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

7,472 rows

View and edit SQL

Suggested facets: week, start_date (date), end_date (date)

country

month

  • 1 66
  • 2 66
  • 3 66
  • 4 66
  • 5 56
  • 6 52

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
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 6682 0 6664.0 18.0 6682 0.0 0.104488355353287 0.00270108043217276 monthly  
22 Ecuador Ecuador EC 2020-02-01 2020-02-29 2020 2 17226800 5998 0 5804.5 193.5 5998 0.0 1.12324982004783 0.0333362046687915 monthly  
23 Ecuador Ecuador EC 2020-03-01 2020-03-31 2020 3 17226800 9470 79 6273.5 3196.5 9391 0.458587781828314 18.5553904381545 0.509524189049175 monthly  
24 Ecuador Ecuador EC 2020-04-01 2020-04-30 2020 4 17226800 19709 821 5915.0 13794.0 18888 4.76582998583602 80.0729096524021 2.33203719357566 monthly  
25 Ecuador Ecuador EC 2020-05-01 2020-05-31 2020 5 17226800 9475 2458 5881.5 3593.5 7017 14.2684654143544 20.8599391645575 0.61098359262093 monthly  
26 Ecuador Ecuador EC 2020-06-01 2020-06-30 2020 6 17226800 8034 1169 5785.0 2249.0 6865 6.7859381893329 13.0552395105301 0.38876404494382 monthly  
27 Ecuador Azuay EC-A 2020-01-01 2020-01-31 2020 1 867200 361 0 358.0 3.0 361 0.0 0.345940959409594 0.0083798882681565 monthly  
28 Ecuador Azuay EC-A 2020-02-01 2020-02-29 2020 2 867200 319 0 308.0 11.0 319 0.0 1.26845018450184 0.0357142857142858 monthly  
29 Ecuador Azuay EC-A 2020-03-01 2020-03-31 2020 3 867200 330 0 328.5 1.5 330 0.0 0.172970479704797 0.00456621004566204 monthly  
30 Ecuador Azuay EC-A 2020-04-01 2020-04-30 2020 4 867200 345 0 325.5 19.5 345 0.0 2.24861623616236 0.0599078341013826 monthly  
31 Ecuador Azuay EC-A 2020-05-01 2020-05-31 2020 5 867200 354 0 336.0 18.0 354 0.0 2.07564575645756 0.0535714285714286 monthly  
32 Ecuador Azuay EC-A 2020-06-01 2020-06-30 2020 6 867200 338 0 326.5 11.5 338 0.0 1.32610701107011 0.0352220520673814 monthly  
33 Ecuador Bolívar EC-B 2020-01-01 2020-01-31 2020 1 208400 63 0 82.0 -19.0 63 0.0 -9.11708253358925 -0.231707317073171 monthly  
34 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  
35 Ecuador Bolívar EC-B 2020-03-01 2020-03-31 2020 3 208400 58 0 77.5 -19.5 58 0.0 -9.35700575815739 -0.251612903225806 monthly  
36 Ecuador Bolívar EC-B 2020-04-01 2020-04-30 2020 4 208400 110 0 64.5 45.5 110 0.0 21.8330134357006 0.705426356589147 monthly  
37 Ecuador Bolívar EC-B 2020-05-01 2020-05-31 2020 5 208400 91 0 66.5 24.5 91 0.0 11.7562380038388 0.368421052631579 monthly  
38 Ecuador Bolívar EC-B 2020-06-01 2020-06-30 2020 6 208400 89 0 78.0 11.0 89 0.0 5.27831094049904 0.141025641025641 monthly  
39 Ecuador Carchi EC-C 2020-01-01 2020-01-31 2020 1 185500 57 0 58.0 -1.0 57 0.0 -0.539083557951482 -0.0172413793103449 monthly  
40 Ecuador Carchi EC-C 2020-02-01 2020-02-29 2020 2 185500 57 0 60.5 -3.5 57 0.0 -1.88679245283019 -0.0578512396694215 monthly  
41 Ecuador Carchi EC-C 2020-03-01 2020-03-31 2020 3 185500 56 0 57.0 -1.0 56 0.0 -0.539083557951482 -0.0175438596491229 monthly  
42 Ecuador Carchi EC-C 2020-04-01 2020-04-30 2020 4 185500 51 0 52.5 -1.5 51 0.0 -0.808625336927224 -0.0285714285714286 monthly  
43 Ecuador Carchi EC-C 2020-05-01 2020-05-31 2020 5 185500 65 0 60.0 5.0 65 0.0 2.69541778975741 0.0833333333333333 monthly  
44 Ecuador Carchi EC-C 2020-06-01 2020-06-30 2020 6 185500 67 0 56.5 10.5 67 0.0 5.66037735849057 0.185840707964602 monthly  
45 Ecuador Orellana EC-D 2020-01-01 2020-01-31 2020 1 159500 42 0 35.0 7.0 42 0.0 4.38871473354232 0.2 monthly  
46 Ecuador Orellana EC-D 2020-02-01 2020-02-29 2020 2 159500 26 0 35.5 -9.5 26 0.0 -5.95611285266458 -0.267605633802817 monthly  
47 Ecuador Orellana EC-D 2020-03-01 2020-03-31 2020 3 159500 24 0 40.5 -16.5 24 0.0 -10.3448275862069 -0.407407407407407 monthly  
48 Ecuador Orellana EC-D 2020-04-01 2020-04-30 2020 4 159500 28 0 34.5 -6.5 28 0.0 -4.07523510971787 -0.188405797101449 monthly  
49 Ecuador Orellana EC-D 2020-05-01 2020-05-31 2020 5 159500 42 0 35.5 6.5 42 0.0 4.07523510971787 0.183098591549296 monthly  
50 Ecuador Orellana EC-D 2020-06-01 2020-06-30 2020 6 159500 59 0 33.0 26.0 59 0.0 16.3009404388715 0.787878787878788 monthly  
51 Ecuador Esmeraldas EC-E 2020-01-01 2020-01-31 2020 1 635200 133 0 157.0 -24.0 133 0.0 -3.77833753148615 -0.152866242038217 monthly  
52 Ecuador Esmeraldas EC-E 2020-02-01 2020-02-29 2020 2 635200 148 0 130.5 17.5 148 0.0 2.75503778337531 0.134099616858238 monthly  
53 Ecuador Esmeraldas EC-E 2020-03-01 2020-03-31 2020 3 635200 100 0 140.5 -40.5 100 0.0 -6.37594458438287 -0.288256227758007 monthly  
54 Ecuador Esmeraldas EC-E 2020-04-01 2020-04-30 2020 4 635200 183 0 139.5 43.5 183 0.0 6.84823677581864 0.311827956989247 monthly  
55 Ecuador Esmeraldas EC-E 2020-05-01 2020-05-31 2020 5 635200 275 0 113.5 161.5 275 0.0 25.4250629722922 1.42290748898678 monthly  
56 Ecuador Esmeraldas EC-E 2020-06-01 2020-06-30 2020 6 635200 212 0 126.5 85.5 212 0.0 13.4603274559194 0.675889328063241 monthly  
57 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  
58 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  
59 Ecuador Cañar EC-F 2020-03-01 2020-03-31 2020 3 276800 87 0 90.5 -3.5 87 0.0 -1.26445086705202 -0.0386740331491713 monthly  
60 Ecuador Cañar EC-F 2020-04-01 2020-04-30 2020 4 276800 153 0 73.5 79.5 153 0.0 28.721098265896 1.08163265306122 monthly  
61 Ecuador Cañar EC-F 2020-05-01 2020-05-31 2020 5 276800 89 0 80.0 9.0 89 0.0 3.2514450867052 0.1125 monthly  
62 Ecuador Cañar EC-F 2020-06-01 2020-06-30 2020 6 276800 88 0 91.5 -3.5 88 0.0 -1.26445086705202 -0.0382513661202186 monthly  
63 Ecuador Guayas EC-G 2020-01-01 2020-01-31 2020 1 4327800 1959 0 1900.0 59.0 1959 0.0 1.36327926429133 0.0310526315789474 monthly  
64 Ecuador Guayas EC-G 2020-02-01 2020-02-29 2020 2 4327800 1703 0 1661.0 42.0 1703 0.0 0.970469984749757 0.0252859723058398 monthly  
65 Ecuador Guayas EC-G 2020-03-01 2020-03-31 2020 3 4327800 5220 0 1852.5 3367.5 5220 0.0 77.810896991543 1.81781376518219 monthly  
66 Ecuador Guayas EC-G 2020-04-01 2020-04-30 2020 4 4327800 12004 0 1779.5 10224.5 12004 0.0 236.251675216045 5.74571508850801 monthly  
67 Ecuador Guayas EC-G 2020-05-01 2020-05-31 2020 5 4327800 2543 0 1683.0 860.0 2543 0.0 19.8715282591617 0.510992275698158 monthly  
68 Ecuador Guayas EC-G 2020-06-01 2020-06-30 2020 6 4327800 1748 0 1628.5 119.5 1748 0.0 2.76121817089514 0.0733804114215535 monthly  
69 Ecuador Chimborazo EC-H 2020-01-01 2020-01-31 2020 1 519800 216 0 210.5 5.5 216 0.0 1.0580992689496 0.0261282660332542 monthly  
70 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  
71 Ecuador Chimborazo EC-H 2020-03-01 2020-03-31 2020 3 519800 203 0 206.0 -3.0 203 0.0 -0.577145055790689 -0.0145631067961165 monthly  
72 Ecuador Chimborazo EC-H 2020-04-01 2020-04-30 2020 4 519800 316 0 190.0 126.0 316 0.0 24.2400923432089 0.663157894736842 monthly  
73 Ecuador Chimborazo EC-H 2020-05-01 2020-05-31 2020 5 519800 254 0 184.5 69.5 254 0.0 13.3705271258176 0.376693766937669 monthly  
74 Ecuador Chimborazo EC-H 2020-06-01 2020-06-30 2020 6 519800 262 0 177.0 85.0 262 0.0 16.3524432474028 0.480225988700565 monthly  
75 Ecuador Imbabura EC-I 2020-01-01 2020-01-31 2020 1 470100 185 0 180.5 4.5 185 0.0 0.957243139757498 0.0249307479224377 monthly  
76 Ecuador Imbabura EC-I 2020-02-01 2020-02-29 2020 2 470100 154 0 147.5 6.5 154 0.0 1.38268453520528 0.0440677966101695 monthly  
77 Ecuador Imbabura EC-I 2020-03-01 2020-03-31 2020 3 470100 135 0 163.5 -28.5 135 0.0 -6.06253988513082 -0.174311926605505 monthly  
78 Ecuador Imbabura EC-I 2020-04-01 2020-04-30 2020 4 470100 164 0 164.5 -0.5 164 0.0 -0.106360348861944 -0.00303951367781152 monthly  
79 Ecuador Imbabura EC-I 2020-05-01 2020-05-31 2020 5 470100 166 0 178.5 -12.5 166 0.0 -2.65900872154861 -0.0700280112044818 monthly  
80 Ecuador Imbabura EC-I 2020-06-01 2020-06-30 2020 6 470100 205 0 168.0 37.0 205 0.0 7.87066581578388 0.220238095238095 monthly  
81 Ecuador Loja EC-L 2020-01-01 2020-01-31 2020 1 516200 213 0 217.5 -4.5 213 0.0 -0.87175513366912 -0.0206896551724138 monthly  
82 Ecuador Loja EC-L 2020-02-01 2020-02-29 2020 2 516200 162 0 220.0 -58.0 162 0.0 -11.2359550561798 -0.263636363636364 monthly  
83 Ecuador Loja EC-L 2020-03-01 2020-03-31 2020 3 516200 163 0 196.0 -33.0 163 0.0 -6.39287098024022 -0.168367346938776 monthly  
84 Ecuador Loja EC-L 2020-04-01 2020-04-30 2020 4 516200 175 0 193.0 -18.0 175 0.0 -3.48702053467648 -0.0932642487046632 monthly  
85 Ecuador Loja EC-L 2020-05-01 2020-05-31 2020 5 516200 206 0 198.0 8.0 206 0.0 1.54978690430066 0.0404040404040404 monthly  
86 Ecuador Loja EC-L 2020-06-01 2020-06-30 2020 6 516200 201 0 181.5 19.5 201 0.0 3.77760557923286 0.107438016528926 monthly  
87 Ecuador Manabí EC-M 2020-01-01 2020-01-31 2020 1 1549800 623 0 568.5 54.5 623 0.0 3.51658278487547 0.0958663148636762 monthly  
88 Ecuador Manabí EC-M 2020-02-01 2020-02-29 2020 2 1549800 533 0 525.5 7.5 533 0.0 0.483933410762679 0.0142721217887727 monthly  
89 Ecuador Manabí EC-M 2020-03-01 2020-03-31 2020 3 1549800 547 0 575.5 -28.5 547 0.0 -1.83894696089818 -0.049522154648132 monthly  
90 Ecuador Manabí EC-M 2020-04-01 2020-04-30 2020 4 1549800 1574 0 520.0 1054.0 1574 0.0 68.0087753258485 2.02692307692308 monthly  
91 Ecuador Manabí EC-M 2020-05-01 2020-05-31 2020 5 1549800 1183 0 474.5 708.5 1183 0.0 45.7155762033811 1.49315068493151 monthly  
92 Ecuador Manabí EC-M 2020-06-01 2020-06-30 2020 6 1549800 647 0 499.0 148.0 647 0.0 9.54961930571687 0.296593186372746 monthly  
93 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  
94 Ecuador Napo EC-N 2020-02-01 2020-02-29 2020 2 131000 29 0 23.0 6.0 29 0.0 4.58015267175572 0.260869565217391 monthly  
95 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  
96 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  
97 Ecuador Napo EC-N 2020-05-01 2020-05-31 2020 5 131000 57 0 31.0 26.0 57 0.0 19.8473282442748 0.838709677419355 monthly  
98 Ecuador Napo EC-N 2020-06-01 2020-06-30 2020 6 131000 65 0 36.5 28.5 65 0.0 21.7557251908397 0.780821917808219 monthly  
99 Ecuador El Oro EC-O 2020-01-01 2020-01-31 2020 1 707200 299 0 273.0 26.0 299 0.0 3.67647058823529 0.0952380952380953 monthly  
100 Ecuador El Oro EC-O 2020-02-01 2020-02-29 2020 2 707200 225 0 246.5 -21.5 225 0.0 -3.04015837104072 -0.0872210953346856 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 274.301ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette