# 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 %}
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.coresignal.com/employee-data/base-employee-data/dictionary-base-employee-data.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.