economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Portugal" and year = 2020 sorted by cadence
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13123 | 13123 | Portugal | Portugal | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 10270857 | 2510 | 0 | TBC | weekly | |
13124 | 13124 | Portugal | Portugal | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 10270857 | 2665 | 0 | TBC | weekly | |
13125 | 13125 | Portugal | Portugal | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 10270857 | 2772 | 0 | TBC | weekly | |
13126 | 13126 | Portugal | Portugal | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 10270857 | 2671 | 0 | TBC | weekly | |
13127 | 13127 | Portugal | Portugal | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 10270857 | 2691 | 0 | TBC | weekly | |
13128 | 13128 | Portugal | Portugal | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 10270857 | 2490 | 0 | TBC | weekly | |
13129 | 13129 | Portugal | Portugal | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 10270857 | 2288 | 0 | TBC | weekly | |
13130 | 13130 | Portugal | Portugal | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 10270857 | 2360 | 0 | TBC | weekly | |
13131 | 13131 | Portugal | Portugal | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 10270857 | 2309 | 0 | TBC | weekly | |
13132 | 13132 | Portugal | Portugal | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 10270857 | 2182 | 0 | TBC | weekly | |
13133 | 13133 | Portugal | Portugal | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 10270857 | 2362 | 0 | TBC | weekly | |
13134 | 13134 | Portugal | Portugal | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 10270857 | 2440 | 14 | TBC | weekly | |
13135 | 13135 | Portugal | Portugal | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 10270857 | 2544 | 105 | TBC | weekly | |
13136 | 13136 | Portugal | Portugal | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 10270857 | 2654 | 176 | TBC | weekly | |
13137 | 13137 | Portugal | Portugal | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 10270857 | 2609 | 209 | TBC | weekly | |
13138 | 13138 | Portugal | Portugal | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 10270857 | 2390 | 210 | TBC | weekly | |
13139 | 13139 | Portugal | Portugal | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 10270857 | 2311 | 189 | TBC | weekly | |
13140 | 13140 | Portugal | Portugal | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 10270857 | 2174 | 140 | TBC | weekly | |
13141 | 13141 | Portugal | Portugal | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 10270857 | 2172 | 92 | TBC | weekly | |
13142 | 13142 | Portugal | Portugal | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 10270857 | 2057 | 83 | TBC | weekly | |
13143 | 13143 | Portugal | Portugal | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 10270857 | 2071 | 98 | TBC | weekly | |
13144 | 13144 | Portugal | Portugal | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 10270857 | 2335 | 94 | TBC | weekly | |
13145 | 13145 | Portugal | Portugal | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 10270857 | 2023 | 69 | TBC | weekly | |
13146 | 13146 | Portugal | Portugal | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 10270857 | 1871 | 38 | TBC | weekly | |
13147 | 13147 | Portugal | Portugal | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 10270857 | 1942 | 13 | TBC | weekly | |
13148 | 13148 | Portugal | Portugal | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 10270857 | 2121 | 34 | TBC | weekly | |
13149 | 13149 | Portugal | Portugal | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 10270857 | 2061 | 50 | TBC | weekly | |
13150 | 13150 | Portugal | Portugal | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 10270857 | 2236 | 46 | TBC | weekly | |
13151 | 13151 | Portugal | Portugal | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 10270857 | 2651 | 29 | TBC | weekly | |
13152 | 13152 | Portugal | Portugal | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 10270857 | 2440 | 28 | TBC | weekly | |
13153 | 13153 | Portugal | Portugal | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 10270857 | 2217 | 21 | TBC | weekly | |
13154 | 13154 | Portugal | Portugal | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 10270857 | 2090 | 18 | TBC | weekly | |
13155 | 13155 | Portugal | Portugal | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 10270857 | 1941 | 22 | TBC | weekly | |
13156 | 13156 | Portugal | Portugal | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 10270857 | 2014 | 18 | TBC | weekly | |
13157 | 13157 | Portugal | Portugal | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 10270857 | 2078 | 23 | TBC | weekly | |
13158 | 13158 | Portugal | Portugal | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 10270857 | 2061 | 21 | TBC | weekly | |
13159 | 13159 | Portugal | Portugal | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 10270857 | 2239 | 27 | TBC | weekly | |
13160 | 13160 | Portugal | Portugal | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 10270857 | 2127 | 45 | TBC | weekly | |
13161 | 13161 | Portugal | Portugal | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 10270857 | 1891 | 41 | TBC | weekly | |
13162 | 13162 | Portugal | Portugal | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 10270857 | 2142 | 52 | TBC | weekly | |
13163 | 13163 | Portugal | Portugal | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 10270857 | 2157 | 75 | TBC | weekly | |
13164 | 13164 | Portugal | Portugal | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 10270857 | 2216 | 101 | TBC | weekly | |
13165 | 13165 | Portugal | Portugal | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 10270857 | 2228 | 135 | TBC | weekly | |
13166 | 13166 | Portugal | Portugal | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 10270857 | 2474 | 228 | TBC | weekly | |
13167 | 13167 | Portugal | Portugal | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 10270857 | 2562 | 352 | TBC | weekly | |
13168 | 13168 | Portugal | Portugal | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 10270857 | 2738 | 485 | TBC | weekly | |
13169 | 13169 | Portugal | Portugal | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 10270857 | 2708 | 516 | TBC | weekly | |
13170 | 13170 | Portugal | Portugal | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 10270857 | 2701 | 530 | TBC | weekly | |
13171 | 13171 | Portugal | Portugal | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 10270857 | 2853 | 536 | TBC | weekly | |
13172 | 13172 | Portugal | Portugal | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 10270857 | 3031 | 596 | TBC | weekly | |
13173 | 13173 | Portugal | Portugal | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 10270857 | 2923 | 575 | TBC | weekly | |
13174 | 13174 | Portugal | Portugal | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 10270857 | 2801 | 485 | TBC | weekly | |
13175 | 13175 | Portugal | Portugal | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 10270857 | 3162 | 499 | 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]);