Curated datasets

State Metrics (demographics / health context, integrated)

vlada_curated.dim_state_metric·live·dim·State Health & Demographics

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Integrated state-level metrics across domains (demographics, health outcomes, access) with value, unit, geo_level, source, and data_year.
2Backs the state-agent/state-KB context.

Grain

Key	Grain
N/A	1One row per (state_code, domain, metric, data_year) — a metric value.

Columns (11)

Column	Type	Meaning
`state_code`	string
`domain`	string
`metric`	string
`value`	double
`unit`	string
`geo_level`	string
`source`	string
`source_url`	string
`vintage`	string
`ingested_at`	string
`data_year`	string

Query it

describe_data_source(source_fqn="vlada_curated.dim_state_metric")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.dim_state_metric 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_metric")`
Raw door	Athena (read-only via query_substrate): vlada_curated.dim_state_metric

This page as markdown: /docs-md/data/vlada_curated_dim_state_metric.md · every page in one file: /llms-full.txt