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

Go to the top of this page.


See the whatsnew page for last year.

This file last modified Thursday May 21, 2015, 09:32:50


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