Getting StartedAPI Documentation
API Documentation
About UsGo to Crunchbase
Start typing to search…

Available Field Types & Operators

We used various field types to represent the data in the Crunchbase graph. In addition to providing the necessary structure for our graph (e.g. boolean vs. string vs. array, max length, etc.), field types also control what you can and cannot do with our data.

For example, field types control which data field is searchable as well as the search operator (e.g. equal, includes, contains, is blank, etc.) you can use via our search API.

Below is a list of available field types and operators for your reference.

note: if you notice anything that is missing or incorrect, please let your CSM know or use the "Suggest Edits" button to let us know. Thanks!

Field Type List

Field Type Name

Data Type

Description

Search Operators (if field is searchable)

boolean

boolean

Possible values: true or false

example:

"is_lead_investor": "true"
  • equal
  • blank

date

string

example:

"announced_on": "2015-02-05"
  • equal
  • blank
  • greater than or equal to (i.e. "After")
  • less than or equal to (i.e. "Before")

datetime

string

example:

"created_at": "2015-02-02T23:00:05Z"
  • equal
  • blank
  • greater than or equal to (i.e. "After")
  • less than or equal to (i.e. "Before")

date_precision

object

This is used when a date field does not require a date to have a year, month, or day. More details can be found here.

Possible values for "precision": day, month, year, none

example:
"founded_on": {
"value": "2014-10-01",
"precision": "month"
}

  • equal
  • blank
  • greater than or equal to (i.e. "After")
  • less than or equal to (i.e. "Before")

enum

string

example:

"operating_status" = "active"
  • equal / not equal
  • blank
  • includes / not includes

enum_multi

array

example:

"facet_ids": ["investor", "company"]
  • blank
  • includes / not includes
  • includes all / not includes all

identifier

object

example:
"identifier": {
"uuid": "74a20af3-f4dd-6188-de60-c4ee6cd0ca4a",
"value": "Ant Financial",
"image_id": "ou8jmfz9upjucrzhhkgm",
"permalink": "ant-financial",
"entity_def_id": "organization"
}

  • equal / not equal
  • blank
  • starts with
  • contains / not contains
  • includes / not includes
  • includes all / not includes all

identifier_multi

array

example:
"categories": [
{"uuid": "275ddcbc-27de-ff4f-4e50-6dc26ebf9570",
"value": "E-Commerce",
"permalink": "e-commerce-275d",
"entity_def_id": "category"},
{"uuid": "90b4194f-1d4f-ff5c-d7a6-6b6f32ae4892",
"value": "Financial Services",
"permalink": "financial-services",
"entity_def_id": "category"}
]

  • blank
  • includes / not includes
  • includes all / not includes all

integer

number

example:

"num_investors": 5
  • equal / not equal
  • blank
  • greater than or equal to
  • less than or equal to
  • between

money

object

example:
"money_raised": {
"value": 30000000,
"currency": "USD",
"value_usd": 30000000
}

  • equal / not equal
  • blank
  • greater than or equal to
  • less than or equal to
  • between

money_decimal

object

example:
"ipo_share_price": {
"value": 45.10,
"currency": "USD",
"value_usd": 30000000
}

  • equal / not equal
  • blank
  • greater than or equal to
  • less than or equal to
  • between

uuid

string

Serves as the unique identifier of an entity. More details can be found here.

example:

"uuid" = "74a20af3-f4dd-6188-de60-c4ee6cd0ca4a"
  • equal
  • blank
  • includes

permalink

string

Serves as the unique identifier of an entity and is a more human-readable version of an identifier (compare to UUID).

It can be used interchangeably with UUID to reference a specific entity./

example:

"permalink" = "ant-financial"

n/a

text_blob

string

example:

"legal name" = "Internal Business Machines"

n/a

text_long

string

example:

"description" = "Twitter is a social networking platform that allows..."
  • blank
  • contains / not contains

text_short

string

example:

