chilean-municipalities.sqlite

begin transaction;

create table regions (id integer primary key, name text unique not null);

insert into regions (name) values ('Tarapacá'); -- 1
insert into regions (name) values ('Antofagasta'); -- 2
insert into regions (name) values ('Atacama'); -- 3
insert into regions (name) values ('Coquimbo'); -- 4
insert into regions (name) values ('Valparaíso'); -- 5
insert into regions (name) values ('Libertador General Bernardo O''Higgins'); -- 6
insert into regions (name) values ('Maule'); -- 7
insert into regions (name) values ('Bío Bío'); -- 8
insert into regions (name) values ('Araucanía'); -- 9
insert into regions (name) values ('Los Lagos'); -- 10
insert into regions (name) values ('Aysén del General Carlos Ibáñez del Campo'); -- 11
insert into regions (name) values ('Magallanes y de la Antártica Chilena'); -- 12
insert into regions (name) values ('Metropolitana'); -- 13
insert into regions (name) values ('Los Ríos'); -- 14
insert into regions (name) values ('Arica y Parinacota'); -- 15

create table municipalities (
	id integer primary key,
	name unique not null,
	region integer,
	foreign key(region) references regions(id));

insert into municipalities (name, region) values ('Algarrobo', 5);
insert into municipalities (name, region) values ('Alhué', 13);
insert into municipalities (name, region) values ('Alto Biobío', 8);
insert into municipalities (name, region) values ('Alto Hospicio', 2);
insert into municipalities (name, region) values ('Alto del Carmen', 3);
insert into municipalities (name, region) values ('Ancud', 10);
insert into municipalities (name, region) values ('Andacollo', 4);
insert into municipalities (name, region) values ('Angol', 9);
insert into municipalities (name, region) values ('Antofagasta', 2);
insert into municipalities (name, region) values ('Antuco', 8);
insert into municipalities (name, region) values ('Antártica', 12);
insert into municipalities (name, region) values ('Arauco', 8);
insert into municipalities (name, region) values ('Arica', 15);
insert into municipalities (name, region) values ('Aysén', 11);
insert into municipalities (name, region) values ('Buin', 13);
insert into municipalities (name, region) values ('Bulnes', 8);
insert into municipalities (name, region) values ('Cabildo', 5);
insert into municipalities (name, region) values ('Cabo de Hornos', 12);
insert into municipalities (name, region) values ('Cabrero', 8);
insert into municipalities (name, region) values ('Calama', 2);
insert into municipalities (name, region) values ('Calbuco', 10);
insert into municipalities (name, region) values ('Caldera', 3);
insert into municipalities (name, region) values ('Calera de Tango', 13);
insert into municipalities (name, region) values ('Calle Larga', 5);
insert into municipalities (name, region) values ('Camarones', 15);
insert into municipalities (name, region) values ('Camiña', 1);
insert into municipalities (name, region) values ('Canela', 4);
insert into municipalities (name, region) values ('Carahue', 9);
insert into municipalities (name, region) values ('Cartagena', 5);
insert into municipalities (name, region) values ('Casablanca', 5);
insert into municipalities (name, region) values ('Castro', 10);
insert into municipalities (name, region) values ('Catemu', 5);
insert into municipalities (name, region) values ('Cauquenes', 7);
insert into municipalities (name, region) values ('Cañete', 8);
insert into municipalities (name, region) values ('Cerrillos', 13);
insert into municipalities (name, region) values ('Cerro Navia', 13);
insert into municipalities (name, region) values ('Chaitén', 10);
insert into municipalities (name, region) values ('Chanco', 7);
insert into municipalities (name, region) values ('Chañaral', 3);
insert into municipalities (name, region) values ('Chiguayante', 8);
insert into municipalities (name, region) values ('Chile Chico', 11);
insert into municipalities (name, region) values ('Chillán', 8);
insert into municipalities (name, region) values ('Chillán Viejo', 8);
insert into municipalities (name, region) values ('Chimbarongo', 6);
insert into municipalities (name, region) values ('Cholchol', 9);
insert into municipalities (name, region) values ('Chonchi', 10);
insert into municipalities (name, region) values ('Chépica', 6);
insert into municipalities (name, region) values ('Cisnes', 11);
insert into municipalities (name, region) values ('Cobquecura', 8);
insert into municipalities (name, region) values ('Cochamó', 10);
insert into municipalities (name, region) values ('Cochrane', 11);
insert into municipalities (name, region) values ('Codegua', 6);
insert into municipalities (name, region) values ('Coelemu', 8);
insert into municipalities (name, region) values ('Coihueco', 8);
insert into municipalities (name, region) values ('Coinco', 6);
insert into municipalities (name, region) values ('Colbún', 7);
insert into municipalities (name, region) values ('Colchane', 1);
insert into municipalities (name, region) values ('Colina', 13);
insert into municipalities (name, region) values ('Collipulli', 9);
insert into municipalities (name, region) values ('Coltauco', 6);
insert into municipalities (name, region) values ('Combarbalá', 4);
insert into municipalities (name, region) values ('Concepción', 8);
insert into municipalities (name, region) values ('Conchalí', 13);
insert into municipalities (name, region) values ('Concón', 5);
insert into municipalities (name, region) values ('Constitución', 7);
insert into municipalities (name, region) values ('Contulmo', 8);
insert into municipalities (name, region) values ('Copiapó', 3);
insert into municipalities (name, region) values ('Coquimbo', 4);
insert into municipalities (name, region) values ('Coronel', 8);
insert into municipalities (name, region) values ('Corral', 14);
insert into municipalities (name, region) values ('Coyhaique', 11);
insert into municipalities (name, region) values ('Cunco', 9);
insert into municipalities (name, region) values ('Curacautín', 9);
insert into municipalities (name, region) values ('Curacaví', 13);
insert into municipalities (name, region) values ('Curaco de Vélez', 10);
insert into municipalities (name, region) values ('Curanilahue', 8);
insert into municipalities (name, region) values ('Curarrehue', 9);
insert into municipalities (name, region) values ('Curepto', 7);
insert into municipalities (name, region) values ('Curicó', 7);
insert into municipalities (name, region) values ('Dalcahue', 10);
insert into municipalities (name, region) values ('Diego de Almagro', 3);
insert into municipalities (name, region) values ('Doñihue', 6);
insert into municipalities (name, region) values ('El Bosque', 13);
insert into municipalities (name, region) values ('El Carmen', 3);
insert into municipalities (name, region) values ('El Monte', 13);
insert into municipalities (name, region) values ('El Quisco', 5);
insert into municipalities (name, region) values ('El Tabo', 5);
insert into municipalities (name, region) values ('Empedrado', 7);
insert into municipalities (name, region) values ('Ercilla', 9);
insert into municipalities (name, region) values ('Estación Central', 13);
insert into municipalities (name, region) values ('Florida', 8);
insert into municipalities (name, region) values ('Freire', 9);
insert into municipalities (name, region) values ('Freirina', 3);
insert into municipalities (name, region) values ('Fresia', 10);
insert into municipalities (name, region) values ('Frutillar', 10);
insert into municipalities (name, region) values ('Futaleufú', 10);
insert into municipalities (name, region) values ('Futrono', 14);
insert into municipalities (name, region) values ('Galvarino', 9);
insert into municipalities (name, region) values ('General Lagos', 15);
insert into municipalities (name, region) values ('Gorbea', 9);
insert into municipalities (name, region) values ('Graneros', 6);
insert into municipalities (name, region) values ('Guaitecas', 11);
insert into municipalities (name, region) values ('Hijuelas', 5);
insert into municipalities (name, region) values ('Hualaihué', 10);
insert into municipalities (name, region) values ('Hualañé', 7);
insert into municipalities (name, region) values ('Hualpén', 8);
insert into municipalities (name, region) values ('Hualqui', 8);
insert into municipalities (name, region) values ('Huara', 1);
insert into municipalities (name, region) values ('Huasco', 3);
insert into municipalities (name, region) values ('Huechuraba', 13);
insert into municipalities (name, region) values ('Illapel', 4);
insert into municipalities (name, region) values ('Independencia', 13);
insert into municipalities (name, region) values ('Iquique', 1);
insert into municipalities (name, region) values ('Isla de Maipo', 13);
insert into municipalities (name, region) values ('Isla de Pascua', 5);
insert into municipalities (name, region) values ('Juan Fernández', 5);
insert into municipalities (name, region) values ('La Calera', 5);
insert into municipalities (name, region) values ('La Cisterna', 13);
insert into municipalities (name, region) values ('La Cruz', 5);
insert into municipalities (name, region) values ('La Estrella', 6);
insert into municipalities (name, region) values ('La Florida', 13);
insert into municipalities (name, region) values ('La Granja', 13);
insert into municipalities (name, region) values ('La Higuera', 4);
insert into municipalities (name, region) values ('La Ligua', 5);
insert into municipalities (name, region) values ('La Pintana', 13);
insert into municipalities (name, region) values ('La Reina', 13);
insert into municipalities (name, region) values ('La Serena', 4);
insert into municipalities (name, region) values ('La Unión', 14);
insert into municipalities (name, region) values ('Lago Ranco', 14);
insert into municipalities (name, region) values ('Lago Verde', 11);
insert into municipalities (name, region) values ('Laguna Blanca', 12);
insert into municipalities (name, region) values ('Laja', 8);
insert into municipalities (name, region) values ('Lampa', 13);
insert into municipalities (name, region) values ('Lanco', 14);
insert into municipalities (name, region) values ('Las Cabras', 6);
insert into municipalities (name, region) values ('Las Condes', 13);
insert into municipalities (name, region) values ('Lautaro', 9);
insert into municipalities (name, region) values ('Lebu', 8);
insert into municipalities (name, region) values ('Licantén', 7);
insert into municipalities (name, region) values ('Limache', 5);
insert into municipalities (name, region) values ('Linares', 7);
insert into municipalities (name, region) values ('Litueche', 6);
insert into municipalities (name, region) values ('Llanquihue', 10);
insert into municipalities (name, region) values ('Llay Llay', 5);
insert into municipalities (name, region) values ('Lo Barnechea', 13);
insert into municipalities (name, region) values ('Lo Espejo', 13);
insert into municipalities (name, region) values ('Lo Prado', 13);
insert into municipalities (name, region) values ('Lolol', 6);
insert into municipalities (name, region) values ('Loncoche', 9);
insert into municipalities (name, region) values ('Longaví', 7);
insert into municipalities (name, region) values ('Lonquimay', 9);
insert into municipalities (name, region) values ('Los Andes', 5);
insert into municipalities (name, region) values ('Los Lagos', 14);
insert into municipalities (name, region) values ('Los Muermos', 10);
insert into municipalities (name, region) values ('Los Sauces', 9);
insert into municipalities (name, region) values ('Los Vilos', 4);
insert into municipalities (name, region) values ('Los Álamos', 8);
insert into municipalities (name, region) values ('Los Ángeles', 8);
insert into municipalities (name, region) values ('Lota', 8);
insert into municipalities (name, region) values ('Lumaco', 9);
insert into municipalities (name, region) values ('Machalí', 6);
insert into municipalities (name, region) values ('Macul', 13);
insert into municipalities (name, region) values ('Maipú', 13);
insert into municipalities (name, region) values ('Malloa', 6);
insert into municipalities (name, region) values ('Marchihue', 6);
insert into municipalities (name, region) values ('Mariquina', 14);
insert into municipalities (name, region) values ('María Elena', 2);
insert into municipalities (name, region) values ('María Pinto', 13);
insert into municipalities (name, region) values ('Maule', 7);
insert into municipalities (name, region) values ('Maullín', 10);
insert into municipalities (name, region) values ('Mejillones', 2);
insert into municipalities (name, region) values ('Melipeuco', 9);
insert into municipalities (name, region) values ('Melipilla', 13);
insert into municipalities (name, region) values ('Molina', 7);
insert into municipalities (name, region) values ('Monte Patria', 4);
insert into municipalities (name, region) values ('Mostazal', 6);
insert into municipalities (name, region) values ('Mulchén', 8);
insert into municipalities (name, region) values ('Máfil', 14);
insert into municipalities (name, region) values ('Nacimiento', 8);
insert into municipalities (name, region) values ('Nancagua', 6);
insert into municipalities (name, region) values ('Natales', 12);
insert into municipalities (name, region) values ('Navidad', 6);
insert into municipalities (name, region) values ('Negrete', 8);
insert into municipalities (name, region) values ('Ninhue', 8);
insert into municipalities (name, region) values ('Nogales', 5);
insert into municipalities (name, region) values ('Nueva Imperial', 9);
insert into municipalities (name, region) values ('Ñiquén', 8);
insert into municipalities (name, region) values ('Ñuñoa', 13);
insert into municipalities (name, region) values ('O''Higgins', 11);
insert into municipalities (name, region) values ('Olivar', 6);
insert into municipalities (name, region) values ('Ollagüe', 2);
insert into municipalities (name, region) values ('Olmué', 5);
insert into municipalities (name, region) values ('Osorno', 10);
insert into municipalities (name, region) values ('Ovalle', 4);
insert into municipalities (name, region) values ('Padre Hurtado', 13);
insert into municipalities (name, region) values ('Padre las Casas', 9);
insert into municipalities (name, region) values ('Paihuano', 4);
insert into municipalities (name, region) values ('Paillaco', 14);
insert into municipalities (name, region) values ('Paine', 13);
insert into municipalities (name, region) values ('Palena', 10);
insert into municipalities (name, region) values ('Palmilla', 6);
insert into municipalities (name, region) values ('Panguipulli', 14);
insert into municipalities (name, region) values ('Panquehue', 5);
insert into municipalities (name, region) values ('Papudo', 5);
insert into municipalities (name, region) values ('Paredones', 6);
insert into municipalities (name, region) values ('Parral', 7);
insert into municipalities (name, region) values ('Pedro Aguirre Cerda', 13);
insert into municipalities (name, region) values ('Pelarco', 7);
insert into municipalities (name, region) values ('Pelluhue', 7);
insert into municipalities (name, region) values ('Pemuco', 8);
insert into municipalities (name, region) values ('Pencahue', 7);
insert into municipalities (name, region) values ('Penco', 7);
insert into municipalities (name, region) values ('Peralillo', 6);
insert into municipalities (name, region) values ('Perquenco', 9);
insert into municipalities (name, region) values ('Petorca', 5);
insert into municipalities (name, region) values ('Peumo', 6);
insert into municipalities (name, region) values ('Peñaflor', 13);
insert into municipalities (name, region) values ('Peñalolén', 13);
insert into municipalities (name, region) values ('Pica', 6);
insert into municipalities (name, region) values ('Pichidegua', 6);
insert into municipalities (name, region) values ('Pichilemu', 6);
insert into municipalities (name, region) values ('Pinto', 8);
insert into municipalities (name, region) values ('Pirque', 13);
insert into municipalities (name, region) values ('Pitrufquén', 9);
insert into municipalities (name, region) values ('Placilla', 6);
insert into municipalities (name, region) values ('Portezuelo', 8);
insert into municipalities (name, region) values ('Porvenir', 12);
insert into municipalities (name, region) values ('Pozo Almonte', 1);
insert into municipalities (name, region) values ('Primavera', 12);
insert into municipalities (name, region) values ('Providencia', 13);
insert into municipalities (name, region) values ('Puchuncaví', 5);
insert into municipalities (name, region) values ('Pucón', 9);
insert into municipalities (name, region) values ('Pudahuel', 13);
insert into municipalities (name, region) values ('Puente Alto', 13);
insert into municipalities (name, region) values ('Puerto Montt', 10);
insert into municipalities (name, region) values ('Puerto Octay', 10);
insert into municipalities (name, region) values ('Puerto Varas', 10);
insert into municipalities (name, region) values ('Pumanque', 6);
insert into municipalities (name, region) values ('Punitaqui', 4);
insert into municipalities (name, region) values ('Punta Arenas', 12);
insert into municipalities (name, region) values ('Puqueldón', 10);
insert into municipalities (name, region) values ('Purranque', 10);
insert into municipalities (name, region) values ('Purén', 9);
insert into municipalities (name, region) values ('Putaendo', 5);
insert into municipalities (name, region) values ('Putre', 15);
insert into municipalities (name, region) values ('Puyehue', 10);
insert into municipalities (name, region) values ('Queilén', 10);
insert into municipalities (name, region) values ('Quellón', 10);
insert into municipalities (name, region) values ('Quemchi', 10);
insert into municipalities (name, region) values ('Quilaco', 8);
insert into municipalities (name, region) values ('Quilicura', 13);
insert into municipalities (name, region) values ('Quilleco', 8);
insert into municipalities (name, region) values ('Quillota', 5);
insert into municipalities (name, region) values ('Quillón', 8);
insert into municipalities (name, region) values ('Quilpué', 5);
insert into municipalities (name, region) values ('Quinchao', 10);
insert into municipalities (name, region) values ('Quinta Normal', 13);
insert into municipalities (name, region) values ('Quinta de Tilcoco', 6);
insert into municipalities (name, region) values ('Quintero', 5);
insert into municipalities (name, region) values ('Quirihue', 8);
insert into municipalities (name, region) values ('Rancagua', 6);
insert into municipalities (name, region) values ('Rauco', 7);
insert into municipalities (name, region) values ('Recoleta', 13);
insert into municipalities (name, region) values ('Renaico', 9);
insert into municipalities (name, region) values ('Renca', 13);
insert into municipalities (name, region) values ('Rengo', 6);
insert into municipalities (name, region) values ('Requínoa', 6);
insert into municipalities (name, region) values ('Retiro', 7);
insert into municipalities (name, region) values ('Rinconada', 5);
insert into municipalities (name, region) values ('Romeral', 7);
insert into municipalities (name, region) values ('Ránquil', 8);
insert into municipalities (name, region) values ('Río Bueno', 14);
insert into municipalities (name, region) values ('Río Claro', 7);
insert into municipalities (name, region) values ('Río Hurtado', 4);
insert into municipalities (name, region) values ('Río Ibáñez', 11);
insert into municipalities (name, region) values ('Río Negro', 10);
insert into municipalities (name, region) values ('Río Verde', 12);
insert into municipalities (name, region) values ('Saavedra', 9);
insert into municipalities (name, region) values ('Sagrada Familia', 7);
insert into municipalities (name, region) values ('Salamanca', 4);
insert into municipalities (name, region) values ('San Antonio', 5);
insert into municipalities (name, region) values ('San Bernardo', 13);
insert into municipalities (name, region) values ('San Carlos', 8);
insert into municipalities (name, region) values ('San Clemente', 7);
insert into municipalities (name, region) values ('San Esteban', 5);
insert into municipalities (name, region) values ('San Fabián', 8);
insert into municipalities (name, region) values ('San Felipe', 5);
insert into municipalities (name, region) values ('San Fernando', 6);
insert into municipalities (name, region) values ('San Gregorio', 12);
insert into municipalities (name, region) values ('San Ignacio', 8);
insert into municipalities (name, region) values ('San Javier', 7);
insert into municipalities (name, region) values ('San Joaquín', 13);
insert into municipalities (name, region) values ('San José de Maipo', 13);
insert into municipalities (name, region) values ('San Juan de la Costa', 10);
insert into municipalities (name, region) values ('San Miguel', 13);
insert into municipalities (name, region) values ('San Nicolás', 8);
insert into municipalities (name, region) values ('San Pablo', 10);
insert into municipalities (name, region) values ('San Pedro', 13);
insert into municipalities (name, region) values ('San Pedro de Atacama', 2);
insert into municipalities (name, region) values ('San Pedro de la Paz', 8);
insert into municipalities (name, region) values ('San Rafael', 7);
insert into municipalities (name, region) values ('San Ramón', 13);
insert into municipalities (name, region) values ('San Rosendo', 8);
insert into municipalities (name, region) values ('San Vicente', 6);
insert into municipalities (name, region) values ('Santa Bárbara', 8);
insert into municipalities (name, region) values ('Santa Cruz', 6);
insert into municipalities (name, region) values ('Santa Juana', 8);
insert into municipalities (name, region) values ('Santa María', 5);
insert into municipalities (name, region) values ('Santiago', 13);
insert into municipalities (name, region) values ('Santo Domingo', 5);
insert into municipalities (name, region) values ('Sierra Gorda', 2);
insert into municipalities (name, region) values ('Talagante', 13);
insert into municipalities (name, region) values ('Talca', 7);
insert into municipalities (name, region) values ('Talcahuano', 8);
insert into municipalities (name, region) values ('Taltal', 2);
insert into municipalities (name, region) values ('Temuco', 9);
insert into municipalities (name, region) values ('Teno', 7);
insert into municipalities (name, region) values ('Teodoro Schmidt', 9);
insert into municipalities (name, region) values ('Tierra Amarilla', 3);
insert into municipalities (name, region) values ('Tiltil', 13);
insert into municipalities (name, region) values ('Timaukel', 12);
insert into municipalities (name, region) values ('Tirúa', 8);
insert into municipalities (name, region) values ('Tocopilla', 2);
insert into municipalities (name, region) values ('Toltén', 9);
insert into municipalities (name, region) values ('Tomé', 8);
insert into municipalities (name, region) values ('Torres del Paine', 12);
insert into municipalities (name, region) values ('Tortel', 11);
insert into municipalities (name, region) values ('Traiguén', 9);
insert into municipalities (name, region) values ('Treguaco', 8);
insert into municipalities (name, region) values ('Tucapel', 8);
insert into municipalities (name, region) values ('Valdivia', 14);
insert into municipalities (name, region) values ('Vallenar', 3);
insert into municipalities (name, region) values ('Valparaíso', 5);
insert into municipalities (name, region) values ('Vichuquén', 7);
insert into municipalities (name, region) values ('Victoria', 9);
insert into municipalities (name, region) values ('Vicuña', 4);
insert into municipalities (name, region) values ('Vilcún', 9);
insert into municipalities (name, region) values ('Villa Alegre', 7);
insert into municipalities (name, region) values ('Villa Alemana', 5);
insert into municipalities (name, region) values ('Villarrica', 9);
insert into municipalities (name, region) values ('Vitacura', 13);
insert into municipalities (name, region) values ('Viña del Mar', 5);
insert into municipalities (name, region) values ('Yerbas Buenas', 7);
insert into municipalities (name, region) values ('Yumbel', 8);
insert into municipalities (name, region) values ('Yungay', 8);
insert into municipalities (name, region) values ('Zapallar', 5);

commit;