text: -- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
  --
  -- Host: 127.0.0.1    Database: ustravelers
  -- ------------------------------------------------------
  -- Server version	5.7.19
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `city`
  --
  
  DROP TABLE IF EXISTS `city`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `city` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `state_id` int(11) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uc_city` (`id`,`name`),
    KEY `country_region_name` (`state_id`,`name`),
    CONSTRAINT `fk_state_id` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB AUTO_INCREMENT=3900 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `city`
  --
  
  LOCK TABLES `city` WRITE;
  /*!40000 ALTER TABLE `city` DISABLE KEYS */;
  INSERT INTO `city` VALUES (3258,'Baksa',1235),(3259,'Barpeta',1235),(3260,'Bongaigaon',1235),(3261,'Cachar',1235),(3262,'Chirang',1235),(3263,'Darrang',1235),(3264,'Dhemaji',1235),(3265,'Dhubri',1235),(3266,'Dibrugarh',1235),(3267,'Dima Hasao District',1235),(3268,'Goalpara',1235),(3269,'Golaghat',1235),(3270,'Hailakandi',1235),(3271,'Jorhat',1235),(3272,'Kamrup',1235),(3273,'Kamrup Metropolitan',1235),(3274,'Karbi Anglong',1235),(3275,'Karimganj',1235),(3276,'Kokrajhar',1235),(3277,'Lakhimpur',1235),(3278,'Morigaon',1235),(3279,'Nagaon',1235),(3280,'Nalbari',1235),(3281,'Sibsagar',1235),(3282,'Sonitpur',1235),(3283,'Tinsukia',1235),(3284,'Udalguri',1235),(3285,'North Goa',1236),(3286,'South Goa',1236),(3287,'Alirajpur',1237),(3288,'Anuppur',1237),(3289,'Ashoknagar',1237),(3290,'Balaghat',1237),(3291,'Barwani',1237),(3292,'Betul',1237),(3293,'Bhind',1237),(3294,'Bhopal',1237),(3295,'Burhanpur',1237),(3296,'Chhatarpur',1237),(3297,'Chhindwara',1237),(3298,'Damoh',1237),(3299,'Datia',1237),(3300,'Dewas',1237),(3301,'Dhar',1237),(3302,'Dindori',1237),(3303,'East Nimar',1237),(3304,'Guna',1237),(3305,'Gwalior',1237),(3306,'Harda',1237),(3307,'Hoshangabad',1237),(3308,'Indore',1237),(3309,'Jabalpur',1237),(3310,'Jhabua',1237),(3311,'Katni',1237),(3312,'Khargone',1237),(3313,'Mandla',1237),(3314,'Mandsaur',1237),(3315,'Morena',1237),(3316,'Narsimhapur',1237),(3317,'Neemuch',1237),(3318,'Panna',1237),(3319,'Raisen',1237),(3320,'Rajgarh',1237),(3321,'Ratlam',1237),(3322,'Rewa',1237),(3323,'Sagar',1237),(3324,'Satna',1237),(3325,'Sehore',1237),(3326,'Seoni',1237),(3327,'Shahdol',1237),(3328,'Shajapur',1237),(3329,'Sheopur',1237),(3330,'Shivpuri',1237),(3331,'Sidhi',1237),(3332,'Singrauli',1237),(3333,'Tikamgarh',1237),(3334,'Ujjain',1237),(3335,'Umaria District',1237),(3336,'Vidisha',1237),(3337,'Bishnupur',1238),(3338,'Chandel',1238),(3339,'Churachandpur',1238),(3340,'Imphal East',1238),(3341,'Imphal West',1238),(3342,'Senapati',1238),(3343,'Tamenglong',1238),(3344,'Thoubal',1238),(3345,'Ukhrul',1238),(3346,'East Garo Hills',1239),(3347,'East Khasi Hills',1239),(3348,'Jaintia Hills',1239),(3349,'Ri-Bhoi',1239),(3350,'South Garo Hills',1239),(3351,'West Garo Hills',1239),(3352,'West Khasi Hills',1239),(3353,'Aizawl',1240),(3354,'Champhai',1240),(3355,'Kolasib district',1240),(3356,'Lawngtlai',1240),(3357,'Lunglei',1240),(3358,'Mamit',1240),(3359,'Saiha',1240),(3360,'Serchhip',1240),(3361,'Central Delhi',1241),(3362,'East Delhi',1241),(3363,'New Delhi',1241),(3364,'North Delhi',1241),(3365,'North East Delhi',1241),(3366,'North West Delhi',1241),(3367,'South Delhi',1241),(3368,'South West Delhi',1241),(3369,'West Delhi',1241),(3370,'East District',1242),(3371,'North District',1242),(3372,'South District',1242),(3373,'West District',1242),(3374,'Anantapur',1243),(3375,'Chittoor',1243),(3376,'Cuddapah',1243),(3377,'East Godavari',1243),(3378,'Guntur',1243),(3379,'Krishna',1243),(3380,'Kurnool',1243),(3381,'Nellore',1243),(3382,'Prakasam',1243),(3383,'Srikakulam',1243),(3384,'Vishakhapatnam',1243),(3385,'Vizianagaram District',1243),(3386,'West Godavari',1243),(3387,'Anjaw',1244),(3388,'Changlang',1244),(3389,'Dibang Valley',1244),(3390,'East Kameng',1244),(3391,'East Siang',1244),(3392,'Kurung Kumey',1244),(3393,'Lohit District',1244),(3394,'Lower Dibang Valley',1244),(3395,'Lower Subansiri',1244),(3396,'Papum Pare',1244),(3397,'Tawang',1244),(3398,'Tirap',1244),(3399,'Upper Siang',1244),(3400,'Upper Subansiri',1244),(3401,'West Kameng',1244),(3402,'West Siang',1244),(3403,'Araria',1245),(3404,'Arwal',1245),(3405,'Aurangabad',1245),(3406,'Banka',1245),(3407,'Begusarai',1245),(3408,'Bhagalpur',1245),(3409,'Bhojpur',1245),(3410,'Buxar',1245),(3411,'Darbhanga',1245),(3412,'Gaya',1245),(3413,'Gopalganj',1245),(3414,'Jamui',1245),(3415,'Jehanabad',1245),(3416,'Kaimur District',1245),(3417,'Katihar',1245),(3418,'Khagaria',1245),(3419,'Kishanganj',1245),(3420,'Lakhisarai',1245),(3421,'Madhepura',1245),(3422,'Madhubani',1245),(3423,'Munger',1245),(3424,'Muzaffarpur',1245),(3425,'Nalanda',1245),(3426,'Nawada',1245),(3427,'Pashchim Champaran',1245),(3428,'Patna',1245),(3429,'Purba Champaran',1245),(3430,'Purnia',1245),(3431,'Rohtas',1245),(3432,'Saharsa',1245),(3433,'Samastipur',1245),(3434,'Saran',1245),(3435,'Sheikhpura',1245),(3436,'Sheohar',1245),(3437,'Sitamarhi',1245),(3438,'Siwan',1245),(3439,'Supaul',1245),(3440,'Vaishali',1245),(3441,'Bastar',1246),(3442,'Bijapur',1246),(3443,'Bilaspur',1246),(3444,'Dakshin Bastar Dantewada',1246),(3445,'Dhamtari',1246),(3446,'Durg',1246),(3447,'Janjgir-Champa',1246),(3448,'Jashpur',1246),(3449,'Kabeerdham',1246),(3450,'Korba',1246),(3451,'Koriya',1246),(3452,'Mahasamund',1246),(3453,'Narayanpur',1246),(3454,'Raigarh',1246),(3455,'Raipur',1246),(3456,'Raj Nandgaon',1246),(3457,'Surguja',1246),(3458,'Uttar Bastar Kanker',1246),(3459,'Ahmadabad',1247),(3460,'Amreli',1247),(3461,'Anand',1247),(3462,'Banas Kantha',1247),(3463,'Bharuch',1247),(3464,'Bhavnagar',1247),(3465,'Dohad',1247),(3466,'Gandhinagar',1247),(3467,'Jamnagar',1247),(3468,'Junagadh',1247),(3469,'Kachchh',1247),(3470,'Kheda',1247),(3471,'Mahesana',1247),(3472,'Narmada District',1247),(3473,'Navsari',1247),(3474,'Panch Mahals',1247),(3475,'Patan',1247),(3476,'Porbandar',1247),(3477,'Rajkot',1247),(3478,'Sabar Kantha',1247),(3479,'Surat',1247),(3480,'Surendranagar',1247),(3481,'Tapi',1247),(3482,'The Dangs',1247),(3483,'Vadodara',1247),(3484,'Valsad',1247),(3485,'Ambala',1248),(3486,'Bhiwani',1248),(3487,'Faridabad District',1248),(3488,'Fatehabad District',1248),(3489,'Gurgaon',1248),(3490,'Hisar',1248),(3491,'Jhajjar',1248),(3492,'Jind',1248),(3493,'Kaithal',1248),(3494,'Karnal',1248),(3495,'Kurukshetra',1248),(3496,'Mahendragarh',1248),(3497,'Mewat',1248),(3498,'Palwal',1248),(3499,'Panchkula',1248),(3500,'Panipat',1248),(3501,'Rewari District',1248),(3502,'Rohtak',1248),(3503,'Sirsa',1248),(3504,'Sonipat',1248),(3505,'Yamunanagar',1248),(3506,'Bilaspur',1249),(3507,'Chamba',1249),(3508,'Hamirpur',1249),(3509,'Kangra',1249),(3510,'Kinnaur',1249),(3511,'Kulu',1249),(3512,'Lahul and Spiti',1249),(3513,'Mandi',1249),(3514,'Shimla',1249),(3515,'Sirmaur',1249),(3516,'Solan',1249),(3517,'Una',1249),(3518,'Anantnag',1250),(3519,'Badgam',1250),(3520,'Bandipore',1250),(3521,'Baramula',1250),(3522,'Doda',1250),(3523,'Ganderbal',1250),(3524,'Jammu',1250),(3525,'Kargil',1250),(3526,'Kathua',1250),(3527,'Kishtwar',1250),(3528,'Kulgam',1250),(3529,'Kupwara',1250),(3530,'Ladakh',1250),(3531,'Pulwama',1250),(3532,'Punch',1250),(3533,'Rajauri',1250),(3534,'Ramban',1250),(3535,'Reasi',1250),(3536,'Samba',1250),(3537,'Shupiyan',1250),(3538,'Srinagar',1250),(3539,'Udhampur',1250),(3540,'Bokaro',1251),(3541,'Chatra',1251),(3542,'Deogarh',1251),(3543,'Dhanbad',1251),(3544,'Dumka',1251),(3545,'Garhwa',1251),(3546,'Giridih',1251),(3547,'Godda',1251),(3548,'Gumla',1251),(3549,'Hazaribag',1251),(3550,'Jamtara',1251),(3551,'Khunti',1251),(3552,'Kodarma',1251),(3553,'Latehar',1251),(3554,'Lohardaga',1251),(3555,'Pakur',1251),(3556,'Palamu',1251),(3557,'Pashchim Singhbhum',1251),(3558,'Purba Singhbhum',1251),(3559,'Ramgarh',1251),(3560,'Ranchi',1251),(3561,'Sahibganj',1251),(3562,'Saraikela',1251),(3563,'Simdega',1251),(3564,'Bagalkot',1252),(3565,'Bangalore Rural',1252),(3566,'Bangalore Urban',1252),(3567,'Belgaum',1252),(3568,'Bellary',1252),(3569,'Bidar',1252),(3570,'Bijapur',1252),(3571,'Chamrajnagar',1252),(3572,'Chikkaballapur',1252),(3573,'Chikmagalur',1252),(3574,'Chitradurga',1252),(3575,'Dakshina Kannada',1252),(3576,'Davanagere',1252),(3577,'Dharwad',1252),(3578,'Gadag',1252),(3579,'Gulbarga',1252),(3580,'Hassan',1252),(3581,'Haveri',1252),(3582,'Kodagu',1252),(3583,'Kolar',1252),(3584,'Koppal',1252),(3585,'Mandya',1252),(3586,'Mysore',1252),(3587,'Raichur',1252),(3588,'Ramanagara',1252),(3589,'Shimoga',1252),(3590,'Tumkur',1252),(3591,'Udupi',1252),(3592,'Uttar Kannada',1252),(3593,'Yadgir',1252),(3594,'Alappuzha',1253),(3595,'Ernakulam',1253),(3596,'Idukki',1253),(3597,'Kannur',1253),(3598,'Kasaragod District',1253),(3599,'Kollam',1253),(3600,'Kottayam',1253),(3601,'Kozhikode',1253),(3602,'Malappuram',1253),(3603,'Palakkad district',1253),(3604,'Pattanamtitta',1253),(3605,'Thiruvananthapuram',1253),(3606,'Thrissur District',1253),(3607,'Wayanad',1253),(3608,'Ahmadnagar',1254),(3609,'Akola',1254),(3610,'Amravati Division',1254),(3611,'Aurangabad Division',1254),(3612,'Bhandara',1254),(3613,'Bid',1254),(3614,'Buldana',1254),(3615,'Chandrapur',1254),(3616,'Dhule',1254),(3617,'Gadchiroli',1254),(3618,'Gondiya',1254),(3619,'Hingoli',1254),(3620,'Jalgaon',1254),(3621,'Jalna',1254),(3622,'Kolhapur',1254),(3623,'Latur',1254),(3624,'Mumbai',1254),(3625,'Mumbai Suburban',1254),(3626,'Nagpur Division',1254),(3627,'Nanded',1254),(3628,'Nandurbar',1254),(3629,'Nashik Division',1254),(3630,'Osmanabad',1254),(3631,'Parbhani',1254),(3632,'Pune Division',1254),(3633,'Raigarh',1254),(3634,'Ratnagiri',1254),(3635,'Sangli',1254),(3636,'Satara Division',1254),(3637,'Sindhudurg',1254),(3638,'Solapur',1254),(3639,'Thane',1254),(3640,'Wardha',1254),(3641,'Washim',1254),(3642,'Yavatmal',1254),(3643,'Dimapur',1255),(3644,'Kiphire',1255),(3645,'Kohima',1255),(3646,'Longleng',1255),(3647,'Mokokchung',1255),(3648,'Mon',1255),(3649,'Peren',1255),(3650,'Phek',1255),(3651,'Tuensang District',1255),(3652,'Wokha',1255),(3653,'Zunheboto',1255),(3654,'Angul District',1256),(3655,'Balangir',1256),(3656,'Baleshwar',1256),(3657,'Baragarh',1256),(3658,'Baudh',1256),(3659,'Bhadrak',1256),(3660,'Cuttack',1256),(3661,'Debagarh',1256),(3662,'Dhenkanal',1256),(3663,'Gajapati',1256),(3664,'Ganjam',1256),(3665,'Jagatsinghpur',1256),(3666,'Jajpur',1256),(3667,'Jharsuguda',1256),(3668,'Kalahandi',1256),(3669,'Kandhamal',1256),(3670,'Kendrapara',1256),(3671,'Kendujhar',1256),(3672,'Khordha',1256),(3673,'Koraput',1256),(3674,'Malkangiri',1256),(3675,'Mayurbhanj',1256),(3676,'Nabarangpur',1256),(3677,'Nayagarh District',1256),(3678,'Nuapada',1256),(3679,'Puri',1256),(3680,'Rayagada',1256),(3681,'Sambalpur',1256),(3682,'Subarnapur',1256),(3683,'Sundargarh',1256),(3684,'Ajitgarh',1257),(3685,'Amritsar',1257),(3686,'Barnala',1257),(3687,'Bathinda',1257),(3688,'Faridkot',1257),(3689,'Fatehgarh Sahib',1257),(3690,'Fazilka',1257),(3691,'Ferozepur',1257),(3692,'Gurdaspur',1257),(3693,'Hoshiarpur',1257),(3694,'Jalandhar',1257),(3695,'Kapurthala',1257),(3696,'Ludhiana',1257),(3697,'Mansa',1257),(3698,'Moga',1257),(3699,'Muktsar',1257),(3700,'Pathankot',1257),(3701,'Patiala',1257),(3702,'Rupnagar',1257),(3703,'Sangrur',1257),(3704,'Shahid Bhagat Singh Nagar',1257),(3705,'Tarn Taran',1257),(3706,'Ajmer',1258),(3707,'Alwar',1258),(3708,'Banswara',1258),(3709,'Baran',1258),(3710,'Barmer',1258),(3711,'Bharatpur',1258),(3712,'Bhilwara',1258),(3713,'Bikaner',1258),(3714,'Bundi',1258),(3715,'Chittaurgarh',1258),(3716,'Churu',1258),(3717,'Dausa',1258),(3718,'Dhaulpur',1258),(3719,'Dungarpur',1258),(3720,'Ganganagar',1258),(3721,'Hanumangarh',1258),(3722,'Jaipur',1258),(3723,'Jaisalmer',1258),(3724,'Jalore',1258),(3725,'Jhalawar',1258),(3726,'Jhunjhunun',1258),(3727,'Jodhpur',1258),(3728,'Karauli',1258),(3729,'Kota',1258),(3730,'Nagaur',1258),(3731,'Pali',1258),(3732,'Pratapgarh',1258),(3733,'Rajsamand',1258),(3734,'Sawai Madhopur',1258),(3735,'Sikar',1258),(3736,'Sirohi',1258),(3737,'Tonk',1258),(3738,'Udaipur',1258),(3739,'Ariyalur',1259),(3740,'Chennai',1259),(3741,'Coimbatore',1259),(3742,'Cuddalore',1259),(3743,'Dharmapuri',1259),(3744,'Dindigul',1259),(3745,'Erode',1259),(3746,'Kancheepuram',1259),(3747,'Kanniyakumari',1259),(3748,'Karur',1259),(3749,'Krishnagiri',1259),(3750,'Madurai',1259),(3751,'Nagapattinam',1259),(3752,'Namakkal',1259),(3753,'Nilgiris District',1259),(3754,'Perambalur',1259),(3755,'Pudukkottai',1259),(3756,'Ramanathapuram',1259),(3757,'Salem',1259),(3758,'Sivaganga',1259),(3759,'Thanjavur',1259),(3760,'Theni',1259),(3761,'Thiruvallur',1259),(3762,'Thiruvarur',1259),(3763,'Thoothukkudi',1259),(3764,'Tiruchchirappalli',1259),(3765,'Tirunelveli Kattabo',1259),(3766,'Tiruppur',1259),(3767,'Tiruvannamalai',1259),(3768,'Vellore',1259),(3769,'Villupuram',1259),(3770,'Virudhunagar',1259),(3771,'Almora',1260),(3772,'Bageshwar',1260),(3773,'Chamoli',1260),(3774,'Champawat',1260),(3775,'Dehradun',1260),(3776,'Garhwal',1260),(3777,'Haridwar',1260),(3778,'Naini Tal',1260),(3779,'Pithoragarh',1260),(3780,'Rudraprayag',1260),(3781,'Tehri-Garhwal',1260),(3782,'Udham Singh Nagar',1260),(3783,'Uttarkashi',1260),(3784,'Adilabad',1261),(3785,'Hyderabad',1261),(3786,'Karimnagar',1261),(3787,'Khammam',1261),(3788,'Mahbubnagar',1261),(3789,'Medak',1261),(3790,'Nalgonda',1261),(3791,'Nizamabad District',1261),(3792,'Rangareddi',1261),(3793,'Warangal',1261),(3794,'Dhalai',1262),(3795,'North Tripura',1262),(3796,'South Tripura',1262),(3797,'West Tripura',1262),(3798,'Nicobar',1263),(3799,'North  & Middle Andaman',1263),(3800,'South Andaman',1263),(3801,'Chandigarh',1264),(3802,'Dadra & Nagar Haveli',1265),(3803,'Daman District',1266),(3804,'Diu',1266),(3805,'Lakshadweep',1267),(3806,'Karaikal',1268),(3807,'Mahe',1268),(3808,'Puducherry',1268),(3809,'Yanam',1268),(3810,'Agra',1269),(3811,'Aligarh',1269),(3812,'Allahabad',1269),(3813,'Ambedkar Nagar',1269),(3814,'Auraiya',1269),(3815,'Azamgarh',1269),(3816,'Baghpat',1269),(3817,'Bahraich',1269),(3818,'Ballia',1269),(3819,'Balrampur',1269),(3820,'Banda',1269),(3821,'Bara Banki',1269),(3822,'Bareilly',1269),(3823,'Basti',1269),(3824,'Bijnor',1269),(3825,'Budaun',1269),(3826,'Bulandshahr',1269),(3827,'Chandauli District',1269),(3828,'Chitrakoot',1269),(3829,'Deoria',1269),(3830,'Etah',1269),(3831,'Etawah',1269),(3832,'Faizabad',1269),(3833,'Farrukhabad',1269),(3834,'Fatehpur',1269),(3835,'Firozabad',1269),(3836,'Gautam Buddha Nagar',1269),(3837,'Ghaziabad',1269),(3838,'Ghazipur',1269),(3839,'Gonda',1269),(3840,'Gorakhpur',1269),(3841,'Hamirpur',1269),(3842,'Hardoi',1269),(3843,'Hathras',1269),(3844,'Jalaun',1269),(3845,'Jaunpur',1269),(3846,'Jhansi',1269),(3847,'Jyotiba Phule Nagar',1269),(3848,'Kannauj',1269),(3849,'Kanpur',1269),(3850,'Kanpur Dehat',1269),(3851,'Kasganj',1269),(3852,'Kaushambi District',1269),(3853,'Kheri',1269),(3854,'Kushinagar',1269),(3855,'Lalitpur',1269),(3856,'Lucknow District',1269),(3857,'Maharajganj',1269),(3858,'Mahoba',1269),(3859,'Mainpuri',1269),(3860,'Mathura',1269),(3861,'Mau',1269),(3862,'Meerut',1269),(3863,'Mirzapur',1269),(3864,'Moradabad',1269),(3865,'Muzaffarnagar',1269),(3866,'Pilibhit',1269),(3867,'Pratapgarh',1269),(3868,'Rae Bareli',1269),(3869,'Rampur',1269),(3870,'Saharanpur',1269),(3871,'Sant Kabir Nagar',1269),(3872,'Sant Ravi Das Nagar',1269),(3873,'Shahjahanpur',1269),(3874,'Shrawasti',1269),(3875,'Siddharthangar',1269),(3876,'Sitapur',1269),(3877,'Sonbhadra',1269),(3878,'Sultanpur',1269),(3879,'Unnao',1269),(3880,'Varanasi',1269),(3881,'Bankura',1270),(3882,'Barddhaman',1270),(3883,'Birbhum',1270),(3884,'Dakshin Dinajpur',1270),(3885,'Darjiling',1270),(3886,'Haora',1270),(3887,'Hugli',1270),(3888,'Jalpaiguri',1270),(3889,'Koch Bihar',1270),(3890,'Kolkata',1270),(3891,'Maldah',1270),(3892,'Murshidabad',1270),(3893,'Nadia',1270),(3894,'North 24 Parganas',1270),(3895,'Paschim Medinipur',1270),(3896,'Purba Medinipur',1270),(3897,'Puruliya',1270),(3898,'South 24 Parganas',1270),(3899,'Uttar Dinajpur',1270),(1,'Autauga County',3495),(2,'Baldwin County',3495),(3,'Barbour County',3495),(4,'Bibb County',3495),(5,'Blount County',3495),(6,'Bullock County',3495),(7,'Butler County',3495),(8,'Calhoun County',3495),(9,'Chambers County',3495),(10,'Cherokee County',3495),(11,'Chilton County',3495),(12,'Choctaw County',3495),(13,'Clarke County',3495),(14,'Clay County',3495),(15,'Cleburne County',3495),(16,'Coffee County',3495),(17,'Colbert County',3495),(18,'Conecuh County',3495),(19,'Coosa County',3495),(20,'Covington County',3495),(21,'Crenshaw County',3495),(22,'Cullman County',3495),(23,'Dale County',3495),(24,'Dallas County',3495),(25,'DeKalb County',3495),(26,'Elmore County',3495),(27,'Escambia County',3495),(28,'Etowah County',3495),(29,'Fayette County',3495),(30,'Franklin County',3495),(31,'Geneva County',3495),(32,'Greene County',3495),(33,'Hale County',3495),(34,'Henry County',3495),(35,'Houston County',3495),(36,'Jackson County',3495),(37,'Jefferson County',3495),(38,'Lamar County',3495),(39,'Lauderdale County',3495),(40,'Lawrence County',3495),(41,'Lee County',3495),(42,'Limestone County',3495),(43,'Lowndes County',3495),(44,'Macon County',3495),(45,'Madison County',3495),(46,'Marengo County',3495),(47,'Marion County',3495),(48,'Marshall County',3495),(49,'Mobile County',3495),(50,'Monroe County',3495),(51,'Montgomery County',3495),(52,'Morgan County',3495),(53,'Perry County',3495),(54,'Pickens County',3495),(55,'Pike County',3495),(56,'Randolph County',3495),(57,'Russell County',3495),(58,'Saint Clair County',3495),(59,'Shelby County',3495),(60,'Sumter County',3495),(61,'Talladega County',3495),(62,'Tallapoosa County',3495),(63,'Tuscaloosa County',3495),(64,'Walker County',3495),(65,'Washington County',3495),(66,'Wilcox County',3495),(67,'Winston County',3495),(68,'Aleutians East Borough',3496),(69,'Aleutians West Census Area',3496),(70,'Anchorage Municipality',3496),(71,'Bethel Census Area',3496),(72,'Bristol Bay Borough',3496),(73,'City and Borough of Wrangell',3496),(74,'Denali Borough',3496),(75,'Dillingham Census Area',3496),(76,'Fairbanks North Star Borough',3496),(77,'Haines Borough',3496),(78,'Hoonah-Angoon Census Area',3496),(79,'Juneau City and Borough',3496),(80,'Kenai Peninsula Borough',3496),(81,'Ketchikan Gateway Borough',3496),(82,'Kodiak Island Borough',3496),(83,'Kusilvak Census Area',3496),(84,'Lake and Peninsula Borough',3496),(85,'Matanuska-Susitna Borough',3496),(86,'Nome Census Area',3496),(87,'North Slope Borough',3496),(88,'Northwest Arctic Borough',3496),(89,'Petersburg Borough',3496),(90,'Prince of Wales-Hyder Census Area, Alaska',3496),(91,'Sitka City and Borough',3496),(92,'Skagway Municipality',3496),(93,'Southeast Fairbanks Census Area',3496),(94,'Valdez-Cordova Census Area',3496),(95,'Yakutat City and Borough',3496),(96,'Yukon-Koyukuk Census Area',3496),(97,'Apache County',3497),(98,'Cochise County',3497),(99,'Coconino County',3497),(100,'Gila County',3497),(101,'Graham County',3497),(102,'Greenlee County',3497),(103,'La Paz County',3497),(104,'Maricopa County',3497),(105,'Mohave County',3497),(106,'Navajo County',3497),(107,'Pima County',3497),(108,'Pinal County',3497),(109,'Santa Cruz County',3497),(110,'Yavapai County',3497),(111,'Yuma County',3497),(112,'Arkansas County',3498),(113,'Ashley County',3498),(114,'Baxter County',3498),(115,'Benton County',3498),(116,'Boone County',3498),(117,'Bradley County',3498),(118,'Calhoun County',3498),(119,'Carroll County',3498),(120,'Chicot County',3498),(121,'Clark County',3498),(122,'Clay County',3498),(123,'Cleburne County',3498),(124,'Cleveland County',3498),(125,'Columbia County',3498),(126,'Conway County',3498),(127,'Craighead County',3498),(128,'Crawford County',3498),(129,'Crittenden County',3498),(130,'Cross County',3498),(131,'Dallas County',3498),(132,'Desha County',3498),(133,'Drew County',3498),(134,'Faulkner County',3498),(135,'Franklin County',3498),(136,'Fulton County',3498),(137,'Garland County',3498),(138,'Grant County',3498),(139,'Greene County',3498),(140,'Hempstead County',3498),(141,'Hot Spring County',3498),(142,'Howard County',3498),(143,'Independence County',3498),(144,'Izard County',3498),(145,'Jackson County',3498),(146,'Jefferson County',3498),(147,'Johnson County',3498),(148,'Lafayette County',3498),(149,'Lawrence County',3498),(150,'Lee County',3498),(151,'Lincoln County',3498),(152,'Little River County',3498),(153,'Logan County',3498),(154,'Lonoke County',3498),(155,'Madison County',3498),(156,'Marion County',3498),(157,'Miller County',3498),(158,'Mississippi County',3498),(159,'Monroe County',3498),(160,'Montgomery County',3498),(161,'Nevada County',3498),(162,'Newton County',3498),(163,'Ouachita County',3498),(164,'Perry County',3498),(165,'Phillips County',3498),(166,'Pike County',3498),(167,'Poinsett County',3498),(168,'Polk County',3498),(169,'Pope County',3498),(170,'Prairie County',3498),(171,'Pulaski County',3498),(172,'Randolph County',3498),(173,'Saint Francis County',3498),(174,'Saline County',3498),(175,'Scott County',3498),(176,'Searcy County',3498),(177,'Sebastian County',3498),(178,'Sevier County',3498),(179,'Sharp County',3498),(180,'Stone County',3498),(181,'Union County',3498),(182,'Van Buren County',3498),(183,'Washington County',3498),(184,'White County',3498),(185,'Woodruff County',3498),(186,'Yell County',3498),(187,'Alameda County',3499),(188,'Alpine County',3499),(189,'Amador County',3499),(190,'Butte County',3499),(191,'Calaveras County',3499),(192,'City and County of San Francisco',3499),(193,'Colusa County',3499),(194,'Contra Costa County',3499),(195,'Del Norte County',3499),(196,'El Dorado County',3499),(197,'Fresno County',3499),(198,'Glenn County',3499),(199,'Humboldt County',3499),(200,'Imperial County',3499),(201,'Inyo County',3499),(202,'Kern County',3499),(203,'Kings County',3499),(204,'Lake County',3499),(205,'Lassen County',3499),(206,'Los Angeles County',3499),(207,'Madera County',3499),(208,'Marin County',3499),(209,'Mariposa County',3499),(210,'Mendocino County',3499),(211,'Merced County',3499),(212,'Modoc County',3499),(213,'Mono County',3499),(214,'Monterey County',3499),(215,'Napa County',3499),(216,'Nevada County',3499),(217,'Orange County',3499),(218,'Placer County',3499),(219,'Plumas County',3499),(220,'Riverside County',3499),(221,'Sacramento County',3499),(222,'San Benito County',3499),(223,'San Bernardino County',3499),(224,'San Diego County',3499),(225,'San Joaquin County',3499),(226,'San Luis Obispo County',3499),(227,'San Mateo County',3499),(228,'Santa Barbara County',3499),(229,'Santa Clara County',3499),(230,'Santa Cruz County',3499),(231,'Shasta County',3499),(232,'Sierra County',3499),(233,'Siskiyou County',3499),(234,'Solano County',3499),(235,'Sonoma County',3499),(236,'Stanislaus County',3499),(237,'Sutter County',3499),(238,'Tehama County',3499),(239,'Trinity County',3499),(240,'Tulare County',3499),(241,'Tuolumne County',3499),(242,'Ventura County',3499),(243,'Yolo County',3499),(244,'Yuba County',3499),(245,'Adams County',3500),(246,'Alamosa County',3500),(247,'Arapahoe County',3500),(248,'Archuleta County',3500),(249,'Baca County',3500),(250,'Bent County',3500),(251,'Boulder County',3500),(252,'Broomfield County',3500),(253,'Chaffee County',3500),(254,'Cheyenne County',3500),(255,'Clear Creek County',3500),(256,'Conejos County',3500),(257,'Costilla County',3500),(258,'Crowley County',3500),(259,'Custer County',3500),(260,'Delta County',3500),(261,'Denver County',3500),(262,'Dolores County',3500),(263,'Douglas County',3500),(264,'Eagle County',3500),(265,'El Paso County',3500),(266,'Elbert County',3500),(267,'Fremont County',3500),(268,'Garfield County',3500),(269,'Gilpin County',3500),(270,'Grand County',3500),(271,'Gunnison County',3500),(272,'Hinsdale County',3500),(273,'Huerfano County',3500),(274,'Jackson County',3500),(275,'Jefferson County',3500),(276,'Kiowa County',3500),(277,'Kit Carson County',3500),(278,'La Plata County',3500),(279,'Lake County',3500),(280,'Larimer County',3500),(281,'Las Animas County',3500),(282,'Lincoln County',3500),(283,'Logan County',3500),(284,'Mesa County',3500),(285,'Mineral County',3500),(286,'Moffat County',3500),(287,'Montezuma County',3500),(288,'Montrose County',3500),(289,'Morgan County',3500),(290,'Otero County',3500),(291,'Ouray County',3500),(292,'Park County',3500),(293,'Phillips County',3500),(294,'Pitkin County',3500),(295,'Prowers County',3500),(296,'Pueblo County',3500),(297,'Rio Blanco County',3500),(298,'Rio Grande County',3500),(299,'Routt County',3500),(300,'Saguache County',3500),(301,'San Juan County',3500),(302,'San Miguel County',3500),(303,'Sedgwick County',3500),(304,'Summit County',3500),(305,'Teller County',3500),(306,'Washington County',3500),(307,'Weld County',3500),(308,'Yuma County',3500),(309,'Fairfield County',3501),(310,'Hartford County',3501),(311,'Litchfield County',3501),(312,'Middlesex County',3501),(313,'New Haven County',3501),(314,'New London County',3501),(315,'Tolland County',3501),(316,'Windham County',3501),(317,'Kent County',3502),(318,'New Castle County',3502),(319,'Sussex County',3502),(320,'Washington County',3503),(321,'Alachua County',3504),(322,'Baker County',3504),(323,'Bay County',3504),(324,'Bradford County',3504),(325,'Brevard County',3504),(326,'Broward County',3504),(327,'Calhoun County',3504),(328,'Charlotte County',3504),(329,'Citrus County',3504),(330,'Clay County',3504),(331,'Collier County',3504),(332,'Columbia County',3504),(333,'DeSoto County',3504),(334,'Dixie County',3504),(335,'Duval County',3504),(336,'Escambia County',3504),(337,'Flagler County',3504),(338,'Franklin County',3504),(339,'Gadsden County',3504),(340,'Gilchrist County',3504),(341,'Glades County',3504),(342,'Gulf County',3504),(343,'Hamilton County',3504),(344,'Hardee County',3504),(345,'Hendry County',3504),(346,'Hernando County',3504),(347,'Highlands County',3504),(348,'Hillsborough County',3504),(349,'Holmes County',3504),(350,'Indian River County',3504),(351,'Jackson County',3504),(352,'Jefferson County',3504),(353,'Lafayette County',3504),(354,'Lake County',3504),(355,'Lee County',3504),(356,'Leon County',3504),(357,'Levy County',3504),(358,'Liberty County',3504),(359,'Madison County',3504),(360,'Manatee County',3504),(361,'Marion County',3504),(362,'Martin County',3504),(363,'Miami-Dade County',3504),(364,'Monroe County',3504),(365,'Nassau County',3504),(366,'Okaloosa County',3504),(367,'Okeechobee County',3504),(368,'Orange County',3504),(369,'Osceola County',3504),(370,'Palm Beach County',3504),(371,'Pasco County',3504),(372,'Pinellas County',3504),(373,'Polk County',3504),(374,'Putnam County',3504),(375,'Saint Johns County',3504),(376,'Saint Lucie County',3504),(377,'Santa Rosa County',3504),(378,'Sarasota County',3504),(379,'Seminole County',3504),(380,'Sumter County',3504),(381,'Suwannee County',3504),(382,'Taylor County',3504),(383,'Union County',3504),(384,'Volusia County',3504),(385,'Wakulla County',3504),(386,'Walton County',3504),(387,'Washington County',3504),(388,'Appling County',3505),(389,'Atkinson County',3505),(390,'Bacon County',3505),(391,'Baker County',3505),(392,'Baldwin County',3505),(393,'Banks County',3505),(394,'Barrow County',3505),(395,'Bartow County',3505),(396,'Ben Hill County',3505),(397,'Berrien County',3505),(398,'Bibb County',3505),(399,'Bleckley County',3505),(400,'Brantley County',3505),(401,'Brooks County',3505),(402,'Bryan County',3505),(403,'Bulloch County',3505),(404,'Burke County',3505),(405,'Butts County',3505),(406,'Calhoun County',3505),(407,'Camden County',3505),(408,'Candler County',3505),(409,'Carroll County',3505),(410,'Catoosa County',3505),(411,'Charlton County',3505),(412,'Chatham County',3505),(413,'Chattahoochee County',3505),(414,'Chattooga County',3505),(415,'Cherokee County',3505),(416,'Clarke County',3505),(417,'Clay County',3505),(418,'Clayton County',3505),(419,'Clinch County',3505),(420,'Cobb County',3505),(421,'Coffee County',3505),(422,'Colquitt County',3505),(423,'Columbia County',3505),(424,'Cook County',3505),(425,'Coweta County',3505),(426,'Crawford County',3505),(427,'Crisp County',3505),(428,'Dade County',3505),(429,'Dawson County',3505),(430,'Decatur County',3505),(431,'DeKalb County',3505),(432,'Dodge County',3505),(433,'Dooly County',3505),(434,'Dougherty County',3505),(435,'Douglas County',3505),(436,'Early County',3505),(437,'Echols County',3505),(438,'Effingham County',3505),(439,'Elbert County',3505),(440,'Emanuel County',3505),(441,'Evans County',3505),(442,'Fannin County',3505),(443,'Fayette County',3505),(444,'Floyd County',3505),(445,'Forsyth County',3505),(446,'Franklin County',3505),(447,'Fulton County',3505),(448,'Gilmer County',3505),(449,'Glascock County',3505),(450,'Glynn County',3505),(451,'Gordon County',3505),(452,'Grady County',3505),(453,'Greene County',3505),(454,'Gwinnett County',3505),(455,'Habersham County',3505),(456,'Hall County',3505),(457,'Hancock County',3505),(458,'Haralson County',3505),(459,'Harris County',3505),(460,'Hart County',3505),(461,'Heard County',3505),(462,'Henry County',3505),(463,'Houston County',3505),(464,'Irwin County',3505),(465,'Jackson County',3505),(466,'Jasper County',3505),(467,'Jeff Davis County',3505),(468,'Jefferson County',3505),(469,'Jenkins County',3505),(470,'Johnson County',3505),(471,'Jones County',3505),(472,'Lamar County',3505),(473,'Lanier County',3505),(474,'Laurens County',3505),(475,'Lee County',3505),(476,'Liberty County',3505),(477,'Lincoln County',3505),(478,'Long County',3505),(479,'Lowndes County',3505),(480,'Lumpkin County',3505),(481,'Macon County',3505),(482,'Madison County',3505),(483,'Marion County',3505),(484,'McDuffie County',3505),(485,'McIntosh County',3505),(486,'Meriwether County',3505),(487,'Miller County',3505),(488,'Mitchell County',3505),(489,'Monroe County',3505),(490,'Montgomery County',3505),(491,'Morgan County',3505),(492,'Murray County',3505),(493,'Muscogee County',3505),(494,'Newton County',3505),(495,'Oconee County',3505),(496,'Oglethorpe County',3505),(497,'Paulding County',3505),(498,'Peach County',3505),(499,'Pickens County',3505),(500,'Pierce County',3505),(501,'Pike County',3505),(502,'Polk County',3505),(503,'Pulaski County',3505),(504,'Putnam County',3505),(505,'Quitman County',3505),(506,'Rabun County',3505),(507,'Randolph County',3505),(508,'Richmond County',3505),(509,'Rockdale County',3505),(510,'Schley County',3505),(511,'Screven County',3505),(512,'Seminole County',3505),(513,'Spalding County',3505),(514,'Stephens County',3505),(515,'Stewart County',3505),(516,'Sumter County',3505),(517,'Talbot County',3505),(518,'Taliaferro County',3505),(519,'Tattnall County',3505),(520,'Taylor County',3505),(521,'Telfair County',3505),(522,'Terrell County',3505),(523,'Thomas County',3505),(524,'Tift County',3505),(525,'Toombs County',3505),(526,'Towns County',3505),(527,'Treutlen County',3505),(528,'Troup County',3505),(529,'Turner County',3505),(530,'Twiggs County',3505),(531,'Union County',3505),(532,'Upson County',3505),(533,'Walker County',3505),(534,'Walton County',3505),(535,'Ware County',3505),(536,'Warren County',3505),(537,'Washington County',3505),(538,'Wayne County',3505),(539,'Webster County',3505),(540,'Wheeler County',3505),(541,'White County',3505),(542,'Whitfield County',3505),(543,'Wilcox County',3505),(544,'Wilkes County',3505),(545,'Wilkinson County',3505),(546,'Worth County',3505),(547,'Hawaii County',3506),(548,'Honolulu County',3506),(549,'Kalawao County',3506),(550,'Kauai County',3506),(551,'Maui County',3506),(552,'Ada County',3507),(553,'Adams County',3507),(554,'Bannock County',3507),(555,'Bear Lake County',3507),(556,'Benewah County',3507),(557,'Bingham County',3507),(558,'Blaine County',3507),(559,'Boise County',3507),(560,'Bonner County',3507),(561,'Bonneville County',3507),(562,'Boundary County',3507),(563,'Butte County',3507),(564,'Camas County',3507),(565,'Canyon County',3507),(566,'Caribou County',3507),(567,'Cassia County',3507),(568,'Clark County',3507),(569,'Clearwater County',3507),(570,'Custer County',3507),(571,'Elmore County',3507),(572,'Franklin County',3507),(573,'Fremont County',3507),(574,'Gem County',3507),(575,'Gooding County',3507),(576,'Idaho County',3507),(577,'Jefferson County',3507),(578,'Jerome County',3507),(579,'Kootenai County',3507),(580,'Latah County',3507),(581,'Lemhi County',3507),(582,'Lewis County',3507),(583,'Lincoln County',3507),(584,'Madison County',3507),(585,'Minidoka County',3507),(586,'Nez Perce County',3507),(587,'Oneida County',3507),(588,'Owyhee County',3507),(589,'Payette County',3507),(590,'Power County',3507),(591,'Shoshone County',3507),(592,'Teton County',3507),(593,'Twin Falls County',3507),(594,'Valley County',3507),(595,'Washington County',3507),(596,'Adams County',3508),(597,'Alexander County',3508),(598,'Bond County',3508),(599,'Boone County',3508),(600,'Brown County',3508),(601,'Bureau County',3508),(602,'Calhoun County',3508),(603,'Carroll County',3508),(604,'Cass County',3508),(605,'Champaign County',3508),(606,'Christian County',3508),(607,'Clark County',3508),(608,'Clay County',3508),(609,'Clinton County',3508),(610,'Coles County',3508),(611,'Cook County',3508),(612,'Crawford County',3508),(613,'Cumberland County',3508),(614,'De Witt County',3508),(615,'DeKalb County',3508),(616,'Douglas County',3508),(617,'DuPage County',3508),(618,'Edgar County',3508),(619,'Edwards County',3508),(620,'Effingham County',3508),(621,'Fayette County',3508),(622,'Ford County',3508),(623,'Franklin County',3508),(624,'Fulton County',3508),(625,'Gallatin County',3508),(626,'Greene County',3508),(627,'Grundy County',3508),(628,'Hamilton County',3508),(629,'Hancock County',3508),(630,'Hardin County',3508),(631,'Henderson County',3508),(632,'Henry County',3508),(633,'Iroquois County',3508),(634,'Jackson County',3508),(635,'Jasper County',3508),(636,'Jefferson County',3508),(637,'Jersey County',3508),(638,'Jo Daviess County',3508),(639,'Johnson County',3508),(640,'Kane County',3508),(641,'Kankakee County',3508),(642,'Kendall County',3508),(643,'Knox County',3508),(644,'Lake County',3508),(645,'LaSalle County',3508),(646,'Lawrence County',3508),(647,'Lee County',3508),(648,'Livingston County',3508),(649,'Logan County',3508),(650,'Macon County',3508),(651,'Macoupin County',3508),(652,'Madison County',3508),(653,'Marion County',3508),(654,'Marshall County',3508),(655,'Mason County',3508),(656,'Massac County',3508),(657,'McDonough County',3508),(658,'McHenry County',3508),(659,'McLean County',3508),(660,'Menard County',3508),(661,'Mercer County',3508),(662,'Monroe County',3508),(663,'Montgomery County',3508),(664,'Morgan County',3508),(665,'Moultrie County',3508),(666,'Ogle County',3508),(667,'Peoria County',3508),(668,'Perry County',3508),(669,'Piatt County',3508),(670,'Pike County',3508),(671,'Pope County',3508),(672,'Pulaski County',3508),(673,'Putnam County',3508),(674,'Randolph County',3508),(675,'Richland County',3508),(676,'Rock Island County',3508),(677,'Saint Clair County',3508),(678,'Saline County',3508),(679,'Sangamon County',3508),(680,'Schuyler County',3508),(681,'Scott County',3508),(682,'Shelby County',3508),(683,'Stark County',3508),(684,'Stephenson County',3508),(685,'Tazewell County',3508),(686,'Union County',3508),(687,'Vermilion County',3508),(688,'Wabash County',3508),(689,'Warren County',3508),(690,'Washington County',3508),(691,'Wayne County',3508),(692,'White County',3508),(693,'Whiteside County',3508),(694,'Will County',3508),(695,'Williamson County',3508),(696,'Winnebago County',3508),(697,'Woodford County',3508),(698,'Adams County',3509),(699,'Allen County',3509),(700,'Bartholomew County',3509),(701,'Benton County',3509),(702,'Blackford County',3509),(703,'Boone County',3509),(704,'Brown County',3509),(705,'Carroll County',3509),(706,'Cass County',3509),(707,'Clark County',3509),(708,'Clay County',3509),(709,'Clinton County',3509),(710,'Crawford County',3509),(711,'Daviess County',3509),(712,'Dearborn County',3509),(713,'Decatur County',3509),(714,'DeKalb County',3509),(715,'Delaware County',3509),(716,'Dubois County',3509),(717,'Elkhart County',3509),(718,'Fayette County',3509),(719,'Floyd County',3509),(720,'Fountain County',3509),(721,'Franklin County',3509),(722,'Fulton County',3509),(723,'Gibson County',3509),(724,'Grant County',3509),(725,'Greene County',3509),(726,'Hamilton County',3509),(727,'Hancock County',3509),(728,'Harrison County',3509),(729,'Hendricks County',3509),(730,'Henry County',3509),(731,'Howard County',3509),(732,'Huntington County',3509),(733,'Jackson County',3509),(734,'Jasper County',3509),(735,'Jay County',3509),(736,'Jefferson County',3509),(737,'Jennings County',3509),(738,'Johnson County',3509),(739,'Knox County',3509),(740,'Kosciusko County',3509),(741,'LaGrange County',3509),(742,'Lake County',3509),(743,'LaPorte County',3509),(744,'Lawrence County',3509),(745,'Madison County',3509),(746,'Marion County',3509),(747,'Marshall County',3509),(748,'Martin County',3509),(749,'Miami County',3509),(750,'Monroe County',3509),(751,'Montgomery County',3509),(752,'Morgan County',3509),(753,'Newton County',3509),(754,'Noble County',3509),(755,'Ohio County',3509),(756,'Orange County',3509),(757,'Owen County',3509),(758,'Parke County',3509),(759,'Perry County',3509),(760,'Pike County',3509),(761,'Porter County',3509),(762,'Posey County',3509),(763,'Pulaski County',3509),(764,'Putnam County',3509),(765,'Randolph County',3509),(766,'Ripley County',3509),(767,'Rush County',3509),(768,'Saint Joseph County',3509),(769,'Scott County',3509),(770,'Shelby County',3509),(771,'Spencer County',3509),(772,'Starke County',3509),(773,'Steuben County',3509),(774,'Sullivan County',3509),(775,'Switzerland County',3509),(776,'Tippecanoe County',3509),(777,'Tipton County',3509),(778,'Union County',3509),(779,'Vanderburgh County',3509),(780,'Vermillion County',3509),(781,'Vigo County',3509),(782,'Wabash County',3509),(783,'Warren County',3509),(784,'Warrick County',3509),(785,'Washington County',3509),(786,'Wayne County',3509),(787,'Wells County',3509),(788,'White County',3509),(789,'Whitley County',3509),(790,'Adair County',3510),(791,'Adams County',3510),(792,'Allamakee County',3510),(793,'Appanoose County',3510),(794,'Audubon County',3510),(795,'Benton County',3510),(796,'Black Hawk County',3510),(797,'Boone County',3510),(798,'Bremer County',3510),(799,'Buchanan County',3510),(800,'Buena Vista County',3510),(801,'Butler County',3510),(802,'Calhoun County',3510),(803,'Carroll County',3510),(804,'Cass County',3510),(805,'Cedar County',3510),(806,'Cerro Gordo County',3510),(807,'Cherokee County',3510),(808,'Chickasaw County',3510),(809,'Clarke County',3510),(810,'Clay County',3510),(811,'Clayton County',3510),(812,'Clinton County',3510),(813,'Crawford County',3510),(814,'Dallas County',3510),(815,'Davis County',3510),(816,'Decatur County',3510),(817,'Delaware County',3510),(818,'Des Moines County',3510),(819,'Dickinson County',3510),(820,'Dubuque County',3510),(821,'Emmet County',3510),(822,'Fayette County',3510),(823,'Floyd County',3510),(824,'Franklin County',3510),(825,'Fremont County',3510),(826,'Greene County',3510),(827,'Grundy County',3510),(828,'Guthrie County',3510),(829,'Hamilton County',3510),(830,'Hancock County',3510),(831,'Hardin County',3510),(832,'Harrison County',3510),(833,'Henry County',3510),(834,'Howard County',3510),(835,'Humboldt County',3510),(836,'Ida County',3510),(837,'Iowa County',3510),(838,'Jackson County',3510),(839,'Jasper County',3510),(840,'Jefferson County',3510),(841,'Johnson County',3510),(842,'Jones County',3510),(843,'Keokuk County',3510),(844,'Kossuth County',3510),(845,'Lee County',3510),(846,'Linn County',3510),(847,'Louisa County',3510),(848,'Lucas County',3510),(849,'Lyon County',3510),(850,'Madison County',3510),(851,'Mahaska County',3510),(852,'Marion County',3510),(853,'Marshall County',3510),(854,'Mills County',3510),(855,'Mitchell County',3510),(856,'Monona County',3510),(857,'Monroe County',3510),(858,'Montgomery County',3510),(859,'Muscatine County',3510),(860,'O\'Brien County',3510),(861,'Osceola County',3510),(862,'Page County',3510),(863,'Palo Alto County',3510),(864,'Plymouth County',3510),(865,'Pocahontas County',3510),(866,'Polk County',3510),(867,'Pottawattamie County',3510),(868,'Poweshiek County',3510),(869,'Ringgold County',3510),(870,'Sac County',3510),(871,'Scott County',3510),(872,'Shelby County',3510),(873,'Sioux County',3510),(874,'Story County',3510),(875,'Tama County',3510),(876,'Taylor County',3510),(877,'Union County',3510),(878,'Van Buren County',3510),(879,'Wapello County',3510),(880,'Warren County',3510),(881,'Washington County',3510),(882,'Wayne County',3510),(883,'Webster County',3510),(884,'Winnebago County',3510),(885,'Winneshiek County',3510),(886,'Woodbury County',3510),(887,'Worth County',3510),(888,'Wright County',3510),(964,'Allen County',3511),(965,'Anderson County',3511),(889,'Arkansas County',3511),(890,'Ashley County',3511),(966,'Atchison County',3511),(967,'Barber County',3511),(968,'Barton County',3511),(891,'Baxter County',3511),(892,'Benton County',3511),(893,'Boone County',3511),(969,'Bourbon County',3511),(894,'Bradley County',3511),(970,'Brown County',3511),(971,'Butler County',3511),(895,'Calhoun County',3511),(896,'Carroll County',3511),(972,'Chase County',3511),(973,'Chautauqua County',3511),(974,'Cherokee County',3511),(975,'Cheyenne County',3511),(897,'Chicot County',3511),(898,'Clark County',3511),(899,'Clay County',3511),(900,'Cleburne County',3511),(901,'Cleveland County',3511),(976,'Cloud County',3511),(977,'Coffey County',3511),(902,'Columbia County',3511),(978,'Comanche County',3511),(903,'Conway County',3511),(979,'Cowley County',3511),(904,'Craighead County',3511),(905,'Crawford County',3511),(906,'Crittenden County',3511),(907,'Cross County',3511),(908,'Dallas County',3511),(980,'Decatur County',3511),(909,'Desha County',3511),(981,'Dickinson County',3511),(982,'Doniphan County',3511),(983,'Douglas County',3511),(910,'Drew County',3511),(984,'Edwards County',3511),(985,'Elk County',3511),(986,'Ellis County',3511),(987,'Ellsworth County',3511),(911,'Faulkner County',3511),(988,'Finney County',3511),(989,'Ford County',3511),(912,'Franklin County',3511),(913,'Fulton County',3511),(914,'Garland County',3511),(990,'Geary County',3511),(991,'Gove County',3511),(992,'Graham County',3511),(915,'Grant County',3511),(993,'Gray County',3511),(994,'Greeley County',3511),(916,'Greene County',3511),(995,'Greenwood County',3511),(996,'Hamilton County',3511),(997,'Harper County',3511),(998,'Harvey County',3511),(999,'Haskell County',3511),(917,'Hempstead County',3511),(1000,'Hodgeman County',3511),(918,'Hot Spring County',3511),(919,'Howard County',3511),(920,'Independence County',3511),(921,'Izard County',3511),(922,'Jackson County',3511),(923,'Jefferson County',3511),(1001,'Jewell County',3511),(924,'Johnson County',3511),(1002,'Kearny County',3511),(1003,'Kingman County',3511),(1004,'Kiowa County',3511),(1005,'Labette County',3511),(925,'Lafayette County',3511),(1006,'Lane County',3511),(926,'Lawrence County',3511),(1007,'Leavenworth County',3511),(927,'Lee County',3511),(928,'Lincoln County',3511),(1008,'Linn County',3511),(929,'Little River County',3511),(930,'Logan County',3511),(931,'Lonoke County',3511),(1009,'Lyon County',3511),(932,'Madison County',3511),(933,'Marion County',3511),(1010,'Marshall County',3511),(1011,'McPherson County',3511),(1012,'Meade County',3511),(1013,'Miami County',3511),(934,'Miller County',3511),(935,'Mississippi County',3511),(1014,'Mitchell County',3511),(936,'Monroe County',3511),(937,'Montgomery County',3511),(1015,'Morris County',3511),(1016,'Morton County',3511),(1017,'Nemaha County',3511),(1018,'Neosho County',3511),(1019,'Ness County',3511),(938,'Nevada County',3511),(939,'Newton County',3511),(1020,'Norton County',3511),(1021,'Osage County',3511),(1022,'Osborne County',3511),(1023,'Ottawa County',3511),(940,'Ouachita County',3511),(1024,'Pawnee County',3511),(941,'Perry County',3511),(942,'Phillips County',3511),(943,'Pike County',3511),(944,'Poinsett County',3511),(945,'Polk County',3511),(946,'Pope County',3511),(1025,'Pottawatomie County',3511),(947,'Prairie County',3511),(1026,'Pratt County',3511),(948,'Pulaski County',3511),(949,'Randolph County',3511),(1027,'Rawlins County',3511),(1028,'Reno County',3511),(1029,'Republic County',3511),(1030,'Rice County',3511),(1031,'Riley County',3511),(1032,'Rooks County',3511),(1033,'Rush County',3511),(1034,'Russell County',3511),(950,'Saint Francis County',3511),(951,'Saline County',3511),(952,'Scott County',3511),(953,'Searcy County',3511),(954,'Sebastian County',3511),(1035,'Sedgwick County',3511),(955,'Sevier County',3511),(1036,'Seward County',3511),(956,'Sharp County',3511),(1037,'Shawnee County',3511),(1038,'Sheridan County',3511),(1039,'Sherman County',3511),(1040,'Smith County',3511),(1041,'Stafford County',3511),(1042,'Stanton County',3511),(1043,'Stevens County',3511),(957,'Stone County',3511),(1044,'Sumner County',3511),(1045,'Thomas County',3511),(1046,'Trego County',3511),(958,'Union County',3511),(959,'Van Buren County',3511),(1047,'Wabaunsee County',3511),(1048,'Wallace County',3511),(960,'Washington County',3511),(961,'White County',3511),(1049,'Wichita County',3511),(1050,'Wilson County',3511),(962,'Woodruff County',3511),(1051,'Woodson County',3511),(1052,'Wyandotte County',3511),(963,'Yell County',3511),(1053,'Adair County',3512),(1054,'Allen County',3512),(1055,'Anderson County',3512),(1056,'Ballard County',3512),(1057,'Barren County',3512),(1058,'Bath County',3512),(1059,'Bell County',3512),(1060,'Boone County',3512),(1061,'Bourbon County',3512),(1062,'Boyd County',3512),(1063,'Boyle County',3512),(1064,'Bracken County',3512),(1065,'Breathitt County',3512),(1066,'Breckinridge County',3512),(1067,'Bullitt County',3512),(1068,'Butler County',3512),(1069,'Caldwell County',3512),(1070,'Calloway County',3512),(1071,'Campbell County',3512),(1072,'Carlisle County',3512),(1073,'Carroll County',3512),(1074,'Carter County',3512),(1075,'Casey County',3512),(1076,'Christian County',3512),(1077,'Clark County',3512),(1078,'Clay County',3512),(1079,'Clinton County',3512),(1080,'Crittenden County',3512),(1081,'Cumberland County',3512),(1082,'Daviess County',3512),(1083,'Edmonson County',3512),(1084,'Elliott County',3512),(1085,'Estill County',3512),(1086,'Fayette County',3512),(1087,'Fleming County',3512),(1088,'Floyd County',3512),(1089,'Franklin County',3512),(1090,'Fulton County',3512),(1091,'Gallatin County',3512),(1092,'Garrard County',3512),(1093,'Grant County',3512),(1094,'Graves County',3512),(1095,'Grayson County',3512),(1096,'Green County',3512),(1097,'Greenup County',3512),(1098,'Hancock County',3512),(1099,'Hardin County',3512),(1100,'Harlan County',3512),(1101,'Harrison County',3512),(1102,'Hart County',3512),(1103,'Henderson County',3512),(1104,'Henry County',3512),(1105,'Hickman County',3512),(1106,'Hopkins County',3512),(1107,'Jackson County',3512),(1108,'Jefferson County',3512),(1109,'Jessamine County',3512),(1110,'Johnson County',3512),(1111,'Kenton County',3512),(1112,'Knott County',3512),(1113,'Knox County',3512),(1114,'Larue County',3512),(1115,'Laurel County',3512),(1116,'Lawrence County',3512),(1117,'Lee County',3512),(1118,'Leslie County',3512),(1119,'Letcher County',3512),(1120,'Lewis County',3512),(1121,'Lincoln County',3512),(1122,'Livingston County',3512),(1123,'Logan County',3512),(1124,'Lyon County',3512),(1125,'Madison County',3512),(1126,'Magoffin County',3512),(1127,'Marion County',3512),(1128,'Marshall County',3512),(1129,'Martin County',3512),(1130,'Mason County',3512),(1131,'McCracken County',3512),(1132,'McCreary County',3512),(1133,'McLean County',3512),(1134,'Meade County',3512),(1135,'Menifee County',3512),(1136,'Mercer County',3512),(1137,'Metcalfe County',3512),(1138,'Monroe County',3512),(1139,'Montgomery County',3512),(1140,'Morgan County',3512),(1141,'Muhlenberg County',3512),(1142,'Nelson County',3512),(1143,'Nicholas County',3512),(1144,'Ohio County',3512),(1145,'Oldham County',3512),(1146,'Owen County',3512),(1147,'Owsley County',3512),(1148,'Pendleton County',3512),(1149,'Perry County',3512),(1150,'Pike County',3512),(1151,'Powell County',3512),(1152,'Pulaski County',3512),(1153,'Robertson County',3512),(1154,'Rockcastle County',3512),(1155,'Rowan County',3512),(1156,'Russell County',3512),(1157,'Scott County',3512),(1158,'Shelby County',3512),(1159,'Simpson County',3512),(1160,'Spencer County',3512),(1161,'Taylor County',3512),(1162,'Todd County',3512),(1163,'Trigg County',3512),(1164,'Trimble County',3512),(1165,'Union County',3512),(1166,'Warren County',3512),(1167,'Washington County',3512),(1168,'Wayne County',3512),(1169,'Webster County',3512),(1170,'Whitley County',3512),(1171,'Wolfe County',3512),(1172,'Woodford County',3512),(1173,'Acadia Parish',3513),(1174,'Allen Parish',3513),(1175,'Ascension Parish',3513),(1176,'Assumption Parish',3513),(1177,'Avoyelles Parish',3513),(1178,'Beauregard Parish',3513),(1179,'Bienville Parish',3513),(1180,'Bossier Parish',3513),(1181,'Caddo Parish',3513),(1182,'Calcasieu Parish',3513),(1183,'Caldwell Parish',3513),(1184,'Cameron Parish',3513),(1185,'Catahoula Parish',3513),(1186,'Claiborne Parish',3513),(1187,'Concordia Parish',3513),(1188,'De Soto Parish',3513),(1189,'East Baton Rouge Parish',3513),(1190,'East Carroll Parish',3513),(1191,'East Feliciana Parish',3513),(1192,'Evangeline Parish',3513),(1193,'Franklin Parish',3513),(1194,'Grant Parish',3513),(1195,'Iberia Parish',3513),(1196,'Iberville Parish',3513),(1197,'Jackson Parish',3513),(1198,'Jefferson Davis Parish',3513),(1199,'Jefferson Parish',3513),(1200,'La Salle Parish',3513),(1201,'Lafayette Parish',3513),(1202,'Lafourche Parish',3513),(1203,'Lincoln Parish',3513),(1204,'Livingston Parish',3513),(1205,'Madison Parish',3513),(1206,'Morehouse Parish',3513),(1207,'Natchitoches Parish',3513),(1208,'Orleans Parish',3513),(1209,'Ouachita Parish',3513),(1210,'Plaquemines Parish',3513),(1211,'Pointe Coupee Parish',3513),(1212,'Rapides Parish',3513),(1213,'Red River Parish',3513),(1214,'Richland Parish',3513),(1215,'Sabine Parish',3513),(1216,'Saint Bernard Parish',3513),(1217,'Saint Charles Parish',3513),(1218,'Saint Helena Parish',3513),(1219,'Saint James Parish',3513),(1220,'Saint John the Baptist Parish',3513),(1221,'Saint Landry Parish',3513),(1222,'Saint Martin Parish',3513),(1223,'Saint Mary Parish',3513),(1224,'Saint Tammany Parish',3513),(1225,'Tangipahoa Parish',3513),(1226,'Tensas Parish',3513),(1227,'Terrebonne Parish',3513),(1228,'Union Parish',3513),(1229,'Vermilion Parish',3513),(1230,'Vernon Parish',3513),(1231,'Washington Parish',3513),(1232,'Webster Parish',3513),(1233,'West Baton Rouge Parish',3513),(1234,'West Carroll Parish',3513),(1235,'West Feliciana Parish',3513),(1236,'Winn Parish',3513),(1237,'Androscoggin County',3514),(1238,'Aroostook County',3514),(1239,'Cumberland County',3514),(1240,'Franklin County',3514),(1241,'Hancock County',3514),(1242,'Kennebec County',3514),(1243,'Knox County',3514),(1244,'Lincoln County',3514),(1245,'Oxford County',3514),(1246,'Penobscot County',3514),(1247,'Piscataquis County',3514),(1248,'Sagadahoc County',3514),(1249,'Somerset County',3514),(1250,'Waldo County',3514),(1251,'Washington County',3514),(1252,'York County',3514),(1253,'Allegany County',3515),(1254,'Anne Arundel County',3515),(1255,'Baltimore County',3515),(1256,'Calvert County',3515),(1257,'Caroline County',3515),(1258,'Carroll County',3515),(1259,'Cecil County',3515),(1260,'Charles County',3515),(1261,'City of Baltimore',3515),(1262,'Dorchester County',3515),(1263,'Frederick County',3515),(1264,'Garrett County',3515),(1265,'Harford County',3515),(1266,'Howard County',3515),(1267,'Kent County',3515),(1268,'Montgomery County',3515),(1269,'Prince George\'s County',3515),(1270,'Queen Anne\'s County',3515),(1271,'Saint Mary\'s County',3515),(1272,'Somerset County',3515),(1273,'Talbot County',3515),(1274,'Washington County',3515),(1275,'Wicomico County',3515),(1276,'Worcester County',3515),(1277,'Barnstable County',3516),(1278,'Berkshire County',3516),(1279,'Bristol County',3516),(1280,'Dukes County',3516),(1281,'Essex County',3516),(1282,'Franklin County',3516),(1283,'Hampden County',3516),(1284,'Hampshire County',3516),(1285,'Middlesex County',3516),(1286,'Nantucket County',3516),(1287,'Norfolk County',3516),(1288,'Plymouth County',3516),(1289,'Suffolk County',3516),(1290,'Worcester County',3516),(1291,'Alcona County',3517),(1292,'Alger County',3517),(1293,'Allegan County',3517),(1294,'Alpena County',3517),(1295,'Antrim County',3517),(1296,'Arenac County',3517),(1297,'Baraga County',3517),(1298,'Barry County',3517),(1299,'Bay County',3517),(1300,'Benzie County',3517),(1301,'Berrien County',3517),(1302,'Branch County',3517),(1303,'Calhoun County',3517),(1304,'Cass County',3517),(1305,'Charlevoix County',3517),(1306,'Cheboygan County',3517),(1307,'Chippewa County',3517),(1308,'Clare County',3517),(1309,'Clinton County',3517),(1310,'Crawford County',3517),(1311,'Delta County',3517),(1312,'Dickinson County',3517),(1313,'Eaton County',3517),(1314,'Emmet County',3517),(1315,'Genesee County',3517),(1316,'Gladwin County',3517),(1317,'Gogebic County',3517),(1318,'Grand Traverse County',3517),(1319,'Gratiot County',3517),(1320,'Hillsdale County',3517),(1321,'Houghton County',3517),(1322,'Huron County',3517),(1323,'Ingham County',3517),(1324,'Ionia County',3517),(1325,'Iosco County',3517),(1326,'Iron County',3517),(1327,'Isabella County',3517),(1328,'Jackson County',3517),(1329,'Kalamazoo County',3517),(1330,'Kalkaska County',3517),(1331,'Kent County',3517),(1332,'Keweenaw County',3517),(1333,'Lake County',3517),(1334,'Lapeer County',3517),(1335,'Leelanau County',3517),(1336,'Lenawee County',3517),(1337,'Livingston County',3517),(1338,'Luce County',3517),(1339,'Mackinac County',3517),(1340,'Macomb County',3517),(1341,'Manistee County',3517),(1342,'Marquette County',3517),(1343,'Mason County',3517),(1344,'Mecosta County',3517),(1345,'Menominee County',3517),(1346,'Midland County',3517),(1347,'Missaukee County',3517),(1348,'Monroe County',3517),(1349,'Montcalm County',3517),(1350,'Montmorency County',3517),(1351,'Muskegon County',3517),(1352,'Newaygo County',3517),(1353,'Oakland County',3517),(1354,'Oceana County',3517),(1355,'Ogemaw County',3517),(1356,'Ontonagon County',3517),(1357,'Osceola County',3517),(1358,'Oscoda County',3517),(1359,'Otsego County',3517),(1360,'Ottawa County',3517),(1361,'Presque Isle County',3517),(1362,'Roscommon County',3517),(1363,'Saginaw County',3517),(1364,'Saint Clair County',3517),(1365,'Saint Joseph County',3517),(1366,'Sanilac County',3517),(1367,'Schoolcraft County',3517),(1368,'Shiawassee County',3517),(1369,'Tuscola County',3517),(1370,'Van Buren County',3517),(1371,'Washtenaw County',3517),(1372,'Wayne County',3517),(1373,'Wexford County',3517),(1374,'Aitkin County',3518),(1375,'Anoka County',3518),(1376,'Becker County',3518),(1377,'Beltrami County',3518),(1378,'Benton County',3518),(1379,'Big Stone County',3518),(1380,'Blue Earth County',3518),(1381,'Brown County',3518),(1382,'Carlton County',3518),(1383,'Carver County',3518),(1384,'Cass County',3518),(1385,'Chippewa County',3518),(1386,'Chisago County',3518),(1387,'Clay County',3518),(1388,'Clearwater County',3518),(1389,'Cook County',3518),(1390,'Cottonwood County',3518),(1391,'Crow Wing County',3518),(1392,'Dakota County',3518),(1393,'Dodge County',3518),(1394,'Douglas County',3518),(1395,'Faribault County',3518),(1396,'Fillmore County',3518),(1397,'Freeborn County',3518),(1398,'Goodhue County',3518),(1399,'Grant County',3518),(1400,'Hennepin County',3518),(1401,'Houston County',3518),(1402,'Hubbard County',3518),(1403,'Isanti County',3518),(1404,'Itasca County',3518),(1405,'Jackson County',3518),(1406,'Kanabec County',3518),(1407,'Kandiyohi County',3518),(1408,'Kittson County',3518),(1409,'Koochiching County',3518),(1410,'Lac qui Parle County',3518),(1411,'Lake County',3518),(1412,'Lake of the Woods County',3518),(1413,'Le Sueur County',3518),(1414,'Lincoln County',3518),(1415,'Lyon County',3518),(1416,'Mahnomen County',3518),(1417,'Marshall County',3518),(1418,'Martin County',3518),(1419,'McLeod County',3518),(1420,'Meeker County',3518),(1421,'Mille Lacs County',3518),(1422,'Morrison County',3518),(1423,'Mower County',3518),(1424,'Murray County',3518),(1425,'Nicollet County',3518),(1426,'Nobles County',3518),(1427,'Norman County',3518),(1428,'Olmsted County',3518),(1429,'Otter Tail County',3518),(1430,'Pennington County',3518),(1431,'Pine County',3518),(1432,'Pipestone County',3518),(1433,'Polk County',3518),(1434,'Pope County',3518),(1435,'Ramsey County',3518),(1436,'Red Lake County',3518),(1437,'Redwood County',3518),(1438,'Renville County',3518),(1439,'Rice County',3518),(1440,'Rock County',3518),(1441,'Roseau County',3518),(1442,'Saint Louis County',3518),(1443,'Scott County',3518),(1444,'Sherburne County',3518),(1445,'Sibley County',3518),(1446,'Stearns County',3518),(1447,'Steele County',3518),(1448,'Stevens County',3518),(1449,'Swift County',3518),(1450,'Todd County',3518),(1451,'Traverse County',3518),(1452,'Wabasha County',3518),(1453,'Wadena County',3518),(1454,'Waseca County',3518),(1455,'Washington County',3518),(1456,'Watonwan County',3518),(1457,'Wilkin County',3518),(1458,'Winona County',3518),(1459,'Wright County',3518),(1460,'Yellow Medicine County',3518),(1461,'Adams County',3519),(1462,'Alcorn County',3519),(1463,'Amite County',3519),(1464,'Attala County',3519),(1465,'Benton County',3519),(1466,'Bolivar County',3519),(1467,'Calhoun County',3519),(1468,'Carroll County',3519),(1469,'Chickasaw County',3519),(1470,'Choctaw County',3519),(1471,'Claiborne County',3519),(1472,'Clarke County',3519),(1473,'Clay County',3519),(1474,'Coahoma County',3519),(1475,'Copiah County',3519),(1476,'Covington County',3519),(1477,'De Soto County',3519),(1478,'Forrest County',3519),(1479,'Franklin County',3519),(1480,'George County',3519),(1481,'Greene County',3519),(1482,'Grenada County',3519),(1483,'Hancock County',3519),(1484,'Harrison County',3519),(1485,'Hinds County',3519),(1486,'Holmes County',3519),(1487,'Humphreys County',3519),(1488,'Issaquena County',3519),(1489,'Itawamba County',3519),(1490,'Jackson County',3519),(1491,'Jasper County',3519),(1492,'Jefferson County',3519),(1493,'Jefferson Davis County',3519),(1494,'Jones County',3519),(1495,'Kemper County',3519),(1496,'Lafayette County',3519),(1497,'Lamar County',3519),(1498,'Lauderdale County',3519),(1499,'Lawrence County',3519),(1500,'Leake County',3519),(1501,'Lee County',3519),(1502,'Leflore County',3519),(1503,'Lincoln County',3519),(1504,'Lowndes County',3519),(1505,'Madison County',3519),(1506,'Marion County',3519),(1507,'Marshall County',3519),(1508,'Monroe County',3519),(1509,'Montgomery County',3519),(1510,'Neshoba County',3519),(1511,'Newton County',3519),(1512,'Noxubee County',3519),(1513,'Oktibbeha County',3519),(1514,'Panola County',3519),(1515,'Pearl River County',3519),(1516,'Perry County',3519),(1517,'Pike County',3519),(1518,'Pontotoc County',3519),(1519,'Prentiss County',3519),(1520,'Quitman County',3519),(1521,'Rankin County',3519),(1522,'Scott County',3519),(1523,'Sharkey County',3519),(1524,'Simpson County',3519),(1525,'Smith County',3519),(1526,'Stone County',3519),(1527,'Sunflower County',3519),(1528,'Tallahatchie County',3519),(1529,'Tate County',3519),(1530,'Tippah County',3519),(1531,'Tishomingo County',3519),(1532,'Tunica County',3519),(1533,'Union County',3519),(1534,'Walthall County',3519),(1535,'Warren County',3519),(1536,'Washington County',3519),(1537,'Wayne County',3519),(1538,'Webster County',3519),(1539,'Wilkinson County',3519),(1540,'Winston County',3519),(1541,'Yalobusha County',3519),(1542,'Yazoo County',3519),(1543,'Adair County',3520),(1544,'Andrew County',3520),(1545,'Atchison County',3520),(1546,'Audrain County',3520),(1547,'Barry County',3520),(1548,'Barton County',3520),(1549,'Bates County',3520),(1550,'Benton County',3520),(1551,'Bollinger County',3520),(1552,'Boone County',3520),(1553,'Buchanan County',3520),(1554,'Butler County',3520),(1555,'Caldwell County',3520),(1556,'Callaway County',3520),(1557,'Camden County',3520),(1558,'Cape Girardeau County',3520),(1559,'Carroll County',3520),(1560,'Carter County',3520),(1561,'Cass County',3520),(1562,'Cedar County',3520),(1563,'Chariton County',3520),(1564,'Christian County',3520),(1565,'City of Saint Louis',3520),(1566,'Clark County',3520),(1567,'Clay County',3520),(1568,'Clinton County',3520),(1569,'Cole County',3520),(1570,'Cooper County',3520),(1571,'Crawford County',3520),(1572,'Dade County',3520),(1573,'Dallas County',3520),(1574,'Daviess County',3520),(1575,'DeKalb County',3520),(1576,'Dent County',3520),(1577,'Douglas County',3520),(1578,'Dunklin County',3520),(1579,'Franklin County',3520),(1580,'Gasconade County',3520),(1581,'Gentry County',3520),(1582,'Greene County',3520),(1583,'Grundy County',3520),(1584,'Harrison County',3520),(1585,'Henry County',3520),(1586,'Hickory County',3520),(1587,'Holt County',3520),(1588,'Howard County',3520),(1589,'Howell County',3520),(1590,'Iron County',3520),(1591,'Jackson County',3520),(1592,'Jasper County',3520),(1593,'Jefferson County',3520),(1594,'Johnson County',3520),(1595,'Knox County',3520),(1596,'Laclede County',3520),(1597,'Lafayette County',3520),(1598,'Lawrence County',3520),(1599,'Lewis County',3520),(1600,'Lincoln County',3520),(1601,'Linn County',3520),(1602,'Livingston County',3520),(1603,'Macon County',3520),(1604,'Madison County',3520),(1605,'Maries County',3520),(1606,'Marion County',3520),(1607,'McDonald County',3520),(1608,'Mercer County',3520),(1609,'Miller County',3520),(1610,'Mississippi County',3520),(1611,'Moniteau County',3520),(1612,'Monroe County',3520),(1613,'Montgomery County',3520),(1614,'Morgan County',3520),(1615,'New Madrid County',3520),(1616,'Newton County',3520),(1617,'Nodaway County',3520),(1618,'Oregon County',3520),(1619,'Osage County',3520),(1620,'Ozark County',3520),(1621,'Pemiscot County',3520),(1622,'Perry County',3520),(1623,'Pettis County',3520),(1624,'Phelps County',3520),(1625,'Pike County',3520),(1626,'Platte County',3520),(1627,'Polk County',3520),(1628,'Pulaski County',3520),(1629,'Putnam County',3520),(1630,'Ralls County',3520),(1631,'Randolph County',3520),(1632,'Ray County',3520),(1633,'Reynolds County',3520),(1634,'Ripley County',3520),(1635,'Saint Charles County',3520),(1636,'Saint Clair County',3520),(1637,'Saint Francois County',3520),(1638,'Saint Louis County',3520),(1639,'Sainte Genevieve County',3520),(1640,'Saline County',3520),(1641,'Schuyler County',3520),(1642,'Scotland County',3520),(1643,'Scott County',3520),(1644,'Shannon County',3520),(1645,'Shelby County',3520),(1646,'Stoddard County',3520),(1647,'Stone County',3520),(1648,'Sullivan County',3520),(1649,'Taney County',3520),(1650,'Texas County',3520),(1651,'Vernon County',3520),(1652,'Warren County',3520),(1653,'Washington County',3520),(1654,'Wayne County',3520),(1655,'Webster County',3520),(1656,'Worth County',3520),(1657,'Wright County',3520),(1658,'Beaverhead County',3521),(1659,'Big Horn County',3521),(1660,'Blaine County',3521),(1661,'Broadwater County',3521),(1662,'Carbon County',3521),(1663,'Carter County',3521),(1664,'Cascade County',3521),(1665,'Chouteau County',3521),(1666,'Custer County',3521),(1667,'Daniels County',3521),(1668,'Dawson County',3521),(1669,'Deer Lodge County',3521),(1670,'Fallon County',3521),(1671,'Fergus County',3521),(1672,'Flathead County',3521),(1673,'Gallatin County',3521),(1674,'Garfield County',3521),(1675,'Glacier County',3521),(1676,'Golden Valley County',3521),(1677,'Granite County',3521),(1678,'Hill County',3521),(1679,'Jefferson County',3521),(1680,'Judith Basin County',3521),(1681,'Lake County',3521),(1682,'Lewis and Clark County',3521),(1683,'Liberty County',3521),(1684,'Lincoln County',3521),(1685,'Madison County',3521),(1686,'McCone County',3521),(1687,'Meagher County',3521),(1688,'Mineral County',3521),(1689,'Missoula County',3521),(1690,'Musselshell County',3521),(1691,'Park County',3521),(1692,'Petroleum County',3521),(1693,'Phillips County',3521),(1694,'Pondera County',3521),(1695,'Powder River County',3521),(1696,'Powell County',3521),(1697,'Prairie County',3521),(1698,'Ravalli County',3521),(1699,'Richland County',3521),(1700,'Roosevelt County',3521),(1701,'Rosebud County',3521),(1702,'Sanders County',3521),(1703,'Sheridan County',3521),(1704,'Silver Bow County',3521),(1705,'Stillwater County',3521),(1706,'Sweet Grass County',3521),(1707,'Teton County',3521),(1708,'Toole County',3521),(1709,'Treasure County',3521),(1710,'Valley County',3521),(1711,'Wheatland County',3521),(1712,'Wibaux County',3521),(1713,'Yellowstone County',3521),(1714,'Adams County',3522),(1715,'Antelope County',3522),(1716,'Arthur County',3522),(1717,'Banner County',3522),(1718,'Blaine County',3522),(1719,'Boone County',3522),(1720,'Box Butte County',3522),(1721,'Boyd County',3522),(1722,'Brown County',3522),(1723,'Buffalo County',3522),(1724,'Burt County',3522),(1725,'Butler County',3522),(1726,'Cass County',3522),(1727,'Cedar County',3522),(1728,'Chase County',3522),(1729,'Cherry County',3522),(1730,'Cheyenne County',3522),(1731,'Clay County',3522),(1732,'Colfax County',3522),(1733,'Cuming County',3522),(1734,'Custer County',3522),(1735,'Dakota County',3522),(1736,'Dawes County',3522),(1737,'Dawson County',3522),(1738,'Deuel County',3522),(1739,'Dixon County',3522),(1740,'Dodge County',3522),(1741,'Douglas County',3522),(1742,'Dundy County',3522),(1743,'Fillmore County',3522),(1744,'Franklin County',3522),(1745,'Frontier County',3522),(1746,'Furnas County',3522),(1747,'Gage County',3522),(1748,'Garden County',3522),(1749,'Garfield County',3522),(1750,'Gosper County',3522),(1751,'Grant County',3522),(1752,'Greeley County',3522),(1753,'Hall County',3522),(1754,'Hamilton County',3522),(1755,'Harlan County',3522),(1756,'Hayes County',3522),(1757,'Hitchcock County',3522),(1758,'Holt County',3522),(1759,'Hooker County',3522),(1760,'Howard County',3522),(1761,'Jefferson County',3522),(1762,'Johnson County',3522),(1763,'Kearney County',3522),(1764,'Keith County',3522),(1765,'Keya Paha County',3522),(1766,'Kimball County',3522),(1767,'Knox County',3522),(1768,'Lancaster County',3522),(1769,'Lincoln County',3522),(1770,'Logan County',3522),(1771,'Loup County',3522),(1772,'Madison County',3522),(1773,'McPherson County',3522),(1774,'Merrick County',3522),(1775,'Morrill County',3522),(1776,'Nance County',3522),(1777,'Nemaha County',3522),(1778,'Nuckolls County',3522),(1779,'Otoe County',3522),(1780,'Pawnee County',3522),(1781,'Perkins County',3522),(1782,'Phelps County',3522),(1783,'Pierce County',3522),(1784,'Platte County',3522),(1785,'Polk County',3522),(1786,'Red Willow County',3522),(1787,'Richardson County',3522),(1788,'Rock County',3522),(1789,'Saline County',3522),(1790,'Sarpy County',3522),(1791,'Saunders County',3522),(1792,'Scotts Bluff County',3522),(1793,'Seward County',3522),(1794,'Sheridan County',3522),(1795,'Sherman County',3522),(1796,'Sioux County',3522),(1797,'Stanton County',3522),(1798,'Thayer County',3522),(1799,'Thomas County',3522),(1800,'Thurston County',3522),(1801,'Valley County',3522),(1802,'Washington County',3522),(1803,'Wayne County',3522),(1804,'Webster County',3522),(1805,'Wheeler County',3522),(1806,'York County',3522),(1807,'Carson City',3523),(1808,'Churchill County',3523),(1809,'Clark County',3523),(1810,'Douglas County',3523),(1811,'Elko County',3523),(1812,'Esmeralda County',3523),(1813,'Eureka County',3523),(1814,'Humboldt County',3523),(1815,'Lander County',3523),(1816,'Lincoln County',3523),(1817,'Lyon County',3523),(1818,'Mineral County',3523),(1819,'Nye County',3523),(1820,'Pershing County',3523),(1821,'Storey County',3523),(1822,'Washoe County',3523),(1823,'White Pine County',3523),(1824,'Belknap County',3524),(1825,'Carroll County',3524),(1826,'Cheshire County',3524),(1827,'Coos County',3524),(1828,'Grafton County',3524),(1829,'Hillsborough County',3524),(1830,'Merrimack County',3524),(1831,'Rockingham County',3524),(1832,'Strafford County',3524),(1833,'Sullivan County',3524),(1834,'Atlantic County',3525),(1835,'Bergen County',3525),(1836,'Burlington County',3525),(1837,'Camden County',3525),(1838,'Cape May County',3525),(1839,'Cumberland County',3525),(1840,'Essex County',3525),(1841,'Gloucester County',3525),(1842,'Hudson County',3525),(1843,'Hunterdon County',3525),(1844,'Mercer County',3525),(1845,'Middlesex County',3525),(1846,'Monmouth County',3525),(1847,'Morris County',3525),(1848,'Ocean County',3525),(1849,'Passaic County',3525),(1850,'Salem County',3525),(1851,'Somerset County',3525),(1852,'Sussex County',3525),(1853,'Union County',3525),(1854,'Warren County',3525),(1855,'Bernalillo County',3526),(1856,'Catron County',3526),(1857,'Chaves County',3526),(1858,'Cibola County',3526),(1859,'Colfax County',3526),(1860,'Curry County',3526),(1861,'De Baca County',3526),(1862,'Dona Ana County',3526),(1863,'Eddy County',3526),(1864,'Grant County',3526),(1865,'Guadalupe County',3526),(1866,'Harding County',3526),(1867,'Hidalgo County',3526),(1868,'Lea County',3526),(1869,'Lincoln County',3526),(1870,'Los Alamos County',3526),(1871,'Luna County',3526),(1872,'McKinley County',3526),(1873,'Mora County',3526),(1874,'Otero County',3526),(1875,'Quay County',3526),(1876,'Rio Arriba County',3526),(1877,'Roosevelt County',3526),(1878,'San Juan County',3526),(1879,'San Miguel County',3526),(1880,'Sandoval County',3526),(1881,'Santa Fe County',3526),(1882,'Sierra County',3526),(1883,'Socorro County',3526),(1884,'Taos County',3526),(1885,'Torrance County',3526),(1886,'Union County',3526),(1887,'Valencia County',3526),(1888,'Albany County',3527),(1889,'Allegany County',3527),(1890,'Bronx',3527),(1891,'Broome County',3527),(1892,'Cattaraugus County',3527),(1893,'Cayuga County',3527),(1894,'Chautauqua County',3527),(1895,'Chemung County',3527),(1896,'Chenango County',3527),(1897,'Clinton County',3527),(1898,'Columbia County',3527),(1899,'Cortland County',3527),(1900,'Delaware County',3527),(1901,'Dutchess County',3527),(1902,'Erie County',3527),(1903,'Essex County',3527),(1904,'Franklin County',3527),(1905,'Fulton County',3527),(1906,'Genesee County',3527),(1907,'Greene County',3527),(1908,'Hamilton County',3527),(1909,'Herkimer County',3527),(1910,'Jefferson County',3527),(1911,'Kings County',3527),(1912,'Lewis County',3527),(1913,'Livingston County',3527),(1914,'Madison County',3527),(1915,'Monroe County',3527),(1916,'Montgomery County',3527),(1917,'Nassau County',3527),(1918,'New York County',3527),(1919,'Niagara County',3527),(1920,'Oneida County',3527),(1921,'Onondaga County',3527),(1922,'Ontario County',3527),(1923,'Orange County',3527),(1924,'Orleans County',3527),(1925,'Oswego County',3527),(1926,'Otsego County',3527),(1927,'Putnam County',3527),(1928,'Queens County',3527),(1929,'Rensselaer County',3527),(1930,'Richmond County',3527),(1931,'Rockland County',3527),(1932,'Saratoga County',3527),(1933,'Schenectady County',3527),(1934,'Schoharie County',3527),(1935,'Schuyler County',3527),(1936,'Seneca County',3527),(1937,'St. Lawrence County',3527),(1938,'Steuben County',3527),(1939,'Suffolk County',3527),(1940,'Sullivan County',3527),(1941,'Tioga County',3527),(1942,'Tompkins County',3527),(1943,'Ulster County',3527),(1944,'Warren County',3527),(1945,'Washington County',3527),(1946,'Wayne County',3527),(1947,'Westchester County',3527),(1948,'Wyoming County',3527),(1949,'Yates County',3527),(1950,'Alamance County',3528),(1951,'Alexander County',3528),(1952,'Alleghany County',3528),(1953,'Anson County',3528),(1954,'Ashe County',3528),(1955,'Avery County',3528),(1956,'Beaufort County',3528),(1957,'Bertie County',3528),(1958,'Bladen County',3528),(1959,'Brunswick County',3528),(1960,'Buncombe County',3528),(1961,'Burke County',3528),(1962,'Cabarrus County',3528),(1963,'Caldwell County',3528),(1964,'Camden County',3528),(1965,'Carteret County',3528),(1966,'Caswell County',3528),(1967,'Catawba County',3528),(1968,'Chatham County',3528),(1969,'Cherokee County',3528),(1970,'Chowan County',3528),(1971,'Clay County',3528),(1972,'Cleveland County',3528),(1973,'Columbus County',3528),(1974,'Craven County',3528),(1975,'Cumberland County',3528),(1976,'Currituck County',3528),(1977,'Dare County',3528),(1978,'Davidson County',3528),(1979,'Davie County',3528),(1980,'Duplin County',3528),(1981,'Durham County',3528),(1982,'Edgecombe County',3528),(1983,'Forsyth County',3528),(1984,'Franklin County',3528),(1985,'Gaston County',3528),(1986,'Gates County',3528),(1987,'Graham County',3528),(1988,'Granville County',3528),(1989,'Greene County',3528),(1990,'Guilford County',3528),(1991,'Halifax County',3528),(1992,'Harnett County',3528),(1993,'Haywood County',3528),(1994,'Henderson County',3528),(1995,'Hertford County',3528),(1996,'Hoke County',3528),(1997,'Hyde County',3528),(1998,'Iredell County',3528),(1999,'Jackson County',3528),(2000,'Johnston County',3528),(2001,'Jones County',3528),(2002,'Lee County',3528),(2003,'Lenoir County',3528),(2004,'Lincoln County',3528),(2005,'Macon County',3528),(2006,'Madison County',3528),(2007,'Martin County',3528),(2008,'McDowell County',3528),(2009,'Mecklenburg County',3528),(2010,'Mitchell County',3528),(2011,'Montgomery County',3528),(2012,'Moore County',3528),(2013,'Nash County',3528),(2014,'New Hanover County',3528),(2015,'Northampton County',3528),(2016,'Onslow County',3528),(2017,'Orange County',3528),(2018,'Pamlico County',3528),(2019,'Pasquotank County',3528),(2020,'Pender County',3528),(2021,'Perquimans County',3528),(2022,'Person County',3528),(2023,'Pitt County',3528),(2024,'Polk County',3528),(2025,'Randolph County',3528),(2026,'Richmond County',3528),(2027,'Robeson County',3528),(2028,'Rockingham County',3528),(2029,'Rowan County',3528),(2030,'Rutherford County',3528),(2031,'Sampson County',3528),(2032,'Scotland County',3528),(2033,'Stanly County',3528),(2034,'Stokes County',3528),(2035,'Surry County',3528),(2036,'Swain County',3528),(2037,'Transylvania County',3528),(2038,'Tyrrell County',3528),(2039,'Union County',3528),(2040,'Vance County',3528),(2041,'Wake County',3528),(2042,'Warren County',3528),(2043,'Washington County',3528),(2044,'Watauga County',3528),(2045,'Wayne County',3528),(2046,'Wilkes County',3528),(2047,'Wilson County',3528),(2048,'Yadkin County',3528),(2049,'Yancey County',3528),(2050,'Adams County',3529),(2051,'Barnes County',3529),(2052,'Benson County',3529),(2053,'Billings County',3529),(2054,'Bottineau County',3529),(2055,'Bowman County',3529),(2056,'Burke County',3529),(2057,'Burleigh County',3529),(2058,'Cass County',3529),(2059,'Cavalier County',3529),(2060,'Dickey County',3529),(2061,'Divide County',3529),(2062,'Dunn County',3529),(2063,'Eddy County',3529),(2064,'Emmons County',3529),(2065,'Foster County',3529),(2066,'Golden Valley County',3529),(2067,'Grand Forks County',3529),(2068,'Grant County',3529),(2069,'Griggs County',3529),(2070,'Hettinger County',3529),(2071,'Kidder County',3529),(2072,'LaMoure County',3529),(2073,'Logan County',3529),(2074,'McHenry County',3529),(2075,'McIntosh County',3529),(2076,'McKenzie County',3529),(2077,'McLean County',3529),(2078,'Mercer County',3529),(2079,'Morton County',3529),(2080,'Mountrail County',3529),(2081,'Nelson County',3529),(2082,'Oliver County',3529),(2083,'Pembina County',3529),(2084,'Pierce County',3529),(2085,'Ramsey County',3529),(2086,'Ransom County',3529),(2087,'Renville County',3529),(2088,'Richland County',3529),(2089,'Rolette County',3529),(2090,'Sargent County',3529),(2091,'Sheridan County',3529),(2092,'Sioux County',3529),(2093,'Slope County',3529),(2094,'Stark County',3529),(2095,'Steele County',3529),(2096,'Stutsman County',3529),(2097,'Towner County',3529),(2098,'Traill County',3529),(2099,'Walsh County',3529),(2100,'Ward County',3529),(2101,'Wells County',3529),(2102,'Williams County',3529),(2103,'Adams County',3530),(2104,'Allen County',3530),(2105,'Ashland County',3530),(2106,'Ashtabula County',3530),(2107,'Athens County',3530),(2108,'Auglaize County',3530),(2109,'Belmont County',3530),(2110,'Brown County',3530),(2111,'Butler County',3530),(2112,'Carroll County',3530),(2113,'Champaign County',3530),(2114,'Clark County',3530),(2115,'Clermont County',3530),(2116,'Clinton County',3530),(2117,'Columbiana County',3530),(2118,'Coshocton County',3530),(2119,'Crawford County',3530),(2120,'Cuyahoga County',3530),(2121,'Darke County',3530),(2122,'Defiance County',3530),(2123,'Delaware County',3530),(2124,'Erie County',3530),(2125,'Fairfield County',3530),(2126,'Fayette County',3530),(2127,'Franklin County',3530),(2128,'Fulton County',3530),(2129,'Gallia County',3530),(2130,'Geauga County',3530),(2131,'Greene County',3530),(2132,'Guernsey County',3530),(2133,'Hamilton County',3530),(2134,'Hancock County',3530),(2135,'Hardin County',3530),(2136,'Harrison County',3530),(2137,'Henry County',3530),(2138,'Highland County',3530),(2139,'Hocking County',3530),(2140,'Holmes County',3530),(2141,'Huron County',3530),(2142,'Jackson County',3530),(2143,'Jefferson County',3530),(2144,'Knox County',3530),(2145,'Lake County',3530),(2146,'Lawrence County',3530),(2147,'Licking County',3530),(2148,'Logan County',3530),(2149,'Lorain County',3530),(2150,'Lucas County',3530),(2151,'Madison County',3530),(2152,'Mahoning County',3530),(2153,'Marion County',3530),(2154,'Medina County',3530),(2155,'Meigs County',3530),(2156,'Mercer County',3530),(2157,'Miami County',3530),(2158,'Monroe County',3530),(2159,'Montgomery County',3530),(2160,'Morgan County',3530),(2161,'Morrow County',3530),(2162,'Muskingum County',3530),(2163,'Noble County',3530),(2164,'Ottawa County',3530),(2165,'Paulding County',3530),(2166,'Perry County',3530),(2167,'Pickaway County',3530),(2168,'Pike County',3530),(2169,'Portage County',3530),(2170,'Preble County',3530),(2171,'Putnam County',3530),(2172,'Richland County',3530),(2173,'Ross County',3530),(2174,'Sandusky County',3530),(2175,'Scioto County',3530),(2176,'Seneca County',3530),(2177,'Shelby County',3530),(2178,'Stark County',3530),(2179,'Summit County',3530),(2180,'Trumbull County',3530),(2181,'Tuscarawas County',3530),(2182,'Union County',3530),(2183,'Van Wert County',3530),(2184,'Vinton County',3530),(2185,'Warren County',3530),(2186,'Washington County',3530),(2187,'Wayne County',3530),(2188,'Williams County',3530),(2189,'Wood County',3530),(2190,'Wyandot County',3530),(2191,'Adair County',3531),(2192,'Alfalfa County',3531),(2193,'Atoka County',3531),(2194,'Beaver County',3531),(2195,'Beckham County',3531),(2196,'Blaine County',3531),(2197,'Bryan County',3531),(2198,'Caddo County',3531),(2199,'Canadian County',3531),(2200,'Carter County',3531),(2201,'Cherokee County',3531),(2202,'Choctaw County',3531),(2203,'Cimarron County',3531),(2204,'Cleveland County',3531),(2205,'Coal County',3531),(2206,'Comanche County',3531),(2207,'Cotton County',3531),(2208,'Craig County',3531),(2209,'Creek County',3531),(2210,'Custer County',3531),(2211,'Delaware County',3531),(2212,'Dewey County',3531),(2213,'Ellis County',3531),(2214,'Garfield County',3531),(2215,'Garvin County',3531),(2216,'Grady County',3531),(2217,'Grant County',3531),(2218,'Greer County',3531),(2219,'Harmon County',3531),(2220,'Harper County',3531),(2221,'Haskell County',3531),(2222,'Hughes County',3531),(2223,'Jackson County',3531),(2224,'Jefferson County',3531),(2225,'Johnston County',3531),(2226,'Kay County',3531),(2227,'Kingfisher County',3531),(2228,'Kiowa County',3531),(2229,'Latimer County',3531),(2230,'Le Flore County',3531),(2231,'Lincoln County',3531),(2232,'Logan County',3531),(2233,'Love County',3531),(2234,'Major County',3531),(2235,'Marshall County',3531),(2236,'Mayes County',3531),(2237,'McClain County',3531),(2238,'McCurtain County',3531),(2239,'McIntosh County',3531),(2240,'Murray County',3531),(2241,'Muskogee County',3531),(2242,'Noble County',3531),(2243,'Nowata County',3531),(2244,'Okfuskee County',3531),(2245,'Oklahoma County',3531),(2246,'Okmulgee County',3531),(2247,'Osage County',3531),(2248,'Ottawa County',3531),(2249,'Pawnee County',3531),(2250,'Payne County',3531),(2251,'Pittsburg County',3531),(2252,'Pontotoc County',3531),(2253,'Pottawatomie County',3531),(2254,'Pushmataha County',3531),(2255,'Roger Mills County',3531),(2256,'Rogers County',3531),(2257,'Seminole County',3531),(2258,'Sequoyah County',3531),(2259,'Stephens County',3531),(2260,'Texas County',3531),(2261,'Tillman County',3531),(2262,'Tulsa County',3531),(2263,'Wagoner County',3531),(2264,'Washington County',3531),(2265,'Washita County',3531),(2266,'Woods County',3531),(2267,'Woodward County',3531),(2268,'Baker County',3532),(2269,'Benton County',3532),(2270,'Clackamas County',3532),(2271,'Clatsop County',3532),(2272,'Columbia County',3532),(2273,'Coos County',3532),(2274,'Crook County',3532),(2275,'Curry County',3532),(2276,'Deschutes County',3532),(2277,'Douglas County',3532),(2278,'Gilliam County',3532),(2279,'Grant County',3532),(2280,'Harney County',3532),(2281,'Hood River County',3532),(2282,'Jackson County',3532),(2283,'Jefferson County',3532),(2284,'Josephine County',3532),(2285,'Klamath County',3532),(2286,'Lake County',3532),(2287,'Lane County',3532),(2288,'Lincoln County',3532),(2289,'Linn County',3532),(2290,'Malheur County',3532),(2291,'Marion County',3532),(2292,'Morrow County',3532),(2293,'Multnomah County',3532),(2294,'Polk County',3532),(2295,'Sherman County',3532),(2296,'Tillamook County',3532),(2297,'Umatilla County',3532),(2298,'Union County',3532),(2299,'Wallowa County',3532),(2300,'Wasco County',3532),(2301,'Washington County',3532),(2302,'Wheeler County',3532),(2303,'Yamhill County',3532),(2304,'Adams County',3533),(2305,'Allegheny County',3533),(2306,'Armstrong County',3533),(2307,'Beaver County',3533),(2308,'Bedford County',3533),(2309,'Berks County',3533),(2310,'Blair County',3533),(2311,'Bradford County',3533),(2312,'Bucks County',3533),(2313,'Butler County',3533),(2314,'Cambria County',3533),(2315,'Cameron County',3533),(2316,'Carbon County',3533),(2317,'Centre County',3533),(2318,'Chester County',3533),(2319,'Clarion County',3533),(2320,'Clearfield County',3533),(2321,'Clinton County',3533),(2322,'Columbia County',3533),(2323,'Crawford County',3533),(2324,'Cumberland County',3533),(2325,'Dauphin County',3533),(2326,'Delaware County',3533),(2327,'Elk County',3533),(2328,'Erie County',3533),(2329,'Fayette County',3533),(2330,'Forest County',3533),(2331,'Franklin County',3533),(2332,'Fulton County',3533),(2333,'Greene County',3533),(2334,'Huntingdon County',3533),(2335,'Indiana County',3533),(2336,'Jefferson County',3533),(2337,'Juniata County',3533),(2338,'Lackawanna County',3533),(2339,'Lancaster County',3533),(2340,'Lawrence County',3533),(2341,'Lebanon County',3533),(2342,'Lehigh County',3533),(2343,'Luzerne County',3533),(2344,'Lycoming County',3533),(2345,'McKean County',3533),(2346,'Mercer County',3533),(2347,'Mifflin County',3533),(2348,'Monroe County',3533),(2349,'Montgomery County',3533),(2350,'Montour County',3533),(2351,'Northampton County',3533),(2352,'Northumberland County',3533),(2353,'Perry County',3533),(2354,'Philadelphia County',3533),(2355,'Pike County',3533),(2356,'Potter County',3533),(2357,'Schuylkill County',3533),(2358,'Snyder County',3533),(2359,'Somerset County',3533),(2360,'Sullivan County',3533),(2361,'Susquehanna County',3533),(2362,'Tioga County',3533),(2363,'Union County',3533),(2364,'Venango County',3533),(2365,'Warren County',3533),(2366,'Washington County',3533),(2367,'Wayne County',3533),(2368,'Westmoreland County',3533),(2369,'Wyoming County',3533),(2370,'York County',3533),(2371,'Bristol County',3534),(2372,'Kent County',3534),(2373,'Newport County',3534),(2374,'Providence County',3534),(2375,'Washington County',3534),(2376,'Abbeville County',3535),(2377,'Aiken County',3535),(2378,'Allendale County',3535),(2379,'Anderson County',3535),(2380,'Bamberg County',3535),(2381,'Barnwell County',3535),(2382,'Beaufort County',3535),(2383,'Berkeley County',3535),(2384,'Calhoun County',3535),(2385,'Charleston County',3535),(2386,'Cherokee County',3535),(2387,'Chester County',3535),(2388,'Chesterfield County',3535),(2389,'Clarendon County',3535),(2390,'Colleton County',3535),(2391,'Darlington County',3535),(2392,'Dillon County',3535),(2393,'Dorchester County',3535),(2394,'Edgefield County',3535),(2395,'Fairfield County',3535),(2396,'Florence County',3535),(2397,'Georgetown County',3535),(2398,'Greenville County',3535),(2399,'Greenwood County',3535),(2400,'Hampton County',3535),(2401,'Horry County',3535),(2402,'Jasper County',3535),(2403,'Kershaw County',3535),(2404,'Lancaster County',3535),(2405,'Laurens County',3535),(2406,'Lee County',3535),(2407,'Lexington County',3535),(2408,'Marion County',3535),(2409,'Marlboro County',3535),(2410,'McCormick County',3535),(2411,'Newberry County',3535),(2412,'Oconee County',3535),(2413,'Orangeburg County',3535),(2414,'Pickens County',3535),(2415,'Richland County',3535),(2416,'Saluda County',3535),(2417,'Spartanburg County',3535),(2418,'Sumter County',3535),(2419,'Union County',3535),(2420,'Williamsburg County',3535),(2421,'York County',3535),(2422,'Aurora County',3536),(2423,'Beadle County',3536),(2424,'Bennett County',3536),(2425,'Bon Homme County',3536),(2426,'Brookings County',3536),(2427,'Brown County',3536),(2428,'Brule County',3536),(2429,'Buffalo County',3536),(2430,'Butte County',3536),(2431,'Campbell County',3536),(2432,'Charles Mix County',3536),(2433,'Clark County',3536),(2434,'Clay County',3536),(2435,'Codington County',3536),(2436,'Corson County',3536),(2437,'Custer County',3536),(2438,'Davison County',3536),(2439,'Day County',3536),(2440,'Deuel County',3536),(2441,'Dewey County',3536),(2442,'Douglas County',3536),(2443,'Edmunds County',3536),(2444,'Fall River County',3536),(2445,'Faulk County',3536),(2446,'Grant County',3536),(2447,'Gregory County',3536),(2448,'Haakon County',3536),(2449,'Hamlin County',3536),(2450,'Hand County',3536),(2451,'Hanson County',3536),(2452,'Harding County',3536),(2453,'Hughes County',3536),(2454,'Hutchinson County',3536),(2455,'Hyde County',3536),(2456,'Jackson County',3536),(2457,'Jerauld County',3536),(2458,'Jones County',3536),(2459,'Kingsbury County',3536),(2460,'Lake County',3536),(2461,'Lawrence County',3536),(2462,'Lincoln County',3536),(2463,'Lyman County',3536),(2464,'Marshall County',3536),(2465,'McCook County',3536),(2466,'McPherson County',3536),(2467,'Meade County',3536),(2468,'Mellette County',3536),(2469,'Miner County',3536),(2470,'Minnehaha County',3536),(2471,'Moody County',3536),(2472,'Oglala Lakota County',3536),(2473,'Pennington County',3536),(2474,'Perkins County',3536),(2475,'Potter County',3536),(2476,'Roberts County',3536),(2477,'Sanborn County',3536),(2478,'Spink County',3536),(2479,'Stanley County',3536),(2480,'Sully County',3536),(2481,'Todd County',3536),(2482,'Tripp County',3536),(2483,'Turner County',3536),(2484,'Union County',3536),(2485,'Walworth County',3536),(2486,'Yankton County',3536),(2487,'Ziebach County',3536),(2488,'Anderson County',3537),(2489,'Bedford County',3537),(2490,'Benton County',3537),(2491,'Bledsoe County',3537),(2492,'Blount County',3537),(2493,'Bradley County',3537),(2494,'Campbell County',3537),(2495,'Cannon County',3537),(2496,'Carroll County',3537),(2497,'Carter County',3537),(2498,'Cheatham County',3537),(2499,'Chester County',3537),(2500,'Claiborne County',3537),(2501,'Clay County',3537),(2502,'Cocke County',3537),(2503,'Coffee County',3537),(2504,'Crockett County',3537),(2505,'Cumberland County',3537),(2506,'Davidson County',3537),(2507,'Decatur County',3537),(2508,'DeKalb County',3537),(2509,'Dickson County',3537),(2510,'Dyer County',3537),(2511,'Fayette County',3537),(2512,'Fentress County',3537),(2513,'Franklin County',3537),(2514,'Gibson County',3537),(2515,'Giles County',3537),(2516,'Grainger County',3537),(2517,'Greene County',3537),(2518,'Grundy County',3537),(2519,'Hamblen County',3537),(2520,'Hamilton County',3537),(2521,'Hancock County',3537),(2522,'Hardeman County',3537),(2523,'Hardin County',3537),(2524,'Hawkins County',3537),(2525,'Haywood County',3537),(2526,'Henderson County',3537),(2527,'Henry County',3537),(2528,'Hickman County',3537),(2529,'Houston County',3537),(2530,'Humphreys County',3537),(2531,'Jackson County',3537),(2532,'Jefferson County',3537),(2533,'Johnson County',3537),(2534,'Knox County',3537),(2535,'Lake County',3537),(2536,'Lauderdale County',3537),(2537,'Lawrence County',3537),(2538,'Lewis County',3537),(2539,'Lincoln County',3537),(2540,'Loudon County',3537),(2541,'Macon County',3537),(2542,'Madison County',3537),(2543,'Marion County',3537),(2544,'Marshall County',3537),(2545,'Maury County',3537),(2546,'McMinn County',3537),(2547,'McNairy County',3537),(2548,'Meigs County',3537),(2549,'Monroe County',3537),(2550,'Montgomery County',3537),(2551,'Moore County',3537),(2552,'Morgan County',3537),(2553,'Obion County',3537),(2554,'Overton County',3537),(2555,'Perry County',3537),(2556,'Pickett County',3537),(2557,'Polk County',3537),(2558,'Putnam County',3537),(2559,'Rhea County',3537),(2560,'Roane County',3537),(2561,'Robertson County',3537),(2562,'Rutherford County',3537),(2563,'Scott County',3537),(2564,'Sequatchie County',3537),(2565,'Sevier County',3537),(2566,'Shelby County',3537),(2567,'Smith County',3537),(2568,'Stewart County',3537),(2569,'Sullivan County',3537),(2570,'Sumner County',3537),(2571,'Tipton County',3537),(2572,'Trousdale County',3537),(2573,'Unicoi County',3537),(2574,'Union County',3537),(2575,'Van Buren County',3537),(2576,'Warren County',3537),(2577,'Washington County',3537),(2578,'Wayne County',3537),(2579,'Weakley County',3537),(2580,'White County',3537),(2581,'Williamson County',3537),(2582,'Wilson County',3537),(2583,'Anderson County',3538),(2584,'Andrews County',3538),(2585,'Angelina County',3538),(2586,'Aransas County',3538),(2587,'Archer County',3538),(2588,'Armstrong County',3538),(2589,'Atascosa County',3538),(2590,'Austin County',3538),(2591,'Bailey County',3538),(2592,'Bandera County',3538),(2593,'Bastrop County',3538),(2594,'Baylor County',3538),(2595,'Bee County',3538),(2596,'Bell County',3538),(2597,'Bexar County',3538),(2598,'Blanco County',3538),(2599,'Borden County',3538),(2600,'Bosque County',3538),(2601,'Bowie County',3538),(2602,'Brazoria County',3538),(2603,'Brazos County',3538),(2604,'Brewster County',3538),(2605,'Briscoe County',3538),(2606,'Brooks County',3538),(2607,'Brown County',3538),(2608,'Burleson County',3538),(2609,'Burnet County',3538),(2610,'Caldwell County',3538),(2611,'Calhoun County',3538),(2612,'Callahan County',3538),(2613,'Cameron County',3538),(2614,'Camp County',3538),(2615,'Carson County',3538),(2616,'Cass County',3538),(2617,'Castro County',3538),(2618,'Chambers County',3538),(2619,'Cherokee County',3538),(2620,'Childress County',3538),(2621,'Clay County',3538),(2622,'Cochran County',3538),(2623,'Coke County',3538),(2624,'Coleman County',3538),(2625,'Collin County',3538),(2626,'Collingsworth County',3538),(2627,'Colorado County',3538),(2628,'Comal County',3538),(2629,'Comanche County',3538),(2630,'Concho County',3538),(2631,'Cooke County',3538),(2632,'Coryell County',3538),(2633,'Cottle County',3538),(2634,'Crane County',3538),(2635,'Crockett County',3538),(2636,'Crosby County',3538),(2637,'Culberson County',3538),(2638,'Dallam County',3538),(2639,'Dallas County',3538),(2640,'Dawson County',3538),(2641,'Deaf Smith County',3538),(2642,'Delta County',3538),(2643,'Denton County',3538),(2644,'DeWitt County',3538),(2645,'Dickens County',3538),(2646,'Dimmit County',3538),(2647,'Donley County',3538),(2648,'Duval County',3538),(2649,'Eastland County',3538),(2650,'Ector County',3538),(2651,'Edwards County',3538),(2652,'El Paso County',3538),(2653,'Ellis County',3538),(2654,'Erath County',3538),(2655,'Falls County',3538),(2656,'Fannin County',3538),(2657,'Fayette County',3538),(2658,'Fisher County',3538),(2659,'Floyd County',3538),(2660,'Foard County',3538),(2661,'Fort Bend County',3538),(2662,'Franklin County',3538),(2663,'Freestone County',3538),(2664,'Frio County',3538),(2665,'Gaines County',3538),(2666,'Galveston County',3538),(2667,'Garza County',3538),(2668,'Gillespie County',3538),(2669,'Glasscock County',3538),(2670,'Goliad County',3538),(2671,'Gonzales County',3538),(2672,'Gray County',3538),(2673,'Grayson County',3538),(2674,'Gregg County',3538),(2675,'Grimes County',3538),(2676,'Guadalupe County',3538),(2677,'Hale County',3538),(2678,'Hall County',3538),(2679,'Hamilton County',3538),(2680,'Hansford County',3538),(2681,'Hardeman County',3538),(2682,'Hardin County',3538),(2683,'Harris County',3538),(2684,'Harrison County',3538),(2685,'Hartley County',3538),(2686,'Haskell County',3538),(2687,'Hays County',3538),(2688,'Hemphill County',3538),(2689,'Henderson County',3538),(2690,'Hidalgo County',3538),(2691,'Hill County',3538),(2692,'Hockley County',3538),(2693,'Hood County',3538),(2694,'Hopkins County',3538),(2695,'Houston County',3538),(2696,'Howard County',3538),(2697,'Hudspeth County',3538),(2698,'Hunt County',3538),(2699,'Hutchinson County',3538),(2700,'Irion County',3538),(2701,'Jack County',3538),(2702,'Jackson County',3538),(2703,'Jasper County',3538),(2704,'Jeff Davis County',3538),(2705,'Jefferson County',3538),(2706,'Jim Hogg County',3538),(2707,'Jim Wells County',3538),(2708,'Johnson County',3538),(2709,'Jones County',3538),(2710,'Karnes County',3538),(2711,'Kaufman County',3538),(2712,'Kendall County',3538),(2713,'Kenedy County',3538),(2714,'Kent County',3538),(2715,'Kerr County',3538),(2716,'Kimble County',3538),(2717,'King County',3538),(2718,'Kinney County',3538),(2719,'Kleberg County',3538),(2720,'Knox County',3538),(2721,'La Salle County',3538),(2722,'Lamar County',3538),(2723,'Lamb County',3538),(2724,'Lampasas County',3538),(2725,'Lavaca County',3538),(2726,'Lee County',3538),(2727,'Leon County',3538),(2728,'Liberty County',3538),(2729,'Limestone County',3538),(2730,'Lipscomb County',3538),(2731,'Live Oak County',3538),(2732,'Llano County',3538),(2733,'Loving County',3538),(2734,'Lubbock County',3538),(2735,'Lynn County',3538),(2736,'Madison County',3538),(2737,'Marion County',3538),(2738,'Martin County',3538),(2739,'Mason County',3538),(2740,'Matagorda County',3538),(2741,'Maverick County',3538),(2742,'McCulloch County',3538),(2743,'McLennan County',3538),(2744,'McMullen County',3538),(2745,'Medina County',3538),(2746,'Menard County',3538),(2747,'Midland County',3538),(2748,'Milam County',3538),(2749,'Mills County',3538),(2750,'Mitchell County',3538),(2751,'Montague County',3538),(2752,'Montgomery County',3538),(2753,'Moore County',3538),(2754,'Morris County',3538),(2755,'Motley County',3538),(2756,'Nacogdoches County',3538),(2757,'Navarro County',3538),(2758,'Newton County',3538),(2759,'Nolan County',3538),(2760,'Nueces County',3538),(2761,'Ochiltree County',3538),(2762,'Oldham County',3538),(2763,'Orange County',3538),(2764,'Palo Pinto County',3538),(2765,'Panola County',3538),(2766,'Parker County',3538),(2767,'Parmer County',3538),(2768,'Pecos County',3538),(2769,'Polk County',3538),(2770,'Potter County',3538),(2771,'Presidio County',3538),(2772,'Rains County',3538),(2773,'Randall County',3538),(2774,'Reagan County',3538),(2775,'Real County',3538),(2776,'Red River County',3538),(2777,'Reeves County',3538),(2778,'Refugio County',3538),(2779,'Roberts County',3538),(2780,'Robertson County',3538),(2781,'Rockwall County',3538),(2782,'Runnels County',3538),(2783,'Rusk County',3538),(2784,'Sabine County',3538),(2785,'San Augustine County',3538),(2786,'San Jacinto County',3538),(2787,'San Patricio County',3538),(2788,'San Saba County',3538),(2789,'Schleicher County',3538),(2790,'Scurry County',3538),(2791,'Shackelford County',3538),(2792,'Shelby County',3538),(2793,'Sherman County',3538),(2794,'Smith County',3538),(2795,'Somervell County',3538),(2796,'Starr County',3538),(2797,'Stephens County',3538),(2798,'Sterling County',3538),(2799,'Stonewall County',3538),(2800,'Sutton County',3538),(2801,'Swisher County',3538),(2802,'Tarrant County',3538),(2803,'Taylor County',3538),(2804,'Terrell County',3538),(2805,'Terry County',3538),(2806,'Throckmorton County',3538),(2807,'Titus County',3538),(2808,'Tom Green County',3538),(2809,'Travis County',3538),(2810,'Trinity County',3538),(2811,'Tyler County',3538),(2812,'Upshur County',3538),(2813,'Upton County',3538),(2814,'Uvalde County',3538),(2815,'Val Verde County',3538),(2816,'Van Zandt County',3538),(2817,'Victoria County',3538),(2818,'Walker County',3538),(2819,'Waller County',3538),(2820,'Ward County',3538),(2821,'Washington County',3538),(2822,'Webb County',3538),(2823,'Wharton County',3538),(2824,'Wheeler County',3538),(2825,'Wichita County',3538),(2826,'Wilbarger County',3538),(2827,'Willacy County',3538),(2828,'Williamson County',3538),(2829,'Wilson County',3538),(2830,'Winkler County',3538),(2831,'Wise County',3538),(2832,'Wood County',3538),(2833,'Yoakum County',3538),(2834,'Young County',3538),(2835,'Zapata County',3538),(2836,'Zavala County',3538),(2837,'Beaver County',3539),(2838,'Box Elder County',3539),(2839,'Cache County',3539),(2840,'Carbon County',3539),(2841,'Daggett County',3539),(2842,'Davis County',3539),(2843,'Duchesne County',3539),(2844,'Emery County',3539),(2845,'Garfield County',3539),(2846,'Grand County',3539),(2847,'Iron County',3539),(2848,'Juab County',3539),(2849,'Kane County',3539),(2850,'Millard County',3539),(2851,'Morgan County',3539),(2852,'Piute County',3539),(2853,'Rich County',3539),(2854,'Salt Lake County',3539),(2855,'San Juan County',3539),(2856,'Sanpete County',3539),(2857,'Sevier County',3539),(2858,'Summit County',3539),(2859,'Tooele County',3539),(2860,'Uintah County',3539),(2861,'Utah County',3539),(2862,'Wasatch County',3539),(2863,'Washington County',3539),(2864,'Wayne County',3539),(2865,'Weber County',3539),(2866,'Addison County',3540),(2867,'Bennington County',3540),(2868,'Caledonia County',3540),(2869,'Chittenden County',3540),(2870,'Essex County',3540),(2871,'Franklin County',3540),(2872,'Grand Isle County',3540),(2873,'Lamoille County',3540),(2874,'Orange County',3540),(2875,'Orleans County',3540),(2876,'Rutland County',3540),(2877,'Washington County',3540),(2878,'Windham County',3540),(2879,'Windsor County',3540),(2880,'Accomack County',3541),(2881,'Albemarle County',3541),(2882,'Alleghany County',3541),(2883,'Amelia County',3541),(2884,'Amherst County',3541),(2885,'Appomattox County',3541),(2886,'Arlington County',3541),(2887,'Augusta County',3541),(3014,'Barbour County',3541),(2888,'Bath County',3541),(2889,'Bedford County',3541),(3015,'Berkeley County',3541),(2890,'Bland County',3541),(3016,'Boone County',3541),(2891,'Botetourt County',3541),(3017,'Braxton County',3541),(3018,'Brooke County',3541),(2892,'Brunswick County',3541),(2893,'Buchanan County',3541),(2894,'Buckingham County',3541),(3019,'Cabell County',3541),(3020,'Calhoun County',3541),(2895,'Campbell County',3541),(2896,'Caroline County',3541),(2897,'Carroll County',3541),(2898,'Charles City County',3541),(2899,'Charlotte County',3541),(2900,'Chesterfield County',3541),(2901,'City of Alexandria',3541),(2902,'City of Bedford',3541),(2903,'City of Bristol',3541),(2904,'City of Buena Vista',3541),(2905,'City of Charlottesville',3541),(2906,'City of Chesapeake',3541),(2907,'City of Colonial Heights',3541),(2908,'City of Covington',3541),(2909,'City of Danville',3541),(2910,'City of Emporia',3541),(2911,'City of Fairfax',3541),(2912,'City of Falls Church',3541),(2913,'City of Franklin',3541),(2914,'City of Fredericksburg',3541),(2915,'City of Galax',3541),(2916,'City of Hampton',3541),(2917,'City of Harrisonburg',3541),(2918,'City of Hopewell',3541),(2919,'City of Lexington',3541),(2920,'City of Lynchburg',3541),(2921,'City of Manassas',3541),(2922,'City of Manassas Park',3541),(2923,'City of Martinsville',3541),(2924,'City of Newport News',3541),(2925,'City of Norfolk',3541),(2926,'City of Norton',3541),(2927,'City of Petersburg',3541),(2928,'City of Poquoson',3541),(2929,'City of Portsmouth',3541),(2930,'City of Radford',3541),(2931,'City of Richmond',3541),(2932,'City of Roanoke',3541),(2933,'City of Salem',3541),(2934,'City of Staunton',3541),(2935,'City of Suffolk',3541),(2936,'City of Virginia Beach',3541),(2937,'City of Waynesboro',3541),(2938,'City of Williamsburg',3541),(2939,'City of Winchester',3541),(2940,'Clarke County',3541),(3021,'Clay County',3541),(2941,'Craig County',3541),(2942,'Culpeper County',3541),(2943,'Cumberland County',3541),(2944,'Dickenson County',3541),(2945,'Dinwiddie County',3541),(3022,'Doddridge County',3541),(2946,'Essex County',3541),(2947,'Fairfax County',3541),(2948,'Fauquier County',3541),(3023,'Fayette County',3541),(2949,'Floyd County',3541),(2950,'Fluvanna County',3541),(2951,'Franklin County',3541),(2952,'Frederick County',3541),(2953,'Giles County',3541),(3024,'Gilmer County',3541),(2954,'Gloucester County',3541),(2955,'Goochland County',3541),(3025,'Grant County',3541),(2956,'Grayson County',3541),(3026,'Greenbrier County',3541),(2957,'Greene County',3541),(2958,'Greensville County',3541),(2959,'Halifax County',3541),(3027,'Hampshire County',3541),(3028,'Hancock County',3541),(2960,'Hanover County',3541),(3029,'Hardy County',3541),(3030,'Harrison County',3541),(2961,'Henrico County',3541),(2962,'Henry County',3541),(2963,'Highland County',3541),(2964,'Isle of Wight County',3541),(3031,'Jackson County',3541),(2965,'James City County',3541),(3032,'Jefferson County',3541),(3033,'Kanawha County',3541),(2966,'King and Queen County',3541),(2967,'King George County',3541),(2968,'King William County',3541),(2969,'Lancaster County',3541),(2970,'Lee County',3541),(3034,'Lewis County',3541),(3035,'Lincoln County',3541),(3036,'Logan County',3541),(2971,'Loudoun County',3541),(2972,'Louisa County',3541),(2973,'Lunenburg County',3541),(2974,'Madison County',3541),(3037,'Marion County',3541),(3038,'Marshall County',3541),(3039,'Mason County',3541),(2975,'Mathews County',3541),(3040,'McDowell County',3541),(2976,'Mecklenburg County',3541),(3041,'Mercer County',3541),(2977,'Middlesex County',3541),(3042,'Mineral County',3541),(3043,'Mingo County',3541),(3044,'Monongalia County',3541),(3045,'Monroe County',3541),(2978,'Montgomery County',3541),(3046,'Morgan County',3541),(2979,'Nelson County',3541),(2980,'New Kent County',3541),(3047,'Nicholas County',3541),(2981,'Northampton County',3541),(2982,'Northumberland County',3541),(2983,'Nottoway County',3541),(3048,'Ohio County',3541),(2984,'Orange County',3541),(2985,'Page County',3541),(2986,'Patrick County',3541),(3049,'Pendleton County',3541),(2987,'Pittsylvania County',3541),(3050,'Pleasants County',3541),(3051,'Pocahontas County',3541),(2988,'Powhatan County',3541),(3052,'Preston County',3541),(2989,'Prince Edward County',3541),(2990,'Prince George County',3541),(2991,'Prince William County',3541),(2992,'Pulaski County',3541),(3053,'Putnam County',3541),(3054,'Raleigh County',3541),(3055,'Randolph County',3541),(2993,'Rappahannock County',3541),(2994,'Richmond County',3541),(3056,'Ritchie County',3541),(3057,'Roane County',3541),(2995,'Roanoke County',3541),(2996,'Rockbridge County',3541),(2997,'Rockingham County',3541),(2998,'Russell County',3541),(2999,'Scott County',3541),(3000,'Shenandoah County',3541),(3001,'Smyth County',3541),(3002,'Southampton County',3541),(3003,'Spotsylvania County',3541),(3004,'Stafford County',3541),(3058,'Summers County',3541),(3005,'Surry County',3541),(3006,'Sussex County',3541),(3059,'Taylor County',3541),(3007,'Tazewell County',3541),(3060,'Tucker County',3541),(3061,'Tyler County',3541),(3062,'Upshur County',3541),(3008,'Warren County',3541),(3009,'Washington County',3541),(3063,'Wayne County',3541),(3064,'Webster County',3541),(3010,'Westmoreland County',3541),(3065,'Wetzel County',3541),(3066,'Wirt County',3541),(3011,'Wise County',3541),(3067,'Wood County',3541),(3068,'Wyoming County',3541),(3012,'Wythe County',3541),(3013,'York County',3541),(3069,'Adams County',3542),(3070,'Asotin County',3542),(3071,'Benton County',3542),(3072,'Chelan County',3542),(3073,'Clallam County',3542),(3074,'Clark County',3542),(3075,'Columbia County',3542),(3076,'Cowlitz County',3542),(3077,'Douglas County',3542),(3078,'Ferry County',3542),(3079,'Franklin County',3542),(3080,'Garfield County',3542),(3081,'Grant County',3542),(3082,'Grays Harbor County',3542),(3083,'Island County',3542),(3084,'Jefferson County',3542),(3085,'King County',3542),(3086,'Kitsap County',3542),(3087,'Kittitas County',3542),(3088,'Klickitat County',3542),(3089,'Lewis County',3542),(3090,'Lincoln County',3542),(3091,'Mason County',3542),(3092,'Okanogan County',3542),(3093,'Pacific County',3542),(3094,'Pend Oreille County',3542),(3095,'Pierce County',3542),(3096,'San Juan County',3542),(3097,'Skagit County',3542),(3098,'Skamania County',3542),(3099,'Snohomish County',3542),(3100,'Spokane County',3542),(3101,'Stevens County',3542),(3102,'Thurston County',3542),(3103,'Wahkiakum County',3542),(3104,'Walla Walla County',3542),(3105,'Whatcom County',3542),(3106,'Whitman County',3542),(3107,'Yakima County',3542),(3108,'Barbour County',3543),(3109,'Berkeley County',3543),(3110,'Boone County',3543),(3111,'Braxton County',3543),(3112,'Brooke County',3543),(3113,'Cabell County',3543),(3114,'Calhoun County',3543),(3115,'Clay County',3543),(3116,'Doddridge County',3543),(3117,'Fayette County',3543),(3118,'Gilmer County',3543),(3119,'Grant County',3543),(3120,'Greenbrier County',3543),(3121,'Hampshire County',3543),(3122,'Hancock County',3543),(3123,'Hardy County',3543),(3124,'Harrison County',3543),(3125,'Jackson County',3543),(3126,'Jefferson County',3543),(3127,'Kanawha County',3543),(3128,'Lewis County',3543),(3129,'Lincoln County',3543),(3130,'Logan County',3543),(3131,'Marion County',3543),(3132,'Marshall County',3543),(3133,'Mason County',3543),(3134,'McDowell County',3543),(3135,'Mercer County',3543),(3136,'Mineral County',3543),(3137,'Mingo County',3543),(3138,'Monongalia County',3543),(3139,'Monroe County',3543),(3140,'Morgan County',3543),(3141,'Nicholas County',3543),(3142,'Ohio County',3543),(3143,'Pendleton County',3543),(3144,'Pleasants County',3543),(3145,'Pocahontas County',3543),(3146,'Preston County',3543),(3147,'Putnam County',3543),(3148,'Raleigh County',3543),(3149,'Randolph County',3543),(3150,'Ritchie County',3543),(3151,'Roane County',3543),(3152,'Summers County',3543),(3153,'Taylor County',3543),(3154,'Tucker County',3543),(3155,'Tyler County',3543),(3156,'Upshur County',3543),(3157,'Wayne County',3543),(3158,'Webster County',3543),(3159,'Wetzel County',3543),(3160,'Wirt County',3543),(3161,'Wood County',3543),(3162,'Wyoming County',3543),(3163,'Adams County',3544),(3164,'Ashland County',3544),(3165,'Barron County',3544),(3166,'Bayfield County',3544),(3167,'Brown County',3544),(3168,'Buffalo County',3544),(3169,'Burnett County',3544),(3170,'Calumet County',3544),(3171,'Chippewa County',3544),(3172,'Clark County',3544),(3173,'Columbia County',3544),(3174,'Crawford County',3544),(3175,'Dane County',3544),(3176,'Dodge County',3544),(3177,'Door County',3544),(3178,'Douglas County',3544),(3179,'Dunn County',3544),(3180,'Eau Claire County',3544),(3181,'Florence County',3544),(3182,'Fond du Lac County',3544),(3183,'Forest County',3544),(3184,'Grant County',3544),(3185,'Green County',3544),(3186,'Green Lake County',3544),(3187,'Iowa County',3544),(3188,'Iron County',3544),(3189,'Jackson County',3544),(3190,'Jefferson County',3544),(3191,'Juneau County',3544),(3192,'Kenosha County',3544),(3193,'Kewaunee County',3544),(3194,'La Crosse County',3544),(3195,'Lafayette County',3544),(3196,'Langlade County',3544),(3197,'Lincoln County',3544),(3198,'Manitowoc County',3544),(3199,'Marathon County',3544),(3200,'Marinette County',3544),(3201,'Marquette County',3544),(3202,'Menominee County',3544),(3203,'Milwaukee County',3544),(3204,'Monroe County',3544),(3205,'Oconto County',3544),(3206,'Oneida County',3544),(3207,'Outagamie County',3544),(3208,'Ozaukee County',3544),(3209,'Pepin County',3544),(3210,'Pierce County',3544),(3211,'Polk County',3544),(3212,'Portage County',3544),(3213,'Price County',3544),(3214,'Racine County',3544),(3215,'Richland County',3544),(3216,'Rock County',3544),(3217,'Rusk County',3544),(3218,'Saint Croix County',3544),(3219,'Sauk County',3544),(3220,'Sawyer County',3544),(3221,'Shawano County',3544),(3222,'Sheboygan County',3544),(3223,'Taylor County',3544),(3224,'Trempealeau County',3544),(3225,'Vernon County',3544),(3226,'Vilas County',3544),(3227,'Walworth County',3544),(3228,'Washburn County',3544),(3229,'Washington County',3544),(3230,'Waukesha County',3544),(3231,'Waupaca County',3544),(3232,'Waushara County',3544),(3233,'Winnebago County',3544),(3234,'Wood County',3544),(3235,'Albany County',3545),(3236,'Big Horn County',3545),(3237,'Campbell County',3545),(3238,'Carbon County',3545),(3239,'Converse County',3545),(3240,'Crook County',3545),(3241,'Fremont County',3545),(3242,'Goshen County',3545),(3243,'Hot Springs County',3545),(3244,'Johnson County',3545),(3245,'Laramie County',3545),(3246,'Lincoln County',3545),(3247,'Natrona County',3545),(3248,'Niobrara County',3545),(3249,'Park County',3545),(3250,'Platte County',3545),(3251,'Sheridan County',3545),(3252,'Sublette County',3545),(3253,'Sweetwater County',3545),(3254,'Teton County',3545),(3255,'Uinta County',3545),(3256,'Washakie County',3545),(3257,'Weston County',3545);
  /*!40000 ALTER TABLE `city` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `country`
  --
  
  DROP TABLE IF EXISTS `country`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `country` (
    `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `code` varchar(45) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `country`
  --
  
  LOCK TABLES `country` WRITE;
  /*!40000 ALTER TABLE `country` DISABLE KEYS */;
  INSERT INTO `country` VALUES (1,'Afghanistan','af'),(2,'Albania','al'),(3,'Algeria','dz'),(4,'Andorra','ad'),(5,'Angola','ao'),(6,'Anguilla','ai'),(7,'Antigua and Barbuda','ag'),(8,'Argentina','ar'),(9,'Armenia','am'),(10,'Aruba','aw'),(11,'Australia','au'),(12,'Austria','at'),(13,'Azerbaijan','az'),(14,'Bahamas','bs'),(15,'Bahrain','bh'),(16,'Bangladesh','bd'),(17,'Barbados','bb'),(18,'Belarus','by'),(19,'Belgium','be'),(20,'Belize','bz'),(21,'Benin','bj'),(22,'Bermuda','bm'),(23,'Bhutan','bt'),(24,'Bolivia','bo'),(25,'Bosnia and Herzegovina','ba'),(26,'Botswana','bw'),(27,'Brazil','br'),(28,'Brunei Darussalam','bn'),(29,'Bulgaria','bg'),(30,'Burkina Faso','bf'),(31,'Burundi','bi'),(32,'Cambodia','kh'),(33,'Cameroon','cm'),(34,'Canada','ca'),(35,'Cape Verde','cv'),(36,'Cayman Islands','ky'),(37,'Central African Republic','cf'),(38,'Chad','td'),(39,'Chile','cl'),(40,'China','cn'),(41,'Christmas Island','cx'),(42,'Cocos (Keeling) Islands','cc'),(43,'Colombia','co'),(44,'Comoros','km'),(45,'Congo','cg'),(46,'Cook Islands','ck'),(47,'Costa Rica','cr'),(48,'Cote D\'Ivoire (Ivory Coast)','ci'),(49,'Croatia (Hrvatska)','hr'),(50,'Cuba','cu'),(51,'Cyprus','cy'),(52,'Czech Republic','cz'),(53,'Democratic Republic of the Congo','cd'),(54,'Denmark','dk'),(55,'Djibouti','dj'),(56,'Dominica','dm'),(57,'Dominican Republic','do'),(58,'Ecuador','ec'),(59,'Egypt','eg'),(60,'El Salvador','sv'),(61,'Equatorial Guinea','gq'),(62,'Eritrea','er'),(63,'Estonia','ee'),(64,'Ethiopia','et'),(65,'Falkland Islands (Malvinas)','fk'),(66,'Faroe Islands','fo'),(67,'Federated States of Micronesia','fm'),(68,'Fiji','fj'),(69,'Finland','fi'),(70,'France','fr'),(71,'French Guiana','gf'),(72,'French Polynesia','pf'),(73,'French Southern Territories','tf'),(74,'Gabon','ga'),(75,'Gambia','gm'),(76,'Georgia','ge'),(77,'Germany','de'),(78,'Ghana','gh'),(79,'Gibraltar','gi'),(80,'Great Britain (UK)','gb'),(81,'Greece','gr'),(82,'Greenland','gl'),(83,'Grenada','gd'),(84,'Guadeloupe','gp'),(85,'Guatemala','gt'),(86,'Guinea','gn'),(87,'Guinea-Bissau','gw'),(88,'Guyana','gy'),(89,'Haiti','ht'),(90,'Honduras','hn'),(91,'Hong Kong','hk'),(92,'Hungary','hu'),(93,'Iceland','is'),(94,'India','in'),(95,'Indonesia','id'),(96,'Iran','ir'),(97,'Iraq','iq'),(98,'Ireland','ie'),(99,'Israel','il'),(100,'Italy','it'),(101,'Jamaica','jm'),(102,'Japan','jp'),(103,'Jordan','jo'),(104,'Kazakhstan','kz'),(105,'Kenya','ke'),(106,'Kiribati','ki'),(107,'Korea (North)','kp'),(108,'Korea (South)','kr'),(109,'Kuwait','kw'),(110,'Kyrgyzstan','kg'),(111,'Laos','la'),(112,'Latvia','lv'),(113,'Lebanon','lb'),(114,'Lesotho','ls'),(115,'Liberia','lr'),(116,'Libya','ly'),(117,'Liechtenstein','li'),(118,'Lithuania','lt'),(119,'Luxembourg','lu'),(120,'Macao','mo'),(121,'Macedonia','mk'),(122,'Madagascar','mg'),(123,'Malawi','mw'),(124,'Malaysia','my'),(125,'Maldives','mv'),(126,'Mali','ml'),(127,'Malta','mt'),(128,'Marshall Islands','mh'),(129,'Martinique','mq'),(130,'Mauritania','mr'),(131,'Mauritius','mu'),(132,'Mayotte','yt'),(133,'Mexico','mx'),(134,'Moldova','md'),(135,'Monaco','mc'),(136,'Mongolia','mn'),(137,'Montserrat','ms'),(138,'Morocco','ma'),(139,'Mozambique','mz'),(140,'Myanmar','mm'),(141,'Namibia','na'),(142,'Nauru','nr'),(143,'Nepal','np'),(144,'Netherlands','nl'),(145,'Netherlands Antilles','an'),(146,'New Caledonia','nc'),(147,'New Zealand (Aotearoa)','nz'),(148,'Nicaragua','ni'),(149,'Niger','ne'),(150,'Nigeria','ng'),(151,'Niue','nu'),(152,'Norfolk Island','nf'),(153,'Northern Mariana Islands','mp'),(154,'Norway','no'),(155,'NULL','gg'),(156,'Oman','om'),(157,'Pakistan','pk'),(158,'Palau','pw'),(159,'Palestinian Territory','ps'),(160,'Panama','pa'),(161,'Papua New Guinea','pg'),(162,'Paraguay','py'),(163,'Peru','pe'),(164,'Philippines','ph'),(165,'Pitcairn','pn'),(166,'Poland','pl'),(167,'Portugal','pt'),(168,'Qatar','qa'),(169,'Reunion','re'),(170,'Romania','ro'),(171,'Russian Federation','ru'),(172,'Rwanda','rw'),(173,'S. Georgia and S. Sandwich Islands','gs'),(174,'Saint Helena','sh'),(175,'Saint Kitts and Nevis','kn'),(176,'Saint Lucia','lc'),(177,'Saint Pierre and Miquelon','pm'),(178,'Saint Vincent and the Grenadines','vc'),(179,'Samoa','ws'),(180,'San Marino','sm'),(181,'Sao Tome and Principe','st'),(182,'Saudi Arabia','sa'),(183,'Senegal','sn'),(184,'Seychelles','sc'),(185,'Sierra Leone','sl'),(186,'Singapore','sg'),(187,'Slovakia','sk'),(188,'Slovenia','si'),(189,'Solomon Islands','sb'),(190,'Somalia','so'),(191,'South Africa','za'),(192,'Spain','es'),(193,'Sri Lanka','lk'),(194,'Sudan','sd'),(195,'Suriname','sr'),(196,'Svalbard and Jan Mayen','sj'),(197,'Swaziland','sz'),(198,'Sweden','se'),(199,'Switzerland','ch'),(200,'Syria','sy'),(201,'Taiwan','tw'),(202,'Tajikistan','tj'),(203,'Tanzania','tz'),(204,'Thailand','th'),(205,'Togo','tg'),(206,'Tokelau','tk'),(207,'Tonga','to'),(208,'Trinidad and Tobago','tt'),(209,'Tunisia','tn'),(210,'Turkey','tr'),(211,'Turkmenistan','tm'),(212,'Turks and Caicos Islands','tc'),(213,'Tuvalu','tv'),(214,'Uganda','ug'),(215,'Ukraine','ua'),(216,'United Arab Emirates','ae'),(217,'United States of America','us'),(218,'Uruguay','uy'),(219,'Uzbekistan','uz'),(220,'Vanuatu','vu'),(221,'Venezuela','ve'),(222,'Viet Nam','vn'),(223,'Virgin Islands (British)','vg'),(224,'Virgin Islands (U.S.)','vi'),(225,'Wallis and Futuna','wf'),(226,'Western Sahara','eh'),(227,'Yemen','ye'),(228,'Zaire (former)','zr'),(229,'Zambia','zm'),(230,'Zimbabwe','zw');
  /*!40000 ALTER TABLE `country` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `customs_status_master`
  --
  
  DROP TABLE IF EXISTS `customs_status_master`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `customs_status_master` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `status` varchar(45) NOT NULL,
    `description` longtext NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `status_UNIQUE` (`status`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `customs_status_master`
  --
  
  LOCK TABLES `customs_status_master` WRITE;
  /*!40000 ALTER TABLE `customs_status_master` DISABLE KEYS */;
  INSERT INTO `customs_status_master` VALUES (1,'New','New'),(2,'Safe','Safe'),(3,'Review','Review'),(4,'Warning','Warning');
  /*!40000 ALTER TABLE `customs_status_master` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `poe`
  --
  
  DROP TABLE IF EXISTS `poe`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `poe` (
    `id` int(5) NOT NULL AUTO_INCREMENT,
    `city_id` int(11) NOT NULL,
    `poe_name` varchar(45) NOT NULL,
    `location_address` varchar(45) NOT NULL,
    `phone_number` varchar(45) NOT NULL,
    `email_id` varchar(45) NOT NULL,
    `fax_number` varchar(45) NOT NULL,
    `mailing_address` varchar(45) NOT NULL,
    `operating_hours` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `fk_poe_city_idx` (`city_id`),
    CONSTRAINT `fk_poe_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `poe`
  --
  
  LOCK TABLES `poe` WRITE;
  /*!40000 ALTER TABLE `poe` DISABLE KEYS */;
  INSERT INTO `poe` VALUES (1,2639,'Dallas/Ft. Worth','7501 Esters Blvd.,Suite 160',' (972) 870-7460','DFW-BRANCH1@cbp.dhs.gov    ','(972) 870-7553','P.O. Box 619050','8:30 AM-5:00 PM (CST) Weekdays (Monday-Friday)');
  /*!40000 ALTER TABLE `poe` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `state`
  --
  
  DROP TABLE IF EXISTS `state`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `state` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `country_id` smallint(5) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    KEY `country_name` (`country_id`,`name`),
    CONSTRAINT `fk_country_id` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB AUTO_INCREMENT=3721 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `state`
  --
  
  LOCK TABLES `state` WRITE;
  /*!40000 ALTER TABLE `state` DISABLE KEYS */;
  INSERT INTO `state` VALUES (1,'Badakhshan',1),(2,'Badghis',1),(3,'Balkh',1),(4,'Daykundi Province',1),(5,'Farah',1),(6,'Faryab Province',1),(7,'Helmand',1),(8,'Herat',1),(9,'Kandahar',1),(10,'Kunduz',1),(11,'Nangarhar',1),(12,'Panjshir',1),(13,'Parwan',1),(14,'Samangan',1),(15,'Sar-e Pul',1),(16,'Uruzgan',1),(17,'Velayat-e Khowst',1),(18,'Velayat-e Nurestan',1),(19,'Wardak',1),(20,'Wilayat-e Baghlan',1),(21,'Wilayat-e Bamyan',1),(22,'Wilayat-e Ghazni',1),(23,'Wilayat-e Ghor',1),(24,'Wilayat-e Jowzjan',1),(25,'Wilayat-e Kabul',1),(26,'Wilayat-e Kapisa',1),(27,'Wilayat-e Kunar',1),(28,'Wilayat-e Laghman',1),(29,'Wilayat-e Logar',1),(30,'Wilayat-e Nimroz',1),(31,'Wilayat-e Paktika',1),(32,'Wilayat-e Paktiya',1),(33,'Wilayat-e Takhar',1),(34,'Wilayat-e Zabul',1),(35,'Qarku i Beratit',2),(36,'Qarku i Dibres',2),(37,'Qarku i Durresit',2),(38,'Qarku i Elbasanit',2),(39,'Qarku i Fierit',2),(40,'Qarku i Gjirokastres',2),(41,'Qarku i Korces',2),(42,'Qarku i Kukesit',2),(43,'Qarku i Lezhes',2),(44,'Qarku i Shkodres',2),(45,'Qarku i Tiranes',2),(46,'Qarku i Vlores',2),(47,'Adrar',3),(48,'Annaba',3),(49,'El Bayadh',3),(50,'El Oued',3),(51,'El Tarf',3),(52,'Illizi',3),(53,'Oran',3),(54,'Oum el Bouaghi',3),(55,'Wilaya d\' Alger',3),(56,'Wilaya de Ain Defla',3),(57,'Wilaya de Ain Temouchent',3),(58,'Wilaya de Batna',3),(59,'Wilaya de Bechar',3),(60,'Wilaya de Bejaia',3),(61,'Wilaya de Biskra',3),(62,'Wilaya de Blida',3),(63,'Wilaya de Bordj Bou Arreridj',3),(64,'Wilaya de Bouira',3),(65,'Wilaya de Boumerdes',3),(66,'Wilaya de Chlef',3),(67,'Wilaya de Constantine',3),(68,'Wilaya de Djelfa',3),(69,'Wilaya de Ghardaia',3),(70,'Wilaya de Guelma',3),(71,'Wilaya de Jijel',3),(72,'Wilaya de Khenchela',3),(73,'Wilaya de Laghouat',3),(74,'Wilaya de M\'Sila',3),(75,'Wilaya de Mascara',3),(76,'Wilaya de Medea',3),(77,'Wilaya de Mila',3),(78,'Wilaya de Mostaganem',3),(79,'Wilaya de Naama',3),(80,'Wilaya de Ouargla',3),(81,'Wilaya de Relizane',3),(82,'Wilaya de Saida',3),(83,'Wilaya de Setif',3),(84,'Wilaya de Sidi Bel Abbes',3),(85,'Wilaya de Skikda',3),(86,'Wilaya de Souk Ahras',3),(87,'Wilaya de Tamanrasset',3),(88,'Wilaya de Tebessa',3),(89,'Wilaya de Tiaret',3),(90,'Wilaya de Tindouf',3),(91,'Wilaya de Tipaza',3),(92,'Wilaya de Tissemsilt',3),(93,'Wilaya de Tizi Ouzou',3),(94,'Wilaya de Tlemcen',3),(95,'Andorra la Vella',4),(96,'Canillo',4),(97,'Encamp',4),(98,'Escaldes-Engordany',4),(99,'La Massana',4),(100,'Ordino',4),(101,'Sant Julia de Loria',4),(102,'Bengo Province',5),(103,'Benguela',5),(104,'Cabinda',5),(105,'Cuanza Norte Province',5),(106,'Cunene Province',5),(107,'Huambo',5),(108,'Huila Province',5),(109,'Kuando Kubango',5),(110,'Kwanza Sul',5),(111,'Luanda Province',5),(112,'Lunda Norte Province',5),(113,'Lunda Sul',5),(114,'Malanje Province',5),(115,'Moxico',5),(116,'Namibe Province',5),(117,'Provincia do Bie',5),(118,'Provincia do Uige',5),(119,'Zaire',5),(120,'Blowing Point',6),(121,'East End',6),(122,'George Hill',6),(123,'Island Harbour',6),(124,'North Hill',6),(125,'North Side',6),(126,'Sandy Ground',6),(127,'Sandy Hill',6),(128,'South Hill',6),(129,'Stoney Ground',6),(130,'The Farrington',6),(131,'The Quarter',6),(132,'The Valley',6),(133,'West End',6),(134,'Barbuda',7),(135,'Parish of Saint George',7),(136,'Parish of Saint John',7),(137,'Parish of Saint Mary',7),(138,'Parish of Saint Paul',7),(139,'Parish of Saint Peter',7),(140,'Parish of Saint Philip',7),(141,'Redonda',7),(142,'Catamarca Province',8),(143,'Chaco Province',8),(144,'Chubut Province',8),(145,'Ciudad Autonoma de Buenos Aires',8),(146,'Cordoba Province',8),(147,'Corrientes Province',8),(148,'Entre Rios Province',8),(149,'Formosa Province',8),(150,'Jujuy Province',8),(151,'La Pampa Province',8),(152,'La Rioja Province',8),(153,'Mendoza Province',8),(154,'Misiones Province',8),(155,'Neuquen Province',8),(156,'Provincia de Buenos Aires',8),(157,'Rio Negro Province',8),(158,'Salta Province',8),(159,'San Juan Province',8),(160,'San Luis Province',8),(161,'Santa Cruz Province',8),(162,'Santa Fe Province',8),(163,'Santiago del Estero Province',8),(164,'Tierra del Fuego Province',8),(165,'Tucuman Province',8),(166,'Aragatsotni Marz',9),(167,'Ararati Marz',9),(168,'Armaviri Marz',9),(169,'Geghark\'unik\'i Marz',9),(170,'Kotayk\'i Marz',9),(171,'Lorru Marz',9),(172,'Shiraki Marz',9),(173,'Syunik\'i Marz',9),(174,'Tavushi Marz',9),(175,'Vayots\' Dzor',9),(176,'Yerevan',9),(177,'Australian Capital Territory',11),(178,'Northern Territory',11),(179,'State of New South Wales',11),(180,'State of Queensland',11),(181,'State of South Australia',11),(182,'State of Tasmania',11),(183,'State of Victoria',11),(184,'State of Western Australia',11),(185,'Burgenland',12),(186,'Kaernten',12),(187,'Niederoesterreich',12),(188,'Oberoesterreich',12),(189,'Salzburg',12),(190,'Steiermark',12),(191,'Tirol',12),(192,'Vorarlberg',12),(193,'Wien',12),(194,'Absheron Rayon',13),(195,'Aghdam Rayon',13),(196,'Aghdash Rayon',13),(197,'Aghjabadi Rayon',13),(198,'Aghstafa Rayon',13),(199,'Aghsu Rayon',13),(200,'Astara District',13),(201,'Baku City',13),(202,'Balakan Rayon',13),(203,'Barda Rayon',13),(204,'Beylagan Rayon',13),(205,'Bilasuvar Rayon',13),(206,'Dashkasan Rayon',13),(207,'Fizuli Rayon',13),(208,'Gadabay Rayon',13),(209,'Ganja City',13),(210,'Gobustan Rayon',13),(211,'Goranboy Rayon',13),(212,'Goychay Rayon',13),(213,'Goygol Rayon',13),(214,'Hajigabul Rayon',13),(215,'Imishli Rayon',13),(216,'Ismayilli Rayon',13),(217,'Jabrayil District',13),(218,'Jalilabad',13),(219,'Kalbajar District',13),(220,'Khachmaz Rayon',13),(221,'Khizi Rayon',13),(222,'Khojavend District',13),(223,'Kurdamir Rayon',13),(224,'Lacin Rayonu',13),(225,'Lankaran Rayon',13),(226,'Lankaran Sahari',13),(227,'Lerik Rayon',13),(228,'Masally District',13),(229,'Mingacevir City',13),(230,'Naftalan City',13),(231,'Nakhchivan',13),(232,'Nakhchivan Autonomous Republic',13),(233,'Neftchala Rayon',13),(234,'Oghuz Rayon',13),(235,'Qabala Rayon',13),(236,'Qakh Rayon',13),(237,'Qazakh Rayon',13),(238,'Quba Rayon',13),(239,'Qubadli Rayon',13),(240,'Qusar Rayon',13),(241,'Saatly Rayon',13),(242,'Sabirabad Rayon',13),(243,'Salyan Rayon',13),(244,'Samukh Rayon',13),(245,'Shabran Rayon',13),(246,'Shaki city',13),(247,'Shaki Rayon',13),(248,'Shamakhi Rayon',13),(249,'Shamkir Rayon',13),(250,'Shirvan',13),(251,'Shusha',13),(252,'Siazan Rayon',13),(253,'Sumqayit City',13),(254,'Susa Rayonu',13),(255,'Tartar Rayon',13),(256,'Tovuz Rayon',13),(257,'Ujar Rayon',13),(258,'Xankandi Sahari',13),(259,'Xocali Rayonu',13),(260,'Yardymli Rayon',13),(261,'Yevlakh City',13),(262,'Yevlakh Rayon',13),(263,'Zangilan Rayon',13),(264,'Zaqatala Rayon',13),(265,'Zardab Rayon',13),(266,'Acklins Island District',14),(267,'Berry Islands District',14),(268,'Bimini District',14),(269,'Black Point District',14),(270,'Cat Island',14),(271,'Central Abaco District',14),(272,'Central Andros District',14),(273,'Central Eleuthera District',14),(274,'City of Freeport District',14),(275,'Crooked Island and Long Cay District',14),(276,'East Grand Bahama District',14),(277,'Exuma District',14),(278,'Grand Cay District',14),(279,'Harbour Island District',14),(280,'Hope Town District',14),(281,'Inagua',14),(282,'Long Island',14),(283,'Mangrove Cay',14),(284,'Mayaguana District',14),(285,'Moore\'s Island District',14),(286,'New Providence District',14),(287,'North Abaco District',14),(288,'North Andros District',14),(289,'North Eleuthera District',14),(290,'Ragged Island District',14),(291,'Rum Cay',14),(292,'San Salvador District',14),(293,'South Abaco District',14),(294,'South Andros',14),(295,'South Eleuthera',14),(296,'Spanish Wells District',14),(297,'West Grand Bahama District',14),(298,'Capital Governorate',15),(299,'Muharraq Governorate',15),(300,'Northern Governorate',15),(301,'Southern Governorate',15),(302,'Barisal Division',16),(303,'Chittagong',16),(304,'Dhaka Division',16),(305,'Khulna Division',16),(306,'Mymensingh Division',16),(307,'Rajshahi Division',16),(308,'Rangpur Division',16),(309,'Sylhet Division',16),(310,'Christ Church',17),(311,'Saint Andrew',17),(312,'Saint George',17),(313,'Saint James',17),(314,'Saint John',17),(315,'Saint Joseph',17),(316,'Saint Lucy',17),(317,'Saint Michael',17),(318,'Saint Peter',17),(319,'Saint Philip',17),(320,'Saint Thomas',17),(321,'Brest Oblast',18),(322,'Gomel Oblast',18),(323,'Grodno Oblast',18),(324,'Horad Minsk',18),(325,'Minsk Oblast',18),(326,'Mogilyov Oblast',18),(327,'Vitebsk Oblast',18),(328,'Bruxelles-Capitale',19),(329,'Flanders',19),(330,'Wallonia',19),(331,'Belize District',20),(332,'Cayo District',20),(333,'Corozal District',20),(334,'Orange Walk District',20),(335,'Stann Creek District',20),(336,'Toledo District',20),(337,'Alibori',21),(338,'Atakora Department',21),(339,'Atlantique Department',21),(340,'Borgou Department',21),(341,'Collines Department',21),(342,'Departement de l\'Oueme',21),(343,'Donga',21),(344,'Kouffo Department',21),(345,'Littoral',21),(346,'Mono',21),(347,'Plateau Department',21),(348,'Zou Department',21),(349,'Devonshire Parish',22),(350,'Hamilton',22),(351,'Paget Parish',22),(352,'Pembroke Parish',22),(353,'Saint George',22),(354,'Saint George\'s Parish',22),(355,'Sandys Parish',22),(356,'Smith\'s Parish',22),(357,'Southampton Parish',22),(358,'Warwick Parish',22),(359,'Bumthang Dzongkhag',23),(360,'Chhukha Dzongkhag',23),(361,'Dagana Dzongkhag',23),(362,'Gasa',23),(363,'Haa Dzongkhag',23),(364,'Lhuentse Dzongkhag',23),(365,'Mongar Dzongkhag',23),(366,'Paro Dzongkhag',23),(367,'Pemagatshel Dzongkhag',23),(368,'Punakha Dzongkhag',23),(369,'Samdrup Jongkhar Dzongkhag',23),(370,'Samtse Dzongkhag',23),(371,'Sarpang Dzongkhag',23),(372,'Thimphu Dzongkhag',23),(373,'Trashi Yangste',23),(374,'Trashigang Dzongkhag',23),(375,'Trongsa Dzongkhag',23),(376,'Tsirang Dzongkhag',23),(377,'Wangdue Phodrang Dzongkhag',23),(378,'Zhemgang Dzongkhag',23),(379,'Departamento de Chuquisaca',24),(380,'Departamento de Cochabamba',24),(381,'Departamento de La Paz',24),(382,'Departamento de Oruro',24),(383,'Departamento de Pando',24),(384,'Departamento de Potosi',24),(385,'Departamento de Santa Cruz',24),(386,'Departamento de Tarija',24),(387,'El Beni',24),(388,'Brcko',25),(389,'Federation of Bosnia and Herzegovina',25),(390,'Republika Srpska',25),(391,'Central District',26),(392,'Ghanzi District',26),(393,'Kgalagadi District',26),(394,'Kgatleng District',26),(395,'Kweneng District',26),(396,'North East District',26),(397,'North West District',26),(398,'South East District',26),(399,'Southern District',26),(400,'Acre',27),(401,'Alagoas',27),(402,'Amapa',27),(403,'Amazonas',27),(404,'Bahia',27),(405,'Ceara',27),(406,'Espirito Santo',27),(407,'Federal District',27),(408,'Goias',27),(409,'Maranhao',27),(410,'Mato Grosso',27),(411,'Mato Grosso do Sul',27),(412,'Minas Gerais',27),(413,'Para',27),(414,'Paraiba',27),(415,'Parana',27),(416,'Pernambuco',27),(417,'Piaui',27),(418,'Rio de Janeiro',27),(419,'Rio Grande do Norte',27),(420,'Rio Grande do Sul',27),(421,'Rondonia',27),(422,'Roraima',27),(423,'Santa Catarina',27),(424,'Sao Paulo',27),(425,'Sergipe',27),(426,'Tocantins',27),(427,'Belait District',28),(428,'Brunei and Muara District',28),(429,'Temburong District',28),(430,'Tutong District',28),(431,'Blagoevgrad',29),(432,'Burgas',29),(433,'Gabrovo',29),(434,'Haskovo',29),(435,'Lovech',29),(436,'Oblast Dobrich',29),(437,'Oblast Kardzhali',29),(438,'Oblast Kyustendil',29),(439,'Oblast Montana',29),(440,'Oblast Pleven',29),(441,'Oblast Razgrad',29),(442,'Oblast Ruse',29),(443,'Oblast Shumen',29),(444,'Oblast Silistra',29),(445,'Oblast Sliven',29),(446,'Oblast Smolyan',29),(447,'Oblast Stara Zagora',29),(448,'Oblast Targovishte',29),(449,'Oblast Veliko Tarnovo',29),(450,'Oblast Vidin',29),(451,'Oblast Vratsa',29),(452,'Oblast Yambol',29),(453,'Pazardzhik',29),(454,'Pernik',29),(455,'Plovdiv',29),(456,'Sofia',29),(457,'Sofia-Grad',29),(458,'Varna',29),(459,'Boucle du Mouhoun Region',30),(460,'Cascades Region',30),(461,'Centre',30),(462,'Centre-Est',30),(463,'Centre-Nord',30),(464,'Centre-Ouest',30),(465,'Centre-Sud',30),(466,'Est',30),(467,'High-Basins Region',30),(468,'Nord',30),(469,'Plateau-Central',30),(470,'Sahel',30),(471,'Southwest Region',30),(472,'Bubanza Province',31),(473,'Bujumbura Mairie Province',31),(474,'Bujumbura Rural Province',31),(475,'Bururi Province',31),(476,'Cankuzo Province',31),(477,'Cibitoke Province',31),(478,'Gitega Province',31),(479,'Karuzi Province',31),(480,'Kayanza Province',31),(481,'Kirundo Province',31),(482,'Makamba Province',31),(483,'Muramvya Province',31),(484,'Muyinga Province',31),(485,'Ngozi Province',31),(486,'Province de Mwaro',31),(487,'Rumonge Province',31),(488,'Rutana Province',31),(489,'Ruyigi Province',31),(490,'Banteay Meanchey',32),(491,'Battambang',32),(492,'Kampong Cham',32),(493,'Kampong Chhnang',32),(494,'Kampong Speu',32),(495,'Kampong Thom',32),(496,'Kampot',32),(497,'Kandal',32),(498,'Kep',32),(499,'Koh Kong',32),(500,'Kratie',32),(501,'Mondolkiri',32),(502,'Otar Meanchey',32),(503,'Pailin',32),(504,'Phnom Penh',32),(505,'Preah Vihear',32),(506,'Prey Veng',32),(507,'Pursat',32),(508,'Ratanakiri',32),(509,'Siem Reap',32),(510,'Sihanoukville',32),(511,'Stung Treng',32),(512,'Svay Rieng',32),(513,'Takeo',32),(514,'Tboung Khmum',32),(515,'Adamaoua Region',33),(516,'Centre Region',33),(517,'East Region',33),(518,'Far North Region',33),(519,'Littoral Region',33),(520,'North Region',33),(521,'North-West Region',33),(522,'South Region',33),(523,'South-West Region',33),(524,'West Region',33),(525,'Alberta',34),(526,'British Columbia',34),(527,'Manitoba',34),(528,'New Brunswick/Nouveau-Brunswick',34),(529,'Newfoundland and Labrador',34),(530,'Northwest Territories',34),(531,'Nova Scotia',34),(532,'Nunavut',34),(533,'Ontario',34),(534,'Prince Edward Island',34),(535,'Quebec',34),(536,'Saskatchewan',34),(537,'Yukon',34),(538,'Concelho da Boa Vista',35),(539,'Concelho da Brava',35),(540,'Concelho da Praia',35),(541,'Concelho da Ribeira Brava',35),(542,'Concelho da Ribeira Grande',35),(543,'Concelho de Ribeira Grande de Santiago',35),(544,'Concelho de Santa Catarina',35),(545,'Concelho de Santa Catarina do Fogo',35),(546,'Concelho de Santa Cruz',35),(547,'Concelho de Sao Domingos',35),(548,'Concelho de Sao Miguel',35),(549,'Concelho de Sao Salvador do Mundo',35),(550,'Concelho de Sao Vicente',35),(551,'Concelho do Maio',35),(552,'Concelho do Paul',35),(553,'Concelho do Porto Novo',35),(554,'Concelho do Sao Filipe',35),(555,'Concelho do Tarrafal',35),(556,'Concelho do Tarrafal de Sao Nicolau',35),(557,'Concelho dos Mosteiros',35),(558,'Sal Municipality',35),(559,'Sao Lourenco dos Orgaos',35),(560,'Bodden Town',36),(561,'East End',36),(562,'George Town',36),(563,'North Side',36),(564,'Sister Island',36),(565,'West Bay',36),(566,'Bamingui-Bangoran',37),(567,'Basse-Kotto',37),(568,'Commune de Bangui',37),(569,'Haut-Mbomou',37),(570,'Haute-Kotto',37),(571,'Lobaye',37),(572,'Mambere-Kadei',37),(573,'Mbomou',37),(574,'Ombella-Mpoko',37),(575,'Ouaka',37),(576,'Ouham',37),(577,'Prefecture de l\'Ouham-Pende',37),(578,'Prefecture de la Kemo',37),(579,'Prefecture de la Nana-Grebizi',37),(580,'Prefecture de la Nana-Mambere',37),(581,'Prefecture de la Sangha-Mbaere',37),(582,'Vakaga',37),(583,'Barh el Gazel',38),(584,'Batha Region',38),(585,'Borkou Region',38),(586,'Chari-Baguirmi Region',38),(587,'Ennedi-Est',38),(588,'Ennedi-Ouest',38),(589,'Guera Region',38),(590,'Hadjer-Lamis',38),(591,'Kanem Region',38),(592,'Lac Region',38),(593,'Logone Occidental Region',38),(594,'Logone Oriental Region',38),(595,'Mandoul',38),(596,'Mayo-Kebbi East Region',38),(597,'Mayo-Kebbi West Region',38),(598,'Moyen-Chari Region',38),(599,'Ouaddai Region',38),(600,'Region de la Ville de N\'Djamena',38),(601,'Salamat Region',38),(602,'Sila',38),(603,'Tandjile Region',38),(604,'Tibesti Region',38),(605,'Wadi Fira Region',38),(606,'Antofagasta',39),(607,'Atacama',39),(608,'Aysen',39),(609,'Coquimbo',39),(610,'Los Lagos',39),(611,'Maule',39),(612,'Region de Arica y Parinacota',39),(613,'Region de la Araucania',39),(614,'Region de Los Rios',39),(615,'Region de Magallanes y de la Antartica Chilena',39),(616,'Region de Tarapaca',39),(617,'Region de Valparaiso',39),(618,'Region del Biobio',39),(619,'Region del Libertador General Bernardo O\'Higgins',39),(620,'Region Metropolitana de Santiago',39),(621,'Anhui Sheng',40),(622,'Beijing Shi',40),(623,'Chongqing Shi',40),(624,'Fujian Sheng',40),(625,'Gansu Sheng',40),(626,'Guangdong Sheng',40),(627,'Guangxi Zhuangzu Zizhiqu',40),(628,'Guizhou Sheng',40),(629,'Hainan Sheng',40),(630,'Hebei Sheng',40),(631,'Heilongjiang Sheng',40),(632,'Henan Sheng',40),(633,'Hubei Sheng',40),(634,'Hunan Sheng',40),(635,'Inner Mongolia Autonomous Region',40),(636,'Jiangsu Sheng',40),(637,'Jiangxi Sheng',40),(638,'Jilin Sheng',40),(639,'Liaoning Sheng',40),(640,'Ningxia Huizu Zizhiqu',40),(641,'Qinghai Sheng',40),(642,'Shaanxi',40),(643,'Shandong Sheng',40),(644,'Shanghai Shi',40),(645,'Shanxi Sheng',40),(646,'Sichuan Sheng',40),(647,'Tianjin Shi',40),(648,'Tibet Autonomous Region',40),(649,'Xinjiang Uygur Zizhiqu',40),(650,'Yunnan Sheng',40),(651,'Zhejiang Sheng',40),(652,'Amazonas',43),(653,'Departamento de Antioquia',43),(654,'Departamento de Arauca',43),(655,'Departamento de Bolivar',43),(656,'Departamento de Boyaca',43),(657,'Departamento de Caldas',43),(658,'Departamento de Casanare',43),(659,'Departamento de Cordoba',43),(660,'Departamento de Cundinamarca',43),(661,'Departamento de La Guajira',43),(662,'Departamento de Narino',43),(663,'Departamento de Norte de Santander',43),(664,'Departamento de Risaralda',43),(665,'Departamento de Santander',43),(666,'Departamento de Sucre',43),(667,'Departamento de Tolima',43),(668,'Departamento del Atlantico',43),(669,'Departamento del Caqueta',43),(670,'Departamento del Cauca',43),(671,'Departamento del Cesar',43),(672,'Departamento del Choco',43),(673,'Departamento del Guainia',43),(674,'Departamento del Guaviare',43),(675,'Departamento del Huila',43),(676,'Departamento del Magdalena',43),(677,'Departamento del Meta',43),(678,'Departamento del Putumayo',43),(679,'Departamento del Valle del Cauca',43),(680,'Departamento del Vaupes',43),(681,'Departamento del Vichada',43),(682,'Distrito Capital de Bogota',43),(683,'Providencia y Santa Catalina, Departamento de Archipielago de San Andres',43),(684,'Quindio Department',43),(685,'Grande Comore',44),(686,'Moheli',44),(687,'Ndzuwani',44),(688,'Commune de Brazzaville',45),(689,'Cuvette',45),(690,'Cuvette-Ouest',45),(691,'Lekoumou',45),(692,'Likouala',45),(693,'Plateaux',45),(694,'Pointe-Noire',45),(695,'Pool',45),(696,'Region de la Bouenza',45),(697,'Region du Kouilou',45),(698,'Region du Niari',45),(699,'Sangha',45),(700,'Aitutaki',46),(701,'Atiu',46),(702,'Ma\'uke',46),(703,'Mangaia',46),(704,'Manihiki',46),(705,'Mitiaro',46),(706,'Palmerston',46),(707,'Penrhyn',46),(708,'Pukapuka',46),(709,'Rakahanga',46),(710,'Rarotonga',46),(711,'Provincia de Alajuela',47),(712,'Provincia de Cartago',47),(713,'Provincia de Guanacaste',47),(714,'Provincia de Heredia',47),(715,'Provincia de Limon',47),(716,'Provincia de Puntarenas',47),(717,'Provincia de San Jose',47),(718,'Abidjan',48),(719,'Bas-Sassandra',48),(720,'Comoe',48),(721,'Denguele',48),(722,'Goh-Djiboua',48),(723,'Lacs',48),(724,'Lagunes',48),(725,'Montagnes',48),(726,'Sassandra-Marahoue',48),(727,'Savanes',48),(728,'Vallee du Bandama',48),(729,'Woroba',48),(730,'Yamoussoukro Autonomous District',48),(731,'Zanzan',48),(732,'Bjelovarsko-Bilogorska Zupanija',49),(733,'Brodsko-Posavska Zupanija',49),(734,'Dubrovacko-Neretvanska Zupanija',49),(735,'Grad Zagreb',49),(736,'Istarska Zupanija',49),(737,'Karlovacka Zupanija',49),(738,'Koprivnicko-Krizevacka Zupanija',49),(739,'Krapinsko-Zagorska Zupanija',49),(740,'Licko-Senjska Zupanija',49),(741,'Megimurska Zupanija',49),(742,'Osjecko-Baranjska Zupanija',49),(743,'Pozesko-Slavonska Zupanija',49),(744,'Primorsko-Goranska Zupanija',49),(745,'Sibensko-Kninska Zupanija',49),(746,'Sisacko-Moslavacka Zupanija',49),(747,'Splitsko-Dalmatinska Zupanija',49),(748,'Varazdinska Zupanija',49),(749,'Viroviticko-Podravska Zupanija',49),(750,'Vukovarsko-Srijemska Zupanija',49),(751,'Zadarska Zupanija',49),(752,'Zagreb County',49),(753,'Artemisa',50),(754,'La Habana',50),(755,'Las Tunas',50),(756,'Municipio Especial Isla de la Juventud',50),(757,'Provincia de Camagueey',50),(758,'Provincia de Ciego de Avila',50),(759,'Provincia de Cienfuegos',50),(760,'Provincia de Guantanamo',50),(761,'Provincia de Holguin',50),(762,'Provincia de Matanzas',50),(763,'Provincia de Pinar del Rio',50),(764,'Provincia de Sancti Spiritus',50),(765,'Provincia de Santiago de Cuba',50),(766,'Provincia de Villa Clara',50),(767,'Provincia Granma',50),(768,'Provincia Mayabeque',50),(769,'Eparchia Ammochostou',51),(770,'Eparchia Keryneias',51),(771,'Eparchia Larnakas',51),(772,'Eparchia Lefkosias',51),(773,'Eparchia Lemesou',51),(774,'Eparchia Pafou',51),(775,'Hlavni mesto Praha',52),(776,'Jihocesky kraj',52),(777,'Jihomoravsky kraj',52),(778,'Karlovarsky kraj',52),(779,'Kraj Vysocina',52),(780,'Kralovehradecky kraj',52),(781,'Liberecky kraj',52),(782,'Moravskoslezsky kraj',52),(783,'Olomoucky kraj',52),(784,'Pardubicky kraj',52),(785,'Plzensky kraj',52),(786,'Stredocesky kraj',52),(787,'Ustecky kraj',52),(788,'Zlinsky kraj',52),(789,'Bas Uele',53),(790,'Haut Uele',53),(791,'Haut-Lomani',53),(792,'Ituri',53),(793,'Kasai District',53),(794,'Kasai-Central',53),(795,'Kinshasa City',53),(796,'Kwango',53),(797,'Kwilu',53),(798,'Lomami',53),(799,'Lualaba',53),(800,'Mai Ndombe',53),(801,'Mongala',53),(802,'Province de l\'Equateur',53),(803,'Province du Haut-Katanga',53),(804,'Province du Kasai Oriental',53),(805,'Province du Kongo Central',53),(806,'Province du Maniema',53),(807,'Province du Nord-Kivu',53),(808,'Province du Nord-Ubangi',53),(809,'Province du Sud-Ubangi',53),(810,'Sankuru',53),(811,'South Kivu Province',53),(812,'Tanganika',53),(813,'Tshopo',53),(814,'Tshuapa',53),(815,'North Denmark Region',54),(816,'Region Hovedstaden',54),(817,'Region Midtjylland',54),(818,'Region Sjaelland',54),(819,'Region Syddanmark',54),(820,'Ali Sabieh Region',55),(821,'Arta Region',55),(822,'Dikhil',55),(823,'Djibouti Region',55),(824,'Obock',55),(825,'Tadjourah',55),(826,'Saint Andrew',56),(827,'Saint David',56),(828,'Saint George',56),(829,'Saint John',56),(830,'Saint Joseph',56),(831,'Saint Luke',56),(832,'Saint Mark',56),(833,'Saint Patrick',56),(834,'Saint Paul',56),(835,'Saint Peter',56),(836,'Distrito Nacional',57),(837,'Provincia de Azua',57),(838,'Provincia de Baoruco',57),(839,'Provincia de Barahona',57),(840,'Provincia de Dajabon',57),(841,'Provincia de El Seibo',57),(842,'Provincia de Elias Pina',57),(843,'Provincia de Hato Mayor',57),(844,'Provincia de Hermanas Mirabal',57),(845,'Provincia de Independencia',57),(846,'Provincia de La Altagracia',57),(847,'Provincia de La Romana',57),(848,'Provincia de La Vega',57),(849,'Provincia de Monsenor Nouel',57),(850,'Provincia de Monte Cristi',57),(851,'Provincia de Monte Plata',57),(852,'Provincia de Pedernales',57),(853,'Provincia de Peravia',57),(854,'Provincia de Puerto Plata',57),(855,'Provincia de San Cristobal',57),(856,'Provincia de San Jose de Ocoa',57),(857,'Provincia de San Juan',57),(858,'Provincia de San Pedro de Macoris',57),(859,'Provincia de Santiago',57),(860,'Provincia de Santiago Rodriguez',57),(861,'Provincia de Santo Domingo',57),(862,'Provincia de Valverde',57),(863,'Provincia Duarte',57),(864,'Provincia Espaillat',57),(865,'Provincia Maria Trinidad Sanchez',57),(866,'Provincia Sanchez Ramirez',57),(867,'Samana Province',57),(868,'Provincia de Bolivar',58),(869,'Provincia de Cotopaxi',58),(870,'Provincia de El Oro',58),(871,'Provincia de Esmeraldas',58),(872,'Provincia de Francisco de Orellana',58),(873,'Provincia de Galapagos',58),(874,'Provincia de Imbabura',58),(875,'Provincia de Loja',58),(876,'Provincia de Los Rios',58),(877,'Provincia de Manabi',58),(878,'Provincia de Morona-Santiago',58),(879,'Provincia de Napo',58),(880,'Provincia de Pichincha',58),(881,'Provincia de Santa Elena',58),(882,'Provincia de Santo Domingo de los Tsachilas',58),(883,'Provincia de Sucumbios',58),(884,'Provincia de Zamora-Chinchipe',58),(885,'Provincia del Azuay',58),(886,'Provincia del Canar',58),(887,'Provincia del Carchi',58),(888,'Provincia del Chimborazo',58),(889,'Provincia del Guayas',58),(890,'Provincia del Pastaza',58),(891,'Provincia del Tungurahua',58),(892,'As Suways',59),(893,'Beheira Governorate',59),(894,'Cairo Governorate',59),(895,'Damietta Governorate',59),(896,'Ismailia Governorate',59),(897,'Kafr ash Shaykh',59),(898,'Muhafazat ad Daqahliyah',59),(899,'Muhafazat al Fayyum',59),(900,'Muhafazat al Gharbiyah',59),(901,'Muhafazat al Iskandariyah',59),(902,'Muhafazat al Jizah',59),(903,'Muhafazat al Minufiyah',59),(904,'Muhafazat al Minya',59),(905,'Muhafazat al Qalyubiyah',59),(906,'Muhafazat al Uqsur',59),(907,'Muhafazat al Wadi al Jadid',59),(908,'Muhafazat ash Sharqiyah',59),(909,'Muhafazat Aswan',59),(910,'Muhafazat Asyut',59),(911,'Muhafazat Bani Suwayf',59),(912,'Muhafazat Bur Sa\'id',59),(913,'Muhafazat Matruh',59),(914,'Muhafazat Qina',59),(915,'Muhafazat Shamal Sina\'',59),(916,'Muhafazat Suhaj',59),(917,'Red Sea Governorate',59),(918,'South Sinai Governorate',59),(919,'Departamento de Ahuachapan',60),(920,'Departamento de Cabanas',60),(921,'Departamento de Chalatenango',60),(922,'Departamento de Cuscatlan',60),(923,'Departamento de La Libertad',60),(924,'Departamento de La Paz',60),(925,'Departamento de La Union',60),(926,'Departamento de Morazan',60),(927,'Departamento de San Miguel',60),(928,'Departamento de San Salvador',60),(929,'Departamento de San Vicente',60),(930,'Departamento de Santa Ana',60),(931,'Departamento de Sonsonate',60),(932,'Departamento de Usulutan',60),(933,'Provincia de Annobon',61),(934,'Provincia de Bioko Norte',61),(935,'Provincia de Bioko Sur',61),(936,'Provincia de Centro Sur',61),(937,'Provincia de Kie-Ntem',61),(938,'Provincia de Litoral',61),(939,'Provincia de Wele-Nzas',61),(940,'Anseba Region',62),(941,'Debub Region',62),(942,'Gash-Barka Region',62),(943,'Maekel Region',62),(944,'Northern Red Sea Region',62),(945,'Southern Red Sea Region',62),(946,'Harjumaa',63),(947,'Hiiumaa',63),(948,'Ida-Virumaa',63),(949,'Jarvamaa',63),(950,'Jogevamaa',63),(951,'Laane-Virumaa',63),(952,'Laeaenemaa',63),(953,'Paernumaa',63),(954,'Polvamaa',63),(955,'Raplamaa',63),(956,'Saaremaa',63),(957,'Tartumaa',63),(958,'Valgamaa',63),(959,'Viljandimaa',63),(960,'Vorumaa',63),(961,'Adis Abeba Astedader',64),(962,'Afar Region',64),(963,'Amhara Region',64),(964,'Benishangul-Gumuz Region',64),(965,'Dire Dawa Region',64),(966,'Gambela Region',64),(967,'Harari Region',64),(968,'Oromiya Region',64),(969,'Somali Region',64),(970,'Southern Nations, Nationalities, and People\'s Region',64),(971,'Tigray Region',64),(972,'Eysturoyar sysla',66),(973,'Nordoyar sysla',66),(974,'Sandoyar Sysla',66),(975,'Streymoyar Sysla',66),(976,'Suduroyar sysla',66),(977,'Vaga Sysla',66),(978,'State of Chuuk',67),(979,'State of Kosrae',67),(980,'State of Pohnpei',67),(981,'State of Yap',67),(982,'Central Division',68),(983,'Eastern Division',68),(984,'Northern Division',68),(985,'Rotuma',68),(986,'Western Division',68),(987,'Etela-Pohjanmaa',69),(988,'Etelae-Karjala',69),(989,'Kainuu',69),(990,'Kanta-Haeme',69),(991,'Keski-Pohjanmaa',69),(992,'Keski-Suomi',69),(993,'Kymenlaakso',69),(994,'Lapland',69),(995,'Paijanne-Tavastland',69),(996,'Pirkanmaa',69),(997,'Pohjanmaa',69),(998,'Pohjois-Karjala',69),(999,'Pohjois-Pohjanmaa',69),(1000,'Pohjois-Savo',69),(1001,'Satakunta',69),(1002,'Southern Savonia',69),(1003,'Uusimaa',69),(1004,'Varsinais-Suomi',69),(1005,'Auvergne-Rhone-Alpes',70),(1006,'Bourgogne-Franche-Comte',70),(1007,'Bretagne',70),(1008,'Centre-Val de Loire',70),(1009,'Corse',70),(1010,'Grand-Est',70),(1011,'Hauts-de-France',70),(1012,'Ile-de-France',70),(1013,'Normandy',70),(1014,'Nouvelle-Aquitaine',70),(1015,'Occitanie',70),(1016,'Pays de la Loire',70),(1017,'Provence-Alpes-Cote d\'Azur',70),(1018,'Guyane',71),(1019,'Iles Australes',72),(1020,'Iles du Vent',72),(1021,'Iles Marquises',72),(1022,'Iles Sous-le-Vent',72),(1023,'Iles Tuamotu-Gambier',72),(1024,'Archipel des Crozet',73),(1025,'Archipel des Kerguelen',73),(1026,'Iles Eparses de l\'ocean Indien',73),(1027,'Iles Saint-Paul et Nouvelle-Amsterdam',73),(1028,'La Terre-Adelie',73),(1029,'Estuaire',74),(1030,'Province de l\'Ogooue-Ivindo',74),(1031,'Province de l\'Ogooue-Lolo',74),(1032,'Province de l\'Ogooue-Maritime',74),(1033,'Province de la Ngounie',74),(1034,'Province de la Nyanga',74),(1035,'Province du Haut-Ogooue',74),(1036,'Province du Moyen-Ogooue',74),(1037,'Province du Woleu-Ntem',74),(1038,'Banjul',75),(1039,'Central River',75),(1040,'Lower River Division',75),(1041,'North Bank',75),(1042,'Upper River',75),(1043,'West Coast',75),(1044,'Abkhazia',76),(1045,'Ajaria',76),(1046,'Guria',76),(1047,'Imereti',76),(1048,'K\'alak\'i T\'bilisi',76),(1049,'Kakheti',76),(1050,'Kvemo Kartli',76),(1051,'Mtskheta-Mtianeti',76),(1052,'Racha-Lechkhumi and Kvemo Svaneti',76),(1053,'Samegrelo-Zemo Svanetis Mkhare',76),(1054,'Samtskhe-Javakheti',76),(1055,'Shida Kartli',76),(1056,'Baden-Wuerttemberg Region',77),(1057,'Bavaria',77),(1058,'Brandenburg',77),(1059,'Bremen',77),(1060,'Free and Hanseatic City of Hamburg',77),(1061,'Hessen',77),(1062,'Land Berlin',77),(1063,'Lower Saxony',77),(1064,'Mecklenburg-Western Pomerania',77),(1065,'Nordrhein-Westfalen',77),(1066,'Rheinland-Pfalz',77),(1067,'Saarland',77),(1068,'Saxony',77),(1069,'Saxony-Anhalt',77),(1070,'Schleswig-Holstein',77),(1071,'Thuringia',77),(1072,'Ashanti Region',78),(1073,'Brong-Ahafo Region',78),(1074,'Central Region',78),(1075,'Eastern Region',78),(1076,'Greater Accra Region',78),(1077,'Northern Region',78),(1078,'Upper East Region',78),(1079,'Upper West Region',78),(1080,'Volta Region',78),(1081,'Western Region',78),(1082,'England',80),(1083,'Northern Ireland',80),(1084,'Scotland',80),(1085,'Wales',80),(1086,'Attica',81),(1087,'Central Greece',81),(1088,'Central Macedonia',81),(1089,'Crete',81),(1090,'Eastern Macedonia and Thrace',81),(1091,'Epirus',81),(1092,'Ionian Islands',81),(1093,'Mount Athos',81),(1094,'North Aegean',81),(1095,'Peloponnese',81),(1096,'South Aegean',81),(1097,'Thessaly',81),(1098,'Western Greece',81),(1099,'Western Macedonia',81),(1100,'Kujalleq',82),(1101,'Qaasuitsup',82),(1102,'Qeqqata',82),(1103,'Sermersooq',82),(1104,'Carriacou and Petite Martinique',83),(1105,'Saint Andrew',83),(1106,'Saint David',83),(1107,'Saint George',83),(1108,'Saint John',83),(1109,'Saint Mark',83),(1110,'Saint Patrick',83),(1111,'Guadeloupe',84),(1112,'Departamento de Alta Verapaz',85),(1113,'Departamento de Baja Verapaz',85),(1114,'Departamento de Chimaltenango',85),(1115,'Departamento de Chiquimula',85),(1116,'Departamento de El Progreso',85),(1117,'Departamento de Escuintla',85),(1118,'Departamento de Guatemala',85),(1119,'Departamento de Huehuetenango',85),(1120,'Departamento de Izabal',85),(1121,'Departamento de Jalapa',85),(1122,'Departamento de Jutiapa',85),(1123,'Departamento de Quetzaltenango',85),(1124,'Departamento de Retalhuleu',85),(1125,'Departamento de Sacatepequez',85),(1126,'Departamento de San Marcos',85),(1127,'Departamento de Santa Rosa',85),(1128,'Departamento de Solola',85),(1129,'Departamento de Suchitepequez',85),(1130,'Departamento de Totonicapan',85),(1131,'Departamento de Zacapa',85),(1132,'Departamento del Peten',85),(1133,'Departamento del Quiche',85),(1134,'Boke Region',86),(1135,'Conakry Region',86),(1136,'Faranah Region',86),(1137,'Kankan Region',86),(1138,'Kindia Region',86),(1139,'Labe Region',86),(1140,'Mamou Region',86),(1141,'Nzerekore Region',86),(1142,'Bafata',87),(1143,'Biombo',87),(1144,'Bissau Region',87),(1145,'Bolama',87),(1146,'Cacheu Region',87),(1147,'Gabu',87),(1148,'Oio Region',87),(1149,'Quinara',87),(1150,'Tombali',87),(1151,'Barima-Waini Region',88),(1152,'Cuyuni-Mazaruni Region',88),(1153,'Demerara-Mahaica Region',88),(1154,'East Berbice-Corentyne Region',88),(1155,'Essequibo Islands-West Demerara Region',88),(1156,'Mahaica-Berbice Region',88),(1157,'Pomeroon-Supenaam Region',88),(1158,'Potaro-Siparuni Region',88),(1159,'Upper Demerara-Berbice Region',88),(1160,'Upper Takutu-Upper Essequibo Region',88),(1161,'Centre',89),(1162,'Departement de l\'Artibonite',89),(1163,'Departement de l\'Ouest',89),(1164,'Departement de Nippes',89),(1165,'Departement du Nord-Est',89),(1166,'Grandans',89),(1167,'Nord',89),(1168,'Nord-Ouest',89),(1169,'Sud',89),(1170,'Sud-Est',89),(1171,'Departamento de Atlantida',90),(1172,'Departamento de Choluteca',90),(1173,'Departamento de Colon',90),(1174,'Departamento de Comayagua',90),(1175,'Departamento de Copan',90),(1176,'Departamento de Cortes',90),(1177,'Departamento de El Paraiso',90),(1178,'Departamento de Francisco Morazan',90),(1179,'Departamento de Gracias a Dios',90),(1180,'Departamento de Intibuca',90),(1181,'Departamento de Islas de la Bahia',90),(1182,'Departamento de La Paz',90),(1183,'Departamento de Lempira',90),(1184,'Departamento de Ocotepeque',90),(1185,'Departamento de Olancho',90),(1186,'Departamento de Santa Barbara',90),(1187,'Departamento de Valle',90),(1188,'Departamento de Yoro',90),(1189,'Central and Western District',91),(1190,'Eastern',91),(1191,'Islands District',91),(1192,'Kowloon City',91),(1193,'Kwai Tsing',91),(1194,'Kwun Tong',91),(1195,'North',91),(1196,'Sai Kung District',91),(1197,'Sha Tin',91),(1198,'Sham Shui Po',91),(1199,'Southern',91),(1200,'Tai Po District',91),(1201,'Tsuen Wan District',91),(1202,'Tuen Mun',91),(1203,'Wan Chai',91),(1204,'Wong Tai Sin',91),(1205,'Yau Tsim Mong',91),(1206,'Yuen Long District',91),(1207,'Bacs-Kiskun county',92),(1208,'Baranya county',92),(1209,'Bekes County',92),(1210,'Borsod-Abauj Zemplen county',92),(1211,'Budapest',92),(1212,'Csongrad megye',92),(1213,'Fejer megye',92),(1214,'Gyor-Moson-Sopron megye',92),(1215,'Hajdu-Bihar',92),(1216,'Heves megye',92),(1217,'Jasz-Nagykun-Szolnok',92),(1218,'Komarom-Esztergom',92),(1219,'Nograd megye',92),(1220,'Pest megye',92),(1221,'Somogy megye',92),(1222,'Szabolcs-Szatmar-Bereg',92),(1223,'Tolna megye',92),(1224,'Vas megye',92),(1225,'Veszprem megye',92),(1226,'Zala megye',92),(1227,'Austurland',93),(1228,'Hoefudborgarsvaedi',93),(1229,'Nordurland Eystra',93),(1230,'Nordurland Vestra',93),(1231,'Sudurland',93),(1232,'Sudurnes',93),(1233,'Vestfirdir',93),(1234,'Vesturland',93),(1235,'Assam',94),(1236,'Goa',94),(1237,'Madhya Pradesh',94),(1238,'Manipur',94),(1239,'Meghalaya',94),(1240,'Mizoram',94),(1241,'National Capital Territory of Delhi',94),(1242,'Sikkim',94),(1243,'State of Andhra Pradesh',94),(1244,'State of Arunachal Pradesh',94),(1245,'State of Bihar',94),(1246,'State of Chhattisgarh',94),(1247,'State of Gujarat',94),(1248,'State of Haryana',94),(1249,'State of Himachal Pradesh',94),(1250,'State of Jammu and Kashmir',94),(1251,'State of Jharkhand',94),(1252,'State of Karnataka',94),(1253,'State of Kerala',94),(1254,'State of Maharashtra',94),(1255,'State of Nagaland',94),(1256,'State of Odisha',94),(1257,'State of Punjab',94),(1258,'State of Rajasthan',94),(1259,'State of Tamil Nadu',94),(1260,'State of Uttarakhand',94),(1261,'Telangana',94),(1262,'Tripura',94),(1263,'Union Territory of Andaman and Nicobar Islands',94),(1264,'Union Territory of Chandigarh',94),(1265,'Union Territory of Dadra and Nagar Haveli',94),(1266,'Union Territory of Daman and Diu',94),(1267,'Union Territory of Lakshadweep',94),(1268,'Union Territory of Puducherry',94),(1269,'Uttar Pradesh',94),(1270,'West Bengal',94),(1271,'Banten',95),(1272,'Daerah Istimewa Yogyakarta',95),(1273,'Daerah Khusus Ibukota Jakarta',95),(1274,'Jawa Barat',95),(1275,'Jawa Timur',95),(1276,'Kepulauan Bangka Belitung',95),(1277,'Nanggroe Aceh Darussalam Province',95),(1278,'North Kalimantan',95),(1279,'Propinsi Bengkulu',95),(1280,'Provinsi Bali',95),(1281,'Provinsi Gorontalo',95),(1282,'Provinsi Jambi',95),(1283,'Provinsi Jawa Tengah',95),(1284,'Provinsi Kalimantan Barat',95),(1285,'Provinsi Kalimantan Selatan',95),(1286,'Provinsi Kalimantan Tengah',95),(1287,'Provinsi Kalimantan Timur',95),(1288,'Provinsi Kepulauan Riau',95),(1289,'Provinsi Lampung',95),(1290,'Provinsi Maluku',95),(1291,'Provinsi Maluku Utara',95),(1292,'Provinsi Nusa Tenggara Timur',95),(1293,'Provinsi Papua',95),(1294,'Provinsi Papua Barat',95),(1295,'Provinsi Riau',95),(1296,'Provinsi Sulawesi Barat',95),(1297,'Provinsi Sulawesi Selatan',95),(1298,'Provinsi Sumatera Barat',95),(1299,'Sulawesi Tengah',95),(1300,'Sulawesi Tenggara',95),(1301,'Sulawesi Utara',95),(1302,'Sumatera Selatan',95),(1303,'Sumatera Utara',95),(1304,'West Nusa Tenggara',95),(1305,'Alborz',96),(1306,'Bushehr',96),(1307,'East Azerbaijan',96),(1308,'Fars',96),(1309,'Hormozgan',96),(1310,'Isfahan',96),(1311,'Kerman',96),(1312,'Khuzestan',96),(1313,'Ostan-e Ardabil',96),(1314,'Ostan-e Azarbayjan-e Gharbi',96),(1315,'Ostan-e Chahar Mahal va Bakhtiari',96),(1316,'Ostan-e Gilan',96),(1317,'Ostan-e Golestan',96),(1318,'Ostan-e Hamadan',96),(1319,'Ostan-e Ilam',96),(1320,'Ostan-e Kermanshah',96),(1321,'Ostan-e Khorasan-e Jonubi',96),(1322,'Ostan-e Khorasan-e Razavi',96),(1323,'Ostan-e Khorasan-e Shomali',96),(1324,'Ostan-e Kohgiluyeh va Bowyer Ahmad',96),(1325,'Ostan-e Kordestan',96),(1326,'Ostan-e Lorestan',96),(1327,'Ostan-e Markazi',96),(1328,'Ostan-e Mazandaran',96),(1329,'Ostan-e Qazvin',96),(1330,'Ostan-e Semnan',96),(1331,'Ostan-e Tehran',96),(1332,'Ostan-e Zanjan',96),(1333,'Qom',96),(1334,'Sistan and Baluchestan',96),(1335,'Yazd',96),(1336,'An Najaf',97),(1337,'Dihok',97),(1338,'Diyala',97),(1339,'Muhafazat al Anbar',97),(1340,'Muhafazat al Basrah',97),(1341,'Muhafazat al Muthanna',97),(1342,'Muhafazat al Qadisiyah',97),(1343,'Muhafazat Arbil',97),(1344,'Muhafazat as Sulaymaniyah',97),(1345,'Muhafazat Babil',97),(1346,'Muhafazat Baghdad',97),(1347,'Muhafazat Dhi Qar',97),(1348,'Muhafazat Karbala\'',97),(1349,'Muhafazat Kirkuk',97),(1350,'Muhafazat Maysan',97),(1351,'Muhafazat Ninawa',97),(1352,'Muhafazat Salah ad Din',97),(1353,'Muhafazat Wasit',97),(1354,'Connaught',98),(1355,'Leinster',98),(1356,'Munster',98),(1357,'Ulster',98),(1358,'Central District',99),(1359,'Haifa',99),(1360,'Jerusalem',99),(1361,'Northern District',99),(1362,'Southern District',99),(1363,'Tel Aviv District',99),(1364,'Abruzzo',100),(1365,'Basilicata',100),(1366,'Calabria',100),(1367,'Campania',100),(1368,'Emilia-Romagna',100),(1369,'Friuli Venezia Giulia',100),(1370,'Lazio',100),(1371,'Liguria',100),(1372,'Lombardia',100),(1373,'Marche',100),(1374,'Molise',100),(1375,'Piemonte',100),(1376,'Puglia',100),(1377,'Regione Autonoma Valle d\'Aosta',100),(1378,'Sardegna',100),(1379,'Sicilia',100),(1380,'Toscana',100),(1381,'Trentino-Alto Adige',100),(1382,'Umbria',100),(1383,'Veneto',100),(1384,'Clarendon',101),(1385,'Kingston',101),(1386,'Manchester',101),(1387,'Parish of Hanover',101),(1388,'Parish of Saint Ann',101),(1389,'Portland',101),(1390,'Saint Andrew',101),(1391,'Saint Catherine',101),(1392,'Saint Elizabeth',101),(1393,'Saint James',101),(1394,'Saint Mary',101),(1395,'Saint Thomas',101),(1396,'Trelawny',101),(1397,'Westmoreland',101),(1398,'Aichi-ken',102),(1399,'Akita',102),(1400,'Aomori-ken',102),(1401,'Chiba-ken',102),(1402,'Ehime',102),(1403,'Fukui',102),(1404,'Fukuoka Prefecture',102),(1405,'Fukushima-ken',102),(1406,'Gifu',102),(1407,'Gunma-ken',102),(1408,'Hiroshima-ken',102),(1409,'Hokkaido',102),(1410,'Hyogo',102),(1411,'Ibaraki',102),(1412,'Ishikawa-ken',102),(1413,'Iwate',102),(1414,'Kagawa-ken',102),(1415,'Kagoshima-ken',102),(1416,'Kanagawa',102),(1417,'Kochi Prefecture',102),(1418,'Kumamoto',102),(1419,'Kyoto Prefecture',102),(1420,'Mie-ken',102),(1421,'Miyagi-ken',102),(1422,'Miyazaki',102),(1423,'Nagano-ken',102),(1424,'Nagasaki Prefecture',102),(1425,'Nara-ken',102),(1426,'Niigata-ken',102),(1427,'Oita Prefecture',102),(1428,'Okayama-ken',102),(1429,'Okinawa',102),(1430,'Osaka-fu',102),(1431,'Saga-ken',102),(1432,'Saitama-ken',102),(1433,'Shiga',102),(1434,'Shimane-ken',102),(1435,'Shizuoka',102),(1436,'Tochigi',102),(1437,'Tokushima-ken',102),(1438,'Tokyo Prefecture',102),(1439,'Tottori',102),(1440,'Toyama-ken',102),(1441,'Wakayama',102),(1442,'Yamagata-ken',102),(1443,'Yamaguchi',102),(1444,'Yamanashi',102),(1445,'Ajloun',103),(1446,'Al Karak',103),(1447,'Al Mafraq',103),(1448,'Amman Governorate',103),(1449,'Irbid',103),(1450,'Jerash',103),(1451,'Muhafazat al \'Aqabah',103),(1452,'Muhafazat al Balqa\'',103),(1453,'Muhafazat at Tafilah',103),(1454,'Muhafazat az Zarqa\'',103),(1455,'Muhafazat Ma\'an',103),(1456,'Muhafazat Madaba',103),(1457,'Aktyubinskaya Oblast\'',104),(1458,'Almaty Oblysy',104),(1459,'Almaty Qalasy',104),(1460,'Aqmola Oblysy',104),(1461,'Astana Qalasy',104),(1462,'Atyrau Oblysy',104),(1463,'Baikonur',104),(1464,'East Kazakhstan',104),(1465,'Mangistauskaya Oblast\'',104),(1466,'North Kazakhstan',104),(1467,'Pavlodar Oblysy',104),(1468,'Qaraghandy Oblysy',104),(1469,'Qostanay Oblysy',104),(1470,'Qyzylorda Oblysy',104),(1471,'South Kazakhstan',104),(1472,'West Kazakhstan',104),(1473,'Zhambyl Oblysy',104),(1474,'Baringo District',105),(1475,'Bomet District',105),(1476,'Bungoma District',105),(1477,'Busia District',105),(1478,'Embu District',105),(1479,'Garissa District',105),(1480,'Homa Bay District',105),(1481,'Isiolo District',105),(1482,'Kajiado District',105),(1483,'Kakamega District',105),(1484,'Kericho District',105),(1485,'Kiambu District',105),(1486,'Kilifi District',105),(1487,'Kirinyaga District',105),(1488,'Kisii District',105),(1489,'Kisumu',105),(1490,'Kitui District',105),(1491,'Kwale District',105),(1492,'Laikipia District',105),(1493,'Lamu',105),(1494,'Machakos District',105),(1495,'Makueni District',105),(1496,'Mandera District',105),(1497,'Marakwet District',105),(1498,'Marsabit District',105),(1499,'Meru',105),(1500,'Migori District',105),(1501,'Mombasa District',105),(1502,'Murang\'a District',105),(1503,'Nairobi Province',105),(1504,'Nakuru District',105),(1505,'Nandi South District',105),(1506,'Narok District',105),(1507,'Nyamira District',105),(1508,'Nyandarua District',105),(1509,'Nyeri District',105),(1510,'Samburu District',105),(1511,'Siaya District',105),(1512,'Taita Taveta District',105),(1513,'Tana River District',105),(1514,'Tharaka District',105),(1515,'Trans Nzoia District',105),(1516,'Turkana District',105),(1517,'Uasin Gishu',105),(1518,'Vihiga District',105),(1519,'Wajir District',105),(1520,'West Pokot District',105),(1521,'Gilbert Islands',106),(1522,'Line Islands',106),(1523,'Phoenix Islands',106),(1524,'Chagang-do',107),(1525,'Hambuk',107),(1526,'Hamnam',107),(1527,'Hwanghae-bukto',107),(1528,'Hwanghae-namdo',107),(1529,'Kangwon-do',107),(1530,'P\'yongan-bukto',107),(1531,'P\'yongan-namdo',107),(1532,'Pyongyang',107),(1533,'Rason',107),(1534,'Ryanggang',107),(1535,'Busan',108),(1536,'Chungcheongbuk-do',108),(1537,'Chungcheongnam-do',108),(1538,'Daegu',108),(1539,'Daejeon',108),(1540,'Gangwon-do',108),(1541,'Gwangju',108),(1542,'Gyeonggi-do',108),(1543,'Gyeongsangbuk-do',108),(1544,'Gyeongsangnam-do',108),(1545,'Incheon',108),(1546,'Jeju-do',108),(1547,'Jeollabuk-do',108),(1548,'Jeollanam-do',108),(1549,'Sejong-si',108),(1550,'Seoul',108),(1551,'Ulsan',108),(1552,'Al Asimah Governorate',109),(1553,'Muhafazat al Ahmadi',109),(1554,'Muhafazat al Farwaniyah',109),(1555,'Muhafazat al Jahra\'',109),(1556,'Muhafazat Hawalli',109),(1557,'Muhafazat Mubarak al Kabir',109),(1558,'Batken',110),(1559,'Chuyskaya Oblast\'',110),(1560,'Gorod Bishkek',110),(1561,'Issyk-Kul Region',110),(1562,'Jalal-Abad oblast',110),(1563,'Naryn oblast',110),(1564,'Osh City',110),(1565,'Osh Oblasty',110),(1566,'Talas',110),(1567,'Attapu',111),(1568,'Bolikhamxai',111),(1569,'Champasak',111),(1570,'Houaphan',111),(1571,'Khammouan',111),(1572,'Khoueng Bokeo',111),(1573,'Khoueng Oudomxai',111),(1574,'Khoueng Phongsali',111),(1575,'Khoueng Savannakhet',111),(1576,'Khoueng Xekong',111),(1577,'Louangnamtha',111),(1578,'Luang Prabang Province',111),(1579,'Salavan',111),(1580,'Vientiane Prefecture',111),(1581,'Vientiane Province',111),(1582,'Xaignabouli',111),(1583,'Xaisomboun Province',111),(1584,'Xiangkhouang',111),(1585,'Adazu Novads',112),(1586,'Aglonas Novads',112),(1587,'Aizkraukles Rajons',112),(1588,'Aizputes Novads',112),(1589,'Aknistes Novads',112),(1590,'Alojas Novads',112),(1591,'Alsungas Novads',112),(1592,'Aluksnes Novads',112),(1593,'Amatas Novads',112),(1594,'Apes Novads',112),(1595,'Auces Novads',112),(1596,'Babites Novads',112),(1597,'Baldones Novads',112),(1598,'Baltinavas Novads',112),(1599,'Balvu Novads',112),(1600,'Bauskas Novads',112),(1601,'Beverinas Novads',112),(1602,'Brocenu Novads',112),(1603,'Burtnieku Novads',112),(1604,'Carnikavas Novads',112),(1605,'Cesu Novads',112),(1606,'Cesvaines Novads',112),(1607,'Ciblas Novads',112),(1608,'Dagdas Novads',112),(1609,'Daugavpils',112),(1610,'Daugavpils municipality',112),(1611,'Dobeles Rajons',112),(1612,'Dundagas Novads',112),(1613,'Durbes Novads',112),(1614,'Engures Novads',112),(1615,'Erglu Novads',112),(1616,'Garkalne Municipality',112),(1617,'Grobinas Novads',112),(1618,'Gulbenes Rajons',112),(1619,'Iecavas Novads',112),(1620,'Ikskiles Novads',112),(1621,'Ilukstes Novads',112),(1622,'Incukalna Novads',112),(1623,'Jaunjelgavas Novads',112),(1624,'Jaunpiebalgas Novads',112),(1625,'Jaunpils Novads',112),(1626,'Jekabpils',112),(1627,'Jekabpils Municipality',112),(1628,'Jelgava',112),(1629,'Jelgavas Rajons',112),(1630,'Jurmala',112),(1631,'Kandavas Novads',112),(1632,'Karsavas Novads',112),(1633,'Keguma Novads',112),(1634,'Kekavas Novads',112),(1635,'Kocenu Novads',112),(1636,'Kokneses Novads',112),(1637,'Kraslavas Rajons',112),(1638,'Krimuldas Novads',112),(1639,'Krustpils Novads',112),(1640,'Kuldigas Rajons',112),(1641,'Lielvardes Novads',112),(1642,'Liepaja',112),(1643,'Ligatnes Novads',112),(1644,'Limbazu Rajons',112),(1645,'Livanu Novads',112),(1646,'Lubanas Novads',112),(1647,'Ludzas Rajons',112),(1648,'Madona Municipality',112),(1649,'Malpils Novads',112),(1650,'Marupes Novads',112),(1651,'Mazsalacas Novads',112),(1652,'Mersraga Novads',112),(1653,'Nauksenu Novads',112),(1654,'Neretas Novads',112),(1655,'Nicas Novads',112),(1656,'Ogres novads',112),(1657,'Olaines Novads',112),(1658,'Ozolnieku Novads',112),(1659,'Pargaujas Novads',112),(1660,'Pavilostas Novads',112),(1661,'Plavinu Novads',112),(1662,'Preili Municipality',112),(1663,'Priekules Novads',112),(1664,'Priekuli Municipality',112),(1665,'Raunas Novads',112),(1666,'Rezekne',112),(1667,'Rezeknes Novads',112),(1668,'Riebinu Novads',112),(1669,'Riga',112),(1670,'Rojas Novads',112),(1671,'Ropazu Novads',112),(1672,'Rucavas Novads',112),(1673,'Rugaju Novads',112),(1674,'Rujienas Novads',112),(1675,'Rundales Novads',112),(1676,'Salacgrivas Novads',112),(1677,'Salas Novads',112),(1678,'Salaspils Novads',112),(1679,'Saldus Municipality',112),(1680,'Saulkrastu Novads',112),(1681,'Sejas Novads',112),(1682,'Siguldas Novads',112),(1683,'Skriveru Novads',112),(1684,'Skrundas Novads',112),(1685,'Smiltenes Novads',112),(1686,'Stopinu Novads',112),(1687,'Strencu Novads',112),(1688,'Talsi Municipality',112),(1689,'Tervetes Novads',112),(1690,'Tukuma Rajons',112),(1691,'Vainodes Novads',112),(1692,'Valka Municipality',112),(1693,'Valmiera District',112),(1694,'Varaklanu Novads',112),(1695,'Varkavas Novads',112),(1696,'Vecpiebalgas Novads',112),(1697,'Vecumnieku Novads',112),(1698,'Ventspils',112),(1699,'Ventspils Municipality',112),(1700,'Viesites Novads',112),(1701,'Vilakas Novads',112),(1702,'Vilanu Novads',112),(1703,'Zilupes Novads',112),(1704,'Beyrouth',113),(1705,'Mohafazat Aakkar',113),(1706,'Mohafazat Baalbek-Hermel',113),(1707,'Mohafazat Beqaa',113),(1708,'Mohafazat Liban-Nord',113),(1709,'Mohafazat Liban-Sud',113),(1710,'Mohafazat Mont-Liban',113),(1711,'Mohafazat Nabatiye',113),(1712,'Berea',114),(1713,'Butha-Buthe',114),(1714,'Leribe District',114),(1715,'Mafeteng District',114),(1716,'Maseru',114),(1717,'Mohale\'s Hoek District',114),(1718,'Mokhotlong',114),(1719,'Qacha\'s Nek',114),(1720,'Quthing',114),(1721,'Thaba-Tseka',114),(1722,'Bomi County',115),(1723,'Bong County',115),(1724,'Gbarpolu County',115),(1725,'Grand Bassa County',115),(1726,'Grand Cape Mount County',115),(1727,'Grand Gedeh County',115),(1728,'Grand Kru County',115),(1729,'Lofa County',115),(1730,'Margibi County',115),(1731,'Maryland County',115),(1732,'Montserrado County',115),(1733,'Nimba County',115),(1734,'River Cess County',115),(1735,'River Gee County',115),(1736,'Sinoe County',115),(1737,'Al Jufrah',116),(1738,'Al Kufrah',116),(1739,'Al Marj',116),(1740,'Al Marqab',116),(1741,'Darnah',116),(1742,'Jabal al Gharbi District',116),(1743,'Murzuq',116),(1745,'Sha\'biyat al Butnan',116),(1746,'Sha\'biyat al Jabal al Akhdar',116),(1747,'Sha\'biyat al Jafarah',116),(1748,'Sha\'biyat al Wahat',116),(1749,'Sha\'biyat an Nuqat al Khams',116),(1750,'Sha\'biyat az Zawiyah',116),(1751,'Sha\'biyat Banghazi',116),(1752,'Sha\'biyat Ghat',116),(1753,'Sha\'biyat Misratah',116),(1754,'Sha\'biyat Sabha',116),(1755,'Sha\'biyat Wadi al Hayat',116),(1756,'Sha\'biyat Wadi ash Shati\'',116),(1744,'Sha`biyat Nalut',116),(1757,'Surt',116),(1758,'Tripoli',116),(1759,'Balzers',117),(1760,'Eschen',117),(1761,'Gamprin',117),(1762,'Mauren',117),(1763,'Planken',117),(1764,'Ruggell',117),(1765,'Schaan',117),(1766,'Schellenberg',117),(1767,'Triesen',117),(1768,'Triesenberg',117),(1769,'Vaduz',117),(1770,'Alytus County',118),(1771,'Kaunas County',118),(1772,'Klaipeda County',118),(1773,'Marijampole County',118),(1774,'Panevezys',118),(1775,'Siauliai County',118),(1776,'Taurage County',118),(1777,'Telsiu apskritis',118),(1778,'Utena County',118),(1779,'Vilniaus apskritis',118),(1780,'Canton d\'Echternach',119),(1781,'Canton d\'Esch-sur-Alzette',119),(1782,'Capellen',119),(1783,'Clervaux',119),(1784,'Diekirch',119),(1785,'Grevenmacher',119),(1786,'Luxembourg',119),(1787,'Mersch',119),(1788,'Redange',119),(1789,'Remich',119),(1790,'Vianden',119),(1791,'Wiltz',119),(1792,'Aerodrom',121),(1793,'Berovo',121),(1794,'Bitola',121),(1795,'Bogdanci',121),(1796,'Bogovinje',121),(1797,'Bosilovo',121),(1798,'Brvenica',121),(1799,'Butel',121),(1800,'Cair',121),(1801,'Cesinovo-Oblesevo',121),(1802,'Debar',121),(1803,'Debarca',121),(1804,'Demir Hisar',121),(1805,'Demir Kapija',121),(1806,'Dolneni',121),(1807,'Drugovo',121),(1808,'Gazi Baba',121),(1809,'Gevgelija',121),(1810,'Gostivar',121),(1811,'Grad Skopje',121),(1812,'Gradsko',121),(1813,'Ilinden',121),(1814,'Jegunovce',121),(1815,'Karbinci',121),(1816,'Kavadarci',121),(1817,'Kisela Voda',121),(1818,'Kratovo',121),(1819,'Kriva Palanka',121),(1820,'Kumanovo',121),(1821,'Lozovo',121),(1822,'Makedonska Kamenica',121),(1823,'Makedonski Brod',121),(1824,'Mogila',121),(1825,'Negotino',121),(1826,'Novaci',121),(1827,'Novo Selo',121),(1828,'Ohrid',121),(1829,'Opstina Aracinovo',121),(1830,'Opstina Caska',121),(1831,'Opstina Centar',121),(1832,'Opstina Centar Zupa',121),(1833,'Opstina Cucer-Sandevo',121),(1834,'Opstina Delcevo',121),(1835,'Opstina Dojran',121),(1836,'Opstina Gjorce Petrov',121),(1837,'Opstina Karpos',121),(1838,'Opstina Kicevo',121),(1839,'Opstina Kocani',121),(1840,'Opstina Konce',121),(1841,'Opstina Krivogastani',121),(1842,'Opstina Krusevo',121),(1843,'Opstina Lipkovo',121),(1844,'Opstina Mavrovo i Rostusa',121),(1845,'Opstina Pehcevo',121),(1846,'Opstina Probistip',121),(1847,'Opstina Radovis',121),(1848,'Opstina Rankovce',121),(1849,'Opstina Sopiste',121),(1850,'Opstina Staro Nagoricane',121),(1851,'Opstina Stip',121),(1852,'Opstina Studenicani',121),(1853,'Opstina Vevcani',121),(1854,'Opstina Vranestica',121),(1855,'Opstina Vrapciste',121),(1856,'Opstina Zelino',121),(1857,'Oslomej',121),(1858,'Petrovec',121),(1859,'Plasnica',121),(1860,'Prilep',121),(1861,'Resen',121),(1862,'Rosoman',121),(1863,'Saraj',121),(1864,'Struga',121),(1865,'Strumica',121),(1866,'Suto Orizari',121),(1867,'Sveti Nikole',121),(1868,'Tearce',121),(1869,'Tetovo',121),(1870,'Valandovo',121),(1871,'Vasilevo',121),(1872,'Veles',121),(1873,'Vinica',121),(1874,'Zajas',121),(1875,'Zelenikovo',121),(1876,'Zrnovci',121),(1877,'Alaotra Mangoro Region',122),(1878,'Amoron\'i Mania Region',122),(1879,'Analamanga Region',122),(1880,'Analanjirofo Region',122),(1881,'Androy Region',122),(1882,'Anosy Region',122),(1883,'Atsimo-Andrefana Region',122),(1884,'Atsimo-Atsinanana Region',122),(1885,'Atsinanana Region',122),(1886,'Betsiboka Region',122),(1887,'Boeny Region',122),(1888,'Bongolava Region',122),(1889,'Diana Region',122),(1890,'Haute Matsiatra Region',122),(1891,'Ihorombe Region',122),(1892,'Itasy Region',122),(1893,'Melaky Region',122),(1894,'Menabe Region',122),(1895,'Sava Region',122),(1896,'Sofia Region',122),(1897,'Vakinankaratra Region',122),(1898,'Vatovavy Fitovinany Region',122),(1899,'Central Region',123),(1900,'Northern Region',123),(1901,'Southern Region',123),(1902,'Johor',124),(1903,'Kedah',124),(1904,'Kelantan',124),(1905,'Kuala Lumpur',124),(1906,'Labuan',124),(1907,'Melaka',124),(1908,'Negeri Sembilan',124),(1909,'Pahang',124),(1910,'Perak',124),(1911,'Perlis',124),(1912,'Pulau Pinang',124),(1913,'Putrajaya',124),(1914,'Sabah',124),(1915,'Sarawak',124),(1916,'Selangor',124),(1917,'Terengganu',124),(1918,'Alifu Atholhu',125),(1919,'Baa Atholhu',125),(1920,'Dhaalu Atholhu',125),(1921,'Faafu Atholhu',125),(1922,'Gaafu Alifu Atholhu',125),(1923,'Gaafu Dhaalu Atholhu',125),(1924,'Gnaviyani Atholhu',125),(1925,'Haa Alifu Atholhu',125),(1926,'Haa Dhaalu Atholhu',125),(1927,'Kaafu Atoll',125),(1928,'Laamu Atholhu',125),(1929,'Lhaviyani Atholhu',125),(1930,'Meemu Atholhu',125),(1931,'Noonu Atoll',125),(1932,'Raa Atholhu',125),(1933,'Seenu Atholhu',125),(1934,'Shaviyani Atholhu',125),(1935,'Southern Ari Atoll',125),(1936,'Thaa Atholhu',125),(1937,'Vaavu Atholhu',125),(1938,'Bamako Region',126),(1939,'Gao Region',126),(1940,'Kayes Region',126),(1941,'Kidal Region',126),(1942,'Koulikoro Region',126),(1943,'Mopti Region',126),(1944,'Segou Region',126),(1945,'Sikasso Region',126),(1946,'Tombouctou Region',126),(1947,'Attard',127),(1948,'Balzan',127),(1949,'Birkirkara',127),(1950,'Birzebbuga',127),(1951,'Bormla',127),(1952,'Dingli',127),(1953,'Ghajnsielem',127),(1954,'Hal Gharghur',127),(1955,'Hal Ghaxaq',127),(1956,'Haz-Zabbar',127),(1957,'Haz-Zebbug',127),(1958,'Il-Belt Valletta',127),(1959,'Il-Birgu',127),(1960,'Il-Fgura',127),(1961,'Il-Fontana',127),(1962,'Il-Furjana',127),(1963,'Il-Gudja',127),(1964,'Il-Gzira',127),(1965,'Il-Hamrun',127),(1966,'Il-Kalkara',127),(1967,'Il-Marsa',127),(1968,'Il-Mellieha',127),(1969,'Il-Mosta',127),(1970,'Il-Munxar',127),(1971,'Il-Qala',127),(1972,'Il-Qrendi',127),(1973,'In-Nadur',127),(1974,'In-Naxxar',127),(1975,'Ir-Rabat',127),(1976,'Is-Siggiewi',127),(1977,'Is-Swieqi',127),(1978,'Ix-Xaghra',127),(1979,'Ix-Xewkija',127),(1980,'Ix-Xghajra',127),(1981,'Iz-Zebbug',127),(1982,'Iz-Zejtun',127),(1983,'Iz-Zurrieq',127),(1984,'Kirkop',127),(1985,'L-Gharb',127),(1986,'L-Ghasri',127),(1987,'L-Iklin',127),(1988,'L-Imdina',127),(1989,'L-Imgarr',127),(1990,'L-Imqabba',127),(1991,'L-Imsida',127),(1992,'L-Imtarfa',127),(1993,'L-Isla',127),(1994,'Lija',127),(1995,'Luqa',127),(1996,'Marsaskala',127),(1997,'Marsaxlokk',127),(1998,'Paola',127),(1999,'Pembroke',127),(2000,'Qormi',127),(2001,'Safi',127),(2002,'Saint John',127),(2003,'Saint Julian\'s',127),(2004,'Saint Lawrence',127),(2005,'Saint Lucia',127),(2006,'Saint Paul\'s Bay',127),(2007,'Saint Venera',127),(2008,'Sannat',127),(2009,'Ta\' Kercem',127),(2010,'Ta\' Xbiex',127),(2011,'Tal-Pieta',127),(2012,'Tarxien',127),(2013,'Tas-Sliema',127),(2014,'Victoria',127),(2015,'Ailinginae Atoll',128),(2016,'Ailinglaplap Atoll',128),(2017,'Ailuk Atoll',128),(2018,'Arno Atoll',128),(2019,'Aur Atoll',128),(2020,'Bikar Atoll',128),(2021,'Bikini Atoll',128),(2022,'Bokak Atoll',128),(2023,'Ebon Atoll',128),(2024,'Enewetak Atoll',128),(2025,'Erikub Atoll',128),(2026,'Jabat Island',128),(2027,'Jaluit Atoll',128),(2028,'Jemo Island',128),(2029,'Kili Island',128),(2030,'Kwajalein Atoll',128),(2031,'Lae Atoll',128),(2032,'Lib Island',128),(2033,'Likiep Atoll',128),(2034,'Majuro Atoll',128),(2035,'Maloelap Atoll',128),(2036,'Mejit Island',128),(2037,'Mili Atoll',128),(2038,'Namdrik Atoll',128),(2039,'Namu Atoll',128),(2040,'Rongelap Atoll',128),(2041,'Rongrik Atoll',128),(2042,'Taka Atoll',128),(2043,'Ujae Atoll',128),(2044,'Ujelang Atoll',128),(2045,'Utrik Atoll',128),(2046,'Wotho Atoll',128),(2047,'Wotje Atoll',128),(2048,'Martinique',129),(2049,'Adrar',130),(2050,'Assaba',130),(2051,'Brakna',130),(2052,'Dakhlet Nouadhibou',130),(2053,'Gorgol',130),(2054,'Guidimaka',130),(2055,'Hodh ech Chargui',130),(2056,'Hodh El Gharbi',130),(2057,'Inchiri',130),(2058,'Nouakchott Nord',130),(2059,'Nouakchott Ouest',130),(2060,'Nouakchott Sud',130),(2061,'Tagant',130),(2062,'Tiris Zemmour',130),(2063,'Wilaya du Trarza',130),(2064,'Agalega Islands',131),(2065,'Black River District',131),(2066,'Cargados Carajos',131),(2067,'Flacq District',131),(2068,'Grand Port District',131),(2069,'Moka District',131),(2070,'Pamplemousses District',131),(2071,'Plaines Wilhems District',131),(2072,'Port Louis District',131),(2073,'Riviere du Rempart District',131),(2074,'Rodrigues',131),(2075,'Savanne District',131),(2076,'Acoua',132),(2077,'Bandraboua',132),(2078,'Bandrele',132),(2079,'Boueni',132),(2080,'Chiconi',132),(2081,'Chirongui',132),(2082,'Dembeni',132),(2083,'Dzaoudzi',132),(2084,'Kani-Keli',132),(2085,'Koungou',132),(2086,'M\'Tsangamouji',132),(2087,'Mamoudzou',132),(2088,'Mtsamboro',132),(2089,'Ouangani',132),(2090,'Pamandzi',132),(2091,'Sada',132),(2092,'Tsingoni',132),(2093,'Ciudad de Mexico',133),(2094,'Estado de Aguascalientes',133),(2095,'Estado de Baja California',133),(2096,'Estado de Baja California Sur',133),(2097,'Estado de Campeche',133),(2098,'Estado de Chiapas',133),(2099,'Estado de Chihuahua',133),(2100,'Estado de Coahuila de Zaragoza',133),(2101,'Estado de Colima',133),(2102,'Estado de Durango',133),(2103,'Estado de Guanajuato',133),(2104,'Estado de Guerrero',133),(2105,'Estado de Hidalgo',133),(2106,'Estado de Jalisco',133),(2107,'Estado de Mexico',133),(2108,'Estado de Michoacan de Ocampo',133),(2109,'Estado de Morelos',133),(2110,'Estado de Nayarit',133),(2111,'Estado de Nuevo Leon',133),(2112,'Estado de Oaxaca',133),(2113,'Estado de Puebla',133),(2114,'Estado de Queretaro',133),(2115,'Estado de Quintana Roo',133),(2116,'Estado de San Luis Potosi',133),(2117,'Estado de Sinaloa',133),(2118,'Estado de Sonora',133),(2119,'Estado de Tabasco',133),(2120,'Estado de Tamaulipas',133),(2121,'Estado de Tlaxcala',133),(2122,'Estado de Veracruz-Llave',133),(2123,'Estado de Yucatan',133),(2124,'Estado de Zacatecas',133),(2125,'Anenii Noi',134),(2126,'Basarabeasca',134),(2127,'Briceni',134),(2128,'Cantemir',134),(2129,'Cimislia',134),(2130,'Criuleni',134),(2131,'Donduseni',134),(2132,'Falesti',134),(2133,'Floresti',134),(2134,'Gagauzia',134),(2135,'Glodeni',134),(2136,'Hincesti',134),(2137,'Ialoveni',134),(2138,'Leova',134),(2139,'Municipiul Balti',134),(2140,'Municipiul Bender',134),(2141,'Municipiul Chisinau',134),(2142,'Nisporeni',134),(2143,'Orhei',134),(2144,'Raionul Cahul',134),(2145,'Raionul Calarasi',134),(2146,'Raionul Causeni',134),(2147,'Raionul Drochia',134),(2148,'Raionul Dubasari',134),(2149,'Raionul Edinet',134),(2150,'Raionul Ocnita',134),(2151,'Raionul Soroca',134),(2152,'Raionul Stefan Voda',134),(2153,'Raionul Straseni',134),(2154,'Raionul Ungheni',134),(2155,'Rezina',134),(2156,'Riscani',134),(2157,'Singerei',134),(2158,'Soldanesti',134),(2159,'Taraclia',134),(2160,'Telenesti',134),(2161,'Unitatea Teritoriala din Stinga Nistrului',134),(2162,'Commune de Monaco',135),(2163,'Arhangay Aymag',136),(2164,'Bayan-OElgiy Aymag',136),(2165,'Bayanhongor Aymag',136),(2166,'Bulgan',136),(2167,'Darhan-Uul Aymag',136),(2168,'Dornod Aymag',136),(2169,'Dornogovi Aymag',136),(2170,'Dundgovi Aymag',136),(2171,'Dzavhan Aymag',136),(2172,'Govi-Altay Aymag',136),(2173,'Govi-Sumber',136),(2174,'Hentiy Aymag',136),(2175,'Hovd',136),(2176,'Hovsgol Aymag',136),(2177,'OEmnoegovi Province',136),(2178,'OEvoerhangay Aymag',136),(2179,'Orhon Aymag',136),(2180,'Selenge Aymag',136),(2181,'Suhbaatar Aymag',136),(2182,'Tov Aymag',136),(2183,'Ulaanbaatar Hot',136),(2184,'Uvs Aymag',136),(2185,'Parish of Saint Anthony',137),(2186,'Parish of Saint Georges',137),(2187,'Parish of Saint Peter',137),(2188,'Beni Mellal-Khenifra',138),(2189,'Casablanca-Settat',138),(2190,'Dakhla-Oued Ed-Dahab',138),(2191,'Draa-Tafilalet',138),(2192,'Fes-Meknes',138),(2193,'Guelmim-Oued Noun',138),(2194,'Laayoune-Sakia El Hamra',138),(2195,'Marrakesh-Safi',138),(2196,'Oriental',138),(2197,'Rabat-Sale-Kenitra',138),(2198,'Souss-Massa',138),(2199,'Tanger-Tetouan-Al Hoceima',138),(2200,'Cabo Delgado Province',139),(2201,'Cidade de Maputo',139),(2202,'Gaza Province',139),(2203,'Inhambane Province',139),(2204,'Manica Province',139),(2205,'Maputo Province',139),(2206,'Nampula',139),(2207,'Niassa Province',139),(2208,'Provincia de Zambezia',139),(2209,'Sofala Province',139),(2210,'Tete',139),(2211,'Ayeyawady Region',140),(2212,'Bago Region',140),(2213,'Chin State',140),(2214,'Kachin State',140),(2215,'Kayah State',140),(2216,'Kayin State',140),(2217,'Magway Region',140),(2218,'Mandalay Region',140),(2219,'Mon State',140),(2220,'Nay Pyi Taw',140),(2221,'Rakhine State',140),(2222,'Sagaing Region',140),(2223,'Shan State',140),(2224,'Taninthayi Region',140),(2225,'Yangon Region',140),(2226,'Erongo',141),(2227,'Hardap',141),(2228,'Karas',141),(2229,'Kavango East Region',141),(2230,'Kavango West Region',141),(2231,'Khomas',141),(2232,'Kunene',141),(2233,'Ohangwena',141),(2234,'Omaheke',141),(2235,'Omusati',141),(2236,'Oshana',141),(2237,'Oshikoto',141),(2238,'Otjozondjupa',141),(2239,'Zambezi Region',141),(2240,'Aiwo District',142),(2241,'Anabar District',142),(2242,'Anetan District',142),(2243,'Anibare District',142),(2244,'Baiti District',142),(2245,'Boe District',142),(2246,'Buada District',142),(2247,'Denigomodu District',142),(2248,'Ewa District',142),(2249,'Ijuw District',142),(2250,'Meneng District',142),(2251,'Nibok District',142),(2252,'Uaboe District',142),(2253,'Yaren',142),(2254,'Madhya Pashchimanchal',143),(2255,'Madhyamanchal',143),(2256,'Pashchimanchal',143),(2257,'Patheka',143),(2258,'Purwanchal',143),(2259,'Sudur Pashchimanchal',143),(2260,'Provincie Drenthe',144),(2261,'Provincie Flevoland',144),(2262,'Provincie Friesland',144),(2263,'Provincie Gelderland',144),(2264,'Provincie Groningen',144),(2265,'Provincie Limburg',144),(2266,'Provincie Noord-Brabant',144),(2267,'Provincie Noord-Holland',144),(2268,'Provincie Overijssel',144),(2269,'Provincie Utrecht',144),(2270,'Provincie Zeeland',144),(2271,'Provincie Zuid-Holland',144),(2272,'Province des iles Loyaute',146),(2273,'Province Nord',146),(2274,'Province Sud',146),(2275,'Auckland',147),(2276,'Bay of Plenty',147),(2277,'Canterbury',147),(2278,'Chatham Islands',147),(2279,'Gisborne',147),(2280,'Hawke\'s Bay',147),(2281,'Manawatu-Wanganui',147),(2282,'Marlborough',147),(2283,'Nelson',147),(2284,'Northland',147),(2285,'Otago',147),(2286,'Southland',147),(2287,'Taranaki',147),(2288,'Tasman',147),(2289,'Waikato',147),(2290,'Wellington',147),(2291,'West Coast',147),(2292,'Costa Caribe Sur',148),(2293,'Departamento de Boaco',148),(2294,'Departamento de Carazo',148),(2295,'Departamento de Chinandega',148),(2296,'Departamento de Chontales',148),(2297,'Departamento de Esteli',148),(2298,'Departamento de Granada',148),(2299,'Departamento de Jinotega',148),(2300,'Departamento de Leon',148),(2301,'Departamento de Madriz',148),(2302,'Departamento de Managua',148),(2303,'Departamento de Masaya',148),(2304,'Departamento de Matagalpa',148),(2305,'Departamento de Nueva Segovia',148),(2306,'Departamento de Rio San Juan',148),(2307,'Departamento de Rivas',148),(2308,'North Atlantic Autonomous Region (RAAN)',148),(2309,'Agadez',149),(2310,'Diffa',149),(2311,'Dosso Region',149),(2312,'Maradi',149),(2313,'Niamey',149),(2314,'Tahoua',149),(2315,'Tillaberi Region',149),(2316,'Zinder',149),(2317,'Abia State',150),(2318,'Adamawa State',150),(2319,'Akwa Ibom State',150),(2320,'Anambra State',150),(2321,'Bauchi State',150),(2322,'Bayelsa State',150),(2323,'Benue State',150),(2324,'Borno State',150),(2325,'Cross River State',150),(2326,'Delta State',150),(2327,'Ebonyi State',150),(2328,'Edo',150),(2329,'Ekiti State',150),(2330,'Enugu State',150),(2331,'Federal Capital Territory',150),(2332,'Gombe State',150),(2333,'Imo State',150),(2334,'Jigawa State',150),(2335,'Kaduna State',150),(2336,'Kano State',150),(2337,'Katsina State',150),(2338,'Kebbi State',150),(2339,'Kogi State',150),(2340,'Kwara State',150),(2341,'Lagos State',150),(2342,'Nasarawa State',150),(2343,'Niger State',150),(2344,'Ogun State',150),(2345,'Ondo State',150),(2346,'Osun State',150),(2347,'Oyo State',150),(2348,'Plateau State',150),(2349,'Rivers State',150),(2350,'Sokoto State',150),(2351,'Taraba State',150),(2352,'Yobe State',150),(2353,'Zamfara State',150),(2354,'Northern Islands Municipality',153),(2355,'Rota Municipality',153),(2356,'Saipan Municipality',153),(2357,'Tinian Municipality',153),(2358,'Akershus fylke',154),(2359,'Aust-Agder fylke',154),(2360,'Buskerud fylke',154),(2361,'Finnmark Fylke',154),(2362,'Hedmark fylke',154),(2363,'Hordaland Fylke',154),(2364,'More og Romsdal fylke',154),(2365,'Nord-Trondelag Fylke',154),(2366,'Nordland Fylke',154),(2367,'Oppland fylke',154),(2368,'Oslo County',154),(2369,'Ostfold fylke',154),(2370,'Rogaland Fylke',154),(2371,'Sogn og Fjordane Fylke',154),(2372,'Sor-Trondelag Fylke',154),(2373,'Telemark fylke',154),(2374,'Troms Fylke',154),(2375,'Vest-Agder Fylke',154),(2376,'Vestfold fylke',154),(2377,'Alderney',155),(2378,'Castel',155),(2379,'Forest',155),(2380,'Saint Andrew',155),(2381,'Saint Martin',155),(2382,'Saint Peter Port',155),(2383,'Saint Pierre du Bois',155),(2384,'Saint Sampson',155),(2385,'Saint Saviour',155),(2386,'Torteval',155),(2387,'Vale',155),(2388,'Al Batinah North Governorate',156),(2389,'Al Batinah South Governorate',156),(2390,'Ash Sharqiyah South',156),(2391,'Az Zahirah',156),(2392,'Muhafazat ad Dakhiliyah',156),(2393,'Muhafazat al Buraymi',156),(2394,'Muhafazat al Wusta',156),(2395,'Muhafazat Masqat',156),(2396,'Muhafazat Shamal ash Sharqiyah',156),(2397,'Muhafazat Zufar',156),(2398,'Musandam',156),(2399,'Azad Kashmir',157),(2400,'Balochistan',157),(2401,'Federally Administered Tribal Areas',157),(2402,'Gilgit-Baltistan',157),(2403,'Islamabad',157),(2404,'Khyber Pakhtunkhwa Province',157),(2405,'Punjab Province',157),(2406,'Sindh',157),(2407,'State of Aimeliik',158),(2408,'State of Airai',158),(2409,'State of Angaur',158),(2410,'State of Hatohobei',158),(2411,'State of Kayangel',158),(2412,'State of Koror',158),(2413,'State of Melekeok',158),(2414,'State of Ngaraard',158),(2415,'State of Ngarchelong',158),(2416,'State of Ngardmau',158),(2417,'State of Ngatpang',158),(2418,'State of Ngchesar',158),(2419,'State of Ngeremlengui',158),(2420,'State of Ngiwal',158),(2421,'State of Peleliu',158),(2422,'State of Sonsorol',158),(2423,'Gaza Strip',159),(2424,'West Bank',159),(2425,'Embera-Wounaan',160),(2426,'Guna Yala',160),(2427,'Ngoebe-Bugle',160),(2428,'Panama Oeste',160),(2429,'Provincia de Bocas del Toro',160),(2430,'Provincia de Chiriqui',160),(2431,'Provincia de Cocle',160),(2432,'Provincia de Colon',160),(2433,'Provincia de Herrera',160),(2434,'Provincia de Los Santos',160),(2435,'Provincia de Panama',160),(2436,'Provincia de Veraguas',160),(2437,'Provincia del Darien',160),(2438,'Bougainville',161),(2439,'Central Province',161),(2440,'Chimbu Province',161),(2441,'East New Britain Province',161),(2442,'East Sepik Province',161),(2443,'Eastern Highlands Province',161),(2444,'Enga Province',161),(2445,'Gulf Province',161),(2446,'Hela',161),(2447,'Jiwaka',161),(2448,'Madang Province',161),(2449,'Manus Province',161),(2450,'Milne Bay Province',161),(2451,'Morobe Province',161),(2452,'National Capital District',161),(2453,'New Ireland Province',161),(2454,'Northern Province',161),(2455,'Southern Highlands Province',161),(2456,'West New Britain Province',161),(2457,'West Sepik Province',161),(2458,'Western Highlands Province',161),(2459,'Western Province',161),(2460,'Asuncion',162),(2461,'Departamento Central',162),(2462,'Departamento de Alto Paraguay',162),(2463,'Departamento de Boqueron',162),(2464,'Departamento de Caaguazu',162),(2465,'Departamento de Caazapa',162),(2466,'Departamento de Canindeyu',162),(2467,'Departamento de Concepcion',162),(2468,'Departamento de Itapua',162),(2469,'Departamento de la Cordillera',162),(2470,'Departamento de Misiones',162),(2471,'Departamento de Neembucu',162),(2472,'Departamento de Paraguari',162),(2473,'Departamento de Presidente Hayes',162),(2474,'Departamento de San Pedro',162),(2475,'Departamento del Alto Parana',162),(2476,'Departamento del Amambay',162),(2477,'Departamento del Guaira',162),(2478,'Amazonas',163),(2479,'Ancash',163),(2480,'Apurimac',163),(2481,'Arequipa',163),(2482,'Ayacucho',163),(2483,'Cajamarca',163),(2484,'Callao',163),(2485,'Cusco',163),(2486,'Departamento de Moquegua',163),(2487,'Huancavelica',163),(2488,'Ica',163),(2489,'Junin',163),(2490,'La Libertad',163),(2491,'Lambayeque',163),(2492,'Lima',163),(2493,'Loreto',163),(2494,'Madre de Dios',163),(2495,'Pasco',163),(2496,'Piura',163),(2497,'Provincia de Lima',163),(2498,'Puno',163),(2499,'Region de Huanuco',163),(2500,'Region de San Martin',163),(2501,'Tacna',163),(2502,'Tumbes',163),(2503,'Ucayali',163),(2504,'Autonomous Region in Muslim Mindanao',164),(2505,'Bicol',164),(2506,'Cagayan Valley',164),(2507,'Calabarzon',164),(2508,'Caraga',164),(2509,'Central Luzon',164),(2510,'Central Visayas',164),(2511,'Cordillera Administrative Region',164),(2512,'Davao',164),(2513,'Eastern Visayas',164),(2514,'Ilocos',164),(2515,'Mimaropa',164),(2516,'National Capital Region',164),(2517,'Negros Island Region',164),(2518,'Northern Mindanao',164),(2519,'Soccsksargen',164),(2520,'Western Visayas',164),(2521,'Zamboanga Peninsula',164),(2522,'Wojewodztwo Dolnoslaskie',166),(2523,'Wojewodztwo Kujawsko-Pomorskie',166),(2524,'Wojewodztwo Lodzkie',166),(2525,'Wojewodztwo Lubelskie',166),(2526,'Wojewodztwo Lubuskie',166),(2527,'Wojewodztwo Malopolskie',166),(2528,'Wojewodztwo Mazowieckie',166),(2529,'Wojewodztwo Opolskie',166),(2530,'Wojewodztwo Podkarpackie',166),(2531,'Wojewodztwo Podlaskie',166),(2532,'Wojewodztwo Pomorskie',166),(2533,'Wojewodztwo Slaskie',166),(2534,'Wojewodztwo Swietokrzyskie',166),(2535,'Wojewodztwo Warminsko-Mazurskie',166),(2536,'Wojewodztwo Wielkopolskie',166),(2537,'Wojewodztwo Zachodniopomorskie',166),(2538,'Azores',167),(2539,'Distrito da Guarda',167),(2540,'Distrito de Aveiro',167),(2541,'Distrito de Beja',167),(2542,'Distrito de Braga',167),(2543,'Distrito de Braganca',167),(2544,'Distrito de Castelo Branco',167),(2545,'Distrito de Coimbra',167),(2546,'Distrito de Evora',167),(2547,'Distrito de Faro',167),(2548,'Distrito de Leiria',167),(2549,'Distrito de Lisboa',167),(2550,'Distrito de Portalegre',167),(2551,'Distrito de Santarem',167),(2552,'Distrito de Setubal',167),(2553,'Distrito de Viana do Castelo',167),(2554,'Distrito de Vila Real',167),(2555,'Distrito de Viseu',167),(2556,'Distrito do Porto',167),(2557,'Madeira',167),(2558,'Al Wakrah',168),(2559,'Baladiyat ad Dawhah',168),(2560,'Baladiyat al Khawr wa adh Dhakhirah',168),(2561,'Baladiyat ar Rayyan',168),(2562,'Baladiyat ash Shamal',168),(2563,'Baladiyat az Za\'ayin',168),(2564,'Baladiyat Umm Salal',168),(2565,'Reunion',169),(2566,'Arad',170),(2567,'Bihor',170),(2568,'Bucuresti',170),(2569,'Constanta',170),(2570,'Covasna',170),(2571,'Dolj',170),(2572,'Giurgiu',170),(2573,'Gorj',170),(2574,'Harghita',170),(2575,'Hunedoara',170),(2576,'Ilfov',170),(2577,'Judetul Alba',170),(2578,'Judetul Arges',170),(2579,'Judetul Bacau',170),(2580,'Judetul Bistrita-Nasaud',170),(2581,'Judetul Botosani',170),(2582,'Judetul Braila',170),(2583,'Judetul Brasov',170),(2584,'Judetul Buzau',170),(2585,'Judetul Calarasi',170),(2586,'Judetul Caras-Severin',170),(2587,'Judetul Cluj',170),(2588,'Judetul Dambovita',170),(2589,'Judetul Galati',170),(2590,'Judetul Ialomita',170),(2591,'Judetul Iasi',170),(2592,'Judetul Maramures',170),(2593,'Judetul Mehedinti',170),(2594,'Judetul Mures',170),(2595,'Judetul Neamt',170),(2596,'Judetul Salaj',170),(2597,'Judetul Sibiu',170),(2598,'Judetul Timis',170),(2599,'Judetul Valcea',170),(2600,'Olt',170),(2601,'Prahova',170),(2602,'Satu Mare',170),(2603,'Suceava',170),(2604,'Teleorman',170),(2605,'Tulcea',170),(2606,'Vaslui',170),(2607,'Vrancea',170),(2608,'Altayskiy Kray',171),(2609,'Amurskaya Oblast\'',171),(2610,'Arkhangel\'skaya Oblast\'',171),(2611,'Astrakhanskaya Oblast\'',171),(2612,'Bashkortostan',171),(2613,'Belgorodskaya Oblast\'',171),(2614,'Bryanskaya Oblast\'',171),(2615,'Chechenskaya Respublika',171),(2616,'Chelyabinskaya Oblast\'',171),(2617,'Chukotskiy Avtonomnyy Okrug',171),(2618,'Chuvashskaya Respublika',171),(2619,'Dagestan',171),(2620,'Irkutskaya Oblast\'',171),(2621,'Ivanovskaya Oblast\'',171),(2622,'Kabardino-Balkarskaya Respublika',171),(2623,'Kaliningradskaya Oblast\'',171),(2624,'Kalmykiya',171),(2625,'Kaluzhskaya Oblast\'',171),(2626,'Kamtchatski Kray',171),(2627,'Karachayevo-Cherkesiya',171),(2628,'Kemerovskaya Oblast\'',171),(2629,'Khabarovskiy Kray',171),(2630,'Khanty-Mansiyskiy Avtonomnyy Okrug-Yugra',171),(2631,'Kirovskaya Oblast\'',171),(2632,'Komi',171),(2633,'Kostromskaya Oblast\'',171),(2634,'Krasnodarskiy Kray',171),(2635,'Krasnoyarskiy Kray',171),(2636,'Kurganskaya Oblast\'',171),(2637,'Kurskaya Oblast\'',171),(2638,'Leningradskaya Oblast\'',171),(2639,'Lipetskaya Oblast\'',171),(2640,'Magadanskaya Oblast\'',171),(2641,'Moscow Oblast',171),(2642,'Moskva',171),(2643,'Murmanskaya Oblast\'',171),(2644,'Nenetskiy Avtonomnyy Okrug',171),(2645,'Nizhegorodskaya Oblast\'',171),(2646,'North Ossetia',171),(2647,'Novgorodskaya Oblast\'',171),(2648,'Novosibirskaya Oblast\'',171),(2649,'Omskaya Oblast\'',171),(2650,'Orenburgskaya Oblast\'',171),(2651,'Orlovskaya Oblast\'',171),(2652,'Penzenskaya Oblast\'',171),(2653,'Perm Krai',171),(2654,'Primorskiy Kray',171),(2655,'Pskovskaya Oblast\'',171),(2656,'Respublika Adygeya',171),(2657,'Respublika Altay',171),(2658,'Respublika Buryatiya',171),(2659,'Respublika Ingushetiya',171),(2660,'Respublika Kareliya',171),(2661,'Respublika Khakasiya',171),(2662,'Respublika Mariy-El',171),(2663,'Respublika Mordoviya',171),(2664,'Respublika Sakha (Yakutiya)',171),(2665,'Respublika Tyva',171),(2666,'Rostovskaya Oblast\'',171),(2667,'Ryazanskaya Oblast\'',171),(2668,'Sakhalinskaya Oblast\'',171),(2669,'Samarskaya Oblast\'',171),(2670,'Sankt-Peterburg',171),(2671,'Saratovskaya Oblast\'',171),(2672,'Smolenskaya Oblast\'',171),(2673,'Stavropol\'skiy Kray',171),(2674,'Sverdlovskaya Oblast\'',171),(2675,'Tambovskaya Oblast\'',171),(2676,'Tatarstan',171),(2677,'Tomskaya Oblast\'',171),(2678,'Tul\'skaya Oblast\'',171),(2679,'Tverskaya Oblast\'',171),(2680,'Tyumenskaya Oblast\'',171),(2681,'Udmurtskaya Respublika',171),(2682,'Ulyanovsk Oblast',171),(2683,'Vladimirskaya Oblast\'',171),(2684,'Volgogradskaya Oblast\'',171),(2685,'Vologodskaya Oblast\'',171),(2686,'Voronezhskaya Oblast\'',171),(2687,'Yamalo-Nenetskiy Avtonomnyy Okrug',171),(2688,'Yaroslavskaya Oblast\'',171),(2689,'Yevreyskaya Avtonomnaya Oblast\'',171),(2690,'Zabaykal\'skiy Kray',171),(2691,'Eastern Province',172),(2692,'Kigali Province',172),(2693,'Northern Province',172),(2694,'Southern Province',172),(2695,'Western Province',172),(2696,'Ascension',174),(2697,'Saint Helena',174),(2698,'Tristan da Cunha',174),(2699,'Christ Church Nichola Town',175),(2700,'Saint Anne Sandy Point',175),(2701,'Saint George Basseterre',175),(2702,'Saint George Gingerland',175),(2703,'Saint James Windward',175),(2704,'Saint John Capesterre',175),(2705,'Saint John Figtree',175),(2706,'Saint Mary Cayon',175),(2707,'Saint Paul Capesterre',175),(2708,'Saint Paul Charlestown',175),(2709,'Saint Peter Basseterre',175),(2710,'Saint Thomas Lowland',175),(2711,'Saint Thomas Middle Island',175),(2712,'Trinity Palmetto Point',175),(2713,'Anse-la-Raye',176),(2714,'Canaries',176),(2715,'Castries',176),(2716,'Choiseul',176),(2717,'Dennery',176),(2718,'Gros-Islet',176),(2719,'Laborie',176),(2720,'Micoud',176),(2721,'Soufriere',176),(2722,'Vieux-Fort',176),(2723,'Commune de Saint-Pierre',177),(2724,'Miquelon-Langlade',177),(2725,'Grenadines',178),(2726,'Parish of Charlotte',178),(2727,'Parish of Saint Andrew',178),(2728,'Parish of Saint David',178),(2729,'Parish of Saint George',178),(2730,'Parish of Saint Patrick',178),(2731,'A\'ana',179),(2732,'Aiga-i-le-Tai',179),(2733,'Atua',179),(2734,'Fa\'asaleleaga',179),(2735,'Gaga\'emauga',179),(2736,'Gagaifomauga',179),(2737,'Palauli',179),(2738,'Satupa\'itea',179),(2739,'Tuamasaga',179),(2740,'Va\'a-o-Fonoti',179),(2741,'Vaisigano',179),(2742,'Castello di Acquaviva',180),(2743,'Castello di Borgo Maggiore',180),(2744,'Castello di Domagnano',180),(2745,'Castello di Faetano',180),(2746,'Castello di Fiorentino',180),(2747,'Castello di Montegiardino',180),(2748,'Castello di San Marino Citta',180),(2749,'Chiesanuova',180),(2750,'Serravalle',180),(2751,'Principe',181),(2752,'Sao Tome',181),(2753,'Al Jawf',182),(2754,'Al Madinah al Munawwarah',182),(2755,'Al Mintaqah ash Sharqiyah',182),(2756,'Al-Qassim Province',182),(2757,'Hai\'l Region',182),(2758,'Jizan Region',182),(2759,'Makkah Province',182),(2760,'Mintaqat \'Asir',182),(2761,'Mintaqat al Bahah',182),(2762,'Mintaqat al Hudud ash Shamaliyah',182),(2763,'Mintaqat ar Riyad',182),(2764,'Mintaqat Najran',182),(2765,'Mintaqat Tabuk',182),(2766,'Dakar',183),(2767,'Diourbel',183),(2768,'Fatick',183),(2769,'Kaolack',183),(2770,'Kolda',183),(2771,'Louga',183),(2772,'Matam',183),(2773,'Region de Kaffrine',183),(2774,'Region de Kedougou',183),(2775,'Region de Sedhiou',183),(2776,'Region de Thies',183),(2777,'Saint-Louis',183),(2778,'Tambacounda',183),(2779,'Ziguinchor',183),(2780,'Anse aux Pins',184),(2781,'Anse Boileau',184),(2782,'Anse Etoile',184),(2783,'Anse Royale',184),(2784,'Au Cap',184),(2785,'Baie Lazare',184),(2786,'Baie Sainte Anne',184),(2787,'Beau Vallon',184),(2788,'Bel Air',184),(2789,'Bel Ombre',184),(2790,'Cascade',184),(2791,'English River',184),(2792,'Glacis',184),(2793,'Grand Anse Mahe',184),(2794,'Grand Anse Praslin',184),(2795,'Inner Islands',184),(2796,'Les Mamelles',184),(2797,'Mont Buxton',184),(2798,'Mont Fleuri',184),(2799,'Plaisance',184),(2800,'Pointe Larue',184),(2801,'Port Glaud',184),(2802,'Roche Caiman',184),(2803,'Saint Louis',184),(2804,'Takamaka',184),(2805,'Eastern Province',185),(2806,'Northern Province',185),(2807,'Southern Province',185),(2808,'Western Area',185),(2809,'Central Singapore Community Development Council',186),(2810,'North East Community Development Region',186),(2811,'North West Community Development Council',186),(2812,'South East Community Development Council',186),(2813,'South West Community Development Council',186),(2814,'Banska Bystrica',187),(2815,'Bratislava',187),(2816,'Kosice',187),(2817,'Nitra',187),(2818,'Presov',187),(2819,'Trencin',187),(2820,'Trnava',187),(2821,'Zilina',187),(2822,'Ankaran',188),(2823,'Beltinci',188),(2824,'Benedikt',188),(2825,'Bistrica ob Sotli',188),(2826,'Bloke',188),(2827,'Bohinj',188),(2828,'Borovnica',188),(2829,'Brda',188),(2830,'Brezovica',188),(2831,'Cankova',188),(2832,'Celje',188),(2833,'Cerklje na Gorenjskem',188),(2834,'Cerknica',188),(2835,'Cerkno',188),(2836,'Cerkvenjak',188),(2837,'Cirkulane',188),(2838,'Destrnik',188),(2839,'Dobje',188),(2840,'Dobrepolje',188),(2841,'Dobrna',188),(2842,'Dobrova-Polhov Gradec',188),(2843,'Dobrovnik',188),(2844,'Dol pri Ljubljani',188),(2845,'Dolenjske Toplice',188),(2846,'Dornava',188),(2847,'Dravograd',188),(2848,'Duplek',188),(2849,'Gorenja Vas-Poljane',188),(2850,'Gorje',188),(2851,'Gornja Radgona',188),(2852,'Gornji Grad',188),(2853,'Gornji Petrovci',188),(2854,'Grad',188),(2855,'Grosuplje',188),(2856,'Hajdina',188),(2857,'Hodos',188),(2858,'Horjul',188),(2859,'Hrastnik',188),(2860,'Hrpelje-Kozina',188),(2861,'Idrija',188),(2862,'Ig',188),(2863,'Ilirska Bistrica',188),(2864,'Izola',188),(2865,'Jesenice',188),(2866,'Jezersko',188),(2867,'Kamnik',188),(2868,'Kanal',188),(2869,'Kobilje',188),(2870,'Komen',188),(2871,'Komenda',188),(2872,'Koper',188),(2873,'Kostanjevica na Krki',188),(2874,'Kostel',188),(2875,'Kozje',188),(2876,'Kranj',188),(2877,'Kranjska Gora',188),(2878,'Kungota',188),(2879,'Kuzma',188),(2880,'Lenart',188),(2881,'Lendava',188),(2882,'Litija',188),(2883,'Ljubno',188),(2884,'Ljutomer',188),(2885,'Log-Dragomer',188),(2886,'Logatec',188),(2887,'Lovrenc na Pohorju',188),(2888,'Lukovica',188),(2889,'Makole',188),(2890,'Maribor',188),(2891,'Markovci',188),(2892,'Medvode',188),(2893,'Mestna Obcina Ljubljana',188),(2894,'Mestna Obcina Novo mesto',188),(2895,'Metlika',188),(2896,'Miren-Kostanjevica',188),(2897,'Mirna',188),(2898,'Mislinja',188),(2899,'Mokronog-Trebelno',188),(2900,'Moravske Toplice',188),(2901,'Mozirje',188),(2902,'Murska Sobota',188),(2903,'Muta',188),(2904,'Naklo',188),(2905,'Nazarje',188),(2906,'Nova Gorica',188),(2907,'Obcina Ajdovscina',188),(2908,'Obcina Apace',188),(2909,'Obcina Bled',188),(2910,'Obcina Bovec',188),(2911,'Obcina Braslovce',188),(2912,'Obcina Brezice',188),(2913,'Obcina Crensovci',188),(2914,'Obcina Crna na Koroskem',188),(2915,'Obcina Crnomelj',188),(2916,'Obcina Divaca',188),(2917,'Obcina Domzale',188),(2918,'Obcina Gorisnica',188),(2919,'Obcina Hoce-Slivnica',188),(2920,'Obcina Ivancna Gorica',188),(2921,'Obcina Jursinci',188),(2922,'Obcina Kidricevo',188),(2923,'Obcina Kobarid',188),(2924,'Obcina Kocevje',188),(2925,'Obcina Krizevci',188),(2926,'Obcina Krsko',188),(2927,'Obcina Lasko',188),(2928,'Obcina Loska Dolina',188),(2929,'Obcina Loski Potok',188),(2930,'Obcina Luce',188),(2931,'Obcina Majsperk',188),(2932,'Obcina Menges',188),(2933,'Obcina Mezica',188),(2934,'Obcina Miklavz na Dravskem Polju',188),(2935,'Obcina Mirna Pec',188),(2936,'Obcina Moravce',188),(2937,'Obcina Ormoz',188),(2938,'Obcina Podcetrtek',188),(2939,'Obcina Poljcane',188),(2940,'Obcina Race-Fram',188),(2941,'Obcina Radece',188),(2942,'Obcina Ravne na Koroskem',188),(2943,'Obcina Razkrizje',188),(2944,'Obcina Recica ob Savinji',188),(2945,'Obcina Rence-Vogrsko',188),(2946,'Obcina Rogaska Slatina',188),(2947,'Obcina Rogasovci',188),(2948,'Obcina Ruse',188),(2949,'Obcina Salovci',188),(2950,'Obcina Semic',188),(2951,'Obcina Sempeter-Vrtojba',188),(2952,'Obcina Sencur',188),(2953,'Obcina Sentilj',188),(2954,'Obcina Sentjernej',188),(2955,'Obcina Sentjur',188),(2956,'Obcina Sentrupert',188),(2957,'Obcina Sezana',188),(2958,'Obcina Skocjan',188),(2959,'Obcina Skofja Loka',188),(2960,'Obcina Skofljica',188),(2961,'Obcina Smarje pri Jelsah',188),(2962,'Obcina Smarjeske Toplice',188),(2963,'Obcina Smartno ob Paki',188),(2964,'Obcina Smartno pri Litiji',188),(2965,'Obcina Sodrazica',188),(2966,'Obcina Solcava',188),(2967,'Obcina Sostanj',188),(2968,'Obcina Sredisce ob Dravi',188),(2969,'Obcina Starse',188),(2970,'Obcina Store',188),(2971,'Obcina Straza',188),(2972,'Obcina Sveti Andraz v Slovenskih Goricah',188),(2973,'Obcina Sveti Jurij ob Scavnici',188),(2974,'Obcina Sveti Tomaz',188),(2975,'Obcina Tisina',188),(2976,'Obcina Tolmin',188),(2977,'Obcina Trnovska vas',188),(2978,'Obcina Trzic',188),(2979,'Obcina Turnisce',188),(2980,'Obcina Velike Lasce',188),(2981,'Obcina Verzej',188),(2982,'Obcina Zalec',188),(2983,'Obcina Zavrc',188),(2984,'Obcina Zelezniki',188),(2985,'Obcina Zetale',188),(2986,'Obcina Ziri',188),(2987,'Obcina Zirovnica',188),(2988,'Obcina Zrece',188),(2989,'Obcina Zuzemberk',188),(2990,'Odranci',188),(2991,'Oplotnica',188),(2992,'Osilnica',188),(2993,'Pesnica',188),(2994,'Piran',188),(2995,'Pivka',188),(2996,'Podlehnik',188),(2997,'Podvelka',188),(2998,'Polzela',188),(2999,'Postojna',188),(3000,'Prebold',188),(3001,'Preddvor',188),(3002,'Prevalje',188),(3003,'Ptuj',188),(3004,'Puconci',188),(3005,'Radenci',188),(3006,'Radlje ob Dravi',188),(3007,'Radovljica',188),(3008,'Ribnica',188),(3009,'Ribnica na Pohorju',188),(3010,'Rogatec',188),(3011,'Selnica ob Dravi',188),(3012,'Sevnica',188),(3013,'Slovenj Gradec',188),(3014,'Slovenska Bistrica',188),(3015,'Slovenske Konjice',188),(3016,'Sveta Ana',188),(3017,'Sveta Trojica v Slovenskih Goricah',188),(3018,'Sveti Jurij v Slovenskih Goricah',188),(3019,'Tabor',188),(3020,'Trbovlje',188),(3021,'Trebnje',188),(3022,'Trzin',188),(3023,'Velenje',188),(3024,'Velika Polana',188),(3025,'Videm',188),(3026,'Vipava',188),(3027,'Vitanje',188),(3028,'Vodice',188),(3029,'Vojnik',188),(3030,'Vransko',188),(3031,'Vrhnika',188),(3032,'Vuzenica',188),(3033,'Zagorje ob Savi',188),(3034,'Central Province',189),(3035,'Choiseul',189),(3036,'Guadalcanal Province',189),(3037,'Honiara',189),(3038,'Isabel Province',189),(3039,'Makira-Ulawa Province',189),(3040,'Malaita Province',189),(3041,'Rennell and Bellona',189),(3042,'Temotu Province',189),(3043,'Western Province',189),(3044,'Gobolka Awdal',190),(3045,'Gobolka Bakool',190),(3046,'Gobolka Banaadir',190),(3047,'Gobolka Bari',190),(3048,'Gobolka Bay',190),(3049,'Gobolka Galguduud',190),(3050,'Gobolka Gedo',190),(3051,'Gobolka Hiiraan',190),(3052,'Gobolka Jubbada Dhexe',190),(3053,'Gobolka Jubbada Hoose',190),(3054,'Gobolka Mudug',190),(3055,'Gobolka Nugaal',190),(3056,'Gobolka Sanaag',190),(3057,'Gobolka Shabeellaha Dhexe',190),(3058,'Gobolka Shabeellaha Hoose',190),(3059,'Gobolka Sool',190),(3060,'Gobolka Togdheer',190),(3061,'Gobolka Woqooyi Galbeed',190),(3062,'Eastern Cape',191),(3063,'Free State',191),(3064,'Gauteng',191),(3065,'Limpopo',191),(3066,'Mpumalanga',191),(3067,'Province of KwaZulu-Natal',191),(3068,'Province of North West',191),(3069,'Province of Northern Cape',191),(3070,'Western Cape',191),(3071,'Andalucia',192),(3072,'Aragon',192),(3073,'Canary Islands',192),(3074,'Cantabria',192),(3075,'Castilla y Leon',192),(3076,'Castilla-La Mancha',192),(3077,'Catalunya',192),(3078,'Ceuta',192),(3079,'Comunidad de Madrid',192),(3080,'Comunitat Autonoma de les Illes Balears',192),(3081,'Comunitat Valenciana',192),(3082,'Euskal Autonomia Erkidegoa',192),(3083,'Extremadura',192),(3084,'Galicia',192),(3085,'La Rioja',192),(3086,'Melilla',192),(3087,'Navarra',192),(3088,'Principality of Asturias',192),(3089,'Region de Murcia',192),(3090,'Central Province',193),(3091,'Eastern Province',193),(3092,'North Central Province',193),(3093,'North Western Province',193),(3094,'Northern Province',193),(3095,'Province of Sabaragamuwa',193),(3096,'Province of Uva',193),(3097,'Southern Province',193),(3098,'Western Province',193),(3099,'Al Jazirah State',194),(3100,'Al Qadarif State',194),(3101,'Blue Nile',194),(3102,'Central Darfur State',194),(3103,'East Darfur',194),(3104,'Kassala State',194),(3105,'Khartoum',194),(3106,'North Darfur',194),(3107,'North Kordofan',194),(3108,'Northern',194),(3109,'Red Sea',194),(3110,'River Nile',194),(3111,'Sennar',194),(3112,'South Darfur',194),(3113,'South Kordofan',194),(3114,'West Darfur',194),(3115,'West Kordofan State',194),(3116,'White Nile',194),(3117,'Distrikt Brokopondo',195),(3118,'Distrikt Commewijne',195),(3119,'Distrikt Coronie',195),(3120,'Distrikt Marowijne',195),(3121,'Distrikt Nickerie',195),(3122,'Distrikt Para',195),(3123,'Distrikt Paramaribo',195),(3124,'Distrikt Saramacca',195),(3125,'Distrikt Sipaliwini',195),(3126,'Distrikt Wanica',195),(3127,'Jan Mayen',196),(3128,'Svalbard',196),(3129,'Hhohho District',197),(3130,'Lubombo District',197),(3131,'Manzini District',197),(3132,'Shiselweni District',197),(3133,'Blekinge',198),(3134,'Dalarna',198),(3135,'Gaevleborgs laen',198),(3136,'Gotland',198),(3137,'Halland',198),(3138,'Jaemtlands laen',198),(3139,'Joenkoepings laen',198),(3140,'Kalmar',198),(3141,'Kronoberg',198),(3142,'Norrbotten',198),(3143,'OErebro laen',198),(3144,'OEstergoetlands laen',198),(3145,'Skane laen',198),(3146,'Soedermanlands laen',198),(3147,'Stockholm',198),(3148,'Uppsala',198),(3149,'Vaermlands laen',198),(3150,'Vaesterbottens laen',198),(3151,'Vaesternorrlands laen',198),(3152,'Vaestmanlands laen',198),(3153,'Vaestra Goetalands laen',198),(3154,'Canton de Berne',199),(3155,'Canton de Fribourg',199),(3156,'Canton de Vaud',199),(3157,'Canton du Valais',199),(3158,'Geneve',199),(3159,'Jura',199),(3160,'Kanton Aargau',199),(3161,'Kanton Appenzell Ausserrhoden',199),(3162,'Kanton Appenzell Innerrhoden',199),(3163,'Kanton Basel-Landschaft',199),(3164,'Kanton Basel-Stadt',199),(3165,'Kanton Glarus',199),(3166,'Kanton Graubunden',199),(3167,'Kanton Luzern',199),(3168,'Kanton Nidwalden',199),(3169,'Kanton Obwalden',199),(3170,'Kanton Schaffhausen',199),(3171,'Kanton Schwyz',199),(3172,'Kanton Solothurn',199),(3173,'Kanton St. Gallen',199),(3174,'Kanton Thurgau',199),(3175,'Kanton Uri',199),(3176,'Kanton Zug',199),(3177,'Kanton Zurich',199),(3178,'Neuchatel',199),(3179,'Ticino',199),(3180,'Al-Hasakah Governorate',200),(3181,'Aleppo Governorate',200),(3182,'Ar-Raqqah Governorate',200),(3183,'As-Suwayda Governorate',200),(3184,'Damascus Governorate',200),(3185,'Daraa Governorate',200),(3186,'Deir ez-Zor Governorate',200),(3187,'Hama Governorate',200),(3188,'Homs Governorate',200),(3189,'Idlib Governorate',200),(3190,'Latakia Governorate',200),(3191,'Muhafazat Rif Dimashq',200),(3192,'Quneitra Governorate',200),(3193,'Tartus Governorate',200),(3194,'Fukien',201),(3195,'Kaohsiung',201),(3196,'Taipei',201),(3197,'Taiwan',201),(3198,'Districts of Republican Subordination',202),(3199,'Dushanbe',202),(3200,'Viloyati Khatlon',202),(3201,'Viloyati Mukhtori Kuhistoni Badakhshon',202),(3202,'Viloyati Sughd',202),(3203,'Arusha Region',203),(3204,'Coast Region',203),(3205,'Dar es Salaam Region',203),(3206,'Dodoma Region',203),(3207,'Geita Region',203),(3208,'Iringa Region',203),(3209,'Kagera Region',203),(3210,'Katavi Region',203),(3211,'Kigoma Region',203),(3212,'Kilimanjaro Region',203),(3213,'Lindi Region',203),(3214,'Manyara Region',203),(3215,'Mara Region',203),(3216,'Mbeya Region',203),(3217,'Morogoro Region',203),(3218,'Mtwara Region',203),(3219,'Mwanza Region',203),(3220,'Njombe Region',203),(3221,'Pemba North Region',203),(3222,'Pemba South Region',203),(3223,'Rukwa Region',203),(3224,'Ruvuma Region',203),(3225,'Shinyanga Region',203),(3226,'Simiyu Region',203),(3227,'Singida Region',203),(3228,'Tabora Region',203),(3229,'Tanga Region',203),(3230,'Zanzibar Central/South Region',203),(3231,'Zanzibar North Region',203),(3232,'Zanzibar Urban/West Region',203),(3233,'Bangkok',204),(3234,'Changwat Amnat Charoen',204),(3235,'Changwat Ang Thong',204),(3236,'Changwat Bueng Kan',204),(3237,'Changwat Buri Ram',204),(3238,'Changwat Chachoengsao',204),(3239,'Changwat Chai Nat',204),(3240,'Changwat Chaiyaphum',204),(3241,'Changwat Chanthaburi',204),(3242,'Changwat Chiang Rai',204),(3243,'Changwat Chon Buri',204),(3244,'Changwat Chumphon',204),(3245,'Changwat Kalasin',204),(3246,'Changwat Kamphaeng Phet',204),(3247,'Changwat Kanchanaburi',204),(3248,'Changwat Khon Kaen',204),(3249,'Changwat Krabi',204),(3250,'Changwat Lampang',204),(3251,'Changwat Lamphun',204),(3252,'Changwat Loei',204),(3253,'Changwat Lop Buri',204),(3254,'Changwat Mae Hong Son',204),(3255,'Changwat Maha Sarakham',204),(3256,'Changwat Mukdahan',204),(3257,'Changwat Nakhon Nayok',204),(3258,'Changwat Nakhon Pathom',204),(3259,'Changwat Nakhon Phanom',204),(3260,'Changwat Nakhon Ratchasima',204),(3261,'Changwat Nakhon Sawan',204),(3262,'Changwat Nakhon Si Thammarat',204),(3263,'Changwat Nan',204),(3264,'Changwat Narathiwat',204),(3265,'Changwat Nong Bua Lamphu',204),(3266,'Changwat Nong Khai',204),(3267,'Changwat Nonthaburi',204),(3268,'Changwat Pathum Thani',204),(3269,'Changwat Pattani',204),(3270,'Changwat Phangnga',204),(3271,'Changwat Phatthalung',204),(3272,'Changwat Phayao',204),(3273,'Changwat Phetchabun',204),(3274,'Changwat Phetchaburi',204),(3275,'Changwat Phichit',204),(3276,'Changwat Phitsanulok',204),(3277,'Changwat Phra Nakhon Si Ayutthaya',204),(3278,'Changwat Phrae',204),(3279,'Changwat Prachin Buri',204),(3280,'Changwat Prachuap Khiri Khan',204),(3281,'Changwat Ranong',204),(3282,'Changwat Ratchaburi',204),(3283,'Changwat Rayong',204),(3284,'Changwat Roi Et',204),(3285,'Changwat Sa Kaeo',204),(3286,'Changwat Sakon Nakhon',204),(3287,'Changwat Samut Prakan',204),(3288,'Changwat Samut Sakhon',204),(3289,'Changwat Samut Songkhram',204),(3290,'Changwat Saraburi',204),(3291,'Changwat Satun',204),(3292,'Changwat Si Sa Ket',204),(3293,'Changwat Sing Buri',204),(3294,'Changwat Songkhla',204),(3295,'Changwat Sukhothai',204),(3296,'Changwat Suphan Buri',204),(3297,'Changwat Surat Thani',204),(3298,'Changwat Surin',204),(3299,'Changwat Tak',204),(3300,'Changwat Trang',204),(3301,'Changwat Trat',204),(3302,'Changwat Ubon Ratchathani',204),(3303,'Changwat Udon Thani',204),(3304,'Changwat Uthai Thani',204),(3305,'Changwat Uttaradit',204),(3306,'Changwat Yala',204),(3307,'Changwat Yasothon',204),(3308,'Chiang Mai Province',204),(3309,'Phuket Province',204),(3310,'Centrale',205),(3311,'Kara',205),(3312,'Maritime',205),(3313,'Plateaux',205),(3314,'Savanes',205),(3315,'Atafu',206),(3316,'Fakaofo',206),(3317,'Nukunonu',206),(3318,'Eua',207),(3319,'Ha`apai',207),(3320,'Niuas',207),(3321,'Tongatapu',207),(3322,'Vava\'u',207),(3323,'Arima',208),(3324,'Chaguanas',208),(3325,'City of Port of Spain',208),(3326,'Couva-Tabaquite-Talparo',208),(3327,'Diego Martin',208),(3328,'Mayaro',208),(3329,'Penal/Debe',208),(3330,'Point Fortin',208),(3331,'Princes Town',208),(3332,'San Fernando',208),(3333,'San Juan/Laventille',208),(3334,'Sangre Grande',208),(3335,'Siparia',208),(3336,'Tobago',208),(3337,'Tunapuna/Piarco',208),(3338,'Gafsa Governorate',209),(3339,'Gouvernorat de Beja',209),(3340,'Gouvernorat de Ben Arous',209),(3341,'Gouvernorat de Bizerte',209),(3342,'Gouvernorat de Gabes',209),(3343,'Gouvernorat de Jendouba',209),(3344,'Gouvernorat de Kairouan',209),(3345,'Gouvernorat de Kasserine',209),(3346,'Gouvernorat de Kebili',209),(3347,'Gouvernorat de Kef',209),(3348,'Gouvernorat de l\'Ariana',209),(3349,'Gouvernorat de Mahdia',209),(3350,'Gouvernorat de Medenine',209),(3351,'Gouvernorat de Monastir',209),(3352,'Gouvernorat de Nabeul',209),(3353,'Gouvernorat de Sfax',209),(3354,'Gouvernorat de Sidi Bouzid',209),(3355,'Gouvernorat de Siliana',209),(3356,'Gouvernorat de Sousse',209),(3357,'Gouvernorat de Tozeur',209),(3358,'Gouvernorat de Tunis',209),(3359,'Gouvernorat de Zaghouan',209),(3360,'Manouba',209),(3361,'Tataouine',209),(3362,'Adana',210),(3363,'Adiyaman',210),(3364,'Afyonkarahisar',210),(3365,'Agri',210),(3366,'Aksaray',210),(3367,'Amasya',210),(3368,'Ankara',210),(3369,'Antalya',210),(3370,'Ardahan',210),(3371,'Artvin',210),(3372,'Aydin',210),(3373,'Balikesir',210),(3374,'Bartin',210),(3375,'Batman',210),(3376,'Bayburt',210),(3377,'Bilecik',210),(3378,'Bingoel',210),(3379,'Bitlis',210),(3380,'Bolu',210),(3381,'Burdur',210),(3382,'Bursa',210),(3383,'Canakkale',210),(3384,'Cankiri',210),(3385,'Corum',210),(3386,'Denizli',210),(3387,'Diyarbakir',210),(3388,'Duezce',210),(3389,'Edirne',210),(3390,'Elazig',210),(3391,'Erzincan',210),(3392,'Erzurum',210),(3393,'Eskisehir',210),(3394,'Gaziantep',210),(3395,'Giresun',210),(3396,'Guemueshane',210),(3397,'Hakkari',210),(3398,'Hatay',210),(3399,'Igdir',210),(3400,'Isparta',210),(3401,'Istanbul',210),(3402,'Izmir',210),(3403,'Kahramanmaras',210),(3404,'Karabuek',210),(3405,'Karaman',210),(3406,'Kars',210),(3407,'Kastamonu',210),(3408,'Kayseri',210),(3409,'Kilis',210),(3410,'Kirikkale',210),(3411,'Kirklareli',210),(3412,'Kirsehir',210),(3413,'Kocaeli',210),(3414,'Konya',210),(3415,'Kuetahya',210),(3416,'Malatya',210),(3417,'Manisa',210),(3418,'Mardin',210),(3419,'Mersin',210),(3420,'Mugla',210),(3421,'Mus',210),(3422,'Nevsehir',210),(3423,'Nigde',210),(3424,'Ordu',210),(3425,'Osmaniye',210),(3426,'Rize',210),(3427,'Sakarya',210),(3428,'Samsun',210),(3429,'Sanliurfa',210),(3430,'Siirt',210),(3431,'Sinop',210),(3432,'Sirnak',210),(3433,'Sivas',210),(3434,'Tekirdag',210),(3435,'Tokat',210),(3436,'Trabzon',210),(3437,'Tunceli',210),(3438,'Usak',210),(3439,'Van',210),(3440,'Yalova',210),(3441,'Yozgat',210),(3442,'Zonguldak',210),(3443,'Ahal',211),(3444,'Ashgabat',211),(3445,'Balkan',211),(3446,'Dasoguz Welayaty',211),(3447,'Lebap',211),(3448,'Mary',211),(3449,'Funafuti',213),(3450,'Nanumanga',213),(3451,'Nanumea',213),(3452,'Niutao',213),(3453,'Nui',213),(3454,'Nukufetau',213),(3455,'Nukulaelae',213),(3456,'Vaitupu',213),(3457,'Central Region',214),(3458,'Eastern Region',214),(3459,'Northern Region',214),(3460,'Western Region',214),(3461,'Cherkas\'ka Oblast\'',215),(3462,'Chernihivs\'ka Oblast\'',215),(3463,'Chernivets\'ka Oblast\'',215),(3464,'Dnipropetrovska Oblast\'',215),(3465,'Donets\'ka Oblast\'',215),(3466,'Gorod Sevastopol',215),(3467,'Ivano-Frankivs\'ka Oblast\'',215),(3468,'Kharkivs\'ka Oblast\'',215),(3469,'Khersons\'ka Oblast\'',215),(3470,'Khmel\'nyts\'ka Oblast\'',215),(3471,'Kirovohrads\'ka Oblast\'',215),(3472,'Kyiv Oblast',215),(3473,'L\'vivs\'ka Oblast\'',215),(3474,'Luhans\'ka Oblast\'',215),(3475,'Misto Kyyiv',215),(3476,'Mykolayivs\'ka Oblast\'',215),(3477,'Odes\'ka Oblast\'',215),(3478,'Poltavs\'ka Oblast\'',215),(3479,'Republic of Crimea',215),(3480,'Rivnens\'ka Oblast\'',215),(3481,'Sums\'ka Oblast\'',215),(3482,'Ternopil\'s\'ka Oblast\'',215),(3483,'Vinnyts\'ka Oblast\'',215),(3484,'Volyns\'ka Oblast\'',215),(3485,'Zakarpattia Oblast',215),(3486,'Zaporiz\'ka Oblast\'',215),(3487,'Zhytomyrs\'ka Oblast\'',215),(3489,'Abu Zaby',216),(3490,'Al Fujayrah',216),(3491,'Ash Shariqah',216),(3492,'Dubai',216),(3493,'Ra\'s al Khaymah',216),(3494,'Umm al Qaywayn',216),(3488,'`Ajman',216),(3495,'Alabama',217),(3496,'Alaska',217),(3497,'Arizona',217),(3498,'Arkansas',217),(3499,'California',217),(3500,'Colorado',217),(3501,'Connecticut',217),(3502,'Delaware',217),(3503,'District of Columbia',217),(3504,'Florida',217),(3505,'Georgia',217),(3506,'Hawaii',217),(3507,'Idaho',217),(3508,'Illinois',217),(3509,'Indiana',217),(3510,'Iowa',217),(3511,'Kansas',217),(3512,'Kentucky',217),(3513,'Louisiana',217),(3514,'Maine',217),(3515,'Maryland',217),(3516,'Massachusetts',217),(3517,'Michigan',217),(3518,'Minnesota',217),(3519,'Mississippi',217),(3520,'Missouri',217),(3521,'Montana',217),(3522,'Nebraska',217),(3523,'Nevada',217),(3524,'New Hampshire',217),(3525,'New Jersey',217),(3526,'New Mexico',217),(3527,'New York',217),(3528,'North Carolina',217),(3529,'North Dakota',217),(3530,'Ohio',217),(3531,'Oklahoma',217),(3532,'Oregon',217),(3533,'Pennsylvania',217),(3534,'Rhode Island',217),(3535,'South Carolina',217),(3536,'South Dakota',217),(3537,'Tennessee',217),(3538,'Texas',217),(3539,'Utah',217),(3540,'Vermont',217),(3541,'Virginia',217),(3542,'Washington',217),(3543,'West Virginia',217),(3544,'Wisconsin',217),(3545,'Wyoming',217),(3546,'Departamento de Artigas',218),(3547,'Departamento de Canelones',218),(3548,'Departamento de Cerro Largo',218),(3549,'Departamento de Colonia',218),(3550,'Departamento de Durazno',218),(3551,'Departamento de Flores',218),(3552,'Departamento de Florida',218),(3553,'Departamento de Lavalleja',218),(3554,'Departamento de Maldonado',218),(3555,'Departamento de Montevideo',218),(3556,'Departamento de Paysandu',218),(3557,'Departamento de Rio Negro',218),(3558,'Departamento de Rivera',218),(3559,'Departamento de Rocha',218),(3560,'Departamento de Salto',218),(3561,'Departamento de San Jose',218),(3562,'Departamento de Soriano',218),(3563,'Departamento de Tacuarembo',218),(3564,'Departamento de Treinta y Tres',218),(3565,'Andijan',219),(3566,'Bukhara Province',219),(3567,'Fergana',219),(3568,'Jizzakh Province',219),(3569,'Karakalpakstan',219),(3570,'Namangan Province',219),(3571,'Navoiy Province',219),(3572,'Qashqadaryo Province',219),(3573,'Samarqand Viloyati',219),(3574,'Sirdaryo',219),(3575,'Surxondaryo Viloyati',219),(3576,'Toshkent Shahri',219),(3577,'Toshkent Viloyati',219),(3578,'Xorazm Viloyati',219),(3579,'Malampa Province',220),(3580,'Penama Province',220),(3581,'Sanma Province',220),(3582,'Shefa Province',220),(3583,'Tafea Province',220),(3584,'Torba Province',220),(3585,'Delta Amacuro',221),(3586,'Dependencias Federales',221),(3587,'Distrito Capital',221),(3588,'Estado Amazonas',221),(3589,'Estado Anzoategui',221),(3590,'Estado Apure',221),(3591,'Estado Aragua',221),(3592,'Estado Barinas',221),(3593,'Estado Bolivar',221),(3594,'Estado Carabobo',221),(3595,'Estado Cojedes',221),(3596,'Estado Falcon',221),(3597,'Estado Guarico',221),(3598,'Estado Lara',221),(3599,'Estado Merida',221),(3600,'Estado Monagas',221),(3601,'Estado Nueva Esparta',221),(3602,'Estado Portuguesa',221),(3603,'Estado Sucre',221),(3604,'Estado Tachira',221),(3605,'Estado Trujillo',221),(3606,'Estado Vargas',221),(3607,'Estado Yaracuy',221),(3608,'Estado Zulia',221),(3609,'Miranda',221),(3610,'An Giang',222),(3611,'Dak Nong',222),(3612,'Gia Lai',222),(3613,'Hau Giang',222),(3614,'Ho Chi Minh City',222),(3615,'Kon Tum',222),(3616,'Long An',222),(3617,'Thanh Pho Can Tho',222),(3618,'Thanh Pho GJa Nang',222),(3619,'Thanh Pho Ha Noi',222),(3620,'Thanh Pho Hai Phong',222),(3621,'Tinh Ba Ria-Vung Tau',222),(3622,'Tinh Bac Giang',222),(3623,'Tinh Bac Kan',222),(3624,'Tinh Bac Lieu',222),(3625,'Tinh Bac Ninh',222),(3626,'Tinh Ben Tre',222),(3627,'Tinh Binh Duong',222),(3628,'Tinh Binh GJinh',222),(3629,'Tinh Binh Phuoc',222),(3630,'Tinh Binh Thuan',222),(3631,'Tinh Ca Mau',222),(3632,'Tinh Cao Bang',222),(3633,'Tinh Dien Bien',222),(3634,'Tinh GJak Lak',222),(3635,'Tinh GJong Nai',222),(3636,'Tinh GJong Thap',222),(3637,'Tinh Ha Giang',222),(3638,'Tinh Ha Nam',222),(3639,'Tinh Ha Tinh',222),(3640,'Tinh Hai Duong',222),(3641,'Tinh Hoa Binh',222),(3642,'Tinh Hung Yen',222),(3643,'Tinh Khanh Hoa',222),(3644,'Tinh Kien Giang',222),(3645,'Tinh Lai Chau',222),(3646,'Tinh Lam GJong',222),(3647,'Tinh Lang Son',222),(3648,'Tinh Lao Cai',222),(3649,'Tinh Nam GJinh',222),(3650,'Tinh Nghe An',222),(3651,'Tinh Ninh Binh',222),(3652,'Tinh Ninh Thuan',222),(3653,'Tinh Phu Tho',222),(3654,'Tinh Phu Yen',222),(3655,'Tinh Quang Binh',222),(3656,'Tinh Quang Nam',222),(3657,'Tinh Quang Ngai',222),(3658,'Tinh Quang Ninh',222),(3659,'Tinh Quang Tri',222),(3660,'Tinh Soc Trang',222),(3661,'Tinh Son La',222),(3662,'Tinh Tay Ninh',222),(3663,'Tinh Thai Binh',222),(3664,'Tinh Thai Nguyen',222),(3665,'Tinh Thanh Hoa',222),(3666,'Tinh Thua Thien-Hue',222),(3667,'Tinh Tien Giang',222),(3668,'Tinh Tra Vinh',222),(3669,'Tinh Tuyen Quang',222),(3670,'Tinh Vinh Long',222),(3671,'Tinh Vinh Phuc',222),(3672,'Tinh Yen Bai',222),(3673,'Saint Croix Island',224),(3674,'Saint John Island',224),(3675,'Saint Thomas Island',224),(3676,'Alo',225),(3677,'Sigave',225),(3678,'Uvea',225),(3679,'Al Bayda Governorate',227),(3680,'Al Mahrah',227),(3681,'Al Mahwit',227),(3682,'Amanat Al Asimah',227),(3683,'Ibb',227),(3685,'Muhafazat \'Adan',227),(3686,'Muhafazat Abyan',227),(3687,'Muhafazat ad Dali\'',227),(3688,'Muhafazat al Hudaydah',227),(3689,'Muhafazat al Jawf',227),(3690,'Muhafazat Dhamar',227),(3691,'Muhafazat Hadramawt',227),(3692,'Muhafazat Hajjah',227),(3693,'Muhafazat Lahij',227),(3694,'Muhafazat Ma\'rib',227),(3695,'Muhafazat Raymah',227),(3696,'Muhafazat Sa\'dah',227),(3697,'Muhafazat Ta`izz',227),(3684,'Muhafazat `Amran',227),(3698,'Sanaa',227),(3699,'Shabwah',227),(3700,'Socotra',227),(3701,'Central Province',229),(3702,'Copperbelt Province',229),(3703,'Eastern Province',229),(3704,'Luapula Province',229),(3705,'Lusaka Province',229),(3706,'Muchinga Province',229),(3707,'North-Western Province',229),(3708,'Northern Province',229),(3709,'Southern Province',229),(3710,'Western Province',229),(3711,'Bulawayo Province',230),(3712,'Harare Province',230),(3713,'Manicaland Province',230),(3714,'Mashonaland Central Province',230),(3715,'Mashonaland East Province',230),(3716,'Mashonaland West Province',230),(3717,'Masvingo Province',230),(3718,'Matabeleland North Province',230),(3719,'Matabeleland South Province',230),(3720,'Midlands Province',230);
  /*!40000 ALTER TABLE `state` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `traveldetails`
  --
  
  DROP TABLE IF EXISTS `traveldetails`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `traveldetails` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `start_date` date NOT NULL,
    `end_date` date NOT NULL,
    `poe_id` int(11) NOT NULL,
    `flight_number` varchar(45) NOT NULL,
    `arrival_time` time NOT NULL,
    `departing_city` int(11) NOT NULL,
    `departing_country` smallint(5) unsigned NOT NULL,
    `address1` varchar(45) NOT NULL,
    `address2` varchar(45) NOT NULL,
    `city_id` int(11) NOT NULL,
    `state_id` int(11) unsigned NOT NULL,
    `zipcode` varchar(45) NOT NULL,
    `customs_status` int(11) NOT NULL,
    `customs_comments` longtext,
    PRIMARY KEY (`id`),
    KEY `fk_td_poe_idx` (`poe_id`),
    KEY `fk_td_status_idx` (`customs_status`),
    KEY `fk_td_user_idx` (`user_id`),
    KEY `fk_td_city_idx` (`departing_city`),
    KEY `fk_td_country_idx` (`departing_country`),
    KEY `fk_td_city_us_idx` (`city_id`),
    KEY `fk_td_state_us_idx` (`state_id`),
    CONSTRAINT `fk_td_city` FOREIGN KEY (`departing_city`) REFERENCES `city` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_td_city_us` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_td_country` FOREIGN KEY (`departing_country`) REFERENCES `country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_td_poe` FOREIGN KEY (`poe_id`) REFERENCES `poe` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_td_state_us` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_td_status` FOREIGN KEY (`customs_status`) REFERENCES `customs_status_master` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_td_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `traveldetails`
  --
  
  LOCK TABLES `traveldetails` WRITE;
  /*!40000 ALTER TABLE `traveldetails` DISABLE KEYS */;
  INSERT INTO `traveldetails` VALUES (1,3,'2018-05-01','2018-07-02',1,'BA001','12:00:00',3566,94,'701 ','S Nedderman Dr',2802,3538,'76019',4,'potential threat.&#10;undefined'),(2,8,'2018-12-31','2018-12-31',1,'65','23:59:00',3258,94,'908 Greek Row Dr, Apt No 246','Apt No 246',2639,3538,'76013',4,'my comments\nok its not safe.&#10;undefined'),(3,8,'2018-12-31','2018-12-31',1,'65','23:59:00',3258,94,'908 Greek Row Dr, Apt No 246','Apt No 246',2639,3538,'76013',1,NULL),(4,8,'2018-12-31','2018-12-31',1,'65','23:59:00',3258,94,'908 Greek Row Dr, Apt No 246','Apt No 246',2784,3538,'234324324',1,NULL),(5,8,'2018-12-31','2018-12-31',1,'65','23:59:00',3258,94,'908 Greek Row Dr, Apt No 246','Apt No 246',2321,3533,'234324324',1,NULL);
  /*!40000 ALTER TABLE `traveldetails` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user`
  --
  
  DROP TABLE IF EXISTS `user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` varchar(45) NOT NULL,
    `password` varchar(45) NOT NULL,
    `fname` varchar(45) NOT NULL,
    `mname` varchar(45) DEFAULT NULL,
    `lname` varchar(45) NOT NULL,
    `email_id` varchar(45) NOT NULL,
    `date_of_birth` date NOT NULL,
    `address1` varchar(45) NOT NULL,
    `address2` varchar(45) NOT NULL,
    `city_id` int(11) NOT NULL,
    `state_id` int(11) unsigned NOT NULL,
    `country_id` int(10) unsigned NOT NULL,
    `zipcode` varchar(45) NOT NULL,
    `visatype_id` int(11) DEFAULT NULL,
    `visa_number` varchar(45) DEFAULT NULL,
    `visa_expiry_date` date DEFAULT NULL,
    `user_type_id` int(11) NOT NULL,
    `accountstatus` char(1) NOT NULL DEFAULT 'Y',
    `passport` varchar(45) NOT NULL,
    `issuing_country_id` int(11) NOT NULL,
    `passport_expiry_date` varchar(45) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `user_id_UNIQUE` (`user_id`),
    KEY `fk_user_city_idx` (`city_id`),
    KEY `fk_user_state_idx` (`state_id`),
    KEY `fk_user_country_idx` (`country_id`),
    KEY `fk_user_type_idx` (`user_type_id`),
    KEY `fk_user_visa_idx` (`visatype_id`),
    CONSTRAINT `fk_user_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_user_state` FOREIGN KEY (`state_id`) REFERENCES `state` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_user_type` FOREIGN KEY (`user_type_id`) REFERENCES `user_type_master` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_user_visa` FOREIGN KEY (`visatype_id`) REFERENCES `visa_master` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user`
  --
  
  LOCK TABLES `user` WRITE;
  /*!40000 ALTER TABLE `user` DISABLE KEYS */;
  INSERT INTO `user` VALUES (1,'admin','admin','John',NULL,'Smith','admin@usatravelers.com','1990-01-01','701','S Nedderman Dr',2886,3541,217,'76019',NULL,NULL,NULL,3,'Y','',0,''),(2,'benkell','customs1','Ben',NULL,'Kell','benkell@usatravelers.com','1990-01-01','701','S Nedderman Dr',2886,3541,217,'76019',NULL,NULL,NULL,2,'Y','',0,''),(3,'prasadkrn','hello123','Nagendra',NULL,'Prasad','prasadkrn@hotmail.com','1990-01-01','701','S Nedderman Dr',2886,3541,217,'76019',NULL,NULL,NULL,1,'Y','',0,''),(8,'prasad','111','Nagendra Prasad','Kasaghatta','Ramachandra','prasadkrn@hotmail.com','2018-12-31','908 Greek Row Dr','Apt No 246',3258,94,1235,'111',1,'111',NULL,1,'Y','111',215,'2018-12-31');
  /*!40000 ALTER TABLE `user` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_type_master`
  --
  
  DROP TABLE IF EXISTS `user_type_master`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `user_type_master` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `type` varchar(45) NOT NULL,
    `description` varchar(45) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `type_UNIQUE` (`type`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_type_master`
  --
  
  LOCK TABLES `user_type_master` WRITE;
  /*!40000 ALTER TABLE `user_type_master` DISABLE KEYS */;
  INSERT INTO `user_type_master` VALUES (1,'Traveler','Traveler'),(2,'Customs Officer','Customs Officer'),(3,'Admin','Admin');
  /*!40000 ALTER TABLE `user_type_master` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `visa_master`
  --
  
  DROP TABLE IF EXISTS `visa_master`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `visa_master` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `visatype` varchar(45) NOT NULL,
    `description` longtext NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `visatype_UNIQUE` (`visatype`)
  ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `visa_master`
  --
  
  LOCK TABLES `visa_master` WRITE;
  /*!40000 ALTER TABLE `visa_master` DISABLE KEYS */;
  INSERT INTO `visa_master` VALUES (1,'B-1','Athlete, amateur or professional (competing for prize money only),Business visitor,Domestic employee or nanny - must be accompanying a foreign national employer'),(2,'E-3','Australian professional specialty'),(3,'BCC','Border Crossing Card: Mexico'),(4,'CW-1','CNMI-only transitional worker'),(5,'D','Crewmember'),(6,'A','Diplomat or foreign government official'),(7,'G1','Employee of a designated international organization or NATO'),(8,'G2','Employee of a designated international organization or NATO'),(9,'G3','Employee of a designated international organization or NATO'),(10,'G4','Employee of a designated international organization or NATO'),(11,'G5','Employee of a designated international organization or NATO'),(12,'NATO','Employee of a designated international organization or NATO'),(13,'A-2','Foreign military personnel stationed in the United States'),(14,'O','Foreign national with extraordinary ability in Sciences, Arts, Education, Business or Athletics'),(15,'H-1B1 - Chile','Free Trade Agreement (FTA) Professional:Chile'),(16,'H-1B1 - Singapore','Free Trade Agreement (FTA) Professional: Singapore'),(17,'Q','International cultural exchange visitor'),(18,'L','Intra-company transferee'),(19,'I','Media, journalist'),(20,'TN/TD','NAFTA professional worker: Mexico, Canada'),(21,'P','Performing athlete, artist, entertainer'),(22,'J','Professor, scholar, teacher (exchange visitor),Physician'),(23,'R','Religious worker'),(24,'H-1B','Specialty occupations in fields requiring highly specialized knowledge'),(25,'F','Student: academic, vocational'),(26,'M','Student: academic, vocational'),(27,'H-2A','Temporary agricultural worker'),(28,'H-2B','Temporary worker performing other services or labor of a temporary or seasonal nature.'),(29,'B-2','Tourism, vacation, pleasure visitor,Medical treatment'),(30,'H-3','Training in a program not primarily for employment'),(31,'E','Treaty trader/treaty investor'),(32,'C','Transiting the United States'),(33,'U','Victim of Criminal Activity'),(34,'T','Victim of Human Trafficking'),(35,'V','Nonimmigrant (V) Visa for Spouse and Children of a Lawful Permanent Resident (LPR)'),(36,'IR1, CR1','Spouse of a U.S. Citizen '),(37,'K-3 *','Spouse of a U.S. Citizen awaiting approval of an I-130 immigrant petition'),(38,'K-1 *','Fiancé(e) to marry U.S. Citizen & live in U.S.'),(39,'IR3, IH3, IR4, IH4','Intercountry Adoption of Orphan Children by U.S. Citizens'),(40,'IR2, CR2, IR5, F1, F3, F4','Certain Family Members of U.S. Citizens'),(41,'F2A, F2B','Certain Family Members of Lawful Permanent Residents'),(42,'SD, SR','Religious Workers'),(43,'SI ','Iraqi and Afghan Translators/Interpreters'),(44,'SQ','Iraqis/Afghan  Who Worked for/on Behalf of the U.S. Government'),(45,'DV','Diversity Immigrant Visa'),(46,'SB','Returning Resident');
  /*!40000 ALTER TABLE `visa_master` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2018-04-29 21:05:01
  