economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
36 rows where cadence = "weekly" and covid_deaths = 103 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, end_date, year, population, total_deaths, expected_deaths, excess_deaths, excess_deaths_per_100k, start_date (date)
country 10
- United States 16
- Guatemala 4
- Austria 2
- Czech Republic 2
- France 2
- Germany 2
- Hungary 2
- Israel 2
- Lithuania 2
- Peru 2
cadence 1
- weekly · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16225 | 16225 | Peru | Peru | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 34049588 | 2854.6 | 103 | 3336.85948717868 | -482.259487178681 | 2751.6 | 0.302499989133496 | -1.41634455952501 | -0.144524960979532 | weekly | |||||||||
24853 | 24853 | Peru | Peru | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 34049588 | 2854.6 | 103 | 3336.85948717868 | -482.259487178681 | 2751.6 | 0.302499989133496 | -1.41634455952501 | -0.144524960979532 | weekly | |||||||||
3938 | 3938 | United States | Georgia | GA | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 10617423 | 1829 | 103 | 1604.3934837098 | 224.606516290204 | 1726 | 0.970103574097029 | 2.11545227396708 | 0.139994657526813 | weekly | |||||||||
5759 | 5759 | United States | Michigan | MI | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 9986857 | 1925 | 103 | 1792.39598997565 | 132.604010024351 | 1822 | 1.03135551054751 | 1.32778520834284 | 0.0739814252910445 | weekly | |||||||||
1949 | 1949 | Guatemala | Guatemala | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 17843914 | 1742 | 103 | 1701.15589887642 | 40.8441011235809 | 1639 | 0.577227619456135 | 0.228896536508643 | 0.0240096167262258 | weekly | |||||||||
14003 | 14003 | Guatemala | Guatemala | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 17843914 | 1742 | 103 | 1701.15589887642 | 40.8441011235809 | 1639 | 0.577227619456135 | 0.228896536508643 | 0.0240096167262251 | weekly | |||||||||
1945 | 1945 | Guatemala | Guatemala | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 17843914 | 1790 | 103 | 1697.35589887642 | 92.6441011235811 | 1687 | 0.577227619456135 | 0.519191591730273 | 0.0545814234863222 | weekly | |||||||||
13999 | 13999 | Guatemala | Guatemala | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 17843914 | 1790 | 103 | 1697.35589887642 | 92.6441011235811 | 1687 | 0.577227619456135 | 0.519191591730273 | 0.0545814234863216 | weekly | |||||||||
8942 | 8942 | United States | Texas | TX | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 28995881 | 4366 | 103 | 3844.90225563973 | 521.097744360274 | 4263 | 0.35522286768938 | 1.79714403007887 | 0.135529516672608 | weekly | |||||||||
7115 | 7115 | United States | New Mexico | NM | 2022-05-22 | 2022-05-28 | 7 | 2022 | 21 | 2096829 | 417 | 103 | 347.616541354256 | 69.3834586457442 | 314 | 4.91217929549811 | 3.30897076708421 | 0.199597689958705 | weekly | |||||||||
10369 | 10369 | Hungary | Hungary | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 9967304 | 2238 | 103 | 2219.63286516853 | 18.3671348314697 | 2135 | 1.03337873511232 | 0.184273850094967 | 0.00827485262076211 | weekly | |||||||||
14128 | 14128 | Hungary | Hungary | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 9967304 | 2238 | 103 | 2219.63286516853 | 18.3671348314697 | 2135 | 1.03337873511232 | 0.184273850094967 | 0.00827485262076233 | weekly | |||||||||
3158 | 3158 | United States | Colorado | CO | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 5758736 | 861 | 103 | 825.621553885694 | 35.3784461143056 | 758 | 1.78858693991181 | 0.614343948295348 | 0.0428506813415916 | weekly | |||||||||
2395 | 2395 | United States | Alabama | AL | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 4903185 | 1043 | 103 | 1039.0501252959 | 3.94987470410297 | 940 | 2.10067537733127 | 0.0805573255772109 | 0.00380142844694631 | weekly | |||||||||
15009 | 15009 | Lithuania | Lithuania | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 2750058 | 887 | 103 | 711.435112359564 | 175.564887640436 | 784 | 3.74537555207927 | 6.38404308710711 | 0.246775685639345 | weekly | |||||||||
18424 | 18424 | Lithuania | Lithuania | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 2750058 | 887 | 103 | 711.435112359564 | 175.564887640436 | 784 | 3.74537555207927 | 6.38404308710711 | 0.246775685639345 | weekly | |||||||||
9683 | 9683 | United States | West Virginia | WV | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1792147 | 668 | 103 | 480.71052631678 | 187.28947368322 | 565 | 5.74729639923511 | 10.4505642496525 | 0.389609678652635 | weekly | |||||||||
11428 | 11428 | Austria | Austria | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 8939617 | 1766 | 103 | 1765.89007490633 | 0.109925093669517 | 1663 | 1.15217464014398 | 0.00122963985671329 | 6.22491146147208e-05 | weekly | |||||||||
21078 | 21078 | Austria | Austria | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 8939617 | 1766 | 103 | 1765.89007490633 | 0.109925093669517 | 1663 | 1.15217464014398 | 0.00122963985671329 | 6.22491146144988e-05 | weekly | |||||||||
8459 | 8459 | United States | South Carolina | SC | 2021-12-05 | 2021-12-11 | 7 | 2021 | 49 | 5148714 | 1213 | 103 | 1026.5401002516 | 186.459899748402 | 1110 | 2.00049954221578 | 3.62148489406096 | 0.181639177761007 | weekly | |||||||||
7988 | 7988 | United States | Oregon | OR | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 4217737 | 983 | 103 | 667.082706767833 | 315.917293232167 | 880 | 2.44206786719988 | 7.4902084514081 | 0.473580397193711 | weekly | |||||||||
13653 | 13653 | Germany | Germany | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 83369840 | 17501 | 103 | 16792.1123595502 | 708.887640449775 | 17398 | 0.123545877022194 | 0.850292672325837 | 0.042215513168993 | weekly | |||||||||
23396 | 23396 | Germany | Germany | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 83369840 | 17501 | 103 | 16792.1123595502 | 708.887640449775 | 17398 | 0.123545877022194 | 0.850292672325838 | 0.0422155131689914 | weekly | |||||||||
4338 | 4338 | United States | Illinois | IL | 2021-08-08 | 2021-08-14 | 7 | 2021 | 32 | 12671821 | 2176 | 103 | 1850.3859649128 | 325.614035087202 | 2073 | 0.812827138262133 | 2.56959149823219 | 0.175970873786079 | weekly | |||||||||
5384 | 5384 | United States | Maryland | MD | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 6045680 | 1159 | 103 | 998.494987469543 | 160.505012530457 | 1056 | 1.70369586216935 | 2.65487112335514 | 0.160746938687414 | weekly | |||||||||
5831 | 5831 | United States | Minnesota | MN | 2021-01-31 | 2021-02-06 | 7 | 2021 | 5 | 5639632 | 983 | 103 | 952.674812030854 | 30.3251879691463 | 880 | 1.82636030152322 | 0.537715722748334 | 0.0318316256357203 | weekly | |||||||||
14491 | 14491 | Israel | Israel | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 9449000 | 907 | 103 | 853.481741572992 | 53.518258427008 | 804 | 1.09006244046989 | 0.566390712530511 | 0.0627058035575223 | weekly | |||||||||
20660 | 20660 | Israel | Israel | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 9449000 | 907 | 103 | 853.481741572992 | 53.518258427008 | 804 | 1.09006244046989 | 0.566390712530512 | 0.0627058035575223 | weekly | |||||||||
4600 | 4600 | United States | Iowa | IA | 2020-10-18 | 2020-10-24 | 7 | 2020 | 43 | 3155070 | 750 | 103 | 597.731829574608 | 152.268170425392 | 647 | 3.26458683959468 | 4.82614238116402 | 0.254743286021354 | weekly | |||||||||
10068 | 10068 | Czech Republic | Czech Republic | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 10493990 | 2392 | 103 | 2047.58061797751 | 344.419382022489 | 2289 | 0.981514180974062 | 3.28206318113976 | 0.16820797139733 | weekly | |||||||||
12701 | 12701 | Czech Republic | Czech Republic | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 10493990 | 2392 | 103 | 2047.58061797751 | 344.419382022489 | 2289 | 0.981514180974062 | 3.28206318113977 | 0.168207971397331 | weekly | |||||||||
2772 | 2772 | United States | Arkansas | AR | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 3017825 | 746 | 103 | 595.621553886035 | 150.378446113965 | 643 | 3.41305410353483 | 4.98300750089766 | 0.252473143614171 | weekly | |||||||||
2618 | 2618 | United States | Arizona | AZ | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 7278717 | 1282 | 103 | 1104.36591479505 | 177.634085204951 | 1179 | 1.41508455404984 | 2.44045874025534 | 0.160847127591689 | weekly | |||||||||
13451 | 13451 | France | France | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 67813000 | 10490 | 103 | 10488.9581460671 | 1.04185393289299 | 10387 | 0.151888281008066 | 0.00153636313522922 | 9.93286385921888e-05 | weekly | |||||||||
19990 | 19990 | France | France | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 67813000 | 10490 | 103 | 10488.9581460671 | 1.04185393289299 | 10387 | 0.151888281008066 | 0.00153636313522922 | 9.93286385915226e-05 | weekly | |||||||||
7624 | 7624 | United States | Ohio | OH | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 11689100 | 2529 | 103 | 2218.48370927517 | 310.516290724826 | 2426 | 0.881162792687204 | 2.65646021271805 | 0.139967802975789 | 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);