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

9,644 rows

View and edit SQL

Suggested facets: 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 Belgium Belgium 0 2020-01-01 2020-01-07 2020 1 11431406 2300 0 2422.66666666667 -122.666666666667 2300 0.0 -1.07306718584456 -0.050632911392405 weekly                
2 Belgium Belgium 0 2020-01-08 2020-01-14 2020 2 11431406 2355 0 2474.0 -119.0 2355 0.0 -1.04099180800682 -0.0481002425222312 weekly                
3 Belgium Belgium 0 2020-01-15 2020-01-21 2020 3 11431406 2270 0 2407.0 -137.0 2270 0.0 -1.19845275375575 -0.056917324470295 weekly                
4 Belgium Belgium 0 2020-01-22 2020-01-28 2020 4 11431406 2208 0 2439.66666666667 -231.666666666667 2208 0.0 -2.02658069065753 -0.094958327640388 weekly                
5 Belgium Belgium 0 2020-01-29 2020-02-04 2020 5 11431406 2345 0 2597.66666666667 -252.666666666667 2345 0.0 -2.21028512736462 -0.0972667778775824 weekly                
6 Belgium Belgium 0 2020-02-05 2020-02-11 2020 6 11431406 2190 0 2544.0 -354.0 2190 0.0 -3.0967319330623 -0.139150943396226 weekly                
7 Belgium Belgium 0 2020-02-12 2020-02-18 2020 7 11431406 2250 0 2534.66666666667 -284.666666666667 2250 0.0 -2.49021569758494 -0.112309310889006 weekly                
8 Belgium Belgium 0 2020-02-19 2020-02-25 2020 8 11431406 2352 0 2488.33333333333 -136.333333333333 2352 0.0 -1.19262086687616 -0.0547890154052244 weekly                
9 Belgium Belgium 0 2020-02-26 2020-03-03 2020 9 11431406 2222 0 2580.0 -358.0 2222 0.0 -3.13172325433984 -0.138759689922481 weekly                
10 Belgium Belgium 0 2020-03-04 2020-03-10 2020 10 11431406 2180 1 2501.0 -321.0 2179 0.00874783031938503 -2.8080535325226 -0.128348660535786 weekly                
11 Belgium Belgium 0 2020-03-11 2020-03-17 2020 11 11431406 2262 39 2369.66666666667 -107.666666666667 2223 0.341165382456016 -0.941849731053787 -0.0454353636235757 weekly                
12 Belgium Belgium 0 2020-03-18 2020-03-24 2020 12 11431406 2712 332 2298.0 414.0 2380 2.90427966603583 3.6216017522254 0.180156657963446 weekly                
13 Belgium Belgium 0 2020-03-25 2020-03-31 2020 13 11431406 3434 1005 2192.33333333333 1241.66666666667 2429 8.79156947098196 10.8618893132364 0.566367644822867 weekly                
14 Belgium Belgium 0 2020-04-01 2020-04-07 2020 14 11431406 4126 1737 2101.66666666667 2024.33333333333 2389 15.1949812647718 17.7085245098751 0.963203806502776 weekly                
15 Belgium Belgium 0 2020-04-08 2020-04-14 2020 15 11431406 4198 1982 2039.33333333333 2158.66666666667 2216 17.3381996930211 18.8836497161125 1.05851585485453 weekly                
16 Belgium Belgium 0 2020-04-15 2020-04-21 2020 16 11431406 3536 1538 2029.0 1507.0 1998 13.4541630312142 13.1829802913132 0.742730409068507 weekly                
17 Belgium Belgium 0 2020-04-22 2020-04-28 2020 17 11431406 2856 1037 2019.0 837.0 1819 9.07150004120228 7.32193397732527 0.414561664190193 weekly                
18 Belgium Belgium 0 2020-04-29 2020-05-05 2020 18 11431406 2327 633 1989.66666666667 337.333333333333 1694 5.53737659217073 2.95093476107255 0.169542636957614 weekly                
19 Belgium Belgium 0 2020-05-06 2020-05-12 2020 19 11431406 2304 474 2006.66666666667 297.333333333333 1830 4.14647157138851 2.60102154829715 0.148172757475083 weekly                
20 Belgium Belgium 0 2020-05-13 2020-05-19 2020 20 11431406 1992 275 2013.33333333333 -21.3333333333333 1717 2.40565333783088 -0.18662038014688 -0.0105960264900662 weekly                
21 Belgium Belgium 0 2020-05-20 2020-05-26 2020 21 11431406 2066 213 1954.0 112.0 1853 1.86328785802901 0.979756995771124 0.0573183213920163 weekly                
22 Belgium Belgium 0 2020-05-27 2020-06-02 2020 22 11431406 1921 155 1991.66666666667 -70.6666666666667 1766 1.35591369950468 -0.618180009236543 -0.0354811715481171 weekly                
23 Belgium Belgium 0 2020-06-03 2020-06-09 2020 23 11431406 1786 90 1850.66666666667 -64.6666666666667 1696 0.787304728744653 -0.565693027320233 -0.034942363112392 weekly                
24 Belgium Belgium 0 2020-06-10 2020-06-16 2020 24 11431406 1927 52 1818.66666666667 108.333333333333 1875 0.454887176608022 0.947681617933378 0.0595674486803519 weekly                
25 Belgium Belgium 0 2020-06-17 2020-06-23 2020 25 11431406 1783 44 1941.33333333333 -158.333333333333 1739 0.384904534052942 -1.38507313390263 -0.0815590659340659 weekly                
26 Belgium Belgium 0 2020-06-24 2020-06-30 2020 26 11431406 1917 34 1924.33333333333 -7.33333333333326 1883 0.297426230859091 -0.0641507556754896 -0.00381084358219297 weekly                
27 Belgium Belgium 0 2020-07-01 2020-07-07 2020 27 11431406 1722 18 1953.0 -231.0 1704 0.157460945748931 -2.02074880377794 -0.118279569892473 weekly                
28 Belgium Belgium 0 2020-07-08 2020-07-14 2020 28 11431406 1668 12 1823.66666666667 -155.666666666667 1656 0.10497396383262 -1.36174558638427 -0.0853591665143484 weekly                
29 Belgium Belgium 0 2020-07-15 2020-07-21 2020 29 11431406 1851 19 1898.33333333333 -47.3333333333333 1832 0.166208776068316 -0.414063968450891 -0.0249341527655839 weekly                
30 Belgium Belgium 0 2020-07-22 2020-07-28 2020 30 11431406 1823 17 2100.0 -277.0 1806 0.148713115429546 -2.42314899846965 -0.131904761904762 weekly                
31 Belgium Belgium 0 2020-07-29 2020-08-04 2020 31 11431406 1901 23 1964.33333333333 -63.3333333333333 1878 0.201200097345856 -0.554029253561051 -0.0322416426268454 weekly                
32 Indonesia Jakarta 0 2020-01-01 2020-01-31 2020   10770000 3303 0 2717.5 585.5 3303 0.0 5.4363974001857 0.215455381784729 monthly 1 745.838709677419 0.0 613.629032258065 132.209677419355 745.838709677419 0.0 1.22757360649355
33 Indonesia Jakarta 0 2020-02-01 2020-02-29 2020   10770000 2744 0 2772.5 -28.5 2744 0.0 -0.264623955431755 -0.0102795311091073 monthly 2 662.344827586207 0.0 669.224137931034 -6.87931034482759 662.344827586207 0.0 -0.0638747478628374
34 Indonesia Jakarta 0 2020-03-01 2020-03-31 2020   10770000 4422 84 3046.5 1375.5 4338 0.779944289693593 12.7715877437326 0.45150172328902 monthly 3 999.860026917901 18.9932705248991 688.845222072678 311.014804845222 980.866756393001 0.176353486767865 2.88778834582379
35 Indonesia Jakarta 0 2020-04-01 2020-04-30 2020   10770000 4550 297 2967.5 1582.5 4253 2.75766016713092 14.6935933147632 0.533277169334457 monthly 4 1061.66666666667 69.3 692.416666666667 369.25 992.366666666667 0.643454038997215 3.42850510677809
36 Indonesia Jakarta 0 2020-05-01 2020-05-31 2020   10770000 4355 139 2848.0 1507.0 4216 1.29062209842154 13.9925719591458 0.529143258426966 monthly 5 983.387096774193 31.3870967741935 643.096774193548 340.290322580645 952.0 0.291430796417767 3.15961302303292
37 Netherlands Netherlands 0 2020-01-06 2020-01-12 2020 1 17414806 3364 0 3355.0 9.0 3364 0.0 0.0516801622711157 0.00268256333830097 weekly                
38 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                
39 Netherlands Netherlands 0 2020-01-20 2020-01-26 2020 3 17414806 3045 0 3288.8 -243.8 3045 0.0 -1.399958173522 -0.0741303819022137 weekly                
40 Netherlands Netherlands 0 2020-01-27 2020-02-02 2020 4 17414806 3162 0 3322.8 -160.8 3162 0.0 -0.923352232577269 -0.0483929216323583 weekly                
41 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                
42 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                
43 Netherlands Netherlands 0 2020-02-17 2020-02-23 2020 7 17414806 2958 0 3341.4 -383.4 2958 0.0 -2.20157491274953 -0.114742323576944 weekly                
44 Netherlands Netherlands 0 2020-02-24 2020-03-01 2020 8 17414806 3096 0 3322.2 -226.2 3096 0.0 -1.29889474508071 -0.0680874119559328 weekly                
45 Netherlands Netherlands 0 2020-03-02 2020-03-08 2020 9 17414806 3103 3 3333.4 -230.4 3100 0.0172267207570386 -1.32301215414056 -0.0691186176276475 weekly                
46 Netherlands Netherlands 0 2020-03-09 2020-03-15 2020 10 17414806 3216 17 3322.0 -106.0 3199 0.0976180842898853 -0.608677466748696 -0.0319084888621313 weekly                
47 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                
48 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                
49 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                
50 Netherlands Netherlands 0 2020-04-06 2020-04-12 2020 14 17414806 4977 971 2920.4 2056.6 4006 5.57571528502815 11.8094913029752 0.704218600191755 weekly                
51 Netherlands Netherlands 0 2020-04-13 2020-04-19 2020 15 17414806 4299 947 2874.0 1425.0 3352 5.43790151897185 8.18269235959333 0.495824634655532 weekly                
52 Netherlands Netherlands 0 2020-04-20 2020-04-26 2020 16 17414806 3905 791 2802.0 1103.0 3114 4.54211203960584 6.33369099833785 0.393647394718059 weekly                
53 Netherlands Netherlands 0 2020-04-27 2020-05-03 2020 17 17414806 3378 581 2732.6 645.4 2797 3.33624158661314 3.70604185886423 0.23618531801215 weekly                
54 Netherlands Netherlands 0 2020-05-04 2020-05-10 2020 18 17414806 2981 384 2736.0 245.0 2597 2.20502025690094 1.40684886182482 0.0895467836257311 weekly                
55 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                
56 Netherlands Netherlands 0 2020-05-18 2020-05-24 2020 20 17414806 2768 142 2703.4 64.5999999999999 2626 0.815398115833159 0.370948720301564 0.0238958348746023 weekly                
57 Netherlands Netherlands 0 2020-05-25 2020-05-31 2020 21 17414806 2724 134 2710.2 13.8000000000002 2590 0.76946019381439 0.0792429154823785 0.00509187513836618 weekly                
58 Netherlands Netherlands 0 2020-06-01 2020-06-07 2020 22 17414806 2681 57 2698.0 -17.0 2624 0.327307694383733 -0.0976180842898853 -0.00630096367679767 weekly                
59 Netherlands Netherlands 0 2020-06-08 2020-06-14 2020 23 17414806 2691 46 2644.0 47.0 2645 0.264143051607925 0.269885291860271 0.0177760968229954 weekly                
60 Netherlands Netherlands 0 2020-06-15 2020-06-21 2020 24 17414806 2690 31 2614.6 75.4000000000001 2659 0.178009447822732 0.432964915026904 0.0288380631836611 weekly                
61 Netherlands Netherlands 0 2020-06-22 2020-06-28 2020 25 17414806 2659 15 2641.4 17.5999999999999 2644 0.0861336037851929 0.101063428441292 0.00666313318694622 weekly                
62 Netherlands Netherlands 0 2020-06-29 2020-07-05 2020 26 17414806 2633 22 2698.4 -65.4000000000001 2611 0.126329285551616 -0.375542512503442 -0.0242365846427512 weekly                
63 Netherlands Netherlands 0 2020-07-06 2020-07-12 2020 27 17414806 2610 8 2692.6 -82.5999999999999 2602 0.0459379220187695 -0.474309044843795 -0.0306766693901804 weekly                
64 Netherlands Netherlands 0 2020-07-13 2020-07-19 2020 28 17414806 2519 1 2593.8 -74.8000000000002 2518 0.00574224025234619 -0.429519570875496 -0.0288379983036472 weekly                
65 Netherlands Netherlands 0 2020-07-20 2020-07-26 2020 29 17414806 2666 4 2737.2 -71.1999999999998 2662 0.0229689610093848 -0.408847505967048 -0.0260119830483705 weekly                
66 Netherlands Netherlands 0 2020-07-27 2020-08-02 2020 30 17414806 2640 0 2620.2 19.8000000000002 2640 0.0 0.113696356996456 0.00755667506297231 weekly                
67 Netherlands Netherlands 0 2020-08-03 2020-08-09 2020 31 17414806 2623 8 2588.4 34.5999999999999 2615 0.0459379220187695 0.198681512731178 0.0133673311698346 weekly                
68 Netherlands Netherlands 0 2020-08-10 2020-08-16 2020 32 17414806 3172 15 2620.2 551.8 3157 0.0861336037851929 3.16856817124463 0.21059461109839 weekly                
69 Netherlands Netherlands 0 2020-08-17 2020-08-23 2020 33 17414806 2828 28 2569.4 258.6 2800 0.160782727065693 1.48494332925673 0.100646065229236 weekly                
70 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                
71 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                
72 Portugal Portugal 0 2020-01-15 2020-01-21 2020 3 10276617 2704 0 2812.0 -108.0 2704 0.0 -1.05092950335699 -0.0384068278805121 weekly                
73 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                
74 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                
75 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                
76 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                
77 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                
78 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                
79 Portugal Portugal 0 2020-03-04 2020-03-10 2020 10 10276617 2217 0 2323.0 -106.0 2217 0.0 -1.03146784588742 -0.0456306500215239 weekly                
80 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                
81 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                
82 Portugal Portugal 0 2020-03-25 2020-03-31 2020 13 10276617 2594 127 2192.0 402.0 2467 1.23581524931794 3.91179315138435 0.183394160583942 weekly                
83 Portugal Portugal 0 2020-04-01 2020-04-07 2020 14 10276617 2670 185 2182.8 487.2 2485 1.80020331593558 4.7408597595882 0.223199560197911 weekly                
84 Portugal Portugal 0 2020-04-08 2020-04-14 2020 15 10276617 2561 222 2120.4 440.6 2339 2.1602439791227 4.28740314054713 0.207790982833428 weekly                
85 Portugal Portugal 0 2020-04-15 2020-04-21 2020 16 10276617 2341 195 2018.6 322.4 2146 1.89751160328345 3.13721918409531 0.1597146537204 weekly                
86 Portugal Portugal 0 2020-04-22 2020-04-28 2020 17 10276617 2279 211 1988.4 290.6 2068 2.05320486304005 2.82777883032908 0.146147656407162 weekly                
87 Portugal Portugal 0 2020-04-29 2020-05-05 2020 18 10276617 2176 101 1995.8 180.2 2075 0.982813702213481 1.75349533800861 0.090289608177172 weekly                
88 Portugal Portugal 0 2020-05-06 2020-05-12 2020 19 10276617 2158 89 1940.6 217.4 2069 0.866043757396038 2.11548216694268 0.112027208079975 weekly                
89 Portugal Portugal 0 2020-05-13 2020-05-19 2020 20 10276617 2025 84 1945.0 80.0 1941 0.817389613722103 0.778466298782955 0.0411311053984575 weekly                
90 Portugal Portugal 0 2020-05-20 2020-05-26 2020 21 10276617 2167 95 1937.2 229.8 2072 0.92442872980476 2.23614444325404 0.118624819326864 weekly                
91 Portugal Portugal 0 2020-05-27 2020-06-02 2020 22 10276617 2243 94 1917.0 326.0 2149 0.914697901069973 3.17225016754054 0.170057381324987 weekly                
92 Portugal Portugal 0 2020-06-03 2020-06-09 2020 23 10276617 1949 56 1893.0 56.0 1893 0.544926409148069 0.544926409148069 0.0295826730058109 weekly                
93 Portugal Portugal 0 2020-06-10 2020-06-16 2020 24 10276617 1893 30 1851.8 41.2 1863 0.291924862043608 0.400910143873222 0.0222486229614429 weekly                
94 Portugal Portugal 0 2020-06-17 2020-06-23 2020 25 10276617 2047 18 2027.4 19.5999999999999 2029 0.175154917226165 0.190724243201823 0.0096675545033047 weekly                
95 Portugal Portugal 0 2020-06-24 2020-06-30 2020 26 10276617 2076 36 1862.6 213.4 2040 0.35030983445233 2.07655885200353 0.11457102974337 weekly                
96 Portugal Portugal 0 2020-07-01 2020-07-07 2020 27 10276617 2080 53 1828.6 251.4 2027 0.515733922943708 2.44633034392544 0.137482226840206 weekly                
97 Portugal Portugal 0 2020-07-08 2020-07-14 2020 28 10276617 2361 39 1817.0 544.0 2322 0.379502320656691 5.2935708317241 0.299394606494221 weekly                
98 Portugal Portugal 0 2020-07-15 2020-07-21 2020 29 10276617 2665 29 1867.4 797.6 2636 0.282194033308821 7.76130899886607 0.427117917960801 weekly                
99 Portugal Portugal 0 2020-07-22 2020-07-28 2020 30 10276617 2339 25 1859.0 480.0 2314 0.243270718369674 4.67079779269773 0.258203335126412 weekly                
100 Portugal Portugal 0 2020-07-29 2020-08-04 2020 31 10276617 2165 17 1909.8 255.2 2148 0.165424088491378 2.48330749311763 0.133626557754739 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] 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);
Powered by Datasette · Query took 517.105ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette