economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
4 rows where cadence = "monthly" and covid_deaths = 1171 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, start_date, end_date, days, year, population, total_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, month, total_deaths_per_7_days, covid_deaths_per_7_days, expected_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)
country 2
cadence 1
- monthly · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
401 | 401 | Kazakhstan | Kazakhstan | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 19397998 | 16002 | 1171 | 11120.7087368485 | 4881.2912631515 | 14831 | 6.03670543733431 | 25.1638919807678 | 0.438937065852407 | monthly | 10 | 3613.35483870968 | 264.41935483871 | 2511.12777928837 | 1102.22705942131 | 3348.93548387097 | 1.36312703423678 | 5.68216915694757 | ||
22139 | 22139 | Kazakhstan | Kazakhstan | 0 | 2021-10-01 | 2021-10-31 | 31 | 2021 | 19397998 | 16002 | 1171 | 11120.7087368485 | 4881.2912631515 | 14831 | 6.03670543733431 | 25.1638919807678 | 0.438937065852406 | monthly | 10 | 3613.35483870968 | 264.41935483871 | 2511.12777928837 | 1102.22705942131 | 3348.93548387097 | 1.36312703423678 | 5.68216915694757 | ||
19484 | 19484 | Philippines | Philippines | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 115559008 | 51558 | 1171 | 51575.4114033226 | -17.4114033226215 | 50387 | 1.01333510928027 | -0.0150671104087545 | -0.000337591166970297 | monthly | 11 | 12030.2 | 273.233333333333 | 12034.2626607753 | -4.06266077527835 | 11756.9666666667 | 0.236444858832064 | -0.00351565909537606 | ||
22663 | 22663 | Philippines | Philippines | 0 | 2020-11-01 | 2020-11-30 | 30 | 2020 | 115559008 | 51558 | 1171 | 51575.4114033226 | -17.4114033226215 | 50387 | 1.01333510928027 | -0.0150671104087545 | -0.000337591166969853 | monthly | 11 | 12030.2 | 273.233333333333 | 12034.2626607753 | -4.06266077527835 | 11756.9666666667 | 0.236444858832064 | -0.00351565909537606 |
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);