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 2018-08-05
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
187 | 187 | United States | United States | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 338289856 | 50800 | 0 | TBC | weekly | |
672 | 672 | Ecuador | Ecuador | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 18001002 | 1376 | 0 | TBC | weekly | |
1158 | 1158 | Latvia | Latvia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 1850654 | 592 | 0 | TBC | weekly | |
1665 | 1665 | Slovakia | Slovakia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 5643455 | 1110 | 0 | TBC | weekly | |
2166 | 2166 | Bulgaria | Bulgaria | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 6781955 | 1902 | 0 | TBC | weekly | |
2576 | 2576 | Luxembourg | Luxembourg | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 647601 | 100 | 0 | TBC | weekly | |
2986 | 2986 | Belgium | Belgium | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 11655923 | 2125 | 0 | TBC | weekly | |
3493 | 3493 | Sweden | Sweden | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 10549349 | 1770.2 | 0 | TBC | weekly | |
3998 | 3998 | Australia | Australia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 26177410 | 3286 | 0 | TBC | weekly | |
4662 | 4662 | Czech Republic | Czech Republic | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 10493990 | 2379 | 0 | TBC | weekly | |
5071 | 5071 | Slovenia | Slovenia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 2119843 | 399 | 0 | TBC | weekly | |
5483 | 5483 | Estonia | Estonia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 1326064 | 321 | 0 | TBC | weekly | |
6070 | 6070 | Israel | Israel | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 9449000 | 752 | 0 | TBC | weekly | |
6481 | 6481 | Hungary | Hungary | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 9967304 | 2479 | 0 | TBC | weekly | |
6877 | 6877 | Peru | Peru | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 34049588 | 3211 | 0 | TBC | weekly | |
7630 | 7630 | South Korea | South Korea | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 51815808 | 5843 | 0 | TBC | weekly | |
8025 | 8025 | South Africa | South Africa | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 59893884 | 10648 | 0 | TBC | weekly | |
8627 | 8627 | Malta | Malta | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 533293 | 58 | 0 | TBC | weekly | |
9348 | 9348 | Romania | Romania | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 19659270 | 4708 | 0 | TBC | weekly | |
9757 | 9757 | New Zealand | New Zealand | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 5185289 | 683 | 0 | TBC | weekly | |
10255 | 10255 | Switzerland | Switzerland | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 8740471 | 1264 | 0 | TBC | weekly | |
10974 | 10974 | Lithuania | Lithuania | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 2750058 | 807 | 0 | TBC | weekly | |
11468 | 11468 | Britain | Britain | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 67508936 | 10408 | 0 | TBC | weekly | |
11882 | 11882 | Mexico | Mexico | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 127504120 | 12997 | 0 | TBC | weekly | |
12550 | 12550 | Iran | Iran | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 88550568 | 7289.1 | 0 | TBC | weekly | |
13049 | 13049 | Portugal | Portugal | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 10270857 | 2250 | 0 | TBC | weekly | |
13463 | 13463 | Croatia | Croatia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 4030361 | 1044 | 0 | TBC | weekly | |
14133 | 14133 | Montenegro | Montenegro | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 627082 | 120 | 0 | TBC | weekly | |
14718 | 14718 | Italy | Italy | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 59037472 | 12305 | 0 | TBC | weekly | |
15207 | 15207 | Canada | Canada | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 38454328 | 4980 | 0 | TBC | weekly | |
15603 | 15603 | Finland | Finland | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 5540745 | 1063 | 0 | TBC | weekly | |
16355 | 16355 | Iceland | Iceland | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 372903 | 41 | 0 | TBC | weekly | |
16979 | 16979 | Netherlands | Netherlands | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 17564020 | 2761 | 0 | TBC | weekly | |
17394 | 17394 | Austria | Austria | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 8939617 | 1615 | 0 | TBC | weekly | |
17808 | 17808 | Spain | Spain | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 47558632 | 7731 | 0 | TBC | weekly | |
18312 | 18312 | Denmark | Denmark | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 5882259 | 1084 | 0 | TBC | weekly | |
18727 | 18727 | Cyprus | Cyprus | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 896007 | 106 | 0 | TBC | weekly | |
19417 | 19417 | Colombia | Colombia | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 51874028 | 4429 | 0 | TBC | weekly | |
19994 | 19994 | Greece | Greece | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 10384972 | 2231 | 0 | TBC | weekly | |
20493 | 20493 | Poland | Poland | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 39857144 | 8007 | 0 | TBC | weekly | |
21235 | 21235 | France | France | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 67813000 | 10765 | 0 | TBC | weekly | |
37757 | 37757 | Guatemala | Guatemala | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 17843914 | 1340 | 0 | TBC | weekly | |
38153 | 38153 | Germany | Germany | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 83369840 | 20371 | 0 | TBC | weekly | |
38852 | 38852 | Chile | Chile | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 19603736 | 2514 | 0 | TBC | weekly | |
39435 | 39435 | Norway | Norway | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 5434324 | 677 | 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]);