{"slug":"acs5-county-profiles","name":"US Census ACS 5-Year County Profiles","domain":"demographics","scope":"country","geo":"usa","path":"demographics/country/usa/acs5-county-profiles","description":"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.","tags":["census","acs","acs5","demographics","income","housing","education","usa","county","annual","key-metrics"],"formats":["parquet","csv"],"size":{"rows":51533,"cols":32,"bytes":2419391},"pricing":{"per_query_usd":0.01,"max_rows_per_query":1000,"free":false,"sample_free":true},"temporal_coverage":{"end":"2024","start":"2009","frequency":"annual"},"geographic_coverage":{"level":"county","coding":"GEOID","region":"United States (~3,220 counties)"},"query_filters":["geo_id","geo_name","year"],"urls":{"detail":"/api/datasets/acs5-county-profiles","sample":"/api/datasets/acs5-county-profiles/sample","query":"/api/datasets/acs5-county-profiles/query","checkout":"/api/checkout/x402"},"schema":[{"name":"geo_id","type":"string","filterable":true,"description":"Standard Census GEOID — 5-digit county FIPS code (2-digit state + 3-digit county, e.g. '06001' for Alameda County, CA)","members_url":"/api/datasets/acs5-county-profiles/members/geo_id"},{"name":"geo_name","type":"string","filterable":true,"description":"County name including state (e.g. 'Alameda County, California')","members_url":"/api/datasets/acs5-county-profiles/members/geo_name"},{"name":"geo_level","type":"string","filterable":false,"description":""},{"name":"state_fips","type":"string","filterable":false,"description":""},{"name":"year","type":"integer","filterable":true,"description":"ACS 5-Year survey ending year (2009–2023)","members_url":"/api/datasets/acs5-county-profiles/members/year"},{"name":"population","type":"integer","filterable":false,"description":"Total resident population (DP05_0001E)"},{"name":"median_age","type":"float","filterable":false,"description":"Median age of the population (DP05_0018E)"},{"name":"pct_female","type":"float","filterable":false,"description":"Percentage of population identifying as female (DP05_0002PE)"},{"name":"pct_white","type":"float","filterable":false,"description":"Percentage identifying as White alone (DP05_0037PE)"},{"name":"pct_black","type":"float","filterable":false,"description":"Percentage identifying as Black or African American alone (DP05_0038PE)"},{"name":"pct_asian","type":"float","filterable":false,"description":"Percentage identifying as Asian alone (DP05_0044PE)"},{"name":"pct_hispanic","type":"float","filterable":false,"description":"Percentage identifying as Hispanic or Latino of any race (DP05_0071PE)"},{"name":"pct_two_or_more","type":"float","filterable":false,"description":"Percentage identifying as two or more races (DP05_0035PE)"},{"name":"labor_force_participation_rate","type":"float","filterable":false,"description":"Percentage of civilian population 16+ in the labor force (DP03_0004PE)"},{"name":"unemployment_rate","type":"float","filterable":false,"description":"Unemployment rate — civilians 16+ (DP03_0009PE)"},{"name":"median_household_income","type":"integer","filterable":false,"description":"Median household income in the past 12 months (inflation-adjusted dollars) (DP03_0062E)"},{"name":"per_capita_income","type":"integer","filterable":false,"description":"Per capita income in the past 12 months (inflation-adjusted dollars) (DP03_0088E)"},{"name":"poverty_rate","type":"float","filterable":false,"description":"Percentage of population with income below the federal poverty level (DP03_0119PE)"},{"name":"pct_health_insurance","type":"float","filterable":false,"description":"Percentage of civilian noninstitutionalized population with health insurance (DP03_0096PE)"},{"name":"pct_public_health_insurance","type":"float","filterable":false,"description":"Percentage with public health insurance coverage (DP03_0098PE)"},{"name":"pct_commute_car","type":"float","filterable":false,"description":"Percentage of workers 16+ commuting by car, truck, or van (DP03_0019PE)"},{"name":"housing_units","type":"integer","filterable":false,"description":"Total housing units (DP04_0001E)"},{"name":"homeownership_rate","type":"float","filterable":false,"description":"Percentage of occupied housing units that are owner-occupied (DP04_0046PE)"},{"name":"median_home_value","type":"integer","filterable":false,"description":"Median value of owner-occupied housing units (dollars) (DP04_0089E)"},{"name":"median_gross_rent","type":"integer","filterable":false,"description":"Median gross rent for renter-occupied units (dollars/month) (DP04_0134E)"},{"name":"pct_housing_cost_burdened","type":"float","filterable":false,"description":"Percentage of renter-occupied units where gross rent is 35%+ of household income (DP04_0141PE)"},{"name":"pct_hs_or_higher","type":"float","filterable":false,"description":"Percentage of population 25+ with a high school diploma or higher (DP02_0067PE)"},{"name":"pct_bachelors_or_higher","type":"float","filterable":false,"description":"Percentage of population 25+ with a bachelor's degree or higher (DP02_0068PE)"},{"name":"pct_foreign_born","type":"float","filterable":false,"description":"Percentage of population that is foreign born (DP02_0094PE)"},{"name":"pct_speaks_only_english","type":"float","filterable":false,"description":"Percentage of population 5+ that speaks only English at home (DP02_0113PE)"},{"name":"pct_with_disability","type":"float","filterable":false,"description":"Percentage of civilian noninstitutionalized population with any disability (DP02_0072PE)"},{"name":"pct_veterans","type":"float","filterable":false,"description":"Percentage of civilian population 18+ that are veterans (DP02_0070PE)"}],"source":{"url":"https://www.census.gov/programs-surveys/acs","name":"US Census Bureau — American Community Survey","license":"Public Domain"}}