Curated datasets
US state and territory dimension
vlada_curated.dim_state·live·dimRows
56
Columns
6
History
N/A
Card
nocolumns only
Typed tools
0
What it is
- 1The 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.
- 2Population 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
| Key | Grain |
|---|---|
| N/A |
|
Columns (6)
| Column | Type | Meaning |
|---|---|---|
state_code | string | |
state_name | string | |
state_fips | string | |
census_region | string | |
census_division | string | |
attribute_source | varchar(27) |
Query it
describe_data_source(source_fqn="vlada_curated.dim_state") # the card, live query_substrate(sql="SELECT * FROM vlada_curated.dim_state WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | none; raw SQL |
| Identity key | state_code |
| Join | how_to_join(source_fqn="vlada_curated.dim_state") |
| Raw door | Athena (read-only): vlada_curated.dim_state |
| Note | Built by ops/scripts/build_dim_state.py. Population derived from data rather than written from memory, for the same reason dim_provider_ccn was built from rosters instead of CMS range conventions. |
This page as markdown: /docs-md/data/vlada_curated_dim_state.md · every page in one file: /llms-full.txt