public geospatial dataset county level csv

Here are some public geospatial datasets at county level that are commonly available as CSV and/or easy to join to county boundaries:

1. US Census Bureau – TIGER/Line + ACS

• What it has: County boundaries, demographics, housing, income, commuting, etc.
• Format: Shapefiles/GeoJSON for boundaries; many tables available as CSV from ACS.
• Best for: Joining county attributes to county polygons.
• Link: https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html
• ACS tables: https://data.census.gov/

2. CDC PLACES

• What it has: County-level health indicators, chronic disease estimates, risk factors.
• Format: CSV
• Best for: Public health spatial analysis at county level.
• Link: https://www.cdc.gov/places/

3. USDA ERS County Typology / Rural-Urban Continuum

• What it has: County classification, rurality, farm dependency, etc.
• Format: CSV or downloadable tables
• Best for: Rural-urban geospatial classification.
• Link: https://www.ers.usda.gov/data-products/county-typology-codes/

4. EPA Environmental Justice Screening and Mapping Tool (EJScreen)

• What it has: County and census tract environmental indicators.
• Format: CSV downloads available
• Best for: Environmental exposure and justice analysis.
• Link: https://www.epa.gov/ejscreen

5. NOAA Climate data by county

• What it has: County-level climate normals, hazards, weather summaries.
• Format: CSV in some products / downloadable tables
• Best for: Environmental/geospatial studies.
• Link: https://www.ncei.noaa.gov/

6. NASS / USDA County Data

• What it has: Agricultural statistics by county.
• Format: CSV
• Best for: Crop, livestock, farm economics analyses.
• Link: https://www.nass.usda.gov/Quick_Stats/

7. FCC Broadband Map / county summaries

• What it has: Broadband access metrics by geography.
• Format: CSV and downloadable data
• Best for: Infrastructure and digital divide analysis.
• Link: https://broadbandmap.fcc.gov/

8. County Health Rankings

• What it has: Health outcomes and determinants by county.
• Format: CSV download
• Best for: County-level health and social determinants.
• Link: https://www.countyhealthrankings.org/explore-health-rankings/rankings-data-documentation

---

If you want a true “geospatial CSV”

Often you’ll need a county identifier like:

• FIPS code
• County name + state
• ANSI code

Then you can join the CSV to county boundary files (e.g., Census TIGER/Line).

If you want, I can also give you:

1. a single downloadable county-level CSV dataset,
2. a list focused on environmental/geography data, or
3. a Python example to join county CSV data to a county shapefile.