MCDC Applications and Data Products

Revised December 2023

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 2022 ACS 1- and 5-year vintages. This is probably our most useful data product. [example]
ACS trend reports: Currently this is for 1-year data from the 2006 thru 2022 ACS, as well as some older 3-year data. [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 versions covering different approximate time periods: Geocorr 2022, Geocorr 2018, 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 basic application to look up standard (mostly FIPS) codes for geographic areas by state, grouped into common census summary levels and including populations (as of most recent ACS). Most codes are also linked to lists of data sources. [example]
ZIP Code lookup: Use this application to look up U.S. ZIP codes by state, place name, or both. Results include preferred and alternate place names, latitude/longitude, and land area for each ZIP code. [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 geography reference 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 Excel or PDF files. [example]
State/county annual population change: This simple application provides an easy way 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 5-year age cohorts, data years (1990-present), and demographic groups. Uses estimates from the Census Bureau's Population Estimates Program. Excel output is also available. [example]
Excel file with latest Missouri estimates: 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.
Population estimates reports: A set of annually updated reports pertaining to population estimates, with corresponding links to the underlying datasets.

See also our population estimates page for other resources.

2020 Decennial Census

Census 2020 profile reports: The MCDC Census 2020 profiles include the most-used data items from the U.S. Census Bureau's 2020 decennial census, Demographic and Housing Charateristics (DHC) summary file. This application allows selection and comparison of up to four geographic areas (of the same or mixed levels). Reports are also available in Excel or PDF formats. [example]
Census 2020 DHC extract assistant: The U.S. Census Bureau's 2020 Demographic and Housing Characteristics (DHC) file contains data from the 2020 decennial census. MCDC has created an extract (or profile) of about 100 key variables from the DHC. Use this application to browse the 2020 DHC profiles for selected geographies, summary levels, and subject areas.
Circular Area Profiles (CAPS) — 2020 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 profile reports based on the Demographic and Housing Characteristics (DHC) File (released May 2023), one for each selected radius, including the same variables as in our standard DHC profiles. [example]

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). 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 front end to the Dexter application allows users to choose geographic areas (U.S., selected states, and/or counties), geographic summary levels, and subjects to extract from the 2010 decennial census, Summary File 1 (SF1).

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]

See also our Census 2000 page for other resources.

Other

Missouri county fact sheets: This simple application generates a report for any county in Missouri. The report includes population trends, age and race, income, employment, agriculture, households and housing, poverty, education, and children and families. [example]
County Business Patterns browser: A basic application for generating County Business Patterns (CBP) reports for any county in the U.S. County Business Patterns is an annual data series from the U.S. Census Bureau that provides county-level economic data by industry. The CBP data includes the number of establishments, employment counts, payroll, and size of business establishments. The MCDC app includes NAICS levels 0, 1, and 2. [example]
IRS state and county migration profiles: This application generates a migration profile showing migration into and out of a selected area (state or county) based on IRS tax returns in consecutive tax years. Data years run from 1999-2000 to present. [example]
MCDC data applications by geographic area: This utility application provides access to an array of applications/web pages relevant to the specified area. Includes links to some non-MCDC web apps. [example]