Decennial Census Summary Files

This page last updated: 03/06/2014
Metadata created using Minnesota Geographic Metadata Guidelines


Go to Section:
1. Overview
2. Data Quality
3. Data Organization
4. Coordinate System
5. Attributes
6. Distribution - Get Data
7. Metadata Reference

Section 1 Overview
Originator U.S. Census Bureau
Title Decennial Census Summary Files
Abstract Decennial Census Summary Files include detailed tabulations of long-form data, covering demographic, social, economic, commuting, and housing characteristics. Geographies nationwide can be obtained from Census, with disaggregate geographic detail down to Block or Block Group-level.
Purpose Decennial Census Summary Files include detailed tabulations of long-form data, covering demographic, social, economic, commuting, and housing characteristics. SF3 data are sample-based estimates, compiled from questionnaires of a sample of 1-in-6 households. SF1 data are population and housing from a "100% count." The Census Bureau attempts to survey or interview all known addresses.

Geographies nationwide can be obtained from Census, with disaggregate geographic detail down to Block or Block Group-level. Metropolitan Council's database includes summary data for counties, cities, townships, and the Twin Cities Region.

SF3 tables compiled by Census Bureau have approximately 16,000 variables. To make these user-friendly, Census statistics in Metropolitan Council's Community Profiles are recompiled by Metropolitan Council, with new field names, in order to accomplish definitional and categorical consistency between Census 1990, Census 2000, Census 2010, and American Community Survey (ACS).

If there are other data elements (variables) needed, we recommend Census's FactFinder for custom extracts of data tables for small numbers (less than 200) of geographic units. OR University of Minnesota's NHGIS DataFinder for custom extracts of data tables for complete sets of detailed geographies (minor civil divisions, Tracts, Block Groups).
Time Period of Content Date 2010
Currentness Reference 1990, 2000 and 2010.
Progress Complete
Maintenance and Update Frequency As needed
Spatial Extent of Data
Bounding Coordinates -94.012
-92.732
45.415
44.471
Place Keywords
Theme Keywords Census, demographic, social, socioeconomic
Theme Keyword Thesaurus None
Access Constraints None
Use Constraints None
Contact Person Information Todd Graham, Principal Forecaster
Metropolitan Council
390 Robert Street North
Saint Paul, MN  55101-1805
Phone: 651-602-1322
Fax: 651-602-1674
Email: todd.graham@metc.state.mn.us
Browse Graphic none available
Associated Data Sets None

Section 2 Data Quality
Attribute Accuracy Statistics produced for Decennial Census SF3 (1990 and 2000) are survey-based estimates and are subject to error. The errors derive from research design (including instrument bias, data frame, and sampling), the survey data collection (non-response bias and response errors), and processing by the Census Bureau (data coding, compilation processes, and case weighting), as well as statistical inference error and uncertainty (which are related to sample size and variance within the measured attributes).

The Decennial Census SF1 reports population and housing from a "100% count." The Census Bureau attempts to survey or interview all known addresses. Still, the data are subject to error. The errors derive from survey data collection (response errors, field follow-up for missing cases) and processing by the Census Bureau (geolocation of population and housing, data coding, compilation processes, and imputation of missing cases).
Logical Consistency The published Census statistics have been recompiled by Metropolitan Council, with new field names, in order to accomplish definitional and categorical consistency between Census 1990, Census 2000, Census 2010, and ACS.
Completeness Entire seven county geographic area is covered.
Horizontal Positional Accuracy
Lineage Historical data may be available for the following places:

Burns Township (became the city of Nowthen, July 2008)
Chaska Township (merged with the city of Chaska, January 2005)
Columbus Township (became the city of Columbus, September 2006)
Elko (merged with the city of New Market to become Elko New Market, January 2007)
Forest Lake Township (merged with the city of Forest Lake, March 2000)
Grant Township (became the city of Grant, January 1997)
New Market (merged with the city of Elko to become Elko New Market, January 2007)
New Scandia Township (became the city of Scandia, January 2007)
Norwood (merged with the city of Young America to become Norwood Young America, January 1997)
Oak Grove Township (became the city of Oak Grove, December 1993)
Young America (merged with the city of Norwood to become Norwood Young America, January 1997)

Section 3 Spatial Data Organization (not used in this metadata)

Section 4 Coordinate System
Horizontal Coordinate Scheme
Horizontal Datum
Horizontal Units

Section 5 Attributes
Overview Attributes for Chart Data (Note: Not all attributes are present in every chart):

DATASOURCE: Data source.

DATASOURCE_DESC: Data source description.

DENOMINATOR: Total for all parts of a subject area.

