economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
20 rows where country = "Gibraltar" and covid_deaths_per_100k = "0.0" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, days, total_deaths, expected_deaths, excess_deaths, excess_deaths_per_100k, excess_deaths_pct_change, month, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18466 | 18466 | Gibraltar | Gibraltar | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 32677 | 25 | 0 | 24.7179483670858 | 0.282051632914193 | 25 | 0.0 | 0.863150328714977 | 0.0114108027383766 | monthly | 10 | 5.64516129032258 | 0.0 | 5.5814722119226 | 0.0636890783999791 | 5.64516129032258 | 0.0 | 0.19490491293564 | ||
21933 | 21933 | Gibraltar | Gibraltar | 0 | 2020-10-01 | 2020-10-31 | 31 | 2020 | 32677 | 25 | 0 | 24.7179483670858 | 0.282051632914193 | 25 | 0.0 | 0.863150328714977 | 0.0114108027383768 | monthly | 10 | 5.64516129032258 | 0.0 | 5.5814722119226 | 0.0636890783999791 | 5.64516129032258 | 0.0 | 0.19490491293564 | ||
18465 | 18465 | Gibraltar | Gibraltar | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 32677 | 23 | 0 | 25.0431758391153 | -2.0431758391153 | 23 | 0.0 | -6.25264203909569 | -0.0815861315769717 | monthly | 9 | 5.36666666666667 | 0.0 | 5.84340769579357 | -0.476741029126903 | 5.36666666666667 | 0.0 | -1.45894980912233 | ||
21932 | 21932 | Gibraltar | Gibraltar | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 32677 | 23 | 0 | 25.0431758391153 | -2.0431758391153 | 23 | 0.0 | -6.25264203909569 | -0.0815861315769717 | monthly | 9 | 5.36666666666667 | 0.0 | 5.84340769579357 | -0.476741029126903 | 5.36666666666667 | 0.0 | -1.45894980912233 | ||
18464 | 18464 | Gibraltar | Gibraltar | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 32677 | 22 | 0 | 23.9179483670858 | -1.91794836708581 | 22 | 0.0 | -5.86941386016405 | -0.0801886657521659 | monthly | 8 | 4.96774193548387 | 0.0 | 5.40082705063228 | -0.433085115148408 | 4.96774193548387 | 0.0 | -1.32535151681124 | ||
21931 | 21931 | Gibraltar | Gibraltar | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 32677 | 22 | 0 | 23.9179483670858 | -1.91794836708581 | 22 | 0.0 | -5.86941386016406 | -0.0801886657521657 | monthly | 8 | 4.96774193548387 | 0.0 | 5.40082705063228 | -0.433085115148408 | 4.96774193548387 | 0.0 | -1.32535151681124 | ||
18463 | 18463 | Gibraltar | Gibraltar | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 32677 | 23 | 0 | 20.1179483670858 | 2.88205163291419 | 23 | 0.0 | 8.8198170973902 | 0.143257730874258 | monthly | 7 | 5.19354838709677 | 0.0 | 4.54276253450325 | 0.650785852593528 | 5.19354838709677 | 0.0 | 1.9915716026365 | ||
21930 | 21930 | Gibraltar | Gibraltar | 0 | 2020-07-01 | 2020-07-31 | 31 | 2020 | 32677 | 23 | 0 | 20.1179483670858 | 2.88205163291419 | 23 | 0.0 | 8.81981709739018 | 0.143257730874258 | monthly | 7 | 5.19354838709677 | 0.0 | 4.54276253450325 | 0.650785852593528 | 5.19354838709677 | 0.0 | 1.9915716026365 | ||
18462 | 18462 | Gibraltar | Gibraltar | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 32677 | 16 | 0 | 22.6431758391153 | -6.6431758391153 | 16 | 0.0 | -20.3298217067518 | -0.293385339862063 | monthly | 6 | 3.73333333333333 | 0.0 | 5.28340769579357 | -1.55007436246024 | 3.73333333333333 | 0.0 | -4.74362506490876 | ||
21929 | 21929 | Gibraltar | Gibraltar | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 32677 | 16 | 0 | 22.6431758391153 | -6.6431758391153 | 16 | 0.0 | -20.3298217067518 | -0.293385339862063 | monthly | 6 | 3.73333333333333 | 0.0 | 5.28340769579357 | -1.55007436246024 | 3.73333333333333 | 0.0 | -4.74362506490876 | ||
18461 | 18461 | Gibraltar | Gibraltar | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 32677 | 12 | 0 | 23.5179483670858 | -11.5179483670858 | 12 | 0.0 | -35.2478757752725 | -0.489751409744805 | monthly | 5 | 2.70967741935484 | 0.0 | 5.31050446998712 | -2.60082705063228 | 2.70967741935484 | 0.0 | -7.9591977557067 | ||
21928 | 21928 | Gibraltar | Gibraltar | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 32677 | 12 | 0 | 23.5179483670858 | -11.5179483670858 | 12 | 0.0 | -35.2478757752725 | -0.489751409744805 | monthly | 5 | 2.70967741935484 | 0.0 | 5.31050446998712 | -2.60082705063228 | 2.70967741935484 | 0.0 | -7.9591977557067 | ||
18460 | 18460 | Gibraltar | Gibraltar | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 32677 | 21 | 0 | 23.0431758391153 | -2.04317583911529 | 21 | 0.0 | -6.25264203909566 | -0.088667284986258 | monthly | 4 | 4.9 | 0.0 | 5.3767410291269 | -0.476741029126901 | 4.9 | 0.0 | -1.45894980912232 | ||
21927 | 21927 | Gibraltar | Gibraltar | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 32677 | 21 | 0 | 23.0431758391153 | -2.04317583911529 | 21 | 0.0 | -6.25264203909566 | -0.0886672849862584 | monthly | 4 | 4.9 | 0.0 | 5.3767410291269 | -0.476741029126901 | 4.9 | 0.0 | -1.45894980912232 | ||
18459 | 18459 | Gibraltar | Gibraltar | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 32677 | 24 | 0 | 25.1179483670858 | -1.11794836708582 | 24 | 0.0 | -3.42120870057171 | -0.0445079490867478 | monthly | 3 | 5.41935483870968 | 0.0 | 5.67179479256777 | -0.252439953858087 | 5.41935483870968 | 0.0 | -0.772530996903288 | ||
21926 | 21926 | Gibraltar | Gibraltar | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 32677 | 24 | 0 | 25.1179483670858 | -1.11794836708582 | 24 | 0.0 | -3.42120870057172 | -0.0445079490867472 | monthly | 3 | 5.41935483870968 | 0.0 | 5.67179479256777 | -0.252439953858087 | 5.41935483870968 | 0.0 | -0.772530996903288 | ||
18458 | 18458 | Gibraltar | Gibraltar | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 32677 | 27 | 0 | 29.0867646640492 | -2.08676466404917 | 27 | 0.0 | -6.38603502172527 | -0.0717427561350052 | monthly | 2 | 6.51724137931034 | 0.0 | 7.02094319477049 | -0.503701815460144 | 6.51724137931034 | 0.0 | -1.54145672938196 | ||
21925 | 21925 | Gibraltar | Gibraltar | 0 | 2020-02-01 | 2020-02-29 | 29 | 2020 | 32677 | 27 | 0 | 29.0867646640492 | -2.08676466404917 | 27 | 0.0 | -6.38603502172528 | -0.0717427561350062 | monthly | 2 | 6.51724137931034 | 0.0 | 7.02094319477049 | -0.503701815460144 | 6.51724137931034 | 0.0 | -1.54145672938196 | ||
18457 | 18457 | Gibraltar | Gibraltar | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 32677 | 34 | 0 | 33.7649569725712 | 0.235043027428752 | 34 | 0.0 | 0.719291940596603 | 0.00696115287869858 | monthly | 1 | 7.67741935483871 | 0.0 | 7.62434512283867 | 0.0530742320000407 | 7.67741935483871 | 0.0 | 0.162420760779878 | ||
21924 | 21924 | Gibraltar | Gibraltar | 0 | 2020-01-01 | 2020-01-31 | 31 | 2020 | 32677 | 34 | 0 | 33.7649569725712 | 0.235043027428752 | 34 | 0.0 | 0.719291940596603 | 0.00696115287870014 | monthly | 1 | 7.67741935483871 | 0.0 | 7.62434512283867 | 0.0530742320000407 | 7.67741935483871 | 0.0 | 0.162420760779878 |
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);