economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
4 rows where cadence = "monthly" and covid_deaths = 616 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, start_date, year, total_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, total_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, start_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
322 | 322 | Japan | Japan | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 123951696 | 120781 | 616 | 118251.862345071 | 2529.13765492915 | 120165 | 0.496967786548076 | 2.04042198416482 | 0.021387719438607 | monthly | 10 | 27273.1290322581 | 139.096774193548 | 26702.0334327579 | 571.09559950013 | 27134.0322580645 | 0.11221853244634 | 0.460740448037217 | ||
22081 | 22081 | Japan | Japan | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 123951696 | 120781 | 616 | 118251.862345071 | 2529.13765492915 | 120165 | 0.496967786548076 | 2.04042198416482 | 0.0213877194386056 | monthly | 10 | 27273.1290322581 | 139.096774193548 | 26702.0334327579 | 571.09559950013 | 27134.0322580645 | 0.11221853244634 | 0.460740448037217 | ||
10663 | 10663 | Egypt | Egypt | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 110990096 | 56515 | 616 | 49533.1459095056 | 6981.85409049439 | 55899 | 0.555004475354269 | 6.29051991314107 | 0.14095317311866 | monthly | 8 | 12761.4516129032 | 139.096774193548 | 11184.9039150497 | 1576.54769785357 | 12622.3548387097 | 0.125323591209029 | 1.42043998038669 | ||
21802 | 21802 | Egypt | Egypt | 0 | 2020-08-01 | 2020-08-31 | 31 | 2020 | 110990096 | 56515 | 616 | 49533.1459095056 | 6981.85409049439 | 55899 | 0.555004475354269 | 6.29051991314107 | 0.14095317311866 | monthly | 8 | 12761.4516129032 | 139.096774193548 | 11184.9039150497 | 1576.54769785357 | 12622.3548387097 | 0.125323591209029 | 1.42043998038669 |
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);