Parsing OFAC SDN List

OFAC maintains its SDN list in different formats

.ff
.txt
.csv.
.del
.pip

The data specs for all of the above are here

The xml format is much easier to parse. Data like :

Date of birth
Id type and number (For ex : passport #)
Place of Birth
Citizenship

which are buried in comments fields for .ff file have their own tags in xml format. This makes the extraction of these fields much easier and effective.

Also, AKAs and Addresses have their own embedded tags within the master SDN entity. This alleviates the whole ordeal of joining the alternate.ff and address.ff files with the master SDN.ff file to get the whole SDN file

The xsd is here

US Treasury has lots of technical details around the SDN list

This entry was posted on 23 Jan 2008 at 23:26 and is filed under AML. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.