GEOGRAPHY: Name of the city, township or unorganized territory, e.g.
Benton Twp., Blaine.

GROUP_QUARTERS_POP: Total count of individuals residing in group
quarters. Group quarters are defined as a place where people live or
stay, in a group living arrangement, that is owned or managed by
an organization providing housing and/or services for the residents.

HOUSEHOLDS: Count of households. A household includes all the persons
who together occupy a housing unit.

HOUSING_TYPE_DESC: Type of housing.

MEASURE: Total for a part of a subject area.

POPULATION: Total number of people.

POPULATION IN HOUSEHOLDS: Number of people living in households.

QUANTITY: Total number of units.

SORT_ORDER: Allows the data to be sorted in a consistent order from
year to year.

SUBJECT_AREA: Subject area.

SUBJECT_LEVEL: Subject level.

SUBJECT_LEVEL_DESC: Subject level description.

UNIT_OF_MEASURE: HH = Households
HU - Housing units
MIN = Minutes
PCT = Percent
POP = Population
USD = U.S. dollars

USD_YR: Year of the income data.

YEAR: Year of the data.


Attributes for Tabular Data:

CO_CODE: 3 digit FIPS and state standard county ID code
003 = Anoka County
019 = Carver County
037 = Dakota County
053 = Hennepin County
123 = Ramsey County
139 = Scott County
163 = Washington County

CTU_CODE: 5 digit FIPS55 'Place' code for CTU. As of 2010 these codes
have been officially retired by the federal government. They are
replaced by the GNIS codes below. The Census Bureau will continue to
create FIPS55 Place codes for new cities and townships through the 2010
Census. After that, no new FIPS55 codes will be created. Note that for
townships that wholly incorporate into cities, the same FIPS55 code for
the former township will usually be used for the new city. Conversely,
GNIS creates a new ID for the new city.

CTU_ID: The Geographic Names Information System (GNIS) federal unique
identifier for each city, township or unorganized territory.

COCTU_ID: 11 digit identifier for the combination of county and CTU
(concatenation of CO_CODE and CTU_ID_CEN).

CTU_NAME: Name of the city, township or unorganized territory, e.g.
Benton Twp., Blaine.

SUMLEV: Census summary level of the data.

YEAR: Year of the data collection.

DATASOURCE: Data source.

DATASOURCE_DESC: Data source description.

SUBJECT_AREA: Subject area.

SUBJECT_AREA_DESC: Subject area description.

SUBJECT_LEVEL_DESC: Description of the subject level.

DENOMINATOR_LEVEL_DESC: Universe of the data.

MEASURE: Total for a part of a subject area.

DENOMINATOR: Total for all parts of a subject area.

COMMUNITY DESIGNATION: A designation of each city and township based on the overall state of development and regional issues faced by that community.


The following appear as labels or headings in tables compiled by Metropolitan Council from Census SF1 and SF3 base tables. (SF1 counts were used where possible and appropriate.) Specific tables used are in parentheses (1990 / 2000).

POPTOTAL= total population (P1 / P1);
POPINHH= population in households and not in GQ (H19 / P16);
HHTOTAL= total households (P3 / P15);

AVGHHSIZE= average household size (POPINHH, HHTOTAL);

LIVEDALONE= households with 1 person (P16, P18 / P18, P19);
MARRIEDFAMILYKIDS= family households with children and headed by a married couple (P16, P18 / P18, P19);
UNMARRIEDFAMILYKIDS= family households with children and headed by a single person or unmarried people (P16, P18 / P18, P19);
FAMILYNOKIDS= family households with no children (P16, P18 / P18, P19);
NONFAMILYHOUSEHOLD= other households that are not families and with more than 1 person (P16, P18 / P18, P19);

MALE_AGE0_4= males in this age range (P12 / P12);
MALE_AGE5_9= males in this age range (P12 / P12);
MALE_AGE10_14= males in this age range (P12 / P12);
MALE_AGE15_19= males in this age range (P12 / P12);
MALE_AGE20_24= males in this age range (P12 / P12);
MALE_AGE25_29= males in this age range (P12 / P12);
MALE_AGE30_34= males in this age range (P12 / P12);
MALE_AGE35_39= males in this age range (P12 / P12);
MALE_AGE40_44= males in this age range (P12 / P12);
MALE_AGE45_49= males in this age range (P12 / P12);
MALE_AGE50_54= males in this age range (P12 / P12);
MALE_AGE55_59= males in this age range (P12 / P12);
MALE_AGE60_64= males in this age range (P12 / P12);
MALE_AGE65_69= males in this age range (P12 / P12);
MALE_AGE70_74= males in this age range (P12 / P12);
MALE_AGE75_79= males in this age range (P12 / P12);
MALE_AGE80_84= males in this age range (P12 / P12);
MALE_AGEOVER85= males in this age range (P12 / P12);

