opensearch_company_mapping_v2
{
"mappings": {
"dynamic": "false",
"properties": {
"company_info": {
"properties": {
"alternative_names": {
"type": "text",
"fields": {
"raw": {
"type": "keyword"
}
}
},
"business_data": {
"properties": {
"customer_types": {
"type": "keyword",
"normalizer": "lowercase_acsiifold_normalizer"
},
"is_acquired": {
"type": "boolean"
},
"is_exited": {
"type": "boolean"
},
"is_government": {
"type": "boolean"
},
"is_non_profit": {
"type": "boolean"
},
"is_shut_down": {
"type": "boolean"
},
"is_startup": {
"type": "boolean"
},
"is_stealth": {
"type": "boolean"
},
"ownership_status": {
"type": "keyword",
"normalizer": "lowercase_acsiifold_normalizer"
},
"ownership_status_detailed": {
"type": "text",
"fields": {
"raw": {
"type": "keyword"
}
}
},
"stock_exchange": {
"type": "keyword",
"normalizer": "lowercase_trim_normalizer"
}
}
},
"canonical_name": {
"type": "keyword",
"normalizer": "lowercase_trim_normalizer"
},
"created_at": {
"type": "date"
},
"data_updated_at": {
"type": "date"
},
"founded": {
"type": "date"
},
"id": {
"type": "keyword"
},
"industries": {
"type": "keyword",
"normalizer": "lowercase_acsiifold_normalizer"
},
"industry": {
"type": "keyword",
"normalizer": "lowercase_acsiifold_normalizer"
},
"linkedin_slugs": {
"type": "keyword",
"normalizer": "lowercase_trim_normalizer"
},
"locations": {
"type": "nested",
"properties": {
"country": {
"type": "keyword",
"normalizer": "lowercase_acsiifold_normalizer"
},
"headquarter": {
"type": "text",
"fields": {
"raw": {
"type": "keyword"
}
}
},
"name": {
"type": "text",
"fields": {
"raw": {
"type": "keyword"
}
}
}
}
},
"name": {
"type": "text",
"fields": {
"raw": {
"type": "keyword"
}
}
},
"networks": {
"type": "nested",
"properties": {
"id": {
"type": "keyword"
},
"network": {
"type": "keyword"
},
"slug": {
"type": "keyword"
},
"url": {
"type": "keyword"
}
}
},
"size": {
"properties": {
"class": {
"type": "keyword"
},
"class_sort": {
"type": "integer"
}
}
},
"social_media": {
"type": "nested",
"properties": {
"id": {
"type": "keyword"
},
"network": {
"type": "keyword"
},
"slug": {
"type": "keyword"
},
"url": {
"type": "keyword"
}
}
},
"updated_at": {
"type": "date"
},
"website": {
"type": "text",
"fields": {
"raw": {
"type": "keyword"
}
}
},
"websites": {
"type": "text",
"fields": {
"raw": {
"type": "keyword"
}
}
},
"workforce": {
"properties": {
"class": {
"type": "keyword"
},
"class_sort": {
"type": "integer"
},
"headcount": {
"type": "integer"
}
}
}
}
},
"connected_team_ids": {
"type": "keyword"
},
"crm_ids": {
"type": "keyword"
},
"funding_data": {
"properties": {
"last_round_amount_usd": {
"type": "long"
},
"last_round_date": {
"type": "date"
},
"last_round_investors": {
"type": "nested",
"properties": {
"crunchbase_id": {
"type": "keyword"
},
"crunchbase_slug": {
"type": "keyword"
},
"id": {
"type": "keyword"
},
"kind": {
"type": "keyword"
},
"name": {
"type": "text"
}
}
},
"last_round_type": {
"type": "keyword"
},
"rounds": {
"type": "nested",
"properties": {
"amount_usd": {
"type": "long"
},
"date": {
"type": "date"
},
"investors": {
"type": "nested",
"properties": {
"crunchbase_id": {
"type": "keyword"
},
"crunchbase_slug": {
"type": "keyword"
},
"id": {
"type": "keyword"
},
"kind": {
"type": "keyword"
},
"name": {
"type": "text"
}
}
},
"type": {
"type": "keyword"
}
}
},
"total_funding_amount_usd": {
"type": "long"
}
}
},
"investor_data": {
"properties": {
"check_size": {
"type": "keyword"
},
"geography_focus": {
"type": "keyword"
},
"industry_focus": {
"type": "keyword"
},
"portfolio_companies": {
"type": "nested",
"properties": {
"company_id": {
"type": "keyword"
}
}
},
"stage_focus": {
"type": "keyword"
},
"type": {
"type": "keyword"
}
}
},
"team_connections": {
"type": "nested",
"properties": {
"connected_members": {
"type": "keyword"
},
"connected_members_count": {
"type": "integer"
},
"profile_count": {
"type": "integer"
},
"team_id": {
"type": "keyword"
}
}
},
"text_search": {
"type": "text"
},
"updated_at": {
"type": "date"
}
}
}
}