economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where cadence = "monthly" and covid_deaths = 5
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, start_date, end_date, days, year, population, month, start_date (date), end_date (date)
country 18
- Bermuda 2
- Nicaragua 2
- Saint Kitts and Nevis 2
- Uruguay 2
- Albania 1
- Aruba 1
- Azerbaijan 1
- Belize 1
- Egypt 1
- Gibraltar 1
- Jordan 1
- Liechtenstein 1
- Mongolia 1
- Palestine 1
- Qatar 1
- Suriname 1
- Taiwan 1
- Tajikistan 1
cadence 1
- monthly · 22 ✖
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4279 | 4279 | Uruguay | Uruguay | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 3422796 | 2718 | 5 | TBC | monthly | 5 | |
4280 | 4280 | Uruguay | Uruguay | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 3422796 | 2707 | 5 | TBC | monthly | 6 | |
4396 | 4396 | Egypt | Egypt | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 110990096 | 42600 | 5 | TBC | monthly | 6 | |
8981 | 8981 | Tajikistan | Tajikistan | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 9952789 | 3234 | 5 | TBC | monthly | 6 | |
9058 | 9058 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 47681 | 39 | 5 | TBC | monthly | 11 | |
9060 | 9060 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 47681 | 70 | 5 | TBC | monthly | 1 | |
10065 | 10065 | Aruba | Aruba | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 106459 | 93 | 5 | TBC | monthly | 10 | |
12172 | 12172 | Gibraltar | Gibraltar | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 32677 | 26 | 5 | TBC | monthly | 11 | |
15012 | 15012 | Bermuda | Bermuda | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 64207 | 55 | 5 | TBC | monthly | 5 | |
15018 | 15018 | Bermuda | Bermuda | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 64207 | 57 | 5 | TBC | monthly | 11 | |
15914 | 15914 | Mongolia | Mongolia | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 3398373 | 1506 | 5 | TBC | monthly | 5 | |
16607 | 16607 | Palestine | Palestine | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 5250076 | 883 | 5 | TBC | monthly | 6 | |
16760 | 16760 | Azerbaijan | Azerbaijan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 10358078 | 5792 | 5 | TBC | monthly | 3 | |
18111 | 18111 | Taiwan | Taiwan | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 23893396 | 14415 | 5 | TBC | monthly | 10 | |
19206 | 19206 | Qatar | Qatar | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 2695131 | 168 | 5 | TBC | monthly | 11 | |
19806 | 19806 | Suriname | Suriname | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 618046 | 350 | 5 | TBC | monthly | 12 | |
20302 | 20302 | Liechtenstein | Liechtenstein | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 39355 | 28 | 5 | TBC | monthly | 2 | |
20769 | 20769 | Jordan | Jordan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 11285875 | 2486 | 5 | TBC | monthly | 3 | |
21035 | 21035 | Albania | Albania | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 2842318 | 1822 | 5 | TBC | monthly | 6 | |
39917 | 39917 | Belize | Belize | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 405285 | 178 | 5 | TBC | monthly | 6 | |
40170 | 40170 | Nicaragua | Nicaragua | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 6948395 | 2133 | 5 | TBC | monthly | 10 | |
40172 | 40172 | Nicaragua | Nicaragua | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 6948395 | 2322 | 5 | TBC | monthly | 12 |
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]);