economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
40,255 rows sorted by end_date
This data as json, yaml, Notebook, copyable, CSV (advanced)
end_date (date) >30 ✖
- 2018-03-31 122
- 2018-06-30 122
- 2019-08-31 122
- 2019-11-30 122
- 2020-02-29 122
- 2020-10-31 121
- 2017-09-30 120
- 2018-09-30 115
- 2019-03-31 115
- 2019-06-30 115
- 2020-05-31 115
- 2017-04-30 113
- 2017-12-31 113
- 2016-01-31 111
- 2016-07-31 111
- 2015-05-31 110
- 2021-07-31 109
- 2021-01-31 104
- 2021-02-28 103
- 2021-10-31 102
- 2022-04-30 89
- 2022-07-31 77
- 2018-01-31 70
- 2018-02-28 70
- 2018-04-30 70
- 2018-05-31 70
- 2018-07-31 70
- 2018-08-31 70
- 2018-10-31 70
- 2018-11-30 70
- …
country >30
- United States 16,426
- Denmark 413
- Netherlands 413
- Austria 412
- Britain 412
- New Zealand 412
- Norway 412
- Portugal 412
- South Africa 412
- Ecuador 411
- Germany 411
- Poland 411
- Latvia 410
- Switzerland 410
- Belgium 409
- Colombia 409
- Estonia 409
- France 409
- Slovenia 409
- Croatia 408
- Cyprus 408
- Finland 408
- Greece 408
- Hungary 408
- Iceland 408
- Israel 408
- Lithuania 408
- Sweden 408
- Bulgaria 407
- Luxembourg 407
- …
Link | rowid | country | region | region_code | start_date | end_date ▼ | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7445 | 7445 | South Korea | South Korea | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 51815808 | 5551 | 0 | TBC | weekly | |
7841 | 7841 | South Africa | South Africa | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 59893884 | 9098 | 0 | TBC | weekly | |
8442 | 8442 | Malta | Malta | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 533293 | 93 | 0 | TBC | weekly | |
9163 | 9163 | Romania | Romania | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 19659270 | 5602 | 0 | TBC | weekly | |
9572 | 9572 | New Zealand | New Zealand | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 5185289 | 595 | 0 | TBC | weekly | |
10070 | 10070 | Switzerland | Switzerland | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 8740471 | 1524 | 0 | TBC | weekly | |
10789 | 10789 | Lithuania | Lithuania | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 2750058 | 905 | 0 | TBC | weekly | |
11283 | 11283 | Britain | Britain | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 67508936 | 16735 | 0 | TBC | weekly | |
11697 | 11697 | Mexico | Mexico | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 127504120 | 14820 | 0 | TBC | weekly | |
12365 | 12365 | Iran | Iran | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 88550568 | 7367.1 | 0 | TBC | weekly | |
12864 | 12864 | Portugal | Portugal | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 10270857 | 3167 | 0 | TBC | weekly | |
13278 | 13278 | Croatia | Croatia | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 4030361 | 1276 | 0 | TBC | weekly | |
13948 | 13948 | Montenegro | Montenegro | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 627082 | 148 | 0 | TBC | weekly | |
14533 | 14533 | Italy | Italy | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 59037472 | 15480 | 0 | TBC | weekly | |
15022 | 15022 | Canada | Canada | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 38454328 | 6190 | 0 | TBC | weekly | |
15418 | 15418 | Finland | Finland | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 5540745 | 1151 | 0 | TBC | weekly | |
16170 | 16170 | Iceland | Iceland | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 372903 | 44 | 0 | TBC | weekly | |
16794 | 16794 | Netherlands | Netherlands | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 17564020 | 3378 | 0 | TBC | weekly | |
17209 | 17209 | Austria | Austria | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 8939617 | 1837 | 0 | TBC | weekly | |
17623 | 17623 | Spain | Spain | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 47558632 | 10738 | 0 | TBC | weekly | |
18127 | 18127 | Denmark | Denmark | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 5882259 | 1093 | 0 | TBC | weekly | |
18542 | 18542 | Cyprus | Cyprus | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 896007 | 155 | 0 | TBC | weekly | |
19232 | 19232 | Colombia | Colombia | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 51874028 | 4506 | 0 | TBC | weekly | |
19809 | 19809 | Greece | Greece | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 10384972 | 3053 | 0 | TBC | weekly | |
20308 | 20308 | Poland | Poland | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 39857144 | 7800 | 0 | TBC | weekly | |
21050 | 21050 | France | France | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 67813000 | 12803 | 0 | TBC | weekly | |
37572 | 37572 | Guatemala | Guatemala | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 17843914 | 1604 | 0 | TBC | weekly | |
37968 | 37968 | Germany | Germany | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 83369840 | 19500 | 0 | TBC | weekly | |
39250 | 39250 | Norway | Norway | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 5434324 | 913 | 0 | TBC | weekly | |
4 | 4 | United States | United States | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 338289856 | 57407 | 0 | TBC | weekly | |
488 | 488 | Ecuador | Ecuador | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 18001002 | 1176 | 0 | TBC | weekly | |
974 | 974 | Latvia | Latvia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 1850654 | 618 | 0 | TBC | weekly | |
1481 | 1481 | Slovakia | Slovakia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 5643455 | 1235 | 0 | TBC | weekly | |
1982 | 1982 | Bulgaria | Bulgaria | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 6781955 | 2339 | 0 | TBC | weekly | |
2392 | 2392 | Luxembourg | Luxembourg | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 647601 | 94 | 0 | TBC | weekly | |
2802 | 2802 | Belgium | Belgium | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 11655923 | 2510 | 0 | TBC | weekly | |
3309 | 3309 | Sweden | Sweden | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 10549349 | 1954 | 0 | TBC | weekly | |
3814 | 3814 | Australia | Australia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 26177410 | 2768 | 0 | TBC | weekly | |
4478 | 4478 | Czech Republic | Czech Republic | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 10493990 | 2499 | 0 | TBC | weekly | |
4887 | 4887 | Slovenia | Slovenia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 2119843 | 449 | 0 | TBC | weekly | |
5299 | 5299 | Estonia | Estonia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 1326064 | 321 | 0 | TBC | weekly | |
5886 | 5886 | Israel | Israel | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 9449000 | 1068 | 0 | TBC | weekly | |
6297 | 6297 | Hungary | Hungary | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 9967304 | 3005 | 0 | TBC | weekly | |
7446 | 7446 | South Korea | South Korea | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 51815808 | 5601 | 0 | TBC | weekly | |
7842 | 7842 | South Africa | South Africa | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 59893884 | 9559 | 0 | TBC | weekly | |
8443 | 8443 | Malta | Malta | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 533293 | 72 | 0 | TBC | weekly | |
9164 | 9164 | Romania | Romania | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 19659270 | 5508 | 0 | TBC | weekly | |
9573 | 9573 | New Zealand | New Zealand | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 5185289 | 531 | 0 | TBC | weekly | |
10071 | 10071 | Switzerland | Switzerland | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 8740471 | 1480 | 0 | TBC | weekly | |
10790 | 10790 | Lithuania | Lithuania | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 2750058 | 853 | 0 | TBC | weekly | |
11284 | 11284 | Britain | Britain | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 67508936 | 15710 | 0 | TBC | weekly | |
11698 | 11698 | Mexico | Mexico | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 127504120 | 14172 | 0 | TBC | weekly | |
12366 | 12366 | Iran | Iran | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 88550568 | 7374.9 | 0 | TBC | weekly | |
12865 | 12865 | Portugal | Portugal | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 10270857 | 3088 | 0 | TBC | weekly | |
13279 | 13279 | Croatia | Croatia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 4030361 | 1231 | 0 | TBC | weekly | |
13949 | 13949 | Montenegro | Montenegro | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 627082 | 128 | 0 | TBC | weekly | |
14534 | 14534 | Italy | Italy | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 59037472 | 14922 | 0 | TBC | weekly | |
15023 | 15023 | Canada | Canada | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 38454328 | 6045 | 0 | TBC | weekly | |
15419 | 15419 | Finland | Finland | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 5540745 | 1040 | 0 | TBC | weekly | |
16171 | 16171 | Iceland | Iceland | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 372903 | 48 | 0 | TBC | weekly | |
16795 | 16795 | Netherlands | Netherlands | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 17564020 | 3353 | 0 | TBC | weekly | |
17210 | 17210 | Austria | Austria | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 8939617 | 1792 | 0 | TBC | weekly | |
17624 | 17624 | Spain | Spain | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 47558632 | 10625 | 0 | TBC | weekly | |
18128 | 18128 | Denmark | Denmark | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 5882259 | 1068 | 0 | TBC | weekly | |
18543 | 18543 | Cyprus | Cyprus | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 896007 | 154 | 0 | TBC | weekly | |
19233 | 19233 | Colombia | Colombia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 51874028 | 4264 | 0 | TBC | weekly | |
19810 | 19810 | Greece | Greece | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 10384972 | 3065 | 0 | TBC | weekly | |
20309 | 20309 | Poland | Poland | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 39857144 | 7559 | 0 | TBC | weekly | |
21051 | 21051 | France | France | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 67813000 | 12617 | 0 | TBC | weekly | |
37573 | 37573 | Guatemala | Guatemala | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 17843914 | 1480 | 0 | TBC | weekly | |
37969 | 37969 | Germany | Germany | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 83369840 | 19346 | 0 | TBC | weekly | |
39251 | 39251 | Norway | Norway | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 5434324 | 930 | 0 | TBC | weekly | |
413 | 413 | Brunei | Brunei | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 449002 | 120 | 0 | TBC | monthly | 1 | |
899 | 899 | Maldives | Maldives | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 523798 | 94 | 0 | TBC | monthly | 1 | |
1384 | 1384 | Kyrgyzstan | Kyrgyzstan | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 6630621 | 3051 | 0 | TBC | monthly | 1 | |
1885 | 1885 | Brazil | Brazil | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 215313504 | 106695 | 0 | TBC | monthly | 1 | |
3211 | 3211 | Thailand | Thailand | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 71697024 | 44867 | 0 | TBC | monthly | 1 | |
3717 | 3717 | Japan | Japan | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 123951696 | 134256 | 0 | TBC | monthly | 1 | |
4215 | 4215 | Uruguay | Uruguay | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 3422796 | 2514 | 0 | TBC | monthly | 1 | |
4307 | 4307 | Egypt | Egypt | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 110990096 | 59713 | 0 | TBC | monthly | 1 | |
4400 | 4400 | Belarus | Belarus | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 9534956 | 11366 | 0 | TBC | monthly | 1 | |
5708 | 5708 | Bolivia | Bolivia | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 12224114 | 4096 | 0 | TBC | monthly | 1 | |
5793 | 5793 | Mauritius | Mauritius | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 1299478 | 845 | 0 | TBC | monthly | 1 | |
6705 | 6705 | Georgia | Georgia | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 3744385 | 4575 | 0 | TBC | monthly | 1 | |
7096 | 7096 | Tunisia | Tunisia | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 12356116 | 7019 | 0 | TBC | monthly | 1 | |
7182 | 7182 | Bahamas | Bahamas | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 409989 | 199 | 0 | TBC | monthly | 1 | |
7266 | 7266 | Isle of Man | Isle of Man | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 84534 | 96 | 0 | TBC | monthly | 1 | |
7350 | 7350 | Malaysia | Malaysia | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 33938216 | 14073 | 0 | TBC | monthly | 1 | |
8253 | 8253 | Barbados | Barbados | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 281646 | 336 | 0 | TBC | monthly | 1 | |
8346 | 8346 | San Marino | San Marino | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 33690 | 27 | 0 | TBC | monthly | 1 | |
8848 | 8848 | El Salvador | El Salvador | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 6336393 | 4361 | 0 | TBC | monthly | 1 | |
8916 | 8916 | Tajikistan | Tajikistan | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 9952789 | 3346 | 0 | TBC | monthly | 1 | |
9068 | 9068 | Greenland | Greenland | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 56494 | 44 | 0 | TBC | monthly | 1 | |
9984 | 9984 | Aruba | Aruba | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 106459 | 51 | 0 | TBC | monthly | 1 | |
10480 | 10480 | Paraguay | Paraguay | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 6780745 | 2456 | 0 | TBC | monthly | 1 | |
10574 | 10574 | Singapore | Singapore | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 5637022 | 1701 | 0 | TBC | monthly | 1 | |
10667 | 10667 | Kuwait | Kuwait | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 4268886 | 596 | 0 | TBC | monthly | 1 | |
11197 | 11197 | Antigua and Barbuda | Antigua and Barbuda | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 93772 | 36 | 0 | TBC | monthly | 1 | |
12102 | 12102 | Gibraltar | Gibraltar | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 32677 | 25 | 0 | TBC | monthly | 1 | |
12175 | 12175 | Macao | Macao | 0 | 2015-01-01 | 2015-01-31 | 31 | 2015 | 695180 | 212 | 0 | TBC | monthly | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_historical_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] TEXT, [cadence] TEXT , [month] INTEGER); CREATE INDEX [idx_economist_historical_deaths_country] ON [economist_historical_deaths] ([country]); CREATE INDEX [idx_economist_historical_deaths_cadence] ON [economist_historical_deaths] ([cadence]); CREATE INDEX [idx_economist_historical_deaths_end_date] ON [economist_historical_deaths] ([end_date]);