31:T1711,charttemp= { if(region=="Countrywide"){ const svg = d3.create("svg") .attr("viewBox", [0, 0, 975, 640]); if(selectedGeoDivision=="Counties"){ //svg.append("g") //.attr("transform", `translate(${width},${mapHeight})`) //.append(() => Swatches(color)); svg.append("g") .selectAll("path") .data(topojson.feature(regionTopo, regionTopo.objects[(selectedGeoDivision=="States"? "states":"counties")]).features) .join("path") .attr("fill", d=>color((selectedGeoDivision=="States")? valToStringForScale(colmap.get(d.properties.name)): valToStringForScale(colmap.get(d.id)))) //d=>color(valToStringForScale(colmap.get(d.id))) .attr("stroke","black") .attr("stroke-width",0.1) .attr("d", path) .attr("class","county") // .append("title") // .text(d => `${d.properties.name}, ${fipsmap.get(d.id)}`); svg.append("path") .datum(topojson.mesh(regionTopo, regionTopo.objects["states"], (a, b) => a !== b)) .attr("fill", "none") .attr("stroke", "black") .attr("stroke-width",2) .attr("stroke-linejoin", "round") .attr("d", path) ; svg.append("path") .data(topojson.feature(regionTopo, regionTopo.objects["nation"]).features) .attr("fill", "none") .attr("stroke", "black") .attr("stroke-width",2) .attr("stroke-linejoin", "round") .attr("d", path) const tooltip = svg.append("g"); svg.selectAll(".county") .on("touchmove mousemove", function(event,d){ tooltip.call( callout, `${percent? colmap.get(d.id)*100+'%':colmap.get(d.id)} ${nameMap.get(d.id)}` ); tooltip.attr("transform", `translate(${d3.pointer(event, this)})`); d3.select(this) .attr("stroke", "white") .attr("stroke-width",3) .raise(); }) .on("touchend mouseleave", function() { tooltip.call(callout, null); d3.select(this) .attr("stroke", null) .lower(); }); } if(selectedGeoDivision=="States"){ //svg.append("g") //.attr("transform", `translate(${width},${mapHeight})`) //.append(() => Swatches(color)); svg.append("g") .selectAll("path") .data(topojson.feature(regionTopo, regionTopo.objects[(selectedGeoDivision=="States"? "states":"counties")]).features) .join("path") .attr("fill", d=>color((selectedGeoDivision=="States")? valToStringForScale(colmap.get(d.properties.name)): valToStringForScale(colmap.get(d.id)))) //d=>color(valToStringForScale(colmap.get(d.id))) .attr("stroke","black") .attr("stroke-width",2) .attr("d", path) .attr("class","state") // .append("title") // .text(d => `${d.properties.name}, ${fipsmap.get(d.id)}`); /*svg.append("path") .datum(topojson.mesh(regionTopo, regionTopo.objects["states"], (a, b) => a !== b)) .attr("fill", "none") .attr("stroke", "black") .attr("stroke-width",2) .attr("stroke-linejoin", "round") .attr("d", path) ;*/ const tooltip = svg.append("g"); svg.selectAll(".state") .on("touchmove mousemove", function(event,d){ tooltip.call( callout, `${percent? colmap.get(d.properties.name)*100+'%':colmap.get(d.properties.name)} ${d.properties.name}` ); tooltip.attr("transform", `translate(${d3.pointer(event, this)})`); d3.select(this) .attr("stroke", "white") .raise(); }) .on("touchend mouseleave", function() { tooltip.call(callout, null); d3.select(this) .attr("stroke", "black") .lower(); }); } return svg.node() } else { if(selectedGeoDivision=="Counties") { projection.fitSize([width, mapHeight/1.5], localities) const svg = d3.create("svg") .attr("viewBox", [0, 0, width, (mapHeight/1.5)+50]); svg.append("rect") .attr("width", "100%") .attr("height", "100%") .attr("fill", "white"); svg.append("g") .selectAll("path") .data(topojson.feature(regionTopo, regionTopo.objects[Object.keys(regionTopo.objects)[0]]).features) .join("path") .attr("fill", d=>color(valToStringForScale(colmap.get(d.properties.GEOID)))) //.attr("fill", "#ddd") .attr("stroke","black") .attr("d", path) .attr("class","county"); const tooltip = svg.append("g"); svg.selectAll(".county") .on("touchmove mousemove", function(event,d){ tooltip.call( callout, `${percent? colmap.get(d.properties.GEOID)*100+'%':colmap.get(d.properties.GEOID)} ${nameMap.get(d.properties.GEOID)}` ); tooltip.attr("transform", `translate(${d3.pointer(event, this)})`); d3.select(this) .attr("stroke", "white") .raise(); }) .on("touchend mouseleave", function() { tooltip.call(callout, null); d3.select(this) .attr("stroke", "black") .lower(); }); /*.append("title") .text(d => `${d.properties.NAME} (${colmap.get(d.properties.GEOID)})`)*/; return svg.node(); } else { projection.fitSize([width, mapHeight/1.5], localities) const svg = d3.create("svg") .attr("viewBox", [0, 0, width, mapHeight/1.5]); svg.append("rect") .attr("width", "100%") .attr("height", "100%") .attr("fill", "white"); svg.append("path") .datum(topojson.merge(regionTopo, regionTopo.objects[Object.keys(regionTopo.objects)[0]].geometries)) .attr("fill", color(valToStringForScale(colmap.get(region)))) .attr("stroke", "black") .attr("stroke-width", 2) .attr("d", path) /*.append("title") .text(d => `${d.properties.NAME} (${colmap.get(d.properties.GEOID)})`)*/; return svg.node(); } } }32:T6a2,data = (selectedGeoDivision=="States") ? aq.from(xlsx.utils.sheet_to_json(wb.Sheets["States"],{range:1})).rename({'NAAT positivity rate - last 7 days (may be an underestimate due to delayed reporting)':"NAAT Positivity rate - Last 7 Days","NAAT positivity rate - absolute change (may be an underestimate due to delayed reporting)":"NAAT positivity absolute change","Cases - % change": "Cases - % Change from previous week","Deaths - % change": "Deaths - % Change from previous week","People who are fully vaccinated as % of total population":"% of population fully vaccinated"}).derive({"% of population initiating vaccination in last 7 days":d=>((d["State Abbreviation"]=="ID")?d["People initiating vaccination as % of population - last 7 days - ages 18+"]: d["People initiating vaccination as % of population - last 7 days - ages 12+"])}).objects() : aq.from(xlsx.utils.sheet_to_json(wb.Sheets["Counties"],{range:1})) .rename({ "NAAT positivity rate - last 7 days (may be an underestimate due to delayed reporting)":"NAAT Positivity rate - Last 7 Days", "NAAT positivity rate - absolute change (may be an underestimate due to delayed reporting)":"NAAT positivity absolute change", "Cases - % change": "Cases - % Change from previous week", "Deaths - % change": "Deaths - % Change from previous week", "People who are fully vaccinated as % of total population":"% of population fully vaccinated"}) .derive( {"% of population initiating vaccination in last 7 days":d=>((d["State Abbreviation"]=="ID")?d["People initiating vaccination as % of population - last 7 days - ages 18+"]: d["People initiating vaccination as % of population - last 7 days - ages 12+"])}).objects()33:T7c6,stateTopos=JSON.parse('{"02": "AK-02-alaska-counties.json", "01": "AL-01-alabama-counties.json", "05": "AR-05-arkansas-counties.json", "04": "AZ-04-arizona-counties.json", "06": "CA-06-california-counties.json", "08": "CO-08-colorado-counties.json", "09": "CT-09-connecticut-counties.json", "10": "DE-10-delaware-counties.json", "12": "FL-12-florida-counties.json", "13": "GA-13-georgia-counties.json", "15": "HI-15-hawaii-counties.json", "19": "IA-19-iowa-counties.json", "16": "ID-16-idaho-counties.json", "17": "IL-17-illinois-counties.json", "18": "IN-18-indiana-counties.json", "20": "KS-20-kansas-counties.json", "21": "KY-21-kentucky-counties.json", "22": "LA-22-louisiana-parishes.json", "25": "MA-25-massachusetts-counties.json", "24": "MD-24-maryland-counties.json", "23": "ME-23-maine-counties.json", "26": "MI-26-michigan-counties.json", "27": "MN-27-minnesota-counties.json", "29": "MO-29-missouri-counties.json", "28": "MS-28-mississippi-counties.json", "30": "MT-30-montana-counties.json", "37": "NC-37-north-carolina-counties.json", "38": "ND-38-north-dakota-counties.json", "31": "NE-31-nebraska-counties.json", "33": "NH-33-new-hampshire-counties.json", "34": "NJ-34-new-jersey-counties.json", "35": "NM-35-new-mexico-counties.json", "32": "NV-32-nevada-counties.json", "36": "NY-36-new-york-counties.json", "39": "OH-39-ohio-counties.json", "40": "OK-40-oklahoma-counties.json", "41": "OR-41-oregon-counties.json", "42": "PA-42-pennsylvania-counties.json", "72": "PR-72-puerto-rico-municipios.json", "44": "RI-44-rhode-island-counties.json", "45": "SC-45-south-carolina-counties.json", "46": "SD-46-south-dakota-counties.json", "47": "TN-47-tennessee-counties.json", "48": "TX-48-texas-counties.json", "49": "UT-49-utah-counties.json", "51": "VA-51-virginia-counties.json", "50": "VT-50-vermont-counties.json", "53": "WA-53-washington-counties.json", "55": "WI-55-wisconsin-counties.json", "54": "WV-54-west-virginia-counties.json", "56": "WY-56-wyoming-counties.json"}')34:Tada,function valToStringForScale(val){ if(metric=="Cases per 100k - last 7 days"){ if(750<=val) return "750 or more" else if(749>=val&& val>=500) return "500-749" else if(499>=val&& val>=200) return "200-499" else if(199>=val&& val>=100) return "100-199" else if(99>=val&& val>=50) return "200-499" else if(49>=val&& val>=10) return "10-49" else if(9>=val&& val>=5) return "5-9" else if(val<=4) return "Less than 4" } else if(metric=="Cases - last 7 days"){ if(10000<=val) return "10,000+" else if(9999>=val&& val>=5000) return "5,000-9,999" else if(4999>=val&& val>=1000) return "1,000-4,999" else if(999>=val&& val>=100) return "100-999" else if(99>=val&& val>=10) return "10-99" else if(9>=val&& val>=1) return "1-9" else if(val==0) return "0" } else if(metric=="Deaths - last 7 days") { if(val>=100) return "100 or more" else if (val>=25 && val<=99) return "25-99" else if (val>=4 && val<=24) return "5-24" else if (val>=1 && val<=4) return "1-4" else if(val==0) return "0" } else if(metric =="% of population fully vaccinated") { if(val>=.7) return "70% or More" else if (val>=.6 && val<=.699) return "60% - 69.9%" else if (val>=.5 && val<=.599) return "50% - 59.9%" else if (val>=.4 && val<=.499) return "40% - 49.9%" else if (val>=.3 && val<=.399) return "30% - 39.9%" else if (val>=.2 && val<=.299) return "20% - 29.9%" else if (val>=0 && val<=.199) return "0% - 19.9%" } else if(metric =="% of population initiating vaccination in last 7 days") { if(val>=.02) return "2.0% or More" else if (val>=.017 && val<=.019) return "1.7% to 1.9%" else if (val>=.014 && val<=.016) return "1.4% to 1.6%" else if (val>=.01 && val<=.013) return "1.0% to 1.3%" else if (val>=.007 && val<=.009) return "0.7% to 0.9%" else if (val>=.004 && val<=.006) return "0.4% to 0.6%" else if (val>=0 && val<=.003) return "0.0% to 0.3%" } else if (metric=="Deaths per 100k - last 7 days"){ if(15.0<=val) return "15.0 or More" else if(14.9>=val&& val>=10.0) return "10.0 to 14.9" else if(9.9>=val&& val>=5.0) return "5.0 to 9.9" else if(4.9>=val&& val>=2.0) return "2.0 to 4.9" else if(1.9>=val&& val>=1.0) return "1.0 to 1.9" else if(0.9>=val&& val>=0.1) return "0.1 to 0.9" else if(val==0.0) return "0.0" } else if(metric=="Community Transmission Level - last 7 days") return val }35:T710,color= { if (metric=="Community Transmission Level - last 7 days") return d3.scaleOrdinal(["Low","Moderate","Substantial","High"],["#1D8AFF","#FFF70E","#FF7134","#FF0000"]).unknown("white") else if (metric == "Cases per 100k - last 7 days") return d3.scaleOrdinal(["Less than 4", "5-9", "10-49", "50-99", "100-199", "200-499","500-749","750 or more"],["#538135","#A9D18E","#F5EF8C","#F7C000","#FF6464","#DF0205","#A80000","#5C072E"]).unknown("white") else if (metric == "Cases - last 7 days") return d3.scaleOrdinal(["0", "1-9", "10-99", "100-999", "1,000-4,999", "5,000-9,999","10,000+",],["#E1E1E1","#FCE062","#F7C348","#F2A72E","#C46D1B","#963A0C","#6B0601"]).unknown("white") else if (metric == "Deaths - last 7 days") return d3.scaleOrdinal(["0", "1-4", "5-24", "25-99", "100 or more"], ["#E1E1E1","#FAD155","#F2A72E","#AD5313","#6B0000"]).unknown("white") else if (metric == "Deaths per 100k - last 7 days"){ return d3.scaleOrdinal(["0.0", "0.1 to 0.9", "1.0 to 1.9", "2.0 to 4.9", "5.0 to 9.9", "5.0 to 9.9","10.0 to 14.9","15.0 or More"], ["#E1E1E1","#F5F57A","#F5CA7A","#F57A7A","#E60000","#A80000","#5C072C"]).unknown("white") } else if (metric == "% of population fully vaccinated"){ return d3.scaleOrdinal(["0% - 19.9%","20% - 29.9%", "30% - 39.9%", "40% - 49.9%", "50% - 59.9%", "60% - 69.9%","70% or More"], ["#CBEAFD","#90BCDF","#6B94B9","#3C70A4","#234D80","#0B3366","#011945"]).unknown("white") } else if (metric == "% of population initiating vaccination in last 7 days"){ return d3.scaleOrdinal(["0.0% to 0.3%","0.4% to 0.6%", "0.7% to 0.9%", "1.0% to 1.3%", "1.4% to 1.6%", "1.7% to 1.9%","2.0% or More"], ["#CBEAFD","#90BCDF","#6B94B9","#3C70A4","#234D80","#0B3366","#011945"]).unknown("white") } }36:[{"id":"783cf2bf259e16d662d92c9f59ec97e564c50841c5984f2bb6f65a6d31f8c1b80846bffb65cb654dc2b587ac96f0007ab68c24bacce33655fd785e46020aff74","href":"https://static.observableusercontent.com/files/783cf2bf259e16d662d92c9f59ec97e564c50841c5984f2bb6f65a6d31f8c1b80846bffb65cb654dc2b587ac96f0007ab68c24bacce33655fd785e46020aff74","name":"counties-10m.json","type":"application/json","lastModified":1633220226292.044,"size":842177}] 2f:{"title":"COVID19 Community Profile Maps","cells":[{"id":0,"value":"# COVID19 Community Profile Maps\n\nThese maps are based off data published in the [White House Community Profile Reports](https://healthdata.gov/Health/COVID-19-Community-Profile-Report/gqxm-d9w9). This tool allows the user to generate a countrywide map and filter down to the state/territory level. If the data presented in this notebook does not match the latest PDF at healthdata.gov, it's because the API I'm using to pull the latest excel version of the report has not updated. I've included several metrics from the report here, the others are quite difficult to extract from the report due to missing data or requiring other datasets. There are plenty of caveats when using this dataset. Please see the report and [spreadsheeet](${url}) for further understanding.","pinned":false,"hidden":false,"mode":"md"},{"id":84,"value":"### Community profile report was last published on ${date.toLocaleDateString()}","pinned":false,"hidden":false,"mode":"md"},{"id":107,"value":"viewof region = Inputs.select([\"Countrywide\"].concat([\"Alabama\",\"Alaska\",\"Arizona\",\"Arkansas\",\"California\",\"Colorado\",\"Connecticut\",\"Delaware\",\"Florida\",\"Georgia\",\"Hawaii\",\"Idaho\",\"Illinois\",\"Indiana\",\"Iowa\",\"Kansas\",\"Kentucky\",\"Louisiana\",\"Maine\",\"Maryland\",\"Massachusetts\",\"Michigan\",\"Minnesota\",\"Mississippi\",\"Missouri\",\"Montana\",\"Nebraska\",\"Nevada\",\"New Hampshire\",\"New Jersey\",\"New Mexico\",\"New York\",\"North Carolina\",\"North Dakota\",\"Ohio\",\"Oklahoma\",\"Oregon\",\"Pennsylvania\",\"Puerto Rico\",\"Rhode Island\",\"South Carolina\",\"South Dakota\",\"Tennessee\",\"Texas\",\"Utah\",\"Vermont\",\"Virginia\",\"Washington\",\"West Virginia\",\"Wisconsin\",\"Wyoming\"].sort()),{label: \"Region of interest\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":73,"value":"viewof selectedGeoDivision = Inputs.select([\"States\",\"Counties\"], {label: \"Break up into\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":314,"value":"(Use this to break up individual states into counties)","pinned":false,"hidden":false,"mode":"md"},{"id":341,"value":"viewof metric=Inputs.select([\"Community Transmission Level - last 7 days\",\"Cases - last 7 days\",\"Deaths - last 7 days\",\"Cases per 100k - last 7 days\",\"Deaths per 100k - last 7 days\",\"% of population fully vaccinated\",\"% of population initiating vaccination in last 7 days\"],{label:\"Coloring metric\",width:400})","pinned":false,"hidden":false,"mode":"ojs"},{"id":481,"value":"#### ${(metric.includes(\"vaccin\"))?metric + \" (Idaho does not report vaccinations for persons under 18)\":metric}","pinned":false,"hidden":false,"mode":"md"},{"id":224,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":395,"value":"Legend(color,{width:width/1.5,title:(metric.includes(\"vaccin\"))?metric + \" (Idaho does not report vaccinations for persons under 18)\":metric})","pinned":false,"hidden":false,"mode":"ojs"},{"id":461,"value":"Regions that are colored white are missing data","pinned":false,"hidden":false,"mode":"md"},{"id":34,"value":"### Data","pinned":false,"hidden":false,"mode":"md"},{"id":40,"value":"#### Community Profile Excel Data","pinned":false,"hidden":false,"mode":"md"},{"id":60,"value":"url=axios.get(\"https://hhs-community-profile-url.herokuapp.com/https://shutdown.network/data/link.txt\").then(resp => {return resp.data.replace(/\\n/g, '')})","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"bytes=axios(url, {responseType:'arraybuffer'}).then(function(res) {\n\t\treturn new Uint8Array(res.data)})","pinned":false,"hidden":false,"mode":"ojs"},{"id":67,"value":"wb=xlsx.read(bytes,{type:\"array\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":76,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":937,"value":"wb.Sheets","pinned":true,"hidden":false,"mode":"ojs"},{"id":79,"value":"date=new Date(Date.parse(wb.Sheets[\"User Notes\"][\"B4\"]['v']))","pinned":false,"hidden":false,"mode":"ojs"},{"id":101,"value":"### Map data and projection / path","pinned":false,"hidden":false,"mode":"md"},{"id":112,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":114,"value":"regionTopo={\n if(region!=\"Countrywide\")\n return d3.json(`https://raw.githubusercontent.com/deldersveld/topojson/master/countries/us-states/${stateTopos[uslookup.lookup(region).fips]}`)\n else\n return FileAttachment(\"counties-10m.json\").json()\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":162,"value":"localities=\n{ \n if(region!=\"Countrywide\")\n return topojson.feature(regionTopo, Object.keys(regionTopo.objects)[0])\n else\n return topojson.feature(regionTopo, regionTopo.objects[\"states\"])\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":196,"value":"projection = \n{\n if(region!=\"Alaska\"&®ion!=\"Countrywide\"){\n return d3.geoIdentity()\n\t .reflectY(true)\n }\n else if(region==\"Countrywide\"){\n return geoAlbersUsaPr().scale(1300).translate([487.5, 305])\n }\n else{\n return d3.geoTransverseMercator()\n .rotate([142, -54]);\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":205,"value":"path = d3.geoPath().projection(projection)","pinned":false,"hidden":false,"mode":"ojs"},{"id":214,"value":"heightRatio = {\n const bounds = path.bounds(localities);\n return (bounds[1][1] - bounds[0][1]) / (bounds[1][0] - bounds[0][0]);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":220,"value":"mapHeight = Math.floor(width/2 * heightRatio)","pinned":false,"hidden":false,"mode":"ojs"},{"id":334,"value":"### Coloring and Scales","pinned":false,"hidden":false,"mode":"md"},{"id":337,"value":"colmap={\n\nif(selectedGeoDivision==\"Counties\")\n return new Map(data.map(d=>[d[\"FIPS code\"].toString().lpad(\"0\",5),d[metric]]))\nelse \n return new Map(data.map(d=>[uslookup.lookup(d[\"State Abbreviation\"]).name,d[metric]]))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":623,"value":"nameMap={\nif(selectedGeoDivision==\"Counties\")\n return new Map(data.map(d=>[d[\"FIPS code\"].toString().lpad(\"0\",5),d[\"County\"]]))\nelse \n return new Map(data.map(d=>[uslookup.lookup(d[\"State Abbreviation\"]).name,d[metric]]))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":345,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":347,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":352,"value":"String.prototype.lpad = function(padString, length) {\n var str = this;\n while (str.length < length)\n str = padString + str;\n return str;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":684,"value":"### Tooltip callout and format","pinned":false,"hidden":false,"mode":"md"},{"id":591,"value":"callout = (g, value) => {\n if (!value) return g.style(\"display\", \"none\");\n\n g\n .style(\"display\", null)\n .style(\"pointer-events\", \"none\")\n .style(\"font\", \"10px sans-serif\");\n\n const path = g.selectAll(\"path\")\n .data([null])\n .join(\"path\")\n .attr(\"fill\", \"white\")\n .attr(\"stroke\", \"black\");\n\n const text = g.selectAll(\"text\")\n .data([null])\n .join(\"text\")\n .call(text => text\n .selectAll(\"tspan\")\n .data((value + \"\").split(/\\n/))\n .join(\"tspan\")\n .attr(\"x\", 0)\n .attr(\"y\", (d, i) => `${i * 1.1}em`)\n .style(\"font-weight\", (_, i) => i ? null : \"bold\")\n .text(d => d));\n\n const {x, y, width: w, height: h} = text.node().getBBox();\n\n text.attr(\"transform\", `translate(${-w / 2},${15 - y})`);\n path.attr(\"d\", `M${-w / 2 - 10},5H-5l5,-5l5,5H${w / 2 + 10}v${h + 20}h-${w + 20}z`);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":635,"value":"percent={\nif(metric==\"Cases - % change\"||metric==\"Cases - % Change from previous week\"||metric==\"% of population fully vaccinated\"||metric==\"% of population initiating vaccination in last 7 days\")\n return true\nelse \n return false\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"### JS Libraries","pinned":false,"hidden":false,"mode":"md"},{"id":119,"value":"uslookup=require(\"us\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":14,"value":"d3=require(\"d3@7\",\"d3-geo-projection\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"import { aq, op } from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs"},{"id":18,"value":"moment=require(\"moment\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":20,"value":"xlsx=require(\"https://bundle.run/xlsx\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":26,"value":"axios=require(\"axios\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":24,"value":"import {Legend, Swatches} from \"@d3/color-legend\"\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":203,"value":"import {geoAlbersUsaPr} from \"@d3/u-s-map-with-puerto-rico\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W36","stdlib":"1","titling":"auto"}