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 = 112 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, year, week, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417 | 2417 | United States | Alabama | AL | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 4903185 | 1091 | 112 | 972.050125298636 | 118.949874701364 | 979 | 2.28422953651555 | 2.42597158176499 | 0.122370103768897 | weekly | |||||||||
3931 | 3931 | United States | Georgia | GA | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 10617423 | 1866 | 112 | 1645.72681704316 | 220.273182956838 | 1754 | 1.05486990581425 | 2.07463885499182 | 0.133845532974056 | weekly | |||||||||
8035 | 8035 | United States | Oregon | OR | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 4217737 | 772 | 112 | 679.110275690171 | 92.8897243098286 | 660 | 2.65545243812025 | 2.20235932941833 | 0.136781503144575 | weekly | |||||||||
3015 | 3015 | United States | California | CA | 2022-06-19 | 2022-06-25 | 7 | 2022 | 25 | 39512223 | 5607 | 112 | 4972.09523809547 | 634.90476190453 | 5495 | 0.283456590129085 | 1.60685659701943 | 0.127693604305883 | weekly | |||||||||
9391 | 9391 | United States | Virginia | VA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 8535519 | 1441 | 112 | 1346.48370927384 | 94.5162907261565 | 1329 | 1.31216391176682 | 1.10732915861539 | 0.0701949010412677 | weekly | |||||||||
8019 | 8019 | United States | Oregon | OR | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 4217737 | 756 | 112 | 741.110275690188 | 14.8897243098116 | 644 | 2.65545243812025 | 0.353026381441319 | 0.020091104924898 | weekly | |||||||||
2850 | 2850 | United States | Arkansas | AR | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 3017825 | 715 | 112 | 642.243107771173 | 72.7568922288269 | 603 | 3.71128213199904 | 2.41090494739844 | 0.113285594424393 | weekly | |||||||||
7397 | 7397 | United States | North Carolina | NC | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 10488084 | 2419 | 112 | 1999.05639097807 | 419.943609021933 | 2307 | 1.06787855627396 | 4.00400691891801 | 0.210070916917191 | weekly | |||||||||
5867 | 5867 | United States | Minnesota | MN | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 5639632 | 1020 | 112 | 901.909774436867 | 118.090225563133 | 908 | 1.98594518223884 | 2.09393495113037 | 0.130933524516757 | weekly | |||||||||
2966 | 2966 | United States | California | CA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 39512223 | 5297 | 112 | 4845.57142857185 | 451.428571428151 | 5185 | 0.283456590129085 | 1.14250360307025 | 0.0931631239127564 | weekly | |||||||||
2776 | 2776 | United States | Arkansas | AR | 2020-10-18 | 2020-10-24 | 7 | 2020 | 43 | 3017825 | 794 | 112 | 633.954887219384 | 160.045112780616 | 682 | 3.71128213199904 | 5.30332649443279 | 0.252455050047168 | weekly | |||||||||
4446 | 4446 | United States | Indiana | IN | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 6732219 | 1442 | 112 | 1207.7944862169 | 234.205513783098 | 1330 | 1.66364166109272 | 3.47887544631418 | 0.193911726254592 | weekly | |||||||||
2769 | 2769 | United States | Arkansas | AR | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3017825 | 713 | 112 | 569.621553886014 | 143.378446113986 | 601 | 3.71128213199904 | 4.75105236764843 | 0.25170825284936 | weekly | |||||||||
7317 | 7317 | United States | North Carolina | NC | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 10488084 | 1878 | 112 | 1798.37092731893 | 79.6290726810748 | 1766 | 1.06787855627396 | 0.759233742608038 | 0.0442784474945825 | weekly | |||||||||
7316 | 7316 | United States | North Carolina | NC | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 10488084 | 1967 | 112 | 1820.03759398557 | 146.962406014425 | 1855 | 1.06787855627396 | 1.40123216036814 | 0.0807469068221842 | 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);