economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Colombia" and year = 2015
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19230 | 19230 | Colombia | Colombia | 0 | 2014-12-29 | 2015-01-04 | 7 | 2015 | 1 | 51874028 | 4725 | 0 | TBC | weekly | |
19231 | 19231 | Colombia | Colombia | 0 | 2015-01-05 | 2015-01-11 | 7 | 2015 | 2 | 51874028 | 4565 | 0 | TBC | weekly | |
19232 | 19232 | Colombia | Colombia | 0 | 2015-01-12 | 2015-01-18 | 7 | 2015 | 3 | 51874028 | 4506 | 0 | TBC | weekly | |
19233 | 19233 | Colombia | Colombia | 0 | 2015-01-19 | 2015-01-25 | 7 | 2015 | 4 | 51874028 | 4264 | 0 | TBC | weekly | |
19234 | 19234 | Colombia | Colombia | 0 | 2015-01-26 | 2015-02-01 | 7 | 2015 | 5 | 51874028 | 4170 | 0 | TBC | weekly | |
19235 | 19235 | Colombia | Colombia | 0 | 2015-02-02 | 2015-02-08 | 7 | 2015 | 6 | 51874028 | 4072 | 0 | TBC | weekly | |
19236 | 19236 | Colombia | Colombia | 0 | 2015-02-09 | 2015-02-15 | 7 | 2015 | 7 | 51874028 | 4052 | 0 | TBC | weekly | |
19237 | 19237 | Colombia | Colombia | 0 | 2015-02-16 | 2015-02-22 | 7 | 2015 | 8 | 51874028 | 4091 | 0 | TBC | weekly | |
19238 | 19238 | Colombia | Colombia | 0 | 2015-02-23 | 2015-03-01 | 7 | 2015 | 9 | 51874028 | 4112 | 0 | TBC | weekly | |
19239 | 19239 | Colombia | Colombia | 0 | 2015-03-02 | 2015-03-08 | 7 | 2015 | 10 | 51874028 | 4094 | 0 | TBC | weekly | |
19240 | 19240 | Colombia | Colombia | 0 | 2015-03-09 | 2015-03-15 | 7 | 2015 | 11 | 51874028 | 4246 | 0 | TBC | weekly | |
19241 | 19241 | Colombia | Colombia | 0 | 2015-03-16 | 2015-03-22 | 7 | 2015 | 12 | 51874028 | 4057 | 0 | TBC | weekly | |
19242 | 19242 | Colombia | Colombia | 0 | 2015-03-23 | 2015-03-29 | 7 | 2015 | 13 | 51874028 | 4176 | 0 | TBC | weekly | |
19243 | 19243 | Colombia | Colombia | 0 | 2015-03-30 | 2015-04-05 | 7 | 2015 | 14 | 51874028 | 4052 | 0 | TBC | weekly | |
19244 | 19244 | Colombia | Colombia | 0 | 2015-04-06 | 2015-04-12 | 7 | 2015 | 15 | 51874028 | 4047 | 0 | TBC | weekly | |
19245 | 19245 | Colombia | Colombia | 0 | 2015-04-13 | 2015-04-19 | 7 | 2015 | 16 | 51874028 | 4040 | 0 | TBC | weekly | |
19246 | 19246 | Colombia | Colombia | 0 | 2015-04-20 | 2015-04-26 | 7 | 2015 | 17 | 51874028 | 4018 | 0 | TBC | weekly | |
19247 | 19247 | Colombia | Colombia | 0 | 2015-04-27 | 2015-05-03 | 7 | 2015 | 18 | 51874028 | 4167 | 0 | TBC | weekly | |
19248 | 19248 | Colombia | Colombia | 0 | 2015-05-04 | 2015-05-10 | 7 | 2015 | 19 | 51874028 | 4223 | 0 | TBC | weekly | |
19249 | 19249 | Colombia | Colombia | 0 | 2015-05-11 | 2015-05-17 | 7 | 2015 | 20 | 51874028 | 4245 | 0 | TBC | weekly | |
19250 | 19250 | Colombia | Colombia | 0 | 2015-05-18 | 2015-05-24 | 7 | 2015 | 21 | 51874028 | 4142 | 0 | TBC | weekly | |
19251 | 19251 | Colombia | Colombia | 0 | 2015-05-25 | 2015-05-31 | 7 | 2015 | 22 | 51874028 | 4010 | 0 | TBC | weekly | |
19252 | 19252 | Colombia | Colombia | 0 | 2015-06-01 | 2015-06-07 | 7 | 2015 | 23 | 51874028 | 4078 | 0 | TBC | weekly | |
19253 | 19253 | Colombia | Colombia | 0 | 2015-06-08 | 2015-06-14 | 7 | 2015 | 24 | 51874028 | 4119 | 0 | TBC | weekly | |
19254 | 19254 | Colombia | Colombia | 0 | 2015-06-15 | 2015-06-21 | 7 | 2015 | 25 | 51874028 | 4254 | 0 | TBC | weekly | |
19255 | 19255 | Colombia | Colombia | 0 | 2015-06-22 | 2015-06-28 | 7 | 2015 | 26 | 51874028 | 4322 | 0 | TBC | weekly | |
19256 | 19256 | Colombia | Colombia | 0 | 2015-06-29 | 2015-07-05 | 7 | 2015 | 27 | 51874028 | 4346 | 0 | TBC | weekly | |
19257 | 19257 | Colombia | Colombia | 0 | 2015-07-06 | 2015-07-12 | 7 | 2015 | 28 | 51874028 | 4313 | 0 | TBC | weekly | |
19258 | 19258 | Colombia | Colombia | 0 | 2015-07-13 | 2015-07-19 | 7 | 2015 | 29 | 51874028 | 4105 | 0 | TBC | weekly | |
19259 | 19259 | Colombia | Colombia | 0 | 2015-07-20 | 2015-07-26 | 7 | 2015 | 30 | 51874028 | 3945 | 0 | TBC | weekly | |
19260 | 19260 | Colombia | Colombia | 0 | 2015-07-27 | 2015-08-02 | 7 | 2015 | 31 | 51874028 | 4053 | 0 | TBC | weekly | |
19261 | 19261 | Colombia | Colombia | 0 | 2015-08-03 | 2015-08-09 | 7 | 2015 | 32 | 51874028 | 4281 | 0 | TBC | weekly | |
19262 | 19262 | Colombia | Colombia | 0 | 2015-08-10 | 2015-08-16 | 7 | 2015 | 33 | 51874028 | 4067 | 0 | TBC | weekly | |
19263 | 19263 | Colombia | Colombia | 0 | 2015-08-17 | 2015-08-23 | 7 | 2015 | 34 | 51874028 | 3967 | 0 | TBC | weekly | |
19264 | 19264 | Colombia | Colombia | 0 | 2015-08-24 | 2015-08-30 | 7 | 2015 | 35 | 51874028 | 4065 | 0 | TBC | weekly | |
19265 | 19265 | Colombia | Colombia | 0 | 2015-08-31 | 2015-09-06 | 7 | 2015 | 36 | 51874028 | 4205 | 0 | TBC | weekly | |
19266 | 19266 | Colombia | Colombia | 0 | 2015-09-07 | 2015-09-13 | 7 | 2015 | 37 | 51874028 | 4113 | 0 | TBC | weekly | |
19267 | 19267 | Colombia | Colombia | 0 | 2015-09-14 | 2015-09-20 | 7 | 2015 | 38 | 51874028 | 4186 | 0 | TBC | weekly | |
19268 | 19268 | Colombia | Colombia | 0 | 2015-09-21 | 2015-09-27 | 7 | 2015 | 39 | 51874028 | 4190 | 0 | TBC | weekly | |
19269 | 19269 | Colombia | Colombia | 0 | 2015-09-28 | 2015-10-04 | 7 | 2015 | 40 | 51874028 | 4201 | 0 | TBC | weekly | |
19270 | 19270 | Colombia | Colombia | 0 | 2015-10-05 | 2015-10-11 | 7 | 2015 | 41 | 51874028 | 4143 | 0 | TBC | weekly | |
19271 | 19271 | Colombia | Colombia | 0 | 2015-10-12 | 2015-10-18 | 7 | 2015 | 42 | 51874028 | 4022 | 0 | TBC | weekly | |
19272 | 19272 | Colombia | Colombia | 0 | 2015-10-19 | 2015-10-25 | 7 | 2015 | 43 | 51874028 | 4004 | 0 | TBC | weekly | |
19273 | 19273 | Colombia | Colombia | 0 | 2015-10-26 | 2015-11-01 | 7 | 2015 | 44 | 51874028 | 4209 | 0 | TBC | weekly | |
19274 | 19274 | Colombia | Colombia | 0 | 2015-11-02 | 2015-11-08 | 7 | 2015 | 45 | 51874028 | 4138 | 0 | TBC | weekly | |
19275 | 19275 | Colombia | Colombia | 0 | 2015-11-09 | 2015-11-15 | 7 | 2015 | 46 | 51874028 | 4334 | 0 | TBC | weekly | |
19276 | 19276 | Colombia | Colombia | 0 | 2015-11-16 | 2015-11-22 | 7 | 2015 | 47 | 51874028 | 4276 | 0 | TBC | weekly | |
19277 | 19277 | Colombia | Colombia | 0 | 2015-11-23 | 2015-11-29 | 7 | 2015 | 48 | 51874028 | 4260 | 0 | TBC | weekly | |
19278 | 19278 | Colombia | Colombia | 0 | 2015-11-30 | 2015-12-06 | 7 | 2015 | 49 | 51874028 | 4330 | 0 | TBC | weekly | |
19279 | 19279 | Colombia | Colombia | 0 | 2015-12-07 | 2015-12-13 | 7 | 2015 | 50 | 51874028 | 4295 | 0 | TBC | weekly | |
19280 | 19280 | Colombia | Colombia | 0 | 2015-12-14 | 2015-12-20 | 7 | 2015 | 51 | 51874028 | 4273 | 0 | TBC | weekly | |
19281 | 19281 | Colombia | Colombia | 0 | 2015-12-21 | 2015-12-27 | 7 | 2015 | 52 | 51874028 | 4522 | 0 | TBC | weekly | |
19282 | 19282 | Colombia | Colombia | 0 | 2015-12-28 | 2016-01-03 | 7 | 2015 | 53 | 51874028 | 4580 | 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]);