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

67 rows where "start_date" is on date 2016-07-01

✎ View and edit SQL

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

Suggested facets: start_date (date)

cadence 1

Link rowid ▼ country region region_code start_date end_date days year week population total_deaths covid_deaths expected_deaths cadence month
431 431 Brunei Brunei 0 2016-07-01 2016-07-31 31 2016   449002 111 0 TBC monthly 7
917 917 Maldives Maldives 0 2016-07-01 2016-07-31 31 2016   523798 83 0 TBC monthly 7
1402 1402 Kyrgyzstan Kyrgyzstan 0 2016-07-01 2016-07-31 31 2016   6630621 2701 0 TBC monthly 7
1903 1903 Brazil Brazil 0 2016-07-01 2016-07-31 31 2016   215313504 118151 0 TBC monthly 7
3229 3229 Thailand Thailand 0 2016-07-01 2016-07-31 31 2016   71697024 36916 0 TBC monthly 7
3735 3735 Japan Japan 0 2016-07-01 2016-07-31 31 2016   123951696 99203 0 TBC monthly 7
4233 4233 Uruguay Uruguay 0 2016-07-01 2016-07-31 31 2016   3422796 3358 0 TBC monthly 7
4325 4325 Egypt Egypt 0 2016-07-01 2016-07-31 31 2016   110990096 45934 0 TBC monthly 7
4418 4418 Belarus Belarus 0 2016-07-01 2016-07-31 31 2016   9534956 9377 0 TBC monthly 7
5726 5726 Bolivia Bolivia 0 2016-07-01 2016-07-31 31 2016   12224114 4323 0 TBC monthly 7
5811 5811 Mauritius Mauritius 0 2016-07-01 2016-07-31 31 2016   1299478 1006 0 TBC monthly 7
6723 6723 Georgia Georgia 0 2016-07-01 2016-07-31 31 2016   3744385 3511 0 TBC monthly 7
7114 7114 Tunisia Tunisia 0 2016-07-01 2016-07-31 31 2016   12356116 4961 0 TBC monthly 7
7200 7200 Bahamas Bahamas 0 2016-07-01 2016-07-31 31 2016   409989 201 0 TBC monthly 7
7284 7284 Isle of Man Isle of Man 0 2016-07-01 2016-07-31 31 2016   84534 54 0 TBC monthly 7
7368 7368 Malaysia Malaysia 0 2016-07-01 2016-07-31 31 2016   33938216 13982 0 TBC monthly 7
8271 8271 Barbados Barbados 0 2016-07-01 2016-07-31 31 2016   281646 187 0 TBC monthly 7
8364 8364 San Marino San Marino 0 2016-07-01 2016-07-31 31 2016   33690 18 0 TBC monthly 7
8866 8866 El Salvador El Salvador 0 2016-07-01 2016-07-31 31 2016   6336393 3209 0 TBC monthly 7
8934 8934 Tajikistan Tajikistan 0 2016-07-01 2016-07-31 31 2016   9952789 2746 0 TBC monthly 7
8994 8994 Saint Kitts and Nevis Saint Kitts and Nevis 0 2016-07-01 2016-07-31 31 2016   47681 39 0 TBC monthly 7
9086 9086 Greenland Greenland 0 2016-07-01 2016-07-31 31 2016   56494 42 0 TBC monthly 7
10002 10002 Aruba Aruba 0 2016-07-01 2016-07-31 31 2016   106459 63 0 TBC monthly 7
10498 10498 Paraguay Paraguay 0 2016-07-01 2016-07-31 31 2016   6780745 3155 0 TBC monthly 7
10592 10592 Singapore Singapore 0 2016-07-01 2016-07-31 31 2016   5637022 1859 0 TBC monthly 7
10685 10685 Kuwait Kuwait 0 2016-07-01 2016-07-31 31 2016   4268886 518 0 TBC monthly 7
11215 11215 Antigua and Barbuda Antigua and Barbuda 0 2016-07-01 2016-07-31 31 2016   93772 23 0 TBC monthly 7
12120 12120 Gibraltar Gibraltar 0 2016-07-01 2016-07-31 31 2016   32677 16 0 TBC monthly 7
12193 12193 Macao Macao 0 2016-07-01 2016-07-31 31 2016   695180 198 0 TBC monthly 7
12287 12287 Oman Oman 0 2016-07-01 2016-07-31 31 2016   4576300 750 0 TBC monthly 7
12786 12786 Faroe Islands Faroe Islands 0 2016-07-01 2016-07-31 31 2016   49085 32 0 TBC monthly 7
13704 13704 Argentina Argentina 0 2016-07-01 2016-07-31 31 2016   45510324 34485 0 TBC monthly 7
13776 13776 Serbia Serbia 0 2016-07-01 2016-07-31 31 2016   6871547 7767 0 TBC monthly 7
13870 13870 Armenia Armenia 0 2016-07-01 2016-07-31 31 2016   2780472 2103 0 TBC monthly 7
14363 14363 Bosnia and Herzegovina Bosnia and Herzegovina 0 2016-07-01 2016-07-31 31 2016   3233530 2732 0 TBC monthly 7
14456 14456 Moldova Moldova 0 2016-07-01 2016-07-31 31 2016   3272993 2918 0 TBC monthly 7
14954 14954 Bermuda Bermuda 0 2016-07-01 2016-07-31 31 2016   64207 47 0 TBC monthly 7
15844 15844 Mongolia Mongolia 0 2016-07-01 2016-07-31 31 2016   3398373 1341 0 TBC monthly 7
15939 15939 North Macedonia North Macedonia 0 2016-07-01 2016-07-31 31 2016   2093606 1570 0 TBC monthly 7
16032 16032 Cape Verde Cape Verde 0 2016-07-01 2016-07-31 31 2016   593162 195 0 TBC monthly 7
16104 16104 Panama Panama 0 2016-07-01 2016-07-31 31 2016   4408582 1588 0 TBC monthly 7
16632 16632 French Polynesia French Polynesia 0 2016-07-01 2016-07-31 31 2016   306292 124 0 TBC monthly 7
16716 16716 Azerbaijan Azerbaijan 0 2016-07-01 2016-07-31 31 2016   10358078 4586 0 TBC monthly 7
18048 18048 Taiwan Taiwan 0 2016-07-01 2016-07-31 31 2016   23893396 13021 0 TBC monthly 7
18968 18968 Hong Kong Hong Kong 0 2016-07-01 2016-07-31 31 2016   7488863 3606 0 TBC monthly 7
19061 19061 Uzbekistan Uzbekistan 0 2016-07-01 2016-07-31 31 2016   34627648 12118 0 TBC monthly 7
19154 19154 Qatar Qatar 0 2016-07-01 2016-07-31 31 2016   2695131 187 0 TBC monthly 7
19659 19659 Ireland Ireland 0 2016-07-01 2016-07-31 31 2016   5023108 2301 0 TBC monthly 7
19753 19753 Suriname Suriname 0 2016-07-01 2016-07-31 31 2016   618046 277 0 TBC monthly 7
20235 20235 Liechtenstein Liechtenstein 0 2016-07-01 2016-07-31 31 2016   39355 27 0 TBC monthly 7
20809 20809 Dominican Republic Dominican Republic 0 2016-07-01 2016-07-31 31 2016   11228821 3684 0 TBC monthly 7
20891 20891 Ukraine Ukraine 0 2016-07-01 2016-07-31 31 2016   39701744 44485 0 TBC monthly 7
20976 20976 Albania Albania 0 2016-07-01 2016-07-31 31 2016   2842318 1643 0 TBC monthly 7
37494 37494 Russia Russia 0 2016-07-01 2016-07-31 31 2016   144713312 152963.5 0 TBC monthly 7
38397 38397 Monaco Monaco 0 2016-07-01 2016-07-31 31 2016   36491 43 0 TBC monthly 7
38490 38490 Cuba Cuba 0 2016-07-01 2016-07-31 31 2016   11212198 8473 0 TBC monthly 7
38574 38574 Philippines Philippines 0 2016-07-01 2016-07-31 31 2016   115559008 48848 0 TBC monthly 7
38664 38664 Andorra Andorra 0 2016-07-01 2016-07-31 31 2016   79843 32 0 TBC monthly 7
39098 39098 Saint Vincent and the Grenadines Saint Vincent and the Grenadines 0 2016-07-01 2016-07-31 31 2016   103959 95 0 TBC monthly 7
39182 39182 Seychelles Seychelles 0 2016-07-01 2016-07-31 31 2016   107135 68 0 TBC monthly 7
39680 39680 Kosovo Kosovo 0 2016-07-01 2016-07-31 31 2016   1782115 632 0 TBC monthly 7
39774 39774 Lebanon Lebanon 0 2016-07-01 2016-07-31 31 2016   5489744 1734 0 TBC monthly 7
39858 39858 Belize Belize 0 2016-07-01 2016-07-31 31 2016   405285 133 0 TBC monthly 7
39942 39942 Costa Rica Costa Rica 0 2016-07-01 2016-07-31 31 2016   5180836 1882 0 TBC monthly 7
40026 40026 Kazakhstan Kazakhstan 0 2016-07-01 2016-07-31 31 2016   19397998 10471 0 TBC monthly 7
40119 40119 Nicaragua Nicaragua 0 2016-07-01 2016-07-31 31 2016   6948395 2060 0 TBC monthly 7
40191 40191 Jamaica Jamaica 0 2016-07-01 2016-07-31 31 2016   2827382 1605 0 TBC monthly 7

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