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
Tracking Equality: Insights from the UK Gender Pay Gap 2018-23 - [Updated]
@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023
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.
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.
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 |
Datasource: GOV.UK Gender Pay Gap Services
Inspiration: ons.gov.uk
Anyone who has the link will be able to view this.