economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
48 rows where cadence = "weekly", country = "Portugal" and year = 2022
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13228 | 13228 | Portugal | Portugal | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 10270857 | 2470 | 123 | TBC | weekly | |
13229 | 13229 | Portugal | Portugal | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 10270857 | 2555 | 190 | TBC | weekly | |
13230 | 13230 | Portugal | Portugal | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 10270857 | 2795 | 266 | TBC | weekly | |
13231 | 13231 | Portugal | Portugal | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 10270857 | 2791 | 287 | TBC | weekly | |
13232 | 13232 | Portugal | Portugal | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 10270857 | 2876 | 366 | TBC | weekly | |
13233 | 13233 | Portugal | Portugal | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 10270857 | 2702 | 308 | TBC | weekly | |
13234 | 13234 | Portugal | Portugal | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 10270857 | 2705 | 301 | TBC | weekly | |
13235 | 13235 | Portugal | Portugal | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 10270857 | 2474 | 208 | TBC | weekly | |
13236 | 13236 | Portugal | Portugal | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 10270857 | 2400 | 160 | TBC | weekly | |
13237 | 13237 | Portugal | Portugal | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 10270857 | 2446 | 86 | TBC | weekly | |
13238 | 13238 | Portugal | Portugal | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 10270857 | 2419 | 123 | TBC | weekly | |
13239 | 13239 | Portugal | Portugal | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 10270857 | 2447 | 137 | TBC | weekly | |
13240 | 13240 | Portugal | Portugal | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 10270857 | 2470 | 171 | TBC | weekly | |
13241 | 13241 | Portugal | Portugal | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 10270857 | 2416 | 158 | TBC | weekly | |
13242 | 13242 | Portugal | Portugal | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 10270857 | 2439 | 119 | TBC | weekly | |
13243 | 13243 | Portugal | Portugal | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 10270857 | 2309 | 169 | TBC | weekly | |
13244 | 13244 | Portugal | Portugal | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 10270857 | 2289 | 118 | TBC | weekly | |
13245 | 13245 | Portugal | Portugal | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 10270857 | 2219 | 140 | TBC | weekly | |
13246 | 13246 | Portugal | Portugal | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 10270857 | 2453 | 163 | TBC | weekly | |
13247 | 13247 | Portugal | Portugal | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 10270857 | 2354 | 171 | TBC | weekly | |
13248 | 13248 | Portugal | Portugal | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 10270857 | 2339 | 227 | TBC | weekly | |
13249 | 13249 | Portugal | Portugal | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 10270857 | 2390 | 262 | TBC | weekly | |
13250 | 13250 | Portugal | Portugal | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 10270857 | 2502 | 288 | TBC | weekly | |
13251 | 13251 | Portugal | Portugal | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 10270857 | 2679 | 215 | TBC | weekly | |
13252 | 13252 | Portugal | Portugal | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 10270857 | 2174 | 267 | TBC | weekly | |
13253 | 13253 | Portugal | Portugal | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 10270857 | 2148 | 136 | TBC | weekly | |
13254 | 13254 | Portugal | Portugal | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 10270857 | 2354 | 142 | TBC | weekly | |
13255 | 13255 | Portugal | Portugal | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 10270857 | 2744 | 90 | TBC | weekly | |
13256 | 13256 | Portugal | Portugal | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 10270857 | 2360 | 147 | TBC | weekly | |
13257 | 13257 | Portugal | Portugal | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 10270857 | 2307 | 64 | TBC | weekly | |
13258 | 13258 | Portugal | Portugal | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 10270857 | 2196 | 72 | TBC | weekly | |
13259 | 13259 | Portugal | Portugal | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 10270857 | 2100 | 58 | TBC | weekly | |
13260 | 13260 | Portugal | Portugal | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 10270857 | 2066 | 50 | TBC | weekly | |
13261 | 13261 | Portugal | Portugal | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 10270857 | 2049 | 41 | TBC | weekly | |
13262 | 13262 | Portugal | Portugal | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 10270857 | 2052 | 52 | TBC | weekly | |
13263 | 13263 | Portugal | Portugal | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 10270857 | 2045 | 44 | TBC | weekly | |
13264 | 13264 | Portugal | Portugal | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 10270857 | 2087 | 42 | TBC | weekly | |
13265 | 13265 | Portugal | Portugal | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 10270857 | 2117 | 40 | TBC | weekly | |
13266 | 13266 | Portugal | Portugal | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 10270857 | 1921 | 40 | TBC | weekly | |
13267 | 13267 | Portugal | Portugal | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 10270857 | 2137 | 44 | TBC | weekly | |
13268 | 13268 | Portugal | Portugal | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 10270857 | 2143 | 50 | TBC | weekly | |
13269 | 13269 | Portugal | Portugal | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 10270857 | 2105 | 3 | TBC | weekly | |
13270 | 13270 | Portugal | Portugal | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 10270857 | 2188 | 100 | TBC | weekly | |
13271 | 13271 | Portugal | Portugal | 0 | 2022-10-31 | 2022-11-06 | 7 | 2022 | 44 | 10270857 | 2232 | 62 | TBC | weekly | |
13272 | 13272 | Portugal | Portugal | 0 | 2022-11-07 | 2022-11-13 | 7 | 2022 | 45 | 10270857 | 2325 | 49 | TBC | weekly | |
13273 | 13273 | Portugal | Portugal | 0 | 2022-11-14 | 2022-11-20 | 7 | 2022 | 46 | 10270857 | 2338 | 56 | TBC | weekly | |
13274 | 13274 | Portugal | Portugal | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 10270857 | 2491 | 55 | TBC | weekly | |
13275 | 13275 | Portugal | Portugal | 0 | 2022-11-28 | 2022-12-04 | 7 | 2022 | 48 | 10270857 | 2607 | 67 | 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]);