U.S. OFAC Sanctions Data
Data from the U.S. Treasury’s OFAC list, detailing individuals and organizations under U.S. sanctions.
| Engineered Field Names | Original Field Names | Data Type | Data Definition | Original/Engineered |
|---|---|---|---|---|
| uid | Uid | Numeric (Integer) | Unique identifier for the sanctioned individual or entity | Original |
| last_name | lastname | Text (String) | Last name (surname) of the sanctioned individual | Original |
| first_name | firstname | Text (String) | First name of the sanctioned individual | Original |
| type | sdntype | Text (String) | Type of SDN entry (e.g., Individual, Entity, Vessel, Aircraft) | Original |
| remarks | remarks | Text (String) | Additional comments or relationship links to other SDN entries | Original |
| program | programs_program | Text (String) | Sanctions program under which the individual/entity is listed | Original |
| aka_first | akas_firstname | Text (String) | First name under an alias or alternate spelling | Original |
| aka_last | akas_lastName | Text (String) | Last name under an alias or alternate spelling | Original |
| aka_uid | akas_Uid | Text (String) | Unique identifier for the alias name | Original |
| aka_type | akas_type | Text (String) | Type of alias (e.g., a.k.a., f.k.a.) | Original |
| aka_cat | akas_category | Text (String) | Confidence level of the alias (e.g., strong, weak) | Original |
| dob_uid | date_of_birth_uid | Numeric (Integer) | Unique identifier for date of birth entry | Original |
| dob_item | date_of_birth_dateOfBirthItem | Date | Date of birth (may include day, month, and year) | Original |
| dob_main | date_of_birth_mainentry | Boolean | Indicates whether the date of birth is the main or primary entry | Original |
| pob_place | place_of_birth_placeOfBirth | Text (String) | Place (usually city and/or country) of birth | Original |
| pob_uid | place_of_birth_uid | Numeric (Integer) | Unique identifier for place of birth record | Original |
| pob_main | place_of_birth_mainentry | Boolean | Whether the place of birth is the main entry | Original |
| publish_date | public_info_publish_date | Date | The date the record was last published or updated | Original |
| record_count | public_info_record_count | Numeric (Integer) | Total number of records in the dataset at the time of publishing | Original |
| addr_uid | addresses_Uid | Numeric (Integer) | Unique identifier for address entry | Original |
| addr_prov | addresses_Province | Text (String) | Province or state of the address | Original |
| addr_postal | addresses_postalCode | String (Numeric) | Postal or ZIP code | Original |
| addr_1 | addresses_address1 | Text (String) | Primary address line | Original |
| addr_city | addresses_city | Text (String) | City name | Original |
| addr_2 | addresses_address2 | Text (String) | Secondary address line | Original |
| addr_3 | addresses_address3 | Text (String) | Tertiary address line | Original |
| addr_country | addresses_country | Text (String) | Country of the address | Original |
| identity_Uid | identity_Uid | Numeric (Integer) | Unique identifier for identity document record | Original |
| identity_issuedate | identity_issuedate | Date | Date identity document was issued | Original |
| identity_expirationdate | identity_expirationdate | Date | Expiration date of identity document | Original |
| identity_idCountry | identity_idCountry | Text (String) | Country where the ID was issued | Original |
| id_type | identity_idtype | Text (String) | Type of identity document | Original |
| id_number | identity_id_number | String | ID document number or additional info | Original |
| nat_uid | national_Uid | Numeric (Integer) | Unique identifier for nationality record | Original |
| nat_country | national_country | Text (String) | Nationality of the person/entity | Original |
| nat_main | national_mainEntry | Boolean | Indicates if this nationality is the primary one | Original |
| citizenship_Uid | citizenship_Uid | Numeric (Integer) | Unique identifier for citizenship record | Original |
| citizenship_country | citizenship_country | Text (String) | Country of citizenship | Original |
| citizenship_mainEntry | citizenship_mainEntry | Boolean | Whether this citizenship is the main or primary entry | Original |
| sanctions_origin | sanctions_origin | Text (String) | Source of the sanctions data | Original |
Fields Specific to OFAC SDN | ||||
| vesselinfo_vesselType | vesselinfo_vesselType | Text (String) | Type of vessel or ship classification (e.g., Tug, Tanker, Cargo) | Original |
| vesselinfo_vesselFlag | vesselinfo_vesselFlag | Text (String) | Country whose flag the vessel is registered under (flag state) | Original |
| vesselinfo_callSign | vesselinfo_callSign | Text (String) | Unique alphanumeric identifier used in radio communications for the vessel | Original |
| vesselinfo_vesselOwner | vesselinfo_vesselOwner | Text (String) | Name of the legal owner of the vessel | Original |
| vesselinfo_grossRegisteredTonnage | vesselinfo_grossRegisteredTonnage | Numeric (Integer) | Gross registered tonnage (GRT) – a measure of the overall internal volume of the vessel | Original |