Thank you for your answer.
Description
TUBOS. ENDOTRAQUEALES DE PLASTICO GRADO MEDICO, TRANSPARENTE, CON GLOBO Y ESPIRAL DE ALAMBRE, CON BALON Y CONECTOR, OPACO A LOS RAYOS X. ESTERIL.ONGITUD. 28-30 CM CALIBRE 30 FR.
IMSS product code
060.167.8204.11
Each circle represents one of the 121 purchases of TUBOS made by the IMSS between 2013 and 2019.
| INSTITUTION | STATE | QUANTITY | TOTAL AMOUNT | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | LAST PURCHASE |
|---|---|---|---|---|---|---|---|
| Delegación Baja California | Baja California | 54 | 112,939.4 MXN | 42,783.4 MXN | 71.3 % | 383.6 | 22 de enero de 2016 |
| Delegación Chihuahua | Chihuahua | 13 | 53,637.2 MXN | 33,719.7 MXN | 639.3 % | 320.5 | 8 de diciembre de 2016 |
| Delegación Baja California Almacen Delegacional En Baja California Norte | Baja California | 7 | 76,852.8 MXN | 37,014.5 MXN | 99 % | 388.5 | 10 de agosto de 2018 |
| Oficinas Centrales Ofnas Centrales -reforma- Coordinacion De Abastecimiento | 6 | 737,438.7 MXN | 483.4 MXN | 0.0512 % | 4.79 | 12 de diciembre de 2017 | |
| Delegación Nayarit | Nayarit | 5 | 520.5 MXN | 169.2 MXN | 19.3 % | 1.12 | 27 de mayo de 2013 |
| H. de Especialidades No. 14 "Adolfo Ruíz Cortines", Veracruz. Umae Especialidades Veracruz (nte.) | Veracruz | 5 | 124,001.4 MXN | 26,058.7 MXN | 60 % | 267.4 | 1 de junio de 2017 |
| Delegación Morelos | Morelos | 4 | 3,139 MXN | 1,539.3 MXN | 96.1 % | 11.2 | 26 de junio de 2015 |
| H. de Traumatología y Ortopedia, "Gral. Div. Manuel Avila Camacho", Centro Médico Nacional, Puebla Umae Traumatologia Y Ortopedia Puebla | Puebla | 4 | 40,787 MXN | 23,140.7 MXN | 130.5 % | 249.8 | 8 de octubre de 2018 |
| Delegación Michoacán Almacen Delegacional En Michoacan | Michoacán | 3 | 28,780.5 MXN | 14,369.2 MXN | 99.7 % | 156.5 | 27 de noviembre de 2017 |
| Delegación Morelos Almacen Delegacional En Morelos | Morelos | 3 | 4,997.5 MXN | 3,039.4 MXN | 152.6 % | 34.2 | 15 de noviembre de 2018 |
| Delegación Coahuila Almacen Delegacional En Coahuila | Coahuila | 2 | 2,030 MXN | 1,103.4 MXN | 132.9 % | 12 | 14 de febrero de 2017 |
| Delegación Sonora Almacen Delegacional En Sonora | Sonora | 2 | 2,088 MXN | 1,684 MXN | 416.8 % | 16.7 | 6 de junio de 2014 |
| H. de Especialidades No. 1, "Lic. Ignacio García Tellez" Mérida, Yucatán. Umae Especialidades Yucatan | Yucatán | 2 | 27,916.5 MXN | 5,949.4 MXN | 57.4 % | 68.8 | 5 de noviembre de 2018 |
| H. de Traumatología y Ortopedia, Núm. 21, Monterrey, N.L. Umae Traumatologia Y Ortopedia Nuevo Leon | Nuevo León | 2 | 29,925.9 MXN | 10,214.3 MXN | 100.7 % | 91.5 | 12 de abril de 2017 |
| Delegación Guanajuato Almacen Delegacional En Guanajuato | Guanajuato | 1 | 371.2 MXN | 198.3 MXN | 114.7 % | 2.29 | 29 de octubre de 2018 |
| Delegación Nayarit Almacen Delegacional En Nayarit | Nayarit | 1 | 1,403.6 MXN | - MXN | - | - | 6 de mayo de 2013 |
| Delegación Querétaro Almacen Delegacional En Queretaro | Querétaro | 1 | 9,256.4 MXN | 1,276.7 MXN | 16 % | 4.64 | 21 de enero de 2019 |
| Delegación San Luis Potosí Almacen Delegacional En San Luis Potosi | San Luis Potosi | 1 | 5,602.8 MXN | 4,392.6 MXN | 363 % | 50.8 | 25 de septiembre de 2018 |
| Delegación Tamaulipas Almacen Delegacional En Tamaulipas | Tamaulipas | 1 | 33,640 MXN | 14,471.1 MXN | 75.5 % | 151 | 30 de octubre de 2017 |
| Delegación Yucatán Almacen Delegacional En Yucatan | Yucatán | 1 | 8,154.8 MXN | 4,870 MXN | 148.3 % | 56.3 | 30 de octubre de 2018 |
| H. de Especialidades, "Dr. Antonio Fraga Mouret" Centro Médico Nacional La Raza Umae Especialidades C.m.n. La Raza | Ciudad de México | 1 | 25,882.5 MXN | 23,007.2 MXN | 800.2 % | 240 | 22 de septiembre de 2017 |
| H. de Especialidades Núm 25, Monterrey, N.L. Umae Especialidades Nuevo Leon | Nuevo León | 1 | 45,994 MXN | 37,581.7 MXN | 446.7 % | 272.5 | 25 de mayo de 2015 |
| H. de Gineco Pediatría Núm 48, León Gto. Umae Gineco - Pediatria Guanajuato | Guanajuato | 1 | 377 MXN | 185.3 MXN | 96.7 % | 1.93 | 6 de abril de 2017 |
| SUPPLIER | PURCHASES | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | TIME PERIOD |
|---|---|---|---|---|---|
| GRUPO MORAVI, S.A. DE C.V. | 13 | 11,042.7 MXN | 35.8 % | 91.6 | 2013 - 2016 |
| LOPEZ VELARDE IVAN | 13 | 10,984.2 MXN | 53.6 % | 96.6 | 2014 - 2015 |
| GERMAN FERNANDO PAVON BORQUEZ | 11 | 1,842.3 MXN | 49.6 % | 13.4 | 2015 - 2015 |
| RODRIGUEZ MENDOZA SALVADOR FERNANDO | 10 | 24,965.3 MXN | 800.7 % | 262.5 | 2015 - 2016 |
| S&M DISTRIBUTION, S. DE R.L. DE C.V. | 8 | 6,898.2 MXN | 54 % | 61.8 | 2013 - 2015 |
| GOMEN HEALTH CARE, S.A. DE C.V. | 5 | 34,463.1 MXN | 136.2 % | 377.8 | 2017 - 2018 |
| ESCAMILLA ZENTENO AURORA | 4 | 6,351.1 MXN | 12.9 % | 41.9 | 2013 - 2013 |
| INSTRUMENTOS Y ACCESORIOS AUTOMATIZADOS, S.A. DE C | 4 | 1,417.2 MXN | 22.2 % | 17.7 | 2015 - 2016 |
| RAMON CAZOLA YERA | 4 | - MXN | - | - | 2013 - 2013 |
| GUILLERMO GARCIA VERGARA | 3 | 1,079.6 MXN | 96.3 % | 7.83 | 2015 - 2015 |
| HOSPITRADE, S DE R L DE C V | 3 | 1,587.9 MXN | 110.3 % | 11.5 | 2015 - 2015 |
| PROVEEDOR HOSPITALARIO Y DE SALUD, S.A. DE C.V. | 3 | 15,815.2 MXN | 126.9 % | 165 | 2017 - 2017 |
| CENTRO DE ABASTECIMIENTO DE INSUMOS MEDICOS EDA, S | 2 | 1,684 MXN | 416.8 % | 16.7 | 2014 - 2014 |
| COMERCIALIZADORA MEDICA ALVASAN S.A DE C.V. | 2 | 1,103.4 MXN | 132.9 % | 12 | 2016 - 2017 |
| GRUPO EMEQUR, S.A. DE C.V. | 2 | 383.6 MXN | 105.7 % | 4.23 | 2017 - 2018 |
| MEDIBAC S DE RL DE CV | 2 | 5,652.6 MXN | 219.3 % | 56 | 2014 - 2014 |
| MEDICA AVANZADA, S. A. DE C. V. | 2 | 3,100.6 MXN | 120.3 % | 30.7 | 2014 - 2014 |
| Proveedor local no identificado (Compra Emergente) | 2 | 3,204.9 MXN | 66.8 % | 23.2 | 2015 - 2015 |
| RAMIREZ GALVEZ JUAN FRANCISCO | 2 | 7,854.5 MXN | 156.3 % | 96.4 | 2016 - 2017 |
| SERVICIOS E INSUMOS INSTITUCIONALES DEL NOROESTE D | 2 | 3,460.6 MXN | 176.1 % | 32.6 | 2014 - 2015 |
| CASA MARZAM, S.A. DE C.V. | 1 | 5,843.1 MXN | 103.3 % | 61 | 2017 - 2017 |
| COMERCIAL QUIMICA DEL NOROESTE, S.A. DE C.V. | 1 | 513.3 MXN | 39.8 % | 5.08 | 2014 - 2014 |
| COMERCIALIZADORA DIFARMALAV, S.A. DE C.V. | 1 | 7,325.4 MXN | 141.2 % | 84.7 | 2018 - 2018 |
| COMERCIALIZADORA Y DISTRIBUIDORA AX-LEX, S.A. DE C | 1 | 4,392.6 MXN | 363 % | 50.8 | 2018 - 2018 |
| CONSORCIO HOSPITALARIO S. A. DE C. V. | 1 | 3,487.4 MXN | 48.6 % | 25.3 | 2015 - 2015 |
| DIAGNOSTICO Y PREVENCION DEL SUR S.A. DE C.V. | 1 | 1,276.7 MXN | 16 % | 4.64 | 2019 - 2019 |
| DURFA, S. A. DE C. V. | 1 | 37,581.7 MXN | 446.7 % | 272.5 | 2015 - 2015 |
| EMAA PRODUCTOS ORGANICOS DE MEXICO S DE RL DE CV | 1 | 23,007.2 MXN | 800.2 % | 240 | 2017 - 2017 |
| FRANCISCO GARCIA LOPEZ, S.A. DE C.V. | 1 | - MXN | - | - | 2015 - 2015 |
| GARCIA VERGARA ALEJANDRINA | 1 | 459.7 MXN | 95.8 % | 3.33 | 2015 - 2015 |
| KENDALL DE MEXICO, S.A. DE C.V. | 1 | - MXN | - | - | 2017 - 2017 |
| MARIA DEL ROSARIO JAUREGUI RAMIREZ | 1 | 7,755.9 MXN | 88.3 % | 51.2 | 2013 - 2013 |
| MOPER MEDICAL S.A. DE C.V. | 1 | 332.4 MXN | 207.8 % | 2.41 | 2015 - 2015 |
| OFERTIMED, S.A. DE C.V. | 1 | 394.5 MXN | 212.7 % | 4.94 | 2016 - 2016 |
| PLAZA MEDICA JALISCO, S.A DE C.V. | 1 | 14,471.1 MXN | 75.5 % | 151 | 2017 - 2017 |
| PRODUCTOS MEDICOS REGIOMONTANOS, S. A. DE C. V. | 1 | 14,152.8 MXN | 109.4 % | 147.7 | 2017 - 2017 |
| PROMEDICA GARCIA, S. A. DE C. V. | 1 | - MXN | - | - | 2013 - 2013 |
| QUIMICA INDUSTRIAL Y DE SALUD, SA DE CV | 1 | 708.9 MXN | 136.7 % | 8.2 | 2018 - 2018 |
| RUIZ RODRIGUEZ ELENA | 1 | 1,771.9 MXN | 110.8 % | 22.2 | 2016 - 2016 |
| SATORI IMPULSORA DE ARTICULOS MEDICOS Y ESCOLARES, | 1 | 169.2 MXN | 96.3 % | 1.12 | 2013 - 2013 |
| SERVICIOS MEDICOS Y TECNICOS, S.A. DE C.V. | 1 | 2,459.5 MXN | 116.6 % | 25.7 | 2017 - 2017 |
| SONOMEDICS, S.A. DE C.V. | 1 | 6,842.1 MXN | 138.9 % | 79.2 | 2018 - 2018 |
| SOPORTE HOSPITALARIO CENTRAL SA DE CV | 1 | 5,465.4 MXN | 172.8 % | 57 | 2017 - 2017 |
| UCIN MEDICA, S. A. DE C. V. | 1 | 5,949.4 MXN | 114.7 % | 68.8 | 2018 - 2018 |
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.167.8204.11")
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.167.8204.11')
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.167.8204.11')