Provider identity

Care-site verified view (enriched)

vlada_curated.vw_care_site_verified·live·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Serving view unioning dim_care_site with fact_care_site_verification — verified care sites with legal name, CCN, class, county, parent system.
2The surface county_expert/county_intelligence read.

Grain

Key	Grain
N/A	1One row per verified care site (NPI) with identity + geography enrichment.

Columns (12)

Column	Type	Meaning
`npi`	string
`canonical_site_id`	string
`county_fips`	string
`county_name`	string
`state_code`	string
`legal_name`	string
`care_site_class`	string
`ccn`	string
`fleet_status`	string
`canonical_parent_system`	string
`fleet_facility_type`	string
`fleet_vintage`	string

Query it

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

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

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