economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
122 rows where "end_date" is on date 2019-11-30 sorted by expected_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
country 22
- Albania 1
- Andorra 1
- Belize 1
- Costa Rica 1
- Cuba 1
- Dominican Republic 1
- Ireland 1
- Jamaica 1
- Jordan 1
- Kazakhstan 1
- Kosovo 1
- Lebanon 1
- Liechtenstein 1
- Monaco 1
- Nicaragua 1
- Philippines 1
- Qatar 1
- Russia 1
- Saint Vincent and the Grenadines 1
- Seychelles 1
- Suriname 1
- Ukraine 1
cadence 1
- monthly 22
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths ▼ | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]);