economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
50 rows where covid_deaths = 57
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: days, year, month, start_date (date), end_date (date)
country 14
- United States 33
- Azerbaijan 2
- Belgium 2
- Ireland 2
- Norway 2
- Albania 1
- Bulgaria 1
- Finland 1
- Kyrgyzstan 1
- Latvia 1
- Netherlands 1
- Slovakia 1
- Slovenia 1
- South Korea 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1323 | 1323 | Latvia | Latvia | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 1850654 | 654 | 57 | TBC | weekly | |
1456 | 1456 | Kyrgyzstan | Kyrgyzstan | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 6630621 | 2988 | 57 | TBC | monthly | 1 | |
1833 | 1833 | Slovakia | Slovakia | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 5643455 | 1309 | 57 | TBC | weekly | |
2318 | 2318 | Bulgaria | Bulgaria | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 6781955 | 2139 | 57 | TBC | weekly | |
3148 | 3148 | Belgium | Belgium | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 11655923 | 2012 | 57 | TBC | weekly | |
3150 | 3150 | Belgium | Belgium | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 11655923 | 1885 | 57 | TBC | weekly | |
5210 | 5210 | Slovenia | Slovenia | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 2119843 | 442 | 57 | TBC | weekly | |
7795 | 7795 | South Korea | South Korea | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 51815808 | 6099 | 57 | TBC | weekly | |
15805 | 15805 | Finland | Finland | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 5540745 | 1041 | 57 | TBC | weekly | |
16766 | 16766 | Azerbaijan | Azerbaijan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 10358078 | 4520 | 57 | TBC | monthly | 9 | |
16789 | 16789 | Azerbaijan | Azerbaijan | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 10358078 | 4575 | 57 | TBC | monthly | 8 | |
17075 | 17075 | Netherlands | Netherlands | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 17564020 | 2682 | 57 | TBC | weekly | |
19718 | 19718 | Ireland | Ireland | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 5023108 | 2340 | 57 | TBC | monthly | 6 | |
19720 | 19720 | Ireland | Ireland | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 5023108 | 2586 | 57 | TBC | monthly | 8 | |
21034 | 21034 | Albania | Albania | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 2842318 | 1874 | 57 | TBC | monthly | 5 | |
21715 | 21715 | United States | Alabama | AL | 2021-11-28 | 2021-12-04 | 7 | 2021 | 48 | 4903185 | 1257 | 57 | 1090 | weekly | |
22685 | 22685 | United States | Arkansas | AR | 2022-10-16 | 2022-10-22 | 7 | 2022 | 42 | 3017825 | 672 | 57 | 615 | weekly | |
25367 | 25367 | United States | Idaho | ID | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1787065 | 284 | 57 | 317 | weekly | |
26268 | 26268 | United States | Iowa | IA | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 3155070 | 625 | 57 | 556 | weekly | |
26377 | 26377 | United States | Iowa | IA | 2022-09-18 | 2022-09-24 | 7 | 2022 | 38 | 3155070 | 600 | 57 | 571 | weekly | |
26871 | 26871 | United States | Kentucky | KY | 2020-05-17 | 2020-05-23 | 7 | 2020 | 21 | 4467673 | 998 | 57 | 955 | weekly | |
26923 | 26923 | United States | Kentucky | KY | 2021-05-16 | 2021-05-22 | 7 | 2021 | 20 | 4467673 | 1048 | 57 | 949 | weekly | |
27302 | 27302 | United States | Louisiana | LA | 2022-09-25 | 2022-10-01 | 7 | 2022 | 39 | 4648794 | 876 | 57 | 876 | weekly | |
28425 | 28425 | United States | Michigan | MI | 2020-08-23 | 2020-08-29 | 7 | 2020 | 35 | 9986857 | 1936 | 57 | 1799 | weekly | |
28714 | 28714 | United States | Minnesota | MN | 2020-04-12 | 2020-04-18 | 7 | 2020 | 16 | 5639632 | 955 | 57 | 887 | weekly | |
28736 | 28736 | United States | Minnesota | MN | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 5639632 | 957 | 57 | 870 | weekly | |
28739 | 28739 | United States | Minnesota | MN | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 5639632 | 1013 | 57 | 888 | weekly | |
28814 | 28814 | United States | Minnesota | MN | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 5639632 | 938 | 57 | 921 | weekly | |
29021 | 29021 | United States | Mississippi | MS | 2020-04-05 | 2020-04-11 | 7 | 2020 | 15 | 2976149 | 699 | 57 | 627 | weekly | |
29111 | 29111 | United States | Mississippi | MS | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 2976149 | 825 | 57 | 664 | weekly | |
29689 | 29689 | United States | Montana | MT | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 1068778 | 204 | 57 | 198 | weekly | |
30044 | 30044 | United States | Nebraska | NE | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 1934408 | 372 | 57 | 364 | weekly | |
30267 | 30267 | United States | Nevada | NV | 2020-07-12 | 2020-07-18 | 7 | 2020 | 29 | 3080156 | 640 | 57 | 532 | weekly | |
30284 | 30284 | United States | Nevada | NV | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 3080156 | 631 | 57 | 544 | weekly | |
30307 | 30307 | United States | Nevada | NV | 2021-04-18 | 2021-04-24 | 7 | 2021 | 16 | 3080156 | 577 | 57 | 550 | weekly | |
31255 | 31255 | United States | New Mexico | NM | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 2096829 | 470 | 57 | 364 | weekly | |
31257 | 31257 | United States | New Mexico | NM | 2021-10-17 | 2021-10-23 | 7 | 2021 | 42 | 2096829 | 490 | 57 | 362 | weekly | |
31284 | 31284 | United States | New Mexico | NM | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 2096829 | 398 | 57 | 383 | weekly | |
31285 | 31285 | United States | New Mexico | NM | 2022-05-01 | 2022-05-07 | 7 | 2022 | 18 | 2096829 | 452 | 57 | 380 | weekly | |
31508 | 31508 | United States | New York | NY | 2020-09-13 | 2020-09-19 | 7 | 2020 | 38 | 19453561 | 2886 | 57 | 2884 | weekly | |
32136 | 32136 | United States | North Dakota | ND | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 762062 | 231 | 57 | 145 | weekly | |
32475 | 32475 | United States | Ohio | OH | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 11689100 | 2334 | 57 | 2402 | weekly | |
32518 | 32518 | United States | Ohio | OH | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 11689100 | 2337 | 57 | 2344 | weekly | |
33071 | 33071 | United States | Oregon | OR | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 4217737 | 800 | 57 | 746 | weekly | |
33115 | 33115 | United States | Oregon | OR | 2021-12-26 | 2022-01-01 | 7 | 2021 | 52 | 4217737 | 936 | 57 | 743 | weekly | |
35225 | 35225 | United States | Utah | UT | 2021-02-07 | 2021-02-13 | 7 | 2021 | 6 | 3205958 | 450 | 57 | 417 | weekly | |
36133 | 36133 | United States | Washington | WA | 2020-10-18 | 2020-10-24 | 7 | 2020 | 43 | 7614893 | 1195 | 57 | 1119 | weekly | |
36745 | 36745 | United States | Wisconsin | WI | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 5822434 | 1102 | 57 | 1020 | weekly | |
39523 | 39523 | Norway | Norway | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 5434324 | 841 | 57 | TBC | weekly | |
39639 | 39639 | Norway | Norway | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 5434324 | 802 | 57 | 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]);