economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
42 rows where covid_deaths = 78
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, days, year, week, expected_deaths, start_date (date), end_date (date)
country 11
- United States 29
- Kyrgyzstan 2
- Poland 2
- Sweden 2
- Australia 1
- Finland 1
- Israel 1
- Lithuania 1
- Netherlands 1
- Norway 1
- Romania 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1468 | 1468 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 6630621 | 2671 | 78 | TBC | monthly | 1 | |
1469 | 1469 | Kyrgyzstan | Kyrgyzstan | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 6630621 | 3177 | 78 | TBC | monthly | 2 | |
3596 | 3596 | Sweden | Sweden | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 10549349 | 1596.3 | 78 | TBC | weekly | |
3709 | 3709 | Sweden | Sweden | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 10549349 | 1761.2 | 78 | TBC | weekly | |
4162 | 4162 | Australia | Australia | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 26177410 | 3353 | 78 | TBC | weekly | |
6177 | 6177 | Israel | Israel | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 9449000 | 913 | 78 | TBC | weekly | |
9442 | 9442 | Romania | Romania | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 19659270 | 4560 | 78 | TBC | weekly | |
11111 | 11111 | Lithuania | Lithuania | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 2750058 | 825 | 78 | TBC | weekly | |
15817 | 15817 | Finland | Finland | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 5540745 | 1192 | 78 | TBC | weekly | |
17126 | 17126 | Netherlands | Netherlands | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 17564020 | 2806 | 78 | TBC | weekly | |
20600 | 20600 | Poland | Poland | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 39857144 | 7947 | 78 | TBC | weekly | |
20601 | 20601 | Poland | Poland | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 39857144 | 7443 | 78 | TBC | weekly | |
21682 | 21682 | United States | Alabama | AL | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 4903185 | 1170 | 78 | 1098 | weekly | |
23576 | 23576 | United States | Connecticut | CT | 2022-02-27 | 2022-03-05 | 7 | 2022 | 9 | 3565287 | 675 | 78 | 679 | weekly | |
24800 | 24800 | United States | Georgia | GA | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 10617423 | 2392 | 78 | 1829 | weekly | |
25411 | 25411 | United States | Idaho | ID | 2021-11-28 | 2021-12-04 | 7 | 2021 | 48 | 1787065 | 349 | 78 | 295 | weekly | |
25420 | 25420 | United States | Idaho | ID | 2022-01-30 | 2022-02-05 | 7 | 2022 | 5 | 1787065 | 385 | 78 | 312 | weekly | |
25952 | 25952 | United States | Indiana | IN | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 6732219 | 1380 | 78 | 1245 | weekly | |
25994 | 25994 | United States | Indiana | IN | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 6732219 | 1395 | 78 | 1373 | weekly | |
26062 | 26062 | United States | Indiana | IN | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 6732219 | 1404 | 78 | 1194 | weekly | |
26063 | 26063 | United States | Indiana | IN | 2022-08-07 | 2022-08-13 | 7 | 2022 | 32 | 6732219 | 1348 | 78 | 1196 | weekly | |
26991 | 26991 | United States | Kentucky | KY | 2022-09-04 | 2022-09-10 | 7 | 2022 | 36 | 4467673 | 971 | 78 | 887 | weekly | |
27182 | 27182 | United States | Louisiana | LA | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 4648794 | 951 | 78 | 868 | weekly | |
27296 | 27296 | United States | Louisiana | LA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 4648794 | 951 | 78 | 863 | weekly | |
27802 | 27802 | United States | Maryland | MD | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 6045680 | 1031 | 78 | 977 | weekly | |
28511 | 28511 | United States | Michigan | MI | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 9986857 | 1917 | 78 | 1897 | weekly | |
28515 | 28515 | United States | Michigan | MI | 2022-05-15 | 2022-05-21 | 7 | 2022 | 20 | 9986857 | 1976 | 78 | 1845 | weekly | |
29030 | 29030 | United States | Mississippi | MS | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 2976149 | 702 | 78 | 597 | weekly | |
29090 | 29090 | United States | Mississippi | MS | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 2976149 | 852 | 78 | 600 | weekly | |
29332 | 29332 | United States | Missouri | MO | 2020-04-26 | 2020-05-02 | 7 | 2020 | 18 | 6137428 | 1393 | 78 | 1238 | weekly | |
29339 | 29339 | United States | Missouri | MO | 2020-06-14 | 2020-06-20 | 7 | 2020 | 25 | 6137428 | 1228 | 78 | 1200 | weekly | |
29385 | 29385 | United States | Missouri | MO | 2021-05-02 | 2021-05-08 | 7 | 2021 | 18 | 6137428 | 1230 | 78 | 1321 | weekly | |
29680 | 29680 | United States | Montana | MT | 2021-01-31 | 2021-02-06 | 7 | 2021 | 5 | 1068778 | 216 | 78 | 212 | weekly | |
31277 | 31277 | United States | New Mexico | NM | 2022-03-06 | 2022-03-12 | 7 | 2022 | 10 | 2096829 | 422 | 78 | 397 | weekly | |
31547 | 31547 | United States | New York | NY | 2021-06-13 | 2021-06-19 | 7 | 2021 | 24 | 19453561 | 2853 | 78 | 2937 | weekly | |
33643 | 33643 | United States | Rhode Island | RI | 2020-04-19 | 2020-04-25 | 7 | 2020 | 17 | 1059361 | 297 | 78 | 200 | weekly | |
34617 | 34617 | United States | Tennessee | TN | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 6833174 | 1693 | 78 | 1557 | weekly | |
35263 | 35263 | United States | Utah | UT | 2021-10-31 | 2021-11-06 | 7 | 2021 | 44 | 3205958 | 529 | 78 | 380 | weekly | |
36122 | 36122 | United States | Washington | WA | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 7614893 | 1234 | 78 | 1083 | weekly | |
36208 | 36208 | United States | Washington | WA | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 7614893 | 1209 | 78 | 1214 | weekly | |
36218 | 36218 | United States | Washington | WA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 7614893 | 1215 | 78 | 1121 | weekly | |
39640 | 39640 | Norway | Norway | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 5434324 | 856 | 78 | 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]);