economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
30 rows where total_deaths = 87 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, days, year, week, population, covid_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_pct_change, month, 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 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9257 | 9257 | United States | Vermont | VT | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 623989 | 87 | 0 | 97.496240602328 | -10.496240602328 | 87 | 0.0 | -1.68211949286413 | -0.107657900832715 | weekly | |||||||||
15322 | 15322 | Malta | Malta | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 533293 | 87 | 11 | 66.2567415730282 | 20.7432584269718 | 76 | 2.06265598835912 | 3.88965511022492 | 0.313073929301346 | weekly | |||||||||
21283 | 21283 | Malta | Malta | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 533293 | 87 | 11 | 66.2567415730282 | 20.7432584269718 | 76 | 2.06265598835912 | 3.88965511022492 | 0.313073929301346 | weekly | |||||||||
15312 | 15312 | Malta | Malta | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 533293 | 87 | 10 | 67.6567415730283 | 19.3432584269717 | 77 | 1.8751418075992 | 3.62713525716102 | 0.285902897142818 | weekly | |||||||||
21273 | 21273 | Malta | Malta | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 533293 | 87 | 10 | 67.6567415730283 | 19.3432584269717 | 77 | 1.8751418075992 | 3.62713525716102 | 0.285902897142818 | weekly | |||||||||
15285 | 15285 | Malta | Malta | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 533293 | 87 | 0 | 69.0853932584215 | 17.9146067415785 | 87 | 0.0 | 3.35924280678323 | 0.259311062681035 | weekly | |||||||||
21246 | 21246 | Malta | Malta | 0 | 2021-10-18 | 2021-10-24 | 7 | 2021 | 42 | 533293 | 87 | 0 | 69.0853932584215 | 17.9146067415785 | 87 | 0.0 | 3.35924280678324 | 0.259311062681036 | weekly | |||||||||
1372 | 1372 | Luxembourg | Luxembourg | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 647601 | 87 | 0 | 74.6651685393229 | 12.3348314606771 | 87 | 0.0 | 1.90469617259347 | 0.165201950279947 | weekly | |||||||||
15120 | 15120 | Luxembourg | Luxembourg | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 647601 | 87 | 0 | 74.6651685393229 | 12.3348314606771 | 87 | 0.0 | 1.90469617259348 | 0.165201950279947 | weekly | |||||||||
1807 | 1807 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 103959 | 87 | 1 | 82.5185550082099 | 4.4814449917901 | 86 | 0.961917679085024 | 4.31078116544994 | 0.0543083309122927 | monthly | 5 | 19.6451612903226 | 0.225806451612903 | 18.633222098628 | 1.01193919169454 | 19.4193548387097 | 0.217207217857909 | 0.973402198649986 | ||
22799 | 22799 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 103959 | 87 | 1 | 82.5185550082099 | 4.4814449917901 | 86 | 0.961917679085024 | 4.31078116544994 | 0.0543083309122927 | monthly | 5 | 19.6451612903226 | 0.225806451612903 | 18.633222098628 | 1.01193919169454 | 19.4193548387097 | 0.217207217857909 | 0.973402198649986 | ||
1354 | 1354 | Luxembourg | Luxembourg | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 647601 | 87 | 15 | 94.6320224719069 | -7.63202247190691 | 72 | 2.31624101877545 | -1.17850690037645 | -0.0806494701534314 | weekly | |||||||||
15102 | 15102 | Luxembourg | Luxembourg | 0 | 2021-02-22 | 2021-02-28 | 7 | 2021 | 8 | 647601 | 87 | 15 | 94.6320224719069 | -7.63202247190691 | 72 | 2.31624101877545 | -1.17850690037645 | -0.0806494701534313 | weekly | |||||||||
21444 | 21444 | Aruba | Aruba | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 106459 | 87 | 14 | 56.5168990236061 | 30.4831009763939 | 73 | 13.1506025793968 | 28.6336533091555 | 0.539362588942851 | monthly | 2 | 21.75 | 3.5 | 14.1292247559015 | 7.62077524409849 | 18.25 | 3.28765064484919 | 7.1584133272889 | ||
24516 | 24516 | Aruba | Aruba | 0 | 2021-02-01 | 2021-02-28 | 28 | 2021 | 106459 | 87 | 14 | 56.5168990236061 | 30.4831009763939 | 73 | 13.1506025793968 | 28.6336533091556 | 0.539362588942853 | monthly | 2 | 21.75 | 3.5 | 14.1292247559015 | 7.62077524409849 | 18.25 | 3.28765064484919 | 7.1584133272889 | ||
2487 | 2487 | United States | Alaska | AK | 2021-01-31 | 2021-02-06 | 7 | 2021 | 5 | 731545 | 87 | 3 | 94.5939849657149 | -7.59398496571488 | 84 | 0.410090971847255 | -1.03807489159449 | -0.0802797870125387 | weekly | |||||||||
1335 | 1335 | Luxembourg | Luxembourg | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 647601 | 87 | 1 | 79.198876404491 | 7.80112359550895 | 86 | 0.154416067918363 | 1.20461883096366 | 0.0985004327039491 | weekly | |||||||||
15083 | 15083 | Luxembourg | Luxembourg | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 647601 | 87 | 1 | 79.198876404491 | 7.80112359550895 | 86 | 0.154416067918363 | 1.20461883096366 | 0.0985004327039498 | weekly | |||||||||
1331 | 1331 | Luxembourg | Luxembourg | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 647601 | 87 | 0 | 71.798876404491 | 15.201123595509 | 87 | 0.0 | 2.34729773355955 | 0.211718126476951 | weekly | |||||||||
15079 | 15079 | Luxembourg | Luxembourg | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 647601 | 87 | 0 | 71.798876404491 | 15.201123595509 | 87 | 0.0 | 2.34729773355955 | 0.211718126476951 | weekly | |||||||||
2466 | 2466 | United States | Alaska | AK | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 731545 | 87 | 2 | 84.7418546394615 | 2.25814536053852 | 85 | 0.273393981231503 | 0.308681675158537 | 0.0266473441034056 | weekly | |||||||||
1312 | 1312 | Luxembourg | Luxembourg | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 647601 | 87 | 5 | 74.798876404491 | 12.201123595509 | 82 | 0.772080339591817 | 1.88404952980446 | 0.163119075873931 | weekly | |||||||||
15060 | 15060 | Luxembourg | Luxembourg | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 647601 | 87 | 5 | 74.798876404491 | 12.201123595509 | 82 | 0.772080339591817 | 1.88404952980446 | 0.163119075873932 | weekly | |||||||||
2447 | 2447 | United States | Alaska | AK | 2020-04-26 | 2020-05-02 | 7 | 2020 | 18 | 731545 | 87 | 0 | 93.7418546394012 | -6.74185463940121 | 87 | 0.0 | -0.921591240374989 | -0.0719193647846551 | weekly | |||||||||
1794 | 1794 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 103959 | 87 | 0 | 82.9795963769261 | 4.0204036230739 | 87 | 0.0 | 3.86729732209227 | 0.0484505083010003 | monthly | 4 | 20.3 | 0.0 | 19.3619058212828 | 0.938094178717244 | 20.3 | 0.0 | 0.902369375154863 | ||
22786 | 22786 | Saint Vincent and the Grenadines | Saint Vincent and the Grenadines | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 103959 | 87 | 0 | 82.9795963769261 | 4.0204036230739 | 87 | 0.0 | 3.86729732209227 | 0.0484505083010003 | monthly | 4 | 20.3 | 0.0 | 19.3619058212828 | 0.938094178717244 | 20.3 | 0.0 | 0.902369375154863 | ||
1305 | 1305 | Luxembourg | Luxembourg | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 647601 | 87 | 7 | 90.3988764044911 | -3.39887640449115 | 80 | 1.08091247542854 | -0.524841129722028 | -0.0375986576346682 | weekly | |||||||||
15053 | 15053 | Luxembourg | Luxembourg | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 647601 | 87 | 7 | 90.3988764044911 | -3.39887640449115 | 80 | 1.08091247542854 | -0.524841129722028 | -0.0375986576346677 | weekly | |||||||||
1304 | 1304 | Luxembourg | Luxembourg | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 647601 | 87 | 1 | 85.9988764044911 | 1.00112359550894 | 86 | 0.154416067918363 | 0.154589569118785 | 0.0116411241328342 | weekly | |||||||||
15052 | 15052 | Luxembourg | Luxembourg | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 647601 | 87 | 1 | 85.9988764044911 | 1.00112359550894 | 86 | 0.154416067918363 | 0.154589569118785 | 0.0116411241328336 | weekly |
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);