2017 Türkiye İl ve İlçeler Veritabanı SQL

2017_il_ilce.sql

CREATE TABLE iller(
il_no int NOT NULL,
isim VARCHAR(50),
PRIMARY KEY (il_no)
);


CREATE TABLE ilceler(
ilce_no int NOT NULL,
isim VARCHAR(50),
il_no int NOT NULL,
CONSTRAINT fk_il_no FOREIGN KEY (il_no)
REFERENCES iller(il_no)
);

INSERT INTO iller VALUES
(1, 'Adana'),
(2, 'Adıyaman'),
(3, 'Afyonkarahisar'),
(4, 'Ağrı'),
(5, 'Amasya'),
(6, 'Ankara'),
(7, 'Antalya'),
(8, 'Artvin'),
(9, 'Aydın'),
(10, 'Balıkesir'),
(11, 'Bilecik'),
(12, 'Bingöl'),
(13, 'Bitlis'),
(14, 'Bolu'),
(15, 'Burdur'),
(16, 'Bursa'),
(17, 'Çanakkale'),
(18, 'Çankırı'),
(19, 'Çorum'),
(20, 'Denizli'),
(21, 'Diyarbakır'),
(22, 'Edirne'),
(23, 'Elâzığ'),
(24, 'Erzincan'),
(25, 'Erzurum'),
(26, 'Eskişehir'),
(27, 'Gaziantep'),
(28, 'Giresun'),
(29, 'Gümüşhane'),
(30, 'Hakkâri'),
(31, 'Hatay'),
(32, 'Isparta'),
(33, 'Mersin'),
(34, 'İstanbul'),
(35, 'İzmir'),
(36, 'Kars'),
(37, 'Kastamonu'),
(38, 'Kayseri'),
(39, 'Kırklareli'),
(40, 'Kırşehir'),
(41, 'Kocaeli'),
(42, 'Konya'),
(43, 'Kütahya'),
(44, 'Malatya'),
(45, 'Manisa'),
(46, 'Kahramanmaraş'),
(47, 'Mardin'),
(48, 'Muğla'),
(49, 'Muş'),
(50, 'Nevşehir'),
(51, 'Niğde'),
(52, 'Ordu'),
(53, 'Rize'),
(54, 'Sakarya'),
(55, 'Samsun'),
(56, 'Siirt'),
(57, 'Sinop'),
(58, 'Sivas'),
(59, 'Tekirdağ'),
(60, 'Tokat'),
(61, 'Trabzon'),
(62, 'Tunceli'),
(63, 'Şanlıurfa'),
(64, 'Uşak'),
(65, 'Van'),
(66, 'Yozgat'),
(67, 'Zonguldak'),
(68, 'Aksaray'),
(69, 'Bayburt'),
(70, 'Karaman'),
(71, 'Kırıkkale'),
(72, 'Batman'),
(73, 'Şırnak'),
(74, 'Bartın'),
(75, 'Ardahan'),
(76, 'Iğdır'),
(77, 'Yalova'),
(78, 'Karabük'),
(79, 'Kilis'),
(80, 'Osmaniye'),
(81, 'Düzce');
 
