economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
115 rows where "start_date" is on date 2018-10-01 sorted by start_date
This data as json, yaml, Notebook, copyable, CSV (advanced)
country 15
- Andorra 1
- Belize 1
- Chile 1
- Costa Rica 1
- Cuba 1
- Jamaica 1
- Kazakhstan 1
- Kosovo 1
- Lebanon 1
- Monaco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38424 | 38424 | Monaco | Monaco | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 36491 | 39 | 0 | TBC | monthly | 10 | |
38517 | 38517 | Cuba | Cuba | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 11212198 | 8281 | 0 | TBC | monthly | 10 | |
38601 | 38601 | Philippines | Philippines | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 115559008 | 50917 | 0 | TBC | monthly | 10 | |
38691 | 38691 | Andorra | Andorra | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 79843 | 33 | 0 | TBC | monthly | 10 | |
38861 | 38861 | Chile | Chile | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 19603736 | 2058 | 0 | TBC | weekly | |
39125 | 39125 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 103959 | 87 | 0 | TBC | monthly | 10 | |
39209 | 39209 | Seychelles | Seychelles | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 107135 | 90 | 0 | TBC | monthly | 10 | |
39444 | 39444 | Norway | Norway | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 5434324 | 701 | 0 | TBC | weekly | |
39707 | 39707 | Kosovo | Kosovo | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 1782115 | 768 | 0 | TBC | monthly | 10 | |
39801 | 39801 | Lebanon | Lebanon | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 5489744 | 2415 | 0 | TBC | monthly | 10 | |
39885 | 39885 | Belize | Belize | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 405285 | 171 | 0 | TBC | monthly | 10 | |
39969 | 39969 | Costa Rica | Costa Rica | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 5180836 | 1971 | 0 | TBC | monthly | 10 | |
40053 | 40053 | Kazakhstan | Kazakhstan | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 19397998 | 11363 | 0 | TBC | monthly | 10 | |
40146 | 40146 | Nicaragua | Nicaragua | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 6948395 | 2217 | 0 | TBC | monthly | 10 | |
40218 | 40218 | Jamaica | Jamaica | 0 | 2018-10-01 | 2018-10-31 | 31 | 2018 | 2827382 | 1422 | 0 | TBC | monthly | 10 |
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]);