> ## Documentation Index
> Fetch the complete documentation index at: https://deepline.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Crustdata Companydb Search: Inputs, Cost & CLI Example

> Searching CrustData CompanyDB with structured filters. Includes inputs, outputs, pricing notes, Deepline CLI examples, and GTM automation guidance.

## Run in Enrichment Spreadsheet

<Info>
  Use this function as a column step in `deepline enrich`.
</Info>

```bash theme={null}
deepline enrich --input leads.csv --output leads.enriched.csv --with 'result=crustdata_companydb_search:{"filters":[{"filter_type":"hq_country","type":"=","value":"USA"}]}' --json
```

<Tip>
  Map payload values to spreadsheet columns with `{{column_name}}` placeholders.
</Tip>

## Input Schema

| Name              | Type              | Required | Default | Description                                                                                                                                                                                                                                                                                                                                                                                                                              |
| ----------------- | ----------------- | -------- | ------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `payload.filters` | `object \| array` | Yes      |         | Array of filter conditions (AND-combined). Each: \{filter\_type, type, value} or \{filter\_name, type, value}. filter\_name is syntactic sugar for filter\_type (e.g. company\_investors → crunchbase\_investors, company\_funding\_stage → last\_funding\_round\_type). Single object is accepted. Nested \{op,conditions} groups supported for OR logic. Current Crust CompanyDB dot-path field names are accepted and passed through. |
| `payload.fields`  | `string \| array` | No       |         | Optional field selection (array or comma-separated). Passed through to Crust when provided.                                                                                                                                                                                                                                                                                                                                              |
| `payload.limit`   | `integer`         | No       | `20`    | Max results to return (1-1000, default 20).                                                                                                                                                                                                                                                                                                                                                                                              |
| `payload.cursor`  | `string`          | No       |         | Pagination cursor.                                                                                                                                                                                                                                                                                                                                                                                                                       |
| `payload.sorts`   | `array`           | No       |         | Sort criteria array.                                                                                                                                                                                                                                                                                                                                                                                                                     |

