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 end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country >30
- Mongolia 2
- Paraguay 2
- Russia 2
- Seychelles 2
- Suriname 2
- Uruguay 2
- Uzbekistan 2
- Aruba 1
- Azerbaijan 1
- Belarus 1
- Belize 1
- Bolivia 1
- Bosnia and Herzegovina 1
- Indonesia 1
- Macao 1
- Maldives 1
- Nicaragua 1
- North Macedonia 1
- Oman 1
- Palestine 1
- Panama 1
- Philippines 1
- Qatar 1
- Saint Kitts and Nevis 1
- Saint Vincent and the Grenadines 1
- San Marino 1
- Serbia 1
- Singapore 1
- Taiwan 1
- Thailand 1
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22471 | 22471 | Mongolia | Mongolia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3398373 | 1366 | 0 | 1455.56719880799 | -89.5671988079919 | 1366 | 0.0 | -2.63559058431761 | -0.0615342245149104 | monthly | 1 | 308.451612903226 | 0.0 | 328.676464246966 | -20.2248513437401 | 308.451612903226 | 0.0 | -0.595133357749138 | ||
22506 | 22506 | Nicaragua | Nicaragua | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 6948395 | 2143 | 0 | 2180.48040503556 | -37.4804050355606 | 2143 | 0.0 | -0.539410972398095 | -0.0171890584061217 | monthly | 1 | 483.903225806452 | 0.0 | 492.366543072546 | -8.46331726609432 | 483.903225806452 | 0.0 | -0.121802477638279 | ||
22518 | 22518 | North Macedonia | North Macedonia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 2093606 | 1774 | 0 | 1979.40749635104 | -205.407496351042 | 1774 | 0.0 | -9.81118206343706 | -0.103772213013086 | monthly | 1 | 400.58064516129 | 0.0 | 446.962983047009 | -46.3823378857192 | 400.58064516129 | 0.0 | -2.21542820787288 | ||
22551 | 22551 | Oman | Oman | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 4576300 | 845 | 0 | 862.640897342327 | -17.6408973423272 | 845 | 0.0 | -0.385483848137736 | -0.0204498736341808 | monthly | 1 | 190.806451612903 | 0.0 | 194.789880045042 | -3.9834284321384 | 190.806451612903 | 0.0 | -0.0870447399020694 | ||
22585 | 22585 | Palestine | Palestine | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 5250076 | 1329 | 0 | 1340.12270571079 | -11.1227057107853 | 1329 | 0.0 | -0.211857994261136 | -0.00829976662837784 | monthly | 1 | 300.096774193548 | 0.0 | 302.608352902435 | -2.51157870888701 | 300.096774193548 | 0.0 | -0.0478389019299342 | ||
22597 | 22597 | Panama | Panama | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 4408582 | 2032 | 0 | 1842.6464240102 | 189.3535759898 | 2032 | 0.0 | 4.29511294084583 | 0.102761752619748 | monthly | 1 | 458.838709677419 | 0.0 | 416.081450582948 | 42.7572590944709 | 458.838709677419 | 0.0 | 0.969864212449057 | ||
22619 | 22619 | Paraguay | Paraguay | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 6780745 | 2863 | 0 | 2834.61254181107 | 28.3874581889349 | 2863 | 0.0 | 0.418648071693227 | 0.0100145814534471 | monthly | 1 | 646.483870967742 | 0.0 | 640.073799763789 | 6.41007120395305 | 646.483870967742 | 0.0 | 0.094533435543632 | ||
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 | ||
22683 | 22683 | Qatar | Qatar | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 2695131 | 192 | 0 | 193.053813932981 | -1.0538139329808 | 192 | 0.0 | -0.0391006571844114 | -0.00545865378938759 | monthly | 1 | 43.3548387096774 | 0.0 | 43.5927966945441 | -0.237957984866633 | 43.3548387096774 | 0.0 | -0.00882918065454454 | ||
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 | ||
22751 | 22751 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 47681 | 29 | 0 | 33.3548017827832 | -4.35480178278316 | 29 | 0.0 | -9.1332014487598 | -0.130559965882664 | monthly | 1 | 6.54838709677419 | 0.0 | 7.531729434822 | -0.983342338047811 | 6.54838709677419 | 0.0 | -2.06233581101028 | ||
22783 | 22783 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 103959 | 93 | 0 | 86.8657635467966 | 6.13423645320341 | 93 | 0.0 | 5.90063049202417 | 0.0706174239739312 | monthly | 1 | 21.0 | 0.0 | 19.6148498331476 | 1.38515016685238 | 21.0 | 0.0 | 1.33240043368288 | ||
22807 | 22807 | San Marino | San Marino | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 33690 | 23 | 0 | 24.2110518153622 | -1.21105181536221 | 23 | 0.0 | -3.59469223912796 | -0.0500206196987185 | monthly | 1 | 5.19354838709677 | 0.0 | 5.46701170024308 | -0.273463313146307 | 5.19354838709677 | 0.0 | -0.81170469915793 | ||
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 | ||
22875 | 22875 | Seychelles | Seychelles | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 107135 | 65 | 0 | 67.3473605789687 | -2.3473605789687 | 65 | 0.0 | -2.19103054927773 | -0.0348545296918694 | monthly | 1 | 14.6774193548387 | 0.0 | 15.2074685178316 | -0.530049162992933 | 14.6774193548387 | 0.0 | -0.494748833707876 | ||
22899 | 22899 | Singapore | Singapore | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 5637022 | 2091 | 0 | 1934.44849860122 | 156.551501398781 | 2091 | 0.0 | 2.77720224258094 | 0.0809282343324109 | monthly | 1 | 472.161290322581 | 0.0 | 436.81095129705 | 35.3503390255311 | 472.161290322581 | 0.0 | 0.627110183808598 | ||
22932 | 22932 | Suriname | Suriname | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 618046 | 329 | 0 | 364.684247096024 | -35.6842470960241 | 329 | 0.0 | -5.77372025642494 | -0.0978497080150218 | monthly | 1 | 74.2903225806452 | 0.0 | 82.3480557958764 | -8.05773321523125 | 74.2903225806452 | 0.0 | -1.30374328370886 | ||
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 | ||
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 | ||
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 | ||
23039 | 23039 | Uruguay | Uruguay | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3422796 | 2546 | 0 | 2644.3994078027 | -98.3994078027026 | 2546 | 0.0 | -2.87482537091613 | -0.0372104938128324 | monthly | 1 | 574.903225806452 | 0.0 | 597.122446923191 | -22.2192211167393 | 574.903225806452 | 0.0 | -0.649154116013321 | ||
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 | ||
23104 | 23104 | Maldives | Maldives | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 523798 | 114 | 0 | 104.983464848264 | 9.01653515173628 | 114 | 0.0 | 1.72137639924862 | 0.085885288362012 | monthly | 1 | 25.741935483871 | 0.0 | 23.7059436754144 | 2.03599180845658 | 25.741935483871 | 0.0 | 0.388697896604527 | ||
23267 | 23267 | Uruguay | Uruguay | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3422796 | 2546 | 0 | 2644.3994078027 | -98.3994078027026 | 2546 | 0.0 | -2.87482537091614 | -0.0372104938128334 | monthly | 1 | 574.903225806452 | 0.0 | 597.122446923191 | -22.2192211167393 | 574.903225806452 | 0.0 | -0.649154116013321 | ||
23299 | 23299 | Suriname | Suriname | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 618046 | 329 | 0 | 364.684247096024 | -35.6842470960241 | 329 | 0.0 | -5.77372025642494 | -0.097849708015022 | monthly | 1 | 74.2903225806452 | 0.0 | 82.3480557958764 | -8.05773321523125 | 74.2903225806452 | 0.0 | -1.30374328370886 | ||
23611 | 23611 | Seychelles | Seychelles | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 107135 | 65 | 0 | 67.3473605789687 | -2.3473605789687 | 65 | 0.0 | -2.19103054927774 | -0.0348545296918694 | monthly | 1 | 14.6774193548387 | 0.0 | 15.2074685178316 | -0.530049162992933 | 14.6774193548387 | 0.0 | -0.494748833707876 | ||
23635 | 23635 | Paraguay | Paraguay | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 6780745 | 2863 | 0 | 2834.61254181107 | 28.3874581889349 | 2863 | 0.0 | 0.418648071693228 | 0.0100145814534489 | monthly | 1 | 646.483870967742 | 0.0 | 640.073799763789 | 6.41007120395305 | 646.483870967742 | 0.0 | 0.094533435543632 | ||
23823 | 23823 | Bolivia | Bolivia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 12224114 | 4717 | 0 | 4547.34808733194 | 169.651912668056 | 4717 | 0.0 | 1.38784629027556 | 0.0373078791000572 | monthly | 1 | 1065.12903225806 | 0.0 | 1026.82053584915 | 38.3084964089159 | 1065.12903225806 | 0.0 | 0.313384646191257 | ||
23848 | 23848 | Mongolia | Mongolia | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3398373 | 1366 | 0 | 1455.56719880799 | -89.5671988079919 | 1366 | 0.0 | -2.63559058431761 | -0.0615342245149115 | monthly | 1 | 308.451612903226 | 0.0 | 328.676464246966 | -20.2248513437401 | 308.451612903226 | 0.0 | -0.595133357749138 | ||
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 | ||
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 | ||
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 | ||
24412 | 24412 | Belize | Belize | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 405285 | 178 | 0 | 177.350965456424 | 0.649034543575823 | 178 | 0.0 | 0.160142749812064 | 0.0036596053588176 | monthly | 1 | 40.1935483870968 | 0.0 | 40.0469921998377 | 0.146556187259057 | 40.1935483870968 | 0.0 | 0.0361612660865951 | ||
24436 | 24436 | Macao | Macao | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 695180 | 201 | 0 | 205.315735419328 | -4.31573541932786 | 201 | 0.0 | -0.620808340189284 | -0.0210199934774292 | monthly | 1 | 45.3870967741935 | 0.0 | 46.3616176753321 | -0.97452090113855 | 45.3870967741935 | 0.0 | -0.140182528429838 | ||
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 | ||
24503 | 24503 | Aruba | Aruba | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 106459 | 69 | 0 | 59.9499110563765 | 9.05008894362353 | 69 | 0.0 | 8.50100878612755 | 0.150960840210637 | monthly | 1 | 15.5806451612903 | 0.0 | 13.5370766901495 | 2.0435684711408 | 15.5806451612903 | 0.0 | 1.91958262912558 | ||
24527 | 24527 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 3233530 | 2800 | 0 | 3263.21400976103 | -463.214009761031 | 2800 | 0.0 | -14.325335152636 | -0.141950239357716 | monthly | 1 | 632.258064516129 | 0.0 | 736.854776397652 | -104.596711881523 | 632.258064516129 | 0.0 | -3.23475309898232 | ||
24908 | 24908 | Indonesia | Jakarta | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 10770000 | 3303 | 0 | 2951.33978288658 | 351.66021711342 | 3303 | 0.0 | 3.26518307440502 | 0.119152738411392 | monthly | 1 | 745.838709677419 | 0.0 | 666.431563877615 | 79.4071457998046 | 745.838709677419 | 0.0 | 0.737299403897907 | ||
24855 | 24855 | Turkey | Istanbul | 0 | 2020-01-01 | 2020-01-08 | 7 | 2020 | 1 | 15519267 | 1699 | 0 | 1762.87499999998 | -63.8749999999814 | 1699 | 0.0 | -0.411585160561909 | -0.0362334255122921 | weekly |
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);