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.

General Elasticsearch DSL information and usage tips

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.

Sort by score

Sort by score

{
   "query": {
      "bool": {
         "must": [
            {
               "query_string": {
                  "query": "2023",
                  "default_field": "founded",
                  "default_operator": "and"
               }
            }
         ]
      }
   },
      "sort": [
      "_score"
   ]
}

Sort by id

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