Elasticsearch DSL: Multi-source Company API

Data type:

Query type:

URL:

Multi-source Company

Elasticsearch DSL

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

---

Overview

Use the /v2/company_multi_source/search/es_dsl endpoint to find company data matching your specifications.

General Elasticsearch DSL information and usage tips

Elasticsearch schema

Elasticsearch schema

Elasticsearch structure maps directly to our Multi-source Company data fields:

{
    "mappings": {
        "properties": {
            "id": {
                "type": "long"
            },
            "source_id": {
                "type": "text"
            },
            "company_name": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "company_name_alias":  {
                "type": "keyword"
            },
            "company_legal_name": {
                "type": "text"
            },
            "company_logo": {
                "type": "text"
            },
            "company_logo_url": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "website": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    },
                    "domain_only": {
                        "type": "text"
                    }
                }
            },
            "website_domain": {
                "type": "keyword",
                "null_value": "NULL"
            },
            "website_alias": {
                "type": "text"
            },
            "professionnal_network_url": {
                "type": "text"
            },
            "canonical_professionnal_network_url": {
                "type": "keyword",
                "null_value": "NULL",
                "fields": {
                    "domain_only": {
                        "type": "text"
                    }
                }
            },
            "twitter_url": {
                "type": "text"
            },
            "discord_url": {
                "type": "text"
            },
            "facebook_url": {
                "type": "text"
            },
            "instagram_url": {
                "type": "text"
            },
            "pinterest_url": {
                "type": "text"
            },
            "tiktok_url": {
                "type": "text"
            },
            "youtube_url": {
                "type": "text"
            },
            "github_url": {
                "type": "text"
            },
            "reddit_url": {
                "type": "text"
            },
            "financial_website_url": {
                "type": "text"
            },
            "stock_ticker": {
                "type": "nested",
                "properties": {
                    "exchange": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "ticker": {
                        "type": "keyword"
                    }
                }
            },
            "top_previous_companies": {
                "type": "nested",
                "properties": {
                    "company_id": {
                        "type": "long"
                    },
                    "company_name": {
                        "type": "text"
                    },
                    "count": {
                        "type": "long"
                    }
                }
            },
            "top_next_companies": {
                "type": "nested",
                "properties": {
                    "company_id": {
                        "type": "long"
                    },
                    "company_name": {
                        "type": "text"
                    },
                    "count": {
                        "type": "long"
                    }
                }
            },
            "is_b2b": {
                "type": "byte"
            },
            "industry": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            },
            "sic_codes": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "naics_codes": {
                "type": "text",
                "fields": {
                    "exact": {
                        "type": "keyword"
                    }
                }
            },
            "categories_and_keywords": {
                "type": "text"
            },
            "description": {
                "type": "text"
            },
            "description_enriched": {
                "type": "text"
            },
            "description_metadata_raw": {
                "type": "text"
            },
            "type": {
                "type": "keyword"
            },
            "status": {
                "properties": {
                    "value": {
                        "type": "text"
                    },
                    "comment": {
                        "type": "text"
                    }
                }
            },
            "founded_year": {
                "type": "text"
            },
            "size_range": {
                "type": "keyword",
                "null_value": "NULL"
            },
            "employees_count": {
                "type": "long"
            },
            "followers_count_professionnal_network": {
                "type": "long"
            },
            "followers_count_twitter": {
                "type": "long"
            },
            "followers_count_owler": {
                "type": "long"
            },
            "hq_region": {
                "type": "text"
            },
            "hq_country": {
                "type": "text"
            },
            "hq_country_iso2": {
                "type": "text"
            },
            "hq_country_iso3": {
                "type": "text"
            },
            "hq_location": {
                "type": "text"
            },
            "hq_full_address": {
                "type": "text"
            },
            "hq_city": {
                "type": "text"
            },
            "hq_state": {
                "type": "text"
            },
            "hq_street": {
                "type": "text"
            },
            "hq_zipcode": {
                "type": "text"
            },
            "company_locations_full": {
                "type": "nested",
                "properties": {
                    "location_address": {
                        "type": "text"
                    },
                    "is_primary": {
                        "type": "long"
                    }
                }
            },
            "is_public": {
                "type": "boolean"
            },
            "ipo_date": {
                "type": "date",
                "format": "yyyy-MM-dd"
            },
            "ipo_share_price": {
                "type": "long"
            },
            "ipo_share_price_currency": {
                "type": "text"
            },
            "revenue_annual_range": {
                "properties": {
                    "source_4_annual_revenue_range": {
                        "properties": {
                            "annual_revenue_range_from": {
                                "type": "double"
                            },
                            "annual_revenue_range_to": {
                                "type": "double"
                            },
                            "annual_revenue_range_currency": {
                                "type": "text"
                            }
                        }
                    },
                    "source_6_annual_revenue_range": {
                        "properties": {
                            "annual_revenue_range_from": {
                                "type": "double"
                            },
                            "annual_revenue_range_to": {
                                "type": "double"
                            },
                            "annual_revenue_range_currency": {
                                "type": "text"
                            }
                        }
                    }
                }
            },
            "revenue_annual": {
                "properties": {
                    "source_5_annual_revenue": {
                        "properties": {
                            "annual_revenue": {
                                "type": "long"
                            },
                            "annual_revenue_currency": {
                                "type": "text"
                            }
                        }
                    },
                    "source_1_annual_revenue": {
                        "properties": {
                            "annual_revenue": {
                                "type": "double"
                            },
                            "annual_revenue_currency": {
                                "type": "text"
                            }
                        }
                    }
                }
            },
            "revenue_quarterly": {
                "properties": {
                    "value": {
                        "type": "double"
                    },
                    "currency": {
                        "type": "text"
                    }
                }
            },
            "income_statements": {
                "type": "nested",
                "properties": {
                    "cost_of_goods_sold": {
                        "type": "double"
                    },
                    "cost_of_goods_sold_currency": {
                        "type": "text"
                    },
                    "ebit": {
                        "type": "double"
                    },
                    "ebitda": {
                        "type": "double"
                    },
                    "ebitda_margin": {
                        "type": "double"
                    },
                    "ebit_margin": {
                        "type": "double"
                    },
                    "earnings_per_share": {
                        "type": "double"
                    },
                    "gross_profit": {
                        "type": "double"
                    },
                    "gross_profit_margin": {
                        "type": "double"
                    },
                    "income_tax_expense": {
                        "type": "double"
                    },
                    "interest_expense": {
                        "type": "double"
                    },
                    "interest_income": {
                        "type": "double"
                    },
                    "net_income": {
                        "type": "double"
                    },
                    "period_display_end_date": {
                        "type": "text"
                    },
                    "period_end_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "period_type": {
                        "type": "text"
                    },
                    "pre_tax_profit": {
                        "type": "long"
                    },
                    "revenue": {
                        "type": "long"
                    },
                    "total_operating_expense": {
                        "type": "long"
                    }
                }
            },
            "stock_information": {
                "type": "nested",
                "properties": {
                    "closing_price": {
                        "type": "double",
                        "index": false
                    },
                    "currency": {
                        "type": "text",
                        "index": false
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd",
                        "index": false
                    },
                    "marketcap": {
                        "type": "double",
                        "index": false
                    }
                }
            },
            "last_funding_round_name": {
                "type": "text"
            },
            "last_funding_round_announced_date": {
                "type": "date",
                "format": "yyyy-MM-dd"
            },
            "last_funding_round_lead_investors": {
                "type": "text"
            },
            "last_funding_round_amount_raised": {
                "type": "long"
            },
            "last_funding_round_amount_raised_currency": {
                "type": "text"
            },
            "last_funding_round_num_investors": {
                "type": "long"
            },
            "funding_rounds": {
                "type": "nested",
                "properties": {
                    "name": {
                        "type": "text"
                    },
                    "announced_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "lead_investors": {
                        "type": "text"
                    },
                    "amount_raised": {
                        "type": "long"
                    },
                    "amount_raised_currency": {
                        "type": "text"
                    },
                    "num_investors": {
                        "type": "long"
                    }
                }
            },
            "ownership_status": {
                "type": "text"
            },
            "parent_company_information": {
                "properties": {
                    "parent_company_name": {
                        "type": "text"
                    },
                    "parent_company_website": {
                        "type": "text"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    }
                }
            },
            "acquired_by_summary": {
                "properties": {
                    "acquirer_name": {
                        "type": "text"
                    },
                    "announced_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "price": {
                        "type": "long"
                    },
                    "currency": {
                        "type": "text"
                    }
                }
            },
            "num_acquisitions_source_1": {
                "type": "long"
            },
            "acquisition_list_source_1": {
                "type": "nested",
                "properties": {
                    "acquiree_name": {
                        "type": "text"
                    },
                    "announced_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd",
                        "ignore_malformed": true
                    },
                    "price": {
                        "type": "text"
                    },
                    "currency": {
                        "type": "text"
                    }
                }
            },
            "num_acquisitions_source_2": {
                "type": "long"
            },
            "acquisition_list_source_2": {
                "type": "nested",
                "properties": {
                    "acquiree_name": {
                        "type": "text"
                    },
                    "announced_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "price": {
                        "type": "long"
                    },
                    "currency": {
                        "type": "text"
                    }
                }
            },
            "num_acquisitions_source_5": {
                "type": "long"
            },
            "acquisition_list_source_5": {
                "type": "nested",
                "properties": {
                    "acquiree_name": {
                        "type": "text"
                    },
                    "announced_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "price": {
                        "type": "text"
                    },
                    "currency": {
                        "type": "text"
                    }
                }
            },
            "competitors": {
                "type": "nested",
                "properties": {
                    "company_name": {
                        "type": "text"
                    },
                    "similarity_score": {
                        "type": "long"
                    }
                }
            },
            "competitors_websites": {
                "type": "nested",
                "properties": {
                    "website": {
                        "type": "text"
                    },
                    "similarity_score": {
                        "type": "long"
                    },
                    "total_website_visits_monthly": {
                        "type": "long"
                    },
                    "category": {
                        "type": "text"
                    },
                    "rank_category": {
                        "type": "long"
                    }
                }
            },
            "company_phone_numbers": {
                "type": "text"
            },
            "company_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"
            },
            "documentation_exist": {
                "type": "boolean"
            },
            "product_reviews_count": {
                "type": "long"
            },
            "product_reviews_aggregate_score": {
                "type": "double"
            },
            "product_reviews_score_distribution": {
                "properties": {
                    "score_1": {
                        "type": "long"
                    },
                    "score_2": {
                        "type": "long"
                    },
                    "score_3": {
                        "type": "long"
                    },
                    "score_4": {
                        "type": "long"
                    },
                    "score_5": {
                        "type": "long"
                    }
                }
            },
            "product_pricing_summary": {
                "type": "nested",
                "properties": {
                    "details": {
                        "type": "text"
                    },
                    "price": {
                        "type": "text"
                    },
                    "type": {
                        "type": "text"
                    }
                }
            },
            "num_news_articles": {
                "type": "long"
            },
            "news_articles": {
                "type": "nested",
                "properties": {
                    "headline": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "published_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "summary": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "article_url": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "source": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    }
                }
            },
            "num_technologies_used": {
                "type": "long"
            },
            "technologies_used": {
                "type": "nested",
                "properties": {
                    "technology": {
                        "type": "text"
                    },
                    "first_verified_at": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "last_verified_at": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    }
                }
            },
            "total_website_visits_monthly": {
                "type": "long"
            },
            "visits_change_monthly": {
                "type": "double"
            },
            "rank_global": {
                "type": "long"
            },
            "rank_country": {
                "type": "long"
            },
            "rank_category": {
                "type": "long"
            },
            "visits_breakdown_by_country": {
                "type": "nested",
                "properties": {
                    "country": {
                        "type": "text",
                        "index": false
                    },
                    "percentage": {
                        "type": "double",
                        "index": false
                    },
                    "percentage_monthly_change": {
                        "type": "double",
                        "index": false
                    }
                }
            },
            "visits_breakdown_by_gender": {
                "properties": {
                    "male_percentage": {
                        "type": "double",
                        "index": false
                    },
                    "female_percentage": {
                        "type": "double",
                        "index": false
                    }
                }
            },
            "visits_breakdown_by_age": {
                "properties": {
                    "age_18_24_percentage": {
                        "type": "double",
                        "index": false
                    },
                    "age_25_34_percentage": {
                        "type": "double",
                        "index": false
                    },
                    "age_35_44_percentage": {
                        "type": "double",
                        "index": false
                    },
                    "age_45_54_percentage": {
                        "type": "double",
                        "index": false
                    },
                    "age_55_64_percentage": {
                        "type": "double",
                        "index": false
                    },
                    "age_65_plus_percentage": {
                        "type": "double",
                        "index": false
                    }
                }
            },
            "bounce_rate": {
                "type": "double"
            },
            "pages_per_visit": {
                "type": "double"
            },
            "average_visit_duration_seconds": {
                "type": "double"
            },
            "similarly_ranked_websites": {
                "type": "text"
            },
            "top_topics": {
                "type": "text"
            },
            "company_employee_reviews_count": {
                "type": "long"
            },
            "company_employee_reviews_aggregate_score": {
                "type": "double"
            },
            "employee_reviews_score_breakdown": {
                "properties": {
                    "business_outlook": {
                        "type": "double"
                    },
                    "career_opportunities": {
                        "type": "double"
                    },
                    "ceo_approval": {
                        "type": "double"
                    },
                    "compensation_benefits": {
                        "type": "double"
                    },
                    "culture_values": {
                        "type": "double"
                    },
                    "diversity_inclusion": {
                        "type": "double"
                    },
                    "recommend": {
                        "type": "double"
                    },
                    "senior_management": {
                        "type": "double"
                    },
                    "work_life_balance": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_distribution": {
                "properties": {
                    "score_1": {
                        "type": "double"
                    },
                    "score_2": {
                        "type": "double"
                    },
                    "score_3": {
                        "type": "double"
                    },
                    "score_4": {
                        "type": "double"
                    },
                    "score_5": {
                        "type": "double"
                    }
                }
            },
            "active_job_postings_count": {
                "type": "long"
            },
            "active_job_postings_count_by_month": {
                "type": "nested",
                "properties": {
                    "active_job_postings_count": {
                        "type": "long"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "active_job_postings":{
                "type": "nested",
                "properties": {
                    "job_posting_id": {
                        "type": "long"
                    },
                    "job_posting_title": {
                        "type": "text"
                    }
                }
            },
            "base_salary": {
                "type": "nested",
                "properties": {
                    "title": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "salary_p25": {
                        "type": "double"
                    },
                    "salary_median": {
                        "type": "double"
                    },
                    "salary_p75": {
                        "type": "double"
                    },
                    "currency": {
                        "type": "keyword"
                    },
                    "pay_period": {
                        "type": "keyword"
                    },
                    "salary_updated_at": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    }
                }
            },
            "additional_pay": {
                "type": "nested",
                "properties": {
                    "title": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "additional_pay_values": {
                        "type": "nested",
                        "properties": {
                            "additional_pay_p25": {
                                "type": "double"
                            },
                            "additional_pay_median": {
                                "type": "double"
                            },
                            "additional_pay_p75": {
                                "type": "double"
                            },
                            "additional_pay_type": {
                                "type": "keyword"
                            }
                        }
                    },
                    "currency": {
                        "type": "keyword"
                    },
                    "pay_period": {
                        "type": "keyword"
                    },
                    "salary_updated_at": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    }
                }
            },
            "total_salary": {
                "type": "nested",
                "properties": {
                    "title": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "salary_p25": {
                        "type": "double"
                    },
                    "salary_median": {
                        "type": "double"
                    },
                    "salary_p75": {
                        "type": "double"
                    },
                    "currency": {
                        "type": "keyword"
                    },
                    "pay_period": {
                        "type": "keyword"
                    },
                    "salary_updated_at": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    }
                }
            },
            "employees_count_inferred": {
                "type": "long"
            },
            "employees_count_inferred_by_month": {
                "type": "nested",
                "properties": {
                    "employees_count_inferred": {
                        "type": "long"
                    },
                    "date": {
                        "type": "date"
                    }
                }
            },
            "employees_count_breakdown_by_seniority": {
                "properties": {
                    "employees_count_owner": {
                        "type": "long"
                    },
                    "employees_count_founder": {
                        "type": "long"
                    },
                    "employees_count_clevel": {
                        "type": "long"
                    },
                    "employees_count_partner": {
                        "type": "long"
                    },
                    "employees_count_vp": {
                        "type": "long"
                    },
                    "employees_count_head": {
                        "type": "long"
                    },
                    "employees_count_director": {
                        "type": "long"
                    },
                    "employees_count_manager": {
                        "type": "long"
                    },
                    "employees_count_senior": {
                        "type": "long"
                    },
                    "employees_count_intern": {
                        "type": "long"
                    },
                    "employees_count_specialist": {
                        "type": "long"
                    },
                    "employees_count_other_management": {
                        "type": "long"
                    }
                }
            },
            "employees_count_breakdown_by_seniority_by_month": {
                "type": "nested",
                "properties": {
                    "employees_count_breakdown_by_seniority": {
                        "type": "object",
                        "properties": {
                            "employees_count_owner": {
                                "type": "long"
                            },
                            "employees_count_founder": {
                                "type": "long"
                            },
                            "employees_count_clevel": {
                                "type": "long"
                            },
                            "employees_count_partner": {
                                "type": "long"
                            },
                            "employees_count_vp": {
                                "type": "long"
                            },
                            "employees_count_head": {
                                "type": "long"
                            },
                            "employees_count_director": {
                                "type": "long"
                            },
                            "employees_count_manager": {
                                "type": "long"
                            },
                            "employees_count_senior": {
                                "type": "long"
                            },
                            "employees_count_intern": {
                                "type": "long"
                            },
                            "employees_count_specialist": {
                                "type": "long"
                            },
                            "employees_count_other_management": {
                                "type": "long"
                            }
                        }
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyyMM"
                    }
                }
            },
            "employees_count_breakdown_by_department": {
                "properties": {
                    "employees_count_medical": {
                        "type": "long"
                    },
                    "employees_count_sales": {
                        "type": "long"
                    },
                    "employees_count_hr": {
                        "type": "long"
                    },
                    "employees_count_legal": {
                        "type": "long"
                    },
                    "employees_count_marketing": {
                        "type": "long"
                    },
                    "employees_count_finance": {
                        "type": "long"
                    },
                    "employees_count_technical": {
                        "type": "long"
                    },
                    "employees_count_consulting": {
                        "type": "long"
                    },
                    "employees_count_operations": {
                        "type": "long"
                    },
                    "employees_count_product": {
                        "type": "long"
                    },
                    "employees_count_general_management": {
                        "type": "long"
                    },
                    "employees_count_administrative": {
                        "type": "long"
                    },
                    "employees_count_customer_service": {
                        "type": "long"
                    },
                    "employees_count_project_management": {
                        "type": "long"
                    },
                    "employees_count_design": {
                        "type": "long"
                    },
                    "employees_count_research": {
                        "type": "long"
                    },
                    "employees_count_trades": {
                        "type": "long"
                    },
                    "employees_count_real_estate": {
                        "type": "long"
                    },
                    "employees_count_education": {
                        "type": "long"
                    },
                    "employees_count_other_department": {
                        "type": "long"
                    }
                }
            },
            "employees_count_breakdown_by_department_by_month": {
                "type": "nested",
                "properties": {
                    "employees_count_breakdown_by_department": {
                        "type": "object",
                        "properties": {
                            "employees_count_sales": {
                                "type": "long"
                            },
                            "employees_count_hr": {
                                "type": "long"
                            },
                            "employees_count_legal": {
                                "type": "long"
                            },
                            "employees_count_marketing": {
                                "type": "long"
                            },
                            "employees_count_finance": {
                                "type": "long"
                            },
                            "employees_count_technical": {
                                "type": "long"
                            },
                            "employees_count_consulting": {
                                "type": "long"
                            },
                            "employees_count_operations": {
                                "type": "long"
                            },
                            "employees_count_product": {
                                "type": "long"
                            },
                            "employees_count_general_management": {
                                "type": "long"
                            },
                            "employees_count_administrative": {
                                "type": "long"
                            },
                            "employees_count_customer_service": {
                                "type": "long"
                            },
                            "employees_count_project_management": {
                                "type": "long"
                            },
                            "employees_count_design": {
                                "type": "long"
                            },
                            "employees_count_research": {
                                "type": "long"
                            },
                            "employees_count_trades": {
                                "type": "long"
                            },
                            "employees_count_real_estate": {
                                "type": "long"
                            },
                            "employees_count_education": {
                                "type": "long"
                            },
                            "employees_count_other_department": {
                                "type": "long"
                            }
                        }
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyyMM"
                    }
                }
            },
            "employees_count_breakdown_by_region": {
                "properties": {
                    "employees_count_eastern_europe": {
                        "type": "long"
                    },
                    "employees_count_latin_america": {
                        "type": "long"
                    },
                    "employees_count_southern_europe": {
                        "type": "long"
                    },
                    "employees_count_sub_saharan_africa": {
                        "type": "long"
                    },
                    "employees_count_central_asia": {
                        "type": "long"
                    },
                    "employees_count_northern_america": {
                        "type": "long"
                    },
                    "employees_count_australia_new_zealand": {
                        "type": "long"
                    },
                    "employees_count_northern_europe": {
                        "type": "long"
                    },
                    "employees_count_south_eastern_asia": {
                        "type": "long"
                    },
                    "employees_count_polynesia": {
                        "type": "long"
                    },
                    "employees_count_southern_asia": {
                        "type": "long"
                    },
                    "employees_count_northern_africa": {
                        "type": "long"
                    },
                    "employees_count_melanesia": {
                        "type": "long"
                    },
                    "employees_count_western_europe": {
                        "type": "long"
                    },
                    "employees_count_western_asia": {
                        "type": "long"
                    },
                    "employees_count_eastern_asia": {
                        "type": "long"
                    },
                    "employees_count_micronesia": {
                        "type": "long"
                    },
                    "employees_count_unknown": {
                        "type": "long"
                    }
                }
            },
            "employees_count_breakdown_by_region_by_month": {
                "type": "nested",
                "properties": {
                    "employees_count_breakdown_by_region": {
                        "type": "object",
                        "properties": {
                            "employees_count_eastern_europe": {
                                "type": "long"
                            },
                            "employees_count_latin_america": {
                                "type": "long"
                            },
                            "employees_count_southern_europe": {
                                "type": "long"
                            },
                            "employees_count_sub_saharan_africa": {
                                "type": "long"
                            },
                            "employees_count_central_asia": {
                                "type": "long"
                            },
                            "employees_count_northern_america": {
                                "type": "long"
                            },
                            "employees_count_australia_new_zealand": {
                                "type": "long"
                            },
                            "employees_count_northern_europe": {
                                "type": "long"
                            },
                            "employees_count_south_eastern_asia": {
                                "type": "long"
                            },
                            "employees_count_polynesia": {
                                "type": "long"
                            },
                            "employees_count_southern_asia": {
                                "type": "long"
                            },
                            "employees_count_northern_africa": {
                                "type": "long"
                            },
                            "employees_count_melanesia": {
                                "type": "long"
                            },
                            "employees_count_western_europe": {
                                "type": "long"
                            },
                            "employees_count_western_asia": {
                                "type": "long"
                            },
                            "employees_count_eastern_asia": {
                                "type": "long"
                            },
                            "employees_count_micronesia": {
                                "type": "long"
                            },
                            "employees_count_unknown": {
                                "type": "long"
                            }
                        }
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyyMM"
                    }
                }
            },
            "employees_count_by_country": {
                "type": "nested",
                "properties": {
                    "country": {
                        "type": "text"
                    },
                    "employee_count": {
                        "type": "long"
                    }
                }
            },
            "employees_count_by_country_by_month": {
                "type": "nested",
                "properties": {
                    "employees_count_by_country": {
                        "type": "nested",
                        "properties": {
                            "country": {
                                "type": "text"
                            },
                            "employee_count": {
                                "type": "long"
                            }
                        }
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyyMM"
                    }
                }
            },
            "key_executives": {
                "type": "nested",
                "properties": {
                    "parent_id": {
                        "type": "long"
                    },
                    "member_full_name": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "member_position_title": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    }
                }
            },
            "key_employee_change_events": {
                "type": "nested",
                "properties": {
                    "employee_change_event_name": {
                        "type": "text"
                    },
                    "employee_change_event_date": {
                        "type": "date",
                        "format": "yyyy-MM-dd"
                    },
                    "employee_change_event_url": {
                        "type": "text"
                    }
                }
            },
            "key_executive_arrivals": {
                "type": "nested",
                "properties": {
                    "parent_id": {
                        "type": "long"
                    },
                    "member_full_name": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "member_position_title": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "arrival_date": {
                        "type": "date",
                        "format": "MMM yyyy"
                    }
                }
            },
            "key_executive_departures":  {
                "type": "nested",
                "properties": {
                    "parent_id": {
                        "type": "long"
                    },
                    "member_full_name": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "member_position_title": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "departure_date": {
                        "type": "date",
                        "format": "MMM yyyy"
                    }
                }
            },
            "employees_count_change": {
                "properties": {
                    "current": {
                        "type": "long"
                    },
                    "change_monthly": {
                        "type": "long"
                    },
                    "change_monthly_percentage": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "long"
                    },
                    "change_quarterly_percentage": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "long"
                    },
                    "change_yearly_percentage": {
                        "type": "double"
                    }
                }
            },
            "employees_count_by_month": {
                "type": "nested",
                "properties": {
                    "employees_count": {
                        "type": "long"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "professionnal_network_followers_count_change": {
                "properties": {
                    "current": {
                        "type": "long"
                    },
                    "change_monthly": {
                        "type": "long"
                    },
                    "change_monthly_percentage": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "long"
                    },
                    "change_quarterly_percentage": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "long"
                    },
                    "change_yearly_percentage": {
                        "type": "double"
                    }
                }
            },
            "professionnal_network_followers_count_by_month": {
                "type": "nested",
                "properties": {
                    "follower_count": {
                        "type": "long"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "active_job_postings_count_change": {
                "properties": {
                    "current": {
                        "type": "long"
                    },
                    "change_monthly": {
                        "type": "long"
                    },
                    "change_monthly_percentage": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "long"
                    },
                    "change_quarterly_percentage": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "long"
                    },
                    "change_yearly_percentage": {
                        "type": "double"
                    }
                }
            },
            "product_reviews_score_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "product_reviews_score_by_month": {
                "type": "nested",
                "properties": {
                    "product_reviews_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "total_website_visits_change": {
                "properties": {
                    "current": {
                        "type": "long"
                    },
                    "change_monthly": {
                        "type": "long"
                    },
                    "change_monthly_percentage": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "long"
                    },
                    "change_quarterly_percentage": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "long"
                    },
                    "change_yearly_percentage": {
                        "type": "double"
                    }
                }
            },
            "total_website_visits_by_month": {
                "type": "nested",
                "properties": {
                    "total_website_visits": {
                        "type": "long"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_aggregated_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_aggregated_by_month": {
                "type": "nested",
                "properties": {
                    "aggregated_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_business_outlook_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_business_outlook_by_month": {
                "type": "nested",
                "properties": {
                    "business_outlook_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_career_opportunities_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_career_opportunities_by_month": {
                "type": "nested",
                "properties": {
                    "career_opportunities_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_ceo_approval_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_ceo_approval_by_month": {
                "type": "nested",
                "properties": {
                    "ceo_approval_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_compensation_benefits_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_compensation_benefits_by_month": {
                "type": "nested",
                "properties": {
                    "compensation_benefits_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_culture_values_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_culture_values_by_month": {
                "type": "nested",
                "properties": {
                    "culture_values_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_diversity_inclusion_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_diversity_inclusion_by_month": {
                "type": "nested",
                "properties": {
                    "diversity_inclusion_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_recommend_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_recommend_by_month": {
                "type": "nested",
                "properties": {
                    "recommend_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_senior_management_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_senior_management_by_month": {
                "type": "nested",
                "properties": {
                    "senior_management_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "employee_reviews_score_work_life_balance_change": {
                "properties": {
                    "current": {
                        "type": "double"
                    },
                    "change_monthly": {
                        "type": "double"
                    },
                    "change_quarterly": {
                        "type": "double"
                    },
                    "change_yearly": {
                        "type": "double"
                    }
                }
            },
            "employee_reviews_score_work_life_balance_by_month": {
                "type": "nested",
                "properties": {
                    "work_life_balance_score": {
                        "type": "double"
                    },
                    "date": {
                        "type": "date",
                        "format": "yyyy-MM-dd||yyyy-MM"
                    }
                }
            },
            "expired_domain": {
                "type": "boolean"
            },
            "unique_domain": {
                "type": "boolean"
            },
            "unique_website": {
                "type": "boolean"
            },
            "last_updated_at": {
                "type": "date",
                "format": "yyyy-MM-dd"
            },
            "created_at": {
                "type": "date",
                "format": "yyyy-MM-dd"
            },
            "company_updates": {
                "type": "nested",
                "properties": {
                    "followers": {
                        "type": "long"
                    },
                    "date": {
                        "type": "date"
                    },
                    "description": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "reactions_count": {
                        "type": "long"
                    },
                    "comments_count": {
                        "type": "long"
                    },
                    "reshared_post_author": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "reshared_post_author_url": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "reshared_post_author_headline": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "reshared_post_description": {
                        "type": "text",
                        "fields": {
                            "exact": {
                                "type": "keyword",
                                "null_value": "NULL"
                            }
                        }
                    },
                    "reshared_post_followers": {
                        "type": "long"
                    },
                    "reshared_post_date": {
                        "type": "keyword",
                        "null_value": "NULL"
                    }
                }
            }
        }
    }
}

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:

• size_range

• industry

• hq_location

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":{
         "company_name":{
            "query":"Google",
            "operator":"and"
         }
      }
   },
    "sort": [
        "_score"
    ]
}

Sort by ID

Additional sorting fields

Multi-source 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,

• followers_count_professional_network,

• followers_count_twitter,

• followers_count_owler,

• num_technologies_used,

• ipo_share_price,

• last_funding_round_amount_raised,

• last_funding_round_num_investors,

• num_acquisitions_source_1,

• num_acquisitions_source_2,

• num_acquisitions_source_5,

• product_reviews_count,

• num_news_articles,

• total_website_visits_monthly,

• rank_global,

• rank_country,

• rank_category,

• company_employee_reviews_count,

• active_job_postings_count,

• product_reviews_aggregate_score,

• visits_change_monthly,

• bounce_rate,

• pages_per_visit,

• average_visit_duration_seconds,

• company_employee_reviews_aggregate_score,

• revenue_quarterly.value,

• revenue_annual.source_1_annual_revenue.annual_revenue,

• revenue_annual.source_5_annual_revenue.annual_revenue