|
Decennial Census 2000
[Return to top of page]
sf32000x/
Standard Extract based on Summary File 3, 2000 decennial
census. Our most popular (frequently accessed) filetype, by far. In
these data files we have compressed the 16,000+ cells of tabular data on
a full sf32000 summary record down to a summary consisting of just a few
hundred key items. These files are the basis for our
dp3_2k profile reports.
This file type closely
resembles (and is understandably sometimes confused with) the
sf3prof filetype (below), which is the Census Bureau's standard
extract from the same basic data source. But there are important
differences; perhaps the most critical is that these data are available
for a much wider array of geographic entities, down to the block group,
than are the sf3prof data, available (on this site) only for governmental units.
Be sure to look at the Variables.pdf
file which provides an excellent overview of the data items contained in
these datasets.
sf32000/
Summary File 3, 2000 decennial census. This is probably the most
widely used of the summary data files produced by the Census Bureau.
"SF3" contains detailed tables based on responses to the long form
questionnaire. Here is where you can find data on topics such as
income, poverty, housing value, occupation, education, etc. These
data are available for a wide array of
geographic units. The MCDC has data down to the tract and block group levels for at least Missouri,
Illinois, Kansas Minnesota, Michigan and Delaware (state files.) We also have the
final National file with data for every state, county, ZCTA, place, UA,
MSA, etc. in the U.S. Be sure to read the Readme
file in this directory for a good overview.
sf12000x/
Standard extract from the full 2000 Summary File 1 data sets. Basic
demographic counts based on the short-form census questionnaire. One of
the few places where you can find census block level data. For an
overview, see the Readme.html
file.
sf12000/
Summary File 1, 2000 decennial census. The first detailed set of
tables from the 2000 U.S. Census, derived from responses to the short
form questionnaire. Does not have data based on
long-form questions regarding items such as income, housing value,
occupation, etc. Those items are on sf32000, which was released in the
summer of 2002. For an overview of SF1, review Readme.html.
sf3prof/
If you are familiar with the Census Bureau's DP1 to
DP4 demographic profile report products, here you will find all the
data that goes into them. We have one file per state/profile and a
national collection with higher level summaries. You get to choose
between the variable names that came with the data from the Census
Bureau or MCDC-assigned mnemonic names (e.g. v23 is the Bureau
name, Over65 is the mnemonic name). Percent variables as used in
the DP reports (but not included in the data files distributed) have
been added to the datasets. This is a very well-documented and
value-added collection. Geographic entities summarized are mostly
governmental units: states, counties, places, MCDs, metro areas, 106th
congressional districts and American Indian reservations. We have a
complete collection of data for all states and US summaries.
pums2000/
Public Use MicroSample files. These files are terrific if you
have good statistical software and know how to use it. With PUMS, you can build
tables any way you like it from these datasets which contain actual
microdata (census returns from individual persons and households). Geographic detail
is limited (to special geographic areas called PUMAs. The Census Bureau
releases these files in two product types, a 1% sample file and a 5% sample.
The MCDC collection includes a complete collection of 5% sample files for all states
and a smaller collection of the 1% sample files (Missouri, Illinois and Kansas). SAS
users at universities may contact the MCDC regarding being obtaining access to this collection
directly on the University of Missouri site using a special server.
ctpp2000/
Census of Transportation Planning Package. These files represent a special tabulation of the 2000 Census long-form data for use in transportation planning applications. As such, the tables have relevance to commuting information such as when people leave home for work, how they travel to work, how long it takes to get there, etc. There is also some custom geography found on thees files such as TAZ's (Transportation Analysis Zones) and MPOs. There are 3 parts to this collection: Part 1 provides table summaries based on where people resided; Part 2 is based on where people worked; and Part 3 deals with dual geography, giving characteristics of commuters for specified origin-destination geographic combinations. These data were prepared by the Census Bureau using specifications from the US Dept of Transportation, who are the distributors of the data and who are responsible for its content. We have downloaded and converted files for Missouri, Illinois and Kansas only.
ctppx/
Census of Transportation Planning Package 2000 standard extract.
These extracts are derived from the datasets in the ctpp2000 complete-tables collection.
cqr2000/
"CQR" (Count Question Resolution) was the Census Bureau's program to identify errors in the total population and housing unit counts in the 2k census. This directory has datasets that capture those adjustments at both the census block level (one dataset and csv file per state) and at the governmental unit (state, county, place, mcd) levels.
daytmpop/
"Daytime population" special tabulation.
Attempts to estimate the number of people who may be in an area on a typical work day.
mig2000/
Datasets in this directory are related to migration in the U.S.
between 1995 and 2000 as derived from the 2000 decennial census long
form (sample) data. The Census Bureau released a number of different
summary files in this category, but our collection contains only the
basic counts of movers. This is a national collection.
eeo2000/
This loosely affiliated collection of tables (datasets) is named for
the Equal Employment Opportunity Commission, 1 of 4 federal agencies
that commissioned this special tabulation product. Here you will find
detailed counts of persons by occupation categories by age, sex,
race/ethnicity, education level, income level and even, sometimes, by
industry. Hard to describe since it is a very complicated collection of
24 tables, each with its own geographic, demographic and occupational
dimensions. We tried very hard to make this collection simple
to access, but the task proved to be impossible.
workflow/
County to county work flows. This special tabulation file is based on
sample (long form) data from the 2K census. It gives you the count of
persons who live in County R and work in County W for all counties in
the country. The MCDC has created some
custom reports based on these
files, and has created a web application that accesses the data for any U.S. state.
sf42000/
See the Census Bureau's Abstract
for a description of this data collection. The key feature of "SF4" is
the ability to get detailed tables for a long list of race/ancestry
groups. However, new threshold limitations (explained in the Abstract)
make using it for analytical purposes very problematic. The large number
of tables combined with the large number of characteristic
iterations makes these files huge.
Because of the enormous size
and complexity of this collection, we strongly recommend that users new
to the collection begin by accessing the SF4 data using the American
FactFinder application, the Data Sets option. It tends to be a lot
easier than accessing via Dexter.
sf22000/
Summary File 2, 2000 decennial census. Important for those who are
interested in detailed complete count data for special
race/hispanic/Indian tribe population groups. Less important than in
previous censuses because so much of the data here was already released
as part of SF1. The special subgroups ("characteristic
iterations") are represented on separate observations, identified by
the ID variable CharIter. See our SAS
format code showing the values of these codes. See the Census
Bureau's SF2
page for more information, including access to the data via American
Fact Finder.
Data for the population subgroups is only present
for a geographic area if it meets the threshold criteria of at least 100
people in that category.
pl942000/
Public Law 94-171 (Redistricting data). This was the first data
published based on the 2000 decennial census. Contains basic pop counts
by race/Hispanic and voting age for a wide variety of geographic levels
(including VTDs - Voting Tabulation Districts), down to census block.
The MCDC has a complete national collection of these data. For an
overview see the Readme
file.
hudcdbg/
These Community Development Block Grant data are derived from 2000
Census data by the U.S. Dept of Housing and Urban Development (HUD).
The datasets contain information regarding low and moderate
income housing down to very small (block group) geographic areas.
These numbers are used by local developers and planners wanting to
qualify for special grant funding in neighborhoods. See the HUD
web site where we went to download these data, and where you can
download it in the form of Excel spreadsheets for any state in the
country. Our collection is limited to Missouri, Illinois and Kansas.
Decennial Census 1990
[Return to top of page]
stf903x2/
1990 Summary Tape File 3: standard extract. Same basic idea
as stf903x, but this filetype was created to be comparable to the
SF3-based extract data for 2000 (filetype sf32000x). Data from these sets are used in the
dp3_2kt
trend reports.
stf903/
1990 Summary Tape File 3. Each dataset contains over 3300 cells of pre-tabulated data based on the 1990
census long-form questionnaires. Each observation contains data for a single geographic area. We have complete "A" files for Missouri, Illinois and Kansas plus a few other states; we also have the complete "C" file (national) with summaries for the country, states, counties and larger cities. And, we have the "B" file - ZIP level summaries. This filetype has been made accessible at the table level from Dexter. As with any of the census summary file filetypes, you really need to have access to the technical documentation -- available in the stf903/Docs subdirectory of this archive -- before attempting to use these data. The stf903x and stf903x2 filetypes are
derived from these files and are appropriate for quick overviews or access to frequently-used
variables. This data collection was substantially restructured in early 2005.
stf903x/
1990 Summary Tape File 3: standard extract (used for Basic
Tables web reports). These datasets are faster and friendlier to access than the much larger stf903 sets from which they are derived. See also the stf903x2 alternative filetype, above.
stf904/
These are very large 1990 census summary files, featuring large multi-dimensional tables and separate files that summzize subpopulations based on race and/or hispanic origin. We have File A and File B for Missouri only
and all of File C (the national file). We have B Table files for total pop, the 5 basic race groups (White, Black, American Indian+, Asian & PI, Other),
the 5 basic groups/non-hispanic and Hispanic (12 chariters).
We have added labels to the variables in these datasets (in December, 2005) and made them accessible at the table level via Dexter. The complete technical documentation is accessible from the Docs subdirectory.
stf901x2/
1990 Summary Tape File 1: standard extract 2: Specifically designed
to be used as the 1990 equivalent of the data in filetype sf12000x. Many
sets in this directory have been re-tabulated to 2000 census geography
to allow for direct trend reports using comparable geography.
stf901/
1990 Summary Tape File 1 is the 100-percent file on population and housing. No social and
economic indicators are associated with this file.
stf901x/
1990 Summary Tape File 1: standard extract
stf902/
1990 Summary Tape File 2.
stf420/
Note
Place of Work Destinations File. The comparable filetype in 2000 is Workflow. (The name comes
from the fact that it is based on Table 20 on Summary Tape File 4.)
pums90/
Public Use Microdata Sample, 1990. We have 5% files for Mo, Il & Ar and the 1% files for the
entire U.S.
stf9s5/
Note
1990 Special Tabulation File 5: Commuting Patterns by county
eeo90/
1990 Equal Employment Opportunity file.
stp154/
Special Tab Product 154 (1990 census): Commuting patterns by Place-tract ("Daytime population" file)
sp312/
Note
Special Product 312: 1990 County-to-county migration file
(data extracted from the special tab cd-rom. (See also stp28 for
easier-to-use extract).
stp28/
Special Tab Product 28: County to County Migration 1985-1990. One of
our "specialties".
pl9490/
1990 Public Law 94. A few variables about lots of geographic areas
(aka "redistricting file")
pl9490tx/
Public Law 94-171 (Redistricting data) from 1990 Census -
special extracts used (along with data from the pl942000 directory) in
creating PL94
Basic Trend reports.
cqr90mo/
Census Quality Review data: documents geographic errors and fixes in
1990 census geography. We have just the single txt file for state of Missouri.
Decennial Census 1980
[Return to
top of page]
stf803/
1980 Summary Tape File 3: Complete national collection with "A" files for every state
as well as a national ZIP code file and the "C" file with higher level geographies for the
entire U.S.
stf803x2/
1980 Summary Tape File 3 standard extract, revised. Same idea as the stf803x standard extract but this is by far the better collection. Content was chosen to be as compatible as possible with similar extracts from the 1990 and 2000 extracts. Complete national collection.
stf803x/
1980 Summary Tape File 3 standard extract. (Needs work - suggest using stf803x2 instead).
stf801/
1980 Summary Tape File 1
stf801x/
Extract 1980 Summary Tape File 1
marf2/
Master Area Reference File 2, 1980 . These files provide a geographic inventory for the 1980 census. Each record/observation describes the geographic codes associated with a 1980 geographic summary area, together with some basic population and housing counts, and pci (Per Capita Income - 1979). For some geographic levels there are internal point latitude-longitude coordinates and/or land areas.
The data are similar to the geographic headers portion of the 1980 Summary Tape File 1 files. Geographic units summarized are states, counties, MCDs (county subdivisions), places (cities), census tracts (BNA's), block groups and enumeration districts. Be sure to check out the extensive Readme.html file.
pums80/
Public Use MicroSample data, 1980 . Microdata data files with long-form census response data from that census. Each record/observation describes either a person or a household. A data dictionary file is included and the Tools library should be very useful for anyone wanting to access these data using SAS.
American Community Survey
[Return to top of page]
acs/
Destined to become one of the most important filetypes in the archive. The American Community Survey is being phased in over this decade and is intended to replace long-form (sample based) decennial census data by 2010. This generic directory is only for holding materials (such as the Readme page) that are about the ACS in general. Date for specific years are stored in the acs20YY directories (below) or in the acspums directory ("filetype").
acs2006/
These data were released in the summer of 2007. They are the
tabulated results of the surveys for the 2006 calendar year. Unlike the
2005 tabulations these include persons in group quarters as part of
the universe. These data are still limited to geographic entities of
65,000 or more population. Our collection includes data for the entire U.S. and includes completed
detailed (base) tables as well as profile datasets that are similar to the data found in the Census
Bureau's profile reports accessible via FactFinder.
acs2005/
Data tables from the ACS for the calendar year 2005 are summarized here. These are the first
substantial set of data tables ever to appear based on the ACS. Summaries are for geographic areas
of at least 65,000 population. The group quarters segment of the population was not covered in the 2005
survey so all figures here summarize just the household population. There are no moving averages
here, just tables based on a single year of surveys. These data were released in "waves" during the summer and fall of 2006.
acspums/
This is American Community Survey's 1% Public Use MicroSample data. These data are only of direct interest to researchers with access to and skill using a statistical software package. We have a complete national collections for 2004, 2005 and 2006.
Population Estimates
[Return to top of page]
popests/
More recent population estimates and projections from many different sources, for
many different geographic areas and units. More for Missouri than for
elsewhere but some good state and county level stuff for the entire
country. Some with historical trends, some with components of change.
These are all post-2000 estimates (along with a very small number of projections), with
one key exception. (Note: for the latest Missouri county level projections, see the moprojs filetype, just below.)
nchsbri/
This popests subdirectory contains special estimates commissioned by NCHS (National Center for Health Statistics)
using "bridged" race categories,
i.e. using race standards established by OMB in 1977 rather than the current ones established in 1997.
The complete national collection has 4 datasets per state, 2 based on 1990 intercensal estimates and 2 based on post-2000
estimates. State and county level numbers with detail by single years of age, race, sex and hispanic origin. Great raw data resource for demographer types.
moprojs/
Missouri ppulation projections at the state and county level out to the year 2030. Done by the state demographer in the Office of Administration in Jefferson City. These projections were done using the latest census results and estimates in 2008.
popests2/
More estimates, but these are outdated and of interest only for historical analyses. Most were
released by the Census Bureau during the 90's and contain data estimated as of some year or years
within that decade.
saipe/
Small Area Income & Poverty Estimates . See the Economic Indicators section.
(Does include some population estimates as well.)
Economic Indicators
[Return to top of page]
beareis/
Files from the Bureau of Economic Analysis
Regional Economic Information System (REIS). Contains time series data
on employment, income, farm income, transfer payments and an overall
economic profile for all states and counties in the U.S. A U.S. file
contains summaries for the nation and BEA regions. Updated each summer.
There is usually a 2-year lag in getting these data out. In April 2008 we completely
replaced the data collection with new data sets rebenchmarked and with new data
for 2006.
bls_la/
These are (un)employment statistics from the Bureau of Labor Statistics -- their "la" (local area) series data. We have significantly restructured the data and have added badly needed FIPS state and county codes to make the data mergeable with other statistics. Monthly and annual average employment, unemployment and unemployment rate data back to 1990 for all US (+PR) states and counties. Data goes back to 1976 for states and includes seasonally adjusted data at state level. These datasets will be updated periodically, at least once a year. (Last updated 2/07 with data thru 12/06.)
saipe/
These are small area (county and school district level) income and poverty estimates from the
HHES group at the Census Bureau. These are inter-censal estimates generated using complex
statistical methodologies. The latest estimates tend to be about 2 or 3 years old. Data are
for usually for the entire U.S.
cbp/
County Business Patterns
empwage/
Employment and wage data for Missouri. Based on ES-202 files for the
state. County level summaries for various years, Missouri only.
taxsales/
Taxable sales for Missouri counties by SIC by quarter, starting with
year 2000. Data is from the Missouri Dept of Revenue. Lots of
suppression here when you look for detailed SIC info, but the data for
total sales without SIC detail is there. One dataset per year at the
county/SIC level, and then a single summary set with just total sales by
county by year (with state totals as well). This filetype replaces the
old mosals type that we had with data from the mod to late 90's.
bankdeps/
Banking Deposits data aggregated to various Missouri geographic
levels. From FDIC
Geography/GIS
[Return to top of page]
georef/
Extensive collection of geographic reference data. A mixture of national and Missouri-specific files.
See related filetypes corrlst and mable2k (next entries) .
corrlst/
These are our geographic "correlation list" (aka "equivalency file")
datasets. They deal with how various geographic layers correspond to
each other. For example, how ZIP codes correlate with Congressional
Districts. Included (as a subdirectory) is the MABLE database used in
the MABLE/Geocorr web application. Many of these datasets (and
many more like them) can be generated using the MABLE/Geocorr
dynamic web application. Where many of these datasets may only be for
Missouri and neighboring states, MABLE/Geocorr works for the entire
country.
mable2k/
Master Area Block Level Equivalency files. This is the
database constructed for use in the Mable/Geocorr2k web application. It
is a distillation of the information contained in the geographic headers
files from Summary File 1, 2000 census. with some augmentations based on more recent TIGER line files and various other geographic sources such as CBSA codes for counties. The Missouri datasets have some extra
codes not available for the rest of the country. Most users will want to
access these data using the web application at http://mcdc2.missouri.edu/websas/geocorr2k.html.
mable98/
Similar to the mable2k data collection, but this is the
previous edition with older geographic codes. You can access these using
the original 1990 version of MABLE/Geocorr at http://mcdc2.missouri.edu/websas/geocorr90.shtml.
gics90/
1990 Geographic Identification Code Scheme (Census). Nice reference sets for basic geographic
entities as defined for the 1990 decennial census.
Compendia [Return to
top of page]
mosenior
The Missouri Senior Report, with its in-depth
analysis and county level ranking of the state of the state's elderly population.
OSEDA (the Office
of Social and Economic Data Analaysis at the University of Missouri Columbia,
an MCDC core agency) was
reponsible for the data and web site development on this project. The data used in the web site reports are
stored as part of the MCDC's data archive. You can access these data in the
mosenior data directory.
(See links under Data and Maps/Download Data Files on the MO Sr Report web site).
cntypage
The Missouri County Summary of Social and Economic Indicators was developed by OSEDA in collaboration with University of Missouri Extension
personnel in the fall of 2005. Includes key indicators used by Extension personnel. It data from the 2000 decennial
census, as well as the latest population estimates, current housing unit estiamte, key employment and personal income categories from BEA, and a host of other ites related to children (Kids Count indicators), family and health status indicators. Geographic summary units are the state, its counties and the UM Extension regions.
See the Missouri County Summary of Social and Economic Indicators web site for access to these data as formatted reports.
indctrs/
Key indicators database. Important collection of datasets that have
been created mostly by extraction of key data items from other sets in
this archive. Emphasis is on data for Missouri (the state, its counties
and various regions), and most have data for at least two points in
time. This collection of data is the basis of all reports and analyses
published by OSEDA on their web site (starting in 2002.)
kidscnt/
Kids Count is a national program sponsored by the Annie E. Casey
foundation. The data for Missouri (all we have in the archive) comes from a myriad of sources, mostly
within state government. They are all collected here and are used as the
source of the tables / charts / reports / maps etc that can be accessed
at the Missouri Kids Count Data Book Online web site.
srcount/
Senior count. This is a similar concept to Kids Count (kidscnt) but
with the focus is on the older population. We have thus far taken data mostly from the
1990 and 2000 decennial censuses. (Not to be confused with the more recent alternative mosenior filetype, which will most likely make this collection (srcount) obsolete.)
desex/
Demographic indicators extracted from the 1990 & 2000 censuses and other public sources created
specifically for the Missouri Dept of Elementary and Secondary Education (DESE). These data
are the basis for the DESE Socio-Economic Indicator Resource
web application. Summaries at various geographic levels, most of them within School District.
modotx/
The MoDOT SEIR extract was created for the Mo. Dept of Transportation for use in their
Socio-Economic Indicator Resource web-based
system (developed for MoDOT by OSEDA.) Geography is geared toward MoDOT apps but includes
RPCs, counties and places.
Other
[Return to top of page]
irsmig/
County level migration data based on IRS tax returns. We have data for the entire U.S. based on tax years
as early as 1999/2000 and as recent as 2004/2005. More data (for prior tax years back to 1983) are available at OSEDA and could be added to archive if users indicate interest.
ag2002/
Census of Agriculture, 2002. Only a few selected Tables have been converted and
placed in the MCDC Library so far. More to come if the folks at USDA ever make good on their
promise to make the data available in a resonable format for importing into our
data archive. Until then go to their web site at
www.nass.usda.gov/census/census02/.
movoters/
Data regarding Missouri voters and voting results. Most (currently all) data come from the
Missouri Secretary of State's office. There are no data on individuals that are publicly accessible in this directory.
Note:If you know what filetype you want you can
explore the data by accessing the main data directory (sorted alphabetically by filetype) at:
http://mcdc2.missouri.edu/cgi-bin/uexplore?/pub/data/
Important Note:
This application is intended for use by people wanting to
access data by querying a database. It is most commonly and
successfully used by members of the MCDC core group/affiliate
network or by end users being guided to appropriate resources (directories or
files) by such data intermediaries. It does NOT (generally)
provide direct, easy access to reports or other end-user products. Users
looking for those kinds of products/interfaces should consider other links on
the OSEDA or MCDC home pages such as Regional
Profiles, Demographic
Profile Products or OSEDA/MCDC's Missouri
County Data Map. First time users of this application should read
the Uexplore Application Description (see link at top of page) to
decide if this is the sort of access they are looking for. If so, they
should then spend some time reading the On-line Tutorial.
[Return to top of page]
|
