|
SECO Target Data |
| individual.identity.day-month-year.calendar | calendar_type | Text (String) | The calendar system used for the date (e.g., Gregorian, Hijri). | Original |
| individual.identity.day-month-year.day | birth_date | Numeric (Float) | Day component of a date (e.g., date of birth). | Original |
| individual.identity.day-month-year.month | birth_date | Numeric (Float) | Month component of a date (e.g., date of birth). | Original |
| individual.identity.day-month-year.quality | date_quality | Text (String) | Data quality indicator for the date provided. | Original |
| individual.identity.day-month-year.ssid | date_ssid | Numeric (Float) | Unique system-specific identifier for the date block. | Original |
| individual.identity.day-month-year.year | birth_date | Numeric (Float) | Year component of a date (e.g., year of birth). | Original |
| individual.identity.main | identity_main | Boolean | Boolean or flag to indicate if this identity is the primary one. | Original |
| individual.identity.name.lang | name_lang | Text (String) | Language of the name provided (e.g., en for English, ar for Arabic). | Original |
| individual.identity.name.name-part.name-part-type | namepart_type | Text (String) | Type of the name part (e.g., 'given', 'family', or 'alias'). | Original |
| individual.identity.name.name-part.order | name_order | Numeric (Float) | The order of the name part in the full name. | Original |
| individual.identity.name.name-part.value | name_val | Text (String) | The value/content of the name part. | Original |
| individual.identity.name.name-type | name_type | Text (String) | Type of name (e.g., legal name, alias, former name). | Original |
| individual.identity.name.quality | name_quality | Text (String) | Data quality level for the name entry. | Original |
| individual.identity.name.ssid | name_ssid | Numeric (Float) | Unique identifier for the name block. | Original |
| individual.identity.ssid | identity_ssid | Numeric (Float) | Unique identifier for this identity entry. | Original |
| individual.justification.#text | justification | Text (String) | Description of the reason for sanctions (free text). | Original |
| individual.justification.ssid | justification_ssid | Numeric (Float) | Unique ID for the justification entry. | Original |
| individual.other-information.#text | other_info | Text (String) | Additional free-text information about the individual. | Original |
| individual.other-information.ssid | other_ssid | Numeric (Float) | Unique ID for the additional information block. | Original |
| sanctions-set-id | sanction_id | Numeric (Integer) | ID of the sanctions set in general. | Original |
| ssid | target_ssid | Numeric (Integer) | System-specific unique identifier (SSID). | Original |
| -- | mod_flag | Text (String) | This is a flag used to denote the rows containing either the original data or modified data. It takes two values; "original" (for when the info related to the sanctioned individual or organization was not modified), "modified" (for when the info related to the sanctioned individual or organization was updated/modified) | Engineered |
| -- | mod_removed | Text (String) | This column combines all the "modification.removed" fields into just one column separated by a semi-colon to avoid have too many unnecessary columns | Engineered |
| -- | modrem_type | Text (String) | This column shows the specific field names of the columns merged together in "mod_removed". | Engineered |
SECO Program Data |
| ssid | ssid_program | Numeric (Integer) | Sanction Set Identifier – unique ID for the record | Original |
| version-date | version_date | Date (MM/DD/YYYY) | Date when this version of the record was released | Original |
| predecessor-version-date | predver_date | Date (MM/DD/YYYY) | Date of the previous version of the record | Original |
| program-key_0_#text | program_key | Text (String) | Value of the program key in English | Original |
| program-name_0_#text | program_name | String (may contain ordinance or law references) | Program name in English | Original |
| sanctions-set_0_ssid | sanctions_ssid | Numeric (Integer) | Sanction Set Identifier for English version | Original |
| sanctions-set_0_#text | sanctions_set | Text (String) | Sanctions description in English | Original |
| origin | origin | Text (String) | Originating authority or region (e.g. EU) | Original |
SECO Place Data |
| ssid | ssid | Numeric (Integer) | Unique Sanction Set Identifier used to group sanctions records | Original |
| iso-code | iso-code | Text (String) | ISO 3166-1 alpha-2 country code representing the country (e.g. "BA" for Bosnia and Herzegovina) | Original |
| country-name | country-name | Text (String) | Full name of the country where the entity or location is registered or based | Original |
| location | location | Text (String) | The primary name of the city, town, or locality associated with the sanctioned entity | Original |
