Thank you for your answer.
Description
AGUJAS PARA BIOPSIA DE HUESO CON MANGO Y DOS MANDRILES RANURADOS. TIPO:WESTEERMAN. LONGITUD. 20 CM CALIBRE.11 G.
IMSS product code
060.040.0147.11
Each circle represents one of the 37 purchases of AGUJAS made by the IMSS between 2009 and 2017.
| INSTITUTION | STATE | QUANTITY | TOTAL AMOUNT | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | LAST PURCHASE |
|---|---|---|---|---|---|---|---|
| H. de Especialidades, "Dr. Antonio Fraga Mouret" Centro Médico Nacional La Raza Umae Especialidades C.m.n. La Raza | Ciudad de México | 7 | 666,539.3 MXN | 106,125.1 MXN | 24.5 % | 57.3 | 1 de febrero de 2017 |
| Delegación Baja California | Baja California | 5 | 33,631.6 MXN | - MXN | - | - | 27 de octubre de 2010 |
| Delegación Querétaro Almacen Delegacional En Queretaro | Querétaro | 4 | 216,249.6 MXN | 53,391.9 MXN | 33.8 % | 16.6 | 19 de mayo de 2017 |
| Oficinas Centrales Ofnas Centrales -reforma- Coordinacion De Abastecimiento | 4 | 443,069.9 MXN | 61,113.1 MXN | 16 % | 37.6 | 1 de enero de 2011 | |
| Delegación Norte del DF Almacen Delegacional En El D.f. Zona Norte | Ciudad de México | 3 | 896,448 MXN | 141,472.6 MXN | 11.3 % | 69.3 | 22 de enero de 2014 |
| Delegación Zacatecas Almacen Delegacional En Zacatecas | Zacatecas | 3 | 79,630.7 MXN | 38,764.5 MXN | 61.2 % | 19.8 | 14 de marzo de 2012 |
| Delegación Jalisco Almacen Delegacional En Jalisco | Jalisco | 2 | 113,555.8 MXN | 14,131.2 MXN | 12.3 % | 7.36 | 2 de septiembre de 2016 |
| H. de Especialidades, "Lic. Ignacio García Tellez" Centro Médico Nacional de Occidente, Jalisco Umae Especialidades Jalisco | Jalisco | 2 | 47,168.6 MXN | 9,038.8 MXN | 45.6 % | 5.78 | 2 de noviembre de 2012 |
| Delegación Baja California Almacen Delegacional En Baja California Norte | Baja California | 1 | 8,028.3 MXN | 636.1 MXN | 8.6 % | 0.344 | 1 de enero de 2009 |
| Delegación Chiapas Almacen Subdelegacional En Tapachula, Chiapas | Chiapas | 1 | 1,219.7 MXN | - MXN | - | - | 2 de junio de 2010 |
| Delegación Estado de México Oriente Almacen Delegacional En Estado De Mexico Oriente | Estado de México | 1 | 176,253.1 MXN | 99,888.6 MXN | 130.8 % | 47.1 | 14 de abril de 2014 |
| Delegación Sur del DF Almacen Delegacional En El D.f. Zona Sur | Ciudad de México | 1 | 62,640 MXN | - MXN | - | - | 27 de enero de 2017 |
| Delegación Veracruz Norte | Veracruz | 1 | 1,015 MXN | - MXN | - | - | 10 de enero de 2013 |
| H. de Especialidades, "Dr. Bernardo Sepulveda Gutiérrez" Centro Médico Nacional Siglo XXI Umae Especialidades C.m.n. Siglo Xxi | Ciudad de México | 1 | 28,901.2 MXN | - MXN | - | - | 11 de septiembre de 2014 |
| H. de Especialidades No. 14 "Adolfo Ruíz Cortines", Veracruz. Umae Especialidades Veracruz (nte.) | Veracruz | 1 | 15,080 MXN | - MXN | - | - | 2 de marzo de 2012 |
| SUPPLIER | PURCHASES | OVERCOST IN MXN | OVERCOST IN % | LOST QUANTITY | TIME PERIOD |
|---|---|---|---|---|---|
| EQUIPOS MEDICOS DE BAJA CALIFORNIA, S.A. DE C.V. | 4 | - MXN | - | - | 2010 - 2010 |
| INSTRUMENTOS Y ACCESORIOS AUTOMATIZADOS, S.A. DE C | 4 | 8,039 MXN | 16.3 % | 4.35 | 2009 - 2009 |
| COMERCIALIZADORA GLAVS, S.A. DE C.V. | 3 | 160,860.3 MXN | 41.7 % | 78.5 | 2012 - 2014 |
| DIAGNOSTICO Y CIRUGIA, S.A. DE C.V. | 3 | 66,336.2 MXN | 21.2 % | 44 | 2010 - 2010 |
| BERNIE MEDICAL, S. A. DE C. V. | 2 | - MXN | - | - | 2010 - 2012 |
| CORPORACION ARMO, S.A. DE C.V. | 2 | 124,838.2 MXN | 75.2 % | 54.7 | 2013 - 2014 |
| DISTRIBUIDORA Y EXP. DE MEDICAMENTOS, S.A. DE C.V. | 2 | 39,603.5 MXN | 51.6 % | 13.4 | 2017 - 2017 |
| ESCAMILLA ZENTENO AURORA | 2 | 36,529.2 MXN | 15.9 % | 22.5 | 2011 - 2011 |
| PROVEEDORA NACIONAL DE MAT. DE CURACION, SA DE CV | 2 | - MXN | - | - | 2014 - 2014 |
| ULTRA TECNOLOGIA, S.A. DE C.V. | 2 | 24,583.9 MXN | 16.1 % | 15.1 | 2011 - 2011 |
| ALFEJ MEDICAL ITEMS S DE R.L. DE C.V. | 1 | 12,064 MXN | 16 % | 6.24 | 2016 - 2016 |
| ASESORIA EN PRODUCTOS MEDICOS, S.A. DE C.V. | 1 | - MXN | - | - | 2012 - 2012 |
| AVISA MEDICAL, S.A. DE C.V. | 1 | 1,384.6 MXN | 70 % | 0.7 | 2012 - 2012 |
| DURFA, S. A. DE C. V. | 1 | - MXN | - | - | 2010 - 2010 |
| EMAA PRODUCTOS ORGANICOS DE MEXICO S DE RL DE CV | 1 | - MXN | - | - | 2017 - 2017 |
| GRUPO EMEQUR, S.A. DE C.V. | 1 | 6,997.2 MXN | 16.2 % | 1.62 | 2015 - 2015 |
| MARIN MANCILLA IRMA LUZ | 1 | - MXN | - | - | 2010 - 2010 |
| MEDICA ZARPA, S.A. DE C.V. | 1 | - MXN | - | - | 2017 - 2017 |
| QUIRURGICOS E HIPODERMICOS DEL NORESTE, SA DE CV | 1 | - MXN | - | - | 2013 - 2013 |
| SAY QUIMICA MEDICA, S.A. DE C.V. | 1 | 6,791.2 MXN | 15.8 % | 1.58 | 2015 - 2015 |
| SUMINISTROS FEGA, S.A. DE C.V. | 1 | 36,534.7 MXN | 153.8 % | 18.5 | 2012 - 2012 |
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.040.0147.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.040.0147.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.040.0147.11')