Filtering Guide

The search endpoints accept structured filters to narrow down results. This guide explains how filters work and which fields you can filter on. It applies to:

Company search (POST /v1/search/company)
Person search (POST /v1/search/person)
Insolvency search (POST /v1/search/insolvency)

All three share the same request structure and filter types; they differ only in which fields are filterable (see Filterable Fields).

Request Structure

Filters go into the filters array of the request body. Each object in the array is one condition and must contain a field plus one of the filter types (value, values, keywords, or min/max).

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

All conditions in the filters array are combined with AND — a result must satisfy every one of them:

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

For an OR across several values of the same field, use values (see below).

Filter Types

Exact Match: `value`

For a simple exact match, use the value property.

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

Multiple Values: `values`

To match any one of a list of values (“OR” within a field), use the values array.

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

Keyword Matching: `keywords`

For free-text fields, keywords finds records whose field contains any of the specified words — unlike values, which requires the whole field to match exactly. Use it on fields like purpose or address.

{
  "field": "purpose",
  "keywords": ["Photovoltaik", "Solar"]
}

This matches companies whose business purpose mentions “Photovoltaik” or “Solar” anywhere in the text.

Range Filtering: `min` and `max`

For numerical and date fields, specify a range using min and/or max. Both bounds are optional — use just one for an open-ended range.

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

Value Conventions

A few conventions apply across all fields:

Monetary values are in cents, not euros. This applies to capital_amount and every financial indicator field (revenue, ebitda, balance_sheet_total, …). For example, 1 million EUR = 100000000 cents.

Dates use the DD-MM-YYYY format, e.g. "01-01-2026". (The ISO YYYY-MM-DD format is also accepted.) Date fields support min/max ranges:
{ "field": "incorporated_at", "min": "01-01-2020", "max": "31-12-2021" }

Booleans are passed as the strings "true" or "false":

{
  "field": "has_open_insolvency",
  "value": "true"
}

Free-Text Search Query

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

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

This searches for companies with “Descartes” in their name or previous names that are located in Berlin.

Location Filtering

For company search, you can filter by geographical location with a location object in the request body. It requires latitude and longitude, and optionally accepts a radius in kilometers.

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

Estimated Financials

Most German companies publish a balance sheet but no income statement, so revenue and EBITDA are missing for the large majority of them. For those companies, OpenRegister estimates both figures from what they do publish, with models trained on the companies that report them. Estimates are available as filters: estimated_revenue and estimated_ebitda for the figure, estimated_revenue_confidence and estimated_ebitda_confidence for how reliable it is. A few rules keep reported and estimated figures apart:

Reported figures are included. estimated_revenue matches the best available figure: the reported revenue where a company publishes one, the estimate everywhere else. A company never has both, so nothing is counted twice and no fiscal years are mixed. Use revenue instead if you want published figures only.
Same freshness as reported figures. An estimate refers to the company’s latest fiscal year with a filing and, like reported indicators, ages out after four years.
Cents, like every other monetary field.
Not estimated: companies in an open insolvency proceeding, and companies under a profit transfer agreement (their reported profit is zero by contract, so nothing can be inferred from it).

How confidence works

Every estimate is a range, not just a number: a median plus an 80% interval from the 10th to the 90th percentile. The models are calibrated on companies they never saw during training so that the true figure falls inside this interval for roughly 80 of 100 companies. Range filters on estimated_revenue and estimated_ebitda apply to the median. How wide that interval is varies a lot between companies: a GmbH with a detailed balance sheet, a headcount and an industry code gets a tight band, a holding with three balance sheet lines does not. The confidence tier summarises the width so you can filter on it without reasoning about quantiles:

Tier	Revenue	EBITDA
`high`	the likely range spans at most a factor of 4, e.g. 1 to 4 million EUR	the likely range is at most 10% of the balance sheet total
`medium`	at most a factor of 8	at most 30%
`low`	anything wider	anything wider, or no balance sheet total to compare with

Revenue uses a ratio because it scales with company size. EBITDA is measured against the balance sheet total instead, because its median is often close to zero, where a relative width would say nothing. Use estimated_revenue_confidence and estimated_ebitda_confidence with value or values to pick the tiers you accept. Companies with a reported figure pass whichever tiers you pick — a published number is the most confident value there is — so ["high"] means reported figures plus tight estimates. For lead lists, where a wrong size costs an outreach, ["high"] or ["high", "medium"] is the usual choice. For market sizing across many companies, all tiers are fine: the errors average out, the individual ranges do not. Combine the tier with a range on the figure itself, here 1 to 5 million EUR in cents:

{
  "filters": [
    {
      "field": "estimated_revenue",
      "min": "100000000",
      "max": "500000000"
    },
    {
      "field": "estimated_revenue_confidence",
      "values": ["high", "medium"]
    }
  ]
}

Examples

Common company search recipes, combining the building blocks above.

All Restaurants

Filter by the industry_codes field (WZ2025 codes):

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

Newly Founded Companies

Companies incorporated since the start of 2026, using a range filter on incorporated_at:

{
  "filters": [
    {
      "field": "incorporated_at",
      "min": "01-01-2026"
    }
  ]
}

