<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Clara Guibourg on Medium]]></title>
        <description><![CDATA[Stories by Clara Guibourg on Medium]]></description>
        <link>https://medium.com/@guibourg.clara?source=rss-22798a324151------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*vPUE27hyjqTk4J7Y12SQQw.jpeg</url>
            <title>Stories by Clara Guibourg on Medium</title>
            <link>https://medium.com/@guibourg.clara?source=rss-22798a324151------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 16:11:40 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@guibourg.clara/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[One in three regions have higher covid deaths in second wave]]></title>
            <link>https://medium.com/newsworthy-se/one-in-three-regions-have-higher-covid-deaths-in-second-wave-fd79f35968a2?source=rss-22798a324151------2</link>
            <guid isPermaLink="false">https://medium.com/p/fd79f35968a2</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[coronavirus]]></category>
            <dc:creator><![CDATA[Clara Guibourg]]></dc:creator>
            <pubDate>Mon, 14 Dec 2020 08:41:03 GMT</pubDate>
            <atom:updated>2020-12-14T08:55:44.203Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Over a third of European regions have had higher excess deaths this autumn than at any previous point during the pandemic, with a second outbreak that has spread beyond a few hard-hit regions. <br>As Europe’s second wave begins to pass its peak, we’ve gathered subnational data from over 750 regions, allowing us to track the true toll of the coronavirus pandemic.</strong></p><p>Over the last couple of months Europeans have once again found themselves at the centre of the coronavirus pandemic, as the continent has been battling a second wave.</p><p>Data from 21 European countries shows that over <strong>370,000 more people than usual have died </strong>since the start of the pandemic.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*VwZIklEVqEau_ZWj" /></figure><p>But these excess deaths have been very unevenly spread, geographically, which is why <strong>regional</strong> data is more useful than national.</p><p>Breaking down excess deaths by when they occurred also allows us to <strong>compare the spring and autumn waves</strong>, and gives us a clearer picture of which areas the pandemic is currently hitting hardest.</p><h3>Highest excess deaths yet in third of regions</h3><p>Already, over <strong>a third of European regions have had higher excess deaths in autumn</strong> than any other time this year.</p><p>There’s a clear geographical pattern here: many countries in central and eastern Europe, for instance Poland, Czechia and Bulgaria, were spared the first wave that battered many western European countries in spring, but have now been hit hard by a second wave.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*JA21LU-GSOAEADa4" /></figure><p>Coronavirus statistics are notoriously difficult to compare across countries, as deaths are defined and counted in very different ways. Excess deaths dodge many of these issues, and are better suited for international comparisons.</p><p>However, this is also the slowest measure, with several weeks lag at best, and so full data for the latest month is yet to come in.</p><h3>Turning point taking longer to arrive</h3><p>Deaths have yet to peak in several European countries, so the full picture of the second coronavirus wave is not yet available to us, but rather a snapshot of the current situation. Even so, some trends are already apparent.</p><p>For one, this time the turning point has taken significantly longer to arrive. In spring, coronavirus deaths started climbing rapidly at the start of March. By mid-April, some six weeks later, they had already peaked across Europe.</p><p>In autumn, however, <strong>deaths across the continent did not peak until 11 weeks after they had begun increasing again</strong> in mid-September.</p><h3>Less concentrated to few hard-hit regions</h3><p>Coronavirus deaths in Europe have been higher in autumn than at any other point. But while the first wave hit a few regions exceptionally hard, such as Bergamo in Italy, our analysis shows the virus is now more spread out.</p><p>In the spring months, the 50 worst affected regions account for nearly half of all the excess — or “unnormal” — deaths.</p><p>By autumn <strong>this proportion had dropped to 30%</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*IpxCzC-bufweUbPU" /></figure><p>About three in five regions have had excess deaths so far this autumn. This is roughly the same proportion as in the spring.</p><p>But this time, so far, there are <strong>fewer regions that stand out with really high rates</strong>.</p><p>In spring, deaths were twice their normal levels in 18 regions. In Bergamo, they were three times higher than usual.</p><p>By comparison, in autumn, based on the data available so far, none of the over 750 regions in our data have so far had deaths twice normal levels.</p><p>At this point, it bears repeating that as deaths have not yet peaked in all regions, this figure is useful to show a trend, rather than an exact value.</p><p>Sweden, for instance, is reporting more cases than ever before, suggesting the outbreak has not yet reached its peak. Meanwhile, Italy has an unusually large lag in reporting, and only has figures until the start of the autumn.</p><p>Although the full picture has not yet emerged, the data so far shows us a second wave that is less concentrated to just a few places, and more evenly spread out across regions and in many places surpasses the first one.</p><h3>Use the data</h3><p>We’ve published the <a href="https://gitlab.com/newsworthy/jpp.2005.excess.deaths.data">data behind our analysis here</a>.</p><h3>Methodology</h3><p>Our analysis is based on data showing daily or weekly all-cause deaths in each region, which has been collated from Eurostat and national statistical agencies (Scotland: NRS, Northern Ireland: NISRA, Germany: Destatis).</p><p>A number of countries in Central and Eastern Europe have not reported any regional statistics on excess. These are excluded from this analysis.</p><p>Excess deaths have been calculated by comparing all deaths reported in a region since the start of the pandemic with the average number of deaths during that time period in the previous couple of years. We have further broken this down by season, to calculate the excess deaths in spring (weeks 10–22), summer (weeks 23–35) and autumn (weeks 36 onward).</p><p>Countries have reported up to different weeks, and we have used the latest data available. This means up to late November for most regions, but some have a larger lag in reporting. Italy, for instance, only has data available up to the beginning of October.</p><p>For most countries, the average period is 2015–2019. Others have fewer years of data available, but at least two full years have been used. We’ve used as granular data as possible, which is NUTS3-level for most countries. However, for Germany, Scotland and Northern Ireland, comparative data is only available at NUTS1-level (making Scotland and Northern Ireland one region each, and Germany’s data broken down by its Bundesländer).</p><p>A region is defined as having had excess deaths if reported deaths were at least 5 percent higher than expected and at least 20 more deaths than usual occurred. If deaths were at least 25 percent higher than expected, we have defined it as a region with “significant excess”.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fd79f35968a2" width="1" height="1" alt=""><hr><p><a href="https://medium.com/newsworthy-se/one-in-three-regions-have-higher-covid-deaths-in-second-wave-fd79f35968a2">One in three regions have higher covid deaths in second wave</a> was originally published in <a href="https://medium.com/newsworthy-se">Newsworthy.se</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Tecken på ändrat beteende efter restriktioner — men inte på samma nivå som i våras]]></title>
            <link>https://medium.com/newsworthy-se/tecken-p%C3%A5-%C3%A4ndrat-beteende-efter-restriktioner-men-inte-p%C3%A5-samma-niv%C3%A5-som-i-v%C3%A5ras-45bae247a60a?source=rss-22798a324151------2</link>
            <guid isPermaLink="false">https://medium.com/p/45bae247a60a</guid>
            <category><![CDATA[coronavirus]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-journalism]]></category>
            <dc:creator><![CDATA[Clara Guibourg]]></dc:creator>
            <pubDate>Fri, 13 Nov 2020 08:15:19 GMT</pubDate>
            <atom:updated>2020-11-19T13:08:27.618Z</atom:updated>
            <content:encoded><![CDATA[<h3>Tecken på ändrat beteende efter restriktioner — men inte på samma nivå som i våras</h3><p><strong>Det syns tecken på minskad aktivitet på arbetsplatser och i utelivet i regioner som har infört striktare lokala råd. Det visar Newsworthys analys av ny data från Google. Men jämfört med andra europeiska länder är våra förändringar små. Är det tillräckligt för att platta till kurvan?</strong></p><p>Går det att mäta vilken effekt lokala restriktioner har på svenskarnas beteende?</p><p>Smittspridningen ökar i Sverige, och under de senaste veckorna har region efter region fått skärpta råd från FHM.</p><p>Som datajournalist undrar man förstås direkt: finns det något sätt att mäta effekten dessa har? Jobbar fler hemifrån? Är det fler som håller sig hemma från kafeer och restauranger?</p><p>Med platsdata från Google går det att följa hur mycket människor rör sig på olika typer av platser. Här ska vi titta närmare på två tidsserier: aktivitet på arbetsplatser, samt på restauranger, caféer och i butiker.</p><p>Så här ser arbetsplatskurvan ut i Stockholm:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*qnkudNRPXpWLVvp8" /></figure><p>Under sommaren var aktiviteten på arbetsplatser — av uppenbara orsaker — låg. Under hela hösten har det varit allt fler som gått tillbaka till sina jobb, men det är fortfarande många som hemmajobbar. I Stockholm har aktiviteten på arbetsplatserna varit omkring en tredjedel lägre än normalt under hösten.</p><p>De senaste två veckorna ser vi att kurvan vänder nedåt, vilket ändå främst kan förklaras av höstlovet. Vi ser ett liknande fall under påskveckan (vecka 15).</p><p>Veckan efter höstlovet, då de skärpta restriktionerna infördes, tillbringade stockholmarna ungefär lika mycket tid på sina arbetsplatser som i slutet av maj, men något mer än under de mest isolerade veckorna i slutet av mars och början av april.</p><p>Kurvan över aktivitet på kaféer, restauranger, butiker och andra allmänna utrymmen är mindre svängig. Vi har tidigare skrivit om <a href="https://medium.com/newsworthy-se/minskad-social-isolering-n%C3%A4stan-halva-landet-r%C3%B6r-sig-ute-som-innan-pandemin-762627bd17af">säsongsvariationerna för utelivet här</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*G663kaMU4Jv1DEe0" /></figure><p>Också här ser vi en viss nedgång den senaste veckan, efter en stadigt ökad aktivitet under hösten. Stockholmarna rör sig — liksom övriga svenskar — ungefär lika mycket på stan om vid ingången till sommaren, men betydligt mer än under isolationsveckorna i slutet av mars och början april.</p><h3>Större minskning i län med restriktioner</h3><p>Den senaste datan från Google sträcker sig fram till den 8 november. Jämför vi senaste siffrorna med vecka 43, innan höstlovet, ser vi att regioner som infört restriktioner* minskat sin aktivitet på arbetsplatser och på stan mer än de regioner som inte har det.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZYym6HdPg92kOhudqYD43g.png" /></figure><p>Närvaron på arbetsplatser är oförändrad för regioner utan lokala råd. För de som har det har aktiviteten sjunkit något de senaste veckorna, med fyra procentenheter.</p><p>Samma trend märks i siffrorna för handel och nöje, det vill säga caféer, restauranger, butiker och liknande.</p><p>Aktiviteten minskar överallt, men regioner med skärpta råd har under de senaste två veckorna en mer än dubbelt så stor nedgång som regioner utan.</p><h3>Räcker det?</h3><p>Siffrorna här blir lätt abstrakta. Vad innebär “fyra procentenheter lägre aktivitet på arbetsplatser” i praktiken? Låt oss försöka konkretisera.</p><p>Säg att ett bostadsområde består av 100 arbetande personer. Innan höstlovet var det 18 av dessa som jobbade hemma. Under de senaste två veckorna är det ytterligare fyra personer som övergått till hemmajobb. Men det är fortfarande 78 som är kvar på sina arbetsplatser.</p><p>Googledatan pekar på att vi än så länge är <em>mindre</em> isolerade nu än under den första vågen i våras, men kurvan pekar nu åt rätt håll. Om den fortsätter nedåt återstår att se.</p><h3>Hur ser det ut i andra länder?</h3><p>Sveriges arbetsplatskurva är relativt lik våra nordiska grannars, men jämfört med andra europeiska länder har våra arbetsplatser varit relativt aktiva.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rmbvbuSpBvrw0dCg" /></figure><p>Beteendeskillnaden är än mer påfallande när vi jämför olika länders uteliv.</p><p>Återigen ser de nordiska ländernas kurvor ganska lika ut, till skillnad från andra europeiska länder, som haft striktare restriktioner och perioder av nedstängning.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*EIqMhK4PF2zJK225" /></figure><p>*) Här ingår endast de regioner som infört restriktioner innan 8 november: Uppsala, Skåne, Östergötland, Stockholm, Västra Götaland, Halland, Jönköping, Örebro, Kronoberg, och Södermanland</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=45bae247a60a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/newsworthy-se/tecken-p%C3%A5-%C3%A4ndrat-beteende-efter-restriktioner-men-inte-p%C3%A5-samma-niv%C3%A5-som-i-v%C3%A5ras-45bae247a60a">Tecken på ändrat beteende efter restriktioner — men inte på samma nivå som i våras</a> was originally published in <a href="https://medium.com/newsworthy-se">Newsworthy.se</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Hur berättar man bättre med klimatdata?]]></title>
            <link>https://medium.com/newsworthy-se/hur-ber%C3%A4ttar-man-b%C3%A4ttre-med-klimatdata-1a7d8d7b863b?source=rss-22798a324151------2</link>
            <guid isPermaLink="false">https://medium.com/p/1a7d8d7b863b</guid>
            <category><![CDATA[data-journalism]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[climate]]></category>
            <category><![CDATA[storytelling]]></category>
            <dc:creator><![CDATA[Clara Guibourg]]></dc:creator>
            <pubDate>Thu, 08 Oct 2020 07:17:33 GMT</pubDate>
            <atom:updated>2020-10-08T07:17:33.713Z</atom:updated>
            <content:encoded><![CDATA[<h4>Vill du komma igång med att bevaka klimatet som datajournalist? Eller göra dina dataknäck mer engagerande? Här är tre saker att komma ihåg för att förbättra ditt berättande.</h4><p>Ett problem man snabbt upptäcker när man ger sig in på att bevaka klimatet ur ett datajournalistiskt perspektiv är att det finns hur mycket klimat- och miljödata som helst, men den känns ofta väldigt abstrakt.</p><p>Vi får till exempel ofta höra att planeten är en dryg grad varmare i dag än den var innan industrialiseringen tog fart. Men sådana här globala genomsnitt är väldigt svåra att föreställa sig.</p><p>Så när man väl tagit sig an själva analysen måste man tänka ett varv till kring hur man ska lägga upp sitt berättande på ett sätt som engagerar läsare, och känns minnesvärt.</p><h3>1. Gör det personligt</h3><p>På Newsworthy funderar vi ofta över hur man kan göra datan <strong><em>personligt</em></strong><em> </em><strong><em>relevant</em></strong> — med andra ord visa användaren hur det ser ut just för dem.</p><p>Datajournalistik gör det möjligt att säga något inte bara om trenden i stort utan svara på frågan “hur blir det just för dig?”, eller “hur ser det ut i din kommun?”.</p><p>Det kommer att göra det du berättar mycket mer minnesvärt.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*gF-R2BO0HEUadFtH" /></figure><p>En av de sista grejerna jag jobbade med på BBC, innan jag började på Newsworthy, var en <a href="https://www.bbc.co.uk/news/resources/idt-985b9374-596e-4ae6-aa04-7fbcae4cb7ee">interaktiv visualisering om ökande temperaturer</a>. Målet var enkelt: vi ville visa hur mycket varmare det redan blivit jämfört med år 1900, och hur mycket varmare det skulle kunna bli.</p><p>Problemet då blev att temperaturanomalier över ett år säger inte så mycket. Därför zoomade vi i stället in och visade temperaturen en typisk sommardag och en typisk vinterdag, just där du bor.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Nw2uqTQluN77hXhU" /></figure><p>Dels blev det mer konkret genom att göra det geografiskt relevant, och genom att visa en specifik månad man faktiskt kan föreställa sig, istället för snittet över året.</p><h3>2. Konkretisera mera!</h3><p>Tänk efter på <em>alla</em> sätt du kan konkretisera datan.</p><p>I vintras använde vi oss av SMHI:s data för att utforska antalet dagar med snö — dels hur många som observerats hittills, dels hur många man tror att det kommer att bli framöver, baserat på olika framtidsscenarier. Det har <a href="http://www.smhi.se/klimat/framtidens-klimat/lansanalyser/sweden/days-snow-5-mm">SMHI tagit fram prognoser för</a>, som finns nedbrutna på väldigt lokal nivå.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*66uyokUw-IM0KUKb" /></figure><p>I stället för att stanna vid att temperaturer blir varmare, gick vi vidare till en <strong><em>konkret, lokal och påtaglig konsekvens</em></strong> av det: hur många ordentligt vintriga snödagar får din stad i framtiden?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1000/0*MtGfMbk8VrJQcC8b" /></figure><p>Målet är ju att det här ska <strong><em>peka på en trend </em></strong>man kanske redan själv har känt av i området — och hur det kan fortsätta att utvecklas.</p><h3>3. Glöm inte konsekvenserna</h3><p>Det är viktigt att sätta saker i sitt sammanhang.</p><p>I våras analyserade vi tillsammans med Sveriges Natur hur <a href="https://www.sverigesnatur.org/aktuellt/klimatprognosen-langre-vaxtsasong-och-mer-torka/">växtsäsonger</a> kunde komma att se ut i framtiden. Vi såg först och främst att våren kommer att börja mycket tidigare, inte minst i södra delar av landet.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*LYSiZr9SDuJPFKuM" /></figure><p>Men vi ville få mer av en helhetsbild, vad kunde en sådan förändring för sin del innebära? <strong><em>Vad kunde konsekvensen av det bli?</em></strong></p><p>När vi tog det ett steg längre insåg vi att en direkt konsekvens av längre odlingssäsong skulle bli fler dagar med torka, något man också kunde se i datan. Med det fick vi en lite breddad bild av klimatprognosen, även här lokalt nedbruten.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Q1uCY_Yzf-GTdGTd" /></figure><h3>Sammanfattning</h3><p>Data i ett vakuum är poänglöst, målet är alltid att <strong>göra det konkret</strong> och <strong>sätta det i ett sammanhang</strong>.</p><p><em>Det här blogginlägget bygger på en </em><a href="https://docs.google.com/presentation/d/12pJonfxPl63-4pzv6BUNdDN7RlaZsmiDwLnWC4iaq8U/edit#slide=id.g98b92d8750_0_155"><em>föreläsning</em></a><em> vi höll tillsammans med Malin Crona från Sveriges Natur, på årets digitala version av Grävseminariet. Inför föreläsningen tog vi också fram denna </em><a href="https://docs.google.com/document/d/1k6e11ZJdiY3HrR75h3ZjtCcN5c_CqgLoo9m9nI72F3M/edit"><em>lista på klimatrelaterade dataset</em></a><em>.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1a7d8d7b863b" width="1" height="1" alt=""><hr><p><a href="https://medium.com/newsworthy-se/hur-ber%C3%A4ttar-man-b%C3%A4ttre-med-klimatdata-1a7d8d7b863b">Hur berättar man bättre med klimatdata?</a> was originally published in <a href="https://medium.com/newsworthy-se">Newsworthy.se</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Most European regions back to normal death rates — several regions in Sweden still above]]></title>
            <link>https://medium.com/newsworthy-se/most-european-regions-back-to-normal-death-rates-several-regions-in-sweden-still-above-9abcffabb31a?source=rss-22798a324151------2</link>
            <guid isPermaLink="false">https://medium.com/p/9abcffabb31a</guid>
            <category><![CDATA[data-journalism]]></category>
            <category><![CDATA[coronavirus]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Clara Guibourg]]></dc:creator>
            <pubDate>Mon, 24 Aug 2020 07:47:43 GMT</pubDate>
            <atom:updated>2020-08-25T08:21:43.990Z</atom:updated>
            <content:encoded><![CDATA[<h3>Most European regions back to normal death rates — several regions in Sweden still above</h3><p><strong>As summer nears its end, it’s becoming possible to evaluate the coronavirus pandemic’s toll on European regions over nearly six months.<br>We’ve analysed data from 776 subnational regions to better understand where the virus is continuing to hit hard.</strong></p><p>Data from <strong><em>21 European countries</em></strong> shows that over 225,000 more people than usual have died since the start of the pandemic.</p><p><strong>This story was co-published with Svenska Dagbladet: </strong><a href="https://www.svd.se/overdodligheten-minskar-langsammare-i-sverige-an-andra-lander"><strong>Överdödligheten minskar långsammare i Sverige</strong></a><strong> <br>Read our </strong><a href="https://medium.com/newsworthy-se/a-fraction-of-european-regions-account-for-a-majority-of-covid-deaths-778e546765a9"><strong>previous analysis</strong></a><strong> or </strong><a href="https://gitlab.com/newsworthy/jpp.2005.excess.deaths.data"><strong>download the data yourself</strong></a><strong>.</strong></p><p>Breaking down the excess deaths by when they occurred allows us to identify areas where the epidemic is continuing to hit hard, after the first wave made areas like Bergamo and Madrid its first epicentres.</p><p>In spring (March-May), <em>the worst-hit areas counted their excess deaths in the thousands</em>, and about one-third, or 255, of all the regions we’ve analysed had deaths at least 25% higher than usual.</p><p>Over the summer months, from June onwards, this was the case in just one region, Legnicko-Głogowski in Poland, where 81 more people than usual died.</p><h3>Normal levels in four in five regions</h3><p>This far into the pandemic, almost all regions have managed to bring their excess deaths down. In fact the vast majority of regions, about four in five, had deaths at more or less normal levels over the summer months.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*6fPu7zXMVakh4Ral" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*FHPJcJ5qhDUEnfHv" /></figure><p>However, progress has been slower in some countries than others.</p><p>Sweden, an outlier in its handling of the coronavirus pandemic, also stands out in our data.</p><p><a href="https://www.svd.se/overdodligheten-minskar-langsammare-i-sverige-an-andra-lander"><strong>Read more: Överdödligheten minskar långsammare i Sverige (Svenska Dagbladet)</strong></a></p><p>Nearly half of all regions (43%) in Sweden still had more deaths than usual during summer. This is higher than all but two other countries, Poland (51%) and Czechia (50%), both of which currently have as many new daily cases as they ever have.</p><p>Other countries where several regions were still seeing excess deaths over summer include Lithuania (40%), Latvia (33%), Portugal (32%) and the UK (22%).</p><p>The UK stood out in <a href="https://medium.com/newsworthy-se/a-fraction-of-european-regions-account-for-a-majority-of-covid-deaths-778e546765a9">our June analysis of excess deaths</a>, as a country with a rather uniform spread of high excess deaths across the country: In most countries the spread of coronavirus this spring was regional, rather than national, and largely contained to one part of the country. In the UK however, all regions but one had at least 25% excess deaths.</p><h3>Stockholm back to normal levels</h3><p>For Sweden, Stockholm has been where the bulk of coronavirus deaths have occurred.</p><p>In the spring, 4,745 more people than usual died in Sweden. Nearly half of these excess deaths occurred in the capital.</p><p>With 59% more deaths than usual, Stockholm had a higher excess death rate of than all but 68 of the 776 regions we looked at.</p><p>However, since June Stockholm hasn’t had any more deaths than usual.</p><p>The regions in Sweden where most excess deaths occurred over summer are Uppsala (16% more deaths than usual), Halland (+15%), and Blekinge (+13%).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/892/0*JgyZjpR_QVqgGwPl" /></figure><p>It is worth noting that all of these excess deaths are not necessarily related to covid-19. In small regions coincidences may bump the death tolls. For example Gotland in Sweden has recorded 31 more deaths than usual (+15%), but only <a href="https://experience.arcgis.com/experience/09f821667ce64bf7be6f9f87457ed9aa">6 officially covid-related deaths</a>, according to the Public Health Agency of Sweden.</p><h3>What about a second wave?</h3><p>Cases are rising again in many European countries, not least Spain, France, Belgium. Across the EU, new daily cases are higher than at any point since April.</p><p>So why is this not visible in our data?</p><p>Comparing countries’ coronavirus figures is a tricky business: official case counts depend on how much testing is being done, and deaths from coronavirus are counted in very different ways, and both are difficult to reliably compare across many countries.</p><p>As an indicator of covid-19’s toll, excess deaths dodges many of issues related to international comparability. However, this is also the slowest measure, with several weeks lag at best, which is why we only cover deaths that occurred up to July or the start of August. A spike occurring in new cases today won’t result in excess deaths for a number of weeks.</p><h3>Use the data</h3><p>We’ve published the <a href="https://gitlab.com/newsworthy/jpp.2005.excess.deaths.data">data behind our analysis here</a>.</p><h3>Methodology</h3><p>Our analysis is based on data showing daily or weekly all-cause deaths in each region, which has been collated from Eurostat and national statistical agencies (Scotland: NRS, Northern Ireland: NISRA, Germany: Destatis).</p><p>A number of countries in Central and Eastern Europe have not reported any regional statistics on excess. These are excluded from this analysis.</p><p>Excess deaths have been calculated by comparing all deaths reported in a region since the start of the pandemic with the average number of deaths during that time period in the previous couple of years. We have further broken this down by season, to calculate the excess deaths in spring by comparing all deaths reported in a region between weeks 10–22 with the average, and the excess deaths in summer by comparing all deaths reported from week 23 onward with the average.</p><p>Countries have reported up to different weeks, and we have used the latest data available. This largely means up to mid-July or the beginning of August, but Italy and Poland, for instance, only have data available up to 28 June.</p><p>For most countries, the average period is 2015–2019. Others have fewer years of data available, but at least two full years have been used. We’ve used as granular data as possible, which is NUTS3-level for most countries. However, for Germany, Scotland and Northern Ireland, comparative data is only available at NUTS1-level.</p><p>A region is defined as having had excess deaths if reported deaths were at least 5 percent higher and 20 more than expected. If deaths were at least 25 percent higher than expected, we have defined it as a region with “significant excess”.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9abcffabb31a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/newsworthy-se/most-european-regions-back-to-normal-death-rates-several-regions-in-sweden-still-above-9abcffabb31a">Most European regions back to normal death rates — several regions in Sweden still above</a> was originally published in <a href="https://medium.com/newsworthy-se">Newsworthy.se</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[A fraction of European regions account for a majority of covid deaths]]></title>
            <link>https://medium.com/newsworthy-se/a-fraction-of-european-regions-account-for-a-majority-of-covid-deaths-778e546765a9?source=rss-22798a324151------2</link>
            <guid isPermaLink="false">https://medium.com/p/778e546765a9</guid>
            <category><![CDATA[coronavirus]]></category>
            <category><![CDATA[data-journalism]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Clara Guibourg]]></dc:creator>
            <pubDate>Wed, 24 Jun 2020 03:01:00 GMT</pubDate>
            <atom:updated>2020-06-24T03:01:00.961Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Some regions report up to three times as many deaths as usual since March, but a large part of Europe has been able to live through the first wave of the coronavirus pandemic without any significant excess death. <br>We have gathered subnational data from 500 European regions to better understand the spread of the virus.</strong></p><p>Borders are being opened and lockdown policies are lifted as the first wave of the coronavirus peters out. We are also getting a more and more comprehensive picture of the death toll of the pandemic so far.</p><p>Data from 20 European countries shows that over 200,000 more people than usual have died since March. In this article we will explore this <em>excess death toll</em>.</p><p>Our analysis shows that the deaths are very unevenly distributed geographically. To better understand the spread of the virus we have gathered data on excess deaths from <strong><em>500 subnational regions</em></strong>.</p><p>The 50 worst affected regions account for just under half of all the excess — or “unnormal” — deaths.</p><p>We have seen tonnes of national coronavirus comparisons in the last couple of months. But comparing nations easily becomes misleading. The spread of the pandemic is <strong><em>regional</em></strong> rather than national.</p><p><strong>Explore the analysis </strong><a href="http://www.newsworthy.se/en/corona-excess-deaths/"><strong>region by region</strong></a><strong> or </strong><a href="https://gitlab.com/newsworthy/jpp.2005.excess.deaths.data"><strong>download the data yourself</strong></a><strong>.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lLgy380R3af7g2qlnJioQw.png" /></figure><h3>Uneven spread in Italy and Sweden</h3><p>Several Italian regions stand out when we compare regional excess deaths across Europe. Bergamo, in northern Italy, is one of the first places coronavirus took hold in Europe, and, up to the end of April, the region has had deaths many times higher than usual.</p><p>But corona’s spread across Italy is geographically focused to the north of the country, suggesting it has been contained. Many regions in the south have had normal levels of deaths.</p><p>This chart shows how much excess deaths vary across Italy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*4N6TcRiGFVPeiy53" /></figure><p>The picture is similar in Sweden, which has also been hit hard by coronavirus. The bulk of the country’s excess deaths have occurred in the capital region, where an unfortunately timed half-term break meant thousands were returning from the Alps just as the new disease was spreading there.</p><p>71 percent more people than usual have died in Stockholm during the pandemic, higher than all but 31 of the 500 regions we’ve analysed, and a similar level to Catalonia and Brussels. However, in large parts of Sweden the number of deaths has been normal or close to it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/892/0*6fjQ3ctV4NcGiUtB" /></figure><p>A country that stands out with a rather uniform spread of the disease is the United Kingdom. Every region but one report significant excess deaths.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*d4jNml3bttMf0nR3" /></figure><h3>On the other hand — many regions go unaffected</h3><p>136 of the 500 regions (27 percent) report a significant number of excess deaths. That is at least 25 percent more deaths than usual during the pandemic. Another 158 report somewhat more deaths than normal.</p><p>While thousands of lives have been lost, it is noteworthy that nearly half of all regions in the 20 analyzed countries have recorded more or less normal number of deaths, despite the pandemic.</p><p>In Slovakia, Lithuania and Bulgaria all (or almost all) regions have had normal levels of death. And even in hard-hit countries like Italy and France and Sweden considerable parts of the countries have had no excess deaths.</p><h3>Publish this story</h3><p>This article and research behind it was made possible through a collaboration with the European Data Journalism Network. You are free to republish all stories and visualisations under Creative Commons, in line with the <a href="https://www.europeandatajournalism.eu/eng/Syndication">syndication guidelines</a>. You can find the data <a href="https://gitlab.com/newsworthy/jpp.2005.excess.deaths.data">here</a>.</p><h3>Methodology</h3><p>Our analysis is based on data showing daily or weekly all-cause deaths in each region, which has been collated from Eurostat and national statistical agencies. (UK: ONS, NRS and NISRA, Germany: Destatis, Spain: ISCIII, Netherlands: CBS)</p><p>We have gathered as geographically granular data as possible (mostly at NUTS3 level), but in countries such as Germany only NUTS1 level data has been published, and in the Netherlands only NUTS2. A number of countries in Central and Eastern Europe have not reported any regional statistics on excess. These are excluded from this analysis.</p><p>Excess deaths have been calculated by comparing all deaths reported in a region since the start of the pandemic with the average number of deaths during that time period in the previous couple of years.</p><p>For most countries, the average period is 2015–2019. Others have fewer years of data available, but at least two full years have been used. Some, like Spain, have modelled the expected number of deaths for 2020 instead of providing historical figures.</p><p>A region is defined as having had excess deaths if reported deaths were at least 5 percent higher and 20 more than expected. If deaths were at least 25 percent higher than expected, we have defined it as a region with “significant excess”.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=778e546765a9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/newsworthy-se/a-fraction-of-european-regions-account-for-a-majority-of-covid-deaths-778e546765a9">A fraction of European regions account for a majority of covid deaths</a> was originally published in <a href="https://medium.com/newsworthy-se">Newsworthy.se</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Minskad social isolering — nästan halva landet rör sig ute som innan pandemin]]></title>
            <link>https://medium.com/newsworthy-se/minskad-social-isolering-n%C3%A4stan-halva-landet-r%C3%B6r-sig-ute-som-innan-pandemin-762627bd17af?source=rss-22798a324151------2</link>
            <guid isPermaLink="false">https://medium.com/p/762627bd17af</guid>
            <category><![CDATA[coronavirus]]></category>
            <category><![CDATA[sweden]]></category>
            <category><![CDATA[data-journalism]]></category>
            <category><![CDATA[social-distance]]></category>
            <category><![CDATA[mobility]]></category>
            <dc:creator><![CDATA[Clara Guibourg]]></dc:creator>
            <pubDate>Thu, 04 Jun 2020 12:29:43 GMT</pubDate>
            <atom:updated>2020-06-04T12:29:43.874Z</atom:updated>
            <content:encoded><![CDATA[<h3>Minskad social isolering — nästan halva landet rör sig ute som innan pandemin</h3><p><strong>Med mobilitetsdata från Google får vi en bild av hur mycket svenskarna rör sig ute på stan. <br>De senaste siffrorna, som publicerades i går, visar att försommarvärmen fört med sig ett tydligt aktivare uteliv.</strong></p><p>Sedan börjar av maj har vi på Newsworthy följt svenskarnas rörlighet som en del av vår <a href="https://www.newsworthy.se/sv/corona/">bredare coronabevakning</a>.</p><p>Med hjälp av <a href="https://www.google.com/covid19/mobility/">siffror från Google</a> kan vi få ett ganska bra hum om hur svenskarna rör på sig på olika platser. Det rör sig om anonymiserad och aggregerad platsdata från Google Maps-användare kategoriserad på olika typer av platser (hemmet, jobbet, kollektivtrafiken och så vidare). Vi har har framför allt följt aktiviteten inom handel och nöje, det vill säga platser som kaféer, restauranger, köpcentra, biografer och bibliotek.</p><p>Vad visar datan? Vår aktivitet har krupit uppåt de senaste veckorna. I de färskaste siffrorna, publicerade 3 juni, ser vi att flera län nu ligger över “normalnivån”, som i det här fallet är en femveckorsperiod i januari och februari, innan pandemin bröt ut.</p><p>Till exempel <a href="https://www.newsworthy.se/sv/dashboard/newslead/47058/">hallänningarna</a> rör sig ute på stan tio procent <em>mer </em>nu än i början av året.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*6CM-94Js2d2LMauE" /></figure><p>Stockholm har fått mycket mediefokus. Så här ser länet kurva ut dag för dag. Vi kan se tydliga upp- och nedsving vid helgdagar, därför räknar vi bort dem från våra analyser. Huvudstaden har dragit ned på rörligheten mer än nästan alla andra län, men <a href="https://www.newsworthy.se/sv/dashboard/newslead/47068/">även här kryper den uppåt</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*4s7b_0VcmBdj79fp" /></figure><p>Den här trenden bekräftas av Telias färska veckodata över <a href="http://press.telia.se/pressreleases/svenskarnas-resande-tillbaka-paa-februarinivaaer-3004842">rörlighet i trafiken</a>, som nu är uppe på samma nivå som i februari.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/536/0*8Ok5xYInOU0xCeuY" /></figure><h3>Vad är normalt?</h3><p>Den vanligaste följdfrågan vi fått på tidigare publiceringar på Googles mobilitetsdata är hur det sett ut tidigare år. Det vet vi tyvärr inte. Google släpper bara en tidsserie som använder början av året som referens.</p><p>Men vi vill nyansera och fördjupa den bilden lite. Vad hade en normal nivå i maj varit — utan en pandemi?</p><p>Då blir nästa fråga förstås: Blir det egentligen äpplen och päron att jämföra hur vi beter oss i maj mot midvinter?</p><p>Korta svaret: ja, lite faktiskt.</p><p>SCB följer våra konsumtionsmönster månad för månad i <a href="https://www.statistikdatabasen.scb.se/goto/sv/ssd/HushKonInd">hushållens konsumtionsindikator</a>*. De senaste fem åren har restaurang-, kafe- och hotellbesök legat i genomsnitt hela 36% högre i maj än i januari-februari.</p><p>Även kultur och rekreation får ett rejält säsongsuppsving, och är 23% högre i maj än under vintermånaderna.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*wFbDNd4xA13CyKcR" /></figure><p>Kategorierna här överlappar förstås inte exakt med de i Googles data, men de ger oss en fingervisning om säsongsskillnaderna.</p><p>Vad innebär allt detta för vad datan visar? Trenden är tydlig: vår rörlighet ökar — och når på många platser samma nivå som innan pandemin, vilket är anmärkningsvärt i sig. Å andra sidan är det normalt att utelivet tar fart under våren, framför allt jämfört med oxveckorna i januari och februari.</p><p>Ett halvfullt glas skulle man kunna säga. Eller halvtomt, om man är lagd åt det hållet.</p><p>….</p><p>*) Vi har kollat på fasta priser och kategorierna rekreation och kultur och restauranger, cafeer, hotell och annan övernattningsservice. <a href="http://www.statistikdatabasen.scb.se/pxweb/sv/ssd/START__HA__HA0101__HA0101B/HushKonInd/#">Datan hittar du här</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=762627bd17af" width="1" height="1" alt=""><hr><p><a href="https://medium.com/newsworthy-se/minskad-social-isolering-n%C3%A4stan-halva-landet-r%C3%B6r-sig-ute-som-innan-pandemin-762627bd17af">Minskad social isolering — nästan halva landet rör sig ute som innan pandemin</a> was originally published in <a href="https://medium.com/newsworthy-se">Newsworthy.se</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>