economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
414 rows where country = "Portugal" sorted by cadence
This data as json, yaml, Notebook, copyable, CSV (advanced)
start_date (date) >30 ✖
- 2016-11-28 1
- 2016-12-05 1
- 2016-12-12 1
- 2016-12-19 1
- 2016-12-26 1
- 2017-01-02 1
- 2017-01-09 1
- 2017-01-16 1
- 2017-01-23 1
- 2017-01-30 1
- 2017-02-06 1
- 2017-02-13 1
- 2017-02-20 1
- 2017-02-27 1
- 2017-03-06 1
- 2017-03-13 1
- 2017-03-20 1
- 2017-03-27 1
- 2017-04-03 1
- 2017-04-10 1
- 2017-04-17 1
- 2017-04-24 1
- 2017-05-01 1
- 2017-05-08 1
- 2017-05-15 1
- 2017-05-22 1
- 2017-05-29 1
- 2017-06-05 1
- 2017-06-12 1
- 2017-06-19 1
- …
country 1
- Portugal · 314 ✖
cadence 1
- weekly 314
Link | rowid | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence ▼ | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12962 | 12962 | Portugal | Portugal | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 10270857 | 2388 | 0 | TBC | weekly | |
12963 | 12963 | Portugal | Portugal | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 10270857 | 2363 | 0 | TBC | weekly | |
12964 | 12964 | Portugal | Portugal | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 10270857 | 2526 | 0 | TBC | weekly | |
12965 | 12965 | Portugal | Portugal | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 10270857 | 2809 | 0 | TBC | weekly | |
12966 | 12966 | Portugal | Portugal | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 10270857 | 3200 | 0 | TBC | weekly | |
12967 | 12967 | Portugal | Portugal | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 10270857 | 3366 | 0 | TBC | weekly | |
12968 | 12968 | Portugal | Portugal | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 10270857 | 2967 | 0 | TBC | weekly | |
12969 | 12969 | Portugal | Portugal | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 10270857 | 2880 | 0 | TBC | weekly | |
12970 | 12970 | Portugal | Portugal | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 10270857 | 2995 | 0 | TBC | weekly | |
12971 | 12971 | Portugal | Portugal | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 10270857 | 2736 | 0 | TBC | weekly | |
12972 | 12972 | Portugal | Portugal | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 10270857 | 2453 | 0 | TBC | weekly | |
12973 | 12973 | Portugal | Portugal | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 10270857 | 2369 | 0 | TBC | weekly | |
12974 | 12974 | Portugal | Portugal | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 10270857 | 2237 | 0 | TBC | weekly | |
12975 | 12975 | Portugal | Portugal | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 10270857 | 2129 | 0 | TBC | weekly | |
12976 | 12976 | Portugal | Portugal | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 10270857 | 2149 | 0 | TBC | weekly | |
12977 | 12977 | Portugal | Portugal | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 10270857 | 2151 | 0 | TBC | weekly | |
12978 | 12978 | Portugal | Portugal | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 10270857 | 2074 | 0 | TBC | weekly | |
12979 | 12979 | Portugal | Portugal | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 10270857 | 2015 | 0 | TBC | weekly | |
12980 | 12980 | Portugal | Portugal | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 10270857 | 2071 | 0 | TBC | weekly | |
12981 | 12981 | Portugal | Portugal | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 10270857 | 2033 | 0 | TBC | weekly | |
12982 | 12982 | Portugal | Portugal | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 10270857 | 1825 | 0 | TBC | weekly | |
12983 | 12983 | Portugal | Portugal | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 10270857 | 1902 | 0 | TBC | weekly | |
12984 | 12984 | Portugal | Portugal | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 10270857 | 2011 | 0 | TBC | weekly | |
12985 | 12985 | Portugal | Portugal | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 10270857 | 1846 | 0 | TBC | weekly | |
12986 | 12986 | Portugal | Portugal | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 10270857 | 1833 | 0 | TBC | weekly | |
12987 | 12987 | Portugal | Portugal | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 10270857 | 1922 | 0 | TBC | weekly | |
12988 | 12988 | Portugal | Portugal | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 10270857 | 1815 | 0 | TBC | weekly | |
12989 | 12989 | Portugal | Portugal | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 10270857 | 1826 | 0 | TBC | weekly | |
12990 | 12990 | Portugal | Portugal | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 10270857 | 1969 | 0 | TBC | weekly | |
12991 | 12991 | Portugal | Portugal | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 10270857 | 2139 | 0 | TBC | weekly | |
12992 | 12992 | Portugal | Portugal | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 10270857 | 1784 | 0 | TBC | weekly | |
12993 | 12993 | Portugal | Portugal | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 10270857 | 1796 | 0 | TBC | weekly | |
12994 | 12994 | Portugal | Portugal | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 10270857 | 1806 | 0 | TBC | weekly | |
12995 | 12995 | Portugal | Portugal | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 10270857 | 1790 | 0 | TBC | weekly | |
12996 | 12996 | Portugal | Portugal | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 10270857 | 1799 | 0 | TBC | weekly | |
12997 | 12997 | Portugal | Portugal | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 10270857 | 1759 | 0 | TBC | weekly | |
12998 | 12998 | Portugal | Portugal | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 10270857 | 1739 | 0 | TBC | weekly | |
12999 | 12999 | Portugal | Portugal | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 10270857 | 1781 | 0 | TBC | weekly | |
13000 | 13000 | Portugal | Portugal | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 10270857 | 1960 | 0 | TBC | weekly | |
13001 | 13001 | Portugal | Portugal | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 10270857 | 1711 | 0 | TBC | weekly | |
13002 | 13002 | Portugal | Portugal | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 10270857 | 1783 | 0 | TBC | weekly | |
13003 | 13003 | Portugal | Portugal | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 10270857 | 1801 | 0 | TBC | weekly | |
13004 | 13004 | Portugal | Portugal | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 10270857 | 1793 | 0 | TBC | weekly | |
13005 | 13005 | Portugal | Portugal | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 10270857 | 1945 | 0 | TBC | weekly | |
13006 | 13006 | Portugal | Portugal | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 10270857 | 1983 | 0 | TBC | weekly | |
13007 | 13007 | Portugal | Portugal | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 10270857 | 1877 | 0 | TBC | weekly | |
13008 | 13008 | Portugal | Portugal | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 10270857 | 2004 | 0 | TBC | weekly | |
13009 | 13009 | Portugal | Portugal | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 10270857 | 1932 | 0 | TBC | weekly | |
13010 | 13010 | Portugal | Portugal | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 10270857 | 1918 | 0 | TBC | weekly | |
13011 | 13011 | Portugal | Portugal | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 10270857 | 1910 | 0 | TBC | weekly | |
13012 | 13012 | Portugal | Portugal | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 10270857 | 2161 | 0 | TBC | weekly | |
13013 | 13013 | Portugal | Portugal | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 10270857 | 2168 | 0 | TBC | weekly | |
13014 | 13014 | Portugal | Portugal | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 10270857 | 2193 | 0 | TBC | weekly | |
13015 | 13015 | Portugal | Portugal | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 10270857 | 2465 | 0 | TBC | weekly | |
13016 | 13016 | Portugal | Portugal | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 10270857 | 2455 | 0 | TBC | weekly | |
13017 | 13017 | Portugal | Portugal | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 10270857 | 2510 | 0 | TBC | weekly | |
13018 | 13018 | Portugal | Portugal | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 10270857 | 2747 | 0 | TBC | weekly | |
13019 | 13019 | Portugal | Portugal | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 10270857 | 2851 | 0 | TBC | weekly | |
13020 | 13020 | Portugal | Portugal | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 10270857 | 2803 | 0 | TBC | weekly | |
13021 | 13021 | Portugal | Portugal | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 10270857 | 2805 | 0 | TBC | weekly | |
13022 | 13022 | Portugal | Portugal | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 10270857 | 2693 | 0 | TBC | weekly | |
13023 | 13023 | Portugal | Portugal | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 10270857 | 2619 | 0 | TBC | weekly | |
13024 | 13024 | Portugal | Portugal | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 10270857 | 2783 | 0 | TBC | weekly | |
13025 | 13025 | Portugal | Portugal | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 10270857 | 2815 | 0 | TBC | weekly | |
13026 | 13026 | Portugal | Portugal | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 10270857 | 2777 | 0 | TBC | weekly | |
13027 | 13027 | Portugal | Portugal | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 10270857 | 2656 | 0 | TBC | weekly | |
13028 | 13028 | Portugal | Portugal | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 10270857 | 2387 | 0 | TBC | weekly | |
13029 | 13029 | Portugal | Portugal | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 10270857 | 2371 | 0 | TBC | weekly | |
13030 | 13030 | Portugal | Portugal | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 10270857 | 2234 | 0 | TBC | weekly | |
13031 | 13031 | Portugal | Portugal | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 10270857 | 2356 | 0 | TBC | weekly | |
13032 | 13032 | Portugal | Portugal | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 10270857 | 2354 | 0 | TBC | weekly | |
13033 | 13033 | Portugal | Portugal | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 10270857 | 2276 | 0 | TBC | weekly | |
13034 | 13034 | Portugal | Portugal | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 10270857 | 2197 | 0 | TBC | weekly | |
13035 | 13035 | Portugal | Portugal | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 10270857 | 2117 | 0 | TBC | weekly | |
13036 | 13036 | Portugal | Portugal | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 10270857 | 2012 | 0 | TBC | weekly | |
13037 | 13037 | Portugal | Portugal | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 10270857 | 1970 | 0 | TBC | weekly | |
13038 | 13038 | Portugal | Portugal | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 10270857 | 2066 | 0 | TBC | weekly | |
13039 | 13039 | Portugal | Portugal | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 10270857 | 1982 | 0 | TBC | weekly | |
13040 | 13040 | Portugal | Portugal | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 10270857 | 1883 | 0 | TBC | weekly | |
13041 | 13041 | Portugal | Portugal | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 10270857 | 1977 | 0 | TBC | weekly | |
13042 | 13042 | Portugal | Portugal | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 10270857 | 1928 | 0 | TBC | weekly | |
13043 | 13043 | Portugal | Portugal | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 10270857 | 2104 | 0 | TBC | weekly | |
13044 | 13044 | Portugal | Portugal | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 10270857 | 1936 | 0 | TBC | weekly | |
13045 | 13045 | Portugal | Portugal | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 10270857 | 1765 | 0 | TBC | weekly | |
13046 | 13046 | Portugal | Portugal | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 10270857 | 1771 | 0 | TBC | weekly | |
13047 | 13047 | Portugal | Portugal | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 10270857 | 1816 | 0 | TBC | weekly | |
13048 | 13048 | Portugal | Portugal | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 10270857 | 1824 | 0 | TBC | weekly | |
13049 | 13049 | Portugal | Portugal | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 10270857 | 2250 | 0 | TBC | weekly | |
13050 | 13050 | Portugal | Portugal | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 10270857 | 2199 | 0 | TBC | weekly | |
13051 | 13051 | Portugal | Portugal | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 10270857 | 1939 | 0 | TBC | weekly | |
13052 | 13052 | Portugal | Portugal | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 10270857 | 1960 | 0 | TBC | weekly | |
13053 | 13053 | Portugal | Portugal | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 10270857 | 1766 | 0 | TBC | weekly | |
13054 | 13054 | Portugal | Portugal | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 10270857 | 1837 | 0 | TBC | weekly | |
13055 | 13055 | Portugal | Portugal | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 10270857 | 1796 | 0 | TBC | weekly | |
13056 | 13056 | Portugal | Portugal | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 10270857 | 1867 | 0 | TBC | weekly | |
13057 | 13057 | Portugal | Portugal | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 10270857 | 1828 | 0 | TBC | weekly | |
13058 | 13058 | Portugal | Portugal | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 10270857 | 1890 | 0 | TBC | weekly | |
13059 | 13059 | Portugal | Portugal | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 10270857 | 1935 | 0 | TBC | weekly | |
13060 | 13060 | Portugal | Portugal | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 10270857 | 1943 | 0 | TBC | weekly | |
13061 | 13061 | Portugal | Portugal | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 10270857 | 1996 | 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]);