31:T4a0,munged = pipe( await d3.csv( `https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv`, d3.autoType ), (arr) => arr .filter((d) => d.county === `New York City`) .map((row) => { const { date: dateObject, cases: value } = row; return { ...row, dateObject, dateString: d3.utcFormat(`%Y-%m-%d`)(dateObject) }; }), (arr) => d3 .rollups( arr, (arr) => d3.sum(arr, (d) => d.cases), (d) => d.dateObject ) .map(([dateObject, value]) => ({ dateObject, casesTotal: value })) .sort((a, b) => d3.ascending(a[0], b[0])) .map((d, index) => ({ ...d, index })), (arr) => arr.map(getDelta({ key: `casesTotal`, outKey: `casesVelocity` })), (arr) => addTrends(arr, { yKey: `casesVelocity`, bandwidth: 0.03 }), (arr) => arr.map( getDelta({ key: `casesVelocityLoess`, outKey: `casesAcceleration` }) ), // (arr) => addTrends(arr, { yKey: `casesAcceleration`, bandwidth: 0.05 }), (arr) => arr.map(getDelta({ key: `casesAcceleration`, outKey: `casesJerk` })) // (arr) => addTrends(arr, { yKey: `casesJerk` }) )32:[] 2f:{"title":"Covid Acceleration in New York City","cells":[{"id":0,"value":"# Covid Acceleration in New York City","pinned":false,"hidden":false,"mode":"md"},{"id":237,"value":"Based on [_A new way to visualize the surge in Covid-19 cases in the U.S._](https://www.statnews.com/2021/07/26/new-way-visualize-covid-19-case-surge-us/) by [Emory Parker](https://twitter.com/jaspar)","pinned":false,"hidden":false,"mode":"md"},{"id":242,"value":"Data from [The New York Times](https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv)","pinned":false,"hidden":false,"mode":"md"},{"id":219,"value":"### Total Cases","pinned":false,"hidden":false,"mode":"md"},{"id":6,"value":"Plot.plot({\n width,\n height: plotHeight,\n x: {\n nice: true,\n label: null,\n domain: xDomain,\n ticks: 5\n },\n y: {\n tickFormat: \"s\",\n zero: true,\n nice: true,\n label: null\n },\n marks: [\n Plot.ruleY([0], { stroke: \"black\", strokeOpacity: 0.2 }),\n Plot.line(munged, { x: \"dateObject\", y: \"casesTotal\", strokeWidth: 0.7 })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":225,"value":"### Case Velocity","pinned":false,"hidden":false,"mode":"md"},{"id":67,"value":"Chart(munged, {\n yKey: `casesVelocityLoess`,\n marks: [\n Plot.line(munged, {\n x: `dateObject`,\n y: `casesVelocity`,\n strokeWidth: 0.5,\n strokeOpacity: 0.5\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":229,"value":"### Case Acceleration","pinned":false,"hidden":false,"mode":"md"},{"id":106,"value":"Chart(munged, { yKey: `casesAcceleration` })","pinned":false,"hidden":false,"mode":"ojs"},{"id":302,"value":"### Case [Jerk](https://en.wikipedia.org/wiki/Jerk_%28physics%29)","pinned":false,"hidden":false,"mode":"md"},{"id":289,"value":"Chart(munged, { yKey: `casesJerk` })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1190,"value":"function Chart(data, { xKey = `dateObject`, yKey, marks = [] }) {\n return Plot.plot({\n width,\n height: plotHeight,\n x: {\n nice: true,\n label: null,\n domain: xDomain,\n ticks: 5\n },\n y: {\n tickFormat: \"s\",\n zero: true,\n nice: 7,\n label: null\n },\n marks: [\n Plot.ruleY([0], { stroke: \"black\", strokeOpacity: 0.2 }),\n ...aboveBelow(data, { yKey }),\n ...marks\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":321,"value":"{\n const formatNumber = d3.format(`,.0f`);\n\n const columns = [\n [\n \"Date\",\n \"dateObject\",\n (dateString) => d3.utcFormat(`%Y-%m-%d`)(new Date(dateString))\n ],\n [\"Total\", \"casesTotal\", d3.format(`.4s`)],\n [\"Velocity\", \"casesVelocityLoess\", formatNumber],\n [\"Acceleration\", \"casesAcceleration\", formatNumber],\n [\"Jerk\", \"casesJerk\", formatNumber]\n ];\n\n const rows = munged\n .map((d) => d)\n .filter((d, i, arr) => i > arr.length - 10)\n .map((d) => {\n return html`\n

\n ${columns.map(([, key, format]) => html`${format(d[key])}`)}\n

`;\n });\n\n return html`\n\n

\n${columns.map((d) => d[0]).map((d) => html`${d}`)}\n

\n ${rows}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":716,"value":"config = ({\n projection: {\n x: `dateString`,\n strokeWidth: 1,\n strokeDasharray: [2, 2]\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":560,"value":"bandwidth = 0.035","pinned":false,"hidden":false,"mode":"ojs"},{"id":551,"value":"xTicks = 10","pinned":false,"hidden":false,"mode":"ojs"},{"id":646,"value":"xDomain = [new Date(\"2020\"), d3.max(munged, (d) => d.dateObject)]","pinned":false,"hidden":false,"mode":"ojs"},{"id":233,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":198,"value":"plotHeight = 250","pinned":false,"hidden":false,"mode":"ojs"},{"id":440,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":882,"value":"function aboveBelow(data, { xKey = `dateObject`, yKey }) {\n return [\n Plot.area(\n filterAboveBelow(data, {\n above: true,\n key: yKey\n }),\n {\n x1: xKey,\n y1: 0,\n y2: yKey,\n fill: \"red\",\n fillOpacity: 0.2\n }\n ),\n Plot.area(\n filterAboveBelow(data, {\n above: false,\n key: yKey\n }),\n {\n x1: xKey,\n y1: 0,\n y2: yKey,\n fill: \"green\",\n fillOpacity: 0.2\n }\n ),\n Plot.line(data, {\n x: xKey,\n y: yKey,\n strokeWidth: 0.5,\n strokeOpacity: 1\n })\n ];\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":354,"value":"function filterAboveBelow(array, { above, key }) {\n return array.map((d) => {\n const value = d[key];\n const check = above ? value > 0 : value < 0;\n return { ...d, [key]: check ? value : null };\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":910,"value":"function addTrends(array, { yKey, bandwidth }) {\n return pipe(array, (array) =>\n addLoess(array, {\n bandwidth,\n xKey: `index`,\n yKey,\n outKey: `${yKey}Loess`\n })\n );\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1066,"value":"function addLoess(\n array,\n {\n bandwidth = 0.75,\n xKey,\n yKey,\n outKey = `${yKey}Loess`,\n xAccessor = (d) => d[xKey],\n yAccessor = (d) => d[yKey]\n }\n) {\n const filtered = array.filter(\n (d) => Number.isFinite(xAccessor(d)) && Number.isFinite(yAccessor(d))\n );\n const x = filtered.map(xAccessor);\n const y = filtered.map(yAccessor);\n const model = new Loess(\n {\n x,\n y\n },\n { span: bandwidth }\n );\n const fitted = model.predict().fitted;\n const indexToFit = Object.fromEntries(\n fitted.map((d, i) => [filtered[i].index, d])\n );\n // const fitted = fit.fitted.map((d, i) => ({ index: xFiltered[i], value: d }));\n // console.log(\"SLERB\", indexToFit);\n // console.log(\"far\", filtered);\n return array.map((d) => ({ ...d, [outKey]: indexToFit[d.index] }));\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":93,"value":"function getDelta({ key, outKey }) {\n return (d, i, arr) => {\n const prev = arr[i - 1];\n const delta = prev ? d[key] - prev[key] : null;\n return {\n ...d,\n [outKey]: delta\n };\n };\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":438,"value":"async function pipe(arg, ...fns) {\n let out = arg;\n for (const func of fns) {\n out = await func(out);\n }\n return out;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":608,"value":"science = require(\"@sgratzl/science\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1064,"value":"Loess = (await import(\"https://cdn.skypack.dev/loess\")).default","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}