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 2019-07-28 and year = 2019
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | 238 | United States | United States | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 338289856 | 51805 | 0 | TBC | weekly | |
723 | 723 | Ecuador | Ecuador | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 18001002 | 1365 | 0 | TBC | weekly | |
1209 | 1209 | Latvia | Latvia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 1850654 | 492 | 0 | TBC | weekly | |
1716 | 1716 | Slovakia | Slovakia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 5643455 | 1025 | 0 | TBC | weekly | |
2217 | 2217 | Bulgaria | Bulgaria | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 6781955 | 1963 | 0 | TBC | weekly | |
2627 | 2627 | Luxembourg | Luxembourg | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 647601 | 72 | 0 | TBC | weekly | |
3037 | 3037 | Belgium | Belgium | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 11655923 | 2318 | 0 | TBC | weekly | |
3544 | 3544 | Sweden | Sweden | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 10549349 | 1568.8 | 0 | TBC | weekly | |
4049 | 4049 | Australia | Australia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 26177410 | 3491 | 0 | TBC | weekly | |
4713 | 4713 | Czech Republic | Czech Republic | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 10493990 | 2171 | 0 | TBC | weekly | |
5122 | 5122 | Slovenia | Slovenia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 2119843 | 407 | 0 | TBC | weekly | |
5534 | 5534 | Estonia | Estonia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 1326064 | 314 | 0 | TBC | weekly | |
6121 | 6121 | Israel | Israel | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 9449000 | 802 | 0 | TBC | weekly | |
6532 | 6532 | Hungary | Hungary | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 9967304 | 2471 | 0 | TBC | weekly | |
6928 | 6928 | Peru | Peru | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 34049588 | 3107 | 0 | TBC | weekly | |
7681 | 7681 | South Korea | South Korea | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 51815808 | 5289 | 0 | TBC | weekly | |
8076 | 8076 | South Africa | South Africa | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 59893884 | 10732 | 0 | TBC | weekly | |
8678 | 8678 | Malta | Malta | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 533293 | 65 | 0 | TBC | weekly | |
9399 | 9399 | Romania | Romania | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 19659270 | 4728 | 0 | TBC | weekly | |
9808 | 9808 | New Zealand | New Zealand | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 5185289 | 728 | 0 | TBC | weekly | |
10306 | 10306 | Switzerland | Switzerland | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 8740471 | 1260 | 0 | TBC | weekly | |
11025 | 11025 | Lithuania | Lithuania | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 2750058 | 727 | 0 | TBC | weekly | |
11519 | 11519 | Britain | Britain | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 67508936 | 10422 | 0 | TBC | weekly | |
11933 | 11933 | Mexico | Mexico | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 127504120 | 13256 | 0 | TBC | weekly | |
12601 | 12601 | Iran | Iran | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 88550568 | 7425.9 | 0 | TBC | weekly | |
13100 | 13100 | Portugal | Portugal | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 10270857 | 1841 | 0 | TBC | weekly | |
13514 | 13514 | Croatia | Croatia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 4030361 | 985 | 0 | TBC | weekly | |
14184 | 14184 | Montenegro | Montenegro | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 627082 | 123 | 0 | TBC | weekly | |
14769 | 14769 | Italy | Italy | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 59037472 | 12024 | 0 | TBC | weekly | |
15258 | 15258 | Canada | Canada | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 38454328 | 5080 | 0 | TBC | weekly | |
15654 | 15654 | Finland | Finland | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 5540745 | 1022 | 0 | TBC | weekly | |
16406 | 16406 | Iceland | Iceland | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 372903 | 56 | 0 | TBC | weekly | |
17030 | 17030 | Netherlands | Netherlands | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 17564020 | 3009 | 0 | TBC | weekly | |
17445 | 17445 | Austria | Austria | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 8939617 | 1557 | 0 | TBC | weekly | |
17859 | 17859 | Spain | Spain | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 47558632 | 7464 | 0 | TBC | weekly | |
18363 | 18363 | Denmark | Denmark | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 5882259 | 967 | 0 | TBC | weekly | |
18778 | 18778 | Cyprus | Cyprus | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 896007 | 75 | 0 | TBC | weekly | |
19468 | 19468 | Colombia | Colombia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 51874028 | 4623 | 0 | TBC | weekly | |
20045 | 20045 | Greece | Greece | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 10384972 | 2337 | 0 | TBC | weekly | |
20544 | 20544 | Poland | Poland | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 39857144 | 7660 | 0 | TBC | weekly | |
21286 | 21286 | France | France | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 67813000 | 11339 | 0 | TBC | weekly | |
37808 | 37808 | Guatemala | Guatemala | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 17843914 | 1659 | 0 | TBC | weekly | |
38204 | 38204 | Germany | Germany | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 83369840 | 19630 | 0 | TBC | weekly | |
38903 | 38903 | Chile | Chile | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 19603736 | 2343 | 0 | TBC | weekly | |
39486 | 39486 | Norway | Norway | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 5434324 | 721 | 0 | 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]);