US State Abbreviations List v.2.0.0
60 Database Records
The US State Abbreviations and Codes Database is a structured 60-record reference for the 50 states, District of Columbia, U.S. territories, and the three independent freely associated states served under USPS domestic-mail rules. Each row includes the canonical name, official USPS abbreviation, historical prose abbreviation where available, entity type, sovereignty status, Census FIPS code, GNIS identifier where published, ISO 3166-2 identifier where applicable, and a scope note. The protected package includes matching UTF-8 CSV, JSON, and SQLite files plus schema, sample, statistics, source documentation, and integrity evidence.
Table Schema Database Field Statistics
Release structure
US State Abbreviations List
Review the published tables, record coverage, and field names included with release 2.0.0.
- Database
- #751
- Version
- 2.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| name | text | Yes | Canonical Census or USPS geographic name. |
| usps_code | text | Yes | Official two-letter USPS state or possession code. |
| traditional_abbreviation | text | No | Conventional prose abbreviation retained from the historical Oddity list; blank where the source supplied none. |
| entity_type | text | Yes | State, federal district, U.S. territory, U.S. territory aggregate, or freely associated state. |
| sovereignty_status | text | Yes | Plain-language sovereignty classification based on Census status definitions. |
| fips_code | text | Yes | Two-digit Census state-level FIPS/ANSI code stored as text. |
| gnis_id | text | No | Eight-digit GNIS identifier where published in the Census national file. |
| iso_3166_2 | text | No | ISO 3166-2 subdivision identifier for U.S. entities; blank for independent freely associated states. |
| source_note | text | No | Concise scope or normalization note. |
Release at a glance
What is inside this database
Review verified record totals, geographic coverage, classifications, and field completeness for US State Abbreviations List.
nameCanonical Census or USPS geographic name.
- Distinct
- 60
- Missing
- 0.0%
usps_codeOfficial two-letter USPS state or possession code.
- Distinct
- 60
- Missing
- 0.0%
traditional_abbreviationConventional prose abbreviation retained from the historical Oddity list; blank where the source supplied none.
- Distinct
- 55
- Missing
- 10.0%
entity_typeState, federal district, U.S. territory, U.S. territory aggregate, or freely associated state.
- Distinct
- 5
- Missing
- 0.0%
sovereignty_statusPlain-language sovereignty classification based on Census status definitions.
- Distinct
- 3
- Missing
- 0.0%
fips_codeTwo-digit Census state-level FIPS/ANSI code stored as text.
- Distinct
- 60
- Missing
- 0.0%
gnis_idEight-digit GNIS identifier where published in the Census national file.
- Distinct
- 58
- Missing
- 5.0%
iso_3166_2ISO 3166-2 subdivision identifier for U.S. entities; blank for independent freely associated states.
- Distinct
- 58
- Missing
- 5.0%
source_noteConcise scope or normalization note.
- Distinct
- 4
- Missing
- 88.3%
Entity Type
- State50
- U.S. Territory5
- Freely Associated State3
- U.S. Territory Aggregate1
- Federal District1
Records Information
Each row represents one state-level geographic entity recognized in the Census or USPS code systems. The release contains 50 states, one federal district, five individually listed U.S. territories, one U.S. territory aggregate, and three independent freely associated states. USPS codes are unique. Blank historical abbreviation, GNIS, or ISO fields mean the selected authoritative source did not provide an applicable value.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
RECENT DATA UPDATES
U.S. Jewelers and Jewelry Store Locations Database
38,557 Jewelry retail locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours ago
U.S. Pet Boarding and Kennel Locations Database
6,859 Pet boarding locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours ago
U.S. Animal Hospital Locations Database
2,990 Animal hospital locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours ago
U.S. Veterinarian Practice Locations Database
39,007 Veterinarian practice locations
v. 2.0.0
Updated 19 hours ago
v. 2.0.0
Updated 19 hours 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