economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
6 rows where country = "Philippines" and month = 4 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, covid_deaths, expected_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_pct_change, 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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19501 | 19501 | Philippines | Philippines | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 115559008 | 50159 | 1092 | 52093.0856722048 | -1934.08567220483 | 49067 | 0.944971767151203 | -1.67367798121357 | -0.0371274929723887 | monthly | 4 | 11703.7666666667 | 254.8 | 12155.0533235145 | -451.286656847793 | 11448.9666666667 | 0.220493412335281 | -0.390524862283166 | ||
22680 | 22680 | Philippines | Philippines | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 115559008 | 50159 | 1092 | 52093.0856722048 | -1934.08567220483 | 49067 | 0.944971767151203 | -1.67367798121357 | -0.0371274929723882 | monthly | 4 | 11703.7666666667 | 254.8 | 12155.0533235145 | -451.286656847793 | 11448.9666666667 | 0.220493412335281 | -0.390524862283166 | ||
19489 | 19489 | Philippines | Philippines | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 115559008 | 70556 | 3937 | 51126.1485377637 | 19429.8514622363 | 66619 | 3.40691744255887 | 16.8137921902517 | 0.380037456721088 | monthly | 4 | 16463.0666666667 | 918.633333333333 | 11929.4346588115 | 4533.63200785513 | 15544.4333333333 | 0.794947403263736 | 3.92321817772538 | ||
22668 | 22668 | Philippines | Philippines | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 115559008 | 70556 | 3937 | 51126.1485377637 | 19429.8514622363 | 66619 | 3.40691744255887 | 16.8137921902517 | 0.380037456721088 | monthly | 4 | 16463.0666666667 | 918.633333333333 | 11929.4346588115 | 4533.63200785513 | 15544.4333333333 | 0.794947403263736 | 3.92321817772538 | ||
19477 | 19477 | Philippines | Philippines | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 115559008 | 44768 | 480 | 50159.2114033226 | -5391.21140332262 | 44288 | 0.415372205341188 | -4.66533202095558 | -0.107481980926149 | monthly | 4 | 10445.8666666667 | 112.0 | 11703.8159941086 | -1257.94932744194 | 10333.8666666667 | 0.0969201812462772 | -1.0885774715563 | ||
22656 | 22656 | Philippines | Philippines | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 115559008 | 44768 | 480 | 50159.2114033226 | -5391.21140332262 | 44288 | 0.415372205341188 | -4.66533202095558 | -0.107481980926149 | monthly | 4 | 10445.8666666667 | 112.0 | 11703.8159941086 | -1257.94932744194 | 10333.8666666667 | 0.0969201812462772 | -1.0885774715563 |
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);