Hi Koen,
I did use this source
http://www.nationsonline.org/oneworld/countrycodes.htm ago one year.
Maybe any country added this list. :-)
MartinaJ
>>>Does anyone have a dbf containing country names and 2 character country codes?
>>
>>Do you mean ISO or US goverment?
>>
>>
>>CREATE TABLE [dbo].[COUNTRIES] (
>> [FIPS] [char] (2) NULL ,
>> [ALPHA2] [char] (2) NULL ,
>> [ALPHA3] [char] (3) NULL ,
>> [UN] [char] (3) NULL ,
>> [NAME] [varchar] (100) NULL
>>) ON [PRIMARY]
>>GO
>>
>>CREATE INDEX [FK01_COUNTRIES] ON [dbo].[COUNTRIES]([FIPS])
>>GO
>>
>>CREATE INDEX [FK02_COUNTRIES] ON [dbo].[COUNTRIES]([ALPHA2])
>>GO
>>
>>CREATE INDEX [FK03_COUNTRIES] ON [dbo].[COUNTRIES]([ALPHA3])
>>GO
>>
>>CREATE INDEX [FK04_COUNTRIES] ON [dbo].[COUNTRIES]([UN])
>>GO
>>
>
>Martina,
>
>Very cool. Please add my stars also.
>
>Regards,
>
>Koen
>
>P.S. do you also supply a yearly update for new countries?
>
>
>>
>>SET NOCOUNT ON
>>
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AF', 'AF', 'AFG', '004', 'Afghanistan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AL', 'AL', 'ALB', '008', 'Albania' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AG', 'DZ', 'DZA', '012', 'Algeria' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AQ', 'AS', 'ASM', '016', 'American Samoa' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AN', 'AD', 'AND', '020', 'Andorra' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AO', 'AO', 'AGO', '024', 'Angola' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AV', 'AI', 'AIA', '660', 'Anguilla' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AY', 'AQ', 'ATA', '010', 'Antarctica' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AC', 'AG', 'ATG', '028', 'Antigua and Barbuda' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AR', 'AR', 'ARG', '032', 'Argentina' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AM', 'AM', 'ARM', '051', 'Armenia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AA', 'AW', 'ABW', '533', 'Aruba' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AS', 'AU', 'AUS', '036', 'Australia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AU', 'AT', 'AUT', '040', 'Austria' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AJ', 'AZ', 'AZE', '031', 'Azerbaijan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BF', 'BS', 'BHS', '044', 'Bahamas' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BA', 'BH', 'BHR', '048', 'Bahrain' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BG', 'BD', 'BGD', '050', 'Bangladesh' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BB', 'BB', 'BRB', '052', 'Barbados' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BO', 'BY', 'BLR', '112', 'Belarus' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BE', 'BE', 'BEL', '056', 'Belgium' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BH', 'BZ', 'BLZ', '084', 'Belize' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BN', 'BJ', 'BEN', '204', 'Benin' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BD', 'BM', 'BMU', '060', 'Bermuda' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BT', 'BT', 'BTN', '064', 'Bhutan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BL', 'BO', 'BOL', '068', 'Bolivia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BK', 'BA', 'BIH', '070', 'Bosnia and Herzegovina' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BC', 'BW', 'BWA', '072', 'Botswana' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BR', 'BR', 'BRA', '076', 'Brazil' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VG', 'VI', 'VGB', '092', 'British Virgin Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BX', 'BN', 'BRN', '096', 'Brunei Darussalam' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BU', 'BG', 'BGR', '100', 'Bulgaria' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'UV', 'BF', 'BFA', '854', 'Burkina Faso' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BY', 'BI', 'BDI', '108', 'Burundi' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CB', 'KH', 'KHM', '116', 'Cambodia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CM', 'CM', 'CMR', '120', 'Cameroon' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CA', 'CA', 'CAN', '124', 'Canada' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CV', 'CV', 'CPV', '132', 'Cape Verde' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CJ', 'KY', 'CYM', '136', 'Cayman Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CT', 'CF', 'CAF', '140', 'Central African Republic' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CD', 'TD', 'TCD', '148', 'Chad' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CI', 'CL', 'CHL', '152', 'Chile' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CH', 'CN', 'CHN', '156', 'China' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KT', 'CX', 'CXR', '162', 'Christmas Island' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CK', 'CC', 'CCK', '166', 'Cocos (Keeling) Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CO', 'CO', 'COL', '170', 'Colombia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CN', 'KM', 'COM', '174', 'Comoros' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CG', 'CD', 'COD', '180', 'Congo Dem. Rep of the' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CF', 'CG', 'COG', '178', 'Congo, Republic of' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CW', 'CK', 'COK', '184', 'Cook Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CS', 'CR', 'CRI', '188', 'Costa Rica' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'IV', 'CI', 'CIV', '384', 'Cote D''Ivoire' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'HR', 'HR', 'HRV', '191', 'Croatia/Hrvatska' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CU', 'CU', 'CUB', '192', 'Cuba' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CY', 'CY', 'CYP', '196', 'Cyprus' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'EZ', 'CZ', 'CZE', '203', 'Czech Republic' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'DA', 'DK', 'DNK', '208', 'Denmark' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'DJ', 'DJ', 'DJI', '262', 'Djibouti' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'DO', 'DM', 'DMA', '212', 'Dominica' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'DR', 'DO', 'DOM', '214', 'Dominican Republic' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'EC', 'EC', 'ECU', '218', 'Ecuador' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'EG', 'EG', 'EGY', '818', 'Egypt' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ES', 'SV', 'SLV', '222', 'El Salvador' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'EK', 'GQ', 'GNQ', '226', 'Equatorial Guinea' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ER', 'ER', 'ERI', '232', 'Eritrea' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'EN', 'EE', 'EST', '233', 'Estonia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ET', 'ET', 'ETH', '231', 'Ethiopia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FK', 'FK', 'FLK', '238', 'Falkland Islands (Malvinas)' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FO', 'FO', 'FRO', '234', 'Faroe Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FJ', 'FJ', 'FJI', '242', 'Fiji' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FI', 'FI', 'FIN', '246', 'Finland' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FR', 'FR', 'FRA', '250', 'France' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FG', 'GF', 'GUF', '254', 'French Guiana' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FP', 'PF', 'PYF', '258', 'French Polynesia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FS', 'TF', 'ATF', '260', 'French Southern Territories' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GB', 'GA', 'GAB', '266', 'Gabon' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GA', 'GM', 'GMB', '270', 'Gambia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GG', 'GE', 'GEO', '268', 'Georgia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GM', 'DE', 'DEU', '276', 'Germany' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GH', 'GH', 'GHA', '288', 'Ghana' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GI', 'GI', 'GIB', '292', 'Gibraltar' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GR', 'GR', 'GRC', '300', 'Greece' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GL', 'GL', 'GRL', '304', 'Greenland' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GJ', 'GD', 'GRD', '308', 'Grenada' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GP', 'GP', 'GLP', '312', 'Guadeloupe' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GQ', 'GU', 'GUM', '316', 'Guam' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GT', 'GT', 'GTM', '320', 'Guatemala' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GV', 'GN', 'GIN', '324', 'Guinea' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PU', 'GW', 'GNB', '624', 'Guinea-Bissau' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'GY', 'GY', 'GUY', '328', 'Guyana' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'HA', 'HT', 'HTI', '332', 'Haiti' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VT', 'VA', 'VAT', '336', 'Holy See (Vatican)' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'HO', 'HN', 'HND', '340', 'Honduras' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'HK', 'HK', 'HKG', '344', 'Hong Kong' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'HU', 'HU', 'HUN', '348', 'Hungary' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'IC', 'IS', 'ISL', '352', 'Iceland' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'IN', 'IN', 'IND', '356', 'India' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ID', 'ID', 'IDN', '360', 'Indonesia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'IR', 'IR', 'IRN', '364', 'Iran (Islamic Republic of)' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'IZ', 'IQ', 'IRQ', '368', 'Iraq' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'EI', 'IE', 'IRL', '372', 'Ireland' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'IS', 'IL', 'ISR', '376', 'Israel' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'IT', 'IT', 'ITA', '380', 'Italy' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'JM', 'JM', 'JAM', '388', 'Jamaica' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'JA', 'JP', 'JPN', '392', 'Japan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'JO', 'JO', 'JOR', '400', 'Jordan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KZ', 'KZ', 'KAZ', '398', 'Kazakhstan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KE', 'KE', 'KEN', '404', 'Kenya' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KR', 'KI', 'KIR', '296', 'Kiribati' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KN', 'KP', 'PRK', '408', 'Korea, DPR' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KS', 'KR', 'KOR', '410', 'Korea, Republic of' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KU', 'KW', 'KWT', '414', 'Kuwait' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'KG', 'KG', 'KGZ', '417', 'Kyrgyzstan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LA', 'LA', 'LAO', '418', 'Lao, PDR' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LG', 'LV', 'LVA', '428', 'Latvia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LE', 'LB', 'LBN', '422', 'Lebanon' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LT', 'LS', 'LSO', '426', 'Lesotho' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LI', 'LR', 'LBR', '430', 'Liberia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LY', 'LY', 'LBY', '434', 'Libyan Arab Jamahiriya' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LS', 'LI', 'LIE', '438', 'Liechtenstein' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LH', 'LT', 'LTU', '440', 'Lithuania' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LU', 'LU', 'LUX', '442', 'Luxembourg' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MC', 'MO', 'MAC', '446', 'Macau' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MK', 'MK', 'MKD', '807', 'Macedonia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MA', 'MG', 'MDG', '450', 'Madagascar' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MI', 'MW', 'MWI', '454', 'Malawi' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MY', 'MY', 'MYS', '458', 'Malaysia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MV', 'MV', 'MDV', '462', 'Maldives' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ML', 'ML', 'MLI', '466', 'Mali' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MT', 'MT', 'MLT', '470', 'Malta' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RM', 'MH', 'MHL', '584', 'Marshall Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MB', 'MQ', 'MTQ', '474', 'Martinique' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MR', 'MR', 'MRT', '478', 'Mauritania' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MP', 'MU', 'MUS', '480', 'Mauritius' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MF', 'YT', 'MYT', '175', 'Mayotte' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MX', 'MX', 'MEX', '484', 'Mexico' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'FM', 'FM', 'FSM', '583', 'Micronesia, Fed. States of' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MD', 'MD', 'MDA', '498', 'Moldova, Republic of' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MN', 'MC', 'MCO', '492', 'Monaco' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MG', 'MN', 'MNG', '496', 'Mongolia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MW', 'ME', 'MNE', '499', 'Montenegro' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MJ', 'MS', 'MSR', '500', 'Montserrat' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MO', 'MA', 'MAR', '504', 'Morocco' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MZ', 'MZ', 'MOZ', '508', 'Mozambique' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BM', 'MM', 'MMR', '104', 'Myanmar' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'WA', 'NA', 'NAM', '516', 'Namibia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NR', 'NR', 'NRU', '520', 'Nauru' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NP', 'NP', 'NPL', '524', 'Nepal' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NL', 'NL', 'NLD', '528', 'Netherlands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NT', 'AN', 'ANT', '530', 'Netherlands Antilles' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NC', 'NC', 'NCL', '540', 'New Caledonia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NZ', 'NZ', 'NZL', '554', 'New Zealand' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NU', 'NI', 'NIC', '558', 'Nicaragua' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NG', 'NE', 'NER', '562', 'Niger' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NI', 'NG', 'NGA', '566', 'Nigeria' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NE', 'NU', 'NIU', '570', 'Niue' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NF', 'NF', 'NFK', '574', 'Norfolk Island' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CQ', 'MP', 'MNP', '580', 'Northern Mariana Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NO', 'NO', 'NOR', '578', 'Norway' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'MU', 'OM', 'OMN', '512', 'Oman' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PK', 'PK', 'PAK', '586', 'Pakistan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PS', 'PW', 'PLW', '585', 'Palau' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'WE', 'PS', 'PSE', '275', 'Palestine' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PM', 'PA', 'PAN', '591', 'Panama' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PP', 'PG', 'PNG', '598', 'Papua New Guinea' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PA', 'PY', 'PRY', '600', 'Paraguay' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PE', 'PE', 'PER', '604', 'Peru' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RP', 'PH', 'PHL', '608', 'Philippines' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PC', 'PN', 'PCN', '612', 'Pitcairn Island' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PL', 'PL', 'POL', '616', 'Poland' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'PO', 'PT', 'PRT', '620', 'Portugal' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RQ', 'PR', 'PRI', '630', 'Puerto Rico' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'QA', 'QA', 'QAT', '634', 'Qatar' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RE', 'RE', 'REU', '638', 'Réunion' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RO', 'RO', 'ROU', '642', 'Romania' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RS', 'RU', 'RUS', '643', 'Russian Federation' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RW', 'RW', 'RWA', '646', 'Rwanda' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SH', 'SH', 'SHN', '654', 'Saint Helena' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SC', 'KN', 'KNA', '659', 'Saint Kitts and Nevis' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ST', 'LC', 'LCA', '662', 'Saint Lucia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SB', 'PM', 'SPM', '666', 'Saint Pierre and Miquelon' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VC', 'VC', 'VCT', '670', 'Saint Vincent and the Grenadines' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'WS', 'WS', 'WSM', '882', 'Samoa' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SM', 'SM', 'SMR', '674', 'San Marino' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TP', 'ST', 'STP', '678', 'Sao Tome and Principe' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SA', 'SA', 'SAU', '682', 'Saudi Arabia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SG', 'SN', 'SEN', '686', 'Senegal' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'RI', 'RS', 'SRB', '688', 'Serbia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SE', 'SC', 'SYC', '690', 'Seychelles' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SL', 'SL', 'SLE', '694', 'Sierra Leone' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SN', 'SG', 'SGP', '702', 'Singapore' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'LO', 'SK', 'SVK', '703', 'Slovakia (Slovak Rep.)' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SI', 'SI', 'SVN', '705', 'Slovenia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'BP', 'SB', 'SLB', '090', 'Solomon Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SO', 'SO', 'SOM', '706', 'Somalia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SF', 'ZA', 'ZAF', '710', 'South Africa' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SX', 'GS', 'SGS', '---', 'South Georgia and South Sandwich Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SP', 'ES', 'ESP', '724', 'Spain' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'CE', 'LK', 'LKA', '144', 'Sri Lanka' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SU', 'SD', 'SDN', '736', 'Sudan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NS', 'SR', 'SUR', '740', 'Suriname' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SV', 'SJ', 'SJM', '744', 'Svalbard and Jan Mayen' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'WZ', 'SZ', 'SWZ', '748', 'Swaziland' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SW', 'SE', 'SWE', '752', 'Sweden' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SZ', 'CH', 'CHE', '756', 'Switzerland' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'SY', 'SY', 'SYR', '760', 'Syrian Arab Republic' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TW', 'TW', 'TWN', '158', 'Taiwan, Republic of China' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TI', 'TJ', 'TJK', '762', 'Tajikistan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TZ', 'TZ', 'TZA', '834', 'Tanzania' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TH', 'TH', 'THA', '764', 'Thailand' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TT', 'TL', 'TLS', '626', 'Timor-Leste (East Timor)' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TO', 'TG', 'TGO', '768', 'Togo' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TL', 'TK', 'TKL', '772', 'Tokelau' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TN', 'TO', 'TON', '776', 'Tonga' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TD', 'TT', 'TTO', '780', 'Trinidad and Tobago' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TS', 'TN', 'TUN', '788', 'Tunisia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TU', 'TR', 'TUR', '792', 'Turkey' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TX', 'TM', 'TKM', '795', 'Turkmenistan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TK', 'TC', 'TCA', '796', 'Turks and Caicos Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'TV', 'TV', 'TUV', '798', 'Tuvalu' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'UG', 'UG', 'UGA', '800', 'Uganda' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'UP', 'UA', 'UKR', '804', 'Ukraine' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'AE', 'AE', 'ARE', '784', 'United Arab Emirates' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'UK', 'GB', 'GBR', '826', 'United Kingdom' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'US', 'US', 'USA', '840', 'United States' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'UY', 'UY', 'URY', '858', 'Uruguay' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'UZ', 'UZ', 'UZB', '860', 'Uzbekistan' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'NH', 'VU', 'VUT', '548', 'Vanuatu' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VT', 'VA', 'VAT', '336', 'Vatican City State' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VE', 'VE', 'VEN', '548', 'Venezuela' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VM', 'VN', 'VNM', '704', 'Viet Nam' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VI', 'VG', 'VGB', '092', 'Virgin Islands (British)' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'VQ', 'VI', 'VIR', '850', 'Virgin Islands (U.S.)' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'WF', 'WF', 'WLF', '876', 'Wallis and Futuna Islands' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'WI', 'EH', 'ESH', '732', 'Western Sahara' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'YM', 'YE', 'YEM', '887', 'Yemen' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ZA', 'ZM', 'ZMB', '894', 'Zambia' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'ZI', 'ZW', 'ZWE', '716', 'Zimbabwe' )
>>
>>INSERT INTO [dbo].[COUNTRIES] ([FIPS], [ALPHA2], [ALPHA3], [UN], [NAME] )
>> VALUES ( 'WQ', 'UM', 'XXX', 'XXX', 'Wake Island' )
>>
>>GO
>>
>>
>>
