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 = 2021
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37884 | 37884 | Guatemala | Guatemala | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 17843914 | 1904 | 192 | TBC | weekly | |
37885 | 37885 | Guatemala | Guatemala | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 17843914 | 1930 | 229 | TBC | weekly | |
37886 | 37886 | Guatemala | Guatemala | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 17843914 | 1898 | 211 | TBC | weekly | |
37887 | 37887 | Guatemala | Guatemala | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 17843914 | 1837 | 178 | TBC | weekly | |
37888 | 37888 | Guatemala | Guatemala | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 17843914 | 1776 | 241 | TBC | weekly | |
37889 | 37889 | Guatemala | Guatemala | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 17843914 | 1785 | 240 | TBC | weekly | |
37890 | 37890 | Guatemala | Guatemala | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 17843914 | 1706 | 158 | TBC | weekly | |
37891 | 37891 | Guatemala | Guatemala | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 17843914 | 1748 | 111 | TBC | weekly | |
37892 | 37892 | Guatemala | Guatemala | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 17843914 | 1811 | 80 | TBC | weekly | |
37893 | 37893 | Guatemala | Guatemala | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 17843914 | 1769 | 98 | TBC | weekly | |
37894 | 37894 | Guatemala | Guatemala | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 17843914 | 1798 | 132 | TBC | weekly | |
37895 | 37895 | Guatemala | Guatemala | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 17843914 | 1970 | 102 | TBC | weekly | |
37896 | 37896 | Guatemala | Guatemala | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 17843914 | 1965 | 89 | TBC | weekly | |
37897 | 37897 | Guatemala | Guatemala | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 17843914 | 2064 | 125 | TBC | weekly | |
37898 | 37898 | Guatemala | Guatemala | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 17843914 | 2221 | 205 | TBC | weekly | |
37899 | 37899 | Guatemala | Guatemala | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 17843914 | 2191 | 189 | TBC | weekly | |
37900 | 37900 | Guatemala | Guatemala | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 17843914 | 2184 | 148 | TBC | weekly | |
37901 | 37901 | Guatemala | Guatemala | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 17843914 | 2133 | 175 | TBC | weekly | |
37902 | 37902 | Guatemala | Guatemala | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 17843914 | 2092 | 154 | TBC | weekly | |
37903 | 37903 | Guatemala | Guatemala | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 17843914 | 2135 | 113 | TBC | weekly | |
37904 | 37904 | Guatemala | Guatemala | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 17843914 | 2079 | 137 | TBC | weekly | |
37905 | 37905 | Guatemala | Guatemala | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 17843914 | 2157 | 157 | TBC | weekly | |
37906 | 37906 | Guatemala | Guatemala | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 17843914 | 2209 | 161 | TBC | weekly | |
37907 | 37907 | Guatemala | Guatemala | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 17843914 | 2156 | 239 | TBC | weekly | |
37908 | 37908 | Guatemala | Guatemala | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 17843914 | 2188 | 356 | TBC | weekly | |
37909 | 37909 | Guatemala | Guatemala | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 17843914 | 2360 | 411 | TBC | weekly | |
37910 | 37910 | Guatemala | Guatemala | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 17843914 | 2467 | 252 | TBC | weekly | |
37911 | 37911 | Guatemala | Guatemala | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 17843914 | 2537 | 201 | TBC | weekly | |
37912 | 37912 | Guatemala | Guatemala | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 17843914 | 2675 | 186 | TBC | weekly | |
37913 | 37913 | Guatemala | Guatemala | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 17843914 | 2732 | 313 | TBC | weekly | |
37914 | 37914 | Guatemala | Guatemala | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 17843914 | 2823 | 358 | TBC | weekly | |
37915 | 37915 | Guatemala | Guatemala | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 17843914 | 2981 | 384 | TBC | weekly | |
37916 | 37916 | Guatemala | Guatemala | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 17843914 | 3329 | 345 | TBC | weekly | |
37917 | 37917 | Guatemala | Guatemala | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 17843914 | 3556 | 358 | TBC | weekly | |
37918 | 37918 | Guatemala | Guatemala | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 17843914 | 3686 | 407 | TBC | weekly | |
37919 | 37919 | Guatemala | Guatemala | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 17843914 | 3855 | 445 | TBC | weekly | |
37920 | 37920 | Guatemala | Guatemala | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 17843914 | 3697 | 330 | TBC | weekly | |
37921 | 37921 | Guatemala | Guatemala | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 17843914 | 3206 | 335 | TBC | weekly | |
37922 | 37922 | Guatemala | Guatemala | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 17843914 | 2956 | 355 | TBC | weekly | |
37923 | 37923 | Guatemala | Guatemala | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 17843914 | 2649 | 297 | TBC | weekly | |
37924 | 37924 | Guatemala | Guatemala | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 17843914 | 2412 | 303 | TBC | weekly | |
37925 | 37925 | Guatemala | Guatemala | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 17843914 | 2108 | 370 | TBC | weekly | |
37926 | 37926 | Guatemala | Guatemala | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 17843914 | 1984 | 394 | TBC | weekly | |
37927 | 37927 | Guatemala | Guatemala | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 17843914 | 1933 | 343 | TBC | weekly | |
37928 | 37928 | Guatemala | Guatemala | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 17843914 | 1807 | 277 | TBC | weekly | |
37929 | 37929 | Guatemala | Guatemala | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 17843914 | 1783 | 126 | TBC | weekly | |
37930 | 37930 | Guatemala | Guatemala | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 17843914 | 1714 | 88 | TBC | weekly | |
37931 | 37931 | Guatemala | Guatemala | 0 | 2021-11-29 | 2021-12-05 | 7 | 2021 | 48 | 17843914 | 1802 | 58 | TBC | weekly | |
37932 | 37932 | Guatemala | Guatemala | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 17843914 | 1732 | 58 | TBC | weekly | |
37933 | 37933 | Guatemala | Guatemala | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 17843914 | 1792 | 28 | TBC | weekly | |
37934 | 37934 | Guatemala | Guatemala | 0 | 2021-12-20 | 2021-12-26 | 7 | 2021 | 51 | 17843914 | 1817 | 25 | TBC | weekly | |
37935 | 37935 | Guatemala | Guatemala | 0 | 2021-12-27 | 2022-01-02 | 7 | 2021 | 52 | 17843914 | 2062 | 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]);