29:null 2a:["$","title",null,{"children":"Did Movistar's 3G Shutdown Improve 4G in Peru? — Frozen version (IEEE LATINCOM 2026) | Leibnihtz Ayamamani-Choque | Observable"}] 2f:T464,# Did Movistar's 3G Shutdown Improve 4G in Peru? — Frozen version (IEEE LATINCOM 2026) *Frozen companion to the IEEE LATINCOM 2026 paper. Data: OSIPTEL through May 2026, repository tag `v1.2-camera-ready` (commit `cfac8c0`). A live version, updated monthly, is available [here](https://observablehq.com/@leibnihtz/apagado-3g-de-movistar-en-peru).* ## A Data-Driven Look at Network Refarming Mobile operators around the world are retiring legacy 2G and 3G networks to free up spectrum for newer technologies. In Peru, Movistar's series in OSIPTEL's open data shows a progressive disappearance of 3G service across districts, a transition publicly associated with spectrum refarming toward 4G. OSIPTEL's data do not identify the LTE band or carrier activated after each event. This notebook analyzes whether that transition was followed by visible changes in Movistar's 4G performance across districts in Peru. Using public mobile internet data, the goal is to move beyond the announcement and evaluate the network impact from a data perspective. **Data source:** OSIPTEL's "Checa tu Internet Móvil" public portal 30:Tc71,

Automated Pipeline for Network Data Analysis

Peru 3G shutdown and LTE refarming analysis

OSIPTEL

Public data source

Mobile internet KPIs

→

GitHub Actions

Automated pipeline

Monthly processing

→

GitHub Repository

Versioned outputs

CSV · GeoJSON · scripts

→

ObservableHQ

Interactive notebook

Maps · trends · rankings

Extract

Process & publish

Load data

