economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where cadence = "weekly", country = "Switzerland" and year = 2015
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10068 | 10068 | Switzerland | Switzerland | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 8740471 | 1423 | 0 | TBC | weekly | |
10069 | 10069 | Switzerland | Switzerland | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 8740471 | 1494 | 0 | TBC | weekly | |
10070 | 10070 | Switzerland | Switzerland | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 8740471 | 1524 | 0 | TBC | weekly | |
10071 | 10071 | Switzerland | Switzerland | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 8740471 | 1480 | 0 | TBC | weekly | |
10072 | 10072 | Switzerland | Switzerland | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 8740471 | 1590 | 0 | TBC | weekly | |
10073 | 10073 | Switzerland | Switzerland | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 8740471 | 1656 | 0 | TBC | weekly | |
10074 | 10074 | Switzerland | Switzerland | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 8740471 | 1805 | 0 | TBC | weekly | |
10075 | 10075 | Switzerland | Switzerland | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 8740471 | 1772 | 0 | TBC | weekly | |
10076 | 10076 | Switzerland | Switzerland | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 8740471 | 1729 | 0 | TBC | weekly | |
10077 | 10077 | Switzerland | Switzerland | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 8740471 | 1549 | 0 | TBC | weekly | |
10078 | 10078 | Switzerland | Switzerland | 0 | 2015-03-09 | 2015-03-15 | 7 | 2015 | 11 | 8740471 | 1541 | 0 | TBC | weekly | |
10079 | 10079 | Switzerland | Switzerland | 0 | 2015-03-16 | 2015-03-22 | 7 | 2015 | 12 | 8740471 | 1435 | 0 | TBC | weekly | |
10080 | 10080 | Switzerland | Switzerland | 0 | 2015-03-23 | 2015-03-29 | 7 | 2015 | 13 | 8740471 | 1293 | 0 | TBC | weekly | |
10081 | 10081 | Switzerland | Switzerland | 0 | 2015-03-30 | 2015-04-05 | 7 | 2015 | 14 | 8740471 | 1302 | 0 | TBC | weekly | |
10082 | 10082 | Switzerland | Switzerland | 0 | 2015-04-06 | 2015-04-12 | 7 | 2015 | 15 | 8740471 | 1229 | 0 | TBC | weekly | |
10083 | 10083 | Switzerland | Switzerland | 0 | 2015-04-13 | 2015-04-19 | 7 | 2015 | 16 | 8740471 | 1284 | 0 | TBC | weekly | |
10084 | 10084 | Switzerland | Switzerland | 0 | 2015-04-20 | 2015-04-26 | 7 | 2015 | 17 | 8740471 | 1215 | 0 | TBC | weekly | |
10085 | 10085 | Switzerland | Switzerland | 0 | 2015-04-27 | 2015-05-03 | 7 | 2015 | 18 | 8740471 | 1275 | 0 | TBC | weekly | |
10086 | 10086 | Switzerland | Switzerland | 0 | 2015-05-04 | 2015-05-10 | 7 | 2015 | 19 | 8740471 | 1161 | 0 | TBC | weekly | |
10087 | 10087 | Switzerland | Switzerland | 0 | 2015-05-11 | 2015-05-17 | 7 | 2015 | 20 | 8740471 | 1152 | 0 | TBC | weekly | |
10088 | 10088 | Switzerland | Switzerland | 0 | 2015-05-18 | 2015-05-24 | 7 | 2015 | 21 | 8740471 | 1129 | 0 | TBC | weekly | |
10089 | 10089 | Switzerland | Switzerland | 0 | 2015-05-25 | 2015-05-31 | 7 | 2015 | 22 | 8740471 | 1099 | 0 | TBC | weekly | |
10090 | 10090 | Switzerland | Switzerland | 0 | 2015-06-01 | 2015-06-07 | 7 | 2015 | 23 | 8740471 | 1171 | 0 | TBC | weekly | |
10091 | 10091 | Switzerland | Switzerland | 0 | 2015-06-08 | 2015-06-14 | 7 | 2015 | 24 | 8740471 | 1169 | 0 | TBC | weekly | |
10092 | 10092 | Switzerland | Switzerland | 0 | 2015-06-15 | 2015-06-21 | 7 | 2015 | 25 | 8740471 | 1100 | 0 | TBC | weekly | |
10093 | 10093 | Switzerland | Switzerland | 0 | 2015-06-22 | 2015-06-28 | 7 | 2015 | 26 | 8740471 | 1197 | 0 | TBC | weekly | |
10094 | 10094 | Switzerland | Switzerland | 0 | 2015-06-29 | 2015-07-05 | 7 | 2015 | 27 | 8740471 | 1295 | 0 | TBC | weekly | |
10095 | 10095 | Switzerland | Switzerland | 0 | 2015-07-06 | 2015-07-12 | 7 | 2015 | 28 | 8740471 | 1358 | 0 | TBC | weekly | |
10096 | 10096 | Switzerland | Switzerland | 0 | 2015-07-13 | 2015-07-19 | 7 | 2015 | 29 | 8740471 | 1295 | 0 | TBC | weekly | |
10097 | 10097 | Switzerland | Switzerland | 0 | 2015-07-20 | 2015-07-26 | 7 | 2015 | 30 | 8740471 | 1174 | 0 | TBC | weekly | |
10098 | 10098 | Switzerland | Switzerland | 0 | 2015-07-27 | 2015-08-02 | 7 | 2015 | 31 | 8740471 | 1140 | 0 | TBC | weekly | |
10099 | 10099 | Switzerland | Switzerland | 0 | 2015-08-03 | 2015-08-09 | 7 | 2015 | 32 | 8740471 | 1215 | 0 | TBC | weekly | |
10100 | 10100 | Switzerland | Switzerland | 0 | 2015-08-10 | 2015-08-16 | 7 | 2015 | 33 | 8740471 | 1195 | 0 | TBC | weekly | |
10101 | 10101 | Switzerland | Switzerland | 0 | 2015-08-17 | 2015-08-23 | 7 | 2015 | 34 | 8740471 | 1152 | 0 | TBC | weekly | |
10102 | 10102 | Switzerland | Switzerland | 0 | 2015-08-24 | 2015-08-30 | 7 | 2015 | 35 | 8740471 | 1172 | 0 | TBC | weekly | |
10103 | 10103 | Switzerland | Switzerland | 0 | 2015-08-31 | 2015-09-06 | 7 | 2015 | 36 | 8740471 | 1151 | 0 | TBC | weekly | |
10104 | 10104 | Switzerland | Switzerland | 0 | 2015-09-07 | 2015-09-13 | 7 | 2015 | 37 | 8740471 | 1188 | 0 | TBC | weekly | |
10105 | 10105 | Switzerland | Switzerland | 0 | 2015-09-14 | 2015-09-20 | 7 | 2015 | 38 | 8740471 | 1130 | 0 | TBC | weekly | |
10106 | 10106 | Switzerland | Switzerland | 0 | 2015-09-21 | 2015-09-27 | 7 | 2015 | 39 | 8740471 | 1188 | 0 | TBC | weekly | |
10107 | 10107 | Switzerland | Switzerland | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 8740471 | 1235 | 0 | TBC | weekly | |
10108 | 10108 | Switzerland | Switzerland | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 8740471 | 1168 | 0 | TBC | weekly | |
10109 | 10109 | Switzerland | Switzerland | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 8740471 | 1220 | 0 | TBC | weekly | |
10110 | 10110 | Switzerland | Switzerland | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 8740471 | 1203 | 0 | TBC | weekly | |
10111 | 10111 | Switzerland | Switzerland | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 8740471 | 1286 | 0 | TBC | weekly | |
10112 | 10112 | Switzerland | Switzerland | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 8740471 | 1169 | 0 | TBC | weekly | |
10113 | 10113 | Switzerland | Switzerland | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 8740471 | 1199 | 0 | TBC | weekly | |
10114 | 10114 | Switzerland | Switzerland | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 8740471 | 1257 | 0 | TBC | weekly | |
10115 | 10115 | Switzerland | Switzerland | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 8740471 | 1255 | 0 | TBC | weekly | |
10116 | 10116 | Switzerland | Switzerland | 0 | 2015-11-30 | 2015-12-06 | 7 | 2015 | 49 | 8740471 | 1307 | 0 | TBC | weekly | |
10117 | 10117 | Switzerland | Switzerland | 0 | 2015-12-07 | 2015-12-13 | 7 | 2015 | 50 | 8740471 | 1240 | 0 | TBC | weekly | |
10118 | 10118 | Switzerland | Switzerland | 0 | 2015-12-14 | 2015-12-20 | 7 | 2015 | 51 | 8740471 | 1208 | 0 | TBC | weekly | |
10119 | 10119 | Switzerland | Switzerland | 0 | 2015-12-21 | 2015-12-27 | 7 | 2015 | 52 | 8740471 | 1294 | 0 | TBC | weekly | |
10120 | 10120 | Switzerland | Switzerland | 0 | 2015-12-28 | 2016-01-03 | 7 | 2015 | 53 | 8740471 | 1318 | 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]);