Missouri Census Data Center

What's New at the MCDC in 2016

Go to most recent posting(s).

January February March April May June July August September October November December

Posted 1-6-2016

New Cycle of Data for the beareis Filetype

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

Posted 1-6-2016

New Cycle of Data for kidscnt Filetype

We have processed a number of resources (mostly from Missouri state agencies) to create an updated version of the database used in the Missouri Kids Count project. See the 2015 new data collection. .

Posted 1-11-2016

New Inter-censal State and County Pop Estimates 1980-1989

We added these data after a user request for some 1980 data by age, race and sex. The new data sets are in the popests/old/ data directory. The new data sets are usageracesex8089 which has county level data by 18 5-year age cohorts for 6 race/sex combos (white, black and other race by sex), and usageracesex8089Summaries, which contains summaries of the data in the first data set but summarized at various levels including nation, state and county geographic levels, and combinations of race and sex. The variable smrytyp is the key to understanding what is being summarized.

Posted 1-26-2016

Problem With Missing 2k PUMA on MABLE14

Discovered and fixed a problem with the MABLE14 database, affecting the geocorr14 web application. The 2000 PUMA and 2000 Pop count variables were missing from the mable data sets. Found and fixed the problem.

Posted 2-13-2016

IRS Taxes Data for 2013 Added

