economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
5,860 rows where year = 2017 sorted by total_deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, start_date (date), end_date (date)
country >30
- United States 2,756
- Australia 52
- Austria 52
- Belgium 52
- Britain 52
- Bulgaria 52
- Canada 52
- Chile 52
- Colombia 52
- Croatia 52
- Cyprus 52
- Czech Republic 52
- Denmark 52
- Ecuador 52
- Estonia 52
- Finland 52
- France 52
- Germany 52
- Greece 52
- Guatemala 52
- Hungary 52
- Iceland 52
- Iran 52
- Israel 52
- Italy 52
- Latvia 52
- Lithuania 52
- Luxembourg 52
- Malta 52
- Mexico 52
- …
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths ▲ | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37500 | 37500 | Russia | Russia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 144713312 | 179736.5 | 0 | TBC | monthly | 1 | |
37504 | 37504 | Russia | Russia | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 144713312 | 154791 | 0 | TBC | monthly | 5 | |
37509 | 37509 | Russia | Russia | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 144713312 | 154450.9 | 0 | TBC | monthly | 10 | |
37502 | 37502 | Russia | Russia | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 144713312 | 154313.8 | 0 | TBC | monthly | 3 | |
37511 | 37511 | Russia | Russia | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 144713312 | 152239.9 | 0 | TBC | monthly | 12 | |
37503 | 37503 | Russia | Russia | 0 | 2017-04-01 | 2017-04-30 | 30 | 2017 | 144713312 | 149933 | 0 | TBC | monthly | 4 | |
37506 | 37506 | Russia | Russia | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 144713312 | 149745.9 | 0 | TBC | monthly | 7 | |
37501 | 37501 | Russia | Russia | 0 | 2017-02-01 | 2017-02-28 | 28 | 2017 | 144713312 | 149011.6 | 0 | TBC | monthly | 2 | |
37505 | 37505 | Russia | Russia | 0 | 2017-06-01 | 2017-06-30 | 30 | 2017 | 144713312 | 148641.4 | 0 | TBC | monthly | 6 | |
37507 | 37507 | Russia | Russia | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 144713312 | 146025.3 | 0 | TBC | monthly | 8 | |
37508 | 37508 | Russia | Russia | 0 | 2017-09-01 | 2017-09-30 | 30 | 2017 | 144713312 | 144414.7 | 0 | TBC | monthly | 9 | |
37510 | 37510 | Russia | Russia | 0 | 2017-11-01 | 2017-11-30 | 30 | 2017 | 144713312 | 142821 | 0 | TBC | monthly | 11 | |
3741 | 3741 | Japan | Japan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 123951696 | 134174 | 0 | TBC | monthly | 1 | |
3752 | 3752 | Japan | Japan | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 123951696 | 124807 | 0 | TBC | monthly | 12 | |
1915 | 1915 | Brazil | Brazil | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 215313504 | 122610 | 0 | TBC | monthly | 7 | |
3743 | 3743 | Japan | Japan | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 123951696 | 120019 | 0 | TBC | monthly | 3 | |
3742 | 3742 | Japan | Japan | 0 | 2017-02-01 | 2017-02-28 | 28 | 2017 | 123951696 | 116534 | 0 | TBC | monthly | 2 | |
3751 | 3751 | Japan | Japan | 0 | 2017-11-01 | 2017-11-30 | 30 | 2017 | 123951696 | 115170 | 0 | TBC | monthly | 11 | |
1913 | 1913 | Brazil | Brazil | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 215313504 | 114774 | 0 | TBC | monthly | 5 | |
1916 | 1916 | Brazil | Brazil | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 215313504 | 114698 | 0 | TBC | monthly | 8 | |
1914 | 1914 | Brazil | Brazil | 0 | 2017-06-01 | 2017-06-30 | 30 | 2017 | 215313504 | 114324 | 0 | TBC | monthly | 6 | |
3750 | 3750 | Japan | Japan | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 123951696 | 110422 | 0 | TBC | monthly | 10 | |
1918 | 1918 | Brazil | Brazil | 0 | 2017-10-01 | 2017-10-31 | 31 | 2017 | 215313504 | 109666 | 0 | TBC | monthly | 10 | |
1911 | 1911 | Brazil | Brazil | 0 | 2017-03-01 | 2017-03-31 | 31 | 2017 | 215313504 | 108850 | 0 | TBC | monthly | 3 | |
3744 | 3744 | Japan | Japan | 0 | 2017-04-01 | 2017-04-30 | 30 | 2017 | 123951696 | 108422 | 0 | TBC | monthly | 4 | |
1920 | 1920 | Brazil | Brazil | 0 | 2017-12-01 | 2017-12-31 | 31 | 2017 | 215313504 | 107971 | 0 | TBC | monthly | 12 | |
1917 | 1917 | Brazil | Brazil | 0 | 2017-09-01 | 2017-09-30 | 30 | 2017 | 215313504 | 107336 | 0 | TBC | monthly | 9 | |
1912 | 1912 | Brazil | Brazil | 0 | 2017-04-01 | 2017-04-30 | 30 | 2017 | 215313504 | 107063 | 0 | TBC | monthly | 4 | |
3745 | 3745 | Japan | Japan | 0 | 2017-05-01 | 2017-05-31 | 31 | 2017 | 123951696 | 106278 | 0 | TBC | monthly | 5 | |
1909 | 1909 | Brazil | Brazil | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 215313504 | 105899 | 0 | TBC | monthly | 1 | |
3748 | 3748 | Japan | Japan | 0 | 2017-08-01 | 2017-08-31 | 31 | 2017 | 123951696 | 103617 | 0 | TBC | monthly | 8 | |
1919 | 1919 | Brazil | Brazil | 0 | 2017-11-01 | 2017-11-30 | 30 | 2017 | 215313504 | 102390 | 0 | TBC | monthly | 11 | |
3747 | 3747 | Japan | Japan | 0 | 2017-07-01 | 2017-07-31 | 31 | 2017 | 123951696 | 102387 | 0 | TBC | monthly | 7 | |
3749 | 3749 | Japan | Japan | 0 | 2017-09-01 | 2017-09-30 | 30 | 2017 | 123951696 | 100893 | 0 | TBC | monthly | 9 | |
3746 | 3746 | Japan | Japan | 0 | 2017-06-01 | 2017-06-30 | 30 | 2017 | 123951696 | 97844 | 0 | TBC | monthly | 6 | |
1910 | 1910 | Brazil | Brazil | 0 | 2017-02-01 | 2017-02-28 | 28 | 2017 | 215313504 | 97082 | 0 | TBC | monthly | 2 | |
156 | 156 | United States | United States | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 338289856 | 61255 | 0 | TBC | weekly | |
37218 | 37218 | United States | United States | USA | 2017-12-24 | 2017-12-30 | 7 | 2017 | 52 | 328300544 | 61255 | 0 | 58422 | weekly | |
106 | 106 | United States | United States | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 338289856 | 61118 | 0 | TBC | weekly | |
37168 | 37168 | United States | United States | USA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 328300544 | 61118 | 0 | 55329 | weekly | |
105 | 105 | United States | United States | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 338289856 | 59901 | 0 | TBC | weekly | |
37167 | 37167 | United States | United States | USA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 328300544 | 59901 | 0 | 55028 | weekly | |
155 | 155 | United States | United States | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 338289856 | 59674 | 0 | TBC | weekly | |
37217 | 37217 | United States | United States | USA | 2017-12-17 | 2017-12-23 | 7 | 2017 | 51 | 328300544 | 59674 | 0 | 57853 | weekly | |
107 | 107 | United States | United States | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 338289856 | 59445 | 0 | TBC | weekly | |
37169 | 37169 | United States | United States | USA | 2017-01-15 | 2017-01-21 | 7 | 2017 | 3 | 328300544 | 59445 | 0 | 55321 | weekly | |
110 | 110 | United States | United States | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 338289856 | 59164 | 0 | TBC | weekly | |
37172 | 37172 | United States | United States | USA | 2017-02-05 | 2017-02-11 | 7 | 2017 | 6 | 328300544 | 59164 | 0 | 55423 | weekly | |
4331 | 4331 | Egypt | Egypt | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 110990096 | 58898 | 0 | TBC | monthly | 1 | |
111 | 111 | United States | United States | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 338289856 | 58596 | 0 | TBC | weekly | |
37173 | 37173 | United States | United States | USA | 2017-02-12 | 2017-02-18 | 7 | 2017 | 7 | 328300544 | 58596 | 0 | 55241 | weekly | |
109 | 109 | United States | United States | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 338289856 | 58541 | 0 | TBC | weekly | |
37171 | 37171 | United States | United States | USA | 2017-01-29 | 2017-02-04 | 7 | 2017 | 5 | 328300544 | 58541 | 0 | 55553 | weekly | |
112 | 112 | United States | United States | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 338289856 | 58386 | 0 | TBC | weekly | |
37174 | 37174 | United States | United States | USA | 2017-02-19 | 2017-02-25 | 7 | 2017 | 8 | 328300544 | 58386 | 0 | 54924 | weekly | |
108 | 108 | United States | United States | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 338289856 | 58178 | 0 | TBC | weekly | |
37170 | 37170 | United States | United States | USA | 2017-01-22 | 2017-01-28 | 7 | 2017 | 4 | 328300544 | 58178 | 0 | 55467 | weekly | |
20897 | 20897 | Ukraine | Ukraine | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 39701744 | 58151 | 0 | TBC | monthly | 1 | |
114 | 114 | United States | United States | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 338289856 | 57598 | 0 | TBC | weekly | |
37176 | 37176 | United States | United States | USA | 2017-03-05 | 2017-03-11 | 7 | 2017 | 10 | 328300544 | 57598 | 0 | 54158 | weekly | |
154 | 154 | United States | United States | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 338289856 | 57538 | 0 | TBC | weekly | |
37216 | 37216 | United States | United States | USA | 2017-12-10 | 2017-12-16 | 7 | 2017 | 50 | 328300544 | 57538 | 0 | 57865 | weekly | |
113 | 113 | United States | United States | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 338289856 | 57360 | 0 | TBC | weekly | |
37175 | 37175 | United States | United States | USA | 2017-02-26 | 2017-03-04 | 7 | 2017 | 9 | 328300544 | 57360 | 0 | 54554 | weekly | |
116 | 116 | United States | United States | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 338289856 | 57168 | 0 | TBC | weekly | |
37178 | 37178 | United States | United States | USA | 2017-03-19 | 2017-03-25 | 7 | 2017 | 12 | 328300544 | 57168 | 0 | 53924 | weekly | |
115 | 115 | United States | United States | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 338289856 | 56781 | 0 | TBC | weekly | |
37177 | 37177 | United States | United States | USA | 2017-03-12 | 2017-03-18 | 7 | 2017 | 11 | 328300544 | 56781 | 0 | 53865 | weekly | |
117 | 117 | United States | United States | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 338289856 | 55829 | 0 | TBC | weekly | |
37179 | 37179 | United States | United States | USA | 2017-03-26 | 2017-04-01 | 7 | 2017 | 13 | 328300544 | 55829 | 0 | 53642 | weekly | |
153 | 153 | United States | United States | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 338289856 | 55751 | 0 | TBC | weekly | |
37215 | 37215 | United States | United States | USA | 2017-12-03 | 2017-12-09 | 7 | 2017 | 49 | 328300544 | 55751 | 0 | 57052 | weekly | |
118 | 118 | United States | United States | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 338289856 | 55269 | 0 | TBC | weekly | |
37180 | 37180 | United States | United States | USA | 2017-04-02 | 2017-04-08 | 7 | 2017 | 14 | 328300544 | 55269 | 0 | 53277 | weekly | |
119 | 119 | United States | United States | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 338289856 | 54971 | 0 | TBC | weekly | |
37181 | 37181 | United States | United States | USA | 2017-04-09 | 2017-04-15 | 7 | 2017 | 15 | 328300544 | 54971 | 0 | 52862 | weekly | |
152 | 152 | United States | United States | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 338289856 | 54904 | 0 | TBC | weekly | |
37214 | 37214 | United States | United States | USA | 2017-11-26 | 2017-12-02 | 7 | 2017 | 48 | 328300544 | 54904 | 0 | 56666 | weekly | |
151 | 151 | United States | United States | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 338289856 | 54229 | 0 | TBC | weekly | |
37213 | 37213 | United States | United States | USA | 2017-11-19 | 2017-11-25 | 7 | 2017 | 47 | 328300544 | 54229 | 0 | 56214 | weekly | |
150 | 150 | United States | United States | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 338289856 | 53916 | 0 | TBC | weekly | |
37212 | 37212 | United States | United States | USA | 2017-11-12 | 2017-11-18 | 7 | 2017 | 46 | 328300544 | 53916 | 0 | 55711 | weekly | |
148 | 148 | United States | United States | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 338289856 | 53838 | 0 | TBC | weekly | |
37210 | 37210 | United States | United States | USA | 2017-10-29 | 2017-11-04 | 7 | 2017 | 44 | 328300544 | 53838 | 0 | 54751 | weekly | |
121 | 121 | United States | United States | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 338289856 | 53407 | 0 | TBC | weekly | |
37183 | 37183 | United States | United States | USA | 2017-04-23 | 2017-04-29 | 7 | 2017 | 17 | 328300544 | 53407 | 0 | 52164 | weekly | |
149 | 149 | United States | United States | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 338289856 | 53404 | 0 | TBC | weekly | |
37211 | 37211 | United States | United States | USA | 2017-11-05 | 2017-11-11 | 7 | 2017 | 45 | 328300544 | 53404 | 0 | 55217 | weekly | |
120 | 120 | United States | United States | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 338289856 | 53168 | 0 | TBC | weekly | |
37182 | 37182 | United States | United States | USA | 2017-04-16 | 2017-04-22 | 7 | 2017 | 16 | 328300544 | 53168 | 0 | 52512 | weekly | |
122 | 122 | United States | United States | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 338289856 | 52753 | 0 | TBC | weekly | |
37184 | 37184 | United States | United States | USA | 2017-04-30 | 2017-05-06 | 7 | 2017 | 18 | 328300544 | 52753 | 0 | 51824 | weekly | |
147 | 147 | United States | United States | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 338289856 | 52682 | 0 | TBC | weekly | |
37209 | 37209 | United States | United States | USA | 2017-10-22 | 2017-10-28 | 7 | 2017 | 43 | 328300544 | 52682 | 0 | 54172 | weekly | |
124 | 124 | United States | United States | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 338289856 | 52578 | 0 | TBC | weekly | |
37186 | 37186 | United States | United States | USA | 2017-05-14 | 2017-05-20 | 7 | 2017 | 20 | 328300544 | 52578 | 0 | 51234 | weekly | |
146 | 146 | United States | United States | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 338289856 | 52366 | 0 | TBC | weekly | |
37208 | 37208 | United States | United States | USA | 2017-10-15 | 2017-10-21 | 7 | 2017 | 42 | 328300544 | 52366 | 0 | 53718 | weekly | |
144 | 144 | United States | United States | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 338289856 | 52243 | 0 | TBC | weekly | |
37206 | 37206 | United States | United States | USA | 2017-10-01 | 2017-10-07 | 7 | 2017 | 40 | 328300544 | 52243 | 0 | 53026 | 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]);