economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
19 rows where covid_deaths = 136
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, days, year, week, expected_deaths, start_date (date), end_date (date)
country 8
- United States 11
- Sweden 2
- Chile 1
- Guatemala 1
- New Zealand 1
- North Macedonia 1
- Portugal 1
- Spain 1
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3673 | 3673 | Sweden | Sweden | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 10549349 | 2071.9 | 136 | TBC | weekly | |
3683 | 3683 | Sweden | Sweden | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 10549349 | 1774 | 136 | TBC | weekly | |
9966 | 9966 | New Zealand | New Zealand | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 5185289 | 848 | 136 | TBC | weekly | |
13253 | 13253 | Portugal | Portugal | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 10270857 | 2148 | 136 | TBC | weekly | |
15989 | 15989 | North Macedonia | North Macedonia | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 2093606 | 1765 | 136 | TBC | monthly | 9 | |
17978 | 17978 | Spain | Spain | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 47558632 | 7821 | 136 | TBC | weekly | |
24815 | 24815 | United States | Georgia | GA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 10617423 | 1753 | 136 | 1725 | weekly | |
24827 | 24827 | United States | Georgia | GA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 10617423 | 1821 | 136 | 1641 | weekly | |
26631 | 26631 | United States | Kansas | KS | 2021-09-05 | 2021-09-11 | 7 | 2021 | 36 | 2913314 | 612 | 136 | 503 | weekly | |
28124 | 28124 | United States | Massachusetts | MA | 2020-10-11 | 2020-10-17 | 7 | 2020 | 42 | 6949503 | 1131 | 136 | 1125 | weekly | |
29068 | 29068 | United States | Mississippi | MS | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 2976149 | 719 | 136 | 647 | weekly | |
31819 | 31819 | United States | North Carolina | NC | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 10488084 | 2117 | 136 | 1869 | weekly | |
31847 | 31847 | United States | North Carolina | NC | 2021-04-18 | 2021-04-24 | 7 | 2021 | 16 | 10488084 | 2036 | 136 | 1927 | weekly | |
31894 | 31894 | United States | North Carolina | NC | 2022-03-13 | 2022-03-19 | 7 | 2022 | 11 | 10488084 | 1938 | 136 | 2006 | weekly | |
34586 | 34586 | United States | Tennessee | TN | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 6833174 | 1624 | 136 | 1470 | weekly | |
35918 | 35918 | United States | Virginia | VA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 8535519 | 1512 | 136 | 1314 | weekly | |
36188 | 36188 | United States | Washington | WA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 7614893 | 1397 | 136 | 1158 | weekly | |
37941 | 37941 | Guatemala | Guatemala | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 17843914 | 2193 | 136 | TBC | weekly | |
39074 | 39074 | Chile | Chile | 0 | 2022-10-31 | 2022-11-06 | 7 | 2022 | 44 | 19603736 | 2515 | 136 | 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]);