We downloaded the IRS individual income tax summary data for states, counties and ZIP codes based on tax year 2013. These are complete data. (The IRS announced preliminary 2014 TY data but that has not been put into the format we use and finalized (i.e. based on a complete calendar year vs a first-9-months preliminary). Access the data at /cgi-bin/uexplore?/pub/data/irstaxes/. These data are similar to what we have for 2011 and 2012 but there were 19 new items added for this cycle. These items have been included on the standard converted sets and have also been processed to appear on our enhanced "plus" data sets. See the Readme.htnl file for details.

Posted 3-1-2016

Data Set and Report Show Post-2010 Changes in Tract and BG Level Geography

Ideally the Census Bureau creates new definitions of census blocks, block groups and census tracts once every 10 years. One of the beauties of using these units for trend analysis within a decade (across decases is a whole other issue)is that (unlike ZIP codes or places, for example, which not only can change at any time but usually do so without changing their codes) they do not (or at least should not) change their definitions. But in the real world stuff happens, and the Census Bureau does wind up having to make changes to these definitions. Most of the "ajustments" have to do with errors made in the original definitions. These changes are documented on the Bureau's web page at http://www2.census.gov/geo/pdfs/reference/Geography_Notes.pdf. Using these notes the MCDC has created a 2010 block level data set where we have both old and new geocodes. Many of the changes are trivial and do not affect any blocks with population. We ignored those changes and focused on the more substantial ones -- in Pima Conty, AZ, Los Angeles County, CA and 3 counties in New York state (Oneida, Madison and Richmond). The results of our efforts can be found in the data set alttract_bg in the mable14 data directory. The data set can, of course, be accessed via Dexter.

We also did a special report showing 3 basic data items - 2010 population and housing unit counts and land area in square miles - for the affected tracts and block groups in Los Angeles and New York state. (We did not bother doing it for the Arizona tracts since those were just simple code changes with no boundary adjustments.) The report shows the value of the 3 items for both the "old" (as defined in the 2010 census and used in those decennial data products) and the new ("alternate") areas which are now being used in the ACS data products.

Posted 3-9-2016

New Tutorial: Data Allocation Using Geographic Equivalency Files

This rather long and fairly technical document describes the steps that can be used to transform geographic data from one geographic unit to another. A simplified case study (example) walks through the steps and displays intermediate and final results, as well as the SAS(r) code that creates them. A second case study shows the "real life" example of how we created a set of 20005-2009 5-year period estimates for 2010 census tracts, using the data published for 2000 tracts as the source. View the main document at UsingGeographicEquivalencyFiles.shtml . Or you can use our uexplore app to access the directory where this document and related files are stored.

Posted 3-9-2016

New ACS Data Facilitates Tract Level Trend Analysis

Users who had been waiting anxiously back in December for the 2010-2014 5-year period estimates to become available because with that release we had non-overlapping 5-year data for small geographies. Such as census tracts and ZCTAs and counties of any size. But the tract option turned out to be problematic because when the Bureau created those data products for vintage 2009 back in 2010 they used the then-current 2000 census tracts as the units for tabulating tract level data. Which means doing comparisons at the tract level would not work unless there was some way to get those 2009 5-year tact estimates aggregated to 2010 tracts. We have tried to do this using a process that is at least well documented in the tutorial reference in the previous article where the process is described in detail. We used the Census Bureau's block level relationship files (stored in our blkrel10 data directory) to create a tract-to-tract equivalency file across the decade. We then did an allocation of the old 2000-tract estimates and arrived at a new set of 2010-tract summaries. We have done this for all 50 states plus DC but users should note that there are ten states (Alabama Alaska Colorado Iowa Maryland Massachusetts Michigan Minnesota Texas and Virginia) where there were unmatched geographies that have led to some loss of data during the allocation process. For a more detailed explanation see the tutorial or at least view the conversion log file where the unmatched tracts are documented. (There is also a summary version of this log file if you want to see the bigger picture without all the detail.)

Access the new data sets in the acs2009 data diretory. Access the new metadata for the Missouri data set -- which contains a link to invoke Dexter for that data set.

Posted 3-24-2016

New County Estimates for 2015 With Components of Change (since 2010)

The Census Bureau released their county and metropolitan area level population estimates today. The MCDC has completed their standard processing of these data, creating new uscom15 and mocom15 data sets and a series of reports based upon these data. These data sets can be accessed via Uexplore/Dexter at //mcdc.missouri.edu/data/popests/Datasets.html. (The first six rows reference the six new data sets.) We have also generated a series of reports based upon these data that can be accessed at the population estimates Reports index page.

Posted 3-24-2016

Two County Changes in Alaska and South Dakota

As part of our processing of the new county estimates we discovered two county changes. They are:

Posted 4-25-2016

New County Business Patterns Data

The Census Bureau released new County Business Patterns data for the US, states, counties and metro areas on 4-21-16. We have downloaded the data and created the usual collection of data sets in the cbp data directory. The new data sets are ustots14, usstates14, uscos14 and uscbsas14. These data can also be accessed on the Bureau's web site on their CBP page.

The companion ZIP Business Patterns data is scheduled for release in May.
(The ZIP level data was downloaded and processed 5-21-16 per note below).

Top of page

Posted 5-17-2016

Health Insurance Coverage Data (SAHIE)

We have downloaded and processed two new sets of SAHIE data for 2013 (updated) and 2014. These datasets are stored in the saipe data directory. There are 6 new data sets: moshaie13, mosahie14, sahie14 and sahietotals14. Naming conventions and data content are essentially the same as we have stored in this time series that goes back to 2006.

Posted 5-19-2016

Sub-county Population Estimates

We downloaded and processed the latest sub-county population estimates for 2010-2015 from the Census Bureau. We did our standard processing, creating US and Missouri data sets in the popests data directory and generating a new set of reports based on these data. See our population estimates Reports page with links to the new reports and to the new data sets (Dexter access) on which they are based.
The new Excel file with these data has not yet been created.

Posted 5-21-2016

2014 ZIP Business Patterns

As promised back in April when we processed County Business Patterns data for counties and other levels we have now received and processed the corresponding data at the ZIP Code level. We store these data in the saem filetype data directory as the county level data. The easiest way to access these data is via the Datasets.html page in the cbp data directory . (Access here is, or course, via Uexplore/Dexter).

Posted 6-4-2016

2015 Update Applied to Curmoests.xlsx

The Excel workbook Curmoests.xlsx has been updated to a 2015 data vintage with the latest estimates for Missouri at the state, county, and place (city) levels. (We point to this file as the first item in the section title Our Best Estimates on our Population Estimates page.)

Posted 6-8-2016

Problem With Web Applications Resolved

The MCDC encountered a problem with many of its more popular dynamic web applications (the ones written in SAS(c)) starting early Sunday morning and continuing until mid-morning on Tuesday (yesterday) when the problem was resolved. We appreciate all the feedback we got from users telling us that their requests were not running.

Posted 6-21-2016

County Level Charts and Maps

Better late than never, we have created a set of charts and maps showing some key variables measuring change in population between 2014 and 2015 at the county level. These are the same bar charts and choropleth maps (one set per state) that we did last year. Access via Uexplore in the popcharts2015 subdirectory of the popests data directory. The Menumap.html page can be used to view a county level map for the entire U.S. that also doubles as a "menu map" where you click within a state to view that charts for that state.
Note: these charts are based on the county population figures with components of change released in March. They do NOT contain any data regarding age, race, sex or Hispanic origin detail such as are scheduled to be released in two days.

Posted 6-23-2016

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

The Census Bureau released these estimates today (see the Bureau new release). These data are available for access via Dexter in the popests data directory (look for data sets such as mocasrh15). We have also generated (as per usual) our set of tabular reports summarizing these data at various levels for all states in the U.S. Access these reports from our Population Estimates Reports by State page. (In addition to the reports for counties and metro areas by state, we also have reports summarizing the data for the nation and statres.) (The vintage 2014 casrh data sets have been archived.)

Posted 7-6-2016

NCHSI 2015 Population Estimates Available

The National Center for Health Statistics' special tab of the Bureau's County Estimates by Age, Sex, Race and Hispanic thru 2015 have been downloaded and processed. The results are stored in the nchsbri data directory (a subdirectory of the popests data directory) in data sets such as monchsbridged201x.sas7bdat and monchsbrided201x_sumry.sas7bdat . The metadata for all these new sets have been added. These data differ from the casrh data sets in that they have single year-of-age data and use the special "bridged" race categories. See the Readme file for details.

Posted 7-11-2016

ZIP-Tract Crosswalk Files from HUD/USPS

The new hudusps data directory (accessible in the MCDC data archive using uexplore/Dexter) contains data linking 5-digit U.S. ZIP codes (not ZCTAs, but actual ZIP codes) to 2010 census tracts. The data are based on address delivery files from the U.S. Postal Service (USPS) and processed by HUD. The files are available from the HUD USPS ZIP Code Crosswalk Files web site where you can select a Year and Quarter and a crosswalk type (Zip-to-tract or Tract-to-ZIP) and have an Excel file delivered on the fly.

We have thus far downloaded just the two files for the 1st quarter of this year, converted them to csv format and, of course, converted them to archive data files (aka SAS data sets). Actually, we have combined the two sets into a single set per quarter. Instead of having the Tract-to-ZIP information stored in a separate data set, we just merged the 4 "portion of tract" variables into the same observation containing the 4 "portion of ZIP variables. See an example at sample_report.html .

Posted 7-13-2016 (rev. 7-26)

New Datasets Provide Estimated Business Activity by Census Tract

We have had County Business Patterns and more recently ZIP Business Patterns data (stored in our cbp data directory) for a number of years. Now, we have used the ZIP-Tract crosswalk data (see previous post, above) to create a new set of estimates at the census tract level. For now, we have only estimated total establishments and total employment. The estimates are stored in the ustractbpests14 data set within the hudusps data directory. (link to dexter here).

Posted 8-9-2016

New Key Neighborhood Indicators Filetype

The new kni filetype is not finalized yet but users might want to visit the construction site. The neighborhhods are actually census tracts and the indicators are almost entirely items extracted from the latest 5-year period estimates from the ACS. But it also includes the "tract business patterns" employment estimates (see previous article). Special "pcat" variables provide quick access to percentile category to let you pick out items that rank somewhat/very/extremely high or low. These data are available for the entire U.S. See the Readme file for more details.

Posted 9-7-2016

2014 data added to irstaxes collection

We have downloaded and processed the latest year of data from the IRS summarizing income tax returns data at the county and ZIP code level for the country. Our processing of these data is the same as what we have done for the three previous tax years (2011-2013). Access the data using Uexplore/Dexter in the irstaxes data directory. (Easiest way to navigate is via the Datasets.html page) which has been updated to reflect the new data sets).

