[DEPRECATED] Consolidated List Of Persons, Groups And Entities Subject To EU Financial Sanctions by European Commission Service for Foreign Policy Instruments (SPI) | Finance and Economics

About this Dataset

[DEPRECATED] Consolidated List Of Persons, Groups And Entities Subject To EU Financial Sanctions

In its policy, the European Union intervenes when necessary to prevent conflict or in response to emerging or actual crises. In certain cases, EU intervention can take the form of restrictive measures or 'sanctions'. The application of financial sanctions and more precisely the freezing of assets constitutes an obligation for both the public and private sector. In this regard, a particular responsibility falls on credit and financial institutions, since they are involved in the bulk of financial transfers. In order to facilitate the application of financial sanctions, the European Banking Federation, the European Savings Banks Group, the European Association of Co-operative Banks, the European Association of Public Banks ("the EU Credit Sector Federations") and the European Commission recognised the need for an EU consolidated list of persons, groups and entities subject to financial sanctions and more precisely the freezing of assets. The Credit Sector Federations set up an initial database containing the consolidated list. The European Commission subsequently took over this database and is responsible for its maintenance and for keeping the consolidated list of sanctions up-to-date. In this respect, the Service for Foreign Policy Instruments (FPI) of the European Commission launched a new Web page in June 2017, where the consolidated lists of financial sanctions consisting in freezing of assets are published in different formats (see link below). Disclaimer: While every effort is made to ensure that the database and the consolidated list correctly reproduce all relevant data of the officially adopted texts published in the Official Journal of the European Union, neither the Commission nor the EU Credit Sector Federations accepts any liability for possible omissions of relevant data or mistakes, and nor for any use the database or of the consolidated list. Only the information published in the Official Journal of the EU is deemed authentic. ____ This dataset has been deprecated when the ownership has been moved from FPI (Service for Foreign Policy Instruments) to FISMA (DG for Financial Stability, Financial Services and Capital Markets Union)
Publisher name: Service for Foreign Policy Instruments
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/foreign-policy-instruments
Last updated: 2024-06-11T16:18:01Z

Tables

Consolidated Financial Sanctions File 1.0

@ecfpi.consolidated_list_of_persons_groups_and_entities_subje_c820718a.consolidated_financial_sanctions_file_1_0

2.01 MB
38472 rows
59 columns


CREATE TABLE consolidated_financial_sanctions_file_1_0 (
  "date_file" TIMESTAMP,
  "entity_logical_id" BIGINT,
  "subject_type" VARCHAR,
  "leba_numtitle" VARCHAR,
  "leba_publication_date" TIMESTAMP,
  "leba_url" VARCHAR,
  "programme" VARCHAR,
  "entity_remark" VARCHAR,
  "naal_logical_id" DOUBLE,
  "entity_logical_id_1" DOUBLE,
  "naal_leba_numtitle" VARCHAR,
  "naal_leba_publication_date" TIMESTAMP,
  "naal_leba_url" VARCHAR,
  "naal_programme" VARCHAR,
  "naal_lastname" VARCHAR,
  "naal_firstname" VARCHAR,
  "naal_middlename" VARCHAR,
  "naal_wholename" VARCHAR,
  "naal_gender" VARCHAR,
  "naal_title" VARCHAR,
  "naal_function" VARCHAR,
  "naal_language" VARCHAR,
  "addr_logical_id" DOUBLE,
  "entity_logical_id_2" DOUBLE,
  "addr_leba_numtitle" VARCHAR,
  "addr_leba_publication_date" TIMESTAMP,
  "addr_leba_url" VARCHAR,
  "addr_programme" VARCHAR,
  "addr_number" VARCHAR,
  "addr_street" VARCHAR,
  "addr_zipcode" VARCHAR,
  "addr_city" VARCHAR,
  "addr_country" VARCHAR,
  "addr_other" VARCHAR,
  "birt_logical_id" DOUBLE,
  "entity_logical_id_3" DOUBLE,
  "birt_leba_numtitle" VARCHAR,
  "birt_leba_publication_date" TIMESTAMP,
  "birt_leba_url" VARCHAR,
  "birt_programme" VARCHAR,
  "birt_date" VARCHAR,
  "birt_place" VARCHAR,
  "birt_country" VARCHAR,
  "iden_logical_id" DOUBLE,
  "entity_logical_id_4" DOUBLE,
  "iden_leba_numtitle" VARCHAR,
  "iden_leba_publication_date" TIMESTAMP,
  "iden_leba_url" VARCHAR,
  "iden_programme" VARCHAR,
  "iden_number" VARCHAR,
  "iden_country" VARCHAR,
  "citi_logical_id" DOUBLE,
  "entity_logical_id_5" DOUBLE,
  "citi_leba_numtitle" VARCHAR,
  "citi_leba_publication_date" TIMESTAMP,
  "citi_leba_url" VARCHAR,
  "citi_programme" VARCHAR,
  "citi_country" VARCHAR,
  "eu_ref_num" VARCHAR
);

Consolidated Financial Sanctions File 1.1

@ecfpi.consolidated_list_of_persons_groups_and_entities_subje_c820718a.consolidated_financial_sanctions_file_1_1

