states
Canonical state dimension. One row per US state plus DC and territories. Primary key is state_id (2-character FIPS). Covers all 50 states plus DC, Puerto Rico, and other territories.
tier acensus
overview
overview
50 states + DC + Puerto Rico and US territories. Full national coverage.
current vintage — ANSI INCITS 38-2009
history — State FIPS codes are stable across all years
provenance
source & licensing
authority
U.S. Census Bureau
dataset
FIPS State Codes
license
Public domain (U.S. Federal Government work)
citation
U.S. Census Bureau, FIPS State Codes (ANSI INCITS 38-2009).
schema
fields
| name | type | definition |
|---|---|---|
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| state_abbrev | string | Two-letter USPS postal abbreviation uniquely identifying a US state or territory (e.g. "CA" for California). |
| state_idkey | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| state_name | string | Human-readable state name corresponding to state_id. |
relationships
joins
primary key
state_id
common joins
All fact tables with state_id
dim.counties on state_id
last updated · May 5, 2026