U.S. City-State Master Database

The U.S. City-State Master Database organizes 48,496 unique city and state combinations supported by current Census places and county subdivisions, plus official APO, FPO, and DPO military p...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated September 4, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
CoreUnique city/state combinations, jurisdiction labels, and current coverage flags.
$20.00
CompleteGeography plus state reference data, SQLite, schemas, samples, statistics, and documentation.
$100.00
U.S. City-State Master Database List

U.S. City-State Master Database v.2.0.0

48,496 Database Records

U.S. City-State Master Database catalog icon U.S. City-State Master Database Download

License Database Purchase Options

Pick the right license CORE
USAGE LICENSE
$20.00
 GEOGRAPHY
PUBLICATION LICENSE
$50.00
 COMPLETE
MASTER LICENSE
$100.00
Data Tracking Seeds
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Distribution
Copyright Endorsement
  BUY NOW BUY NOW BUY NOW
The U.S. City-State Master Database organizes 48,496 unique city and state combinations supported by current Census places and county subdivisions, plus official APO, FPO, and DPO military postal combinations. Core supplies clean city names, postal abbreviations, jurisdiction labels, and coverage flags. Higher tiers add supporting geography types, stable identifiers, area measures, representative coordinates, state reference data, indexed SQLite, schemas, samples, statistics, and documentation. Matching UTF-8 CSV and JSON files make the release useful for validation, directories, publishing, lookup tools, geographic analysis, and application development.
48,496 Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Lyrics Baby Names Postal Records Historical Events Postal Records

Table Schema Database Field Statistics

Release structure

U.S. City-State Master Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#40
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
city_state_combinations48496combination_id, city_name, state_abbreviation, state_name, jurisdiction_type, entity_count, has_census_place, has_county_subdivision, is_military_postal
geographic_entities68786entity_id, combination_id, source_geography, geoid, geoidfq, ansi_code, official_name, lsad_code, functional_status, land_area_sqmi, water_area_sqmi, internal_point_latitude, internal_point_longitude
state_reference52state_abbreviation, state_name, state_geoid, land_area_sqmi, water_area_sqmi, internal_point_latitude, internal_point_longitude

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for U.S. City-State Master Database.

48,496City State Combinations
68,786Geographic Entities
52State Reference

Geographic coverage

This release represents 55 state or territory codes. The 12 largest totals are shown below.

  • PA2,758
  • IL2,474
  • MN2,305
  • TX2,115
  • NY1,856
  • CA1,747
  • MO1,736
  • OH1,676
  • ND1,589
  • MI1,564
  • IA1,547
  • NC1,456

Source Geography

  • County Subdivision36,427
  • Census Place32,350
  • Military Postal9

Table and column statistics

Select a table to review its own schema, record total, fields, distinct values, and missing-value coverage.

city state combinations48,496 records · 9 fields
combination_id
Distinct
48,496
Missing
0 (0.0%)
city_name
Distinct
30,057
Missing
0 (0.0%)
state_abbreviation
Distinct
55
Missing
0 (0.0%)
state_name
Distinct
55
Missing
0 (0.0%)
jurisdiction_type
Distinct
4
Missing
0 (0.0%)
entity_count
Distinct
54
Missing
0 (0.0%)
has_census_place
Distinct
2
Missing
0 (0.0%)
has_county_subdivision
Distinct
2
Missing
0 (0.0%)
is_military_postal
Distinct
2
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

city state combinationsDownload this sample CSV
combination_idcity_namestate_abbreviationstate_namejurisdiction_typeentity_counthas_census_placehas_county_subdivisionis_military_postal
1APOAAArmed Forces Americasmilitary postal region1001
2DPOAAArmed Forces Americasmilitary postal region1001
3FPOAAArmed Forces Americasmilitary postal region1001
4APOAEArmed Forces Europe, Middle East, Africa, and Canadamilitary postal region1001
5DPOAEArmed Forces Europe, Middle East, Africa, and Canadamilitary postal region1001
6FPOAEArmed Forces Europe, Middle East, Africa, and Canadamilitary postal region1001
7AdakAKAlaskastate1100
8AkhiokAKAlaskastate1100
9AkiachakAKAlaskastate1100
10AkiakAKAlaskastate1100

Records Information

One primary record represents one normalized city/state combination. Multiple current Census entities with the same normalized name and state remain linked in the geographic_entities table rather than being discarded. Census internal points are representative geography coordinates, not street addresses or delivery validation.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Build a broader dataset

Extend this dataset around your project

Combine this database with compatible business, location, or specialty records. Oddity can also scope a custom package by geography, fields, format, and intended use.

Related datasetsField selectionCustom geography
Explore compatible data Discuss a custom package

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details