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"
}
}
}Having trouble writing Elasticsearch queries on your own?
Explore AI query builder feature available in Self-service playground. Write a prompt, and AI assistant will automatically convert it into a query.
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.
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?