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
This data as json, yaml, Notebook, copyable, CSV (advanced)
country 15
- United States 8
- Andorra 1
- Belize 1
- Costa Rica 1
- Cuba 1
- Jamaica 1
- Kazakhstan 1
- Kosovo 1
- Lebanon 1
- Monaco 1
- Nicaragua 1
- Philippines 1
- Russia 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35162 | 35162 | United States | Utah | UT | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 3205958 | 388 | 0 | 398 | weekly | |
35470 | 35470 | United States | Vermont | VT | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 623989 | 114 | 0 | 120 | weekly | |
35778 | 35778 | United States | Virginia | VA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 8535519 | 1447 | 0 | 1412 | weekly | |
36086 | 36086 | United States | Washington | WA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 7614893 | 1090 | 0 | 1185 | weekly | |
36394 | 36394 | United States | West Virginia | WV | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 1792147 | 418 | 0 | 460 | weekly | |
36702 | 36702 | United States | Wisconsin | WI | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 5822434 | 1041 | 0 | 1082 | weekly | |
37010 | 37010 | United States | Wyoming | WY | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 578759 | 110 | 0 | 85 | weekly | |
37318 | 37318 | United States | United States | USA | 2019-11-24 | 2019-11-30 | 7 | 2019 | 48 | 328300544 | 55608 | 0 | 58382 | weekly | |
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]);