📊 census

U.S. Census Bureau demographic and population data including American Community Survey (ACS) estimates, decennial census results, and population estimates. Provides comprehensive demographic profiles, household characteristics, income distributions, educational attainment, housing statistics, and migration patterns at national, state, and county levels.

42 datasets · 335 columns

population_summary · table

State-level population summary showing total, male, and female population by year. Aggregates data from acs_population table.

View — columns are resolved by the query engine at runtime.

income_summary · table

State-level income summary showing median household income and per capita income by year. Aggregates data from acs_income table.

View — columns are resolved by the query engine at runtime.

poverty_rate · table

State-level poverty rates calculated from poverty universe and below poverty level counts. Shows percentage of population below poverty level.

View — columns are resolved by the query engine at runtime.

education_attainment · table

State-level educational attainment showing population with high school diploma, bachelor's degree, master's degree, and doctorate. Includes percentages.

View — columns are resolved by the query engine at runtime.

unemployment_rate · table

State-level unemployment rates calculated from labor force and unemployed population. Shows labor force participation and unemployment percentages.

View — columns are resolved by the query engine at runtime.

acs_population · table

American Community Survey population demographics including total population, age, sex, race, and ethnicity. Provides population counts at state and county levels.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_population	long	yes	Total population
male_population	long	yes	Male population
female_population	long	yes	Female population

acs_income · table

Household and family income statistics from ACS including median household income and per capita income at state and county levels.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
median_household_income	long	yes	Median household income in the past 12 months
per_capita_income	long	yes	Per capita income in the past 12 months

acs_housing · table

Housing characteristics from ACS including total housing units, occupancy status, median home value, and median rent.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_housing_units	long	yes	Total housing units
occupied_units	long	yes	Occupied housing units
vacant_units	long	yes	Vacant housing units
median_home_value	long	yes	Median value of owner-occupied housing units
median_rent	long	yes	Median gross rent

acs_education · table

Educational attainment from ACS including high school graduation rates and bachelor's degree attainment for population 25 years and over.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
pop_25_plus	long	yes	Total population 25 years and over
hs_graduate	long	yes	Regular high school diploma (excludes GED/equivalency)
bachelors	long	yes	Bachelor's degree only (excludes higher degrees)
masters	long	yes	Master's degree
doctorate	long	yes	Doctorate degree

acs_employment · table

Employment status and labor force participation from ACS including employed, unemployed, and labor force participation rates.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
labor_force	long	yes	Civilian labor force (population 16 years and over)
employed	long	yes	Employed (civilian labor force)
unemployed	long	yes	Unemployed (civilian labor force)
not_in_labor_force	long	yes	Not in labor force

acs_poverty · table

Poverty statistics from ACS including population below poverty level and poverty rates by demographic groups.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
poverty_universe	long	yes	Population for whom poverty status is determined (excludes institutionalized, military, unrelated children under 15)
below_poverty	long	yes	Income below poverty level in past 12 months

decennial_population · table

Decennial Census population from 2000, 2010, and 2020. Unified schema across all years with columns normalized to canonical names regardless of year-specific API variable codes (P001001 vs P1_001N, etc.).

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_population	long	yes	Total population
white_alone	long	yes	Population identifying as White alone
black_alone	long	yes	Population identifying as Black or African American alone
asian_alone	long	yes	Population identifying as Asian alone

acs_race_ethnicity · table

Detailed race and Hispanic/Latino origin demographics from ACS including population counts by race categories and Hispanic origin status.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
white_alone	long	yes	White alone
black_alone	long	yes	Black or African American alone
american_indian_alone	long	yes	American Indian and Alaska Native alone
asian_alone	long	yes	Asian alone
pacific_islander_alone	long	yes	Native Hawaiian and Other Pacific Islander alone
other_race_alone	long	yes	Some other race alone
two_or_more_races	long	yes	Two or more races
hispanic_latino	long	yes	Hispanic or Latino origin (any race)
not_hispanic_latino	long	yes	Not Hispanic or Latino

acs_age · table

Age distribution from ACS including median age and population by age groups.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
median_age	double	yes	Median age
under_5_years	long	yes	Population under 5 years
age_5_to_17	long	yes	Population 5 to 17 years (school age)
age_18_to_64	long	yes	Working age population 18 to 64
age_65_and_over	long	yes	Senior population 65 years and over

acs_commuting · table

