economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Switzerland" and year = 2017 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10224 | 10224 | Switzerland | Switzerland | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 8740471 | 1375 | 0 | TBC | weekly | |
10223 | 10223 | Switzerland | Switzerland | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 8740471 | 1456 | 0 | TBC | weekly | |
10222 | 10222 | Switzerland | Switzerland | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 8740471 | 1357 | 0 | TBC | weekly | |
10221 | 10221 | Switzerland | Switzerland | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 8740471 | 1390 | 0 | TBC | weekly | |
10220 | 10220 | Switzerland | Switzerland | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 8740471 | 1396 | 0 | TBC | weekly | |
10219 | 10219 | Switzerland | Switzerland | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 8740471 | 1318 | 0 | TBC | weekly | |
10218 | 10218 | Switzerland | Switzerland | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 8740471 | 1251 | 0 | TBC | weekly | |
10217 | 10217 | Switzerland | Switzerland | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 8740471 | 1312 | 0 | TBC | weekly | |
10216 | 10216 | Switzerland | Switzerland | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 8740471 | 1153 | 0 | TBC | weekly | |
10215 | 10215 | Switzerland | Switzerland | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 8740471 | 1214 | 0 | TBC | weekly | |
10214 | 10214 | Switzerland | Switzerland | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 8740471 | 1210 | 0 | TBC | weekly | |
10213 | 10213 | Switzerland | Switzerland | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 8740471 | 1268 | 0 | TBC | weekly | |
10212 | 10212 | Switzerland | Switzerland | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 8740471 | 1295 | 0 | TBC | weekly | |
10211 | 10211 | Switzerland | Switzerland | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 8740471 | 1243 | 0 | TBC | weekly | |
10210 | 10210 | Switzerland | Switzerland | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 8740471 | 1265 | 0 | TBC | weekly | |
10209 | 10209 | Switzerland | Switzerland | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 8740471 | 1190 | 0 | TBC | weekly | |
10208 | 10208 | Switzerland | Switzerland | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 8740471 | 1153 | 0 | TBC | weekly | |
10207 | 10207 | Switzerland | Switzerland | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 8740471 | 1164 | 0 | TBC | weekly | |
10206 | 10206 | Switzerland | Switzerland | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 8740471 | 1207 | 0 | TBC | weekly | |
10205 | 10205 | Switzerland | Switzerland | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 8740471 | 1128 | 0 | TBC | weekly | |
10204 | 10204 | Switzerland | Switzerland | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 8740471 | 1099 | 0 | TBC | weekly | |
10203 | 10203 | Switzerland | Switzerland | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 8740471 | 1200 | 0 | TBC | weekly | |
10202 | 10202 | Switzerland | Switzerland | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 8740471 | 1121 | 0 | TBC | weekly | |
10201 | 10201 | Switzerland | Switzerland | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 8740471 | 1151 | 0 | TBC | weekly | |
10200 | 10200 | Switzerland | Switzerland | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 8740471 | 1087 | 0 | TBC | weekly | |
10199 | 10199 | Switzerland | Switzerland | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 8740471 | 1158 | 0 | TBC | weekly | |
10198 | 10198 | Switzerland | Switzerland | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 8740471 | 1166 | 0 | TBC | weekly | |
10197 | 10197 | Switzerland | Switzerland | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 8740471 | 1196 | 0 | TBC | weekly | |
10196 | 10196 | Switzerland | Switzerland | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 8740471 | 1120 | 0 | TBC | weekly | |
10195 | 10195 | Switzerland | Switzerland | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 8740471 | 1108 | 0 | TBC | weekly | |
10194 | 10194 | Switzerland | Switzerland | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 8740471 | 1126 | 0 | TBC | weekly | |
10193 | 10193 | Switzerland | Switzerland | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 8740471 | 1186 | 0 | TBC | weekly | |
10192 | 10192 | Switzerland | Switzerland | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 8740471 | 1207 | 0 | TBC | weekly | |
10191 | 10191 | Switzerland | Switzerland | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 8740471 | 1204 | 0 | TBC | weekly | |
10190 | 10190 | Switzerland | Switzerland | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 8740471 | 1210 | 0 | TBC | weekly | |
10189 | 10189 | Switzerland | Switzerland | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 8740471 | 1223 | 0 | TBC | weekly | |
10188 | 10188 | Switzerland | Switzerland | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 8740471 | 1181 | 0 | TBC | weekly | |
10187 | 10187 | Switzerland | Switzerland | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 8740471 | 1201 | 0 | TBC | weekly | |
10186 | 10186 | Switzerland | Switzerland | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 8740471 | 1234 | 0 | TBC | weekly | |
10185 | 10185 | Switzerland | Switzerland | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 8740471 | 1183 | 0 | TBC | weekly | |
10184 | 10184 | Switzerland | Switzerland | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 8740471 | 1239 | 0 | TBC | weekly | |
10183 | 10183 | Switzerland | Switzerland | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 8740471 | 1262 | 0 | TBC | weekly | |
10182 | 10182 | Switzerland | Switzerland | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 8740471 | 1348 | 0 | TBC | weekly | |
10181 | 10181 | Switzerland | Switzerland | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 8740471 | 1395 | 0 | TBC | weekly | |
10180 | 10180 | Switzerland | Switzerland | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 8740471 | 1383 | 0 | TBC | weekly | |
10179 | 10179 | Switzerland | Switzerland | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 8740471 | 1402 | 0 | TBC | weekly | |
10178 | 10178 | Switzerland | Switzerland | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 8740471 | 1592 | 0 | TBC | weekly | |
10177 | 10177 | Switzerland | Switzerland | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 8740471 | 1564 | 0 | TBC | weekly | |
10176 | 10176 | Switzerland | Switzerland | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 8740471 | 1657 | 0 | TBC | weekly | |
10175 | 10175 | Switzerland | Switzerland | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 8740471 | 1746 | 0 | TBC | weekly | |
10174 | 10174 | Switzerland | Switzerland | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 8740471 | 1731 | 0 | TBC | weekly | |
10173 | 10173 | Switzerland | Switzerland | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 8740471 | 1678 | 0 | 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]);