2a:null 2b:["$","title",null,{"children":"Inversión pública subnacional en el Perú | Victor Fuentes | Observable"}] 31:T570,plot_ejec = Plot.plot({ style: "overflow: visible;", y: { percent: true, grid: true, label: "↑ Ejecución (%)", domain: [0, 100] }, x: { grid: true, label: "", domain: [2008, 2022] }, marks: [ // Plot.ruleY([1]), Plot.lineY( data .filter((d) => d.cat === tipo1 && d.anio < 2023) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), { x: "anio", y: "ejec", stroke: "siaf_nombre_largo", curve: "bump-x", strokeOpacity: 0.6 } ), Plot.dot( data .filter((d) => d.cat === tipo1 && d.anio < 2023) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), { x: "anio", y: "ejec", r: 4, title: (d) => `${d.siaf_nombre}, ${d.anio} \n ${(d.ejec*100).toFixed(1)}%`, fill: "siaf_nombre_largo", stroke: "white", fillOpacity: 0.6 } ), Plot.text( data .filter((d) => d.cat === tipo1 && d.anio < 2023) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), Plot.selectLast({ x: "anio", y: "ejec", z: "siaf_nombre_largo", text: "siaf_nombre_largo", textAnchor: "start", dx: 2 }) ) ] })32:T5c3,plot_pim = Plot.plot({ style: "overflow: visible;", y: { percent: false, grid: true, label: "↑ Presupuesto (S/ millones)" // domain: [0, 100] }, x: { grid: true, label: "", domain: [2008, 2022] }, marks: [ // Plot.ruleY([1]), Plot.lineY( data .filter((d) => d.cat === tipo1 && d.anio <= 2022) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), { x: "anio", y: (d) => (d.pim / 1000000), stroke: "siaf_nombre_largo", curve: "bump-x", strokeOpacity: 0.6 } ), Plot.dot( data .filter((d) => d.cat === tipo1 && d.anio <= 2022) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), { x: "anio", y: (d) => (d.pim / 1000000), r: 4, title: (d) => `${d.siaf_nombre}, ${d.anio} \n S/${(d.pim/1000000).toFixed(1)} millones`, fill: "siaf_nombre_largo", stroke: "white", fillOpacity: 0.6 } ), Plot.text( data .filter((d) => d.cat === tipo1 && d.anio <= 2022) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), Plot.selectLast({ x: "anio", y: (d) => (d.pim / 1000000), z: "siaf_nombre_largo", text: "siaf_nombre_largo", textAnchor: "start", dx: 2 }) ) ] })33:T5df,plot_devengado = Plot.plot({ style: "overflow: visible;", y: { percent: false, grid: true, label: "↑ Devengado (S/ millones)" // domain: [0, 100] }, x: { grid: true, label: "", domain: [2008, 2022] }, marks: [ // Plot.ruleY([1]), Plot.lineY( data .filter((d) => d.cat === tipo1 && d.anio <= 2022) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), { x: "anio", y: (d) => (d.devengado / 1000000), stroke: "siaf_nombre_largo", curve: "bump-x", strokeOpacity: 0.6 } ), Plot.dot( data .filter((d) => d.cat === tipo1 && d.anio <= 2022) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), { x: "anio", y: (d) => (d.devengado / 1000000), r: 4, title: (d) => `${d.siaf_nombre}, ${d.anio} \n S/${(d.devengado/1000000).toFixed(1)} millones`, fill: "siaf_nombre_largo", stroke: "white", fillOpacity: 0.6 } ), Plot.text( data .filter((d) => d.cat === tipo1 && d.anio <= 2022) .filter(function (d, i) { return select_geo.indexOf(d.siaf_id) >= 0; }), Plot.selectLast({ x: "anio", y: (d) => (d.devengado / 1000000), z: "siaf_nombre_largo", text: "siaf_nombre_largo", textAnchor: "start", dx: 2 }) ) ] })34:[] 2e:{"id":"4ef26bb83b698e23","slug":"inversion-publica-subnacional-peru","title":"Inversión pública subnacional en el Perú","thumbnail":"ae02c3f50b974cb25d4ff20b33aef06fe7c76d536050096a457ed4fdb56118ee","access_level":"public","create_time":"$D2023-02-01T02:49:39.419Z","update_time":"$D2023-04-08T20:28:44.050Z","view_time":null,"first_public_time":"$D2023-02-01T02:49:39.419Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"29a4dfa992066803","login":"vfuentesc","name":"Victor Fuentes","avatar_url":"https://avatars-next.observableusercontent.com/1d1eef43546c42d5f4083ce7815440acf431e2e8a9a8eaf7113fcde29e34826e","tier":"starter_2024"},"version":680,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7e69cc332aa690cb","login":"vfuentesc","name":"Victor Fuentes","avatar_url":"https://avatars-next.observableusercontent.com/ea82c90a64af21d1a51a98787faf2a737de8ac4d0a996468c8025a9adb671a2f","tier":null}],"members":[{"type":"individual","id":"7e69cc332aa690cb","login":"vfuentesc","name":"Victor Fuentes","avatar_url":"https://avatars-next.observableusercontent.com/ea82c90a64af21d1a51a98787faf2a737de8ac4d0a996468c8025a9adb671a2f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Inversión pública subnacional en el Perú","cells":[{"id":0,"value":"# Inversión pública subnacional en el Perú\n\nAnálisis de la ejecución de la inversión pública subnacional según municipalidades y gobiernos regionales. La información se actualiza el primer día de cada a partir de la información extraída del módulo de [Consulta Amigable](https://apps5.mineco.gob.pe/transparencia/Navegador/default.aspx) del gasto presupuesto de actualización diaria del [Ministerio de Economía y Finanzas](https://www.mef.gob.pe/es/?option=com_content&language=es-ES&Itemid=100944&lang=es-ES&view=article&id=504).","pinned":false,"hidden":false,"mode":"md"},{"id":289,"value":"

Información actualizada al cierre de febrero 2023.

","pinned":false,"hidden":false,"mode":"html"},{"id":381,"value":"---\n## Ranking de ${tipo===\"inversion\"?\"inversión pública\":\"gasto público total\"} subnacional, ${anio}","pinned":false,"hidden":false,"mode":"md"},{"id":73,"value":"viewof tipo = Inputs.radio(new Map([[\"Inversión pública\", \"inversion\"], [\"Gasto total\", \"total\"]]), {value: \"inversion\", label: \"Tipo de recursos\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":235,"value":"viewof nivel = Inputs.checkbox(\n new Map([\n [\"Gobierno Regionales\", \"R\"],\n [\"Municipalidades Distritales\", \"D\"],\n [\"Municipalidades Provinciales\", \"P\"]\n ]),\n { label: \"Tipos de instituciones\", value: [\"R\", \"D\", \"P\"] }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":219,"value":"viewof anio = Inputs.range([2008, 2023], {label: \"Año de análisis\", step: 1, value: 2023})","pinned":false,"hidden":false,"mode":"ojs"},{"id":169,"value":"viewof filtrado = Search(\n data\n .filter((d) => d.anio === anio && d.cat === tipo)\n .filter(function (d, i) {\n return nivel.indexOf(d.siaf_tipo) >= 0;\n }),\n {\n placeholder: \"Buscar por palabra clave\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":77,"value":"viewof resumen = Table(\n filtrado,\n {\n ejec: (d) => d.devengado / d.pim,\n columns: [\n \"geo_region\",\n \"geo_provincia\",\n \"siaf_nombre\",\n \"pim\",\n \"devengado\",\n \"ejec\"\n ],\n header: {\n geo_region: \"Región\",\n geo_provincia: \"Provincia\",\n siaf_nombre: \"Institución\",\n devengado: \"Devengado (S/)\",\n pim: \"PIM (S/)\",\n ejec: \"Ejecución\"\n },\n // width: {geo_region: 100, geo_provincia: 100, siaf_nombre: 150, pim: 100, devengado: 100, ejec: 100},\n layout: \"fixed\",\n rows: 10,\n sort: \"pim\",\n reverse: true,\n multiple: false,\n format: {\n // ejec: d3.format(\".1%\"),\n pim: pe_locale.format(\",\"),\n devengado: pe_locale.format(\",\"),\n ejec: sparkbar(1)\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":402,"value":"---\n## Evolución de la ejecución de${tipo1===\"inversion\"?\" la inversión pública\":\"l gasto público total\"} subnacional, 2008-2022","pinned":false,"hidden":false,"mode":"md"},{"id":376,"value":"viewof tipo1 = Inputs.radio(new Map([[\"Inversión pública\", \"inversion\"], [\"Gasto total\", \"total\"]]), {value: \"inversion\", label: \"Tipo de recursos\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":54,"value":"viewof select_geo = yamultiselect(geo_siaf_map, {\n label: \"Municipalidad o Gobierno Regional\",\n width: 320,\n value: [getRandomItem(geo_siaf_map)[1], getRandomItem(geo_siaf_map)[1]],\n placeholder: \"Buscar...\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":60,"value":"random = Inputs.button(\"Escoge aleatoriamente\", {\n reduce: () => {\n viewof select_geo.value = [getRandomItem(geo_siaf_map)[1], getRandomItem(geo_siaf_map)[1]];\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":304,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":454,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":467,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":416,"value":"

Fuente: INEI. Actualizado al 2022/02/01

","pinned":false,"hidden":false,"mode":"html"},{"id":4,"value":"import { yamultiselect } from \"@saneef/yet-another-multi-select\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"import { join } from \"@dakoop/combining-data-learn-js-data\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":173,"value":"import {Search, Table} from \"@observablehq/inputs\"\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":126,"value":"pe_ES = ({\n decimal: \".\",\n thousands: \",\",\n grouping: [3],\n currency: [\"S/ \", \"\"],\n dateTime: \"%a %b %e %X %Y\",\n date: \"%d/%m/%Y\",\n time: \"%H:%M:%S\",\n periods: [\"AM\", \"PM\"],\n days: [\n \"Domingo\",\n \"Lunes\",\n \"Martes\",\n \"Miércoles\",\n \"Jueves\",\n \"Viernes\",\n \"Sábado\"\n ],\n shortDays: [\"Dom\", \"Lun\", \"Mar\", \"Mi\", \"Jue\", \"Vie\", \"Sab\"],\n months: [\n \"Enero\",\n \"Febrero\",\n \"Marzo\",\n \"Abril\",\n \"Mayo\",\n \"Junio\",\n \"Julio\",\n \"Agosto\",\n \"Septiembre\",\n \"Octubre\",\n \"Noviembre\",\n \"Diciembre\"\n ],\n shortMonths: [\n \"Ene\",\n \"Feb\",\n \"Mar\",\n \"Abr\",\n \"May\",\n \"Jun\",\n \"Jul\",\n \"Ago\",\n \"Sep\",\n \"Oct\",\n \"Nov\",\n \"Dic\"\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":129,"value":"pe_locale = d3.formatLocale(pe_ES)","pinned":false,"hidden":false,"mode":"ojs"},{"id":389,"value":"pe_locale_time= d3.timeFormatLocale(pe_ES)","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"getRandomItem = (set) => [...set][Math.floor(Math.random() * set.size)]","pinned":false,"hidden":false,"mode":"ojs"},{"id":83,"value":"color = d3\n .scaleLinear()\n .domain([0, 0.5, 1])\n .range([\"#8e063b\", \"#dedbd3\", \"#023fa5\"])","pinned":false,"hidden":false,"mode":"ojs"},{"id":182,"value":"function sparkbar(max) {\n return (x) => htl.html`

${(x*100).toFixed(1)}%`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":489,"value":"siaf_db = d3.csv(\n \"https://raw.githubusercontent.com/vfuentesc/IPE_DataViz/main/Inversion/siaf_2008_2023.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":30,"value":"geo_db = d3.csv(\n \"https://raw.githubusercontent.com/vfuentesc/IPE_DataViz/main/Inversion/geo_siaf.csv\",\n d3.autoType\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":37,"value":"data = join(geo_db, siaf_db, \"siaf_id\", \"siaf_id\", function (main, sec) {\n return {\n anio: main.anio,\n cat: main.cat,\n siaf_id: main.siaf_id,\n pia: main.pia,\n pim: main.pim,\n devengado: main.devengado,\n geo_id: sec !== undefined ? sec.geo_id : null,\n geo_idx: sec !== undefined ? sec.geo_idx : null,\n geo_tipo: sec !== undefined ? sec.geo_tipo : null,\n geo_region: sec !== undefined ? sec.geo_region : null,\n geo_provincia: sec !== undefined ? sec.geo_provincia : null,\n geo_nombre: sec !== undefined ? sec.geo_nombre : null,\n siaf_tipo: sec !== undefined ? sec.siaf_tipo : null,\n siaf_nombre: sec !== undefined ? sec.siaf_nombre : null,\n siaf_nombre_largo: sec !== undefined ? sec.siaf_nombre_largo : null\n };\n})\n.sort(function (a, b) {return a.geo_idx - b.geo_idx})\n.map(d => ({...d, ejec: d.devengado/d.pim}) )","pinned":false,"hidden":false,"mode":"ojs"},{"id":630,"value":"region_anio = d3.rollup(\n data,\n (v) => d3.sum(v, (d) => d.pim),\n (d) => d.geo_region,\n (d) => d.anio\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":41,"value":"geo_siaf_array = d3\n .groups(data, (d) => d.siaf_nombre_largo)\n .map(([siaf_nombre_largo, siaf_id]) => ({\n siaf_nombre_largo,\n siaf_id: d3.map(siaf_id, (d) => d.siaf_id)[0],\n geo_idx: d3.map(siaf_id, (d) => d.geo_idx)[0]\n }))\n // .sort(function (a, b) {return a.geo_idx - b.geo_idx})","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"geo_siaf_map = new Map(geo_siaf_array.map((d) => [d.siaf_nombre_largo, d.siaf_id, d.geo_idx])\n)","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}} 2f:"$2e:body"