# Care-site verification (county-fleet promoted truth)

`vlada_curated.fact_care_site_verification` · Provider identity · status live

The 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. The audited truth of which care sites are real (vw_care_site_verified serves it enriched).

**Grain.** One row per (NPI, county, care_site_class) — verified care-site verdict.

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