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

644 rows where country = "Britain"

View and edit SQL

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

country

  • Britain · 644

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
1261 Britain England and Wales K04000001 2020-01-04 2020-01-10 2020   59115809 14058 0 14131.2 -73.2000000000007 14058 0.0 -0.123824745424698 -0.00518002717391308 weekly 1
1262 Britain England and Wales K04000001 2020-01-11 2020-01-17 2020   59115809 12990 0 13218.6 -228.6 12990 0.0 -0.38669859021975 -0.0172938132631293 weekly 2
1263 Britain England and Wales K04000001 2020-01-18 2020-01-24 2020   59115809 11856 0 12791.8 -935.799999999999 11856 0.0 -1.58299449137201 -0.0731562407167091 weekly 3
1264 Britain England and Wales K04000001 2020-01-25 2020-01-31 2020   59115809 11612 0 12256.8 -644.799999999999 11612 0.0 -1.09074038046236 -0.0526075321454212 weekly 4
1265 Britain England and Wales K04000001 2020-02-01 2020-02-07 2020   59115809 10986 0 11903.0 -917.0 10986 0.0 -1.55119250757441 -0.0770394018314711 weekly 5
1266 Britain England and Wales K04000001 2020-02-08 2020-02-14 2020   59115809 10944 0 11741.2 -797.200000000001 10944 0.0 -1.34853944060886 -0.0678976595237285 weekly 6
1267 Britain England and Wales K04000001 2020-02-15 2020-02-21 2020   59115809 10841 0 11451.0 -610.0 10841 0.0 -1.03187287853914 -0.05327045672867 weekly 7
1268 Britain England and Wales K04000001 2020-02-22 2020-02-28 2020   59115809 10816 0 11134.8 -318.799999999999 10816 0.0 -0.539280448652913 -0.0286309587958472 weekly 8
1269 Britain England and Wales K04000001 2020-02-29 2020-03-06 2020   59115809 10895 0 11545.2 -650.200000000001 10895 0.0 -1.09987499282975 -0.0563177770848492 weekly 9
1270 Britain England and Wales K04000001 2020-03-07 2020-03-13 2020   59115809 11019 5 11202.6 -183.6 11014 0.00845797441425525 -0.310576820491453 -0.0163890525413743 weekly 10
1271 Britain England and Wales K04000001 2020-03-14 2020-03-20 2020   59115809 10645 103 10846.0 -201.0 10542 0.174234272933658 -0.340010571453061 -0.0185321777613867 weekly 11
1272 Britain England and Wales K04000001 2020-03-21 2020-03-27 2020   59115809 11141 539 9992.6 1148.4 10602 0.911769641856715 1.94262756346614 0.114925044532954 weekly 12
1273 Britain England and Wales K04000001 2020-03-28 2020-04-03 2020   59115809 16387 3475 10041.4 6345.6 12912 5.8782922179074 10.7341844886196 0.631943752863147 weekly 13
1274 Britain England and Wales K04000001 2020-04-04 2020-04-10 2020   59115809 18516 6213 10554.6 7961.4 12303 10.5098790071536 13.4674635003303 0.754306179296231 weekly 14
1275 Britain England and Wales K04000001 2020-04-11 2020-04-17 2020   59115809 22351 8758 10589.6 11761.4 13593 14.8149879840095 19.8955240551643 1.11065573770492 weekly 15
1276 Britain England and Wales K04000001 2020-04-18 2020-04-24 2020   59115809 21997 8237 10559.4 11437.6 13760 13.9336670500441 19.3477856320972 1.08316760421994 weekly 16
1277 Britain England and Wales K04000001 2020-04-25 2020-05-01 2020   59115809 17953 6035 10194.2 7758.8 11918 10.2087751180061 13.1247463770647 0.761099448706127 weekly 17
1278 Britain England and Wales K04000001 2020-05-02 2020-05-08 2020   59115809 12657 3930 9274.2 3382.8 8727 6.64796788960462 5.72232716970853 0.364753833214725 weekly 18
1279 Britain England and Wales K04000001 2020-05-09 2020-05-15 2020   59115809 14573 3810 10325.6 4247.4 10763 6.4449765036625 7.18488010542154 0.411346556132331 weekly 19
1280 Britain England and Wales K04000001 2020-05-16 2020-05-22 2020   59115809 12288 2589 9983.6 2304.4 9699 4.37953915170137 3.89811124804196 0.230818542409552 weekly 20
1281 Britain England and Wales K04000001 2020-05-23 2020-05-29 2020   59115809 9824 1822 8538.2 1285.8 8002 3.08208587655461 2.17505270036988 0.150593801972313 weekly 21
1282 Britain England and Wales K04000001 2020-05-30 2020-06-05 2020   59115809 10709 1588 9584.4 1124.6 9121 2.68625267396747 1.90236760525429 0.117336505154209 weekly 22
1283 Britain England and Wales K04000001 2020-06-06 2020-06-12 2020   59115809 9976 1114 9515.2 460.799999999999 8862 1.88443669949607 0.779486922017762 0.0484277787119556 weekly 23
1284 Britain North East E12000001 2020-01-04 2020-01-10 2020   2657909 707 0 735.2 -28.2 707 0.0 -1.06098440541042 -0.0383569096844397 weekly 1
1285 Britain North East E12000001 2020-01-11 2020-01-17 2020   2657909 647 0 697.0 -50.0 647 0.0 -1.88117802377734 -0.0717360114777619 weekly 2
1286 Britain North East E12000001 2020-01-18 2020-01-24 2020   2657909 612 0 691.2 -79.2 612 0.0 -2.9797859896633 -0.114583333333333 weekly 3
1287 Britain North East E12000001 2020-01-25 2020-01-31 2020   2657909 561 0 667.4 -106.4 561 0.0 -4.00314683459817 -0.159424632903806 weekly 4
1288 Britain North East E12000001 2020-02-01 2020-02-07 2020   2657909 564 0 639.0 -75.0 564 0.0 -2.82176703566601 -0.117370892018779 weekly 5
1289 Britain North East E12000001 2020-02-08 2020-02-14 2020   2657909 573 0 610.2 -37.2 573 0.0 -1.39959644969034 -0.0609636184857425 weekly 6
1290 Britain North East E12000001 2020-02-15 2020-02-21 2020   2657909 539 0 634.8 -95.8 539 0.0 -3.60433709355738 -0.150913673597984 weekly 7
1291 Britain North East E12000001 2020-02-22 2020-02-28 2020   2657909 572 0 583.4 -11.4 572 0.0 -0.428908589421232 -0.0195406239286938 weekly 8
1292 Britain North East E12000001 2020-02-29 2020-03-06 2020   2657909 568 0 606.6 -38.6 568 0.0 -1.45226943435611 -0.0636333663039895 weekly 9
1293 Britain North East E12000001 2020-03-07 2020-03-13 2020   2657909 590 0 572.8 17.2 590 0.0 0.647125240179406 0.0300279329608939 weekly 10
1294 Britain North East E12000001 2020-03-14 2020-03-20 2020   2657909 522 1 552.2 -30.2 521 0.0376235604755468 -1.13623152636151 -0.0546903295907281 weekly 11
1295 Britain North East E12000001 2020-03-21 2020-03-27 2020   2657909 542 15 504.4 37.6 527 0.564353407133201 1.41464587388056 0.0745440126883425 weekly 12
1296 Britain North East E12000001 2020-03-28 2020-04-03 2020   2657909 770 134 528.6 241.4 636 5.04155710372327 9.08232749879699 0.456678017404464 weekly 13
1297 Britain North East E12000001 2020-04-04 2020-04-10 2020   2657909 849 288 538.0 311.0 561 10.8355854169575 11.700927307895 0.578066914498141 weekly 14
1298 Britain North East E12000001 2020-04-11 2020-04-17 2020   2657909 1155 475 551.0 604.0 680 17.8711912258847 22.7246305272302 1.0961887477314 weekly 15
1299 Britain North East E12000001 2020-04-18 2020-04-24 2020   2657909 1103 419 558.0 545.0 684 15.7642718392541 20.504840459173 0.976702508960573 weekly 16
1300 Britain North East E12000001 2020-04-25 2020-05-01 2020   2657909 922 316 528.2 393.8 606 11.8890451102728 14.8161581152703 0.745550927678909 weekly 17
1301 Britain North East E12000001 2020-05-02 2020-05-08 2020   2657909 769 271 508.6 260.4 498 10.1959848888732 9.79717514783237 0.511993708218639 weekly 18
1302 Britain North East E12000001 2020-05-09 2020-05-15 2020   2657909 845 248 539.2 305.8 597 9.3306429979356 11.5052847934222 0.56713649851632 weekly 19
1303 Britain North East E12000001 2020-05-16 2020-05-22 2020   2657909 718 202 519.4 198.6 516 7.59995921606045 7.47203911044359 0.382364266461302 weekly 20
1304 Britain North East E12000001 2020-05-23 2020-05-29 2020   2657909 550 141 448.6 101.4 409 5.30492202705209 3.81502903222044 0.226036558181008 weekly 21
1305 Britain North East E12000001 2020-05-30 2020-06-05 2020   2657909 576 113 503.8 72.2 463 4.25146233373678 2.71642106633448 0.143310837633982 weekly 22
1306 Britain North East E12000001 2020-06-06 2020-06-12 2020   2657909 478 71 506.0 -28.0 407 2.67127279376382 -1.05345969331531 -0.0553359683794467 weekly 23
1307 Britain North West E12000002 2020-01-04 2020-01-10 2020   7292093 1932 0 1919.0 13.0 1932 0.0 0.178275290784141 0.00677436164669087 weekly 1
1308 Britain North West E12000002 2020-01-11 2020-01-17 2020   7292093 1696 0 1736.0 -40.0 1696 0.0 -0.548539356258896 -0.0230414746543779 weekly 2
1309 Britain North West E12000002 2020-01-18 2020-01-24 2020   7292093 1529 0 1704.4 -175.4 1529 0.0 -2.40534507719526 -0.10291011499648 weekly 3
1310 Britain North West E12000002 2020-01-25 2020-01-31 2020   7292093 1461 0 1604.6 -143.6 1461 0.0 -1.96925628896943 -0.0894927084631684 weekly 4
1311 Britain North West E12000002 2020-02-01 2020-02-07 2020   7292093 1529 0 1564.2 -35.2 1529 0.0 -0.482714633507829 -0.0225035161744023 weekly 5
1312 Britain North West E12000002 2020-02-08 2020-02-14 2020   7292093 1427 0 1577.0 -150.0 1427 0.0 -2.05702258597086 -0.0951173113506658 weekly 6
1313 Britain North West E12000002 2020-02-15 2020-02-21 2020   7292093 1477 0 1520.0 -43.0 1477 0.0 -0.589679807978313 -0.0282894736842105 weekly 7
1314 Britain North West E12000002 2020-02-22 2020-02-28 2020   7292093 1476 0 1472.2 3.79999999999995 1476 0.0 0.0521112388445945 0.00258117103654398 weekly 8
1315 Britain North West E12000002 2020-02-29 2020-03-06 2020   7292093 1490 0 1536.2 -46.2 1490 0.0 -0.633562956479025 -0.0300742090873585 weekly 9
1316 Britain North West E12000002 2020-03-07 2020-03-13 2020   7292093 1472 1 1504.0 -32.0 1471 0.0137134839064724 -0.438831485007117 -0.0212765957446809 weekly 10
1317 Britain North West E12000002 2020-03-14 2020-03-20 2020   7292093 1443 12 1435.6 7.40000000000009 1431 0.164561806877669 0.101479780907897 0.00515463917525771 weekly 11
1318 Britain North West E12000002 2020-03-21 2020-03-27 2020   7292093 1538 60 1329.8 208.2 1478 0.822809034388344 2.85514734932755 0.156564896976989 weekly 12
1319 Britain North West E12000002 2020-03-28 2020-04-03 2020   7292093 2137 418 1346.6 790.4 1719 5.73223627290546 10.8391376796758 0.586959750482697 weekly 13
1320 Britain North West E12000002 2020-04-04 2020-04-10 2020   7292093 2597 909 1413.8 1183.2 1688 12.4655568709834 16.2257941581381 0.836893478568397 weekly 14
1321 Britain North West E12000002 2020-04-11 2020-04-17 2020   7292093 3195 1350 1427.2 1767.8 1845 18.5132032737377 24.2426968498619 1.23864910313901 weekly 15
1322 Britain North West E12000002 2020-04-18 2020-04-24 2020   7292093 3109 1207 1425.2 1683.8 1902 16.5521750751122 23.0907642017182 1.18144821779399 weekly 16
1323 Britain North West E12000002 2020-04-25 2020-05-01 2020   7292093 2503 910 1375.0 1128.0 1593 12.4792703548899 15.4688098465009 0.820363636363636 weekly 17
1324 Britain North West E12000002 2020-05-02 2020-05-08 2020   7292093 1790 597 1228.8 561.2 1193 8.18694989216402 7.69600716831231 0.456705729166667 weekly 18
1325 Britain North West E12000002 2020-05-09 2020-05-15 2020   7292093 1992 620 1389.0 603.0 1372 8.50236002201289 8.26923079560285 0.434125269978402 weekly 19
1326 Britain North West E12000002 2020-05-16 2020-05-22 2020   7292093 1636 394 1343.6 292.4 1242 5.40311265915012 4.00982269425253 0.217624292944329 weekly 20
1327 Britain North West E12000002 2020-05-23 2020-05-29 2020   7292093 1337 282 1188.4 148.6 1055 3.86720246162522 2.0378237085018 0.125042073375968 weekly 21
1328 Britain North West E12000002 2020-05-30 2020-06-05 2020   7292093 1478 250 1288.8 189.2 1228 3.4283709766181 2.59459115510458 0.146803227808814 weekly 22
1329 Britain North West E12000002 2020-06-06 2020-06-12 2020   7292093 1374 196 1264.0 110.0 1178 2.68784284566859 1.50848322971196 0.0870253164556962 weekly 23
1330 Britain Yorkshire and The Humber E12000003 2020-01-04 2020-01-10 2020   5479615 1339 0 1400.4 -61.4000000000001 1339 0.0 -1.12051667863527 -0.0438446158240503 weekly 1
1331 Britain Yorkshire and The Humber E12000003 2020-01-11 2020-01-17 2020   5479615 1278 0 1311.4 -33.4000000000001 1278 0.0 -0.609531874045897 -0.0254689644654569 weekly 2
1332 Britain Yorkshire and The Humber E12000003 2020-01-18 2020-01-24 2020   5479615 1187 0 1249.4 -62.4000000000001 1187 0.0 -1.13876613594203 -0.0499439731070914 weekly 3
1333 Britain Yorkshire and The Humber E12000003 2020-01-25 2020-01-31 2020   5479615 1136 0 1202.0 -66.0 1136 0.0 -1.20446418224638 -0.0549084858569051 weekly 4
1334 Britain Yorkshire and The Humber E12000003 2020-02-01 2020-02-07 2020   5479615 1072 0 1164.6 -92.5999999999999 1072 0.0 -1.68989974660628 -0.0795122788940408 weekly 5
1335 Britain Yorkshire and The Humber E12000003 2020-02-08 2020-02-14 2020   5479615 1059 0 1159.8 -100.8 1059 0.0 -1.83954529652174 -0.0869115364718055 weekly 6
1336 Britain Yorkshire and The Humber E12000003 2020-02-15 2020-02-21 2020   5479615 1087 0 1126.0 -39.0 1087 0.0 -0.71172883496377 -0.0346358792184724 weekly 7
1337 Britain Yorkshire and The Humber E12000003 2020-02-22 2020-02-28 2020   5479615 1078 0 1117.0 -39.0 1078 0.0 -0.71172883496377 -0.0349149507609668 weekly 8
1338 Britain Yorkshire and The Humber E12000003 2020-02-29 2020-03-06 2020   5479615 1112 0 1119.6 -7.59999999999991 1112 0.0 -0.1386958755314 -0.00678813862093597 weekly 9
1339 Britain Yorkshire and The Humber E12000003 2020-03-07 2020-03-13 2020   5479615 1053 0 1103.0 -50.0 1053 0.0 -0.912472865338167 -0.0453309156844969 weekly 10
1340 Britain Yorkshire and The Humber E12000003 2020-03-14 2020-03-20 2020   5479615 1012 5 1072.0 -60.0 1007 0.0912472865338167 -1.0949674384058 -0.0559701492537313 weekly 11
1341 Britain Yorkshire and The Humber E12000003 2020-03-21 2020-03-27 2020   5479615 982 12 986.0 -4.0 970 0.21899348768116 -0.0729978292270534 -0.00405679513184587 weekly 12
1342 Britain Yorkshire and The Humber E12000003 2020-03-28 2020-04-03 2020   5479615 1436 174 960.4 475.6 1262 3.17540557137682 8.67944189509664 0.495210329029571 weekly 13
1343 Britain Yorkshire and The Humber E12000003 2020-04-04 2020-04-10 2020   5479615 1503 374 1035.8 467.2 1129 6.82529703272949 8.52614645371983 0.451052326703997 weekly 14
1344 Britain Yorkshire and The Humber E12000003 2020-04-11 2020-04-17 2020   5479615 1960 690 1033.0 927.0 1270 12.5921255416667 16.9172469233696 0.897386253630203 weekly 15
1345 Britain Yorkshire and The Humber E12000003 2020-04-18 2020-04-24 2020   5479615 2095 755 1010.6 1084.4 1340 13.7783402666063 19.7897115034542 1.07302592519295 weekly 16
1346 Britain Yorkshire and The Humber E12000003 2020-04-25 2020-05-01 2020   5479615 1844 647 976.6 867.4 1197 11.8073988774759 15.8295792678865 0.88818349375384 weekly 17
1347 Britain Yorkshire and The Humber E12000003 2020-05-02 2020-05-08 2020   5479615 1328 432 939.8 388.2 896 7.88376555652176 7.08443932648553 0.413066609917004 weekly 18
1348 Britain Yorkshire and The Humber E12000003 2020-05-09 2020-05-15 2020   5479615 1589 452 998.2 590.8 1137 8.24875470265703 10.7817793768358 0.591865357643759 weekly 19
1349 Britain Yorkshire and The Humber E12000003 2020-05-16 2020-05-22 2020   5479615 1236 297 957.8 278.2 939 5.42008882010871 5.07699902274156 0.290457297974525 weekly 20
1350 Britain Yorkshire and The Humber E12000003 2020-05-23 2020-05-29 2020   5479615 1046 237 834.2 211.8 809 4.32512138170291 3.86523505757247 0.253895948213857 weekly 21
1351 Britain Yorkshire and The Humber E12000003 2020-05-30 2020-06-05 2020   5479615 1090 210 959.6 130.4 880 3.8323860344203 2.37972923280194 0.135889954147562 weekly 22
1352 Britain Yorkshire and The Humber E12000003 2020-06-06 2020-06-12 2020   5479615 980 136 949.0 31.0 844 2.48192619371981 0.565733176509664 0.0326659641728135 weekly 23
1353 Britain East Midlands E12000004 2020-01-04 2020-01-10 2020   4804149 1195 0 1184.0 11.0 1195 0.0 0.228968751801828 0.00929054054054057 weekly 1
1354 Britain East Midlands E12000004 2020-01-11 2020-01-17 2020   4804149 1106 0 1117.2 -11.2 1106 0.0 -0.233131820016408 -0.0100250626566416 weekly 2
1355 Britain East Midlands E12000004 2020-01-18 2020-01-24 2020   4804149 1024 0 1090.6 -66.5999999999999 1024 0.0 -1.3863017154547 -0.0610673024023473 weekly 3
1356 Britain East Midlands E12000004 2020-01-25 2020-01-31 2020   4804149 1015 0 1027.8 -12.8 1015 0.0 -0.266436365733035 -0.0124537847830317 weekly 4
1357 Britain East Midlands E12000004 2020-02-01 2020-02-07 2020   4804149 922 0 1031.6 -109.6 922 0.0 -2.28136138158912 -0.106242729740209 weekly 5
1358 Britain East Midlands E12000004 2020-02-08 2020-02-14 2020   4804149 976 0 991.8 -15.8 976 0.0 -0.328882388951716 -0.0159306311756402 weekly 6
1359 Britain East Midlands E12000004 2020-02-15 2020-02-21 2020   4804149 924 0 952.4 -28.4 924 0.0 -0.591155686470173 -0.0298194036119277 weekly 7
1360 Britain East Midlands E12000004 2020-02-22 2020-02-28 2020   4804149 919 0 940.0 -21.0 919 0.0 -0.437122162530762 -0.0223404255319148 weekly 8

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 99.622ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette