About this Dataset

COVID-19 Positive Cases: DHCS Behavioral Health Licensed And Certified Facilities

COVID-19 positive cases reported amongst staff and residents within behavioral health licensed and certified facilities overseen by DHCS.
Organization: State of California
Last updated: 2023-08-12T12:37:17.987916
Tags: alcoholism, california-department-of-health-care-services, certified-alcohol-and-drug-programs, coronavirus, covid, covid-19, covid19, dhcs, drug-abuse, licensed-andor-certified-by-the-department-of-health-care-services, licensed-residential-facilities, mental-health-psychiatric-health-facility, mental-health-rehabilitation-center, narcotic-treatment-program, non-medical, nonresidential, outpatient, recovery, substance-use-disorder, treatment-facilities

Tables

DHCS COVID-19 Reported BH Facilities

@usgov.ca_gov_covid_19_positive_cases_dhcs_behavioral_health__5459a730.dhcs_covid_19_reported_bh_facilities

25.53 kB
613 rows
11 columns

CREATE TABLE dhcs_covid_19_reported_bh_facilities (
  "date" TIMESTAMP,
  "facility_type" VARCHAR,
  "facility_name" VARCHAR,
  "license_number" VARCHAR,
  "county" VARCHAR,
  "staff_confirmed_covid_19_cumulative" DOUBLE  -- Staff: Confirmed COVID-19 (CUMULATIVE),
  "residents_clients_confirmed_covid_19_cumulative" DOUBLE  -- Residents/Clients: Confirmed COVID-19 (CUMULATIVE),
  "staff_covid_related_deaths_cumulative" DOUBLE  -- Staff: COVID-Related Deaths (CUMULATIVE),
  "residents_clients_covid_related_deaths_cumulative" DOUBLE  -- Residents/Clients: COVID-Related Deaths (CUMULATIVE),
  "annotaion_code" DOUBLE,
  "annotation_code_description" VARCHAR
);