economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
6 rows where country = "Spain" and week = 19 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, year, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, excess_deaths_per_100k, excess_deaths_pct_change, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17389 | 17389 | Spain | Spain | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 47558632 | 8819 | 575 | 7530.4078651685 | 1288.5921348315 | 8244 | 1.20903393520655 | 2.70948107765484 | 0.171118504854407 | weekly | |||||||||
18183 | 18183 | Spain | Spain | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 47558632 | 8819 | 575 | 7530.4078651685 | 1288.5921348315 | 8244 | 1.20903393520655 | 2.70948107765484 | 0.171118504854407 | weekly | |||||||||
17337 | 17337 | Spain | Spain | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 47558632 | 7738 | 547 | 7535.7662921348 | 202.233707865196 | 7191 | 1.15015923923127 | 0.425230288089859 | 0.0268365153622498 | weekly | |||||||||
18131 | 18131 | Spain | Spain | 0 | 2021-05-10 | 2021-05-16 | 7 | 2021 | 19 | 47558632 | 7738 | 547 | 7535.7662921348 | 202.233707865196 | 7191 | 1.15015923923127 | 0.42523028808986 | 0.0268365153622494 | weekly | |||||||||
17284 | 17284 | Spain | Spain | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 47558632 | 8458 | 1357 | 7541.1247191011 | 916.875280898896 | 7101 | 2.85332008708745 | 1.92788405036313 | 0.121583359916661 | weekly | |||||||||
18078 | 18078 | Spain | Spain | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 47558632 | 8458 | 1357 | 7541.1247191011 | 916.875280898896 | 7101 | 2.85332008708745 | 1.92788405036313 | 0.121583359916661 | 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);