COVID-19 Positive Cases: DHCS Behavioral Health Licensed And Certified Facilities by US Government | Healthcare

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

24.93 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,
  "residents_clients_confirmed_covid_19_cumulative" DOUBLE,
  "staff_covid_related_deaths_cumulative" DOUBLE,
  "residents_clients_covid_related_deaths_cumulative" DOUBLE,
  "annotaion_code" DOUBLE,
  "annotation_code_description" VARCHAR
);