# CCN <-> NPI facility bridge

`vlada_curated.provider_facility_xref` · Provider identity · status live

Confidence-scored bridge between hospital CCNs and provider NPIs. The join key for hospital x commercial unification. Floor for use is confidence >= 0.80.

**Grain.** One row per (hospital_ccn, npi) candidate match with confidence + method.

| column | type | meaning |
|---|---|---|
| provider_entity_id | string |  |
| facility_entity_id | string |  |
| npi | string |  |
| ccn | string |  |
| match_method | string |  |
| confidence | double |  |
| evidence_json | string |  |
| built_at | timestamp |  |

Tools that read it: resolve_provider

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.provider_facility_xref WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.provider_facility_xref")` first.