INSERT INTO ilceler VALUES
(1,'Abana',37),
(2,'Acıgöl',50),
(3,'Acıpayam',20),
(4,'Adaklı',12),
(5,'Adalar',34),
(6,'Adapazarı',54),
(7,'Adıyaman',2),
(8,'Adilcevaz',13),
(9,'Afşin',46),
(10,'Afyonkarahisar',3),
(11,'Ağaçören',68),
(12,'Ağın',23),
(13,'Ağlasun',15),
(14,'Ağlı',37),
(15,'Ağrı',4),
(16,'Ahırlı',42),
(17,'Ahlat',13),
(18,'Ahmetli',45),
(19,'Akçaabat',61),
(20,'Akçadağ',44),
(21,'Akçakale',63),
(22,'Akçakent',40),
(23,'Akçakoca',81),
(24,'Akdağmadeni',66),
(25,'Akdeniz',33),
(26,'Akhisar',45),
(27,'Akıncılar',58),
(28,'Akkışla',38),
(29,'Akkuş',52),
(30,'Akören',42),
(31,'Akpınar',40),
(32,'Aksaray',68),
(33,'Akseki',7),
(34,'Aksu',7),
(35,'Aksu',32),
(36,'Akşehir',42),
(37,'Akyaka',36),
(38,'Akyazı',54),
(39,'Akyurt',6),
(40,'Alaca',19),
(41,'Alacakaya',23),
(42,'Alaçam',55),
(43,'Aladağ',1),
(44,'Alanya',7),
(45,'Alaplı',67),
(46,'Alaşehir',45),
(47,'Aliağa',35),
(48,'Almus',60),
(49,'Alpu',26),
(50,'Altıeylül',10),
(51,'Altındağ',6),
(52,'Altınekin',42),
(53,'Altınordu',52),
(54,'Altınova',77),
(55,'Altınözü',31),
(56,'Altıntaş',43),
(57,'Altınyayla',15),
(58,'Altınyayla',58),
(59,'Altunhisar',51),
(60,'Alucra',28),
(61,'Amasra',74),
(62,'Amasya',5),
(63,'Anamur',33),
(64,'Andırın',46),
(65,'Antakya',31),
(66,'Araban',27),
(67,'Araç',37),
(68,'Araklı',61),
(69,'Aralık',76),
(70,'Arapgir',44),
(71,'Ardahan',75),
(72,'Ardanuç',8),
(73,'Ardeşen',53),
(74,'Arguvan',44),
(75,'Arhavi',8),
(76,'Arıcak',23),
(77,'Arifiye',54),
(78,'Armutlu',77),
(79,'Arnavutköy',34),
(80,'Arpaçay',36),
(81,'Arsin',61),
(82,'Arsuz',31),
(83,'Artova',60),
(84,'Artuklu',47),
(85,'Artvin',8),
(86,'Asarcık',55),
(87,'Aslanapa',43),
(88,'Aşkale',25),
(89,'Atabey',32),
(90,'Atakum',55),
(91,'Ataşehir',34),
(92,'Atkaracalar',18),
(93,'Avanos',50),
(94,'Avcılar',34),
(95,'Ayancık',57),
(96,'Ayaş',6),
(97,'Aybastı',52),
(98,'Aydıncık',33),
(99,'Aydıncık',66),
(100,'Aydıntepe',69);
 
INSERT INTO ilceler VALUES
(101,'Ayrancı',70),
(102,'Ayvacık',17),
(103,'Ayvacık',55),
(104,'Ayvalık',10),
(105,'Azdavay',37),
(106,'Aziziye',25),
(107,'Babadağ',20),
(108,'Babaeski',39),
(109,'Bafra',55),
(110,'Bağcılar',34),
(111,'Bağlar',21),
(112,'Bahçe',80),
(113,'Bahçelievler',34),
(114,'Bahçesaray',65),
(115,'Bahşili',71),
(116,'Bakırköy',34),
(117,'Baklan',20),
(118,'Bala',6),
(119,'Balçova',35),
(120,'Balışeyh',71),
(121,'Balya',10),
(122,'Banaz',64),
(123,'Bandırma',10),
(124,'Bartın',74),
(125,'Baskil',23),
(126,'Başakşehir',34),
(127,'Başçiftlik',60),
(128,'Başiskele',41),
(129,'Başkale',65),
(130,'Başmakçı',3),
(131,'Başyayla',70),
(132,'Batman',72),
(133,'Battalgazi',44),
(134,'Bayat',3),
(135,'Bayat',19),
(136,'Bayburt',69),
(137,'Bayındır',35),
(138,'Baykan',56),
(139,'Bayraklı',35),
(140,'Bayramiç',17),
(141,'Bayramören',18),
(142,'Bayrampaşa',34),
(143,'Bekilli',20),
(144,'Belen',31),
(145,'Bergama',35),
(146,'Besni',2),
(147,'Beşikdüzü',61),
(148,'Beşiktaş',34),
(149,'Beşiri',72),
(150,'Beyağaç',20),
(151,'Beydağ',35),
(152,'Beykoz',34),
(153,'Beylikdüzü',34),
(154,'Beylikova',26),
(155,'Beyoğlu',34),
(156,'Beypazarı',6),
(157,'Beyşehir',42),
(158,'Beytüşşebap',73),
(159,'Biga',17),
(160,'Bigadiç',10),
(161,'Bilecik',11),
(162,'Bingöl',12),
(163,'Birecik',63),
(164,'Bismil',21),
(165,'Bitlis',13),
(166,'Bodrum',48),
(167,'Boğazkale',19),
(168,'Boğazlıyan',66),
(169,'Bolu',14),
(170,'Bolvadin',3),
(171,'Bor',51),
(172,'Borçka',8),
(173,'Bornova',35),
(174,'Boyabat',57),
(175,'Bozcaada',17),
(176,'Bozdoğan',9),
(177,'Bozkır',42),
(178,'Bozkurt',20),
(179,'Bozkurt',37),
(180,'Bozova',63),
(181,'Boztepe',40),
(182,'Bozüyük',11),
(183,'Bozyazı',33),
(184,'Buca',35),
(185,'Bucak',15),
(186,'Buharkent',9),
(187,'Bulancak',28),
(188,'Bulanık',49),
(189,'Buldan',20),
(190,'Burdur',15),
(191,'Burhaniye',10),
(192,'Bünyan',38),
(193,'Büyükçekmece',34),
(194,'Büyükorhan',16),
(195,'Canik',55),
(196,'Ceyhan',1),
(197,'Ceylanpınar',63),
(198,'Cide',37),
(199,'Cihanbeyli',42),
(200,'Cizre',73);
 
