DSH COVID-19 Patient Testing: Last updated -02/10/2025 DSH COVID-19 Patient Data reports on patient positives and testing counts at the facility level for DSH. The table reports on the following data fields: * Total patients that tested positive for COVID-19 since 5/16/2020 * Patients newly positive for COVID-19 in the last 14 days * Patient deaths while patient was positive for COVID-19 since 5/30/2020 * Total number of tests administered since 3/23/2020 ##Table Notes: COVID-19 test results for patients include DSH patients who are tested while receiving treatment at an outside medical facility. Data has been de-identified in accordance with CalHHS Data De-identification Guidelines. Counts between 1-10 are masked with "<11". Includes Patients Under Investigation (PUIs) testing and proactive testing of asymptomatic patients for surveillance of geriatric, medically fragile, and skilled nursing facility units and for patients upon admission, re-admission, or discharge. Includes all individuals who were positive for COVID-19 at time of death, regardless of underlying health conditions or whether the cause of death has been confirmed to be COVID-19 related illness. Metro-Norwalk is additional COVID-19 surge space and technically a branch location that is part of DSH Metropolitan Hospital.

Organization: State of California
Last updated: 2025-07-23T16:12:09.049832
Tags: california-department-of-state-hospitals, covid, covid-19, covid19

Tables

COVID-19 Patient Data

@usgov.ca_gov_covid_19_patient_data_9604c.covid_19_patient_data

7.14 kB
6 rows
6 columns

CREATE TABLE covid_19_patient_data (
  "facility" VARCHAR,
  "positive_for_covid_19_cumulative_since_5_16_2020" BIGINT  -- Positive For COVID-19 (Cumulative # Since 5/16/2020),
  "newly_positive_for_covid_19_in_the_last_14_days" BIGINT,
  "positive_for_covid_19_while_at_acute_hospitalization" BIGINT,
  "death_while_patient_was_positive_for_covid_19_cumulati_212b83b2" VARCHAR  -- Death While Patient Was Positive For COVID-19 (Cumulative # Since 05/30/2020),
  "total_of_tests_administered_cumulative_since_3_23_2020_035c9455" BIGINT  -- Total # Of Tests Administered (Cumulative # Since 3/23/2020, Includes Retesting)
);