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
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
);
CREATE TABLE sic07_ch_condensed_list_en (
"sic_code" BIGINT,
"description" VARCHAR
);
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.