economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
139 rows where "start_date" is on date 2020-01-01 sorted by expected_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
country 20
- Algeria 2
- Argentina 2
- Azerbaijan 2
- Belarus 2
- Brazil 2
- Cuba 2
- Egypt 2
- Georgia 2
- Hong Kong 2
- Japan 2
- Kazakhstan 2
- Malaysia 2
- Philippines 2
- Russia 2
- Serbia 2
- Taiwan 2
- Thailand 2
- Ukraine 2
- Uzbekistan 2
- Tunisia 1
cadence 1
- monthly 39
Link | rowid | country | region | region_code | start_date | end_date | days | 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 | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11071 | 11071 | Georgia | Georgia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3744385 | 4630 | 0 | 4601.03104816644 | 28.9689518335636 | 4630 | 0.0 | 0.773663814847126 | 0.0062961869916327 | monthly | 1 | 1045.48387096774 | 0.0 | 1038.94249474726 | 6.54137622048209 | 1045.48387096774 | 0.0 | 0.174698280771932 | ||
21894 | 21894 | Georgia | Georgia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3744385 | 4630 | 0 | 4601.03104816644 | 28.9689518335636 | 4630 | 0.0 | 0.773663814847127 | 0.00629618699163181 | monthly | 1 | 1045.48387096774 | 0.0 | 1038.94249474726 | 6.54137622048209 | 1045.48387096774 | 0.0 | 0.174698280771932 | ||
600 | 600 | Hong Kong | Hong Kong | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 7488863 | 4749 | 0 | 4726.74692270266 | 22.2530772973414 | 4749 | 0.0 | 0.297148943669305 | 0.00470790538635768 | monthly | 1 | 1072.35483870968 | 0.0 | 1067.3299502877 | 5.02488842198032 | 1072.35483870968 | 0.0 | 0.0670981485704882 | ||
21970 | 21970 | Hong Kong | Hong Kong | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 7488863 | 4749 | 0 | 4726.74692270266 | 22.2530772973414 | 4749 | 0.0 | 0.297148943669305 | 0.00470790538635724 | monthly | 1 | 1072.35483870968 | 0.0 | 1067.3299502877 | 5.02488842198032 | 1072.35483870968 | 0.0 | 0.0670981485704882 | ||
21455 | 21455 | Azerbaijan | Azerbaijan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 10358078 | 5177 | 0 | 5394.49563872163 | -217.495638721633 | 5177 | 0.0 | -2.09976830374933 | -0.0403180673945583 | monthly | 1 | 1169.0 | 0.0 | 1218.11191842101 | -49.1119184210138 | 1169.0 | 0.0 | -0.474141229878881 | ||
24185 | 24185 | Azerbaijan | Azerbaijan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 10358078 | 5177 | 0 | 5394.49563872163 | -217.495638721633 | 5177 | 0.0 | -2.09976830374933 | -0.0403180673945588 | monthly | 1 | 1169.0 | 0.0 | 1218.11191842101 | -49.1119184210138 | 1169.0 | 0.0 | -0.474141229878881 | ||
2100 | 2100 | Tunisia | Tunisia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 12356116 | 7465 | 0 | 7640.72106671526 | -175.721066715256 | 7465 | 0.0 | -1.42213837030387 | -0.0229979690635138 | monthly | 1 | 1685.64516129032 | 0.0 | 1725.32411183893 | -39.6789505486061 | 1685.64516129032 | 0.0 | -0.321128019100874 | ||
19098 | 19098 | Cuba | Cuba | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 11212198 | 9920 | 0 | 9952.74142720298 | -32.7414272029837 | 9920 | 0.0 | -0.292016134597192 | -0.00328968932253126 | monthly | 1 | 2240.0 | 0.0 | 2247.39322549745 | -7.39322549744793 | 2240.0 | 0.0 | -0.0659391271671079 | ||
21749 | 21749 | Cuba | Cuba | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 11212198 | 9920 | 0 | 9952.74142720298 | -32.7414272029837 | 9920 | 0.0 | -0.292016134597192 | -0.00328968932253082 | monthly | 1 | 2240.0 | 0.0 | 2247.39322549745 | -7.39322549744793 | 2240.0 | 0.0 | -0.0659391271671079 | ||
10211 | 10211 | Serbia | Serbia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 6871547 | 9886 | 0 | 10281.9246206593 | -395.924620659258 | 9886 | 0.0 | -5.76179746219094 | -0.0385068589069146 | monthly | 1 | 2232.32258064516 | 0.0 | 2321.72491434241 | -89.4023336972518 | 2232.32258064516 | 0.0 | -1.30105103984957 | ||
22841 | 22841 | Serbia | Serbia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 6871547 | 9886 | 0 | 10281.9246206593 | -395.924620659258 | 9886 | 0.0 | -5.76179746219094 | -0.0385068589069185 | monthly | 1 | 2232.32258064516 | 0.0 | 2321.72491434241 | -89.4023336972518 | 2232.32258064516 | 0.0 | -1.30105103984957 | ||
23071 | 23071 | Uzbekistan | Uzbekistan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 34627648 | 11136 | 0 | 10482.4824674633 | 653.517532536678 | 11136 | 0.0 | 1.88727092448404 | 0.0623437753952998 | monthly | 1 | 2514.58064516129 | 0.0 | 2367.01217007236 | 147.568475088927 | 2514.58064516129 | 0.0 | 0.426157950689944 | ||
24470 | 24470 | Uzbekistan | Uzbekistan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 34627648 | 11136 | 0 | 10482.4824674633 | 653.517532536678 | 11136 | 0.0 | 1.88727092448404 | 0.0623437753952976 | monthly | 1 | 2514.58064516129 | 0.0 | 2367.01217007236 | 147.568475088927 | 2514.58064516129 | 0.0 | 0.426157950689944 | ||
21546 | 21546 | Belarus | Belarus | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 9534956 | 10725 | 0 | 11317.0601433741 | -592.060143374085 | 10725 | 0.0 | -6.20936418976747 | -0.0523157194424506 | monthly | 1 | 2421.77419354839 | 0.0 | 2555.46519366512 | -133.691000116729 | 2421.77419354839 | 0.0 | -1.40211449446362 | ||
24363 | 24363 | Belarus | Belarus | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 9534956 | 10725 | 0 | 11317.0601433741 | -592.060143374085 | 10725 | 0.0 | -6.20936418976747 | -0.0523157194424494 | monthly | 1 | 2421.77419354839 | 0.0 | 2555.46519366512 | -133.691000116729 | 2421.77419354839 | 0.0 | -1.40211449446362 | ||
380 | 380 | Kazakhstan | Kazakhstan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 19397998 | 11867 | 0 | 12193.7762938636 | -326.776293863633 | 11867 | 0.0 | -1.68458772840183 | -0.0267986131603939 | monthly | 1 | 2679.64516129032 | 0.0 | 2753.43335667889 | -73.7881953885624 | 2679.64516129032 | 0.0 | -0.380390777381059 | ||
22118 | 22118 | Kazakhstan | Kazakhstan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 19397998 | 11867 | 0 | 12193.7762938636 | -326.776293863633 | 11867 | 0.0 | -1.68458772840183 | -0.0267986131603913 | monthly | 1 | 2679.64516129032 | 0.0 | 2753.43335667889 | -73.7881953885624 | 2679.64516129032 | 0.0 | -0.380390777381059 | ||
19273 | 19273 | Taiwan | Taiwan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 23893396 | 14673 | 0 | 15473.708385027 | -800.708385026985 | 14673 | 0.0 | -3.35117027745652 | -0.0517463794135984 | monthly | 1 | 3313.25806451613 | 0.0 | 3494.06318371577 | -180.805119199642 | 3313.25806451613 | 0.0 | -0.756715869103085 | ||
22944 | 22944 | Taiwan | Taiwan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 23893396 | 14673 | 0 | 15473.708385027 | -800.708385026985 | 14673 | 0.0 | -3.35117027745652 | -0.0517463794135993 | monthly | 1 | 3313.25806451613 | 0.0 | 3494.06318371577 | -180.805119199642 | 3313.25806451613 | 0.0 | -0.756715869103085 | ||
10178 | 10178 | Malaysia | Malaysia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 33938216 | 16028 | 0 | 15557.5768731374 | 470.423126862621 | 16028 | 0.0 | 1.38611624978349 | 0.0302375576028733 | monthly | 1 | 3619.22580645161 | 0.0 | 3513.00122941812 | 106.224577033495 | 3619.22580645161 | 0.0 | 0.312993991886595 | ||
22330 | 22330 | Malaysia | Malaysia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 33938216 | 16028 | 0 | 15557.5768731374 | 470.423126862621 | 16028 | 0.0 | 1.38611624978349 | 0.0302375576028719 | monthly | 1 | 3619.22580645161 | 0.0 | 3513.00122941812 | 106.224577033495 | 3619.22580645161 | 0.0 | 0.312993991886595 | ||
18908 | 18908 | Algeria | Algeria | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 44903228 | 17195 | 0 | 17369.0507215846 | -174.050721584612 | 17195 | 0.0 | -0.387612938616823 | -0.0100207388633116 | monthly | 1 | 3882.74193548387 | 0.0 | 3922.04371132556 | -39.3017758416866 | 3882.74193548387 | 0.0 | -0.0875255022683148 | ||
21337 | 21337 | Algeria | Algeria | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 44903228 | 17195 | 0 | 17369.0507215846 | -174.050721584612 | 17195 | 0.0 | -0.387612938616823 | -0.0100207388633109 | monthly | 1 | 3882.74193548387 | 0.0 | 3922.04371132556 | -39.3017758416866 | 3882.74193548387 | 0.0 | -0.0875255022683148 | ||
19308 | 19308 | Argentina | Argentina | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 45510324 | 25791 | 0 | 26393.106378094 | -602.106378094013 | 25791 | 0.0 | -1.32301052854296 | -0.0228130167578059 | monthly | 1 | 5823.77419354839 | 0.0 | 5959.73369827929 | -135.959504730906 | 5823.77419354839 | 0.0 | -0.298744312896797 | ||
21385 | 21385 | Argentina | Argentina | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 45510324 | 25791 | 0 | 26393.106378094 | -602.106378094013 | 25791 | 0.0 | -1.32301052854296 | -0.0228130167578053 | monthly | 1 | 5823.77419354839 | 0.0 | 5959.73369827929 | -135.959504730906 | 5823.77419354839 | 0.0 | -0.298744312896797 | ||
10395 | 10395 | Thailand | Thailand | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 71697024 | 47125 | 0 | 45206.7964445356 | 1918.20355546442 | 47125 | 0.0 | 2.67542981346677 | 0.0424317515579296 | monthly | 1 | 10641.1290322581 | 0.0 | 10207.9862939274 | 433.142738330676 | 10641.1290322581 | 0.0 | 0.604129312718303 | ||
22979 | 22979 | Thailand | Thailand | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 71697024 | 47125 | 0 | 45206.7964445356 | 1918.20355546442 | 47125 | 0.0 | 2.67542981346676 | 0.0424317515579291 | monthly | 1 | 10641.1290322581 | 0.0 | 10207.9862939274 | 433.142738330676 | 10641.1290322581 | 0.0 | 0.604129312718303 | ||
19474 | 19474 | Philippines | Philippines | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 115559008 | 53500 | 0 | 54744.0875973053 | -1244.08759730526 | 53500 | 0.0 | -1.07658210193814 | -0.022725515245714 | monthly | 1 | 12080.6451612903 | 0.0 | 12361.5681671334 | -280.923005843123 | 12080.6451612903 | 0.0 | -0.243099184308612 | ||
22653 | 22653 | Philippines | Philippines | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 115559008 | 53500 | 0 | 54744.0875973053 | -1244.08759730526 | 53500 | 0.0 | -1.07658210193814 | -0.0227255152457146 | monthly | 1 | 12080.6451612903 | 0.0 | 12361.5681671334 | -280.923005843123 | 12080.6451612903 | 0.0 | -0.243099184308612 | ||
20260 | 20260 | Ukraine | Ukraine | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 39701744 | 53610 | 0 | 55838.8734423464 | -2228.8734423464 | 53610 | 0.0 | -5.61404416477625 | -0.0399161606411654 | monthly | 1 | 12105.4838709677 | 0.0 | 12608.7778740782 | -503.294003110479 | 12105.4838709677 | 0.0 | -1.26768739204625 | ||
23014 | 23014 | Ukraine | Ukraine | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 39701744 | 53610 | 0 | 55838.8734423464 | -2228.8734423464 | 53610 | 0.0 | -5.61404416477624 | -0.0399161606411653 | monthly | 1 | 12105.4838709677 | 0.0 | 12608.7778740782 | -503.294003110479 | 12105.4838709677 | 0.0 | -1.26768739204625 | ||
10656 | 10656 | Egypt | Egypt | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 110990096 | 56964 | 0 | 58232.6215912547 | -1268.62159125468 | 56964 | 0.0 | -1.14300431928149 | -0.0217854109361478 | monthly | 1 | 12862.8387096774 | 0.0 | 13149.3016496382 | -286.462939960733 | 12862.8387096774 | 0.0 | -0.258097749515176 | ||
21795 | 21795 | Egypt | Egypt | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 110990096 | 56964 | 0 | 58232.6215912547 | -1268.62159125468 | 56964 | 0.0 | -1.1430043192815 | -0.0217854109361482 | monthly | 1 | 12862.8387096774 | 0.0 | 13149.3016496382 | -286.462939960733 | 12862.8387096774 | 0.0 | -0.258097749515176 | ||
413 | 413 | Brazil | Brazil | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 215313504 | 110932 | 0 | 111661.575161922 | -729.575161922316 | 110932 | 0.0 | -0.338843197648354 | -0.0065338068253501 | monthly | 1 | 25049.1612903226 | 0.0 | 25213.9040688212 | -164.742778498587 | 25049.1612903226 | 0.0 | -0.0765129801141444 | ||
21667 | 21667 | Brazil | Brazil | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 215313504 | 110932 | 0 | 111661.575161922 | -729.575161922316 | 110932 | 0.0 | -0.338843197648354 | -0.00653380682534732 | monthly | 1 | 25049.1612903226 | 0.0 | 25213.9040688212 | -164.742778498587 | 25049.1612903226 | 0.0 | -0.0765129801141444 | ||
301 | 301 | Japan | Japan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 123951696 | 132622 | 0 | 138539.830632335 | -5917.83063233504 | 132622 | 0.0 | -4.77430388071095 | -0.0427157345676286 | monthly | 1 | 29946.9032258065 | 0.0 | 31283.1875621402 | -1336.28433633372 | 29946.9032258065 | 0.0 | -1.07806861822505 | ||
22060 | 22060 | Japan | Japan | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 123951696 | 132622 | 0 | 138539.830632335 | -5917.83063233504 | 132622 | 0.0 | -4.77430388071095 | -0.0427157345676283 | monthly | 1 | 29946.9032258065 | 0.0 | 31283.1875621402 | -1336.28433633372 | 29946.9032258065 | 0.0 | -1.07806861822505 | ||
22717 | 22717 | Russia | Russia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 144713312 | 161007.1 | 0 | 165319.386198611 | -4312.28619861128 | 161007.1 | 0.0 | -2.97988218154476 | -0.026084576635376 | monthly | 1 | 36356.4419354839 | 0.0 | 37330.1839803316 | -973.742044847709 | 36356.4419354839 | 0.0 | -0.672876621639141 | ||
24378 | 24378 | Russia | Russia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 144713312 | 161007.1 | 0 | 165319.386198611 | -4312.28619861128 | 161007.1 | 0.0 | -2.97988218154477 | -0.0260845766353778 | monthly | 1 | 36356.4419354839 | 0.0 | 37330.1839803316 | -973.742044847709 | 36356.4419354839 | 0.0 | -0.672876621639141 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_deaths] ( [country] TEXT, [region] TEXT, [region_code] INTEGER, [start_date] TEXT, [end_date] TEXT, [days] INTEGER, [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, [quarter] INTEGER);