US Census ACS 5-Year State Profiles

Wide-format state-level profiles from the US Census Bureau American Community Survey (ACS) 5-Year estimates. One row per state per year covering demographics (population, age, sex, race/ethnicity), economics (income, employment, poverty, health insurance), housing (home values, rents, homeownership), and social characteristics (education, disability, veterans, foreign born). Covers all 50 states and DC, 2009–2023.

demographics country/usa demographics/country/usa/acs5-state-profiles census acs acs5 demographics income housing education usa state annual key-metrics

Catalog

Browse and search all available datasets.

Dataset API

Endpoints for this dataset — schema, filter values, preview, and querying.

Purchase

Add balance or buy access to start querying.

Source

Name
US Census Bureau — American Community Survey
URL
https://www.census.gov/programs-surveys/acs
License
Public Domain

Size and Format

Rows
832
Columns
32
Size (bytes)
82,330
Formats
parquet, csv

Pricing

Per query (USD)
0.0100 USD
Max rows per query
1000
Free
No
Free sample
Yes

Temporal Coverage

end
2024
start
2009
frequency
annual

Geographic Coverage

level
state
coding
GEOID
region
United States (50 states + DC)

Query Filters

Columns you can use as query params in GET /api/datasets/acs5-state-profiles/query.

Schema (Columns)

Column Type Description Filterable
geo_id string Standard Census GEOID — 2-digit state FIPS code (e.g. '06' for California) Yes
geo_name string State name (e.g. 'California') Yes
geo_level string No
state_fips string No
year integer ACS 5-Year survey ending year (2009–2023) Yes
population integer Total resident population (DP05_0001E) No
median_age float Median age of the population (DP05_0018E) No
pct_female float Percentage of population identifying as female (DP05_0002PE) No
pct_white float Percentage identifying as White alone (DP05_0037PE) No
pct_black float Percentage identifying as Black or African American alone (DP05_0038PE) No
pct_asian float Percentage identifying as Asian alone (DP05_0044PE) No
pct_hispanic float Percentage identifying as Hispanic or Latino of any race (DP05_0071PE) No
pct_two_or_more float Percentage identifying as two or more races (DP05_0035PE) No
labor_force_participation_rate float Percentage of civilian population 16+ in the labor force (DP03_0004PE) No
unemployment_rate float Unemployment rate — civilians 16+ (DP03_0009PE) No
median_household_income integer Median household income in the past 12 months (inflation-adjusted dollars) (DP03_0062E) No
per_capita_income integer Per capita income in the past 12 months (inflation-adjusted dollars) (DP03_0088E) No
poverty_rate float Percentage of population with income below the federal poverty level (DP03_0119PE) No
pct_health_insurance float Percentage of civilian noninstitutionalized population with health insurance (DP03_0096PE) No
pct_public_health_insurance float Percentage with public health insurance coverage (DP03_0098PE) No
pct_commute_car float Percentage of workers 16+ commuting by car, truck, or van (DP03_0019PE) No
housing_units integer Total housing units (DP04_0001E) No
homeownership_rate float Percentage of occupied housing units that are owner-occupied (DP04_0046PE) No
median_home_value integer Median value of owner-occupied housing units (dollars) (DP04_0089E) No
median_gross_rent integer Median gross rent for renter-occupied units (dollars/month) (DP04_0134E) No
pct_housing_cost_burdened float Percentage of renter-occupied units where gross rent is 35%+ of household income (DP04_0141PE) No
pct_hs_or_higher float Percentage of population 25+ with a high school diploma or higher (DP02_0067PE) No
pct_bachelors_or_higher float Percentage of population 25+ with a bachelor's degree or higher (DP02_0068PE) No
pct_foreign_born float Percentage of population that is foreign born (DP02_0094PE) No
pct_speaks_only_english float Percentage of population 5+ that speaks only English at home (DP02_0113PE) No
pct_with_disability float Percentage of civilian noninstitutionalized population with any disability (DP02_0072PE) No
pct_veterans float Percentage of civilian population 18+ that are veterans (DP02_0070PE) No

← Back to catalog