economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
43 rows where country = "Spain" and year = 2022 sorted by days
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17987 | 17987 | Spain | Spain | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 47558632 | 9929 | 529 | TBC | weekly | |
17988 | 17988 | Spain | Spain | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 47558632 | 10688 | 825 | TBC | weekly | |
17989 | 17989 | Spain | Spain | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 47558632 | 10847 | 982 | TBC | weekly | |
17990 | 17990 | Spain | Spain | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 47558632 | 11225 | 1225 | TBC | weekly | |
17991 | 17991 | Spain | Spain | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 47558632 | 10897 | 1074 | TBC | weekly | |
17992 | 17992 | Spain | Spain | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 47558632 | 10026 | 1955 | TBC | weekly | |
17993 | 17993 | Spain | Spain | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 47558632 | 9274 | 2003 | TBC | weekly | |
17994 | 17994 | Spain | Spain | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 47558632 | 8944 | 1412 | TBC | weekly | |
17995 | 17995 | Spain | Spain | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 47558632 | 8632 | 1003 | TBC | weekly | |
17996 | 17996 | Spain | Spain | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 47558632 | 8505 | 722 | TBC | weekly | |
17997 | 17997 | Spain | Spain | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 47558632 | 8531 | 568 | TBC | weekly | |
17998 | 17998 | Spain | Spain | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 47558632 | 8543 | 689 | TBC | weekly | |
17999 | 17999 | Spain | Spain | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 47558632 | 8509 | 323 | TBC | weekly | |
18000 | 18000 | Spain | Spain | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 47558632 | 8712 | 563 | TBC | weekly | |
18001 | 18001 | Spain | Spain | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 47558632 | 8701 | 0 | TBC | weekly | |
18002 | 18002 | Spain | Spain | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 47558632 | 8401 | 804 | TBC | weekly | |
18003 | 18003 | Spain | Spain | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 47558632 | 8505 | 548 | TBC | weekly | |
18004 | 18004 | Spain | Spain | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 47558632 | 8489 | 413 | TBC | weekly | |
18005 | 18005 | Spain | Spain | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 47558632 | 8819 | 575 | TBC | weekly | |
18006 | 18006 | Spain | Spain | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 47558632 | 8908 | 508 | TBC | weekly | |
18007 | 18007 | Spain | Spain | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 47558632 | 8229 | 394 | TBC | weekly | |
18008 | 18008 | Spain | Spain | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 47558632 | 8132 | 456 | TBC | weekly | |
18009 | 18009 | Spain | Spain | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 47558632 | 8185 | 311 | TBC | weekly | |
18010 | 18010 | Spain | Spain | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 47558632 | 9353 | 374 | TBC | weekly | |
18011 | 18011 | Spain | Spain | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 47558632 | 8570 | 317 | TBC | weekly | |
18012 | 18012 | Spain | Spain | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 47558632 | 8585 | 312 | TBC | weekly | |
18013 | 18013 | Spain | Spain | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 47558632 | 9102 | 619 | TBC | weekly | |
18014 | 18014 | Spain | Spain | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 47558632 | 10875 | 618 | TBC | weekly | |
18015 | 18015 | Spain | Spain | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 47558632 | 10962 | 839 | TBC | weekly | |
18016 | 18016 | Spain | Spain | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 47558632 | 9896 | 532 | TBC | weekly | |
18017 | 18017 | Spain | Spain | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 47558632 | 9416 | 381 | TBC | weekly | |
18018 | 18018 | Spain | Spain | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 47558632 | 9295 | 573 | TBC | weekly | |
18019 | 18019 | Spain | Spain | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 47558632 | 8072 | 461 | TBC | weekly | |
18020 | 18020 | Spain | Spain | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 47558632 | 8128 | 326 | TBC | weekly | |
18021 | 18021 | Spain | Spain | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 47558632 | 7725 | 350 | TBC | weekly | |
18022 | 18022 | Spain | Spain | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 47558632 | 7635 | 334 | TBC | weekly | |
18023 | 18023 | Spain | Spain | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 47558632 | 7611 | 595 | TBC | weekly | |
18024 | 18024 | Spain | Spain | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 47558632 | 7406 | 284 | TBC | weekly | |
18025 | 18025 | Spain | Spain | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 47558632 | 7508 | 170 | TBC | weekly | |
18026 | 18026 | Spain | Spain | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 47558632 | 7936 | 289 | TBC | weekly | |
18027 | 18027 | Spain | Spain | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 47558632 | 7752 | 173 | TBC | weekly | |
18028 | 18028 | Spain | Spain | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 47558632 | 8090 | 221 | TBC | weekly | |
18029 | 18029 | Spain | Spain | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 47558632 | 7635 | 220 | 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]);