economist_excess_deaths

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

12 rows where cadence = "monthly" and non_covid_deaths = 42 sorted by end_date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: region, start_date, end_date, year, population, total_deaths, covid_deaths, expected_deaths, excess_deaths, excess_deaths_per_100k, excess_deaths_pct_change, 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, start_date (date)

cadence 1

  • monthly · 12 ✖
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
18265 18265 Monaco Monaco 0 2022-01-01 2022-01-31 31 2022   36491 51 9 46.2376039956218 4.76239600437822 42 24.6636156860596 13.0508783107567 0.102998330208226 monthly 1 11.5161290322581 2.03225806451613 10.440749289334 1.07537974292411 9.48387096774193 5.56920354201345 2.94697252178377  
22462 22462 Monaco Monaco 0 2022-01-01 2022-01-31 31 2022   36491 51 9 46.2376039956218 4.76239600437822 42 24.6636156860596 13.0508783107567 0.102998330208225 monthly 1 11.5161290322581 2.03225806451613 10.440749289334 1.07537974292411 9.48387096774193 5.56920354201345 2.94697252178377  
17981 17981 Faroe Islands Faroe Islands 0 2021-11-01 2021-11-30 30 2021   49085 42 0 31.9049514157413 10.0950485842587 42 0.0 20.5664634496459 0.31641009110824 monthly 11 9.8 0.0 7.44448866367298 2.35551133632703 9.8 0.0 4.79884147158404  
21858 21858 Faroe Islands Faroe Islands 0 2021-11-01 2021-11-30 30 2021   49085 42 0 31.9049514157413 10.0950485842587 42 0.0 20.5664634496459 0.316410091108241 monthly 11 9.8 0.0 7.44448866367298 2.35551133632703 9.8 0.0 4.79884147158404  
19523 19523 Saint Kitts and Nevis Saint Kitts and Nevis 0 2021-08-01 2021-08-31 31 2021   47681 42 0 29.6209031198693 12.3790968801307 42 0.0 25.962326461548 0.417917604673807 monthly 8 9.48387096774193 0.0 6.68859102706726 2.79527994067467 9.48387096774193 0.0 5.86246081389793  
22770 22770 Saint Kitts and Nevis Saint Kitts and Nevis 0 2021-08-01 2021-08-31 31 2021   47681 42 0 29.6209031198693 12.3790968801307 42 0.0 25.962326461548 0.417917604673808 monthly 8 9.48387096774193 0.0 6.68859102706726 2.79527994067467 9.48387096774193 0.0 5.86246081389793  
19928 19928 Bermuda Bermuda 0 2020-08-01 2020-08-31 31 2020   64207 42 0 44.2606595511773 -2.26065955117731 42 0.0 -3.52089266151247 -0.0510760475352469 monthly 8 9.48387096774193 0.0 9.9943424792981 -0.510471511556167 9.48387096774193 0.0 -0.795040278406042  
21592 21592 Bermuda Bermuda 0 2020-08-01 2020-08-31 31 2020   64207 42 0 44.2606595511773 -2.26065955117731 42 0.0 -3.52089266151247 -0.0510760475352466 monthly 8 9.48387096774193 0.0 9.9943424792981 -0.510471511556167 9.48387096774193 0.0 -0.795040278406042  
19079 19079 Antigua and Barbuda Antigua and Barbuda 0 2020-06-01 2020-06-30 30 2020   93772 42 0 50.6414225682854 -8.64142256828543 42 0.0 -9.21535486956173 -0.170639411968201 monthly 6 9.8 0.0 11.8163319325999 -2.01633193259993 9.8 0.0 -2.1502494695644  
21366 21366 Antigua and Barbuda Antigua and Barbuda 0 2020-06-01 2020-06-30 30 2020   93772 42 0 50.6414225682854 -8.64142256828543 42 0.0 -9.21535486956173 -0.170639411968201 monthly 6 9.8 0.0 11.8163319325999 -2.01633193259993 9.8 0.0 -2.1502494695644  
18244 18244 Monaco Monaco 0 2020-04-01 2020-04-30 30 2020   36491 45 3 39.0973789219065 5.9026210780935 42 8.22120522868653 16.1755530900592 0.150972296375249 monthly 4 10.5 0.7 9.12272174844485 1.37727825155515 9.8 1.91828122002686 3.77429572101381  
22441 22441 Monaco Monaco 0 2020-04-01 2020-04-30 30 2020   36491 45 3 39.0973789219065 5.9026210780935 42 8.22120522868653 16.1755530900592 0.15097229637525 monthly 4 10.5 0.7 9.12272174844485 1.37727825155515 9.8 1.91828122002686 3.77429572101381  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);