U.S. County Data
Every U.S. county and county-equivalent — 3,144 rows — as a single documented CSV: GEOID, name, county seat, population, income, unemployment, area, and adjacency. Built from official federal and Wikidata sources only, so it’s freely usable.
Columns
| Column | Description |
|---|---|
geoid | 5-digit county FIPS/GEOID (state + county code) |
name | County or county-equivalent name (e.g. "Franklin County") |
state | State or district name |
state_fips | 2-digit state FIPS code |
noun | What the equivalent is called — County, Parish, Borough, City and Borough, Census Area, Municipality, Planning Region, city (independent), or county-equivalent |
county_seat | County seat / administrative center (Wikidata P36); blank where none exists or is unmapped |
population | Population, Census PEP Vintage 2023 (July 1, 2023) |
median_household_income | Median household income, Census SAIPE 2023; blank if suppressed (CV ≥ 0.30) |
poverty_rate | Poverty rate (%), Census SAIPE 2023; blank if suppressed |
unemployment_rate | Unemployment rate (%), BLS LAUS; blank if suppressed |
unemployment_month | Reference month for the unemployment rate |
land_sq_mi | Land area in square miles (TIGER) |
water_sq_mi | Water area in square miles (TIGER) |
neighbors | Semicolon-separated GEOIDs of counties sharing a boundary in the national map topology (includes cross-state; a few island or fully enclosed counties may list none) |
Sources & license
Census TIGER (boundaries), PEP Vintage 2023 (population), SAIPE 2023 (income & poverty), BLS LAUS (unemployment), Wikidata P36 (county seats). Federal + Wikidata only — no proprietary sources.
Federal statistics are public domain; Wikidata is CC0. The dataset carries no proprietary or license-restricted data, so you may use, redistribute, and build on it freely. Suppressed estimates (coefficient of variation ≥ 0.30) are left blank rather than guessed — see the methodology for the full sourcing, vintages, and the suppression rule.
Versions
This dataset is versioned and refreshed as its sources publish new vintages. Changes will be logged here so you can pin to a known version.
- v1 — 2026: initial release. Population PEP 2023; income & poverty SAIPE 2023; unemployment BLS LAUS; boundaries TIGER (current, Connecticut planning-region basis); county seats Wikidata.