2f:T592,metricsMeta = ({ N_PMMoV: { label: "N gene - all variants / PMMoV", color: "#7fa2db" }, N: { label: "N gene - all variants", color: "#7fa2db" }, S_PMMoV: { label: "S gene - all variants / PMMoV", color: "#3865b0" }, S: { label: "S gene - all variants", color: "#3865b0" }, Delta_156157_PMMoV: {label: "Delta / PMMoV", color: "#45d991"}, Delta_156157: {label: "Delta", color: "#45d991"}, Del_143145_PMMoV: { label: "BA.1 Omicron / PMMoV", color: "#ffb14e"}, Del_143145: { label: "BA.1 Omicron", color: "#ffb14e"}, BA_2_LPPA24S_PMMoV: { label: "(BA.2 + BA.4 + BA.5 Omicron) / PMMoV", color: "#eb5f34"}, BA_2_LPPA24S: { label: "(BA.2 + BA.4 + BA.5 Omicron)", color: "#eb5f34"}, BA_4_ORF1a_Del_141143_PMMoV: { label: "BA.4 Omicron / PMMoV", color: "#cd34b5"}, BA_4_ORF1a_Del_141143: { label: "BA.4 Omicron", color: "#cd34b5"}, HV_6970_Del_PMMoV: { label: "(BA.4 + BA.5 + BQ.* Omicron)/PMMoV", color: "#9d02d7"}, HV_6970_Del: { label: "(BA.4 + BA.5 + BQ.* Omicron)", color: "#9d02d7"}, BA_2_75_S_147E_S_152R_PMMoV: {label: "BA 2.75 Omicron / PMMoV", color: "#FF1175"}, // BA 2.75 BA_2_75_S_147E_S_152R: {label: "BA 2.75 Omicron", color: "#FF1175"}, XBB_bkpt_PMMoV: {label: "XBB Omicron / PMMoV", color: "#764FFF"}, XBB_bkpt: {label: "XBB Omicron", color: "#764FFF"}, }) //["#ffb14e","#fa8775","#ea5f94","#cd34b5","#9d02d7", "#FF1175"]30:T3303,plotOverview = function (l, params) { // todo: revisit all "params" (put in place for monkeypox issues near 0) const ndLimit = params?.ndlimit ? params.ndlimit : ndLimits[l]; let cutoffDate = params?.cutoffdate ? new Date(params.cutoffdate) : new Date(cutoffDates[l]); let data = rawdata.filter( (d) => (d.Plant == l) & (d.date >= new Date(earliestDate)) ); let dates = d3.map(data, (d) => d.date); let dataPoints = data.filter((d) => d.date < cutoffDate); let dataLines = data.filter((d) => d.date >= cutoffDate); let dataByDate = d3.group(data, (d) => d.dateformatted); let dateExtent = [new Date(earliestDate), new Date()]; let props = { margin: { top: 80, right: 180, bottom: 60, left: leftMargin } }; props.chartHeight = totalheight - props.margin.top - props.margin.bottom; props.chartWidth = totalwidth - props.margin.right - props.margin.left; let dayMultiple = props.chartWidth / d3.timeDay.count(new Date(dateExtent[0]), new Date(dateExtent[1])); let twoWeeksAgo = data[ data .map((e) => timeFormat(e.date)) .indexOf(timeFormat(d3.timeDay.offset(new Date(), -14))) ]; let timelabels = { full: "2 weeks", abbv: "2w" }; // if no data 14 days ago, try looking backwards let countup = 14 while (typeof twoWeeksAgo == "undefined" & countup <= 30) { twoWeeksAgo = data[ data .map((e) => timeFormat(e.date)) .indexOf(timeFormat(d3.timeDay.offset(new Date(), -1 * countup))) ]; timelabels = { full: countup + " days", abbv: countup + "d" }; countup++ } // if no data 14-30 days ago, try looking forward let countdown = 14 while (typeof twoWeeksAgo == "undefined" & countdown >= 7) { twoWeeksAgo = data[ data .map((e) => timeFormat(e.date)) .indexOf(timeFormat(d3.timeDay.offset(new Date(), -1 * countdown))) ]; timelabels = { full: countdown + " days", abbv: countdown + "d" }; countdown = countdown - 1; } let twoWeeksAgoMean = d3.mean(metricsToDefineYGridlines.map((e) => twoWeeksAgo[e])); let minValue = log ? d3.min(data, (d) => d3.min(metrics.map((metric) => d[metric]))) : 0; let maxValue = d3.max(data, (d) => d3.max(metrics.map((metric) => d[metric]))); let ydomain = [ d3.min([minValue, twoWeeksAgoMean / 2]), maxValue == 0 ? .000001 : maxValue ]; let xScale = d3.scaleLinear().domain(dateExtent).range([0, props.chartWidth]); let yScale = log ? d3.scaleLog() : d3.scaleLinear(); const svg = d3 .create("svg") .attr("width", props.chartWidth + props.margin.left + props.margin.right) .attr("height", props.chartHeight + props.margin.top + props.margin.bottom); let chart = svg .append("g") .attr( "transform", "translate(" + props.margin.left + "," + props.margin.top + " )" ); yScale.domain(ydomain).range([props.chartHeight, 0]); // axis let formatMyDates = d3.timeFormat("%b %e"); let formatMyDatesYear = d3.timeFormat("%b %e, %Y"); let xAxis = d3 .axisBottom(xScale) .tickValues(d3.timeDay.range(dateExtent[0], dateExtent[1], 7 * x_weeks)) .tickFormat((d) => formatMyDates(d)) .tickSize(10); let intervalLabels = [ minValue == 0 ? "0" : "", "half " + timelabels.abbv + " ago", timelabels.abbv + " ago" ]; let intervalValues = [minValue, twoWeeksAgoMean / 2, twoWeeksAgoMean]; if (twoWeeksAgoMean * 2 < ydomain[1]) { intervalValues.push(twoWeeksAgoMean * 2); intervalLabels.push("twice " + timelabels.abbv + " ago"); } if (twoWeeksAgoMean == 0) { intervalLabels = ["2w ago"]; intervalValues = [0]; } if (metrics.filter(x => metricsToDefineYGridlines.includes(x)).length == 0 || typeof(twoWeeksAgoMean) == 'undefined') { intervalLabels = []; intervalValues = []; } let yAxis = d3 .axisLeft(yScale) .tickValues(intervalValues) .tickFormat((d, i) => { return intervalLabels[i]; }); chart.append("g").call(yAxis).selectAll("text").attr("fill", "#101b63"); chart .append("g") .attr("transform", "translate(0," + props.chartHeight + ")") .call(xAxis); chart.selectAll(".domain").attr("stroke", "#d6d6d6"); chart.selectAll(".tick").selectAll("line").attr("stroke", "#d6d6d6"); // title chart .append("text") .attr("transform", "translate(0,-38)") .attr("font-size", "20px") .text(humanReadableLocationNames[l]); chart .append("text") .attr("transform", "translate(0,-20)") .attr("font-size", "14px") .text(mainTitle); chart .append("text") .attr( "transform", "translate(" + props.chartWidth / 2 + "," + (props.chartHeight + props.margin.top - 40) + ")" ) .attr("text-anchor", "middle") .attr("font-size", "14px") .text(xlabel); chart .append("text") .attr( "transform", "rotate(270)translate(" + (-1 * props.chartHeight) / 2 + ",-80)" ) .attr("text-anchor", "middle") .attr("font-size", "14px") .text(ylabel); // gridlines chart .append("g") .selectAll("line") .data(intervalValues.slice(1, intervalValues.length)) .join("line") .attr("x1", xScale.range()[0]) .attr("x2", xScale.range()[1]) .attr("y1", (d) => yScale(d)) .attr("y2", (d) => yScale(d)) .attr("stroke", gridlineColor) .attr("stroke-width", 1) .attr("stroke-dasharray", (d, i) => { if (i == 1) { return "5,2"; } return "1,3"; }); let gridlines = chart .append("g") .attr( "transform", "translate(" + xScale(twoWeeksAgo.date) + "," + yScale.range()[1] + ")" ); // vertical for two weeks ago gridlines .append("line") .attr("y1", yScale.range()[0]) .attr("stroke", "#ababab"); gridlines.append("circle").attr("r", 2).attr("fill", "#757575"); gridlines .append("text") .attr("x", 2) .attr("y", 3) .attr("font-size", "10px") .attr("fill", "#757575") .text(formatMyDates(twoWeeksAgo.date) + " (" + timelabels.abbv + " ago)"); // the data curves chart .append("g") .selectAll("g") .data(metrics) .join("path") .attr("d", (metric) => { return d3 .line() .y((d) => yScale(d[metric])) .defined((d) => isFinite(yScale(d[metric]))) .x((d) => xScale(d.date))(dataLines); }) .attr("fill", "none") .attr("stroke", (metric) => { return metricsMeta[metric]["color"]; }) .attr("stroke-width", 3) .attr("opacity", 0.75) .attr("class", "lines"); // the data points [for early history when sampling was not yet supposed to be daily] for (const [i] in metrics) { // points chart .append("g") .selectAll("g") .data(dataPoints.filter((d) => isFinite(yScale(d[metrics[i]])))) .join("circle") .attr("stroke", "none") .attr("fill", metricsMeta[metrics[i]]["color"]) .attr("cx", (d) => xScale(d.date)) .attr("cy", (d) => yScale(d[metrics[i]])) .attr("r", 3); // hover points let lasttwoweeks = chart.append("g").selectAll("g") .data(data.filter(d => !isNaN(d[metrics[i]]))); lasttwoweeks .join("circle") .attr("stroke", "black") .attr("fill", metricsMeta[metrics[i]]["color"]) .attr("cx", (d) => xScale(d.date)) .attr("cy", (d) => yScale(d[metrics[i]])) .attr("class", (d) => "date_" + d.dateformatted + " tooltipPoints") .attr("r", 5) .attr("opacity", 0); /* lasttwoweeks.join('line') .attr('stroke', metricsMeta[metrics[i]]['color']) .attr('x1', d => xScale(d.date)) .attr('y1', d => yScale(d[metrics[i]])) .attr('x2', d => xScale(new Date(offset2weeks(d.dateformatted)))) .attr('y2', d => { let twoweeksago = dataByDate.get(offset2weeks(d.dateformatted)); if(twoweeksago){ return yScale(twoweeksago[0][metrics[i]])} }) .attr('class', d => "date_" + d.dateformatted + ' tooltipPoints') .attr('stroke-width', 2) .attr('opacity', 0) */ } // Add Labels to lines (assuming last value is in the lines group) let yLabelPlacements = []; // todo: better handle for empty dataLines let lastvalue = dataLines.length > 0 ? dataLines[dataLines.length - 1] : dataPoints[dataPoints.length - 1]; metrics.forEach((m) => { // todo: better handle for empty dataLines let nonNAN = dataLines.length > 0 ? dataLines.filter(d => !isNaN(d[m])) : dataPoints.filter(d => !isNaN(d[m])); let value = nonNAN[nonNAN.length - 1] if(value){ yLabelPlacements.push({ metric: m, missing: false, pixel: value[m] == 0 ? yScale(0) - 8 : yScale(value[m]), xpixel: xScale(value.date) }); } else { yLabelPlacements.push({ metric: m, missing: true, pixel: yScale(0) - 8, xpixel: xScale.range()[1] }); } }); // adjust yLabel location to avoid overflow yLabelPlacements = yLabelPlacements.sort((a, b) => a.pixel - b.pixel); if (yLabelPlacements.length > 1) { if (yLabelPlacements[1].pixel - yLabelPlacements[0].pixel < 10) { yLabelPlacements[0].pixel = yLabelPlacements[1].pixel - 10; } if (yLabelPlacements.length > 2) { if (yLabelPlacements[2].pixel - yLabelPlacements[1].pixel < 10) { yLabelPlacements[2].pixel = yLabelPlacements[1].pixel + 10; } } } chart .append("g") .selectAll("text") .data(yLabelPlacements) .join("text") .attr( "transform", (yLabel, i) => "translate(" + (2 + yLabel.xpixel) + "," + (yLabel.pixel + 4) + ")" ) .attr("fill", (yLabel) => metricsMeta[yLabel.metric].color) .attr("x", 2) .attr("font-size", "10px") .text((yLabel) => yLabel.missing ? 'No Data: ' + metricsMeta[yLabel.metric].label : metricsMeta[yLabel.metric].label); // show a mark on x-axis for all dates we have data for chart .append("g") .selectAll("line") .data(dates) .join("line") .attr("x1", (d) => xScale(d) + 0.5) .attr("x2", (d) => xScale(d) + 0.5) .attr("y1", yScale.range()[0] + 3) .attr("y2", yScale.range()[0]) .attr("stroke", "black") .attr("stroke-width", 2); // for capturing mouseover events let datesFormatted = dates.map((d) => timeFormat(d)); chart .append("g") .selectAll("line") .data(d3.timeDays(dateExtent[0], d3.timeDay.offset(dateExtent[1], 1), 1)) .join("rect") .attr("x", (d) => xScale(d) - dayMultiple / 2) .attr("width", dayMultiple + 0.2) .attr("y1", yScale.range()[0] + 3) .attr("height", yScale.range()[0] - yScale.range()[1]) .attr("opacity", 0) /*.attr('opacity', d => { if(datesFormatted.indexOf(timeFormat(d)) == -1){ return .4 }; return 0 })*/ .attr("fill", "grey") .attr("stroke", "none") .attr("cursor", "pointer") .on("mouseover", showTooltip) .on("mousemove", moveTooltip) .on("mouseout", hideTooltip); const gradientId = "gradient-vertical-fade"; //+ Math.random(); const gradientSel = chart .append("linearGradient") .attr("id", gradientId) .attr("x1", 0) .attr("x2", 0) .attr("y1", 1) .attr("y2", 0); gradientSel .append("stop") .attr("offset", "50%") .attr("stop-color", "rgba(200,200,200,1)"); gradientSel .append("stop") .attr("offset", "70%") .attr("stop-color", "rgba(200,200,200,.8)"); gradientSel .append("stop") .attr("offset", "100%") .attr("stop-color", "rgba(200,200,200,.1)"); chart .append("rect") .attr("width", props.chartWidth) .attr("height", props.chartHeight - yScale(ndLimit)) .attr("y", yScale(ndLimit)) .attr("fill", `url(#${gradientId})`); function moveTooltip(event, d) { tooltip //.style('top', (event.pageY - event.layerY + props.margin.top - 10) + 'px') .style("top", event.pageY + 30 + "px") .style("left", event.pageX + "px"); for (const [i] in metrics) { let ltw = d3 .selectAll(".lasttwoweeksmark_" + metrics[i]) .attr("transform", (d) => console.log(d)); /* ltw.select("circle") .attr('cx', xScale(datavalue.date)) .attr('cy', yScale(datavalue[metrics[i]])) */ } } function showTooltip(event, d) { d3.selectAll(".date_" + timeFormat(d)).attr("opacity", 1); if(params?.showdetailtooltip) { tooltip .html(`

${d}

`) .style("visibility", "visible"); } else { tooltip .html(`

${formatMyDatesYear(d)}

`) .style("visibility", "visible"); } } function hideTooltip(event, d) { d3.selectAll("." + "tooltipPoints").attr("opacity", 0); tooltip.html(``).style("visibility", "hidden"); } return svg.node(); }31:[] 2d:{"title":"overview chart: covid in wastewater","cells":[{"id":0,"value":"md`# overview chart: covid in wastewater`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1171,"value":"md`These charts **are published to live websites**. Do not change without checking with Anupam or Zan.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1115,"value":"viewof log = Select([false, true], {label: \"log\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1186,"value":"mainTitle = \"Tracking change in quantity of 2 SARS-CoV-2 genes since \" + d3.timeFormat('%b %e')(earliestDateUnformatted) ","pinned":true,"hidden":false,"mode":"ojs"},{"id":1183,"value":"ylabel = \"Quantity of RNA, normalized\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1182,"value":"xlabel = \"Date of Sample\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1191,"value":"howto = html`\n

How to read the plots?

1. Solid trend lines show the quantity of RNA from 2 SARS-COV-2 genes: N and S; Normalized by PMMoV to account for “fecal strength”.

2. Higher value on Y axis indicates more SARS-COV-2 virus. Values shown represent a trimmed 5-day moving average.

3. Dashed horizontal line provides a comparison to 2 weeks ago

4. Black marks on x-axis indicate that the data was sampled that day (typically daily, but sometimes a day is missed)

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":887,"value":"credit = html`Credit: SCAN project by Stanford University`","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"paloalto = plotOverview(\"Palo Alto\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":851,"value":"sanjose = plotOverview(\"San Jose\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":868,"value":"gilroy = plotOverview(\"Gilroy\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":874,"value":"sunnyvale = plotOverview(\"Sunnyvale\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":1582,"value":"davis = plotOverview('Davis')","pinned":false,"hidden":false,"mode":"ojs"},{"id":1585,"value":"codiga = plotOverview('CODIGA', {cutoffdate: '2030-01-01'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1127,"value":"md`### Data Parameters`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1478,"value":"x_weeks = num_weeks <= 6 ? 1 : num_weeks <= 12 ? 2 : num_weeks <= 20 ? 4 : 8","pinned":true,"hidden":false,"mode":"ojs"},{"id":659,"value":"smoothing = \"_trimmed5\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1105,"value":"md`### Chart Parameters`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1090,"value":"totalwidth = 600","pinned":true,"hidden":false,"mode":"ojs"},{"id":1089,"value":"totalheight = 300","pinned":true,"hidden":false,"mode":"ojs"},{"id":905,"value":"leftMargin = 100","pinned":true,"hidden":false,"mode":"ojs"},{"id":770,"value":"num_weeks = 6","pinned":true,"hidden":false,"mode":"ojs"},{"id":1737,"value":"humanReadableLocationNames = ({\n 'Palo Alto': 'Palo Alto',\n 'San Jose': 'San Jose',\n 'Oceanside': 'Oceanside (Western San Francisco)',\n 'Silicon Valley': 'Silicon Valley Clean Water',\n 'CODIGA': 'CODIGA (Stanford University)',\n 'Davis': 'Davis',\n 'Gilroy': 'Gilroy',\n 'Sunnyvale': 'Sunnyvale',\n 'Sacramento': 'Sacramento',\n 'UC Davis': 'UC Davis',\n 'Merced': 'Merced',\n 'Modesto': 'Modesto',\n 'Southeast San Francisco': '\"Southeast\" (Eastern San Francisco)',\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":663,"value":"cutoffDates = ({\n 'Palo Alto': '2020-11-18',\n 'San Jose': '2020-11-17',\n 'Oceanside': '2020-12-10',\n 'Silicon Valley': '2020-12-10',\n 'CODIGA': '2021-07-29',\n 'Davis': '2020-11-25',\n 'Gilroy': '2020-12-03',\n 'Sunnyvale': '2020-12-02',\n 'Sacramento': '2020-12-10',\n 'UC Davis': '2021-05-01',\n 'Merced': '2021-10-20',\n 'Modesto': '2021-10-20',\n 'Southeast San Francisco': '2022-05-20'\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":655,"value":"//metrics = [\"N_PMMoV\",\"S_PMMoV\"]\nmetrics = [\"N_PMMoV\",\"S_PMMoV\"]","pinned":true,"hidden":false,"mode":"ojs"},{"id":1633,"value":"metricsAllVariants = [\"N_PMMoV\",\"S_PMMoV\"]","pinned":true,"hidden":false,"mode":"ojs"},{"id":1763,"value":"metricsToDefineYGridlines = metricsAllVariants // for covid use N & S to define gridlines, for other pathogens will import \"with\" to overright this with appropriate metric","pinned":true,"hidden":false,"mode":"ojs"},{"id":1774,"value":"gridlineColor = \"#101b63\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":1401,"value":"ndLimits = ({\n Sacramento: 0.00000123,\n \"Silicon Valley\": 0.00000031,\n Oceanside: 0.00000162,\n Gilroy: 0.000000294,\n Sunnyvale: 0.000000557,\n Davis: 0.000000965,\n \"Palo Alto\": 0.000000703,\n \"San Jose\": 0.000000467,\n CODIGA: 0.0000026\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1638,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":1100,"value":"md`### Charting functions`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1833,"value":"mutable temp = []","pinned":true,"hidden":false,"mode":"ojs"},{"id":1927,"value":"tempchart = plotOverview(\"Oceanside\", params)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1929,"value":"params = ({cutoffdate: \"2023-01-01\", ndlimit: -.0001, showdetailtooltip: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":732,"value":"$30","pinned":true,"hidden":false,"mode":"ojs"},{"id":976,"value":"tooltip = d3\n .select('body')\n .append('div')\n .attr('class', 'scan-tooltip')\n .style('position', 'absolute')\n .style('z-index', '10')\n .style('visibility', 'hidden')\n .style('padding', '5px')\n .style('background', 'white')\n .style('border-radius', '4px')\n .style('border', \"1px solid grey\")\n .style('opacity', \".9\")\n .style('left', '50%')\n .style('transform', 'translateX(-50%)')\n .style('color', 'black');","pinned":true,"hidden":false,"mode":"ojs"},{"id":935,"value":"html`\n`","pinned":true,"hidden":false,"mode":"ojs"},{"id":1138,"value":"md`### Supporting functions`","pinned":true,"hidden":false,"mode":"ojs"},{"id":1055,"value":"offset2weeks = function(date){\n return timeFormat(d3.timeDay.offset(new Date(date), -14))\n}\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":657,"value":"earliestDate = timeFormat(earliestDateUnformatted)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1388,"value":"earliestDateUnformatted = d3.timeDay.offset(new Date(), -(7 * num_weeks))","pinned":true,"hidden":false,"mode":"ojs"},{"id":653,"value":"timeParse = d3.timeParse(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":647,"value":"parseData = (d) => {\n d.datetime = d.Date.replace(' ', 'T')\n if (new Date(d.datetime) >= new Date(earliestDate)) { \n let r = {\n date: timeParse(d.datetime.substring(0, 10)),\n dateformatted: d.datetime.substring(0, 10),\n };\n if (new Date(d.datetime) >= new Date(cutoffDates[d.Plant])) {\n metrics.forEach((metric) => (r[metric] = +d[metric + smoothing]));\n } else {\n metrics.forEach((metric) => (r[metric] = +d[metric]));\n }\n r[\"Plant\"] = d.Plant;\n return r;\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":794,"value":"timeFormat = d3.timeFormat('%Y-%m-%d');","pinned":true,"hidden":false,"mode":"ojs"},{"id":1613,"value":"omicron_color = \"#448388\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"md`### get data from data notebook\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1568,"value":"mutable mutVar = []","pinned":true,"hidden":false,"mode":"ojs"},{"id":606,"value":"rawdata = d3.csv(url, parseData)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1504,"value":"test = d3.csv(url)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1506,"value":"[...new Set(test.map((d) => d.Plant))]","pinned":true,"hidden":false,"mode":"ojs"},{"id":1643,"value":"test.map(d => d.N_PMMoV_trimmed5)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1517,"value":"rawdata.filter((d) => d.Plant == \"Oceanside\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1370,"value":"url = \"https://storage.googleapis.com/soe-wwd-data/dashboard.csv?no_cache=\" + Math.random()\n//\"https://storage.googleapis.com/soe-wwd-data/4462.csv?\" + Math.random()","pinned":true,"hidden":false,"mode":"ojs"},{"id":55,"value":"md`### Libraries`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1178,"value":"Select = Inputs.Select","pinned":true,"hidden":false,"mode":"ojs"},{"id":1180,"value":"Inputs = require(\"@observablehq/inputs@0.7.17/dist/inputs.umd.min.js\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":10,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}