Filtering Guide

Our advanced search endpoint offers a flexible and powerful way to find specific companies. This guide explains the various filtering options available.

Basic Structure

The core of the filtering mechanism is the filters array in the request body. Each object in this array represents a single filter condition and must contain a field and a corresponding value using one of the available filter types.

{
  "filters": [
    {
      "field": "status",
      "value": "active"
    }
  ]
}

Free-Text Search Query

Besides structured filters, you can also perform a free-text search using the query field. This is useful for finding companies by name or previous names.

{
  "query": {
    "value": "Descartes"
  },
  "filters": [
    {
      "field": "city",
      "value": "Berlin"
    }
  ]
}

This will search for companies with “Descartes” in their name or previous names and are located in Berlin.

Examples

Here are a few examples of how you can combine different filters to achieve specific search results.

All Restaurants

To find all companies in the restaurant industry, you can filter by the industry_codes field.

{
  "filters": [
    {
      "field": "industry_codes",
      "value": "56.11" 
    }
  ]
}

Newly Founded Companies

To find companies that were incorporated in the last week, you can use a range filter on the incorporated_at field.

{
  "filters": [
    {
      "field": "incorporated_at",
      "min": "15-07-2024"
    }
  ]
}

High-Revenue Companies with a Large Workforce

To find companies with more than 100 employees and over 100 million EUR in revenue, you can combine two range filters. Monetary filter values (revenue, balance_sheet_total, capital_amount, etc.) are in cents — 100 million EUR = 10,000,000,000 cents.

{
  "filters": [
    {
      "field": "employees",
      "min": "100"
    },
    {
      "field": "revenue",
      "min": "10000000000"
    }
  ]
}

Companies in a Specific Location

To find all companies with a registered address in a specific postal code.

{
  "filters": [
    {
      "field": "zip",
      "value": "10117"
    }
  ]
}

Companies with a Specific Legal Form and Capital

To find all GmbH companies with a capital of more than 1 million EUR. Monetary filter values are in cents — 1 million EUR = 100,000,000 cents.

{
  "filters": [
    {
      "field": "legal_form",
      "value": "gmbh"
    },
    {
      "field": "capital_amount",
      "min": "100000000"
    },
    {
      "field": "capital_currency",
      "value": "EUR"
    }
  ]
}

Companies With or Without a Legal Entity Identifier (LEI)

Use has_lei with value "true" or "false" to restrict results to companies that have been indexed with a non-empty LEI (true) or without (false). Use lei with value for one LEI, or values for several (OR).

{
  "filters": [
    {
      "field": "has_lei",
      "value": "true"
    }
  ]
}

Match one or more exact LEIs (20-character GLEIF identifiers):

{
  "filters": [
    {
      "field": "lei",
      "values": ["5493001HCMGWDQ4MX390", "529900T8BM49AURSDO55"]
    }
  ]
}

Companies with an Open Insolvency Proceeding

To find companies that currently have an open insolvency proceeding, opened since the start of 2026. The insolvency_opened_at range uses the YYYY-MM-DD format.

{
  "filters": [
    {
      "field": "has_open_insolvency",
      "value": "true"
    },
    {
      "field": "insolvency_opened_at",
      "min": "2026-01-01"
    }
  ]
}

You can also target specific stages of a proceeding, e.g. all companies in preliminary or opened proceedings:

{
  "filters": [
    {
      "field": "insolvency_stage",
      "values": ["preliminary", "opened"]
    }
  ]
}

Owner-Managed Companies for Succession Planning

To find owner-managed businesses with an older owner - ideal for identifying succession opportunities.

{
  "filters": [
    {
      "field": "has_representative_owner",
      "value": "true"
    },
    {
      "field": "is_family_owned",
      "value": "false"
    },
    {
      "field": "youngest_owner_age",
      "min": "60"
    }
  ]
}

Filterable Fields

You can filter on a wide range of fields, listed below in two groups: general company fields and financial indicator fields.

Company Fields

Important: capital_amount uses values in cents, not euros.

Field	Description
`status`	The current status of the company (e.g., `active`, `inactive`, `liquidation`).
`legal_form`	The legal form of the company (e.g., `gmbh`, `ag`).
`register_number`	The company’s registration number.
`register_court`	The court where the company is registered.
`register_type`	The type of register (e.g., `HRB`, `HRA`).
`city`	The city where the company is located.
`active`	A boolean indicating if the company is active.
`incorporated_at`	The date of incorporation.
`purpose`	The business purpose of the company.
`zip`	The postal code of the company’s address.
`address`	The full address of the company.
`industry_codes`	The company’s industry codes (WZ2025).
`capital_amount`	The amount of the company’s capital (in cents).
`capital_currency`	The currency of the company’s capital.
`number_of_owners`	The number of company owners/shareholders. (enterprise only)
`has_sole_owner`	Boolean indicating if the company has only one owner. (enterprise only)
`has_representative_owner`	Boolean indicating if an owner is also in management (owner-managed). (enterprise only)
`is_family_owned`	Boolean indicating if the company is family-owned. (enterprise only)
`youngest_owner_age`	The age of the youngest owner/shareholder. (enterprise only)
`has_lei`	Boolean string `"true"` or `"false"`: company has a non-empty LEI indexed (`true`) or not (`false`).
`lei`	Legal Entity Identifier (GLEIF). Exact match via `value`, or `values` for multiple LEIs (OR).
`had_insolvency`	Boolean string `"true"` or `"false"`: company has ever had an insolvency proceeding.
`has_open_insolvency`	Boolean string `"true"` or `"false"`: company currently has an open insolvency proceeding.
`insolvency_stage`	Stage of the company’s most relevant proceeding (e.g., `preliminary`, `opened`, `plan_supervised`, `lifted`, `discharge_granted`). Use `value`, or `values` for multiple stages (OR).
`insolvency_opened_at`	The date the insolvency proceeding was opened. Range via `min`/`max` in `YYYY-MM-DD` format (note: unlike `incorporated_at`).

Financial Indicator Fields

Every financial indicator can be used as a range filter via min/max, based on the company’s most recent available fiscal year. Important: All financial indicator fields use values in cents, not euros — except employees. Divide by 100 to convert to EUR.

Field	Description
`balance_sheet_total`	Balance sheet total (Bilanzsumme).
`revenue`	Revenue (Umsatzerlöse).
`net_income`	Net income (Jahresüberschuss).
`parent_net_income`	Net income attributable to the parent company.
`income_before_tax`	Income before taxes.
`income_after_tax`	Income after taxes.
`ebit`	Earnings before interest and taxes.
`ebitda`	Earnings before interest, taxes, depreciation, and amortization.
`employees`	The number of employees.
`equity`	Equity (Eigenkapital).
`cash`	Cash reserves.
`fixed_assets`	Fixed assets (Anlagevermögen).
`current_assets`	Current assets (Umlaufvermögen).
`intangible_assets`	Intangible assets (immaterielle Vermögensgegenstände).
`tangible_assets`	Tangible assets (Sachanlagen).
`financial_assets`	Financial assets (Finanzanlagen).
`real_estate`	Real estate (Grundstücke und Bauten).
`inventory`	Inventory (Vorräte).
`receivables`	Receivables (Forderungen).
`trade_receivables`	Trade receivables (Forderungen aus Lieferungen und Leistungen).
`active_accruals`	Prepaid expenses (aktive Rechnungsabgrenzungsposten).
`passive_accruals`	Deferred income (passive Rechnungsabgrenzungsposten).
`liabilities`	Liabilities (Verbindlichkeiten).
`other_liabilities`	Other liabilities (sonstige Verbindlichkeiten).
`bank_debt`	Liabilities to banks (Verbindlichkeiten gegenüber Kreditinstituten).
`trade_payables`	Trade payables (Verbindlichkeiten aus Lieferungen und Leistungen).
`shareholder_liabilities`	Liabilities to shareholders (Verbindlichkeiten gegenüber Gesellschaftern).
`affiliated_liabilities`	Liabilities to affiliated companies (Verbindlichkeiten gegenüber verbundenen Unternehmen).
`financial_debt`	Financial debt (Finanzverbindlichkeiten).
`provisions`	Provisions (Rückstellungen).
`other_provisions`	Other provisions (sonstige Rückstellungen).
`pension_provisions`	Pension provisions (Pensionsrückstellungen).
`capital_reserves`	Capital reserves (Kapitalrücklage).
`retained_earnings`	Retained earnings (Gewinnrücklagen).
`profit_carryforward`	Profit carried forward (Gewinnvortrag).
`materials`	Cost of materials (Materialaufwand).
`salaries`	Personnel expenses (Personalaufwand).
`operating_depreciation`	Depreciation and amortization on fixed assets (Abschreibungen).
`financial_depreciation`	Depreciation on financial assets (Abschreibungen auf Finanzanlagen).
`other_operating_income`	Other operating income (sonstige betriebliche Erträge).
`other_operating_expenses`	Other operating expenses (sonstige betriebliche Aufwendungen).
`interest_income`	Interest income (Zinserträge).
`interest_expense`	Interest expense (Zinsaufwendungen).
`commission_income`	Commission income (Provisionserträge).
`commission_expense`	Commission expense (Provisionsaufwendungen).
`taxes`	Income taxes (Steuern vom Einkommen und vom Ertrag).
`other_taxes`	Other taxes (sonstige Steuern).

Insolvency Search Fields

The insolvency search (POST /v1/search/insolvency) supports its own set of filterable fields:

