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)
licensed_healthcare_facility_listing_june_30_2025    
Sources
facility-listing-data-dictionary.csv  -   
datapackage.json  -   
current-california-healthcare-facility-listing.csv  -  Table: licensed_facility_listing_01   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2016-.csv  -  Table: licensed_facility_listing_02   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2017.csv  -  Table: licensed_facility_listing_03   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2018.csv  -  Table: licensed_facility_listing_04   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2019.csv  -  Table: licensed_facility_listing_05   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2020.csv  -  Table: licensed_facility_listing_06   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2021.csv  -  Table: licensed_facility_listing_07   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2022.csv  -  Table: licensed_facility_listing_08   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2023.csv  -  Table: licensed_facility_listing_09   Updated: 2025-10-08
licensed-healthcare-facility-listing-december-31-2024.csv  -  Table: licensed_facility_listing_10   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2017.csv  -  Table: licensed_facility_listing_11   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2018.csv  -  Table: licensed_facility_listing_12   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2019.csv  -  Table: licensed_facility_listing_13   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2020.csv  -  Table: licensed_facility_listing_14   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2021.csv  -  Table: licensed_facility_listing_15   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2022.csv  -  Table: licensed_facility_listing_16   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2023.csv  -  Table: licensed_facility_listing_17   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2024.csv  -  Table: licensed_facility_listing_18   Updated: 2025-10-08
licensed-healthcare-facility-listing-june-30-2025.csv  -  Table: licensed_healthcare_facility_listing_june_30_2025   Updated: 2025-10-11
Updated