40:null 41:["$","title",null,{"children":"Presuntos Suicidios. Colombia, 2015 a 2024. | David Zamora | Observable"}] 47:T1757,viewof heatmapYM = { const margin = { top: 36, right: 8, bottom: 48, left: 56 }; const rightBarW = 120; // ancho para totales por año (barras horizontales) const bottomBarH = 60; // alto para totales por mes (barras verticales) const W = Math.max(640, width); const cols = 12; const rows = years.length; // Tamaños de celda const cw = Math.floor((W - margin.left - margin.right - rightBarW) / cols); const ch = 26; // alto por fila const innerW = cw * cols; const innerH = ch * rows; const H = margin.top + innerH + bottomBarH + margin.bottom; const x = d3 .scaleBand() .domain(d3.range(1, 13)) .range([margin.left, margin.left + innerW]) .paddingInner(0.05); const y = d3 .scaleBand() .domain(years) .range([margin.top, margin.top + innerH]) .paddingInner(0.05); // Color del heatmap (raíz cuadrada para comprimir extremos) const color = d3.scaleSequentialSqrt([0, maxCount], d3.interpolateViridis); // Escalas para barras marginales const xRow = d3 .scaleLinear() .domain([0, maxRowTotal]) .range([0, rightBarW - 24]); // barras horizontales (derecha) const yCol = d3 .scaleLinear() .domain([0, maxColTotal]) .range([0, bottomBarH - 18]); // barras verticales (abajo) // Contenedor + tooltip const wrap = d3.create("div").style("position", "relative"); const svg = d3 .create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .style("display", "block") .style("max-width", "100%") .style("height", "auto") .style("font", "12px system-ui, sans-serif"); wrap.append(() => svg.node()); const tip = wrap .append("div") .style("position", "absolute") .style("pointer-events", "none") .style("background", "rgba(0,0,0,.8)") .style("color", "#fff") .style("padding", "6px 8px") .style("border-radius", "6px") .style("visibility", "hidden"); // === Heat cells === svg .append("g") .selectAll("rect") .data(heat, (d) => `${d.year}-${d.month}`) .join("rect") .attr("x", (d) => x(d.month)) .attr("y", (d) => y(d.year)) .attr("width", x.bandwidth()) .attr("height", y.bandwidth()) .attr("fill", (d) => color(d.value)) .on("pointerenter", (event, d) => { tip .html( `

${mesNombre(d.month)} ${d.year}

Casos: ${d.value.toLocaleString("es-CO")}

Pertenencia: ${filtroPertenencia}

` ) .style("visibility", "visible"); }) .on("pointermove", (event) => { const [px, py] = d3.pointer(event, wrap.node()); tip.style("left", `${px + 12}px`).style("top", `${py + 12}px`); }) .on("pointerleave", () => tip.style("visibility", "hidden")); // Meses (encabezado columnas) svg .append("g") .selectAll("text") .data(d3.range(1, 13)) .join("text") .attr("x", (m) => x(m) + x.bandwidth() / 2) .attr("y", margin.top - 10) .attr("text-anchor", "middle") .text((m) => mesAbbr(m)); // Años (filas) svg .append("g") .selectAll("text") .data(years) .join("text") .attr("x", margin.left - 8) .attr("y", y.bandwidth() / 2) .attr("dy", (_, i) => y(years[i]) + 4) .attr("text-anchor", "end") .text((d) => d); // === Barras marginales: totales por año (derecha) === const xBarOrigin = margin.left + innerW + 8; svg .append("g") .selectAll("rect") .data(years) .join("rect") .attr("x", xBarOrigin) .attr("y", y) .attr("width", (d) => xRow(rowTotals.get(d))) .attr("height", y.bandwidth()) .attr("fill", "#555") .attr("opacity", 0.8); // Etiquetas numéricas de totales por año svg .append("g") .selectAll("text") .data(years) .join("text") .attr("x", (d) => xBarOrigin + xRow(rowTotals.get(d)) + 4) .attr("y", (d) => y(d) + y.bandwidth() / 2 + 4) .attr("font-size", 11) .text((d) => d3.format(",")(rowTotals.get(d))); // === Barras marginales: totales por mes (abajo) === const yBarBaseline = margin.top + innerH + 8; svg .append("g") .selectAll("rect") .data(d3.range(1, 13)) .join("rect") .attr("x", (m) => x(m)) .attr("y", (m) => yBarBaseline + (bottomBarH - 18 - yCol(colTotals.get(m)))) .attr("width", x.bandwidth()) .attr("height", (m) => yCol(colTotals.get(m))) .attr("fill", "#555") .attr("opacity", 0.8); // Etiquetas numéricas de totales por mes svg .append("g") .selectAll("text") .data(d3.range(1, 13)) .join("text") .attr("x", (m) => x(m) + x.bandwidth() / 2) .attr("y", yBarBaseline + (bottomBarH - 2)) .attr("text-anchor", "middle") .attr("font-size", 11) .text((m) => d3.format(",")(colTotals.get(m))); // Leyenda continua (opcional breve) const Lw = Math.min(240, innerW); const Lh = 8, Lx = margin.left, Ly = H - margin.bottom + 16; const defs = svg.append("defs"); const grad = defs .append("linearGradient") .attr("id", "legend-hm") .attr("x1", "0%") .attr("x2", "100%"); d3.range(0, 1.0001, 0.1).forEach((t) => { grad .append("stop") .attr("offset", `${t * 100}%`) .attr("stop-color", color(t * maxCount)); }); svg .append("rect") .attr("x", Lx) .attr("y", Ly) .attr("width", Lw) .attr("height", Lh) .attr("fill", "url(#legend-hm)"); const scaleL = d3 .scaleLinear() .domain([0, maxCount]) .range([Lx, Lx + Lw]); const axisL = d3.axisBottom(scaleL).ticks(4).tickFormat(d3.format(",")); svg .append("g") .attr("transform", `translate(0, ${Ly + Lh})`) .call(axisL) .call((g) => g.select(".domain").remove()); svg .append("text") .attr("x", Lx) .attr("y", Ly - 6) .attr("font-size", 11) .text(`Casos/mes — Filtro: ${filtroPertenencia}`); return wrap.node(); }48:Tbbb,viewof treemapEdad = { // Construye un "mini árbol" solo con root -> edades (más rápido que estratificar caso por caso) const treeData = { name: "root", children: conteoEdad.map(([name, value]) => ({ name, value })) }; const root = d3.hierarchy(treeData).sum((d) => d.value); const W = width; const H = Math.max(420, Math.round(width * 0.55)); d3 .treemap() .size([W, H]) .paddingOuter(4) .paddingInner(2) .round(true) .tile(d3.treemapSquarify)(root); // posiciones x0,y0,x1,y1 // :contentReference[oaicite:1]{index=1} // Dominio de colores = grupos etarios decenales const domainAges = root.leaves().map((d) => d.data.name); const palette = [...d3.schemeTableau10, ...d3.schemeSet3, ...d3.schemePaired]; // suficientes colores const color = d3 .scaleOrdinal() .domain(domainAges) .range(palette.slice(0, domainAges.length)); // :contentReference[oaicite:2]{index=2} // Contenedor + tooltip const wrap = d3.create("div").style("position", "relative"); const svg = wrap .append("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .style("display", "block") .style("max-width", "100%") .style("height", "auto") .style("font", "12px system-ui, sans-serif"); const tip = wrap .append("div") .style("position", "absolute") .style("pointer-events", "none") .style("background", "rgba(0,0,0,.75)") .style("color", "#fff") .style("padding", "8px 10px") .style("border-radius", "6px") .style("visibility", "hidden"); const g = svg.append("g"); const cell = g .selectAll("g.cell") .data(root.leaves()) .join("g") .attr("class", "cell") .attr("transform", (d) => `translate(${d.x0},${d.y0})`); const fmt = new Intl.NumberFormat("es-CO"); cell .append("rect") .attr("width", (d) => Math.max(0, d.x1 - d.x0)) .attr("height", (d) => Math.max(0, d.y1 - d.y0)) .attr("fill", (d) => color(d.data.name)) .attr("stroke", "#fff") .attr("stroke-width", 0.5) .on("pointerenter", (event, d) => { tip .html( `

${d.data.name}

Casos: ${fmt.format(d.value ?? 0)}

Pertenencia: ${filtroPertenencia}

` ) .style("visibility", "visible"); }) .on("pointermove", (event) => { const [x, y] = d3.pointer(event, wrap.node()); tip.style("left", `${x + 12}px`).style("top", `${y + 12}px`); }) .on("pointerleave", () => tip.style("visibility", "hidden")); // Etiquetas si hay espacio cell .filter((d) => d.x1 - d.x0 > 72 && d.y1 - d.y0 > 22) .append("text") .attr("x", 6) .attr("y", 16) .attr("fill", "currentColor") .attr("paint-order", "stroke") .attr("stroke", "#fff") .attr("stroke-width", 3) .text((d) => d.data.name); return wrap.node(); }49:[{"id":"38d1324570554b7c5f3eec10f65723a7f0e27402c799233d4a2c98d8a702c23d0123ea4db46a00716fd325dd9020d38112604f6a28f188e06a2bdf156176cca6","href":"https://static.observableusercontent.com/files/38d1324570554b7c5f3eec10f65723a7f0e27402c799233d4a2c98d8a702c23d0123ea4db46a00716fd325dd9020d38112604f6a28f188e06a2bdf156176cca6","name":"shapes-bogota-laburbano.geojson","type":"application/geo+json","lastModified":1736574844678.218,"size":4278075}] 45:{"id":"654bfbff31a90ad7","slug":null,"title":"Presuntos Suicidios. Colombia, 2015 a 2024.","thumbnail":"a0d51915602f6f25f9f5d7097bdba9d56d96935a5bc0879f4eaf47b65c04f575","access_level":"public","create_time":"$D2025-01-11T05:50:37.590Z","update_time":"$D2025-10-19T06:55:04.151Z","view_time":null,"first_public_time":"$D2025-01-11T05:50:37.590Z","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":280,"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":0,"collection":{"id":"74bad9ae81ed6f9f","slug":"inml","title":"INML","owner":{"id":"872bea5f18aed5fe","login":"davzrx","name":"David Zamora"}},"type":"notebook","body":{"titling":"auto","title":"Presuntos Suicidios. Colombia, 2015 a 2024.","cells":[{"id":0,"value":"# Presuntos Suicidios. Colombia, 2015 a 2024.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":30,"value":"tooltip = {\n return d3\n .select(\"body\")\n .append(\"div\")\n .style(\"position\", \"absolute\")\n .style(\"background\", \"white\")\n .style(\"border\", \"1px solid black\")\n .style(\"padding\", \"5px\")\n .style(\"border-radius\", \"5px\")\n .style(\"visibility\", \"hidden\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"selected = navio(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"viewof maxDigit = slider({\n min: 1,\n max: 2,\n value: 2,\n step: 1,\n title: \"Longitud del Código de Municipio (mpios)\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"caseCountMap = {\n // Calcular el conteo por municipio\n const caseCounts = d3.rollups(\n data,\n (v) => v.length, // Contar casos\n (d) => d.codigo_dane_municipio\n );\n\n // Convertir a un mapa clave-valor para acceso rápido\n return new Map(caseCounts);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"table(data, { paged: 6 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"treemap = d3.treemap().size([500,500]).padding(0.5)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"mesIndex = (m) => {\n if (m == null) return null;\n const s = String(m)\n .trim()\n .toLocaleLowerCase(\"es\")\n .normalize(\"NFD\")\n .replace(/\\p{Diacritic}/gu, \"\"); // quita tildes\n\n // ¿es numérico? (\"1\", \"01\", \"12\")\n const n = +s;\n if (Number.isFinite(n) && n >= 1 && n <= 12) return n;\n\n const map = {\n enero: 1,\n ene: 1,\n febrero: 2,\n feb: 2,\n marzo: 3,\n mar: 3,\n abril: 4,\n abr: 4,\n mayo: 5,\n may: 5,\n junio: 6,\n jun: 6,\n julio: 7,\n jul: 7,\n agosto: 8,\n ago: 8,\n septiembre: 9,\n setiembre: 9,\n sep: 9,\n set: 9,\n octubre: 10,\n oct: 10,\n noviembre: 11,\n nov: 11,\n diciembre: 12,\n dic: 12\n };\n return map[s] ?? null;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"mesNombre = (m) =>\n [\n \"\",\n \"Enero\",\n \"Febrero\",\n \"Marzo\",\n \"Abril\",\n \"Mayo\",\n \"Junio\",\n \"Julio\",\n \"Agosto\",\n \"Septiembre\",\n \"Octubre\",\n \"Noviembre\",\n \"Diciembre\"\n ][m]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":239,"value":"mesAbbr = (m) =>\n [\n \"\",\n \"Ene\",\n \"Feb\",\n \"Mar\",\n \"Abr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Ago\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dic\"\n ][m]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"// Años presentes (ordenados) con el filtro actual\nyears = Array.from(\n new Set(dataFiltrada.map((d) => +d.a_o_del_hecho).filter(Number.isFinite))\n).sort(d3.ascending)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"// rollup: Map(year -> Map(month -> count))\ncountsYM = d3.rollup(\n dataFiltrada,\n (v) => v.length,\n (d) => +d.a_o_del_hecho,\n (d) => mesIndex(d.mes_del_hecho)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"// Matriz del heat (completa meses 1..12 para cada año)\nheat = years.flatMap((y) =>\n d3.range(1, 13).map((m) => ({\n year: y,\n month: m,\n value: countsYM.get(y)?.get(m) ?? 0\n }))\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":262,"value":"rowTotals = new Map(\n years.map((y) => [\n y,\n d3.sum(\n heat.filter((d) => d.year === y),\n (d) => d.value\n )\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"colTotals = new Map(\n d3.range(1, 13).map((m) => [\n m,\n d3.sum(\n heat.filter((d) => d.month === m),\n (d) => d.value\n )\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"maxCount = d3.max(heat, (d) => d.value) ?? 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"maxRowTotal = d3.max(rowTotals.values()) ?? 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"maxColTotal = d3.max(colTotals.values()) ?? 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"viewof filtroPertenencia = {\n const form = d3.create(\"form\").attr(\"class\", \"btnbar\");\n form.property(\"value\", \"Todas\");\n\n pertenencias.forEach((p) => {\n const btn = form.append(\"button\").attr(\"type\", \"button\").text(p);\n if (p === \"Todas\") btn.classed(\"active\", true);\n btn.on(\"click\", (event) => {\n event.preventDefault();\n form.selectAll(\"button\").classed(\"active\", false);\n d3.select(event.currentTarget).classed(\"active\", true);\n form.property(\"value\", p);\n form.dispatch(\"input\", { bubbles: true });\n });\n });\n\n return form.node();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"import { navio } from \"@john-guerra/navio\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"import { table } from \"@john-guerra/tables\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"columns = data.columns ?? [...new Set(data.flatMap((d) => Object.keys(d)))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"data = loadSocrata(url)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"import { loadSocrata } from \"@john-guerra/socrata-load-multiples-pages\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"url = \"https://www.datos.gov.co/resource/f75u-mirk.csv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"viewof mergedData = data.map((d) => {\n const geoFeature = geojsonData.features.find(\n (f) => f.properties.mpios === d.codigo_dane_municipio\n );\n return {\n ...d,\n geoData: geoFeature ? geoFeature.properties : null\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"aggregatedData = {\n const municipios = geojsonData.features;\n\n // Agrupación dinámica\n const deptos = d3.rollup(\n municipios,\n (v) => d3.sum(v, (d) => d.properties.area), // Sumar áreas\n (d) => d.properties.mpios.slice(0, maxDigit) // Filtrar por longitud\n );\n\n // Convertir a un array de objetos para facilitar el acceso\n return Array.from(deptos, ([key, area]) => ({\n agrupacion: key,\n area_total: area\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"geojsonData.features[0].properties","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"colorScale = {\n const areas = geojsonData.features.map((d) => d.properties.area);\n return d3\n .scaleQuantize()\n .domain([d3.min(areas), d3.max(areas)])\n .range(d3.schemeBlues[9]); // Escala de azules\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"geojsonData = FileAttachment(\"shapes-bogota-laburbano.geojson\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"d3 = require(\"d3@7\") // Asegura la última versión de D3.js","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"import { slider } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"NR = \"NR\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"normBase = (v) =>\n (v == null ? \"\" : String(v))\n .trim()\n .toLocaleLowerCase(\"es\")\n .replace(/\\s+/g, \" \")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"nicePertenencia = (v) => {\n const t = normBase(v);\n if (!t) return NR;\n if (t.startsWith(\"sin inform\")) return \"Sin información\";\n // devuelve el label original razonable (capas de datos reales suelen venir ya en título)\n // puedes mapear más alias aquí si hace falta.\n return String(v).trim();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"decadeBin = (s) => {\n if (!s) return NR;\n const t = String(s).toLocaleLowerCase(\"es\");\n const m = t.match(/\\d{1,3}/); // primer número que aparezca\n if (m) {\n const n = +m[0];\n const start = Math.floor(n / 10) * 10;\n const openEnded =\n /(?:\\+|m[aá]s)/.test(t) || (t.includes(\"y\") && t.includes(\"m\"));\n return openEnded ? `${start}+` : `${start}–${start + 9}`;\n }\n if (/menor/.test(t)) return \"0–9\"; // ej. \"Menor de 1 año\"\n return NR;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"decadeKey = (label) => {\n if (label === NR) return 1e9;\n const m = String(label).match(/^\\d{1,3}/);\n return m ? +m[0] : 1e9 - 1;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"pertenencias = {\n const counts = d3.rollups(\n data,\n (v) => v.length,\n (d) => nicePertenencia(d.pertenencia_etnica)\n );\n counts.sort((a, b) => d3.descending(a[1], b[1]));\n return [\"Todas\", ...counts.map((d) => d[0])];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":225,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"// Datos filtrados por la selección actual\ndataFiltrada = {\n const sel = filtroPertenencia;\n if (sel === \"Todas\") return data;\n const keySel = normBase(sel);\n return data.filter(\n (d) => normBase(nicePertenencia(d.pertenencia_etnica)) === keySel\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"conteoEdad = {\n const entries = d3.rollups(\n dataFiltrada,\n (v) => v.length,\n (d) => decadeBin(d.grupo_de_edad_quinquenal)\n );\n // ⬇️ Ordenar por valor (a[1]) de mayor a menor\n entries.sort((a, b) => d3.descending(a[1], b[1]));\n return entries;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":178,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":152,"value":"root.eachAfter((node) => {\n if (node.children) {\n node.children = node.children.filter((c) => c.value >= 5);\n if (node.children.length === 0) node.children = null;\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"root.sort((a, b) => d3.descending(a.value, b.value))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"root = d3\n .stratify()\n .path((d) => d)(paths)\n .sum(() => 1) // cada caso cuenta 1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"paths = data.map((d) =>\n [\n \"Colombia\",\n `PERTENENCIA=${clean(d.pertenencia_etnica)}`,\n `PUEBLO=${clean(d.pueblo_indigena)}`,\n `ANCESTRO=${clean(d.ancestro_racial)}`,\n `SEXO=${clean(d.sexo_de_la_victima)}`,\n `EDAD=${clean(d.grupo_de_edad_quinquenal)}`,\n `ESCOLARIDAD=${clean(d.escolaridad)}`,\n `EST_CIVIL=${clean(d.estado_civil)}`,\n `ESCENARIO=${clean(d.escenario_del_hecho)}`,\n `ZONA=${clean(d.zona_del_hecho)}`,\n `DEPTO=${labelDep(d)}`,\n `MUNI=${labelMun(d)}`,\n `id=${clean(d.id)}`\n ].join(\"/\")\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"// Paleta amplia; si hay más categorías, se cicla.\ncolor = d3\n .scaleOrdinal()\n .domain(pertenencias)\n .range([...d3.schemeTableau10, ...d3.schemeSet3, ...d3.schemePaired])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":140,"value":"labelMun = (d) =>\n `${clean(d.codigo_dane_municipio)}-${clean(d.municipio_del_hecho_dane)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"labelDep = (d) =>\n `${clean(d.codigo_dane_departamento)}-${clean(d.departamento_del_hecho_dane)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"normalizeKey = (s) =>\n String(s)\n .normalize(\"NFC\")\n .trim()\n .toLocaleLowerCase(\"es\")\n .replace(/\\s+/g, \" \")\n .replace(/informacion/g, \"información\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":130,"value":"clean = (v) =>\n v == null || v === \"\" ? NIL : String(v).trim().replaceAll(\"/\", \"∕\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"pertFromNode = (d) => {\n const a1 = d.ancestors().find((a) => a.depth === 1);\n return a1 ? labelFromSegment(a1.id.split(\"/\").pop()) : \"N/A\";\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"NIL = \"NR\" // No reporta","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"SHOW_DEPTH = 5","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"labelFromNode = (d) => labelFromSegment(d.id.split(\"/\").pop())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"labelFromSegment = (s) =>\n s.includes(\"=\") ? s.split(\"=\").slice(1).join(\"=\") : s","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"fmt = new Intl.NumberFormat(\"es-CO\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"topojson = require(\"topojson-client@3\") // Opcional para TopoJSON","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 46:"$45:body"