34:["$","title",null,{"children":"SNF covid trends for individual facilities | Erica Yee | Observable"}] 3c:T4b9,chart = { const svg = d3.create("svg") .style("height", height + "px") .style("width", width + "px") // daily new cases svg.append("g") // .attr("fill", d => d[field] == null ? "red" : "steelblue") // .attr("fill-opacity", 0.8) .selectAll("rect") .data(sorted) .join("rect") .attr("x", d => x(timeParse(d.as_of_date))) .attr("width", x.bandwidth()) .attr("y", d => y(d[field] == null ? 10 : d[field])) .attr("height", d => y(0) - y(d[field] == null ? 10 : d[field])) .attr("fill", d => d[field] == null ? "red" : "steelblue") .attr("fill-opacity", d => d[field] == null ? 0.3 : 0.8) // for tooltips svg.append("g") .attr("fill", "none") .attr("pointer-events", "all") .selectAll("rect") .data(sorted) .join("rect") .attr("x", d => x(timeParse(d.as_of_date))) .attr("width", x.bandwidth()) .attr("y", 0) .attr("height", height) svg.append("g") .call(xAxis); svg.append("g") .call(yAxis); // if (d3.select('.svg-tooltip').style('visibility') == 'visible') { // d3.select('.svg-tooltip').style('visibility') = 'hidden'; // } return svg.node(); }3d:[{"id":"758df7308c1c1cfe0d51341e81c551173b00685a6bd931ed30cd5d5f6e6f660b52153ff60f63048bc9d5e8f4146d35352dccab05e50c603ff34f0f5ad04bd1c0","href":"https://static.observableusercontent.com/files/758df7308c1c1cfe0d51341e81c551173b00685a6bd931ed30cd5d5f6e6f660b52153ff60f63048bc9d5e8f4146d35352dccab05e50c603ff34f0f5ad04bd1c0","name":"cdph_facilities_only@1.csv","type":"text/csv","lastModified":1607625755535.562,"size":64346}] 38:{"id":"6b184f1a6c3e5138","slug":"snf-covid-trends-for-individual-facilities","title":"SNF covid trends for individual facilities","thumbnail":"614b444a1f546436f526f37a4b313fdd324d07ae10bb73def9864dc82d041a76","access_level":"public","create_time":"$D2020-12-09T22:36:19.907Z","update_time":"$D2021-11-18T17:59:53.002Z","view_time":null,"first_public_time":"$D2020-12-10T19:45:58.290Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b037fb3afc5e643d","login":"ericayee","name":"Erica Yee","avatar_url":"https://avatars-next.observableusercontent.com/e06ee0f58db43307f4bc550b15cf3861ff8c70f1f6f0a132ee4fd3d803b33bd0","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":555,"publish_version":555,"role":null,"authored":false,"authors":[{"type":"individual","id":"2c988eb21019213f","login":"ericayee","name":"Erica Yee","avatar_url":"https://avatars-next.observableusercontent.com/e06ee0f58db43307f4bc550b15cf3861ff8c70f1f6f0a132ee4fd3d803b33bd0","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"2c988eb21019213f","login":"ericayee","name":"Erica Yee","avatar_url":"https://avatars-next.observableusercontent.com/e06ee0f58db43307f4bc550b15cf3861ff8c70f1f6f0a132ee4fd3d803b33bd0","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"SNF covid trends for individual facilities","cells":[{"id":0,"value":"mainTitle = md`# SNF covid trends for individual facilities\nSource: [California Department of Public Health](https://data.chhs.ca.gov/dataset/test-cdph-skilled-nursing-facilities-covid-19/resource/d4d68f74-9176-4969-9f07-1546d81db5a7)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":395,"value":"viewof facilitySelect = autoSelect({\n options: facilities.map(d => d.facility_name),\n placeholder: \"Search for a facility . . .\",\n id: 'facility_search'\n // value: \"A Grace Sub Acute & Skilled Care\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"title = html`

Covid-19 data for ${searchInput.facility_name} in ${searchInput.county} County (${(\"000000000\" + searchInput.facility_id).substr(-9,9)})

` //

Source: CDPH

","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":210,"value":"\nviewof field = select({\n options: [\n'new_resident_cases',\n'total_resident_cases',\n'total_resident_deaths',\n'new_health_care_worker_cases',\n'total_health_care_worker_cases',\n'total_health_care_workers_deaths',\n],\n value: \"total_resident_cases\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"tooltipText = html`

${tooltipTextDate}

${tooltipTextData}

Last 7 days for ${searchInput.facility_name} in ${searchInput.county} County (${(\"000000000\" + searchInput.facility_id).substr(-9,9)})

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"viewof tableWeek = table(\n // sorted.slice(Math.max(sorted.length - 7, 1)).reverse().map(\n sorted.reverse().map(\n ({ as_of_date, new_resident_cases, total_resident_cases, total_resident_deaths, new_health_care_worker_cases, total_health_care_worker_cases, total_health_care_workers_deaths }) => ({\n Date: timeFormat(timeParse(as_of_date)),\n // 'Facility Name': facility_name,\n // County: county,\n // 'Facility ID': facility_id,\n // 'New Resident Cases': new_resident_cases == null ? '<11' : new_resident_cases,\n 'New Resident Cases': checkMasked(new_resident_cases),\n 'Total Resident Cases': checkMasked(total_resident_cases),\n 'Total Resident Deaths': checkMasked(total_resident_deaths),\n 'New HCW Cases': checkMasked(new_health_care_worker_cases),\n 'Total HCW Cases': checkMasked(total_health_care_worker_cases),\n 'Total HCW Deaths': checkMasked(total_health_care_workers_deaths),\n })\n )\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":532,"value":"md`## Get and set data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"searchInput = facilitySelect ? facilities.filter(f => f.facility_name == facilitySelect)[0] : facilities[0];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"SNF_API = (await fetch(`https://data.chhs.ca.gov/api/3/action/datastore_search?resource_id=d4d68f74-9176-4969-9f07-1546d81db5a7&limit=32000&q=${(\"000000000\" + searchInput.facility_id).substr(-9,9)}`)).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"results = SNF_API.result.records","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"sorted = results.sort((a, b) => timeParse(a.as_of_date) - timeParse(b.as_of_date))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":393,"value":"facilities = Object.assign(d3.csvParse(await FileAttachment(\"cdph_facilities_only@1.csv\").text(), d3.autoType))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"tooltip = {\n chart;\n \n // const tooltip = d3\n // .select(\"body\")\n // .append(\"div\")\n // .attr(\"class\", \"svg-tooltip\")\n // .style(\"position\", \"absolute\")\n // .style(\"visibility\", \"hidden\");\n\n // select all rect\n d3.selectAll(\"rect\")\n .on(\"mouseover\", function(d) {\n // tooltip\n // .style(\"visibility\", \"visible\")\n // .text(`${d3.timeFormat('%b %d')(timeParse(d.as_of_date))}\\n${d[field] == null ? '<11' : d[field]} ${field}`)\n mutable tooltipTextDate = `${d3.timeFormat('%b %d')(timeParse(d.as_of_date))}`;\n mutable tooltipTextData = `${d[field] == null ? '<11' : d[field]} ${field}`;\n })\n// .on(\"mousemove\", function() {\n// tooltip\n// .style(\"top\", d3.event.pageY - 10 + \"px\")\n// .style(\"left\", d3.event.pageX + 10 + \"px\");\n// })\n// .on(\"mouseout\", function() {\n// // change the selection style\n// d3.selectAll('.marker').attr('fill', 'none');\n\n// tooltip.style(\"visibility\", \"hidden\");\n// });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":464,"value":"mutable tooltipTextDate = ''","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":485,"value":"mutable tooltipTextData = '';","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"x = d3\n .scaleBand()\n .domain(sorted.map(d => timeParse(d.as_of_date)))\n .range([margin.left, width - margin.right])\n .padding(0.1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"y = d3.scaleLinear()\n .domain([0, Math.max(10, Math.ceil(d3.max(sorted, d => d[field]) / 10) * 10)])\n .range([height - margin.bottom, margin.top])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x)\n .tickValues(x.domain().filter(function(d,i){ return !(i%30)}))\n .tickFormat(d3.timeFormat('%b %d'))\n .tickSize(0))\n .call(g => g.selectAll('.tick text')\n .attr('y', margin.bottom - 25)\n .attr('text-anchor', 'start'))\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"yAxis = g =>\n g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y)\n .ticks(6)\n .tickSize(-width + margin.right))\n .call(g => g.select('.domain')\n .remove())\n .call(g => g.selectAll('.tick:not(:first-of-type) line')\n .attr('stroke-opacity', 0.5)\n .attr('stroke', '#474644')\n .attr('stroke-dasharray', '2,2'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"margin = ({top: 20, right: 20, bottom: 30, left: 20})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"height = 400","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"width = 700","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"md`## Utils`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":350,"value":"function checkMasked(value) {\n if (value == null || isNaN(value)) {\n return '<11'\n } else {\n return String(value)\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"timeParse = d3.timeParse('%Y-%m-%dT%H:%M:%S')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"timeFormat = d3.timeFormat('%m/%d')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"styles = html`\n\n `","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"md`## Appendix`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"import {autoSelect, select} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"import { table } from \"@tmcw/tables/2\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"d3 = require('d3@5')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3d","stdlib":"1"}} 33:null