Baselight
Sign In

UK Gender Pay Gap Data 2018-2023

Tracking Equality: Insights from the UK Gender Pay Gap 2018-23 - [Updated]

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023

Loading...
Loading...

About this Dataset

UK Gender Pay Gap Data 2018-2023

Context

In the United Kingdom, it's mandated by law that any organization employing over 250 individuals must disclose their gender pay gap data annually. This is not to be mistaken with equal pay, which is the legal obligation to pay men and women the same for equivalent work. The gender pay gap, on the other hand, is a broader measure that looks at the average differences in pay, seniority, and career advancement between male and female employees. This makes it a more potent indicator of gender equality and institutional bias within organizations.

Content

Geography: United Kingdom

Time period: 2018-2023

Unit of analysis: UK Gender Pay Gap

Dataset: This dataset currently contains data collected by the Gender Pay Gap Service for the 2018 to 2023 reporting years. More data will be added as it becomes available.

At present, the Gender Pay Gap Service only provides data downloads in CSV format, divided by the reporting year. This dataset amalgamates all the available CSV files, with column descriptions and file introductions informed by my firsthand experience working on the Gender Pay Gap Service website for the Government Equalities Office.

Variables

Field Description Source
EmployerName The name of the employer at the time of reporting Via CoHo API or manually entered by user
EmployerID Unique ID assigned to each employer that is consistent across every reporting year Generated by the system
Address The current registered address of the employer Via CoHo API or manually entered by user
PostCode The postal code of the current registered address of the employer Via CoHo API or manually entered by user
CompanyNumber The Company Number of the employer as listed on Companies House (null for public sector) Via CoHo API
SicCodes List of comma-separated SIC codes used to describe the employer's purpose and sectors of work Via CoHo API or manually entered by user
DiffMeanHourlyPercent Mean % difference between male and female hourly pay (negative = women's mean hourly pay is higher) Entered by a user when reporting GPG data
DiffMedianHourlyPercent Median % difference between male and female hourly pay (negative = women's median hourly pay is higher) Entered by a user when reporting GPG data
DiffMeanBonusPercent Mean % difference between male and female bonus pay (negative = women's mean bonus pay is higher) Entered by a user when reporting GPG data
DiffMedianBonusPercent Median % difference between male and female bonus pay (negative = women's median bonus pay is higher) Entered by a user when reporting GPG data
MaleBonusPercent Percentage of male employees paid a bonus Entered by a user when reporting GPG data
FemaleBonusPercent Percentage of female employees paid a bonus Entered by a user when reporting GPG data
MaleLowerQuartile Percentage of males in the lower hourly pay quarter Entered by a user when reporting GPG data
FemaleLowerQuartile Percentage of females in the lower hourly pay quarter Entered by a user when reporting GPG data
MaleLowerMiddleQuartile Percentage of males in the lower middle hourly pay quarter Entered by a user when reporting GPG data
FemaleLowerMiddleQuartile Percentage of females in the lower middle hourly pay quarter Entered by a user when reporting GPG data
MaleUpperMiddleQuartile Percentage of males in the upper middle hourly pay quarter Entered by a user when reporting GPG data
FemaleUpperMiddleQuartile Percentage of females in the upper middle hourly pay quarter Entered by a user when reporting GPG data
MaleTopQuartile Percentage of males in the top hourly pay quarter Entered by a user when reporting GPG data
FemaleTopQuartile Percentage of females in the top hourly pay quarter Entered by a user when reporting GPG data
CompanyLinkToGPGInfo Voluntary link to additional GPG data published by the reporting employer Entered by a user when reporting GPG data
ResponsiblePerson The name of the responsible person who confirms that the published information is accurate - Employers covered by the private sector regulations only Entered by a user when reporting GPG data
EmployerSize Number of employees employed by an employer Entered by a user when reporting GPG data
CurrentName The current name of the employer Via CoHo API or manually entered by user
SubmittedAfterTheDeadline TRUE/FALSE value showing whether the employee submitted their GPG data after the relevant reporting deadline. If a report is updated after the initial submission, it is marked as late only if the figures are changed Generated by the system
DueDate The date that the GPG data should have been submitted by. Format: dd/MM/yyyy HH:mm:ss Generated by the system
DateSubmitted Date that GPG data was submitted (if this was updated after the initial submission, this date also changes). Format: dd/MM/yyyy HH:mm:ss Generated by the system

Acknowledgements

Datasource: GOV.UK Gender Pay Gap Services

Inspiration: ons.gov.uk

Tables

Paygap

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.paygap
  • 4.43 MB
  • 48711 rows
  • 27 columns
Loading... 

CREATE TABLE paygap (
  "employer_name" VARCHAR,
  "employer_id" BIGINT,
  "address" VARCHAR,
  "post_code" VARCHAR,
  "company_number" VARCHAR,
  "sic_codes" VARCHAR,
  "diff_mean_hourly_percent" DOUBLE,
  "diff_median_hourly_percent" DOUBLE,
  "diff_mean_bonus_percent" DOUBLE,
  "diff_median_bonus_percent" DOUBLE,
  "male_bonus_percent" DOUBLE,
  "female_bonus_percent" DOUBLE,
  "male_lower_quartile" DOUBLE,
  "female_lower_quartile" DOUBLE,
  "male_lower_middle_quartile" DOUBLE,
  "female_lower_middle_quartile" DOUBLE,
  "male_upper_middle_quartile" DOUBLE,
  "female_upper_middle_quartile" DOUBLE,
  "male_top_quartile" DOUBLE,
  "female_top_quartile" DOUBLE,
  "company_link_to_gpg_info" VARCHAR,
  "responsible_person" VARCHAR,
  "employer_size" VARCHAR,
  "current_name" VARCHAR,
  "submitted_after_the_deadline" BOOLEAN,
  "due_date" VARCHAR,
  "date_submitted" VARCHAR
);

Sic07 Ch Condensed List En

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.sic07_ch_condensed_list_en
  • 21.44 KB
  • 731 rows
  • 2 columns
Loading... 

CREATE TABLE sic07_ch_condensed_list_en (
  "sic_code" BIGINT,
  "description" VARCHAR
);

Uk Gender Pay Gap Data 2017 To 2018

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.uk_gender_pay_gap_data_2017_to_2018
  • 1.62 MB
  • 10230 rows
  • 27 columns
Loading... 

CREATE TABLE uk_gender_pay_gap_data_2017_to_2018 (
  "employername" VARCHAR,
  "employerid" BIGINT,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "companynumber" VARCHAR,
  "siccodes" VARCHAR,
  "diffmeanhourlypercent" DOUBLE,
  "diffmedianhourlypercent" DOUBLE,
  "diffmeanbonuspercent" DOUBLE,
  "diffmedianbonuspercent" DOUBLE,
  "malebonuspercent" DOUBLE,
  "femalebonuspercent" DOUBLE,
  "malelowerquartile" DOUBLE,
  "femalelowerquartile" DOUBLE,
  "malelowermiddlequartile" DOUBLE,
  "femalelowermiddlequartile" DOUBLE,
  "maleuppermiddlequartile" DOUBLE,
  "femaleuppermiddlequartile" DOUBLE,
  "maletopquartile" DOUBLE,
  "femaletopquartile" DOUBLE,
  "companylinktogpginfo" VARCHAR,
  "responsibleperson" VARCHAR,
  "employersize" VARCHAR,
  "currentname" VARCHAR,
  "submittedafterthedeadline" BOOLEAN,
  "duedate" TIMESTAMP,
  "datesubmitted" TIMESTAMP
);

Uk Gender Pay Gap Data 2018 To 2019

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.uk_gender_pay_gap_data_2018_to_2019
  • 1.64 MB
  • 10471 rows
  • 27 columns
Loading... 

CREATE TABLE uk_gender_pay_gap_data_2018_to_2019 (
  "employername" VARCHAR,
  "employerid" BIGINT,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "companynumber" VARCHAR,
  "siccodes" VARCHAR,
  "diffmeanhourlypercent" DOUBLE,
  "diffmedianhourlypercent" DOUBLE,
  "diffmeanbonuspercent" DOUBLE,
  "diffmedianbonuspercent" DOUBLE,
  "malebonuspercent" DOUBLE,
  "femalebonuspercent" DOUBLE,
  "malelowerquartile" DOUBLE,
  "femalelowerquartile" DOUBLE,
  "malelowermiddlequartile" DOUBLE,
  "femalelowermiddlequartile" DOUBLE,
  "maleuppermiddlequartile" DOUBLE,
  "femaleuppermiddlequartile" DOUBLE,
  "maletopquartile" DOUBLE,
  "femaletopquartile" DOUBLE,
  "companylinktogpginfo" VARCHAR,
  "responsibleperson" VARCHAR,
  "employersize" VARCHAR,
  "currentname" VARCHAR,
  "submittedafterthedeadline" BOOLEAN,
  "duedate" TIMESTAMP,
  "datesubmitted" TIMESTAMP
);

Uk Gender Pay Gap Data 2019 To 2020

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.uk_gender_pay_gap_data_2019_to_2020
  • 1.11 MB
  • 6924 rows
  • 27 columns
Loading... 

CREATE TABLE uk_gender_pay_gap_data_2019_to_2020 (
  "employername" VARCHAR,
  "employerid" BIGINT,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "companynumber" VARCHAR,
  "siccodes" VARCHAR,
  "diffmeanhourlypercent" DOUBLE,
  "diffmedianhourlypercent" DOUBLE,
  "diffmeanbonuspercent" DOUBLE,
  "diffmedianbonuspercent" DOUBLE,
  "malebonuspercent" DOUBLE,
  "femalebonuspercent" DOUBLE,
  "malelowerquartile" DOUBLE,
  "femalelowerquartile" DOUBLE,
  "malelowermiddlequartile" DOUBLE,
  "femalelowermiddlequartile" DOUBLE,
  "maleuppermiddlequartile" DOUBLE,
  "femaleuppermiddlequartile" DOUBLE,
  "maletopquartile" DOUBLE,
  "femaletopquartile" DOUBLE,
  "companylinktogpginfo" VARCHAR,
  "responsibleperson" VARCHAR,
  "employersize" VARCHAR,
  "currentname" VARCHAR,
  "submittedafterthedeadline" BOOLEAN,
  "duedate" TIMESTAMP,
  "datesubmitted" TIMESTAMP
);

Uk Gender Pay Gap Data 2020 To 2021

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.uk_gender_pay_gap_data_2020_to_2021
  • 1.65 MB
  • 10536 rows
  • 27 columns
Loading... 

CREATE TABLE uk_gender_pay_gap_data_2020_to_2021 (
  "employername" VARCHAR,
  "employerid" BIGINT,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "companynumber" VARCHAR,
  "siccodes" VARCHAR,
  "diffmeanhourlypercent" DOUBLE,
  "diffmedianhourlypercent" DOUBLE,
  "diffmeanbonuspercent" DOUBLE,
  "diffmedianbonuspercent" DOUBLE,
  "malebonuspercent" DOUBLE,
  "femalebonuspercent" DOUBLE,
  "malelowerquartile" DOUBLE,
  "femalelowerquartile" DOUBLE,
  "malelowermiddlequartile" DOUBLE,
  "femalelowermiddlequartile" DOUBLE,
  "maleuppermiddlequartile" DOUBLE,
  "femaleuppermiddlequartile" DOUBLE,
  "maletopquartile" DOUBLE,
  "femaletopquartile" DOUBLE,
  "companylinktogpginfo" VARCHAR,
  "responsibleperson" VARCHAR,
  "employersize" VARCHAR,
  "currentname" VARCHAR,
  "submittedafterthedeadline" BOOLEAN,
  "duedate" TIMESTAMP,
  "datesubmitted" TIMESTAMP
);

Uk Gender Pay Gap Data 2021 To 2022

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.uk_gender_pay_gap_data_2021_to_2022
  • 1.64 MB
  • 10425 rows
  • 27 columns
Loading... 

CREATE TABLE uk_gender_pay_gap_data_2021_to_2022 (
  "employername" VARCHAR,
  "employerid" BIGINT,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "companynumber" VARCHAR,
  "siccodes" VARCHAR,
  "diffmeanhourlypercent" DOUBLE,
  "diffmedianhourlypercent" DOUBLE,
  "diffmeanbonuspercent" DOUBLE,
  "diffmedianbonuspercent" DOUBLE,
  "malebonuspercent" DOUBLE,
  "femalebonuspercent" DOUBLE,
  "malelowerquartile" DOUBLE,
  "femalelowerquartile" DOUBLE,
  "malelowermiddlequartile" DOUBLE,
  "femalelowermiddlequartile" DOUBLE,
  "maleuppermiddlequartile" DOUBLE,
  "femaleuppermiddlequartile" DOUBLE,
  "maletopquartile" DOUBLE,
  "femaletopquartile" DOUBLE,
  "companylinktogpginfo" VARCHAR,
  "responsibleperson" VARCHAR,
  "employersize" VARCHAR,
  "currentname" VARCHAR,
  "submittedafterthedeadline" BOOLEAN,
  "duedate" TIMESTAMP,
  "datesubmitted" TIMESTAMP
);

Uk Gender Pay Gap Data 2022 To 2023

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.uk_gender_pay_gap_data_2022_to_2023
  • 48.25 KB
  • 125 rows
  • 27 columns
Loading... 

CREATE TABLE uk_gender_pay_gap_data_2022_to_2023 (
  "employername" VARCHAR,
  "employerid" BIGINT,
  "address" VARCHAR,
  "postcode" VARCHAR,
  "companynumber" VARCHAR,
  "siccodes" VARCHAR,
  "diffmeanhourlypercent" DOUBLE,
  "diffmedianhourlypercent" DOUBLE,
  "diffmeanbonuspercent" DOUBLE,
  "diffmedianbonuspercent" DOUBLE,
  "malebonuspercent" DOUBLE,
  "femalebonuspercent" DOUBLE,
  "malelowerquartile" DOUBLE,
  "femalelowerquartile" DOUBLE,
  "malelowermiddlequartile" DOUBLE,
  "femalelowermiddlequartile" DOUBLE,
  "maleuppermiddlequartile" DOUBLE,
  "femaleuppermiddlequartile" DOUBLE,
  "maletopquartile" DOUBLE,
  "femaletopquartile" DOUBLE,
  "companylinktogpginfo" VARCHAR,
  "responsibleperson" VARCHAR,
  "employersize" VARCHAR,
  "currentname" VARCHAR,
  "submittedafterthedeadline" BOOLEAN,
  "duedate" TIMESTAMP,
  "datesubmitted" TIMESTAMP
);

Share link

Anyone who has the link will be able to view this.