economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
10 rows where "start_date" is on date 2022-11-28
This data as json, yaml, Notebook, copyable, CSV (advanced)
country 10
- Austria 1
- Britain 1
- Chile 1
- Denmark 1
- Ecuador 1
- Netherlands 1
- New Zealand 1
- Norway 1
- Portugal 1
- South Africa 1
end_date (date) 1 ✖
- 2022-12-04 10
cadence 1
- weekly 10
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
898 | 898 | Ecuador | Ecuador | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 18001002 | 1640 | 0 | TBC | weekly | |
8251 | 8251 | South Africa | South Africa | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 59893884 | 9889 | 36 | TBC | weekly | |
9983 | 9983 | New Zealand | New Zealand | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 5185289 | 599 | 23 | TBC | weekly | |
11694 | 11694 | Britain | Britain | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 67508936 | 12883 | 230 | TBC | weekly | |
13275 | 13275 | Portugal | Portugal | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 10270857 | 2607 | 67 | TBC | weekly | |
17205 | 17205 | Netherlands | Netherlands | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 17564020 | 3400 | 13 | TBC | weekly | |
17620 | 17620 | Austria | Austria | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 8939617 | 1824 | 45 | TBC | weekly | |
18538 | 18538 | Denmark | Denmark | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 5882259 | 1165 | 28 | TBC | weekly | |
39078 | 39078 | Chile | Chile | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 19603736 | 2269 | 194 | TBC | weekly | |
39661 | 39661 | Norway | Norway | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 5434324 | 873 | 55 | TBC | 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]);