economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
18 rows where cadence = "monthly", country = "Egypt" and year = 2022 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, total_deaths, expected_deaths, excess_deaths, covid_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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10688 | 10688 | Egypt | Egypt | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 110990096 | 42200 | 3 | 42448.4611443639 | -248.461144363901 | 42197 | 0.00270294387347858 | -0.223858842651961 | -0.00585324267748843 | monthly | 9 | 9846.66666666667 | 0.7 | 9904.64093368491 | -57.9742670182435 | 9845.96666666667 | 0.00063068690381167 | -0.0522337299521242 | ||
21827 | 21827 | Egypt | Egypt | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 110990096 | 42200 | 3 | 42448.4611443639 | -248.461144363901 | 42197 | 0.00270294387347858 | -0.223858842651962 | -0.00585324267748843 | monthly | 9 | 9846.66666666667 | 0.7 | 9904.64093368491 | -57.9742670182435 | 9845.96666666667 | 0.00063068690381167 | -0.0522337299521242 | ||
10687 | 10687 | Egypt | Egypt | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 110990096 | 48000 | 29 | 49476.709849176 | -1476.70984917603 | 47971 | 0.0261284574436263 | -1.33048794657861 | -0.0298465652562105 | monthly | 8 | 10838.7096774194 | 6.54838709677419 | 11172.1602885236 | -333.450611104264 | 10832.1612903226 | 0.00589997426146401 | -0.300432762130654 | ||
21826 | 21826 | Egypt | Egypt | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 110990096 | 48000 | 29 | 49476.709849176 | -1476.70984917603 | 47971 | 0.0261284574436263 | -1.33048794657861 | -0.02984656525621 | monthly | 8 | 10838.7096774194 | 6.54838709677419 | 11172.1602885236 | -333.450611104264 | 10832.1612903226 | 0.00589997426146401 | -0.300432762130654 | ||
10686 | 10686 | Egypt | Egypt | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 110990096 | 45300 | 42 | 46961.109849176 | -1661.10984917603 | 45258 | 0.0378412142287002 | -1.49662889666843 | -0.0353720313363757 | monthly | 7 | 10229.0322580645 | 9.48387096774193 | 10604.1215788462 | -375.089320781685 | 10219.5483870968 | 0.00854479030970649 | -0.337948460538033 | ||
21825 | 21825 | Egypt | Egypt | 0 | 2022-07-01 | 2022-07-31 | 31 | 2022 | 110990096 | 45300 | 42 | 46961.109849176 | -1661.10984917603 | 45258 | 0.0378412142287002 | -1.49662889666843 | -0.0353720313363749 | monthly | 7 | 10229.0322580645 | 9.48387096774193 | 10604.1215788462 | -375.089320781685 | 10219.5483870968 | 0.00854479030970649 | -0.337948460538033 | ||
10685 | 10685 | Egypt | Egypt | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 110990096 | 42600 | 5 | 43099.4611443639 | -499.461144363893 | 42595 | 0.00450490645579764 | -0.450005146732996 | -0.0115885705088266 | monthly | 6 | 9940.0 | 1.16666666666667 | 10056.5409336849 | -116.540933684908 | 9938.83333333333 | 0.00105114483968612 | -0.105001200904366 | ||
21824 | 21824 | Egypt | Egypt | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 110990096 | 42600 | 5 | 43099.4611443639 | -499.461144363893 | 42595 | 0.00450490645579764 | -0.450005146732996 | -0.0115885705088268 | monthly | 6 | 9940.0 | 1.16666666666667 | 10056.5409336849 | -116.540933684908 | 9938.83333333333 | 0.00105114483968612 | -0.105001200904366 | ||
10684 | 10684 | Egypt | Egypt | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 110990096 | 44500 | 105 | 43457.509849176 | 1042.49015082398 | 44395 | 0.0946030355717505 | 0.939264122110479 | 0.0239887226498263 | monthly | 5 | 10048.3870967742 | 23.7096774193548 | 9812.98609497523 | 235.401001798963 | 10024.6774193548 | 0.0213619757742662 | 0.212091898541076 | ||
21823 | 21823 | Egypt | Egypt | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 110990096 | 44500 | 105 | 43457.509849176 | 1042.49015082398 | 44395 | 0.0946030355717505 | 0.939264122110481 | 0.0239887226498268 | monthly | 5 | 10048.3870967742 | 23.7096774193548 | 9812.98609497523 | 235.401001798963 | 10024.6774193548 | 0.0213619757742662 | 0.212091898541076 | ||
10683 | 10683 | Egypt | Egypt | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 110990096 | 44800 | 196 | 42251.4611443639 | 2548.53885563612 | 44604 | 0.176592333067268 | 2.29618582872126 | 0.0603183602793838 | monthly | 4 | 10453.3333333333 | 45.7333333333333 | 9858.67426701824 | 594.659066315095 | 10407.6 | 0.0412048777156958 | 0.535776693368294 | ||
21822 | 21822 | Egypt | Egypt | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 110990096 | 44800 | 196 | 42251.4611443639 | 2548.53885563612 | 44604 | 0.176592333067268 | 2.29618582872126 | 0.0603183602793831 | monthly | 4 | 10453.3333333333 | 45.7333333333333 | 9858.67426701824 | 594.659066315095 | 10407.6 | 0.0412048777156958 | 0.535776693368294 | ||
10682 | 10682 | Egypt | Egypt | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 110990096 | 53400 | 343 | 46110.709849176 | 7289.29015082397 | 53057 | 0.309036582867718 | 6.56751405172581 | 0.158082366865888 | monthly | 3 | 12058.064516129 | 77.4516129032258 | 10412.0957723946 | 1645.96874373444 | 11980.6129032258 | 0.0697824541959364 | 1.48298704393809 | ||
21821 | 21821 | Egypt | Egypt | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 110990096 | 53400 | 343 | 46110.709849176 | 7289.29015082397 | 53057 | 0.309036582867718 | 6.56751405172581 | 0.158082366865889 | monthly | 3 | 12058.064516129 | 77.4516129032258 | 10412.0957723946 | 1645.96874373444 | 11980.6129032258 | 0.0697824541959364 | 1.48298704393809 | ||
10681 | 10681 | Egypt | Egypt | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 110990096 | 68100 | 1439 | 47794.36483253 | 20305.63516747 | 66661 | 1.29651207797856 | 18.2949973910014 | 0.424854169285862 | monthly | 2 | 17025.0 | 359.75 | 11948.5912081325 | 5076.40879186749 | 16665.25 | 0.32412801949464 | 4.57374934775035 | ||
21820 | 21820 | Egypt | Egypt | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 110990096 | 68100 | 1439 | 47794.36483253 | 20305.63516747 | 66661 | 1.29651207797856 | 18.2949973910014 | 0.424854169285863 | monthly | 2 | 17025.0 | 359.75 | 11948.5912081325 | 5076.40879186749 | 16665.25 | 0.32412801949464 | 4.57374934775035 | ||
10680 | 10680 | Egypt | Egypt | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 110990096 | 69000 | 883 | 58176.1855309251 | 10823.8144690749 | 68117 | 0.795566480093863 | 9.7520543356183 | 0.186052323133514 | monthly | 1 | 15580.6451612903 | 199.387096774194 | 13136.5580231121 | 2444.08713817821 | 15381.2580645161 | 0.179644043892163 | 2.2020767854622 | ||
21819 | 21819 | Egypt | Egypt | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 110990096 | 69000 | 883 | 58176.1855309251 | 10823.8144690749 | 68117 | 0.795566480093863 | 9.75205433561829 | 0.186052323133513 | monthly | 1 | 15580.6451612903 | 199.387096774194 | 13136.5580231121 | 2444.08713817821 | 15381.2580645161 | 0.179644043892163 | 2.2020767854622 |
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);