economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Spain" and year = 2015
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17621 | 17621 | Spain | Spain | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 47558632 | 9605 | 0 | TBC | weekly | |
17622 | 17622 | Spain | Spain | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 47558632 | 10415 | 0 | TBC | weekly | |
17623 | 17623 | Spain | Spain | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 47558632 | 10738 | 0 | TBC | weekly | |
17624 | 17624 | Spain | Spain | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 47558632 | 10625 | 0 | TBC | weekly | |
17625 | 17625 | Spain | Spain | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 47558632 | 11046 | 0 | TBC | weekly | |
17626 | 17626 | Spain | Spain | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 47558632 | 10682 | 0 | TBC | weekly | |
17627 | 17627 | Spain | Spain | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 47558632 | 10857 | 0 | TBC | weekly | |
17628 | 17628 | Spain | Spain | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 47558632 | 10580 | 0 | TBC | weekly | |
17629 | 17629 | Spain | Spain | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 47558632 | 10058 | 0 | TBC | weekly | |
17630 | 17630 | Spain | Spain | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 47558632 | 9421 | 0 | TBC | weekly | |
17631 | 17631 | Spain | Spain | 0 | 2015-03-09 | 2015-03-15 | 7 | 2015 | 11 | 47558632 | 8785 | 0 | TBC | weekly | |
17632 | 17632 | Spain | Spain | 0 | 2015-03-16 | 2015-03-22 | 7 | 2015 | 12 | 47558632 | 8379 | 0 | TBC | weekly | |
17633 | 17633 | Spain | Spain | 0 | 2015-03-23 | 2015-03-29 | 7 | 2015 | 13 | 47558632 | 8366 | 0 | TBC | weekly | |
17634 | 17634 | Spain | Spain | 0 | 2015-03-30 | 2015-04-05 | 7 | 2015 | 14 | 47558632 | 8282 | 0 | TBC | weekly | |
17635 | 17635 | Spain | Spain | 0 | 2015-04-06 | 2015-04-12 | 7 | 2015 | 15 | 47558632 | 7894 | 0 | TBC | weekly | |
17636 | 17636 | Spain | Spain | 0 | 2015-04-13 | 2015-04-19 | 7 | 2015 | 16 | 47558632 | 7855 | 0 | TBC | weekly | |
17637 | 17637 | Spain | Spain | 0 | 2015-04-20 | 2015-04-26 | 7 | 2015 | 17 | 47558632 | 7802 | 0 | TBC | weekly | |
17638 | 17638 | Spain | Spain | 0 | 2015-04-27 | 2015-05-03 | 7 | 2015 | 18 | 47558632 | 7365 | 0 | TBC | weekly | |
17639 | 17639 | Spain | Spain | 0 | 2015-05-04 | 2015-05-10 | 7 | 2015 | 19 | 47558632 | 7464 | 0 | TBC | weekly | |
17640 | 17640 | Spain | Spain | 0 | 2015-05-11 | 2015-05-17 | 7 | 2015 | 20 | 47558632 | 7543 | 0 | TBC | weekly | |
17641 | 17641 | Spain | Spain | 0 | 2015-05-18 | 2015-05-24 | 7 | 2015 | 21 | 47558632 | 7234 | 0 | TBC | weekly | |
17642 | 17642 | Spain | Spain | 0 | 2015-05-25 | 2015-05-31 | 7 | 2015 | 22 | 47558632 | 7096 | 0 | TBC | weekly | |
17643 | 17643 | Spain | Spain | 0 | 2015-06-01 | 2015-06-07 | 7 | 2015 | 23 | 47558632 | 7364 | 0 | TBC | weekly | |
17644 | 17644 | Spain | Spain | 0 | 2015-06-08 | 2015-06-14 | 7 | 2015 | 24 | 47558632 | 7152 | 0 | TBC | weekly | |
17645 | 17645 | Spain | Spain | 0 | 2015-06-15 | 2015-06-21 | 7 | 2015 | 25 | 47558632 | 6956 | 0 | TBC | weekly | |
17646 | 17646 | Spain | Spain | 0 | 2015-06-22 | 2015-06-28 | 7 | 2015 | 26 | 47558632 | 7111 | 0 | TBC | weekly | |
17647 | 17647 | Spain | Spain | 0 | 2015-06-29 | 2015-07-05 | 7 | 2015 | 27 | 47558632 | 8146 | 0 | TBC | weekly | |
17648 | 17648 | Spain | Spain | 0 | 2015-07-06 | 2015-07-12 | 7 | 2015 | 28 | 47558632 | 8351 | 0 | TBC | weekly | |
17649 | 17649 | Spain | Spain | 0 | 2015-07-13 | 2015-07-19 | 7 | 2015 | 29 | 47558632 | 8164 | 0 | TBC | weekly | |
17650 | 17650 | Spain | Spain | 0 | 2015-07-20 | 2015-07-26 | 7 | 2015 | 30 | 47558632 | 7798 | 0 | TBC | weekly | |
17651 | 17651 | Spain | Spain | 0 | 2015-07-27 | 2015-08-02 | 7 | 2015 | 31 | 47558632 | 7349 | 0 | TBC | weekly | |
17652 | 17652 | Spain | Spain | 0 | 2015-08-03 | 2015-08-09 | 7 | 2015 | 32 | 47558632 | 7219 | 0 | TBC | weekly | |
17653 | 17653 | Spain | Spain | 0 | 2015-08-10 | 2015-08-16 | 7 | 2015 | 33 | 47558632 | 7075 | 0 | TBC | weekly | |
17654 | 17654 | Spain | Spain | 0 | 2015-08-17 | 2015-08-23 | 7 | 2015 | 34 | 47558632 | 6801 | 0 | TBC | weekly | |
17655 | 17655 | Spain | Spain | 0 | 2015-08-24 | 2015-08-30 | 7 | 2015 | 35 | 47558632 | 6954 | 0 | TBC | weekly | |
17656 | 17656 | Spain | Spain | 0 | 2015-08-31 | 2015-09-06 | 7 | 2015 | 36 | 47558632 | 6603 | 0 | TBC | weekly | |
17657 | 17657 | Spain | Spain | 0 | 2015-09-07 | 2015-09-13 | 7 | 2015 | 37 | 47558632 | 6660 | 0 | TBC | weekly | |
17658 | 17658 | Spain | Spain | 0 | 2015-09-14 | 2015-09-20 | 7 | 2015 | 38 | 47558632 | 6617 | 0 | TBC | weekly | |
17659 | 17659 | Spain | Spain | 0 | 2015-09-21 | 2015-09-27 | 7 | 2015 | 39 | 47558632 | 6898 | 0 | TBC | weekly | |
17660 | 17660 | Spain | Spain | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 47558632 | 6813 | 0 | TBC | weekly | |
17661 | 17661 | Spain | Spain | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 47558632 | 7055 | 0 | TBC | weekly | |
17662 | 17662 | Spain | Spain | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 47558632 | 7119 | 0 | TBC | weekly | |
17663 | 17663 | Spain | Spain | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 47558632 | 7267 | 0 | TBC | weekly | |
17664 | 17664 | Spain | Spain | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 47558632 | 7392 | 0 | TBC | weekly | |
17665 | 17665 | Spain | Spain | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 47558632 | 7412 | 0 | TBC | weekly | |
17666 | 17666 | Spain | Spain | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 47558632 | 7325 | 0 | TBC | weekly | |
17667 | 17667 | Spain | Spain | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 47558632 | 7397 | 0 | TBC | weekly | |
17668 | 17668 | Spain | Spain | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 47558632 | 7849 | 0 | TBC | weekly | |
17669 | 17669 | Spain | Spain | 0 | 2015-11-30 | 2015-12-06 | 7 | 2015 | 49 | 47558632 | 8080 | 0 | TBC | weekly | |
17670 | 17670 | Spain | Spain | 0 | 2015-12-07 | 2015-12-13 | 7 | 2015 | 50 | 47558632 | 8032 | 0 | TBC | weekly | |
17671 | 17671 | Spain | Spain | 0 | 2015-12-14 | 2015-12-20 | 7 | 2015 | 51 | 47558632 | 8342 | 0 | TBC | weekly | |
17672 | 17672 | Spain | Spain | 0 | 2015-12-21 | 2015-12-27 | 7 | 2015 | 52 | 47558632 | 8031 | 0 | TBC | weekly | |
17673 | 17673 | Spain | Spain | 0 | 2015-12-28 | 2016-01-03 | 7 | 2015 | 53 | 47558632 | 8427 | 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]);