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 end_date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, month, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21459 | 21459 | United States | Alabama | AL | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 4903185 | 1121 | 0 | 1033 | weekly | |
21767 | 21767 | United States | Alaska | AK | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 731545 | 104 | 0 | 76 | weekly | |
22075 | 22075 | United States | Arizona | AZ | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 7278717 | 1170 | 0 | 1107 | weekly | |
22383 | 22383 | United States | Arkansas | AR | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3017825 | 651 | 0 | 632 | weekly | |
22691 | 22691 | United States | California | CA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 39512223 | 6061 | 0 | 5169 | weekly | |
22999 | 22999 | United States | Colorado | CO | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 5758736 | 793 | 0 | 746 | weekly | |
23307 | 23307 | United States | Connecticut | CT | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3565287 | 656 | 0 | 620 | weekly | |
23615 | 23615 | United States | Delaware | DE | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 973764 | 197 | 0 | 174 | weekly | |
23923 | 23923 | United States | District of Columbia | DC | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 705749 | 133 | 0 | 108 | weekly | |
24231 | 24231 | United States | Florida | FL | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 21477737 | 4153 | 0 | 3943 | weekly | |
24539 | 24539 | United States | Georgia | GA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 10617423 | 1816 | 0 | 1713 | weekly | |
24847 | 24847 | United States | Hawaii | HI | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1415872 | 217 | 0 | 226 | weekly | |
25155 | 25155 | United States | Idaho | ID | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1787065 | 291 | 0 | 259 | weekly | |
25463 | 25463 | United States | Illinois | IL | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 12671821 | 2178 | 0 | 2075 | weekly | |
25771 | 25771 | United States | Indiana | IN | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 6732219 | 1457 | 0 | 1278 | weekly | |
26079 | 26079 | United States | Iowa | IA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3155070 | 655 | 0 | 603 | weekly | |
26387 | 26387 | United States | Kansas | KS | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 2913314 | 576 | 0 | 516 | weekly | |
26695 | 26695 | United States | Kentucky | KY | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 4467673 | 1050 | 0 | 912 | weekly | |
27003 | 27003 | United States | Louisiana | LA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 4648794 | 908 | 0 | 984 | weekly | |
27311 | 27311 | United States | Maine | ME | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1344212 | 260 | 0 | 271 | weekly | |
27619 | 27619 | United States | Maryland | MD | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 6045680 | 1030 | 0 | 980 | weekly | |
27927 | 27927 | United States | Massachusetts | MA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 6949503 | 1247 | 0 | 1167 | weekly | |
28235 | 28235 | United States | Michigan | MI | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 9986857 | 2102 | 0 | 1865 | weekly | |
28543 | 28543 | United States | Minnesota | MN | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 5639632 | 885 | 0 | 843 | weekly | |
28851 | 28851 | United States | Mississippi | MS | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 2976149 | 663 | 0 | 642 | weekly | |
29159 | 29159 | United States | Missouri | MO | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 6137428 | 1452 | 0 | 1227 | weekly | |
29467 | 29467 | United States | Montana | MT | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1068778 | 209 | 0 | 193 | weekly | |
29775 | 29775 | United States | Nebraska | NE | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1934408 | 396 | 0 | 329 | weekly | |
30083 | 30083 | United States | Nevada | NV | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3080156 | 608 | 0 | 468 | weekly | |
30391 | 30391 | United States | New Hampshire | NH | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1359711 | 236 | 0 | 232 | weekly | |
30699 | 30699 | United States | New Jersey | NJ | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 8882190 | 1524 | 0 | 1449 | weekly | |
31007 | 31007 | United States | New Mexico | NM | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 2096829 | 376 | 0 | 348 | weekly | |
31315 | 31315 | United States | New York | NY | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 19453561 | 3355 | 0 | 3081 | weekly | |
31623 | 31623 | United States | North Carolina | NC | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 10488084 | 2002 | 0 | 1865 | weekly | |
31931 | 31931 | United States | North Dakota | ND | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 762062 | 117 | 0 | 140 | weekly | |
32239 | 32239 | United States | Ohio | OH | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 11689100 | 2671 | 0 | 2301 | weekly | |
32547 | 32547 | United States | Oklahoma | OK | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3956971 | 795 | 0 | 792 | weekly | |
32855 | 32855 | United States | Oregon | OR | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 4217737 | 903 | 0 | 711 | weekly | |
33163 | 33163 | United States | Pennsylvania | PA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 12801989 | 2979 | 0 | 2630 | weekly | |
33471 | 33471 | United States | Rhode Island | RI | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1059361 | 227 | 0 | 207 | weekly | |
33779 | 33779 | United States | South Carolina | SC | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 5148714 | 966 | 0 | 959 | weekly | |
34087 | 34087 | United States | South Dakota | SD | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 884659 | 170 | 0 | 148 | weekly | |
34395 | 34395 | United States | Tennessee | TN | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 6833174 | 1580 | 0 | 1451 | weekly | |
34703 | 34703 | United States | Texas | TX | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 28995881 | 4027 | 0 | 4145 | weekly | |
35011 | 35011 | United States | Utah | UT | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 3205958 | 432 | 0 | 369 | weekly | |
35319 | 35319 | United States | Vermont | VT | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 623989 | 137 | 0 | 113 | weekly | |
35627 | 35627 | United States | Virginia | VA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 8535519 | 1405 | 0 | 1318 | weekly | |
35935 | 35935 | United States | Washington | WA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 7614893 | 1316 | 0 | 1067 | weekly | |
36243 | 36243 | United States | West Virginia | WV | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 1792147 | 474 | 0 | 429 | weekly | |
36551 | 36551 | United States | Wisconsin | WI | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 5822434 | 1084 | 0 | 1025 | weekly | |
36859 | 36859 | United States | Wyoming | WY | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 578759 | 86 | 0 | 89 | weekly | |
37167 | 37167 | United States | United States | USA | 2017-01-01 | 2017-01-07 | 7 | 2017 | 1 | 328300544 | 59901 | 0 | 55028 | weekly | |
105 | 105 | United States | United States | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 338289856 | 59901 | 0 | TBC | weekly | |
590 | 590 | Ecuador | Ecuador | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 18001002 | 1351 | 0 | TBC | weekly | |
1076 | 1076 | Latvia | Latvia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 1850654 | 606 | 0 | TBC | weekly | |
1583 | 1583 | Slovakia | Slovakia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5643455 | 1411 | 0 | TBC | weekly | |
2084 | 2084 | Bulgaria | Bulgaria | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 6781955 | 3169 | 0 | TBC | weekly | |
2494 | 2494 | Luxembourg | Luxembourg | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 647601 | 95 | 0 | TBC | weekly | |
2904 | 2904 | Belgium | Belgium | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 11655923 | 2557 | 0 | TBC | weekly | |
3411 | 3411 | Sweden | Sweden | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 10549349 | 2193.6 | 0 | TBC | weekly | |
3916 | 3916 | Australia | Australia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 26177410 | 2895 | 0 | TBC | weekly | |
4580 | 4580 | Czech Republic | Czech Republic | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 10493990 | 2763 | 0 | TBC | weekly | |
4989 | 4989 | Slovenia | Slovenia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 2119843 | 479 | 0 | TBC | weekly | |
5401 | 5401 | Estonia | Estonia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 1326064 | 364 | 0 | TBC | weekly | |
5988 | 5988 | Israel | Israel | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 9449000 | 1128 | 0 | TBC | weekly | |
6399 | 6399 | Hungary | Hungary | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 9967304 | 3155 | 0 | TBC | weekly | |
6795 | 6795 | Peru | Peru | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 34049588 | 2404.1 | 0 | TBC | weekly | |
7548 | 7548 | South Korea | South Korea | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 51815808 | 5958 | 0 | TBC | weekly | |
7943 | 7943 | South Africa | South Africa | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 59893884 | 9938 | 0 | TBC | weekly | |
8545 | 8545 | Malta | Malta | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 533293 | 103 | 0 | TBC | weekly | |
9266 | 9266 | Romania | Romania | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 19659270 | 6940 | 0 | TBC | weekly | |
9675 | 9675 | New Zealand | New Zealand | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5185289 | 528 | 0 | TBC | weekly | |
10173 | 10173 | Switzerland | Switzerland | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 8740471 | 1678 | 0 | TBC | weekly | |
10892 | 10892 | Lithuania | Lithuania | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 2750058 | 958 | 0 | TBC | weekly | |
11386 | 11386 | Britain | Britain | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 67508936 | 13608 | 0 | TBC | weekly | |
11800 | 11800 | Mexico | Mexico | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 127504120 | 14312 | 0 | TBC | weekly | |
12468 | 12468 | Iran | Iran | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 88550568 | 7494.6 | 0 | TBC | weekly | |
12967 | 12967 | Portugal | Portugal | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 10270857 | 3366 | 0 | TBC | weekly | |
13381 | 13381 | Croatia | Croatia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 4030361 | 1465 | 0 | TBC | weekly | |
14051 | 14051 | Montenegro | Montenegro | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 627082 | 191 | 0 | TBC | weekly | |
14636 | 14636 | Italy | Italy | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 59037472 | 18072 | 0 | TBC | weekly | |
15125 | 15125 | Canada | Canada | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 38454328 | 6180 | 0 | TBC | weekly | |
15521 | 15521 | Finland | Finland | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5540745 | 1273 | 0 | TBC | weekly | |
16273 | 16273 | Iceland | Iceland | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 372903 | 35 | 0 | TBC | weekly | |
16897 | 16897 | Netherlands | Netherlands | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 17564020 | 3570 | 0 | TBC | weekly | |
17312 | 17312 | Austria | Austria | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 8939617 | 2293 | 0 | TBC | weekly | |
17726 | 17726 | Spain | Spain | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 47558632 | 10726 | 0 | TBC | weekly | |
18230 | 18230 | Denmark | Denmark | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5882259 | 1113 | 0 | TBC | weekly | |
18645 | 18645 | Cyprus | Cyprus | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 896007 | 155 | 0 | TBC | weekly | |
19335 | 19335 | Colombia | Colombia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 51874028 | 4601 | 0 | TBC | weekly | |
19912 | 19912 | Greece | Greece | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 10384972 | 3425 | 0 | TBC | weekly | |
20411 | 20411 | Poland | Poland | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 39857144 | 9279 | 0 | TBC | weekly | |
21153 | 21153 | France | France | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 67813000 | 15509 | 0 | TBC | weekly | |
37675 | 37675 | Guatemala | Guatemala | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 17843914 | 1597 | 0 | TBC | weekly | |
38071 | 38071 | Germany | Germany | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 83369840 | 20918 | 0 | TBC | weekly | |
38770 | 38770 | Chile | Chile | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 19603736 | 1878 | 0 | TBC | weekly | |
39353 | 39353 | Norway | Norway | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 5434324 | 1006 | 0 | TBC | weekly | |
21460 | 21460 | United States | Alabama | AL | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 4903185 | 1130 | 0 | 1042 | weekly | |
21768 | 21768 | United States | Alaska | AK | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 731545 | 87 | 0 | 78 | weekly | |
22076 | 22076 | United States | Arizona | AZ | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 7278717 | 1205 | 0 | 1123 | 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]);