economist_excess_deaths

⚠️ 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

40 rows where country = "Germany"

View and edit SQL

Suggested facets: start_date, end_date, total_deaths, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, week, start_date (date), end_date (date)

country

  • Germany · 40

cadence

Link rowid ▼ country region region_code start_date end_date year month 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 week
2298 Germany Germany 0 2020-01-01 2020-01-07 2020   83149300 19023 0 19261.25 -238.25 19023 0.0 -0.28653277898912 -0.0123693945097021 weekly 1
2299 Germany Germany 0 2020-01-08 2020-01-14 2020   83149300 19530 0 19617.0 -87.0 19530 0.0 -0.104631067248912 -0.00443492888820918 weekly 2
2300 Germany Germany 0 2020-01-15 2020-01-21 2020   83149300 18888 0 19458.25 -570.25 18888 0.0 -0.685814552858533 -0.0293063353590379 weekly 3
2301 Germany Germany 0 2020-01-22 2020-01-28 2020   83149300 19279 0 19908.75 -629.75 19279 0.0 -0.757372581609226 -0.0316318201795693 weekly 4
2302 Germany Germany 0 2020-01-29 2020-02-04 2020   83149300 19665 0 20281.75 -616.75 19665 0.0 -0.741738054319158 -0.0304091116397747 weekly 5
2303 Germany Germany 0 2020-02-05 2020-02-11 2020   83149300 19004 0 20379.75 -1375.75 19004 0.0 -1.65455391687002 -0.067505734859358 weekly 6
2304 Germany Germany 0 2020-02-12 2020-02-18 2020   83149300 19352 0 20669.25 -1317.25 19352 0.0 -1.58419854406471 -0.0637299369836835 weekly 7
2305 Germany Germany 0 2020-02-19 2020-02-25 2020   83149300 18978 0 21054.25 -2076.25 18978 0.0 -2.49701440661557 -0.0986142940261467 weekly 8
2306 Germany Germany 0 2020-02-26 2020-03-03 2020   83149300 19558 0 21488.75 -1930.75 19558 0.0 -2.32202796656135 -0.0898493397708103 weekly 9
2307 Germany Germany 0 2020-03-04 2020-03-10 2020   83149300 19566 2 21323.75 -1757.75 19564 0.0024053118907796 -2.11396848800892 -0.0824315610528167 weekly 10
2308 Germany Germany 0 2020-03-11 2020-03-17 2020   83149300 19784 11 20400.0 -616.0 19773 0.0132292153992878 -0.740836062360116 -0.0301960784313725 weekly 11
2309 Germany Germany 0 2020-03-18 2020-03-24 2020   83149300 19241 136 19704.75 -463.75 19105 0.163561208573013 -0.557731694674519 -0.0235349344701151 weekly 12
2310 Germany Germany 0 2020-03-25 2020-03-31 2020   83149300 20004 583 18845.75 1158.25 19421 0.701148416162253 1.39297624874773 0.0614594802541688 weekly 13
2311 Germany Germany 0 2020-04-01 2020-04-07 2020   83149300 20746 1129 18594.0 2152.0 19617 1.35779856234508 2.58811559447885 0.115736259008282 weekly 14
2312 Germany Germany 0 2020-04-08 2020-04-14 2020   83149300 19671 1393 17963.75 1707.25 18278 1.67529973192799 2.05323436276673 0.0950386194419317 weekly 15
2313 Germany Germany 0 2020-04-15 2020-04-21 2020   83149300 19065 1625 17317.75 1747.25 17440 1.95431591125842 2.10134060058233 0.100893591834967 weekly 16
2314 Germany Germany 0 2020-04-22 2020-04-28 2020   83149300 18141 1236 17368.5 772.5 16905 1.48648274850179 0.92905171781362 0.0444770705587703 weekly 17
2315 Germany Germany 0 2020-04-29 2020-05-05 2020   83149300 17476 881 16963.5 512.5 16595 1.05953988788841 0.616361172012272 0.0302119256049753 weekly 18
2316 Germany Germany 0 2020-05-06 2020-05-12 2020   83149300 17181 638 17316.0 -135.0 16543 0.767294493158692 -0.162358552627623 -0.00779625779625781 weekly 19
2317 Germany Germany 0 2020-05-13 2020-05-19 2020   83149300 16654 456 16967.5 -313.5 16198 0.548411111097748 -0.377032638879702 -0.0184764991896272 weekly 20
6780 Germany Germany 0 2020-01-01 2020-01-07 2020   83149300 19023 0 19261.25 -238.25 19023       weekly 1
6781 Germany Germany 0 2020-01-08 2020-01-14 2020   83149300 19530 0 19617.0 -87.0 19530       weekly 2
6782 Germany Germany 0 2020-01-15 2020-01-21 2020   83149300 18888 0 19458.25 -570.25 18888       weekly 3
6783 Germany Germany 0 2020-01-22 2020-01-28 2020   83149300 19279 0 19908.75 -629.75 19279       weekly 4
6784 Germany Germany 0 2020-01-29 2020-02-04 2020   83149300 19665 0 20281.75 -616.75 19665       weekly 5
6785 Germany Germany 0 2020-02-05 2020-02-11 2020   83149300 19004 0 20379.75 -1375.75 19004       weekly 6
6786 Germany Germany 0 2020-02-12 2020-02-18 2020   83149300 19352 0 20669.25 -1317.25 19352       weekly 7
6787 Germany Germany 0 2020-02-19 2020-02-25 2020   83149300 18978 0 21054.25 -2076.25 18978       weekly 8
6788 Germany Germany 0 2020-02-26 2020-03-03 2020   83149300 19558 0 21488.75 -1930.75 19558       weekly 9
6789 Germany Germany 0 2020-03-04 2020-03-10 2020   83149300 19566 2 21323.75 -1757.75 19564       weekly 10
6790 Germany Germany 0 2020-03-11 2020-03-17 2020   83149300 19784 11 20400.0 -616.0 19773       weekly 11
6791 Germany Germany 0 2020-03-18 2020-03-24 2020   83149300 19241 136 19704.75 -463.75 19105       weekly 12
6792 Germany Germany 0 2020-03-25 2020-03-31 2020   83149300 20004 583 18845.75 1158.25 19421       weekly 13
6793 Germany Germany 0 2020-04-01 2020-04-07 2020   83149300 20746 1129 18594.0 2152.0 19617       weekly 14
6794 Germany Germany 0 2020-04-08 2020-04-14 2020   83149300 19671 1393 17963.75 1707.25 18278       weekly 15
6795 Germany Germany 0 2020-04-15 2020-04-21 2020   83149300 19065 1625 17317.75 1747.25 17440       weekly 16
6796 Germany Germany 0 2020-04-22 2020-04-28 2020   83149300 18141 1236 17368.5 772.5 16905       weekly 17
6797 Germany Germany 0 2020-04-29 2020-05-05 2020   83149300 17476 881 16963.5 512.5 16595       weekly 18
6798 Germany Germany 0 2020-05-06 2020-05-12 2020   83149300 17181 638 17316.0 -135.0 16543       weekly 19
6799 Germany Germany 0 2020-05-13 2020-05-19 2020   83149300 16654 456 16967.5 -313.5 16198       weekly 20

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_excess_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [month] 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
, [week] INTEGER);
Powered by Datasette · Query took 110.914ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette