economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
122 rows where "end_date" is on date 2018-06-30 sorted by expected_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
country >30
- United States 52
- Albania 1
- Algeria 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
- …
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths ▼ | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24000 | 24000 | United States | District of Columbia | DC | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 705749 | 121 | 0 | 104 | weekly | |
22152 | 22152 | United States | Arizona | AZ | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 7278717 | 1105 | 0 | 1065 | weekly | |
36012 | 36012 | United States | Washington | WA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 7614893 | 1021 | 0 | 1071 | weekly | |
35396 | 35396 | United States | Vermont | VT | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 623989 | 104 | 0 | 109 | weekly | |
28004 | 28004 | United States | Massachusetts | MA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 6949503 | 1042 | 0 | 1124 | weekly | |
29236 | 29236 | United States | Missouri | MO | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 6137428 | 1154 | 0 | 1175 | weekly | |
25848 | 25848 | United States | Indiana | IN | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 6732219 | 1223 | 0 | 1180 | weekly | |
35704 | 35704 | United States | Virginia | VA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 8535519 | 1191 | 0 | 1213 | weekly | |
32008 | 32008 | United States | North Dakota | ND | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 762062 | 126 | 0 | 124 | weekly | |
30776 | 30776 | United States | New Jersey | NJ | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 8882190 | 1333 | 0 | 1275 | weekly | |
34472 | 34472 | United States | Tennessee | TN | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 6833174 | 1283 | 0 | 1357 | weekly | |
34164 | 34164 | United States | South Dakota | SD | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 884659 | 132 | 0 | 149 | weekly | |
24616 | 24616 | United States | Georgia | GA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 10617423 | 1546 | 0 | 1560 | weekly | |
23692 | 23692 | United States | Delaware | DE | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 973764 | 181 | 0 | 163 | weekly | |
31700 | 31700 | United States | North Carolina | NC | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 10488084 | 1727 | 0 | 1729 | weekly | |
28312 | 28312 | United States | Michigan | MI | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 9986857 | 1755 | 0 | 1788 | weekly | |
25540 | 25540 | United States | Illinois | IL | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 12671821 | 1932 | 0 | 1941 | weekly | |
29544 | 29544 | United States | Montana | MT | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1068778 | 175 | 0 | 195 | weekly | |
33548 | 33548 | United States | Rhode Island | RI | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1059361 | 197 | 0 | 199 | weekly | |
32316 | 32316 | United States | Ohio | OH | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 11689100 | 2242 | 0 | 2198 | weekly | |
24924 | 24924 | United States | Hawaii | HI | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1415872 | 213 | 0 | 231 | weekly | |
30468 | 30468 | United States | New Hampshire | NH | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1359711 | 214 | 0 | 236 | weekly | |
33240 | 33240 | United States | Pennsylvania | PA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 12801989 | 2452 | 0 | 2403 | weekly | |
25232 | 25232 | United States | Idaho | ID | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1787065 | 245 | 0 | 264 | weekly | |
31392 | 31392 | United States | New York | NY | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 19453561 | 2767 | 0 | 2728 | weekly | |
27388 | 27388 | United States | Maine | ME | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1344212 | 285 | 0 | 281 | weekly | |
29852 | 29852 | United States | Nebraska | NE | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1934408 | 352 | 0 | 314 | weekly | |
31084 | 31084 | United States | New Mexico | NM | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 2096829 | 336 | 0 | 331 | weekly | |
35088 | 35088 | United States | Utah | UT | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3205958 | 340 | 0 | 355 | weekly | |
34780 | 34780 | United States | Texas | TX | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 28995881 | 3700 | 0 | 3758 | weekly | |
24308 | 24308 | United States | Florida | FL | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 21477737 | 3722 | 0 | 3835 | weekly | |
36320 | 36320 | United States | West Virginia | WV | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 1792147 | 416 | 0 | 406 | weekly | |
30160 | 30160 | United States | Nevada | NV | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3080156 | 522 | 0 | 471 | weekly | |
22768 | 22768 | United States | California | CA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 39512223 | 4757 | 0 | 4913 | weekly | |
26464 | 26464 | United States | Kansas | KS | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 2913314 | 478 | 0 | 493 | weekly | |
37244 | 37244 | United States | United States | USA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 328300544 | 50996 | 0 | 51466 | weekly | |
26156 | 26156 | United States | Iowa | IA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3155070 | 553 | 0 | 525 | weekly | |
23384 | 23384 | United States | Connecticut | CT | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3565287 | 546 | 0 | 565 | weekly | |
22460 | 22460 | United States | Arkansas | AR | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3017825 | 570 | 0 | 574 | weekly | |
28928 | 28928 | United States | Mississippi | MS | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 2976149 | 586 | 0 | 577 | weekly | |
32932 | 32932 | United States | Oregon | OR | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 4217737 | 671 | 0 | 699 | weekly | |
32624 | 32624 | United States | Oklahoma | OK | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 3956971 | 685 | 0 | 720 | weekly | |
23076 | 23076 | United States | Colorado | CO | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 5758736 | 664 | 0 | 745 | weekly | |
27080 | 27080 | United States | Louisiana | LA | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 4648794 | 853 | 0 | 799 | weekly | |
28620 | 28620 | United States | Minnesota | MN | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 5639632 | 798 | 0 | 808 | weekly | |
26772 | 26772 | United States | Kentucky | KY | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 4467673 | 823 | 0 | 878 | weekly | |
21844 | 21844 | United States | Alaska | AK | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 731545 | 66 | 0 | 88 | weekly | |
27696 | 27696 | United States | Maryland | MD | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 6045680 | 951 | 0 | 884 | weekly | |
36936 | 36936 | United States | Wyoming | WY | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 578759 | 86 | 0 | 89 | weekly | |
33856 | 33856 | United States | South Carolina | SC | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 5148714 | 858 | 0 | 899 | weekly | |
21536 | 21536 | United States | Alabama | AL | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 4903185 | 927 | 0 | 928 | weekly | |
36628 | 36628 | United States | Wisconsin | WI | 2018-06-24 | 2018-06-30 | 7 | 2018 | 26 | 5822434 | 970 | 0 | 950 | weekly | |
454 | 454 | Brunei | Brunei | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 449002 | 99 | 0 | TBC | monthly | 6 | |
940 | 940 | Maldives | Maldives | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 523798 | 89 | 0 | TBC | monthly | 6 | |
1425 | 1425 | Kyrgyzstan | Kyrgyzstan | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 6630621 | 2594 | 0 | TBC | monthly | 6 | |
1926 | 1926 | Brazil | Brazil | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 215313504 | 116967 | 0 | TBC | monthly | 6 | |
3252 | 3252 | Thailand | Thailand | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 71697024 | 36867 | 0 | TBC | monthly | 6 | |
3758 | 3758 | Japan | Japan | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 123951696 | 98406 | 0 | TBC | monthly | 6 | |
4256 | 4256 | Uruguay | Uruguay | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 3422796 | 3210 | 0 | TBC | monthly | 6 | |
4348 | 4348 | Egypt | Egypt | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 110990096 | 44510 | 0 | TBC | monthly | 6 | |
4441 | 4441 | Belarus | Belarus | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 9534956 | 9036 | 0 | TBC | monthly | 6 | |
5749 | 5749 | Bolivia | Bolivia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 12224114 | 4511 | 0 | TBC | monthly | 6 | |
5834 | 5834 | Mauritius | Mauritius | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 1299478 | 881 | 0 | TBC | monthly | 6 | |
6746 | 6746 | Georgia | Georgia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 3744385 | 3696 | 0 | TBC | monthly | 6 | |
7137 | 7137 | Tunisia | Tunisia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 12356116 | 4569 | 0 | TBC | monthly | 6 | |
7223 | 7223 | Bahamas | Bahamas | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 409989 | 218 | 0 | TBC | monthly | 6 | |
7307 | 7307 | Isle of Man | Isle of Man | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 84534 | 87 | 0 | TBC | monthly | 6 | |
7391 | 7391 | Malaysia | Malaysia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 33938216 | 14033 | 0 | TBC | monthly | 6 | |
8294 | 8294 | Barbados | Barbados | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 281646 | 193 | 0 | TBC | monthly | 6 | |
8387 | 8387 | San Marino | San Marino | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 33690 | 11 | 0 | TBC | monthly | 6 | |
8889 | 8889 | El Salvador | El Salvador | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 6336393 | 3447 | 0 | TBC | monthly | 6 | |
8957 | 8957 | Tajikistan | Tajikistan | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 9952789 | 2526 | 0 | TBC | monthly | 6 | |
9017 | 9017 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 47681 | 27 | 0 | TBC | monthly | 6 | |
9109 | 9109 | Greenland | Greenland | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 56494 | 45 | 0 | TBC | monthly | 6 | |
10025 | 10025 | Aruba | Aruba | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 106459 | 49 | 0 | TBC | monthly | 6 | |
10521 | 10521 | Paraguay | Paraguay | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 6780745 | 2921 | 0 | TBC | monthly | 6 | |
10615 | 10615 | Singapore | Singapore | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 5637022 | 1748 | 0 | TBC | monthly | 6 | |
10708 | 10708 | Kuwait | Kuwait | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 4268886 | 548 | 0 | TBC | monthly | 6 | |
10756 | 10756 | Algeria | Algeria | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 44903228 | 13613.6 | 0 | TBC | monthly | 6 | |
11238 | 11238 | Antigua and Barbuda | Antigua and Barbuda | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 93772 | 42 | 0 | TBC | monthly | 6 | |
12143 | 12143 | Gibraltar | Gibraltar | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 32677 | 21 | 0 | TBC | monthly | 6 | |
12216 | 12216 | Macao | Macao | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 695180 | 157 | 0 | TBC | monthly | 6 | |
12310 | 12310 | Oman | Oman | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 4576300 | 701 | 0 | TBC | monthly | 6 | |
12809 | 12809 | Faroe Islands | Faroe Islands | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 49085 | 30 | 0 | TBC | monthly | 6 | |
13727 | 13727 | Argentina | Argentina | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 45510324 | 31454 | 0 | TBC | monthly | 6 | |
13799 | 13799 | Serbia | Serbia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 6871547 | 7403 | 0 | TBC | monthly | 6 | |
13893 | 13893 | Armenia | Armenia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 2780472 | 1902 | 0 | TBC | monthly | 6 | |
14386 | 14386 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 3233530 | 2698 | 0 | TBC | monthly | 6 | |
14479 | 14479 | Moldova | Moldova | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 3272993 | 2844 | 0 | TBC | monthly | 6 | |
14977 | 14977 | Bermuda | Bermuda | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 64207 | 38 | 0 | TBC | monthly | 6 | |
15867 | 15867 | Mongolia | Mongolia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 3398373 | 1367 | 0 | TBC | monthly | 6 | |
15962 | 15962 | North Macedonia | North Macedonia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 2093606 | 1462 | 0 | TBC | monthly | 6 | |
16055 | 16055 | Cape Verde | Cape Verde | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 593162 | 229 | 0 | TBC | monthly | 6 | |
16127 | 16127 | Panama | Panama | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 4408582 | 1555 | 0 | TBC | monthly | 6 | |
16583 | 16583 | Palestine | Palestine | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 5250076 | 929 | 0 | TBC | monthly | 6 | |
16655 | 16655 | French Polynesia | French Polynesia | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 306292 | 151 | 0 | TBC | monthly | 6 | |
16739 | 16739 | Azerbaijan | Azerbaijan | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 10358078 | 4015 | 0 | TBC | monthly | 6 | |
18071 | 18071 | Taiwan | Taiwan | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 23893396 | 13043 | 0 | TBC | monthly | 6 | |
18991 | 18991 | Hong Kong | Hong Kong | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 7488863 | 3551 | 0 | TBC | monthly | 6 | |
19084 | 19084 | Uzbekistan | Uzbekistan | 0 | 2018-06-01 | 2018-06-30 | 30 | 2018 | 34627648 | 11610 | 0 | TBC | monthly | 6 |
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]);