Missouri Census Data Center

What's New at the MCDC in 2014

Go to most recent posting(s).

New 2008-2012 ACS Data Accessible Via MCDC's ACS Profile Extract Assistant

Posted 1-11-2014

You can now access the latest 5-year ACS period estimates data via Dexter and the ( ACS Profile extract assistant preprocessor app (the second item in our Quick Links menu box). The application makes it relatively simple to specify the geography and profile tables you want to extract.

Of course, what makes this all possible is that we have created the required datbase datasets which the application can access. It is the same application as before, just working with a whole new set of 2012 vintage 5-year period estimates.

New 2008-2012 ACS Data Accessible Via Uexplore/Dexter

Posted 1-11-2014

Similar to prior years we have created an extensive collection of datasets based on the Census Bureau's 2008-2012 5-year period estimates data. In addition to the standard MCDC profile datasets (most of which are accessible using the previously cited Extract Assistant application), we also have a new set of detailed base tables which can be accessed. Access the smaller mcdcpofiles datasets using this URL: http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/acs2012 (or, better yet, use the Datasets.html page within this directory. The new detailed base tables are such a huge collection that they merit their own special subdirectory. Access it at the following URL: http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/acs2012/btabs5yr. Note the presence of a Varlabs directory that can be used to search for and identify the tables of interest. The TableTopicCodes.txt file can help you to find the table-group of interest. (Use it to find out, for example, that the Poverty topic code is 17, so you can see the outlines of all available tables dealing with poverty in the file Varlabs/17_20labels.txt).

New 2008-2012 ACS Data Available for Circular Areas

Posted 1-16-2014

A version of the MCDC's CAPS web application for generating reports for circular areas (i.e. based on user-specified point and radius parameters) is now avaiable for use with the new 2008-2012 ACS data. To access it, use the trial version page at http://mcdc.missouri.edu/websas/caps10acs2012.html . This will change on Jan. 27 when we plan to replace the old version (which worked with 2007-2011 data) with this new one (at which time you can use the usual (current) link to the application - http://mcdc.missouri.edu/websas/caps10acs.html .

New Readme File for the acs2012/btabs5yr Directory

Posted 1-21-2014

We have created a new Readme.shtml file for our collection of custom 5-year period estimate base tables. We mostly copied the corresponding file from last year (in acs2011/btabs5yr) but did note some changes for this year. Such as going back to our standard table-variable naming convention using "i" before the cell number, instead of "e" (for estimate) as we did with the 2011 vintage tables.

New 2012 SAIPE Data Downloaded and Added to Archive

Posted 1-23-2014

The SAIPE (Small Area Income and Poverty Estimates) data (Census Bureau) was downloaded and converted for the data archive. These data were released in December of 2013. Conversion and data set naming conventions have not changed for several years now. We simply added another set of data to the time series. The new data sets are usstcnty2012 and usschldst2012 (new data for the entire US just for 2012 and at the nation-state-county and school district levels, respectively. The corresponding Missouri-only subsets are the same, just change the "us" prefix to "mo". The corresponding "20xx" data sets (i.e. usstcnty20xx and uschhldst20xx) have the new data as well as data for all other years going back to 2000. The Datasets.html index page with metadata has been updated and is the easiest way to access the data. You can also access it the old-fashioned way via uexplore on the saipe data directory. See the SAIPE web site at the Census Bureau for background information regarding these data and for access to an interactive data tool for viewing the data.

New Queries Module Extracts an ACS Base Table for All Tracts in Several States

Posted 1-23-2014

Inspired by a data user who was needing such data we coded a Dexter sample query showing how you can extract a specified ACS base table for all the census tracts in 3 selected states. Of course, you could just as easily do it for just one state, or for all states; or for a different level of geography such as a county, ZCTA or PUMA; or for multiple tables, if needed. The sample query is stored as a web page in the Queries subdirectory of the btabs5yr of the ;latest ACS data directory (/pub/data/acs2012). The module is mnemonically named OneTable4StatesAlltracts.html . A key feature of this example is that it illustrates how you can select tables and the corresponding MOE variables by using the "3rd way" to select variables in Section III of the Dexter Query Form. This entails entering the names of all the varibles you want in a text box and taking advantage of the variable interval notation. This turns out to be much easier than finding and selecting all 346 (173 estimates and 173 MOEs) variables (base table B23001) off a monster select list.

MABLE/Geocorr12 Updated To Fix Missing PUMA 2000 Codes

Posted 1-27-2014

A problem was reported related to the old PUMA 2000 codes. There were a few blocks where no such code had been assigned. We were able to trace the problem back to a step where we built a bridge file linking 2000 and 2010 census blocks. A small number of 2010 blocks were not linked to any 2000 block using our algorithm (which was based on data from the blkrel10 block relationship files). We tweaked that code, so that any block not matched would be assigned the same puma2k code as the preceding block if it were in the same county. The data base was updated today 1-27-2014, circa 7:30 AM CST.

New ACS PUMS Data for 2010-2012, Missouri and Entire U.S.

Posted 2-13-2014

We have downloaded the two 3-year ACS PUMS SAS data sets for Missouri into the acspums data directory (data sets mohrecs123yr and moprecs123yr). Note also the ACS2010-2012_PUMS_README.pdf file which contains news regarding the way PUMA codes are being handled on these data sets. This is the first multi-year ACS PUMS file released since the Bureau started using the revised 2010 PUMA codes (aka "2012" because they were not readily available or used in the ACS data until vintage year 2012). Basically, they give us 2/3 old 2000 codes and 1/3 new 2010 PUMA codes. Which means you really can't do much at the PUMA level with these data sets. This sets the precedent so that we should expect the same thing to happen when the 2008-2012 5-year ACS PUMS data are released next month.

We have also downloaded the collection of 8 data sets containing the latest 3-year (2010-2012) ACS PUMS data for the entire country. Because of the size of this data collection the Bureau distributes it in 4 state-interval subsets. These are identified with a single alpha suffix code a thru d, where "a" sets contain data for the states of Alabame thru Hawaii, "b" meaning Idaho thru Mississippi, "c" Missouri thru Oregon, and "d" indicating data for Pennsylvania thru Wyoming.

The datasets as distributed have 2 PUMA variables called PUMA00 and PUMA10, only one of which contains a value for any observation depending on the year of the survey response. We were able to create our own new PUMA variable which has the same value as PUMA10 for 2012-vintage responses; for earlier responses we attempted to impute a value of PUMA from the value of PUMA00 by doing a table lookup. Turns out that about 37% of all 2000 PUMAs have a 1-to-1 correspondence to a 2010 PUMA. Our table lookup identifies those cases and makes the assignment of the equivalent 2010 PUMA.

Addendum posted 2-19-2014 .

(Some additional detail in response to questions we got regarding what we talked about in the previous paragraph.)
We used our MABLE/Geocorr12 geographic web application to generate an equivalency file showing the relationships between 2000 and 2010 PUMAs for the U.S. We saved the results as a
tab-delimited file as well as the usual SAS data set that can be accessed via Dexter. We also created a special lookup table in the form of a SAS format code, $pma2k12, which is what we used to assign values to PUMA10 based on the values of PUMA00 in some (about 37% as mentioned above) observations on these new 3yr acspums data sets. The entries of this lookup table represent PUMA00/PUMA10 combinations where at least 98% of the 2010 population of PUMA00 was contained in PUMA10, and conversely at least 98% of the 2010 population of the 2010 PUMA was contained in the 2000 PUMA. So, for example, there is this entry:


This says that PUMA Code 01701 in state 29 (Missouri) corresponds to PUMA 2010 code 01801. It turns out this is one of eight entries in a row that have equivalents across the decades. These 8 PUMAs are all subareas of St. Louis County, MO; so if you are someone doing research on that county you are in luck - you can do analysis using the new 3yr acspums data set and have PUMA10 filled in for all the observations, not just the (approximately 1 in 3) observations based on 2012 surveys.

New Thresholds in caps10c Application for Choosing Geographic Units

Posted 2-17-2014

We ran into a fairly bizarre case of running our caps10c (Circular Area Profiling System, 2010 Census version) where we were able to generate data for a .5 mile radius of a point, but not for a 4.4 mile radius of that same point. We discovered the curious case that we had dozens of census block centroids that were in the circle but NO block group centroids. To fix the problem we changed our thresholds in the caps10c application: we now use 6 miles as the threshold for using blocks; and, while we were at it we also raised the threshold to start using tracts instead of BGs from 20 to 30.

New IRS Tax Returns Summary Data by ZIP and County

Posted 2-19-2014
Updated 3-3-2014

We have created a new filetype, irstaxes, containing data from the IRS summarizing tax returns for 2011. We have created four national files with ZIP code and county level summaries of returns, with and without gross income category breakdowns. These data sets are basically as received, with variable names corresponding to those used in the provided layout file, and with no derived variables such as means or percentages.

We have now (circa 2-26) created a set of four enhanced data sets based on the original four created by reading the data as delivered. These "plus" data sets contain all the variables from the original files, but most have been assigned new, more mnemonic names. For example, the variables N00200 and A00200 contain the number of returns reporting Salaries and Wages and the total amount of salaries and wages, respectively. On the "plus" data set these variables are now Nwages and AmtWages. In addition, we have added three new variables to help describe the item:

  1. PctWithWages: indicates the percentage of returns that reported Salary & Wage income.

  2. Avgwages: indicates the average amount of salaries and wages reported, using Nwages as the denominator.

  3. AvgTRwages: indicates the average amount of salaries and wages reported using TotRtrns (total returns) as the denominator. Note that this figure is in dollars, while the AmtWages variable is in thousands of dollars.

This same pattern of renaming and assigning the percentage of all returns and the two average figures are assigned to each return line item.

New Government Finance Data

Posted 3-3-2014

The Census Bureau publishes data annually regarding aggregate revenues and expenditures at the state and nation levels. Data are also reported for the aggregate of all local governments with the nation or state. We have downloaded these data for 2011 (latest available) and 2006 (to allow viewing 5-year trends) and have created a new filetype, govfin . These datasets have a very simple structure, each observation representing a line item by state/nation and and level type (state, local, or state+local). We have added an ItemDesc variable (Item Description) that contains the meaning of the ItemCode variable.

We are doing this on an experimental basis. Let us know if you find these data useful and/or would like to see more years of data.

New Default Version of ACS CAPS

Posted 3-4-2014

We have copied the current default version of the CAPS application for ACS data to caps10acs2011.html . It has been edited to reference the fact that it is not the latest version of the data and has a link to the current (latest data) version. The latest version is still caps10acs2012.html and it has been edited to provide a link back to the previous version. Most importantly, we have deleted the caps10acs.html file and replaced it with a soft link which now points to caps10acs2012.html. So when a user goes to the default caps10c version and sees the link to the ACS version that link now takes the user to the latest version, per the soft link.

Sample Queries for New irstaxes Data

Posted 3-11-2014

We have created a new Queries library for the irstaxes filetype. There are three sample queries, one of which actually invokes Rankster directly instead of Dexter. It produces a report (which we saved and you can access without having to run the query) showing the 40 wealthiest ZIP codes in every state (based on averaged Adjusted Gross Income values).

The transpose_states sample query shows how to use the transpose capabilities of Dexter to create an output report/file with the variables as rows and geographic areas (5 selected states in this example) serving as the variables.

Enhanced Readme.html Page for 2010 Census

Posted 3-17-2014

See the revised overview at http://mcdc.missouri.edu/decennial-census/2010.shtml (or follow the link labeled 2010 Census in the Navy Blue Navigation Box (at left of most mcdc pages). We have added descriptions and links for our SF1-based profile applications.

Cycle Update for the Missouri Social & Economic Profile Report

Posted 3-17-2014

We have modified the Missouri Social and Economic Profile Report beta test version to reflect recent data additions and especially to upgrade the links pointing to the latest available data from the American Community Survey (ACS). We have not yet created a corresponding set of narrative profile versions of the new data. We plan to do so in the summer, after the new round of population estimates for 2013 are made available.

As the title implies, these reports are for Missouri counties only. Easiest way to access them is old home page - www.oseda.missouri.edu/countypage/county_seir.shtml - click on any of the "Data Tables" links (which takes you to an old 2009 version for now - we plan to change that soon) and then follow the link at the top of that report page to the"new beta test version". You can also access the profiles via our Applinks application, which for Missouri counties is most easily done using the Missouri County Data Map, accessible via our Quick Links navigation box (on right of this page). You just click on your county, and when the application links menu page for that county appears, look for "MO Social and Economic Profile" in the Applicaiton/Link column. When the report appears click on the "here" link at top to get the new beta version. Note that data for the state (totals) are included for comparison on each report.

Small Area Health Insurance Estimates (SAHIE) Data for 2012

Posted 3-18-2014

The recently released data estimates, now based on ACS data, for 2012 have been downloaded and converted. These are the same kind of data and in the same format the Bureau has been using since 2008. We store these data together with the SAIPE (Small Area Income and Poverty Estaimtes) data) in the saipe data directory. The raw downloaded data are in the sahie12all.txt file, while the data for the entire US are stored in the sahie12all and sahie12totals data sets, with mosahie12 stored as the Missouri subset of sahie12all. Easiest access is via the index page, Datasets.html. Learn more about these data sets and view highlights (maps and pdf files) at the Bureau's SAHIE data web site.

MCDC Home Page Features Article re new IRS Taxes Data

Posted 3-18-2014

We posted a rather extensive article describing this important new economic data source. Complete with links and snapshots of outputs from some of our several sample queries. Plans to do thematic maps based on these data are underway.

New All About 2010 PUMAs

Posted 3-22-2014

See the new puma2010.shtml page with lots of information regarding the revised Public Use Microdata Areas, 2010 update. Companion piece to our earlier page that dealt with the 2000 edition of this important geographic level.

MCDC Home Page Features Article re new IRS Taxes Data Completed

Posted 3-24-2014

As promised in the article as posted earlier this month, we have completed creating some thematic maps and the corresponding Queries modules that were used to generate the data used for those maps. We also added a brief testimonial regarding the data resource from the Maryland State Data Center. [On 4-3-14 this article was moved to this oldhome page.]

Census Bureau Releases New County Estimates With Components of Change

Posted 3/27/2014

This is the first in a series of three major sub-state estimate products to be released in the first half of this year. The key item in this set is the 2013 estimated total population for each state and county. (The state figures have actually already been published back around New Years but they are repeated here.) The data are also reported for CBSAs (Metropolitan Statistical Areas and Micropolitan SA's). These figures contain annual estimates (starting with July 1,2010 and going through July 1, 2013) and report components of change (births, deaths, migration) for each year since 2010 plus the 3-month period April-June, 2010. These data are stored in a series of data sets within the popests data directory, and the Datasets.html file for navigating though those sets has been updated to reflect the 5 new data sets (mocom13, mocom13t, uscom13, uscomcbsas13, and mocomregns13). Follow the metadata links in Datasets.html for details. They are all the same as last year but now with data for (or through) 2013 rather than 2012.

We have updated the poptrends1 web application, best accessed using applinks. We have a link to the Applinks master menu in our Quick Links box. For those interested just in Missouri we recommend using the MO County Data Map link, also in Quick Links. Would you like to see these reports and charts for every county in the state? Just replace the value of the &co parm with the word all instead of a county code. For example the URL
results in a rather long report showing basic pop trends (no component detail, just total pops) for each county in Missouri going back to 2000. Change the value of the &st parm if you want it for a different state (e.g. &st=06 will generate a report for California counties.)

We have updated our Population Estimates page to reflect what's new. That page contains a link to the Reports library (bullet item 3 under Our Best Estimates), with new reports for Missouri and the nation at the county and CBSA (metro area) levels.

Access the data as released by the Census Bureau at their Population Estimates main page, under Latest Releases.

Updated Social and Economic Profiles for Missouri Counties

Posted 3/31/2014

These popular reports have been updated to reflect the latest population estimates with components of change which we recently added to our data archive. We also created a new directory with updated narrative profiles for each county. And, finally, we created a new master menu page which can be accessed at http://www.oseda.missouri.edu/countypage/county_seir14.shtml . We have made this revised version of the "cntypage" web application the default version (it was previously the 2010 version with data no later than 2009). If you choose this applicaiton from an applinks menu page it will now take you directly to the latest version with the most up-to-date data.

New MCDC Home Page Features Article Re New 2013 Pop Estimates

Posted 4/3/2014

The article features a report produced by our poptrends1 web application showing a trend report for the state for the last 13 years. It also produces a 9-bullet list of interesting trends related to Missouri's population as extracted from the new mocom13 and uscom13 datasets (and one item using mocomregns13). The previous home page article related to the IRS Tax summary data files was moved to the oldhome directory.

Bug Fixed in irstaxes Enhanced Data Sets

Posted 4/10/2014

A problem was found and fixed in our "plus" data sets in the irstaxes data directory (see earlier entry here). The IRS reported 0 values as .0001 (see footnote 2 in the tech doc). So variables that appear to have a value of 0 (for both the N returns and A amount reported values). This caused the Avg values on our "plus" data sets to have a value of $1,000 which makes no sense. The Avg value for an N of 0 is missing. We have rerun our conversions for the plus data sets and the Avg variables are now correct. We also replaced all of the .0001 pseuo-values to zero. The original data sets still contain the .0001 values as distributed by the IRS. We also updated the metdata modules to alert users to this situation.

IRS Releases 2010-2011 Migration Data

Posted 4/23/2014

The IRS Statistics of Income division recently posted this notice on their web site:

State and county migration data for 20102011 are now available on Tax Stats. Migration data for the United States are based on year-to-year address changes reported on individual income tax returns filed with the IRS. The data present migration patterns by State or by county for the entire United States and are available for inflows (the number of new residents who moved to a county or State and where they migrated from) and outflows (the number of residents leaving a county or State and where they went).

The Missouri Census Data Center has downloaded and converted these files, storing the results in the irsmig data directory. The data sets are a little different from earlier editions. Variables TotalHHIncome and AvgHHIncome are now called Aggr_AGI and AvgAGI, for example. Median and Per Captita income variables have been dropped.

The web application for generating IRS Migration Profile reports has been upgraded to recognize the new year of data. Access this application at the IRS Migration Profile menu page (for single counties, anywhere in the U.S.).

The two state-level irsmig data sets, usstateinmig20xx and usstateoutmig in the irsmig directory have also been updated, with the new year of data (2010-2011 based) added. The variable names have also changed consistent with the county names (to aggr_agi and AvgAGI). The web app to display state-to-state migration profiles has also been updated.

Problem Found with irstaxes Data

Posted 4/27/2014

We have been alerted to bad data in at least some of our recently posted irstaxes data sets. We know that the data for ZIP codes and all returns (no AGI intervals) are wrong. The problem occurs in the original csv file used to generate our data sets. We have downloaded the current version of the file we orginally downloaded on Feb. 18 and have found very significant differences in many of the data items. We are running Proc Compare and generating reports to document the scope of the discrepancies as we await word from the IRS regarding what may have gone wrong. We hope to have revised data up by the end of the week.

Problem with irstaxes Data Fixed

Posted 4/30/2014

We downloaded fresh versions of the four csv files used to create our irstaxes data sets. Two for ZIP codes (with and without AGI-interval detail) and two more for state and county levle data. We found no problems with the county level data, although we had to do considerable work to verify thus since we had no response from the IRS regarding any known problems with the data. Bottom line is that we have rerun all our conversions using the latest raw data and hopefully all is well.

MCDC Sitemap Page Updated

Posted 5/5/2014

A signficant update was applied. We removed some old stuff, added some new and fixed some broken or out-of-date links.

SF1-based 2000 Census Profile Application

Posted 5/6/2014

The dp1_2k profile report application was failing because of a problem looking up a base map for small area geography. The accessed data set had been moved and we are working on an update. A temporary fix allows the profile to now generate a report but without the link to a base map containing the area being profiled.

Problem With Labeling of Housing Tables in the ACS Profiles

Posted 5/8/2014

We discovered labeling problems with the first two detailed cells of the H3 and H4 tables within the MCDC's Housing profiles (2012 vintage). The year intervals shown as "2000 to 2004" and "2005 or later" should actually be "2000 to 2009" and "2010 or later". We hope to have this fixed shortly.

Problem With Labeling of Housing Tables in the ACS Profiles Fixed

Posted 5/10/2014

The problem described in the previous article has been fixed. It was also an issue in our caps10acs web application, which was not working on Friday, May 9. That has now been fixed as well.

New Version of CAPS with ACS Data

Posted 5/20/2014

A new version of our caps10acs web applicaion is available for testing at http://mcdc.missouri.edu/websas/caps10acsb.html . The biggest difference between the two versions is that we now support circles of any size (previously we had a minimum of 2 miles), and we now use data at the block group level for circles of less than 3 miles. This is a beta test version, so use it with caution and please report any problems you encounter using the application.

City Population Estimates Processed

Posted 5/22/2014

The Census Bureau's vintage 2013 population estimates for cities and other sub-county governmental units went public today. The data can be accessed on this site in the popests data directory via uexplore/dexter software. We have also generated the usual two standard reports (in the (Reports subdirectory of the popests data directory. They show the fastest and slowest growing cities within their respective universes (Missouri and the US). Excerpts from two of the reports are currently being displayed on the MCDC home page;.

The Bureau also released the 2013 vintage housing unit estimates at the state and county levels. We have also downloaded and processed these, creating the ushuests2013 and mohuests2013 data sets.

ALPS: Address List Processing System

Posted 6/2/2014

ALPS at this point is a set of template setups in a new directory with modules (SAS programs) that can process address-list files, i.e. files where the rows (observations) correspond to street addresses (or other point locations). These files may already be geocoded (i.e. assigned latitude, longitude corrdinates and/or geographic codes to identify where the address is located) or not. A geocoding service is offered as part of the ALPS package. Input will normally be a csv (comma separated value) file, with certain required fields. If the file needs to be geocoded then the input needs to contain detailed address information, including city, state and ZIP code. If the file is already geocoded then it needs to contain fields with the latitude and longitude values assigned. A single numeric ID field is required to allow us to identify your cases (we can assign these codes based on any combination of fields on your input file for a small additional fee.) A field identifying the state (2-character FIPS code or postal abbreviation) is not required but recommended. ALPS will read these csv files and convert them to standarized data sets, and then will invoke various modules to enhance the records by the addition of various data enhancements. If, for example, your already-geocoded file contains 2010 census block codes (including state, county and census tract) then we can add additional geographic codes (using our 2012 vintage Master Area Block Level Equivalency - MABLE - database, as used in our MABLE/Geocorr12 web application). You can append codes such as 113th CD, 2010 PUMA, place (city), county subdivision (town or township), UA, CBSA, Urban/Rural, state legislative districts, etc.

Perhaps the most important and unique feature of the system is its "batch CAPS" processing capability. The output from this module corresponds to the kind of data you can have displayed (and saved as a csv file) by running our latest version of CAPS (see CAPS - ACS Version) . Access to 2010 SF1 profile data will also be offered if there is sufficent user interest, but we think most users will want the more current and more interesting American Community Survey-based data.

If, just for example, you have a file with 500 potential sites for your new school/prison/restaurant/day care center, etc. you can now look at 3 and 5-mile radius data for all 500 in a single data set, which you can then analyze to your heart's content. The system can handle up to 3 radii, ranging from 1 mile to 100, and can handle any number of point locations from anywhere within the U.S. (for example, we are currently working on a sample case that involves 20,000 addresses and 3 radii). Output can be in any of three standard formats: csv file, dbf file, or SAS data set. These, in turn, you can readily turn into Excel files, SPSS system files, etc.

ALPS is (will be) a fee-based custom service. You will need to contact us (at blodgettj@missouri.edu, for now) and provide us with your input address file and specs for the exact kind of processing you need. We can be very flexible in this regard. The fee structure has yet to be finalized but if you would like to get in on the ground floor we are ready to offer some introductory specials.

We are working on a more formal and detailed description of the system, including capabilities and pricing. We will post a notice here (and on our home page) when that is ready.


Posted 6/11/2014

We have created a new Excel workbook version with all the latest city and county estimates for Missouri through 2013. Note that we have gone to a more current version of Excel file (filetype extension is now xlsx instead of the old xls. You may need to upgrade your version of Excel.

County Business Patterns Data

Posted 6/19/2014

We have completed processing the latest (2012 vintage) county business patterns data, which includes ZIP business patterns data as well. We used the same scheme for organizing and naming the data sets that we have been using for over 10 years. Access the new data sets via uexplore looking at the cbp data directory (look for the icons next to these just-added data sets). You can also use the Datasets.html page to assist you in accessing these data. For background information and access to online data access tools see the Census Bureau page related to this data release.

Contents File for irsmig Filetype Updated

Posted 6/19/2014

We received a query from a user asking if we intened to make the latest (2010 / 2011) IRS migration data available on our web site in the data archive. We actually processed these data back in March and advertised them as being available. We updated the Datasets.html file in the /pub/data/irsmig data directory and pointed user to this page as a way of accessing the collection. But what we failed to do was to update the Contents file in that directory so that the new files would appear when the user navigated to the irsmig directory using uexplore. So have have rectified that situation, and even added some extra descriptive material and highlighting of the most recent files (they will not be flagged with a "New" icon because they have already been out there over 45 days.)

ALPS Product Description

Posted 6/23/2014

We have created a preliminary description of the ALPS product at http://mcdc.missouri.edu/products/alps_product_description.shtml.

New Population Estimates Reports

Posted 6/24/2014

We have added two new reports to our standard population estimates report collection at http://mcdc.missouri.edu/data/popests/Reports/. They are actually reports we have done in the past but now have renewed for the new decade. These include the group quarters/ households population report by county, and the "Change in Change" report for cities showing the places with the largest momentum shifts between the most recent two years.

New Population Estimates Data/Reports (embargoed)

Posted 6/24/2014

We downloaded the 2013 vintage population estimates for counties by age, sex, race and Hispanic origin. These are embargoed until tomorrow. We did a test conversion and have our code ready to go in the morning when we shall do the full conversion (a bit of a monster processing step) and should have our data sets and usual reports available by mid-morning on the 26th. That's the plan, at least.

New Population Estimates Data/Reports (now publicly accessible)

Posted 6/26/2014

Our processing of the 2013 vintage "casrh" (county estimates by age, sex, race and Hispanic origin) has been completed and the data made publicly accessible. You can access any of the 51 XXcasrh13 data sets in the popests data directory.

The standard set of reports based on these data have been generated and can be accessed most readily by using the Population Estimates Reports by State web app. (This application is referenced under bullet item 4 in the Our Best Estimates section of our newly updated Population Estimates home page).

Bridged Race Estimates from NCHS for 2013 Added to Data Archive

Posted 6/30/2014

The National Center for Health Statistics at the CDC has published their 2013 vintage population estimates for U.S. counties by single years of age, race (4 "bridged" categories), sex and Hispanic origin. We have downloaded and converted these data, storing the results in the nchsbri subdirectory of the popests data directory.

Population Estimates by Age and Poptrends Applications Updated

Posted 6/30/2014

The Population Estimates by Age web application has been updated to now report the latest (2013 vintage) estimates data as just released by the NCHS (see previous note). Similarly, our Poptrends application, which also uses data based upon the latest NCHSBRI numbers has been updated to include intervals ending in 2013 instead of 2012.

Missouri County-Based Regions

Posted 7/3/2014

The MCDC and OSEDA have routinely maintained reference information regarding a number of county-based regions in the state. These include RPCs (Regional Planning Committees [or Councils, depending on the RPC]), MoDOT planning districts, DED economic development regions, Area Agency on Aging Regions, and the latest CBSAs: Metropolitan and Micropolitan Statistical Areas. Also University of Missouri extension regions. The file/data set that served as the offical source of information regarding what counties comprised each district has been mocogeos, stored jn the georef data directory. That has now changed.

The new official source of region definitions on the MCDC web site is the new mocogeos14 data set. As the name implies, the codes in this data set are, for the most part, vintage 2014. The only exceptions are the UMX extension district codes which are still vintage 2010 and the msa2k codes which are, of course, vintage 2000.

But what is really new is a new set of reports and maps corresponding to the six primary region types defined by the data set. These come in the form of .gif map files and .pdf report files, accessible in the new mocogeomaps subdirectory of the georef data directory. Notice the index.html file in the directory: use this for easier access to the six map and six report files. The other file (not referenced from the index file) is called gmaps.html and contains all six of the map files in one. Here is a sample of the DED Economic Regions printable report and the corresponding map:

Puerto Rico Now Supported by CAPS10C App

Posted 7/7/2014

We added data sets prblocks and prbgs150 to the sf12010x data directory. This makes it possible for the caps10c program to process data for PR. The data set does not have the usual estimates for the 2000 census pops, but otherwise looks the same.

Final Update of Missouri Social and Economic Profiles for 2014

Posted 7/7/2014

The Social and Economic Profile reports (accessible at b>http://www.oseda.missouri.edu/countypage/county_seir14.shtml were updated to contain the latest population estimates at the sub-county level and for age and race/hispanic detail. This completes the 2014 data cycle. The next update will be in the spring of 2015.

Update to ZIP Code Master Data Set

Posted 7/23/2014

The zcta_master data set in the georef data directory is an important reference resource for anyone working with ZIP codes and/or ZCTAs. It focuses primarily on geographic aspects of these elusive geographic entities, helping the researcher know what other geographies can be linked to a ZIP code. For example, what county or counties intersect the ZIP code area, what metropolitan area(s), what ubanized area(s), what place(s), what PUMA(s), etc. The data set also contains about 25 key socio-economic measures from the latest American Community Survey data. There were two reasons we decided to update this data set:

  1. We did not have the most recent ACS data. We were using vintage 2011 ACS data and now we have 2012 vintage data (5-year estimates, 2008-2012).
  2. We wanted to provide information regarding secondary states associated with the codes. This is for those 103 ZIP/ZCTA codes that serve more than one state. You will now see a secondary state identified when a ZIP crosses into a second state.

New web application: display_zctamaster

Posted 8/02/2014

We have developed a web application that lets you display the zcta_master data for a specified ZIP code. Just type in a ZIP code and hit Enter to get a report telling you the state(s), county(s), place(s), PUMA(s), metro area, congressional district, etc. You will also see about 25 key indicators for the ZCTA based on the latest (2008-2012) ACS data. Access the application at websas/display_zctamaster.html .

New irstaxes Data for Tax Year 2012

Posted 8/06/2014

The IRS has released a new set of tax return data for tax year 2012. We have downloaded these data sets, containing summaries of individual income tax return data at the ZIP code and county levels. They have bee converted and enhanced for the archive. The data are very similar to the 2011 data that we first made available in the early spring of this year. Access the data in the irstaxes data directory using Uexplore. There have been some notable changes in how these data are reported starting with 2010. These are documented in the two Word doc files in the directory.(12zpdoc.doc and 12incydocguide.doc). For example, all the number of return items on the ZIP files have been rounded to the nearest 10. It may be difficult to do detailed trend analysis on these data because of these changes.

New web application Helps Estimate ALPS Fees

Posted 8/07/2014

You can now You can use our ALPS Geoservices Cost Estimates web application to assist you in estimating the charges for an ALPS project. A link to this application is now included on the ALPS Product Description page (which has also undergone some minor editing).

Taxable Sales Data for 2013

Posted 8/14/2014

We have added the latest (for tax year 2013) taxable sales data from the Missouri Dept of Revenue. These reports/data sets show taxable sales for the state or county (the state totals are on a separate file and data set) for SIC-based industry classifications by quarter and with annual totals. This continues a time series we have going back to the year 2000. We have modified the Details metadata entries for these data sets to alert users (in the Notes section) of the possibility of overriding the format codes used to display the Sales figures in these data sets so that you see values that are not rounded to the nearest $000.

MABLE/Geocorr12 Web Page Modified

Posted 8/21/2014

The current MABLE/Geocorr12 was given a minor style update. It is now slightly less ugly than before. We also fixed a small problem in the geocorr12 program so that it now provides the names of the 3 newest county equivalent areas in the state of Alaska.

Census Bureau Gazetteer Files Added to Data Archive

Posted 9/15/2014

The Census Bureau Gazetteer Files provide basic geographic data regarding congressional districts, places, counties, county subdivisions, census tracts, American Indian areas, school districts, state legislative districts, urban areas, and ZIP Code tabulation areas (ZCTAs). They are available for years 1990, 2000, 2010 and 2012 thru the most recent (usually current calendar) year. We have thus far downloaded and converted the data for 2010, 2012, 2013 and 2014.

Access these data via Uexplore/Dexter in the new gazteer data directory. (To access via the Uexplore home page look under the Geography/GIS major category.)

American Community Survey Data for 2013 Released

Posted 9-23-2014

The Census Bureau has released the first wave of data products based on the calendar year 2013 surveys. These data are for larger geographic areas of at least 65,000 population. The 3-year (2011-2013) data are due to be released next month and the 5-year estimates (2009-2013) in December. See an example profile report using the new data or access our ACS Profiles web app and choose 2013 from the Select Period drop down. Note, of course, that we have these data for the entirey country.

We have created a new "filetype" (/pub/data subdirectory), acs2013, We have processed the single-year estimates, creating the "best of" profile data set, usmcdcprofiles. The detailed base tables are also available in the basetbls subdirectory.

New Home Page Focuses on Accessing New ACS Base/Summary Tables

Posted 9-29-2014 (rev. 10-8-14)

Screen shots accompanied by explanatory text lead users through the process of accessing these tables using Uexplore/Dexter. Available on the MCDC home page (on that page for a limited time only, then archived in our oldhome directory as file asof092214 .

Updates to Uexplore/Dexter Home Page

Posted 9-29-2014

The updates to our Uexplore/Dexter home page include a new order within the Major Cateogry Index (teal blue) box, where we have moved American Community Survey to the top and provided direct access for specific ACS vintage collections, while moving the Decennial Census Data links to the bottom of the box. This reflects the new relative importance of these two key data categories.

In addition to minor cosmetic changes, the other significant change has to do with the "Important Note" paragraph that used to appear at the bottom of the page with a link to it at the top. The paragraph was basically a warning to would-be users of the technical nature of the application which made it unsuitable for the casual user. We have kept the concept of alerting the user to the nature of the resource, but have created a separate file that we still link to from the top of the page. We have tried to make the new document more detailed and explicit in terms of who should probably NOT be trying to use these tools, as well as creating a new parallel bullet list of characteristics of those whom we feel would be the most likely to reap benefits from the application.

2010 Census Data for 2012 Geographic Units

Posted 10-6-2014, revised 10-8-2014

We have created a series of state-based data sets in the sf12010 data directory containing complete sets of P(erson) and H(ousehold) tables for four basic new geographic units. The new units are

We also have created summaries for the county portions of the CDs and SLDs. We used our MABLE12 geographic equivalency file to associate every 2010 census block on our 2010 SF1 tableto files to these new geocodes and then aggregated the results by the new geographic units. We created 51 new data sets, one per state and the District of Columbia. A typical data set is mocdsldspumas2012 containing the new data for the state of Missouri. For now, we are just generating the basic P and H tables; we are not generating any PCT or HCT tables, since we do not have those at the census block level and doing an allocation would be more difficult and less reliable since we could have to do some disaggregation.

These new data sets will now allow users to look at some basic demographic trends between 2010 and the latest ACS data tabulated to these geographic units. You still won't be able to get trends on "long form" data such as income, employment, and educational attainment, but you will for basic items such as age, race, sex, Hispanic, and household types.

A corresponding set of standard extracts with the same data set names have been created in the sf12010x directory. We have updated our SF1 standard extract web application to allow selecting these new geographies. (This application does not currently support within-county summary levels - just the 4 complete geographic levels: 500 (113th CD), 610 and 620 (redrawn by 2012 state legislative districts) and 795 (2010 PUMA - aka "2012" PUMA).

If you would like to look at data for the entire country we have created a single uscdsldspumas2012 data set by concatenating the 51 state-level data sets. The Detailed Metadata for this set lets you view "Key values" for this data set such as this page for the Sumlev (geographic summary level code) variable:

So, for example, you can access this dataset via Dexter and code a filter of    Sumlev Equal To 795    and be able to extract data for every 2010 PUMA in the country. You could then look at 3-year trends for these 2351 geographic units by linking these data with those extracted from the most recent (1-year) American Community Survey data. Of course, this only applies to the rather basic dempographic data available on SF1 (no "long form" data such as income, occupation, education, etc.)

In addition to the usual archive datasets that require using Uexplore/Dexter to access, we have also created a series of comma-delimited files with the same data, one file per state. These can be accessed via uexplore or directly at http://mcdc.missouri.edu/data/sf12010x/cdsldspumas2012/.

PctGrpQuarters Denominaotr Problem Fixed

Posted 10-13-2014

A problem with the percentage variable for the Grp Quarters variable was found. It was using HHpop as the denominator instead of Totpop. This caused (in most cases a very slight) error in this percentage variable. The problem was limited to the 1-year 2013 vintage data and the 1 and 3-year period data for vintage 2012. These were fixed so that the acsprofile app now displays the correct numbers (and the indent level was fixed so that it displays with the appropriate lack of indentation, no longer implying that Group Quarters was a subcategory of Household Pop. The fix was also applied to the various standard extract data sets in acs2012 and acs2013 filetype directories (on 10-11-14).

Problem With Space Usage May be Solved

Posted 10-23-2014

We have had a problem over the years caused by our users running certain applications (mostly Dexter) that create rather large temporary files that stay around for several days to allow users to provide indirect access to other users with whom they want to share their results. This has led to instances where we have run out of our temp space and then none of our SAS web applications work until we resolve the problem. We have tried various strategies to resolve the problem but we have now implenented a new strategy that we hope will resolve the problem. We basically now keep track of the temporary space used by each application, writing it to a special log file. At the startup of selected applications (such as Dexter and the geocorr apps) we look at the log file to see if the current user has been creating a lot of such temp space usage. When we see that a user has been very busy generating space (over 5G in a 12-hour period) and when our temp storage capacity if over 65% utilized then we will deny that user access to selected applications for the remainder of the day. This will only effect you if you are one of those users who try to download complete collections of large data sets. The new strategy will mean that you'll have to do those downloads over a period of days rather than trying to do it all at once.

Latest 3-year ACS Period Estimates Available

Posted 10-25-2014

The Census Bureau released the American Community Surveythe 2011-2013 period estiamtes on Thursday. You can now access the MCDC's standard profile data for this release. To view the data in profile report format use the ACS Profiles we application (this is the first link in our Quick Links box). The data can also be accessed via Uexplore/Dexter in the usmcdcprofiles3yr and usmcdcprofiles3yralt data sets. (The "alt" version contains the same data as the original but has all the _moe variables moved to the end of the observation.)

Latest 3-year ACS Period Estimates - Summary ("Base") Tables Now Available Via Dexter

Posted 10-27-2014

You can now access the detailed summary tables containing 3-year period estimates, 2011-2013. These have been stored with the usual partitioning into 6 topic-based datasets, each containing data for the entire U.S. Estimates and MOEs are stored in separate data sets, which can be readily linked using the key field Logrecno (or, alternatively, State, Geoid). To access use Uexplore go to access the acs2013/basetbls data directory. If you want to access table C17001 (with poverty by age) select data set ustabs17_203yr . Once in Dexter you'll note that the select list on the right lets you choose tables rather than individual cells (variables). Just select the C17001 table (or any of hundreds of other tables for the range of topics for this data set (Poverty=17, Disability=18, Income=19 and Individual Earnings=20).

Vintage 2013 1-year ACS PUMS Data Available Via Dexter

Posted 10-27-2014

The usual naming conventions apply. Access these data via uexplore/dexter at http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/acspums. We downloaded the data for Missouri and for the entire US. Note that as usual the usprecs13 and ushrecs13 data sets come wth the companion ushrecs13b and usprecs13b data set to avoid overly-large data sets. The "b" sets contain data for states Missouri thru Wyoming.

1990 Census, Summary File 2C Added to Archive

Posted 11-04-2014

We downloaded the national summary file "stf902c" (Summary File 2C, 1990 Census) from the Bureau's FTP site and was able to use our 20-year-old conversion macro to access the 47 flat files comprising this data product. We also downloaded the techdoc and added to a Docs subdirectory. We have a scanned pdf file of over 200 pages, which is hard to work with because you cannot partition it or do character string finds to navigate.

Ten Things to Know About the MCDC Data Archive

Posted 11-11-2014

This module provides some basic topics related to our collection of public datasets accessible via the Uexplore/Dexter software. See it at mcdc.missouri.edu/TenThings/MCDCDataArchive.shtml.

2010 PUMS Data Now Available

Posted 12-02-2014

Better late than never -- the Census Bureau has released a Public Use MicroSample file based on the 2010 census. They did so early last month without much fanfare (we missed it and we are no most of the Bureau's alert lists). We discovered its existence on the Proximity 1 blog earlier this week. The data are available in the Bureau's ftp site. This is perhaps a preliminary release since they do not yet have a complete set of Technical Documentation. But a simple Excel file (available from our data archive as file 2010 PUMS Record Layout.xlsx) provides a layout as well as codebook (value labels). These data are lacking in subject matter (no long form in 2010, and not much of a short form either). But they are a 1-in-10 sample so they can be valuable for studying rather small demographic groups. Geography is the usual for PUMS files with the smallest area identified being a PUMA. (2010 PUMAs, of course).

The data are released (for now, at least) as a collection of state .zip files with two fixed format (.txt) files inside: one for the H(ousehold) records and one for the P(erson) records. We have written SAS code to convert these files to a pair of SAS data sets (e.g. mohrecs and moprecs) and a SAS view (mov) that merges the two together as if they were a single rectangularized data set. You can access the data via Uexplore/Dexter at http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data//pums2010 . All we have so far are data for Missouri. Let us know if you need data for other states and we'll consider adding them. If you are interested in seeing the SAS code we used to read the input files that is avaialble as the cnvtpums.sas file in the Tools subdirectory (http://mcdc.missouri.edu/data/pums2010/Tools/cnvtpums.sas).

New 2009-2013 ACS Data Now Available

Posted 12-05-2014 and Updated 12-08-14

The Census Bureau has released the 5-year period estimates based on the ACS data collected for years 2009 through 2013. These data can be accessed using the Bureau's American FactFinder web site. The MCDC has updated their ACS Profile web application (census.missouri.edu/acs/profiles/) so that you can now select the 2009-2013 time period. We have also updated the ACS Profile Extract app to assist users in pulling extracts from the 5yr datasets in the /pub/data/acs2013 data directory. New summary tables data have also been added to the archive in the acs2013/basetbls subdirectory which can be accessed via Uexplore/Dexter. (More custom versions will be created shortly).

New PUMA Master Dataset

Posted 12-05-2014

We recently generated a report showing which of the datasets in our public archive were getting accessed the most. We discovered that by far the most frequently accessed was the zcta_master dataset in the /pub/data/georef data directory. This dataset is useful for anyone working with ZCTA level geography, and now we created something equivalent for users working with the latest PUMA level geogrpahy. We understand that this is a much smaller audience, but there is still demand from users who want to use the PUMA level summary data from the ACS (important because PUMAs are large enough that they get single-year data every year), or for those doing research with PUMS datasets (both the more recent acspums datasets and the just-released 2010 PUMS data). Still need to create the metadata file (but if you look at the one we did for zcta_master you'll see it's the same idea).

New PUMA Master Dataset Web App and Metdata

Posted 12-10-2014

We have completed coding of the metadata page for the new georef.puma_master dataset. We have also created a new web application that allows the user to enter a PUMA code and get a display of all the relevant geographic info and ACS-based key indictors. The output also contains links to two map applications where users can go to see where the PUMS(s) are located. Access the new Display PUMA_Master application. Links at the bottom of this page can be used to take you to the puma_master dataset (via Dexter) and to the puma_master.Metdata.html file.

We updated our All About PUMAs web page to include a reference to these new resources.

Geography Page Updated

Posted 12-11-2014

We made extensive changes to our Geography page involving deleting or updating outdated links and adding links to recently created resources such as the puma_master dataset/web app.

New set of 5-year ACS Base Tables

Posted 12-17-2014

We have created a new set of American Community Survey base tables based on the recently released 2009-2013 vintage data from the Census Bureau. We have used the same setups as ;last year so that the new acs2013/btabs5yr directory is very similar to last year's acs2012/btabs5yr directory. Basically we break the tables down by tabel topic groups and level(s) of geography.

New set of 5-year ACS Standard Profiles Data

Posted 12-17-2014

We have created a new set of standard "mcdc" profiles based on the latest 5-year ACS data (2009-2013). These can be readily accessed using our ACS Standard Profile Extract Assistant or, you can access the updated acs2013 data directly via uexplore. These are the same data can be accessed via the ACS Profiles web app as well as the ACS version of the Circular Area Profiling System app (see next article).

ACS CAPS App Now Uses 2009-2013 Data

Posted 12-17-2014

The MCDC's CAPS - ACS Version has been updated so that it now uses the new 2013 vintae 5-year ACS data in order to create the n-mile profile reports. If the smallest circle requested is < 3 miles then the application will use block group level data to estimate the circular area. Otherwise, it uses census tract data for the estimate.

New 2013 Vintage SAIPE Data Now Available

Posted 12-18-2014

The Census Bureau released the new 2013 Small Area Income and Poverty Estimates ("SAIPE") data earlier this week. We have downloaded these data for the entire U.S. and they can be accessed in the saipe data directory using Uexplore/Dexter. We have appended the new data to our usschldst20xx and usstcnty20xx data sets, one for data at the School District level and the other at the State and County levels. See the Census Bureau SAIPE page for a detailed discussion and for access to an interactive application for accessing selected data.

Go to the top of this page.

See the whatsnew page for last year.

This file last modified Thursday December 18, 2014, 12:26:44

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