economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Colombia" and year = 2016
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19283 | 19283 | Colombia | Colombia | 0 | 2016-01-04 | 2016-01-10 | 7 | 2016 | 1 | 51874028 | 4442 | 0 | TBC | weekly | |
19284 | 19284 | Colombia | Colombia | 0 | 2016-01-11 | 2016-01-17 | 7 | 2016 | 2 | 51874028 | 4405 | 0 | TBC | weekly | |
19285 | 19285 | Colombia | Colombia | 0 | 2016-01-18 | 2016-01-24 | 7 | 2016 | 3 | 51874028 | 4363 | 0 | TBC | weekly | |
19286 | 19286 | Colombia | Colombia | 0 | 2016-01-25 | 2016-01-31 | 7 | 2016 | 4 | 51874028 | 4222 | 0 | TBC | weekly | |
19287 | 19287 | Colombia | Colombia | 0 | 2016-02-01 | 2016-02-07 | 7 | 2016 | 5 | 51874028 | 4152 | 0 | TBC | weekly | |
19288 | 19288 | Colombia | Colombia | 0 | 2016-02-08 | 2016-02-14 | 7 | 2016 | 6 | 51874028 | 4095 | 0 | TBC | weekly | |
19289 | 19289 | Colombia | Colombia | 0 | 2016-02-15 | 2016-02-21 | 7 | 2016 | 7 | 51874028 | 4108 | 0 | TBC | weekly | |
19290 | 19290 | Colombia | Colombia | 0 | 2016-02-22 | 2016-02-28 | 7 | 2016 | 8 | 51874028 | 4072 | 0 | TBC | weekly | |
19291 | 19291 | Colombia | Colombia | 0 | 2016-02-29 | 2016-03-06 | 7 | 2016 | 9 | 51874028 | 4175 | 0 | TBC | weekly | |
19292 | 19292 | Colombia | Colombia | 0 | 2016-03-07 | 2016-03-13 | 7 | 2016 | 10 | 51874028 | 4206 | 0 | TBC | weekly | |
19293 | 19293 | Colombia | Colombia | 0 | 2016-03-14 | 2016-03-20 | 7 | 2016 | 11 | 51874028 | 4200 | 0 | TBC | weekly | |
19294 | 19294 | Colombia | Colombia | 0 | 2016-03-21 | 2016-03-27 | 7 | 2016 | 12 | 51874028 | 4244 | 0 | TBC | weekly | |
19295 | 19295 | Colombia | Colombia | 0 | 2016-03-28 | 2016-04-03 | 7 | 2016 | 13 | 51874028 | 4066 | 0 | TBC | weekly | |
19296 | 19296 | Colombia | Colombia | 0 | 2016-04-04 | 2016-04-10 | 7 | 2016 | 14 | 51874028 | 4098 | 0 | TBC | weekly | |
19297 | 19297 | Colombia | Colombia | 0 | 2016-04-11 | 2016-04-17 | 7 | 2016 | 15 | 51874028 | 4137 | 0 | TBC | weekly | |
19298 | 19298 | Colombia | Colombia | 0 | 2016-04-18 | 2016-04-24 | 7 | 2016 | 16 | 51874028 | 4196 | 0 | TBC | weekly | |
19299 | 19299 | Colombia | Colombia | 0 | 2016-04-25 | 2016-05-01 | 7 | 2016 | 17 | 51874028 | 4092 | 0 | TBC | weekly | |
19300 | 19300 | Colombia | Colombia | 0 | 2016-05-02 | 2016-05-08 | 7 | 2016 | 18 | 51874028 | 4154 | 0 | TBC | weekly | |
19301 | 19301 | Colombia | Colombia | 0 | 2016-05-09 | 2016-05-15 | 7 | 2016 | 19 | 51874028 | 4301 | 0 | TBC | weekly | |
19302 | 19302 | Colombia | Colombia | 0 | 2016-05-16 | 2016-05-22 | 7 | 2016 | 20 | 51874028 | 4611 | 0 | TBC | weekly | |
19303 | 19303 | Colombia | Colombia | 0 | 2016-05-23 | 2016-05-29 | 7 | 2016 | 21 | 51874028 | 4509 | 0 | TBC | weekly | |
19304 | 19304 | Colombia | Colombia | 0 | 2016-05-30 | 2016-06-05 | 7 | 2016 | 22 | 51874028 | 4549 | 0 | TBC | weekly | |
19305 | 19305 | Colombia | Colombia | 0 | 2016-06-06 | 2016-06-12 | 7 | 2016 | 23 | 51874028 | 4525 | 0 | TBC | weekly | |
19306 | 19306 | Colombia | Colombia | 0 | 2016-06-13 | 2016-06-19 | 7 | 2016 | 24 | 51874028 | 4513 | 0 | TBC | weekly | |
19307 | 19307 | Colombia | Colombia | 0 | 2016-06-20 | 2016-06-26 | 7 | 2016 | 25 | 51874028 | 4484 | 0 | TBC | weekly | |
19308 | 19308 | Colombia | Colombia | 0 | 2016-06-27 | 2016-07-03 | 7 | 2016 | 26 | 51874028 | 4515 | 0 | TBC | weekly | |
19309 | 19309 | Colombia | Colombia | 0 | 2016-07-04 | 2016-07-10 | 7 | 2016 | 27 | 51874028 | 4316 | 0 | TBC | weekly | |
19310 | 19310 | Colombia | Colombia | 0 | 2016-07-11 | 2016-07-17 | 7 | 2016 | 28 | 51874028 | 4295 | 0 | TBC | weekly | |
19311 | 19311 | Colombia | Colombia | 0 | 2016-07-18 | 2016-07-24 | 7 | 2016 | 29 | 51874028 | 4072 | 0 | TBC | weekly | |
19312 | 19312 | Colombia | Colombia | 0 | 2016-07-25 | 2016-07-31 | 7 | 2016 | 30 | 51874028 | 4156 | 0 | TBC | weekly | |
19313 | 19313 | Colombia | Colombia | 0 | 2016-08-01 | 2016-08-07 | 7 | 2016 | 31 | 51874028 | 4143 | 0 | TBC | weekly | |
19314 | 19314 | Colombia | Colombia | 0 | 2016-08-08 | 2016-08-14 | 7 | 2016 | 32 | 51874028 | 4263 | 0 | TBC | weekly | |
19315 | 19315 | Colombia | Colombia | 0 | 2016-08-15 | 2016-08-21 | 7 | 2016 | 33 | 51874028 | 4154 | 0 | TBC | weekly | |
19316 | 19316 | Colombia | Colombia | 0 | 2016-08-22 | 2016-08-28 | 7 | 2016 | 34 | 51874028 | 4019 | 0 | TBC | weekly | |
19317 | 19317 | Colombia | Colombia | 0 | 2016-08-29 | 2016-09-04 | 7 | 2016 | 35 | 51874028 | 4103 | 0 | TBC | weekly | |
19318 | 19318 | Colombia | Colombia | 0 | 2016-09-05 | 2016-09-11 | 7 | 2016 | 36 | 51874028 | 4061 | 0 | TBC | weekly | |
19319 | 19319 | Colombia | Colombia | 0 | 2016-09-12 | 2016-09-18 | 7 | 2016 | 37 | 51874028 | 4000 | 0 | TBC | weekly | |
19320 | 19320 | Colombia | Colombia | 0 | 2016-09-19 | 2016-09-25 | 7 | 2016 | 38 | 51874028 | 4164 | 0 | TBC | weekly | |
19321 | 19321 | Colombia | Colombia | 0 | 2016-09-26 | 2016-10-02 | 7 | 2016 | 39 | 51874028 | 3998 | 0 | TBC | weekly | |
19322 | 19322 | Colombia | Colombia | 0 | 2016-10-03 | 2016-10-09 | 7 | 2016 | 40 | 51874028 | 4043 | 0 | TBC | weekly | |
19323 | 19323 | Colombia | Colombia | 0 | 2016-10-10 | 2016-10-16 | 7 | 2016 | 41 | 51874028 | 4162 | 0 | TBC | weekly | |
19324 | 19324 | Colombia | Colombia | 0 | 2016-10-17 | 2016-10-23 | 7 | 2016 | 42 | 51874028 | 4127 | 0 | TBC | weekly | |
19325 | 19325 | Colombia | Colombia | 0 | 2016-10-24 | 2016-10-30 | 7 | 2016 | 43 | 51874028 | 4049 | 0 | TBC | weekly | |
19326 | 19326 | Colombia | Colombia | 0 | 2016-10-31 | 2016-11-06 | 7 | 2016 | 44 | 51874028 | 4021 | 0 | TBC | weekly | |
19327 | 19327 | Colombia | Colombia | 0 | 2016-11-07 | 2016-11-13 | 7 | 2016 | 45 | 51874028 | 4155 | 0 | TBC | weekly | |
19328 | 19328 | Colombia | Colombia | 0 | 2016-11-14 | 2016-11-20 | 7 | 2016 | 46 | 51874028 | 4111 | 0 | TBC | weekly | |
19329 | 19329 | Colombia | Colombia | 0 | 2016-11-21 | 2016-11-27 | 7 | 2016 | 47 | 51874028 | 4237 | 0 | TBC | weekly | |
19330 | 19330 | Colombia | Colombia | 0 | 2016-11-28 | 2016-12-04 | 7 | 2016 | 48 | 51874028 | 4178 | 0 | TBC | weekly | |
19331 | 19331 | Colombia | Colombia | 0 | 2016-12-05 | 2016-12-11 | 7 | 2016 | 49 | 51874028 | 4438 | 0 | TBC | weekly | |
19332 | 19332 | Colombia | Colombia | 0 | 2016-12-12 | 2016-12-18 | 7 | 2016 | 50 | 51874028 | 4571 | 0 | TBC | weekly | |
19333 | 19333 | Colombia | Colombia | 0 | 2016-12-19 | 2016-12-25 | 7 | 2016 | 51 | 51874028 | 4566 | 0 | TBC | weekly | |
19334 | 19334 | Colombia | Colombia | 0 | 2016-12-26 | 2017-01-01 | 7 | 2016 | 52 | 51874028 | 4747 | 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]);