economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
9 rows where covid_deaths = 297
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, year, expected_deaths, start_date (date)
country 8
- United States 2
- Belgium 1
- Greece 1
- Guatemala 1
- Hungary 1
- Kazakhstan 1
- Mexico 1
- Peru 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3117 | 3117 | Belgium | Belgium | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 11655923 | 2275 | 297 | TBC | weekly | |
6671 | 6671 | Hungary | Hungary | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 9967304 | 2760 | 297 | TBC | weekly | |
7089 | 7089 | Peru | Peru | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 34049588 | 3219.2 | 297 | TBC | weekly | |
12087 | 12087 | Mexico | Mexico | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 127504120 | 14234 | 297 | TBC | weekly | |
20157 | 20157 | Greece | Greece | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 10384972 | 2719 | 297 | TBC | weekly | |
24795 | 24795 | United States | Georgia | GA | 2021-11-28 | 2021-12-04 | 7 | 2021 | 48 | 10617423 | 2017 | 297 | 1781 | weekly | |
25708 | 25708 | United States | Illinois | IL | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 12671821 | 2289 | 297 | 2056 | weekly | |
37923 | 37923 | Guatemala | Guatemala | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 17843914 | 2649 | 297 | TBC | weekly | |
40092 | 40092 | Kazakhstan | Kazakhstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 19397998 | 13264 | 297 | TBC | monthly | 1 |
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]);