Provider identity

Health System list

vlada_curated.dim_health_system·live·dim

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1A roster of health systems with system type, HQ state, and a multi-facility flag.
2A lightweight system list (the richer hierarchy is dim_hospital_system).

Grain

Key	Grain
N/A	1One row per health system (system_name) — type, HQ state, multi-facility flag.

Columns (4)

Column	Type	Meaning
`system_name`	string
`system_type`	string
`hq_state`	string
`multi_facility`	boolean

Query it

describe_data_source(source_fqn="vlada_curated.dim_health_system")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.dim_health_system WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`system_name`
Join	`how_to_join(source_fqn="vlada_curated.dim_health_system")`
Raw door	Athena (read-only via query_substrate): vlada_curated.dim_health_system

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