U.S. County Data
Every U.S. county and county-equivalent in one documented CSV of 3,144 rows: GEOID, name, county seat, population, income, unemployment, area, and adjacency. It is built from official federal data and Wikidata, with the county seats Wikidata lacks taken from the pages cited in the seat file, so you can use it freely.
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 (Wikidata P36, queried 2026-11-11, or the page in county_seat_source where Wikidata has none); blank where the county-equivalent has no seat |
county_seat_source | Where the seat comes from: “Wikidata P36 (CC0)”, or the address of the page it was checked on; /data/county-seat-overrides.json lists each one with its publisher and a quote |
county_seat_note | Why a county-equivalent has no seat (an independent city, a census area, a planning region …), or a note on the seat |
population | Population, Census PEP Vintage 2025 (July 1, 2025) |
median_household_income | Median household income, Census SAIPE 2024; blank if suppressed (CV ≥ 0.30) |
poverty_rate | Poverty rate (%), Census SAIPE 2024; blank if suppressed |
unemployment_rate | Unemployment rate (%), BLS LAUS, not seasonally adjusted, for the month in unemployment_month; blank if not published |
unemployment_month | Reference month for the unemployment rate |
unemployment_preliminary | “true” while BLS marks that month preliminary, so the rate may still be revised; “false” once it is final; blank where there is no rate |
land_sq_mi | Land area in square miles, calculated from TIGER AREALAND (m² ÷ 2,589,988.11), January 1, 2026 vintage |
water_sq_mi | Water area in square miles, calculated from TIGER AREAWATER, January 1, 2026 vintage |
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) |
Preliminary unemployment. BLS marks the newest month of county unemployment rates preliminary, and a preliminary rate may change when BLS revises it. While unemployment_preliminary is true, unemployment_rate is BLS’s preliminary estimate for the month in unemployment_month; it is false for a month BLS has finalized. This file’s month, September 2026, is preliminary, and the site marks those figures “preliminary” beside the month.
Sources & license
- Source: U.S. Census Bureau, TIGERweb county boundaries, January 1, 2026 vintage — retrieved Nov 2026
- Source: U.S. Census Bureau, Population Estimates, Vintage 2025 (July 1, 2025) — retrieved Nov 2026
- Source: U.S. Census Bureau, Small Area Income and Poverty Estimates (SAIPE), 2024 — retrieved Nov 2026
- Source: U.S. Bureau of Labor Statistics, Local Area Unemployment Statistics (LAUS), September 2026, preliminary — retrieved Nov 2026
- Source: Wikidata, county seats (P36), query of 2026-11-11 — retrieved Nov 2026
- Source: County, state and Census sources, seats and no-seat reasons for 92 county-equivalents (3 rows cite the Virginia Association of Counties) — retrieved Nov 2026
- Calculated: square miles = TIGER AREALAND or AREAWATER (m²) ÷ 2,589,988.11, rounded to 2 dp (method)
- Calculated: neighbors and border length = counties sharing a boundary arc are neighbors; border length = shared arc length after clipping coastal and Great Lakes water (method)
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. The methodology covers 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.
- 2026-11: refreshed to population Census PEP V2025, income & poverty Census SAIPE 2024, boundaries and land area Census TIGER 2026 (January 1, 2026 vintage); unemployment BLS LAUS September 2026, preliminary (from the BLS county workbook; see methodology); county seats re-queried 2026-11-11.
- v1 (2026): initial release with population (PEP), income & poverty (SAIPE), unemployment (BLS LAUS), boundaries (TIGER, Connecticut planning-region basis) and county seats (Wikidata).