economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
6 rows where country = "Japan" and month = 4 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, year, total_deaths, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_per_100k, total_deaths_per_7_days, covid_deaths_per_7_days, expected_deaths_per_7_days, excess_deaths_per_7_days, covid_deaths_per_100k_per_7_days, excess_deaths_per_100k_per_7_days, end_date (date)
start_date (date) 3 ✖
- 2020-04-01 2
- 2021-04-01 2
- 2022-04-01 2
country 1
- Japan · 6 ✖
cadence 1
- monthly 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328 | 328 | Japan | Japan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 123951696 | 121799 | 1447 | 116946.181869037 | 4852.81813096278 | 120352 | 1.16739023885563 | 3.91508812510543 | 0.0414961656157122 | monthly | 4 | 28419.7666666667 | 337.633333333333 | 27287.4424361087 | 1132.32423055798 | 28082.1333333333 | 0.27239105573298 | 0.913520562524601 | ||
22087 | 22087 | Japan | Japan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 123951696 | 121799 | 1447 | 116946.181869037 | 4852.81813096278 | 120352 | 1.16739023885563 | 3.91508812510543 | 0.0414961656157142 | monthly | 4 | 28419.7666666667 | 337.633333333333 | 27287.4424361087 | 1132.32423055798 | 28082.1333333333 | 0.27239105573298 | 0.913520562524601 | ||
316 | 316 | Japan | Japan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 123951696 | 118169 | 1067 | 115170.50549523 | 2998.49450477015 | 117102 | 0.860819201699346 | 2.41908307956524 | 0.0260352639061252 | monthly | 4 | 27572.7666666667 | 248.966666666667 | 26873.117948887 | 699.648717779701 | 27323.8 | 0.200857813729847 | 0.564452718565223 | ||
22075 | 22075 | Japan | Japan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 123951696 | 118169 | 1067 | 115170.50549523 | 2998.49450477015 | 117102 | 0.860819201699346 | 2.41908307956524 | 0.0260352639061239 | monthly | 4 | 27572.7666666667 | 248.966666666667 | 26873.117948887 | 699.648717779701 | 27323.8 | 0.200857813729847 | 0.564452718565223 | ||
304 | 304 | Japan | Japan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 123951696 | 113362 | 414 | 113394.829121422 | -32.8291214220517 | 112948 | 0.334001077322895 | -0.0264854152718101 | -0.00028951162655666 | monthly | 4 | 26451.1333333333 | 96.6 | 26458.7934616651 | -7.66012833181206 | 26354.5333333333 | 0.0779335847086755 | -0.00617993023008903 | ||
22063 | 22063 | Japan | Japan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 123951696 | 113362 | 414 | 113394.829121422 | -32.8291214220517 | 112948 | 0.334001077322895 | -0.0264854152718102 | -0.000289511626556105 | monthly | 4 | 26451.1333333333 | 96.6 | 26458.7934616651 | -7.66012833181206 | 26354.5333333333 | 0.0779335847086755 | -0.00617993023008903 |
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);