2c:null 2d:["$","title",null,{"children":"Coronavirus Tests, Positives, and Deaths by State | Brandon Hamilton | Observable"}] 32:Tae5,chart = { const container = d3.create("div") .style("content", '') .style("clear", "both") .style("display", "table") const stateDivs = container.selectAll("div") .data(nestedData) .join("div") .html(d => `

${stateAbbrMap[d.key]}

${addCommas(last(d.values).totalTestResults)} tests (${Math.round((last(d.values).totalTestResults / populationsMap[stateAbbrMap[d.key]]) * 10000) / 100}% of population)

${addCommas(last(d.values).positive)} positives (${Math.round(last(d.values).positive / last(d.values).totalTestResults * 100)}% of tested)

${addCommas(last(d.values).death)} deaths (${Math.round((last(d.values).death / populationsMap[stateAbbrMap[d.key]]) * 1000000) / 10000}% of population)

`) .style("float", "left") .style("margin", "4px") const stateSvgs = stateDivs.append("svg") .attr("viewBox", [0, 0, width, height]) .attr("height", height) .attr("width", width) .style("border", "1px solid black") .style("overflow", "visible"); stateSvgs.append("g") .call(xAxis); stateSvgs.append("g") .call(yAxis); if (indicators.includes("Deaths")) { const deathLineGroup = stateSvgs.append("g") .attr("fill", "none") .attr("stroke", "red") .attr("stroke-width", 1.5) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .append("path") .style("mix-blend-mode", "multiply") .attr("d", d => line("death")(d.values)); } if (indicators.includes("Positives")) { const positiveLineGroup = stateSvgs.append("g") .attr("fill", "none") .attr("stroke", "steelblue") .attr("stroke-width", 1.5) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .append("path") .style("mix-blend-mode", "multiply") .attr("d", d => line("positive")(d.values)); } if (indicators.includes("Tests")) { const totalTestResultsLineGroup = stateSvgs.append("g") .attr("fill", "none") .attr("stroke", "gray") .attr("stroke-width", 1.5) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .append("path") .style("mix-blend-mode", "multiply") .attr("d", d => line("totalTestResults")(d.values)); } if (indicators.includes("Hospitalizations")) { const hospitalizedLineGroup = stateSvgs.append("g") .attr("fill", "none") .attr("stroke", "orange") .attr("stroke-width", 1.5) .attr("stroke-linejoin", "round") .attr("stroke-linecap", "round") .append("path") .style("mix-blend-mode", "multiply") .attr("d", d => line("hospitalized")(d.values)); } return container.node(); } 33:T57d,stateAbbrMap = ({ "AL": "Alabama", "AK": "Alaska", "AS": "American Samoa", "AZ": "Arizona", "AR": "Arkansas", "CA": "California", "CO": "Colorado", "CT": "Connecticut", "DE": "Delaware", "DC": "District of Columbia", "FM": "Federated States Of Micronesia", "FL": "Florida", "GA": "Georgia", "GU": "Guam", "HI": "Hawaii", "ID": "Idaho", "IL": "Illinois", "IN": "Indiana", "IA": "Iowa", "KS": "Kansas", "KY": "Kentucky", "LA": "Louisiana", "ME": "Maine", "MH": "Marshall Islands", "MD": "Maryland", "MA": "Massachusetts", "MI": "Michigan", "MN": "Minnesota", "MS": "Mississippi", "MO": "Missouri", "MT": "Montana", "NE": "Nebraska", "NV": "Nevada", "NH": "New Hampshire", "NJ": "New Jersey", "NM": "New Mexico", "NY": "New York", "NC": "North Carolina", "ND": "North Dakota", "MP": "Northern Mariana Islands", "OH": "Ohio", "OK": "Oklahoma", "OR": "Oregon", "PW": "Palau", "PA": "Pennsylvania", "PR": "Puerto Rico", "RI": "Rhode Island", "SC": "South Carolina", "SD": "South Dakota", "TN": "Tennessee", "TX": "Texas", "UT": "Utah", "VT": "Vermont", "VI": "Virgin Islands", "VA": "Virginia", "WA": "Washington", "WV": "West Virginia", "WI": "Wisconsin", "WY": "Wyoming" })34:T506,populationsMap = ({"California": 39512223, "Texas": 28995881, "Florida": 21477737, "New York": 19453561, "Pennsylvania": 12801989, "Illinois": 12671821, "Ohio": 11689100, "Georgia": 10617423, "North Carolina": 10488084, "Michigan": 9986857, "New Jersey": 8882190, "Virginia": 8535519, "Washington": 7614893, "Arizona": 7278717, "Massachusetts": 6949503, "Tennessee": 6833174, "Indiana": 6732219, "Missouri": 6137428, "Maryland": 6045680, "Wisconsin": 5822434, "Colorado": 5758736, "Minnesota": 5639632, "South Carolina": 5148714, "Alabama": 4903185, "Louisiana": 4648794, "Kentucky": 4467673, "Oregon": 4217737, "Oklahoma": 3956971, "Connecticut": 3565287, "Utah": 3205958, "Puerto Rico": 3193694, "Iowa": 3155070, "Nevada": 3080156, "Arkansas": 3017825, "Mississippi": 2976149, "Kansas": 2913314, "New Mexico": 2096829, "Nebraska": 1934408, "West Virginia": 1792065, "Idaho": 1787147, "Hawaii": 1415872, "New Hampshire": 1359711, "Maine": 1344212, "Montana": 1068778, "Rhode Island": 1059361, "Delaware": 973764, "South Dakota": 884659, "North Dakota": 762062, "Alaska": 731545, "District of Columbia": 705749, "Vermont": 623989, "Wyoming": 578759, "Guam": 165718, "Virgin Islands": 104914, "American Samoa": 55641, "Northern Mariana Islands": 55194, "District of Columbia": 711571, })35:[] 30:{"id":"91fa4778ea8568de","slug":"coronavirus-tests-positives-and-deaths-by-state","title":"Coronavirus Tests, Positives, and Deaths by State","thumbnail":"e7b67a5f0d44edb56ace684d2eb239159c94cf4bf57e4f7fd375e79c060d27b6","access_level":"public","create_time":"$D2020-03-30T01:54:33.776Z","update_time":"$D2020-08-24T20:09:22.115Z","view_time":null,"first_public_time":"$D2020-03-30T17:56:24.483Z","has_unpublished_edits":null,"fork":true,"stars":1,"starred":false,"owner":{"type":"team","id":"e0a12d88c87ef1dc","login":"mistidoi","name":"Brandon Hamilton","avatar_url":"https://avatars-next.observableusercontent.com/ce68139bd96db02e1261b5e4ad8a8147d2081167d52dfd1d2ea26b1291129df2","tier":"starter_2024"},"version":895,"publish_version":895,"role":null,"authored":false,"authors":[{"type":"individual","id":"153740caf042585a","login":"mistidoi","name":"Brandon Hamilton","avatar_url":"https://avatars-next.observableusercontent.com/ce68139bd96db02e1261b5e4ad8a8147d2081167d52dfd1d2ea26b1291129df2","tier":null}],"members":[{"type":"individual","id":"153740caf042585a","login":"mistidoi","name":"Brandon Hamilton","avatar_url":"https://avatars-next.observableusercontent.com/ce68139bd96db02e1261b5e4ad8a8147d2081167d52dfd1d2ea26b1291129df2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Coronavirus Tests, Positives, and Deaths by State","cells":[{"id":0,"value":"md`# Coronavirus Tests, Positives, and Deaths by State\n\nHi! My name is Brandon Hamilton, and I work at [Relevant](https://relevant.healthcare). We build analytics and workflow tools for safety-net healthcare providers. This is the notebook backing [this](https://relevant.healthcare/blog/2020-04-02-covid-state-visualization/) blog post.\n\nAll data are from the [COVID Tracking Project](https://covidtracking.com/) and are updated live.\n`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":659,"value":"stateSelector = html`\n

Select States

\n ${Object.keys(stateAbbrMap).map(d => html``)}\n\n\n\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":641,"value":"viewof indicators = checkbox({title: \"Indicators\",options: [\"Tests\", \"Positives\", \"Deaths\"], value: [\"Tests\", \"Positives\", \"Deaths\"]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":821,"value":"viewof scaleBy = radio({\n title: 'Scale',\n options: [\n { label: 'Absolute (cumulative)', value: 'absolute' },\n { label: 'Absolute (daily)', value: 'absolute_daily' },\n { label: '% of population (cumulative)', value: 'percent_of_population' },\n ],\n value: 'absolute'\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"viewof sortBy = radio({\n title: 'Sort by',\n options: [\n { label: 'Tests', value: 'tests_absolute' },\n { label: 'Tests (% of population)', value: 'tests_percent' },\n { label: 'Positives', value: 'positives_absolute' },\n { label: 'Positives (% of tested)', value: 'positives_percent' },\n { label: 'Positives (% of population)', value: 'positives_percent_of_population' },\n { label: 'Deaths', value: 'death_absolute' },\n { label: 'Deaths (% of population)', value: 'death_percent' },\n ],\n value: 'death_absolute'\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":487,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":771,"value":"selectAllStates = () => mutable statesSelected = Object.keys(stateAbbrMap)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":781,"value":"selectInverseStates = () => mutable statesSelected = Object.keys(stateAbbrMap).filter(d => !statesSelected.includes(d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":684,"value":"mutable statesSelected = Object.keys(stateAbbrMap);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":675,"value":"toggleState = (value) => {\n var index = statesSelected.indexOf(value);\n if (statesSelected.length === Object.keys(stateAbbrMap).length) {\n mutable statesSelected = [value];\n return\n }\n if (index === -1) {\n mutable statesSelected = [...statesSelected,value];\n } else {\n mutable statesSelected = [...statesSelected.slice(0, index), ...statesSelected.slice(index+1)];\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"data = (await fetch(\"https://api.covidtracking.com/v1/states/daily.json\")).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"parseDate = (d) => new Date(d[\"date\"].toString().substring(0,4), +d[\"date\"].toString().substring(4,6) -1, d[\"date\"].toString().substring(6,8))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":553,"value":"filteredData = data.filter(d => statesSelected.includes(d.state));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"sortedData = filteredData.sort((a,b) => d3.ascending(a.date,b.date));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"nestedData = d3.nest()\n.key(function(d) { return d.state; })\n.entries(sortedData)\n.sort(sortFunctionMap[sortBy]);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":612,"value":"sortFunctionMap = ({\n \"death_absolute\": (a, b) => d3.descending(last(a.values).death, last(b.values).death),\n \"death_percent\": (a, b) => d3.descending(deathPercent(a), deathPercent(b)),\n \"positives_absolute\": (a, b) => d3.descending(last(a.values).positive, last(b.values).positive),\n \"positives_percent\": (a, b) => d3.descending(positivePercent(a), positivePercent(b)),\n \"positives_percent_of_population\": (a, b) => d3.descending(positivePercentOfPopulation(a), positivePercentOfPopulation(b)),\n \"tests_absolute\": (a, b) => d3.descending(last(a.values).totalTestResults, last(b.values).totalTestResults),\n \"tests_percent\": (a, b) => d3.descending(testsPercent(a), testsPercent(b)),\n})\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":845,"value":"positivePercentOfPopulation = d => last(d.values).positive / populationsMap[stateAbbrMap[d.key]]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":623,"value":"positivePercent = d => Math.round(last(d.values).positive / last(d.values).totalTestResults * 100)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"testsPercent = d => Math.round((last(d.values).totalTestResults / populationsMap[stateAbbrMap[d.key]]) * 10000) / 100\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":616,"value":"deathPercent = d => Math.round((last(d.values).death / populationsMap[stateAbbrMap[d.key]]) * 1000000) / 10000","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"color = d3.scaleOrdinal(d3.schemeCategory10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y))\n .call(g => g.select(\".domain\").remove())\n .call(g => g.select(\".tick:last-of-type text\").clone()\n .attr(\"x\", 3)\n .attr(\"text-anchor\", \"start\")\n .attr(\"font-weight\", \"bold\")\n .text(data.y))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"dailyMap = (\n {\n \"death\": \"deathIncrease\",\n \"positive\": \"positiveIncrease\",\n \"totalTestResults\": \"totalTestResultsIncrease\",\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":824,"value":"scales = ({\n \"absolute\": (d, accessor_string) => d[accessor_string],\n \"absolute_daily\": (d, accessor_string) => d[dailyMap[accessor_string]],\n \"percent_of_population\": (d, accessor_string) => (d[accessor_string] / populationsMap[stateAbbrMap[d.state]]) * 100,\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"y = d3.scaleLinear()\n .domain([0, d3.max(\n [\n indicators.includes(\"Deaths\") ? d3.max(filteredData, d => scales[scaleBy](d, \"death\")) : 0,\n indicators.includes(\"Positives\") ? d3.max(filteredData, d => scales[scaleBy](d, \"positive\")) : 0,\n indicators.includes(\"Tests\") ? d3.max(filteredData, d => scales[scaleBy](d, \"totalTestResults\")) : 0,\n indicators.includes(\"Hospitalizations\") ? d3.max(filteredData, d => scales[scaleBy](d, \"hospitalized\")) : 0,\n ]\n )]).nice()\n .range([height - margin.bottom, margin.top])\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x).ticks(width / 80).tickSizeOuter(0))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"width = 300","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"height = 200","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"margin = ({top: 20, right: 20, bottom: 30, left: 60}) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"line = indicator => d3.line()\n .defined(d => !isNaN(d[indicator]))\n .x(d => x(parseDate(d)))\n .y(d => y(scales[scaleBy](d, indicator)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"x = d3.scaleUtc()\n .domain(d3.extent(sortedData.map(d => parseDate(d))))\n .range([margin.left, width - margin.right])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"d3 = require(\"d3@5\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":282,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":467,"value":"last = array => array[array.length - 1]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":473,"value":"addCommas = d3.format(\",\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":559,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"import {select, radio, checkbox} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":739,"value":"import {html} from \"@observablehq/htl\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1"}} 31:"$30:body"