Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save cosmin-marginean/7fec8b4425beb39ee85f261275ccb8d1 to your computer and use it in GitHub Desktop.
Save cosmin-marginean/7fec8b4425beb39ee85f261275ccb8d1 to your computer and use it in GitHub Desktop.
Panama Papers - Jurisdiction geo names code fixes
# Most of the Geo names in the Panama Papers are using the right codes but some
# are inconsistent or plain incorrect. The problems are usually:
# * Mostly ISO-3166 alpha3 for country codes, but some sporadic alpha2 codes as well. We're
# fixing this by always reverting to the alpha3 code.
# * Some incorrect codes (STLU, MARSH, WYO).
# * It's not clear if some codes (DUBAI, LABUA) are actual jurisdictions. We are using the
# "parent" country for these but you might want to adjust them for your use case.
# This translation table addresses all these issues.
# Countries
ANG = AIA
RAK = ARE
IOM = IMN
CAYMN = CYM
STLU = LCA
PMA = PAN
SEY = SYC
SAM = WSM
BVI = VGB
BAH = BHS
UK = GBR
HK = HKG
NIUE = NIU
UY = URY
JSY = JEY
COOK = COK
MARSH = MHL
MAURI = MUS
MALAY = MYS
NETH = NLD
BRUN = BRN
LIBER = LBR
VANU = VUT
BERMU = BMU
THAIL = THA
IRELD = IRL
CHINA = CHN
# US States
WYO = WY
NEV = NV
# Others
DUBAI = ARE
LABUA = MYS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment