economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Portugal" and year = 2016
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12915 | 12915 | Portugal | Portugal | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 10270857 | 2321 | 0 | TBC | weekly | |
12916 | 12916 | Portugal | Portugal | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 10270857 | 2332 | 0 | TBC | weekly | |
12917 | 12917 | Portugal | Portugal | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 10270857 | 2456 | 0 | TBC | weekly | |
12918 | 12918 | Portugal | Portugal | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 10270857 | 2332 | 0 | TBC | weekly | |
12919 | 12919 | Portugal | Portugal | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 10270857 | 2271 | 0 | TBC | weekly | |
12920 | 12920 | Portugal | Portugal | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 10270857 | 2351 | 0 | TBC | weekly | |
12921 | 12921 | Portugal | Portugal | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 10270857 | 2345 | 0 | TBC | weekly | |
12922 | 12922 | Portugal | Portugal | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 10270857 | 2296 | 0 | TBC | weekly | |
12923 | 12923 | Portugal | Portugal | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 10270857 | 2391 | 0 | TBC | weekly | |
12924 | 12924 | Portugal | Portugal | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 10270857 | 2380 | 0 | TBC | weekly | |
12925 | 12925 | Portugal | Portugal | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 10270857 | 2288 | 0 | TBC | weekly | |
12926 | 12926 | Portugal | Portugal | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 10270857 | 2271 | 0 | TBC | weekly | |
12927 | 12927 | Portugal | Portugal | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 10270857 | 2214 | 0 | TBC | weekly | |
12928 | 12928 | Portugal | Portugal | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 10270857 | 2225 | 0 | TBC | weekly | |
12929 | 12929 | Portugal | Portugal | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 10270857 | 2166 | 0 | TBC | weekly | |
12930 | 12930 | Portugal | Portugal | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 10270857 | 1989 | 0 | TBC | weekly | |
12931 | 12931 | Portugal | Portugal | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 10270857 | 2025 | 0 | TBC | weekly | |
12932 | 12932 | Portugal | Portugal | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 10270857 | 1954 | 0 | TBC | weekly | |
12933 | 12933 | Portugal | Portugal | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 10270857 | 1849 | 0 | TBC | weekly | |
12934 | 12934 | Portugal | Portugal | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 10270857 | 2045 | 0 | TBC | weekly | |
12935 | 12935 | Portugal | Portugal | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 10270857 | 1971 | 0 | TBC | weekly | |
12936 | 12936 | Portugal | Portugal | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 10270857 | 1983 | 0 | TBC | weekly | |
12937 | 12937 | Portugal | Portugal | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 10270857 | 1906 | 0 | TBC | weekly | |
12938 | 12938 | Portugal | Portugal | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 10270857 | 1799 | 0 | TBC | weekly | |
12939 | 12939 | Portugal | Portugal | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 10270857 | 1916 | 0 | TBC | weekly | |
12940 | 12940 | Portugal | Portugal | 0 | 2016-06-27 | 2016-07-03 | 7 | 2016 | 26 | 10270857 | 1893 | 0 | TBC | weekly | |
12941 | 12941 | Portugal | Portugal | 0 | 2016-07-04 | 2016-07-10 | 7 | 2016 | 27 | 10270857 | 1913 | 0 | TBC | weekly | |
12942 | 12942 | Portugal | Portugal | 0 | 2016-07-11 | 2016-07-17 | 7 | 2016 | 28 | 10270857 | 1934 | 0 | TBC | weekly | |
12943 | 12943 | Portugal | Portugal | 0 | 2016-07-18 | 2016-07-24 | 7 | 2016 | 29 | 10270857 | 1958 | 0 | TBC | weekly | |
12944 | 12944 | Portugal | Portugal | 0 | 2016-07-25 | 2016-07-31 | 7 | 2016 | 30 | 10270857 | 2054 | 0 | TBC | weekly | |
12945 | 12945 | Portugal | Portugal | 0 | 2016-08-01 | 2016-08-07 | 7 | 2016 | 31 | 10270857 | 1864 | 0 | TBC | weekly | |
12946 | 12946 | Portugal | Portugal | 0 | 2016-08-08 | 2016-08-14 | 7 | 2016 | 32 | 10270857 | 2091 | 0 | TBC | weekly | |
12947 | 12947 | Portugal | Portugal | 0 | 2016-08-15 | 2016-08-21 | 7 | 2016 | 33 | 10270857 | 1879 | 0 | TBC | weekly | |
12948 | 12948 | Portugal | Portugal | 0 | 2016-08-22 | 2016-08-28 | 7 | 2016 | 34 | 10270857 | 1914 | 0 | TBC | weekly | |
12949 | 12949 | Portugal | Portugal | 0 | 2016-08-29 | 2016-09-04 | 7 | 2016 | 35 | 10270857 | 1873 | 0 | TBC | weekly | |
12950 | 12950 | Portugal | Portugal | 0 | 2016-09-05 | 2016-09-11 | 7 | 2016 | 36 | 10270857 | 1864 | 0 | TBC | weekly | |
12951 | 12951 | Portugal | Portugal | 0 | 2016-09-12 | 2016-09-18 | 7 | 2016 | 37 | 10270857 | 1707 | 0 | TBC | weekly | |
12952 | 12952 | Portugal | Portugal | 0 | 2016-09-19 | 2016-09-25 | 7 | 2016 | 38 | 10270857 | 1835 | 0 | TBC | weekly | |
12953 | 12953 | Portugal | Portugal | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 10270857 | 1852 | 0 | TBC | weekly | |
12954 | 12954 | Portugal | Portugal | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 10270857 | 1856 | 0 | TBC | weekly | |
12955 | 12955 | Portugal | Portugal | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 10270857 | 1879 | 0 | TBC | weekly | |
12956 | 12956 | Portugal | Portugal | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 10270857 | 2026 | 0 | TBC | weekly | |
12957 | 12957 | Portugal | Portugal | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 10270857 | 1971 | 0 | TBC | weekly | |
12958 | 12958 | Portugal | Portugal | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 10270857 | 1939 | 0 | TBC | weekly | |
12959 | 12959 | Portugal | Portugal | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 10270857 | 2040 | 0 | TBC | weekly | |
12960 | 12960 | Portugal | Portugal | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 10270857 | 2127 | 0 | TBC | weekly | |
12961 | 12961 | Portugal | Portugal | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 10270857 | 2197 | 0 | TBC | weekly | |
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 |
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]);