3f:["$","title",null,{"children":"Rhode Island COVID-19 Case Data | The Brown Daily Herald | Observable"}] 45:T486,statsDisplay = html`

${stats .get('Cumulative positive tests') .toLocaleString()} cumulative positive tests in Rhode Island ${stats .get('Daily number of positive tests') .toLocaleString()} positive tests in the last 24 hours in Rhode Island ${stats .get('Cumulative total tests completed') .toLocaleString()} cumulative tests in Rhode Island ${stats .get('Currently hospitalized') .toLocaleString()} people currently hospitialized in Rhode Island ${stats.get('Total deaths').toLocaleString()} COVID-19 associated fatalities in Rhode Island

`46:[] 43:{"id":"370caab89559e2b7","slug":"rhode-island-covid-19-case-data","title":"Rhode Island COVID-19 Case Data","thumbnail":"c1eb30147b65b0c30eed80fdc7f620a736922e0561078ae9b7da224c3d6ccaa5","access_level":"public","create_time":"$D2020-03-24T17:02:02.032Z","update_time":"$D2020-08-10T12:02:05.594Z","view_time":null,"first_public_time":"$D2020-03-25T00:56:11.315Z","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","bio":"An independent, student-run news organization serving the Brown University community since 1891."},"version":824,"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,"bio":""}],"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":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Rhode Island COVID-19 Case Data","cells":[{"id":185,"value":"md`# Rhode Island COVID-19 Case Data\n\nProduced by Jed Fox and Leon Jiang for the [Brown Daily Herald](https://browndailyherald.com).\n\nNote: The maps below are extremely outdated. See the [current city-by-city map](https://observablehq.com/d/f123bddf1d8844a5). (the case stats are up to date)\n\n*[Click here to view The Herald’s COVID-19 coverage](https://www.browndailyherald.com/sections/covid-19-update/)*.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":540,"value":"md`## Case stats`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":795,"value":"lastUpdated = md`**Stats last updated ${stats\n .get('date')\n .toLocaleDateString()}**`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"md`## Number of cases by county`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"casesGraph = {\n const svg = d3\n .create('svg')\n .attr('viewBox', [0, 0, 460, 630])\n .style('width', '400px');\n\n svg\n .append('g')\n .attr('transform', 'translate(50,20)')\n .append(() => legend({ color: casesColor, title: 'Cases', width: 260 }));\n\n const color = d => casesColor(numCases.get(d.properties.name));\n svg\n .append('g')\n .selectAll('g')\n .data(topojson.feature(ri, ri.objects.counties).features)\n .join('g')\n .call(g =>\n g\n .append('path')\n .attr('fill', color)\n .attr('d', path)\n )\n .call(\n labelCounties(color, d =>\n d3.format(',.0f')(numCases.get(d.properties.name))\n )\n );\n\n return svg.node();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"casesColor = d3\n .scaleSequential(t => d3.interpolateOrRd(Math.pow(t, 1 / 1.5)))\n .domain([0, d3.max(Array.from(numCases.values()))])\n .nice()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":562,"value":"md`## Percentage of population infected by county`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"percentInfectedGraph = {\n const svg = d3\n .create(\"svg\")\n .attr(\"viewBox\", [0, 0, 460, 630])\n .style(\"width\", \"400px\");\n\n svg\n .append(\"g\")\n .attr(\"transform\", \"translate(50,20)\")\n .append(() =>\n legend({\n color: percentInfectedColor,\n title: \"Percent Infected\",\n width: 260,\n tickFormat: '%'\n })\n );\n\n const percent = d =>\n numCases.get(d.properties.name) / populations[d.properties.name];\n const color = d => percentInfectedColor(percent(d));\n svg\n .append('g')\n .selectAll('g')\n .data(topojson.feature(ri, ri.objects.counties).features)\n .join('g')\n .call(g =>\n g\n .append('path')\n .attr(\"fill\", color)\n .attr(\"d\", d3.geoPath(projection))\n )\n .call(labelCounties(color, d => d3.format('.4%')(percent(d))));\n\n return svg.node();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"percentInfectedColor = d3\n .scaleSequential(d3.interpolateBlues)\n .domain([\n 0,\n d3.max(Array.from(numCases.entries()), d => d[1] / populations[d[0]])\n ])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":537,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"stats = {\n const text = await d3.text(\n 'https://cors-anywhere.herokuapp.com/docs.google.com/spreadsheets/d/1c2QrNMz8pIbYEKzMJL7Uh2dtThOJa2j1sSMwiDo5Gz4/export?format=csv'\n );\n const [firstLine, ...rest] = text.split('\\r\\n');\n const date = d3.timeParse('%-m/%-d/%Y')(firstLine.split(',')[1]);\n const map = new Map(\n d3.csvParseRows(rest.join('\\n'), ([name, value]) => [\n name\n .replace(/\\s*\$[^)]+\$/g, '')\n .replace(/\\s{2,}/g, ' ')\n .trim(),\n parseInt(value.replace(/,/g, ''))\n ])\n );\n map.set('date', date);\n return map;\n}\n// stats = d3\n// .text('https://j-f1.github.io/ridoh-covid19-key-stats/latest.csv?v=1')\n// .then(text => d3.csvParseRows(text, d3.autoType))\n// .then(rows => new Map(rows))\n// stats = d3.json(\n// 'https://raw.githubusercontent.com/j-f1/covid19-map/master/key_stats.json'\n// )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"numCases = csvRows(\n 'https://cors-anywhere.herokuapp.com/docs.google.com/spreadsheets/d/e/2PACX-1vT--dFc7nR7jA_yu24aZYX_uVpa2grOddI7Zx2j4tFZRXasOL0Ldr6l_uAMmoOf77WV5jZsKNNg53eH/pub?output=csv',\n ([name, count]) => [name.toUpperCase(), parseInt(count)]\n).then(rows => new Map(rows))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"// Source: https://en.wikipedia.org/wiki/List_of_counties_in_Rhode_Island\npopulations = ({\n BRISTOL: 49875,\n KENT: 166158,\n NEWPORT: 82888,\n PROVIDENCE: 626667,\n WASHINGTON: 126979\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":553,"value":"md`### Map Projection\n\n(manually positioned/scaled to fit RI)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":133,"value":"projection = d3\n .geoAlbers()\n .center([-2, 41.8])\n .scale(4e4)\n .rotate([69, 0, 0])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":320,"value":"path = d3.geoPath(projection)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"ri = d3\n .json(\n 'https://raw.githubusercontent.com/leonyjiang/covid19-map/master/ri_topojson.json'\n )\n .then(ri =>\n Object.assign(ri, {\n objects: {\n counties: {\n type: \"GeometryCollection\",\n // merge separate chunks of each county\n geometries: Array.from(\n ri.objects.Counties.geometries\n .reduce((map, poly) => {\n const name = poly.properties.COUNTY;\n if (map.has(name)) {\n map.get(name).geometries.push(poly);\n } else {\n map.set(name, {\n type: \"GeometryCollection\",\n properties: { name },\n geometries: [poly]\n });\n }\n return map;\n }, new Map())\n .values()\n )\n }\n }\n })\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":522,"value":"md`## Helper functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"csvRows = (url, handler = d3.autoType) =>\n fetch(url)\n .then(res => res.text())\n .then(csv => d3.csvParseRows(csv, handler))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"labelCounties = (color, value) => g =>\n g\n .call(g =>\n makeLabel(g, d => d.properties.name)\n .attr('stroke', color)\n .attr('stroke-width', 6)\n .attr('stroke-opacity', .75)\n .attr('dy', -10)\n )\n .call(g =>\n makeLabel(g, d => d.properties.name)\n .attr('fill', d => (isDark(color(d)) ? 'white' : 'black'))\n .attr('dy', -10)\n )\n .call(g =>\n makeLabel(g, value)\n .attr('stroke', color)\n .attr('stroke-width', 6)\n .attr('stroke-opacity', .75)\n .attr('dy', 10)\n )\n .call(g =>\n makeLabel(g, value)\n .attr('fill', d => (isDark(color(d)) ? 'white' : 'black'))\n .attr('dy', 10)\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"makeLabel = (g, text) =>\n g\n .append('text')\n .attr('transform', d => `translate(${path.centroid(d)})`)\n .attr('text-anchor', 'middle')\n .attr('font-weight', '900')\n .text(text)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":363,"value":"pl = n => (n === 1 ? '' : 's')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":372,"value":"html`