ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '683360' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '683360' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '683360' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '683360' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '683360']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '683360'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 683360 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 683360]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 683360 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 683360

Título del libro:
Título del capítulo: Vote buying detection via independent component analysis

Autores UNAM:
JOSE ANTONIO NEME CASTILLO; OMAR NEME CASTILLO;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2016

---

Palabras clave:

Blind source separation; Data handling; Independent component analysis; Information analysis; Economic incentive; Intelligent data analysis; Me-xico; Mixed signal; Original signal; Presidential election; Public data; Undesired behavior; Economic and social effects

---

Resumen:

Electoral fraud can be committed along several stages. Different tools have been applied to detect the existence of such undesired actions. One particular undesired activity is that of vote-buying. It can be thought of as an economical influence of a candidate over voters that in other circumstances could have decided to vote for a different candidate, or not to vote at all. Instead, under this influence, some citizens cast their votes for the suspicious candidate. We propose in this contribution that intelligent data analysis tools can be of help in the identification of this undesired behavior. We think of the results obtained in the affected ballots as a mixture of two signals. The first signal is the number of votes for the suspicious candidate, which includes his/her actual supporters and the voters affected by an economic influence. The second mixed signal is the number of citizens that did not vote, which is affected also by the bribes or economic incentives. These assumptions allows us to apply an instance of blind source separation, independent component analysis, in order to reconstruct the original signals, namely, the actual number of voters the candidate may have had and the actual number of no voters. As a case of study we applied the proposed methodology to the case of presidential elections in Mexico in 2012, obtained by analyzing public data. Our results are consistent with the findings of inconsistencies through other electoral forensic means. © Springer International Publishing AG 2016.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783319463483
Editorial:
Springer Verlag

Tipo de producto:
Conference Paper

DOI:
10.1007/978-3-319-46349-020