economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
13 rows where covid_deaths = 222
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, year, population, expected_deaths, start_date (date), end_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
793 | 793 | Ecuador | Ecuador | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 18001002 | 1718 | 222 | TBC | weekly | |
3101 | 3101 | Belgium | Belgium | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 11655923 | 2157 | 222 | TBC | weekly | |
6964 | 6964 | Peru | Peru | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 34049588 | 2742.9 | 222 | TBC | weekly | |
17983 | 17983 | Spain | Spain | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 47558632 | 9017 | 222 | TBC | weekly | |
19583 | 19583 | Colombia | Colombia | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 51874028 | 5180 | 222 | TBC | weekly | |
22625 | 22625 | United States | Arkansas | AR | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3017825 | 903 | 222 | 608 | weekly | |
25987 | 25987 | United States | Indiana | IN | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 6732219 | 1439 | 222 | 1478 | weekly | |
28450 | 28450 | United States | Michigan | MI | 2021-02-14 | 2021-02-20 | 7 | 2021 | 7 | 9986857 | 2101 | 222 | 2114 | weekly | |
30289 | 30289 | United States | Nevada | NV | 2020-12-13 | 2020-12-19 | 7 | 2020 | 51 | 3080156 | 845 | 222 | 573 | weekly | |
30921 | 30921 | United States | New Jersey | NJ | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 8882190 | 1677 | 222 | 1564 | weekly | |
34876 | 34876 | United States | Texas | TX | 2020-04-26 | 2020-05-02 | 7 | 2020 | 18 | 28995881 | 4263 | 222 | 4070 | weekly | |
34877 | 34877 | United States | Texas | TX | 2020-05-03 | 2020-05-09 | 7 | 2020 | 19 | 28995881 | 4278 | 222 | 4036 | weekly | |
39045 | 39045 | Chile | Chile | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 19603736 | 2253 | 222 | 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]);