High-Revenue Companies with a Large Workforce

Companies with more than 100 employees and over 100 million EUR in revenue (remember: monetary values 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

All companies with a registered address in a specific postal code:

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

Companies with a Specific Legal Form and Capital

All GmbH companies with a capital of more than 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 "true" or "false" to restrict results to companies that have been indexed with a non-empty LEI (true) or without one (false):

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

Or match one or more exact LEIs (20-character GLEIF identifiers) via lei:

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

Companies by VAT ID

Use vat_id to look up companies by their VAT identification number (Umsatzsteuer-Identifikationsnummer). VAT IDs are collected from company websites, so they are only available for companies whose website has been indexed.

{
  "filters": [
    {
      "field": "vat_id",
      "values": ["DE265054603", "DE812708193"]
    }
  ]
}

Companies by Estimated Revenue

Companies with revenue between 5 and 20 million EUR (cents: 5 million EUR = 500,000,000), reported or estimated, keeping reported figures and the tighter confidence tiers — see How confidence works:

{
  "filters": [
    {
      "field": "estimated_revenue",
      "min": "500000000",
      "max": "2000000000"
    },
    {
      "field": "estimated_revenue_confidence",
      "values": ["high", "medium"]
    }
  ]
}

Companies with an Open Insolvency Proceeding

Companies that currently have an open insolvency proceeding, opened since the start of 2026:

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

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

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

Company Search

The company search supports general company fields, financial indicator fields and estimated financial fields.

Company Fields

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)
`youngest_director_age`	The age of the youngest person currently in management (Geschäftsführer, Vorstand, board members, liquidators). Excludes Prokuristen and owners who hold no management role. (enterprise only)
`vat_id`	VAT identification number (Umsatzsteuer-Identifikationsnummer), sourced from the company’s website imprint. Exact match via `value`, or `values` for multiple VAT IDs (OR). Only available for companies whose website has been indexed.
`has_lei`	Boolean: 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: company has ever had an insolvency proceeding.
`has_open_insolvency`	Boolean: 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`.

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.

All financial indicator fields use values in cents, not euros — except employees.

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).

Estimated Financial Fields

Where a company reports neither figure, the search carries model estimates; these filters match the reported figure where there is one and the estimate otherwise — see Estimated Financials for the rules and how the confidence tiers are defined. Monetary values are in cents.

Field	Description
`estimated_revenue`	Best available revenue: the reported figure where the company publishes one, the median of the estimate otherwise. Range via `min`/`max`.
`estimated_revenue_confidence`	Confidence tier of the revenue estimate: `high`, `medium` or `low`. Reported figures pass every tier. Use `value`, or `values` for several tiers (OR).
`estimated_ebitda`	Best available EBITDA: the reported figure where the company publishes one, the median of the estimate otherwise. Range via `min`/`max`.
`estimated_ebitda_confidence`	Confidence tier of the EBITDA estimate: `high`, `medium` or `low`. Reported figures pass every tier. Use `value`, or `values` for several tiers (OR).

Person Search

The person search supports the following filterable fields:

Field	Description
`city`	The city of the person.
`date_of_birth`	The person’s date of birth. Range via `min`/`max`.
`active`	Boolean indicating if the person is active.

Insolvency Search

The insolvency search supports the following filterable fields. The date fields (opened_at, closed_at, last_event_at, claims_filing_deadline) support min/max ranges.

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.

Search

Company

Document

Web Data

Monitor

Person

Insolvency

Transparenzregister

Developer Resources

Request Structure

Filter Types

Exact Match: `value`

Multiple Values: `values`

Keyword Matching: `keywords`

Range Filtering: `min` and `max`

Value Conventions

Free-Text Search Query

Location Filtering

Estimated Financials

How confidence works

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 by VAT ID

Companies by Estimated Revenue

Companies with an Open Insolvency Proceeding

Owner-Managed Companies for Succession Planning

Filterable Fields

Company Search

Company Fields

Financial Indicator Fields

Estimated Financial Fields

Person Search

Insolvency Search

​Request Structure

​Filter Types

​Exact Match: value

​Multiple Values: values

​Keyword Matching: keywords

​Range Filtering: min and max

​Value Conventions

​Free-Text Search Query

​Location Filtering

​Estimated Financials

​How confidence works

​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 by VAT ID

​Companies by Estimated Revenue

​Companies with an Open Insolvency Proceeding

​Owner-Managed Companies for Succession Planning

​Filterable Fields

​Company Search

​Company Fields

​Financial Indicator Fields

​Estimated Financial Fields

​Person Search

​Insolvency Search

Request Structure

Filter Types

Exact Match: `value`

Multiple Values: `values`

Keyword Matching: `keywords`

Range Filtering: `min` and `max`

Value Conventions

Free-Text Search Query

Location Filtering

Estimated Financials

How confidence works

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 by VAT ID

Companies by Estimated Revenue

Companies with an Open Insolvency Proceeding

Owner-Managed Companies for Succession Planning

Filterable Fields

Company Search

Company Fields

Financial Indicator Fields

Estimated Financial Fields

Person Search

Insolvency Search