Home

Dataset:

Name licensed-healthcare-facility-listing
Updated 2025-08-01
CA Dataset link
Current True
Tables
licensed_facility_listing_01     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(42)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_02     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
longitude - decimal(12,8)
latitude - decimal(12,8)
licensed_facility_listing_03     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_04     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_05     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_06     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_07     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_08     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(22)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_09     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(31)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_10     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(42)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_11     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_12     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_13     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_14     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_15     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_16     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(21)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_17     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(33)
dba_city - varchar(22)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
licensed_facility_listing_18     oshpd_id - varchar(9)
facility_name - varchar(79)
license_num - varchar(11)
facility_level_desc - varchar(22)
dba_address1 - varchar(37)
dba_city - varchar(23)
dba_zip_code - varchar(12)
county_code - varchar(11)
county_name - varchar(15)
er_service_level_desc - varchar(25)
total_number_beds - varchar(17)
facility_status_desc - varchar(20)
facility_status_date - varchar(20)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
latitude - decimal(12,8)
longitude - decimal(12,8)
Sources
facility-listing-data-dictionary.csv - None
NULL - None
licensed-healthcare-facility-listing-june-30-2025.csv - None
datapackage.json - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
NULL - None
current-california-healthcare-facility-listing.csv - licensed_facility_listing_01
licensed-healthcare-facility-listing-december-31-2016-.csv - licensed_facility_listing_02
licensed-healthcare-facility-listing-december-31-2017.csv - licensed_facility_listing_03
licensed-healthcare-facility-listing-december-31-2018.csv - licensed_facility_listing_04
licensed-healthcare-facility-listing-december-31-2019.csv - licensed_facility_listing_05
licensed-healthcare-facility-listing-december-31-2020.csv - licensed_facility_listing_06
licensed-healthcare-facility-listing-december-31-2021.csv - licensed_facility_listing_07
licensed-healthcare-facility-listing-december-31-2022.csv - licensed_facility_listing_08
licensed-healthcare-facility-listing-december-31-2023.csv - licensed_facility_listing_09
licensed-healthcare-facility-listing-december-31-2024.csv - licensed_facility_listing_10
licensed-healthcare-facility-listing-june-30-2017.csv - licensed_facility_listing_11
licensed-healthcare-facility-listing-june-30-2018.csv - licensed_facility_listing_12
licensed-healthcare-facility-listing-june-30-2019.csv - licensed_facility_listing_13
licensed-healthcare-facility-listing-june-30-2020.csv - licensed_facility_listing_14
licensed-healthcare-facility-listing-june-30-2021.csv - licensed_facility_listing_15
licensed-healthcare-facility-listing-june-30-2022.csv - licensed_facility_listing_16
licensed-healthcare-facility-listing-june-30-2023.csv - licensed_facility_listing_17
licensed-healthcare-facility-listing-june-30-2024.csv - licensed_facility_listing_18
Updated