Home

Dataset:

Name	licensed-healthcare-facility-listing
Updated	2025-08-01
CA Dataset	link
Current	False
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 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
Updates	2025-07-11 17:44:17      None 2025-07-04 16:49:45      0 2025-06-06 12:11:07      0 2025-04-11 11:31:00      0 2025-03-03 10:04:05      0 2025-02-03 09:57:47      0 2025-02-02 18:19:23      0 2025-01-31 14:28:19      0 2025-01-03 19:43:55      0 2025-01-03 19:18:07      1 2025-01-03 19:17:02      1 2025-01-03 19:15:37      1 2025-01-03 18:59:07      1 2025-01-03 14:48:05      1 2024-12-27 18:44:27      0 2024-12-25 17:12:22      0 2024-12-25 16:33:44      1 2024-12-25 16:33:44      1 2024-12-25 16:27:15      1 2024-12-25 16:27:14      1 2024-12-25 16:25:46      1 2024-12-25 16:25:46      1 2024-11-15 20:08:57      None 2024-11-15 20:08:57      None 2024-09-18 13:09:57      None 2024-09-18 13:09:57      None 2024-09-09 15:54:26      None 2024-09-09 15:54:26      None 2024-09-09 13:43:04      None 2024-09-09 13:43:03      None 2024-08-21 10:46:16      None 2024-08-21 10:46:16      None 2024-08-21 10:45:11      None 2024-06-19 13:42:57      None 2024-06-19 13:24:21      None 2024-06-19 12:20:59      None 2024-05-30 11:31:29      None