('R',322,3,1,'2026-06-03','04:17:41','2026-06-03','1003079783','El operador se desplazó al inmueble con el fin de atender la orden por inconformidad en el consumo. En terreno, el funcionario procedió a realizar la toma de lectura de control y a inspeccionar el cuadro de micromedición, constatando que el medidor funciona correctamente y que la lectura impresa en la factura es verídica. No obstante, al realizar la prueba del indicador de movimiento con las llaves del predio cerradas, el técnico detectó un registro activo y constante de flujo de agua, comprobando la existencia de una fuga interna localizada en el área del baño. El funcionario notificó el hallazgo en sitio al suscriptor, explicándole que el desperdicio de agua ocurrió después del medidor dentro de su propiedad privada.'),('R',322,10,1,'2026-06-03','04:21:14','2026-06-03','1003079783','Se califica el trámite como No Procedente Atendido. Se verificó el informe de inspección técnica, donde quedó plenamente demostrado que el incremento en el valor de la factura no obedeció a errores de lectura o fallas del medidor imputables a la empresa, sino a un consumo real y medido originado por una fuga interna en el baño del inmueble.'),('R',322,20,1,'2026-06-03','04:22:20','2026-06-03','1003079783','No Procedente Atendido. Se verificó el informe de inspección técnica, donde quedó plenamente demostrado que el incremento en el valor de la factura no obedeció a errores de lectura o fallas del medidor imputables a la empresa, sino a un consumo real y medido originado por una fuga interna en el baño del inmueble.'),('R',323,1,0,'2026-06-03','04:34:16','2026-06-03','1003079783',''),('R',323,2,0,'2026-06-03','04:34:16','2026-06-03','1003079783','Visita Programada'),('R',323,3,1,'2026-06-03','04:37:54','2026-06-03','1003079783','El operador se desplazó al predio y ejecutó la inspección técnica operativa para analizar la inconformidad con el consumo. En terreno, el funcionario procedió a verificar el número de serie del medidor y constató la lectura actual, confirmando que la secuencia registrada por el lector en el periodo en disputa fue bien tomada.'),('R',323,10,1,'2026-06-03','04:39:15','2026-06-03','1003079783','Se califica el trámite como No Procedente Atendido. Se verificó el informe técnico de campo, donde quedó demostrado que la facturación se encuentra debidamente liquidada y que los consumos cobrados corresponden fielmente a los registros del medidor.'),('R',323,20,1,'2026-06-03','04:40:15','2026-06-03','1003079783','No Procedente Atendido. Se verificó el informe técnico de campo, donde quedó demostrado que la facturación se encuentra debidamente liquidada y que los consumos cobrados corresponden fielmente a los registros del medidor.');
/*!40000 ALTER TABLE `sucesos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tidano`
--

DROP TABLE IF EXISTS `tidano`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tidano` (
  `td_tidano` char(4) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidano`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tidano`
--

LOCK TABLES `tidano` WRITE;
/*!40000 ALTER TABLE `tidano` DISABLE KEYS */;
INSERT INTO `tidano` (`td_tidano`, `td_descri`) VALUES ('0','NO APLICA');
/*!40000 ALTER TABLE `tidano` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tidocu`
--

DROP TABLE IF EXISTS `tidocu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tidocu` (
  `td_tidocu` char(2) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidocu`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tidocu`
--

LOCK TABLES `tidocu` WRITE;
/*!40000 ALTER TABLE `tidocu` DISABLE KEYS */;
INSERT INTO `tidocu` (`td_tidocu`, `td_descri`) VALUES ('CC','Cedula Ciudadania'),('CE','Cedula de Extranjeria'),('NI','NIT');
/*!40000 ALTER TABLE `tidocu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiprec`
--

DROP TABLE IF EXISTS `tiprec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tiprec` (
  `tr_tiprec` char(1) NOT NULL,
  `tr_codrec` int(3) NOT NULL,
  `tr_descri` char(50) DEFAULT NULL,
  `tr_codsui` int(2) NOT NULL DEFAULT '0',
  `tr_reporte` int(3) NOT NULL,
  `tr_causal` varchar(1) NOT NULL,
  PRIMARY KEY (`tr_tiprec`,`tr_codrec`,`tr_codsui`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tiprec`
--

LOCK TABLES `tiprec` WRITE;
/*!40000 ALTER TABLE `tiprec` DISABLE KEYS */;
INSERT INTO `tiprec` (`tr_tiprec`, `tr_codrec`, `tr_descri`, `tr_codsui`, `tr_reporte`, `tr_causal`) VALUES ('P',548,'Descuento Por Predio Desocupado',3,114,'F'),('P',547,'Solicitud de Aforo',3,0,''),('P',546,'Reconexion, reinstalacion',1,0,''),('P',538,'Requerimientos SSPD',3,0,''),('P',537,'Requerimientos Entes oficiales o Entidades externa',3,0,''),('P',536,'Pago parcial',3,0,''),('P',535,'Pago de la factura de otro usuario',3,0,''),('P',534,'Notificacion y/o descargos',3,0,''),('P',533,'Informacion general',3,0,''),('P',532,'Gestionar financiacion',3,0,''),('P',531,'Exencion contribucion',3,0,''),('P',530,'Emision de documento para pago',3,0,''),('P',529,'Direccion incorrecta',3,106,'F'),('P',528,'Devolucion y/o copia de documentos',3,0,''),('P',527,'Devolucion de saldo a favor',3,0,''),('P',526,'Cambio de uso',3,118,'F'),('P',525,'Cambio de datos basicos',3,216,'F'),('R',523,'Tarifa  incorrecta',3,119,'F'),('R',522,'Suspension por mutuo acuerdo',3,115,'F'),('R',521,'Subsidios y Contribuciones',3,112,'F'),('R',520,'Solicitud de rompimiento de solidaridad',3,123,'F'),('R',519,'Pago sin abono a cuenta',3,122,'F'),('R',518,'Inconformidad por cobros por normalizacion del ser',3,131,'F'),('R',517,'Inconformidad con el consumo o produccion facturad',3,102,'F'),('R',516,'Inconformidad con el servicio a usuario CICLO 1',3,312,'P'),('R',515,'Inconformidad con el aforo',3,101,'F'),('R',514,'Estrato incorrecto',3,117,'F'),('R',513,'Cobro de otros bienes o servicios en la factura',3,113,'F'),('R',512,'Cobro multiple y/o acumulado',3,107,'F'),('R',511,'Cobros por servicios no prestados',3,105,'F'),('R',510,'Cobros por conexion, reconexion, reinstalacion',3,109,'F'),('R',509,'Cobros por promedio',3,120,'F'),('R',508,'Cobro por consumos dejados de facturar o recuperac',3,129,'F'),('R',507,'Cobros inoportunos',3,103,'F'),('R',506,'Cobro de cargos relacionados con el servicio publi',3,111,'F'),('R',504,'Cobro desconocido',3,104,'F'),('R',503,'Cobro de revisiones',3,124,'F'),('R',502,'Cobro de acuerdo de pago o financiacion',3,130,'F'),('R',501,'Clase de uso incorrecto',3,118,'F'),('S',405,'Otros',3,0,''),('S',403,'Verificar servicio',3,0,''),('S',402,'Verificacion de Pagos',3,0,''),('Q',307,' Cambio de Nombre y/o Direccion',3,0,''),('Q',306,' Otro tipo de Queja',3,0,''),('P',539,'Solicitud de Acometida',3,1,''),('Q',301,' No llega el Agua',1,0,''),('Q',302,' Varios Dias Sin Servicio de Agua',1,0,''),('Q',303,' Llega el Agua en Mal Estado',1,0,''),('Q',301,' Alcantarilla Tapada',2,0,''),('Q',302,' Alcantarilla Sin Tapa',2,0,''),('Q',304,' Agua llega con Poca Presion',1,0,''),('Q',305,' Fuga de Agua Potable',1,0,''),('Q',306,' Otro tipo de Queja',1,0,''),('Q',307,' Cambio de Nombre y/o Direccion',1,0,''),('Q',309,' Robo de Medidor',1,0,''),('S',401,'Verificacion de Lectura',1,0,''),('S',402,'Verificación de Pagos',1,0,''),('S',403,'Verificar servicio',1,0,''),('S',405,'Otros',1,0,''),('Q',308,'Calidad de Agua',1,0,''),('S',406,'Verificacion Reconexion',1,0,''),('Q',310,'Fuga por Suspension/Reconexion',1,0,''),('Q',311,'Inconformidad con la Suspension/Reconexion',1,0,''),('Q',312,'Fuga por Instalación de Medidor',1,0,''),('Q',313,'Resane pendiente por Instalación de Medidor',1,0,''),('R',501,'Clase de uso incorrecto',1,118,'F'),('R',502,'Cobro de acuerdo de pago o financiacion',1,130,'F'),('R',503,'Cobro de revisiones',1,124,'F'),('R',504,'Cobro desconocido',1,104,'F'),('R',505,'Cobro de medidor',1,110,'F'),('R',506,'Cobro de cargos relacionados con el servicio publi',1,111,'F'),('R',507,'Cobros inoportunos',1,103,'F'),('R',508,'Cobro por consumos dejados de facturar o recuperac',1,129,'F'),('R',509,'Cobros por promedio',1,120,'F'),('R',510,'Cobros por conexion, reconexion, reinstalacion',1,109,'F'),('R',511,'Cobros por servicios no prestados',1,105,'F'),('R',512,'Cobro multiple y/o acumulado',1,107,'F'),('R',513,'Cobro de otros bienes o servicios en la factura',1,113,'F'),('R',514,'Estrato incorrecto',1,117,'F'),('R',515,'Inconformidad con el aforo',1,101,'F'),('R',516,'Inconformidad con el servicio a usuario CICLO 1',1,312,'P'),('R',517,'Inconformidad con el consumo o produccion facturad',1,102,'F'),('R',518,'Inconformidad por cobros por normalizacion del ser',1,131,'F'),('R',519,'Pago sin abono a cuenta',1,122,'F'),('R',520,'Solicitud de rompimiento de solidaridad',1,123,'F'),('R',521,'Subsidios y Contribuciones',1,112,'F'),('R',522,'Suspension por mutuo acuerdo',1,115,'F'),('R',523,'Tarifa  incorrecta',1,119,'F'),('P',524,'Agua en bloque',1,0,'P'),('P',525,'Cambio de datos basicos',1,216,'F'),('P',526,'Cambio de uso',1,118,'F'),('P',527,'Devolucion de saldo a favor',1,0,''),('P',528,'Devolucion y/o copia de documentos',1,0,''),('P',529,'Direccion incorrecta',1,106,'F'),('P',530,'Emision de documento para pago',1,0,''),('P',531,'Exencion contribucion',1,0,''),('P',532,'Gestionar financiacion',1,0,''),('P',533,'Informacion general',1,0,''),('P',534,'Notificacion y/o descargos',1,0,''),('P',535,'Pago de la factura de otro usuario',1,0,''),('P',536,'Pago parcial',1,0,''),('P',537,'Requerimientos Entes oficiales o Entidades externa',1,0,''),('P',538,'Requerimientos SSPD',1,0,''),('P',539,'Requererimiento competencia de otra empresa',1,0,''),('P',540,'Revision presunto SAP',1,0,''),('P',541,'Solicitud constancia lectura',1,0,''),('P',542,'Suspension o corte del servicio',1,309,'P'),('P',543,'Terminacion del contrato',1,0,''),('P',544,'Trabajos tecnicos',1,0,''),('Q',545,'Afectacion ambiental\n',1,0,''),('Q',546,'Cambio de medidor o equipo de medida',1,307,'P'),('Q',547,'Comportamiento de funcionario, trabajador o contra',1,0,''),('Q',548,'Demora en atender peticion',1,0,''),('Q',549,'Demora en reparar da?o',1,0,''),('Q',550,'Entrega inoportuna o no entrega de la factura',1,108,'F'),('Q',551,'Falla en la conexion del servicio',1,401,'I'),('Q',552,'Falla en la prestacion del servicio por calidad',1,304,'P'),('Q',553,'Falla en la prestacion del servicio por continuida',1,303,'P'),('Q',554,'Inadecuada disposicion de residuos',1,0,''),('Q',555,'Inconformidad con el canal de atencion',1,0,''),('Q',556,'Inconformidad con la informacion',1,0,''),('Q',557,'Inconformidad en la atencion de condiciones de seg',1,306,'P'),('Q',558,'Inconformidad por la prog. de interrupciones del s',1,0,''),('Q',559,'Inconformidad punto de venta y/o recaudo',1,0,''),('Q',560,'Inconformidad trabajos',1,0,''),('Q',561,'Inconformidad venta portafolio',1,0,''),('Q',562,'Incumplimiento de la revision en las fechas establ',1,0,''),('Q',563,'Levantamiento de desechos vegetales',1,0,''),('Q',564,'Manejo de fauna y flora',1,0,''),('Q',565,'Negacion de la solicitud de suspension',1,301,'P'),('Q',566,'No conexion del servicio',1,402,'I'),('Q',567,'No se genera factura para una instalacion',1,0,''),('Q',568,'Suspension o corte del servicio',1,309,''),('Q',569,'Terminacion del contrato',1,308,'P'),('S',570,'Ampliar los plazos para pago de las facturas',1,0,''),('S',571,'Aumentar cobertura a otros municipios',1,0,''),('S',572,'Colocar dispensadores',1,0,''),('S',573,'Colocar entretenimiento en puntos de atencion',1,0,''),('S',574,'Colocar fotocopiadora',1,0,''),('S',575,'Colocar mas puntos de pago',1,0,''),('S',576,'Colocar telefonos publicos',1,0,''),('S',577,'Contar con mas acompa?amiento de gestores sociales',1,0,''),('S',578,'Crear nuevos planes de financiacion',1,0,''),('S',579,'Entrega de material educativo',1,0,''),('S',580,'Felicitaciones',1,0,''),('S',581,'Incrementar puntos de atencion',1,0,''),('S',582,'Mejorar componentes de los servicios',1,0,''),('S',583,'Mejorar factura',1,0,''),('S',584,'Mejorar tiempos de solucion a problemas tecnicos',1,0,''),('S',585,'Notificar antes de realizar trabajos',1,0,''),('S',586,'Simplificar tramites',1,0,''),('S',587,'Verificacion de presunta irregularidad',1,0,''),('S',588,'Verificar publicidad',1,0,''),('R',501,'Clase de uso incorrecto',2,118,'F'),('R',502,'Cobro de acuerdo de pago o financiacion',2,130,'F'),('R',503,'Cobro de revisiones',2,124,'F'),('R',504,'Cobro desconocido',2,104,'F'),('R',505,'Cobro de medidor',2,110,'F'),('R',506,'Cobro de cargos relacionados con el servicio publi',2,111,'F'),('R',507,'Cobros inoportunos',2,103,'F'),('R',508,'Cobro por consumos dejados de facturar o recuperac',2,129,'F'),('R',509,'Cobros por promedio',2,120,'F'),('R',510,'Cobros por conexion, reconexion, reinstalacion',2,109,'F'),('R',511,'Cobros por servicios no prestados',2,105,'F'),('R',512,'Cobro multiple y/o acumulado',2,107,'F'),('R',513,'Cobro de otros bienes o servicios en la factura',2,113,'F'),('R',514,'Estrato incorrecto',2,117,'F'),('R',515,'Inconformidad con el aforo',2,101,'F'),('R',516,'Inconformidad con el servicio a usuario CICLO 1',2,312,'P'),('R',517,'Inconformidad con el consumo o produccion facturad',2,102,'F'),('R',518,'Inconformidad por cobros por normalizacion del ser',2,131,'F'),('R',519,'Pago sin abono a cuenta',2,122,'F'),('R',520,'Solicitud de rompimiento de solidaridad',2,123,'F'),('R',521,'Subsidios y Contribuciones',2,112,'F'),('R',522,'Suspension por mutuo acuerdo',2,115,'F'),('R',523,'Tarifa  incorrecta',2,119,'F'),('P',524,'Agua en bloque',2,0,'P'),('P',525,'Cambio de datos basicos',2,216,'F'),('P',526,'Cambio de uso',2,118,'F'),('P',527,'Devolucion de saldo a favor',2,0,''),('P',528,'Devolucion y/o copia de documentos',2,0,''),('P',529,'Direccion incorrecta',2,106,'F'),('P',530,'Emision de documento para pago',2,0,''),('P',531,'Exencion contribucion',2,0,''),('P',532,'Gestionar financiacion',2,0,''),('P',533,'Informacion general',2,0,''),('P',534,'Notificacion y/o descargos',2,0,''),('P',535,'Pago de la factura de otro usuario',2,0,''),('P',536,'Pago parcial',2,0,''),('P',537,'Requerimientos Entes oficiales o Entidades externa',2,0,''),('P',538,'Requerimientos SSPD',2,0,''),('P',539,'Requererimiento competencia de otra empresa',2,0,''),('P',540,'Reboso Alcantarillado',2,0,''),('P',541,'Solicitud constancia lectura',2,0,''),('P',542,'Suspension o corte del servicio',2,309,'P'),('P',543,'Terminacion del contrato',2,0,''),('P',544,'Trabajos tecnicos',2,0,''),('Q',545,'Afectacion ambiental\n',2,0,''),('Q',546,'Cambio de medidor o equipo de medida',2,307,'P'),('Q',547,'Comportamiento de funcionario, trabajador o contra',2,0,''),('Q',548,'Demora en atender peticion',2,0,''),('Q',549,'Demora en reparar da?o',2,0,''),('Q',550,'Entrega inoportuna o no entrega de la factura',2,108,'F'),('Q',551,'Falla en la conexion del servicio',2,401,'I'),('Q',552,'Falla en la prestacion del servicio por calidad',2,304,''),('Q',553,'Falla en la prestacion del servicio por calidad',2,304,'P'),('Q',554,'Inadecuada disposicion de residuos',2,0,''),('Q',555,'Inconformidad con el canal de atencion',2,0,''),('Q',556,'Inconformidad con la informacion',2,0,''),('Q',557,'Inconformidad en la atencion de condiciones de seg',2,306,'P'),('Q',558,'Inconformidad por la prog. de interrupciones del s',2,0,''),('Q',559,'Inconformidad punto de venta y/o recaudo',2,0,''),('Q',560,'Inconformidad trabajos',2,0,''),('Q',561,'Inconformidad venta portafolio',2,0,''),('Q',562,'Incumplimiento de la revision en las fechas establ',2,0,''),('Q',563,'Levantamiento de desechos vegetales',2,0,''),('Q',564,'Manejo de fauna y flora',2,0,''),('Q',565,'Negacion de la solicitud de suspension',2,301,'P'),('Q',566,'No conexion del servicio',2,402,'I'),('Q',567,'No se genera factura para una instalacion',2,0,''),('Q',568,'Suspension o corte del servicio',2,309,''),('Q',569,'Terminacion del contrato',2,308,'P'),('S',570,'Ampliar los plazos para pago de las facturas',2,0,''),('S',571,'Aumentar cobertura a otros municipios',2,0,''),('S',572,'Colocar dispensadores',2,0,''),('S',573,'Colocar entretenimiento en puntos de atencion',2,0,''),('S',574,'Colocar fotocopiadora',2,0,''),('S',575,'Colocar mas puntos de pago',2,0,''),('S',576,'Colocar telefonos publicos',2,0,''),('S',577,'Contar con mas acompa?amiento de gestores sociales',2,0,''),('S',578,'Crear nuevos planes de financiacion',2,0,''),('S',579,'Entrega de material educativo',2,0,''),('S',580,'Felicitaciones',2,0,''),('S',581,'Incrementar puntos de atencion',2,0,''),('S',582,'Mejorar componentes de los servicios',2,0,''),('S',583,'Mejorar factura',2,0,''),('S',584,'Mejorar tiempos de solucion a problemas tecnicos',2,0,''),('S',585,'Notificar antes de realizar trabajos',2,0,''),('S',586,'Simplificar tramites',2,0,''),('S',587,'Verificacion de presunta irregularidad',2,0,''),('S',588,'Verificar publicidad',2,0,''),('P',539,'Solicitud de Acometida',0,1,''),('P',545,'Solicitud de Acometida',1,0,''),('P',545,'Solicitud de Acometida',2,0,''),('P',549,'Revision de Centro de Medicion',1,0,''),('P',550,'Revision Instalaciones y Acometida',1,0,''),('P',551,'Cambio de Registro / Materiales',1,0,''),('P',602,'Frecuencias Adicionales  de Recolccion',3,311,'P'),('P',601,'Frecuencias Adicionales de Barrido',3,310,'P'),('P',600,'Descuento por no Recoleccion Puerta a Puerta',3,132,'F'),('R',599,'Inconformidad por Desviaci?n Significativa',2,127,'F'),('R',599,'Inconformidad por Desviaci?n Significativa',1,127,'F'),('R',598,'lectura Incorrecta',1,126,'F'),('P',597,'Multiusuario del Servicio de Aseo',3,125,'F'),('P',596,'Cobro Por Numero de Unidades Independientes',3,116,'F'),('R',596,'Cobro de Consumo Registrado por  Medidor de otro P',1,121,'F'),('R',596,'Cobro de Consumo Registrado por  Medidor de otro P',2,121,'F'),('R',596,'Cobro de Consumo Registrado por  Medidor de otro P',3,121,'F'),('R',595,'Servicios no Vigilados por la SSPD',3,100,'F'),('R',595,'Cambio llave de Paso',2,100,'F'),('R',595,'Servicios no Vigilados por la SSPD',1,100,'F'),('Q',570,'Terminacion del contrato',3,308,'P'),('Q',553,'Falla en la prestacion del servicio por continuida',3,303,'P'),('Q',552,'Falla en la prestacion del servicio por calidad',3,304,'P'),('',550,'Entrega inoportuna o no entrega de la factura',3,108,'F'),('3',313,'Tardanza para realizar un trabajo',3,0,''),('Q',312,'Daño por vehiculo recolector',3,0,''),('Q',311,'El carro no ha pasado por el Sector',3,0,''),('Q',310,'Calidad del Servicio',3,0,'');
/*!40000 ALTER TABLE `tiprec` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tramites`
--

DROP TABLE IF EXISTS `tramites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tramites` (
  `tm_pqr` char(1) NOT NULL,
  `tm_numero` int(9) NOT NULL,
  `tm_nromat` int(9) NOT NULL,
  `tm_codrec` int(3) NOT NULL,
  `tm_fecreg` date DEFAULT NULL,
  `tm_horreg` time NOT NULL DEFAULT '00:00:00',
  `tm_tidocu` char(2) NOT NULL,
  `tm_numdoc` char(12) NOT NULL,
  `tm_nomsol` char(40) NOT NULL,
  `tm_telsol` char(40) NOT NULL,
  `tm_celsol` char(50) NOT NULL,
  `tm_dirsol` char(40) NOT NULL,
  `tm_medio` char(1) NOT NULL,
  `tm_estado` char(1) NOT NULL,
  `tm_califi` char(1) DEFAULT NULL,
  `tm_feccon` date DEFAULT NULL,
  `tm_horcon` time NOT NULL DEFAULT '00:00:00',
  `tm_codser` int(2) NOT NULL,
  `tm_sitio` char(4) NOT NULL,
  `tm_codbar` int(4) NOT NULL,
  `tm_nrofac` int(9) DEFAULT NULL,
  `tm_rectip` char(1) DEFAULT NULL,
  `tm_recnum` int(9) DEFAULT NULL,
  `tm_recssp` char(1) DEFAULT NULL,
  `tm_dirnot` varchar(50) NOT NULL,
  `tm_notele` char(1) NOT NULL,
  `tm_tidano` varchar(4) NOT NULL,
  `tm_codrec_ad1` int(3) NOT NULL,
  `tm_codrec_ad2` int(3) NOT NULL,
  `tm_codrec_ad3` int(3) NOT NULL,
  `tm_codrec_ad4` int(3) NOT NULL,
  `tm_fecven` date NOT NULL,
  `tm_feccit` date NOT NULL,
  `tm_fecnot` date NOT NULL,
  `tm_fecrec` date NOT NULL,
  `tm_fecamp` date NOT NULL,
  `tm_causa` int(3) NOT NULL,
  `tm_imputa` varchar(2) NOT NULL,
  PRIMARY KEY (`tm_pqr`,`tm_numero`),
  KEY `tm_codrec` (`tm_codrec`),
  KEY `tm_tidocu` (`tm_tidocu`),
  KEY `tm_codser` (`tm_codser`),
  KEY `tm_sitio` (`tm_sitio`),
  KEY `tm_codbar` (`tm_codbar`),
  KEY `tramites_nromat_fkey` (`tm_nromat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tramites`
--

LOCK TABLES `tramites` WRITE;
/*!40000 ALTER TABLE `tramites` DISABLE KEYS */;
INSERT INTO `tramites` (`tm_pqr`, `tm_numero`, `tm_nromat`, `tm_codrec`, `tm_fecreg`, `tm_horreg`, `tm_tidocu`, `tm_numdoc`, `tm_nomsol`, `tm_telsol`, `tm_celsol`, `tm_dirsol`, `tm_medio`, `tm_estado`, `tm_califi`, `tm_feccon`, `tm_horcon`, `tm_codser`, `tm_sitio`, `tm_codbar`, `tm_nrofac`, `tm_rectip`, `tm_recnum`, `tm_recssp`, `tm_dirnot`, `tm_notele`, `tm_tidano`, `tm_codrec_ad1`, `tm_codrec_ad2`, `tm_codrec_ad3`, `tm_codrec_ad4`, `tm_fecven`, `tm_feccit`, `tm_fecnot`, `tm_fecrec`, `tm_fecamp`, `tm_causa`, `tm_imputa`) VALUES ('R',1,2186630,517,'2021-01-19','03:31:59','CC','50999080','florentina ariza','3128551966','','B. Ramon Rubio','V','C','1','2021-01-19','04:23:50',1,'1',1,2186630,'R',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2021-02-08','2021-02-12','2021-02-15','2021-02-19','0000-00-00',0,'S'),('R',2,32300,517,'2021-01-19','04:35:31','CC','50999080','YADIRA GAMBOA','3128551966','','C 6 10 11','T','C','1','2021-01-19','05:03:58',1,'1',1,32300,'',0,'','C 6 10 11','N','0',0,0,0,0,'2021-02-08','2021-02-12','2021-02-15','2021-02-19','0000-00-00',0,'N'),('Q',1,2186260,551,'2021-01-19','05:39:48','CC','50999080','JUANA PEREZ','3128551966','','CALLE 10','V','C','2','2021-01-21','10:29:13',1,'xx',1,0,'',0,'','','N','0',0,0,0,0,'2021-02-08','2021-02-12','2021-02-15','2021-02-19','0000-00-00',47,'N'),('R',3,20221600,305,'2021-01-22','09:40:03','CC','78290661','RAFAEL EMILIO ORTEGA VASQUEZ','3205875435','','B. Ramon Rubio','V','C','4','2021-02-03','03:13:34',1,'1',1,20221600,'',0,'R','B. Ramon Rubio','N','0',0,0,0,0,'2021-02-11','2021-02-17','2021-02-18','2021-02-24','0000-00-00',55,'N'),('R',4,20239200,517,'2021-01-22','10:01:42','CC','1063276959','ALEXANDER ARROYO ARBOLEDA','3126471674','','B. Ramon Rubio','V','A','','0000-00-00','00:00:00',1,'1',1,20239200,'',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2021-02-11','2021-02-17','2021-02-18','2021-02-24','0000-00-00',0,''),('P',1,191800,551,'2021-01-25','03:07:06','CC','25991562','MARTHA CECILIA DE LA OSSA LUCAS','3122599544','','BARRIO 7 DE SEPTIEMBRE','E','C','1','2021-02-11','04:11:08',1,'1',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-02-12','2021-02-18','2021-02-19','2021-02-25','0000-00-00',16,'N'),('P',2,191800,544,'2021-01-25','03:22:25','CC','25991562','MARTHA CECILIA DE LA OSSA LUCAS','3122599544','','BARRIO 7 DE SEPTIEMBRE','E','C','4','2021-02-03','03:18:37',1,'xx',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-02-12','2021-02-18','2021-02-19','2021-02-25','0000-00-00',45,'N'),('P',3,20224200,549,'2021-01-25','04:55:56','CC','25999274','VIVIANA MARCELO MARTINEZ','3136011151','','','V','C','1','2021-02-11','03:29:42',1,'1',1,20224200,'',0,'','','N','0',0,0,0,0,'2021-02-12','2021-02-18','2021-02-19','2021-02-25','0000-00-00',45,'S'),('P',4,2186630,525,'2021-01-26','11:31:18','CC','1047496677','YEIS DANIELA PEREZ ESPINOSA','3008015109','','B. Ramon Rubio','E','C','1','2021-02-12','08:30:48',1,'1',1,2186630,'',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2021-02-15','2021-02-19','2021-02-22','2021-02-26','0000-00-00',50,'S'),('S',1,194700,582,'2021-01-26','11:52:34','CC','78590859','ALBERT ENRIQUE GONZALEZ DUQUE','3126539513','','C 14 12d 06','V','C','1','2021-02-12','08:38:54',1,'1',1,194700,'',0,'','C 14 12d 06','N','0',0,0,0,0,'2021-02-15','2021-02-19','2021-02-22','2021-02-26','0000-00-00',48,'S'),('P',5,162100,544,'2021-01-27','09:33:25','CC','50999402','LEDIS SIBAJA','3135640759','','BARRIO PALMIRA CARRERA 9','V','C','1','2021-02-11','04:32:31',1,'1',1,0,'',0,'','BARRIO PALMIRA CARRERA 9 ','N','0',0,0,0,0,'2021-02-16','2021-02-22','2021-02-23','2021-03-01','0000-00-00',45,'S'),('P',6,162100,544,'2021-01-27','09:37:25','CC','50999402','LEDIS SIBAJA','3135640759','','BARRIO PALMIRA CARRERA 9','V','C','4','2021-02-03','02:45:52',1,'1',1,0,'',0,'','BARRIO PALMIRA CARRERA 9 ','N','0',0,0,0,0,'2021-02-16','2021-02-22','2021-02-23','2021-03-01','0000-00-00',45,'N'),('P',7,20235200,544,'2021-01-27','03:37:15','CC','1063786794','','3128987934','','BARRIO EL PARAISO','V','C','1','2021-02-11','04:47:20',1,'1',1,0,'',0,'','BARRIO EL PARAISO ','N','0',0,0,0,0,'2021-02-16','2021-02-22','2021-02-23','2021-03-01','0000-00-00',48,'S'),('P',8,20235200,544,'2021-01-27','03:43:29','CC','1063786794','LEIDYS BENITEZ','3128987934','','BARRIO EL PARAISO','V','C','1','2021-02-12','08:49:48',1,'1',1,0,'',0,'','BARRIO EL PARAISO ','N','0',0,0,0,0,'2021-02-16','2021-02-22','2021-02-23','2021-03-01','0000-00-00',45,'S'),('P',9,160900,549,'2021-01-27','05:20:15','CC','50947046','RUBYS SANCHEZ','3135672776','','BARRIO PALMIRA CARRERA  FUNERARIA','V','C','4','2021-02-03','02:42:35',1,'1',1,0,'',0,'','BARRIO PALMIRA CARRERA  FUNERARIA ','N','0',0,0,0,0,'2021-02-16','2021-02-22','2021-02-23','2021-03-01','0000-00-00',55,'N'),('P',10,170700,549,'2021-01-28','02:50:02','CC','1063356765','JOSE OSUNA','3107443112','','BARRIO 7 DE SEPTIEMBRE','V','C','1','2021-02-12','10:17:47',1,'1',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-02-17','2021-02-23','2021-02-24','2021-03-02','0000-00-00',55,'N'),('P',11,1770900,544,'2021-01-29','10:41:59','CC','34883969','REINA MARGOTH PARRA','3147426116','','BARRIO 7 DE SEPTIEMBRE D 13a 12C-53','V','C','4','2021-02-03','02:46:44',1,'1',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-02-18','2021-02-24','2021-02-25','2021-03-03','0000-00-00',48,'N'),('P',12,2476500,525,'2021-01-29','11:09:14','CC','1063284854','DARLIS KARINA ROJAS PARRA','3122599544','','BARRIO RAMON RUBIO','V','C','1','2021-02-12','10:25:02',1,'1',1,0,'',0,'','BARRIO RAMON RUBIO','N','0',0,0,0,0,'2021-02-18','2021-02-24','2021-02-25','2021-03-03','0000-00-00',50,'S'),('P',13,37300,544,'2021-01-29','03:34:57','CC','78506104','AURELIO ALARCON','','','AGUAS VIVAS CALLE #2','V','C','1','2021-02-12','10:31:43',1,'1',1,37300,'',0,'','AGUAS VIVAS CALLE #2','N','0',0,0,0,0,'2021-02-18','2021-02-24','2021-02-25','2021-03-03','0000-00-00',45,'S'),('P',14,0,545,'2021-02-03','08:19:59','CC','78112015','JAIDER HUERTAS ESPINOSA','3002087201','','BARRIO GUADALUPE','E','C','1','2021-02-15','10:53:00',1,'1',1,0,'',0,'','BARRIO GUADALUPE','N','0',0,0,0,0,'2021-02-23','2021-03-01','2021-03-02','2021-03-08','0000-00-00',48,'S'),('P',15,0,545,'2021-02-03','11:19:39','CC','15039642','ORLANDO ORTEGA BORJA','3205529193','','BARRIO PARAISO 2','E','C','1','2021-02-12','10:37:48',1,'1',1,0,'',0,'','BARRIO PARAISO 2','N','0',0,0,0,0,'2021-02-23','2021-03-01','2021-03-02','2021-03-08','0000-00-00',48,'S'),('R',5,0,517,'2021-02-03','11:25:37','CC','1063357402','JULIO EDER GONZALEZ','3144533401','','BARRIO 20 DE JULIO','V','C','1','2021-02-12','10:44:23',1,'1',1,0,'',0,'','BARRIO 20 DE JULIO ','N','0',0,0,0,0,'2021-02-23','2021-03-01','2021-03-02','2021-03-08','0000-00-00',55,'N'),('R',6,0,517,'2021-02-03','02:35:45','CC','34884150','ENEIDA PINEDA MIRANDA','3107479386','','BARRIO AGUAS VIVAS','V','C','3','2021-02-12','10:58:23',1,'1',1,0,'',0,'','BARRIO AGUAS VIVAS','N','0',0,0,0,0,'2021-02-23','2021-03-01','2021-03-02','2021-03-08','0000-00-00',55,'N'),('R',7,21900,517,'2021-02-03','03:55:12','CC','25984885','DOLORES JARAMILLO','','','BARRIO EL CENTRO','V','C','3','2021-02-12','11:07:53',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-02-23','2021-03-01','2021-03-02','2021-03-08','0000-00-00',12,'N'),('R',8,42100,517,'2021-02-03','05:09:38','CC','50997627','NOHELIA SAEZ','3218290163','','C 5 11 22','V','C','3','2021-02-12','11:12:55',1,'1',1,486,'',0,'','C 5 11 22','N','0',0,0,0,0,'2021-02-23','2021-03-01','2021-03-02','2021-03-08','0000-00-00',12,'N'),('R',9,56220,517,'2021-02-04','10:06:43','CC','10994863','','3135447172','','','V','C','3','2021-02-16','03:29:48',1,'xx',1,652,'',0,'','','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',10,56220,517,'2021-02-04','10:28:42','CC','10994863','','3135447172','','BARRIO 20 DE JULIO','V','C','3','2021-02-16','03:19:57',1,'1',1,652,'',0,'','','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',11,25200,517,'2021-02-04','10:35:46','CC','1063365433','','3233859802','','C 4 9 60','V','C','3','2021-02-16','03:22:16',1,'1',1,298,'',0,'','C 4 9 60','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('P',16,87300,544,'2021-02-04','10:55:56','CC','30060131','YADIRA DIAZ','3227582201','','D 9a 13a 20','V','C','1','2021-02-15','05:03:11',1,'1',1,1010,'',0,'','D 9a 13a 20','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',48,'S'),('R',12,56220,517,'2021-02-04','11:05:29','CC','10994863','ELIAS GONZALEZ','3135447172','','BARRIO 20 DE JULIO','V','C','3','2021-02-16','03:24:11',1,'1',1,652,'',0,'','BARRIO 20 DE JULIO ','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',13,149900,517,'2021-02-04','11:13:19','CC','78763682','ARGELIDO VERGARA','3205987589','','K 10 10 26','V','C','3','2021-02-15','05:00:39',1,'1',1,1766,'',0,'','K 10 10 26','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',26,'N'),('R',14,25200,517,'2021-02-04','11:19:08','CC','1063365433','YIRIS CASTRO','3233859802','','C 4 9 60','V','C','3','2021-02-15','04:55:42',1,'1',1,298,'',0,'','C 4 9 60','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',53,'N'),('R',15,56220,517,'2021-02-04','11:25:04','CC','10994863','ELIAS GONZALEZ','3135447172','','BARRIO 20 DE JULIO','V','C','3','2021-02-15','04:48:55',1,'1',1,652,'',0,'','BARRIO 20 DE JULIO','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',16,'N'),('R',16,122000,517,'2021-02-04','02:52:11','CC','30059944','MARIA CORONADO','','','K 8 9 30','V','C','1','2021-02-15','04:41:13',1,'1',1,1424,'',0,'','K 8 9 30','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',14,'S'),('R',17,147400,517,'2021-02-04','02:59:24','CC','8203934','MIGUEL DIAZ','3202418362','','C 14 9 02','V','C','3','2021-02-15','04:38:17',1,'1',1,1732,'',0,'','C 14 9 02','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',53,'N'),('R',18,160100,517,'2021-02-04','03:09:57','CC','78587816','ISMAEL PEREZ','3107356490','','BARRIO PALMIRA','V','C','3','2021-02-15','04:35:21',1,'1',1,1903,'',0,'','C 16 9b 24','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',19,115800,517,'2021-02-04','03:34:32','CC','50999231','CARIDAD GUZMAN','3206043544','','K 11 9 54','V','C','3','2021-02-15','04:26:16',1,'1',1,1360,'',0,'','K 11 9 54','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',0,'N'),('R',20,160400,517,'2021-02-04','03:47:07','CC','','ARELIS THERAN','3113487896','','BARRIO PALMIRA','V','C','3','2021-02-15','04:20:13',1,'1',1,1907,'',0,'','C 16 12c 33','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',21,124200,517,'2021-02-04','04:11:56','CC','98656452','ANDRES SOTO','3104204946','','BARRIO SAN JOSE','V','C','3','2021-02-15','04:15:26',1,'1',1,1449,'',0,'','K 7 6 71','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',22,18300,517,'2021-02-04','04:22:11','CC','30060217','AMERICA GONZALEZ','3114298115','','BARRIO MIRAFLORES','V','C','3','2021-02-15','03:48:15',1,'1',1,223,'',0,'','K 7 5a 04','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',23,75300,517,'2021-02-04','04:28:00','CC','30653748','NANCY AVILA','3117161622','','BARRIO VENDE AGUJAS','V','C','3','2021-02-15','03:56:58',1,'1',1,872,'',0,'','C 8 11 24','N','0',0,0,0,0,'2021-02-24','2021-03-02','2021-03-03','2021-03-09','0000-00-00',55,'N'),('R',24,112300,598,'2021-02-05','10:50:48','CC','1063361449','ADRIANA ENSUNCHO','3017722722','','BARRIO 23 DE MARZO','V','A','','0000-00-00','00:00:00',1,'1',1,1320,'',0,'','C 9 13 99','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',0,''),('R',25,184800,517,'2021-02-05','11:04:21','CC','78589976','WILSON ROMERO','3135882340','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-02-16','03:34:25',1,'1',1,2208,'',0,'','K 12c 13 49','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',55,'N'),('R',26,20236000,598,'2021-02-05','11:09:56','CC','78590630','JORGE ANDRES SILVA','3137611632','','BARRIO EL PARAISO','E','C','1','2021-02-16','03:43:48',1,'xx',1,5065,'',0,'','','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',6,'S'),('R',27,72400,509,'2021-02-05','11:17:57','CC','1063276659','MARIA CENTENO','3017550987','','LAS CRUCES','V','C','3','2021-02-16','03:45:37',1,'1',1,841,'',0,'','K 11 8 37','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',55,'N'),('R',28,149700,517,'2021-02-05','03:13:59','CC','25910811','MARTHA ALVAREZ','3205726278','','CAMILO JIMENEZ','V','C','3','2021-02-16','03:47:23',1,'1',1,1763,'',0,'','K 10 10 29','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',55,'N'),('R',29,2770000,517,'2021-02-05','03:19:20','CC','1003081257','CARLOS MARIO ORTEGA','3136919006','','RAMON RUBIO','V','C','3','2021-02-22','08:54:21',1,'1',1,3843,'',0,'','','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',55,'N'),('R',30,2270000,517,'2021-02-05','03:24:32','CC','1003081257','CARLOS MARIO ORTEGA','3136919006','','B. Ramon Rubio Calle 10','V','C','3','2021-02-15','05:19:35',1,'1',1,2715,'',0,'','B. Ramon Rubio Calle 10','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',37,'N'),('R',31,76700,517,'2021-02-05','03:28:07','CC','34883603','ROSIRIS LOPÉZ','3136010218','','VENDE AGUJAS','V','C','3','2021-02-15','05:15:52',1,'1',1,888,'',0,'','K 12 8 11','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',55,'N'),('R',32,184100,517,'2021-02-05','03:36:32','CC','78587117','NATAN CALDERA','3145495233','','K 12d 13c 30','V','C','3','2021-02-15','05:13:45',1,'1',1,2200,'',0,'','K 12d 13c 30','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',37,'N'),('R',33,125950,523,'2021-02-05','03:41:07','CC','25995891','ROSORIS HERNANDEZ','','','BARRIO SAN JOSE','V','C','1','2021-02-15','05:06:58',1,'1',1,1468,'',0,'','','N','0',0,0,0,0,'2021-02-25','2021-03-03','2021-03-04','2021-03-10','0000-00-00',18,'N'),('R',34,102700,598,'2021-02-08','11:13:32','CC','1148435013','JOSE ALVAREZ','3057517476','','LA UNION','V','C','1','2021-02-18','05:14:06',1,'1',1,0,'',0,'','BARRIO LA UNION','N','0',0,0,0,0,'2021-02-26','2021-03-04','2021-03-05','2021-03-11','0000-00-00',14,'S'),('R',35,102700,598,'2021-02-08','11:23:12','CC','1148435013','JOSE ALVAREZ','3057517476','','K 6 8a 25','V','C','1','2021-02-18','05:15:09',1,'1',1,1188,'',0,'','LA UNION','N','0',0,0,0,0,'2021-02-26','2021-03-04','2021-03-05','2021-03-11','0000-00-00',14,'S'),('R',36,2600850,511,'2021-02-08','11:32:11','CC','50999445','ANA BALMASEDA','3107091414','','BARRIO RAMON RUBIO','V','C','3','2021-02-18','05:07:46',1,'1',1,3120,'',0,'','','N','0',0,0,0,0,'2021-02-26','2021-03-04','2021-03-05','2021-03-11','0000-00-00',55,'N'),('R',37,2600850,511,'2021-02-08','11:32:11','CC','50999445','ANA BALMASEDA','3107091414','','BARRIO RAMON RUBIO','V','C','3','2021-02-18','05:04:03',1,'1',1,3120,'',0,'','','N','0',0,0,0,0,'2021-02-26','2021-03-04','2021-03-05','2021-03-11','0000-00-00',55,'N'),('P',17,172716,544,'2021-02-08','02:51:53','CC','50870398','NUR MARIA FERNANDEZ PASTRANA','','','BARRIO 7 DE SEPTIEMBRE','E','C','1','2021-02-22','08:58:50',1,'1',1,2070,'',0,'','','N','0',0,0,0,0,'2021-02-26','2021-03-04','2021-03-05','2021-03-11','0000-00-00',48,'N'),('P',18,196037,544,'2021-02-08','03:50:33','CC','','YONEIDA URIBE','3116738250','','BARRIO PALMIRA','T','C','1','2021-02-16','03:54:21',2,'xx',1,2414,'',0,'','','N','0',0,0,0,0,'2021-02-26','2021-03-04','2021-03-05','2021-03-11','0000-00-00',45,'N'),('P',19,189950,544,'2021-02-10','03:53:26','CC','1063365031','MILVIA TAPIAZ','3148038410','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-02-22','09:04:18',1,'xx',1,2279,'',0,'','','N','0',0,0,0,0,'2021-03-02','2021-03-08','2021-03-09','2021-03-15','0000-00-00',48,'N'),('P',20,0,545,'2021-02-11','08:25:55','CC','50997856','MILADYS MARIA CALLE VAQUERO','3012572528','','BARRIO 7 DE SEPTIEMBRE','E','C','1','2021-02-26','04:14:38',1,'1',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-03-03','2021-03-09','2021-03-10','2021-03-16','0000-00-00',48,'N'),('R',38,68420,517,'2021-02-11','09:36:51','CC','','SERVIENTREGA','XXX','','Calle 8 Cra 9','V','C','1','2021-02-18','05:10:21',1,'1',1,795,'',0,'','Calle 8 Cra 9','N','0',0,0,0,0,'2021-03-03','2021-03-09','2021-03-10','2021-03-16','0000-00-00',14,'S'),('P',21,192800,544,'2021-02-17','04:24:59','CC','34883718','DORIS AVILA','3235259422','','K 12c 14 26','V','C','3','2021-02-22','09:09:31',1,'1',1,2315,'',0,'','K 12c 14 26','N','0',0,0,0,0,'2021-03-09','2021-03-15','2021-03-16','2021-03-23','0000-00-00',48,'N'),('R',39,43000,517,'2021-02-22','09:11:48','CC','1129575035','ELIZABETH LAGARES','3041409878','','C 5 12 67','V','C','3','2021-03-08','10:52:29',1,'1',1,495,'',0,'','C 5 12 67','N','0',0,0,0,0,'2021-03-12','2021-03-18','2021-03-19','2021-03-26','0000-00-00',58,'N'),('P',22,154500,544,'2021-03-01','04:55:09','CC','1003080554','YEIS BEDOYA','','','K 10 13 55','V','C','1','2021-03-23','10:29:21',1,'1',1,1839,'',0,'','K 10 13 55','N','0',0,0,0,0,'2021-03-19','2021-03-26','2021-03-29','2021-04-06','0000-00-00',50,'N'),('P',23,20214800,544,'2021-03-03','08:30:31','CC','78296533','ISIDRO MORALES','3202183170','','BARRIO RAMON RUBIO','V','C','1','2021-03-23','10:35:42',1,'1',1,10098,'',0,'','BARRIO RAMON RUBIO','N','0',0,0,0,0,'2021-03-24','2021-03-30','2021-03-31','2021-04-08','0000-00-00',48,'N'),('R',40,68420,517,'2021-03-03','09:13:21','CC','98656023','ABRHAN DAVID CARCAMO','3105082031','','Calle 8 Cra 9','V','C','1','2021-03-25','10:13:11',1,'1',1,5946,'',0,'','Calle 8 Cra 9','N','0',0,0,0,0,'2021-03-24','2021-03-30','2021-03-31','2021-04-08','0000-00-00',14,'N'),('R',41,20226000,517,'2021-03-03','10:07:00','CC','50999459','ROSA SALAS','3146737820','','B/ Paraiso','V','C','3','2021-03-25','10:59:24',1,'1',1,10157,'',0,'','B/ Paraiso','N','0',0,0,0,0,'2021-03-24','2021-03-30','2021-03-31','2021-04-08','0000-00-00',55,'N'),('P',24,0,544,'2021-03-03','04:14:34','CC','34883978','NASTA MONTIEL','3114196929','','BARRIO 7 DE SEPTIEMBRE','V','C','1','2021-03-25','10:45:47',1,'1',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-03-24','2021-03-30','2021-03-31','2021-04-08','0000-00-00',48,'N'),('R',42,69400,517,'2021-03-03','04:21:13','CC','10905304','ERASMO GOMEZ','XXX','','BARRIO LAS CRUCES','V','C','3','2021-03-25','10:51:47',1,'1',1,0,'',0,'','BARRIO LAS CRUCES','N','0',0,0,0,0,'2021-03-24','2021-03-30','2021-03-31','2021-04-08','0000-00-00',55,'N'),('P',25,153700,544,'2021-03-03','05:06:34','CC','6887749','ALBERTO AVILEZ','3202401076','','K 11a 13 35','V','C','1','2021-03-23','09:43:03',1,'1',1,6980,'',0,'','K 11a 13 35','N','0',0,0,0,0,'2021-03-24','2021-03-30','2021-03-31','2021-04-08','0000-00-00',48,'N'),('P',26,165850,544,'2021-03-03','05:19:13','CC','1063303831','YAIR MONTERROZA','3142244303','','K 9 N? 17 44','V','C','1','2021-03-17','04:02:30',1,'1',1,7127,'',0,'','K 9 N? 17 44','N','0',0,0,0,0,'2021-03-24','2021-03-30','2021-03-31','2021-04-08','0000-00-00',48,'N'),('R',43,43800,517,'2021-03-04','03:29:43','CC','34884420','MARLENIS RAMOS','3136527432','','BARRIO VENDE AGUJAS','V','C','3','2021-03-25','11:10:32',1,'1',1,0,'',0,'','BARRIO VENDE AGUJAS','N','0',0,0,0,0,'2021-03-25','2021-03-31','2021-04-05','2021-04-09','0000-00-00',55,'N'),('R',44,57600,517,'2021-03-04','03:39:02','CC','14863142','YUNEISY GONZALEZ','3137639181','','K 13a 4 39','V','C','3','2021-03-25','11:12:58',1,'1',1,5821,'',0,'','K 13a 4 39','N','0',0,0,0,0,'2021-03-25','2021-03-31','2021-04-05','2021-04-09','0000-00-00',55,'N'),('R',45,20217000,517,'2021-03-04','03:43:06','CC','27127401','EVELIN CABEZAS','3117643262','','B. Ramon Rubio','V','C','3','2021-03-25','11:16:29',1,'1',1,10109,'',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2021-03-25','2021-03-31','2021-04-05','2021-04-09','0000-00-00',55,'N'),('R',46,169400,517,'2021-03-04','03:46:36','CC','78291457','RAFAEL ALVARADO','3145059155','','C 16 9 42','V','C','3','2021-03-25','11:25:04',1,'1',1,7173,'',0,'','C 16 9 42','N','0',0,0,0,0,'2021-03-25','2021-03-31','2021-04-05','2021-04-09','0000-00-00',55,'N'),('R',47,2601500,517,'2021-03-04','03:57:25','CC','78320285','ELIASID ALVAREZ VEGA','3218539491','','BARRIO RAMON RUBIO','V','C','3','2021-03-25','04:25:04',1,'1',1,8285,'',0,'','BARRIO RAMON RUBIO','N','0',0,0,0,0,'2021-03-25','2021-03-31','2021-04-05','2021-04-09','0000-00-00',55,'N'),('R',48,60800,517,'2021-03-04','04:00:48','CC','1063356768','FRANCISCO LOPEZ','3137756638','','K 8 6 20','V','C','3','2021-03-25','04:30:44',1,'1',1,5861,'',0,'','K 8 6 20','N','0',0,0,0,0,'2021-03-25','2021-03-31','2021-04-05','2021-04-09','0000-00-00',55,'N'),('R',49,134800,517,'2021-03-04','04:06:05','CC','1063366440','KELLY RUBIO','3106479522','','K 8 5a 10','V','C','3','2021-03-25','04:37:23',1,'1',1,6737,'',0,'','K 8 5a 10','N','0',0,0,0,0,'2021-03-25','2021-03-31','2021-04-05','2021-04-09','0000-00-00',55,'N'),('P',27,0,545,'2021-03-08','11:03:27','CC','1069486987','PAOLA PINEDA ARRIETA','','','BARRIO VENDE AGUJAS','E','C','1','2021-03-26','03:51:22',1,'1',1,0,'',0,'','CALLE #6 12-67','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',48,'N'),('R',50,31250,517,'2021-03-08','11:15:59','CC','25995829','SIRLY SANCHEZ','3215751915','','BARRIO AGUAS VIVAS','V','C','3','2021-03-26','03:56:02',1,'1',1,5517,'',0,'','','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',55,'N'),('R',51,66400,517,'2021-03-08','11:22:00','CC','','FRANCIA UPARELA','3138795655','','K 9 8 75','V','C','3','2021-03-26','03:58:07',1,'1',1,5925,'',0,'','K 9 8 75','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',55,'N'),('R',52,20228400,517,'2021-03-08','11:29:40','CC','1193552324','LUZ DARY GOMEZ','3046017898','','B. Ramon Rubio','V','C','3','2021-03-26','04:02:17',1,'1',1,10170,'',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',0,'N'),('R',53,97600,517,'2021-03-08','11:32:17','CC','6675900','SABINO CONSERVANTES','','','K 8 8a 25','V','C','1','2021-03-26','04:08:14',1,'1',1,6275,'',0,'','K 8 8a 25','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',14,'N'),('R',54,116900,517,'2021-03-08','11:36:13','CC','34943944','RAQUEL PRASCA','3115479697','','K 10 9 75','V','C','3','2021-03-26','04:10:44',1,'1',1,6522,'',0,'','K 10 9 75','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',55,'N'),('R',55,54900,517,'2021-03-08','11:39:57','CC','15720457','JAIDER CONDE','','','C 2 10 30','V','C','3','2021-03-26','04:12:49',1,'1',1,5786,'',0,'','C 2 10 30','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',55,'N'),('R',56,104000,517,'2021-03-08','11:43:27','CC','1063282857','MARICELA RUIZ','','','BARRIO LA UNION','V','C','3','2021-03-26','04:17:29',1,'1',1,6353,'',0,'','Cra 7 N? 8-71','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',53,'N'),('R',57,20222600,517,'2021-03-08','11:46:37','CC','1063282857','MARICELA RUIZ','3114361454','','B/ El Paraiso','V','C','3','2021-03-26','04:20:20',1,'1',1,10138,'',0,'','B/ El Paraiso','N','0',0,0,0,0,'2021-03-29','2021-04-06','2021-04-07','2021-04-13','0000-00-00',55,'N'),('P',28,20231600,544,'2021-03-10','10:50:52','CC','30060303','DIGNA ROMERO','','','B. El Paraiso','V','C','1','2021-03-26','04:30:08',1,'1',1,10190,'',0,'','B. El Paraiso','N','0',0,0,0,0,'2021-03-31','2021-04-08','2021-04-09','2021-04-15','0000-00-00',48,'N'),('P',29,80000,544,'2021-03-10','11:01:15','CC','50998498','MANUELA CHAVEZ','3114082534','','C 8 13 116','V','C','1','2021-03-26','04:35:31',1,'1',1,6075,'',0,'','C 8 13 116','N','0',0,0,0,0,'2021-03-31','2021-04-08','2021-04-09','2021-04-15','0000-00-00',53,'N'),('P',30,7900,544,'2021-03-11','03:35:36','CC','2804708','JORGE IVAN CALE','3135362973','','C 1a 7 01','V','C','1','2021-03-26','04:32:48',1,'1',1,5252,'',0,'','C 1a 7 01','N','0',0,0,0,0,'2021-04-05','2021-04-09','2021-04-12','2021-04-16','0000-00-00',48,'N'),('R',58,0,517,'2021-04-06','04:12:02','CC','78304267','OSCAR ESPINOZA','3016534188','','BARRIO PALMIRA','V','C','3','2021-04-14','09:46:22',1,'1',1,0,'',0,'','BARRIO PALMIRA CARRERA 9 ','N','0',0,0,0,0,'2021-04-26','2021-04-30','2021-05-03','2021-05-07','0000-00-00',55,'N'),('R',59,0,517,'2021-04-06','04:28:17','CC','30060767','SAIDETH MONTERROSA','3117186628','','BARRIO EL PARAISO','V','C','3','2021-04-14','09:54:19',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-26','2021-04-30','2021-05-03','2021-05-07','0000-00-00',55,'N'),('R',60,135850,517,'2021-04-06','04:32:28','CC','50997779','SMITH MENDOZA','3128606002','','BARRIO EL PROGRESO','V','C','3','2021-04-15','09:50:53',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-26','2021-04-30','2021-05-03','2021-05-07','0000-00-00',55,'N'),('R',61,93650,517,'2021-04-06','04:36:49','CC','26000778','ETIVIA LOPEZ','3135716286','','BARRIO EL EDEN','V','A','','0000-00-00','00:00:00',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-26','2021-04-30','2021-05-03','2021-05-07','0000-00-00',0,''),('R',62,170700,517,'2021-04-06','05:03:32','CC','1063356765','JOSE OZUNA','3107443112','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-04-15','09:55:43',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-26','2021-04-30','2021-05-03','2021-05-07','0000-00-00',55,'N'),('R',63,58000,517,'2021-04-06','05:06:31','CC','','CRISTOBAL SIMANCA','','','BARRIO EL EDEN','V','C','1','2021-04-15','10:02:53',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-26','2021-04-30','2021-05-03','2021-05-07','0000-00-00',0,'N'),('R',64,49900,517,'2021-04-07','05:11:40','CC','1063289023','JUAN CARLOS CONTRERAS','3215928334','','BARRIO VENDE AGUJAS','V','C','3','2021-04-15','10:05:36',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-27','2021-05-03','2021-05-04','2021-05-10','0000-00-00',55,'N'),('R',65,194954,517,'2021-04-07','05:15:33','CC','43893829','MARYURI RUA','3105462612','','','V','C','3','2021-04-15','10:06:49',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-27','2021-05-03','2021-05-04','2021-05-10','0000-00-00',55,'N'),('R',66,185700,517,'2021-04-07','05:17:49','CC','','TEODORO CALLE','','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-04-15','10:08:21',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-27','2021-05-03','2021-05-04','2021-05-10','0000-00-00',55,'N'),('P',31,20231200,544,'2021-04-07','05:20:04','CC','1003078968','AURINEL HERNANDEZ','3146836615','','BARRIO EL PARAISO','V','C','1','2021-04-16','10:16:39',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-27','2021-05-03','2021-05-04','2021-05-10','0000-00-00',48,'N'),('P',32,87500,544,'2021-04-07','05:25:31','CC','92507090','JAIDER MONTES','3107367024','','BARRIO 23 DE MARZO','V','C','1','2021-04-16','10:25:18',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-04-27','2021-05-03','2021-05-04','2021-05-10','0000-00-00',48,'N'),('P',33,152100,544,'2021-04-12','03:56:59','CC','','LICETH YOHANA PEREZ','','','C 15 10 13','V','C','1','2021-04-16','10:21:24',1,'1',1,149665,'',0,'','C 15 10 13','N','0',0,0,0,0,'2021-04-30','2021-05-06','2021-05-07','2021-05-13','0000-00-00',48,'N'),('R',67,23000,517,'2021-04-14','04:04:29','CC','25996225','RAFAELA TRESPALACIOS','3217116834','','BARRIO 20 DE JULIO','V','A','','0000-00-00','00:00:00',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-05-04','2021-05-10','2021-05-11','2021-05-18','0000-00-00',0,''),('R',68,121800,517,'2021-04-14','04:32:03','CC','','EULOGIO ROMERO','','','K 8 9 38','V','C','3','2021-04-23','02:52:49',1,'1',1,149221,'',0,'','K 8 9 38','N','0',0,0,0,0,'2021-05-04','2021-05-10','2021-05-11','2021-05-18','0000-00-00',55,'N'),('P',34,20236800,544,'2021-04-14','04:33:59','CC','1038098753','SADIS SALAZAR HERRERA','3113415362','','BARRIO EL PARAISO','V','C','3','2021-04-23','03:03:07',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-05-04','2021-05-10','2021-05-11','2021-05-18','0000-00-00',48,'N'),('P',35,163250,544,'2021-04-19','09:03:20','CC','1063366383','JOSE LUIS MENDOZA','3045399343','','C 18','V','C','1','2021-04-23','03:01:00',1,'1',1,149742,'',0,'','C 18','N','0',0,0,0,0,'2021-05-07','2021-05-13','2021-05-14','2021-05-21','0000-00-00',48,'N'),('R',69,10700,517,'2021-04-19','10:54:06','CC','25987957','CARMEN ALDANA','3135250688','','C 4 3 50','V','C','3','2021-04-23','02:59:03',1,'1',1,147930,'',0,'','C 4 3 50','N','0',0,0,0,0,'2021-05-07','2021-05-13','2021-05-14','2021-05-21','0000-00-00',55,'N'),('R',70,20243800,517,'2021-04-19','11:01:04','CC','25995839','25995839','3128292689','','BARRIO EL PARAISO','V','C','3','2021-04-23','02:55:32',1,'1',1,152906,'',0,'','','N','0',0,0,0,0,'2021-05-07','2021-05-13','2021-05-14','2021-05-21','0000-00-00',55,'N'),('R',71,84200,517,'2021-04-20','11:12:08','CC','1003308156','MIRLEYDIS NEGRETE','3113765970','','K 13b 8 35','V','C','3','2021-04-23','02:57:03',1,'1',1,148773,'',0,'','K 13b 8 35','N','0',0,0,0,0,'2021-05-10','2021-05-14','2021-05-18','2021-05-24','0000-00-00',55,'N'),('R',72,185800,517,'2021-05-07','10:41:53','CC','78291112','ISRAEL CALDERON GUZMAN','3147077283','','K 12b 13c 93','V','C','3','2021-05-20','03:29:34',1,'1',1,155173,'',0,'','K 12b 13c 93','N','0',0,0,0,0,'2021-05-28','2021-06-03','2021-06-04','2021-06-11','0000-00-00',55,'N'),('P',36,0,544,'2021-05-07','10:51:03','CC','','ELIZA HERNANDEZ','','','','V','C','1','2021-05-20','03:35:00',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-05-28','2021-06-03','2021-06-04','2021-06-11','0000-00-00',48,'N'),('R',73,92800,517,'2021-05-10','09:48:00','CC','34884076','ENERIS MEJIA','3105842660','','B/ Eden','V','C','1','2021-05-24','03:19:45',1,'1',1,154019,'',0,'','B/ Eden','N','0',0,0,0,0,'2021-05-31','2021-06-04','2021-06-08','2021-06-15','0000-00-00',14,'N'),('R',74,149900,517,'2021-05-10','10:00:59','CC','78763682','ARGELIO VERGARA','3205987589','','K 10 10 26','V','C','1','2021-05-24','04:01:20',1,'1',1,154717,'',0,'','K 10 10 26','N','0',0,0,0,0,'2021-05-31','2021-06-04','2021-06-08','2021-06-15','0000-00-00',6,'N'),('R',75,35600,517,'2021-05-10','10:15:24','CC','34884432','GLORIA  MACEA','3206134300','','C 2 11 69','V','C','3','2021-05-24','04:06:02',1,'1',1,153370,'',0,'','C 2 11 69','N','0',0,0,0,0,'2021-05-31','2021-06-04','2021-06-08','2021-06-15','0000-00-00',55,'N'),('R',76,0,0,'2021-05-10','10:18:26','CC','25995935','JUDITH  GONZALES','3015733044','','BARRIO VENDE AGUJAS','V','C','1','2021-05-24','04:10:31',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'1970-02-14','1970-02-18','1970-02-19','1970-02-23','1970-01-31',0,''),('R',77,140600,517,'2021-05-10','10:22:17','CC','','LEONOR MARIA  PADILLA','','','K 9 12 52','V','C','3','2021-05-24','03:23:29',1,'1',1,154605,'',0,'','K 9 12 52','N','0',0,0,0,0,'2021-05-31','2021-06-04','2021-06-08','2021-06-15','0000-00-00',55,'N'),('R',78,80700,517,'2021-05-10','10:33:38','CC','78585838','DANIEL CANSINO','3147827602','','C 8 13 26','V','C','3','2021-05-24','04:12:29',1,'1',1,153882,'',0,'','C 8 13 26','N','0',0,0,0,0,'2021-05-31','2021-06-04','2021-06-08','2021-06-15','0000-00-00',55,'N'),('R',79,32955,517,'2021-05-10','05:27:20','CC','34884334','ELEDA FUENTES','','','C 7 10 33','V','C','1','2021-05-24','04:14:02',1,'1',1,153348,'',0,'','C 7 10 33','N','0',0,0,0,0,'2021-05-31','2021-06-04','2021-06-08','2021-06-15','0000-00-00',48,'N'),('S',2,124500,582,'2021-05-10','05:31:25','CC','43668423','GUMERCINDA LOPEZ','3114331939','','K 7 4 02','V','C','1','2021-05-25','02:53:24',1,'1',1,154404,'',0,'','K 7 4 02','N','0',0,0,0,0,'2021-05-31','2021-06-04','2021-06-08','2021-06-15','0000-00-00',48,'N'),('R',80,186900,517,'2021-05-11','04:46:44','CC','1063365049','YONEYDIS MORENO','','','K 12c 13c 50','V','C','1','2021-05-31','08:20:08',1,'1',1,155188,'',0,'','K 12c 13c 50','N','0',0,0,0,0,'2021-06-01','2021-06-08','2021-06-09','2021-06-16','0000-00-00',48,'N'),('R',81,70100,517,'2021-05-12','03:22:40','CC','23987954','ETELVINA PEREZ','3145223054','','K 10 8 39','V','C','3','2021-05-24','03:50:14',1,'1',1,153767,'',0,'','K 10 8 39','N','0',0,0,0,0,'2021-06-02','2021-06-09','2021-06-10','2021-06-17','0000-00-00',55,'N'),('P',37,50350,544,'2021-05-13','04:47:45','CC','78590040','HECTOR MANCHEGO','3127342355','','Calle 12 B/ Vendeaguja','V','C','1','2021-05-24','03:38:21',1,'1',1,153531,'',0,'','Calle 12 B/ Vendeaguja','N','0',0,0,0,0,'2021-06-03','2021-06-10','2021-06-11','2021-06-18','0000-00-00',48,'N'),('R',82,95700,517,'2021-05-18','04:22:39','CC','78304994','ANDRES MENDOZA','3103808420','','C 9 12 44','V','C','3','2021-05-24','03:32:29',1,'1',1,154054,'',0,'','C 9 12 44','N','0',0,0,0,0,'2021-06-08','2021-06-15','2021-06-16','2021-06-22','0000-00-00',55,'N'),('P',38,194928,544,'2021-05-18','04:27:16','CC','78587089','GABRIEL LUNA','3104327082','','BARRIO EL PORVENIR','V','C','1','2021-05-24','03:28:30',1,'1',1,155307,'',0,'','','N','0',0,0,0,0,'2021-06-08','2021-06-15','2021-06-16','2021-06-22','0000-00-00',48,'N'),('P',39,196040,544,'2021-05-18','04:33:41','CC','26036917','IDALIDES OCHOA','3123243446','','BARRIO EL PORVENIR','V','C','1','2021-05-24','03:36:54',1,'1',1,155366,'',0,'','','N','0',0,0,0,0,'2021-06-08','2021-06-15','2021-06-16','2021-06-22','0000-00-00',48,'N'),('R',83,9200,517,'2021-06-02','03:54:07','CC','25999274','GABRIEL DE ORO','3156812684','','K 3 2 38','V','C','3','2021-06-29','10:06:23',1,'1',1,158219,'',0,'','K 3 2 38','N','0',0,0,0,0,'2021-06-24','2021-06-30','2021-07-01','2021-07-08','0000-00-00',55,'N'),('R',84,159400,517,'2021-06-02','04:05:25','CC','34883978','DUIVIS CASTRO','','','K 9b 16 25','V','C','3','2021-06-11','03:46:08',1,'1',1,159998,'',0,'','K 9b 16 25','N','0',0,0,0,0,'2021-06-24','2021-06-30','2021-07-01','2021-07-08','0000-00-00',55,'N'),('R',85,159900,517,'2021-06-02','04:26:05','CC','','OSCAR ZAPATA','3117597903','','','V','C','1','2021-06-11','03:48:26',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-06-24','2021-06-30','2021-07-01','2021-07-08','0000-00-00',14,'N'),('R',86,83200,517,'2021-06-02','04:29:52','CC','1010085923','MARIA BEDOYA','3126928791','','','V','C','3','2021-06-11','04:07:36',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-06-24','2021-06-30','2021-07-01','2021-07-08','0000-00-00',55,'N'),('R',87,165500,517,'2021-06-02','04:33:50','CC','','ALVARO YEPEZ','3117933717','','BARRIO PALMIRA','V','C','3','2021-06-11','03:53:15',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-06-24','2021-06-30','2021-07-01','2021-07-08','0000-00-00',55,'N'),('R',88,166800,517,'2021-06-02','04:36:17','CC','23242902','LEONOR HERNANDEZ','3137671191','','BARRIO PALMIRA','V','C','1','2021-06-11','03:55:45',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-06-24','2021-06-30','2021-07-01','2021-07-08','0000-00-00',53,'N'),('R',89,9200,517,'2021-06-02','04:54:06','CC','xxx','xxx','xxx','','','V','C','1','2021-06-11','04:00:14',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-06-24','2021-06-30','2021-07-01','2021-07-08','0000-00-00',14,'N'),('R',90,20237800,517,'2021-06-04','10:27:42','CC','','JORGE NARVAEZ','','','B. Ramon Rubio','V','C','3','2021-06-11','03:07:08',1,'1',1,163178,'',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2021-06-28','2021-07-02','2021-07-06','2021-07-12','0000-00-00',55,'N'),('R',91,92500,517,'2021-06-04','10:32:14','CC','50997738','NELCY  ARROYO','3117444577','','D 9a 13a 60','V','C','3','2021-06-11','03:10:12',1,'1',1,159168,'',0,'','D 9a 13a 60','N','0',0,0,0,0,'2021-06-28','2021-07-02','2021-07-06','2021-07-12','0000-00-00',55,'N'),('R',92,39300,517,'2021-06-04','10:35:18','CC','50999309','MARY LUZ GIL','3147510747','','C 2 11 58','V','C','1','2021-06-11','03:15:40',1,'1',1,158561,'',0,'','C 2 11 58','N','0',0,0,0,0,'2021-06-28','2021-07-02','2021-07-06','2021-07-12','0000-00-00',55,'N'),('R',93,195040,517,'2021-06-04','10:40:58','CC','50998491','YORLADIS PACHECO','3107390856','','BARRIO PORVENIR','V','C','1','2021-06-11','03:23:56',1,'1',1,160488,'',0,'','','N','0',0,0,0,0,'2021-06-28','2021-07-02','2021-07-06','2021-07-12','0000-00-00',14,'N'),('R',94,46750,517,'2021-06-04','03:42:36','CC','15045929','PEDRO SALGADO','3107262151','','C 4 11 23','V','C','3','2021-06-11','03:29:47',1,'1',1,158642,'',0,'','C 4 11 23','N','0',0,0,0,0,'2021-06-28','2021-07-02','2021-07-06','2021-07-12','0000-00-00',55,'N'),('R',95,2201000,511,'2021-06-04','03:49:42','CC','509962508','YOLEYDA  ALVAREZ','3148422729','','B. Ramon Rubio','V','C','3','2021-06-29','10:28:27',1,'1',1,160728,'',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2021-06-28','2021-07-02','2021-07-06','2021-07-12','0000-00-00',28,'N'),('P',40,153000,544,'2021-06-08','07:55:14','CC','25996471','ONEIDA SEGURA CARDOZO','3126530273','','','E','C','1','2021-06-21','09:30:21',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-06-29','2021-07-06','2021-07-07','2021-07-13','0000-00-00',48,'N'),('P',41,67100,535,'2021-06-08','03:56:51','CC','509950941','ROSIRIS TUIRAN (CASA)','3128650614','','C 8 9 28','V','C','1','2021-06-29','10:09:40',1,'1',1,158884,'',0,'','C 8 9 28','N','0',0,0,0,0,'2021-06-29','2021-07-06','2021-07-07','2021-07-13','0000-00-00',34,'N'),('R',96,179450,517,'2021-06-08','04:08:09','CC','106378795','DIANA  ARANGO','3216128889','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-06-11','03:33:13',1,'1',1,160245,'',0,'','','N','0',0,0,0,0,'2021-06-29','2021-07-06','2021-07-07','2021-07-13','0000-00-00',55,'N'),('R',97,137600,517,'2021-06-08','04:26:59','CC','25800995','JAEL SAENZ','3205887808','','K 8 12 100','V','C','3','2021-06-11','03:35:03',1,'1',1,159720,'',0,'','K 8 12 100','N','0',0,0,0,0,'2021-06-29','2021-07-06','2021-07-07','2021-07-13','0000-00-00',55,'N'),('P',42,163700,544,'2021-06-08','04:38:47','CC','50992761','LUISA LOBO','3145417390','','BARRIO PALMIRA','V','C','3','2021-06-21','09:57:36',1,'1',1,160053,'',0,'','','N','0',0,0,0,0,'2021-06-29','2021-07-06','2021-07-07','2021-07-13','0000-00-00',55,'N'),('R',98,65900,517,'2021-06-09','04:38:22','CC','98657445','ALISON BERNAL','','','K 9 8 96','V','C','3','2021-06-11','03:36:35',1,'1',1,158872,'',0,'','K 9 8 96','N','0',0,0,0,0,'2021-06-30','2021-07-07','2021-07-08','2021-07-14','0000-00-00',55,'N'),('P',43,111700,544,'2021-06-10','04:04:22','CC','50940401','ELENA VENTA','3135598035','','C 9 11 65','V','C','1','2021-06-21','09:40:33',1,'1',1,159414,'',0,'','C 9 11 65','N','0',0,0,0,0,'2021-07-01','2021-07-08','2021-07-09','2021-07-15','0000-00-00',53,'N'),('R',99,5600,517,'2021-06-10','04:11:02','CC','78585826','CESAR TULIO ALGARIN','3233732995','','BARRIO EL CENTRO','V','C','3','2021-06-11','03:43:56',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-01','2021-07-08','2021-07-09','2021-07-15','0000-00-00',55,'N'),('P',44,184930,544,'2021-06-10','04:21:05','CC','50998958','ELSA ZAPA','3114122752','','BARRIO PORVENIR','V','C','1','2021-06-21','09:38:08',1,'1',1,160313,'',0,'','','N','0',0,0,0,0,'2021-07-01','2021-07-08','2021-07-09','2021-07-15','0000-00-00',48,'N'),('R',100,20249400,517,'2021-06-15','04:52:00','CC','1007526667','SEBASTIAN ROJAS','3112046127','','B/ El Paraiso','V','C','1','2021-06-21','09:48:31',1,'1',1,163242,'',0,'','B/ El Paraiso','N','0',0,0,0,0,'2021-07-06','2021-07-12','2021-07-13','2021-07-19','0000-00-00',14,'N'),('R',101,163500,517,'2021-06-15','04:59:23','CC','6893989','PEDRO AVILEZ','3145061669','','C 18 9 32','V','C','1','2021-06-21','09:45:25',1,'1',1,160050,'',0,'','C 18 9 32','N','0',0,0,0,0,'2021-07-06','2021-07-12','2021-07-13','2021-07-19','0000-00-00',14,'N'),('R',102,125950,511,'2021-06-15','05:04:03','CC','XXX','JUAN ANDRES HERNANDEZ','XXX','','BARRIO SAN JOSE','V','C','1','2021-06-21','09:55:06',2,'1',1,159571,'',0,'','','N','0',0,0,0,0,'2021-07-06','2021-07-12','2021-07-13','2021-07-19','0000-00-00',34,'N'),('R',103,180416,517,'2021-06-22','10:16:15','CC','6666037','WENSESLAO HERNANDEZ','3145115026','','D 13b 13b 33','V','C','3','2021-07-06','09:00:23',1,'1',1,160269,'',0,'','D 13b 13b 33','N','0',0,0,0,0,'2021-07-13','2021-07-19','2021-07-21','2021-07-27','0000-00-00',55,'N'),('P',45,0,545,'2021-06-23','02:50:42','CC','78590253','RAFAEL EMIRO CALLA HOYOS','3126822577','','','E','C','1','2021-07-06','09:07:23',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-14','2021-07-21','2021-07-22','2021-07-28','0000-00-00',48,'N'),('P',46,8700,544,'2021-06-23','03:12:35','CC','','6675995','3118211723','','BARRIO LA CUMBIA','V','C','3','2021-06-29','10:11:13',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-14','2021-07-21','2021-07-22','2021-07-28','0000-00-00',55,'N'),('P',47,114600,544,'2021-06-23','03:49:43','CC','21981317','EDILMA GUZMAN','3145069571','','','V','C','3','2021-06-29','10:16:12',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-14','2021-07-21','2021-07-22','2021-07-28','0000-00-00',53,'N'),('P',48,20211600,544,'2021-07-06','09:09:43','CC','78589501','EVER HERNANDEZ','3126357872','','','V','C','1','2021-07-16','02:59:48',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-27','2021-08-02','2021-08-03','2021-08-09','0000-00-00',48,'N'),('R',104,129407,517,'2021-07-06','11:21:28','CC','1063082650','EDUAR MANCHEGO','3113461894','','BARRIO EL PARAISO','V','C','3','2021-07-16','03:04:48',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-27','2021-08-02','2021-08-03','2021-08-09','0000-00-00',55,'N'),('R',105,77700,517,'2021-07-06','11:38:39','CC','50997667','BERTA DE LA ROSA','3215103049','','BARRIO VENDE AGUJAS','V','C','3','2021-07-21','05:04:25',1,'1',1,0,'',0,'','BARRIO VENDE AGUJAS','N','0',0,0,0,0,'2021-07-27','2021-08-02','2021-08-03','2021-08-09','0000-00-00',53,'N'),('R',106,106100,517,'2021-07-06','03:23:21','CC','78589408','LUIS ALARCON','3145082915','','BARRIO SAN JOSE','V','C','3','2021-07-16','03:12:35',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-27','2021-08-02','2021-08-03','2021-08-09','0000-00-00',55,'N'),('R',107,17000,517,'2021-07-06','03:39:53','CC','34884876','RUBY NUÑEZ','3118888222','','BARRIO MIRAFLORES','V','C','3','2021-07-16','03:17:35',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-27','2021-08-02','2021-08-03','2021-08-09','0000-00-00',55,'N'),('P',49,171300,550,'2021-07-07','10:47:24','CC','2758480','GENARO ARCIA','3023643597','','BARRIO 7 DE SEPTIEMBRE','V','C','1','2021-07-16','03:25:35',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-28','2021-08-03','2021-08-04','2021-08-10','0000-00-00',48,'N'),('P',50,53900,544,'2021-07-07','10:54:26','CC','6876394','RAFAEL VITOLA','3172373521','','BARRIO VENDE AGUJAS','V','C','1','2021-07-16','03:27:41',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-28','2021-08-03','2021-08-04','2021-08-10','0000-00-00',53,'N'),('P',51,145300,544,'2021-07-07','02:21:00','CC','508729718','AURA DE LA ESPRIELLA','3217565603','','','V','C','1','2021-07-16','03:29:23',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-28','2021-08-03','2021-08-04','2021-08-10','0000-00-00',48,'N'),('R',108,90100,517,'2021-07-07','03:07:27','CC','785901871','FRANCISCO HERRERA','3132786543','','BARRIO  SANTIAGO SANCHEZ','V','C','3','2021-07-16','03:20:11',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-07-28','2021-08-03','2021-08-04','2021-08-10','0000-00-00',55,'N'),('R',109,9800,517,'2021-07-12','08:45:01','CC','','JUAN CARLOS MUNERA','3008773381','','BARRIO EL CENTRO','V','C','3','2021-07-22','03:13:28',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-02','2021-08-06','2021-08-09','2021-08-13','0000-00-00',55,'N'),('R',110,185000,517,'2021-07-12','09:00:58','CC','50998671','ASTELIS PERTUZ','3135925795','','BARRIO EL PORVENIR','V','C','3','2021-07-22','03:15:25',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-02','2021-08-06','2021-08-09','2021-08-13','0000-00-00',55,'N'),('R',111,180416,515,'2021-07-12','09:04:26','CC','6660037','WENSESLAO','3145115026','','BARRIO 7 DE SEPTIEMBRE','V','C','1','2021-07-22','03:26:12',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-02','2021-08-06','2021-08-09','2021-08-13','0000-00-00',17,'N'),('R',112,129420,517,'2021-07-12','11:12:49','CC','509945506','MARIA  ARRIETA','3015612870','','BARRIO CAMILO JIMENEZ','V','C','3','2021-07-22','03:17:51',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-02','2021-08-06','2021-08-09','2021-08-13','0000-00-00',55,'N'),('R',113,142300,517,'2021-07-14','10:22:22','CC','15048782','LUIS MARIMON','3117146061','','BARRIO EL PROGRESO','V','C','3','2021-07-22','03:18:57',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-04','2021-08-10','2021-08-11','2021-08-18','0000-00-00',55,'N'),('R',114,73400,517,'2021-07-19','08:41:26','CC','78590004','NELSON APARICIO','3233009533','','K 11 8 83','V','C','3','2021-07-22','03:23:32',1,'1',1,164107,'',0,'','K 11 8 83','N','0',0,0,0,0,'2021-08-09','2021-08-13','2021-08-17','2021-08-23','0000-00-00',53,'N'),('P',52,153400,544,'2021-07-19','09:03:00','CC','6895699','MANUEL GUARIN','3218950072','','K 11a 13 65','V','C','3','2021-07-30','09:11:41',1,'1',1,165079,'',0,'','K 11a 13 65','N','0',0,0,0,0,'2021-08-09','2021-08-13','2021-08-17','2021-08-23','0000-00-00',55,'N'),('P',53,2100,544,'2021-07-22','03:48:22','CC','1063354212','SANDRA  AGUDELO','3135216698','','BARRIO 20 DE JULIO','V','C','4','2021-07-30','09:07:57',1,'1',1,0,'',0,'','BARRIO 20 DE JULIO ','N','0',0,0,0,0,'2021-08-11','2021-08-18','2021-08-19','2021-08-25','0000-00-00',53,'N'),('R',115,165500,517,'2021-08-04','03:18:32','CC','34884671','SOFIA OSORIO','3146493605','','barrio palmira','V','C','3','2021-08-20','08:18:12',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-25','2021-08-31','2021-09-01','2021-09-07','0000-00-00',55,'N'),('R',116,143900,517,'2021-08-04','03:33:33','CC','1068587752','LUZ ESTELA BUENDIA','3113436133','','BARRIO CAMILO JIMENEZ','V','C','3','2021-08-23','05:33:41',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-25','2021-08-31','2021-09-01','2021-09-07','0000-00-00',53,'N'),('R',117,21900,517,'2021-08-04','03:39:51','CC','1128402343','LILIBETH ALVAREZ','3207723357','','BARRIO EL CENTRO','V','C','3','2021-08-20','08:30:17',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-25','2021-08-31','2021-09-01','2021-09-07','0000-00-00',53,'N'),('R',118,91300,517,'2021-08-04','03:57:09','CC','1063361022','JUAN FELIPE MARTINEZ','3226518887','','BARRIO EL EDEN','V','C','3','2021-08-20','08:20:37',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-25','2021-08-31','2021-09-01','2021-09-07','0000-00-00',55,'N'),('R',119,94300,517,'2021-08-04','04:00:29','CC','43907852','GLORIA HURTADO','3205351881','','BARRIO EL EDEN','V','C','3','2021-08-20','08:21:56',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-25','2021-08-31','2021-09-01','2021-09-07','0000-00-00',55,'N'),('R',120,44200,517,'2021-08-04','04:06:47','CC','1019013099','LORENA VILLALBA','3155298041','','BARRIO VENDIAGUJAS','V','C','3','2021-08-20','08:24:24',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-08-25','2021-08-31','2021-09-01','2021-09-07','0000-00-00',55,'N'),('R',121,20216000,517,'2021-09-06','10:09:25','CC','78589575','JAIDER MONTES','3234884438','','BARRIO EL PARAISO','V','C','1','2021-09-15','10:49:27',1,'1',1,0,'',0,'','BARRIO EL PARAISO ','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',14,'N'),('R',122,152590,517,'2021-09-06','10:30:52','CC','1063360706','YERLIS ROMERO','3216262692','','BARRIO GUADALUPE','V','C','3','2021-09-15','03:15:35',1,'xx',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',123,137600,517,'2021-09-06','10:35:07','CC','10890052','TAMAS SAENZ','3104075573','','BARRIO EL PROGRESO','V','C','3','2021-09-25','09:31:19',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',124,21900,517,'2021-09-06','10:40:04','CC','78585032','DANIEL GIL','3126847701','','BARRIO EL CENTRO','V','C','3','2021-09-15','03:17:57',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',125,72200,517,'2021-09-06','10:45:12','CC','1020455650','MERIS ESPITIA','3014887007','','BARRIO LAS CRUCES','V','C','3','2021-09-15','03:19:03',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',126,32100,517,'2021-09-06','10:54:56','CC','1003078965','YERLIS MARTINEZ','3107401454','','BARRIO VIENTE DE JULIO','V','C','3','2021-09-15','03:20:15',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',127,10200,517,'2021-09-06','11:01:23','CC','25996670','BEATRIZ MENESES','3107840519','','BARRIO EL CENTRO','V','C','3','2021-09-20','10:22:34',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',128,101200,517,'2021-09-06','11:08:21','CC','50998009','ERLINDA','3205037215','','BARRIO LA UNION','V','C','1','2021-09-15','03:12:36',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',32,'N'),('R',129,132500,517,'2021-09-06','03:17:19','CC','25991562','RAFAEL DIAZ','3135085874','','BARRIO EL PROGRESO','V','C','3','2021-09-15','03:08:37',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',130,171200,517,'2021-09-06','03:20:36','CC','2758480','GENARO ARIAS','3023643597','','BARRIO SIETE DE SEPTIEMBRE','V','C','3','2021-09-15','03:06:33',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',131,172728,517,'2021-09-06','03:44:34','CC','50998715','BERENICE DE ARCO','3145656067','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-09-15','03:03:42',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',132,7900,517,'2021-09-06','03:53:58','CC','2804708','JORGE IVAN CALLE','3135362973','','BARRIO AGUAS VIVAS','V','C','3','2021-09-15','02:55:57',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',133,173200,516,'2021-09-06','03:57:33','CC','348836116','LUZ MARIINA MARTINEZ','3215742511','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-09-15','02:41:01',1,'1',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',134,20233600,517,'2021-09-06','04:09:11','CC','30060403','INES FARIDES MONTES','3107194488','','BARRIO EL PARAISO','V','C','3','2021-09-15','11:24:13',1,'1',1,0,'',0,'','BARRIO EL PARAISO ','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',135,134600,517,'2021-09-06','04:13:13','CC','50997855','MERIS ORTEGA','3107088132','','BARRIO EL PROGRESO','V','C','3','2021-09-15','11:01:11',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-24','2021-09-30','2021-10-01','2021-10-07','0000-00-00',55,'N'),('R',136,142400,598,'2021-09-09','11:26:09','CC','19468001','ADALBERTO GORDON','3217740216','','BARRIO CAMILO JIMENEZ','V','C','1','2021-09-20','10:26:06',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-29','2021-10-05','2021-10-06','2021-10-12','0000-00-00',55,'N'),('P',54,109500,544,'2021-09-09','03:08:42','CC','6675213','MAGIN PEREZ ZAPATA','3135362973','','BARRIO CAMILO JIMENEZ','V','C','1','2021-09-20','11:26:23',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-29','2021-10-05','2021-10-06','2021-10-12','0000-00-00',53,'N'),('P',55,169300,544,'2021-09-09','03:35:25','CC','30059717','ELIDA ROSA ROJAS','3218708628','','BARRIO PALMIRA','V','C','3','2021-09-20','11:32:56',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-29','2021-10-05','2021-10-06','2021-10-12','0000-00-00',55,'N'),('R',137,191850,517,'2021-09-09','03:44:58','CC','43694316','ELDA CATAÑO','3126333493','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2021-09-20','11:20:38',1,'1',1,175881,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2021-09-29','2021-10-05','2021-10-06','2021-10-12','0000-00-00',55,'N'),('R',138,80700,517,'2021-09-09','03:47:59','CC','78585838','DANIEL CANSINO','3147827602','','BARRIO EL EDEN','V','C','3','2021-09-20','11:23:06',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-09-29','2021-10-05','2021-10-06','2021-10-12','0000-00-00',55,'N'),('R',139,93600,517,'2021-10-19','10:04:28','CC','6675791','UBALDO VILLADIEGO','3107209979','','C 10 12 05','V','C','3','2021-11-08','03:01:30',1,'1',1,179883,'',0,'','C 10 12 05','N','0',0,0,0,0,'2021-11-09','2021-11-16','2021-11-17','2021-11-23','0000-00-00',55,'N'),('R',140,32970,517,'2021-10-19','10:13:03','CC','92511945','AISAR MONTES','3137559929','','C 7 10 50','V','C','3','2021-11-08','03:07:26',1,'1',1,179206,'',0,'','C 7 10 50','N','0',0,0,0,0,'2021-11-09','2021-11-16','2021-11-17','2021-11-23','0000-00-00',12,'N'),('R',141,194970,517,'2021-10-19','10:25:07','CC','34884219','ORFA HERNANDEZ','3127095471','','BARRIO EL PORVENIR','V','C','3','2021-11-08','03:08:47',1,'1',1,181184,'',0,'','','N','0',0,0,0,0,'2021-11-09','2021-11-16','2021-11-17','2021-11-23','0000-00-00',55,'N'),('P',56,32500,544,'2021-10-19','10:49:42','CC','1063363832','JOAQUIN SUAREZ','3045606499','','C 6 10 25','V','C','1','2021-11-08','03:15:49',1,'1',1,179186,'',0,'','C 6 10 25','N','0',0,0,0,0,'2021-11-09','2021-11-16','2021-11-17','2021-11-23','0000-00-00',53,'N'),('R',142,113700,517,'2021-10-19','10:54:29','CC','1063356765','YENY RENTERIA','3135106115','','BARRIO VENDE AGUJAS','V','C','1','2021-11-08','03:14:20',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-11-09','2021-11-16','2021-11-17','2021-11-23','0000-00-00',48,'N'),('R',143,2864500,517,'2021-10-21','09:48:07','CC','306617814','ENELDA  ARRIETA','','','B/ El Progreso 2','V','C','3','2021-11-08','03:10:24',1,'1',1,183568,'',0,'','B/ El Progreso 2','N','0',0,0,0,0,'2021-11-11','2021-11-18','2021-11-19','2021-11-25','0000-00-00',55,'N'),('R',144,163400,517,'2021-10-21','10:04:33','CC','78586037','SILVIO SIMANCA','3145534969','','C 18 9 40','V','C','3','2021-11-08','03:11:23',1,'1',1,180750,'',0,'','C 18 9 40','N','0',0,0,0,0,'2021-11-11','2021-11-18','2021-11-19','2021-11-25','0000-00-00',55,'N'),('R',145,167750,517,'2021-10-21','10:22:35','CC','71376749','ALEXANDER GALEANO','3137983583','','BARRIO PALMIRA','V','C','3','2021-11-08','03:12:41',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-11-11','2021-11-18','2021-11-19','2021-11-25','0000-00-00',55,'N'),('R',146,20500,517,'2021-11-08','03:19:06','CC','30060113','OBERCIA  BARON','3105353278','','K 7 3 20','V','C','3','2021-11-30','02:47:07',1,'1',1,179054,'',0,'','K 7 3 20','N','0',0,0,0,0,'2021-11-29','2021-12-03','2021-12-06','2021-12-13','0000-00-00',55,'N'),('R',147,170530,517,'2021-11-08','03:40:39','CC','5633723','HUMBERTO RINCON','3114189261','','BARRIO GUADALUPE','V','C','3','2021-11-30','02:49:19',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-11-29','2021-12-03','2021-12-06','2021-12-13','0000-00-00',55,'N'),('P',57,2570000,544,'2021-11-12','09:55:17','CC','50992761','ANADELFA CORONADO','3122450876','','Calle 17 B/ Ramon Rubio','V','C','1','2021-11-30','02:53:03',1,'1',1,187085,'',0,'','Calle 17 B/ Ramon Rubio','N','0',0,0,0,0,'2021-12-03','2021-12-10','2021-12-13','2021-12-17','0000-00-00',53,'N'),('P',58,125800,544,'2021-11-16','10:59:28','CC','10805820','CANDELARIO SANCHEZ','3147267398','','C 9 8 39','V','C','1','2021-11-30','02:54:59',1,'1',1,185493,'',0,'','C 9 8 39','N','0',0,0,0,0,'2021-12-06','2021-12-13','2021-12-14','2021-12-20','0000-00-00',53,'N'),('P',59,189400,544,'2021-11-16','11:05:47','CC','1003289269','LUIS FERNANDO PEREZ','3005690141','','K 11a 13b 44','V','C','1','2021-11-30','02:56:37',1,'1',1,186298,'',0,'','K 11a 13b 44','N','0',0,0,0,0,'2021-12-06','2021-12-13','2021-12-14','2021-12-20','0000-00-00',48,'N'),('R',148,106700,517,'2021-12-06','09:26:09','CC','50998599','CLAUDIA  MARTINEZ','3223049579','','BARRIO SAN JOSE','V','C','1','2021-12-16','09:13:25',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2021-12-27','2021-12-31','2022-01-03','2022-01-07','0000-00-00',14,'N'),('R',149,7900,517,'2021-12-06','09:34:21','CC','2804708','JORGE IVAN CALLE','3135362973','','C 1a 7 01','V','A','','0000-00-00','00:00:00',1,'1',1,189353,'',0,'','C 1a 7 01','N','0',0,0,0,0,'2021-12-27','2021-12-31','2022-01-03','2022-01-07','0000-00-00',0,''),('R',150,21800,517,'2021-12-06','10:14:31','CC','1017154928','MELISA RODRIGUEZ','3206166688','','C 2 3 179','V','C','1','2021-12-16','09:41:00',1,'xx',1,189512,'',0,'','C 2 3 179','N','0',0,0,0,0,'2021-12-27','2021-12-31','2022-01-03','2022-01-07','0000-00-00',53,'N'),('R',151,123700,517,'2021-12-06','10:22:53','CC','1063359668','WILSON RICARDO','3212480809','','C 9 7a 12','V','C','3','2021-12-16','09:43:33',1,'1',1,190691,'',0,'','C 9 7a 12','N','0',0,0,0,0,'2021-12-27','2021-12-31','2022-01-03','2022-01-07','0000-00-00',55,'N'),('R',152,172706,517,'2021-12-06','10:32:30','CC','','DIANIS ORTEGA','3106030016','','K 13 13a 36','V','C','3','2021-12-16','09:44:34',1,'1',1,191310,'',0,'','K 13 13a 36','N','0',0,0,0,0,'2021-12-27','2021-12-31','2022-01-03','2022-01-07','0000-00-00',55,'N'),('R',153,168400,517,'2021-12-06','10:36:53','CC','30060878','ARELIS MONTIEL','3126407330','','K 9b 16 29','V','C','3','2021-12-16','09:31:55',1,'1',1,191252,'',0,'','K 9b 16 29','N','0',0,0,0,0,'2021-12-27','2021-12-31','2022-01-03','2022-01-07','0000-00-00',55,'N'),('R',154,57700,517,'2021-12-06','10:39:29','CC','10994035','MIGUEL PEREZ','3148358115','','K 13a 4 30','V','C','1','2021-12-16','09:29:23',1,'1',1,189920,'',0,'','K 13a 4 30','N','0',0,0,0,0,'2021-12-27','2021-12-31','2022-01-03','2022-01-07','0000-00-00',14,'N'),('P',60,153400,544,'2021-12-07','03:55:13','CC','25998452','GEORGINA ORTEGA','3142567893','','K 11a 13 65','V','C','1','2021-12-20','10:29:08',1,'1',1,191069,'',0,'','K 11a 13 65','N','0',0,0,0,0,'2021-12-28','2022-01-03','2022-01-04','2022-01-11','0000-00-00',48,'N'),('R',155,80200,517,'2021-12-07','04:06:52','CC','6458231','ERASMO CAUSIL','321568941','','C 8 13 37','V','C','3','2021-12-16','09:36:05',1,'1',1,190174,'',0,'','C 8 13 37','N','0',0,0,0,0,'2021-12-28','2022-01-03','2022-01-04','2022-01-11','0000-00-00',53,'N'),('R',156,68800,517,'2021-12-09','04:09:16','CC','78290965','GUILLERMO NEGRETE','3126110218','','Kra.10 #8-34','V','C','3','2021-12-20','10:33:44',1,'1',1,190050,'',0,'','Kra.10 #8-34','N','0',0,0,0,0,'2021-12-29','2022-01-04','2022-01-05','2022-01-12','0000-00-00',55,'N'),('R',157,2863700,517,'2021-12-09','04:15:04','CC','50999340','ONEIDA SUAREZ','3108646184','','B/ El Progreso 2','V','A','','0000-00-00','00:00:00',1,'1',1,194001,'',0,'R','B/ El Progreso 2','N','0',0,0,0,0,'2021-12-29','2022-01-04','2022-01-05','2022-01-12','0000-00-00',0,''),('R',158,2558700,517,'2021-12-16','10:04:44','CC','1063367526','CESAR MARTINEZ','3136928797','','BARRIO PALMIRA','V','C','3','2021-12-20','10:30:46',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2022-01-05','2022-01-12','2022-01-13','2022-01-19','0000-00-00',53,'N'),('R',159,76600,517,'2022-01-12','03:26:13','CC','1063363230','KAREN VIVIANA SUAREZ','3008399207','','BARRIO VENDE AGUJAS','V','C','3','2022-01-31','10:01:20',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2022-02-01','2022-02-07','2022-02-08','2022-02-14','0000-00-00',55,'N'),('R',160,178300,517,'2022-01-12','03:59:20','CC','1063355387','MARCELA MARTINEZ','3106113078','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2022-01-31','10:02:43',1,'1',1,0,'',0,'','BARRIO 7 DE SEPTIEMBRE','N','0',0,0,0,0,'2022-02-01','2022-02-07','2022-02-08','2022-02-14','0000-00-00',55,'N'),('R',161,192300,517,'2022-01-12','04:54:28','CC','78590253','ORLANDO OSUNA','3235253423','','BARRIO 7 DE SEPTIEMBRE','V','C','3','2022-01-31','10:03:43',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2022-02-01','2022-02-07','2022-02-08','2022-02-14','0000-00-00',55,'N'),('P',61,46400,544,'2022-01-13','02:51:43','CC','1063364501','DEIVIS DIAZ','3153524823','','K 12 6 14','V','C','1','2022-01-31','10:05:10',1,'1',1,195000,'',0,'','K 12 6 14','N','0',0,0,0,0,'2022-02-02','2022-02-08','2022-02-09','2022-02-15','0000-00-00',48,'N'),('R',162,117300,517,'2022-02-03','03:13:46','CC','50992772','LISENIA PACHECO','3136481303','','BARRIO CAMILO JIMENEZ','V','C','1','2022-02-07','10:35:32',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2022-02-23','2022-03-01','2022-03-02','2022-03-08','0000-00-00',14,'N'),('R',163,166700,517,'2022-02-03','03:38:23','CC','30060537','GLADIS LOBO','3205081282','','C 17 9 - 45','V','C','3','2022-02-16','10:26:00',1,'1',1,201661,'',0,'','C 17 9 - 45','N','0',0,0,0,0,'2022-02-23','2022-03-01','2022-03-02','2022-03-08','0000-00-00',55,'N'),('R',164,123000,517,'2022-02-04','10:53:11','CC','50997629','ADELA REYES','3002429891','','K 7a 9 21','V','C','3','2022-02-14','04:55:36',1,'1',1,201112,'',0,'','K 7a 9 21','N','0',0,0,0,0,'2022-02-24','2022-03-02','2022-03-03','2022-03-09','0000-00-00',55,'N'),('R',165,94800,511,'2022-02-04','10:58:41','CC','50997600','EDITH CANCHILA','3146460613','','C 9 12 60','V','C','1','2022-02-14','04:58:45',2,'1',1,200770,'',0,'','C 9 12 60','N','0',0,0,0,0,'2022-02-24','2022-03-02','2022-03-03','2022-03-09','0000-00-00',34,'N'),('R',166,152800,517,'2022-02-04','11:11:24','CC','78585842','EUSTORGIO ARRIETA','3106546998','','K 11a 11 50','V','C','3','2022-02-14','05:00:02',1,'1',1,201491,'',0,'','K 11a 11 50','N','0',0,0,0,0,'2022-02-24','2022-03-02','2022-03-03','2022-03-09','0000-00-00',55,'N'),('R',167,196300,517,'2022-02-07','10:09:55','CC','15705340','RODRIGO CAVADIA','3102234903','','K 12d 15 20','V','C','3','2022-02-16','10:16:26',1,'1',1,202099,'',0,'','K 12d 15 20','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',55,'N'),('R',168,44100,517,'2022-02-07','10:16:54','CC','30652337','YANETH CARDENAS','3205426221','','C 6 11 82','V','C','3','2022-02-15','02:50:15',1,'1',1,200190,'',0,'','C 6 11 82','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',55,'N'),('R',169,168200,517,'2022-02-07','10:20:06','CC','80251360','JOAQUIN CAMACHO','3213435458','','BARRIO PALMIRA','V','C','3','2024-03-21','02:41:39',1,'1',1,201678,'',0,'','K 9 16 22','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',55,'N'),('P',62,184930,544,'2022-02-07','10:23:59','CC','50998958','ELSA ZAPA','3114122752','','BARRIO EL PORVENIR','V','C','1','2022-02-15','03:01:48',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',48,'N'),('R',170,124500,517,'2022-02-07','03:37:40','CC','43668423','GUMERCINDA LOPEZ','3114331939','','BARRIO SAN JOSE','V','C','3','2022-02-15','02:52:06',1,'1',1,201129,'',0,'','K 7 4 02','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',55,'N'),('R',171,126400,517,'2022-02-07','03:40:50','CC','25775908','MINERVA CAMARGO LOPEZ','3014451532','','BARRIO SAN JOSE','V','C','3','2022-02-15','02:53:28',1,'1',1,201148,'',0,'','C 9 7 59','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',55,'N'),('R',172,2865300,517,'2022-02-07','03:46:40','CC','78588526','IVAN SANCHEZ','3145718563','','BARRIO EL PROGRESO2','V','A','','0000-00-00','00:00:00',1,'1',1,0,'',0,'','','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',0,''),('R',173,115700,517,'2022-02-07','03:49:33','CC','6639510','MIGUEL SEQUEDA','3135362973','','K 11 9 62','V','C','3','2022-02-15','02:55:14',1,'1',1,201035,'',0,'','K 11 9 62','N','0',0,0,0,0,'2022-02-25','2022-03-03','2022-03-04','2022-03-10','0000-00-00',55,'N'),('R',174,134000,517,'2022-02-08','03:16:37','CC','34883997','ABERIS MUÑOZ','3114368682','','K 8 11 02','V','C','3','2022-02-15','02:58:15',1,'1',1,201251,'',0,'','K 8 11 02','N','0',0,0,0,0,'2022-02-28','2022-03-04','2022-03-07','2022-03-11','0000-00-00',55,'N'),('P',63,52800,544,'2022-02-08','03:20:09','CC','73543393','ARGEMIRO ACOSTA','3126488396','','K 13 4 30','V','A','','0000-00-00','00:00:00',1,'1',1,200288,'',0,'','K 13 4 30','N','0',0,0,0,0,'2022-02-28','2022-03-04','2022-03-07','2022-03-11','0000-00-00',0,''),('P',64,76700,544,'2022-02-08','03:26:17','CC','34883603','ROSIRIS LOPEZ','3136010218','','K 12 8 11','V','A','','0000-00-00','00:00:00',1,'1',1,200566,'',0,'','K 12 8 11','N','0',0,0,0,0,'2022-02-28','2022-03-04','2022-03-07','2022-03-11','0000-00-00',0,''),('R',175,7600,517,'2022-02-09','10:14:50','CC','25990251','NERIS ALARCON','3218249212','','K 8 1a 28','V','A','','0000-00-00','00:00:00',1,'1',1,199781,'',0,'','K 8 1a 28','N','0',0,0,0,0,'2022-03-01','2022-03-07','2022-03-08','2022-03-14','0000-00-00',0,''),('R',176,27300,517,'2022-02-10','05:04:06','CC','50997627','LINA CHOPERENA','3103573492','','C 2 9 03','V','A','','0000-00-00','00:00:00',1,'1',1,200006,'',0,'','C 2 9 03','N','0',0,0,0,0,'2022-03-02','2022-03-08','2022-03-09','2022-03-15','0000-00-00',0,''),('R',177,171200,517,'2022-02-10','05:09:39','CC','78590253','ISABEL PEÑATE','3135447172','','D 13a 12c 19','V','A','','0000-00-00','00:00:00',1,'1',1,201714,'',0,'','D 13a 12c 19','N','0',0,0,0,0,'2022-03-02','2022-03-08','2022-03-09','2022-03-15','0000-00-00',0,''),('R',178,145900,517,'2022-02-10','05:13:27','CC','98615914','EDILBERTO DE LA OSSA','3126830845','','C 12 9 24','V','A','','0000-00-00','00:00:00',1,'1',1,201387,'',0,'','C 12 9 24','N','0',0,0,0,0,'2022-03-02','2022-03-08','2022-03-09','2022-03-15','0000-00-00',0,''),('R',179,130750,517,'2022-03-23','06:01:37','CC','50998907','NAYIBIS  MUÑOZ','3108495171','','KR8','V','A','','0000-00-00','00:00:00',1,'1',1,0,'',0,'A','','N','0',0,0,0,0,'2022-04-12','2022-04-19','2022-04-20','2022-04-26','0000-00-00',0,''),('R',180,84200,517,'2022-03-24','08:28:06','CC','','MIRLEYDIS NEGRETE','3113765970','','','V','A','','0000-00-00','00:00:00',1,'1',1,84200,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('Q',2,69950,546,'2022-03-24','08:35:33','CC','50997563','DIANA LUZ OYOLA','3133162737','','','V','A','','0000-00-00','00:00:00',1,'1',1,69950,'',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',181,118100,517,'2022-03-24','08:57:11','CC','1036615045','JORGE HUGO ALZATE','3023391173','','','V','A','','0000-00-00','00:00:00',1,'1',1,118100,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',182,41100,517,'2022-03-24','09:12:14','CC','1063358283','ANTONIO HENAO','3164066879','','','V','A','','0000-00-00','00:00:00',1,'1',1,41100,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('Q',3,185600,551,'2022-03-24','09:35:28','CC','','SANDY ALDANA','3205522921','','','V','A','','0000-00-00','00:00:00',1,'1',1,185600,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',183,50000,517,'2022-03-24','09:43:05','CC','1063275868','YOLEYDA  BERRIOS','3137646939','','','V','A','','0000-00-00','00:00:00',1,'1',1,50000,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',184,92800,517,'2022-03-24','09:49:41','CC','','ENERIS MEJIA','3106542660','','','V','A','','0000-00-00','00:00:00',1,'1',1,92800,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',185,2864500,517,'2022-03-24','10:20:33','CC','','ENELDA  ARRIETA','3106617814','','','V','A','','0000-00-00','00:00:00',1,'1',1,2864500,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',186,185650,517,'2022-03-24','10:23:58','CC','','VIICTOR MANUEL ESTRADA','3205907533','','','V','A','','0000-00-00','00:00:00',1,'1',1,185650,'',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',187,132500,517,'2022-03-24','10:31:25','CC','','LUZ MARINA MELENDRE','3135085874','','K 8 11 88','V','A','','0000-00-00','00:00:00',1,'1',1,132500,'R',0,'A','K 8 11 88','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',188,197100,517,'2022-03-24','10:35:54','CC','','ONAIDIS SIERRA','3235286673','','','V','A','','0000-00-00','00:00:00',1,'1',1,197100,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('R',189,58400,517,'2022-03-24','10:41:35','CC','','LEVIS JARAMILLO','3142086740','','','V','A','','0000-00-00','00:00:00',1,'1',1,0,'R',0,'A','','N','0',0,0,0,0,'2022-04-13','2022-04-20','2022-04-21','2022-04-27','0000-00-00',0,''),('Q',4,163650,546,'2022-04-04','07:43:58','CC','','LEDYS MONTIEL','3215133638','','','V','C','','0000-00-00','00:00:00',1,'1',1,163650,'P',0,'A','','N','0',0,0,0,0,'2022-04-25','2022-04-29','2022-05-02','2022-05-06','0000-00-00',0,''),('P',65,2206000,525,'2022-04-04','07:50:32','CC','1148435031','MARICELA LOPEZ CANTERO','3126003889','','','V','A','','0000-00-00','00:00:00',1,'1',1,2206000,'P',0,'A','','N','0',0,0,0,0,'2022-04-25','2022-04-29','2022-05-02','2022-05-06','0000-00-00',0,''),('R',190,41700,517,'2022-04-06','08:05:35','CC','1063356714','LUIS FERNANDO OYOLA','3215456117','','','V','A','','0000-00-00','00:00:00',1,'1',1,41700,'R',0,'A','','N','0',0,0,0,0,'2022-04-27','2022-05-03','2022-05-04','2022-05-10','0000-00-00',0,''),('R',191,133800,517,'2022-04-06','08:14:27','CC','26366360','TERESA CORTEZ','3205174293','','','V','A','','0000-00-00','00:00:00',1,'1',1,133800,'R',0,'A','','N','0',0,0,0,0,'2022-04-27','2022-05-03','2022-05-04','2022-05-10','0000-00-00',0,''),('R',192,41700,517,'2022-04-11','08:08:07','CC','1063356714','LUIS FERNANDO OYOLA','3215456117','','','V','A','','0000-00-00','00:00:00',1,'1',1,41700,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',193,169,517,'2022-04-11','08:12:33','CC','98652140','WILSON MONTES','3146305318','','','V','A','','0000-00-00','00:00:00',1,'1',1,169,'',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',194,30200,517,'2022-04-11','08:21:28','CC','25987038','ELDA URZOLA','31256853806','','','V','A','','0000-00-00','00:00:00',1,'1',1,30200,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',195,32915,517,'2022-04-11','08:24:30','CC','30060123','GLADYS APARICIO','3202017825','','','V','A','','0000-00-00','00:00:00',1,'1',1,32915,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',196,42100,517,'2022-04-11','08:27:17','CC','50997627','NOELIA SAEZ AVILA','3218290163','','','V','A','','0000-00-00','00:00:00',1,'1',1,42100,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',197,112050,517,'2022-04-11','08:31:24','CC','1063356628','YERSID DE ORO','3185418512','','','V','C','','0000-00-00','00:00:00',1,'1',1,112050,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',198,107000,517,'2022-04-11','10:03:36','CC','71710637','ENOR ORTEGA','3116238681','','','V','C','','0000-00-00','00:00:00',1,'1',1,107000,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',199,195300,517,'2022-04-11','10:08:24','CC','78589450','DARIO SIERRA','3205545865','','','V','C','','0000-00-00','00:00:00',1,'1',1,195300,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',200,148700,517,'2022-04-11','10:12:35','CC','30553420','DIOSELINA BEDOYA','315497911','','','V','A','','0000-00-00','00:00:00',1,'1',1,148700,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',201,124500,517,'2022-04-11','10:47:30','CC','43668423','GUMERCINDA LOPEZ','3114331939','','K 7 4 02','V','C','','0000-00-00','00:00:00',1,'1',1,211564,'R',0,'A','K 7 4 02','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',202,46100,517,'2022-04-11','10:49:43','CC','1063279828','GABRIEL CALDERON','3108938436','','','V','C','','0000-00-00','00:00:00',1,'1',1,46100,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',203,42400,517,'2022-04-11','10:54:19','CC','78590862','JHON MERCADO','3126160885','','','V','C','','0000-00-00','00:00:00',1,'1',1,42400,'R',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',204,62700,517,'2022-04-11','10:59:50','CC','948467','JOSE PARRA','','','','V','C','','0000-00-00','00:00:00',1,'1',1,0,'P',0,'A','','N','0',0,0,0,0,'2022-05-02','2022-05-06','2022-05-09','2022-05-13','0000-00-00',0,''),('R',205,53700,517,'2022-05-31','08:04:25','CC','1103112950','cesar rodriguez','3145502332','','','V','C','','0000-00-00','00:00:00',1,'1',1,53700,'R',0,'A','','N','0',0,0,0,0,'2022-06-21','2022-06-28','2022-06-29','2022-07-06','0000-00-00',0,''),('R',206,7400,517,'2022-05-31','08:08:54','CC','','daniel acosta','3145425166','','','V','C','','0000-00-00','00:00:00',1,'1',1,7400,'R',0,'A','','N','0',0,0,0,0,'2022-06-21','2022-06-28','2022-06-29','2022-07-06','0000-00-00',0,''),('R',207,163650,517,'2022-05-31','08:12:55','CC','','leydis montiel','3215133638','','','V','C','','0000-00-00','00:00:00',1,'1',1,163650,'P',0,'A','','N','0',0,0,0,0,'2022-06-21','2022-06-28','2022-06-29','2022-07-06','0000-00-00',0,''),('R',208,198400,517,'2022-05-31','08:16:52','CC','1066747673','','','','','V','A','','0000-00-00','00:00:00',1,'1',1,198400,'R',0,'A','','N','0',0,0,0,0,'2022-06-21','2022-06-28','2022-06-29','2022-07-06','0000-00-00',0,''),('R',209,133300,517,'2022-05-31','08:24:51','CC','1003080737','patricia mestra','3235260605','','','V','A','','0000-00-00','00:00:00',1,'1',1,133300,'R',0,'A','','N','0',0,0,0,0,'2022-06-21','2022-06-28','2022-06-29','2022-07-06','0000-00-00',0,''),('R',210,133300,517,'2022-05-31','08:26:31','CC','1003080737','patricia mestra','3235260605','','','V','A','','0000-00-00','00:00:00',1,'1',1,133300,'R',0,'A','','N','0',0,0,0,0,'2022-06-21','2022-06-28','2022-06-29','2022-07-06','0000-00-00',0,''),('R',211,176300,517,'2022-05-31','08:28:15','CC','3856196','RAMON BELTRAN','3205718959','','','V','A','','0000-00-00','00:00:00',1,'1',1,176300,'R',0,'A','','N','0',0,0,0,0,'2022-06-21','2022-06-28','2022-06-29','2022-07-06','0000-00-00',0,''),('R',212,132500,517,'2022-06-01','02:48:47','CC','78590891','RAFAEL DIAZ','3135085874','','','V','A','','0000-00-00','00:00:00',1,'1',1,132500,'R',0,'A','','N','0',0,0,0,0,'2022-06-22','2022-06-29','2022-06-30','2022-07-07','0000-00-00',0,''),('R',213,132500,517,'2022-06-01','02:51:30','CC','78590891','RAFAEL DIAZ','3135085874','','','V','A','','0000-00-00','00:00:00',1,'1',1,132500,'R',132500,'A','','N','0',0,0,0,0,'2022-06-22','2022-06-29','2022-06-30','2022-07-07','0000-00-00',0,''),('R',214,106710,517,'2022-06-01','04:15:43','CC','','DARIS ORTEGA','3233866101','','','V','A','','0000-00-00','00:00:00',1,'1',1,106710,'R',0,'A','','N','0',0,0,0,0,'2022-06-22','2022-06-29','2022-06-30','2022-07-07','0000-00-00',0,''),('R',215,179260,517,'2022-06-01','04:17:46','CC','','LIDIS SALDUA GUERRA','3205154232','','','V','A','','0000-00-00','00:00:00',1,'1',1,179260,'R',0,'A','','N','0',0,0,0,0,'2022-06-22','2022-06-29','2022-06-30','2022-07-07','0000-00-00',0,''),('R',216,132700,517,'2022-06-01','04:58:44','CC','25988943','SOSLEY PEREZ','3135627600','','','V','A','','0000-00-00','00:00:00',1,'1',1,132700,'R',0,'','','N','0',0,0,0,0,'2022-06-22','2022-06-29','2022-06-30','2022-07-07','0000-00-00',0,''),('R',217,131400,517,'2022-06-01','05:14:50','CC','','JUAN CARLOS CORREA','3105463392','','','V','A','','0000-00-00','00:00:00',1,'1',1,131400,'R',0,'A','','N','0',0,0,0,0,'2022-06-22','2022-06-29','2022-06-30','2022-07-07','0000-00-00',0,''),('R',218,152565,517,'2022-06-02','08:32:19','CC','1063357034','DIANA GARCIA','3207649404','','','V','A','','0000-00-00','00:00:00',1,'1',1,152565,'R',152565,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',219,137400,517,'2022-06-02','08:34:31','CC','30060518','ENA SOFIA PEREZ','3205161599','','','V','A','','0000-00-00','00:00:00',1,'1',1,137400,'R',137400,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',220,172100,517,'2022-06-02','08:37:18','CC','1003213409','MARY MESTRA','3145145345','','','V','A','','0000-00-00','00:00:00',1,'1',1,172100,'R',0,'R','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',221,152300,517,'2022-06-02','08:59:31','CC','25996469','SAMIRA FLOREZ','3113891307','','','V','A','','0000-00-00','00:00:00',1,'1',1,152300,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',222,117300,517,'2022-06-02','09:15:29','CC','25988459','SADI DE LA OSSA','3215682008','','','V','A','','0000-00-00','00:00:00',1,'1',1,117300,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',223,20234200,517,'2022-06-02','09:29:35','CC','10330557801','ISLENI CONTRERAS','3136543934','','','V','A','','0000-00-00','00:00:00',1,'1',1,20234200,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',224,122300,517,'2022-06-02','09:31:33','CC','26032346','HERCY HERNANDEZ','3137291175','','','V','A','','0000-00-00','00:00:00',1,'1',1,122300,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',225,194954,517,'2022-06-02','09:33:33','CC','43893829','MARGARET RUA','3105472612','','','V','A','','0000-00-00','00:00:00',1,'1',1,194954,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',226,145400,517,'2022-06-02','09:47:05','CC','30060593','ROCIO GARCIA','314542183','','','V','A','','0000-00-00','00:00:00',1,'1',1,145400,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',227,160400,517,'2022-06-02','09:58:04','CC','78590950','OSCAR MENDEZ','3106021636','','','V','A','','0000-00-00','00:00:00',1,'1',1,160400,'',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',228,130400,517,'2022-06-02','11:22:44','CC','78588084','RICARDO ALBERTO TAVORDA','3106409054','','','V','A','','0000-00-00','00:00:00',1,'1',1,130400,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',229,2863900,517,'2022-06-02','04:10:05','CC','1063356410','PAULA PACHECO','3223620280','','','V','A','','0000-00-00','00:00:00',1,'1',1,2863900,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',230,173460,517,'2022-06-02','04:37:01','CC','106335895','WILMER ROJAS','3126398533','','','V','A','','0000-00-00','00:00:00',1,'1',1,173460,'R',0,'A','','N','0',0,0,0,0,'2022-06-23','2022-06-30','2022-07-01','2022-07-08','0000-00-00',0,''),('R',231,178600,517,'2022-06-03','03:38:19','CC','','maria soto','3024240318','','','V','A','','0000-00-00','00:00:00',1,'1',1,178600,'P',0,'A','','N','0',0,0,0,0,'2022-06-24','2022-07-01','2022-07-05','2022-07-11','0000-00-00',0,''),('R',232,178600,517,'2022-06-03','03:40:06','CC','','MARIA SOTO','3024240318','','','V','C','','0000-00-00','00:00:00',1,'1',1,178600,'R',0,'A','','N','0',0,0,0,0,'2022-06-24','2022-07-01','2022-07-05','2022-07-11','0000-00-00',0,''),('R',233,179100,517,'2022-06-03','03:45:43','CC','','GLORIA SALGADO','3113431857','','','V','C','','0000-00-00','00:00:00',1,'1',1,179100,'R',0,'A','','N','0',0,0,0,0,'2022-06-24','2022-07-01','2022-07-05','2022-07-11','0000-00-00',0,''),('R',234,167000,517,'2022-06-03','03:50:32','CC','43418247','LUZ ELENA GOES','3122941066','','','V','C','','0000-00-00','00:00:00',1,'1',1,167000,'R',0,'A','','N','0',0,0,0,0,'2022-06-24','2022-07-01','2022-07-05','2022-07-11','0000-00-00',0,''),('R',235,197730,517,'2022-06-06','11:29:33','CC','','LUDIS LOBO ORTEGA','3218169740','','','V','C','','0000-00-00','00:00:00',1,'1',1,197730,'R',0,'A','','N','0',0,0,0,0,'2022-06-28','2022-07-05','2022-07-06','2022-07-12','0000-00-00',0,''),('R',236,20206400,517,'2022-06-07','09:05:01','CC','','VELIDE PEREZ','3135241309','','','V','C','','0000-00-00','00:00:00',1,'1',1,20206400,'R',0,'A','','N','0',0,0,0,0,'2022-06-29','2022-07-06','2022-07-07','2022-07-13','0000-00-00',0,''),('R',237,184400,517,'2022-06-14','03:02:17','CC','25996062','CARMEN PEREIRA','3235951526','','','V','A','','0000-00-00','00:00:00',1,'1',1,184400,'R',184400,'A','','N','0',0,0,0,0,'2022-07-07','2022-07-13','2022-07-14','2022-07-21','0000-00-00',0,''),('P',66,131200,525,'2024-03-21','03:03:30','CC','78587293','DAIRO PACHECO','','','K 8 13a 70','V','C','1','2024-03-21','03:23:42',1,'1',1,333480,'',0,'','K 8 13a 70','N','0',0,0,0,0,'2024-04-15','2024-04-19','2024-04-22','2024-04-26','0000-00-00',50,'S'),('R',238,134000,598,'2024-03-21','03:26:58','CC','XXXXXXX','EDGARDO MUÑOS','3114368682','','K 8 11 02','V','C','1','2024-03-21','03:34:51',1,'1',1,333509,'',0,'','K 8 11 02','N','0',0,0,0,0,'2024-04-15','2024-04-19','2024-04-22','2024-04-26','0000-00-00',14,'S'),('R',239,149000,598,'2024-03-21','03:36:02','CC','XXXXXXX','NEVIS GENEY FERNANDEZ','3147058836','','Kra 10 Calles 11 - 12','V','C','1','2024-03-21','03:41:47',1,'1',1,333685,'',0,'','Kra 10 Calles 11 - 12','N','0',546,0,0,0,'2024-04-15','2024-04-19','2024-04-22','2024-04-26','0000-00-00',14,'S'),('R',240,145,517,'2024-07-18','10:43:34','CC','15441262','PAOLA BOTACHE','3143506331','acsepal2012@hotmail.com','clle 10-15','V','C','1','2024-07-18','10:54:25',1,'1',1,353059,'R',353059,'','0','N','0',0,0,0,0,'2024-08-08','2024-08-14','2024-08-15','2024-08-22','0000-00-00',0,'N'),('R',241,146000,517,'2025-01-21','10:52:14','CC','1','francisco ramos','3203368590','','C 12 10 27','V','C','3','2025-01-22','12:07:18',1,'1',1,7134,'',0,'','C 12 10 27','N','0',0,0,0,0,'2025-02-10','2025-02-14','2025-02-17','2025-02-21','0000-00-00',53,'N'),('R',242,126400,517,'2025-01-22','02:40:32','CC','1','manuel camargo','1','1','C 9 7 59','V','C','3','2025-01-22','03:07:39',1,'1',1,6899,'',0,'','C 9 7 59','N','0',0,0,0,0,'2025-02-11','2025-02-17','2025-02-18','2025-02-24','0000-00-00',55,'N'),('R',243,5600,517,'2025-03-13','03:07:06','CC','1063361828','MIRIAM','3203368590','0','K 7 5 16','V','C','1','2025-03-13','03:30:51',1,'1',1,16114,'R',16114,'','K 7 5 16','N','0',0,0,0,0,'2025-04-03','2025-04-09','2025-04-10','2025-04-16','0000-00-00',55,'N'),('R',244,198742,517,'2025-03-17','08:55:36','CC','34884636','rosa vergara','3116905522','','K 11 14 36','V','C','3','2025-03-17','09:09:30',1,'1',1,18480,'R',0,'R','K 11 14 36','N','0',0,0,0,0,'2025-04-07','2025-04-11','2025-04-14','2025-04-22','0000-00-00',55,'N'),('R',245,141000,517,'2025-04-10','10:47:59','CC','15036247','LEON URZOLA','4145892196','0','K 9 12-39','V','C','1','2025-04-23','04:55:41',1,'1',1,22962,'R',22962,'','K 9 12-39','N','0',0,0,0,0,'2025-05-05','2025-05-09','2025-05-12','2025-05-16','0000-00-00',0,'N'),('R',246,21800,517,'2025-04-10','11:12:11','CC','1066747113','MARGARITA CORDERO','3014800085','NO','C 2 3 179','V','C','1','2025-04-23','04:28:04',1,'1',1,21600,'R',21600,'','C 2 3 179','N','0',0,0,0,0,'2025-05-05','2025-05-09','2025-05-12','2025-05-16','0000-00-00',12,'N'),('R',247,0,517,'2025-05-08','03:09:54','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','A','','0000-00-00','00:00:00',1,'1',1,28398,'',0,'','Guadalupe ','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',248,152565,517,'2025-05-08','03:09:54','CC','1063357034','diana margarita','3207649404','','guadalupe','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',28398,'','Guadalupe ','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',249,152565,517,'2025-05-08','03:09:54','CC','1063357034','diana margarita','3207649404','','guadalupe','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',28398,'','Guadalupe ','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',250,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',251,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',252,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',253,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',254,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',255,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',256,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',257,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',258,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',259,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',260,152565,517,'2025-05-08','04:02:50','CC','1063357034','diana margarita','3207649404','0','guadalupe ruta 150','V','P','','0000-00-00','00:00:00',1,'1',1,28398,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',261,187700,517,'2025-05-08','04:20:50','CC','78585707','wilson Cantero','','','calle 12b 13c 38','V','A','','0000-00-00','00:00:00',1,'1',1,187700,'R',261,'','calle 12b 13c 38','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('R',262,153300,517,'2025-05-08','04:43:56','CC','10992368','luis manuel','3145233788','0','K 11 13 73','V','P','','0000-00-00','00:00:00',1,'1',1,28424,'R',0,'','K 11 13 73','N','0',0,0,0,0,'2025-05-28','2025-06-04','2025-06-05','2025-06-11','0000-00-00',0,''),('Q',5,186900,545,'2025-07-29','07:54:10','CC','1126246364','','3143343592','0','K 12c 13c 50','V','P','','0000-00-00','00:00:00',2,'1',1,39430,'R',545,'','K 12c 13c 50','N','0',0,0,0,0,'2025-08-19','2025-08-25','2025-08-26','2025-09-01','0000-00-00',0,''),('Q',6,186900,545,'2025-07-29','07:54:10','CC','1126246364','','3143343592','0','K 12c 13c 50','V','P','','0000-00-00','00:00:00',2,'1',1,39430,'R',545,'','K 12c 13c 50','N','0',0,0,0,0,'2025-08-19','2025-08-25','2025-08-26','2025-09-01','0000-00-00',0,''),('R',263,35200,517,'2025-07-30','02:46:30','CC','no','carmen','3241061717','0','K 11 6 15','V','P','','0000-00-00','00:00:00',1,'1',1,37656,'R',0,'','K 11 6 15','N','0',0,0,0,0,'2025-08-20','2025-08-26','2025-08-27','2025-09-02','0000-00-00',0,''),('R',264,48,517,'2025-07-30','03:11:42','CC','1090434333','yanis soto','3216928551','1','guadalupe ruta 150','V','C','1','2025-07-30','03:22:18',1,'1',1,37045,'R',0,'','guadalupe ruta 150','N','0',0,0,0,0,'2025-08-20','2025-08-26','2025-08-27','2025-09-02','0000-00-00',58,'N'),('R',265,2859100,517,'2025-07-30','03:30:13','CC','50999169','omaira vergara','3147134258','1','B/ El Progreso 2','V','C','1','2025-07-30','03:36:43',1,'1',1,41897,'R',0,'','B/ El Progreso 2','N','0',0,0,0,0,'2025-08-20','2025-08-26','2025-08-27','2025-09-02','0000-00-00',58,'N'),('R',266,93750,517,'2025-07-31','09:31:52','CC','106358808','lorena tejada','3234059309','','puerto libertador','V','C','1','2025-07-31','09:41:18',1,'1',1,38298,'R',266,'','puerto libertador ','N','0',0,0,0,0,'2025-08-21','2025-08-27','2025-08-28','2025-09-03','0000-00-00',53,'N'),('P',67,190500,540,'2025-07-31','06:31:32','CC','1063356841','neider arias','3105115570','0','C 14 K 12','V','P','','0000-00-00','00:00:00',2,'1',1,190500,'P',67,'','C 14 K 12','N','0',0,0,0,0,'2025-08-21','2025-08-27','2025-08-28','2025-09-03','0000-00-00',0,''),('R',267,87400,517,'2025-08-22','04:58:58','CC','78586554','manuel silvestre lopez hoyos','3122951591','1','C 9 12 29 I','V','P','','0000-00-00','00:00:00',1,'1',1,43519,'',0,'','C 9 12 29 I','N','0',0,0,0,0,'2025-09-11','2025-09-17','2025-09-18','2025-09-24','0000-00-00',0,''),('R',268,141000,517,'2025-08-22','05:21:39','CC','1128400080','maria monica urzola','3233271946','1','K 9 12-39','V','P','','0000-00-00','00:00:00',1,'1',1,44151,'',0,'','K 9 12-39','N','0',0,0,0,0,'2025-09-11','2025-09-17','2025-09-18','2025-09-24','0000-00-00',0,''),('R',269,62140,517,'2025-08-22','05:32:45','CC','64546200','luz marina moreno','3208023252','1','parque 20 de julio','V','P','','0000-00-00','00:00:00',1,'1',1,43248,'R',517,'','parque 20 de julio ','N','0',0,0,0,0,'2025-09-11','2025-09-17','2025-09-18','2025-09-24','0000-00-00',0,''),('R',270,155900,517,'2025-08-22','05:48:55','CC','9129704','jose mazo','3103608151','1','K 10 13b 15','V','P','','0000-00-00','00:00:00',1,'1',1,44338,'R',517,'','K 10 13b 15','N','0',0,0,0,0,'2025-09-11','2025-09-17','2025-09-18','2025-09-24','0000-00-00',0,''),('R',271,5900,517,'2025-08-22','05:57:28','CC','91136926','leandro rodriguez','3023242887','0','C 4 7 38','V','P','','0000-00-00','00:00:00',1,'1',1,42625,'',0,'','C 4 7 38','N','0',0,0,0,0,'2025-09-11','2025-09-17','2025-09-18','2025-09-24','0000-00-00',0,''),('R',272,195510,517,'2025-08-28','03:12:26','CC','30060865','amparo rivera','3148467095','','K 1 C 16 B Porvenir','V','P','','0000-00-00','00:00:00',1,'1',1,44866,'',0,'','K 1 C 16 B Porvenir','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('R',273,435,517,'2025-08-28','03:59:03','CC','42971042','marta ney','315505513','','ruta 30','V','P','','0000-00-00','00:00:00',1,'1',1,42557,'R',0,'','ruta 30','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('R',274,147100,517,'2025-08-28','04:58:35','CC','156170411','aristides salgado','3126170411','','K 9a 16 45','V','P','','0000-00-00','00:00:00',1,'1',1,44218,'R',517,'R','K 9a 16 45','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('R',275,52200,517,'2025-08-28','05:22:44','CC','30060222','juana marzola','3135013939','','K 13 6 21','V','P','','0000-00-00','00:00:00',1,'1',1,43123,'R',517,'','K 13 6 21','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('R',276,14900,517,'2025-08-28','05:28:20','CC','50893719','yazmin arteaga','3145426242','','C 5a 6 05','V','P','','0000-00-00','00:00:00',1,'1',1,42728,'R',517,'','C 5a 6 05','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('R',277,32920,517,'2025-08-28','05:35:42','CC','1063355960','paola samaca','3246813635','','K 10 7 14','V','P','','0000-00-00','00:00:00',1,'1',1,42923,'R',517,'','K 10 7 14','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('R',278,104400,517,'2025-08-28','05:38:52','CC','15677975','julio leonardo','3216927230','','K 7a 8 36','V','P','','0000-00-00','00:00:00',1,'1',1,43707,'R',517,'','K 7a 8 36','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('P',68,1325500,540,'2025-08-28','05:47:41','CC','78585005','rafael augusto','1315085874','','k 8 11 88','V','P','','0000-00-00','00:00:00',2,'1',1,44054,'P',68,'','','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('P',69,58200,540,'2025-08-28','05:52:42','CC','92506364','luis suarez','3225070343','','C 6 13 51','V','P','','0000-00-00','00:00:00',2,'1',1,43198,'P',540,'','C 6 13 51','N','0',0,0,0,0,'2025-09-17','2025-09-23','2025-09-24','2025-09-30','0000-00-00',0,''),('R',279,23300,595,'2026-03-25','05:36:52','CC','10876051','santiago guerra ruiz','3126483517','0','Kra.9 # 6-17','V','C','1','2026-05-26','04:09:43',2,'1',1,79825,'R',279,'R','Kra.9 # 6-17','N','0',0,0,0,0,'2026-04-16','2026-04-22','2026-04-23','2026-04-29','0000-00-00',0,'N'),('R',280,131000,595,'2026-03-25','05:49:35','CC','1065637640','rafael rojano','3166224395','0','K 8 13a 96','V','C','1','2026-05-26','04:21:22',2,'1',1,81049,'R',280,'R','K 8 13a 96','N','0',0,0,0,0,'2026-04-16','2026-04-22','2026-04-23','2026-04-29','0000-00-00',0,'N'),('R',281,127700,595,'2026-03-26','03:22:22','CC','78290671','alvaro mestra','3105102311','0','C 2 10 17','V','C','1','2026-05-26','04:30:23',2,'1',1,79872,'R',127700,'R','C 2 10 17','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,'N'),('R',282,20226600,517,'2026-03-26','03:29:47','CC','1063285926','yeris valdez','3016944321','0','ruta 70','V','C','3','2026-05-26','04:40:53',1,'1',1,84462,'R',20226600,'R','carrera 9 numero11-45 camili jimenez','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,'N'),('R',283,170900,517,'2026-03-26','03:44:36','CC','34883969','reina margoth parra','3042389199','0','D 13a 12c 53','V','P','','0000-00-00','00:00:00',2,'1',1,81528,'',0,'','D 13a 12c 53','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,''),('R',284,5900,517,'2026-03-26','04:01:00','CC','1129575035','elizabeth lagares','3023242887','0','C 4 7 38','V','P','','0000-00-00','00:00:00',1,'1',1,79636,'R',5900,'','C 4 7 38','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,''),('R',285,18600,517,'2026-03-26','04:07:38','CC','25990038','lina maria tafur','3218381479','0','C 5a 5 53','V','P','','0000-00-00','00:00:00',1,'1',1,79778,'R',18600,'','C 5a 5 53','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,''),('R',286,306,517,'2026-03-26','04:13:34','CC','1063357988','rosa rodriguez','3245877732','0','ruta 10','V','P','','0000-00-00','00:00:00',1,'1',1,79505,'R',306,'','K 9 11-45','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,''),('R',287,42400,517,'2026-04-30','03:06:20','CC','1063356062','ludis mercado','3224711052','no','C 5 11 74','V','C','3','2026-05-27','04:17:50',1,'1',1,196304,'R',287,'','C 5 11 74','N','0',0,0,0,0,'2026-05-22','2026-05-28','2026-05-29','2026-06-04','0000-00-00',0,'N'),('R',288,312,517,'2026-04-30','03:23:51','CC','64573652','judith pacheco','3117017107','','40','V','C','1','2026-05-27','10:52:43',1,'1',1,195783,'',0,'','40','N','0',0,0,0,0,'2026-05-22','2026-05-28','2026-05-29','2026-06-04','0000-00-00',0,'N'),('R',289,2600500,517,'2026-04-30','03:32:27','CC','92030744','antonio de la osa','3045418037','','80','V','C','1','2026-05-27','11:12:29',1,'1',1,198853,'R',288,'','80','N','0',0,0,0,0,'2026-05-22','2026-05-28','2026-05-29','2026-06-04','0000-00-00',0,'N'),('R',290,138780,517,'2026-04-30','03:46:40','CC','1065815521','nevis mesa','3246872967','','Cra 9 Calle 14','V','C','3','2026-05-27','04:07:29',1,'1',1,197417,'R',290,'','Cra 9 Calle 14','N','0',0,0,0,0,'2026-05-22','2026-05-28','2026-05-29','2026-06-04','0000-00-00',0,'N'),('R',291,66900,517,'2026-04-30','03:49:28','CC','34883837','gricelda ochoa','3117388366','','K 9 8 50','V','C','1','2026-05-27','11:26:35',1,'1',1,196580,'R',291,'','K 9 8 50','N','0',0,0,0,0,'2026-05-22','2026-05-28','2026-05-29','2026-06-04','0000-00-00',0,'N'),('R',292,77800,517,'2026-05-20','04:17:19','CC','0','RUBEN DARIO HOYOLA','3207341969','0','C 7 12 64','V','A','','0000-00-00','00:00:00',1,'1',1,202033,'',0,'','C 7 12 64','N','0',0,0,0,0,'2026-06-10','2026-06-17','2026-06-18','2026-06-24','0000-00-00',0,''),('R',293,87900,517,'2026-05-20','04:52:33','CC','0','NOHORA DOMINGUEZ SUAREZ','3145201990','0','C 9 12 61','V','C','3','2026-05-22','11:06:26',1,'1',1,202147,'',0,'','C 9 12 61','N','0',0,0,0,0,'2026-06-10','2026-06-17','2026-06-18','2026-06-24','0000-00-00',0,'N'),('R',294,77800,517,'2026-05-21','08:23:23','CC','30060196','MARTA PEREZ','3207341969','0','C 7 12 64','V','C','1','2026-05-21','04:48:47',1,'1',1,202033,'',0,'','C 7 12 64','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',0,'N'),('R',295,149300,517,'2026-05-21','08:28:21','CC','1003290824','DANIEL ACUÑA','3117348093','0','K 10 11 16','V','C','1','2026-05-21','04:38:45',1,'1',1,202873,'',0,'','K 10 11 16','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',0,'N'),('R',296,145700,517,'2026-05-21','08:32:39','CC','0','JOSE DOMINGO','3135727741','0','C 12 9 44','V','P','','0000-00-00','00:00:00',1,'1',1,202828,'',0,'','C 12 9 44','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',0,''),('R',297,81700,517,'2026-05-21','08:41:13','CC','0','ORLINDA MERCEDES ORTEGA','3127717625','0','C 7 13a 06','V','C','1','2026-05-21','03:07:43',1,'1',1,202078,'',0,'','C 7 13a 06','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',55,'N'),('P',70,37100,549,'2026-05-21','09:00:09','CC','0','JUANA GOMEZ','3147160734','0','C 2 11 19','V','C','1','2026-05-21','03:25:11',1,'1',1,201586,'',0,'','C 2 11 19','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',0,'N'),('R',298,71200,595,'2026-05-21','10:17:46','CC','30568550','BERNAIS DE HOYOS','3126868856','0','C 7 13 61','V','C','1','2026-05-21','03:38:48',2,'1',1,201963,'',0,'','C 7 13 61','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',0,'N'),('Q',7,2263700,553,'2026-05-21','03:55:22','CC','25996115','ARACELIS PAYARES','3114339767','0','B/ Ramon Rubio','V','C','1','2026-05-21','04:04:04',1,'1',1,203795,'',0,'','B/ Ramon Rubio','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',0,'N'),('R',299,55300,595,'2026-05-21','04:12:35','CC','78591064','DEMETRIO ALDANA','3116339407','0','C 4 13a 48','V','C','1','2026-05-21','04:22:22',2,'1',1,201787,'',0,'','C 4 13a 48','N','0',0,0,0,0,'2026-06-11','2026-06-18','2026-06-19','2026-06-25','0000-00-00',0,'N'),('R',300,188700,595,'2026-05-22','02:29:56','CC','6887749','ALBERTO AVILEZ','3202401076','0','K 12 13b 44','V','C','1','2026-05-22','02:40:07',2,'1',1,203367,'',0,'','K 12 13b 44','N','0',0,0,0,0,'2026-06-12','2026-06-19','2026-06-22','2026-06-26','0000-00-00',0,'N'),('R',301,155900,517,'2026-05-25','08:18:45','CC','50997577','LUDIS MARIA MAZO MARIN','3106308151','0','K 10 13b 15','V','C','3','2026-05-25','08:27:31',1,'1',1,202965,'',0,'','K 10 13b 15','N','0',0,0,0,0,'2026-06-15','2026-06-22','2026-06-23','2026-06-30','0000-00-00',0,'N'),('Q',8,20246600,553,'2026-05-25','09:04:36','CC','78585104','UBALDO ANTONIO OSORIO','3226081090','0','Calle 1','V','C','3','2026-05-25','09:08:53',1,'1',1,206200,'',0,'','Calle 1','N','0',0,0,0,0,'2026-06-15','2026-06-22','2026-06-23','2026-06-30','0000-00-00',0,'N'),('P',71,172100,550,'2026-05-25','04:40:19','CC','1003213409','MARI MESTRA','3023711567','0','K 10 10 59','V','C','1','2026-05-25','04:51:28',1,'1',1,202884,'',0,'','K 10 10 59','N','0',0,0,0,0,'2026-06-15','2026-06-22','2026-06-23','2026-06-30','0000-00-00',0,'N'),('P',72,150200,550,'2026-05-26','08:24:34','CC','3023711567','ETILVIO ORTIZ','3023711567','0','K 10 10 59','V','C','1','2026-05-26','08:33:25',1,'1',1,202884,'',0,'','K 10 10 59','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('R',302,180406,598,'2026-05-26','08:47:48','CC','1063355168','GLORIA MARTINEZ','3126136874','0','D 13a 12c 16','V','C','1','2026-05-26','10:26:30',1,'1',1,203266,'',0,'','D 13a 12c 16','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('Q',9,20207200,546,'2026-05-26','08:56:06','CC','1001533185','VALENTINA CAUSIL CEBALLOS','3223266601','0','B. Ramon Rubio','V','C','3','2026-05-26','09:03:58',1,'1',1,205993,'',0,'','B. Ramon Rubio','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',55,'N'),('R',303,106700,517,'2026-05-26','10:12:05','CC','52355143','CLAUDIA PATRICIA NAVARRO','3223049579','0','C 10 7a 06','V','C','1','2026-05-26','10:17:53',1,'1',1,202366,'',0,'','C 10 7a 06','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('P',73,110100,540,'2026-05-26','10:45:07','CC','33119163','EFIGENIA','3145342144','0','K 11 11 34','V','C','1','2026-05-26','10:50:49',2,'1',1,202418,'',0,'','K 11 11 34','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('P',74,149200,546,'2026-05-26','10:56:27','CC','0','SOL AMADA SALGADO DE ROMERO','0','0','Cra 10 11 66 B/ Camilo Jimenez','V','C','1','2026-05-26','11:02:05',1,'1',1,202872,'',0,'','Cra 10 11 66 B/ Camilo Jimenez','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('Q',10,123500,546,'2026-05-26','11:06:28','CC','50999257','CONSUELO PATERNINA','3206150865','0','C 9 7a 04','V','C','1','2026-05-26','11:11:19',1,'1',1,202566,'',0,'','C 9 7a 04','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('P',75,5100,550,'2026-05-26','11:20:53','CC','30059965','MARIA ELENA MEJIA MONTOYA','3107067943','0','CARRERA 8 N 5-26','V','C','3','2026-05-26','11:28:19',1,'1',1,201238,'',0,'','CARRERA 8 N 5-26','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('P',76,70800,540,'2026-05-26','11:44:59','CC','26391968','LYNEY LEMOS','3226043960','0','C 7 10 24','V','P','','0000-00-00','00:00:00',2,'1',1,201959,'',0,'','C 7 10 24','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,''),('P',77,70800,540,'2026-05-26','11:44:59','CC','26391968','LYNEY LEMOS','3226043960','0','C 7 10 24','V','C','1','2026-05-26','11:52:36',2,'1',1,201959,'',0,'','C 7 10 24','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('P',78,2501000,550,'2026-05-26','02:28:32','CC','0','LEIDY GUTIERREZ MARIN','3147029556','0','Calle 15 B/ Ramon Rubio','V','C','1','2026-05-26','03:23:33',1,'1',1,204067,'',0,'','Calle 15 B/ Ramon Rubio','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('R',304,106200,517,'2026-03-27','02:59:12','CC','0','PABLO ROMERO PRASCA','0','0','C 10 7 58','V','P','','0000-00-00','00:00:00',1,'1',1,202361,'',0,'','C 10 7 58','N','0',0,0,0,0,'2026-04-20','2026-04-24','2026-04-27','2026-05-04','0000-00-00',0,''),('R',305,106200,517,'2026-03-27','02:59:12','CC','0','PABLO ROMERO PRASCA','0','0','C 10 7 58','V','C','3','2026-05-26','03:06:28',2,'1',1,202361,'',0,'','C 10 7 58','N','0',0,0,0,0,'2026-04-20','2026-04-24','2026-04-27','2026-05-04','0000-00-00',0,'N'),('R',306,22100,595,'2026-04-27','03:37:24','CC','1131107295','MARIBEL CANTERO','3014750546','0','K 7 1a 12','V','C','1','2026-05-26','03:42:44',2,'1',1,201425,'',0,'','K 7 1a 12','N','0',0,0,0,0,'2026-05-19','2026-05-25','2026-05-26','2026-06-01','0000-00-00',0,'N'),('R',307,23300,595,'2026-05-26','03:48:29','CC','10876051','SANTIAGO GUERRA RUIZ','3126483517','0','Kra.9 # 6-17','V','P','','0000-00-00','00:00:00',2,'1',1,201437,'',0,'','Kra.9 # 6-17','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,''),('R',308,170900,595,'2026-03-24','04:47:31','CC','34883969','REINA MARGOTH PARRA','3042389199','0','D 13a 12c 53','V','C','1','2026-05-26','04:51:12',2,'1',1,203144,'',0,'','D 13a 12c 53','N','0',0,0,0,0,'2026-04-15','2026-04-21','2026-04-22','2026-04-28','0000-00-00',0,'N'),('R',309,27500,595,'2026-05-26','04:57:20','CC','0','ELVIRA CORONADO','3104204946','0','C 2 10 17','V','A','','0000-00-00','00:00:00',2,'1',1,201484,'',0,'','C 2 10 17','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,''),('R',310,27500,595,'2026-03-26','05:03:37','CC','0','ELVIRA CORONADO','3104204946','0','C 2 10 17','V','C','1','2026-05-26','05:08:40',2,'1',1,201484,'',0,'','C 2 10 17','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,'N'),('P',79,49100,549,'2026-03-26','09:48:34','CC','1003079713','NEFALIS GIL','3112064873','0','C 6 12 67','V','C','1','2026-05-27','09:55:36',1,'1',1,201716,'',0,'','C 6 12 67','N','0',0,0,0,0,'2026-04-17','2026-04-23','2026-04-24','2026-04-30','0000-00-00',0,'N'),('R',311,500,517,'2026-05-27','10:05:27','CC','30060147','BARBARA MONTALVO','3215629112','0','K 8 5a 27','V','A','','0000-00-00','00:00:00',1,'1',1,201165,'',0,'','K 8 5a 27','N','0',0,0,0,0,'2026-06-18','2026-06-24','2026-06-25','2026-07-02','0000-00-00',0,''),('R',312,500,517,'2026-03-25','10:08:36','CC','30060147','BARBARA MONTALVO','3215629112','0','K 8 5a 27','V','C','3','2026-05-27','10:16:25',1,'1',1,201165,'',0,'','K 8 5a 27','N','0',0,0,0,0,'2026-04-16','2026-04-22','2026-04-23','2026-04-29','0000-00-00',0,'N'),('R',313,306,517,'2026-05-27','10:24:33','CC','1063357988','ROSA RODRIGUEZ','3245877732','0','0','V','C','3','2026-05-27','10:28:38',1,'1',1,201068,'',0,'','0','N','0',0,0,0,0,'2026-06-18','2026-06-24','2026-06-25','2026-07-02','0000-00-00',0,'N'),('R',314,18600,517,'2026-03-03','10:37:02','CC','25990038','LINA MARIA TAFUR','3218381479','0','C 5a 5 53','V','C','3','2026-05-27','10:40:23',1,'1',1,201390,'',0,'','C 5a 5 53','N','0',0,0,0,0,'2026-03-23','2026-03-27','2026-03-30','2026-04-07','0000-00-00',0,'N'),('P',80,2866300,551,'2026-04-21','11:33:34','CC','50690035','VIRGENINA BALMACEDA','3225439416','0','B/ El Progreso 2','V','C','1','2026-05-27','11:42:04',1,'1',1,205854,'',0,'','B/ El Progreso 2','N','0',0,0,0,0,'2026-05-12','2026-05-19','2026-05-20','2026-05-26','0000-00-00',0,'N'),('R',315,89200,517,'2026-05-27','11:53:13','CC','0','NATIVIDAD WITRON','0','0','D 9a 13 04','V','A','','0000-00-00','00:00:00',1,'1',1,202161,'',0,'','D 9a 13 04','N','0',0,0,0,0,'2026-06-18','2026-06-24','2026-06-25','2026-07-02','0000-00-00',0,''),('R',316,89200,517,'2026-04-25','11:55:55','CC','0','NATIVIDAD WITRON','0','0','D 9a 13 04','V','C','3','2026-05-27','11:59:44',1,'1',1,202161,'',0,'','D 9a 13 04','N','0',0,0,0,0,'2026-05-15','2026-05-22','2026-05-25','2026-05-29','0000-00-00',0,'N'),('Q',11,137450,553,'2026-04-22','02:12:40','CC','1063278378','ANA FLOREZ','3216502074','0','Calle 8 N? 3-76','V','C','1','2026-05-27','02:16:25',1,'1',1,202734,'',0,'','Calle 8 N? 3-76','N','0',0,0,0,0,'2026-05-13','2026-05-20','2026-05-21','2026-05-27','0000-00-00',0,'N'),('P',81,56500,540,'2026-04-22','02:40:08','CC','36573767','MARTHA RAMIREZ','3147948326','0','C 4 13 48','V','P','','0000-00-00','00:00:00',2,'1',1,201804,'',0,'','C 4 13 48','N','0',0,0,0,0,'2026-05-13','2026-05-20','2026-05-21','2026-05-27','0000-00-00',0,''),('P',82,56500,540,'2026-04-22','02:40:08','CC','36573767','MARTHA RAMIREZ','3147948326','0','C 4 13 48','V','C','1','2026-05-27','02:44:23',2,'1',1,201804,'',0,'','C 4 13 48','N','0',0,0,0,0,'2026-05-13','2026-05-20','2026-05-21','2026-05-27','0000-00-00',0,'N'),('Q',12,166900,553,'2026-04-20','02:54:55','CC','64582353','','3106331547','0','K 9b 16 39','V','C','1','2026-05-27','03:09:00',1,'1',1,203098,'',0,'','K 9b 16 39','N','0',0,0,0,0,'2026-05-11','2026-05-15','2026-05-19','2026-05-25','0000-00-00',0,'N'),('P',83,4600,546,'2026-05-11','03:17:20','CC','0','JULIO ACUÑA','3136972332','0','C 4 8 12','V','C','1','2026-05-27','03:23:03',1,'1',1,201234,'',0,'','C 4 8 12','N','0',0,0,0,0,'2026-06-01','2026-06-05','2026-06-09','2026-06-15','0000-00-00',0,'N'),('P',84,24500,551,'2026-04-22','03:36:01','CC','25598785','DAYILETH MARTINEZ','3116278609','0','C 5 9 61','V','C','1','2026-05-27','03:45:11',1,'1',1,201448,'',0,'','C 5 9 61','N','0',0,0,0,0,'2026-05-13','2026-05-20','2026-05-21','2026-05-27','0000-00-00',0,'N'),('P',85,20228000,540,'2026-04-26','04:32:38','CC','0','ROSALBA MEJIA','3107443984','0','PUERTO LIBERTADOR','V','P','','0000-00-00','00:00:00',2,'1',1,206085,'',0,'','PUERTO LIBERTADOR','N','0',0,0,0,0,'2026-05-15','2026-05-22','2026-05-25','2026-05-29','0000-00-00',0,''),('P',86,20228000,540,'2026-04-26','04:32:38','CC','0','ROSALBA MEJIA','3107443984','0','PUERTO LIBERTADOR','V','C','1','2026-05-27','04:37:29',2,'1',1,206085,'',0,'','PUERTO LIBERTADOR','N','0',0,0,0,0,'2026-05-15','2026-05-22','2026-05-25','2026-05-29','0000-00-00',0,'N'),('P',87,41200,539,'2026-04-15','04:57:24','CC','1063357072','JUAN DAVID FLOREZ BENITEZ','3215448547','0','C 4 11 41','E','C','1','2026-05-27','05:05:46',3,'1',1,201630,'',0,'','C 4 11 41','N','0',0,0,0,0,'2026-05-06','2026-05-12','2026-05-13','2026-05-20','0000-00-00',0,'N'),('P',88,195700,551,'2026-05-28','08:32:39','CC','1063358878','YORLEDIS OSUNA MORALES','3008727427','0','K 13 15 82 B/ El Porvenir','V','A','','0000-00-00','00:00:00',1,'1',1,203495,'',0,'','K 13 15 82 B/ El Porvenir','N','0',0,0,0,0,'2026-06-19','2026-06-25','2026-06-26','2026-07-03','0000-00-00',0,''),('P',89,195700,551,'2026-03-24','08:38:04','CC','1063358878','YORLEDIS OSUNA MORALES','3008727427','0','K 13 15 82 B/ El Porvenir','V','C','1','2026-05-28','08:42:07',1,'1',1,203495,'',0,'','K 13 15 82 B/ El Porvenir','N','0',0,0,0,0,'2026-04-15','2026-04-21','2026-04-22','2026-04-28','0000-00-00',0,'N'),('P',90,79400,551,'2026-04-27','08:54:36','CC','0','KATERINE HERNÁNDEZ','3008214055','0','C 8 13 148','V','C','1','2026-05-28','09:11:46',1,'1',1,202051,'',0,'','C 8 13 148','N','0',0,0,0,0,'2026-05-19','2026-05-25','2026-05-26','2026-06-01','0000-00-00',0,'N'),('P',91,196750,540,'2026-05-26','09:25:08','CC','1063361237','GREYSI BUSTAMANTE','3202523257','0','0','V','C','1','2026-05-28','09:31:01',2,'1',1,203534,'',0,'','0','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('R',317,40100,517,'2026-05-26','09:36:50','CC','78589911','EVIER LUIS SUAREZ MUÑOZ','3228783997','0','K 11 3 07','V','C','1','2026-05-28','09:47:29',1,'1',1,201618,'',0,'','K 11 3 07','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('P',92,2467000,540,'2026-05-20','09:53:15','CC','30060772','LUZ MARINA ACOSTA','3124336745','0','B. Ramon Rubio Calle 14','V','C','1','2026-05-28','09:56:32',2,'1',1,204026,'',0,'','B. Ramon Rubio Calle 14','N','0',0,0,0,0,'2026-06-10','2026-06-17','2026-06-18','2026-06-24','0000-00-00',0,'N'),('P',93,2467000,540,'2026-05-20','09:53:15','CC','30060772','LUZ MARINA ACOSTA','3124336745','0','B. Ramon Rubio Calle 14','V','C','1','2026-05-28','09:55:47',2,'1',1,204026,'',0,'','B. Ramon Rubio Calle 14','N','0',0,0,0,0,'2026-06-10','2026-06-17','2026-06-18','2026-06-24','0000-00-00',0,'N'),('P',94,172732,540,'2026-05-11','10:09:36','CC','50998441','YORLADIS ESTHER PACHECO MENDOZA','3107390856','0','K 12D 14-47','E','C','1','2026-05-28','10:16:01',2,'1',1,203184,'',0,'','K 12D 14-47','N','0',0,0,0,0,'2026-06-01','2026-06-05','2026-06-09','2026-06-15','0000-00-00',0,'N'),('P',95,172732,540,'2026-05-11','10:09:36','CC','50998441','YORLADIS ESTHER PACHECO MENDOZA','3107390856','0','K 12D 14-47','E','P','','0000-00-00','00:00:00',2,'1',1,203184,'',0,'','K 12D 14-47','N','0',0,0,0,0,'2026-06-01','2026-06-05','2026-06-09','2026-06-15','0000-00-00',0,''),('R',318,41000,517,'2026-05-26','10:23:17','CC','0','ADRIANA HENAO','3105380624','0','C 4 11 52','V','C','3','2026-05-28','10:26:53',1,'1',1,201628,'',0,'','C 4 11 52','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('Q',13,30100,546,'2026-05-26','10:34:50','CC','1037599199','JUAN DIEGO URZOLA','3249114180','','C 4 10 25','V','C','3','2026-05-28','10:41:28',1,'1',1,201511,'',0,'','C 4 10 25','N','0',0,0,0,0,'2026-06-17','2026-06-23','2026-06-24','2026-07-01','0000-00-00',0,'N'),('R',319,55800,595,'2026-05-25','10:45:45','CC','0','ANGELA IBARRA','3137555530','0','C 4 13 36','V','C','1','2026-05-28','10:53:34',2,'1',1,201792,'',0,'','C 4 13 36','N','0',0,0,0,0,'2026-06-15','2026-06-22','2026-06-23','2026-06-30','0000-00-00',0,'N'),('P',96,173800,540,'2026-05-25','11:03:05','CC','0','BEATRIZ PARRA','3105340544','0','K 12a 13 27','V','P','','0000-00-00','00:00:00',2,'1',1,203201,'',0,'','K 12a 13 27','N','0',0,0,0,0,'2026-06-15','2026-06-22','2026-06-23','2026-06-30','0000-00-00',0,''),('P',97,173800,540,'2026-05-25','11:03:05','CC','0','BEATRIZ PARRA','3105340544','0','K 12a 13 27','V','P','','0000-00-00','00:00:00',2,'1',1,203201,'',0,'','K 12a 13 27','N','0',0,0,0,0,'2026-06-15','2026-06-22','2026-06-23','2026-06-30','0000-00-00',0,''),('P',98,130500,540,'2026-06-02','09:44:18','CC','98652140','WILSON DE JESUS MONTES ESCOBAR','3146305618','0','K 8 13a 88','V','P','','0000-00-00','00:00:00',2,'1',1,283170,'',0,'','K 8 13a 88','N','0',0,0,0,0,'2026-06-24','2026-07-01','2026-07-02','2026-07-08','0000-00-00',0,''),('R',320,195720,517,'2026-06-02','09:47:27','CC','78589176','EDINSON MORENO','313598557','0','0','V','C','3','2026-06-03','04:08:57',1,'1',1,284008,'',0,'','0','N','0',0,0,0,0,'2026-06-24','2026-07-01','2026-07-02','2026-07-08','0000-00-00',0,'N'),('P',99,128300,550,'2026-06-02','09:50:49','CC','1065815521','NEVIS MESA','3246872967','0','C 10 8 77','V','C','3','2026-06-03','02:49:13',1,'1',1,283126,'',0,'','C 10 8 77','N','0',0,0,0,0,'2026-06-24','2026-07-01','2026-07-02','2026-07-08','0000-00-00',0,'N'),('R',321,127400,517,'2026-06-02','09:54:50','CC','78587953','ISMAEL HERNANDEZ','3205744728','0','C 10 7a 15','V','C','3','2026-06-03','02:59:09',1,'1',1,283117,'',0,'','C 10 7a 15','N','0',0,0,0,0,'2026-06-24','2026-07-01','2026-07-02','2026-07-08','0000-00-00',0,'N'),('R',322,153700,517,'2026-06-03','04:14:54','CC','6887749','ALBERTO AVILEZ FUENTES','3126929218','0','K 11a 13 35','V','C','3','2026-06-03','04:22:12',1,'1',1,283452,'',0,'','K 11a 13 35','N','0',0,0,0,0,'2026-06-25','2026-07-02','2026-07-03','2026-07-09','0000-00-00',0,'N'),('R',323,164700,517,'2026-06-03','04:34:16','CC','25985576','FIDELINA RUIZ','3205502483','0','CALLE 17 # 9 - 50','V','C','3','2026-06-03','04:40:06',1,'1',1,283581,'',0,'','CALLE 17 # 9 - 50','N','0',0,0,0,0,'2026-06-25','2026-07-02','2026-07-03','2026-07-09','0000-00-00',0,'N');
/*!40000 ALTER TABLE `tramites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usos`
--

DROP TABLE IF EXISTS `usos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usos` (
  `us_coduso` int(2) NOT NULL,
  `us_detalle` char(40) DEFAULT NULL,
  PRIMARY KEY (`us_coduso`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usos`
--

LOCK TABLES `usos` WRITE;
/*!40000 ALTER TABLE `usos` DISABLE KEYS */;
INSERT INTO `usos` (`us_coduso`, `us_detalle`) VALUES (1,'Residencial'),(10,'Industrial'),(11,'Comercial'),(12,'Oficial');
/*!40000 ALTER TABLE `usos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usuario`
--

DROP TABLE IF EXISTS `usuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuario` (
  `us_codemp` char(8) NOT NULL DEFAULT '',
  `us_nombre` char(40) NOT NULL DEFAULT '',
  `us_direcc` char(40) NOT NULL DEFAULT '',
  `us_telefo` char(10) NOT NULL DEFAULT '',
  `us_passwd` char(8) NOT NULL DEFAULT '',
  `us_nivelu` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`us_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuario`
--

LOCK TABLES `usuario` WRITE;
/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vlrtemp`
--

DROP TABLE IF EXISTS `vlrtemp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vlrtemp` (
  `dt_pqr` char(1) NOT NULL,
  `dt_numero` int(9) NOT NULL,
  `dt_codcon` int(4) NOT NULL,
  `dt_period` int(6) NOT NULL DEFAULT '0',
  `dt_ubica` int(1) NOT NULL DEFAULT '0',
  `dt_apagar` float DEFAULT NULL,
  `dt_vlrnue` float DEFAULT NULL,
  PRIMARY KEY (`dt_pqr`,`dt_numero`,`dt_codcon`,`dt_period`,`dt_ubica`),
  KEY `dt_pqr` (`dt_pqr`,`dt_numero`),
  KEY `dt_codcon` (`dt_codcon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vlrtemp`
--

LOCK TABLES `vlrtemp` WRITE;
/*!40000 ALTER TABLE `vlrtemp` DISABLE KEYS */;
/*!40000 ALTER TABLE `vlrtemp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'antsoftw_puerto_pqr'
--

--
-- Dumping routines for database 'antsoftw_puerto_pqr'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-06-05  2:31:48
