 | TABLE OF CONTENTS |
Appendix 1: time zones
0 = (UTC) Universal Coordinated Time
1 = (GMT) Greenwich Mean Time
2= (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London
3 = (GMT+01:00) Brussels, Copenhagen, Madrid, Paris
4 = (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
5 = (GMT+02:00) Bucharest
6 = (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
7 = (GMT+02:00) Athens, Istanbul, Minsk
8 = (GMT-03:00) Brasilia
9 = (GMT-04:00) Atlantic Time (Canada)
10 = (GMT-05:00) Eastern Time (US and Canada)
11 = (GMT-06:00) Central Time (US and Canada)
12 = (GMT-07:00) Mountain Time (US and Canada)
13 = (GMT-08:00) Pacific Time (US and Canada); Tijuana
14 = (GMT-09:00) Alaska
15 = (GMT-10:00) Hawaii
16 = (GMT-11:00) Midway Island, Samoa
17 = (GMT+12:00) Auckland, Wellington
18 = (GMT+10:00) Brisbane
19 = (GMT+09:30) Adelaide
20 = (GMT+09:00) Osaka, Sapporo, Tokyo
21 = (GMT+08:00) Kuala Lumpur, Singapore
22 = (GMT+07:00) Bangkok, Hanoi, Jakarta
23 = (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi
24 = (GMT+04:00) Abu Dhabi, Muscat
25 = (GMT+03:30) Tehran
26 = (GMT+03:00) Baghdad
27 = (GMT+02:00) Jerusalem
28 = (GMT-03:30) Newfoundland
29 = (GMT-01:00) Azores
31 = (GMT) Casablanca, Monrovia
32 = (GMT-03:00) Buenos Aires, Georgetown
33 = (GMT-04:00) Caracas, La Paz
34 = (GMT-05:00) Indiana (East)
35 = (GMT-05:00) Bogota, Lima, Quito
36 = (GMT-06:00) Saskatchewan
37 = (GMT-06:00) Guadalajara, Mexico City, Monterrey
38 = (GMT-07:00) Arizona
39 = (GMT-12:00) International Date Line West
40 = (GMT+12:00) Fiji Is., Kamchatka, Marshall Is.
41 = (GMT+11:00) Magadan, Solomon Is., New Caledonia
42 = (GMT+10:00) Hobart
43 = (GMT+10:00) Guam, Port Moresby
44 = (GMT+09:30) Darwin
45 = (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi
46 = (GMT+06:00) Almaty, Novosibirsk
47 = (GMT+05:00) Islamabad, Karachi, Tashkent
48 = (GMT+04:30) Kabul
49 = (GMT+02:00) Cairo
50 = (GMT+02:00) Harare, Pretoria
51 = (GMT+03:00) Moscow, St. Petersburg, Volgograd
53 = (GMT-01:00) Cape Verde Is.
54 = (GMT+04:00) Baku, Tbilisi, Yerevan
55 = (GMT-06:00) Central America
56 = (GMT+03:00) Nairobi
57 = (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb
59 = (GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius
60 = (GMT-03:00) Greenland
61 = (GMT+06:30) Rangoon
62 = (GMT+05:45) Kathmandu
63 = (GMT+08:00) Irkutsk, Ulaan Bataar
64 = (GMT+07:00) Krasnoyarsk
65 = (GMT-04:00) Santiago
66 = (GMT+06:00) Sri Jayawardenepura
67 = (GMT+13:00) Nuku''alofa
68 = (GMT+10:00) Vladivostok
69 = (GMT+01:00) West Central Africa
70 = (GMT+09:00) Yakutsk
71 = (GMT+06:00) Astana, Dhaka
72 = (GMT+09:00) Seoul
73 = (GMT+08:00) Perth
74 = (GMT+03:00) Kuwait, Riyadh
75 = (GMT+08:00) Taipei
76 = (GMT+10:00) Canberra, Melbourne, Sydney
77 = (GMT-07:00) Chihuahua, La Paz, Mazatlan
Appendix 2: Relationships between providers, training and branches
Appendix 3: Countries and States/Provinces
CountryID iso2 Name
--------- ---- --------------------------------------------------
1 AF Afghanistan
2 AL Albania
3 AQ Antarctica
4 DZ Algeria
5 AS American Samoa
6 AD Andorra
7 AO Angola
8 AG Antigua and Barbuda
9 AZ Azerbaijan
10 AR Argentina
11 AU Australia
12 AT Austria
13 BS Bahamas
14 BH Bahrain
15 BD Bangladesh
16 AM Armenia
17 BB Barbados
18 BE Belgium
19 BM Bermuda
20 BT Bhutan
21 BO Bolivia
22 BA Bosnia and Herzegovina
23 BW Botswana
24 BV Bouvet Island
25 BR Brazil
26 BZ Belize
27 IO British Indian Ocean Territory
28 SB Solomon Islands
29 VG British Virgin Islands
30 BN Brunei Darussalam
31 BG Bulgaria
32 MM Myanmar
33 BI Burundi
34 BY Belarus
35 KH Cambodia
36 CM Cameroon
37 CA Canada
38 CV Cape Verde
39 KY Cayman Islands
40 CF Central African Republic
41 LK Sri Lanka
42 TD Chad
43 CL Chile
44 CN China
45 TW Taiwan
46 CX Christmas Island
47 CC Cocos (Keeling) Islands
48 CO Colombia
49 KM Comoros
51 CG Republic of the Congo
52 CD Democratic Republic of the Congo
53 CK Cook Islands
54 CR Costa Rica
55 HR Croatia
56 CU Cuba
57 CY Cyprus
58 CZ Czech Republic
59 BJ Benin
60 DK Denmark
61 DM Dominica
62 DO Dominican Republic
63 EC Ecuador
64 SV El Salvador
65 GQ Equatorial Guinea
66 ET Ethiopia
67 ER Eritrea
68 EE Estonia
69 FO Faroe Islands
70 FK Falkland Islands (Malvinas)
71 GS South Georgia and the South Sandwich Islands
72 FJ Fiji
73 FI Finland
74 AX Åland Islands
75 FR France
78 TF French Southern Territories
79 DJ Djibouti
80 GA Gabon
81 GE Georgia
82 GM Gambia
83 PS Occupied Palestinian Territory
84 DE Germany
85 GH Ghana
86 GI Gibraltar
87 KI Kiribati
88 GR Greece
89 GL Greenland
90 GD Grenada
92 GU Guam
93 GT Guatemala
94 GN Guinea
95 GY Guyana
96 HT Haiti
97 HM Heard Island and McDonald Islands
98 VA Holy See (Vatican City State)
99 HN Honduras
100 HK Hong Kong
101 HU Hungary
102 IS Iceland
103 IN India
104 ID Indonesia
105 IR Islamic Republic of Iran
106 IQ Iraq
107 IE Ireland
108 IL Israel
109 IT Italy
110 CI Côte d'Ivoire
111 JM Jamaica
112 JP Japan
113 KZ Kazakhstan
114 JO Jordan
115 KE Kenya
116 KP Democratic People's Republic of Korea
117 KR Republic of Korea
118 KW Kuwait
119 KG Kyrgyzstan
120 LA Lao People's Democratic Republic
121 LB Lebanon
122 LS Lesotho
123 LV Latvia
124 LR Liberia
125 LY Libyan Arab Jamahiriya
126 LI Liechtenstein
127 LT Lithuania
128 LU Luxembourg
129 MO Macao
130 MG Madagascar
131 MW Malawi
132 MY Malaysia
133 MV Maldives
134 ML Mali
135 MT Malta
137 MR Mauritania
138 MU Mauritius
139 MX Mexico
140 MC Monaco
141 MN Mongolia
142 MD Republic of Moldova
143 MS Montserrat
144 MA Morocco
145 MZ Mozambique
146 OM Oman
147 NA Namibia
148 NR Nauru
149 NP Nepal
150 NL Netherlands
151 AN Netherlands Antilles
152 AW Aruba
154 VU Vanuatu
155 NZ New Zealand
156 NI Nicaragua
157 NE Niger
158 NG Nigeria
159 NU Niue
160 NF Norfolk Island
161 NO Norway
162 MP Northern Mariana Islands
163 UM United States Minor Outlying Islands
164 FM Federated States of Micronesia
165 MH Marshall Islands
166 PW Palau
167 PK Pakistan
168 PA Panama
169 PG Papua New Guinea
170 PY Paraguay
171 PE Peru
172 PH Philippines
173 PN Pitcairn
174 PL Poland
175 PT Portugal
176 GW Guinea-Bissau
177 TL Timor-Leste
178 PR Puerto Rico
179 QA Qatar
181 RO Romania
182 RU Russian Federation
183 RW Rwanda
184 SH Saint Helena
185 KN Saint Kitts and Nevis
186 AI Anguilla
187 LC Saint Lucia
189 VC Saint Vincent and the Grenadines
190 SM San Marino
191 ST Sao Tome and Principe
192 SA Saudi Arabia
193 SN Senegal
194 SC Seychelles
195 SL Sierra Leone
196 SG Singapore
197 SK Slovakia
198 VN Viet Nam
199 SI Slovenia
200 SO Somalia
201 ZA South Africa
202 ZW Zimbabwe
203 ES Spain
204 EH Western Sahara
205 SD Sudan
206 SR Suriname
207 SJ Svalbard and Jan Mayen
208 SZ Swaziland
209 SE Sweden
210 CH Switzerland
211 SY Syrian Arab Republic
212 TJ Tajikistan
213 TH Thailand
214 TG Togo
215 TK Tokelau
216 TO Tonga
217 TT Trinidad and Tobago
218 AE United Arab Emirates
219 TN Tunisia
220 TR Turkey
221 TM Turkmenistan
222 TC Turks and Caicos Islands
223 TV Tuvalu
224 UG Uganda
225 UA Ukraine
226 MK The Former Yugoslav Republic of Macedonia
227 EG Egypt
228 GB United Kingdom
229 IM Isle of Man
230 TZ United Republic of Tanzania
231 US United States
232 VI United States Virgin Islands
233 BF Burkina Faso
234 UY Uruguay
235 UZ Uzbekistan
236 VE Venezuela
238 WS Samoa
239 YE Yemen
240 CS Serbia and Montenegro
241 ZM Zambia
StateID CountryID iso2 Name
------- --------- ---- ------------------------------------------------------------------
1 37 AB Alberta
2 37 BC British Columbia
3 37 MB Manitoba
4 37 NB New Brunswick
5 37 NL Newfoundland and Labrador
6 37 NT Northwest Territories
7 37 NS Nova Scotia
8 37 NU Nunavut
9 37 ON Ontario
10 37 PE Prince Edward Island
11 37 QC Quebec
12 37 SK Saskatchewan
13 37 YT Yukon
36 231 AL Alabama
37 231 AK Alaska
38 231 AZ Arizona
39 231 AR Arkansas
40 231 CA California
41 231 CO Colorado
42 231 CT Connecticut
43 231 DE Delaware
44 231 DC District of Columbia
45 231 FL Florida
46 231 GA Georgia
47 231 HI Hawaii
48 231 ID Idaho
49 231 IL Illinois
50 231 IN Indiana
51 231 IA Iowa
52 231 KS Kansas
53 231 KY Kentucky
54 231 LA Louisiana
55 231 ME Maine
56 231 MD Maryland
57 231 MA Massachusetts
58 231 MI Michigan
59 231 MN Minnesota
60 231 MS Mississippi
61 231 MO Missouri
62 231 MT Montana
63 231 NE Nebraska
64 231 NV Nevada
65 231 NH New Hampshire
66 231 NJ New Jersey
67 231 NM New Mexico
68 231 NY New York
69 231 NC North Carolina
70 231 ND North Dakota
71 231 OH Ohio
72 231 OK Oklahoma
73 231 OR Oregon
74 231 PA Pennsylvania
75 231 RI Rhode Island
76 231 SC South Carolina
77 231 SD South Dakota
78 231 TN Tennessee
79 231 TX Texas
80 231 UT Utah
81 231 VT Vermont
82 231 VA Virginia
83 231 WA Washington
84 231 WV West Virginia
85 231 WI Wisconsin
86 231 WY Wyoming
87 75 GES Grand Est
88 75 NAQ Nouvelle-Aquitaine
89 75 ARA Auvergne-Rhône-Alpes
90 75 BFC Bourgogne-Franche-Comté
91 75 BRE Brittany
92 75 CVL Centre-Val de Loire
93 75 20R Corsica
94 75 IDF Île-de-France
95 75 OCC Occitanie
96 75 HDF Hauts-de-France
97 75 NOR Normandy
98 75 PDL Pays de la Loire
99 75 PAC Provence-Alpes-Côte d'Azur
100 75 GP Guadeloupe
101 75 MQ Martinique
102 75 GF French Guiana
103 75 RE Réunion
104 75 YT Mayotte
105 75 NC New Caledonia
106 75 MF Saint Martin
107 75 PM Saint Pierre and Miquelon
108 75 BL Saint Barthélemy
109 75 WF Wallis and Futuna
110 75 PF French Polynesia