Download JSON file - Click on JSON file
--NATIONALITY TABLE
AND
Download JSON file - Click on Excel file
CREATE
TABLE [dbo].[Nationality]
(
[NationalityID]
[int] IDENTITY(1,1) NOT NULL,
[Country]
[nvarchar](55) NULL,
[CountryCode]
[nvarchar](4) NULL,
[Nationality]
[nvarchar] (140) NULL,
[Person]
[nvarchar] (120) NULL
) ON [PRIMARY]
GO
--INSERT NATIONALITY TABLE
INSERT
INTO [dbo].[Nationality](Country, CountryCode, Nationality, Person )
VALUES
( 'UNITED KINGDOM','GB','British','a Briton' ),
( 'ARGENTINA','AR','Argentinian','an Argentinian' ),
( 'AUSTRALIA','AU','Australian','an Australian' ),
( 'BAHAMAS','BS','Bahamian','a Bahamian' ),
( 'BELGIUM','BE','Belgian','a Belgian' ),
( 'BRAZIL','BR','Brazilian','a Brazilian' ),
( 'CANADA','CA','Canadian','a Canadian' ),
( 'CHINA','CN','Chinese','a Chinese' ),
( 'COLOMBIA','CO','Colombian','a Colombian' ),
( 'CUBA','CU','Cuban','a Cuban' ),
( 'DOMINICAN REPUBLIC','DO','Dominican','a Dominican' ),
( 'ECUADOR','EC','Ecuadorean','an Ecuadorean' ),
( 'EL SALVADOR','SV','Salvadorean','a Salvadorean' ),
( 'FRANCE','FR','French','a Frenchman, a Frenchwoman' ),
( 'GERMANY','DE','German','a German' ),
( 'GUATEMALA','GT','Guatemalan','a Guatemalan' ),
( 'HAITI','HT','Haitian','a Haitian' ),
( 'HONDURAS','HN','Honduran','a Honduran' ),
( 'INDIA','IN','Indian','an Indian' ),
( 'IRELAND','IE','Ireland','an Irishman, an Irishwoman' ),
( 'ISRAEL','IL','Israeli','an Israeli' ),
( 'ITALY','IT','Italian','an Italian' ),
( 'JAPAN','JP','Japanese','a Japanese' ),
( 'KOREA - REPUBLIC OF','KR','South Korean','a South Korean' ),
( 'MEXICO','MX','Mexican','a Mexican' ),
( 'NETHERLANDS','NL','Dutch','a Dutchman, a Dutchwoman' ),
( 'PHILIPPINES','PH','Philippine','a Filipino' ),
( 'SPAIN','ES','Spanish','a Spaniard' ),
( 'SWEDEN','SE','Swedish','a Swede' ),
( 'SWITZERLAND','CH','Swiss','a Swiss' ),
( 'TAIWAN - PROVINCE OF CHINA','TW','Taiwanese','a Taiwanese' ),
( 'VENEZUELA - BOLIVARIAN
REPUBLIC OF','VE','Venezuelan','a Venezuelan' ),
( 'VIET NAM','VN','Vietnamese','a Vietnamese' ),
( 'AFGHANISTAN','AF','Afghan','an Afghan' ),
( 'ALBANIA','AL','Albanian','an Albanian' ),
( 'ALGERIA','DZ','Algerian','an Algerian' ),
( 'AMERICAN SAMOA','AS','Samoan','a Samoan' ),
( 'ANDORRA','AD','Andorran','an Andorran' ),
( 'ANGOLA','AO','Angolan','an Angolan' ),
( 'ARMENIA','AM','Armenian','an Armenian' ),
( 'AUSTRIA','AT','Austrian','an Austrian' ),
( 'AZERBAIJAN','AZ','Azerbaijani','an Azerbaijani' ),
( 'BAHRAIN','BH','Bahraini','a Bahraini' ),
( 'BANGLADESH','BD','Bangladeshi','a Bangladeshi' ),
( 'BARBADOS','BB','Barbadian','a Barbadian' ),
( 'BELARUS','BY','Belarusian or Belarusan','a Belarusian' ),
( 'BELIZE','BZ','Belizean','a Belizean' ),
( 'BENIN','BJ','Beninese','a Beninese' ),
( 'BERMUDA','BM','Bermudian','a Bermudian' ),
( 'BHUTAN','BT','Bhutanese','a Bhutanese' ),
( 'BOLIVIA - PLURINATIONAL STATE
OF','BO','Bolivian','a Bolivian' ),
( 'BOSNIA AND HERZEGOVINA','BA','Bosnian','a Bosnian' ),
( 'BOTSWANA','BW','Botswanan','a Tswana' ),
( 'BULGARIA','BG','Bulgarian','a Bulgarian' ),
( 'BURKINA FASO','BF','Burkinese','a Burkinese' ),
( 'BURUNDI','BI','Burundian','a Burundian' ),
( 'CAMBODIA','KH','Cambodian','a Cambodian' ),
( 'CAMEROON','CM','Cameroonian','a Cameroonian' ),
( 'CAPE VERDE ISLANDS','CV','Cape Verdean','a Cape Verdean' ),
( 'CHAD','TD','Chadian','a Chadian' ),
( 'CHILE','CL','Chilean','a Chilean' ),
( 'CONGO','CG','Congolese','a Congolese' ),
( 'COSTA RICA','CR','Costa Rican','a Costa Rican' ),
( 'CROATIA','HR','Croat or Croatian','a Croat' ),
( 'CYPRUS','CY','Cypriot','a Cypriot' ),
( 'CZECH REPUBLIC','CZ','Czech','a Czech' ),
( 'DENMARK','DK','Danish','a Dane' ),
( 'DJIBOUTI','DJ','Djiboutian','a Djiboutian' ),
( 'DOMINICA','DM','Dominican','a Dominican' ),
( 'EGYPT','EG','Egyptian','an Egyptian' ),
( 'ERITREA','ER','Eritrean','an Eritrean' ),
( 'ESTONIA','EE','Estonian','an Estonian' ),
( 'ETHIOPIA','ET','Ethiopian','an Ethiopian' ),
( 'FIJI','FJ','Fijian','a Fijian' ),
( 'FINLAND','FI','Finnish','a Finn' ),
( 'FRENCH POLYNESIA','PF','French Polynesian','a French Polynesian'
),
( 'GABON','GA','Gabonese','a Gabonese' ),
( 'GAMBIA','GM','Gambian','a Gambian' ),
( 'GEORGIA','GE','Georgian','a Georgian' ),
( 'GHANA','GH','Ghanaian','a Ghanaian' ),
( 'GREECE','GR','Greek','a Greek' ),
( 'GRENADA','GD','Grenadian','a Grenadian' ),
( 'GUINEA','GN','Guinean','a Guinean' ),
( 'GUYANA','GY','Guyanese','a Guyanese' ),
( 'HUNGARY','HU','Hungarian','a Hungarian' ),
( 'ICELAND','IS','Icelandic','an Icelander' ),
( 'INDONESIA','ID','Indonesian','an Indonesian' ),
( 'IRAN - ISLAMIC REPUBLIC OF','IR','Iranian','an Iranian' ),
( 'IRAQ','IQ','Iraqi','an Iraqi' ),
( 'JAMAICA','JM','Jamaican','a Jamaican' ),
( 'JORDAN','JO','Jordanian','a Jordanian' ),
( 'KAZAKHSTAN','KZ','Kazakh','a Kazakh' ),
( 'KENYA','KE','Kenyan','a Kenyan' ),
( 'KOREA - DEMOCRATIC PEOPLE''S
REPUBLIC OF','KP','North Korean','a North Korean' ),
( 'KUWAIT','KW','Kuwaiti','a Kuwaiti' ),
( 'LATVIA','LV','Latvian','a Latvian' ),
( 'LEBANON','LB','Lebanese','a Lebanese' ),
( 'LIBERIA','LR','Liberian','a Liberian' ),
( 'LIBYA','LY','Libyan','a Libyan' ),
( 'LITHUANIA','LT','Lithuanian','a Lithuanian' ),
( 'LUXEMBOURG','LU','-','a Luxembourger' ),
( 'MADAGASCAR','MG','Malagasy or Madagascan','a Malagasy' ),
( 'MALAWI','MW','Malawian','a Malawian' ),
( 'MALAYSIA','MY','Malaysian','a Malaysian' ),
( 'MALDIVES','MV','Maldivian','a Maldivian' ),
( 'MALI','ML','Malian','a Malian' ),
( 'MALTA','MT','Maltese','a Maltese' ),
( 'MAURITANIA','MR','Mauritanian','a Mauritanian' ),
( 'MAURITIUS','MU','Mauritian','a Mauritian' ),
( 'MONACO','MC','Monégasque or Monacan','a Monégasque or a Monacan' ),
( 'MONGOLIA','MN','Mongolian','a Mongolian' ),
( 'MONTENEGRO','ME','Montenegrin','a Montenegrin' ),
( 'MOROCCO','MA','Moroccan','a Moroccan' ),
( 'MOZAMBIQUE','MZ','Mozambican','a Mozambican' ),
( 'NAMIBIA','NA','Namibian','a Namibian' ),
( 'NEPAL','NP','Nepalese','a Nepalese' ),
( 'NICARAGUA','NI','Nicaraguan','a Nicaraguan' ),
( 'NIGER','NE','Nigerien','a Nigerien' ),
( 'NIGERIA','NG','Nigerian','a Nigerian' ),
( 'NORWAY','NO','Norwegian','a Norwegian' ),
( 'OMAN','OM','Omani','an Omani' ),
( 'PAKISTAN','PK','Pakistani','a Pakistani' ),
( 'PANAMA','PA','Panamanian','a Panamanian' ),
( 'PARAGUAY','PY','Paraguayan','a Paraguayan' ),
( 'PERU','PE','Peruvian','a Peruvian' ),
( 'POLAND','PL','Polish','a Pole' ),
( 'PORTUGAL','PT','Portuguese','a Portuguese' ),
( 'QATAR','QA','Qatari','a Qatari' ),
( 'ROMANIA','RO','Romanian','a Romanian' ),
( 'RWANDA','RW','Rwandan','a Rwandan' ),
( 'SAUDI ARABIA','SA','Saudi Arabian or Saudi','a Saudi Arabian' ),
( 'SENEGAL','SN','Senegalese','a Senegalese' ),
( 'SERBIA','RS','Serb or Serbian','a Serb or a Serbian'
),
( 'SIERRA LEONE','SL','Sierra Leonian','a Sierra Leonian' ),
( 'SINGAPORE','SG','Singaporean','a Singaporean' ),
( 'SLOVAKIA','SK','Slovak','a Slovak' ),
( 'SLOVENIA','SI','Slovene or Slovenian','a Slovene' ),
( 'SOLOMON ISLANDS','SB','-','a Solomon Islander' ),
( 'SOMALIA','SO','Somali','a Somali' ),
( 'SOUTH AFRICA','ZA','South African','a South African' ),
( 'SRI LANKA','LK','Sri Lankan','a Sri Lankan' ),
( 'SUDAN','SD','Sudanese','a Sudanese' ),
( 'SURINAME','SR','Surinamese','a Surinamer' ),
( 'SWAZILAND','SZ','Swazi','a Swazi' ),
( 'TAJIKISTAN','TJ','Tajik or Tadjik','a Tajik' ),
( 'THAILAND','TH','Thai','a Thai' ),
( 'TOGO','TG','Togolese','a Togolese' ),
( 'TRINIDAD AND TOBAGO','TT','Trinidadian','a Trinidadian' ),
( 'TUNISIA','TN','Tunisian','a Tunisian' ),
( 'TURKEY','TR','Turkish','a Turk' ),
( 'TURKMENISTAN','TM','Turkmen or Turkoman','a Turkmen' ),
( 'TUVALU','TV','Tuvaluan','a Tuvaluan' ),
( 'UGANDA','UG','Ugandan','a Ugandan' ),
( 'UKRAINE','UA','Ukrainian','a Ukrainian' ),
( 'UNITED ARAB EMIRATES','AE', 'Emirati', 'a UAE citizen' ),
( 'UNITED STATES','US','American','a US citizen' ),
( 'URUGUAY','UY','Uruguayan','a Uruguayan' ),
( 'UZBEKISTAN','UZ','Uzbek','an Uzbek' ),
( 'VANUATU','VU','Vanuatuan','a Vanuatuan' ),
( 'YEMEN','YE','Yemeni','a Yemeni' ),
( 'ZAMBIA','ZM','Zambian','a Zambian' )
GO