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 = 3 sorted by region_code
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, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
303 | 303 | Japan | Japan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 123951696 | 119161 | 61 | 123276.796758803 | -4115.79675880283 | 119100 | 0.0492127191224556 | -3.32048442387011 | -0.0333866296579363 | monthly | 3 | 26907.3225806452 | 13.7741935483871 | 27836.6960423103 | -929.373461665154 | 26893.5483870968 | 0.0111125494792642 | -0.749786805390024 | ||
315 | 315 | Japan | Japan | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 123951696 | 123579 | 1279 | 125111.662345071 | -1532.66234507089 | 122300 | 1.03185356979706 | -1.23649969668094 | -0.0122503555331528 | monthly | 3 | 27904.935483871 | 288.806451612903 | 28251.0205295321 | -346.085045661168 | 27616.1290322581 | 0.232999193179981 | -0.279209608927955 | ||
327 | 327 | Japan | Japan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 123951696 | 139571 | 4454 | 126946.527931338 | 12624.4720686615 | 135117 | 3.59333526182651 | 10.1849934095791 | 0.0994471631038991 | monthly | 3 | 31516.0322580645 | 1005.74193548387 | 28665.3450167539 | 2850.68724131066 | 30510.2903225806 | 0.811398284928567 | 2.29983722151786 | ||
22062 | 22062 | Japan | Japan | 0 | 2020-03-01 | 2020-03-31 | 31 | 2020 | 123951696 | 119161 | 61 | 123276.796758803 | -4115.79675880283 | 119100 | 0.0492127191224556 | -3.32048442387011 | -0.0333866296579376 | monthly | 3 | 26907.3225806452 | 13.7741935483871 | 27836.6960423103 | -929.373461665154 | 26893.5483870968 | 0.0111125494792642 | -0.749786805390024 | ||
22074 | 22074 | Japan | Japan | 0 | 2021-03-01 | 2021-03-31 | 31 | 2021 | 123951696 | 123579 | 1279 | 125111.662345071 | -1532.66234507089 | 122300 | 1.03185356979706 | -1.23649969668095 | -0.0122503555331538 | monthly | 3 | 27904.935483871 | 288.806451612903 | 28251.0205295321 | -346.085045661168 | 27616.1290322581 | 0.232999193179981 | -0.279209608927955 | ||
22086 | 22086 | Japan | Japan | 0 | 2022-03-01 | 2022-03-31 | 31 | 2022 | 123951696 | 139571 | 4454 | 126946.527931338 | 12624.4720686615 | 135117 | 3.59333526182651 | 10.1849934095791 | 0.0994471631039033 | monthly | 3 | 31516.0322580645 | 1005.74193548387 | 28665.3450167539 | 2850.68724131066 | 30510.2903225806 | 0.811398284928567 | 2.29983722151786 |
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);