Ref Watch Ref Watch: Referee League Table

SteMerritt · 28 Oct 2021

Being a database geek, I've started to collate the Ref Watch information. I have done this season and last so far, I'll add the 2019/20 season in when I get the time. To kick things off, here is the Referee League Table (up to the Shrewsbury match).

Referee League Table

Ref Name	Games	High	Low	Ave
Andy Haines	1	7.54	7.54	7.54
Alan Young	1	7.31	7.31	7.31
Peter Wright	2	8.10	5.48	7.25
Ben Toner	2	7.40	6.40	7.16
Paul Townsend	1	7.16	7.16	7.16
Ross Joyce	2	7.60	5.57	7.11
Craig Breakspear	2	7.00	6.62	6.75
Will Finnie	2	7.26	5.53	6.73
Keith Stroud	1	6.70	6.70	6.70
Kevin Johnson	1	6.65	6.65	6.65
Samuel Barrott	2	7.07	5.83	6.64
Seb Stockbridge	1	6.44	6.44	6.44
Sam Purkiss	2	6.73	6.15	6.42
David Rock	3	7.18	4.97	6.19
Ollie Yates	1	6.13	6.13	6.13
Anthony Backhouse	1	5.96	5.96	5.96
Darren Drysdale	3	6.78	5.39	5.91
Thomas Bramall	3	6.60	4.00	5.84
Scott Oldham	1	5.71	5.71	5.71
Tom Nield	2	5.86	4.88	5.59
Robert Madley	2	5.74	5.13	5.50
Paul Howard	2	6.69	4.67	5.38
Neil Hair	1	5.30	5.30	5.30
Martin Coy	1	5.25	5.25	5.25
Craig Hicks	4	7.04	2.66	5.22
Graham Sailsbury	1	5.14	5.14	5.14
Brett Huxtable	4	7.33	2.97	5.09
Robert Lewis	3	5.77	4.47	5.06
Andy Woolmer	1	4.95	4.95	4.95
Carl Boyeson	2	4.97	4.86	4.95
Andy Davies	2	6.29	3.24	4.92
Lee Swabey	2	5.10	4.30	4.90
Chris Pollard	1	4.71	4.71	4.71
Tim Robinson	1	3.91	3.91	3.91
Declan Bourne	1	3.90	3.90	3.90
James Bell	2	4.44	3.44	3.82
Benjamin Speedie	1	3.68	3.68	3.68
Sam Allison	1	3.29	3.29	3.29
Trevor Kettle	2	7.43	1.14	3.24
Marc Edwards	1	3.06	3.06	3.06
James Oldham	1	2.74	2.74	2.74
Chris Sarginson	1	2.65	2.65	2.65

SteMerritt · 28 Oct 2021

Referee Performance by Opponents

Opponents	Games	High	Low	Ave
Sheffield Wednesday	1	7.54	7.54	7.54
Chelsea U21	1	7.43	7.43	7.43
Burton Albion	3	8.10	6.44	7.31
Rochdale	2	7.60	6.25	7.12
Tranmere Rovers	1	7.04	7.04	7.04
Cheltenham Town	1	6.69	6.69	6.69
Fleetwood Town	2	7.07	5.31	6.61
Stevenage	1	6.40	6.40	6.40
Bristol Rovers	2	7.18	5.10	6.26
AFC Wimbledon	5	6.78	4.30	6.22
Shrewsbury Town	3	6.15	5.83	6.05
Crewe Alexandra	3	7.16	5.13	6.01
Lincoln City	3	7.26	3.24	5.92
Sunderland	2	6.13	5.45	5.91
Blackpool	4	6.70	5.25	5.84
Swindon Town	2	6.62	4.97	5.83
Wigan Athletic	2	6.30	4.67	5.72
Charlton Athletic	3	5.86	5.04	5.56
Peterborough United	3	7.31	3.68	5.55
Hull City	2	5.96	4.95	5.36
Doncaster Rovers	2	7.40	3.44	5.32
Bolton Wanderers	1	5.30	5.30	5.30
Cambridge United	3	7.00	3.29	5.09
Queens Park Rangers	1	4.88	4.88	4.88
Gillingham	3	5.39	4.00	4.86
Accrington Stanley	3	5.77	1.14	4.60
Plymouth Argyle	3	7.33	2.97	4.50
Portsmouth	2	5.14	3.91	4.47
Northampton Town	2	4.71	3.90	4.20
MK Dons	2	6.65	2.74	3.68
Ipswich Town	1	3.06	3.06	3.06
Forest Green Rovers	1	2.66	2.66	2.66
Wycombe Wanderers	1	2.65	2.65	2.65