Commuting patterns from ACS including means of transportation to work, travel time, and work-from-home statistics.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_workers	long	yes	Total workers 16 years and over
drove_alone	long	yes	Workers who drove alone
carpooled	long	yes	Workers who carpooled
public_transit	long	yes	Workers using public transportation
walked	long	yes	Workers who walked to work
bicycle	long	yes	Workers who bicycled to work
worked_from_home	long	yes	Workers who worked from home
mean_travel_time	double	yes	Mean travel time to work (minutes)

acs_health_insurance · table

Health insurance coverage from ACS including coverage rates by age and type.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_population	long	yes	Total civilian noninstitutionalized population
with_health_insurance	long	yes	Population with health insurance coverage
no_health_insurance	long	yes	Population without health insurance coverage
public_coverage	long	yes	Population with public health insurance
private_coverage	long	yes	Population with private health insurance

acs_language · table

Language spoken at home from ACS including English proficiency.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
population_5_plus	long	yes	Population 5 years and over
english_only	long	yes	Speak only English at home
spanish	long	yes	Speak Spanish at home
spanish_limited_english	long	yes	Speak Spanish, limited English proficiency
other_indo_european	long	yes	Speak other Indo-European language
asian_pacific_languages	long	yes	Speak Asian and Pacific Island languages
other_languages	long	yes	Speak other languages

acs_disability · table

Disability status from ACS including types of disabilities.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_population	long	yes	Total civilian noninstitutionalized population
with_disability	long	yes	Population with a disability
hearing_difficulty	long	yes	Population with hearing difficulty
vision_difficulty	long	yes	Population with vision difficulty
cognitive_difficulty	long	yes	Population with cognitive difficulty
ambulatory_difficulty	long	yes	Population with ambulatory difficulty

acs_veterans · table

Veteran status from ACS including veteran population by period of service.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
civilian_population_18_plus	long	yes	Civilian population 18 years and over
veterans	long	yes	Veteran population
nonveterans	long	yes	Nonveteran population
male_veterans	long	yes	Male veterans
female_veterans	long	yes	Female veterans

acs_migration · table

Geographic mobility from ACS showing where people moved from in the past year.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
population_1_year_plus	long	yes	Population 1 year and over
same_house	long	yes	Same house 1 year ago
moved_within_county	long	yes	Moved within same county
moved_from_different_county_same_state	long	yes	Moved from different county, same state
moved_from_different_state	long	yes	Moved from different state
moved_from_abroad	long	yes	Moved from abroad

acs_occupation · table

Employment by occupation category from ACS.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_employed	long	yes	Total employed civilian population 16+
management_business_science_arts	long	yes	Management, business, science, and arts occupations
service_occupations	long	yes	Service occupations
sales_office	long	yes	Sales and office occupations
natural_resources_construction_maintenance	long	yes	Natural resources, construction, and maintenance occupations
production_transportation_moving	long	yes	Production, transportation, and material moving occupations

acs_industry · table

Employment by industry sector from ACS.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_employed	long	yes	Total employed civilian population 16+
agriculture_forestry_mining	long	yes	Agriculture, forestry, fishing, hunting, and mining
construction	long	yes	Construction
manufacturing	long	yes	Manufacturing
wholesale_trade	long	yes	Wholesale trade
retail_trade	long	yes	Retail trade
transportation_utilities	long	yes	Transportation and warehousing, and utilities
information	long	yes	Information
finance_insurance_real_estate	long	yes	Finance and insurance, and real estate
professional_scientific_management	long	yes	Professional, scientific, management, admin, and waste management
educational_healthcare_social	long	yes	Educational services, health care, and social assistance
arts_entertainment_recreation_food	long	yes	Arts, entertainment, recreation, accommodation, and food services
other_services	long	yes	Other services (except public administration)
public_administration	long	yes	Public administration

acs_internet · table

Internet and computer access from ACS showing digital connectivity.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_households	long	yes	Total households
with_internet	long	yes	Households with an internet subscription
with_broadband	long	yes	Households with broadband internet
no_internet	long	yes	Households without internet access
with_computer	long	yes	Households with a computer
no_computer	long	yes	Households without a computer

acs_nativity · table

Nativity and citizenship status from ACS including foreign-born population.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_population	long	yes	Total population
native_born	long	yes	Native born (US citizen at birth)
foreign_born	long	yes	Foreign born
naturalized_citizen	long	yes	Naturalized US citizen
not_a_citizen	long	yes	Not a US citizen

