https://api.census.gov/data/2010/dec/sf1/examples.html
Example of extracting census attribute data (Block population and block black population), e.g. mimicking AFF query and extraction.
#Imports
import pandas as pd
import os,requests
#Get key
pdKey = pd.read_csv('{}/APIkeys.csv'.format(os.environ['localappdata']))
census = pdKey.iloc[0,1]
List of variables: P003001: Total P003003: Black or African American alone
#Census API
theURL = 'https://api.census.gov/data/2010/dec/sf1'
params = {'get':'P003001,P003003,P010001,P010004',
'for':'block:*',
'in':'state:37%county:183',
'key':census
}
r = requests.get(theURL,params)
#Convert response to a dataframe
rJSON =r.json()
dfB = pd.DataFrame(rJSON[1:],columns=rJSON[0])
dfB['GEOID10'] = dfB.state+dfB.county+dfB.tract+dfB.block
dfB.head()
P003001 | P003003 | P010001 | P010004 | state | county | tract | block | GEOID10 | |
---|---|---|---|---|---|---|---|---|---|
0 | 230 | 146 | 185 | 115 | 37 | 183 | 050100 | 1097 | 371830501001097 |
1 | 0 | 0 | 0 | 0 | 37 | 183 | 050100 | 1103 | 371830501001103 |
2 | 20 | 9 | 20 | 9 | 37 | 183 | 050100 | 1105 | 371830501001105 |
3 | 22 | 17 | 18 | 13 | 37 | 183 | 050100 | 1107 | 371830501001107 |
4 | 21 | 15 | 16 | 10 | 37 | 183 | 050100 | 1116 | 371830501001116 |
dfB[dfB.GEOID10 == '371830501001020']
P003001 | P003003 | P010001 | P010004 | state | county | tract | block | GEOID10 | |
---|---|---|---|---|---|---|---|---|---|
103 | 29 | 1 | 27 | 1 | 37 | 183 | 050100 | 1020 | 371830501001020 |
#Export to a table
dfB.iloc[:,[0,1,-1]].to_csv('Durham.csv',index=False)
Explore variables:
#Get list of variables and convert to a dataframe (transposed)
varsJson =requests.get('https://api.census.gov/data/2010/dec/sf1/variables.json').json()
dfVars = pd.DataFrame(varsJson['variables']).T
dfVars.columns
Index(['attributes', 'concept', 'group', 'label', 'limit', 'predicateOnly', 'predicateType', 'required', 'values'], dtype='object')
#Reveal varibles containing the word "Black"
dfVars[dfVars.label.str.contains('Black')]
attributes | concept | group | label | limit | predicateOnly | predicateType | required | values | |
---|---|---|---|---|---|---|---|---|---|
PCT001005 | NaN | AMERICAN INDIAN AND ALASKA NATIVE ALONE WITH O... | PCT1 | Total tribes tallied (300, A01-M38, M41-R98, S... | 0 | NaN | int | NaN | NaN |
H008003 | NaN | TOTAL RACES TALLIED FOR HOUSEHOLDERS | H8 | Total races tallied for householders!!Black or... | 0 | NaN | int | NaN | NaN |
P008069 | NaN | RACE | P8 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P008067 | NaN | RACE | P8 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P008066 | NaN | RACE | P8 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P008061 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008060 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008065 | NaN | RACE | P8 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P008064 | NaN | RACE | P8 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P008071 | NaN | RACE | P8 | Total!!Two or More Races!!Population of six ra... | 0 | NaN | int | NaN | NaN |
P008019 | NaN | RACE | P8 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P008011 | NaN | RACE | P8 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P008018 | NaN | RACE | P8 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P008017 | NaN | RACE | P8 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P008016 | NaN | RACE | P8 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P008004 | NaN | RACE | P8 | Total!!Population of one race!!Black or Africa... | 0 | NaN | int | NaN | NaN |
P008050 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008053 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008051 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008052 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008058 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008059 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008040 | NaN | RACE | P8 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P008041 | NaN | RACE | P8 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P008042 | NaN | RACE | P8 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P008048 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008049 | NaN | RACE | P8 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P008030 | NaN | RACE | P8 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P008039 | NaN | RACE | P8 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P008037 | NaN | RACE | P8 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
P009019 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009039 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009031 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009030 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009032 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009040 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009044 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009043 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009042 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009041 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009053 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009052 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009055 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009054 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009051 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009050 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009069 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009068 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009067 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009066 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009063 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009062 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009061 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009060 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009071 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
P009073 | NaN | HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO... | P9 | Total!!Not Hispanic or Latino!!Two or More Rac... | 0 | NaN | int | NaN | NaN |
HCT001013 | NaN | TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHO... | HCT1 | Total!!Owner occupied!!Hispanic or Latino hous... | 0 | NaN | int | NaN | NaN |
HCT001005 | NaN | TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHO... | HCT1 | Total!!Owner occupied!!Not Hispanic or Latino ... | 0 | NaN | int | NaN | NaN |
HCT001030 | NaN | TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHO... | HCT1 | Total!!Renter occupied!!Hispanic or Latino hou... | 0 | NaN | int | NaN | NaN |
HCT001022 | NaN | TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHO... | HCT1 | Total!!Renter occupied!!Not Hispanic or Latino... | 0 | NaN | int | NaN | NaN |
153 rows × 9 columns
df = pd.DataFrame(varsJson['variables']).T
df.head(10)
attributes | concept | group | label | limit | predicateOnly | predicateType | required | values | |
---|---|---|---|---|---|---|---|---|---|
for | NaN | Census API Geography Specification | N/A | Census API FIPS 'for' clause | 0 | True | fips-for | NaN | NaN |
in | NaN | Census API Geography Specification | N/A | Census API FIPS 'in' clause | 0 | True | fips-in | NaN | NaN |
ucgid | NaN | Census API Geography Specification | N/A | Uniform Census Geography Identifier clause | 0 | True | ucgid | NaN | NaN |
P029009 | NaN | HOUSEHOLD TYPE BY RELATIONSHIP | P29 | Total!!In households!!In family households!!Ad... | 0 | NaN | int | NaN | NaN |
P029007 | NaN | HOUSEHOLD TYPE BY RELATIONSHIP | P29 | Total!!In households!!In family households!!Sp... | 0 | NaN | int | NaN | NaN |
P029008 | NaN | HOUSEHOLD TYPE BY RELATIONSHIP | P29 | Total!!In households!!In family households!!Bi... | 0 | NaN | int | NaN | NaN |
PCO008033 | NaN | GROUP QUARTERS POPULATION IN COLLEGE/UNIVERSIT... | PCO8 | Total (501)!!Female!!55 to 59 years | 0 | NaN | int | NaN | NaN |
PCO008034 | NaN | GROUP QUARTERS POPULATION IN COLLEGE/UNIVERSIT... | PCO8 | Total (501)!!Female!!60 to 64 years | 0 | NaN | int | NaN | NaN |
PCO008035 | NaN | GROUP QUARTERS POPULATION IN COLLEGE/UNIVERSIT... | PCO8 | Total (501)!!Female!!65 to 69 years | 0 | NaN | int | NaN | NaN |
PCO008036 | NaN | GROUP QUARTERS POPULATION IN COLLEGE/UNIVERSIT... | PCO8 | Total (501)!!Female!!70 to 74 years | 0 | NaN | int | NaN | NaN |
df.loc['P010001']#:'P005012']
attributes NaN concept RACE FOR THE POPULATION 18 YEARS AND OVER group P10 label Total limit 0 predicateOnly NaN predicateType int required NaN values NaN Name: P010001, dtype: object
df[df.group == 'P10']
attributes | concept | group | label | limit | predicateOnly | predicateType | required | values | |
---|---|---|---|---|---|---|---|---|---|
P010014 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010015 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010016 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010017 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010010 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two races | 0 | NaN | int | NaN | NaN |
P010011 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010012 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010013 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010018 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010019 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010003 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Population of one race!!White alone | 0 | NaN | int | NaN | NaN |
P010004 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Population of one race!!Black or Africa... | 0 | NaN | int | NaN | NaN |
P010005 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Population of one race!!American Indian... | 0 | NaN | int | NaN | NaN |
P010006 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Population of one race!!Asian alone | 0 | NaN | int | NaN | NaN |
P010001 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total | 0 | NaN | int | NaN | NaN |
P010002 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Population of one race | 0 | NaN | int | NaN | NaN |
P010007 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Population of one race!!Native Hawaiian... | 0 | NaN | int | NaN | NaN |
P010008 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Population of one race!!Some Other Race... | 0 | NaN | int | NaN | NaN |
P010009 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races | 0 | NaN | int | NaN | NaN |
P010070 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of six races | 0 | NaN | int | NaN | NaN |
P010071 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of six ra... | 0 | NaN | int | NaN | NaN |
P010061 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010062 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010063 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P010064 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P010060 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010069 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P010065 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P010066 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
P010067 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of five r... | 0 | NaN | int | NaN | NaN |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
P010020 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010025 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010026 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010027 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010028 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010021 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010022 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010023 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010024 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of two ra... | 0 | NaN | int | NaN | NaN |
P010029 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010050 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010051 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010052 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010053 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010058 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010059 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010054 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010055 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010056 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010057 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010040 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010041 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010042 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010047 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010048 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010049 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of four r... | 0 | NaN | int | NaN | NaN |
P010043 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010044 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010045 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
P010046 | NaN | RACE FOR THE POPULATION 18 YEARS AND OVER | P10 | Total!!Two or More Races!!Population of three ... | 0 | NaN | int | NaN | NaN |
71 rows × 9 columns