economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
409 rows where country = "Spain" sorted by week
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 | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17842 | 17842 | Spain | Spain | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 47558632 | 8171 | 0 | TBC | weekly | |
17894 | 17894 | Spain | Spain | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 47558632 | 19828 | 5031 | TBC | weekly | |
17947 | 17947 | Spain | Spain | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 47558632 | 8195 | 688 | TBC | weekly | |
17999 | 17999 | Spain | Spain | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 47558632 | 8509 | 323 | TBC | weekly | |
17634 | 17634 | Spain | Spain | 0 | 2015-03-30 | 2015-04-05 | 7 | 2015 | 14 | 47558632 | 8282 | 0 | TBC | weekly | |
17687 | 17687 | Spain | Spain | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 47558632 | 7998 | 0 | TBC | weekly | |
17739 | 17739 | Spain | Spain | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 47558632 | 7814 | 0 | TBC | weekly | |
17791 | 17791 | Spain | Spain | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 47558632 | 8414 | 0 | TBC | weekly | |
17843 | 17843 | Spain | Spain | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 47558632 | 8087 | 0 | TBC | weekly | |
17895 | 17895 | Spain | Spain | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 47558632 | 20967 | 5838 | TBC | weekly | |
17948 | 17948 | Spain | Spain | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 47558632 | 8080 | 630 | TBC | weekly | |
18000 | 18000 | Spain | Spain | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 47558632 | 8712 | 563 | TBC | weekly | |
17635 | 17635 | Spain | Spain | 0 | 2015-04-06 | 2015-04-12 | 7 | 2015 | 15 | 47558632 | 7894 | 0 | TBC | weekly | |
17688 | 17688 | Spain | Spain | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 47558632 | 7859 | 0 | TBC | weekly | |
17740 | 17740 | Spain | Spain | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 47558632 | 7800 | 0 | TBC | weekly | |
17792 | 17792 | Spain | Spain | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 47558632 | 8335 | 0 | TBC | weekly | |
17844 | 17844 | Spain | Spain | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 47558632 | 8055 | 0 | TBC | weekly | |
17896 | 17896 | Spain | Spain | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 47558632 | 17325 | 4568 | TBC | weekly | |
17949 | 17949 | Spain | Spain | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 47558632 | 7947 | 653 | TBC | weekly | |
18001 | 18001 | Spain | Spain | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 47558632 | 8701 | 0 | TBC | weekly | |
17636 | 17636 | Spain | Spain | 0 | 2015-04-13 | 2015-04-19 | 7 | 2015 | 16 | 47558632 | 7855 | 0 | TBC | weekly | |
17689 | 17689 | Spain | Spain | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 47558632 | 7589 | 0 | TBC | weekly | |
17741 | 17741 | Spain | Spain | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 47558632 | 7574 | 0 | TBC | weekly | |
17793 | 17793 | Spain | Spain | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 47558632 | 8112 | 0 | TBC | weekly | |
17845 | 17845 | Spain | Spain | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 47558632 | 7801 | 0 | TBC | weekly | |
17897 | 17897 | Spain | Spain | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 47558632 | 13244 | 3244 | TBC | weekly | |
17950 | 17950 | Spain | Spain | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 47558632 | 8084 | 610 | TBC | weekly | |
18002 | 18002 | Spain | Spain | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 47558632 | 8401 | 804 | TBC | weekly | |
17637 | 17637 | Spain | Spain | 0 | 2015-04-20 | 2015-04-26 | 7 | 2015 | 17 | 47558632 | 7802 | 0 | TBC | weekly | |
17690 | 17690 | Spain | Spain | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 47558632 | 7462 | 0 | TBC | weekly | |
17742 | 17742 | Spain | Spain | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 47558632 | 7661 | 0 | TBC | weekly | |
17794 | 17794 | Spain | Spain | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 47558632 | 7735 | 0 | TBC | weekly | |
17846 | 17846 | Spain | Spain | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 47558632 | 7759 | 0 | TBC | weekly | |
17898 | 17898 | Spain | Spain | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 47558632 | 10452 | 2737 | TBC | weekly | |
17951 | 17951 | Spain | Spain | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 47558632 | 7867 | 625 | TBC | weekly | |
18003 | 18003 | Spain | Spain | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 47558632 | 8505 | 548 | TBC | weekly | |
17638 | 17638 | Spain | Spain | 0 | 2015-04-27 | 2015-05-03 | 7 | 2015 | 18 | 47558632 | 7365 | 0 | TBC | weekly | |
17691 | 17691 | Spain | Spain | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 47558632 | 7606 | 0 | TBC | weekly | |
17743 | 17743 | Spain | Spain | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 47558632 | 7520 | 0 | TBC | weekly | |
17795 | 17795 | Spain | Spain | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 47558632 | 7359 | 0 | TBC | weekly | |
17847 | 17847 | Spain | Spain | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 47558632 | 7744 | 0 | TBC | weekly | |
17899 | 17899 | Spain | Spain | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 47558632 | 9008 | 2074 | TBC | weekly | |
17952 | 17952 | Spain | Spain | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 47558632 | 8062 | 576 | TBC | weekly | |
18004 | 18004 | Spain | Spain | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 47558632 | 8489 | 413 | TBC | weekly | |
17639 | 17639 | Spain | Spain | 0 | 2015-05-04 | 2015-05-10 | 7 | 2015 | 19 | 47558632 | 7464 | 0 | TBC | weekly | |
17692 | 17692 | Spain | Spain | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 47558632 | 7374 | 0 | TBC | weekly | |
17744 | 17744 | Spain | Spain | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 47558632 | 7622 | 0 | TBC | weekly | |
17796 | 17796 | Spain | Spain | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 47558632 | 7595 | 0 | TBC | weekly | |
17848 | 17848 | Spain | Spain | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 47558632 | 7731 | 0 | TBC | weekly | |
17900 | 17900 | Spain | Spain | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 47558632 | 8458 | 1357 | TBC | weekly | |
17953 | 17953 | Spain | Spain | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 47558632 | 7738 | 547 | TBC | weekly | |
18005 | 18005 | Spain | Spain | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 47558632 | 8819 | 575 | TBC | weekly | |
17640 | 17640 | Spain | Spain | 0 | 2015-05-11 | 2015-05-17 | 7 | 2015 | 20 | 47558632 | 7543 | 0 | TBC | weekly | |
17693 | 17693 | Spain | Spain | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 47558632 | 7533 | 0 | TBC | weekly | |
17745 | 17745 | Spain | Spain | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 47558632 | 7494 | 0 | TBC | weekly | |
17797 | 17797 | Spain | Spain | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 47558632 | 7511 | 0 | TBC | weekly | |
17849 | 17849 | Spain | Spain | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 47558632 | 7536 | 0 | TBC | weekly | |
17901 | 17901 | Spain | Spain | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 47558632 | 7536 | 942 | TBC | weekly | |
17954 | 17954 | Spain | Spain | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 47558632 | 7606 | 281 | TBC | weekly | |
18006 | 18006 | Spain | Spain | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 47558632 | 8908 | 508 | TBC | weekly | |
17641 | 17641 | Spain | Spain | 0 | 2015-05-18 | 2015-05-24 | 7 | 2015 | 21 | 47558632 | 7234 | 0 | TBC | weekly | |
17694 | 17694 | Spain | Spain | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 47558632 | 7304 | 0 | TBC | weekly | |
17746 | 17746 | Spain | Spain | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 47558632 | 7666 | 0 | TBC | weekly | |
17798 | 17798 | Spain | Spain | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 47558632 | 7527 | 0 | TBC | weekly | |
17850 | 17850 | Spain | Spain | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 47558632 | 7436 | 0 | TBC | weekly | |
17902 | 17902 | Spain | Spain | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 47558632 | 7643 | 1189 | TBC | weekly | |
17955 | 17955 | Spain | Spain | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 47558632 | 7437 | 285 | TBC | weekly | |
18007 | 18007 | Spain | Spain | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 47558632 | 8229 | 394 | TBC | weekly | |
17642 | 17642 | Spain | Spain | 0 | 2015-05-25 | 2015-05-31 | 7 | 2015 | 22 | 47558632 | 7096 | 0 | TBC | weekly | |
17695 | 17695 | Spain | Spain | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 47558632 | 7255 | 0 | TBC | weekly | |
17747 | 17747 | Spain | Spain | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 47558632 | 7092 | 0 | TBC | weekly | |
17799 | 17799 | Spain | Spain | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 47558632 | 7306 | 0 | TBC | weekly | |
17851 | 17851 | Spain | Spain | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 47558632 | 7618 | 0 | TBC | weekly | |
17903 | 17903 | Spain | Spain | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 47558632 | 7620 | 293 | TBC | weekly | |
17956 | 17956 | Spain | Spain | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 47558632 | 7353 | 291 | TBC | weekly | |
18008 | 18008 | Spain | Spain | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 47558632 | 8132 | 456 | TBC | weekly | |
17643 | 17643 | Spain | Spain | 0 | 2015-06-01 | 2015-06-07 | 7 | 2015 | 23 | 47558632 | 7364 | 0 | TBC | weekly | |
17696 | 17696 | Spain | Spain | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 47558632 | 7576 | 0 | TBC | weekly | |
17748 | 17748 | Spain | Spain | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 47558632 | 7067 | 0 | TBC | weekly | |
17800 | 17800 | Spain | Spain | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 47558632 | 7109 | 0 | TBC | weekly | |
17852 | 17852 | Spain | Spain | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 47558632 | 7508 | 0 | TBC | weekly | |
17904 | 17904 | Spain | Spain | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 47558632 | 7144 | 9 | TBC | weekly | |
17957 | 17957 | Spain | Spain | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 47558632 | 7710 | 305 | TBC | weekly | |
18009 | 18009 | Spain | Spain | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 47558632 | 8185 | 311 | TBC | weekly | |
17644 | 17644 | Spain | Spain | 0 | 2015-06-08 | 2015-06-14 | 7 | 2015 | 24 | 47558632 | 7152 | 0 | TBC | weekly | |
17697 | 17697 | Spain | Spain | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 47558632 | 7140 | 0 | TBC | weekly | |
17749 | 17749 | Spain | Spain | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 47558632 | 7819 | 0 | TBC | weekly | |
17801 | 17801 | Spain | Spain | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 47558632 | 7154 | 0 | TBC | weekly | |
17853 | 17853 | Spain | Spain | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 47558632 | 7016 | 0 | TBC | weekly | |
17905 | 17905 | Spain | Spain | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 47558632 | 6849 | 0 | TBC | weekly | |
17958 | 17958 | Spain | Spain | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 47558632 | 7799 | 151 | TBC | weekly | |
18010 | 18010 | Spain | Spain | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 47558632 | 9353 | 374 | TBC | weekly | |
17645 | 17645 | Spain | Spain | 0 | 2015-06-15 | 2015-06-21 | 7 | 2015 | 25 | 47558632 | 6956 | 0 | TBC | weekly | |
17698 | 17698 | Spain | Spain | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 47558632 | 7173 | 0 | TBC | weekly | |
17750 | 17750 | Spain | Spain | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 47558632 | 7991 | 0 | TBC | weekly | |
17802 | 17802 | Spain | Spain | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 47558632 | 7713 | 0 | TBC | weekly | |
17854 | 17854 | Spain | Spain | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 47558632 | 7404 | 0 | TBC | weekly | |
17906 | 17906 | Spain | Spain | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 47558632 | 7032 | 8 | TBC | weekly | |
17959 | 17959 | Spain | Spain | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 47558632 | 7285 | 127 | TBC | weekly | |
18011 | 18011 | Spain | Spain | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 47558632 | 8570 | 317 | TBC | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_historical_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] TEXT, [cadence] TEXT , [month] INTEGER); CREATE INDEX [idx_economist_historical_deaths_country] ON [economist_historical_deaths] ([country]); CREATE INDEX [idx_economist_historical_deaths_cadence] ON [economist_historical_deaths] ([cadence]); CREATE INDEX [idx_economist_historical_deaths_end_date] ON [economist_historical_deaths] ([end_date]);