2e:null 2f:["$","title",null,{"children":"Montana weekly COVID-19 tests data | Eric Dietrich | Observable"}] 34:T4ff,makeCounty = (county, viewType) => { const makeEncoding = (metric, color, domain=false, format=",.0f", label='') => ({ width: 130, height: 150, mark: { type: "bar", size: 5, color: color, tooltip: true, }, encoding: { "x": { "field": "weekEnding", "type": "temporal", "title": "", "axis": {grid: false}, scale: {domain: ['3/1/2020', '7/18/2020']} }, "y": { "field": metric, "type": "quantitative", "axis": {domain: false, format: format, title: label}, scale: {domain: domain} }, } }) const encodings = [ makeEncoding("tests", "#2c7fb8", null, ",.0f", 'Weekly tests'), makeEncoding("positives", "#CA532B", null,",.0f", 'Weekly cases'), makeEncoding("positive_rate", "#31a354", null, "%", 'Positivity rate') ] const hConcat = { hconcat: encodings } const vConcat = { vconcat: encodings } return embed({ data: {values: weeklyData.filter(d => d.County === county)}, config: { view: { padding: 0, stroke: 'transparent', }, facet: { spacing: {row: 30, column: 10}, }, }, ...(width > 500 ? hConcat : vConcat) }, embedConfig) }35:T625,verticalCounty = (county) => { const makeEncoding = ({metric, color, domain=false, format=".0f", title, label}) => ({ title: title, width: 80, height: 80, mark: { type: "bar", size: 3, color: color, tooltip: null, }, encoding: { "x": { "field": "weekEnding", "type": "temporal", "title": "", "axis": {grid: false, format: '%b' }, scale: {domain: ['3/1/2020', '7/18/2020']} }, "y": { "field": metric, "type": "quantitative", "axis": {domain: false, format: format, title: '', titleFontWeight: 'normal'}, scale: {domain: domain} }, } }) return embed({ data: {values: weeklyData.filter(d => d.County === county)}, // data: {values: weeklyData}, config: { title: { anchor: 'start', fontSize: 11, color: '#444' }, view: { padding: 0, stroke: 'transparent', }, facet: { spacing: {row: 30, column: 10}, }, }, vconcat: [ makeEncoding({ metric: "tests_per_10k", label: "Testing rate", color: "#2c7fb8", domain: [0,1500], format: null, title: county, }), makeEncoding({ metric: "positives_per_10k", label: "Case rate", color: "#CA532B", domain: [0,40], format: null, title: '', }), // makeEncoding("positive_rate", "#31a354", null, "%") ] }, embedConfig) }36:[{"id":"d728e5f5b2b9c293d0459158a880430e6586773e373b3c624d166233f3279c959c8bf6d193e6b2167071f35c4e590d924992e1a16445c84043b9ca9b6cc92ad0","href":"https://static.observableusercontent.com/files/d728e5f5b2b9c293d0459158a880430e6586773e373b3c624d166233f3279c959c8bf6d193e6b2167071f35c4e590d924992e1a16445c84043b9ca9b6cc92ad0","name":"mt-weekly-covid-tests@3.csv","type":"text/csv","lastModified":1596231675606.589,"size":42677}] 32:{"id":"1a9c736382608aa6","slug":"montana-weekly-covid-19-tests-data","title":"Montana weekly COVID-19 tests data","thumbnail":"b50543a5c6ddbc9f6ce9d6ebf449103aaa9066898eeefe1e77d8861cd819d51f","access_level":"public","create_time":"$D2020-07-31T16:02:12.902Z","update_time":"$D2020-08-05T15:08:13.174Z","view_time":null,"first_public_time":"$D2020-08-03T18:35:29.742Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"8fa547b9c358d4e8","login":"eidietrich","name":"Eric Dietrich","avatar_url":"https://avatars-next.observableusercontent.com/6a4f9d38834facbf55e9160551ff5c73115e28ebaddfbfc0116118b6d82c216d","tier":"starter_2024"},"version":764,"publish_version":764,"role":null,"authored":false,"authors":[{"type":"individual","id":"4bd52d95d518f450","login":"eidietrich","name":"Eric Dietrich","avatar_url":"https://avatars-next.observableusercontent.com/6a4f9d38834facbf55e9160551ff5c73115e28ebaddfbfc0116118b6d82c216d","tier":null}],"members":[{"type":"individual","id":"4bd52d95d518f450","login":"eidietrich","name":"Eric Dietrich","avatar_url":"https://avatars-next.observableusercontent.com/6a4f9d38834facbf55e9160551ff5c73115e28ebaddfbfc0116118b6d82c216d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Montana weekly COVID-19 tests data","cells":[{"id":0,"value":"md`# Montana weekly COVID-19 tests data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"weeklyData = {\n const raw = d3.csvParse(await FileAttachment(\"mt-weekly-covid-tests@3.csv\").text())\n raw.forEach(d => {\n d.weekEnding = new Date(d.week)\n d.population = +d.population\n d.tests = +d.tests\n d.tests_per_10k = +d.tests / +d.population * 10000\n d.positives = +d.positives\n d.positives_per_10k = +d.positives / +d.population * 10000\n d.positive_rate = (+d.tests >= 10) ? +d.positive_rate : null // report positivity rate only for weeks with at least 10 tests\n })\n return raw\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"dateDomain = d3.extent(weeklyData, d => d.weekEnding)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"counties = Array.from(new Set(weeklyData.map(d => d.County)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"top12 = ['YELLOWSTONE','GALLATIN','MISSOULA','FLATHEAD','LAKE','CASCADE','BIG HORN','LEWIS AND CLARK','RAVALLI','TOOLE','CUSTER','GLACIER']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":475,"value":"countyPlots = {\n\n const buildChart = async c => html`

${await verticalCounty(c)}

`\n const charts = Promise.all(top12.map(buildChart))\n \n return html`\n

\n \n

County testing rate and case rate trends

Weekly figures for top 12 Montana counties by known COVID-19 cases.

\n ${makeLegend('#2c7fb8','#CA532B')}\n

\n ${await charts}\n \n

Data: Montana Dept. of Public Health and Human Services. Graphics: Eric Dietrich / MTFP

\n`\n}\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":655,"value":"md`#### Weekly trend for specific county`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"viewof curCounty = select({\n title: \"\",\n description: \"Select a county\",\n options: counties,\n value: \"YELLOWSTONE\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"countyInteractive = {\n\n \n return html`\n

\n \n

${curCounty} COUNTY

\n ${await makeCounty(curCounty, 'total')}\n

Data is current through July 18. Positivity rate is the percentage of tests returning positive each week, calculated only for weeks where the county saw at least 10 tests.

Data: Montana Dept. of Public Health and Human Services. Interactive: Eric Dietrich / MTFP

\n`\n}\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":724,"value":"countyTotals = {\n const data = weeklyData.filter(d => d.County === curCounty)\n return {\n tests: d3.sum(data, d => d.tests),\n positives: d3.sum(data, d => d.positives)\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":753,"value":"md`## All counties`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":757,"value":"allCountyPlots = {\n const buildChart = async c => html`

${await verticalCounty(c)}

`\n const charts = Promise.all(counties.map(buildChart))\n return html`\n

\n \n ${makeLegend('#2c7fb8','#CA532B')}\n

\n ${await charts}\n

Data: Montana Dept. of Public Health and Human Services. Graphics: Eric Dietrich / MTFP

\n`\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"md`## 12 counties with most COVID-19 cases\nShowing COVID-19 case and testing **${viewType === 'per-10k' ? 'rates per 10,000 residents' : 'totals'}** at a county level. Positivity rate plot excludes weeks where less than 10 tests were conducted in a specific county.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"viewof viewType = DOM.select(['per-10k','total'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"plotCountyFacet({\n data: weeklyData.filter(d => top12.includes(d.County)),\n metric: (viewType === 'total') ? 'positives' : 'positives_per_10k',\n color: '#CA532B',\n // domain: [0,30]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"plotCountyFacet({\n data: weeklyData.filter(d => top12.includes(d.County)),\n metric: (viewType === 'total') ? 'tests' : 'tests_per_10k',\n color: '#2c7fb8',\n // domain: [0,1500]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"plotCountyFacet({\n data: weeklyData.filter(d => top12.includes(d.County)),\n metric: 'positive_rate',\n color: '#31a354',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":605,"value":"makeLegend = (color1, color2) => html`

\n \n Tests conducted per 10k residents (Top)\n

\n \n

\n \n New cases per 10k residents (Bottom)\n

\n \n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":471,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"plotCountyFacet = ({data, metric, color, domain}) => {\n return embed({\n data: {values: data},\n width: 100,\n height: 100,\n \n config: {\n view: {\n padding: 0,\n stroke: 'transparent',\n },\n facet: {\n spacing: {row: 40, column: 5},\n }\n },\n mark: {\n type: \"bar\",\n size: 3,\n color: color,\n tooltip: true,\n },\n encoding: {\n \"x\": {\n \"field\": \"weekEnding\",\n \"type\": \"temporal\",\n \"title\": \"\",\n \"axis\": {grid: false}\n },\n \"y\": {\n \"field\": metric,\n \"type\": \"quantitative\",\n \"axis\": {domain: false},\n scale: { domain: domain}\n },\n \"facet\": {\n \"field\": \"County\",\n \"type\": \"nominal\",\n columns: 7,\n title: '',\n header: {labelOrient: 'top', labelAnchor: 'start', labelPadding: 0},\n sort: {field: 'positives', op: \"sum\", type: \"quantitative\", order: \"descending\",}\n }\n }\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"embed = require('vega-embed@6')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":686,"value":"embedConfig = ({actions: false, renderer: 'canvas'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":665,"value":"import { select } from '@jashkenas/inputs'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 33:"$32:body"