Elasticsearch DSL
Data type:
Query type:
URL:
Multi-source Company
Elasticsearch Domain Specific Language (ES 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.
Elasticsearch schema
Elasticsearch schema
Elasticsearch structure maps directly to our Multi-source Company data points:
{
"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"
},
"website": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"website_alias": {
"type": "text"
},
"professional_network_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"twitter_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"discord_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"facebook_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"instagram_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"pinterest_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"tiktok_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"youtube_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"github_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"reddit_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"financial_website_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"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": "long"
},
"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_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": {
"1": {
"type": "long"
},
"2": {
"type": "long"
},
"3": {
"type": "long"
},
"4": {
"type": "long"
},
"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",
"index": false
},
"published_date": {
"type": "date",
"format": "yyyy-MM-dd",
"index": false
},
"summary": {
"type": "text",
"index": false
},
"article_url": {
"type": "text",
"index": false
}
}
},
"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": {
"1": {
"type": "double"
},
"2": {
"type": "double"
},
"3": {
"type": "double"
},
"4": {
"type": "double"
},
"5": {
"type": "double"
}
}
},
"active_job_postings_count": {
"type": "long"
},
"active_job_postings_titles": {
"type": "text",
"fields": {
"exact": {
"type": "keyword"
}
}
},
"active_job_postings_count_by_month": {
"type": "nested",
"properties": {
"active_job_postings_count": {
"type": "long"
},
"date": {
"type": "date",
"format": "yyyy-MM"
}
}
},
"base_salary": {
"type": "flattened"
},
"additional_pay": {
"type": "flattened"
},
"total_salary": {
"type": "flattened"
},
"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": "flattened"
},
"key_executives": {
"type": "flattened"
},
"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": "flattened"
},
"key_executive_departures": {
"type": "flattened"
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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"
}
}
},
"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": "keyword",
"null_value": "NULL"
},
"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"
}
}
}
}
}
}
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
{
"query": {
"match":{
"company_name":{
"query":"Google",
"operator":"and"
}
}
},
"sort": [
"_score"
]
}Sort by id
{
"query": {
"match":{
"company_name":{
"query":"Google",
"operator":"and"
}
}
},
"sort": [
"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
Last updated
Was this helpful?