Dataset: LinkedIn Job Postings Dataset

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

53.94 KB
13761 rows
3 columns


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

Companies

@kaggle.rajatraj0502_linkedin_job_2023.companies

3.3 MB
6063 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

75.36 KB
15880 rows
2 columns


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

Company Specialities

@kaggle.rajatraj0502_linkedin_job_2023.company_specialities

626.6 KB
128355 rows
2 columns


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

Employee Counts

@kaggle.rajatraj0502_linkedin_job_2023.employee_counts

163.43 KB
15907 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

126.3 KB
21993 rows
2 columns


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

Job Postings

@kaggle.rajatraj0502_linkedin_job_2023.job_postings

29.04 MB
15886 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

133.55 KB
27899 rows
2 columns


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