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

48 rows where country = "Portugal"

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

  • Portugal · 48

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
1170 Portugal Portugal 0 2020-01-01 2020-01-07 2020   10276617 2574 0 2859.4 -285.4 2574       weekly 1
1171 Portugal Portugal 0 2020-01-08 2020-01-14 2020   10276617 2726 0 2878.8 -152.8 2726       weekly 2
1172 Portugal Portugal 0 2020-01-15 2020-01-21 2020   10276617 2704 0 2812.0 -108.0 2704       weekly 3
1173 Portugal Portugal 0 2020-01-22 2020-01-28 2020   10276617 2732 0 2833.4 -101.4 2732       weekly 4
1174 Portugal Portugal 0 2020-01-29 2020-02-04 2020   10276617 2681 0 2686.8 -5.80000000000018 2681       weekly 5
1175 Portugal Portugal 0 2020-02-05 2020-02-11 2020   10276617 2374 0 2686.2 -312.2 2374       weekly 6
1176 Portugal Portugal 0 2020-02-12 2020-02-18 2020   10276617 2302 0 2585.4 -283.4 2302       weekly 7
1177 Portugal Portugal 0 2020-02-19 2020-02-25 2020   10276617 2350 0 2556.4 -206.4 2350       weekly 8
1178 Portugal Portugal 0 2020-02-26 2020-03-03 2020   10276617 2282 0 2442.8 -160.8 2282       weekly 9
1179 Portugal Portugal 0 2020-03-04 2020-03-10 2020   10276617 2217 0 2323.0 -106.0 2217       weekly 10
1180 Portugal Portugal 0 2020-03-11 2020-03-17 2020   10276617 2374 1 2257.6 116.4 2373       weekly 11
1181 Portugal Portugal 0 2020-03-18 2020-03-24 2020   10276617 2461 32 2224.4 236.6 2429       weekly 12
1182 Portugal Portugal 0 2020-03-25 2020-03-31 2020   10276617 2593 127 2192.0 401.0 2466       weekly 13
1183 Portugal Portugal 0 2020-04-01 2020-04-07 2020   10276617 2670 185 2182.8 487.2 2485       weekly 14
1184 Portugal Portugal 0 2020-04-08 2020-04-14 2020   10276617 2561 222 2120.4 440.6 2339       weekly 15
1185 Portugal Portugal 0 2020-04-15 2020-04-21 2020   10276617 2339 195 2018.6 320.4 2144       weekly 16
1186 Portugal Portugal 0 2020-04-22 2020-04-28 2020   10276617 2277 211 1988.4 288.6 2066       weekly 17
1187 Portugal Portugal 0 2020-04-29 2020-05-05 2020   10276617 2176 101 1995.8 180.2 2075       weekly 18
1188 Portugal Portugal 0 2020-05-06 2020-05-12 2020   10276617 2157 89 1940.6 216.4 2068       weekly 19
1189 Portugal Portugal 0 2020-05-13 2020-05-19 2020   10276617 2025 84 1945.0 80.0 1941       weekly 20
1190 Portugal Portugal 0 2020-05-20 2020-05-26 2020   10276617 2164 95 1937.2 226.8 2069       weekly 21
1191 Portugal Portugal 0 2020-05-27 2020-06-02 2020   10276617 2243 94 1917.0 326.0 2149       weekly 22
1192 Portugal Portugal 0 2020-06-03 2020-06-09 2020   10276617 1948 56 1893.0 55.0 1892       weekly 23
1193 Portugal Portugal 0 2020-06-10 2020-06-16 2020   10276617 1891 30 1851.8 39.2 1861       weekly 24
2757 Portugal Portugal 0 2020-01-01 2020-01-07 2020   10276617 2574 0 2859.4 -285.4 2574 0.0 -2.77717852090819 -0.0998111491921383 weekly 1
2758 Portugal Portugal 0 2020-01-08 2020-01-14 2020   10276617 2726 0 2878.8 -152.8 2726 0.0 -1.48687063067545 -0.0530776712519105 weekly 2
2759 Portugal Portugal 0 2020-01-15 2020-01-21 2020   10276617 2704 0 2812.0 -108.0 2704 0.0 -1.05092950335699 -0.0384068278805121 weekly 3
2760 Portugal Portugal 0 2020-01-22 2020-01-28 2020   10276617 2732 0 2833.4 -101.4 2732 0.0 -0.986706033707397 -0.0357873932378062 weekly 4
2761 Portugal Portugal 0 2020-01-29 2020-02-04 2020   10276617 2681 0 2686.8 -5.80000000000018 2681 0.0 -0.056438806661766 -0.00215870180139954 weekly 5
2762 Portugal Portugal 0 2020-02-05 2020-02-11 2020   10276617 2374 0 2686.2 -312.2 2374 0.0 -3.03796473100048 -0.116223661678207 weekly 6
2763 Portugal Portugal 0 2020-02-12 2020-02-18 2020   10276617 2302 0 2585.4 -283.4 2302 0.0 -2.75771686343862 -0.109615533379748 weekly 7
2764 Portugal Portugal 0 2020-02-19 2020-02-25 2020   10276617 2350 0 2556.4 -206.4 2350 0.0 -2.00844305086003 -0.0807385385698639 weekly 8
2765 Portugal Portugal 0 2020-02-26 2020-03-03 2020   10276617 2282 0 2442.8 -160.8 2282 0.0 -1.56471726055374 -0.0658261011953497 weekly 9
2766 Portugal Portugal 0 2020-03-04 2020-03-10 2020   10276617 2217 0 2323.0 -106.0 2217 0.0 -1.03146784588742 -0.0456306500215239 weekly 10
2767 Portugal Portugal 0 2020-03-11 2020-03-17 2020   10276617 2374 1 2257.6 116.4 2373 0.00973082873478694 1.1326684647292 0.0515591778880227 weekly 11
2768 Portugal Portugal 0 2020-03-18 2020-03-24 2020   10276617 2461 32 2224.4 236.6 2429 0.311386519513182 2.30231407865059 0.106365761553677 weekly 12
2769 Portugal Portugal 0 2020-03-25 2020-03-31 2020   10276617 2593 127 2192.0 401.0 2466 1.23581524931794 3.90206232264956 0.18293795620438 weekly 13
2770 Portugal Portugal 0 2020-04-01 2020-04-07 2020   10276617 2670 185 2182.8 487.2 2485 1.80020331593558 4.7408597595882 0.223199560197911 weekly 14
2771 Portugal Portugal 0 2020-04-08 2020-04-14 2020   10276617 2561 222 2120.4 440.6 2339 2.1602439791227 4.28740314054713 0.207790982833428 weekly 15
2772 Portugal Portugal 0 2020-04-15 2020-04-21 2020   10276617 2339 195 2018.6 320.4 2144 1.89751160328345 3.11775752662574 0.158723868027346 weekly 16
2773 Portugal Portugal 0 2020-04-22 2020-04-28 2020   10276617 2277 211 1988.4 288.6 2066 2.05320486304005 2.80831717285951 0.145141822570911 weekly 17
2774 Portugal Portugal 0 2020-04-29 2020-05-05 2020   10276617 2176 101 1995.8 180.2 2075 0.982813702213481 1.75349533800861 0.090289608177172 weekly 18
2775 Portugal Portugal 0 2020-05-06 2020-05-12 2020   10276617 2157 89 1940.6 216.4 2068 0.866043757396038 2.1057513382079 0.111511903534989 weekly 19
2776 Portugal Portugal 0 2020-05-13 2020-05-19 2020   10276617 2025 84 1945.0 80.0 1941 0.817389613722103 0.778466298782955 0.0411311053984575 weekly 20
2777 Portugal Portugal 0 2020-05-20 2020-05-26 2020   10276617 2164 95 1937.2 226.8 2069 0.92442872980476 2.20695195704968 0.117076192442701 weekly 21
2778 Portugal Portugal 0 2020-05-27 2020-06-02 2020   10276617 2243 94 1917.0 326.0 2149 0.914697901069973 3.17225016754054 0.170057381324987 weekly 22
2779 Portugal Portugal 0 2020-06-03 2020-06-09 2020   10276617 1948 56 1893.0 55.0 1892 0.544926409148069 0.535195580413282 0.0290544109878499 weekly 23
2780 Portugal Portugal 0 2020-06-10 2020-06-16 2020   10276617 1891 30 1851.8 39.2 1861 0.291924862043608 0.381448486403649 0.0211685927205962 weekly 24

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 167.031ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette