OpenSearch Company Mappings

Employ this mapping while formulating OpenSearch queries within the Company Search API to precisely refine your search results.
OpenSearch Company Mapping
{
  "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"
              }
            }
          },
          "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"
          }
        }
      },
      "text_search": {
        "type": "text"
      },
      "updated_at": {
        "type": "date"
      }
    }
  }
}
Getting Started

Models

Team Management

Examples

OpenSearch Company Mappings
