Elasticsearch DSL: Base Company API

Data type:

Query type:

URL:

Base Company

Elasticsearch DSL

https://api.coresignal.com/cdapi/v2/company_base/search/es_dsl

---

Overview

Use the /v2/company_base/search/es_dsl endpoint for more sophisticated queries and retrieve company data.

General Elasticsearch DSL information and usage tips

Elasticsearch schema

Elasticsearch schema

Endpoint schema

{
    "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
                    }
                }
            }
        }
    }
}

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.

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": {
      "match":{
         "name":{
            "query":"Example Company",
            "operator":"and"
         }
      }
   },
    "sort": [
        "_score"
    ]
}

Sort by id

Additional sorting fields

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