economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
26 rows where covid_deaths = 152 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, days, year, week, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, month, total_deaths_per_7_days, covid_deaths_per_7_days, expected_deaths_per_7_days, excess_deaths_per_7_days, covid_deaths_per_100k_per_7_days, excess_deaths_per_100k_per_7_days, end_date (date)
country 8
- United States 13
- Armenia 2
- Belarus 2
- Italy 2
- Lithuania 2
- Mexico 2
- Paraguay 2
- South Africa 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5767 | 5767 | United States | Michigan | MI | 2022-10-09 | 2022-10-15 | 7 | 2022 | 41 | 9986857 | 2130 | 152 | 1821.72932330899 | 308.270676691011 | 1978 | 1.52200036507982 | 3.0867637004416 | 0.169218704857354 | weekly | |||||||||
10554 | 10554 | Mexico | Mexico | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 127504120 | 13984 | 152 | 14730.2882022464 | -746.288202246442 | 13832 | 0.119211834096028 | -0.5853051668028 | -0.0506635166943054 | weekly | |||||||||
15462 | 15462 | Mexico | Mexico | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 127504120 | 13984 | 152 | 14730.2882022464 | -746.288202246442 | 13832 | 0.119211834096028 | -0.5853051668028 | -0.0506635166943027 | weekly | |||||||||
19711 | 19711 | Armenia | Armenia | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 2780472 | 2679 | 152 | 2221.69990421456 | 457.300095785441 | 2527 | 5.46669774052751 | 16.4468513182453 | 0.205833422829944 | monthly | 3 | 604.935483870968 | 34.3225806451613 | 501.674171919417 | 103.261311951551 | 570.612903225806 | 1.23441561882879 | 3.71380513637797 | ||
21423 | 21423 | Armenia | Armenia | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 2780472 | 2679 | 152 | 2221.69990421456 | 457.300095785441 | 2527 | 5.46669774052751 | 16.4468513182453 | 0.205833422829943 | monthly | 3 | 604.935483870968 | 34.3225806451613 | 501.674171919417 | 103.261311951551 | 570.612903225806 | 1.23441561882879 | 3.71380513637797 | ||
9376 | 9376 | United States | Virginia | VA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 8535519 | 2185 | 152 | 1536.88157894803 | 648.118421051972 | 2033 | 1.78079388025497 | 7.59319288085436 | 0.421710058816372 | weekly | |||||||||
3750 | 3750 | United States | Florida | FL | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 21477737 | 4869 | 152 | 4332.69423558992 | 536.305764410075 | 4717 | 0.707709569215788 | 2.49703106249078 | 0.123781124457091 | weekly | |||||||||
22642 | 22642 | Paraguay | Paraguay | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 6780745 | 3381 | 152 | 2866.91340023108 | 514.086599768919 | 3229 | 2.24164158953035 | 7.58156514909378 | 0.179317101007475 | monthly | 12 | 763.451612903226 | 34.3225806451613 | 647.367541987663 | 116.084070915562 | 729.129032258065 | 0.506177133119757 | 1.71196632398892 | ||
23658 | 23658 | Paraguay | Paraguay | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 6780745 | 3381 | 152 | 2866.91340023108 | 514.086599768919 | 3229 | 2.24164158953035 | 7.58156514909378 | 0.179317101007475 | monthly | 12 | 763.451612903226 | 34.3225806451613 | 647.367541987663 | 116.084070915562 | 729.129032258065 | 0.506177133119757 | 1.71196632398892 | ||
14993 | 14993 | Lithuania | Lithuania | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 2750058 | 964 | 152 | 675.428089887664 | 288.571910112336 | 812 | 5.52715615452474 | 10.4933026907918 | 0.427242980315389 | weekly | |||||||||
18408 | 18408 | Lithuania | Lithuania | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 2750058 | 964 | 152 | 675.428089887664 | 288.571910112336 | 812 | 5.52715615452474 | 10.4933026907918 | 0.427242980315388 | weekly | |||||||||
19417 | 19417 | South Africa | South Africa | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 59893884 | 10984 | 152 | 9708.627118644 | 1275.372881356 | 10832 | 0.253782172483588 | 2.12938750366565 | 0.131364905230198 | weekly | |||||||||
4196 | 4196 | United States | Idaho | ID | 2021-10-17 | 2021-10-23 | 7 | 2021 | 42 | 1787065 | 469 | 152 | 290.130325815289 | 178.869674184711 | 317 | 8.50556638958292 | 10.0091308477706 | 0.616514918535568 | weekly | |||||||||
5709 | 5709 | United States | Michigan | MI | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 9986857 | 2093 | 152 | 1785.46365914863 | 307.536340851367 | 1941 | 1.52200036507982 | 3.07941067796773 | 0.172244525546944 | weekly | |||||||||
10907 | 10907 | Italy | Italy | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 59037472 | 12646 | 152 | 11630.4494382024 | 1015.55056179764 | 12494 | 0.257463598712357 | 1.72017962049195 | 0.0873182560307495 | weekly | |||||||||
14680 | 14680 | Italy | Italy | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 59037472 | 12646 | 152 | 11630.4494382024 | 1015.55056179764 | 12494 | 0.257463598712357 | 1.72017962049195 | 0.0873182560307457 | weekly | |||||||||
7671 | 7671 | United States | Ohio | OH | 2021-05-23 | 2021-05-29 | 7 | 2021 | 21 | 11689100 | 2437 | 152 | 2204.72556391201 | 232.274436087991 | 2285 | 1.30035674260636 | 1.9871028230402 | 0.105352992630906 | weekly | |||||||||
8420 | 8420 | United States | South Carolina | SC | 2021-03-07 | 2021-03-13 | 7 | 2021 | 10 | 5148714 | 1169 | 152 | 1031.87343358491 | 137.126566415085 | 1017 | 2.95219349919223 | 2.66331682853398 | 0.132890877846019 | weekly | |||||||||
7810 | 7810 | United States | Oklahoma | OK | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3956971 | 924 | 152 | 829.665413534606 | 94.3345864653936 | 772 | 3.84132206174875 | 2.38401005378593 | 0.113701963377625 | weekly | |||||||||
2627 | 2627 | United States | Arizona | AZ | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 7278717 | 1252 | 152 | 1194.36591479501 | 57.6340852049925 | 1100 | 2.08828011859782 | 0.791816541362887 | 0.0482549648236441 | weekly | |||||||||
5513 | 5513 | United States | Massachusetts | MA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 6949503 | 1089 | 152 | 1133.125313284 | -44.1253132840009 | 937 | 2.18720676859914 | -0.634941999219237 | -0.0389412475096137 | weekly | |||||||||
21554 | 21554 | Belarus | Belarus | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 9534956 | 10659 | 152 | 9116.40532778926 | 1542.59467221074 | 10507 | 1.59413425714812 | 16.1783092885876 | 0.169210847559454 | monthly | 9 | 2487.1 | 35.4666666666667 | 2127.16124315083 | 359.938756849173 | 2451.63333333333 | 0.371964660001228 | 3.77493883400377 | ||
24371 | 24371 | Belarus | Belarus | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 9534956 | 10659 | 152 | 9116.40532778926 | 1542.59467221074 | 10507 | 1.59413425714812 | 16.1783092885876 | 0.169210847559454 | monthly | 9 | 2487.1 | 35.4666666666667 | 2127.16124315083 | 359.938756849173 | 2451.63333333333 | 0.371964660001228 | 3.77493883400377 | ||
8696 | 8696 | United States | Tennessee | TN | 2020-08-23 | 2020-08-29 | 7 | 2020 | 35 | 6833174 | 1709 | 152 | 1384.69423558983 | 324.305764410169 | 1557 | 2.22444211138191 | 4.7460486797229 | 0.234207492220855 | weekly | |||||||||
7631 | 7631 | United States | Ohio | OH | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 11689100 | 2592 | 152 | 2183.15037594183 | 408.849624058169 | 2440 | 1.30035674260636 | 3.49769977207971 | 0.18727506293825 | weekly | |||||||||
8086 | 8086 | United States | Pennsylvania | PA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 12801989 | 2661 | 152 | 2352.95238095347 | 308.047619046528 | 2509 | 1.18731550230203 | 2.40624811540244 | 0.130919614667977 | 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);