2c:null 2d:["$","title",null,{"children":"Siniestralidad histórica CCS | CCS | Observable"}] 32:T5781,{ ////////////////////////////////////////////////////////////// // 0. Utilidades ////////////////////////////////////////////////////////////// const fmtS = d3.format("~s"); const fmtPct = d3.format(".1f"); const fmtM = (v) => `${d3.format(",.2f")(v / 1e6)} M€`; ////////////////////////////////////////////////////////////// // 1. Configuración de fuentes y tabla anual consolidada ////////////////////////////////////////////////////////////// const fuentes = [ { key: "Inun", label: "Inundaciones", data: inun_todos, color: ["#60A5FA", "#1A3A6B"] }, { key: "TCA", label: "TCA", data: tcas_todos, color: ["#5EEAD4", "#0F766E"] }, { key: "Erupción", label: "Erupción (La Palma)", data: erupcion_bienes, color: ["#FEF08A", "#CA8A04"] }, { key: "Terremoto", label: "Terremotos", data: terremoto_bienes, color: ["#FDBA74", "#C2410C"] }, { key: "Humanas", label: "Humanas", data: terr_bienes, color: ["#D1D5DB", "#4B5563"] } ]; const keys = fuentes.map(f => f.key); const meta = new Map(fuentes.map(f => [f.key, f])); const years = d3.range(1990, 2026); const annualData = years.map(year => { const row = { year }; fuentes.forEach(f => { row[f.key] = d3.sum(f.data.filter(d => +d["AÑO"] === year), d => d["Indemnizaciones"] || 0); }); row.total = keys.reduce((acc, k) => acc + row[k], 0); return row; }); ////////////////////////////////////////////////////////////// // 2. Estado interactivo ////////////////////////////////////////////////////////////// let mode = "stacked"; // stacked | grouped | normalized let hidden = new Set(); // causas ocultas let range = [years[0], years[years.length - 1]]; // rango de años activo ////////////////////////////////////////////////////////////// // 3. Layout general ////////////////////////////////////////////////////////////// const totalW = 1180; const leftW = 800; const rightW = totalW - leftW - 28; const root = d3.create("div") .style("position", "relative") .style("width", `${totalW}px`) .style("font-family", "'Inter', system-ui, sans-serif") .style("color", "#E5E7EB") .style("background", "radial-gradient(circle at 15% 0%, #111827 0%, #030712 70%)") .style("border-radius", "18px") .style("padding", "22px 26px") .style("box-shadow", "0 20px 50px -20px rgba(0,0,0,.6)"); root.append("h2") .style("margin", "0 0 2px 0") .style("font-size", "18px") .style("font-weight", "600") .text("Indemnizaciones por causa — análisis multidimensional (1990–2025)"); root.append("div") .style("margin", "0 0 16px 0") .style("font-size", "12.5px") .style("color", "#9CA3AF") .text("Filtra el periodo arrastrando el minigráfico inferior, cambia de vista y aísla causas desde la leyenda o el ranking."); const bodyRow = root.append("div") .style("display", "flex") .style("gap", "24px") .style("align-items", "flex-start"); const left = bodyRow.append("div").style("width", `${leftW}px`); const right = bodyRow.append("div").style("width", `${rightW}px`); ////////////////////////////////////////////////////////////// // 4. Controles de modo + reset ////////////////////////////////////////////////////////////// const modes = [ { id: "stacked", label: "Apilado" }, { id: "grouped", label: "Agrupado" }, { id: "normalized", label: "% Normalizado" } ]; const controls = left.append("div") .style("display", "flex") .style("gap", "8px") .style("margin-bottom", "10px"); const modeButtons = controls.selectAll("button.mode") .data(modes) .join("button") .attr("class", "mode") .text(d => d.label) .style("cursor", "pointer") .style("border", "1px solid #374151") .style("background", d => d.id === mode ? "#2563EB" : "transparent") .style("color", d => d.id === mode ? "#fff" : "#D1D5DB") .style("padding", "6px 14px") .style("border-radius", "999px") .style("font-size", "12px") .style("font-weight", "500") .style("transition", "all .2s ease") .on("click", (event, d) => { mode = d.id; modeButtons .style("background", m => m.id === mode ? "#2563EB" : "transparent") .style("color", m => m.id === mode ? "#fff" : "#D1D5DB"); render(); }); const resetBtn = controls.append("button") .text("Restablecer filtros") .style("cursor", "pointer") .style("border", "1px solid #374151") .style("background", "transparent") .style("color", "#9CA3AF") .style("padding", "6px 14px") .style("border-radius", "999px") .style("font-size", "12px") .style("margin-left", "auto") .on("click", () => { hidden = new Set(); range = [years[0], years[years.length - 1]]; gBrush.call(brush.move, [xContext(range[0]), xContext(range[1]) + xContext.bandwidth()]); render(); }); ////////////////////////////////////////////////////////////// // 5. SVG principal + defs ////////////////////////////////////////////////////////////// const marginTop = 30, marginRight = 20, marginBottom = 90, marginLeft = 64; const contextHeight = 44, contextGap = 26; const chartTotalHeight = 430; const height = chartTotalHeight - contextHeight - contextGap; const plotW = leftW - marginLeft - marginRight; const plotH = height - marginTop - marginBottom; const svg = left.append("svg") .attr("viewBox", `0 0 ${leftW} ${chartTotalHeight}`) .attr("width", leftW) .attr("height", chartTotalHeight) .style("display", "block") .style("overflow", "visible"); const defs = svg.append("defs"); keys.forEach(k => { const c = meta.get(k).color; const grad = defs.append("linearGradient") .attr("id", `bar-grad-${k}`) .attr("x1", "0").attr("y1", "0").attr("x2", "0").attr("y2", "1"); grad.append("stop").attr("offset", "0%").attr("stop-color", c[0]); grad.append("stop").attr("offset", "100%").attr("stop-color", c[1]); }); const glow = defs.append("filter").attr("id", "bar-glow2") .attr("x", "-50%").attr("y", "-50%").attr("width", "200%").attr("height", "200%"); glow.append("feGaussianBlur").attr("stdDeviation", "4").attr("result", "blur"); const gm = glow.append("feMerge"); gm.append("feMergeNode").attr("in", "blur"); gm.append("feMergeNode").attr("in", "SourceGraphic"); const gMain = svg.append("g").attr("transform", `translate(${marginLeft},${marginTop})`); const gBars = gMain.append("g"); const gLine = gMain.append("g"); const gTotals = gMain.append("g"); const gAxisX = gMain.append("g").attr("transform", `translate(0,${plotH})`); const gAxisY = gMain.append("g"); const x = d3.scaleBand().paddingInner(0.3).paddingOuter(0.15); const xSub = d3.scaleBand().padding(0.12); const y = d3.scaleLinear(); ////////////////////////////////////////////////////////////// // 6. Tooltip ////////////////////////////////////////////////////////////// const tooltip = root.append("div") .style("position", "absolute") .style("pointer-events", "none") .style("opacity", 0) .style("background", "rgba(17,24,39,.95)") .style("border", "1px solid #374151") .style("border-radius", "10px") .style("padding", "8px 12px") .style("font-size", "12px") .style("box-shadow", "0 10px 25px rgba(0,0,0,.5)") .style("transition", "opacity .15s ease") .style("z-index", 10); function showTooltip(event, row, key) { const [mx, my] = d3.pointer(event, root.node()); const visKeys = keys.filter(k => !hidden.has(k)); const total = visKeys.reduce((s, k) => s + row[k], 0); tooltip .style("opacity", 1) .style("left", `${mx + 16}px`) .style("top", `${my - 10}px`) .html(`

${row.year}

${visKeys.map(k => `

${meta.get(k).label}: ${fmtM(row[k])}

`).join("")}

Total: ${fmtM(total)}

`); } function moveTooltip(event) { const [mx, my] = d3.pointer(event, root.node()); tooltip.style("left", `${mx + 16}px`).style("top", `${my - 10}px`); } function hideTooltip() { tooltip.style("opacity", 0); } ////////////////////////////////////////////////////////////// // 7. Leyenda interactiva ////////////////////////////////////////////////////////////// const legend = left.append("div") .style("display", "flex") .style("gap", "16px") .style("flex-wrap", "wrap") .style("margin-top", "8px"); function toggleHidden(k) { if (hidden.has(k)) hidden.delete(k); else hidden.add(k); render(); } ////////////////////////////////////////////////////////////// // 8. Minigráfico de contexto (brush de años) ////////////////////////////////////////////////////////////// const gContext = svg.append("g") .attr("transform", `translate(${marginLeft},${height + contextGap})`); const xContext = d3.scaleBand().domain(years).range([0, plotW]).padding(0.1); const yContext = d3.scaleLinear() .domain([0, d3.max(annualData, d => d.total)]) .range([contextHeight, 0]); const ctxStack = d3.stack().keys(keys)(annualData); gContext.selectAll("g.ctx-layer") .data(ctxStack) .join("g") .attr("fill", d => `url(#bar-grad-${d.key})`) .attr("opacity", 0.55) .selectAll("rect") .data(d => d) .join("rect") .attr("x", d => xContext(d.data.year)) .attr("y", d => yContext(d[1])) .attr("height", d => yContext(d[0]) - yContext(d[1])) .attr("width", xContext.bandwidth()); gContext.append("g") .attr("transform", `translate(0,${contextHeight})`) .call(d3.axisBottom(xContext).tickValues(years.filter(yr => yr % 5 === 0)).tickSize(0)) .call(g => g.select(".domain").attr("stroke", "#374151")) .selectAll("text").attr("fill", "#6B7280").style("font-size", "10px"); const brush = d3.brushX() .extent([[0, 0], [plotW, contextHeight]]) .on("brush end", brushed); const gBrush = gContext.append("g").call(brush); function brushed(event) { if (!event.selection) return; const [x0, x1] = event.selection; const sel = years.filter(yr => { const bx = xContext(yr) + xContext.bandwidth() / 2; return bx >= x0 && bx <= x1; }); if (sel.length < 2) return; range = [d3.min(sel), d3.max(sel)]; render(); } ////////////////////////////////////////////////////////////// // 9. Panel derecho: KPIs + ranking ////////////////////////////////////////////////////////////// right.append("div") .style("font-size", "12px").style("color", "#9CA3AF").style("margin-bottom", "8px") .text("Resumen del periodo seleccionado"); const kpiGrid = right.append("div") .style("display", "grid") .style("grid-template-columns", "1fr 1fr") .style("gap", "10px") .style("margin-bottom", "18px"); function kpiCard(titleText) { const card = kpiGrid.append("div") .style("background", "rgba(255,255,255,.04)") .style("border", "1px solid #1F2937") .style("border-radius", "12px") .style("padding", "10px 12px"); card.append("div") .style("font-size", "10.5px").style("color", "#9CA3AF").style("margin-bottom", "4px") .text(titleText); return card.append("div") .style("font-size", "16px").style("font-weight", "700").style("color", "#F9FAFB"); } const kpiTotal = kpiCard("Total acumulado"); const kpiTop = kpiCard("Causa principal"); const kpiPeak = kpiCard("Año pico"); const kpiAvg = kpiCard("Media anual"); right.append("div") .style("font-size", "12px").style("color", "#9CA3AF").style("margin", "4px 0 8px") .text("Ranking por causa (periodo activo)"); const rankingBox = right.append("div"); ////////////////////////////////////////////////////////////// // 10. Render principal ////////////////////////////////////////////////////////////// function styleAxisY(g) { g.select(".domain").remove(); g.selectAll(".tick line").attr("stroke", "#1F2937").attr("stroke-dasharray", "2,3"); g.selectAll(".tick text").attr("fill", "#9CA3AF").style("font-size", "11px"); } function render() { const visKeys = keys.filter(k => !hidden.has(k)); const [r0, r1] = range; const view = annualData.filter(d => d.year >= r0 && d.year <= r1).map(d => { const row = { year: d.year }; keys.forEach(k => row[k] = visKeys.includes(k) ? d[k] : 0); row.totalVisible = visKeys.reduce((s, k) => s + row[k], 0); return row; }); //// Leyenda //// const legendItems = legend.selectAll("div.item") .data(fuentes, f => f.key) .join("div") .attr("class", "item") .style("display", "flex").style("align-items", "center").style("gap", "6px") .style("cursor", "pointer").style("font-size", "12.5px").style("user-select", "none") .style("opacity", f => hidden.has(f.key) ? 0.35 : 1) .on("click", (event, f) => toggleHidden(f.key)); legendItems.html(""); legendItems.append("span") .style("width", "10px").style("height", "10px").style("border-radius", "3px") .style("display", "inline-block") .style("background", f => `linear-gradient(180deg, ${f.color[0]}, ${f.color[1]})`); legendItems.append("span").text(f => f.label); //// Escalas //// x.domain(view.map(d => d.year)).range([0, plotW]); xSub.domain(visKeys).range([0, x.bandwidth()]); let series, yMax; if (mode === "normalized") { const norm = view.map(d => { const t = d.totalVisible || 1; const row = { year: d.year }; visKeys.forEach(k => row[k] = d[k] / t); keys.forEach(k => { if (!(k in row)) row[k] = 0; }); return row; }); series = d3.stack().keys(visKeys)(norm); y.domain([0, 1]).range([plotH, 0]); gAxisY.transition().duration(600).call(d3.axisLeft(y).ticks(5, "%").tickSize(-plotW)).call(styleAxisY); } else if (mode === "grouped") { yMax = d3.max(view, d => d3.max(visKeys, k => d[k])) || 1; y.domain([0, yMax * 1.15]).range([plotH, 0]); gAxisY.transition().duration(600).call(d3.axisLeft(y).ticks(6, "~s").tickSize(-plotW)).call(styleAxisY); } else { series = d3.stack().keys(visKeys)(view); yMax = d3.max(view, d => d.totalVisible) || 1; y.domain([0, yMax * 1.15]).range([plotH, 0]); gAxisY.transition().duration(600).call(d3.axisLeft(y).ticks(6, "~s").tickSize(-plotW)).call(styleAxisY); } gAxisX.transition().duration(600) .call(d3.axisBottom(x).tickValues(view.map(d => d.year).filter(yy => yy % 2 === 0)).tickSize(0)) .call(g => g.select(".domain").attr("stroke", "#374151")) .selectAll("text").attr("fill", "#9CA3AF").style("font-size", "10.5px") .attr("transform", "rotate(-45)").style("text-anchor", "end"); //// Barras //// if (mode === "grouped") { const flat = visKeys.flatMap(k => view.map(d => ({ year: d.year, key: k, value: d[k], raw: d }))); gBars.selectAll("rect") .data(flat, d => `${d.year}-${d.key}`) .join( enter => enter.append("rect") .attr("x", d => x(d.year) + xSub(d.key)) .attr("y", plotH).attr("height", 0).attr("width", xSub.bandwidth()) .attr("rx", 3).attr("fill", d => `url(#bar-grad-${d.key})`) .call(e => e.transition().duration(700).ease(d3.easeCubicOut) .attr("y", d => y(d.value)).attr("height", d => plotH - y(d.value))), update => update.call(u => u.transition().duration(700).ease(d3.easeCubicInOut) .attr("x", d => x(d.year) + xSub(d.key)).attr("width", xSub.bandwidth()) .attr("y", d => y(d.value)).attr("height", d => plotH - y(d.value))), exit => exit.transition().duration(400).attr("height", 0).attr("y", plotH).remove() ) .on("mousemove", function (event, d) { d3.select(this).attr("filter", "url(#bar-glow2)"); showTooltip(event, d.raw, d.key); }) .on("mouseleave", function () { d3.select(this).attr("filter", null); hideTooltip(); }); gLine.selectAll("*").remove(); gTotals.selectAll("*").remove(); } else { const flat = series.flatMap(s => s.map(d => ({ key: s.key, year: d.data.year, y0: d[0], y1: d[1], raw: d.data }))); gBars.selectAll("rect") .data(flat, d => `${d.year}-${d.key}`) .join( enter => enter.append("rect") .attr("x", d => x(d.year)).attr("y", plotH).attr("height", 0).attr("width", x.bandwidth()) .attr("rx", 3).attr("fill", d => `url(#bar-grad-${d.key})`) .call(e => e.transition().duration(700).ease(d3.easeCubicOut) .attr("y", d => y(d.y1)).attr("height", d => Math.max(0, y(d.y0) - y(d.y1)))), update => update.call(u => u.transition().duration(700).ease(d3.easeCubicInOut) .attr("x", d => x(d.year)).attr("width", x.bandwidth()) .attr("y", d => y(d.y1)).attr("height", d => Math.max(0, y(d.y0) - y(d.y1)))), exit => exit.transition().duration(400).attr("height", 0).attr("y", plotH).remove() ) .on("mousemove", function (event, d) { d3.select(this).attr("filter", "url(#bar-glow2)"); showTooltip(event, d.raw, d.key); }) .on("mouseleave", function () { d3.select(this).attr("filter", null); hideTooltip(); }); // Línea de tendencia del total visible const lineGen = d3.line() .x(d => x(d.year) + x.bandwidth() / 2) .y(d => y(d.totalVisible)) .curve(d3.curveMonotoneX); gLine.selectAll("path.trend") .data([view]) .join( enter => enter.append("path").attr("class", "trend") .attr("fill", "none").attr("stroke", "#F9FAFB").attr("stroke-width", 1.5) .attr("stroke-dasharray", "4,3").attr("opacity", 0.85) .attr("d", lineGen), update => update.transition().duration(700).attr("d", lineGen) ); // Etiquetas de total gTotals.selectAll("text") .data(view.filter(d => d.totalVisible > 0), d => d.year) .join( enter => enter.append("text") .attr("x", d => x(d.year) + x.bandwidth() / 2) .attr("y", d => y(d.totalVisible) - 8) .attr("text-anchor", "middle") .style("font-size", "9px").style("fill", "#9CA3AF").style("opacity", 0) .text(d => fmtS(d.totalVisible)) .call(e => e.transition().duration(700).style("opacity", 1)), update => update.call(u => u.transition().duration(700) .attr("x", d => x(d.year) + x.bandwidth() / 2) .attr("y", d => y(d.totalVisible) - 8) .text(d => fmtS(d.totalVisible))), exit => exit.transition().duration(300).style("opacity", 0).remove() ); } root.on("pointermove.tooltip", (event) => { if (tooltip.style("opacity") !== "0") moveTooltip(event); }); //////////////////////// KPIs //////////////////////// const totalAcum = d3.sum(view, d => d.totalVisible); const sumsByKey = visKeys.map(k => ({ key: k, value: d3.sum(view, d => d[k]) })) .sort((a, b) => d3.descending(a.value, b.value)); const top = sumsByKey[0]; const peakRow = view.reduce((best, d) => (!best || d.totalVisible > best.totalVisible) ? d : best, null); const avgAnual = view.length ? totalAcum / view.length : 0; kpiTotal.text(fmtM(totalAcum)); kpiTop.text(top ? meta.get(top.key).label : "—"); kpiPeak.text(peakRow ? `${peakRow.year}` : "—"); kpiAvg.text(fmtM(avgAnual)); //////////////////////// Ranking //////////////////////// const maxVal = d3.max(sumsByKey, d => d.value) || 1; const rankItems = rankingBox.selectAll("div.rank").data(sumsByKey, d => d.key); const rankEnter = rankItems.enter().append("div").attr("class", "rank") .style("margin-bottom", "8px") .style("cursor", "pointer") .on("click", (event, d) => toggleHidden(d.key)); rankEnter.append("div") .attr("class", "rank-label") .style("display", "flex").style("justify-content", "space-between") .style("font-size", "11.5px").style("color", "#D1D5DB").style("margin-bottom", "3px"); rankEnter.append("div") .style("background", "#1F2937").style("border-radius", "6px").style("height", "8px").style("overflow", "hidden") .append("div").attr("class", "rank-bar") .style("height", "100%").style("border-radius", "6px").style("width", "0%"); const rankMerge = rankEnter.merge(rankItems); rankMerge.select(".rank-label").html(d => { const pct = totalAcum ? (d.value / totalAcum * 100) : 0; return `${meta.get(d.key).label}${fmtM(d.value)} · ${fmtPct(pct)}%`; }); rankMerge.select(".rank-bar") .style("background", d => `linear-gradient(90deg, ${meta.get(d.key).color[0]}, ${meta.get(d.key).color[1]})`) .transition().duration(700) .style("width", d => `${(d.value / maxVal * 100)}%`); rankItems.exit().remove(); // Reordena visualmente el ranking según el orden de sumsByKey rankingBox.selectAll("div.rank").data(sumsByKey, d => d.key).order(); } // La selección inicial del brush se aplica aquí, al final, y no justo tras // crearlo: `brush.move` dispara "brush end" de forma síncrona, y ese evento // llama a render(). Si se hiciera antes, render() se ejecutaría cuando las // tarjetas KPI y el panel de ranking (declarados más abajo) todavía no // existen, provocando un ReferenceError por acceso a un const no inicializado. gBrush.call(brush.move, [xContext(range[0]), xContext(range[1]) + xContext.bandwidth()]); render(); return root.node(); }33:[{"id":"26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","href":"https://static.observableusercontent.com/files/26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","name":"260527_Charla_EMBATE@2.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1778655242856.915,"size":14132},{"id":"26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","href":"https://static.observableusercontent.com/files/26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","name":"260527_Charla_EMBATE@3.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1778655539898.161,"size":14132},{"id":"e91abc73f025a4568286378d8d1d91d9832f2ac4cb8d51dbe2715665da57157a121f5d1133e1b721f3d7baeb7c9faffdcf8f662cb4d4fb395c0b77f071a99202","href":"https://static.observableusercontent.com/files/e91abc73f025a4568286378d8d1d91d9832f2ac4cb8d51dbe2715665da57157a121f5d1133e1b721f3d7baeb7c9faffdcf8f662cb4d4fb395c0b77f071a99202","name":"260908_Charla_EMBATE.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1788866964425,"size":13893},{"id":"3a8a9472d26a4a28844c8d8583995118f014580c65b92c62c31dd42df62ed545a052a5cb156ad3479736fe8b7cfa7c90dc3368f0aff97e5b4fbe63b33955aaa3","href":"https://static.observableusercontent.com/files/3a8a9472d26a4a28844c8d8583995118f014580c65b92c62c31dd42df62ed545a052a5cb156ad3479736fe8b7cfa7c90dc3368f0aff97e5b4fbe63b33955aaa3","name":"Estadistica RREE 2024 web.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1778655207701.752,"size":5972604},{"id":"364c675cce1488d72a62ade30599f48c37009ee1705d03e789f7d30830a23ff974756bd56d34fadb6a5b0d5db687b40265022e4d14a65cdfb7ac59c606c6be43","href":"https://static.observableusercontent.com/files/364c675cce1488d72a62ade30599f48c37009ee1705d03e789f7d30830a23ff974756bd56d34fadb6a5b0d5db687b40265022e4d14a65cdfb7ac59c606c6be43","name":"Estadistica_RREE_2025web.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1785132921003,"size":6842297}] 30:{"id":"89bf6be1a68b19ce","slug":"ccsrree_indhist","title":"Siniestralidad histórica CCS","thumbnail":"3b117f1af63d31c35a8b471ee068b491343d4113b5228bf9a2d8c920b7052813","access_level":"public","create_time":"$D2026-09-15T20:24:41.840Z","update_time":"$D2026-10-06T07:02:57.899Z","view_time":null,"first_public_time":"$D2026-10-06T06:42:48.509Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"b41ec3c254271ac8","login":"ccs529","name":"CCS","avatar_url":"https://avatars-next.observableusercontent.com/b59bc59c2d180c039d524a5d961ed3c9d500df42287155694895191c78044d7e","tier":"starter_2024","bio":""},"version":600,"publish_version":600,"role":null,"authored":false,"authors":[{"type":"individual","id":"8e6ec184824ddf12","login":"uelosegi","name":"Uelosegi","avatar_url":"https://avatars-next.observableusercontent.com/dffdbab23303bc1c4d4ebb7f164683ea0e1cd331a930b0366c0adb65d402d1e0","tier":null,"bio":""}],"members":[{"type":"team","id":"b41ec3c254271ac8","login":"ccs529","name":"CCS","avatar_url":"https://avatars-next.observableusercontent.com/b59bc59c2d180c039d524a5d961ed3c9d500df42287155694895191c78044d7e","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Siniestralidad histórica CCS","cells":[{"id":0,"value":"# Siniestralidad histórica CCS","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":285,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"d3 = require(\"d3@7\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"sheetjs = require(\"https://cdn.sheetjs.com/xlsx-0.20.1/package/dist/xlsx.full.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"rawFile = FileAttachment(\"Estadistica_RREE_2025web.xlsx\").arrayBuffer()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"workbook = {\n const data = new Uint8Array(rawFile);\n const wb = sheetjs.read(data, { type: \"array\" });\n console.log(\"Hojas encontradas:\", wb.SheetNames);\n return wb;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"workbook.SheetNames","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"rawFile1 = FileAttachment(\"260908_Charla_EMBATE.xlsx\").arrayBuffer()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"bienes_todos = Array.from(\n d3.rollup(\n [...inun_bienes, ...tca_bienes, ...erupcion_bienes, ...terremoto_bienes, ...terr_bienes],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"personas_todos = Array.from(\n d3.rollup(\n [...inun_personas, ...tca_personas, ...terremoto_personas, ...terr_personas],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"pb_todos = Array.from(\n d3.rollup(\n [...inun_pb, ...tca_pb, ...erupcion_pb, ...terremoto_pb, ...terr_pb],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"todos = Array.from(\n d3.rollup(\n [...todos_bienes, ...todos_personas, ...todos_pb],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"inun_todos = Array.from(\n d3.rollup(\n [...inun_bienes, ...inun_personas, ...inun_pb],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"tcas_todos = Array.from(\n d3.rollup(\n [...tca_bienes, ...tca_personas, ...tca_pb],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"terremoto_todos = Array.from(\n d3.rollup(\n [...terremoto_bienes, ...terremoto_personas, ...terremoto_pb],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"erupcion_todos = Array.from(\n d3.rollup(\n [...erupcion_bienes, ...erupcion_pb],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":266,"value":"terr_todos = Array.from(\n d3.rollup(\n [...terr_bienes, ...terr_personas, ...terr_pb],\n filas => ({\n AÑO: +filas[0].AÑO,\n \"Nº de Expedientes*\": d3.sum(filas, d => +d[\"Nº de Expedientes*\"] || 0),\n Indemnizaciones: d3.sum(filas, d => +d[\"Indemnizaciones\"] || 0),\n \"Costes Medios\": d3.sum(filas, d => +d[\"Costes Medios\"] || 0)\n }),\n d => +d.AÑO\n ).values()\n)\n.sort((a, b) => a.AÑO - b.AÑO)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"workbook1 = {\n const data = new Uint8Array(rawFile1);\n const wb = sheetjs.read(data, { type: \"array\" });\n console.log(\"Hojas encontradas:\", wb.SheetNames);\n return wb;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"workbook1.SheetNames","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"embate_bienes_can = {\n const sheetName = \"CAN\";\n const sheet = workbook1.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook1.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"A1:E31\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"Año siniestro\"]) >= 1996);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"embate_bienes = {\n const sheetName = \"ESP\";\n const sheet = workbook1.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook1.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"A1:D31\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"Año siniestro\"]) >= 1996);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"todos_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B651:E706\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"bienes_polizas = {\n const sheetName = \"S1-I-B\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B8:J46\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"bienes_capitales = {\n const sheetName = \"S1-I-B\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"N8:U46\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"pb_polizas = {\n const sheetName = \"S1-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B8:I32\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"pb_capitales = {\n const sheetName = \"S1-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"L8:R32\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"personas_polcapits = {\n const sheetName = \"S1-III-P\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B9:E46\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"todos_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B291:E330\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"todos_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"H12:K34\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"inun_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B15:E70\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"inun_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B13:E52\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"inun_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B12:E34\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"tca_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B204:E259\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"tca_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B105:E144\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"tca_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B99:E121\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":256,"value":"erupcion_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B141:E196\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"erupcion_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B70:E92\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"terremoto_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B78:E133\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"terremoto_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B59:E98\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"terremoto_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B41:E63\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"terr_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B333:E388\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"terr_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B151:E190\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"terr_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B128:E150\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"