economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
40 rows where month = 1 and "start_date" is on date 2022-01-01
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), end_date (date)
country >30
- Albania 1
- Armenia 1
- Azerbaijan 1
- Barbados 1
- Bolivia 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
- Liechtenstein 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
- …
cadence 1
- monthly 40
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1468 | 1468 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 6630621 | 2671 | 78 | TBC | monthly | 1 | |
1969 | 1969 | Brazil | Brazil | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 215313504 | 167728 | 8255 | TBC | monthly | 1 | |
3295 | 3295 | Thailand | Thailand | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 71697024 | 48377 | 475 | TBC | monthly | 1 | |
3801 | 3801 | Japan | Japan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 123951696 | 143992 | 423 | TBC | monthly | 1 | |
4299 | 4299 | Uruguay | Uruguay | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3422796 | 3766 | 309 | TBC | monthly | 1 | |
4391 | 4391 | Egypt | Egypt | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 110990096 | 69000 | 883 | TBC | monthly | 1 | |
5792 | 5792 | Bolivia | Bolivia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 12224114 | 9779 | 1271 | TBC | monthly | 1 | |
5877 | 5877 | Mauritius | Mauritius | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 1299478 | 1134 | 36 | TBC | monthly | 1 | |
6789 | 6789 | Georgia | Georgia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3744385 | 5603 | 1130 | TBC | monthly | 1 | |
7180 | 7180 | Tunisia | Tunisia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 12356116 | 8047 | 719 | TBC | monthly | 1 | |
7434 | 7434 | Malaysia | Malaysia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 33938216 | 16465 | 491 | TBC | monthly | 1 | |
8337 | 8337 | Barbados | Barbados | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 281646 | 297 | 20 | TBC | monthly | 1 | |
8430 | 8430 | San Marino | San Marino | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 33690 | 33 | 9 | TBC | monthly | 1 | |
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 | |
9152 | 9152 | Greenland | Greenland | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 56494 | 47 | 4 | TBC | monthly | 1 | |
10564 | 10564 | Paraguay | Paraguay | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 6780745 | 6205 | 697 | TBC | monthly | 1 | |
10658 | 10658 | Singapore | Singapore | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 5637022 | 1970 | 27 | TBC | monthly | 1 | |
12259 | 12259 | Macao | Macao | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 695180 | 205 | 0 | TBC | monthly | 1 | |
12353 | 12353 | Oman | Oman | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 4576300 | 958 | 30 | TBC | monthly | 1 | |
12852 | 12852 | Faroe Islands | Faroe Islands | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 49085 | 40 | 0 | TBC | monthly | 1 | |
13842 | 13842 | Serbia | Serbia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 6871547 | 11392 | 915 | TBC | monthly | 1 | |
13936 | 13936 | Armenia | Armenia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 2780472 | 2789 | 81 | TBC | monthly | 1 | |
14429 | 14429 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3233530 | 3985 | 1005 | TBC | monthly | 1 | |
14522 | 14522 | Moldova | Moldova | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3272993 | 3873 | 367 | TBC | monthly | 1 | |
15910 | 15910 | Mongolia | Mongolia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3398373 | 1345 | 50 | TBC | monthly | 1 | |
16005 | 16005 | North Macedonia | North Macedonia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 2093606 | 2228 | 449 | TBC | monthly | 1 | |
16782 | 16782 | Azerbaijan | Azerbaijan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 10358078 | 6009 | 376 | TBC | monthly | 1 | |
18114 | 18114 | Taiwan | Taiwan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 23893396 | 15954 | 1 | TBC | monthly | 1 | |
19034 | 19034 | Hong Kong | Hong Kong | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 7488863 | 4736 | 0 | TBC | monthly | 1 | |
19127 | 19127 | Uzbekistan | Uzbekistan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 34627648 | 11848 | 79 | TBC | monthly | 1 | |
19220 | 19220 | Qatar | Qatar | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 2695131 | 292 | 27 | TBC | monthly | 1 | |
19725 | 19725 | Ireland | Ireland | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 5023108 | 3134 | 224 | TBC | monthly | 1 | |
20301 | 20301 | Liechtenstein | Liechtenstein | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 39355 | 35 | 4 | TBC | monthly | 1 | |
20957 | 20957 | Ukraine | Ukraine | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 39701744 | 57248 | 4792 | TBC | monthly | 1 | |
21042 | 21042 | Albania | Albania | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 2842318 | 3294 | 129 | TBC | monthly | 1 | |
37560 | 37560 | Russia | Russia | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 144713312 | 192952 | 22001 | TBC | monthly | 1 | |
38463 | 38463 | Monaco | Monaco | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 36491 | 51 | 9 | TBC | monthly | 1 | |
38640 | 38640 | Philippines | Philippines | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 115559008 | 69869 | 2499 | TBC | monthly | 1 | |
39746 | 39746 | Kosovo | Kosovo | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 1782115 | 900 | 25 | TBC | monthly | 1 | |
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]);