MCDC Data Product Inventory and Showcase

Rev. June, 2017

Population Estimates and Projections

Product Example Access point(s) Notes and comments
Population Trends Report MO and Boone County, 2000-2016, for selected demographic items. Menu page allows selecting geography, time periods and demographic details. Works for the nation, states and counties nationwide. Time periods from 1990 to most recently available. Demographic detail based on age, sex, race and hispanic, with emphasis on changes over the time periods. Includes bar charts and options for generating an output Excel or PDF file.
Total pop trend (2000 to latest available year) with bar chart Population trends, 2000-2016, for Christian County, MO Menu page to select a state (and subsequently a county.) This is so simple as to be almost trivial but we find it is a quick and easy was to picture what the general trend in total pop is for any county. Works for any county nationwide.
Excel file with latest Missouri estimates Curmoests.xlsx There is no specific front end or menu page but there is a link to this file from the MCDC Population Estimates page (first bullet item) You must have Excel or at least an Excel file viewer in order to use this. The file has multiple worksheets with different levels of geography. As new estimates are released throughout the year they are added here. So in early June of 2010 (for example) we had the 2009 estimates for counties, but not for cities or cities within counties (where 2008 values were the latest available). The 2009 place level estimates came out in July of 2010 and shortly thereafter they appeared in these spreadsheets. (As of 10/12 this file has complete estimates for all geographic levels thru 2009 (updated per a Bureau re-issue in September of 2010). )
Missouri county projections to 2030 with population pyramids St. Charles county projections to 2030, etc. Uexplore-based menu page for access to all 116 chart xls files (1 for each Mo county plus a Missouri state totals file). Missouri only. Data are official values from state demographer's office. Each xls file has multiple worksheets, one for each projected year. Each sheet has the pyramid chart followed by the data table.
Population Estimates by Age Standard broad cohort estimates for state of Delaware and each of its counties with racial detail for 3 recent years. Population Estimates by Age menu page Link to this app off the MCDC Population Estimates page. Data nationwide at state and county levels for years 1990 to latest available estimates (2016). Uses bridged race data from NCHS/Census. The user can specify their own custom age intervals or standard groupings can be used. Output can also be a csv file (easily converted to Excel).
Report (pdf format) for any state, county-level estimates for most recent year and 2010 for various demographic categories: age, race, Hispanic, sex California report (pdf file) Menu page to select state and year. This same menu page lets you select companion reports that have breakdowns of Race and Hispanic origin crossed with Age and Sex. Data available back to 2004. Based on official Census estimates by county, age, sex, race and hispanic origin. Comparable report by CBSA (metropolitan and micropolitan statistical areas) also available.
Population Estimates Reports Population Estimates Reports menu page Points to a series of updated reports pertaining to population estimates. With corresponding links to the underlying datasets via Dexter.

American Community Survey

Product Example Access point(s) Notes and comments
ACS Demographic Profile Profiles for Boone co., MO + 3 related geographic areas Front-end page (Geographic Selection Menu; included in our Quick Links menu box) Currently has data for the 2006 thru 2012 ACS years. This is probably our most useful data product, and the one most accessed.
ACS Trends Profile Columbia, MO Trends Profile, 2011-2012 Front-end page (Geographic Selection Menu) Currently this is for single-year and three-year data from the 2006 thru 2012 ACS, but it will be updated as more data are released.
ACS Data Extraction Example Measures of Economic Well Being - Missouri Cities and Counties . This ACS-based report was generated using the MCDC's Dexter data extraction module. Dexter for Data Junkies module. (module name is acs20071). The Dexter for Data Junkies modules are experimental and are intended for serious data users who are willing and able to make use of the MCDC's Uexplore/Dexter software (see below). This module provides a detailed explanation of what you need to know and how you would go about doing a basic extract from what many would say is the MCDC's most important single data set. It demonstrates the power of these important tools accessing these important data.
Ten Things to Know About the American Community Survey Ten Things to Know .... Same as link to left - this is just a single web page. This is just a kind of Readme file that we put together with the help of Leonard Gaines a few years ago when the first ACS data were being released. It is a brief orientation to the data resource, and tries to warn users about certain aspects of the data that might surprise or disappoint them. It is one of our consistently most frequently accessed pages, still getting about a thousand hits (not counting bots) each month 3 years later. It has not been updated since the original publication but nothing that we said about it back then seems to have changed.
American Community Survey home page (MCDC) American Community Survey. Same as link to left - this is just a single web page. This is where you should start if you are new to this data resource and want to find out more. Includes a good links-to-other resources section.

