# Care-site verified view (enriched)

`vlada_curated.vw_care_site_verified` · Provider identity · status live

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

**Grain.** One row per verified care site (NPI) with identity + geography enrichment.

| 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: `query_substrate` with `SELECT ... FROM vlada_curated.vw_care_site_verified WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.vw_care_site_verified")` first.