31:T447,html`

Confirmed districts

${summary.length}

≥ 3 months after shutdown

${filteredSummary.length}

Median download gain

${d3.median(filteredSummary, d => d.delta_4g_download_mbps).toFixed(2)} Mbps

Departments

${new Set(summary.map(d => d.department)).size}

`32:T19ad,d3BubbleMap = { const W = width; const H = 760; const svg = d3.create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .attr("style", "max-width:100%;height:auto;background:#ffffff;cursor:grab;"); const affectedDistricts = upgradeDistricts.features.filter(d => Number.isFinite(d.properties.delta_4g_download_mbps) ); // Fit the map using the department layer const mapPadding = { top: 90, right: 90, bottom: 140, left: 90 }; const projection = d3.geoMercator().fitExtent( [ [mapPadding.left, mapPadding.top], [W - mapPadding.right, H - mapPadding.bottom] ], departments ); const path = d3.geoPath(projection); const values = affectedDistricts.map(d => d.properties.delta_4g_download_mbps); const maxAbs = d3.max(values, d => Math.abs(d)) || 1; const color = d3.scaleDiverging() .domain([-maxAbs, 0, maxAbs]) .interpolator(d3.interpolateRdYlGn); const radius = d3.scaleSqrt() .domain([0, maxAbs]) .range([4, 16]); const g = svg.append("g"); // Department base map g.append("g") .attr("fill", "#f1f5f9") .attr("stroke", "#94a3b8") .attr("stroke-width", 0.9) .attr("stroke-opacity", 0.8) .selectAll("path") .data(departments.features) .join("path") .attr("d", path) .append("title") .text(d => { const p = d.properties; return p.department || p.NOMBDEP || p.NOMB_DEP || p.name || "Department"; }); // District polygons only where 3G shutdown / 4G upgrade data exists g.append("g") .selectAll("path") .data(affectedDistricts) .join("path") .attr("d", path) .attr("fill", d => color(d.properties.delta_4g_download_mbps)) .attr("fill-opacity", 0.72) .attr("stroke", "#ffffff") .attr("stroke-width", 0.8) .append("title") .text(d => { const p = d.properties; return `${p.district}, ${p.province}, ${p.department} UBIGEO: ${p.ubigeo} 3G shutdown month: ${p.breakpoint_yearmonth} 4G download upgrade: ${p.delta_4g_download_mbps?.toFixed(2)} Mbps 4G latency change: ${p.delta_4g_latency_ms?.toFixed(1)} ms Composite upgrade score: ${p.composite_upgrade_score?.toFixed(3)}`; }); // Bubbles over affected districts g.append("g") .selectAll("circle") .data(affectedDistricts) .join("circle") .attr("transform", d => `translate(${path.centroid(d)})`) .attr("r", d => radius(Math.abs(d.properties.delta_4g_download_mbps))) .attr("fill", d => color(d.properties.delta_4g_download_mbps)) .attr("fill-opacity", 0.58) .attr("stroke", "#111827") .attr("stroke-opacity", 0.55) .attr("stroke-width", 0.8) .append("title") .text(d => { const p = d.properties; return `${p.district}, ${p.province}, ${p.department} 4G download upgrade: ${p.delta_4g_download_mbps?.toFixed(2)} Mbps`; }); // Title svg.append("text") .attr("x", 24) .attr("y", 34) .attr("font-size", 18) .attr("font-weight", 700) .attr("fill", "#111827") .text("4G download upgrade after Movistar’s 3G shutdown"); // Bubble size legend const legend = svg.append("g") .attr("transform", `translate(24, ${H - 110})`); legend.append("text") .attr("x", 0) .attr("y", -14) .attr("font-weight", 700) .attr("font-size", 12) .attr("fill", "#111827") .text("Bubble size: |4G download upgrade|"); const legendValues = [1, 3, 5].filter(d => d <= maxAbs * 1.15); legend.selectAll("circle") .data(legendValues) .join("circle") .attr("cx", (d, i) => i * 82 + 18) .attr("cy", 24) .attr("r", d => radius(d)) .attr("fill", "#94a3b8") .attr("fill-opacity", 0.35) .attr("stroke", "#334155"); legend.selectAll("text.value") .data(legendValues) .join("text") .attr("class", "value") .attr("x", (d, i) => i * 82 + 18) .attr("y", 62) .attr("text-anchor", "middle") .attr("font-size", 11) .attr("fill", "#475569") .text(d => `${d} Mbps`); // Color legend const colorLegend = svg.append("g") .attr("transform", `translate(${Math.max(24, W - 270)}, ${H - 92})`); colorLegend.append("text") .attr("x", 0) .attr("y", -12) .attr("font-weight", 700) .attr("font-size", 12) .attr("fill", "#111827") .text("Color: 4G download change"); const gradientId = "download-upgrade-gradient"; const defs = svg.append("defs"); const gradient = defs.append("linearGradient") .attr("id", gradientId) .attr("x1", "0%") .attr("x2", "100%"); d3.range(0, 1.01, 0.1).forEach(t => { gradient.append("stop") .attr("offset", `${t * 100}%`) .attr("stop-color", color(-maxAbs + t * 2 * maxAbs)); }); colorLegend.append("rect") .attr("width", 220) .attr("height", 12) .attr("rx", 6) .attr("fill", `url(#${gradientId})`); colorLegend.append("text") .attr("x", 0) .attr("y", 32) .attr("font-size", 11) .attr("fill", "#475569") .text("Lower"); colorLegend.append("text") .attr("x", 110) .attr("y", 32) .attr("text-anchor", "middle") .attr("font-size", 11) .attr("fill", "#475569") .text("No change"); colorLegend.append("text") .attr("x", 220) .attr("y", 32) .attr("text-anchor", "end") .attr("font-size", 11) .attr("fill", "#475569") .text("Higher"); // More aggressive zoom const minZoom = 1; const maxZoom = 80; const bubbleShrinkFactor = 0.85; const minBubbleRadius = 0.7; const zoom = d3.zoom() .scaleExtent([minZoom, maxZoom]) .wheelDelta(event => -event.deltaY * 0.006) .on("start", () => { svg.attr("style", "max-width:100%;height:auto;background:#ffffff;cursor:grabbing;"); }) .on("zoom", event => { const k = event.transform.k; g.attr("transform", event.transform); // Keep bubbles readable but reduce overlap as zoom increases g.selectAll("circle") .attr("r", d => { const baseRadius = radius(Math.abs(d.properties.delta_4g_download_mbps)); return Math.max( minBubbleRadius, baseRadius / Math.pow(k, bubbleShrinkFactor) ); }) .attr("stroke-width", Math.max(0.15, 0.8 / k)); // Make district borders thinner while zooming g.selectAll("path") .attr("stroke-width", Math.max(0.08, 0.8 / k)); }) .on("end", () => { svg.attr("style", "max-width:100%;height:auto;background:#ffffff;cursor:grab;"); }); svg.call(zoom); return svg.node(); }33:Tbf8,d3Ranking = { const margin = {top: 28, right: 28, bottom: 46, left: 190}; const W = width; const H = 520; const data = topDownload.slice().sort((a, b) => d3.ascending(a.delta_4g_download_mbps, b.delta_4g_download_mbps)); const x = d3.scaleLinear() .domain([Math.min(0, d3.min(data, d => d.delta_4g_download_mbps)), d3.max(data, d => d.delta_4g_download_mbps)]) .nice() .range([margin.left, W - margin.right]); const y = d3.scaleBand() .domain(data.map(d => `${d.district}, ${d.province}`)) .range([H - margin.bottom, margin.top]) .padding(0.22); const color = d3.scaleOrdinal() .domain([...new Set(filteredSummary.map(d => d.department))].sort()) .range(d3.schemeTableau10); const svg = d3.create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .attr("style", "max-width:100%;height:auto;background:#ffffff;"); svg.append("g") .attr("transform", `translate(0,${H - margin.bottom})`) .call(d3.axisBottom(x).ticks(7)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", W - margin.right) .attr("y", 38) .attr("fill", "currentColor") .attr("text-anchor", "end") .text("4G download upgrade (Mbps)")); svg.append("g") .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(y).tickSizeOuter(0)) .call(g => g.select(".domain").remove()); svg.append("g") .attr("stroke", "#e5e7eb") .attr("stroke-opacity", 0.9) .selectAll("line") .data(x.ticks(7)) .join("line") .attr("x1", d => x(d)) .attr("x2", d => x(d)) .attr("y1", margin.top) .attr("y2", H - margin.bottom); svg.append("line") .attr("x1", x(0)) .attr("x2", x(0)) .attr("y1", margin.top) .attr("y2", H - margin.bottom) .attr("stroke", "#111827") .attr("stroke-width", 1); svg.append("g") .selectAll("rect") .data(data) .join("rect") .attr("x", d => x(Math.min(0, d.delta_4g_download_mbps))) .attr("y", d => y(`${d.district}, ${d.province}`)) .attr("width", d => Math.abs(x(d.delta_4g_download_mbps) - x(0))) .attr("height", y.bandwidth()) .attr("rx", 3) .attr("fill", d => color(d.department)) .append("title") .text(d => `${d.district}, ${d.province}, ${d.department} 4G download upgrade: ${d.delta_4g_download_mbps.toFixed(2)} Mbps 6-month pre-shutdown avg.: ${d.pre6_4g_download_mbps.toFixed(2)} Mbps 6-month post-shutdown avg.: ${d.post6_4g_download_mbps.toFixed(2)} Mbps 3G shutdown month: ${d.breakpoint_yearmonth}`); svg.append("g") .attr("font-size", 11) .attr("fill", "#111827") .selectAll("text") .data(data) .join("text") .attr("x", d => x(d.delta_4g_download_mbps) + (d.delta_4g_download_mbps >= 0 ? 5 : -5)) .attr("y", d => y(`${d.district}, ${d.province}`) + y.bandwidth() / 2) .attr("dy", "0.35em") .attr("text-anchor", d => d.delta_4g_download_mbps >= 0 ? "start" : "end") .text(d => d.delta_4g_download_mbps.toFixed(2)); return svg.node(); }34:Tb6b,d3BeforeAfter = { const margin = {top: 28, right: 28, bottom: 62, left: 72}; const W = width; const H = 620; const limit = Math.ceil(maxDownload + 1); const data = filteredSummary; const x = d3.scaleLinear().domain([0, limit]).nice().range([margin.left, W - margin.right]); const y = d3.scaleLinear().domain([0, limit]).nice().range([H - margin.bottom, margin.top]); const color = d3.scaleOrdinal() .domain([...new Set(data.map(d => d.department))].sort()) .range(d3.schemeTableau10); const r = d3.scaleSqrt() .domain([0, d3.max(data, d => d.post6_4g_download_measurements || 1)]) .range([3, 10]); const svg = d3.create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .attr("style", "max-width:100%;height:auto;background:#ffffff;"); svg.append("g") .attr("transform", `translate(0,${H - margin.bottom})`) .call(d3.axisBottom(x)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", W - margin.right) .attr("y", 44) .attr("fill", "currentColor") .attr("text-anchor", "end") .text("Before shutdown: average 4G download speed (Mbps)")); svg.append("g") .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(y)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", -margin.left + 4) .attr("y", margin.top - 12) .attr("fill", "currentColor") .attr("text-anchor", "start") .text("After shutdown: average 4G download speed (Mbps)")); svg.append("g") .attr("stroke", "#e5e7eb") .selectAll("line") .data(x.ticks()) .join("line") .attr("x1", d => x(d)) .attr("x2", d => x(d)) .attr("y1", margin.top) .attr("y2", H - margin.bottom); svg.append("g") .attr("stroke", "#e5e7eb") .selectAll("line") .data(y.ticks()) .join("line") .attr("x1", margin.left) .attr("x2", W - margin.right) .attr("y1", d => y(d)) .attr("y2", d => y(d)); svg.append("line") .attr("x1", x(0)) .attr("y1", y(0)) .attr("x2", x(limit)) .attr("y2", y(limit)) .attr("stroke", "#6b7280") .attr("stroke-dasharray", "5,5"); svg.append("g") .attr("fill-opacity", 0.78) .attr("stroke", "#ffffff") .attr("stroke-width", 0.8) .selectAll("circle") .data(data) .join("circle") .attr("cx", d => x(d.pre6_4g_download_mbps)) .attr("cy", d => y(d.post6_4g_download_mbps)) .attr("r", d => r(d.post6_4g_download_measurements || 1)) .attr("fill", d => color(d.department)) .append("title") .text(d => `${d.district}, ${d.province}, ${d.department} 6-month pre-shutdown 4G avg.: ${d.pre6_4g_download_mbps.toFixed(2)} Mbps 6-month post-shutdown 4G avg.: ${d.post6_4g_download_mbps.toFixed(2)} Mbps 4G download upgrade: ${d.delta_4g_download_mbps.toFixed(2)} Mbps`); return svg.node(); }35:T97b,d3DownloadLatency = { const margin = {top: 28, right: 28, bottom: 58, left: 76}; const W = width; const H = 560; const data = filteredSummary; const x = d3.scaleLinear() .domain(d3.extent(data, d => d.delta_4g_download_mbps)) .nice() .range([margin.left, W - margin.right]); const y = d3.scaleLinear() .domain(d3.extent(data, d => d.delta_4g_latency_ms)) .nice() .range([H - margin.bottom, margin.top]); const color = d3.scaleOrdinal() .domain([...new Set(data.map(d => d.department))].sort()) .range(d3.schemeTableau10); const svg = d3.create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .attr("style", "max-width:100%;height:auto;background:#ffffff;"); svg.append("g") .attr("transform", `translate(0,${H - margin.bottom})`) .call(d3.axisBottom(x)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", W - margin.right) .attr("y", 42) .attr("fill", "currentColor") .attr("text-anchor", "end") .text("4G download upgrade (Mbps)")); svg.append("g") .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(y)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", -margin.left + 4) .attr("y", margin.top - 12) .attr("fill", "currentColor") .attr("text-anchor", "start") .text("4G latency change (ms). Negative = improvement")); svg.append("line") .attr("x1", x(0)).attr("x2", x(0)) .attr("y1", margin.top).attr("y2", H - margin.bottom) .attr("stroke", "#9ca3af") .attr("stroke-dasharray", "4,4"); svg.append("line") .attr("x1", margin.left).attr("x2", W - margin.right) .attr("y1", y(0)).attr("y2", y(0)) .attr("stroke", "#9ca3af") .attr("stroke-dasharray", "4,4"); svg.append("g") .attr("fill-opacity", 0.78) .attr("stroke", "#ffffff") .attr("stroke-width", 0.8) .selectAll("circle") .data(data) .join("circle") .attr("cx", d => x(d.delta_4g_download_mbps)) .attr("cy", d => y(d.delta_4g_latency_ms)) .attr("r", 5) .attr("fill", d => color(d.department)) .append("title") .text(d => `${d.district}, ${d.province}, ${d.department} 4G download upgrade: ${d.delta_4g_download_mbps.toFixed(2)} Mbps 4G latency change: ${d.delta_4g_latency_ms.toFixed(1)} ms`); return svg.node(); }36:Tbbf,d3SelectedDownload = { const {margin, W, xDomain} = selectedTimeChart; const H = 460; const data = selectedSeries; const x = d3.scaleLinear() .domain(xDomain) .nice() .range([margin.left, W - margin.right]); const y = d3.scaleLinear() .domain([0, d3.max(data, d => Math.max( d.AVERAGE_THROUGHPUT_DOWNLOAD_4G ?? 0, d.AVERAGE_THROUGHPUT_DOWNLOAD_3G ?? 0 ))]) .nice() .range([H - margin.bottom, margin.top]); const svg = d3.create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .attr("style", "max-width:100%;height:auto;background:#ffffff;"); svg.append("g") .attr("transform", `translate(0,${H - margin.bottom})`) .call(d3.axisBottom(x)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", W - margin.right) .attr("y", 40) .attr("fill", "currentColor") .attr("text-anchor", "end") .text("Month relative to 3G shutdown")); svg.append("g") .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(y)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", -margin.left + 4) .attr("y", margin.top - 12) .attr("fill", "currentColor") .attr("text-anchor", "start") .text("Average download speed (Mbps)")); svg.append("line") .attr("x1", x(0)) .attr("x2", x(0)) .attr("y1", margin.top) .attr("y2", H - margin.bottom) .attr("stroke", "#b00020") .attr("stroke-width", 2); const series = [ {name: "4G", key: "AVERAGE_THROUGHPUT_DOWNLOAD_4G", color: "#2563eb", width: 2.4}, {name: "3G", key: "AVERAGE_THROUGHPUT_DOWNLOAD_3G", color: "#ef4444", width: 2.0} ]; for (const s of series) { svg.append("path") .datum(data) .attr("fill", "none") .attr("stroke", s.color) .attr("stroke-width", s.width) .attr("stroke-dasharray", s.name === "3G" ? "5,3" : null) .attr("d", d3.line() .defined(d => Number.isFinite(d[s.key])) .x(d => x(d.relative_month)) .y(d => y(d[s.key]))); svg.append("g") .attr("fill", s.color) .attr("stroke", "#ffffff") .attr("stroke-width", 1) .selectAll("circle") .data(data.filter(d => Number.isFinite(d[s.key]))) .join("circle") .attr("cx", d => x(d.relative_month)) .attr("cy", d => y(d[s.key])) .attr("r", s.name === "4G" ? 4 : 3.5) .append("title") .text(d => `Red: ${s.name} Mes: ${d.YEARMONTH} Mes relativo: ${d.relative_month} Descarga ${s.name}: ${d[s.key]?.toFixed(2)} Mbps`); } for (const s of series) { const last = data .filter(d => Number.isFinite(d[s.key])) .at(-1); if (!last) continue; svg.append("text") .attr("x", W - margin.right + 12) .attr("y", y(last[s.key])) .attr("dy", "0.35em") .attr("fill", s.color) .attr("font-size", 13) .attr("font-weight", 700) .text(s.name); } return svg.node(); }37:Ta35,d3SelectedNetworkTime = { const margin = {top: 28, right: 90, bottom: 54, left: 70}; const W = width; const H = 420; const data = selectedSeries; const x = d3.scaleLinear() .domain(d3.extent(data, d => d.relative_month)) .nice() .range([margin.left, W - margin.right]); const y = d3.scaleLinear() .domain([0, 100]) .range([H - margin.bottom, margin.top]); const series = [ {name: "3G", key: "TIME_PERCENTAGE_3G", color: "#ef4444"}, {name: "4G", key: "TIME_PERCENTAGE_4G", color: "#2563eb"} ]; const svg = d3.create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .attr("style", "max-width:100%;height:auto;background:#ffffff;"); svg.append("g") .attr("transform", `translate(0,${H - margin.bottom})`) .call(d3.axisBottom(x)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", W - margin.right) .attr("y", 40) .attr("fill", "currentColor") .attr("text-anchor", "end") .text("Month relative to 3G shutdown")); svg.append("g") .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(y).ticks(6).tickFormat(d => `${d}%`)) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", -margin.left + 4) .attr("y", margin.top - 12) .attr("fill", "currentColor") .attr("text-anchor", "start") .text("Time on network (%)")); svg.append("line") .attr("x1", x(0)) .attr("x2", x(0)) .attr("y1", margin.top) .attr("y2", H - margin.bottom) .attr("stroke", "#b00020") .attr("stroke-width", 2); for (const s of series) { svg.append("path") .datum(data) .attr("fill", "none") .attr("stroke", s.color) .attr("stroke-width", 2.2) .attr("d", d3.line() .x(d => x(d.relative_month)) .y(d => y(d[s.key]))); svg.append("text") .attr("x", W - margin.right + 12) .attr("y", y(data.at(-1)?.[s.key] ?? 0)) .attr("dy", "0.35em") .attr("fill", s.color) .attr("font-weight", 700) .text(s.name); } svg.append("g") .selectAll("circle") .data(data.flatMap(d => series.map(s => ({...d, network: s.name, key: s.key, color: s.color, value: d[s.key]})))) .join("circle") .attr("cx", d => x(d.relative_month)) .attr("cy", d => y(d.value)) .attr("r", 3) .attr("fill", d => d.color) .append("title") .text(d => `Red: ${d.network} Mes: ${d.YEARMONTH} Mes relativo: ${d.relative_month} Tiempo: ${d.value?.toFixed(1)}%`); return svg.node(); }38:Tf49,d3EventStudyHeatmap = { const margin = {top: 46, right: 110, bottom: 56, left: 210}; const W = width; const rowH = 18; const labels = eventDistricts.map(d => `${d.district}, ${d.province}`); const months = d3.range(-12, 13); const H = margin.top + margin.bottom + labels.length * rowH; const x = d3.scaleBand() .domain(months) .range([margin.left, W - margin.right]) .paddingInner(0.05); const y = d3.scaleBand() .domain(labels) .range([margin.top, H - margin.bottom]) .paddingInner(0.08); const maxAbs = d3.max(eventStudyData, d => Math.abs(d.value_vs_baseline)) || 1; const color = d3.scaleDiverging(d3.interpolateRdYlGn) .domain([-maxAbs, 0, maxAbs]); const svg = d3.create("svg") .attr("viewBox", [0, 0, W, H]) .attr("width", W) .attr("height", H) .attr("style", "max-width:100%;height:auto;background:#ffffff;"); svg.append("g") .attr("transform", `translate(0,${H - margin.bottom})`) .call(d3.axisBottom(x).tickValues(months.filter(d => d % 3 === 0))) .call(g => g.select(".domain").remove()) .call(g => g.append("text") .attr("x", W - margin.right) .attr("y", 38) .attr("fill", "currentColor") .attr("text-anchor", "end") .text("Month relative to 3G shutdown")); svg.append("g") .attr("transform", `translate(${margin.left},0)`) .call(d3.axisLeft(y).tickSizeOuter(0)) .call(g => g.select(".domain").remove()) .call(g => g.selectAll("text").attr("font-size", 10)); svg.append("line") .attr("x1", x(0) + x.bandwidth() / 2) .attr("x2", x(0) + x.bandwidth() / 2) .attr("y1", margin.top - 8) .attr("y2", H - margin.bottom) .attr("stroke", "#b00020") .attr("stroke-width", 2); svg.append("text") .attr("x", W / 2) .attr("y", 20) .attr("text-anchor", "middle") .attr("font-size", 16) .attr("font-weight", 700) .text("Temporal Impact of 850 MHz Refarming on 4G Download Speed"); svg.append("text") .attr("x", x(0) + x.bandwidth() / 2 + 5) .attr("y", margin.top - 5) .attr("fill", "#b00020") .attr("font-size", 11) .attr("font-weight", 700) .text("shutdown"); svg.append("g") .selectAll("rect") .data(eventStudyData) .join("rect") .attr("x", d => x(d.relative_month)) .attr("y", d => y(d.label)) .attr("width", x.bandwidth()) .attr("height", y.bandwidth()) .attr("fill", d => color(d.value_vs_baseline)) .append("title") .text(d => `${d.district}, ${d.province}, ${d.department} Mes: ${d.YEARMONTH} Mes relativo: ${d.relative_month} Descarga 4G: ${d.AVERAGE_THROUGHPUT_DOWNLOAD_4G?.toFixed(2)} Mbps Base pre6: ${d.baseline?.toFixed(2)} Mbps Diferencia vs base: ${d.value_vs_baseline?.toFixed(2)} Mbps Upgrade pre/post6: ${d.upgrade?.toFixed(2)} Mbps`); const legendH = 120; const legendY = d3.scaleLinear() .domain([-maxAbs, maxAbs]) .range([margin.top + legendH, margin.top]); const defs = svg.append("defs"); const gradient = defs.append("linearGradient") .attr("id", "event-heatmap-gradient") .attr("x1", "0%") .attr("x2", "0%") .attr("y1", "100%") .attr("y2", "0%"); d3.range(0, 1.01, 0.1).forEach(t => { const v = -maxAbs + t * 2 * maxAbs; gradient.append("stop") .attr("offset", `${t * 100}%`) .attr("stop-color", color(v)); }); svg.append("rect") .attr("x", W - margin.right + 34) .attr("y", margin.top) .attr("width", 14) .attr("height", legendH) .attr("fill", "url(#event-heatmap-gradient)"); svg.append("g") .attr("transform", `translate(${W - margin.right + 48},0)`) .call(d3.axisRight(legendY).ticks(5)) .call(g => g.select(".domain").remove()); svg.append("text") .attr("x", W - margin.right + 22) .attr("y", margin.top - 10) .attr("font-size", 11) .attr("font-weight", 700) .text("Mbps vs. baseline"); return svg.node(); }39:[{"id":"a633a8ca15fa9721c0983d2e8785a0f8d51ad1e08061daf86664bf51f48c065c2e4da5f8ff13b8aab8ac477de1bed0ddb4c00206293d885df26f9e4f20ab849d","href":"https://static.observableusercontent.com/files/a633a8ca15fa9721c0983d2e8785a0f8d51ad1e08061daf86664bf51f48c065c2e4da5f8ff13b8aab8ac477de1bed0ddb4c00206293d885df26f9e4f20ab849d","name":"observable_shutdown_timeseries.csv","type":"text/csv","lastModified":1782878965745.696,"size":526054},{"id":"a10af4c2da0bbeca41646fe9acd4d96fdfdaaf44104bf12d149c9020ec4d283308236922f89ab77dde09211be1e21bb3b0956f9bb371ac4e2202200165d9537d","href":"https://static.observableusercontent.com/files/a10af4c2da0bbeca41646fe9acd4d96fdfdaaf44104bf12d149c9020ec4d283308236922f89ab77dde09211be1e21bb3b0956f9bb371ac4e2202200165d9537d","name":"observable_4g_upgrade_districts.geojson","type":"application/geo+json","lastModified":1782878954226.921,"size":2524254},{"id":"5d305dd02a8d776d1bb19a425e435aeb131b6fffb26672b14259fcaa583653323d7d6ae3ac8344827ab9e2bbc664d9c6e1a28b176f61d80beed76341fdcc4408","href":"https://static.observableusercontent.com/files/5d305dd02a8d776d1bb19a425e435aeb131b6fffb26672b14259fcaa583653323d7d6ae3ac8344827ab9e2bbc664d9c6e1a28b176f61d80beed76341fdcc4408","name":"observable_4g_upgrade_summary_with_ubigeo.csv","type":"text/csv","lastModified":1782878957403.53,"size":37143},{"id":"c9b6e477a9c78b166b478d763ee40b3a005d121de76008b5ba710d7d3550b5f6a772d7054c7fd8cf3fd6957652e1f58b6cfbee28564b83a2460ec3a08649851b","href":"https://static.observableusercontent.com/files/c9b6e477a9c78b166b478d763ee40b3a005d121de76008b5ba710d7d3550b5f6a772d7054c7fd8cf3fd6957652e1f58b6cfbee28564b83a2460ec3a08649851b","name":"observable_all_districts_with_upgrade_simplified.geojson","type":"application/geo+json","lastModified":1782880209017.579,"size":1784471}] 2d:{"id":"027e1cf0182bcc1b","slug":"apagado-3g-latincom-2026","title":"Did Movistar's 3G Shutdown Improve 4G in Peru? — Frozen version (IEEE LATINCOM 2026)","thumbnail":"0cb08cbcc508c8dc23892bad792c7707eb9960690baf9c07b5908e1bee99804b","access_level":"public","create_time":"$D2026-09-27T16:20:05.593Z","update_time":"$D2026-09-27T16:50:35.434Z","view_time":null,"first_public_time":"$D2026-09-27T16:31:19.367Z","has_unpublished_edits":null,"fork":{"id":"42e2b1280524610e","slug":"apagado-3g-de-movistar-en-peru","title":"Did Movistar’s 3G Shutdown Improve 4G in Peru?","owner":{"id":"642f642bcad5a3a9","login":"leibnihtz","name":"Leibnihtz Ayamamani-Choque"}},"stars":0,"starred":false,"owner":{"type":"team","id":"642f642bcad5a3a9","login":"leibnihtz","name":"Leibnihtz Ayamamani-Choque","avatar_url":"https://avatars-next.observableusercontent.com/125816f99fb99b0465bc7e35145c7ddc337013fb60d918338c76b9c6bc40254d","tier":"starter_2024"},"version":651,"publish_version":651,"role":null,"authored":false,"authors":[{"type":"individual","id":"70eae1d3f6d99dd3","login":"leibnihtz","name":"Leibnihtz Ayamamani-Choque","avatar_url":"https://avatars-next.observableusercontent.com/125816f99fb99b0465bc7e35145c7ddc337013fb60d918338c76b9c6bc40254d","tier":null}],"members":[{"type":"team","id":"642f642bcad5a3a9","login":"leibnihtz","name":"Leibnihtz Ayamamani-Choque","avatar_url":"https://avatars-next.observableusercontent.com/125816f99fb99b0465bc7e35145c7ddc337013fb60d918338c76b9c6bc40254d","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Did Movistar's 3G Shutdown Improve 4G in Peru? — Frozen version (IEEE LATINCOM 2026)","cells":[{"id":0,"value":"$2f","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":576,"value":"## Data Pipeline and Reproducibility\n\nThis notebook is supported by an automated, serverless pipeline that collects public mobile internet quality data from OSIPTEL and transforms it into Observable-ready datasets.\n\nThe workflow runs monthly and keeps the live notebook updated. This frozen version reads the files of tag v1.2-camera-ready and does not change.\n\n **Repository**: github.com/leibnihtz/osiptel-apagado-3g","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":584,"value":"$30","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":581,"value":"Processed CSV and GeoJSON outputs are published through the project repository for transparency and reproducibility.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":601,"value":"## Analysis Scope\n\nThe following results focus on districts where a confirmed 3G shutdown event was detected and where enough post-shutdown data is available to compare 4G performance before and after the transition.\n\n### Main Metric\n\n${tex.block`\n4G\\ Download\\ Upgrade =\nAvg_{\\text{post 6m}}(Download_{4G})\n-\nAvg_{\\text{pre 6m}}(Download_{4G})\n`}\n\nA positive value means that average 4G download speed increased after the 3G shutdown.\n\nWindows use up to six months before and after the breakpoint; at least three valid post-shutdown months are required. The values shown here are crude before–after changes. The paper's matched difference-in-differences estimate, which subtracts the change in comparable districts where 3G remained active, is +0.65 Mbps.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":48,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":607,"value":"## Geographic Distribution of 3G Shutdown Events\n\nThe map shows where Movistar’s 3G shutdown was detected across Peru. Department borders provide geographic context, while bubbles represent affected districts with measurable 4G download changes after the shutdown.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":66,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":410,"value":"## Top Districts by 4G Download Upgrade\n\nWhere did Movistar’s 4G download speed improve the most after the 3G shutdown?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"## Before vs. After the 3G Shutdown\n\nDid 4G download speed improve after refarming?\n\nEach point represents a district with a confirmed 3G shutdown event. Points above the dashed line show districts where average 4G download speed increased after the shutdown, while points below the line indicate districts where the post-shutdown average was lower.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":82,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":553,"value":"md`\n> **RAN interpretation:** Refarming appears to improve 4G performance in many districts, but the effect is not homogeneous. A few districts do not show a positive post-shutdown change, which may be explained by local radio conditions, traffic load, site density, device mix, backhaul capacity, or optimization status.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":556,"value":"md`\n> \n>\n> `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"## 4G Download Upgrade vs. 4G Latency Change\n\nDo districts with higher 4G download gains also experience latency improvements?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":86,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"md`\nRAN interpretation: These results are consistent with an improvement in the 4G layer after the 3G shutdown. However, the chart does not prove causality by itself; traffic load, site density, backhaul capacity, device mix, and optimization status can also affect post-shutdown performance.\n> `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":421,"value":"## Monthly Trend in the Selected Shutdown District\n\n3G vs. 4G performance evolution over time\n\n> **Note:** Unlike the main impact metrics, this exploratory view includes every district with a detected 3G shutdown month. Some districts may have only one or a few months of post-shutdown data, so they are shown for temporal inspection but are not necessarily included in the 6-month before/after comparison.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":105,"value":"viewof selectedDepartment = Inputs.select(departmentOptions, {\n label: \"Department\",\n value: departmentOptions.includes(\"Cusco\") ? \"Cusco\" : departmentOptions[0]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"viewof selectedProvince = Inputs.select(provinceOptions, {\n label: \"Province\",\n value: provinceOptions.includes(\"Cusco\") ? \"Cusco\" : provinceOptions[0]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"viewof selectedDistrict = Inputs.select(districtOptions, {\n label: \"District\",\n value: \"San Jeronimo, Cusco, Cusco\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"html`

Current selection

${selectedDistrictLabel}

\n 3G shutdown month: ${selectedSummary?.breakpoint_yearmonth ?? \"n/a\"} -\n 4G download upgrade: ${selectedSummary?.delta_4g_download_mbps?.toFixed(2) ?? \"n/a\"} Mbps -\n 4G latency change: ${selectedSummary?.delta_4g_latency_ms?.toFixed(1) ?? \"n/a\"} ms\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"## Temporal Impact of the 3G Shutdown on 4G Download Speed\nThis heatmap compares each district’s monthly 4G download speed against its own 6-month pre-shutdown baseline.\n\nAfter the detected 3G shutdown month, many districts remain above their own pre-shutdown baseline for several months. In districts with nearly one year of post-shutdown data, the pattern is generally sustained, suggesting a lasting rather than temporary change.\n\nNote: this view compares each district with its own baseline and does not subtract the contemporaneous change in control districts; the control-adjusted estimates are reported in the paper.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":133,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"## Sources\n\n- **OSIPTEL – Checa tu Internet Móvil**: Monthly mobile quality-of-experience KPIs by district, operator, and technology.\n https://checatuinternetmovil.osiptel.gob.pe/\n\n- **INEI – Cartography:** district boundaries from the 2025 National Census (CPV 2025) and department boundaries from the 2023 Pre-census, used only for the map layer. Population and altitude (used in the paper's matching) come from the 2017 National Census.\n\n- **Project GitHub Repository**: Monthly pipeline, processing scripts, and CSV/GeoJSON files published for Observable.\n https://github.com/leibnihtz/osiptel-apagado-3g\n\n- Live Observable notebook (updated monthly; may differ from this frozen version): https://observablehq.com/@leibnihtz/apagado-3g-de-movistar-en-peru\n\nIn this frozen version, Observable reads the published files directly from the v1.2-camera-ready tag on GitHub.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":286,"value":"## Technical Appendix\n\nMuted JavaScript cells below contain the code used to load, process, and render the visualizations.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":487,"value":"viewof metric = Inputs.radio(\n [\"delta_4g_download_mbps\", \"composite_upgrade_score\", \"delta_4g_latency_ms\", \"delta_4g_time_pp\"],\n {\n label: \"Metrica del mapa\",\n value: \"delta_4g_download_mbps\",\n format: d => ({\n delta_4g_download_mbps: \"Upgrade descarga 4G\",\n composite_upgrade_score: \"Score integral\",\n delta_4g_latency_ms: \"Cambio latencia 4G\",\n delta_4g_time_pp: \"Cambio tiempo en 4G\"\n })[d]\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"d3 = require(\"d3@7\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"Inputs = require(\"@observablehq/inputs@0.10\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"repoBase = \"https://raw.githubusercontent.com/leibnihtz/osiptel-apagado-3g/v1.2-camera-ready/outputs/observable/data/\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"upgradeDistricts = d3.json(`${repoBase}/observable_4g_upgrade_districts.geojson`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"allDistricts = d3.json(`${repoBase}/observable_all_districts_with_upgrade_simplified.geojson`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"summary = d3.csv(`${repoBase}/observable_4g_upgrade_summary_with_ubigeo.csv`, d3.autoType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"timeseries = d3.csv(`${repoBase}/observable_shutdown_timeseries.csv`, d3.autoType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"metricKey = metric ?? \"delta_4g_download_mbps\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":362,"value":"metricInfo = ({\n delta_4g_download_mbps: {\n label: \"Upgrade descarga 4G (Mbps)\",\n scheme: \"RdYlGn\",\n reverse: false,\n format: d => `${d?.toFixed(2)} Mbps`\n },\n composite_upgrade_score: {\n label: \"Score integral de mejora\",\n scheme: \"RdYlGn\",\n reverse: false,\n format: d => d?.toFixed(3)\n },\n delta_4g_latency_ms: {\n label: \"Cambio latencia 4G (ms)\",\n scheme: \"RdYlGn\",\n reverse: true,\n format: d => `${d?.toFixed(1)} ms`\n },\n delta_4g_time_pp: {\n label: \"Cambio tiempo en 4G (p.p.)\",\n scheme: \"RdYlGn\",\n reverse: false,\n format: d => `${d?.toFixed(1)} p.p.`\n }\n})[metricKey] ?? {\n label: \"Upgrade descarga 4G (Mbps)\",\n scheme: \"RdYlGn\",\n reverse: false,\n format: d => `${d?.toFixed(2)} Mbps`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"filteredSummary = summary.filter(d => d.months_post >= 3)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"topDownload = filteredSummary\n .slice()\n .sort((a, b) => d3.descending(a.delta_4g_download_mbps, b.delta_4g_download_mbps))\n .slice(0, 15)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":372,"value":"selectorSummary = summary","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"departmentOptions = [...new Set(selectorSummary.map(d => d.department))].sort(d3.ascending)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":382,"value":"provinceOptions = [...new Set(\n selectorSummary\n .filter(d => d.department === selectedDepartment)\n .map(d => d.province)\n)].sort(d3.ascending)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"districtOptions = selectorSummary\n .filter(d => d.department === selectedDepartment && d.province === selectedProvince)\n .slice()\n .sort((a, b) => d3.ascending(a.district, b.district))\n .map(d => d.district)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"selectedSummary = selectorSummary.find(d =>\n d.department === selectedDepartment &&\n d.province === selectedProvince &&\n d.district === selectedDistrict\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":394,"value":"selectedSeries = timeseries\n .filter(d =>\n d.ADM_LEVEL_1_NAME === selectedDepartment &&\n d.ADM_LEVEL_2_NAME === selectedProvince &&\n d.ADM_LEVEL_3_NAME === selectedDistrict\n )\n .sort((a, b) => d3.ascending(a.relative_month, b.relative_month))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"selectedTimeChart = {\n const months = selectedSeries\n .map(d => d.relative_month)\n .filter(Number.isFinite);\n const [minMonth, maxMonth] = d3.extent(months);\n\n return {\n margin: {top: 28, right: 90, bottom: 54, left: 70},\n W: width,\n xDomain: [Math.min(minMonth ?? -1, 0), Math.max(maxMonth ?? 1, 0)]\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":398,"value":"selectedDistrictLabel = `${selectedDistrict}, ${selectedProvince}, ${selectedDepartment}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":442,"value":"eventDistricts = filteredSummary\n .slice()\n .sort((a, b) => d3.descending(a.delta_4g_download_mbps, b.delta_4g_download_mbps))\n .slice(0, eventTopN)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":446,"value":"eventStudyData = timeseries\n .filter(d => d.relative_month >= -12 && d.relative_month <= 12)\n .map(d => {\n const s = filteredSummary.find(x =>\n x.department === d.ADM_LEVEL_1_NAME &&\n x.province === d.ADM_LEVEL_2_NAME &&\n x.district === d.ADM_LEVEL_3_NAME\n );\n return s ? {\n ...d,\n label: `${d.ADM_LEVEL_3_NAME}, ${d.ADM_LEVEL_2_NAME}`,\n department: d.ADM_LEVEL_1_NAME,\n province: d.ADM_LEVEL_2_NAME,\n district: d.ADM_LEVEL_3_NAME,\n baseline: s.pre6_4g_download_mbps,\n upgrade: s.delta_4g_download_mbps,\n value_vs_baseline: d.AVERAGE_THROUGHPUT_DOWNLOAD_4G - s.pre6_4g_download_mbps\n } : null;\n })\n .filter(Boolean)\n .filter(d => eventDistricts.some(x =>\n x.department === d.department &&\n x.province === d.province &&\n x.district === d.district\n ))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"departments = d3.json(`${repoBase}/observable_departments_inei_2023_simplified.geojson`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"maxDownload = d3.max(filteredSummary, d => Math.max(d.pre6_4g_download_mbps, d.post6_4g_download_mbps))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":613,"value":"eventTopN = 40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W39","stdlib":"1","titling":"auto"}} 2e:"$2d:body"