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 NameData TypeDescriptionSearch Operators (if field is searchable)
booleanbooleanPossible values: true or false

example:
"is_lead_investor": "true"
- equal
- blank
datestringexample:
"announced_on": "2015-02-05"
- equal
- blank
- greater than or equal to (i.e. "After")
- less than or equal to (i.e. "Before")
datetimestringexample:
"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_precisionobjectThis 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")
enumstringexample:
"operating_status" = "active"
- equal / not equal
- blank
- includes / not includes
enum_multiarrayexample:
"facet_ids": ["investor", "company"]
- blank
- includes / not includes
- includes all / not includes all
identifierobjectexample:
"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_multiarrayexample:
"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
integernumberexample:
"num_investors": 5
- equal / not equal
- blank
- greater than or equal to
- less than or equal to
- between
moneyobjectexample:
"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_decimalobjectexample:
"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
uuidstringServes as the unique identifier of an entity. More details can be found here.

example:
"uuid" = "74a20af3-f4dd-6188-de60-c4ee6cd0ca4a"
- equal
- blank
- includes
permalinkstringServes 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_blobstringexample:
"legal name" = "Internal Business Machines"
n/a
text_longstringexample:
"description" = "Twitter is a social networking platform that allows..."
- blank
- contains / not contains
text_shortstringexample:
"last name" = "Benioff"
- equal / not equal
- blank
- starts with
- contains / not contains
linkobjectA 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
urlstringA 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_idstringid of the imagen/a

Available Operators

Operator NameValueDescription
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"]
}