economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Spain" and year = 2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]);