2e:null 2f:["$","title",null,{"children":"Venezolanos rechazados por vía aérea en México (2019-2024) | Fer Aguirre | Observable"}] 34:T43c,*Última actualización: 22/02/2025* ## Acerca de este notebook - Los datos sobre aerolíneas contienen información de 2019 a 2024. ## Fuente de datos - Instituto Nacional de Migración (INM) a través de dos solicitudes de acceso a la información con folios *330020324001228* y *330020325000053*. - [Unidad de Política Migratoria, Registro e Identidad de Personas (UPMRIP)](https://portales.segob.gob.mx/es/PoliticaMigratoria/Direccion_de_Estadistica#est) ## Glosario: - **Eventos:** Las cifras se refieren a eventos debido a que una misma persona pudo haber entrado al país en más de una ocasión o fue rechazada más de una vez. - **Porcentaje de rechazos:** El porcentaje permite evaluar la proporción de eventos de rechazo en comparación con el total de eventos de ingreso. El porcentaje de rechazos se calcula utilizando la siguiente fórmula: ${tex`\text{Porcentaje de Rechazos} = \left( \frac{\text{Eventos de Rechazo}}{\text{Eventos de Rechazo + Eventos de Ingreso}} \right) \times 100`}

35:T4fb,Plot.plot({ width:width, marginRight: 40, marginLeft: 40, height:600, title: "Venezolanos rechazados por año", color: { legend: true, domain: ["Subtotal anual de acuerdo a la UPMRIP¹", "Subtotal anual de acuerdo a solicitud de acceso a la información al INM²"], range: ["#4000ff", "#ff6200"] }, subtitle: "De 2019 a 2024", caption: "Gráfico: Fernanda Aguirre Ruíz • Fuente: Datos de la UPMRIP de 2019 a 2024¹, Datos obtenidos mediante solicitud de acceso a la información al INM de 2019 a 2024²", x:{ label:"Año", ticks:[...new Set(dataFlujoAnual.map(item => item.año))].length}, y:{zero:true, tickFormat:"s", label:"Rechazados", grid: true,}, marks: [ Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "UPMRIP"), {x: "año", y: "total_rechazos", stroke: "#4000ff"}), Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), {x: "año", y: "total_rechazos", stroke: "#ff6200"}), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "UPMRIP").filter(d => d.fuente == "UPMRIP"), {x: "año", y: "total_rechazos", stroke: "#4000ff", fill: "#4000ff"}), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), {x: "año", y: "total_rechazos", stroke: "#ff6200", fill: "#ff6200"}), ] });36:T57a,htl.html`

${Plot.plot({ width: 500, height: 300, marginLeft: 100, insetTop: 20, color: { legend: true }, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "s", zero: true, label: "Eventos", grid: true }, title: "Rechazos a venezolanos vía aérea en México", marks: [ Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.total_rechazos, stroke: "#0003ff", }), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.total_rechazos, fill: "#0003ff", tip: true }), ] })} ${Plot.plot({ width: 500, height: 300, marginLeft: 100, insetTop: 20, color: { legend: true }, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "p", zero: true, label: "Porcentaje", grid: true }, title: "Porcentaje de rechazo a venezolanos vía aérea en México", marks: [ Plot.lineY(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.porcentaje_rechazo, stroke: "#0003ff", }), Plot.dot(dataFlujoAnual.filter(d => d.fuente == "solicitud al INM"), { x: d => +d.año, y: d => +d.porcentaje_rechazo, fill: "#0003ff", tip: true }), ] })}

`37:T558,Plot.plot({ width:width, marginRight: 40, height:600, title: "Porcentaje mensual de rechazados", color: { type: "categorical", domain: dataMesesSolicitud.año, scheme: "YlOrRd", legend: true, }, subtitle: "De 2019 a 2024", caption: "Gráfico: Fernanda Aguirre Ruíz • Fuente: Datos obtenidos mediante solicitud de acceso a la información al INM", x:{ tickFormat: d => { const monthNames = ["Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"]; return monthNames[new Date(2024, d - 1).getMonth()]; }, label:"Mes", ticks:Array.from(d3.group(dataMesesSolicitud, d => d.mes)).length}, y:{zero:true, tickFormat:"p", label:"Porcentaje", grid: true,}, marks: [ Plot.lineY( dataMesesSolicitud, { x: "mes", y:"porcentaje_rechazo", stroke: "año", }), Plot.dot( dataMesesSolicitud, { x: "mes", y: "porcentaje_rechazo", fill: "año", }), Plot.text( dataMesesSolicitud, Plot.selectMaxY({ x: "mes", y: "porcentaje_rechazo", text: d => d.año.toString(), dy: -10, fill: "año", stroke: "white", strokeWidth: 5, }) ) ], });38:T431,Plot.plot({ grid: true, inset: 10, width: width, height: 250, x: { tickFormat: "d", label: "Año", ticks: yearsRange.length}, y: { tickFormat: "s", zero: true, label: "Rechazos", grid: true }, title: "Aerolíneas donde viajan más venezolanos rechazados en México", subtitle: "Desagregados por sexo", color: { legend: true, domain: ["hombre", "mujer", "total"], range: ["#7d2fff", "#ea7500", "#b8b8b8"] }, facet: { data: aerolineasRechazadosFiltered, x: "aerolínea", label: "Aerolínea" }, marks: [ Plot.frame(), Plot.line(aerolineasRechazadosFiltered, {x: "año", y: "hombre", stroke: "#7d2fff"}), Plot.dot(aerolineasRechazadosFiltered, {x: "año", y: "hombre", stroke: "#7d2fff", fill: "white", tip:false}), Plot.line(aerolineasRechazadosFiltered, {x: "año", y: "mujer", stroke: "#ea7500"}), Plot.dot(aerolineasRechazadosFiltered, {x: "año", y: "mujer", stroke: "#ea7500", fill: "white", tip:false}), Plot.line(aerolineasRechazadosFiltered, {x: "año", y: "total", stroke: "#b8b8b8"}), ] })39:T4ee,htl.html`

${d3.groups(groupedRechazosIngresos, (d) => d.aerolínea) .sort((a, b) => d3.descending(a[1].length, b[1].length)) .map(([caption, groupedRechazosIngresos]) => htl.html`

