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 = 2021
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
end_date (date) >30 ✖
- 2021-01-10 1
- 2021-01-17 1
- 2021-01-24 1
- 2021-01-31 1
- 2021-02-07 1
- 2021-02-14 1
- 2021-02-21 1
- 2021-02-28 1
- 2021-03-07 1
- 2021-03-14 1
- 2021-03-21 1
- 2021-03-28 1
- 2021-04-04 1
- 2021-04-11 1
- 2021-04-18 1
- 2021-04-25 1
- 2021-05-02 1
- 2021-05-09 1
- 2021-05-16 1
- 2021-05-23 1
- 2021-05-30 1
- 2021-06-06 1
- 2021-06-13 1
- 2021-06-20 1
- 2021-06-27 1
- 2021-07-04 1
- 2021-07-11 1
- 2021-07-18 1
- 2021-07-25 1
- 2021-08-01 1
- …
country 1
- Portugal · 52 ✖
cadence 1
- weekly 52
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13176 | 13176 | Portugal | Portugal | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 10270857 | 3836 | 685 | TBC | weekly | |
13177 | 13177 | Portugal | Portugal | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 10270857 | 4618 | 1058 | TBC | weekly | |
13178 | 13178 | Portugal | Portugal | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 10270857 | 5044 | 1608 | TBC | weekly | |
13179 | 13179 | Portugal | Portugal | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 10270857 | 4818 | 2013 | TBC | weekly | |
13180 | 13180 | Portugal | Portugal | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 10270857 | 3973 | 1676 | TBC | weekly | |
13181 | 13181 | Portugal | Portugal | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 10270857 | 3394 | 1163 | TBC | weekly | |
13182 | 13182 | Portugal | Portugal | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 10270857 | 2862 | 641 | TBC | weekly | |
13183 | 13183 | Portugal | Portugal | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 10270857 | 2535 | 355 | TBC | weekly | |
13184 | 13184 | Portugal | Portugal | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 10270857 | 2354 | 223 | TBC | weekly | |
13185 | 13185 | Portugal | Portugal | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 10270857 | 2138 | 144 | TBC | weekly | |
13186 | 13186 | Portugal | Portugal | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 10270857 | 2115 | 84 | TBC | weekly | |
13187 | 13187 | Portugal | Portugal | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 10270857 | 2057 | 69 | TBC | weekly | |
13188 | 13188 | Portugal | Portugal | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 10270857 | 2133 | 42 | TBC | weekly | |
13189 | 13189 | Portugal | Portugal | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 10270857 | 1996 | 37 | TBC | weekly | |
13190 | 13190 | Portugal | Portugal | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 10270857 | 1966 | 29 | TBC | weekly | |
13191 | 13191 | Portugal | Portugal | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 10270857 | 1916 | 20 | TBC | weekly | |
13192 | 13192 | Portugal | Portugal | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 10270857 | 1893 | 12 | TBC | weekly | |
13193 | 13193 | Portugal | Portugal | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 10270857 | 2046 | 15 | TBC | weekly | |
13194 | 13194 | Portugal | Portugal | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 10270857 | 1912 | 15 | TBC | weekly | |
13195 | 13195 | Portugal | Portugal | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 10270857 | 1838 | 10 | TBC | weekly | |
13196 | 13196 | Portugal | Portugal | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 10270857 | 1996 | 6 | TBC | weekly | |
13197 | 13197 | Portugal | Portugal | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 10270857 | 1884 | 11 | TBC | weekly | |
13198 | 13198 | Portugal | Portugal | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 10270857 | 1947 | 13 | TBC | weekly | |
13199 | 13199 | Portugal | Portugal | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 10270857 | 1987 | 18 | TBC | weekly | |
13200 | 13200 | Portugal | Portugal | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 10270857 | 1854 | 19 | TBC | weekly | |
13201 | 13201 | Portugal | Portugal | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 10270857 | 1954 | 28 | TBC | weekly | |
13202 | 13202 | Portugal | Portugal | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 10270857 | 1953 | 44 | TBC | weekly | |
13203 | 13203 | Portugal | Portugal | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 10270857 | 2058 | 51 | TBC | weekly | |
13204 | 13204 | Portugal | Portugal | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 10270857 | 1960 | 85 | TBC | weekly | |
13205 | 13205 | Portugal | Portugal | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 10270857 | 1979 | 77 | TBC | weekly | |
13206 | 13206 | Portugal | Portugal | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 10270857 | 2066 | 98 | TBC | weekly | |
13207 | 13207 | Portugal | Portugal | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 10270857 | 2089 | 95 | TBC | weekly | |
13208 | 13208 | Portugal | Portugal | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 10270857 | 2129 | 77 | TBC | weekly | |
13209 | 13209 | Portugal | Portugal | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 10270857 | 2095 | 82 | TBC | weekly | |
13210 | 13210 | Portugal | Portugal | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 10270857 | 2083 | 77 | TBC | weekly | |
13211 | 13211 | Portugal | Portugal | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 10270857 | 1994 | 63 | TBC | weekly | |
13212 | 13212 | Portugal | Portugal | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 10270857 | 1923 | 46 | TBC | weekly | |
13213 | 13213 | Portugal | Portugal | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 10270857 | 2034 | 47 | TBC | weekly | |
13214 | 13214 | Portugal | Portugal | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 10270857 | 2016 | 39 | TBC | weekly | |
13215 | 13215 | Portugal | Portugal | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 10270857 | 2130 | 48 | TBC | weekly | |
13216 | 13216 | Portugal | Portugal | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 10270857 | 2140 | 56 | TBC | weekly | |
13217 | 13217 | Portugal | Portugal | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 10270857 | 2051 | 36 | TBC | weekly | |
13218 | 13218 | Portugal | Portugal | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 10270857 | 2187 | 24 | TBC | weekly | |
13219 | 13219 | Portugal | Portugal | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 10270857 | 2135 | 46 | TBC | weekly | |
13220 | 13220 | Portugal | Portugal | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 10270857 | 2425 | 54 | TBC | weekly | |
13221 | 13221 | Portugal | Portugal | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 10270857 | 2470 | 64 | TBC | weekly | |
13222 | 13222 | Portugal | Portugal | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 10270857 | 2568 | 96 | TBC | weekly | |
13223 | 13223 | Portugal | Portugal | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 10270857 | 2741 | 120 | TBC | weekly | |
13224 | 13224 | Portugal | Portugal | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 10270857 | 2628 | 121 | TBC | weekly | |
13225 | 13225 | Portugal | Portugal | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 10270857 | 2504 | 120 | TBC | weekly | |
13226 | 13226 | Portugal | Portugal | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 10270857 | 2596 | 96 | TBC | weekly | |
13227 | 13227 | Portugal | Portugal | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 10270857 | 2539 | 116 | 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]);