Dataset 2: SAUS POP2 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_ds2_by_TYPE | char(4) | 2017 Geography Type (represents Block Group (BG) only) |
| pop_ds2_by_popby | integer | 2010 Total population |
| pop_ds2_by_an001afgby | integer | 2010 Ancestry: Afghan |
| pop_ds2_by_an002albby | integer | 2010 Ancestry: Albanian |
| pop_ds2_by_an003alsby | integer | 2010 Ancestry: Alsatian |
| pop_ds2_by_an004ameby | integer | 2010 Ancestry: American |
| pop_ds2_by_an005egyby | integer | 2010 Ancestry: Arab, Egyptian |
| pop_ds2_by_an006irqby | integer | 2010 Ancestry: Arab, Iraqi |
| pop_ds2_by_an007jorby | integer | 2010 Ancestry: Arab, Jordanian |
| pop_ds2_by_an008lbnby | integer | 2010 Ancestry: Arab, Lebanese |
| pop_ds2_by_an009morby | integer | 2010 Ancestry: Arab, Moroccan |
| pop_ds2_by_an010palby | integer | 2010 Ancestry: Arab, Palestinian |
| pop_ds2_by_an011syrby | integer | 2010 Ancestry: Arab, Syrian |
| pop_ds2_by_an012arbby | integer | 2010 Ancestry: Arab, Arab/Arabic |
| pop_ds2_by_an013oarby | integer | 2010 Ancestry: Arab, Other Arab |
| pop_ds2_by_an014armby | integer | 2010 Ancestry: Armenian |
| pop_ds2_by_an015acsby | integer | 2010 Ancestry: Assyrian/Chaldean/Syriac |
| pop_ds2_by_an016ausby | integer | 2010 Ancestry: Australian |
| pop_ds2_by_an017autby | integer | 2010 Ancestry: Austrian |
| pop_ds2_by_an018basby | integer | 2010 Ancestry: Basque |
| pop_ds2_by_an019belby | integer | 2010 Ancestry: Belgian |
| pop_ds2_by_an020braby | integer | 2010 Ancestry: Brazilian |
| pop_ds2_by_an021briby | integer | 2010 Ancestry: British |
| pop_ds2_by_an022bgrby | integer | 2010 Ancestry: Bulgarian |
| pop_ds2_by_an023cajby | integer | 2010 Ancestry: Cajun |
| pop_ds2_by_an024canby | integer | 2010 Ancestry: Canadian |
| pop_ds2_by_an025cruby | integer | 2010 Ancestry: Carpatho Rusyn |
| pop_ds2_by_an026celby | integer | 2010 Ancestry: Celtic |
| pop_ds2_by_an027croby | integer | 2010 Ancestry: Croatian |
| pop_ds2_by_an028cypby | integer | 2010 Ancestry: Cypriot |
| pop_ds2_by_an029czeby | integer | 2010 Ancestry: Czech |
| pop_ds2_by_an030czsby | integer | 2010 Ancestry: Czechoslovakian |
| pop_ds2_by_an031danby | integer | 2010 Ancestry: Danish |
| pop_ds2_by_an032dutby | integer | 2010 Ancestry: Dutch |
| pop_ds2_by_an033eeuby | integer | 2010 Ancestry: Eastern European |
| pop_ds2_by_an034engby | integer | 2010 Ancestry: English |
| pop_ds2_by_an035estby | integer | 2010 Ancestry: Estonian |
| pop_ds2_by_an036eurby | integer | 2010 Ancestry: European |
| pop_ds2_by_an037finby | integer | 2010 Ancestry: Finnish |
| pop_ds2_by_an038freby | integer | 2010 Ancestry: French (except Basque) |
| pop_ds2_by_an039frcby | integer | 2010 Ancestry: French Canadian |
| pop_ds2_by_an040gerby | integer | 2010 Ancestry: German |
| pop_ds2_by_an041gruby | integer | 2010 Ancestry: German Russian |
| pop_ds2_by_an042greby | integer | 2010 Ancestry: Greek |
| pop_ds2_by_an043guyby | integer | 2010 Ancestry: Guyanese |
| pop_ds2_by_an044hunby | integer | 2010 Ancestry: Hungarian |
| pop_ds2_by_an045iceby | integer | 2010 Ancestry: Icelander |
| pop_ds2_by_an046irnby | integer | 2010 Ancestry: Iranian |
| pop_ds2_by_an047iriby | integer | 2010 Ancestry: Irish |
| pop_ds2_by_an048isrby | integer | 2010 Ancestry: Israeli |
| pop_ds2_by_an049itaby | integer | 2010 Ancestry: Italian |
| pop_ds2_by_an050latby | integer | 2010 Ancestry: Latvian |
| pop_ds2_by_an051litby | integer | 2010 Ancestry: Lithuanian |
| pop_ds2_by_an052luxby | integer | 2010 Ancestry: Luxemburger |
| pop_ds2_by_an053macby | integer | 2010 Ancestry: Macedonian |
| pop_ds2_by_an054malby | integer | 2010 Ancestry: Maltese |
| pop_ds2_by_an055nzlby | integer | 2010 Ancestry: New Zealander |
| pop_ds2_by_an056neuby | integer | 2010 Ancestry: Northern European |
| pop_ds2_by_an057norby | integer | 2010 Ancestry: Norwegian |
| pop_ds2_by_an058pgeby | integer | 2010 Ancestry: Pennsylvania German |
| pop_ds2_by_an059polby | integer | 2010 Ancestry: Polish |
| pop_ds2_by_an060porby | integer | 2010 Ancestry: Portuguese |
| pop_ds2_by_an061romby | integer | 2010 Ancestry: Romanian |
| pop_ds2_by_an062rusby | integer | 2010 Ancestry: Russian |
| pop_ds2_by_an063scaby | integer | 2010 Ancestry: Scandinavian |
| pop_ds2_by_an064sirby | integer | 2010 Ancestry: Scotch-Irish |
| pop_ds2_by_an065scoby | integer | 2010 Ancestry: Scottish |
| pop_ds2_by_an066serby | integer | 2010 Ancestry: Serbian |
| pop_ds2_by_an067slaby | integer | 2010 Ancestry: Slavic |
| pop_ds2_by_an068svkby | integer | 2010 Ancestry: Slovak |
| pop_ds2_by_an069svnby | integer | 2010 Ancestry: Slovene |
| pop_ds2_by_an070sunby | integer | 2010 Ancestry: Soviet Union |
| pop_ds2_by_an071cveby | integer | 2010 Ancestry: Subsaharan African, Cape Verdean |
| pop_ds2_by_an072ethby | integer | 2010 Ancestry: Subsaharan African, Ethiopian |
| pop_ds2_by_an073ghaby | integer | 2010 Ancestry: Subsaharan African, Ghanaian |
| pop_ds2_by_an074kenby | integer | 2010 Ancestry: Subsaharan African, Kenyan |
| pop_ds2_by_an075lbrby | integer | 2010 Ancestry: Subsaharan African, Liberian |
| pop_ds2_by_an076ngaby | integer | 2010 Ancestry: Subsaharan African, Nigerian |
| pop_ds2_by_an077senby | integer | 2010 Ancestry: Subsaharan African, Senegalese |
| pop_ds2_by_an078sleby | integer | 2010 Ancestry: Subsaharan African, Sierra Leonean |
| pop_ds2_by_an079somby | integer | 2010 Ancestry: Subsaharan African, Somalian |
| pop_ds2_by_an080safby | integer | 2010 Ancestry: Subsaharan African, South African |
| pop_ds2_by_an081sdnby | integer | 2010 Ancestry: Subsaharan African, Sudanese |
| pop_ds2_by_an082ugaby | integer | 2010 Ancestry: Subsaharan African, Ugandan |
| pop_ds2_by_an083zweby | integer | 2010 Ancestry: Subsaharan African, Zimbabwean |
| pop_ds2_by_an084afrby | integer | 2010 Ancestry: Subsaharan African, African |
| pop_ds2_by_an085osaby | integer | 2010 Ancestry: Subsaharan African, Other Subsaharan African |
| pop_ds2_by_an086sweby | integer | 2010 Ancestry: Swedish |
| pop_ds2_by_an087swiby | integer | 2010 Ancestry: Swiss |
| pop_ds2_by_an088turby | integer | 2010 Ancestry: Turkish |
| pop_ds2_by_an089ukrby | integer | 2010 Ancestry: Ukrainian |
| pop_ds2_by_an090welby | integer | 2010 Ancestry: Welsh |
| pop_ds2_by_an091bhsby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Bahamian |
| pop_ds2_by_an092brbby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Barbadian |
| pop_ds2_by_an093blzby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Belizean |
| pop_ds2_by_an094bmuby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Bermudan |
| pop_ds2_by_an095bwiby | integer | 2010 Ancestry: West Indian (except Hispanic groups), British West Indian |
| pop_ds2_by_an096dwiby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Dutch West Indian |
| pop_ds2_by_an097haiby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Haitian |
| pop_ds2_by_an098jamby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Jamaican |
| pop_ds2_by_an099ttoby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Trinidadian and Tobagonian |
| pop_ds2_by_an100virby | integer | 2010 Ancestry: West Indian (except Hispanic groups), U.S. Virgin Islander |
| pop_ds2_by_an101winby | integer | 2010 Ancestry: West Indian (except Hispanic groups), West Indian |
| pop_ds2_by_an102owiby | integer | 2010 Ancestry: West Indian (except Hispanic groups), Other West Indian |
| pop_ds2_by_an103yugby | integer | 2010 Ancestry: Yugoslavian |
| pop_ds2_by_an104ogrby | integer | 2010 Ancestry: Other groups |
| pop_ds2_by_an105unrby | integer | 2010 Ancestry: Unclassified or not reported |