31:T74c,plot = { const x = { var: 'date', label: 'Date' }, y = { var: 'cases_cum_norm', label: 'Cumulative cases per 100,000 residents' }, c = { var: 'location', label: 'Location' }; // select a point for which to provide details-on-demand const hover = vl .selectSingle() .encodings('x') // limit selection to x-axis value .on('mouseover') // select on mouseover events .nearest(true) // select data point nearest the cursor .empty('none'); // empty selection includes no data points // define our base line chart of stock prices const line = vl.markLine().encode( vl.x({ title: x.label }).fieldT(x.var), vl.y({ title: y.label }).fieldQ(y.var), vl .color({ title: c.label }) .fieldN(c.var) ); // shared base for new layers, filtered to hover selection const base = line.transform(vl.filter(hover)); // mark properties for text label layers const label = { align: 'right', dx: -5, dy: 5 }; const white = { stroke: 'white', strokeWidth: 2 }; return vl .data({ values: data }) .layer( line, // add a rule mark to serve as a guide line vl .markRule({ color: '#aaa' }) .transform(vl.filter(hover)) .encode(vl.x().fieldT('date')), // add circle marks for selected time points, hide unselected points line .markCircle() .select(hover) // use as anchor points for selection .encode( vl .opacity() .if(hover, vl.value(1)) .value(0) ), // add white stroked text to provide a legible background for labels base.markText(label, white).encode(vl.text().fieldQ(y.var)), // add text labels base.markText(label).encode(vl.text().fieldQ(y.var)) ) .width(700) .height(400) .render(); }32:[{"id":"8596ede2bf4ec3b797f96801e200888c09d945a723cf3f7bc0f797c13ec5aa6a217327bbc5fb83e580362e06211e0af6040e55193f2eae8ca063a08aea2cca68","href":"https://static.observableusercontent.com/files/8596ede2bf4ec3b797f96801e200888c09d945a723cf3f7bc0f797c13ec5aa6a217327bbc5fb83e580362e06211e0af6040e55193f2eae8ca063a08aea2cca68","name":"nyt-backup.json","type":"application/json","lastModified":1605890825941.871,"size":215720}] 2f:{"title":"Local Cumulative Coronavirus Cases","cells":[{"id":353,"value":"viewof loader = {\n let title = (progress = '') => md`# Local Cumulative Coronavirus Cases \n ## US Counties + BC Health Authorities\n \n Source: [*The New York Times*](https://github.com/nytimes/covid-19-data) and [British Columbia Centre for Disease Control](http://www.bccdc.ca/health-info/diseases-conditions/covid-19/data)\n\n${progress}\n`;\n let i = 0;\n if (isDataLoaded) return yield title();\n while (true) {\n yield Promises.tick(500, title(md`Loading${'.'.repeat(i++ % 4)}`));\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"md`\n

\n\n

Alabama

Houston County: Dothan

\n\n

Arizona

Maricopa County: Phoenix

\n\n

British Columbia

Vancouver Coastal Health Authority: Squamish; Richmond; Vancouver

\n\n

California

\n\n

Nevada County: Tahoe
San Francisco County: San Francisco

\n\n

Colorado

Boulder County: Boulder

\n\n

Nebraska

Lancaster County: Lincoln

\n\n

Oregon

Jackson County: Ashland; Medford
Lane County: Eugene
Multnomah County: Portland

\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":315,"value":"md`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"md`\nValues for US counties comes from the *New York Times* [Coronavirus (Covid-19) Data in the United States](https://github.com/nytimes/covid-19-data). British Columbia [case data comes from the BCCDC](http://www.bccdc.ca/health-info/diseases-conditions/covid-19/data). [Population estimates for BC health authorities](https://bcstats.shinyapps.io/popApp/) come form BC Stats.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":42,"value":"data = {\n const usdata = d3\n .csv(\n 'https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv'\n )\n .then(processNYT)\n .catch(e => FileAttachment('bccdc-backup.json').json());\n\n const vchdata = d3\n .csv(\n 'https://cors-anywhere.herokuapp.com/http://www.bccdc.ca/Health-Info-Site/Documents/BCCDC_COVID19_Dashboard_Case_Details.csv'\n )\n .then(processBC)\n .catch(e =>\n FileAttachment('BCCDC_COVID19_Dashboard_Case_Details@3.csv')\n .csv()\n .then(processBC)\n );\n\n return Promise.all([usdata, vchdata]).then(data => {\n mutable isDataLoaded = true;\n return data.flat();\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":245,"value":"health_authorities = new Set(['Vancouver Coastal'])","pinned":false,"hidden":false,"mode":"ojs"},{"id":44,"value":"fips = new Set([\n \"41029\",\n \"08013\",\n \"41039\",\n \"04013\",\n \"41051\",\n \"31109\",\n \"06057\",\n \"01069\",\n \"06075\"\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"import { populationByCounty } from '@enjalot/us-county-datasets'","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"import {vl} from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs"},{"id":381,"value":"mutable isDataLoaded = false","pinned":false,"hidden":false,"mode":"ojs"},{"id":412,"value":"processBC = data => {\n const pop = 1193977;\n const vchdata = data.filter(d => health_authorities.has(d.HA));\n let agg = d3\n .nest()\n .key(d => d.Reported_Date)\n .entries(vchdata);\n\n return agg.map((d, i, arr) => {\n d.cases_cum =\n i > 0 ? arr[i - 1].cases_cum + d.values.length : d.values.length;\n d.cases_cum_norm = +d3.format('r')((d.cases_cum / pop) * 1e5);\n d.date = d.key;\n d.location = d.values[0].HA;\n\n delete d.Reported_Date;\n delete d.key;\n delete d.values;\n return d;\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":419,"value":"processNYT = data => {\n data = data.filter(d => fips.has(d.fips));\n let agg = d3\n .nest()\n .key(d => d.fips)\n .entries(data);\n\n data = agg.map(k => {\n return k.values.map((d, i) => {\n let pop = populationByCounty.get(k.key);\n d.cases_cum = +d.cases;\n d.cases_cum_norm = +d3.format('r')((d.cases / pop) * 1e5);\n d.location = `${d.county} County`;\n\n delete d.deaths;\n delete d.cases;\n delete d.state;\n delete d.county;\n delete d.fips;\n return d;\n });\n });\n return data.flat();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"d3 = require('d3@v5')","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}