/*!40101 SET NAMES utf8 */; /******************************************************* * * civicrm_county (!! TBD) * * Look at importing county tables (re: Advokit) * *******************************************************/ INSERT INTO civicrm_country (id, name,iso_code) VALUES("1001", "Afghanistan", "AF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1002", "Albania", "AL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1003", "Algeria", "DZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1004", "American Samoa", "AS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1005", "Andorra", "AD"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1006", "Angola", "AO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1007", "Anguilla", "AI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1008", "Antarctica", "AQ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1009", "Antigua and Barbuda", "AG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1010", "Argentina", "AR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1011", "Armenia", "AM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1012", "Aruba", "AW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1013", "Australia", "AU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1014", "Austria", "AT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1015", "Azerbaijan", "AZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1016", "Bahrain", "BH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1017", "Bangladesh", "BD"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1018", "Barbados", "BB"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1019", "Belarus", "BY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1020", "Belgium", "BE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1021", "Belize", "BZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1022", "Benin", "BJ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1023", "Bermuda", "BM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1024", "Bhutan", "BT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1025", "Bolivia", "BO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1026", "Bosnia and Herzegovina", "BA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1027", "Botswana", "BW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1028", "Bouvet Island", "BV"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1029", "Brazil", "BR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1030", "British Indian Ocean Territory", "IO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1031", "Virgin Islands, British", "VG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1032", "Brunei Darussalam", "BN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1033", "Bulgaria", "BG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1034", "Burkina Faso", "BF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1035", "Myanmar", "MM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1036", "Burundi", "BI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1037", "Cambodia", "KH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1038", "Cameroon", "CM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1039", "Canada", "CA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1040", "Cape Verde", "CV"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1041", "Cayman Islands", "KY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1042", "Central African Republic", "CF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1043", "Chad", "TD"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1044", "Chile", "CL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1045", "China", "CN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1046", "Christmas Island", "CX"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1047", "Cocos (Keeling) Islands", "CC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1048", "Colombia", "CO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1049", "Comoros", "KM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1050", "Congo, The Democratic Republic of the", "CD"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1051", "Congo", "CG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1052", "Cook Islands", "CK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1053", "Costa Rica", "CR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1054", "Côte d\'Ivoire", "CI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1055", "Croatia", "HR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1056", "Cuba", "CU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1057", "Cyprus", "CY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1058", "Czech Republic", "CZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1059", "Denmark", "DK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1060", "Djibouti", "DJ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1061", "Dominica", "DM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1062", "Dominican Republic", "DO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1063", "Timor-Leste", "TL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1064", "Ecuador", "EC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1065", "Egypt", "EG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1066", "El Salvador", "SV"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1067", "Equatorial Guinea", "GQ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1068", "Eritrea", "ER"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1069", "Estonia", "EE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1070", "Ethiopia", "ET"); -- INSERT INTO civicrm_country (id, name,iso_code) VALUES("1071", "European Union", "EU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1072", "Falkland Islands (Malvinas)", "FK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1073", "Faroe Islands", "FO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1074", "Fiji", "FJ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1075", "Finland", "FI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1076", "France", "FR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1077", "French Guiana", "GF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1078", "French Polynesia", "PF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1079", "French Southern Territories", "TF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1080", "Gabon", "GA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1081", "Georgia", "GE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1082", "Germany", "DE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1083", "Ghana", "GH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1084", "Gibraltar", "GI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1085", "Greece", "GR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1086", "Greenland", "GL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1087", "Grenada", "GD"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1088", "Guadeloupe", "GP"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1089", "Guam", "GU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1090", "Guatemala", "GT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1091", "Guinea", "GN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1092", "Guinea-Bissau", "GW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1093", "Guyana", "GY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1094", "Haiti", "HT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1095", "Heard Island and McDonald Islands", "HM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1096", "Holy See (Vatican City State)", "VA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1097", "Honduras", "HN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1098", "Hong Kong", "HK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1099", "Hungary", "HU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1100", "Iceland", "IS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1101", "India", "IN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1102", "Indonesia", "ID"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1103", "Iran, Islamic Republic of", "IR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1104", "Iraq", "IQ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1105", "Ireland", "IE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1106", "Israel", "IL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1107", "Italy", "IT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1108", "Jamaica", "JM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1109", "Japan", "JP"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1110", "Jordan", "JO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1111", "Kazakhstan", "KZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1112", "Kenya", "KE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1113", "Kiribati", "KI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1114", "Korea, Democratic People\'s Republic of", "KP"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1115", "Korea, Republic of", "KR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1116", "Kuwait", "KW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1117", "Kyrgyzstan", "KG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1118", "Lao People\'s Democratic Republic", "LA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1119", "Latvia", "LV"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1120", "Lebanon", "LB"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1121", "Lesotho", "LS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1122", "Liberia", "LR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1123", "Libyan Arab Jamahiriya", "LY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1124", "Liechtenstein", "LI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1125", "Lithuania", "LT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1126", "Luxembourg", "LU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1127", "Macao", "MO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1128", "Macedonia, Republic of", "MK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1129", "Madagascar", "MG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1130", "Malawi", "MW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1131", "Malaysia", "MY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1132", "Maldives", "MV"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1133", "Mali", "ML"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1134", "Malta", "MT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1135", "Marshall Islands", "MH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1136", "Martinique", "MQ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1137", "Mauritania", "MR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1138", "Mauritius", "MU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1139", "Mayotte", "YT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1140", "Mexico", "MX"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1141", "Micronesia, Federated States of", "FM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1142", "Moldova, Republic of", "MD"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1143", "Monaco", "MC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1144", "Mongolia", "MN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1145", "Montserrat", "MS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1146", "Morocco", "MA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1147", "Mozambique", "MZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1148", "Namibia", "NA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1149", "Nauru", "NR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1150", "Nepal", "NP"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1151", "Netherlands Antilles", "AN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1152", "Netherlands", "NL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1153", "New Caledonia", "NC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1154", "New Zealand", "NZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1155", "Nicaragua", "NI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1156", "Niger", "NE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1157", "Nigeria", "NG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1158", "Niue", "NU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1159", "Norfolk Island", "NF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1160", "Northern Mariana Islands", "MP"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1161", "Norway", "NO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1162", "Oman", "OM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1163", "Pakistan", "PK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1164", "Palau", "PW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1165", "Palestinian Territory, Occupied", "PS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1166", "Panama", "PA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1167", "Papua New Guinea", "PG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1168", "Paraguay", "PY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1169", "Peru", "PE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1170", "Philippines", "PH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1171", "Pitcairn", "PN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1172", "Poland", "PL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1173", "Portugal", "PT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1174", "Puerto Rico", "PR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1175", "Qatar", "QA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1176", "Romania", "RO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1177", "Russian Federation", "RU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1178", "Rwanda", "RW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1179", "Reunion", "RE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1180", "Saint Helena", "SH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1181", "Saint Kitts and Nevis", "KN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1182", "Saint Lucia", "LC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1183", "Saint Pierre and Miquelon", "PM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1184", "Saint Vincent and the Grenadines", "VC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1185", "Samoa", "WS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1186", "San Marino", "SM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1187", "Saudi Arabia", "SA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1188", "Senegal", "SN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1189", "Seychelles", "SC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1190", "Sierra Leone", "SL"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1191", "Singapore", "SG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1192", "Slovakia", "SK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1193", "Slovenia", "SI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1194", "Solomon Islands", "SB"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1195", "Somalia", "SO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1196", "South Africa", "ZA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1197", "South Georgia and the South Sandwich Islands", "GS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1198", "Spain", "ES"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1199", "Sri Lanka", "LK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1200", "Sudan", "SD"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1201", "Suriname", "SR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1202", "Svalbard and Jan Mayen", "SJ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1203", "Swaziland", "SZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1204", "Sweden", "SE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1205", "Switzerland", "CH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1206", "Syrian Arab Republic", "SY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1207", "Sao Tome and Principe", "ST"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1208", "Taiwan", "TW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1209", "Tajikistan", "TJ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1210", "Tanzania, United Republic of", "TZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1211", "Thailand", "TH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1212", "Bahamas", "BS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1213", "Gambia", "GM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1214", "Togo", "TG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1215", "Tokelau", "TK"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1216", "Tonga", "TO"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1217", "Trinidad and Tobago", "TT"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1218", "Tunisia", "TN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1219", "Turkey", "TR"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1220", "Turkmenistan", "TM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1221", "Turks and Caicos Islands", "TC"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1222", "Tuvalu", "TV"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1223", "Uganda", "UG"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1224", "Ukraine", "UA"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1225", "United Arab Emirates", "AE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1226", "United Kingdom", "GB"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1227", "United States Minor Outlying Islands", "UM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1228", "United States", "US"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1229", "Uruguay", "UY"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1230", "Uzbekistan", "UZ"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1231", "Vanuatu", "VU"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1232", "Venezuela", "VE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1233", "Viet Nam", "VN"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1234", "Virgin Islands, U.S.", "VI"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1235", "Wallis and Futuna", "WF"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1236", "Western Sahara", "EH"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1237", "Yemen", "YE"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1238", "Serbia and Montenegro", "CS"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1239", "Zambia", "ZM"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1240", "Zimbabwe", "ZW"); INSERT INTO civicrm_country (id, name,iso_code) VALUES("1241", "Åland Islands", "AX"); /*!40101 SET NAMES utf8 */; INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (1000, 1228, "AL", "Alabama"), (1001, 1228, "AK", "Alaska"), (1002, 1228, "AZ", "Arizona"), (1003, 1228, "AR", "Arkansas"), (1004, 1228, "CA", "California"), (1005, 1228, "CO", "Colorado"), (1006, 1228, "CT", "Connecticut"), (1007, 1228, "DE", "Delaware"), (1008, 1228, "FL", "Florida"), (1009, 1228, "GA", "Georgia"), (1010, 1228, "HI", "Hawaii"), (1011, 1228, "ID", "Idaho"), (1012, 1228, "IL", "Illinois"), (1013, 1228, "IN", "Indiana"), (1014, 1228, "IA", "Iowa"), (1015, 1228, "KS", "Kansas"), (1016, 1228, "KY", "Kentucky"), (1017, 1228, "LA", "Louisiana"), (1018, 1228, "ME", "Maine"), (1019, 1228, "MD", "Maryland"), (1020, 1228, "MA", "Massachusetts"), (1021, 1228, "MI", "Michigan"), (1022, 1228, "MN", "Minnesota"), (1023, 1228, "MS", "Mississippi"), (1024, 1228, "MO", "Missouri"), (1025, 1228, "MT", "Montana"), (1026, 1228, "NE", "Nebraska"), (1027, 1228, "NV", "Nevada"), (1028, 1228, "NH", "New Hampshire"), (1029, 1228, "NJ", "New Jersey"), (1030, 1228, "NM", "New Mexico"), (1031, 1228, "NY", "New York"), (1032, 1228, "NC", "North Carolina"), (1033, 1228, "ND", "North Dakota"), (1034, 1228, "OH", "Ohio"), (1035, 1228, "OK", "Oklahoma"), (1036, 1228, "OR", "Oregon"), (1037, 1228, "PA", "Pennsylvania"), (1038, 1228, "RI", "Rhode Island"), (1039, 1228, "SC", "South Carolina"), (1040, 1228, "SD", "South Dakota"), (1041, 1228, "TN", "Tennessee"), (1042, 1228, "TX", "Texas"), (1043, 1228, "UT", "Utah"), (1044, 1228, "VT", "Vermont"), (1045, 1228, "VA", "Virginia"), (1046, 1228, "WA", "Washington"), (1047, 1228, "WV", "West Virginia"), (1048, 1228, "WI", "Wisconsin"), (1049, 1228, "WY", "Wyoming"), (1050, 1228, "DC", "District of Columbia"), (1052, 1228, "AS", "American Samoa"), (1053, 1228, "GU", "Guam"), (1055, 1228, "MP", "Northern Mariana Islands"), (1056, 1228, "PR", "Puerto Rico"), (1057, 1228, "VI", "Virgin Islands"), (1058, 1228, "UM", "United States Minor Outlying Islands"), (1059, 1228, "AE", "Armed Forces Europe"), (1060, 1228, "AA", "Armed Forces Americas"), (1061, 1228, "AP", "Armed Forces Pacific"), (1100, 1039, "AB", "Alberta"), (1101, 1039, "BC", "British Columbia"), (1102, 1039, "MB", "Manitoba"), (1103, 1039, "NB", "New Brunswick"), (1104, 1039, "NL", "Newfoundland and Labrador"), (1105, 1039, "NT", "Northwest Territories"), (1106, 1039, "NS", "Nova Scotia"), (1107, 1039, "NU", "Nunavut"), (1108, 1039, "ON", "Ontario"), (1109, 1039, "PE", "Prince Edward Island"), (1110, 1039, "QC", "Quebec"), (1111, 1039, "SK", "Saskatchewan"), (1112, 1039, "YT", "Yukon Territory"), (1200, 1101, "MM", "Maharashtra"), (1201, 1101, "KA", "Karnataka"), (1202, 1101, "AP", "Andhra Pradesh"), (1203, 1101, "AR", "Arunachal Pradesh"), (1204, 1101, "AS", "Assam"), (1205, 1101, "BR", "Bihar"), (1206, 1101, "CH", "Chhattisgarh"), (1207, 1101, "GA", "Goa"), (1208, 1101, "GJ", "Gujarat"), (1209, 1101, "HR", "Haryana"), (1210, 1101, "HP", "Himachal Pradesh"), (1211, 1101, "JK", "Jammu and Kashmir"), (1212, 1101, "JH", "Jharkhand"), (1213, 1101, "KL", "Kerala"), (1214, 1101, "MP", "Madhya Pradesh"), (1215, 1101, "MN", "Manipur"), (1216, 1101, "ML", "Meghalaya"), (1217, 1101, "MZ", "Mizoram"), (1218, 1101, "NL", "Nagaland"), (1219, 1101, "OR", "Orissa"), (1220, 1101, "PB", "Punjab"), (1221, 1101, "RJ", "Rajasthan"), (1222, 1101, "SK", "Sikkim"), (1223, 1101, "TN", "Tamil Nadu"), (1224, 1101, "TR", "Tripura"), (1225, 1101, "UL", "Uttaranchal"), (1226, 1101, "UP", "Uttar Pradesh"), (1227, 1101, "WB", "West Bengal"), (1228, 1101, "AN", "Andaman and Nicobar Islands"), (1229, 1101, "DN", "Dadra and Nagar Haveli"), (1230, 1101, "DD", "Daman and Diu"), (1231, 1101, "DL", "Delhi"), (1232, 1101, "LD", "Lakshadweep"), (1233, 1101, "PY", "Pondicherry"), (1300, 1172, "MZ", "mazowieckie"), (1301, 1172, "PM", "pomorskie"), (1302, 1172, "DS", "dolnośląskie"), (1303, 1172, "KP", "kujawsko-pomorskie"), (1304, 1172, "LU", "lubelskie"), (1305, 1172, "LB", "lubuskie"), (1306, 1172, "LD", "łódzkie"), (1307, 1172, "MA", "małopolskie"), (1308, 1172, "OP", "opolskie"), (1309, 1172, "PK", "podkarpackie"), (1310, 1172, "PD", "podlaskie"), (1311, 1172, "SL", "śląskie"), (1312, 1172, "SK", "świętokrzyskie"), (1313, 1172, "WN", "warmińsko-mazurskie"), (1314, 1172, "WP", "wielkopolskie"), (1315, 1172, "ZP", "zachodniopomorskie"), (1500, 1225, "AZ", "Abu Zaby"), (1501, 1225, "AJ", "\'Ajman"), (1502, 1225, "FU", "Al Fujayrah"), (1503, 1225, "SH", "Ash Shariqah"), (1504, 1225, "DU", "Dubayy"), (1505, 1225, "RK", "Ra\'s al Khaymah"), (1506, 1233, "33", "Dac Lac"), (1507, 1225, "UQ", "Umm al Qaywayn"), (1508, 1001, "BDS", "Badakhshan"), (1509, 1001, "BDG", "Badghis"), (1510, 1001, "BGL", "Baghlan"), (1511, 1001, "BAL", "Balkh"), (1512, 1001, "BAM", "Bamian"), (1513, 1001, "FRA", "Farah"), (1514, 1001, "FYB", "Faryab"), (1515, 1001, "GHA", "Ghazni"), (1516, 1001, "GHO", "Ghowr"), (1517, 1001, "HEL", "Helmand"), (1518, 1001, "HER", "Herat"), (1519, 1001, "JOW", "Jowzjan"), (1520, 1001, "KAB", "Kabul"), (1521, 1001, "KAN", "Kandahar"), (1522, 1001, "KAP", "Kapisa"), (1523, 1001, "KHO", "Khowst"), (1524, 1001, "KNR", "Konar"), (1525, 1001, "KDZ", "Kondoz"), (1526, 1001, "LAG", "Laghman"), (1527, 1001, "LOW", "Lowgar"), (1528, 1001, "NAN", "Nangrahar"), (1529, 1001, "NIM", "Nimruz"), (1530, 1001, "NUR", "Nurestan"), (1531, 1001, "ORU", "Oruzgan"), (1532, 1001, "PIA", "Paktia"), (1533, 1001, "PKA", "Paktika"), (1534, 1001, "PAR", "Parwan"), (1535, 1001, "SAM", "Samangan"), (1536, 1001, "SAR", "Sar-e Pol"), (1537, 1001, "TAK", "Takhar"), (1538, 1001, "WAR", "Wardak"), (1539, 1001, "ZAB", "Zabol"), (1540, 1002, "BR", "Berat"), (1541, 1002, "BU", "Bulqizë"), (1542, 1002, "DL", "Delvinë"), (1543, 1002, "DV", "Devoll"), (1544, 1002, "DI", "Dibër"), (1545, 1002, "DR", "Durrsës"), (1546, 1002, "EL", "Elbasan"), (1547, 1002, "FR", "Fier"), (1548, 1002, "GR", "Gramsh"), (1549, 1002, "GJ", "Gjirokastër"), (1550, 1002, "HA", "Has"), (1551, 1002, "KA", "Kavajë"), (1552, 1002, "ER", "Kolonjë"), (1553, 1002, "KO", "Korcë"), (1554, 1002, "KR", "Krujë"), (1555, 1002, "KC", "Kuçovë"), (1556, 1002, "KU", "Kukës"), (1557, 1002, "KB", "Kurbin"), (1558, 1002, "LE", "Lezhë"), (1559, 1002, "LB", "Librazhd"), (1560, 1002, "LU", "Lushnjë"), (1561, 1002, "MM", "Malësi e Madhe"), (1562, 1002, "MK", "Mallakastër"), (1563, 1002, "MT", "Mat"), (1564, 1002, "MR", "Mirditë"), (1565, 1002, "PQ", "Peqin"), (1566, 1002, "PR", "Përmet"), (1567, 1002, "PG", "Pogradec"), (1568, 1002, "PU", "Pukë"), (1569, 1002, "SR", "Sarandë"), (1570, 1002, "SK", "Skrapar"), (1571, 1002, "SH", "Shkodër"), (1572, 1002, "TE", "Tepelenë"), (1573, 1002, "TR", "Tiranë"), (1574, 1002, "TP", "Tropojë"), (1575, 1002, "VL", "Vlorë"), (1576, 1011, "ER", "Erevan"), (1577, 1011, "AG", "Aragacotn"), (1578, 1011, "AR", "Ararat"), (1579, 1011, "AV", "Armavir"), (1580, 1011, "GR", "Gegarkunik\'"), (1581, 1011, "KT", "Kotayk\'"), (1582, 1011, "LO", "Lory"), (1583, 1011, "SH", "Sirak"), (1584, 1011, "SU", "Syunik\'"), (1585, 1011, "TV", "Tavus"), (1586, 1011, "VD", "Vayoc Jor"), (1587, 1006, "BGO", "Bengo"), (1588, 1006, "BGU", "Benguela"), (1589, 1006, "BIE", "Bie"), (1590, 1006, "CAB", "Cabinda"), (1591, 1006, "CCU", "Cuando-Cubango"), (1592, 1006, "CNO", "Cuanza Norte"), (1593, 1006, "CUS", "Cuanza Sul"), (1594, 1006, "CNN", "Cunene"), (1595, 1006, "HUA", "Huambo"), (1596, 1006, "HUI", "Huila"), (1597, 1006, "LUA", "Luanda"), (1598, 1006, "LNO", "Lunda Norte"), (1599, 1006, "LSU", "Lunda Sul"), (1600, 1006, "MAL", "Malange"), (1601, 1006, "MOX", "Moxico"), (1602, 1006, "NAM", "Namibe"), (1603, 1006, "UIG", "Uige"), (1604, 1006, "ZAI", "Zaire"), (1605, 1010, "C", "Capital federal"), (1606, 1010, "B", "Buenos Aires"), (1607, 1010, "K", "Catamarca"), (1608, 1010, "X", "Cordoba"), (1609, 1010, "W", "Corrientes"), (1610, 1010, "H", "Chaco"), (1611, 1010, "U", "Chubut"), (1612, 1010, "E", "Entre Rios"), (1613, 1010, "P", "Formosa"), (1614, 1010, "Y", "Jujuy"), (1615, 1010, "L", "La Pampa"), (1616, 1010, "M", "Mendoza"), (1617, 1010, "N", "Misiones"), (1618, 1010, "Q", "Neuquen"), (1619, 1010, "R", "Rio Negro"), (1620, 1010, "A", "Salta"), (1621, 1010, "J", "San Juan"), (1622, 1010, "D", "San Luis"), (1623, 1010, "Z", "Santa Cruz"), (1624, 1010, "S", "Santa Fe"), (1625, 1010, "G", "Santiago del Estero"), (1626, 1010, "V", "Tierra del Fuego"), (1627, 1010, "T", "Tucuman"), (1628, 1014, "1", "Burgenland"), (1629, 1014, "2", "Kärnten"), (1630, 1014, "3", "Niederosterreich"), (1631, 1014, "4", "Oberosterreich"), (1632, 1014, "5", "Salzburg"), (1633, 1014, "6", "Steiermark"), (1634, 1014, "7", "Tirol"), (1635, 1014, "8", "Vorarlberg"), (1636, 1014, "9", "Wien"), (1637, 1013, "AAT", "Australian Antarctic Territory"), (1638, 1013, "ACT", "Australian Capital Territory"), (1639, 1013, "NT", "Northern Territory"), (1640, 1013, "NSW", "New South Wales"), (1641, 1013, "QLD", "Queensland"), (1642, 1013, "SA", "South Australia"), (1643, 1013, "TAS", "Tasmania"), (1644, 1013, "VIC", "Victoria"), (1645, 1013, "WA", "Western Australia"), (1646, 1015, "NX", "Naxcivan"), (1647, 1015, "AB", "Ali Bayramli"), (1648, 1015, "BA", "Baki"), (1649, 1015, "GA", "Ganca"), (1650, 1015, "LA", "Lankaran"), (1651, 1015, "MI", "Mingacevir"), (1652, 1015, "NA", "Naftalan"), (1653, 1015, "SA", "Saki"), (1654, 1015, "SM", "Sumqayit"), (1655, 1015, "SS", "Susa"), (1656, 1015, "XA", "Xankandi"), (1657, 1015, "YE", "Yevlax"), (1658, 1015, "ABS", "Abseron"), (1659, 1015, "AGC", "Agcabadi"), (1660, 1015, "AGM", "Agdam"), (1661, 1015, "AGS", "Agdas"), (1662, 1015, "AGA", "Agstafa"), (1663, 1015, "AGU", "Agsu"), (1664, 1015, "AST", "Astara"), (1665, 1015, "BAB", "Babak"), (1666, 1015, "BAL", "Balakan"), (1667, 1015, "BAR", "Barda"), (1668, 1015, "BEY", "Beylagan"), (1669, 1015, "BIL", "Bilasuvar"), (1670, 1015, "CAB", "Cabrayll"), (1671, 1015, "CAL", "Calilabad"), (1672, 1015, "CUL", "Culfa"), (1673, 1015, "DAS", "Daskasan"), (1674, 1015, "DAV", "Davaci"), (1675, 1015, "FUZ", "Fuzuli"), (1676, 1015, "GAD", "Gadabay"), (1677, 1015, "GOR", "Goranboy"), (1678, 1015, "GOY", "Goycay"), (1679, 1015, "HAC", "Haciqabul"), (1680, 1015, "IMI", "Imisli"), (1681, 1015, "ISM", "Ismayilli"), (1682, 1015, "KAL", "Kalbacar"), (1683, 1015, "KUR", "Kurdamir"), (1684, 1015, "LAC", "Lacin"), (1685, 1015, "LER", "Lerik"), (1686, 1015, "MAS", "Masalli"), (1687, 1015, "NEF", "Neftcala"), (1688, 1015, "OGU", "Oguz"), (1689, 1015, "ORD", "Ordubad"), (1690, 1015, "QAB", "Qabala"), (1691, 1015, "QAX", "Qax"), (1692, 1015, "QAZ", "Qazax"), (1693, 1015, "QOB", "Qobustan"), (1694, 1015, "QBA", "Quba"), (1695, 1015, "QBI", "Qubadli"), (1696, 1015, "QUS", "Qusar"), (1697, 1015, "SAT", "Saatli"), (1698, 1015, "SAB", "Sabirabad"), (1699, 1015, "SAD", "Sadarak"), (1700, 1015, "SAH", "Sahbuz"), (1701, 1015, "SAL", "Salyan"), (1702, 1015, "SMI", "Samaxi"), (1703, 1015, "SKR", "Samkir"), (1704, 1015, "SMX", "Samux"), (1705, 1015, "SAR", "Sarur"), (1706, 1015, "SIY", "Siyazan"), (1707, 1015, "TAR", "Tartar"), (1708, 1015, "TOV", "Tovuz"), (1709, 1015, "UCA", "Ucar"), (1710, 1015, "XAC", "Xacmaz"), (1711, 1015, "XAN", "Xanlar"), (1712, 1015, "XIZ", "Xizi"), (1713, 1015, "XCI", "Xocali"), (1714, 1015, "XVD", "Xocavand"), (1715, 1015, "YAR", "Yardimli"), (1716, 1015, "ZAN", "Zangilan"), (1717, 1015, "ZAQ", "Zaqatala"), (1718, 1015, "ZAR", "Zardab"), (1719, 1026, "BIH", "Federacija Bosna i Hercegovina"), (1720, 1026, "SRP", "Republika Srpska"), (1721, 1017, "05", "Bagerhat zila"), (1722, 1017, "01", "Bandarban zila"), (1723, 1017, "02", "Barguna zila"), (1724, 1017, "06", "Barisal zila"), (1725, 1017, "07", "Bhola zila"), (1726, 1017, "03", "Bogra zila"), (1727, 1017, "04", "Brahmanbaria zila"), (1728, 1017, "09", "Chandpur zila"), (1729, 1017, "10", "Chittagong zila"), (1730, 1017, "12", "Chuadanga zila"), (1731, 1017, "08", "Comilla zila"), (1732, 1017, "11", "Cox\'s Bazar zila"), (1733, 1017, "13", "Dhaka zila"), (1734, 1017, "14", "Dinajpur zila"), (1735, 1017, "15", "Faridpur zila"), (1736, 1017, "16", "Feni zila"), (1737, 1017, "19", "Gaibandha zila"), (1738, 1017, "18", "Gazipur zila"), (1739, 1017, "17", "Gopalganj zila"), (1740, 1017, "20", "Habiganj zila"), (1741, 1017, "24", "Jaipurhat zila"), (1742, 1017, "21", "Jamalpur zila"), (1743, 1017, "22", "Jessore zila"), (1744, 1017, "25", "Jhalakati zila"), (1745, 1017, "23", "Jhenaidah zila"), (1746, 1017, "29", "Khagrachari zila"), (1747, 1017, "27", "Khulna zila"), (1748, 1017, "26", "Kishorganj zila"), (1749, 1017, "28", "Kurigram zila"), (1750, 1017, "30", "Kushtia zila"), (1751, 1017, "31", "Lakshmipur zila"), (1752, 1017, "32", "Lalmonirhat zila"), (1753, 1017, "36", "Madaripur zila"), (1754, 1017, "37", "Magura zila"), (1755, 1017, "33", "Manikganj zila"), (1756, 1017, "39", "Meherpur zila"), (1757, 1017, "38", "Moulvibazar zila"), (1758, 1017, "35", "Munshiganj zila"), (1759, 1017, "34", "Mymensingh zila"), (1760, 1017, "48", "Naogaon zila"), (1761, 1017, "43", "Narail zila"), (1762, 1017, "40", "Narayanganj zila"), (1763, 1017, "42", "Narsingdi zila"), (1764, 1017, "44", "Natore zila"), (1765, 1017, "45", "Nawabganj zila"), (1766, 1017, "41", "Netrakona zila"), (1767, 1017, "46", "Nilphamari zila"), (1768, 1017, "47", "Noakhali zila"), (1769, 1017, "49", "Pabna zila"), (1770, 1017, "52", "Panchagarh zila"), (1771, 1017, "51", "Patuakhali zila"), (1772, 1017, "50", "Pirojpur zila"), (1773, 1017, "53", "Rajbari zila"), (1774, 1017, "54", "Rajshahi zila"), (1775, 1017, "56", "Rangamati zila"), (1776, 1017, "55", "Rangpur zila"), (1777, 1017, "58", "Satkhira zila"), (1778, 1017, "62", "Shariatpur zila"), (1779, 1017, "57", "Sherpur zila"), (1780, 1017, "59", "Sirajganj zila"), (1781, 1017, "61", "Sunamganj zila"), (1782, 1017, "60", "Sylhet zila"), (1783, 1017, "63", "Tangail zila"), (1784, 1017, "64", "Thakurgaon zila"), (1785, 1020, "VAN", "Antwerpen"), (1786, 1020, "WBR", "Brabant Wallon"), (1787, 1020, "WHT", "Hainaut"), (1788, 1020, "WLG", "Liege"), (1789, 1020, "VLI", "Limburg"), (1790, 1020, "WLX", "Luxembourg"), (1791, 1020, "WNA", "Namur"), (1792, 1020, "VOV", "Oost-Vlaanderen"), (1793, 1020, "VBR", "Vlaams-Brabant"), (1794, 1020, "VWV", "West-Vlaanderen"), (1795, 1034, "BAL", "Bale"), (1796, 1034, "BAM", "Bam"), (1797, 1034, "BAN", "Banwa"), (1798, 1034, "BAZ", "Bazega"), (1799, 1034, "BGR", "Bougouriba"), (1800, 1034, "BLG", "Boulgou"), (1801, 1034, "BLK", "Boulkiemde"), (1802, 1034, "COM", "Comoe"), (1803, 1034, "GAN", "Ganzourgou"), (1804, 1034, "GNA", "Gnagna"), (1805, 1034, "GOU", "Gourma"), (1806, 1034, "HOU", "Houet"), (1807, 1034, "IOB", "Ioba"), (1808, 1034, "KAD", "Kadiogo"), (1809, 1034, "KEN", "Kenedougou"), (1810, 1034, "KMD", "Komondjari"), (1811, 1034, "KMP", "Kompienga"), (1812, 1034, "KOS", "Kossi"), (1813, 1034, "KOP", "Koulpulogo"), (1814, 1034, "KOT", "Kouritenga"), (1815, 1034, "KOW", "Kourweogo"), (1816, 1034, "LER", "Leraba"), (1817, 1034, "LOR", "Loroum"), (1818, 1034, "MOU", "Mouhoun"), (1819, 1034, "NAO", "Nahouri"), (1820, 1034, "NAM", "Namentenga"), (1821, 1034, "NAY", "Nayala"), (1822, 1034, "NOU", "Noumbiel"), (1823, 1034, "OUB", "Oubritenga"), (1824, 1034, "OUD", "Oudalan"), (1825, 1034, "PAS", "Passore"), (1826, 1034, "PON", "Poni"), (1827, 1034, "SNG", "Sanguie"), (1828, 1034, "SMT", "Sanmatenga"), (1829, 1034, "SEN", "Seno"), (1830, 1034, "SIS", "Siasili"), (1831, 1034, "SOM", "Soum"), (1832, 1034, "SOR", "Sourou"), (1833, 1034, "TAP", "Tapoa"), (1834, 1034, "TUI", "Tui"), (1835, 1034, "YAG", "Yagha"), (1836, 1034, "YAT", "Yatenga"), (1837, 1034, "ZIR", "Ziro"), (1838, 1034, "ZON", "Zondoma"), (1839, 1034, "ZOU", "Zoundweogo"), (1840, 1033, "01", "Blagoevgrad"), (1841, 1033, "02", "Burgas"), (1842, 1033, "08", "Dobric"), (1843, 1033, "07", "Gabrovo"), (1844, 1033, "26", "Haskovo"), (1845, 1033, "28", "Jambol"), (1846, 1033, "09", "Kardzali"), (1847, 1033, "10", "Kjstendil"), (1848, 1033, "11", "Lovec"), (1849, 1033, "12", "Montana"), (1850, 1033, "13", "Pazardzik"), (1851, 1033, "14", "Pernik"), (1852, 1033, "15", "Pleven"), (1853, 1033, "16", "Plovdiv"), (1854, 1033, "17", "Razgrad"), (1855, 1033, "18", "Ruse"), (1856, 1033, "19", "Silistra"), (1857, 1033, "20", "Sliven"), (1858, 1033, "21", "Smoljan"), (1859, 1033, "23", "Sofija"), (1860, 1033, "24", "Stara Zagora"), (1861, 1033, "27", "Sumen"), (1862, 1033, "25", "Targoviste"), (1863, 1033, "03", "Varna"), (1864, 1033, "04", "Veliko Tarnovo"), (1865, 1033, "05", "Vidin"), (1866, 1033, "06", "Vraca"), (1867, 1016, "01", "Al Hadd"), (1868, 1016, "03", "Al Manamah"), (1869, 1016, "10", "Al Mintaqah al Gharbiyah"), (1870, 1016, "07", "Al Mintagah al Wusta"), (1871, 1016, "05", "Al Mintaqah ash Shamaliyah"), (1872, 1016, "02", "Al Muharraq"), (1873, 1016, "09", "Ar Rifa"), (1874, 1016, "04", "Jidd Hafs"), (1875, 1016, "12", "Madluat Jamad"), (1876, 1016, "08", "Madluat Isa"), (1877, 1016, "11", "Mintaqat Juzur tawar"), (1878, 1016, "06", "Sitrah"), (1879, 1036, "BB", "Bubanza"), (1880, 1036, "BJ", "Bujumbura"), (1881, 1036, "BR", "Bururi"), (1882, 1036, "CA", "Cankuzo"), (1883, 1036, "CI", "Cibitoke"), (1884, 1036, "GI", "Gitega"), (1885, 1036, "KR", "Karuzi"), (1886, 1036, "KY", "Kayanza"), (1887, 1036, "MA", "Makamba"), (1888, 1036, "MU", "Muramvya"), (1889, 1036, "MW", "Mwaro"), (1890, 1036, "NG", "Ngozi"), (1891, 1036, "RT", "Rutana"), (1892, 1036, "RY", "Ruyigi"), (1893, 1022, "AL", "Alibori"), (1894, 1022, "AK", "Atakora"), (1895, 1022, "AQ", "Atlantique"), (1896, 1022, "BO", "Borgou"), (1897, 1022, "CO", "Collines"), (1898, 1022, "DO", "Donga"), (1899, 1022, "KO", "Kouffo"), (1900, 1022, "LI", "Littoral"), (1901, 1022, "MO", "Mono"), (1902, 1022, "OU", "Oueme"), (1903, 1022, "PL", "Plateau"), (1904, 1022, "ZO", "Zou"), (1905, 1032, "BE", "Belait"), (1906, 1032, "BM", "Brunei-Muara"), (1907, 1032, "TE", "Temburong"), (1908, 1032, "TU", "Tutong"), (1909, 1025, "C", "Cochabamba"), (1910, 1025, "H", "Chuquisaca"), (1911, 1025, "B", "El Beni"), (1912, 1025, "L", "La Paz"), (1913, 1025, "O", "Oruro"), (1914, 1025, "N", "Pando"), (1915, 1025, "P", "Potosi"), (1916, 1025, "T", "Tarija"), (1917, 1029, "AC", "Acre"), (1918, 1029, "AL", "Alagoas"), (1919, 1029, "AM", "Amazonas"), (1920, 1029, "AP", "Amapa"), (1921, 1029, "BA", "Baia"), (1922, 1029, "CE", "Ceara"), (1923, 1029, "DF", "Distrito Federal"), (1924, 1029, "ES", "Espirito Santo"), (1925, 1029, "FN", "Fernando de Noronha"), (1926, 1029, "GO", "Goias"), (1927, 1029, "MA", "Maranhao"), (1928, 1029, "MG", "Minas Gerais"), (1929, 1029, "MS", "Mato Grosso do Sul"), (1930, 1029, "MT", "Mato Grosso"), (1931, 1029, "PA", "Para"), (1932, 1029, "PB", "Paraiba"), (1933, 1029, "PE", "Pernambuco"), (1934, 1029, "PI", "Piaui"), (1935, 1029, "PR", "Parana"), (1936, 1029, "RJ", "Rio de Janeiro"), (1937, 1029, "RN", "Rio Grande do Norte"), (1938, 1029, "RO", "Rondonia"), (1939, 1029, "RR", "Roraima"), (1940, 1029, "RS", "Rio Grande do Sul"), (1941, 1029, "SC", "Santa Catarina"), (1942, 1029, "SE", "Sergipe"), (1943, 1029, "SP", "Sao Paulo"), (1944, 1029, "TO", "Tocatins"), (1945, 1212, "AC", "Acklins and Crooked Islands"), (1946, 1212, "BI", "Bimini"), (1947, 1212, "CI", "Cat Island"), (1948, 1212, "EX", "Exuma"), (1949, 1212, "FP", "Freeport"), (1950, 1212, "FC", "Fresh Creek"), (1951, 1212, "GH", "Governor\'s Harbour"), (1952, 1212, "GT", "Green Turtle Cay"), (1953, 1212, "HI", "Harbour Island"), (1954, 1212, "HR", "High Rock"), (1955, 1212, "IN", "Inagua"), (1956, 1212, "KB", "Kemps Bay"), (1957, 1212, "LI", "Long Island"), (1958, 1212, "MH", "Marsh Harbour"), (1959, 1212, "MG", "Mayaguana"), (1960, 1212, "NP", "New Providence"), (1961, 1212, "NB", "Nicholls Town and Berry Islands"), (1962, 1212, "RI", "Ragged Island"), (1963, 1212, "RS", "Rock Sound"), (1964, 1212, "SP", "Sandy Point"), (1965, 1212, "SR", "San Salvador and Rum Cay"), (1966, 1024, "33", "Bumthang"), (1967, 1024, "12", "Chhukha"), (1968, 1024, "22", "Dagana"), (1969, 1024, "GA", "Gasa"), (1970, 1024, "13", "Ha"), (1971, 1024, "44", "Lhuentse"), (1972, 1024, "42", "Monggar"), (1973, 1024, "11", "Paro"), (1974, 1024, "43", "Pemagatshel"), (1975, 1024, "23", "Punakha"), (1976, 1024, "45", "Samdrup Jongkha"), (1977, 1024, "14", "Samtee"), (1978, 1024, "31", "Sarpang"), (1979, 1024, "15", "Thimphu"), (1980, 1024, "41", "Trashigang"), (1981, 1024, "TY", "Trashi Yangtse"), (1982, 1024, "32", "Trongsa"), (1983, 1024, "21", "Tsirang"), (1984, 1024, "24", "Wangdue Phodrang"), (1985, 1024, "34", "Zhemgang"), (1986, 1027, "CE", "Central"), (1987, 1027, "GH", "Ghanzi"), (1988, 1027, "KG", "Kgalagadi"), (1989, 1027, "KL", "Kgatleng"), (1990, 1027, "KW", "Kweneng"), (1991, 1027, "NG", "Ngamiland"), (1992, 1027, "NE", "North-East"), (1993, 1027, "NW", "North-West"), (1994, 1027, "SE", "South-East"), (1995, 1027, "SO", "Southern"), (1996, 1019, "BR", "Brèsckaja voblasc\'"), (1997, 1019, "HO", "Homel\'skaja voblasc\'"), (1998, 1019, "HR", "Hrodzenskaja voblasc\'"), (1999, 1019, "MA", "Mahilëuskaja voblasc\'"), (2000, 1019, "MI", "Minskaja voblasc\'"), (2001, 1019, "VI", "Vicebskaja voblasc\'"), (2002, 1021, "BZ", "Belize"), (2003, 1021, "CY", "Cayo"), (2004, 1021, "CZL", "Corozal"), (2005, 1021, "OW", "Orange Walk"), (2006, 1021, "SC", "Stann Creek"), (2007, 1021, "TOL", "Toledo"), (2008, 1050, "KN", "Kinshasa"), (2009, 1050, "BN", "Bandundu"), (2010, 1050, "BC", "Bas-Congo"), (2011, 1050, "EQ", "Equateur"), (2012, 1050, "HC", "Haut-Congo"), (2013, 1050, "KW", "Kasai-Occidental"), (2014, 1050, "KE", "Kasai-Oriental"), (2015, 1050, "KA", "Katanga"), (2016, 1050, "MA", "Maniema"), (2017, 1050, "NK", "Nord-Kivu"), (2018, 1050, "OR", "Orientale"), (2019, 1050, "SK", "Sud-Kivu"), (2020, 1042, "BGF", "Bangui"), (2021, 1042, "BB", "Bamingui-Bangoran"), (2022, 1042, "BK", "Basse-Kotto"), (2023, 1042, "HK", "Haute-Kotto"), (2024, 1042, "HM", "Haut-Mbomou"), (2025, 1042, "KG", "Kemo"), (2026, 1042, "LB", "Lobaye"), (2027, 1042, "HS", "Mambere-Kadei"), (2028, 1042, "MB", "Mbomou"), (2029, 1042, "KB", "Nana-Grebizi"), (2030, 1042, "NM", "Nana-Mambere"), (2031, 1042, "MP", "Ombella-Mpoko"), (2032, 1042, "UK", "Ouaka"), (2033, 1042, "AC", "Ouham"), (2034, 1042, "OP", "Ouham-Pende"), (2035, 1042, "SE", "Sangha-Mbaere"), (2036, 1042, "VR", "Vakaga"), (2037, 1051, "BZV", "Brazzaville"), (2038, 1051, "11", "Bouenza"), (2039, 1051, "8", "Cuvette"), (2040, 1051, "15", "Cuvette-Ouest"), (2041, 1051, "5", "Kouilou"), (2042, 1051, "2", "Lekoumou"), (2043, 1051, "7", "Likouala"), (2044, 1051, "9", "Niari"), (2045, 1051, "14", "Plateaux"), (2046, 1051, "12", "Pool"), (2047, 1051, "13", "Sangha"), (2048, 1205, "AG", "Aargau"), (2049, 1205, "AI", "Appenzell Innerrhoden"), (2050, 1205, "AR", "Appenzell Ausserrhoden"), (2051, 1205, "BE", "Bern"), (2052, 1205, "BL", "Basel-Landschaft"), (2053, 1205, "BS", "Basel-Stadt"), (2054, 1205, "FR", "Fribourg"), (2055, 1205, "GE", "Geneva"), (2056, 1205, "GL", "Glarus"), (2057, 1205, "GR", "Graubunden"), (2058, 1205, "JU", "Jura"), (2059, 1205, "LU", "Luzern"), (2060, 1205, "NE", "Neuchatel"), (2061, 1205, "NW", "Nidwalden"), (2062, 1205, "OW", "Obwalden"), (2063, 1205, "SG", "Sankt Gallen"), (2064, 1205, "SH", "Schaffhausen"), (2065, 1205, "SO", "Solothurn"), (2066, 1205, "SZ", "Schwyz"), (2067, 1205, "TG", "Thurgau"), (2068, 1205, "TI", "Ticino"), (2069, 1205, "UR", "Uri"), (2070, 1205, "VD", "Vaud"), (2071, 1205, "VS", "Valais"), (2072, 1205, "ZG", "Zug"), (2073, 1205, "ZH", "Zurich"), (2074, 1054, "06", "18 Montagnes"), (2075, 1054, "16", "Agnebi"), (2076, 1054, "09", "Bas-Sassandra"), (2077, 1054, "10", "Denguele"), (2078, 1054, "02", "Haut-Sassandra"), (2079, 1054, "07", "Lacs"), (2080, 1054, "01", "Lagunes"), (2081, 1054, "12", "Marahoue"), (2082, 1054, "05", "Moyen-Comoe"), (2083, 1054, "11", "Nzi-Comoe"), (2084, 1054, "03", "Savanes"), (2085, 1054, "15", "Sud-Bandama"), (2086, 1054, "13", "Sud-Comoe"), (2087, 1054, "04", "Vallee du Bandama"), (2088, 1054, "14", "Worodouqou"), (2089, 1054, "08", "Zanzan"), (2090, 1044, "AI", "Aisen del General Carlos Ibanez del Campo"), (2091, 1044, "AN", "Antofagasta"), (2092, 1044, "AR", "Araucania"), (2093, 1044, "AT", "Atacama"), (2094, 1044, "BI", "Bio-Bio"), (2095, 1044, "CO", "Coquimbo"), (2096, 1044, "LI", "Libertador General Bernardo O\'Higgins"), (2097, 1044, "LL", "Los Lagos"), (2098, 1044, "MA", "Magallanes"), (2099, 1044, "ML", "Maule"), (2100, 1044, "RM", "Region Metropolitana de Santiago"), (2101, 1044, "TA", "Tarapaca"), (2102, 1044, "VS", "Valparaiso"), (2103, 1038, "AD", "Adamaoua"), (2104, 1038, "CE", "Centre"), (2105, 1038, "ES", "East"), (2106, 1038, "EN", "Far North"), (2107, 1038, "NO", "North"), (2108, 1038, "SW", "South"), (2109, 1038, "SW", "South-West"), (2110, 1038, "OU", "West"), (2111, 1045, "11", "Beijing"), (2112, 1045, "50", "Chongqing"), (2113, 1045, "31", "Shanghai"), (2114, 1045, "12", "Tianjin"), (2115, 1045, "34", "Anhui"), (2116, 1045, "35", "Fujian"), (2117, 1045, "62", "Gansu"), (2118, 1045, "44", "Guangdong"), (2119, 1045, "52", "Gulzhou"), (2120, 1045, "46", "Hainan"), (2121, 1045, "13", "Hebei"), (2122, 1045, "23", "Heilongjiang"), (2123, 1045, "41", "Henan"), (2124, 1045, "42", "Hubei"), (2125, 1045, "43", "Hunan"), (2126, 1045, "32", "Jiangsu"), (2127, 1045, "36", "Jiangxi"), (2128, 1045, "22", "Jilin"), (2129, 1045, "21", "Liaoning"), (2130, 1045, "63", "Qinghai"), (2131, 1045, "61", "Shaanxi"), (2132, 1045, "37", "Shandong"), (2133, 1045, "14", "Shanxi"), (2134, 1045, "51", "Sichuan"), (2135, 1045, "71", "Taiwan"), (2136, 1045, "53", "Yunnan"), (2137, 1045, "33", "Zhejiang"), (2138, 1045, "45", "Guangxi"), (2139, 1045, "15", "Neia Mongol (mn)"), (2140, 1045, "65", "Xinjiang"), (2141, 1045, "54", "Xizang"), (2142, 1045, "91", "Hong Kong"), (2143, 1045, "92", "Macau"), (2144, 1048, "DC", "Distrito Capital de Bogotá"), (2145, 1048, "AMA", "Amazonea"), (2146, 1048, "ANT", "Antioquia"), (2147, 1048, "ARA", "Arauca"), (2148, 1048, "ATL", "Atlántico"), (2149, 1048, "BOL", "Bolívar"), (2150, 1048, "BOY", "Boyacá"), (2151, 1048, "CAL", "Caldea"), (2152, 1048, "CAQ", "Caquetá"), (2153, 1048, "CAS", "Casanare"), (2154, 1048, "CAU", "Cauca"), (2155, 1048, "CES", "Cesar"), (2156, 1048, "COR", "Córdoba"), (2157, 1048, "CUN", "Cundinamarca"), (2158, 1048, "CHO", "Chocó"), (2159, 1048, "GUA", "Guainía"), (2160, 1048, "GUV", "Guaviare"), (2161, 1048, "LAG", "La Guajira"), (2162, 1048, "MAG", "Magdalena"), (2163, 1048, "MET", "Meta"), (2164, 1048, "NAR", "Nariño"), (2165, 1048, "NSA", "Norte de Santander"), (2166, 1048, "PUT", "Putumayo"), (2167, 1048, "QUI", "Quindio"), (2168, 1048, "RIS", "Risaralda"), (2169, 1048, "SAP", "San Andrés, Providencia y Santa Catalina"), (2170, 1048, "SAN", "Santander"), (2171, 1048, "SUC", "Sucre"), (2172, 1048, "TOL", "Tolima"), (2173, 1048, "VAC", "Valle del Cauca"), (2174, 1048, "VAU", "Vaupés"), (2175, 1048, "VID", "Vichada"), (2176, 1053, "A", "Alajuela"), (2177, 1053, "C", "Cartago"), (2178, 1053, "G", "Guanacaste"), (2179, 1053, "H", "Heredia"), (2180, 1053, "L", "Limon"), (2181, 1053, "P", "Puntarenas"), (2182, 1053, "SJ", "San Jose"), (2183, 1056, "09", "Camagey"), (2184, 1056, "08", "Ciego de `vila"), (2185, 1056, "06", "Cienfuegos"), (2186, 1056, "03", "Ciudad de La Habana"), (2187, 1056, "12", "Granma"), (2188, 1056, "14", "Guantanamo"), (2189, 1056, "11", "Holquin"), (2190, 1056, "02", "La Habana"), (2191, 1056, "10", "Las Tunas"), (2192, 1056, "04", "Matanzas"), (2193, 1056, "01", "Pinar del Rio"), (2194, 1056, "07", "Sancti Spiritus"), (2195, 1056, "13", "Santiago de Cuba"), (2196, 1056, "05", "Villa Clara"), (2197, 1056, "99", "Isla de la Juventud"), (2198, 1056, "PR", "Pinar del Roo"), (2199, 1056, "CA", "Ciego de Avila"), (2200, 1056, "CG", "Camagoey"), (2201, 1056, "HO", "Holgun"), (2202, 1056, "SS", "Sancti Spritus"), (2203, 1056, "IJ", "Municipio Especial Isla de la Juventud"), (2204, 1040, "BV", "Boa Vista"), (2205, 1040, "BR", "Brava"), (2206, 1040, "CS", "Calheta de Sao Miguel"), (2207, 1040, "FO", "Fogo"), (2208, 1040, "MA", "Maio"), (2209, 1040, "MO", "Mosteiros"), (2210, 1040, "PA", "Paul"), (2211, 1040, "PN", "Porto Novo"), (2212, 1040, "PR", "Praia"), (2213, 1040, "RG", "Ribeira Grande"), (2214, 1040, "SL", "Sal"), (2215, 1040, "SD", "Sao Domingos"), (2216, 1040, "SF", "Sao Filipe"), (2217, 1040, "SN", "Sao Nicolau"), (2218, 1040, "SV", "Sao Vicente"), (2219, 1040, "TA", "Tarrafal"), (2220, 1057, "04", "Ammochostos Magusa"), (2221, 1057, "06", "Keryneia"), (2222, 1057, "03", "Larnaka"), (2223, 1057, "01", "Lefkosia"), (2224, 1057, "02", "Lemesos"), (2225, 1057, "05", "Pafos"), (2226, 1058, "JC", "Jihočeský kraj"), (2227, 1058, "JM", "Jihomoravský kraj"), (2228, 1058, "KA", "Karlovarský kraj"), (2229, 1058, "KR", "Královéhradecký kraj"), (2230, 1058, "LI", "Liberecký kraj"), (2231, 1058, "MO", "Moravskoslezský kraj"), (2232, 1058, "OL", "Olomoucký kraj"), (2233, 1058, "PA", "Pardubický kraj"), (2234, 1058, "PL", "Plzeňský kraj"), (2235, 1058, "PR", "Praha, hlavní město"), (2236, 1058, "ST", "Středočeský kraj"), (2237, 1058, "US", "Ústecký kraj"), (2238, 1058, "VY", "Vysočina"), (2239, 1058, "ZL", "Zlínský kraj"), (2240, 1082, "BW", "Baden-Wuerttemberg"), (2241, 1082, "BY", "Bayern"), (2242, 1082, "HB", "Bremen"), (2243, 1082, "HH", "Hamburg"), (2244, 1082, "HE", "Hessen"), (2245, 1082, "NI", "Niedersachsen"), (2246, 1082, "NW", "Nordrhein-Westfalen"), (2247, 1082, "RP", "Rheinland-Pfalz"), (2248, 1082, "SL", "Saarland"), (2249, 1082, "SH", "Schleswig-Holstein"), (2250, 1082, "BR", "Berlin"), (2251, 1082, "BB", "Brandenburg"), (2252, 1082, "MV", "Mecklenburg-Vorpommern"), (2253, 1082, "SN", "Sachsen"), (2254, 1082, "ST", "Sachsen-Anhalt"), (2255, 1082, "TH", "Thueringen"), (2256, 1060, "AS", "Ali Sabiah"), (2257, 1060, "DI", "Dikhil"), (2258, 1060, "DJ", "Djibouti"), (2259, 1060, "OB", "Obock"), (2260, 1060, "TA", "Tadjoura"), (2261, 1059, "147", "Frederikaberg municipality"), (2262, 1059, "101", "Copenhagen municipality"), (2263, 1059, "015", "Copenhagen"), (2264, 1059, "020", "Frederiksborg"), (2265, 1059, "025", "Roskilde"), (2266, 1059, "030", "Western Zealand"), (2267, 1059, "035", "Storstrøm"), (2268, 1059, "040", "Bornholm"), (2269, 1059, "042", "Funen"), (2270, 1059, "050", "Southern Jutland"), (2271, 1059, "055", "Ribe"), (2272, 1059, "060", "Vejle"), (2273, 1059, "065", "Ringkøbing"), (2274, 1059, "070", "Aarhus"), (2275, 1059, "076", "Viborg"), (2276, 1059, "080", "Northern Jutland"), (2277, 1062, "01", "Distrito Nacional (Santo Domingo)"), (2278, 1062, "02", "Azua"), (2279, 1062, "03", "Bahoruco"), (2280, 1062, "04", "Barahona"), (2281, 1062, "05", "Dajabón"), (2282, 1062, "06", "Duarte"), (2283, 1062, "08", "El Seybo [El Seibo]"), (2284, 1062, "09", "Espaillat"), (2285, 1062, "30", "Hato Mayor"), (2286, 1062, "10", "Independencia"), (2287, 1062, "11", "La Altagracia"), (2288, 1062, "07", "La Estrelleta [Elias Pina]"), (2289, 1062, "12", "La Romana"), (2290, 1062, "13", "La Vega"), (2291, 1062, "14", "Maroia Trinidad Sánchez"), (2292, 1062, "28", "Monseñor Nouel"), (2293, 1062, "15", "Monte Cristi"), (2294, 1062, "29", "Monte Plata"), (2295, 1062, "16", "Pedernales"), (2296, 1062, "17", "Peravia"), (2297, 1062, "18", "Puerto Plata"), (2298, 1062, "19", "Salcedo"), (2299, 1062, "20", "Samaná"), (2300, 1062, "21", "San Cristóbal"), (2301, 1062, "23", "San Pedro de Macorís"), (2302, 1062, "24", "Sánchez Ramírez"), (2303, 1062, "25", "Santiago"), (2304, 1062, "26", "Santiago Rodríguez"), (2305, 1062, "27", "Valverde"), (2306, 1003, "01", "Adrar"), (2307, 1003, "44", "Ain Defla"), (2308, 1003, "46", "Ain Tmouchent"), (2309, 1003, "16", "Alger"), (2310, 1003, "23", "Annaba"), (2311, 1003, "05", "Batna"), (2312, 1003, "08", "Bechar"), (2313, 1003, "06", "Bejaia"), (2314, 1003, "07", "Biskra"), (2315, 1003, "09", "Blida"), (2316, 1003, "34", "Bordj Bou Arreridj"), (2317, 1003, "10", "Bouira"), (2318, 1003, "35", "Boumerdes"), (2319, 1003, "02", "Chlef"), (2320, 1003, "25", "Constantine"), (2321, 1003, "17", "Djelfa"), (2322, 1003, "32", "El Bayadh"), (2323, 1003, "39", "El Oued"), (2324, 1003, "36", "El Tarf"), (2325, 1003, "47", "Ghardaia"), (2326, 1003, "24", "Guelma"), (2327, 1003, "33", "Illizi"), (2328, 1003, "18", "Jijel"), (2329, 1003, "40", "Khenchela"), (2330, 1003, "03", "Laghouat"), (2331, 1003, "29", "Mascara"), (2332, 1003, "26", "Medea"), (2333, 1003, "43", "Mila"), (2334, 1003, "27", "Mostaganem"), (2335, 1003, "28", "Msila"), (2336, 1003, "45", "Naama"), (2337, 1003, "31", "Oran"), (2338, 1003, "30", "Ouargla"), (2339, 1003, "04", "Oum el Bouaghi"), (2340, 1003, "48", "Relizane"), (2341, 1003, "20", "Saida"), (2342, 1003, "19", "Setif"), (2343, 1003, "22", "Sidi Bel Abbes"), (2344, 1003, "21", "Skikda"), (2345, 1003, "41", "Souk Ahras"), (2346, 1003, "11", "Tamanghasset"), (2347, 1003, "12", "Tebessa"), (2348, 1003, "14", "Tiaret"), (2349, 1003, "37", "Tindouf"), (2350, 1003, "42", "Tipaza"), (2351, 1003, "38", "Tissemsilt"), (2352, 1003, "15", "Tizi Ouzou"), (2353, 1003, "13", "Tlemcen"), (2354, 1064, "A", "Azuay"), (2355, 1064, "B", "Bolivar"), (2356, 1064, "F", "Canar"), (2357, 1064, "C", "Carchi"), (2358, 1064, "X", "Cotopaxi"), (2359, 1064, "H", "Chimborazo"), (2360, 1064, "O", "El Oro"), (2361, 1064, "E", "Esmeraldas"), (2362, 1064, "W", "Galapagos"), (2363, 1064, "G", "Guayas"), (2364, 1064, "I", "Imbabura"), (2365, 1064, "L", "Loja"), (2366, 1064, "R", "Los Rios"), (2367, 1064, "M", "Manabi"), (2368, 1064, "S", "Morona-Santiago"), (2369, 1064, "N", "Napo"), (2370, 1064, "D", "Orellana"), (2371, 1064, "Y", "Pastaza"), (2372, 1064, "P", "Pichincha"), (2373, 1064, "U", "Sucumbios"), (2374, 1064, "T", "Tungurahua"), (2375, 1064, "Z", "Zamora-Chinchipe"), (2376, 1069, "37", "Harjumsa"), (2377, 1069, "39", "Hitumea"), (2378, 1069, "44", "Ida-Virumsa"), (2379, 1069, "49", "Jogevamsa"), (2380, 1069, "51", "Jarvamsa"), (2381, 1069, "57", "Lasnemsa"), (2382, 1069, "59", "Laane-Virumaa"), (2383, 1069, "65", "Polvamea"), (2384, 1069, "67", "Parnumsa"), (2385, 1069, "70", "Raplamsa"), (2386, 1069, "74", "Saaremsa"), (2387, 1069, "7B", "Tartumsa"), (2388, 1069, "82", "Valgamaa"), (2389, 1069, "84", "Viljandimsa"), (2390, 1069, "86", "Vorumaa"), (2391, 1065, "DK", "Ad Daqahllyah"), (2392, 1065, "BA", "Al Bahr al Ahmar"), (2393, 1065, "BH", "Al Buhayrah"), (2394, 1065, "FYM", "Al Fayym"), (2395, 1065, "GH", "Al Gharbiyah"), (2396, 1065, "ALX", "Al Iskandarlyah"), (2397, 1065, "IS", "Al Isma illyah"), (2398, 1065, "GZ", "Al Jizah"), (2399, 1065, "MNF", "Al Minuflyah"), (2400, 1065, "MN", "Al Minya"), (2401, 1065, "C", "Al Qahirah"), (2402, 1065, "KB", "Al Qalyublyah"), (2403, 1065, "WAD", "Al Wadi al Jadid"), (2404, 1065, "SHR", "Ash Sharqiyah"), (2405, 1065, "SUZ", "As Suways"), (2406, 1065, "ASN", "Aswan"), (2407, 1065, "AST", "Asyut"), (2408, 1065, "BNS", "Bani Suwayf"), (2409, 1065, "PTS", "Bur Sa\'id"), (2410, 1065, "DT", "Dumyat"), (2411, 1065, "JS", "Janub Sina\'"), (2412, 1065, "KFS", "Kafr ash Shaykh"), (2413, 1065, "MT", "Matruh"), (2414, 1065, "KN", "Qina"), (2415, 1065, "SIN", "Shamal Sina\'"), (2416, 1065, "SHG", "Suhaj"), (2417, 1068, "AN", "Anseba"), (2418, 1068, "DU", "Debub"), (2419, 1068, "DK", "Debubawi Keyih Bahri [Debub-Keih-Bahri]"), (2420, 1068, "GB", "Gash-Barka"), (2421, 1068, "MA", "Maakel [Maekel]"), (2422, 1068, "SK", "Semenawi Keyih Bahri [Semien-Keih-Bahri]"), (2423, 1198, "VI", "Álava"), (2424, 1198, "AB", "Albacete"), (2425, 1198, "A", "Alicante"), (2426, 1198, "AL", "Almería"), (2427, 1198, "O", "Asturias"), (2428, 1198, "AV", "Ávila"), (2429, 1198, "BA", "Badajoz"), (2430, 1198, "PM", "Baleares"), (2431, 1198, "B", "Barcelona"), (2432, 1198, "BU", "Burgos"), (2433, 1198, "CC", "Cáceres"), (2434, 1198, "CA", "Cádiz"), (2435, 1198, "S", "Cantabria"), (2436, 1198, "CS", "Castellón"), (2437, 1198, "CR", "Ciudad Real"), (2438, 1198, "CU", "Cuenca"), (2439, 1198, "GE", "Girona [Gerona]"), (2440, 1198, "GR", "Granada"), (2441, 1198, "GU", "Guadalajara"), (2442, 1198, "SS", "Guipúzcoa"), (2443, 1198, "H", "Huelva"), (2444, 1198, "HU", "Huesca"), (2445, 1198, "J", "Jaén"), (2446, 1198, "C", "La Coruña"), (2447, 1198, "LO", "La Rioja"), (2448, 1198, "GC", "Las Palmas"), (2449, 1198, "LE", "León"), (2450, 1198, "L", "Lleida [Lérida]"), (2451, 1198, "LU", "Lugo"), (2452, 1198, "M", "Madrid"), (2453, 1198, "MA", "Málaga"), (2454, 1198, "MU", "Murcia"), (2455, 1198, "NA", "Navarra"), (2456, 1198, "OR", "Ourense"), (2457, 1198, "P", "Palencia"), (2458, 1198, "PO", "Pontevedra"), (2459, 1198, "SA", "Salamanca"), (2460, 1198, "TF", "Santa Cruz de Tenerife"), (2461, 1198, "SG", "Segovia"), (2462, 1198, "SE", "Sevilla"), (2463, 1198, "SO", "Soria"), (2464, 1198, "T", "Tarragona"), (2465, 1198, "TE", "Teruel"), (2466, 1198, "V", "Valencia"), (2467, 1198, "VA", "Valladolid"), (2468, 1198, "BI", "Vizcaya"), (2469, 1198, "ZA", "Zamora"), (2470, 1198, "Z", "Zaragoza"), (2471, 1198, "CE", "Ceuta"), (2472, 1198, "ML", "Melilla"), (2473, 1070, "AA", "Addis Ababa"), (2474, 1070, "DD", "Dire Dawa"), (2475, 1070, "AF", "Afar"), (2476, 1070, "AM", "Amara"), (2477, 1070, "BE", "Benshangul-Gumaz"), (2478, 1070, "GA", "Gambela Peoples"), (2479, 1070, "HA", "Harari People"), (2480, 1070, "OR", "Oromia"), (2481, 1070, "SO", "Somali"), (2482, 1070, "SN", "Southern Nations, Nationalities and Peoples"), (2483, 1070, "TI", "Tigrai"), (2484, 1075, "AL", "Ahvenanmasn laani"), (2485, 1075, "ES", "Etela-Suomen laani"), (2486, 1075, "IS", "Ita-Suomen lasni"), (2487, 1075, "LL", "Lapin Laani"), (2488, 1075, "LS", "Lansi-Suomen Laani"), (2489, 1075, "OL", "Oulun Lasni"), (2490, 1074, "E", "Eastern"), (2491, 1074, "N", "Northern"), (2492, 1074, "W", "Western"), (2493, 1074, "R", "Rotuma"), (2494, 1141, "TRK", "Chuuk"), (2495, 1141, "KSA", "Kosrae"), (2496, 1141, "PNI", "Pohnpei"), (2497, 1141, "YAP", "Yap"), (2498, 1076, "01", "Ain"), (2499, 1076, "02", "Aisne"), (2500, 1076, "03", "Allier"), (2501, 1076, "04", "Alpes-de-Haute-Provence"), (2502, 1076, "06", "Alpes-Maritimes"), (2503, 1076, "07", "Ardèche"), (2504, 1076, "08", "Ardennes"), (2505, 1076, "09", "Ariège"), (2506, 1076, "10", "Aube"), (2507, 1076, "11", "Aude"), (2508, 1076, "12", "Aveyron"), (2509, 1076, "67", "Bas-Rhin"), (2510, 1076, "13", "Bouches-du-Rhône"), (2511, 1076, "14", "Calvados"), (2512, 1076, "15", "Cantal"), (2513, 1076, "16", "Charente"), (2514, 1076, "17", "Charente-Maritime"), (2515, 1076, "18", "Cher"), (2516, 1076, "19", "Corrèze"), (2517, 1076, "20A", "Corse-du-Sud"), (2518, 1076, "21", "Côte-d\'Or"), (2519, 1076, "22", "Côtes-d\'Armor"), (2520, 1076, "23", "Creuse"), (2521, 1076, "79", "Deux-Sèvres"), (2522, 1076, "24", "Dordogne"), (2523, 1076, "25", "Doubs"), (2524, 1076, "26", "Drôme"), (2525, 1076, "91", "Essonne"), (2526, 1076, "27", "Eure"), (2527, 1076, "28", "Eure-et-Loir"), (2528, 1076, "29", "Finistère"), (2529, 1076, "30", "Gard"), (2530, 1076, "32", "Gers"), (2531, 1076, "33", "Gironde"), (2532, 1076, "68", "Haut-Rhin"), (2533, 1076, "20B", "Haute-Corse"), (2534, 1076, "31", "Haute-Garonne"), (2535, 1076, "43", "Haute-Loire"), (2536, 1076, "70", "Haute-Saône"), (2537, 1076, "74", "Haute-Savoie"), (2538, 1076, "87", "Haute-Vienne"), (2539, 1076, "05", "Hautes-Alpes"), (2540, 1076, "65", "Hautes-Pyrénées"), (2541, 1076, "92", "Hauts-de-Seine"), (2542, 1076, "34", "Hérault"), (2543, 1076, "35", "Indre"), (2544, 1076, "36", "Ille-et-Vilaine"), (2545, 1076, "37", "Indre-et-Loire"), (2546, 1076, "38", "Isère"), (2547, 1076, "40", "Landes"), (2548, 1076, "41", "Loir-et-Cher"), (2549, 1076, "42", "Loire"), (2550, 1076, "44", "Loire-Atlantique"), (2551, 1076, "45", "Loiret"), (2552, 1076, "46", "Lot"), (2553, 1076, "47", "Lot-et-Garonne"), (2554, 1076, "48", "Lozère"), (2555, 1076, "49", "Maine-et-Loire"), (2556, 1076, "50", "Manche"), (2557, 1076, "51", "Marne"), (2558, 1076, "53", "Mayenne"), (2559, 1076, "54", "Meurthe-et-Moselle"), (2560, 1076, "55", "Meuse"), (2561, 1076, "56", "Morbihan"), (2562, 1076, "57", "Moselle"), (2563, 1076, "58", "Nièvre"), (2564, 1076, "59", "Nord"), (2565, 1076, "60", "Oise"), (2566, 1076, "61", "Orne"), (2567, 1076, "75", "Paris"), (2568, 1076, "62", "Pas-de-Calais"), (2569, 1076, "63", "Puy-de-Dôme"), (2570, 1076, "64", "Pyrénées-Atlantiques"), (2571, 1076, "66", "Pyrénées-Orientales"), (2572, 1076, "69", "Rhône"), (2573, 1076, "71", "Saône-et-Loire"), (2574, 1076, "72", "Sarthe"), (2575, 1076, "73", "Savoie"), (2576, 1076, "77", "Seine-et-Marne"), (2577, 1076, "76", "Seine-Maritime"), (2578, 1076, "93", "Seine-Saint-Denis"), (2579, 1076, "80", "Somme"), (2580, 1076, "81", "Tarn"), (2581, 1076, "82", "Tarn-et-Garonne"), (2582, 1076, "95", "Val d\'Oise"), (2583, 1076, "90", "Territoire de Belfort"), (2584, 1076, "94", "Val-de-Marne"), (2585, 1076, "83", "Var"), (2586, 1076, "84", "Vaucluse"), (2587, 1076, "85", "Vendée"), (2588, 1076, "86", "Vienne"), (2589, 1076, "88", "Vosges"), (2590, 1076, "89", "Yonne"), (2591, 1076, "78", "Yvelines"), (2592, 1226, "ABE", "Aberdeen City"), (2593, 1226, "ABD", "Aberdeenshire"), (2594, 1226, "ANS", "Angus"), (2595, 1226, "ANT", "Antrim"), (2596, 1226, "ARD", "Ards"), (2597, 1226, "AGB", "Argyll and Bute"), (2598, 1226, "ARM", "Armagh"), (2599, 1226, "BLA", "Ballymena"), (2600, 1226, "BLY", "Ballymoney"), (2601, 1226, "BNB", "Banbridge"), (2602, 1226, "BDG", "Barking and Dagenham"), (2603, 1226, "BNE", "Barnet"), (2604, 1226, "BNS", "Barnsley"), (2605, 1226, "BAS", "Bath and North East Somerset"), (2606, 1226, "BDF", "Bedfordshire"), (2607, 1226, "BFS", "Belfast"), (2608, 1226, "BEX", "Bexley"), (2609, 1226, "BIR", "Birmingham"), (2610, 1226, "BBD", "Blackburn with Darwen"), (2611, 1226, "BPL", "Blackpool"), (2612, 1226, "BGW", "Blaenau Gwent"), (2613, 1226, "BOL", "Bolton"), (2614, 1226, "BMH", "Bournemouth"), (2615, 1226, "BRC", "Bracknell Forest"), (2616, 1226, "BRD", "Bradford"), (2617, 1226, "BEN", "Brent"), (2618, 1226, "BGE", "Bridgend"), (2619, 1226, "BNH", "Brighton and Hove"), (2620, 1226, "BST", "Bristol, City of"), (2621, 1226, "BRY", "Bromley"), (2622, 1226, "BKM", "Buckinghamshire"), (2623, 1226, "BUR", "Bury"), (2624, 1226, "CAY", "Caerphilly"), (2625, 1226, "CLD", "Calderdale"), (2626, 1226, "CAM", "Cambridgeshire"), (2627, 1226, "CMD", "Camden"), (2628, 1226, "CRF", "Cardiff"), (2629, 1226, "CMN", "Carmarthenshire"), (2630, 1226, "GFY", "Sir Gaerfyrddin"), (2631, 1226, "CKF", "Carrickfergus"), (2632, 1226, "CSR", "Castlereagh"), (2633, 1226, "CGN", "Ceredigion"), (2634, 1226, "CHS", "Cheshire"), (2635, 1226, "CLK", "Clackmannanshire"), (2636, 1226, "CLR", "Coleraine"), (2637, 1226, "CWY", "Conwy"), (2638, 1226, "CKT", "Cookstown"), (2639, 1226, "CON", "Cornwall"), (2640, 1226, "COV", "Coventry"), (2641, 1226, "CGV", "Cralgavon"), (2642, 1226, "CRY", "Croydon"), (2643, 1226, "CMA", "Cumbria"), (2644, 1226, "DAL", "Darlington"), (2645, 1226, "DEN", "Denbighshire"), (2646, 1226, "DER", "Derby"), (2647, 1226, "DBY", "Derbyshire"), (2648, 1226, "DRY", "Derry"), (2649, 1226, "DEV", "Devon"), (2650, 1226, "DNC", "Doncaster"), (2651, 1226, "DOR", "Dorset"), (2652, 1226, "DOW", "Down"), (2653, 1226, "DUD", "Dudley"), (2654, 1226, "DGY", "Dumfries and Galloway"), (2655, 1226, "DND", "Dundee City"), (2656, 1226, "DGN", "Dungannon"), (2657, 1226, "DUR", "Durham"), (2658, 1226, "EAL", "Ealing"), (2659, 1226, "EAY", "East Ayrshire"), (2660, 1226, "EDU", "East Dunbartonshire"), (2661, 1226, "ELN", "East Lothian"), (2662, 1226, "ERW", "East Renfrewshire"), (2663, 1226, "ERY", "East Riding of Yorkshire"), (2664, 1226, "ESX", "East Sussex"), (2665, 1226, "EDH", "Edinburgh, City of"), (2666, 1226, "ELS", "Eilean Siar"), (2667, 1226, "ENF", "Enfield"), (2668, 1226, "ESS", "Essex"), (2669, 1226, "FAL", "Falkirk"), (2670, 1226, "FER", "Fermanagh"), (2671, 1226, "FIF", "Fife"), (2672, 1226, "FLN", "Flintshire"), (2673, 1226, "GAT", "Gateshead"), (2674, 1226, "GLG", "Glasgow City"), (2675, 1226, "GLS", "Gloucestershire"), (2676, 1226, "GRE", "Greenwich"), (2677, 1226, "GSY", "Guernsey"), (2678, 1226, "GWN", "Gwynedd"), (2679, 1226, "HCK", "Hackney"), (2680, 1226, "HAL", "Halton"), (2681, 1226, "HMF", "Hammersmith and Fulham"), (2682, 1226, "HAM", "Hampshire"), (2683, 1226, "HRY", "Haringey"), (2684, 1226, "HRW", "Harrow"), (2685, 1226, "HPL", "Hartlepool"), (2686, 1226, "HAV", "Havering"), (2687, 1226, "HEF", "Herefordshire, County of"), (2688, 1226, "HRT", "Hertfordshire"), (2689, 1226, "HED", "Highland"), (2690, 1226, "HIL", "Hillingdon"), (2691, 1226, "HNS", "Hounslow"), (2692, 1226, "IVC", "Inverclyde"), (2693, 1226, "AGY", "Isle of Anglesey"), (2694, 1226, "IOW", "Isle of Wight"), (2695, 1226, "IOS", "Isles of Scilly"), (2696, 1226, "ISL", "Islington"), (2697, 1226, "JSY", "Jersey"), (2698, 1226, "KEC", "Kensington and Chelsea"), (2699, 1226, "KEN", "Kent"), (2700, 1226, "KHL", "Kingston upon Hull, City of"), (2701, 1226, "KTT", "Kingston upon Thames"), (2702, 1226, "KIR", "Kirklees"), (2703, 1226, "KWL", "Knowsley"), (2704, 1226, "LBH", "Lambeth"), (2705, 1226, "LAN", "Lancashire"), (2706, 1226, "LRN", "Larne"), (2707, 1226, "LDS", "Leeds"), (2708, 1226, "LCE", "Leicester"), (2709, 1226, "LEC", "Leicestershire"), (2710, 1226, "LEW", "Lewisham"), (2711, 1226, "LMV", "Limavady"), (2712, 1226, "LIN", "Lincolnshire"), (2713, 1226, "LSB", "Lisburn"), (2714, 1226, "LIV", "Liverpool"), (2715, 1226, "LND", "London, City of"), (2716, 1226, "LUT", "Luton"), (2717, 1226, "MFT", "Magherafelt"), (2718, 1226, "MAN", "Manchester"), (2719, 1226, "MDW", "Medway"), (2720, 1226, "MTY", "Merthyr Tydfil"), (2721, 1226, "MRT", "Merton"), (2722, 1226, "MDB", "Middlesbrough"), (2723, 1226, "MLN", "Midlothian"), (2724, 1226, "MIK", "Milton Keynes"), (2725, 1226, "MON", "Monmouthshire"), (2726, 1226, "MRY", "Moray"), (2727, 1226, "MYL", "Moyle"), (2728, 1226, "NTL", "Neath Port Talbot"), (2729, 1226, "NET", "Newcastle upon Tyne"), (2730, 1226, "NWM", "Newham"), (2731, 1226, "NWP", "Newport"), (2732, 1226, "NYM", "Newry and Mourne"), (2733, 1226, "NTA", "Newtownabbey"), (2734, 1226, "NFK", "Norfolk"), (2735, 1226, "NAY", "North Ayrahire"), (2736, 1226, "NDN", "North Down"), (2737, 1226, "NEL", "North East Lincolnshire"), (2738, 1226, "NLK", "North Lanarkshire"), (2739, 1226, "NLN", "North Lincolnshire"), (2740, 1226, "NSM", "North Somerset"), (2741, 1226, "NTY", "North Tyneside"), (2742, 1226, "NYK", "North Yorkshire"), (2743, 1226, "NTH", "Northamptonshire"), (2744, 1226, "NBL", "Northumbarland"), (2745, 1226, "NGM", "Nottingham"), (2746, 1226, "NTT", "Nottinghamshire"), (2747, 1226, "OLD", "Oldham"), (2748, 1226, "OMH", "Omagh"), (2749, 1226, "ORR", "Orkney Islands"), (2750, 1226, "OXF", "Oxfordshire"), (2751, 1226, "PEM", "Pembrokeshire"), (2752, 1226, "PKN", "Perth and Kinross"), (2753, 1226, "PTE", "Peterborough"), (2754, 1226, "PLY", "Plymouth"), (2755, 1226, "POL", "Poole"), (2756, 1226, "POR", "Portsmouth"), (2757, 1226, "POW", "Powys"), (2758, 1226, "RDG", "Reading"), (2759, 1226, "RDB", "Redbridge"), (2760, 1226, "RCC", "Redcar and Cleveland"), (2761, 1226, "RFW", "Renfrewshlre"), (2762, 1226, "RCT", "Rhondda, Cynon, Taff"), (2763, 1226, "RIC", "Richmond upon Thames"), (2764, 1226, "RCH", "Rochdale"), (2765, 1226, "ROT", "Rotherham"), (2766, 1226, "RUT", "Rutland"), (2767, 1226, "SHN", "St. Helens"), (2768, 1226, "SLF", "Salford"), (2769, 1226, "SAW", "Sandwell"), (2770, 1226, "SCB", "Scottish Borders, The"), (2771, 1226, "SFT", "Sefton"), (2772, 1226, "SHF", "Sheffield"), (2773, 1226, "ZET", "Shetland Islands"), (2774, 1226, "SHR", "Shropshire"), (2775, 1226, "SLG", "Slough"), (2776, 1226, "SOL", "Solihull"), (2777, 1226, "SOM", "merset"), (2778, 1226, "SAY", "South Ayrshire"), (2779, 1226, "SGC", "South Gloucestershire"), (2780, 1226, "SLK", "South Lanarkshire"), (2781, 1226, "STY", "South Tyneside"), (2782, 1226, "STH", "Southampton"), (2783, 1226, "SOS", "Southend-on-Sea"), (2784, 1226, "SWK", "Southwark"), (2785, 1226, "STS", "Staffordshire"), (2786, 1226, "STG", "Stirling"), (2787, 1226, "SKP", "Stockport"), (2788, 1226, "STT", "Stockton-on-Tees"), (2789, 1226, "STE", "Stoke-on-Trent"), (2790, 1226, "STB", "Strabane"), (2791, 1226, "SFK", "Suffolk"), (2792, 1226, "SND", "Sunderland"), (2793, 1226, "SRY", "Surrey"), (2794, 1226, "STN", "Sutton"), (2795, 1226, "SWA", "Swansea"), (2796, 1226, "SWD", "Swindon"), (2797, 1226, "TAM", "Tameside"), (2798, 1226, "TFW", "Telford and Wrekin"), (2799, 1226, "THR", "Thurrock"), (2800, 1226, "TOB", "Torbay"), (2801, 1226, "TOF", "Torfasn"), (2802, 1226, "TWH", "Tower Hamlets"), (2803, 1226, "TRF", "Trafford"), (2804, 1226, "VGL", "Vale of Glamorgan, The"), (2805, 1226, "BMG", "Bro Morgannwg"), (2806, 1226, "WKF", "Wakefield"), (2807, 1226, "WLL", "Walsall"), (2808, 1226, "WFT", "Waltham Forest"), (2809, 1226, "WND", "Wandsworth"), (2810, 1226, "WRT", "Warrington"), (2811, 1226, "WAR", "Warwickshire"), (2812, 1226, "WBX", "West Berkshire"), (2813, 1226, "WDU", "West Dunbartonshire"), (2814, 1226, "WLN", "West Lothian"), (2815, 1226, "WSX", "West Sussex"), (2816, 1226, "WSM", "Westminster"), (2817, 1226, "WGN", "Wigan"), (2818, 1226, "WIL", "Wiltshire"), (2819, 1226, "WNM", "Windsor and Maidenhead"), (2820, 1226, "WRL", "Wirral"), (2821, 1226, "WOK", "Wokingham"), (2822, 1226, "WLV", "Wolverhampton"), (2823, 1226, "WOR", "Worcestershire"), (2824, 1226, "WRX", "Wrexham"), (2825, 1226, "YOR", "York"), (2826, 1083, "AH", "Ashanti"), (2827, 1083, "BA", "Brong-Ahafo"), (2828, 1083, "AA", "Greater Accra"), (2829, 1083, "UE", "Upper East"), (2830, 1083, "UW", "Upper West"), (2831, 1083, "TV", "Volta"), (2832, 1213, "B", "Banjul"), (2833, 1213, "L", "Lower River"), (2834, 1213, "M", "MacCarthy Island"), (2835, 1213, "N", "North Bank"), (2836, 1213, "U", "Upper River"), (2837, 1091, "BE", "Beyla"), (2838, 1091, "BF", "Boffa"), (2839, 1091, "BK", "Boke"), (2840, 1091, "CO", "Coyah"), (2841, 1091, "DB", "Dabola"), (2842, 1091, "DL", "Dalaba"), (2843, 1091, "DI", "Dinguiraye"), (2844, 1091, "DU", "Dubreka"), (2845, 1091, "FA", "Faranah"), (2846, 1091, "FO", "Forecariah"), (2847, 1091, "FR", "Fria"), (2848, 1091, "GA", "Gaoual"), (2849, 1091, "GU", "Guekedou"), (2850, 1091, "KA", "Kankan"), (2851, 1091, "KE", "Kerouane"), (2852, 1091, "KD", "Kindia"), (2853, 1091, "KS", "Kissidougou"), (2854, 1091, "KB", "Koubia"), (2855, 1091, "KN", "Koundara"), (2856, 1091, "KO", "Kouroussa"), (2857, 1091, "LA", "Labe"), (2858, 1091, "LE", "Lelouma"), (2859, 1091, "LO", "Lola"), (2860, 1091, "MC", "Macenta"), (2861, 1091, "ML", "Mali"), (2862, 1091, "MM", "Mamou"), (2863, 1091, "MD", "Mandiana"), (2864, 1091, "NZ", "Nzerekore"), (2865, 1091, "PI", "Pita"), (2866, 1091, "SI", "Siguiri"), (2867, 1091, "TE", "Telimele"), (2868, 1091, "TO", "Tougue"), (2869, 1091, "YO", "Yomou"), (2870, 1067, "C", "Region Continental"), (2871, 1067, "I", "Region Insular"), (2872, 1067, "AN", "Annobon"), (2873, 1067, "BN", "Bioko Norte"), (2874, 1067, "BS", "Bioko Sur"), (2875, 1067, "CS", "Centro Sur"), (2876, 1067, "KN", "Kie-Ntem"), (2877, 1067, "LI", "Litoral"), (2878, 1067, "WN", "Wele-Nzas"), (2879, 1085, "13", "Achaa"), (2880, 1085, "01", "Aitolia-Akarnania"), (2881, 1085, "11", "Argolis"), (2882, 1085, "12", "Arkadia"), (2883, 1085, "31", "Arta"), (2884, 1085, "A1", "Attiki"), (2885, 1085, "64", "Chalkidiki"), (2886, 1085, "94", "Chania"), (2887, 1085, "85", "Chios"), (2888, 1085, "81", "Dodekanisos"), (2889, 1085, "52", "Drama"), (2890, 1085, "71", "Evros"), (2891, 1085, "05", "Evrytania"), (2892, 1085, "04", "Evvoia"), (2893, 1085, "63", "Florina"), (2894, 1085, "07", "Fokis"), (2895, 1085, "06", "Fthiotis"), (2896, 1085, "51", "Grevena"), (2897, 1085, "14", "Ileia"), (2898, 1085, "53", "Imathia"), (2899, 1085, "33", "Ioannina"), (2900, 1085, "91", "Irakleion"), (2901, 1085, "41", "Karditsa"), (2902, 1085, "56", "Kastoria"), (2903, 1085, "55", "Kavalla"), (2904, 1085, "23", "Kefallinia"), (2905, 1085, "22", "Kerkyra"), (2906, 1085, "57", "Kilkis"), (2907, 1085, "15", "Korinthia"), (2908, 1085, "58", "Kozani"), (2909, 1085, "82", "Kyklades"), (2910, 1085, "16", "Lakonia"), (2911, 1085, "42", "Larisa"), (2912, 1085, "92", "Lasithion"), (2913, 1085, "24", "Lefkas"), (2914, 1085, "83", "Lesvos"), (2915, 1085, "43", "Magnisia"), (2916, 1085, "17", "Messinia"), (2917, 1085, "59", "Pella"), (2918, 1085, "34", "Preveza"), (2919, 1085, "93", "Rethymnon"), (2920, 1085, "73", "Rodopi"), (2921, 1085, "84", "Samos"), (2922, 1085, "62", "Serrai"), (2923, 1085, "32", "Thesprotia"), (2924, 1085, "54", "Thessaloniki"), (2925, 1085, "44", "Trikala"), (2926, 1085, "03", "Voiotia"), (2927, 1085, "72", "Xanthi"), (2928, 1085, "21", "Zakynthos"), (2929, 1085, "69", "Agio Oros"), (2930, 1090, "AV", "Alta Verapez"), (2931, 1090, "BV", "Baja Verapez"), (2932, 1090, "CM", "Chimaltenango"), (2933, 1090, "CQ", "Chiquimula"), (2934, 1090, "PR", "El Progreso"), (2935, 1090, "ES", "Escuintla"), (2936, 1090, "GU", "Guatemala"), (2937, 1090, "HU", "Huehuetenango"), (2938, 1090, "IZ", "Izabal"), (2939, 1090, "JA", "Jalapa"), (2940, 1090, "JU", "Jutiapa"), (2941, 1090, "PE", "Peten"), (2942, 1090, "QZ", "Quetzaltenango"), (2943, 1090, "QC", "Quiche"), (2944, 1090, "RE", "Reta.thuleu"), (2945, 1090, "SA", "Sacatepequez"), (2946, 1090, "SM", "San Marcos"), (2947, 1090, "SR", "Santa Rosa"), (2948, 1090, "SO", "Solol6"), (2949, 1090, "SU", "Suchitepequez"), (2950, 1090, "TO", "Totonicapan"), (2951, 1090, "ZA", "Zacapa"), (2952, 1092, "BS", "Bissau"), (2953, 1092, "BA", "Bafata"), (2954, 1092, "BM", "Biombo"), (2955, 1092, "BL", "Bolama"), (2956, 1092, "CA", "Cacheu"), (2957, 1092, "GA", "Gabu"), (2958, 1092, "OI", "Oio"), (2959, 1092, "QU", "Quloara"), (2960, 1092, "TO", "Tombali S"), (2961, 1093, "BA", "Barima-Waini"), (2962, 1093, "CU", "Cuyuni-Mazaruni"), (2963, 1093, "DE", "Demerara-Mahaica"), (2964, 1093, "EB", "East Berbice-Corentyne"), (2965, 1093, "ES", "Essequibo Islands-West Demerara"), (2966, 1093, "MA", "Mahaica-Berbice"), (2967, 1093, "PM", "Pomeroon-Supenaam"), (2968, 1093, "PT", "Potaro-Siparuni"), (2969, 1093, "UD", "Upper Demerara-Berbice"), (2970, 1093, "UT", "Upper Takutu-Upper Essequibo"), (2971, 1097, "AT", "Atlantida"), (2972, 1097, "CL", "Colon"), (2973, 1097, "CM", "Comayagua"), (2974, 1097, "CP", "Copan"), (2975, 1097, "CR", "Cortes"), (2976, 1097, "CH", "Choluteca"), (2977, 1097, "EP", "El Paraiso"), (2978, 1097, "FM", "Francisco Morazan"), (2979, 1097, "GD", "Gracias a Dios"), (2980, 1097, "IN", "Intibuca"), (2981, 1097, "IB", "Islas de la Bahia"), (2982, 1097, "LE", "Lempira"), (2983, 1097, "OC", "Ocotepeque"), (2984, 1097, "OL", "Olancho"), (2985, 1097, "SB", "Santa Barbara"), (2986, 1097, "VA", "Valle"), (2987, 1097, "YO", "Yoro"), (2988, 1055, "07", "Bjelovarsko-bilogorska zupanija"), (2989, 1055, "12", "Brodsko-posavska zupanija"), (2990, 1055, "19", "Dubrovacko-neretvanska zupanija"), (2991, 1055, "18", "Istarska zupanija"), (2992, 1055, "04", "Karlovacka zupanija"), (2993, 1055, "06", "Koprivnickco-krizevacka zupanija"), (2994, 1055, "02", "Krapinako-zagorska zupanija"), (2995, 1055, "09", "Licko-senjska zupanija"), (2996, 1055, "20", "Medimurska zupanija"), (2997, 1055, "14", "Osjecko-baranjska zupanija"), (2998, 1055, "11", "Pozesko-slavonska zupanija"), (2999, 1055, "08", "Primorsko-goranska zupanija"), (3000, 1055, "03", "Sisacko-moelavacka Iupanija"), (3001, 1055, "17", "Splitako-dalmatinska zupanija"), (3002, 1055, "15", "Sibenako-kninska zupanija"), (3003, 1055, "05", "Varaidinska zupanija"), (3004, 1055, "10", "VirovitiEko-podravska zupanija"), (3005, 1055, "16", "VuRovarako-srijemska zupanija"), (3006, 1055, "13", "Zadaraka"), (3007, 1055, "01", "Zagrebacka zupanija"), (3008, 1094, "GA", "Grande-Anse"), (3009, 1094, "NE", "Nord-Eat"), (3010, 1094, "NO", "Nord-Ouest"), (3011, 1094, "OU", "Ouest"), (3012, 1094, "SD", "Sud"), (3013, 1094, "SE", "Sud-Est"), (3014, 1099, "BU", "Budapest"), (3015, 1099, "BK", "Bács-Kiskun"), (3016, 1099, "BA", "Baranya"), (3017, 1099, "BE", "Békés"), (3018, 1099, "BZ", "Borsod-Abaúj-Zemplén"), (3019, 1099, "CS", "Csongrád"), (3020, 1099, "FE", "Fejér"), (3021, 1099, "GS", "Győr-Moson-Sopron"), (3022, 1099, "HB", "Hajdu-Bihar"), (3023, 1099, "HE", "Heves"), (3024, 1099, "JN", "Jász-Nagykun-Szolnok"), (3025, 1099, "KE", "Komárom-Esztergom"), (3026, 1099, "NO", "Nográd"), (3027, 1099, "PE", "Pest"), (3028, 1099, "SO", "Somogy"), (3029, 1099, "SZ", "Szabolcs-Szatmár-Bereg"), (3030, 1099, "TO", "Tolna"), (3031, 1099, "VA", "Vas"), (3032, 1099, "VE", "Veszprém"), (3033, 1099, "ZA", "Zala"), (3034, 1099, "BC", "Békéscsaba"), (3035, 1099, "DE", "Debrecen"), (3036, 1099, "DU", "Dunaújváros"), (3037, 1099, "EG", "Eger"), (3038, 1099, "GY", "Győr"), (3039, 1099, "HV", "Hódmezővásárhely"), (3040, 1099, "KV", "Kaposvár"), (3041, 1099, "KM", "Kecskemét"), (3042, 1099, "MI", "Miskolc"), (3043, 1099, "NK", "Nagykanizsa"), (3044, 1099, "NY", "Nyiregyháza"), (3045, 1099, "PS", "Pécs"), (3046, 1099, "ST", "Salgótarján"), (3047, 1099, "SN", "Sopron"), (3048, 1099, "SD", "Szeged"), (3049, 1099, "SF", "Székesfehérvár"), (3050, 1099, "SS", "Szekszárd"), (3051, 1099, "SK", "Szolnok"), (3052, 1099, "SH", "Szombathely"), (3053, 1099, "TB", "Tatabánya"), (3054, 1099, "ZE", "Zalaegerszeg"), (3055, 1102, "BA", "Bali"), (3056, 1102, "BB", "Bangka Belitung"), (3057, 1102, "BT", "Banten"), (3058, 1102, "BE", "Bengkulu"), (3059, 1102, "GO", "Gorontalo"), (3060, 1102, "IJ", "Irian Jaya"), (3061, 1102, "JA", "Jambi"), (3062, 1102, "JB", "Jawa Barat"), (3063, 1102, "JT", "Jawa Tengah"), (3064, 1102, "JI", "Jawa Timur"), (3065, 1102, "KB", "Kalimantan Barat"), (3066, 1102, "KT", "Kalimantan Timur"), (3067, 1102, "KS", "Kalimantan Selatan"), (3068, 1102, "KR", "Kepulauan Riau"), (3069, 1102, "LA", "Lampung"), (3070, 1102, "MA", "Maluku"), (3071, 1102, "MU", "Maluku Utara"), (3072, 1102, "NB", "Nusa Tenggara Barat"), (3073, 1102, "NT", "Nusa Tenggara Timur"), (3074, 1102, "PA", "Papua"), (3075, 1102, "RI", "Riau"), (3076, 1102, "SN", "Sulawesi Selatan"), (3077, 1102, "ST", "Sulawesi Tengah"), (3078, 1102, "SG", "Sulawesi Tenggara"), (3079, 1102, "SA", "Sulawesi Utara"), (3080, 1102, "SB", "Sumatra Barat"), (3081, 1102, "SS", "Sumatra Selatan"), (3082, 1102, "SU", "Sumatera Utara"), (3083, 1102, "JK", "Jakarta Raya"), (3084, 1102, "AC", "Aceh"), (3085, 1102, "YO", "Yogyakarta"), (3086, 1105, "C", "Cork"), (3087, 1105, "CE", "Clare"), (3088, 1105, "CN", "Cavan"), (3089, 1105, "CW", "Carlow"), (3090, 1105, "D", "Dublin"), (3091, 1105, "DL", "Donegal"), (3092, 1105, "G", "Galway"), (3093, 1105, "KE", "Kildare"), (3094, 1105, "KK", "Kilkenny"), (3095, 1105, "KY", "Kerry"), (3096, 1105, "LD", "Longford"), (3097, 1105, "LH", "Louth"), (3098, 1105, "LK", "Limerick"), (3099, 1105, "LM", "Leitrim"), (3100, 1105, "LS", "Laois"), (3101, 1105, "MH", "Meath"), (3102, 1105, "MN", "Monaghan"), (3103, 1105, "MO", "Mayo"), (3104, 1105, "OY", "Offaly"), (3105, 1105, "RN", "Roscommon"), (3106, 1105, "SO", "Sligo"), (3107, 1105, "TA", "Tipperary"), (3108, 1105, "WD", "Waterford"), (3109, 1105, "WH", "Westmeath"), (3110, 1105, "WW", "Wicklow"), (3111, 1105, "WX", "Wexford"), (3112, 1106, "D", "HaDarom"), (3113, 1106, "M", "HaMerkaz"), (3114, 1106, "Z", "HaZafon"), (3115, 1106, "HA", "Hefa"), (3116, 1106, "TA", "Tel-Aviv"), (3117, 1106, "JM", "Yerushalayim Al Quds"), (3118, 1104, "AN", "Al Anbar"), (3119, 1104, "BA", "Al Ba,rah"), (3120, 1104, "MU", "Al Muthanna"), (3121, 1104, "QA", "Al Qadisiyah"), (3122, 1104, "NA", "An Najef"), (3123, 1104, "AR", "Arbil"), (3124, 1104, "SW", "As Sulaymaniyah"), (3125, 1104, "TS", "At Ta\'mim"), (3126, 1104, "BB", "Babil"), (3127, 1104, "BG", "Baghdad"), (3128, 1104, "DA", "Dahuk"), (3129, 1104, "DQ", "Dhi Qar"), (3130, 1104, "DI", "Diyala"), (3131, 1104, "KA", "Karbala\'"), (3132, 1104, "MA", "Maysan"), (3133, 1104, "NI", "Ninawa"), (3134, 1104, "SD", "Salah ad Din"), (3135, 1104, "WA", "Wasit"), (3136, 1103, "03", "Ardabil"), (3137, 1103, "02", "Azarbayjan-e Gharbi"), (3138, 1103, "01", "Azarbayjan-e Sharqi"), (3139, 1103, "06", "Bushehr"), (3140, 1103, "08", "Chahar Mahall va Bakhtiari"), (3141, 1103, "04", "Esfahan"), (3142, 1103, "14", "Fars"), (3143, 1103, "19", "Gilan"), (3144, 1103, "27", "Golestan"), (3145, 1103, "24", "Hamadan"), (3146, 1103, "23", "Hormozgan"), (3147, 1103, "05", "Iiam"), (3148, 1103, "15", "Kerman"), (3149, 1103, "17", "Kermanshah"), (3150, 1103, "09", "Khorasan"), (3151, 1103, "10", "Khuzestan"), (3152, 1103, "18", "Kohjiluyeh va Buyer Ahmad"), (3153, 1103, "16", "Kordestan"), (3154, 1103, "20", "Lorestan"), (3155, 1103, "22", "Markazi"), (3156, 1103, "21", "Mazandaran"), (3157, 1103, "28", "Qazvin"), (3158, 1103, "26", "Qom"), (3159, 1103, "12", "Semnan"), (3160, 1103, "13", "Sistan va Baluchestan"), (3161, 1103, "07", "Tehran"), (3162, 1103, "25", "Yazd"), (3163, 1103, "11", "Zanjan"), (3164, 1100, "7", "Austurland"), (3165, 1100, "1", "Hofuoborgarsvaeoi utan Reykjavikur"), (3166, 1100, "6", "Norourland eystra"), (3167, 1100, "5", "Norourland vestra"), (3168, 1100, "0", "Reykjavik"), (3169, 1100, "8", "Suourland"), (3170, 1100, "2", "Suournes"), (3171, 1100, "4", "Vestfirolr"), (3172, 1100, "3", "Vesturland"), (3173, 1107, "AG", "Agrigento"), (3174, 1107, "AL", "Alessandria"), (3175, 1107, "AN", "Ancona"), (3176, 1107, "AO", "Aosta"), (3177, 1107, "AR", "Arezzo"), (3178, 1107, "AP", "Ascoli Piceno"), (3179, 1107, "AT", "Asti"), (3180, 1107, "AV", "Avellino"), (3181, 1107, "BA", "Bari"), (3182, 1107, "BL", "Belluno"), (3183, 1107, "BN", "Benevento"), (3184, 1107, "BG", "Bergamo"), (3185, 1107, "BI", "Biella"), (3186, 1107, "BO", "Bologna"), (3187, 1107, "BZ", "Bolzano"), (3188, 1107, "BS", "Brescia"), (3189, 1107, "BR", "Brindisi"), (3190, 1107, "CA", "Cagliari"), (3191, 1107, "CL", "Caltanissetta"), (3192, 1107, "CB", "Campobasso"), (3193, 1107, "CE", "Caserta"), (3194, 1107, "CT", "Catania"), (3195, 1107, "CZ", "Catanzaro"), (3196, 1107, "CH", "Chieti"), (3197, 1107, "CO", "Como"), (3198, 1107, "CS", "Cosenza"), (3199, 1107, "CR", "Cremona"), (3200, 1107, "KR", "Crotone"), (3201, 1107, "CN", "Cuneo"), (3202, 1107, "EN", "Enna"), (3203, 1107, "FE", "Ferrara"), (3204, 1107, "FI", "Firenze"), (3205, 1107, "FG", "Foggia"), (3206, 1107, "FO", "Forli"), (3207, 1107, "FR", "Frosinone"), (3208, 1107, "GE", "Genova"), (3209, 1107, "GO", "Gorizia"), (3210, 1107, "GR", "Grosseto"), (3211, 1107, "IM", "Imperia"), (3212, 1107, "IS", "Isernia"), (3213, 1107, "AQ", "L\'Aquila"), (3214, 1107, "SP", "La Spezia"), (3215, 1107, "LT", "Latina"), (3216, 1107, "LE", "Lecce"), (3217, 1107, "LC", "Lecco"), (3218, 1107, "LI", "Livorno"), (3219, 1107, "LO", "Lodi"), (3220, 1107, "LU", "Lucca"), (3221, 1107, "SC", "Macerata"), (3222, 1107, "MN", "Mantova"), (3223, 1107, "MS", "Massa-Carrara"), (3224, 1107, "MT", "Matera"), (3225, 1107, "ME", "Messina"), (3226, 1107, "MI", "Milano"), (3227, 1107, "MO", "Modena"), (3228, 1107, "NA", "Napoli"), (3229, 1107, "NO", "Novara"), (3230, 1107, "NU", "Nuoro"), (3231, 1107, "OR", "Oristano"), (3232, 1107, "PD", "Padova"), (3233, 1107, "PA", "Palermo"), (3234, 1107, "PR", "Parma"), (3235, 1107, "PV", "Pavia"), (3236, 1107, "PG", "Perugia"), (3237, 1107, "PS", "Pesaro e Urbino"), (3238, 1107, "PE", "Pescara"), (3239, 1107, "PC", "Piacenza"), (3240, 1107, "PI", "Pisa"), (3241, 1107, "PT", "Pistoia"), (3242, 1107, "PN", "Pordenone"), (3243, 1107, "PZ", "Potenza"), (3244, 1107, "PO", "Prato"), (3245, 1107, "RG", "Ragusa"), (3246, 1107, "RA", "Ravenna"), (3247, 1107, "RC", "Reggio Calabria"), (3248, 1107, "RE", "Reggio Emilia"), (3249, 1107, "RI", "Rieti"), (3250, 1107, "RN", "Rimini"), (3251, 1107, "RM", "Roma"), (3252, 1107, "RO", "Rovigo"), (3253, 1107, "SA", "Salerno"), (3254, 1107, "SS", "Sassari"), (3255, 1107, "SV", "Savona"), (3256, 1107, "SI", "Siena"), (3257, 1107, "SR", "Siracusa"), (3258, 1107, "SO", "Sondrio"), (3259, 1107, "TA", "Taranto"), (3260, 1107, "TE", "Teramo"), (3261, 1107, "TR", "Terni"), (3262, 1107, "TO", "Torino"), (3263, 1107, "TP", "Trapani"), (3264, 1107, "TN", "Trento"), (3265, 1107, "TV", "Treviso"), (3266, 1107, "TS", "Trieste"), (3267, 1107, "UD", "Udine"), (3268, 1107, "VA", "Varese"), (3269, 1107, "VE", "Venezia"), (3270, 1107, "VB", "Verbano-Cusio-Ossola"), (3271, 1107, "VC", "Vercelli"), (3272, 1107, "VR", "Verona"), (3273, 1107, "VV", "Vibo Valentia"), (3274, 1107, "VI", "Vicenza"), (3275, 1107, "VT", "Viterbo"), (3276, 1109, "23", "Aichi"), (3277, 1109, "05", "Akita"), (3278, 1109, "02", "Aomori"), (3279, 1109, "12", "Chiba"), (3280, 1109, "38", "Ehime"), (3281, 1109, "18", "Fukui"), (3282, 1109, "40", "Fukuoka"), (3283, 1109, "07", "Fukusima"), (3284, 1109, "21", "Gifu"), (3285, 1109, "10", "Gunma"), (3286, 1109, "34", "Hiroshima"), (3287, 1109, "01", "Hokkaido"), (3288, 1109, "28", "Hyogo"), (3289, 1109, "08", "Ibaraki"), (3290, 1109, "17", "Ishikawa"), (3291, 1109, "03", "Iwate"), (3292, 1109, "37", "Kagawa"), (3293, 1109, "46", "Kagoshima"), (3294, 1109, "14", "Kanagawa"), (3295, 1109, "39", "Kochi"), (3296, 1109, "43", "Kumamoto"), (3297, 1109, "26", "Kyoto"), (3298, 1109, "24", "Mie"), (3299, 1109, "04", "Miyagi"), (3300, 1109, "45", "Miyazaki"), (3301, 1109, "20", "Nagano"), (3302, 1109, "42", "Nagasaki"), (3303, 1109, "29", "Nara"), (3304, 1109, "15", "Niigata"), (3305, 1109, "44", "Oita"), (3306, 1109, "33", "Okayama"), (3307, 1109, "47", "Okinawa"), (3308, 1109, "27", "Osaka"), (3309, 1109, "41", "Saga"), (3310, 1109, "11", "Saitama"), (3311, 1109, "25", "Shiga"), (3312, 1109, "32", "Shimane"), (3313, 1109, "22", "Shizuoka"), (3314, 1109, "09", "Tochigi"), (3315, 1109, "36", "Tokushima"), (3316, 1109, "13", "Tokyo"), (3317, 1109, "31", "Tottori"), (3318, 1109, "16", "Toyama"), (3319, 1109, "30", "Wakayama"), (3320, 1109, "06", "Yamagata"), (3321, 1109, "35", "Yamaguchi"), (3322, 1109, "19", "Yamanashi"), (3323, 1108, "13", "Clarendon"), (3324, 1108, "09", "Hanover"), (3325, 1108, "01", "Kingston"), (3326, 1108, "04", "Portland"), (3327, 1108, "02", "Saint Andrew"), (3328, 1108, "06", "Saint Ann"), (3329, 1108, "14", "Saint Catherine"), (3330, 1108, "11", "Saint Elizabeth"), (3331, 1108, "08", "Saint James"), (3332, 1108, "05", "Saint Mary"), (3333, 1108, "03", "Saint Thomea"), (3334, 1108, "07", "Trelawny"), (3335, 1108, "10", "Westmoreland"), (3336, 1110, "AJ", "Ajln"), (3337, 1110, "AQ", "Al \'Aqaba"), (3338, 1110, "BA", "Al Balqa\'"), (3339, 1110, "KA", "Al Karak"), (3340, 1110, "MA", "Al Mafraq"), (3341, 1110, "AM", "Amman"), (3342, 1110, "AT", "At Tafilah"), (3343, 1110, "AZ", "Az Zarga"), (3344, 1110, "JR", "Irbid"), (3345, 1110, "JA", "Jarash"), (3346, 1110, "MN", "Ma\'an"), (3347, 1110, "MD", "Madaba"), (3348, 1112, "110", "Nairobi Municipality"), (3349, 1112, "300", "Coast"), (3350, 1112, "500", "North-Eastern Kaskazini Mashariki"), (3351, 1112, "700", "Rift Valley"), (3352, 1112, "900", "Western Magharibi"), (3353, 1117, "GB", "Bishkek"), (3354, 1117, "B", "Batken"), (3355, 1117, "C", "Chu"), (3356, 1117, "J", "Jalal-Abad"), (3357, 1117, "N", "Naryn"), (3358, 1117, "O", "Osh"), (3359, 1117, "T", "Talas"), (3360, 1117, "Y", "Ysyk-Kol"), (3361, 1037, "23", "Krong Kaeb"), (3362, 1037, "24", "Krong Pailin"), (3363, 1037, "18", "Xrong Preah Sihanouk"), (3364, 1037, "12", "Phnom Penh"), (3365, 1037, "2", "Baat Dambang"), (3366, 1037, "1", "Banteay Mean Chey"), (3367, 1037, "3", "Rampong Chaam"), (3368, 1037, "4", "Kampong Chhnang"), (3369, 1037, "5", "Kampong Spueu"), (3370, 1037, "6", "Kampong Thum"), (3371, 1037, "7", "Kampot"), (3372, 1037, "8", "Kandaal"), (3373, 1037, "9", "Kach Kong"), (3374, 1037, "10", "Krachoh"), (3375, 1037, "11", "Mondol Kiri"), (3376, 1037, "22", "Otdar Mean Chey"), (3377, 1037, "15", "Pousaat"), (3378, 1037, "13", "Preah Vihear"), (3379, 1037, "14", "Prey Veaeng"), (3380, 1037, "16", "Rotanak Kiri"), (3381, 1037, "17", "Siem Reab"), (3382, 1037, "19", "Stueng Traeng"), (3383, 1037, "20", "Svaay Rieng"), (3384, 1037, "21", "Taakaev"), (3385, 1113, "G", "Gilbert Islands"), (3386, 1113, "L", "Line Islands"), (3387, 1113, "P", "Phoenix Islands"), (3388, 1049, "A", "Anjouan Ndzouani"), (3389, 1049, "G", "Grande Comore Ngazidja"), (3390, 1049, "M", "Moheli Moili"), (3391, 1114, "KAE", "Kaesong-si"), (3392, 1114, "NAM", "Nampo-si"), (3393, 1114, "PYO", "Pyongyang-ai"), (3394, 1114, "CHA", "Chagang-do"), (3395, 1114, "HAB", "Hamgyongbuk-do"), (3396, 1114, "HAN", "Hamgyongnam-do"), (3397, 1114, "HWB", "Hwanghaebuk-do"), (3398, 1114, "HWN", "Hwanghaenam-do"), (3399, 1114, "KAN", "Kangwon-do"), (3400, 1114, "PYB", "Pyonganbuk-do"), (3401, 1114, "PYN", "Pyongannam-do"), (3402, 1114, "YAN", "Yanggang-do"), (3403, 1114, "NAJ", "Najin Sonbong-si"), (3404, 1115, "11", "Seoul Teugbyeolsi"), (3405, 1115, "26", "Busan Gwang\'yeogsi"), (3406, 1115, "27", "Daegu Gwang\'yeogsi"), (3407, 1115, "30", "Daejeon Gwang\'yeogsi"), (3408, 1115, "29", "Gwangju Gwang\'yeogsi"), (3409, 1115, "28", "Incheon Gwang\'yeogsi"), (3410, 1115, "31", "Ulsan Gwang\'yeogsi"), (3411, 1115, "43", "Chungcheongbugdo"), (3412, 1115, "44", "Chungcheongnamdo"), (3413, 1115, "42", "Gang\'weondo"), (3414, 1115, "41", "Gyeonggido"), (3415, 1115, "47", "Gyeongsangbugdo"), (3416, 1115, "48", "Gyeongsangnamdo"), (3417, 1115, "49", "Jejudo"), (3418, 1115, "45", "Jeonrabugdo"), (3419, 1115, "46", "Jeonranamdo"), (3420, 1116, "AH", "Al Ahmadi"), (3421, 1116, "FA", "Al Farwanlyah"), (3422, 1116, "JA", "Al Jahrah"), (3423, 1116, "KU", "Al Kuwayt"), (3424, 1116, "HA", "Hawalli"), (3425, 1111, "ALA", "Almaty"), (3426, 1111, "AST", "Astana"), (3427, 1111, "ALM", "Almaty oblysy"), (3428, 1111, "AKM", "Aqmola oblysy"), (3429, 1111, "AKT", "Aqtobe oblysy"), (3430, 1111, "ATY", "Atyrau oblyfiy"), (3431, 1111, "ZAP", "Batys Quzaqstan oblysy"), (3432, 1111, "MAN", "Mangghystau oblysy"), (3433, 1111, "YUZ", "Ongtustik Quzaqstan oblysy"), (3434, 1111, "PAV", "Pavlodar oblysy"), (3435, 1111, "KAR", "Qaraghandy oblysy"), (3436, 1111, "KUS", "Qostanay oblysy"), (3437, 1111, "KZY", "Qyzylorda oblysy"), (3438, 1111, "VOS", "Shyghys Quzaqstan oblysy"), (3439, 1111, "SEV", "Soltustik Quzaqstan oblysy"), (3440, 1111, "ZHA", "Zhambyl oblysy Zhambylskaya oblast\'"), (3441, 1118, "VT", "Vientiane"), (3442, 1118, "AT", "Attapu"), (3443, 1118, "BK", "Bokeo"), (3444, 1118, "BL", "Bolikhamxai"), (3445, 1118, "CH", "Champasak"), (3446, 1118, "HO", "Houaphan"), (3447, 1118, "KH", "Khammouan"), (3448, 1118, "LM", "Louang Namtha"), (3449, 1118, "LP", "Louangphabang"), (3450, 1118, "OU", "Oudomxai"), (3451, 1118, "PH", "Phongsali"), (3452, 1118, "SL", "Salavan"), (3453, 1118, "SV", "Savannakhet"), (3454, 1118, "XA", "Xaignabouli"), (3455, 1118, "XN", "Xiasomboun"), (3456, 1118, "XE", "Xekong"), (3457, 1118, "XI", "Xiangkhoang"), (3458, 1120, "BA", "Beirout"), (3459, 1120, "BI", "El Begsa"), (3460, 1120, "JL", "Jabal Loubnane"), (3461, 1120, "AS", "Loubnane ech Chemali"), (3462, 1120, "JA", "Loubnane ej Jnoubi"), (3463, 1120, "NA", "Nabatiye"), (3464, 1199, "52", "Ampara"), (3465, 1199, "71", "Anuradhapura"), (3466, 1199, "81", "Badulla"), (3467, 1199, "51", "Batticaloa"), (3468, 1199, "11", "Colombo"), (3469, 1199, "31", "Galle"), (3470, 1199, "12", "Gampaha"), (3471, 1199, "33", "Hambantota"), (3472, 1199, "41", "Jaffna"), (3473, 1199, "13", "Kalutara"), (3474, 1199, "21", "Kandy"), (3475, 1199, "92", "Kegalla"), (3476, 1199, "42", "Kilinochchi"), (3477, 1199, "61", "Kurunegala"), (3478, 1199, "43", "Mannar"), (3479, 1199, "22", "Matale"), (3480, 1199, "32", "Matara"), (3481, 1199, "82", "Monaragala"), (3482, 1199, "45", "Mullaittivu"), (3483, 1199, "23", "Nuwara Eliya"), (3484, 1199, "72", "Polonnaruwa"), (3485, 1199, "62", "Puttalum"), (3486, 1199, "91", "Ratnapura"), (3487, 1199, "53", "Trincomalee"), (3488, 1199, "44", "VavunLya"), (3489, 1122, "BM", "Bomi"), (3490, 1122, "BG", "Bong"), (3491, 1122, "GB", "Grand Basaa"), (3492, 1122, "CM", "Grand Cape Mount"), (3493, 1122, "GG", "Grand Gedeh"), (3494, 1122, "GK", "Grand Kru"), (3495, 1122, "LO", "Lofa"), (3496, 1122, "MG", "Margibi"), (3497, 1122, "MY", "Maryland"), (3498, 1122, "MO", "Montserrado"), (3499, 1122, "NI", "Nimba"), (3500, 1122, "RI", "Rivercess"), (3501, 1122, "SI", "Sinoe"), (3502, 1121, "D", "Berea"), (3503, 1121, "B", "Butha-Buthe"), (3504, 1121, "C", "Leribe"), (3505, 1121, "E", "Mafeteng"), (3506, 1121, "A", "Maseru"), (3507, 1121, "F", "Mohale\'s Hoek"), (3508, 1121, "J", "Mokhotlong"), (3509, 1121, "H", "Qacha\'s Nek"), (3510, 1121, "G", "Quthing"), (3511, 1121, "K", "Thaba-Tseka"), (3512, 1125, "AL", "Alytaus Apskritis"), (3513, 1125, "KU", "Kauno Apskritis"), (3514, 1125, "KL", "Klaipedos Apskritis"), (3515, 1125, "MR", "Marijampoles Apskritis"), (3516, 1125, "PN", "Panevezio Apskritis"), (3517, 1125, "SA", "Sisuliu Apskritis"), (3518, 1125, "TA", "Taurages Apskritis"), (3519, 1125, "TE", "Telsiu Apskritis"), (3520, 1125, "UT", "Utenos Apskritis"), (3521, 1125, "VL", "Vilniaus Apskritis"), (3522, 1126, "D", "Diekirch"), (3523, 1126, "G", "GreveNmacher"), (3524, 1119, "AI", "Aizkraukles Apripkis"), (3525, 1119, "AL", "Alkanes Apripkis"), (3526, 1119, "BL", "Balvu Apripkis"), (3527, 1119, "BU", "Bauskas Apripkis"), (3528, 1119, "CE", "Cesu Aprikis"), (3529, 1119, "DA", "Daugavpile Apripkis"), (3530, 1119, "DO", "Dobeles Apripkis"), (3531, 1119, "GU", "Gulbenes Aprlpkis"), (3532, 1119, "JL", "Jelgavas Apripkis"), (3533, 1119, "JK", "Jekabpils Apripkis"), (3534, 1119, "KR", "Kraslavas Apripkis"), (3535, 1119, "KU", "Kuldlgas Apripkis"), (3536, 1119, "LM", "Limbazu Apripkis"), (3537, 1119, "LE", "Liepajas Apripkis"), (3538, 1119, "LU", "Ludzas Apripkis"), (3539, 1119, "MA", "Madonas Apripkis"), (3540, 1119, "OG", "Ogres Apripkis"), (3541, 1119, "PR", "Preilu Apripkis"), (3542, 1119, "RE", "Rezaknes Apripkis"), (3543, 1119, "RI", "Rigas Apripkis"), (3544, 1119, "SA", "Saldus Apripkis"), (3545, 1119, "TA", "Talsu Apripkis"), (3546, 1119, "TU", "Tukuma Apriplcis"), (3547, 1119, "VK", "Valkas Apripkis"), (3548, 1119, "VM", "Valmieras Apripkis"), (3549, 1119, "VE", "Ventspils Apripkis"), (3550, 1119, "DGV", "Daugavpils"), (3551, 1119, "JEL", "Jelgava"), (3552, 1119, "JUR", "Jurmala"), (3553, 1119, "LPX", "Liepaja"), (3554, 1119, "REZ", "Rezekne"), (3555, 1119, "RIX", "Riga"), (3556, 1119, "VEN", "Ventspils"), (3557, 1123, "AJ", "Ajdābiyā"), (3558, 1123, "BU", "Al Buţnān"), (3559, 1123, "HZ", "Al Hizām al Akhdar"), (3560, 1123, "JA", "Al Jabal al Akhdar"), (3561, 1123, "JI", "Al Jifārah"), (3562, 1123, "JU", "Al Jufrah"), (3563, 1123, "KF", "Al Kufrah"), (3564, 1123, "MJ", "Al Marj"), (3565, 1123, "MB", "Al Marqab"), (3566, 1123, "QT", "Al Qaţrūn"), (3567, 1123, "QB", "Al Qubbah"), (3568, 1123, "WA", "Al Wāhah"), (3569, 1123, "NQ", "An Nuqaţ al Khams"), (3570, 1123, "SH", "Ash Shāţi\'"), (3571, 1123, "ZA", "Az Zāwiyah"), (3572, 1123, "BA", "Banghāzī"), (3573, 1123, "BW", "Banī Walīd"), (3574, 1123, "DR", "Darnah"), (3575, 1123, "GD", "Ghadāmis"), (3576, 1123, "GR", "Gharyān"), (3577, 1123, "GT", "Ghāt"), (3578, 1123, "JB", "Jaghbūb"), (3579, 1123, "MI", "Mişrātah"), (3580, 1123, "MZ", "Mizdah"), (3581, 1123, "MQ", "Murzuq"), (3582, 1123, "NL", "Nālūt"), (3583, 1123, "SB", "Sabhā"), (3584, 1123, "SS", "Şabrātah Şurmān"), (3585, 1123, "SR", "Surt"), (3586, 1123, "TN", "Tājūrā\' wa an Nawāhī al Arbāh"), (3587, 1123, "TB", "Ţarābulus"), (3588, 1123, "TM", "Tarhūnah-Masallātah"), (3589, 1123, "WD", "Wādī al hayāt"), (3590, 1123, "YJ", "Yafran-Jādū"), (3591, 1146, "AGD", "Agadir"), (3592, 1146, "BAH", "Aït Baha"), (3593, 1146, "MEL", "Aït Melloul"), (3594, 1146, "HAO", "Al Haouz"), (3595, 1146, "HOC", "Al Hoceïma"), (3596, 1146, "ASZ", "Assa-Zag"), (3597, 1146, "AZI", "Azilal"), (3598, 1146, "BEM", "Beni Mellal"), (3599, 1146, "BES", "Ben Sllmane"), (3600, 1146, "BER", "Berkane"), (3601, 1146, "BOD", "Boujdour"), (3602, 1146, "BOM", "Boulemane"), (3603, 1146, "CAS", "Casablanca [Dar el Beïda]"), (3604, 1146, "CHE", "Chefchaouene"), (3605, 1146, "CHI", "Chichaoua"), (3606, 1146, "HAJ", "El Hajeb"), (3607, 1146, "JDI", "El Jadida"), (3608, 1146, "ERR", "Errachidia"), (3609, 1146, "ESI", "Essaouira"), (3610, 1146, "ESM", "Es Smara"), (3611, 1146, "FES", "Fès"), (3612, 1146, "FIG", "Figuig"), (3613, 1146, "GUE", "Guelmim"), (3614, 1146, "IFR", "Ifrane"), (3615, 1146, "JRA", "Jerada"), (3616, 1146, "KES", "Kelaat Sraghna"), (3617, 1146, "KEN", "Kénitra"), (3618, 1146, "KHE", "Khemisaet"), (3619, 1146, "KHN", "Khenifra"), (3620, 1146, "KHO", "Khouribga"), (3621, 1146, "LAA", "Laâyoune (EH)"), (3622, 1146, "LAP", "Larache"), (3623, 1146, "MAR", "Marrakech"), (3624, 1146, "MEK", "Meknsès"), (3625, 1146, "NAD", "Nador"), (3626, 1146, "OUA", "Ouarzazate"), (3627, 1146, "OUD", "Oued ed Dahab (EH)"), (3628, 1146, "OUJ", "Oujda"), (3629, 1146, "RBA", "Rabat-Salé"), (3630, 1146, "SAF", "Safi"), (3631, 1146, "SEF", "Sefrou"), (3632, 1146, "SET", "Settat"), (3633, 1146, "SIK", "Sidl Kacem"), (3634, 1146, "TNG", "Tanger"), (3635, 1146, "TNT", "Tan-Tan"), (3636, 1146, "TAO", "Taounate"), (3637, 1146, "TAR", "Taroudannt"), (3638, 1146, "TAT", "Tata"), (3639, 1146, "TAZ", "Taza"), (3640, 1146, "TET", "Tétouan"), (3641, 1146, "TIZ", "Tiznit"), (3642, 1142, "GA", "Gagauzia, Unitate Teritoriala Autonoma"), (3643, 1142, "CU", "Chisinau"), (3644, 1142, "SN", "Stinga Nistrului, unitatea teritoriala din"), (3645, 1142, "BA", "Balti"), (3646, 1142, "CA", "Cahul"), (3647, 1142, "ED", "Edinet"), (3648, 1142, "LA", "Lapusna"), (3649, 1142, "OR", "Orhei"), (3650, 1142, "SO", "Soroca"), (3651, 1142, "TA", "Taraclia"), (3652, 1142, "TI", "Tighina [Bender]"), (3653, 1142, "UN", "Ungheni"), (3654, 1129, "T", "Antananarivo"), (3655, 1129, "D", "Antsiranana"), (3656, 1129, "F", "Fianarantsoa"), (3657, 1129, "M", "Mahajanga"), (3658, 1129, "A", "Toamasina"), (3659, 1129, "U", "Toliara"), (3660, 1135, "ALL", "Ailinglapalap"), (3661, 1135, "ALK", "Ailuk"), (3662, 1135, "ARN", "Arno"), (3663, 1135, "AUR", "Aur"), (3664, 1135, "EBO", "Ebon"), (3665, 1135, "ENI", "Eniwetok"), (3666, 1135, "JAL", "Jaluit"), (3667, 1135, "KIL", "Kili"), (3668, 1135, "KWA", "Kwajalein"), (3669, 1135, "LAE", "Lae"), (3670, 1135, "LIB", "Lib"), (3671, 1135, "LIK", "Likiep"), (3672, 1135, "MAJ", "Majuro"), (3673, 1135, "MAL", "Maloelap"), (3674, 1135, "MEJ", "Mejit"), (3675, 1135, "MIL", "Mili"), (3676, 1135, "NMK", "Namorik"), (3677, 1135, "NMU", "Namu"), (3678, 1135, "RON", "Rongelap"), (3679, 1135, "UJA", "Ujae"), (3680, 1135, "UJL", "Ujelang"), (3681, 1135, "UTI", "Utirik"), (3682, 1135, "WTN", "Wotho"), (3683, 1135, "WTJ", "Wotje"), (3684, 1133, "BK0", "Bamako"), (3685, 1133, "7", "Gao"), (3686, 1133, "1", "Kayes"), (3687, 1133, "8", "Kidal"), (3688, 1133, "2", "Xoulikoro"), (3689, 1133, "5", "Mopti"), (3690, 1133, "4", "S69ou"), (3691, 1133, "3", "Sikasso"), (3692, 1133, "6", "Tombouctou"), (3693, 1035, "07", "Ayeyarwady"), (3694, 1035, "02", "Bago"), (3695, 1035, "03", "Magway"), (3696, 1035, "04", "Mandalay"), (3697, 1035, "01", "Sagaing"), (3698, 1035, "05", "Tanintharyi"), (3699, 1035, "06", "Yangon"), (3700, 1035, "14", "Chin"), (3701, 1035, "11", "Kachin"), (3702, 1035, "12", "Kayah"), (3703, 1035, "13", "Kayin"), (3704, 1035, "15", "Mon"), (3705, 1035, "16", "Rakhine"), (3706, 1035, "17", "Shan"), (3707, 1144, "1", "Ulanbaatar"), (3708, 1144, "073", "Arhangay"), (3709, 1144, "069", "Bayanhongor"), (3710, 1144, "071", "Bayan-Olgiy"), (3711, 1144, "067", "Bulgan"), (3712, 1144, "037", "Darhan uul"), (3713, 1144, "061", "Dornod"), (3714, 1144, "063", "Dornogov,"), (3715, 1144, "059", "DundgovL"), (3716, 1144, "057", "Dzavhan"), (3717, 1144, "065", "Govi-Altay"), (3718, 1144, "064", "Govi-Smber"), (3719, 1144, "039", "Hentiy"), (3720, 1144, "043", "Hovd"), (3721, 1144, "041", "Hovsgol"), (3722, 1144, "053", "Omnogovi"), (3723, 1144, "035", "Orhon"), (3724, 1144, "055", "Ovorhangay"), (3725, 1144, "049", "Selenge"), (3726, 1144, "051", "Shbaatar"), (3727, 1144, "047", "Tov"), (3728, 1144, "046", "Uvs"), (3729, 1137, "NKC", "Nouakchott"), (3730, 1137, "03", "Assaba"), (3731, 1137, "05", "Brakna"), (3732, 1137, "08", "Dakhlet Nouadhibou"), (3733, 1137, "04", "Gorgol"), (3734, 1137, "10", "Guidimaka"), (3735, 1137, "01", "Hodh ech Chargui"), (3736, 1137, "02", "Hodh el Charbi"), (3737, 1137, "12", "Inchiri"), (3738, 1137, "09", "Tagant"), (3739, 1137, "11", "Tiris Zemmour"), (3740, 1137, "06", "Trarza"), (3741, 1138, "BR", "Beau Bassin-Rose Hill"), (3742, 1138, "CU", "Curepipe"), (3743, 1138, "PU", "Port Louis"), (3744, 1138, "QB", "Quatre Bornes"), (3745, 1138, "VP", "Vacosa-Phoenix"), (3746, 1138, "BL", "Black River"), (3747, 1138, "FL", "Flacq"), (3748, 1138, "GP", "Grand Port"), (3749, 1138, "MO", "Moka"), (3750, 1138, "PA", "Pamplemousses"), (3751, 1138, "PW", "Plaines Wilhems"), (3752, 1138, "RP", "Riviere du Rempart"), (3753, 1138, "SA", "Savanne"), (3754, 1138, "AG", "Agalega Islands"), (3755, 1138, "CC", "Cargados Carajos Shoals"), (3756, 1138, "RO", "Rodrigues Island"), (3757, 1132, "MLE", "Male"), (3758, 1132, "02", "Alif"), (3759, 1132, "20", "Baa"), (3760, 1132, "17", "Dhaalu"), (3761, 1132, "14", "Faafu"), (3762, 1132, "27", "Gaaf Alif"), (3763, 1132, "28", "Gaefu Dhaalu"), (3764, 1132, "29", "Gnaviyani"), (3765, 1132, "07", "Haa Alif"), (3766, 1132, "23", "Haa Dhaalu"), (3767, 1132, "26", "Kaafu"), (3768, 1132, "05", "Laamu"), (3769, 1132, "03", "Lhaviyani"), (3770, 1132, "12", "Meemu"), (3771, 1132, "25", "Noonu"), (3772, 1132, "13", "Raa"), (3773, 1132, "01", "Seenu"), (3774, 1132, "24", "Shaviyani"), (3775, 1132, "08", "Thaa"), (3776, 1132, "04", "Vaavu"), (3777, 1130, "BA", "Balaka"), (3778, 1130, "BL", "Blantyre"), (3779, 1130, "CK", "Chikwawa"), (3780, 1130, "CR", "Chiradzulu"), (3781, 1130, "CT", "Chitipa"), (3782, 1130, "DE", "Dedza"), (3783, 1130, "DO", "Dowa"), (3784, 1130, "KR", "Karonga"), (3785, 1130, "KS", "Kasungu"), (3786, 1130, "LK", "Likoma Island"), (3787, 1130, "LI", "Lilongwe"), (3788, 1130, "MH", "Machinga"), (3789, 1130, "MG", "Mangochi"), (3790, 1130, "MC", "Mchinji"), (3791, 1130, "MU", "Mulanje"), (3792, 1130, "MW", "Mwanza"), (3793, 1130, "MZ", "Mzimba"), (3794, 1130, "NB", "Nkhata Bay"), (3795, 1130, "NK", "Nkhotakota"), (3796, 1130, "NS", "Nsanje"), (3797, 1130, "NU", "Ntcheu"), (3798, 1130, "NI", "Ntchisi"), (3799, 1130, "PH", "Phalomba"), (3800, 1130, "RU", "Rumphi"), (3801, 1130, "SA", "Salima"), (3802, 1130, "TH", "Thyolo"), (3803, 1130, "ZO", "Zomba"), (3804, 1140, "AGU", "Aguascalientes"), (3805, 1140, "BCN", "Baja California"), (3806, 1140, "BCS", "Baja California Sur"), (3807, 1140, "CAM", "Campeche"), (3808, 1140, "COA", "Coahu ila"), (3809, 1140, "COL", "Col ima"), (3810, 1140, "CHP", "Chiapas"), (3811, 1140, "CHH", "Chihushua"), (3812, 1140, "DUR", "Durango"), (3813, 1140, "GUA", "Guanajuato"), (3814, 1140, "GRO", "Guerrero"), (3815, 1140, "HID", "Hidalgo"), (3816, 1140, "JAL", "Jalisco"), (3817, 1140, "MEX", "Mexico"), (3818, 1140, "MIC", "Michoacin"), (3819, 1140, "MOR", "Moreloa"), (3820, 1140, "NAY", "Nayarit"), (3821, 1140, "NLE", "Nuevo Leon"), (3822, 1140, "OAX", "Oaxaca"), (3823, 1140, "PUE", "Puebla"), (3824, 1140, "QUE", "Queretaro"), (3825, 1140, "ROO", "Quintana Roo"), (3826, 1140, "SLP", "San Luis Potosi"), (3827, 1140, "SIN", "Sinaloa"), (3828, 1140, "SON", "Sonora"), (3829, 1140, "TAB", "Tabasco"), (3830, 1140, "TAM", "Tamaulipas"), (3831, 1140, "TLA", "Tlaxcala"), (3832, 1140, "VER", "Veracruz"), (3833, 1140, "YUC", "Yucatan"), (3834, 1140, "ZAC", "Zacatecas"), (3835, 1131, "14", "Wilayah Persekutuan Kuala Lumpur"), (3836, 1131, "15", "Wilayah Persekutuan Labuan"), (3837, 1131, "16", "Wilayah Persekutuan Putrajaya"), (3838, 1131, "01", "Johor"), (3839, 1131, "02", "Kedah"), (3840, 1131, "03", "Kelantan"), (3841, 1131, "04", "Melaka"), (3842, 1131, "05", "Negeri Sembilan"), (3843, 1131, "06", "Pahang"), (3844, 1131, "08", "Perak"), (3845, 1131, "09", "Perlis"), (3846, 1131, "07", "Pulau Pinang"), (3847, 1131, "12", "Sabah"), (3848, 1131, "13", "Sarawak"), (3849, 1131, "10", "Selangor"), (3850, 1131, "11", "Terengganu"), (3851, 1147, "MPM", "Maputo"), (3852, 1147, "P", "Cabo Delgado"), (3853, 1147, "G", "Gaza"), (3854, 1147, "I", "Inhambane"), (3855, 1147, "B", "Manica"), (3856, 1147, "N", "Numpula"), (3857, 1147, "A", "Niaaea"), (3858, 1147, "S", "Sofala"), (3859, 1147, "T", "Tete"), (3860, 1147, "Q", "Zambezia"), (3861, 1148, "CA", "Caprivi"), (3862, 1148, "ER", "Erongo"), (3863, 1148, "HA", "Hardap"), (3864, 1148, "KA", "Karas"), (3865, 1148, "KH", "Khomae"), (3866, 1148, "KU", "Kunene"), (3867, 1148, "OW", "Ohangwena"), (3868, 1148, "OK", "Okavango"), (3869, 1148, "OH", "Omaheke"), (3870, 1148, "OS", "Omusati"), (3871, 1148, "ON", "Oshana"), (3872, 1148, "OT", "Oshikoto"), (3873, 1148, "OD", "Otjozondjupa"), (3874, 1156, "8", "Niamey"), (3875, 1156, "1", "Agadez"), (3876, 1156, "2", "Diffa"), (3877, 1156, "3", "Dosso"), (3878, 1156, "4", "Maradi"), (3879, 1156, "S", "Tahoua"), (3880, 1156, "6", "Tillaberi"), (3881, 1156, "7", "Zinder"), (3882, 1157, "FC", "Abuja Capital Territory"), (3883, 1157, "AB", "Abia"), (3884, 1157, "AD", "Adamawa"), (3885, 1157, "AK", "Akwa Ibom"), (3886, 1157, "AN", "Anambra"), (3887, 1157, "BA", "Bauchi"), (3888, 1157, "BY", "Bayelsa"), (3889, 1157, "BE", "Benue"), (3890, 1157, "BO", "Borno"), (3891, 1157, "CR", "Cross River"), (3892, 1157, "DE", "Delta"), (3893, 1157, "EB", "Ebonyi"), (3894, 1157, "ED", "Edo"), (3895, 1157, "EK", "Ekiti"), (3896, 1157, "EN", "Enugu"), (3897, 1157, "GO", "Gombe"), (3898, 1157, "IM", "Imo"), (3899, 1157, "JI", "Jigawa"), (3900, 1157, "KD", "Kaduna"), (3901, 1157, "KN", "Kano"), (3902, 1157, "KT", "Katsina"), (3903, 1157, "KE", "Kebbi"), (3904, 1157, "KO", "Kogi"), (3905, 1157, "KW", "Kwara"), (3906, 1157, "LA", "Lagos"), (3907, 1157, "NA", "Nassarawa"), (3908, 1157, "NI", "Niger"), (3909, 1157, "OG", "Ogun"), (3910, 1157, "ON", "Ondo"), (3911, 1157, "OS", "Osun"), (3912, 1157, "OY", "Oyo"), (3913, 1157, "RI", "Rivers"), (3914, 1157, "SO", "Sokoto"), (3915, 1157, "TA", "Taraba"), (3916, 1157, "YO", "Yobe"), (3917, 1157, "ZA", "Zamfara"), (3918, 1155, "BO", "Boaco"), (3919, 1155, "CA", "Carazo"), (3920, 1155, "CI", "Chinandega"), (3921, 1155, "CO", "Chontales"), (3922, 1155, "ES", "Esteli"), (3923, 1155, "JI", "Jinotega"), (3924, 1155, "LE", "Leon"), (3925, 1155, "MD", "Madriz"), (3926, 1155, "MN", "Managua"), (3927, 1155, "MS", "Masaya"), (3928, 1155, "MT", "Matagalpa"), (3929, 1155, "NS", "Nueva Segovia"), (3930, 1155, "SJ", "Rio San Juan"), (3931, 1155, "RI", "Rivas"), (3932, 1155, "AN", "Atlantico Norte"), (3933, 1155, "AS", "Atlantico Sur"), (3934, 1152, "DR", "Drente"), (3935, 1152, "FL", "Flevoland"), (3936, 1152, "FR", "Friesland"), (3937, 1152, "GL", "Gelderland"), (3938, 1152, "GR", "Groningen"), (3939, 1152, "NB", "Noord-Brabant"), (3940, 1152, "NH", "Noord-Holland"), (3941, 1152, "OV", "Overijssel"), (3942, 1152, "UT", "Utrecht"), (3943, 1152, "ZH", "Zuid-Holland"), (3944, 1152, "ZL", "Zeeland"), (3945, 1161, "02", "Akershus"), (3946, 1161, "09", "Aust-Agder"), (3947, 1161, "06", "Buskerud"), (3948, 1161, "20", "Finumark"), (3949, 1161, "04", "Hedmark"), (3950, 1161, "12", "Hordaland"), (3951, 1161, "15", "Mire og Romsdal"), (3952, 1161, "18", "Nordland"), (3953, 1161, "17", "Nord-Trindelag"), (3954, 1161, "05", "Oppland"), (3955, 1161, "03", "Oslo"), (3956, 1161, "11", "Rogaland"), (3957, 1161, "14", "Sogn og Fjordane"), (3958, 1161, "16", "Sir-Trindelag"), (3959, 1161, "06", "Telemark"), (3960, 1161, "19", "Troms"), (3961, 1161, "10", "Vest-Agder"), (3962, 1161, "07", "Vestfold"), (3963, 1161, "01", "Ostfold"), (3964, 1161, "22", "Jan Mayen"), (3965, 1161, "21", "Svalbard"), (3966, 1154, "AUK", "Auckland"), (3967, 1154, "BOP", "Bay of Plenty"), (3968, 1154, "CAN", "Canterbury"), (3969, 1154, "GIS", "Gisborne"), (3970, 1154, "HKB", "Hawkes\'s Bay"), (3971, 1154, "MWT", "Manawatu-Wanganui"), (3972, 1154, "MBH", "Marlborough"), (3973, 1154, "NSN", "Nelson"), (3974, 1154, "NTL", "Northland"), (3975, 1154, "OTA", "Otago"), (3976, 1154, "STL", "Southland"), (3977, 1154, "TKI", "Taranaki"), (3978, 1154, "TAS", "Tasman"), (3979, 1154, "WKO", "waikato"), (3980, 1154, "WGN", "Wellington"), (3981, 1154, "WTC", "West Coast"), (3982, 1162, "DA", "Ad Dakhillyah"), (3983, 1162, "BA", "Al Batinah"), (3984, 1162, "JA", "Al Janblyah"), (3985, 1162, "WU", "Al Wusta"), (3986, 1162, "SH", "Ash Sharqlyah"), (3987, 1162, "ZA", "Az Zahirah"), (3988, 1162, "MA", "Masqat"), (3989, 1162, "MU", "Musandam"), (3990, 1166, "1", "Bocas del Toro"), (3991, 1166, "2", "Cocle"), (3992, 1166, "4", "Chiriqui"), (3993, 1166, "5", "Darien"), (3994, 1166, "6", "Herrera"), (3995, 1166, "7", "Loa Santoa"), (3996, 1166, "8", "Panama"), (3997, 1166, "9", "Veraguas"), (3998, 1166, "Q", "Comarca de San Blas"), (3999, 1169, "CAL", "El Callao"), (4000, 1169, "ANC", "Ancash"), (4001, 1169, "APU", "Apurimac"), (4002, 1169, "ARE", "Arequipa"), (4003, 1169, "AYA", "Ayacucho"), (4004, 1169, "CAJ", "Cajamarca"), (4005, 1169, "CUS", "Cuzco"), (4006, 1169, "HUV", "Huancavelica"), (4007, 1169, "HUC", "Huanuco"), (4008, 1169, "ICA", "Ica"), (4009, 1169, "JUN", "Junin"), (4010, 1169, "LAL", "La Libertad"), (4011, 1169, "LAM", "Lambayeque"), (4012, 1169, "LIM", "Lima"), (4013, 1169, "LOR", "Loreto"), (4014, 1169, "MDD", "Madre de Dios"), (4015, 1169, "MOQ", "Moquegua"), (4016, 1169, "PAS", "Pasco"), (4017, 1169, "PIU", "Piura"), (4018, 1169, "PUN", "Puno"), (4019, 1169, "SAM", "San Martin"), (4020, 1169, "TAC", "Tacna"), (4021, 1169, "TUM", "Tumbes"), (4022, 1169, "UCA", "Ucayali"), (4023, 1167, "NCD", "National Capital District (Port Moresby)"), (4024, 1167, "CPK", "Chimbu"), (4025, 1167, "EHG", "Eastern Highlands"), (4026, 1167, "EBR", "East New Britain"), (4027, 1167, "ESW", "East Sepik"), (4028, 1167, "EPW", "Enga"), (4029, 1167, "GPK", "Gulf"), (4030, 1167, "MPM", "Madang"), (4031, 1167, "MRL", "Manus"), (4032, 1167, "MBA", "Milne Bay"), (4033, 1167, "MPL", "Morobe"), (4034, 1167, "NIK", "New Ireland"), (4035, 1167, "NSA", "North Solomons"), (4036, 1167, "SAN", "Santaun"), (4037, 1167, "SHM", "Southern Highlands"), (4038, 1167, "WHM", "Western Highlands"), (4039, 1167, "WBK", "West New Britain"), (4040, 1170, "ABR", "Abra"), (4041, 1170, "AGN", "Agusan del Norte"), (4042, 1170, "AGS", "Agusan del Sur"), (4043, 1170, "AKL", "Aklan"), (4044, 1170, "ALB", "Albay"), (4045, 1170, "ANT", "Antique"), (4046, 1170, "APA", "Apayao"), (4047, 1170, "AUR", "Aurora"), (4048, 1170, "BAS", "Basilan"), (4049, 1170, "BAN", "Batasn"), (4050, 1170, "BTN", "Batanes"), (4051, 1170, "BTG", "Batangas"), (4052, 1170, "BEN", "Benguet"), (4053, 1170, "BIL", "Biliran"), (4054, 1170, "BOH", "Bohol"), (4055, 1170, "BUK", "Bukidnon"), (4056, 1170, "BUL", "Bulacan"), (4057, 1170, "CAG", "Cagayan"), (4058, 1170, "CAN", "Camarines Norte"), (4059, 1170, "CAS", "Camarines Sur"), (4060, 1170, "CAM", "Camiguin"), (4061, 1170, "CAP", "Capiz"), (4062, 1170, "CAT", "Catanduanes"), (4063, 1170, "CAV", "Cavite"), (4064, 1170, "CEB", "Cebu"), (4065, 1170, "COM", "Compostela Valley"), (4066, 1170, "DAV", "Davao"), (4067, 1170, "DAS", "Davao del Sur"), (4068, 1170, "DAO", "Davao Oriental"), (4069, 1170, "EAS", "Eastern Samar"), (4070, 1170, "GUI", "Guimaras"), (4071, 1170, "IFU", "Ifugao"), (4072, 1170, "ILN", "Ilocos Norte"), (4073, 1170, "ILS", "Ilocos Sur"), (4074, 1170, "ILI", "Iloilo"), (4075, 1170, "ISA", "Isabela"), (4076, 1170, "KAL", "Kalinga-Apayso"), (4077, 1170, "LAG", "Laguna"), (4078, 1170, "LAN", "Lanao del Norte"), (4079, 1170, "LAS", "Lanao del Sur"), (4080, 1170, "LUN", "La Union"), (4081, 1170, "LEY", "Leyte"), (4082, 1170, "MAG", "Maguindanao"), (4083, 1170, "MAD", "Marinduque"), (4084, 1170, "MAS", "Masbate"), (4085, 1170, "MDC", "Mindoro Occidental"), (4086, 1170, "MDR", "Mindoro Oriental"), (4087, 1170, "MSC", "Misamis Occidental"), (4088, 1170, "MSR", "Misamis Oriental"), (4089, 1170, "MOU", "Mountain Province"), (4090, 1170, "NEC", "Negroe Occidental"), (4091, 1170, "NER", "Negros Oriental"), (4092, 1170, "NCO", "North Cotabato"), (4093, 1170, "NSA", "Northern Samar"), (4094, 1170, "NUE", "Nueva Ecija"), (4095, 1170, "NUV", "Nueva Vizcaya"), (4096, 1170, "PLW", "Palawan"), (4097, 1170, "PAM", "Pampanga"), (4098, 1170, "PAN", "Pangasinan"), (4099, 1170, "QUE", "Quezon"), (4100, 1170, "QUI", "Quirino"), (4101, 1170, "RIZ", "Rizal"), (4102, 1170, "ROM", "Romblon"), (4103, 1170, "SAR", "Sarangani"), (4104, 1170, "SIG", "Siquijor"), (4105, 1170, "SOR", "Sorsogon"), (4106, 1170, "SCO", "South Cotabato"), (4107, 1170, "SLE", "Southern Leyte"), (4108, 1170, "SUK", "Sultan Kudarat"), (4109, 1170, "SLU", "Sulu"), (4110, 1170, "SUN", "Surigao del Norte"), (4111, 1170, "SUR", "Surigao del Sur"), (4112, 1170, "TAR", "Tarlac"), (4113, 1170, "TAW", "Tawi-Tawi"), (4114, 1170, "WSA", "Western Samar"), (4115, 1170, "ZMB", "Zambales"), (4116, 1170, "ZAN", "Zamboanga del Norte"), (4117, 1170, "ZAS", "Zamboanga del Sur"), (4118, 1170, "ZSI", "Zamboanga Sibiguey"), (4119, 1163, "IS", "Islamabad"), (4120, 1163, "BA", "Baluchistan (en)"), (4121, 1163, "NW", "North-West Frontier"), (4122, 1163, "SD", "Sind (en)"), (4123, 1163, "TA", "Federally Administered Tribal Aresa"), (4124, 1163, "JK", "Azad Rashmir"), (4125, 1163, "NA", "Northern Areas"), (4126, 1173, "01", "Aveiro"), (4127, 1173, "02", "Beja"), (4128, 1173, "03", "Braga"), (4129, 1173, "04", "Braganca"), (4130, 1173, "05", "Castelo Branco"), (4131, 1173, "06", "Colmbra"), (4132, 1173, "07", "Ovora"), (4133, 1173, "08", "Faro"), (4134, 1173, "09", "Guarda"), (4135, 1173, "10", "Leiria"), (4136, 1173, "11", "Lisboa"), (4137, 1173, "12", "Portalegre"), (4138, 1173, "13", "Porto"), (4139, 1173, "14", "Santarem"), (4140, 1173, "15", "Setubal"), (4141, 1173, "16", "Viana do Castelo"), (4142, 1173, "17", "Vila Real"), (4143, 1173, "18", "Viseu"), (4144, 1173, "20", "Regiao Autonoma dos Acores"), (4145, 1173, "30", "Regiao Autonoma da Madeira"), (4146, 1168, "ASU", "Asuncion"), (4147, 1168, "16", "Alto Paraguay"), (4148, 1168, "10", "Alto Parana"), (4149, 1168, "13", "Amambay"), (4150, 1168, "19", "Boqueron"), (4151, 1168, "5", "Caeguazu"), (4152, 1168, "6", "Caazapl"), (4153, 1168, "14", "Canindeyu"), (4154, 1168, "1", "Concepcion"), (4155, 1168, "3", "Cordillera"), (4156, 1168, "4", "Guaira"), (4157, 1168, "7", "Itapua"), (4158, 1168, "8", "Miaiones"), (4159, 1168, "12", "Neembucu"), (4160, 1168, "9", "Paraguari"), (4161, 1168, "15", "Presidente Hayes"), (4162, 1168, "2", "San Pedro"), (4163, 1175, "DA", "Ad Dawhah"), (4164, 1175, "GH", "Al Ghuwayriyah"), (4165, 1175, "JU", "Al Jumayliyah"), (4166, 1175, "KH", "Al Khawr"), (4167, 1175, "WA", "Al Wakrah"), (4168, 1175, "RA", "Ar Rayyan"), (4169, 1175, "JB", "Jariyan al Batnah"), (4170, 1175, "MS", "Madinat ash Shamal"), (4171, 1175, "US", "Umm Salal"), (4172, 1176, "B", "Bucuresti"), (4173, 1176, "AB", "Alba"), (4174, 1176, "AR", "Arad"), (4175, 1176, "AG", "Arges"), (4176, 1176, "BC", "Bacau"), (4177, 1176, "BH", "Bihor"), (4178, 1176, "BN", "Bistrita-Nasaud"), (4179, 1176, "BT", "Boto\'ani"), (4180, 1176, "BV", "Bra\'ov"), (4181, 1176, "BR", "Braila"), (4182, 1176, "BZ", "Buzau"), (4183, 1176, "CS", "Caras-Severin"), (4184, 1176, "CL", "Ca la ras\'i"), (4185, 1176, "CJ", "Cluj"), (4186, 1176, "CT", "Constant\'a"), (4187, 1176, "CV", "Covasna"), (4188, 1176, "DB", "Dambovit\'a"), (4189, 1176, "DJ", "Dolj"), (4190, 1176, "GL", "Galat\'i"), (4191, 1176, "GR", "Giurgiu"), (4192, 1176, "GJ", "Gorj"), (4193, 1176, "HR", "Harghita"), (4194, 1176, "HD", "Hunedoara"), (4195, 1176, "IL", "Ialomit\'a"), (4196, 1176, "IS", "Ias\'i"), (4197, 1176, "IF", "Ilfov"), (4198, 1176, "MM", "Maramures"), (4199, 1176, "MH", "Mehedint\'i"), (4200, 1176, "MS", "Mures"), (4201, 1176, "NT", "Neamt"), (4202, 1176, "OT", "Olt"), (4203, 1176, "PH", "Prahova"), (4204, 1176, "SM", "Satu Mare"), (4205, 1176, "SJ", "Sa laj"), (4206, 1176, "SB", "Sibiu"), (4207, 1176, "SV", "Suceava"), (4208, 1176, "TR", "Teleorman"), (4209, 1176, "TM", "Timis"), (4210, 1176, "TL", "Tulcea"), (4211, 1176, "VS", "Vaslui"), (4212, 1176, "VL", "Valcea"), (4213, 1176, "VN", "Vrancea"), (4214, 1177, "AD", "Adygeya, Respublika"), (4215, 1177, "AL", "Altay, Respublika"), (4216, 1177, "BA", "Bashkortostan, Respublika"), (4217, 1177, "BU", "Buryatiya, Respublika"), (4218, 1177, "CE", "Chechenskaya Respublika"), (4219, 1177, "CU", "Chuvashskaya Respublika"), (4220, 1177, "DA", "Dagestan, Respublika"), (4221, 1177, "IN", "Ingushskaya Respublika"), (4222, 1177, "KB", "Kabardino-Balkarskaya"), (4223, 1177, "KL", "Kalmykiya, Respublika"), (4224, 1177, "KC", "Karachayevo-Cherkesskaya Respublika"), (4225, 1177, "KR", "Kareliya, Respublika"), (4226, 1177, "KK", "Khakasiya, Respublika"), (4227, 1177, "KO", "Komi, Respublika"), (4228, 1177, "ME", "Mariy El, Respublika"), (4229, 1177, "MO", "Mordoviya, Respublika"), (4230, 1177, "SA", "Sakha, Respublika [Yakutiya]"), (4231, 1177, "SE", "Severnaya Osetiya, Respublika"), (4232, 1177, "TA", "Tatarstan, Respublika"), (4233, 1177, "TY", "Tyva, Respublika [Tuva]"), (4234, 1177, "UD", "Udmurtskaya Respublika"), (4235, 1177, "ALT", "Altayskiy kray"), (4236, 1177, "KHA", "Khabarovskiy kray"), (4237, 1177, "KDA", "Krasnodarskiy kray"), (4238, 1177, "KYA", "Krasnoyarskiy kray"), (4239, 1177, "PRI", "Primorskiy kray"), (4240, 1177, "STA", "Stavropol\'skiy kray"), (4241, 1177, "AMU", "Amurskaya oblast\'"), (4242, 1177, "ARK", "Arkhangel\'skaya oblast\'"), (4243, 1177, "AST", "Astrakhanskaya oblast\'"), (4244, 1177, "BEL", "Belgorodskaya oblast\'"), (4245, 1177, "BRY", "Bryanskaya oblast\'"), (4246, 1177, "CHE", "Chelyabinskaya oblast\'"), (4247, 1177, "CHI", "Chitinskaya oblast\'"), (4248, 1177, "IRK", "Irkutskaya oblast\'"), (4249, 1177, "IVA", "Ivanovskaya oblast\'"), (4250, 1177, "KGD", "Kaliningradskaya oblast\'"), (4251, 1177, "KLU", "Kaluzhskaya oblast\'"), (4252, 1177, "KAM", "Kamchatskaya oblast\'"), (4253, 1177, "KEM", "Kemerovskaya oblast\'"), (4254, 1177, "KIR", "Kirovskaya oblast\'"), (4255, 1177, "KOS", "Kostromskaya oblast\'"), (4256, 1177, "KGN", "Kurganskaya oblast\'"), (4257, 1177, "KRS", "Kurskaya oblast\'"), (4258, 1177, "LEN", "Leningradskaya oblast\'"), (4259, 1177, "LIP", "Lipetskaya oblast\'"), (4260, 1177, "MAG", "Magadanskaya oblast\'"), (4261, 1177, "MOS", "Moskovskaya oblast\'"), (4262, 1177, "MUR", "Murmanskaya oblast\'"), (4263, 1177, "NIZ", "Nizhegorodskaya oblast\'"), (4264, 1177, "NGR", "Novgorodskaya oblast\'"), (4265, 1177, "NVS", "Novosibirskaya oblast\'"), (4266, 1177, "OMS", "Omskaya oblast\'"), (4267, 1177, "ORE", "Orenburgskaya oblast\'"), (4268, 1177, "ORL", "Orlovskaya oblast\'"), (4269, 1177, "PNZ", "Penzenskaya oblast\'"), (4270, 1177, "PER", "Permskaya oblast\'"), (4271, 1177, "PSK", "Pskovskaya oblast\'"), (4272, 1177, "ROS", "Rostovskaya oblast\'"), (4273, 1177, "RYA", "Ryazanskaya oblast\'"), (4274, 1177, "SAK", "Sakhalinskaya oblast\'"), (4275, 1177, "SAM", "Samarskaya oblast\'"), (4276, 1177, "SAR", "Saratovskaya oblast\'"), (4277, 1177, "SMO", "Smolenskaya oblast\'"), (4278, 1177, "SVE", "Sverdlovskaya oblast\'"), (4279, 1177, "TAM", "Tambovskaya oblast\'"), (4280, 1177, "TOM", "Tomskaya oblast\'"), (4281, 1177, "TUL", "Tul\'skaya oblast\'"), (4282, 1177, "TVE", "Tverskaya oblast\'"), (4283, 1177, "TYU", "Tyumenskaya oblast\'"), (4284, 1177, "ULY", "Ul\'yanovskaya oblast\'"), (4285, 1177, "VLA", "Vladimirskaya oblast\'"), (4286, 1177, "VGG", "Volgogradskaya oblast\'"), (4287, 1177, "VLG", "Vologodskaya oblast\'"), (4288, 1177, "VOR", "Voronezhskaya oblast\'"), (4289, 1177, "YAR", "Yaroslavskaya oblast\'"), (4290, 1177, "MOW", "Moskva"), (4291, 1177, "SPE", "Sankt-Peterburg"), (4292, 1177, "YEV", "Yevreyskaya avtonomnaya oblast\'"), (4293, 1177, "AGB", "Aginskiy Buryatskiy avtonomnyy"), (4294, 1177, "CHU", "Chukotskiy avtonomnyy okrug"), (4295, 1177, "EVE", "Evenkiyskiy avtonomnyy okrug"), (4296, 1177, "KHM", "Khanty-Mansiyskiy avtonomnyy okrug"), (4297, 1177, "KOP", "Komi-Permyatskiy avtonomnyy okrug"), (4298, 1177, "KOR", "Koryakskiy avtonomnyy okrug"), (4299, 1177, "NEN", "Nenetskiy avtonomnyy okrug"), (4300, 1177, "TAY", "Taymyrskiy (Dolgano-Nenetskiy)"), (4301, 1177, "UOB", "Ust\'-Ordynskiy Buryatskiy"), (4302, 1177, "YAN", "Yamalo-Nenetskiy avtonomnyy okrug"), (4303, 1178, "C", "Butare"), (4304, 1178, "I", "Byumba"), (4305, 1178, "E", "Cyangugu"), (4306, 1178, "D", "Gikongoro"), (4307, 1178, "G", "Gisenyi"), (4308, 1178, "B", "Gitarama"), (4309, 1178, "J", "Kibungo"), (4310, 1178, "F", "Kibuye"), (4311, 1178, "K", "Kigali-Rural Kigali y\' Icyaro"), (4312, 1178, "L", "Kigali-Ville Kigali Ngari"), (4313, 1178, "M", "Mutara"), (4314, 1178, "H", "Ruhengeri"), (4315, 1187, "11", "Al Batah"), (4316, 1187, "08", "Al H,udd ash Shamallyah"), (4317, 1187, "12", "Al Jawf"), (4318, 1187, "03", "Al Madinah"), (4319, 1187, "05", "Al Qasim"), (4320, 1187, "01", "Ar Riyad"), (4321, 1187, "14", "Asir"), (4322, 1187, "06", "Ha\'il"), (4323, 1187, "09", "Jlzan"), (4324, 1187, "02", "Makkah"), (4325, 1187, "10", "Najran"), (4326, 1187, "07", "Tabuk"), (4327, 1194, "CT", "Capital Territory (Honiara)"), (4328, 1194, "GU", "Guadalcanal"), (4329, 1194, "IS", "Isabel"), (4330, 1194, "MK", "Makira"), (4331, 1194, "ML", "Malaita"), (4332, 1194, "TE", "Temotu"), (4333, 1200, "23", "A\'ali an Nil"), (4334, 1200, "26", "Al Bah al Ahmar"), (4335, 1200, "18", "Al Buhayrat"), (4336, 1200, "07", "Al Jazirah"), (4337, 1200, "03", "Al Khartum"), (4338, 1200, "06", "Al Qadarif"), (4339, 1200, "22", "Al Wahdah"), (4340, 1200, "04", "An Nil"), (4341, 1200, "08", "An Nil al Abyaq"), (4342, 1200, "24", "An Nil al Azraq"), (4343, 1200, "01", "Ash Shamallyah"), (4344, 1200, "17", "Bahr al Jabal"), (4345, 1200, "16", "Gharb al Istiwa\'iyah"), (4346, 1200, "14", "Gharb Ba~r al Ghazal"), (4347, 1200, "12", "Gharb Darfur"), (4348, 1200, "10", "Gharb Kurdufan"), (4349, 1200, "11", "Janub Darfur"), (4350, 1200, "13", "Janub Rurdufan"), (4351, 1200, "20", "Jnqall"), (4352, 1200, "05", "Kassala"), (4353, 1200, "15", "Shamal Batr al Ghazal"), (4354, 1200, "02", "Shamal Darfur"), (4355, 1200, "09", "Shamal Kurdufan"), (4356, 1200, "19", "Sharq al Istiwa\'iyah"), (4357, 1200, "25", "Sinnar"), (4358, 1200, "21", "Warab"), (4359, 1204, "K", "Blekinge lan"), (4360, 1204, "W", "Dalarnas lan"), (4361, 1204, "I", "Gotlands lan"), (4362, 1204, "X", "Gavleborge lan"), (4363, 1204, "N", "Hallands lan"), (4364, 1204, "Z", "Jamtlande lan"), (4365, 1204, "F", "Jonkopings lan"), (4366, 1204, "H", "Kalmar lan"), (4367, 1204, "G", "Kronoberge lan"), (4368, 1204, "BD", "Norrbottena lan"), (4369, 1204, "M", "Skane lan"), (4370, 1204, "AB", "Stockholms lan"), (4371, 1204, "D", "Sodermanlands lan"), (4372, 1204, "C", "Uppsala lan"), (4373, 1204, "S", "Varmlanda lan"), (4374, 1204, "AC", "Vasterbottens lan"), (4375, 1204, "Y", "Vasternorrlands lan"), (4376, 1204, "U", "Vastmanlanda lan"), (4377, 1204, "Q", "Vastra Gotalands lan"), (4378, 1204, "T", "Orebro lan"), (4379, 1204, "E", "Ostergotlands lan"), (4380, 1180, "SH", "Saint Helena"), (4381, 1180, "AC", "Ascension"), (4382, 1180, "TA", "Tristan da Cunha"), (4383, 1193, "001", "Ajdovscina"), (4384, 1193, "002", "Beltinci"), (4385, 1193, "148", "Benedikt"), (4386, 1193, "149", "Bistrica ob Sotli"), (4387, 1193, "003", "Bled"), (4388, 1193, "150", "Bloke"), (4389, 1193, "004", "Bohinj"), (4390, 1193, "005", "Borovnica"), (4391, 1193, "006", "Bovec"), (4392, 1193, "151", "Braslovce"), (4393, 1193, "007", "Brda"), (4394, 1193, "008", "Brezovica"), (4395, 1193, "009", "Brezica"), (4396, 1193, "152", "Cankova"), (4397, 1193, "011", "Celje"), (4398, 1193, "012", "Cerklje na Gorenjskem"), (4399, 1193, "013", "Cerknica"), (4400, 1193, "014", "Cerkno"), (4401, 1193, "153", "Cerkvenjak"), (4402, 1193, "015", "Crensovci"), (4403, 1193, "016", "Crna na Koroskem"), (4404, 1193, "017", "Crnomelj"), (4405, 1193, "018", "Destrnik"), (4406, 1193, "019", "Divaca"), (4407, 1193, "154", "Dobje"), (4408, 1193, "020", "Dobrepolje"), (4409, 1193, "155", "Dobrna"), (4410, 1193, "021", "Dobrova-Polhov Gradec"), (4411, 1193, "156", "Dobrovnik"), (4412, 1193, "022", "Dol pri Ljubljani"), (4413, 1193, "157", "Dolenjske Toplice"), (4414, 1193, "023", "Domzale"), (4415, 1193, "024", "Dornava"), (4416, 1193, "025", "Dravograd"), (4417, 1193, "026", "Duplek"), (4418, 1193, "027", "Gorenja vas-Poljane"), (4419, 1193, "028", "Gorsnica"), (4420, 1193, "029", "Gornja Radgona"), (4421, 1193, "030", "Gornji Grad"), (4422, 1193, "031", "Gornji Petrovci"), (4423, 1193, "158", "Grad"), (4424, 1193, "032", "Grosuplje"), (4425, 1193, "159", "Hajdina"), (4426, 1193, "160", "Hoce-Slivnica"), (4427, 1193, "161", "Hodos"), (4428, 1193, "162", "Jorjul"), (4429, 1193, "034", "Hrastnik"), (4430, 1193, "035", "Hrpelje-Kozina"), (4431, 1193, "036", "Idrija"), (4432, 1193, "037", "Ig"), (4433, 1193, "038", "IIrska Bistrica"), (4434, 1193, "039", "Ivancna Gorica"), (4435, 1193, "040", "Izola"), (4436, 1193, "041", "Jesenice"), (4437, 1193, "163", "Jezersko"), (4438, 1193, "042", "Jursinci"), (4439, 1193, "043", "Kamnik"), (4440, 1193, "044", "Kanal"), (4441, 1193, "045", "Kidricevo"), (4442, 1193, "046", "Kobarid"), (4443, 1193, "047", "Kobilje"), (4444, 1193, "048", "Jovevje"), (4445, 1193, "049", "Komen"), (4446, 1193, "164", "Komenda"), (4447, 1193, "050", "Koper"), (4448, 1193, "165", "Kostel"), (4449, 1193, "051", "Kozje"), (4450, 1193, "052", "Kranj"), (4451, 1193, "053", "Kranjska Gora"), (4452, 1193, "166", "Krizevci"), (4453, 1193, "054", "Krsko"), (4454, 1193, "055", "Kungota"), (4455, 1193, "056", "Kuzma"), (4456, 1193, "057", "Lasko"), (4457, 1193, "058", "Lenart"), (4458, 1193, "059", "Lendava"), (4459, 1193, "060", "Litija"), (4460, 1193, "061", "Ljubljana"), (4461, 1193, "062", "Ljubno"), (4462, 1193, "063", "Ljutomer"), (4463, 1193, "064", "Logatec"), (4464, 1193, "065", "Loska dolina"), (4465, 1193, "066", "Loski Potok"), (4466, 1193, "167", "Lovrenc na Pohorju"), (4467, 1193, "067", "Luce"), (4468, 1193, "068", "Lukovica"), (4469, 1193, "069", "Majsperk"), (4470, 1193, "070", "Maribor"), (4471, 1193, "168", "Markovci"), (4472, 1193, "071", "Medvode"), (4473, 1193, "072", "Menges"), (4474, 1193, "073", "Metlika"), (4475, 1193, "074", "Mezica"), (4476, 1193, "169", "Miklavz na Dravskern polju"), (4477, 1193, "075", "Miren-Kostanjevica"), (4478, 1193, "170", "Mirna Pec"), (4479, 1193, "076", "Mislinja"), (4480, 1193, "077", "Moravce"), (4481, 1193, "078", "Moravske Toplice"), (4482, 1193, "079", "Mozirje"), (4483, 1193, "080", "Murska Sobota"), (4484, 1193, "081", "Muta"), (4485, 1193, "082", "Naklo"), (4486, 1193, "083", "Nazarje"), (4487, 1193, "084", "Nova Gorica"), (4488, 1193, "085", "Nova mesto"), (4489, 1193, "181", "Sveta Ana"), (4490, 1193, "182", "Sveti Andraz v Slovenskih goricah"), (4491, 1193, "116", "Sveti Jurij"), (4492, 1193, "033", "Salovci"), (4493, 1193, "183", "Sempeter-Vrtojba"), (4494, 1193, "117", "Sencur"), (4495, 1193, "118", "Sentilj"), (4496, 1193, "119", "Sentjernej"), (4497, 1193, "120", "Sentjur pri Celju"), (4498, 1193, "121", "Skocjan"), (4499, 1193, "122", "Skofja Loka"), (4500, 1193, "123", "Skoftjica"), (4501, 1193, "124", "Smarje pri Jelsah"), (4502, 1193, "125", "Smartno ob Paki"), (4503, 1193, "194", "Smartno pri Litiji"), (4504, 1193, "126", "Sostanj"), (4505, 1193, "127", "Store"), (4506, 1193, "184", "Tabor"), (4507, 1193, "010", "Tisina"), (4508, 1193, "128", "Tolmin"), (4509, 1193, "129", "Trbovje"), (4510, 1193, "130", "Trebnje"), (4511, 1193, "185", "Trnovska vas"), (4512, 1193, "131", "Trzic"), (4513, 1193, "186", "Trzin"), (4514, 1193, "132", "Turnisce"), (4515, 1193, "133", "Velenje"), (4516, 1193, "187", "Velika Polana"), (4517, 1193, "134", "Velika Lasce"), (4518, 1193, "188", "Verzej"), (4519, 1193, "135", "Videm"), (4520, 1193, "136", "Vipava"), (4521, 1193, "137", "Vitanje"), (4522, 1193, "138", "Vojnik"), (4523, 1193, "189", "Vransko"), (4524, 1193, "140", "Vrhnika"), (4525, 1193, "141", "Vuzenica"), (4526, 1193, "142", "Zagorje ob Savi"), (4527, 1193, "143", "Zavrc"), (4528, 1193, "144", "Zrece"), (4529, 1193, "190", "Zalec"), (4530, 1193, "146", "Zelezniki"), (4531, 1193, "191", "Zetale"), (4532, 1193, "147", "Ziri"), (4533, 1193, "192", "Zirovnica"), (4534, 1193, "193", "Zuzemberk"), (4535, 1192, "BC", "Banskobystrický kraj"), (4536, 1192, "BL", "Bratislavský kraj"), (4537, 1192, "KI", "Košický kraj"), (4538, 1192, "NJ", "Nitriansky kraj"), (4539, 1192, "PV", "Prešovský kraj"), (4540, 1192, "TC", "Trenčiansky kraj"), (4541, 1192, "TA", "Trnavský kraj"), (4542, 1192, "ZI", "Žilinský kraj"), (4543, 1190, "W", "Western Area (Freetown)"), (4544, 1188, "DK", "Dakar"), (4545, 1188, "DB", "Diourbel"), (4546, 1188, "FK", "Fatick"), (4547, 1188, "KL", "Kaolack"), (4548, 1188, "KD", "Kolda"), (4549, 1188, "LG", "Louga"), (4550, 1188, "MT", "Matam"), (4551, 1188, "SL", "Saint-Louis"), (4552, 1188, "TC", "Tambacounda"), (4553, 1188, "TH", "Thies"), (4554, 1188, "ZG", "Ziguinchor"), (4555, 1195, "AW", "Awdal"), (4556, 1195, "BK", "Bakool"), (4557, 1195, "BN", "Banaadir"), (4558, 1195, "BY", "Bay"), (4559, 1195, "GA", "Galguduud"), (4560, 1195, "GE", "Gedo"), (4561, 1195, "HI", "Hiirsan"), (4562, 1195, "JD", "Jubbada Dhexe"), (4563, 1195, "JH", "Jubbada Hoose"), (4564, 1195, "MU", "Mudug"), (4565, 1195, "NU", "Nugaal"), (4566, 1195, "SA", "Saneag"), (4567, 1195, "SD", "Shabeellaha Dhexe"), (4568, 1195, "SH", "Shabeellaha Hoose"), (4569, 1195, "SO", "Sool"), (4570, 1195, "TO", "Togdheer"), (4571, 1195, "WO", "Woqooyi Galbeed"), (4572, 1201, "BR", "Brokopondo"), (4573, 1201, "CM", "Commewijne"), (4574, 1201, "CR", "Coronie"), (4575, 1201, "MA", "Marowijne"), (4576, 1201, "NI", "Nickerie"), (4577, 1201, "PM", "Paramaribo"), (4578, 1201, "SA", "Saramacca"), (4579, 1201, "SI", "Sipaliwini"), (4580, 1201, "WA", "Wanica"), (4581, 1207, "P", "Principe"), (4582, 1207, "S", "Sao Tome"), (4583, 1066, "AH", "Ahuachapan"), (4584, 1066, "CA", "Cabanas"), (4585, 1066, "CU", "Cuscatlan"), (4586, 1066, "CH", "Chalatenango"), (4587, 1066, "MO", "Morazan"), (4588, 1066, "SM", "San Miguel"), (4589, 1066, "SS", "San Salvador"), (4590, 1066, "SA", "Santa Ana"), (4591, 1066, "SV", "San Vicente"), (4592, 1066, "SO", "Sonsonate"), (4593, 1066, "US", "Usulutan"), (4594, 1206, "HA", "Al Hasakah"), (4595, 1206, "LA", "Al Ladhiqiyah"), (4596, 1206, "QU", "Al Qunaytirah"), (4597, 1206, "RA", "Ar Raqqah"), (4598, 1206, "SU", "As Suwayda\'"), (4599, 1206, "DR", "Dar\'a"), (4600, 1206, "DY", "Dayr az Zawr"), (4601, 1206, "DI", "Dimashq"), (4602, 1206, "HL", "Halab"), (4603, 1206, "HM", "Hamah"), (4604, 1206, "HI", "Jim\'"), (4605, 1206, "ID", "Idlib"), (4606, 1206, "RD", "Rif Dimashq"), (4607, 1206, "TA", "Tarts"), (4608, 1203, "HH", "Hhohho"), (4609, 1203, "LU", "Lubombo"), (4610, 1203, "MA", "Manzini"), (4611, 1203, "SH", "Shiselweni"), (4612, 1043, "BA", "Batha"), (4613, 1043, "BI", "Biltine"), (4614, 1043, "BET", "Borkou-Ennedi-Tibesti"), (4615, 1043, "CB", "Chari-Baguirmi"), (4616, 1043, "GR", "Guera"), (4617, 1043, "KA", "Kanem"), (4618, 1043, "LC", "Lac"), (4619, 1043, "LO", "Logone-Occidental"), (4620, 1043, "LR", "Logone-Oriental"), (4621, 1043, "MK", "Mayo-Kebbi"), (4622, 1043, "MC", "Moyen-Chari"), (4623, 1043, "OD", "Ouaddai"), (4624, 1043, "SA", "Salamat"), (4625, 1043, "TA", "Tandjile"), (4626, 1214, "K", "Kara"), (4627, 1214, "M", "Maritime (Region)"), (4628, 1214, "S", "Savannes"), (4629, 1211, "10", "Krung Thep Maha Nakhon Bangkok"), (4630, 1211, "S", "Phatthaya"), (4631, 1211, "37", "Amnat Charoen"), (4632, 1211, "15", "Ang Thong"), (4633, 1211, "31", "Buri Ram"), (4634, 1211, "24", "Chachoengsao"), (4635, 1211, "18", "Chai Nat"), (4636, 1211, "36", "Chaiyaphum"), (4637, 1211, "22", "Chanthaburi"), (4638, 1211, "50", "Chiang Mai"), (4639, 1211, "57", "Chiang Rai"), (4640, 1211, "20", "Chon Buri"), (4641, 1211, "86", "Chumphon"), (4642, 1211, "46", "Kalasin"), (4643, 1211, "62", "Kamphasng Phet"), (4644, 1211, "71", "Kanchanaburi"), (4645, 1211, "40", "Khon Kaen"), (4646, 1211, "81", "Krabi"), (4647, 1211, "52", "Lampang"), (4648, 1211, "51", "Lamphun"), (4649, 1211, "42", "Loei"), (4650, 1211, "16", "Lop Buri"), (4651, 1211, "58", "Mae Hong Son"), (4652, 1211, "44", "Maha Sarakham"), (4653, 1211, "49", "Mukdahan"), (4654, 1211, "26", "Nakhon Nayok"), (4655, 1211, "73", "Nakhon Pathom"), (4656, 1211, "48", "Nakhon Phanom"), (4657, 1211, "30", "Nakhon Ratchasima"), (4658, 1211, "60", "Nakhon Sawan"), (4659, 1211, "80", "Nakhon Si Thammarat"), (4660, 1211, "55", "Nan"), (4661, 1211, "96", "Narathiwat"), (4662, 1211, "39", "Nong Bua Lam Phu"), (4663, 1211, "43", "Nong Khai"), (4664, 1211, "12", "Nonthaburi"), (4665, 1211, "13", "Pathum Thani"), (4666, 1211, "94", "Pattani"), (4667, 1211, "82", "Phangnga"), (4668, 1211, "93", "Phatthalung"), (4669, 1211, "56", "Phayao"), (4670, 1211, "67", "Phetchabun"), (4671, 1211, "76", "Phetchaburi"), (4672, 1211, "66", "Phichit"), (4673, 1211, "65", "Phitsanulok"), (4674, 1211, "54", "Phrae"), (4675, 1211, "14", "Phra Nakhon Si Ayutthaya"), (4676, 1211, "83", "Phaket"), (4677, 1211, "25", "Prachin Buri"), (4678, 1211, "77", "Prachuap Khiri Khan"), (4679, 1211, "85", "Ranong"), (4680, 1211, "70", "Ratchaburi"), (4681, 1211, "21", "Rayong"), (4682, 1211, "45", "Roi Et"), (4683, 1211, "27", "Sa Kaeo"), (4684, 1211, "47", "Sakon Nakhon"), (4685, 1211, "11", "Samut Prakan"), (4686, 1211, "74", "Samut Sakhon"), (4687, 1211, "75", "Samut Songkhram"), (4688, 1211, "19", "Saraburi"), (4689, 1211, "91", "Satun"), (4690, 1211, "17", "Sing Buri"), (4691, 1211, "33", "Si Sa Ket"), (4692, 1211, "90", "Songkhla"), (4693, 1211, "64", "Sukhothai"), (4694, 1211, "72", "Suphan Buri"), (4695, 1211, "84", "Surat Thani"), (4696, 1211, "32", "Surin"), (4697, 1211, "63", "Tak"), (4698, 1211, "92", "Trang"), (4699, 1211, "23", "Trat"), (4700, 1211, "34", "Ubon Ratchathani"), (4701, 1211, "41", "Udon Thani"), (4702, 1211, "61", "Uthai Thani"), (4703, 1211, "53", "Uttaradit"), (4704, 1211, "95", "Yala"), (4705, 1211, "35", "Yasothon"), (4706, 1209, "SU", "Sughd"), (4707, 1209, "KT", "Khatlon"), (4708, 1209, "GB", "Gorno-Badakhshan"), (4709, 1220, "A", "Ahal"), (4710, 1220, "B", "Balkan"), (4711, 1220, "D", "Dasoguz"), (4712, 1220, "L", "Lebap"), (4713, 1220, "M", "Mary"), (4714, 1218, "31", "Béja"), (4715, 1218, "13", "Ben Arous"), (4716, 1218, "23", "Bizerte"), (4717, 1218, "81", "Gabès"), (4718, 1218, "71", "Gafsa"), (4719, 1218, "32", "Jendouba"), (4720, 1218, "41", "Kairouan"), (4721, 1218, "42", "Rasserine"), (4722, 1218, "73", "Kebili"), (4723, 1218, "12", "L\'Ariana"), (4724, 1218, "33", "Le Ref"), (4725, 1218, "53", "Mahdia"), (4726, 1218, "14", "La Manouba"), (4727, 1218, "82", "Medenine"), (4728, 1218, "52", "Moneatir"), (4729, 1218, "21", "Naboul"), (4730, 1218, "61", "Sfax"), (4731, 1218, "43", "Sidi Bouxid"), (4732, 1218, "34", "Siliana"), (4733, 1218, "51", "Sousse"), (4734, 1218, "83", "Tataouine"), (4735, 1218, "72", "Tozeur"), (4736, 1218, "11", "Tunis"), (4737, 1218, "22", "Zaghouan"), (4738, 1219, "01", "Adana"), (4739, 1219, "02", "Ad yaman"), (4740, 1219, "03", "Afyon"), (4741, 1219, "04", "Ag r"), (4742, 1219, "68", "Aksaray"), (4743, 1219, "05", "Amasya"), (4744, 1219, "06", "Ankara"), (4745, 1219, "07", "Antalya"), (4746, 1219, "75", "Ardahan"), (4747, 1219, "08", "Artvin"), (4748, 1219, "09", "Aydin"), (4749, 1219, "10", "Bal kesir"), (4750, 1219, "74", "Bartin"), (4751, 1219, "72", "Batman"), (4752, 1219, "69", "Bayburt"), (4753, 1219, "11", "Bilecik"), (4754, 1219, "12", "Bingol"), (4755, 1219, "13", "Bitlis"), (4756, 1219, "14", "Bolu"), (4757, 1219, "15", "Burdur"), (4758, 1219, "16", "Bursa"), (4759, 1219, "17", "Canakkale"), (4760, 1219, "18", "Cankir"), (4761, 1219, "19", "Corum"), (4762, 1219, "20", "Denizli"), (4763, 1219, "21", "Diyarbakir"), (4764, 1219, "81", "Duzce"), (4765, 1219, "22", "Edirne"), (4766, 1219, "23", "Elazig"), (4767, 1219, "24", "Erzincan"), (4768, 1219, "25", "Erzurum"), (4769, 1219, "26", "Eskis\'ehir"), (4770, 1219, "27", "Gaziantep"), (4771, 1219, "28", "Giresun"), (4772, 1219, "29", "Gms\'hane"), (4773, 1219, "30", "Hakkari"), (4774, 1219, "31", "Hatay"), (4775, 1219, "76", "Igidir"), (4776, 1219, "32", "Isparta"), (4777, 1219, "33", "Icel"), (4778, 1219, "34", "Istanbul"), (4779, 1219, "35", "Izmir"), (4780, 1219, "46", "Kahramanmaras"), (4781, 1219, "78", "Karabk"), (4782, 1219, "70", "Karaman"), (4783, 1219, "36", "Kars"), (4784, 1219, "37", "Kastamonu"), (4785, 1219, "38", "Kayseri"), (4786, 1219, "71", "Kirikkale"), (4787, 1219, "39", "Kirklareli"), (4788, 1219, "40", "Kirs\'ehir"), (4789, 1219, "79", "Kilis"), (4790, 1219, "41", "Kocaeli"), (4791, 1219, "42", "Konya"), (4792, 1219, "43", "Ktahya"), (4793, 1219, "44", "Malatya"), (4794, 1219, "45", "Manisa"), (4795, 1219, "47", "Mardin"), (4796, 1219, "48", "Mugila"), (4797, 1219, "49", "Mus"), (4798, 1219, "50", "Nevs\'ehir"), (4799, 1219, "51", "Nigide"), (4800, 1219, "52", "Ordu"), (4801, 1219, "80", "Osmaniye"), (4802, 1219, "53", "Rize"), (4803, 1219, "54", "Sakarya"), (4804, 1219, "55", "Samsun"), (4805, 1219, "56", "Siirt"), (4806, 1219, "57", "Sinop"), (4807, 1219, "58", "Sivas"), (4808, 1219, "63", "S\'anliurfa"), (4809, 1219, "73", "S\'rnak"), (4810, 1219, "59", "Tekirdag"), (4811, 1219, "60", "Tokat"), (4812, 1219, "61", "Trabzon"), (4813, 1219, "62", "Tunceli"), (4814, 1219, "64", "Us\'ak"), (4815, 1219, "65", "Van"), (4816, 1219, "77", "Yalova"), (4817, 1219, "66", "Yozgat"), (4818, 1219, "67", "Zonguldak"), (4819, 1217, "CTT", "Couva-Tabaquite-Talparo"), (4820, 1217, "DMN", "Diego Martin"), (4821, 1217, "ETO", "Eastern Tobago"), (4822, 1217, "PED", "Penal-Debe"), (4823, 1217, "PRT", "Princes Town"), (4824, 1217, "RCM", "Rio Claro-Mayaro"), (4825, 1217, "SGE", "Sangre Grande"), (4826, 1217, "SJL", "San Juan-Laventille"), (4827, 1217, "SIP", "Siparia"), (4828, 1217, "TUP", "Tunapuna-Piarco"), (4829, 1217, "WTO", "Western Tobago"), (4830, 1217, "ARI", "Arima"), (4831, 1217, "CHA", "Chaguanas"), (4832, 1217, "PTF", "Point Fortin"), (4833, 1217, "POS", "Port of Spain"), (4834, 1217, "SFO", "San Fernando"), (4835, 1063, "AL", "Aileu"), (4836, 1063, "AN", "Ainaro"), (4837, 1063, "BA", "Bacucau"), (4838, 1063, "BO", "Bobonaro"), (4839, 1063, "CO", "Cova Lima"), (4840, 1063, "DI", "Dili"), (4841, 1063, "ER", "Ermera"), (4842, 1063, "LA", "Laulem"), (4843, 1063, "LI", "Liquica"), (4844, 1063, "MT", "Manatuto"), (4845, 1063, "MF", "Manafahi"), (4846, 1063, "OE", "Oecussi"), (4847, 1063, "VI", "Viqueque"), (4848, 1208, "CHA", "Changhua"), (4849, 1208, "CYQ", "Chiayi"), (4850, 1208, "HSQ", "Hsinchu"), (4851, 1208, "HUA", "Hualien"), (4852, 1208, "ILA", "Ilan"), (4853, 1208, "KHQ", "Kaohsiung"), (4854, 1208, "MIA", "Miaoli"), (4855, 1208, "NAN", "Nantou"), (4856, 1208, "PEN", "Penghu"), (4857, 1208, "PIF", "Pingtung"), (4858, 1208, "TXQ", "Taichung"), (4859, 1208, "TNQ", "Tainan"), (4860, 1208, "TPQ", "Taipei"), (4861, 1208, "TTT", "Taitung"), (4862, 1208, "TAO", "Taoyuan"), (4863, 1208, "YUN", "Yunlin"), (4864, 1208, "KEE", "Keelung"), (4865, 1210, "01", "Arusha"), (4866, 1210, "02", "Dar-es-Salaam"), (4867, 1210, "03", "Dodoma"), (4868, 1210, "04", "Iringa"), (4869, 1210, "05", "Kagera"), (4870, 1210, "06", "Kaskazini Pemba"), (4871, 1210, "07", "Kaskazini Unguja"), (4872, 1210, "08", "Xigoma"), (4873, 1210, "09", "Kilimanjaro"), (4874, 1210, "10", "Rusini Pemba"), (4875, 1210, "11", "Kusini Unguja"), (4876, 1210, "12", "Lindi"), (4877, 1210, "26", "Manyara"), (4878, 1210, "13", "Mara"), (4879, 1210, "14", "Mbeya"), (4880, 1210, "15", "Mjini Magharibi"), (4881, 1210, "16", "Morogoro"), (4882, 1210, "17", "Mtwara"), (4883, 1210, "19", "Pwani"), (4884, 1210, "20", "Rukwa"), (4885, 1210, "21", "Ruvuma"), (4886, 1210, "22", "Shinyanga"), (4887, 1210, "23", "Singida"), (4888, 1210, "24", "Tabora"), (4889, 1210, "25", "Tanga"), (4890, 1224, "71", "Cherkas\'ka Oblast\'"), (4891, 1224, "74", "Chernihivs\'ka Oblast\'"), (4892, 1224, "77", "Chernivets\'ka Oblast\'"), (4893, 1224, "12", "Dnipropetrovs\'ka Oblast\'"), (4894, 1224, "14", "Donets\'ka Oblast\'"), (4895, 1224, "26", "Ivano-Frankivs\'ka Oblast\'"), (4896, 1224, "63", "Kharkivs\'ka Oblast\'"), (4897, 1224, "65", "Khersons\'ka Oblast\'"), (4898, 1224, "68", "Khmel\'nyts\'ka Oblast\'"), (4899, 1224, "35", "Kirovohrads\'ka Oblast\'"), (4900, 1224, "32", "Kyivs\'ka Oblast\'"), (4901, 1224, "09", "Luhans\'ka Oblast\'"), (4902, 1224, "46", "L\'vivs\'ka Oblast\'"), (4903, 1224, "48", "Mykolaivs\'ka Oblast\'"), (4904, 1224, "51", "Odes \'ka Oblast\'"), (4905, 1224, "53", "Poltavs\'ka Oblast\'"), (4906, 1224, "56", "Rivnens\'ka Oblast\'"), (4907, 1224, "59", "Sums \'ka Oblast\'"), (4908, 1224, "61", "Ternopil\'s\'ka Oblast\'"), (4909, 1224, "05", "Vinnyts\'ka Oblast\'"), (4910, 1224, "07", "Volyos\'ka Oblast\'"), (4911, 1224, "21", "Zakarpats\'ka Oblast\'"), (4912, 1224, "23", "Zaporiz\'ka Oblast\'"), (4913, 1224, "18", "Zhytomyrs\'ka Oblast\'"), (4914, 1224, "43", "Respublika Krym"), (4915, 1224, "30", "Kyiv"), (4916, 1224, "40", "Sevastopol"), (4917, 1223, "301", "Adjumani"), (4918, 1223, "302", "Apac"), (4919, 1223, "303", "Arua"), (4920, 1223, "201", "Bugiri"), (4921, 1223, "401", "Bundibugyo"), (4922, 1223, "402", "Bushenyi"), (4923, 1223, "202", "Busia"), (4924, 1223, "304", "Gulu"), (4925, 1223, "403", "Hoima"), (4926, 1223, "203", "Iganga"), (4927, 1223, "204", "Jinja"), (4928, 1223, "404", "Kabale"), (4929, 1223, "405", "Kabarole"), (4930, 1223, "213", "Kaberamaido"), (4931, 1223, "101", "Kalangala"), (4932, 1223, "102", "Kampala"), (4933, 1223, "205", "Kamuli"), (4934, 1223, "413", "Kamwenge"), (4935, 1223, "414", "Kanungu"), (4936, 1223, "206", "Kapchorwa"), (4937, 1223, "406", "Kasese"), (4938, 1223, "207", "Katakwi"), (4939, 1223, "112", "Kayunga"), (4940, 1223, "407", "Kibaale"), (4941, 1223, "103", "Kiboga"), (4942, 1223, "408", "Kisoro"), (4943, 1223, "305", "Kitgum"), (4944, 1223, "306", "Kotido"), (4945, 1223, "208", "Kumi"), (4946, 1223, "415", "Kyenjojo"), (4947, 1223, "307", "Lira"), (4948, 1223, "104", "Luwero"), (4949, 1223, "105", "Masaka"), (4950, 1223, "409", "Masindi"), (4951, 1223, "214", "Mayuge"), (4952, 1223, "209", "Mbale"), (4953, 1223, "410", "Mbarara"), (4954, 1223, "308", "Moroto"), (4955, 1223, "309", "Moyo"), (4956, 1223, "106", "Mpigi"), (4957, 1223, "107", "Mubende"), (4958, 1223, "108", "Mukono"), (4959, 1223, "311", "Nakapiripirit"), (4960, 1223, "109", "Nakasongola"), (4961, 1223, "310", "Nebbi"), (4962, 1223, "411", "Ntungamo"), (4963, 1223, "312", "Pader"), (4964, 1223, "210", "Pallisa"), (4965, 1223, "110", "Rakai"), (4966, 1223, "412", "Rukungiri"), (4967, 1223, "111", "Sembabule"), (4968, 1223, "215", "Sironko"), (4969, 1223, "211", "Soroti"), (4970, 1223, "212", "Tororo"), (4971, 1223, "113", "Wakiso"), (4972, 1223, "313", "Yumbe"), (4973, 1227, "81", "Baker Island"), (4974, 1227, "84", "Howland Island"), (4975, 1227, "86", "Jarvis Island"), (4976, 1227, "67", "Johnston Atoll"), (4977, 1227, "89", "Kingman Reef"), (4978, 1227, "71", "Midway Islands"), (4979, 1227, "76", "Navassa Island"), (4980, 1227, "95", "Palmyra Atoll"), (4981, 1227, "79", "Wake Ialand"), (4982, 1229, "AR", "Artigsa"), (4983, 1229, "CA", "Canelones"), (4984, 1229, "CL", "Cerro Largo"), (4985, 1229, "CO", "Colonia"), (4986, 1229, "DU", "Durazno"), (4987, 1229, "FS", "Flores"), (4988, 1229, "LA", "Lavalleja"), (4989, 1229, "MA", "Maldonado"), (4990, 1229, "MO", "Montevideo"), (4991, 1229, "PA", "Paysandu"), (4992, 1229, "RV", "Rivera"), (4993, 1229, "RO", "Rocha"), (4994, 1229, "SA", "Salto"), (4995, 1229, "SO", "Soriano"), (4996, 1229, "TA", "Tacuarembo"), (4997, 1229, "TT", "Treinta y Tres"), (4998, 1230, "TK", "Toshkent (city)"), (4999, 1230, "QR", "Qoraqalpogiston Respublikasi"), (5000, 1230, "AN", "Andijon"), (5001, 1230, "BU", "Buxoro"), (5002, 1230, "FA", "Farg\'ona"), (5003, 1230, "JI", "Jizzax"), (5004, 1230, "KH", "Khorazm"), (5005, 1230, "NG", "Namangan"), (5006, 1230, "NW", "Navoiy"), (5007, 1230, "QA", "Qashqadaryo"), (5008, 1230, "SA", "Samarqand"), (5009, 1230, "SI", "Sirdaryo"), (5010, 1230, "SU", "Surxondaryo"), (5011, 1230, "TO", "Toshkent"), (5012, 1230, "XO", "Xorazm"), (5013, 1232, "A", "Diatrito Federal"), (5014, 1232, "B", "Anzoategui"), (5015, 1232, "C", "Apure"), (5016, 1232, "D", "Aragua"), (5017, 1232, "E", "Barinas"), (5018, 1232, "G", "Carabobo"), (5019, 1232, "H", "Cojedes"), (5020, 1232, "I", "Falcon"), (5021, 1232, "J", "Guarico"), (5022, 1232, "K", "Lara"), (5023, 1232, "L", "Merida"), (5024, 1232, "M", "Miranda"), (5025, 1232, "N", "Monagas"), (5026, 1232, "O", "Nueva Esparta"), (5027, 1232, "P", "Portuguesa"), (5028, 1232, "S", "Tachira"), (5029, 1232, "T", "Trujillo"), (5030, 1232, "X", "Vargas"), (5031, 1232, "U", "Yaracuy"), (5032, 1232, "V", "Zulia"), (5033, 1232, "Y", "Delta Amacuro"), (5034, 1232, "W", "Dependencias Federales"), (5035, 1233, "44", "An Giang"), (5036, 1233, "43", "Ba Ria - Vung Tau"), (5037, 1233, "53", "Bac Can"), (5038, 1233, "54", "Bac Giang"), (5039, 1233, "55", "Bac Lieu"), (5040, 1233, "56", "Bac Ninh"), (5041, 1233, "50", "Ben Tre"), (5042, 1233, "31", "Binh Dinh"), (5043, 1233, "57", "Binh Duong"), (5044, 1233, "58", "Binh Phuoc"), (5045, 1233, "40", "Binh Thuan"), (5046, 1233, "59", "Ca Mau"), (5047, 1233, "48", "Can Tho"), (5048, 1233, "04", "Cao Bang"), (5049, 1233, "60", "Da Nang, thanh pho"), (5050, 1233, "39", "Dong Nai"), (5051, 1233, "45", "Dong Thap"), (5052, 1233, "30", "Gia Lai"), (5053, 1233, "03", "Ha Giang"), (5054, 1233, "63", "Ha Nam"), (5055, 1233, "64", "Ha Noi, thu do"), (5056, 1233, "15", "Ha Tay"), (5057, 1233, "23", "Ha Tinh"), (5058, 1233, "61", "Hai Duong"), (5059, 1233, "62", "Hai Phong, thanh pho"), (5060, 1233, "14", "Hoa Binh"), (5061, 1233, "65", "Ho Chi Minh, thanh pho [Sai Gon]"), (5062, 1233, "66", "Hung Yen"), (5063, 1233, "34", "Khanh Hoa"), (5064, 1233, "47", "Kien Giang"), (5065, 1233, "28", "Kon Tum"), (5066, 1233, "01", "Lai Chau"), (5067, 1233, "35", "Lam Dong"), (5068, 1233, "09", "Lang Son"), (5069, 1233, "02", "Lao Cai"), (5070, 1233, "41", "Long An"), (5071, 1233, "67", "Nam Dinh"), (5072, 1233, "22", "Nghe An"), (5073, 1233, "18", "Ninh Binh"), (5074, 1233, "36", "Ninh Thuan"), (5075, 1233, "68", "Phu Tho"), (5076, 1233, "32", "Phu Yen"), (5077, 1233, "24", "Quang Binh"), (5078, 1233, "27", "Quang Nam"), (5079, 1233, "29", "Quang Ngai"), (5080, 1233, "13", "Quang Ninh"), (5081, 1233, "25", "Quang Tri"), (5082, 1233, "52", "Soc Trang"), (5083, 1233, "05", "Son La"), (5084, 1233, "37", "Tay Ninh"), (5085, 1233, "20", "Thai Binh"), (5086, 1233, "69", "Thai Nguyen"), (5087, 1233, "21", "Thanh Hoa"), (5088, 1233, "26", "Thua Thien-Hue"), (5089, 1233, "46", "Tien Giang"), (5090, 1233, "51", "Tra Vinh"), (5091, 1233, "07", "Tuyen Quang"), (5092, 1233, "49", "Vinh Long"), (5093, 1233, "70", "Vinh Phuc"), (5094, 1233, "06", "Yen Bai"), (5095, 1231, "MAP", "Malampa"), (5096, 1231, "PAM", "Penama"), (5097, 1231, "SAM", "Sanma"), (5098, 1231, "SEE", "Shefa"), (5099, 1231, "TAE", "Tafea"), (5100, 1231, "TOB", "Torba"), (5101, 1185, "AA", "A\'ana"), (5102, 1185, "AL", "Aiga-i-le-Tai"), (5103, 1185, "AT", "Atua"), (5104, 1185, "FA", "Fa\'aaaleleaga"), (5105, 1185, "GE", "Gaga\'emauga"), (5106, 1185, "GI", "Gagaifomauga"), (5107, 1185, "PA", "Palauli"), (5108, 1185, "SA", "Satupa\'itea"), (5109, 1185, "TU", "Tuamasaga"), (5110, 1185, "VF", "Va\'a-o-Fonoti"), (5111, 1185, "VS", "Vaisigano"), (5112, 1238, "CG", "Crna Gora"), (5113, 1238, "SR", "Srbija"), (5114, 1238, "KM", "Kosovo-Metohija"), (5115, 1238, "VO", "Vojvodina"), (5116, 1237, "AB", "Abyan"), (5117, 1237, "AD", "Adan"), (5118, 1237, "DA", "Ad Dali"), (5119, 1237, "BA", "Al Bayda\'"), (5120, 1237, "MU", "Al Hudaydah"), (5121, 1237, "MR", "Al Mahrah"), (5122, 1237, "MW", "Al Mahwit"), (5123, 1237, "AM", "Amran"), (5124, 1237, "DH", "Dhamar"), (5125, 1237, "HD", "Hadramawt"), (5126, 1237, "HJ", "Hajjah"), (5127, 1237, "IB", "Ibb"), (5128, 1237, "LA", "Lahij"), (5129, 1237, "MA", "Ma\'rib"), (5130, 1237, "SD", "Sa\'dah"), (5131, 1237, "SN", "San\'a\'"), (5132, 1237, "SH", "Shabwah"), (5133, 1237, "TA", "Ta\'izz"), (5134, 1196, "EC", "Eastern Cape"), (5135, 1196, "FS", "Free State"), (5136, 1196, "GT", "Gauteng"), (5137, 1196, "NL", "Kwazulu-Natal"), (5138, 1196, "MP", "Mpumalanga"), (5139, 1196, "NC", "Northern Cape"), (5140, 1196, "NP", "Limpopo"), (5141, 1196, "WC", "Western Cape"), (5142, 1239, "08", "Copperbelt"), (5143, 1239, "04", "Luapula"), (5144, 1239, "09", "Lusaka"), (5145, 1239, "06", "North-Western"), (5146, 1240, "BU", "Bulawayo"), (5147, 1240, "HA", "Harare"), (5148, 1240, "MA", "Manicaland"), (5149, 1240, "MC", "Mashonaland Central"), (5150, 1240, "ME", "Mashonaland East"), (5151, 1240, "MW", "Mashonaland West"), (5152, 1240, "MV", "Masvingo"), (5153, 1240, "MN", "Matabeleland North"), (5154, 1240, "MS", "Matabeleland South"), (5155, 1240, "MI", "Midlands"); # insert some data for domain, reserved location_types, and reserved relationship_types # INSERT INTO civicrm_domain( name, contact_name, email_domain ) VALUES ( 'CRM Test Domain', 'Mr System Administrator', 'FIXME.ORG' ); INSERT INTO civicrm_location_type( domain_id, name, vcard_name, description, is_reserved, is_active ) VALUES( 1, 'Home', 'HOME', 'Place of residence', 0, 1 ); INSERT INTO civicrm_location_type( domain_id, name, vcard_name, description, is_reserved, is_active, is_default ) VALUES( 1, 'Work', 'WORK', 'Work location', 0, 1, 1 ); INSERT INTO civicrm_location_type( domain_id, name, vcard_name, description, is_reserved, is_active ) VALUES( 1, 'Main', NULL, 'Main office location', 0, 1 ); INSERT INTO civicrm_location_type( domain_id, name, vcard_name, description, is_reserved, is_active ) VALUES( 1, 'Other', NULL, 'Another location', 0, 1 ); INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved ) VALUES( 1, 'Child of', 'Parent of', 'Parent/child relationship.', 'Individual', 'Individual', 0 ); INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved ) VALUES( 1, 'Spouse of', 'Spouse of', 'Spousal relationship.', 'Individual', 'Individual', 0 ); INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved ) VALUES( 1, 'Sibling of','Sibling of', 'Sibling relationship.','Individual','Individual', 0 ); INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved ) VALUES( 1, 'Employee of', 'Employer of', 'Employment relationship.','Individual','Organization', 0 ); INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved ) VALUES( 1, 'Volunteer for', 'Volunteer is', 'Volunteer relationship.','Individual','Organization', 0 ); INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved ) VALUES( 1, 'Head of Household for', 'Head of Household is', 'Head of household.','Individual','Household', 0 ); INSERT INTO civicrm_relationship_type( domain_id, name_a_b, name_b_a, description, contact_type_a, contact_type_b, is_reserved ) VALUES( 1, 'Household Member of', 'Household Member is', 'Household membership.','Individual','Household', 0 ); -- Sample Tags INSERT INTO civicrm_tag( domain_id, name, description, parent_id ) VALUES( 1, 'Non-profit', 'Any not-for-profit organization.', NULL ); INSERT INTO civicrm_tag( domain_id, name, description, parent_id ) VALUES( 1, 'Company', 'For-profit organization.', NULL ); INSERT INTO civicrm_tag( domain_id, name, description, parent_id ) VALUES( 1, 'Government Entity', 'Any governmental entity.', NULL ); INSERT INTO civicrm_tag( domain_id, name, description, parent_id ) VALUES( 1, 'Major Donor', 'High-value supporter of our organization.', NULL ); INSERT INTO civicrm_tag( domain_id, name, description, parent_id ) VALUES( 1, 'Volunteer', 'Active volunteers.', NULL ); INSERT INTO civicrm_im_provider(name, domain_id, is_reserved, is_active) VALUES('Yahoo', 1, 0, 1); INSERT INTO civicrm_im_provider(name, domain_id, is_reserved, is_active) VALUES('MSN', 1, 0, 1); INSERT INTO civicrm_im_provider(name, domain_id, is_reserved, is_active) VALUES('AIM', 1, 0, 1); INSERT INTO civicrm_im_provider(name, domain_id, is_reserved, is_active) VALUES('GTalk', 1, 0, 1); INSERT INTO civicrm_im_provider(name, domain_id, is_reserved, is_active) VALUES('Jabber', 1, 0, 1); INSERT INTO civicrm_im_provider(name, domain_id, is_reserved, is_active) VALUES('Skype', 1, 0, 1); INSERT INTO civicrm_mobile_provider (name, domain_id, is_reserved, is_active) VALUES ('Sprint', 1, 0, 1); INSERT INTO civicrm_mobile_provider (name, domain_id, is_reserved, is_active) VALUES ('Verizon', 1, 0, 1); INSERT INTO civicrm_mobile_provider (name, domain_id, is_reserved, is_active) VALUES ('Cingular', 1, 0, 1); INSERT INTO civicrm_county (name, state_province_id) VALUES ('Alameda', 1004); INSERT INTO civicrm_county (name, state_province_id) VALUES ('Contra Costa', 1004); INSERT INTO civicrm_county (name, state_province_id) VALUES ('Marin', 1004); INSERT INTO civicrm_county (name, state_province_id) VALUES ('San Francisco', 1004); INSERT INTO civicrm_county (name, state_province_id) VALUES ('San Mateo', 1004); INSERT INTO civicrm_county (name, state_province_id) VALUES ('Santa Clara', 1004); INSERT INTO civicrm_geo_coord (id, coord_type, coord_units, coord_ogc_wkt_string) VALUES (1, 'LatLong', 'Degree', 31); -- Bounce classification patterns INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('AOL', 'AOL Terms of Service complaint', 1); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (1, 'Client TOS Notification'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Away', 'Recipient is on vacation', 3); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (2, '(be|am)? (out of|away from) (the|my)? (office|computer|town)'), (2, 'i am on vacation'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Dns', 'Unable to resolve recipient domain', 3); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (3, 'name(server entry| lookup failure)'), (3, 'no (mail server|matches to nameserver query|dns entries)'), (3, 'reverse dns entry'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Host', 'Unable to deliver to destintation mail server', 3); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (4, '(unknown|not local) host'), (4, 'all hosts have been failing'), (4, 'allowed rcpthosts'), (4, 'connection (refused|timed out)'), (4, 'couldn\'t find any host named'), (4, 'error involving remote host'), (4, 'host unknown'), (4, 'invalid host name'), (4, 'isn\'t in my control/locals file'), (4, 'local configuration error'), (4, 'not a gateway'), (4, 'server is down or unreachable'), (4, 'too many connections'), (4, 'unable to connect'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Inactive', 'User account is no longer active', 1); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (5, '(my )?e-?mail( address)? has changed'), (5, 'account (inactive|expired|deactivated)'), (5, 'account is locked'), (5, 'changed \w+( e-?mail)? address'), (5, 'deactivated mailbox'), (5, 'disabled or discontinued'), (5, 'inactive user'), (5, 'is inactive on this domain'), (5, 'mail receiving disabled'), (5, 'mail( ?)address is administrative?ly disabled'), (5, 'mailbox (temporarily disabled|currently suspended)'), (5, 'no longer (accepting mail|on server|in use|with|employed|on staff|works for|using this account)'), (5, 'not accepting mail'), (5, 'please use my new e-?mail address'), (5, 'this address no longer accepts mail'), (5, 'user account suspended'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Invalid', 'Email address is not valid', 1); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (6, '(user|recipient( name)?) is not recognized'), (6, '554 delivery error'), (6, 'address does not exist'), (6, 'address(es)? could not be found'), (6, 'addressee unknown'), (6, 'bad destination'), (6, 'badly formatted address'), (6, 'can\'t open mailbox for'), (6, 'cannot deliver'), (6, 'delivery to the following recipients failed'), (6, 'destination addresses were unknown'), (6, 'did not reach the following recipient'), (6, 'does not exist'), (6, 'does not like recipient'), (6, 'does not specify a valid notes mail file'), (6, 'illegal alias'), (6, 'invalid (mailbox|(e-?mail )?address|recipient|final delivery)'), (6, 'invalid( or unknown)?( virtual)? user'), (6, 'mail delivery to this user is not allowed'), (6, 'mailbox (not found|unavailable|name not allowed)'), (6, 'message could not be forwarded'), (6, 'missing or malformed local(-| )part'), (6, 'no e-?mail address registered'), (6, 'no such (mail drop|mailbox( \w+)?|(e-?mail )?address|recipient|(local )?user)( here)?'), (6, 'no mailbox here by that name'), (6, 'not (listed in|found in directory|known at this site|our customer)'), (6, 'not a valid( (user|mailbox))?'), (6, 'not present in directory entry'), (6, 'recipient (does not exist|(is )?unknown)'), (6, 'this user doesn\'t have a yahoo.com address'), (6, 'unavailable to take delivery of the message'), (6, 'unavailable mailbox'), (6, 'unknown (local( |-)part|recipient)'), (6, 'unknown( or illegal)? user( account)?'), (6, 'unrecognized recipient'), (6, 'unregistered address'), (6, 'user (unknown|does not exist)'), (6, 'user doesn\'t have an? \w+ account'), (6, 'user(\'s e-?mail name is)? not found'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Loop', 'Mail routing error', 3); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (7, '(mail|routing) loop'), (7, 'excessive recursion'), (7, 'loop detected'), (7, 'maximum hop count exceeded'), (7, 'message was forwarded more than the maximum allowed times'), (7, 'too many hops'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Quota', 'User inbox is full', 3); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (8, '(disk|over the allowed|exceed(ed|s)?|storage) quota'), (8, '522_mailbox_full'), (8, 'exceeds allowed message count'), (8, 'file too large'), (8, 'full mailbox'), (8, 'mailbox ((for user \w+ )?is )?full'), (8, 'mailbox has exceeded the limit'), (8, 'mailbox( exceeds allowed)? size'), (8, 'no space left for this user'), (8, 'over\s?quota'), (8, 'quota (for the mailbox )?has been exceeded'), (8, 'quota (usage|violation|exceeded)'), (8, 'recipient storage full'), (8, 'not able to receive more mail'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Relay', 'Unable to reach destination mail server', 3); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (9, 'cannot find your hostname'), (9, 'ip name lookup'), (9, 'not configured to relay mail'), (9, 'relay (not permitted|access denied)'), (9, 'relayed mail to .+? not allowed'), (9, 'sender ip must resolve'), (9, 'unable to relay'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Spam', 'Message caught by a content filter', 1); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (10, '(bulk( e-?mail)|content|attachment blocking|virus|mail system) filters?'), (10, '(hostile|questionable|unacceptable) content'), (10, 'address .+? has not been verified'), (10, 'anti-?spam (polic\w+|software)'), (10, 'anti-?virus gateway has detected'), (10, 'blacklisted'), (10, 'blocked message'), (10, 'content control'), (10, 'delivery not authorized'), (10, 'does not conform to our e-?mail policy'), (10, 'excessive spam content'), (10, 'message looks suspicious'), (10, 'open relay'), (10, 'sender was rejected'), (10, 'spam(check| reduction software| filters?)'), (10, 'blocked by a user configured filter'), (10, 'detected as spam'); INSERT INTO civicrm_mailing_bounce_type (name, description, hold_threshold) VALUES ('Syntax', 'Error in SMTP transaction', 3); INSERT INTO civicrm_mailing_bounce_pattern (bounce_type_id, pattern) VALUES (11, 'nonstandard smtp line terminator'), (11, 'syntax error in from address'), (11, 'unknown smtp code'); INSERT INTO civicrm_activity_type (domain_id, name, description, is_active, is_reserved) VALUES ( 1, 'Meeting', 'Schedule a Meeting', 1, 1); INSERT INTO civicrm_activity_type (domain_id, name, description, is_active, is_reserved) VALUES ( 1, 'Phone Call', 'Schedule a Phone Call', 1, 1); INSERT INTO civicrm_activity_type (domain_id, name, description, is_active, is_reserved) VALUES ( 1, 'Email', 'Email Sent', 1, 1); INSERT INTO civicrm_activity_type (domain_id, name, description, is_active, is_reserved) VALUES ( 1, 'Event', 'Event', 1, 0); INSERT INTO civicrm_mailing_component (domain_id,name,component_type,subject,body_html,body_text,is_default,is_active) VALUES (1,'Mailing Header','Header','This is the Header','HTML Body of Header','Text Body of Header',1,1), (1,'Mailing Footer','Footer','This is the Footer','HTML Body of Footer','Text Body of Footer',1,1), (1,'Subscribe Message','Subscribe','Subscription confirmation request','You have a pending subscription to {subscribe.group}. To confirm this subscription, reply to this email.','You have a pending subscription to {subscribe.group}. To confirm this subscription, reply to this email.',1,1), (1,'Welcome Message','Welcome','Welcome','Welcome to {welcome.group}!','Welcome to {welcome.group}!',1,1), (1,'Unsubscribe Message','Unsubscribe','Unsubscribe results','You have been unsubscribed from {unsubscribe.group}.','You have been unsubscribed from {unsubscribe.group}.',1,1), (1,'Opt-out Message','OptOut','Goodbye','You have been removed from {domain.name}. Goodbye.','You have been removed from {domain.name}. Goodbye.',1,1), (1,'Auto-responder','Reply','Automated response','Thank you for your reply.','Thank you for your reply.',1,1); INSERT INTO civicrm_individual_prefix (domain_id, name, weight, is_active) VALUES ( 1, 'Mrs', 1, 1); INSERT INTO civicrm_individual_prefix (domain_id, name, weight, is_active) VALUES ( 1, 'Ms', 2, 1); INSERT INTO civicrm_individual_prefix (domain_id, name, weight, is_active) VALUES ( 1, 'Mr', 3, 1); INSERT INTO civicrm_individual_prefix (domain_id, name, weight, is_active) VALUES ( 1, 'Dr', 4, 1); INSERT INTO civicrm_individual_suffix (domain_id, name, weight, is_active) VALUES ( 1, 'Jr', 1, 1); INSERT INTO civicrm_individual_suffix (domain_id, name, weight, is_active) VALUES ( 1, 'Sr', 2, 1); INSERT INTO civicrm_individual_suffix (domain_id, name, weight, is_active) VALUES ( 1, 'II', 3, 1); INSERT INTO civicrm_gender (domain_id, name, weight, is_active) VALUES ( 1, 'Female', 1, 1); INSERT INTO civicrm_gender (domain_id, name, weight, is_active) VALUES ( 1, 'Male', 2, 1); INSERT INTO civicrm_gender (domain_id, name, weight, is_active) VALUES ( 1, 'Transgender', 3, 1); INSERT INTO civicrm_dupe_match (domain_id, entity_table , rule) VALUES ( 1,'contact_individual','first_name AND last_name AND email'); -- contribution types INSERT INTO civicrm_contribution_type(name, domain_id, is_reserved, is_active, is_deductible) VALUES ( 'Donation' , 1, 0, 1, 1 ), ( 'Member Dues' , 1, 0, 1, 1 ), ( 'Campaign Contribution', 1, 0, 1, 0 ); -- payment instrument INSERT INTO civicrm_payment_instrument(name, domain_id, is_reserved, is_active) VALUES ( 'Credit Card', 1, 1, 1 ), ( 'Debit Card' , 1, 1, 1 ), ( 'Cash' , 1, 1, 1 ), ( 'Check' , 1, 1, 1 ), ( 'EFT' , 1, 1, 1 ); -- accepted credit cards INSERT INTO civicrm_accept_credit_card(name, title, domain_id, is_reserved, is_active) VALUES ( 'Visa', 'Visa', 1, 0, 1 ), ( 'MasterCard', 'Master Card', 1, 0, 1 ), ( 'Amex', 'American Express', 1, 0, 1 ), ( 'Discover', 'Discover', 1, 0, 1 );