${Plot.plot({ grid: true, inset: 10, width: 250, height: 250, marginTop: 20, marginBottom: 40, insetTop: 20, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "p", zero: true, label: "Porcentaje de rechazos", grid: true }, marks: [ Plot.frame(), Plot.line(groupedRechazosIngresos, {x: "año", y: "per_rechazos", stroke: "#ff0000"}), Plot.dot(groupedRechazosIngresos, {x: "año", y: "per_rechazos", stroke: "#ff0000", fill: "white"}), Plot.text(groupedRechazosIngresos, Plot.selectMaxY( {x: "año", y: "per_rechazos", text: d=> Math.round(d.per_rechazos * 100) + "%", dy: -10, fill: "#606060"}) ), ] })}

${caption}

` )}

`3a:T5d2,htl.html`

hombre mujer

${d3.groups(dataRechazos, (d) => d.aerolínea) .sort((a, b) => d3.descending(a[1].length, b[1].length)) .map(([caption, dataRechazos]) => htl.html`

${Plot.plot({ grid: true, inset: 10, width: 250, height: 250, marginTop: 20, marginBottom: 40, x: { tickFormat: "d", label: "Año"}, y: { tickFormat: "s", zero: true, label: "Rechazos", grid: true }, marks: [ Plot.frame(), Plot.line(dataRechazos, {x: "año", y: "hombre", stroke: "#7d2fff"}), Plot.dot(dataRechazos, {x: "año", y: "hombre", stroke: "#7d2fff", fill: "white", tip:true}), Plot.line(dataRechazos, {x: "año", y: "mujer", stroke: "#ea7500"}), Plot.dot(dataRechazos, {x: "año", y: "mujer", stroke: "#ea7500", fill: "white", tip:true}), ] })}

${caption}

