About this Dataset

Licensed Mental Health Rehabilitation Centers (MHRC) And Psychiatric Health Facilities (PHF)

This dataset contains an alphabetical list, by county, of all Mental Health Rehabilitation Centers (MHRC) and Psychiatric Health Facilities (PHF) licensed by the Department of Health Care Services (DHCS). Within DHCS, the Licensing and Certification Division (LCD), Licensing Branch 2, Mental Health Licensing (MHL) Section is responsible for assuring that quality mental health treatment and services are provided to all program participants in a safe and healthy environment through licensure and oversight of a statewide system of 24-hour psychiatric and rehabilitation care facilities.
Organization: State of California
Last updated: 2025-07-23T14:35:31.101586
Tags: california-department-of-health-care-services, care, centers, certification, dhcs, facilities, health, health-care-services-licensing, licensing, mental, mhrc, phf, psychiatric, rehabilitation, services

Tables

County Code List

@usgov.ca_gov_licensed_mental_health_rehabilitation_centers_m_f549f4a8.county_code_list

3.09 KB
58 rows
2 columns


CREATE TABLE county_code_list (
  "county_code" BIGINT,
  "county" VARCHAR
);

DHCS Licensed Mental Health Rehabilitation Centers (MHRC) And Psychiatric Health Facilities (PHF)

@usgov.ca_gov_licensed_mental_health_rehabilitation_centers_m_f549f4a8.dhcs_licensed_mental_health_rehabilitation_centers_mhr_3cb00173

23.37 KB
73 rows
20 columns


CREATE TABLE dhcs_licensed_mental_health_rehabilitation_centers_mhr_3cb00173 (
  "county_code" VARCHAR,
  "record_id" VARCHAR,
  "legal_name" VARCHAR,
  "facility_name" VARCHAR,
  "physical_address" VARCHAR,
  "physical_address_2" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_address_2" VARCHAR,
  "physical_city" VARCHAR,
  "mailing_city" VARCHAR,
  "physical_state" VARCHAR,
  "mailing_state" VARCHAR,
  "physical_zip" BIGINT,
  "mailing_zip" BIGINT,
  "facility_phone" VARCHAR,
  "type_of_application" VARCHAR,
  "service_type" VARCHAR,
  "client_patient_capacity" BIGINT,
  "expiration_date" TIMESTAMP,
  "target_population" VARCHAR
);