Thank you for your answer.
Description
PINZA PEAN O ROCHESTER PEAN, CURVA, ESTRIAS TRANSVERSALES, LONGITUD DE 180 A 185 MM.
IMSS product code
535.701.1542.01
Each circle represents one of the 90 purchases of PINZAS made by the IMSS between 2009 and 2018.
| INSTITUTION | STATE | QUANTITY | TOTAL AMOUNT | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | LAST PURCHASE |
|---|---|---|---|---|---|---|---|
| Delegación Chiapas Almacen Subdelegacional En Tapachula, Chiapas | Chiapas | 9 | 169,127.6 MXN | 24,704.3 MXN | 58.6 % | 289.3 | 31 de julio de 2018 |
| Delegación Hidalgo Almacen Delegacional En Hidalgo | Hidalgo | 7 | 31,534.9 MXN | 10,285.7 MXN | 51.8 % | 97.9 | 28 de julio de 2018 |
| Delegación Durango Almacen Delegacional En Durango | Durango | 6 | 43,908.7 MXN | 11,520.5 MXN | 73.8 % | 132.8 | 30 de noviembre de 2017 |
| Delegación Guanajuato Almacen Delegacional En Guanajuato | Guanajuato | 6 | 20,768.6 MXN | 7,231.6 MXN | 61 % | 52.2 | 20 de agosto de 2018 |
| Delegación San Luis Potosí Almacen Delegacional En San Luis Potosi | San Luis Potosi | 6 | 71,247.8 MXN | 11,506.8 MXN | 16.8 % | 144.3 | 11 de julio de 2017 |
| Delegación Veracruz Norte Almacen Delegacional En Veracruz Norte | Veracruz | 6 | 33,512.2 MXN | 17,821.6 MXN | 104.7 % | 219.3 | 17 de mayo de 2017 |
| Oficinas Centrales Almacen De Programas Especiales Y Red Fria | 5 | 4.7 millones MXN | 522,459.7 MXN | 12.8 % | 4,819.3 | 14 de noviembre de 2014 | |
| Delegación Nayarit Almacen Delegacional En Nayarit | Nayarit | 4 | 22,755.2 MXN | 3,362 MXN | 26.7 % | 28.2 | 6 de octubre de 2014 |
| Delegación Tamaulipas Almacen Delegacional En Tamaulipas | Tamaulipas | 4 | 14,197.5 MXN | 2,252.8 MXN | 44.6 % | 20.4 | 25 de agosto de 2016 |
| Delegación Veracruz Sur Almacen Delegacional En Veracruz Sur | Veracruz | 4 | 14,915.2 MXN | 3,639 MXN | 56.5 % | 33.4 | 8 de noviembre de 2017 |
| Delegación Coahuila Almacen Delegacional En Coahuila | Coahuila | 3 | 16,942 MXN | 9,007.3 MXN | 66.8 % | 71.8 | 25 de noviembre de 2015 |
| Delegación Estado de México Poniente Almacen Delegacional En El Estado De Mexico Poniente | Estado de México | 3 | 17,445.2 MXN | 4,571.5 MXN | 57.8 % | 41.5 | 6 de octubre de 2016 |
| Delegación Michoacán Almacen Delegacional En Michoacan | Michoacán | 3 | 135,201 MXN | 99,765 MXN | 280.7 % | 905.2 | 22 de julio de 2011 |
| Delegación Oaxaca Almacen Delegacional En Oaxaca | Oaxaca | 3 | 54,294.3 MXN | 9,194.4 MXN | 39.7 % | 124.3 | 3 de noviembre de 2016 |
| Delegación Yucatán Almacen Delegacional En Yucatan | Yucatán | 3 | 19,515.8 MXN | 6,432.5 MXN | 85.4 % | 60.3 | 16 de mayo de 2016 |
| Delegación Chiapas Almacen Subdelegacional En Tuxtla Gutierrez, Chiapas | Chiapas | 2 | 5,681.4 MXN | 500.9 MXN | 29.4 % | 4.25 | 13 de octubre de 2016 |
| Delegación Chihuahua Almacen Delegacional En Chihuahua | Chihuahua | 2 | 10,778.8 MXN | 743.7 MXN | 10.9 % | 8.08 | 2 de junio de 2014 |
| Delegación Guerrero Almacen Delegacional En Guerrero | Guerrero | 2 | 2,821.9 MXN | 974.6 MXN | 62.1 % | 12.4 | 9 de julio de 2013 |
| Delegación Sinaloa Almacen Delegacional En Sinaloa | Sinaloa | 2 | 11,670 MXN | 3,589.3 MXN | 34.4 % | 29.9 | 13 de noviembre de 2018 |
| Delegación Aguascalientes Almacen Delegacional En Aguascalientes | Aguascalientes | 1 | 5,383.8 MXN | 3,234 MXN | 150.4 % | 30.1 | 18 de junio de 2009 |
| Delegación Baja California Sur Almacen Delegacional En Baja California Sur | Baja California Sur | 1 | 2,331.6 MXN | - MXN | - | - | 31 de enero de 2017 |
| Delegación Colima Almacen Delegacional En Colima | Colima | 1 | 4,854.6 MXN | 2,249 MXN | 86.3 % | 17.3 | 22 de diciembre de 2011 |
| Delegación Jalisco Almacen Delegacional En Jalisco | Jalisco | 1 | 14,763.3 MXN | 4,827.5 MXN | 48.6 % | 63.2 | 13 de julio de 2010 |
| Delegación Quintana Roo Almacen Delegacional En Quintana Roo | Quintana Roo | 1 | 12,958.7 MXN | 253.2 MXN | 1.99 % | 1.49 | 9 de mayo de 2018 |
| Delegación Sonora Almacen Delegacional En Sonora | Sonora | 1 | 7,830 MXN | 4,008.5 MXN | 104.9 % | 52.4 | 25 de junio de 2010 |
| Delegación Tlaxcala Almacen Delegacional En Tlaxcala | Tlaxcala | 1 | 5,053 MXN | 3,371.5 MXN | 200.5 % | 44.1 | 30 de noviembre de 2010 |
| Delegación Zacatecas Almacen Delegacional En Zacatecas | Zacatecas | 1 | 469.8 MXN | 118.6 MXN | 33.8 % | 1.01 | 17 de abril de 2012 |
| H. de Especialidades No. 2, "Luis Donaldo Colosio Murrieta", Centro Médico Nacional del Noroeste, Cd. Obregón Sonora Umae Especialidades Sonora | Sonora | 1 | 14,066.9 MXN | 12,662.1 MXN | 901.3 % | 108.2 | 2 de noviembre de 2012 |
| Oficinas Centrales Ofnas Centrales -reforma- Coordinacion De Abastecimiento | 1 | 807,146.6 MXN | 94,788.5 MXN | 13.3 % | 1,052.1 | 26 de mayo de 2015 |
| SUPPLIER | PURCHASES | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | TIME PERIOD |
|---|---|---|---|---|---|
| QUIRURGICA ORTOPEDICA, S. A. DE C. V. | 33 | 668,602.2 MXN | 47.1 % | 6,423 | 2009 - 2018 |
| HEMOST, S. A. DE C. V. | 9 | 17,699.3 MXN | 59.5 % | 202.6 | 2010 - 2018 |
| DRENOVAC, S. A. DE C. V. | 6 | 3,419.3 MXN | 5.72 % | 30.7 | 2009 - 2012 |
| GRUPO CORPORATIVO MEDICO DIVISION CENTRO S.A. DE C | 3 | 7,410.5 MXN | 35 % | 97 | 2010 - 2011 |
| ARTICULOS MEDICOS DACASA, S.A. DE C.V. | 2 | 8,819.4 MXN | 108.6 % | 78 | 2012 - 2015 |
| COMERCIALIZADORA MEDIGLOBAL SA DE CV | 2 | 73,976 MXN | 308.6 % | 567.8 | 2011 - 2011 |
| NEODREN, S. DE R. L. DE C. V. | 2 | 6,433.6 MXN | 49.8 % | 91.5 | 2013 - 2015 |
| RUBI ESQUIVEL PULIDO | 2 | 4,042.6 MXN | 126 % | 25.2 | 2017 - 2017 |
| SERVICIOS ORTOPEDICOS DEL GUADIANA, S.A. DE C.V. | 2 | 3,459.1 MXN | 15.9 % | 38.4 | 2015 - 2016 |
| SUMINISTROS MEDICOS AVANZADOS S.A. DE C.V | 2 | 752.8 MXN | 29.2 % | 6.39 | 2016 - 2016 |
| ALONSO RUBIN FRANCISCO FERNANDO | 1 | 1,373.4 MXN | 254.1 % | 15.2 | 2015 - 2015 |
| ALVAREZ MARTINEZ TANIA | 1 | 25,788.9 MXN | 224.9 % | 337.4 | 2010 - 2010 |
| APLICACIONES MEDICAS Y TECNOLOGICAS, SA DE CV | 1 | 12,662.1 MXN | 901.3 % | 108.2 | 2012 - 2012 |
| ATM ALTA TECNOLOGIA MEDICA, S.A. DE C.V. | 1 | 657.3 MXN | 97.1 % | 9.71 | 2013 - 2013 |
| COMERCIALIZADORA DE TODO MENA, S.A. DE C.V. | 1 | 3,375.8 MXN | 47.8 % | 28.7 | 2016 - 2016 |
| CORREA AYALA GEORGINA | 1 | 3,371.5 MXN | 200.5 % | 44.1 | 2010 - 2010 |
| DESARROLLO COMERCIAL Y DE SERVICIOS APLV S.A DE CV | 1 | 1,533.5 MXN | 71.7 % | 20.1 | 2010 - 2010 |
| DEWIMED, S. A. | 1 | 3,234 MXN | 150.4 % | 30.1 | 2009 - 2009 |
| DURFA, S. A. DE C. V. | 1 | 1,947.1 MXN | 183.8 % | 16.5 | 2016 - 2016 |
| EBS MEXICO, S.A. DE C.V. | 1 | 7,109.5 MXN | 110.6 % | 105.1 | 2013 - 2013 |
| ECOMED EQUIPOS Y CONS. MEDICOS DEL NORTE S.A. DE C | 1 | 491.8 MXN | 18.4 % | 6.43 | 2010 - 2010 |
| EL CIRUJANO, S.A DE C.V | 1 | 39.3 MXN | 5.45 % | 0.436 | 2015 - 2015 |
| FARMACIA DERMATOLOGICA Y ESPECIALIDADES S.A. DE C. | 1 | 2,249 MXN | 86.3 % | 17.3 | 2011 - 2011 |
| HC TECH, S.A. DE C.V. | 1 | 1,145.4 MXN | 12.8 % | 9.73 | 2016 - 2016 |
| HIDRO HOSPITAL, S.A. DE C.V. | 1 | 5,648 MXN | 211.1 % | 73.9 | 2010 - 2010 |
| INSTRUMENTOS Y ACCESORIOS AUTOMATIZADOS, S.A. DE C | 1 | 178.7 MXN | 34.3 % | 1.37 | 2011 - 2011 |
| INSUMOS MEDICOS GEVA SA DE CV | 1 | 213.5 MXN | 21 % | 1.26 | 2018 - 2018 |
| PHARMACY, S.A. DE C.V. | 1 | 2,493.5 MXN | 141.2 % | 21.2 | 2016 - 2016 |
| PRECISION QUIRURGICA, S.A. DE C.V. | 1 | 252 MXN | 3.42 % | 1.64 | 2014 - 2014 |
| PROVEEDORA DE SUMINISTROS DEL SUR, S.A. DE C.V. | 1 | - MXN | - | - | 2018 - 2018 |
| PROVEEDORA MEDICAL DYCSA, S.A. DE C.V. | 1 | 1,705.9 MXN | 48.6 % | 14.6 | 2012 - 2012 |
| RIOJA LOPEZ DARIO JOEL | 1 | 317.3 MXN | 27.1 % | 2.71 | 2012 - 2012 |
| SERVICIOS MEDICOS Y TECNICOS, S.A. DE C.V. | 1 | - MXN | - | - | 2017 - 2017 |
| STATION BUSINESS GROUP AND SERVICES, S.A. DE C.V. | 1 | 3,407.6 MXN | 16.8 % | 29.1 | 2012 - 2012 |
| SUMINISTROS HOSPITALARIOS SURESTE, S.A. DE C.V. | 1 | 102.4 MXN | 2.29 % | 0.87 | 2016 - 2016 |
| SUPPORT GLOBAL BIOMEDICAL GROUP, S.A. DE C.V. | 1 | 523.4 MXN | 14.8 % | 3.26 | 2017 - 2017 |
| VARGAS ALVAREZ ANA LUISA | 1 | 640.4 MXN | 18.1 % | 5.44 | 2016 - 2016 |
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=535.701.1542.01")
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=535.701.1542.01')
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=535.701.1542.01')