INSERT INTO ilceler VALUES
(201,'Cumayeri',81),
(202,'Çağlayancerit',46),
(203,'Çal',20),
(204,'Çaldıran',65),
(205,'Çamardı',51),
(206,'Çamaş',52),
(207,'Çameli',20),
(208,'Çamlıdere',6),
(209,'Çamlıhemşin',53),
(210,'Çamlıyayla',33),
(211,'Çamoluk',28),
(212,'Çan',17),
(213,'Çanakçı',28),
(214,'Çanakkale',17),
(215,'Çandır',66),
(216,'Çankaya',6),
(217,'Çankırı',18),
(218,'Çardak',20),
(219,'Çarşamba',55),
(220,'Çarşıbaşı',61),
(221,'Çat',25),
(222,'Çatak',65),
(223,'Çatalca',34),
(224,'Çatalpınar',52),
(225,'Çatalzeytin',37),
(226,'Çavdarhisar',43),
(227,'Çavdır',15),
(228,'Çay',3),
(229,'Çaybaşı',52),
(230,'Çaycuma',67),
(231,'Çayeli',53),
(232,'Çayıralan',66),
(233,'Çayırlı',24),
(234,'Çayırova',41),
(235,'Çaykara',61),
(236,'Çekerek',66),
(237,'Çekmeköy',34),
(238,'Çelebi',71),
(239,'Çelikhan',2),
(240,'Çeltik',42),
(241,'Çeltikçi',15),
(242,'Çemişgezek',62),
(243,'Çerkeş',18),
(244,'Çerkezköy',59),
(245,'Çermik',21),
(246,'Çeşme',35),
(247,'Çıldır',75),
(248,'Çınar',21),
(249,'Çınarcık',77),
(250,'Çiçekdağı',40),
(251,'Çifteler',26),
(252,'Çiftlik',51),
(253,'Çiftlikköy',77),
(254,'Çiğli',35),
(255,'Çilimli',81),
(256,'Çine',9),
(257,'Çivril',20),
(258,'Çobanlar',3),
(259,'Çorlu',59),
(260,'Çorum',19),
(261,'Çubuk',6),
(262,'Çukurca',30),
(263,'Çukurova',1),
(264,'Çumra',42),
(265,'Çüngüş',21),
(266,'Daday',37),
(267,'Dalaman',48),
(268,'Damal',75),
(269,'Darende',44),
(270,'Dargeçit',47),
(271,'Darıca',41),
(272,'Datça',48),
(273,'Dazkırı',3),
(274,'Defne',31),
(275,'Delice',71),
(276,'Demirci',45),
(277,'Demirköy',39),
(278,'Demirözü',69),
(279,'Demre',7),
(280,'Derbent',42),
(281,'Derebucak',42),
(282,'Dereli',28),
(283,'Derepazarı',53),
(284,'Derik',47),
(285,'Derince',41),
(286,'Derinkuyu',50),
(287,'Dernekpazarı',61),
(288,'Develi',38),
(289,'Devrek',67),
(290,'Devrekani',37),
(291,'Dicle',21),
(292,'Didim',9),
(293,'Digor',36),
(294,'Dikili',35),
(295,'Dikmen',57),
(296,'Dilovası',41),
(297,'Dinar',3),
(298,'Divriği',58),
(299,'Diyadin',4),
(300,'Dodurga',19);
 
