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 expected_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17721 | 17721 | Spain | Spain | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 47558632 | 8321 | 0 | TBC | weekly | |
17722 | 17722 | Spain | Spain | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 47558632 | 8124 | 0 | TBC | weekly | |
17723 | 17723 | Spain | Spain | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 47558632 | 8612 | 0 | TBC | weekly | |
17724 | 17724 | Spain | Spain | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 47558632 | 8980 | 0 | TBC | weekly | |
17725 | 17725 | Spain | Spain | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 47558632 | 9855 | 0 | TBC | weekly | |
17726 | 17726 | Spain | Spain | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 47558632 | 10726 | 0 | 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 | |
17729 | 17729 | Spain | Spain | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 47558632 | 11068 | 0 | TBC | weekly | |
17730 | 17730 | Spain | Spain | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 47558632 | 10636 | 0 | TBC | weekly | |
17731 | 17731 | Spain | Spain | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 47558632 | 9660 | 0 | TBC | weekly | |
17732 | 17732 | Spain | Spain | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 47558632 | 9017 | 0 | TBC | weekly | |
17733 | 17733 | Spain | Spain | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 47558632 | 8670 | 0 | TBC | weekly | |
17734 | 17734 | Spain | Spain | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 47558632 | 8371 | 0 | TBC | weekly | |
17735 | 17735 | Spain | Spain | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 47558632 | 8213 | 0 | TBC | weekly | |
17736 | 17736 | Spain | Spain | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 47558632 | 7906 | 0 | TBC | weekly | |
17737 | 17737 | Spain | Spain | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 47558632 | 7875 | 0 | TBC | weekly | |
17738 | 17738 | Spain | Spain | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 47558632 | 7827 | 0 | TBC | weekly | |
17739 | 17739 | Spain | Spain | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 47558632 | 7814 | 0 | TBC | weekly | |
17740 | 17740 | Spain | Spain | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 47558632 | 7800 | 0 | TBC | weekly | |
17741 | 17741 | Spain | Spain | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 47558632 | 7574 | 0 | TBC | weekly | |
17742 | 17742 | Spain | Spain | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 47558632 | 7661 | 0 | TBC | weekly | |
17743 | 17743 | Spain | Spain | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 47558632 | 7520 | 0 | TBC | weekly | |
17744 | 17744 | Spain | Spain | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 47558632 | 7622 | 0 | TBC | weekly | |
17745 | 17745 | Spain | Spain | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 47558632 | 7494 | 0 | TBC | weekly | |
17746 | 17746 | Spain | Spain | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 47558632 | 7666 | 0 | TBC | weekly | |
17747 | 17747 | Spain | Spain | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 47558632 | 7092 | 0 | TBC | weekly | |
17748 | 17748 | Spain | Spain | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 47558632 | 7067 | 0 | TBC | weekly | |
17749 | 17749 | Spain | Spain | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 47558632 | 7819 | 0 | TBC | weekly | |
17750 | 17750 | Spain | Spain | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 47558632 | 7991 | 0 | TBC | weekly | |
17751 | 17751 | Spain | Spain | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 47558632 | 7137 | 0 | TBC | weekly | |
17752 | 17752 | Spain | Spain | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 47558632 | 7156 | 0 | TBC | weekly | |
17753 | 17753 | Spain | Spain | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 47558632 | 7214 | 0 | TBC | weekly | |
17754 | 17754 | Spain | Spain | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 47558632 | 7259 | 0 | TBC | weekly | |
17755 | 17755 | Spain | Spain | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 47558632 | 7110 | 0 | TBC | weekly | |
17756 | 17756 | Spain | Spain | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 47558632 | 7596 | 0 | TBC | weekly | |
17757 | 17757 | Spain | Spain | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 47558632 | 7186 | 0 | TBC | weekly | |
17758 | 17758 | Spain | Spain | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 47558632 | 7118 | 0 | TBC | weekly | |
17759 | 17759 | Spain | Spain | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 47558632 | 7219 | 0 | TBC | weekly | |
17760 | 17760 | Spain | Spain | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 47558632 | 7013 | 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 | |
17763 | 17763 | Spain | Spain | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 47558632 | 7091 | 0 | TBC | weekly | |
17764 | 17764 | Spain | Spain | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 47558632 | 7367 | 0 | TBC | weekly | |
17765 | 17765 | Spain | Spain | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 47558632 | 7388 | 0 | TBC | weekly | |
17766 | 17766 | Spain | Spain | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 47558632 | 7234 | 0 | TBC | weekly | |
17767 | 17767 | Spain | Spain | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 47558632 | 7392 | 0 | TBC | weekly | |
17768 | 17768 | Spain | Spain | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 47558632 | 7308 | 0 | TBC | weekly | |
17769 | 17769 | Spain | Spain | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 47558632 | 7511 | 0 | TBC | weekly | |
17770 | 17770 | Spain | Spain | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 47558632 | 7632 | 0 | TBC | weekly | |
17771 | 17771 | Spain | Spain | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 47558632 | 8063 | 0 | TBC | weekly | |
17772 | 17772 | Spain | Spain | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 47558632 | 8169 | 0 | TBC | weekly | |
17773 | 17773 | Spain | Spain | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 47558632 | 8257 | 0 | TBC | weekly | |
17774 | 17774 | Spain | Spain | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 47558632 | 8620 | 0 | TBC | weekly | |
17775 | 17775 | Spain | Spain | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 47558632 | 9262 | 0 | TBC | weekly | |
17776 | 17776 | Spain | Spain | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 47558632 | 9628 | 0 | TBC | weekly | |
17777 | 17777 | Spain | Spain | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 47558632 | 10412 | 0 | TBC | weekly | |
17778 | 17778 | Spain | Spain | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 47558632 | 11204 | 0 | TBC | weekly | |
17779 | 17779 | Spain | Spain | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 47558632 | 10905 | 0 | TBC | weekly | |
17780 | 17780 | Spain | Spain | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 47558632 | 10981 | 0 | TBC | weekly | |
17781 | 17781 | Spain | Spain | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 47558632 | 10324 | 0 | TBC | weekly | |
17782 | 17782 | Spain | Spain | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 47558632 | 9893 | 0 | TBC | weekly | |
17783 | 17783 | Spain | Spain | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 47558632 | 10015 | 0 | TBC | weekly | |
17784 | 17784 | Spain | Spain | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 47558632 | 10105 | 0 | TBC | weekly | |
17785 | 17785 | Spain | Spain | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 47558632 | 9656 | 0 | TBC | weekly | |
17786 | 17786 | Spain | Spain | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 47558632 | 9599 | 0 | TBC | weekly | |
17787 | 17787 | Spain | Spain | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 47558632 | 9203 | 0 | TBC | weekly | |
17788 | 17788 | Spain | Spain | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 47558632 | 8862 | 0 | TBC | weekly | |
17789 | 17789 | Spain | Spain | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 47558632 | 8616 | 0 | TBC | weekly | |
17790 | 17790 | Spain | Spain | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 47558632 | 8628 | 0 | TBC | weekly | |
17791 | 17791 | Spain | Spain | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 47558632 | 8414 | 0 | TBC | weekly | |
17792 | 17792 | Spain | Spain | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 47558632 | 8335 | 0 | TBC | weekly | |
17793 | 17793 | Spain | Spain | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 47558632 | 8112 | 0 | TBC | weekly | |
17794 | 17794 | Spain | Spain | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 47558632 | 7735 | 0 | TBC | weekly | |
17795 | 17795 | Spain | Spain | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 47558632 | 7359 | 0 | TBC | weekly | |
17796 | 17796 | Spain | Spain | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 47558632 | 7595 | 0 | TBC | weekly | |
17797 | 17797 | Spain | Spain | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 47558632 | 7511 | 0 | TBC | weekly | |
17798 | 17798 | Spain | Spain | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 47558632 | 7527 | 0 | TBC | weekly | |
17799 | 17799 | Spain | Spain | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 47558632 | 7306 | 0 | TBC | weekly | |
17800 | 17800 | Spain | Spain | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 47558632 | 7109 | 0 | TBC | weekly | |
17801 | 17801 | Spain | Spain | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 47558632 | 7154 | 0 | TBC | weekly | |
17802 | 17802 | Spain | Spain | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 47558632 | 7713 | 0 | TBC | weekly | |
17803 | 17803 | Spain | Spain | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 47558632 | 7698 | 0 | TBC | weekly | |
17804 | 17804 | Spain | Spain | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 47558632 | 7305 | 0 | TBC | weekly | |
17805 | 17805 | Spain | Spain | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 47558632 | 7366 | 0 | TBC | weekly | |
17806 | 17806 | Spain | Spain | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 47558632 | 7186 | 0 | TBC | weekly | |
17807 | 17807 | Spain | Spain | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 47558632 | 7155 | 0 | TBC | weekly | |
17808 | 17808 | Spain | Spain | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 47558632 | 7731 | 0 | TBC | weekly | |
17809 | 17809 | Spain | Spain | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 47558632 | 8003 | 0 | TBC | weekly | |
17810 | 17810 | Spain | Spain | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 47558632 | 7194 | 0 | TBC | weekly | |
17811 | 17811 | Spain | Spain | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 47558632 | 7015 | 0 | TBC | weekly | |
17812 | 17812 | Spain | Spain | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 47558632 | 6927 | 0 | TBC | weekly | |
17813 | 17813 | Spain | Spain | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 47558632 | 6906 | 0 | TBC | weekly | |
17814 | 17814 | Spain | Spain | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 47558632 | 6834 | 0 | TBC | weekly | |
17815 | 17815 | Spain | Spain | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 47558632 | 7153 | 0 | TBC | weekly | |
17816 | 17816 | Spain | Spain | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 47558632 | 7230 | 0 | TBC | weekly | |
17817 | 17817 | Spain | Spain | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 47558632 | 7210 | 0 | TBC | weekly | |
17818 | 17818 | Spain | Spain | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 47558632 | 7437 | 0 | TBC | weekly | |
17819 | 17819 | Spain | Spain | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 47558632 | 7350 | 0 | TBC | weekly | |
17820 | 17820 | Spain | Spain | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 47558632 | 7327 | 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]);