economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
9 rows where cadence = "monthly" and covid_deaths = 16
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, year, month, start_date (date), end_date (date)
country 9
- Albania 1
- Bahamas 1
- Barbados 1
- Bermuda 1
- Hong Kong 1
- Kazakhstan 1
- Seychelles 1
- Thailand 1
- Uruguay 1
cadence 1
- monthly · 9 ✖
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3283 | 3283 | Thailand | Thailand | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 71697024 | 46685 | 16 | TBC | monthly | 1 | |
4278 | 4278 | Uruguay | Uruguay | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 3422796 | 2511 | 16 | TBC | monthly | 4 | |
7259 | 7259 | Bahamas | Bahamas | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 409989 | 233 | 16 | TBC | monthly | 6 | |
8343 | 8343 | Barbados | Barbados | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 281646 | 178 | 16 | TBC | monthly | 7 | |
15011 | 15011 | Bermuda | Bermuda | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 64207 | 62 | 16 | TBC | monthly | 4 | |
19018 | 19018 | Hong Kong | Hong Kong | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 7488863 | 3849 | 16 | TBC | monthly | 9 | |
21021 | 21021 | Albania | Albania | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 2842318 | 1804 | 16 | TBC | monthly | 4 | |
39241 | 39241 | Seychelles | Seychelles | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 107135 | 108 | 16 | TBC | monthly | 6 | |
40072 | 40072 | Kazakhstan | Kazakhstan | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 19397998 | 14358 | 16 | TBC | monthly | 5 |
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]);