optional-skills/research/osint-investigation/references/sources/ofac-sdn.md
The Office of Foreign Assets Control (OFAC) publishes the Specially Designated Nationals and Blocked Persons List (SDN). US persons are generally prohibited from dealing with individuals and entities on this list. Also published: non-SDN consolidated lists (BIS Denied Persons, FSE, etc.).
https://www.treasury.gov/ofac/downloads/sdn.xmlhttps://www.treasury.gov/ofac/downloads/sdn.csvhttps://www.treasury.gov/ofac/downloads/consolidated/consolidated.xmlKey fields emitted by fetch_ofac_sdn.py:
| Column | Type | Description |
|---|---|---|
entity_id | int | OFAC unique ID |
name | str | Primary name |
entity_type | str | individual / entity / vessel / aircraft |
program_list | str | Semicolon-separated sanctions programs (e.g. SDGT;IRAN) |
title | str | For individuals: title/role |
nationalities | str | Semicolon-separated country codes |
aka_list | str | Semicolon-separated "also known as" names |
addresses | str | Semicolon-separated known addresses |
dob | str | Date of birth (individuals) |
pob | str | Place of birth (individuals) |
remarks | str | OFAC's free-text remarks |
last_updated | str | YYYY-MM-DD (publication date) |
name (public companies sanctioned)name (sanctioned entity as federal contractor — should
be impossible but verify)name (offshore entities also sanctioned)Join key: normalized name. CRITICAL: must match against aka_list too.
Many sanctioned entities are caught only via aliases.
remarks contain critical context — read themPath: scripts/fetch_ofac_sdn.py
# Full snapshot
python3 SKILL_DIR/scripts/fetch_ofac_sdn.py --out data/ofac_sdn.csv
# Filter to specific program
python3 SKILL_DIR/scripts/fetch_ofac_sdn.py --program SDGT --out data/sdn_sdgt.csv
# Entities only (skip individuals, vessels, aircraft)
python3 SKILL_DIR/scripts/fetch_ofac_sdn.py --entity-type entity --out data/sdn_entities.csv