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": {
    "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
        }
      }
    },
    "founded": {
      "type": "date",
      "index": true,
      "format": "yyyy-MM-dd||yyyy-MM||yyyy",
      "ignore_malformed": true
    },
    "size": {
      "type": "keyword",
      "index": true,
      "doc_values": true
    },
    "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"
    },
    "gics_sector": {
      "type": "keyword",
      "index": true,
      "doc_values": true
    },
    "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
    },
    "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
        }
      }
    },
    "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"
    }
  }
}