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 = '456651' 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 = '456651' 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 = '456651' 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 = '456651' 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 = '456651']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '456651'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 456651 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= 456651]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 456651 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= 456651

Título del libro: Risk Factors Linked To Influenza-Like Illness As Identified From The Mexican Participatory Surveillance System "reporta"
Título del capítulo: Risk factors Linked to Influenza-like Illness as Identified from the Mexican Participatory Surveillance System ``Reporta''

Autores UNAM:
CHRISTOPHER RHODES STEPHENS; VICTOR MIRELES CHAVEZ; JUAN ARTURO HERRERA ORTIZ; NATALIA BARBARA MANTILLA BENIERS;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2017

---

Palabras clave:

Participatory surveillance system; influenza; risk factors

---

Resumen:

Internet-based monitoring of influenza-like illnesses (ILI) has become more common since its beginnings over a decade ago, both through estimates based on the number of searches for influenza-related terms (e.g., Google flu trends), or by means of participatory surveillance systems. The latter, often seen as ways of engaging people in matters of scientific and public health importance, gather a wealth of potentially valuable epidemiological information complementary to that obtained through the established disease surveillance networks and also usually absent from search-based web algorithms. We present a statistical analysis of the data from the Mexican monitoring website ``Reporta'' by which the risk factors linked to reporting of ILI symptoms as outcome among its participants are determined, and interpret these results based on current knowledge of the factors that influence transmission of infection resulting in disease. Besides standard factors associated with enhanced susceptibility to infection some novel behavioral factors linked to high risk were: (i) use of public transport; (ii) frequent contact with animals, and (iii) use of non-standard interventions, such as homeopathy. While close contact with large groups of people in public transportation is generally assumed to be important in disease spread, frequent contact with animals is not. Our results are consistent with previous observations that animals may serve as mobile fomites and hence increase the propensity to develop disease. We conclude that analysis of rich information sets from Internet-based systems may suggest novel ideas on disease spread that are worth following up with field research.

---

Entidades citadas de la UNAM:

---

Fuente:



ISBN:
9781450352499
Editorial:
Association for Computing Machinery

Tipo de producto:
Proceedings Paper

DOI:
10.1145/3079452.3079471