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 start_date
This data as json, yaml, Notebook, copyable, CSV (advanced)
country >30
- United States 2,710
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
37500 | 37500 | Russia | Russia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 144713312 | 179736.5 | 0 | TBC | monthly | 1 | |
38403 | 38403 | Monaco | Monaco | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 36491 | 43 | 0 | TBC | monthly | 1 | |
38496 | 38496 | Cuba | Cuba | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 11212198 | 9009 | 0 | TBC | monthly | 1 | |
38580 | 38580 | Philippines | Philippines | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 115559008 | 50476 | 0 | TBC | monthly | 1 | |
38670 | 38670 | Andorra | Andorra | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 79843 | 49 | 0 | TBC | monthly | 1 | |
39104 | 39104 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 103959 | 89 | 0 | TBC | monthly | 1 | |
39188 | 39188 | Seychelles | Seychelles | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 107135 | 61 | 0 | TBC | monthly | 1 | |
39686 | 39686 | Kosovo | Kosovo | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 1782115 | 826 | 0 | TBC | monthly | 1 | |
39780 | 39780 | Lebanon | Lebanon | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 5489744 | 2688 | 0 | TBC | monthly | 1 | |
39864 | 39864 | Belize | Belize | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 405285 | 161 | 0 | TBC | monthly | 1 | |
39948 | 39948 | Costa Rica | Costa Rica | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 5180836 | 2147 | 0 | TBC | monthly | 1 | |
40032 | 40032 | Kazakhstan | Kazakhstan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 19397998 | 12867 | 0 | TBC | monthly | 1 | |
40125 | 40125 | Nicaragua | Nicaragua | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 6948395 | 2120 | 0 | TBC | monthly | 1 | |
40197 | 40197 | Jamaica | Jamaica | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 2827382 | 1580 | 0 | TBC | monthly | 1 | |
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 | |
22384 | 22384 | United States | Arkansas | AR | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 3017825 | 658 | 0 | 634 | weekly | |
22692 | 22692 | United States | California | CA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 39512223 | 6267 | 0 | 5205 | weekly | |
23000 | 23000 | United States | Colorado | CO | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 5758736 | 840 | 0 | 754 | weekly | |
23308 | 23308 | United States | Connecticut | CT | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 3565287 | 662 | 0 | 623 | weekly | |
23616 | 23616 | United States | Delaware | DE | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 973764 | 212 | 0 | 175 | weekly | |
23924 | 23924 | United States | District of Columbia | DC | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 705749 | 127 | 0 | 107 | weekly | |
24232 | 24232 | United States | Florida | FL | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 21477737 | 4337 | 0 | 3974 | weekly | |
24540 | 24540 | United States | Georgia | GA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 10617423 | 1751 | 0 | 1717 | weekly | |
24848 | 24848 | United States | Hawaii | HI | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 1415872 | 263 | 0 | 232 | weekly | |
25156 | 25156 | United States | Idaho | ID | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 1787065 | 312 | 0 | 259 | weekly | |
25464 | 25464 | United States | Illinois | IL | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 12671821 | 2329 | 0 | 2080 | weekly | |
25772 | 25772 | United States | Indiana | IN | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 6732219 | 1428 | 0 | 1287 | weekly | |
26080 | 26080 | United States | Iowa | IA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 3155070 | 716 | 0 | 605 | weekly | |
26388 | 26388 | United States | Kansas | KS | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 2913314 | 575 | 0 | 520 | weekly | |
26696 | 26696 | United States | Kentucky | KY | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 4467673 | 1077 | 0 | 919 | weekly | |
27004 | 27004 | United States | Louisiana | LA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 4648794 | 939 | 0 | 988 | weekly | |
27312 | 27312 | United States | Maine | ME | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 1344212 | 280 | 0 | 276 | weekly | |
27620 | 27620 | United States | Maryland | MD | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 6045680 | 1078 | 0 | 983 | weekly | |
27928 | 27928 | United States | Massachusetts | MA | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 6949503 | 1310 | 0 | 1179 | weekly | |
28236 | 28236 | United States | Michigan | MI | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 9986857 | 2045 | 0 | 1878 | weekly | |
28544 | 28544 | United States | Minnesota | MN | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 5639632 | 916 | 0 | 845 | weekly | |
28852 | 28852 | United States | Mississippi | MS | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 2976149 | 659 | 0 | 644 | weekly | |
29160 | 29160 | United States | Missouri | MO | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 6137428 | 1360 | 0 | 1237 | weekly | |
29468 | 29468 | United States | Montana | MT | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 1068778 | 214 | 0 | 195 | weekly | |
29776 | 29776 | United States | Nebraska | NE | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 1934408 | 439 | 0 | 330 | weekly | |
30084 | 30084 | United States | Nevada | NV | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 3080156 | 561 | 0 | 473 | weekly | |
30392 | 30392 | United States | New Hampshire | NH | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 1359711 | 274 | 0 | 235 | weekly | |
30700 | 30700 | United States | New Jersey | NJ | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 8882190 | 1698 | 0 | 1462 | weekly | |
31008 | 31008 | United States | New Mexico | NM | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 2096829 | 381 | 0 | 351 | weekly | |
31316 | 31316 | United States | New York | NY | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 19453561 | 3307 | 0 | 3082 | weekly | |
31624 | 31624 | United States | North Carolina | NC | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 10488084 | 1988 | 0 | 1869 | weekly | |
31932 | 31932 | United States | North Dakota | ND | 2017-01-08 | 2017-01-14 | 7 | 2017 | 2 | 762062 | 142 | 0 | 139 | 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]);