Provider identity

Care-site geography (CCN → CBSA/county/ZIP)

vlada_curated.care_site_geo·live·dim

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Care-site geography: hospital_ccn → care_site_type, CBSA, county FIPS, ZIP, city, state with geo source + vintage.
2Places each care site in its market.

Grain

Key	Grain
N/A	1One row per care site (hospital_ccn) — its CBSA/county/ZIP geography.

Columns (9)

Column	Type	Meaning
`hospital_ccn`	string
`care_site_type`	string
`cbsa`	string
`county_fips`	string
`zip`	string
`city`	string
`state`	string
`geo_source`	string
`geo_vintage`	string

Query it

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

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

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