US State Capitals List v.2.0.0
50 Database Records
The US State Capitals Database provides one carefully sourced record for each of the 50 states. Every row pairs the state and capital with official USPS, Census FIPS, GNIS, and place GEOID identifiers; 2025 Census representative internal-point coordinates and land/water area; a same-vintage county-equivalent association; ratification or admission date and order; and a direct government source with archived hash evidence. Washington, DC is documented separately as the federal capital and is not misrepresented as a state record.
Table Schema Database Field Statistics
Release structure
US State Capitals List
Review the published tables, record coverage, and field names included with release 2.0.0.
- Database
- #737
- Version
- 2.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| state_name | string | Yes | Official state name. |
| state_usps | string | Yes | Official two-letter USPS state abbreviation. |
| state_fips | string | Yes | Two-digit Census state ANSI/FIPS code stored as text. |
| state_gnis_id | string | Yes | State-level GNIS identifier published by Census. |
| capital_city | string | Yes | Common display name of the state capital. |
| census_place_name | string | Yes | Matched Census 2025 place geography name. |
| place_fips | string | Yes | Five-digit place FIPS code stored as text. |
| place_geoid | string | Yes | Seven-digit state-plus-place GEOID stored as text. |
| place_lsad | string | Yes | Census legal/statistical area description code. |
| latitude | number | Yes | Census 2025 representative internal-point latitude. |
| longitude | number | Yes | Census 2025 representative internal-point longitude. |
| coordinate_type | string | Yes | Coordinate meaning; never a capitol-building location. |
| coordinate_vintage | string | Yes | Census Gazetteer vintage. |
| land_area_sq_mi | number | Yes | Census 2025 place land area in square miles. |
| water_area_sq_mi | number | Yes | Census 2025 place water area in square miles. |
| county_equivalent_name | string | Yes | County-equivalent containing the documented representative point. |
| county_equivalent_fips | string | Yes | Five-digit county-equivalent GEOID stored as text. |
| county_equivalent_type | string | Yes | County-equivalent legal/statistical type. |
| county_assignment_method | string | Yes | Method and vintage for the singular county-equivalent association. |
| union_event_type | string | Yes | Constitution ratification for original states or admission for later states. |
| union_event_date | string | Yes | ISO date of ratification or admission/statehood. |
| union_order | integer | Yes | Order of ratification/admission from 1 through 50. |
| capital_status | string | Yes | Scope label distinguishing a state capital from the federal capital. |
| capital_source_url | string | Yes | Row-level U.S. Census government guide naming the capital and statehood context. |
| capital_source_sha256 | string | Yes | Hash of the archived row-level Census guide PDF. |
| source_note | string | Yes | Scope and methodology note. |
Release at a glance
What is inside this database
Review verified record totals, geographic coverage, classifications, and field completeness for US State Capitals List.
state_nameOfficial state name.
- Distinct
- 50
- Missing
- 0.0%
state_uspsOfficial two-letter USPS state abbreviation.
- Distinct
- 50
- Missing
- 0.0%
state_fipsTwo-digit Census state ANSI/FIPS code stored as text.
- Distinct
- 50
- Missing
- 0.0%
state_gnis_idState-level GNIS identifier published by Census.
- Distinct
- 50
- Missing
- 0.0%
capital_cityCommon display name of the state capital.
- Distinct
- 50
- Missing
- 0.0%
census_place_nameMatched Census 2025 place geography name.
- Distinct
- 50
- Missing
- 0.0%
place_fipsFive-digit place FIPS code stored as text.
- Distinct
- 44
- Missing
- 0.0%
place_geoidSeven-digit state-plus-place GEOID stored as text.
- Distinct
- 50
- Missing
- 0.0%
place_lsadCensus legal/statistical area description code.
- Distinct
- 4
- Missing
- 0.0%
latitudeCensus 2025 representative internal-point latitude.
- Distinct
- 50
- Missing
- 0.0%
longitudeCensus 2025 representative internal-point longitude.
- Distinct
- 50
- Missing
- 0.0%
coordinate_typeCoordinate meaning; never a capitol-building location.
- Distinct
- 1
- Missing
- 0.0%
coordinate_vintageCensus Gazetteer vintage.
- Distinct
- 1
- Missing
- 0.0%
land_area_sq_miCensus 2025 place land area in square miles.
- Distinct
- 50
- Missing
- 0.0%
water_area_sq_miCensus 2025 place water area in square miles.
- Distinct
- 50
- Missing
- 0.0%
county_equivalent_nameCounty-equivalent containing the documented representative point.
- Distinct
- 48
- Missing
- 0.0%
county_equivalent_fipsFive-digit county-equivalent GEOID stored as text.
- Distinct
- 50
- Missing
- 0.0%
county_equivalent_typeCounty-equivalent legal/statistical type.
- Distinct
- 6
- Missing
- 0.0%
county_assignment_methodMethod and vintage for the singular county-equivalent association.
- Distinct
- 1
- Missing
- 0.0%
union_event_typeConstitution ratification for original states or admission for later states.
- Distinct
- 2
- Missing
- 0.0%
union_event_dateISO date of ratification or admission/statehood.
- Distinct
- 49
- Missing
- 0.0%
union_orderOrder of ratification/admission from 1 through 50.
- Distinct
- 50
- Missing
- 0.0%
capital_statusScope label distinguishing a state capital from the federal capital.
- Distinct
- 1
- Missing
- 0.0%
capital_source_urlRow-level U.S. Census government guide naming the capital and statehood context.
- Distinct
- 50
- Missing
- 0.0%
capital_source_sha256Hash of the archived row-level Census guide PDF.
- Distinct
- 50
- Missing
- 0.0%
source_noteScope and methodology note.
- Distinct
- 1
- Missing
- 0.0%
Unique
- State Name50
- State Usps50
- State Fips50
- Capital City50
- Place Geoid50
- Union Order50
Union Event
- Admission36
- Constitution Ratification14
Records Information
Each record represents one U.S. state and its current capital. The scope is exactly 50 rows: no District of Columbia and no territories. Capital names are reconciled to 2025 Census place geographies. Coordinates are representative internal points, not capitol-building locations. County-equivalent values follow the current 2025 geography, including Connecticut planning regions and independent-city forms.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
Need a closer fit?
Data shaped around your project.
Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.RECENT DATA UPDATES
Public School Districts Database
19,439 Districts and education agencies
v. 2.0.0
Updated 2 weeks ago
v. 2.0.0
Updated 2 weeks ago
Computer Networking Services Database
48,446 IT and networking locations
v. 2.0.0
Updated 2 weeks ago
v. 2.0.0
Updated 2 weeks ago
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