economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
6 rows where country = "Kazakhstan" and month = 4 sorted by quarter
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, end_date, total_deaths, expected_deaths, excess_deaths, non_covid_deaths, excess_deaths_per_100k, excess_deaths_pct_change, 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, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
383 | 383 | Kazakhstan | Kazakhstan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 19397998 | 4441 | 23 | 11106.2498896481 | -6665.2498896481 | 4418 | 0.118568936856267 | -34.3605040563882 | -0.600135055115286 | monthly | 4 | 1036.23333333333 | 5.36666666666667 | 2591.45830758456 | -1555.22497425122 | 1030.86666666667 | 0.0276660852664624 | -8.01745094649057 | ||
395 | 395 | Kazakhstan | Kazakhstan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 19397998 | 13317 | 649 | 11129.0665195308 | 2187.9334804692 | 12668 | 3.3457060878138 | 11.2791715952811 | 0.196596316198624 | monthly | 4 | 3107.3 | 151.433333333333 | 2596.78218789052 | 510.51781210948 | 2955.86666666667 | 0.780664753823221 | 2.63180670556559 | ||
407 | 407 | Kazakhstan | Kazakhstan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 19397998 | 9578 | 2 | 11151.8831494135 | -1573.8831494135 | 9576 | 0.0103103423353276 | -8.11363703312836 | -0.141131603364789 | monthly | 4 | 2234.86666666667 | 0.466666666666667 | 2602.10606819648 | -367.239401529816 | 2234.4 | 0.00240574654490977 | -1.89318197439662 | ||
22121 | 22121 | Kazakhstan | Kazakhstan | 0 | 2020-04-01 | 2020-04-30 | 30 | 2020 | 19397998 | 4441 | 23 | 11106.2498896481 | -6665.2498896481 | 4418 | 0.118568936856267 | -34.3605040563882 | -0.600135055115286 | monthly | 4 | 1036.23333333333 | 5.36666666666667 | 2591.45830758456 | -1555.22497425122 | 1030.86666666667 | 0.0276660852664624 | -8.01745094649057 | ||
22133 | 22133 | Kazakhstan | Kazakhstan | 0 | 2021-04-01 | 2021-04-30 | 30 | 2021 | 19397998 | 13317 | 649 | 11129.0665195308 | 2187.9334804692 | 12668 | 3.3457060878138 | 11.2791715952811 | 0.196596316198624 | monthly | 4 | 3107.3 | 151.433333333333 | 2596.78218789052 | 510.51781210948 | 2955.86666666667 | 0.780664753823221 | 2.63180670556559 | ||
22145 | 22145 | Kazakhstan | Kazakhstan | 0 | 2022-04-01 | 2022-04-30 | 30 | 2022 | 19397998 | 9578 | 2 | 11151.8831494135 | -1573.8831494135 | 9576 | 0.0103103423353276 | -8.11363703312837 | -0.141131603364789 | monthly | 4 | 2234.86666666667 | 0.466666666666667 | 2602.10606819648 | -367.239401529816 | 2234.4 | 0.00240574654490977 | -1.89318197439662 |
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);