2e:null 2f:["$","title",null,{"children":"COVID-19 in België: een overzicht | Bart Mesuere | Observable"}] 34:T1085,overview = html` ${row("Antwerpen", "Antwerpen", false)} ${row("Limburg", "Limburg", false)} ${row("Oost-Vlaanderen", "OostVlaanderen", false)} ${row("Vlaams-Brabant", "VlaamsBrabant", false)} ${row("West-Vlaanderen", "WestVlaanderen", false)} ${row("Henegouwen", "Hainaut", false)} ${row("Luik", "Liège", false)} ${row("Luxemburg", "Luxembourg", false)} ${row("Namen", "Namur", false)} ${row("Waals-Brabant","BrabantWallon", false)} ${row("Brussel", "Brussels", false)} ${row("Vlaanderen", "Vlaanderen", true)} ${row("Wallonië", "Wallonië", true)} ${row("België", "België", true)}

Situatie op ${d3.timeFormat("%d/%m/%Y")(Date.parse(today))}

@BartMesuere

Provincie

Trend besmettingen
laatste 14 dagen^a

Recente besmettingen
per 100k inwoners^b

% positieve testen
laatste 14 dagen^c

Trend hospitalisaties
laatste 14 dagen^d

Patiënten
in ziekenhuis ${trend(national_hospitalisations.slice(-8)[0].TOTAL_IN, national_hospitalisations.slice(-1)[0].TOTAL_IN, 0.05, false)}

${hospiGraph(national_hospitalisations.slice(-14).map(v => v.TOTAL_IN), 135, 42)}

Patiënten
in ICU ${trend(national_hospitalisations.slice(-8)[0].TOTAL_IN_ICU, national_hospitalisations.slice(-1)[0].TOTAL_IN_ICU, 0.05, false)}

${hospiGraph(national_hospitalisations.slice(-14).map(v => v.TOTAL_IN_ICU), 135, 42, "d", true)}

Overlijdens
${trend(deaths.slice(-10)[0].AVG_DEATHS, deaths.slice(-3)[0].AVG_DEATHS, 0.05, false, 0)}

${hospiGraph(deaths.slice(-16).slice(0, -2).map(v => v.AVG_DEATHS), 135, 42, ".1f")}

Uitgevoerde
testen
${trend(lastCasesBelgium[6].TESTS_ALL, lastCasesBelgium[13].TESTS_ALL, 1, false)}

${hospiGraph(lastCasesBelgium.map(v => Math.round(v.TESTS_ALL/7)), 135, 42, ".3s")}

^a Verschil van het 7-daags gemiddelde van nieuwe besmettingen afgelopen week en verloop gedurende de laatste 14 dagen.
De laatste waarde voor België (${d3.format(".1f")(lastCasesBelgium[13].CASES/7)}) is het gemiddelde voor de periode van ${lastCasesBelgium[7].DATE} t.e.m. ${lastCasesBelgium[13].DATE}.
^b Deze waarden tonen het aantal besmette personen gedurende de laatste 14 dagen per 100 000 inwoners.
^c Gemiddeld percentage positieve testen gedurende de laatste 14 dagen.
^d Verschil van het 7-daags gemiddelde van nieuwe hospitalisaties afgelopen week en verloop gedurende de laatste 14 dagen.
De laatste waarde voor België (${d3.format(".1f")(lastHospiBelgium[13].CASES/7)}) is het gemiddelde voor de periode van ${lastHospiBelgium[7].DATE} t.e.m. ${lastHospiBelgium[13].DATE}.
^e Geschat op basis van het aantal besmettingen naar voorbeeld van het Robert Koch Institute met serieel interval 4.
Drempelwaarden: incidentie van 50, 200, en 500; 4% positieve testen; 65 en 150 opnames per dag; 300 en 500 personen op intensieve

Rt^e${rMiniGraph(r_values.map(v => v.r))}

Data: Sciensano

`35:Tbdb,function miniGraph(values, population, width = 135, height = 37) { //const levelHigh = hospiLevel(population, 14); //const levelLow = hospiLevel(population, 3.5); const levelLow = hospiLevel2(population, 65); const levelHigh = hospiLevel2(population, 150); const format = ".1f"; const x = d3.scaleLinear().domain([0, values.length - 1]).range([30, width - 35]); const y = d3.scaleLinear().domain([0, Math.max(levelHigh,d3.max(values))]).range([height - 6, 4]); const c = DOM.context2d(width, height); const area = d3.area().x((d, i) => x(i)).y0(y(0)).y1(y).context(c); const line = d3.line().x((d, i) => x(i)).y(y).context(c); // base line c.strokeStyle = "#000"; c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(0)); c.lineTo(x(values.length - 1), y(0)); c.stroke(); // fill c.fillStyle = lightFill; c.strokeStyle = darkFill;c.lineWidth = 1.5; c.beginPath(); area(values); c.fill(); // levels /*c.strokeStyle = purple; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelHigh)); c.lineTo(x(values.length - 1), y(levelHigh)); c.stroke(); c.setLineDash([]); c.strokeStyle = red; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelLow)); c.lineTo(x(values.length - 1), y(levelLow)); c.stroke(); c.setLineDash([]);*/ c.strokeStyle = red; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelHigh)); c.lineTo(x(values.length - 1), y(levelHigh)); c.stroke(); c.strokeStyle = orange; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelLow)); c.lineTo(x(values.length - 1), y(levelLow)); c.stroke(); c.setLineDash([]); // line c.fillStyle = lightFill; c.strokeStyle = darkFill; c.lineWidth = 1.5; c.beginPath(); line(values); c.stroke(); // dot and number left if (values[0] <= levelLow) c.fillStyle = green; else if(values[0] <= levelHigh) c.fillStyle = orange; else c.fillStyle = red; /*if (values[0] <= levelNew) c.fillStyle = green; else c.fillStyle = red;*/ c.beginPath(); c.arc(x(0), y(values[0]), 2, 0, 2*Math.PI); c.fill(); const text = c.measureText(d3.format(format)(values[0] / 7)); c.fillText(d3.format(format)(values[0] / 7), x(0) - text.width - 4, y(values[0]) + 4); // dot and number right if (values[values.length - 1] <= levelLow) c.fillStyle = green; else if(values[values.length - 1] <= levelHigh) c.fillStyle = orange; else c.fillStyle = red; /*if (values[values.length - 1] <= levelNew) c.fillStyle = green; else c.fillStyle = red;*/ c.beginPath(); c.arc(x(values.length - 1), y(values[values.length - 1]), 2, 0, 2*Math.PI); c.fill(); let arrow = ""; if (values[values.length - 1] > values[values.length - 2]) { arrow = "↑"; } else if (values[values.length - 1] < values[values.length - 2]) { arrow = "↓"; } c.fillText(d3.format(format)(values[values.length - 1] / 7) + arrow, x(values.length - 1) + 4, y(values[values.length - 1]) + 4); return c.canvas; }36:T8fc,function percentMiniGraph(values, width = 135, height = 37) { const max = 0.35; //const levelHigh = 0.06; const levelLow = 0.04; const format = ".1%"; const x = d3.scaleLinear().domain([0, values.length - 1]).range([33, width - 38]); const y = d3.scaleLinear().domain([0, max]).range([height - 6, 4]); const c = DOM.context2d(width, height); const area = d3.area().x((d, i) => x(i)).y0(y(0)).y1(y).context(c); const line = d3.line().x((d, i) => x(i)).y(y).context(c); // base line c.strokeStyle = "#000"; c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(0)); c.lineTo(x(values.length - 1), y(0)); c.stroke(); // fill c.fillStyle = lightFill; c.strokeStyle = darkFill;c.lineWidth = 1.5; c.beginPath(); area(values); c.fill(); // levels /*c.strokeStyle = purple; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelHigh)); c.lineTo(x(values.length - 1), y(levelHigh)); c.stroke();*/ c.strokeStyle = red; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelLow)); c.lineTo(x(values.length - 1), y(levelLow)); c.stroke(); c.setLineDash([]); // line c.fillStyle = lightFill; c.strokeStyle = darkFill; c.lineWidth = 1.5; c.beginPath(); line(values); c.stroke(); // dot and number left if (values[0] <= levelLow) c.fillStyle = green; //else if(values[0] <= levelHigh) c.fillStyle = red; else c.fillStyle = red; c.beginPath(); c.arc(x(0), y(values[0]), 2, 0, 2*Math.PI); c.fill(); const text = c.measureText(d3.format(format)(values[0])); c.fillText(d3.format(format)(values[0]), x(0) - text.width - 4, y(values[0]) + 4); // dot and nnumber right if (values[values.length - 1] <= levelLow) c.fillStyle = green; //else if(values[values.length - 1] <= levelHigh) c.fillStyle = red; else c.fillStyle = red; c.beginPath(); c.arc(x(values.length - 1), y(values[values.length - 1]), 2, 0, 2*Math.PI); c.fill(); let arrow = ""; if (values[values.length - 1] > values[values.length - 2]) { arrow = "↑"; } else if (values[values.length - 1] < values[values.length - 2]) { arrow = "↓"; } c.fillText(d3.format(format)(values[values.length - 1]) + arrow, x(values.length - 1) + 4, y(values[values.length - 1]) + 4); return c.canvas; }37:T439,function vaccineGraph(values, width = 190, height = 37) { const format = ".3s"; const marginBottom = 12; const baseLine = height - marginBottom; //const x = d3.scaleLinear().domain([0, values.length - 1]).range([30, width - 35]); const x = d3.scaleBand().domain(values.map((d, i) => i)).rangeRound([0, width]).padding(0.1); const y = d3.scaleLinear().domain([0, d3.max(values)]).rangeRound([0, height - marginBottom]); const c = DOM.context2d(width, height); const area = d3.area().x((d, i) => x(i)).y0(y(0)).y1(y).context(c); const line = d3.line().x((d, i) => x(i)).y(y).context(c); c.strokeStyle = "#000"; c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), baseLine); c.lineTo(x(values.length - 1) + x.bandwidth(), baseLine); c.stroke(); c.fillStyle = green; values.forEach(function(d, i) { c.fillRect(x(i), baseLine, x.bandwidth(), -y(d)); }); const text = `+${added_vaccines} ↵`; const textW = c.measureText(text).width; c.fillText(text, x(values.length - 1) - textW + x.bandwidth()/2 + 1, height -2); return c.canvas; }38:Tbb6,function baselessProjectedMiniGraph(values, pop, width = 145, height = 37) { const levelNew = hospiLevel2(pop, 500 / 100000 * population["België"] / 14); const levelHigh = hospiLevel2(pop, 500 / 100000 * population["België"] / 14); const levelMedium = hospiLevel2(pop, 200 / 100000 * population["België"] / 14); const levelLow = hospiLevel2(pop, 50 / 100000 * population["België"] / 14); const x = d3.scaleLinear().domain([0, values.length - 3]).range([40, width - 40]); //const y = d3.scaleLinear().domain(d3.extent(values.slice(0, -2))).range([height - 6, 6]); const y = d3.scaleLinear().domain([0, d3.max(values.slice(0, -2))]).range([height - 6, 6]); const c = DOM.context2d(width, height); const area = d3.area().x((d, i) => x(i)).y0(y(0)).y1(y).context(c); const line = d3.line().x((d, i) => x(i)).y(y).context(c); const lineDotted = d3.line().x((d, i) => x(values.length - 3 + i)).y(y).context(c); c.strokeStyle = "#000"; c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(0)); c.lineTo(x(values.length - 3), y(0)); c.stroke(); c.fillStyle = lightFill; c.strokeStyle = darkFill;c.lineWidth = 1.5; c.beginPath(); area(values.slice(0, -2)); c.fill(); c.beginPath(); line(values.slice(0, -2)); c.stroke(); c.strokeStyle = purple; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelHigh)); c.lineTo(x(values.length - 3), y(levelHigh)); c.stroke(); c.strokeStyle = red; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelMedium)); c.lineTo(x(values.length - 3), y(levelMedium)); c.stroke(); /*c.strokeStyle = orange; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelLow)); c.lineTo(x(values.length - 3), y(levelLow)); c.stroke();*/ c.setLineDash([]); if (values[0] <= levelLow) c.fillStyle = green; else if (values[0] <= levelMedium) c.fillStyle = orange; else if (values[0] <= levelHigh) c.fillStyle = red; else c.fillStyle = purple; c.beginPath(); c.arc(x(0), y(values[0]), 2, 0, 2*Math.PI); c.fill(); let text = c.measureText(d3.format(".1f")(values[0] / 7)); c.fillText(d3.format(".1f")(values[0] / 7), x(0) - text.width - 4, y(values[0]) + 4); if (values[values.length - 3] <= levelLow) c.fillStyle = green; else if (values[values.length - 3] <= levelMedium) c.fillStyle = orange; else if (values[values.length - 3] <= levelHigh) c.fillStyle = red; else c.fillStyle = purple; c.beginPath(); c.arc(x(values.length - 3), y(values[values.length - 3]), 2, 0, 2*Math.PI); c.fill(); let arrow = ""; if (values[values.length - 3] > values[values.length - 4]) { arrow = "↑"; } else if (values[values.length - 3] < values[values.length - 4]) { arrow = "↓"; } text = c.measureText(d3.format(".1f")(values[values.length - 3] / 7) + arrow); c.fillText(d3.format(".1f")(values[values.length - 3] / 7) + arrow, x(values.length - 3) + 4, y(values[values.length - 3]) + 4); return c.canvas; }39:T76a,function projectedMiniGraph(values, width = 145, height = 37) { const x = d3.scaleLinear().domain([0, values.length - 1]).range([30, width - 35]); const y = d3.scaleLinear().domain([0, d3.max(values)]).range([height - 6, 12]); const c = DOM.context2d(width, height); const area = d3.area().x((d, i) => x(i)).y0(y(0)).y1(y).context(c); const line = d3.line().x((d, i) => x(i)).y(y).context(c); const lineDotted = d3.line().x((d, i) => x(values.length - 3 + i)).y(y).context(c); c.strokeStyle = "#000"; c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(0)); c.lineTo(x(values.length - 1), y(0)); c.stroke(); c.fillStyle = lightFill; c.strokeStyle = darkFill;c.lineWidth = 1.5; c.beginPath(); area(values); c.fill(); c.beginPath(); line(values.slice(0, -2)); c.stroke(); c.beginPath(); c.setLineDash([1, 2]); lineDotted(values.slice(-3)); c.stroke(); c.fillStyle = darkFill; c.beginPath(); c.arc(x(0), y(values[0]), 2, 0, 2*Math.PI); c.fill(); c.beginPath(); c.arc(x(values.length - 3), y(values[values.length - 3]), 2, 0, 2*Math.PI); c.fill(); c.beginPath(); c.arc(x(values.length - 1), y(values[values.length - 1]), 2, 0, 2*Math.PI); c.fill(); let arrow = ""; if (values[values.length - 1] > values[values.length - 3]) { arrow = "↑"; } else if (values[values.length - 1] < values[values.length - 3]) { arrow = "↓"; } let text = c.measureText(d3.format(".1f")(values[values.length - 3] / 7)); c.fillText(d3.format(".1f")(values[values.length - 3] / 7), x(values.length - 3) - text.width / 2, y(values[values.length - 3]) - 4); c.fillText(d3.format(".1f")(values[values.length - 1] / 7) + arrow, x(values.length - 1) + 4, y(values[values.length - 1]) + 4); text = c.measureText(d3.format(".1f")(values[0] / 7)); c.fillText(d3.format(".1f")(values[0] / 7), x(0) - text.width - 4, y(values[0]) + 4); return c.canvas; }3a:T81e,function rMiniGraph(values, width = 165, height = 37) { const x = d3.scaleLinear().domain([0, values.length - 1]).range([25, width - 35]); const y = d3.scaleLog().domain([Math.min(1, d3.min(values)), Math.max(1, d3.max(values))]).range([height - 6, 12]); const c = DOM.context2d(width, height); const line = d3.line().x((d, i) => x(i)).y(y).context(c); const lineDotted = d3.line().x((d, i) => x(values.length - 3 + i)).y(y).context(c); c.strokeStyle = "#000"; c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(1)); c.lineTo(x(values.length - 3), y(1)); c.stroke(); c.fillStyle = lightFill; c.strokeStyle = darkFill;c.lineWidth = 1.5; c.beginPath(); line(values.slice(0, -2)); c.stroke(); c.strokeStyle = mediumFill; //c.beginPath(); c.setLineDash([1, 2]); lineDotted(values.slice(-3)); c.stroke(); c.fillStyle = darkFill; c.beginPath(); c.arc(x(0), y(values[0]), 2, 0, 2*Math.PI); c.fill(); c.beginPath(); c.arc(x(values.length - 3), y(values[values.length - 3]), 2, 0, 2*Math.PI); c.fill(); c.fillStyle = mediumFill; //c.beginPath(); c.arc(x(values.length - 1), y(values[values.length - 1]), 2, 0, 2*Math.PI); c.fill(); c.fillStyle = darkFill; let arrow = ""; if (values[values.length - 3] > values[values.length - 4]) { arrow = "↑"; } else if (values[values.length - 3] < values[values.length - 4]) { arrow = "↓"; } let text = c.measureText(d3.format(".2f")(values[values.length - 3]) + arrow); //c.fillText(d3.format(".2f")(values[values.length - 3]) + arrow, x(values.length - 3) - text.width / 2, y(values[values.length - 3]) - 4); c.fillText(d3.format(".2f")(values[values.length - 3]) + arrow, x(values.length - 3) + 4, y(values[values.length - 3]) + 4); c.fillStyle = mediumStroke; //c.fillText(d3.format(".2f")(values[values.length - 1]), x(values.length - 1) + 4, y(values[values.length - 1]) + 4); c.fillStyle = darkFill; text = c.measureText(d3.format(".2f")(values[0])); c.fillText(d3.format(".2f")(values[0]), x(0) - text.width - 4, y(values[0]) + 4); return c.canvas; }3b:T8ab,function hospiGraph(values, width = 135, height = 37, format="d", dots = false) { const levelRed = 500; const levelOrange = 300; const x = d3.scaleLinear().domain([0, values.length - 1]).range([30, width - 35]); const y = d3.scaleLinear().domain([0, d3.max(values)]).range([height - 2, 6]); const c = DOM.context2d(width, height); const area = d3.area().x((d, i) => x(i)).y0(y(0)).y1(y).context(c); const line = d3.line().x((d, i) => x(i)).y(y).context(c); c.strokeStyle = "#000"; c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(0)); c.lineTo(x(values.length - 1), y(0)); c.stroke(); c.fillStyle = lightFill; c.strokeStyle = darkFill;c.lineWidth = 1.5; c.beginPath(); area(values); c.fill(); c.beginPath(); line(values); c.stroke(); if (dots) { c.strokeStyle = red; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelRed)); c.lineTo(x(values.length - 1), y(levelRed)); c.stroke(); c.strokeStyle = orange; c.setLineDash([1, 1]) c.lineWidth = 0.5; c.beginPath(); c.moveTo(x(0), y(levelOrange)); c.lineTo(x(values.length - 1), y(levelOrange)); c.stroke(); c.setLineDash([]); } let arrow = ""; if (values[values.length - 1] > values[values.length - 2]) { arrow = "↑"; } else if (values[values.length - 1] < values[values.length - 2]) { arrow = "↓"; } c.fillStyle = darkFill; if (dots) { if (values[0] <= levelOrange) c.fillStyle = green; else if(values[0] <= levelRed) c.fillStyle = orange; else c.fillStyle = red; } c.beginPath(); c.arc(x(0), y(values[0]), 2, 0, 2*Math.PI); c.fill(); const text = c.measureText(d3.format(format)(values[0])); c.fillText(d3.format(format)(values[0]), x(0) - text.width - 4, y(values[0]) + 4); if (dots) { if (values[values.length - 1] <= levelOrange) c.fillStyle = green; else if(values[values.length - 1] <= levelRed) c.fillStyle = orange; else c.fillStyle = red; } c.beginPath(); c.arc(x(values.length - 1), y(values[values.length - 1]), 2, 0, 2*Math.PI); c.fill(); c.fillText(d3.format(format)(values[values.length - 1]) + arrow, x(values.length - 1) + 4, y(values[values.length - 1]) + 4); return c.canvas; }3c:T66e,cases = { const result = []; const grouped = d3a.rollup(raw_cases, v => d3.sum(v, d => d.CASES), d => d.DATE, d => d.PROVINCE); dates.forEach(date => { provinces.forEach(province => { result.push({DATE: date, PROVINCE: province, CASES: grouped.get(date).get(province) ? grouped.get(date).get(province) : 0}); }); const vl = (grouped.get(date).get("Antwerpen") ? grouped.get(date).get("Antwerpen") : 0) + (grouped.get(date).get("Limburg") ? grouped.get(date).get("Limburg") : 0) + (grouped.get(date).get("WestVlaanderen") ? grouped.get(date).get("WestVlaanderen") : 0) + (grouped.get(date).get("OostVlaanderen") ? grouped.get(date).get("OostVlaanderen") : 0) + (grouped.get(date).get("VlaamsBrabant") ? grouped.get(date).get("VlaamsBrabant") : 0); const wal = (grouped.get(date).get("Liège") ? grouped.get(date).get("Liège") : 0) + (grouped.get(date).get("BrabantWallon") ? grouped.get(date).get("BrabantWallon") : 0) + (grouped.get(date).get("Luxembourg") ? grouped.get(date).get("Luxembourg") : 0) + (grouped.get(date).get("Hainaut") ? grouped.get(date).get("Hainaut") : 0) + (grouped.get(date).get("Namur") ? grouped.get(date).get("Namur") : 0); const bru = grouped.get(date).get("Brussels") ? grouped.get(date).get("Brussels") : 0; const un = grouped.get(date).get(undefined) ? grouped.get(date).get(undefined) : 0; result.push({DATE: date, PROVINCE: "Vlaanderen", CASES: vl}); result.push({DATE: date, PROVINCE: "Wallonië", CASES: wal}); result.push({DATE: date, PROVINCE: "België", CASES: vl + wal + bru + un}); }); return result; }3d:T416,avg_cases = { const result = []; const grouped_cases = d3a.rollup(projected_cases, v => v, d => d.PROVINCE); const grouped_tests = d3a.rollup(tests, v => v, d => d.PROVINCE); extendedProvinces.forEach(province => { const c = grouped_cases.get(province); const t = grouped_tests.get(province); for (let i = 6; i < c.length; i++) { const cases = c[i-6].CASES + c[i-5].CASES + c[i-4].CASES + c[i-3].CASES + c[i-2].CASES + c[i-1].CASES + c[i-0].CASES; const tests = t[i-6].TESTS_ALL + t[i-5].TESTS_ALL + t[i-4].TESTS_ALL + t[i-3].TESTS_ALL + t[i-2].TESTS_ALL + t[i-1].TESTS_ALL + t[i-0].TESTS_ALL; const tests_pos = t[i-6].TESTS_POSITIVE + t[i-5].TESTS_POSITIVE + t[i-4].TESTS_POSITIVE + t[i-3].TESTS_POSITIVE + t[i-2].TESTS_POSITIVE + t[i-1].TESTS_POSITIVE + t[i-0].TESTS_POSITIVE; //const rate = cases/tests; const rate = tests_pos/tests; result.push({DATE: c[i].DATE, PROVINCE: province, CASES: cases, TESTS_ALL: tests, TESTS_POSITIVE: tests_pos, RATE: rate}); } }); return result; }3e:T68b,hospitalisations = { const result = []; const grouped = d3a.rollup(raw_hospitalisations, v => d3.sum(v, d => d.NEW_IN), d => d.DATE, d => d.PROVINCE); hospi_dates.forEach(date => { provinces.forEach(province => { result.push({DATE: date, PROVINCE: province, CASES: grouped.get(date).get(province) ? grouped.get(date).get(province) : 0}); }); const vl = (grouped.get(date).get("Antwerpen") ? grouped.get(date).get("Antwerpen") : 0) + (grouped.get(date).get("Limburg") ? grouped.get(date).get("Limburg") : 0) + (grouped.get(date).get("WestVlaanderen") ? grouped.get(date).get("WestVlaanderen") : 0) + (grouped.get(date).get("OostVlaanderen") ? grouped.get(date).get("OostVlaanderen") : 0) + (grouped.get(date).get("VlaamsBrabant") ? grouped.get(date).get("VlaamsBrabant") : 0); const wal = (grouped.get(date).get("Liège") ? grouped.get(date).get("Liège") : 0) + (grouped.get(date).get("BrabantWallon") ? grouped.get(date).get("BrabantWallon") : 0) + (grouped.get(date).get("Luxembourg") ? grouped.get(date).get("Luxembourg") : 0) + (grouped.get(date).get("Hainaut") ? grouped.get(date).get("Hainaut") : 0) + (grouped.get(date).get("Namur") ? grouped.get(date).get("Namur") : 0); const bru = grouped.get(date).get("Brussels") ? grouped.get(date).get("Brussels") : 0; const un = grouped.get(date).get(undefined) ? grouped.get(date).get(undefined) : 0; result.push({DATE: date, PROVINCE: "Vlaanderen", CASES: vl}); result.push({DATE: date, PROVINCE: "Wallonië", CASES: wal}); result.push({DATE: date, PROVINCE: "België", CASES: vl + wal + bru + un}); }); return result; }3f:Td43,tests = { const result = []; const grouped = d3a.rollup(raw_tests, v => {return {TESTS_ALL: v[0].TESTS_ALL, TESTS_POSITIVE: v[0].TESTS_ALL_POS}}, d => d.DATE, d => d.PROVINCE); dates.forEach(date => { provinces.forEach(province => { result.push({ DATE: date, PROVINCE: province, TESTS_ALL: grouped.get(date).get(province) ? grouped.get(date).get(province).TESTS_ALL : 0, TESTS_POSITIVE: grouped.get(date).get(province) ? grouped.get(date).get(province).TESTS_POSITIVE : 0 }); }); const vl_all = (grouped.get(date).get("Antwerpen") ? grouped.get(date).get("Antwerpen").TESTS_ALL : 0) + (grouped.get(date).get("Limburg") ? grouped.get(date).get("Limburg").TESTS_ALL : 0) + (grouped.get(date).get("WestVlaanderen") ? grouped.get(date).get("WestVlaanderen").TESTS_ALL : 0) + (grouped.get(date).get("OostVlaanderen") ? grouped.get(date).get("OostVlaanderen").TESTS_ALL : 0) + (grouped.get(date).get("VlaamsBrabant") ? grouped.get(date).get("VlaamsBrabant").TESTS_ALL : 0); const vl_pos = (grouped.get(date).get("Antwerpen") ? grouped.get(date).get("Antwerpen").TESTS_POSITIVE : 0) + (grouped.get(date).get("Limburg") ? grouped.get(date).get("Limburg").TESTS_POSITIVE : 0) + (grouped.get(date).get("WestVlaanderen") ? grouped.get(date).get("WestVlaanderen").TESTS_POSITIVE : 0) + (grouped.get(date).get("OostVlaanderen") ? grouped.get(date).get("OostVlaanderen").TESTS_POSITIVE : 0) + (grouped.get(date).get("VlaamsBrabant") ? grouped.get(date).get("VlaamsBrabant").TESTS_POSITIVE : 0); const wal_all = (grouped.get(date).get("Liège") ? grouped.get(date).get("Liège").TESTS_ALL : 0) + (grouped.get(date).get("BrabantWallon") ? grouped.get(date).get("BrabantWallon").TESTS_ALL : 0) + (grouped.get(date).get("Luxembourg") ? grouped.get(date).get("Luxembourg").TESTS_ALL : 0) + (grouped.get(date).get("Hainaut") ? grouped.get(date).get("Hainaut").TESTS_ALL : 0) + (grouped.get(date).get("Namur") ? grouped.get(date).get("Namur").TESTS_ALL : 0); const wal_pos = (grouped.get(date).get("Liège") ? grouped.get(date).get("Liège").TESTS_POSITIVE : 0) + (grouped.get(date).get("BrabantWallon") ? grouped.get(date).get("BrabantWallon").TESTS_POSITIVE : 0) + (grouped.get(date).get("Luxembourg") ? grouped.get(date).get("Luxembourg").TESTS_POSITIVE : 0) + (grouped.get(date).get("Hainaut") ? grouped.get(date).get("Hainaut").TESTS_POSITIVE : 0) + (grouped.get(date).get("Namur") ? grouped.get(date).get("Namur").TESTS_POSITIVE : 0); const bru_all = grouped.get(date).get("Brussels") ? grouped.get(date).get("Brussels").TESTS_ALL : 0; const bru_pos = grouped.get(date).get("Brussels") ? grouped.get(date).get("Brussels").TESTS_POSITIVE : 0; const un_all = grouped.get(date).get(undefined) ? grouped.get(date).get(undefined).TESTS_ALL : 0; const un_pos = grouped.get(date).get(undefined) ? grouped.get(date).get(undefined).TESTS_POSITIVE : 0; result.push({DATE: date, PROVINCE: "Vlaanderen", TESTS_ALL: vl_all, TESTS_POSITIVE: vl_pos}); result.push({DATE: date, PROVINCE: "Wallonië", TESTS_ALL: wal_all, TESTS_POSITIVE: wal_pos}); result.push({DATE: date, PROVINCE: "België", TESTS_ALL: vl_all + wal_all + bru_all + un_all, TESTS_POSITIVE: vl_pos + wal_pos + bru_pos + un_pos}); }); return result; }40:[] 32:{"id":"01d654dd666b5b22","slug":"covid-19-in-belgie-een-overzicht","title":"COVID-19 in België: een overzicht","thumbnail":"6bdb4a9236f5292addd24f87d7e82c3267b7d6bafd5141b0e4b3259ae82e8a03","access_level":"public","create_time":"$D2020-07-11T10:09:22.655Z","update_time":"$D2022-08-19T08:04:43.291Z","view_time":null,"first_public_time":"$D2020-07-12T09:58:42.125Z","has_unpublished_edits":null,"fork":false,"stars":16,"starred":false,"owner":{"type":"team","id":"1f20537af0cde79f","login":"bmesuere","name":"Bart Mesuere","avatar_url":"https://avatars-next.observableusercontent.com/eb2388e453b68d683131930d7e0b914d9c3d26dc21802c4e3c852e91ae6e1799","tier":"starter_2024"},"version":2417,"publish_version":2417,"role":null,"authored":false,"authors":[{"type":"individual","id":"d42baac23e3ffb5f","login":"bmesuere","name":"Bart Mesuere","avatar_url":"https://avatars-next.observableusercontent.com/eb2388e453b68d683131930d7e0b914d9c3d26dc21802c4e3c852e91ae6e1799","tier":null}],"members":[{"type":"individual","id":"d42baac23e3ffb5f","login":"bmesuere","name":"Bart Mesuere","avatar_url":"https://avatars-next.observableusercontent.com/eb2388e453b68d683131930d7e0b914d9c3d26dc21802c4e3c852e91ae6e1799","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":14,"collection":{"id":"15f1b04221d4e188","slug":"covid","title":"COVID","owner":{"id":"1f20537af0cde79f","login":"bmesuere","name":"Bart Mesuere"}},"type":"notebook","body":{"title":"COVID-19 in België: een overzicht","cells":[{"id":0,"value":"md`# COVID-19 in België: een overzicht\nDeze pagina bevat steeds de meest recente cijfers die door Sciensano gepubliceerd werden.\n\nEnkel op **dinsdag en vrijdag** zijn er cijferupdates van Sciensano. Op andere dagen zijn de gegevens in deze tabel mogelijk **NIET correct**.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1403,"value":"md`Gisteren waren er **${recent_national_hospitalisations.slice(-1)[0].NEW_IN}** nieuwe ziekenhuisopnames. Er liggen nu **${recent_national_hospitalisations.slice(-1)[0].TOTAL_IN}** (${extra_hospital}) covid-patiënten in het ziekenhuis, waarvan **${recent_national_hospitalisations.slice(-1)[0].TOTAL_IN_ICU}** (${extra_icu}) op IC. Op ${d3.timeFormat(\"%a\")(Date.parse(d_4)) == \"Sat\" ? \"zaterdag\" : d3.timeFormat(\"%a\")(Date.parse(d_4)) == \"Sun\" ? \"zondag\" : \"\"} **${d3.timeFormat(\"%d/%m\")(Date.parse(d_4))}** waren er **${last_10_days.find(d => d.DATE == d_4).CASES}** nieuwe bevestigde besmettingen.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"function row(displayName, name, agg) {\n let level = levels[name];\n level = \"transparent\";\n return html`\n\n ${displayName}
${d3.format(\".3s\")(population[name])} inwoners\n ${casesTrend(name)}\n ${casesGraph(name)}\n ${incidenceGraph(name)}\n ${rateGraph(name)}\n ${hospitalisationsTrend(name)}\n ${hospitalisationsGraph(name)}\n`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"function casesGraph(province, days=16, skipLast=0) {\n let c = avg_cases\n .filter(c => c.PROVINCE === province)\n .slice(-1 * (days + skipLast));\n if (skipLast > 0) {\n c = c.slice(0, -1 * skipLast);\n }\n return baselessProjectedMiniGraph(c.map(c => c.CASES), population[province]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"function casesTrend(province, days=14, skipLast=2) {\n let c = avg_cases\n .filter(c => c.PROVINCE === province)\n .slice(-1 * (days + skipLast));\n if (skipLast > 0) {\n c = c.slice(0, -1 * skipLast);\n }\n c = c.map(c => c.CASES);\n //return trend(c[0], c[c.length -1]);\n return trend(c[6], c[c.length -1]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":759,"value":"function trend(begin, end, cutoff = 0.05, addBreak = true, cutoff2 = 1) {\n let change = (-1 + end / begin);\n change = change == Infinity ? 1 : change;\n let changeText = (change > 0 ? \"+\" : \"\") + d3.format(\".0%\")(change);\n if (begin / 7 < cutoff2 && end / 7 < cutoff2) {\n changeText = \" —\";\n change = 0;\n }\n let trend = \"stabiel\";\n if (change > cutoff) {\n trend = \"stijgend\";\n } else if (change < -1 * cutoff) {\n trend = \"dalend\";\n }\n //const trendText = `${trend}`;\n const trendText = `${changeText === \" —\" ? \"stabiel\" : \"per week\"}`;\n const breakText = addBreak ? \"
\" : \"\";\n return `

${changeText} ${breakText} ${trendText}

`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"function incidence(province, days=14, skipLast=2) {\n let c = avg_cases\n .filter(c => c.PROVINCE === province)\n .slice(-1 * (days + skipLast));\n if (skipLast > 0) {\n c = c.slice(0, -1 * skipLast);\n }\n c = c.map(c => c.CASES);\n return (c[c.length - 1] + c[c.length - 8]) / population[province] * 100000;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"function incidenceGraph(province, width = 150, height = 16) {\n const warn = 50;\n const alert = 200;\n const error = 500\n const max = 500;\n const i = incidence(province);\n const x = d3.scaleLinear().domain([0, max]).range([0, width]);\n const c = DOM.context2d(width, height);\n c.fillStyle = lightFill;\n c.fillRect(0, 0, x(max), height);\n \n if (i < warn) {\n c.fillStyle = green;\n } else if (i < alert) {\n c.fillStyle = orange;\n } else if (i < error) {\n c.fillStyle = red;\n } else {\n c.fillStyle = purple;\n }\n c.fillRect(0, 0, x(i), height);\n \n const text = c.measureText(d3.format(\".1f\")(i));\n if (i >= 500) {\n c.fillStyle = \"white\";\n c.fillText(d3.format(\".1f\")(i), x(i) - text.width - 4, height / 2 + 4);\n } else {\n c.fillText(d3.format(\".1f\")(i), x(i) + 4, height / 2 + 4);\n }\n \n return c.canvas;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"function hospitalisationsGraph(province, days=14, skipLast=0) {\n let c = avg_hospitalisations\n .filter(c => c.PROVINCE === province)\n .slice(-1 * (days + skipLast));\n if (skipLast > 0) {\n c = c.slice(0, -1 * skipLast);\n }\n return miniGraph(c.map(c => c.CASES), population[province]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1197,"value":"function rateGraph(province, days=14, skipLast=2) {\n let c = avg_cases\n .filter(c => c.PROVINCE === province)\n .slice(-1 * (days + skipLast));\n if (skipLast > 0) {\n c = c.slice(0, -1 * skipLast);\n }\n return percentMiniGraph(c.map(c => c.RATE));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"function hospitalisationsTrend(province, days=14, skipLast=0) {\n let c = avg_hospitalisations\n .filter(c => c.PROVINCE === province)\n .slice(-1 * (days + skipLast));\n if (skipLast > 0) {\n c = c.slice(0, -1 * skipLast);\n }\n c = c.map(c => c.CASES);\n //return trend(c[0], c[c.length -1], 0.2);\n return trend(c[6], c[c.length -1], 0.05);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1214,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1947,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1109,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":551,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":693,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":733,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1335,"value":"levels = {\n return {\n Antwerpen: purple,\n Brussels: purple,\n Liège: purple,\n Limburg: purple,\n OostVlaanderen: purple,\n VlaamsBrabant: purple,\n WestVlaanderen: purple,\n BrabantWallon: purple,\n Hainaut: purple,\n Namur: purple,\n Luxembourg: purple,\n Vlaanderen: purple,\n Wallonië: purple,\n België: purple,\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":915,"value":"md`**Recent data**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":440,"value":"lastCasesBelgium = avg_cases.filter(c => c.PROVINCE === \"België\").slice(-16,-2)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"last_10_days = cases.filter(c => c.PROVINCE === \"België\").splice(-10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2335,"value":"**Dagcijfers bevestigde besmettingen**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1425,"value":"printTable(cases.filter(c => c.PROVINCE === \"België\").splice(-14).map(d => {return {DATE: d.DATE, DAY: d3.timeFormat(\"%a\")(new Date(d.DATE)), CASES: d.CASES}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"last_10_days_corrected = projected_cases.filter(c => c.PROVINCE === \"België\").splice(-10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2136,"value":"md`The last 2 rows contain extrapolated data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1429,"value":"printTable(last_10_days_corrected.map(d => {return {DATE: d.DATE, DAY: d3.timeFormat(\"%a\")(new Date(d.DATE)), CASES: d.CASES}}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":460,"value":"lastHospiBelgium = avg_hospitalisations.filter(c => c.PROVINCE === \"België\").slice(-14)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":884,"value":"last_hospitalisations= hospitalisations.filter(h => h.DATE == d_1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1441,"value":"printTable(last_hospitalisations)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":925,"value":"last_raw_hospitalisations= raw_hospitalisations.filter(h => h.DATE == d_1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":726,"value":"recent_national_hospitalisations = national_hospitalisations.slice(-15)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2339,"value":"**Dagcijfers hospitalisaties**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1432,"value":"printTable(recent_national_hospitalisations.map(d => Object.assign({DAY: d3.timeFormat(\"%a\")(new Date(d.DATE))}, d)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2344,"value":"**Dagcijfers overlijdens**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1609,"value":"printTable(deaths.slice(-14))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2227,"value":"deaths.filter(d => d.DEATHS === 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1586,"value":"extra_hospital = {\n const r = recent_national_hospitalisations.slice(-1)[0].TOTAL_IN - recent_national_hospitalisations.slice(-2)[0].TOTAL_IN;\n return r > 0 ? \"+\" + r : \"\" + r;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1590,"value":"extra_icu = {\n const r = recent_national_hospitalisations.slice(-1)[0].TOTAL_IN_ICU - recent_national_hospitalisations.slice(-2)[0].TOTAL_IN_ICU;\n return r > 0 ? \"+\" + r : \"\" + r;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":898,"value":"md`**R values**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"r_values = {\n const cases_belgium = avg_cases.filter(c => c.PROVINCE === \"België\");\n return cases_belgium.map((c, i) => {\n if (i < 7) return 0;\n //return {date: c.DATE, r: (cases_belgium[i-3].CASES+cases_belgium[i-2].CASES+cases_belgium[i-1].CASES+cases_belgium[i].CASES) / (cases_belgium[i-7].CASES+cases_belgium[i-6].CASES+cases_belgium[i-5].CASES+cases_belgium[i-4].CASES)};\n return {date: c.DATE, r: (cases_belgium[i].CASES / cases_belgium[i-4].CASES), Regio: \"België\"};\n}).slice(-30)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"r_values_provinces = {\n let result = [];\n extendedProvinces.filter(p => p !== undefined).forEach(p => {\n const ca = avg_cases.filter(c => c.PROVINCE === p);\n result = result.concat(ca.map((c, i) => {\n if (i < 7) return 0;\n return {date: c.DATE, r: (ca[i].CASES / ca[i-4].CASES), Regio: p, predicted: false};\n }).slice(-30, -2));\n });\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"r_values_provinces_projected = {\n let result = [];\n extendedProvinces.filter(p => p !== undefined).forEach(p => {\n const ca = avg_cases.filter(c => c.PROVINCE === p);\n result = result.concat(ca.map((c, i) => {\n if (i < 7) return 0;\n return {date: c.DATE, r: (ca[i].CASES / ca[i-4].CASES), Regio: p, predicted: true};\n }).slice(-3));\n });\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":827,"value":"{\n const lines = vl.markLine().encode(\n vl.x().fieldT(\"date\").title(false), \n vl.y().fieldQ(\"r\").title(\"R\").scale({type: \"log\", domain: [1/3, 3], nice: false}), \n vl.color().fieldN(\"Regio\").legend(null), \n vl.tooltip().fieldQ(\"r\"),\n vl.strokeDash().fieldN(\"predicted\").legend(null)\n );\n const rules = vl.markRule().data({\"values\": [{\"ref\": 1}]}).encode(vl.y().fieldQ(\"ref\"));\n \n return vl.layer(rules, lines)\n .width(150)\n .height(200)\n .facet({field: \"Regio\", title: null, sort: [\"Antwerpen\", \"Limburg\", \"OostVlaanderen\", \"VlaamsBrabant\", \"WestVlaanderen\", \"Hainaut\", \"Liège\", \"Luxembourg\", \"Namur\", \"BrabantWallon\", \"Brussels\"]}).columns(5)\n .resolve({scale: {x: 'independent'}})\n .data(r_values_provinces/*.concat(r_values_provinces_projected)*/)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":895,"value":"md`**Calculate and project cases**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"raw_cases = (await fetch(`https://epistat.sciensano.be/Data/COVID19BE_CASES_AGESEX.json?date=${today}`)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"projected_cases = cases.map(project).filter(c => c !== null)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"function project(c) {\n if (c.DATE === today || c.DATE === d_1) {\n return null;\n }\n if (c.DATE === d_2) {\n const copy = Object.assign({}, c);\n copy.CASES = copy.CASES / projections[d3.timeFormat(\"%a\")(Date.parse(d_2))][1];\n return copy;\n }\n if (c.DATE === d_3) {\n const copy = Object.assign({}, c);\n copy.CASES = copy.CASES / projections[d3.timeFormat(\"%a\")(Date.parse(d_3))][2]\n return copy;\n }\n return c;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":633,"value":"projections = {\n return {\n Mon: [0, 0.43, 0.96, 0.98, 0.98],\n Tue: [0, 0.50, 0.96, 0.99, 0.98],\n Wed: [0, 0.49, 0.96, 0.99, 0.98],\n Thu: [0, 0.50, 0.96, 0.98, 0.98],\n Fri: [0, 0.49, 0.94, 0.97, 0.98],\n Sat: [0, 0.50, 0.94, 0.98, 0.98],\n Sun: [0, 0.45, 0.99, 0.99, 0.99]\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1237,"value":"avg_cases.slice(-10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1501,"value":"hospiLevel = function (population, limit) {\n return limit * population / 100000;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1760,"value":"hospiLevel2 = function (pop, limit) {\n return limit / population[\"België\"] * pop * 7;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":911,"value":"md`**Calculate hospitalisations**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"raw_hospitalisations = (await fetch(`https://epistat.sciensano.be/Data/COVID19BE_HOSP.json?date=${today}`\n)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":712,"value":"national_hospitalisations = {\n const result = [];\n const grouped = d3a.rollup(raw_hospitalisations, v => {\n return {\n DATE : v[0].DATE,\n NEW_IN : d3.sum(v, d => d.NEW_IN),\n NEW_OUT : d3.sum(v, d => d.NEW_OUT),\n TOTAL_IN : d3.sum(v, d => d.TOTAL_IN),\n TOTAL_IN_ECMO : d3.sum(v, d => d.TOTAL_IN_ECMO),\n TOTAL_IN_ICU : d3.sum(v, d => d.TOTAL_IN_ICU),\n TOTAL_IN_RESP : d3.sum(v, d => d.TOTAL_IN_RESP),\n };\n }, d => d.DATE);\n return Array.from(grouped.values());\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":315,"value":"avg_hospitalisations = {\n const result = [];\n const grouped = d3a.rollup(hospitalisations, v => v, d => d.PROVINCE);\n extendedProvinces.forEach(province => {\n const c = grouped.get(province);\n for (let i = 6; i < c.length; i++) {\n const sum = c[i-6].CASES + c[i-5].CASES + c[i-4].CASES + c[i-3].CASES + c[i-2].CASES + c[i-1].CASES + c[i-0].CASES;\n result.push({DATE: c[i].DATE, PROVINCE: province, CASES: sum});\n }\n });\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1172,"value":"md`**Calculate tests**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1176,"value":"raw_tests = (await fetch(\"https://epistat.sciensano.be/Data/COVID19BE_tests.json\")).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1179,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1595,"value":"raw_deaths = (await fetch(\"https://epistat.sciensano.be/Data/COVID19BE_MORT.json\")).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1599,"value":"deaths = {\n const result = [];\n const grouped = d3a.rollup(raw_deaths, v => d3.sum(v, d => d.DEATHS), d => d.DATE);\n dates.forEach(date => {\n result.push({DATE: date, DEATHS: grouped.get(date) ? grouped.get(date) : 0});\n });\n for (let i = 6; i < result.length; i++) {\n result[i].AVG_DEATHS = (result[i - 6].DEATHS + result[i - 5].DEATHS + result[i - 4].DEATHS + result[i - 3].DEATHS + result[i - 2].DEATHS + result[i - 1].DEATHS + result[i].DEATHS) / 7;\n }\n return result.slice(0,-1);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1907,"value":"md`**Vaccines**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1910,"value":"raw_vaccines = d3.csv(\"https://raw.githubusercontent.com/bmesuere/covid/master/data/vaccines_cumulative.csv\", d => {return {DATE: d.DATE, REGION: d.REGION, VACCINES_TOTAL: +d.VACCINES_TOTAL}});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2020,"value":"vaccines = {\n const result = [];\n vaccine_regions.forEach(region => {\n const v = raw_vaccines.filter(d => d.REGION === region);\n const c = Object.assign({}, v[0]);\n c.VACCINES_ADDED = c.VACCINES_TOTAL;\n result.push(c);\n for (let i = 1; i < v.length; i++) {\n const c = Object.assign({}, v[i]);\n c.VACCINES_ADDED = c.VACCINES_TOTAL - v[i - 1].VACCINES_TOTAL;\n result.push(c);\n }\n });\n return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2060,"value":"vaccine_population = 941227 + 5343806 + 2895568","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2013,"value":"vaccine_dates = Array.from(new Set(raw_vaccines.map(d => d.DATE)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2023,"value":"vaccine_regions = Array.from(new Set(raw_vaccines.map(d => d.REGION)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1927,"value":"total_vaccines = d3.format(\",\")(vaccines.filter(v => v.REGION === \"Belgium\").slice(-1)[0].VACCINES_TOTAL).replaceAll(\",\", \" \")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1939,"value":"added_vaccines = d3.format(\",\")(+vaccines.filter(v => v.REGION === \"Belgium\").slice(-1)[0].VACCINES_TOTAL - +vaccines.filter(v => v.REGION === \"Belgium\").slice(-2)[0].VACCINES_TOTAL).replaceAll(\",\", \" \")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2063,"value":"vaccine_percentage = d3.format(\".0f\")(100*vaccines.filter(v => v.REGION === \"Belgium\").slice(-1)[0].VACCINES_TOTAL / population[\"België\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2193,"value":"import {percentPartly, percentFully, percentBoostered} from \"@bmesuere/vaccinatiestatus-in-belgie\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2198,"value":"percentAtLeastPartly = percentPartly + percentFully","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":928,"value":"md`**Other stuff**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":607,"value":"today = d3.timeFormat(\"%Y-%m-%d\")(d3.timeHour.offset(Date.now(), -4))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":614,"value":"d_1 = d3.timeFormat(\"%Y-%m-%d\")(d3.timeDay.offset(Date.parse(today), -1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":618,"value":"d_2 = d3.timeFormat(\"%Y-%m-%d\")(d3.timeDay.offset(Date.parse(today), -2))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":620,"value":"d_3 = d3.timeFormat(\"%Y-%m-%d\")(d3.timeDay.offset(Date.parse(today), -3))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1139,"value":"d_4 = d3.timeFormat(\"%Y-%m-%d\")(d3.timeDay.offset(Date.parse(today), -4))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"dates = Array.from(new Set(raw_cases.map(c => c.DATE))).filter(d => d).filter(d => new Date(d) >= new Date(\"2020-03-01\")).sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"hospi_dates = Array.from(new Set(raw_hospitalisations.map(c => c.DATE))).filter(d => d)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"provinces = Array.from(new Set(raw_cases.map(c => c.PROVINCE)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":380,"value":"extendedProvinces = new Array(...provinces, \"Vlaanderen\", \"Wallonië\", \"België\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":230,"value":"population = {\n return {\n Antwerpen: 1872841,\n Brussels: 1214550,\n Liège: 1107937,\n Limburg: 879933,\n OostVlaanderen: 1530773,\n VlaamsBrabant: 1161430,\n WestVlaanderen: 1202529,\n BrabantWallon: 407377,\n Hainaut: 1344483,\n Namur: 496795,\n Luxembourg: 288515,\n Vlaanderen: 6647506,\n Wallonië: 3645243,\n België: 11507163,\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1259,"value":"purple= \"#66023C\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"red = \"#c71e1d\";","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"green = \"#016351\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"orange = \"#ffbf00\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1303,"value":"yellow = \"#fcf75e\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"neutral = \"#777\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"lightFill = \"#eee\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1123,"value":"mediumFill = \"#bbb\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1276,"value":"mediumStroke = \"#ccc\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"darkFill = \"#888\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"d3 = require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"d3a = require(\"d3-array@^2.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"import {vl} from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1418,"value":"import {printTable} from '@uwdata/data-utilities'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2276,"value":"percent = {\n const p = projected_cases.filter(c => c.PROVINCE === \"België\").filter(d => d.DATE > \"2021-08-01\").filter(d => d.DATE < d_1);\n const result = [];\n for (let i = 7; i < p.length; i++) {\n const t = Object.assign({}, p[i]);\n //if (t.DATE === \"2021-11-27\") t.CASES = 11539;\n //if (t.DATE === \"2021-11-28\") t.CASES = 7024;\n //if (t.DATE === \"2021-11-29\") t.CASES = 26000;\n t.RATIO = t.CASES / p[i-7].CASES;\n t.DAY = d3.timeFormat(\"%A\")(new Date(t.DATE));\n t.WEEKEND = t.DAY === \"Saturday\" || t.DAY === \"Sunday\";\n result.push(t);\n }\n return result;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2291,"value":"vl.markCircle()\n .encode(\n vl.x().fieldT(\"DATE\").title(false),\n vl.y().fieldQ(\"RATIO\").scale({domainMax: 3}).axis({format: \"%\"}).title(false),\n vl.color().field(\"WEEKEND\").legend(false)\n )\n .title(\"Procentueel verschil dagcijfers, week over week\")\n .data(\n percent\n .filter(d => d.DATE !== \"2021-11-01\")\n .filter(d => d.DATE !== \"2021-11-11\")\n .filter(d => d.DATE !== \"2021-11-08\")\n .filter(d => d.DATE !== \"2021-11-18\")\n )\n .render()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W40","stdlib":"1","titling":"auto"}} 33:"$32:body"