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 = 2018
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10225 | 10225 | Switzerland | Switzerland | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 8740471 | 1561 | 0 | TBC | weekly | |
10226 | 10226 | Switzerland | Switzerland | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 8740471 | 1541 | 0 | TBC | weekly | |
10227 | 10227 | Switzerland | Switzerland | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 8740471 | 1494 | 0 | TBC | weekly | |
10228 | 10228 | Switzerland | Switzerland | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 8740471 | 1397 | 0 | TBC | weekly | |
10229 | 10229 | Switzerland | Switzerland | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 8740471 | 1397 | 0 | TBC | weekly | |
10230 | 10230 | Switzerland | Switzerland | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 8740471 | 1441 | 0 | TBC | weekly | |
10231 | 10231 | Switzerland | Switzerland | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 8740471 | 1458 | 0 | TBC | weekly | |
10232 | 10232 | Switzerland | Switzerland | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 8740471 | 1478 | 0 | TBC | weekly | |
10233 | 10233 | Switzerland | Switzerland | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 8740471 | 1636 | 0 | TBC | weekly | |
10234 | 10234 | Switzerland | Switzerland | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 8740471 | 1532 | 0 | TBC | weekly | |
10235 | 10235 | Switzerland | Switzerland | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 8740471 | 1482 | 0 | TBC | weekly | |
10236 | 10236 | Switzerland | Switzerland | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 8740471 | 1380 | 0 | TBC | weekly | |
10237 | 10237 | Switzerland | Switzerland | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 8740471 | 1348 | 0 | TBC | weekly | |
10238 | 10238 | Switzerland | Switzerland | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 8740471 | 1339 | 0 | TBC | weekly | |
10239 | 10239 | Switzerland | Switzerland | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 8740471 | 1300 | 0 | TBC | weekly | |
10240 | 10240 | Switzerland | Switzerland | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 8740471 | 1229 | 0 | TBC | weekly | |
10241 | 10241 | Switzerland | Switzerland | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 8740471 | 1147 | 0 | TBC | weekly | |
10242 | 10242 | Switzerland | Switzerland | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 8740471 | 1226 | 0 | TBC | weekly | |
10243 | 10243 | Switzerland | Switzerland | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 8740471 | 1200 | 0 | TBC | weekly | |
10244 | 10244 | Switzerland | Switzerland | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 8740471 | 1117 | 0 | TBC | weekly | |
10245 | 10245 | Switzerland | Switzerland | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 8740471 | 1223 | 0 | TBC | weekly | |
10246 | 10246 | Switzerland | Switzerland | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 8740471 | 1159 | 0 | TBC | weekly | |
10247 | 10247 | Switzerland | Switzerland | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 8740471 | 1178 | 0 | TBC | weekly | |
10248 | 10248 | Switzerland | Switzerland | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 8740471 | 1119 | 0 | TBC | weekly | |
10249 | 10249 | Switzerland | Switzerland | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 8740471 | 1127 | 0 | TBC | weekly | |
10250 | 10250 | Switzerland | Switzerland | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 8740471 | 1181 | 0 | TBC | weekly | |
10251 | 10251 | Switzerland | Switzerland | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 8740471 | 1152 | 0 | TBC | weekly | |
10252 | 10252 | Switzerland | Switzerland | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 8740471 | 1078 | 0 | TBC | weekly | |
10253 | 10253 | Switzerland | Switzerland | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 8740471 | 1223 | 0 | TBC | weekly | |
10254 | 10254 | Switzerland | Switzerland | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 8740471 | 1222 | 0 | TBC | weekly | |
10255 | 10255 | Switzerland | Switzerland | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 8740471 | 1264 | 0 | TBC | weekly | |
10256 | 10256 | Switzerland | Switzerland | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 8740471 | 1222 | 0 | TBC | weekly | |
10257 | 10257 | Switzerland | Switzerland | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 8740471 | 1187 | 0 | TBC | weekly | |
10258 | 10258 | Switzerland | Switzerland | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 8740471 | 1145 | 0 | TBC | weekly | |
10259 | 10259 | Switzerland | Switzerland | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 8740471 | 1206 | 0 | TBC | weekly | |
10260 | 10260 | Switzerland | Switzerland | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 8740471 | 1178 | 0 | TBC | weekly | |
10261 | 10261 | Switzerland | Switzerland | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 8740471 | 1230 | 0 | TBC | weekly | |
10262 | 10262 | Switzerland | Switzerland | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 8740471 | 1177 | 0 | TBC | weekly | |
10263 | 10263 | Switzerland | Switzerland | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 8740471 | 1212 | 0 | TBC | weekly | |
10264 | 10264 | Switzerland | Switzerland | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 8740471 | 1225 | 0 | TBC | weekly | |
10265 | 10265 | Switzerland | Switzerland | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 8740471 | 1233 | 0 | TBC | weekly | |
10266 | 10266 | Switzerland | Switzerland | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 8740471 | 1211 | 0 | TBC | weekly | |
10267 | 10267 | Switzerland | Switzerland | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 8740471 | 1233 | 0 | TBC | weekly | |
10268 | 10268 | Switzerland | Switzerland | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 8740471 | 1272 | 0 | TBC | weekly | |
10269 | 10269 | Switzerland | Switzerland | 0 | 2018-11-05 | 2018-11-11 | 7 | 2018 | 45 | 8740471 | 1263 | 0 | TBC | weekly | |
10270 | 10270 | Switzerland | Switzerland | 0 | 2018-11-12 | 2018-11-18 | 7 | 2018 | 46 | 8740471 | 1248 | 0 | TBC | weekly | |
10271 | 10271 | Switzerland | Switzerland | 0 | 2018-11-19 | 2018-11-25 | 7 | 2018 | 47 | 8740471 | 1280 | 0 | TBC | weekly | |
10272 | 10272 | Switzerland | Switzerland | 0 | 2018-11-26 | 2018-12-02 | 7 | 2018 | 48 | 8740471 | 1321 | 0 | TBC | weekly | |
10273 | 10273 | Switzerland | Switzerland | 0 | 2018-12-03 | 2018-12-09 | 7 | 2018 | 49 | 8740471 | 1389 | 0 | TBC | weekly | |
10274 | 10274 | Switzerland | Switzerland | 0 | 2018-12-10 | 2018-12-16 | 7 | 2018 | 50 | 8740471 | 1356 | 0 | TBC | weekly | |
10275 | 10275 | Switzerland | Switzerland | 0 | 2018-12-17 | 2018-12-23 | 7 | 2018 | 51 | 8740471 | 1322 | 0 | TBC | weekly | |
10276 | 10276 | Switzerland | Switzerland | 0 | 2018-12-24 | 2018-12-30 | 7 | 2018 | 52 | 8740471 | 1349 | 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]);