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 2017-04-02
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
country 45
- 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
- Netherlands 1
- New Zealand 1
- Norway 1
- Peru 1
- Poland 1
- Portugal 1
- Romania 1
- Slovakia 1
- Slovenia 1
- South Africa 1
- South Korea 1
- Spain 1
- Sweden 1
- Switzerland 1
- United States 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117 | 117 | United States | United States | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 338289856 | 55829 | 0 | TBC | weekly | |
602 | 602 | Ecuador | Ecuador | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 18001002 | 1477 | 0 | TBC | weekly | |
1088 | 1088 | Latvia | Latvia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 1850654 | 570 | 0 | TBC | weekly | |
1595 | 1595 | Slovakia | Slovakia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5643455 | 1017 | 0 | TBC | weekly | |
2096 | 2096 | Bulgaria | Bulgaria | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 6781955 | 2098 | 0 | TBC | weekly | |
2506 | 2506 | Luxembourg | Luxembourg | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 647601 | 99 | 0 | TBC | weekly | |
2916 | 2916 | Belgium | Belgium | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 11655923 | 2068 | 0 | TBC | weekly | |
3423 | 3423 | Sweden | Sweden | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 10549349 | 1824.5 | 0 | TBC | weekly | |
3928 | 3928 | Australia | Australia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 26177410 | 2858 | 0 | TBC | weekly | |
4592 | 4592 | Czech Republic | Czech Republic | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 10493990 | 2075 | 0 | TBC | weekly | |
5001 | 5001 | Slovenia | Slovenia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 2119843 | 413 | 0 | TBC | weekly | |
5413 | 5413 | Estonia | Estonia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 1326064 | 322 | 0 | TBC | weekly | |
6000 | 6000 | Israel | Israel | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 9449000 | 903 | 0 | TBC | weekly | |
6411 | 6411 | Hungary | Hungary | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 9967304 | 2546 | 0 | TBC | weekly | |
6807 | 6807 | Peru | Peru | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 34049588 | 2707.3 | 0 | TBC | weekly | |
7560 | 7560 | South Korea | South Korea | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 51815808 | 5425 | 0 | TBC | weekly | |
7955 | 7955 | South Africa | South Africa | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 59893884 | 9251 | 0 | TBC | weekly | |
8557 | 8557 | Malta | Malta | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 533293 | 74 | 0 | TBC | weekly | |
9278 | 9278 | Romania | Romania | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 19659270 | 4955 | 0 | TBC | weekly | |
9687 | 9687 | New Zealand | New Zealand | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5185289 | 596 | 0 | TBC | weekly | |
10185 | 10185 | Switzerland | Switzerland | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 8740471 | 1183 | 0 | TBC | weekly | |
10904 | 10904 | Lithuania | Lithuania | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 2750058 | 771 | 0 | TBC | weekly | |
11398 | 11398 | Britain | Britain | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 67508936 | 11453 | 0 | TBC | weekly | |
11812 | 11812 | Mexico | Mexico | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 127504120 | 13307 | 0 | TBC | weekly | |
12480 | 12480 | Iran | Iran | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 88550568 | 8816.1 | 0 | TBC | weekly | |
12979 | 12979 | Portugal | Portugal | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 10270857 | 2015 | 0 | TBC | weekly | |
13393 | 13393 | Croatia | Croatia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 4030361 | 969 | 0 | TBC | weekly | |
14063 | 14063 | Montenegro | Montenegro | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 627082 | 114 | 0 | TBC | weekly | |
14648 | 14648 | Italy | Italy | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 59037472 | 12300 | 0 | TBC | weekly | |
15137 | 15137 | Canada | Canada | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 38454328 | 5490 | 0 | TBC | weekly | |
15533 | 15533 | Finland | Finland | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5540745 | 985 | 0 | TBC | weekly | |
16285 | 16285 | Iceland | Iceland | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 372903 | 48 | 0 | TBC | weekly | |
16909 | 16909 | Netherlands | Netherlands | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 17564020 | 2853 | 0 | TBC | weekly | |
17324 | 17324 | Austria | Austria | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 8939617 | 1489 | 0 | TBC | weekly | |
17738 | 17738 | Spain | Spain | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 47558632 | 7827 | 0 | TBC | weekly | |
18242 | 18242 | Denmark | Denmark | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5882259 | 1041 | 0 | TBC | weekly | |
18657 | 18657 | Cyprus | Cyprus | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 896007 | 105 | 0 | TBC | weekly | |
19347 | 19347 | Colombia | Colombia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 51874028 | 4477 | 0 | TBC | weekly | |
19924 | 19924 | Greece | Greece | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 10384972 | 2253 | 0 | TBC | weekly | |
20423 | 20423 | Poland | Poland | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 39857144 | 7684 | 0 | TBC | weekly | |
21165 | 21165 | France | France | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 67813000 | 10795 | 0 | TBC | weekly | |
37687 | 37687 | Guatemala | Guatemala | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 17843914 | 1648 | 0 | TBC | weekly | |
38083 | 38083 | Germany | Germany | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 83369840 | 17731 | 0 | TBC | weekly | |
38782 | 38782 | Chile | Chile | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 19603736 | 1800 | 0 | TBC | weekly | |
39365 | 39365 | Norway | Norway | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 5434324 | 756 | 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]);