DROP TABLE IF EXISTS "airport";
CREATE TABLE airport (id integer, country varchar(2), name varchar(50));
INSERT INTO "airport" VALUES(1,'GM','BAYREUTH');
INSERT INTO "airport" VALUES(2,'GM','SPANGDAHLEM AB');
INSERT INTO "airport" VALUES(3,'GM','MAINZ FINTHEN');
INSERT INTO "airport" VALUES(4,'GM','EGELSBACH');
INSERT INTO "airport" VALUES(5,'GM','HAHN');
INSERT INTO "airport" VALUES(6,'BE','BERTRIX JEHONVILLE');
INSERT INTO "airport" VALUES(7,'GM','TRIER FOHREN');
INSERT INTO "airport" VALUES(8,'GM','ROSENTHAL FIELD PLOSSEN');
INSERT INTO "airport" VALUES(9,'GM','DARMSTADT AAF');
INSERT INTO "airport" VALUES(10,'GM','BURG FEUERSTEIN');
INSERT INTO "airport" VALUES(11,'FR','CHARLEVILLE MEZIERES');
INSERT INTO "airport" VALUES(12,'GM','KITZINGEN AAF');
INSERT INTO "airport" VALUES(13,'GM','GRAFENWOHR AAF');
INSERT INTO "airport" VALUES(14,'EZ','LINE');
INSERT INTO "airport" VALUES(15,'GM','GIEBELSTADT AAF');
INSERT INTO "airport" VALUES(16,'GM','VILSECK AAF');
INSERT INTO "airport" VALUES(17,'LU','LUXEMBOURG');
INSERT INTO "airport" VALUES(18,'GM','COLEMAN AAF');
INSERT INTO "airport" VALUES(19,'GM','NURNBERG');
INSERT INTO "airport" VALUES(20,'GM','MANNHEIM');
INSERT INTO "airport" VALUES(21,'GM','RAMSTEIN AB');
INSERT INTO "airport" VALUES(22,'GM','HEIDELBERG AAF');
INSERT INTO "airport" VALUES(23,'GM','NIEDERSTETTEN');
INSERT INTO "airport" VALUES(24,'GM','FEUCHT AAF');
INSERT INTO "airport" VALUES(25,'FR','CHAMPAGNE');
INSERT INTO "airport" VALUES(26,'GM','SPEYER');
INSERT INTO "airport" VALUES(27,'FR','ROUVRES');
INSERT INTO "airport" VALUES(28,'GM','SAARBRUCKEN');
INSERT INTO "airport" VALUES(29,'GM','ZWEIBRUCKEN');
INSERT INTO "airport" VALUES(30,'FR','PRUNAY');
INSERT INTO "airport" VALUES(31,'FR','LE ROZELIER');
INSERT INTO "airport" VALUES(32,'GM','SCHWABISCH HALL HESSENTAL');
INSERT INTO "airport" VALUES(33,'FR','FRESCATY');
INSERT INTO "airport" VALUES(34,'FR','METZ NANCY LORRAINE');
INSERT INTO "airport" VALUES(35,'GM','KARLSRUHE FORCHHEIM');
INSERT INTO "airport" VALUES(36,'EZ','CESKE BUDEJOVICE');
INSERT INTO "airport" VALUES(37,'GM','STRAUBING WALLMUHLE');
INSERT INTO "airport" VALUES(38,'FR','HAGUENAU');
INSERT INTO "airport" VALUES(39,'GM','BADEN BADEN OOS');
INSERT INTO "airport" VALUES(40,'FR','ROSIERES');
INSERT INTO "airport" VALUES(41,'GM','KARLSRUHE BADEN BADEN');
INSERT INTO "airport" VALUES(42,'GM','AALEN HEIDENHEIM ELCHINGEN');
INSERT INTO "airport" VALUES(43,'FR','VATRY');
INSERT INTO "airport" VALUES(44,'FR','BOURSCHEID');
INSERT INTO "airport" VALUES(45,'GM','INGOLSTADT MANCHING');
INSERT INTO "airport" VALUES(46,'GM','NEUBURG');
INSERT INTO "airport" VALUES(47,'FR','ESSEY');
INSERT INTO "airport" VALUES(48,'GM','STUTTGART');
INSERT INTO "airport" VALUES(49,'GM','VILSHOFEN');
INSERT INTO "airport" VALUES(50,'FR','ROBINSON');
INSERT INTO "airport" VALUES(51,'FR','CROISMARE');
INSERT INTO "airport" VALUES(52,'FR','OCHEY');
INSERT INTO "airport" VALUES(53,'FR','ENTZHEIM');
INSERT INTO "airport" VALUES(54,'GM','LEIPHEIM');
INSERT INTO "airport" VALUES(55,'FR','BRIENNE  LE CHATEAU');
INSERT INTO "airport" VALUES(56,'GM','AUGSBURG');
INSERT INTO "airport" VALUES(57,'GM','LAHR');
INSERT INTO "airport" VALUES(58,'GM','MUNCHEN');
INSERT INTO "airport" VALUES(59,'GM','ERDING');
INSERT INTO "airport" VALUES(60,'FR','BARBEREY');
INSERT INTO "airport" VALUES(61,'FR','MIRECOURT');
INSERT INTO "airport" VALUES(62,'AU','LINZ');
INSERT INTO "airport" VALUES(63,'GM','LAUPHEIM');
INSERT INTO "airport" VALUES(64,'GM','FURSTENFELDBRUCK');
INSERT INTO "airport" VALUES(65,'GM','LECHFELD');
INSERT INTO "airport" VALUES(66,'AU','WELS');
INSERT INTO "airport" VALUES(67,'FR','HOUSSEN');
INSERT INTO "airport" VALUES(68,'FR','DAMBLAIN');
INSERT INTO "airport" VALUES(69,'GM','OBERPFAFFENHOFEN');
INSERT INTO "airport" VALUES(70,'GM','LANDSBERG LECH');
INSERT INTO "airport" VALUES(71,'GM','MENGEN');
INSERT INTO "airport" VALUES(72,'GM','FREIBURG');
INSERT INTO "airport" VALUES(73,'GM','MEMMINGEN');
INSERT INTO "airport" VALUES(74,'GM','DONAUESCHINGEN VILLINGEN');
INSERT INTO "airport" VALUES(75,'FR','MEYENHEIM');
INSERT INTO "airport" VALUES(76,'GM','BREMGARTEN');
INSERT INTO "airport" VALUES(77,'GM','LEUTKIRCH UNTERZEIL');
INSERT INTO "airport" VALUES(78,'AU','SALZBURG');
INSERT INTO "airport" VALUES(79,'FR','SAINT SAUVEUR');
INSERT INTO "airport" VALUES(80,'FR','HABSHEIM');
INSERT INTO "airport" VALUES(81,'GM','FRIEDRICHSHAFEN');
INSERT INTO "airport" VALUES(82,'FR','FROTEY');
INSERT INTO "airport" VALUES(83,'FR','BALE MULHOUSE');
INSERT INTO "airport" VALUES(84,'FR','COURCELLES');
INSERT INTO "airport" VALUES(85,'SZ','ST GALLEN ALTENRHEIN');
INSERT INTO "airport" VALUES(86,'SZ','ZURICH');
INSERT INTO "airport" VALUES(87,'SZ','DUBENDORF');
INSERT INTO "airport" VALUES(88,'FR','LONGVIC');
INSERT INTO "airport" VALUES(89,'AU','INNSBRUCK');
INSERT INTO "airport" VALUES(90,'FR','LA VEZE');
INSERT INTO "airport" VALUES(91,'AU','ZELTWEG');
INSERT INTO "airport" VALUES(92,'SZ','EMMEN');
INSERT INTO "airport" VALUES(93,'SZ','LES EPLATURES');
INSERT INTO "airport" VALUES(94,'SZ','MOLLIS');
INSERT INTO "airport" VALUES(95,'FR','TAVAUX');
INSERT INTO "airport" VALUES(96,'FR','CHALLANGES');
INSERT INTO "airport" VALUES(97,'SZ','BUOCHS');
INSERT INTO "airport" VALUES(98,'FR','BELLEVUE');
INSERT INTO "airport" VALUES(99,'SZ','ALPNACH');
INSERT INTO "airport" VALUES(100,'SZ','BERN BELP');
INSERT INTO "airport" VALUES(101,'FR','PONTARLIER');
INSERT INTO "airport" VALUES(102,'SZ','PAYERNE');
INSERT INTO "airport" VALUES(103,'FR','CHAMPFORGEUIL');
INSERT INTO "airport" VALUES(104,'SZ','MEIRINGEN');
INSERT INTO "airport" VALUES(105,'SZ','INTERLAKEN');
INSERT INTO "airport" VALUES(106,'AU','KLAGENFURT');
INSERT INTO "airport" VALUES(107,'SZ','REICHENBACH');
INSERT INTO "airport" VALUES(108,'SZ','SAMEDAN');
INSERT INTO "airport" VALUES(109,'SZ','AMBRI');
INSERT INTO "airport" VALUES(110,'SZ','ULRICHEN');
INSERT INTO "airport" VALUES(111,'SZ','ST STEPHAN');
INSERT INTO "airport" VALUES(112,'SZ','SAANEN');
INSERT INTO "airport" VALUES(113,'IT','BOLZANO');
INSERT INTO "airport" VALUES(114,'FR','SAINT YAN');
INSERT INTO "airport" VALUES(115,'SZ','TURTMANN');
INSERT INTO "airport" VALUES(116,'SZ','RARON');
INSERT INTO "airport" VALUES(117,'FR','CHARNAY');
INSERT INTO "airport" VALUES(118,'SZ','GENEVA COINTRIN');
INSERT INTO "airport" VALUES(119,'SI','LJUBLJANA');
INSERT INTO "airport" VALUES(120,'SZ','SION');
INSERT INTO "airport" VALUES(121,'FR','CEYZERIAT');
INSERT INTO "airport" VALUES(122,'FR','ANNEMASSE');
INSERT INTO "airport" VALUES(123,'IT','AVIANO AB');
INSERT INTO "airport" VALUES(124,'IT','MATTARELLO');
INSERT INTO "airport" VALUES(125,'SZ','LUGANO');
INSERT INTO "airport" VALUES(126,'FR','AMBERIEU');
INSERT INTO "airport" VALUES(127,'IT','RIVOLTO');
INSERT INTO "airport" VALUES(128,'FR','MEYTHET');
INSERT INTO "airport" VALUES(129,'FR','TARARE');
INSERT INTO "airport" VALUES(130,'IT','ASIAGO');
INSERT INTO "airport" VALUES(131,'IT','RONCHI DEI LEGIONARI');
INSERT INTO "airport" VALUES(132,'IT','VENEGONO');
INSERT INTO "airport" VALUES(133,'IT','AOSTA');
INSERT INTO "airport" VALUES(134,'FR','BRON');
INSERT INTO "airport" VALUES(135,'FR','SATOLAS');
INSERT INTO "airport" VALUES(136,'IT','VERGIATE');
INSERT INTO "airport" VALUES(137,'IT','ISTRANA');
INSERT INTO "airport" VALUES(138,'IT','BERGAMO ORIO AL SERIO');
INSERT INTO "airport" VALUES(139,'IT','TREVISO');
INSERT INTO "airport" VALUES(140,'FR','AIX LES BAINS');
INSERT INTO "airport" VALUES(141,'IT','MALPENSA');
INSERT INTO "airport" VALUES(142,'IT','VICENZA');
INSERT INTO "airport" VALUES(143,'FR','CHALLES LES EAUX');
INSERT INTO "airport" VALUES(144,'FR','BOUTHEON');
INSERT INTO "airport" VALUES(145,'IT','BRESSO');
INSERT INTO "airport" VALUES(146,'IT','CAMERI');
INSERT INTO "airport" VALUES(147,'IT','VENEZIA TESSERA');
INSERT INTO "airport" VALUES(148,'IT','BIELLA CERRIONE');
INSERT INTO "airport" VALUES(149,'SI','PORTOROZ');
INSERT INTO "airport" VALUES(150,'IT','VERONA BOSCOMANTICO');
INSERT INTO "airport" VALUES(151,'IT','LINATE');
INSERT INTO "airport" VALUES(152,'IT','GHEDI');
INSERT INTO "airport" VALUES(153,'IT','MONTICHIARI');
INSERT INTO "airport" VALUES(154,'IT','PADOVA');
INSERT INTO "airport" VALUES(155,'IT','VILLAFRANCA');
INSERT INTO "airport" VALUES(156,'HR','GROBNICKL POLJE');
INSERT INTO "airport" VALUES(157,'FR','SAINT GEOIRS');
INSERT INTO "airport" VALUES(158,'HR','RIJEKA');
INSERT INTO "airport" VALUES(159,'IT','TORINO');
INSERT INTO "airport" VALUES(160,'IT','AERITALIA');
INSERT INTO "airport" VALUES(161,'EZ','CASLAV');
INSERT INTO "airport" VALUES(162,'EZ','NAMEST');
INSERT INTO "airport" VALUES(163,'EZ','TURANY');
INSERT INTO "airport" VALUES(164,'AU','TULLN');
INSERT INTO "airport" VALUES(165,'AU','SCHWECHAT');
INSERT INTO "airport" VALUES(166,'AU','WIENER NEUSTADT EAST');
INSERT INTO "airport" VALUES(167,'AU','GRAZ');
INSERT INTO "airport" VALUES(168,'HU','ZALAEGERSZEG');
INSERT INTO "airport" VALUES(169,'SI','MARIBOR');
INSERT INTO "airport" VALUES(170,'SI','SLOVENJ GRADEC');
INSERT INTO "airport" VALUES(171,'HR','VARAZDIN');
INSERT INTO "airport" VALUES(172,'SI','CERKLJE');
INSERT INTO "airport" VALUES(173,'HR','ZAGREB');
INSERT INTO "airport" VALUES(174,'IT','VOGHERA');
INSERT INTO "airport" VALUES(175,'FR','CHABEUIL');
INSERT INTO "airport" VALUES(176,'IT','PIACENZA');
INSERT INTO "airport" VALUES(177,'HR','PULA');
INSERT INTO "airport" VALUES(178,'IT','PARMA');
INSERT INTO "airport" VALUES(179,'IT','REGGIO EMILIA');
INSERT INTO "airport" VALUES(180,'IT','LEVALDIGI');
INSERT INTO "airport" VALUES(181,'FR','VALS LANAS');
INSERT INTO "airport" VALUES(182,'IT','BOLOGNA');
INSERT INTO "airport" VALUES(183,'IT','GENOVA SESTRI');
INSERT INTO "airport" VALUES(184,'IT','RAVENNA');
INSERT INTO "airport" VALUES(185,'IT','CERVIA');
INSERT INTO "airport" VALUES(186,'IT','FORLI');
INSERT INTO "airport" VALUES(187,'FR','PLAN DE DIEU');
INSERT INTO "airport" VALUES(188,'FR','CARITAT');
INSERT INTO "airport" VALUES(189,'FR','DEAUX');
INSERT INTO "airport" VALUES(190,'FR','SAINT CHRISTOL');
INSERT INTO "airport" VALUES(191,'IT','ALBENGA');
INSERT INTO "airport" VALUES(192,'FR','CARPENTRAS');
INSERT INTO "airport" VALUES(193,'IT','RIMINI');
INSERT INTO "airport" VALUES(194,'FR','CAUMONT');
INSERT INTO "airport" VALUES(195,'IT','PERETOLA');
INSERT INTO "airport" VALUES(196,'FR','GARONS');
INSERT INTO "airport" VALUES(197,'IT','PISA');
INSERT INTO "airport" VALUES(198,'FR','COTE D AZUR');
INSERT INTO "airport" VALUES(199,'IT','PONTEDERA');
INSERT INTO "airport" VALUES(200,'IT','FALCONARA');
INSERT INTO "airport" VALUES(201,'FR','SALON');
INSERT INTO "airport" VALUES(202,'FR','MANDELIEU');
INSERT INTO "airport" VALUES(203,'FR','LE TUBE');
INSERT INTO "airport" VALUES(204,'FR','AIX LES MILLES');
INSERT INTO "airport" VALUES(205,'FR','PROVENCE');
INSERT INTO "airport" VALUES(206,'FR','LE CANNET');
INSERT INTO "airport" VALUES(207,'IT','AMPUGNANO');
INSERT INTO "airport" VALUES(208,'FR','LE CASTELLET');
INSERT INTO "airport" VALUES(209,'FR','PIERREFEU');
INSERT INTO "airport" VALUES(210,'FR','LA MOLE');
INSERT INTO "airport" VALUES(211,'FR','LE PALYVESTRE');
INSERT INTO "airport" VALUES(212,'IT','PERUGIA');
INSERT INTO "airport" VALUES(213,'IT','MARINA DI CAMPO');
INSERT INTO "airport" VALUES(214,'IT','GROSSETO');
INSERT INTO "airport" VALUES(215,'FR','PORETTA');
INSERT INTO "airport" VALUES(216,'FR','SAINT CATHERINE');
INSERT INTO "airport" VALUES(217,'IT','VITERBO');
INSERT INTO "airport" VALUES(218,'IT','PESCARA');
INSERT INTO "airport" VALUES(219,'IT','L AQUILA PRETURO');
INSERT INTO "airport" VALUES(220,'FR','CORTE');
INSERT INTO "airport" VALUES(221,'HR','UDBINA');
INSERT INTO "airport" VALUES(222,'HR','SEPURINE TRAINING BASE');
INSERT INTO "airport" VALUES(223,'HR','ZADAR');
INSERT INTO "airport" VALUES(224,'HR','SPLIT');
INSERT INTO "airport" VALUES(225,'HR','BRAC');
DROP TABLE IF EXISTS "country";
CREATE TABLE country (id varchar(2), name varchar(50));
INSERT INTO "country" VALUES('GM','GERMANY');
INSERT INTO "country" VALUES('BE','BELGIUM');
INSERT INTO "country" VALUES('FR','FRANCE');
INSERT INTO "country" VALUES('EZ','CZECH REPUBLIC');
INSERT INTO "country" VALUES('LU','LUXEMBOURG');
INSERT INTO "country" VALUES('AU','AUSTRIA');
INSERT INTO "country" VALUES('SZ','SWITZERLAND');
INSERT INTO "country" VALUES('IT','ITALY');
INSERT INTO "country" VALUES('SI','SLOVENIA');
INSERT INTO "country" VALUES('HR','CROATIA');
INSERT INTO "country" VALUES('HU','HUNGARY');
DROP TABLE IF EXISTS "district";
CREATE TABLE district (id integer, country varchar(2), name varchar(50), area integer);
INSERT INTO "district" VALUES(26,'SZ','SCHAFFHAUSEN',290);
INSERT INTO "district" VALUES(129,'HR','CROATIA',52406);
INSERT INTO "district" VALUES(278,'HR','OTOK SVETAC CROATIA',3);
INSERT INTO "district" VALUES(135,'EZ','JIHOMORAVSKY',14583);
INSERT INTO "district" VALUES(203,'SM','SAN MARINO',60);
INSERT INTO "district" VALUES(221,'IT','LAZIO',17061);
INSERT INTO "district" VALUES(222,'IT','ISOLA PIONOSA TOSCANA',11);
INSERT INTO "district" VALUES(34,'SZ','AARGAU',1450);
INSERT INTO "district" VALUES(271,'HR','OTOK SOLTA CROATIA',61);
INSERT INTO "district" VALUES(2,'FR','NORD-PAS-DE-CALAIS',12546);
INSERT INTO "district" VALUES(185,'HR','OTOK LOSINJ CROATIA',77);
INSERT INTO "district" VALUES(63,'AU','KARNTEN',9427);
INSERT INTO "district" VALUES(67,'SZ','GLARUS',695);
INSERT INTO "district" VALUES(11,'FR','PICARDIE',19728);
INSERT INTO "district" VALUES(180,'HR','OTOK PAG CROATIA',291);
INSERT INTO "district" VALUES(267,'HR','OTOK ZIRJE CROATIA',17);
INSERT INTO "district" VALUES(197,'HR','OTOK MOLAT CROATIA',22);
INSERT INTO "district" VALUES(289,'IT','PUGLIA',1);
INSERT INTO "district" VALUES(4,'BE','NAMUR',3667);
INSERT INTO "district" VALUES(76,'IT','VENETO',18091);
INSERT INTO "district" VALUES(84,'IT','PIEMONTE',25392);
INSERT INTO "district" VALUES(36,'AU','VORARLBERG',2595);
INSERT INTO "district" VALUES(213,'FR','ILE DU LEVANT PROVENCE-ALPES-COTE D AZUR',9);
INSERT INTO "district" VALUES(286,'HR','OTOK PALAGRUZA CROATIA',1);
INSERT INTO "district" VALUES(208,'IT','ISOLA DI GORGONA TOSCANA',3);
INSERT INTO "district" VALUES(220,'IT','ELBA TOSCANA',227);
INSERT INTO "district" VALUES(83,'IT','LOMBARDIA',24070);
INSERT INTO "district" VALUES(10,'EZ','STREDOCESKY',11260);
INSERT INTO "district" VALUES(18,'GM','BADEN-WURTTEMBERG',36030);
INSERT INTO "district" VALUES(174,'HR','OTOK RAB CROATIA',88);
INSERT INTO "district" VALUES(282,'HR','OTOK KORCULA CROATIA',271);
INSERT INTO "district" VALUES(287,'HR','ISOLA PIANOSA PUGLIA',0);
INSERT INTO "district" VALUES(81,'FR','RHONE-ALPES',45120);
INSERT INTO "district" VALUES(178,'FR','LANGUEDOC-ROUSSILLON',27669);
INSERT INTO "district" VALUES(5,'GM','RHEINLAND-PFALZ',19807);
INSERT INTO "district" VALUES(71,'SZ','OBWALDEN',495);
INSERT INTO "district" VALUES(123,'IT','EMILIA-ROMAGNA',22113);
INSERT INTO "district" VALUES(142,'AU','BURGENLAND',4032);
INSERT INTO "district" VALUES(54,'SZ','ZUG',226);
INSERT INTO "district" VALUES(59,'SZ','GRAUBUNDEN',7106);
INSERT INTO "district" VALUES(60,'SZ','NIDWALDEN',292);
INSERT INTO "district" VALUES(16,'FR','LORRAINE',23821);
INSERT INTO "district" VALUES(86,'IT','FRIULI-VENEZIA GIULIA',7571);
INSERT INTO "district" VALUES(43,'SZ','APPENZELL INNER-RHODEN',180);
INSERT INTO "district" VALUES(138,'LO','ZAPADOSLOVENSKY',14548);
INSERT INTO "district" VALUES(147,'HU','SOMOGY',6123);
INSERT INTO "district" VALUES(122,'FR','PROVENCE-ALPES-COTE D AZUR',31500);
INSERT INTO "district" VALUES(32,'SZ','BASEL-STADT',41);
INSERT INTO "district" VALUES(255,'HR','OTOK KORNAT CROATIA',34);
INSERT INTO "district" VALUES(224,'IT','ISOLA DI MONTECRISTO TOSCANA',12);
INSERT INTO "district" VALUES(68,'SZ','VAUD',3208);
INSERT INTO "district" VALUES(283,'HR','OTOK SUSAC CROATIA',5);
INSERT INTO "district" VALUES(219,'IT','UMBRIA',8512);
INSERT INTO "district" VALUES(275,'HR','OTOK HVAR CROATIA',301);
INSERT INTO "district" VALUES(139,'AU','WIEN',430);
INSERT INTO "district" VALUES(55,'SZ','LUZERN',1479);
INSERT INTO "district" VALUES(290,'IT','ISOLA SAN DOMINGO PUGLIA',3);
INSERT INTO "district" VALUES(216,'FR','CORSICA CORSE',8746);
INSERT INTO "district" VALUES(192,'HR','OTOK OLIB CROATIA',26);
INSERT INTO "district" VALUES(204,'IT','MARCHE',9801);
INSERT INTO "district" VALUES(148,'HU','ZALA',3926);
INSERT INTO "district" VALUES(27,'SZ','THURGAU',1038);
INSERT INTO "district" VALUES(227,'IT','ABRUZZI',10922);
INSERT INTO "district" VALUES(193,'HR','OTAK PREMUDA (ISLAND) CROATIA',8);
INSERT INTO "district" VALUES(69,'SZ','URI',1070);
INSERT INTO "district" VALUES(233,'HR','OTOK UGLJAN CROATIA',51);
INSERT INTO "district" VALUES(200,'IT','TOSCANA',22681);
INSERT INTO "district" VALUES(1,'GM','HESSEN',21023);
INSERT INTO "district" VALUES(126,'HR','KRK CROATIA',420);
INSERT INTO "district" VALUES(82,'SZ','GENEVE',250);
INSERT INTO "district" VALUES(8,'EZ','ZAPADOCESKY',10980);
INSERT INTO "district" VALUES(58,'LS','LIECHTENSTEIN',151);
INSERT INTO "district" VALUES(131,'EZ','VYCHODOCESKY',11690);
INSERT INTO "district" VALUES(3,'BE','HAINAUT',3820);
INSERT INTO "district" VALUES(288,'HR','ISOLE TREMITI PUGLIA',1);
INSERT INTO "district" VALUES(240,'HR','OTOK PASMAN CROATIA',63);
INSERT INTO "district" VALUES(206,'MN','MONACO',8);
INSERT INTO "district" VALUES(51,'SZ','SCHWYZ',951);
INSERT INTO "district" VALUES(7,'BE','LUXEMBOURG',4472);
INSERT INTO "district" VALUES(17,'GM','SAARLAND',2505);
INSERT INTO "district" VALUES(78,'SZ','VALAIS',5061);
INSERT INTO "district" VALUES(14,'LU','LUXEMBOURG',934);
INSERT INTO "district" VALUES(35,'SZ','BASEL-LANDSCHAFT',432);
INSERT INTO "district" VALUES(56,'IT','TRENTINO-ALTO ADIGE',13636);
INSERT INTO "district" VALUES(285,'HR','OTOK LASTOVO CROATIA',47);
INSERT INTO "district" VALUES(85,'IT','VALLE D AOSTA',3309);
INSERT INTO "district" VALUES(279,'HR','OTOK VIS CROATIA',92);
INSERT INTO "district" VALUES(128,'SI','SLOVENIA',20771);
INSERT INTO "district" VALUES(130,'PL','OPOLE',8682);
INSERT INTO "district" VALUES(20,'FR','ALSACE',8091);
INSERT INTO "district" VALUES(190,'IT','LIGURIA',5452);
INSERT INTO "district" VALUES(218,'FR','ILE DE PORQUEROLLES PROVENCE-ALPES-COTE D AZUR',13);
INSERT INTO "district" VALUES(13,'LU','GREVENMACHER',524);
INSERT INTO "district" VALUES(22,'AU','OBEROSTERREICH',12039);
INSERT INTO "district" VALUES(125,'HR','OTOK CRES CROATIA',411);
INSERT INTO "district" VALUES(40,'SZ','BERN',5973);
INSERT INTO "district" VALUES(42,'SZ','JURA',900);
INSERT INTO "district" VALUES(52,'SZ','NEUCHATEL',849);
INSERT INTO "district" VALUES(133,'EZ','SEVEROMORAVSKY',11649);
INSERT INTO "district" VALUES(39,'SZ','SOLOTHURN',815);
INSERT INTO "district" VALUES(272,'HR','OTOK BRAC CROATIA',404);
INSERT INTO "district" VALUES(144,'HU','VAS',3435);
INSERT INTO "district" VALUES(48,'AU','TIROL',12762);
INSERT INTO "district" VALUES(6,'GM','BAYERN',70334);
INSERT INTO "district" VALUES(12,'FR','CHAMPAGNE-ARDENNE',25947);
INSERT INTO "district" VALUES(151,'BK','BOSNIA AND HERZEGOVINA',51580);
INSERT INTO "district" VALUES(79,'FR','AUVERGNE',26218);
INSERT INTO "district" VALUES(214,'IT','ISOLA DI CAPRAIA TOSCANA',19);
INSERT INTO "district" VALUES(44,'SZ','APPENZELL AUSSER-RHODEN',250);
INSERT INTO "district" VALUES(223,'IT','ISOLA DEL GIGLIO TOSCANA',23);
INSERT INTO "district" VALUES(29,'SZ','ZURICH',1687);
INSERT INTO "district" VALUES(33,'SZ','SANKT GALLEN',2067);
INSERT INTO "district" VALUES(9,'LU','DIEKIRCH',1164);
INSERT INTO "district" VALUES(25,'AU','STEIERMARK',16630);
INSERT INTO "district" VALUES(38,'AU','SALZBURG',7234);
INSERT INTO "district" VALUES(77,'SZ','TICINO',2768);
INSERT INTO "district" VALUES(15,'EZ','JIHOCESKY',11087);
INSERT INTO "district" VALUES(140,'LO','BRATISLAVA',331);
INSERT INTO "district" VALUES(19,'AU','NIEDEROSTERREICH',19090);
INSERT INTO "district" VALUES(64,'SZ','FRIBOURG',1665);
INSERT INTO "district" VALUES(23,'FR','BOURGOGNE',31971);
INSERT INTO "district" VALUES(201,'HR','DUGI OTOK CROATIA',115);
INSERT INTO "district" VALUES(141,'HU','GYOR-MOSON-SOPRON',3995);
INSERT INTO "district" VALUES(24,'FR','FRANCHE-COMTE',16111);
INSERT INTO "district" VALUES(226,'IT','MOLISE',4189);