32:T483,flexGrid( Array.from(problemStatesByHospitalization).map(s => { const stateData = data.params({ state: s }).filter((d, $) => d.state === $.state && d['actuals.hospitalBeds.currentUsageCovid']) const chart = Plot.plot({ width: CHART_WIDTH, height: CHART_WIDTH * 0.46, marginRight: 75, y: { label: 'Beds Occupied', tickFormat: 's' }, marks: [ Plot.areaY(stateData, { y: 'actuals.hospitalBeds.currentUsageCovid', x: 'date', }), Plot.text(stateData, Plot.selectMaxY({ y: 'actuals.hospitalBeds.currentUsageCovid', x: 'date', dx: 5, text: d => d3.format(',d')(d['actuals.hospitalBeds.currentUsageCovid']), textAnchor: 'start', })), Plot.dot(stateData, Plot.selectMaxY({ y: 'actuals.hospitalBeds.currentUsageCovid', x: 'date', fill: '#A00', })) ] }) return htl.html.fragment`

${US_STATES[s]}

${chart} ` }), 'No states had their worst hospitalization peak in this date range.' )33:T411,flexGrid( Array.from(problemStatesByDeath).map(s => { const stateData = data.params({ state: s }).filter((d, $) => d.state === $.state && d['averageDeaths']) const chart = Plot.plot({ width: CHART_WIDTH, height: CHART_WIDTH * 0.46, marginRight: 75, y: { label: 'Deaths (7-day avg)', tickFormat: 's' }, x: { ticks: 5 }, marks: [ Plot.areaY(stateData, { y: 'averageDeaths', x: 'date', }), Plot.text(stateData, Plot.selectMaxY({ y: 'averageDeaths', x: 'date', dx: 5, text: d => d3.format(',d')(d['averageDeaths']), textAnchor: 'start', })), Plot.dot(stateData, Plot.selectMaxY({ y: 'averageDeaths', x: 'date', fill: '#A00', })) ] }) return htl.html.fragment`

${US_STATES[s]}

${chart} ` }), 'No states had their worst fatality peak in this date range.' )34:T58c,US_STATES = ({ "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" })35:[] 30:{"title":"Which states’ worst pandemic days were this week?","cells":[{"id":0,"value":"# Which states’ worst pandemic days were this week?","pinned":false,"hidden":false,"mode":"md"},{"id":55,"value":"## Hospitalizations\n\n${\n Array.from(problemStatesByHospitalization).length === 1 ?\n 'This state had its worst ever covid hospitalization day' :\n `These ${Array.from(problemStatesByHospitalization).length} states had their worst ever covid hospitalization day`\n}\n${\n settingsPristine ?\n `_this week_, between ${d3.timeFormat('%x')(dateRange[0])} and ${d3.timeFormat('%x')(dateRange[1])}.` :\n `between ${d3.timeFormat('%x')(dateRange[0])} and ${d3.timeFormat('%x')(dateRange[1])}.`\n}","pinned":false,"hidden":false,"mode":"md"},{"id":299,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":309,"value":"## Deaths\n\n${\n Array.from(problemStatesByDeath).length === 1 ?\n 'This state had its worst ever covid fatalities day' :\n `These ${Array.from(problemStatesByDeath).length} states had their worst ever covid fatalities day`\n}\n${\n settingsPristine ?\n `_this week_, between ${d3.timeFormat('%x')(dateRange[0])} and ${d3.timeFormat('%x')(dateRange[1])}.` :\n `between ${d3.timeFormat('%x')(dateRange[0])} and ${d3.timeFormat('%x')(dateRange[1])}.`\n}","pinned":false,"hidden":false,"mode":"md"},{"id":319,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":139,"value":"_Data: [CovidActNow](https://www.covidactnow.org/)_","pinned":false,"hidden":false,"mode":"md"},{"id":173,"value":"## Settings ⚙️\n\nTo check a different date range for peaks, change the dates below. If a state had their hospitalization peak during the selected range, it will show up in the list above.","pinned":false,"hidden":false,"mode":"md"},{"id":187,"value":"viewof settings = view`

\n ${['start', Inputs.text({ label: 'Start', type: 'date', value: d3.timeFormat('%Y-%m-%d')(ONE_WEEK_AGO)})]}\n ${['end', Inputs.text({ label: 'End', type: 'date', value: d3.timeFormat('%Y-%m-%d')(TODAY) })]}\n

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"***\n\n## Calculations","pinned":false,"hidden":false,"mode":"md"},{"id":8,"value":"data = aq.fromCSV(\n await (await fetch(`https://api.covidactnow.org/v2/states.timeseries.csv?apiKey=${API_KEY}`)).text()\n).derive({\n averageDeaths: aq.rolling(d => op.average(d['actuals.newDeaths']), [-6, 0]),\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":19,"value":"problemStatesByHospitalization = new Set(\n data.groupby('state')\n // Calculate the maximum hospitalizations for every state\n .derive({\n maxHospitalizations: d => op.max(d['actuals.hospitalBeds.currentUsageCovid'])\n })\n // Filter to only the rows that are the max hospitalization row for each state\n .filter(d => op.equal(d['actuals.hospitalBeds.currentUsageCovid'], d.maxHospitalizations))\n // Filter to only the rows that occurred in the date range\n .filter(aq.escape(d => d.date > dateRange[0] && d.date < dateRange[1]))\n .select('state')\n .objects()\n .map(d => d.state)\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":271,"value":"problemStatesByDeath = new Set(\n data.groupby('state')\n // Calculate the maximum daily average deaths for every state\n .derive({\n maxDeaths: d => op.max(d.averageDeaths)\n })\n // Filter to only the rows that are the max death row for each state\n .filter(d => op.equal(d.averageDeaths, d.maxDeaths))\n // Filter to only rows that occurred in the date range\n .filter(aq.escape(d => d.date > dateRange[0] && d.date < dateRange[1]))\n .select('state')\n .objects()\n .map(d => d.state)\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":285,"value":"***\n\n## Utilities","pinned":false,"hidden":false,"mode":"md"},{"id":241,"value":"ONE_WEEK_AGO = d3.timeDay.floor(d3.timeWeek.offset(new Date(), -1))","pinned":true,"hidden":false,"mode":"ojs"},{"id":247,"value":"TODAY = d3.timeDay.floor(new Date())","pinned":true,"hidden":false,"mode":"ojs"},{"id":344,"value":"CHART_WIDTH = {\n if (width > 800) return Math.floor(width / 3) - 5\n if (width > 500) return Math.floor(width / 2) - 5\n return width\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":237,"value":"dateRange = [\n d3.timeParse('%Y-%m-%d')(settings.start),\n d3.timeParse('%Y-%m-%d')(settings.end),\n] ","pinned":true,"hidden":false,"mode":"ojs"},{"id":239,"value":"settingsPristine = +dateRange[0] === +ONE_WEEK_AGO && +dateRange[1] === +TODAY","pinned":true,"hidden":false,"mode":"ojs"},{"id":296,"value":"flexGrid = (arr, emptyMessage) => arr.length > 0 ? \n htl.html`

\n ${arr.map(el => htl.html`

${el}

`)}\n

` :\n htl.html`${emptyMessage}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":313,"value":"pluralize = (singular, count, plural) => {\n if (count === 1) return singular\n if (plural !== undefined) return plural\n return singular + 's'\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":14,"value":"***\n\n## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":12,"value":"API_KEY = 'd7978daa8e1d48cf84c1f16f0e6428c0'","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":9,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":180,"value":"import {view} from '@tomlarkworthy/view'","pinned":false,"hidden":false,"mode":"ojs"},{"id":183,"value":"import { Inputs } from '@observablehq/inputs'","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W35","stdlib":"1","titling":"auto"}