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)
Suggested facets: year, end_date (date)
start_date (date) >30 ✖
- 2014-12-29 1
- 2015-01-05 1
- 2015-01-12 1
- 2015-01-19 1
- 2015-01-26 1
- 2015-02-02 1
- 2015-02-09 1
- 2015-02-16 1
- 2015-02-23 1
- 2015-03-02 1
- 2015-03-09 1
- 2015-03-16 1
- 2015-03-23 1
- 2015-03-30 1
- 2015-04-06 1
- 2015-04-13 1
- 2015-04-20 1
- 2015-04-27 1
- 2015-05-04 1
- 2015-05-11 1
- 2015-05-18 1
- 2015-05-25 1
- 2015-06-01 1
- 2015-06-08 1
- 2015-06-15 1
- 2015-06-22 1
- 2015-06-29 1
- 2015-07-06 1
- 2015-07-13 1
- 2015-07-20 1
- …
country 1
- Spain · 409 ✖
cadence 1
- weekly 409
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths ▼ | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17656 | 17656 | Spain | Spain | 0 | 2015-08-31 | 2015-09-06 | 7 | 2015 | 36 | 47558632 | 6603 | 0 | TBC | weekly | |
17658 | 17658 | Spain | Spain | 0 | 2015-09-14 | 2015-09-20 | 7 | 2015 | 38 | 47558632 | 6617 | 0 | TBC | weekly | |
17710 | 17710 | Spain | Spain | 0 | 2016-09-12 | 2016-09-18 | 7 | 2016 | 37 | 47558632 | 6641 | 0 | TBC | weekly | |
17657 | 17657 | Spain | Spain | 0 | 2015-09-07 | 2015-09-13 | 7 | 2015 | 37 | 47558632 | 6660 | 0 | TBC | weekly | |
17761 | 17761 | Spain | Spain | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 47558632 | 6680 | 0 | TBC | weekly | |
17762 | 17762 | Spain | Spain | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 47558632 | 6730 | 0 | TBC | weekly | |
17654 | 17654 | Spain | Spain | 0 | 2015-08-17 | 2015-08-23 | 7 | 2015 | 34 | 47558632 | 6801 | 0 | TBC | weekly | |
17660 | 17660 | Spain | Spain | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 47558632 | 6813 | 0 | TBC | weekly | |
17814 | 17814 | Spain | Spain | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 47558632 | 6834 | 0 | TBC | weekly | |
17905 | 17905 | Spain | Spain | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 47558632 | 6849 | 0 | TBC | weekly | |
17659 | 17659 | Spain | Spain | 0 | 2015-09-21 | 2015-09-27 | 7 | 2015 | 39 | 47558632 | 6898 | 0 | TBC | weekly | |
17864 | 17864 | Spain | Spain | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 47558632 | 6898 | 0 | TBC | weekly | |
17865 | 17865 | Spain | Spain | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 47558632 | 6904 | 0 | TBC | weekly | |
17813 | 17813 | Spain | Spain | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 47558632 | 6906 | 0 | TBC | weekly | |
17863 | 17863 | Spain | Spain | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 47558632 | 6920 | 0 | TBC | weekly | |
17812 | 17812 | Spain | Spain | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 47558632 | 6927 | 0 | TBC | weekly | |
17866 | 17866 | Spain | Spain | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 47558632 | 6939 | 0 | TBC | weekly | |
17655 | 17655 | Spain | Spain | 0 | 2015-08-24 | 2015-08-30 | 7 | 2015 | 35 | 47558632 | 6954 | 0 | TBC | weekly | |
17645 | 17645 | Spain | Spain | 0 | 2015-06-15 | 2015-06-21 | 7 | 2015 | 25 | 47558632 | 6956 | 0 | TBC | weekly | |
17711 | 17711 | Spain | Spain | 0 | 2016-09-19 | 2016-09-25 | 7 | 2016 | 38 | 47558632 | 6956 | 0 | TBC | weekly | |
17869 | 17869 | Spain | Spain | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 47558632 | 6978 | 0 | TBC | weekly | |
17867 | 17867 | Spain | Spain | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 47558632 | 6996 | 0 | TBC | weekly | |
17760 | 17760 | Spain | Spain | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 47558632 | 7013 | 0 | TBC | weekly | |
17811 | 17811 | Spain | Spain | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 47558632 | 7015 | 0 | TBC | weekly | |
17853 | 17853 | Spain | Spain | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 47558632 | 7016 | 0 | TBC | weekly | |
17868 | 17868 | Spain | Spain | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 47558632 | 7027 | 0 | TBC | weekly | |
17906 | 17906 | Spain | Spain | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 47558632 | 7032 | 8 | TBC | weekly | |
17712 | 17712 | Spain | Spain | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 47558632 | 7036 | 0 | TBC | weekly | |
17714 | 17714 | Spain | Spain | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 47558632 | 7036 | 0 | TBC | weekly | |
17661 | 17661 | Spain | Spain | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 47558632 | 7055 | 0 | TBC | weekly | |
17748 | 17748 | Spain | Spain | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 47558632 | 7067 | 0 | TBC | weekly | |
17713 | 17713 | Spain | Spain | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 47558632 | 7072 | 0 | TBC | weekly | |
17653 | 17653 | Spain | Spain | 0 | 2015-08-10 | 2015-08-16 | 7 | 2015 | 33 | 47558632 | 7075 | 0 | TBC | weekly | |
17763 | 17763 | Spain | Spain | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 47558632 | 7091 | 0 | TBC | weekly | |
17747 | 17747 | Spain | Spain | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 47558632 | 7092 | 0 | TBC | weekly | |
17642 | 17642 | Spain | Spain | 0 | 2015-05-25 | 2015-05-31 | 7 | 2015 | 22 | 47558632 | 7096 | 0 | TBC | weekly | |
17708 | 17708 | Spain | Spain | 0 | 2016-08-29 | 2016-09-04 | 7 | 2016 | 35 | 47558632 | 7100 | 0 | TBC | weekly | |
17706 | 17706 | Spain | Spain | 0 | 2016-08-15 | 2016-08-21 | 7 | 2016 | 33 | 47558632 | 7102 | 0 | TBC | weekly | |
17800 | 17800 | Spain | Spain | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 47558632 | 7109 | 0 | TBC | weekly | |
17755 | 17755 | Spain | Spain | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 47558632 | 7110 | 0 | TBC | weekly | |
17646 | 17646 | Spain | Spain | 0 | 2015-06-22 | 2015-06-28 | 7 | 2015 | 26 | 47558632 | 7111 | 0 | TBC | weekly | |
17758 | 17758 | Spain | Spain | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 47558632 | 7118 | 0 | TBC | weekly | |
17662 | 17662 | Spain | Spain | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 47558632 | 7119 | 0 | TBC | weekly | |
17862 | 17862 | Spain | Spain | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 47558632 | 7128 | 0 | TBC | weekly | |
17860 | 17860 | Spain | Spain | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 47558632 | 7136 | 0 | TBC | weekly | |
17751 | 17751 | Spain | Spain | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 47558632 | 7137 | 0 | TBC | weekly | |
17697 | 17697 | Spain | Spain | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 47558632 | 7140 | 0 | TBC | weekly | |
17904 | 17904 | Spain | Spain | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 47558632 | 7144 | 9 | TBC | weekly | |
17644 | 17644 | Spain | Spain | 0 | 2015-06-08 | 2015-06-14 | 7 | 2015 | 24 | 47558632 | 7152 | 0 | TBC | weekly | |
17815 | 17815 | Spain | Spain | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 47558632 | 7153 | 0 | TBC | weekly | |
17801 | 17801 | Spain | Spain | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 47558632 | 7154 | 0 | TBC | weekly | |
17807 | 17807 | Spain | Spain | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 47558632 | 7155 | 0 | TBC | weekly | |
17752 | 17752 | Spain | Spain | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 47558632 | 7156 | 0 | TBC | weekly | |
17698 | 17698 | Spain | Spain | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 47558632 | 7173 | 0 | TBC | weekly | |
17707 | 17707 | Spain | Spain | 0 | 2016-08-22 | 2016-08-28 | 7 | 2016 | 34 | 47558632 | 7184 | 0 | TBC | weekly | |
17715 | 17715 | Spain | Spain | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 47558632 | 7185 | 0 | TBC | weekly | |
17757 | 17757 | Spain | Spain | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 47558632 | 7186 | 0 | TBC | weekly | |
17806 | 17806 | Spain | Spain | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 47558632 | 7186 | 0 | TBC | weekly | |
17810 | 17810 | Spain | Spain | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 47558632 | 7194 | 0 | TBC | weekly | |
17709 | 17709 | Spain | Spain | 0 | 2016-09-05 | 2016-09-11 | 7 | 2016 | 36 | 47558632 | 7203 | 0 | TBC | weekly | |
17817 | 17817 | Spain | Spain | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 47558632 | 7210 | 0 | TBC | weekly | |
17753 | 17753 | Spain | Spain | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 47558632 | 7214 | 0 | TBC | weekly | |
17652 | 17652 | Spain | Spain | 0 | 2015-08-03 | 2015-08-09 | 7 | 2015 | 32 | 47558632 | 7219 | 0 | TBC | weekly | |
17759 | 17759 | Spain | Spain | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 47558632 | 7219 | 0 | TBC | weekly | |
17816 | 17816 | Spain | Spain | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 47558632 | 7230 | 0 | TBC | weekly | |
17705 | 17705 | Spain | Spain | 0 | 2016-08-08 | 2016-08-14 | 7 | 2016 | 32 | 47558632 | 7233 | 0 | TBC | weekly | |
17641 | 17641 | Spain | Spain | 0 | 2015-05-18 | 2015-05-24 | 7 | 2015 | 21 | 47558632 | 7234 | 0 | TBC | weekly | |
17766 | 17766 | Spain | Spain | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 47558632 | 7234 | 0 | TBC | weekly | |
17717 | 17717 | Spain | Spain | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 47558632 | 7244 | 0 | TBC | weekly | |
17695 | 17695 | Spain | Spain | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 47558632 | 7255 | 0 | TBC | weekly | |
17754 | 17754 | Spain | Spain | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 47558632 | 7259 | 0 | TBC | weekly | |
17663 | 17663 | Spain | Spain | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 47558632 | 7267 | 0 | TBC | weekly | |
17959 | 17959 | Spain | Spain | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 47558632 | 7285 | 127 | TBC | weekly | |
17703 | 17703 | Spain | Spain | 0 | 2016-07-25 | 2016-07-31 | 7 | 2016 | 30 | 47558632 | 7295 | 0 | TBC | weekly | |
17858 | 17858 | Spain | Spain | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 47558632 | 7301 | 0 | TBC | weekly | |
17694 | 17694 | Spain | Spain | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 47558632 | 7304 | 0 | TBC | weekly | |
17804 | 17804 | Spain | Spain | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 47558632 | 7305 | 0 | TBC | weekly | |
17799 | 17799 | Spain | Spain | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 47558632 | 7306 | 0 | TBC | weekly | |
17768 | 17768 | Spain | Spain | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 47558632 | 7308 | 0 | TBC | weekly | |
17870 | 17870 | Spain | Spain | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 47558632 | 7312 | 0 | TBC | weekly | |
17871 | 17871 | Spain | Spain | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 47558632 | 7314 | 0 | TBC | weekly | |
17861 | 17861 | Spain | Spain | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 47558632 | 7317 | 0 | TBC | weekly | |
17666 | 17666 | Spain | Spain | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 47558632 | 7325 | 0 | TBC | weekly | |
17820 | 17820 | Spain | Spain | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 47558632 | 7327 | 0 | TBC | weekly | |
17699 | 17699 | Spain | Spain | 0 | 2016-06-27 | 2016-07-03 | 7 | 2016 | 26 | 47558632 | 7345 | 0 | TBC | weekly | |
17651 | 17651 | Spain | Spain | 0 | 2015-07-27 | 2015-08-02 | 7 | 2015 | 31 | 47558632 | 7349 | 0 | TBC | weekly | |
17819 | 17819 | Spain | Spain | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 47558632 | 7350 | 0 | TBC | weekly | |
17956 | 17956 | Spain | Spain | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 47558632 | 7353 | 291 | TBC | weekly | |
17795 | 17795 | Spain | Spain | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 47558632 | 7359 | 0 | TBC | weekly | |
17643 | 17643 | Spain | Spain | 0 | 2015-06-01 | 2015-06-07 | 7 | 2015 | 23 | 47558632 | 7364 | 0 | TBC | weekly | |
17638 | 17638 | Spain | Spain | 0 | 2015-04-27 | 2015-05-03 | 7 | 2015 | 18 | 47558632 | 7365 | 0 | TBC | weekly | |
17805 | 17805 | Spain | Spain | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 47558632 | 7366 | 0 | TBC | weekly | |
17764 | 17764 | Spain | Spain | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 47558632 | 7367 | 0 | TBC | weekly | |
17692 | 17692 | Spain | Spain | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 47558632 | 7374 | 0 | TBC | weekly | |
17702 | 17702 | Spain | Spain | 0 | 2016-07-18 | 2016-07-24 | 7 | 2016 | 29 | 47558632 | 7377 | 0 | TBC | weekly | |
17765 | 17765 | Spain | Spain | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 47558632 | 7388 | 0 | TBC | weekly | |
17664 | 17664 | Spain | Spain | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 47558632 | 7392 | 0 | TBC | weekly | |
17767 | 17767 | Spain | Spain | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 47558632 | 7392 | 0 | TBC | weekly | |
17667 | 17667 | Spain | Spain | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 47558632 | 7397 | 0 | TBC | weekly | |
17854 | 17854 | Spain | Spain | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 47558632 | 7404 | 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]);