economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where cadence = "weekly", country = "Guatemala" and year = 2018
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37727 | 37727 | Guatemala | Guatemala | 0 | 2018-01-01 | 2018-01-07 | 7 | 2018 | 1 | 17843914 | 1716 | 0 | TBC | weekly | |
37728 | 37728 | Guatemala | Guatemala | 0 | 2018-01-08 | 2018-01-14 | 7 | 2018 | 2 | 17843914 | 1668 | 0 | TBC | weekly | |
37729 | 37729 | Guatemala | Guatemala | 0 | 2018-01-15 | 2018-01-21 | 7 | 2018 | 3 | 17843914 | 1746 | 0 | TBC | weekly | |
37730 | 37730 | Guatemala | Guatemala | 0 | 2018-01-22 | 2018-01-28 | 7 | 2018 | 4 | 17843914 | 1593 | 0 | TBC | weekly | |
37731 | 37731 | Guatemala | Guatemala | 0 | 2018-01-29 | 2018-02-04 | 7 | 2018 | 5 | 17843914 | 1351 | 0 | TBC | weekly | |
37732 | 37732 | Guatemala | Guatemala | 0 | 2018-02-05 | 2018-02-11 | 7 | 2018 | 6 | 17843914 | 1520 | 0 | TBC | weekly | |
37733 | 37733 | Guatemala | Guatemala | 0 | 2018-02-12 | 2018-02-18 | 7 | 2018 | 7 | 17843914 | 1498 | 0 | TBC | weekly | |
37734 | 37734 | Guatemala | Guatemala | 0 | 2018-02-19 | 2018-02-25 | 7 | 2018 | 8 | 17843914 | 1487 | 0 | TBC | weekly | |
37735 | 37735 | Guatemala | Guatemala | 0 | 2018-02-26 | 2018-03-04 | 7 | 2018 | 9 | 17843914 | 1448 | 0 | TBC | weekly | |
37736 | 37736 | Guatemala | Guatemala | 0 | 2018-03-05 | 2018-03-11 | 7 | 2018 | 10 | 17843914 | 1498 | 0 | TBC | weekly | |
37737 | 37737 | Guatemala | Guatemala | 0 | 2018-03-12 | 2018-03-18 | 7 | 2018 | 11 | 17843914 | 1526 | 0 | TBC | weekly | |
37738 | 37738 | Guatemala | Guatemala | 0 | 2018-03-19 | 2018-03-25 | 7 | 2018 | 12 | 17843914 | 1506 | 0 | TBC | weekly | |
37739 | 37739 | Guatemala | Guatemala | 0 | 2018-03-26 | 2018-04-01 | 7 | 2018 | 13 | 17843914 | 1400 | 0 | TBC | weekly | |
37740 | 37740 | Guatemala | Guatemala | 0 | 2018-04-02 | 2018-04-08 | 7 | 2018 | 14 | 17843914 | 1524 | 0 | TBC | weekly | |
37741 | 37741 | Guatemala | Guatemala | 0 | 2018-04-09 | 2018-04-15 | 7 | 2018 | 15 | 17843914 | 1520 | 0 | TBC | weekly | |
37742 | 37742 | Guatemala | Guatemala | 0 | 2018-04-16 | 2018-04-22 | 7 | 2018 | 16 | 17843914 | 1687 | 0 | TBC | weekly | |
37743 | 37743 | Guatemala | Guatemala | 0 | 2018-04-23 | 2018-04-29 | 7 | 2018 | 17 | 17843914 | 1689 | 0 | TBC | weekly | |
37744 | 37744 | Guatemala | Guatemala | 0 | 2018-04-30 | 2018-05-06 | 7 | 2018 | 18 | 17843914 | 1637 | 0 | TBC | weekly | |
37745 | 37745 | Guatemala | Guatemala | 0 | 2018-05-07 | 2018-05-13 | 7 | 2018 | 19 | 17843914 | 1449 | 0 | TBC | weekly | |
37746 | 37746 | Guatemala | Guatemala | 0 | 2018-05-14 | 2018-05-20 | 7 | 2018 | 20 | 17843914 | 1552 | 0 | TBC | weekly | |
37747 | 37747 | Guatemala | Guatemala | 0 | 2018-05-21 | 2018-05-27 | 7 | 2018 | 21 | 17843914 | 1596 | 0 | TBC | weekly | |
37748 | 37748 | Guatemala | Guatemala | 0 | 2018-05-28 | 2018-06-03 | 7 | 2018 | 22 | 17843914 | 1372 | 0 | TBC | weekly | |
37749 | 37749 | Guatemala | Guatemala | 0 | 2018-06-04 | 2018-06-10 | 7 | 2018 | 23 | 17843914 | 1686 | 0 | TBC | weekly | |
37750 | 37750 | Guatemala | Guatemala | 0 | 2018-06-11 | 2018-06-17 | 7 | 2018 | 24 | 17843914 | 1635 | 0 | TBC | weekly | |
37751 | 37751 | Guatemala | Guatemala | 0 | 2018-06-18 | 2018-06-24 | 7 | 2018 | 25 | 17843914 | 1659 | 0 | TBC | weekly | |
37752 | 37752 | Guatemala | Guatemala | 0 | 2018-06-25 | 2018-07-01 | 7 | 2018 | 26 | 17843914 | 1707 | 0 | TBC | weekly | |
37753 | 37753 | Guatemala | Guatemala | 0 | 2018-07-02 | 2018-07-08 | 7 | 2018 | 27 | 17843914 | 1613 | 0 | TBC | weekly | |
37754 | 37754 | Guatemala | Guatemala | 0 | 2018-07-09 | 2018-07-15 | 7 | 2018 | 28 | 17843914 | 1633 | 0 | TBC | weekly | |
37755 | 37755 | Guatemala | Guatemala | 0 | 2018-07-16 | 2018-07-22 | 7 | 2018 | 29 | 17843914 | 1671 | 0 | TBC | weekly | |
37756 | 37756 | Guatemala | Guatemala | 0 | 2018-07-23 | 2018-07-29 | 7 | 2018 | 30 | 17843914 | 1643 | 0 | TBC | weekly | |
37757 | 37757 | Guatemala | Guatemala | 0 | 2018-07-30 | 2018-08-05 | 7 | 2018 | 31 | 17843914 | 1340 | 0 | TBC | weekly | |
37758 | 37758 | Guatemala | Guatemala | 0 | 2018-08-06 | 2018-08-12 | 7 | 2018 | 32 | 17843914 | 1612 | 0 | TBC | weekly | |
37759 | 37759 | Guatemala | Guatemala | 0 | 2018-08-13 | 2018-08-19 | 7 | 2018 | 33 | 17843914 | 1478 | 0 | TBC | weekly | |
37760 | 37760 | Guatemala | Guatemala | 0 | 2018-08-20 | 2018-08-26 | 7 | 2018 | 34 | 17843914 | 1586 | 0 | TBC | weekly | |
37761 | 37761 | Guatemala | Guatemala | 0 | 2018-08-27 | 2018-09-02 | 7 | 2018 | 35 | 17843914 | 1280 | 0 | TBC | weekly | |
37762 | 37762 | Guatemala | Guatemala | 0 | 2018-09-03 | 2018-09-09 | 7 | 2018 | 36 | 17843914 | 1587 | 0 | TBC | weekly | |
37763 | 37763 | Guatemala | Guatemala | 0 | 2018-09-10 | 2018-09-16 | 7 | 2018 | 37 | 17843914 | 1584 | 0 | TBC | weekly | |
37764 | 37764 | Guatemala | Guatemala | 0 | 2018-09-17 | 2018-09-23 | 7 | 2018 | 38 | 17843914 | 1548 | 0 | TBC | weekly | |
37765 | 37765 | Guatemala | Guatemala | 0 | 2018-09-24 | 2018-09-30 | 7 | 2018 | 39 | 17843914 | 1581 | 0 | TBC | weekly | |
37766 | 37766 | Guatemala | Guatemala | 0 | 2018-10-01 | 2018-10-07 | 7 | 2018 | 40 | 17843914 | 1577 | 0 | TBC | weekly | |
37767 | 37767 | Guatemala | Guatemala | 0 | 2018-10-08 | 2018-10-14 | 7 | 2018 | 41 | 17843914 | 1644 | 0 | TBC | weekly | |
37768 | 37768 | Guatemala | Guatemala | 0 | 2018-10-15 | 2018-10-21 | 7 | 2018 | 42 | 17843914 | 1642 | 0 | TBC | weekly | |
37769 | 37769 | Guatemala | Guatemala | 0 | 2018-10-22 | 2018-10-28 | 7 | 2018 | 43 | 17843914 | 1534 | 0 | TBC | weekly | |
37770 | 37770 | Guatemala | Guatemala | 0 | 2018-10-29 | 2018-11-04 | 7 | 2018 | 44 | 17843914 | 1430 | 0 | TBC | weekly | |
37771 | 37771 | Guatemala | Guatemala | 0 | 2018-11-05 | 2018-11-11 | 7 | 2018 | 45 | 17843914 | 1608 | 0 | TBC | weekly | |
37772 | 37772 | Guatemala | Guatemala | 0 | 2018-11-12 | 2018-11-18 | 7 | 2018 | 46 | 17843914 | 1577 | 0 | TBC | weekly | |
37773 | 37773 | Guatemala | Guatemala | 0 | 2018-11-19 | 2018-11-25 | 7 | 2018 | 47 | 17843914 | 1556 | 0 | TBC | weekly | |
37774 | 37774 | Guatemala | Guatemala | 0 | 2018-11-26 | 2018-12-02 | 7 | 2018 | 48 | 17843914 | 1568 | 0 | TBC | weekly | |
37775 | 37775 | Guatemala | Guatemala | 0 | 2018-12-03 | 2018-12-09 | 7 | 2018 | 49 | 17843914 | 1529 | 0 | TBC | weekly | |
37776 | 37776 | Guatemala | Guatemala | 0 | 2018-12-10 | 2018-12-16 | 7 | 2018 | 50 | 17843914 | 1582 | 0 | TBC | weekly | |
37777 | 37777 | Guatemala | Guatemala | 0 | 2018-12-17 | 2018-12-23 | 7 | 2018 | 51 | 17843914 | 1620 | 0 | TBC | weekly | |
37778 | 37778 | Guatemala | Guatemala | 0 | 2018-12-24 | 2018-12-30 | 7 | 2018 | 52 | 17843914 | 1782 | 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]);