economist_excess_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

960 rows where country = "Spain"

View and edit SQL

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

country

  • Spain · 960

cadence

Link rowid ▼ country region region_code start_date end_date year month population total_deaths covid_deaths expected_deaths excess_deaths non_covid_deaths covid_deaths_per_100k excess_deaths_per_100k excess_deaths_pct_change cadence week
690 Spain Andalucía 1 2020-01-01 2020-01-07 2020   8405294 1542 0 1554.0 -12.0 1542       weekly 1
691 Spain Andalucía 1 2020-01-08 2020-01-14 2020   8405294 1663 0 1645.5 17.5 1663       weekly 2
692 Spain Andalucía 1 2020-01-15 2020-01-21 2020   8405294 1812 0 1627.5 184.5 1812       weekly 3
693 Spain Andalucía 1 2020-01-22 2020-01-28 2020   8405294 1759 0 1654.0 105.0 1759       weekly 4
694 Spain Andalucía 1 2020-01-29 2020-02-04 2020   8405294 1796 0 1635.5 160.5 1796       weekly 5
695 Spain Andalucía 1 2020-02-05 2020-02-11 2020   8405294 1601 0 1644.5 -43.5 1601       weekly 6
696 Spain Andalucía 1 2020-02-12 2020-02-18 2020   8405294 1512 0 1611.0 -99.0 1512       weekly 7
697 Spain Andalucía 1 2020-02-19 2020-02-25 2020   8405294 1430 0 1570.0 -140.0 1430       weekly 8
698 Spain Andalucía 1 2020-02-26 2020-03-03 2020   8405294 1393 0 1535.0 -142.0 1393       weekly 9
699 Spain Andalucía 1 2020-03-04 2020-03-10 2020   8405294 1363 0 1475.5 -112.5 1363       weekly 10
700 Spain Andalucía 1 2020-03-11 2020-03-17 2020   8405294 1548 11 1448.0 100.0 1537       weekly 11
701 Spain Andalucía 1 2020-03-18 2020-03-24 2020   8405294 1745 76 1418.0 327.0 1669       weekly 12
702 Spain Andalucía 1 2020-03-25 2020-03-31 2020   8405294 1820 161 1406.5 413.5 1659       weekly 13
703 Spain Andalucía 1 2020-04-01 2020-04-07 2020   8405294 1838 280 1371.0 467.0 1558       weekly 14
704 Spain Andalucía 1 2020-04-08 2020-04-14 2020   8405294 1664 308 1343.5 320.5 1356       weekly 15
705 Spain Andalucía 1 2020-04-15 2020-04-21 2020   8405294 1464 181 1314.0 150.0 1283       weekly 16
706 Spain Andalucía 1 2020-04-22 2020-04-28 2020   8405294 1345 151 1293.5 51.5 1194       weekly 17
707 Spain Andalucía 1 2020-04-29 2020-05-05 2020   8405294 1252 99 1285.0 -33.0 1153       weekly 18
708 Spain Andalucía 1 2020-05-06 2020-05-12 2020   8405294 1252 59 1291.0 -39.0 1193       weekly 19
709 Spain Andalucía 1 2020-05-13 2020-05-19 2020   8405294 1219 41 1270.0 -51.0 1178       weekly 20
710 Spain Andalucía 1 2020-05-20 2020-05-26 2020   8405294 1378 24 1250.5 127.5 1354       weekly 21
711 Spain Andalucía 1 2020-05-27 2020-06-02 2020   8405294 1283 NA 1242.0 41.0 NA       weekly 22
712 Spain Andalucía 1 2020-06-03 2020-06-09 2020   8405294 1185 NA 1197.0 -12.0 NA       weekly 23
713 Spain Andalucía 1 2020-06-10 2020-06-16 2020   8405294 1183 NA 1197.0 -14.0 NA       weekly 24
714 Spain Aragón 2 2020-01-01 2020-01-07 2020   1316064 239 0 241.0 -2.0 239       weekly 1
715 Spain Aragón 2 2020-01-08 2020-01-14 2020   1316064 282 0 250.0 32.0 282       weekly 2
716 Spain Aragón 2 2020-01-15 2020-01-21 2020   1316064 265 0 255.5 9.5 265       weekly 3
717 Spain Aragón 2 2020-01-22 2020-01-28 2020   1316064 266 0 242.0 24.0 266       weekly 4
718 Spain Aragón 2 2020-01-29 2020-02-04 2020   1316064 259 0 254.5 4.5 259       weekly 5
719 Spain Aragón 2 2020-02-05 2020-02-11 2020   1316064 259 0 249.75 9.25 259       weekly 6
720 Spain Aragón 2 2020-02-12 2020-02-18 2020   1316064 212 0 245.75 -33.75 212       weekly 7
721 Spain Aragón 2 2020-02-19 2020-02-25 2020   1316064 228 0 237.0 -9.0 228       weekly 8
722 Spain Aragón 2 2020-02-26 2020-03-03 2020   1316064 230 0 231.5 -1.5 230       weekly 9
723 Spain Aragón 2 2020-03-04 2020-03-10 2020   1316064 209 4 227.0 -18.0 205       weekly 10
724 Spain Aragón 2 2020-03-11 2020-03-17 2020   1316064 250 8 219.25 30.75 242       weekly 11
725 Spain Aragón 2 2020-03-18 2020-03-24 2020   1316064 277 25 214.25 62.75 252       weekly 12
726 Spain Aragón 2 2020-03-25 2020-03-31 2020   1316064 432 101 214.0 218.0 331       weekly 13
727 Spain Aragón 2 2020-04-01 2020-04-07 2020   1316064 458 174 211.75 246.25 284       weekly 14
728 Spain Aragón 2 2020-04-08 2020-04-14 2020   1316064 405 180 199.75 205.25 225       weekly 15
729 Spain Aragón 2 2020-04-15 2020-04-21 2020   1316064 328 151 202.25 125.75 177       weekly 16
730 Spain Aragón 2 2020-04-22 2020-04-28 2020   1316064 245 92 191.0 54.0 153       weekly 17
731 Spain Aragón 2 2020-04-29 2020-05-05 2020   1316064 260 35 200.0 60.0 225       weekly 18
732 Spain Aragón 2 2020-05-06 2020-05-12 2020   1316064 229 58 200.0 29.0 171       weekly 19
733 Spain Aragón 2 2020-05-13 2020-05-19 2020   1316064 188 15 198.0 -10.0 173       weekly 20
734 Spain Aragón 2 2020-05-20 2020-05-26 2020   1316064 163 15 195.25 -32.25 148       weekly 21
735 Spain Aragón 2 2020-05-27 2020-06-02 2020   1316064 183 NA 193.5 -10.5 NA       weekly 22
736 Spain Aragón 2 2020-06-03 2020-06-09 2020   1316064 172 NA 197.25 -25.25 NA       weekly 23
737 Spain Aragón 2 2020-06-10 2020-06-16 2020   1316064 174 NA 193.75 -19.75 NA       weekly 24
738 Spain Asturias 3 2020-01-01 2020-01-07 2020   1024381 288 0 310.0 -22.0 288       weekly 1
739 Spain Asturias 3 2020-01-08 2020-01-14 2020   1024381 309 0 322.5 -13.5 309       weekly 2
740 Spain Asturias 3 2020-01-15 2020-01-21 2020   1024381 333 0 317.0 16.0 333       weekly 3
741 Spain Asturias 3 2020-01-22 2020-01-28 2020   1024381 332 0 301.0 31.0 332       weekly 4
742 Spain Asturias 3 2020-01-29 2020-02-04 2020   1024381 314 0 292.5 21.5 314       weekly 5
743 Spain Asturias 3 2020-02-05 2020-02-11 2020   1024381 261 0 297.0 -36.0 261       weekly 6
744 Spain Asturias 3 2020-02-12 2020-02-18 2020   1024381 285 0 296.0 -11.0 285       weekly 7
745 Spain Asturias 3 2020-02-19 2020-02-25 2020   1024381 230 0 295.5 -65.5 230       weekly 8
746 Spain Asturias 3 2020-02-26 2020-03-03 2020   1024381 256 0 288.0 -32.0 256       weekly 9
747 Spain Asturias 3 2020-03-04 2020-03-10 2020   1024381 246 0 285.0 -39.0 246       weekly 10
748 Spain Asturias 3 2020-03-11 2020-03-17 2020   1024381 269 2 260.5 8.5 267       weekly 11
749 Spain Asturias 3 2020-03-18 2020-03-24 2020   1024381 319 24 266.5 52.5 295       weekly 12
750 Spain Asturias 3 2020-03-25 2020-03-31 2020   1024381 339 40 252.5 86.5 299       weekly 13
751 Spain Asturias 3 2020-04-01 2020-04-07 2020   1024381 307 35 258.5 48.5 272       weekly 14
752 Spain Asturias 3 2020-04-08 2020-04-14 2020   1024381 347 64 249.5 97.5 283       weekly 15
753 Spain Asturias 3 2020-04-15 2020-04-21 2020   1024381 290 38 249.0 41.0 252       weekly 16
754 Spain Asturias 3 2020-04-22 2020-04-28 2020   1024381 314 49 245.0 69.0 265       weekly 17
755 Spain Asturias 3 2020-04-29 2020-05-05 2020   1024381 257 23 250.5 6.5 234       weekly 18
756 Spain Asturias 3 2020-05-06 2020-05-12 2020   1024381 232 15 248.5 -16.5 217       weekly 19
757 Spain Asturias 3 2020-05-13 2020-05-19 2020   1024381 249 13 240.0 9.0 236       weekly 20
758 Spain Asturias 3 2020-05-20 2020-05-26 2020   1024381 235 5 246.5 -11.5 230       weekly 21
759 Spain Asturias 3 2020-05-27 2020-06-02 2020   1024381 267 NA 243.0 24.0 NA       weekly 22
760 Spain Asturias 3 2020-06-03 2020-06-09 2020   1024381 232 NA 238.0 -6.0 NA       weekly 23
761 Spain Asturias 3 2020-06-10 2020-06-16 2020   1024381 229 NA 241.5 -12.5 NA       weekly 24
762 Spain Balears, Illes 4 2020-01-01 2020-01-07 2020   1176627 151 0 168.5 -17.5 151       weekly 1
763 Spain Balears, Illes 4 2020-01-08 2020-01-14 2020   1176627 173 0 176.5 -3.5 173       weekly 2
764 Spain Balears, Illes 4 2020-01-15 2020-01-21 2020   1176627 178 0 168.5 9.5 178       weekly 3
765 Spain Balears, Illes 4 2020-01-22 2020-01-28 2020   1176627 172 0 174.0 -2.0 172       weekly 4
766 Spain Balears, Illes 4 2020-01-29 2020-02-04 2020   1176627 175 0 186.5 -11.5 175       weekly 5
767 Spain Balears, Illes 4 2020-02-05 2020-02-11 2020   1176627 178 0 184.5 -6.5 178       weekly 6
768 Spain Balears, Illes 4 2020-02-12 2020-02-18 2020   1176627 160 0 177.5 -17.5 160       weekly 7
769 Spain Balears, Illes 4 2020-02-19 2020-02-25 2020   1176627 164 0 180.0 -16.0 164       weekly 8
770 Spain Balears, Illes 4 2020-02-26 2020-03-03 2020   1176627 158 0 177.0 -19.0 158       weekly 9
771 Spain Balears, Illes 4 2020-03-04 2020-03-10 2020   1176627 175 0 157.5 17.5 175       weekly 10
772 Spain Balears, Illes 4 2020-03-11 2020-03-17 2020   1176627 185 1 160.0 25.0 184       weekly 11
773 Spain Balears, Illes 4 2020-03-18 2020-03-24 2020   1176627 180 9 163.5 16.5 171       weekly 12
774 Spain Balears, Illes 4 2020-03-25 2020-03-31 2020   1176627 220 32 160.5 59.5 188       weekly 13
775 Spain Balears, Illes 4 2020-04-01 2020-04-07 2020   1176627 174 42 154.0 20.0 132       weekly 14
776 Spain Balears, Illes 4 2020-04-08 2020-04-14 2020   1176627 199 34 148.5 50.5 165       weekly 15
777 Spain Balears, Illes 4 2020-04-15 2020-04-21 2020   1176627 164 43 147.0 17.0 121       weekly 16
778 Spain Balears, Illes 4 2020-04-22 2020-04-28 2020   1176627 174 20 151.0 23.0 154       weekly 17
779 Spain Balears, Illes 4 2020-04-29 2020-05-05 2020   1176627 129 17 142.0 -13.0 112       weekly 18
780 Spain Balears, Illes 4 2020-05-06 2020-05-12 2020   1176627 161 12 145.0 16.0 149       weekly 19
781 Spain Balears, Illes 4 2020-05-13 2020-05-19 2020   1176627 128 9 148.0 -20.0 119       weekly 20
782 Spain Balears, Illes 4 2020-05-20 2020-05-26 2020   1176627 138 3 146.5 -8.5 135       weekly 21
783 Spain Balears, Illes 4 2020-05-27 2020-06-02 2020   1176627 145 NA 139.5 5.5 NA       weekly 22
784 Spain Balears, Illes 4 2020-06-03 2020-06-09 2020   1176627 109 NA 141.5 -32.5 NA       weekly 23
785 Spain Balears, Illes 4 2020-06-10 2020-06-16 2020   1176627 140 NA 148.0 -8.0 NA       weekly 24
786 Spain Canarias 5 2020-01-01 2020-01-07 2020   2188626 332 0 347.0 -15.0 332       weekly 1
787 Spain Canarias 5 2020-01-08 2020-01-14 2020   2188626 356 0 351.5 4.5 356       weekly 2
788 Spain Canarias 5 2020-01-15 2020-01-21 2020   2188626 414 0 357.5 56.5 414       weekly 3
789 Spain Canarias 5 2020-01-22 2020-01-28 2020   2188626 394 0 356.75 37.25 394       weekly 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_excess_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [month] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] FLOAT,
   [excess_deaths] FLOAT,
   [non_covid_deaths] INTEGER,
   [covid_deaths_per_100k] FLOAT,
   [excess_deaths_per_100k] FLOAT,
   [excess_deaths_pct_change] FLOAT,
   [cadence] TEXT
, [week] INTEGER);
Powered by Datasette · Query took 132.292ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette