VvebOIDC/install/sql/insert/geoip/region-7.sql

477 lines
17 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

INSERT INTO `region` VALUES
(3315, 215, 'Adana', 'TR-01', 0),
(3316, 215, 'Adıyaman', 'TR-02', 0),
(3317, 215, 'Afyonkarahisar', 'TR-03', 0),
(3318, 215, 'Ağrı', 'TR-04', 0),
(3319, 215, 'Aksaray', 'TR-68', 0),
(3320, 215, 'Amasya', 'TR-05', 0),
(3321, 215, 'Ankara', 'TR-06', 0),
(3322, 215, 'Antalya', 'TR-07', 0),
(3323, 215, 'Ardahan', 'TR-75', 0),
(3324, 215, 'Artvin', 'TR-08', 0),
(3325, 215, 'Aydın', 'TR-09', 0),
(3326, 215, 'Balıkesir', 'TR-10', 0),
(3327, 215, 'Bartın', 'TR-74', 0),
(3328, 215, 'Batman', 'TR-72', 0),
(3329, 215, 'Bayburt', 'TR-69', 0),
(3330, 215, 'Bilecik', 'TR-11', 0),
(3331, 215, 'Bingöl', 'TR-12', 0),
(3332, 215, 'Bitlis', 'TR-13', 0),
(3333, 215, 'Bolu', 'TR-14', 0),
(3334, 215, 'Burdur', 'TR-15', 0),
(3335, 215, 'Bursa', 'TR-16', 0),
(3336, 215, 'Çanakkale', 'TR-17', 0),
(3337, 215, 'Çankırı', 'TR-18', 0),
(3338, 215, 'Çorum', 'TR-19', 0),
(3339, 215, 'Denizli', 'TR-20', 0),
(3340, 215, 'Diyarbakır', 'TR-21', 0),
(3341, 215, 'Düzce', 'TR-81', 0),
(3342, 215, 'Edirne', 'TR-22', 0),
(3343, 215, 'Elazığ', 'TR-23', 0),
(3344, 215, 'Erzincan', 'TR-24', 0),
(3345, 215, 'Erzurum', 'TR-25', 0),
(3346, 215, 'Eskişehir', 'TR-26', 0),
(3347, 215, 'Gaziantep', 'TR-27', 0),
(3348, 215, 'Giresun', 'TR-28', 0),
(3349, 215, 'Gümüşhane', 'TR-29', 0),
(3350, 215, 'Hakkari', 'TR-30', 0),
(3351, 215, 'Hatay', 'TR-31', 0),
(3352, 215, 'Iğdır', 'TR-76', 0),
(3353, 215, 'Isparta', 'TR-32', 0),
(3354, 215, 'İstanbul', 'TR-34', 0),
(3355, 215, 'İzmir', 'TR-35', 0),
(3356, 215, 'Kahramanmaraş', 'TR-46', 0),
(3357, 215, 'Karabük', 'TR-78', 0),
(3358, 215, 'Karaman', 'TR-70', 0),
(3359, 215, 'Kars', 'TR-36', 0),
(3360, 215, 'Kastamonu', 'TR-37', 0),
(3361, 215, 'Kayseri', 'TR-38', 0),
(3362, 215, 'Kilis', 'TR-79', 0),
(3363, 215, 'Kırıkkale', 'TR-71', 0),
(3364, 215, 'Kırklareli', 'TR-39', 0),
(3365, 215, 'Kırşehir', 'TR-40', 0),
(3366, 215, 'Kocaeli', 'TR-41', 0),
(3367, 215, 'Konya', 'TR-42', 0),
(3368, 215, 'Kütahya', 'TR-43', 0),
(3369, 215, 'Malatya', 'TR-44', 0),
(3370, 215, 'Manisa', 'TR-45', 0),
(3371, 215, 'Mardin', 'TR-47', 0),
(3372, 215, 'Mersin', 'TR-33', 0),
(3373, 215, 'Muğla', 'TR-48', 0),
(3374, 215, 'Muş', 'TR-49', 0),
(3375, 215, 'Nevşehir', 'TR-50', 0),
(3376, 215, 'Niğde', 'TR-51', 0),
(3377, 215, 'Ordu', 'TR-52', 0),
(3378, 215, 'Osmaniye', 'TR-80', 0),
(3379, 215, 'Rize', 'TR-53', 0),
(3380, 215, 'Sakarya', 'TR-54', 0),
(3381, 215, 'Samsun', 'TR-55', 0),
(3382, 215, 'Şanlıurfa', 'TR-63', 0),
(3383, 215, 'Siirt', 'TR-56', 0),
(3384, 215, 'Sinop', 'TR-57', 0),
(3385, 215, 'Şırnak', 'TR-73', 0),
(3386, 215, 'Sivas', 'TR-58', 0),
(3387, 215, 'Tekirdağ', 'TR-59', 0),
(3388, 215, 'Tokat', 'TR-60', 0),
(3389, 215, 'Trabzon', 'TR-61', 0),
(3390, 215, 'Tunceli', 'TR-62', 0),
(3391, 215, 'Uşak', 'TR-64', 0),
(3392, 215, 'Van', 'TR-65', 0),
(3393, 215, 'Yalova', 'TR-77', 0),
(3394, 215, 'Yozgat', 'TR-66', 0),
(3395, 215, 'Zonguldak', 'TR-67', 0),
(3396, 216, 'Ahal Welayaty', 'A', 0),
(3397, 216, 'Balkan Welayaty', 'B', 0),
(3398, 216, 'Dashhowuz Welayaty', 'D', 0),
(3399, 216, 'Lebap Welayaty', 'L', 0),
(3400, 216, 'Mary Welayaty', 'M', 0),
(3401, 217, 'Ambergris Cays', 'AC', 0),
(3402, 217, 'Dellis Cay', 'DC', 0),
(3403, 217, 'French Cay', 'FC', 0),
(3404, 217, 'Little Water Cay', 'LW', 0),
(3405, 217, 'Parrot Cay', 'RC', 0),
(3406, 217, 'Pine Cay', 'PN', 0),
(3407, 217, 'Salt Cay', 'SL', 0),
(3408, 217, 'Grand Turk', 'GT', 0),
(3409, 217, 'South Caicos', 'SC', 0),
(3410, 217, 'East Caicos', 'EC', 0),
(3411, 217, 'Middle Caicos', 'MC', 0),
(3412, 217, 'North Caicos', 'NC', 0),
(3413, 217, 'Providenciales', 'PR', 0),
(3414, 217, 'West Caicos', 'WC', 0),
(3415, 218, 'Nanumanga', 'NMG', 0),
(3416, 218, 'Niulakita', 'NLK', 0),
(3417, 218, 'Niutao', 'NTO', 0),
(3418, 218, 'Funafuti', 'FUN', 0),
(3419, 218, 'Nanumea', 'NME', 0),
(3420, 218, 'Nui', 'NUI', 0),
(3421, 218, 'Nukufetau', 'NFT', 0),
(3422, 218, 'Nukulaelae', 'NLL', 0),
(3423, 218, 'Vaitupu', 'VAI', 0),
(3424, 219, 'Kalangala', 'KAL', 0),
(3425, 219, 'Kampala', 'KMP', 0),
(3426, 219, 'Kayunga', 'KAY', 0),
(3427, 219, 'Kiboga', 'KIB', 0),
(3428, 219, 'Luwero', 'LUW', 0),
(3429, 219, 'Masaka', 'MAS', 0),
(3430, 219, 'Mpigi', 'MPI', 0),
(3431, 219, 'Mubende', 'MUB', 0),
(3432, 219, 'Mukono', 'MUK', 0),
(3433, 219, 'Nakasongola', 'NKS', 0),
(3434, 219, 'Rakai', 'RAK', 0),
(3435, 219, 'Sembabule', 'SEM', 0),
(3436, 219, 'Wakiso', 'WAK', 0),
(3437, 219, 'Bugiri', 'BUG', 0),
(3438, 219, 'Busia', 'BUS', 0),
(3439, 219, 'Iganga', 'IGA', 0),
(3440, 219, 'Jinja', 'JIN', 0),
(3441, 219, 'Kaberamaido', 'KAB', 0),
(3442, 219, 'Kamuli', 'KML', 0),
(3443, 219, 'Kapchorwa', 'KPC', 0),
(3444, 219, 'Katakwi', 'KTK', 0),
(3445, 219, 'Kumi', 'KUM', 0),
(3446, 219, 'Mayuge', 'MAY', 0),
(3447, 219, 'Mbale', 'MBA', 0),
(3448, 219, 'Pallisa', 'PAL', 0),
(3449, 219, 'Sironko', 'SIR', 0),
(3450, 219, 'Soroti', 'SOR', 0),
(3451, 219, 'Tororo', 'TOR', 0),
(3452, 219, 'Adjumani', 'ADJ', 0),
(3453, 219, 'Apac', 'APC', 0),
(3454, 219, 'Arua', 'ARU', 0),
(3455, 219, 'Gulu', 'GUL', 0),
(3456, 219, 'Kitgum', 'KIT', 0),
(3457, 219, 'Kotido', 'KOT', 0),
(3458, 219, 'Lira', 'LIR', 0),
(3459, 219, 'Moroto', 'MRT', 0),
(3460, 219, 'Moyo', 'MOY', 0),
(3461, 219, 'Nakapiripirit', 'NAK', 0),
(3462, 219, 'Nebbi', 'NEB', 0),
(3463, 219, 'Pader', 'PAD', 0),
(3464, 219, 'Yumbe', 'YUM', 0),
(3465, 219, 'Bundibugyo', 'BUN', 0),
(3466, 219, 'Bushenyi', 'BSH', 0),
(3467, 219, 'Hoima', 'HOI', 0),
(3468, 219, 'Kabale', 'KBL', 0),
(3469, 219, 'Kabarole', 'KAR', 0),
(3470, 219, 'Kamwenge', 'KAM', 0),
(3471, 219, 'Kanungu', 'KAN', 0),
(3472, 219, 'Kasese', 'KAS', 0),
(3473, 219, 'Kibaale', 'KBA', 0),
(3474, 219, 'Kisoro', 'KIS', 0),
(3475, 219, 'Kyenjojo', 'KYE', 0),
(3476, 219, 'Masindi', 'MSN', 0),
(3477, 219, 'Mbarara', 'MBR', 0),
(3478, 219, 'Ntungamo', 'NTU', 0),
(3479, 219, 'Rukungiri', 'RUK', 0),
(3480, 220, 'Cherkaska', '23', 0),
(3481, 220, 'Chernihivska', '25', 0),
(3482, 220, 'Chernivetska', '24', 0),
(3483, 220, 'Avtonomna Respublika Krym', '27', 0),
(3484, 220, 'Dnipropetrovska', '04', 0),
(3485, 220, 'Donetska', '05', 0),
(3486, 220, 'Ivano-Frankivska', '09', 0),
(3487, 220, 'Khersonska', '21', 0),
(3488, 220, 'Khmelnytska', '22', 0),
(3489, 220, 'Kirovohradska', '35', 0),
(3490, 220, 'Kyiv', '26', 0),
(3491, 220, 'Kyivska', '10', 0),
(3492, 220, 'Luhanska', '12', 0),
(3493, 220, 'Lvivska', '13', 0),
(3494, 220, 'Mykolaivska', '14', 0),
(3495, 220, 'Odeska', '15', 0),
(3496, 220, 'Poltavska', '16', 0),
(3497, 220, 'Rivnenska', '17', 0),
(3498, 220, 'Sevastopol', '28', 0),
(3499, 220, 'Sumska', '18', 0),
(3500, 220, 'Ternopilska', '19', 0),
(3501, 220, 'Vinnytska', '02', 0),
(3502, 220, 'Volynska', '03', 0),
(3503, 220, 'Zakarpatska', '07', 0),
(3504, 220, 'Zaporizka', '08', 0),
(3505, 220, 'Zhytomyrskа', '06', 0),
(3506, 221, 'Abu Dhabi', 'ADH', 0),
(3507, 221, '`Ajman', 'AJ', 0),
(3508, 221, 'Al Fujayrah', 'FU', 0),
(3509, 221, 'Ash Shāriqah', 'SH', 0),
(3510, 221, 'Dubai', 'DU', 0),
(3511, 221, 'Ras al Khaymah', 'RK', 0),
(3512, 221, 'Umm al Qaywayn', 'UQ', 0),
(3513, 222, 'Aberdeen', 'ABN', 1),
(3514, 222, 'Aberdeenshire', 'ABNS', 1),
(3515, 222, 'Anglesey', 'ANG', 1),
(3516, 222, 'Angus', 'AGS', 1),
(3517, 222, 'Argyll and Bute', 'ARY', 1),
(3518, 222, 'Bedfordshire', 'BEDS', 1),
(3519, 222, 'Berkshire', 'BERKS', 1),
(3520, 222, 'Blaenau Gwent', 'BLA', 1),
(3521, 222, 'Bridgend', 'BRI', 1),
(3522, 222, 'Bristol', 'BSTL', 1),
(3523, 222, 'Buckinghamshire', 'BUCKS', 1),
(3524, 222, 'Caerphilly', 'CAE', 1),
(3525, 222, 'Cambridgeshire', 'CAMBS', 1),
(3526, 222, 'Cardiff', 'CDF', 1),
(3527, 222, 'Carmarthenshire', 'CARM', 1),
(3528, 222, 'Ceredigion', 'CDGN', 1),
(3529, 222, 'Cheshire', 'CHES', 1),
(3530, 222, 'Clackmannanshire', 'CLACK', 1),
(3531, 222, 'Conwy', 'CON', 1),
(3532, 222, 'Cornwall', 'CORN', 1),
(3533, 222, 'Denbighshire', 'DNBG', 1),
(3534, 222, 'Derbyshire', 'DERBY', 1),
(3535, 222, 'Devon', 'DVN', 1),
(3536, 222, 'Dorset', 'DOR', 1),
(3537, 222, 'Dumfries and Galloway', 'DGL', 1),
(3538, 222, 'Dundee', 'DUND', 1),
(3539, 222, 'Durham', 'DHM', 1),
(3540, 222, 'East Ayrshire', 'ARYE', 1),
(3541, 222, 'East Dunbartonshire', 'DUNBE', 1),
(3542, 222, 'East Lothian', 'LOTE', 1),
(3543, 222, 'East Renfrewshire', 'RENE', 1),
(3544, 222, 'East Riding of Yorkshire', 'ERYS', 1),
(3545, 222, 'East Sussex', 'SXE', 1),
(3546, 222, 'Edinburgh', 'EDIN', 1),
(3547, 222, 'Essex', 'ESX', 1),
(3548, 222, 'Falkirk', 'FALK', 1),
(3549, 222, 'Fife', 'FFE', 1),
(3550, 222, 'Flintshire', 'FLINT', 1),
(3551, 222, 'Glasgow', 'GLAS', 1),
(3552, 222, 'Gloucestershire', 'GLOS', 1),
(3553, 222, 'Greater London', 'LDN', 1),
(3554, 222, 'Greater Manchester', 'MCH', 1),
(3555, 222, 'Gwynedd', 'GDD', 1),
(3556, 222, 'Hampshire', 'HANTS', 1),
(3557, 222, 'Herefordshire', 'HWR', 1),
(3558, 222, 'Hertfordshire', 'HERTS', 1),
(3559, 222, 'Highlands', 'HLD', 1),
(3560, 222, 'Inverclyde', 'IVER', 1),
(3561, 222, 'Isle of Wight', 'IOW', 1),
(3562, 222, 'Kent', 'KNT', 1),
(3563, 222, 'Lancashire', 'LANCS', 1),
(3564, 222, 'Leicestershire', 'LEICS', 1),
(3565, 222, 'Lincolnshire', 'LINCS', 1),
(3566, 222, 'Merseyside', 'MSY', 1),
(3567, 222, 'Merthyr Tydfil', 'MERT', 1),
(3568, 222, 'Midlothian', 'MLOT', 1),
(3569, 222, 'Monmouthshire', 'MMOUTH', 1),
(3570, 222, 'Moray', 'MORAY', 1),
(3571, 222, 'Neath Port Talbot', 'NPRTAL', 1),
(3572, 222, 'Newport', 'NEWPT', 1),
(3573, 222, 'Norfolk', 'NOR', 1),
(3574, 222, 'North Ayrshire', 'ARYN', 1),
(3575, 222, 'North Lanarkshire', 'LANN', 1),
(3576, 222, 'North Yorkshire', 'YSN', 1),
(3577, 222, 'Northamptonshire', 'NHM', 1),
(3578, 222, 'Northumberland', 'NLD', 1),
(3579, 222, 'Nottinghamshire', 'NOT', 1),
(3580, 222, 'Orkney Islands', 'ORK', 1),
(3581, 222, 'Oxfordshire', 'OFE', 1),
(3582, 222, 'Pembrokeshire', 'PEM', 1),
(3583, 222, 'Perth and Kinross', 'PERTH', 1),
(3584, 222, 'Powys', 'PWS', 1),
(3585, 222, 'Renfrewshire', 'REN', 1),
(3586, 222, 'Rhondda Cynon Taff', 'RHON', 1),
(3587, 222, 'Rutland', 'RUT', 1),
(3588, 222, 'Scottish Borders', 'BOR', 1),
(3589, 222, 'Shetland Islands', 'SHET', 1),
(3590, 222, 'Shropshire', 'SPE', 1),
(3591, 222, 'Somerset', 'SOM', 1),
(3592, 222, 'South Ayrshire', 'ARYS', 1),
(3593, 222, 'South Lanarkshire', 'LANS', 1),
(3594, 222, 'South Yorkshire', 'YSS', 1),
(3595, 222, 'Staffordshire', 'SFD', 1),
(3596, 222, 'Stirling', 'STIR', 1),
(3597, 222, 'Suffolk', 'SFK', 1),
(3598, 222, 'Surrey', 'SRY', 1),
(3599, 222, 'Swansea', 'SWAN', 1),
(3600, 222, 'Torfaen', 'TORF', 1),
(3601, 222, 'Tyne and Wear', 'TWR', 1),
(3602, 222, 'Vale of Glamorgan', 'VGLAM', 1),
(3603, 222, 'Warwickshire', 'WARKS', 1),
(3604, 222, 'West Dunbartonshire', 'WDUN', 1),
(3605, 222, 'West Lothian', 'WLOT', 1),
(3606, 222, 'West Midlands', 'WMD', 1),
(3607, 222, 'West Sussex', 'SXW', 1),
(3608, 222, 'West Yorkshire', 'YSW', 1),
(3609, 222, 'Western Isles', 'WIL', 1),
(3610, 222, 'Wiltshire', 'WLT', 1),
(3611, 222, 'Worcestershire', 'WORCS', 1),
(3612, 222, 'Wrexham', 'WRX', 1),
(3949, 222, 'County Antrim', 'ANT', 1),
(3950, 222, 'County Armagh', 'ARM', 1),
(3951, 222, 'County Down', 'DOW', 1),
(3952, 222, 'County Fermanagh', 'FER', 1),
(3953, 222, 'County Londonderry', 'LDY', 1),
(3954, 222, 'County Tyrone', 'TYR', 1),
(3955, 222, 'Cumbria', 'CMA', 1),
(3613, 223, 'Alabama', 'AL', 1),
(3614, 223, 'Alaska', 'AK', 1),
(3615, 223, 'American Samoa', 'AS', 1),
(3616, 223, 'Arizona', 'AZ', 1),
(3617, 223, 'Arkansas', 'AR', 1),
(3618, 223, 'Armed Forces Africa', 'AF', 1),
(3619, 223, 'Armed Forces Americas', 'AA', 1),
(3620, 223, 'Armed Forces Canada', 'AC', 1),
(3621, 223, 'Armed Forces Europe', 'AE', 1),
(3622, 223, 'Armed Forces Middle East', 'AM', 1),
(3623, 223, 'Armed Forces Pacific', 'AP', 1),
(3624, 223, 'California', 'CA', 1),
(3625, 223, 'Colorado', 'CO', 1),
(3626, 223, 'Connecticut', 'CT', 1),
(3627, 223, 'Delaware', 'DE', 1),
(3628, 223, 'District of Columbia', 'DC', 1),
(3629, 223, 'Federated States Of Micronesia', 'FM', 1),
(3630, 223, 'Florida', 'FL', 1),
(3631, 223, 'Georgia', 'GA', 1),
(3632, 223, 'Guam', 'GU', 1),
(3633, 223, 'Hawaii', 'HI', 1),
(3634, 223, 'Idaho', 'ID', 1),
(3635, 223, 'Illinois', 'IL', 1),
(3636, 223, 'Indiana', 'IN', 1),
(3637, 223, 'Iowa', 'IA', 1),
(3638, 223, 'Kansas', 'KS', 1),
(3639, 223, 'Kentucky', 'KY', 1),
(3640, 223, 'Louisiana', 'LA', 1),
(3641, 223, 'Maine', 'ME', 1),
(3642, 223, 'Marshall Islands', 'MH', 1),
(3643, 223, 'Maryland', 'MD', 1),
(3644, 223, 'Massachusetts', 'MA', 1),
(3645, 223, 'Michigan', 'MI', 1),
(3646, 223, 'Minnesota', 'MN', 1),
(3647, 223, 'Mississippi', 'MS', 1),
(3648, 223, 'Missouri', 'MO', 1),
(3649, 223, 'Montana', 'MT', 1),
(3650, 223, 'Nebraska', 'NE', 1),
(3651, 223, 'Nevada', 'NV', 1),
(3652, 223, 'New Hampshire', 'NH', 1),
(3653, 223, 'New Jersey', 'NJ', 1),
(3654, 223, 'New Mexico', 'NM', 1),
(3655, 223, 'New York', 'NY', 1),
(3656, 223, 'North Carolina', 'NC', 1),
(3657, 223, 'North Dakota', 'ND', 1),
(3658, 223, 'Northern Mariana Islands', 'MP', 1),
(3659, 223, 'Ohio', 'OH', 1),
(3660, 223, 'Oklahoma', 'OK', 1),
(3661, 223, 'Oregon', 'OR', 1),
(3662, 223, 'Palau', 'PW', 1),
(3663, 223, 'Pennsylvania', 'PA', 1),
(3664, 223, 'Puerto Rico', 'PR', 1),
(3665, 223, 'Rhode Island', 'RI', 1),
(3666, 223, 'South Carolina', 'SC', 1),
(3667, 223, 'South Dakota', 'SD', 1),
(3668, 223, 'Tennessee', 'TN', 1),
(3669, 223, 'Texas', 'TX', 1),
(3670, 223, 'Utah', 'UT', 1),
(3671, 223, 'Vermont', 'VT', 1),
(3672, 223, 'Virgin Islands', 'VI', 1),
(3673, 223, 'Virginia', 'VA', 1),
(3674, 223, 'Washington', 'WA', 1),
(3675, 223, 'West Virginia', 'WV', 1),
(3676, 223, 'Wisconsin', 'WI', 1),
(3677, 223, 'Wyoming', 'WY', 1),
(3678, 224, 'Baker Island', 'BI', 0),
(3679, 224, 'Howland Island', 'HI', 0),
(3680, 224, 'Jarvis Island', 'JI', 0),
(3681, 224, 'Johnston Atoll', 'JA', 0),
(3682, 224, 'Kingman Reef', 'KR', 0),
(3683, 224, 'Midway Atoll', 'MA', 0),
(3684, 224, 'Navassa Island', 'NI', 0),
(3685, 224, 'Palmyra Atoll', 'PA', 0),
(3686, 224, 'Wake Island', 'WI', 0),
(3687, 225, 'Artigas', 'AR', 0),
(3688, 225, 'Canelones', 'CA', 0),
(3689, 225, 'Cerro Largo', 'CL', 0),
(3690, 225, 'Colonia', 'CO', 0),
(3691, 225, 'Durazno', 'DU', 0),
(3692, 225, 'Flores', 'FS', 0),
(3693, 225, 'Florida', 'FA', 0),
(3694, 225, 'Lavalleja', 'LA', 0),
(3695, 225, 'Maldonado', 'MA', 0),
(3696, 225, 'Montevideo', 'MO', 0),
(3697, 225, 'Paysandu', 'PA', 0),
(3698, 225, 'Rio Negro', 'RN', 0),
(3699, 225, 'Rivera', 'RV', 0),
(3700, 225, 'Rocha', 'RO', 0),
(3701, 225, 'Salto', 'SL', 0),
(3702, 225, 'San Jose', 'SJ', 0),
(3703, 225, 'Soriano', 'SO', 0),
(3704, 225, 'Tacuarembo', 'TA', 0),
(3705, 225, 'Treinta y Tres', 'TT', 0),
(3706, 226, 'Andijon', 'AN', 0),
(3707, 226, 'Buxoro', 'BU', 0),
(3708, 226, 'Farg`ona', 'FA', 0),
(3709, 226, 'Jizzax', 'JI', 0),
(3710, 226, 'Namangan', 'NG', 0),
(3711, 226, 'Navoiy', 'NW', 0),
(3712, 226, 'Qashqadaryo', 'QA', 0),
(3713, 226, 'Qoraqalpog`iston Republikasi', 'QR', 0),
(3714, 226, 'Samarqand', 'SA', 0),
(3715, 226, 'Sirdaryo', 'SI', 0),
(3716, 226, 'Surxondaryo', 'SU', 0),
(3717, 226, 'Toshkent City', 'TK', 0),
(3718, 226, 'Toshkent Region', 'TO', 0),
(3719, 226, 'Xorazm', 'XO', 0),
(3720, 227, 'Malampa', 'MA', 0),
(3721, 227, 'Penama', 'PE', 0),
(3722, 227, 'Sanma', 'SA', 0),
(3723, 227, 'Shefa', 'SH', 0),
(3724, 227, 'Tafea', 'TA', 0),
(3725, 227, 'Torba', 'TO', 0),
(3726, 229, 'Amazonas', 'Z', 0),
(3727, 229, 'Anzoategui', 'B', 0),
(3728, 229, 'Apure', 'C', 0),
(3729, 229, 'Aragua', 'D', 0),
(3730, 229, 'Barinas', 'E', 0),
(3731, 229, 'Bolivar', 'F', 0),
(3732, 229, 'Carabobo', 'G', 0),
(3733, 229, 'Cojedes', 'H', 0),
(3734, 229, 'Delta Amacuro', 'Y', 0),
(3735, 229, 'Dependencias Federales', 'W', 0),
(3736, 229, 'Distrito Capital', 'A', 0),
(3737, 229, 'Falcon', 'I', 0),
(3738, 229, 'Guarico', 'J', 0),
(3739, 229, 'Lara', 'K', 0),
(3740, 229, 'Merida', 'L', 0),
(3741, 229, 'Miranda', 'M', 0),
(3742, 229, 'Monagas', 'N', 0),
(3743, 229, 'Nueva Esparta', 'O', 0),
(3744, 229, 'Portuguesa', 'P', 0),
(3745, 229, 'Sucre', 'R', 0),
(3746, 229, 'Tachira', 'S', 0),
(3747, 229, 'Trujillo', 'T', 0),
(3748, 229, 'Vargas', 'X', 0),
(3749, 229, 'Yaracuy', 'U', 0),
(3750, 229, 'Zulia', 'V', 0),
(3751, 230, 'An Giang', 'AG', 0),
(3752, 230, 'Bac Giang', 'BG', 0),
(3753, 230, 'Bac Kan', 'BK', 0),
(3754, 230, 'Bac Lieu', 'BL', 0),
(3755, 230, 'Bac Ninh', 'BC', 0),
(3756, 230, 'Ba Ria-Vung Tau', 'BR', 0),
(3757, 230, 'Ben Tre', 'BN', 0),
(3758, 230, 'Binh Dinh', 'BH', 0),
(3759, 230, 'Binh Duong', 'BU', 0),
(3760, 230, 'Binh Phuoc', 'BP', 0),
(3761, 230, 'Binh Thuan', 'BT', 0),
(3762, 230, 'Ca Mau', 'CM', 0),
(3763, 230, 'Can Tho', 'CT', 0),
(3764, 230, 'Cao Bang', 'CB', 0),
(3765, 230, 'Dak Lak', 'DL', 0),
(3766, 230, 'Dak Nong', 'DG', 0),
(3767, 230, 'Da Nang', 'DN', 0),
(3768, 230, 'Dien Bien', 'DB', 0),
(3769, 230, 'Dong Nai', 'DI', 0),
(3770, 230, 'Dong Thap', 'DT', 0),
(3771, 230, 'Gia Lai', 'GL', 0),
(3772, 230, 'Ha Giang', 'HG', 0),
(3773, 230, 'Hai Duong', 'HD', 0),
(3774, 230, 'Hai Phong', 'HP', 0),
(3775, 230, 'Ha Nam', 'HM', 0),
(3776, 230, 'Ha Noi', 'HI', 0),
(3777, 230, 'Ha Tay', 'HT', 0),
(3778, 230, 'Ha Tinh', 'HH', 0),
(3779, 230, 'Hoa Binh', 'HB', 0),
(3780, 230, 'Ho Chi Minh City', 'HC', 0),
(3781, 230, 'Hau Giang', 'HU', 0),
(3782, 230, 'Hung Yen', 'HY', 0);