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

8,658 rows

View and edit SQL

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

country

cadence

Link rowid ▼ country region region_code start_date end_date 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
1 South Africa South Africa 0 2020-01-01 2020-01-07 2020 1 58775022 9931 0 9029 902.0 9931 0.0 1.5346655250933 0.0999003211872853 weekly                
2 South Africa South Africa 0 2020-01-08 2020-01-14 2020 2 58775022 8726 0 8938 -212.0 8726 0.0 -0.360697440487559 -0.0237189527858581 weekly                
3 South Africa South Africa 0 2020-01-15 2020-01-21 2020 3 58775022 8300 0 8420 -120.0 8300 0.0 -0.204168362540128 -0.0142517814726841 weekly                
4 South Africa South Africa 0 2020-01-22 2020-01-28 2020 4 58775022 8328 0 8088 240.0 8328 0.0 0.408336725080256 0.029673590504451 weekly                
5 South Africa South Africa 0 2020-01-29 2020-02-04 2020 5 58775022 9193 0 8577 616.0 9193 0.0 1.04806426103932 0.0718199836772764 weekly                
6 South Africa South Africa 0 2020-02-05 2020-02-11 2020 6 58775022 8739 0 8564 175.0 8739 0.0 0.297745528704353 0.0204343764595982 weekly                
7 South Africa South Africa 0 2020-02-12 2020-02-18 2020 7 58775022 8600 0 8189 411.0 8600 0.0 0.699276641699939 0.0501892783001587 weekly                
8 South Africa South Africa 0 2020-02-19 2020-02-25 2020 8 58775022 8325 0 8262 63.0 8325 0.0 0.107188390333567 0.00762527233115473 weekly                
9 South Africa South Africa 0 2020-02-26 2020-03-03 2020 9 58775022 8735 0 8909 -174.0 8735 0.0 -0.296044125683186 -0.0195308115388932 weekly                
10 South Africa South Africa 0 2020-03-04 2020-03-10 2020 10 58775022 9082 0 8613 469.0 9082 0.0 0.797958016927667 0.054452571693951 weekly                
11 South Africa South Africa 0 2020-03-11 2020-03-17 2020 11 58775022 8573 0 8365 208.0 8573 0.0 0.353891828402889 0.0248655110579796 weekly                
12 South Africa South Africa 0 2020-03-18 2020-03-24 2020 12 58775022 8421 0 8396 25.0 8421 0.0 0.0425350755291933 0.00297760838494532 weekly                
13 South Africa South Africa 0 2020-03-25 2020-03-31 2020 13 58775022 8272 5 8811 -539.0 8267 0.00850701510583867 -0.917056228409408 -0.0611735330836455 weekly                
14 South Africa South Africa 0 2020-04-01 2020-04-07 2020 14 58775022 8112 8 8823 -711.0 8104 0.0136112241693419 -1.20969754805026 -0.0805848350901054 weekly                
15 South Africa South Africa 0 2020-04-08 2020-04-14 2020 15 58775022 8181 14 8660 -479.0 8167 0.0238196422963483 -0.814972047139344 -0.0553117782909931 weekly                
16 South Africa South Africa 0 2020-04-15 2020-04-21 2020 16 58775022 7994 31 8680 -686.0 7963 0.0527434936561997 -1.16716247252107 -0.0790322580645161 weekly                
17 South Africa South Africa 0 2020-04-22 2020-04-28 2020 17 58775022 7632 35 9086 -1454.0 7597 0.0595491057408707 -2.47383999277788 -0.160026414263702 weekly                
18 South Africa South Africa 0 2020-04-29 2020-05-05 2020 18 58775022 8301 55 9447 -1146.0 8246 0.0935771661642253 -1.94980786225822 -0.121308351857733 weekly                
19 South Africa South Africa 0 2020-05-06 2020-05-12 2020 19 58775022 8469 58 9501 -1032.0 8411 0.0986813752277285 -1.7558479178451 -0.108620145247869 weekly                
20 South Africa South Africa 0 2020-05-13 2020-05-19 2020 20 58775022 8616 106 9358 -742.0 8510 0.18034872024378 -1.26244104170646 -0.0792904466766403 weekly                
21 South Africa South Africa 0 2020-05-20 2020-05-26 2020 21 58775022 8784 212 9578 -794.0 8572 0.360697440487559 -1.35091399880718 -0.0828983086239299 weekly                
22 South Africa South Africa 0 2020-05-27 2020-06-02 2020 22 58775022 9884 231 10195 -311.0 9653 0.393024097889746 -0.529136339583165 -0.030505149583129 weekly                
23 South Africa South Africa 0 2020-06-03 2020-06-09 2020 23 58775022 10165 407 10880 -715.0 9758 0.692471029615268 -1.21650316013493 -0.0657169117647058 weekly                
24 South Africa South Africa 0 2020-06-10 2020-06-16 2020 24 58775022 11066 463 11130 -64.0 10603 0.787749598800661 -0.108889793354735 -0.00575022461814911 weekly                
25 South Africa South Africa 0 2020-06-17 2020-06-23 2020 25 58775022 12044 477 11129 915.0 11567 0.811569241097009 1.55678376436848 0.0822176296163177 weekly                
26 South Africa South Africa 0 2020-06-24 2020-06-30 2020 26 58775022 12613 555 10760 1853.0 12058 0.944278676748092 3.15269979822381 0.172211895910781 weekly                
27 South Africa South Africa 0 2020-07-01 2020-07-07 2020 27 58775022 13891 845 10815 3076.0 13046 1.43768555288673 5.23351569311195 0.284419787332409 weekly                
28 South Africa South Africa 0 2020-07-08 2020-07-14 2020 28 58775022 15012 844 9935 5077.0 14168 1.43598414986557 8.63802313846858 0.511021640664318 weekly                
29 South Africa South Africa 0 2020-07-15 2020-07-21 2020 29 58775022 16182 1022 9966 6216.0 15160 1.73883388763342 10.5759211795786 0.623720650210716 weekly                
30 South Africa South Africa 0 2020-07-22 2020-07-28 2020 30 58775022 15461 1889 9733 5728.0 13572 3.21395030698585 9.74563650524878 0.58851330525018 weekly                
31 Norway Norway 0 2020-01-01 2020-01-07 2020 1 5367580 860 0 924.4 -64.4 860 0.0 -1.19979581114767 -0.0696668109043703 weekly                
32 Norway Norway 0 2020-01-08 2020-01-14 2020 2 5367580 948 0 917.6 30.4 948 0.0 0.566363240044861 0.033129904097646 weekly                
33 Norway Norway 0 2020-01-15 2020-01-21 2020 3 5367580 836 0 907.2 -71.2 836 0.0 -1.32648232536823 -0.0784832451499119 weekly                
34 Norway Norway 0 2020-01-22 2020-01-28 2020 4 5367580 862 0 884.8 -22.8 862 0.0 -0.424772430033646 -0.0257685352622061 weekly                
35 Norway Norway 0 2020-01-29 2020-02-04 2020 5 5367580 815 0 895.2 -80.2 815 0.0 -1.49415565301309 -0.0895889186773906 weekly                
36 Norway Norway 0 2020-02-05 2020-02-11 2020 6 5367580 798 0 864 -66.0 798 0.0 -1.22960440272898 -0.0763888888888888 weekly                
37 Norway Norway 0 2020-02-12 2020-02-18 2020 7 5367580 857 0 875.6 -18.6 857 0.0 -0.346524877132712 -0.0212425765189584 weekly                
38 Norway Norway 0 2020-02-19 2020-02-25 2020 8 5367580 813 0 867.6 -54.6 813 0.0 -1.01721818771215 -0.0629322268326418 weekly                
39 Norway Norway 0 2020-02-26 2020-03-03 2020 9 5367580 838 0 877.4 -39.4 838 0.0 -0.734036567689722 -0.0449054023250512 weekly                
40 Norway Norway 0 2020-03-04 2020-03-10 2020 10 5367580 799 0 868.4 -69.4 799 0.0 -1.29294765983926 -0.0799170888991249 weekly                
41 Norway Norway 0 2020-03-11 2020-03-17 2020 11 5367580 823 3 828.2 -5.20000000000005 820 0.0558911092149535 -0.0968779226392535 -0.00627867664815263 weekly                
42 Norway Norway 0 2020-03-18 2020-03-24 2020 12 5367580 805 7 817 -12.0 798 0.130412588168225 -0.223564436859814 -0.01468788249694 weekly                
43 Norway Norway 0 2020-03-25 2020-03-31 2020 13 5367580 853 18 781.4 71.6 835 0.335346655289721 1.33393447326356 0.0916304069618634 weekly                
44 Norway Norway 0 2020-04-01 2020-04-07 2020 14 5367580 831 41 799.4 31.6 790 0.763845159271031 0.588719683730844 0.0395296472354265 weekly                
45 Norway Norway 0 2020-04-08 2020-04-14 2020 15 5367580 838 58 785.6 52.4 780 1.08056144482243 0.976231374287854 0.0667006109979633 weekly                
46 Norway Norway 0 2020-04-15 2020-04-21 2020 16 5367580 811 36 765.8 45.2 775 0.670693310579442 0.842092712171967 0.0590232436667537 weekly                
47 Norway Norway 0 2020-04-22 2020-04-28 2020 17 5367580 772 32 780 -8.0 740 0.59617183162617 -0.149042957906543 -0.0102564102564102 weekly                
48 Norway Norway 0 2020-04-29 2020-05-05 2020 18 5367580 748 14 741.6 6.39999999999998 734 0.26082517633645 0.119234366325234 0.00862998921251346 weekly                
49 Norway Norway 0 2020-05-06 2020-05-12 2020 19 5367580 738 19 736.4 1.60000000000002 719 0.353977025028039 0.0298085915813089 0.00217273221075498 weekly                
50 Norway Norway 0 2020-05-13 2020-05-19 2020 20 5367580 685 5 724.6 -39.6 680 0.0931518486915891 -0.737762641637386 -0.0546508418437759 weekly                
51 Norway Norway 0 2020-05-20 2020-05-26 2020 21 5367580 737 2 732.2 4.79999999999995 735 0.0372607394766357 0.0894257747439247 0.00655558590549021 weekly                
52 Norway Norway 0 2020-05-27 2020-06-02 2020 22 5367580 660 2 713.6 -53.6 658 0.0372607394766357 -0.998587817973836 -0.0751121076233184 weekly                
53 Norway Norway 0 2020-06-03 2020-06-09 2020 23 5367580 673 2 714.2 -41.2 671 0.0372607394766357 -0.767571233218695 -0.0576869224306917 weekly                
54 Norway Norway 0 2020-06-10 2020-06-16 2020 24 5367580 716 3 722.6 -6.60000000000002 713 0.0558911092149535 -0.122960440272898 -0.00913368391918079 weekly                
55 Norway Norway 0 2020-06-17 2020-06-23 2020 25 5367580 730 6 724 6.0 724 0.111782218429907 0.111782218429907 0.00828729281767959 weekly                
56 Norway Norway 0 2020-06-24 2020-06-30 2020 26 5367580 664 2 734.2 -70.2 662 0.0372607394766357 -1.30785195562991 -0.0956142740397712 weekly                
57 Norway Norway 0 2020-07-01 2020-07-07 2020 27 5367580 666 1 748.6 -82.6 665 0.0186303697383178 -1.53886854038505 -0.110339300026717 weekly                
58 Norway Norway 0 2020-07-08 2020-07-14 2020 28 5367580 637 2 718 -81.0 635 0.0372607394766357 -1.50905994880374 -0.112813370473538 weekly                
59 Norway Norway 0 2020-07-15 2020-07-21 2020 29 5367580 667 2 723.2 -56.2 665 0.0372607394766357 -1.04702677929346 -0.0777101769911505 weekly                
60 Netherlands Netherlands 0 2020-01-06 2020-01-12 2020 1 17414806 3364 0 3355 9.0 3364 0.0 0.0516801622711157 0.00268256333830097 weekly                
61 Netherlands Netherlands 0 2020-01-13 2020-01-19 2020 2 17414806 3154 0 3319.6 -165.6 3154 0.0 -0.950914985788529 -0.0498855283769128 weekly                
62 Netherlands Netherlands 0 2020-01-20 2020-01-26 2020 3 17414806 3044 0 3288.8 -244.8 3044 0.0 -1.40570041377435 -0.0744344441741669 weekly                
63 Netherlands Netherlands 0 2020-01-27 2020-02-02 2020 4 17414806 3160 0 3322.8 -162.8 3160 0.0 -0.934836713081961 -0.048994823642711 weekly                
64 Netherlands Netherlands 0 2020-02-03 2020-02-09 2020 5 17414806 3193 0 3307.4 -114.4 3193 0.0 -0.656912284868405 -0.0345891032230755 weekly                
65 Netherlands Netherlands 0 2020-02-10 2020-02-16 2020 6 17414806 3198 0 3311.6 -113.6 3198 0.0 -0.652318492666527 -0.0343036598623022 weekly                
66 Netherlands Netherlands 0 2020-02-17 2020-02-23 2020 7 17414806 2957 0 3341.4 -384.4 2957 0.0 -2.20731715300188 -0.115041599329622 weekly                
67 Netherlands Netherlands 0 2020-02-24 2020-03-01 2020 8 17414806 3095 0 3322.2 -227.2 3095 0.0 -1.30463698533305 -0.0683884173138282 weekly                
68 Netherlands Netherlands 0 2020-03-02 2020-03-08 2020 9 17414806 3102 3 3333.4 -231.4 3099 0.0172267207570386 -1.32875439439291 -0.0694186116277675 weekly                
69 Netherlands Netherlands 0 2020-03-09 2020-03-15 2020 10 17414806 3216 17 3322 -106.0 3199 0.0976180842898853 -0.608677466748696 -0.0319084888621313 weekly                
70 Netherlands Netherlands 0 2020-03-16 2020-03-22 2020 11 17414806 3612 159 3146.4 465.6 3453 0.913016200123045 2.67358706149239 0.147978642257818 weekly                
71 Netherlands Netherlands 0 2020-03-23 2020-03-29 2020 12 17414806 4458 592 3066.6 1391.4 3866 3.39940622938895 7.98975308711449 0.453727254940325 weekly                
72 Netherlands Netherlands 0 2020-03-30 2020-04-05 2020 13 17414806 5084 995 2970.2 2113.8 4089 5.71352905108446 12.1379474454094 0.711669247862097 weekly                
73 Netherlands Netherlands 0 2020-04-06 2020-04-12 2020 14 17414806 4974 971 2920.4 2053.6 4003 5.57571528502815 11.7922645822181 0.703191343651554 weekly                
74 Netherlands Netherlands 0 2020-04-13 2020-04-19 2020 15 17414806 4298 947 2874 1424.0 3351 5.43790151897185 8.17695011934098 0.495476687543493 weekly                
75 Netherlands Netherlands 0 2020-04-20 2020-04-26 2020 16 17414806 3903 791 2802 1101.0 3112 4.54211203960584 6.32220651783316 0.392933618843683 weekly                
76 Netherlands Netherlands 0 2020-04-27 2020-05-03 2020 17 17414806 3377 581 2732.6 644.4 2796 3.33624158661314 3.70029961861189 0.235819366171412 weekly                
77 Netherlands Netherlands 0 2020-05-04 2020-05-10 2020 18 17414806 2980 384 2736 244.0 2596 2.20502025690094 1.40110662157247 0.0891812865497077 weekly                
78 Netherlands Netherlands 0 2020-05-11 2020-05-17 2020 19 17414806 2772 240 2787.4 -15.4000000000001 2532 1.37813766056309 -0.0884304998861319 -0.00552486187845302 weekly                
79 Netherlands Netherlands 0 2020-05-18 2020-05-24 2020 20 17414806 2765 142 2703.4 61.5999999999999 2623 0.815398115833159 0.353721999544525 0.0227861211807354 weekly                
80 Netherlands Netherlands 0 2020-05-25 2020-05-31 2020 21 17414806 2720 134 2710.2 9.80000000000018 2586 0.76946019381439 0.0562739544729937 0.00361596930115859 weekly                
81 Netherlands Netherlands 0 2020-06-01 2020-06-07 2020 22 17414806 2680 57 2698 -18.0 2623 0.327307694383733 -0.103360324542231 -0.00667160859896221 weekly                
82 Netherlands Netherlands 0 2020-06-08 2020-06-14 2020 23 17414806 2686 46 2644 42.0 2640 0.264143051607925 0.24117409059854 0.0158850226928895 weekly                
83 Netherlands Netherlands 0 2020-06-15 2020-06-21 2020 24 17414806 2684 31 2614.6 69.4000000000001 2653 0.178009447822732 0.398511473512826 0.0265432570947755 weekly                
84 Netherlands Netherlands 0 2020-06-22 2020-06-28 2020 25 17414806 2656 15 2641.4 14.5999999999999 2641 0.0861336037851929 0.0838367076842539 0.00552737184826224 weekly                
85 Netherlands Netherlands 0 2020-06-29 2020-07-05 2020 26 17414806 2626 22 2698.4 -72.4000000000001 2604 0.126329285551616 -0.415738194269865 -0.02683071449748 weekly                
86 Netherlands Netherlands 0 2020-07-06 2020-07-12 2020 27 17414806 2596 8 2692.6 -96.5999999999999 2588 0.0459379220187695 -0.554700408376642 -0.0358761048800416 weekly                
87 Netherlands Netherlands 0 2020-07-13 2020-07-19 2020 28 17414806 2496 1 2593.8 -97.8000000000002 2495 0.00574224025234619 -0.561591096679459 -0.037705297247282 weekly                
88 Portugal Portugal 0 2020-01-01 2020-01-07 2020 1 10276617 2574 0 2859.4 -285.4 2574 0.0 -2.77717852090819 -0.0998111491921383 weekly                
89 Portugal Portugal 0 2020-01-08 2020-01-14 2020 2 10276617 2726 0 2878.8 -152.8 2726 0.0 -1.48687063067545 -0.0530776712519105 weekly                
90 Portugal Portugal 0 2020-01-15 2020-01-21 2020 3 10276617 2704 0 2812 -108.0 2704 0.0 -1.05092950335699 -0.0384068278805121 weekly                
91 Portugal Portugal 0 2020-01-22 2020-01-28 2020 4 10276617 2732 0 2833.4 -101.4 2732 0.0 -0.986706033707397 -0.0357873932378062 weekly                
92 Portugal Portugal 0 2020-01-29 2020-02-04 2020 5 10276617 2681 0 2686.8 -5.80000000000018 2681 0.0 -0.056438806661766 -0.00215870180139954 weekly                
93 Portugal Portugal 0 2020-02-05 2020-02-11 2020 6 10276617 2374 0 2686.2 -312.2 2374 0.0 -3.03796473100048 -0.116223661678207 weekly                
94 Portugal Portugal 0 2020-02-12 2020-02-18 2020 7 10276617 2302 0 2585.4 -283.4 2302 0.0 -2.75771686343862 -0.109615533379748 weekly                
95 Portugal Portugal 0 2020-02-19 2020-02-25 2020 8 10276617 2350 0 2556.4 -206.4 2350 0.0 -2.00844305086003 -0.0807385385698639 weekly                
96 Portugal Portugal 0 2020-02-26 2020-03-03 2020 9 10276617 2282 0 2442.8 -160.8 2282 0.0 -1.56471726055374 -0.0658261011953497 weekly                
97 Portugal Portugal 0 2020-03-04 2020-03-10 2020 10 10276617 2217 0 2323 -106.0 2217 0.0 -1.03146784588742 -0.0456306500215239 weekly                
98 Portugal Portugal 0 2020-03-11 2020-03-17 2020 11 10276617 2374 1 2257.6 116.4 2373 0.00973082873478694 1.1326684647292 0.0515591778880227 weekly                
99 Portugal Portugal 0 2020-03-18 2020-03-24 2020 12 10276617 2461 32 2224.4 236.6 2429 0.311386519513182 2.30231407865059 0.106365761553677 weekly                
100 Portugal Portugal 0 2020-03-25 2020-03-31 2020 13 10276617 2593 127 2192 401.0 2466 1.23581524931794 3.90206232264956 0.18293795620438 weekly                

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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