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