docs/us_dimension/states

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 aTier A: canonical ANSI/FIPS state reference.

grain

state

years

—

cadence

Static

overview

56 rows — 50 states, DC, and 5 territories.

current vintage — 2023

provenance

source & licensing

authority

U.S. Census Bureau

dataset

ANSI/FIPS state codes

source url

https://www.census.gov/library/reference/code-lists/ansi.html

license

Public domain (U.S. Federal Government work)

citation

U.S. Census Bureau, ANSI state codes.

schema

fields

name	type	definition
country_id	string	ISO alpha-2 country code (always 'US' for domestic tables).
state_abbrev	string	2-letter USPS postal abbreviation for the state, DC, or territory (e.g. "CA" for California). A string label, not a numeric measure.
state_idkey	string	2-character FIPS code identifying the state.Part of primary key. 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

not provided

usage

how to use this table

method

Loaded from the ANSI state code list; no derivation.

do not use for

N/A — static reference dimension.

← previousus_dimension.sic_naics next →us_dimension.tract_county_crosswalk

last updated · Jul 7, 2026