Skip to main content
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"
    }
  ]
}
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"
    }
  ]
}

​
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. Here is a list of all available fields: Important: All monetary/indicator fields (balance_sheet_total, revenue, cash, equity, capital_amount, real_estate, materials, pension_provisions, salaries, taxes, liabilities, capital_reserves, net_income) use values in cents, not euros. Divide by 100 to convert to EUR.
FieldDescription
statusThe current status of the company (e.g., active, inactive, liquidation).
legal_formThe legal form of the company (e.g., gmbh, ag).
register_numberThe company’s registration number.
register_courtThe court where the company is registered.
register_typeThe type of register (e.g., HRB, HRA).
cityThe city where the company is located.
activeA boolean indicating if the company is active.
incorporated_atThe date of incorporation.
purposeThe business purpose of the company.
zipThe postal code of the company’s address.
addressThe full address of the company.
balance_sheet_totalThe total of the balance sheet (in cents).
revenueThe company’s revenue (in cents).
cashThe company’s cash reserves (in cents).
employeesThe number of employees.
equityThe company’s equity (in cents).
real_estateThe value of the company’s real estate (in cents).
materialsThe value of the company’s materials (in cents).
pension_provisionsThe company’s pension provisions (in cents).
salariesThe company’s salary expenses (in cents).
taxesThe company’s tax expenses (in cents).
liabilitiesThe company’s liabilities (in cents).
capital_reservesThe company’s capital reserves (in cents).
net_incomeThe company’s net income (in cents).
industry_codesThe company’s industry codes (WZ2025).
capital_amountThe amount of the company’s capital (in cents).
capital_currencyThe currency of the company’s capital.
number_of_ownersThe number of company owners/shareholders. (enterprise only)
has_sole_ownerBoolean indicating if the company has only one owner. (enterprise only)
has_representative_ownerBoolean indicating if an owner is also in management (owner-managed). (enterprise only)
is_family_ownedBoolean indicating if the company is family-owned. (enterprise only)
youngest_owner_ageThe age of the youngest owner/shareholder. (enterprise only)

​
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"
    }
  ]
}