Baselight
Sign In

Licensed Healthcare Facility Listing

State of California

@usgov.ca_gov_licensed_healthcare_facility_listing_46300

Loading...
Loading...

About this Dataset

Licensed Healthcare Facility Listing

A list of California healthcare facilities licensed by California Department of Public Health, Licensing and Certification. To link the OSHPD IDs with those from other Departments, like CDPH, please reference the "Licensed Facility Cross-Walk" Open Data table at https://data.chhs.ca.gov/dataset/licensed-facility-crosswalk
Organization: State of California
Last updated: 2025-07-23T14:39:27.405128
Tags: california, department-of-health-care-access-and-information, hcai, healthcare, licensed-healthcare-facility-listing

Tables

Facility Listing Data Dictionary

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.facility_listing_data_dictionary
  • 6.65 kB
  • 17 rows
  • 4 columns
Loading... 
CREATE TABLE facility_listing_data_dictionary (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

Licensed Healthcare Facility Listing, December 31, 2017

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2017
  • 488.55 kB
  • 6,738 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2017 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, December 31, 2018

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2018
  • 506.83 kB
  • 7,063 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2018 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, December 31, 2019

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2019
  • 537.01 kB
  • 7,609 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2019 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, December 31, 2020

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2020
  • 564.65 kB
  • 8,125 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2020 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, December 31, 2021

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2021
  • 578.29 kB
  • 8,342 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2021 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, December 31, 2022

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2022
  • 641.43 kB
  • 9,594 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2022 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" DOUBLE,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, December 31, 2023

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2023
  • 658.79 kB
  • 10,046 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2023 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, December 31, 2024

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_december_31_2024
  • 695.82 kB
  • 10,778 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_december_31_2024 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2017

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2017
  • 458.79 kB
  • 6,240 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2017 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2018

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2018
  • 500.94 kB
  • 6,954 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2018 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2019

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2019
  • 516.55 kB
  • 7,225 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2019 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2020

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2020
  • 551.29 kB
  • 7,841 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2020 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2021

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2021
  • 570.7 kB
  • 8,224 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2021 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2022

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2022
  • 624.25 kB
  • 9,253 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2022 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" DOUBLE,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2023

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2023
  • 662.47 kB
  • 10,056 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2023 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2024

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2024
  • 648.31 kB
  • 10,452 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2024 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Licensed Healthcare Facility Listing, June 30, 2025

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.licensed_healthcare_facility_listing_june_30_2025
  • 694.15 kB
  • 10,780 rows
  • 17 columns
Loading... 
CREATE TABLE licensed_healthcare_facility_listing_june_30_2025 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Data Dictionary - Licensed Healthcare Facility Listing, December 31, 2017

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.n__dictionary_licensed_healthcare_facility_listing_dec_315a0b31
  • 3.47 kB
  • 17 rows
  • 4 columns
Loading... 
CREATE TABLE n__dictionary_licensed_healthcare_facility_listing_dec_315a0b31 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Table 20

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.table_20
  • 476.76 kB
  • 6,895 rows
  • 17 columns
Loading... 
CREATE TABLE table_20 (
  "oshpd_id" BIGINT,
  "facility_name" VARCHAR,
  "license_num" VARCHAR,
  "facility_level_desc" VARCHAR,
  "dba_address1" VARCHAR,
  "dba_city" VARCHAR,
  "dba_zip_code" BIGINT,
  "county_code" BIGINT,
  "county_name" VARCHAR,
  "er_service_level_desc" VARCHAR,
  "total_number_beds" DOUBLE,
  "facility_status_desc" VARCHAR,
  "facility_status_date" TIMESTAMP,
  "license_type_desc" VARCHAR,
  "license_category_desc" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);

Table 21

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.table_21
  • 4.78 kB
  • 17 rows
  • 4 columns
Loading... 
CREATE TABLE table_21 (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Share link

Anyone who has the link will be able to view this.