economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
6 rows where country = "New Zealand" and week = 17 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, total_deaths, covid_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, end_date (date)
start_date (date) 3 ✖
- 2020-04-20 2
- 2021-04-26 2
- 2022-04-25 2
country 1
- New Zealand · 6 ✖
cadence 1
- weekly 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15897 | 15897 | New Zealand | New Zealand | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 5185289 | 712 | 61 | 668.812078651666 | 43.1879213483345 | 651 | 1.17640501811953 | 0.832893236005447 | 0.0645740750307642 | weekly | |||||||||
20228 | 20228 | New Zealand | New Zealand | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 5185289 | 712 | 61 | 668.812078651666 | 43.1879213483345 | 651 | 1.17640501811953 | 0.832893236005447 | 0.0645740750307648 | weekly | |||||||||
15845 | 15845 | New Zealand | New Zealand | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 5185289 | 687 | 0 | 656.169662921322 | 30.8303370786781 | 687 | 0.0 | 0.594573168027435 | 0.0469853131298676 | weekly | |||||||||
20176 | 20176 | New Zealand | New Zealand | 0 | 2021-04-26 | 2021-05-02 | 7 | 2021 | 17 | 5185289 | 687 | 0 | 656.169662921322 | 30.8303370786781 | 687 | 0.0 | 0.594573168027435 | 0.0469853131298679 | weekly | |||||||||
15792 | 15792 | New Zealand | New Zealand | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 5185289 | 633 | 2 | 643.527247190978 | -10.5272471909783 | 631 | 0.0385706563317879 | -0.203021416761502 | -0.016358665832612 | weekly | |||||||||
20123 | 20123 | New Zealand | New Zealand | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 5185289 | 633 | 2 | 643.527247190978 | -10.5272471909783 | 631 | 0.0385706563317879 | -0.203021416761502 | -0.0163586658326126 | 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);