Countries, country code, continent code SQL database dump

countries-continent.sql

BEGIN;
create schema "1";
COMMIT;

CREATE TABLE "1".countries
(
  code     char(2),
  name     varchar(255),
  continentcode  char(2)
);
INSERT INTO "1".countries VALUES ('AD', 'Andorra', 'EU');
INSERT INTO "1".countries VALUES ('AE', 'United Arab Emirates', 'AS');
INSERT INTO "1".countries VALUES ('AF', 'Afghanistan', 'AS');
INSERT INTO "1".countries VALUES ('AG', 'Antigua and Barbuda', 'NA');
INSERT INTO "1".countries VALUES ('AI', 'Anguilla', 'NA');
INSERT INTO "1".countries VALUES ('AL', 'Albania', 'EU');
INSERT INTO "1".countries VALUES ('AM', 'Armenia', 'AS');
INSERT INTO "1".countries VALUES ('AN', 'Netherlands Antilles', 'NA');
INSERT INTO "1".countries VALUES ('AO', 'Angola', 'AF');
INSERT INTO "1".countries VALUES ('AQ', 'Antarctica', 'AN');
INSERT INTO "1".countries VALUES ('AR', 'Argentina', 'SA');
INSERT INTO "1".countries VALUES ('AS', 'American Samoa', 'OC');
INSERT INTO "1".countries VALUES ('AT', 'Austria', 'EU');
INSERT INTO "1".countries VALUES ('AU', 'Australia', 'OC');
INSERT INTO "1".countries VALUES ('AW', 'Aruba', 'NA');
INSERT INTO "1".countries VALUES ('AX', 'Åland', 'EU');
INSERT INTO "1".countries VALUES ('AZ', 'Azerbaijan', 'AS');
INSERT INTO "1".countries VALUES ('BA', 'Bosnia and Herzegovina', 'EU');
INSERT INTO "1".countries VALUES ('BB', 'Barbados', 'NA');
INSERT INTO "1".countries VALUES ('BD', 'Bangladesh', 'AS');
INSERT INTO "1".countries VALUES ('BE', 'Belgium', 'EU');
INSERT INTO "1".countries VALUES ('BF', 'Burkina Faso', 'AF');
INSERT INTO "1".countries VALUES ('BG', 'Bulgaria', 'EU');
INSERT INTO "1".countries VALUES ('BH', 'Bahrain', 'AS');
INSERT INTO "1".countries VALUES ('BI', 'Burundi', 'AF');
INSERT INTO "1".countries VALUES ('BJ', 'Benin', 'AF');
INSERT INTO "1".countries VALUES ('BL', 'Saint Barthélemy', 'NA');
INSERT INTO "1".countries VALUES ('BM', 'Bermuda', 'NA');
INSERT INTO "1".countries VALUES ('BN', 'Brunei Darussalam', 'AS');
INSERT INTO "1".countries VALUES ('BO', 'Bolivia', 'SA');
INSERT INTO "1".countries VALUES ('BR', 'Brazil', 'SA');
INSERT INTO "1".countries VALUES ('BS', 'Bahamas', 'NA');
INSERT INTO "1".countries VALUES ('BT', 'Bhutan', 'AS');
INSERT INTO "1".countries VALUES ('BV', 'Bouvet Island', 'AN');
INSERT INTO "1".countries VALUES ('BW', 'Botswana', 'AF');
INSERT INTO "1".countries VALUES ('BY', 'Belarus', 'EU');
INSERT INTO "1".countries VALUES ('BZ', 'Belize', 'NA');
INSERT INTO "1".countries VALUES ('CA', 'Canada', 'NA');
INSERT INTO "1".countries VALUES ('CC', 'Cocos (Keeling) Islands', 'AS');
INSERT INTO "1".countries VALUES ('CD', 'Congo (Kinshasa)', 'AF');
INSERT INTO "1".countries VALUES ('CF', 'Central African Republic', 'AF');
INSERT INTO "1".countries VALUES ('CG', 'Congo (Brazzaville)', 'AF');
INSERT INTO "1".countries VALUES ('CH', 'Switzerland', 'EU');
INSERT INTO "1".countries VALUES ('CI', 'Côte dIvoire', 'AF');
INSERT INTO "1".countries VALUES ('CK', 'Cook Islands', 'OC');
INSERT INTO "1".countries VALUES ('CL', 'Chile', 'SA');
INSERT INTO "1".countries VALUES ('CM', 'Cameroon', 'AF');
INSERT INTO "1".countries VALUES ('CN', 'China', 'AS');
INSERT INTO "1".countries VALUES ('CO', 'Colombia', 'SA');
INSERT INTO "1".countries VALUES ('CR', 'Costa Rica', 'NA');
INSERT INTO "1".countries VALUES ('CU', 'Cuba', 'NA');
INSERT INTO "1".countries VALUES ('CV', 'Cape Verde', 'AF');
INSERT INTO "1".countries VALUES ('CX', 'Christmas Island', 'AS');
INSERT INTO "1".countries VALUES ('CY', 'Cyprus', 'AS');
INSERT INTO "1".countries VALUES ('CZ', 'Czech Republic', 'EU');
INSERT INTO "1".countries VALUES ('DE', 'Germany', 'EU');
INSERT INTO "1".countries VALUES ('DJ', 'Djibouti', 'AF');
INSERT INTO "1".countries VALUES ('DK', 'Denmark', 'EU');
INSERT INTO "1".countries VALUES ('DM', 'Dominica', 'NA');
INSERT INTO "1".countries VALUES ('DO', 'Dominican Republic', 'NA');
INSERT INTO "1".countries VALUES ('DZ', 'Algeria', 'AF');
INSERT INTO "1".countries VALUES ('EC', 'Ecuador', 'SA');
INSERT INTO "1".countries VALUES ('EE', 'Estonia', 'EU');
INSERT INTO "1".countries VALUES ('EG', 'Egypt', 'AF');
INSERT INTO "1".countries VALUES ('EH', 'Western Sahara', 'AF');
INSERT INTO "1".countries VALUES ('ER', 'Eritrea', 'AF');
INSERT INTO "1".countries VALUES ('ES', 'Spain', 'EU');
INSERT INTO "1".countries VALUES ('ET', 'Ethiopia', 'AF');
INSERT INTO "1".countries VALUES ('FI', 'Finland', 'EU');
INSERT INTO "1".countries VALUES ('FJ', 'Fiji', 'OC');
INSERT INTO "1".countries VALUES ('FK', 'Falkland Islands', 'SA');
INSERT INTO "1".countries VALUES ('FM', 'Micronesia', 'OC');
INSERT INTO "1".countries VALUES ('FO', 'Faroe Islands', 'EU');
INSERT INTO "1".countries VALUES ('FR', 'France', 'EU');
INSERT INTO "1".countries VALUES ('GA', 'Gabon', 'AF');
INSERT INTO "1".countries VALUES ('GB', 'United Kingdom', 'EU');
INSERT INTO "1".countries VALUES ('GD', 'Grenada', 'NA');
INSERT INTO "1".countries VALUES ('GE', 'Georgia', 'AS');
INSERT INTO "1".countries VALUES ('GF', 'French Guiana', 'SA');
INSERT INTO "1".countries VALUES ('GG', 'Guernsey', 'EU');
INSERT INTO "1".countries VALUES ('GH', 'Ghana', 'AF');
INSERT INTO "1".countries VALUES ('GI', 'Gibraltar', 'EU');
INSERT INTO "1".countries VALUES ('GL', 'Greenland', 'NA');
INSERT INTO "1".countries VALUES ('GM', 'Gambia', 'AF');
INSERT INTO "1".countries VALUES ('GN', 'Guinea', 'AF');
INSERT INTO "1".countries VALUES ('GP', 'Guadeloupe', 'NA');
INSERT INTO "1".countries VALUES ('GQ', 'Equatorial Guinea', 'AF');
INSERT INTO "1".countries VALUES ('GR', 'Greece', 'EU');
INSERT INTO "1".countries VALUES ('GS', 'South Georgia and South Sandwich Islands', 'AN');
INSERT INTO "1".countries VALUES ('GT', 'Guatemala', 'NA');
INSERT INTO "1".countries VALUES ('GU', 'Guam', 'OC');
INSERT INTO "1".countries VALUES ('GW', 'Guinea-Bissau', 'AF');
INSERT INTO "1".countries VALUES ('GY', 'Guyana', 'SA');
INSERT INTO "1".countries VALUES ('HK', 'Hong Kong', 'AS');
INSERT INTO "1".countries VALUES ('HM', 'Heard and McDonald Islands', 'AN');
INSERT INTO "1".countries VALUES ('HN', 'Honduras', 'NA');
INSERT INTO "1".countries VALUES ('HR', 'Croatia', 'EU');
INSERT INTO "1".countries VALUES ('HT', 'Haiti', 'NA');
INSERT INTO "1".countries VALUES ('HU', 'Hungary', 'EU');
INSERT INTO "1".countries VALUES ('ID', 'Indonesia', 'AS');
INSERT INTO "1".countries VALUES ('IE', 'Ireland', 'EU');
INSERT INTO "1".countries VALUES ('IL', 'Israel', 'AS');
INSERT INTO "1".countries VALUES ('IM', 'Isle of Man', 'EU');
INSERT INTO "1".countries VALUES ('IN', 'India', 'AS');
INSERT INTO "1".countries VALUES ('IO', 'British Indian Ocean Territory', 'AS');
INSERT INTO "1".countries VALUES ('IQ', 'Iraq', 'AS');
INSERT INTO "1".countries VALUES ('IR', 'Iran', 'AS');
INSERT INTO "1".countries VALUES ('IS', 'Iceland', 'EU');
INSERT INTO "1".countries VALUES ('IT', 'Italy', 'EU');
INSERT INTO "1".countries VALUES ('JE', 'Jersey', 'EU');
INSERT INTO "1".countries VALUES ('JM', 'Jamaica', 'NA');
INSERT INTO "1".countries VALUES ('JO', 'Jordan', 'AS');
INSERT INTO "1".countries VALUES ('JP', 'Japan', 'AS');
INSERT INTO "1".countries VALUES ('KE', 'Kenya', 'AF');
INSERT INTO "1".countries VALUES ('KG', 'Kyrgyzstan', 'AS');
INSERT INTO "1".countries VALUES ('KH', 'Cambodia', 'AS');
INSERT INTO "1".countries VALUES ('KI', 'Kiribati', 'OC');
INSERT INTO "1".countries VALUES ('KM', 'Comoros', 'AF');
INSERT INTO "1".countries VALUES ('KN', 'Saint Kitts and Nevis', 'NA');
INSERT INTO "1".countries VALUES ('KP', 'Korea, North', 'AS');
INSERT INTO "1".countries VALUES ('KR', 'Korea, South', 'AS');
INSERT INTO "1".countries VALUES ('KW', 'Kuwait', 'AS');
INSERT INTO "1".countries VALUES ('KY', 'Cayman Islands', 'NA');
INSERT INTO "1".countries VALUES ('KZ', 'Kazakhstan', 'AS');
INSERT INTO "1".countries VALUES ('LA', 'Laos', 'AS');
INSERT INTO "1".countries VALUES ('LB', 'Lebanon', 'AS');
INSERT INTO "1".countries VALUES ('LC', 'Saint Lucia', 'NA');
INSERT INTO "1".countries VALUES ('LI', 'Liechtenstein', 'EU');
INSERT INTO "1".countries VALUES ('LK', 'Sri Lanka', 'AS');
INSERT INTO "1".countries VALUES ('LR', 'Liberia', 'AF');
INSERT INTO "1".countries VALUES ('LS', 'Lesotho', 'AF');
INSERT INTO "1".countries VALUES ('LT', 'Lithuania', 'EU');
INSERT INTO "1".countries VALUES ('LU', 'Luxembourg', 'EU');
INSERT INTO "1".countries VALUES ('LV', 'Latvia', 'EU');
INSERT INTO "1".countries VALUES ('LY', 'Libya', 'AF');
INSERT INTO "1".countries VALUES ('MA', 'Morocco', 'AF');
INSERT INTO "1".countries VALUES ('MC', 'Monaco', 'EU');
INSERT INTO "1".countries VALUES ('MD', 'Moldova', 'EU');
INSERT INTO "1".countries VALUES ('ME', 'Montenegro', 'EU');
INSERT INTO "1".countries VALUES ('MF', 'Saint Martin (French part)', 'NA');
INSERT INTO "1".countries VALUES ('MG', 'Madagascar', 'AF');
INSERT INTO "1".countries VALUES ('MH', 'Marshall Islands', 'OC');
INSERT INTO "1".countries VALUES ('MK', 'Macedonia', 'EU');
INSERT INTO "1".countries VALUES ('ML', 'Mali', 'AF');
INSERT INTO "1".countries VALUES ('MM', 'Myanmar', 'AS');
INSERT INTO "1".countries VALUES ('MN', 'Mongolia', 'AS');
INSERT INTO "1".countries VALUES ('MO', 'Macau', 'AS');
INSERT INTO "1".countries VALUES ('MP', 'Northern Mariana Islands', 'OC');
INSERT INTO "1".countries VALUES ('MQ', 'Martinique', 'NA');
INSERT INTO "1".countries VALUES ('MR', 'Mauritania', 'AF');
INSERT INTO "1".countries VALUES ('MS', 'Montserrat', 'NA');
INSERT INTO "1".countries VALUES ('MT', 'Malta', 'EU');
INSERT INTO "1".countries VALUES ('MU', 'Mauritius', 'AF');
INSERT INTO "1".countries VALUES ('MV', 'Maldives', 'AS');
INSERT INTO "1".countries VALUES ('MW', 'Malawi', 'AF');
INSERT INTO "1".countries VALUES ('MX', 'Mexico', 'NA');
INSERT INTO "1".countries VALUES ('MY', 'Malaysia', 'AS');
INSERT INTO "1".countries VALUES ('MZ', 'Mozambique', 'AF');
INSERT INTO "1".countries VALUES ('NA', 'Namibia', 'AF');
INSERT INTO "1".countries VALUES ('NC', 'New Caledonia', 'OC');
INSERT INTO "1".countries VALUES ('NE', 'Niger', 'AF');
INSERT INTO "1".countries VALUES ('NF', 'Norfolk Island', 'OC');
INSERT INTO "1".countries VALUES ('NG', 'Nigeria', 'AF');
INSERT INTO "1".countries VALUES ('NI', 'Nicaragua', 'NA');
INSERT INTO "1".countries VALUES ('NL', 'Netherlands', 'EU');
INSERT INTO "1".countries VALUES ('NO', 'Norway', 'EU');
INSERT INTO "1".countries VALUES ('NP', 'Nepal', 'AS');
INSERT INTO "1".countries VALUES ('NR', 'Nauru', 'OC');
INSERT INTO "1".countries VALUES ('NU', 'Niue', 'OC');
INSERT INTO "1".countries VALUES ('NZ', 'New Zealand', 'OC');
INSERT INTO "1".countries VALUES ('OM', 'Oman', 'AS');
INSERT INTO "1".countries VALUES ('PA', 'Panama', 'NA');
INSERT INTO "1".countries VALUES ('PE', 'Peru', 'SA');
INSERT INTO "1".countries VALUES ('PF', 'French Polynesia', 'OC');
INSERT INTO "1".countries VALUES ('PG', 'Papua New Guinea', 'OC');
INSERT INTO "1".countries VALUES ('PH', 'Philippines', 'AS');
INSERT INTO "1".countries VALUES ('PK', 'Pakistan', 'AS');
INSERT INTO "1".countries VALUES ('PL', 'Poland', 'EU');
INSERT INTO "1".countries VALUES ('PM', 'Saint Pierre and Miquelon', 'NA');
INSERT INTO "1".countries VALUES ('PN', 'Pitcairn', 'OC');
INSERT INTO "1".countries VALUES ('PR', 'Puerto Rico', 'NA');
INSERT INTO "1".countries VALUES ('PS', 'Palestine', 'AS');
INSERT INTO "1".countries VALUES ('PT', 'Portugal', 'EU');
INSERT INTO "1".countries VALUES ('PW', 'Palau', 'OC');
INSERT INTO "1".countries VALUES ('PY', 'Paraguay', 'SA');
INSERT INTO "1".countries VALUES ('QA', 'Qatar', 'AS');
INSERT INTO "1".countries VALUES ('RE', 'Reunion', 'AF');
INSERT INTO "1".countries VALUES ('RO', 'Romania', 'EU');
INSERT INTO "1".countries VALUES ('RS', 'Serbia', 'EU');
INSERT INTO "1".countries VALUES ('RU', 'Russian Federation', 'EU');
INSERT INTO "1".countries VALUES ('RW', 'Rwanda', 'AF');
INSERT INTO "1".countries VALUES ('SA', 'Saudi Arabia', 'AS');
INSERT INTO "1".countries VALUES ('SB', 'Solomon Islands', 'OC');
INSERT INTO "1".countries VALUES ('SC', 'Seychelles', 'AF');
INSERT INTO "1".countries VALUES ('SD', 'Sudan', 'AF');
INSERT INTO "1".countries VALUES ('SE', 'Sweden', 'EU');
INSERT INTO "1".countries VALUES ('SG', 'Singapore', 'AS');
INSERT INTO "1".countries VALUES ('SH', 'Saint Helena', 'AF');
INSERT INTO "1".countries VALUES ('SI', 'Slovenia', 'EU');
INSERT INTO "1".countries VALUES ('SJ', 'Svalbard and Jan Mayen Islands', 'EU');
INSERT INTO "1".countries VALUES ('SK', 'Slovakia', 'EU');
INSERT INTO "1".countries VALUES ('SL', 'Sierra Leone', 'AF');
INSERT INTO "1".countries VALUES ('SM', 'San Marino', 'EU');
INSERT INTO "1".countries VALUES ('SN', 'Senegal', 'AF');
INSERT INTO "1".countries VALUES ('SO', 'Somalia', 'AF');
INSERT INTO "1".countries VALUES ('SR', 'Suriname', 'SA');
INSERT INTO "1".countries VALUES ('ST', 'Sao Tome and Principe', 'AF');
INSERT INTO "1".countries VALUES ('SV', 'El Salvador', 'NA');
INSERT INTO "1".countries VALUES ('SY', 'Syria', 'AS');
INSERT INTO "1".countries VALUES ('SZ', 'Swaziland', 'AF');
INSERT INTO "1".countries VALUES ('TC', 'Turks and Caicos Islands', 'NA');
INSERT INTO "1".countries VALUES ('TD', 'Chad', 'AF');
INSERT INTO "1".countries VALUES ('TF', 'French Southern Lands', 'AN');
INSERT INTO "1".countries VALUES ('TG', 'Togo', 'AF');
INSERT INTO "1".countries VALUES ('TH', 'Thailand', 'AS');
INSERT INTO "1".countries VALUES ('TJ', 'Tajikistan', 'AS');
INSERT INTO "1".countries VALUES ('TK', 'Tokelau', 'OC');
INSERT INTO "1".countries VALUES ('TL', 'Timor-Leste', 'AS');
INSERT INTO "1".countries VALUES ('TM', 'Turkmenistan', 'AS');
INSERT INTO "1".countries VALUES ('TN', 'Tunisia', 'AF');
INSERT INTO "1".countries VALUES ('TO', 'Tonga', 'OC');
INSERT INTO "1".countries VALUES ('TR', 'Turkey', 'AS');
INSERT INTO "1".countries VALUES ('TT', 'Trinidad and Tobago', 'NA');
INSERT INTO "1".countries VALUES ('TV', 'Tuvalu', 'OC');
INSERT INTO "1".countries VALUES ('TW', 'Taiwan', 'AS');
INSERT INTO "1".countries VALUES ('TZ', 'Tanzania', 'AF');
INSERT INTO "1".countries VALUES ('UA', 'Ukraine', 'EU');
INSERT INTO "1".countries VALUES ('UG', 'Uganda', 'AF');
INSERT INTO "1".countries VALUES ('UM', 'United States Minor Outlying Islands', 'OC');
INSERT INTO "1".countries VALUES ('US', 'United States of America', 'NA');
INSERT INTO "1".countries VALUES ('UY', 'Uruguay', 'SA');
INSERT INTO "1".countries VALUES ('UZ', 'Uzbekistan', 'AS');
INSERT INTO "1".countries VALUES ('VA', 'Vatican City', 'EU');
INSERT INTO "1".countries VALUES ('VC', 'Saint Vincent and the Grenadines', 'NA');
INSERT INTO "1".countries VALUES ('VE', 'Venezuela', 'SA');
INSERT INTO "1".countries VALUES ('VG', 'Virgin Islands, British', 'NA');
INSERT INTO "1".countries VALUES ('VI', 'Virgin Islands, U.S.', 'NA');
INSERT INTO "1".countries VALUES ('VN', 'Vietnam', 'AS');
INSERT INTO "1".countries VALUES ('VU', 'Vanuatu', 'OC');
INSERT INTO "1".countries VALUES ('WF', 'Wallis and Futuna Islands', 'OC');
INSERT INTO "1".countries VALUES ('WS', 'Samoa', 'OC');
INSERT INTO "1".countries VALUES ('YE', 'Yemen', 'AS');
INSERT INTO "1".countries VALUES ('YT', 'Mayotte', 'AF');
INSERT INTO "1".countries VALUES ('ZA', 'South Africa', 'AF');
INSERT INTO "1".countries VALUES ('ZM', 'Zambia', 'AF');
INSERT INTO "1".countries VALUES ('ZW', 'Zimbabwe', 'AF');