SAUS Update Profile Description

Field Name Field Type Description
pbkey varchar(50) Unique ID for an addressable location
up_pop2k Float 2000 Total population
up_popby Float 2010 Total population
up_popcy Float 2020 Total population
up_pop5y Float 2025 Total population
up_p0004cx Float 2020 % Total population: Under 5 years
up_p0509cx Float 2020 % Total population: 5 to 9 years
up_p1014cx Float 2020 % Total population: 10 to 14 years
up_p1519cx Float 2020 % Total population: 15 to 19 years
up_p2024cx Float 2020 % Total population: 20 to 24 years
up_p2534cx Float 2020 % Total population: 25 to 34 years
up_p3544cx Float 2020 % Total population: 35 to 44 years
up_p4554cx Float 2020 % Total population: 45 to 54 years
up_p5559cx Float 2020 % Total population: 55 to 59 years
up_p6064cx Float 2020 % Total population: 60 to 64 years
up_p6574cx Float 2020 % Total population: 65 to 74 years
up_p7584cx Float 2020 % Total population: 75 to 84 years
up_p85pcx Float 2020 % Total population: 85 years and over
up_pmedcy Float 2020 % Total population: Median age
up_malecy Float 2020 Male population
up_malecx Float 2020 % Male population
up_m0004cx Float 2020 % Male population: Under 5 years
up_m0509cx Float 2020 % Male population: 5 to 9 years
up_m1014cx Float 2020 % Male population: 10 to 14 years
up_m1519cx Float 2020 % Male population: 15 to 19 years
up_m2024cx Float 2020 % Male population: 20 to 24 years
up_m2534cx Float 2020 % Male population: 25 to 34 years
up_m3544cx Float 2020 % Male population: 35 to 44 years
up_m4554cx Float 2020 % Male population: 45 to 54 years
up_m5559cx Float 2020 % Male population: 55 to 59 years
up_m6064cx Float 2020 % Male population: 60 to 64 years
up_m6574cx Float 2020 % Male population: 65 to 74 years
up_m7584cx Float 2020 % Male population: 75 to 84 years
up_m85pcx Float 2020 % Male population: 85 years and over
up_mmedcy Float 2020 Male population: Median age
up_femalecy Float 2020 Female population
up_femalecx Float 2020 % Female population
up_f0004cx Float 2020 % Female population: Under 5 years
up_f0509cx Float 2020 % Female population: 5 to 9 years
up_f1014cx Float 2020 % Female population: 10 to 14 years
up_f1519cx Float 2020 % Female population: 15 to 19 years
up_f2024cx Float 2020 % Female population: 20 to 24 years
up_f2534cx Float 2020 % Female population: 25 to 34 years
up_f3544cx Float 2020 % Female population: 35 to 44 years
up_f4554cx Float 2020 % Female population: 45 to 54 years
up_f5559cx Float 2020 % Female population: 55 to 59 years
up_f6064cx Float 2020 % Female population: 60 to 64 years
up_f6574cx Float 2020 % Female population: 65 to 74 years
up_f7584cx Float 2020 % Female population: 75 to 84 years
up_f85pcx Float 2020 % Female population: 85 years and over
up_fmedcy Integer 2020 Female population: Median age
up_whtpopcx Float 2020 % White alone
up_blkpopcx Float 2020 % Black or African American alone
up_indpopcx Float 2020 % American Indian and Alaska Native alone
up_asnpopcx Float 2020 % Asian alone
up_hpipopcx Float 2020 % Native Hawaiian and OPI alone
up_othpopcx Float 2020 % Some Other Race alone
up_twopopcx Float 2020 % Two or More Races
up_hsppopcx Float 2020 % Hispanic
up_nhpopcx Float 2020 % Not Hispanic
up_ms1p15pcy Float 2020 Marital Status: Population 15 years and over
up_ms2pnmcx Float 2020 % Marital Status: Population 15 years and over - Never married
up_ms3pmarcx Float 2020 % Marital Status: Population 15 years and over - Now married
up_ms4psepcx Float 2020 % Marital Status: Population 15 years and over - Separated
up_ms5pwidcx Float 2020 % Marital Status: Population 15 years and over - Widowed
up_ms6pdivcx Float 2020 % Marital Status: Population 15 years and over - Divorced
up_wrkcy Float 2020 Workers 16 years and over
up_wrknahcy Float 2020 Workers 16 years and over who did not work at home
up_wrknahcx Float 2020 % Workers 16 years and over who did not work at home
up_wrkahcx Float 2020 % Workers 16 years and over who work at home
up_mt1dacx Float 2020 % Means of transportation: Car, truck, or van - Drove alone
up_mt2cpcx Float 2020 % Means of transportation: Car, truck, or van - Carpooled
up_mt3buscx Float 2020 % Means of transportation: Public transportation
up_mt4walkcx Float 2020 % Means of transportation: Walked
up_mt5tmbocx Float 2020 % Means of transportation: Taxicab, motorcycle, bicycle, or other means
up_tt0009cx Float 2020 % Travel time: Less than 10 minutes
up_tt1014cx Float 2020 % Travel time: 10 to 14 minutes
up_tt1519cx Float 2020 % Travel time: 15 to 19 minutes
up_tt2024cx Float 2020 % Travel time: 20 to 24 minutes
up_tt2529cx Float 2020 % Travel time: 25 to 29 minutes
up_tt3034cx Float 2020 % Travel time: 30 to 34 minutes
up_tt3544cx Float 2020 % Travel time: 35 to 44 minutes
up_tt4559cx Float 2020 % Travel time: 45 to 59 minutes
up_tt60pcx Float 2020 % Travel time: 60 or more minutes
up_ttavgcy Integer 2020 Travel time: Average (in minutes)
up_ed1p25pcy Float 2020 Educational Attainment: Population 25 years and over
up_ed2ltgr9cx Float 2020 % Educational Attainment: Less than 9th grade
up_ed3gr912cx Float 2020 % Educational Attainment: 9th to 12th grade, no diploma
up_ed4hschcx Float 2020 % Educational Attainment: High school graduate, GED, or alternative
up_ed5scndcx Float 2020 % Educational Attainment: Some college, no degree
up_ed6assocx Float 2020 % Educational Attainment: Associate's degree
up_ed7bachcx Float 2020 % Educational Attainment: Bachelor's degree
up_ed8gradcx Float 2020 % Educational Attainment: Graduate or professional degree
up_ecpop16pcy Float 2020 Civilian employed population 16 years and over
up_in01agrcx Float 2020 % Industry: Agriculture, forestry, fishing and hunting, and mining
up_in02cnstcx Float 2020 % Industry: Construction
up_in03mfgcx Float 2020 % Industry: Manufacturing
up_in04wtrdcx Float 2020 % Industry: Wholesale trade
up_in05rtrdcx Float 2020 % Industry: Retail trade
up_in06trancx Float 2020 % Industry: Transportation and warehousing, and utilities
up_in07infocx Float 2020 % Industry: Information
up_in08firecx Float 2020 % Industry: Finance, insurance, real estate, and rental and leasing
up_in09profcx Float 2020 % Industry: Professional, scientific, and management
up_in10educcx Float 2020 % Industry: Educational services, health care and social assistance
up_in11artscx Float 2020 % Industry: Arts, entertainment, accommodation and food services
up_in12othscx Float 2020 % Industry: Other services, except public administration
up_in13publcx Float 2020 % Industry: Public administration
up_oc1mbsacx Float 2020 % Occupation: Management, business, science, and arts occupations
up_oc2servcx Float 2020 % Occupation: Service occupations
up_oc3salecx Float 2020 % Occupation: Sales and office occupations
up_oc4nrcmcx Float 2020 % Occupation: Natural resources, construction, and maintenance occupations
up_oc5ptmmcx Float 2020 % Occupation: Production, transportation, and material moving occupations
up_oc6wccx Float 2020 % Occupation: White collar
up_oc7bccx Float 2020 % Occupation: Blue collar
up_hh2k Float 2000 Households
up_hhby Float 2010 Households
up_hhcy Float 2020 Households
up_hh5y Float 2021 Households
up_hhpopcy Float 2020 Population in households
up_avghhszcy Integer 2020 Average household size
up_gqpopcy Float 2020 Population in group quarters
up_hhs1percx Float 2020 % Households: 1-person household
up_hhs2percx Float 2020 % Households: 2-person household
up_hhs3percx Float 2020 % Households: 3-person household
up_hhs4percx Float 2020 % Households: 4-or-more-person household
up_owncy Float 2020 Owner occupied housing units
up_owncx Float 2020 % Owner occupied housing units
up_rntcy Float 2020 Renter occupied housing units
up_rntcx Float 2020 % Renter occupied housing units
up_hh1whtcx Float 2020 % Householder who is White alone
up_hh2blkcx Float 2020 % Householder who is Black or African American alone
up_hh3indcx Float 2020 % Householder who is American Indian and Alaska Native alone
up_hh4asncx Float 2020 % Householder who is Asian alone
up_hh5hpicx Float 2020 % Householder who is Native Hawaiian and OPI alone
up_hh6othcx Float 2020 % Householder who is Some Other Race alone
up_hh7twocx Float 2020 % Householder who is Two or More Races
up_nhhhcx Float 2020 % Not Hispanic householder
up_hsphhcx Float 2020 % Hispanic householder
up_hhu01cx Float 2020 % Occupied units in structure: 1, detached or attached
up_hhu0209cx Float 2020 % Occupied units in structure: 2 to 9
up_hhu10pcx Float 2020 % Occupied units in structure: 10 or more
up_hhuothcx Float 2020 % Occupied units in structure: Mobile home and all other types of units
up_hhf1gascx Float 2020 % House heating fuel: Gas
up_hhf2eleccx Float 2020 % House heating fuel: Electricity
up_hhf3oilcx Float 2020 % House heating fuel: Fuel oil, kerosene, etc.
up_hhf4othcx Float 2020 % House heating fuel: All other fuels and no fuel used
up_hhveh0cx Float 2020 % Households: No vehicle available
up_hhveh1cx Float 2020 % Households: 1 vehicle available
up_hhveh2cx Float 2020 % Households: 2 vehicles available
up_hhveh3pcx Float 2020 % Households: 3 or more vehicles available
up_hhvavgcy Float 2020 Households: Number of vehicles available - Average
up_crcashcx Float 2020 % Contract rent: With cash rent
up_cr0000cx Float 2020 % Contract rent: Less than $200
up_cr0200cx Float 2020 % Contract rent: $200 to $299
up_cr0300cx Float 2020 % Contract rent: $300 to $499
up_cr0500cx Float 2020 % Contract rent: $500 to $749
up_cr0750cx Float 2020 % Contract rent: $750 to $999
up_cr1000pcx Float 2020 % Contract rent: $1,000 or more
up_crnocashcx Float 2020 % Contract rent: No cash rent
up_crmedcy Float 2020 Contract rent: Median
up_cravgcy Float 2020 Contract rent: Average
up_hv0000kcx Float 2020 % Home value: Less than $50,000
up_hv0050kcx Float 2020 % Home value: $50,000 to $99,999
up_hv0100kcx Float 2020 % Home value: $100,000 to $149,999
up_hv0150kcx Float 2020 % Home value: $150,000 to $199,999
up_hv0200kcx Float 2020 % Home value: $200,000 to $299,999
up_hv0300kcx Float 2020 % Home value: $300,000 to $499,999
up_hv0500kcx Float 2020 % Home value: $500,000 to $999,999
up_hv1000kpcx Float 2020 % Home value: $1,000,000 or more
up_hvmedcy Float 2020 Home value: Median
up_hvavgcy Float 2020 Home value: Average
up_hha1534cx Float 2020 % Householder 15 to 34 years
up_hha3544cx Float 2020 % Householder 35 to 44 years
up_hha4554cx Float 2020 % Householder 45 to 54 years
up_hha5564cx Float 2020 % Householder 55 to 64 years
up_hha6574cx Float 2020 % Householder 65 to 74 years
up_hha7584cx Float 2020 % Householder 75 to 84 years
up_hha85pcx Float 2020 % Householder 85 years and over
up_hi000kcx Float 2020 % Household income: Less than $10,000
up_hi010kcx Float 2020 % Household income: $10,000 to $14,999
up_hi015kcx Float 2020 % Household income: $15,000 to $24,999
up_hi025kcx Float 2020 % Household income: $25,000 to $34,999
up_hi035kcx Float 2020 % Household income: $35,000 to $49,999
up_hi050kcx Float 2020 % Household income: $50,000 to $74,999
up_hi075kcx Float 2020 % Household income: $75,000 to $99,999
up_hi100kcx Float 2020 % Household income: $100,000 to $149,999
up_hi150kcx Float 2020 % Household income: $150,000 to $199,999
up_hi200pcx Float 2020 % Household income: $200,000 or more
up_himedcy Float 2020 Household income: Median
up_hiavgcy Float 2020 Household income: Average