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 = 2021 sorted by week
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17935 | 17935 | Spain | Spain | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 47558632 | 10470 | 1037 | TBC | weekly | |
17936 | 17936 | Spain | Spain | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 47558632 | 11858 | 1440 | TBC | weekly | |
17937 | 17937 | Spain | Spain | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 47558632 | 12950 | 2127 | TBC | weekly | |
17938 | 17938 | Spain | Spain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 47558632 | 12701 | 2878 | TBC | weekly | |
17939 | 17939 | Spain | Spain | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 47558632 | 11571 | 3067 | TBC | weekly | |
17940 | 17940 | Spain | Spain | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 47558632 | 10368 | 3361 | TBC | weekly | |
17941 | 17941 | Spain | Spain | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 47558632 | 9488 | 2354 | TBC | weekly | |
17942 | 17942 | Spain | Spain | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 47558632 | 9032 | 2041 | TBC | weekly | |
17943 | 17943 | Spain | Spain | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 47558632 | 8542 | 1996 | TBC | weekly | |
17944 | 17944 | Spain | Spain | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 47558632 | 8318 | 1120 | TBC | weekly | |
17945 | 17945 | Spain | Spain | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 47558632 | 8077 | 652 | TBC | weekly | |
17946 | 17946 | Spain | Spain | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 47558632 | 8189 | 2100 | TBC | weekly | |
17947 | 17947 | Spain | Spain | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 47558632 | 8195 | 688 | TBC | weekly | |
17948 | 17948 | Spain | Spain | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 47558632 | 8080 | 630 | TBC | weekly | |
17949 | 17949 | Spain | Spain | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 47558632 | 7947 | 653 | TBC | weekly | |
17950 | 17950 | Spain | Spain | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 47558632 | 8084 | 610 | TBC | weekly | |
17951 | 17951 | Spain | Spain | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 47558632 | 7867 | 625 | TBC | weekly | |
17952 | 17952 | Spain | Spain | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 47558632 | 8062 | 576 | TBC | weekly | |
17953 | 17953 | Spain | Spain | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 47558632 | 7738 | 547 | TBC | weekly | |
17954 | 17954 | Spain | Spain | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 47558632 | 7606 | 281 | TBC | weekly | |
17955 | 17955 | Spain | Spain | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 47558632 | 7437 | 285 | TBC | weekly | |
17956 | 17956 | Spain | Spain | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 47558632 | 7353 | 291 | TBC | weekly | |
17957 | 17957 | Spain | Spain | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 47558632 | 7710 | 305 | TBC | weekly | |
17958 | 17958 | Spain | Spain | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 47558632 | 7799 | 151 | TBC | weekly | |
17959 | 17959 | Spain | Spain | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 47558632 | 7285 | 127 | TBC | weekly | |
17960 | 17960 | Spain | Spain | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 47558632 | 7557 | 132 | TBC | weekly | |
17961 | 17961 | Spain | Spain | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 47558632 | 7544 | 92 | TBC | weekly | |
17962 | 17962 | Spain | Spain | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 47558632 | 7563 | 93 | TBC | weekly | |
17963 | 17963 | Spain | Spain | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 47558632 | 8481 | 125 | TBC | weekly | |
17964 | 17964 | Spain | Spain | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 47558632 | 8362 | 265 | TBC | weekly | |
17965 | 17965 | Spain | Spain | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 47558632 | 8642 | 520 | TBC | weekly | |
17966 | 17966 | Spain | Spain | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 47558632 | 8860 | 464 | TBC | weekly | |
17967 | 17967 | Spain | Spain | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 47558632 | 8766 | 666 | TBC | weekly | |
17968 | 17968 | Spain | Spain | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 47558632 | 8214 | 864 | TBC | weekly | |
17969 | 17969 | Spain | Spain | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 47558632 | 7936 | 795 | TBC | weekly | |
17970 | 17970 | Spain | Spain | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 47558632 | 7895 | 495 | TBC | weekly | |
17971 | 17971 | Spain | Spain | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 47558632 | 7504 | 493 | TBC | weekly | |
17972 | 17972 | Spain | Spain | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 47558632 | 7430 | 446 | TBC | weekly | |
17973 | 17973 | Spain | Spain | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 47558632 | 7548 | 234 | TBC | weekly | |
17974 | 17974 | Spain | Spain | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 47558632 | 7526 | 315 | TBC | weekly | |
17975 | 17975 | Spain | Spain | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 47558632 | 7586 | 196 | TBC | weekly | |
17976 | 17976 | Spain | Spain | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 47558632 | 7744 | 158 | TBC | weekly | |
17977 | 17977 | Spain | Spain | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 47558632 | 8179 | 236 | TBC | weekly | |
17978 | 17978 | Spain | Spain | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 47558632 | 7821 | 136 | TBC | weekly | |
17979 | 17979 | Spain | Spain | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 47558632 | 8717 | 169 | TBC | weekly | |
17980 | 17980 | Spain | Spain | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 47558632 | 8793 | 137 | TBC | weekly | |
17981 | 17981 | Spain | Spain | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 47558632 | 8846 | 145 | TBC | weekly | |
17982 | 17982 | Spain | Spain | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 47558632 | 9386 | 204 | TBC | weekly | |
17983 | 17983 | Spain | Spain | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 47558632 | 9017 | 222 | TBC | weekly | |
17984 | 17984 | Spain | Spain | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 47558632 | 9503 | 327 | TBC | weekly | |
17985 | 17985 | Spain | Spain | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 47558632 | 9780 | 311 | TBC | weekly | |
17986 | 17986 | Spain | Spain | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 47558632 | 9833 | 386 | 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]);