Provider identity

CCN <-> NPI facility bridge

vlada_curated.provider_facility_xref·live·curated·Vlada Provider & Facility Identity

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Grain

Key	Grain
N/A	1One row per (hospital_ccn, npi) candidate match with confidence + method.

Columns (8)

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

Query it

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

Item	Value
Typed tools that read it	resolve_provider
Identity key	`hospital_ccn`
Join	`how_to_join(source_fqn="vlada_curated.provider_facility_xref")`
Raw door	Athena: vlada_curated.provider_facility_xref (filter confidence >= 0.80)
Note	match_method direct_facility_npi (1.0) or fuzzy_name_zip (RapidFuzz token_sort_ratio >= 70 + state + ZIP).

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