# EU financial firm licences and regulator warnings

**Check whether a European financial firm is licensed, live on SEPA Instant, sanctioned or named in a regulator warning.** One table brings together official registers from across the EU: ESMA's registers of investment firms, fund managers, crowdfunding providers, trading venues and crypto-asset firms; the ECB's list of banks, money market funds and central banks; the EBA's register of payment an…

EU financial firm licences and regulator warnings is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `eu-financial-firm-licences-and-regulator-warnings`
- Canonical page: https://mostlyright.md/datasets/eu-financial-firm-licences-and-regulator-warnings
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-10-19T16:26:47.486Z
- Tables: 1
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/eu-financial-firm-licences-and-regulator-warnings`
- Topics: financial regulation, licensing, sanctions, payments, sepa instant, crypto, fraud, kyb

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and nothing else: no filter, sort, search, download or page past row 500.
3. Sign in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: counterparty_records

- Table id: `b0bc56bb-2e3b-4304-a46d-eb94ceaeed9f`
- Slug: `counterparty-records`
- Immutable version: `faf55752-1330-5c91-a429-e8919ebceff3`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/b0bc56bb-2e3b-4304-a46d-eb94ceaeed9f/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/b0bc56bb-2e3b-4304-a46d-eb94ceaeed9f/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/b0bc56bb-2e3b-4304-a46d-eb94ceaeed9f/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/b0bc56bb-2e3b-4304-a46d-eb94ceaeed9f/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (35)

| Column | Type | Description |
| --- | --- | --- |
| `record_id` | string | A stable hash of the record type and the source record's own key, which names one row. |
| `record_type` | string | What the record is: licence, payment_scheme, warning or sanction. |
| `source_list` | string | The published register or list the record comes from, such as esma_registers, ecb_mfi_list, eba_payments_register, cnb_banks, esma_casps, epc_scheme_registers,… |
| `authority` | string | The body that keeps the register or issued the warning or sanction. |
| `authority_country` | string | The two-letter code of the authority's country, for licences and warnings; EU for an EU body such as the European Central Bank. |
| `name` | string | The firm, participant or entity name; for a warning that lists only a website or email, its domain. A warning about a clone keeps the regulator's clone marker… |
| `other_names` | string | The trading name of a licensed firm, or every name and alias of a sanctioned entity separated by vertical bars. |
| `country` | string | The two-letter code of the counterparty's country: the home member state of a licensed firm, the country of a payment scheme participant, or the address countr… |
| `national_id` | string | A national or register identifier where the source gives one: the Czech company number (IČO) on Czech National Bank lists, the ECB's RIAD code for monetary fin… |
| `lei` | string | The Legal Entity Identifier, where the register gives one. |
| `bic` | string | The eleven-character BIC of a payment scheme participant. |
| `eu_reference_number` | string | The EU reference number of a sanctioned entity. |
| `un_id` | string | The United Nations identifier of a sanctioned entity the UN also lists. |
| `website` | string | A licensed firm's website as the register writes it. |
| `website_domain` | string | The host name of a licensed firm's website or of a website a regulator warns about, lower-cased and without www. |
| `email_domain` | string | The domain of an email address a regulator warns about. The part before the @ is not kept. |
| `address` | string | The registered address as the register writes it for licensed firms and payment scheme participants, or the seat a warned firm claims. |
| `city` | string | The city of a licensed firm or payment scheme participant. |
| `category` | string | What the licence covers (for example a credit institution, a payment or electronic money institution, an investment firm, a fund manager or a crypto-asset serv… |
| `detail` | string | The services a licensed firm is authorised for (for a branch, its head office; for a firm notified under a PSD2 exclusion, the exclusion and its activity), or… |
| `value_kind` | string | For a warning, whether it lists a website, an email domain, a name or a firm with its details. |
| `passported_to` | string | The member states a firm has notified it serves under its licence, or where its branch sits, as two-letter codes separated by vertical bars. |
| `since` | date | When the record took effect: the authorisation date of a licence, the SCT Inst or payee-check readiness date of a payment scheme participant, the date a warnin… |
| `until` | date | When a licence ended or a participant leaves its scheme, where the source gives a date. |
| `in_sct_inst` | boolean | For a payment scheme participant, whether it is on the SEPA Instant Credit Transfer (SCT Inst) register. |
| `sct_inst_ready_since` | date | The participant's SCT Inst readiness date as the EPC lists it. |
| `sct_inst_leaving_date` | date | The date the participant leaves SCT Inst, where the EPC lists one. |
| `in_vop` | boolean | For a payment scheme participant, whether it is on the Verification of Payee (VOP) register. |
| `vop_status` | string | The participant's Verification of Payee status as the EPC writes it. |
| `vop_role` | string | Whether the participant requests payee checks, answers them, or both. |
| `vop_ready_since` | date | The participant's Verification of Payee readiness date as the EPC lists it. |
| `vop_leaving_date` | date | The date the participant leaves Verification of Payee, where the EPC lists one. |
| `name_count` | integer | How many distinct names and aliases the sanctions list gives an entity. |
| `regulation_url` | string | A link to the Official Journal act that listed a sanctioned entity. |
| `source_url` | string | A link to the record on the publisher's own site, such as a warning's notice or a firm's register entry, where the source gives one. |

## Citing this dataset

Cite the dataset by name and canonical URL (https://mostlyright.md/datasets/eu-financial-firm-licences-and-regulator-warnings), the table, and the immutable `version_id` the rows came from. A query response carries `table.version_id` and `table.content_digest`; a download carries a strong ETag and a `Content-Digest` header.