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-08-23T12:59:47.317727
Tags: california, department-of-health-care-access-and-information, hcai, healthcare, licensed-healthcare-facility-listing

Tables

Current California Healthcare Facility Listing

@usgov.ca_gov_licensed_healthcare_facility_listing_46300.current_california_healthcare_facility_listing

743.13 kB
10,838 rows
18 columns

CREATE TABLE current_california_healthcare_facility_listing (
  "oshpd_id" BIGINT,
  "perm_id" DOUBLE,
  "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
);