<details>
  <summary>Show raw input schema</summary>

  ### Input JSON Schema

  ```json theme={null}
  {
    "type": "object",
    "description": "Searches CompanyDB using /screener/companydb/search with filters.",
    "properties": {
      "filters": {
        "description": "Array of filter conditions (AND-combined). Each: {filter_type, type, value} or {filter_name, type, value}. filter_name is syntactic sugar for filter_type (e.g. company_investors → crunchbase_investors, company_funding_stage → last_funding_round_type). Single object is accepted. Nested {op,conditions} groups supported for OR logic. Current Crust CompanyDB dot-path field names are accepted and passed through.",
        "anyOf": [
          {
            "$ref": "T0"
          },
          {
            "type": "array",
            "minItems": 1,
            "items": {
              "$ref": "T0"
            }
          }
        ]
      },
      "fields": {
        "description": "Optional field selection (array or comma-separated). Passed through to Crust when provided.",
        "anyOf": [
          {
            "type": "string",
            "minLength": 1
          },
          {
            "type": "array",
            "minItems": 1,
            "items": {
              "type": "string",
              "minLength": 1
            }
          }
        ]
      },
      "limit": {
        "type": "integer",
        "description": "Max results to return (1-1000, default 20).",
        "default": 20,
        "minimum": 1,
        "maximum": 1000
      },
      "cursor": {
        "type": "string",
        "description": "Pagination cursor.",
        "minLength": 1
      },
      "sorts": {
        "type": "array",
        "description": "Sort criteria array.",
        "minItems": 1,
        "items": {
          "type": "object",
          "properties": {
            "column": {
              "type": "string",
              "description": "Field to sort by. Supports current Crust CompanyDB sort fields plus Deepline aliases like funding_date/last_funding_round_date -> last_funding_date, funding_stage/funding_round -> last_funding_round_type, headcount/size -> employee_metrics.latest_count, industry -> linkedin_industries, location -> hq_country, domain -> company_website_domain.",
              "minLength": 1
            },
            "order": {
              "type": "string",
              "description": "Sort order: asc or desc.",
              "enum": [
                "asc",
                "desc"
              ]
            }
          },
          "required": [
            "column",
            "order"
          ],
          "additionalProperties": false
        }
      }
    },
    "required": [
      "filters"
    ],
    "additionalProperties": false,
    "$defs": {
      "T0": {
        "$id": "T0",
        "anyOf": [
          {
            "type": "object",
            "properties": {
              "filter_type": {
                "type": "string",
                "description": "Field to filter on. Accepts current Crust CompanyDB field paths plus Deepline aliases via filter_name. Key mappings: company_investors → crunchbase_investors, company_funding_stage → last_funding_round_type, funding stage/round → last_funding_round_type, headcount/size → employee_metrics.latest_count, industry → linkedin_industries, location → hq_country (ISO alpha-3) or hq_location or region, funding amount → crunchbase_total_investment_usd, domain → company_website_domain. New upstream dot-path fields are passed through instead of being rejected locally.",
                "minLength": 1
              },
              "type": {
                "type": "string",
                "description": "Operator: =, !=, in, not_in, >, <, =>, =<, (.) fuzzy contains, [.] substring.",
                "enum": [
                  "=",
                  "!=",
                  "in",
                  "not_in",
                  ">",
                  "<",
                  "=>",
                  "=<",
                  "(.)",
                  "[.]"
                ]
              },
              "value": {
                "description": "Filter value. When unsure of exact values for a field, call crustdata_companydb_autocomplete first (free, no credits): e.g. deepline tools execute crustdata_companydb_autocomplete --payload '{\"field\":\"last_funding_round_type\",\"query\":\"series\",\"limit\":10}' --json. hq_country uses ISO 3166-1 alpha-3 codes (USA, GBR, CAN).",
                "anyOf": [
                  {
                    "type": "string"
                  },
                  {
                    "type": "number"
                  },
                  {
                    "type": "boolean"
                  },
                  {
                    "type": "array",
                    "minItems": 1,
                    "items": {
                      "anyOf": [
                        {
                          "type": "string"
                        },
                        {
                          "type": "number"
                        },
                        {
                          "type": "boolean"
                        }
                      ]
                    }
                  }
                ]
              }
            },
            "required": [
              "filter_type",
              "type",
              "value"
            ],
            "additionalProperties": false
          },
          {
            "type": "object",
            "properties": {
              "op": {
                "type": "string",
                "description": "Logical operator for conditions.",
                "enum": [
                  "and",
                  "or"
                ]
              },
              "conditions": {
                "type": "array",
                "description": "Nested filter conditions.",
                "minItems": 1,
                "items": {
                  "$ref": "T0"
                }
              }
            },
            "required": [
              "op",
              "conditions"
            ],
            "additionalProperties": false
          }
        ]
      }
    }
  }
  ```
</details>

## Output Schema

| Name            | Type     | Required | Default | Description |
| --------------- | -------- | -------- | ------- | ----------- |
| `result.status` | `string` | Yes      |         |             |
| `result.result` | `object` | Yes      |         |             |

