# Elasticsearch DSL: Multi-source Company API {% columns %} {% column width="16.666666666666664%" %} Data type: Query type: URL: {% endcolumn %} {% column %} Multi-source Company Elasticsearch DSL {% endcolumn %} {% endcolumns %} *** ## Overview Use the `/v2/company_multi_source/search/es_dsl` endpoint to find company data matching your specifications.
General Elasticsearch DSL information and usage tipselasticsearch-dsl
## Elasticsearch schema
Elasticsearch schema Elasticsearch structure maps directly to our Multi-source Company data fields: {% code expandable="true" %} ```json { "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", "fields": { "domain_only": { "type": "text" } } }, "professional_network_url": { "type": "text" }, "professional_network_shorthand_name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "canonical_professional_network_url": { "type": "keyword", "null_value": "NULL", "fields": { "domain_only": { "type": "text" } } }, "canonical_professional_network_shorthand_name": { "type": "text", "fields": { "exact": { "type": "keyword", "null_value": "NULL" } } }, "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_professional_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": { "properties": { "type": { "type": "text" }, "announced_date": { "type": "date", "format": "yyyy-MM-dd" }, "investors": { "type": "nested", "properties": { "name": { "type": "text" }, "entity_id": { "type": "long" }, "entity": { "type": "text" }, "is_lead": { "type": "boolean" }, "partner_identifiers": { "type": "nested", "properties": { "name": { "type": "text" }, "entity_id": { "type": "long" }, "entity": { "type": "text" } } } } }, "amount_raised": { "type": "long" }, "amount_raised_currency": { "type": "text" }, "num_investors": { "type": "long" }, "num_partners": { "type": "long" } } }, "funding_rounds": { "type": "nested", "properties": { "type": { "type": "text" }, "announced_date": { "type": "date", "format": "yyyy-MM-dd" }, "investors": { "type": "nested", "properties": { "name": { "type": "text" }, "entity_id": { "type": "long" }, "entity": { "type": "text" }, "is_lead": { "type": "boolean" }, "partner_identifiers": { "type": "nested", "properties": { "name": { "type": "text" }, "entity_id": { "type": "long" }, "entity": { "type": "text" } } } } }, "amount_raised": { "type": "long" }, "amount_raised_currency": { "type": "text" }, "num_investors": { "type": "long" }, "num_partners": { "type": "long" } } }, "ownership_status": { "type": "text" }, "parent_company_information": { "properties": { "parent_company_id": { "type": "long" }, "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", "format": "yyyyMM" } } }, "departures_count": { "type": "long" }, "departures_count_by_month": { "type": "nested", "properties": { "departures_count": { "type": "long" }, "date": { "type": "date", "format": "yyyyMM" } } }, "employee_attrition_rate": { "type": "double" }, "employee_attrition_rate_by_month": { "type": "nested", "properties": { "employee_attrition_rate": { "type": "double" }, "date": { "type": "date", "format": "yyyyMM" } } }, "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" } } }, "professional_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" } } }, "professional_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" } } } } } } ``` {% endcode %}
{% hint style="success" %} #### Having trouble writing Elasticsearch queries on your own? Explore **AI query builder** feature available in Self-service [playground](https://dashboard.coresignal.com/apis/company/playground). Write a prompt, and AI assistant will automatically convert it into a query. {% endhint %} ### Possible input values You can look for available input values in the general [Elasticsearch DSL](https://docs.coresignal.com/api-introduction/requests/elasticsearch-dsl) topic and find the lists of the following fields: * size\_range * industry * hq\_location ## Sample request {% code title="Request example" expandable="true" %} ```json curl -X 'POST' \ 'https://api.coresignal.com/cdapi/v2/company_multi_source/search/es_dsl' \ -H 'accept: application/json' \ -H 'apikey: {API Key}' \ -H 'Content-Type: application/json' \ -d '{ "query": { "bool": { "should": [ { "query_string": { "query": "it", "default_field": "company_name", "default_operator": "and" } } ] } } }' ``` {% endcode %} ### Sorting options Find several examples of the available sorting options. All information about the sorting is in the general [Elasticsearch DSL](https://docs.coresignal.com/api-introduction/requests/elasticsearch-dsl) topic. {% tabs %} {% tab title="Sort by score" %} {% code title="Sort by score" %} ```json { "query": { "match":{ "company_name":{ "query":"Google", "operator":"and" } } }, "sort": [ "_score" ] } ``` {% endcode %} {% endtab %} {% tab title="Sort by ID" %} {% code title="Sort by id" %} ```json { "query": { "match":{ "company_name":{ "query":"Google", "operator":"and" } } }, "sort": [ "id" ] } ``` {% endcode %} {% endtab %} {% endtabs %} #### 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: {% columns %} {% column %} * `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`, {% endcolumn %} {% column %} * `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` {% endcolumn %} {% endcolumns %} --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.coresignal.com/company-api/multi-source-company-api/elasticsearch-dsl.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.