Raw Data
This data dictionary shows all available data points, explains their values, and provides raw job posting data samples.
All tables have snippets of the Professional Network Job Postings dataset.
All company information mentioned in this data dictionary is fictional and is solely intended for illustrative purposes.
A null value means that the information was not listed on the job posting.
Data point | Description | Data type |
time_posted | The time when the record was posted | string |
title | Job title | string |
description | Job description Note: contains control characters. | string |
seniority | Job seniority level | string |
employment_type | Full-time or part-time work | string |
location | Job location | string |
url | Job posting URL | string |
hash | Job posting URL processed by the MD5 algorithm | string |
company_id | Company identification key, relating directly to the company table | number (integer) |
company_name | Company name | string |
company_url | Company profile URL | string |
external_url | External URL provided by the company referring to the job posting | string |
application_active | One of two values possible - 1 or 0. 0 - the last time we scraped the job posting, the job posting was no longer available 1 - as of the last time the job posting was scraped, the information was still valid | boolean |
salary | Salary offered for the job position | string |
applicants_count | The number of applicants | string |
professional_network_job_id | Professional network in-house job ID (static) | number (integer) |
country | Job location (country) | string |
last_updated_ux | The date and time when the record was last updated (Unix time) | number (integer) |
redirected_url | URL where we are redirected while trying to access the job posting | string |
redirected_url_hash | Redirected URL processed by the MD5 algorithm | string |
The main job table data sample:
Data point | Description | Data type |
job_functions_collection | Consists of record metadata and job_function_list objects | array of objects |
function_id | Identification key relating to the job_function_list table | number (integer) |
job_function_list | Information on the job functions in the job ad | object |
function | Job function title | string |
hash | Job function title processed by the MD5 algorithm | string |
Job functions table data sample:
Data point | Description | Data type |
job_industries_collection | Consists of record metadata and job_industry_list objects | array of objects |
industry_id | Identification key relating to the job_industry_list table | number (integer_ |
job_industry_list | Information on the job industry | object |
industry | Job industry title | string |
hash | Job industry title processed by the MD5 algorithm | string |
Industries table data sample: