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
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|