Elasticsearch DSL
Data type:
Query type:
URL:
Clean Company
Elasticsearch DSL
https://api.coresignal.com/cdapi/v2/company_clean/search/es_dsl
Overview
Use the /v2/company_clean/search/es_dsl endpoint to find company data matching your specifications.
Elasticsearch schema
Elasticsearch schema
"mappings": {
"properties": {
"id": {
"type": "long"
},
"name": {
"type": "text"
},
"type": {
"type": "keyword",
"null_value": "NULL"
},
"founded": {
"type": "keyword"
},
"followers": {
"type": "long",
"null_value": -1
},
"websites_main_original": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"websites_main": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"websites_resolved": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"websites_facebook": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"websites_twitter": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"websites_professional_network": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"size_range": {
"type": "keyword",
"null_value": "NULL"
},
"size_employees_count": {
"type": "long",
"null_value": -1
},
"industry": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"description": {
"type": "text"
},
"location_hq_raw_address": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"location_hq_country": {
"type": "keyword",
"null_value": "NULL"
},
"location_hq_regions": {
"type": "text"
},
"last_updated": {
"type": "date",
"format": "yyyy-MM-dd"
},
"logo": {
"type": "binary"
},
"specialities": {
"type": "text",
"fields": {
"exact": {
"type": "keyword"
}
}
},
"ticker": {
"type": "keyword"
},
"exchange": {
"type": "keyword"
},
"enriched_summary": {
"type": "text"
},
"enriched_keywords": {
"type": "keyword"
},
"enriched_b2b": {
"type": "long"
},
"enriched_category": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"metadata_title": {
"type": "text"
},
"metadata_description": {
"type": "text"
},
"professional_network_source_id": {
"type": "keyword"
},
"funding_rounds": {
"type": "nested",
"properties": {
"last_round_investors_count": {
"type": "long",
"null_value": -1
},
"total_rounds_count": {
"type": "long",
"null_value": -1
},
"last_round_type": {
"type": "keyword",
"null_value": "NULL"
},
"last_round_date": {
"type": "date",
"format": "yyyy-MM-dd"
},
"last_round_money_raised": {
"type": "long",
"null_value": -1
},
"financial_website_url": {
"type": "keyword"
}
}
},
"expired_domain": {
"type": "boolean"
},
"unique_domain": {
"type": "boolean"
},
"unique_website": {
"type": "boolean"
},
"phone_numbers": {
"type": "keyword"
},
"emails": {
"type": "text"
},
"pricing_available": {
"type": "boolean"
},
"free_trial_available": {
"type": "boolean"
},
"demo_available": {
"type": "boolean"
},
"is_downloadable": {
"type": "boolean"
},
"mobile_apps_exist": {
"type": "boolean"
},
"online_reviews_exist": {
"type": "boolean"
},
"api_docs_exist": {
"type": "boolean"
},
"social_discord_urls": {
"type": "text"
},
"social_facebook_urls": {
"type": "text"
},
"social_instagram_urls": {
"type": "text"
},
"social_professional_network_urls": {
"type": "text"
},
"social_pinterest_urls": {
"type": "text"
},
"social_tiktok_urls": {
"type": "text"
},
"social_twitter_urls": {
"type": "text"
},
"social_x_urls": {
"type": "text"
},
"social_youtube_urls": {
"type": "text"
},
"social_github_urls": {
"type": "text"
},
"social_reddit_urls": {
"type": "text"
},
"locations_full": {
"type": "nested",
"properties": {
"location_address": {
"type": "keyword",
"null_value": "NULL"
},
"is_primary": {
"type": "boolean"
}
}
},
"technologies": {
"type": "nested",
"properties": {
"technology": {
"type": "text"
},
"first_verified_at": {
"type": "date",
"format": "yyyy-MM-dd"
},
"last_verified_at": {
"type": "date",
"format": "yyyy-MM-dd"
}
}
},
"updates": {
"type": "nested",
"properties": {
"urn": {
"type": "text"
},
"followers": {
"type": "long"
},
"date": {
"type": "text"
},
"description": {
"type": "text"
},
"reactions_count": {
"type": "long"
},
"comments_count": {
"type": "long"
},
"reshared_post_author": {
"type": "text"
},
"reshared_post_author_url": {
"type": "text"
},
"reshared_post_author_headline": {
"type": "text"
},
"reshared_post_description": {
"type": "text"
},
"reshared_post_date": {
"type": "text"
},
"reshared_post_followers": {
"type": "long"
}
}
},
"created_at": {
"type": "date",
"format": "yyyy-MM-dd"
}
}
}Possible input values
You can look for available input values in the general Elasticsearch DSL topic and find the lists of the following fields:
type
size_range
industry
location_hq_regions
last_round_type
Sorting options
Find several examples of the available sorting options. All information about the sorting is in the general Elasticsearch DSL topic.
Sort by score
{
"query": {
"bool": {
"must": [
{
"query_string": {
"query": "2023",
"default_field": "founded",
"default_operator": "and"
}
}
]
}
},
"sort": [
"_score"
]
}Sort by id
{
"query": {
"bool": {
"must": [
{
"query_string": {
"query": "2023",
"default_field": "founded",
"default_operator": "and"
}
}
]
}
},
"sort": [
"id"
]
}Additional sorting fields
Clean 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:
followers,size_employees_count
Last updated
Was this helpful?