economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
18 rows where cadence = "monthly", country = "Bosnia and Herzegovina" and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, 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, 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 | ||
21665 | 21665 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 3233530 | 3182 | 197 | 2743.82801952204 | 438.17198047796 | 2985 | 6.09241293570803 | 13.5508865072524 | 0.15969367517221 | monthly | 8 | 718.516129032258 | 44.4838709677419 | 619.574068924331 | 98.9420601079266 | 674.032258064516 | 1.37570614677278 | 3.05987759841185 | ||
24558 | 24558 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 3233530 | 3182 | 197 | 2743.82801952204 | 438.17198047796 | 2985 | 6.09241293570803 | 13.5508865072525 | 0.15969367517221 | monthly | 8 | 718.516129032258 | 44.4838709677419 | 619.574068924331 | 98.9420601079266 | 674.032258064516 | 1.37570614677278 | 3.05987759841185 | ||
21664 | 21664 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3233530 | 2779 | 47 | 2699.02801952204 | 79.9719804779606 | 2732 | 1.45351983745319 | 2.47320978861989 | 0.029629918585329 | monthly | 7 | 627.516129032258 | 10.6129032258065 | 609.457939892073 | 18.0581891401847 | 616.903225806452 | 0.328214156844268 | 0.558466726462555 | ||
24557 | 24557 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 3233530 | 2779 | 47 | 2699.02801952204 | 79.9719804779606 | 2732 | 1.45351983745319 | 2.47320978861989 | 0.0296299185853293 | monthly | 7 | 627.516129032258 | 10.6129032258065 | 609.457939892073 | 18.0581891401847 | 616.903225806452 | 0.328214156844268 | 0.558466726462555 | ||
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 | ||
21662 | 21662 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 3233530 | 3000 | 23 | 2888.82801952204 | 111.17198047796 | 2977 | 0.71129694173241 | 3.43809955305688 | 0.0384834194790016 | monthly | 5 | 677.41935483871 | 5.19354838709677 | 652.316004408203 | 25.1033504305072 | 672.225806451613 | 0.160615438455706 | 0.776345060367685 | ||
24555 | 24555 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 3233530 | 3000 | 23 | 2888.82801952204 | 111.17198047796 | 2977 | 0.71129694173241 | 3.43809955305689 | 0.0384834194790018 | monthly | 5 | 677.41935483871 | 5.19354838709677 | 652.316004408203 | 25.1033504305072 | 672.225806451613 | 0.160615438455706 | 0.776345060367685 | ||
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 | ||
21660 | 21660 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 3233530 | 3931 | 254 | 3256.22801952204 | 674.77198047796 | 3677 | 7.85519231304488 | 20.8679672208998 | 0.207225039657083 | monthly | 3 | 887.645161290323 | 57.3548387096774 | 735.277294730783 | 152.367866559539 | 830.290322580645 | 1.77375310294562 | 4.71212163052575 | ||
24553 | 24553 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 3233530 | 3931 | 254 | 3256.22801952204 | 674.77198047796 | 3677 | 7.85519231304488 | 20.8679672208998 | 0.207225039657083 | monthly | 3 | 887.645161290323 | 57.3548387096774 | 735.277294730783 | 152.367866559539 | 830.290322580645 | 1.77375310294562 | 4.71212163052575 | ||
21659 | 21659 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 3233530 | 5060 | 1012 | 3171.83192065262 | 1888.16807934738 | 4048 | 31.297065436226 | 58.3933991441978 | 0.595292602692163 | monthly | 2 | 1265.0 | 253.0 | 792.957980163156 | 472.042019836844 | 1012.0 | 7.82426635905651 | 14.5983497860494 | ||
24552 | 24552 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 3233530 | 5060 | 1012 | 3171.83192065262 | 1888.16807934738 | 4048 | 31.297065436226 | 58.3933991441977 | 0.595292602692161 | monthly | 2 | 1265.0 | 253.0 | 792.957980163156 | 472.042019836844 | 1012.0 | 7.82426635905651 | 14.5983497860494 | ||
21658 | 21658 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3233530 | 3985 | 1005 | 3196.18521756985 | 788.814782430154 | 2980 | 31.0805837583075 | 24.3948496667776 | 0.246798833213398 | monthly | 1 | 899.83870967742 | 226.935483870968 | 721.719242677062 | 178.119467000357 | 672.903225806452 | 7.01819633252105 | 5.50851444088526 | ||
24551 | 24551 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 3233530 | 3985 | 1005 | 3196.18521756985 | 788.814782430154 | 2980 | 31.0805837583075 | 24.3948496667776 | 0.246798833213399 | monthly | 1 | 899.83870967742 | 226.935483870968 | 721.719242677062 | 178.119467000357 | 672.903225806452 | 7.01819633252105 | 5.50851444088526 |
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);