economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
7 rows where cadence = "weekly" and total_deaths = 2883 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, end_date, week, population, covid_deaths, expected_deaths, excess_deaths, covid_deaths_per_100k, excess_deaths_per_100k, start_date (date)
country 3
- United States 3
- Chile 2
- Czech Republic 2
cadence 1
- weekly · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12191 | 12191 | Chile | Chile | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 19603736 | 2883 | 173 | 2612.31065573779 | 270.689344262215 | 2710 | 0.88248484880637 | 1.38080488465166 | 0.103620656168001 | weekly | |||||||||
19849 | 19849 | Chile | Chile | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 19603736 | 2883 | 173 | 2612.31065573779 | 270.689344262215 | 2710 | 0.88248484880637 | 1.38080488465165 | 0.103620656168003 | weekly | |||||||||
8166 | 8166 | United States | Pennsylvania | PA | 2022-02-20 | 2022-02-26 | 7 | 2022 | 8 | 12801989 | 2883 | 517 | 2715.75000000114 | 167.24999999886 | 2366 | 4.03843496506676 | 1.30643761683329 | 0.06158519745882 | weekly | |||||||||
7709 | 7709 | United States | Ohio | OH | 2022-02-13 | 2022-02-19 | 7 | 2022 | 7 | 11689100 | 2883 | 488 | 2445.01315789707 | 437.986842102928 | 2395 | 4.174829542052 | 3.74696804803559 | 0.179134758718287 | weekly | |||||||||
10127 | 10127 | Czech Republic | Czech Republic | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 10493990 | 2883 | 459 | 2075.97415730336 | 807.025842696638 | 2424 | 4.373932126865 | 7.69036222348828 | 0.388745611238699 | weekly | |||||||||
12760 | 12760 | Czech Republic | Czech Republic | 0 | 2021-11-08 | 2021-11-14 | 7 | 2021 | 45 | 10493990 | 2883 | 459 | 2075.97415730336 | 807.025842696638 | 2424 | 4.373932126865 | 7.69036222348828 | 0.3887456112387 | weekly | |||||||||
7168 | 7168 | United States | New York | NY | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 19453561 | 2883 | 750 | 2852.89974937426 | 30.1002506257369 | 2133 | 3.85533527769029 | 0.15472874413963 | 0.010550756517939 | weekly |
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);