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-08-31 sorted by end_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35149 | 35149 | United States | Utah | UT | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 3205958 | 352 | 0 | 371 | weekly | |
35457 | 35457 | United States | Vermont | VT | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 623989 | 96 | 0 | 112 | weekly | |
35765 | 35765 | United States | Virginia | VA | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 8535519 | 1283 | 0 | 1280 | weekly | |
36073 | 36073 | United States | Washington | WA | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 7614893 | 1003 | 0 | 1112 | weekly | |
36381 | 36381 | United States | West Virginia | WV | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 1792147 | 387 | 0 | 425 | weekly | |
36689 | 36689 | United States | Wisconsin | WI | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 5822434 | 1049 | 0 | 994 | weekly | |
36997 | 36997 | United States | Wyoming | WY | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 578759 | 89 | 0 | 83 | weekly | |
37305 | 37305 | United States | United States | USA | 2019-08-25 | 2019-08-31 | 7 | 2019 | 35 | 328300544 | 51298 | 0 | 53744 | weekly | |
37531 | 37531 | Russia | Russia | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 144713312 | 144215.7 | 0 | TBC | monthly | 8 | |
38434 | 38434 | Monaco | Monaco | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 36491 | 37 | 0 | TBC | monthly | 8 | |
38527 | 38527 | Cuba | Cuba | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 11212198 | 9419 | 0 | TBC | monthly | 8 | |
38611 | 38611 | Philippines | Philippines | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 115559008 | 50265 | 0 | TBC | monthly | 8 | |
38701 | 38701 | Andorra | Andorra | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 79843 | 18 | 0 | TBC | monthly | 8 | |
39135 | 39135 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 103959 | 93 | 0 | TBC | monthly | 8 | |
39219 | 39219 | Seychelles | Seychelles | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 107135 | 47 | 0 | TBC | monthly | 8 | |
39717 | 39717 | Kosovo | Kosovo | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 1782115 | 774 | 0 | TBC | monthly | 8 | |
39811 | 39811 | Lebanon | Lebanon | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 5489744 | 1750 | 0 | TBC | monthly | 8 | |
39895 | 39895 | Belize | Belize | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 405285 | 164 | 0 | TBC | monthly | 8 | |
39979 | 39979 | Costa Rica | Costa Rica | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 5180836 | 2006 | 0 | TBC | monthly | 8 | |
40063 | 40063 | Kazakhstan | Kazakhstan | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 19397998 | 10477 | 0 | TBC | monthly | 8 | |
40156 | 40156 | Nicaragua | Nicaragua | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 6948395 | 2137 | 0 | TBC | monthly | 8 | |
40228 | 40228 | Jamaica | Jamaica | 0 | 2019-08-01 | 2019-08-31 | 31 | 2019 | 2827382 | 1612 | 0 | TBC | monthly | 8 |
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]);