35:["$","title",null,{"children":"Andy's CDC Cruise Ship COVID outbreak tracker | Andy Bloch | Observable"}] 3d:T558,html`

${ Plot.plot({ //grid: true, //inset: 0, width: 1024, height: 3000, x: { //type: "time", //nice: true, //label: "Date", //ticks: 3, //inset: 10, //marginRight: 0, }, y: { //domain: d3.groupSort(barley, g => -d3.median(g, d => d.yield), d => d.variety), inset: 0, ticks: 4, grid: true, label: "Positives" }, color: { type: "sqrt", domain: [-.01,.03], //domain: [0.01,0.02,0.03,0.04,0.05,0.06,0.07,0.08,0.09], //range: d3.schemeSpectral[0], }, facet: { data: allData, //x: "vesselIndex", //x: d=>(d.vesselIndex-1) % 5, x: d=> (d.vesselTotals.sortedIndex % 4) + 1, //y: d=>Math.floor((d.vesselIndex-1) / 5), y: d=> Math.floor(d.vesselTotals.sortedIndex / 4), marginRight: 0, label: null, //y: "Cruise.Line" }, marks: [ Plot.frame({ stroke: "grey", }), Plot.barY(allData, { title: "VesselName", x: d=>d.reportDate + 1, y: "Rate", fill: "Rate", }), Plot.text(allData, { text: "VesselName", fontSize: 15, textAnchor: "start", x: 0, y: 0.035, fill: d=>d.vesselTotals.totalRate/14, stroke: "#ffffff50", strokeWidth: 5, //fill: "Cruise.Line", }) ] }) }

`3e:T798,async function fetchData(params="") { // let oldParams = "?date=2022-07-18"; let data = await d3.csv("https://labvegas.com/data/covid19/cruises/dashboard-EDC totals by ship and 28 days.csv"+params, d3.autoType); //let oldData = await d3.csv("https://labvegas.com/data/covid19/cruises/dashboard-EDC totals by ship and 28 days.csv"+oldParams, d3.autoType); //data.sort((a,b)=> a.reportDate - b.reportDate); console.log(data); let prev = null ; let vesselsByCruiseLine = {}; let allVessels = {}; let vesselCount = 0; data.forEach(d=>{ d.Date=new Date(d.reportDate); d.Rate = d["tot.pos"] / (d.numcrew + d.numpax); d.Positivity = d["tot.test"] ? d["tot.pos"] / d["tot.test"] : null; let cl = d["Cruise.Line"]; let vessel = d.VesselName; allVessels[vessel] = (allVessels[vessel] || { totalPeople:0, totalPositive:0, totalRate:0, index: ++vesselCount, }); let vesselIndex = allVessels[vessel].index; d.vesselTotals = allVessels[vessel]; allVessels[vessel].totalPositive += d["tot.pos"]; allVessels[vessel].totalPeople += d.numcrew + d.numpax; allVessels[vessel].totalRate += isNaN(d.Rate) ? 0 : d.Rate; let vessels = vesselsByCruiseLine[cl] = vesselsByCruiseLine[cl] || {}; let vesselIndexCL = vessels[vessel]; if (!vesselIndexCL) { vesselIndexCL = Object.keys(vessels).length + 1; vessels[vessel] = vesselIndexCL; } d.vesselIndexCL = vesselIndexCL; d.vesselIndex = vesselIndex; d.SympPositivity = d["tot.symp.pos"] / d["tot.symp.test"]; d.AsympPositivity = d["tot.asymp.pos"] / d["tot.asymp.test"]; d.TestsPerPerson = d["tot.test"] / (d.numcrew + d.numpax); }); let sorted = Object.entries(allVessels); sorted.sort((a,b)=> b[1].totalRate - a[1].totalRate); sorted.forEach((kv,i) => { kv[1].sortedIndex = i; }); console.log(data); console.log("sorted",sorted); return data; } 3f:T758,function plotColorStatusData(data, ycolumn="Cases among % Crew", x = d=>d.numpax + d.numcrew, xlabel = "Total passengers and crew", radius) { function shortCompany(c) { return c.split(" CRUISE")[0].replace(" CORPORATION","").replace(" GROUP",""); } let colorRange = [...d3.schemePaired]; colorRange[10] = "#eeee00"; return Plot.plot({ height: 400, width: 1000, marginLeft: 75, marginRight: 25, marginTop: 25, marginBottom: 45, style: { fontSize: 15, }, color: { legend: "swatches", columns: "11em", range: colorRange }, //x: {type: "label"}, x: { label: xlabel, labelAnchor: "center", //type: "band", //domain: d3.sort(data, d=> d.numcrew + d.numpax).map(d=>d["Ship Name"]) }, y: { labelAnchor: "center", label: ycolumn.replace(" %","").replace("Pax"," passengers"), tickPadding: 1, tickSize: 3, tickFormat: v=>(v*100).toFixed(1) + "%", nice:true, }, grid: true, marks: [ Plot.ruleY([0]), Plot.circle(data, { x: x, y: ycolumn, r: radius || (d=>Math.sqrt(d[ycolumn])), title: d=>d["Ship Name"]+"\n"+d["Cruise Line"]+"\nCrew "+d["Crew cases in last 7 days"]+" / " + d["numcrew"] + " " + (d["Cases among % Crew"]*100).toFixed(1) +"%"+ "\nPax "+d["Pax cases in last 7 days"]+" / " + d["numpax"] + " " + (d["Cases among % Pax"]*100).toFixed(1) +"%" , stroke: d=>shortCompany(d.Company), fill: d=>shortCompany(d.Company), //interval: 1000*24*60*60, }), Plot.text(data, { x, y: ycolumn, dx: 7, dy: -7, fill: d=>shortCompany(d.Company), fontSize: radius && radius*10 || (d=>75*Math.sqrt(d[ycolumn])), text: d=>d["Ship Name"], textAnchor: "start", }), ] }) }40:[] 39:{"id":"46e68c0d885ec333","slug":"andys-cdc-cruise-ship-covid-outbreak-tracker","title":"Andy's CDC Cruise Ship COVID outbreak tracker","thumbnail":"6deedc303a8a186854fde3efaed342f28ee2c2893005d21f24f2f30b38eda162","access_level":"public","create_time":"$D2022-06-21T03:25:34.045Z","update_time":"$D2023-03-25T20:31:39.017Z","view_time":null,"first_public_time":"$D2022-07-19T19:17:40.585Z","has_unpublished_edits":null,"fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"1f31ae6127750b50","login":"andy-bloch","name":"Andy Bloch","avatar_url":"https://avatars-next.observableusercontent.com/f8d4001bdab27a3cfa956d8e8ce42e845944efa3f199456264dad93d7d00a47a","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1325,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"32eb0f53cf971b80","login":"andy-bloch","name":"Andy Bloch","avatar_url":"https://avatars-next.observableusercontent.com/f8d4001bdab27a3cfa956d8e8ce42e845944efa3f199456264dad93d7d00a47a","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"32eb0f53cf971b80","login":"andy-bloch","name":"Andy Bloch","avatar_url":"https://avatars-next.observableusercontent.com/f8d4001bdab27a3cfa956d8e8ce42e845944efa3f199456264dad93d7d00a47a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Andy's CDC Cruise Ship COVID outbreak tracker","cells":[{"id":0,"value":"# Andy's CDC Cruise Ship COVID outbreak tracker","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1270,"value":"## The CDC has apparently removed the dashboard completely. The last update was August 1, 2022.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1235,"value":"The CDC halted its “COVID-19 Program for Cruise Ships” July 18th, but cruise ships were still reporting cases to the CDC. Until August 2, the CDC continued updating its dashboard nightly. This page used data extracted from the dashboard nightly.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1268,"value":"Last report date: ${lastColorStatusDate}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1048,"value":"https://observablehq.com/@andy-bloch/andys-cdc-cruise-ship-covid-outbreak-tracker","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":642,"value":"### Fraction of passengers and crew testing positive by day, last 28 days","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":256,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1107,"value":"viewof showAllShips = Inputs.toggle({label:\"Expand to show all tracked ships\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1177,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":585,"value":"### Percentage of passengers on each ship testing positive in last week\nColor indicates cruise company","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":395,"value":"plotColorStatusData(allColorStatus, \"Cases among % Pax\", \"numpax\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1179,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":588,"value":"### Percentage of crew on each ship testing positive in last week\nColor indicates company","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":377,"value":"plotColorStatusData(allColorStatus,\"Cases among % Crew\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":743,"value":"----\n### Cases among passengers versus cases among crew, last 7 days","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":740,"value":"plotColorStatusData(allColorStatus,\"Cases among % Pax\", d=>d[\"Cases among % Crew\"],\"Cases among crew\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":763,"value":"### Ships with lowest % of cases among passengers and crew, last 7 days","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":747,"value":"plotColorStatusData(allColorStatus.filter(d=> d[\"num.reports\"] > 1 && d[\"Cases among % Pax\"] < 0.01 && d[\"Cases among % Crew\"] < 0.012),\"Cases among % Pax\", d=>d[\"Cases among % Crew\"],\"Cases among crew\",1.25)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":767,"value":"### Ships reporting 0 cases in last 7 days: \n${allColorStatus.filter(d=>d[\"num.reports\"] > 1 && d[\"Cases among % Pax\"] === 0 && d[\"Cases among % Crew\"] === 0).map(d=>d[\"Ship Name\"]).join(\"
\")}\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":614,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":619,"value":"### All ships, fraction positive by date (passengers and crew)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":31,"value":"plotCruiseData(allData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":985,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1158,"value":"### Charts and data for a selected ship","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":96,"value":"viewof selectVesselName = Inputs.select(vesselNames, {value: allData.find(d=>d.vesselTotals.sortedIndex === 0).VesselName, label: \"Select vessel name\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":912,"value":"shipWeeklySummary(allColorStatus,selectVesselName)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"#### ${selectVesselName} 7-day data (if reported):","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1200,"value":"viewof allColorStatusPreviousTable = Inputs.table(allColorStatusPreviousText)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"### Fraction of ${selectVesselName} passengers plus crew testing positive daily, since May 24","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":93,"value":"plotSingleCruiseData(selectedVesselData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":796,"value":"#### Daily COVID-19 testing reported to CDC for the ${selectVesselName}, since May 24","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":792,"value":"viewof selectedVesselTable = Inputs.table(d3.sort(allDataCombined.filter(d=>d[\"VesselName\"]===selectVesselName),d=>-d.reportDate).map(d=>{\n let dd = {\n \"ReportDate\": d.Date,\n \"Positives\": d[\"tot.pos\"],\n \"Symptomatic Positives\": d[\"tot.symp.pos\"],\n \"Aymptomatic Positives\": d[\"tot.asymp.pos\"],\n \"Tests\": d[\"tot.test\"],\n \"Symptomatic Tests\": d[\"tot.symp.test\"],\n \"Aymptomatic Tests\": d[\"tot.asymp.test\"],\n Passengers: d.numpax,\n Crew: d.numcrew,\n \"Pos per pax+crew\": d.Rate,\n \"Test Positivity\":d.Positivity,\n \"Symptomatic Positivity\":d.SympPositivity,\n \"Asymptomatic Positivity\":d.AsympPositivity,\n \"Tests per pax+crew\": d.TestsPerPerson,\n \n };\n //delete d.ParentCompany;\n //delete d[\"Cruise.Line\"];\n //delete d.VesselName;\n //delete d.reportDate;\n \n return dd;\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1050,"value":"viewof showPaxCounts = Inputs.button(\"Show/hide chart of daily Passenger counts\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"toggleDisplay(showPaxCounts % 2,plotSingleCruiseData(selectedVesselData,\"Rate\",\"numpax\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1060,"value":"viewof showCrewCounts = Inputs.button(\"Show/hide chart of daily crew counts\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"toggleDisplay(showCrewCounts % 2,plotSingleCruiseData(selectedVesselData,\"Rate\",\"numcrew\"))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1066,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":486,"value":"#### Data is from the CDC's Dashboard (still being updated):\nhttps://app.powerbigov.us/view?r=eyJrIjoiODg1MmRhYzItYTE1Yy00MzlmLTk4OTctNzZhODA2NWQ1NDM2IiwidCI6IjljZTcwODY5LTYwZGItNDRmZC1hYmU4LWQyNzY3MDc3ZmM4ZiJ9\n\nThis is the URL for the CDC's web page which contained the dashboard. (URL now forwards to a different page.) https://www.cdc.gov/quarantine/cruise/cruise-ship-color-status.html\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":654,"value":"### Number of passengers by color status ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"plotColors(allColorStatus)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1076,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":650,"value":"### Fraction positive by day, all ships in an individual cruise line","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":147,"value":"viewof selectCruiseLine = Inputs.select(cruiseLines, {label: \"Select cruise line\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"plotCruiseData(selectedData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":979,"value":"-----\n### Color status and tests for last 7 days for all cruises reporting to the CDC","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":228,"value":"viewof allColorStatusTable = Inputs.table(allColorStatus)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":983,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1168,"value":"### Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1170,"value":"toc({headers: \"h2, h3\", hideStartingFrom: \"Appendix\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1172,"value":"import {toc} from \"@nebrius/indented-toc\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"selectedVesselData = allDataCombined.filter(d=>d.VesselName === selectVesselName)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"selectedData = allData.filter(d=>d[\"Cruise.Line\"]===selectCruiseLine)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"allData = fetchData(\"\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1240,"value":"allData2 = fetchData(\"?date=\"+daysAgo(28))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1272,"value":"allData3 = fetchData(\"?date=\"+firstDataDate)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1244,"value":"allDataCombined = {\n function key(d) {\n return d.VesselName + d.reportDate ;\n }\n let a = [];\n let keys = {};\n allData.forEach(d=>{\n a.push(d);\n let k = key(d);\n keys[k] = d;\n });\n [...allData2,...allData3].forEach(d=>{\n let k = key(d);\n if (!keys[k]) {\n a.push(d);\n keys[k] = d ;\n }\n else {\n if (JSON.stringify({...keys[k],vesselIndex:null,vesselIndexCL:null,vesselTotals:null}) !== JSON.stringify({...d,vesselIndex:null,vesselIndexCL:null,vesselTotals:null})) {\n console.warn(\"Duplicate key, but row doesn't match.\",keys[k],d);\n }\n }\n });\n return a;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":622,"value":"yesterday = {\n let date = new Date(lastColorStatusReportDate);\n date.setDate(date.getDate()-1);\n return date.toISOString().slice(0,10);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":868,"value":"weekAgo = daysAgo(7)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1281,"value":"firstDataDate = \"2022-06-21\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1185,"value":"function daysAgo(n = 1) {\n let date = new Date(lastColorStatusReportDate);\n date.setDate(date.getDate()-n);\n return date.toISOString().slice(0,10);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1314,"value":"daysAgo(28)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":496,"value":"//oldData = fetchData(\"?date=\"+yesterday)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":501,"value":"function compareCruiseData(oldData,newData) {\n function key(d) {\n return d.VesselName + \",\" + d.reportDate;\n }\n function equal(d,d2) {\n function removeColumns(d) {\n let d2 = {...d};\n delete d2.vesselIndex ;\n delete d2.vesselIndexCL ;\n return d2;\n }\n function stringify(d) {\n return JSON.stringify(removeColumns(d));\n }\n return stringify(d) === stringify(d2);\n }\n const oldDict = {}\n oldData.forEach(d => oldDict[key(d)] = d);\n const newDict = {}\n newData.forEach(d => newDict[key(d)] = d);\n let diffs = [];\n newData.forEach(d => {\n let k = key(d) ;\n let d2 = oldDict[k];\n if (!equal(d,d2)) {\n diffs.push({key: k, old:d2,current:d});\n }\n });\n oldData.forEach(d => {\n let k = key(d) ;\n let d2 = newDict[k];\n if (!equal(d,d2)) {\n diffs.push({key: k, old:d,current:d2});\n }\n });\n return diffs;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"//plotCruiseData(oldData.filter(d=>!({\"CRYSTAL SYMPHONY\":1,\"INSIGNIA\":1,\"ISLAND PRINCESS\":1,\"JEWEL OF THE SEAS\":1,\"LEGEND OF THE SEAS\":1}[d.VesselName])))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":504,"value":"//compareCruiseData(oldData,allData).filter(d=>!d.old)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":475,"value":"viewof table1 = Inputs.table(allData.filter(d=>d[\"VesselName\"].startsWith(\"ZAAN\")))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"allColorStatus = getColorStatus()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1254,"value":"lastColorStatusReportDate = d3.max(allColorStatus,d=>d.reportDate)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1258,"value":"lastColorStatusDate = (new Date(lastColorStatusReportDate)).toISOString().slice(0,10)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"allColorStatusPrevious = {\n let a = [allColorStatus];\n let step = 1;\n for (let i = step ; i <= 35 ; i+=step) {\n a[i] = await getColorStatus(\"?date=\"+daysAgo(i));\n }\n return a;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1197,"value":"// Use only the most recent report for report date\nallColorStatusPreviousText = Array.from(d3.rollup(\n allColorStatusPrevious.filter(d=>d).map(d=>shipWeeklySummaryObject(d,selectVesselName)),\n group => group[0],\n d => d[\"Report Date\"]\n).values()).filter(d=>!isNaN(d[\"Passenger cases\"]) || !isNaN(d[\"Crew cases\"]))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1193,"value":"function shipWeeklySummaryObject(data, shipName) {\n let d = data.find(d=>d[\"Ship Name\"]===shipName);\n if (!d) {\n return {};\n }\n return {\n \"Report Date\": d.Date,\n \"CDC Color status\": d[\"Ship Status\"],\n \"Passenger rate\" : d.numpax ? `${(d[\"Cases among % Pax\"]*100).toFixed(1)}%` : \"n/a\",\n \"Passenger cases\" : d.numpax ? d[\"Pax cases in last 7 days\"] : \"n/a\",\n \"Passengers\" : d.numpax || \"n/a\",\n \"Crew rate\" : d.numcrew ? `${(d[\"Cases among % Crew\"]*100).toFixed(1)}%` : \"n/a\",\n \"Crew cases\" : d.numcrew ? d[\"Crew cases in last 7 days\"] : \"n/a\",\n \"Crew\" : d.numcrew || \"n/a\",\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":871,"value":"async function getColorStatus(params=\"\") {\n let data = await d3.csv(\"https://labvegas.com/data/covid19/cruises/dashboard-Color Status.csv\"+params, d3.autoType);\n data.sort((a,b)=> a.reportDate - b.reportDate);\n delete data.columns;\n console.log(data);\n let prev = null ;\n data.forEach(d=>{\n d.Date=new Date(d.reportDate);\n d[\"Total cases in last 7 days\"] = d[\"Crew cases in last 7 days\"] + d[\"Pax cases in last 7 days\"];\n d[\"Total pax and crew\"] = d[\"numpax\"] + d[\"numcrew\"];\n d[\"Total cases %\"] = d[\"Total cases in last 7 days\"] / d[\"Total pax and crew\"];\n delete d[\"Current Voyage Type\"];\n delete d[\"Current Voyage Type\"];\n delete d[\"include.on.website\"];\n\n \n });\n \n return data;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"function plotColors(data) {\n return Plot.plot({\n color: {\n legend: \"swatches\",\n columns: \"13em\",\n },\n //x: {type: \"label\"},\n grid: true,\n marks: [\n Plot.ruleY([0]),\n Plot.barY(data, {\n x: \"Color Status for Table\",\n y: d=>d.numpax,\n title: d=>d[\"Ship Name\"]+\"\\n\"+d[\"Cruise Line\"]+\"\\nCrew \"+d[\"Crew cases in last 7 days\"]+\" / \" + d[\"numcrew\"] + \"\\nPax \"+d[\"Pax cases in last 7 days\"]+\" / \" + d[\"numpax\"] ,\n stroke: \"Company\",\n fill: \"Company\",\n //interval: 1000*24*60*60,\n })\n ]\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"function plotCruiseData(data,colorColumn=\"VesselName\",ycolumn = \"Rate\") {\n return Plot.plot({\n color: {\n legend: \"swatches\",\n columns: \"13em\",\n },\n x: {type: \"utc\"},\n grid: true,\n marks: [\n Plot.ruleY([0]),\n Plot.rectY(data, {\n x: d=>d.reportDate + 1,\n y: ycolumn,\n title: d=>d.VesselName+\"\\n\"+d[\"Cruise.Line\"]+\"\\n\"+d[\"tot.pos\"]+\" pos out of \" + (d[\"numcrew\"]+d[\"numpax\"]) + \" total (\" + d[\"numpax\"] + \" pax + \" + d[\"numcrew\"] + \" crew)\" ,\n stroke: colorColumn,\n fill: colorColumn,\n interval: 1000*24*60*60,\n })\n ]\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1030,"value":"function plotSingleCruiseData(data,colorColumn=\"Rate\",ycolumn = \"Rate\") {\n return Plot.plot({\n color: {\n type: \"sqrt\",\n domain: [-.01,.03],\n range: d3.schemeSpectral[0], \n columns: \"13em\",\n },\n x: {type: \"utc\"},\n grid: true,\n marks: [\n Plot.ruleY([0]),\n Plot.rectY(data, {\n x: d=>d.reportDate + 1,\n y: ycolumn,\n title: d=>d.VesselName+\"\\n\"+d[\"Cruise.Line\"]+\"\\n\"+d[\"tot.pos\"]+\" pos out of \" + (d[\"numcrew\"]+d[\"numpax\"]) + \" total (\" + d[\"numpax\"] + \" pax + \" + d[\"numcrew\"] + \" crew)\" ,\n stroke: colorColumn,\n fill: colorColumn,\n interval: 1000*24*60*60,\n })\n ]\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"function getColorStatusTotals(data) {\n let crewCases = d3.sum(allColorStatus,d=>d[\"Crew cases in last 7 days\"]);\n let paxCases = d3.sum(allColorStatus,d=>d[\"Pax cases in last 7 days\"]);\n let numCrew = d3.sum(allColorStatus,d=>d[\"numcrew\"]);\n let numPax = d3.sum(allColorStatus,d=>d[\"numpax\"]);\n let totalCases = crewCases + paxCases;\n let totalPeople = numCrew + numPax;\n return {\n crewCases,\n paxCases,\n numCrew,\n numPax,\n crewRate : crewCases/numCrew,\n paxRate: paxCases/numPax,\n totalRate: totalCases/totalPeople,\n };\n}\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":416,"value":"getColorStatusTotals(allColorStatus)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"vesselNames = getUnique(d3.map(allData, d=>d.VesselName)).sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"cruiseLines = getUnique(d3.map(allData, d=>d[\"Cruise.Line\"])).sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"function getUnique(a) {\n let m = {};\n a.forEach(d=>m[d] = 1);\n return Object.keys(m);\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"function reduceBy(a,column,f) {\n // f is a function f(value, cumValue, key). Key is often unused\n let m = {};\n a.forEach(r=>{\n m[r[column]] = m[r[column]] || {_count: 0};\n m[r[column]]._count ++ ;\n Object.entries(r).forEach(kv => {\n \n m[r[column]][kv[0]] = f(kv[1],m[r[column]][kv[0]],kv[0]); \n });\n });\n return m;\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"function sumBy(a,column, exclude={}) {\n return reduceBy(a,column, (v,sum,key) => {\n if (exclude[key]) {\n return null;\n }\n if (typeof v === 'number') {\n return (sum || 0) + v; \n }\n if (v === sum) {\n return sum;\n }\n if (v === null) {\n return sum;\n }\n if (!sum) {\n return v;\n }\n return \"\" + sum + \", \" + v;\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"byVessel = sumDailyData(allData);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":902,"value":"function sumDailyData(data) {\n let byVessel = sumBy(data,\"VesselName\", {\"Date\":1});\n Object.values(byVessel).forEach(d=> {\n d.RatePerDay = d[\"tot.pos\"] / (d.numcrew + d.numpax); \n d.Positivity = d[\"tot.pos\"] / d[\"tot.test\"];\n d.SympPositivity = d[\"tot.symp.pos\"] / d[\"tot.symp.test\"];\n d.AsympPositivity = d[\"tot.asymp.pos\"] / d[\"tot.asymp.test\"];\n d.SympToAsympPositivity = d[\"SympPositivity\"] / d[\"AsympPositivity\"];\n d.SympTestShare = d[\"tot.symp.test\"] / d[\"tot.test\"];\n d.SympPosShare = d[\"tot.symp.pos\"] / d[\"tot.pos\"];\n d.TestRatePerDay = d[\"tot.test\"] / (d.numcrew + d.numpax);\n });\n return byVessel;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":473,"value":"viewof table = Inputs.table(Object.values(byVessel))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":689,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":882,"value":"{\n let data = d3.sort(allData.filter(d=>d[\"VesselName\"]===selectVesselName),d=>-d.reportDate).filter(d => (new Date(\"2022-07-11\")) <= d.Date);\n return sumDailyData(data);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":830,"value":"function shipWeeklySummary(data, shipName) {\n let d = data.find(d=>d[\"Ship Name\"]===shipName);\n return md`#### ${d[\"Ship Name\"]} last 7 days.\nColor status: ${d[\"Ship Status\"]}
\n\nCrew cases : **${d.numcrew ? (d[\"Cases among % Crew\"]*100).toFixed(1) : \"N/A\"}%** (${d[\"Crew cases in last 7 days\"]} / ${d.numcrew})
\nPassenger cases : **${d.numpax ? (d[\"Cases among % Pax\"]*100).toFixed(1) : \"N/A\"}%** (${d[\"Pax cases in last 7 days\"]} / ${d.numpax})\n`;\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":879,"value":"//Object.entries(allColorStatusPreviousWeek.find(d=>d[\"Ship Name\"]===selectVesselName)).map(kv=>kv[0]+\"|\"+kv[1]).join(\"\\n\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1056,"value":"function toggleDisplay(show,content) {\n return html`${content}`\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"//plotCruiseData(allData,\"Cruise.Line\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W40","stdlib":"1"}} 34:null