venezuela.sql

--
-- Table structure for table `ciudades`
--

CREATE TABLE IF NOT EXISTS `ciudades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` int(2) NOT NULL,
  `ciudad` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1027 ;

--
-- Dumping data for table `ciudades`
--

INSERT INTO `ciudades` (`id`, `cod`, `ciudad`) VALUES
(1, 1, 'Acanaña'),
(2, 1, 'Cacurí'),
(3, 1, 'Camani'),
(4, 1, 'Comunidad'),
(5, 1, 'Curimacare'),
(6, 1, 'Isla Ratón'),
(7, 1, 'La Esmeralda'),
(8, 1, 'Laja Lisa'),
(9, 1, 'Limón de Parhueña'),
(10, 1, 'Macuruco'),
(11, 1, 'Maroa'),
(12, 1, 'Marueta'),
(13, 1, 'Mavaca'),
(14, 1, 'Munduapo'),
(15, 1, 'Pendare'),
(16, 1, 'Puerto Ayacucho'),
(17, 1, 'Samariapo'),
(18, 1, 'San Carlos de Río Negro'),
(19, 1, 'San Fernando de Atabapo'),
(20, 1, 'San Juan de Manapiare'),
(21, 1, 'San Pedro del Orinoco'),
(22, 1, 'Santa Lucía'),
(23, 1, 'Solano'),
(24, 1, 'Toky-Shamanaña'),
(25, 1, 'Victorino'),
(26, 1, '* OTRA'),
(27, 2, 'Anaco'),
(28, 2, 'Aragua de Barcelona'),
(29, 2, 'Atapirire'),
(30, 2, 'Barcelona'),
(31, 2, 'Bergantín'),
(32, 2, 'Boca de Chávez'),
(33, 2, 'Boca de Uchire'),
(34, 2, 'Boca del Pao'),
(35, 2, 'Caigua'),
(36, 2, 'Cantaura'),
(37, 2, 'Carapa'),
(38, 2, 'Clarines'),
(39, 2, 'El Carito'),
(40, 2, 'El Chaparro'),
(41, 2, 'El Hatillo'),
(42, 2, 'El Pao de Barcelona'),
(43, 2, 'El Pilar'),
(44, 2, 'El Tigre'),
(45, 2, 'Guanape'),
(46, 2, 'Guanta'),
(47, 2, 'José Gregorio Monagas'),
(48, 2, 'Lecherías'),
(49, 2, 'Mapire'),
(50, 2, 'Múcura'),
(51, 2, 'Mundo Nuevo'),
(52, 2, 'Naricual'),
(53, 2, 'Onoto'),
(54, 2, 'Pariaguán'),
(55, 2, 'Pertigalete'),
(56, 2, 'Píritu'),
(57, 2, 'Pozuelos'),
(58, 2, 'Pueblo Nuevo'),
(59, 2, 'Puerto La Cruz'),
(60, 2, 'Puerto Píritu'),
(61, 2, 'Sabana de Uchire'),
(62, 2, 'San Diego de Cabrutica'),
(63, 2, 'San Francisco'),
(64, 2, 'San Joaquín'),
(65, 2, 'San José de Guanipa (El Tigrito)'),
(66, 2, 'San Mateo'),
(67, 2, 'San Miguel'),
(68, 2, 'San Pablo'),
(69, 2, 'Santa Ana'),
(70, 2, 'Santa Bárbara'),
(71, 2, 'Santa Clara'),
(72, 2, 'Santa Cruz de Orinoco'),
(73, 2, 'Santa Inés'),
(74, 2, 'Santa Rosa'),
(75, 2, 'Soledad'),
(76, 2, 'Urica'),
(77, 2, 'Uverito'),
(78, 2, 'Valle de Guanape'),
(79, 2, 'Zuata'),
(80, 2, '* OTRA'),
(81, 3, 'Achaguas'),
(82, 3, 'Apurito'),
(83, 3, 'Arichuna'),
(84, 3, 'Biruaca'),
(85, 3, 'Bruzual'),
(86, 3, 'El Amparo'),
(87, 3, 'El Nula'),
(88, 3, 'El Recreo'),
(89, 3, 'El Samán de Apure'),
(90, 3, 'El Yagual'),
(91, 3, 'Elorza'),
(92, 3, 'Guachara'),
(93, 3, 'Guasdualito'),
(94, 3, 'Guasimal'),
(95, 3, 'La Estacada'),
(96, 3, 'La Trinidad de Orichuna'),
(97, 3, 'La Victoria'),
(98, 3, 'Mantecal'),
(99, 3, 'Palmarito'),
(100, 3, 'Puerto Páez'),
(101, 3, 'Quintero'),
(102, 3, 'San Fernando de Apure'),
(103, 3, 'San Juan de Payara'),
(104, 3, 'San Miguel de Cunaviche'),
(105, 3, 'San Rafael de Atamaica'),
(106, 3, 'San Vicente'),
(107, 3, '* OTRA'),
(108, 4, '19 de Abril'),
(109, 4, 'Barbacoas'),
(110, 4, 'Bella Vista'),
(111, 4, 'Cagua'),
(112, 4, 'Camatagua'),
(113, 4, 'Caña de Azúcar'),
(114, 4, 'Carmen de Cura'),
(115, 4, 'Choroní'),
(116, 4, 'Chuao'),
(117, 4, 'El Consejo'),
(118, 4, 'El Limón'),
(119, 4, 'Francisco de Miranda'),
(120, 4, 'Güiripa'),
(121, 4, 'La Colonia Tovar'),
(122, 4, 'La Pica'),
(123, 4, 'La Victoria'),
(124, 4, 'Las Guacamayas'),
(125, 4, 'Las Mercedes'),
(126, 4, 'Las Peñitas'),
(127, 4, 'Las Tejerías'),
(128, 4, 'Los Bagres'),
(129, 4, 'Magdaleno'),
(130, 4, 'Maracay'),
(131, 4, 'Ocumare de la Costa'),
(132, 4, 'Ollas de Caramacate'),
(133, 4, 'Palo Negro'),
(134, 4, 'Pao de Zárate'),
(135, 4, 'Paraparal'),
(136, 4, 'Rosario de Paya'),
(137, 4, 'San Casimiro'),
(138, 4, 'San Francisco de Asís'),
(139, 4, 'San Francisco de Cara'),
(140, 4, 'San Joaquín'),
(141, 4, 'San Mateo'),
(142, 4, 'San Sebastián'),
(143, 4, 'Santa Cruz'),
(144, 4, 'Santa Rita'),
(145, 4, 'Taguay'),
(146, 4, 'Tiara'),
(147, 4, 'Tocorón'),
(148, 4, 'Turmero'),
(149, 4, 'Valle Morín'),
(150, 4, 'Villa de Cura'),
(151, 4, 'Zuata'),
(152, 4, '* OTRA'),
(153, 5, 'Altamira'),
(154, 5, 'Arismendi'),
(155, 5, 'Barinas'),
(156, 5, 'Barinitas'),
(157, 5, 'Barrancas'),
(158, 5, 'Bum-Bum'),
(159, 5, 'Calderas'),
(160, 5, 'Capitanejo'),
(161, 5, 'Chameta'),
(162, 5, 'Ciudad Bolivia'),
(163, 5, 'Ciudad de Nutrias'),
(164, 5, 'Curbatí'),
(165, 5, 'Dolores'),
(166, 5, 'El Cantón'),
(167, 5, 'El Corozo'),
(168, 5, 'El Real'),
(169, 5, 'El Regalo'),
(170, 5, 'Guadarrama'),
(171, 5, 'La Caramuca'),
(172, 5, 'La Luz'),
(173, 5, 'La Mula'),
(174, 5, 'La Unión'),
(175, 5, 'La Yuca'),
(176, 5, 'Libertad'),
(177, 5, 'Los Guasimitos'),
(178, 5, 'Maporal'),
(179, 5, 'Masparrito'),
(180, 5, 'Mijagual'),
(181, 5, 'Obispos'),
(182, 5, 'Pedraza La Vieja'),
(183, 5, 'Puerto de Nutrias'),
(184, 5, 'Puerto Vivas'),
(185, 5, 'Punta de Piedra'),
(186, 5, 'Quebrada Seca'),
(187, 5, 'Sabaneta'),
(188, 5, 'San Antonio'),
(189, 5, 'San Rafael de Canaguá'),
(190, 5, 'San Silvestre'),
(191, 5, 'Santa Bárbara'),
(192, 5, 'Santa Catalina'),
(193, 5, 'Santa Cruz de Guacas'),
(194, 5, 'Santa Inés'),
(195, 5, 'Santa Lucía'),
(196, 5, 'Santa Rosa'),
(197, 5, 'Socopó'),
(198, 5, 'Torunos'),
(199, 5, 'Veguitas'),
(200, 5, '* OTRA'),
(201, 6, 'Almacén'),
(202, 6, 'Aripao'),
(203, 6, 'Caicara del Orinoco'),
(204, 6, 'Ciudad Bolívar'),
(205, 6, 'Ciudad Guayana'),
(206, 6, 'Ciudad Piar'),
(207, 6, 'El Callao'),
(208, 6, 'El Dorado'),
(209, 6, 'El Manteco'),
(210, 6, 'El Miamo'),
(211, 6, 'El Milagro'),
(212, 6, 'El Palmar'),
(213, 6, 'El Pao de El Hierro'),
(214, 6, 'El Rosario'),
(215, 6, 'Guarataro'),
(216, 6, 'Guasipati'),
(217, 6, 'Ikabarú'),
(218, 6, 'La Carolina'),
(219, 6, 'La Paragua'),
(220, 6, 'La Urbana'),
(221, 6, 'Las Bonitas'),
(222, 6, 'Las Claritas'),
(223, 6, 'Las Majadas'),
(224, 6, 'Maripa'),
(225, 6, 'Moitaco'),
(226, 6, 'Morichalito'),
(227, 6, 'Pozo Verde'),
(228, 6, 'San Francisco'),
(229, 6, 'San José de Bongo'),
(230, 6, 'Santa Bárbara de Centurión'),
(231, 6, 'Santa Elena de Uairén'),
(232, 6, 'Santa Rosalía'),
(233, 6, 'Tumeremo'),
(234, 6, 'Upata'),
(235, 6, '* OTRA'),
(236, 7, 'Bejuma'),
(237, 7, 'Belén'),
(238, 7, 'Borburata'),
(239, 7, 'Canoabo'),
(240, 7, 'Central Tacarigua'),
(241, 7, 'Chirgua'),
(242, 7, 'Guacara'),
(243, 7, 'Güigüe'),
(244, 7, 'Los Guayos'),
(245, 7, 'Los Naranjos'),
(246, 7, 'Mariara'),
(247, 7, 'Miranda'),
(248, 7, 'Montalbán'),
(249, 7, 'Morón'),
(250, 7, 'Naguanagua'),
(251, 7, 'Patanemo'),
(252, 7, 'Puerto Cabello'),
(253, 7, 'San Diego'),
(254, 7, 'San Joaquín'),
(255, 7, 'Tocuyito'),
(256, 7, 'Urama'),
(257, 7, 'Valencia'),
(258, 7, 'Yagua'),
(259, 7, '* OTRA'),
(260, 8, 'Apartaderos'),
(261, 8, 'Cojedes'),
(262, 8, 'El Amparo'),
(263, 8, 'El Baúl'),
(264, 8, 'El Pao'),
(265, 8, 'La Aguadita'),
(266, 8, 'La Sierra'),
(267, 8, 'Las Vegas'),
(268, 8, 'Libertad'),
(269, 8, 'Macapo'),
(270, 8, 'Manrique'),
(271, 8, 'San Carlos'),
(272, 8, 'Sucre'),
(273, 8, 'Tinaco'),
(274, 8, 'Tinaquillo'),
(275, 8, '* OTRA'),
(276, 9, 'Araguabisi'),
(277, 9, 'Araguaimujo'),
(278, 9, 'Boca de Cuyubini'),
(279, 9, 'Capure'),
(280, 9, 'Carapal de Guara'),
(281, 9, 'Curiapo'),
(282, 9, 'El Triunfo'),
(283, 9, 'Hacienda del Medio'),
(284, 9, 'La Horqueta'),
(285, 9, 'Manoa'),
(286, 9, 'Moruca'),
(287, 9, 'Paloma'),
(288, 9, 'Pedernales'),
(289, 9, 'Piacoa'),
(290, 9, 'San Francisco de Guayo'),
(291, 9, 'San Rafael'),
(292, 9, 'Santa Catalina'),
(293, 9, 'Sierra Imataca'),
(294, 9, 'Tucupita'),
(295, 9, 'Urbanización Delfín Mendoza'),
(296, 9, 'Urbanización Leonardo Ruíz Pineda'),
(297, 9, '* OTRA'),
(298, 10, 'Caracas'),
(299, 10, '* OTRA'),
(300, 11, 'Acurigua'),
(301, 11, 'Adaure'),
(302, 11, 'Adícora'),
(303, 11, 'Agua Larga'),
(304, 11, 'Agua Linda'),
(305, 11, 'Aracua'),
(306, 11, 'Araurima'),
(307, 11, 'Baraived'),
(308, 11, 'Bariro'),
(309, 11, 'Boca de Aroa'),
(310, 11, 'Boca de Tocuyo'),
(311, 11, 'Borojó'),
(312, 11, 'Buena Vista'),
(313, 11, 'Cabure'),
(314, 11, 'Capadare'),
(315, 11, 'Capatárida'),
(316, 11, 'Casigua'),
(317, 11, 'Chichiriviche'),
(318, 11, 'Churuguara'),
(319, 11, 'Coro'),
(320, 11, 'Curimagua'),
(321, 11, 'Dabajuro'),
(322, 11, 'El Charal'),
(323, 11, 'El Hato'),
(324, 11, 'El Manantial (Agua Clara)'),
(325, 11, 'El Mene de San Lorenzo'),
(326, 11, 'El Moyepo'),
(327, 11, 'El Paují'),
(328, 11, 'El Tupí'),
(329, 11, 'El Vínculo'),
(330, 11, 'Guaibacoa'),
(331, 11, 'Guajiro'),
(332, 11, 'Jacura'),
(333, 11, 'Jadacaquiva'),
(334, 11, 'Judibana'),
(335, 11, 'La Ciénaga'),
(336, 11, 'La Cruz de Taratara'),
(337, 11, 'La Negrita'),
(338, 11, 'La Pastora'),
(339, 11, 'La Peña'),
(340, 11, 'La Soledad'),
(341, 11, 'La Vela de Coro'),
(342, 11, 'Las Calderas'),
(343, 11, 'Las Vegas del Tuy'),
(344, 11, 'Mapararí'),
(345, 11, 'Mene de Mauroa'),
(346, 11, 'Mirimire'),
(347, 11, 'Mitare'),
(348, 11, 'Moruy'),
(349, 11, 'Palmasola'),
(350, 11, 'Pecaya'),
(351, 11, 'Pedregal'),
(352, 11, 'Piedra Grande'),
(353, 11, 'Píritu'),
(354, 11, 'Pueblo Cumarebo'),
(355, 11, 'Pueblo Nuevo'),
(356, 11, 'Pueblo Nuevo de la Sierra'),
(357, 11, 'Puerto Cumarebo'),
(358, 11, 'Punta Cardón'),
(359, 11, 'Punto Fijo'),
(360, 11, 'Purureche'),
(361, 11, 'Río Seco'),
(362, 11, 'Sabaneta'),
(363, 11, 'San Félix'),
(364, 11, 'San José de Bruzual'),
(365, 11, 'San José de la Costa'),
(366, 11, 'San José de Seque'),
(367, 11, 'San Juan  de los Cayos'),
(368, 11, 'San Juan de los Cayos'),
(369, 11, 'San Luis'),
(370, 11, 'Santa Ana'),
(371, 11, 'Santa Ana de Coro'),
(372, 11, 'Santa Cruz de Bucaral'),
(373, 11, 'Santa Cruz de Los Taques'),
(374, 11, 'Tocópero'),
(375, 11, 'Tocuyo de La Costa'),
(376, 11, 'Tucacas'),
(377, 11, 'Tupure'),
(378, 11, 'Urumaco'),
(379, 11, 'Yaracal'),
(380, 11, 'Zazárida'),
(381, 11, '* OTRA'),
(382, 12, 'Altagracia de Orituco'),
(383, 12, 'Altamira'),
(384, 12, 'Cabruta'),
(385, 12, 'Calabozo'),
(386, 12, 'Camaguán'),
(387, 12, 'Cantagallo'),
(388, 12, 'Cazorla'),
(389, 12, 'Chaguaramas'),
(390, 12, 'El Calvario'),
(391, 12, 'El Rastro'),
(392, 12, 'El Socorro'),
(393, 12, 'El Sombrero'),
(394, 12, 'Espino'),
(395, 12, 'Guardatinajas'),
(396, 12, 'Guayabal'),
(397, 12, 'La Unión de Canuto'),
(398, 12, 'Las Mercedes'),
(399, 12, 'Lezama'),
(400, 12, 'Libertad de Orituco'),
(401, 12, 'Ortiz'),
(402, 12, 'Parapara'),
(403, 12, 'Paso Real de Macaira'),
(404, 12, 'Puerto Miranda'),
(405, 12, 'Sabana Grande de Orituco'),
(406, 12, 'San Francisco de Macaira'),
(407, 12, 'San Francisco de Tiznados'),
(408, 12, 'San José de Guaribe'),
(409, 12, 'San José de Tiznados'),
(410, 12, 'San José de Unare'),
(411, 12, 'San Juan de Los Morros'),
(412, 12, 'San Rafael de Laya'),
(413, 12, 'San Rafael de Orituco'),
(414, 12, 'Santa María de Ipire'),
(415, 12, 'Santa Rita'),
(416, 12, 'Sosa'),
(417, 12, 'Tucupido'),
(418, 12, 'Uverito'),
(419, 12, 'Valle de La Pascua'),
(420, 12, 'Zaraza'),
(421, 12, '* OTRA'),
(422, 13, 'Agua Negra'),
(423, 13, 'Agua Viva'),
(424, 13, 'Aguada Grande'),
(425, 13, 'Altagracia'),
(426, 13, 'Anzoátegui'),
(427, 13, 'Aregue'),
(428, 13, 'Arenales'),
(429, 13, 'Atarigua'),
(430, 13, 'Baragua'),
(431, 13, 'Barbacoas'),
(432, 13, 'Barquisimeto'),
(433, 13, 'Bobare'),
(434, 13, 'Buena Vista'),
(435, 13, 'Burere'),
(436, 13, 'Cabudare'),
(437, 13, 'Carora'),
(438, 13, 'Cuara'),
(439, 13, 'Cubiro'),
(440, 13, 'Curarigua'),
(441, 13, 'Duaca'),
(442, 13, 'El Empedrado'),
(443, 13, 'El Eneal'),
(444, 13, 'El Hato'),
(445, 13, 'El Jabón'),
(446, 13, 'El Paradero'),
(447, 13, 'El Tocuyo'),
(448, 13, 'Guaitó'),
(449, 13, 'Guarico'),
(450, 13, 'Humocaro Alto'),
(451, 13, 'Humocaro Bajo'),
(452, 13, 'La Bucarita'),
(453, 13, 'La Ceiba'),
(454, 13, 'La Escalera'),
(455, 13, 'La Miel'),
(456, 13, 'La Pastora'),
(457, 13, 'Los Rastrojos'),
(458, 13, 'Manzanita'),
(459, 13, 'Palmarito'),
(460, 13, 'Parapara'),
(461, 13, 'Quebrada Arriba'),
(462, 13, 'Quíbor'),
(463, 13, 'Río Claro'),
(464, 13, 'Río Tocuyo'),
(465, 13, 'San Francisco'),
(466, 13, 'San Miguel'),
(467, 13, 'San Pedro'),
(468, 13, 'Sanare'),
(469, 13, 'Santa Inés'),
(470, 13, 'Sarare'),
(471, 13, 'Siquisique'),
(472, 13, 'Tintorero'),
(473, 13, 'Villanueva'),
(474, 13, '* OTRA'),
(475, 14, 'Acequias'),
(476, 14, 'Arapuey'),
(477, 14, 'Aricagua'),
(478, 14, 'Bailadores'),
(479, 14, 'Cacute'),
(480, 14, 'Campo Elías'),
(481, 14, 'Canaguá'),
(482, 14, 'Caño Tigre'),
(483, 14, 'Capurí'),
(484, 14, 'Chacantá'),
(485, 14, 'Chachopo'),
(486, 14, 'Chiguará'),
(487, 14, 'Ejido'),
(488, 14, 'El Molino'),
(489, 14, 'El Morro'),
(490, 14, 'El Pinar'),
(491, 14, 'El Viento'),
(492, 14, 'El Vigía'),
(493, 14, 'Estánquez'),
(494, 14, 'Guaraque'),
(495, 14, 'Guayabones'),
(496, 14, 'Jají'),
(497, 14, 'La Azulita'),
(498, 14, 'La Blanca (12 de Octubre)'),
(499, 14, 'La Mesa'),
(500, 14, 'La Palmita'),
(501, 14, 'La Playa'),
(502, 14, 'La Toma'),
(503, 14, 'La Trampa'),
(504, 14, 'La Venta'),
(505, 14, 'Lagunillas'),
(506, 14, 'Las Piedras'),
(507, 14, 'Las Virtudes'),
(508, 14, 'Los Naranjos'),
(509, 14, 'Los Nevados'),
(510, 14, 'Mérida'),
(511, 14, 'Mesa Bolívar'),
(512, 14, 'Mesa de las Palmas'),
(513, 14, 'Mesa de Quintero'),
(514, 14, 'Mucuchachí'),
(515, 14, 'Mucuchíes'),
(516, 14, 'Mucujepe'),
(517, 14, 'Mucurubá'),
(518, 14, 'Mucutuy'),
(519, 14, 'Nueva Bolivia'),
(520, 14, 'Palmarito'),
(521, 14, 'Piñango'),
(522, 14, 'Pueblo Llano'),
(523, 14, 'Pueblo Nuevo del Sur'),
(524, 14, 'Río Negro'),
(525, 14, 'San Cristóbal de Torondoy'),
(526, 14, 'San José'),
(527, 14, 'San José de Palmira'),
(528, 14, 'San Juan'),
(529, 14, 'San Rafael'),
(530, 14, 'San Rafael de Alcázar'),
(531, 14, 'Santa Apolonia'),
(532, 14, 'Santa Cruz de Mora'),
(533, 14, 'Santa Elena de Arenales'),
(534, 14, 'Santa María de Caparo'),
(535, 14, 'Santo Domingo'),
(536, 14, 'Tabay'),
(537, 14, 'Timotes'),
(538, 14, 'Torondoy'),
(539, 14, 'Tovar'),
(540, 14, 'Tucaní'),
(541, 14, 'Zea'),
(542, 14, '* OTRA'),
(543, 15, 'Altagracia de la Montaña'),
(544, 15, 'Aragüita'),
(545, 15, 'Araira'),
(546, 15, 'Capaya'),
(547, 15, 'Carrizal'),
(548, 15, 'Caucagua'),
(549, 15, 'Caucagüita'),
(550, 15, 'Chacao'),
(551, 15, 'Charallave'),
(552, 15, 'Cúa'),
(553, 15, 'Cumbo'),
(554, 15, 'Cúpira'),
(555, 15, 'Curiepe'),
(556, 15, 'El Café'),
(557, 15, 'El Cafetal'),
(558, 15, 'El Cartanal'),
(559, 15, 'El Clavo'),
(560, 15, 'El Guapo'),
(561, 15, 'El Hatillo'),
(562, 15, 'El Jarillo'),
(563, 15, 'Fila de Mariches'),
(564, 15, 'Guarenas'),
(565, 15, 'Guatire'),
(566, 15, 'Higuerote'),
(567, 15, 'La Democracia'),
(568, 15, 'La Dolorita'),
(569, 15, 'Las Brisas'),
(570, 15, 'Las Minas de Baruta'),
(571, 15, 'Los Dos Caminos'),
(572, 15, 'Los Teques'),
(573, 15, 'Machurucuto'),
(574, 15, 'Mamporal'),
(575, 15, 'Marizapa'),
(576, 15, 'Nuestra Señora del Rosario de Baruta'),
(577, 15, 'Nueva Cúa'),
(578, 15, 'Ocumare del Tuy'),
(579, 15, 'Panaquire'),
(580, 15, 'Paparo'),
(581, 15, 'Paracotos'),
(582, 15, 'Petare'),
(583, 15, 'Río Chico'),
(584, 15, 'San Antonio de Los Altos'),
(585, 15, 'San Antonio de Yare'),
(586, 15, 'San Diego'),
(587, 15, 'San Fernando'),
(588, 15, 'San Francisco de Yare'),
(589, 15, 'San José de Barlovento'),
(590, 15, 'San Pedro'),
(591, 15, 'Santa Bárbara'),
(592, 15, 'Santa Lucía'),
(593, 15, 'Santa Teresa del Tuy'),
(594, 15, 'Tacarigua de La Laguna'),
(595, 15, 'Tacarigua de Mamporal'),
(596, 15, 'Tácata'),
(597, 15, 'Tapipa'),
(598, 15, '* OTRA'),
(599, 16, 'Aguasay'),
(600, 16, 'Aparicio'),
(601, 16, 'Aragua'),
(602, 16, 'Areo'),
(603, 16, 'Barrancas'),
(604, 16, 'Cachipo'),
(605, 16, 'Caicara'),
(606, 16, 'Caripe'),
(607, 16, 'Caripito'),
(608, 16, 'Chaguaramal'),
(609, 16, 'Chaguaramas'),
(610, 16, 'El Corozo'),
(611, 16, 'El Furrial'),
(612, 16, 'El Guácharo'),
(613, 16, 'El Pinto'),
(614, 16, 'El Tejero'),
(615, 16, 'Guanaguana'),
(616, 16, 'Jusepín'),
(617, 16, 'La Guanota'),
(618, 16, 'La Pica'),
(619, 16, 'La Toscana'),
(620, 16, 'Las Alhuacas'),
(621, 16, 'Los Barrancos de Fajardo'),
(622, 16, 'Maturín'),
(623, 16, 'Punta de Mata'),
(624, 16, 'Quiriquire'),
(625, 16, 'Sabana de Piedra'),
(626, 16, 'San Agustín'),
(627, 16, 'San Antonio'),
(628, 16, 'San Félix'),
(629, 16, 'San Francisco'),
(630, 16, 'San Vicente'),
(631, 16, 'Santa Bárbara'),
(632, 16, 'Tabasca'),
(633, 16, 'Taguaya'),
(634, 16, 'Temblador'),
(635, 16, 'Teresén'),
(636, 16, 'Uracoa'),
(637, 16, 'Viento Fresco'),
(638, 16, '* OTRA'),
(639, 17, 'Altagracia'),
(640, 17, 'Boca del Pozo'),
(641, 17, 'Boca del Río'),
(642, 17, 'El Guamache'),
(643, 17, 'El Maco'),
(644, 17, 'El Pilar (Los Robles)'),
(645, 17, 'El Valle del Espíritu Santo'),
(646, 17, 'Güinima'),
(647, 17, 'Juangriego'),
(648, 17, 'La Asunción'),
(649, 17, 'La Guardia'),
(650, 17, 'La Plaza de Paraguachí'),
(651, 17, 'Los Millanes'),
(652, 17, 'Pampatar'),
(653, 17, 'Pedro González'),
(654, 17, 'Porlamar'),
(655, 17, 'Punta de Piedras'),
(656, 17, 'San Juan Bautista'),
(657, 17, 'San Pedro de Coche'),
(658, 17, 'Santa Ana'),
(659, 17, 'Tacarigua'),
(660, 17, 'Villa Rosa'),
(661, 17, '* OTRA'),
(662, 18, 'Acarigua'),
(663, 18, 'Agua Blanca'),
(664, 18, 'Araure'),
(665, 18, 'Biscucuy'),
(666, 18, 'Boconoito'),
(667, 18, 'Caño Delgadito'),
(668, 18, 'Colonia Turén'),
(669, 18, 'Córdoba'),
(670, 18, 'El Algarrobito'),
(671, 18, 'El Playón'),
(672, 18, 'Guanare'),
(673, 18, 'Guanarito'),
(674, 18, 'La Aparición'),
(675, 18, 'La Concepción'),
(676, 18, 'La Estación'),
(677, 18, 'La Misión'),
(678, 18, 'Las Cruces'),
(679, 18, 'Mesa de Cavacas'),
(680, 18, 'Mijagüito'),
(681, 18, 'Morrones'),
(682, 18, 'Nueva Florida'),
(683, 18, 'Ospino'),
(684, 18, 'Papelón'),
(685, 18, 'Paraíso de Chabasquén'),
(686, 18, 'Payara'),
(687, 18, 'Peña Blanca'),
(688, 18, 'Pimpinela'),
(689, 18, 'Píritu'),
(690, 18, 'Quebrada de la Virgen'),
(691, 18, 'Río Acarigua'),
(692, 18, 'San José de la Montaña'),
(693, 18, 'San José de Saguaz'),
(694, 18, 'San Nicolás'),
(695, 18, 'San Rafael de Onoto'),
(696, 18, 'San Rafael de Palo Alzado'),
(697, 18, 'Santa Cruz'),
(698, 18, 'Santa Fe'),
(699, 18, 'Trinidad de la Capilla'),
(700, 18, 'Uveral'),
(701, 18, 'Villa Bruzual'),
(702, 18, 'Villa Rosa'),
(703, 18, '* OTRA'),
(704, 19, 'Araya'),
(705, 19, 'Arenas'),
(706, 19, 'Aricagua'),
(707, 19, 'Caigüire'),
(708, 19, 'Campo Claro'),
(709, 19, 'Cariaco'),
(710, 19, 'Carúpano'),
(711, 19, 'Casanay'),
(712, 19, 'Catuaro'),
(713, 19, 'Chacopata'),
(714, 19, 'Cumaná'),
(715, 19, 'Cumanacoa'),
(716, 19, 'El Morro de Puerto Santo'),
(717, 19, 'El Paujil'),
(718, 19, 'El Pilar'),
(719, 19, 'El Rincón'),
(720, 19, 'Guaraúnos'),
(721, 19, 'Guariquén'),
(722, 19, 'Guayana'),
(723, 19, 'Güiria'),
(724, 19, 'Irapa'),
(725, 19, 'Las Piedras'),
(726, 19, 'Los Altos'),
(727, 19, 'Los Arroyos'),
(728, 19, 'Los Puertos de Santa Fe'),
(729, 19, 'Macuro'),
(730, 19, 'Manicuare'),
(731, 19, 'Marabal'),
(732, 19, 'Marigüitar'),
(733, 19, 'Playa Grande'),
(734, 19, 'Puerto Santo'),
(735, 19, 'Río Caribe'),
(736, 19, 'Río Casanay'),
(737, 19, 'Rio Salado'),
(738, 19, 'Río Seco'),
(739, 19, 'San Antonio de Irapa'),
(740, 19, 'San Antonio del Golfo'),
(741, 19, 'San José de Aerocuar'),
(742, 19, 'San Juan'),
(743, 19, 'San Juan de Las Galdonas'),
(744, 19, 'San Juan de Unare'),
(745, 19, 'San Lorenzo'),
(746, 19, 'San Vicente'),
(747, 19, 'Santa Cruz'),
(748, 19, 'Santa María'),
(749, 19, 'Soro'),
(750, 19, 'Tunapuicito'),
(751, 19, 'Tunapuy'),
(752, 19, 'Villa Frontado (Muelle de Cariaco)'),
(753, 19, 'Villarroel (Quebrada Seca)'),
(754, 19, 'Yaguaraparo'),
(755, 19, 'Yoco'),
(756, 19, '* OTRA'),
(757, 20, 'Abejales'),
(758, 20, 'Aguas Calientes'),
(759, 20, 'Boca de Grita'),
(760, 20, 'Boconó'),
(761, 20, 'Borotá'),
(762, 20, 'Bramón'),
(763, 20, 'Capacho Nuevo'),
(764, 20, 'Capacho Viejo'),
(765, 20, 'Colón'),
(766, 20, 'Coloncito'),
(767, 20, 'Cordero'),
(768, 20, 'Delicias'),
(769, 20, 'EL Cobre'),
(770, 20, 'El Milagro'),
(771, 20, 'El Pueblito'),
(772, 20, 'El Recreo'),
(773, 20, 'El Valle'),
(774, 20, 'Hato de la Virgen'),
(775, 20, 'Hernández'),
(776, 20, 'La Florida'),
(777, 20, 'La Fría'),
(778, 20, 'La Fundación'),
(779, 20, 'La Grita'),
(780, 20, 'La Palmita'),
(781, 20, 'La Tendida'),
(782, 20, 'Laguna de García'),
(783, 20, 'Las Dantas'),
(784, 20, 'Las Mesas'),
(785, 20, 'Lobatera'),
(786, 20, 'Macanillo'),
(787, 20, 'Mesa del Tigre'),
(788, 20, 'Michelena'),
(789, 20, 'Orope'),
(790, 20, 'Palmira'),
(791, 20, 'Palo Gordo'),
(792, 20, 'Palotal'),
(793, 20, 'Patio Redondo'),
(794, 20, 'Peribeca'),
(795, 20, 'Pregonero'),
(796, 20, 'Pueblo Hondo'),
(797, 20, 'Puerto Nuevo'),
(798, 20, 'Puerto Teteo'),
(799, 20, 'Queniquea'),
(800, 20, 'Río Chiquito'),
(801, 20, 'Rubio'),
(802, 20, 'Sabana Grande'),
(803, 20, 'San Antonio del Táchira'),
(804, 20, 'San Cristóbal'),
(805, 20, 'San Félix'),
(806, 20, 'San Joaquín de Navay'),
(807, 20, 'San José de Bolívar'),
(808, 20, 'San Josecito'),
(809, 20, 'San Lorenzo'),
(810, 20, 'San Pablo'),
(811, 20, 'San Pedro del Río'),
(812, 20, 'San Rafael del Piñal'),
(813, 20, 'San Simón'),
(814, 20, 'San Vicente de la Revancha'),
(815, 20, 'Santa Ana'),
(816, 20, 'Seboruco'),
(817, 20, 'Táriba'),
(818, 20, 'Umuquena'),
(819, 20, 'Ureña'),
(820, 20, '* OTRA'),
(821, 21, 'Agua Caliente'),
(822, 21, 'Agua Santa'),
(823, 21, 'Altamira de Caús'),
(824, 21, 'Araguaney'),
(825, 21, 'Batatal'),
(826, 21, 'Betijoque'),
(827, 21, 'Boconó'),
(828, 21, 'Bolivia'),
(829, 21, 'Buena Vista'),
(830, 21, 'Burbusay'),
(831, 21, 'Cabimbú'),
(832, 21, 'Campo Alegre'),
(833, 21, 'Campo Elías'),
(834, 21, 'Carache'),
(835, 21, 'Carvajal'),
(836, 21, 'Casa de Tabla'),
(837, 21, 'Chejendé'),
(838, 21, 'Chiquinquirá'),
(839, 21, 'Cuicas'),
(840, 21, 'El Alto'),
(841, 21, 'El Baño'),
(842, 21, 'El Carmen'),
(843, 21, 'El Cenizo'),
(844, 21, 'El Dividive'),
(845, 21, 'El Gallo'),
(846, 21, 'El Jagüito'),
(847, 21, 'El Paradero'),
(848, 21, 'El Paraíso'),
(849, 21, 'El Zapatero'),
(850, 21, 'Escuque'),
(851, 21, 'Flor de Patria'),
(852, 21, 'Granados'),
(853, 21, 'Guaramacal'),
(854, 21, 'Isnotú'),
(855, 21, 'Jajó'),
(856, 21, 'Jalisco'),
(857, 21, 'Juan Ignacio Montilla'),
(858, 21, 'Junín'),
(859, 21, 'La Beatriz'),
(860, 21, 'La Ceiba'),
(861, 21, 'La Concepción'),
(862, 21, 'La Cuchilla'),
(863, 21, 'La Mata'),
(864, 21, 'La Mesa de Esnujaque'),
(865, 21, 'La Placita'),
(866, 21, 'La Plazuela'),
(867, 21, 'La Puerta'),
(868, 21, 'La Quebrada'),
(869, 21, 'Las Llanadas'),
(870, 21, 'Las Mesetas'),
(871, 21, 'Las Mesitas'),
(872, 21, 'Las Quebradas'),
(873, 21, 'Las Rurales'),
(874, 21, 'Los Caprichos'),
(875, 21, 'Los Cedros'),
(876, 21, 'Matriz'),
(877, 21, 'Mendoza'),
(878, 21, 'Mercedes Díaz'),
(879, 21, 'Minas'),
(880, 21, 'Mitón'),
(881, 21, 'Monay'),
(882, 21, 'Monte Carmelo'),
(883, 21, 'Mosquey'),
(884, 21, 'Motatán'),
(885, 21, 'Niquitao'),
(886, 21, 'Pampán'),
(887, 21, 'Pampanito'),
(888, 21, 'Sabana de Mendoza'),
(889, 21, 'Sabana Grande'),
(890, 21, 'Sabana Libre'),
(891, 21, 'San Jacinto'),
(892, 21, 'San Lázaro'),
(893, 21, 'San Luis'),
(894, 21, 'San Miguel'),
(895, 21, 'San Rafael'),
(896, 21, 'Santa Ana'),
(897, 21, 'Santa Apolonia'),
(898, 21, 'Santa Isabel'),
(899, 21, 'Santa Rosa'),
(900, 21, 'Santiago'),
(901, 21, 'Torococo'),
(902, 21, 'Tostós'),
(903, 21, 'Tres de Febrero'),
(904, 21, 'Tres Esquinas'),
(905, 21, 'Trujillo'),
(906, 21, 'Tuñame'),
(907, 21, 'Valera'),
(908, 21, 'Valerita'),
(909, 21, 'Valmore Rodríguez'),
(910, 21, 'Vega de Guaramacal'),
(911, 21, 'Zona Rica'),
(912, 21, '* OTRA'),
(913, 22, 'Caraballeda'),
(914, 22, 'Carayaca'),
(915, 22, 'Catia La Mar'),
(916, 22, 'El Junko'),
(917, 22, 'La Guaira'),
(918, 22, 'La Sabana'),
(919, 22, 'Macuto'),
(920, 22, 'Maiquetía'),
(921, 22, 'Naiguatá'),
(922, 22, '* OTRA'),
(923, 23, 'Albarico'),
(924, 23, 'Aroa'),
(925, 23, 'Boraure'),
(926, 23, 'Cambural'),
(927, 23, 'Campo Elías'),
(928, 23, 'Casimiro Vásquez'),
(929, 23, 'Chivacoa'),
(930, 23, 'Cocorote'),
(931, 23, 'Farriar'),
(932, 23, 'Guama'),
(933, 23, 'Independencia'),
(934, 23, 'Marín'),
(935, 23, 'Nirgua'),
(936, 23, 'Sabana de Parra'),
(937, 23, 'Salom'),
(938, 23, 'San Felipe'),
(939, 23, 'San Pablo'),
(940, 23, 'Temerla'),
(941, 23, 'Urachiche'),
(942, 23, 'Yaritagua'),
(943, 23, 'Yumare'),
(944, 23, '* OTRA'),
(945, 24, 'Bachaquero'),
(946, 24, 'Barranquitas'),
(947, 24, 'Bobures'),
(948, 24, 'Cabimas'),
(949, 24, 'Cachirí'),
(950, 24, 'Caja Seca'),
(951, 24, 'Campo Lara'),
(952, 24, 'Carrasquero'),
(953, 24, 'Casigua El Cubo'),
(954, 24, 'Ceuta'),
(955, 24, 'Ciudad  Ojeda'),
(956, 24, 'Ciudad Ojeda'),
(957, 24, 'Cojoro'),
(958, 24, 'Concepción'),
(959, 24, 'Concha'),
(960, 24, 'Cuatro Esquinas'),
(961, 24, 'El Bajo'),
(962, 24, 'El Batey'),
(963, 24, 'El Carmelo'),
(964, 24, 'El Consejo de Ciruma'),
(965, 24, 'El Corozo'),
(966, 24, 'El Cruce'),
(967, 24, 'El Guanábano'),
(968, 24, 'El Guayabo'),
(969, 24, 'El Mecocal'),
(970, 24, 'El Mene'),
(971, 24, 'El Molinete'),
(972, 24, 'El Moralito'),
(973, 24, 'El Silencio'),
(974, 24, 'El Tigre'),
(975, 24, 'El Toro'),
(976, 24, 'El Venado'),
(977, 24, 'Encontrados'),
(978, 24, 'Gibraltar'),
(979, 24, 'Jobo Alto (Kilómetro 25)'),
(980, 24, 'Kilómetro 48 (Santo Domingo)'),
(981, 24, 'La Concepción'),
(982, 24, 'La Ensenada'),
(983, 24, 'La Paz'),
(984, 24, 'La Sierrita'),
(985, 24, 'La Villa del Rosario'),
(986, 24, 'Lagunillas'),
(987, 24, 'Las Parcelas'),
(988, 24, 'Las Piedras'),
(989, 24, 'Los Cortijos'),
(990, 24, 'Los Naranjos'),
(991, 24, 'Los Puertos de Altagracia'),
(992, 24, 'Machiques'),
(993, 24, 'Maracaibo'),
(994, 24, 'Mene Grande'),
(995, 24, 'Palito Blanco'),
(996, 24, 'Palmarejo'),
(997, 24, 'Paraguaipoa'),
(998, 24, 'Picapica'),
(999, 24, 'Potreritos'),
(1000, 24, 'Pueblo Nuevo'),
(1001, 24, 'Pueblo Nuevo El Chivo'),
(1002, 24, 'Punta Gorda'),
(1003, 24, 'Quisiro'),
(1004, 24, 'Río Negro'),
(1005, 24, 'Sabana de la Plata'),
(1006, 24, 'Sabaneta de Palmas'),
(1007, 24, 'San Antonio'),
(1008, 24, 'San Carlos'),
(1009, 24, 'San Carlos del Zulia'),
(1010, 24, 'San Francisco'),
(1011, 24, 'San Ignacio'),
(1012, 24, 'San Isidro'),
(1013, 24, 'San José'),
(1014, 24, 'San Rafael de El Moján'),
(1015, 24, 'San Timoteo'),
(1016, 24, 'Santa Bárbara'),
(1017, 24, 'Santa Cruz de Mara'),
(1018, 24, 'Santa Cruz del Zulia'),
(1019, 24, 'Santa María'),
(1020, 24, 'Santa Rita'),
(1021, 24, 'Sierra Maestra'),
(1022, 24, 'Sinamaica'),
(1023, 24, 'Sur América'),
(1024, 24, 'Tamare'),
(1025, 24, 'Tía Juana'),
(1026, 24, '* OTRA');

-- --------------------------------------------------------

--
-- Table structure for table `estados`
--

CREATE TABLE IF NOT EXISTS `estados` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `estado` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `estados`
--

INSERT INTO `estados` (`id`, `estado`) VALUES
(1, 'Amazonas'),
(2, 'Anzoátegui'),
(3, 'Apure'),
(4, 'Aragua'),
(5, 'Barinas'),
(6, 'Bolívar'),
(7, 'Carabobo'),
(8, 'Cojedes'),
(9, 'Delta Amacuro'),
(10, 'Distrito Capital'),
(11, 'Falcón'),
(12, 'Guárico'),
(13, 'Lara'),
(14, 'Mérida'),
(15, 'Miranda'),
(16, 'Monagas'),
(17, 'Nueva Esparta'),
(18, 'Portuguesa'),
(19, 'Sucre'),
(20, 'Táchira'),
(21, 'Trujillo'),
(22, 'Vargas'),
(23, 'Yaracuy'),
(24, 'Zulia');