⚠️ 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

15,280 rows

View and edit SQL

Suggested facets: month, covid_deaths_per_7_days, covid_deaths_per_100k_per_7_days, 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 Austria Austria 0 2019-12-30 2020-01-05 2020 1 8902600 1611 0 1740.71507760512 -129.715077605117 1611 0.0 -1.45704712786283 -0.0745182708382002 weekly                
2 Austria Austria 0 2020-01-06 2020-01-12 2020 2 8902600 1702 0 1781.98780487798 -79.9878048779844 1702 0.0 -0.898476904252515 -0.0448868419071259 weekly                
3 Austria Austria 0 2020-01-13 2020-01-19 2020 3 8902600 1797 0 1744.35144124162 52.6485587583802 1797 0.0 0.591384076094402 0.0301823116108444 weekly                
4 Austria Austria 0 2020-01-20 2020-01-26 2020 4 8902600 1779 0 1716.89689578708 62.1031042129246 1779 0.0 0.697583899230838 0.0361717144257836 weekly                
5 Austria Austria 0 2020-01-27 2020-02-02 2020 5 8902600 1947 0 1779.35144124162 167.64855875838 1947 0.0 1.883141540206 0.0942189130672217 weekly                
6 Austria Austria 0 2020-02-03 2020-02-09 2020 6 8902600 1681 0 1799.53325942344 -118.533259423439 1681 0.0 -1.33144541396265 -0.0658688906152345 weekly                
7 Austria Austria 0 2020-02-10 2020-02-16 2020 7 8902600 1721 0 1816.53325942344 -95.5332594234385 1721 0.0 -1.07309392114032 -0.0525909773068292 weekly                
8 Austria Austria 0 2020-02-17 2020-02-23 2020 8 8902600 1718 0 1796.80598669617 -78.8059866961655 1718 0.0 -0.885201926360451 -0.0438589292776501 weekly                
9 Austria Austria 0 2020-02-24 2020-03-01 2020 9 8902600 1768 0 1784.68658536579 -16.6865853657885 1768 0.0 -0.187434966928633 -0.00934986876834087 weekly                
10 Austria Austria 0 2020-03-02 2020-03-08 2020 10 8902600 1744 1 1757.08658536579 -13.086585365789 1743 0.0112326736009705 -0.146997341965145 -0.00744788872374469 weekly                
11 Austria Austria 0 2020-03-09 2020-03-15 2020 11 8902600 1718 15 1740.28658536579 -22.2865853657888 1703 0.168490104014558 -0.250337939094072 -0.0128062731467325 weekly                
12 Austria Austria 0 2020-03-16 2020-03-22 2020 12 8902600 1836 70 1666.18658536579 169.813414634212 1766 0.786287152067935 1.90745865965237 0.10191740596503 weekly                
13 Austria Austria 0 2020-03-23 2020-03-29 2020 13 8902600 1765 118 1662.78658536579 102.213414634211 1647 1.32545548491452 1.14812992422676 0.0614711566317609 weekly                
14 Austria Austria 0 2020-03-30 2020-04-05 2020 14 8902600 1828 146 1604.68658536579 223.313414634211 1682 1.63997034574169 2.50840669730429 0.139163258838677 weekly                
15 Austria Austria 0 2020-04-06 2020-04-12 2020 15 8902600 1793 102 1586.28658536579 206.713414634213 1691 1.14573270729899 2.3219443155282 0.130312779885576 weekly                
16 Austria Austria 0 2020-04-13 2020-04-19 2020 16 8902600 1704 90 1574.38658536579 129.613414634211 1614 1.01094062408735 1.45590518089335 0.0823262951037511 weekly                
17 Austria Austria 0 2020-04-20 2020-04-26 2020 17 8902600 1588 56 1541.48658536579 46.5134146342095 1532 0.629029721654348 0.522470004652681 0.0301743882014853 weekly                
18 Austria Austria 0 2020-04-27 2020-05-03 2020 18 8902600 1480 20 1522.78658536579 -42.7865853657877 1460 0.22465347201941 -0.480607747913954 -0.0280975586316384 weekly                
19 Austria Austria 0 2020-05-04 2020-05-10 2020 19 8902600 1520 11 1508.38658536579 11.6134146342108 1509 0.123559409610676 0.130449695978824 0.0076992295919911 weekly                
20 Austria Austria 0 2020-05-11 2020-05-17 2020 20 8902600 1489 11 1494.38658536579 -5.3865853657876 1478 0.123559409610676 -0.0605057552376564 -0.00360454611847916 weekly                
21 Austria Austria 0 2020-05-18 2020-05-24 2020 21 8902600 1481 28 1497.38658536579 -16.3865853657885 1453 0.314514860827174 -0.184065164848342 -0.0109434567705744 weekly                
22 Austria Austria 0 2020-05-25 2020-05-31 2020 22 8902600 1417 4 1477.48658536579 -60.4865853657884 1413 0.044930694403882 -0.67942607065114 -0.0409388389477753 weekly                
23 Austria Austria 0 2020-06-01 2020-06-07 2020 23 8902600 1490 5 1491.28658536579 -1.2865853657886 1485 0.0561633680048525 -0.0144517934736885 -0.000862735156618499 weekly                
24 Austria Austria 0 2020-06-08 2020-06-14 2020 24 8902600 1461 13 1473.78658536579 -12.7865853657879 1448 0.146024756812617 -0.143627539884842 -0.00867600878767283 weekly                
25 Austria Austria 0 2020-06-15 2020-06-21 2020 25 8902600 1413 12 1500.48658536579 -87.4865853657898 1401 0.134792083211646 -0.982708257877359 -0.0583054765161144 weekly                
26 Austria Austria 0 2020-06-22 2020-06-28 2020 26 8902600 1437 4 1478.88658536579 -41.8865853657869 1433 0.044930694403882 -0.470498341673072 -0.028323054506189 weekly                
27 Austria Austria 0 2020-06-29 2020-07-05 2020 27 8902600 1561 2 1507.98658536579 53.013414634212 1559 0.022465347201941 0.595482383059017 0.0351550969674923 weekly                
28 Austria Austria 0 2020-07-06 2020-07-12 2020 28 8902600 1383 3 1467.98658536579 -84.9865853657886 1380 0.0336980208029115 -0.95462657387492 -0.0578932983536848 weekly                
29 Austria Austria 0 2020-07-13 2020-07-19 2020 29 8902600 1443 1 1486.08658536579 -43.0865853657888 1442 0.0112326736009705 -0.483977549994258 -0.0289933209747556 weekly                
30 Austria Austria 0 2020-07-20 2020-07-26 2020 30 8902600 1452 6 1510.28658536579 -58.2865853657891 1446 0.067396041605823 -0.654714188729012 -0.0385930630190111 weekly                
31 Austria Austria 0 2020-07-27 2020-08-02 2020 31 8902600 1527 3 1514.48658536579 12.5134146342123 1524 0.0336980208029115 0.140559102219714 0.00826247967801574 weekly                
32 Austria Austria 0 2020-08-03 2020-08-09 2020 32 8902600 1433 7 1481.78658536579 -48.7865853657888 1426 0.0786287152067935 -0.54800378951979 -0.0329241645508254 weekly                
33 Austria Austria 0 2020-08-10 2020-08-16 2020 33 8902600 1607 4 1474.68658536579 132.313414634212 1603 0.044930694403882 1.48623339961598 0.0897230746839623 weekly                
34 Austria Austria 0 2020-08-17 2020-08-23 2020 34 8902600 1477 1 1495.68658536579 -18.6865853657887 1476 0.0112326736009705 -0.209900314130576 -0.0124936504402884 weekly                
35 Austria Austria 0 2020-08-24 2020-08-30 2020 35 8902600 1498 3 1446.58658536579 51.4134146342112 1495 0.0336980208029115 0.577510105297455 0.0355411941147032 weekly                
36 Austria Austria 0 2020-08-31 2020-09-06 2020 36 8902600 1522 20 1455.48658536579 66.5134146342116 1502 0.22465347201941 0.747123476672114 0.0456984044394306 weekly                
37 Austria Austria 0 2020-09-07 2020-09-13 2020 37 8902600 1568 10 1448.98658536579 119.013414634212 1558 0.112326736009705 1.33683884072307 0.0821356221211447 weekly                
38 Austria Austria 0 2020-09-14 2020-09-20 2020 38 8902600 1569 21 1492.58658536579 76.4134146342124 1548 0.235886145620381 0.85832694532173 0.0511952977357664 weekly                
39 Austria Austria 0 2020-09-21 2020-09-27 2020 39 8902600 1532 26 1507.48658536579 24.5134146342111 1506 0.292049513625233 0.275351185431347 0.0162611162660946 weekly                
40 Austria Austria 0 2020-09-28 2020-10-04 2020 40 8902600 1584 38 1534.78658536579 49.2134146342116 1546 0.426841596836879 0.552798223375324 0.0320653145547807 weekly                
41 Austria Austria 0 2020-10-05 2020-10-11 2020 41 8902600 1624 42 1551.58658536579 72.4134146342119 1582 0.471772291240761 0.813396250917843 0.0466705598754196 weekly                
42 Austria Austria 0 2020-10-12 2020-10-18 2020 42 8902600 1618 86 1544.38658536579 73.6134146342119 1532 0.966009929683463 0.826875459239008 0.0476651476591119 weekly                
43 Austria Austria 0 2020-10-19 2020-10-25 2020 43 8902600 1777 151 1544.58658536579 232.413414634212 1626 1.69613371374655 2.61062402707312 0.150469657600433 weekly                
44 Austria Austria 0 2020-10-26 2020-11-01 2020 44 8902600 1895 281 1557.18658536579 337.813414634212 1614 3.15638128187271 3.79454782461541 0.216938302582961 weekly                
45 Austria Austria 0 2020-11-02 2020-11-08 2020 45 8902600 2004 418 1551.08658536579 452.913414634211 1586 4.69525756520567 5.08742855608711 0.291997506075653 weekly                
46 Austria Austria 0 2020-11-09 2020-11-15 2020 46 8902600 2283 559 1570.18658536579 712.813414634212 1724 6.27906454294251 8.00680042497935 0.453967331830284 weekly                
47 Austria Austria 0 2020-11-16 2020-11-22 2020 47 8902600 2406 717 1581.98658536579 824.013414634212 1689 8.05382697189585 9.25587372940727 0.520872567603778 weekly                
48 Austria Austria 0 2020-11-23 2020-11-29 2020 48 8902600 2425 735 1585.08658536579 839.913414634211 1690 8.25601509671332 9.4344732396627 0.529884879721183 weekly                
49 Austria Austria 0 2020-11-30 2020-12-06 2020 49 8902600 2547 633 1639.38658536579 907.613414634212 1914 7.11028238941433 10.1949252424484 0.553629889823516 weekly                
50 Austria Austria 0 2020-12-07 2020-12-13 2020 50 8902600 2486 878 1664.88658536579 821.113414634211 1608 9.8622874216521 9.22329897596445 0.493194804890452 weekly                
51 Belgium Belgium 0 2020-01-01 2020-01-07 2020 1 11431406 2301 0 2353.93346774128 -52.9334677412771 2301 0.0 -0.463052994017334 -0.0224872403857996 weekly                
52 Belgium Belgium 0 2020-01-08 2020-01-14 2020 2 11431406 2357 0 2406.43346774172 -49.4334677417196 2357 0.0 -0.432435587903357 -0.0205422125333511 weekly                
53 Belgium Belgium 0 2020-01-15 2020-01-21 2020 3 11431406 2270 0 2334.43346774172 -64.4334677417187 2270 0.0 -0.563653042694124 -0.0276013296725266 weekly                
54 Belgium Belgium 0 2020-01-22 2020-01-28 2020 4 11431406 2210 0 2343.93346774172 -133.93346774172 2210 0.0 -1.1716272498914 -0.0571404733047988 weekly                
55 Belgium Belgium 0 2020-01-29 2020-02-04 2020 5 11431406 2347 0 2496.68346774172 -149.68346774172 2347 0.0 -1.30940557742171 -0.0599529214158293 weekly                
56 Belgium Belgium 0 2020-02-05 2020-02-11 2020 6 11431406 2192 0 2417.68346774172 -225.68346774172 2192 0.0 -1.97424068169497 -0.0933469872102501 weekly                
57 Belgium Belgium 0 2020-02-12 2020-02-18 2020 7 11431406 2251 0 2425.43346774172 -174.433467741719 2251 0.0 -1.52591437782648 -0.0719184715069225 weekly                
58 Belgium Belgium 0 2020-02-19 2020-02-25 2020 8 11431406 2353 0 2416.18346774172 -63.1834677417191 2353 0.0 -0.552718254794897 -0.0261501117714267 weekly                
59 Belgium Belgium 0 2020-02-26 2020-03-03 2020 9 11431406 2223 0 2528.91129032234 -305.911290322342 2223 0.0 -2.67606006052398 -0.120965607410986 weekly                
60 Belgium Belgium 0 2020-03-04 2020-03-10 2020 10 11431406 2182 1 2449.91129032234 -267.911290322341 2181 0.00874783031938503 -2.34364250838734 -0.109355506617993 weekly                
61 Belgium Belgium 0 2020-03-11 2020-03-17 2020 11 11431406 2268 40 2318.57795698901 -50.5779569890083 2228 0.349913212775401 -0.442447385640999 -0.0218142145432499 weekly                
62 Belgium Belgium 0 2020-03-18 2020-03-24 2020 12 11431406 2715 332 2246.91129032234 468.088709677658 2383 2.90427966603583 4.09476060668004 0.208325407279656 weekly                
63 Belgium Belgium 0 2020-03-25 2020-03-31 2020 13 11431406 3437 1005 2141.24462365567 1295.75537634433 2432 8.79156947098196 11.3350481676911 0.605141216481901 weekly                
64 Belgium Belgium 0 2020-04-01 2020-04-07 2020 14 11431406 4130 1740 2050.57795698901 2079.42204301099 2390 15.22122475573 18.1904311946491 1.01406632014339 weekly                
65 Belgium Belgium 0 2020-04-08 2020-04-14 2020 15 11431406 4201 1983 1988.24462365568 2212.75537634432 2218 17.3469475233405 19.3568085705671 1.11291907948221 weekly                
66 Belgium Belgium 0 2020-04-15 2020-04-21 2020 16 11431406 3537 1538 1977.91129032234 1559.08870967766 1999 13.4541630312142 13.6386434851291 0.788250068294809 weekly                
67 Belgium Belgium 0 2020-04-22 2020-04-28 2020 17 11431406 2864 1033 1967.91129032234 896.088709677658 1831 9.03650871992474 7.83883198337683 0.455350154290176 weekly                
68 Belgium Belgium 0 2020-04-29 2020-05-05 2020 18 11431406 2329 632 1938.57795698901 390.422043010992 1697 5.52862876185134 3.4153457852078 0.201396101510095 weekly                
69 Belgium Belgium 0 2020-05-06 2020-05-12 2020 19 11431406 2306 474 1955.57795698901 350.422043010991 1832 4.14647157138851 3.0654325724324 0.179191037492841 weekly                
70 Belgium Belgium 0 2020-05-13 2020-05-19 2020 20 11431406 1997 275 1962.24462365568 34.7553763443241 1722 2.40565333783088 0.304034134946516 0.0177120507429775 weekly                
71 Belgium Belgium 0 2020-05-20 2020-05-26 2020 21 11431406 2074 213 1902.91129032234 171.088709677658 1861 1.86328785802901 1.49665500182268 0.089908925627677 weekly                
72 Belgium Belgium 0 2020-05-27 2020-06-02 2020 22 11431406 1927 155 1940.57795698901 -13.5779569890076 1772 1.35591369950468 -0.118777663823747 -0.00699686242446818 weekly                
73 Belgium Belgium 0 2020-06-03 2020-06-09 2020 23 11431406 1787 90 1799.57795698901 -12.5779569890083 1697 0.787304728744653 -0.110029833504367 -0.00698939267407639 weekly                
74 Belgium Belgium 0 2020-06-10 2020-06-16 2020 24 11431406 1936 52 1767.57795698901 168.422043010991 1884 0.454887176608022 1.47332745430432 0.0952840820089718 weekly                
75 Belgium Belgium 0 2020-06-17 2020-06-23 2020 25 11431406 1790 44 1890.24462365568 -100.244623655675 1746 0.384904534052942 -0.876922958170456 -0.0530326193769592 weekly                
76 Belgium Belgium 0 2020-06-24 2020-06-30 2020 26 11431406 1923 34 1873.24462365567 49.7553763443259 1889 0.297426230859091 0.435251589737307 0.0265610672071368 weekly                
77 Belgium Belgium 0 2020-07-01 2020-07-07 2020 27 11431406 1728 18 1901.91129032234 -173.911290322342 1710 0.157460945748931 -1.52134645836516 -0.0914402744267149 weekly                
78 Belgium Belgium 0 2020-07-08 2020-07-14 2020 28 11431406 1684 12 1772.57795698901 -88.5779569890087 1672 0.10497396383262 -0.774864937777634 -0.0499712617093986 weekly                
79 Belgium Belgium 0 2020-07-15 2020-07-21 2020 29 11431406 1859 19 1847.24462365567 11.7553763443252 1840 0.166208776068316 0.10283403760067 0.00636373558422454 weekly                
80 Belgium Belgium 0 2020-07-22 2020-07-28 2020 30 11431406 1844 17 2048.91129032234 -204.911290322342 1827 0.148713115429546 -1.79252919826609 -0.10000984000147 weekly                
81 Belgium Belgium 0 2020-07-29 2020-08-04 2020 31 11431406 1932 23 1913.24462365567 18.7553763443254 1909 0.201200097345856 0.164068849836367 0.00980291600584193 weekly                
82 Belgium Belgium 0 2020-08-05 2020-08-11 2020 32 11431406 2294 46 1794.24462365568 499.755376344324 2248 0.402400194691712 4.37177523346055 0.278532464166508 weekly                
83 Belgium Belgium 0 2020-08-12 2020-08-18 2020 33 11431406 2735 69 1781.91129032234 953.088709677658 2666 0.603600292037567 8.33745831158178 0.53486877537279 weekly                
84 Belgium Belgium 0 2020-08-19 2020-08-25 2020 34 11431406 2110 34 1830.57795698901 279.422043010992 2076 0.297426230859091 2.44433661975606 0.152641433239256 weekly                
85 Belgium Belgium 0 2020-08-26 2020-09-01 2020 35 11431406 1833 24 1863.57795698901 -30.577956989009 1809 0.209947927665241 -0.267490779253304 -0.0164081984734429 weekly                
86 Belgium Belgium 0 2020-09-02 2020-09-08 2020 36 11431406 1876 18 1817.91129032234 58.0887096776578 1858 0.157460945748931 0.50815017573217 0.0319535447009396 weekly                
87 Belgium Belgium 0 2020-09-09 2020-09-15 2020 37 11431406 1889 19 1767.91129032234 121.088709677659 1870 0.166208776068316 1.05926348585343 0.0684925258074349 weekly                
88 Belgium Belgium 0 2020-09-16 2020-09-22 2020 38 11431406 1909 24 1897.57795698901 11.4220430109915 1885 0.209947927665241 0.0999180941608714 0.0060192747122314 weekly                
89 Belgium Belgium 0 2020-09-23 2020-09-29 2020 39 11431406 1955 58 1831.24462365568 123.755376344325 1897 0.507374158524332 1.08259103337179 0.0675799261036325 weekly                
90 Belgium Belgium 0 2020-09-30 2020-10-06 2020 40 11431406 1906 93 1936.91129032234 -30.9112903223413 1813 0.813548219702808 -0.27040672269309 -0.0159590635238628 weekly                
91 Belgium Belgium 0 2020-10-07 2020-10-13 2020 41 11431406 2099 177 1951.24462365568 147.755376344325 1922 1.54836596653115 1.29253896103703 0.0757236558415233 weekly                
92 Belgium Belgium 0 2020-10-14 2020-10-20 2020 42 11431406 2183 270 1942.57795698901 240.422043010992 1913 2.36191418623396 2.10317123730004 0.123764424560673 weekly                
93 Belgium Belgium 0 2020-10-21 2020-10-27 2020 43 11431406 2857 650 1900.24462365568 956.755376344325 2207 5.68608970760027 8.36953368941953 0.503490637170559 weekly                
94 Belgium Belgium 0 2020-10-28 2020-11-03 2020 44 11431406 3405 1187 1880.57795698901 1524.42204301099 2218 10.38367458911 13.3353853673904 0.810613586820799 weekly                
95 Belgium Belgium 0 2020-11-04 2020-11-10 2020 45 11431406 3685 1448 1927.24462365568 1757.75537634432 2237 12.6668583024695 15.3765457752469 0.912056183615209 weekly                
96 Belgium Belgium 0 2020-11-11 2020-11-17 2020 46 11431406 3313 1274 2002.57795698901 1310.42204301099 2039 11.1447358268965 11.463349679042 0.65436755579857 weekly                
97 Belgium Belgium 0 2020-11-18 2020-11-24 2020 47 11431406 3020 1036 2069.24462365568 950.755376344325 1984 9.0627522108829 8.31704670750321 0.4594697821008 weekly                
98 Belgium Belgium 0 2020-11-25 2020-12-01 2020 48 11431406 2786 824 2035.57795698901 750.422043010992 1962 7.20821218317327 6.56456470018641 0.368653060146614 weekly                
99 Belgium Belgium 0 2020-12-02 2020-12-08 2020 49 11431406 2719 683 2153.57795698901 565.422043010991 2036 5.97476810813998 4.94621609110018 0.262550069838905 weekly                
100 Belgium Belgium 0 2020-12-09 2020-12-15 2020 50 11431406 2751 676 2216.91129032234 534.088709677658 2075 5.91353329590428 4.67211740775945 0.240915688421615 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);