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/

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 \"cdc-gov/ah-provisional-covid19-deaths-by-hospital-referral-mqmc-4b9n\".\"ah_provisional_covid19_deaths_by_hospital_referral\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.