2.32 MB
38472 rows
118 columns


CREATE TABLE consolidated_financial_sanctions_file_1_1 (
  "filegenerationdate" TIMESTAMP,
  "entity_logicalid" BIGINT,
  "entity_eu_referencenumber" VARCHAR,
  "entity_unitednationid" VARCHAR,
  "entity_designationdate" TIMESTAMP,
  "entity_designationdetails" VARCHAR,
  "entity_remark" VARCHAR,
  "entity_subjecttype" VARCHAR,
  "entity_subjecttype_classificationcode" VARCHAR,
  "entity_regulation_type" VARCHAR,
  "entity_regulation_organisationtype" VARCHAR,
  "entity_regulation_publicationdate" TIMESTAMP,
  "entity_regulation_entryintoforcedate" TIMESTAMP,
  "entity_regulation_numbertitle" VARCHAR,
  "entity_regulation_programme" VARCHAR,
  "entity_regulation_publicationurl" VARCHAR,
  "namealias_lastname" VARCHAR,
  "namealias_firstname" VARCHAR,
  "namealias_middlename" VARCHAR,
  "namealias_wholename" VARCHAR,
  "namealias_namelanguage" VARCHAR,
  "namealias_gender" VARCHAR,
  "namealias_title" VARCHAR,
  "namealias_function" VARCHAR,
  "namealias_logicalid" DOUBLE,
  "namealias_regulationlanguage" VARCHAR,
  "namealias_remark" VARCHAR,
  "namealias_regulation_type" VARCHAR,
  "namealias_regulation_organisationtype" VARCHAR,
  "namealias_regulation_publicationdate" TIMESTAMP,
  "namealias_regulation_entryintoforcedate" TIMESTAMP,
  "namealias_regulation_numbertitle" VARCHAR,
  "namealias_regulation_programme" VARCHAR,
  "namealias_regulation_publicationurl" VARCHAR,
  "address_city" VARCHAR,
  "address_street" VARCHAR,
  "address_pobox" VARCHAR,
  "address_zipcode" VARCHAR,
  "address_region" VARCHAR,
  "address_place" VARCHAR,
  "address_asatlistingtime" VARCHAR,
  "address_contactinfo" VARCHAR,
  "address_countryiso2code" VARCHAR,
  "address_countrydescription" VARCHAR,
  "address_logicalid" DOUBLE,
  "address_regulationlanguage" VARCHAR,
  "address_remark" VARCHAR,
  "address_regulation_type" VARCHAR,
  "address_regulation_organisationtype" VARCHAR,
  "address_regulation_publicationdate" TIMESTAMP,
  "address_regulation_entryintoforcedate" TIMESTAMP,
  "address_regulation_numbertitle" VARCHAR,
  "address_regulation_programme" VARCHAR,
  "address_regulation_publicationurl" VARCHAR,
  "birthdate_birthdate" TIMESTAMP,
  "birthdate_day" DOUBLE,
  "birthdate_month" DOUBLE,
  "birthdate_year" DOUBLE,
  "birthdate_yearrangefrom" DOUBLE,
  "birthdate_yearrangeto" DOUBLE,
  "birthdate_circa" VARCHAR,
  "birthdate_calendartype" VARCHAR,
  "birthdate_zipcode" VARCHAR,
  "birthdate_region" VARCHAR,
  "birthdate_place" VARCHAR,
  "birthdate_city" VARCHAR,
  "birthdate_countryiso2code" VARCHAR,
  "birthdate_countrydescription" VARCHAR,
  "birthdate_logicalid" DOUBLE,
  "birthdate_regulationlanguage" VARCHAR,
  "birthdate_remark" VARCHAR,
  "birthdate_regulation_type" VARCHAR,
  "birthdate_regulation_organisationtype" VARCHAR,
  "birthdate_regulation_publicationdate" TIMESTAMP,
  "birthdate_regulation_entryintoforcedate" TIMESTAMP,
  "birthdate_regulation_numbertitle" VARCHAR,
  "birthdate_regulation_programme" VARCHAR,
  "birthdate_regulation_publicationurl" VARCHAR,
  "identification_number" VARCHAR,
  "identification_diplomatic" VARCHAR,
  "identification_knownexpired" VARCHAR,
  "identification_knownfalse" VARCHAR,
  "identification_reportedlost" VARCHAR,
  "identification_revokedbyissuer" VARCHAR,
  "identification_issuedby" VARCHAR,
  "identification_issueddate" TIMESTAMP,
  "identification_validfrom" TIMESTAMP,
  "identification_validto" TIMESTAMP,
  "identification_latinnumber" VARCHAR,
  "identification_nameondocument" VARCHAR,
  "identification_typecode" VARCHAR,
  "identification_typedescription" VARCHAR,
  "identification_region" VARCHAR,
  "identification_countryiso2code" VARCHAR,
  "identification_countrydescription" VARCHAR,
  "identification_logicalid" DOUBLE,
  "identification_regulationlanguage" VARCHAR,
  "identification_remark" VARCHAR,
  "identification_regulation_type" VARCHAR,
  "identification_regulation_organisationtype" VARCHAR
);