Skip to content

Instantly share code, notes, and snippets.

@gauravdixit007

gauravdixit007/country_continent_mapping.sql

Created April 12, 2019 04:52
Show Gist options
  • Save gauravdixit007/71dd07cd209039e7e5a489a64bad39e5 to your computer and use it in GitHub Desktop.
Save gauravdixit007/71dd07cd209039e7e5a489a64bad39e5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
country_continent_mapping.sql
/**
* country_continent mapping Table compiled from Wikipedia
* and a couple other places.
* You may need to change datatype or escape sequence depending on your exact database.
* I have compiled this for postgresql. This is deliberately denormalized. If you are looking for normalized
* country and continent tables. Refer https://gist.github.com/kamermans/1441495
*
* Compiled by Gaurav Dixit, 2019
*/
CREATE TABLE country_continent (
code char(2) NOT NULL, -- 'Two-letter country code (ISO 3166-1 alpha-2)'
country_name varchar(64) NOT NULL, -- 'English country name'
full_name varchar(128) NOT NULL, -- 'Full English country name'
iso3 char(3) NOT NULL, -- 'Three-letter country code (ISO 3166-1 alpha-3)'
number smallint NOT NULL, -- 'Three-digit country number (ISO 3166-1 numeric)'
continent_code char(2) NOT NULL,
continent_name varchar(64) NOT NULL, -- 'English continent name'
PRIMARY KEY(code)
);
INSERT INTO country_continent VALUES ( 'AO' , 'Angola' , 'Republic of Angola' , 'AGO' , '024' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'BF' , 'Burkina Faso' , 'Burkina Faso' , 'BFA' , '854' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'BI' , 'Burundi' , 'Republic of Burundi' , 'BDI' , '108' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'BJ' , 'Benin' , 'Republic of Benin' , 'BEN' , '204' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'BW' , 'Botswana' , 'Republic of Botswana' , 'BWA' , '072' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'CD' , 'Congo (Kinshasa)' , 'Democratic Republic of the Congo' , 'COD' , '180' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'CF' , 'Central African Republic' , 'Central African Republic' , 'CAF' , '140' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'CG' , 'Congo (Brazzaville)' , 'Republic of the Congo' , 'COG' , '178' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'CI' , E'Côte \'Ivoire' , E'Republic of Cote \'Ivoire' , 'CIV' , '384' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'CM' , 'Cameroon' , 'Republic of Cameroon' , 'CMR' , '120' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'CV' , 'Cape Verde' , 'Republic of Cape Verde' , 'CPV' , '132' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'DJ' , 'Djibouti' , 'Republic of Djibouti' , 'DJI' , '262' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'DZ' , 'Algeria' , E'People\'s Democratic Republic of Algeria' , 'DZA' , '012' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'EG' , 'Egypt' , 'Arab Republic of Egypt' , 'EGY' , '818' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'EH' , 'Western Sahara' , 'Western Sahara' , 'ESH' , '732' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'ER' , 'Eritrea' , 'State of Eritrea' , 'ERI' , '232' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'ET' , 'Ethiopia' , 'Federal Democratic Republic of Ethiopia' , 'ETH' , '231' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'GA' , 'Gabon' , 'Gabonese Republic' , 'GAB' , '266' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'GH' , 'Ghana' , 'Republic of Ghana' , 'GHA' , '288' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'GM' , 'Gambia' , 'Republic of the Gambia' , 'GMB' , '270' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'GN' , 'Guinea' , 'Republic of Guinea' , 'GIN' , '324' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'GQ' , 'Equatorial Guinea' , 'Republic of Equatorial Guinea' , 'GNQ' , '226' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'GW' , 'Guinea-Bissau' , 'Republic of Guinea-Bissau' , 'GNB' , '624' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'KE' , 'Kenya' , 'Republic of Kenya' , 'KEN' , '404' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'KM' , 'Comoros' , 'Union of the Comoros' , 'COM' , '174' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'LR' , 'Liberia' , 'Republic of Liberia' , 'LBR' , '430' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'LS' , 'Lesotho' , 'Kingdom of Lesotho' , 'LSO' , '426' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'LY' , 'Libya' , 'Libyan Arab Jamahiriya' , 'LBY' , '434' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'MA' , 'Morocco' , 'Kingdom of Morocco' , 'MAR' , '504' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'MG' , 'Madagascar' , 'Republic of Madagascar' , 'MDG' , '450' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'ML' , 'Mali' , 'Republic of Mali' , 'MLI' , '466' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'MR' , 'Mauritania' , 'Islamic Republic of Mauritania' , 'MRT' , '478' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'MU' , 'Mauritius' , 'Republic of Mauritius' , 'MUS' , '480' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'MW' , 'Malawi' , 'Republic of Malawi' , 'MWI' , '454' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'MZ' , 'Mozambique' , 'Republic of Mozambique' , 'MOZ' , '508' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'NA' , 'Namibia' , 'Republic of Namibia' , 'NAM' , '516' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'NE' , 'Niger' , 'Republic of Niger' , 'NER' , '562' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'NG' , 'Nigeria' , 'Federal Republic of Nigeria' , 'NGA' , '566' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'RE' , 'Reunion' , 'Reunion' , 'REU' , '638' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'RW' , 'Rwanda' , 'Republic of Rwanda' , 'RWA' , '646' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'SC' , 'Seychelles' , 'Republic of Seychelles' , 'SYC' , '690' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'SD' , 'Sudan' , 'Republic of Sudan' , 'SDN' , '736' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'SH' , 'Saint Helena' , 'Saint Helena' , 'SHN' , '654' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'SL' , 'Sierra Leone' , 'Republic of Sierra Leone' , 'SLE' , '694' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'SN' , 'Senegal' , 'Republic of Senegal' , 'SEN' , '686' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'SO' , 'Somalia' , 'Somali Republic' , 'SOM' , '706' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'ST' , 'Sao Tome and Principe' , 'Democratic Republic of Sao Tome and Principe' , 'STP' , '678' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'SZ' , 'Swaziland' , 'Kingdom of Swaziland' , 'SWZ' , '748' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'TD' , 'Chad' , 'Republic of Chad' , 'TCD' , '148' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'TG' , 'Togo' , 'Togolese Republic' , 'TGO' , '768' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'TN' , 'Tunisia' , 'Tunisian Republic' , 'TUN' , '788' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'TZ' , 'Tanzania' , 'United Republic of Tanzania' , 'TZA' , '834' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'UG' , 'Uganda' , 'Republic of Uganda' , 'UGA' , '800' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'YT' , 'Mayotte' , 'Mayotte' , 'MYT' , '175' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'ZA' , 'South Africa' , 'Republic of South Africa' , 'ZAF' , '710' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'ZM' , 'Zambia' , 'Republic of Zambia' , 'ZMB' , '894' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'ZW' , 'Zimbabwe' , 'Republic of Zimbabwe' , 'ZWE' , '716' , 'AF' , 'Africa' );
INSERT INTO country_continent VALUES ( 'AQ' , 'Antarctica' , 'Antarctica (the territory South of 60 deg S)' , 'ATA' , '010' , 'AN' , 'Antarctica' );
INSERT INTO country_continent VALUES ( 'BV' , 'Bouvet Island' , 'Bouvet Island (Bouvetoya)' , 'BVT' , '074' , 'AN' , 'Antarctica' );
INSERT INTO country_continent VALUES ( 'GS' , 'South Georgia and South Sandwich Islands' , 'South Georgia and the South Sandwich Islands' , 'SGS' , '239' , 'AN' , 'Antarctica' );
INSERT INTO country_continent VALUES ( 'HM' , 'Heard and McDonald Islands' , 'Heard Island and McDonald Islands' , 'HMD' , '334' , 'AN' , 'Antarctica' );
INSERT INTO country_continent VALUES ( 'TF' , 'French Southern Lands' , 'French Southern Territories' , 'ATF' , '260' , 'AN' , 'Antarctica' );
INSERT INTO country_continent VALUES ( 'AE' , 'United Arab Emirates' , 'United Arab Emirates' , 'ARE' , '784' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'AF' , 'Afghanistan' , 'Islamic Republic of Afghanistan' , 'AFG' , '004' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'AM' , 'Armenia' , 'Republic of Armenia' , 'ARM' , '051' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'AZ' , 'Azerbaijan' , 'Republic of Azerbaijan' , 'AZE' , '031' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'BD' , 'Bangladesh' , E'People\'s Republic of Bangladesh' , 'BGD' , '050' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'BH' , 'Bahrain' , 'Kingdom of Bahrain' , 'BHR' , '048' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'BN' , 'Brunei Darussalam' , 'Brunei Darussalam' , 'BRN' , '096' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'BT' , 'Bhutan' , 'Kingdom of Bhutan' , 'BTN' , '064' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'CC' , 'Cocos (Keeling) Islands' , 'Cocos (Keeling) Islands' , 'CCK' , '166' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'CN' , 'China' , E'People\'s Republic of China' , 'CHN' , '156' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'CX' , 'Christmas Island' , 'Christmas Island' , 'CXR' , '162' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'CY' , 'Cyprus' , 'Republic of Cyprus' , 'CYP' , '196' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'GE' , 'Georgia' , 'Georgia' , 'GEO' , '268' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'HK' , 'Hong Kong' , 'Hong Kong Special Administrative Region of China' , 'HKG' , '344' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'ID' , 'Indonesia' , 'Republic of Indonesia' , 'IDN' , '360' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'IL' , 'Israel' , 'State of Israel' , 'ISR' , '376' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'IN' , 'India' , 'Republic of India' , 'IND' , '356' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'IO' , 'British Indian Ocean Territory' , 'British Indian Ocean Territory (Chagos Archipelago)' , 'IOT' , '086' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'IQ' , 'Iraq' , 'Republic of Iraq' , 'IRQ' , '368' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'IR' , 'Iran' , 'Islamic Republic of Iran' , 'IRN' , '364' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'JO' , 'Jordan' , 'Hashemite Kingdom of Jordan' , 'JOR' , '400' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'JP' , 'Japan' , 'Japan' , 'JPN' , '392' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'KG' , 'Kyrgyzstan' , 'Kyrgyz Republic' , 'KGZ' , '417' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'KH' , 'Cambodia' , 'Kingdom of Cambodia' , 'KHM' , '116' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'KP' , 'North Korea ' , E'Democratic People\'s Republic of Korea' , 'PRK ' , '408' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'KR' , 'South Korea ' , 'Republic of Korea ' , 'KOR ' , '410' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'KW' , 'Kuwait' , 'State of Kuwait' , 'KWT' , '414' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'KZ' , 'Kazakhstan' , 'Republic of Kazakhstan' , 'KAZ' , '398' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'LA' , 'Laos' , E'Lao People\'s Democratic Republic' , 'LAO' , '418' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'LB' , 'Lebanon' , 'Lebanese Republic' , 'LBN' , '422' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'LK' , 'Sri Lanka' , 'Democratic Socialist Republic of Sri Lanka' , 'LKA' , '144' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'MM' , 'Myanmar' , 'Union of Myanmar' , 'MMR' , '104' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'MN' , 'Mongolia' , 'Mongolia' , 'MNG' , '496' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'MO' , 'Macau' , 'Macao Special Administrative Region of China' , 'MAC' , '446' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'MV' , 'Maldives' , 'Republic of Maldives' , 'MDV' , '462' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'MY' , 'Malaysia' , 'Malaysia' , 'MYS' , '458' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'NP' , 'Nepal' , 'State of Nepal' , 'NPL' , '524' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'OM' , 'Oman' , 'Sultanate of Oman' , 'OMN' , '512' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'PH' , 'Philippines' , 'Republic of the Philippines' , 'PHL' , '608' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'PK' , 'Pakistan' , 'Islamic Republic of Pakistan' , 'PAK' , '586' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'PS' , 'Palestine' , 'Occupied Palestinian Territory' , 'PSE' , '275' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'QA' , 'Qatar' , 'State of Qatar' , 'QAT' , '634' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'SA' , 'Saudi Arabia' , 'Kingdom of Saudi Arabia' , 'SAU' , '682' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'SG' , 'Singapore' , 'Republic of Singapore' , 'SGP' , '702' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'SY' , 'Syria' , 'Syrian Arab Republic' , 'SYR' , '760' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'TH' , 'Thailand' , 'Kingdom of Thailand' , 'THA' , '764' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'TJ' , 'Tajikistan' , 'Republic of Tajikistan' , 'TJK' , '762' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'TL' , 'Timor-Leste' , 'Democratic Republic of Timor-Leste' , 'TLS' , '626' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'TM' , 'Turkmenistan' , 'Turkmenistan' , 'TKM' , '795' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'TR' , 'Turkey' , 'Republic of Turkey' , 'TUR' , '792' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'TW' , 'Taiwan' , 'Taiwan' , 'TWN' , '158' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'UZ' , 'Uzbekistan' , 'Republic of Uzbekistan' , 'UZB' , '860' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'VN' , 'Vietnam' , 'Socialist Republic of Vietnam' , 'VNM' , '704' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'YE' , 'Yemen' , 'Yemen' , 'YEM' , '887' , 'AS' , 'Asia Pacific' );
INSERT INTO country_continent VALUES ( 'AD' , 'Andorra' , 'Principality of Andorra' , 'AND' , '020' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'AL' , 'Albania' , 'Republic of Albania' , 'ALB' , '008' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'AT' , 'Austria' , 'Republic of Austria' , 'AUT' , '040' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'AX' , 'Åland' , 'Åland Islands' , 'ALA' , '248' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'BA' , 'Bosnia and Herzegovina' , 'Bosnia and Herzegovina' , 'BIH' , '070' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'BE' , 'Belgium' , 'Kingdom of Belgium' , 'BEL' , '056' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'BG' , 'Bulgaria' , 'Republic of Bulgaria' , 'BGR' , '100' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'BY' , 'Belarus' , 'Republic of Belarus' , 'BLR' , '112' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'CH' , 'Switzerland' , 'Swiss Confederation' , 'CHE' , '756' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'CZ' , 'Czech Republic' , 'Czech Republic' , 'CZE' , '203' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'DE' , 'Germany' , 'Federal Republic of Germany' , 'DEU' , '276' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'DK' , 'Denmark' , 'Kingdom of Denmark' , 'DNK' , '208' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'EE' , 'Estonia' , 'Republic of Estonia' , 'EST' , '233' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'ES' , 'Spain' , 'Kingdom of Spain' , 'ESP' , '724' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'FI' , 'Finland' , 'Republic of Finland' , 'FIN' , '246' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'FO' , 'Faroe Islands' , 'Faroe Islands' , 'FRO' , '234' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'FR' , 'France' , 'French Republic' , 'FRA' , '250' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'GB' , 'United Kingdom' , 'United Kingdom of Great Britain & Northern Ireland' , 'GBR' , '826' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'GG' , 'Guernsey' , 'Bailiwick of Guernsey' , 'GGY' , '831' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'GI' , 'Gibraltar' , 'Gibraltar' , 'GIB' , '292' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'GR' , 'Greece' , 'Hellenic Republic Greece' , 'GRC' , '300' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'HR' , 'Croatia' , 'Republic of Croatia' , 'HRV' , '191' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'HU' , 'Hungary' , 'Republic of Hungary' , 'HUN' , '348' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'IE' , 'Ireland' , 'Ireland' , 'IRL' , '372' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'IM' , 'Isle of Man' , 'Isle of Man' , 'IMN' , '833' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'IS' , 'Iceland' , 'Republic of Iceland' , 'ISL' , '352' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'IT' , 'Italy' , 'Italian Republic' , 'ITA' , '380' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'JE' , 'Jersey' , 'Bailiwick of Jersey' , 'JEY' , '832' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'LI' , 'Liechtenstein' , 'Principality of Liechtenstein' , 'LIE' , '438' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'LT' , 'Lithuania' , 'Republic of Lithuania' , 'LTU' , '440' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'LU' , 'Luxembourg' , 'Grand Duchy of Luxembourg' , 'LUX' , '442' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'LV' , 'Latvia' , 'Republic of Latvia' , 'LVA' , '428' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'MC' , 'Monaco' , 'Principality of Monaco' , 'MCO' , '492' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'MD' , 'Moldova' , 'Republic of Moldova' , 'MDA' , '498' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'ME' , 'Montenegro' , 'Republic of Montenegro' , 'MNE' , '499' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'MK' , 'Macedonia' , 'Republic of Macedonia' , 'MKD' , '807' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'MT' , 'Malta' , 'Republic of Malta' , 'MLT' , '470' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'NL' , 'Netherlands' , 'Kingdom of the Netherlands' , 'NLD' , '528' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'NO' , 'Norway' , 'Kingdom of Norway' , 'NOR' , '578' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'PL' , 'Poland' , 'Republic of Poland' , 'POL' , '616' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'PT' , 'Portugal' , 'Portuguese Republic' , 'PRT' , '620' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'RO' , 'Romania' , 'Romania' , 'ROU' , '642' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'RS' , 'Serbia' , 'Republic of Serbia' , 'SRB' , '688' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'RU' , 'Russian Federation' , 'Russian Federation' , 'RUS' , '643' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'SE' , 'Sweden' , 'Kingdom of Sweden' , 'SWE' , '752' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'SI' , 'Slovenia' , 'Republic of Slovenia' , 'SVN' , '705' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'SJ' , 'Svalbard and Jan Mayen Islands' , 'Svalbard & Jan Mayen Islands' , 'SJM' , '744' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'SK' , 'Slovakia' , 'Slovakia (Slovak Republic)' , 'SVK' , '703' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'SM' , 'San Marino' , 'Republic of San Marino' , 'SMR' , '674' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'UA' , 'Ukraine' , 'Ukraine' , 'UKR' , '804' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'VA' , 'Vatican City' , 'Holy See (Vatican City State)' , 'VAT' , '336' , 'EU' , 'Europe' );
INSERT INTO country_continent VALUES ( 'AG' , 'Antigua and Barbuda' , 'Antigua and Barbuda' , 'ATG' , '028' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'AI' , 'Anguilla' , 'Anguilla' , 'AIA' , '660' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'AN' , 'Netherlands Antilles' , 'Netherlands Antilles' , 'ANT' , '530' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'AW' , 'Aruba' , 'Aruba' , 'ABW' , '533' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'BB' , 'Barbados' , 'Barbados' , 'BRB' , '052' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'BL' , 'Saint Barthélemy' , 'Saint Barthelemy' , 'BLM' , '652' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'BM' , 'Bermuda' , 'Bermuda' , 'BMU' , '060' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'BS' , 'Bahamas' , 'Commonwealth of the Bahamas' , 'BHS' , '044' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'BZ' , 'Belize' , 'Belize' , 'BLZ' , '084' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'CA' , 'Canada' , 'Canada' , 'CAN' , '124' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'CR' , 'Costa Rica' , 'Republic of Costa Rica' , 'CRI' , '188' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'CU' , 'Cuba' , 'Republic of Cuba' , 'CUB' , '192' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'DM' , 'Dominica' , 'Commonwealth of Dominica' , 'DMA' , '212' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'DO' , 'Dominican Republic' , 'Dominican Republic' , 'DOM' , '214' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'GD' , 'Grenada' , 'Grenada' , 'GRD' , '308' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'GL' , 'Greenland' , 'Greenland' , 'GRL' , '304' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'GP' , 'Guadeloupe' , 'Guadeloupe' , 'GLP' , '312' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'GT' , 'Guatemala' , 'Republic of Guatemala' , 'GTM' , '320' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'HN' , 'Honduras' , 'Republic of Honduras' , 'HND' , '340' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'HT' , 'Haiti' , 'Republic of Haiti' , 'HTI' , '332' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'JM' , 'Jamaica' , 'Jamaica' , 'JAM' , '388' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'KN' , 'Saint Kitts and Nevis' , 'Federation of Saint Kitts and Nevis' , 'KNA' , '659' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'KY' , 'Cayman Islands' , 'Cayman Islands' , 'CYM' , '136' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'LC' , 'Saint Lucia' , 'Saint Lucia' , 'LCA' , '662' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'MF' , 'Saint Martin (French part)' , 'Saint Martin' , 'MAF' , '663' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'MQ' , 'Martinique' , 'Martinique' , 'MTQ' , '474' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'MS' , 'Montserrat' , 'Montserrat' , 'MSR' , '500' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'MX' , 'Mexico' , 'United Mexican States' , 'MEX' , '484' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'NI' , 'Nicaragua' , 'Republic of Nicaragua' , 'NIC' , '558' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'PA' , 'Panama' , 'Republic of Panama' , 'PAN' , '591' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'PM' , 'Saint Pierre and Miquelon' , 'Saint Pierre and Miquelon' , 'SPM' , '666' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'PR' , 'Puerto Rico' , 'Commonwealth of Puerto Rico' , 'PRI' , '630' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'SV' , 'El Salvador' , 'Republic of El Salvador' , 'SLV' , '222' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'TC' , 'Turks and Caicos Islands' , 'Turks and Caicos Islands' , 'TCA' , '796' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'TT' , 'Trinidad and Tobago' , 'Republic of Trinidad and Tobago' , 'TTO' , '780' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'US' , 'United States of America' , 'United States of America' , 'USA' , '840' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'VC' , 'Saint Vincent and the Grenadines' , 'Saint Vincent and the Grenadines' , 'VCT' , '670' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'VG' , 'Virgin Islands British ' , 'British Viriginia Islands ' , 'VGB' , '092 ' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'VI' , 'Virgin Islands US ' , 'United States Virginia Islands ' , 'VIR' , '850 ' , 'NA' , 'North America' );
INSERT INTO country_continent VALUES ( 'AS' , 'American Samoa' , 'American Samoa' , 'ASM' , '016' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'AU' , 'Australia' , 'Commonwealth of Australia' , 'AUS' , '036' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'CK' , 'Cook Islands' , 'Cook Islands' , 'COK' , '184' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'FJ' , 'Fiji' , 'Republic of the Fiji Islands' , 'FJI' , '242' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'FM' , 'Micronesia' , 'Federated States of Micronesia' , 'FSM' , '583' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'GU' , 'Guam' , 'Guam' , 'GUM' , '316' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'KI' , 'Kiribati' , 'Republic of Kiribati' , 'KIR' , '296' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'MH' , 'Marshall Islands' , 'Republic of the Marshall Islands' , 'MHL' , '584' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'MP' , 'Northern Mariana Islands' , 'Commonwealth of the Northern Mariana Islands' , 'MNP' , '580' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'NC' , 'New Caledonia' , 'New Caledonia' , 'NCL' , '540' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'NF' , 'Norfolk Island' , 'Norfolk Island' , 'NFK' , '574' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'NR' , 'Nauru' , 'Republic of Nauru' , 'NRU' , '520' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'NU' , 'Niue' , 'Niue' , 'NIU' , '570' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'NZ' , 'New Zealand' , 'New Zealand' , 'NZL' , '554' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'PF' , 'French Polynesia' , 'French Polynesia' , 'PYF' , '258' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'PG' , 'Papua New Guinea' , 'Independent State of Papua New Guinea' , 'PNG' , '598' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'PN' , 'Pitcairn' , 'Pitcairn Islands' , 'PCN' , '612' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'PW' , 'Palau' , 'Republic of Palau' , 'PLW' , '585' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'SB' , 'Solomon Islands' , 'Solomon Islands' , 'SLB' , '090' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'TK' , 'Tokelau' , 'Tokelau' , 'TKL' , '772' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'TO' , 'Tonga' , 'Kingdom of Tonga' , 'TON' , '776' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'TV' , 'Tuvalu' , 'Tuvalu' , 'TUV' , '798' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'UM' , 'United States Minor Outlying Islands' , 'United States Minor Outlying Islands' , 'UMI' , '581' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'VU' , 'Vanuatu' , 'Republic of Vanuatu' , 'VUT' , '548' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'WF' , 'Wallis and Futuna Islands' , 'Wallis and Futuna' , 'WLF' , '876' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'WS' , 'Samoa' , 'Independent State of Samoa' , 'WSM' , '882' , 'OC' , 'Oceania' );
INSERT INTO country_continent VALUES ( 'AR' , 'Argentina' , 'Argentine Republic' , 'ARG' , '032' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'BO' , 'Bolivia' , 'Republic of Bolivia' , 'BOL' , '068' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'BR' , 'Brazil' , 'Federative Republic of Brazil' , 'BRA' , '076' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'CL' , 'Chile' , 'Republic of Chile' , 'CHL' , '152' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'CO' , 'Colombia' , 'Republic of Colombia' , 'COL' , '170' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'EC' , 'Ecuador' , 'Republic of Ecuador' , 'ECU' , '218' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'FK' , 'Falkland Islands' , 'Falkland Islands (Malvinas)' , 'FLK' , '238' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'GF' , 'French Guiana' , 'French Guiana' , 'GUF' , '254' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'GY' , 'Guyana' , 'Co-operative Republic of Guyana' , 'GUY' , '328' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'PE' , 'Peru' , 'Republic of Peru' , 'PER' , '604' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'PY' , 'Paraguay' , 'Republic of Paraguay' , 'PRY' , '600' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'SR' , 'Suriname' , 'Republic of Suriname' , 'SUR' , '740' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'UY' , 'Uruguay' , 'Eastern Republic of Uruguay' , 'URY' , '858' , 'SA' , 'Latin America' );
INSERT INTO country_continent VALUES ( 'VE' , 'Venezuela' , 'Bolivarian Republic of Venezuela' , 'VEN' , '862' , 'SA' , 'Latin America' );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment