Dataset: NHS Jobs

About this Dataset

NHS Jobs

Context

This data was scraped from the NHS jobs website.
The dataset will be valuable to those who seek to understand the the job market of doctors for the NHS within the UK.

Content

This data only includes jobs that were deemed as being related to doctors from March 2019 to October 2019. Fields relating to a json file derive from a json file embedded in the HTML code. These fields are typically easier to work with as they contain less user inputted data.

Acknowledgements

The NHS.

Inspiration

What variables constitute to salary?
Can salary be predicted?
What important bits of information can be extracted from the job descriptions?

Tables

Jobs Raw

@kaggle.homelesssandwich_nhs_jobs.jobs_raw

63.98 MB
27482 rows
29 columns


CREATE TABLE jobs_raw (
  "job_title" VARCHAR,
  "job_reference" VARCHAR,
  "employer" VARCHAR,
  "employer_postcode" VARCHAR,
  "department" VARCHAR,
  "location" VARCHAR,
  "salary" VARCHAR,
  "job_type" VARCHAR,
  "working_pattern" VARCHAR,
  "pay_scheme" VARCHAR,
  "pay_band" VARCHAR,
  "staff_group" VARCHAR,
  "specialty" VARCHAR,
  "full_description" VARCHAR,
  "json_salary_max" DOUBLE,
  "json_salary_min" DOUBLE,
  "json_salary_unit" VARCHAR,
  "json_salary_value" VARCHAR,
  "json_date_posted" VARCHAR,
  "json_description" VARCHAR,
  "json_employment_type" VARCHAR,
  "json_hire_name" VARCHAR,
  "json_address_locality" VARCHAR,
  "json_address_postcode" VARCHAR,
  "json_lat" DOUBLE,
  "json_lng" DOUBLE,
  "json_title" VARCHAR,
  "json_closing_date" VARCHAR,
  "scrape_dt" VARCHAR
);