3 create-table-comunas-sii.sql

/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXISTS `chile`.`comunas` (
 `comuna_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `region_numero` int(11) unsigned NOT NULL,
 `comuna_numero` int(11) unsigned NOT NULL,
 `comuna_nombre` text NOT NULL,
 PRIMARY KEY (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Regiones de Chile';

INSERT INTO `chile`.`comunas` (`comuna_id`, `region_numero`, `comuna_numero`, `comuna_nombre`) VALUES
  (1,5,5406,'ALGARROBO'),
  (2,13,14605,'ALHUÉ'),
  (3,8,8414,'ALTO BIOBÍO'),
  (4,3,3304,'ALTO DEL CARMEN'),
  (5,1,1211,'ALTO HOSPICIO'),
  (6,10,10406,'ANCUD'),
  (7,4,4104,'ANDACOLLO'),
  (8,9,9101,'ANGOL'),
  (9,2,2201,'ANTOFAGASTA'),
  (10,8,8413,'ANTUCO'),
  (11,8,8301,'ARAUCO'),
  (12,15,1101,'ARICA'),
  (13,11,11101,'AYSÉN'),
  (14,13,16403,'BUIN'),
  (15,16,8113,'BULNES'),
  (16,5,5203,'CABILDO'),
  (17,12,12401,'CABO DE HORNOS'),
  (18,8,8410,'CABRERO'),
  (19,2,2301,'CALAMA'),
  (20,10,10309,'CALBUCO'),
  (21,3,3202,'CALDERA'),
  (22,13,16402,'CALERA DE TANGO'),
  (23,5,5702,'CALLE LARGA'),
  (24,15,1106,'CAMARONES'),
  (25,1,1208,'CAMIÑA'),
  (26,4,4304,'CANELA'),
  (27,9,9209,'CARAHUE'),
  (28,5,5403,'CARTAGENA'),
  (29,5,5305,'CASABLANCA'),
  (30,10,10401,'CASTRO'),
  (31,5,5603,'CATEMU'),
  (32,7,7401,'CAUQUENES'),
  (33,8,8305,'CAÑETE'),
  (34,13,14166,'CERRILLOS'),
  (35,13,14156,'CERRO NAVIA'),
  (36,10,10501,'CHAITÉN'),
  (37,7,7403,'CHANCO'),
  (38,3,3101,'CHAÑARAL'),
  (39,8,8211,'CHIGUAYANTE'),
  (40,11,11201,'CHILE CHICO'),
  (41,16,8101,'CHILLÁN'),
  (42,16,8121,'CHILLÁN VIEJO'),
  (43,6,6202,'CHIMBARONGO'),
  (44,9,9221,'CHOLCHOL'),
  (45,10,10402,'CHONCHI'),
  (46,6,6209,'CHÉPICA'),
  (47,11,11102,'CISNES'),
  (48,16,8107,'COBQUECURA'),
  (49,10,10302,'COCHAMÓ'),
  (50,11,11301,'COCHRANE'),
  (51,6,6107,'CODEGUA'),
  (52,16,8120,'COELEMU'),
  (53,16,8103,'COIHUECO'),
  (54,6,6116,'COINCO'),
  (55,7,7303,'COLBÚN'),
  (56,1,1210,'COLCHANE'),
  (57,13,14201,'COLINA'),
  (58,9,9105,'COLLIPULLI'),
  (59,6,6106,'COLTAUCO'),
  (60,4,4205,'COMBARBALÁ'),
  (61,8,8201,'CONCEPCIÓN'),
  (62,13,14127,'CONCHALÍ'),
  (63,5,5309,'CONCÓN'),
  (64,7,7208,'CONSTITUCIÓN'),
  (65,8,8306,'CONTULMO'),
  (66,3,3201,'COPIAPÓ'),
  (67,4,4103,'COQUIMBO'),
  (68,8,8207,'CORONEL'),
  (69,14,10106,'CORRAL'),
  (70,11,11401,'COYHAIQUE'),
  (71,9,9204,'CUNCO'),
  (72,9,9110,'CURACAUTÍN'),
  (73,13,14603,'CURACAVÍ'),
  (74,10,10410,'CURACO DE VÉLEZ'),
  (75,8,8302,'CURANILAHUE'),
  (76,9,9218,'CURARREHUE'),
  (77,7,7207,'CUREPTO'),
  (78,7,7101,'CURICÓ'),
  (79,10,10408,'DALCAHUE'),
  (80,3,3102,'DIEGO DE ALMAGRO'),
  (81,6,6105,'DOÑIHUE'),
  (82,13,16165,'EL BOSQUE'),
  (83,16,8118,'EL CARMEN'),
  (84,13,14503,'EL MONTE'),
  (85,5,5405,'EL QUISCO'),
  (86,5,5404,'EL TABO'),
  (87,7,7209,'EMPEDRADO'),
  (88,9,9106,'ERCILLA'),
  (89,13,14157,'ESTACIÓN CENTRAL'),
  (90,8,8204,'FLORIDA'),
  (91,9,9203,'FREIRE'),
  (92,3,3302,'FREIRINA'),
  (93,10,10304,'FRESIA'),
  (94,10,10305,'FRUTILLAR'),
  (95,10,10503,'FUTALEUFÚ'),
  (96,14,10105,'FUTRONO'),
  (97,9,9207,'GALVARINO'),
  (98,15,1302,'GENERAL LAGOS'),
  (99,9,9212,'GORBEA'),
  (100,6,6103,'GRANEROS'),
  (101,11,11104,'GUAITECAS'),
  (102,5,5503,'HIJUELAS'),
  (103,10,10502,'HUALAIHUÉ'),
  (104,7,7107,'HUALAÑÉ'),
  (105,8,8212,'HUALPÉN'),
  (106,8,8203,'HUALQUI'),
  (107,1,1206,'HUARA'),
  (108,3,3303,'HUASCO'),
  (109,13,14158,'HUECHURABA'),
  (110,4,4301,'ILLAPEL'),
  (111,13,13167,'INDEPENDENCIA'),
  (112,1,1201,'IQUIQUE'),
  (113,13,14502,'ISLA DE MAIPO'),
  (114,5,5101,'ISLA DE PASCUA'),
  (115,5,5308,'JUAN FERNÁNDEZ'),
  (116,5,5504,'LA CALERA'),
  (117,13,16110,'LA CISTERNA'),
  (118,5,5505,'LA CRUZ'),
  (119,6,6304,'LA ESTRELLA'),
  (120,13,15128,'LA FLORIDA'),
  (121,13,16131,'LA GRANJA'),
  (122,4,4102,'LA HIGUERA'),
  (123,5,5201,'LA LIGUA'),
  (124,13,16154,'LA PINTANA'),
  (125,13,15132,'LA REINA'),
  (126,4,4101,'LA SERENA'),
  (127,14,10109,'LA UNIÓN'),
  (128,14,10112,'LAGO RANCO'),
  (129,11,11402,'LAGO VERDE'),
  (130,12,12206,'LAGUNA BLANCA'),
  (131,8,8403,'LAJA'),
  (132,13,14202,'LAMPA'),
  (133,14,10103,'LANCO'),
  (134,6,6109,'LAS CABRAS'),
  (135,13,15108,'LAS CONDES'),
  (136,9,9205,'LAUTARO'),
  (137,8,8303,'LEBU'),
  (138,7,7105,'LICANTÉN'),
  (139,5,5506,'LIMACHE'),
  (140,7,7301,'LINARES'),
  (141,6,6303,'LITUECHE'),
  (142,10,10306,'LLANQUIHUE'),
  (143,5,5606,'LLAY-LLAY'),
  (144,13,15161,'LO BARNECHEA'),
  (145,13,16164,'LO ESPEJO'),
  (146,13,14155,'LO PRADO'),
  (147,6,6206,'LOLOL'),
  (148,9,9214,'LONCOCHE'),
  (149,7,7304,'LONGAVÍ'),
  (150,9,9111,'LONQUIMAY'),
  (151,8,8304,'LOS ALAMOS'),
  (152,5,5701,'LOS ANDES'),
  (153,8,8401,'LOS ANGELES'),
  (154,14,10104,'LOS LAGOS'),
  (155,10,10308,'LOS MUERMOS'),
  (156,9,9103,'LOS SAUCES'),
  (157,4,4303,'LOS VILOS'),
  (158,8,8208,'LOTA'),
  (159,9,9108,'LUMACO'),
  (160,6,6102,'MACHALÍ'),
  (161,13,15151,'MACUL'),
  (162,13,14109,'MAIPÚ'),
  (163,6,6115,'MALLOA'),
  (164,6,6305,'MARCHIGÜE'),
  (165,14,10102,'MARIQUINA'),
  (166,2,2103,'MARÍA ELENA'),
  (167,13,14602,'MARÍA PINTO'),
  (168,7,7206,'MAULE'),
  (169,10,10307,'MAULLÍN'),
  (170,2,2203,'MEJILLONES'),
  (171,9,9217,'MELIPEUCO'),
  (172,13,14601,'MELIPILLA'),
  (173,7,7108,'MOLINA'),
  (174,4,4203,'MONTE PATRIA'),
  (175,8,8407,'MULCHÉN'),
  (176,14,10107,'MÁFIL'),
  (177,8,8405,'NACIMIENTO'),
  (178,6,6203,'NANCAGUA'),
  (179,12,12101,'NATALES'),
  (180,6,6302,'NAVIDAD'),
  (181,8,8406,'NEGRETE'),
  (182,16,8105,'NINHUE'),
  (183,5,5502,'NOGALES'),
  (184,9,9208,'NUEVA IMPERIAL'),
  (185,11,11302,O\'HIGGINS'),
  (186,6,6114,'OLIVAR'),
  (187,2,2302,'OLLAGÜE'),
  (188,5,5507,'OLMUÉ'),
  (189,10,10201,'OSORNO'),
  (190,4,4201,'OVALLE'),
  (191,13,14505,'PADRE HURTADO'),
  (192,9,9220,'PADRE LAS CASAS'),
  (193,4,4106,'PAIHUANO'),
  (194,14,10110,'PAILLACO'),
  (195,13,16404,'PAINE'),
  (196,10,10504,'PALENA'),
  (197,6,6207,'PALMILLA'),
  (198,14,10108,'PANGUIPULLI'),
  (199,5,5602,'PANQUEHUE'),
  (200,5,5205,'PAPUDO'),
  (201,6,6306,'PAREDONES'),
  (202,7,7305,'PARRAL'),
  (203,13,16162,'PEDRO AGUIRRE CERDA'),
  (204,7,7203,'PELARCO'),
  (205,7,7402,'PELLUHUE'),
  (206,16,8117,'PEMUCO'),
  (207,7,7205,'PENCAHUE'),
  (208,8,8202,'PENCO'),
  (209,6,6208,'PERALILLO'),
  (210,9,9206,'PERQUENCO'),
  (211,5,5202,'PETORCA'),
  (212,6,6108,'PEUMO'),
  (213,13,14504,'PEÑAFLOR'),
  (214,13,15152,'PEÑALOLÉN'),
  (215,1,1203,'PICA'),
  (216,6,6111,'PICHIDEGUA'),
  (217,6,6301,'PICHILEMU'),
  (218,16,8102,'PINTO'),
  (219,13,16302,'PIRQUE'),
  (220,9,9211,'PITRUFQUÉN'),
  (221,6,6204,'PLACILLA'),
  (222,16,8106,'PORTEZUELO'),
  (223,12,12301,'PORVENIR'),
  (224,1,1204,'POZO ALMONTE'),
  (225,12,12302,'PRIMAVERA'),
  (226,13,15103,'PROVIDENCIA'),
  (227,5,5307,'PUCHUNCAVÍ'),
  (228,9,9216,'PUCÓN'),
  (229,13,14111,'PUDAHUEL'),
  (230,13,16301,'PUENTE ALTO'),
  (231,10,10301,'PUERTO MONTT'),
  (232,10,10203,'PUERTO OCTAY'),
  (233,10,10303,'PUERTO VARAS'),
  (234,6,6214,'PUMANQUE'),
  (235,4,4204,'PUNITAQUI'),
  (236,12,12205,'PUNTA ARENAS'),
  (237,10,10405,'PUQUELDÓN'),
  (238,10,10206,'PURRANQUE'),
  (239,9,9102,'PURÉN'),
  (240,5,5604,'PUTAENDO'),
  (241,15,1301,'PUTRE'),
  (242,10,10204,'PUYEHUE'),
  (243,10,10403,'QUEILÉN'),
  (244,10,10404,'QUELLÓN'),
  (245,10,10407,'QUEMCHI'),
  (246,8,8408,'QUILACO'),
  (247,13,14114,'QUILICURA'),
  (248,8,8404,'QUILLECO'),
  (249,5,5501,'QUILLOTA'),
  (250,16,8115,'QUILLÓN'),
  (251,5,5304,'QUILPUÉ'),
  (252,10,10415,'QUINCHAO'),
  (253,6,6117,'QUINTA DE TILCOCO'),
  (254,13,14107,'QUINTA NORMAL'),
  (255,5,5306,'QUINTERO'),
  (256,16,8104,'QUIRIHUE'),
  (257,6,6101,'RANCAGUA'),
  (258,7,7104,'RAUCO'),
  (259,13,13159,'RECOLETA'),
  (260,9,9104,'RENAICO'),
  (261,13,14113,'RENCA'),
  (262,6,6112,'RENGO'),
  (263,6,6113,'REQUÍNOA'),
  (264,7,7306,'RETIRO'),
  (265,5,5704,'RINCONADA'),
  (266,7,7103,'ROMERAL'),
  (267,16,8119,'RÁNQUIL'),
  (268,14,10111,'RÍO BUENO'),
  (269,7,7204,'RÍO CLARO'),
  (270,4,4206,'RÍO HURTADO'),
  (271,11,11203,'RÍO IBÁÑEZ'),
  (272,10,10205,'RÍO NEGRO'),
  (273,12,12202,'RÍO VERDE'),
  (274,9,9210,'SAAVEDRA'),
  (275,7,7109,'SAGRADA FAMILIA'),
  (276,4,4302,'SALAMANCA'),
  (277,5,5401,'SAN ANTONIO'),
  (278,13,16401,'SAN BERNARDO'),
  (279,16,8109,'SAN CARLOS'),
  (280,7,7202,'SAN CLEMENTE'),
  (281,5,5703,'SAN ESTEBAN'),
  (282,16,8111,'SAN FABIÁN'),
  (283,5,5601,'SAN FELIPE'),
  (284,6,6201,'SAN FERNANDO'),
  (285,6,6104,'SAN FRANCISCO DE MOSTAZAL'),
  (286,12,12204,'SAN GREGORIO'),
  (287,16,8114,'SAN IGNACIO'),
  (288,7,7310,'SAN JAVIER'),
  (289,13,16163,'SAN JOAQUÍN'),
  (290,13,16303,'SAN JOSÉ DE MAIPO'),
  (291,10,10207,'SAN JUAN DE LA COSTA'),
  (292,13,16106,'SAN MIGUEL'),
  (293,16,8112,'SAN NICOLÁS'),
  (294,10,10202,'SAN PABLO'),
  (295,13,14604,'SAN PEDRO'),
  (296,2,2303,'SAN PEDRO DE ATACAMA'),
  (297,8,8210,'SAN PEDRO DE LA PAZ'),
  (298,7,7210,'SAN RAFAEL'),
  (299,13,16153,'SAN RAMÓN'),
  (300,8,8411,'SAN ROSENDO'),
  (301,6,6110,'SAN VICENTE'),
  (302,8,8402,'SANTA BÁRBARA'),
  (303,6,6205,'SANTA CRUZ'),
  (304,8,8209,'SANTA JUANA'),
  (305,5,5605,'SANTA MARÍA'),
  (306,13,13101,'SANTIAGO'),
  (307,13,13134,'SANTIAGO OESTE'),
  (308,13,13135,'SANTIAGO SUR'),
  (309,5,5402,'SANTO DOMINGO'),
  (310,2,2206,'SIERRA GORDA'),
  (311,13,14501,'TALAGANTE'),
  (312,7,7201,'TALCA'),
  (313,8,8206,'TALCAHUANO'),
  (314,2,2202,'TALTAL'),
  (315,9,9201,'TEMUCO'),
  (316,7,7102,'TENO'),
  (317,9,9219,'TEODORO SCHMIDT'),
  (318,3,3203,'TIERRA AMARILLA'),
  (319,13,14203,'TIL-TIL'),
  (320,12,12304,'TIMAUKEL'),
  (321,8,8307,'TIRÚA'),
  (322,2,2101,'TOCOPILLA'),
  (323,9,9213,'TOLTÉN'),
  (324,8,8205,'TOMÉ'),
  (325,12,12103,'TORRES DEL PAINE'),
  (326,11,11303,'TORTEL'),
  (327,9,9107,'TRAIGUÉN'),
  (328,16,8108,'TREHUACO'),
  (329,8,8412,'TUCAPEL'),
  (330,14,10101,'VALDIVIA'),
  (331,3,3301,'VALLENAR'),
  (332,5,5301,'VALPARAISO'),
  (333,7,7106,'VICHUQUÉN'),
  (334,9,9109,'VICTORIA'),
  (335,4,4105,'VICUÑA'),
  (336,9,9202,'VILCÚN'),
  (337,7,7309,'VILLA ALEGRE'),
  (338,5,5303,'VILLA ALEMANA'),
  (339,9,9215,'VILLARRICA'),
  (340,13,15160,'VITACURA'),
  (341,5,5302,'VIÑA DEL MAR'),
  (342,7,7302,'YERBAS BUENAS'),
  (343,8,8409,'YUMBEL'),
  (344,16,8116,'YUNGAY'),
  (345,5,5204,'ZAPALLAR'),
  (346,16,8110,'ÑIQUÉN'),
  (347,13,15105,'ÑUÑOA');