economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where country = "Thailand" and days = 30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, year, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, month, total_deaths_per_7_days, covid_deaths_per_7_days, expected_deaths_per_7_days, non_covid_deaths_per_7_days, covid_deaths_per_100k_per_7_days, excess_deaths_per_100k_per_7_days, start_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10429 | 10429 | Thailand | Thailand | 0 | 2022-11-01 | 2022-11-30 | 30 | 2022 | 71697024 | 49543 | 225 | 42085.2963442628 | 7457.70365573719 | 49318 | 0.31382055690345 | 10.4016920642859 | 0.177204494290174 | monthly | 11 | 11560.0333333333 | 52.5 | 9819.90248032799 | 1740.13085300534 | 11507.5333333333 | 0.0732247966108049 | 2.42706148166672 | ||
23013 | 23013 | Thailand | Thailand | 0 | 2022-11-01 | 2022-11-30 | 30 | 2022 | 71697024 | 49543 | 225 | 42085.2963442628 | 7457.70365573719 | 49318 | 0.31382055690345 | 10.4016920642859 | 0.177204494290174 | monthly | 11 | 11560.0333333333 | 52.5 | 9819.90248032799 | 1740.13085300534 | 11507.5333333333 | 0.0732247966108049 | 2.42706148166672 | ||
10427 | 10427 | Thailand | Thailand | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 71697024 | 47755 | 443 | 41113.0963442628 | 6641.90365573719 | 47312 | 0.617877807592125 | 9.26384846285558 | 0.161552017394186 | monthly | 9 | 11142.8333333333 | 103.366666666667 | 9593.05581366132 | 1549.77751967201 | 11039.4666666667 | 0.144171488438163 | 2.16156464133297 | ||
23011 | 23011 | Thailand | Thailand | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 71697024 | 47755 | 443 | 41113.0963442628 | 6641.90365573719 | 47312 | 0.617877807592125 | 9.26384846285557 | 0.161552017394186 | monthly | 9 | 11142.8333333333 | 103.366666666667 | 9593.05581366132 | 1549.77751967201 | 11039.4666666667 | 0.144171488438163 | 2.16156464133297 | ||
10424 | 10424 | Thailand | Thailand | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 71697024 | 47056 | 629 | 39577.6963442628 | 7478.30365573719 | 46427 | 0.877302801298977 | 10.430424079718 | 0.188952474411039 | monthly | 6 | 10979.7333333333 | 146.766666666667 | 9234.79581366132 | 1744.93751967201 | 10832.9666666667 | 0.204703986969761 | 2.43376561860087 | ||
23008 | 23008 | Thailand | Thailand | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 71697024 | 47056 | 629 | 39577.6963442628 | 7478.30365573719 | 46427 | 0.877302801298977 | 10.430424079718 | 0.188952474411039 | monthly | 6 | 10979.7333333333 | 146.766666666667 | 9234.79581366132 | 1744.93751967201 | 10832.9666666667 | 0.204703986969761 | 2.43376561860087 | ||
10422 | 10422 | Thailand | Thailand | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 71697024 | 55398 | 3396 | 44336.0963442628 | 11061.9036557372 | 52002 | 4.73659827219607 | 15.42867895847 | 0.249501074019762 | monthly | 4 | 12926.2 | 792.4 | 10345.0891469947 | 2581.11085300535 | 12133.8 | 1.10520626351242 | 3.60002509030967 | ||
23006 | 23006 | Thailand | Thailand | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 71697024 | 55398 | 3396 | 44336.0963442628 | 11061.9036557372 | 52002 | 4.73659827219607 | 15.42867895847 | 0.249501074019762 | monthly | 4 | 12926.2 | 792.4 | 10345.0891469947 | 2581.11085300535 | 12133.8 | 1.10520626351242 | 3.60002509030967 | ||
10417 | 10417 | Thailand | Thailand | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 71697024 | 48892 | 1566 | 41573.1170754101 | 7318.8829245899 | 47326 | 2.18419107604801 | 10.2080707346931 | 0.176048452448587 | monthly | 11 | 11408.1333333333 | 365.4 | 9700.39398426236 | 1707.73934907098 | 11042.7333333333 | 0.509644584411202 | 2.38188317142839 | ||
23001 | 23001 | Thailand | Thailand | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 71697024 | 48892 | 1566 | 41573.1170754101 | 7318.8829245899 | 47326 | 2.18419107604801 | 10.2080707346931 | 0.176048452448588 | monthly | 11 | 11408.1333333333 | 365.4 | 9700.39398426236 | 1707.73934907098 | 11042.7333333333 | 0.509644584411202 | 2.38188317142839 | ||
10415 | 10415 | Thailand | Thailand | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 71697024 | 48129 | 5138 | 40600.9170754101 | 7528.0829245899 | 42991 | 7.16626676164411 | 10.4998541147118 | 0.185416573487924 | monthly | 9 | 11230.1 | 1198.86666666667 | 9473.54731759569 | 1756.55268240431 | 10031.2333333333 | 1.67212891105029 | 2.44996596009942 | ||
22999 | 22999 | Thailand | Thailand | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 71697024 | 48129 | 5138 | 40600.9170754101 | 7528.0829245899 | 42991 | 7.16626676164411 | 10.4998541147118 | 0.185416573487924 | monthly | 9 | 11230.1 | 1198.86666666667 | 9473.54731759569 | 1756.55268240431 | 10031.2333333333 | 1.67212891105029 | 2.44996596009942 | ||
10412 | 10412 | Thailand | Thailand | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 71697024 | 43522 | 992 | 39065.5170754101 | 4456.48292458989 | 42530 | 1.38359996643654 | 6.21571534766896 | 0.114077151877635 | monthly | 6 | 10155.1333333333 | 231.466666666667 | 9115.28731759569 | 1039.84601573764 | 9923.66666666667 | 0.322839992168527 | 1.45033358112276 | ||
22996 | 22996 | Thailand | Thailand | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 71697024 | 43522 | 992 | 39065.5170754101 | 4456.48292458989 | 42530 | 1.38359996643654 | 6.21571534766895 | 0.114077151877635 | monthly | 6 | 10155.1333333333 | 231.466666666667 | 9115.28731759569 | 1039.84601573764 | 9923.66666666667 | 0.322839992168527 | 1.45033358112276 | ||
10410 | 10410 | Thailand | Thailand | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 71697024 | 42435 | 109 | 43823.9170754101 | -1388.9170754101 | 42326 | 0.152028625344338 | -1.93720324487959 | -0.0316931294165266 | monthly | 4 | 9901.5 | 25.4333333333333 | 10225.580650929 | -324.080650929023 | 9876.06666666667 | 0.0354733459136788 | -0.452014090471905 | ||
22994 | 22994 | Thailand | Thailand | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 71697024 | 42435 | 109 | 43823.9170754101 | -1388.9170754101 | 42326 | 0.152028625344338 | -1.93720324487959 | -0.0316931294165266 | monthly | 4 | 9901.5 | 25.4333333333333 | 10225.580650929 | -324.080650929023 | 9876.06666666667 | 0.0354733459136788 | -0.452014090471905 | ||
10405 | 10405 | Thailand | Thailand | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 71697024 | 43545 | 1 | 41060.9378065576 | 2484.06219344238 | 43544 | 0.001394758030682 | 3.4646656930173 | 0.0604969668531454 | monthly | 11 | 10160.5 | 0.233333333333333 | 9580.88548819678 | 579.614511803223 | 10160.2666666667 | 0.000325443540492466 | 0.808421995037371 | ||
22989 | 22989 | Thailand | Thailand | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 71697024 | 43545 | 1 | 41060.9378065576 | 2484.06219344238 | 43544 | 0.001394758030682 | 3.4646656930173 | 0.0604969668531459 | monthly | 11 | 10160.5 | 0.233333333333333 | 9580.88548819678 | 579.614511803223 | 10160.2666666667 | 0.00032544354049246 | 0.808421995037371 | ||
10403 | 10403 | Thailand | Thailand | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 71697024 | 39361 | 1 | 40088.7378065576 | -727.737806557612 | 39360 | 0.001394758030682 | -1.01501814992713 | -0.0181531733443244 | monthly | 9 | 9184.23333333333 | 0.233333333333333 | 9354.03882153011 | -169.805488196776 | 9184.0 | 0.000325443540492466 | -0.236837568316331 | ||
22987 | 22987 | Thailand | Thailand | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 71697024 | 39361 | 1 | 40088.7378065576 | -727.737806557612 | 39360 | 0.001394758030682 | -1.01501814992713 | -0.0181531733443241 | monthly | 9 | 9184.23333333333 | 0.233333333333333 | 9354.03882153011 | -169.805488196776 | 9184.0 | 0.00032544354049246 | -0.236837568316331 | ||
10400 | 10400 | Thailand | Thailand | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 71697024 | 39479 | 1 | 38553.3378065576 | 925.662193442382 | 39478 | 0.001394758030682 | 1.29107477800248 | 0.0240099105837974 | monthly | 6 | 9211.76666666667 | 0.233333333333333 | 8995.77882153011 | 215.987845136556 | 9211.53333333333 | 0.000325443540492466 | 0.301250781533911 | ||
22984 | 22984 | Thailand | Thailand | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 71697024 | 39479 | 1 | 38553.3378065576 | 925.662193442382 | 39478 | 0.001394758030682 | 1.29107477800248 | 0.0240099105837976 | monthly | 6 | 9211.76666666667 | 0.233333333333333 | 8995.77882153011 | 215.987845136556 | 9211.53333333333 | 0.00032544354049246 | 0.301250781533911 | ||
10398 | 10398 | Thailand | Thailand | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 71697024 | 40057 | 44 | 43311.7378065576 | -3254.73780655761 | 40013 | 0.0613693533500079 | -4.53957169346054 | -0.0751467840217861 | monthly | 4 | 9346.63333333333 | 10.2666666666667 | 10106.0721548634 | -759.43882153011 | 9336.36666666667 | 0.0143195157816685 | -1.05923339514079 | ||
22982 | 22982 | Thailand | Thailand | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 71697024 | 40057 | 44 | 43311.7378065576 | -3254.73780655761 | 40013 | 0.0613693533500079 | -4.53957169346054 | -0.0751467840217858 | monthly | 4 | 9346.63333333333 | 10.2666666666667 | 10106.0721548634 | -759.43882153011 | 9336.36666666667 | 0.0143195157816685 | -1.05923339514079 |
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);