Posted 9-10-2016

Updates to MABLE/Geocorr

We have two new things added to the MABLE/geocorr14 web utility app:

  1. Two new geographic codes have been added to the . These are Hospital Service Areas and Hospital Referral Regions. See the new Maggot file entries for details regarding these items.

  2. A new weight variable option has been added: the population over 65 per the 2010 census.

Top of page

Posted 9-15-2016

2015 ACS Single-year Data Released

The first set of vintage 2015 ACS data was released by the Census Bureau today. The MCDC has download the detailed tables and created our usual MCDC Profile standard extract. You can go to the Bureau's Americna FactFinder site to access the data or you can use our site to get most of what you are probably looking for.

You can start by accessing our ACS Profiles web app where you now select the 1-year 2015 period. Then select your geography (up to 4 areas - remember, these 1-year data are only for large areas of at least 65,000 population) to see the basic facts. To see the report with 2015 pre-selected along with the state of Missouri and the United States as geogrpahies use: census.missouri.edu/acs/profiles/report.php?p=26&g=04000US29|01000US.

If you would prefer to compare Missouri over time (rather than with the U.S.) you can use the updated acstrends report. To run with 2014/2015 for Missouri pre-selected use: census.missouri.edu/acs/trends/report.php?p=26|24&g=04000US29.

