economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Colombia", 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19335 | 19335 | Colombia | Colombia | 0 | 2017-01-02 | 2017-01-08 | 7 | 2017 | 1 | 51874028 | 4601 | 0 | TBC | weekly | |
19336 | 19336 | Colombia | Colombia | 0 | 2017-01-09 | 2017-01-15 | 7 | 2017 | 2 | 51874028 | 4614 | 0 | TBC | weekly | |
19337 | 19337 | Colombia | Colombia | 0 | 2017-01-16 | 2017-01-22 | 7 | 2017 | 3 | 51874028 | 4512 | 0 | TBC | weekly | |
19338 | 19338 | Colombia | Colombia | 0 | 2017-01-23 | 2017-01-29 | 7 | 2017 | 4 | 51874028 | 4440 | 0 | TBC | weekly | |
19339 | 19339 | Colombia | Colombia | 0 | 2017-01-30 | 2017-02-05 | 7 | 2017 | 5 | 51874028 | 4272 | 0 | TBC | weekly | |
19340 | 19340 | Colombia | Colombia | 0 | 2017-02-06 | 2017-02-12 | 7 | 2017 | 6 | 51874028 | 4291 | 0 | TBC | weekly | |
19341 | 19341 | Colombia | Colombia | 0 | 2017-02-13 | 2017-02-19 | 7 | 2017 | 7 | 51874028 | 4142 | 0 | TBC | weekly | |
19342 | 19342 | Colombia | Colombia | 0 | 2017-02-20 | 2017-02-26 | 7 | 2017 | 8 | 51874028 | 4174 | 0 | TBC | weekly | |
19343 | 19343 | Colombia | Colombia | 0 | 2017-02-27 | 2017-03-05 | 7 | 2017 | 9 | 51874028 | 4142 | 0 | TBC | weekly | |
19344 | 19344 | Colombia | Colombia | 0 | 2017-03-06 | 2017-03-12 | 7 | 2017 | 10 | 51874028 | 4223 | 0 | TBC | weekly | |
19345 | 19345 | Colombia | Colombia | 0 | 2017-03-13 | 2017-03-19 | 7 | 2017 | 11 | 51874028 | 4122 | 0 | TBC | weekly | |
19346 | 19346 | Colombia | Colombia | 0 | 2017-03-20 | 2017-03-26 | 7 | 2017 | 12 | 51874028 | 4130 | 0 | TBC | weekly | |
19347 | 19347 | Colombia | Colombia | 0 | 2017-03-27 | 2017-04-02 | 7 | 2017 | 13 | 51874028 | 4477 | 0 | TBC | weekly | |
19348 | 19348 | Colombia | Colombia | 0 | 2017-04-03 | 2017-04-09 | 7 | 2017 | 14 | 51874028 | 4319 | 0 | TBC | weekly | |
19349 | 19349 | Colombia | Colombia | 0 | 2017-04-10 | 2017-04-16 | 7 | 2017 | 15 | 51874028 | 4151 | 0 | TBC | weekly | |
19350 | 19350 | Colombia | Colombia | 0 | 2017-04-17 | 2017-04-23 | 7 | 2017 | 16 | 51874028 | 4230 | 0 | TBC | weekly | |
19351 | 19351 | Colombia | Colombia | 0 | 2017-04-24 | 2017-04-30 | 7 | 2017 | 17 | 51874028 | 4275 | 0 | TBC | weekly | |
19352 | 19352 | Colombia | Colombia | 0 | 2017-05-01 | 2017-05-07 | 7 | 2017 | 18 | 51874028 | 4042 | 0 | TBC | weekly | |
19353 | 19353 | Colombia | Colombia | 0 | 2017-05-08 | 2017-05-14 | 7 | 2017 | 19 | 51874028 | 4158 | 0 | TBC | weekly | |
19354 | 19354 | Colombia | Colombia | 0 | 2017-05-15 | 2017-05-21 | 7 | 2017 | 20 | 51874028 | 4488 | 0 | TBC | weekly | |
19355 | 19355 | Colombia | Colombia | 0 | 2017-05-22 | 2017-05-28 | 7 | 2017 | 21 | 51874028 | 4316 | 0 | TBC | weekly | |
19356 | 19356 | Colombia | Colombia | 0 | 2017-05-29 | 2017-06-04 | 7 | 2017 | 22 | 51874028 | 4467 | 0 | TBC | weekly | |
19357 | 19357 | Colombia | Colombia | 0 | 2017-06-05 | 2017-06-11 | 7 | 2017 | 23 | 51874028 | 4313 | 0 | TBC | weekly | |
19358 | 19358 | Colombia | Colombia | 0 | 2017-06-12 | 2017-06-18 | 7 | 2017 | 24 | 51874028 | 4303 | 0 | TBC | weekly | |
19359 | 19359 | Colombia | Colombia | 0 | 2017-06-19 | 2017-06-25 | 7 | 2017 | 25 | 51874028 | 4142 | 0 | TBC | weekly | |
19360 | 19360 | Colombia | Colombia | 0 | 2017-06-26 | 2017-07-02 | 7 | 2017 | 26 | 51874028 | 4379 | 0 | TBC | weekly | |
19361 | 19361 | Colombia | Colombia | 0 | 2017-07-03 | 2017-07-09 | 7 | 2017 | 27 | 51874028 | 4366 | 0 | TBC | weekly | |
19362 | 19362 | Colombia | Colombia | 0 | 2017-07-10 | 2017-07-16 | 7 | 2017 | 28 | 51874028 | 4372 | 0 | TBC | weekly | |
19363 | 19363 | Colombia | Colombia | 0 | 2017-07-17 | 2017-07-23 | 7 | 2017 | 29 | 51874028 | 4305 | 0 | TBC | weekly | |
19364 | 19364 | Colombia | Colombia | 0 | 2017-07-24 | 2017-07-30 | 7 | 2017 | 30 | 51874028 | 4231 | 0 | TBC | weekly | |
19365 | 19365 | Colombia | Colombia | 0 | 2017-07-31 | 2017-08-06 | 7 | 2017 | 31 | 51874028 | 4335 | 0 | TBC | weekly | |
19366 | 19366 | Colombia | Colombia | 0 | 2017-08-07 | 2017-08-13 | 7 | 2017 | 32 | 51874028 | 4234 | 0 | TBC | weekly | |
19367 | 19367 | Colombia | Colombia | 0 | 2017-08-14 | 2017-08-20 | 7 | 2017 | 33 | 51874028 | 4356 | 0 | TBC | weekly | |
19368 | 19368 | Colombia | Colombia | 0 | 2017-08-21 | 2017-08-27 | 7 | 2017 | 34 | 51874028 | 4193 | 0 | TBC | weekly | |
19369 | 19369 | Colombia | Colombia | 0 | 2017-08-28 | 2017-09-03 | 7 | 2017 | 35 | 51874028 | 4215 | 0 | TBC | weekly | |
19370 | 19370 | Colombia | Colombia | 0 | 2017-09-04 | 2017-09-10 | 7 | 2017 | 36 | 51874028 | 4224 | 0 | TBC | weekly | |
19371 | 19371 | Colombia | Colombia | 0 | 2017-09-11 | 2017-09-17 | 7 | 2017 | 37 | 51874028 | 4329 | 0 | TBC | weekly | |
19372 | 19372 | Colombia | Colombia | 0 | 2017-09-18 | 2017-09-24 | 7 | 2017 | 38 | 51874028 | 4345 | 0 | TBC | weekly | |
19373 | 19373 | Colombia | Colombia | 0 | 2017-09-25 | 2017-10-01 | 7 | 2017 | 39 | 51874028 | 4248 | 0 | TBC | weekly | |
19374 | 19374 | Colombia | Colombia | 0 | 2017-10-02 | 2017-10-08 | 7 | 2017 | 40 | 51874028 | 4282 | 0 | TBC | weekly | |
19375 | 19375 | Colombia | Colombia | 0 | 2017-10-09 | 2017-10-15 | 7 | 2017 | 41 | 51874028 | 4351 | 0 | TBC | weekly | |
19376 | 19376 | Colombia | Colombia | 0 | 2017-10-16 | 2017-10-22 | 7 | 2017 | 42 | 51874028 | 4416 | 0 | TBC | weekly | |
19377 | 19377 | Colombia | Colombia | 0 | 2017-10-23 | 2017-10-29 | 7 | 2017 | 43 | 51874028 | 4151 | 0 | TBC | weekly | |
19378 | 19378 | Colombia | Colombia | 0 | 2017-10-30 | 2017-11-05 | 7 | 2017 | 44 | 51874028 | 4273 | 0 | TBC | weekly | |
19379 | 19379 | Colombia | Colombia | 0 | 2017-11-06 | 2017-11-12 | 7 | 2017 | 45 | 51874028 | 4399 | 0 | TBC | weekly | |
19380 | 19380 | Colombia | Colombia | 0 | 2017-11-13 | 2017-11-19 | 7 | 2017 | 46 | 51874028 | 4191 | 0 | TBC | weekly | |
19381 | 19381 | Colombia | Colombia | 0 | 2017-11-20 | 2017-11-26 | 7 | 2017 | 47 | 51874028 | 4251 | 0 | TBC | weekly | |
19382 | 19382 | Colombia | Colombia | 0 | 2017-11-27 | 2017-12-03 | 7 | 2017 | 48 | 51874028 | 4363 | 0 | TBC | weekly | |
19383 | 19383 | Colombia | Colombia | 0 | 2017-12-04 | 2017-12-10 | 7 | 2017 | 49 | 51874028 | 4541 | 0 | TBC | weekly | |
19384 | 19384 | Colombia | Colombia | 0 | 2017-12-11 | 2017-12-17 | 7 | 2017 | 50 | 51874028 | 4456 | 0 | TBC | weekly | |
19385 | 19385 | Colombia | Colombia | 0 | 2017-12-18 | 2017-12-24 | 7 | 2017 | 51 | 51874028 | 4518 | 0 | TBC | weekly | |
19386 | 19386 | Colombia | Colombia | 0 | 2017-12-25 | 2017-12-31 | 7 | 2017 | 52 | 51874028 | 4542 | 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]);