text: -- phpMyAdmin SQL Dump
  -- version 4.6.5.2
  -- https://www.phpmyadmin.net/
  --
  -- Servidor: 127.0.0.1
  -- Tiempo de generación: 26-06-2017 a las 05:39:27
  -- Versión del servidor: 10.1.21-MariaDB
  -- Versión de PHP: 5.6.30
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Base de datos: `basicosistema`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `admins`
  --
  
  CREATE TABLE `admins` (
    `id` bigint(20) NOT NULL,
    `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `usuario` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `clave` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `estado` tinyint(4) NOT NULL DEFAULT '1'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `admins`
  --
  
  INSERT INTO `admins` (`id`, `nombre`, `email`, `usuario`, `clave`, `estado`) VALUES
  (1, 'Javier Cruz', 'jcjavier@hotmail.com', 'jcjavier', 'asdf1234', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `ciudades`
  --
  
  CREATE TABLE `ciudades` (
    `id` bigint(20) NOT NULL,
    `departamento_id` bigint(20) NOT NULL,
    `ciudad` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `codigo` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
    `estado` tinyint(4) NOT NULL DEFAULT '1',
    `creado` datetime NOT NULL,
    `editado` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `ciudades`
  --
  
  INSERT INTO `ciudades` (`id`, `departamento_id`, `ciudad`, `codigo`, `estado`, `creado`, `editado`) VALUES
  (1, 1, 'SAN ROQUE', '05670', 1, '2017-06-20 02:31:30', NULL),
  (2, 1, 'SAN VICENTE', '05674', 1, '2017-06-20 02:31:30', NULL),
  (3, 1, 'SEGOVIA', '05736', 1, '2017-06-20 02:31:30', NULL),
  (4, 1, 'SONSON', '05756', 1, '2017-06-20 02:31:30', NULL),
  (5, 1, 'SOPETRAN', '05761', 1, '2017-06-20 02:31:30', NULL),
  (6, 1, 'TURBO', '05837', 1, '2017-06-20 02:31:30', NULL),
  (7, 1, 'URAMITA', '05842', 1, '2017-06-20 02:31:30', NULL),
  (8, 1, 'VIGIA DEL FUERTE', '05873', 1, '2017-06-20 02:31:30', NULL),
  (9, 1, 'YOLOMBO', '05890', 1, '2017-06-20 02:31:30', NULL),
  (10, 1, 'GUARNE', '05318', 1, '2017-06-20 02:31:31', NULL),
  (11, 1, 'GUATAPE', '05321', 1, '2017-06-20 02:31:31', NULL),
  (12, 1, 'HELICONIA', '05347', 1, '2017-06-20 02:31:31', NULL),
  (13, 1, 'HISPANIA', '05353', 1, '2017-06-20 02:31:31', NULL),
  (14, 1, 'ITAGUI', '05360', 1, '2017-06-20 02:31:31', NULL),
  (15, 1, 'ITUANGO', '05361', 1, '2017-06-20 02:31:31', NULL),
  (16, 1, 'JARDIN', '05364', 1, '2017-06-20 02:31:31', NULL),
  (17, 1, 'JERICO', '05368', 1, '2017-06-20 02:31:31', NULL),
  (18, 1, 'LA CEJA', '05376', 1, '2017-06-20 02:31:31', NULL),
  (19, 1, 'LA ESTRELLA', '05380', 1, '2017-06-20 02:31:31', NULL),
  (20, 1, 'LA PINTADA', '05390', 1, '2017-06-20 02:31:31', NULL),
  (21, 1, 'LA UNION', '05400', 1, '2017-06-20 02:31:31', NULL),
  (22, 1, 'LIBORINA', '05411', 1, '2017-06-20 02:31:31', NULL),
  (23, 1, 'MACEO', '05425', 1, '2017-06-20 02:31:31', NULL),
  (24, 1, 'MARINILLA', '05440', 1, '2017-06-20 02:31:31', NULL),
  (25, 1, 'MONTEBELLO', '05467', 1, '2017-06-20 02:31:31', NULL),
  (26, 1, 'MURINDO', '05475', 1, '2017-06-20 02:31:31', NULL),
  (27, 1, 'MUTATA', '05480', 1, '2017-06-20 02:31:31', NULL),
  (28, 1, 'NARIÃ‘O', '05483', 1, '2017-06-20 02:31:31', NULL),
  (29, 1, 'NECOCLI', '05490', 1, '2017-06-20 02:31:32', NULL),
  (30, 1, 'OLAYA', '05501', 1, '2017-06-20 02:31:32', NULL),
  (31, 1, 'PUEBLORRICO', '05576', 1, '2017-06-20 02:31:32', NULL),
  (32, 1, 'PUERTO BERRIO', '05579', 1, '2017-06-20 02:31:32', NULL),
  (33, 1, 'PUERTO NARE', '05585', 1, '2017-06-20 02:31:32', NULL),
  (34, 1, 'PUERTO TRIUNFO', '05591', 1, '2017-06-20 02:31:32', NULL),
  (35, 1, 'RIONEGRO', '05615', 1, '2017-06-20 02:31:32', NULL),
  (36, 1, 'SABANALARGA', '05628', 1, '2017-06-20 02:31:32', NULL),
  (37, 1, 'SABANETA', '05631', 1, '2017-06-20 02:31:32', NULL),
  (38, 1, 'SALGAR', '05642', 1, '2017-06-20 02:31:32', NULL),
  (39, 1, 'SAN FRANCISCO', '05652', 1, '2017-06-20 02:31:32', NULL),
  (40, 1, 'SAN JERONIMO', '05656', 1, '2017-06-20 02:31:32', NULL),
  (41, 1, 'SAN JOSE DE LA MONTAÃ‘A', '05658', 1, '2017-06-20 02:31:32', NULL),
  (42, 1, 'SAN JUAN DE URABA', '05659', 1, '2017-06-20 02:31:32', NULL),
  (43, 1, 'SAN PEDRO DE LOS MILAGROS', '05664', 1, '2017-06-20 02:31:32', NULL),
  (44, 1, 'SAN PEDRO DE URABA', '05665', 1, '2017-06-20 02:31:32', NULL),
  (45, 1, 'SAN RAFAEL', '05667', 1, '2017-06-20 02:31:32', NULL),
  (46, 1, 'SANTA BARBARA', '05679', 1, '2017-06-20 02:31:32', NULL),
  (47, 1, 'SANTA ROSA DE OSOS', '05686', 1, '2017-06-20 02:31:32', NULL),
  (48, 1, 'SANTO DOMINGO', '05690', 1, '2017-06-20 02:31:32', NULL),
  (49, 1, 'SANTUARIO', '05697', 1, '2017-06-20 02:31:32', NULL),
  (50, 1, 'TAMESIS', '05789', 1, '2017-06-20 02:31:32', NULL),
  (51, 1, 'TARAZA', '05790', 1, '2017-06-20 02:31:32', NULL),
  (52, 1, 'TARSO', '05792', 1, '2017-06-20 02:31:32', NULL),
  (53, 1, 'TITIRIBI', '05809', 1, '2017-06-20 02:31:32', NULL),
  (54, 1, 'TOLEDO', '05819', 1, '2017-06-20 02:31:32', NULL),
  (55, 1, 'URRAO', '05847', 1, '2017-06-20 02:31:33', NULL),
  (56, 1, 'VALDIVIA', '05854', 1, '2017-06-20 02:31:33', NULL),
  (57, 1, 'VALPARAISO', '05856', 1, '2017-06-20 02:31:33', NULL),
  (58, 1, 'VEGACHI', '05858', 1, '2017-06-20 02:31:33', NULL),
  (59, 1, 'VENECIA', '05861', 1, '2017-06-20 02:31:33', NULL),
  (60, 1, 'YALI', '05885', 1, '2017-06-20 02:31:33', NULL),
  (61, 1, 'YARUMAL', '05887', 1, '2017-06-20 02:31:33', NULL),
  (62, 1, 'CAMPAMENTO', '05134', 1, '2017-06-20 02:31:33', NULL),
  (63, 1, 'CAÃ‘ASGORDAS', '05138', 1, '2017-06-20 02:31:33', NULL),
  (64, 1, 'CARACOLI', '05142', 1, '2017-06-20 02:31:33', NULL),
  (65, 1, 'CARAMANTA', '05145', 1, '2017-06-20 02:31:33', NULL),
  (66, 1, 'CAREPA', '05147', 1, '2017-06-20 02:31:33', NULL),
  (67, 1, 'EL CARMEN DE VIBORAL', '05148', 1, '2017-06-20 02:31:33', NULL),
  (68, 1, 'CAROLINA DEL PRINCIPE', '05150', 1, '2017-06-20 02:31:33', NULL),
  (69, 1, 'CAUCASIA', '05154', 1, '2017-06-20 02:31:33', NULL),
  (70, 1, 'CHIGORODO', '05172', 1, '2017-06-20 02:31:33', NULL),
  (71, 1, 'CISNEROS', '05190', 1, '2017-06-20 02:31:34', NULL),
  (72, 1, 'COCORNA', '05197', 1, '2017-06-20 02:31:34', NULL),
  (73, 1, 'CONCEPCION', '05206', 1, '2017-06-20 02:31:34', NULL),
  (74, 1, 'CONCORDIA', '05209', 1, '2017-06-20 02:31:34', NULL),
  (75, 1, 'COPACABANA', '05212', 1, '2017-06-20 02:31:34', NULL),
  (76, 1, 'DABEIBA', '05234', 1, '2017-06-20 02:31:34', NULL),
  (77, 1, 'DON MATIAS', '05237', 1, '2017-06-20 02:31:34', NULL),
  (78, 1, 'EBEJICO', '05240', 1, '2017-06-20 02:31:34', NULL),
  (79, 1, 'EL BAGRE', '05250', 1, '2017-06-20 02:31:34', NULL),
  (80, 1, 'ENVIGADO', '05266', 1, '2017-06-20 02:31:34', NULL),
  (81, 1, 'FREDONIA', '05282', 1, '2017-06-20 02:31:34', NULL),
  (82, 1, 'FRONTINO', '05284', 1, '2017-06-20 02:31:34', NULL),
  (83, 1, 'GIRARDOTA', '05308', 1, '2017-06-20 02:31:34', NULL),
  (84, 1, 'GOMEZ PLATA', '05310', 1, '2017-06-20 02:31:34', NULL),
  (85, 1, 'GRANADA', '05313', 1, '2017-06-20 02:31:34', NULL),
  (86, 1, 'GUADALUPE', '05315', 1, '2017-06-20 02:31:34', NULL),
  (87, 1, 'YONDO', '05893', 1, '2017-06-20 02:31:34', NULL),
  (88, 1, 'ZARAGOZA', '05895', 1, '2017-06-20 02:31:34', NULL),
  (89, 1, 'MEDELLIN', '05001', 1, '2017-06-20 02:31:34', NULL),
  (90, 1, 'ABEJORRAL', '05002', 1, '2017-06-20 02:31:34', NULL),
  (91, 1, 'ABRIAQUI', '05004', 1, '2017-06-20 02:31:34', NULL),
  (92, 1, 'ALEJANDRIA', '05021', 1, '2017-06-20 02:31:34', NULL),
  (93, 1, 'AMAGA', '05030', 1, '2017-06-20 02:31:34', NULL),
  (94, 1, 'AMALFI', '05031', 1, '2017-06-20 02:31:34', NULL),
  (95, 1, 'ANDES', '05034', 1, '2017-06-20 02:31:34', NULL),
  (96, 1, 'ANGELOPOLIS', '05036', 1, '2017-06-20 02:31:34', NULL),
  (97, 1, 'ANGOSTURA', '05038', 1, '2017-06-20 02:31:35', NULL),
  (98, 1, 'ANORI', '05040', 1, '2017-06-20 02:31:35', NULL),
  (99, 1, 'SANTA FE DE ANTIOQUIA', '05042', 1, '2017-06-20 02:31:35', NULL),
  (100, 1, 'ANZA', '05044', 1, '2017-06-20 02:31:35', NULL),
  (101, 1, 'APARTADO', '05045', 1, '2017-06-20 02:31:35', NULL),
  (102, 1, 'ARBOLETES', '05051', 1, '2017-06-20 02:31:35', NULL),
  (103, 1, 'ARGELIA', '05055', 1, '2017-06-20 02:31:35', NULL),
  (104, 1, 'ARMENIA', '05059', 1, '2017-06-20 02:31:35', NULL),
  (105, 1, 'BARBOSA', '05079', 1, '2017-06-20 02:31:35', NULL),
  (106, 1, 'BELMIRA', '05086', 1, '2017-06-20 02:31:35', NULL),
  (107, 1, 'BELLO', '05088', 1, '2017-06-20 02:31:35', NULL),
  (108, 1, 'BETANIA', '05091', 1, '2017-06-20 02:31:35', NULL),
  (109, 1, 'BETULIA', '05093', 1, '2017-06-20 02:31:35', NULL),
  (110, 1, 'CIUDAD BOLIVAR', '05101', 1, '2017-06-20 02:31:35', NULL),
  (111, 1, 'BRICEÃ‘O', '05107', 1, '2017-06-20 02:31:35', NULL),
  (112, 1, 'BURITICA', '05113', 1, '2017-06-20 02:31:35', NULL),
  (113, 1, 'CACERES', '05120', 1, '2017-06-20 02:31:35', NULL),
  (114, 1, 'CAICEDO', '05125', 1, '2017-06-20 02:31:35', NULL),
  (115, 1, 'CALDAS', '05129', 1, '2017-06-20 02:31:35', NULL),
  (116, 1, 'NECHI', '05495', 1, '2017-06-20 02:31:35', NULL),
  (117, 1, 'ENTRERRIOS', '05264', 1, '2017-06-20 02:31:35', NULL),
  (118, 1, 'GIRALDO', '05306', 1, '2017-06-20 02:31:35', NULL),
  (119, 1, 'REMEDIOS', '05604', 1, '2017-06-20 02:31:35', NULL),
  (120, 1, 'EL PEÃ‘OL', '05541', 1, '2017-06-20 02:31:35', NULL),
  (121, 1, 'PEQUE', '05543', 1, '2017-06-20 02:31:35', NULL),
  (122, 1, 'EL RETIRO', '05607', 1, '2017-06-20 02:31:35', NULL),
  (123, 1, 'SAN ANDRES', '05647', 1, '2017-06-20 02:31:35', NULL),
  (124, 1, 'SAN CARLOS', '05649', 1, '2017-06-20 02:31:35', NULL),
  (125, 1, 'SAN LUIS', '05660', 1, '2017-06-20 02:31:36', NULL),
  (126, 2, 'BARRANQUILLA', '08001', 1, '2017-06-20 02:31:36', NULL),
  (127, 2, 'BARANOA', '08078', 1, '2017-06-20 02:31:36', NULL),
  (128, 2, 'CAMPO DE LA CRUZ', '08137', 1, '2017-06-20 02:31:36', NULL),
  (129, 2, 'CANDELARIA', '08141', 1, '2017-06-20 02:31:36', NULL),
  (130, 2, 'GALAPA', '08296', 1, '2017-06-20 02:31:36', NULL),
  (131, 2, 'JUAN DE ACOSTA', '08372', 1, '2017-06-20 02:31:36', NULL),
  (132, 2, 'LURUACO', '08421', 1, '2017-06-20 02:31:36', NULL),
  (133, 2, 'MALAMBO', '08433', 1, '2017-06-20 02:31:36', NULL),
  (134, 2, 'MANATI', '08436', 1, '2017-06-20 02:31:36', NULL),
  (135, 2, 'PALMAR DE VARELA', '08520', 1, '2017-06-20 02:31:36', NULL),
  (136, 2, 'PIOJO', '08549', 1, '2017-06-20 02:31:36', NULL),
  (137, 2, 'POLONUEVO', '08558', 1, '2017-06-20 02:31:36', NULL),
  (138, 2, 'PONEDERA', '08560', 1, '2017-06-20 02:31:36', NULL),
  (139, 2, 'PUERTO COLOMBIA', '08573', 1, '2017-06-20 02:31:36', NULL),
  (140, 2, 'REPELON', '08606', 1, '2017-06-20 02:31:36', NULL),
  (141, 2, 'SABANAGRANDE', '08634', 1, '2017-06-20 02:31:36', NULL),
  (142, 2, 'SABANALARGA', '08638', 1, '2017-06-20 02:31:36', NULL),
  (143, 2, 'SANTA LUCIA', '08675', 1, '2017-06-20 02:31:36', NULL),
  (144, 2, 'SANTO TOMAS', '08685', 1, '2017-06-20 02:31:37', NULL),
  (145, 2, 'SOLEDAD', '08758', 1, '2017-06-20 02:31:37', NULL),
  (146, 2, 'SUAN', '08770', 1, '2017-06-20 02:31:37', NULL),
  (147, 2, 'TUBARA', '08832', 1, '2017-06-20 02:31:37', NULL),
  (148, 2, 'USIACURI', '08849', 1, '2017-06-20 02:31:37', NULL),
  (149, 3, 'BOGOTA D.C.', '11001', 1, '2017-06-20 02:31:37', NULL),
  (150, 4, 'ACHI', '13006', 1, '2017-06-20 02:31:37', NULL),
  (151, 4, 'ALTOS DEL ROSARIO', '13030', 1, '2017-06-20 02:31:37', NULL),
  (152, 4, 'ARENAL DEL SUR', '13042', 1, '2017-06-20 02:31:37', NULL),
  (153, 4, 'ARJONA', '13052', 1, '2017-06-20 02:31:37', NULL),
  (154, 4, 'ARROYOHONDO', '13062', 1, '2017-06-20 02:31:37', NULL),
  (155, 4, 'BARRANCO DE LOBA', '13074', 1, '2017-06-20 02:31:37', NULL),
  (156, 4, 'CICUCO', '13188', 1, '2017-06-20 02:31:37', NULL),
  (157, 4, 'CORDOBA', '13212', 1, '2017-06-20 02:31:37', NULL),
  (158, 4, 'CLEMENCIA', '13222', 1, '2017-06-20 02:31:37', NULL),
  (159, 4, 'EL CARMEN DE BOLIVAR', '13244', 1, '2017-06-20 02:31:37', NULL),
  (160, 4, 'EL GUAMO', '13248', 1, '2017-06-20 02:31:38', NULL),
  (161, 4, 'EL PEÃ‘ON', '13268', 1, '2017-06-20 02:31:38', NULL),
  (162, 4, 'MAGANGUE', '13430', 1, '2017-06-20 02:31:38', NULL),
  (163, 4, 'MAHATES', '13433', 1, '2017-06-20 02:31:38', NULL),
  (164, 4, 'MARGARITA', '13440', 1, '2017-06-20 02:31:38', NULL),
  (165, 4, 'MARIA LA BAJA', '13442', 1, '2017-06-20 02:31:38', NULL),
  (166, 4, 'MONTECRISTO', '13458', 1, '2017-06-20 02:31:38', NULL),
  (167, 4, 'SANTA CRUZ DE MOMPOX', '13468', 1, '2017-06-20 02:31:38', NULL),
  (168, 4, 'MORALES', '13473', 1, '2017-06-20 02:31:38', NULL),
  (169, 4, 'PINILLOS', '13549', 1, '2017-06-20 02:31:38', NULL),
  (170, 4, 'REGIDOR', '13580', 1, '2017-06-20 02:31:38', NULL),
  (171, 4, 'RIOVIEJO', '13600', 1, '2017-06-20 02:31:38', NULL),
  (172, 4, 'SAN CRISTOBAL', '13620', 1, '2017-06-20 02:31:38', NULL),
  (173, 4, 'SAN ESTANISLAO', '13647', 1, '2017-06-20 02:31:38', NULL),
  (174, 4, 'SAN FERNANDO', '13650', 1, '2017-06-20 02:31:38', NULL),
  (175, 4, 'SAN JACINTO', '13654', 1, '2017-06-20 02:31:38', NULL),
  (176, 4, 'SAN JACINTO DEL CAUCA', '13655', 1, '2017-06-20 02:31:38', NULL),
  (177, 4, 'SAN JUAN NEPOMUCENO', '13657', 1, '2017-06-20 02:31:38', NULL),
  (178, 4, 'SAN MARTIN DE LOBA', '13667', 1, '2017-06-20 02:31:38', NULL),
  (179, 4, 'SAN PABLO', '13670', 1, '2017-06-20 02:31:38', NULL),
  (180, 4, 'SANTA CATALINA DE ALEJANDRIA', '13673', 1, '2017-06-20 02:31:38', NULL),
  (181, 4, 'SANTA ROSA DEL NORTE', '13683', 1, '2017-06-20 02:31:38', NULL),
  (182, 4, 'SANTA ROSA DEL SUR', '13688', 1, '2017-06-20 02:31:38', NULL),
  (183, 4, 'SIMITI', '13744', 1, '2017-06-20 02:31:38', NULL),
  (184, 4, 'SOPLAVIENTO', '13760', 1, '2017-06-20 02:31:38', NULL),
  (185, 4, 'TALAIGUA NUEVO', '13780', 1, '2017-06-20 02:31:38', NULL),
  (186, 4, 'TIQUISIO (PUERTO RICO)', '13810', 1, '2017-06-20 02:31:38', NULL),
  (187, 4, 'TURBACO', '13836', 1, '2017-06-20 02:31:38', NULL),
  (188, 4, 'TURBANA', '13838', 1, '2017-06-20 02:31:38', NULL),
  (189, 4, 'VILLANUEVA', '13873', 1, '2017-06-20 02:31:39', NULL),
  (190, 4, 'ZAMBRANO', '13894', 1, '2017-06-20 02:31:39', NULL),
  (191, 4, 'CARTAGENA DE INDIAS', '13001', 1, '2017-06-20 02:31:39', NULL),
  (192, 4, 'CANTAGALLO', '13160', 1, '2017-06-20 02:31:39', NULL),
  (193, 4, 'HATILLO DE LOBA', '13300', 1, '2017-06-20 02:31:39', NULL),
  (194, 4, 'CALAMAR', '13140', 1, '2017-06-20 02:31:39', NULL),
  (195, 5, 'TASCO', '15790', 1, '2017-06-20 02:31:39', NULL),
  (196, 5, 'TENZA', '15798', 1, '2017-06-20 02:31:39', NULL),
  (197, 5, 'VENTAQUEMADA', '15861', 1, '2017-06-20 02:31:39', NULL),
  (198, 5, 'CHITARAQUE', '15185', 1, '2017-06-20 02:31:39', NULL),
  (199, 5, 'CIENEGA', '15189', 1, '2017-06-20 02:31:39', NULL),
  (200, 5, 'CUCAITA', '15224', 1, '2017-06-20 02:31:39', NULL),
  (201, 5, 'GARAGOA', '15299', 1, '2017-06-20 02:31:39', NULL),
  (202, 5, 'TOTA', '15822', 1, '2017-06-20 02:31:39', NULL),
  (203, 5, 'TURMEQUE', '15835', 1, '2017-06-20 02:31:39', NULL),
  (204, 5, 'ZETAQUIRA', '15897', 1, '2017-06-20 02:31:40', NULL),
  (205, 5, 'RONDON', '15621', 1, '2017-06-20 02:31:40', NULL),
  (206, 5, 'TOPAGA', '15820', 1, '2017-06-20 02:31:40', NULL),
  (207, 5, 'GUACAMAYAS', '15317', 1, '2017-06-20 02:31:40', NULL),
  (208, 5, 'PANQUEBA', '15522', 1, '2017-06-20 02:31:40', NULL),
  (209, 5, 'PAZ DE RIO', '15537', 1, '2017-06-20 02:31:40', NULL),
  (210, 5, 'PUERTO BOYACA', '15572', 1, '2017-06-20 02:31:40', NULL),
  (211, 5, 'SATIVANORTE', '15720', 1, '2017-06-20 02:31:40', NULL),
  (212, 5, 'PISBA', '15550', 1, '2017-06-20 02:31:40', NULL),
  (213, 5, 'QUIPAMA', '15580', 1, '2017-06-20 02:31:40', NULL),
  (214, 5, 'RAMIRIQUI', '15599', 1, '2017-06-20 02:31:40', NULL),
  (215, 5, 'RAQUIRA', '15600', 1, '2017-06-20 02:31:40', NULL),
  (216, 5, 'SABOYA', '15632', 1, '2017-06-20 02:31:40', NULL),
  (217, 5, 'SACHICA', '15638', 1, '2017-06-20 02:31:40', NULL),
  (218, 5, 'SAMACA', '15646', 1, '2017-06-20 02:31:40', NULL),
  (219, 5, 'SAN EDUARDO', '15660', 1, '2017-06-20 02:31:40', NULL),
  (220, 5, 'SAN JOSE DE PARE', '15664', 1, '2017-06-20 02:31:40', NULL),
  (221, 5, 'SAN LUIS DE GACENO', '15667', 1, '2017-06-20 02:31:40', NULL),
  (222, 5, 'SAN MIGUEL DE SEMA', '15676', 1, '2017-06-20 02:31:40', NULL),
  (223, 5, 'SAN PABLO DE BORBUR', '15681', 1, '2017-06-20 02:31:40', NULL),
  (224, 5, 'SANTANA', '15686', 1, '2017-06-20 02:31:40', NULL),
  (225, 5, 'SANTA MARIA', '15690', 1, '2017-06-20 02:31:40', NULL),
  (226, 5, 'SANTA ROSA DE VITERBO', '15693', 1, '2017-06-20 02:31:40', NULL),
  (227, 5, 'SANTA SOFIA', '15696', 1, '2017-06-20 02:31:40', NULL),
  (228, 5, 'SATIVASUR', '15723', 1, '2017-06-20 02:31:40', NULL),
  (229, 5, 'SIACHOQUE', '15740', 1, '2017-06-20 02:31:40', NULL),
  (230, 5, 'SOATA', '15753', 1, '2017-06-20 02:31:41', NULL),
  (231, 5, 'SOCOTA', '15755', 1, '2017-06-20 02:31:41', NULL),
  (232, 5, 'SOCHA', '15757', 1, '2017-06-20 02:31:41', NULL),
  (233, 5, 'SOGAMOSO', '15759', 1, '2017-06-20 02:31:41', NULL),
  (234, 5, 'SOMONDOCO', '15761', 1, '2017-06-20 02:31:41', NULL),
  (235, 5, 'SORA', '15762', 1, '2017-06-20 02:31:41', NULL),
  (236, 5, 'SORACA', '15764', 1, '2017-06-20 02:31:41', NULL),
  (237, 5, 'SUSACON', '15774', 1, '2017-06-20 02:31:41', NULL),
  (238, 5, 'SUTAMARCHAN', '15776', 1, '2017-06-20 02:31:41', NULL),
  (239, 5, 'SUTATENZA', '15778', 1, '2017-06-20 02:31:41', NULL),
  (240, 5, 'TIBANA', '15804', 1, '2017-06-20 02:31:41', NULL),
  (241, 5, 'TIBASOSA', '15806', 1, '2017-06-20 02:31:41', NULL),
  (242, 5, 'TINJACA', '15808', 1, '2017-06-20 02:31:41', NULL),
  (243, 5, 'TIPACOQUE', '15810', 1, '2017-06-20 02:31:41', NULL),
  (244, 5, 'TOCA', '15814', 1, '2017-06-20 02:31:41', NULL),
  (245, 5, 'TOGUI', '15816', 1, '2017-06-20 02:31:41', NULL),
  (246, 5, 'TUNUNGUA', '15832', 1, '2017-06-20 02:31:41', NULL),
  (247, 5, 'TUTA', '15837', 1, '2017-06-20 02:31:41', NULL),
  (248, 5, 'PAUNA', '15531', 1, '2017-06-20 02:31:41', NULL),
  (249, 5, 'PAYA', '15533', 1, '2017-06-20 02:31:41', NULL),
  (250, 5, 'PESCA', '15542', 1, '2017-06-20 02:31:41', NULL),
  (251, 5, 'CHIQUINQUIRA', '15176', 1, '2017-06-20 02:31:42', NULL),
  (252, 5, 'BOYACA', '15104', 1, '2017-06-20 02:31:42', NULL),
  (253, 5, 'BRICENNO', '15106', 1, '2017-06-20 02:31:42', NULL),
  (254, 5, 'CORRALES', '15215', 1, '2017-06-20 02:31:42', NULL),
  (255, 5, 'COVARACHIA', '15218', 1, '2017-06-20 02:31:42', NULL),
  (256, 5, 'CUBARA', '15223', 1, '2017-06-20 02:31:42', NULL),
  (257, 5, 'CUITIVA', '15226', 1, '2017-06-20 02:31:42', NULL),
  (258, 5, 'CHIVOR', '15236', 1, '2017-06-20 02:31:42', NULL),
  (259, 5, 'DUITAMA', '15238', 1, '2017-06-20 02:31:42', NULL),
  (260, 5, 'EL COCUY', '15244', 1, '2017-06-20 02:31:42', NULL),
  (261, 5, 'EL ESPINO', '15248', 1, '2017-06-20 02:31:42', NULL),
  (262, 5, 'FIRAVITOBA', '15272', 1, '2017-06-20 02:31:42', NULL),
  (263, 5, 'FLORESTA', '15276', 1, '2017-06-20 02:31:42', NULL),
  (264, 5, 'GACHANTIVA', '15293', 1, '2017-06-20 02:31:42', NULL),
  (265, 5, 'GAMEZA', '15296', 1, '2017-06-20 02:31:42', NULL),
  (266, 5, 'GUATEQUE', '15322', 1, '2017-06-20 02:31:42', NULL),
  (267, 5, 'GUAYATA', '15325', 1, '2017-06-20 02:31:42', NULL),
  (268, 5, 'GUICAN', '15332', 1, '2017-06-20 02:31:42', NULL),
  (269, 5, 'IZA', '15362', 1, '2017-06-20 02:31:42', NULL),
  (270, 5, 'JENESANO', '15367', 1, '2017-06-20 02:31:42', NULL),
  (271, 5, 'JERICO', '15368', 1, '2017-06-20 02:31:42', NULL),
  (272, 5, 'LABRANZAGRANDE', '15377', 1, '2017-06-20 02:31:42', NULL),
  (273, 5, 'LA CAPILLA', '15380', 1, '2017-06-20 02:31:42', NULL),
  (274, 5, 'LA VICTORIA', '15401', 1, '2017-06-20 02:31:42', NULL),
  (275, 5, 'LA UVITA', '15403', 1, '2017-06-20 02:31:42', NULL),
  (276, 5, 'VILLA DE LEYVA', '15407', 1, '2017-06-20 02:31:42', NULL),
  (277, 5, 'MACANAL', '15425', 1, '2017-06-20 02:31:42', NULL),
  (278, 5, 'MARIPI', '15442', 1, '2017-06-20 02:31:43', NULL),
  (279, 5, 'MIRAFLORES', '15455', 1, '2017-06-20 02:31:43', NULL),
  (280, 5, 'MONGUA', '15464', 1, '2017-06-20 02:31:43', NULL),
  (281, 5, 'MONGUI', '15466', 1, '2017-06-20 02:31:43', NULL),
  (282, 5, 'MONIQUIRA', '15469', 1, '2017-06-20 02:31:43', NULL),
  (283, 5, 'MOTAVITA', '15476', 1, '2017-06-20 02:31:43', NULL),
  (284, 5, 'MUZO', '15480', 1, '2017-06-20 02:31:43', NULL),
  (285, 5, 'NOBSA', '15491', 1, '2017-06-20 02:31:43', NULL),
  (286, 5, 'NUEVO COLON', '15494', 1, '2017-06-20 02:31:43', NULL),
  (287, 5, 'OICATA', '15500', 1, '2017-06-20 02:31:43', NULL),
  (288, 5, 'OTANCHE', '15507', 1, '2017-06-20 02:31:43', NULL),
  (289, 5, 'PACHAVITA', '15511', 1, '2017-06-20 02:31:43', NULL),
  (290, 5, 'PAEZ', '15514', 1, '2017-06-20 02:31:43', NULL),
  (291, 5, 'PAIPA', '15516', 1, '2017-06-20 02:31:43', NULL),
  (292, 5, 'TUTAZA', '15839', 1, '2017-06-20 02:31:43', NULL),
  (293, 5, 'UMBITA', '15842', 1, '2017-06-20 02:31:43', NULL),
  (294, 5, 'VIRACACHA', '15879', 1, '2017-06-20 02:31:43', NULL),
  (295, 5, 'TUNJA', '15001', 1, '2017-06-20 02:31:43', NULL),
  (296, 5, 'ALMEIDA', '15022', 1, '2017-06-20 02:31:43', NULL),
  (297, 5, 'AQUITANIA', '15047', 1, '2017-06-20 02:31:43', NULL),
  (298, 5, 'ARCABUCO', '15051', 1, '2017-06-20 02:31:43', NULL),
  (299, 5, 'BELEN', '15087', 1, '2017-06-20 02:31:43', NULL),
  (300, 5, 'BERBEO', '15090', 1, '2017-06-20 02:31:43', NULL),
  (301, 5, 'BETEITIVA', '15092', 1, '2017-06-20 02:31:43', NULL),
  (302, 5, 'BOAVITA', '15097', 1, '2017-06-20 02:31:44', NULL),
  (303, 5, 'BUENAVISTA', '15109', 1, '2017-06-20 02:31:44', NULL),
  (304, 5, 'BUSBANZA', '15114', 1, '2017-06-20 02:31:44', NULL),
  (305, 5, 'CALDAS', '15131', 1, '2017-06-20 02:31:44', NULL),
  (306, 5, 'CAMPOHERMOSO', '15135', 1, '2017-06-20 02:31:44', NULL),
  (307, 5, 'CERINZA', '15162', 1, '2017-06-20 02:31:44', NULL),
  (308, 5, 'CHINAVITA', '15172', 1, '2017-06-20 02:31:44', NULL),
  (309, 5, 'CHISCAS', '15180', 1, '2017-06-20 02:31:44', NULL),
  (310, 5, 'CHITA', '15183', 1, '2017-06-20 02:31:44', NULL),
  (311, 5, 'CHIVATA', '15187', 1, '2017-06-20 02:31:44', NULL),
  (312, 5, 'COMBITA', '15204', 1, '2017-06-20 02:31:44', NULL),
  (313, 5, 'COPER', '15212', 1, '2017-06-20 02:31:44', NULL),
  (314, 5, 'CHIQUIZA (SAN PEDRO DE IGUAQUE)', '15232', 1, '2017-06-20 02:31:44', NULL),
  (315, 5, 'PAJARITO', '15518', 1, '2017-06-20 02:31:44', NULL),
  (316, 5, 'SAN MATEO', '15673', 1, '2017-06-20 02:31:44', NULL),
  (317, 5, 'SOTAQUIRA', '15763', 1, '2017-06-20 02:31:44', NULL),
  (318, 6, 'MANIZALES', '17001', 1, '2017-06-20 02:31:44', NULL),
  (319, 6, 'AGUADAS', '17013', 1, '2017-06-20 02:31:44', NULL),
  (320, 6, 'ANSERMA', '17042', 1, '2017-06-20 02:31:44', NULL),
  (321, 6, 'ARANZAZU', '17050', 1, '2017-06-20 02:31:44', NULL),
  (322, 6, 'BELALCAZAR', '17088', 1, '2017-06-20 02:31:44', NULL),
  (323, 6, 'CHINCHINA', '17174', 1, '2017-06-20 02:31:44', NULL),
  (324, 6, 'FILADELFIA', '17272', 1, '2017-06-20 02:31:44', NULL),
  (325, 6, 'LA DORADA', '17380', 1, '2017-06-20 02:31:44', NULL),
  (326, 6, 'LA MERCED', '17388', 1, '2017-06-20 02:31:44', NULL),
  (327, 6, 'MARMATO', '17442', 1, '2017-06-20 02:31:45', NULL),
  (328, 6, 'MARQUETALIA', '17444', 1, '2017-06-20 02:31:45', NULL),
  (329, 6, 'MARULANDA', '17446', 1, '2017-06-20 02:31:45', NULL),
  (330, 6, 'NEIRA', '17486', 1, '2017-06-20 02:31:45', NULL),
  (331, 6, 'NORCASIA', '17495', 1, '2017-06-20 02:31:45', NULL),
  (332, 6, 'PALESTINA', '17524', 1, '2017-06-20 02:31:45', NULL),
  (333, 6, 'RIOSUCIO', '17614', 1, '2017-06-20 02:31:45', NULL),
  (334, 6, 'RISARALDA', '17616', 1, '2017-06-20 02:31:45', NULL),
  (335, 6, 'SALAMINA', '17653', 1, '2017-06-20 02:31:45', NULL),
  (336, 6, 'SAN JOSE', '17665', 1, '2017-06-20 02:31:45', NULL),
  (337, 6, 'SUPIA', '17777', 1, '2017-06-20 02:31:45', NULL),
  (338, 6, 'VICTORIA', '17867', 1, '2017-06-20 02:31:45', NULL),
  (339, 6, 'VILLA MARIA', '17873', 1, '2017-06-20 02:31:45', NULL),
  (340, 6, 'VITERBO', '17877', 1, '2017-06-20 02:31:45', NULL),
  (341, 6, 'PENSILVANIA', '17541', 1, '2017-06-20 02:31:45', NULL),
  (342, 6, 'PACORA', '17513', 1, '2017-06-20 02:31:45', NULL),
  (343, 6, 'SAMANA', '17662', 1, '2017-06-20 02:31:45', NULL),
  (344, 6, 'MANZANARES', '17433', 1, '2017-06-20 02:31:45', NULL),
  (345, 7, 'FLORENCIA', '18001', 1, '2017-06-20 02:31:45', NULL),
  (346, 7, 'ALBANIA', '18029', 1, '2017-06-20 02:31:45', NULL),
  (347, 7, 'BELEN DE LOS ANDAQUIES', '18094', 1, '2017-06-20 02:31:45', NULL),
  (348, 7, 'CARTAGENA DEL CHAIRA', '18150', 1, '2017-06-20 02:31:46', NULL),
  (349, 7, 'EL PAUJIL', '18256', 1, '2017-06-20 02:31:46', NULL),
  (350, 7, 'LA MONTAÃ‘ITA', '18410', 1, '2017-06-20 02:31:46', NULL),
  (351, 7, 'MILAN', '18460', 1, '2017-06-20 02:31:46', NULL),
  (352, 7, 'MORELIA', '18479', 1, '2017-06-20 02:31:46', NULL),
  (353, 7, 'SAN VICENTE DEL CAGUAN', '18753', 1, '2017-06-20 02:31:46', NULL),
  (354, 7, 'SOLANO', '18756', 1, '2017-06-20 02:31:46', NULL),
  (355, 7, 'SOLITA', '18785', 1, '2017-06-20 02:31:46', NULL),
  (356, 7, 'EL DONCELLO', '18247', 1, '2017-06-20 02:31:46', NULL),
  (357, 7, 'CURILLO', '18205', 1, '2017-06-20 02:31:46', NULL),
  (358, 7, 'PUERTO RICO', '18592', 1, '2017-06-20 02:31:46', NULL),
  (359, 7, 'SAN JOSE DEL FRAGUA', '18610', 1, '2017-06-20 02:31:46', NULL),
  (360, 7, 'VALPARAISO', '18860', 1, '2017-06-20 02:31:46', NULL),
  (361, 8, 'TIMBIQUI', '19809', 1, '2017-06-20 02:31:46', NULL),
  (362, 8, 'POPAYAN', '19001', 1, '2017-06-20 02:31:46', NULL),
  (363, 8, 'ALMAGUER', '19022', 1, '2017-06-20 02:31:46', NULL),
  (364, 8, 'ARGELIA', '19050', 1, '2017-06-20 02:31:47', NULL),
  (365, 8, 'BALBOA', '19075', 1, '2017-06-20 02:31:47', NULL),
  (366, 8, 'BOLIVAR', '19100', 1, '2017-06-20 02:31:47', NULL),
  (367, 8, 'CAJIBIO', '19130', 1, '2017-06-20 02:31:47', NULL),
  (368, 8, 'CALDONO', '19137', 1, '2017-06-20 02:31:47', NULL),
  (369, 8, 'CORINTO', '19212', 1, '2017-06-20 02:31:47', NULL),
  (370, 8, 'EL TAMBO', '19256', 1, '2017-06-20 02:31:47', NULL),
  (371, 8, 'FLORENCIA', '19290', 1, '2017-06-20 02:31:47', NULL),
  (372, 8, 'GUAPI', '19318', 1, '2017-06-20 02:31:47', NULL),
  (373, 8, 'INZA', '19355', 1, '2017-06-20 02:31:47', NULL),
  (374, 8, 'LA SIERRA', '19392', 1, '2017-06-20 02:31:47', NULL),
  (375, 8, 'LA VEGA', '19397', 1, '2017-06-20 02:31:47', NULL),
  (376, 8, 'LOPEZ DE MICAY', '19418', 1, '2017-06-20 02:31:47', NULL),
  (377, 8, 'MIRANDA', '19455', 1, '2017-06-20 02:31:47', NULL),
  (378, 8, 'MORALES', '19473', 1, '2017-06-20 02:31:47', NULL),
  (379, 8, 'PAEZ (BELALCAZAR)', '19517', 1, '2017-06-20 02:31:47', NULL),
  (380, 8, 'PIAMONTE', '19533', 1, '2017-06-20 02:31:47', NULL),
  (381, 8, 'PUERTO TEJADA', '19573', 1, '2017-06-20 02:31:47', NULL),
  (382, 8, 'ROSAS', '19622', 1, '2017-06-20 02:31:47', NULL),
  (383, 8, 'SAN SEBASTIAN', '19693', 1, '2017-06-20 02:31:47', NULL),
  (384, 8, 'SOTARA', '19760', 1, '2017-06-20 02:31:47', NULL),
  (385, 8, 'SUAREZ', '19780', 1, '2017-06-20 02:31:47', NULL),
  (386, 8, 'SUCRE', '19785', 1, '2017-06-20 02:31:47', NULL),
  (387, 8, 'TIMBIO', '19807', 1, '2017-06-20 02:31:47', NULL),
  (388, 8, 'PATIA (EL BORDO)', '19532', 1, '2017-06-20 02:31:47', NULL),
  (389, 8, 'JAMBALO', '19364', 1, '2017-06-20 02:31:47', NULL),
  (390, 8, 'GUACHENE', '19300', 1, '2017-06-20 02:31:47', NULL),
  (391, 8, 'PIENDAMO', '19548', 1, '2017-06-20 02:31:48', NULL),
  (392, 8, 'PURACE (COCONUCO)', '19585', 1, '2017-06-20 02:31:48', NULL),
  (393, 8, 'CALOTO', '19142', 1, '2017-06-20 02:31:48', NULL),
  (394, 8, 'TOTORO', '19824', 1, '2017-06-20 02:31:48', NULL),
  (395, 8, 'VILLA RICA', '19845', 1, '2017-06-20 02:31:48', NULL),
  (396, 8, 'BUENOS AIRES', '19110', 1, '2017-06-20 02:31:48', NULL),
  (397, 8, 'MERCADERES', '19450', 1, '2017-06-20 02:31:48', NULL),
  (398, 8, 'PADILLA', '19513', 1, '2017-06-20 02:31:48', NULL),
  (399, 8, 'SANTA ROSA', '19701', 1, '2017-06-20 02:31:48', NULL),
  (400, 8, 'SANTANDER DE QUILICHAO', '19698', 1, '2017-06-20 02:31:48', NULL),
  (401, 8, 'TORIBIO', '19821', 1, '2017-06-20 02:31:48', NULL),
  (402, 8, 'SILVIA', '19743', 1, '2017-06-20 02:31:48', NULL),
  (403, 9, 'VALLEDUPAR', '20001', 1, '2017-06-20 02:31:48', NULL),
  (404, 9, 'AGUACHICA', '20011', 1, '2017-06-20 02:31:48', NULL),
  (405, 9, 'AGUSTIN CODAZZI', '20013', 1, '2017-06-20 02:31:48', NULL),
  (406, 9, 'ASTREA', '20032', 1, '2017-06-20 02:31:48', NULL),
  (407, 9, 'BECERRIL', '20045', 1, '2017-06-20 02:31:49', NULL),
  (408, 9, 'BOSCONIA', '20060', 1, '2017-06-20 02:31:49', NULL),
  (409, 9, 'CHIMICHAGUA', '20175', 1, '2017-06-20 02:31:49', NULL),
  (410, 9, 'CHIRIGUANA', '20178', 1, '2017-06-20 02:31:49', NULL),
  (411, 9, 'CURUMANI', '20228', 1, '2017-06-20 02:31:49', NULL),
  (412, 9, 'EL COPEY', '20238', 1, '2017-06-20 02:31:49', NULL),
  (413, 9, 'EL PASO', '20250', 1, '2017-06-20 02:31:49', NULL),
  (414, 9, 'GAMARRA', '20295', 1, '2017-06-20 02:31:49', NULL),
  (415, 9, 'GONZALEZ', '20310', 1, '2017-06-20 02:31:49', NULL),
  (416, 9, 'LA GLORIA', '20383', 1, '2017-06-20 02:31:49', NULL),
  (417, 9, 'LA JAGUA DE IBIRICO', '20400', 1, '2017-06-20 02:31:49', NULL),
  (418, 9, 'MANAURE BALCON DEL CESAR', '20443', 1, '2017-06-20 02:31:49', NULL),
  (419, 9, 'PAILITAS', '20517', 1, '2017-06-20 02:31:49', NULL),
  (420, 9, 'PELAYA', '20550', 1, '2017-06-20 02:31:49', NULL),
  (421, 9, 'PUEBLO BELLO', '20570', 1, '2017-06-20 02:31:49', NULL),
  (422, 9, 'RIO DE ORO', '20614', 1, '2017-06-20 02:31:49', NULL),
  (423, 9, 'LA PAZ', '20621', 1, '2017-06-20 02:31:49', NULL),
  (424, 9, 'SAN ALBERTO', '20710', 1, '2017-06-20 02:31:49', NULL),
  (425, 9, 'SAN DIEGO', '20750', 1, '2017-06-20 02:31:49', NULL),
  (426, 9, 'SAN MARTIN', '20770', 1, '2017-06-20 02:31:49', NULL),
  (427, 9, 'TAMALAMEQUE', '20787', 1, '2017-06-20 02:31:49', NULL),
  (428, 10, 'CANALETE', '23090', 1, '2017-06-20 02:31:50', NULL),
  (429, 10, 'CERETE', '23162', 1, '2017-06-20 02:31:50', NULL),
  (430, 10, 'CHIMA', '23168', 1, '2017-06-20 02:31:50', NULL),
  (431, 10, 'CHINU', '23182', 1, '2017-06-20 02:31:50', NULL),
  (432, 10, 'CIENAGA DE ORO', '23189', 1, '2017-06-20 02:31:50', NULL),
  (433, 10, 'COTORRA', '23300', 1, '2017-06-20 02:31:50', NULL),
  (434, 10, 'LA APARTADA (FRONTERA)', '23350', 1, '2017-06-20 02:31:50', NULL),
  (435, 10, 'LORICA', '23417', 1, '2017-06-20 02:31:50', NULL),
  (436, 10, 'LOS CORDOBAS', '23419', 1, '2017-06-20 02:31:50', NULL),
  (437, 10, 'MOMIL', '23464', 1, '2017-06-20 02:31:50', NULL),
  (438, 10, 'MONTELIBANO', '23466', 1, '2017-06-20 02:31:51', NULL),
  (439, 10, 'MOÃ‘ITOS', '23500', 1, '2017-06-20 02:31:51', NULL),
  (440, 10, 'PLANETA RICA', '23555', 1, '2017-06-20 02:31:51', NULL),
  (441, 10, 'PUEBLO NUEVO', '23570', 1, '2017-06-20 02:31:51', NULL),
  (442, 10, 'PUERTO ESCONDIDO', '23574', 1, '2017-06-20 02:31:51', NULL),
  (443, 10, 'PUERTO LIBERTADOR', '23580', 1, '2017-06-20 02:31:51', NULL),
  (444, 10, 'PURISIMA', '23586', 1, '2017-06-20 02:31:51', NULL),
  (445, 10, 'SAHAGUN', '23660', 1, '2017-06-20 02:31:51', NULL),
  (446, 10, 'SAN ANDRES DE SOTAVENTO', '23670', 1, '2017-06-20 02:31:51', NULL),
  (447, 10, 'SAN ANTERO', '23672', 1, '2017-06-20 02:31:51', NULL),
  (448, 10, 'SAN BERNARDO DEL VIENTO', '23675', 1, '2017-06-20 02:31:51', NULL),
  (449, 10, 'SAN CARLOS', '23678', 1, '2017-06-20 02:31:51', NULL),
  (450, 10, 'SAN PELAYO', '23686', 1, '2017-06-20 02:31:51', NULL),
  (451, 10, 'TIERRALTA', '23807', 1, '2017-06-20 02:31:51', NULL),
  (452, 10, 'VALENCIA', '23855', 1, '2017-06-20 02:31:51', NULL),
  (453, 10, 'MONTERIA', '23001', 1, '2017-06-20 02:31:51', NULL),
  (454, 10, 'AYAPEL', '23068', 1, '2017-06-20 02:31:51', NULL),
  (455, 10, 'BUENAVISTA', '23079', 1, '2017-06-20 02:31:51', NULL),
  (456, 10, 'SAN JOSE DE URE', '23682', 1, '2017-06-20 02:31:51', NULL),
  (457, 10, 'TUCHIN', '23815', 1, '2017-06-20 02:31:51', NULL),
  (458, 11, 'LA PEÃ‘A', '25398', 1, '2017-06-20 02:31:52', NULL),
  (459, 11, 'LA VEGA', '25402', 1, '2017-06-20 02:31:52', NULL),
  (460, 11, 'LENGUAZAQUE', '25407', 1, '2017-06-20 02:31:52', NULL),
  (461, 11, 'MACHETA', '25426', 1, '2017-06-20 02:31:52', NULL),
  (462, 11, 'MEDINA', '25438', 1, '2017-06-20 02:31:52', NULL),
  (463, 11, 'MOSQUERA', '25473', 1, '2017-06-20 02:31:52', NULL),
  (464, 11, 'NARIÃ‘O', '25483', 1, '2017-06-20 02:31:52', NULL),
  (465, 11, 'NEMOCON', '25486', 1, '2017-06-20 02:31:52', NULL),
  (466, 11, 'NILO', '25488', 1, '2017-06-20 02:31:52', NULL),
  (467, 11, 'NIMAIMA', '25489', 1, '2017-06-20 02:31:52', NULL),
  (468, 11, 'NOCAIMA', '25491', 1, '2017-06-20 02:31:52', NULL),
  (469, 11, 'PACHO', '25513', 1, '2017-06-20 02:31:52', NULL),
  (470, 11, 'PAIME', '25518', 1, '2017-06-20 02:31:52', NULL),
  (471, 11, 'PASCA', '25535', 1, '2017-06-20 02:31:52', NULL),
  (472, 11, 'PUERTO SALGAR', '25572', 1, '2017-06-20 02:31:52', NULL),
  (473, 11, 'QUEBRADANEGRA', '25592', 1, '2017-06-20 02:31:52', NULL),
  (474, 11, 'QUETAME', '25594', 1, '2017-06-20 02:31:53', NULL),
  (475, 11, 'APULO', '25599', 1, '2017-06-20 02:31:53', NULL),
  (476, 11, 'SAN ANTONIO DEL TEQUENDAMA', '25645', 1, '2017-06-20 02:31:53', NULL),
  (477, 11, 'SAN CAYETANO', '25653', 1, '2017-06-20 02:31:53', NULL),
  (478, 11, 'SAN FRANCISCO', '25658', 1, '2017-06-20 02:31:53', NULL),
  (479, 11, 'SAN JUAN DE RIOSECO', '25662', 1, '2017-06-20 02:31:53', NULL),
  (480, 11, 'SASAIMA', '25718', 1, '2017-06-20 02:31:53', NULL),
  (481, 11, 'SESQUILE', '25736', 1, '2017-06-20 02:31:53', NULL),
  (482, 11, 'SIBATE', '25740', 1, '2017-06-20 02:31:53', NULL),
  (483, 11, 'SOPO', '25758', 1, '2017-06-20 02:31:53', NULL),
  (484, 11, 'SUBACHOQUE', '25769', 1, '2017-06-20 02:31:53', NULL),
  (485, 11, 'SUESCA', '25772', 1, '2017-06-20 02:31:53', NULL),
  (486, 11, 'SUPATA', '25777', 1, '2017-06-20 02:31:53', NULL),
  (487, 11, 'TABIO', '25785', 1, '2017-06-20 02:31:53', NULL),
  (488, 11, 'TAUSA', '25793', 1, '2017-06-20 02:31:53', NULL),
  (489, 11, 'TENA', '25797', 1, '2017-06-20 02:31:53', NULL),
  (490, 11, 'TOCAIMA', '25815', 1, '2017-06-20 02:31:53', NULL),
  (491, 11, 'TOCANCIPA', '25817', 1, '2017-06-20 02:31:53', NULL),
  (492, 11, 'TOPAIPI', '25823', 1, '2017-06-20 02:31:53', NULL),
  (493, 11, 'UBALA', '25839', 1, '2017-06-20 02:31:53', NULL),
  (494, 11, 'UBATE', '25843', 1, '2017-06-20 02:31:53', NULL),
  (495, 11, 'UTICA', '25851', 1, '2017-06-20 02:31:53', NULL),
  (496, 11, 'VIANI', '25867', 1, '2017-06-20 02:31:53', NULL),
  (497, 11, 'VILLAGOMEZ', '25871', 1, '2017-06-20 02:31:54', NULL),
  (498, 11, 'VILLAPINZON', '25873', 1, '2017-06-20 02:31:54', NULL),
  (499, 11, 'VILLETA', '25875', 1, '2017-06-20 02:31:54', NULL),
  (500, 11, 'VIOTA', '25878', 1, '2017-06-20 02:31:54', NULL),
  (501, 11, 'YACOPI', '25885', 1, '2017-06-20 02:31:54', NULL),
  (502, 11, 'ZIPACON', '25898', 1, '2017-06-20 02:31:54', NULL),
  (503, 11, 'ZIPAQUIRA', '25899', 1, '2017-06-20 02:31:54', NULL),
  (504, 11, 'AGUA DE DIOS', '25001', 1, '2017-06-20 02:31:54', NULL),
  (505, 11, 'ALBAN', '25019', 1, '2017-06-20 02:31:54', NULL),
  (506, 11, 'ANAPOIMA', '25035', 1, '2017-06-20 02:31:54', NULL),
  (507, 11, 'ANOLAIMA', '25040', 1, '2017-06-20 02:31:54', NULL),
  (508, 11, 'BELTRAN', '25086', 1, '2017-06-20 02:31:54', NULL),
  (509, 11, 'BITUIMA', '25095', 1, '2017-06-20 02:31:54', NULL),
  (510, 11, 'VENECIA', '25506', 1, '2017-06-20 02:31:54', NULL),
  (511, 11, 'MADRID', '25430', 1, '2017-06-20 02:31:54', NULL),
  (512, 11, 'GUATAVITA', '25326', 1, '2017-06-20 02:31:54', NULL),
  (513, 11, 'GUTIERREZ', '25339', 1, '2017-06-20 02:31:54', NULL),
  (514, 11, 'ARBELAEZ', '25053', 1, '2017-06-20 02:31:54', NULL),
  (515, 11, 'PULI', '25580', 1, '2017-06-20 02:31:54', NULL),
  (516, 11, 'QUIPILE', '25596', 1, '2017-06-20 02:31:54', NULL),
  (517, 11, 'SAN BERNARDO', '25649', 1, '2017-06-20 02:31:54', NULL),
  (518, 11, 'RICAURTE', '25612', 1, '2017-06-20 02:31:54', NULL),
  (519, 11, 'SILVANIA', '25743', 1, '2017-06-20 02:31:54', NULL),
  (520, 11, 'SIMIJACA', '25745', 1, '2017-06-20 02:31:54', NULL),
  (521, 11, 'SUSA', '25779', 1, '2017-06-20 02:31:54', NULL),
  (522, 11, 'SUTATAUSA', '25781', 1, '2017-06-20 02:31:54', NULL),
  (523, 11, 'UBAQUE', '25841', 1, '2017-06-20 02:31:54', NULL),
  (524, 11, 'VERGARA', '25862', 1, '2017-06-20 02:31:55', NULL),
  (525, 11, 'CARMEN DE CARUPA', '25154', 1, '2017-06-20 02:31:55', NULL),
  (526, 11, 'CUCUNUBA', '25224', 1, '2017-06-20 02:31:55', NULL),
  (527, 11, 'EL COLEGIO', '25245', 1, '2017-06-20 02:31:55', NULL),
  (528, 11, 'FUQUENE', '25288', 1, '2017-06-20 02:31:55', NULL),
  (529, 11, 'GUAYABAL DE SIQUIMA', '25328', 1, '2017-06-20 02:31:55', NULL),
  (530, 11, 'GACHANCIPA', '25295', 1, '2017-06-20 02:31:55', NULL),
  (531, 11, 'GIRARDOT', '25307', 1, '2017-06-20 02:31:55', NULL),
  (532, 11, 'MANTA', '25436', 1, '2017-06-20 02:31:55', NULL),
  (533, 11, 'CACHIPAY', '25123', 1, '2017-06-20 02:31:55', NULL),
  (534, 11, 'CHIPAQUE', '25178', 1, '2017-06-20 02:31:55', NULL),
  (535, 11, 'COGUA', '25200', 1, '2017-06-20 02:31:55', NULL),
  (536, 11, 'TIBIRITA', '25807', 1, '2017-06-20 02:31:55', NULL),
  (537, 11, 'GUAYABETAL', '25335', 1, '2017-06-20 02:31:55', NULL),
  (538, 11, 'PANDI', '25524', 1, '2017-06-20 02:31:55', NULL),
  (539, 11, 'PARATEBUENO (LA NAGUAYA)', '25530', 1, '2017-06-20 02:31:55', NULL),
  (540, 11, 'TENJO', '25799', 1, '2017-06-20 02:31:55', NULL),
  (541, 11, 'TIBACUY', '25805', 1, '2017-06-20 02:31:55', NULL),
  (542, 11, 'SOACHA', '25754', 1, '2017-06-20 02:31:55', NULL),
  (543, 11, 'UNE', '25845', 1, '2017-06-20 02:31:55', NULL),
  (544, 11, 'BOJACA', '25099', 1, '2017-06-20 02:31:55', NULL),
  (545, 11, 'CABRERA', '25120', 1, '2017-06-20 02:31:55', NULL),
  (546, 11, 'CAJICA', '25126', 1, '2017-06-20 02:31:55', NULL),
  (547, 11, 'CAPARRAPI', '25148', 1, '2017-06-20 02:31:55', NULL),
  (548, 11, 'CAQUEZA', '25151', 1, '2017-06-20 02:31:55', NULL),
  (549, 11, 'CHAGUANI', '25168', 1, '2017-06-20 02:31:55', NULL),
  (550, 11, 'CHIA', '25175', 1, '2017-06-20 02:31:55', NULL),
  (551, 11, 'CHOACHI', '25181', 1, '2017-06-20 02:31:56', NULL),
  (552, 11, 'CHOCONTA', '25183', 1, '2017-06-20 02:31:56', NULL),
  (553, 11, 'COTA', '25214', 1, '2017-06-20 02:31:56', NULL),
  (554, 11, 'EL PEÃ‘ON', '25258', 1, '2017-06-20 02:31:56', NULL),
  (555, 11, 'EL ROSAL', '25260', 1, '2017-06-20 02:31:56', NULL),
  (556, 11, 'FACATATIVA', '25269', 1, '2017-06-20 02:31:56', NULL),
  (557, 11, 'FOMEQUE', '25279', 1, '2017-06-20 02:31:56', NULL),
  (558, 11, 'FOSCA', '25281', 1, '2017-06-20 02:31:56', NULL),
  (559, 11, 'FUNZA', '25286', 1, '2017-06-20 02:31:56', NULL),
  (560, 11, 'FUSAGASUGA', '25290', 1, '2017-06-20 02:31:56', NULL),
  (561, 11, 'GACHALA', '25293', 1, '2017-06-20 02:31:56', NULL),
  (562, 11, 'GACHETA', '25297', 1, '2017-06-20 02:31:56', NULL),
  (563, 11, 'GAMA', '25299', 1, '2017-06-20 02:31:56', NULL),
  (564, 11, 'GRANADA', '25312', 1, '2017-06-20 02:31:56', NULL),
  (565, 11, 'GUACHETA', '25317', 1, '2017-06-20 02:31:56', NULL),
  (566, 11, 'GUADUAS', '25320', 1, '2017-06-20 02:31:56', NULL),
  (567, 11, 'GUASCA', '25322', 1, '2017-06-20 02:31:56', NULL),
  (568, 11, 'GUATAQUI', '25324', 1, '2017-06-20 02:31:56', NULL),
  (569, 11, 'JERUSALEN', '25368', 1, '2017-06-20 02:31:56', NULL),
  (570, 11, 'JUNIN', '25372', 1, '2017-06-20 02:31:56', NULL),
  (571, 11, 'LA CALERA', '25377', 1, '2017-06-20 02:31:56', NULL),
  (572, 11, 'LA MESA', '25386', 1, '2017-06-20 02:31:56', NULL),
  (573, 11, 'LA PALMA', '25394', 1, '2017-06-20 02:31:56', NULL),
  (574, 12, 'EL CANTON DE SAN PABLO', '27135', 1, '2017-06-20 02:31:57', NULL),
  (575, 12, 'MEDIO ATRATO (BETE)', '27425', 1, '2017-06-20 02:31:57', NULL),
  (576, 12, 'SIPI', '27745', 1, '2017-06-20 02:31:57', NULL),
  (577, 12, 'TADO', '27787', 1, '2017-06-20 02:31:57', NULL),
  (578, 12, 'EL CARMEN DE ATRATO', '27245', 1, '2017-06-20 02:31:57', NULL),
  (579, 12, 'NUQUI', '27495', 1, '2017-06-20 02:31:57', NULL),
  (580, 12, 'BELEN DE BAJIRA', '27086', 1, '2017-06-20 02:31:57', NULL),
  (581, 12, 'CERTEGUI', '27160', 1, '2017-06-20 02:31:57', NULL),
  (582, 12, 'UNGUIA', '27800', 1, '2017-06-20 02:31:57', NULL),
  (583, 12, 'UNION PANAMERICANA', '27810', 1, '2017-06-20 02:31:57', NULL),
  (584, 12, 'MEDIO BAUDO (PUERTO MELUK)', '27430', 1, '2017-06-20 02:31:57', NULL),
  (585, 12, 'BAHIA SOLANO (MUTIS)', '27075', 1, '2017-06-20 02:31:57', NULL),
  (586, 12, 'BAJO BAUDO (PIZARRO)', '27077', 1, '2017-06-20 02:31:57', NULL),
  (587, 12, 'BOJAYA', '27099', 1, '2017-06-20 02:31:57', NULL),
  (588, 12, 'EL CARMEN DEL DARIEN', '27150', 1, '2017-06-20 02:31:57', NULL),
  (589, 12, 'CONDOTO', '27205', 1, '2017-06-20 02:31:57', NULL),
  (590, 12, 'LITORAL DE SAN JUAN', '27250', 1, '2017-06-20 02:31:57', NULL),
  (591, 12, 'ISTMINA', '27361', 1, '2017-06-20 02:31:58', NULL),
  (592, 12, 'JURADO', '27372', 1, '2017-06-20 02:31:58', NULL),
  (593, 12, 'LLORO', '27413', 1, '2017-06-20 02:31:58', NULL),
  (594, 12, 'ANDAGOYA MEDIO SAN JUAN', '27450', 1, '2017-06-20 02:31:58', NULL),
  (595, 12, 'NOVITA', '27491', 1, '2017-06-20 02:31:58', NULL),
  (596, 12, 'RIO IRO', '27580', 1, '2017-06-20 02:31:58', NULL),
  (597, 12, 'RIO QUITO (PAIMADO)', '27600', 1, '2017-06-20 02:31:58', NULL),
  (598, 12, 'RIOSUCIO', '27615', 1, '2017-06-20 02:31:58', NULL),
  (599, 12, 'SAN JOSE DEL PALMAR', '27660', 1, '2017-06-20 02:31:58', NULL),
  (600, 12, 'QUIBDO', '27001', 1, '2017-06-20 02:31:58', NULL),
  (601, 12, 'ACANDI', '27006', 1, '2017-06-20 02:31:58', NULL),
  (602, 12, 'ALTO BAUDO (PIE DE PATO)', '27025', 1, '2017-06-20 02:31:58', NULL),
  (603, 12, 'ATRATO (YUTO)', '27050', 1, '2017-06-20 02:31:58', NULL),
  (604, 12, 'BAGADO', '27073', 1, '2017-06-20 02:31:58', NULL),
  (605, 13, 'OPORAPA', '41503', 1, '2017-06-20 02:31:59', NULL),
  (606, 13, 'PAICOL', '41518', 1, '2017-06-20 02:31:59', NULL),
  (607, 13, 'RIVERA', '41615', 1, '2017-06-20 02:31:59', NULL),
  (608, 13, 'TESALIA', '41797', 1, '2017-06-20 02:31:59', NULL),
  (609, 13, 'VILLAVIEJA', '41872', 1, '2017-06-20 02:31:59', NULL),
  (610, 13, 'NEIVA', '41001', 1, '2017-06-20 02:31:59', NULL),
  (611, 13, 'ACEVEDO', '41006', 1, '2017-06-20 02:31:59', NULL),
  (612, 13, 'EL AGRADO', '41013', 1, '2017-06-20 02:31:59', NULL),
  (613, 13, 'AIPE', '41016', 1, '2017-06-20 02:31:59', NULL),
  (614, 13, 'ALGECIRAS', '41020', 1, '2017-06-20 02:31:59', NULL),
  (615, 13, 'ALTAMIRA', '41026', 1, '2017-06-20 02:31:59', NULL),
  (616, 13, 'BARAYA', '41078', 1, '2017-06-20 02:31:59', NULL),
  (617, 13, 'CAMPOALEGRE', '41132', 1, '2017-06-20 02:31:59', NULL),
  (618, 13, 'COLOMBIA', '41206', 1, '2017-06-20 02:31:59', NULL),
  (619, 13, 'ELIAS', '41244', 1, '2017-06-20 02:32:00', NULL),
  (620, 13, 'GARZON', '41298', 1, '2017-06-20 02:32:00', NULL),
  (621, 13, 'GIGANTE', '41306', 1, '2017-06-20 02:32:00', NULL),
  (622, 13, 'GUADALUPE', '41319', 1, '2017-06-20 02:32:00', NULL),
  (623, 13, 'HOBO', '41349', 1, '2017-06-20 02:32:00', NULL),
  (624, 13, 'IQUIRA', '41357', 1, '2017-06-20 02:32:00', NULL),
  (625, 13, 'LA PLATA', '41396', 1, '2017-06-20 02:32:00', NULL),
  (626, 13, 'ISNOS', '41359', 1, '2017-06-20 02:32:00', NULL),
  (627, 13, 'LA ARGENTINA', '41378', 1, '2017-06-20 02:32:00', NULL),
  (628, 13, 'SAN AGUSTIN', '41668', 1, '2017-06-20 02:32:00', NULL),
  (629, 13, 'PITAL', '41548', 1, '2017-06-20 02:32:00', NULL),
  (630, 13, 'SANTA MARIA', '41676', 1, '2017-06-20 02:32:00', NULL),
  (631, 13, 'SUAZA', '41770', 1, '2017-06-20 02:32:00', NULL),
  (632, 13, 'TARQUI', '41791', 1, '2017-06-20 02:32:00', NULL),
  (633, 13, 'TELLO', '41799', 1, '2017-06-20 02:32:00', NULL),
  (634, 13, 'TERUEL', '41801', 1, '2017-06-20 02:32:00', NULL),
  (635, 13, 'TIMANA', '41807', 1, '2017-06-20 02:32:00', NULL),
  (636, 13, 'YAGUARA', '41885', 1, '2017-06-20 02:32:00', NULL),
  (637, 13, 'NATAGA', '41483', 1, '2017-06-20 02:32:00', NULL),
  (638, 13, 'PALERMO', '41524', 1, '2017-06-20 02:32:00', NULL),
  (639, 13, 'PALESTINA', '41530', 1, '2017-06-20 02:32:00', NULL),
  (640, 13, 'PITALITO', '41551', 1, '2017-06-20 02:32:00', NULL),
  (641, 13, 'SALADOBLANCO', '41660', 1, '2017-06-20 02:32:00', NULL),
  (642, 14, 'RIOHACHA', '44001', 1, '2017-06-20 02:32:01', NULL),
  (643, 14, 'ALBANIA', '44035', 1, '2017-06-20 02:32:01', NULL),
  (644, 14, 'BARRANCAS', '44078', 1, '2017-06-20 02:32:01', NULL),
  (645, 14, 'DIBULLA', '44090', 1, '2017-06-20 02:32:01', NULL),
  (646, 14, 'DISTRACCION', '44098', 1, '2017-06-20 02:32:01', NULL),
  (647, 14, 'EL MOLINO', '44110', 1, '2017-06-20 02:32:01', NULL),
  (648, 14, 'FONSECA', '44279', 1, '2017-06-20 02:32:01', NULL),
  (649, 14, 'HATONUEVO', '44378', 1, '2017-06-20 02:32:01', NULL),
  (650, 14, 'LA JAGUA DEL PILAR', '44420', 1, '2017-06-20 02:32:01', NULL),
  (651, 14, 'MAICAO', '44430', 1, '2017-06-20 02:32:01', NULL),
  (652, 14, 'MANAURE', '44560', 1, '2017-06-20 02:32:01', NULL),
  (653, 14, 'SAN JUAN DEL CESAR', '44650', 1, '2017-06-20 02:32:01', NULL),
  (654, 14, 'URIBIA', '44847', 1, '2017-06-20 02:32:01', NULL),
  (655, 14, 'URUMITA', '44855', 1, '2017-06-20 02:32:02', NULL),
  (656, 14, 'VILLANUEVA', '44874', 1, '2017-06-20 02:32:02', NULL),
  (657, 15, 'SANTA BARBARA DE PINTO', '47720', 1, '2017-06-20 02:32:02', NULL),
  (658, 15, 'NUEVA GRANADA', '47460', 1, '2017-06-20 02:32:02', NULL),
  (659, 15, 'PIVIJAY', '47551', 1, '2017-06-20 02:32:02', NULL),
  (660, 15, 'PLATO', '47555', 1, '2017-06-20 02:32:02', NULL),
  (661, 15, 'SALAMINA', '47675', 1, '2017-06-20 02:32:02', NULL),
  (662, 15, 'SANTA ANA', '47707', 1, '2017-06-20 02:32:02', NULL),
  (663, 15, 'SANTA MARTA', '47001', 1, '2017-06-20 02:32:02', NULL),
  (664, 15, 'ALGARROBO', '47030', 1, '2017-06-20 02:32:02', NULL),
  (665, 15, 'ARACATACA', '47053', 1, '2017-06-20 02:32:02', NULL),
  (666, 15, 'ARIGUANI', '47058', 1, '2017-06-20 02:32:02', NULL),
  (667, 15, 'CERRO DE SAN ANTONIO', '47161', 1, '2017-06-20 02:32:03', NULL),
  (668, 15, 'CHIVOLO', '47170', 1, '2017-06-20 02:32:03', NULL),
  (669, 15, 'CIENAGA', '47189', 1, '2017-06-20 02:32:03', NULL),
  (670, 15, 'CONCORDIA', '47205', 1, '2017-06-20 02:32:03', NULL),
  (671, 15, 'EL BANCO', '47245', 1, '2017-06-20 02:32:03', NULL),
  (672, 15, 'EL PIÃ‘ON', '47258', 1, '2017-06-20 02:32:03', NULL),
  (673, 15, 'EL RETEN', '47268', 1, '2017-06-20 02:32:03', NULL),
  (674, 15, 'FUNDACION', '47288', 1, '2017-06-20 02:32:03', NULL),
  (675, 15, 'GUAMAL', '47318', 1, '2017-06-20 02:32:03', NULL),
  (676, 15, 'PEDRAZA', '47541', 1, '2017-06-20 02:32:03', NULL),
  (677, 15, 'PIJIÃ‘O DEL CARMEN', '47545', 1, '2017-06-20 02:32:03', NULL),
  (678, 15, 'PUEBLOVIEJO', '47570', 1, '2017-06-20 02:32:03', NULL),
  (679, 15, 'REMOLINO', '47605', 1, '2017-06-20 02:32:03', NULL),
  (680, 15, 'SABANAS DE SAN ANGEL', '47660', 1, '2017-06-20 02:32:03', NULL),
  (681, 15, 'SAN SEBASTIAN DE BUENAVISTA', '47692', 1, '2017-06-20 02:32:03', NULL),
  (682, 15, 'SAN ZENON', '47703', 1, '2017-06-20 02:32:03', NULL),
  (683, 15, 'SITIONUEVO', '47745', 1, '2017-06-20 02:32:03', NULL),
  (684, 15, 'TENERIFE', '47798', 1, '2017-06-20 02:32:03', NULL),
  (685, 15, 'ZAPAYAN', '47960', 1, '2017-06-20 02:32:03', NULL),
  (686, 15, 'ZONA BANANERA', '47980', 1, '2017-06-20 02:32:03', NULL),
  (687, 16, 'URIBE', '50370', 1, '2017-06-20 02:32:04', NULL),
  (688, 16, 'SAN MARTIN', '50689', 1, '2017-06-20 02:32:04', NULL),
  (689, 16, 'MESETAS', '50330', 1, '2017-06-20 02:32:04', NULL),
  (690, 16, 'PUERTO CONCORDIA', '50450', 1, '2017-06-20 02:32:04', NULL),
  (691, 16, 'VILLAVICENCIO', '50001', 1, '2017-06-20 02:32:04', NULL),
  (692, 16, 'EL CASTILLO', '50251', 1, '2017-06-20 02:32:04', NULL),
  (693, 16, 'GRANADA', '50313', 1, '2017-06-20 02:32:04', NULL),
  (694, 16, 'GUAMAL', '50318', 1, '2017-06-20 02:32:04', NULL),
  (695, 16, 'ACACIAS', '50006', 1, '2017-06-20 02:32:04', NULL),
  (696, 16, 'BARRANCA DE UPIA', '50110', 1, '2017-06-20 02:32:04', NULL),
  (697, 16, 'CABUYARO', '50124', 1, '2017-06-20 02:32:04', NULL),
  (698, 16, 'CASTILLA LA NUEVA', '50150', 1, '2017-06-20 02:32:04', NULL),
  (699, 16, 'CUBARRAL', '50223', 1, '2017-06-20 02:32:04', NULL),
  (700, 16, 'CUMARAL', '50226', 1, '2017-06-20 02:32:04', NULL),
  (701, 16, 'EL CALVARIO', '50245', 1, '2017-06-20 02:32:04', NULL),
  (702, 16, 'EL DORADO', '50270', 1, '2017-06-20 02:32:04', NULL),
  (703, 16, 'FUENTE DE ORO', '50287', 1, '2017-06-20 02:32:05', NULL),
  (704, 16, 'MAPIRIPAN', '50325', 1, '2017-06-20 02:32:05', NULL),
  (705, 16, 'LA MACARENA', '50350', 1, '2017-06-20 02:32:05', NULL),
  (706, 16, 'LEJANIAS', '50400', 1, '2017-06-20 02:32:05', NULL),
  (707, 16, 'PUERTO GAITAN', '50568', 1, '2017-06-20 02:32:05', NULL),
  (708, 16, 'PUERTO LOPEZ', '50573', 1, '2017-06-20 02:32:05', NULL),
  (709, 16, 'PUERTO LLERAS', '50577', 1, '2017-06-20 02:32:05', NULL),
  (710, 16, 'PUERTO RICO', '50590', 1, '2017-06-20 02:32:05', NULL),
  (711, 16, 'RESTREPO', '50606', 1, '2017-06-20 02:32:05', NULL),
  (712, 16, 'SAN CARLOS DE GUAROA', '50680', 1, '2017-06-20 02:32:05', NULL),
  (713, 16, 'SAN JUAN DE ARAMA', '50683', 1, '2017-06-20 02:32:05', NULL),
  (714, 16, 'SAN JUANITO', '50686', 1, '2017-06-20 02:32:05', NULL),
  (715, 16, 'VISTAHERMOSA', '50711', 1, '2017-06-20 02:32:05', NULL),
  (716, 17, 'EL CHARCO', '52250', 1, '2017-06-20 02:32:06', NULL),
  (717, 17, 'EL ROSARIO', '52256', 1, '2017-06-20 02:32:06', NULL),
  (718, 17, 'EL TABLON DE GOMEZ', '52258', 1, '2017-06-20 02:32:06', NULL),
  (719, 17, 'MAGUI (PAYAN)', '52427', 1, '2017-06-20 02:32:06', NULL),
  (720, 17, 'MALLAMA (PIEDRANCHA)', '52435', 1, '2017-06-20 02:32:06', NULL),
  (721, 17, 'MOSQUERA', '52473', 1, '2017-06-20 02:32:06', NULL),
  (722, 17, 'NARIÃ‘O', '52480', 1, '2017-06-20 02:32:06', NULL),
  (723, 17, 'OLAYA HERRERA (BOCAS DE SATINGA)', '52490', 1, '2017-06-20 02:32:06', NULL),
  (724, 17, 'OSPINA', '52506', 1, '2017-06-20 02:32:06', NULL),
  (725, 17, 'FRANCISCO PIZARRO (SALAHONDA)', '52520', 1, '2017-06-20 02:32:06', NULL),
  (726, 17, 'POLICARPA', '52540', 1, '2017-06-20 02:32:06', NULL),
  (727, 17, 'POTOSI', '52560', 1, '2017-06-20 02:32:06', NULL),
  (728, 17, 'PROVIDENCIA', '52565', 1, '2017-06-20 02:32:06', NULL),
  (729, 17, 'PUERRES', '52573', 1, '2017-06-20 02:32:06', NULL),
  (730, 17, 'PUPIALES', '52585', 1, '2017-06-20 02:32:06', NULL),
  (731, 17, 'RICAURTE', '52612', 1, '2017-06-20 02:32:06', NULL),
  (732, 17, 'ROBERTO PAYAN SAN JOSE', '52621', 1, '2017-06-20 02:32:06', NULL),
  (733, 17, 'SAMANIEGO', '52678', 1, '2017-06-20 02:32:06', NULL),
  (734, 17, 'SANDONA', '52683', 1, '2017-06-20 02:32:06', NULL),
  (735, 17, 'SAN BERNARDO', '52685', 1, '2017-06-20 02:32:07', NULL),
  (736, 17, 'SAN LORENZO', '52687', 1, '2017-06-20 02:32:07', NULL),
  (737, 17, 'SAN PABLO', '52693', 1, '2017-06-20 02:32:07', NULL),
  (738, 17, 'SAN PEDRO DE CARTAGO', '52694', 1, '2017-06-20 02:32:07', NULL),
  (739, 17, 'SANTA CRUZ (GUACHAVES)', '52699', 1, '2017-06-20 02:32:07', NULL),
  (740, 17, 'TAMINANGO', '52786', 1, '2017-06-20 02:32:07', NULL),
  (741, 17, 'TANGUA', '52788', 1, '2017-06-20 02:32:07', NULL),
  (742, 17, 'YACUANQUER', '52885', 1, '2017-06-20 02:32:07', NULL),
  (743, 17, 'SAPUYES', '52720', 1, '2017-06-20 02:32:07', NULL),
  (744, 17, 'SANTA BARBARA (ISCUANDE)', '52696', 1, '2017-06-20 02:32:07', NULL),
  (745, 17, 'TUMACO', '52835', 1, '2017-06-20 02:32:07', NULL),
  (746, 17, 'TUQUERRES', '52838', 1, '2017-06-20 02:32:07', NULL),
  (747, 17, 'EL TAMBO', '52260', 1, '2017-06-20 02:32:07', NULL),
  (748, 17, 'FUNES', '52287', 1, '2017-06-20 02:32:07', NULL),
  (749, 17, 'GUACHUCAL', '52317', 1, '2017-06-20 02:32:07', NULL),
  (750, 17, 'GUAITARILLA', '52320', 1, '2017-06-20 02:32:07', NULL),
  (751, 17, 'GUALMATAN', '52323', 1, '2017-06-20 02:32:07', NULL),
  (752, 17, 'ILES', '52352', 1, '2017-06-20 02:32:07', NULL),
  (753, 17, 'IMUES', '52354', 1, '2017-06-20 02:32:07', NULL),
  (754, 17, 'IPIALES', '52356', 1, '2017-06-20 02:32:07', NULL),
  (755, 17, 'LA CRUZ', '52378', 1, '2017-06-20 02:32:07', NULL),
  (756, 17, 'LA FLORIDA', '52381', 1, '2017-06-20 02:32:07', NULL),
  (757, 17, 'LA LLANADA', '52385', 1, '2017-06-20 02:32:07', NULL),
  (758, 17, 'LA TOLA', '52390', 1, '2017-06-20 02:32:07', NULL),
  (759, 17, 'LA UNION', '52399', 1, '2017-06-20 02:32:07', NULL),
  (760, 17, 'LEIVA', '52405', 1, '2017-06-20 02:32:07', NULL),
  (761, 17, 'LINARES', '52411', 1, '2017-06-20 02:32:08', NULL),
  (762, 17, 'LOS ANDES (SOTOMAYOR)', '52418', 1, '2017-06-20 02:32:08', NULL),
  (763, 17, 'CUASPUD (CARLOSAMA)', '52224', 1, '2017-06-20 02:32:08', NULL),
  (764, 17, 'CARTAGO', '5220', 1, '2017-06-20 02:32:08', NULL),
  (765, 17, 'SOTOMAYOR (ELIMINAR)', '52148', 1, '2017-06-20 02:32:08', NULL),
  (766, 17, 'EL PEÃ‘OL', '52254', 1, '2017-06-20 02:32:08', NULL),
  (767, 17, 'SAN MARCOS', '525269', 1, '2017-06-20 02:32:08', NULL),
  (768, 17, 'SAN JUAN DE PASTO', '52001', 1, '2017-06-20 02:32:08', NULL),
  (769, 17, 'SAN JOSE DE ALBAN', '52019', 1, '2017-06-20 02:32:08', NULL),
  (770, 17, 'ALDANA', '52022', 1, '2017-06-20 02:32:08', NULL),
  (771, 17, 'ANCUYA', '52036', 1, '2017-06-20 02:32:08', NULL),
  (772, 17, 'ARBOLEDA (BERRUECOS)', '52051', 1, '2017-06-20 02:32:08', NULL),
  (773, 17, 'BARBACOAS', '52079', 1, '2017-06-20 02:32:08', NULL),
  (774, 17, 'BELEN', '52083', 1, '2017-06-20 02:32:08', NULL),
  (775, 17, 'BUESACO', '52110', 1, '2017-06-20 02:32:08', NULL),
  (776, 17, 'COLON (GENOVA)', '52203', 1, '2017-06-20 02:32:08', NULL),
  (777, 17, 'CONSACA', '52207', 1, '2017-06-20 02:32:08', NULL),
  (778, 17, 'CONTADERO', '52210', 1, '2017-06-20 02:32:08', NULL),
  (779, 17, 'CORDOBA', '52215', 1, '2017-06-20 02:32:08', NULL),
  (780, 17, 'CUMBAL', '52227', 1, '2017-06-20 02:32:08', NULL),
  (781, 17, 'CUMBITARA', '52233', 1, '2017-06-20 02:32:08', NULL),
  (782, 17, 'CHACHAGUI', '52240', 1, '2017-06-20 02:32:08', NULL),
  (783, 18, 'ABREGO', '54003', 1, '2017-06-20 02:32:09', NULL),
  (784, 18, 'ARBOLEDAS', '54051', 1, '2017-06-20 02:32:09', NULL),
  (785, 18, 'BUCARASICA', '54109', 1, '2017-06-20 02:32:09', NULL),
  (786, 18, 'CACOTA', '54125', 1, '2017-06-20 02:32:09', NULL),
  (787, 18, 'CACHIRA', '54128', 1, '2017-06-20 02:32:09', NULL),
  (788, 18, 'CHITAGA', '54174', 1, '2017-06-20 02:32:09', NULL),
  (789, 18, 'CUCUTILLA', '54223', 1, '2017-06-20 02:32:09', NULL),
  (790, 18, 'EL CARMEN', '54245', 1, '2017-06-20 02:32:09', NULL),
  (791, 18, 'GRAMALOTE', '54313', 1, '2017-06-20 02:32:09', NULL),
  (792, 18, 'HACARI', '54344', 1, '2017-06-20 02:32:09', NULL),
  (793, 18, 'HERRAN', '54347', 1, '2017-06-20 02:32:09', NULL),
  (794, 18, 'LABATECA', '54377', 1, '2017-06-20 02:32:09', NULL),
  (795, 18, 'LA ESPERANZA', '54385', 1, '2017-06-20 02:32:09', NULL),
  (796, 18, 'LA PLAYA DE BELEN', '54398', 1, '2017-06-20 02:32:09', NULL);
  INSERT INTO `ciudades` (`id`, `departamento_id`, `ciudad`, `codigo`, `estado`, `creado`, `editado`) VALUES
  (797, 18, 'LOS PATIOS', '54405', 1, '2017-06-20 02:32:09', NULL),
  (798, 18, 'LOURDES', '54418', 1, '2017-06-20 02:32:09', NULL),
  (799, 18, 'MUTISCUA', '54480', 1, '2017-06-20 02:32:09', NULL),
  (800, 18, 'PAMPLONITA', '54520', 1, '2017-06-20 02:32:09', NULL),
  (801, 18, 'PUERTO SANTANDER', '54553', 1, '2017-06-20 02:32:09', NULL),
  (802, 18, 'RAGONVALIA', '54599', 1, '2017-06-20 02:32:09', NULL),
  (803, 18, 'SALAZAR DE LAS PALMAS', '54660', 1, '2017-06-20 02:32:09', NULL),
  (804, 18, 'SAN CALIXTO', '54670', 1, '2017-06-20 02:32:09', NULL),
  (805, 18, 'SANTIAGO', '54680', 1, '2017-06-20 02:32:10', NULL),
  (806, 18, 'SANTO DOMINGO DE SILOS', '54743', 1, '2017-06-20 02:32:10', NULL),
  (807, 18, 'TIBU', '54810', 1, '2017-06-20 02:32:10', NULL),
  (808, 18, 'TOLEDO', '54820', 1, '2017-06-20 02:32:10', NULL),
  (809, 18, 'VILLA CARO', '54871', 1, '2017-06-20 02:32:10', NULL),
  (810, 18, 'CHINACOTA', '54172', 1, '2017-06-20 02:32:10', NULL),
  (811, 18, 'CONVENCION', '54206', 1, '2017-06-20 02:32:10', NULL),
  (812, 18, 'EL TARRA', '54250', 1, '2017-06-20 02:32:10', NULL),
  (813, 18, 'EL ZULIA', '54261', 1, '2017-06-20 02:32:10', NULL),
  (814, 18, 'OCAÃ‘A', '54498', 1, '2017-06-20 02:32:10', NULL),
  (815, 18, 'PAMPLONA', '54518', 1, '2017-06-20 02:32:10', NULL),
  (816, 18, 'SARDINATA', '54720', 1, '2017-06-20 02:32:10', NULL),
  (817, 18, 'TEORAMA', '54800', 1, '2017-06-20 02:32:10', NULL),
  (818, 18, 'VILLA DEL ROSARIO', '54874', 1, '2017-06-20 02:32:10', NULL),
  (819, 18, 'SAN CAYETANO', '54673', 1, '2017-06-20 02:32:10', NULL),
  (820, 18, 'DURANIA', '54239', 1, '2017-06-20 02:32:10', NULL),
  (821, 18, 'BOCHALEMA', '54099', 1, '2017-06-20 02:32:10', NULL),
  (822, 18, 'SAN JOSE DE CUCUTA', '54001', 1, '2017-06-20 02:32:10', NULL),
  (823, 19, 'ARMENIA', '63001', 1, '2017-06-20 02:32:11', NULL),
  (824, 19, 'BUENAVISTA', '63111', 1, '2017-06-20 02:32:11', NULL),
  (825, 19, 'CALARCA', '63130', 1, '2017-06-20 02:32:11', NULL),
  (826, 19, 'CIRCASIA', '63190', 1, '2017-06-20 02:32:11', NULL),
  (827, 19, 'CORDOBA', '63212', 1, '2017-06-20 02:32:11', NULL),
  (828, 19, 'FILANDIA', '63272', 1, '2017-06-20 02:32:11', NULL),
  (829, 19, 'GENOVA', '63302', 1, '2017-06-20 02:32:11', NULL),
  (830, 19, 'LA TEBAIDA', '63401', 1, '2017-06-20 02:32:11', NULL),
  (831, 19, 'MONTENEGRO', '63470', 1, '2017-06-20 02:32:11', NULL),
  (832, 19, 'PIJAO', '63548', 1, '2017-06-20 02:32:11', NULL),
  (833, 19, 'QUIMBAYA', '63594', 1, '2017-06-20 02:32:11', NULL),
  (834, 19, 'SALENTO', '63690', 1, '2017-06-20 02:32:11', NULL),
  (835, 20, 'APIA', '66045', 1, '2017-06-20 02:32:12', NULL),
  (836, 20, 'BALBOA', '66075', 1, '2017-06-20 02:32:12', NULL),
  (837, 20, 'BELEN DE UMBRIA', '66088', 1, '2017-06-20 02:32:12', NULL),
  (838, 20, 'DOSQUEBRADAS', '66170', 1, '2017-06-20 02:32:12', NULL),
  (839, 20, 'GUATICA', '66318', 1, '2017-06-20 02:32:12', NULL),
  (840, 20, 'LA CELIA', '66383', 1, '2017-06-20 02:32:12', NULL),
  (841, 20, 'LA VIRGINIA', '66400', 1, '2017-06-20 02:32:12', NULL),
  (842, 20, 'MARSELLA', '66440', 1, '2017-06-20 02:32:12', NULL),
  (843, 20, 'MISTRATO', '66456', 1, '2017-06-20 02:32:12', NULL),
  (844, 20, 'PUEBLO RICO', '66572', 1, '2017-06-20 02:32:12', NULL),
  (845, 20, 'QUINCHIA', '66594', 1, '2017-06-20 02:32:12', NULL),
  (846, 20, 'SANTA ROSA DE CABAL', '66682', 1, '2017-06-20 02:32:12', NULL),
  (847, 20, 'SANTUARIO', '66687', 1, '2017-06-20 02:32:12', NULL),
  (848, 20, 'PEREIRA', '66001', 1, '2017-06-20 02:32:12', NULL),
  (849, 21, 'MATANZA', '68444', 1, '2017-06-20 02:32:13', NULL),
  (850, 21, 'MOGOTES', '68464', 1, '2017-06-20 02:32:13', NULL),
  (851, 21, 'ONZAGA', '68502', 1, '2017-06-20 02:32:13', NULL),
  (852, 21, 'PALMAR', '68522', 1, '2017-06-20 02:32:13', NULL),
  (853, 21, 'PINCHOTE', '68549', 1, '2017-06-20 02:32:13', NULL),
  (854, 21, 'PUENTE NACIONAL', '68572', 1, '2017-06-20 02:32:13', NULL),
  (855, 21, 'SAN ANDRES', '68669', 1, '2017-06-20 02:32:13', NULL),
  (856, 21, 'SAN BENITO', '68673', 1, '2017-06-20 02:32:13', NULL),
  (857, 21, 'SAN MIGUEL', '68686', 1, '2017-06-20 02:32:13', NULL),
  (858, 21, 'SAN VICENTE DE CHUCURI', '68689', 1, '2017-06-20 02:32:13', NULL),
  (859, 21, 'JORDAN', '68370', 1, '2017-06-20 02:32:13', NULL),
  (860, 21, 'BOLIVAR', '68101', 1, '2017-06-20 02:32:13', NULL),
  (861, 21, 'CHARTA', '68169', 1, '2017-06-20 02:32:14', NULL),
  (862, 21, 'CIMITARRA', '68190', 1, '2017-06-20 02:32:14', NULL),
  (863, 21, 'CONCEPCION', '68207', 1, '2017-06-20 02:32:14', NULL),
  (864, 21, 'EL CARMEN DE CHUCURI', '68235', 1, '2017-06-20 02:32:14', NULL),
  (865, 21, 'EL PEÃ‘ON', '68250', 1, '2017-06-20 02:32:14', NULL),
  (866, 21, 'FLORIDABLANCA', '68276', 1, '2017-06-20 02:32:14', NULL),
  (867, 21, 'GUACA', '68318', 1, '2017-06-20 02:32:14', NULL),
  (868, 21, 'GIRON', '68307', 1, '2017-06-20 02:32:14', NULL),
  (869, 21, 'VALLE DE SAN JOSE', '68855', 1, '2017-06-20 02:32:14', NULL),
  (870, 21, 'VELEZ', '68861', 1, '2017-06-20 02:32:14', NULL),
  (871, 21, 'CALIFORNIA', '68132', 1, '2017-06-20 02:32:14', NULL),
  (872, 21, 'BUCARAMANGA', '68001', 1, '2017-06-20 02:32:14', NULL),
  (873, 21, 'AGUADA', '68013', 1, '2017-06-20 02:32:14', NULL),
  (874, 21, 'ALBANIA', '68020', 1, '2017-06-20 02:32:14', NULL),
  (875, 21, 'ARATOCA', '68051', 1, '2017-06-20 02:32:14', NULL),
  (876, 21, 'BARBOSA', '68077', 1, '2017-06-20 02:32:14', NULL),
  (877, 21, 'BARICHARA', '68079', 1, '2017-06-20 02:32:14', NULL),
  (878, 21, 'BARRANCABERMEJA', '68081', 1, '2017-06-20 02:32:14', NULL),
  (879, 21, 'BETULIA', '68092', 1, '2017-06-20 02:32:14', NULL),
  (880, 21, 'CABRERA', '68121', 1, '2017-06-20 02:32:14', NULL),
  (881, 21, 'CAPITANEJO', '68147', 1, '2017-06-20 02:32:14', NULL),
  (882, 21, 'CARCASI', '68152', 1, '2017-06-20 02:32:14', NULL),
  (883, 21, 'CEPITA', '68160', 1, '2017-06-20 02:32:14', NULL),
  (884, 21, 'CERRITO', '68162', 1, '2017-06-20 02:32:14', NULL),
  (885, 21, 'CHARALA', '68167', 1, '2017-06-20 02:32:14', NULL),
  (886, 21, 'CHIMA', '68176', 1, '2017-06-20 02:32:14', NULL),
  (887, 21, 'CHIPATA', '68179', 1, '2017-06-20 02:32:14', NULL),
  (888, 21, 'CONFINES', '68209', 1, '2017-06-20 02:32:15', NULL),
  (889, 21, 'CONTRATACION', '68211', 1, '2017-06-20 02:32:15', NULL),
  (890, 21, 'COROMORO', '68217', 1, '2017-06-20 02:32:15', NULL),
  (891, 21, 'CURITI', '68229', 1, '2017-06-20 02:32:15', NULL),
  (892, 21, 'EL GUACAMAYO', '68245', 1, '2017-06-20 02:32:15', NULL),
  (893, 21, 'ENCINO', '68264', 1, '2017-06-20 02:32:15', NULL),
  (894, 21, 'ENCISO', '68266', 1, '2017-06-20 02:32:15', NULL),
  (895, 21, 'FLORIAN', '68271', 1, '2017-06-20 02:32:15', NULL),
  (896, 21, 'GALAN', '68296', 1, '2017-06-20 02:32:15', NULL),
  (897, 21, 'GAMBITA', '68298', 1, '2017-06-20 02:32:15', NULL),
  (898, 21, 'GUADALUPE', '68320', 1, '2017-06-20 02:32:15', NULL),
  (899, 21, 'GUAPOTA', '68322', 1, '2017-06-20 02:32:15', NULL),
  (900, 21, 'GUAVATA', '68324', 1, '2017-06-20 02:32:15', NULL),
  (901, 21, 'GUEPSA', '68327', 1, '2017-06-20 02:32:15', NULL),
  (902, 21, 'HATO', '68344', 1, '2017-06-20 02:32:15', NULL),
  (903, 21, 'JESUS MARIA', '68368', 1, '2017-06-20 02:32:15', NULL),
  (904, 21, 'LA BELLEZA', '68377', 1, '2017-06-20 02:32:15', NULL),
  (905, 21, 'LANDAZURI', '68385', 1, '2017-06-20 02:32:15', NULL),
  (906, 21, 'LA PAZ', '68397', 1, '2017-06-20 02:32:15', NULL),
  (907, 21, 'LEBRIJA', '68406', 1, '2017-06-20 02:32:15', NULL),
  (908, 21, 'MACARAVITA', '68425', 1, '2017-06-20 02:32:15', NULL),
  (909, 21, 'MALAGA', '68432', 1, '2017-06-20 02:32:16', NULL),
  (910, 21, 'MOLAGAVITA', '68468', 1, '2017-06-20 02:32:16', NULL),
  (911, 21, 'OCAMONTE', '68498', 1, '2017-06-20 02:32:16', NULL),
  (912, 21, 'OIBA', '68500', 1, '2017-06-20 02:32:16', NULL),
  (913, 21, 'PALMAS DEL SOCORRO', '68524', 1, '2017-06-20 02:32:16', NULL),
  (914, 21, 'PARAMO', '68533', 1, '2017-06-20 02:32:16', NULL),
  (915, 21, 'PIEDECUESTA', '68547', 1, '2017-06-20 02:32:16', NULL),
  (916, 21, 'PUERTO PARRA', '68573', 1, '2017-06-20 02:32:16', NULL),
  (917, 21, 'PUERTO WILCHES', '68575', 1, '2017-06-20 02:32:16', NULL),
  (918, 21, 'RIONEGRO', '68615', 1, '2017-06-20 02:32:16', NULL),
  (919, 21, 'SABANA DE TORRES', '68655', 1, '2017-06-20 02:32:16', NULL),
  (920, 21, 'SAN GIL', '68679', 1, '2017-06-20 02:32:16', NULL),
  (921, 21, 'SAN JOAQUIN', '68682', 1, '2017-06-20 02:32:16', NULL),
  (922, 21, 'SAN JOSE DE MIRANDA', '68684', 1, '2017-06-20 02:32:16', NULL),
  (923, 21, 'SANTA BARBARA', '68705', 1, '2017-06-20 02:32:16', NULL),
  (924, 21, 'SANTA HELENA DEL OPON', '68720', 1, '2017-06-20 02:32:16', NULL),
  (925, 21, 'SIMACOTA', '68745', 1, '2017-06-20 02:32:17', NULL),
  (926, 21, 'SOCORRO', '68755', 1, '2017-06-20 02:32:17', NULL),
  (927, 21, 'SUAITA', '68770', 1, '2017-06-20 02:32:17', NULL),
  (928, 21, 'SUCRE', '68773', 1, '2017-06-20 02:32:17', NULL),
  (929, 21, 'SURATA', '68780', 1, '2017-06-20 02:32:17', NULL),
  (930, 21, 'TONA', '68820', 1, '2017-06-20 02:32:17', NULL),
  (931, 21, 'VETAS', '68867', 1, '2017-06-20 02:32:17', NULL),
  (932, 21, 'VILLANUEVA', '68872', 1, '2017-06-20 02:32:17', NULL),
  (933, 21, 'ZAPATOCA', '68895', 1, '2017-06-20 02:32:17', NULL),
  (934, 21, 'EL PLAYON', '68255', 1, '2017-06-20 02:32:17', NULL),
  (935, 21, 'LOS SANTOS', '68418', 1, '2017-06-20 02:32:17', NULL),
  (936, 22, 'COVEÃ‘AS', '70221', 1, '2017-06-20 02:32:18', NULL),
  (937, 22, 'MORROA', '70473', 1, '2017-06-20 02:32:18', NULL),
  (938, 22, 'OVEJAS', '70508', 1, '2017-06-20 02:32:18', NULL),
  (939, 22, 'SAN ANTONIO DE PALMITO', '70523', 1, '2017-06-20 02:32:18', NULL),
  (940, 22, 'SAMPUES', '70670', 1, '2017-06-20 02:32:18', NULL),
  (941, 22, 'SAN BENITO ABAD', '70678', 1, '2017-06-20 02:32:18', NULL),
  (942, 22, 'SAN JUAN DE BETULIA', '70702', 1, '2017-06-20 02:32:18', NULL),
  (943, 22, 'SAN MARCOS', '70708', 1, '2017-06-20 02:32:18', NULL),
  (944, 22, 'SAN ONOFRE', '70713', 1, '2017-06-20 02:32:18', NULL),
  (945, 22, 'SAN PEDRO', '70717', 1, '2017-06-20 02:32:18', NULL),
  (946, 22, 'SINCE', '70742', 1, '2017-06-20 02:32:18', NULL),
  (947, 22, 'SUCRE', '70771', 1, '2017-06-20 02:32:18', NULL),
  (948, 22, 'TOLU', '70820', 1, '2017-06-20 02:32:18', NULL),
  (949, 22, 'TOLUVIEJO', '70823', 1, '2017-06-20 02:32:18', NULL),
  (950, 22, 'SINCELEJO', '70001', 1, '2017-06-20 02:32:18', NULL),
  (951, 22, 'BUENAVISTA', '70110', 1, '2017-06-20 02:32:18', NULL),
  (952, 22, 'CAIMITO', '70124', 1, '2017-06-20 02:32:18', NULL),
  (953, 22, 'CHALAN', '70230', 1, '2017-06-20 02:32:18', NULL),
  (954, 22, 'EL ROBLE', '70233', 1, '2017-06-20 02:32:18', NULL),
  (955, 22, 'GALERAS (NUEVA GRANADA)', '70235', 1, '2017-06-20 02:32:18', NULL),
  (956, 22, 'GUARANDA', '70265', 1, '2017-06-20 02:32:18', NULL),
  (957, 22, 'LA UNION DE SUCRE', '70400', 1, '2017-06-20 02:32:18', NULL),
  (958, 22, 'LOS PALMITOS', '70418', 1, '2017-06-20 02:32:18', NULL),
  (959, 22, 'MAJAGUAL', '70429', 1, '2017-06-20 02:32:19', NULL),
  (960, 22, 'COROZAL', '70215', 1, '2017-06-20 02:32:19', NULL),
  (961, 22, 'COLOSO/RICAURTE', '70204', 1, '2017-06-20 02:32:19', NULL),
  (962, 23, 'IBAGUE', '73001', 1, '2017-06-20 02:32:19', NULL),
  (963, 23, 'ALPUJARRA', '73024', 1, '2017-06-20 02:32:19', NULL),
  (964, 23, 'ALVARADO', '73026', 1, '2017-06-20 02:32:19', NULL),
  (965, 23, 'AMBALEMA', '73030', 1, '2017-06-20 02:32:19', NULL),
  (966, 23, 'ANZOATEGUI', '73043', 1, '2017-06-20 02:32:19', NULL),
  (967, 23, 'ARMERO (GUAYABAL)', '73055', 1, '2017-06-20 02:32:19', NULL),
  (968, 23, 'ATACO', '73067', 1, '2017-06-20 02:32:19', NULL),
  (969, 23, 'CAJAMARCA', '73124', 1, '2017-06-20 02:32:19', NULL),
  (970, 23, 'CARMEN DE APICALA', '73148', 1, '2017-06-20 02:32:19', NULL),
  (971, 23, 'CASABIANCA', '73152', 1, '2017-06-20 02:32:19', NULL),
  (972, 23, 'CHAPARRAL', '73168', 1, '2017-06-20 02:32:19', NULL),
  (973, 23, 'COELLO', '73200', 1, '2017-06-20 02:32:19', NULL),
  (974, 23, 'COYAIMA', '73217', 1, '2017-06-20 02:32:19', NULL),
  (975, 23, 'CUNDAY', '73226', 1, '2017-06-20 02:32:19', NULL),
  (976, 23, 'EL ESPINAL', '73268', 1, '2017-06-20 02:32:19', NULL),
  (977, 23, 'FALAN', '73270', 1, '2017-06-20 02:32:19', NULL),
  (978, 23, 'FLANDES', '73275', 1, '2017-06-20 02:32:19', NULL),
  (979, 23, 'FRESNO', '73283', 1, '2017-06-20 02:32:19', NULL),
  (980, 23, 'EL GUAMO', '73319', 1, '2017-06-20 02:32:19', NULL),
  (981, 23, 'ICONONZO', '73352', 1, '2017-06-20 02:32:20', NULL),
  (982, 23, 'LERIDA', '73408', 1, '2017-06-20 02:32:20', NULL),
  (983, 23, 'MARIQUITA', '73443', 1, '2017-06-20 02:32:20', NULL),
  (984, 23, 'MELGAR', '73449', 1, '2017-06-20 02:32:20', NULL),
  (985, 23, 'MURILLO', '73461', 1, '2017-06-20 02:32:20', NULL),
  (986, 23, 'PALOCABILDO', '73520', 1, '2017-06-20 02:32:20', NULL),
  (987, 23, 'PIEDRAS', '73547', 1, '2017-06-20 02:32:20', NULL),
  (988, 23, 'PLANADAS', '73555', 1, '2017-06-20 02:32:20', NULL),
  (989, 23, 'RONCESVALLES', '73622', 1, '2017-06-20 02:32:20', NULL),
  (990, 23, 'ROVIRA', '73624', 1, '2017-06-20 02:32:20', NULL),
  (991, 23, 'SALDAÃ‘A', '73671', 1, '2017-06-20 02:32:20', NULL),
  (992, 23, 'SAN ANTONIO', '73675', 1, '2017-06-20 02:32:20', NULL),
  (993, 23, 'SAN LUIS', '73678', 1, '2017-06-20 02:32:20', NULL),
  (994, 23, 'SANTA ISABEL', '73686', 1, '2017-06-20 02:32:20', NULL),
  (995, 23, 'SUAREZ', '73770', 1, '2017-06-20 02:32:20', NULL),
  (996, 23, 'VALLE DE SAN JUAN', '73854', 1, '2017-06-20 02:32:20', NULL),
  (997, 23, 'VENADILLO', '73861', 1, '2017-06-20 02:32:20', NULL),
  (998, 23, 'VILLAHERMOSA', '73870', 1, '2017-06-20 02:32:20', NULL),
  (999, 23, 'VILLARRICA', '73873', 1, '2017-06-20 02:32:20', NULL),
  (1000, 23, 'ORTEGA', '73504', 1, '2017-06-20 02:32:20', NULL),
  (1001, 23, 'NATAGAIMA', '73483', 1, '2017-06-20 02:32:20', NULL),
  (1002, 23, 'RIOBLANCO', '73616', 1, '2017-06-20 02:32:20', NULL),
  (1003, 23, 'DOLORES', '73236', 1, '2017-06-20 02:32:20', NULL),
  (1004, 23, 'HERVEO', '73347', 1, '2017-06-20 02:32:20', NULL),
  (1005, 23, 'HONDA', '73349', 1, '2017-06-20 02:32:20', NULL),
  (1006, 23, 'PRADO', '73563', 1, '2017-06-20 02:32:20', NULL),
  (1007, 23, 'LIBANO', '73411', 1, '2017-06-20 02:32:20', NULL),
  (1008, 23, 'PURIFICACION', '73585', 1, '2017-06-20 02:32:20', NULL),
  (1009, 24, 'FLORIDA', '76275', 1, '2017-06-20 02:32:21', NULL),
  (1010, 24, 'GINEBRA', '76306', 1, '2017-06-20 02:32:21', NULL),
  (1011, 24, 'GUACARI', '76318', 1, '2017-06-20 02:32:21', NULL),
  (1012, 24, 'JAMUNDI', '76364', 1, '2017-06-20 02:32:21', NULL),
  (1013, 24, 'LA CUMBRE', '76377', 1, '2017-06-20 02:32:21', NULL),
  (1014, 24, 'OBANDO', '76497', 1, '2017-06-20 02:32:21', NULL),
  (1015, 24, 'PRADERA', '76563', 1, '2017-06-20 02:32:21', NULL),
  (1016, 24, 'RESTREPO', '76606', 1, '2017-06-20 02:32:21', NULL),
  (1017, 24, 'RIOFRIO', '76616', 1, '2017-06-20 02:32:21', NULL),
  (1018, 24, 'ROLDANILLO', '76622', 1, '2017-06-20 02:32:21', NULL),
  (1019, 24, 'SAN PEDRO', '76670', 1, '2017-06-20 02:32:21', NULL),
  (1020, 24, 'SEVILLA', '76736', 1, '2017-06-20 02:32:21', NULL),
  (1021, 24, 'TORO', '76823', 1, '2017-06-20 02:32:21', NULL),
  (1022, 24, 'TRUJILLO', '76828', 1, '2017-06-20 02:32:21', NULL),
  (1023, 24, 'TULUA', '76834', 1, '2017-06-20 02:32:21', NULL),
  (1024, 24, 'VIJES', '76869', 1, '2017-06-20 02:32:21', NULL),
  (1025, 24, 'YOTOCO', '76890', 1, '2017-06-20 02:32:21', NULL),
  (1026, 24, 'SANTIAGO DE CALI', '76001', 1, '2017-06-20 02:32:21', NULL),
  (1027, 24, 'ALCALA', '76020', 1, '2017-06-20 02:32:21', NULL),
  (1028, 24, 'ANDALUCIA', '76036', 1, '2017-06-20 02:32:21', NULL),
  (1029, 24, 'ANSERMANUEVO', '76041', 1, '2017-06-20 02:32:21', NULL),
  (1030, 24, 'ARGELIA', '76054', 1, '2017-06-20 02:32:21', NULL),
  (1031, 24, 'BOLIVAR', '76100', 1, '2017-06-20 02:32:22', NULL),
  (1032, 24, 'BUENAVENTURA', '76109', 1, '2017-06-20 02:32:22', NULL),
  (1033, 24, 'GUADALAJARA DE BUGA', '76111', 1, '2017-06-20 02:32:22', NULL),
  (1034, 24, 'BUGALAGRANDE', '76113', 1, '2017-06-20 02:32:22', NULL),
  (1035, 24, 'CALIMA (DARIEN)', '76126', 1, '2017-06-20 02:32:22', NULL),
  (1036, 24, 'CANDELARIA', '76130', 1, '2017-06-20 02:32:22', NULL),
  (1037, 24, 'EL AGUILA', '76243', 1, '2017-06-20 02:32:22', NULL),
  (1038, 24, 'EL DOVIO', '76250', 1, '2017-06-20 02:32:22', NULL),
  (1039, 24, 'DAGUA', '76233', 1, '2017-06-20 02:32:22', NULL),
  (1040, 24, 'CAICEDONIA', '76122', 1, '2017-06-20 02:32:22', NULL),
  (1041, 24, 'CARTAGO', '76147', 1, '2017-06-20 02:32:22', NULL),
  (1042, 24, 'EL CAIRO', '76246', 1, '2017-06-20 02:32:22', NULL),
  (1043, 24, 'EL CERRITO', '76248', 1, '2017-06-20 02:32:22', NULL),
  (1044, 24, 'LA VICTORIA', '76403', 1, '2017-06-20 02:32:22', NULL),
  (1045, 24, 'ULLOA', '76845', 1, '2017-06-20 02:32:22', NULL),
  (1046, 24, 'VERSALLES', '76863', 1, '2017-06-20 02:32:22', NULL),
  (1047, 24, 'ZARZAL', '76895', 1, '2017-06-20 02:32:22', NULL),
  (1048, 24, 'YUMBO', '76892', 1, '2017-06-20 02:32:22', NULL),
  (1049, 24, 'LA UNION', '76400', 1, '2017-06-20 02:32:23', NULL),
  (1050, 24, 'PALMIRA', '76520', 1, '2017-06-20 02:32:23', NULL),
  (1051, 25, 'ARAUCA', '81001', 1, '2017-06-20 02:32:23', NULL),
  (1052, 25, 'ARAUQUITA', '81065', 1, '2017-06-20 02:32:23', NULL),
  (1053, 25, 'CRAVO NORTE', '81220', 1, '2017-06-20 02:32:23', NULL),
  (1054, 25, 'FORTUL', '81300', 1, '2017-06-20 02:32:23', NULL),
  (1055, 25, 'PUERTO RONDON', '81591', 1, '2017-06-20 02:32:23', NULL),
  (1056, 25, 'SARAVENA', '81736', 1, '2017-06-20 02:32:24', NULL),
  (1057, 25, 'TAME', '81794', 1, '2017-06-20 02:32:24', NULL),
  (1058, 26, 'YOPAL', '85001', 1, '2017-06-20 02:32:24', NULL),
  (1059, 26, 'AGUAZUL', '85010', 1, '2017-06-20 02:32:24', NULL),
  (1060, 26, 'CHAMEZA', '85015', 1, '2017-06-20 02:32:24', NULL),
  (1061, 26, 'HATO COROZAL', '85125', 1, '2017-06-20 02:32:24', NULL),
  (1062, 26, 'LA SALINA', '85136', 1, '2017-06-20 02:32:24', NULL),
  (1063, 26, 'MANI', '85139', 1, '2017-06-20 02:32:24', NULL),
  (1064, 26, 'MONTERREY', '85162', 1, '2017-06-20 02:32:24', NULL),
  (1065, 26, 'NUNCHIA', '85225', 1, '2017-06-20 02:32:24', NULL),
  (1066, 26, 'OROCUE', '85230', 1, '2017-06-20 02:32:24', NULL),
  (1067, 26, 'PAZ DE ARIPORO', '85250', 1, '2017-06-20 02:32:24', NULL),
  (1068, 26, 'PORE', '85263', 1, '2017-06-20 02:32:24', NULL),
  (1069, 26, 'RECETOR', '85279', 1, '2017-06-20 02:32:24', NULL),
  (1070, 26, 'SABANALARGA', '85300', 1, '2017-06-20 02:32:24', NULL),
  (1071, 26, 'SACAMA', '85315', 1, '2017-06-20 02:32:24', NULL),
  (1072, 26, 'SAN LUIS DE PALENQUE', '85325', 1, '2017-06-20 02:32:24', NULL),
  (1073, 26, 'TAMARA', '85400', 1, '2017-06-20 02:32:24', NULL),
  (1074, 26, 'TAURAMENA', '85410', 1, '2017-06-20 02:32:24', NULL),
  (1075, 26, 'TRINIDAD', '85430', 1, '2017-06-20 02:32:24', NULL),
  (1076, 26, 'VILLANUEVA', '85440', 1, '2017-06-20 02:32:24', NULL),
  (1077, 27, 'MOCOA', '86001', 1, '2017-06-20 02:32:25', NULL),
  (1078, 27, 'COLON', '86219', 1, '2017-06-20 02:32:25', NULL),
  (1079, 27, 'ORITO', '86320', 1, '2017-06-20 02:32:25', NULL),
  (1080, 27, 'PUERTO ASIS', '86568', 1, '2017-06-20 02:32:25', NULL),
  (1081, 27, 'PUERTO CAICEDO', '86569', 1, '2017-06-20 02:32:25', NULL),
  (1082, 27, 'PUERTO GUZMAN', '86571', 1, '2017-06-20 02:32:25', NULL),
  (1083, 27, 'PUERTO LEGUIZAMO', '86573', 1, '2017-06-20 02:32:25', NULL),
  (1084, 27, 'SIBUNDOY', '86749', 1, '2017-06-20 02:32:25', NULL),
  (1085, 27, 'SAN FRANCISCO', '86755', 1, '2017-06-20 02:32:25', NULL),
  (1086, 27, 'SAN MIGUEL', '86757', 1, '2017-06-20 02:32:25', NULL),
  (1087, 27, 'SANTIAGO', '86760', 1, '2017-06-20 02:32:25', NULL),
  (1088, 27, 'VALLE DEL GUAMUEZ', '86865', 1, '2017-06-20 02:32:25', NULL),
  (1089, 27, 'VILLAGARZON VILLA AMAZONICA', '86885', 1, '2017-06-20 02:32:25', NULL),
  (1090, 28, 'SAN ANDRES ISLAS', '88001', 1, '2017-06-20 02:32:26', NULL),
  (1091, 28, 'PROVIDENCIA', '88564', 1, '2017-06-20 02:32:26', NULL),
  (1092, 29, 'PUERTO ALEGRIA', '91530', 1, '2017-06-20 02:32:26', NULL),
  (1093, 29, 'LA VICTORIA', '91430', 1, '2017-06-20 02:32:26', NULL),
  (1094, 29, 'PUERTO ARICA', '91536', 1, '2017-06-20 02:32:26', NULL),
  (1095, 29, 'EL ENCANTO', '91263', 1, '2017-06-20 02:32:26', NULL),
  (1096, 29, 'LA CHORRERA', '91405', 1, '2017-06-20 02:32:26', NULL),
  (1097, 29, 'LA PEDRERA', '91407', 1, '2017-06-20 02:32:26', NULL),
  (1098, 29, 'LETICIA', '91001', 1, '2017-06-20 02:32:26', NULL),
  (1099, 29, 'MIRITI-PARANA', '91460', 1, '2017-06-20 02:32:26', NULL),
  (1100, 29, 'PUERTO NARIÃ‘O', '91540', 1, '2017-06-20 02:32:26', NULL),
  (1101, 29, 'PUERTO SANTANDER', '91669', 1, '2017-06-20 02:32:27', NULL),
  (1102, 29, 'TARAPACA', '91798', 1, '2017-06-20 02:32:27', NULL),
  (1103, 30, 'SAN FELIPE', '94883', 1, '2017-06-20 02:32:27', NULL),
  (1104, 30, 'PUERTO COLOMBIA', '94884', 1, '2017-06-20 02:32:27', NULL),
  (1105, 30, 'LA GUADALUPE', '94885', 1, '2017-06-20 02:32:27', NULL),
  (1106, 30, 'CACAHUAL', '94886', 1, '2017-06-20 02:32:27', NULL),
  (1107, 30, 'PANA PANA', '94887', 1, '2017-06-20 02:32:27', NULL),
  (1108, 30, 'MORICHAL', '94888', 1, '2017-06-20 02:32:27', NULL),
  (1109, 30, 'MAPIRIPANA', '94663', 1, '2017-06-20 02:32:27', NULL),
  (1110, 30, 'INIRIDA', '94001', 1, '2017-06-20 02:32:27', NULL),
  (1111, 30, 'BARRANCO MINAS', '94343', 1, '2017-06-20 02:32:27', NULL),
  (1112, 31, 'SAN JOSE DEL GUAVIARE', '95001', 1, '2017-06-20 02:32:28', NULL),
  (1113, 31, 'CALAMAR', '95015', 1, '2017-06-20 02:32:28', NULL),
  (1114, 31, 'EL RETORNO', '95025', 1, '2017-06-20 02:32:28', NULL),
  (1115, 31, 'MIRAFLORES', '95200', 1, '2017-06-20 02:32:28', NULL),
  (1116, 32, 'MITU', '97001', 1, '2017-06-20 02:32:28', NULL),
  (1117, 32, 'CARURU', '97161', 1, '2017-06-20 02:32:28', NULL),
  (1118, 32, 'PACOA', '97511', 1, '2017-06-20 02:32:28', NULL),
  (1119, 32, 'TARAIRA', '97666', 1, '2017-06-20 02:32:28', NULL),
  (1120, 32, 'PAPUNAUA', '97777', 1, '2017-06-20 02:32:28', NULL),
  (1121, 32, 'YAVARATE', '97889', 1, '2017-06-20 02:32:28', NULL),
  (1122, 33, 'PUERTO CARREÃ‘O', '99001', 1, '2017-06-20 02:32:29', NULL),
  (1123, 33, 'LA PRIMAVERA', '99524', 1, '2017-06-20 02:32:29', NULL),
  (1124, 33, 'SANTA ROSALIA', '99624', 1, '2017-06-20 02:32:29', NULL),
  (1125, 33, 'CUMARIBO', '99773', 1, '2017-06-20 02:32:29', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `departamentos`
  --
  
  CREATE TABLE `departamentos` (
    `id` bigint(20) NOT NULL,
    `departamento` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `codigo` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
    `estado` tinyint(4) NOT NULL DEFAULT '1',
    `creado` datetime NOT NULL,
    `editado` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Volcado de datos para la tabla `departamentos`
  --
  
  INSERT INTO `departamentos` (`id`, `departamento`, `codigo`, `estado`, `creado`, `editado`) VALUES
  (1, 'ANTIOQUIA', '05', 1, '2017-06-20 02:31:30', NULL),
  (2, 'ATLANTICO', '08', 1, '2017-06-20 02:31:36', NULL),
  (3, 'BOGOTA D.C.', '11', 1, '2017-06-20 02:31:37', NULL),
  (4, 'BOLIVAR', '13', 1, '2017-06-20 02:31:37', NULL),
  (5, 'BOYACA', '15', 1, '2017-06-20 02:31:39', NULL),
  (6, 'CALDAS', '17', 1, '2017-06-20 02:31:44', NULL),
  (7, 'CAQUETA', '18', 1, '2017-06-20 02:31:45', NULL),
  (8, 'CAUCA', '19', 1, '2017-06-20 02:31:46', NULL),
  (9, 'CESAR', '20', 1, '2017-06-20 02:31:48', NULL),
  (10, 'CORDOBA', '23', 1, '2017-06-20 02:31:49', NULL),
  (11, 'CUNDINAMARCA', '25', 1, '2017-06-20 02:31:51', NULL),
  (12, 'CHOCO', '27', 1, '2017-06-20 02:31:56', NULL),
  (13, 'HUILA', '41', 1, '2017-06-20 02:31:58', NULL),
  (14, 'LA GUAJIRA', '44', 1, '2017-06-20 02:32:00', NULL),
  (15, 'MAGDALENA', '47', 1, '2017-06-20 02:32:02', NULL),
  (16, 'META', '50', 1, '2017-06-20 02:32:03', NULL),
  (17, 'NARIÃ‘O', '52', 1, '2017-06-20 02:32:05', NULL),
  (18, 'NORTE DE SANTANDER', '54', 1, '2017-06-20 02:32:08', NULL),
  (19, 'QUINDIO', '63', 1, '2017-06-20 02:32:10', NULL),
  (20, 'RISARALDA', '66', 1, '2017-06-20 02:32:11', NULL),
  (21, 'SANTANDER', '68', 1, '2017-06-20 02:32:12', NULL),
  (22, 'SUCRE', '70', 1, '2017-06-20 02:32:17', NULL),
  (23, 'TOLIMA', '73', 1, '2017-06-20 02:32:19', NULL),
  (24, 'VALLE DEL CAUCA', '76', 1, '2017-06-20 02:32:21', NULL),
  (25, 'ARAUCA', '81', 1, '2017-06-20 02:32:23', NULL),
  (26, 'CASANARE', '85', 1, '2017-06-20 02:32:24', NULL),
  (27, 'PUTUMAYO', '86', 1, '2017-06-20 02:32:24', NULL),
  (28, 'ARCHIPIELAGO DE SAN ANDRES, SANTA CATALINA Y PROVIDENCIA', '88', 1, '2017-06-20 02:32:25', NULL),
  (29, 'AMAZONAS', '91', 1, '2017-06-20 02:32:26', NULL),
  (30, 'GUAINIA', '94', 1, '2017-06-20 02:32:27', NULL),
  (31, 'GUAVIARE', '95', 1, '2017-06-20 02:32:27', NULL),
  (32, 'VAUPES', '97', 1, '2017-06-20 02:32:28', NULL),
  (33, 'VICHADA', '99', 1, '2017-06-20 02:32:28', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `usuarios`
  --
  
  CREATE TABLE `usuarios` (
    `id` bigint(20) NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `clave` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `apellidos` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `tipo_documento` tinyint(4) DEFAULT NULL COMMENT '1.Cedula de Ciudadania,2.Cedula de Extrangeria,3.Targeta de Identidad,4.Pasaporte',
    `documento` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `celular` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `direccion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `ciudad_id` bigint(20) DEFAULT NULL,
    `sexo` tinyint(4) DEFAULT NULL COMMENT '1.Hombre,2.Mujer',
    `nacimiento` date DEFAULT NULL,
    `estado` tinyint(4) NOT NULL DEFAULT '1',
    `creado` datetime NOT NULL,
    `editado` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;
  
  --
  -- Volcado de datos para la tabla `usuarios`
  --
  
  INSERT INTO `usuarios` (`id`, `email`, `clave`, `nombre`, `apellidos`, `tipo_documento`, `documento`, `celular`, `direccion`, `ciudad_id`, `sexo`, `nacimiento`, `estado`, `creado`, `editado`) VALUES
  (1, 'jcjavier@hotmail.com', 'asdf1234', 'Javier', 'Cruz', 1, '79794338', '3017395532', 'Calle con Carrera', 0, 1, '1978-02-07', 1, '2017-06-19 18:53:05', '2017-06-19 21:41:47'),
  (2, 'test@gihco.co', 'asdf1234', 'Javier', 'test', NULL, '79794339', '30303', '', 0, 1, NULL, 1, '2017-06-19 20:39:22', NULL);
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `admins`
  --
  ALTER TABLE `admins`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `ciudades`
  --
  ALTER TABLE `ciudades`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `departamentos`
  --
  ALTER TABLE `departamentos`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `usuarios`
  --
  ALTER TABLE `usuarios`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `admins`
  --
  ALTER TABLE `admins`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT de la tabla `ciudades`
  --
  ALTER TABLE `ciudades`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1126;
  --
  -- AUTO_INCREMENT de la tabla `departamentos`
  --
  ALTER TABLE `departamentos`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
  --
  -- AUTO_INCREMENT de la tabla `usuarios`
  --
  ALTER TABLE `usuarios`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  /*!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 */;
  