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:

'2901701'='01801'
.

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
http://mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=websas.poptrend1.sas&_SERVICE=sasapp&st=29&co=all
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.

Curmoests.xlsx

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 1/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 2012, 2013 and 2014.

Access these data via Uexplore/Dexter in the new gazteer data directory.

Go to the top of this page.


See the whatsnew page for last year.

This file last modified Monday September 15, 2014, 08:22:55


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