DataTerminology.comNEW
Also known as: ISO 3166-2 Codes, FIPS State Codes, Subdivision Codes
Standard codes that identify primary subdivisions of countries, such as states, provinces, or regions.
DESCRIPTION
State codes provide standardized identifiers for country subdivisions, enabling accurate address matching, deduplication, and geographic analytics. ISO 3166-2 codes are internationally used, while legacy or national codes like U.S. FIPS appear in some datasets. Proper selection and mapping reduce ambiguity, especially for cross-border data. Governance includes version control, alias handling, and change history for boundary or naming updates.
ALTERNATIVE DEFINITIONS
Wikipedia
ISO 3166-2 defines codes for the names of the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1.
Highlights ISO 3166-2 scope over principal subdivisions globally.
U.S. Census Bureau
States and equivalent entities are assigned a two-digit numeric code, and the District of Columbia is treated as a state-equivalent entity.
Explains U.S. numeric coding for state-equivalent entities after FIPS transition to ANSI.
RELATED TERMS
ISO 3166 Geocoding Address Standardization Master Data Management UN M49 Postal Codes Geographic Information System
COMPETING TERMS
RELATIONS
- Narrower: ISO State Codes USPS State Codes
KNOWLEDGE AREAS
Reference & Master Data Data Integration & Interoperability Data Management Data Quality Domain & Business Context
TARGET AUDIENCE
Data Steward Data Modeler Data Architect Data Engineer BI Specialist Data Governance Manager
EXTERNAL SOURCES
- Wikipedia - ISO 3166-2
- International Organization for Standardization - ISO 3166 overview
- U.S. Census Bureau - U.S. state ANSI codes
TOP QUESTIONS
Why are State Codes important for data quality?
They enforce consistent subdivision identifiers, improving address matching, deduplication, and geographic rollups for analytics and reporting.
Category: Relevancy
What is the difference between ISO 3166-2 and FIPS State Codes?
ISO 3166-2 is the international standard for subdivisions; FIPS was a U.S. federal scheme. Many datasets have moved to ANSI/ISO references.
Category: Comparison
How do I map legacy FIPS State Codes to ISO 3166-2?
Use curated crosswalk tables and validate edge cases like territories. Preserve original values and track mapping provenance for audits.
Category: Best practices
Do State Codes change over time?
Yes, due to subdivision renaming or boundary changes. Maintain versioning and effective dates in reference data.
Category: Management
What common mistakes occur with State Codes?
Mixing postal abbreviations with ISO codes, using free-text names, or ignoring diacritics can cause mismatches and joins that silently fail.
Category: Mistakes
How should I store State Codes in a data model?
Use normalized reference tables with code, name, parent country, and validity periods. Enforce referential integrity and code system metadata.
Category: Modeling
Which roles should own State Codes in governance?
Data Stewards manage definitions and quality, while Data Architects standardize usage and mappings across domains.
Category: Governance
Are State Codes the same as postal abbreviations?
Not always. Postal abbreviations (e.g., USPS) differ from ISO 3166-2; ensure you select the correct system for your use case.
Category: Misunderstanding
Where can I find authoritative State Code lists?
ISO 3166 resources and national statistics agencies provide official lists and updates with documentation.
Category: Resources