economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Guatemala" and year = 2020
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37831 | 37831 | Guatemala | Guatemala | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 17843914 | 1757 | 0 | TBC | weekly | |
37832 | 37832 | Guatemala | Guatemala | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 17843914 | 1670 | 0 | TBC | weekly | |
37833 | 37833 | Guatemala | Guatemala | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 17843914 | 1663 | 0 | TBC | weekly | |
37834 | 37834 | Guatemala | Guatemala | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 17843914 | 1607 | 0 | TBC | weekly | |
37835 | 37835 | Guatemala | Guatemala | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 17843914 | 1599 | 0 | TBC | weekly | |
37836 | 37836 | Guatemala | Guatemala | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 17843914 | 1610 | 0 | TBC | weekly | |
37837 | 37837 | Guatemala | Guatemala | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 17843914 | 1586 | 0 | TBC | weekly | |
37838 | 37838 | Guatemala | Guatemala | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 17843914 | 1517 | 0 | TBC | weekly | |
37839 | 37839 | Guatemala | Guatemala | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 17843914 | 1565 | 0 | TBC | weekly | |
37840 | 37840 | Guatemala | Guatemala | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 17843914 | 1581 | 0 | TBC | weekly | |
37841 | 37841 | Guatemala | Guatemala | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 17843914 | 1478 | 0 | TBC | weekly | |
37842 | 37842 | Guatemala | Guatemala | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 17843914 | 1394 | 1 | TBC | weekly | |
37843 | 37843 | Guatemala | Guatemala | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 17843914 | 1329 | 0 | TBC | weekly | |
37844 | 37844 | Guatemala | Guatemala | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 17843914 | 1305 | 1 | TBC | weekly | |
37845 | 37845 | Guatemala | Guatemala | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 17843914 | 1259 | 3 | TBC | weekly | |
37846 | 37846 | Guatemala | Guatemala | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 17843914 | 1314 | 2 | TBC | weekly | |
37847 | 37847 | Guatemala | Guatemala | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 17843914 | 1405 | 8 | TBC | weekly | |
37848 | 37848 | Guatemala | Guatemala | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 17843914 | 1351 | 2 | TBC | weekly | |
37849 | 37849 | Guatemala | Guatemala | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 17843914 | 1375 | 9 | TBC | weekly | |
37850 | 37850 | Guatemala | Guatemala | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 17843914 | 1402 | 7 | TBC | weekly | |
37851 | 37851 | Guatemala | Guatemala | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 17843914 | 1470 | 25 | TBC | weekly | |
37852 | 37852 | Guatemala | Guatemala | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 17843914 | 1542 | 50 | TBC | weekly | |
37853 | 37853 | Guatemala | Guatemala | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 17843914 | 1890 | 144 | TBC | weekly | |
37854 | 37854 | Guatemala | Guatemala | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 17843914 | 1946 | 132 | TBC | weekly | |
37855 | 37855 | Guatemala | Guatemala | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 17843914 | 2113 | 147 | TBC | weekly | |
37856 | 37856 | Guatemala | Guatemala | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 17843914 | 2352 | 196 | TBC | weekly | |
37857 | 37857 | Guatemala | Guatemala | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 17843914 | 2626 | 220 | TBC | weekly | |
37858 | 37858 | Guatemala | Guatemala | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 17843914 | 2961 | 272 | TBC | weekly | |
37859 | 37859 | Guatemala | Guatemala | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 17843914 | 2785 | 266 | TBC | weekly | |
37860 | 37860 | Guatemala | Guatemala | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 17843914 | 2710 | 249 | TBC | weekly | |
37861 | 37861 | Guatemala | Guatemala | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 17843914 | 2576 | 261 | TBC | weekly | |
37862 | 37862 | Guatemala | Guatemala | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 17843914 | 2386 | 216 | TBC | weekly | |
37863 | 37863 | Guatemala | Guatemala | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 17843914 | 2225 | 168 | TBC | weekly | |
37864 | 37864 | Guatemala | Guatemala | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 17843914 | 2128 | 215 | TBC | weekly | |
37865 | 37865 | Guatemala | Guatemala | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 17843914 | 2127 | 146 | TBC | weekly | |
37866 | 37866 | Guatemala | Guatemala | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 17843914 | 2029 | 112 | TBC | weekly | |
37867 | 37867 | Guatemala | Guatemala | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 17843914 | 1957 | 105 | TBC | weekly | |
37868 | 37868 | Guatemala | Guatemala | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 17843914 | 1932 | 162 | TBC | weekly | |
37869 | 37869 | Guatemala | Guatemala | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 17843914 | 1907 | 110 | TBC | weekly | |
37870 | 37870 | Guatemala | Guatemala | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 17843914 | 1812 | 64 | TBC | weekly | |
37871 | 37871 | Guatemala | Guatemala | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 17843914 | 1926 | 91 | TBC | weekly | |
37872 | 37872 | Guatemala | Guatemala | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 17843914 | 1819 | 146 | TBC | weekly | |
37873 | 37873 | Guatemala | Guatemala | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 17843914 | 1787 | 114 | TBC | weekly | |
37874 | 37874 | Guatemala | Guatemala | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 17843914 | 1821 | 94 | TBC | weekly | |
37875 | 37875 | Guatemala | Guatemala | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 17843914 | 1866 | 83 | TBC | weekly | |
37876 | 37876 | Guatemala | Guatemala | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 17843914 | 1820 | 111 | TBC | weekly | |
37877 | 37877 | Guatemala | Guatemala | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 17843914 | 1876 | 144 | TBC | weekly | |
37878 | 37878 | Guatemala | Guatemala | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 17843914 | 1862 | 90 | TBC | weekly | |
37879 | 37879 | Guatemala | Guatemala | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 17843914 | 1765 | 84 | TBC | weekly | |
37880 | 37880 | Guatemala | Guatemala | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 17843914 | 1866 | 173 | TBC | weekly | |
37881 | 37881 | Guatemala | Guatemala | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 17843914 | 1851 | 233 | TBC | weekly | |
37882 | 37882 | Guatemala | Guatemala | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 17843914 | 1898 | 112 | TBC | weekly | |
37883 | 37883 | Guatemala | Guatemala | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 17843914 | 2049 | 65 | 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]);