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 = 2019
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17830 | 17830 | Spain | Spain | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 47558632 | 9127 | 0 | TBC | weekly | |
17831 | 17831 | Spain | Spain | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 47558632 | 10025 | 0 | TBC | weekly | |
17832 | 17832 | Spain | Spain | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 47558632 | 10476 | 0 | TBC | weekly | |
17833 | 17833 | Spain | Spain | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 47558632 | 10141 | 0 | TBC | weekly | |
17834 | 17834 | Spain | Spain | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 47558632 | 9964 | 0 | TBC | weekly | |
17835 | 17835 | Spain | Spain | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 47558632 | 9686 | 0 | TBC | weekly | |
17836 | 17836 | Spain | Spain | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 47558632 | 9363 | 0 | TBC | weekly | |
17837 | 17837 | Spain | Spain | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 47558632 | 9216 | 0 | TBC | weekly | |
17838 | 17838 | Spain | Spain | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 47558632 | 8920 | 0 | TBC | weekly | |
17839 | 17839 | Spain | Spain | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 47558632 | 8595 | 0 | TBC | weekly | |
17840 | 17840 | Spain | Spain | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 47558632 | 8205 | 0 | TBC | weekly | |
17841 | 17841 | Spain | Spain | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 47558632 | 8027 | 0 | TBC | weekly | |
17842 | 17842 | Spain | Spain | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 47558632 | 8171 | 0 | TBC | weekly | |
17843 | 17843 | Spain | Spain | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 47558632 | 8087 | 0 | TBC | weekly | |
17844 | 17844 | Spain | Spain | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 47558632 | 8055 | 0 | TBC | weekly | |
17845 | 17845 | Spain | Spain | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 47558632 | 7801 | 0 | TBC | weekly | |
17846 | 17846 | Spain | Spain | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 47558632 | 7759 | 0 | TBC | weekly | |
17847 | 17847 | Spain | Spain | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 47558632 | 7744 | 0 | TBC | weekly | |
17848 | 17848 | Spain | Spain | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 47558632 | 7731 | 0 | TBC | weekly | |
17849 | 17849 | Spain | Spain | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 47558632 | 7536 | 0 | TBC | weekly | |
17850 | 17850 | Spain | Spain | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 47558632 | 7436 | 0 | TBC | weekly | |
17851 | 17851 | Spain | Spain | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 47558632 | 7618 | 0 | TBC | weekly | |
17852 | 17852 | Spain | Spain | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 47558632 | 7508 | 0 | TBC | weekly | |
17853 | 17853 | Spain | Spain | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 47558632 | 7016 | 0 | TBC | weekly | |
17854 | 17854 | Spain | Spain | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 47558632 | 7404 | 0 | TBC | weekly | |
17855 | 17855 | Spain | Spain | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 47558632 | 7570 | 0 | TBC | weekly | |
17856 | 17856 | Spain | Spain | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 47558632 | 8050 | 0 | TBC | weekly | |
17857 | 17857 | Spain | Spain | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 47558632 | 7463 | 0 | TBC | weekly | |
17858 | 17858 | Spain | Spain | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 47558632 | 7301 | 0 | TBC | weekly | |
17859 | 17859 | Spain | Spain | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 47558632 | 7464 | 0 | TBC | weekly | |
17860 | 17860 | Spain | Spain | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 47558632 | 7136 | 0 | TBC | weekly | |
17861 | 17861 | Spain | Spain | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 47558632 | 7317 | 0 | TBC | weekly | |
17862 | 17862 | Spain | Spain | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 47558632 | 7128 | 0 | TBC | weekly | |
17863 | 17863 | Spain | Spain | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 47558632 | 6920 | 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 | |
17866 | 17866 | Spain | Spain | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 47558632 | 6939 | 0 | TBC | weekly | |
17867 | 17867 | Spain | Spain | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 47558632 | 6996 | 0 | TBC | weekly | |
17868 | 17868 | Spain | Spain | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 47558632 | 7027 | 0 | TBC | weekly | |
17869 | 17869 | Spain | Spain | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 47558632 | 6978 | 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 | |
17872 | 17872 | Spain | Spain | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 47558632 | 7543 | 0 | TBC | weekly | |
17873 | 17873 | Spain | Spain | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 47558632 | 7698 | 0 | TBC | weekly | |
17874 | 17874 | Spain | Spain | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 47558632 | 7677 | 0 | TBC | weekly | |
17875 | 17875 | Spain | Spain | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 47558632 | 8036 | 0 | TBC | weekly | |
17876 | 17876 | Spain | Spain | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 47558632 | 8217 | 0 | TBC | weekly | |
17877 | 17877 | Spain | Spain | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 47558632 | 8328 | 0 | TBC | weekly | |
17878 | 17878 | Spain | Spain | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 47558632 | 8021 | 0 | TBC | weekly | |
17879 | 17879 | Spain | Spain | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 47558632 | 8340 | 0 | TBC | weekly | |
17880 | 17880 | Spain | Spain | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 47558632 | 8393 | 0 | TBC | weekly | |
17881 | 17881 | Spain | Spain | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 47558632 | 8333 | 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]);