SteMerritt · 28 Oct 2021

Best Performances

Ref Name	Match Date	Competition	Match	R	Average
Peter Wright	02/01/2021	League	Burton Albion (A)	W	8.10
Ross Joyce	26/01/2021	League	Rochdale (A)	W	7.60
Andy Haines	02/10/2021	League	Sheffield Wednesday (A)	W	7.54
Trevor Kettle	08/09/2020	EFL Trophy	Chelsea U21 (H)	W	7.43
Ben Toner	16/03/2021	League	Doncaster Rovers (H)	W	7.40
Brett Huxtable	24/04/2021	League	Plymouth Argyle (H)	W	7.33
Alan Young	02/03/2021	League	Peterborough United (H)	D	7.31
Will Finnie	28/08/2021	League	Lincoln City (H)	W	7.26
David Rock	23/01/2021	League	Bristol Rovers (H)	W	7.18
Paul Townsend	10/04/2021	League	Crewe Alexandra (A)	W	7.16

SteMerritt · 28 Oct 2021

Worst Performances

Ref Name	Match Date	Competition	Match	R	Average
Trevor Kettle	05/04/2021	League	Accrington Stanley (H)	L	1.14
Chris Sarginson	11/09/2021	League	Wycombe Wanderers (H)	D	2.65
Craig Hicks	08/12/2020	EFL Trophy	Forest Green Rovers (H)	D	2.66
James Oldham	27/02/2021	League	MK Dons (A)	D	2.74
Brett Huxtable	29/12/2020	League	Plymouth Argyle (A)	W	2.97
Marc Edwards	20/02/2021	League	Ipswich Town (A)	D	3.06
Andy Davies	12/09/2020	League	Lincoln City (A)	L	3.24
Sam Allison	31/08/2021	EFL Trophy	Cambridge United (A)	L	3.29
James Bell	06/02/2021	League	Doncaster Rovers (A)	L	3.44
Benjamin Speedie	07/11/2020	FA Cup	Peterborough United (H)	L	3.68

Big Ronaldo · 28 Oct 2021

Fourth best performance
And worst performance goes to….

Trevor Kettle!!

QR · 28 Oct 2021

SteMerritt said:
Being a database geek, I've started to collate the Ref Watch information. I have done this season and last so far, I'll add the 2019/20 season in when I get the time. To kick things off, here is the Referee League Table (up to the Shrewsbury match).

Referee League Table

Ref Name Games High Low Ave
Andy Haines
1
7.54 7.54 7.54
Alan Young
1
7.31 7.31 7.31
Peter Wright
2
8.10 5.48 7.25
Ben Toner
2
7.40 6.40 7.16
Paul Townsend
1
7.16 7.16 7.16
Ross Joyce
2
7.60 5.57 7.11
Craig Breakspear
2
7.00 6.62 6.75
Will Finnie
2
7.26 5.53 6.73
Keith Stroud
1
6.70 6.70 6.70
Kevin Johnson
1
6.65 6.65 6.65
Samuel Barrott
2
7.07 5.83 6.64
Seb Stockbridge
1
6.44 6.44 6.44
Sam Purkiss
2
6.73 6.15 6.42
David Rock
3
7.18 4.97 6.19
Ollie Yates
1
6.13 6.13 6.13
Anthony Backhouse
1
5.96 5.96 5.96
Darren Drysdale
3
6.78 5.39 5.91
Thomas Bramall
3
6.60 4.00 5.84
Scott Oldham
1
5.71 5.71 5.71
Tom Nield
2
5.86 4.88 5.59
Robert Madley
2
5.74 5.13 5.50
Paul Howard
2
6.69 4.67 5.38
Neil Hair
1
5.30 5.30 5.30
Martin Coy
1
5.25 5.25 5.25
Craig Hicks
4
7.04 2.66 5.22
Graham Sailsbury
1
5.14 5.14 5.14
Brett Huxtable
4
7.33 2.97 5.09
Robert Lewis
3
5.77 4.47 5.06
Andy Woolmer
1
4.95 4.95 4.95
Carl Boyeson
2
4.97 4.86 4.95
Andy Davies
2
6.29 3.24 4.92
Lee Swabey
2
5.10 4.30 4.90
Chris Pollard
1
4.71 4.71 4.71
Tim Robinson
1
3.91 3.91 3.91
Declan Bourne
1
3.90 3.90 3.90
James Bell
2
4.44 3.44 3.82
Benjamin Speedie
1
3.68 3.68 3.68
Sam Allison
1
3.29 3.29 3.29
Trevor Kettle
2
7.43 1.14 3.24
Marc Edwards
1
3.06 3.06 3.06
James Oldham
1
2.74 2.74 2.74
Chris Sarginson
1
2.65 2.65 2.65

