economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
270 rows where country = "Guatemala" sorted by region
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, week, covid_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, start_date (date)
end_date (date) 135 ✖
- 2020-01-05 2
- 2020-01-12 2
- 2020-01-19 2
- 2020-01-26 2
- 2020-02-02 2
- 2020-02-09 2
- 2020-02-16 2
- 2020-02-23 2
- 2020-03-01 2
- 2020-03-08 2
- 2020-03-15 2
- 2020-03-22 2
- 2020-03-29 2
- 2020-04-05 2
- 2020-04-12 2
- 2020-04-19 2
- 2020-04-26 2
- 2020-05-03 2
- 2020-05-10 2
- 2020-05-17 2
- 2020-05-24 2
- 2020-05-31 2
- 2020-06-07 2
- 2020-06-14 2
- 2020-06-21 2
- 2020-06-28 2
- 2020-07-05 2
- 2020-07-12 2
- 2020-07-19 2
- 2020-07-26 2
- 2020-08-02 2
- 2020-08-09 2
- 2020-08-16 2
- 2020-08-23 2
- 2020-08-30 2
- 2020-09-06 2
- 2020-09-13 2
- 2020-09-20 2
- 2020-09-27 2
- 2020-10-04 2
- 2020-10-11 2
- 2020-10-18 2
- 2020-10-25 2
- 2020-11-01 2
- 2020-11-08 2
- 2020-11-15 2
- 2020-11-22 2
- 2020-11-29 2
- 2020-12-06 2
- 2020-12-13 2
- 2020-12-20 2
- 2020-12-27 2
- 2021-01-03 2
- 2021-01-10 2
- 2021-01-17 2
- 2021-01-24 2
- 2021-01-31 2
- 2021-02-07 2
- 2021-02-14 2
- 2021-02-21 2
- 2021-02-28 2
- 2021-03-07 2
- 2021-03-14 2
- 2021-03-21 2
- 2021-03-28 2
- 2021-04-04 2
- 2021-04-11 2
- 2021-04-18 2
- 2021-04-25 2
- 2021-05-02 2
- 2021-05-09 2
- 2021-05-16 2
- 2021-05-23 2
- 2021-05-30 2
- 2021-06-06 2
- 2021-06-13 2
- 2021-06-20 2
- 2021-06-27 2
- 2021-07-04 2
- 2021-07-11 2
- 2021-07-18 2
- 2021-07-25 2
- 2021-08-01 2
- 2021-08-08 2
- 2021-08-15 2
- 2021-08-22 2
- 2021-08-29 2
- 2021-09-05 2
- 2021-09-12 2
- 2021-09-19 2
- 2021-09-26 2
- 2021-10-03 2
- 2021-10-10 2
- 2021-10-17 2
- 2021-10-24 2
- 2021-10-31 2
- 2021-11-07 2
- 2021-11-14 2
- 2021-11-21 2
- 2021-11-28 2
- 2021-12-05 2
- 2021-12-12 2
- 2021-12-19 2
- 2021-12-26 2
- 2022-01-02 2
- 2022-01-09 2
- 2022-01-16 2
- 2022-01-23 2
- 2022-01-30 2
- 2022-02-06 2
- 2022-02-13 2
- 2022-02-20 2
- 2022-02-27 2
- 2022-03-06 2
- 2022-03-13 2
- 2022-03-20 2
- 2022-03-27 2
- 2022-04-03 2
- 2022-04-10 2
- 2022-04-17 2
- 2022-04-24 2
- 2022-05-01 2
- 2022-05-08 2
- 2022-05-15 2
- 2022-05-22 2
- 2022-05-29 2
- 2022-06-05 2
- 2022-06-12 2
- 2022-06-19 2
- 2022-06-26 2
- 2022-07-03 2
- 2022-07-10 2
- 2022-07-17 2
- 2022-07-24 2
- 2022-07-31 2
country 1
- Guatemala · 270 ✖
cadence 1
- weekly 270
Link | rowid | country | region ▼ | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | excess_deaths | non_covid_deaths | covid_deaths_per_100k | excess_deaths_per_100k | excess_deaths_pct_change | cadence | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1815 | 1815 | Guatemala | Guatemala | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 17843914 | 1757 | 0 | 1670.24461610468 | 86.7553838953154 | 1757 | 0.0 | 0.48619032738734 | 0.0519417234211146 | weekly | |||||||||
1816 | 1816 | Guatemala | Guatemala | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 17843914 | 1670 | 0 | 1679.24461610485 | -9.24461610484559 | 1670 | 0.0 | -0.0518082305532609 | -0.00550522301288614 | weekly | |||||||||
1817 | 1817 | Guatemala | Guatemala | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 17843914 | 1663 | 0 | 1662.57794943818 | 0.422050561821152 | 1663 | 0.0 | 0.00236523535038978 | 0.000253853097212042 | weekly | |||||||||
1818 | 1818 | Guatemala | Guatemala | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 17843914 | 1607 | 0 | 1605.41128277151 | 1.58871722848767 | 1607 | 0.0 | 0.00890341226979499 | 0.000989601384727479 | weekly | |||||||||
1819 | 1819 | Guatemala | Guatemala | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 17843914 | 1599 | 0 | 1557.91128277151 | 41.0887172284874 | 1599 | 0.0 | 0.230267402255399 | 0.0263742343244289 | weekly | |||||||||
1820 | 1820 | Guatemala | Guatemala | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 17843914 | 1610 | 0 | 1609.07794943818 | 0.922050561821152 | 1610 | 0.0 | 0.00516731117299238 | 0.000573030388082207 | weekly | |||||||||
1821 | 1821 | Guatemala | Guatemala | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 17843914 | 1586 | 0 | 1624.07794943818 | -38.0779494381788 | 1586 | 0.0 | -0.21339460299001 | -0.0234458878352183 | weekly | |||||||||
1822 | 1822 | Guatemala | Guatemala | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 17843914 | 1517 | 0 | 1605.91128277151 | -88.9112827715123 | 1517 | 0.0 | -0.498272311621275 | -0.0553650028649575 | weekly | |||||||||
1823 | 1823 | Guatemala | Guatemala | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 17843914 | 1565 | 0 | 1584.09353932583 | -19.0935393258262 | 1565 | 0.0 | -0.107003089825619 | -0.0120532903214492 | weekly | |||||||||
1824 | 1824 | Guatemala | Guatemala | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 17843914 | 1581 | 0 | 1627.09353932583 | -46.0935393258267 | 1581 | 0.0 | -0.258315184246162 | -0.0283287581271604 | weekly | |||||||||
1825 | 1825 | Guatemala | Guatemala | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 17843914 | 1478 | 0 | 1624.69353932583 | -146.693539325827 | 1478 | 0.0 | -0.822092839753804 | -0.0902899751707622 | weekly | |||||||||
1826 | 1826 | Guatemala | Guatemala | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 17843914 | 1394 | 1 | 1636.09353932583 | -242.093539325826 | 1393 | 0.00560415164520519 | -1.35672890670637 | -0.1479704757135 | weekly | |||||||||
1827 | 1827 | Guatemala | Guatemala | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 17843914 | 1329 | 0 | 1664.89353932583 | -335.893539325827 | 1329 | 0.0 | -1.88239833102663 | -0.201750761470215 | weekly | |||||||||
1828 | 1828 | Guatemala | Guatemala | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 17843914 | 1305 | 1 | 1651.29353932583 | -346.293539325826 | 1304 | 0.00560415164520519 | -1.94068150813676 | -0.209710467024057 | weekly | |||||||||
1829 | 1829 | Guatemala | Guatemala | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 17843914 | 1259 | 3 | 1629.69353932583 | -370.693539325826 | 1256 | 0.0168124549356156 | -2.07742280827977 | -0.227462115042301 | weekly | |||||||||
1830 | 1830 | Guatemala | Guatemala | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 17843914 | 1314 | 2 | 1656.29353932583 | -342.293539325826 | 1312 | 0.0112083032904104 | -1.91826490155594 | -0.206662364610293 | weekly | |||||||||
1831 | 1831 | Guatemala | Guatemala | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 17843914 | 1405 | 8 | 1715.89353932583 | -310.893539325826 | 1397 | 0.0448332131616416 | -1.74229453989649 | -0.181184631913689 | weekly | |||||||||
1832 | 1832 | Guatemala | Guatemala | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 17843914 | 1351 | 2 | 1657.49353932583 | -306.493539325826 | 1349 | 0.0112083032904104 | -1.71763627265759 | -0.184913866663088 | weekly | |||||||||
1833 | 1833 | Guatemala | Guatemala | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 17843914 | 1375 | 9 | 1623.09353932583 | -248.093539325826 | 1366 | 0.0504373648068467 | -1.39035381657761 | -0.152852274570001 | weekly | |||||||||
1834 | 1834 | Guatemala | Guatemala | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 17843914 | 1402 | 7 | 1646.09353932583 | -244.093539325826 | 1395 | 0.0392290615164364 | -1.36793720999679 | -0.148286554496652 | weekly | |||||||||
1835 | 1835 | Guatemala | Guatemala | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 17843914 | 1470 | 25 | 1611.69353932583 | -141.693539325827 | 1445 | 0.14010379113013 | -0.794072081527778 | -0.0879159318247916 | weekly | |||||||||
1836 | 1836 | Guatemala | Guatemala | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 17843914 | 1542 | 50 | 1548.89353932583 | -6.89353932582685 | 1492 | 0.28020758226026 | -0.0386324397541193 | -0.00445062178310029 | weekly | |||||||||
1837 | 1837 | Guatemala | Guatemala | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 17843914 | 1890 | 144 | 1678.49353932583 | 211.506460674173 | 1746 | 0.806997836909548 | 1.1853142795587 | 0.126009696027264 | weekly | |||||||||
1838 | 1838 | Guatemala | Guatemala | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 17843914 | 1946 | 132 | 1623.09353932583 | 322.906460674173 | 1814 | 0.739748017167086 | 1.80961677283455 | 0.198945071772202 | weekly | |||||||||
1839 | 1839 | Guatemala | Guatemala | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 17843914 | 2113 | 147 | 1677.49353932583 | 435.506460674174 | 1966 | 0.823810291845164 | 2.44064424808466 | 0.259617369882212 | weekly | |||||||||
1840 | 1840 | Guatemala | Guatemala | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 17843914 | 2352 | 196 | 1665.69353932583 | 686.306460674174 | 2156 | 1.09841372246022 | 3.84616548070212 | 0.412024447757629 | weekly | |||||||||
1841 | 1841 | Guatemala | Guatemala | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 17843914 | 2626 | 220 | 1681.69353932583 | 944.306460674174 | 2406 | 1.23291336194514 | 5.29203660516506 | 0.561521132472648 | weekly | |||||||||
1842 | 1842 | Guatemala | Guatemala | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 17843914 | 2961 | 272 | 1659.09353932583 | 1301.90646067417 | 2689 | 1.52432924749581 | 7.29608123349044 | 0.784709499383141 | weekly | |||||||||
1843 | 1843 | Guatemala | Guatemala | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 17843914 | 2785 | 266 | 1661.69353932583 | 1123.30646067417 | 2519 | 1.49070433762458 | 6.29517974965679 | 0.676000979777484 | weekly | |||||||||
1844 | 1844 | Guatemala | Guatemala | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 17843914 | 2710 | 249 | 1669.49353932583 | 1040.50646067417 | 2461 | 1.39543375965609 | 5.8311559934338 | 0.623246772847261 | weekly | |||||||||
1845 | 1845 | Guatemala | Guatemala | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 17843914 | 2576 | 261 | 1600.09353932583 | 975.906460674173 | 2315 | 1.46268357939856 | 5.46912779715355 | 0.609905881555747 | weekly | |||||||||
1846 | 1846 | Guatemala | Guatemala | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 17843914 | 2386 | 216 | 1653.89353932583 | 732.106460674174 | 2170 | 1.21049675536432 | 4.10283562605252 | 0.442656339883038 | weekly | |||||||||
1847 | 1847 | Guatemala | Guatemala | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 17843914 | 2225 | 168 | 1584.89353932583 | 640.106460674173 | 2057 | 0.941497476394473 | 3.58725367469364 | 0.403879784219739 | weekly | |||||||||
1848 | 1848 | Guatemala | Guatemala | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 17843914 | 2128 | 215 | 1624.69353932583 | 503.306460674174 | 1913 | 1.20489260371912 | 2.82060572962958 | 0.309785475532218 | weekly | |||||||||
1849 | 1849 | Guatemala | Guatemala | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 17843914 | 2127 | 146 | 1566.69353932583 | 560.306460674173 | 1981 | 0.818206140199958 | 3.14004237340627 | 0.3576362872571 | weekly | |||||||||
1850 | 1850 | Guatemala | Guatemala | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 17843914 | 2029 | 112 | 1612.09353932583 | 416.906460674174 | 1917 | 0.627664984262982 | 2.33640702748384 | 0.258611830209631 | weekly | |||||||||
1851 | 1851 | Guatemala | Guatemala | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 17843914 | 1957 | 105 | 1615.69353932583 | 341.306460674173 | 1852 | 0.588435922746545 | 1.91273316310633 | 0.21124455372681 | weekly | |||||||||
1852 | 1852 | Guatemala | Guatemala | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 17843914 | 1932 | 162 | 1628.09353932583 | 303.906460674174 | 1770 | 0.907872566523241 | 1.70313789157566 | 0.186664005066943 | weekly | |||||||||
1853 | 1853 | Guatemala | Guatemala | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 17843914 | 1907 | 110 | 1610.29353932583 | 296.706460674174 | 1797 | 0.616456680972571 | 1.66278799973018 | 0.184256133076454 | weekly | |||||||||
1854 | 1854 | Guatemala | Guatemala | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 17843914 | 1812 | 64 | 1674.89353932583 | 137.106460674174 | 1748 | 0.358665705293132 | 0.768365397155431 | 0.081859806283187 | weekly | |||||||||
1855 | 1855 | Guatemala | Guatemala | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 17843914 | 1926 | 91 | 1642.29353932583 | 283.706460674174 | 1835 | 0.509977799713673 | 1.58993402834251 | 0.172750153295152 | weekly | |||||||||
1856 | 1856 | Guatemala | Guatemala | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 17843914 | 1819 | 146 | 1617.29353932583 | 201.706460674174 | 1673 | 0.818206140199958 | 1.13039359343569 | 0.124718522500409 | weekly | |||||||||
1857 | 1857 | Guatemala | Guatemala | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 17843914 | 1787 | 114 | 1604.49353932583 | 182.506460674173 | 1673 | 0.638873287553392 | 1.02279388184775 | 0.11374708355065 | weekly | |||||||||
1858 | 1858 | Guatemala | Guatemala | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 17843914 | 1821 | 94 | 1592.69353932583 | 228.306460674174 | 1727 | 0.526790254649288 | 1.27946402719815 | 0.143346133475756 | weekly | |||||||||
1859 | 1859 | Guatemala | Guatemala | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 17843914 | 1866 | 83 | 1600.29353932583 | 265.706460674173 | 1783 | 0.465144586552031 | 1.48905929872882 | 0.166036076597616 | weekly | |||||||||
1860 | 1860 | Guatemala | Guatemala | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 17843914 | 1820 | 111 | 1579.49353932583 | 240.506460674174 | 1709 | 0.622060832617777 | 1.34783467726965 | 0.15226808764082 | weekly | |||||||||
1861 | 1861 | Guatemala | Guatemala | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 17843914 | 1876 | 144 | 1581.69353932583 | 294.306460674174 | 1732 | 0.806997836909548 | 1.64933803578169 | 0.186070470262917 | weekly | |||||||||
1862 | 1862 | Guatemala | Guatemala | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 17843914 | 1862 | 90 | 1555.09353932583 | 306.906460674174 | 1772 | 0.504373648068468 | 1.71995034651127 | 0.19735562711374 | weekly | |||||||||
1863 | 1863 | Guatemala | Guatemala | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 17843914 | 1765 | 84 | 1565.69353932583 | 199.306460674174 | 1681 | 0.470748738197236 | 1.11694362948719 | 0.127295959054665 | weekly | |||||||||
1864 | 1864 | Guatemala | Guatemala | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 17843914 | 1866 | 173 | 1610.29353932583 | 255.706460674174 | 1693 | 0.969518234620499 | 1.43301778227677 | 0.158794936717705 | weekly | |||||||||
1865 | 1865 | Guatemala | Guatemala | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 17843914 | 1851 | 233 | 1603.89353932583 | 247.106460674174 | 1618 | 1.30576733333281 | 1.384822078128 | 0.154066622637586 | weekly | |||||||||
1866 | 1866 | Guatemala | Guatemala | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 17843914 | 1898 | 112 | 1694.89353932583 | 203.106460674174 | 1786 | 0.627664984262982 | 1.13823940573897 | 0.119834347091182 | weekly | |||||||||
1867 | 1867 | Guatemala | Guatemala | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 17843914 | 2049 | 65 | 1693.10393258426 | 355.896067415742 | 1984 | 0.364269856938338 | 1.99449553172999 | 0.210203319811869 | weekly | |||||||||
1868 | 1868 | Guatemala | Guatemala | 0 | 2021-01-04 | 2021-01-10 | 7 | 2021 | 1 | 17843914 | 1904 | 192 | 1686.07579587998 | 217.924204120016 | 1712 | 1.0759971158794 | 1.22128028704922 | 0.129249352047236 | weekly | |||||||||
1869 | 1869 | Guatemala | Guatemala | 0 | 2021-01-11 | 2021-01-17 | 7 | 2021 | 2 | 17843914 | 1930 | 229 | 1695.07579588015 | 234.924204119855 | 1701 | 1.28335072675199 | 1.31655086501681 | 0.138592153041672 | weekly | |||||||||
1870 | 1870 | Guatemala | Guatemala | 0 | 2021-01-18 | 2021-01-24 | 7 | 2021 | 3 | 17843914 | 1898 | 211 | 1678.40912921348 | 219.590870786522 | 1687 | 1.1824759971383 | 1.23062053979033 | 0.130832743318922 | weekly | |||||||||
1871 | 1871 | Guatemala | Guatemala | 0 | 2021-01-25 | 2021-01-31 | 7 | 2021 | 4 | 17843914 | 1837 | 178 | 1621.24246254681 | 215.757537453188 | 1659 | 0.997538992846525 | 1.20913795848371 | 0.133081597871705 | weekly | |||||||||
1872 | 1872 | Guatemala | Guatemala | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 17843914 | 1776 | 241 | 1573.74246254681 | 202.257537453188 | 1535 | 1.35060054649445 | 1.13348191127343 | 0.128520099232673 | weekly | |||||||||
1873 | 1873 | Guatemala | Guatemala | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 17843914 | 1785 | 240 | 1624.90912921348 | 160.090870786522 | 1545 | 1.34499639484925 | 0.897173516900618 | 0.098522968397631 | weekly | |||||||||
1874 | 1874 | Guatemala | Guatemala | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 17843914 | 1706 | 158 | 1639.90912921348 | 66.0908707865217 | 1548 | 0.885455959942421 | 0.370383262251329 | 0.0403015445241284 | weekly | |||||||||
1875 | 1875 | Guatemala | Guatemala | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 17843914 | 1748 | 111 | 1621.74246254681 | 126.257537453188 | 1637 | 0.622060832617777 | 0.707566386237841 | 0.077853013267539 | weekly | |||||||||
1876 | 1876 | Guatemala | Guatemala | 0 | 2021-03-01 | 2021-03-07 | 7 | 2021 | 9 | 17843914 | 1811 | 80 | 1599.92471910113 | 211.075280898874 | 1731 | 0.448332131616416 | 1.18289788271158 | 0.131928257860446 | weekly | |||||||||
1877 | 1877 | Guatemala | Guatemala | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 17843914 | 1769 | 98 | 1642.92471910113 | 126.075280898874 | 1671 | 0.549206861230109 | 0.706544992869131 | 0.0767383188244024 | weekly | |||||||||
1878 | 1878 | Guatemala | Guatemala | 0 | 2021-03-15 | 2021-03-21 | 7 | 2021 | 11 | 17843914 | 1798 | 132 | 1640.52471910113 | 157.475280898874 | 1666 | 0.739748017167086 | 0.882515354528575 | 0.0959908004221708 | weekly | |||||||||
1879 | 1879 | Guatemala | Guatemala | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 17843914 | 1970 | 102 | 1651.92471910112 | 318.075280898875 | 1868 | 0.57162346781093 | 1.78254210874853 | 0.192548290621834 | weekly | |||||||||
1880 | 1880 | Guatemala | Guatemala | 0 | 2021-03-29 | 2021-04-04 | 7 | 2021 | 13 | 17843914 | 1965 | 89 | 1680.72471910113 | 284.275280898874 | 1876 | 0.498769496423262 | 1.59312178314059 | 0.1691385136829 | weekly | |||||||||
1881 | 1881 | Guatemala | Guatemala | 0 | 2021-04-05 | 2021-04-11 | 7 | 2021 | 14 | 17843914 | 2064 | 125 | 1667.12471910113 | 396.875280898874 | 1939 | 0.700518955650649 | 2.2241492583907 | 0.238059742232638 | weekly | |||||||||
1882 | 1882 | Guatemala | Guatemala | 0 | 2021-04-12 | 2021-04-18 | 7 | 2021 | 15 | 17843914 | 2221 | 205 | 1645.52471910113 | 575.475280898874 | 2016 | 1.14885108726706 | 3.22505074222435 | 0.349721443998258 | weekly | |||||||||
1883 | 1883 | Guatemala | Guatemala | 0 | 2021-04-19 | 2021-04-25 | 7 | 2021 | 16 | 17843914 | 2191 | 189 | 1672.12471910113 | 518.875280898874 | 2002 | 1.05918466094378 | 2.90785575910573 | 0.310308958997869 | weekly | |||||||||
1884 | 1884 | Guatemala | Guatemala | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 17843914 | 2184 | 148 | 1731.72471910113 | 452.275280898874 | 2036 | 0.829414443490369 | 2.53461925953507 | 0.2611704250163 | weekly | |||||||||
1885 | 1885 | Guatemala | Guatemala | 0 | 2021-05-03 | 2021-05-09 | 7 | 2021 | 18 | 17843914 | 2133 | 175 | 1673.32471910113 | 459.675280898874 | 1958 | 0.980726537910909 | 2.57608998170959 | 0.27470775734778 | weekly | |||||||||
1886 | 1886 | Guatemala | Guatemala | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 17843914 | 2092 | 154 | 1638.92471910113 | 453.075280898874 | 1938 | 0.8630393533616 | 2.53910258085123 | 0.276446669952824 | weekly | |||||||||
1887 | 1887 | Guatemala | Guatemala | 0 | 2021-05-17 | 2021-05-23 | 7 | 2021 | 20 | 17843914 | 2135 | 113 | 1661.92471910113 | 473.075280898874 | 2022 | 0.633269135908187 | 2.65118561375533 | 0.284655060161054 | weekly | |||||||||
1888 | 1888 | Guatemala | Guatemala | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 17843914 | 2079 | 137 | 1627.52471910113 | 451.475280898874 | 1942 | 0.767768775393112 | 2.5301359382189 | 0.277399953192859 | weekly | |||||||||
1889 | 1889 | Guatemala | Guatemala | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 17843914 | 2157 | 157 | 1564.72471910113 | 592.275280898874 | 2000 | 0.879851808297216 | 3.31920048986379 | 0.378517239274595 | weekly | |||||||||
1890 | 1890 | Guatemala | Guatemala | 0 | 2021-06-07 | 2021-06-13 | 7 | 2021 | 23 | 17843914 | 2209 | 161 | 1694.32471910113 | 514.675280898874 | 2048 | 0.902268414878036 | 2.88431832219587 | 0.303764251974037 | weekly | |||||||||
1891 | 1891 | Guatemala | Guatemala | 0 | 2021-06-14 | 2021-06-20 | 7 | 2021 | 24 | 17843914 | 2156 | 239 | 1638.92471910113 | 517.075280898874 | 1917 | 1.33939224320404 | 2.89776828614436 | 0.31549666367987 | weekly | |||||||||
1892 | 1892 | Guatemala | Guatemala | 0 | 2021-06-21 | 2021-06-27 | 7 | 2021 | 25 | 17843914 | 2188 | 356 | 1693.32471910113 | 494.675280898874 | 1832 | 1.99507798569305 | 2.77223528929177 | 0.292132557517654 | weekly | |||||||||
1893 | 1893 | Guatemala | Guatemala | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 17843914 | 2360 | 411 | 1681.52471910113 | 678.475280898874 | 1949 | 2.30330632617933 | 3.80227836168048 | 0.403488139776833 | weekly | |||||||||
1894 | 1894 | Guatemala | Guatemala | 0 | 2021-07-05 | 2021-07-11 | 7 | 2021 | 27 | 17843914 | 2467 | 252 | 1697.52471910113 | 769.475280898874 | 2215 | 1.41224621459171 | 4.31225616139415 | 0.453292533675932 | weekly | |||||||||
1895 | 1895 | Guatemala | Guatemala | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 17843914 | 2537 | 201 | 1674.92471910113 | 862.075280898874 | 2336 | 1.12643448068624 | 4.83120060374015 | 0.514694941848801 | weekly | |||||||||
1896 | 1896 | Guatemala | Guatemala | 0 | 2021-07-19 | 2021-07-25 | 7 | 2021 | 29 | 17843914 | 2675 | 186 | 1677.52471910113 | 997.475280898874 | 2489 | 1.04237220600817 | 5.59000273650094 | 0.594611375642414 | weekly | |||||||||
1897 | 1897 | Guatemala | Guatemala | 0 | 2021-07-26 | 2021-08-01 | 7 | 2021 | 30 | 17843914 | 2732 | 313 | 1685.32471910113 | 1046.67528089887 | 2419 | 1.75409946494923 | 5.86572699744503 | 0.62105258947197 | weekly | |||||||||
1898 | 1898 | Guatemala | Guatemala | 0 | 2021-08-02 | 2021-08-08 | 7 | 2021 | 31 | 17843914 | 2823 | 358 | 1615.92471910113 | 1207.07528089887 | 2465 | 2.00628628898346 | 6.76463292133595 | 0.746987323500021 | weekly | |||||||||
1899 | 1899 | Guatemala | Guatemala | 0 | 2021-08-09 | 2021-08-15 | 7 | 2021 | 32 | 17843914 | 2981 | 384 | 1669.72471910113 | 1311.27528089887 | 2597 | 2.15199423175879 | 7.34858552276633 | 0.785324230933577 | weekly | |||||||||
1900 | 1900 | Guatemala | Guatemala | 0 | 2021-08-16 | 2021-08-22 | 7 | 2021 | 33 | 17843914 | 3329 | 345 | 1600.72471910113 | 1728.27528089887 | 2984 | 1.93343231759579 | 9.68551675881689 | 1.07968300874954 | weekly | |||||||||
1901 | 1901 | Guatemala | Guatemala | 0 | 2021-08-23 | 2021-08-29 | 7 | 2021 | 34 | 17843914 | 3556 | 358 | 1640.52471910113 | 1915.47528089887 | 3198 | 2.00628628898346 | 10.7346139467993 | 1.16759915812082 | weekly | |||||||||
1902 | 1902 | Guatemala | Guatemala | 0 | 2021-08-30 | 2021-09-05 | 7 | 2021 | 35 | 17843914 | 3686 | 407 | 1582.52471910113 | 2103.47528089887 | 3279 | 2.28088971959851 | 11.7881944560979 | 1.32918952576845 | weekly | |||||||||
1903 | 1903 | Guatemala | Guatemala | 0 | 2021-09-06 | 2021-09-12 | 7 | 2021 | 36 | 17843914 | 3855 | 445 | 1627.92471910113 | 2227.07528089887 | 3410 | 2.49384748211631 | 12.4808675994452 | 1.3680456195349 | weekly | |||||||||
1904 | 1904 | Guatemala | Guatemala | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 17843914 | 3697 | 330 | 1631.52471910113 | 2065.47528089887 | 3367 | 1.84937004291771 | 11.5752366935801 | 1.26597853940995 | weekly | |||||||||
1905 | 1905 | Guatemala | Guatemala | 0 | 2021-09-20 | 2021-09-26 | 7 | 2021 | 38 | 17843914 | 3206 | 335 | 1643.92471910113 | 1562.07528089887 | 2871 | 1.87739080114374 | 8.75410675538379 | 0.950210957198207 | weekly | |||||||||
1906 | 1906 | Guatemala | Guatemala | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 17843914 | 2956 | 355 | 1626.12471910113 | 1329.87528089887 | 2601 | 1.98947383404784 | 7.45282274336715 | 0.81781874740456 | weekly | |||||||||
1907 | 1907 | Guatemala | Guatemala | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 17843914 | 2649 | 297 | 1690.72471910113 | 958.275280898874 | 2352 | 1.66443303862594 | 5.37031999200889 | 0.566783740766706 | weekly | |||||||||
1908 | 1908 | Guatemala | Guatemala | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 17843914 | 2412 | 303 | 1658.12471910113 | 753.875280898874 | 2109 | 1.69805794849717 | 4.22483139572895 | 0.454655353855138 | weekly | |||||||||
1909 | 1909 | Guatemala | Guatemala | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 17843914 | 2108 | 370 | 1633.12471910113 | 474.875280898874 | 1738 | 2.07353610872592 | 2.6612730867167 | 0.290777106821484 | weekly | |||||||||
1910 | 1910 | Guatemala | Guatemala | 0 | 2021-10-25 | 2021-10-31 | 7 | 2021 | 43 | 17843914 | 1984 | 394 | 1620.32471910113 | 363.675280898874 | 1590 | 2.20803574821085 | 2.03809142376989 | 0.224445925320835 | weekly | |||||||||
1911 | 1911 | Guatemala | Guatemala | 0 | 2021-11-01 | 2021-11-07 | 7 | 2021 | 44 | 17843914 | 1933 | 343 | 1608.52471910113 | 324.475280898874 | 1590 | 1.92222401430538 | 1.81840867927784 | 0.201722284429795 | weekly | |||||||||
1912 | 1912 | Guatemala | Guatemala | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 17843914 | 1807 | 277 | 1616.12471910113 | 190.875280898874 | 1530 | 1.55235000572184 | 1.06969401947843 | 0.118106776440519 | weekly | |||||||||
1913 | 1913 | Guatemala | Guatemala | 0 | 2021-11-15 | 2021-11-21 | 7 | 2021 | 46 | 17843914 | 1783 | 126 | 1595.32471910113 | 187.675280898874 | 1657 | 0.706123107295854 | 1.05176073421377 | 0.117640802936106 | weekly | |||||||||
1914 | 1914 | Guatemala | Guatemala | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 17843914 | 1714 | 88 | 1597.52471910113 | 116.475280898874 | 1626 | 0.493165344778057 | 0.652745137075163 | 0.0729098457796702 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_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] FLOAT, [excess_deaths] FLOAT, [non_covid_deaths] INTEGER, [covid_deaths_per_100k] FLOAT, [excess_deaths_per_100k] FLOAT, [excess_deaths_pct_change] FLOAT, [cadence] TEXT , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);