economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
40 rows where covid_deaths = 69
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, days, year, expected_deaths, start_date (date)
country 14
- United States 25
- Israel 2
- Portugal 2
- Australia 1
- Canada 1
- Finland 1
- Italy 1
- Latvia 1
- Mexico 1
- New Zealand 1
- Paraguay 1
- Poland 1
- Romania 1
- Switzerland 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1334 | 1334 | Latvia | Latvia | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 1850654 | 655 | 69 | TBC | weekly | |
4161 | 4161 | Australia | Australia | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 26177410 | 3478 | 69 | TBC | weekly | |
6173 | 6173 | Israel | Israel | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 9449000 | 817 | 69 | TBC | weekly | |
6190 | 6190 | Israel | Israel | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 9449000 | 930 | 69 | TBC | weekly | |
9544 | 9544 | Romania | Romania | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 19659270 | 4706 | 69 | TBC | weekly | |
9948 | 9948 | New Zealand | New Zealand | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 5185289 | 753 | 69 | TBC | weekly | |
10391 | 10391 | Switzerland | Switzerland | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 8740471 | 1287 | 69 | TBC | weekly | |
10569 | 10569 | Paraguay | Paraguay | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 6780745 | 3394 | 69 | TBC | monthly | 6 | |
12101 | 12101 | Mexico | Mexico | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 127504120 | 13156 | 69 | TBC | weekly | |
13145 | 13145 | Portugal | Portugal | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 10270857 | 2023 | 69 | TBC | weekly | |
13187 | 13187 | Portugal | Portugal | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 10270857 | 2057 | 69 | TBC | weekly | |
14828 | 14828 | Italy | Italy | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 59037472 | 11627 | 69 | TBC | weekly | |
15364 | 15364 | Canada | Canada | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 38454328 | 5575 | 69 | TBC | weekly | |
15692 | 15692 | Finland | Finland | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 5540745 | 1094 | 69 | TBC | weekly | |
20690 | 20690 | Poland | Poland | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 39857144 | 7901 | 69 | TBC | weekly | |
21635 | 21635 | United States | Alabama | AL | 2020-05-17 | 2020-05-23 | 7 | 2020 | 21 | 4903185 | 1153 | 69 | 1016 | weekly | |
21653 | 21653 | United States | Alabama | AL | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 4903185 | 1183 | 69 | 1009 | weekly | |
22301 | 22301 | United States | Arizona | AZ | 2021-05-02 | 2021-05-08 | 7 | 2021 | 18 | 7278717 | 1414 | 69 | 1242 | weekly | |
23578 | 23578 | United States | Connecticut | CT | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 3565287 | 632 | 69 | 669 | weekly | |
24094 | 24094 | United States | District of Columbia | DC | 2020-04-12 | 2020-04-18 | 7 | 2020 | 16 | 705749 | 202 | 69 | 138 | weekly | |
25953 | 25953 | United States | Indiana | IN | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 6732219 | 1345 | 69 | 1244 | weekly | |
27806 | 27806 | United States | Maryland | MD | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 6045680 | 1007 | 69 | 971 | weekly | |
27862 | 27862 | United States | Maryland | MD | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 6045680 | 1113 | 69 | 985 | weekly | |
28520 | 28520 | United States | Michigan | MI | 2022-06-19 | 2022-06-25 | 7 | 2022 | 25 | 9986857 | 1940 | 69 | 1797 | weekly | |
28738 | 28738 | United States | Minnesota | MN | 2020-09-27 | 2020-10-03 | 7 | 2020 | 40 | 5639632 | 886 | 69 | 882 | weekly | |
28760 | 28760 | United States | Minnesota | MN | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 5639632 | 931 | 69 | 947 | weekly | |
28765 | 28765 | United States | Minnesota | MN | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 5639632 | 873 | 69 | 898 | weekly | |
29023 | 29023 | United States | Mississippi | MS | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 2976149 | 750 | 69 | 614 | weekly | |
29719 | 29719 | United States | Montana | MT | 2021-10-31 | 2021-11-06 | 7 | 2021 | 44 | 1068778 | 308 | 69 | 195 | weekly | |
31276 | 31276 | United States | New Mexico | NM | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 2096829 | 488 | 69 | 401 | weekly | |
31503 | 31503 | United States | New York | NY | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 19453561 | 2811 | 69 | 2824 | weekly | |
31821 | 31821 | United States | North Carolina | NC | 2020-10-18 | 2020-10-24 | 7 | 2020 | 43 | 10488084 | 2130 | 69 | 1895 | weekly | |
34296 | 34296 | United States | South Dakota | SD | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 884659 | 220 | 69 | 170 | weekly | |
35857 | 35857 | United States | Virginia | VA | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 8535519 | 1426 | 69 | 1359 | weekly | |
36134 | 36134 | United States | Washington | WA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 7614893 | 1194 | 69 | 1126 | weekly | |
36195 | 36195 | United States | Washington | WA | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 7614893 | 1453 | 69 | 1230 | weekly | |
36219 | 36219 | United States | Washington | WA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 7614893 | 1234 | 69 | 1127 | weekly | |
36222 | 36222 | United States | Washington | WA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 7614893 | 1354 | 69 | 1105 | weekly | |
37109 | 37109 | United States | Wyoming | WY | 2021-10-17 | 2021-10-23 | 7 | 2021 | 42 | 578759 | 157 | 69 | 99 | weekly | |
37111 | 37111 | United States | Wyoming | WY | 2021-10-31 | 2021-11-06 | 7 | 2021 | 44 | 578759 | 155 | 69 | 100 | 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]);