Can you colour code the high and low scores to show if we won (green), drew (Amber) or lost (red). I would suspect a strong correlation.

SteMerritt · 28 Oct 2021

QR said:
Can you colour code the high and low scores to show if we won (green), drew (Amber) or lost (red). I would suspect a strong correlation.

I do have a query showing the average by result, I'll add it on when I next power up the PC. I will add the result into the 2 grids as well.

QR · 28 Oct 2021

SteMerritt said:
I do have a query showing the average by result, I'll add it on when I next power up the PC. I will add the result into the 2 grids as well.

I knew you wouldn't be able to resist.

Essexyellows · 28 Oct 2021

Needs a bit of work to make it more engaging, throw a few pivot tables and pie charts in.

Nobody will understand them but they look pretty.

Berliner · 28 Oct 2021

Big Ronaldo said:
Fourth best performance
And worst performance goes to….

Trevor Kettle!!

That's Trevor "The Randomiser" Kettle for you...

IsleofWightYellow · 28 Oct 2021

This is absolutely brilliant, love a stat.

However I do have to say that the marking of referees on here is questionable at best, you get some wildly differing scores!

Marked Ox · 28 Oct 2021

@SteMerritt you have too much time on your hands.

Notaswindonfan · 28 Oct 2021

Will have to be more careful with my scoring have been far too generous.

oufc1991 · 28 Oct 2021

I’m surprised we haven’t had the pleasure of Trevor kettle yet this season I’ve been looking forward to KR giving him some stick lol

SteMerritt · 29 Oct 2021

QR said:
I knew you wouldn't be able to resist.

Nope

I've added the result into the Best and Worst performances grid. Adding the information into the League Table query will take a touch more work, but now you've put the idea into my head it'll get done.

SteMerritt · 29 Oct 2021

Essexyellows said:
Needs a bit of work to make it more engaging, throw a few pivot tables and pie charts in.

Nobody will understand them but they look pretty.

Pivot Tables you say?...

Referee Performance vs Competition vs Venue

Competition	All	Away	Home
EFL Trophy	5.62	3.29	5.93
FA Cup	3.68		3.68
League	5.46	5.10	5.74
League Cup	5.11	5.44	4.30
Play-Offs	6.06	6.70	5.74

Referee Performance vs Result vs Venue

Result	All	Away	Home
Drew	4.44	4.04	4.78
Lost	4.98	4.87	5.08
Won	6.20	6.00	6.31

Essexyellows · 29 Oct 2021

SteMerritt said:
Pivot Tables you say?...

Referee Performance vs Competition vs Venue

Competition All Away Home
EFL Trophy 5.62 3.29 5.93
FA Cup 3.68 3.68
League 5.46 5.10 5.74
League Cup 5.11 5.44 4.30
Play-Offs 6.06 6.70 5.74

Referee Performance vs Result vs Venue

Result All Away Home
Drew 4.44 4.04 4.78
Lost 4.98 4.87 5.08
Won 6.20 6.00 6.31

Amazing - better ratings when we win.

SteMerritt · 29 Oct 2021

Essexyellows said:
Amazing - better ratings when we win.

Shocking isn't it... makes me wonder why I bothered in the first place

Wallop · 29 Oct 2021

But better ratings when we lose than when we draw.

Ref Watch Ref Watch: Referee League Table

SteMerritt

Moderator & English Language Pedant

SteMerritt

Moderator & English Language Pedant

SteMerritt

Moderator & English Language Pedant

SteMerritt

Moderator & English Language Pedant

Big Ronaldo

Well-known member

QR

Well-known member

SteMerritt

Moderator & English Language Pedant

QR

Well-known member

Essexyellows

Well-known member

Berliner

Well-known member

IsleofWightYellow

Well-known member

Marked Ox

God like member

Notaswindonfan

Well-known member

oufc1991

Well-known member

SteMerritt

Moderator & English Language Pedant

SteMerritt

Moderator & English Language Pedant

Essexyellows

Well-known member

SteMerritt

Moderator & English Language Pedant

Wallop

Well-known member