economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
296 rows where country = "Spain" sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | 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 | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17366 | 17366 | Spain | Spain | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 47558632 | 9386 | 204 | 8115.36629213481 | 1270.63370786519 | 9182 | 0.428944213534149 | 2.67172047308928 | 0.15657133173356 | weekly | |||||||||
17367 | 17367 | Spain | Spain | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 47558632 | 9017 | 222 | 8157.76629213481 | 859.233707865189 | 8795 | 0.466792232375397 | 1.80668297579541 | 0.105327080611957 | weekly | |||||||||
17368 | 17368 | Spain | Spain | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 47558632 | 9503 | 327 | 8490.16629213481 | 1012.83370786519 | 9176 | 0.68757234228268 | 2.12965273657407 | 0.119294919912637 | weekly | |||||||||
17369 | 17369 | Spain | Spain | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 47558632 | 9780 | 311 | 8732.56629213481 | 1047.43370786519 | 9469 | 0.653929658868237 | 2.2024050394578 | 0.119945692116713 | weekly | |||||||||
17370 | 17370 | Spain | Spain | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 47558632 | 9833 | 386 | 9034.76629213481 | 798.233707865191 | 9447 | 0.811629737373438 | 1.67842024527785 | 0.0883513399300755 | weekly | |||||||||
17371 | 17371 | Spain | Spain | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 47558632 | 9929 | 529 | 9647.55374531838 | 281.446254681621 | 9400 | 1.11231122039002 | 0.591787952777155 | 0.0291728102388853 | weekly | |||||||||
17372 | 17372 | Spain | Spain | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 47558632 | 10688 | 825 | 10113.8870786517 | 574.112921348342 | 9863 | 1.73470086355722 | 1.20716870356646 | 0.056764814248335 | weekly | |||||||||
17373 | 17373 | Spain | Spain | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 47558632 | 10847 | 982 | 10348.720411985 | 498.279588015012 | 9865 | 2.06481969456144 | 1.04771640196676 | 0.0481489080947568 | weekly | |||||||||
17374 | 17374 | Spain | Spain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 47558632 | 11225 | 1225 | 10076.3870786517 | 1148.61292134834 | 10000 | 2.57576794891829 | 2.4151513049163 | 0.113990551611679 | weekly | |||||||||
17375 | 17375 | Spain | Spain | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 47558632 | 10897 | 1074 | 9971.55374531833 | 925.446254681669 | 9823 | 2.25826512419449 | 1.94590596020859 | 0.0928086312643273 | weekly | |||||||||
17376 | 17376 | Spain | Spain | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 47558632 | 10026 | 1955 | 9607.72041198499 | 418.279588015012 | 8071 | 4.11071537970226 | 0.879502984894544 | 0.0435357785279882 | weekly | |||||||||
17377 | 17377 | Spain | Spain | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 47558632 | 9274 | 2003 | 9419.22041198499 | -145.220411984994 | 7271 | 4.21164342994559 | -0.305350271607884 | -0.0154174555465558 | weekly | |||||||||
17378 | 17378 | Spain | Spain | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 47558632 | 8944 | 1412 | 9176.72041198499 | -232.720411984994 | 7532 | 2.9689668113246 | -0.489333696530619 | -0.0253598673095731 | weekly | |||||||||
17379 | 17379 | Spain | Spain | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 47558632 | 8632 | 1003 | 9091.8078651685 | -459.807865168503 | 7629 | 2.1089757165429 | -0.966823152458429 | -0.050573865174831 | weekly | |||||||||
17380 | 17380 | Spain | Spain | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 47558632 | 8505 | 722 | 8790.20786516851 | -285.20786516851 | 7783 | 1.51812608907674 | -0.599697369698334 | -0.0324460888232979 | weekly | |||||||||
17381 | 17381 | Spain | Spain | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 47558632 | 8531 | 568 | 8487.00786516852 | 43.9921348314838 | 7963 | 1.19431526121273 | 0.0925008415538189 | 0.00518346813510417 | weekly | |||||||||
17382 | 17382 | Spain | Spain | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 47558632 | 8543 | 689 | 8210.8078651685 | 332.192134831501 | 7854 | 1.44873805453445 | 0.69848967655651 | 0.0404579111198924 | weekly | |||||||||
17383 | 17383 | Spain | Spain | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 47558632 | 8509 | 323 | 8246.60786516851 | 262.392134831485 | 8186 | 0.679161671429069 | 0.551723470160969 | 0.0318181898692875 | weekly | |||||||||
17384 | 17384 | Spain | Spain | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 47558632 | 8712 | 563 | 8092.20786516851 | 619.792134831494 | 8149 | 1.18380192264571 | 1.30321691093111 | 0.0765912276548502 | weekly | |||||||||
17385 | 17385 | Spain | Spain | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 47558632 | 8701 | 0 | 7961.8078651685 | 739.192134831495 | 8701 | 0.0 | 1.55427543591139 | 0.0928422473073403 | weekly | |||||||||
17386 | 17386 | Spain | Spain | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 47558632 | 8401 | 804 | 7759.40786516851 | 641.592134831491 | 7597 | 1.69054484157576 | 1.34905506708328 | 0.0826857082370365 | weekly | |||||||||
17387 | 17387 | Spain | Spain | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 47558632 | 8505 | 548 | 7657.00786516851 | 847.992134831487 | 7957 | 1.15226190694467 | 1.78304568312959 | 0.110747193912256 | weekly | |||||||||
17388 | 17388 | Spain | Spain | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 47558632 | 8489 | 413 | 7492.0078651685 | 996.992134831502 | 8076 | 0.868401765635311 | 2.09634317242662 | 0.133074090787687 | weekly | |||||||||
17389 | 17389 | Spain | Spain | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 47558632 | 8819 | 575 | 7530.4078651685 | 1288.5921348315 | 8244 | 1.20903393520655 | 2.70948107765484 | 0.171118504854407 | weekly | |||||||||
17390 | 17390 | Spain | Spain | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 47558632 | 8908 | 508 | 7496.6078651685 | 1411.3921348315 | 8400 | 1.06815519840857 | 2.96768867286069 | 0.188270769955736 | weekly | |||||||||
17391 | 17391 | Spain | Spain | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 47558632 | 8229 | 394 | 7406.60786516851 | 822.392134831493 | 7835 | 0.82845107908066 | 1.72921738966649 | 0.111034923112239 | weekly | |||||||||
17392 | 17392 | Spain | Spain | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 47558632 | 8132 | 456 | 7246.60786516851 | 885.392134831488 | 7676 | 0.958816477311627 | 1.86168545561085 | 0.12218021884242 | weekly | |||||||||
17393 | 17393 | Spain | Spain | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 47558632 | 8185 | 311 | 7298.00786516851 | 886.992134831487 | 7874 | 0.653929658868237 | 1.86504972395229 | 0.121538939285729 | weekly | |||||||||
17394 | 17394 | Spain | Spain | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 47558632 | 9353 | 374 | 7229.40786516851 | 2123.59213483149 | 8979 | 0.786397724812606 | 4.46520861834607 | 0.293743578234535 | weekly | |||||||||
17395 | 17395 | Spain | Spain | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 47558632 | 8570 | 317 | 7420.60786516852 | 1149.39213483148 | 8253 | 0.666545665148653 | 2.41678973194914 | 0.15489191124444 | weekly | |||||||||
17396 | 17396 | Spain | Spain | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 47558632 | 8585 | 312 | 7345.40786516851 | 1239.59213483149 | 8273 | 0.656032326581639 | 2.60645035969809 | 0.168757427441104 | weekly | |||||||||
17397 | 17397 | Spain | Spain | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 47558632 | 9102 | 619 | 7605.60786516851 | 1496.39213483149 | 8483 | 1.30155131459626 | 3.1464154284999 | 0.196748525740399 | weekly | |||||||||
17398 | 17398 | Spain | Spain | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 47558632 | 10875 | 618 | 7536.60786516851 | 3338.39213483149 | 10257 | 1.29944864688286 | 7.01952935658765 | 0.442956857323085 | weekly | |||||||||
17399 | 17399 | Spain | Spain | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 47558632 | 10962 | 839 | 7430.6078651685 | 3531.3921348315 | 10123 | 1.76413821154486 | 7.42534422527439 | 0.475249427625585 | weekly | |||||||||
17400 | 17400 | Spain | Spain | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 47558632 | 9896 | 532 | 7337.60786516851 | 2558.39213483149 | 9364 | 1.11861922353023 | 5.37944854013356 | 0.348668419169159 | weekly | |||||||||
17401 | 17401 | Spain | Spain | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 47558632 | 9416 | 381 | 7420.60786516851 | 1995.39213483149 | 9035 | 0.801116398806425 | 4.19564661748784 | 0.268898744023065 | weekly | |||||||||
17402 | 17402 | Spain | Spain | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 47558632 | 9295 | 573 | 7364.8078651685 | 1930.1921348315 | 8722 | 1.20482859977974 | 4.05855268257401 | 0.262083162272332 | weekly | |||||||||
17403 | 17403 | Spain | Spain | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 47558632 | 8072 | 461 | 7096.60786516851 | 975.392134831489 | 7611 | 0.96932981587864 | 2.0509255498171 | 0.137444840318555 | weekly | |||||||||
17404 | 17404 | Spain | Spain | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 47558632 | 8128 | 326 | 7001.0078651685 | 1126.9921348315 | 7802 | 0.685469674569277 | 2.36968997516897 | 0.1609756990045 | weekly | |||||||||
17405 | 17405 | Spain | Spain | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 47558632 | 7725 | 350 | 6951.60786516851 | 773.392134831487 | 7375 | 0.735933699690941 | 1.62618667170975 | 0.111253705593295 | weekly | |||||||||
17406 | 17406 | Spain | Spain | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 47558632 | 7635 | 334 | 6832.40786516851 | 802.592134831492 | 7301 | 0.702291016276498 | 1.68758456894112 | 0.117468416796821 | weekly | |||||||||
17407 | 17407 | Spain | Spain | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 47558632 | 7611 | 595 | 6734.00786516851 | 876.992134831486 | 7016 | 1.2510872894746 | 1.84402304681826 | 0.130233310146207 | weekly | |||||||||
17408 | 17408 | Spain | Spain | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 47558632 | 7406 | 284 | 6935.8078651685 | 470.192134831496 | 7122 | 0.597157630606364 | 0.988657821006071 | 0.0677919780899348 | weekly | |||||||||
17409 | 17409 | Spain | Spain | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 47558632 | 7508 | 170 | 7084.8078651685 | 423.1921348315 | 7338 | 0.357453511278457 | 0.889832438476153 | 0.0597323375432759 | weekly | |||||||||
17410 | 17410 | Spain | Spain | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 47558632 | 7936 | 289 | 7065.40786516851 | 870.592134831491 | 7647 | 0.607670969173377 | 1.8305659734525 | 0.123218949485335 | weekly | |||||||||
17411 | 17411 | Spain | Spain | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 47558632 | 7752 | 173 | 7188.00786516851 | 563.992134831495 | 7579 | 0.363761514418665 | 1.18588805252324 | 0.078462926781768 | weekly | |||||||||
17412 | 17412 | Spain | Spain | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 47558632 | 8090 | 221 | 7245.2078651685 | 844.792134831496 | 7869 | 0.464689564661995 | 1.77631714644672 | 0.116600123909882 | weekly | |||||||||
17413 | 17413 | Spain | Spain | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 47558632 | 7635 | 220 | 7364.60786516851 | 270.392134831493 | 7415 | 0.462586896948592 | 0.568544811868207 | 0.0367150756403922 | weekly | |||||||||
18060 | 18060 | Spain | Spain | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 47558632 | 8710 | 0 | 9658.27059925098 | -948.270599250984 | 8710 | 0.0 | -1.99389797261406 | -0.0981822355779226 | weekly | |||||||||
18061 | 18061 | Spain | Spain | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 47558632 | 9398 | 0 | 10124.6039325843 | -726.603932584261 | 9398 | 0.0 | -1.52780662947635 | -0.0717661586983974 | weekly | |||||||||
18062 | 18062 | Spain | Spain | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 47558632 | 9917 | 0 | 10359.4372659176 | -442.437265917593 | 9917 | 0.0 | -0.930298554251084 | -0.0427086196441583 | weekly | |||||||||
18063 | 18063 | Spain | Spain | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 47558632 | 9954 | 0 | 10087.1039325843 | -133.103932584263 | 9954 | 0.0 | -0.279873341571858 | -0.0131954556504864 | weekly | |||||||||
18064 | 18064 | Spain | Spain | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 47558632 | 9974 | 0 | 9982.27059925093 | -8.27059925093454 | 9974 | 0.0 | -0.0173903220154325 | -0.000828528857107491 | weekly | |||||||||
18065 | 18065 | Spain | Spain | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 47558632 | 9192 | 0 | 9618.43726591759 | -426.437265917592 | 9192 | 0.0 | -0.896655870836637 | -0.0443354002451779 | weekly | |||||||||
18066 | 18066 | Spain | Spain | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 47558632 | 8839 | 0 | 9429.9372659176 | -590.937265917597 | 8839 | 0.0 | -1.24254470969139 | -0.0626660866614042 | weekly | |||||||||
18067 | 18067 | Spain | Spain | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 47558632 | 8413 | 0 | 9187.4372659176 | -774.437265917597 | 8413 | 0.0 | -1.62838423510078 | -0.08429306709832 | weekly | |||||||||
18068 | 18068 | Spain | Spain | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 47558632 | 8379 | 0 | 9102.52471910111 | -723.524719101108 | 8379 | 0.0 | -1.52133206670265 | -0.0794861581186189 | weekly | |||||||||
18069 | 18069 | Spain | Spain | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 47558632 | 8465 | 17 | 8800.92471910111 | -335.924719101113 | 8448 | 0.0357453511278457 | -0.706338060987778 | -0.0381692526436498 | weekly | |||||||||
18070 | 18070 | Spain | Spain | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 47558632 | 9481 | 272 | 8497.72471910112 | 983.275280898881 | 9209 | 0.571925618045532 | 2.06750118653304 | 0.11571041818861 | weekly | |||||||||
18071 | 18071 | Spain | Spain | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 47558632 | 12843 | 1483 | 8221.5247191011 | 4621.4752808989 | 11360 | 3.11825621897619 | 9.71742686143474 | 0.562119003323289 | weekly | |||||||||
18072 | 18072 | Spain | Spain | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 47558632 | 19828 | 5031 | 8257.32471910112 | 11570.6752808989 | 14797 | 10.5785212661289 | 24.3292853354127 | 1.4012619915665 | weekly | |||||||||
18073 | 18073 | Spain | Spain | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 47558632 | 20967 | 5838 | 8102.92471910111 | 12864.0752808989 | 15129 | 12.2753741108449 | 27.0488757559277 | 1.58758420284645 | weekly | |||||||||
18074 | 18074 | Spain | Spain | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 47558632 | 17325 | 4568 | 7972.52471910111 | 9352.47528089889 | 12757 | 9.60498611482349 | 19.6651478135429 | 1.17308827635136 | weekly | |||||||||
18075 | 18075 | Spain | Spain | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 47558632 | 13244 | 3244 | 7770.12471910111 | 5473.87528089889 | 10000 | 6.82105406227833 | 11.5097408203392 | 0.704477145320794 | weekly | |||||||||
18076 | 18076 | Spain | Spain | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 47558632 | 10452 | 2737 | 7667.72471910112 | 2784.27528089888 | 7715 | 5.75500153158316 | 5.85440573837129 | 0.363116228463831 | weekly | |||||||||
18077 | 18077 | Spain | Spain | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 47558632 | 9008 | 2074 | 7502.7247191011 | 1505.2752808989 | 6934 | 4.36093283759718 | 3.16509373292928 | 0.200630482558774 | weekly | |||||||||
18078 | 18078 | Spain | Spain | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 47558632 | 8458 | 1357 | 7541.1247191011 | 916.875280898896 | 7101 | 2.85332008708745 | 1.92788405036313 | 0.121583359916661 | weekly | |||||||||
18079 | 18079 | Spain | Spain | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 47558632 | 7536 | 942 | 7507.3247191011 | 28.6752808988967 | 6594 | 1.98071298602533 | 0.060294587318863 | 0.00381964041410621 | weekly | |||||||||
18080 | 18080 | Spain | Spain | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 47558632 | 7643 | 1189 | 7417.32471910111 | 225.675280898889 | 6454 | 2.5000719112358 | 0.474520126859178 | 0.0304254282299021 | weekly | |||||||||
18081 | 18081 | Spain | Spain | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 47558632 | 7620 | 293 | 7257.32471910112 | 362.675280898884 | 7327 | 0.616081640026988 | 0.762585603595335 | 0.0499736879547819 | weekly | |||||||||
18082 | 18082 | Spain | Spain | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 47558632 | 7144 | 9 | 7308.72471910112 | -164.724719101116 | 7135 | 0.0189240094206242 | -0.346361348453243 | -0.0225380932285782 | weekly | |||||||||
18083 | 18083 | Spain | Spain | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 47558632 | 6849 | 0 | 7240.12471910111 | -391.124719101114 | 6849 | 0.0 | -0.822405318767609 | -0.0540218206558289 | weekly | |||||||||
18084 | 18084 | Spain | Spain | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 47558632 | 7032 | 8 | 7431.32471910112 | -399.324719101121 | 7024 | 0.0168213417072215 | -0.839647194017525 | -0.0537353344383829 | weekly | |||||||||
18085 | 18085 | Spain | Spain | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 47558632 | 7512 | 20 | 7356.12471910111 | 155.875280898888 | 7492 | 0.0420533542680538 | 0.327753920463668 | 0.0211898638007235 | weekly | |||||||||
18086 | 18086 | Spain | Spain | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 47558632 | 7635 | 42 | 7616.32471910111 | 18.6752808988895 | 7593 | 0.088312043962913 | 0.0392679101848209 | 0.00245200691772673 | weekly | |||||||||
18087 | 18087 | Spain | Spain | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 47558632 | 7732 | 18 | 7547.32471910112 | 184.675280898884 | 7714 | 0.0378480188412484 | 0.388310750609656 | 0.0244689724865685 | weekly | |||||||||
18088 | 18088 | Spain | Spain | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 47558632 | 7562 | 17 | 7441.3247191011 | 120.675280898898 | 7545 | 0.0357453511278457 | 0.253740016951912 | 0.0162169083401422 | weekly | |||||||||
18089 | 18089 | Spain | Spain | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 47558632 | 7827 | 12 | 7348.32471910111 | 478.675280898889 | 7815 | 0.0252320125608323 | 1.00649505835006 | 0.0651407360448606 | weekly | |||||||||
18090 | 18090 | Spain | Spain | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 47558632 | 8589 | 13 | 7431.32471910112 | 1157.67528089888 | 8576 | 0.027334680274235 | 2.43420643575047 | 0.155783164463699 | weekly | |||||||||
18091 | 18091 | Spain | Spain | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 47558632 | 8394 | 58 | 7375.52471910111 | 1018.47528089889 | 8336 | 0.121954727377356 | 2.14151509004484 | 0.138088518402121 | weekly | |||||||||
18092 | 18092 | Spain | Spain | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 47558632 | 8170 | 116 | 7107.32471910111 | 1062.67528089889 | 8054 | 0.243909454754712 | 2.23445300297722 | 0.149518324109059 | weekly | |||||||||
18093 | 18093 | Spain | Spain | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 47558632 | 7886 | 221 | 7011.7247191011 | 874.275280898901 | 7665 | 0.464689564661995 | 1.83831040577219 | 0.124687621936616 | weekly | |||||||||
18094 | 18094 | Spain | Spain | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 47558632 | 7954 | 173 | 6962.32471910112 | 991.675280898884 | 7781 | 0.363761514418665 | 2.08516359532563 | 0.142434505845185 | weekly | |||||||||
18095 | 18095 | Spain | Spain | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 47558632 | 7777 | 407 | 6843.12471910111 | 933.875280898889 | 7370 | 0.855785759354895 | 1.96362940149096 | 0.136469130584772 | weekly | |||||||||
18096 | 18096 | Spain | Spain | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 47558632 | 7998 | 329 | 6744.72471910112 | 1253.27528089888 | 7669 | 0.691777677709485 | 2.63522146915177 | 0.185815631192418 | weekly | |||||||||
18097 | 18097 | Spain | Spain | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 47558632 | 8168 | 748 | 6946.52471910111 | 1221.47528089889 | 7420 | 1.57279544962521 | 2.56835663586558 | 0.175839765968177 | weekly | |||||||||
18098 | 18098 | Spain | Spain | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 47558632 | 8064 | 737 | 7095.5247191011 | 968.475280898897 | 7327 | 1.54966610477778 | 2.03638170437471 | 0.136491002320345 | weekly | |||||||||
18099 | 18099 | Spain | Spain | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 47558632 | 8188 | 854 | 7076.12471910111 | 1111.87528089889 | 7334 | 1.7956782272459 | 2.33790425447664 | 0.157130537552217 | weekly | |||||||||
18100 | 18100 | Spain | Spain | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 47558632 | 8593 | 843 | 7198.72471910111 | 1394.27528089889 | 7750 | 1.77254888239847 | 2.93169761674157 | 0.193683650272015 | weekly | |||||||||
18101 | 18101 | Spain | Spain | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 47558632 | 8594 | 846 | 7255.92471910111 | 1338.07528089889 | 7748 | 1.77885688553868 | 2.81352769124834 | 0.18441140622317 | weekly | |||||||||
18102 | 18102 | Spain | Spain | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 47558632 | 9470 | 977 | 7375.32471910111 | 2094.67528089889 | 8493 | 2.05430635599443 | 4.40440608320881 | 0.284011261968434 | weekly | |||||||||
18103 | 18103 | Spain | Spain | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 47558632 | 9596 | 1126 | 7511.72471910111 | 2084.27528089889 | 8470 | 2.36760384529143 | 4.38253833898942 | 0.277469603698191 | weekly | |||||||||
18104 | 18104 | Spain | Spain | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 47558632 | 10316 | 2955 | 7685.52471910111 | 2630.47528089889 | 7361 | 6.21338309310495 | 5.53101544404996 | 0.342263589935671 | weekly | |||||||||
18105 | 18105 | Spain | Spain | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 47558632 | 10030 | 1936 | 7883.72471910111 | 2146.27528089889 | 8094 | 4.07076469314761 | 4.51290373722038 | 0.272241276474149 | weekly | |||||||||
18106 | 18106 | Spain | Spain | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 47558632 | 9695 | 1850 | 7944.92471910111 | 1750.07528089889 | 7845 | 3.88993526979498 | 3.67982678917024 | 0.220275879605426 | weekly | |||||||||
18107 | 18107 | Spain | Spain | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 47558632 | 9534 | 2049 | 8120.72471910111 | 1413.27528089889 | 7485 | 4.30836614476211 | 2.97164830329621 | 0.174033147260203 | weekly | |||||||||
18108 | 18108 | Spain | Spain | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 47558632 | 9541 | 1584 | 8163.12471910111 | 1377.87528089889 | 7957 | 3.33062565802986 | 2.89721386624175 | 0.168792628841596 | weekly | |||||||||
18109 | 18109 | Spain | Spain | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 47558632 | 9534 | 1372 | 8495.52471910111 | 1038.47528089889 | 8162 | 2.88486010278849 | 2.18356844431289 | 0.122237921168543 | weekly | |||||||||
18110 | 18110 | Spain | Spain | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 47558632 | 9287 | 1302 | 8737.92471910111 | 549.075280898889 | 7985 | 2.7376733628503 | 1.15452286537361 | 0.062838179378979 | weekly | |||||||||
18111 | 18111 | Spain | Spain | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 47558632 | 9015 | 898 | 9040.12471910111 | -25.1247191011098 | 8117 | 1.88819560663562 | -0.0528289356622154 | -0.00277924474294289 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_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] 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 , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);