International Trade Administration Export Screened Entities Index

Snowflake table name : CYBERSYN.INTERNATIONAL_TRADE_ADMINISTRATION_EXPORT_SCREENED_ENTITIES_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
EXPORT_RESTRICTED_ENTITY_ID	Unique identifier provided by the International Trade Administration (ITA) for the entity listed with a prefix associated with the source.	VARCHAR	SDN-36054
EXPORT_RESTRICTED_ENTITY_NUMBER	Unique identifier for the entity.	NUMBER	7893
EXPORT_RESTRICTED_ENTITY_NAME	The name of the individual, group, vessel, or entity on the list (e.g., Khokhlova, Olga Nikolayevna).	VARCHAR	Ryazantsev, Oleg Nikolayevich
EXPORT_RESTRICTED_ENTITY_TITLE	The title for an individual, group, vessel, or entity on the list (e.g., Member of the Federation Council of the Federal Assembly of the Russian Federation).	VARCHAR	Scientific Studies and Research Center Employee
EXPORT_RESTRICTED_ENTITY_TYPE	The type of entity that is listed (e.g., Vessel, Individual, Entity, Aircraft).	VARCHAR	Entity
START_DATE	The date when the listing came into effect.	DATE	2010-06-28
END_DATE	The date when the listing will no longer be valid.	DATE	2024-07-19
FEDERAL_REGISTER_NOTICE	The Federal Register citation indicating the law or policy under which the entity is listed.	VARCHAR	78 FR 75458
ALT_NAMES	Any known alternate names for the entity.	ARRAY	[ "RYAZANTSEV, Oleg Nikolaevich", "RYAZANCEV, Oleg N" ]
ADDRESSES	The physical addresses associated with the entity.	ARRAY	[]
CITIZENSHIPS	Citizenships of the listed individual.	ARRAY	[]
GEO_ID_COUNTRY	Unique geographic identifier for the country associated with the listing.	VARCHAR	country/IRN
DATES_OF_BIRTH	Birth dates of the listed individual(s), if available.	ARRAY	[]
IDS	Associated IDs with an individual or group (e.g., passport details).	ARRAY	[ { "country": "VE", "expiration_date": null, "iss...
NATIONALITIES	Nationality of the listed individual or entity's country of formation.	ARRAY	[ "IQ" ]
PLACES_OF_BIRTH	Place of birth of the listed individual(s), if available.	ARRAY	[]
PROGRAMS	Specific sanction or restriction program under which the individual, entity, or vessel is listed.	ARRAY	[]
STANDARD_ORDER	A general directive applied to transactions with the listed entity.	VARCHAR	Y
VESSEL_CALL_SIGN	The unique call sign assigned to a vessel for identification purposes, similar to a license plate number on a vehicle.	VARCHAR	N/A
VESSEL_GROSS_REGISTERED_TONNAGE	A measure of the overall internal volume of a vessel, with one gross registered tonnage unit representing 100 cubic feet of space.	VARCHAR	N/A
VESSEL_GROSS_TONNAGE	A more modern measurement of a ship's size that is calculated based on the volume of all enclosed spaces of a ship.	VARCHAR	N/A
SOURCE	Name of the source that identified and monitors this company, entity, or person.	VARCHAR	Specially Designated Nationals (SDN) - Treasury Department
SOURCE_INFORMATION_URL	URL for the source.	VARCHAR	https://home.treasury.gov/policy-issues/financial-sanctions/spec...
SOURCE_LIST_URL	URL for the source list or further information about the entry.	VARCHAR	https://www.treasury.gov/resource-center/sanctions/SDN-List/Page...
COMMENTS	Associated comments from the organization on the entity.	VARCHAR	ICTY indictee