economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
36 rows where covid_deaths = 83
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, year, week, expected_deaths, start_date (date), end_date (date)
country 12
- United States 25
- Britain 1
- Croatia 1
- Dominican Republic 1
- Finland 1
- Guatemala 1
- Hungary 1
- Latvia 1
- Lithuania 1
- Portugal 1
- Sweden 1
- Uzbekistan 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1341 | 1341 | Latvia | Latvia | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 1850654 | 669 | 83 | TBC | weekly | |
3688 | 3688 | Sweden | Sweden | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 10549349 | 1653.1 | 83 | TBC | weekly | |
6571 | 6571 | Hungary | Hungary | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 9967304 | 2359 | 83 | TBC | weekly | |
11114 | 11114 | Lithuania | Lithuania | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 2750058 | 896 | 83 | TBC | weekly | |
11616 | 11616 | Britain | Britain | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 67508936 | 9115 | 83 | TBC | weekly | |
13142 | 13142 | Portugal | Portugal | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 10270857 | 2057 | 83 | TBC | weekly | |
13628 | 13628 | Croatia | Croatia | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 4030361 | 1106 | 83 | TBC | weekly | |
15782 | 15782 | Finland | Finland | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 5540745 | 1280 | 83 | TBC | weekly | |
19126 | 19126 | Uzbekistan | Uzbekistan | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 34627648 | 15797 | 83 | TBC | monthly | 12 | |
20862 | 20862 | Dominican Republic | Dominican Republic | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 11228821 | 4143 | 83 | TBC | monthly | 12 | |
21750 | 21750 | United States | Alabama | AL | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 4903185 | 1107 | 83 | 991 | weekly | |
21756 | 21756 | United States | Alabama | AL | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 4903185 | 1120 | 83 | 996 | weekly | |
22014 | 22014 | United States | Alaska | AK | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 731545 | 171 | 83 | 86 | weekly | |
22684 | 22684 | United States | Arkansas | AR | 2022-10-09 | 2022-10-15 | 7 | 2022 | 41 | 3017825 | 717 | 83 | 607 | weekly | |
22923 | 22923 | United States | California | CA | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 39512223 | 5477 | 83 | 5104 | weekly | |
23242 | 23242 | United States | Colorado | CO | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 5758736 | 911 | 83 | 760 | weekly | |
23567 | 23567 | United States | Connecticut | CT | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 3565287 | 808 | 83 | 684 | weekly | |
25960 | 25960 | United States | Indiana | IN | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 6732219 | 1359 | 83 | 1275 | weekly | |
26256 | 26256 | United States | Iowa | IA | 2020-05-24 | 2020-05-30 | 7 | 2020 | 22 | 3155070 | 632 | 83 | 565 | weekly | |
26630 | 26630 | United States | Kansas | KS | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 2913314 | 655 | 83 | 504 | weekly | |
27265 | 27265 | United States | Louisiana | LA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 4648794 | 1252 | 83 | 987 | weekly | |
28182 | 28182 | United States | Massachusetts | MA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6949503 | 1270 | 83 | 1247 | weekly | |
28211 | 28211 | United States | Massachusetts | MA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6949503 | 1094 | 83 | 1092 | weekly | |
28531 | 28531 | United States | Michigan | MI | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 9986857 | 2010 | 83 | 1802 | weekly | |
29396 | 29396 | United States | Missouri | MO | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 6137428 | 1446 | 83 | 1282 | weekly | |
29672 | 29672 | United States | Montana | MT | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1068778 | 303 | 83 | 203 | weekly | |
30032 | 30032 | United States | Nebraska | NE | 2021-12-05 | 2021-12-11 | 7 | 2021 | 49 | 1934408 | 464 | 83 | 372 | weekly | |
30980 | 30980 | United States | New Jersey | NJ | 2022-05-22 | 2022-05-28 | 7 | 2022 | 21 | 8882190 | 1444 | 83 | 1393 | weekly | |
31917 | 31917 | United States | North Carolina | NC | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 10488084 | 2036 | 83 | 1825 | weekly | |
32799 | 32799 | United States | Oklahoma | OK | 2021-10-31 | 2021-11-06 | 7 | 2021 | 44 | 3956971 | 909 | 83 | 789 | weekly | |
33396 | 33396 | United States | Pennsylvania | PA | 2021-06-20 | 2021-06-26 | 7 | 2021 | 25 | 12801989 | 2514 | 83 | 2592 | weekly | |
33979 | 33979 | United States | South Carolina | SC | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 5148714 | 1185 | 83 | 994 | weekly | |
34685 | 34685 | United States | Tennessee | TN | 2022-07-24 | 2022-07-30 | 7 | 2022 | 30 | 6833174 | 1548 | 83 | 1441 | weekly | |
34981 | 34981 | United States | Texas | TX | 2022-05-01 | 2022-05-07 | 7 | 2022 | 18 | 28995881 | 4131 | 83 | 4011 | weekly | |
35806 | 35806 | United States | Virginia | VA | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 8535519 | 1422 | 83 | 1311 | weekly | |
37875 | 37875 | Guatemala | Guatemala | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 17843914 | 1866 | 83 | TBC | 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]);