economist_historical_deaths

⚠️ 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

545 rows where country = "Switzerland"

View and edit SQL

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

country

  • Switzerland · 545

cadence

Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
12503 Switzerland Switzerland 0 2010-01-04 2010-01-10 2010 1 8570146 1293 0 TBC weekly  
12504 Switzerland Switzerland 0 2010-01-11 2010-01-17 2010 2 8570146 1269 0 TBC weekly  
12505 Switzerland Switzerland 0 2010-01-18 2010-01-24 2010 3 8570146 1196 0 TBC weekly  
12506 Switzerland Switzerland 0 2010-01-25 2010-01-31 2010 4 8570146 1246 0 TBC weekly  
12507 Switzerland Switzerland 0 2010-02-01 2010-02-07 2010 5 8570146 1285 0 TBC weekly  
12508 Switzerland Switzerland 0 2010-02-08 2010-02-14 2010 6 8570146 1236 0 TBC weekly  
12509 Switzerland Switzerland 0 2010-02-15 2010-02-21 2010 7 8570146 1421 0 TBC weekly  
12510 Switzerland Switzerland 0 2010-02-22 2010-02-28 2010 8 8570146 1315 0 TBC weekly  
12511 Switzerland Switzerland 0 2010-03-01 2010-03-07 2010 9 8570146 1298 0 TBC weekly  
12512 Switzerland Switzerland 0 2010-03-08 2010-03-14 2010 10 8570146 1352 0 TBC weekly  
12513 Switzerland Switzerland 0 2010-03-15 2010-03-21 2010 11 8570146 1310 0 TBC weekly  
12514 Switzerland Switzerland 0 2010-03-22 2010-03-28 2010 12 8570146 1248 0 TBC weekly  
12515 Switzerland Switzerland 0 2010-03-29 2010-04-04 2010 13 8570146 1211 0 TBC weekly  
12516 Switzerland Switzerland 0 2010-04-05 2010-04-11 2010 14 8570146 1150 0 TBC weekly  
12517 Switzerland Switzerland 0 2010-04-12 2010-04-18 2010 15 8570146 1145 0 TBC weekly  
12518 Switzerland Switzerland 0 2010-04-19 2010-04-25 2010 16 8570146 1197 0 TBC weekly  
12519 Switzerland Switzerland 0 2010-04-26 2010-05-02 2010 17 8570146 1140 0 TBC weekly  
12520 Switzerland Switzerland 0 2010-05-03 2010-05-09 2010 18 8570146 1137 0 TBC weekly  
12521 Switzerland Switzerland 0 2010-05-10 2010-05-16 2010 19 8570146 1164 0 TBC weekly  
12522 Switzerland Switzerland 0 2010-05-17 2010-05-23 2010 20 8570146 1178 0 TBC weekly  
12523 Switzerland Switzerland 0 2010-05-24 2010-05-30 2010 21 8570146 1152 0 TBC weekly  
12524 Switzerland Switzerland 0 2010-05-31 2010-06-06 2010 22 8570146 1100 0 TBC weekly  
12525 Switzerland Switzerland 0 2010-06-07 2010-06-13 2010 23 8570146 1135 0 TBC weekly  
12526 Switzerland Switzerland 0 2010-06-14 2010-06-20 2010 24 8570146 1079 0 TBC weekly  
12527 Switzerland Switzerland 0 2010-06-21 2010-06-27 2010 25 8570146 1075 0 TBC weekly  
12528 Switzerland Switzerland 0 2010-06-28 2010-07-04 2010 26 8570146 1145 0 TBC weekly  
12529 Switzerland Switzerland 0 2010-07-05 2010-07-11 2010 27 8570146 1105 0 TBC weekly  
12530 Switzerland Switzerland 0 2010-07-12 2010-07-18 2010 28 8570146 1120 0 TBC weekly  
12531 Switzerland Switzerland 0 2010-07-19 2010-07-25 2010 29 8570146 1040 0 TBC weekly  
12532 Switzerland Switzerland 0 2010-07-26 2010-08-01 2010 30 8570146 1099 0 TBC weekly  
12533 Switzerland Switzerland 0 2010-08-02 2010-08-08 2010 31 8570146 1101 0 TBC weekly  
12534 Switzerland Switzerland 0 2010-08-09 2010-08-15 2010 32 8570146 1083 0 TBC weekly  
12535 Switzerland Switzerland 0 2010-08-16 2010-08-22 2010 33 8570146 1053 0 TBC weekly  
12536 Switzerland Switzerland 0 2010-08-23 2010-08-29 2010 34 8570146 1107 0 TBC weekly  
12537 Switzerland Switzerland 0 2010-08-30 2010-09-05 2010 35 8570146 1114 0 TBC weekly  
12538 Switzerland Switzerland 0 2010-09-06 2010-09-12 2010 36 8570146 1190 0 TBC weekly  
12539 Switzerland Switzerland 0 2010-09-13 2010-09-19 2010 37 8570146 1121 0 TBC weekly  
12540 Switzerland Switzerland 0 2010-09-20 2010-09-26 2010 38 8570146 1182 0 TBC weekly  
12541 Switzerland Switzerland 0 2010-09-27 2010-10-03 2010 39 8570146 1220 0 TBC weekly  
12542 Switzerland Switzerland 0 2010-10-04 2010-10-10 2010 40 8570146 1210 0 TBC weekly  
12543 Switzerland Switzerland 0 2010-10-11 2010-10-17 2010 41 8570146 1249 0 TBC weekly  
12544 Switzerland Switzerland 0 2010-10-18 2010-10-24 2010 42 8570146 1159 0 TBC weekly  
12545 Switzerland Switzerland 0 2010-10-25 2010-10-31 2010 43 8570146 1217 0 TBC weekly  
12546 Switzerland Switzerland 0 2010-11-01 2010-11-07 2010 44 8570146 1237 0 TBC weekly  
12547 Switzerland Switzerland 0 2010-11-08 2010-11-14 2010 45 8570146 1223 0 TBC weekly  
12548 Switzerland Switzerland 0 2010-11-15 2010-11-21 2010 46 8570146 1175 0 TBC weekly  
12549 Switzerland Switzerland 0 2010-11-22 2010-11-28 2010 47 8570146 1197 0 TBC weekly  
12550 Switzerland Switzerland 0 2010-11-29 2010-12-05 2010 48 8570146 1215 0 TBC weekly  
12551 Switzerland Switzerland 0 2010-12-06 2010-12-12 2010 49 8570146 1273 0 TBC weekly  
12552 Switzerland Switzerland 0 2010-12-13 2010-12-19 2010 50 8570146 1283 0 TBC weekly  
12553 Switzerland Switzerland 0 2010-12-20 2010-12-26 2010 51 8570146 1269 0 TBC weekly  
12554 Switzerland Switzerland 0 2010-12-27 2011-01-02 2010 52 8570146 1319 0 TBC weekly  
12555 Switzerland Switzerland 0 2011-01-03 2011-01-09 2011 1 8570146 1354 0 TBC weekly  
12556 Switzerland Switzerland 0 2011-01-10 2011-01-16 2011 2 8570146 1290 0 TBC weekly  
12557 Switzerland Switzerland 0 2011-01-17 2011-01-23 2011 3 8570146 1246 0 TBC weekly  
12558 Switzerland Switzerland 0 2011-01-24 2011-01-30 2011 4 8570146 1294 0 TBC weekly  
12559 Switzerland Switzerland 0 2011-01-31 2011-02-06 2011 5 8570146 1268 0 TBC weekly  
12560 Switzerland Switzerland 0 2011-02-07 2011-02-13 2011 6 8570146 1247 0 TBC weekly  
12561 Switzerland Switzerland 0 2011-02-14 2011-02-20 2011 7 8570146 1261 0 TBC weekly  
12562 Switzerland Switzerland 0 2011-02-21 2011-02-27 2011 8 8570146 1273 0 TBC weekly  
12563 Switzerland Switzerland 0 2011-02-28 2011-03-06 2011 9 8570146 1246 0 TBC weekly  
12564 Switzerland Switzerland 0 2011-03-07 2011-03-13 2011 10 8570146 1283 0 TBC weekly  
12565 Switzerland Switzerland 0 2011-03-14 2011-03-20 2011 11 8570146 1245 0 TBC weekly  
12566 Switzerland Switzerland 0 2011-03-21 2011-03-27 2011 12 8570146 1182 0 TBC weekly  
12567 Switzerland Switzerland 0 2011-03-28 2011-04-03 2011 13 8570146 1276 0 TBC weekly  
12568 Switzerland Switzerland 0 2011-04-04 2011-04-10 2011 14 8570146 1219 0 TBC weekly  
12569 Switzerland Switzerland 0 2011-04-11 2011-04-17 2011 15 8570146 1068 0 TBC weekly  
12570 Switzerland Switzerland 0 2011-04-18 2011-04-24 2011 16 8570146 1191 0 TBC weekly  
12571 Switzerland Switzerland 0 2011-04-25 2011-05-01 2011 17 8570146 1158 0 TBC weekly  
12572 Switzerland Switzerland 0 2011-05-02 2011-05-08 2011 18 8570146 1191 0 TBC weekly  
12573 Switzerland Switzerland 0 2011-05-09 2011-05-15 2011 19 8570146 1105 0 TBC weekly  
12574 Switzerland Switzerland 0 2011-05-16 2011-05-22 2011 20 8570146 1107 0 TBC weekly  
12575 Switzerland Switzerland 0 2011-05-23 2011-05-29 2011 21 8570146 1076 0 TBC weekly  
12576 Switzerland Switzerland 0 2011-05-30 2011-06-05 2011 22 8570146 1105 0 TBC weekly  
12577 Switzerland Switzerland 0 2011-06-06 2011-06-12 2011 23 8570146 1066 0 TBC weekly  
12578 Switzerland Switzerland 0 2011-06-13 2011-06-19 2011 24 8570146 1098 0 TBC weekly  
12579 Switzerland Switzerland 0 2011-06-20 2011-06-26 2011 25 8570146 1096 0 TBC weekly  
12580 Switzerland Switzerland 0 2011-06-27 2011-07-03 2011 26 8570146 1141 0 TBC weekly  
12581 Switzerland Switzerland 0 2011-07-04 2011-07-10 2011 27 8570146 1101 0 TBC weekly  
12582 Switzerland Switzerland 0 2011-07-11 2011-07-17 2011 28 8570146 1110 0 TBC weekly  
12583 Switzerland Switzerland 0 2011-07-18 2011-07-24 2011 29 8570146 1087 0 TBC weekly  
12584 Switzerland Switzerland 0 2011-07-25 2011-07-31 2011 30 8570146 1146 0 TBC weekly  
12585 Switzerland Switzerland 0 2011-08-01 2011-08-07 2011 31 8570146 1109 0 TBC weekly  
12586 Switzerland Switzerland 0 2011-08-08 2011-08-14 2011 32 8570146 1083 0 TBC weekly  
12587 Switzerland Switzerland 0 2011-08-15 2011-08-21 2011 33 8570146 1150 0 TBC weekly  
12588 Switzerland Switzerland 0 2011-08-22 2011-08-28 2011 34 8570146 1205 0 TBC weekly  
12589 Switzerland Switzerland 0 2011-08-29 2011-09-04 2011 35 8570146 1125 0 TBC weekly  
12590 Switzerland Switzerland 0 2011-09-05 2011-09-11 2011 36 8570146 1111 0 TBC weekly  
12591 Switzerland Switzerland 0 2011-09-12 2011-09-18 2011 37 8570146 1085 0 TBC weekly  
12592 Switzerland Switzerland 0 2011-09-19 2011-09-25 2011 38 8570146 1113 0 TBC weekly  
12593 Switzerland Switzerland 0 2011-09-26 2011-10-02 2011 39 8570146 1132 0 TBC weekly  
12594 Switzerland Switzerland 0 2011-10-03 2011-10-09 2011 40 8570146 1141 0 TBC weekly  
12595 Switzerland Switzerland 0 2011-10-10 2011-10-16 2011 41 8570146 1196 0 TBC weekly  
12596 Switzerland Switzerland 0 2011-10-17 2011-10-23 2011 42 8570146 1116 0 TBC weekly  
12597 Switzerland Switzerland 0 2011-10-24 2011-10-30 2011 43 8570146 1254 0 TBC weekly  
12598 Switzerland Switzerland 0 2011-10-31 2011-11-06 2011 44 8570146 1186 0 TBC weekly  
12599 Switzerland Switzerland 0 2011-11-07 2011-11-13 2011 45 8570146 1168 0 TBC weekly  
12600 Switzerland Switzerland 0 2011-11-14 2011-11-20 2011 46 8570146 1199 0 TBC weekly  
12601 Switzerland Switzerland 0 2011-11-21 2011-11-27 2011 47 8570146 1223 0 TBC weekly  
12602 Switzerland Switzerland 0 2011-11-28 2011-12-04 2011 48 8570146 1255 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] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [week] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] TEXT,
   [cadence] TEXT
, [month] INTEGER);
Powered by Datasette · Query took 333.019ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette