U.S. County Profiles and Geographic Identifiers Database v.1.0.0
3,222 Database Records
The U.S. County Profiles and Geographic Identifiers Database brings current Census county geography and selected ACS community measures into one practical, well-documented release. Each row represents one county or county-equivalent across the 50 states, District of Columbia, and Puerto Rico, including parishes, boroughs, census areas, independent cities, municipios, and other official forms. Fixed-width FIPS and GEOID values are paired with state and region context, land and water area, representative coordinates, population, households, median household income, median age, margins of error, and a reproducible density calculation.
Table Schema Database Field Statistics
| Field | Type | Required | Description |
|---|---|---|---|
| state_fips | string | Yes | Two-character Census state FIPS code. |
| county_fips | string | Yes | Three-character Census county FIPS code. |
| geoid | string | Yes | Five-character state-plus-county Census GEOID. |
| county_name | string | Yes | Official 2025 Census county or county-equivalent name. |
| legal_statistical_area_description | string | Yes | County-equivalent form derived from the official Census name, such as county, parish, borough, census area, independent city, municipio, or district. |
| state_name | string | Yes | Official state, district, or territory name. |
| state_code | string | Yes | Two-character USPS abbreviation. |
| region_code | string | No | Census region code; null for Puerto Rico. |
| division_code | string | No | Census division code; null for Puerto Rico. |
| land_area_sq_miles | number | Yes | Land area converted from unrounded 2025 Gazetteer square meters. |
| water_area_sq_miles | number | Yes | Water area converted from unrounded 2025 Gazetteer square meters. |
| latitude | number | Yes | 2025 Census representative internal-point latitude. |
| longitude | number | Yes | 2025 Census representative internal-point longitude. |
| population_estimate | integer | Yes | 2020-2024 ACS 5-year total population estimate. |
| population_margin_of_error | integer | No | ACS 90 percent margin of error for population. |
| households | integer | Yes | 2020-2024 ACS 5-year household estimate. |
| households_margin_of_error | integer | Yes | ACS 90 percent margin of error for households. |
| median_household_income | integer | No | 2020-2024 ACS 5-year median household income in dollars. |
| median_household_income_margin_of_error | integer | No | ACS 90 percent margin of error for median household income. |
| median_age | number | Yes | 2020-2024 ACS 5-year median age in years. |
| median_age_margin_of_error | number | Yes | ACS 90 percent margin of error for median age. |
| population_density_sq_mile | number | Yes | Population estimate divided by land area converted from unrounded square meters. |
| geography_vintage | string | Yes | Geographic source vintage. |
| demographic_vintage | string | Yes | Demographic estimate period. |
| data_vintage | string | Yes | Combined release-vintage statement. |
Release at a glance
What is inside this database
Validated release statistics.
state_fipsTwo-character Census state FIPS code.
- Distinct
- 52
- Missing
- 0.0%
county_fipsThree-character Census county FIPS code.
- Distinct
- 330
- Missing
- 0.0%
geoidFive-character state-plus-county Census GEOID.
- Distinct
- 3,222
- Missing
- 0.0%
county_nameOfficial 2025 Census county or county-equivalent name.
- Distinct
- 1,960
- Missing
- 0.0%
legal_statistical_area_descriptionCounty-equivalent form derived from the official Census name, such as county, parish, borough, census area, independent city, municipio, or district.
- Distinct
- 10
- Missing
- 0.0%
state_nameOfficial state, district, or territory name.
- Distinct
- 52
- Missing
- 0.0%
state_codeTwo-character USPS abbreviation.
- Distinct
- 52
- Missing
- 0.0%
region_codeCensus region code; null for Puerto Rico.
- Distinct
- 4
- Missing
- 0.0%
division_codeCensus division code; null for Puerto Rico.
- Distinct
- 9
- Missing
- 0.0%
land_area_sq_milesLand area converted from unrounded 2025 Gazetteer square meters.
- Distinct
- 3,222
- Missing
- 0.0%
water_area_sq_milesWater area converted from unrounded 2025 Gazetteer square meters.
- Distinct
- 3,222
- Missing
- 0.0%
latitude2025 Census representative internal-point latitude.
- Distinct
- 3,221
- Missing
- 0.0%
longitude2025 Census representative internal-point longitude.
- Distinct
- 3,222
- Missing
- 0.0%
population_estimate2020-2024 ACS 5-year total population estimate.
- Distinct
- 3,162
- Missing
- 0.0%
population_margin_of_errorACS 90 percent margin of error for population.
- Distinct
- 64
- Missing
- 0.0%
households2020-2024 ACS 5-year household estimate.
- Distinct
- 3,069
- Missing
- 0.0%
households_margin_of_errorACS 90 percent margin of error for households.
- Distinct
- 937
- Missing
- 0.0%
median_household_income2020-2024 ACS 5-year median household income in dollars.
- Distinct
- 3,098
- Missing
- 0.0%
median_household_income_margin_of_errorACS 90 percent margin of error for median household income.
- Distinct
- 2,720
- Missing
- 0.0%
median_age2020-2024 ACS 5-year median age in years.
- Distinct
- 313
- Missing
- 0.0%
median_age_margin_of_errorACS 90 percent margin of error for median age.
- Distinct
- 102
- Missing
- 0.0%
population_density_sq_milePopulation estimate divided by land area converted from unrounded square meters.
- Distinct
- 3,222
- Missing
- 0.0%
geography_vintageGeographic source vintage.
- Distinct
- 1
- Missing
- 0.0%
demographic_vintageDemographic estimate period.
- Distinct
- 1
- Missing
- 0.0%
data_vintageCombined release-vintage statement.
- Distinct
- 1
- Missing
- 0.0%
Records Information
Each of the 3,222 records represents one county or county-equivalent in the 2025 Census Gazetteer. The release includes the 50 states, District of Columbia, and Puerto Rico. Island Areas are outside the current Gazetteer scope. Geography and ACS estimates retain separate vintage labels. Special ACS values are null, margins of error are included, and identifiers remain fixed-width text. County seat is omitted because no complete current authoritative national source passed the release gate.
This is NOT an email marketing list
RECENT DATA UPDATES
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needs