acs_marital_status · table

Marital status from ACS for population 15 years and over.

Column	Type	Null	Description
name	string	yes	Geographic area name from Census API
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
b12001_001e	string	yes	Population 15 years and over (total)
b12001_003e	string	yes	Male never married
b12001_004e	string	yes	Male now married (excluding separated)
b12001_006e	string	yes	Male separated
b12001_009e	string	yes	Male widowed
b12001_010e	string	yes	Male divorced
b12001_012e	string	yes	Female never married
b12001_013e	string	yes	Female now married (excluding separated)
b12001_015e	string	yes	Female separated
b12001_018e	string	yes	Female widowed
b12001_019e	string	yes	Female divorced

acs_household_type · table

Household type and family composition from ACS.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_households	long	yes	Total households
family_households	long	yes	Family households
married_couple_family	long	yes	Married-couple family
male_householder_no_spouse	long	yes	Male householder, no spouse present
female_householder_no_spouse	long	yes	Female householder, no spouse present
nonfamily_households	long	yes	Nonfamily households
living_alone	long	yes	Householder living alone
average_household_size	double	yes	Average household size

acs_housing_tenure · table

Housing tenure showing homeownership vs rental status from ACS.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
occupied_units	long	yes	Total occupied housing units
owner_occupied	long	yes	Owner-occupied units
renter_occupied	long	yes	Renter-occupied units
median_home_value	long	yes	Median value of owner-occupied units
median_gross_rent	long	yes	Median gross rent
median_year_built	long	yes	Median year structure built

acs_income_distribution · table

Household income distribution showing income brackets from ACS.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_households	long	yes	Total households
income_under_10k	long	yes	Households with income under $10,000
income_10k_to_25k	long	yes	Households with income $10,000 to $24,999
income_25k_to_50k	long	yes	Households with income $25,000 to $49,999
income_50k_to_100k	long	yes	Households with income $50,000 to $99,999
income_100k_to_200k	long	yes	Households with income $100,000 to $199,999
income_200k_plus	long	yes	Households with income $200,000 or more
gini_index	double	yes	Gini index of income inequality

decennial_housing · table

Decennial Census housing unit counts and occupancy from 2000, 2010, 2020.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
total_housing_units	long	yes	Total housing units
occupied_units	long	yes	Occupied housing units
vacant_units	long	yes	Vacant housing units

pep_population · table

Population Estimates Program (PEP) annual population estimates. Uses dimension resolver to handle API differences: - 2019 and earlier: pep/population endpoint with POP, DENSITY - 2020+: pep/charv endpoint with POP and YEAR filter

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
population	long	yes	Total population estimate
density	double	yes	Population density (only for 2019 vintage)

cbp_establishments · table

County Business Patterns provides annual data on business establishments, employment, and payroll by industry (NAICS) at state and county levels.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
naics_code	string	yes	2017 NAICS industry code
establishments	long	yes	Number of establishments
employees	long	yes	Number of employees (mid-March)
annual_payroll	long	yes	Annual payroll ($1,000)
first_quarter_payroll	long	yes	First quarter payroll ($1,000)

acs1_population · table

ACS 1-Year population estimates. More current than 5-year but only available for areas with 65,000+ population.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
total_population	long	yes	Total population
male_population	long	yes	Male population
female_population	long	yes	Female population
median_age	double	yes	Median age

acs1_income · table

ACS 1-Year income statistics for areas with 65,000+ population.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
median_household_income	long	yes	Median household income
per_capita_income	long	yes	Per capita income

economic_census · table

Economic Census provides comprehensive business statistics including establishments, employment, payroll, and sales by industry. Uses dimension resolver to handle NAICS version differences: - 2017: Uses NAICS2017 variable - 2022: Uses NAICS2022 variable Partitioned by year only (not geography) to reduce file count.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
naics_code	string	yes	NAICS industry code (version depends on census year)
establishments	long	yes	Number of establishments
employees	long	yes	Number of employees
payroll	long	yes	Annual payroll ($1,000)
sales	long	yes	Total sales/receipts ($1,000)

saipe_poverty · table