FEMALE_AGE0_4= females in this age range (P12 / P12);
FEMALE_AGE5_9= females in this age range (P12 / P12);
FEMALE_AGE10_14= females in this age range (P12 / P12);
FEMALE_AGE15_19= females in this age range (P12 / P12);
FEMALE_AGE20_24= females in this age range (P12 / P12);
FEMALE_AGE25_29= females in this age range (P12 / P12);
FEMALE_AGE30_34= females in this age range (P12 / P12);
FEMALE_AGE35_39= females in this age range (P12 / P12);
FEMALE_AGE40_44= females in this age range (P12 / P12);
FEMALE_AGE45_49= females in this age range (P12 / P12);
FEMALE_AGE50_54= females in this age range (P12 / P12);
FEMALE_AGE55_59= females in this age range (P12 / P12);
FEMALE_AGE60_64= females in this age range (P12 / P12);
FEMALE_AGE65_69= females in this age range (P12 / P12);
FEMALE_AGE70_74= females in this age range (P12 / P12);
FEMALE_AGE75_79= females in this age range (P12 / P12);
FEMALE_AGE80_84= females in this age range (P12 / P12);
FEMALE_AGEOVER85= females in this age range (P12 / P12);

POPOVER5= population (age 5+) used as denominator in % calculations (P57 / P19 [SF3]);
POPOVER16 = population age 16+ (P12 / P14);
POPOVER18 = population age 18+ (P12 / P14);

WHITENH= population that identifies as white only and non-Hispanic (P10 / P8);
BLACKNH= population that identifies as black only and non-Hispanic (P10 / P8);
AMINDNH= population that identifies as American Indian only and non-Hispanic (P10 / P8);
ASIANNH= population that identifies as Asian/Asian-American only and non-Hispanic (P10 / P8);
PACIFICNH= population that identifies as Pacific Islander only and non-Hispanic (P10 / P8);
OTHERNH= population that identifies as other race and non-Hispanic (P10 / P8);
MULTRACENH= population that identifies as multi-racial and non-Hispanic (P10 / P8);
HISPPOP= population that identifies as Hispanic in combination with any race (P10 / P8);
NOTHISPPOP= population that identifies as non-Hispanic (P10 / P8);

POPOVER25= adult population (25 and over) used as denominator in % calculations (P57 / P37);
LESSHS= adult population that did not complete high school (P57 / P37);
HIGHSCHOOL= adult population that competed high school (P57 / P37);
SOMECOLLEGE= adult population that attended some college (P57 / P37);
ASSOCIATE= adult population that competed 2-year degree (P57 / P37);
BACHELORS= adult population that competed bachelor's degree (P57 / P37);
GRADPROF= adult population that competed post-bac graduate or professional degree (P57 / P37);

WORKDENOM= employed population used as denominator in % calculations (P49 / P30);
DROVEALONE= drive alone to work (P49 / P30);
CARPOOL= drive or ride with others to work (P49 / P30);
PUBLICTRANSIT= take public transit to work (P49 / P30);
WALKTOWORK= walk to work (P49 / P30);
OTHERCOMMUTE= commuted to work bicycling or by taxi or some other way (P49 / P30);
WORKATHOME= worked at home and did not commute (P49 / P30);

COMMUTEDENOM= employed commuters excluding 'work at home' used as denominator in % calculations (P50 / P31);
COMMUTELT10= commuted 1-9 minutes to work (P50 / P31);
COMMUTE10TO14= commuted 10-14 minutes to work (P50 / P31);
COMMUTE15TO19= commuted 15-19 minutes to work (P50 / P31);
COMMUTE20TO24= commuted 20-24 minutes to work (P50 / P31);
COMMUTE25TO29= commuted 25-29 minutes to work (P50 / P31);
COMMUTE30TO34= commuted 30-34 minutes to work (P50 / P31);
COMMUTE35TO44= commuted 35-44 minutes to work (P50 / P31);
COMMUTE45TO59= commuted 45-59 minutes to work (P50 / P31);
COMMUTE60PLUS= commuted 60 minutes or longer (P50 / P31);
AGGCOMMUTE= total minutes of commuting used as numerator (P51 / P33);
AVGCOMMUTE= mean average commute length (AGGCOMMUTE, COMMUTEDENOM);

