# Search Filters: Base Company API

{% columns %}
{% column width="16.666666666666664%" %}
Data type:

Query type:

URL:
{% endcolumn %}

{% column %}
Base Company

Coresignal's custom filters

<https://api.coresignal.com/cdapi/v2/company\\_base/search/filter>
{% endcolumn %}
{% endcolumns %}

***

## Overview

Use the endpoint to discover company IDs. It offers a less complex user experience than the `/v2/company_base/search/es_dsl` endpoint.

Explore the available filters, their potential applications, and helpful tips.

If you prefer uncomplicated queries, opt for this endpoint. Below are details about filter explanations and how to use them.

## Endpoint structure

{% code title="Full structure" %}

```json
{
  "name": "string",
  "website": "string",
  "exact_website": "string",
  "size": "string",
  "industry": "string",
  "country": "string",
  "location": "string",
  "created_at_gte": "string",
  "created_at_lte": "string",
  "last_updated_gte": "string",
  "last_updated_lte": "string",
  "deleted": true,
  "employees_count_gte": 0,
  "employees_count_lte": 0,
  "source_id": 0,
  "founded_year_gte": 0,
  "founded_year_lte": 0,
  "funding_total_rounds_count_gte": 0,
  "funding_total_rounds_count_lte": 0,
  "funding_last_round_type": "string",
  "funding_last_round_date_gte": "string",
  "funding_last_round_date_lte": "string"
}
```

{% endcode %}

## Filter list

{% hint style="info" %}
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.

***

Example outputs are redacted and may not contain all the fields you would receive using the endpoint.
{% endhint %}

<details>

<summary>name</summary>

| Filter name | Data input type | Description  | Usage                                                                                                                                                                                                                          |
| ----------- | --------------- | ------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `name`      | String          | Company name | <p>Find company records using the company name or parts of it.<br>Available operators:</p><ul><li><code>AND</code> (both keywords need to be present)</li><li><code>OR</code> (one or the other keyword is present).</li></ul> |

{% hint style="success" %}
You can search for company records using a part of the name.

For instance, entering `IT` will return results with companies such as `Backbone IT Consulting Inc.` and `Brothers IT Limited`.
{% endhint %}

**Example input:**

{% code title="name" %}

```json
{
  "name": "IT"
}
```

{% endcode %}

{% code title="OR operator" %}

```json
{
  "name": "(IT Consulting) OR (IT Security)"
}
```

{% endcode %}

{% code title="AND operator" %}

```json
{
  "name": "(IT Consulting) AND (IT Security)"
}
```

{% endcode %}

{% hint style="success" %}
Use `"(first phrase) OR (second phrase)"` if you are searching for words in a phrase and want them to be interpreted together.
{% endhint %}

**Example output:**

{% code title="First example" %}

```json
{
    "id": 482,
    "name": "IT Consulting Inc.",
}
```

{% endcode %}

</details>

<details>

<summary>website</summary>

