About this Dataset

Effects Of COVID-19 On Hospital Utilization Trends

With the onset of COVID-19, hospitals statewide saw a sharp drop in inpatient discharges, emergency department utilization, and ambulatory surgeries. These datasets contain monthly counts of encounters and in-hospital mortalities in those three settings and are also broken down by the following common health conditions/categories: anxiety, asthma, behavioral syndromes, cancer, cardiac arrest, chronic obstructive pulmonary disease (COPD), COVID-19, depression, diabetes, homeless, hypertension, mood disorders (excluding depression), non-mood psychotic disorders, nonpsychotic disorders (excluding anxiety), obesity, pneumonia, respiratory arrest/failure, sepsis, stroke, substance use disorders, and unspecified mental disorders.
Organization: State of California
Last updated: 2023-08-25T21:28:26.176589
Tags: acute-care-hospitals, ambulatory-surgery, as-encounters, covid-19-coronavirus, department-of-health-care-access-and-information, discharges, emergency-department, healthcare, mortality, trends, utilization

Tables

In-Hospital Mortality Trends By Diagnosis Type

@usgov.ca_gov_effects_of_covid_19_on_hospital_utilization_trends_636d2.in_hospital_mortality_trends_by_diagnosis_type

13.18 KB
2305 rows
7 columns


CREATE TABLE in_hospital_mortality_trends_by_diagnosis_type (
  "category" VARCHAR,
  "setting" VARCHAR,
  "diagnosis" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "date" VARCHAR,
  "count" BIGINT
);

In-Hospital Mortality Trends By Health Category

@usgov.ca_gov_effects_of_covid_19_on_hospital_utilization_trends_636d2.in_hospital_mortality_trends_by_health_category

11.25 KB
2243 rows
4 columns


CREATE TABLE in_hospital_mortality_trends_by_health_category (
  "date" VARCHAR,
  "category" VARCHAR,
  "setting" VARCHAR,
  "count" BIGINT
);

In-Hospital Mortality Trends By Secondary Diagnosis

@usgov.ca_gov_effects_of_covid_19_on_hospital_utilization_trends_636d2.in_hospital_mortality_trends_by_secondary_diagnosis

11.62 KB
1684 rows
7 columns


CREATE TABLE in_hospital_mortality_trends_by_secondary_diagnosis (
  "category" VARCHAR,
  "setting" VARCHAR,
  "diagnosis" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "date" VARCHAR,
  "count" BIGINT
);

Utilization Trends By Health Category

@usgov.ca_gov_effects_of_covid_19_on_hospital_utilization_trends_636d2.utilization_trends_by_health_category

405.25 KB
818513 rows
6 columns


CREATE TABLE utilization_trends_by_health_category (
  "date" VARCHAR,
  "setting" VARCHAR,
  "category" VARCHAR,
  "system" VARCHAR,
  "facility_name" VARCHAR,
  "count" DOUBLE
);