Countries – ISO country code mappings for Stratfor
SRC_ID / COUNTRY_CODE / COUNTRY_NAME / ISO_COUNTRY_CODE0224 / 1 / Afghanistan / AF
0224 / 2 / Albania / AL
0224 / 3 / Algeria / DZ
0224 / 178 / Andorra / AD
0224 / 4 / Angola / AO
0224 / 184 / Anguilla / AI
0224 / 185 / Antigua and Barbuda / AG
0224 / 5 / Argentina / AR
0224 / 6 / Armenia / AM
0224 / 208 / Aruba / AW
0224 / 7 / Australia / AU
0224 / 8 / Austria / AT
0224 / 9 / Azerbaijan / AZ
0224 / 186 / Bahamas, The / BS
0224 / 10 / Bahrain / BH
0224 / 11 / Bangladesh / BD
0224 / 187 / Barbados / BB
0224 / 12 / Belarus / BY
0224 / 13 / Belgium / BE
0224 / 204 / Belize / BZ
0224 / 144 / Benin / BJ
0224 / 164 / Bhutan / BT
0224 / 205 / Bolivia / BO
0224 / 14 / Bosnia-Herzegovina / BA
0224 / 15 / Botswana / BW
0224 / 16 / Brazil / BR
0224 / 165 / Brunei Darussalam / BN
0224 / 17 / Bulgaria / BG
0224 / 145 / Burkina Faso / BF
0224 / 18 / Burundi / BI
0224 / 19 / Cambodia / KH
0224 / 146 / Cameroon / CM
0224 / 20 / Canada / CA
0224 / 147 / Cape Verde / CV
0224 / 188 / Cayman Islands / KY
0224 / 21 / Central African Republic / CF
0224 / 22 / Chad / TD
0224 / 23 / Chile / CL
0224 / 24 / China / CN
0224 / 25 / Colombia / CO
0224 / 148 / Comoros / KM
0224 / 33 / Congo, Democratic Republic of the / CD
0224 / 26 / Congo, Republic of the / CG
0224 / 189 / Costa Rica / CR
0224 / 27 / Cote d'lvoire / CI
0224 / 28 / Croatia / HR
0224 / 29 / Cuba / CU
0224 / 30 / Cyprus / CY
0224 / 31 / Czech Republic / CZ
0224 / 32 / Denmark / DK
0224 / 149 / Djibouti / DJ
0224 / 190 / Dominica / DM
0224 / 34 / Dominican Republic / DO
0224 / 35 / East Timor / TP
0224 / 36 / Ecuador / EC
0224 / 37 / Egypt / EG
0224 / 38 / El Salvador / SV
0224 / 150 / Equatorial Guinea / GQ
0224 / 39 / Eritrea / ER
0224 / 40 / Estonia / EE
0224 / 41 / Ethiopia / ET
0224 / 191 / Falkland Islands / FK
0224 / 42 / Fiji / FJ
0224 / 43 / Finland / FI
0224 / 44 / France / FR
0224 / 45 / Gabon / GA
0224 / 46 / Gambia, The / GM
0224 / 47 / Georgia / GE
0224 / 48 / Germany / DE
0224 / 49 / Ghana / GH
0224 / 50 / Greece / GR
0224 / 192 / Grenada / GD
0224 / 193 / Guatemala / GT
0224 / 151 / Guinea / GN
0224 / 51 / Guinea-Bissau / GW
0224 / 194 / Guyana / GY
0224 / 52 / Haiti / HT
0224 / 179 / Holy See (Vatican City) / VA
0224 / 195 / Honduras / HN
0224 / 53 / Hong Kong / HK
0224 / 54 / Hungary / HU
0224 / 55 / Iceland / IS
0224 / 56 / India / IN
0224 / 57 / Indonesia / ID
0224 / 58 / Iran / IR
0224 / 59 / Iraq / IQ
0224 / 60 / Ireland / IE
0224 / 61 / Israel / IL
0224 / 62 / Italy / IT
0224 / 196 / Jamaica / JM
0224 / 64 / Japan / JP
0224 / 63 / Jordan / JO
0224 / 65 / Kazakhstan / KZ
0224 / 66 / Kenya / KE
0224 / 166 / Kiribati / KI
0224 / 67 / Kuwait / KW
0224 / 68 / Kyrgyzstan / KG
0224 / 69 / Laos / LA
0224 / 70 / Latvia / LV
0224 / 71 / Lebanon / LB
0224 / 152 / Lesotho / LS
0224 / 72 / Liberia / LR
0224 / 73 / Libya / LY
0224 / 180 / Liechtenstein / LI
0224 / 74 / Lithuania / LT
0224 / 181 / Luxembourg / LU
0224 / 75 / Macedonia / MK
0224 / 154 / Madagascar / MG
0224 / 155 / Malawi / MW
0224 / 76 / Malaysia / MY
0224 / 206 / Maldives / MV
0224 / 78 / Mali / ML
0224 / 156 / Malta / MT
0224 / 167 / Marshall Islands / MH
0224 / 157 / Mauritania / MR
0224 / 158 / Mauritius / MU
0224 / 79 / Mexico / MX
0224 / 168 / Micronesia, Federated States of / FM
0224 / 80 / Moldova / MD
0224 / 182 / Monaco / MC
0224 / 81 / Mongolia / MN
0224 / 210 / Montserrat / MS
0224 / 82 / Morocco / MA
0224 / 83 / Mozambique / MZ
0224 / 84 / Myanmar / MM
0224 / 85 / Namibia / NA
0224 / 169 / Nauru / NR
0224 / 86 / Nepal / NP
0224 / 209 / Netherland Antilles / AN
0224 / 88 / New Zealand / NZ
0224 / 89 / Nicaragua / NI
0224 / 90 / Niger / NE
0224 / 91 / Nigeria / NG
0224 / 92 / North Korea / KP
0224 / 93 / Norway / NO
0224 / 94 / Oman / OM
0224 / 95 / Pakistan / PK
0224 / 170 / Palau / PW
0224 / 96 / Palestinian National Authority / PS
0224 / 197 / Panama / PA
0224 / 97 / Papua New Guinea / PG
0224 / 141 / Paraguay / PY
0224 / 98 / Peru / PE
0224 / 99 / Philippines / PH
0224 / 100 / Poland / PL
0224 / 101 / Portugal / PT
0224 / 102 / Puerto Rico / PR
0224 / 103 / Qatar / QA
0224 / 104 / Romania / RO
0224 / 105 / Russia / RU
0224 / 106 / Rwanda / RW
0224 / 211 / Saharawi Arab Democratic Republic / Z1
0224 / 198 / Saint Kitts and Nevis / KN
0224 / 199 / Saint Lucia / LC
0224 / 200 / Saint Vincent and the Grenadines / VC
0224 / 172 / Samoa / WS
0224 / 183 / San Marino / SM
0224 / 159 / Sao Tome and Principe / ST
0224 / 107 / Saudi Arabia / SA
0224 / 160 / Senegal / SN
0224 / 138 / Serbia and Montenegro / YU
0224 / 161 / Seychelles / SC
0224 / 162 / Sierra Leone / SL
0224 / 108 / Singapore / SG
0224 / 109 / Slovakia / SK
0224 / 110 / Slovenia / SI
0224 / 173 / Solomon Islands / SB
0224 / 111 / Somalia / SO
0224 / 112 / South Africa / ZA
0224 / 113 / South Korea / KR
0224 / 114 / Spain / ES
0224 / 115 / Sri Lanka / LK
0224 / 116 / Sudan / SD
0224 / 201 / Suriname / SR
0224 / 207 / Swaziland / SZ
0224 / 117 / Sweden / SE
0224 / 118 / Switzerland / CH
0224 / 119 / Syria / SY
0224 / 120 / Taiwan / TW
0224 / 121 / Tajikistan / TJ
0224 / 122 / Tanzania / TZ
0224 / 123 / Thailand / TH
0224 / 87 / The Netherlands / NL
0224 / 163 / Togo / TG
0224 / 175 / Tonga / TO
0224 / 202 / Trinidad and Tobago / TT
0224 / 124 / Tunisia / TN
0224 / 125 / Turkey / TR
0224 / 203 / Turkish Republic of Northern Cyprus / TC
0224 / 126 / Turkmenistan / TM
0224 / 176 / Tuvalu / TV
0224 / 127 / Uganda / UG
0224 / 128 / Ukraine / UA
0224 / 129 / United Arab Emirates / AE
0224 / 130 / United Kingdom / GB
0224 / 131 / United States / US
0224 / 132 / Uruguay / UY
0224 / 133 / Uzbekistan / UZ
0224 / 177 / Vanuatu / VU
0224 / 134 / Venezuela / VE
0224 / 135 / Vietnam / VN
0224 / 136 / Western Sahara / EH
0224 / 137 / Yemen / YE
0224 / 139 / Zambia / ZM
0224 / 140 / Zimbabwe / ZW
Regions – Stratfor defined regions
SRC_ID / REGION_CODE / REGION_NAME0224 / 1 / Africa
0224 / 2 / East Asia and Oceania
0224 / 3 / Former Soviet Union (FSU)
0224 / 4 / Europe
0224 / 5 / Latin America
0224 / 6 / South Asia
0224 / 7 / Middle East
0224 / 8 / North America
0224 / 9 / Global
Country Grouping – Strafor country groupings
SRC_ID / GROUP_ID / GROUP_NAME0224 / 1 / Andean Common Market (AnCom)
0224 / 2 / Association of Caribbean States
0224 / 3 / Carribean Community
0224 / 4 / Central American Common Market (CACM)
0224 / 5 / European Union
0224 / 6 / European Union Prospects
0224 / 7 / Group of Three (G-3)
0224 / 8 / Latin American Integration Association (ALADI)
0224 / 9 / Mercosur
0224 / 10 / North American Free Trade Agreement (NAFTA)
0224 / 11 / Organization for Economic Cooperation and Development
0224 / 12 / Paris Club
0224 / 13 / Rio Group
0224 / 17 / Free Trade Area of the Americas (FTAA)
0224 / 18 / African Union
0224 / 19 / Arab League
0224 / 20 / Commonwealth of Independent States
0224 / 14 / NATO
0224 / 15 / Association of Southeast Asian Nations (ASEAN)
0224 / 16 / Asian-Pacific Economic Cooperation (APEC)
Media Partners – Stratfor media partners
MALL_ID / MP_ID / DESCRIPTION0224 / 1 / Economist Intelligence Unit
0224 / 2 / Fox News
Sources – Strafor subscription levels
SRC_ID / SOURCE_CODE / NAME0224 / BZ / Biz
0224 / CO / Com
0224 / IN / Info
0224 / TR / Terrorism
Article Staging table – converted data is staged into this table. From here, all business rules are applied to publish the document, create the site components, and maintain the publishing queue for edits, deletes, and publishing.
SEQ / SRC / SOURCECODE / HEADLINE / CATEGORY / PUB_DATE / TRANS_ID / RANK / SUMMARY / COUNTRY_GROUP_ID / COUNTRY_CODE / KEYWORDS / REGION_CODE / RELATED_TRANS_ID / USER_ID / INSERT_DATE / STATUS35003 / 0224 / BZ / Albanian Instability Threatens NATO's Kosovo Mission / GAN / 2/4/2003 10:48:26 AM / 100002-A / 2 / Summary Albanian media has reported that the head of the Albanian intelligence service, Fatos Klosi, secretly met with Prime Minister Ilir Meta to brief him on the possibility of armed protests against his government. / |2| / 4 / 2 / 2/4/2003 10:48:26 AM / 1