economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
14 rows where covid_deaths = 197
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, days, expected_deaths, start_date (date), end_date (date)
country 8
- United States 6
- Austria 2
- Bosnia and Herzegovina 1
- Canada 1
- Ecuador 1
- Iran 1
- Kazakhstan 1
- Kuwait 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
808 | 808 | Ecuador | Ecuador | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 18001002 | 2425 | 197 | TBC | weekly | |
10744 | 10744 | Kuwait | Kuwait | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 4268886 | 1032 | 197 | TBC | monthly | 6 | |
12730 | 12730 | Iran | Iran | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 88550568 | 8504 | 197 | TBC | weekly | |
14436 | 14436 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 3233530 | 3182 | 197 | TBC | monthly | 8 | |
15370 | 15370 | Canada | Canada | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 38454328 | 5990 | 197 | TBC | weekly | |
17571 | 17571 | Austria | Austria | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 8939617 | 1856 | 197 | TBC | weekly | |
17579 | 17579 | Austria | Austria | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 8939617 | 1916 | 197 | TBC | weekly | |
25632 | 25632 | United States | Illinois | IL | 2020-03-29 | 2020-04-04 | 7 | 2020 | 14 | 12671821 | 2622 | 197 | 2145 | weekly | |
26014 | 26014 | United States | Indiana | IN | 2021-08-29 | 2021-09-04 | 7 | 2021 | 35 | 6732219 | 1545 | 197 | 1290 | weekly | |
31621 | 31621 | United States | New York | NY | 2022-11-13 | 2022-11-19 | 7 | 2022 | 46 | 19453561 | 3356 | 197 | 3058 | weekly | |
31810 | 31810 | United States | North Carolina | NC | 2020-08-02 | 2020-08-08 | 7 | 2020 | 32 | 10488084 | 2061 | 197 | 1829 | weekly | |
33435 | 33435 | United States | Pennsylvania | PA | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 12801989 | 2670 | 197 | 2686 | weekly | |
36452 | 36452 | United States | West Virginia | WV | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1792147 | 722 | 197 | 478 | weekly | |
40076 | 40076 | Kazakhstan | Kazakhstan | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 19397998 | 13672 | 197 | TBC | monthly | 9 |
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]);