Dictionary: Base Employee Data
This data dictionary shows all available data points, explains their values, and provides snippets of Employee dataset data.
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
Data point | Description | Data type |
---|---|---|
id | Record identification key | Number (integer) |
parent_id | Employee profile identification key | Number (integer) |
full_name | Full name | String |
first_name | First name | String |
last_name | Last name | String |
headline | Employee headline | String |
checked_at | Timestamp of the last time the profile was checked for key changes in ISO 8601 format | String (date) |
public_profile_id | Employee URN provided by professional network | String |
profile_url | Employee profile URL | String |
location | Displayed location | String |
industry | Associated industry Note: legacy field | String |
summary | Professional experience summary | String |
services | Offered services | String |
recommendations_count | Number of recommendations | String |
profile_photo_url | Profile photo URL | String |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the profile is publicly available: 1 - The last time we scraped the profile, the page that was not found was returned. 0 - The last time we scraped the profile, the record was added to our data and marked with the value 0 | Number (integer) |
country | Displayed location (country) parsed by us from the location value | String |
country_iso_2 | ISO 3166-1 alpha-2 country code | String |
country_iso_3 | ISO 3166-1 alpha-3 country code | String |
regions | Region information (additional location information) | Array of objects |
region | Location region | String |
connections_count | Number of active connections | Number (integer) |
follower_count | Employee follower count | Number (integer) |
experience_count | Number of experience records | Number (integer) |
shorthand_name | Part of the employee URL used to identify employee profiles Note: can be changed at any time by the user | String |
canonical_shorthand_name | The most recent version of the shorthand_name | String |
shorthand_names | A list of all historical shorthand_names that we captured | Array of objects |
shorthand_name | Captured shorthand name | String |
historical_ids | A list of all employee identification keys assigned to this record | Array of objects |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
is_parent | Represents if the employee ID is the original ID in our dataset (not a duplicate) 1 = original ID 0 = duplicate ID | Number (integer) |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
also_viewed | Other employee profiles from the People also viewedsection | Array of objects |
id | Record UUID identifier | String |
full_name | Employee's name | String |
profile_url | Employee's URL | String |
headline | Employee's headline | String |
location | Associated location | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
awards | Awards | Array of objects |
id | Record UUID identifier | String |
title | Award title | String |
issuer | Award issuer | String |
description | Award description Note: contains HTML tags | String |
date | Issue date Note: date format vary | String (date) |
date_year | Issue year | Number (integer) |
date_month | Issue month | Number (integer) |
date_day | Issue day | Number (integer) |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
certifications | Certifications | Array of objects |
id | Record UUID identifier | String |
title | Certification title | String |
issuer | Certification issuer | String |
credential_id | Credential identification key | String |
certificate_url | Certification URL | String |
issuer_url | Issuer profile URL | String |
order_in_profile | Section record order | Number (integer) |
date_from | Certification issue date | String (date) |
date_from_year | Issue year | Number (integer) |
date_from_month | Issue month | Number (integer) |
date_to | Certification expiry date | String (date) |
date_to_year | Expiry year | Number (integer) |
date_to_month | Expiry month | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
courses | Courses | Array of objects |
id | Record UUID identifier | String |
organizer | Course organizer | String |
title | Course title | String |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
education | Education details | Array of objects |
id | Record UUID identifier | String |
institution | Education institution | String |
program | Program title | String |
institution_id | ID of the company (institution) relating to the company table | Number (integer, int64) |
institution_source_id | Record identification key assigned by professional network | Number (integer, int64) |
date_from | Enrollment date | String (date) |
date_from_year | Enrollment year | Number (integer) |
date_from_month | Enrollment month | Number (integer) |
date_to | Graduation date | String (date) |
date_to_year | Graduation year | Number (integer) |
date_to_month | Graduation month | Number (integer) |
activities_and_societies | Activities and societies considered part of education | String |
description | Education experience described by the person Note: contains HTML tags | String |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
institution_url | Institution profile URL | String |
institution_shorthand_name | Shorthand name from the institution profile URL | String |
order_in_profile | Section record order | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
experience | Work experience | Array of objects |
id | Record UUID identifier | String |
title | Job title | String |
location | Job (company) location | String |
company_id | ID of the company relating to the company table | Number (integer, int64) |
company_source_id | Record identification key assigned by professional network | Number (integer, int64) |
company_name | Workplace name | String |
company_shorthand_name | Shorthand name from the company profile URL | String |
company_url | The profile URL of the workplace | String |
date_from | Employment start date | String (date) |
date_from_year | Employment start year | Number (integer) |
date_from_month | Employment start month | Number (integer) |
date_to | Employment end date | String (date) |
date_to_year | Employment end year | Number (integer) |
date_to_month | Employment end month | Number (integer) |
is_current | Marks if the record is for current employment 1 - Current workplace 0 - Former workplace | Boolean |
duration | Employment duration | String |
description | Job/job experience description Note: contains HTML tags | String |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
order_in_profile | Section record order | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
languages | Language knowledge | Array of objects |
id | Record UUID identifier | String |
language | Listed language | String |
proficiency | Language proficiency | String |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
organizations | Memberships in organizations | Array of objects |
id | Record UUID identifier | String |
organization | Organization title Note: Contains HTML tags | String |
position | Position in the organization Note: Contains HTML tags | String |
description | Description of the activity/experience in the organization | String |
date_from | Membership start date | String (date) |
date_from_year | Membership start year | Number (integer) |
date_from_month | Membership start month | Number (integer) |
date_to | Membership end date | String (date) |
date_to_year | Membership end year | Number (integer) |
date_to_month | Membership end month | Number (integer) |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
patents | Authored patents | Array of objects |
id | Record UUID identifier | String |
title | Patent title | String |
status | Patent status | String |
inventors | Patent inventors | Array of objects |
full_name | Inventor's name | String |
profile_url | Inventor's profile URL | String |
order_in_profile | Section record order | Number (integer) |
date | Patent filing date | String (date) |
date_year | Filling year | Number (integer) |
date_month | Filling month | Number (integer) |
date_day | Filling day | Number (integer) |
patent_url | Patent URL | String |
description | Patent description Note: contains HTML tags | String |
patent_or_application_number | Patent details, such as the area the patent is valid in | String |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
projects | Projects | Array of objects |
id | Record UUID identifier | String |
name | Project name | String |
project_url | Project website URL | String |
description | Project description Note: contains HTML tags | String |
date_from | Project start date | String (date) |
date_from_year | Start year | Number (integer) |
date_from_month | Start year | Number (integer) |
date_to | Project end date | String (date) |
date_to_year | End year | Number (integer) |
date_to_month | End month | Number (integer) |
team_members | Project team members | Array of objects |
full_name | Member's full name | String (date) |
profile_url | Member's profile URL on professional network | String (date) |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See snippets of the dataset for reference:
Data point | Description | Data type |
---|---|---|
publications | Authored publications | Array of objects |
id | Record UUID identifier | String |
title | Publication title | String |
publisher | Publication publisher | String |
date | Publication release date | String (date) |
date_year | Release year | Number (integer) |
date_month | Release month | Number (integer) |
date_day | Release day | Number (integer) |
description | Publication description Note: contains HTML tags | String |
authors | Publication authors | Array of objects |
full_name | Author's name | String |
profile_url | Author's profile URL | String |
order_in_profile | Section record order | Number (integer) |
publication_url | Publication website URL | String |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
recommendations | Recommendations from other previous/current colleagues | Array of objects |
id | Record UUID identifier | String |
recommendation | Recommendation text | String |
full_name | Referee's name | String |
referee_url | Referee's profile URL | String |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
similar_profiles | Similar profiles | Array of objects |
id | Record UUID identifier | String |
profile_url | Profile URL | String |
full_name | Full name | String |
headline | Profile headline Note: not directly related to any particular work experience | String |
location | Displayed location | String |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
others_named | List of employees with similar or exact name | Array of objects |
id | Record UUID identifier | String |
profile_url | Profile URL | String |
full_name | Full name | String |
headline | Profile headline Note: not directly related to any particular work experience | String |
location | Displayed location | String |
order_in_profile | Section record order | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
Data point | Description | Data type |
---|---|---|
test_scores | Relevant tests and scores | Array of objects |
id | Record UUID identifier | String |
title | Test title | String |
date | Test completion date | String (date) |
date_year | Test completion year | Number (integer) |
date_month | Test completion month | Number (integer) |
description | Test completion day | String |
score | Test score | String |
order_in_profile | Section record order | String |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
volunteering_positions | Participation in volunteering organizations | Array of objects |
id | Record UUID identifier | String |
organization | Volunteer organization | String |
role | Role in the organization | String |
cause | Volunteering cause | String |
date_from | Volunteering start date | String (date) |
date_from_year | Start year | Number (integer) |
date_from_month | Start month | Number (integer) |
date_to | Volunteering end date | String (date) |
date_to_year | End year | Number (integer) |
date_to_month | End month | Number (integer) |
duration | Volunteering duration | String |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
description | Experience description Note: contains HTML tags | String |
organization_url | Organization's profile URL | String |
organization_shorthand_name | Shorthand name from the profile URL | String |
order_in_profile | Section record order | Number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
websites | Personal websites | Array of objects |
id | Record UUID identifier | String |
personal_website | Personal website | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Data point | Description | Data type |
---|---|---|
course_suggestions | Suggested courses | Array of objects |
id | Record UUID identifier | String |
title | Course title | String |
course_url | Course URL | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
activity | Activity on professional network | Array of objects |
id | Record UUID identifier | String |
activity_url | Post URL | String |
title | Post title Note: contains control characters | String |
action | Interaction type | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
hidden_details | Information hidden or blurred by professional network | Array of objects |
hidden_collection | The collection hidden information belongs to a collection (e.g., education, experience) | String |
See a snippet of the dataset for reference:
Legacy tables have low fill rates or are not filled with information due to the professional network hiding the data from public profiles.
Data point | Description | Data type |
---|---|---|
groups | Listed groups | Array of objects |
title | Group title | String |
url | Group page URL | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
interests | Employee's interests | Array of objects |
interest | Listed interest | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
posts_see_more_urls | URLs seen on the profile | Array of objects |
url | Link to the post feed on professional network | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
skills | Employee's skills | Array of objects |
skill | Listed skill | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
volunteering_cares | Employee's volunteering cares | Array of objects |
care | Listed volunteering care | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
volunteering_opportunities | Employee's volunteering opportunities | Array of objects |
opportunity | Listed volunteering opportunity | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Refer to the table example from the data:
Data point | Description | Data type |
---|---|---|
volunteering_supports | Employee's volunteering supports | Array of objects |
support | Listed volunteering support | String |
order_in_profile | Section record order | Number (integer) |
deleted | Status indicating if the record is publicly available: 1 - The record was publicly unavailable the last time we scraped the profile. 0 - The last time we scraped the profile, the record was available and added to the profile's data | Number (integer) |
created_at | Record creation timestamp in ISO 8601 format | String (date) |
updated_at | Record update timestamp in ISO 8601 format | String (date) |
Refer to the table example from the data: