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

37 rows where month = 3 and year = 2022

✎ 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
1470 1470 Kyrgyzstan Kyrgyzstan 0 2022-03-01 2022-03-31 31 2022   6630621 2955 30 TBC monthly 3
1971 1971 Brazil Brazil 0 2022-03-01 2022-03-31 31 2022   215313504 123152 10346 TBC monthly 3
3297 3297 Thailand Thailand 0 2022-03-01 2022-03-31 31 2022   71697024 53256 2197 TBC monthly 3
3803 3803 Japan Japan 0 2022-03-01 2022-03-31 31 2022   123951696 139571 4454 TBC monthly 3
4301 4301 Uruguay Uruguay 0 2022-03-01 2022-03-31 31 2022   3422796 3026 174 TBC monthly 3
4393 4393 Egypt Egypt 0 2022-03-01 2022-03-31 31 2022   110990096 53400 343 TBC monthly 3
5879 5879 Mauritius Mauritius 0 2022-03-01 2022-03-31 31 2022   1299478 1306 64 TBC monthly 3
6791 6791 Georgia Georgia 0 2022-03-01 2022-03-31 31 2022   3744385 4886 582 TBC monthly 3
7436 7436 Malaysia Malaysia 0 2022-03-01 2022-03-31 31 2022   33938216 21173 2234 TBC monthly 3
8339 8339 Barbados Barbados 0 2022-03-01 2022-03-31 31 2022   281646 422 58 TBC monthly 3
8432 8432 San Marino San Marino 0 2022-03-01 2022-03-31 31 2022   33690 19 1 TBC monthly 3
9062 9062 Saint Kitts and Nevis Saint Kitts and Nevis 0 2022-03-01 2022-03-31 31 2022   47681 39 1 TBC monthly 3
9154 9154 Greenland Greenland 0 2022-03-01 2022-03-31 31 2022   56494 24 4 TBC monthly 3
10566 10566 Paraguay Paraguay 0 2022-03-01 2022-03-31 31 2022   6780745 2902 305 TBC monthly 3
10660 10660 Singapore Singapore 0 2022-03-01 2022-03-31 31 2022   5637022 2622 249 TBC monthly 3
12261 12261 Macao Macao 0 2022-03-01 2022-03-31 31 2022   695180 218 0 TBC monthly 3
12355 12355 Oman Oman 0 2022-03-01 2022-03-31 31 2022   4576300 848 6 TBC monthly 3
12854 12854 Faroe Islands Faroe Islands 0 2022-03-01 2022-03-31 31 2022   49085 56 0 TBC monthly 3
13844 13844 Serbia Serbia 0 2022-03-01 2022-03-31 31 2022   6871547 11250 558 TBC monthly 3
13938 13938 Armenia Armenia 0 2022-03-01 2022-03-31 31 2022   2780472 2679 152 TBC monthly 3
14431 14431 Bosnia and Herzegovina Bosnia and Herzegovina 0 2022-03-01 2022-03-31 31 2022   3233530 3931 254 TBC monthly 3
14524 14524 Moldova Moldova 0 2022-03-01 2022-03-31 31 2022   3272993 3468 215 TBC monthly 3
15912 15912 Mongolia Mongolia 0 2022-03-01 2022-03-31 31 2022   3398373 1496 12 TBC monthly 3
16007 16007 North Macedonia North Macedonia 0 2022-03-01 2022-03-31 31 2022   2093606 2162 211 TBC monthly 3
16784 16784 Azerbaijan Azerbaijan 0 2022-03-01 2022-03-31 31 2022   10358078 6166 275 TBC monthly 3
18116 18116 Taiwan Taiwan 0 2022-03-01 2022-03-31 31 2022   23893396 18239 0 TBC monthly 3
19036 19036 Hong Kong Hong Kong 0 2022-03-01 2022-03-31 31 2022   7488863 12216 7081 TBC monthly 3
19129 19129 Uzbekistan Uzbekistan 0 2022-03-01 2022-03-31 31 2022   34627648 13951 2 TBC monthly 3
19222 19222 Qatar Qatar 0 2022-03-01 2022-03-31 31 2022   2695131 224 7 TBC monthly 3
19727 19727 Ireland Ireland 0 2022-03-01 2022-03-31 31 2022   5023108 2995 256 TBC monthly 3
20303 20303 Liechtenstein Liechtenstein 0 2022-03-01 2022-03-31 31 2022   39355 28 6 TBC monthly 3
21044 21044 Albania Albania 0 2022-03-01 2022-03-31 31 2022   2842318 1892 23 TBC monthly 3
37562 37562 Russia Russia 0 2022-03-01 2022-03-31 31 2022   144713312 201072 16693 TBC monthly 3
38465 38465 Monaco Monaco 0 2022-03-01 2022-03-31 31 2022   36491 50 3 TBC monthly 3
38642 38642 Philippines Philippines 0 2022-03-01 2022-03-31 31 2022   115559008 51862 2798 TBC monthly 3
39748 39748 Kosovo Kosovo 0 2022-03-01 2022-03-31 31 2022   1782115 763 20 TBC monthly 3
40094 40094 Kazakhstan Kazakhstan 0 2022-03-01 2022-03-31 31 2022   19397998 11036 74 TBC monthly 3

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