31:T6aa,casesTable = (heading, data, nicefilterfunc) => html`

${heading}	${data[0].Date_of_publication.toLocaleString("nl-NL", { day: "numeric", month: "short", year: "numeric" })}	14-daagse verandering	Trend
Nieuwe besmettingen	${data[0].Total_reported}	${ Math.sign(weeklyChange('Total_reported', data)) === 1 ? '+' : '' }${weeklyChange('Total_reported', data).toFixed(0)}%	${sparkline( data .map(el => el.Total_reported_avg) .slice(0, 14) .reverse() )}
Nieuwe ziekenhuisopnames	${nicedata(nicefilterfunc)[0].Hospital_admission}	${ Math.sign(weeklyChange('Hospital_admission', nicedata(nicefilterfunc))) === 1 ? '+' : '' }${weeklyChange('Hospital_admission', nicedata(nicefilterfunc)).toFixed(0)}%	${sparkline( nicedata(nicefilterfunc) .map(el => el.Hospital_admission_avg) .slice(0, 14) .reverse() )}
Nieuwe doden	${data[0].Deceased}	${ Math.sign(weeklyChange('Deceased', data)) === 1 ? '+' : '' }${weeklyChange('Deceased', data).toFixed(0)}%	${sparkline( data .map(el => el.Deceased_avg) .slice(0, 14) .reverse() )}

`32:[{"id":"f1b28e556c22949291b8361037840fc821701544ca30863da078cda94d1a84a8152613e49fbdc78ff0ffeb915b759bcf862c3c382eaa4b1e7f96f46c1204ab0d","href":"https://static.observableusercontent.com/files/f1b28e556c22949291b8361037840fc821701544ca30863da078cda94d1a84a8152613e49fbdc78ff0ffeb915b759bcf862c3c382eaa4b1e7f96f46c1204ab0d","name":"Screenshot 2020-11-17 at 23.17.38.png","type":"image/png","lastModified":1605651472160.852,"size":123852},{"id":"cdaa51b6c9fedbeb4037e579d84f1b26f1d7333973462f672cb045a79df64f7640dc4502183814ea80ff2c40083a6504ac09406759bd9d077326dbfa83e14023","href":"https://static.observableusercontent.com/files/cdaa51b6c9fedbeb4037e579d84f1b26f1d7333973462f672cb045a79df64f7640dc4502183814ea80ff2c40083a6504ac09406759bd9d077326dbfa83e14023","name":"Bevolking_op_1_januari_en_gemiddeld__geslacht__leeftijd_en_regio_26032021_174819.csv","type":"text/csv","lastModified":1616777424155.773,"size":21782}] 2f:{"title":"RIVM covid daily numbers in the Netherlands","cells":[{"id":0,"value":"md`# RIVM covid daily numbers in the Netherlands\n\nOngoing attemt to recreate this block of visualizations from nytimes.com for The Netherlands:\n\n${await FileAttachment(\"Screenshot 2020-11-17 at 23.17.38.png\").image()}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":442,"value":"casesTable('Nederland', allNL, d => d)","pinned":false,"hidden":false,"mode":"ojs"},{"id":471,"value":"casesTable('Amsterdam', allAMS, d => d.Municipality_name === \"Amsterdam\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":336,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":333,"value":"md`## Todo\n\n* hospitalizations apart inladen\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"RIVMdata = d3.dsv(\n ';',\n 'https://data.rivm.nl/covid-19/COVID-19_aantallen_gemeente_per_dag.csv',\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":504,"value":"NICEdata = \nd3.dsv(\n ';',\n 'https://data.rivm.nl/covid-19/COVID-19_ziekenhuisopnames.csv',\n d3.autoType\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":576,"value":"FileAttachment(\"Bevolking_op_1_januari_en_gemiddeld__geslacht__leeftijd_en_regio_26032021_174819.csv\").text()","pinned":true,"hidden":false,"mode":"ojs"},{"id":514,"value":"NICEdataT = NICEdata.map(el => ({\n ...el,\n Date_of_report: new Date(el.Date_of_report.replace(' ', 'T')),\n Date_of_statistics: new Date(el.Date_of_statistics),\n week: dateFns.getISOWeek(el['Date_of_statistics'])\n }))","pinned":true,"hidden":false,"mode":"ojs"},{"id":139,"value":"transformData = (data = RIVMdata) =>\n data.map(el => ({\n ...el,\n Date_of_report: new Date(el.Date_of_report.replace(' ', 'T')),\n Date_of_publication: new Date(el.Date_of_publication),\n week: dateFns.getISOWeek(el['Date_of_publication'])\n }))","pinned":true,"hidden":false,"mode":"ojs"},{"id":319,"value":"data = transformData()","pinned":true,"hidden":false,"mode":"ojs"},{"id":418,"value":"dataAms = transformData().filter(el => el.Municipality_name === 'Amsterdam')","pinned":true,"hidden":false,"mode":"ojs"},{"id":496,"value":"allNICENL = nicedata(d => d)","pinned":true,"hidden":false,"mode":"ojs"},{"id":536,"value":"allNICEAMS = nicedata(d => d.Municipality_name === \"Amsterdam\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":524,"value":"nicedata = (filterfunc) => aq\n .from(NICEdataT.filter(filterfunc))\n .groupby('Date_of_statistics')\n .rollup({\n // Total_reported: op.sum('Total_reported'),\n Hospital_admission: op.sum('Hospital_admission_notification'),\n // Deceased: op.sum('Deceased'),\n Date_of_publication: op.any('Date_of_statistics')\n }).orderby(aq.desc('Date_of_statistics'))\n .ungroup() // groups persist; ungroup to avoid downstream surprises\n.derive({\n Hospital_admission_avg: aq.rolling(op.average('Hospital_admission'), [-6, 0]),\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":80,"value":"dataAgg = (column, data) =>\n aq\n .from(data)\n .groupby([column])\n .rollup({\n Total_reported: op.sum('Total_reported'),\n Hospital_admission: op.sum('Hospital_admission'),\n Deceased: op.sum('Deceased'),\n Date_of_publication: op.any('Date_of_publication')\n })\n .orderby(aq.desc(column))\n .ungroup() // groups persist; ungroup to avoid downstream surprises\n .derive({\n Total_reported_rm: aq.rolling(op.mean('Total_reported'), [-3, 3]),\n Hospital_admission_rm: aq.rolling(op.mean('Hospital_admission'), [-3, 3]),\n Deceased_rm: aq.rolling(op.mean('Deceased'), [-3, 3]),\n Total_reported_avg: aq.rolling(op.average('Total_reported'), [-6, 0]),\n Hospital_admission_avg: aq.rolling(op.average('Hospital_admission'), [-6, 0]),\n Deceased_avg: aq.rolling(op.average('Deceased'), [-6, 0]),\n })\n .objects()","pinned":true,"hidden":false,"mode":"ojs"},{"id":415,"value":"allAMS = dataAgg('Date_of_publication', dataAms)","pinned":true,"hidden":false,"mode":"ojs"},{"id":422,"value":"allNL = dataAgg('Date_of_publication', data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":434,"value":"todayNL = allNL[0]","pinned":true,"hidden":false,"mode":"ojs"},{"id":436,"value":"todayAMS = allAMS[0]","pinned":true,"hidden":false,"mode":"ojs"},{"id":300,"value":"current7Days = (col, data) => data\n .map(el => el[col])\n .slice(0, 7).reduce((a,b)=>a+b)","pinned":true,"hidden":false,"mode":"ojs"},{"id":307,"value":"previous7Days = (col, data) => data\n .map(el => el[col])\n .slice(7, 14).reduce((a,b)=>a+b)","pinned":true,"hidden":false,"mode":"ojs"},{"id":456,"value":"weeklyChange = (col, data) =>\n ((current7Days(col, data) - previous7Days(col, data)) /\n previous7Days(col, data)) *\n 100","pinned":true,"hidden":false,"mode":"ojs"},{"id":226,"value":"aq.from(dataAgg('Date_of_publication', dataAms)).view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":270,"value":"current7Days('Hospital_admission', nicedata(d=>d))","pinned":true,"hidden":false,"mode":"ojs"},{"id":572,"value":"previous7Days('Hospital_admission', nicedata(d=>d))","pinned":true,"hidden":false,"mode":"ojs"},{"id":244,"value":"function doWMA(array, weightedPeriod) {\n var weightedArray = [];\n for (var i = 0; i <= array.length - weightedPeriod; i++) {\n var sum = 0;\n for (var j = 0; j < weightedPeriod; j++) {\n sum += array[i + j] * (weightedPeriod - j);\n }\n weightedArray[i] = sum / ((weightedPeriod * (weightedPeriod + 1)) / 2);\n }\n return weightedArray;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":255,"value":"sparkline = (values, width = 64, height = 17) => {\n const context = DOM.context2d(width, height);\n const x = d3\n .scaleLinear()\n .domain([0, values.length - 1])\n .range([0.5, width - 0.5]);\n const y = d3\n .scaleLinear()\n .domain(d3.extent(values))\n .range([height - 0.5, 0.5]);\n const line = d3\n .line()\n .x((d, i) => x(i))\n .y(y)\n .context(context);\n context.beginPath(), line(values), context.stroke();\n return context.canvas;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":4,"value":"d3 = require('d3')","pinned":true,"hidden":false,"mode":"ojs"},{"id":26,"value":"import { vl } from \"@vega/vega-lite-api\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":76,"value":"import { aq, op } from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs"},{"id":108,"value":"dateFns = await require('https://cdnjs.cloudflare.com/ajax/libs/date-fns/1.30.1/date_fns.js')","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}