| Filter name | Data input type | Description       | Usage                                                                                                                                                                                                                                                                                   |
| ----------- | --------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `website`   | String          | Company's website | <p>Search for company records using the company's website.<br>Possible URL formats include: <code>microsoft.com</code></p><p><code>subdomain.microsoft.com</code></p><p><code>[www.microsoft.com](http://www.microsoft.com)</code></p><p><code><https://www.microsoft.com></code> .</p> |

**Example input:**

{% code title="Domain" %}

```json
{
  "website": "example-company.com"
}
```

{% endcode %}

{% code title="https format" %}

```json
{
  "website": "https://www.example-company.com"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"name": "Example Company",
"website": "www.example-company.com",
```

{% endcode %}

</details>

<details>

<summary>exact_website</summary>

| Filter name     | Data input type | Description       | Usage                                                                                                                                                                                                                                    |
| --------------- | --------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `exact_website` | String          | Company's website | <p>Search for company records using the (exact) company website.<br>Possible URL formats: <code>microsoft.com</code></p><p><code>[www.microsoft.com](http://www.microsoft.com)</code></p><p><code><https://www.microsoft.com></code></p> |

**Example input:**

{% code title="exact\_website" %}

```json
{
  "name": "IT Company",
  "exact_website": "www.it-company.com"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
    "name": "IT Company",
    "website": "http://www.it-company.com",
```

{% endcode %}

</details>

<details>

<summary>size</summary>

| Filter name | Data input type | Description                       | Usage                                      |
| ----------- | --------------- | --------------------------------- | ------------------------------------------ |
| `size`      | String          | Company size (based on headcount) | Find company profiles based on their size. |

Possible input values can be found in general [Search filters](https://docs.coresignal.com/api-introduction/requests/search-filters#possible-input-values) topic.

</details>

<details>

<summary>industry</summary>

| Filter name | Data input type | Description         | Usage                                                                                                                                                                                                                                                                                        |
| ----------- | --------------- | ------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `industry`  | String          | Associated industry | <p>Use the associated industry values to find company profiles.<br>Search based on the available industry list.<br>Available operators: </p><ul><li><code>AND</code> (both keywords need to be present)</li><li><code>OR</code> (one or the other keyword is present in the data).</li></ul> |

{% hint style="success" %}
Use `"(first phrase) OR (second phrase)"` if you are searching for words in a phrase and want them to be interpreted together.
{% endhint %}

{% code title="Phrases" %}

```json
{
  "industry": "(Information technology) OR Internet"
}
```

{% endcode %}

Possible input values can be found in general [Search filters](https://docs.coresignal.com/api-introduction/requests/search-filters#possible-input-values) topic.

</details>

<details>

<summary>country</summary>

| Filter name | Data input type | Description                        | Usage                                                                                                                                                 |
| ----------- | --------------- | ---------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------- |
| `country`   | String          | Country where the company is based | <p>Use any of the possible country values to find company records.<br>Available operators:<br>\* <code>OR</code><br>(one of the two input values)</p> |

{% hint style="info" %}
Use `"(first phrase) OR (second phrase)"` if you are searching for words in a phrase and want them to be interpreted together.
{% endhint %}

{% code title="Phrases" %}

```json
{
  "country": "(United Kingdom) OR Germany"
}
```

{% endcode %}

Possible input values can be found in general [Search filters](https://docs.coresignal.com/api-introduction/requests/search-filters#possible-input-values) topic.

</details>

<details>

<summary>location</summary>

| Filter name | Data input type | Description      | Usage                                                                                                                                                                                                                                                                                                                                                                                                                        |
| ----------- | --------------- | ---------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `location`  | String          | Company location | <p>Use the following values to search for company records:</p><ul><li>continent (e.g., North America)</li><li>country (e.g., United States)</li><li>state (e.g., Florida)</li><li>city (e.g., Jacksonville)</li><li>village (e.g., Palmetto bay).</li></ul><p>Available operators:</p><ul><li> <code>AND</code> – both keywords need to be present;</li><li><code>OR</code> – one or the other keyword is present.</li></ul> |

**Example input:**

{% code title="location" %}

```json
{
  "location": "United States, Florida"
}
```

{% endcode %}

**Example output:**

{% code title="Output" %}

```json
"headquarters_new_address": "Palmetto Bay, Miami, Florida, United States",
```

{% endcode %}

{% hint style="info" %}
Use `"\"{keyword}\""` format to find exact matches.
{% endhint %}

{% code title="Exact match" %}

```json
{
  "location": "\"United States\" OR Germany"
}
```

{% endcode %}

</details>

<details>

<summary>created_at_gte</summary>

| Filter name      | Data input type | Description                                               | Usage                                                                                                                                                                                  |
| ---------------- | --------------- | --------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `created_at_gte` | String          | Date and time when the record was created in our database | <p>Find company records based on the creation date.<br>Use the <code>YYYY-MM-DD hh:mm:ss</code> date format.<br>The output value will be greater than or equal to the input value.</p> |

**Example input:**

{% code title="created\_at\_gte" %}

```json
{
  "created_at_gte": "2021-06-26 12:21:01"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
  "created": "2021-06-26 12:21:06",
```

{% endcode %}

</details>

<details>

<summary>created_at_lte</summary>

| Filter name      | Data input type | Description                                               | Usage                                                                                                                                                                              |
| ---------------- | --------------- | --------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `created_at_lte` | String          | Date and time when the record was created in our database | <p>Find company records based on the creation date.<br>Use the <code>YYYY-MM-DD hh:mm:ss</code> date format.<br>The output data will be less than or equal to the input value.</p> |

**Example input:**

{% code title="created\_at\_lte" %}

```json
{
  "created_at_lte": "2021-06-26 12:21:01"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
 "created": "2016-06-17 14:59:01",
```

{% endcode %}

</details>

<details>

<summary>last_updated_gte</summary>

| Filter name        | Data input type | Description                                    | Usage                                                                                                                                                                                     |
| ------------------ | --------------- | ---------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `last_updated_gte` | String          | Date and time when the record was last updated | <p>Find company records based on the last update date.<br>Use the <code>YYYY-MM-DD hh:mm:ss</code> date format.<br>The output value will be greater than or equal to the input value.</p> |

**Example input:**

{% code title="last\_updated\_gte" %}

```json
{
  "last_updated_gte": "2021-02-26 12:41:01"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"last_updated": "2023-05-21 17:58:40",
"last_response_code": 200,
```

{% endcode %}

</details>

<details>

<summary>last_updated_lte</summary>

| Filter name        | Data input type | Description                                    | Usage                                                                                                                                                                                  |
| ------------------ | --------------- | ---------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `last_updated_lte` | String          | Date and time when the record was last updated | <p>Find company records based on the last update date.<br>Use the <code>YYYY-MM-DD hh:mm:ss</code> date format.<br>The output value will be less than or equal to the input value.</p> |

**Example input:**

{% code title="last\_updated\_lte" %}

```json
{
  "last_updated_lte": "2023-02-26 12:41:01"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"last_updated": "2023-01-09 05:01:35",
"last_response_code": 200,
```

{% endcode %}

</details>

<details>

<summary>deleted</summary>

| Filter name | Data input type | Description                        | Usage                                                                                                                                                                                                                                                                                     |
| ----------- | --------------- | ---------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `deleted`   | Boolean         | Marks record's public availability | <p>Use it to see company records that are deleted or private.<br>Use the value <code>true</code> to include deleted/private profiles or <code>false</code> to exclude such profiles from your search.</p><p><strong>Tip:</strong> Combine with other filters using relevant keywords.</p> |

**Input values:**

{% code title="deleted – true" %}

```json
{
  "deleted": true
}
```

{% endcode %}

{% code title="deleted – false" %}

```json
{
  "deleted": false
}
```

{% endcode %}

**Example output:**

{% code title="Deleted profile" %}

```json
{
    "deleted": 1
}
```

{% endcode %}

</details>

<details>

<summary>employees_count_gte</summary>

| Filter name           | Data input type | Description                                     | Usage                                                                                                                             |
| --------------------- | --------------- | ----------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------- |
| `employees_count_gte` | Integer         | Employee count visible on the company's profile | <p>Find company records based on the company headcount.<br>The output value will be greater than or equal to the input value.</p> |

**Example input:**

{% code title="employees\_count\_gte" %}

```json
{
  "employees_count_gte": 22
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"employees_count": 190,
```

{% endcode %}

</details>

<details>

<summary>employees_count_lte</summary>

| Filter name           | Data input type | Description                                     | Usage                                                                                                                          |
| --------------------- | --------------- | ----------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------ |
| `employees_count_gte` | Integer         | Employee count visible on the company's profile | <p>Find company records based on the company headcount.<br>The output value will be less than or equal to the input value.</p> |

**Example input:**

{% code title="employees\_count" %}

```json
{
  "employees_count_lte": 22
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"employees_count": 2,
```

{% endcode %}

</details>

<details>

<summary>source_id</summary>

| Filter name | Data input type | Description                       | Usage                                          |
| ----------- | --------------- | --------------------------------- | ---------------------------------------------- |
| `source_id` | Integer         | Company ID assigned by the source | Find company records using source identifiers. |

**Example input:**

{% code title="source\_id" %}

```json
{
  "source_id": 2280242
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"id": 5,
"url": "https://www.professional-network.com/company/it-company",
"hash": "7c7aa7f01abcc2c5672ae36fc412cff9",
"name": "ITcompany",
"source_id": 2280242,
```

{% endcode %}

</details>

<details>

<summary>founded_year_gte</summary>

| Filter name        | Data input type | Description             | Usage                                                                                                                           |
| ------------------ | --------------- | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------- |
| `founded_year_gte` | Integer         | Company's founding year | <p>Find company records based on their founding year.<br>The output value will be greater than or equal to the input value.</p> |

**Example input:**

{% code title="founded\_year" %}

```json
{
  "founded_year_gte": 2011
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"founded": 2015,
```

{% endcode %}

</details>

<details>

<summary>founded_year_lte</summary>

| Filter name        | Data input type | Description             | Usage                                                                                                                        |
| ------------------ | --------------- | ----------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| `founded_year_lte` | Integer         | Company's founding year | <p>Find company records based on their founding year.<br>The output value will be less than or equal to the input value.</p> |

**Example input:**

{% code title="founded\_year\_lte" %}

```json
{
  "founded_year_lte": 2011 
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"founded": 2001,
```

{% endcode %}

</details>

<details>

<summary>funding_total_rounds_count_gte</summary>

| Filter name                      | Data input type | Description                              | Usage                                                                                                                                                             |
| -------------------------------- | --------------- | ---------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `funding_total_rounds_count_gte` | Integer         | Total number of company's funding rounds | <p>Find company records based on the funding rounds in the company's financial history.<br>The output value will be greater than or equal to the input value.</p> |

**Example input**:

{% code title="funding\_rounds\_total\_count" %}

```json
{
  "funding_total_rounds_count_gte": 5
}
```

{% endcode %}

**Example input:**

{% code title="Example" %}

```json
"company_funding_rounds_collection": [
        {
            "id": 81212,
            "last_round_investors_count": 0,
            "total_rounds_count": 5,
            "last_round_type": "Seed",
            "last_round_date": "2016-11-21 00:00:00",
            "last_round_money_raised": "US$ 1.6M",
            "financial_website_url": "https://www.financial_website.com/funding_round/it-company",
            "created": "2020-09-15 10:22:31",
            "last_updated": "2020-10-17 23:02:42",
            "deleted": 1
        }
  ]
```

{% endcode %}

</details>

<details>

<summary>funding_total_rounds_count_lte</summary>

| Filter name                      | Data input type | Description                              | Usage                                                                                                                                                          |
| -------------------------------- | --------------- | ---------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `funding_total_rounds_count_lte` | Integer         | Total number of company's funding rounds | <p>Find company records based on the funding rounds in the company's financial history.<br>The output value will be less than or equal to the input value.</p> |

**Example input:**

{% code title="funding\_total\_rounds\_count" %}

```json
{
  "funding_total_rounds_count_lte": 5
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"company_funding_rounds_collection": [
        {
            "id": 9707,
            "last_round_investors_count": 0,
            "total_rounds_count": 0,
            "last_round_type": null,
            "last_round_date": null,
            "last_round_money_raised": null,
            "financial_website_url": null,
            "created": "2020-09-07 19:44:55",
            "last_updated": "2020-10-30 09:03:58",
            "deleted": 1
        }
    ]
```

{% endcode %}

</details>

<details>

<summary>funding_last_round_type</summary>

| Filter name               | Data input type | Description             | Usage                                                                                                           |
| ------------------------- | --------------- | ----------------------- | --------------------------------------------------------------------------------------------------------------- |
| `funding_last_round_type` | String          | Last funding round type | <p>Find company records based on the company's last funding round.<br>Use any of the possible input values.</p> |

Possible input values can be found in general [Search filters](https://docs.coresignal.com/api-introduction/requests/search-filters#possible-input-values) topic.

</details>

<details>

<summary>funding_last_round_date_gte</summary>

| Filter name                   | Data input type | Description             | Usage                                                                                                                                                                                          |
| ----------------------------- | --------------- | ----------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `funding_last_round_date_gte` | String          | Last funding round date | <p>Use the last funding round date to find relevant company records.<br>Use the <code>yyyy-mm-dd</code> date format.<br>The output value will be greater than or equal to the input value.</p> |

**Example input:**

{% code title="funding\_last\_round\_date\_gte" %}

```json
{
  "funding_last_round_date_gte": "2021-11-01"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"company_funding_rounds_collection": [
        {
            "id": 81212,
            "last_round_investors_count": 0,
            "total_rounds_count": 5,
            "last_round_type": "Seed",
            "last_round_date": "2016-11-21 00:00:00",
            "last_round_money_raised": "US$ 1.6M",
            "financial_website_url": "https://www.financial_website.com/funding_round/it-company",
            "created": "2020-09-15 10:22:31",
            "last_updated": "2020-10-17 23:02:42",
            "deleted": 1
        }
    ]
```

{% endcode %}

</details>

<details>

<summary>funding_last_round_date_lte</summary>

| Filter name                   | Data input type | Description             | Usage                                                                                                                                                                                       |
| ----------------------------- | --------------- | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `funding_last_round_date_gte` | String          | Last funding round date | <p>Use the last funding round date to find relevant company records.<br>Use the <code>yyyy-mm-dd</code> date format.<br>The output value will be less than or equal to the input value.</p> |

**Example input:**

{% code title="funding\_last\_round\_date\_lte" %}

```json
{
  "funding_last_round_date_lte": "2011-11-01"
}
```

{% endcode %}

**Example output:**

{% code title="Example" %}

```json
"company_funding_rounds_collection": [
        {
            "id": 121691,
            "last_round_investors_count": 0,
            "total_rounds_count": 1,
            "last_round_type": "Angel",
            "last_round_date": "2007-01-01 00:00:00",
            "last_round_money_raised": null,
            "financial_website_url": "https://www.financial_website.com/funding_round/it-company",
            "created": "2020-09-20 23:18:01",
            "last_updated": "2020-10-13 08:17:36",
            "deleted": 1
        }
  ]
```

{% endcode %}

</details>