If you prefer to just access the data from our archive via Uexplore/Dexter you can access all the data appearing in our acsprofiles report in the acs2015.usmcdcprofiles dataset. If you want more detail you can follow uexplore into the basetbls subdirectory where you can access the hundreds of detailed ("base") tables.

Posted 9-19-2016

Dexter Modifications

We have made some fairly minor updates to the uex2dex/dexter modules used to provide user access to our public data archive. The mods are:

  1. The rankster option line has been moved to the bottom of the form. This was due to lack of use. We would have deleted it altogether but we use it too much ourselves.

  2. A Comments text box has been added near the top of the form (by default the comments are not displayed - you have to click on the "(Display Comments text box)" button to see them). After entering the text there is a Hide Comments text box button you can use to hide it. This vertically scrollable box allows you to enter text describing the query. This text will then be displayed on the output Summary Log page, which can then be downloaded and saved to document your query. Perhaps more importantly, it allows us (at the MCDC) to add descriptive text to our saved Queries modules. See, for example, our recently added econ_indicators_1state Queries module for accessing the latest acs2015 data.

  3. We have dropped support for old format saved query files. (Saving the entire page with File-Save as from your browser is now a better way to go.)

Posted 9-19-2016

New Queries Module for New acs2015 Data

Using our new acs2015 data and our new and improved Dexter web utility we have created a new sample Queries module. Go to the acs2015/Queries directory and click on the econ_indicators_1state.htm saved query module. Note that when the page loads it will display a Comments box that describes the query. It also provides hints regarding how to modify the query -- to filter out geographic component data and/or change the state specified from Missouri to (for example) California.

The module extracts key economic indicator variables for all counties, cities and the state for 2015 single-year data for a specified state (Missouri, by defult). We download the output csv file and opened it in Excel. Then we saved it as an Excel file and added it to the files directory associated with the Queries module. It can be accessed by going to the files directory and selecting xtract.xlsx (assuming you have Excel or something equivalent to allow you to view Excel files.) The correspond csv file that was created by the query is also saved in the same directory.

Posted 9-20-2016

Error found and fixed in Uninsured Profile Variables

We discovered an error in the variables regarding health insurance coverage by age (<18 and 18-64). These have been corrected. The acs2015.usmcdcprofiles data set has been updated to have the correct values. The acsprofiles and acstrends applications are displaying the correct data.

Posted 10-12-2016

Address List Processing Service (ALPS) Update

We have revised our ALPS products. We have dropped some services that had never been used, and have revised the pricing structure.

Posted 10-17-2016

New Cycle of IRS County Migration Data Added

Possible Problem: We are seeing dramatic and consistent decreases in the flow values for this year (2014-15) vs. last year (2013-2014). For example, the new data shows 44,000 total inflows to the state of Missouri when last year that figure was over 60,000. The same pattern appears to be occurring everywhere. We have sent a note to the IRS migration data folks asking if there is any known problem. Our guess is that it is a preliminary file (not advertised as such) that does not include the entire year of returns.

The IRS has released a new set of migration data tracking county-to-county and state-to-state moves based on tracking income tax returns filed during calendar years 2014 and 2015. The MCDC has comparable data from this source going back to 2004-05. These data can be accessed via Uexplore/Dexter in the irsmig data directory (the link to this data directory is found in the other section of the uexplore home page.) Look for the icons. The usinmig1415 and usoutmig1415 datasets are the new county level flows for just the latest year(s), while usstateinmig20xx and usstateoutmig20xx have state level flows for all years going back to 04-05.

Most users will prefer to access these data using our IRS migration profile web apps (one for counties, one for states). Access a profile report for any county in the US via the Single County IRS Migration Profile page, and for any state at the State-toState IRS Migration Profile page. (Both of these menu-page links can be found on our MCDC Data Product Inventory and Showcase page.)

You can also access a profile report for any state or county using MCDC Data Applications (aka "applinks" - in Quick Links box). These links should always display profiles with the latest available data.

Posted 10-24-2016

New set of ACS PUMS Data for 2015 Available in MCDC Archive