` )}

`3b:T44f,dataFlujoAnual = Object.values( [...dataMesesVen.map(d => ({ año: d.año, mes: d.mes, total_ingresos: d.eventos_de_entrada, total_rechazos: d.rechazados, total_eventos: d.total_de_eventos, fuente: "UPMRIP" })), ...dataMesesSolicitud.map(d => ({ año: d.año, mes: d.mes, total_ingresos: d.eventos_de_entrada, total_rechazos: d.rechazados, total_eventos: d.total_de_eventos, fuente: "solicitud al INM" }))] .reduce((acc, curr) => { const key = `${curr.año}-${curr.fuente}`; if (!acc[key]) { acc[key] = { año: curr.año, fuente: curr.fuente, total_ingresos: 0, total_rechazos: 0, total_eventos: 0 }; } acc[key].total_ingresos += curr.total_ingresos; acc[key].total_rechazos += curr.total_rechazos; acc[key].total_eventos += curr.total_eventos; return acc; }, {}) ).map(item => ({ ...item, porcentaje_rechazo: item.total_eventos > 0 ? item.total_rechazos / item.total_eventos : 0 // Avoid division by zero })).sort((a, b) => b.año - a.año);3c:[] 32:{"id":"13cf8bdb38396448","slug":"venezolanos-rechazados-por-via-aerea-en-mexico","title":"Venezolanos rechazados por vía aérea en México (2019-2024)","thumbnail":"ba1e451e26f04b3da9a6af4a5fc59dbb4aa780e2451867336d4ac114cdc0960c","access_level":"public","create_time":"$D2025-02-21T23:51:32.182Z","update_time":"$D2025-02-22T16:46:15.395Z","view_time":null,"first_public_time":"$D2025-02-21T23:51:32.182Z","has_unpublished_edits":null,"fork":{"id":"9254e367bac6cbe1","slug":"colombianos-rechazados-por-via-aerea-en-mexico","title":"Colombianos rechazados por vía aérea en México (2019-2024)","owner":{"id":"789e6ba9bbf11803","login":"fer-aguirre","name":"Fer Aguirre"}},"stars":0,"starred":false,"owner":{"type":"team","id":"789e6ba9bbf11803","login":"fer-aguirre","name":"Fer Aguirre","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":"starter_2024"},"version":1898,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"11c69ba1437427e2","login":"fer-aguirre","name":"Fernanda Aguirre Ruíz","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":null}],"members":[{"type":"individual","id":"11c69ba1437427e2","login":"fer-aguirre","name":"Fernanda Aguirre Ruíz","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":null,"role":"editor"},{"type":"team","id":"789e6ba9bbf11803","login":"fer-aguirre","name":"Fer Aguirre","avatar_url":"https://avatars-next.observableusercontent.com/f531eb1aface10aa40ec00b9dd17bd5b8a04204b1bccb07e46041ecf2a566a97","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"fe97b49b307e5aea","slug":"migracion-en-mexico","title":"Migración en México","owner":{"id":"789e6ba9bbf11803","login":"fer-aguirre","name":"Fer Aguirre"}},"type":"notebook","body":{"title":"Venezolanos rechazados por vía aérea en México (2019-2024)","cells":[{"id":0,"value":"# Venezolanos rechazados por vía aérea en México (2019-2024)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"$34","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1658,"value":"## Comparación de fuentes de datos\n\nEste dashboard cuenta con dos fuentes de información: los datos públicos de la Unidad de Política Migratoria, Registro e Identidad de Personas (UPMRIP) y datos obtenidos mediante solicitudes de acceso a la información al Instituto Nacional de Migración (INM). \n\nAmbas bases de datos contienen información de 2019 a 2024. Sin embargo, los datos de las solicitudes contienen información desagragada sobre las aerolíneas donde viajaban los venezolanos. Por esta razón, se utilizaron los datos de las solicitudes con el fin de tener la fuente más detallada.\n\nA continuación un gráfico comparativo con el número de rechazados por año de acuerdo a cada fuente.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1645,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":708,"value":"
\n\n## Historial de rechazos a venezolanos en aeropuertos de México\n \n- A partir del año **2020**, comenzó a aumentar el porcentaje de venezolanos que eran rechazados en aeropuertos de México.\n\n- El pico máximo de rechazos se presentó en **2021**.\n\n- A partir de **2022** los rechazos a venezolanos han disminuido. No obstante, desde el 21 de enero de ese mismo año, los venezolanos necesitan [visa](https://embamex.sre.gob.mx/venezuela/index.php/servicios-consulares/18-documentacion-consular/para-extranjeros/20-visas-para-extranjeros) para visitar México como turistas, en tránsito, por negocios, o para estudiar a corto plazo. \n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1811,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1419,"value":"
\n\n

\n\n## Flujo mensual\n\n- **Junio de 2021** ha sido el mes con el porcentaje de rechazo más alto. Durante ese mes, 1 de cada 10 venezolanos que viajó a México por vía aérea, fue rechazado.\n\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1524,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":970,"value":"
\n\n

\n\n## Rechazos por aerolínea\n\n- De acuerdo a los datos, las aerolíneas que concentran la mayoría de los casos son:\n\n${renderTermsMarkdown(topAerolineas)}\n\n- **Copa Airlines** es la aerolínea que concentra la mayoría de los casos.\n\n- Desde **2023**, Copa Airlines y Avianca son las aerolíneas donde más han rechazado a venezolanos\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":417,"value":"Plot.plot({\n width:width,\n height:600,\n color: { legend: true },\n title: \"Venezolanos rechazados de acuerdo a la aerolínea en que viajaban\",\n x:{tickFormat:\"d\", label:\"Año\", ticks: yearsRange.length},\n y: {\n grid: true,\n label: \"Rechazos\",\n tickFormat:\"s\",\n },\n marks: [\n Plot.areaY(\n groupedAerolineasAcumuladas,\n {x:\"año\", y: \"total\", z:\"aerolínea\", fill:\"aerolínea\", offset:null}\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":490,"value":"
\n\n

\n\n## Pocentaje de rechazos por aerolínea \n\nEl porcentaje de rechazos se calculó con relación al número de ingresos de venezolanos con esa misma aerolínea. Para analizar esto en detalle, a continuación se muestran las aerolíneas mencionadas previamente: \n\n- **Avianca** fue la que llegó a tener el porcentaje de rechazo más alto con su punto máximo en 2021.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":604,"value":"Plot.plot({\n grid: true,\n inset: 10,\n width: width,\n height: 250,\n insetTop: 20,\n marginTop: 50,\n marginBottom: 50,\n x: { tickFormat: \"d\", label: \"Año\", ticks: yearsRange.length},\n y: { tickFormat: \"p\", zero: true, label: \"Porcentaje de rechazos\", grid: true },\n title: \"Porcentaje anual de venezolanos rechazados por aerolínea\",\n subtitle: \"De 2019 a julio de 2024\",\n facet: {\n data: groupedAerolineasFiltered,\n x: \"aerolínea\",\n label: \"Aerolínea\"\n },\n marks: [\n Plot.frame(),\n Plot.line(groupedAerolineasFiltered, {x: \"año\", y: \"per_rechazos\", stroke: \"#ff0000\"}),\n Plot.dot(groupedAerolineasFiltered, {x: \"año\", y: \"per_rechazos\", stroke: \"#ff0000\", fill: \"white\", tip:false}),\n Plot.text(groupedAerolineasFiltered, {x: \"año\", y: \"per_rechazos\", text: d=> Math.round(d.per_rechazos * 100) + \"%\", dy: -10, fill: \"#606060\"}),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"
\n\n

\n\n## Perfil de las personas rechazadas\n\n- Los **hombres** son los que recibieron más rechazos sin importar la aerolínea en la que viajaron. Sin ambargo, desde que se implementó la visa para ingresar a México, el rechazo hacia hombres y mujeres se ha equilibrado.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":192,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1281,"value":"
\n\n

\n\n## Grupos etarios de los rechazados\n\n- El grupo etario de hombres que recibe más rechazos es de **30 a 39** años. Mientras que en mujeres es de **20 a 29** años.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1189,"value":"Plot.plot({\n width: width,\n height: 400,\n marginLeft: 100,\n insetTop: 50,\n title: \"Grupos etarios de hombres rechazados por año\",\n x: {\n axis: null,\n domain: dataGruposEtariosFiltered.año,\n },\n y: {\n grid: true,\n tickFormat: \"s\"\n },\n color: {\n domain: dataGruposEtariosFiltered.grupo_etario,\n scheme: \"spectral\",\n legend: true\n },\n fx: {\n domain: d3.groupSort(dataGruposEtariosFiltered, d => -d.hombre, d => d.año),\n label: null,\n tickSize: 6\n },\n facet: {\n data: dataGruposEtariosFiltered,\n x: \"año\"\n },\n marks: [\n Plot.barY(dataGruposEtariosFiltered, {x: \"grupo_etario\", y: \"hombre\", fill: \"grupo_etario\", title: \"grupo_etario\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1269,"value":"Plot.plot({\n width: width,\n height: 400,\n marginLeft: 100,\n insetTop: 50,\n title: \"Grupos etarios de mujeres rechazadas por año\",\n x: {\n axis: null,\n domain: dataGruposEtariosFiltered.año,\n },\n y: {\n grid: true,\n tickFormat: \"s\"\n },\n color: {\n domain: dataGruposEtariosFiltered.grupo_etario,\n scheme: \"magma\",\n legend: true\n },\n fx: {\n domain: d3.groupSort(dataGruposEtariosFiltered, d => -d.mujer, d => d.año),\n label: null,\n tickSize: 6\n },\n facet: {\n data: dataGruposEtariosFiltered,\n x: \"año\"\n },\n marks: [\n Plot.barY(dataGruposEtariosFiltered, {x: \"grupo_etario\", y: \"mujer\", fill: \"grupo_etario\", title: \"grupo_etario\"}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1860,"value":"
\n\n

\n\n## ¿Cómo viajaron los venezolanos que fueron rechazados en 2024?\n\nEste gráfico visualiza el país del vuelo proveniente y la aerolínea con la que viajaron.\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1862,"value":"sankeyAerolineas = SankeyChart({\n links: sankeyAerolineaRechazosData,\n}, {\n nodeGroup: d => d.id.split(/\\W/)[0],\n format: (f => d => `${f(d)} TWh`)(d3.format(\",.1~f\")),\n width,\n height: 1000,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1869,"value":"
\n\n

\n\n## ¿De qué países provenían los vuelos de los venezolanos que viajaron en ${airline} en 2024?\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1875,"value":"**Selecciona una aerolínea:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1873,"value":"viewof airline = Inputs.select(Array.from(d3.group(sankeyAerolineaData, d => d.aerolínea).keys()).sort())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1877,"value":"**Selecciona un status:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1879,"value":"viewof statusAirlines = searchCheckbox( \n [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).map(item => item.target))].sort(), \n {\n value: [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).map(item => item.target))].sort(),\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1881,"value":"**Selecciona uno o varios países:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1883,"value":"viewof countriesAirlines = searchCheckbox( \n [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).filter(d => statusAirlines.includes(d.target)).map(item => item.source))].sort(), \n {\n value: [...new Set(sankeyAerolineaData.filter(d => d.aerolínea == airline).filter(d => statusAirlines.includes(d.target)).map(item => item.source))].sort(),\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1885,"value":"sankeyPaises = SankeyChart({\n links: sankeyFiltered\n}, {\n nodeGroup: d => d.id.split(/\\W/)[0],\n format: (f => d => `${f(d)} TWh`)(d3.format(\",.1~f\")),\n width,\n height: countriesAirlines.length / 5 * 100 \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":823,"value":"
\n\n

\n\n## Explora los datos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":38,"value":"**Selecciona una o varias aerolíneas:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":40,"value":"viewof aerolineaSelection = searchCheckbox( \n [...new Set(dataRechazos.map(item => item.aerolínea))].sort(), \n {\n value: [...new Set(dataRechazos.map(item => item.aerolínea))].sort(),\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"Plot.plot({\n width: width,\n height: 600,\n marginLeft: 100,\n insetTop: 50,\n color: { legend: true },\n x: { tickFormat: \"d\", label: \"Año\", ticks: yearsRange.length},\n y: { tickFormat: \"s\", zero: true, label: \"Rechazos\", grid: true },\n title: \"Aerolíneas donde viajan venezolanos rechazados en México\",\n subtitle: \"De 2019 a julio de 2024\",\n marks: [\n Plot.lineY(aerolineaSelected, {\n x: d => +d.año,\n y: d => +d.total,\n stroke: \"aerolínea\",\n }),\n Plot.dot(aerolineaSelected, {\n x: d => +d.año,\n y: d => +d.total,\n fill: \"aerolínea\",\n tip: true\n }),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":851,"value":"
\n\n

\n\n## Rechazos por aeropuerto","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":321,"value":"**Selecciona una aerolínea:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":325,"value":"viewof aerolinea = Inputs.select(Array.from(d3.group(dataRechazosAeropuertos, d => d.aerolínea).keys()).sort())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"Plot.plot({\n width: width,\n height: 600,\n marginLeft: 100,\n color: { legend: true },\n x: { tickFormat: \"d\", label: \"Año\", ticks: yearsRange.length},\n y: { tickFormat: \"s\", zero: true, label: \"Rechazos\", grid: true },\n title: `Aeropuertos donde rechazaron a venezolanos que viajaron en ${aerolinea}`,\n subtitle: \"De 2019 a julio de 2024\",\n marks: [\n Plot.lineY(aerolineaAeropuerto, {\n x: d => +d.año,\n y: d => +d.total,\n stroke: \"aeropuerto\",\n }),\n Plot.dot(aerolineaAeropuerto, {\n x: d => +d.año,\n y: d => +d.total,\n fill: \"aeropuerto\",\n tip: true\n }),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"
\n\n

\n\n## Porcentaje anual de venezolanos rechazados por aerolínea","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":637,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"
\n\n

\n\n## Sexo de venezolanos rechazados por aerolínea","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":141,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"
\n\n

\n\n### Code section","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":448,"value":"csvURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vREs9CMFhX-xpOU--Gc-Xahk3GPPNLqYgTe7zduoFwIdcprrixtuMA7b8fWUZRa6g/pub?gid=1197861129&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"dataRaw = d3.csv(csvURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"data = dataRaw.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n hombre: parseInt(item.hombre),\n mujer: parseInt(item.mujer),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":472,"value":"dataRechazos = data.filter(d => d.tipo == \"rechazos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1116,"value":"dataIngresos = data.filter(d => d.tipo == \"ingresos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"yearsRange = Array.from(new Set(data.map(d => d.año))).sort((a, b) => a - b)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1747,"value":"totalAerolineas = Array.from(\n d3.rollup(\n dataRechazos,\n v => d3.sum(v, d => d.total), // Summing the 'total' for each group\n d => d.aerolínea // Grouping by 'aerolínea'\n ),\n ([aerolínea, total]) => ({ aerolínea, total }) // Mapping the result to an array of objects\n).sort((a, b) => b.total - a.total); // Sorting in descending order based on total","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1756,"value":"topAerolineas = totalAerolineas.slice(0, 6).map(item => item.aerolínea)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"aerolineasAcumuladasRechazos = dataRechazos.map(d => ({\n ...d,\n aerolínea: topAerolineas.includes(d.aerolínea) ? d.aerolínea : \"Otra\"\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"groupedAerolineasAcumuladas = Array.from(\n d3.rollup(\n aerolineasAcumuladasRechazos, \n v => d3.sum(v, d => d.total), // Summing the 'total' for each group\n d => d.aerolínea, // First level of grouping by 'aerolínea'\n d => d.año // Second level of grouping by 'año'\n )\n).flatMap(([aerolínea, yearValues]) => \n Array.from(yearValues, ([año, total]) => ({\n aerolínea: aerolínea,\n año: año,\n total: total\n }))\n).sort((a, b) => b.año - a.año)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"groupedRechazosIngresos = Array.from(\n d3.rollup(\n data,\n v => {\n const total_rechazos = d3.sum(v.filter(d => d.tipo === \"rechazos\"), d => d.total); // Sum for 'rechazos'\n const total_ingresos = d3.sum(v.filter(d => d.tipo === \"ingresos\"), d => d.total); // Sum for 'ingresos'\n return {\n total_rechazos,\n total_ingresos,\n total: total_rechazos + total_ingresos // Calculate total\n };\n },\n d => d.aerolínea, // Group by 'aerolínea'\n d => d.año // Then group by 'año'\n ),\n ([aerolinea, años]) => \n Array.from(años, ([año, totals]) => ({\n aerolínea: aerolinea,\n año: año,\n total_rechazos: totals.total_rechazos,\n total_ingresos: totals.total_ingresos,\n total: totals.total,\n per_rechazos: (totals.total_rechazos / totals.total),\n per_ingresos: (totals.total_ingresos / totals.total)\n }))\n).flat().sort((a, b) => a.año - b.año)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"groupedAerolineasFiltered = groupedRechazosIngresos.filter(d => topAerolineas.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"aerolineaSelected = dataRechazos.filter(d => aerolineaSelection.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"aerolineasFiltered = data.filter(d => topAerolineas.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"aerolineasRechazadosFiltered = dataRechazos.filter(d => topAerolineas.includes(d.aerolínea))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1840,"value":"**Grupos etarios**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1173,"value":"csvGruposEtariosURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vREs9CMFhX-xpOU--Gc-Xahk3GPPNLqYgTe7zduoFwIdcprrixtuMA7b8fWUZRa6g/pub?gid=574363938&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1175,"value":"dataGruposEtariosRaw = d3.csv(csvGruposEtariosURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1182,"value":"dataGruposEtarios = dataGruposEtariosRaw.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n hombre: parseInt(item.hombre),\n mujer: parseInt(item.mujer),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1266,"value":"dataGruposEtariosFiltered = dataGruposEtarios.filter(d => d.tipo == \"rechazos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1846,"value":"**País de vuelo proveniente**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1848,"value":"csvAerolineaPaises = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vREs9CMFhX-xpOU--Gc-Xahk3GPPNLqYgTe7zduoFwIdcprrixtuMA7b8fWUZRa6g/pub?gid=1182285066&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1850,"value":"arolineaPaisesRawData = d3.csv(csvAerolineaPaises)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1852,"value":"arolineaPaisesData = arolineaPaisesRawData.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1854,"value":"sankeyAerolineaRechazosData = arolineaPaisesData.filter(d => d.tipo == \"rechazos\").map(({ país_de_vuelo_proveniente, total, aerolínea}) => ({\n source: país_de_vuelo_proveniente,\n target: aerolínea,\n value: total,\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1856,"value":"sankeyAerolineaData = arolineaPaisesData.map(({ tipo, país_de_vuelo_proveniente, total, aerolínea}) => ({\n source: país_de_vuelo_proveniente,\n target: tipo,\n value: total,\n aerolínea: aerolínea\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1858,"value":"sankeyFiltered = sankeyAerolineaData.filter(d => d.aerolínea == airline).filter(d => countriesAirlines.includes(d.source)).filter(d => statusAirlines.includes(d.target))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1842,"value":"**Aeropuertos**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":315,"value":"csvAeropuertosURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vREs9CMFhX-xpOU--Gc-Xahk3GPPNLqYgTe7zduoFwIdcprrixtuMA7b8fWUZRa6g/pub?gid=135169198&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"rawDataAeropuertos = d3.csv(csvAeropuertosURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"dataAeropuertos = rawDataAeropuertos.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n hombre: parseInt(item.hombre),\n mujer: parseInt(item.mujer),\n total: parseInt(item.total),\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1496,"value":"dataRechazosAeropuertos = dataAeropuertos.filter(item => item.tipo == \"rechazos\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":328,"value":"aerolineaAeropuerto = dataRechazosAeropuertos.filter( d => d.aerolínea == aerolinea)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"groupedAeropuertos = Array.from(\n d3.rollup(\n dataRechazosAeropuertos, \n v => d3.sum(v, d => d.total), // Summing the 'total' for each group\n d => d.aeropuerto, // First level of grouping by 'aeropuerto'\n d => d.año // Second level of grouping by 'año'\n )\n).flatMap(([aeropuerto, yearValues]) => \n Array.from(yearValues, ([año, total]) => ({\n aeropuerto: aeropuerto,\n año: año,\n total: total\n }))\n).sort((a, b) => a.año - b.año)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1474,"value":"import {data as dataMeses} from \"@fer-aguirre/extranjeros-rechazados-por-via-aerea-en-mexico\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1479,"value":"dataMesesVen = dataMeses.filter(item => \n item.pais === \"Venezuela\" && \n yearsRange.includes(item.año)\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1844,"value":"**Desagregados por meses**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1511,"value":"csvMesesSolicitudURL = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vREs9CMFhX-xpOU--Gc-Xahk3GPPNLqYgTe7zduoFwIdcprrixtuMA7b8fWUZRa6g/pub?gid=927942835&single=true&output=csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1513,"value":"dataMesesSolicitudRaw = d3.csv(csvMesesSolicitudURL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1515,"value":"dataMesesSolicitud = dataMesesSolicitudRaw.map(item => {\n return {\n ...item,\n año: parseInt(item.año),\n mes: parseInt(item.mes),\n eventos_de_entrada: parseInt(item.eventos_de_entrada),\n rechazados: parseInt(item.rechazados),\n total_de_eventos: parseInt(item.total_de_eventos),\n porcentaje_rechazo: parseFloat(d3.format(\".2f\")(item.porcentaje_rechazo.replaceAll(\",\", \".\")))\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1692,"value":"$3b","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1825,"value":"**Functions**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1827,"value":"renderTermsMarkdown = (array) => \n array.map(item => ` - ${item}`).join('\\n')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"### Libraries","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":25,"value":"import {searchCheckbox} from \"@john-guerra/search-checkbox\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1823,"value":"marked = require('marked')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1864,"value":"import {SankeyChart} from \"@d3/sankey-component\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3c","stdlib":"1","titling":"auto"}} 33:"$32:body"