Missouri Census Data Center

What's New at the MCDC in 2017

Posted 2-4-2017

New extracts with UA enhancements

Better late than never, we have finally gotten around to adding the urbanized area / urban cluster identifiers to our block level 2010 census standard extract files. These are the files that can be accessed using our 2010 Data Extract assistant web application. There are 4 new varibles added to each observation. These are the UA code, the UA size code, the UA type ("c" for Urbanized Cluster, "u" for Urbanized Area, and "9" to indicate not urban. The urbrur variable just contains "u" or "r" to indicate if the block is or is not within an urban area. This is considered a "beta" version for now but unless we find problems with it we'll make these the new standard block level extracts. For now you would access the moblocksua data set to get the Missouri data with UA fields added. The moblocks dataset (without the new UA codes) is still out there, and that is still the version that gets accessed by the extract assistant. The new data sets are sorted by county, tract and block.

Access these new datasets via uexplore at /cgi-bin/uexplore?/pub/data/sf12010x.

The 2010 Census SF1 Profile application is accessible from the Quick Links box found on most MCDC web pages.

Posted 3-11-2017

New dataset has 10 years of basic ACS data

The new usmcdcprofiles2006_2015 has the standard profile data for all geographic areas large enough to get single-year ACS data (i.e. population at least 65,000) for each of the 10 years indicated. We got this by simply interleaving the ten datasets named usmcdcprofiles in the 10 acs yearly directories (acs2006, acs2007, ...,acs2015). An alternate dataset ("_nomoes" appended to the set name) is the same as this one but has all the "moe" (margin of error) variables removed. See the metadata page for details.

We also have added a 2015 vintage age by race/hispanic and sex (usagebysexraceh15) dataset - same idea as the previous five years. These datasets are mostly for internal use, or for people who have statistical software that makes it easier to build custom tables from data in this "cell" format.

Posted 3-20-2017

Problem with CBSA Code for Hempstead county, AR

We got a report of a problem with Hempstead county not being in any metro area in 2014 (using MABLE/Gocorr14 app). The problem stemmed back to our georef.cbsaco15 dataset where we had manually applied updates last summer. We fixed the problem - both in the geocref.cbsacos15 data set and the mable14 data for Arkansas.

Posted 3-23-2017

New County Estimates for 2016 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 uscom16 and mocom16 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 five rows reference the five new data sets.) These datasets are all alike in terms of the data being reported (pop estimates with annual component of change estimates for the post-2010 era) differing only in terms of what geography is being summarized and for what geographic universe. uscom16 and uscomcbsas16 are the national collections; uscom16 has summaries for counties and states, while uscomcbsa2016 has comparable data for CBSAs (Core Based Statistical Areas, i.e. metropolitan and micropolitan statistical areas) as well as US totals.

We have also generated a series of reports based upon these data that can be accessed at the population estimates Reports index page.

County Level Charts and Maps

Using these new data we have created a set of charts and maps showing some key variables measuring change in population between 2015 and 2016 at the county level. These are the same bar charts and choropleth maps (one set per state) that we did last year. You can access via Uexplore in the popcharts2016 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 charts and maps for that state.

Regular users of this web site will recognize the fact that these 2016 vintage datasets, reports, charts, etc. are the same products we have been producing for many years.

Posted 4-17-2017

New 2015 SAHIE Data

We have added the 2015 vintage data in the Small Area Health Insurance Estimates series to our data archive. Same idea as in previous years, i.e. data regarding health insurance status by county for various age, race sex and income level categories. A new age category, 21-64, has been added this cycle. To acces the data via Uexplore/Dexter go to the saipe data directory (yes, that is not a typo, we keep the sahie data in the saipe data directory). From there select the 3 new datasets: sahie15 (all data for all state and counties in US with breakdowns by demographic categories), mosahie15 (Missouri subset of sahie15) and sahietotals (much shortened version of sahie15 without the demographic detail - just total uninsured.

For more information and some analysis of these data see the Census Bureau web site for sahie data at https://www.census.gov/did/www/sahie/. Note that we have comparable trios of these sahie data sets for each year 2006 through 2015.

We have created a sample query for these data, stored as sahie_trends.htm (in the Queries subdirectory of the saipe data directory). This module demonstrates how to pull data from multiple years of the sahie data to see trends in coverage over several years. This specific query does state level for all states, but it can be readily adapted to work with other geography and/or with other time periods.

Posted 4-27-2017

New 2015 County and ZIP Business Patterns Data

We have added the most recent data for this time series. We did the usual processing, creating datasets at the nation, state, county, CBSA and ZIP code levels (all with NAICS based industry detail). See the cbp data directory. There are 6 new data sets (access Datasets.html in the cbp directory; the six new data sets will appear first in the table.

Posted 4-27-2017

New CAPS Index Page

This new page will assist users in choosing the appropriate version of our CAPS (Circular Area Profiling System) applications. The CAPS links in the Quick Links box that appears on many/most of our web pages will now take you to this page, from which you can select and access the version that best suits your needs.

Posted 4-27-2017

New MABLE/Geocorr Index Page

Same idea as the CAPS index page (see previous item). But
this index page directs you to the appropriate version of MABLE/Geocorr. It also has links to relevant documentation and some useful notes related to the application.
Posted 5-2-2017

Blodgett Presentation at ACS User's Conference

The conference will be in Alexandria, VA next Thursday and Friday, May 11-12. We have posted the ppt presentation as well as a related page with hyperlinks to the pages referenced by the presentation. Access these at
/tutorials/acsconf2017/. The paper gives a brief overview of some resources for accessing American Community Survey data on our web site.
Posted 5-25-2017

Sub-county Population Estimates

. We downloaded and processed the latest sub-county population estimates for 2010-2016 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 first 3 lines of the table are the relevant (new) reports.)

The Excel workbook file (Curmoests.xlsx ) with these data for Missouri has also been updated.

Posted 5-25-2017

County Level Housing Unit Estimates

We downloaded and processed the latest set of housing unit estimates at the nation, state and county levels for 2010 to 2016. These can be accessed via Dexter in the
huest2016 data set. The mohuest2016 data set is the Missouri subset of the us set.
Posted 6-12-2017

Updated Population Reports

We updated several reports to reflect the latest data:

The Geographic Reference Reports index page was updated to provide these new links. (Replacing the previous links to earlier versions of these reports.)

Posted 6-22-2017

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

The Census Bureau released these estimates today (see the Census Bureau news release). These data are available for access via Dexter in the popests data directory (look for data sets such as mocasrh16 - they will all have the "New! icon to make them easy to find.). We have also generated our usual set of tabular reports summarizing these data at various levels (nation, state, county and CBSA) 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 2015 casrh data sets were archived.)

Posted 7-14-2017

Blodgett Retires

And so this will be the final Whats New posting. Check out the new web site at https://census.missouri.edu/ .