MCDC Applications and Data Products

Revised September 2018

Public Data Archive

The MCDC public data archive is intended for serious data users who want data in a format they can manipulate and analyze. Many users will never use this tool on their own, but should be aware of the resource so that they can inquire about getting help with custom data requests. Start here for an overview of the data archive. Tutorials may also be helpful.

American Community Survey

ACS demographic profile reports
Currently has data for the 2006 through 2012 ACS 1- and 5-year vintages. This is probably our most useful data product, and the one most accessed. [example]
ACS trend reports
Currently this is for 1- and 3-year data from the 2006 thru 2016 ACS. Updated as more data are released. [example]
Circular Area Profiles (CAPS) — ACS version
The CAPS application allows users to enter a location (latitude-longitude coordinates or ZIP Code) and up to five radius values. The results are a series of ACS-based profile reports, one for each selected radius, including the same variables as in our standard ACS profiles, above. [example]

See also our American Community Survey page for other resources.

Geographic Reference

Geographic correspondence engine (Geocorr)
The Geocorr programs allow 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. There are three versions covering different approximate time periods: Geocorr 2014, Geocorr 2000, and Geocorr 1990. All Geocorr versions include links to geographic glossary pages, help/usage pages, etc.
Geographic codes lookup
Use this application to look up standard (mostly FIPS) codes for geographic areas by state, grouped into common census summary levels and including populations (as of 2011-2015 ACS). Most codes are also linked to lists of data sources. Very simple but helpful. [example]
Geographic reference reports
Quite a variety here, ranging from basic to complex. Focus is on reports that will make the geography more understandable and useful. This example deals with PUMAs (Public Use Microdata Areas), which are not widely understood but are one of the most useful geographic levels.

See also our population estimates page for other resources.

Population Estimates

Population trends with demographics
Population trends at the national, state, and county levels for selected years (1990-present) and age and race categories. Includes bar charts and options for generating an output Excel or PDF file. [example]
State/county annual population change
This very simple application provides a quick and easy was to picture what the general trend in total population is for any county nationwide. [example]
Population estimates by age
The most detailed of our population estimate applications. Provides population data at the state and county level for multiple age cohorts, data years (1990-present), and demographic groups. Uses bridged race data from NCHS/Census. The user can specify their own custom age intervals or use predefined cohorts. Excel output is also available. [example]
Excel file with latest Missouri estimates ("curmoests")
Updated annually, this spreadsheet includes the latest population estimates for Missouri counties and places (incorporated cities). You can get earlier versions of this spreadsheet in the popests data archive.
Missouri county projections to 2030 with population pyramids
Older (circa 2002) population projections for each county in Missouri. Data were official values from state demographer's office. Each Excel file has multiple worksheets, one for each projected year. Each sheet has the pyramid chart followed by the data table.
Population estimates reports
A set of annually updated reports pertaining to population estimates, with corresponding links to the underlying datasets via Dexter.

See also our population estimates page for other resources.

2010 Decennial Census

Census 2010 profile reports
The MCDC Census 2010 profiles include the most-used data items from the U.S. Census Bureau’s 2010 decennial census, Summary File 1 (SF1). This application allows selection and comparison of up to four geographic areas (of the same or mixed levels) over a single time period. In addition to the web-based profile report output, reports are also available in Excel or PDF formats. Note that Summary File 3 was replaced in 2005 by the American Community Survey; use one of the ACS applications listed above to get SF3-type data for 2010. [example]
Circular Area Profiles (CAPS) — 2010 version
The CAPS application allows users to enter a location (latitude-longitude coordinates or ZIP Code) and up to five radius values. The results are a series of SF1-based profile reports, one for each selected radius, including the same variables as in our standard SF1 profiles, above. [example]
Census 2010 SF1 extract assistant
This is a front end to the Dexter application (see below) that lets users choose the geographic areas (entire U.S. or selected states and/or counties) and geographic units (summary levels).

See also our Census 2010 page for other resources.

2000 Decennial Census

Census 2000 profiles menu
Available for almost all geographic levels, usually nationwide. Reports contain drill-down links to parent tables on Summary File 3. Includes links to extensive metadata. [example]
Circular Area Profiles (CAPS) — 2000 version
Similar to the 2010 version of CAPS (see above). However, unlike the 2010 census version that has limited ("short form" only) data, these reports show a much richer set of data, taken from Summary File 3. [example]
Demographic trend report: 1990-2000
Available for many geographic levels, usually nationwide. (Tract and block-group levels are available for Missouri only.) Content is very similar to the profile reports (above), but here we have data for two decades with calculated change and percent change figures. Has links to extensive metadata. [example]
SDC profiles
Very detailed subject-based tabular reports in PDF format, presented via a heirarchical menu of geographic levels, specific geographic areas, and specific profile subjects. Reports are based on Summary File 3. Design and coding of this application was done by a coalition of State Data Center (SDC) agencies, including MCDC. Very popular with many librarians and detailed data junkies. [example]
2000 county-to-county work flow reports
These reports show the counts and percentages of workers commuting from/into counties. There are four reports for each state: two sort orders (resident or work geography) and two formats (HTML/PDF). [example]

See also our Census 2000 page for other resources.

Other

County-to-county IRS migration profiles
This application generates a migration profile with data regarding movement into and out of the chosen county based on tracking movement reflected in IRS tax returns in consecutive tax years. Data years run from 1999-2000 to present. State-to-state migration profiles are also available here. [example]
MCDC data applications by geographic area
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 make it possible and where we think the page/app is worthy of the link. [example]