Dataset1: SAUS POP1 CY Description
| Field Name | Field Type | Description |
|---|---|---|
| pbkey | varchar(50) | Unique ID for an addressable location. 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_cy_TYPE | char(4) | 2020 Geography Type (represents Block Group (BG) only) |
| pop_ds1_cy_whtpopcy | integer | 2020 White alone |
| pop_ds1_cy_blkpopcy | integer | 2020 Black or African American alone |
| pop_ds1_cy_indpopcy | integer | 2020 American Indian and Alaska Native alone |
| pop_ds1_cy_asnpopcy | integer | 2020 Asian alone |
| pop_ds1_cy_hpipopcy | integer | 2020 Native Hawaiian and OPI alone |
| pop_ds1_cy_othpopcy | integer | 2020 Some Other Race alone |
| pop_ds1_cy_twopopcy | integer | 2020 Two or More Races |
| pop_ds1_cy_hsppopcy | integer | 2020 Hispanic |
| pop_ds1_cy_nhpopcy | integer | 2020 Not Hispanic |
| pop_ds1_cy_nhp1whtcy | integer | 2020 Not Hispanic: White alone |
| pop_ds1_cy_nhp2blkcy | integer | 2020 Not Hispanic: Black or African American alone |
| pop_ds1_cy_nhp3indcy | integer | 2020 Not Hispanic: American Indian and Alaska Native alone |
| pop_ds1_cy_nhp4asncy | integer | 2020 Not Hispanic: Asian alone |
| pop_ds1_cy_nhp5hpicy | integer | 2020 Not Hispanic: Native Hawaiian and OPI alone |
| pop_ds1_cy_nhp6othcy | integer | 2020 Not Hispanic: Some Other Race alone |
| pop_ds1_cy_nhp7twocy | integer | 2020 Not Hispanic: Two or More Races |
| pop_ds1_cy_hsp1whtcy | integer | 2020 Hispanic: White alone |
| pop_ds1_cy_hsp2blkcy | integer | 2020 Hispanic: Black or African American alone |
| pop_ds1_cy_hsp3indcy | integer | 2020 Hispanic: American Indian and Alaska Native alone |
| pop_ds1_cy_hsp4asncy | integer | 2020 Hispanic: Asian alone |
| pop_ds1_cy_hsp5hpicy | integer | 2020 Hispanic: Native Hawaiian and OPI alone |
| pop_ds1_cy_hsp6othcy | integer | 2020 Hispanic: Some Other Race alone |
| pop_ds1_cy_hsp7twocy | integer | 2020 Hispanic: Two or More Races |
| pop_ds1_cy_popcy | integer | 2020 Total population |
| pop_ds1_cy_p0004cy | integer | 2020 Total population: Under 5 years |
| pop_ds1_cy_p0509cy | integer | 2020 Total population: 5 to 9 years |
| pop_ds1_cy_p1014cy | integer | 2020 Total population: 10 to 14 years |
| pop_ds1_cy_p1519cy | integer | 2020 Total population: 15 to 19 years |
| pop_ds1_cy_p2024cy | integer | 2020 Total population: 20 to 24 years |
| pop_ds1_cy_p2529cy | integer | 2020 Total population: 25 to 29 years |
| pop_ds1_cy_p3034cy | integer | 2020 Total population: 30 to 34 years |
| pop_ds1_cy_p3539cy | integer | 2020 Total population: 35 to 39 years |
| pop_ds1_cy_p4044cy | integer | 2020 Total population: 40 to 44 years |
| pop_ds1_cy_p4549cy | integer | 2020 Total population: 45 to 49 years |
| pop_ds1_cy_p5054cy | integer | 2020 Total population: 50 to 54 years |
| pop_ds1_cy_p5559cy | integer | 2020 Total population: 55 to 59 years |
| pop_ds1_cy_p6064cy | integer | 2020 Total population: 60 to 64 years |
| pop_ds1_cy_p6569cy | integer | 2020 Total population: 65 to 69 years |
| pop_ds1_cy_p7074cy | integer | 2020 Total population: 70 to 74 years |
| pop_ds1_cy_p7579cy | integer | 2020 Total population: 75 to 79 years |
| pop_ds1_cy_p8084cy | integer | 2020 Total population: 80 to 84 years |
| pop_ds1_cy_p85pcy | integer | 2020 Total population: 85 years and over |
| pop_ds1_cy_pmedcy | float | 2020 Total population: Median age |
| pop_ds1_cy_padultcy | integer | 2020 Total population: 18 years and over |
| pop_ds1_cy_pamedcy | float | 2020 Total population: 18 years and over median age |
| pop_ds1_cy_p1819cy | integer | 2020 Total population: 18 to 19 years |
| pop_ds1_cy_malecy | integer | 2020 Male population |
| pop_ds1_cy_m0004cy | integer | 2020 Male population: Under 5 years |
| pop_ds1_cy_m0509cy | integer | 2020 Male population: 5 to 9 years |
| pop_ds1_cy_m1014cy | integer | 2020 Male population: 10 to 14 years |
| pop_ds1_cy_m1519cy | integer | 2020 Male population: 15 to 19 years |
| pop_ds1_cy_m2024cy | integer | 2020 Male population: 20 to 24 years |
| pop_ds1_cy_m2529cy | integer | 2020 Male population: 25 to 29 years |
| pop_ds1_cy_m3034cy | integer | 2020 Male population: 30 to 34 years |
| pop_ds1_cy_m3539cy | integer | 2020 Male population: 35 to 39 years |
| pop_ds1_cy_m4044cy | integer | 2020 Male population: 40 to 44 years |
| pop_ds1_cy_m4549cy | integer | 2020 Male population: 45 to 49 years |
| pop_ds1_cy_m5054cy | integer | 2020 Male population: 50 to 54 years |
| pop_ds1_cy_m5559cy | integer | 2020 Male population: 55 to 59 years |
| pop_ds1_cy_m6064cy | integer | 2020 Male population: 60 to 64 years |
| pop_ds1_cy_m6569cy | integer | 2020 Male population: 65 to 69 years |
| pop_ds1_cy_m7074cy | integer | 2020 Male population: 70 to 74 years |
| pop_ds1_cy_m7579cy | integer | 2020 Male population: 75 to 79 years |
| pop_ds1_cy_m8084cy | integer | 2020 Male population: 80 to 84 years |
| pop_ds1_cy_m85pcy | integer | 2020 Male population: 85 years and over |
| pop_ds1_cy_mmedcy | float | 2020 Male population: Median age |
| pop_ds1_cy_madultcy | integer | 2020 Male population: 18 years and over |
| pop_ds1_cy_mamedcy | float | 2020 Male population: 18 years and over median age |
| pop_ds1_cy_m1819cy | integer | 2020 Male population: 18 to 19 years |
| pop_ds1_cy_femalecy | integer | 2020 Female population |
| pop_ds1_cy_f0004cy | integer | 2020 Female population: Under 5 years |
| pop_ds1_cy_f0509cy | integer | 2020 Female population: 5 to 9 years |
| pop_ds1_cy_f1014cy | integer | 2020 Female population: 10 to 14 years |
| pop_ds1_cy_f1519cy | integer | 2020 Female population: 15 to 19 years |
| pop_ds1_cy_f2024cy | integer | 2020 Female population: 20 to 24 years |
| pop_ds1_cy_f2529cy | integer | 2020 Female population: 25 to 29 years |
| pop_ds1_cy_f3034cy | integer | 2020 Female population: 30 to 34 years |
| pop_ds1_cy_f3539cy | integer | 2020 Female population: 35 to 39 years |
| pop_ds1_cy_f4044cy | integer | 2020 Female population: 40 to 44 years |
| pop_ds1_cy_f4549cy | integer | 2020 Female population: 45 to 49 years |
| pop_ds1_cy_f5054cy | integer | 2020 Female population: 50 to 54 years |
| pop_ds1_cy_f5559cy | integer | 2020 Female population: 55 to 59 years |
| pop_ds1_cy_f6064cy | integer | 2020 Female population: 60 to 64 years |
| pop_ds1_cy_f6569cy | integer | 2020 Female population: 65 to 69 years |
| pop_ds1_cy_f7074cy | integer | 2020 Female population: 70 to 74 years |
| pop_ds1_cy_f7579cy | integer | 2020 Female population: 75 to 79 years |
| pop_ds1_cy_f8084cy | integer | 2020 Female population: 80 to 84 years |
| pop_ds1_cy_f85pcy | integer | 2020 Female population: 85 years and over |
| pop_ds1_cy_fmedcy | float | 2020 Female population: Median age |
| pop_ds1_cy_fadultcy | integer | 2020 Female population: 18 years and over |
| pop_ds1_cy_famedcy | float | 2020 Female population: 18 years and over median age |
| pop_ds1_cy_f1819cy | integer | 2020 Female population: 18 to 19 years |
| pop_ds1_cy_hhcy | integer | 2020 Households |
| pop_ds1_cy_hhpopcy | integer | 2020 Population in households |
| pop_ds1_cy_avghhszcy | float | 2020 Average household size |
| pop_ds1_cy_gqpopcy | integer | 2020 Population in group quarters |
| pop_ds1_cy_hhs1percy | integer | 2020 Households: 1-person household |
| pop_ds1_cy_hhs2percy | integer | 2020 Households: 2-person household |
| pop_ds1_cy_hhs3percy | integer | 2020 Households: 3-person household |
| pop_ds1_cy_hhs4percy | integer | 2020 Households: 4-person household |
| pop_ds1_cy_hhs5percy | integer | 2020 Households: 5-person household |
| pop_ds1_cy_hhs6percy | integer | 2020 Households: 6-person household |
| pop_ds1_cy_hhs7percy | integer | 2020 Households: 7-or-more-person household |
| pop_ds1_cy_ls01p05pcy | integer | 2020 Language Spoken at Home: Population 5 years and over |
| pop_ds1_cy_ls02englcy | integer | 2020 Language Spoken at Home: Speak only English |
| pop_ds1_cy_ls03spancy | integer | 2020 Language Spoken at Home: Spanish or Spanish Creole |
| pop_ds1_cy_ls04frency | integer | 2020 Language Spoken at Home: French (incl. Patois, Cajun) |
| pop_ds1_cy_ls05frcrcy | integer | 2020 Language Spoken at Home: French Creole |
| pop_ds1_cy_ls06italcy | integer | 2020 Language Spoken at Home: Italian |
| pop_ds1_cy_ls07portcy | integer | 2020 Language Spoken at Home: Portuguese or Portuguese Creole |
| pop_ds1_cy_ls08germcy | integer | 2020 Language Spoken at Home: German |
| pop_ds1_cy_ls09yiddcy | integer | 2020 Language Spoken at Home: Yiddish |
| pop_ds1_cy_ls10owgecy | integer | 2020 Language Spoken at Home: Other West Germanic languages |
| pop_ds1_cy_ls11scancy | integer | 2020 Language Spoken at Home: Scandinavian languages |
| pop_ds1_cy_ls12greecy | integer | 2020 Language Spoken at Home: Greek |
| pop_ds1_cy_ls13russcy | integer | 2020 Language Spoken at Home: Russian |
| pop_ds1_cy_ls14policy | integer | 2020 Language Spoken at Home: Polish |
| pop_ds1_cy_ls15serbcy | integer | 2020 Language Spoken at Home: Serbo-Croatian |
| pop_ds1_cy_ls16oslacy | integer | 2020 Language Spoken at Home: Other Slavic languages |
| pop_ds1_cy_ls17armecy | integer | 2020 Language Spoken at Home: Armenian |
| pop_ds1_cy_ls18perscy | integer | 2020 Language Spoken at Home: Persian |
| pop_ds1_cy_ls19gujacy | integer | 2020 Language Spoken at Home: Gujarathi |
| pop_ds1_cy_ls20hindcy | integer | 2020 Language Spoken at Home: Hindi |
| pop_ds1_cy_ls21urducy | integer | 2020 Language Spoken at Home: Urdu |
| pop_ds1_cy_ls22oindcy | integer | 2020 Language Spoken at Home: Other Indic languages |
| pop_ds1_cy_ls23oieucy | integer | 2020 Language Spoken at Home: Other Indo-European languages |
| pop_ds1_cy_ls24chincy | integer | 2020 Language Spoken at Home: Chinese |
| pop_ds1_cy_ls25japacy | integer | 2020 Language Spoken at Home: Japanese |
| pop_ds1_cy_ls26korecy | integer | 2020 Language Spoken at Home: Korean |
| pop_ds1_cy_ls27mocacy | integer | 2020 Language Spoken at Home: Mon-Khmer, Cambodian |
| pop_ds1_cy_ls28hmoncy | integer | 2020 Language Spoken at Home: Hmong (Miao) |
| pop_ds1_cy_ls29thaicy | integer | 2020 Language Spoken at Home: Thai |
| pop_ds1_cy_ls30loatcy | integer | 2020 Language Spoken at Home: Laotian |
| pop_ds1_cy_ls31vietcy | integer | 2020 Language Spoken at Home: Vietnamese |
| pop_ds1_cy_ls32oasncy | integer | 2020 Language Spoken at Home: Other Asian languages |
| pop_ds1_cy_ls33tagacy | integer | 2020 Language Spoken at Home: Tagalog |
| pop_ds1_cy_ls34opiscy | integer | 2020 Language Spoken at Home: Other Pacific Island languages |
| pop_ds1_cy_ls35navacy | integer | 2020 Language Spoken at Home: Navajo |
| pop_ds1_cy_ls36onnacy | integer | 2020 Language Spoken at Home: Other Native North American languages |
| pop_ds1_cy_ls37hungcy | integer | 2020 Language Spoken at Home: Hungarian |
| pop_ds1_cy_ls38arabcy | integer | 2020 Language Spoken at Home: Arabic |
| pop_ds1_cy_ls39hebrcy | integer | 2020 Language Spoken at Home: Hebrew |
| pop_ds1_cy_ls40africy | integer | 2020 Language Spoken at Home: African languages |
| pop_ds1_cy_ls41otuncy | integer | 2020 Language Spoken at Home: Other and unspecified languages |
| pop_ds1_cy_an01amercy | integer | 2020 Ancestry: American |
| pop_ds1_cy_an02arabcy | integer | 2020 Ancestry: Arab |
| pop_ds1_cy_an03britcy | integer | 2020 Ancestry: British |
| pop_ds1_cy_an04czeccy | integer | 2020 Ancestry: Czech |
| pop_ds1_cy_an05danicy | integer | 2020 Ancestry: Danish |
| pop_ds1_cy_an06dutccy | integer | 2020 Ancestry: Dutch |
| pop_ds1_cy_an07englcy | integer | 2020 Ancestry: English |
| pop_ds1_cy_an08eurocy | integer | 2020 Ancestry: European |
| pop_ds1_cy_an09frency | integer | 2020 Ancestry: French (except Basque) |
| pop_ds1_cy_an10frcncy | integer | 2020 Ancestry: French Canadian |
| pop_ds1_cy_an11germcy | integer | 2020 Ancestry: German |
| pop_ds1_cy_an12greecy | integer | 2020 Ancestry: Greek |
| pop_ds1_cy_an13hungcy | integer | 2020 Ancestry: Hungarian |
| pop_ds1_cy_an14iriscy | integer | 2020 Ancestry: Irish |
| pop_ds1_cy_an15italcy | integer | 2020 Ancestry: Italian |
| pop_ds1_cy_an16lithcy | integer | 2020 Ancestry: Lithuanian |
| pop_ds1_cy_an17norwcy | integer | 2020 Ancestry: Norwegian |
| pop_ds1_cy_an18policy | integer | 2020 Ancestry: Polish |
| pop_ds1_cy_an19portcy | integer | 2020 Ancestry: Portuguese |
| pop_ds1_cy_an20russcy | integer | 2020 Ancestry: Russian |
| pop_ds1_cy_an21scircy | integer | 2020 Ancestry: Scotch-Irish |
| pop_ds1_cy_an22scotcy | integer | 2020 Ancestry: Scottish |
| pop_ds1_cy_an23slovcy | integer | 2020 Ancestry: Slovak |
| pop_ds1_cy_an24safrcy | integer | 2020 Ancestry: Subsaharan African |
| pop_ds1_cy_an25swedcy | integer | 2020 Ancestry: Swedish |
| pop_ds1_cy_an26swiscy | integer | 2020 Ancestry: Swiss |
| pop_ds1_cy_an27ukracy | integer | 2020 Ancestry: Ukrainian |
| pop_ds1_cy_an28welscy | integer | 2020 Ancestry: Welsh |
| pop_ds1_cy_an29windcy | integer | 2020 Ancestry: West Indian (except Hispanic groups) |
| pop_ds1_cy_an30othgcy | integer | 2020 Ancestry: Other groups |
| pop_ds1_cy_an31ucnrcy | integer | 2020 Ancestry: Unclassified or not reported |
| pop_ds1_cy_daypopcy | integer | 2020 Total Daytime Population |
| pop_ds1_cy_dayworkcy | integer | 2020 Total Employees |
| pop_ds1_cy_dayhomecy | integer | 2020 Total Daytime at Home Population |