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

2,100 rows where country = "Spain"

View and edit SQL

Suggested facets: region, region_code, year, population, start_date (date), end_date (date)

country

  • Spain · 2,100

cadence

Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
13089 Spain Andalucía 1 2018-06-11 2018-06-17 2018 24 8405294 1276 0 1209.5 weekly  
13090 Spain Andalucía 1 2018-06-18 2018-06-24 2018 25 8405294 1300 0 1213.5 weekly  
13091 Spain Andalucía 1 2018-06-25 2018-07-01 2018 26 8405294 1226 0 1244 weekly  
13092 Spain Andalucía 1 2018-07-02 2018-07-08 2018 27 8405294 1215 0 1261 weekly  
13093 Spain Andalucía 1 2018-07-09 2018-07-15 2018 28 8405294 1208 0 1244 weekly  
13094 Spain Andalucía 1 2018-07-16 2018-07-22 2018 29 8405294 1206 0 1243 weekly  
13095 Spain Andalucía 1 2018-07-23 2018-07-29 2018 30 8405294 1155 0 1237 weekly  
13096 Spain Andalucía 1 2018-07-30 2018-08-05 2018 31 8405294 1216 0 1231 weekly  
13097 Spain Andalucía 1 2018-08-06 2018-08-12 2018 32 8405294 1352 0 1240 weekly  
13098 Spain Andalucía 1 2018-08-13 2018-08-19 2018 33 8405294 1225 0 1229 weekly  
13099 Spain Andalucía 1 2018-08-20 2018-08-26 2018 34 8405294 1181 0 1206 weekly  
13100 Spain Andalucía 1 2018-08-27 2018-09-02 2018 35 8405294 1182 0 1207 weekly  
13101 Spain Andalucía 1 2018-09-03 2018-09-09 2018 36 8405294 1184 0 1177 weekly  
13102 Spain Andalucía 1 2018-09-10 2018-09-16 2018 37 8405294 1162 0 1156 weekly  
13103 Spain Andalucía 1 2018-09-17 2018-09-23 2018 38 8405294 1181 0 1157 weekly  
13104 Spain Andalucía 1 2018-09-24 2018-09-30 2018 39 8405294 1220 0 1177 weekly  
13105 Spain Andalucía 1 2018-10-01 2018-10-07 2018 40 8405294 1242 0 1188 weekly  
13106 Spain Andalucía 1 2018-10-08 2018-10-14 2018 41 8405294 1201 0 1199 weekly  
13107 Spain Andalucía 1 2018-10-15 2018-10-21 2018 42 8405294 1188 0 1217 weekly  
13108 Spain Andalucía 1 2018-10-22 2018-10-28 2018 43 8405294 1286 0 1230 weekly  
13109 Spain Andalucía 1 2018-10-29 2018-11-04 2018 44 8405294 1269 0 1227 weekly  
13110 Spain Andalucía 1 2018-11-05 2018-11-11 2018 45 8405294 1417 0 1267 weekly  
13111 Spain Andalucía 1 2018-11-12 2018-11-18 2018 46 8405294 1340 0 1312 weekly  
13112 Spain Andalucía 1 2018-11-19 2018-11-25 2018 47 8405294 1362 0 1330 weekly  
13113 Spain Andalucía 1 2018-11-26 2018-12-02 2018 48 8405294 1472 0 1379 weekly  
13114 Spain Andalucía 1 2018-12-03 2018-12-09 2018 49 8405294 1387 0 1404 weekly  
13115 Spain Andalucía 1 2018-12-10 2018-12-16 2018 50 8405294 1494 0 1430 weekly  
13116 Spain Andalucía 1 2018-12-17 2018-12-23 2018 51 8405294 1443 0 1493 weekly  
13117 Spain Andalucía 1 2018-12-24 2018-12-30 2018 52 8405294 1476 0 1516 weekly  
13118 Spain Andalucía 1 2019-01-01 2019-01-07 2019 1 8405294 1634 0 1546 weekly  
13119 Spain Andalucía 1 2019-01-08 2019-01-14 2019 2 8405294 1734 0 1614 weekly  
13120 Spain Andalucía 1 2019-01-15 2019-01-21 2019 3 8405294 1801 0 1600 weekly  
13121 Spain Andalucía 1 2019-01-22 2019-01-28 2019 4 8405294 1685 0 1640 weekly  
13122 Spain Andalucía 1 2019-01-29 2019-02-04 2019 5 8405294 1657 0 1639 weekly  
13123 Spain Andalucía 1 2019-02-05 2019-02-11 2019 6 8405294 1604 0 1662 weekly  
13124 Spain Andalucía 1 2019-02-12 2019-02-18 2019 7 8405294 1582 0 1616 weekly  
13125 Spain Andalucía 1 2019-02-19 2019-02-25 2019 8 8405294 1518 0 1589 weekly  
13126 Spain Andalucía 1 2019-02-26 2019-03-04 2019 9 8405294 1556 0 1520 weekly  
13127 Spain Andalucía 1 2019-03-05 2019-03-11 2019 10 8405294 1460 0 1481 weekly  
13128 Spain Andalucía 1 2019-03-12 2019-03-18 2019 11 8405294 1357 0 1458 weekly  
13129 Spain Andalucía 1 2019-03-19 2019-03-25 2019 12 8405294 1349 0 1421 weekly  
13130 Spain Andalucía 1 2019-03-26 2019-04-01 2019 13 8405294 1386 0 1410 weekly  
13131 Spain Andalucía 1 2019-04-02 2019-04-08 2019 14 8405294 1349 0 1377 weekly  
13132 Spain Andalucía 1 2019-04-09 2019-04-15 2019 15 8405294 1392 0 1341 weekly  
13133 Spain Andalucía 1 2019-04-16 2019-04-22 2019 16 8405294 1333 0 1315 weekly  
13134 Spain Andalucía 1 2019-04-23 2019-04-29 2019 17 8405294 1335 0 1288 weekly  
13135 Spain Andalucía 1 2019-04-30 2019-05-06 2019 18 8405294 1381 0 1277 weekly  
13136 Spain Andalucía 1 2019-05-07 2019-05-13 2019 19 8405294 1335 0 1285 weekly  
13137 Spain Andalucía 1 2019-05-14 2019-05-20 2019 20 8405294 1266 0 1274 weekly  
13138 Spain Andalucía 1 2019-05-21 2019-05-27 2019 21 8405294 1268 0 1244 weekly  
13139 Spain Andalucía 1 2019-05-28 2019-06-03 2019 22 8405294 1345 0 1213 weekly  
13140 Spain Andalucía 1 2019-06-04 2019-06-10 2019 23 8405294 1204 0 1208 weekly  
13141 Spain Andalucía 1 2019-06-11 2019-06-17 2019 24 8405294 1169 0 1218 weekly  
13142 Spain Andalucía 1 2019-06-18 2019-06-24 2019 25 8405294 1196 0 1220 weekly  
13143 Spain Andalucía 1 2019-06-25 2019-07-01 2019 26 8405294 1205 0 1239 weekly  
13144 Spain Andalucía 1 2019-07-02 2019-07-08 2019 27 8405294 1243 0 1259 weekly  
13145 Spain Andalucía 1 2019-07-09 2019-07-15 2019 28 8405294 1202 0 1242 weekly  
13146 Spain Andalucía 1 2019-07-16 2019-07-22 2019 29 8405294 1193 0 1237 weekly  
13147 Spain Andalucía 1 2019-07-23 2019-07-29 2019 30 8405294 1252 0 1220 weekly  
13148 Spain Andalucía 1 2019-07-30 2019-08-05 2019 31 8405294 1195 0 1223.5 weekly  
13149 Spain Andalucía 1 2019-08-06 2019-08-12 2019 32 8405294 1223 0 1255.5 weekly  
13150 Spain Andalucía 1 2019-08-13 2019-08-19 2019 33 8405294 1211 0 1229.5 weekly  
13151 Spain Andalucía 1 2019-08-20 2019-08-26 2019 34 8405294 1134 0 1209.5 weekly  
13152 Spain Andalucía 1 2019-08-27 2019-09-02 2019 35 8405294 1182 0 1205 weekly  
13153 Spain Andalucía 1 2019-09-03 2019-09-09 2019 36 8405294 1240 0 1177.5 weekly  
13154 Spain Andalucía 1 2019-09-10 2019-09-16 2019 37 8405294 1177 0 1157 weekly  
13155 Spain Andalucía 1 2019-09-17 2019-09-23 2019 38 8405294 1152 0 1158.5 weekly  
13156 Spain Andalucía 1 2019-09-24 2019-09-30 2019 39 8405294 1099 0 1178.5 weekly  
13157 Spain Andalucía 1 2019-10-01 2019-10-07 2019 40 8405294 1186 0 1189 weekly  
13158 Spain Andalucía 1 2019-10-08 2019-10-14 2019 41 8405294 1303 0 1199.5 weekly  
13159 Spain Andalucía 1 2019-10-15 2019-10-21 2019 42 8405294 1180 0 1207.5 weekly  
13160 Spain Andalucía 1 2019-10-22 2019-10-28 2019 43 8405294 1295 0 1235 weekly  
13161 Spain Andalucía 1 2019-10-29 2019-11-04 2019 44 8405294 1343 0 1231 weekly  
13162 Spain Andalucía 1 2019-11-05 2019-11-11 2019 45 8405294 1278 0 1271.5 weekly  
13163 Spain Andalucía 1 2019-11-12 2019-11-18 2019 46 8405294 1338 0 1314.5 weekly  
13164 Spain Andalucía 1 2019-11-19 2019-11-25 2019 47 8405294 1381 0 1333 weekly  
13165 Spain Andalucía 1 2019-11-26 2019-12-02 2019 48 8405294 1416 0 1387 weekly  
13166 Spain Andalucía 1 2019-12-03 2019-12-09 2019 49 8405294 1345 0 1406.5 weekly  
13167 Spain Andalucía 1 2019-12-10 2019-12-16 2019 50 8405294 1428 0 1429.5 weekly  
13168 Spain Andalucía 1 2019-12-17 2019-12-23 2019 51 8405294 1392 0 1479.5 weekly  
13169 Spain Andalucía 1 2019-12-24 2019-12-30 2019 52 8405294 1442 0 1503 weekly  
13170 Spain Andalucía 1 2020-01-01 2020-01-07 2020 1 8405294 1542 0 1554 weekly  
13171 Spain Andalucía 1 2020-01-08 2020-01-14 2020 2 8405294 1663 0 1645.5 weekly  
13172 Spain Andalucía 1 2020-01-15 2020-01-21 2020 3 8405294 1812 0 1627.5 weekly  
13173 Spain Andalucía 1 2020-01-22 2020-01-28 2020 4 8405294 1759 0 1654 weekly  
13174 Spain Andalucía 1 2020-01-29 2020-02-04 2020 5 8405294 1796 0 1635.5 weekly  
13175 Spain Andalucía 1 2020-02-05 2020-02-11 2020 6 8405294 1601 0 1644.5 weekly  
13176 Spain Andalucía 1 2020-02-12 2020-02-18 2020 7 8405294 1512 0 1611 weekly  
13177 Spain Andalucía 1 2020-02-19 2020-02-25 2020 8 8405294 1430 0 1570 weekly  
13178 Spain Andalucía 1 2020-02-26 2020-03-03 2020 9 8405294 1393 0 1535 weekly  
13179 Spain Andalucía 1 2020-03-04 2020-03-10 2020 10 8405294 1363 0 1475.5 weekly  
13180 Spain Andalucía 1 2020-03-11 2020-03-17 2020 11 8405294 1548 11 1448 weekly  
13181 Spain Andalucía 1 2020-03-18 2020-03-24 2020 12 8405294 1745 76 1418 weekly  
13182 Spain Andalucía 1 2020-03-25 2020-03-31 2020 13 8405294 1820 161 1406.5 weekly  
13183 Spain Andalucía 1 2020-04-01 2020-04-07 2020 14 8405294 1838 280 1371 weekly  
13184 Spain Andalucía 1 2020-04-08 2020-04-14 2020 15 8405294 1664 308 1343.5 weekly  
13185 Spain Andalucía 1 2020-04-15 2020-04-21 2020 16 8405294 1464 181 1314 weekly  
13186 Spain Andalucía 1 2020-04-22 2020-04-28 2020 17 8405294 1345 151 1293.5 weekly  
13187 Spain Andalucía 1 2020-04-29 2020-05-05 2020 18 8405294 1252 99 1285 weekly  
13188 Spain Andalucía 1 2020-05-06 2020-05-12 2020 19 8405294 1252 59 1291 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 311.64ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette