# Dictionary: Base Employee Data
This data dictionary displays all available data fields, explains their values, and provides snippets of data from the Employee dataset.
{% tabs %}
{% tab title="Data fields per category" %}
1. [Root table](#root-table)
2. [Awards](#awards)
3. [Certifications](#certifications)
4. [Courses](#courses)
5. [Education](#education)
6. [Experience](#experience)
7. [Languages](#languages)
8. [Organizations](#organizations)
9. [Patents](#patents)
10. [Projects](#projects)
11. [Publications](#publications)
12. [Recommendations](#recommendations)
13. [Similar profiles](#similar-profiles)
14. [Others named](#others-named)
15. [Test scores](#test-scores)
16. [Volunteering positions](#volunteering-positions)
17. [Websites](#websites)
18. [Course suggestions](#course-suggestions)
19. [Activity](#activity)
20. [Inferred skills](#inferred-skills)
{% endtab %}
{% tab title="Legacy data – obtain on demand" %}
{% hint style="danger" %}
The following legacy categories are excluded from Base Employee schema and data dumps. This data can be obtained only on demand.
{% endhint %}
1. [Also viewed](#also-viewed)
2. [Groups](#groups)
3. [Interests](#interests)
4. [See more URLs](#see-more-urls)
5. [Skills](#skills)
6. [Volunteering cares](#volunteering-cares)
7. [Volunteering opportunities](#volunteering-opportunities)
8. [Volunteering supports](#volunteering-supports)
{% endtab %}
{% endtabs %}
{% hint style="info" %}
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
{% endhint %}
### Root table
| Data field | Description | Data type |
| -------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------- |
| `id` | Record identification key | Long |
| `parent_id` | Employee profile identification key | Long |
| `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 |
| `city` | Employee location city | String |
| `state` | Employee location state | String |
| `industry` | Associated industry
Note: legacy field
| String |
| `summary` | Professional experience summary | String |
| `services` | Offered services | String |
| `recommendations_count` | Number of recommendations | Integer |
| `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 structs |
**Refer to the table example from the data:**
```json
{
"id": 101,
"parent_id": 101,
"full_name": "John Doe",
"first_name": "John",
"last_name": "Doe",
"headline": "Software Engineer",
"created_at": "2024-12-10T12:00:00Z",
"updated_at": "2024-12-10T12:00:00Z",
"checked_at": "2024-12-10T12:00:00Z",
"public_profile_id": "422009225",
"profile_url": "http://example.com/johndoe",
"location": "New York, USA",
"city": "New York",
"state": "New York",
"industry": "Technology",
"summary": "Experienced software engineer with expertise in Python and Spark.",
"services": "Consulting, Development",
"profile_photo_url": "http://example.com/johndoe/photo.jpg",
"deleted": 0,
"country": "USA",
"country_iso_2": "US",
"country_iso_3": "USA",
"regions": [
{
"region": "Northeast"
}
],
"recommendations_count": 10,
"connections_count": 500,
"follower_count": 1500,
"experience_count": 5,
"shorthand_name": "johndoe",
"canonical_shorthand_name": "johndoe",
"shorthand_names": [
{
"shorthand_name": "johndoe"
}
],
"historical_ids": [
{
"id": 1001
}
]
}
```
***
| Data field | 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:**
```json
"is_parent": 1
```
### Awards
| Data field | Description | Data type |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------- |
| `awards` | Awards | Array of objects |
| `id` | Record UUID identifier | String |
| `title` | Award title | String |
| `issuer` | Award issuer | String |
| `description` | Award description | 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:**
{% code title="Awards" %}
```json
"awards": [
{
"id": "c8f68c94-1c90-4b36-8e0e-905cf2e1283e",
"title": "Best Innovator",
"issuer": "Tech Conference 2023",
"description": "Awarded for outstanding innovation in technology.",
"date": "2023-11-15",
"date_year": 2023,
"date_month": 11,
"date_day": 15,
"order_in_profile": 1,
"deleted": 0,
"created_at": "2023-11-15T10:00:00Z",
"updated_at": "2023-11-15T12:00:00Z"
}
]
```
{% endcode %}
### Certifications
| Data field | 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 |
| `certificate_logo_url` | URL pointing to the logo of the certification provider (AWS, Microsoft, Coursera, etc.) | 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:**
{% code title="Certifications" %}
```json
"certifications": [
{
"id": "f1c4f870-8c4e-456c-a5e6-892a2be9a3b2",
"title": "Certified Data Scientist",
"issuer": "Data Science Institute",
"credential_id": "6245866",
"certificate_url": "https://example.com/certificates/dsi-2023-001",
"certificate_logo_url": "https:/example-images.com/dms/image/v2/certificate",
"date_from": "2023-01-01",
"date_from_year": 2023,
"date_from_month": 1,
"date_to": "2025-01-01",
"date_to_year": 2025,
"date_to_month": 1,
"issuer_url": "https://datascienceinstitute.org",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2023-01-01T10:00:00Z",
"updated_at": "2023-01-01T12:00:00Z"
}
]
```
{% endcode %}
### Courses
| Data field | 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:**
{% code title="Courses" %}
```json
"courses": [
{
"id": "d0f7e8e5-abc3-4e9b-8e0c-2a8b80b9f5e9",
"organizer": "Coursera",
"title": "Introduction to Machine Learning",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2023-05-01T10:00:00Z",
"updated_at": "2023-05-01T12:00:00Z"
}
]
```
{% endcode %}
### Education
| Data field | 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_to` | Graduation date | String (date) |
| `date_to_year` | Graduation year | Number (integer) |
| `activities_and_societies` | Activities and societies considered part of education | String |
| `description` | Education experience described by the person | 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 |
| `institution_logo_url` | URL pointing to the logo of the educational institution (university, school, training provider) | String |
| `order_in_profile` | Section record order | Number (integer) |
**See a snippet of the dataset for reference:**
{% code title="Education" %}
```json
"education": [
{
"id": "d1e2f3b4-56a7-8901-bcde-234567890abc",
"institution": "Harvard University",
"program": "Bachelor of Science in Computer Science",
"institution_id": 1026807,
"institution_source_id": 166807,
"date_from": "2015-09-01",
"date_from_year": 2015,
"date_to": "2019-06-01",
"date_to_year": 2019,
"activities_and_societies": "Member of the Computer Science Club and Debate Team",
"description": "Studied core computer science concepts including algorithms, machine learning, and distributed systems.",
"institution_url": "https://www.harvard.edu",
"institution_shorthand_name": "harvard",
"institution_logo_url": "https://example-images.com/dms/image/v2/education",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2015-09-01T10:00:00Z",
"updated_at": "2019-06-01T12:00:00Z"
}
]
```
{% endcode %}
### Experience
| Data field | 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 |
| `company_logo_url` | URL pointing to the logo of the company/employer | 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 or job experience description | 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:**
{% code title="Experience" %}
```json
"experience": [
{
"id": "a1b2c3d4-e5f6-7890-ab12-cd34ef567890",
"title": "Senior Software Engineer",
"location": "San Francisco, CA",
"company_id": 91823973,
"company_source_id": 1015745,
"company_name": "Tech Innovations Inc.",
"company_url": "https://www.techinnovations.com",
"company_shorthand_name": "tech-innovations",
"company_logo_url": "https://example-images.com/dms/image/v2/company-logo",
"date_from": "2019-05-01",
"date_from_year": 2019,
"date_from_month": 5,
"date_to": "2023-03-01",
"date_to_year": 2023,
"date_to_month": 3,
"is_current": 0,
"duration": "3 years 10 months",
"description": "Led a team of engineers to develop scalable web applications and improve system performance by 40%.",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2019-05-01T08:00:00Z",
"updated_at": "2023-03-01T17:00:00Z"
}
]
```
{% endcode %}
### Languages
| Data field | 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:**
{% code title="Languages" %}
```json
"languages": [
{
"id": "d3f4e5b6-7890-ab12-cd34-ef5678901234",
"language": "English",
"proficiency": "Native",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2022-01-01T10:00:00Z",
"updated_at": "2022-01-01T12:00:00Z"
}
]
```
{% endcode %}
### Organizations
| Data field | 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:**
{% code title="Organizations" %}
```json
"organizations": [
{
"id": "b1a2c3d4-5678-90ab-cdef-1234567890ab",
"organization": "Tech Community Network",
"position": "Member",
"description": "Participated in monthly meetups and collaborative projects focused on technology innovation.",
"date_from": "2020-03-01",
"date_from_year": 2020,
"date_from_month": 3,
"date_to": "2023-03-01",
"date_to_year": 2023,
"date_to_month": 3,
"order_in_profile": 1,
"deleted": 0,
"created_at": "2020-03-01T08:00:00Z",
"updated_at": "2023-03-01T17:00:00Z"
}
],
```
{% endcode %}
### Patents
| Data field | 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:**
{% code title="Patents" %}
```json
"patents": [
{
"id": "f1a2b3c4-d5e6-7890-ab12-cd34ef567890",
"title": "System for Optimized Data Processing",
"status": "Granted",
"inventors": [
{
"full_name": "John Doe",
"profile_url": "www.professional_network.com/in/johndoe",
"order_in_profile": 1
},
{
"full_name": "Jane Smith",
"profile_url": "www.professional_network.com/in/janesmith",
"order_in_profile": 2
}
],
"date": "2021-08-15",
"date_year": 2021,
"date_month": 8,
"date_day": 15,
"patent_url": "https://example.com/patents/123456",
"description": "An innovative system for efficient data processing in distributed environments.",
"patent_or_application_number": "US1234567890A",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2021-08-15T10:00:00Z",
"updated_at": "2023-03-01T12:00:00Z"
}
]
```
{% endcode %}
### Projects
| Data field | 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 | 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:**
{% code title="Projects" %}
```json
"projects": [
{
"id": "e1f2a3b4-c5d6-7890-ab12-cd34ef567890",
"name": "AI-Powered Recommendation System",
"project_url": "https://example.com/projects/recommendation-system",
"description": "Developed an AI-powered recommendation engine for e-commerce platforms, increasing conversion rates by 20%.",
"date_from": "2020-01-01",
"date_from_year": 2020,
"date_from_month": 1,
"date_to": "2022-06-01",
"date_to_year": 2022,
"date_to_month": 6,
"team_members": [
{
"full_name": "Jane Johnson",
"profile_url": "www.professional_network.com/in/janejohnson",
"order_in_profile": 1
},
{
"full_name": "Bob Doe",
"profile_url": "www.professional_network.com/in/bobdoe",
"order_in_profile": 2
}
],
"order_in_profile": 1,
"deleted": 0,
"created_at": "2020-01-01T10:00:00Z",
"updated_at": "2022-06-01T12:00:00Z"
}
]
```
{% endcode %}
### Publications
| Data field | 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:**
{% code title="Publications" %}
```json
"publications": [
{
"id": "f1e2d3c4-b5a6-7890-ab12-cd34ef567890",
"title": "Advances in Machine Learning",
"publisher": "Tech Journal",
"date": "2021-10-15",
"date_year": 2021,
"date_month": 10,
"date_day": 15,
"description": "A comprehensive study on the latest trends and advancements in machine learning techniques.",
"authors": [
{
"full_name": "John Doe",
"profile_url": "https://example.com/johndoe",
"order_in_profile": 1
},
{
"full_name": "Jane Smith",
"profile_url": "https://example.com/janesmith",
"order_in_profile": 2
}
],
"publication_url": "https://example.com/publications/machine-learning",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2021-10-15T10:00:00Z",
"updated_at": "2021-10-15T12:00:00Z"
}
]
```
{% endcode %}
### Recommendations
| Data field | 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:**
{% code title="Recommendations" %}
```json
"recommendations": [
{
"id": "a1b2c3d4-e5f6-7890-ab12-cd34ef567890",
"recommendation": "John is a highly skilled and dependable software engineer. His ability to solve complex problems and lead projects to success is remarkable.",
"full_name": "Jane Johnson",
"referee_url": "https:/www.professional_network.com/in/janejohnson",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2022-05-01T10:00:00Z",
"updated_at": "2022-05-01T12:00:00Z"
}
]
```
{% endcode %}
### Similar profiles
| Data field | 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 |
| `company` | Company name associated with the similar profile | String |
| `followers` | Follower count or description for the similar profile | 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) |
**See a snippet of the dataset for reference:**
{% code title="Similar profiles" %}
```json
"similar_profiles": [
{
"id": "b1a2c3d4-f5e6-7890-ab12-cd34ef567890",
"profile_url": "www.professional_network.com/in/janedoe",
"full_name": "Jane Doe",
"headline": "Senior Data Scientist at Tech Corp",
"location": "New York, NY",
"company": "Tech Corp",
"followers": "210",
"order_in_profile": 1,
"created_at": "2023-01-01T10:00:00Z",
"updated_at": "2023-01-01T12:00:00Z"
}
]
```
{% endcode %}
### Others named
| Data field | 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) |
{% code title="Others named" %}
```json
"others_named": [
{
"id": "b1a2c3d4-f5e6-7890-ab12-cd34ef567890",
"profile_url": "www.professional_network.com/in/janedoe",
"full_name": "Jane Doe",
"headline": "Senior Data Scientist at Tech Corp",
"location": "New York, NY",
"order_in_profile": 1,
"created_at": "2023-01-01T10:00:00Z",
"updated_at": "2023-01-01T12:00:00Z"
}
]
```
{% endcode %}
### Test scores
| Data field | 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:**
{% code title="Test scores" %}
```json
"test_scores": [
{
"id": "c1d2e3f4-a5b6-7890-ab12-cd34ef567890",
"title": "GRE General Test",
"date": "2021-09-15",
"date_year": 2021,
"date_month": 9,
"date_day": 15,
"description": "Scored in the 95th percentile on the GRE General Test, with a focus on quantitative reasoning and analytical writing.",
"score": "328",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2021-09-15T10:00:00Z",
"updated_at": "2021-09-15T12:00:00Z"
}
]
```
{% endcode %}
### Volunteering positions
| Data field | 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:**
{% code title="Volunteering positions" %}
```json
"volunteering_positions": [
{
"id": "d1e2f3a4-b5c6-7890-ab12-cd34ef567890",
"organization": "Community Aid Network",
"role": "Volunteer Coordinator",
"cause": "Poverty Alleviation",
"date_from": "2018-04-01",
"date_from_year": 2018,
"date_from_month": 4,
"date_to": "2021-12-01",
"date_to_year": 2021,
"date_to_month": 12,
"duration": "3 years 8 months",
"description": "Organized and managed volunteer activities to support low-income families through food distribution and educational programs.",
"organization_url": "www.professional_network.com/company/community-aid",
"organization_shorthand_name": "CAN",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2018-04-01T08:00:00Z",
"updated_at": "2021-12-01T17:00:00Z"
}
]
```
{% endcode %}
### Websites
| Data field | 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
| Number (integer) |
| `created_at` | Record creation timestamp in `ISO 8601` format | String (date) |
| `updated_at` | Record update timestamp in `ISO 8601` format | String (date) |
{% code title="Websites table" %}
```json
"websites": [
{
"id": "a1b2c3d4-e5f6-7890-ab12-cd34ef567890",
"personal_website": "https://www.johndoeportfolio.com",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2023-01-01T10:00:00Z",
"updated_at": "2023-01-01T12:00:00Z"
}
]
```
{% endcode %}
### Course suggestions
| Data field | 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:**
{% code title="Course suggestions" %}
```json
"course_suggestions": [
{
"id": "b1c2d3e4-f5a6-7890-ab12-cd34ef567890",
"title": "Advanced Data Science and Machine Learning",
"course_url": "https://www.example.com/courses/advanced-data-science",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2023-06-01T10:00:00Z",
"updated_at": "2023-06-01T12:00:00Z"
}
]
```
{% endcode %}
### Activity
| Data field | 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:**
{% code title="Activity" %}
```json
"activity": [
{
"id": "d1e2f3a4-b5c6-7890-ab12-cd34ef567890",
"activity_url": "https://www.example.com/activity/12345",
"title": "Shared an article on AI advancements",
"action": "Shared",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2023-07-01T10:00:00Z",
"updated_at": "2023-07-01T12:00:00Z"
}
]
```
{% endcode %}
### Inferred skills
| Data field | Description | Data type |
| ----------------- | ------------------------------------------------------------------ | ---------------- |
| `inferred_skills` | Lists employees' skills based on the descriptions from the profile | Array of strings |
**See a snippet of the dataset for reference:**
{% code title="Inferred skills" %}
```json
"inferred_skills": [
"software development",
"troubleshooting",
"web development"
]
```
{% endcode %}
## Legacy tables
The following legacy categories are excluded from Base Employee schema and data dumps. This data can be obtained only on demand.
### Also viewed
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | Description | Data type |
| ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------- |
| `also_viewed` | Other employee profiles from the`People also viewed` section | 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:**
{% code title="Also viewed" %}
```json
"also_viewed": [
{
"id": "406e4bfd-4c27-42a0-8f17-1ef70152265a",
"full_name": "John Doe",
"profile_url": "https://www.professional_network.com/in/john-doe",
"headline": "Executive Director, Capture, ManTech",
"location": "Virginia Beach, VA",
"order_in_profile": 1,
"deleted": 0,
"created_at": "2024-12-14 12:15:41",
"updated_at": "2024-12-14 12:15:41"
}
],
```
{% endcode %}
### Groups
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | 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:**
{% code title="Groups" %}
```json
"groups": [
{
"id": "e6612926024662a2857650ab6765af8a",
"title": "AI Group",
"url": "https://www.professional_network.com/groups/3205179",
"order_in_profile": 1,
"deleted": 1,
"created_at": "2023-10-07 00:31:30",
"updated_at": "2024-11-28 13:21:21"
}
]
```
{% endcode %}
### Interests
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | 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:**
{% code title="Interests table" %}
```json
"interests": [
{
"id": "d87ee2b130a249a8ab411ed0485abef0",
"interest": "sociology",
"order_in_profile": 1,
"deleted": 1,
"created_at": "2016-10-23 01:59:41",
"updated_at": "2021-11-24 10:15:02"
}
]
```
{% endcode %}
### See more URLs
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | 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:**
{% code title="post\_see\_more\_urls" %}
```json
"posts_see_more_urls": [
{
"id": "0c7211374be4061de35455d7f4c29342",
"url": "https://www.professional_network.com/today/author",
"order_in_profile": 1,
"deleted": 1,
"created_at": "2016-10-21 12:27:33",
"updated_at": "2020-04-18 12:42:54"
}
]
```
{% endcode %}
### Skills
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | 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:**
{% code title="Skills table" %}
```json
"skills": [
{
"id": "9050bf5227ebbb956c56ed0aa17acb52",
"skill": "cabinetry",
"order_in_profile": 1,
"deleted": 1,
"created_at": "2018-06-29 18:09:12",
"updated_at": "2018-11-14 07:56:41"
}
]
```
{% endcode %}
### Volunteering cares
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | 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:**
{% code title="Volunteering cares table" %}
```json
"volunteering_cares": [
{
"id": "57a8edada05719738df4323c5afbd22f",
"care": "poverty alleviation",
"order_in_profile": 1,
"deleted": 1,
"created_at": "2018-06-29 18:09:12",
"updated_at": "2018-11-14 07:56:41"
}
]
```
{% endcode %}
### Volunteering opportunities
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | 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:**
{% code title="Volunteering opportunities" %}
```json
"volunteering_opportunities": [
{
"id": "67c30beacec25e39de50659fb8e150bb",
"opportunity": "skills-based volunteering (pro bono consulting)",
"order_in_profile": 1,
"deleted": 1,
"created_at": "2016-11-27 12:25:29",
"updated_at": "2020-04-17 19:07:33"
}
]
```
{% endcode %}
### Volunteering supports
{% hint style="danger" %}
This data is not included in the schema and is available only on demand.
{% endhint %}
| Data field | 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:**
{% code title="Volunteering supports table" %}
```json
"volunteering_supports": [
{
"id": "82131a9a7776d23c8dac09f623e66c61",
"support": "atlanta area council boy scouts of america",
"order_in_profile": 1,
"deleted": 1,
"created_at": "2016-10-19 20:23:42",
"updated_at": "2021-11-25 00:17:50"
}
]
```
{% endcode %}