economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
45 rows where "end_date" is on date 2022-07-31 and "start_date" is on date 2022-07-25
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date (date)
country >30
- Australia 1
- Austria 1
- Belgium 1
- Britain 1
- Bulgaria 1
- Canada 1
- Chile 1
- Colombia 1
- Croatia 1
- Cyprus 1
- Czech Republic 1
- Denmark 1
- Ecuador 1
- Estonia 1
- Finland 1
- France 1
- Germany 1
- Greece 1
- Guatemala 1
- Hungary 1
- Iceland 1
- Iran 1
- Israel 1
- Italy 1
- Latvia 1
- Lithuania 1
- Luxembourg 1
- Malta 1
- Mexico 1
- Montenegro 1
- …
cadence 1
- weekly 45
| Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 395 | 395 | United States | United States | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 338289856 | 59126 | 3002 | TBC | weekly | |
| 880 | 880 | Ecuador | Ecuador | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 18001002 | 1742 | 15 | TBC | weekly | |
| 1366 | 1366 | Latvia | Latvia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 1850654 | 517 | 13 | TBC | weekly | |
| 1873 | 1873 | Slovakia | Slovakia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 5643455 | 1083 | 26 | TBC | weekly | |
| 2374 | 2374 | Bulgaria | Bulgaria | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 6781955 | 2137 | 47 | TBC | weekly | |
| 2784 | 2784 | Luxembourg | Luxembourg | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 647601 | 93 | 2 | TBC | weekly | |
| 3194 | 3194 | Belgium | Belgium | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 11655923 | 2011 | 110 | TBC | weekly | |
| 3701 | 3701 | Sweden | Sweden | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 10549349 | 1697.1 | 109 | TBC | weekly | |
| 4206 | 4206 | Australia | Australia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 26177410 | 4142 | 680 | TBC | weekly | |
| 4870 | 4870 | Czech Republic | Czech Republic | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 10493990 | 2167 | 90 | TBC | weekly | |
| 5279 | 5279 | Slovenia | Slovenia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 2119843 | 379 | 17 | TBC | weekly | |
| 5691 | 5691 | Estonia | Estonia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 1326064 | 315 | 8 | TBC | weekly | |
| 6278 | 6278 | Israel | Israel | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 9449000 | 981 | 86 | TBC | weekly | |
| 6689 | 6689 | Hungary | Hungary | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 9967304 | 2511 | 54 | TBC | weekly | |
| 7085 | 7085 | Peru | Peru | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 34049588 | 3451 | 275 | TBC | weekly | |
| 7838 | 7838 | South Korea | South Korea | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 51815808 | 6017 | 178 | TBC | weekly | |
| 8233 | 8233 | South Africa | South Africa | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 59893884 | 10858 | 39 | TBC | weekly | |
| 8835 | 8835 | Malta | Malta | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 533293 | 66 | 9 | TBC | weekly | |
| 9556 | 9556 | Romania | Romania | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 19659270 | 5163 | 142 | TBC | weekly | |
| 9965 | 9965 | New Zealand | New Zealand | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 5185289 | 967 | 47 | TBC | weekly | |
| 10463 | 10463 | Switzerland | Switzerland | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 8740471 | 1489 | 15 | TBC | weekly | |
| 11182 | 11182 | Lithuania | Lithuania | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 2750058 | 722 | 12 | TBC | weekly | |
| 11676 | 11676 | Britain | Britain | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 67508936 | 12547 | 754 | TBC | weekly | |
| 12090 | 12090 | Mexico | Mexico | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 127504120 | 15083 | 436 | TBC | weekly | |
| 12757 | 12757 | Iran | Iran | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 88550568 | 8788 | 314 | TBC | weekly | |
| 13257 | 13257 | Portugal | Portugal | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 10270857 | 2307 | 64 | TBC | weekly | |
| 13671 | 13671 | Croatia | Croatia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 4030361 | 1112 | 96 | TBC | weekly | |
| 14340 | 14340 | Montenegro | Montenegro | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 627082 | 143 | 8 | TBC | weekly | |
| 14926 | 14926 | Italy | Italy | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 59037472 | 16001 | 1211 | TBC | weekly | |
| 15415 | 15415 | Canada | Canada | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 38454328 | 5290 | 260 | TBC | weekly | |
| 15811 | 15811 | Finland | Finland | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 5540745 | 1098 | 0 | TBC | weekly | |
| 16563 | 16563 | Iceland | Iceland | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 372903 | 56 | 0 | TBC | weekly | |
| 17187 | 17187 | Netherlands | Netherlands | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 17564020 | 3133 | 36 | TBC | weekly | |
| 17602 | 17602 | Austria | Austria | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 8939617 | 1732 | 91 | TBC | weekly | |
| 18016 | 18016 | Spain | Spain | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 47558632 | 9896 | 532 | TBC | weekly | |
| 18520 | 18520 | Denmark | Denmark | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 5882259 | 1068 | 48 | TBC | weekly | |
| 18935 | 18935 | Cyprus | Cyprus | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 896007 | 149 | 16 | TBC | weekly | |
| 19625 | 19625 | Colombia | Colombia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 51874028 | 5455 | 242 | TBC | weekly | |
| 20202 | 20202 | Greece | Greece | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 10384972 | 3223 | 292 | TBC | weekly | |
| 20701 | 20701 | Poland | Poland | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 39857144 | 7645 | 60 | TBC | weekly | |
| 21443 | 21443 | France | France | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 67813000 | 11659 | 633 | TBC | weekly | |
| 37965 | 37965 | Guatemala | Guatemala | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 17843914 | 1742 | 103 | TBC | weekly | |
| 38361 | 38361 | Germany | Germany | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 83369840 | 20215 | 794 | TBC | weekly | |
| 39060 | 39060 | Chile | Chile | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 19603736 | 2676 | 245 | TBC | weekly | |
| 39643 | 39643 | Norway | Norway | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 5434324 | 800 | 27 | TBC | weekly |
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]);