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 total_deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18024 | 18024 | Spain | Spain | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 47558632 | 7406 | 284 | TBC | weekly | |
17665 | 17665 | Spain | Spain | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 47558632 | 7412 | 0 | TBC | weekly | |
17701 | 17701 | Spain | Spain | 0 | 2016-07-11 | 2016-07-17 | 7 | 2016 | 28 | 47558632 | 7423 | 0 | TBC | weekly | |
17704 | 17704 | Spain | Spain | 0 | 2016-08-01 | 2016-08-07 | 7 | 2016 | 31 | 47558632 | 7425 | 0 | TBC | weekly | |
17972 | 17972 | Spain | Spain | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 47558632 | 7430 | 446 | TBC | weekly | |
17850 | 17850 | Spain | Spain | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 47558632 | 7436 | 0 | TBC | weekly | |
17818 | 17818 | Spain | Spain | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 47558632 | 7437 | 0 | TBC | weekly | |
17955 | 17955 | Spain | Spain | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 47558632 | 7437 | 285 | TBC | weekly | |
17690 | 17690 | Spain | Spain | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 47558632 | 7462 | 0 | TBC | weekly | |
17857 | 17857 | Spain | Spain | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 47558632 | 7463 | 0 | TBC | weekly | |
17639 | 17639 | Spain | Spain | 0 | 2015-05-04 | 2015-05-10 | 7 | 2015 | 19 | 47558632 | 7464 | 0 | TBC | weekly | |
17859 | 17859 | Spain | Spain | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 47558632 | 7464 | 0 | TBC | weekly | |
17745 | 17745 | Spain | Spain | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 47558632 | 7494 | 0 | TBC | weekly | |
17971 | 17971 | Spain | Spain | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 47558632 | 7504 | 493 | TBC | weekly | |
17700 | 17700 | Spain | Spain | 0 | 2016-07-04 | 2016-07-10 | 7 | 2016 | 27 | 47558632 | 7505 | 0 | TBC | weekly | |
17852 | 17852 | Spain | Spain | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 47558632 | 7508 | 0 | TBC | weekly | |
18025 | 18025 | Spain | Spain | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 47558632 | 7508 | 170 | TBC | weekly | |
17769 | 17769 | Spain | Spain | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 47558632 | 7511 | 0 | TBC | weekly | |
17797 | 17797 | Spain | Spain | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 47558632 | 7511 | 0 | TBC | weekly | |
17716 | 17716 | Spain | Spain | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 47558632 | 7512 | 0 | TBC | weekly | |
17907 | 17907 | Spain | Spain | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 47558632 | 7512 | 20 | TBC | weekly | |
17743 | 17743 | Spain | Spain | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 47558632 | 7520 | 0 | TBC | weekly | |
17974 | 17974 | Spain | Spain | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 47558632 | 7526 | 315 | TBC | weekly | |
17798 | 17798 | Spain | Spain | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 47558632 | 7527 | 0 | TBC | weekly | |
17693 | 17693 | Spain | Spain | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 47558632 | 7533 | 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 | |
17640 | 17640 | Spain | Spain | 0 | 2015-05-11 | 2015-05-17 | 7 | 2015 | 20 | 47558632 | 7543 | 0 | TBC | weekly | |
17872 | 17872 | Spain | Spain | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 47558632 | 7543 | 0 | TBC | weekly | |
17961 | 17961 | Spain | Spain | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 47558632 | 7544 | 92 | TBC | weekly | |
17973 | 17973 | Spain | Spain | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 47558632 | 7548 | 234 | TBC | weekly | |
17960 | 17960 | Spain | Spain | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 47558632 | 7557 | 132 | TBC | weekly | |
17910 | 17910 | Spain | Spain | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 47558632 | 7562 | 17 | TBC | weekly | |
17962 | 17962 | Spain | Spain | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 47558632 | 7563 | 93 | TBC | weekly | |
17855 | 17855 | Spain | Spain | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 47558632 | 7570 | 0 | TBC | weekly | |
17741 | 17741 | Spain | Spain | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 47558632 | 7574 | 0 | TBC | weekly | |
17696 | 17696 | Spain | Spain | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 47558632 | 7576 | 0 | TBC | weekly | |
17975 | 17975 | Spain | Spain | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 47558632 | 7586 | 196 | TBC | weekly | |
17689 | 17689 | Spain | Spain | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 47558632 | 7589 | 0 | TBC | weekly | |
17796 | 17796 | Spain | Spain | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 47558632 | 7595 | 0 | TBC | weekly | |
17756 | 17756 | Spain | Spain | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 47558632 | 7596 | 0 | TBC | weekly | |
17691 | 17691 | Spain | Spain | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 47558632 | 7606 | 0 | TBC | weekly | |
17954 | 17954 | Spain | Spain | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 47558632 | 7606 | 281 | TBC | weekly | |
18023 | 18023 | Spain | Spain | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 47558632 | 7611 | 595 | 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 | |
17744 | 17744 | Spain | Spain | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 47558632 | 7622 | 0 | TBC | weekly | |
17770 | 17770 | Spain | Spain | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 47558632 | 7632 | 0 | TBC | weekly | |
17908 | 17908 | Spain | Spain | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 47558632 | 7635 | 42 | TBC | weekly | |
18022 | 18022 | Spain | Spain | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 47558632 | 7635 | 334 | TBC | weekly | |
18029 | 18029 | Spain | Spain | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 47558632 | 7635 | 220 | TBC | weekly | |
17902 | 17902 | Spain | Spain | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 47558632 | 7643 | 1189 | TBC | weekly | |
17742 | 17742 | Spain | Spain | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 47558632 | 7661 | 0 | TBC | weekly | |
17746 | 17746 | Spain | Spain | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 47558632 | 7666 | 0 | TBC | weekly | |
17874 | 17874 | Spain | Spain | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 47558632 | 7677 | 0 | TBC | weekly | |
17803 | 17803 | Spain | Spain | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 47558632 | 7698 | 0 | TBC | weekly | |
17873 | 17873 | Spain | Spain | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 47558632 | 7698 | 0 | TBC | weekly | |
17957 | 17957 | Spain | Spain | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 47558632 | 7710 | 305 | TBC | weekly | |
17802 | 17802 | Spain | Spain | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 47558632 | 7713 | 0 | TBC | weekly | |
18021 | 18021 | Spain | Spain | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 47558632 | 7725 | 350 | TBC | weekly | |
17808 | 17808 | Spain | Spain | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 47558632 | 7731 | 0 | TBC | weekly | |
17848 | 17848 | Spain | Spain | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 47558632 | 7731 | 0 | TBC | weekly | |
17909 | 17909 | Spain | Spain | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 47558632 | 7732 | 18 | TBC | weekly | |
17794 | 17794 | Spain | Spain | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 47558632 | 7735 | 0 | TBC | weekly | |
17953 | 17953 | Spain | Spain | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 47558632 | 7738 | 547 | TBC | weekly | |
17847 | 17847 | Spain | Spain | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 47558632 | 7744 | 0 | TBC | weekly | |
17976 | 17976 | Spain | Spain | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 47558632 | 7744 | 158 | TBC | weekly | |
18027 | 18027 | Spain | Spain | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 47558632 | 7752 | 173 | TBC | weekly | |
17846 | 17846 | Spain | Spain | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 47558632 | 7759 | 0 | TBC | weekly | |
17718 | 17718 | Spain | Spain | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 47558632 | 7775 | 0 | TBC | weekly | |
17917 | 17917 | Spain | Spain | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 47558632 | 7777 | 407 | TBC | weekly | |
17821 | 17821 | Spain | Spain | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 47558632 | 7794 | 0 | TBC | weekly | |
17650 | 17650 | Spain | Spain | 0 | 2015-07-20 | 2015-07-26 | 7 | 2015 | 30 | 47558632 | 7798 | 0 | TBC | weekly | |
17958 | 17958 | Spain | Spain | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 47558632 | 7799 | 151 | TBC | weekly | |
17740 | 17740 | Spain | Spain | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 47558632 | 7800 | 0 | TBC | weekly | |
17845 | 17845 | Spain | Spain | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 47558632 | 7801 | 0 | TBC | weekly | |
17637 | 17637 | Spain | Spain | 0 | 2015-04-20 | 2015-04-26 | 7 | 2015 | 17 | 47558632 | 7802 | 0 | TBC | weekly | |
17739 | 17739 | Spain | Spain | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 47558632 | 7814 | 0 | TBC | weekly | |
17749 | 17749 | Spain | Spain | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 47558632 | 7819 | 0 | TBC | weekly | |
17978 | 17978 | Spain | Spain | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 47558632 | 7821 | 136 | TBC | weekly | |
17738 | 17738 | Spain | Spain | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 47558632 | 7827 | 0 | TBC | weekly | |
17911 | 17911 | Spain | Spain | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 47558632 | 7827 | 12 | TBC | weekly | |
17668 | 17668 | Spain | Spain | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 47558632 | 7849 | 0 | TBC | weekly | |
17636 | 17636 | Spain | Spain | 0 | 2015-04-13 | 2015-04-19 | 7 | 2015 | 16 | 47558632 | 7855 | 0 | TBC | weekly | |
17688 | 17688 | Spain | Spain | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 47558632 | 7859 | 0 | TBC | weekly | |
17951 | 17951 | Spain | Spain | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 47558632 | 7867 | 625 | TBC | weekly | |
17737 | 17737 | Spain | Spain | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 47558632 | 7875 | 0 | TBC | weekly | |
17915 | 17915 | Spain | Spain | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 47558632 | 7886 | 221 | TBC | weekly | |
17635 | 17635 | Spain | Spain | 0 | 2015-04-06 | 2015-04-12 | 7 | 2015 | 15 | 47558632 | 7894 | 0 | TBC | weekly | |
17970 | 17970 | Spain | Spain | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 47558632 | 7895 | 495 | TBC | weekly | |
17736 | 17736 | Spain | Spain | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 47558632 | 7906 | 0 | TBC | weekly | |
17825 | 17825 | Spain | Spain | 0 | 2018-11-26 | 2018-12-02 | 7 | 2018 | 48 | 47558632 | 7929 | 0 | TBC | weekly | |
17824 | 17824 | Spain | Spain | 0 | 2018-11-19 | 2018-11-25 | 7 | 2018 | 47 | 47558632 | 7932 | 0 | TBC | weekly | |
17969 | 17969 | Spain | Spain | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 47558632 | 7936 | 795 | TBC | weekly | |
18026 | 18026 | Spain | Spain | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 47558632 | 7936 | 289 | TBC | weekly | |
17949 | 17949 | Spain | Spain | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 47558632 | 7947 | 653 | TBC | weekly | |
17916 | 17916 | Spain | Spain | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 47558632 | 7954 | 173 | TBC | weekly | |
17750 | 17750 | Spain | Spain | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 47558632 | 7991 | 0 | TBC | weekly | |
17687 | 17687 | Spain | Spain | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 47558632 | 7998 | 0 | TBC | weekly | |
17918 | 17918 | Spain | Spain | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 47558632 | 7998 | 329 | 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]);