US Census ACS 5-Year County Profiles
Wide-format county-level profiles from the US Census Bureau American Community Survey (ACS) 5-Year estimates. One row per county 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 ~3,220 US counties, 2009–2023.
demographics
Catalog
Browse and search all available datasets.
- Catalog — browse all datasets
- GET /api/catalog — catalog in JSON
- GET /api/catalog?q=… — search the catalog
Dataset API
Endpoints for this dataset — schema, filter values, preview, and querying.
- GET /api/datasets/acs5-county-profiles — schema, filters, and pricing
- GET /api/datasets/acs5-county-profiles/sample — free sample (100 rows)
- GET /api/datasets/acs5-county-profiles/members/{col} — valid values for a filterable column
- GET /api/datasets/acs5-county-profiles/query — query with filters (API key required)
Purchase
Add balance or buy access to start querying.
- POST /api/checkout/x402 — agents: add balance via x402 (USDC)
- Sign in at /account — humans: add balance via Stripe (card, Apple Pay, bank transfer)
- POST /api/ap2/intent → /api/ap2/purchase — agents: AP2 mandate-based payment
Source
Size and Format
Pricing
Temporal Coverage
Geographic Coverage
Query Filters
Columns you can use as query params in GET /api/datasets/acs5-county-profiles/query.
-
geo_idMembers (JSON) -
geo_nameMembers (JSON) -
yearMembers (JSON)
Schema (Columns)
| Column | Type | Description | Filterable |
|---|---|---|---|
geo_id |
string | Standard Census GEOID — 5-digit county FIPS code (2-digit state + 3-digit county, e.g. '06001' for Alameda County, CA) | Yes |
geo_name |
string | County name including state (e.g. 'Alameda County, 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 |