economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
17 rows where covid_deaths = 297 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, days, year, population, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, month, total_deaths_per_7_days, covid_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, start_date (date), end_date (date)
country 9
- Belgium 2
- Greece 2
- Guatemala 2
- Hungary 2
- Kazakhstan 2
- Mexico 2
- Peru 2
- United States 2
- Indonesia 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16220 | 16220 | Peru | Peru | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 34049588 | 3219.2 | 297 | 3203.05948717868 | 16.1405128213182 | 2922.2 | 0.872257250219885 | 0.047402960709299 | 0.00503909243207246 | weekly | |||||||||
24848 | 24848 | Peru | Peru | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 34049588 | 3219.2 | 297 | 3203.05948717868 | 16.1405128213182 | 2922.2 | 0.872257250219885 | 0.0474029607092991 | 0.00503909243207201 | weekly | |||||||||
10561 | 10561 | Mexico | Mexico | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 127504120 | 14234 | 297 | 14435.6882022465 | -201.688202246451 | 13937 | 0.23293364951658 | -0.158181713850855 | -0.0139714989282648 | weekly | |||||||||
15469 | 15469 | Mexico | Mexico | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 127504120 | 14234 | 297 | 14435.6882022465 | -201.688202246451 | 13937 | 0.23293364951658 | -0.158181713850855 | -0.0139714989282681 | weekly | |||||||||
10361 | 10361 | Hungary | Hungary | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 9967304 | 2760 | 297 | 2583.03286516853 | 176.967134831469 | 2463 | 2.97974256629476 | 1.77547644610286 | 0.0685113756072639 | weekly | |||||||||
14120 | 14120 | Hungary | Hungary | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 9967304 | 2760 | 297 | 2583.03286516853 | 176.967134831469 | 2463 | 2.97974256629476 | 1.77547644610287 | 0.0685113756072646 | weekly | |||||||||
404 | 404 | Kazakhstan | Kazakhstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 19397998 | 13264 | 297 | 12240.9306622879 | 1023.06933771212 | 12967 | 1.53108583679615 | 5.2740975522944 | 0.0835777414264758 | monthly | 1 | 2995.09677419355 | 67.0645161290323 | 2764.08111729081 | 231.015656902736 | 2928.03225806452 | 0.345729059921711 | 1.1909252537439 | ||
22142 | 22142 | Kazakhstan | Kazakhstan | 0 | 2022-01-01 | 2022-01-31 | 31 | 2022 | 19397998 | 13264 | 297 | 12240.9306622879 | 1023.06933771212 | 12967 | 1.53108583679615 | 5.27409755229442 | 0.0835777414264745 | monthly | 1 | 2995.09677419355 | 67.0645161290323 | 2764.08111729081 | 231.015656902736 | 2928.03225806452 | 0.345729059921711 | 1.1909252537439 | ||
3898 | 3898 | United States | Georgia | GA | 2021-11-28 | 2021-12-04 | 7 | 2021 | 48 | 10617423 | 2017 | 297 | 1750.04511278247 | 266.954887217527 | 1720 | 2.79728894666813 | 2.51430961371255 | 0.152541717506404 | weekly | |||||||||
1907 | 1907 | Guatemala | Guatemala | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 17843914 | 2649 | 297 | 1690.72471910113 | 958.275280898874 | 2352 | 1.66443303862594 | 5.37031999200889 | 0.566783740766706 | weekly | |||||||||
13961 | 13961 | Guatemala | Guatemala | 0 | 2021-10-04 | 2021-10-10 | 7 | 2021 | 40 | 17843914 | 2649 | 297 | 1690.72471910113 | 958.275280898874 | 2352 | 1.66443303862594 | 5.37031999200889 | 0.566783740766702 | weekly | |||||||||
1707 | 1707 | Greece | Greece | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 10384972 | 2719 | 297 | 2119.97528089879 | 599.024719101213 | 2422 | 2.85990178885412 | 5.76818810008552 | 0.282562124425927 | weekly | |||||||||
13809 | 13809 | Greece | Greece | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 10384972 | 2719 | 297 | 2119.97528089879 | 599.024719101213 | 2422 | 2.85990178885412 | 5.76818810008552 | 0.282562124425925 | weekly | |||||||||
4343 | 4343 | United States | Illinois | IL | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 12671821 | 2289 | 297 | 1946.38596491282 | 342.61403508718 | 1992 | 2.34378310741605 | 2.70374743367334 | 0.17602574271672 | weekly | |||||||||
11530 | 11530 | Belgium | Belgium | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 11655923 | 2275 | 297 | 2459.96900749069 | -184.969007490688 | 1978 | 2.54806075846589 | -1.58690999838184 | -0.0751916007589741 | weekly | |||||||||
20354 | 20354 | Belgium | Belgium | 0 | 2021-02-01 | 2021-02-07 | 7 | 2021 | 5 | 11655923 | 2275 | 297 | 2459.96900749069 | -184.969007490688 | 1978 | 2.54806075846589 | -1.58690999838183 | -0.0751916007589732 | weekly | |||||||||
24911 | 24911 | Indonesia | Jakarta | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 10770000 | 4550 | 297 | 3023.63839451264 | 1526.36160548736 | 4253 | 2.75766016713092 | 14.1723454548501 | 0.504809572552534 | monthly | 4 | 1061.66666666667 | 69.3 | 705.515625386283 | 356.151041280383 | 992.366666666667 | 0.643454038997215 | 3.30688060613169 |
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);