About this Dataset

AH Provisional COVID-19 Deaths By Hospital Referral Region

Provisional count of deaths involving coronavirus disease 2019 (COVID-19) in the United States by week of death and by hospital referral region (HRR). HRR is determined by county of occurrence. Weekly weighted counts of deaths from all causes and due to COVID-19 are provided by HRR overall and for decedents 65 years and older. The weighted counts by HRRs are based on published methods for aggregating county-level data to HRRs. More detail about aggregating to HRRs from counties can be found in the following: https://github.com/Dartmouth-DAC/covid-19-hrr-mapping
https://dartmouthatlas.org/covid-19/hrr-mapping/
Organization: U.S. Department of Health & Human Services
Last updated: 2021-03-16T19:47:08.078818
Tags: all-causes, coronavirus, covid-19, deaths, hospital-referral-region, mortality, nchs, nvss, provisional, united-states, weekly

Tables

Table 1

@usgov.hhs_gov_ah_provisional_covid_19_deaths_by_hospital_ref_08aa896f.table_1

5.61 MB
138,618 rows
21 columns

CREATE TABLE table_1 (
  "data_as_of" TIMESTAMP,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "mmwr_year" BIGINT,
  "mmwr_week" BIGINT,
  "week_ending_date" TIMESTAMP,
  "hrr_name" VARCHAR,
  "hrr_number" BIGINT,
  "state" VARCHAR,
  "total_deaths" DOUBLE,
  "covid_19_deaths" DOUBLE,
  "total_deaths_over_65_years" DOUBLE,
  "covid_19_deaths_over_65_years" DOUBLE,
  "total_deaths_65_to_74_years" DOUBLE,
  "covid_19_deaths_65_to_74_years" DOUBLE,
  "total_deaths_75_to_84_years" DOUBLE,
  "covid_19_deaths_75_to_84_years" DOUBLE,
  "total_deaths_over_85_years" DOUBLE,
  "covid_19_deaths_over_85_years" DOUBLE,
  "footnote" VARCHAR,
  "accuracy_index" DOUBLE
);