Skip to content

Instantly share code, notes, and snippets.

@hejrobin
Created April 5, 2011 10:39
Show Gist options
  • Save hejrobin/903409 to your computer and use it in GitHub Desktop.
Save hejrobin/903409 to your computer and use it in GitHub Desktop.
CREATE TABLE IF NOT EXISTS geo_counties (
id INT (11) NOT NULL,
slug VARCHAR (64) NOT NULL,
name VARCHAR (64) NOT NULL,
name_long VARCHAR (64) NOT NULL,
PRIMARY KEY(id)
) ENGINE = MyISAM;
CREATE TABLE IF NOT EXISTS geo_counties (
id INT (11) NOT NULL AUTO_INCREMENT,
county_id INT (11) NOT NULL,
slug VARCHAR (64) NOT NULL,
name VARCHAR (64) NOT NULL,
PRIMARY KEY(id),
FOREIGN KEY (county_id)
REFERENCES geo_counties(id)
) ENGINE = MyISAM;
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (1, 'stockholm', 'Stockholm', 'Stockholms län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (2, 'uppsala', 'Uppsala', 'Uppsala län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (3, 'sodermanland', 'Södermanland', 'Södermanlands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (4, 'ostergotland', 'Östergötland', 'Östergötlands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (5, 'jonkoping', 'Jönköping', 'Jönköpings län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (6, 'kronoberg', 'Kronoberg', 'Kronobergs län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (7, 'kalmar', 'Kalmar', 'Kalmar län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (8, 'gotland', 'Gotland', 'Gotlands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (9, 'blekinge', 'Blekinge', 'Blekinge län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (10, 'skane', 'Skåne', 'Skåne län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (11, 'halland', 'Halland', 'Hallands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (12, 'vastra-gotaland', 'Västra Götaland', 'Västra Götalands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (13, 'varmland', 'Värmland', 'Värmlands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (14, 'orebro', 'Örebro', 'Örebro län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (15, 'vastmanland', 'Västmanland', 'Västmanlands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (16, 'dalarna', 'Dalarna', 'Dalarnas län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (17, 'gavleborg', 'Gävleborg', 'Gävleborgs län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (18, 'vasternorrland', 'Västernorrland', 'Västernorrlands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (19, 'jamtland', 'Jämtland', 'Jämtlands län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (20, 'vasterbotten', 'Västerbotten', 'Västerbottens län');
INSERT INTO geo_counties (id, slug, name, name_long) VALUES (21, 'norrbotten', 'Norrbotten', 'Norrbottens län');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'upplands-vasby', 'Upplands-Väsby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'vallentuna', 'Vallentuna');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'osteraker', 'Österåker');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'varmdo', 'Värmdö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'jarfalla', 'Järfälla');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'ekero', 'Ekerö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'huddinge', 'Huddinge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'botkyrka', 'Botkyrka');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'salem', 'Salem');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'haninge', 'Haninge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'tyreso', 'Tyresö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'upplands-bro', 'Upplands-Bro');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'nykvarn', 'Nykvarn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'taby', 'Täby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'danderyd', 'Danderyd');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'sollentuna', 'Sollentuna');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'stockholm', 'Stockholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'sodertalje', 'Södertälje');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'nacka', 'Nacka');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'solna', 'Solna');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'lidingo', 'Lidingö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'vaxholm', 'Vaxholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'norrtalje', 'Norrtälje');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'sigtuna', 'Sigtuna');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (1, 'nynashamn', 'Nynäshamn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (2, 'habo', 'Håbo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (2, 'alvkarleby', 'Älvkarleby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (2, 'knivsta', 'Knivsta');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (2, 'tierp', 'Tierp');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (2, 'uppsala', 'Uppsala');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (2, 'enkoping', 'Enköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (2, 'osthammar', 'Östhammar');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'vingaker', 'Vingåker');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'gnesta', 'Gnesta');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'nykoping', 'Nyköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'oxelosund', 'Oxelösund');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'flen', 'Flen');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'katrineholm', 'Katrineholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'eskilstuna', 'Eskilstuna');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'strangnas', 'Strängnäs');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (3, 'trosa', 'Trosa');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'odeshog', 'Ödeshög');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'ydre', 'Ydre');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'kinda', 'Kinda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'boxholm', 'Boxholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'atvidaberg', 'Åtvidaberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'finspang', 'Finspång');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'valdemarsvik', 'Valdemarsvik');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'linkoping', 'Linköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'norrkoping', 'Norrköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'soderkoping', 'Söderköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'motala', 'Motala');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'vadstena', 'Vadstena');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (4, 'mjolby', 'Mjölby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'aneby', 'Aneby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'gnosjo', 'Gnosjö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'mullsjo', 'Mullsjö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'habo', 'Habo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'gislaved', 'Gislaved');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'vaggeryd', 'Vaggeryd');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'jonkoping', 'Jönköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'nassjo', 'Nässjö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'varnamo', 'Värnamo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'savsjo', 'Sävsjö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'vetlanda', 'Vetlanda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'eksjo', 'Eksjö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (5, 'tranas', 'Tranås');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'uppvidinge', 'Uppvidinge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'lessebo', 'Lessebo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'tingsryd', 'Tingsryd');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'alvesta', 'Alvesta');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'almhult', 'Älmhult');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'markaryd', 'Markaryd');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'vaxjo', 'Växjö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (6, 'ljungby', 'Ljungby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'hogsby', 'Högsby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'torsas', 'Torsås');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'morbylanga', 'Mörbylånga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'hultsfred', 'Hultsfred');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'monsteras', 'Mönsterås');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'emmaboda', 'Emmaboda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'kalmar', 'Kalmar');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'nybro', 'Nybro');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'oskarshamn', 'Oskarshamn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'vastervik', 'Västervik');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'vimmerby', 'Vimmerby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (7, 'borgholm', 'Borgholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (8, 'gotland', 'Gotland');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (9, 'olofstrom', 'Olofström');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (9, 'karlskrona', 'Karlskrona');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (9, 'ronneby', 'Ronneby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (9, 'karlshamn', 'Karlshamn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (9, 'solvesborg', 'Sölvesborg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'svalov', 'Svalöv');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'staffanstorp', 'Staffanstorp');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'burlov', 'Burlöv');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'vellinge', 'Vellinge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'ostra-goinge', 'Östra Göinge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'orkelljunga', 'Örkelljunga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'bjuv', 'Bjuv');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'kavlinge', 'Kävlinge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'lomma', 'Lomma');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'svedala', 'Svedala');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'skurup', 'Skurup');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'sjobo', 'Sjöbo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'horby', 'Hörby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'hoor', 'Höör');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'tomelilla', 'Tomelilla');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'bromolla', 'Bromölla');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'osby', 'Osby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'perstorp', 'Perstorp');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'klippan', 'Klippan');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'astorp', 'Åstorp');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'bastad', 'Båstad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'malmo', 'Malmö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'lund', 'Lund');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'landskrona', 'Landskrona');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'helsingborg', 'Helsingborg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'hoganas', 'Höganäs');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'eslov', 'Eslöv');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'ystad', 'Ystad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'trelleborg', 'Trelleborg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'kristianstad', 'Kristianstad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'simrishamn', 'Simrishamn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'angelholm', 'Ängelholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (10, 'hassleholm', 'Hässleholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (11, 'hylte', 'Hylte');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (11, 'halmstad', 'Halmstad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (11, 'laholm', 'Laholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (11, 'falkenberg', 'Falkenberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (11, 'varberg', 'Varberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (11, 'kungsbacka', 'Kungsbacka');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'harryda', 'Härryda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'partille', 'Partille');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'ockero', 'Öckerö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'stenungsund', 'Stenungsund');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'tjorn', 'Tjörn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'orust', 'Orust');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'sotenas', 'Sotenäs');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'munkedal', 'Munkedal');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'tanum', 'Tanum');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'dals-ed', 'Dals-Ed');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'fargelanda', 'Färgelanda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'ale', 'Ale');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'lerum', 'Lerum');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'vargarda', 'Vårgårda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'bollebygd', 'Bollebygd');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'grastorp', 'Grästorp');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'essunga', 'Essunga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'karlsborg', 'Karlsborg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'gullspang', 'Gullspång');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'tranemo', 'Tranemo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'bengtsfors', 'Bengtsfors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'mellerud', 'Mellerud');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'lilla-edet', 'Lilla Edet');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'svenljunga', 'Svenljunga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'herrljunga', 'Herrljunga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'vara', 'Vara');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'gotene', 'Götene');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'tibro', 'Tibro');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'toreboda', 'Töreboda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'goteborg', 'Göteborg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'molndal', 'Mölndal');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'kungalv', 'Kungälv');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'lysekil', 'Lysekil');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'uddevalla', 'Uddevalla');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'stromstad', 'Strömstad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'vanersborg', 'Vänersborg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'trollhattan', 'Trollhättan');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'alingsas', 'Alingsås');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'boras', 'Borås');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'ulricehamn', 'Ulricehamn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'amal', 'Åmål');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'mariestad', 'Mariestad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'lidkoping', 'Lidköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'skara', 'Skara');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'skovde', 'Skövde');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'hjo', 'Hjo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'tidaholm', 'Tidaholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (12, 'falkoping', 'Falköping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'kil', 'Kil');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'eda', 'Eda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'torsby', 'Torsby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'storfors', 'Storfors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'hammaro', 'Hammarö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'munkfors', 'Munkfors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'forshaga', 'Forshaga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'grums', 'Grums');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'arjang', 'Årjäng');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'sunne', 'Sunne');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'karlstad', 'Karlstad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'kristinehamn', 'Kristinehamn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'filipstad', 'Filipstad');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'hagfors', 'Hagfors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'arvika', 'Arvika');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (13, 'saffle', 'Säffle');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'lekeberg', 'Lekeberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'laxa', 'Laxå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'hallsberg', 'Hallsberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'degerfors', 'Degerfors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'hallefors', 'Hällefors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'ljusnarsberg', 'Ljusnarsberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'orebro', 'Örebro');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'kumla', 'Kumla');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'askersund', 'Askersund');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'karlskoga', 'Karlskoga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'nora', 'Nora');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (14, 'lindesberg', 'Lindesberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'skinnskatteberg', 'Skinnskatteberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'surahammar', 'Surahammar');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'heby', 'Heby');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'kungsor', 'Kungsör');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'hallstahammar', 'Hallstahammar');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'norberg', 'Norberg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'vasteras', 'Västerås');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'sala', 'Sala');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'fagersta', 'Fagersta');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'koping', 'Köping');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (15, 'arboga', 'Arboga');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'vansbro', 'Vansbro');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'malung', 'Malung');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'gagnef', 'Gagnef');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'leksand', 'Leksand');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'rattvik', 'Rättvik');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'orsa', 'Orsa');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'alvdalen', 'Älvdalen');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'smedjebacken', 'Smedjebacken');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'mora', 'Mora');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'falun', 'Falun');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'borlange', 'Borlänge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'sater', 'Säter');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'hedemora', 'Hedemora');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'avesta', 'Avesta');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (16, 'ludvika', 'Ludvika');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'ockelbo', 'Ockelbo');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'hofors', 'Hofors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'ovanaker', 'Ovanåker');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'nordanstig', 'Nordanstig');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'ljusdal', 'Ljusdal');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'gavle', 'Gävle');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'sandviken', 'Sandviken');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'soderhamn', 'Söderhamn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'bollnas', 'Bollnäs');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (17, 'hudiksvall', 'Hudiksvall');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (18, 'ange', 'Ånge');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (18, 'timra', 'Timrå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (18, 'harnosand', 'Härnösand');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (18, 'sundsvall', 'Sundsvall');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (18, 'kramfors', 'Kramfors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (18, 'solleftea', 'Sollefteå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (18, 'ornskoldsvik', 'Örnsköldsvik');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'ragunda', 'Ragunda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'bracke', 'Bräcke');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'krokom', 'Krokom');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'stromsund', 'Strömsund');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'are', 'Åre');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'berg', 'Berg');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'harjedalen', 'Härjedalen');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (19, 'ostersund', 'Östersund');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'nordmaling', 'Nordmaling');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'bjurholm', 'Bjurholm');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'vindeln', 'Vindeln');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'robertsfors', 'Robertsfors');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'norsjo', 'Norsjö');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'mala', 'Malå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'storuman', 'Storuman');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'sorsele', 'Sorsele');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'dorotea', 'Dorotea');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'vannas', 'Vännäs');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'vilhelmina', 'Vilhelmina');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'asele', 'Åsele');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'umea', 'Umeå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'lycksele', 'Lycksele');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (20, 'skelleftea', 'Skellefteå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'arvidsjaur', 'Arvidsjaur');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'arjeplog', 'Arjeplog');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'jokkmokk', 'Jokkmokk');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'overkalix', 'Överkalix');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'kalix', 'Kalix');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'overtornea', 'Övertorneå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'pajala', 'Pajala');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'gallivare', 'Gällivare');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'alvsbyn', 'Älvsbyn');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'lulea', 'Luleå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'pitea', 'Piteå');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'boden', 'Boden');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'haparanda', 'Haparanda');
INSERT INTO geo_municipalities (county_id, slug, name) VALUES (21, 'kiruna', 'Kiruna');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment