economist_excess_deaths

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

320 rows where cadence = "monthly"

View and edit SQL

Suggested facets: start_date, end_date, month, covid_deaths, covid_deaths_per_100k, start_date (date), end_date (date)

country

cadence

  • monthly · 320
Link rowid ▼ country region region_code start_date end_date year month 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 week
1 Brazil Fortaleza 2304400 2020-01-01 2020-01-31 2020 1 2669342 1569 0 1400.75 168.25 1569 0.0 6.30305146361912 0.120114224522577 monthly  
2 Brazil Fortaleza 2304400 2020-02-01 2020-02-29 2020 2 2669342 1473 0 1347.25 125.75 1473 0.0 4.71089879078814 0.0933382816849138 monthly  
3 Brazil Fortaleza 2304400 2020-03-01 2020-03-31 2020 3 2669342 1693 22 1550.0 143.0 1671 0.824173148288979 5.35712546387836 0.0922580645161291 monthly  
4 Brazil Fortaleza 2304400 2020-04-01 2020-04-30 2020 4 2669342 2187 629 1593.5 593.5 1558 23.5638595578985 22.2339437958868 0.372450580483213 monthly  
5 Brazil Manaus 1302603 2020-01-01 2020-01-31 2020 1 2182763 1121 0 933.0 188.0 1121 0.0 8.61293690611395 0.201500535905681 monthly  
6 Brazil Manaus 1302603 2020-02-01 2020-02-29 2020 2 2182763 975 0 875.75 99.25 975 0.0 4.54698929750962 0.113331430202683 monthly  
7 Brazil Manaus 1302603 2020-03-01 2020-03-31 2020 3 2182763 1047 1 923.0 124.0 1046 0.0458134941814572 5.68087327850069 0.134344528710726 monthly  
8 Brazil Manaus 1302603 2020-04-01 2020-04-30 2020 4 2182763 2656 410 950.5 1705.5 2246 18.7835326143974 78.1349143264752 1.79431877958969 monthly  
9 Brazil Recife 2611606 2020-01-01 2020-01-31 2020 1 1645727 1330 0 1086.75 243.25 1330 0.0 14.7807017810366 0.223832528180354 monthly  
10 Brazil Recife 2611606 2020-02-01 2020-02-29 2020 2 1645727 1242 0 1030.75 211.25 1242 0.0 12.8362723586597 0.20494785350473 monthly  
11 Brazil Recife 2611606 2020-03-01 2020-03-31 2020 3 1645727 1384 6 1158.25 225.75 1378 0.364580516695661 13.7173419406742 0.194906108353119 monthly  
12 Brazil Recife 2611606 2020-04-01 2020-04-30 2020 4 1645727 1787 216 1042.0 745.0 1571 13.1248986010438 45.2687474897112 0.714971209213052 monthly  
13 Brazil Rio de Janeiro 3304557 2020-01-01 2020-01-31 2020 1 6718903 4731 0 4824.75 -93.75 4731 0.0 -1.39531706291935 -0.0194310586040728 monthly  
14 Brazil Rio de Janeiro 3304557 2020-02-01 2020-02-29 2020 2 6718903 4489 0 4253.75 235.25 4489 0.0 3.50131561655229 0.0553041434028798 monthly  
15 Brazil Rio de Janeiro 3304557 2020-03-01 2020-03-31 2020 3 6718903 4872 43 4617.75 254.25 4829 0.639985426192341 3.78409987463727 0.0550592821179146 monthly  
16 Brazil Rio de Janeiro 3304557 2020-04-01 2020-04-30 2020 4 6718903 6929 1655 4825.5 2103.5 5274 24.6319972174029 31.3071940464091 0.43591337685214 monthly  
17 Brazil São Paulo 3550308 2020-01-01 2020-01-31 2020 1 12252023 8121 0 6531.75 1589.25 8121 0.0 12.9713272657095 0.243311516821679 monthly  
18 Brazil São Paulo 3550308 2020-02-01 2020-02-29 2020 2 12252023 6076 0 5792.75 283.25 6076 0.0 2.31186311027983 0.0488973285572483 monthly  
19 Brazil São Paulo 3550308 2020-03-01 2020-03-31 2020 3 12252023 7639 307 6381.5 1257.5 7332 2.50570864909411 10.2636111603774 0.197053984173 monthly  
20 Brazil São Paulo 3550308 2020-04-01 2020-04-30 2020 4 12252023 9323 1738 6430.0 2893.0 7585 14.1854124824937 23.6124271069357 0.449922239502333 monthly  
21 Ecuador Ecuador EC 2020-01-01 2020-01-31 2020 1 17226800 6669 0 6622.5 46.5 6669 0.0 0.269928251329324 0.00702151755379399 monthly  
22 Ecuador Ecuador EC 2020-02-01 2020-02-29 2020 2 17226800 5993 0 5773.5 219.5 5993 0.0 1.27417744444702 0.038018532952282 monthly  
23 Ecuador Ecuador EC 2020-03-01 2020-03-31 2020 3 17226800 8985 79 6240.0 2745.0 8906 0.458587781828314 15.9344741913762 0.439903846153846 monthly  
24 Ecuador Ecuador EC 2020-04-01 2020-04-30 2020 4 17226800 18496 821 5881.5 12614.5 17675 4.76582998583602 73.2260199224464 2.14477599251892 monthly  
25 Ecuador Ecuador EC 2020-05-01 2020-05-31 2020 5 17226800 8252 2458 5851.5 2400.5 5794 14.2684654143544 13.9346831680869 0.410236691446638 monthly  
26 Ecuador Azuay EC-A 2020-01-01 2020-01-31 2020 1 867200 360 0 355.5 4.5 360 0.0 0.518911439114391 0.0126582278481013 monthly  
27 Ecuador Azuay EC-A 2020-02-01 2020-02-29 2020 2 867200 319 0 306.5 12.5 319 0.0 1.44142066420664 0.0407830342577489 monthly  
28 Ecuador Azuay EC-A 2020-03-01 2020-03-31 2020 3 867200 306 0 328.0 -22.0 306 0.0 -2.53690036900369 -0.0670731707317073 monthly  
29 Ecuador Azuay EC-A 2020-04-01 2020-04-30 2020 4 867200 327 0 325.5 1.5 327 0.0 0.172970479704797 0.00460829493087567 monthly  
30 Ecuador Azuay EC-A 2020-05-01 2020-05-31 2020 5 867200 304 0 332.5 -28.5 304 0.0 -3.28643911439114 -0.0857142857142857 monthly  
31 Ecuador Bolívar EC-B 2020-01-01 2020-01-31 2020 1 208400 63 0 81.5 -18.5 63 0.0 -8.87715930902111 -0.226993865030675 monthly  
32 Ecuador Bolívar EC-B 2020-02-01 2020-02-29 2020 2 208400 84 0 74.5 9.5 84 0.0 4.55854126679463 0.12751677852349 monthly  
33 Ecuador Bolívar EC-B 2020-03-01 2020-03-31 2020 3 208400 49 0 77.5 -28.5 49 0.0 -13.6756238003839 -0.367741935483871 monthly  
34 Ecuador Bolívar EC-B 2020-04-01 2020-04-30 2020 4 208400 102 0 64.5 37.5 102 0.0 17.9942418426104 0.581395348837209 monthly  
35 Ecuador Bolívar EC-B 2020-05-01 2020-05-31 2020 5 208400 72 0 65.5 6.5 72 0.0 3.1190019193858 0.0992366412213741 monthly  
36 Ecuador Carchi EC-C 2020-01-01 2020-01-31 2020 1 185500 56 0 54.5 1.5 56 0.0 0.808625336927224 0.0275229357798166 monthly  
37 Ecuador Carchi EC-C 2020-02-01 2020-02-29 2020 2 185500 57 0 59.0 -2.0 57 0.0 -1.07816711590296 -0.0338983050847458 monthly  
38 Ecuador Carchi EC-C 2020-03-01 2020-03-31 2020 3 185500 51 0 54.5 -3.5 51 0.0 -1.88679245283019 -0.0642201834862385 monthly  
39 Ecuador Carchi EC-C 2020-04-01 2020-04-30 2020 4 185500 49 0 50.0 -1.0 49 0.0 -0.539083557951482 -0.02 monthly  
40 Ecuador Carchi EC-C 2020-05-01 2020-05-31 2020 5 185500 57 0 59.0 -2.0 57 0.0 -1.07816711590296 -0.0338983050847458 monthly  
41 Ecuador Orellana EC-D 2020-01-01 2020-01-31 2020 1 159500 42 0 34.5 7.5 42 0.0 4.70219435736677 0.217391304347826 monthly  
42 Ecuador Orellana EC-D 2020-02-01 2020-02-29 2020 2 159500 26 0 35.0 -9.0 26 0.0 -5.64263322884013 -0.257142857142857 monthly  
43 Ecuador Orellana EC-D 2020-03-01 2020-03-31 2020 3 159500 23 0 40.5 -17.5 23 0.0 -10.9717868338558 -0.432098765432099 monthly  
44 Ecuador Orellana EC-D 2020-04-01 2020-04-30 2020 4 159500 23 0 33.5 -10.5 23 0.0 -6.58307210031348 -0.313432835820896 monthly  
45 Ecuador Orellana EC-D 2020-05-01 2020-05-31 2020 5 159500 30 0 35.5 -5.5 30 0.0 -3.44827586206897 -0.154929577464789 monthly  
46 Ecuador Esmeraldas EC-E 2020-01-01 2020-01-31 2020 1 635200 133 0 155.5 -22.5 133 0.0 -3.54219143576826 -0.144694533762058 monthly  
47 Ecuador Esmeraldas EC-E 2020-02-01 2020-02-29 2020 2 635200 149 0 128.5 20.5 149 0.0 3.22732997481108 0.159533073929961 monthly  
48 Ecuador Esmeraldas EC-E 2020-03-01 2020-03-31 2020 3 635200 90 0 139.5 -49.5 90 0.0 -7.79282115869018 -0.354838709677419 monthly  
49 Ecuador Esmeraldas EC-E 2020-04-01 2020-04-30 2020 4 635200 172 0 137.5 34.5 172 0.0 5.43136020151134 0.250909090909091 monthly  
50 Ecuador Esmeraldas EC-E 2020-05-01 2020-05-31 2020 5 635200 213 0 112.5 100.5 213 0.0 15.8217884130982 0.893333333333333 monthly  
51 Ecuador Cañar EC-F 2020-01-01 2020-01-31 2020 1 276800 107 0 92.0 15.0 107 0.0 5.41907514450867 0.16304347826087 monthly  
52 Ecuador Cañar EC-F 2020-02-01 2020-02-29 2020 2 276800 75 0 85.5 -10.5 75 0.0 -3.79335260115607 -0.12280701754386 monthly  
53 Ecuador Cañar EC-F 2020-03-01 2020-03-31 2020 3 276800 72 0 90.5 -18.5 72 0.0 -6.68352601156069 -0.204419889502762 monthly  
54 Ecuador Cañar EC-F 2020-04-01 2020-04-30 2020 4 276800 132 0 72.5 59.5 132 0.0 21.4956647398844 0.820689655172414 monthly  
55 Ecuador Cañar EC-F 2020-05-01 2020-05-31 2020 5 276800 68 0 80.0 -12.0 68 0.0 -4.33526011560694 -0.15 monthly  
56 Ecuador Guayas EC-G 2020-01-01 2020-01-31 2020 1 4327800 1960 0 1892.0 68.0 1960 0.0 1.57123711816627 0.0359408033826638 monthly  
57 Ecuador Guayas EC-G 2020-02-01 2020-02-29 2020 2 4327800 1703 0 1653.5 49.5 1703 0.0 1.14376819631221 0.0299364983368613 monthly  
58 Ecuador Guayas EC-G 2020-03-01 2020-03-31 2020 3 4327800 5021 0 1843.0 3178.0 5021 0.0 73.432228846065 1.72436245252306 monthly  
59 Ecuador Guayas EC-G 2020-04-01 2020-04-30 2020 4 4327800 11376 0 1772.5 9603.5 11376 0.0 221.902583298674 5.41805359661495 monthly  
60 Ecuador Guayas EC-G 2020-05-01 2020-05-31 2020 5 4327800 2350 0 1675.5 674.5 2350 0.0 15.5852858265169 0.402566398090122 monthly  
61 Ecuador Chimborazo EC-H 2020-01-01 2020-01-31 2020 1 519800 216 0 209.5 6.5 216 0.0 1.25048095421316 0.0310262529832936 monthly  
62 Ecuador Chimborazo EC-H 2020-02-01 2020-02-29 2020 2 519800 184 0 203.5 -19.5 184 0.0 -3.75144286263948 -0.0958230958230958 monthly  
63 Ecuador Chimborazo EC-H 2020-03-01 2020-03-31 2020 3 519800 182 0 205.5 -23.5 182 0.0 -4.52096960369373 -0.114355231143552 monthly  
64 Ecuador Chimborazo EC-H 2020-04-01 2020-04-30 2020 4 519800 286 0 190.0 96.0 286 0.0 18.468641785302 0.505263157894737 monthly  
65 Ecuador Chimborazo EC-H 2020-05-01 2020-05-31 2020 5 519800 183 0 184.0 -1.0 183 0.0 -0.192381685263563 -0.00543478260869568 monthly  
66 Ecuador Imbabura EC-I 2020-01-01 2020-01-31 2020 1 470100 185 0 179.5 5.5 185 0.0 1.16996383748139 0.0306406685236769 monthly  
67 Ecuador Imbabura EC-I 2020-02-01 2020-02-29 2020 2 470100 154 0 147.0 7.0 154 0.0 1.48904488406722 0.0476190476190477 monthly  
68 Ecuador Imbabura EC-I 2020-03-01 2020-03-31 2020 3 470100 135 0 162.0 -27.0 135 0.0 -5.74345883854499 -0.166666666666667 monthly  
69 Ecuador Imbabura EC-I 2020-04-01 2020-04-30 2020 4 470100 159 0 160.0 -1.0 159 0.0 -0.212720697723889 -0.00624999999999998 monthly  
70 Ecuador Imbabura EC-I 2020-05-01 2020-05-31 2020 5 470100 142 0 178.0 -36.0 142 0.0 -7.65794511805999 -0.202247191011236 monthly  
71 Ecuador Loja EC-L 2020-01-01 2020-01-31 2020 1 516200 210 0 217.5 -7.5 210 0.0 -1.45292522278187 -0.0344827586206896 monthly  
72 Ecuador Loja EC-L 2020-02-01 2020-02-29 2020 2 516200 162 0 219.5 -57.5 162 0.0 -11.139093374661 -0.261958997722096 monthly  
73 Ecuador Loja EC-L 2020-03-01 2020-03-31 2020 3 516200 139 0 195.0 -56.0 139 0.0 -10.8485083301046 -0.287179487179487 monthly  
74 Ecuador Loja EC-L 2020-04-01 2020-04-30 2020 4 516200 149 0 192.5 -43.5 149 0.0 -8.42696629213483 -0.225974025974026 monthly  
75 Ecuador Loja EC-L 2020-05-01 2020-05-31 2020 5 516200 144 0 196.5 -52.5 144 0.0 -10.1704765594731 -0.267175572519084 monthly  
76 Ecuador Manabí EC-M 2020-01-01 2020-01-31 2020 1 1549800 623 0 567.5 55.5 623 0.0 3.58110723964383 0.0977973568281938 monthly  
77 Ecuador Manabí EC-M 2020-02-01 2020-02-29 2020 2 1549800 532 0 524.5 7.5 532 0.0 0.483933410762679 0.0142993326978074 monthly  
78 Ecuador Manabí EC-M 2020-03-01 2020-03-31 2020 3 1549800 506 0 574.5 -68.5 506 0.0 -4.41992515163247 -0.119234116623151 monthly  
79 Ecuador Manabí EC-M 2020-04-01 2020-04-30 2020 4 1549800 1445 0 519.5 925.5 1445 0.0 59.7173828881146 1.78152069297401 monthly  
80 Ecuador Manabí EC-M 2020-05-01 2020-05-31 2020 5 1549800 1017 0 473.5 543.5 1017 0.0 35.0690411666021 1.14783526927138 monthly  
81 Ecuador Napo EC-N 2020-01-01 2020-01-31 2020 1 131000 35 0 33.5 1.5 35 0.0 1.14503816793893 0.044776119402985 monthly  
82 Ecuador Napo EC-N 2020-02-01 2020-02-29 2020 2 131000 29 0 22.5 6.5 29 0.0 4.9618320610687 0.288888888888889 monthly  
83 Ecuador Napo EC-N 2020-03-01 2020-03-31 2020 3 131000 13 0 32.0 -19.0 13 0.0 -14.5038167938931 -0.59375 monthly  
84 Ecuador Napo EC-N 2020-04-01 2020-04-30 2020 4 131000 31 0 32.0 -1.0 31 0.0 -0.763358778625954 -0.03125 monthly  
85 Ecuador Napo EC-N 2020-05-01 2020-05-31 2020 5 131000 44 0 31.0 13.0 44 0.0 9.9236641221374 0.419354838709677 monthly  
86 Ecuador El Oro EC-O 2020-01-01 2020-01-31 2020 1 707200 298 0 270.5 27.5 298 0.0 3.88857466063348 0.101663585951941 monthly  
87 Ecuador El Oro EC-O 2020-02-01 2020-02-29 2020 2 707200 224 0 244.5 -20.5 224 0.0 -2.8987556561086 -0.0838445807770961 monthly  
88 Ecuador El Oro EC-O 2020-03-01 2020-03-31 2020 3 707200 251 0 268.0 -17.0 251 0.0 -2.40384615384615 -0.0634328358208955 monthly  
89 Ecuador El Oro EC-O 2020-04-01 2020-04-30 2020 4 707200 564 0 227.5 336.5 564 0.0 47.5820135746606 1.47912087912088 monthly  
90 Ecuador El Oro EC-O 2020-05-01 2020-05-31 2020 5 707200 546 0 250.5 295.5 546 0.0 41.7845022624434 1.17964071856287 monthly  
91 Ecuador Pichincha EC-P 2020-01-01 2020-01-31 2020 1 3172200 1204 0 1268.5 -64.5 1204 0.0 -2.03328919992434 -0.0508474576271186 monthly  
92 Ecuador Pichincha EC-P 2020-02-01 2020-02-29 2020 2 3172200 1143 0 998.0 145.0 1143 0.0 4.57096021688418 0.145290581162325 monthly  
93 Ecuador Pichincha EC-P 2020-03-01 2020-03-31 2020 3 3172200 1086 0 1047.5 38.5 1086 0.0 1.21366874724166 0.0367541766109785 monthly  
94 Ecuador Pichincha EC-P 2020-04-01 2020-04-30 2020 4 3172200 1255 0 1001.5 253.5 1255 0.0 7.99129941365614 0.253120319520719 monthly  
95 Ecuador Pichincha EC-P 2020-05-01 2020-05-31 2020 5 3172200 1507 0 1096.0 411.0 1507 0.0 12.9563079250993 0.375 monthly  
96 Ecuador Los Ríos EC-R 2020-01-01 2020-01-31 2020 1 910800 296 0 308.0 -12.0 296 0.0 -1.31752305665349 -0.038961038961039 monthly  
97 Ecuador Los Ríos EC-R 2020-02-01 2020-02-29 2020 2 910800 286 0 302.5 -16.5 286 0.0 -1.81159420289855 -0.0545454545454546 monthly  
98 Ecuador Los Ríos EC-R 2020-03-01 2020-03-31 2020 3 910800 267 0 333.5 -66.5 267 0.0 -7.30127360562143 -0.199400299850075 monthly  
99 Ecuador Los Ríos EC-R 2020-04-01 2020-04-30 2020 4 910800 677 0 309.0 368.0 677 0.0 40.4040404040404 1.19093851132686 monthly  
100 Ecuador Los Ríos EC-R 2020-05-01 2020-05-31 2020 5 910800 426 0 294.0 132.0 426 0.0 14.4927536231884 0.448979591836735 monthly  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_excess_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [month] 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
, [week] INTEGER);
Powered by Datasette · Query took 161.248ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette