economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
66 rows where covid_deaths = 42
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, days, month, start_date (date), end_date (date)
country 21
- United States 41
- Austria 2
- Croatia 2
- Estonia 2
- Montenegro 2
- Portugal 2
- Canada 1
- Ecuador 1
- Egypt 1
- Finland 1
- Guatemala 1
- Hungary 1
- Latvia 1
- Luxembourg 1
- Netherlands 1
- Nicaragua 1
- South Africa 1
- South Korea 1
- Spain 1
- Switzerland 1
- Uruguay 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
838 | 838 | Ecuador | Ecuador | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 18001002 | 1504 | 42 | TBC | weekly | |
1301 | 1301 | Latvia | Latvia | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 1850654 | 630 | 42 | TBC | weekly | |
2700 | 2700 | Luxembourg | Luxembourg | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 647601 | 105 | 42 | TBC | weekly | |
4306 | 4306 | Uruguay | Uruguay | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 3422796 | 3425 | 42 | TBC | monthly | 8 | |
4397 | 4397 | Egypt | Egypt | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 110990096 | 45300 | 42 | TBC | monthly | 7 | |
5611 | 5611 | Estonia | Estonia | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 1326064 | 396 | 42 | TBC | weekly | |
5614 | 5614 | Estonia | Estonia | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 1326064 | 354 | 42 | TBC | weekly | |
6696 | 6696 | Hungary | Hungary | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 9967304 | 2260 | 42 | TBC | weekly | |
7788 | 7788 | South Korea | South Korea | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 51815808 | 5820 | 42 | TBC | weekly | |
8231 | 8231 | South Africa | South Africa | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 59893884 | 11196 | 42 | TBC | weekly | |
10415 | 10415 | Switzerland | Switzerland | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 8740471 | 1241 | 42 | TBC | weekly | |
13188 | 13188 | Portugal | Portugal | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 10270857 | 2133 | 42 | TBC | weekly | |
13264 | 13264 | Portugal | Portugal | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 10270857 | 2087 | 42 | TBC | weekly | |
13613 | 13613 | Croatia | Croatia | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 4030361 | 1030 | 42 | TBC | weekly | |
13660 | 13660 | Croatia | Croatia | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 4030361 | 1015 | 42 | TBC | weekly | |
14301 | 14301 | Montenegro | Montenegro | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 627082 | 169 | 42 | TBC | weekly | |
14315 | 14315 | Montenegro | Montenegro | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 627082 | 260 | 42 | TBC | weekly | |
15314 | 15314 | Canada | Canada | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 38454328 | 5415 | 42 | TBC | weekly | |
15693 | 15693 | Finland | Finland | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 5540745 | 1142 | 42 | TBC | weekly | |
17197 | 17197 | Netherlands | Netherlands | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 17564020 | 3304 | 42 | TBC | weekly | |
17598 | 17598 | Austria | Austria | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 8939617 | 1655 | 42 | TBC | weekly | |
17599 | 17599 | Austria | Austria | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 8939617 | 1596 | 42 | TBC | weekly | |
17908 | 17908 | Spain | Spain | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 47558632 | 7635 | 42 | TBC | weekly | |
22568 | 22568 | United States | Arkansas | AR | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3017825 | 714 | 42 | 618 | weekly | |
23179 | 23179 | United States | Colorado | CO | 2020-06-14 | 2020-06-20 | 7 | 2020 | 25 | 5758736 | 863 | 42 | 762 | weekly | |
23184 | 23184 | United States | Colorado | CO | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 5758736 | 833 | 42 | 748 | weekly | |
23197 | 23197 | United States | Colorado | CO | 2020-10-18 | 2020-10-24 | 7 | 2020 | 43 | 5758736 | 869 | 42 | 789 | weekly | |
23268 | 23268 | United States | Colorado | CO | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 5758736 | 943 | 42 | 837 | weekly | |
23579 | 23579 | United States | Connecticut | CT | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 3565287 | 597 | 42 | 661 | weekly | |
23832 | 23832 | United States | Delaware | DE | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 973764 | 217 | 42 | 217 | weekly | |
25094 | 25094 | United States | Hawaii | HI | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1415872 | 266 | 42 | 234 | weekly | |
25368 | 25368 | United States | Idaho | ID | 2021-01-31 | 2021-02-06 | 7 | 2021 | 5 | 1787065 | 328 | 42 | 316 | weekly | |
26321 | 26321 | United States | Iowa | IA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3155070 | 680 | 42 | 578 | weekly | |
26624 | 26624 | United States | Kansas | KS | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 2913314 | 533 | 42 | 503 | weekly | |
27292 | 27292 | United States | Louisiana | LA | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 4648794 | 993 | 42 | 861 | weekly | |
27520 | 27520 | United States | Maine | ME | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1344212 | 345 | 42 | 298 | weekly | |
27598 | 27598 | United States | Maine | ME | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1344212 | 310 | 42 | 284 | weekly | |
27900 | 27900 | United States | Maryland | MD | 2022-05-22 | 2022-05-28 | 7 | 2022 | 21 | 6045680 | 965 | 42 | 950 | weekly | |
27918 | 27918 | United States | Maryland | MD | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 6045680 | 960 | 42 | 957 | weekly | |
28095 | 28095 | United States | Massachusetts | MA | 2020-03-22 | 2020-03-28 | 7 | 2020 | 13 | 6949503 | 1290 | 42 | 1260 | weekly | |
28473 | 28473 | United States | Michigan | MI | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 9986857 | 1862 | 42 | 1841 | weekly | |
28730 | 28730 | United States | Minnesota | MN | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 5639632 | 897 | 42 | 840 | weekly | |
28774 | 28774 | United States | Minnesota | MN | 2021-06-06 | 2021-06-12 | 7 | 2021 | 23 | 5639632 | 917 | 42 | 860 | weekly | |
28776 | 28776 | United States | Minnesota | MN | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 5639632 | 890 | 42 | 857 | weekly | |
29105 | 29105 | United States | Mississippi | MS | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 2976149 | 696 | 42 | 630 | weekly | |
29143 | 29143 | United States | Mississippi | MS | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 2976149 | 673 | 42 | 600 | weekly | |
30308 | 30308 | United States | Nevada | NV | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 3080156 | 551 | 42 | 547 | weekly | |
30648 | 30648 | United States | New Hampshire | NH | 2021-12-05 | 2021-12-11 | 7 | 2021 | 49 | 1359711 | 306 | 42 | 267 | weekly | |
30887 | 30887 | United States | New Jersey | NJ | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 8882190 | 1308 | 42 | 1391 | weekly | |
31552 | 31552 | United States | New York | NY | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 19453561 | 2903 | 42 | 2917 | weekly | |
31830 | 31830 | United States | North Carolina | NC | 2020-12-20 | 2020-12-26 | 7 | 2020 | 52 | 10488084 | 2670 | 42 | 2048 | weekly | |
31897 | 31897 | United States | North Carolina | NC | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 10488084 | 1852 | 42 | 1969 | weekly | |
31900 | 31900 | United States | North Carolina | NC | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 10488084 | 2052 | 42 | 1939 | weekly | |
31930 | 31930 | United States | North Carolina | NC | 2022-11-20 | 2022-11-26 | 7 | 2022 | 47 | 10488084 | 2061 | 42 | 1961 | weekly | |
32140 | 32140 | United States | North Dakota | ND | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 762062 | 157 | 42 | 149 | weekly | |
32716 | 32716 | United States | Oklahoma | OK | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 3956971 | 784 | 42 | 794 | weekly | |
33730 | 33730 | United States | Rhode Island | RI | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 1059361 | 290 | 42 | 230 | weekly | |
33737 | 33737 | United States | Rhode Island | RI | 2022-02-06 | 2022-02-12 | 7 | 2022 | 6 | 1059361 | 253 | 42 | 233 | weekly | |
34352 | 34352 | United States | South Dakota | SD | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 884659 | 219 | 42 | 171 | weekly | |
36540 | 36540 | United States | West Virginia | WV | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1792147 | 459 | 42 | 430 | weekly | |
36792 | 36792 | United States | Wisconsin | WI | 2021-08-15 | 2021-08-21 | 7 | 2021 | 33 | 5822434 | 1150 | 42 | 1039 | weekly | |
36826 | 36826 | United States | Wisconsin | WI | 2022-04-10 | 2022-04-16 | 7 | 2022 | 15 | 5822434 | 1072 | 42 | 1066 | weekly | |
36849 | 36849 | United States | Wisconsin | WI | 2022-09-18 | 2022-09-24 | 7 | 2022 | 38 | 5822434 | 1112 | 42 | 1045 | weekly | |
37063 | 37063 | United States | Wyoming | WY | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 578759 | 123 | 42 | 86 | weekly | |
37948 | 37948 | Guatemala | Guatemala | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 17843914 | 1817 | 42 | TBC | weekly | |
40167 | 40167 | Nicaragua | Nicaragua | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 6948395 | 3207 | 42 | TBC | monthly | 7 |
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]);