Skip to content

Instantly share code, notes, and snippets.

@JoeGermuska
Last active December 14, 2023 19:55
Show Gist options
  • Save JoeGermuska/8da7a3e5e86600f26a48f2d3ce68910b to your computer and use it in GitHub Desktop.
Save JoeGermuska/8da7a3e5e86600f26a48f2d3ce68910b to your computer and use it in GitHub Desktop.
Read Census 2020 PL94-171 ("redistricting") files into Pandas DataFrames

Some quick work to facilitate reading data for the Census 2020 PL94-171 data release into Pandas dataframes.

Sample data for Providence County, RI can be downloaded from https://www.census.gov/programs-surveys/decennial-census/about/rdo/summary-files.html, as can auxiliary materials.

The file headers.py was created by parsing the SAS import scripts from the link above.

It seems as though the Census Bureau removed the sample data for Providence County, RI, against which this code was tested. You can get a copy of it from http://files.censusreporter.org/ri2018_2020Style.pl.zip

Note: The full data release is now available at https://www2.census.gov/programs-surveys/decennial/2020/data/01-Redistricting_File--PL_94-171/

To run this:

  • download the two .py files here and put them in a directory
  • retrieve the ZIP above, or, once the data is out, the real 2020 data for your state. Unzip it into the same directory, and, if necessary, update the filenames in FILES (in create_dataframes.py)

Then, in ipython or jupyter, enter

%run create_dataframes.py

after it's done, you should be able to use p1, p2, p3, p4, p5, and h1 in your notebook/runtime.

See headers.py for comments explaining the meaning of the different column names, or read the technical docs from Census.