INSERT INTO ilceler VALUES
(301,'Doğanhisar',42),
(302,'Doğankent',28),
(303,'Doğanşar',58),
(304,'Doğanşehir',44),
(305,'Doğanyol',44),
(306,'Doğanyurt',37),
(307,'Doğubayazıt',4),
(308,'Domaniç',43),
(309,'Dörtdivan',14),
(310,'Dörtyol',31),
(311,'Döşemealtı',7),
(312,'Dulkadiroğlu',46),
(313,'Dumlupınar',43),
(314,'Durağan',57),
(315,'Dursunbey',10),
(316,'Düzce',81),
(317,'Düziçi',80),
(318,'Düzköy',61),
(319,'Eceabat',17),
(320,'Edirne',22),
(321,'Edremit',10),
(322,'Edremit',65),
(323,'Efeler',9),
(324,'Eflani',78),
(325,'Eğil',21),
(326,'Eğirdir',32),
(327,'Ekinözü',46),
(328,'Elazığ',23),
(329,'Elbeyli',79),
(330,'Elbistan',46),
(331,'Eldivan',18),
(332,'Eleşkirt',4),
(333,'Elmadağ',6),
(334,'Elmalı',7),
(335,'Emet',43),
(336,'Emirdağ',3),
(337,'Emirgazi',42),
(338,'Enez',22),
(339,'Erbaa',60),
(340,'Erciş',65),
(341,'Erdek',10),
(342,'Erdemli',33),
(343,'Ereğli',42),
(344,'Ereğli',67),
(345,'Erenler',54),
(346,'Erfelek',57),
(347,'Ergani',21),
(348,'Ergene',59),
(349,'Ermenek',70),
(350,'Eruh',56),
(351,'Erzin',31),
(352,'Erzincan',24),
(353,'Esenler',34),
(354,'Esenyurt',34),
(355,'Eskil',68),
(356,'Eskipazar',78),
(357,'Espiye',28),
(358,'Eşme',64),
(359,'Etimesgut',6),
(360,'Evciler',3),
(361,'Evren',6),
(362,'Eynesil',28),
(363,'Eyüp',34),
(364,'Eyyübiye',63),
(365,'Ezine',17),
(366,'Fatih',34),
(367,'Fatsa',52),
(368,'Feke',1),
(369,'Felahiye',38),
(370,'Ferizli',54),
(371,'Fethiye',48),
(372,'Fındıklı',53),
(373,'Finike',7),
(374,'Foça',35),
(375,'Gaziemir',35),
(376,'Gaziosmanpaşa',34),
(377,'Gazipaşa',7),
(378,'Gebze',41),
(379,'Gediz',43),
(380,'Gelendost',32),
(381,'Gelibolu',17),
(382,'Gemerek',58),
(383,'Gemlik',16),
(384,'Genç',12),
(385,'Gercüş',72),
(386,'Gerede',14),
(387,'Gerger',2),
(388,'Germencik',9),
(389,'Gerze',57),
(390,'Gevaş',65),
(391,'Geyve',54),
(392,'Giresun',28),
(393,'Gökçeada',17),
(394,'Gökçebey',67),
(395,'Göksun',46),
(396,'Gölbaşı',2),
(397,'Gölbaşı',6),
(398,'Gölcük',41),
(399,'Göle',75),
(400,'Gölhisar',15);
 
