economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
36 rows where cadence = "monthly" and "end_date" is on date 2022-06-30
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, start_date (date)
country 36
- Albania 1
- Armenia 1
- Azerbaijan 1
- Barbados 1
- Bosnia and Herzegovina 1
- Brazil 1
- Egypt 1
- Faroe Islands 1
- Georgia 1
- Greenland 1
- Hong Kong 1
- Ireland 1
- Japan 1
- Kazakhstan 1
- Kosovo 1
- Kyrgyzstan 1
- Macao 1
- Malaysia 1
- Mauritius 1
- Moldova 1
- Monaco 1
- Mongolia 1
- North Macedonia 1
- Oman 1
- Paraguay 1
- Philippines 1
- Qatar 1
- Russia 1
- Saint Kitts and Nevis 1
- San Marino 1
- Serbia 1
- Singapore 1
- Taiwan 1
- Thailand 1
- Uruguay 1
- Uzbekistan 1
cadence 1
- monthly · 36 ✖
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1473 | 1473 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6630621 | 2483 | 0 | TBC | monthly | 6 | |
1974 | 1974 | Brazil | Brazil | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 215313504 | 140232 | 4740 | TBC | monthly | 6 | |
3300 | 3300 | Thailand | Thailand | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 71697024 | 47056 | 629 | TBC | monthly | 6 | |
3806 | 3806 | Japan | Japan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 123951696 | 111904 | 658 | TBC | monthly | 6 | |
4304 | 4304 | Uruguay | Uruguay | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3422796 | 3967 | 93 | TBC | monthly | 6 | |
4396 | 4396 | Egypt | Egypt | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 110990096 | 42600 | 5 | TBC | monthly | 6 | |
5882 | 5882 | Mauritius | Mauritius | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 1299478 | 1020 | 7 | TBC | monthly | 6 | |
6794 | 6794 | Georgia | Georgia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3744385 | 3248 | 14 | TBC | monthly | 6 | |
7439 | 7439 | Malaysia | Malaysia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 33938216 | 14038 | 89 | TBC | monthly | 6 | |
8342 | 8342 | Barbados | Barbados | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 281646 | 287 | 27 | TBC | monthly | 6 | |
8435 | 8435 | San Marino | San Marino | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 33690 | 22 | 0 | TBC | monthly | 6 | |
9065 | 9065 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 47681 | 38 | 0 | TBC | monthly | 6 | |
9157 | 9157 | Greenland | Greenland | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 56494 | 33 | 0 | TBC | monthly | 6 | |
10569 | 10569 | Paraguay | Paraguay | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6780745 | 3394 | 69 | TBC | monthly | 6 | |
10663 | 10663 | Singapore | Singapore | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 5637022 | 2110 | 24 | TBC | monthly | 6 | |
12264 | 12264 | Macao | Macao | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 695180 | 228 | 0 | TBC | monthly | 6 | |
12358 | 12358 | Oman | Oman | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 4576300 | 659 | 0 | TBC | monthly | 6 | |
12857 | 12857 | Faroe Islands | Faroe Islands | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 49085 | 35 | 0 | TBC | monthly | 6 | |
13847 | 13847 | Serbia | Serbia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6871547 | 7744 | 45 | TBC | monthly | 6 | |
13941 | 13941 | Armenia | Armenia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 2780472 | 1879 | 4 | TBC | monthly | 6 | |
14434 | 14434 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3233530 | 2705 | 18 | TBC | monthly | 6 | |
14527 | 14527 | Moldova | Moldova | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3272993 | 2644 | 30 | TBC | monthly | 6 | |
15915 | 15915 | Mongolia | Mongolia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3398373 | 1424 | 3 | TBC | monthly | 6 | |
16010 | 16010 | North Macedonia | North Macedonia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 2093606 | 1775 | 22 | TBC | monthly | 6 | |
16787 | 16787 | Azerbaijan | Azerbaijan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 10358078 | 4491 | 4 | TBC | monthly | 6 | |
18119 | 18119 | Taiwan | Taiwan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 23893396 | 21033 | 4396 | TBC | monthly | 6 | |
19039 | 19039 | Hong Kong | Hong Kong | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 7488863 | 3496 | 23 | TBC | monthly | 6 | |
19132 | 19132 | Uzbekistan | Uzbekistan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 34627648 | 14817 | 0 | TBC | monthly | 6 | |
19225 | 19225 | Qatar | Qatar | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 2695131 | 178 | 2 | TBC | monthly | 6 | |
19730 | 19730 | Ireland | Ireland | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 5023108 | 2612 | 195 | TBC | monthly | 6 | |
21047 | 21047 | Albania | Albania | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 2842318 | 1534 | 3 | TBC | monthly | 6 | |
37565 | 37565 | Russia | Russia | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 144713312 | 140730 | 1940 | TBC | monthly | 6 | |
38468 | 38468 | Monaco | Monaco | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 36491 | 39 | 1 | TBC | monthly | 6 | |
38645 | 38645 | Philippines | Philippines | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 115559008 | 49353 | 100 | TBC | monthly | 6 | |
39751 | 39751 | Kosovo | Kosovo | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 1782115 | 640 | 1 | TBC | monthly | 6 | |
40097 | 40097 | Kazakhstan | Kazakhstan | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 19397998 | 10730 | 3 | TBC | monthly | 6 |
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]);