/*!40000 ALTER TABLE `sucesos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tactividades`
--

DROP TABLE IF EXISTS `tactividades`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tactividades` (
  `ta_numero` int(9) NOT NULL,
  `ta_codact` int(11) NOT NULL,
  `ta_codemp` char(12) NOT NULL,
  `ta_fecini` date DEFAULT NULL,
  `ta_horini` time DEFAULT NULL,
  `ta_fecfin` date DEFAULT NULL,
  `ta_horfin` time DEFAULT NULL,
  `ta_vlract` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`ta_numero`,`ta_codact`,`ta_codemp`),
  KEY `ta_nroord` (`ta_numero`),
  KEY `ta_codact` (`ta_codact`),
  KEY `ta_codemp` (`ta_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tactividades`
--

LOCK TABLES `tactividades` WRITE;
/*!40000 ALTER TABLE `tactividades` DISABLE KEYS */;
INSERT INTO `tactividades` (`ta_numero`, `ta_codact`, `ta_codemp`, `ta_fecini`, `ta_horini`, `ta_fecfin`, `ta_horfin`, `ta_vlract`) VALUES (24,2,'4','2022-01-18','08:20:00','2022-01-16','04:53:00',-205384.66),(10,14,'4','2022-01-05','08:58:00','2022-01-06','12:00:00',109836.43),(13,42,'10','2022-01-28','08:33:00','2022-01-28','12:00:00',14017.35),(13,40,'10','2022-01-28','08:20:00','2022-01-31','04:34:00',277232.03),(16,42,'10','2022-01-27','08:15:00','2022-01-27','04:51:00',-10563.80),(18,15,'4','2022-01-31','08:30:00','2022-01-31','04:12:00',-15033.10),(14,40,'10','2022-02-02','08:20:00','2022-02-02','04:45:00',-9818.92),(14,42,'10','2022-02-02','08:20:00','2022-02-02','04:45:00',-9818.92),(34,2,'4','2022-02-02','08:15:00','2022-02-02','04:26:00',-8870.88),(60,42,'10','2022-02-12','08:45:00','2022-02-12','11:07:00',9615.77),(39,42,'10','2022-02-02','08:31:00','2022-02-02','03:41:00',-12866.17),(53,42,'10','2022-02-02','08:31:00','2022-02-02','03:41:00',-12866.17),(65,42,'10','2022-02-02','08:31:00','2022-02-16','03:41:00',1345530.12),(54,42,'10','2022-01-27','09:40:00','2022-01-27','00:00:04',-12527.58),(63,2,'4','2022-02-14','08:20:00','2022-02-14','04:18:00',-16116.57),(63,62,'4','2022-02-14','08:20:00','2022-02-14','04:18:00',-16116.57),(73,42,'10','2022-02-22','08:55:00','2022-02-22','05:30:00',-10496.08),(68,14,'10','2022-02-28','10:30:00','2022-02-28','04:15:00',-23362.25),(62,21,'4','2022-02-23','03:20:00','2022-02-23','04:00:00',2708.67),(84,42,'10','2022-02-24','08:00:00','2022-02-24','11:30:00',14220.50),(64,42,'10','2022-02-15','08:45:00','2022-02-15','05:00:00',-9141.75),(81,42,'10','2022-03-03','08:00:00','2022-03-03','11:00:00',12189.00),(96,42,'10','2022-02-24','08:00:00','2022-02-24','03:00:00',-20315.00),(23,42,'12','0000-00-00','08:00:00','0000-00-00','03:00:00',0.00),(57,44,'12','2022-02-03','08:00:00','2022-02-03','05:30:00',-4500.00),(71,44,'12','2022-02-23','08:00:00','2022-02-23','10:45:00',8250.00),(86,44,'12','2022-02-23','08:00:00','2022-02-23','04:00:00',-12000.00),(94,44,'12','2022-02-24','08:00:00','2022-02-24','06:00:00',-6000.00),(49,44,'12','2022-02-09','08:17:00','2022-02-09','04:39:00',-7100.00),(69,44,'12','2022-02-21','08:30:00','2022-02-21','04:37:00',-6350.00),(83,58,'12','2022-02-23','08:00:00','2022-02-24','10:45:00',80250.00),(114,42,'11','2022-03-11','08:00:00','2022-03-12','05:30:00',64500.00),(100,42,'11','2022-03-18','08:30:00','2022-03-18','04:25:00',-11750.00),(120,42,'12','2022-03-17','08:40:00','2022-03-17','09:30:00',2500.00),(121,42,'12','2022-03-18','08:00:00','2022-03-18','09:40:00',5000.00),(123,42,'12','2022-03-21','08:00:00','2022-03-21','09:30:00',4500.00),(125,44,'10','2022-03-22','08:00:00','2022-03-22','04:30:00',-10157.50),(59,2,'4','2022-03-25','08:20:00','2022-03-25','04:45:00',-9818.92),(125,40,'10','2022-03-29','08:45:00','2022-03-29','04:30:00',-15236.25),(131,42,'10','2022-03-28','08:30:00','2022-03-28','04:45:00',-9141.75),(129,44,'10','2022-03-29','08:20:00','2022-03-29','12:00:00',14897.67),(128,44,'10','2022-03-25','08:40:00','2022-03-25','03:45:00',-12527.58),(137,44,'10','2022-04-05','08:15:00','2022-04-05','04:45:00',-10157.50),(134,44,'11','2022-03-29','08:29:00','2022-03-29','05:00:00',-7550.00),(153,42,'10','2022-04-18','08:27:00','2022-04-18','05:12:00',-11173.25),(160,44,'12','2022-04-21','08:00:00','2022-04-21','04:00:00',-12000.00),(159,44,'12','2022-04-20','08:00:00','2022-04-20','04:00:00',-12000.00),(156,44,'12','2022-04-19','08:00:00','2022-04-19','05:00:00',-9000.00),(152,44,'12','2022-04-12','08:00:00','2022-04-12','04:00:00',-12000.00),(172,44,'10','2022-05-02','08:00:00','2022-05-02','11:30:00',14220.50),(189,44,'10','2022-05-02','08:30:00','2022-05-02','04:40:00',-8803.17),(184,44,'10','2022-05-05','08:30:00','2022-05-05','04:40:00',-8803.17),(146,15,'4','2022-04-05','08:20:00','2022-04-05','04:30:00',-8803.17),(142,15,'4','2022-04-13','08:00:00','2022-04-13','05:15:00',-5078.75),(162,15,'4','2022-04-24','09:15:00','2022-04-24','00:00:04',-13204.75),(173,44,'10','2022-04-20','08:30:00','2022-04-20','04:00:00',-14220.50),(168,44,'12','2022-04-25','08:00:00','2022-04-25','12:15:00',12750.00),(185,44,'12','2022-05-10','08:00:00','2022-05-10','02:30:00',-13500.00),(183,44,'12','2022-05-10','02:00:00','2022-05-10','05:30:00',10500.00),(182,44,'12','2022-05-09','08:00:00','2022-05-09','12:00:00',12000.00),(138,44,'12','2022-04-06','08:00:00','2022-04-07','12:30:00',85500.00),(176,44,'12','2022-04-22','08:00:00','2022-04-22','10:15:00',6750.00),(195,44,'10','2022-05-18','08:20:00','2022-05-18','04:30:00',-8803.17),(198,44,'10','2022-05-19','08:30:00','2022-05-19','04:30:00',-16252.00),(204,44,'10','2022-05-19','08:30:00','2022-05-19','04:00:00',-14220.50),(111,15,'4','2022-04-01','08:00:00','2022-04-01','04:30:00',-10157.50),(207,15,'4','2022-05-25','08:00:00','2022-05-25','03:30:00',-14220.50),(194,40,'4','2022-05-13','08:00:00','2022-05-13','03:30:00',-14220.50),(201,40,'13','2022-05-12','08:00:00','2022-05-14','05:00:00',135000.00),(213,15,'4','2022-06-03','08:00:00','2022-06-03','04:15:00',-9141.75),(209,44,'12','2022-06-06','08:00:00','2022-06-07','03:15:00',57750.00),(216,15,'4','2022-06-06','08:15:00','2022-06-06','04:30:00',-9141.75),(217,44,'10','2022-06-07','08:00:00','2022-06-07','03:20:00',-13543.33),(99,15,'4','2022-03-09','08:00:00','2022-03-09','05:45:00',-7110.25),(218,44,'12','2022-06-09','02:00:00','2022-06-08','04:40:00',-62000.00),(197,44,'12','2022-05-16','08:15:00','2022-05-17','03:30:00',57750.00),(220,44,'12','2022-06-03','02:30:00','2022-06-03','05:00:00',7500.00),(226,44,'10','2022-06-15','08:30:00','2022-06-16','04:20:00',80582.83),(214,15,'4','2022-06-10','08:15:00','2022-06-11','11:45:00',111732.50),(230,44,'5','2022-06-21','08:30:00','2022-06-21','10:45:00',9141.75),(222,44,'2','2022-06-08','10:30:00','2022-06-08','12:30:00',8126.00),(229,44,'12','2022-06-15','08:30:00','2022-06-15','10:30:00',6000.00),(227,44,'12','2022-06-13','10:00:00','2022-06-13','04:30:00',-13500.00),(233,44,'6','2022-07-11','08:30:00','2022-07-11','04:45:00',-9141.75),(224,44,'12','2022-06-15','08:15:00','2022-06-15','04:45:00',-7500.00),(239,44,'12','2022-07-15','08:15:00','2022-07-16','10:20:00',78250.00),(241,44,'5','2022-07-22','08:30:00','2022-07-22','04:30:00',-16252.00),(242,44,'5','2022-07-22','08:30:00','2022-07-22','05:15:00',-11173.25),(237,44,'5','2022-07-14','10:00:00','2022-07-14','12:45:00',11173.25),(249,44,'5','2022-08-04','08:30:00','2022-08-04','05:45:00',-5078.75),(240,15,'12','2022-07-18','08:15:00','2022-07-18','05:45:00',-4500.00),(256,15,'12','2022-08-03','08:15:00','2022-08-03','05:45:00',-4500.00),(261,44,'13','2022-08-12','08:30:00','2022-08-12','10:45:00',6750.00),(257,44,'5','2022-08-09','08:30:00','2022-08-09','04:45:00',-9141.75),(255,44,'5','2022-08-11','08:30:00','2022-08-11','04:15:00',-15236.25),(263,15,'12','2022-08-12','08:30:00','2022-08-12','12:15:00',11250.00),(223,42,'13','2022-06-09','08:30:00','2022-06-09','11:15:00',8250.00),(258,44,'5','2022-08-09','10:00:00','2022-08-09','12:15:00',9141.75),(266,42,'13','2022-08-23','08:30:00','2022-08-23','04:30:00',-12000.00),(252,42,'10','2022-08-05','08:30:00','2022-08-05','04:30:00',-16252.00),(274,44,'12','2022-09-06','08:30:00','2022-09-06','05:15:00',-8250.00),(278,44,'13','2022-09-12','08:15:00','2022-09-12','05:30:00',-3750.00),(273,2,'6','2022-08-05','10:00:00','2022-08-05','03:15:00',-21330.75),(277,40,'13','2022-09-09','08:00:00','2022-09-09','05:30:00',-4500.00),(283,44,'13','2022-09-26','10:35:00','2022-09-26','12:00:00',4250.00),(281,44,'5','2022-09-22','08:30:00','2022-09-22','04:15:00',-15236.25),(282,44,'12','2022-09-23','10:30:00','2022-09-23','01:00:00',-25500.00),(287,42,'12','2022-09-26','08:30:00','2022-09-26','10:00:00',4500.00),(291,15,'13','2022-09-30','08:00:00','2022-09-30','05:30:00',-4500.00),(286,15,'12','2022-09-28','08:00:00','2022-09-28','05:15:00',-3750.00),(293,15,'2','2022-10-07','08:00:00','2022-10-08','05:30:00',87354.50),(284,15,'12','2022-09-27','08:00:00','2022-10-27','03:15:00',2145750.00),(295,15,'2','2022-09-06','02:00:00','2022-09-06','05:30:00',14220.50),(288,15,'12','2022-09-30','08:00:00','2022-09-30','04:00:00',-12000.00),(294,0,'2','2022-09-06','08:00:00','2022-09-06','04:00:00',-16252.00),(294,15,'2','2022-09-06','08:00:00','2022-09-06','04:00:00',-16252.00),(190,15,'12','2022-06-15','08:00:00','2022-06-18','04:30:00',205500.00),(285,44,'12','2022-09-26','08:30:00','2022-09-26','10:00:00',4500.00),(270,44,'12','2022-08-30','08:30:00','2022-08-30','12:15:00',11250.00),(246,44,'12','2022-07-28','02:30:00','2022-07-28','05:45:00',9750.00),(269,44,'12','2022-08-31','08:30:00','2022-08-31','03:15:00',-14250.00),(271,42,'5','0000-00-00','08:30:00','0000-00-00','05:00:00',0.00),(271,44,'5','2022-08-30','03:09:00','2022-08-30','05:00:00',7516.55),(326,40,'12','2022-12-13','08:46:00','2022-12-13','05:15:00',-7450.00),(327,44,'5','2022-12-13','08:30:00','2022-12-13','12:00:00',14220.50),(305,15,'5','2022-11-22','08:00:00','2022-11-22','12:00:00',16252.00),(306,44,'5','2022-11-22','08:30:00','2022-11-22','05:00:00',-10157.50),(308,44,'5','2022-11-30','08:30:00','2022-11-30','04:20:00',-15574.83),(325,44,'5','2022-12-06','08:30:00','2022-12-06','04:20:00',-15574.83),(312,44,'5','2022-12-22','08:30:00','2022-12-22','03:40:00',-12866.17),(329,40,'5','2022-12-16','08:30:00','2022-12-16','04:00:00',-14220.50),(315,40,'12','2022-12-19','08:30:00','2022-12-19','04:30:00',-12000.00),(317,42,'12','2022-12-20','08:30:00','2022-12-20','12:00:00',10500.00),(328,15,'12','2022-12-29','08:30:00','2022-12-29','05:00:00',-7500.00),(331,15,'5','2023-01-10','08:30:00','2023-01-10','03:00:00',-18283.50),(332,15,'5','0203-01-12','08:30:00','2023-01-12','04:00:00',3408789.25),(335,42,'5','2023-01-13','08:30:00','2023-01-13','05:00:00',-10157.50),(337,42,'5','2023-01-13','08:30:00','2023-01-13','05:00:00',-10157.50),(338,15,'5','2023-01-23','08:30:00','2023-01-23','04:00:00',-14220.50),(340,44,'5','2023-01-27','08:30:00','2023-01-27','03:00:00',-18283.50),(343,21,'6','2023-01-27','08:30:00','2023-01-27','10:45:00',9141.75),(341,42,'5','2023-01-28','08:30:00','2023-01-28','04:00:00',-14220.50),(345,15,'5','2023-01-29','08:30:00','2023-01-29','05:00:00',-10157.50),(330,42,'12','2023-01-30','08:30:00','2023-01-30','04:40:00',-6500.00),(346,15,'5','2023-01-30','08:30:00','2023-01-30','04:00:00',-14220.50),(347,21,'8','2023-01-31','08:30:00','2023-01-31','10:00:00',6094.50),(350,15,'2','2023-02-28','08:30:00','2023-02-28','03:00:00',-18283.50),(334,41,'12','2023-01-07','08:30:00','2023-01-07','04:00:00',-10500.00),(353,15,'12','2023-02-28','08:30:00','2023-02-28','05:00:00',-7500.00),(310,44,'5','2022-11-18','08:30:00','2022-11-18','03:15:00',-19299.25),(322,42,'5','2022-12-15','08:30:00','2022-12-15','04:00:00',-14220.50),(323,42,'5','2022-12-26','08:30:00','2022-12-26','11:00:00',10157.50),(320,15,'2','2022-12-16','08:30:00','2022-12-16','11:45:00',13204.75),(318,42,'5','2022-12-26','08:30:00','2022-12-26','11:45:00',13204.75),(265,42,'5','2022-08-23','10:00:00','2022-08-23','12:00:00',8126.00),(307,44,'5','2022-11-18','08:30:00','2022-11-18','12:15:00',15236.25),(311,40,'5','2022-11-18','02:30:00','2022-11-18','05:30:00',12189.00),(324,42,'5','2022-12-20','02:30:00','2022-12-20','05:00:00',10157.50),(321,42,'5','2022-12-10','08:30:00','2022-12-10','10:45:00',9141.75),(313,15,'5','2022-11-24','08:30:00','2022-12-24','11:45:00',2938564.75),(314,42,'5','2022-11-22','08:30:00','2022-11-22','12:30:00',16252.00),(366,15,'12','2023-03-07','08:30:00','2023-03-07','12:00:00',10500.00),(349,42,'6','2023-03-07','08:30:00','2023-03-07','04:30:00',-16252.00),(348,42,'13','2023-03-13','00:00:08','2023-03-13','10:15:00',5250.00),(354,42,'13','2023-03-18','02:30:00','2023-03-18','05:00:00',7500.00),(355,42,'13','2023-02-20','08:30:00','2023-02-20','03:00:00',-13500.00),(356,42,'13','2023-02-24','02:30:00','2023-02-24','05:00:00',7500.00),(344,42,'13','2023-01-31','08:30:00','2023-01-31','05:00:00',-7500.00),(342,42,'12','2023-01-25','08:30:00','2023-03-25','04:30:00',2516950.00),(367,15,'12','2023-03-21','08:30:00','2023-03-21','04:30:00',-12000.00),(373,15,'12','2023-03-13','08:30:00','2023-03-13','04:15:00',-11250.00),(375,63,'14','2023-03-17','08:30:00','2023-03-27','03:15:00',953789.25),(383,42,'13','2023-03-28','08:30:00','2023-03-28','04:30:00',-12000.00),(362,42,'12','2023-03-13','08:30:00','2023-03-13','04:30:00',-12000.00),(374,15,'5','2023-03-23','08:30:00','2023-03-23','03:15:00',-19299.25),(333,15,'5','2023-03-10','08:30:00','2023-03-10','10:30:00',8126.00),(376,42,'13','2023-03-27','08:30:00','2023-03-27','12:30:00',12000.00),(369,42,'13','2023-03-22','02:00:00','2023-03-22','05:30:00',10500.00),(370,42,'13','2023-03-21','08:30:00','2023-03-21','03:00:00',-13500.00),(377,15,'5','2023-03-29','08:30:00','2023-03-29','04:30:00',-16252.00),(368,42,'13','2023-03-23','08:30:00','2023-03-23','12:00:00',10500.00),(372,42,'13','2023-03-13','08:30:00','2023-03-13','12:00:00',10500.00),(371,42,'13','2023-03-16','08:30:00','2023-03-16','04:30:00',-12000.00),(385,42,'13','2023-03-23','08:30:00','2023-03-23','05:00:00',-7500.00),(384,42,'12','2023-03-31','02:30:00','2023-03-31','05:00:00',7500.00),(382,42,'13','2023-03-17','08:30:00','2023-03-17','12:00:00',10500.00),(339,15,'5','2023-01-23','08:30:00','2023-01-23','04:30:00',-16252.00),(386,42,'5','2023-04-05','08:30:00','2023-04-05','12:00:00',14220.50),(387,42,'2','2023-04-13','00:00:02','2023-04-13','04:00:00',8126.00),(393,42,'2','2023-04-18','08:30:00','2023-04-18','12:00:00',14220.50),(394,42,'13','2023-04-22','08:30:00','2023-04-22','12:00:00',10500.00),(395,42,'13','2023-04-24','08:30:00','2023-04-24','12:30:00',12000.00),(403,42,'5','2023-04-28','02:30:00','2023-04-28','05:30:00',12189.00),(398,44,'5','2023-04-19','08:30:00','2023-04-19','12:00:00',14220.50),(406,0,'5','2023-05-08','08:30:00','2023-05-08','12:30:00',16252.00),(406,42,'5','2023-05-08','08:30:00','2023-05-08','12:30:00',16252.00),(405,42,'13','2023-05-08','02:30:00','2023-05-08','04:30:00',6000.00),(408,42,'13','2023-05-10','08:30:00','2023-05-10','04:30:00',-12000.00),(410,42,'6','2023-05-10','08:30:00','2023-05-10','04:40:00',-8803.17),(409,15,'2','2023-05-12','08:30:00','2023-05-12','05:00:00',-10157.50),(415,42,'14','2023-05-16','08:30:00','2023-05-16','04:00:00',-14220.50),(416,15,'14','0000-00-00','08:30:00','0000-00-00','12:00:00',0.00),(420,42,'5','2023-05-23','08:30:00','2023-05-23','12:00:00',14220.50),(418,42,'6','2023-05-26','08:30:00','2023-05-26','04:00:00',-14220.50),(422,42,'13','2023-05-29','02:30:00','2023-05-29','05:00:00',7500.00),(421,42,'5','2023-05-26','08:30:00','2023-05-26','04:30:00',-16252.00),(417,42,'12','2023-05-12','08:30:00','2023-05-12','10:00:00',4500.00),(426,40,'12','2023-05-30','08:30:00','2023-05-30','04:00:00',-10500.00),(419,42,'5','2023-05-26','08:30:00','2023-05-26','12:00:00',14220.50),(427,42,'12','2023-05-31','08:30:00','2023-05-31','05:00:00',-7500.00),(430,40,'12','2023-06-09','08:30:00','2023-06-09','05:00:00',-7500.00),(432,40,'12','2023-06-13','08:30:00','2023-06-13','12:00:00',10500.00),(431,42,'12','2023-06-08','08:30:00','2023-06-08','04:30:00',-12000.00),(433,42,'12','2023-06-16','08:30:00','2023-06-16','05:00:00',-7500.00),(435,42,'13','2023-06-26','02:30:00','2023-06-26','04:30:00',6000.00),(434,42,'13','2023-06-26','08:30:00','2023-06-26','12:00:00',10500.00),(445,42,'12','2023-07-07','08:00:00','2023-07-07','11:00:00',9000.00),(437,63,'2','2023-06-29','08:30:00','2023-06-29','12:00:00',14220.50),(436,62,'12','2023-06-23','08:30:00','2023-06-23','12:00:00',10500.00),(439,42,'12','2023-06-26','08:30:00','2023-06-26','05:30:00',-9000.00),(451,42,'14','2023-07-12','08:30:00','2023-07-12','10:00:00',6094.50),(449,42,'12','2023-07-10','08:30:00','2023-07-30','04:30:00',1428000.00),(454,42,'13','2023-07-31','02:30:00','2023-07-31','04:30:00',6000.00),(453,42,'13','2023-07-31','08:30:00','2023-07-31','12:00:00',10500.00),(448,42,'xx','2023-06-30','09:59:00','2023-06-30','09:12:00',0.00),(450,44,'12','2023-08-19','08:30:00','2023-07-19','12:00:00',-2218500.00),(457,40,'5','2023-07-24','08:00:00','2023-07-24','07:00:00',-4063.00),(475,15,'5','2023-08-08','10:00:00','2023-08-08','12:00:00',8126.00),(459,15,'5','2023-08-10','02:30:00','2023-08-10','04:30:00',8126.00),(460,42,'13','2023-08-11','08:30:00','2023-08-11','03:45:00',-9750.00),(461,40,'13','2023-08-15','08:30:00','2023-08-15','05:30:00',-9000.00),(465,42,'13','2023-08-14','08:30:00','2023-08-14','10:00:00',4500.00),(469,42,'12','2023-08-17','08:30:00','2023-08-17','04:30:00',-12000.00),(462,42,'13','2023-08-18','08:30:00','2023-08-18','04:30:00',-12000.00),(474,42,'13','2023-08-20','10:00:00','2023-08-20','12:00:00',6000.00),(470,42,'xx','2023-08-25','08:30:00','2023-08-25','03:30:00',0.00),(470,42,'12','2023-08-25','08:30:00','2023-08-25','03:30:00',-15000.00),(471,42,'14','2023-08-24','02:30:00','2023-08-24','05:30:00',12189.00),(472,42,'12','2023-08-31','02:30:00','2023-08-31','04:30:00',6000.00),(464,40,'13','2023-08-15','08:30:00','2023-08-15','05:45:00',-3750.00),(477,42,'13','2023-09-05','08:30:00','2023-09-05','12:35:00',12250.00),(485,42,'12','0000-00-00','08:30:00','0000-00-00','05:35:00',0.00),(452,42,'13','0000-00-00','02:30:00','0000-00-00','05:30:00',0.00),(452,0,'13','0000-00-00','02:30:00','0000-00-00','05:30:00',0.00),(486,42,'12','2023-09-29','08:30:00','2023-09-29','05:15:00',-8250.00),(480,42,'12','2023-09-08','02:20:00','2023-09-08','05:30:00',9500.00),(476,42,'13','2023-08-22','08:30:00','2023-08-22','03:15:00',-14250.00),(482,42,'12','2023-09-12','08:30:00','2023-09-12','05:45:00',-3750.00),(478,15,'5','2023-09-04','02:30:00','2023-09-04','05:30:00',12189.00),(487,42,'13','2023-09-26','08:30:00','2023-09-26','03:15:00',-14250.00),(479,42,'10','2023-09-11','08:30:00','2023-09-11','12:20:00',15574.83),(491,15,'5','2023-09-26','09:30:00','2023-09-26','04:20:00',-19637.83),(481,42,'12','2023-09-12','02:30:00','2023-09-12','04:45:00',6750.00),(493,42,'12','2023-09-07','08:30:00','2023-09-07','12:15:00',11250.00),(494,42,'6','2023-09-13','08:30:00','2023-09-13','03:15:00',-19299.25),(496,42,'13','2023-09-14','08:30:00','2023-09-14','01:15:00',-20250.00),(497,42,'13','2023-09-17','08:30:00','2023-09-17','03:45:00',-9750.00),(502,15,'9','2023-10-18','08:30:00','2023-10-18','12:00:00',14220.50),(505,15,'5','2023-10-19','08:30:00','2023-10-19','03:15:00',-19299.25),(507,40,'13','2023-10-20','08:30:00','2023-10-20','03:30:00',-15000.00),(506,42,'5','2023-10-21','08:30:00','2023-10-21','05:00:00',-10157.50),(498,42,'5','2023-10-23','08:30:00','2023-10-23','11:30:00',12189.00),(509,44,'5','2023-10-25','10:54:00','2023-10-25','10:30:00',1625.20),(508,42,'13','2023-10-24','08:30:00','2023-10-24','10:30:00',6000.00),(492,15,'5','2023-10-30','10:20:00','2023-10-30','03:30:00',-20992.17),(490,42,'12','2023-10-18','08:30:00','2023-10-18','03:15:00',-14250.00),(301,42,'13','2023-10-23','08:30:00','2023-10-23','12:00:00',10500.00),(522,42,'13','2023-11-16','08:30:00','2023-11-16','12:00:00',10500.00),(520,42,'2','2023-11-14','02:30:00','2023-11-14','04:15:00',7110.25),(523,42,'13','2023-11-17','08:30:00','2023-11-17','05:00:00',-7500.00),(527,42,'13','2023-11-11','08:30:00','2023-11-11','12:30:00',12000.00),(519,42,'2','2023-11-16','02:30:00','2023-11-16','05:00:00',10157.50),(524,42,'2','2023-11-17','08:30:00','2023-11-17','03:30:00',-20315.00),(517,42,'13','2023-11-14','08:30:00','2023-11-14','05:30:00',-9000.00),(516,42,'13','2023-11-15','08:30:00','2023-11-15','10:30:00',6000.00),(515,42,'13','2023-11-08','08:30:00','2023-11-08','12:15:00',11250.00),(514,59,'2','2023-11-07','08:30:00','2023-11-07','05:30:00',-12189.00),(533,42,'13','2023-11-30','08:30:00','2023-11-30','04:45:00',-6750.00);
/*!40000 ALTER TABLE `tactividades` 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 ('0001','AC - DANO EN RED MATRIZ ACUEDUCTO'),('0002','AC - FUGA DOMICILIARIA ACUEDUCTO'),('0003','AC - ROBO DE MEDIDOR'),('0004','AC - MEDIDOR FRENADO'),('0005','AC - FUGA DE MEDIDOR'),('0006','AC - GEOFONO INTERNO'),('0007','AC - GEOFONO EXTERNO'),('0008','AC - INSTALACION DE HIDRANTE'),('0009','AC - MANTENIMIENTO HIDRANTE'),('0010','AC - RETIRO DE HIDRANTE'),('0011','AC - INSTALACION DE VALVULA'),('0012','AC - MANTENIMIENTO DE VALVULA'),('0013','AC - RETIRO DE VALVULA'),('0014','AC - RETIRO DE ESCOMBROS'),('0015','OT -RECUPERACION EN RECEBO ACUEDUCTO'),('0016','OT -RECUPERACION EN ASFALTO ACUEDUCTO'),('0017','OT -RECUPERACION EN CONCRETO ACUEDUCTO'),('0018','AC - DANO EN LLAVE DE PASO'),('0019','AC - INSTALACION DE TAPA VALVULA'),('0020','AL -SONDEO Y LIMPIEZA RED MATRIZ ALCANTA'),('0021','AL -DANO RED MATRIZ ALCANTARILLADO'),('0022','AL -LAVADO RED MATRIZ'),('0023','AL -LIMPIEZA Y SONDEO POZOS DE INSPECCIO'),('0024','AL -POZO COLAPSADO'),('0025','AL -CAJA DE INSPECCION DOMICILIARIA COLA'),('0026','AL -REPOSICION RED DOMICILIARIA'),('0027','AL -CONSTRUCCION POZO DE INSPECCION'),('0028','AL -RECONSTRUCCION POZO DE INSPECCION'),('0029','AL -INSTALACION REJILLA'),('0030','AL -INSTALACION TAPA POZO'),('0031','OT -REPOSICION VIA PAVIMENTO FLEXIBLE'),('0032','OT -REPOSICION VIAA PAVIMENTO RIGIDO'),('0033','AL -REALIZAR APIQUE'),('0034','AC - DANO RED MATRIZ 2\" ACUEDUCTO'),('0035','AC - DANO RED MATRIZ 3\" ACUEDUCTO'),('0036','AC - DANO RED MATRIZ 4\" ACUEDUCTO'),('0037','AC - DANO RED MATRIZ 6\" ACUEDUCTO'),('0038','AC - DANO RED MATRIZ 8\" ACUEDUCTO'),('0039','AC - DANO RED MATRIZ 10\" ACUEDUCTO'),('0040','AC - DANO RED MATRIZ 12\" ACUEDUCTO'),('0041','AC - DANO RED MATRIZ 14\" ACUEDUCTO'),('0042','AL -HUNDIMIENTO DE VIA ALCANTARILLADO'),('0043','AC - FUGA EN LA CALLE ACUEDUCTO'),('0044','AC - FRAUDE ACUEDUCTO'),('0045','AC - INSTALACION LLAVES DE PASO'),('0046','AC - REPOSICION DOMICILIARIA ACUEDUCTO'),('0047','AC - REVISION DE MEDIDOR'),('0048','AL -RECUPERACION EN RECEBO ALCANTARILLAD'),('0049','AC - EXCAVASION DE ACUEDUCTO'),('0050','AC - RECUPERACION DE ANDEN ACUEDUCTO'),('0051','AL -RED COLAPSADA'),('0052','AL -FUGA DOMICILIARIA ALCANTARILLADO'),('0053','AL -POZO REBOSADO'),('0054','AC - INSTALACION HIDRANTE INSP REDES'),('0055','AC - TOMA DE PRESION INSP. REDES'),('0056','AC - EMPALMES EN RED MATRIZ INSP. REDES'),('0057','AC - INSTALACION DE VENTOSAS INSP. REDES'),('0058','AC - INSTALACION DE VALVULAS INSP. REDES'),('0059','AC - INST. TUBERIA 2\" INSP. REDES'),('0060','AC - INST. TUBERIA 3\" INSP. REDES'),('0061','AC - INST. TUBERIA 4\" INSP. REDES'),('0062','AC - INST. TUBERIA 6\" INSP. REDES'),('0063','AL -DANO RED MATRIZ ALCANTARILLADO'),('0064','AL -POZO TAPADO'),('0065','AC - RECONEXION (Cartera)'),('0066','AC - FUGA POR CORTE DEL SERVICIO (Carter'),('0067','AL -BRIGADA LIMPIEZA RED PPAL ALCAN. DET'),('0068','AL -RECUPERACION EN RECEBO ALCANTARILLAD'),('0069','AL -RECUPERACION EN ASFALTO ALCANTARILLA'),('0070','OT -RECUPERACION EN CONCRETO'),('0071','AL -RECUPERACION DE ANDEN ALCANTARILLADO'),('0072','AC - INSTALACION DE MEDIDOR'),('0073','AC - LEVANTAMIENTO MEDIDOR'),('0074','AC - INSTALACION DOMICILIARIA'),('0075','AC - TAPONAMIENTO DOMICILIARIA'),('0076','AC - SONDEO DE RED PRINCIPAL'),('0077','AC - SONDEO DE RED MATRIZ  DE ACUEDUCTO'),('0078','AL -LIMPIEZA DE POZO'),('0079','AL -VISITA TECNICA ALCANTARILLADO'),('0080','AS -BRIGADAS MANUALES'),('0081','AL -INST.ARO TAPA TRAFICO PESADO'),('0082','AC - SIN SERVICIO ACUEDUCTO'),('0083','AL -TAPONAMIENTO DOMICILIARIA ALCANTARIL'),('0084','AC - INSTALACION CAJA DE ANDEN'),('0085','AL -ACOMETIDA NUEVA ALCANTARILLADO'),('0086','AC - FRAUDE CONTROL PERDIDAS'),('0087','AC - FUGA DE MEDIDOR CONTROL PERDIDAS'),('0088','AC - ACOMETIDA NUEVA ACUEDUCTO'),('0089','AC - LAVADO DE RED ACUEDUCTO'),('0090','AL -RETIRO ESCOMBROS ALCANTARILLADO'),('0091','AC - GEOFONO MARCADO'),('0092','AC - GEOFONO FUERA DE LA CIUDAD'),('0093','AC - REVISION TECNICA ACUEDUCTO'),('0094','AC - VISITA TECNICA ACUEDUCTO'),('0095','AC - PROFUNDIZACION ACOMETIDA ACUEDUCTO'),('0096','OT -INSTALACION PASACALLE'),('0097','AC - INSTALACION VENTOSA'),('0098','AC - CAMBIO DE ACOMETIDA ACUEDUCTO'),('0099','AC - RENIVELACION RECEBO ACUEDUCTO'),('0100','AC - INDEPENDIZACION DOMICILIARIA'),('0101','AC - DISPONIBILIDAD ACUEDUCTO Y ALCANTAR'),('0102','AC - RED ACUEDUCTO NUEVA'),('0103','AL -REPARACION RED DE ALCANTARILLADO'),('0104','AC - INSTALACION DE TUBO MADRE PARA ACUE'),('0105','AS -VISITA VERIFICACION DESHABITADO'),('0106','AS -FALLA EN LA PRESTACION DE SERVICIO A'),('0107','AS -REVISAR SI AL PREDIO T.EL SERVICIO A'),('0108','AC - CONEXION DE ACUEDUCTO'),('0112','AL -ROTURA TAPA POZO DE INSPECCION ALCAN'),('0116','AC - INSTALAR TAPA PARA REGISTRO DE ACUE'),('0119','AL -REVISION TECNICA DE ALCANTARILLADO'),('0120','AC - ARREGLO DE TUBO MADRE DE 3\" PVC'),('0122','AL -ARREGLO DE POZO DE INSPECCION DE ALC'),('0124','AC - REPOSICION DE MICROMEDIDOR'),('0123','AC - INSTALACION DE SISTEMA ACCUCTAB'),('0125','AC - VERIFICAR SERVICIO Y USO'),('0127','AL -MANTENIMIENTO DE ALCANTARILLADO'),('0109','AC - IDENTIFICACION FRAUDULENTOS'),('0126','AC - VIABILIDAD DE SERVICIOS'),('0128','OT -MANTENIMIENTO INFRAESTRUCTURA'),('0130','OT -MANTENIMIENTO INFRAESTRUCTURA PLANTA'),('2001','OT -ADECUACIONES LOCATIVAS'),('2002','OT -MANTENIMIENTO Y REPARACION'),('2003','OT -SUMINISTROS'),('2004','AL- FUNDIR TAPA EN CONCRETO'),('3001','AS -FALLA EN LA RECOLECCION DEL SERVICIO'),('3002','AS -FALLA EN LA RECOLECCION DEL BARRIDO'),('3003','AS -NO SE REALIZO SERVICIO DE RECOLECCIO'),('3004','AS -RECOLECCION DE PODAS Y ESCOMBROS'),('0110','AS - REALIZAR AFORO ASEO'),('0111','AC - RETIRAR ACOMETIDA'),('0129','AC - SUSPENSION DEL SERVICIO'),('3005','CAMBIO MEDIDOR'),('3006','ARREGLO DOMICILIARIO'),('3007','OTROS'),('0117','AC- DESTAPONAMIENTO RED DOMICILIARIA'),('0131','AC- MANTENIMIENTO SUMIDERAS'),('0118','AC- REVISION MANTENIMIENTO VALVULAS CIRC'),('3008','AC- REPARACIÓN RED PRINCIPAL 3\"'),('0113','AC- INSTALACION SISTEMAS ASPERSORES'),('3009','AC- -DISTRIBUCIÓN CARROTANQUE'),('2005','AC- PROYECCIÓN NUEVA RED'),('2006','OT- MANTENIMIENTO DE VEHÍCULOS'),('3010','PRESUPUESTAR TRABAJOS'),('3011','INSPECCIÓN A LA LINEA DE CONDUCCION'),('3012','AC- MUESTREO'),('3013','OT-RECEPCION Y CORDINACION'),('3014','DESMONTE DE ASPERSORES'),('3015','AC - MANTENIMIENTO DE VÁLVULAS'),('3016','ALC- INSTALACION TUBERIA SANITARIA'),('3017','AC- CAMBIO VALVULA DE PURGA'),('3018','AC- REVISION RED PRINCIPAL'),('3019','AC- REPARACION FUGA DE AGUA EN PURGA'),('3020','AC- RELLENO  CUBRIMIENTO');
/*!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 de Ciudadania'),('CE','Cedula de Extranjeria'),('NI','NIT');
/*!40000 ALTER TABLE `tidocu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipdis`
--

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

--
-- Dumping data for table `tipdis`
--

LOCK TABLES `tipdis` WRITE;
/*!40000 ALTER TABLE `tipdis` DISABLE KEYS */;
INSERT INTO `tipdis` (`td_tipdis`, `td_descri`) VALUES ('SO','SERVICIO ORDINARIO');
/*!40000 ALTER TABLE `tipdis` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tisalida`
--

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

--
-- Dumping data for table `tisalida`
--

LOCK TABLES `tisalida` WRITE;
/*!40000 ALTER TABLE `tisalida` DISABLE KEYS */;
INSERT INTO `tisalida` (`ts_tisalida`, `ts_descri`) VALUES ('PP','PROCESO DE POTABILIZACION'),('PQ','SOLUCION PQR'),('SG','SALIDA GENERAL'),('CS','CORTE Y SUSPENSIONES'),('AS','ASEO, RECOLECCION Y BARRIDO'),('FN','FONTANERO'),('AD','ADMINISTRACION'),('DT','DOTACION'),('AL','ALCANTARILLADO');
/*!40000 ALTER TABLE `tisalida` 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_numero` int(9) NOT NULL,
  `tm_codare` int(3) NOT NULL,
  `tm_tidano` char(4) 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(12) NOT NULL,
  `tm_celsol` char(30) 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_codbar` int(4) NOT NULL,
  `tm_origen` char(1) NOT NULL,
  `tm_tippqr` char(1) NOT NULL,
  `tm_numpqr` int(9) NOT NULL,
  `tm_nromat` int(10) NOT NULL,
  `tm_cobrar` char(1) NOT NULL,
  PRIMARY KEY (`tm_numero`),
  KEY `tm_tidano` (`tm_tidano`),
  KEY `tm_tidocu` (`tm_tidocu`),
  KEY `tm_codare` (`tm_codare`),
  KEY `tm_codbar` (`tm_codbar`)
) 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_numero`, `tm_codare`, `tm_tidano`, `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_codbar`, `tm_origen`, `tm_tippqr`, `tm_numpqr`, `tm_nromat`, `tm_cobrar`) VALUES (1,1,'0094','2022-01-24','10:50:31','CC','39016357','ELVIRA TORRES PORTILLO','4292316','','K 2 C 9 ESQ EL CENTRO','V','C','1','2022-02-09','10:19:13',12,'P','R',1,205,'N'),(2,1,'0125','2022-01-24','02:14:56','CC','39006162','Leonilde Cáceres','3118007829','','C 3 N 7-26 LA ALMIRANTE PADILLA','E','C','1','2022-01-26','08:16:26',21,'P','R',2,3502,'N'),(3,1,'0094','2022-01-24','02:48:14','CC','1004095176','Yelitza Sáenz villareal','3107467639','','C 1 N 12-58 SANTANDER','V','C','1','2022-02-02','11:50:58',41,'P','R',3,2330,'N'),(4,1,'0094','2022-01-24','03:05:46','CC','39017078','Laura casado','3106172024','','K 5 N 3-19 SAN FRANCISCO','V','C','1','2022-02-21','08:39:30',36,'P','R',4,9426,'N'),(5,1,'0094','2022-01-24','03:22:23','CC','85433774','Edgar paz','3104733527','','C 7  #  17-54','V','C','1','2022-02-02','11:55:21',16,'P','R',5,8944,'N'),(6,1,'0094','2022-01-24','03:42:08','CC','73591098','pablo tafur','3004002275','','K 10 N 4-18 SAN FRANCISCO','V','C','1','2022-02-07','08:20:59',36,'P','R',6,391,'N'),(7,1,'0094','2022-01-24','04:07:29','CC','39020440','Yesica Bolaños','3205692215','','C 6 N 4-55 CHAPINERO','V','C','1','2022-02-02','09:47:06',7,'P','R',7,3861,'N'),(8,1,'0094','2022-01-24','04:38:03','CC','12584692','Nilton Ramos','3135991790','','C 1A N 11-27 SANTANDER','V','C','1','2022-02-02','11:46:56',41,'P','R',8,3521,'N'),(9,1,'0094','2022-01-25','08:39:05','CC','39010165','Angelica Alvarado Rodríguez','3148912815','','KRA 20 # 9B-10','E','C','1','2022-02-07','11:43:42',35,'P','R',9,11566,'N'),(10,1,'0094','2022-01-25','09:57:12','CC','','Magali Vásquez viadero','3135757445','','K 11 N 2A-2 SANTANDER','E','C','1','2022-01-26','10:14:26',41,'P','R',11,4718,'N'),(11,1,'0094','2022-01-25','10:27:04','CC','22241426','Viviana Galezo Raad','3114292444','','C 2A # 11-6 SANTANDER','E','C','1','2022-02-07','08:45:21',41,'P','R',12,3335,'N'),(12,1,'0094','2022-01-25','10:47:02','CC','','Immer Martínez','3226692002','','C  10A-  #  19-28 OTRO','E','C','1','2022-02-21','08:34:27',35,'P','R',13,6792,'N'),(13,2,'0127','2022-01-25','04:01:06','CC','85438130','Luis Albertos Valdés Palacio','3042087919','','K13 N 3-126 LA PLEGARIA','E','C','1','2022-02-02','08:42:17',24,'P','R',14,5917,'N'),(14,2,'0127','2022-01-25','04:01:06','CC','85438130','Luis Albertos Valdés Palacio','3042087919','','K13 N 3-126 LA PLEGARIA','E','C','1','2022-02-07','09:56:46',24,'P','R',14,5917,'N'),(15,1,'0125','2022-01-26','08:53:47','CC','85438471','Geovany de Jesús Villalobos Hernández','3217074067','','K 8 C 2A Y SAN FRANCISCO','E','C','1','2022-01-31','12:17:29',36,'P','R',15,5784,'N'),(16,2,'0053','2022-01-26','10:20:05','CC','39010709','Liliana de Bayter L','3116677317','','C 4 N 12-09 LA PLEGARIA','E','C','1','2022-02-02','09:02:18',24,'P','Q',2,3578,'N'),(17,1,'0094','2022-01-26','11:09:42','CC','12583803','julio naycir','3115445644','','K 3 13-09 EL PROGRESO','E','C','1','2022-02-11','09:48:52',15,'P','R',16,5292,'N'),(18,1,'0094','2022-01-26','11:35:01','CC','5424456','Gilverto Ojeda Lobo','3134580684','','C 10 N 4-66','E','C','1','2022-02-02','09:31:22',15,'P','R',17,2459,'N'),(19,1,'0094','2022-01-27','09:12:35','CC','39010402','MARTA OSPINO','3205966796','','C 1A N 11-27 SANTANDER','V','C','1','2022-02-21','10:06:30',41,'P','R',18,3158,'N'),(20,1,'0094','2022-01-27','09:56:06','CC','1140885938','ANDRES FUENTES','3126606097','','KRA24#4B-32','T','C','1','2022-03-02','10:15:55',22,'P','R',19,11491,'N'),(21,1,'0094','2022-01-27','10:11:12','CC','26729239','OLIVIA GARCIA','3126003763','','KRA 13 # 17-90','V','C','1','2022-02-16','10:58:45',38,'P','R',20,10567,'N'),(22,1,'0094','2022-01-27','10:47:03','CC','12578418','Héctor julio Campuzano cárdenas','3145341016','','C 7 N 9-106 SAN FRANCISCO','E','C','1','2022-03-01','11:16:16',36,'P','R',21,4057,'N'),(23,1,'0094','2022-01-27','02:42:41','CC','13822171','Darío Villareal','3043832057','','C 8 N 2-115 EL CENTRO','E','C','1','2022-03-08','02:38:40',12,'P','R',23,4110,'N'),(24,1,'0094','2022-01-27','04:30:25','CC','','Yenibeth Villafañe','3008121183','','CARRERA 7 # 16-65','E','C','1','2022-01-31','12:03:27',1,'P','R',24,10590,'N'),(25,1,'0094','2022-01-27','05:11:45','CC','93.008.204','Marina Barbudo','3126895823','','C 2 N 13A-3 SANTANDER','E','C','1','2022-02-02','11:14:21',41,'P','R',25,3247,'N'),(26,1,'0094','2022-01-28','08:46:18','CC','1079657808','Jose Jaraba','3154662522','','C 7  #  19-07 PUEBLO NUEVO','E','C','1','2022-03-17','03:31:43',35,'P','R',26,9404,'N'),(27,1,'0094','2022-01-28','10:42:04','CC','77.159.172','Manuel torres Arroyo','3197123492','','Cra 17 # 16C-24','E','C','1','2022-02-16','11:13:19',44,'P','R',28,11123,'N'),(28,1,'0094','2022-01-28','10:43:37','CC','39018755','Ana rincón','3106945631','','C.16 CRAS. 10 DE JULIO','E','C','1','2022-02-16','09:12:35',1,'P','R',27,4382,'N'),(29,1,'0094','2022-01-28','03:00:10','CC','26743625','Diocelina  pañuela de Tamayo','','','C 5 N 6-89 CHAPINERO','E','C','1','2022-02-07','09:16:48',7,'P','R',29,3768,'N'),(30,1,'0094','2022-01-28','04:24:53','CC','','Rafaela Menco','3204481741','','K 3 C 18 2 DE FEBRERO','E','C','1','2022-02-02','11:31:50',3,'P','R',31,5296,'N'),(31,1,'0094','2022-01-28','04:32:06','CC','','Rafaela Menco','3204481741','','K 3 C 18 2 DE FEBRERO','E','C','1','2022-02-02','11:30:23',3,'P','R',30,5296,'N'),(32,1,'0094','2022-01-28','04:54:35','CC','1216967235','Luis Miguel Zorro Galvan','3155183181','','C 2A N 7-107 LA ALMIRANTE PADILLA','E','C','1','2022-02-18','10:09:31',21,'P','R',32,3384,'N'),(33,1,'0094','2022-01-31','08:49:47','CC','1.004.499571','Zulay Méndez Villafañe','3202292276','','C 1A N 10-0 EL BANQUITO','E','C','1','2022-02-16','10:27:03',9,'P','R',10,401,'N'),(34,1,'0094','2022-01-31','09:45:50','CC','85443101','Willington Martínez','3204308271','','calle 2 # 6-142','E','C','1','2022-02-14','10:30:15',21,'P','P',2,0,'N'),(35,1,'0094','2022-01-31','10:21:18','CC','85436705','Raumir Moreno Rios','3116627990','','K 18A N 9-45/B. LAS FERIAS OTRO','E','C','1','2022-03-02','10:25:08',20,'P','R',33,10275,'N'),(36,1,'0094','2022-01-31','10:46:45','CC','39021858','Francinelda Cardeño Mansera','3103648973-3','','K 1B N 16-0 LA PLAYA','E','C','1','2022-03-01','03:57:29',23,'P','R',34,4942,'N'),(37,1,'0079','2022-01-31','11:45:10','CC','39010709','Liliana de Bayter L','3116677317','','C 4 N 12-09 LA PLEGARIA','E','C','1','2022-03-11','09:05:24',24,'P','Q',2,3578,'N'),(38,1,'0094','2022-01-31','02:58:26','CC','39010566','Mireya Ruiz Cortes','3135243175','','K 2A N 16-77 LA CANDELARIA','V','C','1','2022-02-14','12:01:33',17,'P','R',35,7636,'N'),(39,2,'0127','2022-01-31','04:41:41','CC','28059880','karolayn Jaimes','3043535398','','kra 8 #3-44','E','C','1','2022-02-14','11:23:18',21,'P','Q',4,0,'N'),(40,1,'0094','2022-01-31','05:05:22','CC','','Angelica Risciotti Rico','3215113069','','C 7 N 16-44 LAS MARIAS','E','C','1','2022-02-16','10:49:11',28,'P','R',36,3933,'N'),(41,1,'0094','2022-02-01','11:40:15','CC','91515540','David Molina','3022659896','','K 4 N 11-21 EL PROGRESO','E','C','1','2022-03-08','09:09:42',15,'P','R',37,5393,'N'),(42,1,'0094','2022-02-01','04:41:27','CC','40796166','Maritza Rodríguez','3204005363','','K 2B N 16-51 LA CANDELARIA','E','C','1','2022-03-07','11:33:44',17,'P','R',38,5280,'N'),(43,1,'0093','2022-02-02','10:46:02','CC','39747848','Sinforosa Esther Serpa Baldovino','3205171300','','calle 12#8-53','E','C','1','2022-02-16','09:37:33',29,'P','R',39,476,'N'),(44,1,'0094','2022-02-02','04:28:46','CC','','Luis José Gutiérrez Bolaños','3134049135','','K 5 N 6-05 CHAPINERO 2 PISO','E','C','1','2022-02-28','02:29:50',7,'P','R',40,10301,''),(45,2,'0119','2022-02-03','09:23:43','CC','1036639706','Katherine Monsalve','3104672194','','calle 6a # con kra 22d -18','E','C','1','2022-03-01','09:58:00',22,'P','Q',6,0,''),(46,2,'0079','2022-02-03','10:02:53','CC','','Inés de veras','3012063188','','calle 13 kra 22','E','C','1','2022-02-16','10:27:06',35,'P','Q',8,0,'N'),(47,2,'0079','2022-02-03','10:22:06','CC','','José  Leandro Fonseca maure','3206953575','','kra 24a #8-37','E','C','1','2022-03-09','09:42:32',22,'P','Q',10,0,'N'),(48,2,'0079','2022-02-03','10:33:15','CC','39009701','Ana Josefa Saltaren Hernández','3145421778','','K 10 N 3-84 SAN FRANCISCO','E','C','1','2022-03-08','07:32:47',36,'P','Q',12,4690,'N'),(49,2,'0079','2022-02-03','10:49:47','CC','12579797','José francisco vegas días','3218993432','','calle 18','E','C','1','2022-03-09','09:07:04',17,'P','Q',14,0,'N'),(50,2,'0079','2022-02-03','11:20:02','CC','','Jon Édison Lizarazo Carreño','3107274959','','kra 23 calle 9','E','C','1','2022-03-08','11:44:25',43,'P','Q',15,0,'N'),(51,1,'0094','2022-02-03','11:58:04','CC','1082933021','Lorena Paola Díaz mármol','3504921736','','C 3 #  17-49 OTRO','V','C','1','2022-03-03','02:41:52',16,'P','R',41,8948,'N'),(52,1,'0094','2022-02-03','02:28:18','CC','1082933021','Lorena Paola Díaz mármol','3504921736','','C 3 #  17-49 OTRO','V','C','1','2022-03-11','09:11:27',16,'P','R',41,8948,'N'),(53,2,'0079','2022-02-03','04:00:03','CC','17124746','Romulo Cesar Delgado Calvo','3108487935','','calle 4 # 7 la casona','E','C','1','2022-02-16','09:34:04',36,'P','Q',18,0,'N'),(54,2,'0079','2022-02-07','08:26:29','CC','','Alex palomino Ojeda','3185890892','','calle 4 # 11-02','E','C','1','2022-02-16','10:02:43',24,'P','Q',20,0,'N'),(55,1,'0094','2022-02-07','09:03:26','CC','1085096074','Marlon de león','3002339368','','calle 7# 16-05','E','C','1','2022-02-28','02:39:24',39,'P','P',3,0,'N'),(56,1,'0093','2022-02-07','10:56:58','CC','','maría  moreno','3002494374','','C 9 # 19A-07 OTRO','V','C','1','2022-02-16','11:25:19',35,'P','R',42,9432,'N'),(57,2,'0079','2022-02-07','11:10:48','CC','1237508','Anderson de Jesús Abad Díaz','3186273400','','calle 10 kra 16a','E','C','1','2022-03-08','03:10:12',28,'P','Q',21,0,'N'),(58,1,'0094','2022-02-07','11:19:11','CC','26743005','Estela luqueta  López','3126212878','','K 17  #  3-25 OTRO','V','C','1','2022-02-11','10:16:47',16,'P','R',43,9693,'N'),(59,1,'0094','2022-02-07','11:45:26','CC','','Nilda Esther Sánchez Lopez','3215534233','','C 11 N 9-75 SANTA ROSA','E','C','1','2022-03-28','10:21:06',40,'P','R',44,2546,'N'),(60,2,'0079','2022-02-08','09:06:20','CC','39015669','Claritza Paternina','3205214455','','kra 4 entre  c 16 y 17','E','C','1','2022-02-14','10:57:02',3,'P','Q',22,0,'N'),(61,1,'0094','2022-02-09','08:53:29','CC','','Ilma  España Hernández','3126706909','','K 6 N 1-11 LA ALMIRANTE PADILLA','E','C','1','2022-02-21','10:58:34',21,'P','P',4,5593,'N'),(62,1,'0094','2022-02-13','07:18:48','CC','85436098','Julio Cesar Moreno león','3059175466','','calle 4 # 8 -53','E','C','1','2022-03-01','04:48:46',36,'P','P',5,0,'N'),(63,1,'0093','2022-02-14','11:17:48','CC','39005140','Vicenta j Pedrozo de Villanueva','3008284778','','Calle 8 kra 9 - 40','V','C','1','2022-02-28','10:22:18',10,'P','P',6,0,''),(64,1,'0094','2022-02-15','09:55:03','CC','84036878','José Guerra','3167590140','','calle 7# 11_07','V','C','1','2022-03-02','04:47:19',10,'P','P',7,0,'N'),(65,2,'0079','2022-02-16','09:43:26','CC','28059880','karolayn Jaimes','3043535398','','kra 8 #3-44','E','C','1','2022-02-16','09:57:29',21,'P','Q',3,0,'N'),(66,1,'0094','2022-02-16','02:30:18','CC','12581111','Cástulo  Pérez','3226523088','','CALLE 9#2-62 EL CENTRO','V','C','1','2022-03-01','08:47:36',12,'P','R',45,4274,''),(67,1,'0094','2022-02-17','10:49:46','CC','','Rufino Ulloque','3216109995','','C 13 K 1 LA PLAYA','V','C','1','2022-03-09','08:36:09',23,'P','R',46,10194,'N'),(68,1,'0094','2022-02-17','11:35:00','CC','85440592','Babyngton  Mieles','3114254310','','kra 9 # 1a -02','V','C','1','2022-03-01','10:52:07',13,'P','R',47,0,''),(69,2,'0079','2022-02-17','03:44:57','CC','1173150642','Francisco Camargo','3103644229','','kra 2 #10-22','V','C','1','2022-03-09','09:31:29',12,'P','Q',23,6267,'N'),(70,2,'0079','2022-02-17','04:46:07','CC','1085042293','Ricardo barrios Pérez','3137601637','','K 7 N 2A-24 LA ALMIRANTE PADILLA','V','C','1','2022-03-03','09:01:56',21,'P','Q',24,5730,'N'),(71,2,'0079','2022-02-18','09:01:09','CC','39014317','Otilia Molina Pedrezo','3023596946','','calle 17  #7a-03','E','C','1','2022-03-08','07:12:57',1,'P','P',9,0,'N'),(72,2,'0079','2022-02-18','10:45:55','CC','39014119','Ana María Carrasquilla Cárdenas','3016977392','','calle 6 kra 3','V','C','1','2022-03-08','03:16:09',12,'P','Q',25,0,'N'),(73,2,'0079','2022-02-21','08:54:24','CC','','Jaime Campo','3142060007','','calle 2# 12-96','V','C','1','2022-02-28','11:28:34',41,'P','Q',27,0,''),(74,1,'0094','2022-02-21','10:44:02','CC','22991605','Flor María Muñoz','','','C 1A K 9 ES EL BANQUITO','V','C','1','2022-03-02','10:29:01',9,'P','R',49,3141,'N'),(75,1,'0093','2022-02-21','11:12:40','CC','','Ruth Sánchez Rojo','','','K 19  #  9A-67 OTRO','V','C','1','2022-03-07','09:15:25',35,'P','R',50,7048,'N'),(76,1,'0093','2022-02-21','11:36:17','CC','39007008','Alicia Rodríguez Lascarro','3153323919','','Kra 12 #2-10','V','C','1','2022-03-04','08:31:26',41,'P','P',10,0,'N'),(77,1,'0094','2022-02-22','09:25:43','CC','85271784','José Luis Velásquez','3116560167','','K 14 20 DE ENERO','V','C','1','2022-03-11','09:20:52',4,'P','R',51,4863,'N'),(78,1,'0094','2022-02-22','09:44:11','CC','85435654','Martin Sánchez','3107163923','','C 8 #  19-26 OTRO','V','C','1','2022-03-03','02:36:41',35,'P','R',52,8879,'N'),(79,1,'0094','2022-02-22','10:28:03','CC','39006002','Policarpa Torres','3162124044','','C 2A N 10-7 EL BANQUITO','V','C','1','2022-03-03','09:20:32',9,'P','R',53,3353,'N'),(80,1,'0093','2022-02-22','10:43:23','CC','85439506','Javier Cudris H','3126479945','','K  19   #   11-19 OTRO','V','C','1','2022-03-18','02:43:46',35,'P','R',54,8434,'N'),(81,2,'0094','2022-02-22','11:33:50','CC','','Jorge Luis Herrera','3222515349','','kra 4 # 15-83','V','C','1','2022-03-03','11:28:28',3,'P','Q',29,0,'N'),(82,1,'0093','2022-02-22','03:08:51','CC','','Francisco Gutiérrez','3232453258','','K 19  #  9-43 OTRO','V','C','1','2022-03-03','09:35:36',35,'P','R',55,7345,'N'),(83,2,'0079','2022-02-23','09:27:22','CC','39014317','Otilia Molina Pedroso','3023596946','','calle 17  #7a-03','E','C','1','2022-03-11','09:36:48',1,'P','P',11,0,'N'),(84,2,'0079','2022-02-23','10:08:03','CC','','Wilfrido Cogollo B','32155016611','','cll 15 #8-81','V','C','1','2022-03-02','03:16:27',28,'P','Q',31,0,'N'),(85,2,'0079','2022-02-23','10:17:30','CC','','Marlene Hernández Mora','3116517513','','kra 10 #10-73','V','C','1','2022-03-02','03:39:20',28,'P','Q',33,0,'N'),(86,2,'0079','2022-02-23','10:32:15','CC','','Gonzalo Tamayo Ospino','3114142106','','C 4 N 5-54 CHAPINERO','V','C','1','2022-03-08','07:43:53',7,'P','Q',35,3626,'N'),(87,1,'0094','2022-02-23','11:00:01','CC','','Pedro Granado','3145832983','','cll 3 # 8-56 y 28','V','C','1','2022-03-01','11:49:41',36,'P','R',56,0,'N'),(88,1,'0094','2022-02-23','11:02:12','CC','','Pedro Granado','3145832983','','cll 3 # 8-56 y 28','V','C','1','2022-03-01','02:31:01',36,'P','R',56,0,'N'),(89,1,'0094','2022-02-23','11:27:55','CC','','Angela María Sánchez Torrez','3135266603','','K 21  # 11-48 OTRO','V','C','1','2022-03-11','09:51:01',35,'P','R',57,7607,'N'),(90,1,'0094','2022-02-23','11:49:03','CC','85433969','Martin Garcés Acuña','3112069701','','C 8 #19A-03 OTRO','V','C','1','2022-03-03','10:16:25',8,'P','P',12,7929,'N'),(91,1,'0094','2022-02-23','02:55:12','CC','12584283','Jaide  Enrique Rangel Laguna','3106927167','','K 19A N 9-45/B. PUEBLO NUEVO OTRO','E','C','1','2022-03-11','09:57:25',35,'P','R',58,10011,'N'),(92,2,'0079','2022-02-23','04:37:45','CC','39015476','Gala l Flórez','3145276454','','cll 10 # 19 -40','V','C','1','2022-03-01','08:20:14',35,'P','Q',36,0,''),(93,1,'0094','2022-02-23','04:51:40','CC','','Gloria María Diaz','3145370946','','K 14A N 3-102 APTO 01/B. 20 DE ENERO','V','C','1','2022-04-11','02:31:32',4,'P','R',59,10185,'N'),(94,2,'0079','2022-02-24','09:05:32','CC','','Samir Pedrozo','3017485763','','cll 15 # 7 -14','V','C','1','2022-03-08','07:54:17',34,'P','Q',39,0,'N'),(95,1,'0094','2022-02-24','09:29:28','CC','','Martin Campo Moreno','3145100243','','C 8A   #  20-33 OTRO','V','C','1','2022-03-03','09:24:56',8,'P','R',60,8696,'N'),(96,2,'0117','2022-02-24','10:40:26','CC','800106050-7','ESP','3127316691','','CLL 9-# 13','V','C','1','2022-03-04','08:53:56',14,'P','Q',37,0,'N'),(97,1,'0094','2022-02-24','11:36:54','CC','39018907','Deleinis Rojas','3215139518','','K 14 N 3 - 20 DE ENERO','V','C','1','2022-04-11','09:17:14',4,'P','R',61,1263,'N'),(98,1,'0094','2022-02-24','02:46:33','CC','','Sandra Molina  Garcia','3107186512','','C 12 #  20-10 OTRO','V','C','1','2022-03-03','09:40:50',8,'P','R',62,8878,'N'),(99,1,'3019','2022-03-01','04:27:40','NI','800106050-7','ESP','3117316691','','calle 2 # 6-50','V','C','1','2022-06-09','03:45:38',36,'P','Q',0,0,'N'),(100,2,'0079','2022-03-02','11:16:35','CC','85441256','EGIDIO RAMIREZ OSPINO','','','calle 1 kra 9 # 63','E','C','1','2022-03-18','04:17:32',13,'P','Q',41,0,'N'),(101,1,'0094','2022-03-03','08:43:13','CC','','yuleidis herrera','3008030345','','C 5 N 5-47 CHAPINERO','V','C','1','2022-03-11','09:44:31',7,'P','R',63,97,'N'),(102,1,'0094','2022-03-03','08:56:52','CC','','gloria Elizabeth Mier Yánez','3114063150','','C 2A N 7-107 LA ALMIRANTE PADILLA','V','C','1','2022-03-08','08:57:40',21,'P','R',64,3384,'N'),(103,1,'0094','2022-03-03','09:04:16','CC','','Carmelo Martínez','3135120888','','C 1 N 12-49 SANTANDER','V','C','1','2022-03-08','08:54:15',41,'P','R',66,2328,'N'),(104,1,'0094','2022-03-03','09:27:18','CC','','gloria maría cala','3135732130','','C 7 CO# KRA 1 CLUB DE LEONES','V','C','1','2022-03-08','09:00:27',8,'P','R',67,8824,'N'),(105,2,'0079','2022-03-03','10:08:22','CC','','José Humberto delgado Sánchez','3136304972','','calle 25 # 8B -24','V','C','1','2022-04-29','09:45:13',11,'P','P',14,0,'N'),(106,1,'0094','2022-03-03','10:14:51','CC','12401312','James Martínez','','','K 5 N 6-25 CHAPINERO','V','C','1','2022-03-08','09:16:01',7,'P','R',68,5556,'N'),(107,1,'0094','2022-03-03','10:22:36','CC','','Lorenzo Arregocés','3205828530','','CLL 11 # 20-76','V','C','1','2022-03-08','09:18:42',35,'P','R',69,11546,'N'),(108,1,'0043','2022-03-07','10:50:53','CC','','Nerelis R','3206625841','','calle 13 con kra 11','V','C','1','2022-05-26','08:57:05',18,'P','R',70,0,'N'),(109,1,'0094','2022-03-08','10:18:01','CC','12401231','Eder  Martinez','3163980044','','CL 3 # 5-53 CHAPINERO','E','C','1','2022-03-10','03:59:47',7,'P','R',71,3480,'N'),(110,1,'0094','2022-03-08','10:29:47','CC','','Nilda  Noriega','3145528009','','C 7A # 15-31 OTRO','V','C','1','2022-03-11','10:02:06',37,'P','R',72,9419,'N'),(111,1,'0043','2022-03-08','02:43:13','CC','','Mary Laura Lizcano','3113259185','','kra 9 # 10 -13','V','C','1','2022-05-26','09:13:29',40,'P','R',73,0,'N'),(112,1,'0094','2022-03-08','02:56:27','CC','','Irina sierra','3138961254','','C 9 # 20-21 OTRO','V','A','','0000-00-00','00:00:00',35,'P','R',74,6844,''),(113,1,'0094','2022-03-08','03:07:55','CC','','Irina sierra','3138961254','','C 9 # 20-21 OTRO','V','C','1','2022-03-17','03:23:34',35,'P','R',74,6844,'N'),(114,1,'0094','2022-03-08','03:20:57','CC','','angelina pisciotti rico','3215113069','','calle 11 # 16-44','V','C','1','2022-03-17','11:06:10',16,'P','Q',42,0,'N'),(115,1,'0093','2022-03-09','10:27:20','CC','39014945','ovadys jimenez','3166025706','','K 8 N 2A-18 LA ALMIRANTE PADILLA','V','C','1','2022-03-11','10:24:05',21,'P','R',75,5810,'N'),(116,1,'0093','2022-03-09','10:51:54','CC','','yerlis rodríguez barrios','3114118515','','C.9 N.13-31 EL HUERTO','V','C','1','2022-03-14','03:10:32',14,'P','R',76,8469,'N'),(117,1,'0094','2022-03-10','10:14:54','CC','1079657808','Jose Jaraba','3154662522','','C 7  #  19-07 PUEBLO NUEVO','V','C','1','2022-03-30','04:05:39',35,'P','R',26,9404,'N'),(118,1,'0094','2022-03-11','10:52:39','CC','','Luis Rafael Martínez Raad','3028448244','','C 1 N 10-14 RIO CESAR','V','C','1','2022-03-15','11:04:39',13,'P','R',77,2296,'N'),(119,1,'0094','2022-03-11','10:58:24','CC','39017149','Leída p Méneses R','3116487925','','C 9 N 2-71 EL CENTRO','E','C','1','2022-03-18','11:28:48',12,'P','R',78,207,'N'),(120,1,'0079','2022-03-11','11:07:14','CC','','Ema Liliana torrez','3506907310','','calle 3a cerca al mercadito de Sandra','T','C','1','2022-03-25','08:54:10',32,'P','Q',43,0,'N'),(121,1,'0094','2022-03-14','10:30:33','CC','12822171','Darío Villareal Macías','3043832057','','kra 3 # 8-18','V','C','1','2022-03-25','09:08:22',12,'P','Q',44,0,'N'),(122,1,'0094','2022-03-14','11:26:23','CC','','Carlos Campos','3107841040','','calle 7 # 15-75','V','C','1','2022-03-22','09:38:48',37,'P','R',79,0,'N'),(123,1,'0079','2022-03-15','08:54:25','CC','','Oscar E Álvarez Ariza','3136601104','','kra 2 calle 8 gomeza','E','C','1','2022-03-25','09:18:09',12,'P','Q',46,0,'N'),(124,1,'0094','2022-03-15','10:33:14','CC','','Erismar Arcillas','3006517717','','C 9 N 4-09 LAS DELICIAS','V','C','1','2022-03-17','10:24:22',27,'P','R',80,210,'N'),(125,2,'0079','2022-03-17','09:53:34','CC','','Ilia zarquis de lisa','3205663858','','calle 6 kra 3 # 6','V','C','1','2022-03-29','08:52:50',12,'P','Q',48,0,'N'),(126,1,'0094','2022-03-18','11:05:27','CC','','edilson Villareal','','','CRA20   #   9C-10 OTRO','V','C','1','2022-03-31','08:40:36',35,'P','R',81,8628,'N'),(127,1,'0094','2022-03-24','09:44:57','CC','','María Mejía Jaraba','3014826039','','C 1A N 9-60 EL BANQUITO','V','C','1','2022-04-01','10:30:31',9,'P','R',82,3198,'N'),(128,1,'0079','2022-03-25','08:32:26','CC','','Wilson turizo gil','3143029792','','calle 16 con  kra 4 y calle 15 con kra 3','V','C','1','2022-04-07','08:45:51',3,'P','Q',49,0,'N'),(129,1,'0079','2022-03-25','10:36:22','CC','','Celso castaños lissa','','','calle 2a entre kra 11 y10','V','C','1','2022-03-30','08:56:17',9,'P','Q',50,0,'N'),(130,1,'0094','2022-03-28','09:01:55','CC','85435260','Joni muñoz pensó','3154935342','','C 4 N 11-44 LA PLEGARIA','V','C','1','2022-04-06','09:02:25',24,'P','R',83,3573,'N'),(131,2,'0079','2022-03-28','09:04:03','CC','','Víctor Javier Velázquez Fonseca','3126031885','','calle 6 # 2a -30','V','C','1','2022-03-29','03:23:53',12,'P','Q',51,0,'N'),(132,1,'0094','2022-03-28','09:11:54','CC','26747375','Edith Toloza Flórez','3103634661','','K 11 N 7-17 EL CANAL','V','C','1','2022-03-30','10:54:47',10,'P','R',84,4741,'N'),(133,1,'0094','2022-03-28','02:26:37','CC','','José sarquis Ricaute','3116616417','','C 5 N 11-22 LA PLEGARIA','V','C','1','2022-04-01','09:51:22',24,'P','R',85,3686,'N'),(134,2,'0079','2022-03-29','10:08:41','CC','','Yamil  Bayter','3135757445','','K 11 N 2A-2 SANTANDER','V','C','1','2022-04-08','11:31:26',41,'P','Q',53,4718,'N'),(135,1,'0094','2022-03-29','03:19:46','CC','','Eloy castro','3223973405','','CALLE 9 # 20b-80','V','C','1','2022-04-04','09:47:12',8,'P','R',86,11581,'N'),(136,1,'0094','2022-03-30','08:45:01','CC','','Manuel Cervera','3226057131','','CALLE 9 # 21-31','V','C','1','2022-04-05','09:28:03',35,'P','R',87,11573,'N'),(137,2,'0119','2022-03-30','09:54:10','CC','','Nancy Londoño Sereno','3135044410','','Kra 5 #13  colegio Luis López de meza','V','C','1','2022-04-08','08:59:51',15,'P','Q',55,0,'N'),(138,2,'0119','2022-03-30','10:10:45','CC','','Nancy Londoño Sereno','3135044410','','kra 18 #7-50 Arcecio  cáliz','E','C','1','2022-05-18','09:35:01',39,'P','Q',57,0,'N'),(139,1,'0094','2022-03-30','10:34:12','CC','','Edilberto castillejo C','3003995716','','CLL12 #20-14','V','C','1','2022-04-04','09:53:21',35,'P','R',88,11289,'N'),(140,1,'0094','2022-03-30','11:05:53','CC','','Dalio Salcedo','3126386976','','CALLE 10 BIS  #20-36','V','C','1','2022-04-05','09:19:20',35,'P','R',89,8747,'N'),(141,1,'0094','2022-03-30','11:15:03','CC','','Arelis Rios','3223085394','','CALLE 9 # 21-45','V','C','1','2022-05-12','11:26:43',35,'P','R',90,11571,'N'),(142,1,'0094','2022-03-31','08:54:50','CC','','Evaristo Sánchez R','3214404457','','Cll 4 #12-49','V','C','1','2022-05-13','10:58:51',24,'P','R',91,0,'N'),(143,1,'0093','2022-03-31','09:11:18','CC','','America Cantillo','3015101903','','cll 2a #5-31','V','C','1','2022-05-13','11:17:54',21,'P','R',92,0,'N'),(144,1,'0094','2022-03-31','11:37:58','CC','','Nicolasa Salazar / luz mari','3023227812','','C 9 # 20A-23 CLUB DE LEONES','V','C','1','2022-04-06','02:33:19',8,'P','R',93,6834,'N'),(145,1,'0094','2022-03-31','04:36:47','CC','','Yolanda Fernández','3008224131','','K  19B   #   9A-75 OTRO APART 1','V','C','1','2022-04-06','02:48:00',35,'P','R',94,8723,'N'),(146,1,'0043','2022-04-05','09:37:38','CC','','Justiniano España','3104586138','','calle 16 kra 8','V','C','1','2022-05-13','10:32:30',1,'P','P',15,0,'N'),(147,1,'0094','2022-04-05','02:34:52','CC','85441595','Fabio Sánchez López','3112451754','','CLL12 #20-65','V','C','1','2022-05-05','10:49:24',35,'P','R',95,11293,'N'),(148,1,'0094','2022-04-11','08:32:54','CC','','Gladys Rangel','3148551904','','K 1A N 16-0 LA CANDELARIA','V','C','1','2022-05-03','03:23:23',17,'P','R',96,4922,'N'),(149,1,'0094','2022-04-11','09:09:03','CC','','Isabel Benitez','3116590791','','C 1 BARRIO 12 DE OCTUBRE','V','C','1','2022-04-29','02:24:18',2,'P','R',97,2281,'N'),(150,1,'0094','2022-04-11','09:16:46','CC','','Juvenal Chaverna','3104374174','','calle 10 # 21-2','V','C','1','2022-04-25','08:39:26',35,'P','R',98,0,'N'),(151,1,'0093','2022-04-11','10:04:53','CC','','Olga García Acuña','3125863761','','calle 11 con kra 9 esquina','V','C','1','2022-05-26','11:15:36',40,'P','R',99,0,'N'),(152,1,'0119','2022-04-13','08:32:22','CC','','Cenaida Paternina P','3135936909','','calle 7#16-79','V','C','1','2022-04-29','09:53:15',39,'P','Q',58,0,'N'),(153,2,'0119','2022-04-18','10:39:36','CC','','Eloy fontalvo','3126511039','','Calle 9a # 18-03','V','C','1','2022-04-20','08:59:33',20,'P','Q',59,0,'N'),(154,1,'0094','2022-04-18','10:53:16','CC','','griceldina cardena','3135174475','','KRA22#7-57','V','C','1','2022-05-02','04:53:22',8,'P','R',100,11434,'N'),(155,1,'0094','2022-04-18','03:13:59','CC','','tomas puerta b','3233736589','','KRA 18B # 9A-35','V','C','1','2022-05-02','05:00:04',20,'P','R',101,11560,'N'),(156,2,'0079','2022-04-19','10:04:37','CC','','Yolanda felizzola morales','3135378425','','calle 7#6-74','V','C','1','2022-04-29','09:39:56',7,'P','Q',60,0,'N'),(157,1,'0094','2022-04-20','10:02:15','CC','','Tomas Pérez','3145601293','','CALLE 11 K 9 Y 10 SANTA ROSA','V','C','1','2022-04-29','04:36:51',40,'P','R',102,6183,'N'),(158,2,'0119','2022-04-20','10:10:25','CC','','Ilia zarquis de lisa','3205663858','','calle 6 # 3-6','V','C','1','2022-05-23','10:05:58',12,'P','Q',62,0,'N'),(159,2,'0079','2022-04-20','03:39:57','CC','','Carolina Pedrozo','3106705575','','calle 10a #18-51','V','C','1','2022-04-29','09:30:11',35,'P','Q',64,0,'N'),(160,2,'0093','2022-04-21','10:27:16','CC','','Teobaldo Martinez T','3116715885','','calle 10 con kra 19','V','C','1','2022-04-29','09:19:06',20,'P','Q',66,0,'N'),(161,1,'0094','2022-04-21','04:22:45','CC','','Ana M Saucedo Rangel','3218125524','','C  9 16-13 OTRO','V','C','1','2022-04-29','08:54:04',39,'P','R',103,8576,'N'),(162,1,'0043','2022-04-25','08:48:24','CC','1173150642','Francisco Camargo','3103644229','','kra 2# 20-22','V','C','1','2022-05-13','02:45:02',12,'P','R',104,0,'N'),(163,1,'0094','2022-04-25','09:03:27','CC','','Esteban Morales','3148761991','','C. 9 N.13-21 EL HUERTO','V','C','1','2022-05-24','04:37:05',14,'P','R',105,8468,'N'),(164,1,'0105','2022-04-25','09:25:45','CC','39007008','Alicia Rodríguez','3153323919','','K 12 N 2-10 SANTANDER','V','C','1','2022-04-29','04:42:00',41,'P','R',106,417,'N'),(165,1,'0043','2022-04-25','09:35:44','CC','','Babyngton  Mieles','3114254310','','kra 9 # 1a -02','V','C','1','2022-05-13','11:40:10',13,'P','R',107,0,'N'),(166,1,'0094','2022-04-25','10:23:14','CC','39007763','Ruth Sánchez Rojas','3145375312','','K 19  #  9A-67 OTRO','V','C','1','2022-04-29','03:48:18',35,'P','R',108,7048,'N'),(167,1,'0094','2022-04-25','12:03:44','CC','','Marina Tapia','3146676467','','calle 13#10-55','V','C','1','2022-05-26','05:02:33',19,'P','R',109,0,'N'),(168,2,'0079','2022-04-26','08:43:21','CC','39016493','Luz Daris Machado Robles','','','calle 10 # 16a -06','E','C','1','2022-05-16','08:52:58',28,'P','Q',68,0,'N'),(169,1,'0093','2022-04-28','09:46:20','CC','','Walberto Ramos','3205065045','','K 1B N 17-5 LA PLAYA','V','C','1','2022-05-12','11:09:34',17,'P','R',110,4954,'N'),(170,1,'0094','2022-04-28','10:06:07','CC','','laudis laguna','3218565943','','KRA 15. N. 4-05 20 DE ENERO','V','C','1','2022-05-12','11:19:27',4,'P','R',111,8820,'N'),(171,1,'0094','2022-04-28','10:16:28','CC','','Laudis Laguna','3218565943','','KRA 15#4-15','V','C','1','2022-05-12','11:31:31',16,'P','R',112,10648,'N'),(172,2,'0119','2022-04-28','10:28:05','CC','','Edgar Carreño','3107277785','','kra 6 #15-30','V','C','1','2022-05-02','11:16:29',3,'P','Q',69,0,'N'),(173,2,'0079','2022-04-29','09:06:26','CC','57380206','Amparo Tinoco Arana','4298204','cdihi-nutrirelbanco@gmail.com','K 4 N 14-35 EL PROGRESO','V','C','1','2022-05-13','04:25:53',15,'P','Q',71,5402,'N'),(174,1,'0093','2022-04-29','09:55:19','CC','57380206','Amparo Tinoco Arana','3216973870','','KM 1 VIA CHIMICHAGUA','V','C','1','2022-05-13','04:29:28',42,'P','P',16,1500,'N'),(175,1,'0094','2022-04-29','10:25:36','CC','57380206','Amparo Tinoco Arana','3216973870','','KM 1 VIA CHIMICHAGUA','E','C','1','2022-05-13','03:48:34',42,'P','P',16,1500,'N'),(176,2,'0127','2022-04-29','10:36:15','CC','57380206','Amparo Tinoco Arana','4298204','cdihi-nutrirelbanco@gmail.com','K 4 N 14-35 EL PROGRESO','V','C','1','2022-05-18','10:43:37',15,'P','Q',71,5402,'N'),(177,1,'0094','2022-04-29','10:45:56','CC','','Luis Mejías Diaz','3114252712','','C 8 N 2A-40  APTO 202','V','C','1','2022-05-12','11:23:22',12,'P','R',113,6771,'N'),(178,1,'0094','2022-04-29','05:01:12','CC','','Jacob Ruz','3205679785','','C 1A N 8-49 LA ALMIRANTE PADILLA','V','C','1','2022-05-12','11:14:43',21,'P','R',114,3178,'N'),(179,2,'0079','2022-05-02','08:39:27','CC','','Kellys Arias','3145925636','kra 20 b # 8-90','','V','C','1','2022-07-22','09:13:56',8,'P','P',17,0,'S'),(180,2,'0079','2022-05-02','08:47:49','CC','','Ana Morales','3205086972','','calle 14 # 23- 65','V','C','1','2022-05-13','11:44:59',35,'P','P',18,0,'N'),(181,1,'0105','2022-05-02','09:15:02','CC','39010720','Griselda Bermúdez','3107023434','','C 9 N 9-117 LAS DELICIAS','V','C','1','2022-05-12','09:39:13',27,'P','R',115,4365,'N'),(182,2,'0079','2022-05-02','02:30:06','CC','','Luis Herrera','3126326019','','calle 10a # 18','V','C','1','2022-05-16','11:08:39',35,'P','Q',72,0,'N'),(183,2,'0079','2022-05-02','02:31:17','CC','','Luis Herrera','3126326019','','calle 10a # 18','V','C','1','2022-05-16','10:59:05',35,'P','Q',72,0,'N'),(184,2,'0079','2022-05-02','02:38:02','CC','','Juan Vargas','','','calle 5 # 9-40','V','C','1','2022-05-10','09:28:09',36,'P','Q',73,0,'N'),(185,2,'0079','2022-05-02','02:46:39','CC','','María F Herrera Pedroso','3016660111','','calle 10a #18-51','V','C','1','2022-05-16','10:42:44',35,'P','Q',74,0,'N'),(186,1,'0094','2022-05-02','02:53:31','CC','','Edwin Diaz','3106880810','','kra 20b # 9d -35','V','C','1','2022-05-24','04:27:39',35,'P','R',116,0,'N'),(187,1,'0093','2022-05-03','04:36:04','CC','','Arelys Ríos','3223085394','','K 2 N 16-42 LA CANDELARIA','V','C','1','2022-07-22','09:10:19',17,'P','R',117,5059,'N'),(188,1,'0094','2022-05-03','04:48:49','CC','','Tomas Barbudo M','3126699184','','K 20   #   10-18 OTRO','V','C','1','2022-05-24','04:32:48',35,'P','R',118,7427,'N'),(189,1,'0093','2022-05-04','08:41:38','CC','','Víctor Esparragoza','3145514718','','C 5 N 9-41 SAN FRANCISCO','V','C','1','2022-05-10','09:11:20',36,'P','P',19,3807,'N'),(190,1,'0093','2022-05-04','10:25:47','CC','12580268','Francisco Abello  Meza','3114145146','','C 11 N 4-03 EL PROGRESO','V','C','1','2022-10-26','11:25:01',15,'P','P',20,2582,'N'),(191,1,'0093','2022-05-04','03:51:28','CC','39017181','Meira Estrada  Tovar','','','calle 7# 10 -27','V','C','1','2022-07-22','09:16:58',12,'P','P',21,0,'N'),(192,1,'0094','2022-05-09','11:12:42','CC','60281427','Erenice Morales','3216490375','','CLL 18 # 16-C30','V','C','1','2022-06-01','11:04:44',44,'P','R',119,9985,'N'),(193,1,'0094','2022-05-10','03:12:30','CC','','Ana Larios','4292556','','C 3 N 4-33 CHAPINERO','V','C','1','2022-05-12','09:29:03',7,'P','R',120,3471,'N'),(194,1,'0043','2022-05-12','09:03:35','CC','','Wilfrido Agamez','3104969320','','kra 2 calle 11','T','C','1','2022-05-26','03:46:25',12,'P','R',121,0,'N'),(195,2,'0119','2022-05-16','09:20:56','CC','','Jose Jaraba','3167590140','','calle 7# 11_07','V','C','1','2022-05-23','09:35:20',10,'P','Q',75,0,'N'),(196,1,'0094','2022-05-16','09:46:16','CC','','Marina Tapia','3146676467','','calle 13#10-55','V','C','1','2022-05-20','03:36:52',19,'P','R',109,0,'N'),(197,1,'0119','2022-05-16','10:43:50','CC','77190344','Jaime Méndez quintero','','','calle 10 # 4-46','E','C','1','2022-06-21','10:47:09',15,'P','Q',77,0,'N'),(198,2,'0079','2022-05-16','11:45:25','CC','','Luisa Soraya Palomino','3133862706','','kra 20 # 9-09','E','C','1','2022-05-23','09:44:40',35,'P','Q',78,0,'N'),(199,1,'0094','2022-05-16','02:53:09','CC','26743565','America Cantilllo','3015101903','','kra 5 # 2a - 27','E','C','1','2022-06-01','02:45:20',21,'P','R',122,0,'N'),(200,1,'0093','2022-05-17','08:47:22','CC','12400713','José Galván Mejía','3008433679','','C 18 N 4-03 2 DE FEBRERO','E','C','1','2022-06-01','08:46:28',3,'P','R',123,3119,'N'),(201,1,'0119','2022-05-17','09:06:09','CC','12579014','Catalino Varela','3118792039','','kra 8 entre calle 3y 4','E','C','1','2022-06-01','04:05:16',36,'P','Q',80,0,'N'),(202,2,'0079','2022-05-17','10:56:31','CC','85434190','Martin Ramos Casares','3107185484','','calle 9 # 16- 59','E','C','1','2022-06-21','10:58:37',40,'P','P',23,0,'N'),(203,2,'0079','2022-05-17','11:05:25','CC','85434190','Martin Ramos Casares','3107185484','','calle 9 # 16- 59','E','A','','0000-00-00','00:00:00',40,'P','P',23,0,''),(204,2,'0079','2022-05-18','10:31:04','CC','','Ricardo Garcias Galezzo','3002579229','','calle 2 #10 -30','V','C','1','2022-05-23','09:52:56',9,'P','Q',81,0,'N'),(205,1,'0094','2022-05-20','03:12:13','CC','','Olga Quiroz','3107340089','','C 12 K 1B Y LA PLAYA','V','C','1','2022-06-01','08:32:02',12,'P','R',124,2665,'N'),(206,1,'0093','2022-05-20','03:45:15','CC','','Mileinis Olivieri Morales','3012459279','','C 1 N 12-74 SANTANDER','V','C','1','2022-06-01','08:37:56',33,'P','R',125,2333,'N'),(207,1,'0093','2022-05-23','09:01:14','CC','12576243','Alfredo Valderrama','','','calle 9 cra 7','V','C','1','2022-05-26','09:29:00',27,'P','R',126,0,'N'),(208,1,'0094','2022-05-23','09:18:38','CC','','Abasto Media Luna','','','CALLE 7#9-108','V','C','1','2022-06-01','08:34:46',36,'P','R',127,9108,'N'),(209,2,'0079','2022-05-26','08:45:56','CC','','Wilfrido Agamez','3104969320','','kra 2 calle 11','V','C','1','2022-06-08','03:50:34',12,'P','Q',83,0,'N'),(210,1,'0093','2022-05-26','10:43:15','CC','','Maricela Rangel','3126650339','','kra 1b # 16 -2','V','C','1','2022-06-01','08:43:37',23,'P','R',128,4943,'N'),(211,1,'0043','2022-05-26','11:05:15','CC','','Jan Carlos España','','','','V','C','1','2022-06-07','08:27:54',27,'P','R',129,0,'N'),(212,1,'0094','2022-05-26','11:16:14','CC','','Cecilia Amaris','','','calle 3 # 10 -47','V','C','1','2022-06-01','08:41:35',36,'P','R',130,3442,'N'),(213,1,'0043','2022-06-01','08:58:41','CC','','Alexander Mendez','3126362242','','kra 2 # 3-34','V','C','1','2022-06-07','08:52:21',24,'P','P',24,0,'N'),(214,1,'0043','2022-06-01','09:06:38','CC','','Denis María Segovia','3202171281','','calle 1 kra 13','V','C','1','2022-06-21','11:48:34',2,'P','P',25,0,'N'),(215,1,'0016','2022-06-01','09:13:32','CC','','Sandra Molina  García','3107186512','','calle 8 # 19-75','V','C','1','2023-11-17','02:32:17',35,'P','P',26,0,'N'),(216,1,'0043','2022-06-01','09:31:55','CC','85440462','Manuel Salvador Morales','3133808793','','kra 11# 1 -06','V','C','1','2022-06-09','09:55:11',13,'P','P',27,0,'N'),(217,2,'0103','2022-06-01','09:36:53','CC','','Yasmin Arias','3117448245','','calle 2 kra 11 y 12','V','C','1','2022-06-09','10:06:54',41,'P','Q',84,0,'N'),(218,2,'0119','2022-06-01','09:44:20','CC','','Ninibeth Martinez Viadero','3042652827','','calle 1 # 8-60','V','C','1','2022-06-10','02:59:38',21,'P','Q',85,0,'N'),(219,1,'0105','2022-06-01','10:03:25','CC','','David Rodriguez T','3209343382','','Kra 1a # 14 -7','V','C','1','2022-06-09','10:34:27',23,'P','R',131,0,'N'),(220,2,'0119','2022-06-01','10:14:49','CC','','Diva Ruiz','3126897171','','C 2 N 11-60 SANTANDER','V','C','1','2022-06-21','11:09:37',41,'P','Q',86,3226,'N'),(221,1,'0043','2022-06-07','01:25:51','CC','34012855','Rosario Beleño P.','3177801726','','Calle 6 # 4 - 28','E','A','','0000-00-00','00:00:00',12,'P','Q',89,0,''),(222,1,'0043','2022-06-08','08:36:37','CC','39011553','Cecilia Fernández','3205313259','','Calle 2A Cra. 7 bajando','E','C','1','2022-07-13','09:42:47',21,'P','Q',90,0,'N'),(223,2,'0053','2022-06-08','08:57:05','CC','1216981178','Johana P. Sánchez','3104680224','','Carrera 2 con calle 15','E','C','1','2022-08-30','09:57:07',17,'P','Q',91,0,'N'),(224,2,'0023','2022-06-08','03:01:22','CC','1691660890','Samir Pedrozo','3169312633','','Cra. 7 entre calles 14 y 15','T','C','1','2022-07-21','11:08:15',34,'P','Q',92,0,'N'),(225,2,'0112','2022-06-09','10:58:45','CC','39018617','Lisbeth Pérez Gil','3135473269','','Cra. 5 # 12 - 16','E','A','','0000-00-00','00:00:00',15,'P','Q',93,0,''),(226,2,'0023','2022-06-13','08:58:09','CC','12581845','Jhony De Jesús Teherán Meza','3135056611','','Clle. 8 entre Cras. 7 y 8','E','C','1','2022-06-21','11:23:35',27,'P','Q',94,0,'N'),(227,2,'0023','2022-06-13','10:28:07','CC','','Emel Hoyos','3205752918','','Cra. 2 # 12 - 60','E','C','1','2022-07-13','10:56:32',15,'P','Q',95,0,'N'),(228,2,'0023','2022-06-13','11:03:17','CC','39011980','Yesenia Mejía Gutiérrez','3146436990','','Clle. 9 con Cra. 9 esquina','E','C','1','2022-06-21','11:29:36',27,'P','Q',96,0,'N'),(229,2,'0053','2022-06-15','08:41:21','CC','5','Juan Carlos Avendaño','','','Clle. 2A # 8 -04','E','C','1','2022-07-13','10:42:03',8,'P','Q',97,0,'N'),(230,2,'0023','2022-06-21','03:08:39','CC','9076299','Manuel Quintero Salazar','3122153141','','Calle. 18 entre Cras. 5 y 6','E','C','1','2022-07-13','09:27:22',3,'P','Q',98,0,'N'),(231,1,'0094','2022-06-28','09:12:39','CC','','CAMILO TORRES','3124855260','','Clle. 8 # 7 - 72','E','C','1','2022-07-13','10:28:07',27,'P','P',28,0,'N'),(232,1,'0082','2022-06-28','02:47:33','CC','7007780326','ADRIANA TORRES','3148396491','','Clle. 7 lavadero jabonazo','E','C','1','2022-07-13','10:22:50',30,'P','R',132,0,'N'),(233,2,'0023','2022-07-06','04:21:53','CC','39007580','MIRYAN CECILIA MOYA  P.','311','','Clle. 6A # 20A - 15','E','C','1','2022-07-15','08:59:17',30,'P','Q',99,0,'N'),(234,1,'0094','2022-07-07','09:10:09','CC','','ALBANIS GARCIA','3126110121','','Clle. 1A - # 10 - 32','V','C','1','2022-07-13','10:11:29',9,'P','R',133,0,'N'),(235,2,'0023','2022-07-11','10:27:28','CC','1085048398','JUAN ARAUJO','3003630884','','Cra. 25A - # 3 - 47','E','C','1','2022-07-15','08:44:54',22,'P','Q',100,0,'N'),(236,1,'0094','2022-07-11','10:47:54','CC','39014432','ELSIDA CARVAJAL','3106850555','','Calle 8 con Cra. 15  otros','E','C','1','2022-07-13','10:17:39',28,'P','Q',101,0,'N'),(237,2,'0023','2022-07-11','03:26:27','CC','12582803','Ramiro Cruz Toro','3023023823','','Cra. 6 con calle 7 esquina','E','C','1','2022-08-09','02:30:52',7,'P','Q',102,0,'N'),(238,1,'0043','2022-07-12','02:41:31','CC','39010402','MARTHA OSPINO','3205966796','','Clle. 7 # 5 - 56','E','A','','0000-00-00','00:00:00',7,'P','Q',103,0,''),(239,2,'0023','2022-07-12','03:06:14','CC','70692829','JUAN ANTONIO GOMEZ','3145587233','','Clle. 5 # 900 - 78','E','C','1','2022-07-21','11:25:57',36,'P','Q',104,0,'N'),(240,1,'0043','2022-07-15','08:29:30','CC','39013416','BETTY MORALES HURTADO','3007530429','','Calle 1ra. con carrera 12','E','C','1','2022-08-11','04:44:52',13,'P','Q',105,0,'N'),(241,2,'0023','2022-07-18','11:27:48','CC','1140852587','SANDRA CHAJIN HUERTAS','3022186396','','Carrera  19 # 9A- 42','E','C','1','2022-07-25','09:18:59',35,'P','Q',106,0,'N'),(242,2,'0023','2022-07-21','12:35:18','CC','85438242','FEDERICO FUNTES VILLALOBO','3507023976','','Calle 1 con carrera 10 y 11','E','C','1','2022-08-08','03:28:25',13,'P','Q',107,2295,'N'),(243,1,'0093','2022-07-21','03:03:23','CC','85435444','EPIFANIO QUIÑONEZ','3145349744','','Carrera 1A # 17 - 4','E','C','1','2022-08-11','09:28:24',23,'P','P',29,0,'N'),(244,1,'0094','2022-07-21','03:59:09','CC','18967820','ANTONIO QUINTERO BLANCO','3126983388','','Calle 1ra. # 2 - 48','E','C','1','2022-08-08','03:48:01',12,'P','P',30,0,'N'),(245,1,'0125','2022-07-21','04:20:29','CC','1085097875','Samuel Enrique Flórez Meza','3128442513','','Calle 8 # 13C - 105','E','C','1','2022-08-08','04:02:29',28,'P','P',31,0,'N'),(246,2,'0079','2022-07-22','08:53:50','CC','','MARCO ANTONIO RINCON','3153590357','','Carrea 4 # Clle. 2 esquina','E','C','1','2022-10-28','10:01:01',21,'P','Q',108,0,'N'),(247,2,'0023','2022-07-25','03:49:07','CC','26764365','EMILIA FUENTES PEDROZO','3126927515','','Calle 8 con carreras 25 - 26','E','C','1','2023-11-17','02:34:46',11,'P','Q',109,0,'N'),(248,1,'0094','2022-07-25','04:24:53','CC','3816958','DANIEL VILLARREAL','3218791606','','Calle 8 # 2 - 18','E','C','1','2022-08-08','02:51:50',12,'P','P',32,0,'N'),(249,2,'0023','2022-07-26','09:07:42','CC','32895986','YEXENIA BAENA HERNANDEZ','3163671311','','Carrera 12 con calle 3 # 5 - 54','E','C','1','2022-08-11','09:11:33',24,'P','Q',110,0,'N'),(250,1,'0093','2022-07-28','08:54:28','CC','12583681','ROIMER  VARGAS','3215441954','','Calle 8 # 20 - 07','E','C','1','2022-08-08','03:01:32',8,'P','P',33,0,'N'),(251,1,'0094','2022-07-28','09:58:47','CC','60379940','LILIZBEY GONZALEZ DURAN','3125395540','','CALLE 12 # 20 - 17','E','C','1','2022-08-08','02:42:49',35,'P','R',134,0,'N'),(252,2,'0023','2022-07-28','10:43:17','CC','39008496','BEATRIZ MARTINEZ','39008496','','Calle 15 # 6 - 02','E','C','1','2022-09-13','09:30:40',3,'P','Q',111,0,'N'),(253,1,'0082','2022-07-28','11:38:24','CC','1004095170','JOSE C.','3114111152','','Calle 10 # 2 - 97','E','C','1','2022-08-08','02:35:43',12,'P','R',137,0,'N'),(254,2,'0023','2022-07-28','03:41:52','CC','3816269','JOSE TRESPALACIO MARTINEZ','3116901010','','Carrera 24A  8C -21','E','C','1','2023-11-17','02:36:17',11,'P','Q',112,0,'N'),(255,2,'0023','2022-08-01','10:12:13','CC','1018509553','LAURA ELENA LANDAZABAL BAYTER','3128519856','','CALLE 4 # 11 - 20','E','C','1','2022-08-23','09:23:32',24,'P','Q',113,0,'N'),(256,1,'0043','2022-08-01','10:28:38','CC','12579854','ANNY REBECA ORTIZ PUERTA','3126529839','','CALLE 8 # 11 - 71','E','C','1','2022-08-12','10:29:24',10,'P','Q',114,0,'N'),(257,2,'0023','2022-08-01','03:54:21','CC','39012687','CANDELARIA OSPINO','3043478964','','Carrera 12 # 1 - 56','E','C','1','2022-08-19','09:02:16',13,'P','Q',115,0,'N'),(258,2,'0023','2022-08-02','03:34:31','CC','85438484','FABIO AARON','3222704339','','CARRERA 5 # 10 - 34','E','C','1','2022-08-30','10:29:46',15,'P','Q',116,0,'N'),(259,1,'0093','2022-08-05','03:31:03','CC','23755107','LUZ MARIELA HEREDIA','3125315253','','CALLE 3 # 10 - 06','E','C','1','2022-08-23','02:57:46',9,'P','P',34,0,'N'),(260,1,'0094','2022-08-08','10:15:22','CC','','GRACIELA  PEREIRA DE PEREZ','3218297063','','CALLE 3 # 7 - 40','E','C','1','2022-08-11','04:16:31',21,'P','P',35,0,'N'),(261,2,'0023','2022-08-09','11:24:49','CC','22377569','ENEYDA  BAYTER  A.','3135420446','','CALLE 9 # 4 - 15','E','C','1','2022-08-17','10:53:04',27,'P','Q',117,0,'N'),(262,1,'0094','2022-08-10','02:29:47','CC','85437927','JESUS TORREJANO BELEÑO','','','CALLE 12 # 2A- 7','E','C','1','2022-08-16','12:25:24',12,'P','R',138,0,'N'),(263,1,'0043','2022-08-10','03:51:09','CC','39008144','MARLENE HERNANDEZ MORA','','','CARRERA 15 # 9A -65','E','C','1','2022-08-25','09:06:48',28,'P','Q',118,0,'N'),(264,1,'0094','2022-08-16','10:46:25','CC','5018049','ALFONSO GOMEZ  ARISTIZABAL','314519','','CARRERA 2 # 8 -18','E','C','1','2022-08-22','09:51:09',12,'P','P',36,0,'N'),(265,2,'0023','2022-08-16','11:16:45','CC','1085042219','JUAN CARLOS PEDROZO','3127044376','','Carrera 19  # 10 - 22','E','C','1','2023-03-15','10:24:36',35,'P','Q',119,0,'N'),(266,2,'0023','2022-08-25','10:37:13','CC','12579707','FRANCISCO  VEGA DIAZ','3218993432','','CARRERA 1ra. # 15-80','E','C','1','2022-08-30','10:40:34',17,'P','Q',120,0,'N'),(267,1,'0094','2022-08-25','11:18:23','CC','51713667','LUZ MARINA RODRIGUEZ','3218771671','','CALLE 2A. # 7- 37','E','C','1','2022-09-02','02:27:13',9,'P','P',37,0,'N'),(268,1,'0094','2022-08-26','09:58:35','CC','1004094878','MARIA F. SALAZAR M.','3116487925','','CALLE 4 CARRERA 9 # 21','E','C','1','2022-09-02','02:32:52',36,'P','P',38,0,'N'),(269,2,'0023','2022-08-30','03:42:41','CC','','FEDERICO FUENTES','3507023976','','CALLE 1ra. CON CARRERA 10','E','C','1','2022-10-28','10:13:57',13,'P','Q',121,0,'N'),(270,2,'0023','2022-08-30','04:03:20','CC','85435169','VICTOR J. ZAMBRANO SEGOVIA','3116922750','','CARRERA 11 # 2-30','E','C','1','2022-10-27','11:17:36',41,'P','Q',122,0,'N'),(271,2,'0023','2022-08-30','04:22:58','CC','52936269','MONICA VILLARREAL','3203592861','','CARRERA 5 # 7 - 24','E','C','1','2023-02-27','03:15:31',7,'P','Q',123,0,'N'),(272,1,'0094','2022-08-31','03:04:43','CC','36695613','YULEYDIS HERRERA','3008030345','','CALLE 4 # 3 - 50','E','C','1','2022-09-13','09:13:40',7,'P','P',39,0,'N'),(273,1,'0094','2022-09-01','09:30:41','CC','85441525','JAIBER  BARRIOS  ALVARADO','3137815027','','Carrera 22B # 1A -02','E','C','1','2022-09-27','10:22:19',5,'P','P',40,0,'N'),(274,2,'0023','2022-09-01','09:59:26','CC','26742838','MARIA DE LAS MERCEDES CANTILLO','3233812591','','CALLE 4 ENTRE CARRERAS 9 Y 10','E','C','1','2022-09-13','10:51:04',36,'P','Q',124,0,'S'),(275,1,'0082','2022-09-01','11:00:08','CC','7928686','JUAN CARLOS FLOREZ','3008058658','','CARRERA 20 # 7 - 42','E','C','1','2022-09-13','10:37:29',8,'P','P',41,0,'N'),(276,1,'0082','2022-09-01','11:23:16','CC','39012342','MONICA BRUCES S.','3022500243','','CALLE 7 # 20 - 24','E','C','1','2022-09-13','10:35:07',30,'P','R',139,0,'S'),(277,2,'0023','2022-09-09','09:18:37','CC','79374666','SANDRA ARCE POSADA','3216806734','','CALLE 4 # 12 - 49','E','C','1','2022-09-27','03:29:25',24,'P','Q',125,0,'N'),(278,2,'0023','2022-09-12','11:23:12','CC','83213228','MARLENE VILLAFAÑE','3145139562','','CALLE 9 CARRERAS 17 Y 18','E','C','1','2022-09-27','09:55:40',20,'P','Q',126,0,'N'),(279,1,'0082','2022-09-21','09:39:13','CC','39013986','ERIKA SARQUIS','3122234588','','CALLE 10  # 2 - 20','E','C','1','2022-09-27','09:17:08',12,'P','R',140,0,'N'),(280,1,'0082','2022-09-21','10:00:01','CC','39023807','YOMAIRA BORJA','3135653832','','Cra. 2A # 11 - 5','E','C','1','2022-09-27','09:09:30',12,'P','R',141,0,'N'),(281,2,'0023','2022-09-22','09:54:37','CC','63317049','DARNELYS PIMIENTA LARA','3042651942','','Cra. 6 # 16 - 49','E','C','1','2022-09-27','04:31:11',3,'P','Q',127,0,'N'),(282,2,'0023','2022-09-22','10:09:26','CC','39008794','TEOBALDINA MARTINEZ','3126537501','','CALLE 18 # 4 - 35','E','C','1','2022-09-27','04:43:10',3,'P','Q',128,0,'N'),(283,2,'0030','2022-09-26','09:35:34','CC','85272018','LUIS ALBERTO TORREZ','3116616213','','CALLE 10 # 18 - 46','E','C','1','2022-09-27','03:44:23',20,'P','Q',129,0,'N'),(284,1,'0043','2022-09-27','11:26:00','CC','85435584','EGIDIO ABD RAMIREZ','3104609268','','CALLE 1ra.  9 - 63','E','C','1','2022-10-26','09:49:38',13,'P','Q',130,0,'N'),(285,2,'0023','2022-09-27','02:36:30','CC','36575135','RITA DEL SOCCORRO ROBLES','3135426849','','CALLE 7 # 7- 47','E','C','1','2022-10-27','11:04:53',36,'P','Q',131,0,'S'),(286,2,'0042','2022-09-28','03:17:13','CC','1216965789','KATHEREN R. CASTRO ALQUERQUE','3245337473','','CALLE 4 Cra. 11 - 12','E','C','1','2022-10-03','03:15:57',24,'P','Q',132,0,'N'),(287,2,'0023','2022-09-30','09:17:13','CC','1085043651','LUIS CARLOS MARTINEZ','3188341889','','CALLE 11 # 23 - 55','E','C','1','2022-10-03','11:35:42',35,'P','Q',133,0,'N'),(288,2,'0023','2022-09-30','09:52:25','CC','1082974682','SHADIA CHEDRAGUI ROYERO','3113980109','','CALLE 7 # 17 - 05','E','C','1','2022-10-26','10:26:28',39,'P','Q',134,0,'N'),(289,1,'0094','2022-09-30','10:19:04','CC','','ROSARIO CAMELO DE LEON','3126075491','','CALLE 2 # 9 - 63','E','C','1','2022-10-03','11:48:57',9,'P','P',42,0,'N'),(290,1,'0094','2022-09-30','10:45:00','CC','23104280','GUANNY CENTENO','3012137916','','CALLE 8 # 7- 51','E','C','1','2022-10-03','11:53:20',27,'P','P',43,0,'N'),(291,2,'0023','2022-09-30','11:02:37','CC','39020345','KARINA MUÑOZ MORALES','3152954407','','CALLE 5 # 13 - 106','E','C','1','2022-10-03','02:53:58',4,'P','Q',135,0,'N'),(292,1,'0094','2022-09-30','11:24:53','CC','1085048141','FERNEY MARTINEZ','3043103242','','CALLE 13 # 8 - 27','E','C','1','2022-10-03','11:40:46',29,'P','P',44,0,'N'),(293,1,'0043','2022-10-03','10:37:51','CC','39013612','TATIANA SANCHEZ','3116590694','','C 2A N 8-75 LA ALMIRANTE PADILLA','E','C','1','2022-10-26','09:03:43',21,'P','Q',138,3417,'N'),(294,1,'0043','2022-10-05','10:32:19','CC','39011987','GRISELDINA MARTINEZ','3145827829','','CARRERA 15 A # 10 - 15B','E','C','1','2022-10-26','11:01:14',28,'P','Q',139,0,'S'),(295,1,'0043','2022-10-05','11:08:24','CC','39022909','EMILSE PALOMINO','3146539679','','CARRERA 15B','E','C','1','2022-10-26','10:07:16',26,'P','Q',140,0,'N'),(296,1,'0094','2022-10-10','09:32:11','CC','85433638','MARTIN NAVAS','3174231168','','CALLE 7 # 19 - 39','E','C','1','2022-10-24','02:43:40',8,'P','R',142,0,'N'),(297,1,'0094','2022-10-10','09:50:24','CC','85442612','JAIME VILLACOB GUERRA','3016628911','','CARRERA 5 # 6 - 40','E','C','1','2022-10-24','02:37:01',7,'P','R',143,0,'N'),(298,1,'0094','2022-10-10','10:22:19','CC','12584794','ALBERTO PEINADO BELEÑO','3114807092','','CALLE 1  # 14 - 24','E','C','1','2022-10-24','02:48:53',2,'P','P',45,0,'N'),(299,1,'0094','2022-10-25','10:26:56','CC','38160084','JUAN BAUTISTA ESPAÑA','','','CALLE 13 # 8 - 90','E','C','1','2022-10-26','08:31:31',29,'P','P',46,0,'N'),(300,1,'0094','2022-10-25','11:30:34','CC','85437865','JANER BLANCO QUINTERO','3145026127','','CALLE 9 # 7 - 31','E','C','1','2022-10-26','08:27:25',27,'P','P',47,0,'N'),(301,1,'0023','2022-10-25','03:08:15','CC','26379116','LEONOR SALAS','3128836017','','Cra. 25B # 7 - 92','E','C','1','2023-11-17','02:47:29',11,'P','Q',141,0,'N'),(302,1,'0093','2022-12-16','10:12:58','CC','9160017','PABLO TORREZ','','','Cra. 17 entre Clles. 9 y 10','T','C','1','2023-02-28','09:15:16',39,'P','R',144,0,'N'),(303,2,'0023','2022-12-16','03:09:07','CC','39012342','MONICA BRUCE','3022500243','','Calle 7 # 20 - 24','E','C','1','2023-02-28','09:11:18',30,'P','Q',143,0,'N'),(304,1,'0094','2022-12-16','03:28:36','CC','1','FRANCISCO J. MRALES C.','3114065927','','Calle 10 # 2 - 35','E','C','1','2023-02-28','09:18:14',15,'P','P',48,0,'N'),(305,1,'0043','2022-12-16','03:51:05','CC','12577824','TOMAS DIAZ','3145601293','','Calle 12 Cra. 4 # 53','E','C','1','2023-02-28','10:05:06',15,'P','Q',144,0,'N'),(306,2,'0023','2022-12-16','04:10:19','CC','36703014','HELEINE MUÑOZ','3216375947','','Calle 8 # 20 A  - 126','E','C','1','2023-02-28','02:34:53',8,'P','Q',145,0,'N'),(307,2,'0023','2022-12-19','08:35:49','CC','39023468','NEYLA TORREJANO','3215471264','','Cra. 22 # 2D - 26 esquina.','E','C','1','2023-03-15','10:36:37',30,'P','Q',146,0,'N'),(308,2,'0079','2022-12-19','08:50:36','CC','12400458','JULIO J. GALEZZO','3118331780','','Cra. 11 # 3 - 39','E','C','1','2023-02-28','02:43:56',36,'P','Q',147,0,'N'),(309,1,'0094','2022-12-19','09:07:38','CC','85270770','IMMER MARTINEZ MENESES','3226692002','','Calle 10A  19 - 28','E','A','','0000-00-00','00:00:00',35,'P','R',145,0,''),(310,2,'0023','2022-12-19','09:22:15','CC','7172669','EDWIN DIAZ CASTAÑEDA','3106880810','','Cra. 20B # 19D - 35','E','C','1','2023-03-14','02:58:19',35,'P','Q',148,0,'S'),(311,2,'0023','2022-12-19','09:38:31','CC','39007650','CRISPINIANA NORIEGA RANGEL','3215661006','','Cra. 19A #  9 - 18','E','C','1','2023-03-15','11:02:46',35,'P','Q',149,0,'N'),(312,1,'0043','2022-12-19','10:01:14','CC','12401315','BRANYS PEREZ','3013575875','','Calle 1 con Cra. 13','E','C','1','2023-02-28','03:18:21',2,'P','Q',150,0,'N'),(313,1,'0043','2022-12-19','10:20:17','CC','39014119','ANA DIAZ (YAMEL BAYTER','3016977392','','Calle 6 Cra. 2A','E','C','1','2023-03-15','11:34:48',7,'P','Q',151,0,'N'),(314,2,'0023','2022-12-19','10:31:00','CC','45743621','NOREIDA MEDINA','3117626879','','Cra. 20 # 13 - 34','E','C','1','2023-03-15','11:45:22',35,'P','Q',152,0,'N'),(315,1,'0043','2022-12-23','10:17:37','CC','39012122','MARIA TRINIDAD P.','3107414225','','CALLE 1A. # 14-50','E','C','1','2023-02-28','04:02:13',2,'P','Q',153,0,'N'),(316,1,'0094','2022-12-23','10:32:03','CC','','TOMAS D.','3145601293','','CALLE 12 # 4 - 53','E','C','1','2023-03-01','10:16:57',15,'P','P',49,0,'N'),(317,2,'0127','2022-12-23','10:51:39','CC','1091660890','SAMIR PEDRO','3169312633','','Carrera 7 entre calles 14 y 15','E','C','1','2023-02-28','04:21:35',34,'P','Q',154,0,'N'),(318,2,'0023','2022-12-23','11:00:38','CC','1085043651','LUIS CARLOS MARTINEZ','3188341889','','Carrera 24 # 11 - 06','E','C','1','2023-03-15','10:16:27',35,'P','Q',155,0,'N'),(319,1,'0094','2023-01-09','01:46:25','CC','51676225','YENIS OLIVEROS','3128873677','','Carrera 14 # 17 - 28','E','A','','0000-00-00','00:00:00',26,'P','P',50,0,''),(320,1,'0043','2023-01-09','02:11:24','CC','39010402','MARTHA C. OSPINO MIRANDA','','','Calle 7 # 5 - 56','E','C','1','2023-03-15','10:05:27',12,'P','Q',156,0,'N'),(321,2,'0023','2023-01-09','02:34:55','CC','39010434','GLADYS RANGEL ANILLOS','3148551904','','CALLE 18 # 2 - 44','E','C','1','2023-03-15','11:19:27',17,'P','Q',157,0,'N'),(322,2,'0023','2023-01-09','02:48:42','CC','8736950','JAIME CAMPO M.','3142060007','','CALLE 2 # 12 - 96','E','C','1','2023-03-14','03:09:00',41,'P','Q',158,0,'S'),(323,2,'0042','2023-01-09','03:01:18','CC','13165754','VICENTE GALVIS','3114142109','','Calle 5 # 9 - 78','E','C','1','2023-03-15','09:53:53',36,'P','Q',159,0,'N'),(324,2,'0023','2023-01-09','03:13:17','CC','13165754','VICENTE GALVIS','3114142109','','CRA. 2 ESQ. ALM. LOS CACHACOS','E','C','1','2023-03-15','11:11:30',12,'P','Q',160,0,'N'),(325,2,'0023','2023-02-15','09:09:01','CC','39011665','DORIS BANDOVINO','','','CRA. 4 Esquina','E','C','1','2023-02-28','02:55:02',3,'P','Q',161,0,'N'),(326,2,'0023','2023-02-15','09:26:24','CC','','BETTY MORALES HURTADO','3007530429','','CALLE 1 # 11','E','C','1','2023-02-28','08:56:50',13,'P','Q',162,0,'N'),(327,2,'0023','2023-02-15','10:10:58','CC','39014119','ANA MARIA CARRASQUILLA','3016977392','','CALLE 2 ENTRE CRA. 2A','E','C','1','2023-02-28','09:49:25',7,'P','Q',163,0,'N'),(328,2,'0023','2023-02-15','10:33:07','CC','','KATIUSCA ARCE','3135230509','','CALLE 8 # 7 - 15','E','C','1','2023-02-28','04:37:57',27,'P','Q',164,0,'N'),(329,2,'0023','2023-02-16','09:12:01','CC','39006002','POLICARPA  TORRES','3164893351','','Cra. 11 Clle. 2A','E','C','1','2023-02-28','03:47:18',9,'P','Q',165,0,'N'),(330,2,'0023','2023-02-16','09:49:54','CC','85442640','RICARDO CABRALES ROBLES','3003490858','','CALLE 9 # 8 - 49','E','C','1','2023-03-01','03:38:40',27,'P','Q',166,0,'N'),(331,1,'0043','2023-02-16','02:38:42','CC','12576674','MANUEL MUÑOZ ROBLES','3116782648','','Cra. 13 con  Calle. 5','E','C','1','2023-02-28','04:54:27',24,'P','Q',167,0,'N'),(332,1,'0043','2023-02-16','02:52:34','CC','39006240','RAMONA PEDROZO','3107463887','','CALLE 4 #  14A - 35','E','C','1','2023-03-01','10:35:53',4,'P','Q',168,0,'N'),(333,1,'0043','2023-02-16','03:30:01','CC','3961057','WILLIAM DE JESUS TAMAYO PALACIO','','','Clle.  4 # entre  Cra. 6 y 7','E','C','1','2023-04-04','03:12:15',7,'P','Q',169,0,'N'),(334,2,'0023','2023-02-16','04:19:11','CC','1085097931','MAGDA MARIA PEREZ','3147892146','','Calle 14 con carrera 1A.','E','C','1','2023-03-13','10:48:56',23,'P','Q',170,0,'N'),(335,2,'0028','2023-02-16','04:47:36','CC','26742838','MERCEDES CANTILLO NUÑEZ','3002506249','','Calle 4 # 9 - 29','E','C','1','2023-03-01','10:49:19',36,'P','Q',171,0,'N'),(336,1,'0093','2023-02-16','05:10:34','CC','1007615983','INGRID K. CARPINTERO','3104269401','','CRA. 22 ESQUINA','E','C','1','2023-03-01','10:56:19',31,'P','Q',172,0,'N'),(337,2,'0023','2023-02-17','08:47:11','CC','3927309','GENARO HERNANDEZ','3232883053','','CARRERA 2A # 11 - 40','E','C','1','2023-03-01','11:10:54',12,'P','Q',173,0,'N'),(338,1,'0093','2023-02-17','09:34:50','CC','49763706','MARELBIS GUZMAN','3005775660','','CALLE 8 # 9 - 68','E','C','1','2023-03-01','11:28:38',10,'P','R',146,0,'N'),(339,1,'0043','2023-02-17','10:03:00','CC','33210817','MIRYAN  ANAYA','3145324412','','Calle  1A. entre Cras. 11 y 12','E','C','1','2023-04-11','09:44:53',41,'P','Q',174,0,'N'),(340,2,'0023','2023-02-17','10:32:38','CC','39014537','LEYNA TOLOZA','3135252306','','CALLE 8 # 4 - 51','E','C','1','2023-03-01','02:45:36',17,'P','Q',175,0,'N'),(341,2,'0042','2023-02-17','10:57:18','CC','40881263',' JUNIS OSPINO R.','3234542358','','Carrera 6 con calle 1','E','C','1','2023-03-01','03:18:11',21,'P','Q',176,0,'N'),(342,2,'0023','2023-02-17','11:17:57','CC','72277465','ELVIS MARTINEZ A.','3127119829','','Calle 6 con Cra. 2. esquina.','E','C','1','2023-03-16','02:46:42',12,'P','Q',177,0,'N'),(343,1,'0094','2023-02-17','02:28:10','CC','','AMERICA BLANCO','3014328856','','CALLE 8 # 11 - 35','E','C','1','2023-03-01','04:04:24',10,'P','R',147,0,'N'),(344,2,'0023','2023-02-17','02:53:15','CC','63317040','DARNELYS PIMIENTA L.','3042651942','','Carrera 6 # 16 - 49','E','C','1','2023-03-16','11:54:57',3,'P','Q',178,0,'N'),(345,1,'0043','2023-02-17','03:22:20','CC','19416892','LUIS ALBERTO CAICEDO','3183077853','','Cra. 2 # 10 - 22','E','C','1','2023-03-01','03:29:10',12,'P','Q',179,0,'N'),(346,1,'0043','2023-02-17','03:59:45','CC','1085099156','JOSE ACEBEDO MARTINEZ','3176946285','','Calle 3 con Cra. 3-1','E','C','1','2023-03-01','03:48:02',12,'P','Q',180,0,'N'),(347,1,'0014','2023-02-21','09:48:02','CC','39010584','NELSY VILLAFAÑE Z.','3108394871','','CALLE  4 # 11- 11','E','C','1','2023-03-01','03:58:37',24,'P','P',51,0,'N'),(348,2,'0023','2023-03-07','03:59:42','CC','85270846','FAUSTO BELEÑO','3215297656','','Clle 15 con Cra. 6','E','C','1','2023-03-16','11:01:27',3,'P','Q',181,0,'N'),(349,2,'0023','2023-03-07','04:36:30','CC','26742942','BLANCA SEPULVEDA Y  OTROS','3145768655','','Carrera 3 entre calles  13 y 14','E','C','1','2023-03-15','02:57:25',15,'P','Q',182,0,'N'),(350,1,'0043','2023-03-07','05:00:23','CC','85439447','JAVIER JIMENEZ','3103648087','','Calle 9 # 8-01','E','C','1','2023-03-13','10:38:26',27,'P','Q',183,0,'N'),(351,1,'0043','2023-03-07','05:19:36','CC','12576895','NAIME MIELES','3118007829','','Calle 2A. # 7-. 01','E','C','1','2023-03-13','11:44:13',21,'P','R',148,0,'N'),(352,1,'0094','2023-03-08','09:19:07','CC','1007558727','MILENIS  CARRASCAL','3128907639','','Calle 8 # 7 - 04','E','C','1','2023-03-13','11:32:04',10,'P','R',149,0,'N'),(353,1,'0043','2023-03-08','09:42:43','CC','39011172','JACKELINE VILARDY','3106944266','','CALLE 8 # 9 - 26','E','C','1','2023-03-13','11:06:35',27,'P','Q',184,0,'N'),(354,2,'0023','2023-03-08','10:08:00','CC','85435036','GUSTAVO MARTINEZ','312661727','','CALLE  15 # 6 - 11','E','C','1','2023-03-16','11:18:53',3,'P','Q',185,0,'N'),(355,2,'0023','2023-03-08','10:43:12','CC','39020079','OLGA GARCIA ACUÑA','312586376','','CALLE 9 # 4-03','E','C','1','2023-03-16','11:31:02',27,'P','Q',186,0,'N'),(356,2,'0023','2023-03-08','11:20:54','CC','','CANDELARIA PEDROZO','3012853471','','CALLE # 15A- 4- 06','E','C','1','2023-03-16','11:38:44',3,'P','Q',187,0,'N'),(357,1,'0094','2023-03-08','03:02:52','CC','26774546','EDITH MARTINEZ','3126268490','','Calle 11 # 3 - 25','E','C','1','2023-03-13','03:03:40',15,'P','R',151,0,'N'),(358,1,'0094','2023-03-08','03:34:48','CC','7928606','JUAN CARLOS FLOREZ','3008058658','','CALLE 7 # 20 - 24','E','C','1','2023-03-13','11:15:08',30,'P','R',152,0,'N'),(359,1,'0094','2023-03-08','03:49:25','CC','26784299','YADIRA RIBON','3145017460','','Cra. 19B. # 9A. 37','E','C','1','2023-03-13','11:52:51',35,'P','R',153,0,'N'),(360,1,'0094','2023-03-08','04:39:34','CC','1007467756','LEIDIS GISELLE CANTILLO','3012404980','','CALLE 10A- # 19 - 10','E','C','1','2023-03-16','03:05:25',35,'P','R',154,0,'N'),(361,2,'0023','2023-03-08','04:58:25','CC','1085050224','DAIMER RODRIGUEZ','3218771672','','C ALLE 14 #CRA. 1','E','C','1','2023-03-15','02:44:51',23,'P','Q',188,0,'N'),(362,2,'0023','2023-03-09','09:52:47','CC','85270173','GUILLERMO MARTINEZ','3233270578','','Carrera 6 con calle 16','E','C','1','2023-04-04','02:48:51',1,'P','Q',189,0,'N'),(363,1,'0094','2023-03-09','02:28:37','CC','26743480','CELMIRA SAAD FRAIJA','3114013453','','CALLE 10 # 3 - 33','E','C','1','2023-03-13','02:16:16',15,'P','R',155,0,'N'),(364,1,'0094','2023-03-09','02:47:26','CC','12579845','RAFAEL CUELLO','3046625147','','Carrera 20  # 9D - 24','E','C','1','2023-03-13','03:09:49',35,'P','R',156,0,'N'),(365,1,'0094','2023-03-09','03:02:46','CC','39018482','DARLYS CAPATAZ C.','3128253909','','Carrera 14 # 3- 39','E','C','1','2023-03-13','11:22:17',4,'P','R',157,0,'N'),(366,1,'0043','2023-03-14','11:09:56','CC','30793025','ERNESTINA  FLOREZ','3215514020','','CALLE 5 # 14- 46','E','C','1','2023-03-15','02:29:47',4,'P','Q',190,0,'N'),(367,1,'0094','2023-03-16','08:44:19','CC','85435570','ALEXANDER LOAIZA CANTILLO','3114840063','','Carrera 9 # 2 - 11','E','C','1','2023-03-28','04:03:57',21,'P','Q',191,0,'N'),(368,2,'0023','2023-03-22','03:51:58','CC','39010709','LILIANA BAYTER','3116677317','CALLE 4# 11- 20','','E','C','1','2023-04-04','03:53:32',24,'P','Q',192,0,'N'),(369,2,'0023','2023-03-22','04:13:46','CC','12583307','LUIS BARROS','3208307186','','CALLE 9 # 18A - 03','E','C','1','2023-04-04','03:27:57',20,'P','Q',193,0,'N'),(370,2,'0023','2023-03-22','04:30:17','CC','12579091','PABLO GARCIA','3126100238','','CALLE 5 # 14- 58','E','C','1','2023-04-04','03:36:11',4,'P','Q',194,0,'N'),(371,2,'0023','2023-03-23','09:42:36','CC','12401840','LUIS RAFAEL SUEAREZ','3103557580','','CARRERA 10 # 3- 52','E','C','1','2023-04-04','04:10:50',36,'P','Q',195,0,'N'),(372,2,'0023','2023-03-23','10:02:02','CC','12577621','FERNANDO OVIEDO','3135849586','','CALLE  9 # 9 - 91','E','C','1','2023-04-04','04:04:03',10,'P','Q',196,0,'N'),(373,1,'0043','2023-03-29','09:16:58','CC','85271830','ELKIN CRESPO','3132062986','','Kra. 15 # 15 A - 30','E','C','1','2023-03-30','02:41:12',38,'P','Q',197,0,'N'),(374,1,'0043','2023-03-29','09:35:32','CC','1085046886','JOHANA PAOLA HERNANDEZ','3113824448','','CALLE 10 Kra. 12','E','C','1','2023-04-04','03:00:10',18,'P','Q',198,0,'N'),(375,1,'0098','2023-03-29','10:20:07','CC','1083009876','JAIRO JOSE ATENCIO LUQUETTA','3004891747','','CALLE 12  6- 38','E','C','1','2023-03-30','03:17:09',15,'P','Q',199,0,'N'),(376,2,'0023','2023-03-29','10:57:37','CC','39017931','DILEIMA MERIÑO FUENTES','3205217066','','CALLE 7 # 2A- 34','E','C','1','2023-04-04','03:18:23',12,'P','Q',200,0,'N'),(377,1,'0043','2023-03-29','03:21:41','CC','39016561','CARMEN CECILIA LOPERA','3207553742','','CALLE 4 # 6- 67','E','C','1','2023-04-04','03:44:35',7,'P','Q',201,0,'N'),(378,1,'0094','2023-03-30','08:59:18','CC','13880473','JAVIER RIVERAS RODRIGUEZ','3107463810','','K 3 N 14-43 EL PROGRESO','E','C','1','2023-03-30','03:55:24',15,'P','P',53,5318,'N'),(379,1,'0094','2023-03-30','09:10:11','CC','85441131','Luis Hernández cepeda','3135349829','','K 13 N 1B-65 SANTANDER','E','C','1','2023-03-30','03:52:33',41,'P','P',54,4833,'N'),(380,1,'0094','2023-03-30','09:25:01','CC','','Norcy Rangel Alvarado','3136929910','','K 17 N 10-05/B. LAS AMERICAS OTRO','E','C','1','2023-03-30','03:58:25',25,'P','R',158,9905,'N'),(381,1,'0094','2023-03-30','11:14:03','CC','38009993','Emilse Avendaño','3106575876','','K 2A N 13-3 LA CANDELARIA','E','C','1','2023-03-31','10:31:08',17,'P','P',55,5201,'N'),(382,2,'0079','2023-03-31','10:47:18','CC','39013634','idocilda vides','3205284789','','CLL 12# 18-140','E','C','1','2023-04-04','04:36:38',35,'P','Q',202,11278,'N'),(383,2,'0079','2023-03-31','10:48:54','CC','39017752','Yeni covilla Alvarado','3023633439','','KRA 3 # 13-42 APTO 3','E','C','1','2023-04-04','02:37:06',15,'P','Q',203,10553,'N'),(384,2,'0079','2023-04-03','09:47:37','CC','85438313','Gioseppe Jaraba Amaris','3116914878','','K 9 N 2-25 LA ALMIRANTE PADILLA','E','C','1','2023-04-04','04:26:29',36,'P','Q',204,5858,'N'),(385,2,'0079','2023-04-03','10:13:48','CC','12400458','Julio Galeazzo','3118331780','','K 11 N 3-39 SAN FRANCISCO','E','C','1','2023-04-04','04:18:18',36,'P','Q',205,4726,'N'),(386,2,'0079','2023-04-03','03:08:24','CC','39010434','Gladys Rangel Anillos','3148551904','','CL.18 N. 2-44LOS LA CANDELARIA','E','C','1','2023-04-18','08:49:20',17,'P','Q',206,8569,'N'),(387,2,'0079','2023-04-11','08:31:31','CC','39089142','Dorcas Cabarcas','3146823025','','K  15 # 10B-61','V','C','1','2023-04-18','09:09:04',28,'P','Q',207,8890,'N'),(388,1,'0094','2023-04-11','08:57:12','CC','85440332','Elkin Ernesto Vásquez Garcia','3172659505','','C 2A N 11-7 EL BANQUITO','V','C','1','2023-04-18','08:55:37',9,'P','P',56,414,'N'),(389,1,'0094','2023-04-11','10:05:30','CC','39009840','Amanda Lopez','3114150300','','CALLE  9 # 9-110','E','C','1','2023-04-18','08:40:16',27,'P','P',57,4243,'N'),(390,1,'0094','2023-04-11','10:05:30','CC','39009840','Amanda Lopez','3114150300','','CALLE  9 # 9-110','E','A','','0000-00-00','00:00:00',27,'P','P',57,4243,''),(391,1,'0094','2023-04-11','10:25:57','CC','39092531','NELLYS JARABA','3106589987','','CARRERA 11 # 1B-17','E','C','1','2023-04-18','11:48:32',9,'P','P',59,11057,'N'),(392,1,'0094','2023-04-11','02:37:52','CC','39092531','NELLYS JARABA','3106589987','','CARRERA 11 # 1B-17','E','A','','0000-00-00','00:00:00',9,'P','P',58,11057,''),(393,2,'0023','2023-04-17','10:33:59','CC','85439716','EDGARDO CAICEDO ROJAS','3234508560','','CARRERA  22 # 3A- 2','E','C','1','2023-04-20','08:51:27',30,'P','Q',208,0,'N'),(394,2,'0023','2023-04-27','10:01:32','CC','85272018','LUIS ALBERTO TORRES','3116616213','','CALLE 10 # 18- 23','E','C','1','2023-05-16','09:06:33',20,'P','Q',209,0,'N'),(395,2,'0023','2023-04-27','10:18:33','CC','22422513','ELIZABETH  VILARDY','3124480601','','CALLE 9 # 18A.- 59','E','C','1','2023-05-16','09:17:34',20,'P','Q',210,0,'N'),(396,1,'0094','2023-05-03','09:12:35','CC','85438025','ENRIQUE  C. OSPINA NUMA','3122583988','','CALLE 6 # 3 - 4','E','C','1','2023-05-16','09:50:23',12,'P','R',159,0,'N'),(397,1,'0094','2023-05-03','09:32:14','CC','13920565','LUIS FRANCISCO CASTELLANOS','3114019343','','CARRERA 11 # 4 - 36','E','C','1','2023-05-11','09:50:47',36,'P','P',60,0,'N'),(398,1,'0014','2023-05-03','09:59:20','CC','39010584','NELSY ZABALETA VILLAFAÑE','3108394871','','CALLE 4 # 11-  23','E','C','1','2023-05-16','09:46:22',24,'P','Q',211,0,'N'),(399,1,'0094','2023-05-03','10:57:18','CC','39013047','TULIA MARINA GIL GARCIA','3004361424','','C 2 N 6-47 LA ALMIRANTE PADILLA','E','C','1','2023-05-16','09:29:41',21,'P','P',61,3279,'N'),(400,1,'0094','2023-05-03','11:12:46','CC','378155587','CARMEN SOFIA TORRES','3165255081','','K 6 N 14-03 EL PROGRESO','E','C','1','2023-05-11','09:42:26',15,'P','P',62,5602,'N'),(401,1,'0094','2023-05-03','11:34:22','CC','39011230','JASMIN ESTHER OSPINO VANEGA','','','C 6 N 2-31 EL CENTRO','E','C','1','2023-05-11','09:28:41',21,'P','P',63,76,'N'),(402,1,'0094','2023-05-03','11:49:24','CC','85436320','MARIO TEHERAN MEZA','3114042006','','K 8 N 2A-18 LA ALMIRANTE PADILLA','E','C','1','2023-05-11','09:33:07',21,'P','P',64,5810,'N'),(403,2,'0023','2023-05-03','03:29:45','CC','12401312','JAMES MARTINEZ MENESES','3003834640','','CALLE 1A- # 8 - 29','E','C','1','2023-05-16','09:25:53',21,'P','Q',212,0,'N'),(404,1,'0094','2023-05-03','03:56:26','CC','5018049','ALFONSO GOMEZ ARISTIZABAL','3232887791','','CALLE 8 # 2A - 24','E','C','1','2023-05-11','09:46:43',12,'P','R',160,0,'N'),(405,2,'0023','2023-05-04','03:43:24','CC','121690752','ANDRES TORREZ','3157386453','','CARRERA 3 # 3 - 10','E','C','1','2023-05-16','10:31:14',7,'P','Q',213,0,'N'),(406,2,'0023','2023-05-04','03:56:53','CC','26743720','CARMEN SANCHEZ','3138746756','','CALLE 4 # 11- 3','E','C','1','2023-05-16','10:00:12',7,'P','Q',214,0,'N'),(407,2,'0023','2023-05-09','09:05:27','CC','73117628','JORGE LUIS CHICOCHICA','3147028175','','Carrera 2 entre clles. 14 y 15','E','C','1','2023-05-16','10:40:27',17,'P','Q',215,0,'N'),(408,2,'0023','2023-05-09','09:18:16','CC','39007809','YADIRA SEQUEA','3135654899','','Calle 11 # 7- 49','E','C','1','2023-05-16','10:54:58',15,'P','Q',216,0,'N'),(409,1,'0043','2023-05-09','09:54:09','CC','73117628','JORGE LUIS CHICOCHICA','3147028175','','CARREA 2A .# 11- 40','E','C','1','2023-05-24','10:10:54',12,'P','Q',217,0,'N'),(410,2,'0023','2023-05-11','11:08:18','CC','26722926','INES MARIA RANGEL MERIÑO','3126131931','','Carrera 8 entre calles 14 y 15','E','C','1','2023-05-24','09:59:10',34,'P','Q',218,0,'N'),(411,1,'0094','2023-05-11','04:03:27','CC','1193104703','FERNANDO CASTILLO','3126199514','',' Carrera 2A  # 12- 36','E','C','1','2023-05-16','11:33:52',15,'P','P',65,0,'N'),(412,1,'0094','2023-05-11','04:15:24','CC','39017577','CIELO TAMAYO P.','3003833919','','Carrera 2A # 11 - 5','E','C','1','2023-05-16','11:19:37',12,'P','P',66,0,'N'),(413,1,'0094','2023-05-12','02:52:03','CC','39011399','MARTHA TAMAYO','3003833919','','Carrera 2A- 11 # 38 local 2','E','C','1','2023-05-16','11:25:53',12,'P','P',67,0,'N'),(414,1,'0094','2023-05-16','02:29:13','CC','12613652','ALFREDO PEÑARREDONDA GRANADOS','3017851138','','CALLE 6  # 5 - 20','E','C','1','2023-05-17','03:40:42',7,'P','P',68,0,'N'),(415,2,'0023','2023-05-17','11:32:49','CC','12579707','JOSE FRANCISCO VEGA','3126969009','','Carrera 1A. calle 15 # 107','E','C','1','2023-05-24','10:16:30',17,'P','Q',219,0,'N'),(416,1,'0043','2023-05-24','04:51:29','CC','39019128','YAQUELINA PEINADO','3017812949','','CALLE 9 # 15- 193','E','C','1','2023-06-05','09:22:07',28,'P','Q',220,0,'N'),(417,2,'0023','2023-05-25','03:49:52','CC','12577624','FERNANDO OVIEDO','3135849586','','CALLE 10 # 9 - 10','E','C','1','2023-06-05','02:45:03',27,'P','Q',221,4377,'N'),(418,2,'0023','2023-05-25','04:08:38','CC','326675132','MARLENE I. SERRANO URRUTIA','3234508560','','CARERRA 22 # 20-24','E','C','1','2023-06-05','09:44:41',31,'P','Q',222,0,'N'),(419,2,'0023','2023-05-25','04:27:54','CC','39021813','MADELEINIS SANCHEZ','3147681797','',' CALLE 10A  #  21 - 45','E','C','1','2023-06-06','09:31:40',35,'P','Q',223,0,'N'),(420,2,'0023','2023-05-25','04:36:15','CC','39020811','YANNIS RODELO','3145896069','','CALLE 14 # 3 - 24','E','C','1','2023-06-05','09:31:48',17,'P','Q',224,0,'N'),(421,2,'0023','2023-05-26','08:52:00','CC','5424456','GILBERTO OJEDA  LOBO','3134580684','','CALLE 10 # 6 - 66','E','C','1','2023-06-05','10:11:31',15,'P','Q',225,0,'N'),(422,2,'0023','2023-05-26','09:16:02','CC','85442002','JOSE JAVIER PALOMINO','3116628549','','CARRERA 2 # 6 - 18','E','C','1','2023-06-05','09:57:03',12,'P','Q',226,0,'N'),(423,1,'0082','2023-05-29','03:19:50','CC','39008751','MARIA IGNACIA CARPIO ZAMBRANO','3205163439','','CARERRA 19A- # 9A- 37','E','C','1','2023-06-30','11:10:07',35,'P','P',70,0,'N'),(424,1,'0094','2023-05-29','03:45:57','CC','1098705069','VANESSA ROSALES','3216999273','','CALLE 3 # 8 - 61','E','C','1','2023-06-05','03:10:24',21,'P','P',71,3528,'N'),(425,1,'0094','2023-05-29','03:58:39','CC','39017149','LIDA PATRICIA MENSESES','','','Calle 2 # 11 - 27','E','C','1','2023-06-30','10:55:57',41,'P','P',72,0,'N'),(426,2,'0023','2023-05-31','09:17:47','CC','85435794','YAMEL BAYTER','3145931044','','KRA. 11 # 2A-  2','E','C','1','2023-06-05','03:02:55',9,'P','Q',227,4718,'N'),(427,2,'0023','2023-06-01','08:52:44','CC','1081395016','Sor. ANA LUCIA ALVIRA','3156444593','','Calle 8 # 20A - 27','E','C','1','2023-06-07','08:47:15',8,'P','Q',228,2143,'N'),(428,1,'0094','2023-06-07','03:26:44','CC','39014115','ANA MARIA CAARRASQUILLA','3016977392','','CALLE 6 # 7 - 67','E','C','1','2023-07-11','09:05:35',7,'P','P',73,0,'N'),(429,1,'0094','2023-06-07','03:39:14','CC','72270557','MICHEL RODRIGUEZ','3008010288','','Carrera 2A. # 12- 3','E','C','1','2023-06-30','10:58:15',12,'P','P',74,0,'N'),(430,2,'0023','2023-06-07','03:57:46','CC','1098676165','SINDY VANESSA GOMEZ','3215418504','','CALLE 6 # 6 - 15','E','C','1','2023-06-27','09:41:06',7,'P','Q',229,0,'N'),(431,2,'0023','2023-06-07','04:45:37','CC','13877562','JOSE CORDERO','3225547362','','CARRERA 2A- # 16- 62','E','C','1','2023-06-27','10:02:28',17,'P','Q',230,5236,'N'),(432,2,'0023','2023-06-23','04:00:29','CC','85438131','LUIS C. MANRRIQUE','3135155573','','CALLE  14 Y 15 CRA. 3','E','C','1','2023-06-27','09:52:13',3,'P','Q',231,0,'N'),(433,2,'0023','2023-06-23','04:09:28','CC','9138422','WILFRIDO AGAMES','3104969320','','CARRERA 5 ENTRE CALLES 12 Y 13','E','C','1','2023-06-27','10:13:33',15,'P','Q',232,0,'N'),(434,2,'0023','2023-06-26','02:52:20','CC','39011006','LUISA SORAYA PALOMINO','3133862706','','Cra. 20 #  9 - 9','E','C','1','2023-06-27','10:37:36',35,'P','Q',233,5520,'N'),(435,2,'0023','2023-06-26','03:02:22','CC','12581135','WILLIAM RANGEL','3215661006','','CRA 19 A # 9- 18','E','C','1','2023-06-27','10:23:01',35,'P','Q',234,8904,'N'),(436,1,'0043','2023-06-26','04:37:56','CC','12579033','ROBINSON RODRIGUEZ C.','3226436738','','Calle 11 # 10 - 39','E','C','1','2023-07-11','09:58:29',19,'P','Q',235,0,'N'),(437,1,'0095','2023-06-30','02:48:33','CC','12400373','FERDINANDO GALVIS','3003833919','','Carrera 11 #  38 local 4','E','C','1','2023-07-11','09:30:22',12,'P','Q',236,0,'N'),(438,1,'0094','2023-06-30','03:26:21','CC','18926815','ALFONSO ANTELIZ','3215396547','','CALLE 7 # 4 - 05','E','C','1','2023-07-10','09:54:21',7,'P','P',75,0,'N'),(439,2,'0023','2023-07-04','02:51:17','CC','','ANDRES QUIROZ','3004915514','','CALLE 12 # 2A- 12','E','C','1','2023-07-11','10:07:37',12,'P','Q',237,6798,'N'),(440,1,'0094','2023-07-04','03:13:51','CC','9076299','MANUEL QUIROZ SALAZAR','3122153141','','CARRERA 2 # 15 - 43','E','C','1','2023-07-18','03:32:26',17,'P','P',76,5039,'N'),(441,1,'0094','2023-07-05','09:30:13','CC','39011560','AMILDE DIAZ DE RODRIGUEZ','3124833197','','Carrera 13 # 1 - 16','E','C','1','2023-07-17','09:30:40',33,'P','P',77,0,'N'),(442,1,'0094','2023-07-05','09:49:28','CC','12578317','ANGEL CAMPUZANO CANAVAL','','','Carrera 1ª B. # 16 - 33','E','C','1','2023-07-17','10:00:02',23,'P','R',161,0,'N'),(443,1,'0094','2023-07-05','10:09:25','CC','85435891','RICHAR PONTON','3107096139','','Carrera 16 # 12 - 40','E','C','1','2023-07-17','09:53:31',25,'P','R',162,0,''),(444,1,'0094','2023-07-06','09:30:28','CC','39013519','MARIA DEL PILAR LOBO R.','3205101483','','CALLE 12 # 5 - 28','E','C','1','2023-07-17','09:48:34',15,'P','R',163,0,'N'),(445,2,'0023','2023-07-10','09:40:59','CC','40977293','FRANCIA RIOS','323465887','','CALLE 1 # 14 - 71','E','C','1','2023-07-11','09:00:10',2,'P','Q',238,0,'N'),(446,1,'0094','2023-07-10','11:05:12','CC','8804','LUZ NORYS RANGEL','3217709936','','Carrera 19 # 9 - 114','E','C','1','2023-08-04','10:15:35',35,'P','P',78,8804,'N'),(447,1,'0094','2023-07-10','02:25:41','CC','39013083','ANA FLOREZ','3145197839','','CALLE 5 # 14 - 66','E','C','1','2023-07-17','09:45:02',4,'P','R',164,0,'N'),(448,2,'0122','2023-07-10','02:51:17','CC','39015322','CLAUDIA FLOREZ','3126512829','','Carrera 12  3  91','E','C','1','2023-08-04','10:03:46',24,'P','Q',239,4773,'N'),(449,2,'0023','2023-07-13','08:57:52','CC','85438051','CIRO ORTIZ MADRID','3226398939','','Carrera 20 entre calles 8 y 9','E','C','1','2023-07-31','10:09:22',8,'P','Q',240,7961,'N'),(450,2,'0023','2023-07-14','02:48:27','CC','3774','JANETH LOPEZ','3107273094','','CALLE 5 # 7 - 18','E','C','1','2023-09-06','03:29:15',36,'P','Q',241,0,'N'),(451,2,'0023','2023-07-14','03:21:55','CC','12582282','JAVIER GARCES','3145390983','','CALLE 5 # 9 - 91','E','C','1','2023-07-18','03:50:28',36,'P','Q',242,1820,'N'),(452,2,'0023','2023-07-18','09:46:52','CC','85435036','GUSTAVO MARTINEZ','3126611725','','Calle 15 con cra.    6 # 05','E','C','1','2023-10-03','04:01:32',3,'P','Q',243,3042,'N'),(453,2,'0023','2023-07-31','02:46:25','CC','26923335','ENA LUZ SUAREZ','3157920441','','CALLE 1º # 10 - 86','E','C','1','2023-08-04','09:54:48',13,'P','Q',244,2305,'N'),(454,2,'0023','2023-07-31','03:00:59','CC','85442007','JOSE JAVIER PALOMINO','3116628549','','Carrera 2 # 6- 18','E','C','1','2023-08-04','09:34:46',12,'P','Q',245,5077,'N'),(455,1,'0094','2023-08-01','08:38:38','CC','12400373','FERDINANDO GALVIS','3003833919','','CALLE 5 # 6 - 89','E','C','1','2023-08-04','10:19:58',7,'P','P',79,3768,'N'),(456,2,'0023','2023-08-02','09:12:26','CC','39010823','LUZ ESTELA RADA','3208307186','','CALLE 9 # 18A - 03','E','C','1','2023-11-21','11:00:14',20,'P','Q',246,0,'N'),(457,2,'0023','2023-08-02','09:26:42','CC','85435794','YAMIL BAYTER LISSA','3145931044','','Carrera 11 # 2A. - 21','E','C','1','2023-09-06','03:51:37',9,'P','Q',247,0,'N'),(458,1,'0094','2023-08-09','10:03:23','CC','1085045659','ALVARO LUIS LLANES PEDROZO','3126089595','','CALLE 13 CON CRA. 11 # 74','E','C','1','2023-09-07','10:37:37',18,'P','P',80,0,'N'),(459,1,'0043','2023-08-09','10:21:05','CC','39012979','ADALEYNIS AVILES R.','30080803999','','CALLE  4 # 12- 16','E','C','1','2023-09-06','04:22:25',24,'P','Q',248,0,'N'),(460,2,'0023','2023-08-15','09:13:02','CC','12575950','WILFRIDO COGOLLO','3213301661','','CALLE 5  # 9 - 88','E','C','1','2023-09-06','04:37:47',36,'P','Q',249,0,'N'),(461,2,'0042','2023-08-16','08:55:31','CC','73102971','SANTANDER RICAURTE JIMENEZ','3114144513','','CALLE 1B # 8 - 56','E','C','1','2023-09-07','09:31:49',21,'P','Q',250,0,'N'),(462,2,'0023','2023-08-16','09:23:28','CC','39017283','DAMITH RANGEL R.','3013806049','','CARRERA 16 # 9 - 41','E','C','1','2023-09-07','09:57:59',39,'P','Q',251,0,'N'),(463,1,'0094','2023-08-30','09:23:05','CC','39009993','EMILSE M. AVENDAÑO NORIEGA','3106575876','','Carrera 2A # 13 -3','E','C','1','2023-09-06','03:57:48',17,'P','P',81,0,'N'),(464,2,'0042','2023-08-30','09:54:53','CC','12400458','JULIO JAVIER GAEZZO GALEZZO','3118331780','','Carrera 11 # 3 - 39','E','C','1','2023-10-03','02:59:18',36,'P','Q',252,4726,'N'),(465,2,'0023','2023-08-30','10:11:38','CC','85442612','JAIME VILLACOB GUERRA','3016628911','','Carrera 5  # 6 - 42','E','C','1','2023-09-07','09:40:45',7,'P','Q',253,0,'N'),(466,1,'0094','2023-09-01','08:33:17','CC','39006413','EDITH SOFIA  RAMOS AMARIS','3103542794','','Calle 5 # 9 - 63','E','C','1','2023-09-07','10:08:11',36,'P','P',82,0,'N'),(467,1,'0094','2023-09-01','08:41:07','CC','88280345','ELKIN  VARGAS  V.','3118011023','','Carrera 5 # 13 - 19','E','C','1','2023-09-07','10:20:27',15,'P','R',165,0,'N'),(468,1,'0094','2023-09-01','08:50:31','CC','49763706','MARELVIS GUZMAN DIAZ','3005775660','','Calle 11 # 2 - 48','E','C','1','2023-09-07','10:40:52',12,'P','R',166,0,'N'),(469,2,'0023','2023-09-01','02:41:47','CC','85436207','SIGILFREDO RIVERA','3156753921','','Calle 8 con cra. 2 esquina','E','C','1','2023-09-07','09:50:17',12,'P','Q',254,0,'N'),(470,2,'0023','2023-09-01','03:44:01','CC','39010709','LILIANA BAYTER','3116677317','','CALLE 4 #11-2','E','C','1','2023-09-07','10:18:06',24,'P','Q',255,0,'N'),(471,2,'0023','2023-09-01','04:02:39','CC','12584780','ALVARO ROSALES','3114010823','','CARRERA 6 #2-43','E','C','1','2023-09-07','10:31:30',21,'P','Q',256,0,'N'),(472,2,'0023','2023-09-01','04:13:29','CC','39010584','NELSY VILLAFAÑE Z.','3108394871','','CALLE 4 #11-11','E','C','1','2023-09-07','10:46:49',24,'P','Q',257,0,'N'),(473,1,'0094','2023-09-05','04:40:44','CC','12401635','JUAN CARLOS  SILVA M.','3164533234','','Calle  2 # 13A - 0','E','C','1','2023-10-06','09:29:29',41,'P','P',83,447,'N'),(474,2,'0023','2023-09-05','04:58:42','CC','39006875','CECILIA E. AMARIS','','','Entre Calles 2A y 2 con Cra. 9','E','C','1','2023-09-07','10:04:52',36,'P','Q',258,0,'N'),(475,1,'0043','2023-09-06','08:27:52','CC','57416621','YOMAIRA  BORJA B.','3126809768','','Carrera 2 # 11 - 40','E','C','1','2023-09-06','04:08:13',12,'P','Q',259,0,'N'),(476,2,'0023','2023-09-13','09:12:28','CC','12402046','MATEO AMARIS BARRIOS','3145121719','','CALLE 10 # 9 - 48','E','C','1','2023-10-04','10:24:24',27,'P','Q',260,245,'N'),(477,2,'0023','2023-09-13','09:53:10','CC','3966579','LUIS FELIPE RODRIGUEZ H.','3218290646','','CALLE 7A.# 15 - 30','E','C','1','2023-10-03','03:12:42',37,'P','Q',261,3768,'N'),(478,1,'0043','2023-09-13','10:20:33','CC','37752710','AMELIS ALTAMAR','3015928207','','Calle 2 entre carreras 12 y 13','E','C','1','2023-11-16','08:51:26',41,'P','Q',262,0,'N'),(479,2,'0023','2023-09-13','10:57:59','CC','85441256','EGIDIO RAMIREZ OSPINO','3169312633','','CALLE 1  # 9 - 72','E','C','1','2023-11-16','09:27:02',13,'P','Q',263,0,'N'),(480,2,'0023','2023-09-14','09:56:56','CC','12583079','VOLMAR A. LEIRA GARCIA','3244847093','','Clle. 11 entre Carreras 7  y 8','E','C','1','2023-10-04','10:15:46',15,'P','Q',264,5520,'N'),(481,2,'0023','2023-09-14','10:42:47','CC','12400540','BORIS A. MARTINEZ','3118018756','','Carrera 4 # 17 - 37','E','C','1','2023-11-16','10:31:26',3,'P','Q',265,0,'N'),(482,2,'0023','2023-09-14','02:49:47','CC','','MANUEL QUIROS  SALAZAR','3122153141','','Carrera 3 # 18 - 04','E','C','1','2023-10-04','10:33:33',3,'P','Q',266,5351,'N'),(483,1,'0094','2023-10-02','10:22:50','CC','12400373','FERDINANDO GALVIS','3003833919','','Carrera 3 # 13 - 42 Apto. 3','E','C','1','2023-10-06','09:59:07',15,'P','P',84,10553,'N'),(484,1,'0094','2023-10-02','10:33:12','CC','12400373','FERDINANDO GALVIS','3003833919','','Carrera 3 # 13 - 42','E','C','1','2023-10-06','10:03:10',15,'P','P',85,5314,'N'),(485,2,'0023','2023-10-02','10:54:59','CC','','CASTA LINAREZ PEREZ','','','Carrera 4 # 14 - 35','E','C','1','2023-10-03','03:39:38',15,'P','Q',267,5402,'N'),(486,2,'0023','2023-10-03','09:09:01','CC','','LEONIT RODRIGUEZ PEREZ','3046327790','','Calle 16 y 17 con Carera 1','E','C','1','2023-10-04','10:05:26',17,'P','Q',268,9953,'N'),(487,2,'0023','2023-10-03','09:37:15','CC','39022728','LILIANA ARIAS PERTUZ','3145238687','','Calle 8 # 7 - 62','E','C','1','2023-11-16','09:04:43',27,'P','Q',269,0,'N'),(488,1,'0094','2023-10-03','09:49:58','CC','5011401','SAUL SEGOVIA ZAMBRANO','3114419942','','Calle 1A. # 14 - 56','E','C','1','2023-10-06','09:43:02',2,'P','P',86,6781,'N'),(489,1,'0094','2023-10-03','10:06:34','CC','26741269','FELICIANA PEREZ DE HERNANDEZ','','','Calle 2 #  7 - 77','E','C','1','2023-10-06','09:36:43',21,'P','P',87,3293,'N'),(490,2,'0023','2023-10-05','10:14:36','CC','39006477','JULIANA CAMPUZANO','3126237798','','Calle 10 entre Cras. 10 y 11','E','C','1','2023-11-17','02:28:56',10,'P','Q',270,0,'N'),(491,1,'0043','2023-10-05','10:35:31','CC','39013165','SILVANA AVILES C.','3146497341','','Calle 3 # 12 - 23','E','C','1','2023-11-16','10:18:28',41,'P','Q',271,0,'N'),(492,1,'0043','2023-10-05','10:50:10','CC','85272421','JOSE CARDOZO','3138961254','','Calle 10 # 18 - 59','E','C','1','2023-11-17','11:24:23',35,'P','Q',272,0,'N'),(493,2,'0023','2023-11-07','09:22:18','CC','944719','ESTEBAN PIMIENTA VILLARREAL','3004156343','','Carrera 19A  # 9 - 40','E','C','1','2023-11-16','10:55:17',35,'P','Q',273,0,'N'),(494,2,'0023','2023-11-07','10:11:53','CC','39006477','SORAYA PALOMINO','3133862706','','Carrera 20B # 9D - 76','E','C','1','2023-11-16','11:09:29',35,'P','Q',274,0,'N'),(495,1,'0125','2023-11-07','10:33:37','CC','1085100577','INGRIS LOZANO','3207524409','','Carrera 1B # 14 - 62','E','C','1','2023-11-16','11:25:53',17,'P','R',167,0,'N'),(496,2,'0023','2023-11-07','11:02:06','CC','17809421','GALO JOSE PUENTE V.','323437857','','Carrera 19 # 4 - 85','E','C','1','2023-11-16','02:53:38',36,'P','Q',275,0,'N'),(497,2,'0042','2023-11-07','11:20:26','CC','12582472','JOSE LUIS BARBA','3114110799','','Calle 4 # 12 - 77','E','C','1','2023-11-16','03:53:43',24,'P','Q',276,0,'N'),(498,2,'0023','2023-11-08','09:18:15','CC','79008882','GLADYS CUELLO','3107215911','','Carrera 19 # 9-38','E','C','1','2023-11-17','08:53:07',35,'P','Q',277,0,'N'),(499,2,'0023','2023-11-08','09:35:22','CC','39010877','ALIX MORALES DIAZ','3218518048','','Carrera 19 # 7 - 35','E','C','1','2023-11-16','04:02:21',20,'P','Q',278,0,'N'),(500,1,'0094','2023-11-08','09:46:07','CC','85272033','ELMER AVILA','3123954185','','Carrera 3 # 18 - 40','E','C','1','2023-11-17','10:49:21',3,'P','R',168,0,'N'),(501,1,'0094','2023-11-08','10:11:51','CC','12583007','JUNIS PEDROZO ZAMBRANO','','','Calle 10 # 6 - 03','E','C','1','2023-11-17','11:07:57',15,'P','P',88,0,'N'),(502,1,'0043','2023-11-08','10:40:59','CC','12575999','JAIME URIBE','3113569031','','Calle 8 # 5 - 35','E','C','1','2023-11-16','04:16:09',27,'P','Q',279,0,'N'),(503,1,'0094','2023-11-08','10:53:09','CC','53120688','ERICKA PATRICIA VIDES NARVAEZ','3233603828','','Calle 2 # 6 - 108','E','C','1','2023-11-17','11:01:05',21,'P','P',89,0,'N'),(504,1,'0043','2023-11-08','11:07:12','CC','57416624','YOMAIRA BORJA','3126809768','','Carrera 2A # 11 - 40','E','C','1','2023-11-17','10:39:12',12,'P','Q',280,0,'N'),(505,1,'0043','2023-11-08','11:15:56','CC','5011401','JAIRO MOYA PIANETA','3107459954','','Calle  10 # 18 - 159','E','C','1','2023-11-16','04:26:42',35,'P','Q',281,0,'N'),(506,2,'0023','2023-11-08','11:25:42','CC','39022161','YAMILE RICARDO OCHOA','3148125768','','Calle 14 con carrera 1°','E','C','1','2023-11-16','04:51:17',17,'P','Q',282,0,'N'),(507,2,'0042','2023-11-08','03:20:24','CC','1085034180','ANA MARIA ALVARADO','3216093508','','Calle 10 entre carreras 8 y 9','E','C','1','2023-11-16','04:42:13',15,'P','Q',283,0,'N'),(508,2,'0023','2023-11-08','04:05:13','CC','1003247008','RONALD J. NUÑEZ G.','3145287756','','Calle 7 # 20 - 138','E','C','1','2023-11-17','10:36:53',30,'P','Q',284,0,'N'),(509,2,'0090','2023-11-08','04:18:49','CC','39817714','GERMITH HERRERA PIMIENTA','3108396020','','Carrera 9 # 4 - 17','E','C','1','2023-11-17','10:02:33',36,'P','Q',285,0,'N'),(510,1,'0094','2023-11-08','04:29:40','CC','12577222','ISRAEL SEGUNDO SALAS MELENDEZ','3152312910','','Carrera 19A  # 7 - 05','E','C','1','2023-11-17','10:56:02',8,'P','R',169,0,'N'),(511,1,'0094','2023-11-08','04:37:55','CC','85440654','EULISE VILLARREAL  P.','3137448418','','Calle 5 # 7 - 20','E','C','1','2023-11-17','10:09:01',7,'P','R',170,0,'N'),(512,1,'0043','2023-11-08','04:48:31','CC','85272421','JOSE CARDOZA','3138961254','','Calle 10 # 18 - 59','E','C','1','2023-11-21','11:02:26',35,'P','Q',286,0,'N'),(513,1,'0094','2023-11-08','04:59:51','CC','1085040868','JOSE LUIS RANGEL C.','3187107426','','Calle  2A # 7 - 79','E','C','1','2023-11-17','10:17:39',35,'P','R',171,0,'N'),(514,1,'0050','2023-11-27','10:27:21','CC','12579870','ROGELIO JIMENEZ MERCADO','3145372884','','Calle 2 # 6 -50','E','C','1','2023-11-30','03:40:14',21,'P','Q',287,0,'N'),(515,2,'0023','2023-11-27','10:57:40','CC','19141657','CRISTIAN FLOREZ M.','','','calle 10 # 4 - 26','E','C','1','2023-11-30','03:29:33',15,'P','Q',288,0,''),(516,2,'0023','2023-11-27','11:05:51','CC','85438025','ENRIQUE OSPINA NUMA','3122583988','','Calle 6 entreCras. 3 y 4 esquina','E','C','1','2023-11-30','03:16:55',7,'P','Q',289,0,'N'),(517,2,'0023','2023-11-27','11:15:37','CC','25852568','HELENA DEL  TORO','25852568','','Calle 2 # 6 -37','E','C','1','2023-11-30','03:08:57',21,'P','Q',290,0,'N'),(518,2,'0023','2023-11-27','02:51:30','CC','1216974244','ANDRES F. COHEN GUTIERREZ','3022109538','','Calle 9 # 4 - 65','E','P','','0000-00-00','00:00:00',27,'P','Q',291,0,''),(519,2,'0023','2023-11-27','02:51:30','CC','1216974244','ANDRES F. COHEN GUTIERREZ','3022109538','','Calle 9 # 4 - 65','E','C','1','2023-11-30','02:45:36',27,'P','Q',291,0,'N'),(520,2,'0023','2023-11-27','03:04:00','CC','5424456','GILBERTO OJEDA','3134580684','','Calle  10 # 4 - 66','E','C','1','2023-11-30','11:23:33',15,'P','Q',292,0,'N'),(521,2,'0023','2023-11-28','09:10:35','CC','12577442','JOSE JESUS BELEÑO PADILLA','','','Calle 4 # 10 - 45','E','C','1','2023-11-30','10:07:42',36,'P','Q',293,0,'N'),(522,2,'0042','2023-11-28','09:25:02','CC','39010161','DIVA ISABEL KING ANGULO','3116897171','','Calle 2 # 11 - 60','E','C','1','2023-11-30','11:13:08',41,'P','Q',294,0,'N'),(523,2,'0023','2023-11-28','09:44:35','CC','1085036379','LAURA MARIA CANEDO  GUTIERREZ','3113416966','','Calle 2 entre  Cras. 12 y 13','E','C','1','2023-11-30','11:31:11',41,'P','Q',295,0,'N'),(524,2,'0023','2023-11-28','10:19:47','CC','39012424','OVIDIA QUIROZ GONZALEZ','3046490684','','Carrera 9 # 8 - 19','E','C','1','2023-11-30','02:52:14',27,'P','Q',296,0,'N'),(525,1,'0094','2023-11-28','10:51:39','CC','26741269','FELICIANA PEREZ DE HERNANDEZ','3116842369','','Calle 2 #  7 - 77','E','C','1','2023-11-30','10:05:01',21,'P','P',91,0,'N'),(526,1,'0094','2023-11-28','11:07:03','CC','39068290','LILA GAMEZ','3043810164','','Carrera 9 # 5 - 01 Apto. 2','E','C','1','2023-11-30','09:55:23',36,'P','P',92,0,'N'),(527,2,'0023','2023-11-28','11:22:27','CC','6813148','ALVARO SANCHEZ MENCO','3114118501','','Carrera 13 # con calle 4','E','C','1','2023-11-30','11:47:40',4,'P','Q',297,0,'N'),(528,2,'0023','2023-11-28','03:04:53','CC','1085049209','ROYER MARTINEZ','3187396010','','Calle 10 # 9 - 87','E','C','1','2023-11-30','02:30:53',40,'P','Q',298,0,'N'),(529,1,'0082','2023-11-28','03:20:46','CC','18967820','ANTONIO QUINTERO BLANCO','3126983388','','Calle 11 # 2- 48 local 1','E','C','1','2023-11-30','10:12:30',12,'P','R',172,0,'N'),(530,1,'0082','2023-11-28','03:44:55','CC','85434416','LUIS  SANCHEZ','3135713589','','Calle 2A # 8 - 23','E','C','1','2023-11-30','02:37:55',21,'P','R',173,0,'N'),(531,2,'0023','2023-11-28','04:09:25','CC','12580644','ELOY  FONTALVO','3126511039','','Calle 9A # 18 B- 03','E','C','1','2023-11-30','10:10:11',20,'P','Q',299,0,'N'),(532,1,'0094','2023-11-28','04:55:49','CC','3907089','ROSARIO CAMELO DE LEON','3217637572','','Calle 2A #  9 - 63','E','P','','0000-00-00','00:00:00',9,'P','P',93,0,''),(533,2,'0023','2023-11-29','03:18:21','CC','85441247',' ALFREDER ESCOBAR','3127429021','','Calle 14 con Carrera 3 esquina','E','C','1','2023-11-30','03:46:08',15,'P','Q',300,0,'N');
/*!40000 ALTER TABLE `tramites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tuberias`
--

DROP TABLE IF EXISTS `tuberias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tuberias` (
  `tb_numero` int(9) NOT NULL,
  `tb_codpro` char(2) NOT NULL,
  `tb_codduc` char(2) NOT NULL,
  `tb_codmat` char(2) NOT NULL,
  `tb_seccion` char(2) NOT NULL,
  `tb_cantid` float(9,2) NOT NULL DEFAULT '0.00',
  `tb_diamet` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`tb_numero`,`tb_codpro`,`tb_codduc`,`tb_codmat`),
  KEY `tb_numero` (`tb_numero`),
  KEY `tb_codpro` (`tb_codpro`),
  KEY `tb_codduc` (`tb_codduc`),
  KEY `tb_codmat` (`tb_codmat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tuberias`
--

LOCK TABLES `tuberias` WRITE;
/*!40000 ALTER TABLE `tuberias` DISABLE KEYS */;
INSERT INTO `tuberias` (`tb_numero`, `tb_codpro`, `tb_codduc`, `tb_codmat`, `tb_seccion`, `tb_cantid`, `tb_diamet`) VALUES (13,'12','12','14','1',9.00,8.00),(10,'2','3','1','1',2.00,1.00),(18,'2','3','1','1',1.00,3.00),(14,'12','12','14','1',9.00,8.00),(34,'4','3','1','1',2.00,3.00),(68,'13','12','1','1',1.00,6.00);
/*!40000 ALTER TABLE `tuberias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tvehiculos`
--

DROP TABLE IF EXISTS `tvehiculos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tvehiculos` (
  `tv_numero` int(9) NOT NULL,
  `tv_codveh` char(6) NOT NULL,
  `tv_fecini` date DEFAULT NULL,
  `tv_horini` time DEFAULT NULL,
  `tv_fecfin` date DEFAULT NULL,
  `tv_horfin` time DEFAULT NULL,
  `tv_vlract` float(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`tv_numero`,`tv_codveh`),
  KEY `tv_numero` (`tv_numero`),
  KEY `tv_codveh` (`tv_codveh`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tvehiculos`
--

LOCK TABLES `tvehiculos` WRITE;
/*!40000 ALTER TABLE `tvehiculos` DISABLE KEYS */;
INSERT INTO `tvehiculos` (`tv_numero`, `tv_codveh`, `tv_fecini`, `tv_horini`, `tv_fecfin`, `tv_horfin`, `tv_vlract`) VALUES (120,'100','2022-03-17','08:40:00','2022-03-17','09:30:00',83333.33),(121,'100','2022-03-18','08:00:00','2022-03-18','09:40:00',166666.67),(123,'100','2022-03-21','08:00:00','2022-03-21','09:30:00',150000.00),(499,'100','2023-10-14','09:30:00','2023-10-14','10:00:00',50000.00),(509,'CARM','2023-10-25','10:00:00','2023-10-25','10:30:00',0.00);
/*!40000 ALTER TABLE `tvehiculos` 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 `vehiculo`
--

DROP TABLE IF EXISTS `vehiculo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehiculo` (
  `vh_codveh` char(6) NOT NULL,
  `vh_descri` char(40) NOT NULL DEFAULT '',
  `vh_vlrhor` decimal(9,2) NOT NULL DEFAULT '0.00',
  `vh_vlrrec` decimal(9,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`vh_codveh`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehiculo`
--

LOCK TABLES `vehiculo` WRITE;
/*!40000 ALTER TABLE `vehiculo` DISABLE KEYS */;
INSERT INTO `vehiculo` (`vh_codveh`, `vh_descri`, `vh_vlrhor`, `vh_vlrrec`) VALUES ('100','EQUPO VACTOR',100000.00,20.00),('101','RETROESCABADORA CASE 210',0.00,0.00),('CARM','CARROMOTO',0.00,0.00),('105','PULIDORA PEQUEÑA',0.00,0.00),('103','BOMBA SUMERGIBLE',0.00,0.00),('104','PULIDORA GRANDE',0.00,0.00),('102','TALADRO',0.00,0.00);
/*!40000 ALTER TABLE `vehiculo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'antsoftw_banco_operativo'
--

--
-- Dumping routines for database 'antsoftw_banco_operativo'
--
/*!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:29:01
