{"ok":true,"data":{"totalRows":500,"fieldCount":85,"fields":[{"field":"fecha_de_notificaci_n_de_prorrogaci_n","type":"date","total":500,"nonNull":51,"nullCount":449,"nullPct":0.898,"emptyStringCount":0,"uniqueCount":49,"duplicatePct":0.039215686274509776,"placeholderCount":0,"sampleValues":["2023-12-13T00:00:00.000","2024-12-01T00:00:00.000","2020-11-06T00:00:00.000","2024-06-15T00:00:00.000","2026-12-14T00:00:00.000"],"issues":["> 50% valores faltantes (89.8%)"],"date":{"earliest":"2017-12-11","latest":"2027-01-27","invalidCount":0}},{"field":"fecha_inicio_liquidacion","type":"date","total":500,"nonNull":64,"nullCount":436,"nullPct":0.872,"emptyStringCount":0,"uniqueCount":61,"duplicatePct":0.046875,"placeholderCount":0,"sampleValues":["2026-01-01T00:00:00.000","2024-12-31T00:00:00.000","2025-01-01T00:00:00.000","2027-01-01T00:00:00.000","2027-01-15T00:00:00.000"],"issues":["> 50% valores faltantes (87.2%)"],"date":{"earliest":"2017-12-21","latest":"2029-01-01","invalidCount":0}},{"field":"fecha_fin_liquidacion","type":"date","total":500,"nonNull":64,"nullCount":436,"nullPct":0.872,"emptyStringCount":0,"uniqueCount":62,"duplicatePct":0.03125,"placeholderCount":0,"sampleValues":["2027-06-30T00:00:00.000","2026-02-28T00:00:00.000","2027-01-29T00:00:00.000","2026-01-30T00:00:00.000","2025-08-06T00:00:00.000"],"issues":["> 50% valores faltantes (87.2%)"],"date":{"earliest":"2018-04-21","latest":"2029-06-30","invalidCount":0}},{"field":"ultima_actualizacion","type":"date","total":500,"nonNull":280,"nullCount":220,"nullPct":0.44,"emptyStringCount":0,"uniqueCount":244,"duplicatePct":0.12857142857142856,"placeholderCount":0,"sampleValues":["2026-06-30T00:00:00.000","2026-05-19T00:00:00.000","2024-05-03T00:00:00.000","2026-03-13T00:00:00.000","2026-04-28T00:00:00.000"],"issues":["Faltantes elevados (44.0%)"],"date":{"earliest":"2018-10-03","latest":"2026-08-06","invalidCount":0}},{"field":"fecha_de_inicio_del_contrato","type":"date","total":500,"nonNull":462,"nullCount":38,"nullPct":0.076,"emptyStringCount":0,"uniqueCount":373,"duplicatePct":0.1926406926406926,"placeholderCount":0,"sampleValues":["2026-02-02T00:00:00.000","2026-01-28T00:00:00.000","2026-01-23T00:00:00.000","2026-01-29T00:00:00.000","2026-01-19T00:00:00.000"],"issues":[],"date":{"earliest":"2017-09-28","latest":"2026-08-03","invalidCount":0}},{"field":"fecha_de_firma","type":"date","total":500,"nonNull":469,"nullCount":31,"nullPct":0.062,"emptyStringCount":0,"uniqueCount":371,"duplicatePct":0.20895522388059706,"placeholderCount":0,"sampleValues":["2026-01-30T00:00:00.000","2026-01-19T00:00:00.000","2022-01-28T00:00:00.000","2026-01-23T00:00:00.000","2026-01-27T00:00:00.000"],"issues":[],"date":{"earliest":"2017-10-03","latest":"2026-08-05","invalidCount":0}},{"field":"fecha_de_fin_del_contrato","type":"date","total":500,"nonNull":498,"nullCount":2,"nullPct":0.004,"emptyStringCount":0,"uniqueCount":300,"duplicatePct":0.3975903614457831,"placeholderCount":0,"sampleValues":["2024-12-31T00:00:00.000","2025-12-31T00:00:00.000","2026-12-31T00:00:00.000","2023-12-31T00:00:00.000","2021-12-31T00:00:00.000"],"issues":[],"date":{"earliest":"2017-12-15","latest":"2028-12-31","invalidCount":0}},{"field":"nombre_entidad","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":321,"duplicatePct":0.358,"placeholderCount":0,"sampleValues":["(Secretaría Distrital de Integración Social)","DEFENSORÍA DEL PUEBLO","SUBRED INTEGRADA DE SERVICIOS DE SALUD SUR E.S.E.**","SUBRED INTEGRADA DE SERVICIOS DE SALUD SUR OCCIDENTE ESE.","FONDO FINANCIERO DISTRITAL DE SALUD."],"issues":[]},{"field":"nit_entidad","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":264,"duplicatePct":0.472,"placeholderCount":0,"sampleValues":["899999034","899999061","890399011","8999990619","899999027"],"issues":[],"numeric":{"min":800000118,"max":9012516946,"mean":1569058544.164,"negativeCount":0,"zeroCount":0}},{"field":"departamento","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":30,"duplicatePct":0.94,"placeholderCount":6,"sampleValues":["Distrito Capital de Bogotá","Valle del Cauca","Antioquia","Cundinamarca","Atlántico"],"issues":[]},{"field":"ciudad","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":107,"duplicatePct":0.786,"placeholderCount":112,"sampleValues":["No Definido","Bogotá","Cali","Barranquilla","Medellín"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 112 (22.4%)"]},{"field":"localizaci_n","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":140,"duplicatePct":0.72,"placeholderCount":0,"sampleValues":["Colombia, Bogotá,  Bogotá","Colombia, Bogotá, No Definido","Colombia, Bogotá, Bogotá","Colombia,  Valle del Cauca ,  Cali","Colombia,  Atlántico ,  Barranquilla"],"issues":[]},{"field":"orden","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":0,"sampleValues":["Territorial","Nacional","Corporación Autónoma"],"issues":[]},{"field":"sector","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":22,"duplicatePct":0.956,"placeholderCount":0,"sampleValues":["Servicio Público","No aplica/No pertenece","Salud y Protección Social","Trabajo","Ambiente y Desarrollo Sostenible"],"issues":[]},{"field":"rama","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":0,"sampleValues":["Ejecutivo","Corporación Autónoma","Legislativo","Judicial"],"issues":[]},{"field":"entidad_centralizada","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["Centralizada","Descentralizada"],"issues":[]},{"field":"proceso_de_compra","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":500,"duplicatePct":0,"placeholderCount":0,"sampleValues":["CO1.BDOS.3452554","CO1.BDOS.9960799","CO1.BDOS.9690037","CO1.BDOS.5042930","CO1.BDOS.1502615"],"issues":[]},{"field":"id_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":500,"duplicatePct":0,"placeholderCount":0,"sampleValues":["CO1.PCCNTR.4168447","CO1.PCCNTR.9324146","CO1.PCCNTR.9069006","CO1.PCCNTR.5481409","CO1.PCCNTR.1914727"],"issues":[]},{"field":"referencia_del_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":500,"duplicatePct":0,"placeholderCount":0,"sampleValues":["CPS-3548-2022","SS-CD-2026-191","HDSJDD-CD-0404-2026","CDN-1000-12-02-014-2023","CO1.PCCNTR.1914727"],"issues":[]},{"field":"estado_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":11,"duplicatePct":0.978,"placeholderCount":0,"sampleValues":["En ejecución","Cerrado","Modificado","terminado","Aprobado"],"issues":[]},{"field":"codigo_de_categoria_principal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":138,"duplicatePct":0.724,"placeholderCount":0,"sampleValues":["V1.80111600","V1.80111701","V1.80111620","V1.80111500","V1.80111501"],"issues":[]},{"field":"descripcion_del_proceso","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":486,"duplicatePct":0.028000000000000025,"placeholderCount":0,"sampleValues":["Sin Descripcion","Prestación de servicios profesionales de abogado para la representación judicial; extrajudicial y las demás que disponga la ley en favor de los usuarios del servicio de defensoría pública; así como la promoción; defensa; ejercicio y divulgación de los derechos humanos","PRESTACIÓN DE SERVICIOS PROFESIONALES ESPECIALIZADOS PARA APOYAR JURIDICAMENTE LOS PROCESOS DE COBRO; RECAUDO Y RECUPERACIÓN DE CARTERA DE LA ESE HOSPITAL DEPARTAMENTAL UNIVERSITARIO DEL QUINDIO SAN JUAN DE DIOS","PRESTACION DE SERVICIOS PROFESIONALES O APOYO A LA GESTION PARA LA\nEJECUCION DE ACCIONES CONTEMPLADAS EN EL PLAN DE ACCION EN SALUD\nVIGENCIA 2026 DEL MUNICIPIO DE SOLEDAD  ATLÁNTICO","PRESTACIÓN DE SERVICIOS PROFESIONALES DE APOYO PARA EL AREA DE CALIDAD DEL HOSPITAL DEPARTAMENTAL SAN JUAN DE DIOS E.S.E."],"issues":[]},{"field":"tipo_de_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":10,"duplicatePct":0.98,"placeholderCount":0,"sampleValues":["Prestación de servicios","Otro","Decreto 092 de 2017","Suministros","Compraventa"],"issues":[]},{"field":"modalidad_de_contratacion","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":8,"duplicatePct":0.984,"placeholderCount":0,"sampleValues":["Contratación directa","Contratación régimen especial","Mínima cuantía","Contratación Directa (con ofertas)","Selección abreviada subasta inversa"],"issues":[]},{"field":"justificacion_modalidad_de","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":17,"duplicatePct":0.966,"placeholderCount":0,"sampleValues":["Servicios profesionales y apoyo a la gestión","Regla aplicable","Presupuesto inferior al 10% de la menor cuantía","Decreto 092 de 2017","Contratos o convenios Interadministrativos (valor cero)"],"issues":[]},{"field":"condiciones_de_entrega","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":11,"duplicatePct":0.978,"placeholderCount":151,"sampleValues":["No Definido","NXTWY.DLVY.2","A convenir","NXTWY.DLVY.6","Como acordado previamente"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 151 (30.2%)"]},{"field":"tipodocproveedor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":5,"duplicatePct":0.99,"placeholderCount":7,"sampleValues":["Cédula de Ciudadanía","NIT","No Definido","Otro","Cédula de Extranjería"],"issues":[]},{"field":"documento_proveedor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":493,"duplicatePct":0.014000000000000012,"placeholderCount":7,"sampleValues":["No Definido","830084433","18610581","32649086","35896350"],"issues":[]},{"field":"proveedor_adjudicado","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":493,"duplicatePct":0.014000000000000012,"placeholderCount":0,"sampleValues":["Sin Descripcion","CERTICAMARA S.A.","DIEGO ALEXANDER ALVAREZ PALACIO","ROSA MARIA","JISELIX MURILLO TAPIAS"],"issues":[]},{"field":"es_grupo","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["No","Si"],"issues":[]},{"field":"es_pyme","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["No","Si"],"issues":[]},{"field":"habilita_pago_adelantado","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":45,"sampleValues":["No","No Definido","Si"],"issues":[]},{"field":"liquidaci_n","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["No","Si"],"issues":[]},{"field":"obligaci_n_ambiental","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["No","Si"],"issues":[]},{"field":"obligaciones_postconsumo","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":0,"sampleValues":["No"],"issues":[]},{"field":"reversion","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":0,"sampleValues":["No"],"issues":[]},{"field":"origen_de_los_recursos","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["Distribuido","Recursos Propios"],"issues":[]},{"field":"destino_gasto","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":1,"sampleValues":["Inversión","Funcionamiento","No Definido"],"issues":[]},{"field":"valor_del_contrato","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":427,"duplicatePct":0.14600000000000002,"placeholderCount":11,"sampleValues":["0","15000000","9000000","5000000","6000000"],"issues":[],"numeric":{"min":0,"max":2971691800,"mean":66398231.797,"negativeCount":0,"zeroCount":11}},{"field":"valor_de_pago_adelantado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":498,"sampleValues":["0","190447025","1485845900"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 498 (99.6%)"],"numeric":{"min":0,"max":1485845900,"mean":3352585.85,"negativeCount":0,"zeroCount":498}},{"field":"valor_facturado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":253,"duplicatePct":0.494,"placeholderCount":221,"sampleValues":["0","10000000","7500000","12000000","13200000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 221 (44.2%)"],"numeric":{"min":0,"max":2971691800,"mean":23662986.562,"negativeCount":0,"zeroCount":221}},{"field":"valor_pendiente_de_pago","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":321,"duplicatePct":0.358,"placeholderCount":148,"sampleValues":["0","6000000","5000000","9000000","7500000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 148 (29.6%)"],"numeric":{"min":0,"max":2797495667,"mean":47250865.904,"negativeCount":0,"zeroCount":148}},{"field":"valor_pagado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":225,"duplicatePct":0.55,"placeholderCount":256,"sampleValues":["0","7500000","10000000","13200000","12000000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 256 (51.2%)"],"numeric":{"min":0,"max":2971691800,"mean":19138965.864,"negativeCount":0,"zeroCount":256}},{"field":"valor_amortizado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":499,"sampleValues":["0","1114384425"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 499 (99.8%)"],"numeric":{"min":0,"max":1114384425,"mean":2228768.85,"negativeCount":0,"zeroCount":499}},{"field":"valor_pendiente_de","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":498,"sampleValues":["0","190447025","371461475"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 498 (99.6%)"],"numeric":{"min":0,"max":371461475,"mean":1123817,"negativeCount":0,"zeroCount":498}},{"field":"valor_pendiente_de_ejecucion","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":321,"duplicatePct":0.358,"placeholderCount":148,"sampleValues":["0","6000000","5000000","9000000","7500000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 148 (29.6%)"],"numeric":{"min":0,"max":2797495667,"mean":47250865.904,"negativeCount":0,"zeroCount":148}},{"field":"saldo_cdp","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":291,"duplicatePct":0.41800000000000004,"placeholderCount":199,"sampleValues":["0","15000000","10000000","90000000","16200000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 199 (39.8%)"],"numeric":{"min":0,"max":150883551000,"mean":1951129103.902,"negativeCount":0,"zeroCount":199}},{"field":"saldo_vigencia","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":6,"duplicatePct":0.988,"placeholderCount":495,"sampleValues":["0","5292324299","10693958539","4684257","44975135"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 495 (99.0%)"],"numeric":{"min":0,"max":108733942000,"mean":249539768.46,"negativeCount":0,"zeroCount":495}},{"field":"espostconflicto","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["No","Si"],"issues":[]},{"field":"dias_adicionados","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":46,"duplicatePct":0.908,"placeholderCount":431,"sampleValues":["0","31","61","62","30"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 431 (86.2%)"],"numeric":{"min":0,"max":919,"mean":9.214,"negativeCount":0,"zeroCount":431}},{"field":"puntos_del_acuerdo","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":0,"sampleValues":["No aplica","ReformaRuralIntegral","VictimasConflicto"],"issues":[]},{"field":"pilares_del_acuerdo","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":0,"sampleValues":["No aplica","IAT","JusticiaYVerdad"],"issues":[]},{"field":"urlproceso","type":"url","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":0,"sampleValues":["[object Object]"],"issues":[]},{"field":"nombre_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":493,"duplicatePct":0.014000000000000012,"placeholderCount":0,"sampleValues":["Sin Descripcion","Paola Ortiz Romero","DIEGO ALEXANDER ALVAREZ PALACIO","ROSA MARIA JIMENEZ","jiselix murillo tapias"],"issues":[]},{"field":"nacionalidad_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":7,"sampleValues":["CO","No definido","ES","US"],"issues":[]},{"field":"domicilio_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":180,"duplicatePct":0.64,"placeholderCount":320,"sampleValues":["No Definido","Carrera 7 No. 26-20 piso 18-19-31","AMBAR RESERVA APTO 1006 TORRE A","cll 14 #8-27","calle 26b # 22-22"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 320 (64.0%)"]},{"field":"tipo_de_identificaci_n_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":0,"sampleValues":["Sin Descripcion","Cédula de Ciudadanía","NIT","Cédula de Extranjería"],"issues":[]},{"field":"identificaci_n_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":161,"duplicatePct":0.6779999999999999,"placeholderCount":0,"sampleValues":["Sin Descripcion","18610581","52531606","19325410","79470917"],"issues":[]},{"field":"g_nero_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":141,"sampleValues":["Mujer","Hombre","No Definido"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 141 (28.2%)"]},{"field":"presupuesto_general_de_la_nacion_pgn","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":112,"duplicatePct":0.776,"placeholderCount":389,"sampleValues":["0","8065000","70623280","6190750","104470000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 389 (77.8%)"],"numeric":{"min":0,"max":1729019606,"mean":16821540.56,"negativeCount":0,"zeroCount":389}},{"field":"sistema_general_de_participaciones","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":31,"duplicatePct":0.938,"placeholderCount":470,"sampleValues":["0","11250000","7500000","9000000","27600503"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 470 (94.0%)"],"numeric":{"min":0,"max":230985714,"mean":1541082.808,"negativeCount":0,"zeroCount":470}},{"field":"sistema_general_de_regal_as","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":497,"sampleValues":["0","33550339","100074587","774822465"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 497 (99.4%)"],"numeric":{"min":0,"max":774822465,"mean":1816894.782,"negativeCount":0,"zeroCount":497}},{"field":"recursos_propios_alcald_as_gobernaciones_y_resguardos_ind_genas_","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":199,"duplicatePct":0.602,"placeholderCount":275,"sampleValues":["0","15000000","9000000","10000000","5000000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 275 (55.0%)"],"numeric":{"min":0,"max":1544278233,"mean":19891431.238,"negativeCount":0,"zeroCount":275}},{"field":"recursos_de_credito","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":499,"sampleValues":["0","3690561"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 499 (99.8%)"],"numeric":{"min":0,"max":3690561,"mean":7381.122,"negativeCount":0,"zeroCount":499}},{"field":"recursos_propios","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":103,"duplicatePct":0.794,"placeholderCount":394,"sampleValues":["0","6000000","80000000","14000000","8959088"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 394 (78.8%)"],"numeric":{"min":0,"max":2971691800,"mean":24760494.98,"negativeCount":0,"zeroCount":394}},{"field":"codigo_entidad","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":321,"duplicatePct":0.358,"placeholderCount":0,"sampleValues":["702271321","702541384","702730482","702486788","701993388"],"issues":[],"numeric":{"min":700066053,"max":727001372,"mean":703503164.028,"negativeCount":0,"zeroCount":0}},{"field":"codigo_proveedor","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":493,"duplicatePct":0.014000000000000012,"placeholderCount":7,"sampleValues":["0","700141062","715778585","726352404","705329134"],"issues":[],"numeric":{"min":0,"max":737231415,"mean":703922739.558,"negativeCount":0,"zeroCount":7}},{"field":"objeto_del_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":486,"duplicatePct":0.028000000000000025,"placeholderCount":14,"sampleValues":["No definido","Prestación de servicios profesionales de abogado para la representación judicial; extrajudicial y las demás que disponga la ley en favor de los usuarios del servicio de defensoría pública; así como la promoción; defensa; ejercicio y divulgación de los derechos humanos","PRESTACIÓN DE SERVICIOS PROFESIONALES ESPECIALIZADOS PARA APOYAR JURIDICAMENTE LOS PROCESOS DE COBRO; RECAUDO Y RECUPERACIÓN DE CARTERA DE LA ESE HOSPITAL DEPARTAMENTAL UNIVERSITARIO DEL QUINDIO SAN JUAN DE DIOS","PRESTACION DE SERVICIOS PROFESIONALES O APOYO A LA GESTION PARA LA\nEJECUCION DE ACCIONES CONTEMPLADAS EN EL PLAN DE ACCION EN SALUD\nVIGENCIA 2026 DEL MUNICIPIO DE SOLEDAD  ATLÁNTICO","PRESTACIÓN DE SERVICIOS PROFESIONALES DE APOYO PARA EL AREA DE CALIDAD DEL HOSPITAL DEPARTAMENTAL SAN JUAN DE DIOS E.S.E."],"issues":[]},{"field":"duraci_n_del_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":179,"duplicatePct":0.642,"placeholderCount":15,"sampleValues":["6 Mes(es)","4 Mes(es)","3 Mes(es)","5 Mes(es)","7 Mes(es)"],"issues":[]},{"field":"nombre_del_banco","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":47,"duplicatePct":0.906,"placeholderCount":355,"sampleValues":["No definido","BANCOLOMBIA","DAVIVIENDA","Bancolombia","bancolombia"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 355 (71.0%)"]},{"field":"tipo_de_cuenta","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":355,"sampleValues":["No Definido","Ahorros","Corriente"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 355 (71.0%)"]},{"field":"n_mero_de_cuenta","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":139,"duplicatePct":0.722,"placeholderCount":362,"sampleValues":["No definido","07458780050","006180227834","50512157774","17463359881"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 362 (72.4%)"]},{"field":"el_contrato_puede_ser_prorrogado","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["No","Si"],"issues":[]},{"field":"nombre_ordenador_del_gasto","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":314,"duplicatePct":0.372,"placeholderCount":143,"sampleValues":["No definido","ALVARO ALBERTO CARDOSO CASTRO","CARLOS ALBERTO PIEDRAHITA GUTIERREZ","willy escruceria  castro","YAIR DE JESUS SOTO BUILES"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 143 (28.6%)"]},{"field":"tipo_de_documento_ordenador_del_gasto","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":5,"duplicatePct":0.99,"placeholderCount":146,"sampleValues":["Cédula de Ciudadanía","No definido","NIT","Otro","Cédula de Extranjería"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 146 (29.2%)"]},{"field":"n_mero_de_documento_ordenador_del_gasto","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":312,"duplicatePct":0.376,"placeholderCount":146,"sampleValues":["No definido","86044126","9845752.","73581599","15385877"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 146 (29.2%)"]},{"field":"nombre_supervisor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":321,"duplicatePct":0.358,"placeholderCount":174,"sampleValues":["No definido","KEYNES CARCAMO CABALLERO","FRANKLIN NEPOMUCENO CASTILLO SANCHEZ","dayra faisury  dorado gomez","CARLOS ANDRES ARRIETA GOMEZ"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 174 (34.8%)"]},{"field":"tipo_de_documento_supervisor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":178,"sampleValues":["Cédula de Ciudadanía","No definido"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 178 (35.6%)"]},{"field":"n_mero_de_documento_supervisor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":317,"duplicatePct":0.366,"placeholderCount":178,"sampleValues":["No definido","72335376","94318306","31321997","1128280527"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 178 (35.6%)"]},{"field":"nombre_ordenador_de_pago","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":81,"duplicatePct":0.838,"placeholderCount":415,"sampleValues":["No definido","DAVID SALOMON ALVAREZ BARROS","ROCIO DEL PILAR YATES VARGAS","JUAN JOSÉ BUILES VELÁSQUEZ","CARLOS ANDRES ARANGO MURGUEITIO"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 415 (83.0%)"]},{"field":"tipo_de_documento_ordenador_de_pago","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":5,"duplicatePct":0.99,"placeholderCount":415,"sampleValues":["No definido","Cédula de Ciudadanía","Cédula de Extranjería","NIT","Otro"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 415 (83.0%)"]},{"field":"n_mero_de_documento_ordenador_de_pago","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":81,"duplicatePct":0.838,"placeholderCount":415,"sampleValues":["No definido","84088298","41057326","71336201","16457811"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 415 (83.0%)"]},{"field":"documentos_tipo","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":0,"sampleValues":["No","Si"],"issues":[]},{"field":"descripcion_documentos_tipo","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":497,"sampleValues":["No definido","Convenios solidarios - Régimen artículo 95, Ley 2166 de 2021","Infraestructura de transporte","Sector de infraestructura social (Cultura, recreación y deporte)"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 497 (99.4%)"]},{"field":"direcci_n_de_ejecuci_n_del_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":368,"duplicatePct":0.264,"placeholderCount":1,"sampleValues":["CARRERA 7 No. 32-16 PISO 20 EDIFICIO SAN MARTIN\nBogotá\nDistrito Capital de Bogotá\nCOLOMBIA","CARRERA 24C No. 53-47 SUR\nBogotá\nDistrito Capital de Bogotá\nCOLOMBIA","CRA 32 N 12-81 \nBogotá\nDistrito Capital de Bogotá\nCOLOMBIA","CALLE 10 # 10 - 77\nLeticia\nAmazonas\nCOLOMBIA","Calle 34 N°43-31\nBarranquilla\nAtlántico\nCOLOMBIA"],"issues":[]}],"duplicateRows":0,"duplicateRowPct":0,"qualityScore":0,"issuesBySeverity":{"high":3,"medium":34,"low":2},"topIssues":[{"field":"ciudad","issue":"112 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"condiciones_de_entrega","issue":"151 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_de_pago_adelantado","issue":"498 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_facturado","issue":"221 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pendiente_de_pago","issue":"148 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pagado","issue":"256 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_amortizado","issue":"499 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pendiente_de","issue":"498 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pendiente_de_ejecucion","issue":"148 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"saldo_cdp","issue":"199 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"}]},"meta":{"dataset":"jbjy-vk9h","sample_size":500,"computed_at":"2026-08-11T04:59:39.161Z"}}