cities_city

gistfile1.txt

INSERT INTO `cities_city` (`id`, `name`, `code`, `state_id`) VALUES
(3, 'CAMILO PONCE ENRIQUEZ', '20115', 29),
(4, 'CHORDELEG', '20111', 29),
(5, 'CUENCA', '20101', 29),
(6, 'EL PAN', '20112', 29),
(7, 'GIRON', '20102', 29),
(8, 'GUACHAPALA', '20114', 29),
(9, 'GUALACEO', '20103', 29),
(10, 'NABON', '20104', 29),
(11, 'OÑA', '20110', 29),
(12, 'PAUTE', '20105', 29),
(13, 'PUCARA', '20106', 29),
(14, 'SAN FERNANDO', '20107', 29),
(15, 'SANTA ISABEL (CHAGUARURCO)', '20108', 29),
(16, 'SEVILLA DE ORO', '20113', 29),
(17, 'SIGSIG', '20109', 29),
(18, 'CALUMA', '20206', 30),
(19, 'CHILLANES', '20202', 30),
(20, 'CHIMBO', '20203', 30),
(21, 'ECHEANDIA', '20204', 30),
(22, 'GUARANDA', '20201', 30),
(23, 'LAS NAVES', '20207', 30),
(24, 'SAN MIGUEL', '20205', 30),
(25, 'AZOGUES', '20301', 31),
(26, 'BIBLIAN', '20302', 31),
(27, 'CAÑAR', '20303', 31),
(28, 'DELEG', '20306', 31),
(29, 'EL TAMBO', '20305', 31),
(30, 'LA TRONCAL', '20304', 31),
(31, 'SUSCAL', '20307', 31),
(32, 'BOLIVAR', '20402', 32),
(33, 'ESPEJO', '20403', 32),
(34, 'MIRA (CHONTAHUASI)', '20404', 32),
(35, 'MONTUFAR', '20405', 32),
(36, 'SAN PEDRO DE HUACA', '20406', 32),
(37, 'TULCAN', '20401', 32),
(38, 'ALAUSI', '20602', 33),
(39, 'CHAMBO', '20604', 33),
(40, 'CHUNCHI', '20605', 33),
(41, 'COLTA', '20603', 33),
(42, 'CUMANDA', '20610', 33),
(43, 'GUAMOTE', '20606', 33),
(44, 'GUANO', '20607', 33),
(45, 'PALLATANGA', '20608', 33),
(46, 'PENIPE', '20609', 33),
(47, 'RIOBAMBA', '20601', 33),
(48, 'LA MANA', '20501', 34),
(49, 'LATACUNGA', '20520', 34),
(50, 'PANGUA', '20503', 34),
(51, 'PUJILI', '20504', 34),
(52, 'SALCEDO', '20505', 34),
(53, 'SAQUISILI', '20506', 34),
(54, 'SIGCHOS', '20507', 34),
(55, 'ARENILLAS', '10702', 35),
(56, 'ATAHUALPA', '10703', 35),
(57, 'BALSAS', '10704', 35),
(58, 'CHILLA', '10705', 35),
(59, 'EL GUABO', '10706', 35),
(60, 'HUAQUILLAS', '10707', 35),
(61, 'LAS LAJAS', '10714', 35),
(62, 'MACHALA', '10701', 35),
(63, 'MARCABELI', '10708', 35),
(64, 'PASAJE', '10709', 35),
(65, 'PIÑAS', '10710', 35),
(66, 'PORTOVELO', '10711', 35),
(67, 'SANTA ROSA', '10712', 35),
(68, 'ZARUMA', '10713', 35),
(69, 'ATACAMES', '10806', 36),
(70, 'ELOY ALFARO', '10802', 36),
(71, 'ESMERALDAS', '10801', 36),
(72, 'MUISNE', '10803', 36),
(73, 'QUININDE', '10804', 36),
(74, 'RIOVERDE', '10807', 36),
(75, 'SAN LORENZO', '10805', 36),
(76, 'ISABELA', '42002', 37),
(77, 'SAN CRISTOBAL', '42001', 37),
(78, 'SANTA CRUZ', '42003', 37),
(79, 'ALFREDO BAQUERIZO MORENO', '10902', 38),
(80, 'BALAO', '10903', 38),
(81, 'BALZAR', '10904', 38),
(82, 'COLIMES', '10905', 38),
(83, 'CORONEL MARCELINO MARIDUEÑA', '10923', 38),
(84, 'DAULE', '10906', 38),
(85, 'DURAN', '10907', 38),
(86, 'EL EMPALME', '10908', 38),
(87, 'EL TRIUNFO', '10909', 38),
(88, 'GENERAL ANTONIO ELIZALDE (BUCAY)', '10927', 38),
(89, 'GUAYAQUIL', '10901', 38),
(90, 'ISIDRO AYORA', '10928', 38),
(91, 'LA LIBERTAD', '10926', 38),
(92, 'LOMAS DE SARGENTILLO', '10924', 38),
(93, 'MILAGRO', '10910', 38),
(94, 'NARANJAL', '10911', 38),
(95, 'NARANJITO', '10912', 38),
(96, 'NOBOL (VICENTE PIEDRAHITA)', '10925', 38),
(97, 'PALESTINA', '10913', 38),
(98, 'PLAYAS (GENERAL VILLAMIL)', '10921', 38),
(99, 'SALINAS', '10915', 38),
(100, 'SAMBORONDON', '10916', 38),
(101, 'SAN JACINTO DE YAGUACHI', '10920', 38),
(102, 'SANTA ELENA', '10917', 38),
(103, 'SANTA LUCIA', '10918', 38),
(104, 'SIMON BOLIVAR', '10922', 38),
(105, 'URBINA JADO', '10919', 38),
(106, 'ANTONIO ANTE', '21002', 39),
(107, 'COTACACHI', '21003', 39),
(108, 'EL LIMONAL', '21001', 39),
(109, 'IBARRA', '21001', 39),
(110, 'OTAVALO', '21004', 39),
(111, 'PIMAMPIRO', '21005', 39),
(112, 'SAN MIGUEL DE URCUQUI', '21006', 39),
(113, 'CALVAS', '21102', 40),
(114, 'CATAMAYO', '21103', 40),
(115, 'CELICA', '21104', 40),
(116, 'CHAGUARPAMBA', '21105', 40),
(117, 'ESPINDOLA', '21106', 40),
(118, 'GONZANAMA', '21107', 40),
(119, 'LOJA', '21101', 40),
(120, 'MACARA', '21108', 40),
(121, 'OLMEDO', '21116', 40),
(122, 'PALTAS', '21109', 40),
(123, 'PINDAL', '21114', 40),
(124, 'PUYANGO', '21110', 40),
(125, 'QUILANGA', '21115', 40),
(126, 'SARAGURO', '21111', 40),
(127, 'SOZORANGA', '21112', 40),
(128, 'BABA', '11202', 41),
(129, 'BABAHOYO', '11201', 41),
(130, 'BUENA FE', '11210', 41),
(131, 'MOCACHE', '11212', 41),
(132, 'MONTALVO', '11203', 41),
(133, 'PALENQUE', '11209', 41),
(134, 'PUEBLO VIEJO', '11204', 41),
(135, 'QUEVEDO', '11205', 41),
(136, 'URDANETE', '11206', 41),
(137, 'VALENCIA', '11211', 41),
(138, 'VENTANAS', '11207', 41),
(139, 'VINCES', '11208', 41),
(140, '24 DE MAYO', '11316', 42),
(141, 'BOLIVAR', '11302', 42),
(142, 'CHONE', '11303', 42),
(143, 'EL CARMEN', '11304', 42),
(144, 'FLAVIO ALFARO', '11305', 42),
(145, 'JAMA', '11320', 42),
(146, 'JARAMIJO', '11321', 42),
(147, 'JIPIJAPA', '11306', 42),
(148, 'JUNIN', '11307', 42),
(149, 'MANTA', '11308', 42),
(150, 'MONTECRISTI', '11309', 42),
(151, 'OLMEDO', '11318', 42),
(152, 'PAJAN', '11310', 42),
(153, 'PEDERNALES', '11317', 42),
(154, 'PICHINCHA', '11311', 42),
(155, 'PORTOVIEJO', '11301', 42),
(156, 'PUERTO LOPEZ', '11319', 42),
(157, 'ROCAFUERTE', '11312', 42),
(158, 'SAN VICENTE', '11322', 42),
(159, 'SANTA ANA', '11313', 42),
(160, 'SUCRE', '11314', 42),
(161, 'TOSAGUA', '11315', 42),
(162, 'GUALAQUIZA', '31402', 43),
(163, 'HUAMBOYA', '31407', 43),
(164, 'LIMON - INDANZA', '31403', 43),
(165, 'LOGROÑO', '31410', 43),
(166, 'MORONA', '31401', 43),
(167, 'PABLO VI', '31411', 43),
(168, 'PALORA', '31404', 43),
(169, 'SAN JUAN DON BOSCO', '31408', 43),
(170, 'SANTIAGO', '31405', 43),
(171, 'SUCUA', '31406', 43),
(172, 'TAISHA', '31409', 43),
(173, 'TIWINTZA', '31412', 43),
(174, 'ARCHIDONA', '31501', 44),
(175, 'CARLOS JULIO AROSEMENA T.', '31502', 44),
(176, 'EL CHACO', '31503', 44),
(177, 'QUIJOS', '31504', 44),
(178, 'TENA', '31505', 44),
(179, 'AGUARICO', '32202', 45),
(180, 'LA JOYA DE LOS SACHAS', '32203', 45),
(181, 'LORETO', '32204', 45),
(182, 'ORELLANA', '32201', 45),
(183, 'ARAJUNO', '31604', 46),
(184, 'MERA', '31602', 46),
(185, 'PASTAZA', '31601', 46),
(186, 'SANTA CLARA', '31603', 46),
(187, 'CAYAMBE', '21702', 47),
(188, 'MEJIA', '21703', 47),
(189, 'PEDRO MONCAYO', '21704', 47),
(190, 'PEDRO VICENTE MALDONADO', '21708', 47),
(191, 'PUERTO QUITO', '21709', 47),
(192, 'QUITO', '21701', 47),
(193, 'RUMIÑAHUI', '21705', 47),
(194, 'SAN MIGUEL DE LOS BANCOS', '21707', 47),
(195, 'SANTO DOMINGO DE LOS COLORADOS', '21706', 47),
(196, 'SANTA ELENA', '12401', 48),
(197, 'LA LIBERTAD', '12402', 48),
(198, 'SALINAS', '12403', 48),
(199, 'SANTO DOMINGO', '22301', 49),
(200, 'CASCALES', '32106', 50),
(201, 'CUYABENO', '32107', 50),
(202, 'GONZALO PIZARRO', '32102', 50),
(203, 'LAGO AGRIO', '32101', 50),
(204, 'PUTUMAYO', '32103', 50),
(205, 'SHUSHUFINDI', '32104', 50),
(206, 'SUCUMBIOS', '32105', 50),
(207, 'AMBATO', '21801', 51),
(208, 'BAÑOS DE AGUA SANTA', '21802', 51),
(209, 'QUERO/YAYULIHUI', '21810', 51),
(210, 'CEVALLOS', '21803', 51),
(211, 'MOCHA', '21804', 51),
(212, 'PATATE', '21805', 51),
(213, 'QUERO', '21806', 51),
(214, 'SAN PEDRO DE PELILEO', '21807', 51),
(215, 'SANTIAGO DE PILLARO', '21808', 51),
(216, 'TISALEO', '21809', 51),
(217, 'CENTINELA DEL CONDOR', '31907', 52),
(218, 'CHINCHIPE', '31902', 52),
(219, 'EL PANGUI', '31906', 52),
(220, 'NANGARITZA', '31903', 52),
(221, 'PALANDA', '31908', 52),
(222, 'PAQUISHA', '31909', 52),
(223, 'YACUAMBI', '31904', 52),
(224, 'YANZATZA', '31905', 52),
(225, 'ZAMORA', '31901', 52);