29:null 2a:["$","title",null,{"children":"Brown Asymptomatic Covid-19 Testing | The Brown Daily Herald | Observable"}] 2f:T5c2,timeline = { const yAxisEl = d3.select(DOM.svg(heroMetrics.left, heroMetrics.height)); yAxisEl.style("min-width", heroMetrics.left); yAxisEl.attr("xmlns", "http://www.w3.org/2000/svg"); yAxisEl.append("g").call(yAxis); const data = smooth(rates, "rate"); const x = d3 .scaleTime() .domain(d3.extent(rates, (d) => d.date)) .range([0, heroMetrics.width - heroMetrics.right]); const chart = d3.select(DOM.svg(heroMetrics.width, heroMetrics.height)); chart .attr("xmlns", "http://www.w3.org/2000/svg") .attr("font-family", "sans-serif") .attr("font-size", 11); // chart // .append("rect") // .attr("fill", "#f0f0f0") // .attr("x", 0) // .attr("y", heroMetrics.top) // .attr("width", heroMetrics.width) // .attr("height", heroMetrics.height - heroMetrics.top - heroMetrics.bottom); chart.append("g").call(addSemesters(x)); chart.append("g").call(xAxis(x)); chart.append(rateLine(x, data)); chart.append("g").call(addAnnotations(x)); chart.call(addHoverTip(x, y, data)); return html`

↑ test positivity rate (7-day average, %)

scroll →

${yAxisEl.node()}

${chart.node()}

`; }30:T613,annotations = [ [ "2020-09-20", "Cohort of undergraduates are allowed to move back onto campus for limited in-person classes", { dy: 100 } ], ["2020-10-05", "Quiet period ends", { dy: 60 }], [ "2020-11-18", "In-person classes shifted online in response to rising cases", { flip: true } ], [ "2020-11-25", "Thanksgiving break begins, portion of the undergraduate population leaves campus for the rest of the semester" ], [ "2021-01-27", "Campus moves to Modified Level 2 activity status", { dy: 20 } ], [ "2021-07-07", "After 90% vaccination level reached, Brown removes vaccinated students from testing program and drops indoor masking requirement for masking students", { flip: true } ], [ "2021-08-03", "University reinstates indoor mask mandate for all community members and increases required testing frequency for vaccinated people" ], [ "2021-09-13", "New temporary restrictions introduced, including suspension of indoor dining", { flip: true, dy: 120 } ], ["2021-09-24", "In-person dining resumes", { dy: 270 }], [ "2021-09-29", "Remaining temporary restrictions are reversed", { dy: 180, width: 80 } ], [ "2021-10-06", "Fully vaccinated students are only required to get tested once weekly", { dy: 100 } ], [ "2021-10-29", "Fully vaccinated undergraduate students are no longer required to get tested", { flip: true } ] ].map((d) => ({ date: new Date(d[0]), content: d[1], ...d[2] }))31:T5f8,addAnnotations = (x) => (g) => g .selectAll("g") .data([...annotations].reverse()) .join("g") .attr("transform", (d) => `translate(${x(d.date)}, 0)`) .call((g) => g .append("foreignObject") .attr("x", (d) => (d.flip ? -149 : -0.5)) .attr("y", (d) => heroMetrics.top + 20 + (d.dy ?? 0)) .attr("width", (d) => d.width ?? 150) .attr("height", 150) .append("xhtml:p") .style("border-radius", "5px") .style("border-bottom-left-radius", (d) => (d.flip ? "5px" : "0")) .style("border-bottom-right-radius", (d) => (d.flip ? "0" : "5px")) .style("width", (d) => d.width ?? 150) .style("height", 150) .style("padding", "5px") .style("border-top", "1px solid black") .style( "border-left", (d) => "1px solid " + (d.flip ? "transparent" : "black") ) .style( "border-right", (d) => "1px solid " + (d.flip ? "black" : "transparent") ) .style("line-height", "1.25") .style("font-family", "sans-serif") .style("background-color", "white") .style("font-size", "11px") .style("text-align", (d) => (d.flip ? "right" : "left")) .text((d) => d.content) ) .call((g) => g .append("line") .attr("x1", 0) .attr("x2", 0) .attr("y1", (d) => y.range()[1] + 22 + (d.dy ?? 0)) .attr("y2", y.range()[0]) .attr("stroke", "#666") ) .node()32:Tab4,addHoverTip = (x, y, chartData, key = "rate", dx = 0) => (chart) => { const hoverTip = chart.append("g").style("opacity", 0).node(); const boxTranslate = `translate(10, -${17 * 4 + 10})`; d3.select(hoverTip).append( () => svg` [[date]] Positive: Negative: Total: Rate: [[x]]% [[x]]% [[x]]% [[x]]% ` ); chart .on("mousemove", (e) => { const cursorDate = x.invert(e.offsetX + dx); const predicate = (d) => dateFns.isSameDay(d.date, cursorDate); const hit = data.find(predicate); if (!hit) { hoverTip.style.opacity = 0; return; } hoverTip.style.opacity = 1; hoverTip.querySelector( ".date" ).textContent = hit.date.toLocaleDateString(); hoverTip.querySelector( ".positive" ).textContent = hit.positive.toLocaleString(); hoverTip.querySelector( ".negative" ).textContent = hit.negative.toLocaleString(); hoverTip.querySelector(".total").textContent = ( hit.positive + hit.negative ).toLocaleString(); hoverTip.querySelector(".rate").textContent = (rates.find(predicate).rate * 100).toFixed(2) + "%"; const yPos = y(chartData.find(predicate)[key]); const translate = `translate(${x(hit.date)}, ${yPos})`; const scaleY = (yPos - y.range()[0]) / (y.range()[1] - y.range()[0]) > 0.5 ? -1 : 1; const scale = `scale(1, ${scaleY})`; hoverTip.setAttribute("transform", translate + " " + scale); hoverTip .querySelector(".box") .setAttribute( "transform", scaleY < 0 ? scale + `translate(10, 14)` : boxTranslate ); }) .on("mouseleave", () => { hoverTip.style.opacity = 0; }); }33:T884,makeSemesterTimeline = (semester) => { const height = 300; const chartWidth = width - heroMetrics.right - 30; const chart = d3.select(DOM.svg(chartWidth + heroMetrics.right, height)); chart .style("position", "relative") .attr("xmlns", "http://www.w3.org/2000/svg") .attr("font-family", "sans-serif") .attr("font-size", 11); setTimeout(() => { chart.style( "left", -(width - chart.node().parentElement.getBoundingClientRect().width) / 2 + (width >= 768 ? Math.max((width - 738) / 10, 0) : 0) ); }); const cases = smooth( data.filter((d) => +d.date >= +semester.start && +d.date <= +semester.end), "positive" ); const x = d3 .scaleTime() .domain([semester.start, semester.end]) .nice() .range([0, chartWidth]); const y = d3 .scaleLinear() .domain([0, d3.max(cases, (d) => d.positive)]) .nice() .range([height - heroMetrics.bottom, heroMetrics.top]); const content = chart .append("g") .attr("transform", `translate(${heroMetrics.left}, 0)`); content .append("rect") .attr("fill", "#0000") .attr("x", 0) .attr("y", heroMetrics.top) .attr("width", chartWidth) .attr("height", heroMetrics.height - heroMetrics.top - heroMetrics.bottom); content .append("g") .call((g) => g.call( d3 .axisLeft(y) .ticks(y.domain()[1] + 1) .tickFormat(d3.format("d")) ) ) .call((g) => g .select(".tick:last-of-type text") .clone() .attr("x", 3) .attr("text-anchor", "start") .attr("font-weight", "bold") .text(`↑ positive tests (7-day average) • ${semester.label}`) ); content .append("g") .call( xAxis( x, width < 500 ? Math.floor( dateFns.differenceInWeeks(semester.end, semester.start) / 2 ) : dateFns.differenceInWeeks(semester.end, semester.start) + 1, height ) ); content.append(rateLine(x, cases, (d) => y(d.positive))); content.call(addHoverTip(x, y, cases, "positive", -heroMetrics.left)); return chart.node(); }34:T498,printTimeline = { const data = smooth(rates, "rate"); const x = d3 .scaleTime() .domain(d3.extent(rates, (d) => d.date)) .range([0, heroMetrics.width - heroMetrics.right]); const chart = d3.select(DOM.svg(heroMetrics.width, heroMetrics.height)); chart .attr("xmlns", "http://www.w3.org/2000/svg") .attr("font-family", "sans-serif") .attr("font-size", 11); const content = chart .append("g") .attr("transform", `translate(${heroMetrics.left}, 0)`); content.append("g").call(addSemesters(x, 18)); content .append("g") .call((g) => g .attr( "transform", `translate(0,${heroMetrics.height - heroMetrics.bottom})` ) .call(d3.axisBottom(x).ticks(20).tickFormat(d3.timeFormat("%B %Y"))) ); content.append(rateLine(x, data)); chart .append("g") .call(yAxis) .call((g) => g .select(".tick:last-of-type text") .clone() .attr("x", -23) .attr("y", -12) .attr("text-anchor", "start") .attr("font-weight", "bold") .text(`↑ test positivity rate (7-day average, %)`) ); return chart.node(); }35:[{"id":"0ac9e345200fd09f6a4b7d17477035203115c024e7739e830f02f2a8ab7ec4ca685ce4e0359cc468b9721852e95c45113278084d89c8d7f30d525e59f6609a5f","href":"https://static.observableusercontent.com/files/0ac9e345200fd09f6a4b7d17477035203115c024e7739e830f02f2a8ab7ec4ca685ce4e0359cc468b9721852e95c45113278084d89c8d7f30d525e59f6609a5f","name":"trends_in_number_of_covid19_vaccinations_in_the_us.csv","type":"text/csv","lastModified":1636041728074.662,"size":53517},{"id":"5db05aa86581d4469cfc7f2557330f266b00738c8e9d5d0eb09e56f39598b99f9082e9d958328d6173627fd0b2c5e3c9f52fa61ca254f10dc9342a78253f616d","href":"https://static.observableusercontent.com/files/5db05aa86581d4469cfc7f2557330f266b00738c8e9d5d0eb09e56f39598b99f9082e9d958328d6173627fd0b2c5e3c9f52fa61ca254f10dc9342a78253f616d","name":"Brown_Asymptomatic Test Results_Daily.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1635970532755.276,"size":17107}] 2d:{"id":"07df6130b7a5db8e","slug":"bdh-university-testing-data","title":"Brown Asymptomatic Covid-19 Testing","thumbnail":"05c44c923582378e6957094176346f0381b93ba5d7b3bca2e075063f2a08505c","access_level":"public","create_time":"$D2021-11-03T20:14:52.395Z","update_time":"$D2021-11-12T15:04:25.644Z","view_time":null,"first_public_time":"$D2021-11-12T17:04:43.384Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"7b6e6ffaf01ab5f3","login":"bdh","name":"The Brown Daily Herald","avatar_url":"https://avatars-next.observableusercontent.com/4ca55d65991306f8e5e5d68c2b0b0c60d41f26cbd245a55b828138492c0b59b2","tier":"starter_2024"},"version":1474,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"6a6723dba070655c","login":"j-f1","name":"Jed Fox","avatar_url":"https://avatars-next.observableusercontent.com/d222a344a2bdf162a8495aa976e7c08179a554665edaa137ea155ef6bb38fc37","tier":null},{"type":"individual","id":"6be7bafc38ff201c","login":"benglickman","name":"","avatar_url":null,"tier":null}],"members":[{"type":"team","id":"7b6e6ffaf01ab5f3","login":"bdh","name":"The Brown Daily Herald","avatar_url":"https://avatars-next.observableusercontent.com/4ca55d65991306f8e5e5d68c2b0b0c60d41f26cbd245a55b828138492c0b59b2","tier":"starter_2024","role":"editor"},{"type":"individual","id":"6a6723dba070655c","login":"j-f1","name":"Jed Fox","avatar_url":"https://avatars-next.observableusercontent.com/d222a344a2bdf162a8495aa976e7c08179a554665edaa137ea155ef6bb38fc37","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Brown Asymptomatic Covid-19 Testing","cells":[{"id":0,"value":"# Brown Asymptomatic Covid-19 Testing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"## Timeline","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":360,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"$30","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"xAxis = (x, ticks = 80, height = heroMetrics.height) => (g) =>\n g\n .attr(\"transform\", `translate(0,${height - heroMetrics.bottom})`)\n .call(d3.axisBottom(x).ticks(ticks).tickFormat(d3.timeFormat(\"%-m/%-d\")))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":427,"value":"y = d3\n .scaleLinear()\n .domain([0, 0.016])\n .nice()\n .range([heroMetrics.height - heroMetrics.bottom, heroMetrics.top])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":419,"value":"yAxis = (g) =>\n g\n .attr(\"transform\", `translate(${heroMetrics.left},0)`)\n .call(d3.axisLeft(y).tickFormat((d) => (d * 100).toFixed(1) + \"%\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":486,"value":"rateLine = (x, data, getY = (d) => y(d.rate)) => () =>\n d3\n .create(\"svg:path\")\n .datum(data)\n .attr(\"fill\", \"none\")\n .attr(\"stroke\", \"steelblue\")\n .attr(\"stroke-width\", 1.5)\n .attr(\"stroke-linejoin\", \"round\")\n .attr(\"stroke-linecap\", \"round\")\n .attr(\n \"d\",\n d3\n .line()\n .curve(d3.curveMonotoneX)\n .x((d) => x(d.date))\n .y(getY)\n )\n .node()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":615,"value":"addSemesters = (x, fontSize = 15) => (g) =>\n g\n .selectAll(\"g\")\n .data(semesters)\n .join(\"g\")\n .attr(\"transform\", (d) => `translate(${x(d.start)}, 0)`)\n .call((g) =>\n g\n .append(\"rect\")\n .attr(\"fill\", \"#f0f0f0\")\n .attr(\"y\", heroMetrics.top)\n .attr(\"width\", (d) => x(d.end) - x(d.start))\n .attr(\n \"height\",\n heroMetrics.height - heroMetrics.bottom - heroMetrics.top\n )\n )\n .call((g) =>\n g\n .append(\"text\")\n .attr(\"x\", 5)\n .attr(\"y\", 39)\n .attr(\"font-size\", fontSize)\n .attr(\"font-weight\", \"bold\")\n .attr(\"fill\", \"#444\")\n .text((d) => d.label.toUpperCase())\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"heroMetrics = ({\n top: 20,\n right: 30,\n bottom: 30,\n left: 40,\n width: 2000,\n height: 520\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1254,"value":"### Per-Semester Timelines","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1051,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1054,"value":"fall2020Timeline = makeSemesterTimeline(semesters[0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1262,"value":"spring2021Timeline = makeSemesterTimeline(semesters[1])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1263,"value":"summer2021Timeline = makeSemesterTimeline(semesters[2])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1259,"value":"fall2021Timeline = makeSemesterTimeline(semesters[3])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1351,"value":"### Print Timeline","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1350,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1046,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"semesters = [\n { start: \"2020-08-30\", end: \"2020-12-11\", label: \"Fall 2020\" },\n { start: \"2021-01-09\", end: \"2021-04-23\", label: \"Spring 2021\" },\n { start: \"2021-05-09\", end: \"2021-08-13\", label: \"Summer 2021\" },\n { start: \"2021-09-08\", end: \"2021-12-21\", label: \"Fall 2021\" }\n].map((s) => ({ ...s, start: new Date(s.start), end: new Date(s.end) }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1150,"value":"smooth = (data, key) =>\n data.map((d, i) => ({\n date: d.date,\n [key]: d3.mean(\n data.slice(\n Math.max(0, i - 7 / 2),\n Math.min(i + 7 / 2 + 1, rates.length - 1)\n ),\n (d) => d[key]\n )\n }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":563,"value":"smoothedRates = rates.map((d, i) => ({\n date: d.date,\n rate: d3.mean(\n rates.slice(\n Math.max(0, i - 7 / 2),\n Math.min(i + 7 / 2 + 1, rates.length - 1)\n ),\n (d) => d.rate\n )\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"// rates = weekify(data, [\"positive\", \"negative\"]).map((d) => {\nrates = data.map((d) => ({\n date: d.date,\n rate: d.positive / (d.positive + d.negative)\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":886,"value":"testRequirements = [\n {\n start: new Date(\"2020-08-30\"),\n end: new Date(\"2020-11-23\"),\n perWeek: 2,\n isSummer: false,\n numTests: 28\n },\n {\n start: new Date(\"2021-01-27\"),\n end: new Date(\"2021-04-23\"),\n perWeek: 2,\n isSummer: false,\n numTests: 24\n },\n {\n start: new Date(\"2021-05-09\"),\n end: new Date(\"2021-08-13\"),\n perWeek: 2,\n isSummer: true,\n numTests: 26\n },\n {\n start: new Date(\"2021-09-08\"),\n end: new Date(\"2021-10-06\"),\n perWeek: 2,\n isSummer: false,\n numTests: 8\n },\n {\n start: new Date(\"2021-10-06\"),\n end: new Date(\"2021-10-26\"),\n perWeek: 1,\n isSummer: false,\n numTests: 2\n },\n {\n start: new Date(\"2021-11-23\"),\n end: new Date(\"2021-12-1\"),\n perWeek: 2,\n isSummer: false,\n numTests: 6\n }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"question = html`

How many tests did you take this semester?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"semesterPicker = html`

I was on campus for:
${viewof hereFall2020}
${\n hereFall2020 ? html`${viewof thanksgiving2020}` : html``\n}
${viewof hereSpring2021}
${viewof hereSummer2021}
${viewof hereFall2021}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":946,"value":"testCountOutput = html`

You took ${totalTests.toLocaleString()} tests!`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":948,"value":"totalTests = {\n let totalTests = 0;\n if (hereFall2020) totalTests += testRequirements[0].numTests;\n if (thanksgiving2020) totalTests += testRequirements[5].numTests;\n if (hereSpring2021) totalTests += testRequirements[1].numTests;\n if (hereSummer2021) totalTests += testRequirements[2].numTests;\n if (hereFall2021)\n testRequirements.slice(3).forEach((r) => (totalTests += r.numTests));\n\n return totalTests;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":953,"value":"check = (title, checked = true) => {\n const checkbox = html``;\n checkbox.checked = checked;\n const view = html`${checkbox} ${title}`;\n view.value = checked;\n checkbox.oninput = () => (view.value = checkbox.checked);\n return view;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1008,"value":"viewof thanksgiving2020 = check(\"Thanksgiving 2020 until finals\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":901,"value":"viewof hereFall2020 = check(\"Fall 2020 until Thanksgiving\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":918,"value":"viewof hereSpring2021 = check(\"Spring 2021\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":921,"value":"viewof hereSummer2021 = check(\"Summer 2021\", false)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":923,"value":"viewof hereFall2021 = check(\"Fall 2021\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":210,"value":"## Miscellaneous Noodling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1016,"value":"TODO:\n- Semester graph (no annotation, absolute positive case numbers)\n- Positive case spikes after holdaiys (halloween, july 4, labor day/first week of school, presidents day)\n- ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":148,"value":"html`

${Plot.plot({\n marks: [\n Plot.barY(\n d3\n .groups(data, (d) =>\n dateFns.differenceInCalendarDays(d.date, dateFns.startOfWeek(d.date))\n )\n .map(([day, items]) => ({\n day,\n total: d3.sum(items, (d) => d.negative + d.positive)\n })),\n { x: \"day\", y: \"total\" }\n )\n ],\n x: { tickFormat: Plot.formatWeekday() },\n y: { tickFormat: \"s\" },\n width: 350\n})}${Plot.plot({\n marks: [\n Plot.barY(\n d3\n .groups(data, (d) =>\n dateFns.differenceInCalendarDays(d.date, dateFns.startOfWeek(d.date))\n )\n .map(([day, items]) => ({\n day,\n positive:\n d3.sum(items, (d) => d.positive) /\n d3.sum(items, (d) => d.negative + d.positive)\n })),\n { x: \"day\", y: \"positive\", fill: \"red\", axis: \"right\" }\n )\n ],\n x: { tickFormat: Plot.formatWeekday() },\n y: { tickFormat: \"%\" },\n width: 350\n})}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"// Plot.plot({\n// marks: [\n// // Plot.line(weeks, { x: \"date\", y: \"negative / 10\", stroke: \"green\" }),\n// Plot.line(weekify(data, [\"positive\"]), {\n// x: \"date\",\n// y: \"positive\",\n// stroke: \"red\"\n// }),\n// Plot.line(weekify(vax, [\"doses\"]), { x: \"date\", y: (d) => d.doses / 4e5 }),\n// Plot.line(\n// weekify(\n// covid.filter((d) => d.state === \"RI\"),\n// [\"new_case\"]\n// ),\n// { x: \"date\", y: (d) => d.new_case / 1e2, stroke: \"blue\" }\n// )\n// ]\n// })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"// Plot.plot({\n// marks: [\n// // Plot.line(weeks, { x: \"date\", y: \"negative / 10\", stroke: \"green\" }),\n// Plot.line(weekify(data, [\"positive\"]), {\n// x: \"date\",\n// y: \"positive\",\n// stroke: \"red\"\n// }),\n// Plot.line(weekify(vax, [\"doses\"]), { x: \"date\", y: (d) => d.doses / 4e5 }),\n// Plot.line(\n// weekify(\n// covid.filter((d) => d.state === \"RI\"),\n// [\"new_case\"]\n// ),\n// { x: \"date\", y: (d) => d.new_case / 1e2, stroke: \"blue\" }\n// )\n// ],\n// width: width\n// })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"Source: https://covid.cdc.gov/covid-data-tracker/#vaccination-trends","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"// vaxRaw = d3\n// .csvParse(\n// (\n// await FileAttachment(\n// \"trends_in_number_of_covid19_vaccinations_in_the_us.csv\"\n// ).text()\n// )\n// .split(\"\\r\\n\")\n// .slice(2)\n// .join(\"\\r\\n\"),\n// d3.autoType\n// )\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"// d3.groups(vax, (d) => d.Location)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"// vax = vaxRaw\n// .filter((d) => d[\"Date Type\"] == \"Admin\")\n// .map((d) => ({\n// type: d[\"Date Type\"],\n// date: d.Date,\n// doses: d[\"Total Doses Administered Daily\"]\n// }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"// weekify = (arr, keysToSum) =>\n// d3\n// .groups(arr, (d) => `${dateFns.getYear(d.date)}-${dateFns.getWeek(d.date)}`)\n// .map(([week, entries]) => ({\n// date: entries[0].date,\n// ...Object.fromEntries(\n// keysToSum.map((k) => [k, d3.sum(entries, (d) => d[k])])\n// )\n// }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"data = FileAttachment(\"Brown_Asymptomatic Test Results_Daily.xlsx\")\n .xlsx()\n .then((file) => file.sheet(0, { headers: true }))\n .then((data) =>\n data.map((d) => ({\n date: d.Date,\n negative: d.Negative,\n positive: d.Positive\n }))\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"// dateFns = import(\"https://unpkg.com/date-fns@2.16.1/esm/index.js?esm\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":990,"value":"// only fetch the required functions (there are a lot of other ones)\ndateFns = Promise.all(\n [\n \"isBefore\",\n \"isSameDay\",\n \"differenceInCalendarDays\",\n \"startOfWeek\",\n \"differenceInWeeks\"\n ].map((name) =>\n import(\n `https://unpkg.com/date-fns@2.16.1/esm/${name}/index.js`\n ).then((m) => [name, m.default])\n )\n).then(Object.fromEntries)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"// rawCovid = await d3.json(\n// \"https://data.cdc.gov/resource/9mfq-cb36.json?$$app_token=P7qXIq6TVhbiyl54sAjeIcy4C&$limit=50000\"\n// )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"// d3\n// .groups(rawCovid, (d) => Object.keys(d).length)\n// .map((d) => [d[0], Object.keys(d[1][0])])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"// covid = d3.sort(\n// rawCovid.map((d) => ({\n// date: new Date(d.submission_date),\n// state: d.state,\n// tot_cases: +d.tot_cases,\n// // conf_cases: +d.conf_cases,\n// // prob_cases: +d.prob_cases,\n// new_case: +d.new_case,\n// // pnew_case: +d.pnew_case,\n// tot_death: +d.tot_death,\n// new_death: +d.new_death,\n// // pnew_death: +d.pnew_death,\n// created_at: new Date(d.created_at)\n// // consent_cases: d.consent_cases,\n// // consent_deaths: d.consent_deaths\n// })),\n// (d) => d.date\n// )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 2e:"$2d:body"