economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
17 rows where covid_deaths = 155
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, days, year, week, expected_deaths, end_date (date)
country 8
- United States 10
- Bulgaria 1
- Colombia 1
- Dominican Republic 1
- Germany 1
- Greece 1
- Iran 1
- South Africa 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2356 | 2356 | Bulgaria | Bulgaria | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 6781955 | 2491 | 155 | TBC | weekly | |
8195 | 8195 | South Africa | South Africa | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 59893884 | 11146 | 155 | TBC | weekly | |
12731 | 12731 | Iran | Iran | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 88550568 | 7958 | 155 | TBC | weekly | |
19606 | 19606 | Colombia | Colombia | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 51874028 | 4965 | 155 | TBC | weekly | |
20191 | 20191 | Greece | Greece | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 10384972 | 2485 | 155 | TBC | weekly | |
20866 | 20866 | Dominican Republic | Dominican Republic | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 11228821 | 3687 | 155 | TBC | monthly | 4 | |
22917 | 22917 | United States | California | CA | 2021-05-02 | 2021-05-08 | 7 | 2021 | 18 | 39512223 | 5370 | 155 | 5343 | weekly | |
25694 | 25694 | United States | Illinois | IL | 2021-06-06 | 2021-06-12 | 7 | 2021 | 23 | 12671821 | 2121 | 155 | 2016 | weekly | |
26280 | 26280 | United States | Iowa | IA | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 3155070 | 905 | 155 | 608 | weekly | |
26973 | 26973 | United States | Kentucky | KY | 2022-05-01 | 2022-05-07 | 7 | 2022 | 18 | 4467673 | 966 | 155 | 929 | weekly | |
29040 | 29040 | United States | Mississippi | MS | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 2976149 | 813 | 155 | 598 | weekly | |
30323 | 30323 | United States | Nevada | NV | 2021-08-08 | 2021-08-14 | 7 | 2021 | 32 | 3080156 | 705 | 155 | 507 | weekly | |
31594 | 31594 | United States | New York | NY | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 19453561 | 3276 | 155 | 2909 | weekly | |
35803 | 35803 | United States | Virginia | VA | 2020-05-17 | 2020-05-23 | 7 | 2020 | 21 | 8535519 | 1464 | 155 | 1340 | weekly | |
35821 | 35821 | United States | Virginia | VA | 2020-09-20 | 2020-09-26 | 7 | 2020 | 39 | 8535519 | 1484 | 155 | 1326 | weekly | |
36493 | 36493 | United States | West Virginia | WV | 2021-10-17 | 2021-10-23 | 7 | 2021 | 42 | 1792147 | 608 | 155 | 454 | weekly | |
38308 | 38308 | Germany | Germany | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 83369840 | 17613 | 155 | 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]);