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 Name
Data Type
Description
Search Operators (if field is searchable)
boolean
boolean
Possible values: true
or false
example:
"is_lead_investor": "true"
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"
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"
image_id
string
id of the image
n/a
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"]
}