economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
32 rows where month = 7 and "start_date" is on date 2022-07-01
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, start_date (date), end_date (date)
country >30
- Armenia 1
- Azerbaijan 1
- Barbados 1
- Bosnia and Herzegovina 1
- Brazil 1
- Egypt 1
- Faroe Islands 1
- Greenland 1
- Hong Kong 1
- Ireland 1
- Japan 1
- Kazakhstan 1
- Kosovo 1
- Kyrgyzstan 1
- Macao 1
- Malaysia 1
- Moldova 1
- Monaco 1
- Mongolia 1
- North Macedonia 1
- Oman 1
- Paraguay 1
- Qatar 1
- Russia 1
- Saint Kitts and Nevis 1
- San Marino 1
- Serbia 1
- Singapore 1
- Taiwan 1
- Thailand 1
- …
cadence 1
- monthly 32
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1474 | 1474 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 6630621 | 2378 | 0 | TBC | monthly | 7 | |
1975 | 1975 | Brazil | Brazil | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 215313504 | 136795 | 7098 | TBC | monthly | 7 | |
3301 | 3301 | Thailand | Thailand | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 71697024 | 44147 | 756 | TBC | monthly | 7 | |
3807 | 3807 | Japan | Japan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 123951696 | 117568 | 1332 | TBC | monthly | 7 | |
4305 | 4305 | Uruguay | Uruguay | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3422796 | 3795 | 72 | TBC | monthly | 7 | |
4397 | 4397 | Egypt | Egypt | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 110990096 | 45300 | 42 | TBC | monthly | 7 | |
7440 | 7440 | Malaysia | Malaysia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 33938216 | 19099 | 204 | TBC | monthly | 7 | |
8343 | 8343 | Barbados | Barbados | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 281646 | 178 | 16 | TBC | monthly | 7 | |
8436 | 8436 | San Marino | San Marino | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 33690 | 22 | 3 | TBC | monthly | 7 | |
9066 | 9066 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 47681 | 33 | 3 | TBC | monthly | 7 | |
9158 | 9158 | Greenland | Greenland | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 56494 | 43 | 0 | TBC | monthly | 7 | |
10570 | 10570 | Paraguay | Paraguay | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 6780745 | 3433 | 257 | TBC | monthly | 7 | |
10664 | 10664 | Singapore | Singapore | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 5637022 | 2391 | 87 | TBC | monthly | 7 | |
12265 | 12265 | Macao | Macao | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 695180 | 203 | 6 | TBC | monthly | 7 | |
12359 | 12359 | Oman | Oman | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 4576300 | 818 | 0 | TBC | monthly | 7 | |
12858 | 12858 | Faroe Islands | Faroe Islands | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 49085 | 46 | 0 | TBC | monthly | 7 | |
13848 | 13848 | Serbia | Serbia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 6871547 | 7848 | 154 | TBC | monthly | 7 | |
13942 | 13942 | Armenia | Armenia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 2780472 | 1869 | 4 | TBC | monthly | 7 | |
14435 | 14435 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3233530 | 2779 | 47 | TBC | monthly | 7 | |
14528 | 14528 | Moldova | Moldova | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3272993 | 2529 | 41 | TBC | monthly | 7 | |
15916 | 15916 | Mongolia | Mongolia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3398373 | 1438 | 1 | TBC | monthly | 7 | |
16011 | 16011 | North Macedonia | North Macedonia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 2093606 | 1528 | 45 | TBC | monthly | 7 | |
16788 | 16788 | Azerbaijan | Azerbaijan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 10358078 | 4594 | 31 | TBC | monthly | 7 | |
18120 | 18120 | Taiwan | Taiwan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 23893396 | 18215 | 2276 | TBC | monthly | 7 | |
19040 | 19040 | Hong Kong | Hong Kong | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 7488863 | 3952 | 102 | TBC | monthly | 7 | |
19133 | 19133 | Uzbekistan | Uzbekistan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 34627648 | 17269 | 0 | TBC | monthly | 7 | |
19226 | 19226 | Qatar | Qatar | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 2695131 | 213 | 2 | TBC | monthly | 7 | |
19731 | 19731 | Ireland | Ireland | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 5023108 | 2749 | 176 | TBC | monthly | 7 | |
37566 | 37566 | Russia | Russia | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 144713312 | 131763 | 1279 | TBC | monthly | 7 | |
38469 | 38469 | Monaco | Monaco | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 36491 | 42 | 3 | TBC | monthly | 7 | |
39752 | 39752 | Kosovo | Kosovo | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 1782115 | 736 | 31 | TBC | monthly | 7 | |
40098 | 40098 | Kazakhstan | Kazakhstan | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 19397998 | 10628 | 4 | TBC | monthly | 7 |
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]);