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 = 2020 sorted by week
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19491 | 19491 | Colombia | Colombia | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 51874028 | 5019 | 0 | TBC | weekly | |
19492 | 19492 | Colombia | Colombia | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 51874028 | 5050 | 0 | TBC | weekly | |
19493 | 19493 | Colombia | Colombia | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 51874028 | 4937 | 0 | TBC | weekly | |
19494 | 19494 | Colombia | Colombia | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 51874028 | 4793 | 0 | TBC | weekly | |
19495 | 19495 | Colombia | Colombia | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 51874028 | 4651 | 0 | TBC | weekly | |
19496 | 19496 | Colombia | Colombia | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 51874028 | 4760 | 0 | TBC | weekly | |
19497 | 19497 | Colombia | Colombia | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 51874028 | 4736 | 0 | TBC | weekly | |
19498 | 19498 | Colombia | Colombia | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 51874028 | 4729 | 0 | TBC | weekly | |
19499 | 19499 | Colombia | Colombia | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 51874028 | 4565 | 0 | TBC | weekly | |
19500 | 19500 | Colombia | Colombia | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 51874028 | 4567 | 0 | TBC | weekly | |
19501 | 19501 | Colombia | Colombia | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 51874028 | 4480 | 0 | TBC | weekly | |
19502 | 19502 | Colombia | Colombia | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 51874028 | 4529 | 2 | TBC | weekly | |
19503 | 19503 | Colombia | Colombia | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 51874028 | 4358 | 8 | TBC | weekly | |
19504 | 19504 | Colombia | Colombia | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 51874028 | 4219 | 25 | TBC | weekly | |
19505 | 19505 | Colombia | Colombia | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 51874028 | 4276 | 74 | TBC | weekly | |
19506 | 19506 | Colombia | Colombia | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 51874028 | 4376 | 70 | TBC | weekly | |
19507 | 19507 | Colombia | Colombia | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 51874028 | 4359 | 65 | TBC | weekly | |
19508 | 19508 | Colombia | Colombia | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 51874028 | 4304 | 96 | TBC | weekly | |
19509 | 19509 | Colombia | Colombia | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 51874028 | 4488 | 123 | TBC | weekly | |
19510 | 19510 | Colombia | Colombia | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 51874028 | 4613 | 111 | TBC | weekly | |
19511 | 19511 | Colombia | Colombia | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 51874028 | 4727 | 153 | TBC | weekly | |
19512 | 19512 | Colombia | Colombia | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 51874028 | 4772 | 212 | TBC | weekly | |
19513 | 19513 | Colombia | Colombia | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 51874028 | 5190 | 320 | TBC | weekly | |
19514 | 19514 | Colombia | Colombia | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 51874028 | 5385 | 408 | TBC | weekly | |
19515 | 19515 | Colombia | Colombia | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 51874028 | 5828 | 570 | TBC | weekly | |
19516 | 19516 | Colombia | Colombia | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 51874028 | 6166 | 941 | TBC | weekly | |
19517 | 19517 | Colombia | Colombia | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 51874028 | 6291 | 886 | TBC | weekly | |
19518 | 19518 | Colombia | Colombia | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 51874028 | 6796 | 1243 | TBC | weekly | |
19519 | 19519 | Colombia | Colombia | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 51874028 | 7377 | 1429 | TBC | weekly | |
19520 | 19520 | Colombia | Colombia | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 51874028 | 7767 | 1789 | TBC | weekly | |
19521 | 19521 | Colombia | Colombia | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 51874028 | 8131 | 2125 | TBC | weekly | |
19522 | 19522 | Colombia | Colombia | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 51874028 | 7926 | 2192 | TBC | weekly | |
19523 | 19523 | Colombia | Colombia | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 51874028 | 7693 | 2255 | TBC | weekly | |
19524 | 19524 | Colombia | Colombia | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 51874028 | 7193 | 2219 | TBC | weekly | |
19525 | 19525 | Colombia | Colombia | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 51874028 | 6845 | 2047 | TBC | weekly | |
19526 | 19526 | Colombia | Colombia | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 51874028 | 6613 | 2049 | TBC | weekly | |
19527 | 19527 | Colombia | Colombia | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 51874028 | 6427 | 1512 | TBC | weekly | |
19528 | 19528 | Colombia | Colombia | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 51874028 | 6290 | 1284 | TBC | weekly | |
19529 | 19529 | Colombia | Colombia | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 51874028 | 6200 | 1280 | TBC | weekly | |
19530 | 19530 | Colombia | Colombia | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 51874028 | 6053 | 1224 | TBC | weekly | |
19531 | 19531 | Colombia | Colombia | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 51874028 | 6227 | 1122 | TBC | weekly | |
19532 | 19532 | Colombia | Colombia | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 51874028 | 6226 | 1136 | TBC | weekly | |
19533 | 19533 | Colombia | Colombia | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 51874028 | 6349 | 1184 | TBC | weekly | |
19534 | 19534 | Colombia | Colombia | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 51874028 | 6124 | 1361 | TBC | weekly | |
19535 | 19535 | Colombia | Colombia | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 51874028 | 6301 | 1276 | TBC | weekly | |
19536 | 19536 | Colombia | Colombia | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 51874028 | 6169 | 1240 | TBC | weekly | |
19537 | 19537 | Colombia | Colombia | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 51874028 | 6281 | 1256 | TBC | weekly | |
19538 | 19538 | Colombia | Colombia | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 51874028 | 6313 | 1297 | TBC | weekly | |
19539 | 19539 | Colombia | Colombia | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 51874028 | 6250 | 1224 | TBC | weekly | |
19540 | 19540 | Colombia | Colombia | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 51874028 | 6682 | 1245 | TBC | weekly | |
19541 | 19541 | Colombia | Colombia | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 51874028 | 6724 | 1422 | TBC | weekly | |
19542 | 19542 | Colombia | Colombia | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 51874028 | 7237 | 1696 | TBC | weekly | |
19543 | 19543 | Colombia | Colombia | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 51874028 | 7881 | 1794 | 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]);