# Facility dimension

`vlada_curated.dim_facility` · Provider identity · status partial

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

**Grain.** One row per facility (CCN/organizational NPI) with metadata.

| 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 |  |

Tools that read it: resolve_provider

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