VEHICLESINAREA = Number of vehicles available to households (H38 / H46);
HH_NOVEH= Households with 0 vehicle (H37 / H44);
HH_1VEH= Households with 1 vehicle (H37 / H44);
HH_MULTVEH= Households with 2 or more vehicles (H37 / H44);

USBORNCIT= US citizens who were born in the US or PR (P37 / P21);
FORBORNCIT= US citizens who were born abroad (P37 / P21);
FORBORNNOTCIT= Non-citizens who were born abroad (P37 / P21);

ENGLISHLANG= population (5 and over) who speak English at home (P28 / P19);
ESL_VERYWELL= population who speak another language and speak English very well (P28 / P19);
LEP= population who speak English less than very well (P28 / P19);
LEP_SPAN= subset of LEP who speak Spanish (P28 / P19);

PCI= income per capita (P114A / P82);
MEANHHINC= mean average income per household (P81, H22 / P54, H32);
MEDIANHHINC= median income per household (P80A / P53);

POPINPOVERTY = estimated population with income 0=99% of poverty threshold (P121 / P88)
POVERTYTO150 = estimated population with income in the range 100%-149% of poverty (less than 150%) (P121 / P88)
POV150_185 = estimated population with income in the range 150%=184% of poverty (less than 185%) (P121 / P88)
POPPOVDENOM = denominator population for poverty question (P121 / P88)
POV100RATE = share of population with income 0=99% of poverty threshold (P121 / P88)
POV150RATE = share of population with income 0=149% of poverty threshold (less than 150%) (P121 / P88)
POV185RATE = share of population with income 0=184% of poverty threshold (less than 185%) (P121 / P88)

HUTOTAL= estimated housing units (H2 / H3);
HUSFD= single family detached housing units (H41 / H30);
HUSFA= single family attached housing units (H41 / H30);
HU234= housing units in duplexes and 3-4 unit buildings (H41 / H30);
HUMF5= housing units in larger buildings (H41 / H30);
HUMOBILE= manufactured or mobile home units (H41 / H30);
HUOTHER= other or not elsewhere classified shelters (H41 / H30);

HOMEOWNERRATE= share of households that own their housing (H3 / H4);
OWNEROCC= owner households or owner-occupied units (H3 / H4);
RENTEROCC= renter households or renter-occupied units (H3 / H4);
VACANT= vacant housing units (H2 / H3);

MEDIANGROSSRENT= median gross rent including utilities (H43A / H63);
MEDIANHVALUE= median home value of ownership housing (H61A / H76);

COSTBURDENOWN= homeowners spending 30+ percent of household budget on housing (H58 / H96) ;
NOCOSTBURDENOWN= homeowners spending 0-29 percent of household budget on housing (H58 / H96) ;
COSTBURDENRENT= renters spending 30+ percent of household budget on housing (H51 / H73) ;
NOCOSTBURDENRENT= renters spending 0-29 percent of household budget on housing (H51 / H73) ;
HOUSINGCOSTDENOM= total households with income used as denominator in % calculations (H58, H51 / H96, H73);

*** CAUTION: In 1990 and 2000, the Census Bureau provided homeowner cost burden data only for households in single-family homes on less than 10 acres and without a business or medical office on the property. This universe, which excludes households in owner-occupied duplexes and condominiums, covered only 87% of all owner-occupied units. Relative to the Public Use Microdata Sample (which contains cost burden data for all households), cost burden estimates based on summary file data are low by about one percentage point region-wide. ***

RENTLT200= renter households with gross rent $1-199 (NA / H62);
RENT200_299= renter households with gross rent in this range (NA / H62);
RENT300_399= renter households with gross rent in this range (NA / H62);
RENT400_499= renter households with gross rent in this range (NA / H62);
RENT500_599= renter households with gross rent in this range (NA / H62);
RENT600_699= renter households with gross rent in this range (NA / H62);
RENT700_799= renter households with gross rent in this range (NA / H62);
RENT800_899= renter households with gross rent in this range (NA / H62);
RENT900_999= renter households with gross rent in this range (NA / H62);
RENT1000_1249= renter households with gross rent in this range (NA / H62);
RENT1250_1499= renter households with gross rent in this range (NA / H62);
RENT1500_1999= renter households with gross rent in this range (NA / H62);
RENT2000up= renter households with gross rent in this range (NA / H62);
RENT_DENOM= renter households with cash rent used as denominator in % calculations (NA / H62);

