Elasticsearch Mapping
The following is the full Elasticsearch field mapping for Company data. Use the mapping when writing Elasticsearch queries with the Company Search API to fine-tune your results.
For more information about Elasticsearch fields, see https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-types.html.
{
"properties": {
"id": {
"type": "keyword",
"index": true,
"doc_values": true
},
"linkedin_slug": {
"type": "keyword",
"index": true,
"doc_values": true
},
"website": {
"type": "keyword",
"index": true,
"doc_values": true
},
"name": {
"type": "keyword",
"index": true,
"ignore_above": 256,
"fields": {
"text": {
"type": "text",
"doc_values": false
}
}
},
"display_name": {
"type": "keyword",
"index": true,
"doc_values": true
},
"founded": {
"type": "date",
"index": true,
"format": "yyyy-MM-dd||yyyy-MM||yyyy",
"ignore_malformed": true
},
"size": {
"type": "keyword",
"index": true,
"doc_values": true
},
"linkedin_follower_count": {
"type": "integer",
"index": true,
"doc_values": false
},
"location": {
"properties": {
"name": {
"type": "keyword",
"index": true,
"doc_values": true
},
"locality": {
"type": "keyword",
"index": true,
"doc_values": true
},
"region": {
"type": "keyword",
"index": true,
"doc_values": true
},
"metro": {
"type": "keyword",
"index": true,
"doc_values": true
},
"country": {
"type": "keyword",
"index": true,
"doc_values": true
},
"continent": {
"type": "keyword",
"index": true,
"doc_values": true
},
"street_address": {
"type": "keyword",
"index": true,
"doc_values": true
},
"address_line_2": {
"type": "keyword",
"index": true,
"doc_values": true
},
"postal_code": {
"type": "keyword",
"index": true,
"doc_values": true
},
"geo": {
"type": "geo_point",
"index": true,
"doc_values": false
}
}
},
"industry": {
"type": "keyword",
"index": true,
"doc_values": true
},
"facebook_url": {
"type": "keyword",
"index": true,
"doc_values": true
},
"twitter_url": {
"type": "keyword",
"index": true,
"doc_values": true
},
"linkedin_url": {
"type": "keyword",
"index": true,
"doc_values": true
},
"linkedin_id": {
"type": "keyword",
"index": true,
"doc_values": true
},
"ticker": {
"type": "keyword",
"index": true,
"doc_values": true,
"normalizer": "lowercase"
},
"mic_exchange": {
"type": "keyword",
"index": true,
"doc_values": true
},
"type": {
"type": "keyword",
"index": true,
"doc_values": true
},
"profiles": {
"type": "keyword",
"index": true,
"doc_values": true
},
"tags": {
"type": "keyword",
"index": true,
"ignore_above": 256,
"fields": {
"text": {
"type": "text",
"doc_values": false
}
}
},
"summary": {
"type": "text",
"index": true,
"doc_values": false
},
"headline": {
"type": "text",
"index": true,
"doc_values": false
},
"alternative_names": {
"type": "keyword",
"index": true,
"ignore_above": 256,
"fields": {
"text": {
"type": "text",
"doc_values": false
}
}
},
"alternative_domains": {
"type": "keyword",
"index": true,
"doc_values": true
},
"affiliated_profiles": {
"type": "keyword",
"index": true,
"doc_values": true
},
"ultimate_parent": {
"type": "keyword",
"index": true,
"doc_values": true
},
"immediate_parent": {
"type": "keyword",
"index": true,
"doc_values": true
},
"direct_subsidiaries": {
"type": "keyword",
"index": true,
"doc_values": true
},
"all_subsidiaries": {
"type": "keyword",
"index": true,
"doc_values": true
},
"ultimate_parent_ticker": {
"type": "keyword",
"index": true,
"doc_values": true
},
"ultimate_parent_mic_exchange": {
"type": "keyword",
"index": true,
"doc_values": true
},
"total_funding_raised": {
"type": "float",
"index": true,
"doc_values": false
},
"funding_stages": {
"type": "keyword",
"index": true,
"doc_values": true
},
"latest_funding_stage": {
"type": "keyword",
"index": true,
"doc_values": true
},
"number_funding_rounds": {
"type": "integer",
"index": true,
"doc_values": false
},
"last_funding_date": {
"type": "date",
"index": true,
"format": "yyyy-MM-dd||yyyy-MM||yyyy",
"ignore_malformed": true
},
"funding_details": {
"properties": {
"funding_round_date": {
"type": "keyword",
"index": false,
"doc_values": true
},
"funding_raised": {
"type": "float",
"index": false,
"doc_values": false
},
"funding_currency": {
"type": "keyword",
"index": false,
"doc_values": true
},
"funding_type": {
"type": "keyword",
"index": false,
"doc_values": true
},
"investing_companies": {
"type": "keyword",
"index": false,
"doc_values": true
},
"investing_individuals": {
"type": "keyword",
"index": true,
"doc_values": true
}
}
},
"sic": {
"properties": {
"sic_code": {
"type": "keyword",
"index": true,
"doc_values": true
},
"major_group": {
"type": "keyword",
"index": true,
"doc_values": true
},
"industry_group": {
"type": "keyword",
"index": true,
"doc_values": true
},
"industry_sector": {
"type": "keyword",
"index": true,
"doc_values": true
}
}
},
"naics": {
"properties": {
"naics_code": {
"type": "keyword",
"index": true,
"doc_values": true
},
"sector": {
"type": "keyword",
"index": true,
"doc_values": true
},
"sub_sector": {
"type": "keyword",
"index": true,
"doc_values": true
},
"industry_group": {
"type": "keyword",
"index": true,
"doc_values": true
},
"naics_industry": {
"type": "keyword",
"index": true,
"doc_values": true
},
"national_industry": {
"type": "keyword",
"index": true,
"doc_values": true
}
}
},
"dataset_version": {
"type": "keyword",
"index": true,
"doc_values": true
},
"employee_growth_rate": {
"properties": {
"3_month": {
"type": "float",
"index": true,
"doc_values": true
},
"6_month": {
"type": "float",
"index": true,
"doc_values": true
},
"12_month": {
"type": "float",
"index": true,
"doc_values": true
},
"24_month": {
"type": "float",
"index": true,
"doc_values": true
}
}
},
"employee_churn_rate": {
"properties": {
"3_month": {
"type": "float",
"index": true,
"doc_values": true
},
"6_month": {
"type": "float",
"index": true,
"doc_values": true
},
"12_month": {
"type": "float",
"index": true,
"doc_values": true
},
"24_month": {
"type": "float",
"index": true,
"doc_values": true
}
}
},
"employee_count": {
"type": "long",
"index": true
},
"inferred_revenue": {
"type": "keyword",
"index": true,
"normalizer": "lowercase"
}
}
}
Updated 4 months ago