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

250 rows where country = "Ecuador"

View and edit SQL

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

country

  • Ecuador · 250

cadence

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
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  
101 Ecuador Morona Santiago EC-S 2020-01-01 2020-01-31 2020 1 192300 49 0 46.5 2.5 49 0.0 1.30005200208008 0.053763440860215 monthly  
102 Ecuador Morona Santiago EC-S 2020-02-01 2020-02-29 2020 2 192300 48 0 40.5 7.5 48 0.0 3.90015600624025 0.185185185185185 monthly  
103 Ecuador Morona Santiago EC-S 2020-03-01 2020-03-31 2020 3 192300 33 0 45.5 -12.5 33 0.0 -6.50026001040042 -0.274725274725275 monthly  
104 Ecuador Morona Santiago EC-S 2020-04-01 2020-04-30 2020 4 192300 23 0 45.0 -22.0 23 0.0 -11.4404576183047 -0.488888888888889 monthly  
105 Ecuador Morona Santiago EC-S 2020-05-01 2020-05-31 2020 5 192300 24 0 39.0 -15.0 24 0.0 -7.8003120124805 -0.384615384615385 monthly  
106 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-01-01 2020-01-31 2020 1 450700 204 0 207.5 -3.5 204 0.0 -0.776569780341691 -0.016867469879518 monthly  
107 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-02-01 2020-02-29 2020 2 450700 202 0 166.0 36.0 202 0.0 7.98757488351453 0.216867469879518 monthly  
108 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-03-01 2020-03-31 2020 3 450700 162 0 204.0 -42.0 162 0.0 -9.31883736410029 -0.205882352941177 monthly  
109 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-04-01 2020-04-30 2020 4 450700 239 0 184.5 54.5 239 0.0 12.0923008653206 0.295392953929539 monthly  
110 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-05-01 2020-05-31 2020 5 450700 256 0 186.0 70.0 256 0.0 15.5313956068338 0.376344086021505 monthly  
111 Ecuador Santa Elena EC-SE 2020-01-01 2020-01-31 2020 1 392600 116 0 111.0 5.0 116 0.0 1.27356087620988 0.045045045045045 monthly  
112 Ecuador Santa Elena EC-SE 2020-02-01 2020-02-29 2020 2 392600 113 0 107.0 6.0 113 0.0 1.52827305145186 0.0560747663551402 monthly  
113 Ecuador Santa Elena EC-SE 2020-03-01 2020-03-31 2020 3 392600 156 0 115.5 40.5 156 0.0 10.3158430973001 0.350649350649351 monthly  
114 Ecuador Santa Elena EC-SE 2020-04-01 2020-04-30 2020 4 392600 982 0 102.0 880.0 982 0.0 224.146714212939 8.62745098039216 monthly  
115 Ecuador Santa Elena EC-SE 2020-05-01 2020-05-31 2020 5 392600 310 0 100.0 210.0 310 0.0 53.4895568008151 2.1 monthly  
116 Ecuador Tungurahua EC-T 2020-01-01 2020-01-31 2020 1 584100 250 0 260.0 -10.0 250 0.0 -1.7120356103407 -0.0384615384615384 monthly  
117 Ecuador Tungurahua EC-T 2020-02-01 2020-02-29 2020 2 584100 235 0 219.0 16.0 235 0.0 2.73925697654511 0.0730593607305936 monthly  
118 Ecuador Tungurahua EC-T 2020-03-01 2020-03-31 2020 3 584100 215 0 241.5 -26.5 215 0.0 -4.53689436740284 -0.109730848861284 monthly  
119 Ecuador Tungurahua EC-T 2020-04-01 2020-04-30 2020 4 584100 260 0 208.5 51.5 260 0.0 8.81698339325458 0.247002398081535 monthly  
120 Ecuador Tungurahua EC-T 2020-05-01 2020-05-31 2020 5 584100 323 0 225.5 97.5 323 0.0 16.6923472008218 0.432372505543237 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 148.653ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette