SAUS Update Profile Description
| Field Name | Field Type | Description |
|---|---|---|
| pbkey | char(12) | 2017 Geography Layer Code Note: This field represents the Code value only but,
it is named as a "pbkey" to support the Spectrum Platform while loading the
data.
|
| pop2k | Float | 2000 Total population |
| popby | Float | 2010 Total population |
| popcy | Float | 2017 Total population |
| pop5y | Float | 2022 Total population |
| p0004cx | Float | 2017 % Total population: Under 5 years |
| p0509cx | Float | 2017 % Total population: 5 to 9 years |
| p1014cx | Float | 2017 % Total population: 10 to 14 years |
| p1519cx | Float | 2017 % Total population: 15 to 19 years |
| p2024cx | Float | 2017 % Total population: 20 to 24 years |
| p2534cx | Float | 2017 % Total population: 25 to 34 years |
| p3544cx | Float | 2017 % Total population: 35 to 44 years |
| p4554cx | Float | 2017 % Total population: 45 to 54 years |
| p5559cx | Float | 2017 % Total population: 55 to 59 years |
| p6064cx | Float | 2017 % Total population: 60 to 64 years |
| p6574cx | Float | 2017 % Total population: 65 to 74 years |
| p7584cx | Float | 2017 % Total population: 75 to 84 years |
| p85pcx | Float | 2017 % Total population: 85 years and over |
| pmedcy | Float | 2017 % Total population: Median age |
| malecy | Float | 2017 Male population |
| malecx | Float | 2017 % Male population |
| m0004cx | Float | 2017 % Male population: Under 5 years |
| m0509cx | Float | 2017 % Male population: 5 to 9 years |
| m1014cx | Float | 2017 % Male population: 10 to 14 years |
| m1519cx | Float | 2017 % Male population: 15 to 19 years |
| m2024cx | Float | 2017 % Male population: 20 to 24 years |
| m2534cx | Float | 2017 % Male population: 25 to 34 years |
| m3544cx | Float | 2017 % Male population: 35 to 44 years |
| m4554cx | Float | 2017 % Male population: 45 to 54 years |
| m5559cx | Float | 2017 % Male population: 55 to 59 years |
| m6064cx | Float | 2017 % Male population: 60 to 64 years |
| m6574cx | Float | 2017 % Male population: 65 to 74 years |
| m7584cx | Float | 2017 % Male population: 75 to 84 years |
| m85pcx | Float | 2017 % Male population: 85 years and over |
| mmedcy | Float | 2017 Male population: Median age |
| femalecy | Float | 2017 Female population |
| femalecx | Float | 2017 % Female population |
| f0004cx | Float | 2017 % Female population: Under 5 years |
| f0509cx | Float | 2017 % Female population: 5 to 9 years |
| f1014cx | Float | 2017 % Female population: 10 to 14 years |
| f1519cx | Float | 2017 % Female population: 15 to 19 years |
| f2024cx | Float | 2017 % Female population: 20 to 24 years |
| f2534cx | Float | 2017 % Female population: 25 to 34 years |
| f3544cx | Float | 2017 % Female population: 35 to 44 years |
| f4554cx | Float | 2017 % Female population: 45 to 54 years |
| f5559cx | Float | 2017 % Female population: 55 to 59 years |
| f6064cx | Float | 2017 % Female population: 60 to 64 years |
| f6574cx | Float | 2017 % Female population: 65 to 74 years |
| f7584cx | Float | 2017 % Female population: 75 to 84 years |
| f85pcx | Float | 2017 % Female population: 85 years and over |
| fmedcy | Integer | 2017 Female population: Median age |
| whtpopcx | Float | 2017 % White alone |
| blkpopcx | Float | 2017 % Black or African American alone |
| indpopcx | Float | 2017 % American Indian and Alaska Native alone |
| asnpopcx | Float | 2017 % Asian alone |
| hpipopcx | Float | 2017 % Native Hawaiian and OPI alone |
| othpopcx | Float | 2017 % Some Other Race alone |
| twopopcx | Float | 2017 % Two or More Races |
| hsppopcx | Float | 2017 % Hispanic |
| nhpopcx | Float | 2017 % Not Hispanic |
| ms1p15pcy | Float | 2017 Marital Status: Population 15 years and over |
| ms2pnmcx | Float | 2017 % Marital Status: Population 15 years and over - Never married |
| ms3pmarcx | Float | 2017 % Marital Status: Population 15 years and over - Now married |
| ms4psepcx | Float | 2017 % Marital Status: Population 15 years and over - Separated |
| ms5pwidcx | Float | 2017 % Marital Status: Population 15 years and over - Widowed |
| ms6pdivcx | Float | 2017 % Marital Status: Population 15 years and over - Divorced |
| wrkcy | Float | 2017 Workers 16 years and over |
| wrknahcy | Float | 2017 Workers 16 years and over who did not work at home |
| wrknahcx | Float | 2017 % Workers 16 years and over who did not work at home |
| wrkahcx | Float | 2017 % Workers 16 years and over who work at home |
| mt1dacx | Float | 2017 % Means of transportation: Car, truck, or van - Drove alone |
| mt2cpcx | Float | 2017 % Means of transportation: Car, truck, or van - Carpooled |
| mt3buscx | Float | 2017 % Means of transportation: Public transportation |
| mt4walkcx | Float | 2017 % Means of transportation: Walked |
| mt5tmbocx | Float | 2017 % Means of transportation: Taxicab, motorcycle, bicycle, or other means |
| tt0009cx | Float | 2017 % Travel time: Less than 10 minutes |
| tt1014cx | Float | 2017 % Travel time: 10 to 14 minutes |
| tt1519cx | Float | 2017 % Travel time: 15 to 19 minutes |
| tt2024cx | Float | 2017 % Travel time: 20 to 24 minutes |
| tt2529cx | Float | 2017 % Travel time: 25 to 29 minutes |
| tt3034cx | Float | 2017 % Travel time: 30 to 34 minutes |
| tt3544cx | Float | 2017 % Travel time: 35 to 44 minutes |
| tt4559cx | Float | 2017 % Travel time: 45 to 59 minutes |
| tt60pcx | Float | 2017 % Travel time: 60 or more minutes |
| ttavgcy | Integer | 2017 Travel time: Average (in minutes) |
| ed1p25pcy | Float | 2017 Educational Attainment: Population 25 years and over |
| ed2ltgr9cx | Float | 2017 % Educational Attainment: Less than 9th grade |
| ed3gr912cx | Float | 2017 % Educational Attainment: 9th to 12th grade, no diploma |
| ed4hschcx | Float | 2017 % Educational Attainment: High school graduate, GED, or alternative |
| ed5scndcx | Float | 2017 % Educational Attainment: Some college, no degree |
| ed6assocx | Float | 2017 % Educational Attainment: Associate's degree |
| ed7bachcx | Float | 2017 % Educational Attainment: Bachelor's degree |
| ed8gradcx | Float | 2017 % Educational Attainment: Graduate or professional degree |
| ecpop16pcy | Float | 2017 Civilian employed population 16 years and over |
| in01agrcx | Float | 2017 % Industry: Agriculture, forestry, fishing and hunting, and mining |
| in02cnstcx | Float | 2017 % Industry: Construction |
| in03mfgcx | Float | 2017 % Industry: Manufacturing |
| in04wtrdcx | Float | 2017 % Industry: Wholesale trade |
| in05rtrdcx | Float | 2017 % Industry: Retail trade |
| in06trancx | Float | 2017 % Industry: Transportation and warehousing, and utilities |
| in07infocx | Float | 2017 % Industry: Information |
| in08firecx | Float | 2017 % Industry: Finance, insurance, real estate, and rental and leasing |
| in09profcx | Float | 2017 % Industry: Professional, scientific, and management |
| in10educcx | Float | 2017 % Industry: Educational services, health care and social assistance |
| in11artscx | Float | 2017 % Industry: Arts, entertainment, accommodation and food services |
| in12othscx | Float | 2017 % Industry: Other services, except public administration |
| in13publcx | Float | 2017 % Industry: Public administration |
| oc1mbsacx | Float | 2017 % Occupation: Management, business, science, and arts occupations |
| oc2servcx | Float | 2017 % Occupation: Service occupations |
| oc3salecx | Float | 2017 % Occupation: Sales and office occupations |
| oc4nrcmcx | Float | 2017 % Occupation: Natural resources, construction, and maintenance occupations |
| oc5ptmmcx | Float | 2017 % Occupation: Production, transportation, and material moving occupations |
| oc6wccx | Float | 2017 % Occupation: White collar |
| oc7bccx | Float | 2017 % Occupation: Blue collar |
| hh2k | Float | 2000 Households |
| hhby | Float | 2010 Households |
| hhcy | Float | 2017 Households |
| hh5y | Float | 2021 Households |
| hhpopcy | Float | 2017 Population in households |
| avghhszcy | Integer | 2017 Average household size |
| gqpopcy | Float | 2017 Population in group quarters |
| hhs1percx | Float | 2017 % Households: 1-person household |
| hhs2percx | Float | 2017 % Households: 2-person household |
| hhs3percx | Float | 2017 % Households: 3-person household |
| hhs4percx | Float | 2017 % Households: 4-or-more-person household |
| owncy | Float | 2017 Owner occupied housing units |
| owncx | Float | 2017 % Owner occupied housing units |
| rntcy | Float | 2017 Renter occupied housing units |
| rntcx | Float | 2017 % Renter occupied housing units |
| hh1whtcx | Float | 2017 % Householder who is White alone |
| hh2blkcx | Float | 2017 % Householder who is Black or African American alone |
| hh3indcx | Float | 2017 % Householder who is American Indian and Alaska Native alone |
| hh4asncx | Float | 2017 % Householder who is Asian alone |
| hh5hpicx | Float | 2017 % Householder who is Native Hawaiian and OPI alone |
| hh6othcx | Float | 2017 % Householder who is Some Other Race alone |
| hh7twocx | Float | 2017 % Householder who is Two or More Races |
| nhhhcx | Float | 2017 % Not Hispanic householder |
| hsphhcx | Float | 2017 % Hispanic householder |
| hhu01cx | Float | 2017 % Occupied units in structure: 1, detached or attached |
| hhu0209cx | Float | 2017 % Occupied units in structure: 2 to 9 |
| hhu10pcx | Float | 2017 % Occupied units in structure: 10 or more |
| hhuothcx | Float | 2017 % Occupied units in structure: Mobile home and all other types of units |
| hhf1gascx | Float | 2017 % House heating fuel: Gas |
| hhf2eleccx | Float | 2017 % House heating fuel: Electricity |
| hhf3oilcx | Float | 2017 % House heating fuel: Fuel oil, kerosene, etc. |
| hhf4othcx | Float | 2017 % House heating fuel: All other fuels and no fuel used |
| hhveh0cx | Float | 2017 % Households: No vehicle available |
| hhveh1cx | Float | 2017 % Households: 1 vehicle available |
| hhveh2cx | Float | 2017 % Households: 2 vehicles available |
| hhveh3pcx | Float | 2017 % Households: 3 or more vehicles available |
| hhvavgcy | Float | 2017 Households: Number of vehicles available - Average |
| crcashcx | Float | 2017 % Contract rent: With cash rent |
| cr0000cx | Float | 2017 % Contract rent: Less than $200 |
| cr0200cx | Float | 2017 % Contract rent: $200 to $299 |
| cr0300cx | Float | 2017 % Contract rent: $300 to $499 |
| cr0500cx | Float | 2017 % Contract rent: $500 to $749 |
| cr0750cx | Float | 2017 % Contract rent: $750 to $999 |
| cr1000pcx | Float | 2017 % Contract rent: $1,000 or more |
| crnocashcx | Float | 2017 % Contract rent: No cash rent |
| crmedcy | Float | 2017 Contract rent: Median |
| cravgcy | Float | 2017 Contract rent: Average |
| hv0000kcx | Float | 2017 % Home value: Less than $50,000 |
| hv0050kcx | Float | 2017 % Home value: $50,000 to $99,999 |
| hv0100kcx | Float | 2017 % Home value: $100,000 to $149,999 |
| hv0150kcx | Float | 2017 % Home value: $150,000 to $199,999 |
| hv0200kcx | Float | 2017 % Home value: $200,000 to $299,999 |
| hv0300kcx | Float | 2017 % Home value: $300,000 to $499,999 |
| hv0500kcx | Float | 2017 % Home value: $500,000 to $999,999 |
| hv1000kpcx | Float | 2017 % Home value: $1,000,000 or more |
| hvmedcy | Float | 2017 Home value: Median |
| hvavgcy | Float | 2017 Home value: Average |
| hha1534cx | Float | 2017 % Householder 15 to 34 years |
| hha3544cx | Float | 2017 % Householder 35 to 44 years |
| hha4554cx | Float | 2017 % Householder 45 to 54 years |
| hha5564cx | Float | 2017 % Householder 55 to 64 years |
| hha6574cx | Float | 2017 % Householder 65 to 74 years |
| hha7584cx | Float | 2017 % Householder 75 to 84 years |
| hha85pcx | Float | 2017 % Householder 85 years and over |
| hi000kcx | Float | 2017 % Household income: Less than $10,000 |
| hi010kcx | Float | 2017 % Household income: $10,000 to $14,999 |
| hi015kcx | Float | 2017 % Household income: $15,000 to $24,999 |
| hi025kcx | Float | 2017 % Household income: $25,000 to $34,999 |
| hi035kcx | Float | 2017 % Household income: $35,000 to $49,999 |
| hi050kcx | Float | 2017 % Household income: $50,000 to $74,999 |
| hi075kcx | Float | 2017 % Household income: $75,000 to $99,999 |
| hi100kcx | Float | 2017 % Household income: $100,000 to $149,999 |
| hi150kcx | Float | 2017 % Household income: $150,000 to $199,999 |
| hi200pcx | Float | 2017 % Household income: $200,000 or more |
| himedcy | Float | 2017 Household income: Median |
| hiavgcy | Float | 2017 Household income: Average |