45:["$","title",null,{"children":"Did Movistar’s 3G Shutdown Improve 4G in Peru? | Leibnihtz Ayamamani-Choque | Observable"}] 4d: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

4e: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}

`4f: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(); }50: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(); }51: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(); }52: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(); }53: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(); }54: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(); }55: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(); }56:[{"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":"a633a8ca15fa9721c0983d2e8785a0f8d51ad1e08061daf86664bf51f48c065c2e4da5f8ff13b8aab8ac477de1bed0ddb4c00206293d885df26f9e4f20ab849d","href":"https://static.observableusercontent.com/files/a633a8ca15fa9721c0983d2e8785a0f8d51ad1e08061daf86664bf51f48c065c2e4da5f8ff13b8aab8ac477de1bed0ddb4c00206293d885df26f9e4f20ab849d","name":"observable_shutdown_timeseries.csv","type":"text/csv","lastModified":1782878965745.696,"size":526054},{"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},{"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}] 49:{"id":"42e2b1280524610e","slug":"apagado-3g-de-movistar-en-peru","title":"Did Movistar’s 3G Shutdown Improve 4G in Peru?","thumbnail":"5b030515785e5f1cf674eaf5810565e382b8a400e2c9da03637281228471a919","access_level":"public","create_time":"$D2026-07-01T04:08:15.616Z","update_time":"$D2026-07-07T14:47:29.263Z","view_time":null,"first_public_time":"$D2026-07-01T04:08:15.616Z","has_unpublished_edits":null,"fork":false,"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","bio":"","followed_by_you":false,"follows_you":false},"version":623,"publish_version":null,"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,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"team","id":"642f642bcad5a3a9","login":"leibnihtz","name":"Leibnihtz Ayamamani-Choque","avatar_url":"https://avatars-next.observableusercontent.com/125816f99fb99b0465bc7e35145c7ddc337013fb60d918338c76b9c6bc40254d","tier":"starter_2024","role":"editor"},{"type":"individual","id":"70eae1d3f6d99dd3","login":"leibnihtz","name":"Leibnihtz Ayamamani-Choque","avatar_url":"https://avatars-next.observableusercontent.com/125816f99fb99b0465bc7e35145c7ddc337013fb60d918338c76b9c6bc40254d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Did Movistar’s 3G Shutdown Improve 4G in Peru?","cells":[{"id":0,"value":"# Did Movistar’s 3G Shutdown Improve 4G in Peru?\n## A Data-Driven Look at Network Refarming\n\nMobile operators around the world are retiring legacy 2G and 3G networks to free up spectrum for newer technologies. In Peru, Movistar appears to be the first operator with public evidence of a progressive 3G shutdown, mainly associated with **850 MHz spectrum refarming toward 4G.**\n\nThis notebook analyzes whether that transition produced visible improvements 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.\n\n **Data source:** OSIPTEL’s “Checa tu Internet Móvil” public portal\n\n\n \n \n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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, allowing the analysis to be updated as new OSIPTEL data becomes available.\n\n **Repository**: github.com/leibnihtz/osiptel-apagado-3g","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":584,"value":"$4d","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":48,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":66,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":82,"value":"$51","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":556,"value":"md`\n> \n>\n> `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":86,"value":"$52","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":561,"value":"md`\n> **RAN interpretation:** These results are consistent with the expected benefits of deploying or strengthening LTE 850 MHz after 3G refarming. 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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"md`\n> \n>\n> `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"$53","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"$54","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"## Temporal Impact of 3G Shutdown on 4G Performance\n\nThis heatmap compares each district’s monthly 4G download speed against its own 6-month pre-shutdown baseline.\n\nThe overall signal is clear: after the detected 3G shutdown month, many districts remain above their historical baseline for several months. In districts with nearly one year of post-shutdown data, the green pattern is generally sustained, suggesting a lasting 4G performance improvement rather than an isolated temporary effect.\n\n**Verdict:** the temporal evidence supports the hypothesis that 3G shutdown and 850 MHz refarming were followed by sustained 4G download improvements in many districts, although local network conditions may also influence the results.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":133,"value":"$55","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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 – 2025 CPV District Boundaries**: District-level geometry used for the geographic layer.\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- **Observable Notebook**: Interactive notebook used to visualize and explore the analysis. \n https://observablehq.com/@leibnihtz/apagado-3g-de-movistar-en-peru\n\nData is updated through GitHub Actions, and Observable reads the published files directly from GitHub raw URLs.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":201,"value":"d3 = require(\"d3@7\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"Inputs = require(\"@observablehq/inputs@0.10\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"repoBase = \"https://raw.githubusercontent.com/leibnihtz/osiptel-apagado-3g/main/outputs/observable/data\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"metricKey = metric ?? \"delta_4g_download_mbps\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":372,"value":"selectorSummary = summary","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":398,"value":"selectedDistrictLabel = `${selectedDistrict}, ${selectedProvince}, ${selectedDepartment}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":613,"value":"eventTopN = 40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W56","stdlib":"1"}} 44:null