INSERT INTO ilceler VALUES
(401,'Gölköy',52),
(402,'Gölmarmara',45),
(403,'Gölova',58),
(404,'Gölpazarı',11),
(405,'Gölyaka',81),
(406,'Gömeç',10),
(407,'Gönen',10),
(408,'Gönen',32),
(409,'Gördes',45),
(410,'Görele',28),
(411,'Göynücek',5),
(412,'Göynük',14),
(413,'Güce',28),
(414,'Güçlükonak',73),
(415,'Güdül',6),
(416,'Gülağaç',68),
(417,'Gülnar',33),
(418,'Gülşehir',50),
(419,'Gülyalı',52),
(420,'Gümüşhacıköy',5),
(421,'Gümüşhane',29),
(422,'Gümüşova',81),
(423,'Gündoğmuş',7),
(424,'Güney',20),
(425,'Güneysınır',42),
(426,'Güneysu',53),
(427,'Güngören',34),
(428,'Günyüzü',26),
(429,'Gürgentepe',52),
(430,'Güroymak',13),
(431,'Gürpınar',65),
(432,'Gürsu',16),
(433,'Gürün',58),
(434,'Güzelbahçe',35),
(435,'Güzelyurt',68),
(436,'Hacıbektaş',50),
(437,'Hacılar',38),
(438,'Hadim',42),
(439,'Hafik',58),
(440,'Hakkâri',30),
(441,'Halfeti',63),
(442,'Haliliye',63),
(443,'Halkapınar',42),
(444,'Hamamözü',5),
(445,'Hamur',4),
(446,'Han',26),
(447,'Hanak',75),
(448,'Hani',21),
(449,'Hanönü',37),
(450,'Harmancık',16),
(451,'Harran',63),
(452,'Hasanbeyli',80),
(453,'Hasankeyf',72),
(454,'Hasköy',49),
(455,'Hassa',31),
(456,'Havran',10),
(457,'Havsa',22),
(458,'Havza',55),
(459,'Haymana',6),
(460,'Hayrabolu',59),
(461,'Hayrat',61),
(462,'Hazro',21),
(463,'Hekimhan',44),
(464,'Hemşin',53),
(465,'Hendek',54),
(466,'Hınıs',25),
(467,'Hilvan',63),
(468,'Hisarcık',43),
(469,'Hizan',13),
(470,'Hocalar',3),
(471,'Honaz',20),
(472,'Hopa',8),
(473,'Horasan',25),
(474,'Hozat',62),
(475,'Hüyük',42),
(476,'Iğdır',76),
(477,'Ilgaz',18),
(478,'Ilgın',42),
(479,'Isparta',32),
(480,'İbradı',7),
(481,'İdil',73),
(482,'İhsangazi',37),
(483,'İhsaniye',3),
(484,'İkizce',52),
(485,'İkizdere',53),
(486,'İliç',24),
(487,'İlkadım',55),
(488,'İmamoğlu',1),
(489,'İmranlı',58),
(490,'İncesu',38),
(491,'İncirliova',9),
(492,'İnebolu',37),
(493,'İnegöl',16),
(494,'İnhisar',11),
(495,'İnönü',26),
(496,'İpekyolu',65),
(497,'İpsala',22),
(498,'İscehisar',3),
(499,'İskenderun',31),
(500,'İskilip',19);
 
INSERT INTO ilceler VALUES
(501,'İslahiye',27),
(502,'İspir',25),
(503,'İvrindi',10),
(504,'İyidere',53),
(505,'İzmit',41),
(506,'İznik',16),
(507,'Kabadüz',52),
(508,'Kabataş',52),
(509,'Kadıköy',34),
(510,'Kadınhanı',42),
(511,'Kadışehri',66),
(512,'Kadirli',80),
(513,'Kağıthane',34),
(514,'Kağızman',36),
(515,'Kahta',2),
(516,'Kale',20),
(517,'Kale',44),
(518,'Kalecik',6),
(519,'Kalkandere',53),
(520,'Kaman',40),
(521,'Kandıra',41),
(522,'Kangal',58),
(523,'Kapaklı',59),
(524,'Karabağlar',35),
(525,'Karaburun',35),
(526,'Karabük',78),
(527,'Karacabey',16),
(528,'Karacasu',9),
(529,'Karaçoban',25),
(530,'Karahallı',64),
(531,'Karaisalı',1),
(532,'Karakeçili',71),
(533,'Karakoçan',23),
(534,'Karakoyunlu',76),
(535,'Karaköprü',63),
(536,'Karaman',70),
(537,'Karamanlı',15),
(538,'Karamürsel',41),
(539,'Karapınar',42),
(540,'Karapürçek',54),
(541,'Karasu',54),
(542,'Karataş',1),
(543,'Karatay',42),
(544,'Karayazı',25),
(545,'Karesi',10),
(546,'Kargı',19),
(547,'Karkamış',27),
(548,'Karlıova',12),
(549,'Karpuzlu',9),
(550,'Kars',36),
(551,'Karşıyaka',35),
(552,'Kartal',34),
(553,'Kartepe',41),
(554,'Kastamonu',37),
(555,'Kaş',7),
(556,'Kavak',55),
(557,'Kavaklıdere',48),
(558,'Kayapınar',21),
(559,'Kaynarca',54),
(560,'Kaynaşlı',81),
(561,'Kazan',6),
(562,'Kazımkarabekir',70),
(563,'Keban',23),
(564,'Keçiborlu',32),
(565,'Keçiören',6),
(566,'Keles',16),
(567,'Kelkit',29),
(568,'Kemah',24),
(569,'Kemaliye',24),
(570,'Kemalpaşa',35),
(571,'Kemer',7),
(572,'Kemer',15),
(573,'Kepez',7),
(574,'Kepsut',10),
(575,'Keskin',71),
(576,'Kestel',16),
(577,'Keşan',22),
(578,'Keşap',28),
(579,'Kıbrıscık',14),
(580,'Kınık',35),
(581,'Kırıkhan',31),
(582,'Kırıkkale',71),
(583,'Kırkağaç',45),
(584,'Kırklareli',39),
(585,'Kırşehir',40),
(586,'Kızılcahamam',6),
(587,'Kızılırmak',18),
(588,'Kızılören',3),
(589,'Kızıltepe',47),
(590,'Kiğı',12),
(591,'Kilimli',67),
(592,'Kilis',79),
(593,'Kiraz',35),
(594,'Kocaali',54),
(595,'Kocaköy',21),
(596,'Kocasinan',38),
(597,'Koçarlı',9),
(598,'Kofçaz',39),
(599,'Konak',35),
(600,'Konyaaltı',7);
 
