economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where country = "Egypt" and days = 30 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, year, total_deaths, covid_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, month, covid_deaths_per_7_days, excess_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
10678 | 10678 | Egypt | Egypt | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 110990096 | 60180 | 1823 | 43786.1689154911 | 16393.8310845089 | 58357 | 1.64248889378382 | 14.770535097572 | 0.374406610364783 | monthly | 11 | 14042.0 | 425.366666666667 | 10216.7727469479 | 3825.22725305207 | 13616.6333333333 | 0.383247408549558 | 3.44645818943347 | ||
21817 | 21817 | Egypt | Egypt | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 110990096 | 60180 | 1823 | 43786.1689154911 | 16393.8310845089 | 58357 | 1.64248889378382 | 14.770535097572 | 0.374406610364784 | monthly | 11 | 14042.0 | 425.366666666667 | 10216.7727469479 | 3825.22725305207 | 13616.6333333333 | 0.383247408549558 | 3.44645818943347 | ||
10676 | 10676 | Egypt | Egypt | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 110990096 | 57300 | 595 | 42475.7689154911 | 14824.2310845089 | 56705 | 0.536083868239919 | 13.356354862968 | 0.349004419767017 | monthly | 9 | 13370.0 | 138.833333333333 | 9911.01274694793 | 3458.98725305207 | 13231.1666666667 | 0.125086235922648 | 3.11648280135921 | ||
21815 | 21815 | Egypt | Egypt | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 110990096 | 57300 | 595 | 42475.7689154911 | 14824.2310845089 | 56705 | 0.536083868239919 | 13.356354862968 | 0.349004419767018 | monthly | 9 | 13370.0 | 138.833333333333 | 9911.01274694793 | 3458.98725305207 | 13231.1666666667 | 0.125086235922648 | 3.11648280135921 | ||
10673 | 10673 | Egypt | Egypt | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 110990096 | 54580 | 1073 | 43126.7689154911 | 11453.2310845089 | 53507 | 0.966752925414174 | 10.3191469304693 | 0.265571276785238 | monthly | 6 | 12735.3333333333 | 250.366666666667 | 10062.9127469479 | 2672.4205863854 | 12484.9666666667 | 0.225575682596641 | 2.40780095044283 | ||
21812 | 21812 | Egypt | Egypt | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 110990096 | 54580 | 1073 | 43126.7689154911 | 11453.2310845089 | 53507 | 0.966752925414174 | 10.3191469304693 | 0.265571276785238 | monthly | 6 | 12735.3333333333 | 250.366666666667 | 10062.9127469479 | 2672.4205863854 | 12484.9666666667 | 0.225575682596641 | 2.40780095044283 | ||
10671 | 10671 | Egypt | Egypt | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 110990096 | 67163 | 1344 | 42278.7689154911 | 24884.2310845089 | 65819 | 1.21091885531841 | 22.4202266520329 | 0.588575110459076 | monthly | 4 | 15671.3666666667 | 313.6 | 9865.04608028126 | 5806.32058638541 | 15357.7666666667 | 0.282547732907628 | 5.23138621880768 | ||
21810 | 21810 | Egypt | Egypt | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 110990096 | 67163 | 1344 | 42278.7689154911 | 24884.2310845089 | 65819 | 1.21091885531841 | 22.4202266520329 | 0.588575110459076 | monthly | 4 | 15671.3666666667 | 313.6 | 9865.04608028126 | 5806.32058638541 | 15357.7666666667 | 0.282547732907628 | 5.23138621880768 | ||
10666 | 10666 | Egypt | Egypt | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 110990096 | 50681 | 384 | 43813.4766866183 | 6867.52331338165 | 50297 | 0.345976815805259 | 6.18751002195876 | 0.156744541468428 | monthly | 11 | 11825.5666666667 | 89.6 | 10223.1445602109 | 1602.42210645572 | 11735.9666666667 | 0.0807279236878937 | 1.44375233845704 | ||
21805 | 21805 | Egypt | Egypt | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 110990096 | 50681 | 384 | 43813.4766866183 | 6867.52331338165 | 50297 | 0.345976815805259 | 6.18751002195876 | 0.156744541468429 | monthly | 11 | 11825.5666666667 | 89.6 | 10223.1445602109 | 1602.42210645572 | 11735.9666666667 | 0.0807279236878937 | 1.44375233845704 | ||
10664 | 10664 | Egypt | Egypt | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 110990096 | 49351 | 509 | 42503.0766866183 | 6847.92331338166 | 48842 | 0.4585994772002 | 6.16985078865204 | 0.161115943767376 | monthly | 9 | 11515.2333333333 | 118.766666666667 | 9917.38456021094 | 1597.84877312239 | 11396.4666666667 | 0.107006544680047 | 1.43963185068548 | ||
21803 | 21803 | Egypt | Egypt | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 110990096 | 49351 | 509 | 42503.0766866183 | 6847.92331338166 | 48842 | 0.4585994772002 | 6.16985078865204 | 0.161115943767377 | monthly | 9 | 11515.2333333333 | 118.766666666667 | 9917.38456021094 | 1597.84877312239 | 11396.4666666667 | 0.107006544680047 | 1.43963185068548 | ||
10661 | 10661 | Egypt | Egypt | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 110990096 | 79078 | 1994 | 43154.0766866183 | 35923.9233133817 | 77084 | 1.7965566945721 | 32.3667828104065 | 0.832457233977186 | monthly | 6 | 18451.5333333333 | 465.266666666667 | 10069.2845602109 | 8382.24877312239 | 17986.2666666667 | 0.419196562066823 | 7.55224932242818 | ||
21800 | 21800 | Egypt | Egypt | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 110990096 | 79078 | 1994 | 43154.0766866183 | 35923.9233133817 | 77084 | 1.7965566945721 | 32.3667828104065 | 0.832457233977188 | monthly | 6 | 18451.5333333333 | 465.266666666667 | 10069.2845602109 | 8382.24877312239 | 17986.2666666667 | 0.419196562066823 | 7.55224932242818 | ||
10659 | 10659 | Egypt | Egypt | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 110990096 | 42078 | 346 | 42306.0766866183 | -228.076686618318 | 41732 | 0.311739526741197 | -0.20549282759276 | -0.00539110937437648 | monthly | 4 | 9818.2 | 80.7333333333333 | 9871.41789354427 | -53.2178935442743 | 9737.46666666667 | 0.0727392229062793 | -0.0479483264383106 | ||
21798 | 21798 | Egypt | Egypt | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 110990096 | 42078 | 346 | 42306.0766866183 | -228.076686618318 | 41732 | 0.311739526741197 | -0.205492827592759 | -0.00539110937437592 | monthly | 4 | 9818.2 | 80.7333333333333 | 9871.41789354427 | -53.2178935442743 | 9737.46666666667 | 0.0727392229062793 | -0.0479483264383106 |
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);