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 region_code
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, end_date (date)
start_date (date) >30 ✖
- 2019-12-30 2
- 2020-01-06 2
- 2020-01-13 2
- 2020-01-20 2
- 2020-01-27 2
- 2020-02-03 2
- 2020-02-10 2
- 2020-02-17 2
- 2020-02-24 2
- 2020-03-02 2
- 2020-03-09 2
- 2020-03-16 2
- 2020-03-23 2
- 2020-03-30 2
- 2020-04-06 2
- 2020-04-13 2
- 2020-04-20 2
- 2020-04-27 2
- 2020-05-04 2
- 2020-05-11 2
- 2020-05-18 2
- 2020-05-25 2
- 2020-06-01 2
- 2020-06-08 2
- 2020-06-15 2
- 2020-06-22 2
- 2020-06-29 2
- 2020-07-06 2
- 2020-07-13 2
- 2020-07-20 2
- …
end_date >30 ✖
- 2020-01-05 2
- 2020-01-12 2
- 2020-01-19 2
- 2020-01-26 2
- 2020-02-02 2
- 2020-02-09 2
- 2020-02-16 2
- 2020-02-23 2
- 2020-03-01 2
- 2020-03-08 2
- 2020-03-15 2
- 2020-03-22 2
- 2020-03-29 2
- 2020-04-05 2
- 2020-04-12 2
- 2020-04-19 2
- 2020-04-26 2
- 2020-05-03 2
- 2020-05-10 2
- 2020-05-17 2
- 2020-05-24 2
- 2020-05-31 2
- 2020-06-07 2
- 2020-06-14 2
- 2020-06-21 2
- 2020-06-28 2
- 2020-07-05 2
- 2020-07-12 2
- 2020-07-19 2
- 2020-07-26 2
- …
country 1
- Spain · 296 ✖
cadence 1
- weekly 296
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17266 | 17266 | Spain | Spain | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 47558632 | 8710 | 0 | 9658.27059925098 | -948.270599250984 | 8710 | 0.0 | -1.99389797261407 | -0.0981822355779223 | weekly | |||||||||
17267 | 17267 | 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.071766158698401 | weekly | |||||||||
17268 | 17268 | Spain | Spain | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 47558632 | 9917 | 0 | 10359.4372659176 | -442.437265917593 | 9917 | 0.0 | -0.930298554251083 | -0.042708619644159 | weekly | |||||||||
17269 | 17269 | 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.01319545565049 | weekly | |||||||||
17270 | 17270 | 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.000828528857107047 | weekly | |||||||||
17271 | 17271 | Spain | Spain | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 47558632 | 9192 | 0 | 9618.43726591759 | -426.437265917592 | 9192 | 0.0 | -0.896655870836638 | -0.0443354002451778 | weekly | |||||||||
17272 | 17272 | 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.0626660866614045 | weekly | |||||||||
17273 | 17273 | 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.0842930670983203 | weekly | |||||||||
17274 | 17274 | 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.079486158118619 | weekly | |||||||||
17275 | 17275 | 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.0381692526436496 | weekly | |||||||||
17276 | 17276 | 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 | |||||||||
17277 | 17277 | 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.56211900332329 | weekly | |||||||||
17278 | 17278 | 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.40126199156649 | weekly | |||||||||
17279 | 17279 | Spain | Spain | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 47558632 | 20967 | 5838 | 8102.92471910111 | 12864.0752808989 | 15129 | 12.2753741108449 | 27.0488757559278 | 1.58758420284645 | weekly | |||||||||
17280 | 17280 | 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.17308827635135 | weekly | |||||||||
17281 | 17281 | 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.704477145320795 | weekly | |||||||||
17282 | 17282 | Spain | Spain | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 47558632 | 10452 | 2737 | 7667.72471910112 | 2784.27528089888 | 7715 | 5.75500153158316 | 5.85440573837128 | 0.36311622846383 | weekly | |||||||||
17283 | 17283 | 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.200630482558775 | weekly | |||||||||
17284 | 17284 | 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 | |||||||||
17285 | 17285 | 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.00381964041410665 | weekly | |||||||||
17286 | 17286 | Spain | Spain | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 47558632 | 7643 | 1189 | 7417.32471910111 | 225.675280898889 | 6454 | 2.5000719112358 | 0.474520126859177 | 0.0304254282299021 | weekly | |||||||||
17287 | 17287 | 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.0499736879547814 | weekly | |||||||||
17288 | 17288 | Spain | Spain | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 47558632 | 7144 | 9 | 7308.72471910112 | -164.724719101116 | 7135 | 0.0189240094206242 | -0.346361348453244 | -0.0225380932285789 | weekly | |||||||||
17289 | 17289 | 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.0540218206558284 | weekly | |||||||||
17290 | 17290 | Spain | Spain | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 47558632 | 7032 | 8 | 7431.32471910112 | -399.324719101121 | 7024 | 0.0168213417072215 | -0.839647194017526 | -0.0537353344383827 | weekly | |||||||||
17291 | 17291 | Spain | Spain | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 47558632 | 7512 | 20 | 7356.12471910111 | 155.875280898888 | 7492 | 0.0420533542680538 | 0.327753920463667 | 0.0211898638007237 | weekly | |||||||||
17292 | 17292 | 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.00245200691772696 | weekly | |||||||||
17293 | 17293 | 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.0244689724865681 | weekly | |||||||||
17294 | 17294 | Spain | Spain | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 47558632 | 7562 | 17 | 7441.3247191011 | 120.675280898898 | 7545 | 0.0357453511278457 | 0.253740016951913 | 0.0162169083401427 | weekly | |||||||||
17295 | 17295 | 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 | |||||||||
17296 | 17296 | Spain | Spain | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 47558632 | 8589 | 13 | 7431.32471910112 | 1157.67528089888 | 8576 | 0.027334680274235 | 2.43420643575046 | 0.155783164463699 | weekly | |||||||||
17297 | 17297 | Spain | Spain | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 47558632 | 8394 | 58 | 7375.52471910111 | 1018.47528089889 | 8336 | 0.121954727377356 | 2.14151509004483 | 0.138088518402121 | weekly | |||||||||
17298 | 17298 | Spain | Spain | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 47558632 | 8170 | 116 | 7107.32471910111 | 1062.67528089889 | 8054 | 0.243909454754712 | 2.23445300297723 | 0.14951832410906 | weekly | |||||||||
17299 | 17299 | 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 | |||||||||
17300 | 17300 | 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.142434505845184 | weekly | |||||||||
17301 | 17301 | 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 | |||||||||
17302 | 17302 | Spain | Spain | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 47558632 | 7998 | 329 | 6744.72471910112 | 1253.27528089888 | 7669 | 0.691777677709485 | 2.63522146915176 | 0.185815631192418 | weekly | |||||||||
17303 | 17303 | 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.175839765968176 | weekly | |||||||||
17304 | 17304 | 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.136491002320346 | weekly | |||||||||
17305 | 17305 | 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 | |||||||||
17306 | 17306 | Spain | Spain | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 47558632 | 8593 | 843 | 7198.72471910111 | 1394.27528089889 | 7750 | 1.77254888239847 | 2.93169761674156 | 0.193683650272015 | weekly | |||||||||
17307 | 17307 | Spain | Spain | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 47558632 | 8594 | 846 | 7255.92471910111 | 1338.07528089889 | 7748 | 1.77885688553868 | 2.81352769124833 | 0.184411406223169 | weekly | |||||||||
17308 | 17308 | 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 | |||||||||
17309 | 17309 | 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 | |||||||||
17310 | 17310 | Spain | Spain | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 47558632 | 10316 | 2955 | 7685.52471910111 | 2630.47528089889 | 7361 | 6.21338309310495 | 5.53101544404997 | 0.342263589935672 | weekly | |||||||||
17311 | 17311 | 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 | |||||||||
17312 | 17312 | 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 | |||||||||
17313 | 17313 | 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.174033147260202 | weekly | |||||||||
17314 | 17314 | Spain | Spain | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 47558632 | 9541 | 1584 | 8163.12471910111 | 1377.87528089889 | 7957 | 3.33062565802986 | 2.89721386624176 | 0.168792628841596 | weekly | |||||||||
17315 | 17315 | 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 | |||||||||
17316 | 17316 | 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 | |||||||||
17317 | 17317 | 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 | |||||||||
17318 | 17318 | Spain | Spain | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 47558632 | 9524 | 1013 | 8933.47191011234 | 590.528089887655 | 8511 | 2.13000239367693 | 1.24168434846413 | 0.0661028652498707 | weekly | |||||||||
17319 | 17319 | Spain | Spain | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 47558632 | 10470 | 1037 | 9652.91217228468 | 817.087827715319 | 9433 | 2.18046641879859 | 1.71806419435134 | 0.0846467690922676 | weekly | |||||||||
17320 | 17320 | Spain | Spain | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 47558632 | 11858 | 1440 | 10119.245505618 | 1738.75449438204 | 10418 | 3.02784150729987 | 3.65602293687093 | 0.171826495702341 | weekly | |||||||||
17321 | 17321 | Spain | Spain | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 47558632 | 12950 | 2127 | 10354.0788389513 | 2595.92116104871 | 10823 | 4.47237422640752 | 5.45835961187595 | 0.250714834359096 | weekly | |||||||||
17322 | 17322 | Spain | Spain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 47558632 | 12701 | 2878 | 10081.745505618 | 2619.25449438204 | 9823 | 6.05147767917294 | 5.507421858522 | 0.259801687408439 | weekly | |||||||||
17323 | 17323 | Spain | Spain | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 47558632 | 11571 | 3067 | 9976.91217228463 | 1594.08782771537 | 8504 | 6.44888187700605 | 3.35183700766534 | 0.159777674714193 | weekly | |||||||||
17324 | 17324 | Spain | Spain | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 47558632 | 10368 | 3361 | 9613.07883895129 | 754.921161048711 | 7007 | 7.06706618474644 | 1.5873483515016 | 0.0785306324535526 | weekly | |||||||||
17325 | 17325 | Spain | Spain | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 47558632 | 9488 | 2354 | 9424.5788389513 | 63.4211610487037 | 7134 | 4.94967979734993 | 0.133353627683622 | 0.00672933635894513 | weekly | |||||||||
17326 | 17326 | Spain | Spain | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 47558632 | 9032 | 2041 | 9182.0788389513 | -150.078838951296 | 6991 | 4.29154480305489 | -0.315565929127852 | -0.016344756082321 | weekly | |||||||||
17327 | 17327 | Spain | Spain | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 47558632 | 8542 | 1996 | 9097.16629213481 | -555.166292134807 | 6546 | 4.19692475595177 | -1.16733023804134 | -0.0610262882206291 | weekly | |||||||||
17328 | 17328 | Spain | Spain | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 47558632 | 8318 | 1120 | 8795.56629213481 | -477.566292134812 | 7198 | 2.35498783901101 | -1.00416322348131 | -0.0542962529384675 | weekly | |||||||||
17329 | 17329 | Spain | Spain | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 47558632 | 8077 | 652 | 8492.36629213482 | -415.366292134819 | 7425 | 1.37093934913855 | -0.873377291707674 | -0.0489105483496998 | weekly | |||||||||
17330 | 17330 | Spain | Spain | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 47558632 | 8189 | 2100 | 8216.1662921348 | -27.1662921348016 | 6089 | 4.41560219814565 | -0.0571216853647128 | -0.00330644380467393 | weekly | |||||||||
17331 | 17331 | Spain | Spain | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 47558632 | 8195 | 688 | 8251.96629213482 | -56.9662921348172 | 7507 | 1.44663538682105 | -0.119781183224146 | -0.00690335977124834 | weekly | |||||||||
17332 | 17332 | Spain | Spain | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 47558632 | 8080 | 630 | 8097.56629213481 | -17.5662921348085 | 7450 | 1.32468065944369 | -0.0369360753160614 | -0.00216932983331952 | weekly | |||||||||
17333 | 17333 | Spain | Spain | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 47558632 | 7947 | 653 | 7967.16629213481 | -20.166292134807 | 7294 | 1.37304201685196 | -0.0424030113709053 | -0.00253117499941202 | weekly | |||||||||
17334 | 17334 | Spain | Spain | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 47558632 | 8084 | 610 | 7764.76629213481 | 319.233707865189 | 7474 | 1.28262730517564 | 0.671242410557959 | 0.0411131122115744 | weekly | |||||||||
17335 | 17335 | Spain | Spain | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 47558632 | 7867 | 625 | 7662.36629213482 | 204.633707865184 | 7242 | 1.31416732087668 | 0.430276690602 | 0.0267063332739954 | weekly | |||||||||
17336 | 17336 | Spain | Spain | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 47558632 | 8062 | 576 | 7497.3662921348 | 564.6337078652 | 7486 | 1.21113660291995 | 1.187237067427 | 0.0753109406509238 | weekly | |||||||||
17337 | 17337 | Spain | Spain | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 47558632 | 7738 | 547 | 7535.7662921348 | 202.233707865196 | 7191 | 1.15015923923127 | 0.425230288089859 | 0.0268365153622498 | weekly | |||||||||
17338 | 17338 | Spain | Spain | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 47558632 | 7606 | 281 | 7501.9662921348 | 104.033707865196 | 7325 | 0.590849627466156 | 0.218748318633715 | 0.0138675253678853 | weekly | |||||||||
17339 | 17339 | Spain | Spain | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 47558632 | 7437 | 285 | 7411.96629213481 | 25.0337078651901 | 7152 | 0.599260298319767 | 0.0526375692748902 | 0.00337747189861815 | weekly | |||||||||
17340 | 17340 | Spain | Spain | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 47558632 | 7353 | 291 | 7251.96629213481 | 101.033707865186 | 7062 | 0.611876304600183 | 0.212440315493486 | 0.0139319053336979 | weekly | |||||||||
17341 | 17341 | Spain | Spain | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 47558632 | 7710 | 305 | 7303.36629213482 | 406.633707865185 | 7405 | 0.64131365258782 | 0.855015568709346 | 0.0556775727246619 | weekly | |||||||||
17342 | 17342 | Spain | Spain | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 47558632 | 7799 | 151 | 7234.76629213481 | 564.233707865186 | 7648 | 0.317502824723806 | 1.18639600034161 | 0.0779892100286073 | weekly | |||||||||
17343 | 17343 | Spain | Spain | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 47558632 | 7285 | 127 | 7425.96629213482 | -140.966292134821 | 7158 | 0.267038799602142 | -0.29640527114998 | -0.0189828887701959 | weekly | |||||||||
17344 | 17344 | Spain | Spain | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 47558632 | 7557 | 132 | 7350.76629213481 | 206.233707865189 | 7425 | 0.277552138169155 | 0.433640958943455 | 0.0280560828176317 | weekly | |||||||||
17345 | 17345 | Spain | Spain | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 47558632 | 7544 | 92 | 7610.96629213481 | -66.9662921348099 | 7452 | 0.193445429633047 | -0.140807860358157 | -0.00879865835222693 | weekly | |||||||||
17346 | 17346 | Spain | Spain | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 47558632 | 7563 | 93 | 7541.96629213482 | 21.0337078651846 | 7470 | 0.19554809734645 | 0.0442268984212679 | 0.002788889137189 | weekly | |||||||||
17347 | 17347 | Spain | Spain | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 47558632 | 8481 | 125 | 7435.9662921348 | 1045.0337078652 | 8356 | 0.262833464175336 | 2.19735863694565 | 0.140537714509351 | weekly | |||||||||
17348 | 17348 | Spain | Spain | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 47558632 | 8362 | 265 | 7342.96629213481 | 1019.03370786519 | 8097 | 0.557206944051713 | 2.14268927639716 | 0.13877684675697 | weekly | |||||||||
17349 | 17349 | Spain | Spain | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 47558632 | 8642 | 520 | 7425.96629213482 | 1216.03370786518 | 8122 | 1.0933872109694 | 2.55691481593747 | 0.163754272511732 | weekly | |||||||||
17350 | 17350 | Spain | Spain | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 47558632 | 8860 | 464 | 7370.16629213481 | 1489.83370786519 | 8396 | 0.975637819018848 | 3.13262523586715 | 0.202143838932792 | weekly | |||||||||
17351 | 17351 | Spain | Spain | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 47558632 | 8766 | 666 | 7101.96629213481 | 1664.03370786519 | 8100 | 1.40037669712619 | 3.4989099515419 | 0.234306055452284 | weekly | |||||||||
17352 | 17352 | Spain | Spain | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 47558632 | 8214 | 864 | 7006.3662921348 | 1207.6337078652 | 7350 | 1.81670490437992 | 2.53925240714493 | 0.172362342691227 | weekly | |||||||||
17353 | 17353 | Spain | Spain | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 47558632 | 7936 | 795 | 6956.96629213482 | 979.033707865185 | 7141 | 1.67162083215514 | 2.05858256786105 | 0.140727102411294 | weekly | |||||||||
17354 | 17354 | Spain | Spain | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 47558632 | 7895 | 495 | 6837.76629213481 | 1057.23370786519 | 7400 | 1.04082051813433 | 2.22301118304915 | 0.154616824076202 | weekly | |||||||||
17355 | 17355 | Spain | Spain | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 47558632 | 7504 | 493 | 6739.36629213482 | 764.633707865183 | 7011 | 1.03661518270753 | 1.6077706101075 | 0.113457805188234 | weekly | |||||||||
17356 | 17356 | Spain | Spain | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 47558632 | 7430 | 446 | 6941.16629213481 | 488.833707865194 | 6984 | 0.9377898001776 | 1.02785485475107 | 0.0704252984716847 | weekly | |||||||||
17357 | 17357 | Spain | Spain | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 47558632 | 7548 | 234 | 7090.1662921348 | 457.833707865198 | 7314 | 0.492024244936229 | 0.962672155635591 | 0.0645730563996898 | weekly | |||||||||
17358 | 17358 | Spain | Spain | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 47558632 | 7526 | 315 | 7070.76629213481 | 455.233707865189 | 7211 | 0.662340329721847 | 0.957205219580725 | 0.0643825137271996 | weekly | |||||||||
17359 | 17359 | Spain | Spain | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 47558632 | 7586 | 196 | 7193.36629213481 | 392.633707865192 | 7390 | 0.412122871826927 | 0.825578220721723 | 0.0545827491496567 | weekly | |||||||||
17360 | 17360 | Spain | Spain | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 47558632 | 7744 | 158 | 7250.56629213481 | 493.433707865193 | 7586 | 0.332221498717625 | 1.03752712623272 | 0.0680545060874005 | weekly | |||||||||
17361 | 17361 | Spain | Spain | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 47558632 | 8179 | 236 | 7369.96629213481 | 809.03370786519 | 7943 | 0.496229580363035 | 1.7011290565826 | 0.109774410871945 | weekly | |||||||||
17362 | 17362 | Spain | Spain | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 47558632 | 7821 | 136 | 7506.36629213481 | 314.633707865191 | 7685 | 0.285962809022766 | 0.661570139076311 | 0.0419155814704733 | weekly | |||||||||
17363 | 17363 | Spain | Spain | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 47558632 | 8717 | 169 | 7680.16629213481 | 1036.83370786519 | 8548 | 0.355350843565055 | 2.18011676169573 | 0.135001465909274 | weekly | |||||||||
17364 | 17364 | Spain | Spain | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 47558632 | 8793 | 137 | 7878.36629213481 | 914.633707865189 | 8656 | 0.288065476736169 | 1.92317076711792 | 0.116094336560398 | weekly | |||||||||
17365 | 17365 | Spain | Spain | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 47558632 | 8846 | 145 | 7939.56629213481 | 906.433707865192 | 8701 | 0.30488681844339 | 1.90592889186803 | 0.114166652750684 | 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);