COVID-19 Reported Patient Impact and Hospital Capacity by State (RAW)

<p><b>After Friday September 29th, 2023, as a result of changes in reporting cadence, this dataset will be updated once a week on Fridays.</b></p>

The following dataset provides state-aggregated data for hospital utilization. These are derived from reports with facility-level granularity across two main sources: (1) HHS TeleTracking, and (2) reporting provided directly to HHS Protect by state/territorial health departments on behalf of their healthcare facilities.

The file will be updated regularly and provides the latest values reported by each facility within the last four days for all time. This allows for a more comprehensive picture of the hospital utilization within a state by ensuring a hospital is represented, even if they miss a single day of reporting.

No statistical analysis is applied to account for non-response and/or to account for missing data.

The below table displays one value for each field (i.e., column). Sometimes, reports for a given facility will be provided to more than one reporting source: HHS TeleTracking, NHSN, and HHS Protect. When this occurs, to ensure that there are not duplicate reports, prioritization is applied to the numbers for each facility.

On June 26, 2023 the field "reporting_cutoff_start" was replaced by the field "date".

On April 27, 2022 the following pediatric fields were added:

<li>all_pediatric_inpatient_bed_occupied<li>all_pediatric_inpatient_bed_occupied_coverage<li>all_pediatric_inpatient_beds<li>all_pediatric_inpatient_beds_coverage<li>previous_day_admission_pediatric_covid_confirmed_0_4<li>previous_day_admission_pediatric_covid_confirmed_0_4_coverage<li>previous_day_admission_pediatric_covid_confirmed_12_17<li>previous_day_admission_pediatric_covid_confirmed_12_17_coverage<li> previous_day_admission_pediatric_covid_confirmed_5_11<li>previous_day_admission_pediatric_covid_confirmed_5_11_coverage<li>previous_day_admission_pediatric_covid_confirmed_unknown<li>previous_day_admission_pediatric_covid_confirmed_unknown_coverage<li>staffed_icu_pediatric_patients_confirmed_covid<li>staffed_icu_pediatric_patients_confirmed_covid_coverage<li>staffed_pediatric_icu_bed_occupancy<li>staffed_pediatric_icu_bed_occupancy_coverage<li>total_staffed_pediatric_icu_beds<li>total_staffed_pediatric_icu_beds_coverage

On January 19, 2022, the following fields have been added to this dataset:

<li>inpatient_beds_used_covid<li>inpatient_beds_used_covid_coverage

On September 17, 2021, this data set has had the following fields added:

<li>icu_patients_confirmed_influenza,<li>icu_patients_confirmed_influenza_coverage,<li>previous_day_admission_influenza_confirmed,<li>previous_day_admission_influenza_confirmed_coverage,<li>previous_day_deaths_covid_and_influenza,<li>previous_day_deaths_covid_and_influenza_coverage,<li>previous_day_deaths_influenza,<li>previous_day_deaths_influenza_coverage,<li>total_patients_hospitalized_confirmed_influenza,<li>total_patients_hospitalized_confirmed_influenza_and_covid,<li>total_patients_hospitalized_confirmed_influenza_and_covid_coverage,<li>total_patients_hospitalized_confirmed_influenza_coverage

On September 13, 2021, this data set has had the following fields added:

<li>on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses,<li>on_hand_supply_therapeutic_b_bamlanivimab_courses,<li>on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses,<li>previous_week_therapeutic_a_casirivimab_imdevimab_courses_used,<li>previous_week_therapeutic_b_bamlanivimab_courses_used,<li>previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used

On June 30, 2021, this data set has had the following fields added:

<li>deaths_covid<li>deaths_covid_coverage

On April 30, 2021, this data set has had the following fields added:

<li>previous_day_admission_adult_covid_confirmed_18-19<li>previous_day_admission_adult_covid_confirmed_18-19_coverage<li>previous_day_admission_adult_covid_confirmed_20-29_coverage<li>previous_day_admission_adult_covi

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"healthdata-gov/covid19-reported-patient-impact-and-hospital-6xf2-c3ie\".\"covid19_reported_patient_impact_and_hospital\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.