economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "Bosnia and Herzegovina" and year = 2021 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, total_deaths, covid_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, month, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21657 | 21657 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 3233530 | 4655 | 856 | 2992.94241561762 | 1662.05758438238 | 3799 | 26.472616614041 | 51.4007163806236 | 0.555325613920774 | monthly | 12 | 1051.12903225806 | 193.290322580645 | 675.825706752367 | 375.303325505698 | 857.838709677419 | 5.97768762252539 | 11.6066133762698 | ||
24550 | 24550 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 3233530 | 4655 | 856 | 2992.94241561762 | 1662.05758438238 | 3799 | 26.472616614041 | 51.4007163806235 | 0.555325613920772 | monthly | 12 | 1051.12903225806 | 193.290322580645 | 675.825706752367 | 375.303325505698 | 857.838709677419 | 5.97768762252539 | 11.6066133762698 | ||
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 | ||
21655 | 21655 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 3233530 | 4125 | 889 | 2938.34241561762 | 1186.65758438238 | 3236 | 27.4931730956571 | 36.6985178545546 | 0.403852722567377 | monthly | 10 | 931.451612903226 | 200.741935483871 | 663.496674494302 | 267.954938408923 | 730.709677419355 | 6.20813586030966 | 8.28676209618972 | ||
24548 | 24548 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 3233530 | 4125 | 889 | 2938.34241561762 | 1186.65758438238 | 3236 | 27.4931730956571 | 36.6985178545545 | 0.403852722567375 | monthly | 10 | 931.451612903226 | 200.741935483871 | 663.496674494302 | 267.954938408923 | 730.709677419355 | 6.20813586030966 | 8.28676209618972 | ||
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 | ||
21653 | 21653 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 3233530 | 3019 | 116 | 2777.34241561762 | 241.657584382375 | 2903 | 3.58741066265042 | 7.47349133554892 | 0.0870103675454221 | monthly | 8 | 681.709677419355 | 26.1935483870968 | 627.141835784625 | 54.5678416347299 | 655.516129032258 | 0.810060472211384 | 1.68756255964008 | ||
24546 | 24546 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 3233530 | 3019 | 116 | 2777.34241561762 | 241.657584382375 | 2903 | 3.58741066265042 | 7.47349133554893 | 0.0870103675454204 | monthly | 8 | 681.709677419355 | 26.1935483870968 | 627.141835784625 | 54.5678416347299 | 655.516129032258 | 0.810060472211384 | 1.68756255964008 | ||
21652 | 21652 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 3233530 | 3067 | 33 | 2732.54241561763 | 334.457584382375 | 3034 | 1.02055648161607 | 10.3434198656693 | 0.122397947958943 | monthly | 7 | 692.548387096774 | 7.45161290322581 | 617.025706752367 | 75.5226803444073 | 685.096774193548 | 0.230448237784273 | 2.33561093740919 | ||
24545 | 24545 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 3233530 | 3067 | 33 | 2732.54241561763 | 334.457584382375 | 3034 | 1.02055648161607 | 10.3434198656693 | 0.122397947958945 | monthly | 7 | 692.548387096774 | 7.45161290322581 | 617.025706752367 | 75.5226803444073 | 685.096774193548 | 0.230448237784273 | 2.33561093740919 | ||
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 | ||
21650 | 21650 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 3233530 | 4223 | 702 | 2922.34241561762 | 1300.65758438238 | 3521 | 21.7100196998327 | 40.2240766092283 | 0.445073642784428 | monthly | 5 | 953.58064516129 | 158.516129032258 | 659.883771268496 | 293.696873892794 | 795.064516129032 | 4.90226251286545 | 9.08285600853539 | ||
24543 | 24543 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 3233530 | 4223 | 702 | 2922.34241561762 | 1300.65758438238 | 3521 | 21.7100196998327 | 40.2240766092282 | 0.445073642784426 | monthly | 5 | 953.58064516129 | 158.516129032258 | 659.883771268496 | 293.696873892794 | 795.064516129032 | 4.90226251286545 | 9.08285600853539 | ||
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 | ||
21648 | 21648 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 3233530 | 4787 | 1528 | 3289.74241561763 | 1497.25758438237 | 3259 | 47.2548576942227 | 46.3041191633407 | 0.455129124175295 | monthly | 3 | 1080.93548387097 | 345.032258064516 | 742.845061591077 | 338.090422279891 | 735.903225806452 | 10.6704517374051 | 10.455768843335 | ||
24541 | 24541 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 3233530 | 4787 | 1528 | 3289.74241561763 | 1497.25758438237 | 3259 | 47.2548576942227 | 46.3041191633408 | 0.455129124175297 | monthly | 3 | 1080.93548387097 | 345.032258064516 | 742.845061591077 | 338.090422279891 | 735.903225806452 | 10.6704517374051 | 10.455768843335 | ||
21647 | 21647 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 3233530 | 3454 | 392 | 3202.1029880938 | 251.897011906203 | 3062 | 12.1229739634393 | 7.79015540001803 | 0.078666118123875 | monthly | 2 | 863.5 | 98.0 | 800.525747023449 | 62.9742529765508 | 765.5 | 3.03074349085983 | 1.94753885000451 | ||
24540 | 24540 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 3233530 | 3454 | 392 | 3202.1029880938 | 251.897011906203 | 3062 | 12.1229739634393 | 7.79015540001804 | 0.0786661181238761 | monthly | 2 | 863.5 | 98.0 | 800.525747023449 | 62.9742529765508 | 765.5 | 3.03074349085983 | 1.94753885000451 | ||
21646 | 21646 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 3233530 | 3452 | 629 | 3229.69961366543 | 222.300386334568 | 2823 | 19.452425058682 | 6.87485151937876 | 0.0688300501365444 | monthly | 1 | 779.483870967742 | 142.032258064516 | 729.287009537356 | 50.1968614303864 | 637.451612903226 | 4.3924830777669 | 1.5523858269565 | ||
24539 | 24539 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 3233530 | 3452 | 629 | 3229.69961366543 | 222.300386334568 | 2823 | 19.452425058682 | 6.87485151937877 | 0.068830050136544 | monthly | 1 | 779.483870967742 | 142.032258064516 | 729.287009537356 | 50.1968614303864 | 637.451612903226 | 4.3924830777669 | 1.5523858269565 |
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);