Home

Dataset:

Name healthcare-facility-locations
Updated 2025-08-07
CA Dataset link
Current False
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-dashboard-licensed-and-certified-healthcare-facilities.tableau - None
across-time-data-dictionary-licensed-and-certified-healthcare-facilities.xlsx - None
counts-dashboard-licensed-and-certified-healthcare-facility.tableau - None
facility-list-data-dictionary-licensed-and-certified-healthcare-facility-listing.xlsx - None
preserve-leading-zero-and-import-code-guide-for-licensed-and-certified-healthcare-facility-listing-file.pdf - None
preserve-leading-zero.pdf - None
datapackage.json - None
across-time-dashboard-licensed-and-certified-healthcare-facilities.tableau - None
counts-dashboard-licensed-and-certified-healthcare-facility.tableau - None
across-time-summary-data-licensed-and-certified-healthcare-facilities.csv - across_time_summ_data_lic_and_cert_facs
licensed-and-certified-healthcare-facility-locations.csv - licensed_and_certified_healthcare_facility_locations
lookup-table-licensed-and-certified-healthcare-facility-listing-lookup-table.xlsx - lookup_table_licensed_and_certified_healthcare_facility_lookup
Updates
2025-07-11 17:45:16      None
2025-06-25 13:22:45      0
2025-06-25 12:54:01      0
2025-06-06 11:37:46      0
2025-04-20 18:53:13      0
2025-04-16 09:34:36      0
2025-03-31 13:42:24      0
2025-03-31 13:39:44      1
2025-03-19 09:16:20      1
2025-03-03 10:01:30      1
2025-02-11 09:50:59      0
2025-02-02 17:57:53      0
2025-01-31 16:07:43      0
2025-01-31 14:24:23      0
2025-01-31 09:55:38      0
2025-01-23 20:01:13      0
2025-01-16 17:45:26      0
2025-01-16 17:45:25      0
2025-01-16 17:32:19      0
2025-01-16 17:32:18      0
2025-01-10 11:15:27      0
2024-12-28 21:44:44      0
2024-11-15 15:10:04      None
2024-09-18 12:59:41      None
2024-09-10 20:09:16      None
2024-09-10 19:58:12      None
2024-09-10 19:57:47      None
2024-09-10 19:56:47      None
2024-09-09 15:47:35      None
2024-09-09 13:36:31      None
2024-07-30 15:50:56      None
2024-07-16 19:20:16      None
2024-06-26 12:07:15      None
2024-06-26 12:03:54      None
2024-06-26 12:01:53      None