tCountry Table

Touchstone 2022 Database Reference

tCountry Table

Collapse All

AIRReference Database : tCountry Table

Description

Stores the supported country codes and indicates whether each country is modeled and an offshore location.

Properties

Creation Date	10/24/2013 4:30 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	283
Data Space Used	16.00 KB
Index Space Used	16.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	CountryCode	ISO 2-character code for the country. Modeled countries are indicated in bold. For a complete list of county aliases, see TblCountryAlias Table. AD = Andorra AE = United Arab Emirates AF = Afghanistan AG = Antigua and Barbuda AI = Anguilla AL = Albania ALO = Alaska Offshore AM = Armenia AN = Netherlands Antilles ANO = Angola Offshore AO = Angola AQ = Antarctica AR = Argentina ARO = Arctic Offshore AS = American Samoa AT = Austria AU = Australia AUO = Australasia Offshore AW = Aruba AX = Åland Islands AZ = Azerbaijan BA = Bosnia and Herzegovina BB = Barbados BCO = Bay of Campeche Offshore BD = Bangladesh BE = Belgium BF = Burkina Faso BG = Bulgaria BH = Bahrain BI = Burundi BJ = Benin BL = Saint Barthélemy BM = Bermuda BN = Brunei BO = Bolivia BQ = Bonaire and Sint Eustatius and Saba BR = Brazil BRO = Brazil Offshore BS = Bahamas BSO = Baltic Sea Offshore BT = Bhutan BV = Bouvet Island BW = Botswana BY = Belarus BZ = Belize CA = Canada CAO = Canada Offshore CAS = Caspian Sea CC = Cocos Islands CD = Congo Republic Of CF = Central African Republic CG = Congo CH = Switzerland CI = Côte D'Ivoire CK = Cook Islands CL = Chile CM = Cameroon CN = China CNO = China Offshore CO = Colombia CR = Costa Rica CU = Cuba CV = Cape Verde CW = Curacao CX = Christmas Island CY = Cyprus CZ = Czech Republic DE = Germany DJ = Djibouti DK = Denmark DM = Dominica DO = Dominican Republic DZ = Algeria AO = East Africa Offshore EC = Ecuador EE = Estonia EG = Egypt EGO = Egypt Offshore EH = Western Sahara ER = Eritrea ES = Spain ET = Ethiopia FAO = Far East Offshore FI = Finland FJ = Fiji FK = Falkland Islands FM = Micronesia FO = Faeroe Islands FR = France GA = Gabon GAO = Gabon Offshore GB = United Kingdom GD = Grenada GE = Georgia GF = French Guiana GG = Guernsey GH = Ghana GI = Gibraltar GL = Greenland GM = Gambia GN = Guinea GOM = Gulf Of Mexico GP = Guadeloupe GQ = Equatorial Guinea GR = Greece GS = South Georgia and the South Sandwich Islands GT = Guatemala GU = Guam GW = Guinea-bissau GY = Guyana HK = Hong Kong HM = Heard Island and Mcdonald Islands HN = Honduras HR = Croatia HT = Haiti HU = Hungary ID = Indonesia IE = Ireland IL = Israel IM = Isle Of Man IN = India INC = India Crop INO = Indian Subcontinent Offshore IO = British Indian Ocean Territory IQ = Iraq IR = Iran IS = Iceland IT = Italy JE = Jersey JKO = Japan/Korea Offshore JM = Jamaica JO = Jordan JP = Japan KE = Kenya KG = Kyrgyzstan KH = Cambodia KI = Kiribati KM = Comoros KN = Saint Kitts and Nevis KP = Korea KR = South Korea KW = Kuwait KY = Cayman Islands KZ = Kazakhstan LA = Lao People's Democratic Republic LB = Lebanon LC = Saint Lucia LI = Liechtenstein LK = Sri Lanka LR = Liberia LS = Lesotho LT = Lithuania LU = Luxembourg LV = Latvia LY = Libya MA = Morocco MC = Monaco MD = Moldova ME = Montenegro MEO = Mediterranean Offshore MF = St. Martin MG = Madagascar MH = Marshall Islands MIO = Middle East Offshore MK = Macedonia ML = Mali MM = Myanmar MN = Mongolia MO = Macau MP = Saipan MQ = Martinique MR = Mauritania MS = Montserrat MT = Malta MU = Mauritius MV = Maldives MW = Malawi MX = Mexico MXO = Mexico Offshore MY = Malaysia MZ = Mozambique NA = Namibia NC = New Caledonia NE = Niger NF = Norfolk Island NG = Nigeria NI = Nicaragua NIO = Nigeria Offshore NL = Netherlands NO = Norway NOO = Norway Offshore NP = Nepal NR = Nauru NSO = North Sea Offshore NU = Niue NZ = New Zealand OM = Oman PA = Panama PE = Peru PF = French Polynesia PG = Papua New Guinea PH = Philippines PK = Pakistan PL = Poland PM = Saint Pierre and Miquelon PN = Pitcairn PR = Puerto Rico PS = Palestinian Territories PT = Portugal PW = Palau PY = Paraguay QA = Qatar RE = Reunion RO = Romania RS = Serbia RU = Russian Federation RUO = Russia Offshore RW = Rwanda SA = Saudi Arabia SAO = South America Offshore SB = Solomon Islands SC = Seychelles SD = Sudan SE = Sweden SEO = Sweden Offshore SG = Singapore SH = Saint Helena SI = Slovenia SJ = Svalbard and Jan Mayen SK = Slovakia SL = Sierra Leone SM = San Marino SN = Senegal SO = Somalia SR = Suriname SSO = South Asia Offshore ST = Sao Tome and Principe SV = El Salvador SX = St. Maarten SY = Syrian Arab Republic SZ = Swaziland TC = Turks and Caicos Islands TD = Chad TF = French Southern Territories TG = Togo TH = Thailand TJ = Tajikistan TK = Tokelau TL = Timor-leste TM = Turkmenistan TN = Tunisia TO = Tonga TR = Turkey TT = Trinidad and Tobago TTO = Trinidad and Tobago Offshore TV = Tuvalu TW = Taiwan TZ = Tanzania UA = Ukraine UG = Uganda UKO = United Kingdom Offshore UM = United States Minor Outlying Islands US = United States UY = Uruguay UZ = Uzbekistan VA = Vatican City VC = Saint Vincent and the Grenadines VE = Venezuela VEO = Venezuela Offshore VG = Virgin Islands British VI = Virgin Islands (US) VN = Vietnam VNO = Vietnam Offshore VU = Vanuatu WAO = West Africa Offshore WF = Wallis and Futuna WS = Samoa WUO = West US/California Offshore YE = Yemen YT Mayotte ZA = South Africa ZM = Zambia ZW = Zimbabwe	varchar	15
	Description	Description of the county.	varchar	1024
	IsModeled	Indicates whether the country is modeled. 1 = Yes (modeled) 0 = No (not modeled)	bit	1
	IsOffshore	Indicates whether the country is an offshore location. 1 = Yes (offshore) 0 = No (not offshore)	bit	1

Objects that depend on tCountry

Database Object

Object Type

Description

Dep Level

tAIRConstOccRegionCountryXref table

tAIRConstOccRegionCountryXref

Table

System reference table that stores the countries supported for each region.

1

tAIROccConSpecial table

tAIROccConSpecial

Table

Stores special AIR construction and occupancy class codes for each region.

1

tCLFIndustryLOB table

tCLFIndustryLOB

Table

Stores the industry line of business data by country used by Touchstone to generate company loss files (CLFs).

Industry LOB data appears in a CLF in the following order: country, peril, and INF version.

1

See Also

Related Objects

AIRReference Database

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.