2b:null 2c:["$","title",null,{"children":"Tax Expenditures 2023 | José M. Zavala González | Observable"}] 31:Ta93,grafica_01 = {let theplot = Plot.plot({ // width: 928, height: 600, marginBottom: 35, // caption: 'Fuente: Espacios Abiertos sobre la base del Departamento de Hacienda', // x: {tickFormat: "", label: 'Año'}, // y: {label: 'Número de gastos fiscales'}, z: { domain: ['With Estimates', 'Without Estimates', 'Not claimed', 'Repealed' ],}, color: {legend: true, label: "Age (years)", tickFormat: d => grafica_01_labels[d] ?? d, range: ['INDIGO', 'PINK', 'RED', 'PURPLE'].map(d => EA_COLORES_MAP[d]), // range: ['#EDEDED','#C9C9C9','#787878','#525252'], // fontFamily: 'jaf-bernino-sans', // TODO: Cambiar a bernino regular, NO tabular porque son palabras // reverse: true, domain: ['Repealed','Not claimed','Without Estimates', 'With Estimates', ], }, marks: [ Plot.axisX({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: '', // label: 'Año', label: null, tickSize: 0, fontSize: 12, }), Plot.axisY({ // label: 'Cantidad', label: null, fontSize: 12, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', tickSize: 0 }), Plot.barY(gastos_clasificados_segun_reportados, { x: "year", y: "amount", fill: "clasificacion", order: '-sum', opacity: d => { let theopacs = { 'With Estimates': 0.85, 'Not claimed': 0.90, } return theopacs[d.clasificacion] ?? 1.0 }, // z: 'clasificacion', // channels: {'z': 'clasificacion'}, // sort: {y: "-y", reverse: true} }), Plot.textY(gastos_clasificados_segun_reportados, Plot.stackY({ filter: d => d.amount > 10, x: "year", y: 'amount', z: 'clasificacion', fontSize: 14.5, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', fill: d => d.amount > 130 ? 'white': 'black', text: 'amount', order: '-sum', })), // Plot.arrow([2020,2021,2022,2023,2024,2025,2026 ], { // x1: d => d, // x2: d => d, // y1: d => 415, // y2: d => 410, // // text: d => '4', // // fontSize: 12, // // fontVariant: 'tabular-nums', // // fontFamily: 'jaf-bernino-sans', // // fontWeight: 'bold', // }), Plot.text([2020,2021,2022,2023,2024,2025,2026 ], { x: d => d, y: d => 417, text: d => '4', fontSize: 14.5, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', }), ] }) add_estilos(theplot, 'thefirstone') return theplot }32:Ta3e,Plot.plot({ // width: 928, height: 600, marginBottom: 35, // caption: 'Fuente: Espacios Abiertos sobre la base del Departamento de Hacienda', // x: {tickFormat: "", label: 'Año'}, // y: {label: 'Número de gastos fiscales'}, z: { domain: ['With Estimates', 'Without Estimates', 'Not claimed', 'Repealed' ],}, color: {legend: true, label: "Age (years)", tickFormat: d => grafica_01_labels[d] ?? d, // range: ['INDIGO', 'PINK', 'RED', 'PURPLE'].map(d => EA_COLORES_MAP[d]), range: ['#EDEDED','#C9C9C9','#787878','#525252'], // fontFamily: 'jaf-bernino-sans', // TODO: Cambiar a bernino regular, NO tabular porque son palabras // reverse: true, domain: ['Repealed','Not claimed','Without Estimates', 'With Estimates', ], }, marks: [ Plot.axisX({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: '', // label: 'Año', label: null, tickSize: 0, fontSize: 12, }), Plot.axisY({ // label: 'Cantidad', label: null, fontSize: 12, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', tickSize: 0 }), Plot.barY(gastos_clasificados_segun_reportados, { x: "year", y: "amount", fill: "clasificacion", order: '-sum', opacity: d => { let theopacs = { 'With Estimates': 0.85, 'Not claimed': 0.90, } return theopacs[d.clasificacion] ?? 1.0 }, // z: 'clasificacion', // channels: {'z': 'clasificacion'}, // sort: {y: "-y", reverse: true} }), Plot.textY(gastos_clasificados_segun_reportados, Plot.stackY({ filter: d => d.amount > 10, x: "year", y: 'amount', z: 'clasificacion', fontSize: 14.5, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', fill: d => d.amount > 130 ? 'white': 'black', text: 'amount', order: '-sum', })), // Plot.arrow([2020,2021,2022,2023,2024,2025,2026 ], { // x1: d => d, // x2: d => d, // y1: d => 415, // y2: d => 410, // // text: d => '4', // // fontSize: 12, // // fontVariant: 'tabular-nums', // // fontFamily: 'jaf-bernino-sans', // // fontWeight: 'bold', // }), Plot.text([2020,2021,2022,2023,2024,2025,2026 ], { x: d => d, y: d => 417, text: d => '4', fontSize: 14.5, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', }), ] })33:T8fd,grafica_02 = { let theplot = Plot.plot({ marginLeft: 150, marginRight: 50, marginBottom: 50, height: 900, x: {percent: true,}, marks: [ Plot.barX(gastos_tributarios_identificados, { x: 'Porciento de gastos tributarios identificados con estimados', y: "País", // fill: d => d['País'] === 'Puerto Rico (2023)' ? EA_COLORES_MAP['DARK GREY'] : '#dddddd' , fill: d => d['País'] === 'Puerto Rico (2023)' ? EA_COLORES_MAP['INDIGO'] : chroma(EA_COLORES_MAP['INDIGO']).alpha(0.35).hex() , // opacity: d => d['País'] === 'Puerto Rico (2023' sort: {y: "x", reverse: true}}), Plot.ruleX([.7585]), Plot.axisY({ fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, }), Plot.axisX({ fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, }), Plot.text(gastos_tributarios_identificados, { filter: d => d['País'] !== 'Puerto Rico (2023)', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', // fontWeight: 'bold', fontSize: 14.5, x: 'Porciento de gastos tributarios identificados con estimados', y: "País", fill: 'black', text: d => d3.format('.1%')(d['Porciento de gastos tributarios identificados con estimados']), dx: -5, textAnchor: 'end', sort: {y: "x", reverse: true}}), Plot.text(gastos_tributarios_identificados, { filter: d => d['País'] === 'Puerto Rico (2023)', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, x: 'Porciento de gastos tributarios identificados con estimados', y: "País", fill: 'white', text: d => d3.format('.1%')(d['Porciento de gastos tributarios identificados con estimados']), dx: -5, textAnchor: 'end', sort: {y: "x", reverse: true}}), Plot.ruleX([0]), Plot.text([0], { x: .77, y: d => 'Grecia (2020)', text: d => 'Promedio mundial\nGTED,\n75.85%', textAnchor: 'start', lineAnchor: 'top', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', fontSize: 13, }), ] }) console.log('ugh', theplot) add_estilos(theplot, 'somebar') return theplot }34:Tf0a,grafica_1 = { let eje_y_traduccion = { "Nueva Zelanda (2021)": "New Zealand (2021)", "Grecia (2020)": "Greece (2020)", "Polonia (2018)": "Poland (2018)", "Reino Unido (2021)": "Unaited Kingdom (2021)", "Suiza (2011)": "Switzerland (2011)", "Alemania (2022)": "Germany (2022)", "Australia (2021)": "Australia (2021)", "Canadá (2022)": "Canada (2022)", "Suecia (2021)": "Sweden (2021)", "Italia (2022)": "Italy (2022)", "Finlandia (2022)": "Finland (2022)", "Puerto Rico (2023)": "Puerto Rico (2023)", "Francia (2021)": "France (2021)", "Austria (2021)": "Austria (2021)", "Israel (2022)": "Israel (2022)", "Irlanda (2021)": "Ireland (2021)", "Chile (2021)": "Chile (2021)", "Bélgica (2020)": "Belgium (2020)", "Argentina (2021)": "Argentina (2021)", "Corea del Sur (2020)": "South Korea (2020)", "México (2022)": "Mexico (2022)", "Turquía (2020)": "Turkey (2020)", "Brasil (2020)": "Brazil (2020)", "Dinamarca (2020)": "Dinmark (2020)", "Estonia (2021)": "Estonia (2021)", "Hungría (2022)": "Hungary (2022)", "India (2022)": "India (2022)", "Letonia (2021)": "Latvia (2021)", "Países Bajos (2022)": "Netherlands (2022)", "Noruega (2022)": "Norway (2022)", "República Eslovaca (2021)": "Sloval Republic (2021)", "Sudáfrica (2020)": "South Africa (2020)", "España (2022)": "Spain (2022)", "Estados Unidos (2022)": "United States (2022)" } let theplot = Plot.plot({ marginLeft: 150, marginRight: 50, marginBottom: 50, height: 900, x: {percent: true,}, marks: [ Plot.barX(gastos_tributarios_identificados, { x: 'Porciento de gastos tributarios identificados con estimados', y: "País", // fill: d => d['País'] === 'Puerto Rico (2023)' ? EA_COLORES_MAP['DARK GREY'] : '#dddddd' , fill: d => d['País'] === 'Puerto Rico (2023)' ? EA_COLORES_MAP['INDIGO'] : chroma(EA_COLORES_MAP['INDIGO']).alpha(0.35).hex() , // opacity: d => d['País'] === 'Puerto Rico (2023' sort: {y: "x", reverse: true}}), Plot.ruleX([.7585]), Plot.axisY({ tickFormat: d => eje_y_traduccion[d] ?? d, label: 'Country', fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, }), Plot.axisX({ label: 'Percentage of tax expenditures identified with estimates', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, }), Plot.text(gastos_tributarios_identificados, { filter: d => d['País'] !== 'Puerto Rico (2023)', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', // fontWeight: 'bold', fontSize: 14.5, x: 'Porciento de gastos tributarios identificados con estimados', y: "País", fill: 'black', text: d => d3.format('.1%')(d['Porciento de gastos tributarios identificados con estimados']), dx: -5, textAnchor: 'end', sort: {y: "x", reverse: true}}), Plot.text(gastos_tributarios_identificados, { filter: d => d['País'] === 'Puerto Rico (2023)', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, x: 'Porciento de gastos tributarios identificados con estimados', y: "País", fill: 'white', text: d => d3.format('.1%')(d['Porciento de gastos tributarios identificados con estimados']), dx: -5, textAnchor: 'end', sort: {y: "x", reverse: true}}), Plot.ruleX([0]), Plot.text([0], { x: .77, y: d => 'Grecia (2020)', text: d => 'Global average \nGTED,\n75.85%', textAnchor: 'start', lineAnchor: 'top', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', fontSize: 13, }), ] }) console.log('ugh', theplot) add_estilos(theplot, 'somebar') return theplot }35:Td02,grafica_03 = { let theplot = Plot.plot({ marginLeft: 60, width: 800, marginBottom: 35, caption: '*Datos de gastos tributarios proyectados por el Departamento de Hacienda', // fx: {paddingInner: '20'}, x: {axis: false, padding: 0}, color: {legend: true, range: ['INDIGO', 'GREEN'].map(d => EA_COLORES_MAP[d]), // range: ['#aaaaaa', '#cccccc'], }, marks: [ Plot.axisY({ // label: 'Total en millones de dolares', label: null, tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums ', fontSize: 12, }), Plot.axisFx({ tickFormat: d => d >= 2022 ? d.toString()+'*' : d.toString(), // label: 'Año', label: null, anchor: 'bottom', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, }), Plot.frame({ // fill: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), fill: chroma.mix('white',EA_COLORES_MAP['DARK GREY'], 0.15).hex(), stroke: null, inset: 0, }), Plot.barY(total_fondos, { fx: "year", x:"tipo_fondo", y: "amount", fill: "tipo_fondo", // inset: 10, }), // Plot.line(total_fondos, { // filter: d => d.year < 2025, // fx: "year", // x:"tipo_fondo", y: "amount", stroke: "black", // dy: -10, // curve: 'step-before', // // inset: 10, // }), Plot.arrow(total_fondos_wide, { filter: d => (d.year < 2026), //& (d.year !== 2022), fx: "year", x1: d => "Fondo General", x2: d => "Fondo General", y1: d => d['Fondo General']+.75e3, y2: 'Gastos Fiscales', strokeWidth: 1, // dy: 10, // text: d => '+'+d3.format(".0%")((d['Gastos Fiscales']-d['Fondo General'])/d['Fondo General']), // fill: 'black', // stroke: 'white', strokeWidth: 8, // fontSize: 12, // fontVariant: 'tabular-nums', // fontFamily: 'jaf-bernino-sans', // fontWeight: 'bold', }), Plot.text(total_fondos, { fx: "year", x:"tipo_fondo", y: "amount", dy: 10, rotate: -90, text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', fill: 'white', // stroke: 'white', strokeWidth: 8, fontSize: 14.5, fontWeight: 'bold', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', textAnchor: 'end', // fontWeight: 'bold', }), Plot.text(total_fondos_wide, { filter: d => (d.year < 2026), //& (d.year !== 2022), fx: "year", rotate: -90, x: d => "Fondo General", y: d => (d['Fondo General']+d['Gastos Fiscales'])/2, // dy: -10, text: d => '+'+d3.format(".0%")((d['Gastos Fiscales']-d['Fondo General'])/d['Fondo General']), fill: 'black', // stroke: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: chroma.mix('white',EA_COLORES_MAP['DARK GREY'], 0.15).hex(), strokeWidth: 10, fontSize: 12, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', // fontWeight: 'bold', }), // Plot.ruleY([0]) ] }) add_estilos(theplot) return theplot }36:Td9a,grafica_2 = { const leyenda_traduccion = { 'Fondo General' : 'General Fund', 'Gastos Fiscales' : 'Tax Expenditures' } let theplot = Plot.plot({ marginLeft: 60, width: 800, marginBottom: 35, caption: '*Tax expenditure data projected by the Department of the Treasury', // fx: {paddingInner: '20'}, x: {axis: false, padding: 0}, color: {legend: true, range: ['INDIGO', 'GREEN'].map(d => EA_COLORES_MAP[d]), tickFormat: d => leyenda_traduccion[d] ?? d, // range: ['#aaaaaa', '#cccccc'], }, marks: [ Plot.axisY({ // label: 'Total en millones de dolares', label: null, tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums ', fontSize: 12, }), Plot.axisFx({ tickFormat: d => d >= 2022 ? d.toString()+'*' : d.toString(), // label: 'Año', label: null, anchor: 'bottom', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, }), Plot.frame({ // fill: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), fill: chroma.mix('white',EA_COLORES_MAP['DARK GREY'], 0.15).hex(), stroke: null, inset: 0, }), Plot.barY(total_fondos, { fx: "year", x:"tipo_fondo", y: "amount", fill: "tipo_fondo", // inset: 10, }), // Plot.line(total_fondos, { // filter: d => d.year < 2025, // fx: "year", // x:"tipo_fondo", y: "amount", stroke: "black", // dy: -10, // curve: 'step-before', // // inset: 10, // }), Plot.arrow(total_fondos_wide, { filter: d => (d.year < 2026), //& (d.year !== 2022), fx: "year", x1: d => "Fondo General", x2: d => "Fondo General", y1: d => d['Fondo General']+.75e3, y2: 'Gastos Fiscales', strokeWidth: 1, // dy: 10, // text: d => '+'+d3.format(".0%")((d['Gastos Fiscales']-d['Fondo General'])/d['Fondo General']), // fill: 'black', // stroke: 'white', strokeWidth: 8, // fontSize: 12, // fontVariant: 'tabular-nums', // fontFamily: 'jaf-bernino-sans', // fontWeight: 'bold', }), Plot.text(total_fondos, { fx: "year", x:"tipo_fondo", y: "amount", dy: 10, rotate: -90, text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', fill: 'white', // stroke: 'white', strokeWidth: 8, fontSize: 14.5, fontWeight: 'bold', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', textAnchor: 'end', // fontWeight: 'bold', }), Plot.text(total_fondos_wide, { filter: d => (d.year < 2026), //& (d.year !== 2022), fx: "year", rotate: -90, x: d => "Fondo General", y: d => (d['Fondo General']+d['Gastos Fiscales'])/2, // dy: -10, text: d => '+'+d3.format(".0%")((d['Gastos Fiscales']-d['Fondo General'])/d['Fondo General']), fill: 'black', // stroke: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: chroma.mix('white',EA_COLORES_MAP['DARK GREY'], 0.15).hex(), strokeWidth: 10, fontSize: 12, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', // fontWeight: 'bold', }), // Plot.ruleY([0]) ] }) add_estilos(theplot) return theplot }37:Ta3c,grafica_04 = { let theplot = Plot.plot({ marginLeft: 62, marginBottom: 50, caption: '*Datos de gastos tributarios proyectados por el Departamento de Hacienda', width: 600, x: {axis: null, padding: 0,}, fx: {padding: 0.25}, color: {legend: true, // range: ['TANGERINE', 'LIGHT GREEN'].map(d => EA_COLORES_MAP[d]), // range: ['#aaaaaa', '#dddddd'], range: ['TANGERINE', 'BROWN', ].map(d => EA_COLORES_MAP[d]), }, marks: [ Plot.axisY({label: 'Total en millones de dolares', tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, label: null, }), Plot.axisFx({ // tickFormat: "", tickFormat: d => d >= 2022 ? d.toString()+'*' : d.toString(), // label: 'Año', label: null, anchor: 'bottom', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontSize: 12, }), Plot.frame({ fill: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: null, inset: 0, }), Plot.barY(ter24_by_desarrollo_economico, { fx: "year", x:"categoria_presupuestaria", y: "amount", fill: "categoria_presupuestaria", // inset: 10, // insetLeft: 5, insetRight: 5, }), // Plot.line(total_fondos, { // filter: d => d.year < 2025, // fx: "year", // x:"tipo_fondo", y: "amount", stroke: "black", // dy: -10, // curve: 'step-before', // // inset: 10, // }), Plot.text(ter24_by_desarrollo_economico, { fx: "year", x:"categoria_presupuestaria", y: "amount", dy: 7, rotate: -90, textAnchor: 'end', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', fill: 'white', // stroke: 'white', strokeWidth: 8, fontSize: 14.5, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', lineAnchor: 'middle', }), // Plot.text(total_fondos_wide, { // filter: d => (d.year < 2025) & (d.year !== 2022), // fx: "year", // x: d => "Fondo General", // y: d => (d['Fondo General']+d['Gastos Fiscales'])/2, // dy: -10, // text: d => '+'+d3.format(".0%")((d['Gastos Fiscales']-d['Fondo General'])/d['Fondo General']), // fill: 'black', stroke: 'white', // strokeWidth: 8, // fontSize: 12, // }), // Plot.ruleY([0]) ] }) add_estilos(theplot) return theplot }38:Tafe,grafica_3 = { const leyenda_traduccion = { 'Desarrollo económico' : 'Economic Development', 'Total de categorías remanentes' : 'Total of Remaining Categories' } let theplot = Plot.plot({ marginLeft: 62, marginBottom: 50, caption: '*Tax expenditure data projected by the Department of the Treasury', width: 600, x: {axis: null, padding: 0,}, fx: {padding: 0.25}, color: {legend: true, // range: ['TANGERINE', 'LIGHT GREEN'].map(d => EA_COLORES_MAP[d]), // range: ['#aaaaaa', '#dddddd'], range: ['TANGERINE', 'BROWN', ].map(d => EA_COLORES_MAP[d]), tickFormat: d => leyenda_traduccion[d] ?? d, }, marks: [ Plot.axisY({label: 'Total en millones de dolares', tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, label: null, }), Plot.axisFx({ // tickFormat: "", tickFormat: d => d >= 2022 ? d.toString()+'*' : d.toString(), // label: 'Año', label: null, anchor: 'bottom', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontSize: 12, }), Plot.frame({ fill: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: null, inset: 0, }), Plot.barY(ter24_by_desarrollo_economico, { fx: "year", x:"categoria_presupuestaria", y: "amount", fill: "categoria_presupuestaria", // inset: 10, // insetLeft: 5, insetRight: 5, }), // Plot.line(total_fondos, { // filter: d => d.year < 2025, // fx: "year", // x:"tipo_fondo", y: "amount", stroke: "black", // dy: -10, // curve: 'step-before', // // inset: 10, // }), Plot.text(ter24_by_desarrollo_economico, { fx: "year", x:"categoria_presupuestaria", y: "amount", dy: 7, rotate: -90, textAnchor: 'end', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', fill: 'white', // stroke: 'white', strokeWidth: 8, fontSize: 14.5, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', lineAnchor: 'middle', }), // Plot.text(total_fondos_wide, { // filter: d => (d.year < 2025) & (d.year !== 2022), // fx: "year", // x: d => "Fondo General", // y: d => (d['Fondo General']+d['Gastos Fiscales'])/2, // dy: -10, // text: d => '+'+d3.format(".0%")((d['Gastos Fiscales']-d['Fondo General'])/d['Fondo General']), // fill: 'black', stroke: 'white', // strokeWidth: 8, // fontSize: 12, // }), // Plot.ruleY([0]) ] }) add_estilos(theplot) return theplot }39:T7d2,grafica_05 = { let thedata = gastos_por_area_y_tipo.filter(d => d.year === 2021) let theplot = Plot.plot({ // width: 928, width: 800, height: 400, marginLeft: 160, // x: , y: { domain: [ 'Retiro', 'Desarrollo económico', 'Vivienda', 'Arte, Cultura, Recreación y Deportes', 'Negocios - Agricultura y Pesca', 'Salud', 'Ambiente', 'Educación', 'Familias y hogares', ], }, color: {legend: true, domain: ['indirecto', 'directo'], range: ['GREEN', 'INDIGO'].map(d => EA_COLORES_MAP[d]), // range: ['#dddddd', '#888888'], tickFormat: d => ({'indirecto': 'Gasto indirecto', 'directo': 'Gasto directo'})[d] ?? d, // reverse: true, // range: ['black', 'gray'], // domain: ['Arbitrios','Contribuciones Individuales','Contribuciones de corporaciones','Impuestos de Venta y Uso' ], }, marks: [ Plot.axisX({ label: null, tickFormat: "%", tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, }), Plot.axisY({ label: 'Área presupuestaria', tickFormat: d => area_label[d] ?? d, fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, }), Plot.barX(thedata, { y: "categoria_presupuestaria", x: "amount", z: 'tipo_gasto', order: '-z', fill: "tipo_gasto", offset: "normalize", }), Plot.textX(thedata, Plot.stackX({ x: "amount", y: 'categoria_presupuestaria', z: 'tipo_gasto', fill: d => ((d.tipo_gasto === 'directo') & (d.amount > 30)) ? 'white' : 'black', //strokeWidth: 5, text: d => d3.format('$,.0f')(d.amount)+'M', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', offset: 'normalize', order: '-z', })), ] }) add_estilos(theplot) return theplot }3a:T9c9,grafica_4 = { let thedata = gastos_por_area_y_tipo.filter(d => d.year === 2021) const eye_y_traduccion = { 'Retiro': 'Retirement', 'Negocios - Agricultura y Pesca': 'Agriculture and Fishing', 'Desarrollo económico' : 'Economic Development', 'Arte, Cultura, Recreación y Deportes': 'Arts, Culture,\nRecreation and Sports', 'Salud' : 'Healthcare', 'Ambiente' : 'Environment', 'Educación' : 'Education', 'Familias y hogares' : 'Families and Households', 'Vivienda' : 'Housing' } let theplot = Plot.plot({ // width: 928, width: 800, height: 400, marginLeft: 160, // x: , y: { domain: [ 'Retiro', 'Desarrollo económico', 'Vivienda', 'Arte, Cultura, Recreación y Deportes', 'Negocios - Agricultura y Pesca', 'Salud', 'Ambiente', 'Educación', 'Familias y hogares', ], }, color: {legend: true, domain: ['indirecto', 'directo'], range: ['GREEN', 'INDIGO'].map(d => EA_COLORES_MAP[d]), // range: ['#dddddd', '#888888'], tickFormat: d => ({'indirecto': 'Indirect expenditure', 'directo': 'Direct expenditure'})[d] ?? d, // reverse: true, // range: ['black', 'gray'], // domain: ['Arbitrios','Contribuciones Individuales','Contribuciones de corporaciones','Impuestos de Venta y Uso' ], }, marks: [ Plot.axisX({ label: null, tickFormat: "%", tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, }), Plot.axisY({ label: 'Budgetary Area', // tickFormat: d => area_label[d] ?? d, tickFormat: d => eye_y_traduccion[d] ?? d, fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, }), Plot.barX(thedata, { y: "categoria_presupuestaria", x: "amount", z: 'tipo_gasto', order: '-z', fill: "tipo_gasto", offset: "normalize", }), Plot.textX(thedata, Plot.stackX({ x: "amount", y: 'categoria_presupuestaria', z: 'tipo_gasto', fill: d => ((d.tipo_gasto === 'directo') & (d.amount > 30)) ? 'white' : 'black', //strokeWidth: 5, text: d => d3.format('$,.0f')(d.amount)+'M', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', offset: 'normalize', order: '-z', })), ] }) add_estilos(theplot) return theplot }3b:T9e6,grafica_06 = { let theplot = Plot.plot({ width: 1000, height: 775, marginLeft: 65, marginBottom: 35, caption: '*Datos de gastos tributarios proyectados por el Departamento de Hacienda', color: {legend: true, // domain: ['Arbitrios','Contribuciones Individuales','Contribuciones de corporaciones','Impuestos de Venta y Uso' ], // range: ['PURPLE', 'LIGHT GREEN', 'BLUE', 'RED'].map(d => EA_COLORES_MAP[d]), range: ['INDIGO', 'PINK', 'RED', 'PURPLE'].map(d => EA_COLORES_MAP[d]), // range: ['#111111', '#aaaaaa', '#888888', '#dddddd'], }, marks: [ Plot.axisX({ tickFormat: d => d >= 2022 ? d.toString()+'*' : d.toString(), // label: 'Año', label: null, tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, }), Plot.axisY({ // label: 'Total en millones de dólares', label: null, tickFormat: d => d3.format("$,.0f")(d)+'M', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, // axis: false, }), Plot.barY(gastos_por_fuente_tributaria, { x: "year", y: "amount", fill: "fuente_tributaria", fillOpacity: 1.0, order: '-sum', // sort: {y: "-y", reverse: true} }), Plot.textY(gastos_por_fuente_tributaria, Plot.stackY({ x: "year", y: 'amount', z: 'fuente_tributaria', fill: d => { if (d.fuente_tributaria === 'Arbitrios') return null; return ['Impuestos de Venta y Uso', 'Contribuciones Individuales', 'Arbitrios', 'Contribuciones de corporaciones'].includes(d.fuente_tributaria) ? 'black' : 'white'}, order: '-sum', // stroke: 'white', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', inset: 0.5 })), Plot.textY(gastos_por_fuente_tributaria, Plot.stackY({ x: "year", y: 'amount', z: 'fuente_tributaria', fill: d => d.fuente_tributaria === 'Arbitrios' ? 'black' : null, dy: -16, order: '-sum', // stroke: 'white', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', inset: 0.5 })), ] }) add_estilos(theplot) return theplot }3c:Tb15,grafica_5 = { const leyenda_traduccion = { 'Arbitrios' : 'Excise Taxes', 'Contribuciones Individuales' : 'Total of Remaining Categories', 'Contribuciones de corporaciones' : 'Corporate contributions', 'Impuestos de Venta y Uso': 'Sales and Use Taxes' } let theplot = Plot.plot({ width: 1000, height: 775, marginLeft: 65, marginBottom: 35, caption: '*Tax expenditure data projected by the Department of the Treasury', color: {legend: true, // domain: ['Arbitrios','Contribuciones Individuales','Contribuciones de corporaciones','Impuestos de Venta y Uso' ], // range: ['PURPLE', 'LIGHT GREEN', 'BLUE', 'RED'].map(d => EA_COLORES_MAP[d]), range: ['INDIGO', 'PINK', 'RED', 'PURPLE'].map(d => EA_COLORES_MAP[d]), // range: ['#111111', '#aaaaaa', '#888888', '#dddddd'], tickFormat: d => leyenda_traduccion[d] ?? d, }, marks: [ Plot.axisX({ tickFormat: d => d >= 2022 ? d.toString()+'*' : d.toString(), // label: 'Año', label: null, tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, }), Plot.axisY({ // label: 'Total en millones de dólares', label: null, tickFormat: d => d3.format("$,.0f")(d)+'M', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, // axis: false, }), Plot.barY(gastos_por_fuente_tributaria, { x: "year", y: "amount", fill: "fuente_tributaria", fillOpacity: 1.0, order: '-sum', // sort: {y: "-y", reverse: true} }), Plot.textY(gastos_por_fuente_tributaria, Plot.stackY({ x: "year", y: 'amount', z: 'fuente_tributaria', fill: d => { if (d.fuente_tributaria === 'Arbitrios') return null; return ['Impuestos de Venta y Uso', 'Contribuciones Individuales', 'Arbitrios', 'Contribuciones de corporaciones'].includes(d.fuente_tributaria) ? 'black' : 'white'}, order: '-sum', // stroke: 'white', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', inset: 0.5 })), Plot.textY(gastos_por_fuente_tributaria, Plot.stackY({ x: "year", y: 'amount', z: 'fuente_tributaria', fill: d => d.fuente_tributaria === 'Arbitrios' ? 'black' : null, dy: -16, order: '-sum', // stroke: 'white', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', inset: 0.5 })), ] }) add_estilos(theplot) return theplot }3d:T896,grafica_ = { let theplot = Plot.plot({ width: 1000, height: 775, marginLeft: 65, marginBottom: 35, color: {legend: true, // domain: ['Arbitrios','Contribuciones Individuales','Contribuciones de corporaciones','Impuestos de Venta y Uso' ], // range: ['PURPLE', 'LIGHT GREEN', 'BLUE', 'RED'].map(d => EA_COLORES_MAP[d]), range: ['#111111', '#aaaaaa', '#888888', '#dddddd'], }, marks: [ Plot.axisX({ tickFormat: "", // label: 'Año', label: null, tickSize: 0, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontSize: 12, }), Plot.axisY({ // label: 'Total en millones de dólares', label: null, tickFormat: d => d3.format("$,.0f")(d)+'M', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, // axis: false, }), Plot.barY(gastos_por_fuente_tributaria, { x: "year", y: "amount", fill: "fuente_tributaria", fillOpacity: 1.0, order: '-sum', // sort: {y: "-y", reverse: true} }), Plot.textY(gastos_por_fuente_tributaria, Plot.stackY({ x: "year", y: 'amount', z: 'fuente_tributaria', fill: d => ['Impuestos de Venta y Uso', 'Contribuciones Individuales', 'Arbitrios'].includes(d.fuente_tributaria) ? 'black' : 'white', order: '-sum', // stroke: 'white', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', inset: 0.5 })), Plot.textY(gastos_por_fuente_tributaria, Plot.stackY({ x: "year", y: 'amount', z: 'fuente_tributaria', fill: d => d.fuente_tributaria === 'Arbitrios' ? 'black' : null, dy: -16, order: '-sum', // stroke: 'white', fontSize: 14.5, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', text: d => (d.amount > 0) ? d3.format("$,.0f")(d.amount)+'M' : '', inset: 0.5 })), ] }) add_estilos(theplot) return theplot }3e:T47c,figura_1 = { let theplot = Plot.plot({ axis: false, width: 900, aspectRatio: 1, className: 'mapa', color: {legend: true, type: 'categorical', // range: ['BLUE', 'AQUA', 'GREEN'].map(d => EA_COLORES_MAP[d]), range: ["#5AB1F6", chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.5).hex(), "#8BCB8D"], // range: ['#777777', '#bbbbbb', '#eeeeee'], // type: 'sequential', interpolate: color_interp, tickFormat: "$,.0s" }, marks: [ Plot.geo(municipios_geojson, { fill: 'none', stroke: 'white', strokeWidth: 1.15, }), Plot.geo( municipios_with_analisis_preliminar, { fill: d => d.properties.analisis_preliminar[0].Detalle, stroke: 'white', strokeWidth: 1.15, }), Plot.text(municipios_with_analisis_preliminar.features, Plot.centroid({ text: (d) => (municipios_label_hack[d.properties.municipio] ?? d.properties.municipio).replaceAll(' ','\n'), // text: (d) => (d.properties.abreviaciones[0].ABR).replaceAll(' ','\n'), fill: "black", fontWeight: 'bold', fontSize: 9, })), ] }) add_estilos(theplot) return theplot }3f:T5a1,figura_ = { const leyenda_traduccion = { 'Información detallada disponible' : 'Detailed information available' , 'Información no disponible': 'No information available' , 'Información parcial disponible' : 'Partial information available' } let theplot = Plot.plot({ axis: false, width: 900, aspectRatio: 1, className: 'mapa', color: {legend: true, type: 'categorical', // range: ['BLUE', 'AQUA', 'GREEN'].map(d => EA_COLORES_MAP[d]), range: ["#5AB1F6", chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.5).hex(), "#8BCB8D"], // range: ['#777777', '#bbbbbb', '#eeeeee'], // type: 'sequential', interpolate: color_interp, tickFormat: "$,.0s" tickFormat: d => leyenda_traduccion[d] ?? d, }, marks: [ Plot.geo(municipios_geojson, { fill: 'none', stroke: 'white', strokeWidth: 1.15, }), Plot.geo( municipios_with_analisis_preliminar, { fill: d => d.properties.analisis_preliminar[0].Detalle, stroke: 'white', strokeWidth: 1.15, }), Plot.text(municipios_with_analisis_preliminar.features, Plot.centroid({ text: (d) => (municipios_label_hack[d.properties.municipio] ?? d.properties.municipio).replaceAll(' ','\n'), // text: (d) => (d.properties.abreviaciones[0].ABR).replaceAll(' ','\n'), fill: "black", fontWeight: 'bold', fontSize: 9, })), ] }) add_estilos(theplot) return theplot }40:T6e5,grafica_07 = { let theplot = Plot.plot({ // width, caption: '', width: 800, height: 223, marginLeft: 250, marginBottom: 50, // marginRight: 100, // x: {}, y: {domain: d3.sort(abatements_latest_by_type, d => -d.not_other, d => d.abatements).map(d => d['Type of Tax']), }, marks: [ Plot.axisX({ tickFormat: "$,.0s", fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, label: null, }), Plot.axisY({ tickFormat: d => type_tax_label[d] ?? d, fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, label: 'Tipo de impuesto' }), Plot.barX(abatements_latest_by_type, { x: "abatement", y: "Type of Tax", // sort: {y: "x", reverse: true}, fill: EA_COLORES_MAP['INDIGO'] }), Plot.text(abatements_latest_by_type, { filter: d => d.abatement > 2e6, x: "abatement", y: "Type of Tax", dx: -5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'end', // sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, fill: 'white', }), Plot.text(abatements_latest_by_type, { filter: d => d.abatement < 2e6, x: "abatement", y: "Type of Tax", dx: 5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'start', // sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, fill: 'black', }), Plot.ruleX([0]) ] }) add_estilos(theplot) return theplot }41:T719,grafica_7 = { let theplot = Plot.plot({ // width, caption: '', width: 800, height: 223, marginLeft: 250, marginBottom: 50, // marginRight: 100, // x: {}, y: {domain: d3.sort(abatements_latest_by_type, d => -d.not_other, d => d.abatements).map(d => d['Type of Tax']), }, marks: [ Plot.axisX({ tickFormat: "$,.0s", fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, label: null, }), Plot.axisY({ // tickFormat: d => type_tax_label[d] ?? d, tickFormat: d => d === 'Otros' ? 'Other' : d, fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, label: 'Type of Tax' }), Plot.barX(abatements_latest_by_type, { x: "abatement", y: "Type of Tax", // sort: {y: "x", reverse: true}, fill: EA_COLORES_MAP['INDIGO'] }), Plot.text(abatements_latest_by_type, { filter: d => d.abatement > 2e6, x: "abatement", y: "Type of Tax", dx: -5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'end', // sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, fill: 'white', }), Plot.text(abatements_latest_by_type, { filter: d => d.abatement < 2e6, x: "abatement", y: "Type of Tax", dx: 5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'start', // sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, fill: 'black', }), Plot.ruleX([0]) ] }) add_estilos(theplot) return theplot }42:T705,grafica_08 = { let theplot = Plot.plot({ // caption: 'Cambiar labels del Y-axis. ', marginTop: 50, marginLeft: 150, // marginRight: 80, marginBottom: 50, height: 175, // x: {}, // y: , marks: [ Plot.axisX({ tickFormat: '$,.0s', // label: 'Total de gastos tributarios en millones de dólares', label: null, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, }), Plot.axisY({ tickFormat: d => entidad_gobe_label[d] ?? d, fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, }), Plot.barX(abatements_latest_by_entidad, { x: "abatement", y: "Entidad Gubernamental", fill: EA_COLORES_MAP['INDIGO'], sort: {y: "x", reverse: true} }), Plot.text(abatements_latest_by_entidad, { filter: d => d['Entidad Gubernamental'] === 'Estatal', x: "abatement", y: "Entidad Gubernamental", dx: -5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'end', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, tickSize: 0, fill: 'white', // sort: {y: "x", reverse: true}, }), Plot.text(abatements_latest_by_entidad, { filter: d => d['Entidad Gubernamental'] !== 'Estatal', x: "abatement", y: "Entidad Gubernamental", dx: 5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'start', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, tickSize: 0, fill: 'black', // sort: {y: "x", reverse: true}, }), Plot.ruleX([0]) ] }) add_estilos(theplot) return theplot }43:T7d4,grafica_8 = { const eye_y_traducciones = { 'Estatal': 'Local Government', 'Gobierno Federal': 'Federal Government', // 'Municipal Ordinances': 'Gobierno Municipal', } let theplot = Plot.plot({ // caption: 'Cambiar labels del Y-axis. ', marginTop: 50, marginLeft: 150, // marginRight: 80, marginBottom: 50, height: 175, // x: {}, // y: , marks: [ Plot.axisX({ tickFormat: '$,.0s', // label: 'Total de gastos tributarios en millones de dólares', label: null, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, }), Plot.axisY({ tickFormat: d => eye_y_traducciones[d] ?? d, label: 'Government Entity', fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 12, }), Plot.barX(abatements_latest_by_entidad, { x: "abatement", y: "Entidad Gubernamental", fill: EA_COLORES_MAP['INDIGO'], sort: {y: "x", reverse: true} }), Plot.text(abatements_latest_by_entidad, { filter: d => d['Entidad Gubernamental'] === 'Estatal', x: "abatement", y: "Entidad Gubernamental", dx: -5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'end', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, tickSize: 0, fill: 'white', // sort: {y: "x", reverse: true}, }), Plot.text(abatements_latest_by_entidad, { filter: d => d['Entidad Gubernamental'] !== 'Estatal', x: "abatement", y: "Entidad Gubernamental", dx: 5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'start', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, tickSize: 0, fill: 'black', // sort: {y: "x", reverse: true}, }), Plot.ruleX([0]) ] }) add_estilos(theplot) return theplot }44:T5db,grafica_9 = { let thedata = abatements_latest_by_ley.filter(d => d.abatement > 1e6) let theplot = Plot.plot({ width: 900, height: 750, marginLeft: 230, marginRight: 100, marks: [ Plot.axisX({ label: null, tickFormat: "$,.0s", fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, ticks: 6, }), Plot.axisY({ tickFormat: d => ley_label[d] ?? d, fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 14, }), Plot.barX(thedata, { x: "abatement", y: "Ley", fill: EA_COLORES_MAP['INDIGO'], sort: {y: "x", reverse: true}, }), Plot.text(thedata, { filter: d => d.abatement > 20e6, x: "abatement", y: "Ley", dx: -5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'end', fill: 'white', sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, }), Plot.text(thedata, { filter: d => d.abatement < 20e6, x: "abatement", y: "Ley", dx: 5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'start', fill: 'black', sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, }), Plot.ruleX([0]) ] }) add_estilos(theplot) return theplot }45:Tacb,grafica_09 = { let thedata = abatements_latest_by_ley.filter(d => d.abatement > 1e6) const ley_traduccion = Object({ '135 of 1997': 'Act 135 of 1997', '159 of 2004': 'Act 159 of 2004' , '73 of 2008': 'Act 73 of 2008' , 'Municipal Ordinances' : 'Municipal Ordinances', "U.S. Custom and Border Protection Foreign Trade Zone Tax Incentives": 'U.S. Custom and Border Protection \nForeign Trade Zone Tax Incentives', "All": 'Municipalities report\n total laws as aggregate', "74 of 2010": 'Act 74 of 2010', "Estatal": 'Municipalities report only\n the total of state laws', "73 of 2008, 135 of 1998, 120 of 2014, 20 of 2012 ": 'Act 73 of 2008, 135 of 1998,\n120 of 2014, 20 of 2012', "168 of 1968": 'Act 168 of 1968', "225 of 1995" : 'Act 225 of 1995', "103 of 2000" : 'Act 103 of 2000', "1101 (a) (6) of the internal revenue code of Puerto Rico (Not for profit)" : 'State exemptions to\n nonprofit organizations', "52 of 1983, 78 of 2011" : 'Act 52 of 1983, 78 of 2011', "255 of 2002" : 'Act 255 of 2002', "83 of 2010": 'Act 83 of 2010', "225 of 2002": 'Act 225 of 2002', "73 of 2008, 135 of 2014, 20 of 2012, 8 of 1987" : 'Act 73 of 2008, 135 of 2014,\n 20 of 2012, 8 of 1987', "20 of 2012" : 'Act 20 of 2012' }) let theplot = Plot.plot({ width: 900, height: 750, marginLeft: 230, marginRight: 100, marks: [ Plot.axisX({ label: null, tickFormat: "$,.0s", fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 12, ticks: 6, }), Plot.axisY({ label: 'Act', tickFormat: d => ley_traduccion[d] ?? d, fontFamily: 'jaf-bernino-sans', tickSize: 0, fontSize: 14, }), Plot.barX(thedata, { x: "abatement", y: "Ley", fill: EA_COLORES_MAP['INDIGO'], sort: {y: "x", reverse: true}, }), Plot.text(thedata, { filter: d => d.abatement > 20e6, x: "abatement", y: "Ley", dx: -5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'end', fill: 'white', sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, }), Plot.text(thedata, { filter: d => d.abatement < 20e6, x: "abatement", y: "Ley", dx: 5, text: d => d3.format("$,.4s")(d['abatement']), textAnchor: 'start', fill: 'black', sort: {y: "x", reverse: true}, fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', fontWeight: 'bold', fontSize: 14.5, }), Plot.ruleX([0]) ] }) add_estilos(theplot) return theplot }46:T6dd,figura_2 = { let theplot = Plot.plot({ axis: false, width: 900, aspectRatio: 1, color: {legend: true, type: 'sequential', // interpolate: color_interp, interpolate: d3.interpolateHcl( chroma(EA_COLORES_MAP['INDIGO']).alpha(0.75).hex(), EA_COLORES_MAP['LIME']), tickFormat: "$,.0s", fontSize: 12, }, marks: [ Plot.geo(municipios_geojson, { fill: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.5).hex(), // stroke: 'black', stroke: 'white', strokeWidth: 1.15, }), Plot.geo(municipios_with_total_abatements, { fill: d => d.properties.total_abatement?.[0].abatement, stroke: 'white', strokeWidth: 1.15, }), // Plot.text(municipios_with_total_abatements.features, Plot.centroid({ // text: d => d.properties.total_abatement ? d3.format("$,.3s")(d.properties.total_abatement?.[0].abatement).slice(1) : null, // // text: d => d.properties.total_abatement ? d3.formatPrefix("$,.0s", 1e+6)(d.properties.total_abatement?.[0].abatement) : null, // fill: "black", // // stroke: "white", strokeWidth: .5, // fontSize: 11, // fontFamily: 'jaf-bernino-sans', // fontVariant: 'tabular-nums', // fontWeight: 'bold', // sort: d => d.properties.total_abatement?.[0].abatement // })), Plot.text(municipios_with_analisis_preliminar.features, Plot.centroid({ text: (d) => (municipios_label_hack[d.properties.municipio] ?? d.properties.municipio).replaceAll(' ','\n'), // text: (d) => (d.properties.abreviaciones[0].ABR).replaceAll(' ','\n'), fill: "black", fontWeight: 'bold', fontSize: 9, })), ] }) add_estilos(theplot) return theplot }47:Tf96,grafica_10 = { let theplot = Plot.plot({ // caption: 'Añadir la proporcion de la diferencia entre una y la otra. Mejorar la visibilidad de la logica (que es la proporcion). Copiar formato de grafica 3', marginLeft: 60, marginBottom: 40, width: 900, height: 800, // marginRight: 150, color: {legend: true, type: 'categorical', tickFormat: d => Object({'presupuesto': 'Presupuesto', 'abatement': 'Gastos Fiscales'})[d] ?? d, domain: ['presupuesto', 'abatement'], // range: ['lightblue', 'salmon'], range: ['INDIGO', 'GREEN', ].map(d => EA_COLORES_MAP[d]), // }, x: {tickFormat: d => '', domain: ['presupuesto', 'abatement'], axis: false, padding: 0}, // y: {}, marks: [ Plot.frame({ fill: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: null, inset: 0, }), Plot.axisFx({ fontFamily: 'jaf-bernino-sans', tickSize: 0, label: null, fontSize: 14, anchor: 'bottom', tickFormat: d => d.replace(' ', '\n') }), Plot.axisY({ tickFormat: '$,.0s', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 14, ticks: 10, label: null }), Plot.barY(abatements_y_presupuestos_comparative .filter(d => (d.abatement_ratio > .50)), { // filter: d => d.municipio !== 'San Juan', y: 'cantidad', x: "tipo", fx: 'municipio', fill: 'tipo', channels: {'z': 'abatement_ratio'}, sort: {fx: "z", reverse: true}, // inset: 0, }), Plot.text(abatements_y_presupuestos_comparative .filter(d => (d.abatement_ratio > .50)), { filter: d => d.cantidad > 32e6, y: 'cantidad', x: "tipo", fx: 'municipio', fill: 'white', text: d => d3.format('$,.0f')(d['cantidad']), channels: {'z': 'abatement_ratio'}, sort: {fx: "z", reverse: true}, fontWeight: 'bold', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', rotate: -90, textAnchor: 'end', dy: 10, fontSize: 14.5, // inset: 0, }), Plot.text(abatements_y_presupuestos_comparative .filter(d => (d.abatement_ratio > .50)), { filter: d => (d.cantidad < 32e6) & (d.cantidad > 10e6), y: 'cantidad', x: "tipo", fx: 'municipio', fill: 'white', text: d => d3.format('$,.2s')(d['cantidad']), channels: {'z': 'abatement_ratio'}, sort: {fx: "z", reverse: true}, fontWeight: 'bold', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', rotate: -90, textAnchor: 'end', dy: 10, fontSize: 14.5, // inset: 0, }), Plot.arrow(abatements_y_presupuestos_comparative_wide .filter(d => (d.abatement > d.presupuesto) & (d.abatement > 20e6)) , { // filter: d => (d.year < 2025) & (d.year !== 2022), fx: "municipio", x1: d => "presupuesto", x2: d => "presupuesto", y1: d => d['presupuesto']+ 2e6, y2: 'abatement', strokeWidth: 1, }), Plot.text(abatements_y_presupuestos_comparative_wide .filter(d => (d.abatement > d.presupuesto) & (d.abatement > 20e6)), { // filter: d => (d.year < 2025) & (d.year !== 2022), fx: "municipio", rotate: -90, x: d => "presupuesto", y: d => (d['presupuesto']+d['abatement'])/2, // dy: -10, text: d => '+'+d3.format(".0%")((d['abatement']-d['presupuesto'])/d['presupuesto']), fill: 'black', // stroke: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: chroma.mix('white',EA_COLORES_MAP['DARK GREY'], 0.15).hex(), strokeWidth: 10, fontSize: 12, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', }), // Plot.ruleY([0]) ] }) add_estilos(theplot) return theplot }48:Tfa3,grafica_6 = { let theplot = Plot.plot({ // caption: 'Añadir la proporcion de la diferencia entre una y la otra. Mejorar la visibilidad de la logica (que es la proporcion). Copiar formato de grafica 3', marginLeft: 60, marginBottom: 40, width: 900, height: 800, // marginRight: 150, color: {legend: true, type: 'categorical', tickFormat: d => Object({'presupuesto': 'Municipal Budget', 'abatement': 'Municipal Tax Abatements'})[d] ?? d, domain: ['presupuesto', 'abatement'], // range: ['lightblue', 'salmon'], range: ['INDIGO', 'GREEN', ].map(d => EA_COLORES_MAP[d]), // }, x: {tickFormat: d => '', domain: ['presupuesto', 'abatement'], axis: false, padding: 0}, // y: {}, marks: [ Plot.frame({ fill: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: null, inset: 0, }), Plot.axisFx({ fontFamily: 'jaf-bernino-sans', tickSize: 0, label: null, fontSize: 14, anchor: 'bottom', tickFormat: d => d.replace(' ', '\n') }), Plot.axisY({ tickFormat: '$,.0s', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', tickSize: 0, fontSize: 14, ticks: 10, label: null }), Plot.barY(abatements_y_presupuestos_comparative .filter(d => (d.abatement_ratio > .50)), { // filter: d => d.municipio !== 'San Juan', y: 'cantidad', x: "tipo", fx: 'municipio', fill: 'tipo', channels: {'z': 'abatement_ratio'}, sort: {fx: "z", reverse: true}, // inset: 0, }), Plot.text(abatements_y_presupuestos_comparative .filter(d => (d.abatement_ratio > .50)), { filter: d => d.cantidad > 32e6, y: 'cantidad', x: "tipo", fx: 'municipio', fill: 'white', text: d => d3.format('$,.0f')(d['cantidad']), channels: {'z': 'abatement_ratio'}, sort: {fx: "z", reverse: true}, fontWeight: 'bold', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', rotate: -90, textAnchor: 'end', dy: 10, fontSize: 14.5, // inset: 0, }), Plot.text(abatements_y_presupuestos_comparative .filter(d => (d.abatement_ratio > .50)), { filter: d => (d.cantidad < 32e6) & (d.cantidad > 10e6), y: 'cantidad', x: "tipo", fx: 'municipio', fill: 'white', text: d => d3.format('$,.2s')(d['cantidad']), channels: {'z': 'abatement_ratio'}, sort: {fx: "z", reverse: true}, fontWeight: 'bold', fontFamily: 'jaf-bernino-sans', fontVariant: 'tabular-nums', rotate: -90, textAnchor: 'end', dy: 10, fontSize: 14.5, // inset: 0, }), Plot.arrow(abatements_y_presupuestos_comparative_wide .filter(d => (d.abatement > d.presupuesto) & (d.abatement > 20e6)) , { // filter: d => (d.year < 2025) & (d.year !== 2022), fx: "municipio", x1: d => "presupuesto", x2: d => "presupuesto", y1: d => d['presupuesto']+ 2e6, y2: 'abatement', strokeWidth: 1, }), Plot.text(abatements_y_presupuestos_comparative_wide .filter(d => (d.abatement > d.presupuesto) & (d.abatement > 20e6)), { // filter: d => (d.year < 2025) & (d.year !== 2022), fx: "municipio", rotate: -90, x: d => "presupuesto", y: d => (d['presupuesto']+d['abatement'])/2, // dy: -10, text: d => '+'+d3.format(".0%")((d['abatement']-d['presupuesto'])/d['presupuesto']), fill: 'black', // stroke: chroma(EA_COLORES_MAP['DARK GREY']).alpha(0.15).hex(), stroke: chroma.mix('white',EA_COLORES_MAP['DARK GREY'], 0.15).hex(), strokeWidth: 10, fontSize: 12, fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', fontWeight: 'bold', }), // Plot.ruleY([0]) ] }) add_estilos(theplot) return theplot }49:T46d,{ let thedata = ter24_by_budget_category//.filter(d => d.categoria_presupuestaria === 'Desarrollo económico') return Plot.plot({ marginLeft: 60, x: {tickFormat: "", label: 'Año'}, y: {tickFormat: d => d3.format("$,.0f")(d)+'M', label: 'Total en millones de dólares'}, marks: [ // Plot.barY(thedata, {x: "year", y: "amount", fill: 'gray'}), // Plot.barY(thedata.filter(d => d.categoria_presupuestaria === 'Desarrollo económico'), // {x: "year", y: "amount", z: 'categoria_presupuestaria', fill: 'pink'}), Plot.line(thedata, {x: "year", y: "amount", z: 'categoria_presupuestaria', stroke: '#bbb'}), Plot.line(thedata.filter(d => d.categoria_presupuestaria === 'Desarrollo económico'), {x: "year", y: "amount", z: 'categoria_presupuestaria', stroke: 'red'}), Plot.dot(thedata.filter(d => d.categoria_presupuestaria === 'Desarrollo económico'), {x: "year", y: "amount", z: 'categoria_presupuestaria', stroke: 'red'}), // Plot.lineY(scatter, {x: "year", y: "amount"}), Plot.ruleY([0]), ] }) }4a:T48a,ley_label = Object({ '135 of 1997': 'Ley 135 del 1997', '159 of 2004': 'Ley 159 del 2004' , '73 of 2008': 'Ley 73 del 2008' , 'Municipal Ordinances' : 'Ordenanzas Municipales', "U.S. Custom and Border Protection Foreign Trade Zone Tax Incentives": 'Ley federal\nde comercio foráneo', "All": 'Municipios reportan el total \n de leyes como agregado', "74 of 2010": 'Ley 74 de 2010', "Estatal": 'Municipios solo reportan \n el total de leyes estatales', "73 of 2008, 135 of 1998, 120 of 2014, 20 of 2012 ": 'Ley 73 de 2008, 135 de 1998,\n120 de 2014, 20 de 2012', "168 of 1968": 'Ley 168 de 1968', "225 of 1995" : 'Ley 225 de 1995', "103 of 2000" : 'Ley 103 de 2000', "1101 (a) (6) of the internal revenue code of Puerto Rico (Not for profit)" : 'Excensiones estatales \n a sin fines de lucro', "52 of 1983, 78 of 2011" : 'Ley 52 de 1983, 78 de 2011', "255 of 2002" : 'Ley 255 de 2002', "83 of 2010": 'Ley 83 de 2010', "225 of 2002": 'Ley 225 de 2002', "73 of 2008, 135 of 2014, 20 of 2012, 8 of 1987" : 'Ley 73 de 2008, 135 de 2014,\n 20 de 2012, 8 de 1987', "20 of 2012" : 'Ley 20 de 2012' })4b:T5a7,Plot.plot({ marginLeft: 100, marginRight: 150, color: {legend: true, type: 'categorical', domain: ['Presupuesto', 'Abatements'], range: ['lightblue', 'salmon'], }, x: {tickFormat: ',.0%'}, marks: [ Plot.barX(abatements_y_presupuestos, { x1: 0, x2: d => d['presupuesto_percent'], y: "municipio", fill: 'lightblue', channels: {'z': 'abatement_ratio'}, sort: {y: "z", reverse: true} }), Plot.barX(abatements_y_presupuestos, { x1: d => d['presupuesto_percent'], x2: d => d['presupuesto_percent'] + d['abatement_percent'], y: "municipio", fill: 'salmon', }), Plot.text(abatements_y_presupuestos, { x: d => (0 + d['presupuesto_percent'])/2, dx: 10, y: "municipio", text: d => { return `${d3.format("$,.2s")(d.presupuesto)} (${d3.format(".0f")(d['presupuesto_percent']*100)+'%'})` }, textAnchor: 'middle', // stroke: 'white', fill: 'black', strokeWidth: 4, }), Plot.text(abatements_y_presupuestos, { x: d => (2*d['presupuesto_percent'] + d['abatement_percent'])/2, dx: 10, y: "municipio", text: d => { return `${d3.format("$,.2s")(d.abatement)} (${d3.format(".0f")(d['abatement_percent']*100)+'%'})` }, textAnchor: 'middle', // stroke: 'white', fill: 'black', strokeWidth: 4, // fontWeight: 'bold', }), Plot.ruleX([0]) ] })4c:T7ab,muni_norm_to_municipio = Object( {'ADJUNTAS': 'Adjuntas', 'AGUADA': 'Aguada', 'AGUADILLA': 'Aguadilla', 'AGUAS BUENAS': 'Aguas Buenas', 'AIBONITO': 'Aibonito', 'AÑASCO': 'Añasco', 'ARECIBO': 'Arecibo', 'ARROYO': 'Arroyo', 'BARCELONETA': 'Barceloneta', 'BARRANQUITAS': 'Barranquitas', 'BAYAMON': 'Bayamón', 'CABO ROJO': 'Cabo Rojo', 'CAGUAS': 'Caguas', 'CAMUY': 'Camuy', 'CANOVANAS': 'Canóvanas', 'CAROLINA': 'Carolina', 'CATAÑO': 'Cataño', 'CAYEY': 'Cayey', 'CEIBA': 'Ceiba', 'CIALES': 'Ciales', 'CIDRA': 'Cidra', 'COAMO': 'Coamo', 'COMERIO': 'Comerío', 'COROZAL': 'Corozal', 'CULEBRA': 'Culebra', 'DORADO': 'Dorado', 'FAJARDO': 'Fajardo', 'FLORIDA': 'Florida', 'GUANICA': 'Guánica', 'GUAYAMA': 'Guayama', 'GUAYANILLA': 'Guayanilla', 'GUAYNABO': 'Guaynabo', 'GURABO': 'Gurabo', 'HATILLO': 'Hatillo', 'HORMIGUEROS': 'Hormigueros', 'HUMACAO': 'Humacao', 'ISABELA': 'Isabela', 'JAYUYA': 'Jayuya', 'JUANA DIAZ': 'Juana Díaz', 'JUNCOS': 'Juncos', 'LAJAS': 'Lajas', 'LARES': 'Lares', 'LAS MARIAS': 'Las Marías', 'LAS PIEDRAS': 'Las Piedras', 'LOIZA': 'Loíza', 'LUQUILLO': 'Luquillo', 'MANATI': 'Manatí', 'MARICAO': 'Maricao', 'MAUNABO': 'Maunabo', 'MAYAGUEZ': 'Mayagüez', 'MOCA': 'Moca', 'MOROVIS': 'Morovis', 'NAGUABO': 'Naguabo', 'NARANJITO': 'Naranjito', 'OROCOVIS': 'Orocovis', 'PATILLAS': 'Patillas', 'PEÑUELAS': 'Peñuelas', 'PONCE': 'Ponce', 'QUEBRADILLAS': 'Quebradillas', 'RINCON': 'Rincón', 'RIO GRANDE': 'Río Grande', 'SABANA GRANDE': 'Sabana Grande', 'SALINAS': 'Salinas', 'SAN GERMAN': 'San Germán', 'SAN JUAN': 'San Juan', 'SAN LORENZO': 'San Lorenzo', 'SAN SEBASTIAN': 'San Sebastián', 'SANTA ISABEL': 'Santa Isabel', 'TOA ALTA': 'Toa Alta', 'TOA BAJA': 'Toa Baja', 'TRUJILLO ALTO': 'Trujillo Alto', 'UTUADO': 'Utuado', 'VEGA ALTA': 'Vega Alta', 'VEGA BAJA': 'Vega Baja', 'VIEQUES': 'Vieques', 'VILLALBA': 'Villalba', 'YABUCOA': 'Yabucoa', 'YAUCO': 'Yauco'} )4d:T6c8,abatements_db = { const db = await DuckDBClient.of({ ingresos_gastos: FileAttachment("estadisticas_municipales-ingresos_y_gastos.snappy.parquet"), abatements_municipales: FileAttachment("Abataments_Master - DatosMunicipales@5.csv"), }) await db.query(` create or replace table muni_norm_to_municipio as ( with initial_table as ( select unnest(${muni_norm_to_municipio_liststring}) as original, string_split(original, '_') as thesplit, thesplit[1] as municipio_norm, thesplit[2] as Municipio ) select municipio_norm, Municipio from initial_table ) `) await db.sql` create or replace table abatements_municipales as ( select * replace ( replace(replace(Abatement, '$', ''), ',', '')::FLOAT as Abatement ) from abatements_municipales ) ` await db.query(` create or replace table abatements_latest as ( with latest_year_per_muni as ( select Municipio, max(Año) as Año from abatements_municipales group by Municipio ) select * from latest_year_per_muni left join abatements_municipales using (Municipio, Año) order by Municipio, Año, "Type of Tax" ) `) // que papelon await db.query(` create or replace table ingresos_gastos_new as ( with initial_table as ( select * from ingresos_gastos as ig left join muni_norm_to_municipio as mm on ig.Municipio = mm.municipio_norm ) select * exclude (municipio_norm, "Municipio:1") replace ("Municipio:1" as "Municipio"), "Municipio" as municipio_original from initial_table ) `) await db.query(`drop view ingresos_gastos`) await db.query(`alter table ingresos_gastos_new rename to ingresos_gastos`) return db }4e:[{"id":"380f4ceac977c2e8c5c64801be2930f5c8330b7d7a7a80fb41d5bda88c56862675c383f0cdf84c4e49a55f2c1ef43982bfcb586317d8186a12010f37215d232b","href":"https://static.observableusercontent.com/files/380f4ceac977c2e8c5c64801be2930f5c8330b7d7a7a80fb41d5bda88c56862675c383f0cdf84c4e49a55f2c1ef43982bfcb586317d8186a12010f37215d232b","name":"Codigos_Censales_y_Abrev_Municipios.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1708965611271.501,"size":20414},{"id":"c483eca2309958e722e956e96c29070c37bda69983334c6b98fd97e530e691546a7a323c1dec9ee8e738bb9632e41a955542df7656c23e865f825228cbc62779","href":"https://static.observableusercontent.com/files/c483eca2309958e722e956e96c29070c37bda69983334c6b98fd97e530e691546a7a323c1dec9ee8e738bb9632e41a955542df7656c23e865f825228cbc62779","name":"Tax Expenditure 2023@1.xlsx - Grafica 3.csv","type":"text/csv","lastModified":1710785609129.108,"size":1235},{"id":"bce05512ae0ba3245e0baa1db9ab4c1698aaf2171b4de68208ba3c3ce0a2a6f9d1832f5abf88f9c2899c602fcafe2560073fdf078bafe7e1aeba969310a934c8","href":"https://static.observableusercontent.com/files/bce05512ae0ba3245e0baa1db9ab4c1698aaf2171b4de68208ba3c3ce0a2a6f9d1832f5abf88f9c2899c602fcafe2560073fdf078bafe7e1aeba969310a934c8","name":"Tax Expenditure 2023@1.xlsx - Grafica 2.csv","type":"text/csv","lastModified":1710793633704.759,"size":443},{"id":"53eb86aa1831d80181b6e409030fb0d7250319d376bd924835a211e07697314e63069d02362ba4efad66b6b3df5f2f0f840ef504f8d0f047117afde69cb37074","href":"https://static.observableusercontent.com/files/53eb86aa1831d80181b6e409030fb0d7250319d376bd924835a211e07697314e63069d02362ba4efad66b6b3df5f2f0f840ef504f8d0f047117afde69cb37074","name":"Tax Expenditure 2023.xlsx - Grafica 3.csv","type":"text/csv","lastModified":1698776256095.538,"size":1235},{"id":"05a4b14bdc01695be18d82eb48c1d0cdb59b623e8fccb2ec55302fd5a446ead69bbdc26b0679b5b4d9e46441ca20b0fccbb8fca4e9cfd284327f0582d2312abb","href":"https://static.observableusercontent.com/files/05a4b14bdc01695be18d82eb48c1d0cdb59b623e8fccb2ec55302fd5a446ead69bbdc26b0679b5b4d9e46441ca20b0fccbb8fca4e9cfd284327f0582d2312abb","name":"Tax Expenditure 2023@1.xlsx - Grafica 1.csv","type":"text/csv","lastModified":1698777036818.581,"size":197},{"id":"38822c9f1ac72c738d9d70eee5b1270474fcf13679b8804570b6000b28bb7f016a39c880e52a5bf451c50426e713ebf41bd5acd7970d9f654278bfcfb1be238b","href":"https://static.observableusercontent.com/files/38822c9f1ac72c738d9d70eee5b1270474fcf13679b8804570b6000b28bb7f016a39c880e52a5bf451c50426e713ebf41bd5acd7970d9f654278bfcfb1be238b","name":"Tax Expenditure 2023.xlsx - Grafica 7.csv","type":"text/csv","lastModified":1698779702646.233,"size":819},{"id":"b14b6631a6056c82f0c78057092ae3a3682e840e9f9f43368047cb3d715aea101805055dad1576407e6f61cf06e6fc4dc508a7dce346b93a5fb0ccb58691d0a1","href":"https://static.observableusercontent.com/files/b14b6631a6056c82f0c78057092ae3a3682e840e9f9f43368047cb3d715aea101805055dad1576407e6f61cf06e6fc4dc508a7dce346b93a5fb0ccb58691d0a1","name":"presupuesto-por-ingreso-2021.csv","type":"text/csv","lastModified":1700080629279.337,"size":195},{"id":"cfe8d3b5b82da3068f2a2df652b8b4edc1c3835af2f3fecc517f533b0cc8a9e1d645573f0839be9a32ae7a3f4a1d2c30cf7678dd18a231fe2beb3321b17c86ef","href":"https://static.observableusercontent.com/files/cfe8d3b5b82da3068f2a2df652b8b4edc1c3835af2f3fecc517f533b0cc8a9e1d645573f0839be9a32ae7a3f4a1d2c30cf7678dd18a231fe2beb3321b17c86ef","name":"presupuesto-por-ingreso-2021@1.csv","type":"text/csv","lastModified":1700080675556.53,"size":194},{"id":"edcd9b25117af1b35608e424a49e256ad5c21b8c95a121645cc9cd4be4178dc4b9dc63b3dd06d087900943d1ae6ead61ad485add2d8036acb32a0ab5a798537f","href":"https://static.observableusercontent.com/files/edcd9b25117af1b35608e424a49e256ad5c21b8c95a121645cc9cd4be4178dc4b9dc63b3dd06d087900943d1ae6ead61ad485add2d8036acb32a0ab5a798537f","name":"presupuesto-por-ingreso@3.csv","type":"text/csv","lastModified":1698857826770.239,"size":552},{"id":"bcc2f0bff50b62c746897f501886ad1e4fd2cae983db398b206c31cba2f418431975a2294778adedf12d8f3a550ee76c6ea2e02fcc8180ff3b6fe6a7f9a3b185","href":"https://static.observableusercontent.com/files/bcc2f0bff50b62c746897f501886ad1e4fd2cae983db398b206c31cba2f418431975a2294778adedf12d8f3a550ee76c6ea2e02fcc8180ff3b6fe6a7f9a3b185","name":"presupuesto-por-ingreso@4.csv","type":"text/csv","lastModified":1698858113301.143,"size":554},{"id":"3463587b2daed0b7fa9cd8780475db6f0d9ce9806e732361015a061ad939c69f7a30fd3a530630c7f7d28afcf46c904c47ebe2cd8afbdd0c6816a28f4aa23979","href":"https://static.observableusercontent.com/files/3463587b2daed0b7fa9cd8780475db6f0d9ce9806e732361015a061ad939c69f7a30fd3a530630c7f7d28afcf46c904c47ebe2cd8afbdd0c6816a28f4aa23979","name":"Abataments_Master - DatosMunicipales@2.csv","type":"text/csv","lastModified":1699288391928.664,"size":46050},{"id":"108c147371fd43cf1b77527c7350df9a5d682671ac21f357e6ac6c264a89e910b6da58a2914124490a937bb304fb079ed96eb11e3bbf72f6afb0cb2a1ef294f9","href":"https://static.observableusercontent.com/files/108c147371fd43cf1b77527c7350df9a5d682671ac21f357e6ac6c264a89e910b6da58a2914124490a937bb304fb079ed96eb11e3bbf72f6afb0cb2a1ef294f9","name":"Abataments_Master - DatosMunicipales@5.csv","type":"text/csv","lastModified":1702573868591.671,"size":46506},{"id":"fa53eb06118f8b5cfe70f27c68d517c34083e78b62290c4f1ac877400ef07435fb6912d5aa5ae4fa54efebbbff5a75a96c906c2b65eaf455549c22672d7f01e4","href":"https://static.observableusercontent.com/files/fa53eb06118f8b5cfe70f27c68d517c34083e78b62290c4f1ac877400ef07435fb6912d5aa5ae4fa54efebbbff5a75a96c906c2b65eaf455549c22672d7f01e4","name":"Tax Expenditure 2023.xlsx - Grafica 2.csv","type":"text/csv","lastModified":1698778055699.532,"size":432},{"id":"f0950f64dfea728ebddf9e61737115f81d56648c88177ba41b745c2c1296475116bbc61862331c3df10514a82e54db50d9b68234e880bf5b815a4e329e1c061f","href":"https://static.observableusercontent.com/files/f0950f64dfea728ebddf9e61737115f81d56648c88177ba41b745c2c1296475116bbc61862331c3df10514a82e54db50d9b68234e880bf5b815a4e329e1c061f","name":"presupuesto-por-ingreso-2021@2.csv","type":"text/csv","lastModified":1700080955639.653,"size":231},{"id":"2725b1efbd52477ca0716a3db39519b32a5b03d9b9dd74d7e5d3ef87db9a42430621a10396ed659909842a2b6eee23072c0aacf33bbc1e3a95b9eebcf1aabcbc","href":"https://static.observableusercontent.com/files/2725b1efbd52477ca0716a3db39519b32a5b03d9b9dd74d7e5d3ef87db9a42430621a10396ed659909842a2b6eee23072c0aacf33bbc1e3a95b9eebcf1aabcbc","name":"ter24_by_budget_category_long.csv","type":"text/csv","lastModified":1698858981958.592,"size":4674},{"id":"e5101b81559ba983f09a8e60cc88821246e50b869a98da969153bb8902e28483ba086b40bc076ab3d6bb8453868e31f4c33233f7cc869578d313a174732d8cf6","href":"https://static.observableusercontent.com/files/e5101b81559ba983f09a8e60cc88821246e50b869a98da969153bb8902e28483ba086b40bc076ab3d6bb8453868e31f4c33233f7cc869578d313a174732d8cf6","name":"Abataments_Master - DatosMunicipales@4.csv","type":"text/csv","lastModified":1700157247097.022,"size":46530},{"id":"c80817b647763d43c01abe063932546fb6c91a8cd7f99bcbea4ce772c823a2dc96b18bf0c6979d77e24fb6044f663519e2302caf2d79454b39c4110b9017e7cc","href":"https://static.observableusercontent.com/files/c80817b647763d43c01abe063932546fb6c91a8cd7f99bcbea4ce772c823a2dc96b18bf0c6979d77e24fb6044f663519e2302caf2d79454b39c4110b9017e7cc","name":"Abataments_Master - DatosMunicipales.csv","type":"text/csv","lastModified":1698866069292.883,"size":41734},{"id":"495e154e84784dd8f669d54f2116010e3e6e0cf50a313001ebc3d22a0aa270939eb3f0dca76a09d12fedfd36c63ca5bf902b30c2ad5b819cc6df5829e20a19f9","href":"https://static.observableusercontent.com/files/495e154e84784dd8f669d54f2116010e3e6e0cf50a313001ebc3d22a0aa270939eb3f0dca76a09d12fedfd36c63ca5bf902b30c2ad5b819cc6df5829e20a19f9","name":"Abataments_Master - DatosMunicipales@1.csv","type":"text/csv","lastModified":1698944526880.404,"size":41911},{"id":"6724bc2011d54849ad2e69d289047286671213919edecc925f7c4f21f610265f74d8795833b9abfa47ec716356a1e4b7a334c997ccea9ff82a9db944b2c3af7d","href":"https://static.observableusercontent.com/files/6724bc2011d54849ad2e69d289047286671213919edecc925f7c4f21f610265f74d8795833b9abfa47ec716356a1e4b7a334c997ccea9ff82a9db944b2c3af7d","name":"Abataments_Master - Análisis Preliminar.csv","type":"text/csv","lastModified":1699300893811.957,"size":4546},{"id":"c1b666c630d8b9928dbd23473a82c4ed264988ccd2b20cf1c85563987fdf7807f033bfb990aef1f15d10e7811e6e0385ef2a41d778c8a9508dcac7f91d8f7cfc","href":"https://static.observableusercontent.com/files/c1b666c630d8b9928dbd23473a82c4ed264988ccd2b20cf1c85563987fdf7807f033bfb990aef1f15d10e7811e6e0385ef2a41d778c8a9508dcac7f91d8f7cfc","name":"Abataments_Master - DatosMunicipales@3.csv","type":"text/csv","lastModified":1699554449935.507,"size":46050},{"id":"a7131372e6ae8b36e12c2c2ff8818cc138c93a067ebf9f1739a1c5462740b53795e36d9ba1300c8a5206117958295411107a78f411cbc60b62d7b3558b06745c","href":"https://static.observableusercontent.com/files/a7131372e6ae8b36e12c2c2ff8818cc138c93a067ebf9f1739a1c5462740b53795e36d9ba1300c8a5206117958295411107a78f411cbc60b62d7b3558b06745c","name":"estadisticas_municipales-ingresos_y_gastos.snappy.parquet","type":"application/octet-stream","lastModified":1698953648386.222,"size":128143}] 2f:{"id":"5480a88d7e070c36","slug":null,"title":"Tax Expenditures 2023","thumbnail":"7b5036efb1c4580dec3e79a74a5591f2d61e3ebc09c968a214b232f90ce4c783","access_level":"public","create_time":"$D2023-10-31T18:17:25.364Z","update_time":"$D2024-03-18T20:35:15.892Z","view_time":null,"first_public_time":"$D2023-10-31T18:17:25.364Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"247b19faa48b7d89","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":"starter_2024"},"version":2736,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2c62f0243f8f45b0","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":null}],"members":[{"type":"individual","id":"2c62f0243f8f45b0","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":null,"role":"editor"},{"type":"individual","id":"6782320697260a55","login":"wilmari-de-jesus","name":"Wilmari De Jesus","avatar_url":"https://avatars-next.observableusercontent.com/42be09894feb2486ea9241648e5f5a37b6af4cb8c5639e53bbe9985e04f5a628","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"6747c4e5c0f5d653","slug":"espacios-abiertos","title":"Espacios Abiertos","owner":{"id":"247b19faa48b7d89","login":"jzavala-gonzalez","name":"José M. Zavala González"}},"type":"notebook","body":{"title":"Tax Expenditures 2023","cells":[{"id":0,"value":"# Tax Expenditures 2023","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":85,"value":"## Gráfica 1: Desglose de gastos fiscales listados por clasificación de datos, PRTER 2024","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":39,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2428,"value":"DOM.download(() => serialize(grafica_01), 'TEXP_grafica_01.svg', \"#1 - Save as SVG\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2436,"value":"download_buttons(grafica_01, 'TEXP_grafica_01', '#1')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2489,"value":"DOM.download(() => rasterize(grafica_01), undefined, \"Save as PNG\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2285,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"## Gráfica 2: Porcentaje de gastos fiscales reportados con impacto fiscal estimado al último año de reporte disponible alrededor del mundo","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2586,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2600,"value":"{\n let traducciones_draft = {}\n gastos_tributarios_identificados.forEach(d => traducciones_draft[d['País']] = d['País'])\n return JSON.stringify(traducciones_draft)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2441,"value":"download_buttons(grafica_02, 'TEXP_grafica_02', '#2')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2496,"value":"DOM.download(() => rasterize(grafica_02), undefined, \"Save as PNG\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"## Gráfica 3: Comparativa entre el presupuesto del fondo general y gastos fiscales, 2017-2019","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":92,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2592,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2446,"value":"download_buttons(grafica_03, 'TEXP_grafica_03', '#3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1875,"value":"aq.from(total_fondos_wide).view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"## Gráfica 4: Distribución de ingresos no devengados por concepto de desarrollo económico 2017-2026.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1316,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2611,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2450,"value":"download_buttons(grafica_04, 'TEXP_grafica_04', '#4')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":224,"value":"## Gráfica 5: Distribución de gastos directos (presupuesto del fondo general) e indirectos (gastos fiscales o tributarios) por áreas presupuestarias seleccionadas, 2021","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":249,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2618,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2456,"value":"download_buttons(grafica_05, 'TEXP_grafica_05', '#5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1562,"value":"area_label = Object({\n 'Negocios - Agricultura y Pesca': 'Agricultura y Pesca',\n 'Arte, Cultura, Recreación y Deportes': 'Arte, Cultura,\\nRecreación y Deportes',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"## Gráfica 6: Distribución de gasto tributario por fuente tributaria 2017-2026. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":164,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2620,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2508,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2460,"value":"download_buttons(grafica_06, 'TEXP_grafica_06', '#6')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":627,"value":"## Figura 1: Distribución de gastos tributarios por municipios y nivel de detalle en el reporte.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1124,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2626,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2707,"value":"municipios_label_hack = Object({\n 'Arroyo': '\\nArroyo',\n 'Quebradillas': '\\nQuebradillas',\n 'Camuy': '\\nCamuy',\n 'Hatillo': 'Hatillo\\n\\n',\n 'Guaynabo': '\\nGuaynabo',\n 'Canóvanas': '\\nCanóvanas',\n 'Hormigueros': 'Hormigueros\\n',\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2685,"value":"Plot.text(municipios_with_data.features, Plot.centroid({\n text: (d) => (d.properties.jovenes['jovenes'] / d.properties.calculos['Poblacion Total']).toLocaleString(undefined,{style: 'percent', minimumFractionDigits:1}),\n fill: \"black\", stroke: \"white\",\n // style: 'paint-order: stroke',\n })),","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2694,"value":"codigos_censales_y_abrev_municipios = {\n const allsheets = await FileAttachment(\"Codigos_Censales_y_Abrev_Municipios.xlsx\").xlsx()\n\n return allsheets.sheet('Sheet1', {headers: true})\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2687,"value":"municipios_with_analisis_preliminar","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2464,"value":"download_buttons(figura_1, 'TEXP_figura_01', 'Fig #1')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1960,"value":"municipios_with_analisis_preliminar.features.filter(d => d.properties.analisis_preliminar !== undefined)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"## Gráfica 7: Distribución de gastos tributarios municipales por categoría de gasto","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":642,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2641,"value":"$41","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2468,"value":"download_buttons(grafica_07, 'TEXP_grafica_07', '#7')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1567,"value":"type_tax_label = Object({\n 'Personal Property Tax': 'Impuestos a la propiedad mueble',\n 'Real Property Tax': 'Impuestos a la propiedad immueble',\n 'Volume of business taxes': 'Impuestos sobre el volumen de venta',\n 'Municipal License Tax': 'Permisos municipales',\n 'Construction excise tax': 'Arbitrios de construcción',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1130,"value":"## Gráfica 8: Distribución de gastos tributarios municipales por mecanismo habilitador. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1094,"value":"$42","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2643,"value":"$43","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2472,"value":"download_buttons(grafica_08, 'TEXP_grafica_08', '#8')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1576,"value":"entidad_gobe_label = Object({\n 'Estatal': 'Gobierno Estatal',\n 'Municipal Ordinances': 'Gobierno Municipal',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"## Gráfica 9: Distribución de gastos tributarios municipales por ley habilitadora. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2670,"value":"$44","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2476,"value":"download_buttons(grafica_09, 'TEXP_grafica_09', '#9')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1901,"value":"{\n let thedata = abatements_latest_by_ley//.filter(d => d.abatement > 1e6)\nlet theplot = Plot.plot({\n width,\n height: 1000,\n marginLeft: 200,\n marginRight: 100,\n marks: [\n Plot.axisX({\n tickFormat: \"$,.0s\",\n fontFamily: 'jaf-bernino-sans',\n fontVariant: 'tabular-nums',\n tickSize: 0,\n }),\n Plot.axisY({\n tickFormat: d => ley_label[d] ?? d,\n fontFamily: 'jaf-bernino-sans',\n tickSize: 0,\n }),\n \n Plot.barX(thedata, {\n x: \"abatement\", y: \"Ley\",\n fill: EA_COLORES_MAP['DARK GREY'],\n sort: {y: \"x\", reverse: true},\n }),\n Plot.text(thedata, {\n x: \"abatement\", y: \"Ley\",\n dx: 5,\n text: d => d3.format(\"$,.4s\")(d['abatement']),\n textAnchor: 'start',\n sort: {y: \"x\", reverse: true},\n fontFamily: 'jaf-bernino-sans',\n fontVariant: 'tabular-nums',\n fontWeight: 'bold',\n fontSize: 12,\n }),\n Plot.ruleX([0])\n ]\n})\n\n return theplot\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1906,"value":"abatements_latest_by_ley.map(d => d.Ley)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1087,"value":"## Figura 2: Distribución de gastos tributarios municipales en dolares.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":546,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2479,"value":"download_buttons(figura_2, 'TEXP_figura_02', 'Fig #2')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1051,"value":"## Gráfica 10: Comparativa de presupuesto vis a vis el gasto tributario municipal ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1026,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2633,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2484,"value":"download_buttons(grafica_10, 'TEXP_grafica_10', '#10')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":434,"value":"# CÓDIGO (PARA USO INTERNO SOLAMENTE)\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1938,"value":"chroma = require(\"chroma-js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2422,"value":"import {serialize, rasterize} from \"@mbostock/saving-svg\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2434,"value":"function download_buttons(svg_embed, filename_no_ext, label_prefix) {\n return html`\n ${DOM.download(serialize(svg_embed), filename_no_ext+'.svg', `${label_prefix} - Download as SVG`)}\n ${DOM.download(rasterize(svg_embed), filename_no_ext+'.png', `${label_prefix} - Download as PNG`)}\n`\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2387,"value":"fonts_link = \"https://use.typekit.net/szl4srx.css\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2391,"value":"fonts_link_element = \n// Importante para ver los fonts en el editor de Observable (o sea aqui)\nhtl.html`\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2401,"value":"fonts_stylesheet_content = {\n // Necesitamos el contenido CSS para embed los fonts en los svg y png downloads\n return await fetch(fonts_link).then(r => r.text())\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2404,"value":"function add_estilos(theplot, plotname = null) {\n var styleElement = document.createElementNS('http://www.w3.org/2000/svg', 'style');\n styleElement.textContent = fonts_stylesheet_content + '\\n' + estilos_content;\n \n let myplot = d3.select(theplot)\n const toplevel_tag = myplot.node().tagName\n // console.log('toplevel_tag', toplevel_tag)\n\n if (toplevel_tag !== 'svg') {\n myplot.selectAll(\"svg\")\n .each((d, i, nodes) => {\n // if (plotname !== null) {\n // console.log('add_estilos for ' + plotname + ': d, i, nodes:', d, i, nodes)\n // }\n d3.select(nodes[i]).node().insertBefore(\n styleElement,\n nodes[i].firstChild,\n );\n \n })\n } else {\n myplot.node().insertBefore(\n styleElement,\n myplot.firstChild,\n );\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1622,"value":"estilos = htl.html`\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2406,"value":"estilos_content = d3.select(estilos).select('style').node().textContent","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1915,"value":"x-height of jaf-bernino-sans normal parece ser 50px for a 100px font size ???","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1909,"value":"htl.html`\nabcd x\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1211,"value":"grafica_01_labels = Object({\n 'Not claimed': 'Sin reclamar',\n 'Repealed': 'Derogado',\n 'With Estimates': 'Con estimados',\n 'Without Estimates': 'Sin estimados',\n \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"gastos_clasificados_segun_reportados_inicial = await FileAttachment(\"Tax Expenditure 2023@1.xlsx - Grafica 1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"gastos_clasificados_segun_reportados_inicial","database":"$undefined"},{"id":364,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1527,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"gastos_clasificados_segun_reportados = {\n let data = structuredClone(gastos_clasificados_segun_reportados_inicial)\n \n data = aq.from(data)\n .fold(['2020', '2021', '2022', '2023', '2024', '2025', '2026'], {as: ['year', 'amount']})\n .objects()\n data.forEach(d => {\n d.year = +d.year\n })\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1262,"value":"total_fondos_wide = aq.from(total_fondos)\n .groupby('year')\n.pivot('tipo_fondo', 'amount')\n.objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1303,"value":"with initial_table as (\n select\n *,\n categoria_presupuestaria = 'Desarrollo económico' as desarrollo_economico\n from ter24_by_budget_category\n)\n\nselect\n case\n when desarrollo_economico\n then 'Desarrollo económico'\n else 'Total de categorías remanentes'\n end\n as categoria_presupuestaria,\n \"year\", sum(amount) as amount,\nfrom initial_table\ngroup by desarrollo_economico, \"year\"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"ter24_by_desarrollo_economico","database":"var:ter24_by_budget_category"},{"id":94,"value":"total_fondos = {\n let text = await FileAttachment(\"Tax Expenditure 2023@1.xlsx - Grafica 2.csv\").text();\n text = text.split('\\n').slice(2).join('\\n')\n let data = d3.csvParse(text)\n\n data = aq.from(data)\n .fold(['2017','2018','2019', '2020', '2021', '2022', '2023', '2024', '2025', '2026'], {as: ['year', 'amount']})\n .objects()\n data.forEach(d => {\n d.year = +d.year\n d.amount = +(d.amount.replace(',', ''))\n\n if ((d.tipo_fondo === 'Fondo General') & (d.year === 2022)) {\n d.amount = 13787.8\n }\n })\n \n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"gastos_tributarios_identificados_inicial = await FileAttachment(\"Tax Expenditure 2023@1.xlsx - Grafica 3.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"gastos_tributarios_identificados_inicial","database":"$undefined"},{"id":5,"value":"gastos_tributarios_identificados = {\n let data = structuredClone(gastos_tributarios_identificados_inicial);\n data.forEach(d => {\n d['Porciento de gastos tributarios identificados con estimados'] = +(d['Porciento de gastos tributarios identificados con estimados'].replace('%', '')) /100\n })\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1126,"value":"municipios_with_analisis_preliminar = {\n let thedata = add_data_to_geojson(municipios_geojson, analisis_preliminar, ['municipio', 'Municipio'], 'analisis_preliminar')\n thedata = add_data_to_geojson(thedata, codigos_censales_y_abrev_municipios, ['cntyidfp', 'GEOID'], 'abreviaciones')\n return thedata\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2698,"value":"codigos_censales_y_abrev_municipios","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1121,"value":"analisis_preliminar = {\n let data = await FileAttachment(\"Abataments_Master - Análisis Preliminar.csv\").csv({typed: true})\n\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1186,"value":"abatements_latest_by_type","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"gastos_por_fuente_tributaria = {\n let text = await FileAttachment(\"Tax Expenditure 2023.xlsx - Grafica 7.csv\").text();\n text = text.split('\\n').slice(2)\n text[0] = 'fuente_tributaria'+text[0]\n text = text.join('\\n')\n let data = d3.csvParse(text).filter(d => (d.fuente_tributaria !== \"\") & (d.fuente_tributaria !== \"Total\"))\n\n data = aq.from(data)\n .fold(['2017','2018','2019', '2020', '2021', '2022', '2023', '2024', '2025', '2026'], {as: ['year', 'amount']})\n .objects()\n data.forEach(d => {\n d.year = +d.year\n d.amount = +(d.amount.replace(',', ''))\n d.fuente_tributaria = d.fuente_tributaria.trim()\n })\n \n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"gastos_por_area_y_tipo = {\n return [\n ...presupuesto_por_ingreso.map(d => Object({...d, amount: d.amount/1000, tipo_gasto: 'directo'})),\n ...ter24_by_budget_category.map(d => Object({...d, tipo_gasto: 'indirecto'}))\n ]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"presupuesto_por_ingreso = {\n let data = await FileAttachment(\"presupuesto-por-ingreso-2021@2.csv\").csv({typed: true});\n // return (await FileAttachment(\"presupuesto-por-ingreso@4.csv\").text())\n // text = text.split('\\n').slice(2)\n // text[0] = 'fuente_tributaria'+text[0]\n // text = text.join('\\n')\n // let data = d3.csvParse(text).filter(d => (d.fuente_tributaria !== \"\") & (d.fuente_tributaria !== \"Total\"))\n\n let cols = data.columns;\n data = aq.from(data)\n .fold(cols.filter(d => d !== 'Periodo fiscal'), {as: ['categoria_presupuestaria', 'amount']})\n .rename({'Periodo fiscal': 'year'})\n .objects()\n // data.forEach(d => {\n // d.year = +d.year\n // d.amount = +(d.amount.replace(',', ''))\n // d.fuente_tributaria = d.fuente_tributaria.trim()\n // })\n \n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"ter24_by_budget_category = {\n let data = await FileAttachment(\"ter24_by_budget_category_long.csv\").csv({typed: true})\n\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":633,"value":"with unfiltered_by_type as (\nselect \"Type of Tax\", sum(Abatement) as abatement\nfrom abatements_latest\ngroup by \"Type of Tax\"\n),\n\nwith_other as (\nselect *,\n list_contains(['Personal Property Tax','Real Property Tax','Volume of business taxes', 'Municipal License Tax', 'Construction excise tax'], \"Type of Tax\") as not_other,\n case when not_other then \"Type of Tax\" else 'Otros' end as \"type_tax_with_others\",\nfrom unfiltered_by_type\n)\n\n-- select *\n-- from with_other\n-- order by abatement desc\n\nselect\n \"type_tax_with_others\" as \"Type of Tax\",\n sum(abatement) as \"abatement\",\n first(not_other) as \"not_other\",\nfrom with_other\ngroup by \"type_tax_with_others\"\norder by not_other desc, abatement desc","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"abatements_latest_by_type","database":"var:abatements_db"},{"id":1149,"value":"select 2 as two","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_db"},{"id":657,"value":"select Ley, sum(Abatement) as abatement\nfrom abatements_latest\ngroup by Ley\norder by abatement desc","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"abatements_latest_by_ley","database":"var:abatements_db"},{"id":688,"value":"## Abatements sobre presupuesto municipal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":900,"value":"Plot.plot({\n marginLeft: 100,\n marginRight: 150,\n color: {legend: true, type: 'categorical',\n domain: ['Presupuesto', 'Abatements'],\n range: ['lightblue', 'salmon'],\n },\n x: {tickFormat: '$,.0s'},\n marks: [\n Plot.barX(abatements_y_presupuestos, {\n x1: 0, x2: d => d['presupuesto'], y: \"municipio\",\n fill: 'lightblue',\n channels: {'z': 'abatement_ratio'},\n sort: {y: \"z\", reverse: true}\n }),\n Plot.barX(abatements_y_presupuestos, {\n x1: d => d['presupuesto'], x2: d => d['presupuesto'] + d['abatement'],\n y: \"municipio\",\n fill: 'salmon',\n }),\n Plot.text(abatements_y_presupuestos, {\n x: d => d['presupuesto'] + d['abatement'],\n dx: 10,\n y: \"municipio\", text: d => {\n return (d3.format(\".0f\")(d['abatement_ratio']*100)+'%') + ` (${d3.format(\"$,.2s\")(d.abatement)} / ${d3.format(\"$,.2s\")(d.presupuesto)})`\n },\n textAnchor: 'start',\n }),\n Plot.ruleX([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1028,"value":"abatements_y_presupuestos_comparative = aq.from(abatements_y_presupuestos)\n .fold(['presupuesto', 'abatement'], {as: ['tipo', 'cantidad']})\n .orderby(aq.desc('abatement_ratio'),aq.desc('tipo'))\n.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2367,"value":"abatements_y_presupuestos_comparative_wide = aq.from(abatements_y_presupuestos_comparative)\n .groupby('año', 'municipio')\n.pivot('tipo', 'cantidad')\n // .view()\n.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":989,"value":"$4b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":836,"value":"with initial_table as (\n select\n * replace (Presupuesto as presupuesto),\n abatement/presupuesto as abatement_ratio,\n presupuesto+abatement as presupuesto_and_abatement,\n presupuesto/presupuesto_and_abatement as presupuesto_percent,\n abatement/presupuesto_and_abatement as abatement_percent,\n from total_abatements_municipales\n left join presupuestos_municipales\n using (Municipio, Año)\n)\n\nselect *\nfrom initial_table\norder by abatement_ratio desc, Municipio, Año","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"abatements_y_presupuestos","database":"var:total_abatements_municipales_db"},{"id":1089,"value":"select \"Entidad gubernamental\", sum(Abatement) as abatement\nfrom abatements_latest\ngroup by \"Entidad gubernamental\"\norder by abatement desc","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"abatements_latest_by_entidad","database":"var:abatements_db"},{"id":868,"value":"select distinct Municipio\nfrom ingresos_gastos","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_db"},{"id":863,"value":"select * from presupuestos_municipales\nwhere Municipio = 'Cataño'","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:presupuestos_municipales_db"},{"id":691,"value":"create or replace table presupuestos_municipales as (\n select Municipio, Año, Presupuesto\n from ingresos_gastos\n)","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"creation_presupuestos_municipales","database":"var:abatements_db"},{"id":834,"value":"presupuestos_municipales_db = creation_presupuestos_municipales, abatements_db","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":698,"value":"muni_norm_to_municipio_liststring = {\n const norm_keys = [];\n const read_keys = [];\n const merged_strings = [];\n for (let k of Object.keys(muni_norm_to_municipio)) {\n const rk = muni_norm_to_municipio[k]\n norm_keys.push(k)\n read_keys.push(rk)\n merged_strings.push(`${k}_${rk}`)\n }\n let the_list = JSON.stringify(merged_strings).replaceAll('\"',\"'\")\n return the_list\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":735,"value":"SELECT\n UNNEST(['a_1', 'b_2']) as orig,\n string_split(orig, '_') as thesplit,\n thesplit[1], thesplit[2]\n","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_db"},{"id":760,"value":"test","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":754,"value":"test = abatements_db.query(`\nwith initial_table as (\nselect\n unnest(${muni_norm_to_municipio_liststring}) as original,\n string_split(original, '_') as thesplit,\n thesplit[1] as municipio_norm, thesplit[2] as Municipio\n)\n\nselect municipio_norm, Municipio\nfrom initial_table\n`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":694,"value":"$4c","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":669,"value":"select sum(abatement)\nfrom abatements_latest_by_ley","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_latest_by_ley"},{"id":426,"value":"// Año máximo por municipio\naq.from(abatements_municipales)\n .groupby('Municipio')\n .rollup({'Año': op.max('Año')})\n .orderby('Municipio')\n.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"aq.from(abatements_municipales)\n\n.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":413,"value":"abatements_municipales = {\n let data = await FileAttachment(\"Abataments_Master - DatosMunicipales@5.csv\").csv({typed: true})\n data.forEach(d => {\n // console.log()\n d.Abatement = (typeof d.Abatement === 'string') ? +(d.Abatement.replace(',','').replace('$','')) : d.Abatement\n })\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":776,"value":"select *\nfrom ingresos_gastos\nwhere Año = 2023","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_db"},{"id":769,"value":"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_db"},{"id":441,"value":"$4d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":684,"value":"show tables","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_db"},{"id":444,"value":"abatements_db","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":847,"value":"select *\nfrom abatements_latest","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"abatements_latest","database":"var:abatements_db"},{"id":485,"value":"select \"Type of Tax\", count(*) as count_rows\nfrom abatements_latest\ngroup by \"Type of Tax\"\norder by count_rows desc","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"type_tax_counts","database":"var:abatements_db"},{"id":503,"value":"select Municipio, Año, list(distinct \"Type of Tax\")\nfrom abatements_latest\ngroup by Municipio, Año","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_db"},{"id":883,"value":"total_abatements_municipales = create_total_abatements_municipales, abatements_db.query(`\nselect *\nfrom total_abatements_municipales\n`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"create or replace table total_abatements_municipales as (\nwith initial_table as (\nselect\n Municipio, Año,\n list(distinct \"Type of Tax\") as distinct_tax_types,\n list_contains(distinct_tax_types, 'All') as contains_all_type,\n ['San Juan', 'Vega Baja'] as munis_to_just_sum,\n case\n when list_contains(munis_to_just_sum, Municipio)\n then sum(abatement)\n when contains_all_type\n then sum(abatement) filter (where \"Type of Tax\" = 'All')\n else sum(abatement)\n end as Abatement\nfrom abatements_latest\ngroup by Municipio, Año\n)\n\nselect Municipio as municipio, Año as año, Abatement as abatement\nfrom initial_table\norder by municipio, año\n)","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"create_total_abatements_municipales","database":"var:abatements_db"},{"id":540,"value":"total_abatements_municipales","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":890,"value":"total_abatements_municipales_db = create_total_abatements_municipales, abatements_db","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":567,"value":"select distinct municipio\nfrom total_abatements_municipales\norder by municipio","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:total_abatements_municipales"},{"id":507,"value":"select *\nfrom abatements_latest","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:abatements_latest"},{"id":612,"value":"d3.formatPrefix(\"$,.3\", 10.123)(1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":572,"value":"// los que faltan\nmunicipios_with_total_abatements.features.filter(d => d.properties.total_abatement === undefined).map(d => d.properties.municipio)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"municipios_with_total_abatements = add_data_to_geojson(municipios_geojson, total_abatements_municipales, 'municipio', 'total_abatement')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"# Apendice","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":51,"value":"import { aq, op } from '@uwdata/arquero'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":563,"value":"color_interp = d3.interpolateHcl(EA_COLORES_MAP['INDIGO'], EA_COLORES_MAP['LIME'])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":550,"value":"municipios_geojson","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":544,"value":"import {municipios_geojson, EA_COLORES_MAP} from \"22dc6182207c44c8\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":542,"value":"// Para añadir datos a un objeto Geojson en una propiedad nueva\nfunction add_data_to_geojson(geojson, data, join_key, prop_name = 'data') {\n const gj = structuredClone(geojson);\n let lk, rk;\n if (Array.isArray(join_key)) {\n if (join_key.length === 2) {\n lk = join_key[0];\n rk = join_key[1];\n } else {\n throw new Error('join_key must be a 2-element array or a string')\n }\n } else if (typeof join_key === 'string') {\n lk = join_key; rk = join_key;\n } else {\n throw new Error('join_key must be a 2-element array or a string');\n }\n\n const data_map = {};\n data.forEach(d => {\n let dm = data_map[d[rk]];\n data_map[d[rk]] = dm ? [...dm, d] : [d];\n });\n\n for (let f of gj.features) {\n const p = f.properties;\n p[prop_name] = data_map[p[lk]]\n }\n\n return gj\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4e","stdlib":"1","titling":"auto"}} 30:"$2f:body"