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 Pop 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.

Go to the top of this page.


See the whatsnew page for last year.

This file last modified Wednesday September 02, 2015, 11:33:11


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