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: example:
|
|
date | string | example:
|
|
datetime | string | example:
|
|
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 example: |
|
enum | string | example:
|
|
enum_multi | array | example:
|
|
identifier | object | example: |
|
identifier_multi | array | example: |
|
integer | number | example:
|
|
money | object | example: |
|
money_decimal | object | example: |
|
uuid | string | Serves as the unique identifier of an entity. More details can be found here. example:
|
|
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:
| n/a |
text_blob | string | example:
| n/a |
text_long | string | example:
|
|
text_short | string | example:
|
|
link | object | A link is a fully-qualified (http or https) website reference (e.g. website url, facebook url, etc.) example:
| n/a |
url | string | A link is a fully-qualified (http or https) website reference (e.g. website url, facebook url, etc.) example:
|
|
image_id | string | id of the image | n/a |
Available Operators
Operator Name | Value | Description |
---|---|---|
Blank |
| Only values: example:
|
Equal |
| example: |
Not equal |
| example: |
Greater than |
| example: |
Greater than or equal |
| example: |
Less than |
| example: |
Less than or equal |
| example: |
Starts |
| example: |
Contains |
| example: |
Does not contain |
| example: |
Between |
| example: |
Includes |
| example: |
Does not include |
| example: |
Includes all | "operator_id": "includes_all"` | example: |
Does not include all | "operator_id": "not_includes_all"` | example: |
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: example2: |
Domain Includes | "operator_id": "domain_includes" | Similar to domain_eq but enables domain search on multiple domains at once example: |