We have added the 1-year 2015 ACS PUMS data as released by the Census Bureau on Oct. 20. Same datasets, naming conventions, etc. as last year(s). Access using the Datasets.html directory page in the acspums data directory. As usual we have separate precs (Person records) and hrecs (Housing unit records) for Missouri and the US. We actually have two US datasets (four to be precise, since we have precs and hrecs datasets for each US subset), one with data for Alabama thru Mississippi, and another for Missouri thru Wyoming.

Top of page

Posted 11-07-2016

Key Neighborhood Indicators Updated

We modified the datasets stored in our kni data collection (see our article from 8-9-2016 posted above). We now keep the actual percentile score for each indicator in addition to the "pcat" (percentile category) item. Also, we have created a subdirectory of reports that show the statistical summaries used in assigning the pcat variables. See the nbhd_attrsUR_meansreports subdirectory (via Uexplore).

Posted 11-08-2016

County Adjacency File Processed

We downloaded a 2010 county adjacency file from the geography page at the Census Bureau web site. We created a pair of new datasets in the georef data directory. First, we created adjacency_counties2010, a straightforward version of the data, one obs per neighboring pair with self-neighboring included; then, we created adjacency_counties2010_collapsed, an alternate "collapsed" version with just one obs per county with the neighboring counties IDed in two list variables. Using uexplore/Dexter and the collapsed dataset you can very easily select the Missouri subset (filter: State Equals 29), check the box to keep all variables and get html output such as the following (16 of 115 rows shown):

Posted 11-21-2016

Sitemap page Updated

We did significant updating of the Site Map page.

Top of page

Posted 12-01-2016

Annual Employment Data from BLS for 2015 Added

The basic unemployment data for calendar year 2015 at the state, nation and county levels are now available in the MCDC data archive. Access the bls_la data directory and access the two new datasets via dexter by clicking on their names in the contents page: uscountyavgs15 has data for all counties and county equivalents in the U.S. and PR. The companion dataset usstateavgs15 has the same data at the state and nation levels. These datasets are the latest in a series that goes back to 2008, with 1990 and 2000 data as well. Dexter users can access the entire time series by using the wildcard feature of Dexter - edit the latest dataset but then edit the box at the top of the page, replacing the suffix 15 with __ (two underscores). That will allow you to extract data for all the years we have. If you only want select years you can always create a filter (in section II of the Dexter query form) with the InList operator to specify the years of interest. (See the wildcard_stateavgs sample Queries module).

Posted 12-08-2016

ACS Data for 2011-2015 Now Available!

These are the highly anticipated data based on ACS surveys taken from 2011 through 2015. These are the same kind of datasets (for the most part) that we have been processing for over the last 10 years. The Missouri Census Data Center has updated their ACS Profiles web application. This app allows the user to choose up to four gegraphic areas and get profile reports with over 200 key data items per area.

We shall also be making the detailed summary tables available (as usual) but those take a while to process and are not yet available.

Posted 12-13-2016

ACS Base (Summary) Tables for 2011-2015 Now Available

As promised we have added the 5-year base tables to the archive. They can be accessed via Uexplore/Dexter in the acs2015/btabs5yr data directory. We have used these summary tables to add some extra variables to our block group level standard profiles dataset. The best way to access the standard profiles data at the BG level is via our ACS Profile Extract app (see second entry in our Quick Links box.)

We used the new summary tables to recover some additional variables at the block group level for our usbgs5yr data set.

Posted 12-14-2016

CAPS ACS Version Updated to Use New 2015 Vintage Data

It is still the same URL to access it (/websas/caps10acsb.html) but it will be a slightly different page. We have added an extra input box at the bottom of the page where you can specify that you want the app to use an earlier vintage data (from 2011 to 2014).
Posted 12-15-2016

New County Level Poverty and Income Estimates

The vintage 2015 SAIPE data have been downloaded and added to the archive. The new datasets (in the /pub/data/saipe data directory) are usstcnty2015 and usschldst2015 and the corresponding Missouri subsets (change "us" to "mo"). The new annual data have (as per usual) been appended to the time-series datasets usstcnty20xx and usschldst20xx.

Posted 12-15-2016

Maps and Charts Depict SAIPE Poverty Data

The new pov2015charts subdirectory of the saipe data directory (/cgi-bin/uexplore?/pub/data/saipe/pov2015charts) is a collection of reports, charts and maps depicting county level poverty data. Easiest way to access is via the US Poverty Rate map that doubles as a menu map (allows drilling down to maps and charts for any state.)

Go to the top of this page.

See the whatsnew page for last year.