economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
24 rows where cadence = "monthly", country = "Egypt" and year = 2021 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, days, total_deaths, covid_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, total_deaths_per_7_days, covid_deaths_per_7_days, excess_deaths_per_7_days, non_covid_deaths_per_7_days, excess_deaths_per_100k_per_7_days, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10679 | 10679 | Egypt | Egypt | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 110990096 | 59726 | 1278 | 53042.1278793408 | 6683.87212065918 | 58448 | 1.15145409010188 | 6.02204373321668 | 0.126010633205808 | monthly | 12 | 13486.5161290323 | 288.58064516129 | 11977.2546824318 | 1509.26144660046 | 13197.935483871 | 0.260005762281069 | 1.35981632685538 | ||
21818 | 21818 | Egypt | Egypt | 0 | 2021-12-01 | 2021-12-31 | 31 | 2021 | 110990096 | 59726 | 1278 | 53042.1278793408 | 6683.87212065918 | 58448 | 1.15145409010188 | 6.02204373321668 | 0.126010633205808 | monthly | 12 | 13486.5161290323 | 288.58064516129 | 11977.2546824318 | 1509.26144660046 | 13197.935483871 | 0.260005762281069 | 1.35981632685538 | ||
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 | ||
10677 | 10677 | Egypt | Egypt | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 110990096 | 65093 | 1320 | 42795.1278793408 | 22297.8721206592 | 63773 | 1.18929530433058 | 20.0899656133816 | 0.521037632683963 | monthly | 10 | 14698.4193548387 | 298.064516129032 | 9663.41597275438 | 5035.00338208433 | 14400.3548387097 | 0.268550552590776 | 4.53644384818293 | ||
21816 | 21816 | Egypt | Egypt | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 110990096 | 65093 | 1320 | 42795.1278793408 | 22297.8721206592 | 63773 | 1.18929530433058 | 20.0899656133816 | 0.521037632683963 | monthly | 10 | 14698.4193548387 | 298.064516129032 | 9663.41597275438 | 5035.00338208433 | 14400.3548387097 | 0.268550552590776 | 4.53644384818293 | ||
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 | ||
10675 | 10675 | Egypt | Egypt | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 110990096 | 56235 | 212 | 49504.9278793408 | 6730.07212065918 | 56023 | 0.19100803372582 | 6.06366906886826 | 0.135947518943215 | monthly | 8 | 12698.2258064516 | 47.8709677419355 | 11178.5321017866 | 1519.69370466498 | 12650.3548387097 | 0.0431308463251852 | 1.36921559619606 | ||
21814 | 21814 | Egypt | Egypt | 0 | 2021-08-01 | 2021-08-31 | 31 | 2021 | 110990096 | 56235 | 212 | 49504.9278793408 | 6730.07212065918 | 56023 | 0.19100803372582 | 6.06366906886825 | 0.135947518943216 | monthly | 8 | 12698.2258064516 | 47.8709677419355 | 11178.5321017866 | 1519.69370466498 | 12650.3548387097 | 0.0431308463251852 | 1.36921559619606 | ||
10674 | 10674 | Egypt | Egypt | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 110990096 | 54861 | 355 | 46989.3278793408 | 7871.67212065918 | 54506 | 0.319848358361633 | 7.09222931085597 | 0.167520423804998 | monthly | 7 | 12387.9677419355 | 80.1612903225806 | 10610.4933921092 | 1777.47434982627 | 12307.8064516129 | 0.0722238228558525 | 1.60147113470941 | ||
21813 | 21813 | Egypt | Egypt | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 110990096 | 54861 | 355 | 46989.3278793408 | 7871.67212065918 | 54506 | 0.319848358361633 | 7.09222931085597 | 0.167520423804998 | monthly | 7 | 12387.9677419355 | 80.1612903225806 | 10610.4933921092 | 1777.47434982627 | 12307.8064516129 | 0.0722238228558525 | 1.60147113470941 | ||
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 | ||
10672 | 10672 | Egypt | Egypt | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 110990096 | 73447 | 1757 | 43485.7278793408 | 29961.2721206592 | 71690 | 1.58302412856729 | 26.9945456400535 | 0.688990930628832 | monthly | 5 | 16584.8064516129 | 396.741935483871 | 9819.35790823825 | 6765.44854337465 | 16188.064516129 | 0.357457061289388 | 6.09554256388305 | ||
21811 | 21811 | Egypt | Egypt | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 110990096 | 73447 | 1757 | 43485.7278793408 | 29961.2721206592 | 71690 | 1.58302412856729 | 26.9945456400535 | 0.688990930628833 | monthly | 5 | 16584.8064516129 | 396.741935483871 | 9819.35790823825 | 6765.44854337465 | 16188.064516129 | 0.357457061289388 | 6.09554256388305 | ||
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 | ||
10670 | 10670 | Egypt | Egypt | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 110990096 | 60592 | 1307 | 46138.9278793408 | 14453.0721206592 | 59285 | 1.1775825475455 | 13.0219475804933 | 0.313251147890905 | monthly | 3 | 13682.064516129 | 295.129032258065 | 10418.4675856576 | 3263.59693047143 | 13386.935483871 | 0.265905736542533 | 2.94043977624042 | ||
21809 | 21809 | Egypt | Egypt | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 110990096 | 60592 | 1307 | 46138.9278793408 | 14453.0721206592 | 59285 | 1.1775825475455 | 13.0219475804933 | 0.313251147890905 | monthly | 3 | 13682.064516129 | 295.129032258065 | 10418.4675856576 | 3263.59693047143 | 13386.935483871 | 0.265905736542533 | 2.94043977624042 | ||
10669 | 10669 | Egypt | Egypt | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 110990096 | 54184 | 1372 | 47819.8520855821 | 6364.14791441789 | 52812 | 1.23614633147087 | 5.73397820506245 | 0.13308589710876 | monthly | 2 | 13546.0 | 343.0 | 11954.9630213955 | 1591.03697860447 | 13203.0 | 0.309036582867718 | 1.43349455126561 | ||
21808 | 21808 | Egypt | Egypt | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 110990096 | 54184 | 1372 | 47819.8520855821 | 6364.14791441789 | 52812 | 1.23614633147087 | 5.73397820506245 | 0.13308589710876 | monthly | 2 | 13546.0 | 343.0 | 11954.9630213955 | 1591.03697860447 | 13203.0 | 0.309036582867718 | 1.43349455126561 | ||
10668 | 10668 | Egypt | Egypt | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 110990096 | 69452 | 1685 | 58204.4035610899 | 11247.5964389101 | 67767 | 1.51815347560381 | 10.1338739619706 | 0.193243049507499 | monthly | 1 | 15682.7096774194 | 380.483870967742 | 13142.9298363751 | 2539.77984104422 | 15302.2258064516 | 0.342808849329892 | 2.28829412044496 | ||
21807 | 21807 | Egypt | Egypt | 0 | 2021-01-01 | 2021-01-31 | 31 | 2021 | 110990096 | 69452 | 1685 | 58204.4035610899 | 11247.5964389101 | 67767 | 1.51815347560381 | 10.1338739619705 | 0.193243049507498 | monthly | 1 | 15682.7096774194 | 380.483870967742 | 13142.9298363751 | 2539.77984104422 | 15302.2258064516 | 0.342808849329892 | 2.28829412044496 |
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);