Dictionary: Base Jobs Data
This data dictionary shows all available data fields, explains their values, and provides jobs data samples.
All tables have snippets of the Base Jobs dataset.
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
Metadata
professional_network_job_id
Job ID
Integer
id
Identification key for a job profile record
Integer
date_posted
Job ad publish date
Timestamp
posted
Job ad publish time (as displayed on Professional network)
String
valid_through
Expiry date
Timestamp
url
Job posting URL
String
application_active
One of two possible values:
0 – the last time we scraped the job posting, the job posting was deactivated.
1 – the last time we scraped the job posting, it was still active
Integer
deleted
One of two possible values:
0 – job posting is available and was successfully scraped
1 – the last time we scraped the job posting, the Page not found was returned
Integer
created_at
The time and date when we first scraped the record
Timestamp
updated_at
The time and date when we updated the record
Timestamp
Refer to the table example from the data:
Job information
title
Job title
String
description
Job description Note: contains control characters.
String
seniority
Job seniority level
String
employment_type
Standardised values to display one of the values: “Full-time “, “Part-time“, “Contract”, “Temporary“, “Internship“, “Volunteer“
String
external_url
External URL provided by the company referring to the job posting
String
location
Job location
String
country
Job country location
String
country_iso_2
ISO 2-letter code of the location country (based on location and/or country values)
String
country_iso_2
ISO 3-letter code of the location country (based on location and/or country values)
String
state
Job location state (if available)
String
city
Job location city
String
regions
Associated geographical regions based on location and/or country values
Array of strings
latitude
Latitude of location (if available)
Float
longitude
Longitude of location (if available)
Float
required_months_of_experience
Experience in months requirements
Integer
applicants_count
Number of applicants
String
estimated_applicants_count
Estimated number of applicants. E.g.,
“Be among the first 25 applicants” = -1
“Over 200 applicants” = 200
Integer
functions
Standardized job functions
Array of strings
industries
Listed industries
Array of strings
Refer to the table example from the data:
Recruiter information
recruiter
Recruiter information
Struct
profile_url
Recruiter's profile url
String
name
Recruiter's name
String
description
Recruiter's description
String
Refer to the table example from the data:
Company information
company_id
Company identification key, relating directly to the company table
Long
company
Company information
Struct
name
Company name
String
url
Company profile URL
String
logo_url
Company logo URL
String
Refer to the table example from the data:
Salary
salary
All salary records for this job
Struct
string
Full and formatted salary field value
String
min_value
Minimum advertised salary
String
max_value
Maximum advertised salary
String
currency
Salary currency
String
unit
The unit of measurement or period associated with the salary values
String
Refer to the table example from the data:
Benefits
benefits
Listed position benefits
Array of strings
Refer to the table example from the data:
Last updated
Was this helpful?