Field	Description
`current_status`	The current status of the proceeding (e.g., `preliminary`, `opened`, `lifted`, `discharge_granted`).
`has_open_insolvency`	Boolean indicating if the proceeding is currently open.
`proceeding_kind`	The kind of proceeding (`regular_insolvency`, `consumer_insolvency`).
`administration_kind`	The kind of administration (`external_administration`, `self_administration`, `protective_shield`).
`insolvency_grounds`	The legal grounds for the insolvency (e.g., `Zahlungsunfähigkeit`).
`debtor_kind`	The kind of debtor (`legal_person`, `natural_person`).
`debtor_legal_form`	The legal form of the debtor (e.g., `gmbh`).
`court`	The insolvency court handling the proceeding.
`city`	The city of the debtor.
`opened_at`	The date the proceeding was opened.
`closed_at`	The date the proceeding was closed.
`last_event_at`	The date of the most recent announcement.
`claims_filing_deadline`	The deadline for filing claims.
`company_id`	The OpenRegister company ID of the debtor.
`person_id`	The OpenRegister person ID of the debtor.

Note: The insolvency date fields (opened_at, closed_at, last_event_at, claims_filing_deadline) support min/max ranges and use the YYYY-MM-DD format — unlike the company incorporated_at examples above.

Filter Types

There are several ways to specify the filter value, depending on the desired comparison.

Exact Match: `value`

For a simple exact match, use the value property.

{
  "field": "legal_form",
  "value": "gmbh"
}

Multiple Values: `values`

To match against a list of possible values, use the values array. This is useful for “OR” conditions.

{
  "field": "city",
  "values": ["Berlin", "Hamburg", "München"]
}

Keyword Matching: `keywords`

For text fields, keywords allows you to find records containing any of the specified words.

{
  "field": "zip",
  "keywords": ["10117", "10119"]
}

Range Filtering: `min` and `max`

For numerical and date fields, you can specify a range using min and max.

{
  "field": "employees",
  "min": "10",
  "max": "100"
}

You can also specify just a minimum or a maximum. For monetary fields, use cents (e.g. 1 million EUR = 100000000).

{
  "field": "revenue",
  "min": "100000000"
}

Date Formatting

When filtering by date, use the DD-MM-YYYY format.

{
  "field": "incorporated_at",
  "min": "01-01-2020",
  "max": "31-12-2021"
}

Location Filtering

You can also filter companies based on their geographical location by providing a location object in the request body. This allows you to find companies within a certain radius of a given point. The location object requires latitude and longitude, and optionally accepts a radius in kilometers.

{
  "location": {
    "latitude": 52.5200,
    "longitude": 13.4050,
    "radius": 10
  }
}

Combining Filters

You can combine multiple filter objects in the filters array. These conditions are joined with an “AND” operator, meaning a company must satisfy all of them to be included in the results.

{
  "filters": [
    {
      "field": "legal_form",
      "value": "gmbh"
    },
    {
      "field": "employees",
      "min": "50"
    }
  ]
}

Search

Company

Document

Web Data

Monitor

Person

Insolvency

Transparenzregister

Developer Resources

Basic Structure

Free-Text Search Query

Examples

All Restaurants

Newly Founded Companies

High-Revenue Companies with a Large Workforce

Companies in a Specific Location

Companies with a Specific Legal Form and Capital

Companies With or Without a Legal Entity Identifier (LEI)

Companies with an Open Insolvency Proceeding

Owner-Managed Companies for Succession Planning

Filterable Fields

Company Fields

Financial Indicator Fields

Insolvency Search Fields

Filter Types

Exact Match: `value`

Multiple Values: `values`

Keyword Matching: `keywords`

Range Filtering: `min` and `max`

Date Formatting

Location Filtering

Combining Filters

​Basic Structure

​Free-Text Search Query

​Examples

​All Restaurants

​Newly Founded Companies

​High-Revenue Companies with a Large Workforce

​Companies in a Specific Location

​Companies with a Specific Legal Form and Capital

​Companies With or Without a Legal Entity Identifier (LEI)

​Companies with an Open Insolvency Proceeding

​Owner-Managed Companies for Succession Planning

​Filterable Fields

​Company Fields

​Financial Indicator Fields

​Insolvency Search Fields

​Filter Types

​Exact Match: value

​Multiple Values: values

​Keyword Matching: keywords

​Range Filtering: min and max

​Date Formatting

​Location Filtering

​Combining Filters

Basic Structure

Free-Text Search Query

Examples

All Restaurants

Newly Founded Companies

High-Revenue Companies with a Large Workforce

Companies in a Specific Location

Companies with a Specific Legal Form and Capital

Companies With or Without a Legal Entity Identifier (LEI)

Companies with an Open Insolvency Proceeding

Owner-Managed Companies for Succession Planning

Filterable Fields

Company Fields

Financial Indicator Fields

Insolvency Search Fields

Filter Types

Exact Match: `value`

Multiple Values: `values`

Keyword Matching: `keywords`

Range Filtering: `min` and `max`

Date Formatting

Location Filtering

Combining Filters