economist_historical_deaths

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

412 rows where cadence = "weekly" and country = "Switzerland"

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: year, start_date (date), end_date (date)

country 1

  • Switzerland · 412 ✖

cadence 1

  • weekly · 412 ✖
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  
10121 10121 Switzerland Switzerland 0 2016-01-04 2016-01-10 7 2016 1 8740471 1340 0 TBC weekly  
10122 10122 Switzerland Switzerland 0 2016-01-11 2016-01-17 7 2016 2 8740471 1243 0 TBC weekly  
10123 10123 Switzerland Switzerland 0 2016-01-18 2016-01-24 7 2016 3 8740471 1323 0 TBC weekly  
10124 10124 Switzerland Switzerland 0 2016-01-25 2016-01-31 7 2016 4 8740471 1351 0 TBC weekly  
10125 10125 Switzerland Switzerland 0 2016-02-01 2016-02-07 7 2016 5 8740471 1345 0 TBC weekly  
10126 10126 Switzerland Switzerland 0 2016-02-08 2016-02-14 7 2016 6 8740471 1340 0 TBC weekly  
10127 10127 Switzerland Switzerland 0 2016-02-15 2016-02-21 7 2016 7 8740471 1313 0 TBC weekly  
10128 10128 Switzerland Switzerland 0 2016-02-22 2016-02-28 7 2016 8 8740471 1380 0 TBC weekly  
10129 10129 Switzerland Switzerland 0 2016-02-29 2016-03-06 7 2016 9 8740471 1320 0 TBC weekly  
10130 10130 Switzerland Switzerland 0 2016-03-07 2016-03-13 7 2016 10 8740471 1355 0 TBC weekly  
10131 10131 Switzerland Switzerland 0 2016-03-14 2016-03-20 7 2016 11 8740471 1278 0 TBC weekly  
10132 10132 Switzerland Switzerland 0 2016-03-21 2016-03-27 7 2016 12 8740471 1294 0 TBC weekly  
10133 10133 Switzerland Switzerland 0 2016-03-28 2016-04-03 7 2016 13 8740471 1269 0 TBC weekly  
10134 10134 Switzerland Switzerland 0 2016-04-04 2016-04-10 7 2016 14 8740471 1242 0 TBC weekly  
10135 10135 Switzerland Switzerland 0 2016-04-11 2016-04-17 7 2016 15 8740471 1224 0 TBC weekly  
10136 10136 Switzerland Switzerland 0 2016-04-18 2016-04-24 7 2016 16 8740471 1139 0 TBC weekly  
10137 10137 Switzerland Switzerland 0 2016-04-25 2016-05-01 7 2016 17 8740471 1175 0 TBC weekly  
10138 10138 Switzerland Switzerland 0 2016-05-02 2016-05-08 7 2016 18 8740471 1172 0 TBC weekly  
10139 10139 Switzerland Switzerland 0 2016-05-09 2016-05-15 7 2016 19 8740471 1149 0 TBC weekly  
10140 10140 Switzerland Switzerland 0 2016-05-16 2016-05-22 7 2016 20 8740471 1176 0 TBC weekly  
10141 10141 Switzerland Switzerland 0 2016-05-23 2016-05-29 7 2016 21 8740471 1227 0 TBC weekly  
10142 10142 Switzerland Switzerland 0 2016-05-30 2016-06-05 7 2016 22 8740471 1150 0 TBC weekly  
10143 10143 Switzerland Switzerland 0 2016-06-06 2016-06-12 7 2016 23 8740471 1104 0 TBC weekly  
10144 10144 Switzerland Switzerland 0 2016-06-13 2016-06-19 7 2016 24 8740471 1113 0 TBC weekly  
10145 10145 Switzerland Switzerland 0 2016-06-20 2016-06-26 7 2016 25 8740471 1237 0 TBC weekly  
10146 10146 Switzerland Switzerland 0 2016-06-27 2016-07-03 7 2016 26 8740471 1172 0 TBC weekly  
10147 10147 Switzerland Switzerland 0 2016-07-04 2016-07-10 7 2016 27 8740471 1092 0 TBC weekly  
10148 10148 Switzerland Switzerland 0 2016-07-11 2016-07-17 7 2016 28 8740471 1164 0 TBC weekly  
10149 10149 Switzerland Switzerland 0 2016-07-18 2016-07-24 7 2016 29 8740471 1235 0 TBC weekly  
10150 10150 Switzerland Switzerland 0 2016-07-25 2016-07-31 7 2016 30 8740471 1181 0 TBC weekly  
10151 10151 Switzerland Switzerland 0 2016-08-01 2016-08-07 7 2016 31 8740471 1113 0 TBC weekly  
10152 10152 Switzerland Switzerland 0 2016-08-08 2016-08-14 7 2016 32 8740471 1150 0 TBC weekly  
10153 10153 Switzerland Switzerland 0 2016-08-15 2016-08-21 7 2016 33 8740471 1166 0 TBC weekly  
10154 10154 Switzerland Switzerland 0 2016-08-22 2016-08-28 7 2016 34 8740471 1131 0 TBC weekly  
10155 10155 Switzerland Switzerland 0 2016-08-29 2016-09-04 7 2016 35 8740471 1137 0 TBC weekly  
10156 10156 Switzerland Switzerland 0 2016-09-05 2016-09-11 7 2016 36 8740471 1184 0 TBC weekly  
10157 10157 Switzerland Switzerland 0 2016-09-12 2016-09-18 7 2016 37 8740471 1103 0 TBC weekly  
10158 10158 Switzerland Switzerland 0 2016-09-19 2016-09-25 7 2016 38 8740471 1180 0 TBC weekly  
10159 10159 Switzerland Switzerland 0 2016-09-26 2016-10-02 7 2016 39 8740471 1212 0 TBC weekly  
10160 10160 Switzerland Switzerland 0 2016-10-03 2016-10-09 7 2016 40 8740471 1286 0 TBC weekly  
10161 10161 Switzerland Switzerland 0 2016-10-10 2016-10-16 7 2016 41 8740471 1271 0 TBC weekly  
10162 10162 Switzerland Switzerland 0 2016-10-17 2016-10-23 7 2016 42 8740471 1277 0 TBC weekly  
10163 10163 Switzerland Switzerland 0 2016-10-24 2016-10-30 7 2016 43 8740471 1230 0 TBC weekly  
10164 10164 Switzerland Switzerland 0 2016-10-31 2016-11-06 7 2016 44 8740471 1313 0 TBC weekly  
10165 10165 Switzerland Switzerland 0 2016-11-07 2016-11-13 7 2016 45 8740471 1286 0 TBC weekly  
10166 10166 Switzerland Switzerland 0 2016-11-14 2016-11-20 7 2016 46 8740471 1353 0 TBC weekly  
10167 10167 Switzerland Switzerland 0 2016-11-21 2016-11-27 7 2016 47 8740471 1193 0 TBC weekly  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);