/
countries.sql
262 lines (261 loc) · 50.2 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
/****** Object: Table [dbo].[Country] Script Date: 4/16/2014 9:14:37 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Country](
[CountryID] [int] NOT NULL,
[CountryName] [nvarchar](255) NOT NULL,
[CountryCode] [nvarchar](255) NOT NULL,
CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED
(
[CountryCode] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF)
)
GO
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (6, N'Andorra', N'AD')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (228, N'United Arab Emirates', N'AE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (1, N'Afghanistan', N'AF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (10, N'Antigua And Barbuda', N'AG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (8, N'Anguilla', N'AI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (3, N'Albania', N'AL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (12, N'Armenia', N'AM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (155, N'Netherlands Antilles', N'AN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (7, N'Angola', N'AO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (9, N'Antarctica', N'AQ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (11, N'Argentina', N'AR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (5, N'American Samoa', N'AS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (15, N'Austria', N'AT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (14, N'Australia', N'AU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (13, N'Aruba', N'AW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (2, N'Aland Islands', N'AX')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (16, N'Azerbaijan', N'AZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (28, N'Bosnia And Herzegovina', N'BA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (20, N'Barbados', N'BB')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (19, N'Bangladesh', N'BD')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (22, N'Belgium', N'BE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (35, N'Burkina Faso', N'BF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (34, N'Bulgaria', N'BG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (18, N'Bahrain', N'BH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (36, N'Burundi', N'BI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (24, N'Benin', N'BJ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (25, N'Bermuda', N'BM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (33, N'Brunei Darussalam', N'BN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (27, N'Bolivia', N'BO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (31, N'Brazil', N'BR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (17, N'Bahamas', N'BS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (26, N'Bhutan', N'BT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (30, N'Bouvet Island', N'BV')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (29, N'Botswana', N'BW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (21, N'Belarus', N'BY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (23, N'Belize', N'BZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (39, N'Canada', N'CA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (47, N'Cocos (Keeling) Islands', N'CC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (51, N'Congo, The Democratic Republic Of The', N'CD')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (42, N'Central African Republic', N'CF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (50, N'Congo', N'CG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (210, N'Switzerland', N'CH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (54, N'Cote D''Ivoire', N'CI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (52, N'Cook Islands', N'CK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (44, N'Chile', N'CL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (38, N'Cameroon', N'CM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (45, N'China', N'CN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (48, N'Colombia', N'CO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (53, N'Costa Rica', N'CR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (193, N'Serbia And Montenegro', N'CS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (56, N'Cuba', N'CU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (40, N'Cape Verde', N'CV')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (46, N'Christmas Island', N'CX')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (57, N'Cyprus', N'CY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (58, N'Czech Republic', N'CZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (81, N'Germany', N'DE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (60, N'Djibouti', N'DJ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (59, N'Denmark', N'DK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (61, N'Dominica', N'DM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (62, N'Dominican Republic', N'DO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (4, N'Algeria', N'DZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (63, N'Ecuador', N'EC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (68, N'Estonia', N'EE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (64, N'Egypt', N'EG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (240, N'Western Sahara', N'EH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (67, N'Eritrea', N'ER')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (203, N'Spain', N'ES')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (69, N'Ethiopia', N'ET')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (73, N'Finland', N'FI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (72, N'Fiji', N'FJ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (70, N'Falkland Islands (Malvinas)', N'FK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (143, N'Micronesia, Federated States Of', N'FM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (71, N'Faroe Islands', N'FO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (74, N'France', N'FR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (78, N'Gabon', N'GA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (229, N'United Kingdom', N'GB')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (86, N'Grenada', N'GD')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (80, N'Georgia', N'GE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (75, N'French Guiana', N'GF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (90, N'Guernsey', N'GG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (82, N'Ghana', N'GH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (83, N'Gibraltar', N'GI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (85, N'Greenland', N'GL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (79, N'Gambia', N'GM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (91, N'Guinea', N'GN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (87, N'Guadeloupe', N'GP')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (66, N'Equatorial Guinea', N'GQ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (84, N'Greece', N'GR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (202, N'South Georgia And The South Sandwich Islands', N'GS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (89, N'Guatemala', N'GT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (88, N'Guam', N'GU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (92, N'Guinea-Bissau', N'GW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (93, N'Guyana', N'GY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (98, N'Hong Kong', N'HK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (95, N'Heard Island And Mcdonald Islands', N'HM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (97, N'Honduras', N'HN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (55, N'Croatia', N'HR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (94, N'Haiti', N'HT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (99, N'Hungary', N'HU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (102, N'Indonesia', N'ID')
GO
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (105, N'Ireland', N'IE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (107, N'Israel', N'IL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (106, N'Isle Of Man', N'IM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (101, N'India', N'IN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (32, N'British Indian Ocean Territory', N'IO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (104, N'Iraq', N'IQ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (103, N'Iran, Islamic Republic Of', N'IR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (100, N'Iceland', N'IS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (108, N'Italy', N'IT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (111, N'Jersey', N'JE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (109, N'Jamaica', N'JM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (112, N'Jordan', N'JO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (110, N'Japan', N'JP')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (114, N'Kenya', N'KE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (119, N'Kyrgyzstan', N'KG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (37, N'Cambodia', N'KH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (115, N'Kiribati', N'KI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (49, N'Comoros', N'KM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (184, N'Saint Kitts And Nevis', N'KN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (116, N'Korea, Democratic People''S Republic Of', N'KP')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (117, N'Korea, Republic Of', N'KR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (118, N'Kuwait', N'KW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (41, N'Cayman Islands', N'KY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (113, N'Kazakhstan', N'KZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (120, N'Lao People''S Democratic Republic', N'LA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (122, N'Lebanon', N'LB')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (185, N'Saint Lucia', N'LC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (126, N'Liechtenstein', N'LI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (204, N'Sri Lanka', N'LK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (124, N'Liberia', N'LR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (123, N'Lesotho', N'LS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (127, N'Lithuania', N'LT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (128, N'Luxembourg', N'LU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (121, N'Latvia', N'LV')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (125, N'Libyan Arab Jamahiriya', N'LY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (148, N'Morocco', N'MA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (145, N'Monaco', N'MC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (144, N'Moldova, Republic Of', N'MD')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (131, N'Madagascar', N'MG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (137, N'Marshall Islands', N'MH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (130, N'Macedonia, The Former Yugoslav Republic Of', N'MK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (135, N'Mali', N'ML')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (150, N'Myanmar', N'MM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (146, N'Mongolia', N'MN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (129, N'Macao', N'MO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (163, N'Northern Mariana Islands', N'MP')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (138, N'Martinique', N'MQ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (139, N'Mauritania', N'MR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (147, N'Montserrat', N'MS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (136, N'Malta', N'MT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (140, N'Mauritius', N'MU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (134, N'Maldives', N'MV')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (132, N'Malawi', N'MW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (142, N'Mexico', N'MX')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (133, N'Malaysia', N'MY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (149, N'Mozambique', N'MZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (151, N'Namibia', N'NA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (156, N'New Caledonia', N'NC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (159, N'Niger', N'NE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (162, N'Norfolk Island', N'NF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (160, N'Nigeria', N'NG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (158, N'Nicaragua', N'NI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (154, N'Netherlands', N'NL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (164, N'Norway', N'NO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (153, N'Nepal', N'NP')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (152, N'Nauru', N'NR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (161, N'Niue', N'NU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (157, N'New Zealand', N'NZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (165, N'Oman', N'OM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (169, N'Panama', N'PA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (172, N'Peru', N'PE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (76, N'French Polynesia', N'PF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (170, N'Papua New Guinea', N'PG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (173, N'Philippines', N'PH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (166, N'Pakistan', N'PK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (175, N'Poland', N'PL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (186, N'Saint Pierre And Miquelon', N'PM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (174, N'Pitcairn', N'PN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (177, N'Puerto Rico', N'PR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (168, N'Palestinian Territory, Occupied', N'PS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (176, N'Portugal', N'PT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (167, N'Palau', N'PW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (171, N'Paraguay', N'PY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (178, N'Qatar', N'QA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (179, N'Reunion', N'RE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (180, N'Romania', N'RO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (181, N'Russian Federation', N'RU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (182, N'Rwanda', N'RW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (191, N'Saudi Arabia', N'SA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (199, N'Solomon Islands', N'SB')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (194, N'Seychelles', N'SC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (205, N'Sudan', N'SD')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (209, N'Sweden', N'SE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (196, N'Singapore', N'SG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (183, N'Saint Helena', N'SH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (198, N'Slovenia', N'SI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (207, N'Svalbard And Jan Mayen', N'SJ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (197, N'Slovakia', N'SK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (195, N'Sierra Leone', N'SL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (189, N'San Marino', N'SM')
GO
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (192, N'Senegal', N'SN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (200, N'Somalia', N'SO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (206, N'Suriname', N'SR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (190, N'Sao Tome And Principe', N'ST')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (65, N'El Salvador', N'SV')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (211, N'Syrian Arab Republic', N'SY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (208, N'Switzerland', N'SZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (224, N'Turks And Caicos Islands', N'TC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (43, N'Chad', N'TD')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (77, N'French Southern Territories', N'TF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (217, N'Togo', N'TG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (215, N'Thailand', N'TH')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (213, N'Tajikistan', N'TJ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (218, N'Tokelau', N'TK')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (216, N'Timor-Leste', N'TL')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (223, N'Turkmenistan', N'TM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (221, N'Tunisia', N'TN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (219, N'Tonga', N'TO')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (222, N'Turkey', N'TR')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (220, N'Trinidad And Tobago', N'TT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (225, N'Tuvalu', N'TV')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (212, N'Taiwan, Province Of China', N'TW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (214, N'Tanzania, United Republic Of', N'TZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (227, N'Ukraine', N'UA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (226, N'Uganda', N'UG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (231, N'United States Minor Outlying Islands', N'UM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (230, N'United States', N'US')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (232, N'Uruguay', N'UY')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (233, N'Uzbekistan', N'UZ')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (96, N'Holy See (Vatican City State)', N'VA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (187, N'Saint Vincent And The Grenadines', N'VC')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (235, N'Venezuela', N'VE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (237, N'Virgin Islands, British', N'VG')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (238, N'Virgin Islands, U.S.', N'VI')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (236, N'Vietnam', N'VN')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (234, N'Vanuatu', N'VU')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (239, N'Wallis And Futuna', N'WF')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (188, N'Samoa', N'WS')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (241, N'Yemen', N'YE')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (141, N'Mayotte', N'YT')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (201, N'South Africa', N'ZA')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (242, N'Zambia', N'ZM')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (243, N'Zimbabwe', N'ZW')
INSERT [dbo].[Country] ([CountryID], [CountryName], [CountryCode]) VALUES (244, N'(Not Specified)', N'ZZ')