{"ok":true,"data":{"totalRows":500,"fieldCount":91,"fields":[{"field":"fecha_de_notificaci_n_de_prorrogaci_n","type":"date","total":500,"nonNull":50,"nullCount":450,"nullPct":0.9,"emptyStringCount":0,"uniqueCount":48,"duplicatePct":0.040000000000000036,"placeholderCount":0,"sampleValues":["2026-12-01T04:59:00.000","2023-12-16T04:59:00.000","2024-02-01T04:00:00.000","2021-10-22T17:00:00.000","2019-12-16T13:00:00.000"],"issues":["> 50% valores faltantes (90.0%)"],"date":{"earliest":"2018-07-01","latest":"2026-12-01","invalidCount":0}},{"field":"fecha_inicio_liquidacion","type":"date","total":500,"nonNull":50,"nullCount":450,"nullPct":0.9,"emptyStringCount":0,"uniqueCount":49,"duplicatePct":0.020000000000000018,"placeholderCount":0,"sampleValues":["2025-09-10T08:00:00.000","2026-12-16T08:00:00.000","2017-12-22T06:00:00.000","2030-01-01T23:59:00.000","2023-12-22T12:00:00.000"],"issues":["> 50% valores faltantes (90.0%)"],"date":{"earliest":"2017-12-22","latest":"2030-01-01","invalidCount":0}},{"field":"fecha_fin_liquidacion","type":"date","total":500,"nonNull":50,"nullCount":450,"nullPct":0.9,"emptyStringCount":0,"uniqueCount":50,"duplicatePct":0,"placeholderCount":0,"sampleValues":["2027-04-15T18:00:00.000","2018-04-12T18:00:00.000","2032-06-01T23:59:00.000","2023-12-23T12:00:00.000","2025-03-28T11:59:00.000"],"issues":["> 50% valores faltantes (90.0%)"],"date":{"earliest":"2018-04-12","latest":"2032-06-01","invalidCount":0}},{"field":"ultima_actualizacion","type":"date","total":500,"nonNull":317,"nullCount":183,"nullPct":0.366,"emptyStringCount":0,"uniqueCount":317,"duplicatePct":0,"placeholderCount":0,"sampleValues":["2026-03-17T13:54:58.326","2023-07-28T11:21:19.212","2026-09-11T11:26:21.521","2023-06-30T08:37:06.903","2026-06-22T12:06:31.308"],"issues":["Faltantes elevados (36.6%)"],"date":{"earliest":"2018-06-22","latest":"2026-10-29","invalidCount":0}},{"field":"fecha_de_inicio_del_contrato","type":"date","total":500,"nonNull":491,"nullCount":9,"nullPct":0.018,"emptyStringCount":0,"uniqueCount":473,"duplicatePct":0.03665987780040736,"placeholderCount":0,"sampleValues":["2022-02-01T12:00:00.000","2026-02-02T12:00:00.000","2023-01-25T12:00:00.000","2019-02-01T00:00:00.000","2026-01-26T12:00:00.000"],"issues":[],"date":{"earliest":"2017-12-13","latest":"2026-10-30","invalidCount":0}},{"field":"fecha_de_firma","type":"date","total":500,"nonNull":493,"nullCount":7,"nullPct":0.014,"emptyStringCount":0,"uniqueCount":493,"duplicatePct":0,"placeholderCount":0,"sampleValues":["2024-09-06T14:36:22.403","2025-03-03T19:13:06.908","2026-01-20T15:02:43.134","2025-03-12T16:25:08.234","2022-02-02T19:50:16.900"],"issues":[],"date":{"earliest":"2017-12-14","latest":"2026-10-30","invalidCount":0}},{"field":"nombre_entidad","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":324,"duplicatePct":0.352,"placeholderCount":0,"sampleValues":["(Secretaría Distrital de Integración Social)","SUBRED INTEGRADA DE SERVICIO DE SALUD CENTRO ORIENTE E.S.E 1","SUBRED INTEGRADA DE SERVICIOS DE SALUD SUR OCCIDENTE ESE.","INSTITUCIÓN UNIVERSITARIA ITM","MUNICIPIO DE ARMENIA QUINDIO"],"issues":[]},{"field":"nit_entidad","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":266,"duplicatePct":0.46799999999999997,"placeholderCount":0,"sampleValues":["899999061","899999034","890399011","8999990619","899999239"],"issues":[],"numeric":{"min":800000118,"max":9010347905,"mean":1515756766.228,"negativeCount":0,"zeroCount":0}},{"field":"departamento","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":31,"duplicatePct":0.938,"placeholderCount":11,"sampleValues":["Distrito Capital de Bogotá","Valle del Cauca","Antioquia","Atlántico","Cundinamarca"],"issues":[]},{"field":"ciudad","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":111,"duplicatePct":0.778,"placeholderCount":107,"sampleValues":["No Definido","Bogotá","Cali","Medellín","Barranquilla"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 107 (21.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,  Valle del Cauca ,  Cali","Colombia, Bogotá, Bogotá","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":24,"duplicatePct":0.952,"placeholderCount":0,"sampleValues":["Servicio Público","No aplica/No pertenece","Salud y Protección Social","Educación Nacional","defensa"],"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.6658824","CO1.BDOS.7744023","CO1.BDOS.9606774","CO1.BDOS.7704855","CO1.BDOS.2809198"],"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.6730680","CO1.PCCNTR.7594386","CO1.PCCNTR.8988493","CO1.PCCNTR.7633085","CO1.PCCNTR.3553906"],"issues":[]},{"field":"referencia_del_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":500,"duplicatePct":0,"placeholderCount":0,"sampleValues":["CO1.PCCNTR.6730680","AGU-PSP-1139-2025","1227 DE 2026","PS-0031-2025","CCS-20220222"],"issues":[]},{"field":"estado_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":8,"duplicatePct":0.984,"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":134,"duplicatePct":0.732,"placeholderCount":0,"sampleValues":["V1.80111600","V1.80111701","V1.80111620","V1.80111500","V1.80111601"],"issues":[]},{"field":"descripcion_del_proceso","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":496,"duplicatePct":0.008000000000000007,"placeholderCount":0,"sampleValues":["PRESTAR SERVICIOS DE APOYO A LA GESTION ASISTENCIAL","Prestar servicios profesionales especializados a la gestión administrativa y/o asistencial en el area de PIC; dentro de los diferentes procesos y procedimientos de la SUBRED INTEGRADA DE SERVICIOS DE SALUD SUR OCCIDENTE E.S.E. de acuerdo al requerimiento institucional.","Prestar los servicios de apoyo a la gestión con el fin de brindar soporte a las actividades adelantadas en la Secretaría de Infraestructura del proyecto denominado BP-26005375 RECUPERACIÓN DE LA INFRAESTRUCTURA VIAL DE SANTIAGO DE CALI","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.","CE_2024_DRA_BDC_TH_IINT_Prestación de servicios de apoyo a la gestión para realizar la verificación; \nrevisión de la validación; análisis y consistencia de la información recolectada por los censistas de \nbarrido durante el operativo de campo del Censo Económico Nacional Urbano en el municipio asig"],"issues":[]},{"field":"tipo_de_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":9,"duplicatePct":0.982,"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":9,"duplicatePct":0.982,"placeholderCount":0,"sampleValues":["Contratación directa","Contratación régimen especial","Mínima cuantía","Contratación régimen especial (con ofertas)","Contratación Directa (con ofertas)"],"issues":[]},{"field":"justificacion_modalidad_de","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":13,"duplicatePct":0.974,"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":"fecha_de_fin_del_contrato","type":"date","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":380,"duplicatePct":0.24,"placeholderCount":0,"sampleValues":["2025-12-31T23:59:00.000","2024-12-31T23:59:00.000","2026-12-31T23:59:00.000","2022-12-31T23:59:00.000","2025-12-30T23:59:00.000"],"issues":[],"date":{"earliest":"2017-12-22","latest":"2032-01-18","invalidCount":0}},{"field":"condiciones_de_entrega","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":8,"duplicatePct":0.984,"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":2,"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":499,"duplicatePct":0.0020000000000000018,"placeholderCount":2,"sampleValues":["No Definido","1042440422","1094728647","1061701920","40928898"],"issues":[]},{"field":"proveedor_adjudicado","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":500,"duplicatePct":0,"placeholderCount":0,"sampleValues":["MAROLIN MARTINEZ HERRERA","MARIA ALEJANDRA GIRALDO CRUZ","EDDY ALEJANDRA CAMPO IMBACHI","ESMERALDA MEDINA PALLARES","EDGAR HELY ROJAS PENAGOS"],"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":2,"duplicatePct":0.996,"placeholderCount":54,"sampleValues":["No","No Definido"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 54 (10.8%)"]},{"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":4,"duplicatePct":0.992,"placeholderCount":3,"sampleValues":["Inversión","Funcionamiento","No Definido","No aplica"],"issues":[]},{"field":"valor_del_contrato","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":438,"duplicatePct":0.124,"placeholderCount":8,"sampleValues":["0","4000000","30000000","12000000","24000000"],"issues":[],"numeric":{"min":0,"max":60347966436,"mean":245470903.91516,"negativeCount":0,"zeroCount":8}},{"field":"valor_de_pago_adelantado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":500,"sampleValues":["0"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 500 (100.0%)"],"numeric":{"min":0,"max":0,"mean":0,"negativeCount":0,"zeroCount":500}},{"field":"valor_facturado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":257,"duplicatePct":0.486,"placeholderCount":218,"sampleValues":["0","12000000","16000000","14000000","15000000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 218 (43.6%)"],"numeric":{"min":0,"max":2534960144.76,"mean":27585835.955620002,"negativeCount":0,"zeroCount":218}},{"field":"valor_pendiente_de_pago","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":328,"duplicatePct":0.344,"placeholderCount":153,"sampleValues":["0","9000000","24000000","4000000","8400000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 153 (30.6%)"],"numeric":{"min":0,"max":60347966436,"mean":227037221.5242,"negativeCount":0,"zeroCount":153}},{"field":"valor_pagado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":233,"duplicatePct":0.534,"placeholderCount":248,"sampleValues":["0","16000000","14000000","7200000","10800000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 248 (49.6%)"],"numeric":{"min":0,"max":650167918,"mean":18433682.39096,"negativeCount":0,"zeroCount":248}},{"field":"valor_amortizado","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":500,"sampleValues":["0"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 500 (100.0%)"],"numeric":{"min":0,"max":0,"mean":0,"negativeCount":0,"zeroCount":500}},{"field":"valor_pendiente_de","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":500,"sampleValues":["0"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 500 (100.0%)"],"numeric":{"min":0,"max":0,"mean":0,"negativeCount":0,"zeroCount":500}},{"field":"valor_pendiente_de_ejecucion","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":328,"duplicatePct":0.344,"placeholderCount":153,"sampleValues":["0","9000000","24000000","4000000","8400000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 153 (30.6%)"],"numeric":{"min":0,"max":60347966436,"mean":227037221.5242,"negativeCount":0,"zeroCount":153}},{"field":"saldo_cdp","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":287,"duplicatePct":0.42600000000000005,"placeholderCount":199,"sampleValues":["0","1000000000","4000000","30000000","23897000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 199 (39.8%)"],"numeric":{"min":0,"max":150883551000,"mean":1697741659.694,"negativeCount":0,"zeroCount":199}},{"field":"saldo_vigencia","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":10,"duplicatePct":0.98,"placeholderCount":491,"sampleValues":["0","2744681514144","34598640367","28417538914","5344660000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 491 (98.2%)"],"numeric":{"min":0,"max":2744681514144,"mean":5628568870.946,"negativeCount":0,"zeroCount":491}},{"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":45,"duplicatePct":0.91,"placeholderCount":425,"sampleValues":["0","61","30","31","60"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 425 (85.0%)"],"numeric":{"min":0,"max":273,"mean":9.362,"negativeCount":0,"zeroCount":425}},{"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","FinConflicto"],"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","OSPRUDS","RFARCVC"],"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":499,"duplicatePct":0.0020000000000000018,"placeholderCount":0,"sampleValues":["Sin Descripcion","Marolin Martínez herrera","MARIA ALEJANDRA GIRALDO CRUZ","Eddy Alejandra Campo Imbachi","ESMERALDA FRANCISCA MEDINA PALLARES"],"issues":[]},{"field":"nacionalidad_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":5,"duplicatePct":0.99,"placeholderCount":2,"sampleValues":["CO","No definido","ES","CY","US"],"issues":[]},{"field":"domicilio_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":181,"duplicatePct":0.638,"placeholderCount":320,"sampleValues":["No Definido","Carrera 28 # 17A - 69","CARRERA 21A 20A 51","CALLE 9 E 8 45","CALLE 149 # 117 - 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","Otro"],"issues":[]},{"field":"identificaci_n_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":180,"duplicatePct":0.64,"placeholderCount":1,"sampleValues":["Sin Descripcion","1061701920","37949438","52271253","1113037295"],"issues":[]},{"field":"g_nero_representante_legal","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":130,"sampleValues":["Mujer","Hombre","No Definido","Otro"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 130 (26.0%)"]},{"field":"presupuesto_general_de_la_nacion_pgn","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":90,"duplicatePct":0.8200000000000001,"placeholderCount":409,"sampleValues":["0","23897000","47374970","10007333","35700000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 409 (81.8%)"],"numeric":{"min":0,"max":60347966436,"mean":189511505.564,"negativeCount":0,"zeroCount":409}},{"field":"sistema_general_de_participaciones","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":32,"duplicatePct":0.9359999999999999,"placeholderCount":469,"sampleValues":["0","3700000","7680000","22215193","266624838"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 469 (93.8%)"],"numeric":{"min":0,"max":2086696780,"mean":6756884.442,"negativeCount":0,"zeroCount":469}},{"field":"sistema_general_de_regal_as","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":7,"duplicatePct":0.986,"placeholderCount":494,"sampleValues":["0","147278700","205615000","22000000","19728653"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 494 (98.8%)"],"numeric":{"min":0,"max":205615000,"mean":886188.568,"negativeCount":0,"zeroCount":494}},{"field":"recursos_propios_alcald_as_gobernaciones_y_resguardos_ind_genas_","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":191,"duplicatePct":0.618,"placeholderCount":283,"sampleValues":["0","30000000","9000000","24000000","14400000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 283 (56.6%)"],"numeric":{"min":0,"max":661683217,"mean":12794404.636,"negativeCount":0,"zeroCount":283}},{"field":"recursos_de_credito","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":497,"sampleValues":["0","200000000","32446867","1000000000"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 497 (99.4%)"],"numeric":{"min":0,"max":1000000000,"mean":2464893.734,"negativeCount":0,"zeroCount":497}},{"field":"recursos_propios","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":107,"duplicatePct":0.786,"placeholderCount":393,"sampleValues":["0","12000000","55000000","35554000","40143655"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 393 (78.6%)"],"numeric":{"min":0,"max":11204685337,"mean":29287315.758,"negativeCount":0,"zeroCount":393}},{"field":"codigo_entidad","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":323,"duplicatePct":0.354,"placeholderCount":0,"sampleValues":["702271321","702769076","702486788","703000075","701365033"],"issues":[],"numeric":{"min":700037070,"max":724889027,"mean":703776365.048,"negativeCount":0,"zeroCount":0}},{"field":"codigo_proveedor","type":"number","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":500,"duplicatePct":0,"placeholderCount":0,"sampleValues":["728258468","725637540","718801111","713437671","714849544"],"issues":[],"numeric":{"min":700014079,"max":737978429,"mean":714273315.884,"negativeCount":0,"zeroCount":0}},{"field":"objeto_del_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":496,"duplicatePct":0.008000000000000007,"placeholderCount":1,"sampleValues":["PRESTAR SERVICIOS DE APOYO A LA GESTION ASISTENCIAL","Prestar servicios profesionales especializados a la gestión administrativa y/o asistencial en el area de PIC; dentro de los diferentes procesos y procedimientos de la SUBRED INTEGRADA DE SERVICIOS DE SALUD SUR OCCIDENTE E.S.E. de acuerdo al requerimiento institucional.","Prestar los servicios de apoyo a la gestión con el fin de brindar soporte a las actividades adelantadas en la Secretaría de Infraestructura del proyecto denominado BP-26005375 RECUPERACIÓN DE LA INFRAESTRUCTURA VIAL DE SANTIAGO DE CALI","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.","CE_2024_DRA_BDC_TH_IINT_Prestación de servicios de apoyo a la gestión para realizar la verificación; \nrevisión de la validación; análisis y consistencia de la información recolectada por los censistas de \nbarrido durante el operativo de campo del Censo Económico Nacional Urbano en el municipio asignado"],"issues":[]},{"field":"duraci_n_del_contrato","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":187,"duplicatePct":0.626,"placeholderCount":16,"sampleValues":["6 Mes(es)","4 Mes(es)","3 Mes(es)","Dia(s)","5 Mes(es)"],"issues":[]},{"field":"nombre_del_banco","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":41,"duplicatePct":0.918,"placeholderCount":334,"sampleValues":["No definido","BANCOLOMBIA","Bancolombia","DAVIVIENDA","Davivienda"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 334 (66.8%)"]},{"field":"tipo_de_cuenta","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":334,"sampleValues":["No Definido","Ahorros","Corriente"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 334 (66.8%)"]},{"field":"n_mero_de_cuenta","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":161,"duplicatePct":0.6779999999999999,"placeholderCount":340,"sampleValues":["No definido","176070427610","29076406128","24066121701","91257832428"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 340 (68.0%)"]},{"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":322,"duplicatePct":0.356,"placeholderCount":141,"sampleValues":["No definido","MARIA ELENA ESTRADA OSORIO","JUAN CAMILO CHAVARRO MARÍN","NORA ELVIRA ANILLO ROMERO","ANDRES EDUARDO GOMEZ MARTINEZ"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 141 (28.2%)"]},{"field":"tipo_de_documento_ordenador_del_gasto","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":6,"duplicatePct":0.988,"placeholderCount":142,"sampleValues":["Cédula de Ciudadanía","No definido","Otro","Cédula de Extranjería","Citizenship Identification"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 142 (28.4%)"]},{"field":"n_mero_de_documento_ordenador_del_gasto","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":319,"duplicatePct":0.362,"placeholderCount":142,"sampleValues":["No definido","44002042","1136880706","45523791","8000068503"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 142 (28.4%)"]},{"field":"nombre_supervisor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":311,"duplicatePct":0.378,"placeholderCount":181,"sampleValues":["No definido","GIOVANNY WALTER IBAÑEZ PRADA","Germán Alberto Cardona Quintero","LIDA ESPERANZA MONTENEGRO PARRA","YEISA ALEJANDRA TORRES RODRIGUEZ"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 181 (36.2%)"]},{"field":"tipo_de_documento_supervisor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":181,"sampleValues":["Cédula de Ciudadanía","No definido","Citizenship Identification","Otro"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 181 (36.2%)"]},{"field":"n_mero_de_documento_supervisor","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":311,"duplicatePct":0.378,"placeholderCount":181,"sampleValues":["No definido","8736558","71743005","59822047","1090393747"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 181 (36.2%)"]},{"field":"nombre_ordenador_de_pago","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":74,"duplicatePct":0.852,"placeholderCount":420,"sampleValues":["No definido","PATRICIA RIOS CUELLAR","Maria Nelly Florez Rodriguez","Germán Alberto Cardona Quintero","LESLY JURLIET ESCUDERO GIRALDO"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 420 (84.0%)"]},{"field":"tipo_de_documento_ordenador_de_pago","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":4,"duplicatePct":0.992,"placeholderCount":420,"sampleValues":["No definido","Cédula de Ciudadanía","Otro","Tarjeta de Identidad"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 420 (84.0%)"]},{"field":"n_mero_de_documento_ordenador_de_pago","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":74,"duplicatePct":0.852,"placeholderCount":420,"sampleValues":["No definido","60349374","64578030","71743005","1017135438"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 420 (84.0%)"]},{"field":"documentos_tipo","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":3,"duplicatePct":0.994,"placeholderCount":78,"sampleValues":["No","No definido","Si"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 78 (15.6%)"]},{"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","Catastro multipropósito - Contratos interadministrativos","Infraestructura de transporte","Convenios solidarios - Régimen artículo 95, Ley 2166 de 2021"],"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":371,"duplicatePct":0.258,"placeholderCount":0,"sampleValues":["CARRERA 7 No. 32-16 PISO 20 EDIFICIO SAN MARTIN\nBogotá\nDistrito Capital de Bogotá\nCOLOMBIA","Calle 73 No. 76A - 354; Vía al Volador\nMedellín\nAntioquia\nCOLOMBIA","CL 72 22 42 OF 301\nBogotá\nDistrito Capital de Bogotá\nCOLOMBIA","carrera 3  calle entre calle 10 y 11 edificio gobernacion del tolima\nIbagué\nTolima\nCOLOMBIA","Calle 66 No 15 - 41\nBogotá\nDistrito Capital de Bogotá\nCOLOMBIA"],"issues":[]},{"field":"criterios_de_sostenibilidad_ambiental","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":2,"duplicatePct":0.996,"placeholderCount":493,"sampleValues":["No definido","No"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 493 (98.6%)"]},{"field":"requisitos_ambientales_en_las_especificaciones_t_cnicas","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":500,"sampleValues":["No definido"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 500 (100.0%)"]},{"field":"criterios_ambientales_en_la_evaluaci_n_de_las_ofertas","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":500,"sampleValues":["No definido"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 500 (100.0%)"]},{"field":"obligaciones_contractuales_o_poscontractuales_a_nivel_ambiental","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":500,"sampleValues":["No definido"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 500 (100.0%)"]},{"field":"uso_de_etiquetado_ecol_gico","type":"text","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":500,"sampleValues":["No definido"],"issues":["Placeholders frecuentes (\"No Definido\"/\"N/A\"): 500 (100.0%)"]},{"field":"obligaciones_posconsumo","type":"bool","total":500,"nonNull":500,"nullCount":0,"nullPct":0,"emptyStringCount":0,"uniqueCount":1,"duplicatePct":0.998,"placeholderCount":0,"sampleValues":["No"],"issues":[]}],"duplicateRows":0,"duplicateRowPct":0,"qualityScore":0,"issuesBySeverity":{"high":3,"medium":41,"low":0},"topIssues":[{"field":"ciudad","issue":"107 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"condiciones_de_entrega","issue":"151 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"habilita_pago_adelantado","issue":"54 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_de_pago_adelantado","issue":"500 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_facturado","issue":"218 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pendiente_de_pago","issue":"153 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pagado","issue":"248 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_amortizado","issue":"500 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pendiente_de","issue":"500 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"},{"field":"valor_pendiente_de_ejecucion","issue":"153 placeholders (\"No Definido\"/\"N/A\")","severity":"medium"}]},"meta":{"dataset":"jbjy-vk9h","sample_size":500,"computed_at":"2026-11-09T14:36:26.173Z"}}