Geographic Reference

Product Example Access point(s) Notes and comments
  1. Maryland ZIP to State Legislative district

  2. Illinois & Missouri county to CBSA

  3. New England County to PUMA Equivalency Report
Our most venerable web application (since 1995), and still one of the most regularly accessed. This utility allows you to examine the relationships between a wide assortment of geographic layers such as counties, ZIP codes, metro areas, legislative districts, census tracts, etc. for the United States (you get to choose the state(s) of interest). Includes several links to related patges, including one to an online powerpoint tutorial, another to the Master Area Geographic Glossary of Terms (MAGGOT) page, which provides background information about the geographic layers, and a link to an earlier version of the application that works with vintage 1990 geography.
Geographic codes lookup Geographic codes lookup, main menu Codes are as of 2010 and are mostly FIPS codes. Very simple but very helpful.
Geographic Reference Reports 2000 PUMA Codes Showing Counties and Cities That Comprise Them (pdf file) Entire U.S. with state index. Geographic Reference Reports index page, which is linked to from our main Geography/GIS/Maps page. Quite a variety here, ranging from basic to complex. Focus is on reports that will make the geography more understandable and thus data tabulated at that level more useful. Our example deals with PUMAs (Public Use Microsample Areas) which are not that widely understood or used (yet), but which now are one of the most useful geographic levels because there are annual ACS data available for them.

Public Data Archive (via Uexplore/Dexter)

Product Example Access point(s) Notes and comments
Data Archive: Dynamic custom-query access to a very large collection of public data sets Measures of Economic Well Being This report (in html format) was generated using Uexplore (navigation tool to access the data set) and Dexter (extraction tool to define a custom query)

Comma delimited file (loads automatically into Excel if you are using IE and have Excel installed). This is output from the same Dexter query that produced the report output (just above.)

Uexplore display of georef data directory. This lets you view the (sub)collection of files in one of the over 65 basic data categories that comprise the archive. File names are links to access subdirectories or to access data sets.

The Datasets.html page for the georef data directory. Provides improved access to the collection with enhanced metadata.

Detailed metadata page for the mocogeos data set within the georef data directory. Provides user with information about the data set to assist in building their query.

Start here to access an overview page to get a general idea of what we're talking about.

Data archive home page is where most access begins. There is a link to this page in the navy blue navigation box appearing on the left of most MCDC web pages. This allows you to read a little about and follow links to almost all of the archive's 65+ subdirectories ("filetypes"), grouped into 9 major categories.

Once you know what it's about here are some of our most popular data collections ("filetypes"), all with nationwide data:

  • acs2007 - the latest data from the American Community Survey
  • popests - a collection of post-2000 population estimates
  • sf32000x - still very popular collection of basic demographic extracts based on the 2000 Census Summary File 3 collection (we also have the complete SF3 data tables in the sf32000 filetype)

The Uexplore/Dexter Tutorials index page will point you to a series of powerpoint tutorial modules as well as some other on-line documents related to these tools.

This is probably the most important feature of the site for serious data users who want data in a format they can manipulate and analyze. But compared to most of our other applications/products it demands considerably more from the user in order to ferret out what is available and how to access it. Many users will never want to use this tool on their own, but they should still be at least aware of the resource so that they can inquire about getting help with custom data requests, or perhaps even having some other person or persons within their organization who can handle custom data requests.

