Name: LinkedIn Job Postings Dataset
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

LinkedIn Job Postings Dataset

Description

This dataset contains information about job postings on LinkedIn. The data is divided into several files, each containing different aspects of the job postings:

job_postings.csv: This file contains detailed information about each job posting, including the job title, description, salary, work type, location, and more.
companies.csv: This file contains detailed information about each company that posted a job, including the company name, website, description, size, location, and more.
company_industries.csv: This file contains the industries associated with each company.
company_specialities.csv: This file contains the specialties associated with each company.
employee_counts.csv: This file contains the employee and follower counts for each company.
benefits.csv: This file contains the benefits associated with each job.
job_industries.csv: This file contains the industries associated with each job.
job_skills.csv: This file contains the skills associated with each job.

Usage

This dataset can be used for various purposes such as:

Analyzing the job market
Analyzing company trends
Analyzing salary trends
Building a job recommendation system
Natural Language Processing (NLP) tasks such as keyword extraction, topic modeling, etc.

Acknowledgements

This dataset was collected from LinkedIn. Please note that the data may be subject to LinkedIn's terms of use.

License

This dataset is released under the Open Database License (ODbL).

Tables

Benefits

@kaggle.rajatraj0502_linkedin_job_2023.benefits

55.23 kB
13,761 rows
3 columns

CREATE TABLE benefits (
  "job_id" BIGINT,
  "inferred" BIGINT,
  "type" VARCHAR
);

Companies

@kaggle.rajatraj0502_linkedin_job_2023.companies

3.46 MB
6,063 rows
10 columns

CREATE TABLE companies (
  "company_id" BIGINT,
  "name" VARCHAR,
  "description" VARCHAR,
  "company_size" DOUBLE,
  "state" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "address" VARCHAR,
  "url" VARCHAR
);

Company Industries

@kaggle.rajatraj0502_linkedin_job_2023.company_industries

77.17 kB
15,880 rows
2 columns

CREATE TABLE company_industries (
  "company_id" BIGINT,
  "industry" VARCHAR
);

Company Specialities

@kaggle.rajatraj0502_linkedin_job_2023.company_specialities

641.64 kB
128,355 rows
2 columns

CREATE TABLE company_specialities (
  "company_id" BIGINT,
  "speciality" VARCHAR
);

Employee Counts

@kaggle.rajatraj0502_linkedin_job_2023.employee_counts

167.35 kB
15,907 rows
4 columns

CREATE TABLE employee_counts (
  "company_id" BIGINT,
  "employee_count" BIGINT,
  "follower_count" BIGINT,
  "time_recorded" DOUBLE
);

Job Industries

@kaggle.rajatraj0502_linkedin_job_2023.job_industries

129.34 kB
21,993 rows
2 columns

CREATE TABLE job_industries (
  "job_id" BIGINT,
  "industry_id" BIGINT
);

Job Postings

@kaggle.rajatraj0502_linkedin_job_2023.job_postings

30.46 MB
15,886 rows
27 columns

CREATE TABLE job_postings (
  "job_id" BIGINT,
  "company_id" DOUBLE,
  "title" VARCHAR,
  "description" VARCHAR,
  "max_salary" DOUBLE,
  "med_salary" DOUBLE,
  "min_salary" DOUBLE,
  "pay_period" VARCHAR,
  "formatted_work_type" VARCHAR,
  "location" VARCHAR,
  "applies" DOUBLE,
  "original_listed_time" DOUBLE,
  "remote_allowed" DOUBLE,
  "views" DOUBLE,
  "job_posting_url" VARCHAR,
  "application_url" VARCHAR,
  "application_type" VARCHAR,
  "expiry" DOUBLE,
  "closed_time" DOUBLE,
  "formatted_experience_level" VARCHAR,
  "skills_desc" VARCHAR,
  "listed_time" DOUBLE,
  "posting_domain" VARCHAR,
  "sponsored" BIGINT,
  "work_type" VARCHAR,
  "currency" VARCHAR,
  "compensation_type" VARCHAR
);

Job Skills

@kaggle.rajatraj0502_linkedin_job_2023.job_skills

136.76 kB
27,899 rows
2 columns

CREATE TABLE job_skills (
  "job_id" BIGINT,
  "skill_abr" VARCHAR
);