economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where country = "Bosnia and Herzegovina" and days = 30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, total_deaths, 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, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21666 | 21666 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 3233530 | 3075 | 87 | 2565.03356727939 | 509.966432720607 | 2988 | 2.69055799698781 | 15.7711984339285 | 0.19881472087771 | monthly | 9 | 717.5 | 20.3 | 598.507832365192 | 118.992167634808 | 697.2 | 0.627796865963823 | 3.67994630124997 | ||
24559 | 24559 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 3233530 | 3075 | 87 | 2565.03356727939 | 509.966432720607 | 2988 | 2.69055799698781 | 15.7711984339285 | 0.198814720877709 | monthly | 9 | 717.5 | 20.3 | 598.507832365192 | 118.992167634808 | 697.2 | 0.627796865963823 | 3.67994630124997 | ||
21663 | 21663 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3233530 | 2705 | 18 | 2660.03356727939 | 44.9664327206065 | 2687 | 0.556667171790582 | 1.39062982933842 | 0.0169044606330291 | monthly | 6 | 631.166666666667 | 4.2 | 620.674499031858 | 10.4921676348082 | 626.966666666667 | 0.129889006751136 | 0.324480293512297 | ||
24556 | 24556 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 3233530 | 2705 | 18 | 2660.03356727939 | 44.9664327206065 | 2687 | 0.556667171790582 | 1.39062982933842 | 0.0169044606330275 | monthly | 6 | 631.166666666667 | 4.2 | 620.674499031858 | 10.4921676348082 | 626.966666666667 | 0.129889006751136 | 0.324480293512297 | ||
21661 | 21661 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 3233530 | 2970 | 52 | 2906.43356727939 | 63.5664327206068 | 2918 | 1.60814960739501 | 1.96585257352203 | 0.0218709395033971 | monthly | 4 | 693.0 | 12.1333333333333 | 678.167832365192 | 14.8321676348083 | 680.866666666667 | 0.37523490839217 | 0.458698933821806 | ||
24554 | 24554 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 3233530 | 2970 | 52 | 2906.43356727939 | 63.5664327206068 | 2918 | 1.60814960739501 | 1.96585257352203 | 0.021870939503396 | monthly | 4 | 693.0 | 12.1333333333333 | 678.167832365192 | 14.8321676348083 | 680.866666666667 | 0.37523490839217 | 0.458698933821806 | ||
21656 | 21656 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 3233530 | 4615 | 1091 | 2863.86685382351 | 1751.13314617649 | 3524 | 33.7402158013069 | 54.1554631061561 | 0.611457597562043 | monthly | 11 | 1076.83333333333 | 254.566666666667 | 668.235599225485 | 408.597734107848 | 822.266666666667 | 7.87271702030495 | 12.6362747247698 | ||
24549 | 24549 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 3233530 | 4615 | 1091 | 2863.86685382351 | 1751.13314617649 | 3524 | 33.7402158013069 | 54.1554631061562 | 0.611457597562044 | monthly | 11 | 1076.83333333333 | 254.566666666667 | 668.235599225485 | 408.597734107848 | 822.266666666667 | 7.87271702030495 | 12.6362747247698 | ||
21654 | 21654 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 3233530 | 3779 | 803 | 2597.46685382351 | 1181.53314617649 | 2976 | 24.8335410526576 | 36.540039714383 | 0.454879008152599 | monthly | 9 | 881.766666666667 | 187.366666666667 | 606.075599225485 | 275.691067441182 | 694.4 | 5.79449291228678 | 8.52600926668939 | ||
24547 | 24547 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 3233530 | 3779 | 803 | 2597.46685382351 | 1181.53314617649 | 2976 | 24.8335410526576 | 36.5400397143831 | 0.4548790081526 | monthly | 9 | 881.766666666667 | 187.366666666667 | 606.075599225485 | 275.691067441182 | 694.4 | 5.79449291228678 | 8.52600926668939 | ||
21651 | 21651 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 3233530 | 3276 | 412 | 2692.46685382351 | 583.533146176492 | 2864 | 12.7414930432066 | 18.0463192293404 | 0.21672807052307 | monthly | 6 | 764.4 | 96.1333333333333 | 628.242265892152 | 136.157734107848 | 668.266666666667 | 2.97301504341488 | 4.21080782017944 | ||
24544 | 24544 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 3233530 | 3276 | 412 | 2692.46685382351 | 583.533146176492 | 2864 | 12.7414930432066 | 18.0463192293404 | 0.216728070523071 | monthly | 6 | 764.4 | 96.1333333333333 | 628.242265892152 | 136.157734107848 | 668.266666666667 | 2.97301504341488 | 4.21080782017944 | ||
21649 | 21649 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 3233530 | 6051 | 1952 | 2938.86685382351 | 3112.13314617649 | 4099 | 60.3674621852898 | 96.2456864843218 | 1.05895683641726 | monthly | 4 | 1411.9 | 455.466666666667 | 685.735599225485 | 726.164400774515 | 956.433333333333 | 14.0857411765676 | 22.4573268463418 | ||
24542 | 24542 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 3233530 | 6051 | 1952 | 2938.86685382351 | 3112.13314617649 | 4099 | 60.3674621852898 | 96.2456864843218 | 1.05895683641726 | monthly | 4 | 1411.9 | 455.466666666667 | 685.735599225485 | 726.164400774515 | 956.433333333333 | 14.0857411765676 | 22.4573268463418 | ||
21644 | 21644 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 3233530 | 5410 | 1447 | 2896.30014036764 | 2513.69985963236 | 3963 | 44.7498554211651 | 77.7385661995516 | 0.867900334152967 | monthly | 11 | 1262.33333333333 | 337.633333333333 | 675.803366085782 | 586.529967247551 | 924.7 | 10.4416329316052 | 18.1389987798954 | ||
24537 | 24537 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 3233530 | 5410 | 1447 | 2896.30014036764 | 2513.69985963236 | 3963 | 44.7498554211651 | 77.7385661995517 | 0.867900334152969 | monthly | 11 | 1262.33333333333 | 337.633333333333 | 675.803366085782 | 586.529967247551 | 924.7 | 10.4416329316052 | 18.1389987798954 | ||
21642 | 21642 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 3233530 | 3459 | 247 | 2629.90014036764 | 829.099859632364 | 3212 | 7.63871063512632 | 25.6407041107509 | 0.315259065128024 | monthly | 9 | 807.1 | 57.6333333333333 | 613.643366085782 | 193.456633914218 | 749.466666666667 | 1.78236581486281 | 5.98283095917521 | ||
24535 | 24535 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 3233530 | 3459 | 247 | 2629.90014036764 | 829.099859632364 | 3212 | 7.63871063512632 | 25.6407041107509 | 0.315259065128025 | monthly | 9 | 807.1 | 57.6333333333333 | 613.643366085782 | 193.456633914218 | 749.466666666667 | 1.78236581486281 | 5.98283095917521 | ||
21639 | 21639 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 3233530 | 2953 | 33 | 2724.90014036764 | 228.099859632363 | 2920 | 1.02055648161607 | 7.05420576374312 | 0.0837094381013117 | monthly | 6 | 689.033333333333 | 7.7 | 635.810032752448 | 53.2233005808848 | 681.333333333333 | 0.238129845710416 | 1.6459813448734 | ||
24532 | 24532 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 3233530 | 2953 | 33 | 2724.90014036764 | 228.099859632363 | 2920 | 1.02055648161607 | 7.05420576374314 | 0.0837094381013128 | monthly | 6 | 689.033333333333 | 7.7 | 635.810032752448 | 53.2233005808848 | 681.333333333333 | 0.238129845710416 | 1.6459813448734 | ||
21637 | 21637 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 3233530 | 3207 | 56 | 2971.30014036764 | 235.699859632364 | 3151 | 1.73185342334848 | 7.28924301405473 | 0.0793254967514647 | monthly | 4 | 748.3 | 13.0666666666667 | 693.303366085782 | 54.9966339142182 | 735.233333333333 | 0.404099132114645 | 1.7008233699461 | ||
24530 | 24530 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 3233530 | 3207 | 56 | 2971.30014036764 | 235.699859632364 | 3151 | 1.73185342334848 | 7.28924301405473 | 0.0793254967514661 | monthly | 4 | 748.3 | 13.0666666666667 | 693.303366085782 | 54.9966339142182 | 735.233333333333 | 0.404099132114645 | 1.7008233699461 |
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);