SELECT '01' AS ILKOD,'322' AS ALANKOD, 'ADANA' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,13844 AS ALAN,2237940 AS NUFUS,25 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '02' AS ILKOD,'416' AS ALANKOD, 'ADIYAMAN' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,7337 AS ALAN,626465 AS NUFUS,701 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '03' AS ILKOD,'272' AS ALANKOD, 'AFYONKARAHİSAR' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,14016 AS ALAN,729483 AS NUFUS,1012 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '04' AS ILKOD,'472' AS ALANKOD, 'AĞRI' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,11099 AS ALAN,536199 AS NUFUS,1630 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '05' AS ILKOD,'358' AS ALANKOD, 'AMASYA' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,5628 AS ALAN,337800 AS NUFUS,400 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '06' AS ILKOD,'312' AS ALANKOD, 'ANKARA' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,25632 AS ALAN,5639076 AS NUFUS,905 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '07' AS ILKOD,'242' AS ALANKOD, 'ANTALYA' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,20177 AS ALAN,2511700 AS NUFUS,62 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '08' AS ILKOD,'466' AS ALANKOD, 'ARTVİN' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,7393 AS ALAN,170875 AS NUFUS,530 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '09' AS ILKOD,'256' AS ALANKOD, 'AYDIN' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,8116 AS ALAN,1110972 AS NUFUS,92 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '10' AS ILKOD,'266' AS ALANKOD, 'BALIKESİR' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,14583 AS ALAN,1228620 AS NUFUS,145 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '11' AS ILKOD,'228' AS ALANKOD, 'BİLECİK' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,4179 AS ALAN,219427 AS NUFUS,513 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '12' AS ILKOD,'426' AS ALANKOD, 'BİNGÖL' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,8004 AS ALAN,279812 AS NUFUS,1159 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '13' AS ILKOD,'434' AS ALANKOD, 'BİTLİS' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,8294 AS ALAN,348115 AS NUFUS,1637 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '14' AS ILKOD,'374' AS ALANKOD, 'BOLU' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,8313 AS ALAN,316126 AS NUFUS,741 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '15' AS ILKOD,'248' AS ALANKOD, 'BURDUR' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,7175 AS ALAN,270796 AS NUFUS,963 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '16' AS ILKOD,'224' AS ALANKOD, 'BURSA' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,10813 AS ALAN,3056120 AS NUFUS,238 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '17' AS ILKOD,'286' AS ALANKOD, 'ÇANAKKALE' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,9817 AS ALAN,542157 AS NUFUS,11 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '18' AS ILKOD,'376' AS ALANKOD, 'ÇANKIRI' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,7542 AS ALAN,195789 AS NUFUS,730 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '19' AS ILKOD,'364' AS ALANKOD, 'ÇORUM' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,12428 AS ALAN,530864 AS NUFUS,822 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '20' AS ILKOD,'258' AS ALANKOD, 'DENİZLİ' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,12134 AS ALAN,1037208 AS NUFUS,392 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '21' AS ILKOD,'412' AS ALANKOD, 'DİYARBAKIR' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,15168 AS ALAN,1756353 AS NUFUS,674 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '22' AS ILKOD,'284' AS ALANKOD, 'EDİRNE' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,6145 AS ALAN,413903 AS NUFUS,50 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '23' AS ILKOD,'424' AS ALANKOD, 'ELAZIĞ' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,9383 AS ALAN,591098 AS NUFUS,1041 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '24' AS ILKOD,'446' AS ALANKOD, 'ERZİNCAN' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,11815 AS ALAN,234747 AS NUFUS,1216 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '25' AS ILKOD,'442' AS ALANKOD, 'ERZURUM' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,25006 AS ALAN,762062 AS NUFUS,1923 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '26' AS ILKOD,'222' AS ALANKOD, 'ESKİŞEHİR' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,13960 AS ALAN,887475 AS NUFUS,796 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '27' AS ILKOD,'342' AS ALANKOD, 'GAZİANTEP' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,6803 AS ALAN,2069364 AS NUFUS,838 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '28' AS ILKOD,'454' AS ALANKOD, 'GİRESUN' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,7025 AS ALAN,448400 AS NUFUS,14 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '29' AS ILKOD,'456' AS ALANKOD, 'GÜMÜŞHANE' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,6668 AS ALAN,164521 AS NUFUS,1174 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '30' AS ILKOD,'438' AS ALANKOD, 'HAKKARİ' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,7095 AS ALAN,280991 AS NUFUS,1756 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '31' AS ILKOD,'326' AS ALANKOD, 'HATAY' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,5524 AS ALAN,1628894 AS NUFUS,89 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '32' AS ILKOD,'246' AS ALANKOD, 'ISPARTA' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,8946 AS ALAN,444914 AS NUFUS,1058 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '33' AS ILKOD,'324' AS ALANKOD, 'MERSİN' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,16010 AS ALAN,1840425 AS NUFUS,18 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '34' AS ILKOD,'212-216' AS ALANKOD, 'İSTANBUL' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,5461 AS ALAN,15519267 AS NUFUS,25 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '35' AS ILKOD,'232' AS ALANKOD, 'İZMİR' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,11891 AS ALAN,4367251 AS NUFUS,9 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '36' AS ILKOD,'474' AS ALANKOD, 'KARS' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,10193 AS ALAN,285410 AS NUFUS,1756 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '37' AS ILKOD,'366' AS ALANKOD, 'KASTAMONU' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,13064 AS ALAN,379405 AS NUFUS,814 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '38' AS ILKOD,'352' AS ALANKOD, 'KAYSERİ' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,16970 AS ALAN,1407409 AS NUFUS,1060 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '39' AS ILKOD,'288' AS ALANKOD, 'KIRKLARELİ' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,6459 AS ALAN,361836 AS NUFUS,231 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '40' AS ILKOD,'386' AS ALANKOD, 'KIRŞEHİR' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,6584 AS ALAN,242938 AS NUFUS,991 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '41' AS ILKOD,'262' AS ALANKOD, 'KOCAELİ' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,3397 AS ALAN,1953035 AS NUFUS,4 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '42' AS ILKOD,'332' AS ALANKOD, 'KONYA' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,40838 AS ALAN,2232374 AS NUFUS,1023 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '43' AS ILKOD,'274' AS ALANKOD, 'KÜTAHYA' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,11634 AS ALAN,579257 AS NUFUS,958 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '44' AS ILKOD,'422' AS ALANKOD, 'MALATYA' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,12259 AS ALAN,800165 AS NUFUS,970 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '45' AS ILKOD,'236' AS ALANKOD, 'MANİSA' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,13339 AS ALAN,1440611 AS NUFUS,79 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '46' AS ILKOD,'344' AS ALANKOD, 'KAHRAMANMARAŞ' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,14520 AS ALAN,1154102 AS NUFUS,562 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '47' AS ILKOD,'482' AS ALANKOD, 'MARDİN' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,8780 AS ALAN,838778 AS NUFUS,938 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '48' AS ILKOD,'252' AS ALANKOD, 'MUĞLA' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,12654 AS ALAN,983142 AS NUFUS,659 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '49' AS ILKOD,'436' AS ALANKOD, 'MUŞ' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,8650 AS ALAN,408809 AS NUFUS,1334 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '50' AS ILKOD,'384' AS ALANKOD, 'NEVŞEHİR' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,5485 AS ALAN,303010 AS NUFUS,1197 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '51' AS ILKOD,'388' AS ALANKOD, 'NİĞDE' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,7234 AS ALAN,362861 AS NUFUS,1239 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '52' AS ILKOD,'452' AS ALANKOD, 'ORDU' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,5861 AS ALAN,754198 AS NUFUS,25 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '53' AS ILKOD,'464' AS ALANKOD, 'RİZE' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,3835 AS ALAN,343212 AS NUFUS,11 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '54' AS ILKOD,'264' AS ALANKOD, 'SAKARYA' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,4824 AS ALAN,1029650 AS NUFUS,41 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '55' AS ILKOD,'362' AS ALANKOD, 'SAMSUN' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,9725 AS ALAN,1348542 AS NUFUS,10 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '56' AS ILKOD,'484' AS ALANKOD, 'SİİRT' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,5717 AS ALAN,330280 AS NUFUS,887 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '57' AS ILKOD,'368' AS ALANKOD, 'SİNOP' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,5717 AS ALAN,218243 AS NUFUS,27 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '58' AS ILKOD,'346' AS ALANKOD, 'SİVAS' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,28164 AS ALAN,638956 AS NUFUS,1313 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '59' AS ILKOD,'282' AS ALANKOD, 'TEKİRDAĞ' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,6190 AS ALAN,1055412 AS NUFUS,28 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '60' AS ILKOD,'356' AS ALANKOD, 'TOKAT' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,10042 AS ALAN,612747 AS NUFUS,630 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '61' AS ILKOD,'462' AS ALANKOD, 'TRABZON' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,4628 AS ALAN,808974 AS NUFUS,36 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '62' AS ILKOD,'428' AS ALANKOD, 'TUNCELİ' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,7582 AS ALAN,84660 AS NUFUS,922 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '63' AS ILKOD,'414' AS ALANKOD, 'ŞANLIURFA' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,19242 AS ALAN,2073614 AS NUFUS,527 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '64' AS ILKOD,'276' AS ALANKOD, 'UŞAK' AS SEHIR,'EGE BÖLGESİ' AS BOLGE,5555 AS ALAN,370509 AS NUFUS,915 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '65' AS ILKOD,'432' AS ALANKOD, 'VAN' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,20921 AS ALAN,1136757 AS NUFUS,1728 AS RAKIM,'BÜYÜKŞEHİR' AS BUYUKSEHIR
UNION
SELECT '66' AS ILKOD,'354' AS ALANKOD, 'YOZGAT' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,13690 AS ALAN,421200 AS NUFUS,1317 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '67' AS ILKOD,'372' AS ALANKOD, 'ZONGULDAK' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,3342 AS ALAN,596053 AS NUFUS,10 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '68' AS ILKOD,'382' AS ALANKOD, 'AKSARAY' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,7659 AS ALAN,416367 AS NUFUS,1228 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '69' AS ILKOD,'458' AS ALANKOD, 'BAYBURT' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,3746 AS ALAN,84843 AS NUFUS,1555 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '70' AS ILKOD,'338' AS ALANKOD, 'KARAMAN' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,8678 AS ALAN,253279 AS NUFUS,1063 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '71' AS ILKOD,'318' AS ALANKOD, 'KIRIKKALE' AS SEHIR,'İÇ ANADOLU BÖLGESİ' AS BOLGE,4791 AS ALAN,283017 AS NUFUS,746 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '72' AS ILKOD,'488' AS ALANKOD, 'BATMAN' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,4477 AS ALAN,608659 AS NUFUS,570 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '73' AS ILKOD,'486' AS ALANKOD, 'ŞIRNAK' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,7078 AS ALAN,529615 AS NUFUS,1343 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '74' AS ILKOD,'378' AS ALANKOD, 'BARTIN' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,2330 AS ALAN,198249 AS NUFUS,12 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '75' AS ILKOD,'478' AS ALANKOD, 'ARDAHAN' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,4934 AS ALAN,97319 AS NUFUS,1799 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '76' AS ILKOD,'476' AS ALANKOD, 'IĞDIR' AS SEHIR,'DOĞU ANADOLU BÖLGESİ' AS BOLGE,3664 AS ALAN,199442 AS NUFUS,860 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '77' AS ILKOD,'226' AS ALANKOD, 'YALOVA' AS SEHIR,'MARMARA BÖLGESİ' AS BOLGE,798 AS ALAN,270976 AS NUFUS,8 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '78' AS ILKOD,'370' AS ALANKOD, 'KARABÜK' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,4142 AS ALAN,248458 AS NUFUS,264 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '79' AS ILKOD,'348' AS ALANKOD, 'KİLİS' AS SEHIR,'GÜNEYDOĞU BÖLGESİ' AS BOLGE,1412 AS ALAN,142490 AS NUFUS,660 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '80' AS ILKOD,'328' AS ALANKOD, 'OSMANİYE' AS SEHIR,'AKDENİZ BÖLGESİ' AS BOLGE,3320 AS ALAN,538759 AS NUFUS,121 AS RAKIM,'' AS BUYUKSEHIR
UNION
SELECT '81' AS ILKOD,'380' AS ALANKOD, 'DÜZCE' AS SEHIR,'KARADENİZ BÖLGESİ' AS BOLGE,2492 AS ALAN,392166 AS NUFUS,149 AS RAKIM,'' AS BUYUKSEHIR