The home page is really just a huge links page. It has links to data, metadata, background information, tutorials, xsamples, warnings, important notes, etc. If you are new to these data and tools, and you ignore any of the links at the top of the page, you are very liable to get lost. Even if you do read them there is a possbility that you may occasionally get lost. People have been known to attend MCDC workshops to get hands-on training in how to use this set of tools.

Even if you are in the majority of occasional MCDC site users who elect to more or less ignore the data archive feature, you should at least be aware of the scope of the mcdc's data holdings, which are what make possible all the other applications, reports, products, etc. found on the site.

2000 Decennial Census

Product Example Access point(s) Notes and comments
Demographic Profile Report Profile of Washington, MO (place/city) Available for almost all geographic levels, usually nationwide. Reports contain drill-down links to "parent" tables on Summary File 3 (see sf3tabgen, below). Has links to extensive metadata.
Since 2002 this has been by far our most popular (frequently invoked) application.
CAPS: Circular Area Profiles Profile of 3- and 5-Mile Radii of a local street address Circular Area Profiles application page Works for anywhere in the U.S. CAPS application page contains links to online geocoding applications where you can look up the lat-long coordinates of a street address. We used a geocoder from Melissa Corp to look up the latitude and longitude of the address in our sample report. The data here are the same as our standard demographic profile reports ("dp3_2k") described above. You can do larger circles as well, e.g. a 150-mile radius of Pittsburgh would be easy to do. You can enter a ZIP code instead of a longitude coordinate and the program will attempt to look up the ("internal point" coordinates provided on 2000 census products for ZIP codes) for you.
Demographic Trend Report: 1990-2000 Trend report for Miami-Dade county, FL Top level page for a hierarchal sequence of menu pages. Available for many geographic levels, usually nationwide. Tract and BG level only for Missouri, where the 1990 data have been retabulated to 2000 geography for comparison. Content is very similar to the Profile Report (just above) but here we have data for two decades with calculated Change/Pct Change figures. Has links to extensive metadata.
Very detailed subject-based SF3 Tabular Reports ("sdcprofiles") Poverty profile for city of Chicago Main menu that links to a number of other menu pages allowing you to choose geographic level, specific geographic area and specific profile (subject). Reports are based on data in Summary File 3. Design and coding of this application was done by a coalition of State Data Center agencies, including the MCDC. These are pdf files and with small fonts to cram as much info as possible onto a page. Very popular with many librarians and detailed data junkies.
Workflow Reports Workers Commuting Into Maine Counties, Sorted by work county Main menu to the report collection. There are 4 reports (static files) for each state. You get to choose sort order (by county of residence or county of work) and between pdf or html format.
PL94-171 Hierarchal Geography Extract Gasconade County, MO Main menu. Missouri only. The "PL94-171" file is the first data product released from the decennial census except for the state-level pop totals. Also known as the "Redistricting File" it contains very limited data, but provides it for very small geography, down to the census block level. Note that the hierarchy includes a "VTD" ("Voting Tabulation District") which, in most counties in Missouri corresponds to a voting precinct. These were very hot items in 2001, but no so much any more.


Product Example Access point(s) Notes and comments
IRS Migration Profile County-to-county IRS migration profile for Taney County, MO Menu page Menu page lets you select the geographic area and the years. Currently, the most recent year is 2007-2008. Earliest year is 1999-2000. You can follow a link on the menu page which takes you to the twin app that does state-to-state reports. (But can't do county-to-state, unfortunately).
applinks menu-page generator Applinks page for Boone County, MO

Applinks page for Gary, Indiana

Master Menu Page - this page lets you navigate through dynamincally-generated menu pages where the links are to other menu pages until you finally get down to a specific geographic choice at which point the link is to the applinks menu page for that geographic choice

This utility application provides access to an array of applications/web pages relevant to the specified area. It takes advantage of consistent URL conventions used to invoke our apps. We include links to non-MCDC pages/dynamic web apps where naming/parm-passing conventions make it doable & where we think the page/app is worthy of the link. Obviously, you get a different set of links for different levels of geography and, in some cases, for Missouri vs non-Missouri.