economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
409 rows where country = "Spain" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18029 | 18029 | Spain | Spain | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 47558632 | 7635 | 220 | TBC | weekly | |
18028 | 18028 | Spain | Spain | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 47558632 | 8090 | 221 | TBC | weekly | |
18027 | 18027 | Spain | Spain | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 47558632 | 7752 | 173 | TBC | weekly | |
18026 | 18026 | Spain | Spain | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 47558632 | 7936 | 289 | TBC | weekly | |
18025 | 18025 | Spain | Spain | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 47558632 | 7508 | 170 | TBC | weekly | |
18024 | 18024 | Spain | Spain | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 47558632 | 7406 | 284 | TBC | weekly | |
18023 | 18023 | Spain | Spain | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 47558632 | 7611 | 595 | TBC | weekly | |
18022 | 18022 | Spain | Spain | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 47558632 | 7635 | 334 | TBC | weekly | |
18021 | 18021 | Spain | Spain | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 47558632 | 7725 | 350 | TBC | weekly | |
18020 | 18020 | Spain | Spain | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 47558632 | 8128 | 326 | TBC | weekly | |
18019 | 18019 | Spain | Spain | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 47558632 | 8072 | 461 | TBC | weekly | |
18018 | 18018 | Spain | Spain | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 47558632 | 9295 | 573 | TBC | weekly | |
18017 | 18017 | Spain | Spain | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 47558632 | 9416 | 381 | TBC | weekly | |
18016 | 18016 | Spain | Spain | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 47558632 | 9896 | 532 | TBC | weekly | |
18015 | 18015 | Spain | Spain | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 47558632 | 10962 | 839 | TBC | weekly | |
18014 | 18014 | Spain | Spain | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 47558632 | 10875 | 618 | TBC | weekly | |
18013 | 18013 | Spain | Spain | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 47558632 | 9102 | 619 | TBC | weekly | |
18012 | 18012 | Spain | Spain | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 47558632 | 8585 | 312 | TBC | weekly | |
18011 | 18011 | Spain | Spain | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 47558632 | 8570 | 317 | TBC | weekly | |
18010 | 18010 | Spain | Spain | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 47558632 | 9353 | 374 | TBC | weekly | |
18009 | 18009 | Spain | Spain | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 47558632 | 8185 | 311 | TBC | weekly | |
18008 | 18008 | Spain | Spain | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 47558632 | 8132 | 456 | TBC | weekly | |
18007 | 18007 | Spain | Spain | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 47558632 | 8229 | 394 | TBC | weekly | |
18006 | 18006 | Spain | Spain | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 47558632 | 8908 | 508 | TBC | weekly | |
18005 | 18005 | Spain | Spain | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 47558632 | 8819 | 575 | TBC | weekly | |
18004 | 18004 | Spain | Spain | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 47558632 | 8489 | 413 | TBC | weekly | |
18003 | 18003 | Spain | Spain | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 47558632 | 8505 | 548 | TBC | weekly | |
18002 | 18002 | Spain | Spain | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 47558632 | 8401 | 804 | TBC | weekly | |
18001 | 18001 | Spain | Spain | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 47558632 | 8701 | 0 | TBC | weekly | |
18000 | 18000 | Spain | Spain | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 47558632 | 8712 | 563 | TBC | weekly | |
17999 | 17999 | Spain | Spain | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 47558632 | 8509 | 323 | TBC | weekly | |
17998 | 17998 | Spain | Spain | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 47558632 | 8543 | 689 | TBC | weekly | |
17997 | 17997 | Spain | Spain | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 47558632 | 8531 | 568 | TBC | weekly | |
17996 | 17996 | Spain | Spain | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 47558632 | 8505 | 722 | TBC | weekly | |
17995 | 17995 | Spain | Spain | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 47558632 | 8632 | 1003 | TBC | weekly | |
17994 | 17994 | Spain | Spain | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 47558632 | 8944 | 1412 | TBC | weekly | |
17993 | 17993 | Spain | Spain | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 47558632 | 9274 | 2003 | TBC | weekly | |
17992 | 17992 | Spain | Spain | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 47558632 | 10026 | 1955 | TBC | weekly | |
17991 | 17991 | Spain | Spain | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 47558632 | 10897 | 1074 | TBC | weekly | |
17990 | 17990 | Spain | Spain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 47558632 | 11225 | 1225 | TBC | weekly | |
17989 | 17989 | Spain | Spain | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 47558632 | 10847 | 982 | TBC | weekly | |
17988 | 17988 | Spain | Spain | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 47558632 | 10688 | 825 | TBC | weekly | |
17987 | 17987 | Spain | Spain | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 47558632 | 9929 | 529 | TBC | weekly | |
17986 | 17986 | Spain | Spain | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 47558632 | 9833 | 386 | TBC | weekly | |
17985 | 17985 | Spain | Spain | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 47558632 | 9780 | 311 | TBC | weekly | |
17984 | 17984 | Spain | Spain | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 47558632 | 9503 | 327 | TBC | weekly | |
17983 | 17983 | Spain | Spain | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 47558632 | 9017 | 222 | TBC | weekly | |
17982 | 17982 | Spain | Spain | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 47558632 | 9386 | 204 | TBC | weekly | |
17981 | 17981 | Spain | Spain | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 47558632 | 8846 | 145 | TBC | weekly | |
17980 | 17980 | Spain | Spain | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 47558632 | 8793 | 137 | TBC | weekly | |
17979 | 17979 | Spain | Spain | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 47558632 | 8717 | 169 | TBC | weekly | |
17978 | 17978 | Spain | Spain | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 47558632 | 7821 | 136 | TBC | weekly | |
17977 | 17977 | Spain | Spain | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 47558632 | 8179 | 236 | TBC | weekly | |
17976 | 17976 | Spain | Spain | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 47558632 | 7744 | 158 | TBC | weekly | |
17975 | 17975 | Spain | Spain | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 47558632 | 7586 | 196 | TBC | weekly | |
17974 | 17974 | Spain | Spain | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 47558632 | 7526 | 315 | TBC | weekly | |
17973 | 17973 | Spain | Spain | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 47558632 | 7548 | 234 | TBC | weekly | |
17972 | 17972 | Spain | Spain | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 47558632 | 7430 | 446 | TBC | weekly | |
17971 | 17971 | Spain | Spain | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 47558632 | 7504 | 493 | TBC | weekly | |
17970 | 17970 | Spain | Spain | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 47558632 | 7895 | 495 | TBC | weekly | |
17969 | 17969 | Spain | Spain | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 47558632 | 7936 | 795 | TBC | weekly | |
17968 | 17968 | Spain | Spain | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 47558632 | 8214 | 864 | TBC | weekly | |
17967 | 17967 | Spain | Spain | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 47558632 | 8766 | 666 | TBC | weekly | |
17966 | 17966 | Spain | Spain | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 47558632 | 8860 | 464 | TBC | weekly | |
17965 | 17965 | Spain | Spain | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 47558632 | 8642 | 520 | TBC | weekly | |
17964 | 17964 | Spain | Spain | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 47558632 | 8362 | 265 | TBC | weekly | |
17963 | 17963 | Spain | Spain | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 47558632 | 8481 | 125 | TBC | weekly | |
17962 | 17962 | Spain | Spain | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 47558632 | 7563 | 93 | TBC | weekly | |
17961 | 17961 | Spain | Spain | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 47558632 | 7544 | 92 | TBC | weekly | |
17960 | 17960 | Spain | Spain | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 47558632 | 7557 | 132 | TBC | weekly | |
17959 | 17959 | Spain | Spain | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 47558632 | 7285 | 127 | TBC | weekly | |
17958 | 17958 | Spain | Spain | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 47558632 | 7799 | 151 | TBC | weekly | |
17957 | 17957 | Spain | Spain | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 47558632 | 7710 | 305 | TBC | weekly | |
17956 | 17956 | Spain | Spain | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 47558632 | 7353 | 291 | TBC | weekly | |
17955 | 17955 | Spain | Spain | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 47558632 | 7437 | 285 | TBC | weekly | |
17954 | 17954 | Spain | Spain | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 47558632 | 7606 | 281 | TBC | weekly | |
17953 | 17953 | Spain | Spain | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 47558632 | 7738 | 547 | TBC | weekly | |
17952 | 17952 | Spain | Spain | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 47558632 | 8062 | 576 | TBC | weekly | |
17951 | 17951 | Spain | Spain | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 47558632 | 7867 | 625 | TBC | weekly | |
17950 | 17950 | Spain | Spain | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 47558632 | 8084 | 610 | TBC | weekly | |
17949 | 17949 | Spain | Spain | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 47558632 | 7947 | 653 | TBC | weekly | |
17948 | 17948 | Spain | Spain | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 47558632 | 8080 | 630 | TBC | weekly | |
17947 | 17947 | Spain | Spain | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 47558632 | 8195 | 688 | TBC | weekly | |
17946 | 17946 | Spain | Spain | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 47558632 | 8189 | 2100 | TBC | weekly | |
17945 | 17945 | Spain | Spain | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 47558632 | 8077 | 652 | TBC | weekly | |
17944 | 17944 | Spain | Spain | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 47558632 | 8318 | 1120 | TBC | weekly | |
17943 | 17943 | Spain | Spain | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 47558632 | 8542 | 1996 | TBC | weekly | |
17942 | 17942 | Spain | Spain | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 47558632 | 9032 | 2041 | TBC | weekly | |
17941 | 17941 | Spain | Spain | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 47558632 | 9488 | 2354 | TBC | weekly | |
17940 | 17940 | Spain | Spain | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 47558632 | 10368 | 3361 | TBC | weekly | |
17939 | 17939 | Spain | Spain | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 47558632 | 11571 | 3067 | TBC | weekly | |
17938 | 17938 | Spain | Spain | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 47558632 | 12701 | 2878 | TBC | weekly | |
17937 | 17937 | Spain | Spain | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 47558632 | 12950 | 2127 | TBC | weekly | |
17936 | 17936 | Spain | Spain | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 47558632 | 11858 | 1440 | TBC | weekly | |
17935 | 17935 | Spain | Spain | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 47558632 | 10470 | 1037 | TBC | weekly | |
17934 | 17934 | Spain | Spain | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 47558632 | 9524 | 1013 | TBC | weekly | |
17933 | 17933 | Spain | Spain | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 47558632 | 9015 | 898 | TBC | weekly | |
17932 | 17932 | Spain | Spain | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 47558632 | 9287 | 1302 | TBC | weekly | |
17931 | 17931 | Spain | Spain | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 47558632 | 9534 | 1372 | TBC | weekly | |
17930 | 17930 | Spain | Spain | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 47558632 | 9541 | 1584 | 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]);