Dataset 2: SAUS POP2 CY 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_ds2_cy_TYPE | char(4) | 2017 Geography Type (represents Block Group (BG) only) |
| pop_ds2_cy_popcy | integer | 2017 Total population |
| pop_ds2_cy_an001afgcy | integer | 2017 Ancestry: Afghan |
| pop_ds2_cy_an002albcy | integer | 2017 Ancestry: Albanian |
| pop_ds2_cy_an003alscy | integer | 2017 Ancestry: Alsatian |
| pop_ds2_cy_an004amecy | integer | 2017 Ancestry: American |
| pop_ds2_cy_an005egycy | integer | 2017 Ancestry: Arab, Egyptian |
| pop_ds2_cy_an006irqcy | integer | 2017 Ancestry: Arab, Iraqi |
| pop_ds2_cy_an007jorcy | integer | 2017 Ancestry: Arab, Jordanian |
| pop_ds2_cy_an008lbncy | integer | 2017 Ancestry: Arab, Lebanese |
| pop_ds2_cy_an009morcy | integer | 2017 Ancestry: Arab, Moroccan |
| pop_ds2_cy_an010palcy | integer | 2017 Ancestry: Arab, Palestinian |
| pop_ds2_cy_an011syrcy | integer | 2017 Ancestry: Arab, Syrian |
| pop_ds2_cy_an012arbcy | integer | 2017 Ancestry: Arab, Arab/Arabic |
| pop_ds2_cy_an013oarcy | integer | 2017 Ancestry: Arab, Other Arab |
| pop_ds2_cy_an014armcy | integer | 2017 Ancestry: Armenian |
| pop_ds2_cy_an015acscy | integer | 2017 Ancestry: Assyrian/Chaldean/Syriac |
| pop_ds2_cy_an016auscy | integer | 2017 Ancestry: Australian |
| pop_ds2_cy_an017autcy | integer | 2017 Ancestry: Austrian |
| pop_ds2_cy_an018bascy | integer | 2017 Ancestry: Basque |
| pop_ds2_cy_an019belcy | integer | 2017 Ancestry: Belgian |
| pop_ds2_cy_an020bracy | integer | 2017 Ancestry: Brazilian |
| pop_ds2_cy_an021bricy | integer | 2017 Ancestry: British |
| pop_ds2_cy_an022bgrcy | integer | 2017 Ancestry: Bulgarian |
| pop_ds2_cy_an023cajcy | integer | 2017 Ancestry: Cajun |
| pop_ds2_cy_an024cancy | integer | 2017 Ancestry: Canadian |
| pop_ds2_cy_an025crucy | integer | 2017 Ancestry: Carpatho Rusyn |
| pop_ds2_cy_an026celcy | integer | 2017 Ancestry: Celtic |
| pop_ds2_cy_an027crocy | integer | 2017 Ancestry: Croatian |
| pop_ds2_cy_an028cypcy | integer | 2017 Ancestry: Cypriot |
| pop_ds2_cy_an029czecy | integer | 2017 Ancestry: Czech |
| pop_ds2_cy_an030czscy | integer | 2017 Ancestry: Czechoslovakian |
| pop_ds2_cy_an031dancy | integer | 2017 Ancestry: Danish |
| pop_ds2_cy_an032dutcy | integer | 2017 Ancestry: Dutch |
| pop_ds2_cy_an033eeucy | integer | 2017 Ancestry: Eastern European |
| pop_ds2_cy_an034engcy | integer | 2017 Ancestry: English |
| pop_ds2_cy_an035estcy | integer | 2017 Ancestry: Estonian |
| pop_ds2_cy_an036eurcy | integer | 2017 Ancestry: European |
| pop_ds2_cy_an037fincy | integer | 2017 Ancestry: Finnish |
| pop_ds2_cy_an038frecy | integer | 2017 Ancestry: French (except Basque) |
| pop_ds2_cy_an039frccy | integer | 2017 Ancestry: French Canadian |
| pop_ds2_cy_an040gercy | integer | 2017 Ancestry: German |
| pop_ds2_cy_an041grucy | integer | 2017 Ancestry: German Russian |
| pop_ds2_cy_an042grecy | integer | 2017 Ancestry: Greek |
| pop_ds2_cy_an043guycy | integer | 2017 Ancestry: Guyanese |
| pop_ds2_cy_an044huncy | integer | 2017 Ancestry: Hungarian |
| pop_ds2_cy_an045icecy | integer | 2017 Ancestry: Icelander |
| pop_ds2_cy_an046irncy | integer | 2017 Ancestry: Iranian |
| pop_ds2_cy_an047iricy | integer | 2017 Ancestry: Irish |
| pop_ds2_cy_an048isrcy | integer | 2017 Ancestry: Israeli |
| pop_ds2_cy_an049itacy | integer | 2017 Ancestry: Italian |
| pop_ds2_cy_an050latcy | integer | 2017 Ancestry: Latvian |
| pop_ds2_cy_an051litcy | integer | 2017 Ancestry: Lithuanian |
| pop_ds2_cy_an052luxcy | integer | 2017 Ancestry: Luxemburger |
| pop_ds2_cy_an053maccy | integer | 2017 Ancestry: Macedonian |
| pop_ds2_cy_an054malcy | integer | 2017 Ancestry: Maltese |
| pop_ds2_cy_an055nzlcy | integer | 2017 Ancestry: New Zealander |
| pop_ds2_cy_an056neucy | integer | 2017 Ancestry: Northern European |
| pop_ds2_cy_an057norcy | integer | 2017 Ancestry: Norwegian |
| pop_ds2_cy_an058pgecy | integer | 2017 Ancestry: Pennsylvania German |
| pop_ds2_cy_an059polcy | integer | 2017 Ancestry: Polish |
| pop_ds2_cy_an060porcy | integer | 2017 Ancestry: Portuguese |
| pop_ds2_cy_an061romcy | integer | 2017 Ancestry: Romanian |
| pop_ds2_cy_an062ruscy | integer | 2017 Ancestry: Russian |
| pop_ds2_cy_an063scacy | integer | 2017 Ancestry: Scandinavian |
| pop_ds2_cy_an064sircy | integer | 2017 Ancestry: Scotch-Irish |
| pop_ds2_cy_an065scocy | integer | 2017 Ancestry: Scottish |
| pop_ds2_cy_an066sercy | integer | 2017 Ancestry: Serbian |
| pop_ds2_cy_an067slacy | integer | 2017 Ancestry: Slavic |
| pop_ds2_cy_an068svkcy | integer | 2017 Ancestry: Slovak |
| pop_ds2_cy_an069svncy | integer | 2017 Ancestry: Slovene |
| pop_ds2_cy_an070suncy | integer | 2017 Ancestry: Soviet Union |
| pop_ds2_cy_an071cvecy | integer | 2017 Ancestry: Subsaharan African, Cape Verdean |
| pop_ds2_cy_an072ethcy | integer | 2017 Ancestry: Subsaharan African, Ethiopian |
| pop_ds2_cy_an073ghacy | integer | 2017 Ancestry: Subsaharan African, Ghanaian |
| pop_ds2_cy_an074kency | integer | 2017 Ancestry: Subsaharan African, Kenyan |
| pop_ds2_cy_an075lbrcy | integer | 2017 Ancestry: Subsaharan African, Liberian |
| pop_ds2_cy_an076ngacy | integer | 2017 Ancestry: Subsaharan African, Nigerian |
| pop_ds2_cy_an077sency | integer | 2017 Ancestry: Subsaharan African, Senegalese |
| pop_ds2_cy_an078slecy | integer | 2017 Ancestry: Subsaharan African, Sierra Leonean |
| pop_ds2_cy_an079somcy | integer | 2017 Ancestry: Subsaharan African, Somalian |
| pop_ds2_cy_an080safcy | integer | 2017 Ancestry: Subsaharan African, South African |
| pop_ds2_cy_an081sdncy | integer | 2017 Ancestry: Subsaharan African, Sudanese |
| pop_ds2_cy_an082ugacy | integer | 2017 Ancestry: Subsaharan African, Ugandan |
| pop_ds2_cy_an083zwecy | integer | 2017 Ancestry: Subsaharan African, Zimbabwean |
| pop_ds2_cy_an084afrcy | integer | 2017 Ancestry: Subsaharan African, African |
| pop_ds2_cy_an085osacy | integer | 2017 Ancestry: Subsaharan African, Other Subsaharan African |
| pop_ds2_cy_an086swecy | integer | 2017 Ancestry: Swedish |
| pop_ds2_cy_an087swicy | integer | 2017 Ancestry: Swiss |
| pop_ds2_cy_an088turcy | integer | 2017 Ancestry: Turkish |
| pop_ds2_cy_an089ukrcy | integer | 2017 Ancestry: Ukrainian |
| pop_ds2_cy_an090welcy | integer | 2017 Ancestry: Welsh |
| pop_ds2_cy_an091bhscy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Bahamian |
| pop_ds2_cy_an092brbcy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Barbadian |
| pop_ds2_cy_an093blzcy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Belizean |
| pop_ds2_cy_an094bmucy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Bermudan |
| pop_ds2_cy_an095bwicy | integer | 2017 Ancestry: West Indian (except Hispanic groups), British West Indian |
| pop_ds2_cy_an096dwicy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Dutch West Indian |
| pop_ds2_cy_an097haicy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Haitian |
| pop_ds2_cy_an098jamcy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Jamaican |
| pop_ds2_cy_an099ttocy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Trinidadian and Tobagonian |
| pop_ds2_cy_an100vircy | integer | 2017 Ancestry: West Indian (except Hispanic groups), U.S. Virgin Islander |
| pop_ds2_cy_an101wincy | integer | 2017 Ancestry: West Indian (except Hispanic groups), West Indian |
| pop_ds2_cy_an102owicy | integer | 2017 Ancestry: West Indian (except Hispanic groups), Other West Indian |
| pop_ds2_cy_an103yugcy | integer | 2017 Ancestry: Yugoslavian |
| pop_ds2_cy_an104ogrcy | integer | 2017 Ancestry: Other groups |
| pop_ds2_cy_an105unrcy | integer | 2017 Ancestry: Unclassified or not reported |