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 2020-03-01 sorted by start_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35176 | 35176 | United States | Utah | UT | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 3205958 | 427 | 0 | 405 | weekly | |
35484 | 35484 | United States | Vermont | VT | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 623989 | 120 | 0 | 125 | weekly | |
35792 | 35792 | United States | Virginia | VA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 8535519 | 1480 | 0 | 1468 | weekly | |
36100 | 36100 | United States | Washington | WA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 7614893 | 1208 | 15 | 1206 | weekly | |
36408 | 36408 | United States | West Virginia | WV | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 1792147 | 483 | 0 | 468 | weekly | |
36716 | 36716 | United States | Wisconsin | WI | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 5822434 | 1116 | 0 | 1108 | weekly | |
37024 | 37024 | United States | Wyoming | WY | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 578759 | 80 | 0 | 85 | weekly | |
37332 | 37332 | United States | United States | USA | 2020-03-01 | 2020-03-07 | 7 | 2020 | 10 | 328300544 | 59699 | 20 | 59870 | weekly | |
37538 | 37538 | Russia | Russia | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 144713312 | 154923 | 17 | TBC | monthly | 3 | |
38441 | 38441 | Monaco | Monaco | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 36491 | 53 | 1 | TBC | monthly | 3 | |
38534 | 38534 | Cuba | Cuba | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 11212198 | 10022 | 6 | TBC | monthly | 3 | |
38618 | 38618 | Philippines | Philippines | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 115559008 | 45996 | 89 | TBC | monthly | 3 | |
38708 | 38708 | Andorra | Andorra | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 79843 | 40 | 12 | TBC | monthly | 3 | |
39142 | 39142 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 103959 | 90 | 0 | TBC | monthly | 3 | |
39226 | 39226 | Seychelles | Seychelles | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 107135 | 57 | 0 | TBC | monthly | 3 | |
39724 | 39724 | Kosovo | Kosovo | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 1782115 | 831 | 1 | TBC | monthly | 3 | |
39818 | 39818 | Lebanon | Lebanon | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 5489744 | 2222 | 12 | TBC | monthly | 3 | |
39902 | 39902 | Belize | Belize | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 405285 | 166 | 0 | TBC | monthly | 3 | |
39986 | 39986 | Costa Rica | Costa Rica | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 5180836 | 2003 | 2 | TBC | monthly | 3 | |
40070 | 40070 | Kazakhstan | Kazakhstan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 19397998 | 8511 | 2 | TBC | monthly | 3 | |
40163 | 40163 | Nicaragua | Nicaragua | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 6948395 | 1986 | 1 | TBC | monthly | 3 | |
40235 | 40235 | Jamaica | Jamaica | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 2827382 | 1525 | 1 | TBC | monthly | 3 |
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]);