smithvoice.com
 Y'herd thisun? 

“What are linux Run Levels? How do you configure startups of linux services? Here ya go...”

from this page by smith

Country Code Table

TaggedCoding, Database

"Hey Smith!  Got that country code table SQL?"

Yeah, right here.

Alter the basic CREATE TABLE script for your table/colum naming and indexing needs.

Copy the inserts to notepad, find&replace to alter your table andor column names. Plus, change the asterisks and pipes as described next.

Asterisks wrap the iso numeric codes, if you want to save then as CHARs do a global replace from asterisk to single quote, if you want to save them as numerics then change the CREATE TABLE script to the type you want and do a global replace on the INSERTs to change all asterisks to empty strings.

Similarly,  the idd codes are wrapped in pipes ("|"), same deal as above but for these characters.  Remember that not all countries have idd values so allow nulls in that column.

You could change the iso numeric code to an int and use it as a pk if you want (or add an identity/sequence for your pk),but in real world use you might be better off using the 2 character code for the pk because most FIPS/subcode data sources use the 2 character code and so it can make relations for county/province/state data simpler.

(Since you're in the address mode, you might find this helpful too)

CREATE TABLE ctrcd
(
name varchar(50),
iso2 char(2),
iso3 char(3),
netsuf char(3),
isonum char(3),
idd varchar(4)
);

 

INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('AFGHANISTAN', 'AF', 'AFG', '.af', *004*, |93|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ALAND ISLANDS', 'AX', 'ALA', '.ax', *248*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ALBANIA', 'AL', 'ALB', '.al', *008*, |355|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ALGERIA', 'DZ', 'DZA', '.dz', *012*, |213|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('AMERICAN SAMOA', 'AS', 'ASM', '.as', *016*, |1684|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ANDORRA', 'AD', 'AND', '.ad', *020*, |376|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ANGOLA', 'AO', 'AGO', '.ao', *024*, |244|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ANGUILLA', 'AI', 'AIA', '.ai', *660*, |1264|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ANTARCTICA', 'AQ', 'ATA', '.aq', *010*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ANTIGUA AND BARBUDA', 'AG', 'ATG', '.ag', *028*, |1268|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ARGENTINA', 'AR', 'ARG', '.ar', *032*, |54|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ARMENIA', 'AM', 'ARM', '.am', *051*, |7|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ARUBA', 'AW', 'ABW', '.aw', *533*, |297|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('AUSTRALIA', 'AU', 'AUS', '.au', *036*, |61|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('AUSTRIA', 'AT', 'AUT', '.at', *040*, |43|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('AZERBAIJAN', 'AZ', 'AZE', '.az', *031*, |994|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BAHAMAS', 'BS', 'BHS', '.bs', *044*, |1242|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BAHRAIN', 'BH', 'BHR', '.bh', *048*, |973|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BANGLADESH', 'BD', 'BGD', '.bd', *050*, |880|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BARBADOS', 'BB', 'BRB', '.bb', *052*, |1246|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BELARUS', 'BY', 'BLR', '.by', *112*, |375|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BELGIUM', 'BE', 'BEL', '.be', *056*, |32|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BELIZE', 'BZ', 'BLZ', '.bz', *084*, |501|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BENIN', 'BJ', 'BEN', '.bj', *204*, |229|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BERMUDA', 'BM', 'BMU', '.bm', *060*, |1441|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BHUTAN', 'BT', 'BTN', '.bt', *064*, |975|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BOLIVIA', 'BO', 'BOL', '.bo', *068*, |591|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BOSNIA AND HERZEGOVINA', 'BA', 'BIH', '.ba', *070*, |387|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BOTSWANA', 'BW', 'BWA', '.bw', *072*, |267|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BOUVET ISLAND', 'BV', 'BVT', '.bv', *074*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BRAZIL', 'BR', 'BRA', '.br', *076*, |55|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BRITISH INDIAN OCEAN TERRITORY', 'IO', 'IOT', '.io', *086*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BRUNEI DARUSSALAM', 'BN', 'BRN', '.bn', *096*, |673|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BULGARIA', 'BG', 'BGR', '.bg', *100*, |359|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BURKINA FASO', 'BF', 'BFA', '.bf', *854*, |226|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('BURUNDI', 'BI', 'BDI', '.bi', *108*, |257|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CAMBODIA', 'KH', 'KHM', '.kh', *116*, |855|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CAMEROON', 'CM', 'CMR', '.cm', *120*, |237|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CANADA', 'CA', 'CAN', '.ca', *124*, |1|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CAPE VERDE', 'CV', 'CPV', '.cv', *132*, |238|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CAYMAN ISLANDS', 'KY', 'CYM', '.ky', *136*, |1345|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CENTRAL AFRICAN REPUBLIC', 'CF', 'CAF', '.cf', *140*, |236|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CHAD', 'TD', 'TCD', '.td', *148*, |235|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CHILE', 'CL', 'CHL', '.cl', *152*, |56|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CHINA', 'CN', 'CHN', '.cn', *156*, |86|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CHRISTMAS ISLAND', 'CX', 'CXR', '.cx', *162*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('COCOS (KEELING) ISLANDS', 'CC', 'CCK', '.cc', *166*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('COLOMBIA', 'CO', 'COL', '.co', *170*, |57|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('COMOROS', 'KM', 'COM', '.km', *174*, |269|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CONGO, DEMOCRATIC REPUBLIC OF', 'CD', 'COD', '.cd', *180*, |243|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CONGO, REPUBLIC OF', 'CG', 'COG', '.cg', *178*, |242|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('COOK ISLANDS', 'CK', 'COK', '.ck', *184*, |682|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('COSTA RICA', 'CR', 'CRI', '.cr', *188*, |506|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CROATIA', 'HR', 'HRV', '.hr', *191*, |385|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CUBA', 'CU', 'CUB', '.cu', *192*, |53|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CYPRUS', 'CY', 'CYP', '.cy', *196*, |357|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('CZECH REPUBLIC', 'CZ', 'CZE', '.cz', *203*, |420|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('DENMARK', 'DK', 'DNK', '.dk', *208*, |45|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('DJIBOUTI', 'DJ', 'DJI', '.dj', *262*, |253|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('DOMINICA', 'DM', 'DMA', '.dm', *212*, |1767|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('DOMINICAN REPUBLIC', 'DO', 'DOM', '.do', *214*, |1809|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ECUADOR', 'EC', 'ECU', '.ec', *218*, |593|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('EGYPT', 'EG', 'EGY', '.eg', *818*, |20|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('EL SALVADOR', 'SV', 'SLV', '.sv', *222*, |503|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('EQUATORIAL GUINEA', 'GQ', 'GNQ', '.gq', *226*, |240|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ERITREA', 'ER', 'ERI', '.er', *232*, |291|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ESTONIA', 'EE', 'EST', '.ee', *233*, |372|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ETHIOPIA', 'ET', 'ETH', '.et', *231*, |251|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FAEROE ISLANDS', 'FO', 'FRO', '.fo', *234*, |298|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FALKLAND ISLANDS', 'FK', 'FLK', '.fk', *238*, |500|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FIJI', 'FJ', 'FJI', '.fj', *242*, |679|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FINLAND', 'FI', 'FIN', '.fi', *246*, |358|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FRANCE', 'FR', 'FRA', '.fr', *250*, |33|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FRENCH GUIANA', 'GF', 'GUF', '.gf', *254*, |594|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FRENCH POLYNESIA', 'PF', 'PYF', '.pf', *258*, |689|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('FRENCH SOUTHERN TERRITORIES', 'TF', 'ATF', '.tf', *260*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GABON', 'GA', 'GAB', '.ga', *266*, |241|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GAMBIA, THE', 'GM', 'GMB', '.gm', *270*, |220|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GEORGIA', 'GE', 'GEO', '.ge', *268*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GERMANY', 'DE', 'DEU', '.de', *276*, |49|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GHANA', 'GH', 'GHA', '.gh', *288*, |233|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GIBRALTAR', 'GI', 'GIB', '.gi', *292*, |350|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GREAT BRITAIN', 'GB', 'GBR', '.uk', *826*, |44|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GREECE', 'GR', 'GRC', '.gr', *300*, |30|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GREENLAND', 'GL', 'GRL', '.gl', *304*, |299|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GRENADA', 'GD', 'GRD', '.gd', *308*, |1473|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GUADELOUPE', 'GP', 'GLP', '.gp', *312*, |590|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GUAM', 'GU', 'GUM', '.gu', *316*, |1671|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GUATEMALA', 'GT', 'GTM', '.gt', *320*, |502|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GUINEA', 'GN', 'GIN', '.gn', *324*, |224|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GUINEA-BISSAU', 'GW', 'GNB', '.gw', *624*, |245|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('GUYANA', 'GY', 'GUY', '.gy', *328*, |592|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('HAITI', 'HT', 'HTI', '.ht', *332*, |509|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('HEARD ISLAND AND MCDONALD ISLANDS', 'HM', 'HMD', '.hm', *334*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('HONDURAS', 'HN', 'HND', '.hn', *340*, |504|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('HONG KONG', 'HK', 'HKG', '.hk', *344*, |852|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('HUNGARY', 'HU', 'HUN', '.hu', *348*, |36|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ICELAND', 'IS', 'ISL', '.is', *352*, |354|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('INDIA', 'IN', 'IND', '.in', *356*, |91|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('INDONESIA', 'ID', 'IDN', '.id', *360*, |62|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('IRAN, Islamic Republic', 'IR', 'IRN', '.ir', *364*, |98|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('IRAQ', 'IQ', 'IRQ', '.iq', *368*, |964|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('IRELAND', 'IE', 'IRL', '.ie', *372*, |353|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ISLE OF MAN', 'IM', 'IMN', '.im', *833*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ISRAEL', 'IL', 'ISR', '.il', *376*, |972|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ITALY', 'IT', 'ITA', '.it', *380*, |39|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('IVORY COAST, Cote DIvoire', 'CI', 'CIV', '.ci', *384*, |225|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('JAMAICA', 'JM', 'JAM', '.jm', *388*, |1876|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('JAPAN', 'JP', 'JPN', '.jp', *392*, |81|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('JORDAN', 'JO', 'JOR', '.jo', *400*, |962|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('KAZAKHSTAN', 'KZ', 'KAZ', '.kz', *398*, |7|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('KENYA', 'KE', 'KEN', '.ke', *404*, |254|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('KIRIBATI', 'KI', 'KIR', '.ki', *296*, |686|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('KUWAIT', 'KW', 'KWT', '.kw', *414*, |965|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('KYRGYZSTAN', 'KG', 'KGZ', '.kg', *417*, |996|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LAOS', 'LA', 'LAO', '.la', *418*, |856|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LATVIA', 'LV', 'LVA', '.lv', *428*, |371|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LEBANON', 'LB', 'LBN', '.lb', *422*, |961|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LESOTHO', 'LS', 'LSO', '.ls', *426*, |266|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LIBERIA', 'LR', 'LBR', '.lr', *430*, |231|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LIBYA', 'LY', 'LBY', '.ly', *434*, |218|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LIECHTENSTEIN', 'LI', 'LIE', '.li', *438*, |423|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LITHUANIA', 'LT', 'LTU', '.lt', *440*, |370|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('LUXEMBOURG', 'LU', 'LUX', '.lu', *442*, |352|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MACAO', 'MO', 'MAC', '.mo', *446*, |853|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MACEDONIA', 'MK', 'MKD', '.mk', *807*, |389|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MADAGASCAR', 'MG', 'MDG', '.mg', *450*, |261|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MALAWI', 'MW', 'MWI', '.mw', *454*, |265|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MALAYSIA', 'MY', 'MYS', '.my', *458*, |60|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MALDIVES', 'MV', 'MDV', '.mv', *462*, |960|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MALI', 'ML', 'MLI', '.ml', *466*, |223|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MALTA', 'MT', 'MLT', '.mt', *470*, |356|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MARSHALL ISLANDS', 'MH', 'MHL', '.mh', *584*, |692|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MARTINIQUE', 'MQ', 'MTQ', '.mq', *474*, |596|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MAURITANIA', 'MR', 'MRT', '.mr', *478*, |222|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MAURITIUS', 'MU', 'MUS', '.mu', *480*, |230|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MAYOTTE', 'YT', 'MYT', '.yt', *175*, |269|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MEXICO', 'MX', 'MEX', '.mx', *484*, |52|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MICRONESIA', 'FM', 'FSM', '.fm', *583*, |691|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MOLDOVA', 'MD', 'MDA', '.md', *498*, |373|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MONACO', 'MC', 'MCO', '.mc', *492*, |377|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MONGOLIA', 'MN', 'MNG', '.mn', *496*, |976|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MONTENEGRO', 'ME', 'MNE', '.me', *499*, |382|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MONTSERRAT', 'MS', 'MSR', '.ms', *500*, |1664|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MOROCCO', 'MA', 'MAR', '.ma', *504*, |212|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MOZAMBIQUE', 'MZ', 'MOZ', '.mz', *508*, |258|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('MYANMAR, formerly Burma', 'MM', 'MMR', '.mm', *104*, |95|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NAMIBIA', 'NA', 'NAM', '.na', *516*, |264|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NAURU', 'NR', 'NRU', '.nr', *520*, |674|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NEPAL', 'NP', 'NPL', '.np', *524*, |977|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NETHERLANDS', 'NL', 'NLD', '.nl', *528*, |31|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NETHERLANDS ANTILLES', 'AN', 'ANT', '.an', *530*, |599|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NEW CALEDONIA', 'NC', 'NCL', '.nc', *540*, |687|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NEW ZEALAND', 'NZ', 'NZL', '.nz', *554*, |64|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NICARAGUA', 'NI', 'NIC', '.ni', *558*, |505|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NIGER', 'NE', 'NER', '.ne', *562*, |227|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NIGERIA', 'NG', 'NGA', '.ng', *566*, |234|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NIUE', 'NU', 'NIU', '.nu', *570*, |683|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NORFOLK ISLAND', 'NF', 'NFK', '.nf', *574*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('North KOREA', 'KP', 'PRK', '.kp', *408*, |850|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NORTHERN MARIANA ISLANDS', 'MP', 'MNP', '.mp', *580*, |1670|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('NORWAY', 'NO', 'NOR', '.no', *578*, |47|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('OMAN', 'OM', 'OMN', '.om', *512*, |968|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PAKISTAN', 'PK', 'PAK', '.pk', *586*, |92|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PALAU', 'PW', 'PLW', '.pw', *585*, |680|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PALESTINIAN TERRITORIES', 'PS', 'PSE', '.ps', *275*, |970|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PANAMA', 'PA', 'PAN', '.pa', *591*, |507|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PAPUA NEW GUINEA', 'PG', 'PNG', '.pg', *598*, |675|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PARAGUAY', 'PY', 'PRY', '.py', *600*, |595|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PERU', 'PE', 'PER', '.pe', *604*, |51|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PHILIPPINES', 'PH', 'PHL', '.ph', *608*, |63|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PITCAIRN', 'PN', 'PCN', '.pn', *612*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('POLAND', 'PL', 'POL', '.pl', *616*, |48|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PORTUGAL', 'PT', 'PRT', '.pt', *620*, |351|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('PUERTO RICO', 'PR', 'PRI', '.pr', *630*, |1|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('QATAR', 'QA', 'QAT', '.qa', *634*, |974|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('REUNION', 'RE', 'REU', '.re', *638*, |262|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ROMANIA', 'RO', 'ROU', '.ro', *642*, |40|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('RUSSIAN FEDERATION', 'RU', 'RUS', '.ru', *643*, |7|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('RWANDA', 'RW', 'RWA', '.rw', *646*, |250|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAINT BARTHELEMY', 'BL', 'BLM', '.bl', *652*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAINT HELENA', 'SH', 'SHN', '.sh', *654*, |290|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAINT KITTS AND NEVIS', 'KN', 'KNA', '.kn', *659*, |1869|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAINT LUCIA', 'LC', 'LCA', '.lc', *662*, |1758|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAINT MARTIN, French portion)', 'MF', 'MAF', '.mf', *663*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAINT PIERRE AND MIQUELON', 'PM', 'SPM', '.pm', *666*, |508|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAINT VINCENT AND THE GRENADINES', 'VC', 'VCT', '.vc', *670*, |1784|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAMOA', 'WS', 'WSM', '.ws', *882*, |685|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAN MARINO', 'SM', 'SMR', '.sm', *674*, |378|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAO TOME AND PRINCIPE', 'ST', 'STP', '.st', *678*, |239|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SAUDI ARABIA, Kingdom of', 'SA', 'SAU', '.sa', *682*, |966|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SENEGAL', 'SN', 'SEN', '.sn', *686*, |221|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SERBIA, Republic of', 'RS', 'SRB', '.rs', *688*, |381|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SEYCHELLES', 'SC', 'SYC', '.sc', *690*, |248|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SIERRA LEONE', 'SL', 'SLE', '.sl', *694*, |232|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SINGAPORE', 'SG', 'SGP', '.sg', *702*, |65|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SLOVAKIA, Slovak Republic)', 'SK', 'SVK', '.sk', *703*, |421|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SLOVENIA', 'SI', 'SVN', '.si', *705*, |386|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SOLOMON ISLANDS', 'SB', 'SLB', '.sb', *090*, |677|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SOMALIA', 'SO', 'SOM', '.so', *706*, |252|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SOUTH AFRICA', 'ZA', 'ZAF', '.za', *710*, |27|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS', 'SGS', '.gs', *239*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('South KOREA, Republic of)', 'KR', 'KOR', '.kr', *410*, |82|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SPAIN', 'ES', 'ESP', '.es', *724*, |34|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SRI LANKA', 'LK', 'LKA', '.lk', *144*, |94|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SUDAN', 'SD', 'SDN', '.sd', *736*, |249|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SURINAME', 'SR', 'SUR', '.sr', *740*, |597|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SVALBARD AND JAN MAYEN', 'SJ', 'SJM', '.sj', *744*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SWAZILAND', 'SZ', 'SWZ', '.sz', *748*, |268|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SWEDEN', 'SE', 'SWE', '.se', *752*, |46|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SWITZERLAND', 'CH', 'CHE', '.ch', *756*, |41|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('SYRIAN ARAB REPUBLIC', 'SY', 'SYR', '.sy', *760*, |963|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TAIWAN', 'TW', 'TWN', '.tw', *158*, |886|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TAJIKISTAN', 'TJ', 'TJK', '.tj', *762*, |992|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TANZANIA', 'TZ', 'TZA', '.tz', *834*, |255|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('THAILAND', 'TH', 'THA', '.th', *764*, |66|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TIMOR-LESTE', 'TL', 'TLS', '.tl', *626*, |670|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TOGO', 'TG', 'TGO', '.tg', *768*, |228|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TOKELAU', 'TK', 'TKL', '.tk', *772*, |690|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TONGA', 'TO', 'TON', '.to', *776*, |676|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TRINIDAD AND TOBAGO', 'TT', 'TTO', '.tt', *780*, |1868|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TUNISIA', 'TN', 'TUN', '.tn', *788*, |216|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TURKEY', 'TR', 'TUR', '.tr', *792*, |90|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TURKMENISTAN', 'TM', 'TKM', '.tm', *795*, |993|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TURKS AND CAICOS ISLANDS', 'TC', 'TCA', '.tc', *796*, |1649|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('TUVALU', 'TV', 'TUV', '.tv', *798*, |688|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('UGANDA', 'UG', 'UGA', '.ug', *800*, |256|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('UKRAINE', 'UA', 'UKR', '.ua', *804*, |380|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('UNITED ARAB EMIRATES', 'AE', 'ARE', '.ae', *784*, |971|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('UNITED STATES', 'US', 'USA', '.us', *840*, |1|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('UNITED STATES MINOR OUTLYING ISLANDS', 'UM', 'UMI', '.um', *581*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('URUGUAY', 'UY', 'URY', '.uy', *858*, |598|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('UZBEKISTAN', 'UZ', 'UZB', '.uz', *860*, |998|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('VANUATU', 'VU', 'VUT', '.vu', *548*, |678|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('VATICAN CITY', 'VA', 'VAT', '.va', *336*, |379|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('VENEZUELA', 'VE', 'VEN', '.ve', *862*, |58|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('VIET NAM', 'VN', 'VNM', '.vn', *704*, |84|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('VIRGIN ISLANDS, BRITISH', 'VG', 'VGB', '.vg', *092*, |1284|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('VIRGIN ISLANDS, U.S.', 'VI', 'VIR', '.vi', *850*, |1340|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('WALLIS AND FUTUNA', 'WF', 'WLF', '.wf', *876*, |681|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('WESTERN SAHARA', 'EH', 'ESH', '.eh', *732*, ||);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('YEMEN', 'YE', 'YEM', '.ye', *887*, |967|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ZAMBIA', 'ZM', 'ZMB', '.zm', *894*, |260|);
INSERT INTO ctrcd (name, iso2, iso3, netsuf, isonum, idd) VALUES ('ZIMBABWE', 'ZW', 'ZWE', '.zw', *716*, |263|);


home     who is smith    contact smith     rss feed π
Since 1997 a place for my stuff, and it if helps you too then all the better smithvoice.com