Elasticsearch DSL: Base Company API
Last updated
Was this helpful?
Data type:
Query type:
URL:
Base Company
Elasticsearch DSL
https://api.coresignal.com/cdapi/v2/company_base/search/es_dsl
Use the /v2/company_base/search/es_dsl endpoint for more sophisticated queries and retrieve company data.
Explore AI query builder feature available in Self-service playground. Write a prompt, and AI assistant will automatically convert it into a query.
Find several examples of the available sorting options. All information about the sorting is in the general Elasticsearch DSL topic.
Base Company includes additional numerical sorting options. Sorting is made in descending order by a selected field. If several fields have the same value, sorting is made by the last_updated field. If the last_updated values are also the same, sorting is then done by the id field. Sorting fields are listed below:
employees_count,
source_id
Last updated
Was this helpful?
Was this helpful?
{
"mappings": {
"properties": {
"id": {
"type": "long"
},
"url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword"
}
}
},
"hash": {
"type": "keyword",
"index": false,
"doc_values": false
},
"name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword"
}
}
},
"website": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"filter": {
"type": "text"
}
}
},
"size": {
"type": "keyword",
"null_value": "NULL"
},
"industry": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"description": {
"type": "text"
},
"followers": {
"type": "long",
"index": false,
"doc_values": false
},
"founded": {
"type": "long",
"null_value": 1000
},
"headquarters_city": {
"type": "keyword",
"index": false,
"doc_values": false
},
"headquarters_country": {
"type": "keyword",
"index": false,
"doc_values": false
},
"headquarters_state": {
"type": "keyword",
"index": false,
"doc_values": false
},
"headquarters_street1": {
"type": "text",
"index": false
},
"headquarters_street2": {
"type": "text",
"index": false
},
"headquarters_zip": {
"type": "keyword",
"index": false,
"doc_values": false
},
"headquarters_country_parsed": {
"type": "keyword",
"null_value": "NULL"
},
"headquarters_new_address": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"headquarters_country_restored": {
"type": "keyword",
"index": false,
"doc_values": false
},
"logo_url": {
"type": "keyword",
"index": false,
"doc_values": false
},
"last_response_code": {
"type": "long",
"index": false,
"doc_values": false
},
"source_id": {
"type": "long"
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
},
"type": {
"type": "text"
},
"employees_count": {
"type": "long",
"null_value": -1
},
"company_shorthand_name": {
"type": "keyword"
},
"company_shorthand_name_hash": {
"type": "keyword",
"index": false,
"doc_values": false
},
"canonical_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword"
}
}
},
"canonical_hash": {
"type": "keyword",
"index": false,
"doc_values": false
},
"canonical_shorthand_name": {
"type": "keyword"
},
"canonical_shorthand_name_hash": {
"type": "keyword",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte"
},
"last_updated_ux": {
"type": "long",
"index": false,
"doc_values": false
},
"company_affiliated_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"affiliated_company_url": {
"type": "text",
"index": false
},
"affiliated_company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_also_viewed_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"viewed_company_url": {
"type": "text",
"index": false
},
"viewed_company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_financial_website_info_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long"
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"financial_website_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword"
}
}
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_featured_employees_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"url": {
"type": "text",
"index": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_featured_investors_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"investor_id": {
"type": "long",
"index": false,
"doc_values": false
},
"round_id": {
"type": "long",
"index": false,
"doc_values": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
},
"company_investors_list": {
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"name": {
"type": "text",
"index": false
},
"hash": {
"type": "keyword",
"index": false,
"doc_values": false
},
"financial_website_url": {
"type": "text",
"index": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
}
}
}
}
},
"company_locations_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"location_address": {
"type": "text",
"index": false
},
"is_primary": {
"type": "byte",
"index": false,
"doc_values": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_similar_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"url": {
"type": "text",
"index": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_specialties_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long"
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"specialty": {
"type": "text"
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_stock_info_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long"
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"ticker": {
"type": "text"
},
"exchange": {
"type": "keyword",
"index": false,
"doc_values": false
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
},
"company_funding_rounds_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long"
},
"last_round_investors_count": {
"type": "long"
},
"total_rounds_count": {
"type": "long",
"null_value": -1
},
"last_round_type": {
"type": "keyword"
},
"last_round_date": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||uuuu",
"null_value": "1000"
},
"last_round_money_raised": {
"type": "keyword"
},
"financial_website_url": {
"type": "keyword"
},
"created": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss"
},
"deleted": {
"type": "byte"
}
}
},
"company_updates_collection": {
"type": "nested",
"properties": {
"id": {
"type": "long",
"index": false,
"doc_values": false
},
"company_id": {
"type": "long",
"index": false,
"doc_values": false
},
"urn": {
"type": "text",
"index": false
},
"followers": {
"type": "long",
"index": false,
"doc_values": false
},
"date": {
"type": "keyword",
"index": false,
"doc_values": false
},
"description": {
"type": "text",
"index": false
},
"reactions_count": {
"type": "long",
"index": false,
"doc_values": false
},
"comments_count": {
"type": "long",
"index": false,
"doc_values": false
},
"reshared_post_author": {
"type": "text",
"index": false
},
"reshared_post_author_url": {
"type": "text",
"index": false
},
"reshared_post_author_headline": {
"type": "text",
"index": false
},
"reshared_post_description": {
"type": "text",
"index": false
},
"reshared_post_followers": {
"type": "long",
"index": false,
"doc_values": false
},
"reshared_post_date": {
"type": "keyword",
"index": false,
"doc_values": false
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss",
"index": false,
"doc_values": false
},
"deleted": {
"type": "byte",
"index": false,
"doc_values": false
}
}
}
}
}
}
curl -X 'POST' \
'https://api.coresignal.com/cdapi/v2/company_base/search/es_dsl' \
-H 'accept: application/json' \
-H 'apikey: {API Key}' \
-H 'Content-Type: application/json' \
-d '{
"query":{
"bool":{
"must":[
{
"query_string":{
"query":"2023",
"default_field":"founded",
"default_operator":"and"
}
}
]
}
}
}'{
"query": {
"match":{
"name":{
"query":"Example Company",
"operator":"and"
}
}
},
"sort": [
"_score"
]
}{
"query": {
"bool": {
"filter": [
{
"range": {
"employees_count": {
"gte": 100
}
}
}
]
}
},
"sort": [
"id"
]
}