economist_historical_deaths

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

70 rows where cadence = "monthly", month = 11 and year = 2019

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: start_date (date), end_date (date)

cadence 1

  • monthly · 70 ✖
Link rowid ▼ country region region_code start_date end_date days year week population total_deaths covid_deaths expected_deaths cadence month
471 471 Brunei Brunei 0 2019-11-01 2019-11-30 30 2019   449002 136 0 TBC monthly 11
957 957 Maldives Maldives 0 2019-11-01 2019-11-30 30 2019   523798 86 0 TBC monthly 11
1442 1442 Kyrgyzstan Kyrgyzstan 0 2019-11-01 2019-11-30 30 2019   6630621 2687 0 TBC monthly 11
1943 1943 Brazil Brazil 0 2019-11-01 2019-11-30 30 2019   215313504 105635 0 TBC monthly 11
3269 3269 Thailand Thailand 0 2019-11-01 2019-11-30 30 2019   71697024 40480 0 TBC monthly 11
3775 3775 Japan Japan 0 2019-11-01 2019-11-30 30 2019   123951696 119462 0 TBC monthly 11
4273 4273 Uruguay Uruguay 0 2019-11-01 2019-11-30 30 2019   3422796 2659 0 TBC monthly 11
4365 4365 Egypt Egypt 0 2019-11-01 2019-11-30 30 2019   110990096 44263 0 TBC monthly 11
4458 4458 Belarus Belarus 0 2019-11-01 2019-11-30 30 2019   9534956 9374 0 TBC monthly 11
5766 5766 Bolivia Bolivia 0 2019-11-01 2019-11-30 30 2019   12224114 3994 0 TBC monthly 11
5851 5851 Mauritius Mauritius 0 2019-11-01 2019-11-30 30 2019   1299478 832 0 TBC monthly 11
6763 6763 Georgia Georgia 0 2019-11-01 2019-11-30 30 2019   3744385 3961 0 TBC monthly 11
7154 7154 Tunisia Tunisia 0 2019-11-01 2019-11-30 30 2019   12356116 5847 0 TBC monthly 11
7240 7240 Bahamas Bahamas 0 2019-11-01 2019-11-30 30 2019   409989 213 0 TBC monthly 11
7324 7324 Isle of Man Isle of Man 0 2019-11-01 2019-11-30 30 2019   84534 67 0 TBC monthly 11
7408 7408 Malaysia Malaysia 0 2019-11-01 2019-11-30 30 2019   33938216 14685 0 TBC monthly 11
8311 8311 Barbados Barbados 0 2019-11-01 2019-11-30 30 2019   281646 266 0 TBC monthly 11
8404 8404 San Marino San Marino 0 2019-11-01 2019-11-30 30 2019   33690 27 0 TBC monthly 11
8906 8906 El Salvador El Salvador 0 2019-11-01 2019-11-30 30 2019   6336393 3394 0 TBC monthly 11
8974 8974 Tajikistan Tajikistan 0 2019-11-01 2019-11-30 30 2019   9952789 2778 0 TBC monthly 11
9034 9034 Saint Kitts and Nevis Saint Kitts and Nevis 0 2019-11-01 2019-11-30 30 2019   47681 23 0 TBC monthly 11
9126 9126 Greenland Greenland 0 2019-11-01 2019-11-30 30 2019   56494 42 0 TBC monthly 11
10042 10042 Aruba Aruba 0 2019-11-01 2019-11-30 30 2019   106459 52 0 TBC monthly 11
10538 10538 Paraguay Paraguay 0 2019-11-01 2019-11-30 30 2019   6780745 2605 0 TBC monthly 11
10632 10632 Singapore Singapore 0 2019-11-01 2019-11-30 30 2019   5637022 1767 0 TBC monthly 11
10725 10725 Kuwait Kuwait 0 2019-11-01 2019-11-30 30 2019   4268886 621 0 TBC monthly 11
10773 10773 Algeria Algeria 0 2019-11-01 2019-11-30 30 2019   44903228 15042.1 0 TBC monthly 11
11255 11255 Antigua and Barbuda Antigua and Barbuda 0 2019-11-01 2019-11-30 30 2019   93772 48 0 TBC monthly 11
12160 12160 Gibraltar Gibraltar 0 2019-11-01 2019-11-30 30 2019   32677 16 0 TBC monthly 11
12233 12233 Macao Macao 0 2019-11-01 2019-11-30 30 2019   695180 168 0 TBC monthly 11
12327 12327 Oman Oman 0 2019-11-01 2019-11-30 30 2019   4576300 673 0 TBC monthly 11
12826 12826 Faroe Islands Faroe Islands 0 2019-11-01 2019-11-30 30 2019   49085 31 0 TBC monthly 11
13744 13744 Argentina Argentina 0 2019-11-01 2019-11-30 30 2019   45510324 25785 0 TBC monthly 11
13816 13816 Serbia Serbia 0 2019-11-01 2019-11-30 30 2019   6871547 8172 0 TBC monthly 11
13910 13910 Armenia Armenia 0 2019-11-01 2019-11-30 30 2019   2780472 2179 0 TBC monthly 11
14403 14403 Bosnia and Herzegovina Bosnia and Herzegovina 0 2019-11-01 2019-11-30 30 2019   3233530 2963 0 TBC monthly 11
14496 14496 Moldova Moldova 0 2019-11-01 2019-11-30 30 2019   3272993 3039 0 TBC monthly 11
14994 14994 Bermuda Bermuda 0 2019-11-01 2019-11-30 30 2019   64207 46 0 TBC monthly 11
15884 15884 Mongolia Mongolia 0 2019-11-01 2019-11-30 30 2019   3398373 1266 0 TBC monthly 11
15979 15979 North Macedonia North Macedonia 0 2019-11-01 2019-11-30 30 2019   2093606 1574 0 TBC monthly 11
16072 16072 Cape Verde Cape Verde 0 2019-11-01 2019-11-30 30 2019   593162 256 0 TBC monthly 11
16144 16144 Panama Panama 0 2019-11-01 2019-11-30 30 2019   4408582 1533 0 TBC monthly 11
16600 16600 Palestine Palestine 0 2019-11-01 2019-11-30 30 2019   5250076 955 0 TBC monthly 11
16672 16672 French Polynesia French Polynesia 0 2019-11-01 2019-11-30 30 2019   306292 115 0 TBC monthly 11
16756 16756 Azerbaijan Azerbaijan 0 2019-11-01 2019-11-30 30 2019   10358078 4393 0 TBC monthly 11
18088 18088 Taiwan Taiwan 0 2019-11-01 2019-11-30 30 2019   23893396 13739 0 TBC monthly 11
19008 19008 Hong Kong Hong Kong 0 2019-11-01 2019-11-30 30 2019   7488863 3946 0 TBC monthly 11
19101 19101 Uzbekistan Uzbekistan 0 2019-11-01 2019-11-30 30 2019   34627648 12273 0 TBC monthly 11
19194 19194 Qatar Qatar 0 2019-11-01 2019-11-30 30 2019   2695131 201 0 TBC monthly 11
19699 19699 Ireland Ireland 0 2019-11-01 2019-11-30 30 2019   5023108 2696 0 TBC monthly 11
19793 19793 Suriname Suriname 0 2019-11-01 2019-11-30 30 2019   618046 301 0 TBC monthly 11
20275 20275 Liechtenstein Liechtenstein 0 2019-11-01 2019-11-30 30 2019   39355 28 0 TBC monthly 11
20765 20765 Jordan Jordan 0 2019-11-01 2019-11-30 30 2019   11285875 2903 0 TBC monthly 11
20849 20849 Dominican Republic Dominican Republic 0 2019-11-01 2019-11-30 30 2019   11228821 3631 0 TBC monthly 11
20931 20931 Ukraine Ukraine 0 2019-11-01 2019-11-30 30 2019   39701744 46986 0 TBC monthly 11
21016 21016 Albania Albania 0 2019-11-01 2019-11-30 30 2019   2842318 1792 0 TBC monthly 11
37534 37534 Russia Russia 0 2019-11-01 2019-11-30 30 2019   144713312 143368 0 TBC monthly 11
38437 38437 Monaco Monaco 0 2019-11-01 2019-11-30 30 2019   36491 50 0 TBC monthly 11
38530 38530 Cuba Cuba 0 2019-11-01 2019-11-30 30 2019   11212198 8899 0 TBC monthly 11
38614 38614 Philippines Philippines 0 2019-11-01 2019-11-30 30 2019   115559008 52787 0 TBC monthly 11
38704 38704 Andorra Andorra 0 2019-11-01 2019-11-30 30 2019   79843 30 0 TBC monthly 11
39138 39138 Saint Vincent and the Grenadines Saint Vincent and the Grenadines 0 2019-11-01 2019-11-30 30 2019   103959 91 0 TBC monthly 11
39222 39222 Seychelles Seychelles 0 2019-11-01 2019-11-30 30 2019   107135 69 0 TBC monthly 11
39720 39720 Kosovo Kosovo 0 2019-11-01 2019-11-30 30 2019   1782115 777 0 TBC monthly 11
39814 39814 Lebanon Lebanon 0 2019-11-01 2019-11-30 30 2019   5489744 1933 0 TBC monthly 11
39898 39898 Belize Belize 0 2019-11-01 2019-11-30 30 2019   405285 176 0 TBC monthly 11
39982 39982 Costa Rica Costa Rica 0 2019-11-01 2019-11-30 30 2019   5180836 1983 0 TBC monthly 11
40066 40066 Kazakhstan Kazakhstan 0 2019-11-01 2019-11-30 30 2019   19397998 10386 0 TBC monthly 11
40159 40159 Nicaragua Nicaragua 0 2019-11-01 2019-11-30 30 2019   6948395 2111 0 TBC monthly 11
40231 40231 Jamaica Jamaica 0 2019-11-01 2019-11-30 30 2019   2827382 1622 0 TBC monthly 11

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);