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 = 2016 sorted by cadence
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17674 | 17674 | Spain | Spain | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 47558632 | 8658 | 0 | TBC | weekly | |
17675 | 17675 | Spain | Spain | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 47558632 | 8671 | 0 | TBC | weekly | |
17676 | 17676 | Spain | Spain | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 47558632 | 8791 | 0 | TBC | weekly | |
17677 | 17677 | Spain | Spain | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 47558632 | 8491 | 0 | TBC | weekly | |
17678 | 17678 | Spain | Spain | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 47558632 | 8461 | 0 | TBC | weekly | |
17679 | 17679 | Spain | Spain | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 47558632 | 8556 | 0 | TBC | weekly | |
17680 | 17680 | Spain | Spain | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 47558632 | 8479 | 0 | TBC | weekly | |
17681 | 17681 | Spain | Spain | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 47558632 | 8670 | 0 | TBC | weekly | |
17682 | 17682 | Spain | Spain | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 47558632 | 8645 | 0 | TBC | weekly | |
17683 | 17683 | Spain | Spain | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 47558632 | 8653 | 0 | TBC | weekly | |
17684 | 17684 | Spain | Spain | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 47558632 | 8811 | 0 | TBC | weekly | |
17685 | 17685 | Spain | Spain | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 47558632 | 8291 | 0 | TBC | weekly | |
17686 | 17686 | Spain | Spain | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 47558632 | 8375 | 0 | TBC | weekly | |
17687 | 17687 | Spain | Spain | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 47558632 | 7998 | 0 | TBC | weekly | |
17688 | 17688 | Spain | Spain | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 47558632 | 7859 | 0 | TBC | weekly | |
17689 | 17689 | Spain | Spain | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 47558632 | 7589 | 0 | TBC | weekly | |
17690 | 17690 | Spain | Spain | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 47558632 | 7462 | 0 | TBC | weekly | |
17691 | 17691 | Spain | Spain | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 47558632 | 7606 | 0 | TBC | weekly | |
17692 | 17692 | Spain | Spain | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 47558632 | 7374 | 0 | TBC | weekly | |
17693 | 17693 | Spain | Spain | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 47558632 | 7533 | 0 | TBC | weekly | |
17694 | 17694 | Spain | Spain | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 47558632 | 7304 | 0 | TBC | weekly | |
17695 | 17695 | Spain | Spain | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 47558632 | 7255 | 0 | TBC | weekly | |
17696 | 17696 | Spain | Spain | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 47558632 | 7576 | 0 | TBC | weekly | |
17697 | 17697 | Spain | Spain | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 47558632 | 7140 | 0 | TBC | weekly | |
17698 | 17698 | Spain | Spain | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 47558632 | 7173 | 0 | TBC | weekly | |
17699 | 17699 | Spain | Spain | 0 | 2016-06-27 | 2016-07-03 | 7 | 2016 | 26 | 47558632 | 7345 | 0 | TBC | weekly | |
17700 | 17700 | Spain | Spain | 0 | 2016-07-04 | 2016-07-10 | 7 | 2016 | 27 | 47558632 | 7505 | 0 | TBC | weekly | |
17701 | 17701 | Spain | Spain | 0 | 2016-07-11 | 2016-07-17 | 7 | 2016 | 28 | 47558632 | 7423 | 0 | TBC | weekly | |
17702 | 17702 | Spain | Spain | 0 | 2016-07-18 | 2016-07-24 | 7 | 2016 | 29 | 47558632 | 7377 | 0 | TBC | weekly | |
17703 | 17703 | Spain | Spain | 0 | 2016-07-25 | 2016-07-31 | 7 | 2016 | 30 | 47558632 | 7295 | 0 | TBC | weekly | |
17704 | 17704 | Spain | Spain | 0 | 2016-08-01 | 2016-08-07 | 7 | 2016 | 31 | 47558632 | 7425 | 0 | TBC | weekly | |
17705 | 17705 | Spain | Spain | 0 | 2016-08-08 | 2016-08-14 | 7 | 2016 | 32 | 47558632 | 7233 | 0 | TBC | weekly | |
17706 | 17706 | Spain | Spain | 0 | 2016-08-15 | 2016-08-21 | 7 | 2016 | 33 | 47558632 | 7102 | 0 | TBC | weekly | |
17707 | 17707 | Spain | Spain | 0 | 2016-08-22 | 2016-08-28 | 7 | 2016 | 34 | 47558632 | 7184 | 0 | TBC | weekly | |
17708 | 17708 | Spain | Spain | 0 | 2016-08-29 | 2016-09-04 | 7 | 2016 | 35 | 47558632 | 7100 | 0 | TBC | weekly | |
17709 | 17709 | Spain | Spain | 0 | 2016-09-05 | 2016-09-11 | 7 | 2016 | 36 | 47558632 | 7203 | 0 | TBC | weekly | |
17710 | 17710 | Spain | Spain | 0 | 2016-09-12 | 2016-09-18 | 7 | 2016 | 37 | 47558632 | 6641 | 0 | TBC | weekly | |
17711 | 17711 | Spain | Spain | 0 | 2016-09-19 | 2016-09-25 | 7 | 2016 | 38 | 47558632 | 6956 | 0 | TBC | weekly | |
17712 | 17712 | Spain | Spain | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 47558632 | 7036 | 0 | TBC | weekly | |
17713 | 17713 | Spain | Spain | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 47558632 | 7072 | 0 | TBC | weekly | |
17714 | 17714 | Spain | Spain | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 47558632 | 7036 | 0 | TBC | weekly | |
17715 | 17715 | Spain | Spain | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 47558632 | 7185 | 0 | TBC | weekly | |
17716 | 17716 | Spain | Spain | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 47558632 | 7512 | 0 | TBC | weekly | |
17717 | 17717 | Spain | Spain | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 47558632 | 7244 | 0 | TBC | weekly | |
17718 | 17718 | Spain | Spain | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 47558632 | 7775 | 0 | TBC | weekly | |
17719 | 17719 | Spain | Spain | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 47558632 | 8076 | 0 | TBC | weekly | |
17720 | 17720 | Spain | Spain | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 47558632 | 8090 | 0 | TBC | weekly | |
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 |
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]);