economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
42 rows where covid_deaths = 67
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, year, expected_deaths, end_date (date)
country 15
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
798 | 798 | Ecuador | Ecuador | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 18001002 | 1914 | 67 | TBC | weekly | |
1299 | 1299 | Latvia | Latvia | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 1850654 | 596 | 67 | TBC | weekly | |
3092 | 3092 | Belgium | Belgium | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 11655923 | 2882 | 67 | TBC | weekly | |
3193 | 3193 | Belgium | Belgium | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 11655923 | 2143 | 67 | TBC | weekly | |
3672 | 3672 | Sweden | Sweden | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 10549349 | 2104.9 | 67 | TBC | weekly | |
7076 | 7076 | Peru | Peru | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 34049588 | 3067.2 | 67 | TBC | weekly | |
7261 | 7261 | Bahamas | Bahamas | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 409989 | 525 | 67 | TBC | monthly | 8 | |
9444 | 9444 | Romania | Romania | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 19659270 | 4910 | 67 | TBC | weekly | |
10394 | 10394 | Switzerland | Switzerland | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 8740471 | 1244 | 67 | TBC | weekly | |
10398 | 10398 | Switzerland | Switzerland | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 8740471 | 1276 | 67 | TBC | weekly | |
10661 | 10661 | Singapore | Singapore | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 5637022 | 2126 | 67 | TBC | monthly | 4 | |
13275 | 13275 | Portugal | Portugal | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 10270857 | 2607 | 67 | TBC | weekly | |
13836 | 13836 | Serbia | Serbia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 6871547 | 8417 | 67 | TBC | monthly | 7 | |
17606 | 17606 | Austria | Austria | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 8939617 | 1550 | 67 | TBC | weekly | |
18402 | 18402 | Denmark | Denmark | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 5882259 | 1086 | 67 | TBC | weekly | |
20196 | 20196 | Greece | Greece | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 10384972 | 2275 | 67 | TBC | weekly | |
21636 | 21636 | United States | Alabama | AL | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 4903185 | 1109 | 67 | 1002 | weekly | |
22602 | 22602 | United States | Arkansas | AR | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 3017825 | 644 | 67 | 671 | weekly | |
23508 | 23508 | United States | Connecticut | CT | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 3565287 | 685 | 67 | 633 | weekly | |
25699 | 25699 | United States | Illinois | IL | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 12671821 | 2110 | 67 | 1983 | weekly | |
25964 | 25964 | United States | Indiana | IN | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 6732219 | 1409 | 67 | 1286 | weekly | |
25996 | 25996 | United States | Indiana | IN | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 6732219 | 1362 | 67 | 1348 | weekly | |
25997 | 25997 | United States | Indiana | IN | 2021-05-02 | 2021-05-08 | 7 | 2021 | 18 | 6732219 | 1321 | 67 | 1333 | weekly | |
26987 | 26987 | United States | Kentucky | KY | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 4467673 | 1020 | 67 | 885 | weekly | |
26994 | 26994 | United States | Kentucky | KY | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 4467673 | 1016 | 67 | 898 | weekly | |
28170 | 28170 | United States | Massachusetts | MA | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 6949503 | 1153 | 67 | 1150 | weekly | |
28416 | 28416 | United States | Michigan | MI | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 9986857 | 1918 | 67 | 1772 | weekly | |
28512 | 28512 | United States | Michigan | MI | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 9986857 | 1948 | 67 | 1886 | weekly | |
28767 | 28767 | United States | Minnesota | MN | 2021-04-18 | 2021-04-24 | 7 | 2021 | 16 | 5639632 | 934 | 67 | 881 | weekly | |
29330 | 29330 | United States | Missouri | MO | 2020-04-12 | 2020-04-18 | 7 | 2020 | 16 | 6137428 | 1358 | 67 | 1266 | weekly | |
29735 | 29735 | United States | Montana | MT | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 1068778 | 251 | 67 | 217 | weekly | |
30371 | 30371 | United States | Nevada | NV | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 3080156 | 642 | 67 | 509 | weekly | |
30898 | 30898 | United States | New Jersey | NJ | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 8882190 | 1434 | 67 | 1455 | weekly | |
30979 | 30979 | United States | New Jersey | NJ | 2022-05-15 | 2022-05-21 | 7 | 2022 | 20 | 8882190 | 1510 | 67 | 1405 | weekly | |
30981 | 30981 | United States | New Jersey | NJ | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 8882190 | 1392 | 67 | 1384 | weekly | |
30991 | 30991 | United States | New Jersey | NJ | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 8882190 | 1376 | 67 | 1355 | weekly | |
31922 | 31922 | United States | North Carolina | NC | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 10488084 | 2093 | 67 | 1857 | weekly | |
32800 | 32800 | United States | Oklahoma | OK | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 3956971 | 868 | 67 | 788 | weekly | |
33114 | 33114 | United States | Oregon | OR | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 4217737 | 898 | 67 | 737 | weekly | |
33685 | 33685 | United States | Rhode Island | RI | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 1059361 | 249 | 67 | 211 | weekly | |
34668 | 34668 | United States | Tennessee | TN | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 6833174 | 1637 | 67 | 1552 | weekly | |
36766 | 36766 | United States | Wisconsin | WI | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 5822434 | 1126 | 67 | 1163 | 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]);