import pandas as pd
from headers import *
FILES = {
'geoheader': 'rigeo2018_2020Style.pl',
'seq01': 'ri000012018_2020Style.pl',
'seq02': 'ri000022018_2020Style.pl',
'seq03': 'ri000032018_2020Style.pl',
}
gh_df = pd.read_csv(
FILES['geoheader'],
delimiter='|',
header=None,
names=GEOHEADER_COLS,
dtype=GEOHEADER_DTYPES,
encoding='latin-1' # only affects geoheader which has place names, TX, CO, PR have non-ASCII text
)
seq01_df = pd.read_csv(
FILES['seq01'],
delimiter='|',
header=None,
names=SEQ01_COLS,
dtype=SEQ01_DTYPES
)
seq02_df = pd.read_csv(
FILES['seq02'],
delimiter='|',
header=None,
names=SEQ02_COLS,
dtype=SEQ02_DTYPES
)
seq03_df = pd.read_csv(
FILES['seq03'],
delimiter='|',
header=None,
names=SEQ03_COLS,
dtype=SEQ03_DTYPES
)
seq01_merged = pd.merge(gh_df,seq01_df, on=[
'FILEID',
'STUSAB',
'CHARITER',
'LOGRECNO'])
seq02_merged = pd.merge(gh_df,seq02_df, on=[
'FILEID',
'STUSAB',
'CHARITER',
'LOGRECNO'])
seq03_merged = pd.merge(gh_df,seq03_df, on=[
'FILEID',
'STUSAB',
'CHARITER',
'LOGRECNO'])
p1_cols = ['SUMLEV', 'GEOID'] + [c for c in SEQ01_COLS if c.startswith('P001')]
p2_cols = ['SUMLEV', 'GEOID'] + [c for c in SEQ01_COLS if c.startswith('P002')]
p3_cols = ['SUMLEV', 'GEOID'] + [c for c in SEQ02_COLS if c.startswith('P003')]
p4_cols = ['SUMLEV', 'GEOID'] + [c for c in SEQ02_COLS if c.startswith('P004')]
h1_cols = ['SUMLEV', 'GEOID'] + [c for c in SEQ02_COLS if c.startswith('H001')]
p5_cols = ['SUMLEV', 'GEOID'] + [c for c in SEQ03_COLS if c.startswith('P005')]
p1 = seq01_merged[p1_cols]
p2 = seq01_merged[p2_cols]
p3 = seq02_merged[p3_cols]
p4 = seq02_merged[p4_cols]
h1 = seq02_merged[h1_cols]
p5 = seq03_merged[p5_cols]
GEOHEADER_COLS = [
'FILEID', # File Identification
'STUSAB', # State/US-Abbreviation (USPS)
'SUMLEV', # Summary Level
'GEOVAR', # Geographic Variant
'GEOCOMP', # Geographic Component
'CHARITER', # Characteristic Iteration
'CIFSN', # Characteristic Iteration File Sequence Number
'LOGRECNO', # Logical Record Number
'GEOID', # Geographic Record Identifier
'GEOCODE', # Geographic Code Identifier
'REGION', # Region
'DIVISION', # Division
'STATE', # State (FIPS)
'STATENS', # State (NS)
'COUNTY', # County (FIPS)
'COUNTYCC', # FIPS County Class Code
'COUNTYNS', # County (NS)
'COUSUB', # County Subdivision (FIPS)
'COUSUBCC', # FIPS County Subdivision Class Code
'COUSUBNS', # County Subdivision (NS)
'SUBMCD', # Subminor Civil Division (FIPS)
'SUBMCDCC', # FIPS Subminor Civil Division Class Code
'SUBMCDNS', # Subminor Civil Division (NS)
'ESTATE', # Estate (FIPS)
'ESTATECC', # FIPS Estate Class Code
'ESTATENS', # Estate (NS)
'CONCIT', # Consolidated City (FIPS)
'CONCITCC', # FIPS Consolidated City Class Code
'CONCITNS', # Consolidated City (NS)
'PLACE', # Place (FIPS)
'PLACECC', # FIPS Place Class Code
'PLACENS', # Place (NS)
'TRACT', # Census Tract
'BLKGRP', # Block Group
'BLOCK', # Block
'AIANHH', # American Indian Area/Alaska Native Area/Hawaiian Home Land (Census)
'AIHHTLI', # American Indian Trust Land/Hawaiian Home Land Indicator
'AIANHHFP', # American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS)
'AIANHHCC', # FIPS American Indian Area/Alaska Native Area/Hawaiian Home Land Class Code
'AIANHHNS', # American Indian Area/Alaska Native Area/Hawaiian Home Land (NS)
'AITS', # American Indian Tribal Subdivision (Census)
'AITSFP', # American Indian Tribal Subdivision (FIPS)
'AITSCC', # FIPS American Indian Tribal Subdivision Class Code
'AITSNS', # American Indian Tribal Subdivision (NS)
'TTRACT', # Tribal Census Tract
'TBLKGRP', # Tribal Block Group
'ANRC', # Alaska Native Regional Corporation (FIPS)
'ANRCCC', # FIPS Alaska Native Regional Corporation Class Code
'ANRCNS', # Alaska Native Regional Corporation (NS)
'CBSA', # Metropolitan Statistical Area/Micropolitan Statistical Area
'MEMI', # Metropolitan/Micropolitan Indicator
'CSA', # Combined Statistical Area
'METDIV', # Metropolitan Division
'NECTA', # New England City and Town Area
'NMEMI', # NECTA Metropolitan/Micropolitan Indicator
'CNECTA', # Combined New England City and Town Area
'NECTADIV', # New England City and Town Area Division
'CBSAPCI', # Metropolitan Statistical Area/Micropolitan Statistical Area Principal City Indicator
'NECTAPCI', # New England City and Town Area Principal City Indicator
'UA', # Urban Area
'UATYPE', # Urban Area Type
'UR', # Urban/Rural
'CD116', # Congressional District (116th)
'CD118', # Congressional District (118th)
'CD119', # Congressional District (119th)
'CD120', # Congressional District (120th)
'CD121', # Congressional District (121st)
'SLDU18', # State Legislative District (Upper Chamber) (2018)
'SLDU22', # State Legislative District (Upper Chamber) (2022)
'SLDU24', # State Legislative District (Upper Chamber) (2024)
'SLDU26', # State Legislative District (Upper Chamber) (2026)
'SLDU28', # State Legislative District (Upper Chamber) (2028)
'SLDL18', # State Legislative District (Lower Chamber) (2018)
'SLDL22', # State Legislative District (Lower Chamber) (2022)
'SLDL24', # State Legislative District (Lower Chamber) (2024)
'SLDL26', # State Legislative District (Lower Chamber) (2026)
'SLDL28', # State Legislative District (Lower Chamber) (2028)
'VTD', # Voting District
'VTDI', # Voting District Indicator
'ZCTA', # ZIP Code Tabulation Area (5-Digit)
'SDELM', # School District (Elementary)
'SDSEC', # School District (Secondary)
'SDUNI', # School District (Unified)
'PUMA', # Public Use Microdata Area
'AREALAND', # Area (Land)
'AREAWATR', # Area (Water)
'BASENAME', # Area Base Name
'NAME', # Area Name-Legal/Statistical Area Description (LSAD) Term-Part Indicator
'FUNCSTAT', # Functional Status Code
'GCUNI', # Geographic Change User Note Indicator
'POP100', # Population Count (100%)
'HU100', # Housing Unit Count (100%)
'INTPTLAT', # Internal Point (Latitude)
'INTPTLON', # Internal Point (Longitude)
'LSADC', # Legal/Statistical Area Description Code
'PARTFLAG', # Part Flag
'UGA', # Urban Growth Area
]
GEOHEADER_DTYPES = {
'FILEID': 'object', # File Identification
'STUSAB': 'object', # State/US-Abbreviation (USPS)
'SUMLEV': 'object', # Summary Level
'GEOVAR': 'object', # Geographic Variant
'GEOCOMP': 'object', # Geographic Component
'CHARITER': 'object', # Characteristic Iteration
'CIFSN': 'object', # Characteristic Iteration File Sequence Number
'LOGRECNO': 'object', # Logical Record Number
'GEOID': 'object', # Geographic Record Identifier
'GEOCODE': 'object', # Geographic Code Identifier
'REGION': 'object', # Region
'DIVISION': 'object', # Division
'STATE': 'object', # State (FIPS)
'STATENS': 'object', # State (NS)
'COUNTY': 'object', # County (FIPS)
'COUNTYCC': 'object', # FIPS County Class Code
'COUNTYNS': 'object', # County (NS)
'COUSUB': 'object', # County Subdivision (FIPS)
'COUSUBCC': 'object', # FIPS County Subdivision Class Code
'COUSUBNS': 'object', # County Subdivision (NS)
'SUBMCD': 'object', # Subminor Civil Division (FIPS)
'SUBMCDCC': 'object', # FIPS Subminor Civil Division Class Code
'SUBMCDNS': 'object', # Subminor Civil Division (NS)
'ESTATE': 'object', # Estate (FIPS)
'ESTATECC': 'object', # FIPS Estate Class Code
'ESTATENS': 'object', # Estate (NS)
'CONCIT': 'object', # Consolidated City (FIPS)
'CONCITCC': 'object', # FIPS Consolidated City Class Code
'CONCITNS': 'object', # Consolidated City (NS)
'PLACE': 'object', # Place (FIPS)
'PLACECC': 'object', # FIPS Place Class Code
'PLACENS': 'object', # Place (NS)
'TRACT': 'object', # Census Tract
'BLKGRP': 'object', # Block Group
'BLOCK': 'object', # Block
'AIANHH': 'object', # American Indian Area/Alaska Native Area/Hawaiian Home Land (Census)
'AIHHTLI': 'object', # American Indian Trust Land/Hawaiian Home Land Indicator
'AIANHHFP': 'object', # American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS)
'AIANHHCC': 'object', # FIPS American Indian Area/Alaska Native Area/Hawaiian Home Land Class Code
'AIANHHNS': 'object', # American Indian Area/Alaska Native Area/Hawaiian Home Land (NS)
'AITS': 'object', # American Indian Tribal Subdivision (Census)
'AITSFP': 'object', # American Indian Tribal Subdivision (FIPS)
'AITSCC': 'object', # FIPS American Indian Tribal Subdivision Class Code
'AITSNS': 'object', # American Indian Tribal Subdivision (NS)
'TTRACT': 'object', # Tribal Census Tract
'TBLKGRP': 'object', # Tribal Block Group
'ANRC': 'object', # Alaska Native Regional Corporation (FIPS)
'ANRCCC': 'object', # FIPS Alaska Native Regional Corporation Class Code
'ANRCNS': 'object', # Alaska Native Regional Corporation (NS)
'CBSA': 'object', # Metropolitan Statistical Area/Micropolitan Statistical Area
'MEMI': 'object', # Metropolitan/Micropolitan Indicator
'CSA': 'object', # Combined Statistical Area
'METDIV': 'object', # Metropolitan Division
'NECTA': 'object', # New England City and Town Area
'NMEMI': 'object', # NECTA Metropolitan/Micropolitan Indicator
'CNECTA': 'object', # Combined New England City and Town Area
'NECTADIV': 'object', # New England City and Town Area Division
'CBSAPCI': 'object', # Metropolitan Statistical Area/Micropolitan Statistical Area Principal City Indicator
'NECTAPCI': 'object', # New England City and Town Area Principal City Indicator
'UA': 'object', # Urban Area
'UATYPE': 'object', # Urban Area Type
'UR': 'object', # Urban/Rural
'CD116': 'object', # Congressional District (116th)
'CD118': 'object', # Congressional District (118th)
'CD119': 'object', # Congressional District (119th)
'CD120': 'object', # Congressional District (120th)
'CD121': 'object', # Congressional District (121st)
'SLDU18': 'object', # State Legislative District (Upper Chamber) (2018)
'SLDU22': 'object', # State Legislative District (Upper Chamber) (2022)
'SLDU24': 'object', # State Legislative District (Upper Chamber) (2024)
'SLDU26': 'object', # State Legislative District (Upper Chamber) (2026)
'SLDU28': 'object', # State Legislative District (Upper Chamber) (2028)
'SLDL18': 'object', # State Legislative District (Lower Chamber) (2018)
'SLDL22': 'object', # State Legislative District (Lower Chamber) (2022)
'SLDL24': 'object', # State Legislative District (Lower Chamber) (2024)
'SLDL26': 'object', # State Legislative District (Lower Chamber) (2026)
'SLDL28': 'object', # State Legislative District (Lower Chamber) (2028)
'VTD': 'object', # Voting District
'VTDI': 'object', # Voting District Indicator
'ZCTA': 'object', # ZIP Code Tabulation Area (5-Digit)
'SDELM': 'object', # School District (Elementary)
'SDSEC': 'object', # School District (Secondary)
'SDUNI': 'object', # School District (Unified)
'PUMA': 'object', # Public Use Microdata Area
'AREALAND': 'object', # Area (Land)
'AREAWATR': 'object', # Area (Water)
'BASENAME': 'object', # Area Base Name
'NAME': 'object', # Area Name-Legal/Statistical Area Description (LSAD) Term-Part Indicator
'FUNCSTAT': 'object', # Functional Status Code
'GCUNI': 'object', # Geographic Change User Note Indicator
'POP100': 'object', # Population Count (100%)
'HU100': 'object', # Housing Unit Count (100%)
'INTPTLAT': 'object', # Internal Point (Latitude)
'INTPTLON': 'object', # Internal Point (Longitude)
'LSADC': 'object', # Legal/Statistical Area Description Code
'PARTFLAG': 'object', # Part Flag
'UGA': 'object', # Urban Growth Area
}
SEQ01_COLS = [
'FILEID', # File Identification
'STUSAB', # State/US-Abbreviation (USPS)
'CHARITER', # Characteristic Iteration
'CIFSN', # Characteristic Iteration File Sequence Number
'LOGRECNO', # Logical Record Number
'P0010001', # Total:
'P0010002', # Population of one race:
'P0010003', # White alone
'P0010004', # Black or African American alone
'P0010005', # American Indian and Alaska Native alone
'P0010006', # Asian alone
'P0010007', # Native Hawaiian and Other Pacific Islander alone
'P0010008', # Some Other Race alone
'P0010009', # Population of two or more races:
'P0010010', # Population of two races:
'P0010011', # White; Black or African American
'P0010012', # White; American Indian and Alaska Native
'P0010013', # White; Asian
'P0010014', # White; Native Hawaiian and Other Pacific Islander
'P0010015', # White; Some Other Race
'P0010016', # Black or African American; American Indian and Alaska Native
'P0010017', # Black or African American; Asian
'P0010018', # Black or African American; Native Hawaiian and Other Pacific Islander
'P0010019', # Black or African American; Some Other Race
'P0010020', # American Indian and Alaska Native; Asian
'P0010021', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010022', # American Indian and Alaska Native; Some Other Race
'P0010023', # Asian; Native Hawaiian and Other Pacific Islander
'P0010024', # Asian; Some Other Race
'P0010025', # Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010026', # Population of three races:
'P0010027', # White; Black or African American; American Indian and Alaska Native
'P0010028', # White; Black or African American; Asian
'P0010029', # White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0010030', # White; Black or African American; Some Other Race
'P0010031', # White; American Indian and Alaska Native; Asian
'P0010032', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010033', # White; American Indian and Alaska Native; Some Other Race
'P0010034', # White; Asian; Native Hawaiian and Other Pacific Islander
'P0010035', # White; Asian; Some Other Race
'P0010036', # White; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010037', # Black or African American; American Indian and Alaska Native; Asian
'P0010038', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010039', # Black or African American; American Indian and Alaska Native; Some Other Race
'P0010040', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0010041', # Black or African American; Asian; Some Other Race
'P0010042', # Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010043', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010044', # American Indian and Alaska Native; Asian; Some Other Race
'P0010045', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010046', # Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010047', # Population of four races:
'P0010048', # White; Black or African American; American Indian and Alaska Native; Asian
'P0010049', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010050', # White; Black or African American; American Indian and Alaska Native; Some Other Race
'P0010051', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0010052', # White; Black or African American; Asian; Some Other Race
'P0010053', # White; Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010054', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010055', # White; American Indian and Alaska Native; Asian; Some Other Race
'P0010056', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010057', # White; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010058', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010059', # Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0010060', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010061', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010062', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010063', # Population of five races:
'P0010064', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010065', # White; Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0010066', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010067', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010068', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010069', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010070', # Population of six races:
'P0010071', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020001', # Total:
'P0020002', # Hispanic or Latino
'P0020003', # Not Hispanic or Latino:
'P0020004', # Population of one race:
'P0020005', # White alone
'P0020006', # Black or African American alone
'P0020007', # American Indian and Alaska Native alone
'P0020008', # Asian alone
'P0020009', # Native Hawaiian and Other Pacific Islander alone
'P0020010', # Some Other Race alone
'P0020011', # Population of two or more races:
'P0020012', # Population of two races:
'P0020013', # White; Black or African American
'P0020014', # White; American Indian and Alaska Native
'P0020015', # White; Asian
'P0020016', # White; Native Hawaiian and Other Pacific Islander
'P0020017', # White; Some Other Race
'P0020018', # Black or African American; American Indian and Alaska Native
'P0020019', # Black or African American; Asian
'P0020020', # Black or African American; Native Hawaiian and Other Pacific Islander
'P0020021', # Black or African American; Some Other Race
'P0020022', # American Indian and Alaska Native; Asian
'P0020023', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020024', # American Indian and Alaska Native; Some Other Race
'P0020025', # Asian; Native Hawaiian and Other Pacific Islander
'P0020026', # Asian; Some Other Race
'P0020027', # Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020028', # Population of three races:
'P0020029', # White; Black or African American; American Indian and Alaska Native
'P0020030', # White; Black or African American; Asian
'P0020031', # White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0020032', # White; Black or African American; Some Other Race
'P0020033', # White; American Indian and Alaska Native; Asian
'P0020034', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020035', # White; American Indian and Alaska Native; Some Other Race
'P0020036', # White; Asian; Native Hawaiian and Other Pacific Islander
'P0020037', # White; Asian; Some Other Race
'P0020038', # White; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020039', # Black or African American; American Indian and Alaska Native; Asian
'P0020040', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020041', # Black or African American; American Indian and Alaska Native; Some Other Race
'P0020042', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0020043', # Black or African American; Asian; Some Other Race
'P0020044', # Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020045', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020046', # American Indian and Alaska Native; Asian; Some Other Race
'P0020047', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020048', # Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020049', # Population of four races:
'P0020050', # White; Black or African American; American Indian and Alaska Native; Asian
'P0020051', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020052', # White; Black or African American; American Indian and Alaska Native; Some Other Race
'P0020053', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0020054', # White; Black or African American; Asian; Some Other Race
'P0020055', # White; Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020056', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020057', # White; American Indian and Alaska Native; Asian; Some Other Race
'P0020058', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020059', # White; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020060', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020061', # Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0020062', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020063', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020064', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020065', # Population of five races:
'P0020066', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020067', # White; Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0020068', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020069', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020070', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020071', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020072', # Population of six races:
'P0020073', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
]
SEQ01_DTYPES = {
'FILEID': 'object', # File Identification
'STUSAB': 'object', # State/US-Abbreviation (USPS)
'CHARITER': 'object', # Characteristic Iteration
'CIFSN': 'object', # Characteristic Iteration File Sequence Number
'LOGRECNO': 'object', # Logical Record Number
'P0010001': 'int', # Total:
'P0010002': 'int', # Population of one race:
'P0010003': 'int', # White alone
'P0010004': 'int', # Black or African American alone
'P0010005': 'int', # American Indian and Alaska Native alone
'P0010006': 'int', # Asian alone
'P0010007': 'int', # Native Hawaiian and Other Pacific Islander alone
'P0010008': 'int', # Some Other Race alone
'P0010009': 'int', # Population of two or more races:
'P0010010': 'int', # Population of two races:
'P0010011': 'int', # White; Black or African American
'P0010012': 'int', # White; American Indian and Alaska Native
'P0010013': 'int', # White; Asian
'P0010014': 'int', # White; Native Hawaiian and Other Pacific Islander
'P0010015': 'int', # White; Some Other Race
'P0010016': 'int', # Black or African American; American Indian and Alaska Native
'P0010017': 'int', # Black or African American; Asian
'P0010018': 'int', # Black or African American; Native Hawaiian and Other Pacific Islander
'P0010019': 'int', # Black or African American; Some Other Race
'P0010020': 'int', # American Indian and Alaska Native; Asian
'P0010021': 'int', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010022': 'int', # American Indian and Alaska Native; Some Other Race
'P0010023': 'int', # Asian; Native Hawaiian and Other Pacific Islander
'P0010024': 'int', # Asian; Some Other Race
'P0010025': 'int', # Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010026': 'int', # Population of three races:
'P0010027': 'int', # White; Black or African American; American Indian and Alaska Native
'P0010028': 'int', # White; Black or African American; Asian
'P0010029': 'int', # White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0010030': 'int', # White; Black or African American; Some Other Race
'P0010031': 'int', # White; American Indian and Alaska Native; Asian
'P0010032': 'int', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010033': 'int', # White; American Indian and Alaska Native; Some Other Race
'P0010034': 'int', # White; Asian; Native Hawaiian and Other Pacific Islander
'P0010035': 'int', # White; Asian; Some Other Race
'P0010036': 'int', # White; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010037': 'int', # Black or African American; American Indian and Alaska Native; Asian
'P0010038': 'int', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010039': 'int', # Black or African American; American Indian and Alaska Native; Some Other Race
'P0010040': 'int', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0010041': 'int', # Black or African American; Asian; Some Other Race
'P0010042': 'int', # Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010043': 'int', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010044': 'int', # American Indian and Alaska Native; Asian; Some Other Race
'P0010045': 'int', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010046': 'int', # Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010047': 'int', # Population of four races:
'P0010048': 'int', # White; Black or African American; American Indian and Alaska Native; Asian
'P0010049': 'int', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0010050': 'int', # White; Black or African American; American Indian and Alaska Native; Some Other Race
'P0010051': 'int', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0010052': 'int', # White; Black or African American; Asian; Some Other Race
'P0010053': 'int', # White; Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010054': 'int', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010055': 'int', # White; American Indian and Alaska Native; Asian; Some Other Race
'P0010056': 'int', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010057': 'int', # White; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010058': 'int', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010059': 'int', # Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0010060': 'int', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010061': 'int', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010062': 'int', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010063': 'int', # Population of five races:
'P0010064': 'int', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0010065': 'int', # White; Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0010066': 'int', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010067': 'int', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010068': 'int', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010069': 'int', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0010070': 'int', # Population of six races:
'P0010071': 'int', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020001': 'int', # Total:
'P0020002': 'int', # Hispanic or Latino
'P0020003': 'int', # Not Hispanic or Latino:
'P0020004': 'int', # Population of one race:
'P0020005': 'int', # White alone
'P0020006': 'int', # Black or African American alone
'P0020007': 'int', # American Indian and Alaska Native alone
'P0020008': 'int', # Asian alone
'P0020009': 'int', # Native Hawaiian and Other Pacific Islander alone
'P0020010': 'int', # Some Other Race alone
'P0020011': 'int', # Population of two or more races:
'P0020012': 'int', # Population of two races:
'P0020013': 'int', # White; Black or African American
'P0020014': 'int', # White; American Indian and Alaska Native
'P0020015': 'int', # White; Asian
'P0020016': 'int', # White; Native Hawaiian and Other Pacific Islander
'P0020017': 'int', # White; Some Other Race
'P0020018': 'int', # Black or African American; American Indian and Alaska Native
'P0020019': 'int', # Black or African American; Asian
'P0020020': 'int', # Black or African American; Native Hawaiian and Other Pacific Islander
'P0020021': 'int', # Black or African American; Some Other Race
'P0020022': 'int', # American Indian and Alaska Native; Asian
'P0020023': 'int', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020024': 'int', # American Indian and Alaska Native; Some Other Race
'P0020025': 'int', # Asian; Native Hawaiian and Other Pacific Islander
'P0020026': 'int', # Asian; Some Other Race
'P0020027': 'int', # Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020028': 'int', # Population of three races:
'P0020029': 'int', # White; Black or African American; American Indian and Alaska Native
'P0020030': 'int', # White; Black or African American; Asian
'P0020031': 'int', # White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0020032': 'int', # White; Black or African American; Some Other Race
'P0020033': 'int', # White; American Indian and Alaska Native; Asian
'P0020034': 'int', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020035': 'int', # White; American Indian and Alaska Native; Some Other Race
'P0020036': 'int', # White; Asian; Native Hawaiian and Other Pacific Islander
'P0020037': 'int', # White; Asian; Some Other Race
'P0020038': 'int', # White; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020039': 'int', # Black or African American; American Indian and Alaska Native; Asian
'P0020040': 'int', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020041': 'int', # Black or African American; American Indian and Alaska Native; Some Other Race
'P0020042': 'int', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0020043': 'int', # Black or African American; Asian; Some Other Race
'P0020044': 'int', # Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020045': 'int', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020046': 'int', # American Indian and Alaska Native; Asian; Some Other Race
'P0020047': 'int', # American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020048': 'int', # Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020049': 'int', # Population of four races:
'P0020050': 'int', # White; Black or African American; American Indian and Alaska Native; Asian
'P0020051': 'int', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0020052': 'int', # White; Black or African American; American Indian and Alaska Native; Some Other Race
'P0020053': 'int', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0020054': 'int', # White; Black or African American; Asian; Some Other Race
'P0020055': 'int', # White; Black or African American; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020056': 'int', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020057': 'int', # White; American Indian and Alaska Native; Asian; Some Other Race
'P0020058': 'int', # White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020059': 'int', # White; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020060': 'int', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020061': 'int', # Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0020062': 'int', # Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020063': 'int', # Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020064': 'int', # American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020065': 'int', # Population of five races:
'P0020066': 'int', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0020067': 'int', # White; Black or African American; American Indian and Alaska Native; Asian; Some Other Race
'P0020068': 'int', # White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020069': 'int', # White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020070': 'int', # White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020071': 'int', # Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
'P0020072': 'int', # Population of six races:
'P0020073': 'int', # White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some Other Race
}
SEQ02_COLS = [
'FILEID', # File Identification
'STUSAB', # State/US-Abbreviation (USPS)
'CHARITER', # Characteristic Iteration
'CIFSN', # Characteristic Iteration File Sequence Number
'LOGRECNO', # Logical Record Number
'P0030001', # P3-1: Total
'P0030002', # P3-2: Population of one race
'P0030003', # P3-3: White alone
'P0030004', # P3-4: Black or African American alone
'P0030005', # P3-5: American Indian and Alaska Native alone
'P0030006', # P3-6: Asian alone
'P0030007', # P3-7: Native Hawaiian and Other Pacific Islander alone
'P0030008', # P3-8: Some other race alone
'P0030009', # P3-9: Population of two or more races
'P0030010', # P3-10: Population of two races
'P0030011', # P3-11: White; Black or African American
'P0030012', # P3-12: White; American Indian and Alaska Native
'P0030013', # P3-13: White; Asian
'P0030014', # P3-14: White; Native Hawaiian and Other Pacific Islander
'P0030015', # P3-15: White; Some other race
'P0030016', # P3-16: Black or African American; American Indian and Alaska Native
'P0030017', # P3-17: Black or African American; Asian
'P0030018', # P3-18: Black or African American; Native Hawaiian and Other Pacific Islander
'P0030019', # P3-19: Black or African American; Some other race
'P0030020', # P3-20: American Indian and Alaska Native; Asian
'P0030021', # P3-21: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030022', # P3-22: American Indian and Alaska Native; Some other race
'P0030023', # P3-23: Asian; Native Hawaiian and Other Pacific Islander
'P0030024', # P3-24: Asian; Some other race
'P0030025', # P3-25: Native Hawaiian and Other Pacific Islander; Some other race
'P0030026', # P3-26: Population of three races
'P0030027', # P3-27: White; Black or African American; American Indian and Alaska Native
'P0030028', # P3-28: White; Black or African American; Asian
'P0030029', # P3-29: White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0030030', # P3-30: White; Black or African American; Some other race
'P0030031', # P3-31: White; American Indian and Alaska Native; Asian
'P0030032', # P3-32: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030033', # P3-33: White; American Indian and Alaska Native; Some other race
'P0030034', # P3-34: White; Asian; Native Hawaiian and Other Pacific Islander
'P0030035', # P3-35: White; Asian; Some other race
'P0030036', # P3-36: White; Native Hawaiian and Other Pacific Islander; Some other race
'P0030037', # P3-37: Black or African American; American Indian and Alaska Native; Asian
'P0030038', # P3-38: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030039', # P3-39: Black or African American; American Indian and Alaska Native; Some other race
'P0030040', # P3-40: Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0030041', # P3-41: Black or African American; Asian; Some other race
'P0030042', # P3-42: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0030043', # P3-43: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030044', # P3-44: American Indian and Alaska Native; Asian; Some other race
'P0030045', # P3-45: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030046', # P3-46: Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030047', # P3-47: Population of four races
'P0030048', # P3-48: White; Black or African American; American Indian and Alaska Native; Asian
'P0030049', # P3-49: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030050', # P3-50: White; Black or African American; American Indian and Alaska Native; Some other race
'P0030051', # P3-51: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0030052', # P3-52: White; Black or African American; Asian; Some other race
'P0030053', # P3-53: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0030054', # P3-54: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030055', # P3-55: White; American Indian and Alaska Native; Asian; Some other race
'P0030056', # P3-56: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030057', # P3-57: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030058', # P3-58: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030059', # P3-59: Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0030060', # P3-60: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030061', # P3-61: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030062', # P3-62: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030063', # P3-63: Population of five races
'P0030064', # P3-64: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030065', # P3-65: White; Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0030066', # P3-66: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030067', # P3-67: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030068', # P3-68: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030069', # P3-69: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030070', # P3-70: Population of six races
'P0030071', # P3-71: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040001', # P4-1: Total
'P0040002', # P4-2: Hispanic or Latino
'P0040003', # P4-3: Not Hispanic or Latino
'P0040004', # P4-4: Population of one race
'P0040005', # P4-5: White alone
'P0040006', # P4-6: Black or African American alone
'P0040007', # P4-7: American Indian and Alaska Native alone
'P0040008', # P4-8: Asian alone
'P0040009', # P4-9: Native Hawaiian and Other Pacific Islander alone
'P0040010', # P4-10: Some other race alone
'P0040011', # P4-11: Population of two or more races
'P0040012', # P4-12: Population of two races
'P0040013', # P4-13: White; Black or African American
'P0040014', # P4-14: White; American Indian and Alaska Native
'P0040015', # P4-15: White; Asian
'P0040016', # P4-16: White; Native Hawaiian and Other Pacific Islander
'P0040017', # P4-17: White; Some other race
'P0040018', # P4-18: Black or African American; American Indian and Alaska Native
'P0040019', # P4-19: Black or African American; Asian
'P0040020', # P4-20: Black or African American; Native Hawaiian and Other Pacific Islander
'P0040021', # P4-21: Black or African American; Some other race
'P0040022', # P4-22: American Indian and Alaska Native; Asian
'P0040023', # P4-23: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040024', # P4-24: American Indian and Alaska Native; Some other race
'P0040025', # P4-25: Asian; Native Hawaiian and Other Pacific Islander
'P0040026', # P4-26: Asian; Some other race
'P0040027', # P4-27: Native Hawaiian and Other Pacific Islander; Some other race
'P0040028', # P4-28: Population of three races
'P0040029', # P4-29: White; Black or African American; American Indian and Alaska Native
'P0040030', # P4-30: White; Black or African American; Asian
'P0040031', # P4-31: White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0040032', # P4-32: White; Black or African American; Some other race
'P0040033', # P4-33: White; American Indian and Alaska Native; Asian
'P0040034', # P4-34: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040035', # P4-35: White; American Indian and Alaska Native; Some other race
'P0040036', # P4-36: White; Asian; Native Hawaiian and Other Pacific Islander
'P0040037', # P4-37: White; Asian; Some other race
'P0040038', # P4-38: White; Native Hawaiian and Other Pacific Islander; Some other race
'P0040039', # P4-39: Black or African American; American Indian and Alaska Native; Asian
'P0040040', # P4-40: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040041', # P4-41: Black or African American; American Indian and Alaska Native; Some other race
'P0040042', # P4-42: Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0040043', # P4-43: Black or African American; Asian; Some other race
'P0040044', # P4-44: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0040045', # P4-45: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040046', # P4-46: American Indian and Alaska Native; Asian; Some other race
'P0040047', # P4-47: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040048', # P4-48: Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040049', # P4-49: Population of four races
'P0040050', # P4-50: White; Black or African American; American Indian and Alaska Native; Asian
'P0040051', # P4-51: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040052', # P4-52: White; Black or African American; American Indian and Alaska Native; Some other race
'P0040053', # P4-53: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0040054', # P4-54: White; Black or African American; Asian; Some other race
'P0040055', # P4-55: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0040056', # P4-56: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040057', # P4-57: White; American Indian and Alaska Native; Asian; Some other race
'P0040058', # P4-58: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040059', # P4-59: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040060', # P4-60: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040061', # P4-61: Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0040062', # P4-62: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040063', # P4-63: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040064', # P4-64: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040065', # P4-65: Population of five races
'P0040066', # P4-66: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040067', # P4-67: White; Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0040068', # P4-68: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040069', # P4-69: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040070', # P4-70: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040071', # P4-71: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040072', # P4-72: Population of six races
'P0040073', # P4-73: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'H0010001', # H1-1: Total
'H0010002', # H1-2: Occupied
'H0010003', # H1-3: Vacant
]
SEQ02_DTYPES = {
'FILEID': 'object', # File Identification
'STUSAB': 'object', # State/US-Abbreviation (USPS)
'CHARITER': 'object', # Characteristic Iteration
'CIFSN': 'object', # Characteristic Iteration File Sequence Number
'LOGRECNO': 'object', # Logical Record Number
'P0030001': 'int', # P3-1: Total
'P0030002': 'int', # P3-2: Population of one race
'P0030003': 'int', # P3-3: White alone
'P0030004': 'int', # P3-4: Black or African American alone
'P0030005': 'int', # P3-5: American Indian and Alaska Native alone
'P0030006': 'int', # P3-6: Asian alone
'P0030007': 'int', # P3-7: Native Hawaiian and Other Pacific Islander alone
'P0030008': 'int', # P3-8: Some other race alone
'P0030009': 'int', # P3-9: Population of two or more races
'P0030010': 'int', # P3-10: Population of two races
'P0030011': 'int', # P3-11: White; Black or African American
'P0030012': 'int', # P3-12: White; American Indian and Alaska Native
'P0030013': 'int', # P3-13: White; Asian
'P0030014': 'int', # P3-14: White; Native Hawaiian and Other Pacific Islander
'P0030015': 'int', # P3-15: White; Some other race
'P0030016': 'int', # P3-16: Black or African American; American Indian and Alaska Native
'P0030017': 'int', # P3-17: Black or African American; Asian
'P0030018': 'int', # P3-18: Black or African American; Native Hawaiian and Other Pacific Islander
'P0030019': 'int', # P3-19: Black or African American; Some other race
'P0030020': 'int', # P3-20: American Indian and Alaska Native; Asian
'P0030021': 'int', # P3-21: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030022': 'int', # P3-22: American Indian and Alaska Native; Some other race
'P0030023': 'int', # P3-23: Asian; Native Hawaiian and Other Pacific Islander
'P0030024': 'int', # P3-24: Asian; Some other race
'P0030025': 'int', # P3-25: Native Hawaiian and Other Pacific Islander; Some other race
'P0030026': 'int', # P3-26: Population of three races
'P0030027': 'int', # P3-27: White; Black or African American; American Indian and Alaska Native
'P0030028': 'int', # P3-28: White; Black or African American; Asian
'P0030029': 'int', # P3-29: White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0030030': 'int', # P3-30: White; Black or African American; Some other race
'P0030031': 'int', # P3-31: White; American Indian and Alaska Native; Asian
'P0030032': 'int', # P3-32: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030033': 'int', # P3-33: White; American Indian and Alaska Native; Some other race
'P0030034': 'int', # P3-34: White; Asian; Native Hawaiian and Other Pacific Islander
'P0030035': 'int', # P3-35: White; Asian; Some other race
'P0030036': 'int', # P3-36: White; Native Hawaiian and Other Pacific Islander; Some other race
'P0030037': 'int', # P3-37: Black or African American; American Indian and Alaska Native; Asian
'P0030038': 'int', # P3-38: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030039': 'int', # P3-39: Black or African American; American Indian and Alaska Native; Some other race
'P0030040': 'int', # P3-40: Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0030041': 'int', # P3-41: Black or African American; Asian; Some other race
'P0030042': 'int', # P3-42: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0030043': 'int', # P3-43: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030044': 'int', # P3-44: American Indian and Alaska Native; Asian; Some other race
'P0030045': 'int', # P3-45: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030046': 'int', # P3-46: Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030047': 'int', # P3-47: Population of four races
'P0030048': 'int', # P3-48: White; Black or African American; American Indian and Alaska Native; Asian
'P0030049': 'int', # P3-49: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0030050': 'int', # P3-50: White; Black or African American; American Indian and Alaska Native; Some other race
'P0030051': 'int', # P3-51: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0030052': 'int', # P3-52: White; Black or African American; Asian; Some other race
'P0030053': 'int', # P3-53: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0030054': 'int', # P3-54: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030055': 'int', # P3-55: White; American Indian and Alaska Native; Asian; Some other race
'P0030056': 'int', # P3-56: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030057': 'int', # P3-57: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030058': 'int', # P3-58: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030059': 'int', # P3-59: Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0030060': 'int', # P3-60: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030061': 'int', # P3-61: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030062': 'int', # P3-62: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030063': 'int', # P3-63: Population of five races
'P0030064': 'int', # P3-64: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0030065': 'int', # P3-65: White; Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0030066': 'int', # P3-66: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0030067': 'int', # P3-67: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030068': 'int', # P3-68: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030069': 'int', # P3-69: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0030070': 'int', # P3-70: Population of six races
'P0030071': 'int', # P3-71: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040001': 'int', # P4-1: Total
'P0040002': 'int', # P4-2: Hispanic or Latino
'P0040003': 'int', # P4-3: Not Hispanic or Latino
'P0040004': 'int', # P4-4: Population of one race
'P0040005': 'int', # P4-5: White alone
'P0040006': 'int', # P4-6: Black or African American alone
'P0040007': 'int', # P4-7: American Indian and Alaska Native alone
'P0040008': 'int', # P4-8: Asian alone
'P0040009': 'int', # P4-9: Native Hawaiian and Other Pacific Islander alone
'P0040010': 'int', # P4-10: Some other race alone
'P0040011': 'int', # P4-11: Population of two or more races
'P0040012': 'int', # P4-12: Population of two races
'P0040013': 'int', # P4-13: White; Black or African American
'P0040014': 'int', # P4-14: White; American Indian and Alaska Native
'P0040015': 'int', # P4-15: White; Asian
'P0040016': 'int', # P4-16: White; Native Hawaiian and Other Pacific Islander
'P0040017': 'int', # P4-17: White; Some other race
'P0040018': 'int', # P4-18: Black or African American; American Indian and Alaska Native
'P0040019': 'int', # P4-19: Black or African American; Asian
'P0040020': 'int', # P4-20: Black or African American; Native Hawaiian and Other Pacific Islander
'P0040021': 'int', # P4-21: Black or African American; Some other race
'P0040022': 'int', # P4-22: American Indian and Alaska Native; Asian
'P0040023': 'int', # P4-23: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040024': 'int', # P4-24: American Indian and Alaska Native; Some other race
'P0040025': 'int', # P4-25: Asian; Native Hawaiian and Other Pacific Islander
'P0040026': 'int', # P4-26: Asian; Some other race
'P0040027': 'int', # P4-27: Native Hawaiian and Other Pacific Islander; Some other race
'P0040028': 'int', # P4-28: Population of three races
'P0040029': 'int', # P4-29: White; Black or African American; American Indian and Alaska Native
'P0040030': 'int', # P4-30: White; Black or African American; Asian
'P0040031': 'int', # P4-31: White; Black or African American; Native Hawaiian and Other Pacific Islander
'P0040032': 'int', # P4-32: White; Black or African American; Some other race
'P0040033': 'int', # P4-33: White; American Indian and Alaska Native; Asian
'P0040034': 'int', # P4-34: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040035': 'int', # P4-35: White; American Indian and Alaska Native; Some other race
'P0040036': 'int', # P4-36: White; Asian; Native Hawaiian and Other Pacific Islander
'P0040037': 'int', # P4-37: White; Asian; Some other race
'P0040038': 'int', # P4-38: White; Native Hawaiian and Other Pacific Islander; Some other race
'P0040039': 'int', # P4-39: Black or African American; American Indian and Alaska Native; Asian
'P0040040': 'int', # P4-40: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040041': 'int', # P4-41: Black or African American; American Indian and Alaska Native; Some other race
'P0040042': 'int', # P4-42: Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0040043': 'int', # P4-43: Black or African American; Asian; Some other race
'P0040044': 'int', # P4-44: Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0040045': 'int', # P4-45: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040046': 'int', # P4-46: American Indian and Alaska Native; Asian; Some other race
'P0040047': 'int', # P4-47: American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040048': 'int', # P4-48: Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040049': 'int', # P4-49: Population of four races
'P0040050': 'int', # P4-50: White; Black or African American; American Indian and Alaska Native; Asian
'P0040051': 'int', # P4-51: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander
'P0040052': 'int', # P4-52: White; Black or African American; American Indian and Alaska Native; Some other race
'P0040053': 'int', # P4-53: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander
'P0040054': 'int', # P4-54: White; Black or African American; Asian; Some other race
'P0040055': 'int', # P4-55: White; Black or African American; Native Hawaiian and Other Pacific Islander; Some other race
'P0040056': 'int', # P4-56: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040057': 'int', # P4-57: White; American Indian and Alaska Native; Asian; Some other race
'P0040058': 'int', # P4-58: White; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040059': 'int', # P4-59: White; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040060': 'int', # P4-60: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040061': 'int', # P4-61: Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0040062': 'int', # P4-62: Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040063': 'int', # P4-63: Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040064': 'int', # P4-64: American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040065': 'int', # P4-65: Population of five races
'P0040066': 'int', # P4-66: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander
'P0040067': 'int', # P4-67: White; Black or African American; American Indian and Alaska Native; Asian; Some other race
'P0040068': 'int', # P4-68: White; Black or African American; American Indian and Alaska Native; Native Hawaiian and Other Pacific Islander; Some other race
'P0040069': 'int', # P4-69: White; Black or African American; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040070': 'int', # P4-70: White; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040071': 'int', # P4-71: Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'P0040072': 'int', # P4-72: Population of six races
'P0040073': 'int', # P4-73: White; Black or African American; American Indian and Alaska Native; Asian; Native Hawaiian and Other Pacific Islander; Some other race
'H0010001': 'int', # H1-1: Total
'H0010002': 'int', # H1-2: Occupied
'H0010003': 'int', # H1-3: Vacant
}
SEQ03_COLS = [
'FILEID', # File Identification
'STUSAB', # State/US-Abbreviation (USPS)
'CHARITER', # Characteristic Iteration
'CIFSN', # Characteristic Iteration File Sequence Number
'LOGRECNO', # Logical Record Number
'P0050001', # Total:
'P0050002', # Institutionalized population:
'P0050003', # Correctional facilities for adults
'P0050004', # Juvenile facilities
'P0050005', # Nursing facilities/Skilled-nursing facilities
'P0050006', # Other institutional facilities
'P0050007', # Noninstitutionalized population:
'P0050008', # College/University student housing
'P0050009', # Military quarters
'P0050010', # Other noninstitutional facilities
]
SEQ03_DTYPES = {
'FILEID': 'object', # File Identification
'STUSAB': 'object', # State/US-Abbreviation (USPS)
'CHARITER': 'object', # Characteristic Iteration
'CIFSN': 'object', # Characteristic Iteration File Sequence Number
'LOGRECNO': 'object', # Logical Record Number
'P0050001': 'int', # Total:
'P0050002': 'int', # Institutionalized population:
'P0050003': 'int', # Correctional facilities for adults
'P0050004': 'int', # Juvenile facilities
'P0050005': 'int', # Nursing facilities/Skilled-nursing facilities
'P0050006': 'int', # Other institutional facilities
'P0050007': 'int', # Noninstitutionalized population:
'P0050008': 'int', # College/University student housing
'P0050009': 'int', # Military quarters
'P0050010': 'int', # Other noninstitutional facilities
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment