Dataset1: SAUS POP1 BY 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.
pop_ds1_by_TYPE char(4) 2017 Geography Type (represents Block Group (BG) only)
pop_ds1_by_whtpopby integer 2010 White alone
pop_ds1_by_blkpopby integer 2010 Black or African American alone
pop_ds1_by_indpopby integer 2010 American Indian and Alaska Native alone
pop_ds1_by_asnpopby integer 2010 Asian alone
pop_ds1_by_hpipopby integer 2010 Native Hawaiian and OPI alone
pop_ds1_by_othpopby integer 2010 Some Other Race alone
pop_ds1_by_twopopby integer 2010 Two or More Races
pop_ds1_by_hsppopby integer 2010 Hispanic
pop_ds1_by_nhpopby integer 2010 Not Hispanic
pop_ds1_by_nhp1whtby integer 2010 Not Hispanic: White alone
pop_ds1_by_nhp2blkby integer 2010 Not Hispanic: Black or African American alone
pop_ds1_by_nhp3indby integer 2010 Not Hispanic: American Indian and Alaska Native alone
pop_ds1_by_nhp4asnby integer 2010 Not Hispanic: Asian alone
pop_ds1_by_nhp5hpiby integer 2010 Not Hispanic: Native Hawaiian and OPI alone
pop_ds1_by_nhp6othby integer 2010 Not Hispanic: Some Other Race alone
pop_ds1_by_nhp7twoby integer 2010 Not Hispanic: Two or More Races
pop_ds1_by_hsp1whtby integer 2010 Hispanic: White alone
pop_ds1_by_hsp2blkby integer 2010 Hispanic: Black or African American alone
pop_ds1_by_hsp3indby integer 2010 Hispanic: American Indian and Alaska Native alone
pop_ds1_by_hsp4asnby integer 2010 Hispanic: Asian alone
pop_ds1_by_hsp5hpiby integer 2010 Hispanic: Native Hawaiian and OPI alone
pop_ds1_by_hsp6othby integer 2010 Hispanic: Some Other Race alone
pop_ds1_by_hsp7twoby integer 2010 Hispanic: Two or More Races
pop_ds1_by_popby integer 2010 Total population
pop_ds1_by_p0004by integer 2010 Total population: Under 5 years
pop_ds1_by_p0509by integer 2010 Total population: 5 to 9 years
pop_ds1_by_p1014by integer 2010 Total population: 10 to 14 years
pop_ds1_by_p1519by integer 2010 Total population: 15 to 19 years
pop_ds1_by_p2024by integer 2010 Total population: 20 to 24 years
pop_ds1_by_p2529by integer 2010 Total population: 25 to 29 years
pop_ds1_by_p3034by integer 2010 Total population: 30 to 34 years
pop_ds1_by_p3539by integer 2010 Total population: 35 to 39 years
pop_ds1_by_p4044by integer 2010 Total population: 40 to 44 years
pop_ds1_by_p4549by integer 2010 Total population: 45 to 49 years
pop_ds1_by_p5054by integer 2010 Total population: 50 to 54 years
pop_ds1_by_p5559by integer 2010 Total population: 55 to 59 years
pop_ds1_by_p6064by integer 2010 Total population: 60 to 64 years
pop_ds1_by_p6569by integer 2010 Total population: 65 to 69 years
pop_ds1_by_p7074by integer 2010 Total population: 70 to 74 years
pop_ds1_by_p7579by integer 2010 Total population: 75 to 79 years
pop_ds1_by_p8084by integer 2010 Total population: 80 to 84 years
pop_ds1_by_p85pby integer 2010 Total population: 85 years and over
pop_ds1_by_pmedby float 2010 Total population: Median age
pop_ds1_by_padultby integer 2010 Total population: 18 years and over
pop_ds1_by_pamedby float 2010 Total population: 18 years and over median age
pop_ds1_by_p1819by integer 2010 Total population: 18 to 19 years
pop_ds1_by_maleby integer 2010 Male population
pop_ds1_by_m0004by integer 2010 Male population: Under 5 years
pop_ds1_by_m0509by integer 2010 Male population: 5 to 9 years
pop_ds1_by_m1014by integer 2010 Male population: 10 to 14 years
pop_ds1_by_m1519by integer 2010 Male population: 15 to 19 years
pop_ds1_by_m2024by integer 2010 Male population: 20 to 24 years
pop_ds1_by_m2529by integer 2010 Male population: 25 to 29 years
pop_ds1_by_m3034by integer 2010 Male population: 30 to 34 years
pop_ds1_by_m3539by integer 2010 Male population: 35 to 39 years
pop_ds1_by_m4044by integer 2010 Male population: 40 to 44 years
pop_ds1_by_m4549by integer 2010 Male population: 45 to 49 years
pop_ds1_by_m5054by integer 2010 Male population: 50 to 54 years
pop_ds1_by_m5559by integer 2010 Male population: 55 to 59 years
pop_ds1_by_m6064by integer 2010 Male population: 60 to 64 years
pop_ds1_by_m6569by integer 2010 Male population: 65 to 69 years
pop_ds1_by_m7074by integer 2010 Male population: 70 to 74 years
pop_ds1_by_m7579by integer 2010 Male population: 75 to 79 years
pop_ds1_by_m8084by integer 2010 Male population: 80 to 84 years
pop_ds1_by_m85pby integer 2010 Male population: 85 years and over
pop_ds1_by_mmedby float 2010 Male population: Median age
pop_ds1_by_madultby integer 2010 Male population: 18 years and over
pop_ds1_by_mamedby float 2010 Male population: 18 years and over median age
pop_ds1_by_m1819by integer 2010 Male population: 18 to 19 years
pop_ds1_by_femaleby integer 2010 Female population
pop_ds1_by_f0004by integer 2010 Female population: Under 5 years
pop_ds1_by_f0509by integer 2010 Female population: 5 to 9 years
pop_ds1_by_f1014by integer 2010 Female population: 10 to 14 years
pop_ds1_by_f1519by integer 2010 Female population: 15 to 19 years
pop_ds1_by_f2024by integer 2010 Female population: 20 to 24 years
pop_ds1_by_f2529by integer 2010 Female population: 25 to 29 years
pop_ds1_by_f3034by integer 2010 Female population: 30 to 34 years
pop_ds1_by_f3539by integer 2010 Female population: 35 to 39 years
pop_ds1_by_f4044by integer 2010 Female population: 40 to 44 years
pop_ds1_by_f4549by integer 2010 Female population: 45 to 49 years
pop_ds1_by_f5054by integer 2010 Female population: 50 to 54 years
pop_ds1_by_f5559by integer 2010 Female population: 55 to 59 years
pop_ds1_by_f6064by integer 2010 Female population: 60 to 64 years
pop_ds1_by_f6569by integer 2010 Female population: 65 to 69 years
pop_ds1_by_f7074by integer 2010 Female population: 70 to 74 years
pop_ds1_by_f7579by integer 2010 Female population: 75 to 79 years
pop_ds1_by_f8084by integer 2010 Female population: 80 to 84 years
pop_ds1_by_f85pby integer 2010 Female population: 85 years and over
pop_ds1_by_fmedby float 2010 Female population: Median age
pop_ds1_by_fadultby integer 2010 Female population: 18 years and over
pop_ds1_by_famedby float 2010 Female population: 18 years and over median age
pop_ds1_by_f1819by integer 2010 Female population: 18 to 19 years
pop_ds1_by_pop00by integer 2010 Total population: Under 1 year
pop_ds1_by_pop01by integer 2010 Total population: 1 year
pop_ds1_by_pop02by integer 2010 Total population: 2 years
pop_ds1_by_pop03by integer 2010 Total population: 3 years
pop_ds1_by_pop04by integer 2010 Total population: 4 years
pop_ds1_by_pop05by integer 2010 Total population: 5 years
pop_ds1_by_pop06by integer 2010 Total population: 6 years
pop_ds1_by_pop07by integer 2010 Total population: 7 years
pop_ds1_by_pop08by integer 2010 Total population: 8 years
pop_ds1_by_pop09by integer 2010 Total population: 9 years
pop_ds1_by_pop10by integer 2010 Total population: 10 years
pop_ds1_by_pop11by integer 2010 Total population: 11 years
pop_ds1_by_pop12by integer 2010 Total population: 12 years
pop_ds1_by_pop13by integer 2010 Total population: 13 years
pop_ds1_by_pop14by integer 2010 Total population: 14 years
pop_ds1_by_pop15by integer 2010 Total population: 15 years
pop_ds1_by_pop16by integer 2010 Total population: 16 years
pop_ds1_by_pop17by integer 2010 Total population: 17 years
pop_ds1_by_pop18by integer 2010 Total population: 18 years
pop_ds1_by_pop19by integer 2010 Total population: 19 years
pop_ds1_by_male00by integer 2010 Male population: Under 1 year
pop_ds1_by_male01by integer 2010 Male population: 1 year
pop_ds1_by_male02by integer 2010 Male population: 2 years
pop_ds1_by_male03by integer 2010 Male population: 3 years
pop_ds1_by_male04by integer 2010 Male population: 4 years
pop_ds1_by_male05by integer 2010 Male population: 5 years
pop_ds1_by_male06by integer 2010 Male population: 6 years
pop_ds1_by_male07by integer 2010 Male population: 7 years
pop_ds1_by_male08by integer 2010 Male population: 8 years
pop_ds1_by_male09by integer 2010 Male population: 9 years
pop_ds1_by_male10by integer 2010 Male population: 10 years
pop_ds1_by_male11by integer 2010 Male population: 11 years
pop_ds1_by_male12by integer 2010 Male population: 12 years
pop_ds1_by_male13by integer 2010 Male population: 13 years
pop_ds1_by_male14by integer 2010 Male population: 14 years
pop_ds1_by_male15by integer 2010 Male population: 15 years
pop_ds1_by_male16by integer 2010 Male population: 16 years
pop_ds1_by_male17by integer 2010 Male population: 17 years
pop_ds1_by_male18by integer 2010 Male population: 18 years
pop_ds1_by_male19by integer 2010 Male population: 19 years
pop_ds1_by_female00by integer 2010 Female population: Under 1 year
pop_ds1_by_female01by integer 2010 Female population: 1 year
pop_ds1_by_female02by integer 2010 Female population: 2 years
pop_ds1_by_female03by integer 2010 Female population: 3 years
pop_ds1_by_female04by integer 2010 Female population: 4 years
pop_ds1_by_female05by integer 2010 Female population: 5 years
pop_ds1_by_female06by integer 2010 Female population: 6 years
pop_ds1_by_female07by integer 2010 Female population: 7 years
pop_ds1_by_female08by integer 2010 Female population: 8 years
pop_ds1_by_female09by integer 2010 Female population: 9 years
pop_ds1_by_female10by integer 2010 Female population: 10 years
pop_ds1_by_female11by integer 2010 Female population: 11 years
pop_ds1_by_female12by integer 2010 Female population: 12 years
pop_ds1_by_female13by integer 2010 Female population: 13 years
pop_ds1_by_female14by integer 2010 Female population: 14 years
pop_ds1_by_female15by integer 2010 Female population: 15 years
pop_ds1_by_female16by integer 2010 Female population: 16 years
pop_ds1_by_female17by integer 2010 Female population: 17 years
pop_ds1_by_female18by integer 2010 Female population: 18 years
pop_ds1_by_female19by integer 2010 Female population: 19 years
pop_ds1_by_hhby integer 2010 Households
pop_ds1_by_hhpopby integer 2010 Population in households
pop_ds1_by_avghhszby float 2010 Average household size
pop_ds1_by_gqpopby integer 2010 Population in group quarters
pop_ds1_by_gq1insby integer 2010 Group quarters: Institutionalized population
pop_ds1_by_gq2corby integer 2010 Group quarters: Institutionalized - Correctional facilities
pop_ds1_by_gq3juvby integer 2010 Group quarters: Institutionalized - Juvenile facilities
pop_ds1_by_gq4nurby integer 2010 Group quarters: Institutionalized - Nursing facilities
pop_ds1_by_gq5oifby integer 2010 Group quarters: Institutionalized - Other institutional
pop_ds1_by_gq6nonby integer 2010 Group quarters: Noninstitutionalized population
pop_ds1_by_gq7colby integer 2010 Group quarters: Noninstitutionalized - College/University housing
pop_ds1_by_gq8milby integer 2010 Group quarters: Noninstitutionalized - Military quarters
pop_ds1_by_gq9onfby integer 2010 Group quarters: Noninstitutionalized - Other noninstitutional
pop_ds1_by_hhs1perby integer 2010 Households: 1-person household
pop_ds1_by_hhs2perby integer 2010 Households: 2-person household
pop_ds1_by_hhs3perby integer 2010 Households: 3-person household
pop_ds1_by_hhs4perby integer 2010 Households: 4-person household
pop_ds1_by_hhs5perby integer 2010 Households: 5-person household
pop_ds1_by_hhs6perby integer 2010 Households: 6-person household
pop_ds1_by_hhs7perby integer 2010 Households: 7-or-more-person household
pop_ds1_by_ls01p05pby integer 2010 Language Spoken at Home: Population 5 years and over
pop_ds1_by_ls02englby integer 2010 Language Spoken at Home: Speak only English
pop_ds1_by_ls03spanby integer 2010 Language Spoken at Home: Spanish or Spanish Creole
pop_ds1_by_ls04frenby integer 2010 Language Spoken at Home: French (incl. Patois, Cajun)
pop_ds1_by_ls05frcrby integer 2010 Language Spoken at Home: French Creole
pop_ds1_by_ls06italby integer 2010 Language Spoken at Home: Italian
pop_ds1_by_ls07portby integer 2010 Language Spoken at Home: Portuguese or Portuguese Creole
pop_ds1_by_ls08germby integer 2010 Language Spoken at Home: German
pop_ds1_by_ls09yiddby integer 2010 Language Spoken at Home: Yiddish
pop_ds1_by_ls10owgeby integer 2010 Language Spoken at Home: Other West Germanic languages
pop_ds1_by_ls11scanby integer 2010 Language Spoken at Home: Scandinavian languages
pop_ds1_by_ls12greeby integer 2010 Language Spoken at Home: Greek
pop_ds1_by_ls13russby integer 2010 Language Spoken at Home: Russian
pop_ds1_by_ls14poliby integer 2010 Language Spoken at Home: Polish
pop_ds1_by_ls15serbby integer 2010 Language Spoken at Home: Serbo-Croatian
pop_ds1_by_ls16oslaby integer 2010 Language Spoken at Home: Other Slavic languages
pop_ds1_by_ls17armeby integer 2010 Language Spoken at Home: Armenian
pop_ds1_by_ls18persby integer 2010 Language Spoken at Home: Persian
pop_ds1_by_ls19gujaby integer 2010 Language Spoken at Home: Gujarathi
pop_ds1_by_ls20hindby integer 2010 Language Spoken at Home: Hindi
pop_ds1_by_ls21urduby integer 2010 Language Spoken at Home: Urdu
pop_ds1_by_ls22oindby integer 2010 Language Spoken at Home: Other Indic languages
pop_ds1_by_ls23oieuby integer 2010 Language Spoken at Home: Other Indo-European languages
pop_ds1_by_ls24chinby integer 2010 Language Spoken at Home: Chinese
pop_ds1_by_ls25japaby integer 2010 Language Spoken at Home: Japanese
pop_ds1_by_ls26koreby integer 2010 Language Spoken at Home: Korean
pop_ds1_by_ls27mocaby integer 2010 Language Spoken at Home: Mon-Khmer, Cambodian
pop_ds1_by_ls28hmonby integer 2010 Language Spoken at Home: Hmong (Miao)
pop_ds1_by_ls29thaiby integer 2010 Language Spoken at Home: Thai
pop_ds1_by_ls30loatby integer 2010 Language Spoken at Home: Laotian
pop_ds1_by_ls31vietby integer 2010 Language Spoken at Home: Vietnamese
pop_ds1_by_ls32oasnby integer 2010 Language Spoken at Home: Other Asian languages
pop_ds1_by_ls33tagaby integer 2010 Language Spoken at Home: Tagalog
pop_ds1_by_ls34opisby integer 2010 Language Spoken at Home: Other Pacific Island languages
pop_ds1_by_ls35navaby integer 2010 Language Spoken at Home: Navajo
pop_ds1_by_ls36onnaby integer 2010 Language Spoken at Home: Other Native North American languages
pop_ds1_by_ls37hungby integer 2010 Language Spoken at Home: Hungarian
pop_ds1_by_ls38arabby integer 2010 Language Spoken at Home: Arabic
pop_ds1_by_ls39hebrby integer 2010 Language Spoken at Home: Hebrew
pop_ds1_by_ls40afriby integer 2010 Language Spoken at Home: African languages
pop_ds1_by_ls41otunby integer 2010 Language Spoken at Home: Other and unspecified languages
pop_ds1_by_an01amerby integer 2010 Ancestry: American
pop_ds1_by_an02arabby integer 2010 Ancestry: Arab
pop_ds1_by_an03britby integer 2010 Ancestry: British
pop_ds1_by_an04czecby integer 2010 Ancestry: Czech
pop_ds1_by_an05daniby integer 2010 Ancestry: Danish
pop_ds1_by_an06dutcby integer 2010 Ancestry: Dutch
pop_ds1_by_an07englby integer 2010 Ancestry: English
pop_ds1_by_an08euroby integer 2010 Ancestry: European
pop_ds1_by_an09frenby integer 2010 Ancestry: French (except Basque)
pop_ds1_by_an10frcnby integer 2010 Ancestry: French Canadian
pop_ds1_by_an11germby integer 2010 Ancestry: German
pop_ds1_by_an12greeby integer 2010 Ancestry: Greek
pop_ds1_by_an13hungby integer 2010 Ancestry: Hungarian
pop_ds1_by_an14irisby integer 2010 Ancestry: Irish
pop_ds1_by_an15italby integer 2010 Ancestry: Italian
pop_ds1_by_an16lithby integer 2010 Ancestry: Lithuanian
pop_ds1_by_an17norwby integer 2010 Ancestry: Norwegian
pop_ds1_by_an18poliby integer 2010 Ancestry: Polish
pop_ds1_by_an19portby integer 2010 Ancestry: Portuguese
pop_ds1_by_an20russby integer 2010 Ancestry: Russian
pop_ds1_by_an21scirby integer 2010 Ancestry: Scotch-Irish
pop_ds1_by_an22scotby integer 2010 Ancestry: Scottish
pop_ds1_by_an23slovby integer 2010 Ancestry: Slovak
pop_ds1_by_an24safrby integer 2010 Ancestry: Subsaharan African
pop_ds1_by_an25swedby integer 2010 Ancestry: Swedish
pop_ds1_by_an26swisby integer 2010 Ancestry: Swiss
pop_ds1_by_an27ukraby integer 2010 Ancestry: Ukrainian
pop_ds1_by_an28welsby integer 2010 Ancestry: Welsh
pop_ds1_by_an29windby integer 2010 Ancestry: West Indian (except Hispanic groups)
pop_ds1_by_an30othgby integer 2010 Ancestry: Other groups
pop_ds1_by_an31ucnrby integer 2010 Ancestry: Unclassified or not reported