economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
15 rows where country = "United States" and covid_deaths = 93 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, year, population, covid_deaths_per_100k, start_date (date), end_date (date)
Link | rowid | country | region | region_code | start_date | end_date ▲ | days | year | week | population | total_deaths | covid_deaths | expected_deaths | excess_deaths | non_covid_deaths | covid_deaths_per_100k | excess_deaths_per_100k | excess_deaths_pct_change | cadence | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3942 | 3942 | United States | Georgia | GA | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 10617423 | 1888 | 93 | 1669.39348370984 | 218.606516290158 | 1795 | 0.8759187610779 | 2.05894138615517 | 0.130949664308234 | weekly | |||||||||
8803 | 8803 | United States | Tennessee | TN | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 6833174 | 1612 | 93 | 1463.72180451225 | 148.278195487754 | 1519 | 1.36100734446393 | 2.16997540949132 | 0.101302170283079 | weekly | |||||||||
7122 | 7122 | United States | New Mexico | NM | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 2096829 | 377 | 93 | 368.283208020879 | 8.7167919791205 | 284 | 4.4352686842847 | 0.415713059058249 | 0.0236687195866565 | weekly | |||||||||
3012 | 3012 | United States | California | CA | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 39512223 | 5582 | 93 | 4944.09523809546 | 637.904761904541 | 5489 | 0.235370204303615 | 1.61444918425506 | 0.129023558646146 | weekly | |||||||||
3768 | 3768 | United States | Florida | FL | 2022-05-01 | 2022-05-07 | 7 | 2022 | 18 | 21477737 | 4353 | 93 | 4104.14786967508 | 248.852130324917 | 4260 | 0.433006512743871 | 1.1586515391492 | 0.0606342993057456 | weekly | |||||||||
9690 | 9690 | United States | West Virginia | WV | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 1792147 | 516 | 93 | 481.050125314255 | 34.949874685745 | 423 | 5.1893064575618 | 1.95016785373884 | 0.0726532908871262 | weekly | |||||||||
9681 | 9681 | United States | West Virginia | WV | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1792147 | 639 | 93 | 521.460526316777 | 117.539473683223 | 546 | 5.1893064575618 | 6.55858440648135 | 0.225404355174184 | weekly | |||||||||
5864 | 5864 | United States | Minnesota | MN | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 5639632 | 988 | 93 | 872.576441103532 | 115.423558896468 | 895 | 1.64904376739475 | 2.04665054202949 | 0.132279022741542 | weekly | |||||||||
2666 | 2666 | United States | Arizona | AZ | 2021-08-08 | 2021-08-14 | 7 | 2021 | 32 | 7278717 | 1472 | 93 | 1135.21553885746 | 336.784461142542 | 1379 | 1.27769770414209 | 4.62697562142534 | 0.296670059221969 | weekly | |||||||||
6617 | 6617 | United States | Nevada | NV | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3080156 | 662 | 93 | 503.115288221364 | 158.884711778636 | 569 | 3.01932759249856 | 5.15833327203673 | 0.31580179632452 | weekly | |||||||||
8426 | 8426 | United States | South Carolina | SC | 2021-04-18 | 2021-04-24 | 7 | 2021 | 16 | 5148714 | 1067 | 93 | 958.873433584928 | 108.126566415072 | 974 | 1.80627628568998 | 2.10006938460889 | 0.112764169522166 | weekly | |||||||||
5969 | 5969 | United States | Mississippi | MS | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 2976149 | 716 | 93 | 591.290726817784 | 124.709273182216 | 623 | 3.12484354781968 | 4.19028997480355 | 0.21091024689898 | weekly | |||||||||
9455 | 9455 | United States | Washington | WA | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 7614893 | 1199 | 93 | 1012.45614035171 | 186.543859648288 | 1106 | 1.22129096232869 | 2.44972397705769 | 0.184248830357713 | weekly | |||||||||
7321 | 7321 | United States | North Carolina | NC | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 10488084 | 1979 | 93 | 1712.03759398554 | 266.962406014458 | 1886 | 0.886720586906054 | 2.54538775637626 | 0.155932560682258 | weekly | |||||||||
5040 | 5040 | United States | Louisiana | LA | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 4648794 | 985 | 93 | 826.61654135431 | 158.38345864569 | 892 | 2.00051884424218 | 3.40697950147264 | 0.19160451155042 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_deaths] ( [country] TEXT, [region] TEXT, [region_code] INTEGER, [start_date] TEXT, [end_date] TEXT, [days] INTEGER, [year] INTEGER, [week] INTEGER, [population] INTEGER, [total_deaths] INTEGER, [covid_deaths] INTEGER, [expected_deaths] FLOAT, [excess_deaths] FLOAT, [non_covid_deaths] INTEGER, [covid_deaths_per_100k] FLOAT, [excess_deaths_per_100k] FLOAT, [excess_deaths_pct_change] FLOAT, [cadence] TEXT , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);