Information on List File Formats and Downloads

Information on List File Formats and Downloads

1031

Answer

Throughout OFAC’s sanctions list data products, such as the XML file, each entry is assigned a unique identification number (UID) as a means to help make sorting and filtering through information easier.  

In OFAC’s files, a UID is a numeric string that is associated with a single entry within a given system. OFAC's sanctions list data products are designed to be integrated into a relational database. As such, UIDs (which are typically considered “primary” or “foreign” keys) are assigned to all primary entries on the sanctions list(s) and are used to link the primary entry to its addresses, aliases, and other identifiers.

Occasionally, OFAC may only provide a list of UIDs in a Recent Actions notice when a clerical update is made to the sanctions list(s).  The purpose of such is to underscore the fact that these types of actions are solely administrative and that there have been no new entries added to OFAC's list(s).

For more information regarding the data specification and formatting of OFAC's files or on the use of UIDs within OFAC's files, please visit the following links: 


Date Released
April 29, 2022

105

Answer

OFAC has rigorous quality control procedures in place to ensure that all SDN data are current and accurate when they are released (including all of its human-readable list formats [in PDF and text]). All of the SDN information is downloaded and checked by OFAC personnel using the same interface that any member of the public might employ. A number of local issues can impact a user’s ability to download current information; many of these issues are associated with caching done by a user’s browser or by the firewall/security systems that protect a specific enterprise. OFAC can only offer technical support when it comes to OFAC provided data and OFAC managed systems (like the OFAC website or OFAC FTP servers). If you continue to have difficulty downloading the latest SDN information, OFAC recommends that you contact your internal IS/IT support and request their assistance in resolving a caching issue.

Date Released
May 8, 2018

22

Answer

OFAC has long maintained such a list. The file is available on OFAC's SDN Page under the link "SDN List Sorted by Country." The file is also contained within the SDALL.ZIP archive and is called ctrylst.txt. It is important to understand that many SDN individuals and entities may operate in countries other than those in which they are based. The relevant regulations prohibit transactions with and/or block the property of SDNs wherever they are located

Date Released
October 8, 2013

90

Answer

No. OFAC records changes to the SDN and other sanctions lists in human-readable form in the recent actions section of its website. An archive of changes files found on this page. Database administrators interested in refreshing their databases with new SDN and other sanctions list data should use the comprehensive data files available on OFAC's website and completely refresh the list.

Date Released
October 8, 2013

89

Answer

The SDN list is comprehensive. Database administrators can overwrite any old data in their systems with the latest versions of the list's data files, thus ensuring that their database is current

Date Released
September 10, 2002

88

Answer

OFAC cannot give specific advice on how to design an automated system for downloading its sanctions list data. Many institutions solve this problem by setting up a scheduled download of the SDN List and other sanctions lists. These firms conduct their own risk assessments and decide how often they need to download the lists in order to comply with U.S. law. Institutions should be aware that OFAC is updating its sanctions lists at an ever increasing pace. If an institution has set up a periodic download schedule, the institution should occasionally reevaluate that schedule to ensure that it remains an effective risk mitigation technique

Date Released
January 30, 2015

87

Answer

The FTP site is run by OFAC. Please contact OFAC's support hotline at 1-800-540-6322 for technical support.

Date Released
August 6, 2014

84

Answer

Yes. OFAC maintains many of its sanctions list files on an FTP server.

This server can be accessed at: ftp://ofacftp.treas.gov.

The server will accept an anonymous login. OFAC's data is stored in the directories listed below.  OFAC does not currently support connections to this server via SFTP.

/fac_sdn - SDN human-readable lists, legacy zip archive (XML and delimited files), and the advanced zip archive (advanced XML file)

/fac_delim - SDN data files (advanced XML file, legacy XML file, legacy delimited files) in un archived format

/ssi_list - All Sectoral Sanctions List files

/fse_list - All Foreign Sanctions Evaders List files

/ns_plc - All Non-SDN Palestinian Legislative Council Lists files

/consolidated_list - All Consolidated Non-SDN List data files

Date Released
April 13, 2017

81

Answer

The delimiter varies based upon the file type. Files that end in .DEL have an @ (at) symbol as the delimiter. Files that end in .CSV have a comma delimiter. Files that end in .FF have a fixed width delimiter. Files that end in .PIP use the | (pipe) symbol as a delimiter.

Date Released
June 14, 2007