Elasticsearch DSL
Data type:
Query type:
URL:
Multi-source Employee
Elasticsearch DSL
https://api.coresignal.com/cdapi/v2/employee_multi_source/search/es_dsl
Overview
Use the /v2/employee_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 Employee data points:
Endpoint schema
{
"mappings": {
"properties": {
"id": {
"type": "long"
},
"parent_id": {
"type": "long"
},
"created_at": {
"type": "date"
},
"updated_at": {
"type": "date"
},
"checked_at": {
"type": "date"
},
"changed_at": {
"type": "date"
},
"experience_change_last_identified_at": {
"type": "date"
},
"is_deleted": {
"type": "byte"
},
"is_parent": {
"type": "byte"
},
"public_profile_id": {
"type": "long"
},
"professional_network_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"professional_network_shorthand_names": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"historical_ids": {
"type": "text"
},
"full_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"first_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"first_name_initial": {
"type": "keyword",
"index": false,
"doc_values": false
},
"middle_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"middle_name_initial": {
"type": "keyword",
"index": false,
"doc_values": false
},
"last_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"last_name_initial": {
"type": "keyword",
"index": false,
"doc_values": false
},
"headline": {
"type": "text"
},
"summary": {
"type": "text"
},
"picture_url": {
"type": "keyword",
"index": false,
"doc_values": false
},
"location_country": {
"type": "keyword",
"null_value": "NULL"
},
"location_country_iso2": {
"type": "keyword",
"null_value": "NULL"
},
"location_country_iso3": {
"type": "keyword",
"null_value": "NULL"
},
"location_full": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"location_regions": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"interests": {
"type": "text"
},
"inferred_skills": {
"type": "text"
},
"historical_skills": {
"type": "text"
},
"connections_count": {
"type": "long"
},
"followers_count": {
"type": "long"
},
"services": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"primary_professional_email": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"primary_professional_email_status": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"professional_emails_collection": {
"type": "nested",
"properties": {
"professional_email": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"professional_email_status": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"order_of_priority": {
"type": "short"
}
}
},
"is_working": {
"type": "byte"
},
"active_experience_company_id": {
"type": "long"
},
"active_experience_title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"active_experience_description": {
"type": "text"
},
"active_experience_department": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"active_experience_management_level": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"is_decision_maker": {
"type": "byte"
},
"total_experience_duration_months": {
"type": "long"
},
"total_experience_duration_months_breakdown_department": {
"type": "nested",
"properties": {
"department": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"total_experience_duration_months": {
"type": "long"
}
}
},
"total_experience_duration_months_breakdown_management_level": {
"type": "nested",
"properties": {
"management_level": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"total_experience_duration_months": {
"type": "long"
}
}
},
"experience": {
"type": "nested",
"properties": {
"active_experience": {
"type": "byte"
},
"position_title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"department": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"management_level": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"location": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"description": {
"type": "text"
},
"date_from": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_from_year": {
"type": "short"
},
"date_from_month": {
"type": "byte"
},
"date_to": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_to_year": {
"type": "short"
},
"date_to_month": {
"type": "byte"
},
"duration_months": {
"type": "short"
},
"company_id": {
"type": "long"
},
"company_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_type": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_founded_year": {
"type": "short"
},
"company_followers_count": {
"type": "long"
},
"company_website": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"company_facebook_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_twitter_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_professional_network_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_size_range": {
"type": "keyword",
"null_value": "NULL"
},
"company_employees_count": {
"type": "long"
},
"company_industry": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_categories_and_keywords": {
"type": "text"
},
"company_annual_revenue_source_5": {
"type": "long"
},
"company_annual_revenue_currency_source_5": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_annual_revenue_source_1": {
"type": "double"
},
"company_annual_revenue_currency_source_1": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_employees_count_change_yearly_percentage": {
"type": "double"
},
"company_last_funding_round_date": {
"type": "date"
},
"company_last_funding_round_amount_raised": {
"type": "long"
},
"company_hq_full_address": {
"type": "text"
},
"company_hq_country": {
"type": "keyword"
},
"company_hq_regions": {
"type": "text"
},
"company_hq_country_iso2": {
"type": "keyword"
},
"company_hq_country_iso3": {
"type": "keyword"
},
"company_hq_city": {
"type": "text"
},
"company_hq_state": {
"type": "text"
},
"company_hq_street": {
"type": "text"
},
"company_hq_zipcode": {
"type": "text"
},
"company_last_updated_at": {
"type": "date"
},
"company_stock_ticker": {
"type": "nested",
"properties": {
"exchange": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"ticker": {
"type": "keyword"
}
}
},
"company_is_b2b": {
"type": "byte"
},
"order_in_profile": {
"type": "integer"
}
}
},
"projected_base_salary_p25": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_base_salary_median": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_base_salary_p75": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_base_salary_period": {
"type": "keyword",
"index": false,
"doc_values": false
},
"projected_base_salary_currency": {
"type": "keyword",
"index": false,
"doc_values": false
},
"projected_base_salary_updated_at": {
"type": "date",
"index": false,
"doc_values": false
},
"projected_additional_salary": {
"type": "nested",
"properties": {
"projected_additional_salary_type": {
"type": "keyword",
"index": false,
"doc_values": false
},
"projected_additional_salary_p25": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_additional_salary_median": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_additional_salary_p75": {
"type": "double",
"index": false,
"doc_values": false
}
}
},
"projected_additional_salary_period": {
"type": "keyword",
"index": false,
"doc_values": false
},
"projected_additional_salary_currency": {
"type": "keyword",
"index": false,
"doc_values": false
},
"projected_additional_salary_updated_at": {
"type": "date",
"index": false,
"doc_values": false
},
"projected_total_salary_p25": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_total_salary_median": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_total_salary_p75": {
"type": "double",
"index": false,
"doc_values": false
},
"projected_total_salary_period": {
"type": "keyword",
"index": false,
"doc_values": false
},
"projected_total_salary_currency": {
"type": "keyword",
"index": false,
"doc_values": false
},
"projected_total_salary_updated_at": {
"type": "date",
"index": false,
"doc_values": false
},
"last_graduation_date": {
"type": "short"
},
"education_degrees": {
"type": "text"
},
"education": {
"type": "nested",
"properties": {
"degree": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"description": {
"type": "text"
},
"institution_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"institution_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"institution_full_address": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"institution_country_iso2": {
"type": "keyword"
},
"institution_country_iso3": {
"type": "keyword"
},
"institution_regions": {
"type": "text"
},
"institution_city": {
"type": "text"
},
"institution_state": {
"type": "text"
},
"institution_street": {
"type": "text"
},
"institution_zipcode": {
"type": "text"
},
"date_from_year": {
"type": "short"
},
"date_to_year": {
"type": "short"
},
"activities_and_societies": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"order_in_profile": {
"type": "integer"
}
}
},
"recommendations_count": {
"type": "long"
},
"recommendations": {
"type": "nested",
"properties": {
"recommendation": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"referee_full_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"referee_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"order_in_profile": {
"type": "integer"
}
}
},
"activity": {
"type": "nested",
"properties": {
"activity_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"action": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"order_in_profile": {
"type": "integer"
}
}
},
"awards": {
"type": "nested",
"properties": {
"title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"issuer": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"description": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"date": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_year": {
"type": "integer"
},
"date_month": {
"type": "integer"
},
"order_in_profile": {
"type": "integer"
}
}
},
"courses": {
"type": "nested",
"properties": {
"organizer": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"order_in_profile": {
"type": "integer"
}
}
},
"certifications": {
"type": "nested",
"properties": {
"title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"issuer": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"issuer_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"credential_id": {
"type": "keyword"
},
"certificate_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"date_from": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_from_year": {
"type": "integer"
},
"date_from_month": {
"type": "integer"
},
"date_to": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_to_year": {
"type": "integer"
},
"date_to_month": {
"type": "integer"
},
"order_in_profile": {
"type": "integer"
}
}
},
"languages": {
"type": "nested",
"properties": {
"language": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"proficiency": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"order_in_profile": {
"type": "integer"
}
}
},
"patents_count": {
"type": "long"
},
"patents_topics": {
"type": "text"
},
"patents": {
"type": "nested",
"properties": {
"title": {
"type": "text"
},
"status": {
"type": "text"
},
"description": {
"type": "text"
},
"patent_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"date": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_year": {
"type": "short"
},
"date_month": {
"type": "byte"
},
"patent_number": {
"type": "keyword"
},
"order_in_profile": {
"type": "integer"
}
}
},
"publications_count": {
"type": "long"
},
"publications_topics": {
"type": "text"
},
"publications": {
"type": "nested",
"properties": {
"title": {
"type": "text"
},
"description": {
"type": "text"
},
"publication_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"publisher_names": {
"type": "text"
},
"date": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_year": {
"type": "short"
},
"date_month": {
"type": "short"
},
"order_in_profile": {
"type": "long"
}
}
},
"projects_count": {
"type": "long"
},
"projects_topics": {
"type": "text"
},
"projects": {
"type": "nested",
"properties": {
"name": {
"type": "text"
},
"description": {
"type": "text"
},
"project_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"date_from": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_from_year": {
"type": "short"
},
"date_from_month": {
"type": "byte"
},
"date_to": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_to_year": {
"type": "short"
},
"date_to_month": {
"type": "byte"
},
"order_in_profile": {
"type": "integer"
}
}
},
"organizations": {
"type": "nested",
"properties": {
"organization_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"position": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"description": {
"type": "text"
},
"date_from": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_from_year": {
"type": "short"
},
"date_from_month": {
"type": "byte"
},
"date_to": {
"type": "date",
"format": "MMMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_to_year": {
"type": "short"
},
"date_to_month": {
"type": "byte"
},
"order_in_profile": {
"type": "integer"
}
}
},
"profile_root_field_changes_summary": {
"type": "nested",
"properties": {
"field_name": {
"type": "keyword"
},
"change_type": {
"type": "keyword"
},
"last_changed_at": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
}
}
},
"profile_collection_field_changes_summary": {
"type": "nested",
"properties": {
"field_name": {
"type": "keyword"
},
"last_changed_at": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
}
}
},
"experience_recently_started": {
"type": "nested",
"properties": {
"company_id": {
"type": "long"
},
"company_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"company_shorthand_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"date_from": {
"type": "date",
"format": "MMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_to": {
"type": "date",
"format": "MMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"identification_date": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
}
}
},
"experience_recently_closed": {
"type": "nested",
"properties": {
"company_id": {
"type": "long"
},
"company_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"company_url": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
},
"domain_only": {
"type": "text"
}
}
},
"company_shorthand_name": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"date_from": {
"type": "date",
"format": "MMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"date_to": {
"type": "date",
"format": "MMM uuuu||uuuu",
"locale": "en",
"ignore_malformed": true
},
"title": {
"type": "text",
"fields": {
"exact": {
"type": "keyword",
"null_value": "NULL"
}
}
},
"identification_date": {
"type": "date",
"format": "yyyy-MM-dd HH:mm:ss.SSSSSS"
}
}
}
}
}
}
Sorting options
Find several examples of the available sorting options. All information about the sorting is in the general Elasticsearch DSL topic.
Last updated
Was this helpful?