Missouri Census Data Center

What's New at the MCDC in 2015

Go to most recent posting(s).

Series of Charts and Maps Depict SAIPE Poverty Data by County

Posted 1-17-2015

We have created a series of modules based on the county level poverty data for 2013 from the latest SAIPE (Small Area Income and Poverty Estimates) data from the Census Bureau. They can be accessed at mcdc.missouri.edu/data/saipe/pov2013charts . We plan to create a custom index page for this directory but in the mean time users should be able to recognize the subdirectory for the state of interest (postal abbreviation as the last 2 characters of the subdirectory name). Each module consists of a short report showing the 12 (or more in a few cases like Georgia and Texas) counties with highest poverty rates, followed by a bar chart of those counties and a chorpleth map. The final graph is a map of all counties in the state showing the poverty rate. These maps will display the county name and poverty rate if you move the mouse over a county. It also supports a drill-down feature so that clicking with a county on the map takes you to a new page: our Applinks page for that county.

New Equivalency Files Relate 2000 and 2010 PUMAs

Posted 1-19-2015

We have created a csv file and SAS data set version of a new equivalency file showing the relationship between the old (2000) and new (2010/2012) PUMAs. We added a paragraph to our All About PUMAS 2010 Edition web page that has descriptions and links to these files.

New Sample Map Displays 2013 Median HH Income for US PUMAs

Posted 1-22-2015

We have created the infrastructure to allow us to do PUMA maps (using the latest 2010 PUMA areas) for any individual state or the nation. To demonstrate the funcationality we have created a demo map that can be accessed at //mcdc.missouri.edu/sasmaps/testmaps/uspumas10/uspumas10.html. This map serves a dual purpose: it shows the spatial pattern of income in the nation, and it provides easy access to the PUMA base maps provided by Proximity 1. To access the latter you just need to click within any state on the map.

BEA Local Area Personal Income accounts Data Updated

Posted 2-04-2015

We have downloaded the latest available Local Area Personal Income accounts from the Bureau of Economic Analysis. Once known as the REIS (Regional Economic Information System) data (but we no longer see this term on their web site) we store these county level economic accounts data in our beareis data directory. There are 11 data sets per state (and 11 more for the US) each containing time series data for a specific topic (income, employment, wages, etc.). The state level data sets have state and county level summaries. The us data sets have nation, state and BEA region data. We plan do do a series of maps and charts based on these data. Watch the MCDC home page for this.

Data Added to kidscnt For 2014 Data Cycle

Posted 2-11-2015

We have done our annual update to the kidscnt compendia filetype. This involves a series of state and county level key indicators related to the well being of children in Missouri. The Kids Count program is sponsored by the Annie E. Casey foundation, and is a national program. But the data collected and reported on for Missouri\ (most of it originating from state agencies, supplented with data taken from federal agencies such as the Census Bureua and BEA) are unique to the state. The key data sets created are the trans2014 and mocomaster2014 data sets. The former contains all of the new cycles of data; it was used as a transaction data set to update the data stored in last year's mocomaster2013 to create the new mocomaster2014 data set. There will be a web site and a publication created by early next year making use of these data.

Presentation Re MABLE/Geocorr at Missouri GIS Conference

Posted 2-26-2015

John Blodgett did a 30-minute presentation regarding the MCDC's MABLE/Geocorr web application . The powerpoint presentation has been added (module mable_geocorr12_2015.ppt) to our tutorials library.

Population Estimates Directory Updates

Posted 3-12-2015

One of the most important data directories within the MCDC public archive is the one where we keep the latest population estimates. About 99% of the data sets in the directory are from the Census Bureau and the great majority are time series sets, where we get a new set of estimates each year. At the end of this month we expect to start receiving the 2014 vintage round of updates. These will be added to the same directory that alreaday includes the comparable data released for many previous years. The problem with this situation is that you wind up with a very large collection of data sets, many of which are of little interest because they have been superceded. For example, the data set containing the 2013 vintage estimates for Missouri counties is call mocom13. It contains estimates not only for 2013, but for all the years beginning with 2010 thru 2013. The data set mocom12 contains comparable data for 2010 thru 2012. While it is true that sometimes these estimates get tweaked over time so that the 2012 estimates released in 2013 may not be identical to the ones released in 2014 (for example), it is generally excepted that once you have the 2013 vintage data you really no longer need the 2012 data.

