Home

Dataset:

Name	healthcare-facility-locations
Updated	2025-08-07
CA Dataset	link
Current	True
Tables	across_time_summ_data_lic_and_cert_facs     state_fiscal_year - varchar(20) county_name - varchar(15) provider_type - varchar(18) fac_fdr - varchar(44) count_num - varchar(5) licensed_and_certified_healthcare_facility_locations     licensed_certified - varchar(35) flag - varchar(16) t18_19 - varchar(13) facid - varchar(9) fac_status_type_code - varchar(20) aspen_facid - varchar(16) ccn - varchar(10) terminat_sw - varchar(11) participation_date - varchar(18) approval_date - varchar(13) npi - varchar(10) can_be_deemed_fac_type - varchar(22) can_be_certified_fac_type - varchar(25) deemed - varchar(6) ao_cd - varchar(5) dmg_efctv_dt - varchar(12) ao_trmntn_dt - varchar(12) ao_name - varchar(7) facname - varchar(100) fac_type_code - varchar(13) fac_fdr - varchar(44) ltc - varchar(7) capacity - varchar(8) address - varchar(67) city - varchar(21) zip - varchar(5) zip9 - varchar(4) facadmin - varchar(38) contact_email - varchar(48) contact_fax - varchar(14) contact_phone_number - varchar(20) county_code - varchar(11) county_name - varchar(15) district_number - varchar(15) district_name - varchar(24) isfacmain - varchar(9) parent_facid - varchar(12) fac_fac_relationship_type_code - varchar(30) start_date - varchar(10) license_number - varchar(14) business_name - varchar(74) license_status_description - varchar(26) initial_license_date - varchar(20) license_effective_date - varchar(22) license_expiration_date - varchar(23) entity_type_description - varchar(25) latitude - decimal(12,8) longitude - decimal(12,8) location - varchar(27) hcai_id - varchar(9) cclho_code - varchar(10) cclho_name - varchar(15) fips_county_code - varchar(16) birthing_facility_flag - varchar(22) trauma_ped_ctr - varchar(14) trauma_ctr - varchar(10) type_of_care - varchar(26) critical_access_hospital - varchar(24) data_date - varchar(9) lookup_table_licensed_and_certified_healthcare_facility_lookup     variable - varchar(7) description - varchar(26) elms_value - varchar(8) aspen_factype - varchar(3) aspen_value - varchar(8) ltc - varchar(9)
Sources	across-time-data-dictionary-licensed-and-certified-healthcare-facilities.xlsx  -    facility-list-data-dictionary-licensed-and-certified-healthcare-facility-listing.xlsx  -    preserve-leading-zero-and-import-code-guide-for-licensed-and-certified-healthcare-facility-listing-file.pdf  -    preserve-leading-zero.pdf  -    datapackage.json  -    across-time-dashboard-licensed-and-certified-healthcare-facilities.tableau  -    counts-dashboard-licensed-and-certified-healthcare-facility.tableau  -    across-time-summary-data-licensed-and-certified-healthcare-facilities.csv  -  Table: across_time_summ_data_lic_and_cert_facs   Updated: 2025-10-08 licensed-and-certified-healthcare-facility-locations.csv  -  Table: licensed_and_certified_healthcare_facility_locations   Updated: 2025-10-08 lookup-table-licensed-and-certified-healthcare-facility-listing-lookup-table.xlsx  -  Table: lookup_table_licensed_and_certified_healthcare_facility_lookup   Updated: 2025-06-25
Updated