States of Turkey

states.sql

/*
Navicat SQL Server Data Transfer

Source Server         : SqlServer_MesutTalebi
Source Server Version : 105000

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2014-07-17 16:11:01
*/


-- ----------------------------
-- Table structure for [dbo].[State]
-- ----------------------------
DROP TABLE [dbo].[State]
GO
CREATE TABLE [dbo].[State] (
[Id] int NOT NULL ,
[CityId] int NOT NULL ,
[Name] nvarchar(30) NOT NULL 
)


GO

-- ----------------------------
-- Records of State
-- ----------------------------
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1101', N'37', N'Abana');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1102', N'20', N'Acıpayam');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1103', N'34', N'Adalar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1104', N'1', N'Seyhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1105', N'2', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1106', N'13', N'Adilcevaz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1107', N'46', N'Afşin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1108', N'3', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1109', N'15', N'Ağlasun');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1110', N'23', N'Ağın');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1111', N'4', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1112', N'13', N'Ahlat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1113', N'61', N'Akçaabat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1114', N'44', N'Akçadağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1115', N'63', N'Akçakale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1116', N'81', N'Akçakoca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1117', N'66', N'Akdağmadeni');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1118', N'45', N'Akhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1119', N'52', N'Akkuş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1120', N'68', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1121', N'7', N'Akseki');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1122', N'42', N'Akşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1123', N'54', N'Akyazı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1124', N'19', N'Alaca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1125', N'55', N'Alaçam');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1126', N'7', N'Alanya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1127', N'45', N'Alaşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1128', N'35', N'Aliağa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1129', N'60', N'Almus');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1130', N'6', N'Altındağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1131', N'31', N'Altınözü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1132', N'43', N'Altıntaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1133', N'28', N'Alucra');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1134', N'5', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1135', N'33', N'Anamur');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1136', N'46', N'Andırın');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1139', N'27', N'Araban');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1140', N'37', N'Araç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1141', N'61', N'Araklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1142', N'76', N'Aralık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1143', N'44', N'Arapgir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1144', N'75', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1145', N'8', N'Ardanuç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1146', N'53', N'Ardeşen');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1147', N'8', N'Arhavi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1148', N'44', N'Arguvan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1149', N'36', N'Arpaçay');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1150', N'61', N'Arsin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1151', N'60', N'Artova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1152', N'8', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1153', N'25', N'Aşkale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1154', N'32', N'Atabey');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1155', N'50', N'Avanos');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1156', N'57', N'Ayancık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1157', N'6', N'Ayaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1158', N'52', N'Aybastı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1160', N'17', N'Ayvacık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1161', N'10', N'Ayvalık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1162', N'37', N'Azdavay');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1163', N'39', N'Babaeski');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1164', N'55', N'Bafra');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1165', N'80', N'Bahçe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1166', N'34', N'Bakırköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1167', N'6', N'Bala');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1169', N'10', N'Balya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1170', N'64', N'Banaz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1171', N'10', N'Bandırma');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1172', N'74', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1173', N'23', N'Baskil');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1174', N'72', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1175', N'65', N'Başkale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1176', N'69', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1177', N'19', N'Bayat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1178', N'35', N'Bayındır');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1179', N'56', N'Baykan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1180', N'17', N'Bayramiç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1181', N'35', N'Bergama');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1182', N'2', N'Besni');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1183', N'34', N'Beşiktaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1184', N'72', N'Beşiri');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1185', N'34', N'Beykoz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1186', N'34', N'Beyoğlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1187', N'6', N'Beypazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1188', N'42', N'Beyşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1189', N'73', N'Beytüşşebap');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1190', N'17', N'Biga');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1191', N'10', N'Bigadiç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1192', N'11', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1193', N'12', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1194', N'63', N'Birecik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1195', N'21', N'Bismil');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1196', N'13', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1197', N'48', N'Bodrum');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1198', N'66', N'Boğazlıyan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1199', N'14', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1200', N'3', N'Bolvadin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1201', N'51', N'Bor');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1202', N'8', N'Borçka');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1203', N'35', N'Bornova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1204', N'57', N'Boyabat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1205', N'17', N'Bozcaada');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1206', N'9', N'Bozdoğan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1207', N'42', N'Bozkır');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1208', N'37', N'Bozkurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1209', N'63', N'Bozova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1210', N'11', N'Bozüyük');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1211', N'15', N'Bucak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1212', N'28', N'Bulancak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1213', N'49', N'Bulanık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1214', N'20', N'Buldan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1215', N'15', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1216', N'10', N'Burhaniye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1218', N'38', N'Bünyan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1219', N'1', N'Ceyhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1220', N'63', N'Ceylanpınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1221', N'37', N'Cide');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1222', N'42', N'Cihanbeyli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1223', N'73', N'Cizre');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1224', N'20', N'Çal');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1225', N'51', N'Çamardı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1226', N'20', N'Çameli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1227', N'6', N'Çamlıdere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1228', N'53', N'Çamlıhemşin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1229', N'17', N'Çan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1230', N'17', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1231', N'6', N'Çankaya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1232', N'18', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1233', N'20', N'Çardak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1234', N'55', N'Çarşamba');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1235', N'25', N'Çat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1236', N'65', N'Çatak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1237', N'34', N'Çatalca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1238', N'37', N'Çatalzeytin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1239', N'3', N'Çay');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1240', N'67', N'Çaycuma');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1241', N'53', N'Çayeli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1242', N'66', N'Çayıralan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1243', N'24', N'Çayırlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1244', N'61', N'Çaykara');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1245', N'66', N'Çekerek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1246', N'2', N'Çelikhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1247', N'62', N'Çemişgezek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1248', N'18', N'Çerkeş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1249', N'21', N'Çermik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1250', N'59', N'Çerkezköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1251', N'35', N'Çeşme');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1252', N'75', N'Çıldır');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1253', N'21', N'Çınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1254', N'40', N'Çiçekdağı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1255', N'26', N'Çifteler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1256', N'9', N'Çine');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1257', N'20', N'Çivril');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1258', N'59', N'Çorlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1259', N'19', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1260', N'6', N'Çubuk');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1261', N'30', N'Çukurca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1262', N'42', N'Çumra');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1263', N'21', N'Çüngüş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1264', N'37', N'Daday');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1265', N'44', N'Darende');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1266', N'48', N'Datça');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1267', N'3', N'Dazkırı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1268', N'71', N'Delice');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1269', N'45', N'Demirci');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1270', N'39', N'Demirköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1272', N'28', N'Dereli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1273', N'47', N'Derik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1274', N'50', N'Derinkuyu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1275', N'38', N'Develi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1276', N'67', N'Devrek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1277', N'37', N'Devrekani');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1278', N'21', N'Dicle');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1279', N'36', N'Digor');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1280', N'35', N'Dikili');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1281', N'3', N'Dinar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1282', N'58', N'Divriği');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1283', N'4', N'Diyadin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1285', N'42', N'Doğanhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1286', N'44', N'Doğanşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1287', N'4', N'Doğubayazıt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1288', N'43', N'Domaniç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1289', N'31', N'Dörtyol');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1290', N'57', N'Durağan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1291', N'10', N'Dursunbey');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1292', N'81', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1293', N'17', N'Eceabat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1294', N'10', N'Edremit');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1295', N'22', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1296', N'78', N'Eflani');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1297', N'32', N'Eğirdir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1298', N'23', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1299', N'46', N'Elbistan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1300', N'18', N'Eldivan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1301', N'4', N'Eleşkirt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1302', N'6', N'Elmadağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1303', N'7', N'Elmalı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1304', N'43', N'Emet');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1306', N'3', N'Emirdağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1307', N'22', N'Enez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1308', N'60', N'Erbaa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1309', N'65', N'Erciş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1310', N'10', N'Erdek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1311', N'33', N'Erdemli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1312', N'42', N'Ereğli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1313', N'67', N'Ereğli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1314', N'57', N'Erfelek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1315', N'21', N'Ergani');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1316', N'70', N'Ermenek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1317', N'56', N'Eruh');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1318', N'24', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1320', N'28', N'Espiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1321', N'78', N'Eskipazar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1323', N'64', N'Eşme');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1324', N'28', N'Eynesil');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1325', N'34', N'Eyüp');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1326', N'17', N'Ezine');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1327', N'34', N'Fatih');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1328', N'52', N'Fatsa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1329', N'1', N'Feke');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1330', N'38', N'Felahiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1331', N'48', N'Fethiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1332', N'53', N'Fındıklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1333', N'7', N'Finike');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1334', N'35', N'Foça');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1336', N'34', N'Gaziosmanpaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1337', N'7', N'Gazipaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1338', N'41', N'Gebze');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1339', N'43', N'Gediz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1340', N'17', N'Gelibolu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1341', N'32', N'Gelendost');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1342', N'58', N'Gemerek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1343', N'16', N'Gemlik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1344', N'12', N'Genç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1345', N'72', N'Gercüş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1346', N'14', N'Gerede');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1347', N'2', N'Gerger');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1348', N'9', N'Germencik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1349', N'57', N'Gerze');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1350', N'65', N'Gevaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1351', N'54', N'Geyve');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1352', N'28', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1353', N'46', N'Göksun');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1354', N'2', N'Gölbaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1355', N'41', N'Gölcük');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1356', N'75', N'Göle');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1357', N'15', N'Gölhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1358', N'52', N'Gölköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1359', N'11', N'Gölpazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1360', N'10', N'Gönen');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1361', N'28', N'Görele');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1362', N'45', N'Gördes');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1363', N'5', N'Göynücek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1364', N'14', N'Göynük');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1365', N'6', N'Güdül');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1366', N'33', N'Gülnar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1367', N'50', N'Gülşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1368', N'5', N'Gümüşhacıköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1369', N'29', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1370', N'7', N'Gündoğmuş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1371', N'20', N'Güney');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1372', N'65', N'Gürpınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1373', N'58', N'Gürün');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1374', N'50', N'Hacıbektaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1375', N'42', N'Hadim');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1376', N'58', N'Hafik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1377', N'30', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1378', N'63', N'Halfeti');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1379', N'4', N'Hamur');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1380', N'75', N'Hanak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1381', N'21', N'Hani');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1382', N'31', N'Hassa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1384', N'10', N'Havran');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1385', N'22', N'Havsa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1386', N'55', N'Havza');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1387', N'6', N'Haymana');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1388', N'59', N'Hayrabolu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1389', N'21', N'Hazro');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1390', N'44', N'Hekimhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1391', N'54', N'Hendek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1392', N'25', N'Hınıs');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1393', N'63', N'Hilvan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1394', N'13', N'Hizan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1395', N'8', N'Hopa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1396', N'25', N'Horasan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1397', N'62', N'Hozat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1398', N'76', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1399', N'18', N'Ilgaz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1400', N'42', N'Ilgın');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1401', N'32', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1403', N'73', N'İdil');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1404', N'3', N'İhsaniye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1405', N'53', N'İkizdere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1406', N'24', N'İliç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1407', N'58', N'İmranlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1408', N'17', N'Gökçeada');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1409', N'38', N'İncesu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1410', N'37', N'İnebolu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1411', N'16', N'İnegöl');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1412', N'22', N'İpsala');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1413', N'31', N'İskenderun');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1414', N'19', N'İskilip');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1415', N'27', N'İslahiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1416', N'25', N'İspir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1418', N'10', N'İvrindi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1420', N'16', N'İznik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1421', N'34', N'Kadıköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1422', N'42', N'Kadınhanı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1423', N'80', N'Kadirli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1424', N'36', N'Kağızman');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1425', N'2', N'Kahta');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1426', N'20', N'Kale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1427', N'6', N'Kalecik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1428', N'53', N'Kalkandere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1429', N'40', N'Kaman');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1430', N'41', N'Kandıra');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1431', N'58', N'Kangal');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1432', N'35', N'Karaburun');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1433', N'78', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1434', N'16', N'Karacabey');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1435', N'9', N'Karacasu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1436', N'64', N'Karahallı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1437', N'1', N'Karaisalı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1438', N'23', N'Karakoçan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1439', N'70', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1440', N'41', N'Karamürsel');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1441', N'42', N'Karapınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1442', N'54', N'Karasu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1443', N'1', N'Karataş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1444', N'25', N'Karayazı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1445', N'19', N'Kargı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1446', N'12', N'Karlıova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1447', N'36', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1448', N'35', N'Karşıyaka');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1449', N'34', N'Kartal');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1450', N'37', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1451', N'7', N'Kaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1452', N'55', N'Kavak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1453', N'54', N'Kaynarca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1455', N'23', N'Keban');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1456', N'32', N'Keçiborlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1457', N'16', N'Keles');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1458', N'29', N'Kelkit');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1459', N'24', N'Kemah');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1460', N'24', N'Kemaliye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1461', N'35', N'Kemalpaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1462', N'10', N'Kepsut');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1463', N'71', N'Keskin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1464', N'22', N'Keşan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1465', N'28', N'Keşap');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1466', N'14', N'Kıbrıscık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1467', N'35', N'Kınık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1468', N'31', N'Kırıkhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1469', N'71', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1470', N'45', N'Kırkağaç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1471', N'39', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1472', N'40', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1473', N'6', N'Kızılcahamam');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1474', N'47', N'Kızıltepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1475', N'12', N'Kiğı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1476', N'79', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1477', N'35', N'Kiraz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1479', N'9', N'Koçarlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1480', N'39', N'Kofçaz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1482', N'52', N'Korgan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1483', N'7', N'Korkuteli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1484', N'58', N'Koyulhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1485', N'50', N'Kozaklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1486', N'1', N'Kozan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1487', N'72', N'Kozluk');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1488', N'48', N'Köyceğiz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1489', N'45', N'Kula');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1490', N'21', N'Kulp');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1491', N'42', N'Kulu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1492', N'7', N'Kumluca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1493', N'52', N'Kumru');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1494', N'18', N'Kurşunlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1495', N'56', N'Kurtalan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1496', N'74', N'Kurucaşile');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1497', N'9', N'Kuşadası');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1498', N'9', N'Kuyucak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1499', N'37', N'Küre');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1500', N'43', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1501', N'55', N'Ladik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1502', N'22', N'Lalapaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1503', N'17', N'Lapseki');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1504', N'21', N'Lice');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1505', N'39', N'Lüleburgaz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1506', N'23', N'Maden');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1507', N'61', N'Maçka');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1508', N'26', N'Mahmudiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1510', N'49', N'Malazgirt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1511', N'59', N'Malkara');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1512', N'7', N'Manavgat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1514', N'10', N'Manyas');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1517', N'48', N'Marmaris');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1518', N'62', N'Mazgirt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1519', N'47', N'Mazıdağı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1520', N'19', N'Mecitözü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1521', N'35', N'Menemen');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1522', N'14', N'Mengen');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1523', N'22', N'Meriç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1524', N'5', N'Merzifon');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1525', N'52', N'Mesudiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1526', N'47', N'Midyat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1527', N'26', N'Mihalıççık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1528', N'48', N'Milas');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1529', N'40', N'Mucur');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1530', N'16', N'Mudanya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1531', N'14', N'Mudurnu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1533', N'65', N'Muradiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1534', N'49', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1535', N'16', N'Mustafakemalpaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1536', N'33', N'Mut');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1537', N'13', N'Mutki');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1538', N'59', N'Muratlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1539', N'6', N'Nallıhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1540', N'25', N'Narman');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1541', N'62', N'Nazımiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1542', N'9', N'Nazilli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1543', N'50', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1544', N'51', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1545', N'60', N'Niksar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1546', N'27', N'Nizip');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1547', N'47', N'Nusaybin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1548', N'61', N'Of');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1549', N'27', N'Oğuzeli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1550', N'25', N'Oltu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1551', N'25', N'Olur');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1553', N'16', N'Orhaneli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1554', N'16', N'Orhangazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1555', N'18', N'Orta');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1556', N'19', N'Ortaköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1557', N'68', N'Ortaköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1558', N'19', N'Osmancık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1559', N'11', N'Osmaneli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1560', N'80', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1561', N'78', N'Ovacık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1562', N'62', N'Ovacık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1563', N'35', N'Ödemiş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1564', N'47', N'Ömerli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1565', N'65', N'Özalp');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1566', N'23', N'Palu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1567', N'25', N'Pasinler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1568', N'4', N'Patnos');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1569', N'53', N'Pazar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1570', N'46', N'Pazarcık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1571', N'11', N'Pazaryeri');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1572', N'39', N'Pehlivanköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1573', N'52', N'Perşembe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1574', N'62', N'Pertek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1575', N'56', N'Pervari');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1576', N'38', N'Pınarbaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1577', N'39', N'Pınarhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1578', N'6', N'Polatlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1579', N'75', N'Posof');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1580', N'1', N'Pozantı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1581', N'62', N'Pülümür');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1582', N'44', N'Pütürge');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1583', N'24', N'Refahiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1584', N'60', N'Reşadiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1585', N'31', N'Reyhanlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1586', N'53', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1587', N'78', N'Safranbolu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1588', N'1', N'Saimbeyli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1590', N'45', N'Salihli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1591', N'31', N'Samandağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1592', N'2', N'Samsat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1594', N'3', N'Sandıklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1595', N'54', N'Sapanca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1596', N'59', N'Saray');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1597', N'20', N'Sarayköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1598', N'42', N'Sarayönü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1599', N'26', N'Sarıcakaya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1600', N'45', N'Sarıgöl');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1601', N'36', N'Sarıkamış');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1602', N'66', N'Sarıkaya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1603', N'38', N'Sarıoğlan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1604', N'34', N'Sarıyer');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1605', N'38', N'Sarız');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1606', N'45', N'Saruhanlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1607', N'72', N'Sason');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1608', N'10', N'Savaştepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1609', N'47', N'Savur');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1610', N'14', N'Seben');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1611', N'35', N'Seferihisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1612', N'35', N'Selçuk');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1613', N'45', N'Selendi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1614', N'36', N'Selim');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1615', N'32', N'Senirkent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1616', N'7', N'Serik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1617', N'42', N'Seydişehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1618', N'26', N'Seyitgazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1619', N'10', N'Sındırgı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1620', N'56', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1621', N'33', N'Silifke');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1622', N'34', N'Silivri');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1623', N'73', N'Silopi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1624', N'21', N'Silvan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1625', N'43', N'Simav');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1626', N'3', N'Sinanpaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1627', N'57', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1628', N'58', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1629', N'64', N'Sivaslı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1630', N'63', N'Siverek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1631', N'23', N'Sivrice');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1632', N'26', N'Sivrihisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1633', N'12', N'Solhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1634', N'45', N'Soma');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1635', N'66', N'Sorgun');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1636', N'11', N'Söğüt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1637', N'9', N'Söke');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1638', N'71', N'Sulakyurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1639', N'3', N'Sultandağı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1640', N'9', N'Sultanhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1641', N'5', N'Suluova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1642', N'19', N'Sungurlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1643', N'63', N'Suruç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1644', N'10', N'Susurluk');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1645', N'36', N'Susuz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1646', N'58', N'Suşehri');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1647', N'61', N'Sürmene');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1648', N'32', N'Sütçüler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1649', N'18', N'Şabanözü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1650', N'58', N'Şarkışla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1651', N'32', N'Şarkikaraağaç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1652', N'59', N'Şarköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1653', N'8', N'Şavşat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1654', N'28', N'Şebinkarahisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1655', N'66', N'Şefaatli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1656', N'30', N'Şemdinli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1657', N'25', N'Şenkaya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1658', N'6', N'Şereflikoçhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1659', N'34', N'Şile');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1660', N'29', N'Şiran');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1661', N'73', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1662', N'56', N'Şirvan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1663', N'34', N'Şişli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1664', N'3', N'Şuhut');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1665', N'33', N'Tarsus');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1666', N'37', N'Taşköprü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1667', N'4', N'Taşlıçay');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1668', N'5', N'Taşova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1669', N'13', N'Tatvan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1670', N'20', N'Tavas');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1671', N'43', N'Tavşanlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1672', N'15', N'Tefenni');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1674', N'25', N'Tekman');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1675', N'24', N'Tercan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1676', N'55', N'Terme');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1677', N'35', N'Tire');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1678', N'28', N'Tirebolu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1679', N'60', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1680', N'38', N'Tomarza');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1681', N'61', N'Tonya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1682', N'35', N'Torbalı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1683', N'25', N'Tortum');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1684', N'29', N'Torul');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1685', N'37', N'Tosya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1687', N'1', N'Tufanbeyli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1688', N'62', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1689', N'45', N'Turgutlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1690', N'60', N'Turhal');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1691', N'4', N'Tutak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1692', N'76', N'Tuzluca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1693', N'57', N'Türkeli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1694', N'46', N'Türkoğlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1695', N'48', N'Ula');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1696', N'52', N'Ulubey');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1697', N'64', N'Ulubey');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1698', N'73', N'Uludere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1699', N'32', N'Uluborlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1700', N'51', N'Ulukışla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1701', N'74', N'Ulus');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1703', N'35', N'Urla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1704', N'64', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1705', N'22', N'Uzunköprü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1706', N'52', N'Ünye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1707', N'50', N'Ürgüp');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1708', N'34', N'Üsküdar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1709', N'61', N'Vakfıkebir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1711', N'49', N'Varto');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1712', N'55', N'Vezirköprü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1713', N'63', N'Viranşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1714', N'39', N'Vize');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1715', N'38', N'Yahyalı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1716', N'77', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1717', N'32', N'Yalvaç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1718', N'18', N'Yapraklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1719', N'48', N'Yatağan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1720', N'27', N'Yavuzeli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1721', N'31', N'Yayladağı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1722', N'17', N'Yenice');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1723', N'6', N'Yenimahalle');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1724', N'9', N'Yenipazar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1725', N'16', N'Yenişehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1726', N'66', N'Yerköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1727', N'38', N'Yeşilhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1728', N'15', N'Yeşilova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1729', N'44', N'Yeşilyurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1730', N'81', N'Yığılca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1731', N'58', N'Yıldızeli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1732', N'61', N'Yomra');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1733', N'66', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1734', N'1', N'Yumurtalık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1735', N'42', N'Yunak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1736', N'8', N'Yusufeli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1737', N'30', N'Yüksekova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1738', N'58', N'Zara');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1739', N'34', N'Zeytinburnu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1740', N'60', N'Zile');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1741', N'67', N'Merkez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1742', N'48', N'Dalaman');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1743', N'80', N'Düziçi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1744', N'6', N'Gölbaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1745', N'6', N'Keçiören');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1746', N'6', N'Mamak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1747', N'6', N'Sincan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1748', N'1', N'Yüreğir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1749', N'50', N'Acıgöl');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1750', N'12', N'Adaklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1751', N'45', N'Ahmetli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1752', N'38', N'Akkışla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1753', N'42', N'Akören');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1754', N'40', N'Akpınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1755', N'32', N'Aksu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1756', N'36', N'Akyaka');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1757', N'1', N'Aladağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1758', N'67', N'Alaplı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1759', N'26', N'Alpu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1760', N'42', N'Altınekin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1761', N'74', N'Amasra');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1762', N'23', N'Arıcak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1763', N'55', N'Asarcık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1764', N'43', N'Aslanapa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1765', N'18', N'Atkaracalar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1766', N'33', N'Aydıncık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1767', N'69', N'Aydıntepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1768', N'70', N'Ayrancı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1769', N'20', N'Babadağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1770', N'65', N'Bahçesaray');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1771', N'3', N'Başmakçı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1772', N'44', N'Battalgazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1773', N'3', N'Bayat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1774', N'20', N'Bekilli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1775', N'61', N'Beşikdüzü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1776', N'35', N'Beydağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1777', N'26', N'Beylikova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1778', N'19', N'Boğazkale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1779', N'33', N'Bozyazı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1780', N'35', N'Buca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1781', N'9', N'Buharkent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1782', N'34', N'Büyükçekmece');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1783', N'16', N'Büyükorhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1784', N'81', N'Cumayeri');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1785', N'46', N'Çağlayancerit');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1786', N'65', N'Çaldıran');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1787', N'47', N'Dargeçit');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1788', N'69', N'Demirözü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1789', N'42', N'Derebucak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1790', N'43', N'Dumlupınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1791', N'21', N'Eğil');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1792', N'31', N'Erzin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1793', N'45', N'Gölmarmara');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1794', N'81', N'Gölyaka');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1795', N'52', N'Gülyalı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1796', N'53', N'Güneysu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1797', N'52', N'Gürgentepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1798', N'13', N'Güroymak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1799', N'16', N'Harmancık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1800', N'63', N'Harran');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1801', N'49', N'Hasköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1802', N'43', N'Hisarcık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1803', N'20', N'Honaz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1804', N'42', N'Hüyük');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1805', N'37', N'İhsangazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1806', N'1', N'İmamoğlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1807', N'9', N'İncirliova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1808', N'26', N'İnönü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1809', N'3', N'İscehisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1810', N'34', N'Kağıthane');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1811', N'7', N'Demre');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1812', N'25', N'Karaçoban');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1813', N'15', N'Karamanlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1814', N'42', N'Karatay');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1815', N'6', N'Kazan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1816', N'15', N'Kemer');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1817', N'18', N'Kızılırmak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1818', N'54', N'Kocaali');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1819', N'35', N'Konak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1820', N'23', N'Kovancılar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1821', N'41', N'Körfez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1822', N'29', N'Köse');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1823', N'34', N'Küçükçekmece');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1824', N'10', N'Marmara');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1825', N'59', N'Marmaraereğlisi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1826', N'35', N'Menderes');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1827', N'42', N'Meram');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1828', N'8', N'Murgul');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1829', N'16', N'Nilüfer');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1830', N'55', N'19 Mayıs');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1831', N'48', N'Ortaca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1832', N'16', N'Osmangazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1833', N'54', N'Pamukova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1834', N'60', N'Pazar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1835', N'34', N'Pendik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1836', N'37', N'Pınarbaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1837', N'28', N'Piraziz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1838', N'55', N'Salıpazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1839', N'42', N'Selçuklu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1840', N'20', N'Serinhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1841', N'27', N'Şahinbey');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1842', N'61', N'Şalpazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1843', N'43', N'Şaphane');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1844', N'27', N'Şehitkamil');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1845', N'37', N'Şenpazar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1846', N'38', N'Talas');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1847', N'54', N'Taraklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1848', N'42', N'Taşkent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1849', N'55', N'Tekkeköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1850', N'19', N'Uğurludağ');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1851', N'25', N'Uzundere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1852', N'34', N'Ümraniye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1853', N'24', N'Üzümlü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1854', N'28', N'Yağlıdere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1855', N'12', N'Yayladere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1856', N'78', N'Yenice');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1857', N'11', N'Yenipazar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1858', N'60', N'Yeşilyurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1859', N'16', N'Yıldırım');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1860', N'68', N'Ağaçören');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1861', N'68', N'Güzelyurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1862', N'70', N'Kazımkarabekir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1863', N'38', N'Kocasinan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1864', N'38', N'Melikgazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1865', N'25', N'Pazaryolu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1866', N'68', N'Sarıyahşi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1867', N'37', N'Ağlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1868', N'42', N'Ahırlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1869', N'40', N'Akçakent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1870', N'58', N'Akıncılar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1871', N'20', N'Pamukkale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1872', N'6', N'Akyurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1873', N'23', N'Alacakaya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1874', N'15', N'Altınyayla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1875', N'58', N'Altınyayla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1876', N'51', N'Altunhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1877', N'66', N'Aydıncık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1878', N'56', N'Tillo');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1879', N'55', N'Ayvacık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1880', N'71', N'Bahşili');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1881', N'20', N'Baklan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1882', N'71', N'Balışeyh');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1883', N'60', N'Başçiftlik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1884', N'70', N'Başyayla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1885', N'18', N'Bayramören');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1886', N'34', N'Bayrampaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1887', N'31', N'Belen');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1888', N'20', N'Beyağaç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1889', N'20', N'Bozkurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1890', N'40', N'Boztepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1891', N'52', N'Çamaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1892', N'33', N'Çamlıyayla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1893', N'28', N'Çamoluk');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1894', N'28', N'Çanakçı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1895', N'66', N'Çandır');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1896', N'61', N'Çarşıbaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1897', N'52', N'Çatalpınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1898', N'43', N'Çavdarhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1899', N'15', N'Çavdır');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1900', N'52', N'Çaybaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1901', N'71', N'Çelebi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1902', N'42', N'Çeltik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1903', N'15', N'Çeltikçi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1904', N'51', N'Çiftlik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1905', N'81', N'Çilimli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1906', N'3', N'Çobanlar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1907', N'42', N'Derbent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1908', N'53', N'Derepazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1909', N'61', N'Dernekpazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1910', N'57', N'Dikmen');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1911', N'19', N'Dodurga');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1912', N'28', N'Doğankent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1913', N'58', N'Doğanşar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1914', N'44', N'Doğanyol');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1915', N'37', N'Doğanyurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1916', N'14', N'Dörtdivan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1917', N'61', N'Düzköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1918', N'65', N'Edremit');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1919', N'46', N'Ekinözü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1920', N'42', N'Emirgazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1921', N'68', N'Eskil');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1922', N'6', N'Etimesgut');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1923', N'3', N'Evciler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1924', N'6', N'Evren');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1925', N'54', N'Ferizli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1926', N'67', N'Gökçebey');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1927', N'58', N'Gölova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1928', N'10', N'Gömeç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1929', N'32', N'Gönen');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1930', N'28', N'Güce');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1931', N'73', N'Güçlükonak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1932', N'68', N'Gülağaç');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1933', N'42', N'Güneysınır');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1934', N'26', N'Günyüzü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1935', N'16', N'Gürsu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1936', N'38', N'Hacılar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1937', N'42', N'Halkapınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1938', N'5', N'Hamamözü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1939', N'26', N'Han');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1940', N'37', N'Hanönü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1941', N'72', N'Hasankeyf');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1942', N'61', N'Hayrat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1943', N'53', N'Hemşin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1944', N'3', N'Hocalar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1945', N'25', N'Aziziye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1946', N'7', N'İbradı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1947', N'52', N'İkizce');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1948', N'11', N'İnhisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1949', N'53', N'İyidere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1950', N'52', N'Kabadüz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1951', N'52', N'Kabataş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1952', N'66', N'Kadışehri');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1953', N'44', N'Kale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1954', N'71', N'Karakeçili');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1955', N'54', N'Karapürçek');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1956', N'27', N'Karkamış');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1957', N'9', N'Karpuzlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1958', N'48', N'Kavaklıdere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1959', N'7', N'Kemer');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1960', N'16', N'Kestel');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1961', N'3', N'Kızılören');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1962', N'21', N'Kocaköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1963', N'18', N'Korgun');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1964', N'49', N'Korkut');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1965', N'45', N'Köprübaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1966', N'61', N'Köprübaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1967', N'25', N'Köprüköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1968', N'9', N'Köşk');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1969', N'44', N'Kuluncak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1970', N'31', N'Kumlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1971', N'29', N'Kürtün');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1972', N'19', N'Laçin');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1973', N'26', N'Mihalgazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1974', N'27', N'Nurdağı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1975', N'46', N'Nurhak');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1976', N'19', N'Oğuzlar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1977', N'24', N'Otlukbeli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1978', N'38', N'Özvatan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1979', N'43', N'Pazarlar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1980', N'65', N'Saray');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1981', N'57', N'Saraydüzü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1982', N'66', N'Saraykent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1983', N'70', N'Sarıveliler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1984', N'37', N'Seydiler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1985', N'2', N'Sincik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1986', N'54', N'Söğütlü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1987', N'60', N'Sulusaray');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1988', N'22', N'Süloğlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1989', N'2', N'Tut');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1990', N'42', N'Tuzlukçu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1991', N'58', N'Ulaş');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1992', N'71', N'Yahşihan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1993', N'55', N'Yakakent');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1994', N'42', N'Yalıhüyük');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1995', N'44', N'Yazıhan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1996', N'12', N'Yedisu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1997', N'14', N'Yeniçağa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'1998', N'66', N'Yenifakılı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2000', N'9', N'Didim');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2001', N'32', N'Yenişarbademli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2002', N'47', N'Yeşilli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2003', N'34', N'Avcılar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2004', N'34', N'Bağcılar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2005', N'34', N'Bahçelievler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2006', N'35', N'Balçova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2007', N'35', N'Çiğli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2008', N'75', N'Damal');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2009', N'35', N'Gaziemir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2010', N'34', N'Güngören');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2011', N'76', N'Karakoyunlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2012', N'34', N'Maltepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2013', N'35', N'Narlıdere');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2014', N'34', N'Sultanbeyli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2015', N'34', N'Tuzla');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2016', N'34', N'Esenler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2017', N'81', N'Gümüşova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2018', N'35', N'Güzelbahçe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2019', N'77', N'Altınova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2020', N'77', N'Armutlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2021', N'77', N'Çınarcık');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2022', N'77', N'Çiftlikköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2023', N'79', N'Elbeyli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2024', N'79', N'Musabeyli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2025', N'79', N'Polateli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2026', N'77', N'Termal');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2027', N'80', N'Hasanbeyli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2028', N'80', N'Sumbas');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2029', N'80', N'Toprakkale');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2030', N'41', N'Derince');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2031', N'81', N'Kaynaşlı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2032', N'1', N'Sarıçam');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2033', N'1', N'Çukurova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2034', N'6', N'Pursaklar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2035', N'7', N'Aksu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2036', N'7', N'Döşemealtı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2037', N'7', N'Kepez');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2038', N'7', N'Konyaaltı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2039', N'7', N'Muratpaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2040', N'21', N'Bağlar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2041', N'21', N'Kayapınar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2042', N'21', N'Sur');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2043', N'21', N'Yenişehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2044', N'25', N'Palandöken');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2045', N'25', N'Yakutiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2046', N'26', N'Odunpazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2047', N'26', N'Tepebaşı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2048', N'34', N'Arnavutköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2049', N'34', N'Ataşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2050', N'34', N'Başakşehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2051', N'34', N'Beylikdüzü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2052', N'34', N'Çekmeköy');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2053', N'34', N'Esenyurt');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2054', N'34', N'Sancaktepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2055', N'34', N'Sultangazi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2056', N'35', N'Bayraklı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2057', N'35', N'Karabağlar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2058', N'41', N'Başiskele');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2059', N'41', N'Çayırova');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2060', N'41', N'Darıca');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2061', N'41', N'Dilovası');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2062', N'41', N'İzmit');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2063', N'41', N'Kartepe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2064', N'33', N'Akdeniz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2065', N'33', N'Mezitli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2066', N'33', N'Toroslar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2067', N'33', N'Yenişehir');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2068', N'54', N'Adapazarı');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2069', N'54', N'Arifiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2070', N'54', N'Erenler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2071', N'54', N'Serdivan');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2072', N'55', N'Atakum');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2073', N'55', N'Canik');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2074', N'55', N'İlkadım');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2076', N'9', N'Efeler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2077', N'10', N'Altıeylül');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2078', N'10', N'Karesi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2079', N'20', N'Merkezefendi');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2080', N'31', N'Antakya');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2081', N'31', N'Arsuz');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2082', N'31', N'Defne');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2083', N'31', N'Payas');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2084', N'46', N'Dulkadiroğlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2085', N'46', N'Onikişubat');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2086', N'45', N'Şehzadeler');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2087', N'45', N'Yunusemre');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2088', N'47', N'Artuklu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2089', N'48', N'Menteşe');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2090', N'48', N'Seydikemer');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2091', N'63', N'Eyyübiye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2092', N'63', N'Haliliye');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2093', N'63', N'Karaköprü');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2094', N'59', N'Ergene');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2096', N'59', N'Süleymanpaşa');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2097', N'61', N'Ortahisar');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2098', N'65', N'İpekyolu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2099', N'65', N'Tuşba');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2103', N'52', N'Altınordu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2104', N'67', N'Kilimli');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2105', N'67', N'Kozlu');
GO
INSERT INTO [dbo].[State] ([Id], [CityId], [Name]) VALUES (N'2106', N'59', N'Kapaklı');
GO

-- ----------------------------
-- Indexes structure for table State
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table [dbo].[State]
-- ----------------------------
ALTER TABLE [dbo].[State] ADD PRIMARY KEY ([Id])
GO

-- ----------------------------
-- Foreign Key structure for table [dbo].[State]
-- ----------------------------
ALTER TABLE [dbo].[State] ADD FOREIGN KEY ([CityId]) REFERENCES [dbo].[City] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
GO