economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
20 rows where cadence = "monthly" and total_deaths = 40 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, start_date, end_date, days, year, population, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, 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)
country 7
cadence 1
- monthly · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18272 | 18272 | Monaco | Monaco | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 36491 | 40 | 0 | 32.7677081432831 | 7.23229185671693 | 40 | 0.0 | 19.8193852092761 | 0.220713997606801 | monthly | 8 | 9.03225806451613 | 0.0 | 7.39915990332199 | 1.63309816119414 | 9.03225806451613 | 0.0 | 4.47534504725588 | ||
22469 | 22469 | Monaco | Monaco | 0 | 2022-08-01 | 2022-08-31 | 31 | 2022 | 36491 | 40 | 0 | 32.7677081432831 | 7.23229185671693 | 40 | 0.0 | 19.8193852092761 | 0.2207139976068 | monthly | 8 | 9.03225806451613 | 0.0 | 7.39915990332199 | 1.63309816119414 | 9.03225806451613 | 0.0 | 4.47534504725588 | ||
19529 | 19529 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 47681 | 40 | 9 | 29.6418221304102 | 10.3581778695898 | 31 | 18.8754430485938 | 21.723910718294 | 0.349444707684252 | monthly | 2 | 10.0 | 2.25 | 7.41045553260256 | 2.58954446739744 | 7.75 | 4.71886076214845 | 5.43097767957351 | ||
22776 | 22776 | Saint Kitts and Nevis | Saint Kitts and Nevis | 0 | 2022-02-01 | 2022-02-28 | 28 | 2022 | 47681 | 40 | 9 | 29.6418221304102 | 10.3581778695898 | 31 | 18.8754430485938 | 21.7239107182941 | 0.349444707684252 | monthly | 2 | 10.0 | 2.25 | 7.41045553260256 | 2.58954446739744 | 7.75 | 4.71886076214845 | 5.43097767957351 | ||
17983 | 17983 | Faroe Islands | Faroe Islands | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 49085 | 40 | 0 | 40.3853393541325 | -0.38533935413254 | 40 | 0.0 | -0.785045032357218 | -0.00954156533769746 | monthly | 1 | 9.03225806451613 | 0.0 | 9.11927017673961 | -0.0870121122234768 | 9.03225806451613 | 0.0 | -0.17726823311292 | ||
21860 | 21860 | Faroe Islands | Faroe Islands | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 49085 | 40 | 0 | 40.3853393541325 | -0.38533935413254 | 40 | 0.0 | -0.785045032357217 | -0.00954156533769646 | monthly | 1 | 9.03225806451613 | 0.0 | 9.11927017673961 | -0.0870121122234768 | 9.03225806451613 | 0.0 | -0.17726823311292 | ||
17974 | 17974 | Faroe Islands | Faroe Islands | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 49085 | 40 | 0 | 31.9049514157413 | 8.0950485842587 | 40 | 0.0 | 16.4918989187302 | 0.253723896293563 | monthly | 4 | 9.33333333333333 | 0.0 | 7.44448866367297 | 1.88884466966036 | 9.33333333333333 | 0.0 | 3.8481097477037 | ||
18256 | 18256 | Monaco | Monaco | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 36491 | 40 | 4 | 37.9298385625418 | 2.07016143745816 | 36 | 10.961606971582 | 5.67307401128542 | 0.0545787041525292 | monthly | 4 | 9.33333333333333 | 0.933333333333333 | 8.8502956645931 | 0.483037668740238 | 8.4 | 2.55770829336914 | 1.32371726929993 | ||
21851 | 21851 | Faroe Islands | Faroe Islands | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 49085 | 40 | 0 | 31.9049514157413 | 8.0950485842587 | 40 | 0.0 | 16.4918989187302 | 0.253723896293563 | monthly | 4 | 9.33333333333333 | 0.0 | 7.44448866367297 | 1.88884466966036 | 9.33333333333333 | 0.0 | 3.8481097477037 | ||
22453 | 22453 | Monaco | Monaco | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 36491 | 40 | 4 | 37.9298385625418 | 2.07016143745816 | 36 | 10.961606971582 | 5.67307401128541 | 0.0545787041525301 | monthly | 4 | 9.33333333333333 | 0.933333333333333 | 8.8502956645931 | 0.483037668740238 | 8.4 | 2.55770829336914 | 1.32371726929993 | ||
19085 | 19085 | Antigua and Barbuda | Antigua and Barbuda | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 93772 | 40 | 1 | 49.7961366538949 | -9.79613665389494 | 39 | 1.06641641428145 | -10.4467609242577 | -0.196724832731149 | monthly | 12 | 9.03225806451613 | 0.225806451612903 | 11.2442889218472 | -2.21203085733112 | 8.80645161290323 | 0.24080370645065 | -2.35894601515497 | ||
21372 | 21372 | Antigua and Barbuda | Antigua and Barbuda | 0 | 2020-12-01 | 2020-12-31 | 31 | 2020 | 93772 | 40 | 1 | 49.7961366538949 | -9.79613665389494 | 39 | 1.06641641428145 | -10.4467609242577 | -0.196724832731149 | monthly | 12 | 9.03225806451613 | 0.225806451612903 | 11.2442889218472 | -2.21203085733112 | 8.80645161290323 | 0.24080370645065 | -2.35894601515497 | ||
19927 | 19927 | Bermuda | Bermuda | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 64207 | 40 | 0 | 44.6606595511773 | -4.66065955117732 | 40 | 0.0 | -7.25880285822 | -0.104357159030233 | monthly | 7 | 9.03225806451613 | 0.0 | 10.0846650599433 | -1.05240699542714 | 9.03225806451613 | 0.0 | -1.63908451637226 | ||
21591 | 21591 | Bermuda | Bermuda | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 64207 | 40 | 0 | 44.6606595511773 | -4.66065955117732 | 40 | 0.0 | -7.25880285822001 | -0.104357159030233 | monthly | 7 | 9.03225806451613 | 0.0 | 10.0846650599433 | -1.05240699542714 | 9.03225806451613 | 0.0 | -1.63908451637226 | ||
18212 | 18212 | Greenland | Greenland | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 56494 | 40 | 0 | 46.2714002919177 | -6.27140029191767 | 40 | 0.0 | -11.1010023930288 | -0.135535130822767 | monthly | 5 | 9.03225806451613 | 0.0 | 10.4483807110782 | -1.41612264656205 | 9.03225806451613 | 0.0 | -2.50667795971617 | ||
21941 | 21941 | Greenland | Greenland | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 56494 | 40 | 0 | 46.2714002919177 | -6.27140029191767 | 40 | 0.0 | -11.1010023930288 | -0.135535130822767 | monthly | 5 | 9.03225806451613 | 0.0 | 10.4483807110782 | -1.41612264656205 | 9.03225806451613 | 0.0 | -2.50667795971617 | ||
17962 | 17962 | Faroe Islands | Faroe Islands | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 49085 | 40 | 0 | 31.6787135618059 | 8.32128643819406 | 40 | 0.0 | 16.9528092863279 | 0.262677536509146 | monthly | 4 | 9.33333333333333 | 0.0 | 7.39169983108805 | 1.94163350224528 | 9.33333333333333 | 0.0 | 3.95565550014318 | ||
21839 | 21839 | Faroe Islands | Faroe Islands | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 49085 | 40 | 0 | 31.6787135618059 | 8.32128643819406 | 40 | 0.0 | 16.9528092863279 | 0.262677536509148 | monthly | 4 | 9.33333333333333 | 0.0 | 7.39169983108805 | 1.94163350224528 | 9.33333333333333 | 0.0 | 3.95565550014318 | ||
20287 | 20287 | Andorra | Andorra | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 79843 | 40 | 12 | 32.9374283889796 | 7.06257161102035 | 28 | 15.0294953846925 | 8.84557395265753 | 0.214423892709954 | monthly | 3 | 9.03225806451613 | 2.70967741935484 | 7.4374838297696 | 1.59477423474653 | 6.32258064516129 | 3.39375702234991 | 1.99738766672912 | ||
21351 | 21351 | Andorra | Andorra | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 79843 | 40 | 12 | 32.9374283889796 | 7.06257161102035 | 28 | 15.0294953846925 | 8.84557395265753 | 0.214423892709956 | monthly | 3 | 9.03225806451613 | 2.70967741935484 | 7.4374838297696 | 1.59477423474653 | 6.32258064516129 | 3.39375702234991 | 1.99738766672912 |
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);