What we have done is taken all (or most, at least) of the redundant earlier-year estimates data and moved them to an archives subdirectory. This makes them invisible to users and greatly reduces the clutter. So now you will still see the uscom13, ussc13, usstatescasrh13 and ushuest2013 data sets. But unless you explore the archives subdirectory you'll not longer be distracted by the appearance of the uscom12, ussc12, etc. data sets. Less is more.

Once we have processed all the 2014 vintage estimates (usually by the end of July) we plan to archive all the 2013 vintage data sets. Explore the new data directory at http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/popests. The Datasets.html page has been updated to reflect the changes.

Readme File for Population Estimates Directory

Posted 3-16-2015

We have created a fairly detailed Readme file within our popests data directory. This is in preparation for the imminent release of the 2014 vintage estimates beginning on March 26.

New 2014 County and CBSA Population Estimates

Posted 3-26-2015

The Census Bureau released the first set of official vintage 2014 post-censal population estimates today. These are estimates at the state, county, and CBSA (Core Based Statistical Area - metropolitan & micropolitan statistical areas) levels, and show components of change for each year since 2010. The MCDC has a standard way of processing these for each annual cycle. We convert the data and store them in our public data archive. The are five new "com14" data sets (listed on the first five lines of the Datasets.html directory page in the popests data directory. The are two data sets with data for the entire country - uscom14 and uscomcbsas14 mocom14; and three more with data just for Missouri: mocom14, mocom14t (transposed version of mocom14) and mocomregns14 (aggregated to county-based regions such as Regional Planning Commisions).

We also generate a series of standard reports based on these data. To see these go to our Population Estimates page (which has been updated for the new cycle year) and use the link to the Population Estimates Reports page. You should see three lines of the matrix where the Report Data Set column has a value ending in "14". For example, the uscomcbsas14 data set is used to generate a pdf-format report showing the trends for all the CBSA's in the nation.

Something new this cycle is a set of 4-part reports, one per state, consisting of a report, a bar chart, and two choropleth maps depicting key trends in the data. The report for Missouri can be accessed at mcdc.missouri.edu/data/popests/pop2014charts/pop2014mo/charts.html. To view a comparable report for any other state just change the state postal abbreviation in the directory. For example, the report for California can be found at mcdc.missouri.edu/data/popests/pop2014charts/pop2014ca/charts.html . The last page of these reports contain a state-wide county map depicting the percent change in population over the latest year. The map doubles as a menu page to access our poptrends1 (updated to display data through 2014 now) web application. Click within Boone County on the Missouri map and get a report and bar charts depicting the annual change in population for the county going back to 2000. (The charts are in a retro printer format, but we provide links to alternate versions with more modern graphics for those needing something for a presentation.)

If you don't like the idea of having to change a URL manually to see the charts page for a state, we have also created a "menu map". See this at http://mcdc.missouri.edu/sasmaps/menumaps/pctch1yr2014/uscountiespctch1yr2014.html. It is a choropleth map depicting percent change in population at the county level for the nation. If you place your mouse over a county it will display its name and the change/% change in population over the past year. If you click within that county (or any county within that state) it will take you to the charts page for that state.

Enhancements to the poptrends Web Application

Posted 4-07-2015

The MCDC's web application (linked to from the Quick Links navigation box as Population Trend Reports) for generating dynamic population trend reports/bar charts has been updated. There is no new data for now (the 2014 estimates are due this summer) but we have enhanced the application particularly in the area of the generated bar charts. Here is a summary of what's new with the application:

Updates to the Social & Economic Profile Reports

Posted 4-13-2015

We have updated the "cntypage" data sets and reports. These Social and Economic Profile reports were created specifically for UM Extension offices to provide a general overview of key indicators. The reports are generally refreshed two or three times each calendar year as newer data are released. This is the first update applied since July of last year. We now show the latest population estimates and the post-2010 components of change. (Detailed estimates by race and age are not yet available for 2014 but should be by mid summer). The employment and income data from the Bureau of Economic Analysis have been updated by two year (2013 data replacing 2011), and the table on Children and Families ("Kids count" data) have been updated by a year. Finally, our links to the ACS profile reports that deal with data in even more detail have been updated to point to the latest available data. These data and reports are for Missouri counties only. The reports can be accessed from the Missouir County Social and Economic Profile home page. That page provides a link to access the underlying data set using Dexter.

County Business Patterns Data for 2013

Posted 4-25-2015

The Census Bureau released the new annual cycle of County Business Patterns on 4-23 and we now have it in our data archive. Access the new data most easily (via uexplore/Dexter) using the Datasets reference file. We did the usual processing, creating summary data sets at the nation, state, county and CBSA levels. Data at the ZIP code level was not released at this time but it expected shortly.

Note: We discovered a problem with these data sets as initially converted on the 25th due to a new field being added to some of the data files being read. We have corrected the problem (as of 4/28/2015 8:00 AM). We also discovered and fixed a problem with the uscos12 data set.

2012 Census of Agriculture Data

Posted 5-5-2015

The US Department of Agriculture conducts an agricultural census every five years. They have published the results of the latest "Ag Census" on their web site. (See, for example, the page that lets you view profile reports for all Missouri counties as well as the state at b>http://www.agcensus.usda.gov/Publications/2012/Online_Resources/County_Profiles/Missouri/index.asp).

While their web site presents some really nice reports and summaries we still an opportunity for us to present some of the most frequently-used data items at the state and county levels in a format with which many of our users are comfortable. So we have created a new "filetype", ag2012 (now referenced under the "Other" category on the Uexplore home page). It is very similar to what we did with the 2007 Ag Census.

2013 ZIP Business Patterns

Posted 5-5-2015

We downloaded and converted the two ZIP Code Business Patterns files released by the Census Bureau today. We created two additional data sets, usziptotals13 and uszipdetails13. These are comparable to the two uszip*12 data sets created last year, with a new year of data. These data sets can be accessed via uexplore in the CBP data directory.

Access to Population Estimates Charts Modules Enhanced

Posted 5-8-2015

Earlier this year (on March 26) we posted an article to this web page regarding new graphics-based 4-part reports depicting population change over the most recent year using the new 2014 vintage population estimates with components of chanage. We have now completed work on documenting the directory where we stored those modules (some might say, hid them). We have now highlighted the subdirectory (pop2104charts) on the Contents page of the popests data directory. More importantly we have added two new files to help users find and access the new pages:

  1. A Readme file provides explanations of what these modules are about and where to find them.

  2. A Menumap.html file is actually just a pointer file to the module we created (and linked to from a home page article back then) which is a map of the country with drill-down capability for accessing these state-based charts modules.

To see what we're talking about, use Uexplore to access the popests data directory and from that page choose the pop2014charts subirectory. Browse the Readme and Menumap files/pages described above.

Posted 5-13-2015

ACS Time Series Profiles Data Set Updated

We created a time-series ACS data set by basically taking the usmcdcprofiles data set (with 1-year estimates for larger geographic areas) for each vintage year from 2006 to 2013. The resulting data set has over 56,000 observations summarizing around 7,000 geographic areas for the 8-year period. There are some problems with using as time-series since variables can come and go with various releases, and geography can change without any change in the key fields to document the change (e.g. changing over from 2000 PUMAs to 2010, or changing CBSA definitions over time).

To access the new data set go to the ACS data directory and then use the Datasets.html directory page to get easy access to the data set usmcdcprofiles2006_2013 using Dexter.

Posted 5-21-2015

New 2014 Population and Housing Unit Estimates

The 2014 vintage population estimates for sub-county areas (cities, cities within counties, minor civil divisions, etc.) have been added to the MCDC data archive. Access the data for the entire U.S. in the ussc14 data set (via Dexter). If you just want the data for Missouri you can access the mosc14 data set. You can access our entire collection of recent population estimates using the popests/Datasets.html directory page. Note that we have modified the order in which the estimates sets are presented so that all the latest vintage (2014) data sets are presented first. We currently have nine vintage 2014 data sets.

To see two new (for 2014) reports showing fasting growing and shrinking cities in the nation and in Missouri use the Population Estimates Reports index page.

At the same time the Census Bureau also released county level housing unit estimates through 2014. These can be accessed in the ushuest2014 data set (which you can also get to from the just-referenced Datasets.html page in the popests data directory).

Posted 6-4-2015

Missouri acspums Data Updated

A problem was found with the original Missouri data sets with ACS PUMS data for the 3-year period 2011-2013. We inadvertently used the one year input data instead of the 3-year. While we were fixing that basic problem we modified the way we handled the implication of a 2012 PUMA for 2011 surveys, creating a new variable called puma10alt.

Posted 6-10-2015

Census Bureau Releases Preview of New ACS Website

View it at http://www.census.gov/programs-surveys/acs.html?utm_source=censussdc .

Posted 6-24-2015

Blodgett Receives Gustafson Award

The State Data Center national organization presents the Randy Gustafson Memorial Award at its annual conference each year. The award "recognizes a member of the SDC network or a SDC office which has made a significant contribution to the partnership with the Census Bureau or to the SDC network. ".    John Blodgett of the MCDC was the recipient this year, as announced at the virtual conference held in early June.

Posted 6-24-2015

Curmoests.xlsx Updated

The popular Excel file with four sheets summarizing the lastest population estimates for Missouri cities and counties has been updated to reflect the new 2014 estimates. It can be accessed either by using Uexplore in the popests data directory or using a link provided in the Our Best Estimates section of our Population Estimates page.

Posted 6-25-2015

County Estimates by Age, Race, Sex and Hispanic thru 2014

The Census Bureau released these estimates today and they are available for access via Dexter in the popests data directory (look for data sets such as mocasrh14). We have also generated (as per usual) our set of tabular reports summarizing these data at various levels for all states in the U.S. Access these reports from our Population Estimates Reports by State page.

Posted 7-1-2015

Missouri Social and Economic Profiles ("cntypage") Updated

These popular profiles are now fully updated for 2015. In this latest update we added data for race and age breakdwons (from the recently added 2014 vintage "casrh" data); the latest (2014) housing unit estimates; the latest population in small cities (subcounty estimates) and Census of Ag data was updated from 2007 to 2012 with a link to the full county profile at the USDA web site. Best way to access is via applinks or the Missouri County Data Map (which is really just an alternate way to access applinks). The link to the profiles is near the bottom of the menu page (last one under Annula Profiles).

Posted 7-6-2015

Pop Estimates from NCHS Processed

We downloaded and did our standard conversions on the new 2014-vintage population estimates at the county level by age (single years), race ("bridged"), sex and Hispanic origin. These data allow us to get a good handle on various trends in the population at the county level for the entire U.S. These data are used as input to our Poptrends web application. See the next item. These data can be accessed using Dexter at mcdc.missouri.edu/data/popests/nchsbri/Datasets.html. There are two new data sets per state. The first is a very detailed set with one observation for every county-age(single year)-sex-race(4 bridged)-Hispanic combinations; there is no Year variable on this data set but instead there are 6 numeric variables measuring the population for a specific year. The second is a shorter version with one observation per state|county-age-year; the variables are now demographic estimatss (of sex, race and hispanic).

Posted 7-6-2015

Poptrends Web Application Updated With Latest Data

See the previous item. We modified the two poptrends modules (potrends_menu and poptrends) so that you will now have access to the latest (2014) data estimates. Access the application at mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=websas.poptrends_menu.sas&_SERVICE=appdev&st=. (Easiest way to access is via the "Pop Trend Reports" link in the Quick Links box of most MCDC web pages.)

Posted 7-13-2015

Pop Estimates by Age Application Updated

This application produces custom state and county level reports using the latest estimates by age, sex, race and Hispanic with special emphasis on age (allows user defined age intervals). It has been updated to provide acess to the 2014 estimates. The application can be accessed using the Pop Estimates by Age link in the Quick Links box.

Posted 7-27-2015

SAS Web Application Activity Reports

For anyone interested in how often the MCDC web applications (just the ones written in SAS, which is most but by no means all of them as we phase in new apps) we have a pair of reports that users can view on the site. The first (and best) of the two is apphitsfy2014_2015_pt1.pdf and summarizes activity for applications within calendar years (last 6 months of 2013, all of 2014 and first 6 months of 2015) and for the two-fiscal-years totals. It shows, for example, that the geocorr12 web zpplication has been invoked almost 46.000 times over the last 2 years, and average of about 1900 per month. This is almost double the number of Dexter hits (25,155) over the same period.

The second report is apphitsfy2014_2015_pt2.pdf which includes a month-by-month summary of activity -- more than most users will need to know.

Posted 8-04-2015

IRS Migration Data and Web Application Updated

The IRS released new (and improved!) county-to-county and state-to-state migration data for calendar years 2011-2012. The best/easiest way to access these data is via the web application at IRS MIgration Profile menu page. (The Applinks data applications utility is an alternate way to get there; the link to the irsmig profile app is the last one on the applinks-generated page.)

Power users who want access to lots of data (not just focusing on a single county) can follow the link at the bottom of the profile report which invokes our Dexter extract utility with access to the data sets (usinmig1112 and usoutmig1112) containing all these data ready to be queried.

The state level profile data have also been processed and the state-level application updated. We are still working on the new gross migration file. Coming soon.

Posted 8-29-2015

IRS Migration Data and Web Application Updated -Again!

The IRS released another set of migration data based on tax returns for calendar years 2012, 2013. We have downloaded, converted and documented these data in the irsmig data directory, where they can be accessed via Dexter. We have also updated the IRS Migration Profile web application to allow you to choose this latest year.

Posted 9-2-2015

New ACS-based Migration Flows Data

The Census Bureau has released a whole new set of county-to-county and MSA-to-MSA migration data based on the 2009-2013 American Community Survey data. There are over a dozen files for the US (and lots more in state subcollections) but we have so far only downloaded and converted a single county-to-county file showing inflows, outflows, net flows and gross flows based on where the respondent lived one year ago. We then attached CBSA (Core Based Statistical Areas, aka Metropolitna/Micropolitan Statistical Areas, and referenced as "MSA"s in the Bureau's documentation). We assigned them for our county to county data set and then did a custom aggregation to create a data set with comparable data at the MSA level. See the data via Uexplore in the new acsmig data directory. For easiest access and metadata use the Datasets.html directory page.

Posted 9-17-2015

New ACS Data for 2014

The Census Bureau released its new one-year data based on 2014 American Community Survey. These data are comparable to what we have been used to seeing for the last many years of ACS data. The Missouri Census Data Center has downloaded these data for the entire United States (there are only 7,819 geographic entities summarized since an area must have at least 65,000 population in order to be included.)

For complete details regarding this release see the relevant Census Bureau web page . The data can, of course, be accessed using the American FactFinder resource (see our link in the Navy Blue Navigation box).

These data can be accessed via our two ACS profile applications, ACS Profile Reports and ACS Trends Report. The latter is particularly useful for spotting trends over the year.

We have created a brief document with some highlights taken from running our ACS Trends report for the state of Missouri. View these at http://mcdc.missouri.edu/data/acs2014/bulletpoints09_14trends.html.

You can also access the 2014 data used in these reports via uexplore/dexter in the usmcdcprofiles data set in the new acs2014 data directory.

We have also done the usual with the summary tables from this release. These tables can be found (as usual) in the basetbls subdirectory of acs2014. There are the usual six pairs of data sets with estimates and moe measures in separate sets. The six sets correspond to the six topic intervals. For example ustabs00_07 has all tables for subject codes 00 (Unweighted sample counts), 01 (Age and Sex), 02 (Race), ... ,07 (Residence Last Year, Migration). See the TableTopicCodes.txt file.

The companion data set ustabs00_07_moes contains the margin-of-error measures for these same tables. Data from the two sets can be matched (linked) using Geoid as the key, or State and LogRecNo.

Note that we do not keep any data for Subject 99 - Imputation tables. Also tables with a PR suffix will only have values for Puerto Rico geographic areas.

We have generated a new set of Varlabs codebook modules -accessed by following the link to this acs2014/basetbls subdirectory using uexplore. These are what you use to search for a table of interest or to help you interpret and/or postprocess your extracts.

When invoking dexter for these data sets you will be presented a menu of tables rather than variables for your Numerics selections.

Using data from these datailed summary tables we were able to create a document that highlighted some trends specifically related to Missouri's children for the Kids Count project in the state. View these at mcdc.missouri.edu/data/acs2014/bulletpointsKidscount.html.

Posted 10-3-2015

MABLE/Geocorr14 Now Available (Beta)

A new version of our Geographic Correspondence utility application with significant updates to the geographic data is now available in a beta test version. It can be accessed at http://mcdc.missouri.edu/websas/geocorr14.html. Click on "Display Related Links" and then follow the link to "What's New in Geocorr14" (http://mcdc.missouri.edu/whatsnew/geocorr14.shtml).

We recorded a video where we show and tell about the new features. There is a link to it from the (previously cited) "What's New in Geocorr14" page.

Posted 10-5-2015

IRS Migration Profiles for 2013-2014

The IRS Statistics of Income folks have released yet another year of migration data (the 4th release this year). You can now get data based on the residence of federal tax filers in calendar years 2013 and 2014. The menu page at http://mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=websas.irsmig_menu.sas&_SERVICE=appdev&st=29 allows you to select your geographic area (any county or county equivalent in the US) as well as the tax years, with 2013 to 2014 added as the new default.) You will also get the 2013-2014 version of the profile when you access the irsmig profile app via applinks.

And, of course, Uexplore/Dexter users can access the new data sets in the usinmig1314 and usoutmigt1314 data sets.

The state level data and profile app have also been updated. (Rev. 10-6)

Posted 10-12-2015

Problems With MABLE/Geocorr14 Fixed

A problem was discovered in about 10 states in the MABLE14 database used in geocorr14. These were fixed over the weekend. (Problem involved records on the tgrnlnfaces files where census blocks changed states. We had to delete these since they were obviously not 2010 blocks.)

Posted 10-28-2015

John Blodgett did a webinar presentation on Oct. 27, 2015.

Presentation outline at http://mcdc.missouri.edu/tutorials/presentation_outlines/ctpp27Oct15.shtml. The presentation to a national organization of transportation planners (CTPP) dealt with Uexplore/Dexter, our ACS data and MABLE/Geocorr. Included in the outline page is a link to a collection of five video files showing sample uses of Uexplore/Dexter.

Posted 10-28-2015

New ACS PUMS data for Missouri.

We downloaded the just-released 2014 single-year ACS microsample data sets from the Bureau web site. Did standard copy/convert creating new data sets moprecs14 and mohrecs14. We can easily do this for any state or the entire US as needed.

Note: Later, on Dec, 21, we downloaded comparable data for 2011 and 2012 for Missouri.

Posted 11-07-2015

Dexter Supports Wildcard Dataset Access

The MCDC's Dexter query web application now supports the capability of accessing multiple datasets in a single run. This involves the Uexplore user selecting a "model" data set in a collection of like-named datasets and invoking dexter. For example, you could access the dataset alselectedinv in the sf12010x data directory. This is the Alabama dataset and it has 51 "sibling" datasets containing the same kind of information for the 49 other states plus DC and PR. All these data sets are named the same way: SSselectedinv, where SS is the state postal abbreviation. To specify wildcard procesing the user needs to change the value in the data set text box at the top of the Dexter query form. You would edit the value alselectedinv, replacing it with the value __selectedinv, with the two underscores substituted for the postal abbreviation portion of the name. You have told Dexter that you want to process all the data sets in this directory with names that match the pattern specified.
Then code the rest of your query as usual. Some restrictions apply; see the Dexter online help for further instructions/caveats.

Posted 11-10-2015

New BLS Unemployment Data

We have added a new collection of annual average unemployment data for the US, states and counties. (Access via the Datasets.html index page of the bls_la data directory.) For each year there is a usstateavgsYY and a uscountyavgsYY data set (where YY is the 2-digit year). Unlike the previous data in this filetype these data are quite simple and straightforward. Each observation is for one geographic area (a county on the uscounty sets, and either state or nation on the usstates sets) for one year and contains 4 data items, all annual averages: employment, unemployment, civilian labor force and unemployment rate. The datasets (available on our site) are for years 1990, 2000, and 2008 to 2014. More years are available and can be easily downloaded and added per user interest. Users should note that these time series sets can be easily accessed using the new wildcard feature in Dexter to access data for multiple years in one dexer run.

Posted 11-11-2015

New Bank Deposits Data for Missouri

The bank deposits data for Missouri for June 30, 2015 have been downloaded from the FDIC web site and processed per usual (we have such data going back to 1997). These can be accessed in the bankdeps data directory via uexplore/dexter. The new data sets are mobrn15 with branch-level detail, and mocnty15 which is just county and state aggregates of the deposits data.

Posted 11-14-2015

New Dexter Query Shows Access to Later BLS Data Using New Wildcard Access

We have created a new module in the bls_la/Queries directory: wildcard_stateavgs. It shows how you can extract a time series of basic unemployment data at the state level for user-specified years where the data for the specified years are in different datasets.

Perhaps more importantly we have (for the first time) created a corresponding "Notes for .." document file (.doc - MS Word file) that takes you through the extract section by section with screen shots. Access the file from the uexplore directory page at bls_la/Queries.

Update (11-16-15): we have experimented with creating the Notes... file in various formats. We started with .docx (MS Word doc) and then tried converting to pdf format and then to html. While the Word option is efficient and would be very handy for many users, not everyone would be able to read such files. For now, we have all 3 formats out there but the html version is probably going to be the one we'll keep. It takes up the most storage space and generates an extra subdirectory but it will be universally and easily accessible from any browser for any user.

Posted 11-19-2015

Vintage Problem with ACS CAPS (Fixed)

The ACS version of CAPS advertises that the source of the data is the 2009-2013 5-year ACS estimates. Actually we were still using the previous year's 2008-2012 dsta. This has now been fixed.

Posted 11-24-2015

New Queries Module Shows How to Aggregate Detailed Pop Data by Age, Race and Sex

Our Population Estimates by Age web app makes it easy to get detailed state and county level reports of estimated population by age, race, sex and Hispanic origin. But except for Age and Race/Hispanic the application handles the demographic categories separately. You can, for example, get estimates by race and by sex, but not crossed (race broken down by sex). But this kind of cross-tabulation is doable using the nchsbri data available in our public archive and the aggregation features of Dexter. We have created a new sample Queries module within the popests/Queries directory. A corresponding Note for nchsbri_aggbysex.htm module describes in detail how features in the Advanced Options section of the Dexter query form can be used to accomplish a typical task.

Posted 12-01-2015

New Document Re SAS Programs in the MCDC Archive

A new module in our "All About.." series is for those persons who would like to know more about how we code our SAS programs. Useful for viewing the SAS code used to create a data set, and also for those who would like to download and adapt code for their own use. Includes a discussion of three special SAS code libraries (sasmacro, sascode and sasfmats) as well as the modules found in our Tools subdirectories. To access the module follow the All about..." from the navy blue navigation box and then click on the last item in the "Related Modules" section of the All About index page. Or just go to http://mcdc.missouri.edu/allabout/SAS_Code_in_the_MCDC_Data_Archive.doc.

Posted 12-03-2015

ACS Data for 2010-2014 Released by Census Bureau

The new and long-awaited 5-year period estimates based on 2010 to 2014 surveys are now available from the Census Bureau (via American FactFinder, for example). You can also access the data on the MCDC web site as follows:

Posted 12-09-2015

SAIPE Data for 2014

The Census Bureau has released the latest set of data in the Small Area Income and Poverty Estimates series. We have done our usual download and convert of these data. Use the Datasets.html index page for easiest access via Uexplore/Dexter.

Posted 12-10-2015

ACS Profile Extract Assistant Update

We updated the ACS Profile Extract Assistant web application so that it now provides easy access to the E11 sub-table with items related to health insurance coverage.

Posted 12-19-2015

ACS Profiles data set at block group level finalized

We created the final version of the usbgs5yr data set within the acs2014 data directory. We added about a dozen new variables and merged with 2010 SF1 to add some baseline census data. Access via dexter at //mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=websas.uex2dex.sas&_SERVICE=appdev&path=/pub/data/acs2014&dset=usbgs5yr&view=0;

Posted 12-19-2015

CAPS application for ACS Data Updated to Use 2014 Vintage

The caps10acsb web application has been updated to now access the new vintage 2014 (2010-2014 5-year period estimates) data.

Posted 12-23-2015

State and Nation Poulation Estimates for 2015

We have added the latest population estimates for the nation and states with components of change as released by the Census Bureau yesterday. The new data set is popests.uscomnst15 . A report showing some of the key variables as well as their corresponding ranks is available at http://mcdc.missouri.edu/data/popests/Reports/uscomnst.pdf.

We have updated our poptrend1 web application so that it will default to showing data changes through 2015 when you ask for a state level report. To do so: access the app via our MCDC Data Applications Menu - choose the state, hit Show data links, and then choose the application Population Changes Since 2000 in the Annual Profiles section.

Posted 12-24-2015

Geocorr14 Replaces Geocorr12 as Current Version of MABLE/Geocorr

We actually removed the "beta" status on geocorr14 several weeks ago. But today we changed our Quick Links box so that it now refers to the 2014 version. Geocorr12 remains on the system but we won't be linking to it any more and it may eventually disappear entirely, or at least be archived.

Posted 12-31-2015

Geocorr14 Bug Re 2010 CBSA Types

A bug was reported while using the MABLE/Geocorr14 application regarding the value of the 2010 CBSA type field (with values 'Metro'/'Micro'). There were also some other issues with the 2013 CBSA related fields which have been fixed.

Posted 1-6-2016

New Cycle of Data for the beareis Filetype

We have processed the latest economicn time series data at the state and county levels from the Bureau of Economic Analysis. Access these in the beareis data directory. The new data sets contain time series starting in 1969 and going through 2014. (Except there was no update to the wag (wage and salary) data sets. The BEA explained that all the items in this data set were also available in the PRO data sets (economic profile).

Posted 1-6-2016

New Cycle of Data for kidscnt Filetype

We have processed a number of resources (mostly from Missouri state agencies) to create an updated version of the database used in the Missouri Kids Count project. These are preliminary, in the sense that they have not been thoroughly reviewed but most of the programs and resources used have been used for several years. New this year is poverty estimates ...

View other recent news ....

Go to the top of this page.

See the whatsnew page for last year.

This file last modified Monday October 03, 2016, 11:24:01

Site Map    |    Our URL    |   
The Missouri Census Data Center is a sponsored program of the Missouri State Library within the office of the Missouri Secretary of State. The MCDC has been a partner in the U.S. Census Bureau's State Data Center program since 1979.

Questions/Comments regarding this page or this web site are strongly encouraged and can be sent to