economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where cadence = "monthly", country = "Greenland", covid_deaths_per_100k = "0.0" 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, expected_deaths, excess_deaths, non_covid_deaths, excess_deaths_per_100k, excess_deaths_pct_change, month, total_deaths_per_7_days, expected_deaths_per_7_days, excess_deaths_per_7_days, non_covid_deaths_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18240 | 18240 | Greenland | Greenland | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 56494 | 39 | 0 | 48.1216133740608 | -9.12161337406081 | 39 | 0.0 | -16.1461630864531 | -0.189553357306546 | monthly | 9 | 9.1 | 0.0 | 11.2283764539475 | -2.12837645394752 | 9.1 | 0.0 | -3.76743805350572 | ||
21969 | 21969 | Greenland | Greenland | 0 | 2022-09-01 | 2022-09-30 | 30 | 2022 | 56494 | 39 | 0 | 48.1216133740608 | -9.12161337406081 | 39 | 0.0 | -16.1461630864531 | -0.189553357306546 | monthly | 9 | 9.1 | 0.0 | 11.2283764539475 | -2.12837645394752 | 9.1 | 0.0 | -3.76743805350572 | ||
18237 | 18237 | Greenland | Greenland | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 56494 | 33 | 0 | 48.1216133740608 | -15.1216133740608 | 33 | 0.0 | -26.7667599639976 | -0.314237456182462 | monthly | 6 | 7.7 | 0.0 | 11.2283764539475 | -3.52837645394752 | 7.7 | 0.0 | -6.24557732493277 | ||
21966 | 21966 | Greenland | Greenland | 0 | 2022-06-01 | 2022-06-30 | 30 | 2022 | 56494 | 33 | 0 | 48.1216133740608 | -15.1216133740608 | 33 | 0.0 | -26.7667599639976 | -0.314237456182462 | monthly | 6 | 7.7 | 0.0 | 11.2283764539475 | -3.52837645394752 | 7.7 | 0.0 | -6.24557732493277 | ||
18235 | 18235 | Greenland | Greenland | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 56494 | 48 | 0 | 49.3216133740608 | -1.3216133740608 | 48 | 0.0 | -2.33938714564521 | -0.0267958260821181 | monthly | 4 | 11.2 | 0.0 | 11.5083764539475 | -0.308376453947521 | 11.2 | 0.0 | -0.545857000650548 | ||
21964 | 21964 | Greenland | Greenland | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 56494 | 48 | 0 | 49.3216133740608 | -1.3216133740608 | 48 | 0.0 | -2.3393871456452 | -0.0267958260821181 | monthly | 4 | 11.2 | 0.0 | 11.5083764539475 | -0.308376453947521 | 11.2 | 0.0 | -0.545857000650548 | ||
18230 | 18230 | Greenland | Greenland | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 56494 | 25 | 0 | 40.1372906992488 | -15.1372906992488 | 25 | 0.0 | -26.7945103891543 | -0.37713782957284 | monthly | 11 | 5.83333333333333 | 0.0 | 9.36536782982473 | -3.5320344964914 | 5.83333333333333 | 0.0 | -6.25205242413601 | ||
21959 | 21959 | Greenland | Greenland | 0 | 2021-11-01 | 2021-11-30 | 30 | 2021 | 56494 | 25 | 0 | 40.1372906992488 | -15.1372906992488 | 25 | 0.0 | -26.7945103891542 | -0.377137829572839 | monthly | 11 | 5.83333333333333 | 0.0 | 9.36536782982473 | -3.5320344964914 | 5.83333333333333 | 0.0 | -6.25205242413601 | ||
18228 | 18228 | Greenland | Greenland | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 56494 | 47 | 0 | 46.9372906992488 | 0.062709300751159 | 47 | 0.0 | 0.111001700625127 | 0.00133602301745461 | monthly | 9 | 10.9666666666667 | 0.0 | 10.9520344964914 | 0.0146321701752704 | 10.9666666666667 | 0.0 | 0.0259003968125295 | ||
21957 | 21957 | Greenland | Greenland | 0 | 2021-09-01 | 2021-09-30 | 30 | 2021 | 56494 | 47 | 0 | 46.9372906992488 | 0.062709300751159 | 47 | 0.0 | 0.111001700625127 | 0.00133602301745572 | monthly | 9 | 10.9666666666667 | 0.0 | 10.9520344964914 | 0.0146321701752704 | 10.9666666666667 | 0.0 | 0.0259003968125295 | ||
18225 | 18225 | Greenland | Greenland | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 56494 | 43 | 0 | 46.9372906992488 | -3.93729069924884 | 43 | 0.0 | -6.96939621773789 | -0.0838840640478606 | monthly | 6 | 10.0333333333333 | 0.0 | 10.9520344964914 | -0.918701163158063 | 10.0333333333333 | 0.0 | -1.62619245080551 | ||
21954 | 21954 | Greenland | Greenland | 0 | 2021-06-01 | 2021-06-30 | 30 | 2021 | 56494 | 43 | 0 | 46.9372906992488 | -3.93729069924884 | 43 | 0.0 | -6.96939621773788 | -0.0838840640478598 | monthly | 6 | 10.0333333333333 | 0.0 | 10.9520344964914 | -0.918701163158063 | 10.0333333333333 | 0.0 | -1.62619245080551 | ||
18223 | 18223 | Greenland | Greenland | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 56494 | 47 | 0 | 48.1372906992488 | -1.13729069924884 | 47 | 0.0 | -2.01311767488377 | -0.0236259806633983 | monthly | 4 | 10.9666666666667 | 0.0 | 11.2320344964914 | -0.265367829824729 | 10.9666666666667 | 0.0 | -0.46972745747288 | ||
21952 | 21952 | Greenland | Greenland | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 56494 | 47 | 0 | 48.1372906992488 | -1.13729069924884 | 47 | 0.0 | -2.01311767488378 | -0.0236259806633976 | monthly | 4 | 10.9666666666667 | 0.0 | 11.2320344964914 | -0.265367829824729 | 10.9666666666667 | 0.0 | -0.46972745747288 | ||
18218 | 18218 | Greenland | Greenland | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 56494 | 47 | 0 | 38.9529680244365 | 8.04703197556355 | 47 | 0.0 | 14.2440471121952 | 0.206583281934136 | monthly | 11 | 10.9666666666667 | 0.0 | 9.08902587236851 | 1.87764079429816 | 10.9666666666667 | 0.0 | 3.32361099284554 | ||
21947 | 21947 | Greenland | Greenland | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 56494 | 47 | 0 | 38.9529680244365 | 8.04703197556355 | 47 | 0.0 | 14.2440471121952 | 0.206583281934135 | monthly | 11 | 10.9666666666667 | 0.0 | 9.08902587236851 | 1.87764079429816 | 10.9666666666667 | 0.0 | 3.32361099284554 | ||
18216 | 18216 | Greenland | Greenland | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 56494 | 55 | 0 | 45.7529680244364 | 9.24703197556355 | 55 | 0.0 | 16.3681664877041 | 0.202107805784856 | monthly | 9 | 12.8333333333333 | 0.0 | 10.6756925390352 | 2.15764079429816 | 12.8333333333333 | 0.0 | 3.81923884713096 | ||
21945 | 21945 | Greenland | Greenland | 0 | 2020-09-01 | 2020-09-30 | 30 | 2020 | 56494 | 55 | 0 | 45.7529680244364 | 9.24703197556355 | 55 | 0.0 | 16.3681664877041 | 0.202107805784858 | monthly | 9 | 12.8333333333333 | 0.0 | 10.6756925390352 | 2.15764079429816 | 12.8333333333333 | 0.0 | 3.81923884713096 | ||
18213 | 18213 | Greenland | Greenland | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 56494 | 49 | 0 | 45.7529680244364 | 3.24703197556355 | 49 | 0.0 | 5.74756961015958 | 0.0709687724265085 | monthly | 6 | 11.4333333333333 | 0.0 | 10.6756925390352 | 0.757640794298162 | 11.4333333333333 | 0.0 | 1.3410995757039 | ||
21942 | 21942 | Greenland | Greenland | 0 | 2020-06-01 | 2020-06-30 | 30 | 2020 | 56494 | 49 | 0 | 45.7529680244364 | 3.24703197556355 | 49 | 0.0 | 5.74756961015957 | 0.0709687724265098 | monthly | 6 | 11.4333333333333 | 0.0 | 10.6756925390352 | 0.757640794298162 | 11.4333333333333 | 0.0 | 1.3410995757039 | ||
18211 | 18211 | Greenland | Greenland | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 56494 | 29 | 0 | 46.9529680244364 | -17.9529680244364 | 29 | 0.0 | -31.7785393571644 | -0.382360663868851 | monthly | 4 | 6.76666666666667 | 0.0 | 10.9556925390352 | -4.1890258723685 | 6.76666666666667 | 0.0 | -7.41499251667169 | ||
21940 | 21940 | Greenland | Greenland | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 56494 | 29 | 0 | 46.9529680244364 | -17.9529680244364 | 29 | 0.0 | -31.7785393571643 | -0.38236066386885 | monthly | 4 | 6.76666666666667 | 0.0 | 10.9556925390352 | -4.1890258723685 | 6.76666666666667 | 0.0 | -7.41499251667169 |
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);