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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17895 | 17895 | Spain | Spain | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 47558632 | 20967 | 5838 | TBC | weekly | |
17894 | 17894 | Spain | Spain | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 47558632 | 19828 | 5031 | TBC | weekly | |
17896 | 17896 | Spain | Spain | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 47558632 | 17325 | 4568 | TBC | weekly | |
17897 | 17897 | Spain | Spain | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 47558632 | 13244 | 3244 | TBC | weekly | |
17937 | 17937 | Spain | Spain | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 47558632 | 12950 | 2127 | TBC | weekly | |
17893 | 17893 | Spain | Spain | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 47558632 | 12843 | 1483 | TBC | weekly | |
17938 | 17938 | Spain | Spain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 47558632 | 12701 | 2878 | TBC | weekly | |
17936 | 17936 | Spain | Spain | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 47558632 | 11858 | 1440 | TBC | weekly | |
17939 | 17939 | Spain | Spain | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 47558632 | 11571 | 3067 | TBC | weekly | |
17727 | 17727 | Spain | Spain | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 47558632 | 11414 | 0 | TBC | weekly | |
17728 | 17728 | Spain | Spain | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 47558632 | 11334 | 0 | TBC | weekly | |
17990 | 17990 | Spain | Spain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 47558632 | 11225 | 1225 | TBC | weekly | |
17778 | 17778 | Spain | Spain | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 47558632 | 11204 | 0 | TBC | weekly | |
17729 | 17729 | Spain | Spain | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 47558632 | 11068 | 0 | TBC | weekly | |
17625 | 17625 | Spain | Spain | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 47558632 | 11046 | 0 | TBC | weekly | |
17780 | 17780 | Spain | Spain | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 47558632 | 10981 | 0 | TBC | weekly | |
18015 | 18015 | Spain | Spain | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 47558632 | 10962 | 839 | TBC | weekly | |
17779 | 17779 | Spain | Spain | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 47558632 | 10905 | 0 | TBC | weekly | |
17991 | 17991 | Spain | Spain | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 47558632 | 10897 | 1074 | TBC | weekly | |
18014 | 18014 | Spain | Spain | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 47558632 | 10875 | 618 | TBC | weekly | |
17627 | 17627 | Spain | Spain | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 47558632 | 10857 | 0 | TBC | weekly | |
17989 | 17989 | Spain | Spain | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 47558632 | 10847 | 982 | TBC | weekly | |
17623 | 17623 | Spain | Spain | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 47558632 | 10738 | 0 | TBC | weekly | |
17726 | 17726 | Spain | Spain | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 47558632 | 10726 | 0 | TBC | weekly | |
17988 | 17988 | Spain | Spain | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 47558632 | 10688 | 825 | TBC | weekly | |
17626 | 17626 | Spain | Spain | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 47558632 | 10682 | 0 | TBC | weekly | |
17730 | 17730 | Spain | Spain | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 47558632 | 10636 | 0 | TBC | weekly | |
17624 | 17624 | Spain | Spain | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 47558632 | 10625 | 0 | TBC | weekly | |
17628 | 17628 | Spain | Spain | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 47558632 | 10580 | 0 | TBC | weekly | |
17832 | 17832 | Spain | Spain | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 47558632 | 10476 | 0 | TBC | weekly | |
17935 | 17935 | Spain | Spain | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 47558632 | 10470 | 1037 | TBC | weekly | |
17898 | 17898 | Spain | Spain | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 47558632 | 10452 | 2737 | TBC | weekly | |
17622 | 17622 | Spain | Spain | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 47558632 | 10415 | 0 | TBC | weekly | |
17777 | 17777 | Spain | Spain | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 47558632 | 10412 | 0 | TBC | weekly | |
17940 | 17940 | Spain | Spain | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 47558632 | 10368 | 3361 | TBC | weekly | |
17781 | 17781 | Spain | Spain | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 47558632 | 10324 | 0 | TBC | weekly | |
17926 | 17926 | Spain | Spain | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 47558632 | 10316 | 2955 | TBC | weekly | |
17833 | 17833 | Spain | Spain | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 47558632 | 10141 | 0 | TBC | weekly | |
17784 | 17784 | Spain | Spain | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 47558632 | 10105 | 0 | TBC | weekly | |
17629 | 17629 | Spain | Spain | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 47558632 | 10058 | 0 | TBC | weekly | |
17927 | 17927 | Spain | Spain | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 47558632 | 10030 | 1936 | TBC | weekly | |
17992 | 17992 | Spain | Spain | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 47558632 | 10026 | 1955 | TBC | weekly | |
17831 | 17831 | Spain | Spain | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 47558632 | 10025 | 0 | TBC | weekly | |
17783 | 17783 | Spain | Spain | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 47558632 | 10015 | 0 | TBC | weekly | |
17886 | 17886 | Spain | Spain | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 47558632 | 9974 | 0 | TBC | weekly | |
17834 | 17834 | Spain | Spain | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 47558632 | 9964 | 0 | TBC | weekly | |
17885 | 17885 | Spain | Spain | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 47558632 | 9954 | 0 | TBC | weekly | |
17987 | 17987 | Spain | Spain | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 47558632 | 9929 | 529 | TBC | weekly | |
17884 | 17884 | Spain | Spain | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 47558632 | 9917 | 0 | TBC | weekly | |
18016 | 18016 | Spain | Spain | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 47558632 | 9896 | 532 | TBC | weekly | |
17782 | 17782 | Spain | Spain | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 47558632 | 9893 | 0 | TBC | weekly | |
17725 | 17725 | Spain | Spain | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 47558632 | 9855 | 0 | TBC | weekly | |
17986 | 17986 | Spain | Spain | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 47558632 | 9833 | 386 | TBC | weekly | |
17985 | 17985 | Spain | Spain | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 47558632 | 9780 | 311 | TBC | weekly | |
17928 | 17928 | Spain | Spain | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 47558632 | 9695 | 1850 | TBC | weekly | |
17835 | 17835 | Spain | Spain | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 47558632 | 9686 | 0 | TBC | weekly | |
17731 | 17731 | Spain | Spain | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 47558632 | 9660 | 0 | TBC | weekly | |
17785 | 17785 | Spain | Spain | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 47558632 | 9656 | 0 | TBC | weekly | |
17776 | 17776 | Spain | Spain | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 47558632 | 9628 | 0 | TBC | weekly | |
17621 | 17621 | Spain | Spain | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 47558632 | 9605 | 0 | TBC | weekly | |
17786 | 17786 | Spain | Spain | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 47558632 | 9599 | 0 | TBC | weekly | |
17925 | 17925 | Spain | Spain | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 47558632 | 9596 | 1126 | TBC | weekly | |
17930 | 17930 | Spain | Spain | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 47558632 | 9541 | 1584 | TBC | weekly | |
17929 | 17929 | Spain | Spain | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 47558632 | 9534 | 2049 | TBC | weekly | |
17931 | 17931 | Spain | Spain | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 47558632 | 9534 | 1372 | TBC | weekly | |
17934 | 17934 | Spain | Spain | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 47558632 | 9524 | 1013 | TBC | weekly | |
17984 | 17984 | Spain | Spain | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 47558632 | 9503 | 327 | TBC | weekly | |
17941 | 17941 | Spain | Spain | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 47558632 | 9488 | 2354 | TBC | weekly | |
17892 | 17892 | Spain | Spain | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 47558632 | 9481 | 272 | TBC | weekly | |
17924 | 17924 | Spain | Spain | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 47558632 | 9470 | 977 | TBC | weekly | |
17630 | 17630 | Spain | Spain | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 47558632 | 9421 | 0 | TBC | weekly | |
18017 | 18017 | Spain | Spain | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 47558632 | 9416 | 381 | TBC | weekly | |
17883 | 17883 | Spain | Spain | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 47558632 | 9398 | 0 | TBC | weekly | |
17982 | 17982 | Spain | Spain | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 47558632 | 9386 | 204 | TBC | weekly | |
17836 | 17836 | Spain | Spain | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 47558632 | 9363 | 0 | TBC | weekly | |
18010 | 18010 | Spain | Spain | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 47558632 | 9353 | 374 | TBC | weekly | |
18018 | 18018 | Spain | Spain | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 47558632 | 9295 | 573 | TBC | weekly | |
17932 | 17932 | Spain | Spain | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 47558632 | 9287 | 1302 | TBC | weekly | |
17993 | 17993 | Spain | Spain | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 47558632 | 9274 | 2003 | TBC | weekly | |
17775 | 17775 | Spain | Spain | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 47558632 | 9262 | 0 | TBC | weekly | |
17837 | 17837 | Spain | Spain | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 47558632 | 9216 | 0 | TBC | weekly | |
17787 | 17787 | Spain | Spain | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 47558632 | 9203 | 0 | TBC | weekly | |
17887 | 17887 | Spain | Spain | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 47558632 | 9192 | 0 | TBC | weekly | |
17830 | 17830 | Spain | Spain | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 47558632 | 9127 | 0 | TBC | weekly | |
18013 | 18013 | Spain | Spain | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 47558632 | 9102 | 619 | TBC | weekly | |
17942 | 17942 | Spain | Spain | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 47558632 | 9032 | 2041 | TBC | weekly | |
17732 | 17732 | Spain | Spain | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 47558632 | 9017 | 0 | TBC | weekly | |
17983 | 17983 | Spain | Spain | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 47558632 | 9017 | 222 | TBC | weekly | |
17933 | 17933 | Spain | Spain | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 47558632 | 9015 | 898 | TBC | weekly | |
17899 | 17899 | Spain | Spain | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 47558632 | 9008 | 2074 | TBC | weekly | |
17724 | 17724 | Spain | Spain | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 47558632 | 8980 | 0 | TBC | weekly | |
17994 | 17994 | Spain | Spain | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 47558632 | 8944 | 1412 | TBC | weekly | |
17838 | 17838 | Spain | Spain | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 47558632 | 8920 | 0 | TBC | weekly | |
18006 | 18006 | Spain | Spain | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 47558632 | 8908 | 508 | TBC | weekly | |
17788 | 17788 | Spain | Spain | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 47558632 | 8862 | 0 | TBC | weekly | |
17966 | 17966 | Spain | Spain | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 47558632 | 8860 | 464 | TBC | weekly | |
17981 | 17981 | Spain | Spain | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 47558632 | 8846 | 145 | TBC | weekly | |
17888 | 17888 | Spain | Spain | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 47558632 | 8839 | 0 | TBC | weekly | |
18005 | 18005 | Spain | Spain | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 47558632 | 8819 | 575 | TBC | weekly | |
17684 | 17684 | Spain | Spain | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 47558632 | 8811 | 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]);