economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
6 rows where country = "Latvia" and week = 26 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, year, total_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, excess_deaths_pct_change, end_date (date)
start_date (date) 3 ✖
- 2020-06-22 2
- 2021-06-28 2
- 2022-06-27 2
country 1
- Latvia · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1573 | 1573 | Latvia | Latvia | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 1850654 | 600 | 5 | 480.411797752817 | 119.588202247183 | 595 | 0.270174759841656 | 6.46194276440562 | 0.248928529246307 | weekly | |||||||||
14871 | 14871 | Latvia | Latvia | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 1850654 | 600 | 5 | 480.411797752817 | 119.588202247183 | 595 | 0.270174759841656 | 6.46194276440561 | 0.248928529246307 | weekly | |||||||||
1521 | 1521 | Latvia | Latvia | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 1850654 | 618 | 25 | 484.249438202255 | 133.750561797745 | 593 | 1.35087379920828 | 7.22720518247846 | 0.27620179032997 | weekly | |||||||||
14819 | 14819 | Latvia | Latvia | 0 | 2021-06-28 | 2021-07-04 | 7 | 2021 | 26 | 1850654 | 618 | 25 | 484.249438202255 | 133.750561797745 | 593 | 1.35087379920828 | 7.22720518247846 | 0.27620179032997 | weekly | |||||||||
1468 | 1468 | Latvia | Latvia | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 1850654 | 560 | 0 | 488.087078651695 | 71.9129213483049 | 560 | 0.0 | 3.88581125095803 | 0.147336253086148 | weekly | |||||||||
14766 | 14766 | Latvia | Latvia | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 1850654 | 560 | 0 | 488.087078651695 | 71.9129213483049 | 560 | 0.0 | 3.88581125095803 | 0.147336253086149 | 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);