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

Table List

8 tables(12.16 MB)

Paygap

Sic07 Ch Condensed List En

Uk Gender Pay Gap Data 2017 To 2018

Uk Gender Pay Gap Data 2018 To 2019

Uk Gender Pay Gap Data 2019 To 2020

Uk Gender Pay Gap Data 2020 To 2021

Uk Gender Pay Gap Data 2021 To 2022

Uk Gender Pay Gap Data 2022 To 2023

Paygap

@kaggle.umerhaddii_uk_gender_pay_gap_data_2018_2023.paygap

4.43 MB
48711 rows
27 columns

employer_name Employer Name	employer_id Employer Id	address Address	post_code Post Code	company_number Company Number	sic_codes Sic Codes	diff_mean_hourly_percent Diff Mean Hourly Percent	diff_median_hourly_percent Diff Median Hourly Percent	diff_mean_bonus_percent Diff Mean Bonus Percent	diff_median_bonus_percent Diff Median Bonus Percent	male_bonus_percent Male Bonus Percent	female_bonus_percent Female Bonus Percent	male_lower_quartile Male Lower Quartile	female_lower_quartile Female Lower Quartile	male_lower_middle_quartile Male Lower Middle Quartile	female_lower_middle_quartile Female Lower Middle Quartile	male_upper_middle_quartile Male Upper Middle Quartile	female_upper_middle_quartile Female Upper Middle Quartile	male_top_quartile Male Top Quartile	female_top_quartile Female Top Quartile	company_link_to_gpg_info Company Link To Gpg Info	responsible_person Responsible Person	employer_size Employer Size	current_name Current Name	submitted_after_the_deadline Submitted After The Deadline	due_date Due Date	date_submitted Date Submitted
Bryanston School, Incorporated	676	Bryanston House, Blandford, Dorset, DT11 0PX	DT11 0PX	00226143	85310	18	28.2					24.4	75.6	50.8	49.2	49.2	50.8	51.5	48.5	https://www.bryanston.co.uk/employment	Nick McRobb (Bursar and Clerk to the Governors)	500 to 999	BRYANSTON SCHOOL INCORPORATED		2018-04-05T00:00:00Z	2018-03-27T11:42:49Z
RED BAND CHEMICAL COMPANY, LIMITED	16879	19 Smith's Place, Leith Walk, Edinburgh, EH6 8NU	EH6 8NU	SC016876	47730	2.3	-2.7	15	37.5	15.6	66.7	20.3	79.7	25.4	74.6	10.3	89.7	18.1	81.9	nan	Philip Galt (Managing Director)	250 to 499	"RED BAND" CHEMICAL COMPANY, LIMITED		2018-04-05T00:00:00Z	2018-03-28T16:44:25Z
123 EMPLOYEES LTD	17677	34 Roundhay Road, Leeds, England, LS7 1AB	LS7 1AB	10530651	78300	41	36	-69.8	-157.2	50	73.5		100	2	98	11	89	23	77	nan	Chloe Lines (Financial Controller)	250 to 499	123 EMPLOYEES LTD	true	2018-04-05T00:00:00Z	2018-05-04T11:24:06Z
1610 LIMITED	682	Trinity Sports And Leisure, Chilton Street, Bridgwater, England, TA6 3JA	TA6 3JA	06727055	93110	-22	-34	-47	-67	25	75	56	44	52	48	30	70	24	76	https://www.1610.org.uk/gender-pay-gap/	Tim Nightingale (CEO)	250 to 499	1610 LIMITED	true	2018-04-05T00:00:00Z	2018-04-12T17:03:26Z
1879 EVENTS MANAGEMENT LIMITED	17101	The Sunderland Stadium Of Light, Sunderland, Tyne And Wear, SR5 1SU	SR5 1SU	07743495	56210:70229	13.4	8.1	41.4	43.7	8.7	3.2	29.1	70.9	49.4	50.6	22.8	77.2	58.2	41.8	https://www.safc.com/news/club-news/2018/march/gender-pay-gap-reporting	Jo Graham (Deputy HR Manager)	250 to 499	1879 EVENTS MANAGEMENT LIMITED		2018-04-05T00:00:00Z	2018-03-29T15:32:33Z
1LIFE MANAGEMENT SOLUTIONS LIMITED	687	Ldh House St Ives Business Park, Parsons Green, St. Ives, Cambridgeshire, PE27 4AA	PE27 4AA	02566586	93110:93130:93290	15.1	2.8	77.6	71.2	5.8	4.2	42.6	57.4	45.2	54.8	46.8	53.2	35.5	64.5	http://www.1life.co.uk/gender-pay-gap	Mark Braithwaite (Managing Director)	500 to 999	1LIFE MANAGEMENT SOLUTIONS LIMITED		2018-04-05T00:00:00Z	2018-03-07T12:01:05Z
1ST HOME CARE LTD.	17484	Real Life Options, 35 East Port, Dunfermline, Fife, Scotland, KY12 7LG	KY12 7LG	SC272838	86900:88100	15						10	90	9	91	10	90	9	91	https://www.1sthomecare.co.uk	John McDonald (Executive Director)	250 to 499	1ST HOME CARE LTD.		2018-04-05T00:00:00Z	2018-04-04T12:28:10Z
1STOP HALAL LIMITED	689	Colmore Court, 9 Colmore Row, Birmingham, West Midlands, B3 2BJ	B3 2BJ	08929070	56290	11.9						75.3	24.7	52.3	47.7	58.1	41.9	69.8	30.2	nan	Stephen Elder (Finance Director)	250 to 499	SHAZAN FOODS LIMITED		2018-04-05T00:00:00Z	2018-03-22T08:08:33Z
2 AGRICULTURE LIMITED	14399	Fairview Mill, Ingliston, Newbridge, Midlothian, EH28 8NB	EH28 8NB	SC156515	1470:10910	13.4	8.5	62.9		89.7	73.3	89.1	10.9	95.3	4.7	98.5	1.5	93.8	6.2	http://www.2agriculture.com/	Gavin Berry (Managing Director)	250 to 499	2 AGRICULTURE LIMITED		2018-04-05T00:00:00Z	2018-03-22T10:46:20Z
2 SISTERS FOOD GROUP LIMITED	77	Trinity Park House Trinity Business Park, Fox Way, Wakefield, West Yorkshire, WF2 8EE	WF2 8EE	02826929	10120	15.3	6.9	55.5	1.6	5.6	5.1	44.9	55.1	67.6	32.4	66.2	33.8	73.7	26.3	https://www.2sfg.com/about-us/how-we-work/gender/	Nigel Perry (Group People & Change Director)	5000 to 19,999	2 SISTERS FOOD GROUP LIMITED		2018-04-05T00:00:00Z	2018-03-27T14:54:56Z


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
);