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

46 rows where country = "Sweden"

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

  • Sweden · 46

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
184 Sweden Sweden 0 2020-01-01 2020-01-07 2020   10338368 1879 0 1987.6 -108.6 1879       weekly 1
185 Sweden Sweden 0 2020-01-08 2020-01-14 2020   10338368 1866 0 1942.0 -76.0 1866       weekly 2
186 Sweden Sweden 0 2020-01-15 2020-01-21 2020   10338368 1789 0 1954.2 -165.2 1789       weekly 3
187 Sweden Sweden 0 2020-01-22 2020-01-28 2020   10338368 1794 0 1912.6 -118.6 1794       weekly 4
188 Sweden Sweden 0 2020-01-29 2020-02-04 2020   10338368 1794 0 1907.0 -113.0 1794       weekly 5
189 Sweden Sweden 0 2020-02-05 2020-02-11 2020   10338368 1771 0 1898.8 -127.8 1771       weekly 6
190 Sweden Sweden 0 2020-02-12 2020-02-18 2020   10338368 1822 0 1923.0 -101.0 1822       weekly 7
191 Sweden Sweden 0 2020-02-19 2020-02-25 2020   10338368 1774 0 2012.0 -238.0 1774       weekly 8
192 Sweden Sweden 0 2020-02-26 2020-03-03 2020   10338368 1751 0 1961.8 -210.8 1751       weekly 9
193 Sweden Sweden 0 2020-03-04 2020-03-10 2020   10338368 1831 0 1924.6 -93.5999999999999 1831       weekly 10
194 Sweden Sweden 0 2020-03-11 2020-03-17 2020   10338368 1781 8 1875.4 -94.4000000000001 1773       weekly 11
195 Sweden Sweden 0 2020-03-18 2020-03-24 2020   10338368 1883 73 1800.2 82.8 1810       weekly 12
196 Sweden Sweden 0 2020-03-25 2020-03-31 2020   10338368 2104 251 1825.8 278.2 1853       weekly 13
197 Sweden Sweden 0 2020-04-01 2020-04-07 2020   10338368 2444 532 1818.4 625.6 1912       weekly 14
198 Sweden Sweden 0 2020-04-08 2020-04-14 2020   10338368 2558 667 1726.4 831.6 1891       weekly 15
199 Sweden Sweden 0 2020-04-15 2020-04-21 2020   10338368 2455 628 1752.4 702.6 1827       weekly 16
200 Sweden Sweden 0 2020-04-22 2020-04-28 2020   10338368 2259 555 1715.8 543.2 1704       weekly 17
201 Sweden Sweden 0 2020-04-29 2020-05-05 2020   10338368 2237 544 1649.0 588.0 1693       weekly 18
202 Sweden Sweden 0 2020-05-06 2020-05-12 2020   10338368 2146 479 1633.2 512.8 1667       weekly 19
203 Sweden Sweden 0 2020-05-13 2020-05-19 2020   10338368 1935 355 1580.4 354.6 1580       weekly 20
204 Sweden Sweden 0 2020-05-20 2020-05-26 2020   10338368 1814 329 1535.6 278.4 1485       weekly 21
205 Sweden Sweden 0 2020-05-27 2020-06-02 2020   10338368 1702 278 1582.0 120.0 1424       weekly 22
206 Sweden Sweden 0 2020-06-03 2020-06-09 2020   10338368 1656 240 1530.6 125.4 1416       weekly 23
3285 Sweden Sweden 0 2020-01-01 2020-01-07 2020   10338368 1879 0 1987.6 -108.6 1879 0.0 -1.05045593269653 -0.0546387603139464 weekly 1
3286 Sweden Sweden 0 2020-01-08 2020-01-14 2020   10338368 1866 0 1942.0 -76.0 1866 0.0 -0.735125698756322 -0.03913491246138 weekly 2
3287 Sweden Sweden 0 2020-01-15 2020-01-21 2020   10338368 1789 0 1954.2 -165.2 1789 0.0 -1.59793112413874 -0.0845358714563504 weekly 3
3288 Sweden Sweden 0 2020-01-22 2020-01-28 2020   10338368 1794 0 1912.6 -118.6 1794 0.0 -1.14718299832236 -0.062009829551396 weekly 4
3289 Sweden Sweden 0 2020-01-29 2020-02-04 2020   10338368 1794 0 1907.0 -113.0 1794 0.0 -1.0930158415719 -0.059255374934452 weekly 5
3290 Sweden Sweden 0 2020-02-05 2020-02-11 2020   10338368 1771 0 1898.8 -127.8 1771 0.0 -1.23617189869813 -0.0673056667368864 weekly 6
3291 Sweden Sweden 0 2020-02-12 2020-02-18 2020   10338368 1822 0 1923.0 -101.0 1822 0.0 -0.976943362820902 -0.0525221008840354 weekly 7
3292 Sweden Sweden 0 2020-02-19 2020-02-25 2020   10338368 1774 0 2012.0 -238.0 1774 0.0 -2.3021041618948 -0.118290258449304 weekly 8
3293 Sweden Sweden 0 2020-02-26 2020-03-03 2020   10338368 1751 0 1961.8 -210.8 1751 0.0 -2.03900654339254 -0.107452339688042 weekly 9
3294 Sweden Sweden 0 2020-03-04 2020-03-10 2020   10338368 1831 0 1924.6 -93.5999999999999 1831 0.0 -0.905365334257785 -0.0486334822820326 weekly 10
3295 Sweden Sweden 0 2020-03-11 2020-03-17 2020   10338368 1781 8 1875.4 -94.4000000000001 1773 0.0773816525006655 -0.913103499507854 -0.0503359283352885 weekly 11
3296 Sweden Sweden 0 2020-03-18 2020-03-24 2020   10338368 1883 73 1800.2 82.8 1810 0.706107579068573 0.800900103381887 0.045994889456727 weekly 12
3297 Sweden Sweden 0 2020-03-25 2020-03-31 2020   10338368 2104 251 1825.8 278.2 1853 2.42784934720838 2.69094696571064 0.1523715631504 weekly 13
3298 Sweden Sweden 0 2020-04-01 2020-04-07 2020   10338368 2444 532 1818.4 625.6 1912 5.14587989129425 6.05124522555204 0.344038715354158 weekly 14
3299 Sweden Sweden 0 2020-04-08 2020-04-14 2020   10338368 2558 667 1726.4 831.6 1891 6.45169527724298 8.04382277744418 0.481696014828545 weekly 15
3300 Sweden Sweden 0 2020-04-15 2020-04-21 2020   10338368 2455 628 1752.4 702.6 1827 6.07445972130224 6.79604363087094 0.400935859392833 weekly 16
3301 Sweden Sweden 0 2020-04-22 2020-04-28 2020   10338368 2259 555 1715.8 543.2 1704 5.36835214223367 5.25421420479519 0.31658701480359 weekly 17
3302 Sweden Sweden 0 2020-04-29 2020-05-05 2020   10338368 2237 544 1649.0 588.0 1693 5.26195237004525 5.68755145879891 0.356579745300182 weekly 18
3303 Sweden Sweden 0 2020-05-06 2020-05-12 2020   10338368 2146 479 1633.2 512.8 1667 4.63322644347735 4.96016392529266 0.313984815086946 weekly 19
3304 Sweden Sweden 0 2020-05-13 2020-05-19 2020   10338368 1935 355 1580.4 354.6 1580 3.43381082971703 3.429941747092 0.224373576309795 weekly 20
3305 Sweden Sweden 0 2020-05-20 2020-05-26 2020   10338368 1814 329 1535.6 278.4 1485 3.18232045908987 2.69288150702316 0.181297212815837 weekly 21
3306 Sweden Sweden 0 2020-05-27 2020-06-02 2020   10338368 1702 278 1582.0 120.0 1424 2.68901242439813 1.16072478750998 0.0758533501896335 weekly 22
3307 Sweden Sweden 0 2020-06-03 2020-06-09 2020   10338368 1656 240 1530.6 125.4 1416 2.32144957501996 1.21295740294793 0.0819286554292435 weekly 23

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