2e:null 2f:["$","title",null,{"children":"Situación epidemiológica en Miranda de Ebro (Burgos) | Adrián Blanco | Observable"}] 34:Tb72,chart = { const svg = d3.create("svg") .attr("width", chartWidth + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); const style = svg.append("style"); style.html(styleHtml); const xScale = d3 .scaleTime() .domain([ new Date(2020, 2, 1), new Date() ]) .range([0 + margin.left, chartWidth - margin.right]) const yScale = d3 .scaleLinear() .domain([0, d3.max(positivos.map(d => d.pcr_positivos))]) .range([height - margin.top, 0 + margin.bottom]) const lineGenerator = d3.line() .curve(d3.curveCardinal) .x(d => xScale(d.fecha)) .y(d => yScale(d.dailyConfirmedRolling)); const head = svg .append('g') .selectAll('text') .data("Casos positivos por coronavirus") .enter() .append('text') .attr('x', 30) .attr('y', 30) .style("font", "12px sans-serif") .html(d => "Casos positivos por coronavirus") const xAxis = g => g .attr("transform", `translate(0,${height - margin.bottom})`) .call(d3.axisBottom(xScale).tickFormat(formatMonth)) const yAxis = g => g .call(d3.axisLeft(yScale).ticks(5).tickSize(-chartWidth + margin.left + margin.right)) .call(g => g.select(".domain").remove()) .call(g => g .selectAll(".tick line") .filter(d => d === 32) .clone() .attr("x2", chartWidth - margin.right - margin.left) ) .call( g => g .append("text") .attr("fill", "#000") .attr("x", 5) .attr("y", margin.top) .attr("dy", "0.32em") .attr("text-anchor", "start") .attr("font-weight", "bold") //.text("Reported cases per day") ) .style("font", "14px sans-serif") svg .append("g") .attr("class", "x axis") .attr("transform", `translate(0, ${height - margin.bottom})`) .call(xAxis) .selectAll("text") .style("text-anchor", "middle") .style("font", "10px sans-serif") svg .append("g") .attr("class", "axis y") .attr("transform", `translate(${margin.left},0)`) .call(yAxis) .selectAll("text") .style("font", "10px sans-serif"); const bars = svg .append('g') .attr('class', 'bars') .selectAll('rect') .data(positivos)//.sort((a, b) => d3.ascending(a.fecha, b.fecha))) .enter() .append('rect') .attr('id', d => d.fecha + " " + d.pcr_positivos) .attr('class', 'bar') .attr('x', d => xScale(d.fecha)) .attr('y', d => yScale(d.pcr_positivos)) .attr('width', 2) .attr('height', d => yScale(0) - yScale(d.pcr_positivos)) .style("fill", "#f9844a") svg.append("path") .attr("class", "rolling-avg") .datum(positivos) .attr("stroke", "#AD5123") .attr("stroke-width", 3) .attr("fill", "none") .attr("d", lineGenerator); return svg.node(); }35:Tc41,chartHospitales = { const svg = d3.create("svg") .attr("width", chartWidth + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); const style = svg.append("style"); style.html(styleHtml); const head = svg .append('g') .selectAll('text') .data("Casos positivos por coronavirus") .enter() .append('text') .attr('x', 30) .attr('y', 30) .style("font", "12px sans-serif") .html(d => "Hospitzaliados por coronavirus") const xScale = d3 .scaleTime() .domain([ new Date(2020, 2, 1), new Date() ]) .range([0 + margin.left, chartWidth - margin.right]) const yScale = d3 .scaleLinear() .domain([0, d3.max(hospitales.map(d => d.hospitalizados_planta))]) .range([height - margin.top, 0 + margin.bottom]) const xAxis = g => g .attr("transform", `translate(0,${height - margin.bottom})`) .call(d3.axisBottom(xScale).tickFormat(formatMonth)) const yAxis = g => g .call(d3.axisLeft(yScale).ticks(5).tickSize(-chartWidth + margin.left + margin.right)) .call(g => g.select(".domain").remove()) .call(g => g .selectAll(".tick line") .filter(d => d === 32) .clone() .attr("x2", chartWidth - margin.right - margin.left) ) .call( g => g .append("text") .attr("fill", "#000") .attr("x", 5) .attr("y", margin.top) .attr("dy", "0.32em") .attr("text-anchor", "start") .attr("font-weight", "bold") //.text("Reported cases per day") ) .style("font", "14px sans-serif") // .call(g => d3.axisLeft(yScale).tickSize(-width + margin.left + margin.right).tickFormat('').ticks(4)) svg .append("g") .attr("class", "x axis") .attr("transform", `translate(0, ${height - margin.bottom})`) .call(xAxis) .selectAll("text") .style("text-anchor", "middle") //.style("font-size", "10pt") // rotate the axis labels // .style("text-anchor", "end") .style("font", "10px sans-serif") // .attr("dx", "-.8em") // .attr("dy", ".15em") // .attr("transform", "rotate(-45)"); svg .append("g") .attr("class", "axis y") .attr("transform", `translate(${margin.left},0)`) .call(yAxis) .selectAll("text") .style("font", "10px sans-serif"); const bars = svg .append('g') .attr('class', 'bars') .selectAll('rect') .data(hospitales.sort((a, b) => d3.ascending(a.fecha, b.fecha))) .enter() .append('rect') .attr('id', d => d.fecha + " " + d.pcr_positivos) .attr('class', 'bar') .attr('x', d => xScale(d.fecha)) //.attr("x", (d, i) => x(i)) .attr('y', d => yScale(d.hospitalizados_planta)) .attr('width', 2) //.attr("width", x.bandwidth()) //.attr("width", x_band.bandwidth()) .attr('height', d => yScale(0) - yScale(d.hospitalizados_planta)) //.style('fill', '#bd3c0d') // .style("fill", d => colorScale(d.pcr_positivos))//"#FFDB16") .style("fill", "#11ADA2") return svg.node(); }36:Tc57,chart_mortalidad = { const svg = d3.create("svg") .attr("width", chartWidth + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); const style = svg.append("style"); style.html(styleHtml); const xScale = d3 .scaleTime() // .domain(["2020-01-01","2022-01-01"]) .domain([ new Date(2020, 2, 1), new Date() ]) .range([0 + margin.left, chartWidth - margin.right]) const yScale = d3 .scaleLinear() .domain([0, d3.max(mortalidad.map(d => d.fallecidos))]) .range([height - margin.top, 0 + margin.bottom * 2]) const lineGenerator = d3.line() .curve(d3.curveCardinal) .x(d => xScale(d.fecha)) .y(d => yScale(d.dailyConfirmedRolling)); const xAxis = g => g .attr("transform", `translate(0,${height - margin.bottom})`) //.call(d3.axisBottom(xScale)) .call(d3.axisBottom(xScale).tickFormat(formatMonth)) const head = svg .append('g') .selectAll('text') .data("Casos positivos por coronavirus") .enter() .append('text') .attr('x', 30) .attr('y', 30) .style("font", "12px sans-serif") .html(d => "Fallecidos por coronavirus") const yAxis = g => g //.attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(yScale).ticks(5).tickSize(-chartWidth + margin.left + margin.right)) .call(g => g.select(".domain").remove()) .call(g => g .selectAll(".tick line") .filter(d => d === 32) .clone() .attr("x2", chartWidth - margin.right - margin.left) .attr("stroke", "orange") ) .call( g => g .append("text") .attr("fill", "#000") .attr("x", 5) .attr("y", margin.top) .attr("dy", "0.32em") .attr("text-anchor", "start") .attr("font-weight", "bold") //.text("Reported cases per day") ) .style("font", "14px sans-serif") svg .append("g") .attr("class", "x axis") .attr("transform", `translate(0, ${height - margin.bottom})`) .call(xAxis) .selectAll("text") .style("text-anchor", "middle") .style("font", "10px sans-serif") svg .append("g") .attr("class", "axis y") .attr("transform", `translate(${margin.left},0)`) .call(yAxis) .selectAll("text") .style("font", "10px sans-serif"); const bars = svg .append('g') .attr('class', 'bars') .selectAll('rect') .data(mortalidad)//.sort((a, b) => d3.ascending(a.fecha, b.fecha))) .enter() .append('rect') .attr('id', d => d.fecha + " " + d.pcr_positivos) .attr('class', 'bar') .attr('x', d => xScale(d.fecha)) .attr('y', d => yScale(d.fallecidos)) .attr('width', 2) .attr('height', d => yScale(0) - yScale(d.fallecidos)) .style("fill", "#FD473F") .attr("fill-opacity", 0.8) svg.append("path") .attr("class", "rolling-avg") .datum(mortalidad) .attr("stroke", "#7D241F") .attr("fill", "none") .attr("stroke-width", 2.5) .attr("d", lineGenerator); return svg.node(); }37:T8e2,positivos = { const EnfermosMirandaOesteUrl = "https://analisis.datosabiertos.jcyl.es/api/records/1.0/search/?dataset=tasa-enfermos-acumulados-por-areas-de-salud&q=&rows=1000&refine.zbs_geo=MIRANDA+OESTE"; const EnfermosMirandaEsteUrl = "https://analisis.datosabiertos.jcyl.es/api/records/1.0/search/?dataset=tasa-enfermos-acumulados-por-areas-de-salud&q=&rows=1000&refine.zbs_geo=MIRANDA+ESTE"; const EnfermosMirandaEste = await d3.json(EnfermosMirandaEsteUrl); const EnfermosMirandaOEste = await d3.json(EnfermosMirandaOesteUrl); const data5 = EnfermosMirandaOEste.records.map((d) => { // var allN = test.map(d => d.n) // var max = Math.max(...allN) // var min = Math.min(...allN) // var variance = max - min return { fecha: parseDate(d.fields.fecha), //formatTime(d.fields.fecha), pcr_positivos: d.fields.pcr_positivos, dataset: d.datasetid, updated: d.record_timestamp }; }); const data4 = EnfermosMirandaEste.records.map((d) => { // var allN = test.map(d => d.n) // var max = Math.max(...allN) // var min = Math.min(...allN) // var variance = max - min return { fecha: parseDate(d.fields.fecha), //formatTime(d.fields.fecha), pcr_positivos: d.fields.pcr_positivos, dataset: d.datasetid, updated: d.record_timestamp }; }); const datahere = join( data5, data4, "fecha", "fecha", function (data33, data22) { return { //id: article.id, fecha: data33.fecha, fecha3: data33.fecha, fecha2: data22.fecha, pcr3: data33.pcr_positivos, pcr2: data22.pcr_positivos, pcr_positivos: data33.pcr_positivos + data22.pcr_positivos //brand: (brand !== undefined) ? brand.name : null }; } ); const sortedData = datahere.sort((a, b) => d3.ascending(a.fecha, b.fecha)); const dailyConfirmedRolling = meanRolling(sortedData, 7, (d) => Math.max(0, d.pcr_positivos) ); const processed = sortedData.map((d, i) => { d.dailyConfirmedRolling = dailyConfirmedRolling[i]; d.dailyConfirmedPer100kRolling = (dailyConfirmedRolling[i] / 40000) * 100000; return d; }); return processed.sort((a, b) => d3.ascending(a.fecha, b.fecha)); }38:T4bb,hospitales = { const url = "https://analisis.datosabiertos.jcyl.es/api/records/1.0/search/?dataset=situacion-de-hospitalizados-por-coronavirus-en-castilla-y-leon&q=&rows=1000&refine.hospital=Hospital+Santiago+Ap%C3%B3stol" let data = await d3.json(url); const processedData = data.records.map(d => { return { fecha: parseDate(d.fields.fecha), hospital: d.fields.hospital, nuevos_hospitalizados_planta: d.fields.nuevos_hospitalizados_planta, hospitalizados_planta: d.fields.hospitalizados_planta, hospitalizados_planta_incluidos_sospecha: d.fields.hospitalizados_planta_incluidos_sospecha, nuevos_hospitalizados_uci: d.fields.nuevos_hospitalizados_uci, hospitalizados_uci: d.fields.hospitalizados_uci, hospitalizados_uci_incluidos_sospecha: d.fields.hospitalizados_uci_incluidos_sospecha, nuevas_altas: d.fields.nuevas_altas, nuevos_fallecimientos:d.fields.nuevos_fallecimientos, fallecimientos: d.fields.fallecimientos, porcentaje_ocupacion_uci: d.fields.porcentaje_ocupacion_uci } }) return processedData.sort((a, b) => d3.descending(a.fecha, b.fecha)) } 39:T9fa,mortalidad = { const MortalidadMirandaOesteUrl = "https://analisis.datosabiertos.jcyl.es/api/records/1.0/search/?dataset=tasa-mortalidad-covid-por-zonas-basicas-de-salud&q=&rows=1000&refine.zbs_geo=MIRANDA+OESTE" const MortalidadMirandaEsteUrl = "https://analisis.datosabiertos.jcyl.es/api/records/1.0/search/?dataset=tasa-mortalidad-covid-por-zonas-basicas-de-salud&q=&rows=1000&refine.zbs_geo=MIRANDA+ESTE" const MortalidadMirandaEste = await d3.json(MortalidadMirandaEsteUrl); const MortalidadMirandaOeste = await d3.json(MortalidadMirandaOesteUrl); const ProcessedMirandaO = MortalidadMirandaOeste.records.map(d => { // var allN = test.map(d => d.n) // var max = Math.max(...allN) // var min = Math.min(...allN) // var variance = max - min return { fecha: parseDate(d.fields.fecha), //formatTime(d.fields.fecha), fallecidos: d.fields.fallecidos, fallecidosPor100: d.fields.tasax100, updated: d.record_timestamp } }) const ProcessedMirandaE = MortalidadMirandaEste.records.map(d => { // var allN = test.map(d => d.n) // var max = Math.max(...allN) // var min = Math.min(...allN) // var variance = max - min return { fecha: parseDate(d.fields.fecha), //formatTime(d.fields.fecha), fallecidos: d.fields.fallecidos, fallecidosPor100: d.fields.tasax100, updated: d.record_timestamp } }) const DataJoin = join(ProcessedMirandaE, ProcessedMirandaO, "fecha", "fecha", function(E, O) { return { //id: article.id, fecha: E.fecha, fechaE: E.fecha, fechaO: O.fecha, fallecidosE: E.fallecidos, fallecidosO: O.fallecidos, fallecidos: E.fallecidos + O.fallecidos, fallecidosPor100E: E.fallecidosPor100, fallecidosPor100O: O.fallecidosPor100, fallecidosPor100: E.fallecidosPor100 + O.fallecidosPor100, //brand: (brand !== undefined) ? brand.name : null }; }); const sortedData = DataJoin.sort((a, b) => d3.ascending(a.fecha, b.fecha)) const fallecidosRolling = meanRolling(sortedData, 7, d => Math.max(0, d.fallecidos)) const fallecidosPor100Rolling = meanRolling(sortedData, 7, d => Math.max(0, d.fallecidosPor100)) const processed = sortedData.map((d, i) => { d.dailyConfirmedRolling = fallecidosRolling[i]; d.dailyConfirmedPer100kRolling = fallecidosPor100Rolling[i];// / 40000 * 100000; return d; }); return processed.sort((a, b) => d3.ascending(a.fecha, b.fecha)) }3a:[] 32:{"id":"ad54ad3f018bda30","slug":"situacion-epidemiologica-en-miranda-de-ebro-burgos","title":"Situación epidemiológica en Miranda de Ebro (Burgos)","thumbnail":"5a8f8390ce87aec96f4c127456174cf0fbe9da4771eaaac17c781cf2d544620c","access_level":"public","create_time":"$D2021-01-31T20:31:52.157Z","update_time":"$D2022-01-05T17:55:59.555Z","view_time":null,"first_public_time":"$D2021-02-06T21:56:30.997Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"245ac42cd892b4cc","login":"adrianblanco","name":"Adrián Blanco","avatar_url":"https://avatars-next.observableusercontent.com/eea5773e3bbeefe76d056115d0b28764b5a0c038faf17da5669a075c69ffeaf2","tier":"starter_2024"},"version":226,"publish_version":226,"role":null,"authored":false,"authors":[{"type":"individual","id":"da362c08c97e9b17","login":"adrianblanco","name":"Adrián Blanco","avatar_url":"https://avatars-next.observableusercontent.com/eea5773e3bbeefe76d056115d0b28764b5a0c038faf17da5669a075c69ffeaf2","tier":null}],"members":[{"type":"individual","id":"da362c08c97e9b17","login":"adrianblanco","name":"Adrián Blanco","avatar_url":"https://avatars-next.observableusercontent.com/eea5773e3bbeefe76d056115d0b28764b5a0c038faf17da5669a075c69ffeaf2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Situación epidemiológica en Miranda de Ebro (Burgos)","cells":[{"id":0,"value":"md`# Situación epidemiológica en Miranda de Ebro (Burgos)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"md`\n**TODOS**:\n\nLa JCyL dejó de actualizar varias bases de datos a 28 de Diciembre de 2021. Averigur si están disponibles en otra API.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"md` El \n${formatDate(positivos.slice(-1)[0].fecha)}\nse registraron \n\n${positivos.slice(-1)[0].pcr_positivos} \npositivos \n\npor coronavirus en Miranda de Ebro.`\n\n// md` El\n// ${formatDate(positivos.filter(d => formatTime(d.fecha) == formatTime(new Date().setDate(new Date().getDate() - 1) ))[0].fecha)}\n// se registraron\n// \n// ${positivos.filter(d => formatTime(d.fecha) == formatTime(new Date().setDate(new Date().getDate() - 1) ))[0].pcr_positivos}\n// positivos\n// \n// por coronavirus en Miranda de Ebro.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"md` El \n${formatDate(hospitales.sort((a, b) => d3.descending(a.fecha, b.fecha))[0].fecha)}\nhay \n\n${hospitales.sort((a, b) => d3.descending(a.fecha, b.fecha))[0].hospitalizados_planta} \npersonas hospitalizadas\n\npor coronavirus en el hospital Santiago Apóstol de Miranda de Ebro.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":138,"value":"md` \n\n${\n mortalidad.slice(-1)[0].fallecidos == 0\n ? \"Ninguna persona\"\n : mortalidad.slice(-1)[0].fallecidos + \" persona\"\n} \n\nfalleció \npor coronavirus en Miranda de Ebro el \n${formatDate(mortalidad.slice(-1)[0].fecha)}.`\n\n// md`\n// \n// ${mortalidad.filter(d => formatTime(d.fecha) == formatTime(new Date().setDate(new Date().getDate() - 1) ))[0].fallecidos == 0 ? \"Ninguna persona\" : mortalidad.filter(d => formatTime(d.fecha) == formatTime(new Date().setDate(new Date().getDate() - 1) ))[0].fallecidos + \" persona\"}\n// \n// falleció\n// por coronavirus en Miranda de Ebro el\n// ${formatDate(mortalidad.filter(d => formatTime(d.fecha) == formatTime(new Date().setDate(new Date().getDate() - 1) ))[0].fecha)}.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"margin = ({ top: 20, right: 20, bottom: 20, left: 20 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"md` ### Styles`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":68,"value":"formatMonth = formatEs.utcFormat(\"%B\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"formatDate = formatEs.utcFormat(\"%d de %B de %Y\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"formatTime = d3.timeFormat(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"formatEs.utcFormat(\"%B\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"formatEs = d3.timeFormatLocale(locale)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"locale = await (await fetch(\"https://unpkg.com/d3-time-format@2/locale/es-ES.json\")).json()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"styleHtml = `\n.title {\n font-size: 24px;\n line-height: 28px;\n max-width: 600px;\n margin-bottom: 8px;\n}\n.dek {\n max-width: 600px;\n}\n\nsvg {\n overflow: visible;\n}\n\n.line {\n fill: none;\n stroke-width: 2px;\n}\n\n\n.label {\n font-size: 16px;\n text-anchor: middle;\n}\n\n\n.axis text {\n font-size: 14px;\n text-transform: capitalize;\n}\n.axis .domain {\n display: none;\n}\n.axis.x .tick line {\n stroke: #939598;\n stroke-width: .5px;\n}\n.axis.y .tick line {\n stroke: #b3b3b3;\n stroke-width: .5px;\n}\n.axis.y .tick:first-of-type line {\n stroke: #939598;\n}\n.axis.y .tick:first-of-type text {\n font-weight: bold;\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"chartWidth = Math.min(720, width)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"height = 400","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"function meanRolling(input, n, fn){\n const output = [];\n \n if (fn) input = arr.map(input, fn);\n \n for (let i = 1, l = input.length; i <= l; i++){\n output[i - 1] = arr.mean(input.slice(Math.max(0, i - n), i));\n }\n \n return output;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"function join(lookupTable, mainTable, lookupKey, mainKey, select) {\n var l = lookupTable.length,\n m = mainTable.length,\n lookupIndex = [],\n output = [];\n for (var i = 0; i < l; i++) { // loop through l items\n var row = lookupTable[i];\n lookupIndex[row[lookupKey]] = row; // create an index for lookup table\n }\n for (var j = 0; j < m; j++) { // loop through m items\n var y = mainTable[j];\n var x = lookupIndex[y[mainKey]]; // get corresponding row from lookupTable\n output.push(select(y, x)); // select only the columns you need\n }\n return output;\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"parseDate = d3.timeParse(\"%Y-%m-%d\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"arr = require(\"arraygeous@0\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3a","stdlib":"1","titling":"auto"}} 33:"$32:body"