economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
113 rows where "end_date" is on date 2017-12-31 sorted by end_date
This data as json, yaml, Notebook, copyable, CSV (advanced)
country 13
- Andorra 1
- Belize 1
- Chile 1
- Costa Rica 1
- Jamaica 1
- Kazakhstan 1
- Kosovo 1
- Lebanon 1
- Nicaragua 1
- Norway 1
- Philippines 1
- Saint Vincent and the Grenadines 1
- Seychelles 1
Link | rowid | country | region | region_code | start_date | end_date ▼ | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38591 | 38591 | Philippines | Philippines | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 115559008 | 50030 | 0 | TBC | monthly | 12 | |
38681 | 38681 | Andorra | Andorra | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 79843 | 30 | 0 | TBC | monthly | 12 | |
38821 | 38821 | Chile | Chile | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 19603736 | 1707 | 0 | TBC | weekly | |
39115 | 39115 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 103959 | 67 | 0 | TBC | monthly | 12 | |
39199 | 39199 | Seychelles | Seychelles | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 107135 | 53 | 0 | TBC | monthly | 12 | |
39404 | 39404 | Norway | Norway | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 5434324 | 891 | 0 | TBC | weekly | |
39697 | 39697 | Kosovo | Kosovo | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 1782115 | 837 | 0 | TBC | monthly | 12 | |
39791 | 39791 | Lebanon | Lebanon | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 5489744 | 1905 | 0 | TBC | monthly | 12 | |
39875 | 39875 | Belize | Belize | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 405285 | 187 | 0 | TBC | monthly | 12 | |
39959 | 39959 | Costa Rica | Costa Rica | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 5180836 | 2080 | 0 | TBC | monthly | 12 | |
40043 | 40043 | Kazakhstan | Kazakhstan | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 19397998 | 10218 | 0 | TBC | monthly | 12 | |
40136 | 40136 | Nicaragua | Nicaragua | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 6948395 | 2014 | 0 | TBC | monthly | 12 | |
40208 | 40208 | Jamaica | Jamaica | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 2827382 | 1565 | 0 | TBC | monthly | 12 |
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]);