economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
120 rows where "start_date" is on date 2017-01-01
This data as json, yaml, Notebook, copyable, CSV (advanced)
country >30
- United States 52
- Albania 1
- Andorra 1
- Antigua and Barbuda 1
- Argentina 1
- Armenia 1
- Aruba 1
- Azerbaijan 1
- Bahamas 1
- Barbados 1
- Belarus 1
- Belize 1
- Bermuda 1
- Bolivia 1
- Bosnia and Herzegovina 1
- Brazil 1
- Brunei 1
- Cape Verde 1
- Costa Rica 1
- Cuba 1
- Dominican Republic 1
- Egypt 1
- El Salvador 1
- Faroe Islands 1
- French Polynesia 1
- Georgia 1
- Gibraltar 1
- Greenland 1
- Hong Kong 1
- Ireland 1
- …
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
437 | 437 | Brunei | Brunei | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 449002 | 155 | 0 | TBC | monthly | 1 | |
923 | 923 | Maldives | Maldives | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 523798 | 97 | 0 | TBC | monthly | 1 | |
1408 | 1408 | Kyrgyzstan | Kyrgyzstan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 6630621 | 3147 | 0 | TBC | monthly | 1 | |
1909 | 1909 | Brazil | Brazil | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 215313504 | 105899 | 0 | TBC | monthly | 1 | |
3235 | 3235 | Thailand | Thailand | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 71697024 | 40798 | 0 | TBC | monthly | 1 | |
3741 | 3741 | Japan | Japan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 123951696 | 134174 | 0 | TBC | monthly | 1 | |
4239 | 4239 | Uruguay | Uruguay | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 3422796 | 2565 | 0 | TBC | monthly | 1 | |
4331 | 4331 | Egypt | Egypt | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 110990096 | 58898 | 0 | TBC | monthly | 1 | |
4424 | 4424 | Belarus | Belarus | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 9534956 | 11978 | 0 | TBC | monthly | 1 | |
5732 | 5732 | Bolivia | Bolivia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 12224114 | 4172 | 0 | TBC | monthly | 1 | |
5817 | 5817 | Mauritius | Mauritius | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 1299478 | 837 | 0 | TBC | monthly | 1 | |
6729 | 6729 | Georgia | Georgia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 3744385 | 5346 | 0 | TBC | monthly | 1 | |
7120 | 7120 | Tunisia | Tunisia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 12356116 | 8344 | 0 | TBC | monthly | 1 | |
7206 | 7206 | Bahamas | Bahamas | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 409989 | 225 | 0 | TBC | monthly | 1 | |
7290 | 7290 | Isle of Man | Isle of Man | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 84534 | 77 | 0 | TBC | monthly | 1 | |
7374 | 7374 | Malaysia | Malaysia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 33938216 | 14333 | 0 | TBC | monthly | 1 | |
8277 | 8277 | Barbados | Barbados | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 281646 | 310 | 0 | TBC | monthly | 1 | |
8370 | 8370 | San Marino | San Marino | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 33690 | 25 | 0 | TBC | monthly | 1 | |
8872 | 8872 | El Salvador | El Salvador | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 6336393 | 4075 | 0 | TBC | monthly | 1 | |
8940 | 8940 | Tajikistan | Tajikistan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 9952789 | 3157 | 0 | TBC | monthly | 1 | |
9000 | 9000 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 47681 | 34 | 0 | TBC | monthly | 1 | |
9092 | 9092 | Greenland | Greenland | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 56494 | 50 | 0 | TBC | monthly | 1 | |
10008 | 10008 | Aruba | Aruba | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 106459 | 66 | 0 | TBC | monthly | 1 | |
10504 | 10504 | Paraguay | Paraguay | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 6780745 | 2524 | 0 | TBC | monthly | 1 | |
10598 | 10598 | Singapore | Singapore | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 5637022 | 1768 | 0 | TBC | monthly | 1 | |
10691 | 10691 | Kuwait | Kuwait | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 4268886 | 686 | 0 | TBC | monthly | 1 | |
11221 | 11221 | Antigua and Barbuda | Antigua and Barbuda | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 93772 | 42 | 0 | TBC | monthly | 1 | |
12126 | 12126 | Gibraltar | Gibraltar | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 32677 | 26 | 0 | TBC | monthly | 1 | |
12199 | 12199 | Macao | Macao | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 695180 | 167 | 0 | TBC | monthly | 1 | |
12293 | 12293 | Oman | Oman | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 4576300 | 773 | 0 | TBC | monthly | 1 | |
12792 | 12792 | Faroe Islands | Faroe Islands | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 49085 | 39 | 0 | TBC | monthly | 1 | |
13710 | 13710 | Argentina | Argentina | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 45510324 | 26822 | 0 | TBC | monthly | 1 | |
13782 | 13782 | Serbia | Serbia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 6871547 | 13385 | 0 | TBC | monthly | 1 | |
13876 | 13876 | Armenia | Armenia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 2780472 | 3027 | 0 | TBC | monthly | 1 | |
14369 | 14369 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 3233530 | 3443 | 0 | TBC | monthly | 1 | |
14462 | 14462 | Moldova | Moldova | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 3272993 | 4312 | 0 | TBC | monthly | 1 | |
14960 | 14960 | Bermuda | Bermuda | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 64207 | 44 | 0 | TBC | monthly | 1 | |
15850 | 15850 | Mongolia | Mongolia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 3398373 | 1357 | 0 | TBC | monthly | 1 | |
15945 | 15945 | North Macedonia | North Macedonia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 2093606 | 2681 | 0 | TBC | monthly | 1 | |
16038 | 16038 | Cape Verde | Cape Verde | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 593162 | 243 | 0 | TBC | monthly | 1 | |
16110 | 16110 | Panama | Panama | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 4408582 | 1710 | 0 | TBC | monthly | 1 | |
16638 | 16638 | French Polynesia | French Polynesia | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 306292 | 132 | 0 | TBC | monthly | 1 | |
16722 | 16722 | Azerbaijan | Azerbaijan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 10358078 | 6085 | 0 | TBC | monthly | 1 | |
18054 | 18054 | Taiwan | Taiwan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 23893396 | 12835 | 0 | TBC | monthly | 1 | |
18974 | 18974 | Hong Kong | Hong Kong | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 7488863 | 4203 | 0 | TBC | monthly | 1 | |
19067 | 19067 | Uzbekistan | Uzbekistan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 34627648 | 11088 | 0 | TBC | monthly | 1 | |
19160 | 19160 | Qatar | Qatar | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 2695131 | 192 | 0 | TBC | monthly | 1 | |
19665 | 19665 | Ireland | Ireland | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 5023108 | 3425 | 0 | TBC | monthly | 1 | |
19759 | 19759 | Suriname | Suriname | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 618046 | 329 | 0 | TBC | monthly | 1 | |
20241 | 20241 | Liechtenstein | Liechtenstein | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 39355 | 27 | 0 | TBC | monthly | 1 | |
20731 | 20731 | Jordan | Jordan | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 11285875 | 2751 | 0 | TBC | monthly | 1 | |
20815 | 20815 | Dominican Republic | Dominican Republic | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 11228821 | 4146 | 0 | TBC | monthly | 1 | |
20897 | 20897 | Ukraine | Ukraine | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 39701744 | 58151 | 0 | TBC | monthly | 1 | |
20982 | 20982 | Albania | Albania | 0 | 2017-01-01 | 2017-01-31 | 31 | 2017 | 2842318 | 3129 | 0 | TBC | monthly | 1 | |
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 |
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]);