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.Current update offer$5.00For eligible earlier Master purchases
$100.00
Records
48,496
Version
2.0.0
Release date
Sep 4, 2026
Before you choose
Explore the samples
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
U.S. City-State Master Database artwork
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

License Database Purchase Options

MASTER

Complete

$100.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$5.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

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 schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.

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.

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.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

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