economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where country = "Guatemala" and year = 2019
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37779 | 37779 | Guatemala | Guatemala | 0 | 2018-12-31 | 2019-01-06 | 7 | 2019 | 1 | 17843914 | 1462 | 0 | TBC | weekly | |
37780 | 37780 | Guatemala | Guatemala | 0 | 2019-01-07 | 2019-01-13 | 7 | 2019 | 2 | 17843914 | 1659 | 0 | TBC | weekly | |
37781 | 37781 | Guatemala | Guatemala | 0 | 2019-01-14 | 2019-01-20 | 7 | 2019 | 3 | 17843914 | 1643 | 0 | TBC | weekly | |
37782 | 37782 | Guatemala | Guatemala | 0 | 2019-01-21 | 2019-01-27 | 7 | 2019 | 4 | 17843914 | 1598 | 0 | TBC | weekly | |
37783 | 37783 | Guatemala | Guatemala | 0 | 2019-01-28 | 2019-02-03 | 7 | 2019 | 5 | 17843914 | 1570 | 0 | TBC | weekly | |
37784 | 37784 | Guatemala | Guatemala | 0 | 2019-02-04 | 2019-02-10 | 7 | 2019 | 6 | 17843914 | 1566 | 0 | TBC | weekly | |
37785 | 37785 | Guatemala | Guatemala | 0 | 2019-02-11 | 2019-02-17 | 7 | 2019 | 7 | 17843914 | 1606 | 0 | TBC | weekly | |
37786 | 37786 | Guatemala | Guatemala | 0 | 2019-02-18 | 2019-02-24 | 7 | 2019 | 8 | 17843914 | 1635 | 0 | TBC | weekly | |
37787 | 37787 | Guatemala | Guatemala | 0 | 2019-02-25 | 2019-03-03 | 7 | 2019 | 9 | 17843914 | 1574 | 0 | TBC | weekly | |
37788 | 37788 | Guatemala | Guatemala | 0 | 2019-03-04 | 2019-03-10 | 7 | 2019 | 10 | 17843914 | 1612 | 0 | TBC | weekly | |
37789 | 37789 | Guatemala | Guatemala | 0 | 2019-03-11 | 2019-03-17 | 7 | 2019 | 11 | 17843914 | 1594 | 0 | TBC | weekly | |
37790 | 37790 | Guatemala | Guatemala | 0 | 2019-03-18 | 2019-03-24 | 7 | 2019 | 12 | 17843914 | 1559 | 0 | TBC | weekly | |
37791 | 37791 | Guatemala | Guatemala | 0 | 2019-03-25 | 2019-03-31 | 7 | 2019 | 13 | 17843914 | 1732 | 0 | TBC | weekly | |
37792 | 37792 | Guatemala | Guatemala | 0 | 2019-04-01 | 2019-04-07 | 7 | 2019 | 14 | 17843914 | 1609 | 0 | TBC | weekly | |
37793 | 37793 | Guatemala | Guatemala | 0 | 2019-04-08 | 2019-04-14 | 7 | 2019 | 15 | 17843914 | 1682 | 0 | TBC | weekly | |
37794 | 37794 | Guatemala | Guatemala | 0 | 2019-04-15 | 2019-04-21 | 7 | 2019 | 16 | 17843914 | 1633 | 0 | TBC | weekly | |
37795 | 37795 | Guatemala | Guatemala | 0 | 2019-04-22 | 2019-04-28 | 7 | 2019 | 17 | 17843914 | 1683 | 0 | TBC | weekly | |
37796 | 37796 | Guatemala | Guatemala | 0 | 2019-04-29 | 2019-05-05 | 7 | 2019 | 18 | 17843914 | 1720 | 0 | TBC | weekly | |
37797 | 37797 | Guatemala | Guatemala | 0 | 2019-05-06 | 2019-05-12 | 7 | 2019 | 19 | 17843914 | 1679 | 0 | TBC | weekly | |
37798 | 37798 | Guatemala | Guatemala | 0 | 2019-05-13 | 2019-05-19 | 7 | 2019 | 20 | 17843914 | 1695 | 0 | TBC | weekly | |
37799 | 37799 | Guatemala | Guatemala | 0 | 2019-05-20 | 2019-05-26 | 7 | 2019 | 21 | 17843914 | 1622 | 0 | TBC | weekly | |
37800 | 37800 | Guatemala | Guatemala | 0 | 2019-05-27 | 2019-06-02 | 7 | 2019 | 22 | 17843914 | 1551 | 0 | TBC | weekly | |
37801 | 37801 | Guatemala | Guatemala | 0 | 2019-06-03 | 2019-06-09 | 7 | 2019 | 23 | 17843914 | 1723 | 0 | TBC | weekly | |
37802 | 37802 | Guatemala | Guatemala | 0 | 2019-06-10 | 2019-06-16 | 7 | 2019 | 24 | 17843914 | 1652 | 0 | TBC | weekly | |
37803 | 37803 | Guatemala | Guatemala | 0 | 2019-06-17 | 2019-06-23 | 7 | 2019 | 25 | 17843914 | 1718 | 0 | TBC | weekly | |
37804 | 37804 | Guatemala | Guatemala | 0 | 2019-06-24 | 2019-06-30 | 7 | 2019 | 26 | 17843914 | 1738 | 0 | TBC | weekly | |
37805 | 37805 | Guatemala | Guatemala | 0 | 2019-07-01 | 2019-07-07 | 7 | 2019 | 27 | 17843914 | 1817 | 0 | TBC | weekly | |
37806 | 37806 | Guatemala | Guatemala | 0 | 2019-07-08 | 2019-07-14 | 7 | 2019 | 28 | 17843914 | 1709 | 0 | TBC | weekly | |
37807 | 37807 | Guatemala | Guatemala | 0 | 2019-07-15 | 2019-07-21 | 7 | 2019 | 29 | 17843914 | 1670 | 0 | TBC | weekly | |
37808 | 37808 | Guatemala | Guatemala | 0 | 2019-07-22 | 2019-07-28 | 7 | 2019 | 30 | 17843914 | 1659 | 0 | TBC | weekly | |
37809 | 37809 | Guatemala | Guatemala | 0 | 2019-07-29 | 2019-08-04 | 7 | 2019 | 31 | 17843914 | 1695 | 0 | TBC | weekly | |
37810 | 37810 | Guatemala | Guatemala | 0 | 2019-08-05 | 2019-08-11 | 7 | 2019 | 32 | 17843914 | 1591 | 0 | TBC | weekly | |
37811 | 37811 | Guatemala | Guatemala | 0 | 2019-08-12 | 2019-08-18 | 7 | 2019 | 33 | 17843914 | 1630 | 0 | TBC | weekly | |
37812 | 37812 | Guatemala | Guatemala | 0 | 2019-08-19 | 2019-08-25 | 7 | 2019 | 34 | 17843914 | 1694 | 0 | TBC | weekly | |
37813 | 37813 | Guatemala | Guatemala | 0 | 2019-08-26 | 2019-09-01 | 7 | 2019 | 35 | 17843914 | 1664 | 0 | TBC | weekly | |
37814 | 37814 | Guatemala | Guatemala | 0 | 2019-09-02 | 2019-09-08 | 7 | 2019 | 36 | 17843914 | 1588 | 0 | TBC | weekly | |
37815 | 37815 | Guatemala | Guatemala | 0 | 2019-09-09 | 2019-09-15 | 7 | 2019 | 37 | 17843914 | 1576 | 0 | TBC | weekly | |
37816 | 37816 | Guatemala | Guatemala | 0 | 2019-09-16 | 2019-09-22 | 7 | 2019 | 38 | 17843914 | 1639 | 0 | TBC | weekly | |
37817 | 37817 | Guatemala | Guatemala | 0 | 2019-09-23 | 2019-09-29 | 7 | 2019 | 39 | 17843914 | 1633 | 0 | TBC | weekly | |
37818 | 37818 | Guatemala | Guatemala | 0 | 2019-09-30 | 2019-10-06 | 7 | 2019 | 40 | 17843914 | 1602 | 0 | TBC | weekly | |
37819 | 37819 | Guatemala | Guatemala | 0 | 2019-10-07 | 2019-10-13 | 7 | 2019 | 41 | 17843914 | 1647 | 0 | TBC | weekly | |
37820 | 37820 | Guatemala | Guatemala | 0 | 2019-10-14 | 2019-10-20 | 7 | 2019 | 42 | 17843914 | 1656 | 0 | TBC | weekly | |
37821 | 37821 | Guatemala | Guatemala | 0 | 2019-10-21 | 2019-10-27 | 7 | 2019 | 43 | 17843914 | 1651 | 0 | TBC | weekly | |
37822 | 37822 | Guatemala | Guatemala | 0 | 2019-10-28 | 2019-11-03 | 7 | 2019 | 44 | 17843914 | 1607 | 0 | TBC | weekly | |
37823 | 37823 | Guatemala | Guatemala | 0 | 2019-11-04 | 2019-11-10 | 7 | 2019 | 45 | 17843914 | 1633 | 0 | TBC | weekly | |
37824 | 37824 | Guatemala | Guatemala | 0 | 2019-11-11 | 2019-11-17 | 7 | 2019 | 46 | 17843914 | 1661 | 0 | TBC | weekly | |
37825 | 37825 | Guatemala | Guatemala | 0 | 2019-11-18 | 2019-11-24 | 7 | 2019 | 47 | 17843914 | 1585 | 0 | TBC | weekly | |
37826 | 37826 | Guatemala | Guatemala | 0 | 2019-11-25 | 2019-12-01 | 7 | 2019 | 48 | 17843914 | 1550 | 0 | TBC | weekly | |
37827 | 37827 | Guatemala | Guatemala | 0 | 2019-12-02 | 2019-12-08 | 7 | 2019 | 49 | 17843914 | 1574 | 0 | TBC | weekly | |
37828 | 37828 | Guatemala | Guatemala | 0 | 2019-12-09 | 2019-12-15 | 7 | 2019 | 50 | 17843914 | 1571 | 0 | TBC | weekly | |
37829 | 37829 | Guatemala | Guatemala | 0 | 2019-12-16 | 2019-12-22 | 7 | 2019 | 51 | 17843914 | 1627 | 0 | TBC | weekly | |
37830 | 37830 | Guatemala | Guatemala | 0 | 2019-12-23 | 2019-12-29 | 7 | 2019 | 52 | 17843914 | 1644 | 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]);