INSERT INTO ilceler VALUES
(601,'Korgan',52),
(602,'Korgun',18),
(603,'Korkut',49),
(604,'Korkuteli',7),
(605,'Kovancılar',23),
(606,'Koyulhisar',58),
(607,'Kozaklı',50),
(608,'Kozan',1),
(609,'Kozlu',67),
(610,'Kozluk',72),
(611,'Köprübaşı',45),
(612,'Köprübaşı',61),
(613,'Köprüköy',25),
(614,'Körfez',41),
(615,'Köse',29),
(616,'Köşk',9),
(617,'Köyceğiz',48),
(618,'Kula',45),
(619,'Kulp',21),
(620,'Kulu',42),
(621,'Kuluncak',44),
(622,'Kumlu',31),
(623,'Kumluca',7),
(624,'Kumru',52),
(625,'Kurşunlu',18),
(626,'Kurtalan',56),
(627,'Kurucaşile',74),
(628,'Kuşadası',9),
(629,'Kuyucak',9),
(630,'Küçükçekmece',34),
(631,'Küre',37),
(632,'Kürtün',29),
(633,'Kütahya',43),
(634,'Laçin',19),
(635,'Ladik',55),
(636,'Lalapaşa',22),
(637,'Lapseki',17),
(638,'Lice',21),
(639,'Lüleburgaz',39),
(640,'Maçka',61),
(641,'Maden',23),
(642,'Mahmudiye',26),
(643,'Malazgirt',49),
(644,'Malkara',59),
(645,'Maltepe',34),
(646,'Mamak',6),
(647,'Manavgat',7),
(648,'Manyas',10),
(649,'Marmara',10),
(650,'Marmaraereğlisi',59),
(651,'Marmaris',48),
(652,'Mazgirt',62),
(653,'Mazıdağı',47),
(654,'Mecitözü',19),
(655,'Melikgazi',38),
(656,'Menderes',35),
(657,'Menemen',35),
(658,'Mengen',14),
(659,'Menteşe',48),
(660,'Meram',42),
(661,'Meriç',22),
(662,'Merkezefendi',20),
(663,'Merzifon',5),
(664,'Mesudiye',52),
(665,'Mezitli',33),
(666,'Midyat',47),
(667,'Mihalgazi',26),
(668,'Mihalıççık',26),
(669,'Milas',48),
(670,'Mucur',40),
(671,'Mudanya',16),
(672,'Mudurnu',14),
(673,'Muradiye',65),
(674,'Muratlı',59),
(675,'Muratpaşa',7),
(676,'Murgul',8),
(677,'Musabeyli',79),
(678,'Mustafakemalpaşa',16),
(679,'Muş',49),
(680,'Mut',33),
(681,'Mutki',13),
(682,'Nallıhan',6),
(683,'Narlıdere',35),
(684,'Narman',25),
(685,'Nazımiye',62),
(686,'Nazilli',9),
(687,'Nevşehir',50),
(688,'Niğde',51),
(689,'Niksar',60),
(690,'Nilüfer',16),
(691,'Nizip',27),
(692,'Nurdağı',27),
(693,'Nurhak',46),
(694,'Nusaybin',47),
(695,'Odunpazarı',26),
(696,'Of',61),
(697,'Oğuzeli',27),
(698,'Oğuzlar',19),
(699,'Oltu',25),
(700,'Olur',25);
 
