Raw Data
This data dictionary shows all available data points, explains their values, and provides raw professional network member data samples.
All tables have snippets of the Professional Network Members dataset. Employee data in this dataset is also referred to as member data.
All personal/company information mentioned in this data dictionary is fictional and is solely intended for illustrative purposes.
A null value means that the information was not listed in the profile.
Data point | Description | Data type |
full_name | Full name | string |
first_name | First name | string |
last_name | Last name | string |
headline | The title found in the profile headline Note: not directly related to any particular work experience | string |
profile_url | Profile URL | string |
location | Member location | string |
industry | Industry member associates with (not directly related to any particular work experience) Note: legacy field | string |
summary | Member's professional experience summary Note: contains control characters | string |
updated_at | The time and date when we last scraped the record | string |
checked_at | Last profile check date, checking if the profile has any changes | string |
services | Services the member can be contacted for | string |
deleted | One of two values - 1 or 0 1 - the last time we scraped the profile, the Page 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 | boolean |
country | The country member is from Note: parsed by us from the location value | string |
recommendations_count | The number of recommendations from other people on the member's profile | string |
connections_count | The number of member's active connections | number (integer) |
follower_count | Member follower count | number (integer) |
shorthand_name | Part of the professional network profile URL used to identify members Note: can be changed at any time by the member | string |
canonical_shorthand_name | The most recent version of the member_shorthand_name | string |
shorthand_names | A list of all historical member shorthand_names that we have managed to capture. | array of objects |
shorthand_name | Captured shorthand name | string |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
shorthand_names_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
Refer to the table example from the data:
Data point | Description | Data type |
also_viewed | Member profiles that were viewed in tandem with the record profile | array of objects |
full_name | Member name | string |
profile_url | Member profile URL | string |
headline | The title found in the profile headline Note: not directly related to any particular work experience | string |
location | Member location | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
also_viewed_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
awards | Member awards | array of objects |
title | Award title | string |
issuer | Award issuer | string |
description | Award description Note: contains HTML tags | string |
reception_date | Issue date | string |
order_in_profile | Section record order | number (integer) |
reception_date_year | Year parsed from the reception_date | number (integer) |
reception_date_month | Month parsed from the reception_date | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
awards_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
certifications | Member certifications | array of objects |
title | Certification title | string |
issuer | Certification issuer | string |
credential_id | Credential ID assigned by professional network | string |
certificate_url | Certification URL | string |
issue_date | Certification issue date | string |
expiration_date | Certification expiry date | string |
issuer_url | Institution profile URL | string |
order_in_profile | Section record order | number (integer) |
issue_date_year | Year parsed from the issue_date | number (integer) |
issue_date_month | Month parsed from the issue_date | number (integer) |
expiration_date_year | Year parsed from the expiration_date | number (integer) |
expiration_date_month | Month parsed from the expiration_date | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | number (integer) |
certifications_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
courses | Member courses | array of objects |
organizer | Course organizer | string |
title | Course name | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
courses_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
education | Member education information | array of objects |
institution | Institution name | string |
program | Educational program | string |
enrolment_date | Education start date | string |
graduation_date | Education end date | string |
activities_and_societies | Activities and societies the member took part in | string |
description | Education experience described by the member Note: contains HTML tags | string |
institution_url | Institution profile | string |
institution_shorthand_name | Institution shorthand name | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
education_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
experience | Member experience information | array of objects |
title | Job title | string |
location | Job (company) location | string |
company_name | Company the person has worked for | string |
company_url | Profile of the company the person has worked for on professional network | string |
company_shorthand_name | Company shorthand name | string |
date_from | Employment start date | string |
date_to | Employment end date | string |
is_current | Marks if the experience is ongoing (current member workplace) | boolean |
duration | Employment duration | string |
description | Job/job experience description Note: contains HTML tags | string |
order_in_profile | Section record order | number (integer) |
date_from_year | Year parsed from the date_from | number (integer) |
date_from_month | Month parsed from the date_from | number (integer) |
date_to_year | Year parsed from the date_to | number (integer) |
date_to_month | Month parsed from the date_to | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | number (integer) |
experience_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | number (integer) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
languages | Member language knowledge | array of objects |
language | Language | string |
proficiency | Language proficiency | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
languages_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
organizations | Member organizations | array of objects |
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_to | Membership end date | string |
order_in_profile | Section record order | number (integer) |
date_from_year | Year parsed from the date_from | number (integer) |
date_from_month | Month parsed from the date_from | number (integer) |
date_to_year | Year parsed from the date_to | number (integer) |
date_to_month | Month parsed from the date_to | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
organizations_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
patents | Member registered patents | array of objects |
title | Patent title | string |
status | Patent status | string |
inventors | Patent inventors | array of objects |
full_name | Inventor name | string |
profile_url | Inventor profile URL | string |
order_in_profile | Section record order | number (integer) |
patents_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
patents_inventors_hash_id | Inventor identification key processed by the MD5 algorithm | string |
date | The date the patent was filled | string |
patent_url | Patent URL | string |
description | Patent description Note: contains HTML tags | string |
patent_or_application_number | Includes patent details, such as the area the patent is valid in | string |
date_year | Year parsed from the date | number (integer) |
date_month | Month parsed from the date | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
projects | Member projects | array of objects |
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_to | Project end date | string |
team_members | Additional people who have worked on the project | array of objects |
name | Team member's name | string |
profile_url | Team member's professional network profile | string |
order_in_profile | Section record order | number (integer) |
projects_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
projects_team_members_hash_id | Team member identification key processed by the MD5 algorithm | string |
date_from_year | Year parsed from the date_from | number (integer) |
date_from_month | Month parsed from the date_from | number (integer) |
date_to_year | Year parsed from the date_to | number (integer) |
date_to_month | Month parsed from the date_to | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
See snippets of the dataset for reference:
Data point | Description | Data type |
publications | Member publications | array of objects |
title | Publication title | string |
publisher | Publication publisher | string |
date | Publication release date | string |
description | Publication description Note: contains HTML tags | string |
authors | Publication authors | array of objects |
name | Author name | string |
profile_url | Author profile URL | string |
order_in_profile | Section record order | number |
publications_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
publications_authors_hash_id | Author identification key processed by the MD5 algorithm | string |
publication_url | Publication website URL | string |
date_year | Year parsed from the date | number (integer) |
date_month | Month parsed from thedate | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
recommendations | Recommendations from other people for the record member | array of objects |
recommendation | Recommendation text | string |
referee_name | Referee name | string |
referee_url | Referee profile URL | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
recommendations_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
similar_profiles | Profiles similar to the member profile in the given record | array of objects |
profile_url | Member profile URL | string |
full_name | Member name | string |
headline | Featured profile title Note: not directly related to any particular work experience | string |
location | Member location | string |
order_in_profile | Section record order | number |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
similar_profiles_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
test_scores | Member test scores | array of objects |
title | Test title | string |
date | Test date | string |
description | Test description | string |
score | Test score | string |
order_in_profile | Section record order | number |
date_year | Year parsed from thedate | number (integer) |
date_month | Month parsed from thedate | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
test_scores_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
volunteering_positions | Member volunteering experience | array of objects |
organization | Voluntary organization | string |
role | The role the member has taken in the organization | string |
cause | Volunteering cause | string |
date_from | Volunteering start date | string |
date_to | Volunteering end date | string |
duration | Volunteering activity duration | string |
description | Voluntary organization/volunteering experience description Note: contains HTML tags | string |
organization_url | Organization profile on professional network | string |
organization_shorthand_name | Organization shorthand name. | string |
order_in_profile | Section record order | number (integer) |
date_from_year | Year parsed from thedate_from | number (integer) |
date_from_month | Month parsed from thedate_from | number (integer) |
date_to_year | Year parsed from thedate_to | number (integer) |
date_to_month | Month parsed from thedate_to | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
volunteering_positions_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
websites | Member websites | array of objects |
personal_website | Member website | object |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
websites_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
course_suggestions | Courses suggested on member profile | array of objects |
course_url | Course URL | string |
title | Course name | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
course_suggestions_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
activity | Member interaction with posts on professional network | array of objects |
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) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
activity_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
received_at | Profile parsing date | string |
id | Member identification key | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
See a snippet of the dataset for reference:
Data point | Description | Data type |
country_iso_2 | ISO 3166-1 alpha-2 country code | string |
country_iso_3 | ISO 3166-1 alpha-3 country code | string |
regions | Member region information (additional location information) | array of objects |
region | Member location region | string |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
regions_hash_id | Region identification key processed by the MD5 algorithm | 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 information from public profiles.
Data point | Description | Data type |
groups | Member groups | array of objects |
title | Group name | string |
url | Group page URL | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
groups_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
Refer to the table example from the data:
Data point | Description | Data type |
interests | Member interests | array of objects |
interest | Member interest | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
interests_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
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) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
posts_see_more_urls_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
Refer to the table example from the data:
Data point | Description | Data type |
skills | Member skills | array of objects |
skill | Member skill | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
skills_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
Refer to the table example from the data:
Data point | Description | Data type |
volunteering_cares | Member volunteering cares | array of objects |
care | Volunteering care name | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
volunteering_cares_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
Refer to the table example from the data:
Data point | Description | Data type |
volunteering_opportunities | Member volunteering opportunities | array of objects |
opportunity | Opportunity name | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
volunteering_opportunities_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
Refer to the table example from the data:
Data point | Description | Data type |
volunteering_supports | Member volunteering supports | array of objects |
support | Volunteering support name | string |
order_in_profile | Section record order | number (integer) |
member_hash_id | Member identification key processed by the MD5 algorithm | string |
volunteering_supports_hash_id | Identification key assigned to the record visible in the object and processed by the MD5 algorithm | string |
Refer to the table example from the data: