economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Canada", days = 7 and year = 2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15125 | 15125 | Canada | Canada | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 38454328 | 6180 | 0 | TBC | weekly | |
15126 | 15126 | Canada | Canada | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 38454328 | 6235 | 0 | TBC | weekly | |
15127 | 15127 | Canada | Canada | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 38454328 | 6290 | 0 | TBC | weekly | |
15128 | 15128 | Canada | Canada | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 38454328 | 6060 | 0 | TBC | weekly | |
15129 | 15129 | Canada | Canada | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 38454328 | 5855 | 0 | TBC | weekly | |
15130 | 15130 | Canada | Canada | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 38454328 | 6025 | 0 | TBC | weekly | |
15131 | 15131 | Canada | Canada | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 38454328 | 5865 | 0 | TBC | weekly | |
15132 | 15132 | Canada | Canada | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 38454328 | 5715 | 0 | TBC | weekly | |
15133 | 15133 | Canada | Canada | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 38454328 | 5555 | 0 | TBC | weekly | |
15134 | 15134 | Canada | Canada | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 38454328 | 5605 | 0 | TBC | weekly | |
15135 | 15135 | Canada | Canada | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 38454328 | 5630 | 0 | TBC | weekly | |
15136 | 15136 | Canada | Canada | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 38454328 | 5565 | 0 | TBC | weekly | |
15137 | 15137 | Canada | Canada | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 38454328 | 5490 | 0 | TBC | weekly | |
15138 | 15138 | Canada | Canada | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 38454328 | 5400 | 0 | TBC | weekly | |
15139 | 15139 | Canada | Canada | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 38454328 | 5260 | 0 | TBC | weekly | |
15140 | 15140 | Canada | Canada | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 38454328 | 5235 | 0 | TBC | weekly | |
15141 | 15141 | Canada | Canada | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 38454328 | 5250 | 0 | TBC | weekly | |
15142 | 15142 | Canada | Canada | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 38454328 | 5280 | 0 | TBC | weekly | |
15143 | 15143 | Canada | Canada | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 38454328 | 5215 | 0 | TBC | weekly | |
15144 | 15144 | Canada | Canada | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 38454328 | 4975 | 0 | TBC | weekly | |
15145 | 15145 | Canada | Canada | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 38454328 | 4990 | 0 | TBC | weekly | |
15146 | 15146 | Canada | Canada | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 38454328 | 4885 | 0 | TBC | weekly | |
15147 | 15147 | Canada | Canada | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 38454328 | 5055 | 0 | TBC | weekly | |
15148 | 15148 | Canada | Canada | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 38454328 | 4910 | 0 | TBC | weekly | |
15149 | 15149 | Canada | Canada | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 38454328 | 4795 | 0 | TBC | weekly | |
15150 | 15150 | Canada | Canada | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 38454328 | 4965 | 0 | TBC | weekly | |
15151 | 15151 | Canada | Canada | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 38454328 | 4915 | 0 | TBC | weekly | |
15152 | 15152 | Canada | Canada | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 38454328 | 4840 | 0 | TBC | weekly | |
15153 | 15153 | Canada | Canada | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 38454328 | 4865 | 0 | TBC | weekly | |
15154 | 15154 | Canada | Canada | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 38454328 | 4920 | 0 | TBC | weekly | |
15155 | 15155 | Canada | Canada | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 38454328 | 4865 | 0 | TBC | weekly | |
15156 | 15156 | Canada | Canada | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 38454328 | 4960 | 0 | TBC | weekly | |
15157 | 15157 | Canada | Canada | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 38454328 | 4750 | 0 | TBC | weekly | |
15158 | 15158 | Canada | Canada | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 38454328 | 4900 | 0 | TBC | weekly | |
15159 | 15159 | Canada | Canada | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 38454328 | 4950 | 0 | TBC | weekly | |
15160 | 15160 | Canada | Canada | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 38454328 | 5045 | 0 | TBC | weekly | |
15161 | 15161 | Canada | Canada | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 38454328 | 5050 | 0 | TBC | weekly | |
15162 | 15162 | Canada | Canada | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 38454328 | 5010 | 0 | TBC | weekly | |
15163 | 15163 | Canada | Canada | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 38454328 | 5070 | 0 | TBC | weekly | |
15164 | 15164 | Canada | Canada | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 38454328 | 5160 | 0 | TBC | weekly | |
15165 | 15165 | Canada | Canada | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 38454328 | 5190 | 0 | TBC | weekly | |
15166 | 15166 | Canada | Canada | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 38454328 | 5180 | 0 | TBC | weekly | |
15167 | 15167 | Canada | Canada | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 38454328 | 5185 | 0 | TBC | weekly | |
15168 | 15168 | Canada | Canada | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 38454328 | 5445 | 0 | TBC | weekly | |
15169 | 15169 | Canada | Canada | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 38454328 | 5430 | 0 | TBC | weekly | |
15170 | 15170 | Canada | Canada | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 38454328 | 5430 | 0 | TBC | weekly | |
15171 | 15171 | Canada | Canada | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 38454328 | 5455 | 0 | TBC | weekly | |
15172 | 15172 | Canada | Canada | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 38454328 | 5465 | 0 | TBC | weekly | |
15173 | 15173 | Canada | Canada | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 38454328 | 5450 | 0 | TBC | weekly | |
15174 | 15174 | Canada | Canada | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 38454328 | 5665 | 0 | TBC | weekly | |
15175 | 15175 | Canada | Canada | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 38454328 | 5900 | 0 | TBC | weekly | |
15176 | 15176 | Canada | Canada | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 38454328 | 6015 | 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]);