Provider identity

Care-site verification (county-fleet promoted truth)

vlada_curated.fact_care_site_verification·live·curated

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The county-fleet promoted verification table: per NPI/county/class, the fleet_status (verified/reclassified/duplicate/unresolved), canonical site id, parent system, true facility type, confidence.
2The audited truth of which care sites are real (vw_care_site_verified serves it enriched).

Grain

Key	Grain
N/A	1One row per (NPI, county, care_site_class) — verified care-site verdict.

Columns (11)

Column	Type	Meaning
`npi`	string
`canonical_site_id`	string
`county_fips`	string
`care_site_class`	string
`fleet_status`	string
`canonical_parent_system`	string
`true_facility_type`	string
`confidence`	string
`vintage`	string
`legal_name`	string
`state_code`	string

Query it

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

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