> ## Documentation Index
> Fetch the complete documentation index at: https://docs.theswarm.com/llms.txt
> Use this file to discover all available pages before exploring further.

# OpenSearch Profile Mappings (v3)

> OpenSearch field mapping for v3 profile data.

Use this mapping when building OpenSearch DSL queries against the [v3 Search Profiles](/docs/endpoints/v3/search-profiles) and [Relationships](/docs/endpoints/v3/relationships) endpoints. The mapping defines which fields are indexed and how (`keyword`, `text`, `nested`, etc.), which determines the query clauses you can use against each field.

v3 adds `hiring`, `open_to_work`, and the nested `team_connections.origins` field to the profile index, among other changes from v2.

<Note>
  **Querying `team_connections.origins`** — accepted values (provisional, may change): `csv`, `plugin`, `overlaps`, `google`, `google-calendar`, `user-profile`, `manual-csv`, `education-overlaps`, `investor-overlaps`, `manual-url`. Use a [nested query](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-nested-query.html) scoped to your `team_connections.team_id` — see [Relationships endpoint examples](/docs/examples/relationships-endpoint#filtering-by-team-connection-origin). This query-side vocabulary differs from the response-side `connections[].sources[].origin` enum.
</Note>

```json opensearch_profile_mapping_v3 lines theme={null}
    {
    "mappings": {
    "dynamic": "false",
    "properties": {
      "profile_info": {
        "properties": {
          "all_time_job_title": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "all_time_title": {
            "type": "alias",
            "path": "profile_info.all_time_job_title"
          },
          "certifications": {
            "type": "nested",
            "properties": {
              "company_name": {
                "type": "text",
                "fields": {
                  "raw": {
                    "type": "keyword"
                  }
                }
              },
              "name": {
                "type": "text",
                "fields": {
                  "raw": {
                    "type": "keyword"
                  }
                }
              }
            }
          },
          "created_at": {
            "type": "date"
          },
          "current_company_id": {
            "type": "alias",
            "path": "profile_info.job_company_id"
          },
          "current_company_industries": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "current_company_industry": {
            "type": "alias",
            "path": "profile_info.job_company_industry"
          },
          "current_company_linkedin_slugs": {
            "type": "alias",
            "path": "profile_info.job_company_linkedin_slugs"
          },
          "current_company_location": {
            "type": "alias",
            "path": "profile_info.job_company_location_name"
          },
          "current_company_location_country": {
            "type": "alias",
            "path": "profile_info.job_company_location_country"
          },
          "current_company_name": {
            "type": "alias",
            "path": "profile_info.job_company_name"
          },
          "current_company_size": {
            "type": "alias",
            "path": "profile_info.job_company_size"
          },
          "current_company_website": {
            "type": "alias",
            "path": "profile_info.job_company_website"
          },
          "current_company_websites": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "current_job_function": {
            "type": "alias",
            "path": "profile_info.job_title_role"
          },
          "current_job_updated_at": {
            "type": "date"
          },
          "current_location": {
            "type": "alias",
            "path": "profile_info.location_name"
          },
          "current_seniorities": {
            "type": "alias",
            "path": "profile_info.job_seniorities"
          },
          "current_start_date": {
            "type": "alias",
            "path": "profile_info.job_start_date"
          },
          "current_title": {
            "type": "alias",
            "path": "profile_info.job_title"
          },
          "data_updated_at": {
            "type": "date"
          },
          "education": {
            "type": "nested",
            "properties": {
              "degrees": {
                "type": "text"
              },
              "end_date": {
                "type": "date"
              },
              "majors": {
                "type": "text"
              },
              "school": {
                "properties": {
                  "linkedin_slugs": {
                    "type": "keyword",
                    "normalizer": "lowercase_trim_normalizer"
                  },
                  "location": {
                    "properties": {
                      "name": {
                        "type": "text",
                        "fields": {
                          "raw": {
                            "type": "keyword"
                          }
                        }
                      }
                    }
                  },
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  },
                  "website": {
                    "type": "keyword",
                    "normalizer": "lowercase_acsiifold_normalizer"
                  }
                }
              },
              "start_date": {
                "type": "date"
              }
            }
          },
          "emails": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "experience": {
            "type": "nested",
            "properties": {
              "company": {
                "properties": {
                  "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"
                  },
                  "location": {
                    "properties": {
                      "continent": {
                        "type": "text",
                        "fields": {
                          "raw": {
                            "type": "keyword"
                          }
                        }
                      },
                      "country": {
                        "type": "keyword",
                        "normalizer": "lowercase_acsiifold_normalizer"
                      },
                      "name": {
                        "type": "text",
                        "fields": {
                          "raw": {
                            "type": "keyword"
                          }
                        }
                      }
                    }
                  },
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  },
                  "size": {
                    "type": "keyword"
                  },
                  "website": {
                    "type": "keyword",
                    "normalizer": "lowercase_acsiifold_normalizer"
                  },
                  "websites": {
                    "type": "keyword",
                    "normalizer": "lowercase_acsiifold_normalizer"
                  }
                }
              },
              "end_date": {
                "type": "date"
              },
              "function": {
                "type": "keyword",
                "normalizer": "lowercase_acsiifold_normalizer"
              },
              "is_current": {
                "type": "alias",
                "path": "profile_info.experience.is_primary"
              },
              "is_primary": {
                "type": "boolean"
              },
              "location": {
                "properties": {
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  }
                }
              },
              "seniorities": {
                "type": "keyword",
                "normalizer": "lowercase_acsiifold_normalizer"
              },
              "start_date": {
                "type": "date"
              },
              "status": {
                "type": "keyword"
              },
              "title": {
                "properties": {
                  "name": {
                    "type": "text",
                    "fields": {
                      "raw": {
                        "type": "keyword"
                      }
                    }
                  }
                }
              }
            }
          },
          "first_name": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "full_name": {
            "type": "text"
          },
          "hiring": {
            "type": "boolean"
          },
          "id": {
            "type": "keyword"
          },
          "industries": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "industry": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_company_id": {
            "type": "keyword"
          },
          "job_company_industry": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_company_linkedin_slugs": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "job_company_location_country": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_company_location_name": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "job_company_name": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "job_company_size": {
            "type": "keyword"
          },
          "job_company_website": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_seniorities": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "job_start_date": {
            "type": "date"
          },
          "job_title": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "job_title_role": {
            "type": "keyword",
            "normalizer": "lowercase_acsiifold_normalizer"
          },
          "last_name": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "latest_company_change_at": {
            "type": "date"
          },
          "latest_role_change_at": {
            "type": "date"
          },
          "linkedin_accounts": {
            "properties": {
              "connections": {
                "type": "integer"
              },
              "entity_id": {
                "type": "keyword"
              },
              "followers": {
                "type": "integer"
              },
              "id": {
                "type": "keyword"
              },
              "join_date": {
                "type": "date"
              },
              "status": {
                "type": "keyword"
              },
              "username": {
                "type": "keyword",
                "normalizer": "lowercase_trim_normalizer"
              }
            }
          },
          "linkedin_usernames": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "location_locality": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "location_name": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "location_country": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "location_continent": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "location_region": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "open_to_work": {
            "type": "boolean"
          },
          "recent_job_title": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "recent_title": {
            "type": "alias",
            "path": "profile_info.recent_job_title"
          },
          "refreshed_at": {
            "type": "date"
          },
          "skills": {
            "type": "text",
            "fields": {
              "raw": {
                "type": "keyword"
              }
            }
          },
          "smart_tags": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          },
          "updated_at": {
            "type": "date"
          },
          "work_emails": {
            "type": "keyword",
            "normalizer": "lowercase_trim_normalizer"
          }
        }
      },
      "team_connections": {
        "type": "nested",
        "properties": {
          "connected_members_count": {
            "type": "integer"
          },
          "origins": {
            "type": "keyword"
          },
          "strength": {
            "type": "long"
          },
          "strength_normalized": {
            "type": "keyword"
          },
          "team_id": {
            "type": "keyword"
          }
        }
      },
      "connections": {
        "type": "nested",
        "properties": {
          "origins": {
            "type": "keyword"
          },
          "sources": {
            "type": "keyword"
          },
          "strength": {
            "type": "long"
          },
          "strength_normalized": {
            "type": "keyword"
          },
          "user_id": {
            "type": "keyword"
          }
        }
      }
    }
    }
    }
```