economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
30 rows where country = "Guatemala" and year = 2022
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: total_deaths, covid_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37936 | 37936 | Guatemala | Guatemala | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 17843914 | 2069 | 16 | TBC | weekly | |
37937 | 37937 | Guatemala | Guatemala | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 17843914 | 2123 | 51 | TBC | weekly | |
37938 | 37938 | Guatemala | Guatemala | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 17843914 | 2189 | 92 | TBC | weekly | |
37939 | 37939 | Guatemala | Guatemala | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 17843914 | 2031 | 111 | TBC | weekly | |
37940 | 37940 | Guatemala | Guatemala | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 17843914 | 2146 | 122 | TBC | weekly | |
37941 | 37941 | Guatemala | Guatemala | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 17843914 | 2193 | 136 | TBC | weekly | |
37942 | 37942 | Guatemala | Guatemala | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 17843914 | 2235 | 150 | TBC | weekly | |
37943 | 37943 | Guatemala | Guatemala | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 17843914 | 2093 | 184 | TBC | weekly | |
37944 | 37944 | Guatemala | Guatemala | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 17843914 | 2049 | 106 | TBC | weekly | |
37945 | 37945 | Guatemala | Guatemala | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 17843914 | 1973 | 76 | TBC | weekly | |
37946 | 37946 | Guatemala | Guatemala | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 17843914 | 1892 | 85 | TBC | weekly | |
37947 | 37947 | Guatemala | Guatemala | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 17843914 | 1797 | 47 | TBC | weekly | |
37948 | 37948 | Guatemala | Guatemala | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 17843914 | 1817 | 42 | TBC | weekly | |
37949 | 37949 | Guatemala | Guatemala | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 17843914 | 1716 | 50 | TBC | weekly | |
37950 | 37950 | Guatemala | Guatemala | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 17843914 | 1707 | 53 | TBC | weekly | |
37951 | 37951 | Guatemala | Guatemala | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 17843914 | 1696 | 90 | TBC | weekly | |
37952 | 37952 | Guatemala | Guatemala | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 17843914 | 1612 | 80 | TBC | weekly | |
37953 | 37953 | Guatemala | Guatemala | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 17843914 | 1688 | 99 | TBC | weekly | |
37954 | 37954 | Guatemala | Guatemala | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 17843914 | 1645 | 123 | TBC | weekly | |
37955 | 37955 | Guatemala | Guatemala | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 17843914 | 1606 | 132 | TBC | weekly | |
37956 | 37956 | Guatemala | Guatemala | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 17843914 | 1606 | 163 | TBC | weekly | |
37957 | 37957 | Guatemala | Guatemala | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 17843914 | 1667 | 102 | TBC | weekly | |
37958 | 37958 | Guatemala | Guatemala | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 17843914 | 1603 | 68 | TBC | weekly | |
37959 | 37959 | Guatemala | Guatemala | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 17843914 | 1593 | 114 | TBC | weekly | |
37960 | 37960 | Guatemala | Guatemala | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 17843914 | 1726 | 96 | TBC | weekly | |
37961 | 37961 | Guatemala | Guatemala | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 17843914 | 1790 | 103 | TBC | weekly | |
37962 | 37962 | Guatemala | Guatemala | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 17843914 | 1828 | 115 | TBC | weekly | |
37963 | 37963 | Guatemala | Guatemala | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 17843914 | 1876 | 107 | TBC | weekly | |
37964 | 37964 | Guatemala | Guatemala | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 17843914 | 1776 | 112 | TBC | weekly | |
37965 | 37965 | Guatemala | Guatemala | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 17843914 | 1742 | 103 | 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]);