Thank you for your answer.
Description
TUBOS ENDOBRONQUIAL PARA INTUBACION DE BRONQUIO IZQUIERDO, DE PLASTICO, GRADO MEDICO, CON DISEYO DEL GLOBO BRONQUIAL EN FORMA DE "BARRIL" QUE PERMITE SU SELLADO, CON MARCAS NUMERICAS PARA DETERMINAR LA PROFUNDIDAD DE LA COLOCACION
IMSS product code
060.908.0502.04
Each circle represents one of the 166 purchases of TUBOS made by the IMSS between 2009 and 2019.
| INSTITUTION | STATE | QUANTITY | TOTAL AMOUNT | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | LAST PURCHASE |
|---|---|---|---|---|---|---|---|
| H. de Oncología, Centro Médico Nacional Siglo XXI Umae Oncologia C.m.n. Siglo Xxi | Ciudad de México | 24 | 199,028.5 MXN | 16,108.9 MXN | 9.92 % | 18.5 | 17 de octubre de 2018 |
| H. de Especialidades Cardiológicas No. 34, Centro Médico Nacional del Noreste. Umae Cardiologia En Nuevo Leon | Nuevo León | 20 | 488,291.5 MXN | 153,515.6 MXN | 37.7 % | 146.2 | 24 de diciembre de 2018 |
| H. de Especialidades No. 1 Centro Médico Nacional del Bajio, León, Gto. Umae Especialidades Guanajuato | Guanajuato | 20 | 78,050.3 MXN | 9,904.7 MXN | 26.8 % | 13.1 | 25 de octubre de 2018 |
| H. de Especialidades, "Gral. Div. Manuel Avila Camacho", Centro Médico Nacional, Puebla Umae Especialidades Puebla | Puebla | 19 | 144,822.9 MXN | 11,038.7 MXN | 19.5 % | 14.7 | 25 de octubre de 2018 |
| H. de Especialidades Núm 71, Torreón, Coahuila Umae Especialidades Coahuila | Coahuila | 17 | 170,102.7 MXN | 33,146.6 MXN | 70.9 % | 38.2 | 29 de octubre de 2018 |
| H. de Especialidades No. 2, "Luis Donaldo Colosio Murrieta", Centro Médico Nacional del Noroeste, Cd. Obregón Sonora Umae Especialidades Sonora | Sonora | 14 | 114,372.6 MXN | 27,931.7 MXN | 36 % | 34.5 | 10 de agosto de 2018 |
| Oficinas Centrales Ofnas Centrales -reforma- Coordinacion De Abastecimiento | 10 | 1.1 millones MXN | 93,130.4 MXN | 12.4 % | 114.2 | 2 de enero de 2019 | |
| Delegación Sinaloa Almacen Delegacional En Sinaloa | Sinaloa | 8 | 51,194.3 MXN | 15,372.8 MXN | 42.7 % | 15.8 | 9 de enero de 2014 |
| H. de Especialidades No. 1, "Lic. Ignacio García Tellez" Mérida, Yucatán. Umae Especialidades Yucatan | Yucatán | 6 | 10,906.3 MXN | 1,915 MXN | 26.8 % | 2.5 | 28 de febrero de 2014 |
| H. General, "Dr. Gaudencio González Garza" Centro Médico Nacional La Raza Umae Hospital General C.m.n. La Raza | Ciudad de México | 5 | 200,815.9 MXN | 33,273.8 MXN | 23.6 % | 35.6 | 21 de marzo de 2014 |
| Delegación Baja California | Baja California | 4 | 5,174.2 MXN | 217.3 MXN | 3.89 % | 0.181 | 15 de octubre de 2016 |
| Delegación Aguascalientes Almacen Delegacional En Aguascalientes | Aguascalientes | 3 | 8,843.9 MXN | 149.6 MXN | 6.42 % | 0.193 | 29 de agosto de 2016 |
| H. de Especialidades, "Lic. Ignacio García Tellez" Centro Médico Nacional de Occidente, Jalisco Umae Especialidades Jalisco | Jalisco | 3 | 9,700.4 MXN | 910.8 MXN | 11.6 % | 1.35 | 28 de febrero de 2011 |
| H. de Especialidades No. 14 "Adolfo Ruíz Cortines", Veracruz. Umae Especialidades Veracruz (nte.) | Veracruz | 3 | 10,639.5 MXN | 1,050.1 MXN | 12.2 % | 1.53 | 22 de octubre de 2012 |
| H. de Especialidades Núm 71, Torreón, Coahuila | Coahuila | 3 | 18,480 MXN | 7,188.4 MXN | 64.2 % | 6.7 | 11 de febrero de 2016 |
| Delegación Aguascalientes | Aguascalientes | 2 | 2,228.8 MXN | 177.5 MXN | 9.13 % | 0.212 | 14 de junio de 2016 |
| Delegación Guerrero Almacen Delegacional En Guerrero | Guerrero | 1 | 3,947.4 MXN | 3,104.8 MXN | 368.5 % | 3.68 | 4 de septiembre de 2009 |
| Delegación Guerrero | Guerrero | 1 | 3,970.4 MXN | 3,001.4 MXN | 309.7 % | 3.56 | 29 de enero de 2009 |
| Delegación Michoacán Almacen Delegacional En Michoacan | Michoacán | 1 | 2,275.9 MXN | 457.1 MXN | 25.1 % | 0.503 | 27 de septiembre de 2018 |
| Delegación Zacatecas Almacen Delegacional En Zacatecas | Zacatecas | 1 | 2,175 MXN | 356.2 MXN | 19.6 % | 0.392 | 17 de octubre de 2018 |
| H. de Especialidades No. 14 "Adolfo Ruíz Cortines", Veracruz. | Veracruz | 1 | 4,197.9 MXN | - MXN | - | - | 9 de agosto de 2012 |
| SUPPLIER | PURCHASES | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | TIME PERIOD |
|---|---|---|---|---|---|
| MALLINCKRODT MEDICAL, S.A. DE C.V. | 25 | 36,069.3 MXN | 9.5 % | 52.2 | 2009 - 2012 |
| ESCAMILLA ZENTENO AURORA | 19 | 17,736.4 MXN | 15.3 % | 23.9 | 2009 - 2014 |
| GRUPO MORAVI, S.A. DE C.V. | 17 | 47,902.2 MXN | 31 % | 58.3 | 2009 - 2018 |
| SUMINISTRADOR UTENC. MED. SALUD Y BIENEST., SA CV | 10 | 2,562.5 MXN | 7.79 % | 2.83 | 2015 - 2018 |
| KENDALL DE MEXICO, S.A. DE C.V. | 9 | 33,859.6 MXN | 1.64 % | 37.3 | 2013 - 2017 |
| EL CIRUJANO, S.A DE C.V | 8 | 21,273.4 MXN | 130.7 % | 23.5 | 2013 - 2016 |
| GRUPO EMEQUR, S.A. DE C.V. | 7 | 356.2 MXN | 2.8 % | 0.392 | 2016 - 2018 |
| SERVICIOS INTEGRALES DE APOYO MEDICOS, SA DE CV | 7 | 3,955.1 MXN | 42.2 % | 4.85 | 2009 - 2013 |
| PROVEEDORA NACIONAL DE MAT. DE CURACION, SA DE CV | 6 | 1,629.9 MXN | 9.35 % | 2.1 | 2014 - 2016 |
| UCIN MEDICA, S. A. DE C. V. | 6 | 1,264.4 MXN | 9.76 % | 1.81 | 2009 - 2018 |
| COMERCIAL HOSPITALARIA S.A DE C.V. | 4 | 2,830.1 MXN | 44 % | 2.98 | 2016 - 2018 |
| DURFA, S. A. DE C. V. | 4 | 113,519.3 MXN | 82.1 % | 101 | 2016 - 2017 |
| FRANCISCO GARCIA LOPEZ, S.A. DE C.V. | 4 | 38,210.2 MXN | 60.5 % | 39.7 | 2013 - 2019 |
| PROMEDICA GARCIA, S. A. DE C. V. | 4 | 1,571 MXN | 34.8 % | 1.99 | 2010 - 2018 |
| ARTIMEDICA, S.A. DE C.V. | 3 | 5,157.8 MXN | 31.2 % | 5.72 | 2013 - 2014 |
| GOPY MEDICAL S.A DE C.V. | 3 | 19,241.7 MXN | 53 % | 22.9 | 2009 - 2013 |
| COMERCIALIZADORA ARVIEN, S.A. DE C.V. | 2 | 975.9 MXN | 16.5 % | 1.26 | 2015 - 2015 |
| CORPORACION ARMO, S.A. DE C.V. | 2 | 29,808.1 MXN | 26.7 % | 28.6 | 2014 - 2014 |
| ESPECIALIDADES TECNOLOGICAS AMEX, SA DE CV | 2 | 3,986.7 MXN | 25.5 % | 3.82 | 2014 - 2014 |
| INSTRUMENTOS Y ACCESORIOS AUTOMATIZADOS, S.A. DE C | 2 | 1,021.6 MXN | 21 % | 1.51 | 2010 - 2010 |
| MANRIQUEZ GUADARRAMA MA. | 2 | 6,106.1 MXN | 339.1 % | 7.25 | 2009 - 2009 |
| MEDICA DALI, S. A. DE C. V. | 2 | 3,481.4 MXN | 33.4 % | 3.34 | 2014 - 2014 |
| SISTEMAS HOSPITALARIOS DALCA S.A DE C.V. | 2 | 4,316.6 MXN | 53 % | 6.36 | 2010 - 2010 |
| SOLUCIONES INTEGRALES MEDICAS, SA DE CV | 2 | 2,764.7 MXN | 101.9 % | 4.07 | 2010 - 2010 |
| ABASTECEDORA MEDICA HOSPITALARIA DE AGS SA DE C V | 1 | 177.5 MXN | 18.3 % | 0.212 | 2013 - 2013 |
| ADMINISTRACION GLOBAL MU?OZ, S. A. DE C. V. | 1 | - MXN | - | - | 2013 - 2013 |
| AVISA MEDICAL, S.A. DE C.V. | 1 | 149.6 MXN | 19.3 % | 0.193 | 2015 - 2015 |
| COMERCIALIZADORA MEDICA DEL OSO, S.A. DE C.V. | 1 | 5,101.5 MXN | 60.9 % | 6.09 | 2013 - 2013 |
| CONTINENTAL MEXICANA DE PRODUCTOS, S.A. DE C.V. | 1 | 1,023.3 MXN | 12.1 % | 0.85 | 2016 - 2016 |
| DISTRIBUIDORA ESPEC. DE MEDICAMENTOS KM, SA DE CV | 1 | 630.3 MXN | 75.2 % | 0.752 | 2013 - 2013 |
| DISTRIBUIDORES MEDICOS DE EXELENCIA DIMEEX, S.A. D | 1 | - MXN | - | - | 2016 - 2016 |
| GOMEN HEALTH CARE, S.A. DE C.V. | 1 | 1,621.8 MXN | 59.4 % | 1.78 | 2018 - 2018 |
| Proveedor local no identificado (Compra Emergente) | 1 | - MXN | - | - | 2016 - 2016 |
| RUIZ ESPARZA ARELLANO GERARDO | 1 | - MXN | - | - | 2016 - 2016 |
| SERVICIOS E INSUMOS INSTITUCIONALES DEL NOROESTE D | 1 | 217.3 MXN | 15.6 % | 0.181 | 2016 - 2016 |
| SERVICIOS EMPRESARIALES DE DIST. MEDICAS, S DE RL | 1 | 204.6 MXN | 6.1 % | 0.244 | 2013 - 2013 |
| SOPORTE HOSPITALARIO CENTRAL SA DE CV | 1 | 1,977.6 MXN | 93.3 % | 1.87 | 2017 - 2017 |
| VALLEJO GUANI LAURA CRISTINA | 1 | 1,247.6 MXN | 36.8 % | 1.84 | 2010 - 2010 |
Date updated in QQW
3 de octubre de 2022
Source(s)
Part of the project
Organization responsible for the import
Information from QuienEsQuien.wiki can be reused without asking for permission, as long as you cite us as the source and use the CC-BY-SA license for your publications.
If you cannot comply with these requirements, please contact us and tell us about your project.
The information gathered on QuiénEsQuién.Wiki comes from public and official sources, such as Compranet and the BMV. If you find that it is inaccurate or contains errors, those are errors in the original sources.
If the information presented about {title} is not correct, please contact us reporting the incorrect information and where we can obtain the correct information. We offer to accompany you in filing a claim with the corresponding entities.
Unfortunately it is very common for companies and people not to fulfill their commitments when providing goods or services. In case of non-compliance in Mexico you can go to Profeco and file a complaint or report as appropriate. If you are the victim of cyber fraud, we invite you to read this guide from the Campaña Nacional Antifraude Cibernético.
If you are the victim of extortion, take screenshots of the messages you received and go to the public prosecutor's office to request protection, or call 088 for guidance on filing the corresponding report. Recommendations for reporting phone extortion. If the extortionists have explicitly mentioned QuienEsQuien.wiki in their messages, please send us a copy of the messages.
If you want to request quotes, offer your services, file claims against companies or contact people, we recommend looking for their official website or using another means of contact. QuienEsQuien.wiki is not an advertising site and has no contact with the companies and people mentioned on the site.
Choose the system where you want to use the data to see the instructions. For research methodology, see the Manual for investigating open contracting.
Add this to your code:
library(rjson)
#Read JSON data into R
data <- fromJSON(file="http://localhost:10010/v3/products?limit=1&sort=&embed=true&db_prefix=&id=060.908.0502.04")
Add this to your code:
import json, urllib
#Read JSON data into python
response = urllib2.urlopen('http://localhost:10010/v3/products?limit=1&sort=&embed=true&db_prefix=&id=060.908.0502.04')
data = json.loads(response.read())
Add this to your code:
import pandas as pd
#Read JSON data into pandas
df = pd.read_json('http://localhost:10010/v3/products?limit=1&sort=&embed=true&db_prefix=&id=060.908.0502.04')