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 excess_deaths_per_100k
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: year, 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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
13883 | 13883 | Guatemala | Guatemala | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 17843914 | 1259 | 3 | 1629.69353932583 | -370.693539325826 | 1256 | 0.0168124549356156 | -2.07742280827976 | -0.227462115042303 | 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 | |||||||||
13882 | 13882 | 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.209710467024058 | 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 | |||||||||
13884 | 13884 | 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.206662364610295 | 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 | |||||||||
13881 | 13881 | 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.201750761470217 | 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 | |||||||||
13885 | 13885 | 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.18118463191369 | 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 | |||||||||
13886 | 13886 | 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.18491386666309 | 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 | |||||||||
13887 | 13887 | 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.152852274570003 | 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 | |||||||||
13888 | 13888 | 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.148286554496654 | weekly | |||||||||
13880 | 13880 | Guatemala | Guatemala | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 17843914 | 1394 | 1 | 1636.09353932583 | -242.093539325826 | 1393 | 0.00560415164520519 | -1.35672890670638 | -0.147970475713502 | 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 | |||||||||
13879 | 13879 | Guatemala | Guatemala | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 17843914 | 1478 | 0 | 1624.69353932583 | -146.693539325827 | 1478 | 0.0 | -0.822092839753806 | -0.0902899751707641 | 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 | |||||||||
13889 | 13889 | Guatemala | Guatemala | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 17843914 | 1470 | 25 | 1611.69353932583 | -141.693539325827 | 1445 | 0.14010379113013 | -0.79407208152778 | -0.0879159318247936 | 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 | |||||||||
13990 | 13990 | Guatemala | Guatemala | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 17843914 | 1612 | 80 | 1747.55589887642 | -135.555898876419 | 1532 | 0.448332131616416 | -0.759675813705553 | -0.0775688485636281 | weekly | |||||||||
1936 | 1936 | Guatemala | Guatemala | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 17843914 | 1612 | 80 | 1747.55589887642 | -135.555898876419 | 1532 | 0.448332131616416 | -0.759675813705551 | -0.0775688485636274 | weekly | |||||||||
1942 | 1942 | Guatemala | Guatemala | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 17843914 | 1603 | 68 | 1710.15589887642 | -107.155898876419 | 1535 | 0.381082311873953 | -0.600517906981725 | -0.0626585558350681 | weekly | |||||||||
13996 | 13996 | Guatemala | Guatemala | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 17843914 | 1603 | 68 | 1710.15589887642 | -107.155898876419 | 1535 | 0.381082311873953 | -0.600517906981725 | -0.0626585558350685 | 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 | |||||||||
13876 | 13876 | 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.0553650028649562 | weekly | |||||||||
1939 | 1939 | Guatemala | Guatemala | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 17843914 | 1606 | 132 | 1677.75589887642 | -71.755898876419 | 1474 | 0.739748017167086 | -0.402130938741461 | -0.0427689742735957 | weekly | |||||||||
13993 | 13993 | Guatemala | Guatemala | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 17843914 | 1606 | 132 | 1677.75589887642 | -71.755898876419 | 1474 | 0.739748017167086 | -0.402130938741461 | -0.0427689742735963 | weekly | |||||||||
1943 | 1943 | Guatemala | Guatemala | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 17843914 | 1593 | 114 | 1654.75589887642 | -61.7558988764192 | 1479 | 0.638873287553392 | -0.34608942228941 | -0.037320247003411 | weekly | |||||||||
13997 | 13997 | Guatemala | Guatemala | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 17843914 | 1593 | 114 | 1654.75589887642 | -61.7558988764192 | 1479 | 0.638873287553392 | -0.34608942228941 | -0.0373202470034113 | 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 | |||||||||
13878 | 13878 | 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.0283287581271624 | 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 | |||||||||
13875 | 13875 | 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.0234458878352189 | weekly | |||||||||
1940 | 1940 | Guatemala | Guatemala | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 17843914 | 1606 | 163 | 1643.35589887642 | -37.3558988764191 | 1443 | 0.913476718168447 | -0.209348122146403 | -0.0227314721673861 | weekly | |||||||||
13994 | 13994 | Guatemala | Guatemala | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 17843914 | 1606 | 163 | 1643.35589887642 | -37.3558988764191 | 1443 | 0.913476718168447 | -0.209348122146403 | -0.0227314721673867 | 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 | |||||||||
13877 | 13877 | 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.0120532903214516 | weekly | |||||||||
13992 | 13992 | Guatemala | Guatemala | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 17843914 | 1645 | 123 | 1654.75589887642 | -9.755898876419 | 1522 | 0.689310652360239 | -0.0546735367387391 | -0.005895672517647 | weekly | |||||||||
1938 | 1938 | Guatemala | Guatemala | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 17843914 | 1645 | 123 | 1654.75589887642 | -9.755898876419 | 1522 | 0.689310652360239 | -0.054673536738739 | -0.00589567251764644 | 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 | |||||||||
13870 | 13870 | 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.00550522301288869 | 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 | |||||||||
13890 | 13890 | Guatemala | Guatemala | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 17843914 | 1542 | 50 | 1548.89353932583 | -6.89353932582685 | 1492 | 0.28020758226026 | -0.0386324397541192 | -0.0044506217831024 | weekly | |||||||||
1937 | 1937 | Guatemala | Guatemala | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 17843914 | 1688 | 99 | 1689.15589887642 | -1.15589887641886 | 1589 | 0.554811012875314 | -0.00647783258997359 | -0.000684305621042824 | weekly | |||||||||
13991 | 13991 | Guatemala | Guatemala | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 17843914 | 1688 | 99 | 1689.15589887642 | -1.15589887641886 | 1589 | 0.554811012875314 | -0.00647783258997359 | -0.000684305621043491 | 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 | |||||||||
13871 | 13871 | Guatemala | Guatemala | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 17843914 | 1663 | 0 | 1662.57794943818 | 0.422050561821152 | 1663 | 0.0 | 0.00236523535038979 | 0.000253853097211154 | 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 | |||||||||
13874 | 13874 | 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.000573030388081541 | 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 | |||||||||
13872 | 13872 | Guatemala | Guatemala | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 17843914 | 1607 | 0 | 1605.41128277151 | 1.58871722848767 | 1607 | 0.0 | 0.00890341226979501 | 0.000989601384728811 | weekly | |||||||||
1935 | 1935 | Guatemala | Guatemala | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 17843914 | 1696 | 90 | 1687.95589887642 | 8.04410112358096 | 1606 | 0.504373648068468 | 0.0450803625459132 | 0.00476558725789911 | weekly | |||||||||
13989 | 13989 | Guatemala | Guatemala | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 17843914 | 1696 | 90 | 1687.95589887642 | 8.04410112358096 | 1606 | 0.504373648068468 | 0.0450803625459132 | 0.00476558725789844 | weekly | |||||||||
13998 | 13998 | Guatemala | Guatemala | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 17843914 | 1726 | 96 | 1709.15589887642 | 16.8441011235811 | 1630 | 0.537998557939699 | 0.0943968970237197 | 0.00985521632909747 | weekly | |||||||||
1944 | 1944 | Guatemala | Guatemala | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 17843914 | 1726 | 96 | 1709.15589887642 | 16.8441011235811 | 1630 | 0.537998557939699 | 0.0943968970237199 | 0.00985521632909814 | weekly | |||||||||
1933 | 1933 | Guatemala | Guatemala | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 17843914 | 1716 | 50 | 1682.95589887642 | 33.044101123581 | 1666 | 0.28020758226026 | 0.185184153676043 | 0.0196345615150355 | weekly | |||||||||
13987 | 13987 | Guatemala | Guatemala | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 17843914 | 1716 | 50 | 1682.95589887642 | 33.044101123581 | 1666 | 0.28020758226026 | 0.185184153676043 | 0.0196345615150351 | weekly | |||||||||
1949 | 1949 | Guatemala | Guatemala | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 17843914 | 1742 | 103 | 1701.15589887642 | 40.8441011235809 | 1639 | 0.577227619456135 | 0.228896536508643 | 0.0240096167262258 | weekly | |||||||||
14003 | 14003 | Guatemala | Guatemala | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 17843914 | 1742 | 103 | 1701.15589887642 | 40.8441011235809 | 1639 | 0.577227619456135 | 0.228896536508643 | 0.0240096167262251 | 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 | |||||||||
13873 | 13873 | 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.0263742343244304 | weekly | |||||||||
1934 | 1934 | Guatemala | Guatemala | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 17843914 | 1707 | 53 | 1661.35589887642 | 45.6441011235811 | 1654 | 0.297020037195875 | 0.255796464405629 | 0.0274740055122749 | weekly | |||||||||
13988 | 13988 | Guatemala | Guatemala | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 17843914 | 1707 | 53 | 1661.35589887642 | 45.6441011235811 | 1654 | 0.297020037195875 | 0.255796464405629 | 0.0274740055122742 | 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 | |||||||||
13928 | 13928 | Guatemala | Guatemala | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 17843914 | 1706 | 158 | 1639.90912921348 | 66.0908707865217 | 1548 | 0.885455959942421 | 0.37038326225133 | 0.0403015445241275 | weekly | |||||||||
1948 | 1948 | Guatemala | Guatemala | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 17843914 | 1776 | 112 | 1693.35589887642 | 82.6441011235811 | 1664 | 0.627664984262982 | 0.463150075278221 | 0.0488049211500177 | weekly | |||||||||
14002 | 14002 | Guatemala | Guatemala | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 17843914 | 1776 | 112 | 1693.35589887642 | 82.6441011235811 | 1664 | 0.627664984262982 | 0.463150075278221 | 0.048804921150017 | weekly | |||||||||
1941 | 1941 | Guatemala | Guatemala | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 17843914 | 1667 | 102 | 1580.55589887642 | 86.4441011235806 | 1565 | 0.57162346781093 | 0.484445851529998 | 0.0546922137869541 | weekly | |||||||||
13995 | 13995 | Guatemala | Guatemala | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 17843914 | 1667 | 102 | 1580.55589887642 | 86.4441011235806 | 1565 | 0.57162346781093 | 0.484445851529998 | 0.0546922137869537 | weekly | |||||||||
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 | |||||||||
13869 | 13869 | 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.0519417234211175 | weekly | |||||||||
1945 | 1945 | Guatemala | Guatemala | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 17843914 | 1790 | 103 | 1697.35589887642 | 92.6441011235811 | 1687 | 0.577227619456135 | 0.519191591730273 | 0.0545814234863222 | weekly | |||||||||
13999 | 13999 | Guatemala | Guatemala | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 17843914 | 1790 | 103 | 1697.35589887642 | 92.6441011235811 | 1687 | 0.577227619456135 | 0.519191591730273 | 0.0545814234863216 | weekly | |||||||||
14000 | 14000 | Guatemala | Guatemala | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 17843914 | 1828 | 115 | 1713.35589887642 | 114.644101123581 | 1713 | 0.644477439198597 | 0.642482927924787 | 0.0669120182203597 | weekly | |||||||||
1946 | 1946 | Guatemala | Guatemala | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 17843914 | 1828 | 115 | 1713.35589887642 | 114.644101123581 | 1713 | 0.644477439198597 | 0.642482927924788 | 0.0669120182203604 | weekly | |||||||||
13968 | 13968 | Guatemala | Guatemala | 0 | 2021-11-22 | 2021-11-28 | 7 | 2021 | 47 | 17843914 | 1714 | 88 | 1597.52471910113 | 116.475280898874 | 1626 | 0.493165344778057 | 0.652745137075162 | 0.0729098457796675 | 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 | |||||||||
1932 | 1932 | Guatemala | Guatemala | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 17843914 | 1817 | 42 | 1696.55589887642 | 120.444101123581 | 1775 | 0.235374369098618 | 0.674987007466976 | 0.0709932995448883 | weekly | |||||||||
13986 | 13986 | Guatemala | Guatemala | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 17843914 | 1817 | 42 | 1696.55589887642 | 120.444101123581 | 1775 | 0.235374369098618 | 0.674987007466977 | 0.0709932995448876 | 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 | |||||||||
13931 | 13931 | Guatemala | Guatemala | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 17843914 | 1769 | 98 | 1642.92471910113 | 126.075280898874 | 1671 | 0.549206861230109 | 0.706544992869132 | 0.0767383188243997 | weekly | |||||||||
13929 | 13929 | Guatemala | Guatemala | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 17843914 | 1748 | 111 | 1621.74246254681 | 126.257537453188 | 1637 | 0.622060832617777 | 0.70756638623784 | 0.0778530132675401 | 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 | |||||||||
1931 | 1931 | Guatemala | Guatemala | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 17843914 | 1797 | 47 | 1667.75589887642 | 129.244101123582 | 1750 | 0.263395127324644 | 0.724303541944788 | 0.0774958141120381 | weekly | |||||||||
13985 | 13985 | Guatemala | Guatemala | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 17843914 | 1797 | 47 | 1667.75589887642 | 129.244101123582 | 1750 | 0.263395127324644 | 0.724303541944789 | 0.077495814112037 | 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 | |||||||||
13908 | 13908 | Guatemala | Guatemala | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 17843914 | 1812 | 64 | 1674.89353932583 | 137.106460674174 | 1748 | 0.358665705293132 | 0.768365397155434 | 0.0818598062831846 | weekly | |||||||||
13970 | 13970 | Guatemala | Guatemala | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 17843914 | 1732 | 58 | 1581.52471910113 | 150.475280898874 | 1674 | 0.325040795421901 | 0.843286293012139 | 0.0951457028027951 | weekly | |||||||||
1916 | 1916 | Guatemala | Guatemala | 0 | 2021-12-06 | 2021-12-12 | 7 | 2021 | 49 | 17843914 | 1732 | 58 | 1581.52471910113 | 150.475280898874 | 1674 | 0.325040795421901 | 0.84328629301214 | 0.095145702802798 | 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 | |||||||||
13932 | 13932 | 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.0959908004221681 | 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 | |||||||||
13927 | 13927 | Guatemala | Guatemala | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 17843914 | 1785 | 240 | 1624.90912921348 | 160.090870786522 | 1545 | 1.34499639484925 | 0.89717351690062 | 0.0985229683976299 | weekly | |||||||||
1917 | 1917 | Guatemala | Guatemala | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 17843914 | 1792 | 28 | 1626.12471910113 | 165.875280898874 | 1764 | 0.156916246065745 | 0.929590228348299 | 0.10200649369045 | weekly | |||||||||
13971 | 13971 | Guatemala | Guatemala | 0 | 2021-12-13 | 2021-12-19 | 7 | 2021 | 50 | 17843914 | 1792 | 28 | 1626.12471910113 | 165.875280898874 | 1764 | 0.156916246065745 | 0.929590228348299 | 0.102006493690447 | weekly | |||||||||
13911 | 13911 | Guatemala | Guatemala | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 17843914 | 1787 | 114 | 1604.49353932583 | 182.506460674173 | 1673 | 0.638873287553392 | 1.02279388184774 | 0.113747083550648 | 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 |
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);