INSERT INTO ilceler VALUES
(701,'Ondokuzmayıs',55),
(702,'Onikişubat',46),
(703,'Orhaneli',16),
(704,'Orhangazi',16),
(705,'Orta',18),
(706,'Ortaca',48),
(707,'Ortahisar',61),
(708,'Ortaköy',68),
(709,'Ortaköy',19),
(710,'Osmancık',19),
(711,'Osmaneli',11),
(712,'Osmangazi',16),
(713,'Osmaniye',80),
(714,'Otlukbeli',24),
(715,'Ovacık',78),
(716,'Ovacık',62),
(717,'Ödemiş',35),
(718,'Ömerli',47),
(719,'Özalp',65),
(720,'Özvatan',38),
(721,'Palandöken',25),
(722,'Palu',23),
(723,'Pamukkale',20),
(724,'Pamukova',54),
(725,'Pasinler',25),
(726,'Patnos',4),
(727,'Payas',31),
(728,'Pazar',53),
(729,'Pazar',60),
(730,'Pazarcık',46),
(731,'Pazarlar',43),
(732,'Pazaryeri',11),
(733,'Pazaryolu',25),
(734,'Pehlivanköy',39),
(735,'Pendik',34),
(736,'Perşembe',52),
(737,'Pertek',62),
(738,'Pervari',56),
(739,'Pınarbaşı',37),
(740,'Pınarbaşı',38),
(741,'Pınarhisar',39),
(742,'Piraziz',28),
(743,'Polateli',79),
(744,'Polatlı',6),
(745,'Posof',75),
(746,'Pozantı',1),
(747,'Pursaklar',6),
(748,'Pülümür',62),
(749,'Pütürge',44),
(750,'Refahiye',24),
(751,'Reşadiye',60),
(752,'Reyhanlı',31),
(753,'Rize',53),
(754,'Safranbolu',78),
(755,'Saimbeyli',1),
(756,'Salıpazarı',55),
(757,'Salihli',45),
(758,'Samandağ',31),
(759,'Samsat',2),
(760,'Sancaktepe',34),
(761,'Sandıklı',3),
(762,'Sapanca',54),
(763,'Saray',59),
(764,'Saray',65),
(765,'Saraydüzü',57),
(766,'Saraykent',66),
(767,'Sarayköy',20),
(768,'Sarayönü',42),
(769,'Sarıcakaya',26),
(770,'Sarıçam',1),
(771,'Sarıgöl',45),
(772,'Sarıkamış',36),
(773,'Sarıkaya',66),
(774,'Sarıoğlan',38),
(775,'Sarıveliler',70),
(776,'Sarıyahşi',68),
(777,'Sarıyer',34),
(778,'Sarız',38),
(779,'Saruhanlı',45),
(780,'Sason',72),
(781,'Savaştepe',10),
(782,'Savur',47),
(783,'Seben',14),
(784,'Seferihisar',35),
(785,'Selçuk',35),
(786,'Selçuklu',42),
(787,'Selendi',45),
(788,'Selim',36),
(789,'Senirkent',32),
(790,'Serdivan',54),
(791,'Serik',7),
(792,'Serinhisar',20),
(793,'Seydikemer',48),
(794,'Seydiler',37),
(795,'Seydişehir',42),
(796,'Seyhan',1),
(797,'Seyitgazi',26),
(798,'Sındırgı',10),
(799,'Siirt',56),
(800,'Silifke',33);
 