"last name" = "Benioff"
  • equal / not equal
  • blank
  • starts with
  • contains / not contains

link

object

A link is a fully-qualified (http or https) website reference (e.g. website url, facebook url, etc.)

example:

"website" = "https://www.crunchbase.com"

n/a

url

string

A link is a fully-qualified (http or https) website reference (e.g. website url, facebook url, etc.)

example:

"website_url": 
"https://www.crunchbase.com"
  • domain_eq

image_id

string

id of the image

n/a

Available Operators

Operator Name

Value

Description

Blank

"operator_id": "blank"

Only values: true or false

example:
{
"type": "predicate",
"field_id": "funded_organization_categories",
"operator_id": "blank",
"values": [false]
}

Equal

"operator_id": "eq"

example:
{
"type": "predicate",
"field_id": "identifier",
"operator_id": "eq",
"values": ["corevist-series-a--6ac64541"]
}

Not equal

"operator_id": "not_eq"

example:
{
"type": "predicate",
"field_id": "funded_organization_funding_stage",
"operator_id": "not_eq",
"values": ["early_stage_venture"]
}

Greater than

"operator_id": "gt"

example:
{
"type": "predicate",
"field_id": "founded_on",
"operator_id": "gte",
"values": ["07/18/2012"]
}

Greater than or equal

"operator_id": "gte"

example:
{
"type": "predicate",
"field_id": "announced_on",
"operator_id": "gte",
"values": ["2012"]
}

Less than

"operator_id": "lt"

example:
{
"type": "predicate",
"field_id": "money_raised",
"operator_id": "lt",
"values": [
{
"currency": "USD",
"value": 5000000
}
]
}

Less than or equal

"operator_id": "lte"

example:
{
"type": "predicate",
"field_id": "money_raised",
"operator_id": "lte",
"values": [
{
"currency": "USD",
"value": 5000000
}
]
}

Starts

"operator_id": "starts"

example:
{
"type": "predicate",
"field_id": "name",
"operator_id": "starts",
"values": ["Sequoia"]
}

Contains

"operator_id": "contains"

example:
{
"type": "predicate",
"field_id": "description",
"operator_id": "contains",
"values": ["SaaS"]
}

Does not contain

"operator_id": "not_contains"

example:
{
"type": "predicate",
"field_id": "description",
"operator_id": "not_contains",
"values": ["mobile"]
}

Between

"operator_id": "between"

example:
{
"type": "predicate",
"field_id": "money_raised",
"operator_id": "between",
"values": [
{
"currency": "USD",
"value": 5000000
},
{
"currency": "USD",
"value": 9000000
}
]
}

Includes

"operator_id": "includes"

example:
{
"type": "predicate",
"field_id": "funded_organization_funding_stage",
"operator_id": "includes",
"values": ["early_stage_venture", "ipo"]
}

Does not include

"operator_id": "not_includes"

example:
{
"type": "predicate",
"field_id": "funded_organization_funding_stage",
"operator_id": "not_includes",
"values": ["early_stage_venture", "ipo"]
}

Includes all

"operator_id": "includes_all"`

example:
{
"type": "predicate",
"field_id": "funded_organization_categories",
"operator_id": "not_includes_all",
"values": ["edtech", "software"]
}

Does not include all

"operator_id": "not_includes_all"`

example:
{
"type": "predicate",
"field_id": "funded_organization_funding_stage",
"operator_id": "not_includes_all",
"values": ["early_stage_venture"]
}

Domain Equal

"operator_id": "domain_eq"

note: this operator will only extract the domain portion of the input values. e.g. for both "comcast.com" and "www.comcast.com", the operator will extract and only use the domain portion of the input, which is "comcast.com".

example:
{
"type": "predicate",
"field_id": "website_url",
"operator_id": "domain_eq",
"values": ["comcast.com"]
}

example2:
{
"type": "predicate",
"field_id": "website_url",
"operator_id": "domain_eq",
"values": ["www.comcast.com"]
}