# US state and territory dimension

`vlada_curated.dim_state` · Curated datasets · status live · 56 rows

The resolving dimension for USPS state codes, built because the only candidate authority was dim_state_metric, a metrics fact grained (state_code, domain, metric) holding roughly 37 rows per state. Population is dim_geography's state set unioned with every state code actually observed in the assets that use the identifier, so a state referenced by a metrics table but absent from the ZIP-derived geography is still resolvable.

**Grain.** One row per USPS state or territory code — the authority for usps:state.

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| state_name | string |  |
| state_fips | string |  |
| census_region | string |  |
| census_division | string |  |
| attribute_source | varchar(27) |  |

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.dim_state WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.dim_state")` first.