Consolidated List Of Persons, Groups And Entities Subject To EU Financial Sanctions by European Commission Directorate-General for Financial Stability, Financial Services and Capital Markets Union (DG FISMA) | Finance and Economics

About this Dataset

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 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. Please note that the information in this dataset may not be fully up to date because updates are delayed compared to the relevant publications in the EU's Official Journal.
Publisher name: Directorate-General for Financial Stability, Financial Services and Capital Markets Union
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/financial-stability-financial-services-and-capital-markets-union
Last updated: 2025-06-19T17:07:36Z

Tables

Consolidated Financial Sanctions File 1.1

@ecdgfisma.consolidated_list_of_persons_groups_and_entities_subje_9d90e0d3.consolidated_financial_sanctions_file_1_1

2.38 MB
39329 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
);

Consolidated Financial Sanctions File 1.0

@ecdgfisma.consolidated_list_of_persons_groups_and_entities_subje_9d90e0d3.consolidated_financial_sanctions_file_1_0

2.06 MB
39329 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
);