economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
45 rows where country = "Colombia" and year = 2022
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19596 | 19596 | Colombia | Colombia | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 51874028 | 6396 | 312 | TBC | weekly | |
19597 | 19597 | Colombia | Colombia | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 51874028 | 7070 | 658 | TBC | weekly | |
19598 | 19598 | Colombia | Colombia | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 51874028 | 7896 | 1244 | TBC | weekly | |
19599 | 19599 | Colombia | Colombia | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 51874028 | 8279 | 1839 | TBC | weekly | |
19600 | 19600 | Colombia | Colombia | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 51874028 | 7741 | 1678 | TBC | weekly | |
19601 | 19601 | Colombia | Colombia | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 51874028 | 6898 | 1358 | TBC | weekly | |
19602 | 19602 | Colombia | Colombia | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 51874028 | 6107 | 991 | TBC | weekly | |
19603 | 19603 | Colombia | Colombia | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 51874028 | 5448 | 587 | TBC | weekly | |
19604 | 19604 | Colombia | Colombia | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 51874028 | 5189 | 398 | TBC | weekly | |
19605 | 19605 | Colombia | Colombia | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 51874028 | 5063 | 206 | TBC | weekly | |
19606 | 19606 | Colombia | Colombia | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 51874028 | 4965 | 155 | TBC | weekly | |
19607 | 19607 | Colombia | Colombia | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 51874028 | 4964 | 121 | TBC | weekly | |
19608 | 19608 | Colombia | Colombia | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 51874028 | 4885 | 87 | TBC | weekly | |
19609 | 19609 | Colombia | Colombia | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 51874028 | 4912 | 59 | TBC | weekly | |
19610 | 19610 | Colombia | Colombia | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 51874028 | 4779 | 30 | TBC | weekly | |
19611 | 19611 | Colombia | Colombia | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 51874028 | 4987 | 29 | TBC | weekly | |
19612 | 19612 | Colombia | Colombia | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 51874028 | 4929 | 19 | TBC | weekly | |
19613 | 19613 | Colombia | Colombia | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 51874028 | 5173 | 12 | TBC | weekly | |
19614 | 19614 | Colombia | Colombia | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 51874028 | 5129 | 12 | TBC | weekly | |
19615 | 19615 | Colombia | Colombia | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 51874028 | 5113 | 12 | TBC | weekly | |
19616 | 19616 | Colombia | Colombia | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 51874028 | 5155 | 21 | TBC | weekly | |
19617 | 19617 | Colombia | Colombia | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 51874028 | 5300 | 13 | TBC | weekly | |
19618 | 19618 | Colombia | Colombia | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 51874028 | 5344 | 27 | TBC | weekly | |
19619 | 19619 | Colombia | Colombia | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 51874028 | 5378 | 24 | TBC | weekly | |
19620 | 19620 | Colombia | Colombia | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 51874028 | 5403 | 52 | TBC | weekly | |
19621 | 19621 | Colombia | Colombia | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 51874028 | 5882 | 100 | TBC | weekly | |
19622 | 19622 | Colombia | Colombia | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 51874028 | 5945 | 132 | TBC | weekly | |
19623 | 19623 | Colombia | Colombia | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 51874028 | 5952 | 163 | TBC | weekly | |
19624 | 19624 | Colombia | Colombia | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 51874028 | 5420 | 238 | TBC | weekly | |
19625 | 19625 | Colombia | Colombia | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 51874028 | 5455 | 242 | TBC | weekly | |
19626 | 19626 | Colombia | Colombia | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 51874028 | 5286 | 230 | TBC | weekly | |
19627 | 19627 | Colombia | Colombia | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 51874028 | 5259 | 212 | TBC | weekly | |
19628 | 19628 | Colombia | Colombia | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 51874028 | 5047 | 119 | TBC | weekly | |
19629 | 19629 | Colombia | Colombia | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 51874028 | 5165 | 113 | TBC | weekly | |
19630 | 19630 | Colombia | Colombia | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 51874028 | 5212 | 127 | TBC | weekly | |
19631 | 19631 | Colombia | Colombia | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 51874028 | 5136 | 62 | TBC | weekly | |
19632 | 19632 | Colombia | Colombia | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 51874028 | 4879 | 38 | TBC | weekly | |
19633 | 19633 | Colombia | Colombia | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 51874028 | 4876 | 23 | TBC | weekly | |
19634 | 19634 | Colombia | Colombia | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 51874028 | 4861 | 25 | TBC | weekly | |
19635 | 19635 | Colombia | Colombia | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 51874028 | 4970 | 13 | TBC | weekly | |
19636 | 19636 | Colombia | Colombia | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 51874028 | 5030 | 13 | TBC | weekly | |
19637 | 19637 | Colombia | Colombia | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 51874028 | 5095 | 7 | TBC | weekly | |
19638 | 19638 | Colombia | Colombia | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 51874028 | 4968 | 10 | TBC | weekly | |
19639 | 19639 | Colombia | Colombia | 0 | 2022-10-31 | 2022-11-06 | 7 | 2022 | 44 | 51874028 | 4961 | 13 | TBC | weekly | |
19640 | 19640 | Colombia | Colombia | 0 | 2022-11-07 | 2022-11-13 | 7 | 2022 | 45 | 51874028 | 4889 | 12 | 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]);