SQL ready list of countries, nationalities, and collective nouns

gistfile1.txt

('Abkhazia', 'Abkhazian', 'Abkhazians');
('Afghanistan', 'Afghan', 'Afghans');
('Albania', 'Albanian', 'Albanians');
('Algeria', 'Algerian', 'Algerians');
('American Samoa', 'American Samoan', 'American Samoans');
('Andorra', 'Andorran', 'Andorrans');
('Angola', 'Angolan', 'Angolans');
('Anguilla', 'Anguillan', 'Anguillans');
('Antigua and Barbuda', 'Antiguan', 'Antiguans');
('Argentina', 'Argentinian', 'Argentinians');
('Armenia', 'Armenian', 'Armenians');
('Aruba', 'Aruban', 'Arubans');
('Australia', 'Australian', 'Australians');
('Austria', 'Austrian', 'Austrians');
('Azerbaijan', 'Azerbaijani', 'Azerbaijanis');
('Bahamas', 'Bahamian', 'Bahamians');
('Bahrain', 'Bahraini', 'Bahrainis');
('Bangladesh', 'Bangladeshi', 'Bangladeshis');
('Barbados', 'Barbadian', 'Barbadians');
('Belarus', 'Belarusian', 'Belarusians');
('Belgium', 'Belgian', 'Belgians');
('Belize', 'Belizean', 'Belizeans');
('Benin', 'Beninese', 'Beninese');
('Bermuda', 'Bermudan', 'Bermudans');
('Bhutan', 'Bhutanese', 'Bhutanese');
('Bolivia', 'Bolivian', 'Bolivians');
('Bosnia and Herzegovina', 'Bosnian / Herzegovinian', 'Bosnians / Herzegovinians');
('Botswana', 'Botswanan', 'Botswanans');
('Brazil', 'Brazilian', 'Brazilians');
('British Virgin Islands', 'British Virgin Islander', 'British Virgin Islanders');
('Brunei', 'Bruneian', 'Bruneians');
('Bulgaria', 'Bulgarian', 'Bulgarians');
('Burkina Fasoa', 'Burkinabé', 'Burkinabé');
('Burmab', 'Burmese', 'Burmese');
('Burundi', 'Burundian', 'Burundians');
('Cambodia', 'Cambodian', 'Cambodians');
('Cameroon', 'Cameroonian', 'Cameroonians');
('Canada', 'Canadian', 'Canadians');
('Cape Verde', 'Cape Verdean', 'Cape Verdeans');
('Cayman Islands', 'Caymanian', 'Caymanians');
('Central African Republic', 'Central African', 'Central Africans');
('Chad', 'Chadian', 'Chadians');
('Chile', 'Chilean', 'Chileans');
('People\'s Republic of China', 'Chinese', 'Chinese');
('Christmas Island', 'Christmas Island', 'Christmas Islanders');
('Cocos (Keeling) Islands', 'Cocos Island', 'Cocos Islanders');
('Colombia', 'Colombian', 'Colombians');
('Comoros', 'Comorian', 'Comorians');
('Dem. Republic of the Congo', 'Congolese (Dem. Rep.)', 'Congolese (Dem. Rep.)');
('Republic of the Congo', 'Congolese (Rep.)', 'Congolese (Rep.)');
('Cook Islands', 'Cook Islands', 'Cook Islanders');
('Costa Rica', 'Costa Rican', 'Costa Ricans');
('Côte d'Ivoire', 'Ivorian', 'Ivorians');
('Croatia', 'Croatian', 'Croats');
('Cuba', 'Cuban', 'Cubans');
('Cyprus', 'Cypriot', 'Cypriots');
('Czech Republic', 'Czech', 'Czechs');
('Denmark', 'Danish', 'Danes');
('Djibouti', 'Djiboutian', 'Djiboutians');
('Dominica', 'Dominican', 'Dominicans');
('Dominican Republic', 'Dominican', 'Dominicans');
('East Timor', 'Timorese', 'Timorese');
('Ecuador', 'Ecuadorian', 'Ecuadorians');
('Egypt', 'Egyptian', 'Egyptians');
('El Salvador', 'Salvadoran', 'Salvadorans');
('England', 'English', 'English');
('Equatorial Guinea', 'Equatorial Guinean', 'Equatorial Guineans');
('Eritrea', 'Eritrean', 'Eritreans');
('Estonia', 'Estonian', 'Estonians');
('Ethiopia', 'Ethiopian', 'Ethiopians');
('Falkland Islands', 'Falkland Island', 'Falkland Islanders');
('Faroe Islands', 'Faroese', 'Faroese');
('Fiji', 'Fijian', 'Fijians');
('Finland', 'Finnish', 'Finns');
('France', 'French', 'French');
('French Guiana', 'French Guianese', 'French Guianese');
('French Polynesia', 'French Polynesian', 'French Polynesians');
('Gabon', 'Gabonese', 'Gabonese');
('Gambia', 'Gambian', 'Gambians');
('Georgia', 'Georgian', 'Georgians');
('Germany', 'German', 'Germans');
('Ghana', 'Ghanaian', 'Ghanaians');
('Gibraltar', 'Gibraltar', 'Gibraltarians');
('Great Britain', 'British', 'Britons');
('Greece', 'Greek', 'Greeks');
('Greenland', 'Greenlandic', 'Greenlanders');
('Grenada', 'Grenadian', 'Grenadians');
('Guadeloupe', 'Guadeloupe', 'Guadeloupians');
('Guam', 'Guamanian', 'Guamanians');
('Guatemala', 'Guatemalan', 'Guatemalans');
('Guinea', 'Guinean', 'Guineans');
('Guinea-Bissau', 'Guinea-Bissauan', 'Guinea-Bissauans');
('Guyana', 'Guyanese', 'Guyanese');
('Haiti', 'Haitian', 'Haitians');
('Honduras', 'Honduran', 'Hondurans');
('Hong Kong', 'Hong Kong, Hongkongese', 'Hongkongers, Hongkongese');
('Hungary', 'Hungarian', 'Hungarians');
('Iceland', 'Icelandic', 'Icelanders');
('India', 'Indian', 'Indians');
('Indonesia', 'Indonesian', 'Indonesians');
('Iran', 'Iranian', 'Iranians');
('Iraq', 'Iraqi', 'Iraqis');
('Ireland', 'Irish', 'Irish');
('Isle of Man', 'Manx', 'Manx');
('Israel', 'Israeli', 'Israelis');
('Italy', 'Italian', 'Italians');
('Jamaica', 'Jamaican', 'Jamaicans');
('Japan', 'Japanese', 'Japanese');
('Jordan', 'Jordanian', 'Jordanians');
('Kazakhstan', 'Kazakh', 'Kazakhs');
('Kenya', 'Kenyan', 'Kenyans');
('Kiribati', 'I-Kiribati', 'I-Kiribati');
('North Korea', 'North Korean', 'North Koreans');
('South Korea', 'South Korean', 'South Koreans');
('Kosovo', 'Kosovar', 'Kosovars');
('Kuwait', 'Kuwaiti', 'Kuwaitis');
('Kyrgyzstan', 'Kyrgyzstani', 'Kyrgyzstanis');
('Laos', 'Laotian', 'Laotians');
('Latvia', 'Latvian', 'Latvians');
('Lebanon', 'Lebanese', 'Lebanese');
('Lesotho', 'Basotho', 'Basotho');
('Liberia', 'Liberian', 'Liberians');
('Libya', 'Libyan', 'Libyans');
('Liechtenstein', 'Liechtenstein', 'Liechtensteiners');
('Lithuania', 'Lithuanian', 'Lithuanians');
('Luxembourg', 'Luxembourg', 'Luxembourgers');
('Macau', 'Macanese', 'Macanese');
('Republic of Macedonia', 'Macedonian', 'Macedonians');
('Madagascar', 'Malagasy', 'Malagasy');
('Malawi', 'Malawian', 'Malawians');
('Malaysia', 'Malaysian', 'Malaysians');
('Maldives', 'Maldivian', 'Maldivians');
('Mali', 'Malian', 'Malians');
('Malta', 'Maltese', 'Maltese');
('Marshall Islands', 'Marshallese', 'Marshallese');
('Martinique', 'Martiniquais', 'Martiniquais');
('Mauritania', 'Mauritanian', 'Mauritanians');
('Mauritius', 'Mauritian', 'Mauritians');
('Mayotte', 'Mahoran', 'Mahorais');
('Mexico', 'Mexican', 'Mexicans');
('Micronesia, Federated States of', 'Micronesian', 'Micronesians');
('Moldova', 'Moldovan', 'Moldovans');
('Monaco', 'Monacan', 'Monacans');
('Mongolia', 'Mongolian', 'Mongolians');
('Montenegro', 'Montenegrin', 'Montenegrins');
('Montserrat', 'Montserratian', 'Montserratians');
('Morocco', 'Moroccan', 'Moroccans');
('Mozambique', 'Mozambican', 'Mozambicans');
('Namibia', 'Namibian', 'Namibians');
('Nauru', 'Nauruan', 'Nauruans');
('Nepal', 'Nepalese', 'Nepalese');
('Netherlands', 'Dutch', 'Dutch');
('New Caledonia', 'New Caledonian', 'New Caledonians');
('New Zealand', 'New Zealand', 'New Zealanders');
('Nicaragua', 'Nicaraguan', 'Nicaraguans');
('Niue', 'Niuean', 'Niueans');
('Niger', 'Nigerien', 'Nigeriens');
('Nigeria', 'Nigerian', 'Nigerians');
('Norway', 'Norwegian', 'Norwegians');
('Northern Ireland', 'Northern Irish', 'Northern Irish');
('Northern Marianas', 'Northern Marianan', 'Northern Marianans');
('Oman', 'Omani', 'Omanis');
('Pakistan', 'Pakistani', 'Pakistanis');
('Palestine', 'Palestinian', 'Palestinians');
('Palau', 'Palauan', 'Palauans');
('Panama', 'Panamanian', 'Panamanians');
('Papua New Guinea', 'Papua New Guinean', 'Papua New Guineans');
('Paraguay', 'Paraguayan', 'Paraguayans');
('Peru', 'Peruvian', 'Peruvians');
('Philippines', 'Filipino', 'Filipinos');
('Pitcairn Island', 'Pitcairn Island', 'Pitcairn Islanders');
('Poland', 'Polish', 'Poles');
('Portugal', 'Portuguese', 'Portuguese');
('Puerto Rico', 'Puerto Rican', 'Puerto Ricans');
('Qatar', 'Qatari', 'Qataris');
('Republic of Ireland', 'Irish', 'Irish');
('Réunion', 'Réunionese', 'Réunionese');
('Romania', 'Romanian', 'Romanians');
('Russia', 'Russian', 'Russians');
('Rwanda', 'Rwandan', 'Rwandans');
('St. Helena', 'St. Helenian', 'St. Helenians');
('St. Kitts and Nevis', 'Kittitian / Nevisian', 'Kittitians / Nevisians');
('St. Lucia', 'St. Lucian', 'St. Lucians');
('Saint-Pierre and Miquelon', 'Saint-Pierrais / Miquelonnais', 'Saint-Pierrais / Miquelonnais');
('St. Vincent and the Grenadines', 'St. Vincentian', 'St. Vincentians');
('Samoa', 'Samoan', 'Samoans');
('San Marino', 'Sammarinese', 'Sammarinese');
('São Tomé and Príncipe', 'São Toméan', 'São Toméans');
('Saudi Arabia', 'Saudi Arabian', 'Saudi Arabians');
('Scotland', 'Scottish', 'Scots');
('Senegal', 'Senegalese', 'Senegalese');
('Serbia', 'Serbian', 'Serbians');
('Seychelles', 'Seychellois', 'Seychellois');
('Sierra Leone', 'Sierra Leonean', 'Sierra Leoneans');
('Singapore', 'Singaporean', 'Singaporeans');
('Slovakia', 'Slovak', 'Slovaks');
('Slovenia', 'Slovenian', 'Slovenians');
('Solomon Islands', 'Solomon Island', 'Solomon Islanders');
('Somalia', 'Somali', 'Somalis');
('South Africa', 'South African', 'South Africans');
('South Ossetia', 'South Ossetian', 'South Ossetians');
('South Sudan', 'South Sudanese', 'South Sudanese');
('Spain', 'Spanish', 'Spaniards');
('Sri Lanka', 'Sri Lankan', 'Sri Lankans');
('Sudan', 'Sudanese', 'Sudanese');
('Surinam', 'Surinamese', 'Surinamers');
('Swaziland', 'Swazi', 'Swazis');
('Sweden', 'Swedish', 'Swedes');
('Switzerland', 'Swiss', 'Swiss');
('Syria', 'Syrian', 'Syrians');
('Taiwan', 'Taiwanese', 'Taiwanese');
('Tajikistan', 'Tajikistani', 'Tajikistanis');
('Tanzania', 'Tanzanian', 'Tanzanians');
('Thailand', 'Thai', 'Thai');
('Togo', 'Togolese', 'Togolese');
('Tonga', 'Tongan', 'Tongans');
('Trinidad and Tobago', 'Trinidadian / Tobagonian', 'Trinidadians / Tobagonians');
('Tunisia', 'Tunisian', 'Tunisians');
('Turkey', 'Turkish', 'Turks');
('Turkmenistan', 'Turkmen', 'Turkmens');
('Turks and Caicos Islands', 'Turks and Caicos Islands', 'Turks and Caicos Islanders');
('Tuvalu', 'Tuvaluan', 'Tuvaluans');
('Uganda', 'Ugandan', 'Ugandans');
('Ukraine', 'Ukrainian', 'Ukrainians');
('United Arab Emirates', 'Emirati', 'Emiratis');
('United Kingdom', 'British', 'Britons');
('United States', 'American', 'Americans');
('Uruguay', 'Uruguayan', 'Uruguayans');
('Uzbekistan', 'Uzbek', 'Uzbeks');
('Vanuatu', 'Vanuatuan', 'Vanuatuans');
('Venezuela', 'Venezuelan', 'Venezuelans');
('Vietnam', 'Vietnamese', 'Vietnamese');
('Virgin Islands', 'Virgin Island', 'Virgin Islanders');
('Wales', 'Welsh', 'Welsh');
('Wallis and Futuna', 'Wallisian / Futunan', 'Wallisians / Futunans');
('Western Sahara', 'Sahrawian', 'Sahrawis');
('Yemen', 'Yemeni', 'Yemenis');
('Zambia', 'Zambian', 'Zambians');
('Zimbabwe', 'Zimbabwean', 'Zimbabweans');