40:null 41:["$","title",null,{"children":"Concejo vs Alcaldia | David Zamora | Observable"}] 47:T83f,makeTreemap = (rows, { height = 420, fallbackColor = "#9E9E9E" } = {}) => { const W = width; const H = height; const fmtInt = d3.format(",d"); const fmtPct = d3.format(".1%"); // 1) Agrega votos por entidad (candidato o partido) respetando el filtro // de includeBlanco ya aplicado aguas arriba en `al` / `co` const totales = new Map(); for (const r of rows) for (const [k, v] of Object.entries(r.votos)) totales.set(k, (totales.get(k) || 0) + v); const data = Array.from(totales, ([name, value]) => ({ name, value, color: colorsByWinner.get(canon(name)) ?? fallbackColor })).sort((a, b) => b.value - a.value); const total = d3.sum(data, (d) => d.value); // 2) Layout treemap binario (rectángulos balanceados) const root = d3 .hierarchy({ children: data }) .sum((d) => d.value) .sort((a, b) => b.value - a.value); d3.treemap().size([W, H]).tile(d3.treemapBinary).paddingInner(1).round(true)( root ); // 3) Render SVG const svg = d3 .create("svg") .attr("width", W) .attr("height", H) .attr("viewBox", [0, 0, W, H]) .attr("style", "max-width:100%; height:auto; shape-rendering:crispEdges;"); const leaf = svg.append("g").selectAll("g").data(root.leaves()).join("g"); leaf .append("rect") .attr("x", (d) => d.x0) .attr("y", (d) => d.y0) .attr("width", (d) => d.x1 - d.x0) .attr("height", (d) => d.y1 - d.y0) .attr("fill", (d) => d.data.color) .attr("stroke", "#111") .attr("stroke-width", 0.6) .attr("stroke-opacity", 0.9) .append("title") .text( (d) => `${d.data.name} Votos: ${fmtInt(d.data.value)} Participación: ${fmtPct(d.data.value / total)}` ); // Etiquetas: solo cuando el rectángulo tiene espacio mínimo leaf .filter((d) => d.x1 - d.x0 > 60 && d.y1 - d.y0 > 18) .append("text") .attr("x", (d) => d.x0 + 4) .attr("y", (d) => d.y0 + 14) .attr("font-size", 11) .attr("fill", "#111") .attr("pointer-events", "none") .text((d) => `${d.data.name} · ${fmtPct(d.data.value / total)}`); return svg.node(); }48:T968,chartPuestos = { const chart = Plot.plot({ width, height: 400, marginLeft: 70, marginRight: 10, marginBottom: 120, // Aumentamos el margen inferior para los textos rotados x: { type: "band", domain: d3.range(grid.length), padding: 0, round: false, tickRotate: -90, // Lógica para que se puedan leer los Puestos sin amontonarse tickFormat: (i) => { // Si hay muchísimos datos (ej. más de 100), mostramos 1 de cada 4 etiquetas. // Ajusta este "4" según qué tan denso se vea en tu pantalla. if (grid.length > 100 && i % 4 !== 0) return ""; const p = grid[i].puesto; // Truncamos si es muy largo return p.length > 20 ? p.substring(0, 18) + "…" : p; } }, y: { type: "band", domain: ["Alcaldía", "Concejo"], padding: 0.02, round: false, label: null }, color: { type: "categorical", domain: colorDomain, range: colorRange, legend: true, label: "Ganador" }, marks: [ Plot.cell(tiles, { x: "ix", y: "layer", fill: "winner", // fillOpacity: (d) => Math.max(1, d.pct) <- Nota: Math.max con 1 siempre da 1. fillOpacity: 1, stroke: strokeColorConst, strokeWidth: 1, strokeOpacity: 0.6, tip: true, // Activamos tooltip flotante title: (d) => `${d.puesto} (${d.comuna})\n${d.layer} — Ganador: ${ d.winner }\n% Ganador: ${(d.pct * 100).toFixed(1)}%\nVotos: ${ d.layer === "Alcaldía" ? d.alc_vot_ganador : d.con_vot_ganador }\nTotal Mesa: ${d.layer === "Alcaldía" ? d.alc_total : d.con_total}` }) ], style: { shapeRendering: "crispEdges", fontSize: 9 } }); // Event listeners para conectar con el Panel Inferior chart.addEventListener("pointermove", (e) => { const el = e.target.closest("rect"); if (!el) { mutable hovered_puesto = null; return; } const d = el.__data__?.data ?? el.__data__; if (d && typeof d === "object") { mutable hovered_puesto = d; } else if (typeof d === "number") { mutable hovered_puesto = tiles[d]; } else { mutable hovered_puesto = null; } }); chart.addEventListener("pointerleave", () => { mutable hovered_puesto = null; }); return chart; }49:Tb1e,panelTooltipPuestos = { if (!hovered_puesto) { return html`

Pasa el mouse por un puesto de votación para ver su detalle…

`; } const { id_puesto, puesto, comuna, layer } = hovered_puesto; // Extraemos los votos completos buscando por id_puesto en tus índices const dataRecord = layer === "Alcaldía" ? al_idx.get(id_puesto) : co_idx.get(id_puesto); if (!dataRecord || !dataRecord.votos) { return html`

Sin datos para el puesto ${puesto} (${layer}).

`; } const s = top2(dataRecord.votos); const fmtInt = d3.format(",d"); const fmtPct = d3.format(".1%"); const cWinner = colorsByWinner.get(s.winner) ?? "#999"; const cRunner = colorsByWinner.get(s.runner) ?? "#bbb"; return html`

${puesto} (${comuna}) — ${layer}

${ s.pWinner > 0.06 ? html`${ s.winner } ${(s.pWinner * 100).toFixed(1)}%` : "" }

${ s.pRunner > 0.06 ? html`${ s.runner } ${(s.pRunner * 100).toFixed(1)}%` : "" }

Ganador: ${s.winner} — ${fmtPct(s.pWinner)} (${fmtInt( s.wVotes )} votos) Segundo: ${s.runner} — ${fmtPct(s.pRunner)} (${fmtInt( s.rVotes )} votos) Otros: ${fmtPct(s.pOthers)} — Total: ${fmtInt(s.total)}

`; }4a:T5d1,chartPuestosMargen = Plot.plot({ width, height: 400, marginLeft: 70, marginRight: 10, marginBottom: 120, x: { type: "band", domain: d3.range(grid_byPuesto.length), padding: 0, round: false, tickRotate: -90, tickFormat: (i) => { if (grid_byPuesto.length > 100 && i % 4 !== 0) return ""; const p = grid_byPuesto[i].puesto; return p.length > 20 ? p.substring(0, 18) + "…" : p; } }, y: { type: "band", domain: ["Alcaldía", "Concejo"], padding: 0.02, round: false, label: null }, color: { type: "sequential", scheme: "viridis", label: "Margen ganador (pp)", domain: [0, 0.6], clamp: true, legend: true, tickFormat: ".0%" }, marks: [ // Capa 1: heatmap de margen (viridis) Plot.cell(tiles_margen, { x: "ix", y: "layer", fill: "margen", stroke: "#E7EFF8", strokeWidth: 0.5, tip: true, title: (d) => `${d.puesto} (${d.comuna}) ${d.layer} — Ganador: ${d.ganador} Margen: ${(d.margen * 100).toFixed(1)} pp % Ganador: ${(d.pct_ganador * 100).toFixed(1)}% Total mesa: ${d.total}` }), // Capa 2: overlay rojo donde gana VOTOS EN BLANCO Plot.cell( tiles_margen.filter((d) => d.ganador === "VOTOS EN BLANCO"), { x: "ix", y: "layer", fill: "none", stroke: "#FF0000", strokeWidth: 2.5 } ) ], style: { shapeRendering: "crispEdges", fontSize: 9 } })4b:Ta4a,panelTooltip = { if (!hovered) { return html`

Pasa el mouse por una comuna para ver detalle…

`; } const { comuna_key, comuna_label, layer } = hovered; const votesMap = layer === "Alcaldía" ? alVotesByComuna : coVotesByComuna; const votes = votesMap.get(comuna_key); if (!votes) { return html`

Sin datos para ${comuna_label} (${layer}). Revisa canonCom.

`; } const s = top2(votes); const fmtInt = d3.format(",d"); const fmtPct = d3.format(".1%"); const cWinner = colorsByWinner.get(s.winner) ?? "#999"; const cRunner = colorsByWinner.get(s.runner) ?? "#bbb"; return html`

${comuna_label} — ${layer}

${ s.pWinner > 0.06 ? html`${s.winner} ${( s.pWinner * 100 ).toFixed(1)}%` : "" }

${ s.pRunner > 0.06 ? html`${s.runner} ${( s.pRunner * 100 ).toFixed(1)}%` : "" }

`; }4c:T811,chartComunasMargen = { const chart = Plot.plot({ width, height: 400, marginLeft: 70, marginRight: 10, marginBottom: 150, x: { type: "band", domain: d3.range(grid_com_byLabel.length), tickFormat: (i) => grid_com_byLabel[i].comuna_label, padding: 0, round: false, tickRotate: -90, tickPadding: 3 }, y: { type: "band", domain: ["Alcaldía", "Concejo"], padding: 0.01, round: false, label: null }, color: { type: "sequential", scheme: "viridis", label: "Margen ganador (pp)", domain: [0, 0.6], clamp: true, legend: true, tickFormat: ".0%" }, marks: [ // Capa 1: heatmap de margen Plot.cell(tiles_com_margen, { x: "ix", y: "layer", fill: "margen", stroke: "#E7EFF8", strokeWidth: 2, strokeOpacity: 1, tip: true, title: (d) => `${d.comuna_label} — ${d.layer} Ganador: ${d.ganador} Margen: ${(d.margen * 100).toFixed(1)} pp % Ganador: ${(d.pct_ganador * 100).toFixed(1)}% Total votos: ${d.total}` }), // Capa 2: overlay rojo donde gana VOTOS EN BLANCO Plot.cell( tiles_com_margen.filter((d) => d.ganador === "VOTOS EN BLANCO"), { x: "ix", y: "layer", fill: "none", stroke: "#FF0000", strokeWidth: 3.5 } ) ], style: { shapeRendering: "crispEdges", fontSize: 10 } }); // Cableado al mutable `hovered` chart.addEventListener("pointermove", (e) => { const el = e.target.closest("rect"); if (!el) { mutable hovered = null; return; } const d = el.__data__?.data ?? el.__data__; if (d && typeof d === "object") { mutable hovered = d; } else if (typeof d === "number") { mutable hovered = tiles_com_margen[d]; } else { mutable hovered = null; } }); chart.addEventListener("pointerleave", () => { mutable hovered = null; }); return chart; }4d:T736,chartComunas = { const chart = Plot.plot({ width, height: 400, marginLeft: 70, marginRight: 10, marginBottom: 150, x: { type: "band", domain: d3.range(grid_com.length), tickFormat: (i) => grid_com[i].comuna_label, padding: 0, round: false, tickRotate: -90, tickPadding: 3 }, y: { type: "band", domain: ["Alcaldía", "Concejo"], padding: 0.01, round: false, label: null }, color: { type: "categorical", domain: colorDomain_com, range: colorRange_com, legend: true, label: "Ganador" }, marks: [ Plot.cell(tiles_com, { x: "ix", y: "layer", fill: "winner", stroke: "#E7EFF8", strokeWidth: 2, strokeOpacity: 1, tip: true, // Tooltip nativo activado title: (d) => `${d.comuna_label} — ${d.layer}\nGanador: ${d.winner}\n% Ganador: ${( d.pct * 100 ).toFixed(1)}%\nTotal Votos: ${ d.layer === "Alcaldía" ? d.alc_total : d.con_total }` }) ], style: { shapeRendering: "crispEdges", fontSize: 10 } }); // Eventos corregidos para el entorno web usando la palabra clave "mutable" chart.addEventListener("pointermove", (e) => { const el = e.target.closest("rect"); if (!el) { mutable hovered = null; return; } // Observable Plot a veces guarda el objeto o el índice, cubrimos ambas const d = el.__data__?.data ?? el.__data__; if (d && typeof d === "object") { mutable hovered = d; } else if (typeof d === "number") { mutable hovered = tiles_com[d]; } else { mutable hovered = null; } }); chart.addEventListener("pointerleave", () => { mutable hovered = null; }); return chart; }4e:T743,chartScatter = { const isPct = metrica === "Porcentaje (%)"; const xField = isPct ? "con_pct" : "con_votos"; const yField = isPct ? "alc_pct" : "alc_votos"; const fmt = isPct ? d3.format(".1%") : d3.format(",d"); const max_x = d3.max(scatterData, (d) => d[xField]) || 1; const max_y = d3.max(scatterData, (d) => d[yField]) || 1; return Plot.plot({ width, height: 500, margin: 50, grid: true, x: { label: isPct ? `% Votos: ${partidoConcejo} (Concejo) →` : `Votos: ${partidoConcejo} (Concejo) →`, tickFormat: isPct ? ".0%" : "s", domain: [0, max_x * 1.1] }, y: { label: isPct ? `↑ % Votos: ${candidatoAlcaldia} (Alcaldía)` : `↑ Votos: ${candidatoAlcaldia} (Alcaldía)`, tickFormat: isPct ? ".0%" : "s", domain: [0, max_y * 1.1] }, color: { legend: nivelAgrupacion === "Puesto", type: "categorical" }, marks: [ Plot.linearRegressionY(scatterData, { x: xField, y: yField, stroke: "#e74c3c", strokeDasharray: "4 4", strokeWidth: 2 }), Plot.dot(scatterData, { x: xField, y: yField, fill: nivelAgrupacion === "Puesto" ? "comuna" : "#2c3e50", r: nivelAgrupacion === "Puesto" ? 3 : 6, fillOpacity: 0.7, stroke: "white", strokeWidth: 0.5, tip: true, title: (d) => nivelAgrupacion === "Puesto" ? `Puesto: ${d.puesto}\nComuna: ${d.comuna}\nAlcaldía: ${fmt( d[yField] )}\nConcejo: ${fmt(d[xField])}` : `Comuna: ${d.comuna}\nPuestos agrupados: ${ d.puestos_count }\nAlcaldía: ${fmt(d[yField])}\nConcejo: ${fmt(d[xField])}` }) ], style: { fontFamily: "system-ui, sans-serif" } }); }4f:T50f,barTopPuestosAlc = Plot.plot({ width, height: 480, marginLeft: 220, marginRight: 60, marginTop: 30, x: { label: "Margen del ganador (pp) →", tickFormat: ".0%", grid: true, domain: [0, 1] }, y: { label: null, domain: topPuestosAlc.map((d) => `${d.puesto} (${d.comuna})`) }, marks: [ Plot.barX(topPuestosAlc, { y: (d) => `${d.puesto} (${d.comuna})`, x: "alc_dif_pct", fill: (d) => colorsByWinner.get(canon(d.alc_ganador)) ?? "#9E9E9E", stroke: (d) => (d.alc_ganador === "VOTOS EN BLANCO" ? "#FF0000" : "#111"), strokeWidth: (d) => (d.alc_ganador === "VOTOS EN BLANCO" ? 2 : 0.4), tip: true, title: (d) => `${d.puesto} (${d.comuna}) Ganador: ${d.alc_ganador} Margen: ${(d.alc_dif_pct * 100).toFixed(1)} pp % Ganador: ${(d.alc_pct_ganador * 100).toFixed(1)}% % Segundo: ${(d.alc_pct_runner * 100).toFixed(1)}% Total mesa: ${d3.format(",d")(d.alc_total)}` }), Plot.text(topPuestosAlc, { y: (d) => `${d.puesto} (${d.comuna})`, x: "alc_dif_pct", text: (d) => `${(d.alc_dif_pct * 100).toFixed(1)}%`, dx: 4, textAnchor: "start", fontSize: 10, fill: "#333" }), Plot.ruleX([0]) ], style: { fontFamily: "system-ui, sans-serif", fontSize: 10 } })50:T4dc,barTopPuestosCon = Plot.plot({ width, height: 480, marginLeft: 220, marginRight: 60, marginTop: 30, x: { label: "Margen del ganador (pp) →", tickFormat: ".0%", grid: true, domain: [0, 1] }, y: { label: null, domain: topPuestosCon.map((d) => `${d.puesto} (${d.comuna})`) }, marks: [ Plot.barX(topPuestosCon, { y: (d) => `${d.puesto} (${d.comuna})`, x: "con_dif_pct", fill: (d) => colorsByWinner.get(canon(d.con_ganador)) ?? "#9E9E9E", stroke: (d) => (d.con_ganador === "VOTOS EN BLANCO" ? "#FF0000" : "#111"), strokeWidth: (d) => (d.con_ganador === "VOTOS EN BLANCO" ? 2 : 0.4), tip: true, title: (d) => `${d.puesto} (${d.comuna}) Ganador: ${d.con_ganador} Margen: ${(d.con_dif_pct * 100).toFixed(1)} pp % Ganador: ${(d.con_pct_ganador * 100).toFixed(1)}% Total mesa: ${d3.format(",d")(d.con_total)}` }), Plot.text(topPuestosCon, { y: (d) => `${d.puesto} (${d.comuna})`, x: "con_dif_pct", text: (d) => `${(d.con_dif_pct * 100).toFixed(1)}%`, dx: 4, textAnchor: "start", fontSize: 10, fill: "#333" }), Plot.ruleX([0]) ], style: { fontFamily: "system-ui, sans-serif", fontSize: 10 } })51:T4d3,barTopComunasAlc = Plot.plot({ width, height: 480, marginLeft: 110, marginRight: 60, marginTop: 30, x: { label: "Margen del ganador (pp) →", tickFormat: ".0%", grid: true, domain: [0, 1] }, y: { label: null, domain: topComunasAlc.map((d) => d.comuna_label) }, marks: [ Plot.barX(topComunasAlc, { y: "comuna_label", x: "alc_dif_pct", fill: (d) => colorsByWinner.get(canon(d.alc_ganador)) ?? "#9E9E9E", stroke: (d) => (d.alc_ganador === "VOTOS EN BLANCO" ? "#FF0000" : "#111"), strokeWidth: (d) => (d.alc_ganador === "VOTOS EN BLANCO" ? 2 : 0.4), tip: true, title: (d) => `${d.comuna_label} Ganador: ${d.alc_ganador} Margen: ${(d.alc_dif_pct * 100).toFixed(1)} pp % Ganador: ${(d.alc_pct_ganador * 100).toFixed(1)}% % Segundo: ${(d.alc_pct_runner * 100).toFixed(1)}% Total votos: ${d3.format(",d")(d.alc_total)}` }), Plot.text(topComunasAlc, { y: "comuna_label", x: "alc_dif_pct", text: (d) => `${(d.alc_dif_pct * 100).toFixed(1)}%`, dx: 4, textAnchor: "start", fontSize: 10, fill: "#333" }), Plot.ruleX([0]) ], style: { fontFamily: "system-ui, sans-serif", fontSize: 11 } })52:T4a0,barTopComunasCon = Plot.plot({ width, height: 480, marginLeft: 110, marginRight: 60, marginTop: 30, x: { label: "Margen del ganador (pp) →", tickFormat: ".0%", grid: true, domain: [0, 1] }, y: { label: null, domain: topComunasCon.map((d) => d.comuna_label) }, marks: [ Plot.barX(topComunasCon, { y: "comuna_label", x: "con_dif_pct", fill: (d) => colorsByWinner.get(canon(d.con_ganador)) ?? "#9E9E9E", stroke: (d) => (d.con_ganador === "VOTOS EN BLANCO" ? "#FF0000" : "#111"), strokeWidth: (d) => (d.con_ganador === "VOTOS EN BLANCO" ? 2 : 0.4), tip: true, title: (d) => `${d.comuna_label} Ganador: ${d.con_ganador} Margen: ${(d.con_dif_pct * 100).toFixed(1)} pp % Ganador: ${(d.con_pct_ganador * 100).toFixed(1)}% Total votos: ${d3.format(",d")(d.con_total)}` }), Plot.text(topComunasCon, { y: "comuna_label", x: "con_dif_pct", text: (d) => `${(d.con_dif_pct * 100).toFixed(1)}%`, dx: 4, textAnchor: "start", fontSize: 10, fill: "#333" }), Plot.ruleX([0]) ], style: { fontFamily: "system-ui, sans-serif", fontSize: 11 } })53:T5e9,scatterData = { // 1. Extraer datos base a nivel de Puesto let rawData = []; for (const [id, al_data] of al_idx.entries()) { const co_data = co_idx.get(id); if (!co_data) continue; const alc_votes = al_data.votos[candidatoAlcaldia] || 0; const alc_total = al_data.alcaldia.total_validos || 1; // Prevenir div/0 const con_votes = co_data.votos[partidoConcejo] || 0; const con_total = co_data.concejo.total_validos || 1; rawData.push({ id_puesto: id, puesto: al_data.puesto, comuna: canonCom(al_data.comuna), alc_votos: alc_votes, alc_total: alc_total, con_votos: con_votes, con_total: con_total, alc_pct: alc_votes / alc_total, con_pct: con_votes / con_total }); } // 2. Agrupar si el usuario seleccionó "Comuna" if (nivelAgrupacion === "Comuna") { const grouped = d3.rollups( rawData, (v) => { const sum_alc_v = d3.sum(v, (d) => d.alc_votos); const sum_alc_t = d3.sum(v, (d) => d.alc_total); const sum_con_v = d3.sum(v, (d) => d.con_votos); const sum_con_t = d3.sum(v, (d) => d.con_total); return { comuna: v[0].comuna, puestos_count: v.length, alc_votos: sum_alc_v, con_votos: sum_con_v, alc_pct: sum_alc_t ? sum_alc_v / sum_alc_t : 0, con_pct: sum_con_t ? sum_con_v / sum_con_t : 0 }; }, (d) => d.comuna ); return grouped.map((d) => d[1]); } return rawData; }54:[{"id":"50dea1eab89b38459caad2e11a89a94aefb1f0749451a766a94348152ac1e6b5b00f0f2ab3469c00c65fb02cb1b17ca39609ab1c808c7906f70bbdde33d99e06","href":"https://static.observableusercontent.com/files/50dea1eab89b38459caad2e11a89a94aefb1f0749451a766a94348152ac1e6b5b00f0f2ab3469c00c65fb02cb1b17ca39609ab1c808c7906f70bbdde33d99e06","name":"alcaldia@2.csv","type":"text/csv","lastModified":1758678302965.244,"size":34188},{"id":"f8fb75499a6899fdd955441752ce3a405d689a508708cca2f1351d72a70771d0bd3bc67bb3f5aab241f56d6e16aebeabaab9db33fdc54a4ae770148258755c17","href":"https://static.observableusercontent.com/files/f8fb75499a6899fdd955441752ce3a405d689a508708cca2f1351d72a70771d0bd3bc67bb3f5aab241f56d6e16aebeabaab9db33fdc54a4ae770148258755c17","name":"concejo@1.csv","type":"text/csv","lastModified":1758678317563.711,"size":40907}] 45:{"id":"4587ab2e7b5394d0","slug":null,"title":"Concejo vs Alcaldia","thumbnail":"9e28351db0b8b1a5f6770437bc02aeb2618213426b6ec4970630a3dd498f95b2","access_level":"public","create_time":"$D2025-09-23T07:59:17.985Z","update_time":"$D2026-10-15T05:54:56.154Z","view_time":null,"first_public_time":"$D2025-09-23T07:59:17.985Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"872bea5f18aed5fe","login":"davzrx","name":"David Zamora","avatar_url":"https://avatars-next.observableusercontent.com/4c82c56df5ebe314bd43d89bb3e5fd175ff8d9d69a411a48ba64b3754cfa03a6","tier":"starter_2024","bio":"Sociólogo | Sociologist - Analista de Datos | Data Analyst - Datos en Español - Colombia","following":false},"version":569,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"4a902bd04f67962c","login":"davzrx","name":"David Zamora Ramírez","avatar_url":"https://avatars-next.observableusercontent.com/4c82c56df5ebe314bd43d89bb3e5fd175ff8d9d69a411a48ba64b3754cfa03a6","tier":null,"bio":"Data Analyst | GeoData | Cali | Colombia","following":false}],"members":[{"type":"individual","id":"4a902bd04f67962c","login":"davzrx","name":"David Zamora Ramírez","avatar_url":"https://avatars-next.observableusercontent.com/4c82c56df5ebe314bd43d89bb3e5fd175ff8d9d69a411a48ba64b3754cfa03a6","tier":null,"role":"editor"},{"type":"team","id":"872bea5f18aed5fe","login":"davzrx","name":"David Zamora","avatar_url":"https://avatars-next.observableusercontent.com/4c82c56df5ebe314bd43d89bb3e5fd175ff8d9d69a411a48ba64b3754cfa03a6","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Concejo vs Alcaldia","cells":[{"id":0,"value":"# Concejo vs Alcaldia","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":82,"value":"navio(tiles)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"viewof includeBlanco = Inputs.toggle({\n label: 'Contar \"VOTOS EN BLANCO\" como competidor',\n value: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":521,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"treemapAlcaldia = makeTreemap(al)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"treemapConcejo = makeTreemap(co)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":553,"value":"diagnosticoComunas = {\n const all = Array.from(new Set(al.map((d) => d.comuna))).sort();\n return {\n total: all.length,\n listado: all,\n matchComunaRegex: all.filter((s) => /COMUNA\\s*\\d/i.test(s)),\n matchCorregimiento: all.filter((s) => /CORREGIMIENTO/i.test(s)),\n otros: all.filter(\n (s) => !/COMUNA\\s*\\d/i.test(s) && !/CORREGIMIENTO/i.test(s)\n )\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":438,"value":"mutable hovered_puesto = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":442,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":490,"value":"ordenados_byPuesto = d3.sort(joined, (a, b) =>\n a.puesto.localeCompare(b.puesto, \"es\", { sensitivity: \"base\" })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"grid_byPuesto = ordenados_byPuesto.map((d, i) => ({ ...d, ix: i }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":500,"value":"tiles_margen = grid_byPuesto.flatMap((d) => [\n {\n ix: d.ix,\n layer: \"Alcaldía\",\n margen: d.alc_dif_pct,\n puesto: d.puesto,\n comuna: d.comuna,\n ganador: d.alc_ganador,\n pct_ganador: d.alc_pct_ganador,\n total: d.alc_total\n },\n {\n ix: d.ix,\n layer: \"Concejo\",\n margen: d.con_dif_pct,\n puesto: d.puesto,\n comuna: d.comuna,\n ganador: d.con_ganador,\n pct_ganador: d.con_pct_ganador,\n total: d.con_total\n }\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":487,"value":"md`### Heatmap de Margen de Victoria\n\nComplementa los heatmaps de ganador con la **intensidad de la disputa**.\n\n- 🟡 **Amarillo claro** → mesa/comuna *competida*: cambio de tendencia barato, alta volatilidad electoral.\n- 🔴 **Rojo intenso** → mesa/comuna *cautiva*: hegemonía consolidada, bajo retorno marginal de campaña.\n\nEl eje X mantiene el orden ascendente del margen en Alcaldía. La fila Concejo permite ver visualmente si la competencia es **simétrica** (ambas filas claras u oscuras juntas) o **asimétrica** (una mesa cautiva en Alcaldía pero disputada en Concejo → split-ticket voting).`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":481,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":508,"value":"ordenados_com_byLabel = d3.sort(comunaStats, (a, b) =>\n a.comuna_label.localeCompare(b.comuna_label, \"es\", { numeric: true, sensitivity: \"base\" })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"grid_com_byLabel = ordenados_com_byLabel.map((d, i) => ({ ...d, ix: i }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":512,"value":"tiles_com_margen = grid_com_byLabel.flatMap((d) => [\n {\n ix: d.ix,\n layer: \"Alcaldía\",\n margen: d.alc_dif_pct,\n comuna_key: d.comuna_key,\n comuna_label: d.comuna_label,\n ganador: d.alc_ganador,\n pct_ganador: d.alc_pct_ganador,\n total: d.alc_total\n },\n {\n ix: d.ix,\n layer: \"Concejo\",\n margen: d.con_dif_pct,\n comuna_key: d.comuna_key,\n comuna_label: d.comuna_label,\n ganador: d.con_ganador,\n pct_ganador: d.con_pct_ganador,\n total: d.con_total\n }\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":484,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"mutable hovered = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"viewof candidatoAlcaldia = Inputs.select(al_cands, {\n label: \"Candidato Alcaldía (Eje Y)\",\n value: \"ROBERTO ORTIZ URUEÑA\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":448,"value":"viewof partidoConcejo = Inputs.select(co_parties, {\n label: \"Partido Concejo (Eje X)\",\n value: \"PARTIDO ALIANZA VERDE\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":451,"value":"viewof nivelAgrupacion = Inputs.radio([\"Puesto\", \"Comuna\"], {\n label: \"Nivel de Análisis\",\n value: \"Comuna\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":465,"value":"viewof metrica = Inputs.radio([\"Porcentaje (%)\", \"Votos Totales\"], {\n label: \"Métrica a graficar\",\n value: \"Porcentaje (%)\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":457,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"topPuestosAlc = d3\n .sort(joined, (a, b) => b.alc_dif_pct - a.alc_dif_pct)\n .slice(0, 20)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":532,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":535,"value":"topPuestosCon = d3\n .sort(joined, (a, b) => b.con_dif_pct - a.con_dif_pct)\n .slice(0, 20)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":538,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"topComunasAlc = d3.sort(comunaStats, (a, b) => b.alc_dif_pct - a.alc_dif_pct)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"$51","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"topComunasCon = d3.sort(comunaStats, (a, b) => b.con_dif_pct - a.con_dif_pct)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":550,"value":"$52","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"$53","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":410,"value":"debugCanon = {\n const missing = grid_com.filter(\n (d) =>\n !(alVotesByComuna.has(d.comuna_key) && coVotesByComuna.has(d.comuna_key))\n );\n return {\n totalGrid: grid_com.length,\n alKeys: alVotesByComuna.size,\n coKeys: coVotesByComuna.size,\n missingCount: missing.length,\n sampleMissing: missing\n .slice(0, 5)\n .map((d) => ({ key: d.comuna_key, label: d.comuna_label }))\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"hits = chartComunas.querySelectorAll(\"g[aria-label='cell'] rect\") // más genérico\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":397,"value":"labelByKey = {\n const m = new Map();\n for (const r of al) {\n const k = canonCom(r.comuna);\n if (!m.has(k)) m.set(k, r.comuna);\n }\n for (const r of co) {\n const k = canonCom(r.comuna);\n if (!m.has(k)) m.set(k, r.comuna);\n }\n return m;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"strokeColorConst = \"#9E9E9E\" // o \"#fff\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"cols = grid.length // número de puestos/columnas","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"colorRange = winners.map((w) => colorsByWinner.get(canon(w)) ?? \"#9E9E9E\") // gris si faltara alguno","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"colorDomain = winners","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"colorsByWinner = new Map([\n [\"ALVARO ALEJANDRO EDER GARCES\", \"#FFD30E\"], // amarillo\n [\"ASI - MIRA - EN MARCHA - DIGNIDAD & COMPROMISO\", \"#8B5E3C\"], // café\n [\"PACTO HISTORICO\", \"#903097\"], // lila\n [\"PARTIDO ALIANZA VERDE\", \"#0C8842\"], // verde\n [\"PARTIDO CAMBIO RADICAL\", \"#5B2C6F\"], // morado oscuro\n [\"PARTIDO CENTRO DEMOCRÁTICO\", \"#74B9FF\"], // azul cielo\n [\"PARTIDO CONSERVADOR COLOMBIANO\", \"#0038A8\"], // azul rey oscuro\n [\"PARTIDO DE LA UNIÓN POR LA GENTE - PARTIDO DE LA U\", \"#FF7F0E\"], // naranja\n [\"PARTIDO LIBERAL COLOMBIANO\", \"#D9080A\"], // rojo oscuro\n [\"ROBERTO ORTIZ URUEÑA\", \"#E74C3C\"], // rojo menos oscuro\n [\"VOTOS EN BLANCO\", \"#fff\"] // Blanco\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"canon = (s) =>\n String(s ?? \"\")\n .normalize(\"NFKC\")\n .replace(/\\s+/g, \" \")\n .trim()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":362,"value":"top2 = (obj) => {\n const arr = Object.entries(obj ?? {}).sort((a, b) => b[1] - a[1]);\n const [w, wv] = arr[0] ?? [\"—\", 0];\n const [r, rv] = arr[1] ?? [\"—\", 0];\n const total = arr.reduce((s, [, v]) => s + v, 0);\n const pw = total ? wv / total : 0;\n const pr = total ? rv / total : 0;\n const po = Math.max(0, 1 - (pw + pr));\n return {\n winner: w,\n wVotes: wv,\n pWinner: pw,\n runner: r,\n rVotes: rv,\n pRunner: pr,\n pOthers: po,\n total\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"winners = Array.from(new Set(tiles.map((d) => d.winner))).sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"tiles = grid.flatMap((d) => [\n {\n ix: d.ix,\n layer: \"Alcaldía\",\n winner: d.alc_ganador,\n pct: d.alc_pct_ganador,\n id_puesto: d.id_puesto,\n puesto: d.puesto,\n comuna: d.comuna,\n alc_total: d.alc_total,\n con_total: d.con_total,\n alc_vot_ganador: d.alc_vot_ganador\n },\n {\n ix: d.ix,\n layer: \"Concejo\",\n winner: d.con_ganador,\n pct: d.con_pct_ganador,\n id_puesto: d.id_puesto,\n puesto: d.puesto,\n comuna: d.comuna,\n alc_total: d.alc_total,\n con_total: d.con_total,\n con_vot_ganador: d.con_vot_ganador\n }\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"grid = joined.map((d, i) => ({ ...d, ix: i })) // index de columna","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"ordenados = d3.sort(joined, (d) => d.alc_dif_pct) // izq: perdió ganador A, der: ganó","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"joined = Array.from(al_idx.keys())\n .filter((id) => co_idx.has(id))\n .map((id) => {\n const A = al_idx.get(id),\n C = co_idx.get(id);\n return {\n id_puesto: id,\n puesto: A.puesto ?? C.puesto,\n comuna: A.comuna ?? C.comuna,\n // Alcaldía\n alc_ganador: A.alcaldia.ganador,\n alc_pct_ganador: A.alcaldia.pct_ganador,\n alc_pct_runner: A.alcaldia.pct_runner,\n alc_dif_pct: A.alcaldia.dif_pct,\n alc_total: A.alcaldia.total_validos,\n alc_vot_ganador: A.alcaldia.max,\n // Concejo (ganador)\n con_ganador: C.concejo.ganador,\n con_pct_ganador: C.concejo.pct_ganador,\n con_dif_pct: C.concejo.dif_pct,\n con_total: C.concejo.total_validos,\n con_vot_ganador: C.concejo.max\n };\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"co_idx = new Map(\n co.map((d) => [d.id_puesto, { ...d, concejo: statsFromVotes(d.votos) }])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"al_idx = new Map(\n al.map((d) => [d.id_puesto, { ...d, alcaldia: statsFromVotes(d.votos) }])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"statsFromVotes = (votosObj) => {\n const arr = Object.entries(votosObj);\n arr.sort((a, b) => b[1] - a[1]); // desc\n const [ganador, max] = arr[0] ?? [null, 0];\n const [runner, second] = arr[1] ?? [null, 0];\n const total_validos = arr.reduce((s, [, x]) => s + x, 0);\n const pct_ganador = total_validos ? max / total_validos : 0;\n const pct_runner = total_validos ? second / total_validos : 0;\n const dif_pct = total_validos ? (max - second) / total_validos : 0; // ganador - 2°\n return {\n ganador,\n runner,\n max,\n second,\n total_validos,\n pct_ganador,\n pct_runner,\n dif_pct\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"co = co_raw.map((r) => {\n const o = {\n id_puesto: fixId(r.id_puesto),\n puesto: r[\"Nombre Puesto\"],\n comuna: r[\"Nombre Comuna\"],\n total_validos: num(r[\"Total\"]),\n blancos: num(r[\"VOTOS EN BLANCO\"]),\n nulos: num(r[\"VOTOS NULOS\"]),\n no_marcados: num(r[\"VOTOS NO MARCADOS\"]),\n winner_txt: r[\"Winner\"],\n runner_txt: r[\"Runner_Up\"],\n votos: {}\n };\n for (const p of co_parties) o.votos[p] = num(r[p]);\n return o;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"co_parties = Object.keys(co_raw[0]).filter((k) => !co_keep.has(k))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":208,"value":"co_keep = {\n const s = new Set(co_keep_base);\n if (!includeBlanco) s.add(\"VOTOS EN BLANCO\");\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"co_keep_base = new Set([\n \"id_puesto\",\n \"Nombre Puesto\",\n \"Nombre Comuna\",\n \"Total\",\n \"VOTOS NO MARCADOS\",\n \"VOTOS NULOS\",\n \"Winner\",\n \"Runner_Up\",\n \"Max_Votes\",\n \"Second_Max_Votes\",\n \"Pct_Winner\",\n \"Pct_Second\"\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"al = al_raw.map((r) => {\n const o = {\n id_puesto: fixId(r.id_puesto),\n puesto: r[\"Nombre Puesto\"],\n comuna: r[\"Nombre Comuna\"],\n total_validos: num(r[\"Total\"]),\n blancos: num(r[\"VOTOS EN BLANCO\"]),\n nulos: num(r[\"VOTOS NULOS\"]),\n no_marcados: num(r[\"VOTOS NO MARCADOS\"]),\n winner_txt: r[\"Winner\"],\n runner_txt: r[\"Runner_Up\"],\n votos: {}\n };\n for (const c of al_cands) o.votos[c] = num(r[c]);\n return o;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"al_cands = Object.keys(al_raw[0]).filter((k) => !al_keep.has(k))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"al_keep = {\n const s = new Set(al_keep_base);\n if (!includeBlanco) s.add(\"VOTOS EN BLANCO\");\n return s;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"al_keep_base = new Set([\n \"id_puesto\",\n \"Nombre Puesto\",\n \"Nombre Comuna\",\n \"Total\",\n \"VOTOS NO MARCADOS\",\n \"VOTOS NULOS\",\n \"Winner\",\n \"Runner_Up\",\n \"Max_Votes\",\n \"Second_Max_Votes\",\n \"Pct_Winner\",\n \"Pct_Second\"\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"num = (v) => {\n if (v == null || v === \"\") return 0;\n // quita separadores de miles y normaliza decimal\n const s = String(v).trim().replace(/\\./g, \"\").replace(/,/g, \".\");\n const n = +s;\n return Number.isFinite(n) ? n : 0;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"fixId = (s) =>\n String(s ?? \"\")\n .trim()\n .replace(/\\D/g, \"\") // deja solo dígitos (por si viene \"0101.\" o \"0101 \")\n .padStart(4, \"0\") // asegura 4 dígitos con ceros a la izquierda","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"al_raw = d3.dsvFormat(\";\").parse(await FileAttachment(\"alcaldia@2.csv\").text())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"co_raw = d3.dsvFormat(\";\").parse(await FileAttachment(\"concejo@1.csv\").text())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":296,"value":"colorRange_com = winners_com.map((w) => colorsByWinner.get(w) ?? \"#9E9E9E\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"colorDomain_com = winners_com","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"winners_com = Array.from(new Set(tiles_com.map((d) => d.winner)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"tiles_com = grid_com.flatMap((d) => [\n {\n ix: d.ix,\n layer: \"Alcaldía\",\n winner: d.alc_ganador,\n pct: d.alc_pct_ganador,\n comuna_key: d.comuna_key,\n comuna_label: d.comuna_label,\n alc_total: d.alc_total,\n con_total: d.con_total,\n alc_vot_ganador: d.alc_vot_ganador,\n con_vot_ganador: d.con_vot_ganador\n },\n {\n ix: d.ix,\n layer: \"Concejo\",\n winner: d.con_ganador,\n pct: d.con_pct_ganador,\n comuna_key: d.comuna_key,\n comuna_label: d.comuna_label,\n alc_total: d.alc_total,\n con_total: d.con_total,\n alc_vot_ganador: d.alc_vot_ganador,\n con_vot_ganador: d.con_vot_ganador\n }\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":284,"value":"grid_com = ordenados_com.map((d, i) => ({ ...d, ix: i }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"ordenados_com = d3.sort(comunaStats, (d) => d.alc_dif_pct)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"comunaStats = comunasJoin.map((k) => {\n const A = statsFromVotes(alVotesByComuna.get(k));\n const C = statsFromVotes(coVotesByComuna.get(k));\n return {\n comuna_key: k,\n comuna_label: labelByKey.get(k) ?? `Comuna ${+k}`, // rótulo bonito\n // Alcaldía\n alc_ganador: A.ganador,\n alc_pct_ganador: A.pct_ganador,\n alc_pct_runner: A.pct_runner,\n alc_dif_pct: A.dif_pct,\n alc_total: A.total_validos,\n alc_vot_ganador: A.max,\n // Concejo\n con_ganador: C.ganador,\n con_pct_ganador: C.pct_ganador,\n con_dif_pct: C.dif_pct,\n con_total: C.total_validos,\n con_vot_ganador: C.max\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"comunasJoin = Array.from(alVotesByComuna.keys()).filter((k) =>\n coVotesByComuna.has(k)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"coVotesByComuna = d3.rollup(\n co,\n (rows) => {\n const acc = new Map();\n for (const r of rows)\n for (const [k, v] of Object.entries(r.votos))\n acc.set(k, (acc.get(k) || 0) + v);\n return Object.fromEntries(acc);\n },\n (d) => canonCom(d.comuna)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":266,"value":"alVotesByComuna = d3.rollup(\n al,\n (rows) => {\n const acc = new Map();\n for (const r of rows)\n for (const [k, v] of Object.entries(r.votos))\n acc.set(k, (acc.get(k) || 0) + v);\n return Object.fromEntries(acc);\n },\n (d) => canonCom(d.comuna)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":268,"value":"// Devuelve una clave estable: \"01\"..\"22\" si encuentra número de comuna; si no, nombre normalizado\ncanonCom = (s) => {\n const t = String(s ?? \"\")\n .normalize(\"NFD\")\n .replace(/\\p{Diacritic}/gu, \"\") // sin tildes\n .replace(/[\\-–—]/g, \" \") // guiones → espacio\n .replace(/\\s+/g, \" \")\n .trim()\n .toUpperCase(); // espacios y MAYÚSCULAS\n // Busca \"COMUNA 12\", \"(12)\", \"12 -\", etc.\n let m = t.match(/\\bCOMUNA\\s*(\\d{1,2})\\b/) || t.match(/\\b(\\d{1,2})\\b/);\n if (m) return m[1].padStart(2, \"0\"); // clave numérica \"01\"..\"22\"\n return t; // fallback: el texto limpio\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"import { navio } from \"@john-guerra/navio\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"d3 = require(\"d3@7\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"Plot = require(\"@observablehq/plot\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"import { toggle } from \"@observablehq/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W54","stdlib":"1"}} 46:"$45:body"