economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
6 rows where cadence = "monthly", country = "Japan" and month = 5 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, year, total_deaths, covid_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, total_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, start_date (date), end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329 | 329 | Japan | Japan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 123951696 | 121473 | 1052 | 114878.527931338 | 6594.47206866153 | 120421 | 0.848717713390545 | 5.32019510944129 | 0.0574038698737764 | monthly | 5 | 27429.3870967742 | 237.548387096774 | 25940.3127586893 | 1489.07433808486 | 27191.8387096774 | 0.191645935281736 | 1.20133437955126 | ||
22088 | 22088 | Japan | Japan | 0 | 2022-05-01 | 2022-05-31 | 31 | 2022 | 123951696 | 121473 | 1052 | 114878.527931338 | 6594.47206866153 | 120421 | 0.848717713390545 | 5.32019510944129 | 0.0574038698737807 | monthly | 5 | 27429.3870967742 | 237.548387096774 | 25940.3127586893 | 1489.07433808486 | 27191.8387096774 | 0.191645935281736 | 1.20133437955126 | ||
317 | 317 | Japan | Japan | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 123951696 | 118634 | 2816 | 113043.662345071 | 5590.33765492914 | 115818 | 2.27185273850549 | 4.51009371822483 | 0.0494529064164995 | monthly | 5 | 26788.3225806452 | 635.870967741935 | 25525.9882714676 | 1262.33430917755 | 26152.4516129032 | 0.512999005468982 | 1.01840825895399 | ||
22076 | 22076 | Japan | Japan | 0 | 2021-05-01 | 2021-05-31 | 31 | 2021 | 123951696 | 118634 | 2816 | 113043.662345071 | 5590.33765492914 | 115818 | 2.27185273850549 | 4.51009371822483 | 0.0494529064164979 | monthly | 5 | 26788.3225806452 | 635.870967741935 | 25525.9882714676 | 1262.33430917755 | 26152.4516129032 | 0.512999005468982 | 1.01840825895399 | ||
305 | 305 | Japan | Japan | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 123951696 | 108380 | 417 | 111208.796758803 | -2828.7967588028 | 107963 | 0.336421374984655 | -2.282176726975 | -0.0254368075300562 | monthly | 5 | 24472.9032258065 | 94.1612903225806 | 25111.6637842458 | -638.760558439341 | 24378.7419354839 | 0.0759661169320189 | -0.515330228671773 | ||
22064 | 22064 | Japan | Japan | 0 | 2020-05-01 | 2020-05-31 | 31 | 2020 | 123951696 | 108380 | 417 | 111208.796758803 | -2828.7967588028 | 107963 | 0.336421374984655 | -2.282176726975 | -0.0254368075300579 | monthly | 5 | 24472.9032258065 | 94.1612903225806 | 25111.6637842458 | -638.760558439341 | 24378.7419354839 | 0.0759661169320189 | -0.515330228671773 |
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);