economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
9 rows where cadence = "weekly", country = "United States" and covid_deaths = 211
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, year, start_date (date), end_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21661 | 21661 | United States | Alabama | AL | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 4903185 | 1275 | 211 | 1085 | weekly | |
21701 | 21701 | United States | Alabama | AL | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 4903185 | 1619 | 211 | 1021 | weekly | |
21703 | 21703 | United States | Alabama | AL | 2021-09-05 | 2021-09-11 | 7 | 2021 | 36 | 4903185 | 1750 | 211 | 1015 | weekly | |
27242 | 27242 | United States | Louisiana | LA | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 4648794 | 1317 | 211 | 892 | weekly | |
29097 | 29097 | United States | Mississippi | MS | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 2976149 | 879 | 211 | 607 | weekly | |
31211 | 31211 | United States | New Mexico | NM | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 2096829 | 662 | 211 | 384 | weekly | |
32819 | 32819 | United States | Oklahoma | OK | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 3956971 | 821 | 211 | 816 | weekly | |
35801 | 35801 | United States | Virginia | VA | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 8535519 | 1593 | 211 | 1354 | weekly | |
35886 | 35886 | United States | Virginia | VA | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 8535519 | 1742 | 211 | 1468 | weekly |
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]);