economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
22 rows where country = "Mexico" and covid_deaths = 0 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, week, total_deaths, excess_deaths, non_covid_deaths, excess_deaths_per_100k, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10440 | 10440 | Mexico | Mexico | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 127504120 | 14032 | 0 | 14661.0129213474 | -629.012921347354 | 14032 | 0.0 | -0.493327526473147 | -0.0429037833007753 | weekly | |||||||||
15348 | 15348 | Mexico | Mexico | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 127504120 | 14032 | 0 | 14661.0129213474 | -629.012921347354 | 14032 | 0.0 | -0.493327526473148 | -0.0429037833007783 | weekly | |||||||||
10439 | 10439 | Mexico | Mexico | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 127504120 | 14214 | 0 | 14941.0129213474 | -727.01292134735 | 14214 | 0.0 | -0.570187787929794 | -0.0486588777597945 | weekly | |||||||||
15347 | 15347 | Mexico | Mexico | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 127504120 | 14214 | 0 | 14941.0129213474 | -727.01292134735 | 14214 | 0.0 | -0.570187787929794 | -0.0486588777597976 | weekly | |||||||||
10438 | 10438 | Mexico | Mexico | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 127504120 | 14116 | 0 | 15307.0129213473 | -1191.01292134734 | 14116 | 0.0 | -0.934097597275556 | -0.077808317499121 | weekly | |||||||||
15346 | 15346 | Mexico | Mexico | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 127504120 | 14116 | 0 | 15307.0129213473 | -1191.01292134734 | 14116 | 0.0 | -0.934097597275555 | -0.0778083174991184 | weekly | |||||||||
10437 | 10437 | Mexico | Mexico | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 127504120 | 14687 | 0 | 15390.0107677892 | -703.010767789234 | 14687 | 0.0 | -0.551363177746126 | -0.045679680046788 | weekly | |||||||||
15345 | 15345 | Mexico | Mexico | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 127504120 | 14687 | 0 | 15390.0107677892 | -703.010767789234 | 14687 | 0.0 | -0.551363177746126 | -0.0456796800467858 | weekly | |||||||||
10436 | 10436 | Mexico | Mexico | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 127504120 | 15090 | 0 | 15691.8441011226 | -601.844101122566 | 15090 | 0.0 | -0.472019336412475 | -0.0383539434399244 | weekly | |||||||||
15344 | 15344 | Mexico | Mexico | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 127504120 | 15090 | 0 | 15691.8441011226 | -601.844101122566 | 15090 | 0.0 | -0.472019336412475 | -0.0383539434399265 | weekly | |||||||||
10435 | 10435 | Mexico | Mexico | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 127504120 | 15915 | 0 | 16072.1774344559 | -157.177434455891 | 15915 | 0.0 | -0.12327243578944 | -0.00977947357144837 | weekly | |||||||||
15343 | 15343 | Mexico | Mexico | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 127504120 | 15915 | 0 | 16072.1774344559 | -157.177434455891 | 15915 | 0.0 | -0.12327243578944 | -0.00977947357144893 | weekly | |||||||||
10434 | 10434 | Mexico | Mexico | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 127504120 | 15437 | 0 | 15981.5107677892 | -544.510767789239 | 15437 | 0.0 | -0.427053469165733 | -0.0340712949921294 | weekly | |||||||||
15342 | 15342 | Mexico | Mexico | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 127504120 | 15437 | 0 | 15981.5107677892 | -544.510767789239 | 15437 | 0.0 | -0.427053469165733 | -0.0340712949921269 | weekly | |||||||||
10433 | 10433 | Mexico | Mexico | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 127504120 | 15814 | 0 | 16083.1774344559 | -269.177434455894 | 15814 | 0.0 | -0.211112734597042 | -0.0167365830261389 | weekly | |||||||||
15341 | 15341 | Mexico | Mexico | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 127504120 | 15814 | 0 | 16083.1774344559 | -269.177434455894 | 15814 | 0.0 | -0.211112734597042 | -0.0167365830261392 | weekly | |||||||||
10432 | 10432 | Mexico | Mexico | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 127504120 | 16421 | 0 | 16423.1774344559 | -2.1774344558944 | 16421 | 0.0 | -0.00170773654678327 | -0.000132583019612609 | weekly | |||||||||
15340 | 15340 | Mexico | Mexico | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 127504120 | 16421 | 0 | 16423.1774344559 | -2.1774344558944 | 16421 | 0.0 | -0.00170773654678327 | -0.000132583019613053 | weekly | |||||||||
10431 | 10431 | Mexico | Mexico | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 127504120 | 16926 | 0 | 16643.0107677892 | 282.98923221077 | 16926 | 0.0 | 0.221945167113635 | 0.0170034879000658 | weekly | |||||||||
15339 | 15339 | Mexico | Mexico | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 127504120 | 16926 | 0 | 16643.0107677892 | 282.98923221077 | 16926 | 0.0 | 0.221945167113635 | 0.0170034879000676 | weekly | |||||||||
10430 | 10430 | Mexico | Mexico | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 127504120 | 16779 | 0 | 16753.8441011188 | 25.1558988812176 | 16779 | 0.0 | 0.0197294792366063 | 0.0015015001171903 | weekly | |||||||||
15338 | 15338 | Mexico | Mexico | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 127504120 | 16779 | 0 | 16753.8441011188 | 25.1558988812176 | 16779 | 0.0 | 0.0197294792366063 | 0.00150150011718919 | 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);