economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
122 rows where "start_date" is on date 2019-09-01
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
end_date (date) 2 ✖
- 2019-09-30 14
- 2019-09-07 8
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35150 | 35150 | United States | Utah | UT | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 3205958 | 367 | 0 | 371 | weekly | |
35458 | 35458 | United States | Vermont | VT | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 623989 | 89 | 0 | 112 | weekly | |
35766 | 35766 | United States | Virginia | VA | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 8535519 | 1246 | 0 | 1282 | weekly | |
36074 | 36074 | United States | Washington | WA | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 7614893 | 1071 | 0 | 1125 | weekly | |
36382 | 36382 | United States | West Virginia | WV | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 1792147 | 420 | 0 | 427 | weekly | |
36690 | 36690 | United States | Wisconsin | WI | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 5822434 | 1054 | 0 | 1001 | weekly | |
36998 | 36998 | United States | Wyoming | WY | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 578759 | 98 | 0 | 83 | weekly | |
37306 | 37306 | United States | United States | USA | 2019-09-01 | 2019-09-07 | 7 | 2019 | 36 | 328300544 | 51960 | 0 | 53927 | weekly | |
37532 | 37532 | Russia | Russia | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 144713312 | 144546.9 | 0 | TBC | monthly | 9 | |
38435 | 38435 | Monaco | Monaco | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 36491 | 42 | 0 | TBC | monthly | 9 | |
38528 | 38528 | Cuba | Cuba | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 11212198 | 9009 | 0 | TBC | monthly | 9 | |
38612 | 38612 | Philippines | Philippines | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 115559008 | 52035 | 0 | TBC | monthly | 9 | |
38702 | 38702 | Andorra | Andorra | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 79843 | 24 | 0 | TBC | monthly | 9 | |
39136 | 39136 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 103959 | 92 | 0 | TBC | monthly | 9 | |
39220 | 39220 | Seychelles | Seychelles | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 107135 | 71 | 0 | TBC | monthly | 9 | |
39718 | 39718 | Kosovo | Kosovo | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 1782115 | 717 | 0 | TBC | monthly | 9 | |
39812 | 39812 | Lebanon | Lebanon | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 5489744 | 1755 | 0 | TBC | monthly | 9 | |
39896 | 39896 | Belize | Belize | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 405285 | 172 | 0 | TBC | monthly | 9 | |
39980 | 39980 | Costa Rica | Costa Rica | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 5180836 | 1996 | 0 | TBC | monthly | 9 | |
40064 | 40064 | Kazakhstan | Kazakhstan | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 19397998 | 10535 | 0 | TBC | monthly | 9 | |
40157 | 40157 | Nicaragua | Nicaragua | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 6948395 | 2197 | 0 | TBC | monthly | 9 | |
40229 | 40229 | Jamaica | Jamaica | 0 | 2019-09-01 | 2019-09-30 | 30 | 2019 | 2827382 | 1529 | 0 | TBC | monthly | 9 |
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]);