economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Canada" and year = 2019
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15229 | 15229 | Canada | Canada | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 38454328 | 6080 | 0 | TBC | weekly | |
15230 | 15230 | Canada | Canada | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 38454328 | 5950 | 0 | TBC | weekly | |
15231 | 15231 | Canada | Canada | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 38454328 | 6000 | 0 | TBC | weekly | |
15232 | 15232 | Canada | Canada | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 38454328 | 5945 | 0 | TBC | weekly | |
15233 | 15233 | Canada | Canada | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 38454328 | 5845 | 0 | TBC | weekly | |
15234 | 15234 | Canada | Canada | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 38454328 | 5810 | 0 | TBC | weekly | |
15235 | 15235 | Canada | Canada | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 38454328 | 5865 | 0 | TBC | weekly | |
15236 | 15236 | Canada | Canada | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 38454328 | 5795 | 0 | TBC | weekly | |
15237 | 15237 | Canada | Canada | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 38454328 | 5735 | 0 | TBC | weekly | |
15238 | 15238 | Canada | Canada | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 38454328 | 5745 | 0 | TBC | weekly | |
15239 | 15239 | Canada | Canada | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 38454328 | 5660 | 0 | TBC | weekly | |
15240 | 15240 | Canada | Canada | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 38454328 | 5625 | 0 | TBC | weekly | |
15241 | 15241 | Canada | Canada | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 38454328 | 5570 | 0 | TBC | weekly | |
15242 | 15242 | Canada | Canada | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 38454328 | 5550 | 0 | TBC | weekly | |
15243 | 15243 | Canada | Canada | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 38454328 | 5560 | 0 | TBC | weekly | |
15244 | 15244 | Canada | Canada | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 38454328 | 5580 | 0 | TBC | weekly | |
15245 | 15245 | Canada | Canada | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 38454328 | 5430 | 0 | TBC | weekly | |
15246 | 15246 | Canada | Canada | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 38454328 | 5520 | 0 | TBC | weekly | |
15247 | 15247 | Canada | Canada | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 38454328 | 5425 | 0 | TBC | weekly | |
15248 | 15248 | Canada | Canada | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 38454328 | 5370 | 0 | TBC | weekly | |
15249 | 15249 | Canada | Canada | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 38454328 | 5335 | 0 | TBC | weekly | |
15250 | 15250 | Canada | Canada | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 38454328 | 5200 | 0 | TBC | weekly | |
15251 | 15251 | Canada | Canada | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 38454328 | 5185 | 0 | TBC | weekly | |
15252 | 15252 | Canada | Canada | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 38454328 | 5240 | 0 | TBC | weekly | |
15253 | 15253 | Canada | Canada | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 38454328 | 5015 | 0 | TBC | weekly | |
15254 | 15254 | Canada | Canada | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 38454328 | 5045 | 0 | TBC | weekly | |
15255 | 15255 | Canada | Canada | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 38454328 | 5160 | 0 | TBC | weekly | |
15256 | 15256 | Canada | Canada | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 38454328 | 5165 | 0 | TBC | weekly | |
15257 | 15257 | Canada | Canada | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 38454328 | 5075 | 0 | TBC | weekly | |
15258 | 15258 | Canada | Canada | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 38454328 | 5080 | 0 | TBC | weekly | |
15259 | 15259 | Canada | Canada | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 38454328 | 4950 | 0 | TBC | weekly | |
15260 | 15260 | Canada | Canada | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 38454328 | 4985 | 0 | TBC | weekly | |
15261 | 15261 | Canada | Canada | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 38454328 | 5065 | 0 | TBC | weekly | |
15262 | 15262 | Canada | Canada | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 38454328 | 5065 | 0 | TBC | weekly | |
15263 | 15263 | Canada | Canada | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 38454328 | 5130 | 0 | TBC | weekly | |
15264 | 15264 | Canada | Canada | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 38454328 | 5095 | 0 | TBC | weekly | |
15265 | 15265 | Canada | Canada | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 38454328 | 4995 | 0 | TBC | weekly | |
15266 | 15266 | Canada | Canada | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 38454328 | 5045 | 0 | TBC | weekly | |
15267 | 15267 | Canada | Canada | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 38454328 | 5395 | 0 | TBC | weekly | |
15268 | 15268 | Canada | Canada | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 38454328 | 5455 | 0 | TBC | weekly | |
15269 | 15269 | Canada | Canada | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 38454328 | 5320 | 0 | TBC | weekly | |
15270 | 15270 | Canada | Canada | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 38454328 | 5640 | 0 | TBC | weekly | |
15271 | 15271 | Canada | Canada | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 38454328 | 5535 | 0 | TBC | weekly | |
15272 | 15272 | Canada | Canada | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 38454328 | 5525 | 0 | TBC | weekly | |
15273 | 15273 | Canada | Canada | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 38454328 | 5615 | 0 | TBC | weekly | |
15274 | 15274 | Canada | Canada | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 38454328 | 5660 | 0 | TBC | weekly | |
15275 | 15275 | Canada | Canada | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 38454328 | 5600 | 0 | TBC | weekly | |
15276 | 15276 | Canada | Canada | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 38454328 | 5665 | 0 | TBC | weekly | |
15277 | 15277 | Canada | Canada | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 38454328 | 5740 | 0 | TBC | weekly | |
15278 | 15278 | Canada | Canada | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 38454328 | 5720 | 0 | TBC | weekly | |
15279 | 15279 | Canada | Canada | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 38454328 | 5650 | 0 | TBC | weekly | |
15280 | 15280 | Canada | Canada | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 38454328 | 5905 | 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]);