INSERT INTO ilceler VALUES
(801,'Silivri',34),
(802,'Silopi',73),
(803,'Silvan',21),
(804,'Simav',43),
(805,'Sinanpaşa',3),
(806,'Sincan',6),
(807,'Sincik',2),
(808,'Sinop',57),
(809,'Sivas',58),
(810,'Sivaslı',64),
(811,'Siverek',63),
(812,'Sivrice',23),
(813,'Sivrihisar',26),
(814,'Solhan',12),
(815,'Soma',45),
(816,'Sorgun',66),
(817,'Söğüt',11),
(818,'Söğütlü',54),
(819,'Söke',9),
(820,'Sulakyurt',71),
(821,'Sultanbeyli',34),
(822,'Sultandağı',3),
(823,'Sultangazi',34),
(824,'Sultanhisar',9),
(825,'Suluova',5),
(826,'Sulusaray',60),
(827,'Sumbas',80),
(828,'Sungurlu',19),
(829,'Sur',21),
(830,'Suruç',63),
(831,'Susurluk',10),
(832,'Susuz',36),
(833,'Suşehri',58),
(834,'Süleymanpaşa',59),
(835,'Süloğlu',22),
(836,'Sürmene',61),
(837,'Sütçüler',32),
(838,'Şabanözü',18),
(839,'Şahinbey',27),
(840,'Şalpazarı',61),
(841,'Şaphane',43),
(842,'Şarkışla',58),
(843,'Şarkikaraağaç',32),
(844,'Şarköy',59),
(845,'Şavşat',8),
(846,'Şebinkarahisar',28),
(847,'Şefaatli',66),
(848,'Şehitkamil',27),
(849,'Şehzadeler',45),
(850,'Şemdinli',30),
(851,'Şenkaya',25),
(852,'Şenpazar',37),
(853,'Şereflikoçhisar',6),
(854,'Şırnak',73),
(855,'Şile',34),
(856,'Şiran',29),
(857,'Şirvan',56),
(858,'Şişli',34),
(859,'Şuhut',3),
(860,'Talas',38),
(861,'Taraklı',54),
(862,'Tarsus',33),
(863,'Taşkent',42),
(864,'Taşköprü',37),
(865,'Taşlıçay',4),
(866,'Taşova',5),
(867,'Tatvan',13),
(868,'Tavas',20),
(869,'Tavşanlı',43),
(870,'Tefenni',15),
(871,'Tekkeköy',55),
(872,'Tekman',25),
(873,'Tepebaşı',26),
(874,'Tercan',24),
(875,'Termal',77),
(876,'Terme',55),
(877,'Tillo',56),
(878,'Tire',35),
(879,'Tirebolu',28),
(880,'Tokat',60),
(881,'Tomarza',38),
(882,'Tonya',61),
(883,'Toprakkale',80),
(884,'Torbalı',35),
(885,'Toroslar',33),
(886,'Tortum',25),
(887,'Torul',29),
(888,'Tosya',37),
(889,'Tufanbeyli',1),
(890,'Tunceli',62),
(891,'Turgutlu',45),
(892,'Turhal',60),
(893,'Tuşba',65),
(894,'Tut',2),
(895,'Tutak',4),
(896,'Tuzla',34),
(897,'Tuzluca',76),
(898,'Tuzlukçu',42),
(899,'Türkeli',57),
(900,'Türkoğlu',46);
 
INSERT INTO ilceler VALUES
(901,'Uğurludağ',19),
(902,'Ula',48),
(903,'Ulaş',58),
(904,'Ulubey',52),
(905,'Ulubey',64),
(906,'Uluborlu',32),
(907,'Uludere',73),
(908,'Ulukışla',51),
(909,'Ulus',74),
(910,'Urla',35),
(911,'Uşak',64),
(912,'Uzundere',25),
(913,'Uzunköprü',22),
(914,'Ümraniye',34),
(915,'Ünye',52),
(916,'Ürgüp',50),
(917,'Üsküdar',34),
(918,'Üzümlü',24),
(919,'Vakfıkebir',61),
(920,'Varto',49),
(921,'Vezirköprü',55),
(922,'Viranşehir',63),
(923,'Vize',39),
(924,'Yağlıdere',28),
(925,'Yahşihan',71),
(926,'Yahyalı',38),
(927,'Yakakent',55),
(928,'Yakutiye',25),
(929,'Yalıhüyük',42),
(930,'Yalova',77),
(931,'Yalvaç',32),
(932,'Yapraklı',18),
(933,'Yatağan',48),
(934,'Yavuzeli',27),
(935,'Yayladağı',31),
(936,'Yayladere',12),
(937,'Yazıhan',44),
(938,'Yedisu',12),
(939,'Yenice',17),
(940,'Yenice',78),
(941,'Yeniçağa',14),
(942,'Yenifakılı',66),
(943,'Yenimahalle',6),
(944,'Yenipazar',9),
(945,'Yenipazar',11),
(946,'Yenişarbademli',32),
(947,'Yenişehir',16),
(948,'Yenişehir',21),
(949,'Yenişehir',33),
(950,'Yerköy',66),
(951,'Yeşilhisar',38),
(952,'Yeşilli',47),
(953,'Yeşilova',15),
(954,'Yeşilyurt',44),
(955,'Yeşilyurt',60),
(956,'Yığılca',81),
(957,'Yıldırım',16),
(958,'Yıldızeli',58),
(959,'Yomra',61),
(960,'Yozgat',66),
(961,'Yumurtalık',1),
(962,'Yunak',42),
(963,'Yunusemre',45),
(964,'Yusufeli',8),
(965,'Yüksekova',30),
(966,'Yüreğir',1),
(967,'Zara',58),
(968,'Zeytinburnu',34),
(969,'Zile',60),
(970,'Zonguldak',67);