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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, start_date (date), end_date (date)
Link | rowid | country | region | region_code | start_date | end_date | days | year | week ▲ | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17673 | 17673 | Spain | Spain | 0 | 2015-12-28 | 2016-01-03 | 7 | 2015 | 53 | 47558632 | 8427 | 0 | TBC | weekly | |
17934 | 17934 | Spain | Spain | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 47558632 | 9524 | 1013 | TBC | weekly | |
17672 | 17672 | Spain | Spain | 0 | 2015-12-21 | 2015-12-27 | 7 | 2015 | 52 | 47558632 | 8031 | 0 | TBC | weekly | |
17725 | 17725 | Spain | Spain | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 47558632 | 9855 | 0 | TBC | weekly | |
17777 | 17777 | Spain | Spain | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 47558632 | 10412 | 0 | TBC | weekly | |
17829 | 17829 | Spain | Spain | 0 | 2018-12-24 | 2018-12-30 | 7 | 2018 | 52 | 47558632 | 8650 | 0 | TBC | weekly | |
17881 | 17881 | Spain | Spain | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 47558632 | 8333 | 0 | TBC | weekly | |
17933 | 17933 | Spain | Spain | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 47558632 | 9015 | 898 | TBC | weekly | |
17986 | 17986 | Spain | Spain | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 47558632 | 9833 | 386 | TBC | weekly | |
17671 | 17671 | Spain | Spain | 0 | 2015-12-14 | 2015-12-20 | 7 | 2015 | 51 | 47558632 | 8342 | 0 | TBC | weekly | |
17724 | 17724 | Spain | Spain | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 47558632 | 8980 | 0 | TBC | weekly | |
17776 | 17776 | Spain | Spain | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 47558632 | 9628 | 0 | TBC | weekly | |
17828 | 17828 | Spain | Spain | 0 | 2018-12-17 | 2018-12-23 | 7 | 2018 | 51 | 47558632 | 8427 | 0 | TBC | weekly | |
17880 | 17880 | Spain | Spain | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 47558632 | 8393 | 0 | TBC | weekly | |
17932 | 17932 | Spain | Spain | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 47558632 | 9287 | 1302 | TBC | weekly | |
17985 | 17985 | Spain | Spain | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 47558632 | 9780 | 311 | TBC | weekly | |
17670 | 17670 | Spain | Spain | 0 | 2015-12-07 | 2015-12-13 | 7 | 2015 | 50 | 47558632 | 8032 | 0 | TBC | weekly | |
17723 | 17723 | Spain | Spain | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 47558632 | 8612 | 0 | TBC | weekly | |
17775 | 17775 | Spain | Spain | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 47558632 | 9262 | 0 | TBC | weekly | |
17827 | 17827 | Spain | Spain | 0 | 2018-12-10 | 2018-12-16 | 7 | 2018 | 50 | 47558632 | 8312 | 0 | TBC | weekly | |
17879 | 17879 | Spain | Spain | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 47558632 | 8340 | 0 | TBC | weekly | |
17931 | 17931 | Spain | Spain | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 47558632 | 9534 | 1372 | TBC | weekly | |
17984 | 17984 | Spain | Spain | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 47558632 | 9503 | 327 | TBC | weekly | |
17669 | 17669 | Spain | Spain | 0 | 2015-11-30 | 2015-12-06 | 7 | 2015 | 49 | 47558632 | 8080 | 0 | TBC | weekly | |
17722 | 17722 | Spain | Spain | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 47558632 | 8124 | 0 | TBC | weekly | |
17774 | 17774 | Spain | Spain | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 47558632 | 8620 | 0 | TBC | weekly | |
17826 | 17826 | Spain | Spain | 0 | 2018-12-03 | 2018-12-09 | 7 | 2018 | 49 | 47558632 | 8051 | 0 | TBC | weekly | |
17878 | 17878 | Spain | Spain | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 47558632 | 8021 | 0 | TBC | weekly | |
17930 | 17930 | Spain | Spain | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 47558632 | 9541 | 1584 | TBC | weekly | |
17983 | 17983 | Spain | Spain | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 47558632 | 9017 | 222 | TBC | weekly | |
17668 | 17668 | Spain | Spain | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 47558632 | 7849 | 0 | TBC | weekly | |
17721 | 17721 | Spain | Spain | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 47558632 | 8321 | 0 | TBC | weekly | |
17773 | 17773 | Spain | Spain | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 47558632 | 8257 | 0 | TBC | weekly | |
17825 | 17825 | Spain | Spain | 0 | 2018-11-26 | 2018-12-02 | 7 | 2018 | 48 | 47558632 | 7929 | 0 | TBC | weekly | |
17877 | 17877 | Spain | Spain | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 47558632 | 8328 | 0 | TBC | weekly | |
17929 | 17929 | Spain | Spain | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 47558632 | 9534 | 2049 | TBC | weekly | |
17982 | 17982 | Spain | Spain | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 47558632 | 9386 | 204 | TBC | weekly | |
17667 | 17667 | Spain | Spain | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 47558632 | 7397 | 0 | TBC | weekly | |
17720 | 17720 | Spain | Spain | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 47558632 | 8090 | 0 | TBC | weekly | |
17772 | 17772 | Spain | Spain | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 47558632 | 8169 | 0 | TBC | weekly | |
17824 | 17824 | Spain | Spain | 0 | 2018-11-19 | 2018-11-25 | 7 | 2018 | 47 | 47558632 | 7932 | 0 | TBC | weekly | |
17876 | 17876 | Spain | Spain | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 47558632 | 8217 | 0 | TBC | weekly | |
17928 | 17928 | Spain | Spain | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 47558632 | 9695 | 1850 | TBC | weekly | |
17981 | 17981 | Spain | Spain | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 47558632 | 8846 | 145 | TBC | weekly | |
17666 | 17666 | Spain | Spain | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 47558632 | 7325 | 0 | TBC | weekly | |
17719 | 17719 | Spain | Spain | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 47558632 | 8076 | 0 | TBC | weekly | |
17771 | 17771 | Spain | Spain | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 47558632 | 8063 | 0 | TBC | weekly | |
17823 | 17823 | Spain | Spain | 0 | 2018-11-12 | 2018-11-18 | 7 | 2018 | 46 | 47558632 | 7999 | 0 | TBC | weekly | |
17875 | 17875 | Spain | Spain | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 47558632 | 8036 | 0 | TBC | weekly | |
17927 | 17927 | Spain | Spain | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 47558632 | 10030 | 1936 | TBC | weekly | |
17980 | 17980 | Spain | Spain | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 47558632 | 8793 | 137 | TBC | weekly | |
17665 | 17665 | Spain | Spain | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 47558632 | 7412 | 0 | TBC | weekly | |
17718 | 17718 | Spain | Spain | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 47558632 | 7775 | 0 | TBC | weekly | |
17770 | 17770 | Spain | Spain | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 47558632 | 7632 | 0 | TBC | weekly | |
17822 | 17822 | Spain | Spain | 0 | 2018-11-05 | 2018-11-11 | 7 | 2018 | 45 | 47558632 | 8012 | 0 | TBC | weekly | |
17874 | 17874 | Spain | Spain | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 47558632 | 7677 | 0 | TBC | weekly | |
17926 | 17926 | Spain | Spain | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 47558632 | 10316 | 2955 | TBC | weekly | |
17979 | 17979 | Spain | Spain | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 47558632 | 8717 | 169 | TBC | weekly | |
17664 | 17664 | Spain | Spain | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 47558632 | 7392 | 0 | TBC | weekly | |
17717 | 17717 | Spain | Spain | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 47558632 | 7244 | 0 | TBC | weekly | |
17769 | 17769 | Spain | Spain | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 47558632 | 7511 | 0 | TBC | weekly | |
17821 | 17821 | Spain | Spain | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 47558632 | 7794 | 0 | TBC | weekly | |
17873 | 17873 | Spain | Spain | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 47558632 | 7698 | 0 | TBC | weekly | |
17925 | 17925 | Spain | Spain | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 47558632 | 9596 | 1126 | TBC | weekly | |
17978 | 17978 | Spain | Spain | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 47558632 | 7821 | 136 | TBC | weekly | |
17663 | 17663 | Spain | Spain | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 47558632 | 7267 | 0 | TBC | weekly | |
17716 | 17716 | Spain | Spain | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 47558632 | 7512 | 0 | TBC | weekly | |
17768 | 17768 | Spain | Spain | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 47558632 | 7308 | 0 | TBC | weekly | |
17820 | 17820 | Spain | Spain | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 47558632 | 7327 | 0 | TBC | weekly | |
17872 | 17872 | Spain | Spain | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 47558632 | 7543 | 0 | TBC | weekly | |
17924 | 17924 | Spain | Spain | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 47558632 | 9470 | 977 | TBC | weekly | |
17977 | 17977 | Spain | Spain | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 47558632 | 8179 | 236 | TBC | weekly | |
18029 | 18029 | Spain | Spain | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 47558632 | 7635 | 220 | TBC | weekly | |
17662 | 17662 | Spain | Spain | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 47558632 | 7119 | 0 | TBC | weekly | |
17715 | 17715 | Spain | Spain | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 47558632 | 7185 | 0 | TBC | weekly | |
17767 | 17767 | Spain | Spain | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 47558632 | 7392 | 0 | TBC | weekly | |
17819 | 17819 | Spain | Spain | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 47558632 | 7350 | 0 | TBC | weekly | |
17871 | 17871 | Spain | Spain | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 47558632 | 7314 | 0 | TBC | weekly | |
17923 | 17923 | Spain | Spain | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 47558632 | 8594 | 846 | TBC | weekly | |
17976 | 17976 | Spain | Spain | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 47558632 | 7744 | 158 | TBC | weekly | |
18028 | 18028 | Spain | Spain | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 47558632 | 8090 | 221 | TBC | weekly | |
17661 | 17661 | Spain | Spain | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 47558632 | 7055 | 0 | TBC | weekly | |
17714 | 17714 | Spain | Spain | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 47558632 | 7036 | 0 | TBC | weekly | |
17766 | 17766 | Spain | Spain | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 47558632 | 7234 | 0 | TBC | weekly | |
17818 | 17818 | Spain | Spain | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 47558632 | 7437 | 0 | TBC | weekly | |
17870 | 17870 | Spain | Spain | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 47558632 | 7312 | 0 | TBC | weekly | |
17922 | 17922 | Spain | Spain | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 47558632 | 8593 | 843 | TBC | weekly | |
17975 | 17975 | Spain | Spain | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 47558632 | 7586 | 196 | TBC | weekly | |
18027 | 18027 | Spain | Spain | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 47558632 | 7752 | 173 | TBC | weekly | |
17660 | 17660 | Spain | Spain | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 47558632 | 6813 | 0 | TBC | weekly | |
17713 | 17713 | Spain | Spain | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 47558632 | 7072 | 0 | TBC | weekly | |
17765 | 17765 | Spain | Spain | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 47558632 | 7388 | 0 | TBC | weekly | |
17817 | 17817 | Spain | Spain | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 47558632 | 7210 | 0 | TBC | weekly | |
17869 | 17869 | Spain | Spain | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 47558632 | 6978 | 0 | TBC | weekly | |
17921 | 17921 | Spain | Spain | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 47558632 | 8188 | 854 | TBC | weekly | |
17974 | 17974 | Spain | Spain | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 47558632 | 7526 | 315 | TBC | weekly | |
18026 | 18026 | Spain | Spain | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 47558632 | 7936 | 289 | TBC | weekly | |
17659 | 17659 | Spain | Spain | 0 | 2015-09-21 | 2015-09-27 | 7 | 2015 | 39 | 47558632 | 6898 | 0 | TBC | weekly | |
17712 | 17712 | Spain | Spain | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 47558632 | 7036 | 0 | TBC | weekly | |
17764 | 17764 | Spain | Spain | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 47558632 | 7367 | 0 | 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]);