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