economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
18 rows where covid_deaths = 275
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, start_date, days, year, week, expected_deaths, start_date (date), end_date (date)
country 7
- United States 11
- Ecuador 2
- Azerbaijan 1
- Britain 1
- Japan 1
- Peru 1
- Sweden 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
769 | 769 | Ecuador | Ecuador | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 18001002 | 2180 | 275 | TBC | weekly | |
806 | 806 | Ecuador | Ecuador | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 18001002 | 2279 | 275 | TBC | weekly | |
3614 | 3614 | Sweden | Sweden | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 10549349 | 2010.1 | 275 | TBC | weekly | |
3785 | 3785 | Japan | Japan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 123951696 | 107468 | 275 | TBC | monthly | 9 | |
7085 | 7085 | Peru | Peru | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 34049588 | 3451 | 275 | TBC | weekly | |
11621 | 11621 | Britain | Britain | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 67508936 | 11137 | 275 | TBC | weekly | |
16784 | 16784 | Azerbaijan | Azerbaijan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 10358078 | 6166 | 275 | TBC | monthly | 3 | |
22326 | 22326 | United States | Arizona | AZ | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 7278717 | 1592 | 275 | 1174 | weekly | |
22595 | 22595 | United States | Arkansas | AR | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3017825 | 873 | 275 | 701 | weekly | |
24758 | 24758 | United States | Georgia | GA | 2021-03-14 | 2021-03-20 | 7 | 2021 | 11 | 10617423 | 1917 | 275 | 1794 | weekly | |
24813 | 24813 | United States | Georgia | GA | 2022-04-03 | 2022-04-09 | 7 | 2022 | 14 | 10617423 | 1803 | 275 | 1746 | weekly | |
25983 | 25983 | United States | Indiana | IN | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6732219 | 1624 | 275 | 1487 | weekly | |
26948 | 26948 | United States | Kentucky | KY | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 4467673 | 1132 | 275 | 957 | weekly | |
27216 | 27216 | United States | Louisiana | LA | 2021-01-31 | 2021-02-06 | 7 | 2021 | 5 | 4648794 | 1202 | 275 | 985 | weekly | |
28542 | 28542 | United States | Michigan | MI | 2022-11-20 | 2022-11-26 | 7 | 2022 | 47 | 9986857 | 2290 | 275 | 1968 | weekly | |
29059 | 29059 | United States | Mississippi | MS | 2020-12-27 | 2021-01-02 | 7 | 2020 | 53 | 2976149 | 1068 | 275 | 652 | weekly | |
30922 | 30922 | United States | New Jersey | NJ | 2021-04-11 | 2021-04-17 | 7 | 2021 | 15 | 8882190 | 1584 | 275 | 1552 | weekly | |
35891 | 35891 | United States | Virginia | VA | 2022-01-23 | 2022-01-29 | 7 | 2022 | 4 | 8535519 | 2148 | 275 | 1509 | 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]);