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 = 2019 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19490 | 19490 | Colombia | Colombia | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 51874028 | 4973 | 0 | TBC | weekly | |
19489 | 19489 | Colombia | Colombia | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 51874028 | 4808 | 0 | TBC | weekly | |
19488 | 19488 | Colombia | Colombia | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 51874028 | 4744 | 0 | TBC | weekly | |
19487 | 19487 | Colombia | Colombia | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 51874028 | 4758 | 0 | TBC | weekly | |
19486 | 19486 | Colombia | Colombia | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 51874028 | 4709 | 0 | TBC | weekly | |
19485 | 19485 | Colombia | Colombia | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 51874028 | 4738 | 0 | TBC | weekly | |
19484 | 19484 | Colombia | Colombia | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 51874028 | 4649 | 0 | TBC | weekly | |
19483 | 19483 | Colombia | Colombia | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 51874028 | 4706 | 0 | TBC | weekly | |
19482 | 19482 | Colombia | Colombia | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 51874028 | 4732 | 0 | TBC | weekly | |
19481 | 19481 | Colombia | Colombia | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 51874028 | 4600 | 0 | TBC | weekly | |
19480 | 19480 | Colombia | Colombia | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 51874028 | 4581 | 0 | TBC | weekly | |
19479 | 19479 | Colombia | Colombia | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 51874028 | 4540 | 0 | TBC | weekly | |
19478 | 19478 | Colombia | Colombia | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 51874028 | 4582 | 0 | TBC | weekly | |
19477 | 19477 | Colombia | Colombia | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 51874028 | 4392 | 0 | TBC | weekly | |
19476 | 19476 | Colombia | Colombia | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 51874028 | 4599 | 0 | TBC | weekly | |
19475 | 19475 | Colombia | Colombia | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 51874028 | 4568 | 0 | TBC | weekly | |
19474 | 19474 | Colombia | Colombia | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 51874028 | 4662 | 0 | TBC | weekly | |
19473 | 19473 | Colombia | Colombia | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 51874028 | 4792 | 0 | TBC | weekly | |
19472 | 19472 | Colombia | Colombia | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 51874028 | 4865 | 0 | TBC | weekly | |
19471 | 19471 | Colombia | Colombia | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 51874028 | 4645 | 0 | TBC | weekly | |
19470 | 19470 | Colombia | Colombia | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 51874028 | 4683 | 0 | TBC | weekly | |
19469 | 19469 | Colombia | Colombia | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 51874028 | 4676 | 0 | TBC | weekly | |
19468 | 19468 | Colombia | Colombia | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 51874028 | 4623 | 0 | TBC | weekly | |
19467 | 19467 | Colombia | Colombia | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 51874028 | 4873 | 0 | TBC | weekly | |
19466 | 19466 | Colombia | Colombia | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 51874028 | 4837 | 0 | TBC | weekly | |
19465 | 19465 | Colombia | Colombia | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 51874028 | 4820 | 0 | TBC | weekly | |
19464 | 19464 | Colombia | Colombia | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 51874028 | 4766 | 0 | TBC | weekly | |
19463 | 19463 | Colombia | Colombia | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 51874028 | 4913 | 0 | TBC | weekly | |
19462 | 19462 | Colombia | Colombia | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 51874028 | 4693 | 0 | TBC | weekly | |
19461 | 19461 | Colombia | Colombia | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 51874028 | 4824 | 0 | TBC | weekly | |
19460 | 19460 | Colombia | Colombia | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 51874028 | 4532 | 0 | TBC | weekly | |
19459 | 19459 | Colombia | Colombia | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 51874028 | 4637 | 0 | TBC | weekly | |
19458 | 19458 | Colombia | Colombia | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 51874028 | 4397 | 0 | TBC | weekly | |
19457 | 19457 | Colombia | Colombia | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 51874028 | 4579 | 0 | TBC | weekly | |
19456 | 19456 | Colombia | Colombia | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 51874028 | 4636 | 0 | TBC | weekly | |
19455 | 19455 | Colombia | Colombia | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 51874028 | 4414 | 0 | TBC | weekly | |
19454 | 19454 | Colombia | Colombia | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 51874028 | 4383 | 0 | TBC | weekly | |
19453 | 19453 | Colombia | Colombia | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 51874028 | 4510 | 0 | TBC | weekly | |
19452 | 19452 | Colombia | Colombia | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 51874028 | 4433 | 0 | TBC | weekly | |
19451 | 19451 | Colombia | Colombia | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 51874028 | 4464 | 0 | TBC | weekly | |
19450 | 19450 | Colombia | Colombia | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 51874028 | 4474 | 0 | TBC | weekly | |
19449 | 19449 | Colombia | Colombia | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 51874028 | 4456 | 0 | TBC | weekly | |
19448 | 19448 | Colombia | Colombia | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 51874028 | 4406 | 0 | TBC | weekly | |
19447 | 19447 | Colombia | Colombia | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 51874028 | 4431 | 0 | TBC | weekly | |
19446 | 19446 | Colombia | Colombia | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 51874028 | 4449 | 0 | TBC | weekly | |
19445 | 19445 | Colombia | Colombia | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 51874028 | 4435 | 0 | TBC | weekly | |
19444 | 19444 | Colombia | Colombia | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 51874028 | 4449 | 0 | TBC | weekly | |
19443 | 19443 | Colombia | Colombia | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 51874028 | 4507 | 0 | TBC | weekly | |
19442 | 19442 | Colombia | Colombia | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 51874028 | 4566 | 0 | TBC | weekly | |
19441 | 19441 | Colombia | Colombia | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 51874028 | 4798 | 0 | TBC | weekly | |
19440 | 19440 | Colombia | Colombia | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 51874028 | 4663 | 0 | TBC | weekly | |
19439 | 19439 | Colombia | Colombia | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 51874028 | 5311 | 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]);