Provider identity

Facility dimension

vlada_curated.dim_facility·partial·dim·Vlada Provider & Facility Identity

Rows

N/A

Columns

112

History

N/A

Card

nocolumns only

Typed tools

What it is

1Facility-level metadata (CCN, organizational NPI, name, location) used to anchor the CCN<->NPI bridge and hospital identity spine.

Grain

Key	Grain
N/A	1One row per facility (CCN/organizational NPI) with metadata.

Columns (112)

Column	Type	Meaning
`facility_id`	string
`ccn`	string
`npi`	string
`ein`	string
`state_license`	string
`display_name`	string
`display_name_normalized`	string
`legal_name`	string
`dba_name`	string
`geo_id`	string
`street_address`	string
`street_address_2`	string
`city`	string
`state_code`	string
`zip_code`	string
`zip_plus_4`	string
`county_name`	string
`county_fips`	string
`cbsa_code`	string
`latitude`	double
`longitude`	double
`geocode_accuracy`	string
`system_id`	string
`parent_facility_id`	string
`parent_ccn`	string
`is_main_campus`	boolean
`campus_name`	string
`facility_type`	string
`facility_subtype`	string
`ownership_type`	string
`ownership_subtype`	string
`teaching_status`	string
`medical_school_affiliation`	string
`residency_programs`	string
`urban_rural`	string
`bed_count`	string
`bed_count_source`	string
`bed_count_date`	string
`staffed_beds`	string
`icu_beds`	string
`emergency_services`	boolean
`trauma_level`	string
`has_helipad`	string
`joint_commission_accredited`	string
`cms_star_rating`	string
`leapfrog_grade`	string
`peer_group_id`	string
`peer_group_override`	boolean
`mrf_status`	string
`mrf_sub_status`	string
`mrf_url`	string
`mrf_url_source`	string
`mrf_url_verified`	boolean
`mrf_url_verified_at`	timestamp
`mrf_url_verification_method`	string
`mrf_last_checked_at`	timestamp
`mrf_last_downloaded_at`	timestamp
`mrf_last_parsed_at`	timestamp
`mrf_file_hash`	string
`mrf_record_count`	double
`mrf_file_format`	string
`mrf_parse_method`	string
`mrf_failure_count`	bigint
`mrf_last_failure_at`	timestamp
`mrf_last_failure_reason`	string
`data_quality_score`	double
`data_completeness_score`	string
`benchmark_ready`	boolean
`benchmark_ready_reason`	string
`has_hospital_pricing`	boolean
`has_commercial_coverage`	boolean
`commercial_payer_count`	bigint
`cms_status`	string
`cms_certification_date`	string
`cms_termination_date`	string
`cms_last_survey_date`	string
`acquired_by_facility_id`	string
`acquired_by_ccn`	string
`acquisition_date`	string
`acquisition_type`	string
`main_phone`	string
`main_fax`	string
`website_url`	string
`patient_portal_url`	string
`status`	string
`status_reason`	string
`status_changed_at`	string
`created_at`	timestamp
`updated_at`	timestamp
`created_by`	string
`updated_by`	string
`data_sources`	string
`last_enriched_at`	string
`last_verified_at`	timestamp
`version`	bigint
`metadata`	string
`tags`	string
`npi_confidence`	double
`is_independent`	boolean
`independent_source`	string
`linkage_confidence`	double
`linkage_source`	string
`website_verified`	boolean
`website_verified_at`	timestamp
`website_verification_method`	string
`last_collected_at`	timestamp
`last_verify_count_status`	string
`cms_version`	string
`layout`	string
`compliance_status`	string
`dialect_id`	string
`_synced_at`	timestamp

Query it

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

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