-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcountries.sql
278 lines (275 loc) · 44.5 KB
/
countries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
DROP TABLE IF EXISTS countries;
CREATE TABLE countries (
id SMALLINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
name VARCHAR(100) NOT NULL,
iso2 CHAR(2) NOT NULL UNIQUE, -- 2-letter ISO country code
iso3 CHAR(3) NOT NULL UNIQUE, -- 3-letter ISO country code
currency_code CHAR(5) NOT NULL, -- ISO 4217 currency code (e.g., USD, EUR, GBP)
currency_name VARCHAR(50) NOT NULL, -- Full currency name (e.g., US Dollar, Euro, British Pound)
currency_symbol VARCHAR(5) NOT NULL, -- Currency symbol (e.g., $, €, £)
phone_code VARCHAR(10) NOT NULL, -- Country calling code (e.g., +1, +44)
phone_format VARCHAR(20) NOT NULL, -- Example: (###) ###-####
continent TEXT NOT NULL CHECK (continent IN ('Africa', 'Asia', 'Europe', 'North America', 'Oceania', 'South America', 'Antarctica')),
region VARCHAR(50) NOT NULL, -- Example: Western Europe, Sub-Saharan Africa
subregion VARCHAR(50) NOT NULL, -- Example: Caribbean, Southern Africa
latitude DECIMAL(8,6) NOT NULL, -- Precision for geolocation
longitude DECIMAL(9,6) NOT NULL,
capital VARCHAR(100) NOT NULL, -- Capital city
tld VARCHAR(10) NOT NULL, -- Top-Level Domain (.us, .uk, .de)
flag_emoji TEXT NOT NULL, -- Unicode flag emoji
created_at TIMESTAMPTZ DEFAULT NOW(),
updated_at TIMESTAMPTZ DEFAULT NOW()
);
-- Keep existing indexes
CREATE INDEX idx_countries_name ON countries (name);
CREATE INDEX idx_countries_continent ON countries (continent);
CREATE INDEX idx_countries_region ON countries (region);
CREATE INDEX idx_countries_phone_prefix ON countries (phone_code);
CREATE INDEX idx_countries_latlong ON countries USING GIST (point(latitude, longitude));
CREATE INDEX idx_countries_currency ON countries (currency_code);
INSERT INTO countries (
name, iso2, iso3, continent, region, subregion,
latitude, longitude, phone_code,
phone_format, capital, tld,
flag_emoji, currency_code, currency_name, currency_symbol
) VALUES
('Afghanistan', 'AF', 'AFG', 'Asia', 'Southern Asia', 'Central Asia', 33.939110, 67.709953, '+93', '## ### ####', 'Kabul', '.af', '🇦🇫', 'AFN', 'Afghan Afghani', '؋'),
('Albania', 'AL', 'ALB', 'Europe', 'Southern Europe', 'Balkans', 41.153332, 20.168331, '+355', '### ### ###', 'Tirana', '.al', '🇦🇱', 'ALL', 'Albanian Lek', 'L'),
('Algeria', 'DZ', 'DZA', 'Africa', 'Northern Africa', 'Maghreb', 36.752887, 3.042048, '+213', '### ## ## ##', 'Algiers', '.dz', '🇩🇿', 'DZD', 'Algerian Dinar', 'د.ج'),
('Andorra', 'AD', 'AND', 'Europe', 'Southern Europe', 'Western Europe', 42.546245, 1.601554, '+376', '### ###', 'Andorra la Vella', '.ad', '🇦🇩', 'EUR', 'Euro', '€'),
('Angola', 'AO', 'AGO', 'Africa', 'Middle Africa', 'Central Africa', -8.839988, 13.289437, '+244', '### ### ###', 'Luanda', '.ao', '🇦🇴', 'AOA', 'Angolan Kwanza', 'Kz'),
('Antigua and Barbuda', 'AG', 'ATG', 'North America', 'Caribbean', 'Lesser Antilles', 17.060816, -61.796428, '+1268', '### ####', 'Saint Johns', '.ag', '🇦🇬', 'XCD', 'East Caribbean Dollar', '$'),
('Argentina', 'AR', 'ARG', 'South America', 'South America', 'Southern Cone', -34.603684, -58.381559, '+54', '### ### ####', 'Buenos Aires', '.ar', '🇦🇷', 'ARS', 'Argentine Peso', '$'),
('Armenia', 'AM', 'ARM', 'Asia', 'Western Asia', 'Caucasus', 40.069099, 45.038189, '+374', '## ### ###', 'Yerevan', '.am', '🇦🇲', 'AMD', 'Armenian Dram', '֏'),
('Australia', 'AU', 'AUS', 'Oceania', 'Australasia', 'Australia and New Zealand', -35.280937, 149.130005, '+61', '### ### ###', 'Canberra', '.au', '🇦🇺', 'AUD', 'Australian Dollar', '$'),
('Austria', 'AT', 'AUT', 'Europe', 'Western Europe', 'Central Europe', 48.208174, 16.373819, '+43', '### ### ####', 'Vienna', '.at', '🇦🇹', 'EUR', 'Euro', '€'),
('Azerbaijan', 'AZ', 'AZE', 'Asia', 'Western Asia', 'Caucasus', 40.409262, 49.867092, '+994', '## ### ## ##', 'Baku', '.az', '🇦🇿', 'AZN', 'Azerbaijani Manat', '₼'),
('Bahamas', 'BS', 'BHS', 'North America', 'Caribbean', 'Greater Antilles', 25.047984, -77.355413, '+1242', '### ####', 'Nassau', '.bs', '🇧🇸', 'BSD', 'Bahamian Dollar', '$'),
('Bahrain', 'BH', 'BHR', 'Asia', 'Western Asia', 'Arabian Peninsula', 26.228516, 50.586056, '+973', '#### ####', 'Manama', '.bh', '🇧🇭', 'BHD', 'Bahraini Dinar', '.د.ب'),
('Bangladesh', 'BD', 'BGD', 'Asia', 'Southern Asia', 'South Asia', 23.810332, 90.412518, '+880', '## ### ####', 'Dhaka', '.bd', '🇧🇩', 'BDT', 'Bangladeshi Taka', '৳'),
('Barbados', 'BB', 'BRB', 'North America', 'Caribbean', 'Lesser Antilles', 13.106725, -59.613220, '+1246', '### ####', 'Bridgetown', '.bb', '🇧🇧', 'BBD', 'Barbadian Dollar', '$'),
('Belarus', 'BY', 'BLR', 'Europe', 'Eastern Europe', 'Eastern Europe', 53.904540, 27.561524, '+375', '## ### ## ##', 'Minsk', '.by', '🇧🇾', 'BYN', 'Belarusian Ruble', 'Br'),
('Belgium', 'BE', 'BEL', 'Europe', 'Western Europe', 'Benelux', 50.850346, 4.351721, '+32', '### ### ###', 'Brussels', '.be', '🇧🇪', 'EUR', 'Euro', '€'),
('Belize', 'BZ', 'BLZ', 'North America', 'Central America', 'Central America', 17.251011, -88.767303, '+501', '### ####', 'Belmopan', '.bz', '🇧🇿', 'BZD', 'Belize Dollar', '$'),
('Benin', 'BJ', 'BEN', 'Africa', 'Western Africa', 'West Africa', 6.496857, 2.628852, '+229', '## ## ## ##', 'Porto-Novo', '.bj', '🇧🇯', 'XOF', 'West African CFA Franc', 'CFA'),
('Bhutan', 'BT', 'BTN', 'Asia', 'Southern Asia', 'South Asia', 27.472792, 89.639286, '+975', '## ### ###', 'Thimphu', '.bt', '🇧🇹', 'BTN', 'Bhutanese Ngultrum', 'Nu.'),
('Bolivia', 'BO', 'BOL', 'South America', 'South America', 'Central South America', -16.489689, -68.119294, '+591', '# ### ####', 'La Paz', '.bo', '🇧🇴', 'BOB', 'Bolivian Boliviano', 'Bs.'),
('Bosnia and Herzegovina', 'BA', 'BIH', 'Europe', 'Southern Europe', 'Balkans', 43.856430, 18.413029, '+387', '## ### ###', 'Sarajevo', '.ba', '🇧🇦', 'BAM', 'Bosnia and Herzegovina Convertible Mark', 'KM'),
('Botswana', 'BW', 'BWA', 'Africa', 'Southern Africa', 'Southern Africa', -24.628208, 25.923147, '+267', '## ### ###', 'Gaborone', '.bw', '🇧🇼', 'BWP', 'Botswana Pula', 'P'),
('Brazil', 'BR', 'BRA', 'South America', 'South America', 'Eastern South America', -15.794229, -47.882166, '+55', '## #### ####', 'Brasília', '.br', '🇧🇷', 'BRL', 'Brazilian Real', 'R$'),
('Brunei', 'BN', 'BRN', 'Asia', 'South-Eastern Asia', 'Maritime Southeast Asia', 4.903052, 114.939821, '+673', '### ####', 'Bandar Seri Begawan', '.bn', '🇧🇳', 'BND', 'Brunei Dollar', '$'),
('Bulgaria', 'BG', 'BGR', 'Europe', 'Eastern Europe', 'Balkans', 42.697708, 23.321868, '+359', '### ### ###', 'Sofia', '.bg', '🇧🇬', 'BGN', 'Bulgarian Lev', 'лв'),
('Burkina Faso', 'BF', 'BFA', 'Africa', 'Western Africa', 'West Africa', 12.371428, -1.519308, '+226', '## ## ## ##', 'Ouagadougou', '.bf', '🇧🇫', 'XOF', 'West African CFA Franc', 'CFA'),
('Burundi', 'BI', 'BDI', 'Africa', 'Eastern Africa', 'East Africa', -3.361378, 29.359878, '+257', '## ## ## ##', 'Gitega', '.bi', '🇧🇮', 'BIF', 'Burundian Franc', 'FBu'),
('Cambodia', 'KH', 'KHM', 'Asia', 'South-Eastern Asia', 'Mainland Southeast Asia', 11.544873, 104.892167, '+855', '## ### ###', 'Phnom Penh', '.kh', '🇰🇭', 'KHR', 'Cambodian Riel', '៛'),
('Cameroon', 'CM', 'CMR', 'Africa', 'Middle Africa', 'Central Africa', 3.848033, 11.502075, '+237', '#### ## ## ##', 'Yaoundé', '.cm', '🇨🇲', 'XAF', 'Central African CFA Franc', 'FCFA'),
('Canada', 'CA', 'CAN', 'North America', 'Northern America', 'North America', 45.421530, -75.697193, '+1', '### ### ####', 'Ottawa', '.ca', '🇨🇦', 'CAD', 'Canadian Dollar', '$'),
('Cape Verde', 'CV', 'CPV', 'Africa', 'Western Africa', 'West Africa', 14.933220, -23.513327, '+238', '### ## ##', 'Praia', '.cv', '🇨🇻', 'CVE', 'Cape Verdean Escudo', '$'),
('Central African Republic', 'CF', 'CAF', 'Africa', 'Middle Africa', 'Central Africa', 4.394674, 18.558190, '+236', '## ## ## ##', 'Bangui', '.cf', '🇨🇫', 'XAF', 'Central African CFA Franc', 'FCFA'),
('Chad', 'TD', 'TCD', 'Africa', 'Middle Africa', 'Central Africa', 12.134846, 15.055742, '+235', '## ## ## ##', 'NDjamena', '.td', '🇹🇩', 'XAF', 'Central African CFA Franc', 'FCFA'),
('Chile', 'CL', 'CHL', 'South America', 'South America', 'Southern Cone', -33.448890, -70.669265, '+56', '# #### ####', 'Santiago', '.cl', '🇨🇱', 'CLP', 'Chilean Peso', '$'),
('China', 'CN', 'CHN', 'Asia', 'Eastern Asia', 'East Asia', 39.904200, 116.407396, '+86', '### #### ####', 'Beijing', '.cn', '🇨🇳', 'CNY', 'Chinese Yuan', '¥'),
('Colombia', 'CO', 'COL', 'South America', 'South America', 'Northern South America', 4.710989, -74.072092, '+57', '### ### ####', 'Bogotá', '.co', '🇨🇴', 'COP', 'Colombian Peso', '$'),
('Comoros', 'KM', 'COM', 'Africa', 'Eastern Africa', 'East Africa', -11.717216, 43.247315, '+269', '### ####', 'Moroni', '.km', '🇰🇲', 'KMF', 'Comorian Franc', 'CF'),
('Costa Rica', 'CR', 'CRI', 'North America', 'Central America', 'Central America', 9.932737, -84.078720, '+506', '#### ####', 'San José', '.cr', '🇨🇷', 'CRC', 'Costa Rican Colón', '₡'),
('Croatia', 'HR', 'HRV', 'Europe', 'Southern Europe', 'Balkans', 45.815011, 15.981919, '+385', '## ### ####', 'Zagreb', '.hr', '🇭🇷', 'EUR', 'Euro', '€'),
('Cuba', 'CU', 'CUB', 'North America', 'Caribbean', 'Greater Antilles', 23.113592, -82.366596, '+53', '# ### ####', 'Havana', '.cu', '🇨🇺', 'CUP', 'Cuban Peso', '₱'),
('Cyprus', 'CY', 'CYP', 'Europe', 'Southern Europe', 'Mediterranean', 35.185566, 33.382275, '+357', '## ### ###', 'Nicosia', '.cy', '🇨🇾', 'EUR', 'Euro', '€'),
('Czech Republic', 'CZ', 'CZE', 'Europe', 'Eastern Europe', 'Central Europe', 50.075538, 14.437800, '+420', '### ### ###', 'Prague', '.cz', '🇨🇿', 'CZK', 'Czech Koruna', 'Kč'),
('DR Congo', 'CD', 'COD', 'Africa', 'Middle Africa', 'Central Africa', -4.441931, 15.266293, '+243', '### ### ###', 'Kinshasa', '.cd', '🇨🇩', 'CDF', 'Congolese Franc', 'FC'),
('Denmark', 'DK', 'DNK', 'Europe', 'Northern Europe', 'Scandinavia', 55.676097, 12.568337, '+45', '## ## ## ##', 'Copenhagen', '.dk', '🇩🇰', 'DKK', 'Danish Krone', 'kr'),
('Djibouti', 'DJ', 'DJI', 'Africa', 'Eastern Africa', 'Horn of Africa', 11.825138, 42.590275, '+253', '## ## ## ##', 'Djibouti', '.dj', '🇩🇯', 'DJF', 'Djiboutian Franc', 'Fdj'),
('Dominica', 'DM', 'DMA', 'North America', 'Caribbean', 'Lesser Antilles', 15.414999, -61.370976, '+1767', '### ####', 'Roseau', '.dm', '🇩🇲', 'XCD', 'East Caribbean Dollar', '$'),
('Dominican Republic', 'DO', 'DOM', 'North America', 'Caribbean', 'Greater Antilles', 18.486058, -69.931212, '+1809', '### ###-####', 'Santo Domingo', '.do', '🇩🇴', 'DOP', 'Dominican Peso', 'RD$'),
('Ecuador', 'EC', 'ECU', 'South America', 'South America', 'Northern South America', -0.180653, -78.467838, '+593', '## ### ####', 'Quito', '.ec', '🇪🇨', 'USD', 'United States Dollar', '$'),
('Egypt', 'EG', 'EGY', 'Africa', 'Northern Africa', 'North Africa', 30.044420, 31.235712, '+20', '### ### ####', 'Cairo', '.eg', '🇪🇬', 'EGP', 'Egyptian Pound', 'E£'),
('El Salvador', 'SV', 'SLV', 'North America', 'Central America', 'Central America', 13.794185, -88.896530, '+503', '#### ####', 'San Salvador', '.sv', '🇸🇻', 'USD', 'United States Dollar', '$'),
('Equatorial Guinea', 'GQ', 'GNQ', 'Africa', 'Middle Africa', 'Central Africa', 3.750412, 8.737104, '+240', '## ### ####', 'Malabo', '.gq', '🇬🇶', 'XAF', 'Central African CFA Franc', 'FCFA'),
('Eritrea', 'ER', 'ERI', 'Africa', 'Eastern Africa', 'Horn of Africa', 15.322877, 38.925052, '+291', '# ### ###', 'Asmara', '.er', '🇪🇷', 'ERN', 'Eritrean Nakfa', 'Nfk'),
('Estonia', 'EE', 'EST', 'Europe', 'Northern Europe', 'Baltic States', 59.436961, 24.753575, '+372', '### ####', 'Tallinn', '.ee', '🇪🇪', 'EUR', 'Euro', '€'),
('Ethiopia', 'ET', 'ETH', 'Africa', 'Eastern Africa', 'Horn of Africa', 9.145000, 38.736946, '+251', '## ### ####', 'Addis Ababa', '.et', '🇪🇹', 'ETB', 'Ethiopian Birr', 'Br'),
('Fiji', 'FJ', 'FJI', 'Oceania', 'Melanesia', 'South Pacific', -18.124779, 178.450806, '+679', '### ####', 'Suva', '.fj', '🇫🇯', 'FJD', 'Fijian Dollar', '$'),
('Finland', 'FI', 'FIN', 'Europe', 'Northern Europe', 'Nordic Countries', 60.173324, 24.941025, '+358', '### ### ###', 'Helsinki', '.fi', '🇫🇮', 'EUR', 'Euro', '€'),
('France', 'FR', 'FRA', 'Europe', 'Western Europe', 'Western Europe', 48.856614, 2.352222, '+33', '# ## ## ## ##', 'Paris', '.fr', '🇫🇷', 'EUR', 'Euro', '€'),
('Gabon', 'GA', 'GAB', 'Africa', 'Middle Africa', 'Central Africa', 0.416198, 9.467268, '+241', '# ## ## ##', 'Libreville', '.ga', '🇬🇦', 'XAF', 'Central African CFA Franc', 'FCFA'),
('Gambia', 'GM', 'GMB', 'Africa', 'Western Africa', 'West Africa', 13.454876, -16.579032, '+220', '### ####', 'Banjul', '.gm', '🇬🇲', 'GMD', 'Gambian Dalasi', 'D'),
('Georgia', 'GE', 'GEO', 'Asia', 'Western Asia', 'Caucasus', 41.715138, 44.827096, '+995', '### ### ###', 'Tbilisi', '.ge', '🇬🇪', 'GEL', 'Georgian Lari', '₾'),
('Germany', 'DE', 'DEU', 'Europe', 'Western Europe', 'Central Europe', 52.520007, 13.404954, '+49', '### ### ####', 'Berlin', '.de', '🇩🇪', 'EUR', 'Euro', '€'),
('Ghana', 'GH', 'GHA', 'Africa', 'Western Africa', 'West Africa', 5.603717, -0.186964, '+233', '### ### ###', 'Accra', '.gh', '🇬🇭', 'GHS', 'Ghanaian Cedi', '₵'),
('Greece', 'GR', 'GRC', 'Europe', 'Southern Europe', 'Mediterranean', 37.983810, 23.727539, '+30', '### ### ####', 'Athens', '.gr', '🇬🇷', 'EUR', 'Euro', '€'),
('Grenada', 'GD', 'GRD', 'North America', 'Caribbean', 'Lesser Antilles', 12.056098, -61.749421, '+1473', '### ####', 'St. George''s', '.gd', '🇬🇩', 'XCD', 'East Caribbean Dollar', '$'),
('Guatemala', 'GT', 'GTM', 'North America', 'Central America', 'Central America', 14.634915, -90.506882, '+502', '#### ####', 'Guatemala City', '.gt', '🇬🇹', 'GTQ', 'Guatemalan Quetzal', 'Q'),
('Guinea', 'GN', 'GIN', 'Africa', 'Western Africa', 'West Africa', 9.641185, -13.578401, '+224', '## ### ###', 'Conakry', '.gn', '🇬🇳', 'GNF', 'Guinean Franc', 'FG'),
('Guinea-Bissau', 'GW', 'GNB', 'Africa', 'Western Africa', 'West Africa', 11.881655, -15.617794, '+245', '### ####', 'Bissau', '.gw', '🇬🇼', 'XOF', 'West African CFA Franc', 'CFA'),
('Guyana', 'GY', 'GUY', 'South America', 'South America', 'Northern South America', 6.801279, -58.155125, '+592', '### ####', 'Georgetown', '.gy', '🇬🇾', 'GYD', 'Guyanese Dollar', '$'),
('Haiti', 'HT', 'HTI', 'North America', 'Caribbean', 'Greater Antilles', 18.594395, -72.307433, '+509', '#### ####', 'Port-au-Prince', '.ht', '🇭🇹', 'HTG', 'Haitian Gourde', 'G'),
('Honduras', 'HN', 'HND', 'North America', 'Central America', 'Central America', 14.072275, -87.192136, '+504', '#### ####', 'Tegucigalpa', '.hn', '🇭🇳', 'HNL', 'Honduran Lempira', 'L'),
('Hungary', 'HU', 'HUN', 'Europe', 'Eastern Europe', 'Central Europe', 47.497912, 19.040235, '+36', '### ### ###', 'Budapest', '.hu', '🇭🇺', 'HUF', 'Hungarian Forint', 'Ft'),
('Iceland', 'IS', 'ISL', 'Europe', 'Northern Europe', 'Nordic Countries', 64.126521, -21.817439, '+354', '### ####', 'Reykjavik', '.is', '🇮🇸', 'ISK', 'Icelandic Króna', 'kr'),
('India', 'IN', 'IND', 'Asia', 'Southern Asia', 'South Asia', 28.613939, 77.209021, '+91', '### ### ####', 'New Delhi', '.in', '🇮🇳', 'INR', 'Indian Rupee', '₹'),
('Indonesia', 'ID', 'IDN', 'Asia', 'South-Eastern Asia', 'Maritime Southeast Asia', -6.208763, 106.845599, '+62', '### ### ###', 'Jakarta', '.id', '🇮🇩', 'IDR', 'Indonesian Rupiah', 'Rp'),
('Iran', 'IR', 'IRN', 'Asia', 'Southern Asia', 'Middle East', 35.689198, 51.388974, '+98', '### ### ####', 'Tehran', '.ir', '🇮🇷', 'IRR', 'Iranian Rial', '﷼'),
('Iraq', 'IQ', 'IRQ', 'Asia', 'Western Asia', 'Middle East', 33.312806, 44.361488, '+964', '### ### ####', 'Baghdad', '.iq', '🇮🇶', 'IQD', 'Iraqi Dinar', 'ع.د'),
('Ireland', 'IE', 'IRL', 'Europe', 'Northern Europe', 'British Isles', 53.349805, -6.260310, '+353', '### ### ###', 'Dublin', '.ie', '🇮🇪', 'EUR', 'Euro', '€'),
('Israel', 'IL', 'ISR', 'Asia', 'Western Asia', 'Middle East', 31.768319, 35.213710, '+972', '### ### ###', 'Jerusalem', '.il', '🇮🇱', 'ILS', 'Israeli New Shekel', '₪'),
('Italy', 'IT', 'ITA', 'Europe', 'Southern Europe', 'Mediterranean', 41.902784, 12.496366, '+39', '### ### ####', 'Rome', '.it', '🇮🇹', 'EUR', 'Euro', '€'),
('Jamaica', 'JM', 'JAM', 'North America', 'Caribbean', 'Greater Antilles', 18.042327, -76.802893, '+1876', '### ####', 'Kingston', '.jm', '🇯🇲', 'JMD', 'Jamaican Dollar', '$'),
('Japan', 'JP', 'JPN', 'Asia', 'Eastern Asia', 'East Asia', 35.689487, 139.691706, '+81', '### ### ####', 'Tokyo', '.jp', '🇯🇵', 'JPY', 'Japanese Yen', '¥'),
('Jordan', 'JO', 'JOR', 'Asia', 'Western Asia', 'Middle East', 31.956578, 35.945695, '+962', '# #### ####', 'Amman', '.jo', '🇯🇴', 'JOD', 'Jordanian Dinar', 'د.ا'),
('Kazakhstan', 'KZ', 'KAZ', 'Asia', 'Central Asia', 'Central Asia', 51.160523, 71.470356, '+7', '### ### ####', 'Nur-Sultan', '.kz', '🇰🇿', 'KZT', 'Kazakhstani Tenge', '₸'),
('Kenya', 'KE', 'KEN', 'Africa', 'Eastern Africa', 'East Africa', -1.292066, 36.821946, '+254', '### ### ###', 'Nairobi', '.ke', '🇰🇪', 'KES', 'Kenyan Shilling', 'KSh'),
('Kiribati', 'KI', 'KIR', 'Oceania', 'Micronesia', 'Pacific Islands', 1.451817, 172.971662, '+686', '#### ####', 'Tarawa', '.ki', '🇰🇮', 'AUD', 'Australian Dollar', '$'),
('Kuwait', 'KW', 'KWT', 'Asia', 'Western Asia', 'Middle East', 29.375859, 47.977405, '+965', '#### ####', 'Kuwait City', '.kw', '🇰🇼', 'KWD', 'Kuwaiti Dinar', 'د.ك'),
('Kyrgyzstan', 'KG', 'KGZ', 'Asia', 'Central Asia', 'Central Asia', 42.874621, 74.569762, '+996', '### ### ###', 'Bishkek', '.kg', '🇰🇬', 'KGS', 'Kyrgyzstani Som', 'с'),
('Laos', 'LA', 'LAO', 'Asia', 'South-Eastern Asia', 'Mainland Southeast Asia', 17.975706, 102.633104, '+856', '## ### ###', 'Vientiane', '.la', '🇱🇦', 'LAK', 'Lao Kip', '₭'),
('Latvia', 'LV', 'LVA', 'Europe', 'Northern Europe', 'Baltic States', 56.949649, 24.105186, '+371', '#### ####', 'Riga', '.lv', '🇱🇻', 'EUR', 'Euro', '€'),
('Lebanon', 'LB', 'LBN', 'Asia', 'Western Asia', 'Middle East', 33.888629, 35.495479, '+961', '## ### ###', 'Beirut', '.lb', '🇱🇧', 'LBP', 'Lebanese Pound', 'ل.ل'),
('Lesotho', 'LS', 'LSO', 'Africa', 'Southern Africa', 'Southern Africa', -29.363219, 27.514339, '+266', '#### ####', 'Maseru', '.ls', '🇱🇸', 'LSL', 'Lesotho Loti', 'L'),
('Liberia', 'LR', 'LBR', 'Africa', 'Western Africa', 'West Africa', 6.290743, -10.760524, '+231', '## ### ###', 'Monrovia', '.lr', '🇱🇷', 'LRD', 'Liberian Dollar', '$'),
('Libya', 'LY', 'LBY', 'Africa', 'Northern Africa', 'North Africa', 32.887209, 13.191338, '+218', '## ### ###', 'Tripoli', '.ly', '🇱🇾', 'LYD', 'Libyan Dinar', 'ل.د'),
('Liechtenstein', 'LI', 'LIE', 'Europe', 'Western Europe', 'Central Europe', 47.166000, 9.555373, '+423', '### ####', 'Vaduz', '.li', '🇱🇮', 'CHF', 'Swiss Franc', 'Fr'),
('Lithuania', 'LT', 'LTU', 'Europe', 'Northern Europe', 'Baltic States', 54.687156, 25.279651, '+370', '### ####', 'Vilnius', '.lt', '🇱🇹', 'EUR', 'Euro', '€'),
('Luxembourg', 'LU', 'LUX', 'Europe', 'Western Europe', 'Benelux', 49.611621, 6.131935, '+352', '### ###', 'Luxembourg City', '.lu', '🇱🇺', 'EUR', 'Euro', '€'),
('Madagascar', 'MG', 'MDG', 'Africa', 'Eastern Africa', 'East Africa', -18.879190, 47.507905, '+261', '## ## ### ##', 'Antananarivo', '.mg', '🇲🇬', 'MGA', 'Malagasy Ariary', 'Ar'),
('Malawi', 'MW', 'MWI', 'Africa', 'Eastern Africa', 'East Africa', -13.962612, 33.774119, '+265', '### ### ###', 'Lilongwe', '.mw', '🇲🇼', 'MWK', 'Malawian Kwacha', 'MK'),
('Malaysia', 'MY', 'MYS', 'Asia', 'South-Eastern Asia', 'Maritime Southeast Asia', 3.139003, 101.686855, '+60', '## ### ####', 'Kuala Lumpur', '.my', '🇲🇾', 'MYR', 'Malaysian Ringgit', 'RM'),
('Maldives', 'MV', 'MDV', 'Asia', 'Southern Asia', 'South Asia', 4.175496, 73.509347, '+960', '### ####', 'Male', '.mv', '🇲🇻', 'MVR', 'Maldivian Rufiyaa', '.ރ'),
('Mali', 'ML', 'MLI', 'Africa', 'Western Africa', 'West Africa', 12.639232, -8.002889, '+223', '## ## ## ##', 'Bamako', '.ml', '🇲🇱', 'XOF', 'West African CFA Franc', 'CFA'),
('Malta', 'MT', 'MLT', 'Europe', 'Southern Europe', 'Mediterranean', 35.898909, 14.514553, '+356', '#### ####', 'Valletta', '.mt', '🇲🇹', 'EUR', 'Euro', '€'),
('Marshall Islands', 'MH', 'MHL', 'Oceania', 'Micronesia', 'Pacific Islands', 7.116421, 171.185013, '+692', '### ####', 'Majuro', '.mh', '🇲🇭', 'USD', 'United States Dollar', '$'),
('Mauritania', 'MR', 'MRT', 'Africa', 'Western Africa', 'West Africa', 18.073666, -15.958670, '+222', '## ## ## ##', 'Nouakchott', '.mr', '🇲🇷', 'MRU', 'Mauritanian Ouguiya', 'UM'),
('Mauritius', 'MU', 'MUS', 'Africa', 'Eastern Africa', 'East Africa', -20.166896, 57.502332, '+230', '#### ####', 'Port Louis', '.mu', '🇲🇺', 'MUR', 'Mauritian Rupee', '₨'),
('Mexico', 'MX', 'MEX', 'North America', 'Central America', 'North America', 19.432608, -99.133208, '+52', '## #### ####', 'Mexico City', '.mx', '🇲🇽', 'MXN', 'Mexican Peso', '$'),
('Micronesia', 'FM', 'FSM', 'Oceania', 'Micronesia', 'Pacific Islands', 6.914712, 158.161027, '+691', '### ####', 'Palikir', '.fm', '🇫🇲', 'USD', 'United States Dollar', '$'),
('Moldova', 'MD', 'MDA', 'Europe', 'Eastern Europe', 'Eastern Europe', 47.010453, 28.863337, '+373', '### ### ###', 'Chisinau', '.md', '🇲🇩', 'MDL', 'Moldovan Leu', 'L'),
('Monaco', 'MC', 'MCO', 'Europe', 'Western Europe', 'Western Europe', 43.738418, 7.424616, '+377', '## ## ## ##', 'Monaco', '.mc', '🇲🇨', 'EUR', 'Euro', '€'),
('Mongolia', 'MN', 'MNG', 'Asia', 'Eastern Asia', 'East Asia', 47.886399, 106.905744, '+976', '## ## ####', 'Ulaanbaatar', '.mn', '🇲🇳', 'MNT', 'Mongolian Tögrög', '₮'),
('Montenegro', 'ME', 'MNE', 'Europe', 'Southern Europe', 'Balkans', 42.430420, 19.259364, '+382', '## ### ###', 'Podgorica', '.me', '🇲🇪', 'EUR', 'Euro', '€'),
('Morocco', 'MA', 'MAR', 'Africa', 'Northern Africa', 'Maghreb', 34.015289, -6.831650, '+212', '### ### ###', 'Rabat', '.ma', '🇲🇦', 'MAD', 'Moroccan Dirham', 'د.م.'),
('Mozambique', 'MZ', 'MOZ', 'Africa', 'Eastern Africa', 'East Africa', -25.891968, 32.605135, '+258', '## ### ###', 'Maputo', '.mz', '🇲🇿', 'MZN', 'Mozambican Metical', 'MT'),
('Myanmar', 'MM', 'MMR', 'Asia', 'South-Eastern Asia', 'Mainland Southeast Asia', 16.866069, 96.195132, '+95', '## ### ###', 'Naypyidaw', '.mm', '🇲🇲', 'MMK', 'Myanmar Kyat', 'Ks'),
('Namibia', 'NA', 'NAM', 'Africa', 'Southern Africa', 'Southern Africa', -22.560881, 17.065755, '+264', '## ### ####', 'Windhoek', '.na', '🇳🇦', 'NAD', 'Namibian Dollar', '$'),
('Nauru', 'NR', 'NRU', 'Oceania', 'Micronesia', 'Pacific Islands', -0.522778, 166.931503, '+674', '### ####', 'Yaren', '.nr', '🇳🇷', 'AUD', 'Australian Dollar', '$'),
('Nepal', 'NP', 'NPL', 'Asia', 'Southern Asia', 'South Asia', 27.717245, 85.323960, '+977', '## #### ###', 'Kathmandu', '.np', '🇳🇵', 'NPR', 'Nepalese Rupee', '₨'),
('Netherlands', 'NL', 'NLD', 'Europe', 'Western Europe', 'Benelux', 52.370216, 4.895168, '+31', '## ### ####', 'Amsterdam', '.nl', '🇳🇱', 'EUR', 'Euro', '€'),
('New Zealand', 'NZ', 'NZL', 'Oceania', 'Australasia', 'Australia and New Zealand', -41.286461, 174.776230, '+64', '### ### ###', 'Wellington', '.nz', '🇳🇿', 'NZD', 'New Zealand Dollar', '$'),
('Nicaragua', 'NI', 'NIC', 'North America', 'Central America', 'Central America', 12.114993, -86.236174, '+505', '#### ####', 'Managua', '.ni', '🇳🇮', 'NIO', 'Nicaraguan Córdoba', 'C$'),
('Niger', 'NE', 'NER', 'Africa', 'Western Africa', 'West Africa', 13.511596, 2.125385, '+227', '## ## ## ##', 'Niamey', '.ne', '🇳🇪', 'XOF', 'West African CFA Franc', 'CFA'),
('Nigeria', 'NG', 'NGA', 'Africa', 'Western Africa', 'West Africa', 9.076479, 7.398574, '+234', '### ### ####', 'Abuja', '.ng', '🇳🇬', 'NGN', 'Nigerian Naira', '₦'),
('North Korea', 'KP', 'PRK', 'Asia', 'Eastern Asia', 'East Asia', 39.039219, 125.762524, '+850', '### ###', 'Pyongyang', '.kp', '🇰🇵', 'KPW', 'North Korean Won', '₩'),
('North Macedonia', 'MK', 'MKD', 'Europe', 'Southern Europe', 'Balkans', 41.997346, 21.427996, '+389', '## ### ###', 'Skopje', '.mk', '🇲🇰', 'MKD', 'Macedonian Denar', 'ден'),
('Norway', 'NO', 'NOR', 'Europe', 'Northern Europe', 'Nordic Countries', 59.913869, 10.752245, '+47', '### ## ###', 'Oslo', '.no', '🇳🇴', 'NOK', 'Norwegian Krone', 'kr'),
('Oman', 'OM', 'OMN', 'Asia', 'Western Asia', 'Middle East', 23.585890, 58.405923, '+968', '#### ####', 'Muscat', '.om', '🇴🇲', 'OMR', 'Omani Rial', 'ر.ع.'),
('Pakistan', 'PK', 'PAK', 'Asia', 'Southern Asia', 'South Asia', 33.729388, 73.093146, '+92', '### ### ####', 'Islamabad', '.pk', '🇵🇰', 'PKR', 'Pakistani Rupee', '₨'),
('Palau', 'PW', 'PLW', 'Oceania', 'Micronesia', 'Pacific Islands', 7.500384, 134.624289, '+680', '### ####', 'Ngerulmud', '.pw', '🇵🇼', 'USD', 'United States Dollar', '$'),
('Palestine', 'PS', 'PSE', 'Asia', 'Western Asia', 'Middle East', 31.768319, 35.213710, '+970', '### ### ###', 'East Jerusalem', '.ps', '🇵🇸', 'ILS', 'Israeli New Shekel', '₪'),
('Panama', 'PA', 'PAN', 'North America', 'Central America', 'Central America', 8.983333, -79.516670, '+507', '#### ####', 'Panama City', '.pa', '🇵🇦', 'PAB', 'Panamanian Balboa', 'B/.'),
('Papua New Guinea', 'PG', 'PNG', 'Oceania', 'Melanesia', 'Pacific Islands', -9.443383, 147.180267, '+675', '### ####', 'Port Moresby', '.pg', '🇵🇬', 'PGK', 'Papua New Guinean Kina', 'K'),
('Paraguay', 'PY', 'PRY', 'South America', 'South America', 'Central South America', -25.286840, -57.333591, '+595', '### ### ###', 'Asunción', '.py', '🇵🇾', 'PYG', 'Paraguayan Guaraní', '₲'),
('Peru', 'PE', 'PER', 'South America', 'South America', 'Western South America', -12.046374, -77.042793, '+51', '### ### ###', 'Lima', '.pe', '🇵🇪', 'PEN', 'Peruvian Sol', 'S/.'),
('Philippines', 'PH', 'PHL', 'Asia', 'South-Eastern Asia', 'Maritime Southeast Asia', 14.599512, 120.984219, '+63', '### ### ####', 'Manila', '.ph', '🇵🇭', 'PHP', 'Philippine Peso', '₱'),
('Poland', 'PL', 'POL', 'Europe', 'Eastern Europe', 'Central Europe', 52.229676, 21.012229, '+48', '### ### ###', 'Warsaw', '.pl', '🇵🇱', 'PLN', 'Polish Złoty', 'zł'),
('Portugal', 'PT', 'PRT', 'Europe', 'Southern Europe', 'Mediterranean', 38.722252, -9.139337, '+351', '### ### ###', 'Lisbon', '.pt', '🇵🇹', 'EUR', 'Euro', '€'),
('Qatar', 'QA', 'QAT', 'Asia', 'Western Asia', 'Middle East', 25.285447, 51.531040, '+974', '#### ####', 'Doha', '.qa', '🇶🇦', 'QAR', 'Qatari Riyal', 'ر.ق'),
('Romania', 'RO', 'ROU', 'Europe', 'Eastern Europe', 'Eastern Europe', 44.426767, 26.102538, '+40', '### ### ###', 'Bucharest', '.ro', '🇷🇴', 'RON', 'Romanian Leu', 'lei'),
('Russia', 'RU', 'RUS', 'Europe', 'Eastern Europe', 'Eastern Europe', 55.755826, 37.617300, '+7', '### ### ####', 'Moscow', '.ru', '🇷🇺', 'RUB', 'Russian Ruble', '₽'),
('Rwanda', 'RW', 'RWA', 'Africa', 'Eastern Africa', 'East Africa', -1.957875, 30.112735, '+250', '### ### ###', 'Kigali', '.rw', '🇷🇼', 'RWF', 'Rwandan Franc', 'FRw'),
('Saint Kitts and Nevis', 'KN', 'KNA', 'North America', 'Caribbean', 'Lesser Antilles', 17.302606, -62.717692, '+1869', '### ####', 'Basseterre', '.kn', '🇰🇳', 'XCD', 'East Caribbean Dollar', '$'),
('Saint Lucia', 'LC', 'LCA', 'North America', 'Caribbean', 'Lesser Antilles', 14.010109, -60.987469, '+1758', '### ####', 'Castries', '.lc', '🇱🇨', 'XCD', 'East Caribbean Dollar', '$'),
('Saint Vincent', 'VC', 'VCT', 'North America', 'Caribbean', 'Lesser Antilles', 13.157778, -61.224915, '+1784', '### ####', 'Kingstown', '.vc', '🇻🇨', 'XCD', 'East Caribbean Dollar', '$'),
('Samoa', 'WS', 'WSM', 'Oceania', 'Polynesia', 'Pacific Islands', -13.850696, -171.751355, '+685', '#### ####', 'Apia', '.ws', '🇼🇸', 'WST', 'Samoan Tālā', 'T'),
('San Marino', 'SM', 'SMR', 'Europe', 'Southern Europe', 'Mediterranean', 43.935591, 12.447281, '+378', '#### ######', 'San Marino', '.sm', '🇸🇲', 'EUR', 'Euro', '€'),
('Sao Tome and Principe', 'ST', 'STP', 'Africa', 'Middle Africa', 'Central Africa', 0.330192, 6.733343, '+239', '## #####', 'São Tomé', '.st', '🇸🇹', 'STN', 'São Tomé and Príncipe Dobra', 'Db'),
('Saudi Arabia', 'SA', 'SAU', 'Asia', 'Western Asia', 'Middle East', 24.713552, 46.675296, '+966', '## ### ####', 'Riyadh', '.sa', '🇸🇦', 'SAR', 'Saudi Riyal', 'ر.س'),
('Senegal', 'SN', 'SEN', 'Africa', 'Western Africa', 'West Africa', 14.764504, -17.366029, '+221', '## ### ## ##', 'Dakar', '.sn', '🇸🇳', 'XOF', 'West African CFA Franc', 'CFA'),
('Serbia', 'RS', 'SRB', 'Europe', 'Southern Europe', 'Balkans', 44.786568, 20.448922, '+381', '## ### ####', 'Belgrade', '.rs', '🇷🇸', 'RSD', 'Serbian Dinar', 'дин.'),
('Seychelles', 'SC', 'SYC', 'Africa', 'Eastern Africa', 'East Africa', -4.619143, 55.451315, '+248', '# ### ###', 'Victoria', '.sc', '🇸🇨', 'SCR', 'Seychellois Rupee', '₨'),
('Sierra Leone', 'SL', 'SLE', 'Africa', 'Western Africa', 'West Africa', 8.465677, -13.231722, '+232', '## ### ###', 'Freetown', '.sl', '🇸🇱', 'SLL', 'Sierra Leonean Leone', 'Le'),
('Singapore', 'SG', 'SGP', 'Asia', 'South-Eastern Asia', 'Maritime Southeast Asia', 1.352083, 103.819836, '+65', '#### ####', 'Singapore', '.sg', '🇸🇬', 'SGD', 'Singapore Dollar', '$'),
('Slovakia', 'SK', 'SVK', 'Europe', 'Eastern Europe', 'Central Europe', 48.148596, 17.107748, '+421', '### ### ###', 'Bratislava', '.sk', '🇸🇰', 'EUR', 'Euro', '€'),
('Slovenia', 'SI', 'SVN', 'Europe', 'Southern Europe', 'Central Europe', 46.056947, 14.505751, '+386', '## ### ###', 'Ljubljana', '.si', '🇸🇮', 'EUR', 'Euro', '€'),
('Solomon Islands', 'SB', 'SLB', 'Oceania', 'Melanesia', 'Pacific Islands', -9.445638, 159.972824, '+677', '### ####', 'Honiara', '.sb', '🇸🇧', 'SBD', 'Solomon Islands Dollar', '$'),
('Somalia', 'SO', 'SOM', 'Africa', 'Eastern Africa', 'Horn of Africa', 2.046934, 45.318162, '+252', '## ### ###', 'Mogadishu', '.so', '🇸🇴', 'SOS', 'Somali Shilling', 'Sh'),
('South Africa', 'ZA', 'ZAF', 'Africa', 'Southern Africa', 'Southern Africa', -25.747868, 28.229271, '+27', '## ### ####', 'Pretoria', '.za', '🇿🇦', 'ZAR', 'South African Rand', 'R'),
('South Korea', 'KR', 'KOR', 'Asia', 'Eastern Asia', 'East Asia', 37.566535, 126.977969, '+82', '## #### ####', 'Seoul', '.kr', '🇰🇷', 'KRW', 'South Korean Won', '₩'),
('South Sudan', 'SS', 'SSD', 'Africa', 'Eastern Africa', 'East Africa', 4.859363, 31.571251, '+211', '## ### ####', 'Juba', '.ss', '🇸🇸', 'SSP', 'South Sudanese Pound', '£'),
('Spain', 'ES', 'ESP', 'Europe', 'Southern Europe', 'Mediterranean', 40.416775, -3.703790, '+34', '### ### ###', 'Madrid', '.es', '🇪🇸', 'EUR', 'Euro', '€'),
('Sri Lanka', 'LK', 'LKA', 'Asia', 'Southern Asia', 'South Asia', 6.927079, 79.861244, '+94', '## ### ####', 'Colombo', '.lk', '🇱🇰', 'LKR', 'Sri Lankan Rupee', 'Rs'),
('Sudan', 'SD', 'SDN', 'Africa', 'Northern Africa', 'North Africa', 15.500654, 32.559899, '+249', '## ### ####', 'Khartoum', '.sd', '🇸🇩', 'SDG', 'Sudanese Pound', 'ج.س.'),
('Suriname', 'SR', 'SUR', 'South America', 'South America', 'Northern South America', 5.852036, -55.203828, '+597', '### ###', 'Paramaribo', '.sr', '🇸🇷', 'SRD', 'Surinamese Dollar', '$'),
('Sweden', 'SE', 'SWE', 'Europe', 'Northern Europe', 'Nordic Countries', 59.329323, 18.068581, '+46', '## ### ####', 'Stockholm', '.se', '🇸🇪', 'SEK', 'Swedish Krona', 'kr'),
('Switzerland', 'CH', 'CHE', 'Europe', 'Western Europe', 'Central Europe', 46.947456, 7.447285, '+41', '## ### ####', 'Bern', '.ch', '🇨🇭', 'CHF', 'Swiss Franc', 'Fr.'),
('Syria', 'SY', 'SYR', 'Asia', 'Western Asia', 'Middle East', 33.513807, 36.276528, '+963', '## ### ####', 'Damascus', '.sy', '🇸🇾', 'SYP', 'Syrian Pound', '£S'),
('Taiwan', 'TW', 'TWN', 'Asia', 'Eastern Asia', 'East Asia', 25.032969, 121.565418, '+886', '### ### ###', 'Taipei', '.tw', '🇹🇼', 'TWD', 'New Taiwan Dollar', 'NT$'),
('Tajikistan', 'TJ', 'TJK', 'Asia', 'Central Asia', 'Central Asia', 38.559772, 68.787038, '+992', '### ## ####', 'Dushanbe', '.tj', '🇹🇯', 'TJS', 'Tajikistani Somoni', 'ЅМ'),
('Tanzania', 'TZ', 'TZA', 'Africa', 'Eastern Africa', 'East Africa', -6.792354, 39.208328, '+255', '### ### ###', 'Dodoma', '.tz', '🇹🇿', 'TZS', 'Tanzanian Shilling', 'TSh'),
('Thailand', 'TH', 'THA', 'Asia', 'South-Eastern Asia', 'Mainland Southeast Asia', 13.756331, 100.501765, '+66', '## ### ####', 'Bangkok', '.th', '🇹🇭', 'THB', 'Thai Baht', '฿'),
('Timor-Leste', 'TL', 'TLS', 'Asia', 'South-Eastern Asia', 'Maritime Southeast Asia', -8.556856, 125.560314, '+670', '### ####', 'Dili', '.tl', '🇹🇱', 'USD', 'United States Dollar', '$'),
('Togo', 'TG', 'TGO', 'Africa', 'Western Africa', 'West Africa', 6.137219, 1.222186, '+228', '## ### ###', 'Lomé', '.tg', '🇹🇬', 'XOF', 'West African CFA Franc', 'CFA'),
('Tonga', 'TO', 'TON', 'Oceania', 'Polynesia', 'Pacific Islands', -21.139342, -175.204947, '+676', '### ####', 'Nukuʻalofa', '.to', '🇹🇴', 'TOP', 'Tongan Paʻanga', 'T$'),
('Trinidad and Tobago', 'TT', 'TTO', 'North America', 'Caribbean', 'Lesser Antilles', 10.654901, -61.501926, '+1868', '### ####', 'Port of Spain', '.tt', '🇹🇹', 'TTD', 'Trinidad and Tobago Dollar', '$'),
('Tunisia', 'TN', 'TUN', 'Africa', 'Northern Africa', 'Maghreb', 36.806495, 10.181532, '+216', '## ### ###', 'Tunis', '.tn', '🇹🇳', 'TND', 'Tunisian Dinar', 'د.ت'),
('Turkey', 'TR', 'TUR', 'Asia', 'Western Asia', 'Middle East', 39.933364, 32.859742, '+90', '### ### ####', 'Ankara', '.tr', '🇹🇷', 'TRY', 'Turkish Lira', '₺'),
('Turkmenistan', 'TM', 'TKM', 'Asia', 'Central Asia', 'Central Asia', 37.960077, 58.326063, '+993', '## ######', 'Ashgabat', '.tm', '🇹🇲', 'TMT', 'Turkmenistan Manat', 'm'),
('Tuvalu', 'TV', 'TUV', 'Oceania', 'Polynesia', 'Pacific Islands', -8.520066, 179.198128, '+688', '### ####', 'Funafuti', '.tv', '🇹🇻', 'AUD', 'Australian Dollar', '$'),
('Uganda', 'UG', 'UGA', 'Africa', 'Eastern Africa', 'East Africa', 0.347596, 32.582520, '+256', '### ### ###', 'Kampala', '.ug', '🇺🇬', 'UGX', 'Ugandan Shilling', 'USh'),
('Ukraine', 'UA', 'UKR', 'Europe', 'Eastern Europe', 'Eastern Europe', 50.450100, 30.523400, '+380', '## ### ####', 'Kyiv', '.ua', '🇺🇦', 'UAH', 'Ukrainian Hryvnia', '₴'),
('United Arab Emirates', 'AE', 'ARE', 'Asia', 'Western Asia', 'Middle East', 24.299174, 54.697277, '+971', '## ### ####', 'Abu Dhabi', '.ae', '🇦🇪', 'AED', 'UAE Dirham', 'د.إ'),
('United Kingdom', 'GB', 'GBR', 'Europe', 'Northern Europe', 'British Isles', 51.507351, -0.127758, '+44', '### ### ####', 'London', '.uk', '🇬🇧', 'GBP', 'British Pound', '£'),
('United States', 'US', 'USA', 'North America', 'Northern America', 'North America', 38.907192, -77.036871, '+1', '### ### ####', 'Washington, D.C.', '.us', '🇺🇸', 'USD', 'United States Dollar', '$'),
('Uruguay', 'UY', 'URY', 'South America', 'South America', 'Southern Cone', -34.901113, -56.164531, '+598', '# ### ####', 'Montevideo', '.uy', '🇺🇾', 'UYU', 'Uruguayan Peso', '$U'),
('Uzbekistan', 'UZ', 'UZB', 'Asia', 'Central Asia', 'Central Asia', 41.299496, 69.240073, '+998', '## ### ####', 'Tashkent', '.uz', '🇺🇿', 'UZS', 'Uzbekistani Som', 'so''m'),
('Vanuatu', 'VU', 'VUT', 'Oceania', 'Melanesia', 'Pacific Islands', -17.733251, 168.327325, '+678', '### ####', 'Port Vila', '.vu', '🇻🇺', 'VUV', 'Vanuatu Vatu', 'VT'),
('Vatican City', 'VA', 'VAT', 'Europe', 'Southern Europe', 'Mediterranean', 41.902916, 12.453389, '+379', '## ### ####', 'Vatican City', '.va', '🇻🇦', 'EUR', 'Euro', '€'),
('Venezuela', 'VE', 'VEN', 'South America', 'South America', 'Northern South America', 10.480594, -66.903606, '+58', '### ### ####', 'Caracas', '.ve', '🇻🇪', 'VES', 'Venezuelan Bolívar Soberano', 'Bs.'),
('Vietnam', 'VN', 'VNM', 'Asia', 'South-Eastern Asia', 'Mainland Southeast Asia', 21.027764, 105.834160, '+84', '### ### ###', 'Hanoi', '.vn', '🇻🇳', 'VND', 'Vietnamese Đồng', '₫'),
('Yemen', 'YE', 'YEM', 'Asia', 'Western Asia', 'Middle East', 15.369445, 44.191007, '+967', '### ### ###', 'Sanaa', '.ye', '🇾🇪', 'YER', 'Yemeni Rial', '﷼'),
('Zambia', 'ZM', 'ZMB', 'Africa', 'Eastern Africa', 'East Africa', -15.387526, 28.322817, '+260', '## ### ####', 'Lusaka', '.zm', '🇿🇲', 'ZMW', 'Zambian Kwacha', 'ZK'),
('Zimbabwe', 'ZW', 'ZWE', 'Africa', 'Eastern Africa', 'East Africa', -17.825166, 31.033510, '+263', '## ### ####', 'Harare', '.zw', '🇿🇼', 'USD', 'United States Dollar', '$'),
('Kosovo', 'XK', 'XKX', 'Europe', 'Southern Europe', 'Balkans', 42.662914, 21.165503, '+383', '## ### ###', 'Pristina', '.xk', '🇽🇰', 'EUR', 'Euro', '€'),
('Transnistria', 'TS', 'TRA', 'Europe', 'Eastern Europe', 'Eastern Europe', 46.848185, 29.596805, '+373', '### ### ###', 'Tiraspol', '.md', '🇲🇩', 'PRB', 'Transnistrian Ruble', 'р.'),
('Somaliland', 'XS', 'SOL', 'Africa', 'Eastern Africa', 'Horn of Africa', 9.562389, 44.077011, '+252', '## ### ###', 'Hargeisa', '.so', '🇸🇴', 'SLSH', 'Somaliland Shilling', 'Sl'),
('South Ossetia', 'OS', 'OST', 'Asia', 'Western Asia', 'Caucasus', 42.226540, 43.968994, '+995', '### ### ###', 'Tskhinvali', '.ge', '🇬🇪', 'RUB', 'Russian Ruble', '₽'),
('Abkhazia', 'AB', 'ABK', 'Asia', 'Western Asia', 'Caucasus', 43.002708, 41.023010, '+995', '### ### ###', 'Sukhumi', '.ge', '🇬🇪', 'RUB', 'Russian Ruble', '₽'),
('Northern Cyprus', 'CT', 'NCY', 'Asia', 'Western Asia', 'Mediterranean', 35.185566, 33.382275, '+90', '### ### ####', 'North Nicosia', '.tr', '🇹🇷', 'TRY', 'Turkish Lira', '₺'),
('Nagorno-Karabakh', 'NK', 'NKR', 'Asia', 'Western Asia', 'Caucasus', 39.826385, 46.763595, '+374', '## ### ###', 'Stepanakert', '.am', '🇦🇲', 'AMD', 'Armenian Dram', '֏'),
('American Samoa', 'AS', 'ASM', 'Oceania', 'Polynesia', 'Pacific Islands', -14.275632, -170.702036, '+1684', '### ####', 'Pago Pago', '.as', '🇦🇸', 'USD', 'United States Dollar', '$'),
('Anguilla', 'AI', 'AIA', 'North America', 'Caribbean', 'Lesser Antilles', 18.220554, -63.068615, '+1264', '### ####', 'The Valley', '.ai', '🇦🇮', 'XCD', 'East Caribbean Dollar', '$'),
('Aruba', 'AW', 'ABW', 'North America', 'Caribbean', 'Lesser Antilles', 12.521110, -70.036209, '+297', '### ####', 'Oranjestad', '.aw', '🇦🇼', 'AWG', 'Aruban Florin', 'ƒ'),
('Bermuda', 'BM', 'BMU', 'North America', 'Caribbean', 'British Overseas Territory', 32.321384, -64.757370, '+1441', '### ####', 'Hamilton', '.bm', '🇧🇲', 'BMD', 'Bermudian Dollar', '$'),
('Bouvet Island', 'BV', 'BVT', 'Antarctica', 'Subantarctic', 'Southern Ocean', -54.423199, 3.413194, '+47', '', 'No permanent population', '.bv', '🇧🇻', 'NOK', 'Norwegian Krone', 'kr'),
('British Indian Ocean Territory', 'IO', 'IOT', 'Asia', 'Southern Asia', 'British Overseas Territory', -7.313267, 72.424154, '+246', '### ####', 'Diego Garcia', '.io', '🇮🇴', 'USD', 'United States Dollar', '$'),
('British Virgin Islands', 'VG', 'VGB', 'North America', 'Caribbean', 'Lesser Antilles', 18.426929, -64.620789, '+1284', '### ####', 'Road Town', '.vg', '🇻🇬', 'USD', 'United States Dollar', '$'),
('Cayman Islands', 'KY', 'CYM', 'North America', 'Caribbean', 'Greater Antilles', 19.286932, -81.367439, '+1345', '### ####', 'George Town', '.ky', '🇰🇾', 'KYD', 'Cayman Islands Dollar', '$'),
('Christmas Island', 'CX', 'CXR', 'Asia', 'South-Eastern Asia', 'Australian Territory', -10.447525, 105.690449, '+61', '#### ####', 'Flying Fish Cove', '.cx', '🇨🇽', 'AUD', 'Australian Dollar', '$'),
('Cocos Islands', 'CC', 'CCK', 'Asia', 'South-Eastern Asia', 'Australian Territory', -12.164165, 96.870956, '+61', '#### ####', 'West Island', '.cc', '🇨🇨', 'AUD', 'Australian Dollar', '$'),
('Cook Islands', 'CK', 'COK', 'Oceania', 'Polynesia', 'Pacific Islands', -21.236736, -159.777671, '+682', '## ###', 'Avarua', '.ck', '🇨🇰', 'NZD', 'New Zealand Dollar', '$'),
('Curacao', 'CW', 'CUW', 'North America', 'Caribbean', 'Lesser Antilles', 12.169570, -68.990021, '+599', '### ####', 'Willemstad', '.cw', '🇨🇼', 'ANG', 'Netherlands Antillean Guilder', 'ƒ'),
('Falkland Islands', 'FK', 'FLK', 'South America', 'South America', 'British Overseas Territory', -51.796253, -58.464050, '+500', '## ###', 'Stanley', '.fk', '🇫🇰', 'FKP', 'Falkland Islands Pound', '£'),
('Faroe Islands', 'FO', 'FRO', 'Europe', 'Northern Europe', 'Danish Territory', 62.007864, -6.790982, '+298', '### ###', 'Tórshavn', '.fo', '🇫🇴', 'DKK', 'Danish Krone', 'kr'),
('French Guiana', 'GF', 'GUF', 'South America', 'South America', 'French Territory', 4.922482, -52.313453, '+594', '### ## ## ##', 'Cayenne', '.gf', '🇬🇫', 'EUR', 'Euro', '€'),
('French Polynesia', 'PF', 'PYF', 'Oceania', 'Polynesia', 'French Territory', -17.679742, -149.406843, '+689', '## ## ##', 'Papeete', '.pf', '🇵🇫', 'XPF', 'CFP Franc', '₣'),
('French Southern Territories', 'TF', 'ATF', 'Antarctica', 'Subantarctic', 'French Territory', -49.280366, 69.348557, '+262', '', 'Port-aux-Français', '.tf', '🇹🇫', 'EUR', 'Euro', '€'),
('Gibraltar', 'GI', 'GIB', 'Europe', 'Southern Europe', 'British Overseas Territory', 36.140773, -5.353599, '+350', '### #####', 'Gibraltar', '.gi', '🇬🇮', 'GIP', 'Gibraltar Pound', '£'),
('Greenland', 'GL', 'GRL', 'North America', 'Northern America', 'Danish Territory', 64.182313, -51.694138, '+299', '### ###', 'Nuuk', '.gl', '🇬🇱', 'DKK', 'Danish Krone', 'kr'),
('Guadeloupe', 'GP', 'GLP', 'North America', 'Caribbean', 'French Territory', 16.265000, -61.551000, '+590', '### ## ## ##', 'Basse-Terre', '.gp', '🇬🇵', 'EUR', 'Euro', '€'),
('Guam', 'GU', 'GUM', 'Oceania', 'Micronesia', 'US Territory', 13.444304, 144.793731, '+1671', '### ####', 'Hagåtña', '.gu', '🇬🇺', 'USD', 'United States Dollar', '$'),
('Hong Kong', 'HK', 'HKG', 'Asia', 'Eastern Asia', 'Chinese SAR', 22.396428, 114.109497, '+852', '#### ####', 'Hong Kong', '.hk', '🇭🇰', 'HKD', 'Hong Kong Dollar', 'HK$'),
('Macao', 'MO', 'MAC', 'Asia', 'Eastern Asia', 'Chinese SAR', 22.198745, 113.543873, '+853', '#### ####', 'Macau', '.mo', '🇲🇴', 'MOP', 'Macanese Pataca', 'MOP$'),
('Martinique', 'MQ', 'MTQ', 'North America', 'Caribbean', 'French Territory', 14.641528, -61.024174, '+596', '### ## ## ##', 'Fort-de-France', '.mq', '🇲🇶', 'EUR', 'Euro', '€'),
('Mayotte', 'YT', 'MYT', 'Africa', 'Eastern Africa', 'French Territory', -12.780949, 45.227872, '+262', '### ## ## ##', 'Mamoudzou', '.yt', '🇾🇹', 'EUR', 'Euro', '€'),
('Montserrat', 'MS', 'MSR', 'North America', 'Caribbean', 'British Overseas Territory', 16.742498, -62.187366, '+1664', '### ####', 'Plymouth', '.ms', '🇲🇸', 'XCD', 'East Caribbean Dollar', '$'),
('New Caledonia', 'NC', 'NCL', 'Oceania', 'Melanesia', 'French Territory', -22.276095, 166.458207, '+687', '## ## ##', 'Nouméa', '.nc', '🇳🇨', 'XPF', 'CFP Franc', '₣'),
('Niue', 'NU', 'NIU', 'Oceania', 'Polynesia', 'New Zealand Territory', -19.054445, -169.867233, '+683', '####', 'Alofi', '.nu', '🇳🇺', 'NZD', 'New Zealand Dollar', '$'),
('Norfolk Island', 'NF', 'NFK', 'Oceania', 'Australia', 'Australian Territory', -29.040835, 167.954712, '+672', '### ###', 'Kingston', '.nf', '🇳🇫', 'AUD', 'Australian Dollar', '$'),
('Northern Mariana Islands', 'MP', 'MNP', 'Oceania', 'Micronesia', 'US Territory', 15.211900, 145.750967, '+1670', '### ####', 'Saipan', '.mp', '🇲🇵', 'USD', 'United States Dollar', '$'),
('Pitcairn', 'PN', 'PCN', 'Oceania', 'Polynesia', 'British Overseas Territory', -25.066667, -130.100000, '+64', '', 'Adamstown', '.pn', '🇵🇳', 'NZD', 'New Zealand Dollar', '$'),
('Puerto Rico', 'PR', 'PRI', 'North America', 'Caribbean', 'US Territory', 18.200178, -66.664513, '+1787', '### ### ####', 'San Juan', '.pr', '🇵🇷', 'USD', 'United States Dollar', '$'),
('Reunion', 'RE', 'REU', 'Africa', 'Eastern Africa', 'French Territory', -21.115141, 55.536384, '+262', '### ## ## ##', 'Saint-Denis', '.re', '🇷🇪', 'EUR', 'Euro', '€'),
('Saint Barthelemy', 'BL', 'BLM', 'North America', 'Caribbean', 'French Territory', 17.896179, -62.849781, '+590', '### ## ## ##', 'Gustavia', '.bl', '🇧🇱', 'EUR', 'Euro', '€'),
('Saint Helena', 'SH', 'SHN', 'Africa', 'Western Africa', 'British Overseas Territory', -15.965000, -5.708890, '+290', '####', 'Jamestown', '.sh', '🇸🇭', 'SHP', 'Saint Helena Pound', '£'),
('Saint Martin', 'MF', 'MAF', 'North America', 'Caribbean', 'French Territory', 18.069430, -63.078220, '+590', '### ## ## ##', 'Marigot', '.mf', '🇲🇫', 'EUR', 'Euro', '€'),
('Saint Pierre and Miquelon', 'PM', 'SPM', 'North America', 'Northern America', 'French Territory', 46.941936, -56.267242, '+508', '## ## ##', 'Saint-Pierre', '.pm', '🇵🇲', 'EUR', 'Euro', '€'),
('Sint Maarten', 'SX', 'SXM', 'North America', 'Caribbean', 'Dutch Territory', 18.042350, -63.054840, '+1721', '### ####', 'Philipsburg', '.sx', '🇸🇽', 'ANG', 'Netherlands Antillean Guilder', 'ƒ'),
('Tokelau', 'TK', 'TKL', 'Oceania', 'Polynesia', 'New Zealand Territory', -9.200000, -171.850000, '+690', '####', 'Fakaofo', '.tk', '🇹🇰', 'NZD', 'New Zealand Dollar', '$'),
('U.S. Virgin Islands', 'VI', 'VIR', 'North America', 'Caribbean', 'US Territory', 18.335765, -64.896335, '+1340', '### ####', 'Charlotte Amalie', '.vi', '🇻🇮', 'USD', 'United States Dollar', '$');