VALUELT40= home owners valuing their home less than $40,000 (NA / H74);
VALUE40_69= home owners valuing their home in this range (NA / H74);
VALUE70_99= home owners valuing their home in this range (NA / H74);
VALUE100_124= home owners valuing their home in this range (NA / H74);
VALUE125_149= home owners valuing their home in this range (NA / H74);
VALUE150_174= home owners valuing their home in this range (NA / H74);
VALUE175_199= home owners valuing their home in this range (NA / H74);
VALUE200_249= home owners valuing their home in this range (NA / H74);
VALUE250_299= home owners valuing their home in this range (NA / H74);
VALUE300_399= home owners valuing their home in this range (NA / H74);
VALUE400_499= home owners valuing their home in this range (NA / H74);
VALUE500_749= home owners valuing their home in this range (NA / H74);
VALUE750_999= home owners valuing their home in this range (NA / H74);
VALUE1MIL= home owners valuing their home at $1 million+ (NA / H74);
VALUE_DENOM= home owner households used as denominator in % calculations (NA / H74);

*** CAUTION: In 1990 and 2000, the Census Bureau provided the home value distribution only for single-family homes on less than 10 acres and without a business or medical office on the property. This universe, which excludes owner-occupied duplexes and condominiums, covered only 87% of all owner-occupied units. ***

HHSF= households in single family detached OR townhouse units (H22 / H32);
HH234= households in duplexes and 3-4 unit buildings (H22 / H32);
HHMF5= households in larger buildings (H22 / H32);
HHMOBILE= households in manufactured or mobile home units (H22 / H32);
HHOTHER= households in other or not elsewhere classified shelters (H22 / H32);

POPSF= population in single family detached OR townhouse units (HA47 [STF 4a] / H33);
POP234= population in duplexes and 3-4 unit buildings (HA47 [STF 4a] / H33);
POPMF5= population in larger buildings (HA47 [STF 4a] / H33);
POPMOBILE= population in manufactured or mobile home units (HA47 [STF 4a] / H33);
POPOTHER= population in other or not elsewhere classified shelters (HA47 [STF 4a] / H33);

PPHSF= average household size in single family housing (POPSF, HHSF);
PPH234= average household size in duplexes and 3-4 unit buildings (POPSF, HHSF);
PPHMF5= average household size in larger buildings (POPSF, HHSF);
PPHMOBILE= average household size in manufactured or mobile home units (POPSF, HHSF);
PPHOTHER= average household size in other or NEC shelters (POPSF, HHSF)
Detailed Citation None
Table Detail:

Section 6 Distribution
Publisher Metropolitan Council
Publication Date periodically revised
Contact Person Information Todd Graham, Principal Forecaster
Metropolitan Council
390 Robert Street North
Saint Paul, MN  55101-1805
Phone: 651-602-1322
Fax: 651-602-1674
Email: todd.graham@metc.state.mn.us
Distributor's Data Set Identifier Decennial Census Summary Files
Distribution Liability NOTICE: The data to which this notice is attached are made available pursuant to the Minnesota Government Data Practices Act (Minnesota Statutes Chapter 13). THE DATA ARE PROVIDED TO YOU AS IS AND WITHOUT ANY WARRANTY AS TO THEIR PERFORMANCE, MERCHANTABILITY, OR FITNESS FOR ANY PARTICULAR PURPOSE. The Metropolitan Council developed some of the data for its own internal business purposes and is redistributing data developed by other data providers (e.g., the U.S. Census Bureau and the Minnesota Department of Employment and Economic Development). The Metropolitan Council does not represent or warrant that the data or the data documentation are error-free, complete, current, or accurate. You are responsible for any consequences resulting from your use of the data or your reliance on the data. You should consult the data documentation for these particular data to determine the limitations of the data. If you transmit or provide the data (or any portion of it) to another user, it is recommended that the data include a copy of this disclaimer and this metadata.
Ordering Instructions This entire dataset is available on the internet by clicking below after 'Online Linkage'. Doing so will tell your browser to download a 'ZIP' file which will contain the following:

- csv file
- metadata for the dataset (.htm)
- NOTICE.RTF, an important notice about this dataset that can be read by any word processing software.

This dataset can also be viewed and downloaded using the Download Tabular Data tool at http://stats.metc.state.mn.us/data_download/DD_start.aspx.
Online Linkage None available

Section 7 Metadata Reference
Metadata Date 03/06/2014
Contact Person Information Todd Graham, Principal Forecaster
Metropolitan Council
390 Robert Street North
Saint Paul, MN  55101-1805
Phone: 651-602-1322
Fax: 651-602-1674
Email: todd.graham@metc.state.mn.us
Metadata Standard Name Minnesota Geographic Metadata Guidelines
Metadata Standard Version 1.2
Metadata Standard Online Linkage http://www.gis.state.mn.us/stds/metadata.htm


This page last updated: 03/06/2014
Go back to top