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 = 2021 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19595 | 19595 | Colombia | Colombia | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 51874028 | 5959 | 265 | TBC | weekly | |
19594 | 19594 | Colombia | Colombia | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 51874028 | 5901 | 303 | TBC | weekly | |
19593 | 19593 | Colombia | Colombia | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 51874028 | 5510 | 351 | TBC | weekly | |
19592 | 19592 | Colombia | Colombia | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 51874028 | 5635 | 327 | TBC | weekly | |
19591 | 19591 | Colombia | Colombia | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 51874028 | 5523 | 343 | TBC | weekly | |
19590 | 19590 | Colombia | Colombia | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 51874028 | 5309 | 344 | TBC | weekly | |
19589 | 19589 | Colombia | Colombia | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 51874028 | 5316 | 284 | TBC | weekly | |
19588 | 19588 | Colombia | Colombia | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 51874028 | 5317 | 276 | TBC | weekly | |
19587 | 19587 | Colombia | Colombia | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 51874028 | 5156 | 252 | TBC | weekly | |
19586 | 19586 | Colombia | Colombia | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 51874028 | 5080 | 214 | TBC | weekly | |
19585 | 19585 | Colombia | Colombia | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 51874028 | 5041 | 202 | TBC | weekly | |
19584 | 19584 | Colombia | Colombia | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 51874028 | 5105 | 242 | TBC | weekly | |
19583 | 19583 | Colombia | Colombia | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 51874028 | 5180 | 222 | TBC | weekly | |
19582 | 19582 | Colombia | Colombia | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 51874028 | 5051 | 256 | TBC | weekly | |
19581 | 19581 | Colombia | Colombia | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 51874028 | 5259 | 250 | TBC | weekly | |
19580 | 19580 | Colombia | Colombia | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 51874028 | 5028 | 248 | TBC | weekly | |
19579 | 19579 | Colombia | Colombia | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 51874028 | 5099 | 369 | TBC | weekly | |
19578 | 19578 | Colombia | Colombia | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 51874028 | 5136 | 467 | TBC | weekly | |
19577 | 19577 | Colombia | Colombia | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 51874028 | 5383 | 595 | TBC | weekly | |
19576 | 19576 | Colombia | Colombia | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 51874028 | 5673 | 757 | TBC | weekly | |
19575 | 19575 | Colombia | Colombia | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 51874028 | 5891 | 1001 | TBC | weekly | |
19574 | 19574 | Colombia | Colombia | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 51874028 | 6385 | 1460 | TBC | weekly | |
19573 | 19573 | Colombia | Colombia | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 51874028 | 7150 | 2130 | TBC | weekly | |
19572 | 19572 | Colombia | Colombia | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 51874028 | 7761 | 2561 | TBC | weekly | |
19571 | 19571 | Colombia | Colombia | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 51874028 | 8895 | 3481 | TBC | weekly | |
19570 | 19570 | Colombia | Colombia | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 51874028 | 9705 | 3930 | TBC | weekly | |
19569 | 19569 | Colombia | Colombia | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 51874028 | 10412 | 4218 | TBC | weekly | |
19568 | 19568 | Colombia | Colombia | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 51874028 | 10606 | 4744 | TBC | weekly | |
19567 | 19567 | Colombia | Colombia | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 51874028 | 10558 | 4156 | TBC | weekly | |
19566 | 19566 | Colombia | Colombia | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 51874028 | 10199 | 3817 | TBC | weekly | |
19565 | 19565 | Colombia | Colombia | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 51874028 | 9874 | 3679 | TBC | weekly | |
19564 | 19564 | Colombia | Colombia | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 51874028 | 9390 | 3558 | TBC | weekly | |
19563 | 19563 | Colombia | Colombia | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 51874028 | 9142 | 3424 | TBC | weekly | |
19562 | 19562 | Colombia | Colombia | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 51874028 | 9061 | 3446 | TBC | weekly | |
19561 | 19561 | Colombia | Colombia | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 51874028 | 8965 | 3377 | TBC | weekly | |
19560 | 19560 | Colombia | Colombia | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 51874028 | 8850 | 3126 | TBC | weekly | |
19559 | 19559 | Colombia | Colombia | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 51874028 | 8872 | 3023 | TBC | weekly | |
19558 | 19558 | Colombia | Colombia | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 51874028 | 8519 | 2439 | TBC | weekly | |
19557 | 19557 | Colombia | Colombia | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 51874028 | 7279 | 1795 | TBC | weekly | |
19556 | 19556 | Colombia | Colombia | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 51874028 | 6557 | 1139 | TBC | weekly | |
19555 | 19555 | Colombia | Colombia | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 51874028 | 6015 | 927 | TBC | weekly | |
19554 | 19554 | Colombia | Colombia | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 51874028 | 5654 | 885 | TBC | weekly | |
19553 | 19553 | Colombia | Colombia | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 51874028 | 5368 | 640 | TBC | weekly | |
19552 | 19552 | Colombia | Colombia | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 51874028 | 5624 | 737 | TBC | weekly | |
19551 | 19551 | Colombia | Colombia | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 51874028 | 5620 | 932 | TBC | weekly | |
19550 | 19550 | Colombia | Colombia | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 51874028 | 5969 | 1229 | TBC | weekly | |
19549 | 19549 | Colombia | Colombia | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 51874028 | 6401 | 1612 | TBC | weekly | |
19548 | 19548 | Colombia | Colombia | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 51874028 | 7103 | 2010 | TBC | weekly | |
19547 | 19547 | Colombia | Colombia | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 51874028 | 7753 | 2609 | TBC | weekly | |
19546 | 19546 | Colombia | Colombia | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 51874028 | 8573 | 2743 | TBC | weekly | |
19545 | 19545 | Colombia | Colombia | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 51874028 | 8537 | 2517 | TBC | weekly | |
19544 | 19544 | Colombia | Colombia | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 51874028 | 8054 | 2149 | 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]);