<details>
  <summary>Show raw output schema</summary>

  ### Output JSON Schema

  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "status": {
        "type": "string"
      },
      "result": {
        "type": "object",
        "properties": {
          "data": {
            "type": "object",
            "properties": {
              "companies": {
                "type": "array",
                "items": {
                  "type": "object",
                  "properties": {
                    "company_name": {
                      "type": "string"
                    },
                    "company_domain": {
                      "type": "string"
                    },
                    "industry": {
                      "type": "string"
                    },
                    "employee_count": {
                      "type": "integer"
                    }
                  },
                  "required": [
                    "company_name",
                    "company_domain",
                    "industry",
                    "employee_count"
                  ],
                  "additionalProperties": true
                }
              },
              "meta": {
                "type": "object",
                "properties": {
                  "totalCount": {
                    "type": "integer"
                  },
                  "nextCursor": {
                    "type": "string"
                  },
                  "limit": {
                    "type": "integer"
                  },
                  "hasMore": {
                    "type": "boolean"
                  }
                },
                "required": [
                  "totalCount",
                  "nextCursor",
                  "limit",
                  "hasMore"
                ],
                "additionalProperties": true
              }
            },
            "required": [
              "companies",
              "meta"
            ],
            "additionalProperties": true
          }
        },
        "required": [
          "data"
        ],
        "additionalProperties": true
      }
    },
    "required": [
      "status",
      "result"
    ],
    "additionalProperties": true
  }
  ```
</details>

## Advanced: Direct CLI

<Info>
  Use direct execution for single payload debugging.
</Info>

```bash theme={null}
deepline tools execute crustdata_companydb_search --payload '{
  "filters": [
    {
      "filter_type": "hq_country",
      "type": "=",
      "value": "USA"
    }
  ]
}' --json
```

### CLI flags

| Flag                        | Description                                         |
| --------------------------- | --------------------------------------------------- |
| `--json`                    | Print machine-readable output.                      |
| `--wait`                    | Wait for terminal provider status when supported.   |
| `--debug`                   | Enable wait mode with additional status/log output. |
| `--wait-timeout SECONDS`    | Max seconds to wait in wait mode.                   |
| `--poll-interval SECONDS`   | Polling interval in seconds during wait mode.       |
| `--timeout SECONDS`         | Request timeout in seconds.                         |
| `--connect-timeout SECONDS` | Connection timeout in seconds.                      |

## Provider API Context

<details>
  <summary>Show provider reference (optional)</summary>

  ```md theme={null}
  ## Core Company Fields | **Field Name** | **Description** | **Data type** | **Example value** | | -------------- | --------------- | -------- | ------------------- | | `company_id` | Unique company identifier | number | `896015` | | `company_name` | Company name | string | `"Feedzai"` | | `year_founded` | Year the company was founded | number | `2010` | | `company_type` | Type of company | string | `"Privately Held"` | | `acquisition_status` | Acquisition status | string | `acquired` | | `ipo_date` | IPO date if public | date | `"2021-03-15"` | | `fiscal_year_end` | Fiscal year end month | string | `December` | ## Location Fields | **Field Name** | **Description** | **Data type** | **Example value** | | -------------- | --------------- | -------- | ------------------- | | `hq_country` | Headquarters country (ISO 3-alpha format, e.g., USA, GBR, CAN) | string | `"USA"` | | `hq_street_address_and_city` | HQ street address and city | string | `"123 Main St, San Francisco"` | | `hq_location` | Full HQ location | string | `"San Francisco, California, United States"` | | `hq_location_address_components` | HQ address hierarchy components (city, state, country) | array | `["San Francisco", "California", "United States"]` | | `largest_headcount_country` | Country with most employees (ISO 3-alpha format) | string | `"USA"` | | `office_addresses` | All office locations | array | `["San Francisco, CA", "New York, NY"]` | ## Company Size & Employee Metrics | **Field Name** | **Description** | **Data type** | **Example value** | | -------------- | --------------- | -------- | ------------------- | | `employee_count_range` | Employee count range | string | `"201-500"` | | `employee_metrics.latest_count` | Latest employee count | number | `350` | | `employee_metrics.growth_1m` | 1-month employee growth (absolute) | number | `15` | | `employee_metrics.growth_3m` | 3-month employee growth (absolute) | number | `45` | | `employee_metrics.growth_6m` | 6-month employee growth (absolute) | number | `80` | | `employee_metrics.growth_12m` | 12-month employee growth (absolute) | number | `150` | | `employee_metrics.growth_1m_percent` | 1-month employee growth (%) | number | `4.5` | | `employee_metrics.growth_3m_percent` | 3-month employee growth (%) | number | `14.7` | | `employee_metrics.growth_6m_percent` | 6-month employee growth (%) | number | `29.6` | | `employee_metrics.growth_12m_percent` | 12-month employee growth (%) | number | `75.0` | ## Financial Metrics | **Field Name** | **Description** | **Data type** | **Example value** | | -------------- | --------------- | -------- | ------------------- | | `estimated_revenue_lower_bound_usd` | Estimated minimum annual revenue (USD) | number | `10000000` | | `estimated_revenue_higher_bound_usd` | Estimated maximum annual revenue (USD) | number | `50000000` | | `crunchbase_total_investment_usd` | Total funding raised (USD) | number | `25000000` | | `crunchbase_valuation_usd` | Latest valuation (USD) | number | `100000000` | | `crunchbase_valuation_lower_bound_usd` | Minimum valuation estimate (USD) | number | `80000000` | | `last_funding_round_investment_usd` | Amount raised in last round (USD) | number | `15000000` | | `last_funding_round_type` | Type of last funding round | string | `"Series B"` | | `last_funding_date` | Date of last funding round | date | `"2023-06-01"` | ## Social Media & Follower Metrics | **Field Name** | **Description** | **Data type** | **Example value** | | -------------- | --------------- | -------- | ------------------- | | `follower_metrics.latest_count` | Latest LinkedIn follower count | number | `5000` | | `follower_metrics.growth_1m` | 1-month follower growth (absolute) | number | `150` | | `follower_metrics.growth_3m` | 3-month follower growth (absolute) | number | `400` | | `follower_metrics.growth_6m` | 6-month follower growth (absolute) | number | `750` | | `follower_metrics.growth_12m` | 12-month follower growth (absolute) | number | `1200` | | `follower_metrics.growth_1m_percent` | 1-month follower growth (%) | number | `3.1` | | `follower_metrics.growth_3m_percent` | 3-month follower growth (%) | number | `8.7` | | `follower_metrics.growth_6m_percent` | 6-month follower growth (%) | number | `17.6` | | `follower_metrics.growth_12m_percent` | 12-month follower growth (%) | number | `31.6` | ## Industry & Categories | **Field Name** | **Description** | **Data type** | **Example value** | | -------------- | --------------- | -------- | ------------------- | | `linkedin_industries` | LinkedIn industry classifications | array | `["Software Development", "Technology"]` | | `linkedin_categories` | LinkedIn category tags | array | `["Enterprise Software", "B2B"]` | | `crunchbase_categories` | Crunchbase category tags | array | `["SaaS", "Enterprise Software"]` | | `markets` | Target markets | array | `["Enterprise", "SMB"]` | ## Web Presence & Identifiers | **Field Name** | **Description** | **Data type** | **Example value** | | -------------- | --------------- | -------- | ------------------- | | `company_website` | Full company website URL | string | `"https://www.feedzai.com/"` | | `company_website_domain` | Company website domain | string | `"feedzai.com"` | | `domains` | All known domains associated with company | array | `["feedzai.com"]` | | `logo_permalink` | Permanent URL to company logo | string | `"https://crustdata-media.s3.us-east-2.amazonaws.com/company/ee4c81bb..."` | | `linkedin_profile_name` | LinkedIn profile slug | string | `"Feedzai"` | | `linkedin_profile_url` | LinkedIn company profile URL | string | `"https://www.linkedin.com/company/feedzai2"` | | `linkedin_id` | LinkedIn company ID | string | `"3052223"` | | `linkedin_company_description` | Company description from LinkedIn | string | `"Feedzai, transforms account opening for financial institutions..."` | | `crunchbase_uuid` | Crunchbase unique identifier | string | `"69d91137-499e-467f-ec47-c2e972e9e18a"` | | `crunchbase_profile_url` | Crunchbase profile

  &lt;Note>
  Provider reference truncated for page speed. Use the provider's official docs for the full upstream reference.
  &lt;/Note>
  ```
</details>

## Cost

* Pricing model: `per_result` (per result).
* Estimated Deepline credits: `0.4` per pricing unit.
* Billing mode: `post_deduct`.