Elasticsearch Mapping

The full Elasticsearch field mapping for Company data

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": {
    "affiliated_profiles": {
      "type": "keyword"
    },
    "all_subsidiaries": {
      "type": "keyword"
    },
    "alternative_domains": {
      "type": "keyword"
    },
    "alternative_names": {
      "type": "keyword",
      "ignore_above": 256,
      "fields": {
        "text": {
          "type": "text"
        }
      }
    },
    "direct_subsidiaries": {
      "type": "keyword"
    },
    "email_domains": {
      "type": "keyword"
    },
    "facebook_url": {
      "type": "keyword"
    },
    "founded": {
      "type": "date",
      "format": "yyyy-MM-dd||yyyy-MM||yyyy",
      "ignore_malformed": true
    },
    "gics_sector": {
      "type": "keyword"
    },
    "headline": {
      "type": "text"
    },
    "id": {
      "type": "keyword"
    },
    "immediate_parent": {
      "type": "keyword"
    },
    "industry": {
      "type": "keyword"
    },
    "insights": {
      "dynamic": "false",
      "properties": {
        "employee_churn_rate": {
          "properties": {
            "12_month": {
              "type": "float"
            },
            "24_month": {
              "type": "float"
            },
            "3_month": {
              "type": "float"
            },
            "6_month": {
              "type": "float"
            }
          }
        },
        "employee_count": {
          "type": "long"
        },
        "employee_growth_rate": {
          "properties": {
            "12_month": {
              "type": "float"
            },
            "24_month": {
              "type": "float"
            },
            "3_month": {
              "type": "float"
            },
            "6_month": {
              "type": "float"
            }
          }
        },
        "inferred_revenue": {
          "type": "keyword"
        }
      }
    },
    "linkedin_id": {
      "type": "keyword"
    },
    "linkedin_url": {
      "type": "keyword"
    },
    "location": {
      "properties": {
        "address_line_2": {
          "type": "keyword"
        },
        "continent": {
          "type": "keyword"
        },
        "country": {
          "type": "keyword"
        },
        "geo": {
          "type": "geo_point",
          "doc_values": false
        },
        "locality": {
          "type": "keyword"
        },
        "metro": {
          "type": "keyword"
        },
        "name": {
          "type": "keyword"
        },
        "postal_code": {
          "type": "keyword"
        },
        "region": {
          "type": "keyword"
        },
        "street_address": {
          "type": "keyword"
        }
      }
    },
    "mic_exchange": {
      "type": "keyword"
    },
    "naics": {
      "properties": {
        "industry_group": {
          "type": "keyword"
        },
        "naics_code": {
          "type": "keyword"
        },
        "naics_industry": {
          "type": "keyword"
        },
        "national_industry": {
          "type": "keyword"
        },
        "sector": {
          "type": "keyword"
        },
        "sub_sector": {
          "type": "keyword"
        }
      }
    },
    "name": {
      "type": "keyword",
      "ignore_above": 256,
      "fields": {
        "text": {
          "type": "text"
        }
      }
    },
    "pdl_id": {
      "type": "keyword"
    },
    "profiles": {
      "type": "keyword"
    },
    "sic": {
      "properties": {
        "industry_group": {
          "type": "keyword"
        },
        "industry_sector": {
          "type": "keyword"
        },
        "major_group": {
          "type": "keyword"
        },
        "sic_code": {
          "type": "keyword"
        }
      }
    },
    "size": {
      "type": "keyword"
    },
    "summary": {
      "type": "text"
    },
    "tags": {
      "type": "keyword",
      "ignore_above": 256,
      "fields": {
        "text": {
          "type": "text"
        }
      }
    },
    "ticker": {
      "type": "keyword",
      "normalizer": "lowercase"
    },
    "twitter_url": {
      "type": "keyword"
    },
    "type": {
      "type": "keyword"
    },
    "ultimate_parent": {
      "type": "keyword"
    },
    "website": {
      "type": "keyword"
    }
  }
}