Skip to content

Instantly share code, notes, and snippets.

@OlabodeAbesin

OlabodeAbesin/Countries

Created January 28, 2022 07:11
Show Gist options
  • Save OlabodeAbesin/8120ba0f28db6ab414c79ae36a52eba2 to your computer and use it in GitHub Desktop.
Save OlabodeAbesin/8120ba0f28db6ab414c79ae36a52eba2 to your computer and use it in GitHub Desktop.
Download ZIP
List of countries, citizen names and country phone code
Raw
Countries
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("1","Afghanistan","Afghan","+93","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("2","Albania","Albanian","+355","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("3","Algeria","Algerian","+213","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("4","American Samoa","","+684","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("5","Andorra","Andorran","+376","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("6","Angola","Angolan","+244","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("7","Anguilla","Anguilla","+264","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("8","Antigua and Barbuda","Antiguan","+268","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("9","Argentina","Argentine","+54","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("10","Armenia","Armenian","+374","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("11","Aruba","","+297","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("12","Australia","Australian","+61","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("13","Austria","","+43","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("14","Azerbaijan","","+994","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("15","Bahamas","","+242","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("16","Bahrain","","+973","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("17","Bangladesh","Bangladeshi","+880","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("18","Barbados","Barbadian","+246","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("19","Belarus","Belarussian","+375","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("20","Belgium","Belgian","+32","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("21","Belize","","+501","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("22","Benin","Beninese","+229","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("23","Bermuda","","+441","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("24","Bhutan","Bhutanese","+975","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("25","Bolivia","Bolivian","+591","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("26","Bosnia and Herzegovina","Bosnian, Herzegovinian","+387","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("27","Botswana","Botswanian","+267","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("28","Brazil","Brazilian","+55","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("29","Brunei Darussalam","Bruneian","+673","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("30","Bulgaria","Bulgarian","+359","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("31","Burkina Faso","Burkinabe","+226","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("32","Burundi","Burundian","+257","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("33","Cambodia","Cambodian","+855","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("34","Cameroon","Cameroonian","+237","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("35","Canada","Canadian","+1","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("36","Cape Verde","Cape Verdean","+238","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("37","Cayman Islands","","+345","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("38","Central African Republic","Central African","+236","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("39","Chad","Chadian","+235","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("40","Chile","Chilean","+56","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("41","China","Chinese","+86","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("42","Christmas Island","","+61","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("43","Cocos (Keeling) Islands","","+61","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("44","Colombia","Colombian","+57","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("45","Comoros","Comoran","+269","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("46","Congo (Brazzaville)","Congolese","+242","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("47","Congo (Kinshasa)","Congolese","+243","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("48","Cook Islands","","+682","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("49","Costa Rica","Costa Rican","+506","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("50","Côte D'Ivoire (Ivory Coast)","Ivorian","+225","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("51","Croatia (Hrvatska)","Croat","+385","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("52","Cuba","Cuban","+53","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("53","Cyprus","Cypriot","+357","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("54","Czech Republic","Czech","+420","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("55","Denmark","Danish","+45","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("56","Djibouti","Djiboutian","+253","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("57","Dominica","Dominican (Dominica)","+767","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("58","Dominican Republic","Dominican","+809","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("59","Ecuador","Ecuadorian","+593","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("60","Egypt","Egyptian","+20","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("61","El Salvador","Salvadorian","+503","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("62","Equatorial Guinea","Equatoguinean","+240","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("63","Eritrea","Eritrean","+291","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("64","Estonia","Estonian","+372","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("65","Ethiopia","Ethiopian","+251","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("66","Falkland Islands (Malvinas)","","+500","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("67","Faroe Islands","","+298","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("68","Fiji","Fijian","+679","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("69","Finland","Finn","+358","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("70","France","French","+33","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("71","French Guiana","","+594","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("72","French Polynesia","","+689","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("73","Gabon","Gabonese","+241","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("74","Gambia","Gambian","+220","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("75","Georgia","Georgian","+995","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("76","Germany","German","+49","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("77","Ghana","Ghanaian","+233","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("78","Gibraltar","","+350","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("79","Greece","Greek","+30","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("80","Greenland","","+299","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("81","Grenada","Grenadian","+473","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("82","Guadeloupe","","+590","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("83","Guam","","+671","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("84","Guatemala","Guatemalan","+502","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("85","Guinea","Guinean","+224","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("86","Guinea-Bissau","Guinean (Guinea-Bissau)","+245","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("87","Guyana","Guyanese","+592","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("88","Haiti","Haitian","+509","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("89","Holy See (Vatican City State)","","+379","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("90","Honduras","Honduran","+504","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("91","Hong Kong, SAR","","+852","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("92","Hungary","Hungarian","+36","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("93","Iceland","Icelander","+354","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("94","India","Indian","+91","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("95","Indonesia","Indonesian","+62","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("96","Iran, Islamic Republic of","Iranian","+98","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("97","Iraq","Iraqi","+964","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("98","Ireland","Irish","+353","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("99","Israel","Israeli","+972","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("100","Italy","Italian","+39","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("101","Jamaica","Jamaican","+876","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("102","Japan","Japanese","+81","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("103","Jordan","Jordanian","+962","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("104","Kazakhstan","Kazakhstani","+810","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("105","Kenya","Kenyan","+254","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("106","Kiribati","I-Kiribati","+686","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("107","Korea, Democratic People's Republic of (North)","Korean (North)","+850","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("108","Korea, Republic of (South)","Korean (South)","+82","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("109","Kuwait","Kuwaiti","+965","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("110","Kyrgyzstan","Kyrgyzstani","+996","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("111","Laos (Lao PDR)","Laotian","+856","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("112","Latvia","Latvian","+371","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("113","Lebanon","Lebanese","+961","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("114","Lesotho","Mosotho","+266","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("115","Liberia","Liberian","+231","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("116","Libya","Libyan","+218","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("117","Liechtenstein","","+423","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("118","Lithuania","Lithuanian","+370","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("119","Luxembourg","Luxembourger","+352","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("120","Macao (SAR China)","","+853","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("121","Macedonia, Republic of","Macedonian","+389","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("122","Madagascar","Malagasy","+261","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("123","Malawi","Malawian","+265","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("124","Malaysia","Malaysian","+60","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("125","Maldives","Maldivian","+960","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("126","Mali","Malian","+223","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("127","Malta","Maltese","+356","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("128","Marshall Islands","Marshallese","+692","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("129","Martinique","","+596","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("130","Mauritania","Mauritanian","+222","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("131","Mauritius","Mauritian","+230","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("132","Mayotte","","+262","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("133","Mexico","Mexican","+52","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("134","Micronesia, Federated States of","Micronesian","+691","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("135","Moldova","Moldovan","+373","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("136","Monaco","Monegasque","+377","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("137","Mongolia","Mongolian","+976","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("138","Montenegro","","+382","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("139","Montserrat","","+664","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("140","Morocco and Western Sahara","Moroccan","+212","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("141","Mozambique","Mozambican","+258","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("142","Myanmar","Burmese","+95","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("143","Namibia","Namibian","+264","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("144","Nauru","Nauruan","+674","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("145","Nepal","Nepalese","+977","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("146","Netherlands","Dutch (Netherlands)","+31","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("147","Netherlands Antilles","Dutch","+599","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("148","New Caledonia","","+687","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("149","New Zealand","New Zealander","+64","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("150","Nicaragua","Nicaraguan","+505","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("151","Niger","Nigerien","+227","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("152","Nigeria","Nigerian","+234","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("153","Niue","","+683","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("154","Norfolk Island","","+672","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("155","Northern Mariana Islands","","+670","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("156","Norway","Norwegian","+47","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("157","Oman","Omani","+968","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("158","Pakistan","Pakistani","+92","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("159","Palau","Palauan","+680","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("160","Palestine","Palestinian","+970","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("161","Panama","Panamanian","+507","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("162","Papua New Guinea","Papua","+675","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("163","Paraguay","Paraguayan","+595","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("164","Peru","Peruvian","+51","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("165","Philippines","Filipino","+63","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("166","Pitcairn","","+870","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("167","Poland","Polish","+48","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("168","Portugal","Portuguese","+351","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("169","Puerto Rico","Puerto Rican","+787","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("170","Qatar","Qatari","+974","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("171","Réunion and Mayotte","","+262","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("172","Romania","Romanian","+40","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("173","Russian Federation","Russian","+810","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("174","Rwanda","Rwandan","+250","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("175","Saint Helena and also Tristan Da Cunha","","+290","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("176","Saint Kitts and Nevis","Kittian","+869","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("177","Saint Lucia","Saint Lucian","+758","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("178","Saint Pierre and Miquelon","","+508","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("179","Saint Vincent and the Grenadines","Saint Vincentian","+784","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("180","Samoa","Samoan","+685","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("181","San Marino","Sanmarinese","+378","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("182","São Tomé and Principe","São Tomean","+239","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("183","Saudi Arabia","Saudi","+966","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("184","Senegal","Senegalese","+221","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("185","Serbia","Serbian","+381","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("186","Seychelles","Seychellois","+248","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("187","Sierra Leone","Sierra Leonean","+232","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("188","Singapore","Singaporean","+65","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("189","Slovakia","Slovak","+421","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("190","Slovenia","Slovene","+386","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("191","Solomon Islands","Solomon Islander","+677","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("192","Somalia","Somali","+252","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("193","South Africa","South African","+27","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("194","Spain","Spanish","+34","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("195","Sri Lanka","Sri Lankan","+94","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("196","Sudan","Sudanese","+249","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("197","Suriname","Surinamer","+597","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("198","Svalbard and Jan Mayen Islands","","+47","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("199","Swaziland","Swazi","+268","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("200","Sweden","Swede","+46","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("201","Switzerland","Swiss","+41","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("202","Syrian Arab Republic (Syria)","Syrian","+963","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("203","Taiwan, Republic of China","Taiwanese","+886","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("204","Tajikistan","Tajikistani","+992","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("205","Tanzania, United Republic of","Tanzanian","+255","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("206","Thailand","Thai","+66","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("207","Timor-Leste","","+670","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("208","Togo","Togolese","+228","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("209","Tokelau","","+690","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("210","Tonga","Tongan","+676","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("211","Trinidad and Tobago","Trinidadian, Tobagonian","+868","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("212","Tunisia","Tunisian","+216","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("213","Turkey","Turkish","+90","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("214","Turkmenistan","Turkmen","+993","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("215","Turks and Caicos Islands","","+649","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("216","Tuvalu","Tuvaluan","+688","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("217","Uganda","Ugandan","+256","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("218","Ukraine","Ukrainian","+380","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("219","United Arab Emirates","Emirati","+971","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("220","United Kingdom","British","+44","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("221","United States of America","American","+1","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("222","Uruguay","Uruguayan","+598","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("223","Uzbekistan","Uzbekistani","+998","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("224","Vanuatu","Ni-Vanuatu","+678","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("225","Venezuela (Bolivarian Republic of)","Venezuelan","+58","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("226","Vietnam","Vietnamese","+84","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("227","Virgin Islands, British","British (Virgin Islands)","+284","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("228","Virgin Islands, US","American (Virgin Islands)","+340","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("229","Wallis and Futuna Islands","","+681","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("230","Yemen","Yemeni","+967","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("231","Zambia","Zambian","+260","2022-01-28 03:30:05","ACTIVE");
insert into country(id,name,nationality,dialling_code,created_date,active_status) values("232","Zimbabwe","Zimbabwean","+263","2022-01-28 03:30:05","ACTIVE");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment