35:null 36:["$","title",null,{"children":"SARS-CoV-2 infections according to regional agencies | Augustus Kling | Observable"}] 3c:T892,md`# SARS-CoV-2 infections according to regional agencies Data shown is scraped from websites of regional agencies and thus often more recent than country statistics due to slow manual communication between agencies. The data is only available for a few regions because a scraper needs to be build for each website separately or data is simply not published :( Data on fatalities distinguishing between SARS-CoV-2 infections and COVID-19 is rarely available. The death counts presented here are generally deaths where a SARS-CoV-2 infection was known to be present upon death. It does not imply SARS-CoV-2 was the cause of the death. Official aggregated data which is **not** used here: * Baden-Württemberg: https://sozialministerium.baden-wuerttemberg.de/de/gesundheit-pflege/gesundheitsschutz/infektionsschutz-hygiene/informationen-zu-coronavirus/ * Bayern: https://www.lgl.bayern.de/gesundheit/infektionsschutz/infektionskrankheiten_a_z/coronavirus/karte_coronavirus/index.htm * Germany: https://experience.arcgis.com/experience/478220a4c454480e823b17327b2bf1d4/page/page_1/ * Austria: https://info.gesundheitsministerium.gv.at/ * Sweden: https://experience.arcgis.com/experience/09f821667ce64bf7be6f9f87457ed9aa Official aggregated data which is used here: * Italy: https://github.com/pcm-dpc/COVID-19 (Data for Sardegna is not shown on provice level because changed province boundaries don't map to NUTS polygons shown on the map) The colors in the map show where data is available, provinces with higher growth rates are more vibrant/brighter. Higher prevalence of SARS-CoV-2 infections is shown in redder tints.

The colors in the map show where data is available, provinces with higher growth rates are more vibrant/brighter. Higher prevalence of SARS-CoV-2 infections is shown in redder tints.

Regions where no data newer than ${old.format('LLL')} (your browser's time zone) is available, are not rendered in the map but are still shown in the table below along with their update time. Expect regions to disappear from the map due to unavailability of current data from time to time, especially during weekends.`3d:T1018,cumulatedInfections = { const table = document.createElement('table'); table.className = 'regionList'; const header = document.createElement('tr'); table.appendChild(header); header.innerHTML = 'NameCumulated InfectionsDaily growth (last 4 days)Update date'; const latestScrapes = Object.values(latestByNuts) .filter(scrape => showItalyInTable==='yes' || !/^IT/.test(scrape.NUTS)); latestScrapes.forEach(scrape => scrape.displayName = nutsCodeToDisplayName[scrape.NUTS] || scrape.NUTS); latestScrapes.sort((a, b) => a.displayName.localeCompare(b.displayName)); for(const scrape of latestScrapes){ const row = document.createElement('tr'); const displayName = document.createElement('td'); displayName.appendChild(document.createTextNode(`${scrape.displayName} (${scrape.NUTS})`)); if (nutsCodeToPopulation.has(scrape.NUTS)) { const population = nutsCodeToPopulation.get(scrape.NUTS); const prevalence = document.createElement('div'); prevalence.appendChild(document.createTextNode(`Prevalence: ${(scrape.cumulatedInfected / population * 1000).toPrecision(4)}‰ (${scrape.cumulatedInfected} of ${population})`)); displayName.appendChild(prevalence); } if (scrape.currentlyInfected || (scrape.cumulatedDeaths && scrape.cumulatedRecovered)) { const activeCases = scrape.currentlyInfected || (scrape.cumulatedInfected - scrape.cumulatedRecovered - scrape.cumulatedDeaths); const currentlyInfected = document.createElement('div'); currentlyInfected.appendChild(document.createTextNode(`Current infections: ${activeCases}`)); if (nutsCodeToPopulation.has(scrape.NUTS)) { const population = nutsCodeToPopulation.get(scrape.NUTS); const activeCasesRelative = ` (${(activeCases / population * 1000).toPrecision(2)}‰ of population)`; currentlyInfected.appendChild(document.createTextNode(activeCasesRelative)); } displayName.appendChild(currentlyInfected); } if (scrape.cumulatedDeaths) { const cumulatedDeaths = document.createElement('div'); cumulatedDeaths.appendChild(document.createTextNode(`Deaths, total: ${scrape.cumulatedDeaths}`)); displayName.appendChild(cumulatedDeaths); } row.appendChild(displayName); const cumulatedInfected = document.createElement('td'); cumulatedInfected.title = 'Cumulated Infected: ' + scrape.cumulatedInfected; makeInfectionGraph(scrape.NUTS).then(graph => cumulatedInfected.appendChild(graph)); row.appendChild(cumulatedInfected); const recentDailyGrowthCell = document.createElement('td'); if (recentDailyGrowthFactor.has(scrape.NUTS)) { const growthFactor = recentDailyGrowthFactor.get(scrape.NUTS); recentDailyGrowthCell.appendChild(document.createTextNode(growthFactorToPercent(growthFactor))); if (growthFactor > 1) { const doublingTime = Math.log(2) / Math.log(growthFactor); const doublingTimeDiv = document.createElement('div'); doublingTimeDiv.appendChild(document.createTextNode(`doubling every ${doublingTime.toFixed(1)} days`)); recentDailyGrowthCell.appendChild(doublingTimeDiv); } } row.appendChild(recentDailyGrowthCell); const updateDate = document.createElement('td'); updateDate.title = `Scraper: ${scrape.scraper}\nLast scrape: ${scrape.scrapedAt.toISOString()}`; if(scrape.updateDate) { updateDate.appendChild(document.createTextNode(scrape.updateDate)); if (old.isAfter(scrape.updateDate)) { updateDate.style.color = outdatedColor; } } else { const lastDataChangeScrape = latestDataChangeByNuts.get(scrape.NUTS); const lastDataChange = lastDataChangeScrape.updateDate || lastDataChangeScrape.scrapedAt.toISOString(); updateDate.appendChild(document.createTextNode('Last data change: ' + lastDataChange)); if (old.isAfter(lastDataChange)) { updateDate.style.color = outdatedColor; } } row.appendChild(updateDate); table.appendChild(row); } return table; }3e:T535,styleFunction = (f, r) => { const scrape = latestByNuts[f.getId()]; if (scrape && old.isBefore(scrape.updateDate || scrape.scrapedAt)) { /*const highGrowth = scrape.cumulatedInfected > 100 && recentDailyGrowthFactor.has(scrape.NUTS) && recentDailyGrowthFactor.get(scrape.NUTS) > 1.2; let opacity = '77'; if (nutsCodeToPopulation.has(scrape.NUTS)) { const prevalenceColor = Math.min(Math.max(Math.round(scrape.cumulatedInfected / nutsCodeToPopulation.get(scrape.NUTS) * 3500), 4), 9); opacity = '' + prevalenceColor + prevalenceColor; } scrapedStyle.getFill().setColor(highGrowth ? '#ff0000' + opacity : '#ffa500' + opacity);*/ scrapedStyle.getFill().setColor('#' + colorForNuts(scrape.NUTS).substr(0, 6) + '77'); const infected = String(scrape.cumulatedInfected); const dailyGrowthLabel = recentDailyGrowthFactor.has(scrape.NUTS) ? '\n' + growthFactorToPercent(recentDailyGrowthFactor.get(scrape.NUTS)) : ''; if (r < 800) { scrapedStyle.getText().setText(nutsCodeToDisplayName[scrape.NUTS] + '\n' + infected + dailyGrowthLabel); } else { scrapedStyle.getText().setText(infected + dailyGrowthLabel); } return scrapedStyle; } else { baseStyle.getText().setText(f.getId().length === 5 ? nutsCodeToDisplayName[f.getId()] : ''); return baseStyle; } }3f:[{"id":"99d33bd0fc65d0416a6a7a7c570bd869c1c6a49ca4cf68ef717c0018094d7d21a26373936c6f186477d3e0b97c6f1500f9178cb48933fe5fa34785de574a1841","href":"https://static.observableusercontent.com/files/99d33bd0fc65d0416a6a7a7c570bd869c1c6a49ca4cf68ef717c0018094d7d21a26373936c6f186477d3e0b97c6f1500f9178cb48933fe5fa34785de574a1841","name":"legend@1.png","type":"image/png","lastModified":1586177588810.32,"size":3035}] 3a:{"id":"09ba41671f4e6126","slug":"sars-cov-2-infections-according-to-regional-agencies","title":"SARS-CoV-2 infections according to regional agencies","thumbnail":"b766fbd51746e224dc43fca228f9925c9a9dfa1bb57a7a3cb28d740e3e236e49","access_level":"public","create_time":"$D2020-03-21T10:30:50.514Z","update_time":"$D2020-04-06T12:54:59.687Z","view_time":null,"first_public_time":"$D2020-03-21T12:21:10.250Z","has_unpublished_edits":null,"fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"28e27a495b2437b4","login":"augustuskling","name":"Augustus Kling","avatar_url":"https://avatars-next.observableusercontent.com/0974177a406c4ca853d5e3838ae5596154e3c39a18195a5043a0109fa8c2f3cc","tier":"starter_2024","bio":"","following":false},"version":490,"publish_version":490,"role":null,"authored":false,"authors":[{"type":"individual","id":"bf5a73194bb2f919","login":"augustuskling","name":"Augustus Kling","avatar_url":"https://avatars-next.observableusercontent.com/0974177a406c4ca853d5e3838ae5596154e3c39a18195a5043a0109fa8c2f3cc","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"bf5a73194bb2f919","login":"augustuskling","name":"Augustus Kling","avatar_url":"https://avatars-next.observableusercontent.com/0974177a406c4ca853d5e3838ae5596154e3c39a18195a5043a0109fa8c2f3cc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"SARS-CoV-2 infections according to regional agencies","cells":[{"id":0,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`## Corona infection according to regional agencies\n\nScraped by https://github.com/AugustusKling/corona-scraper`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"mapRegionsApi.target","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"viewof showItalyInTable = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"scrapes =\n fetch('https://raw.githubusercontent.com/AugustusKling/corona-scraper/master/data/scrapes.jsonstream').then(response => response.text())\n //FileAttachment(\"scrapes.jsonstream\").text()\n .then(raw => raw.split('\\n').filter(line => line.trim() !== '').map(line => JSON.parse(line)).map(o => ({...o, scrapedAt: moment(o.scrapedAt)})))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":228,"value":"scrapesByNuts = {\n const groups = new Map();\n scrapes.forEach(scrape => {\n if(!groups.has(scrape.NUTS)) {\n groups.set(scrape.NUTS, [scrape]);\n } else {\n groups.get(scrape.NUTS).push(scrape);\n }\n });\n return groups;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"lowestInfectionsByNuts = (fromTime, toTime) => {\n const results = new Map();\n for(const [nutsCode, scrapes] of scrapesByNuts) {\n const candidates = scrapes.filter(scrape => {\n const time = scrape.updateDate ? moment(scrape.updateDate) : scrape.scrapedAt;\n return time.isBetween(fromTime, toTime);\n });\n if (candidates.length > 0) {\n candidates.sort((a, b) => a.cumulatedInfected - b.cumulatedInfected);\n results.set(nutsCode, candidates[0]);\n }\n }\n return results;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"lowReferenceData = lowestInfectionsByNuts(moment().subtract(4, 'days'), moment().subtract(2, 'days'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"recentDailyGrowthFactor = {\n const results = new Map();\n \n for (const [nutsCode, lowRef] of lowReferenceData) {\n const mostRecent = latestByNuts[nutsCode];\n if (mostRecent) {\n const lowTime = lowRef.updateDate ? moment(lowRef.updateDate) : lowRef.scrapedAt;\n const recentTime = mostRecent.updateDate ? moment(mostRecent.updateDate) : mostRecent.scrapedAt;\n if (lowTime.isBefore(recentTime)) {\n const daysPassed = moment.duration(recentTime.diff(lowTime)).as('days');\n const growthFactor = Math.pow(mostRecent.cumulatedInfected / lowRef.cumulatedInfected, 1/daysPassed);\n results.set(nutsCode, growthFactor);\n }\n }\n }\n \n return results;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"latestByNuts = {\n const latestAllLevels = {};\n for(const [nuts, group] of scrapesByNuts) {\n latestAllLevels[nuts] = group.reduce((a, b) => {\n if (a.scrapedAt.isAfter(b.scrapedAt)) {\n return a;\n } else {\n return b;\n }\n });\n }\n \n const ignoreDueToMoreSpecificData = new Set();\n for(const nutsId of Object.keys(latestAllLevels)) {\n if ( nutsId.length > 2) {\n const parentNutsId = nutsId.substr(0, nutsId.length - 1);\n ignoreDueToMoreSpecificData.add(parentNutsId);\n }\n }\n \n const result = {};\n for(const [nuts, scrape] of Object.entries(latestAllLevels)) {\n if (!ignoreDueToMoreSpecificData.has(nuts)){\n result[nuts] = scrape;\n }\n }\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"latestDataChangeByNuts = {\n const result = new Map();\n for(const [nuts, scrapes] of scrapesByNuts) {\n result.set(nuts, scrapes.reduce((older, newer) => {\n if (older.cumulatedInfected === newer.cumulatedInfected) {\n return older;\n } else {\n return newer;\n }\n }));\n }\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"old = moment().subtract(2, 'day');","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"outdatedColor = 'red';","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":223,"value":"md`## Styling`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"makeInfectionGraph = async nuts => {\n const lowBoundary = moment().subtract(4, 'days');\n const data = scrapesByNuts.get(nuts).map(s => {\n return Object.assign({}, s, {date: (s.updateDate ? moment(s.updateDate) : s.scrapedAt).toDate()});\n });\n const x = vl.x().axis({ title: null }).scale({ domain: [lowBoundary, moment()] }).fieldT('date');\n const y = vl.y().axis({ title: null, tickCount: 3 }).fieldQ('cumulatedInfected');\n \n const line = vl.mark({ type: 'line', clip: true })\n .width(100).height(50)\n .data(data)\n .encode(x, y);\n const point = vl.mark({ type: 'point', size: 8, clip: true })\n .width(100).height(50)\n .data(data)\n .encode(x, y);\n const graphContainer = await vl.layer(line, point)\n .background('transparent')\n .view({ fill: 'white' })\n .render();\n return graphContainer;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"baseStyle = new ol.style.Style({\n text: new ol.style.Text({\n font: '12px sans-serif',\n stroke: new ol.style.Stroke({\n color: 'white',\n width: 2\n })\n }),\n stroke: new ol.style.Stroke({\n color: 'lightgray',\n width: 2\n })\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"scrapedStyle = new ol.style.Style({\n fill: new ol.style.Fill(),\n text: new ol.style.Text({\n font: '12px sans-serif',\n stroke: new ol.style.Stroke({\n color: 'white',\n width: 3\n })\n }),\n stroke: baseStyle.getStroke()\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"growthFactorToPercent = growthFactor => {\n const growhRate = Math.round((growthFactor - 1) * 100) + '%';\n if (growthFactor < 1) {\n return growhRate;\n } else {\n return '+' + growhRate;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"mapRegionsApi.regionLayer.getSource().once('change', () => {\n const extentWithData = ol.extent.createEmpty();\n mapRegionsApi.regionLayer.getSource().getFeatures()\n .filter(feature => latestByNuts.hasOwnProperty(feature.getId()))\n .forEach(f => ol.extent.extend(extentWithData, f.getGeometry().getExtent()));\n mapRegionsApi.map.getView().fit(extentWithData);\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":452,"value":"colorScheme = {\n // first index prevalence, next growth factor.\n return [\n ['828132ff', 'd2c71aff', 'ffea00ff'],\n ['7e5836ff', 'cd8319ff', 'ff9600ff'],\n ['823232ff', 'd21a1aff', 'ff0000ff']\n ];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"colorForNuts = nuts => {\n const scrape = latestByNuts[nuts];\n let growthColorIndex = 1;\n if (recentDailyGrowthFactor.has(scrape.NUTS)) {\n const growthFactor = recentDailyGrowthFactor.get(scrape.NUTS);\n if (growthFactor < 1.05) {\n growthColorIndex = 0;\n } else if (growthFactor > 1.2) {\n growthColorIndex = 2;\n }\n }\n \n let prevalenceColorIndex = 1;\n if (nutsCodeToPopulation.has(scrape.NUTS)) {\n const prevalencePromille = scrape.cumulatedInfected / nutsCodeToPopulation.get(scrape.NUTS) * 1000;\n if (prevalencePromille < 1) {\n prevalenceColorIndex = 0;\n } else if (prevalencePromille > 3) {\n prevalenceColorIndex = 2;\n }\n }\n \n return colorScheme[prevalenceColorIndex][growthColorIndex];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"md`## Dependencies`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"import {mapRegionsApi, ol, nutsCodeToDisplayName, nutsCodeToPopulation} with {styleFunction as styleFunction} from '@augustuskling/openlayers-map-of-europe'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"moment = require('moment')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"import {vl} from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3f","stdlib":"1"}} 3b:"$3a:body"