Small Area Income and Poverty Estimates (SAIPE) provides annual county-level estimates of income and poverty including median household income and poverty rates by age group.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
all_ages_poverty_count	long	yes	All ages in poverty count estimate
all_ages_poverty_rate	double	yes	All ages poverty rate estimate
child_poverty_count	long	yes	Ages 0-17 in poverty count estimate
child_poverty_rate	double	yes	Ages 0-17 poverty rate estimate
median_household_income	long	yes	Median household income estimate

sahie_insurance · table

Small Area Health Insurance Estimates (SAHIE) provides county-level estimates of health insurance coverage rates.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
insured_count	long	yes	Number insured estimate
uninsured_count	long	yes	Number uninsured estimate
insured_rate	double	yes	Percent insured estimate
uninsured_rate	double	yes	Percent uninsured estimate

bds_dynamics · table

Business Dynamics Statistics tracks job creation, destruction, firm births and deaths at state level by industry and firm characteristics.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
job_creation	long	yes	Number of jobs created
job_destruction	long	yes	Number of jobs destroyed
net_job_creation	long	yes	Net job creation (creation - destruction)
establishments	long	yes	Number of establishments
firms	long	yes	Number of firms
employees	long	yes	Number of employees

abs_characteristics · table

Annual Business Survey provides data on business owner characteristics including demographics, education, and veteran status.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
firms	long	yes	Number of employer firms
receipts	long	yes	Sales receipts ($1,000)
employees	long	yes	Number of employees
payroll	long	yes	Annual payroll ($1,000)

nonemployer_statistics · table

Nonemployer Statistics covers businesses with no paid employees, typically self-employed individuals operating unincorporated businesses. Partitioned by year only (not geography) to reduce file count.

Column	Type	Null	Description
geo_name	string	yes	Geographic area name
state	string	yes	State FIPS code (2 digits)
county	string	yes	County FIPS code (3 digits, within state)
county_fips	string	yes	5-digit county FIPS code (state + county) for joining to geo.counties
naics_code	string	yes	NAICS industry code (canonical header; source variable is the vintage-specific NAICS20xx, normalized by CensusResponseTransformer)
establishments	long	yes	Number of nonemployer establishments
receipts	long	yes	Total receipts ($1,000)

building_permits · table

Building Permits Survey tracks new privately-owned residential construction permits by state. Uses December cumulative (YTD) totals. Data from https://www2.census.gov/econ/bps/State/ URL format is stYYMMy.txt where YYMM is year-month code (e.g., 2212 = Dec 2022). Partition 'year' stores the YYMM code for URL compatibility; actual year derived from survey_date.

Column	Type	Null	Description
column0	string	yes	Survey date in YYYYMM format
column1	string	yes	State FIPS code (2-digit)
column4	string	yes	State name
column6	string	yes	Single-family housing units authorized
column7	string	yes	Value of single-family permits ($1000)
column9	string	yes	Duplex housing units authorized
column10	string	yes	Value of duplex permits ($1000)
column12	string	yes	3-4 unit housing units authorized
column13	string	yes	Value of 3-4 unit permits ($1000)
column15	string	yes	5+ unit housing units authorized
column16	string	yes	Value of 5+ unit permits ($1000)

qwi_employment · table

Quarterly Workforce Indicators tracks employment, earnings, job creation, and worker turnover by demographics (age, sex) and industry. Note: QWI API doesn't support wildcard states - must iterate per state. Partitioned by time (YYYY-QN format) to reduce file count vs per-state.

Column	Type	Null	Description
state	string	yes	State FIPS code (2 digits)
quarter	string	yes	Quarter in YYYY-QN format
employment	long	yes	Beginning-of-quarter employment
stable_employment	long	yes	Stable employment (employed full quarter)
hires	long	yes	All hires
separations	long	yes	All separations
earnings	long	yes	Average monthly earnings of stable workers

lodes_workplace · table

LEHD Origin-Destination Employment Statistics (LODES) Workplace Area Characteristics (WAC). Downloaded from lehd.ces.census.gov/data/lodes/.

Column	Type	Null	Description
w_geocode	string	yes	Workplace census block code (15 digits)
c000	string	yes	Total number of jobs
ca01	string	yes	Jobs for workers age 29 or younger
ca02	string	yes	Jobs for workers age 30 to 54
ca03	string	yes	Jobs for workers age 55 or older
ce01	string	yes	Jobs with monthly earnings $1,250 or less
ce02	string	yes	Jobs with monthly earnings $1,251 to $3,333
ce03	string	yes	Jobs with monthly earnings $3,333 or more