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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17621 | 17621 | Spain | Spain | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 47558632 | 9605 | 0 | TBC | weekly | |
17674 | 17674 | Spain | Spain | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 47558632 | 8658 | 0 | TBC | weekly | |
17726 | 17726 | Spain | Spain | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 47558632 | 10726 | 0 | TBC | weekly | |
17778 | 17778 | Spain | Spain | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 47558632 | 11204 | 0 | TBC | weekly | |
17830 | 17830 | Spain | Spain | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 47558632 | 9127 | 0 | TBC | weekly | |
17882 | 17882 | Spain | Spain | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 47558632 | 8710 | 0 | TBC | weekly | |
17935 | 17935 | Spain | Spain | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 47558632 | 10470 | 1037 | TBC | weekly | |
17987 | 17987 | Spain | Spain | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 47558632 | 9929 | 529 | TBC | weekly | |
17622 | 17622 | Spain | Spain | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 47558632 | 10415 | 0 | TBC | weekly | |
17675 | 17675 | Spain | Spain | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 47558632 | 8671 | 0 | TBC | weekly | |
17727 | 17727 | Spain | Spain | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 47558632 | 11414 | 0 | TBC | weekly | |
17779 | 17779 | Spain | Spain | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 47558632 | 10905 | 0 | TBC | weekly | |
17831 | 17831 | Spain | Spain | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 47558632 | 10025 | 0 | TBC | weekly | |
17883 | 17883 | Spain | Spain | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 47558632 | 9398 | 0 | TBC | weekly | |
17936 | 17936 | Spain | Spain | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 47558632 | 11858 | 1440 | TBC | weekly | |
17988 | 17988 | Spain | Spain | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 47558632 | 10688 | 825 | TBC | weekly | |
17623 | 17623 | Spain | Spain | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 47558632 | 10738 | 0 | TBC | weekly | |
17676 | 17676 | Spain | Spain | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 47558632 | 8791 | 0 | TBC | weekly | |
17728 | 17728 | Spain | Spain | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 47558632 | 11334 | 0 | TBC | weekly | |
17780 | 17780 | Spain | Spain | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 47558632 | 10981 | 0 | TBC | weekly | |
17832 | 17832 | Spain | Spain | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 47558632 | 10476 | 0 | TBC | weekly | |
17884 | 17884 | Spain | Spain | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 47558632 | 9917 | 0 | TBC | weekly | |
17937 | 17937 | Spain | Spain | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 47558632 | 12950 | 2127 | TBC | weekly | |
17989 | 17989 | Spain | Spain | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 47558632 | 10847 | 982 | TBC | weekly | |
17624 | 17624 | Spain | Spain | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 47558632 | 10625 | 0 | TBC | weekly | |
17677 | 17677 | Spain | Spain | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 47558632 | 8491 | 0 | TBC | weekly | |
17729 | 17729 | Spain | Spain | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 47558632 | 11068 | 0 | TBC | weekly | |
17781 | 17781 | Spain | Spain | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 47558632 | 10324 | 0 | TBC | weekly | |
17833 | 17833 | Spain | Spain | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 47558632 | 10141 | 0 | TBC | weekly | |
17885 | 17885 | Spain | Spain | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 47558632 | 9954 | 0 | TBC | weekly | |
17938 | 17938 | Spain | Spain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 47558632 | 12701 | 2878 | TBC | weekly | |
17990 | 17990 | Spain | Spain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 47558632 | 11225 | 1225 | TBC | weekly | |
17625 | 17625 | Spain | Spain | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 47558632 | 11046 | 0 | TBC | weekly | |
17678 | 17678 | Spain | Spain | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 47558632 | 8461 | 0 | TBC | weekly | |
17730 | 17730 | Spain | Spain | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 47558632 | 10636 | 0 | TBC | weekly | |
17782 | 17782 | Spain | Spain | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 47558632 | 9893 | 0 | TBC | weekly | |
17834 | 17834 | Spain | Spain | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 47558632 | 9964 | 0 | TBC | weekly | |
17886 | 17886 | Spain | Spain | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 47558632 | 9974 | 0 | TBC | weekly | |
17939 | 17939 | Spain | Spain | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 47558632 | 11571 | 3067 | TBC | weekly | |
17991 | 17991 | Spain | Spain | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 47558632 | 10897 | 1074 | TBC | weekly | |
17626 | 17626 | Spain | Spain | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 47558632 | 10682 | 0 | TBC | weekly | |
17679 | 17679 | Spain | Spain | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 47558632 | 8556 | 0 | TBC | weekly | |
17731 | 17731 | Spain | Spain | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 47558632 | 9660 | 0 | TBC | weekly | |
17783 | 17783 | Spain | Spain | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 47558632 | 10015 | 0 | TBC | weekly | |
17835 | 17835 | Spain | Spain | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 47558632 | 9686 | 0 | TBC | weekly | |
17887 | 17887 | Spain | Spain | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 47558632 | 9192 | 0 | TBC | weekly | |
17940 | 17940 | Spain | Spain | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 47558632 | 10368 | 3361 | TBC | weekly | |
17992 | 17992 | Spain | Spain | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 47558632 | 10026 | 1955 | TBC | weekly | |
17627 | 17627 | Spain | Spain | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 47558632 | 10857 | 0 | TBC | weekly | |
17680 | 17680 | Spain | Spain | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 47558632 | 8479 | 0 | TBC | weekly | |
17732 | 17732 | Spain | Spain | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 47558632 | 9017 | 0 | TBC | weekly | |
17784 | 17784 | Spain | Spain | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 47558632 | 10105 | 0 | TBC | weekly | |
17836 | 17836 | Spain | Spain | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 47558632 | 9363 | 0 | TBC | weekly | |
17888 | 17888 | Spain | Spain | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 47558632 | 8839 | 0 | TBC | weekly | |
17941 | 17941 | Spain | Spain | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 47558632 | 9488 | 2354 | TBC | weekly | |
17993 | 17993 | Spain | Spain | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 47558632 | 9274 | 2003 | TBC | weekly | |
17628 | 17628 | Spain | Spain | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 47558632 | 10580 | 0 | TBC | weekly | |
17681 | 17681 | Spain | Spain | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 47558632 | 8670 | 0 | TBC | weekly | |
17733 | 17733 | Spain | Spain | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 47558632 | 8670 | 0 | TBC | weekly | |
17785 | 17785 | Spain | Spain | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 47558632 | 9656 | 0 | TBC | weekly | |
17837 | 17837 | Spain | Spain | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 47558632 | 9216 | 0 | TBC | weekly | |
17889 | 17889 | Spain | Spain | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 47558632 | 8413 | 0 | TBC | weekly | |
17942 | 17942 | Spain | Spain | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 47558632 | 9032 | 2041 | TBC | weekly | |
17994 | 17994 | Spain | Spain | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 47558632 | 8944 | 1412 | TBC | weekly | |
17629 | 17629 | Spain | Spain | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 47558632 | 10058 | 0 | TBC | weekly | |
17682 | 17682 | Spain | Spain | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 47558632 | 8645 | 0 | TBC | weekly | |
17734 | 17734 | Spain | Spain | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 47558632 | 8371 | 0 | TBC | weekly | |
17786 | 17786 | Spain | Spain | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 47558632 | 9599 | 0 | TBC | weekly | |
17838 | 17838 | Spain | Spain | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 47558632 | 8920 | 0 | TBC | weekly | |
17890 | 17890 | Spain | Spain | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 47558632 | 8379 | 0 | TBC | weekly | |
17943 | 17943 | Spain | Spain | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 47558632 | 8542 | 1996 | TBC | weekly | |
17995 | 17995 | Spain | Spain | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 47558632 | 8632 | 1003 | TBC | weekly | |
17630 | 17630 | Spain | Spain | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 47558632 | 9421 | 0 | TBC | weekly | |
17683 | 17683 | Spain | Spain | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 47558632 | 8653 | 0 | TBC | weekly | |
17735 | 17735 | Spain | Spain | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 47558632 | 8213 | 0 | TBC | weekly | |
17787 | 17787 | Spain | Spain | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 47558632 | 9203 | 0 | TBC | weekly | |
17839 | 17839 | Spain | Spain | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 47558632 | 8595 | 0 | TBC | weekly | |
17891 | 17891 | Spain | Spain | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 47558632 | 8465 | 17 | TBC | weekly | |
17944 | 17944 | Spain | Spain | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 47558632 | 8318 | 1120 | TBC | weekly | |
17996 | 17996 | Spain | Spain | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 47558632 | 8505 | 722 | TBC | weekly | |
17631 | 17631 | Spain | Spain | 0 | 2015-03-09 | 2015-03-15 | 7 | 2015 | 11 | 47558632 | 8785 | 0 | TBC | weekly | |
17684 | 17684 | Spain | Spain | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 47558632 | 8811 | 0 | TBC | weekly | |
17736 | 17736 | Spain | Spain | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 47558632 | 7906 | 0 | TBC | weekly | |
17788 | 17788 | Spain | Spain | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 47558632 | 8862 | 0 | TBC | weekly | |
17840 | 17840 | Spain | Spain | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 47558632 | 8205 | 0 | TBC | weekly | |
17892 | 17892 | Spain | Spain | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 47558632 | 9481 | 272 | TBC | weekly | |
17945 | 17945 | Spain | Spain | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 47558632 | 8077 | 652 | TBC | weekly | |
17997 | 17997 | Spain | Spain | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 47558632 | 8531 | 568 | TBC | weekly | |
17632 | 17632 | Spain | Spain | 0 | 2015-03-16 | 2015-03-22 | 7 | 2015 | 12 | 47558632 | 8379 | 0 | TBC | weekly | |
17685 | 17685 | Spain | Spain | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 47558632 | 8291 | 0 | TBC | weekly | |
17737 | 17737 | Spain | Spain | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 47558632 | 7875 | 0 | TBC | weekly | |
17789 | 17789 | Spain | Spain | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 47558632 | 8616 | 0 | TBC | weekly | |
17841 | 17841 | Spain | Spain | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 47558632 | 8027 | 0 | TBC | weekly | |
17893 | 17893 | Spain | Spain | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 47558632 | 12843 | 1483 | TBC | weekly | |
17946 | 17946 | Spain | Spain | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 47558632 | 8189 | 2100 | TBC | weekly | |
17998 | 17998 | Spain | Spain | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 47558632 | 8543 | 689 | TBC | weekly | |
17633 | 17633 | Spain | Spain | 0 | 2015-03-23 | 2015-03-29 | 7 | 2015 | 13 | 47558632 | 8366 | 0 | TBC | weekly | |
17686 | 17686 | Spain | Spain | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 47558632 | 8375 | 0 | TBC | weekly | |
17738 | 17738 | Spain | Spain | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 47558632 | 7827 | 0 | TBC | weekly | |
17790 | 17790 | Spain | Spain | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 47558632 | 8628 | 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]);