Skip to content

Instantly share code, notes, and snippets.

@jonnylaw
Last active October 9, 2017 13:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jonnylaw/7aabbabffc6eecef4c762a0674a68a7c to your computer and use it in GitHub Desktop.
Save jonnylaw/7aabbabffc6eecef4c762a0674a68a7c to your computer and use it in GitHub Desktop.
What if the harrier league started from scratch

Harrier League Cross Country From Scratch The Harrier League is a cross country running league with seven fixtures across the North East of England in the 2017/18 season across the winter months from September ’17 until March ‘18.

The harrier league is unique to other cross country fixtures because the senior runners are divided up into slow, medium and fast packs. In the senior men’s race, the slow runners start first followed 2 minutes 30 seconds later by the medium pack runners, then a further 2 minutes 30 seconds by the fast pack runners.

In order to progress to the fast pack, runners must first run in the slow pack and finish in the top 10% of finishers, this entitles them to run from the medium pack. If they then finish in the top 10% from the medium pack, then they can run from the fast pack.

Teams are split into three divisions and final team positions are calculated within each division by ordering the first six runners (four in the senior women) by race time. This is the total time elapsed from when the slow pack starts to when the runner crosses the finish line. Let’s answer one interesting question, what would the results be from the past weekends fixture without the handicaps, ie. if everyone started from scratch.

The code for this analysis was written using R and the tidyverse. The full code can be found on Github. Let me know if you’d like me to answer other questions about the harrier league.

Senior Womens

We will look at the results from yesterdays race at Druridge Bay. In the senior womens race there are four counters, any team with less than four runners will be removed from the final results. Now, we can calculate the position of each runner within each division by the actual running time of each runner.

division club total_points total_counters counters position
1 Tyne Bridge Harriers 43 4 Alison Dargie (3), Louise Rodgers (5), Heather Dorman (18), Mairi Clancy (17) 1
1 North Shields Poly 63 4 Rachel Mcintyre (15), Joanna Fletcher (26), Alison Smith (10), Katherine Davis (12) 2
1 Tynedale Harriers 65 4 Elizabeth Earle (24), Steph Scott (28), Kirstie Anderson (6), Jo Sutton (7) 3
1 Gateshead Harriers 66 4 Jemma Louise Bell (13), Sarah Holmes (36), Sarah Hill (8), Elizabeth Raven (9) 4
1 Morpeth Harriers & AC 71 4 Emma Holt (1), Jane Hodgson (2), Alison Brown (11), Sue Smith (57) 5
1 South Shields Harriers 89 4 Linda Bone (28), Rachel Breheny (16), Fran Dembele (26), Claire O’Callaghan (19) 6
1 Alnwick Harriers 93 4 Johanna Gascoigne-Owens (4), Lisa Baston (33), Alice Tetley-Paul (34), Karen Kelly (22) 7
1 Gosforth Harriers 111 4 Louise Watson (20), Angela Richardson (31), Sylvie Moffat (21), Susan Driscoll (39) 8
1 Durham City Harriers 117 4 Kelly Bentley (25), Gemma Soulsby (14), Rachel Terry (40), Rachel Bentley (38) 9
1 Elvet Striders 186 4 Susan Davis (41), Rachelle Mason (44), Sarah Davies (50), Rachael Bullock (51) 10
division club total_points total_counters counters position
2 Heaton Harriers 31 4 Nina Cameron (8), Louise Johnson (10), Ellen Roberts (2), Janine Routledge (11) 1
2 Jesmond Joggers 49 4 Emma Glover (4), Laura Cheetham (5), Jo King (18), Kate Black (22) 2
2 Crook AC 53 4 Kirstin Farquhar (6), Helene Pratt (32), Elizabeth Wood (12), Joanne Raine (3) 3
2 Sunderland Harriers 88 4 Linda Mudford (24), Lauren Flaxen (26), Vikki Cotton (9), Peter Richardson (29) 4
2 Elswick Harriers 89 4 Elspeth Aspinall (7), Catherine Lee (13), Graham Leslie (33), Jill Bennett (36) 5
2 Claremont RR 94 4 Mandy Herworth (20), Sarah Kerr (25), Nicki O’Brien (14), Jane Evans (35) 6
2 Low Fell RC 94 4 Emma Sproat (16), Claire Diamond-Howe (17), Cheryl Parkin (19), William Doidge (42) 6
2 Birtley AC 121 4 Chloe Price (1), Clare Atkinson (31), Shannel Curtis (37), Stephanie Young (52) 8
2 Blackhill 152 4 Louise Priestley (30), Caroline Slane (34), Kerry Anderson (40), Juliet Robinson (48) 9
2 Wallsend Harriers 154 4 Donna Thompson (15), Emily James (28), Julie Williams (47), Julie Collinson (64) 10
division club total_points total_counters counters position
3 Saltwell Harriers 46 4 Chritie Waddington (4), Gemma Bradley (3), Sarah Garrett (12), Nicola Whitman (27) 1
3 Sunderland Strollers 70 4 Wendy Chapman (2), Clare Baharie (14), Hasina Khanom (16), Michelle Houghton (38) 2
3 Ponteland Runners 72 4 Elaine Stroud (15), Fiona Nicholson (18), Alison Guadagno (19), Laura Choake (20) 3
3 Blyth RC 76 4 Claire Calverley (8), Holly Johnson (21), Lisa Scorer (23), Sandra Watson (24) 4
3 Blaydon Harriers 88 4 Claire Collinson (10), Liane Brown (25), Joanne Ramshaw (26), Izzi Jackson (27) 5
3 Derwent Valley Running Club 93 4 Lindsay Smith (5), Dawn Cooper (13), Eleanor Shotton (22), Bernadette Salmon (53) 6
3 Jarrow & Hebburn AC 94 4 Rachel Jameson (9), Elaine Leslie (1), Heather Robinson (7), Julia Barnshaw (77) 7
3 Derwentside AC 171 4 Emma Armstrong (31), Fiona Gilchrist (40), Claire Wilkie (44), Janet Brooks (56) 8
3 Washington Running Club 174 4 Katherine Conway (30), Sarah Turnbull (42), Radina Tahtadzhieva (47), Nicole Clarke (55) 9
3 Ashington Hirst 192 4 Lee Elder (34), Kate Mclean (41), Laura Jobson (58), Lindsay Freeman (59) 10
3 Derwent Valley Trail Runners 226 4 Dawn Metcalfe (17), Susie Thompson (37), Vicky Hopper (72), Kathleen Boyle (100) 11
3 Newcastle Frontrunners 309 4 Heather Witham (52), Gillian Dodds (70), Grace Lewis (89), Jo Morrissey (98) 12
3 Stocksfield Striders 353 4 Rachael Maitland (49), Holly Kelleher (71), Louise Newton (116), Jane Buckingham (117) 13
Senior Men ========== In the senior mens race there are six counters, any team with less than four runners will be removed from the final results. Now, we can calculate the position of each runner within each division by the actual running time of each runner.
division club total_points total_counters counters position
1 Tyne Bridge Harriers 89 6 Paul O’Mara (9), James Dunce (2), Tom Charlton (4), Alasdair Blain (26), Tony Carter (21), Paul Turnbull (27) 1
1 Durham City Harriers 111 6 Alexander Cook (22), Jonathan Wilkinson (8), Francisco Martinez-Sevilla (16), Michael Wade (17), David Cross (36), Robin Linten (12) 2
1 Morpeth Harriers & AC 129 6 Robert Balmbra (1), Thomas Innes (23), Tony Lewis (37), Richard Castledine (39), Alistair Douglass (14), Mark Snowball (15) 3
1 Sunderland Harriers 149 6 Sean Mackie (31), Paul Blakey (10), Andrew Powell (3), Robert Walker (20), Steven Duffy (33), Paul Merrison (52) 4
1 Gateshead Harriers 159 6 Matthew Linsley (43), Ross Christie (13), Conrad Franks (7), Steven Asquith (31), Kevin Connolly (18), Peter Grimoldby (47) 5
1 Heaton Harriers 188 6 Matt Hetherington (19), Sam Thorpe (30), James Meader (24), James Mckenzie (11), Mark Oliver (50), Ian Norman (54) 6
1 Elvet Striders 255 6 Stephen Jackson (5), Jack Lee (57), Jason Harding (34), Michael Mason (25), Phil Ray (66), Scott Watson (68) 7
1 Birtley AC 348 6 Adrian Bailes (6), Peter Farnie (40), Karl Oakes (79), Peter Gill (44), Mark Hornsby (87), Trevor Crewe (92) 8
1 North Shields Poly 374 6 Paul West (29), Michael Parkinson (27), Michael Gibson (78), Paul Davies (49), William Powis (95), Richard Hanley (96) 9
1 Wallsend Harriers 445 6 Simon Lyon (35), David Diston (76), Jack Armstrong (57), Brian Hetherington (59), Keith Odonnell (108), Paul James (110) 10
division club total_points total_counters counters position
2 Jarrow & Hebburn AC 90 6 Andy Burn (1), Jonny Evans (3), Kevin Emmett (20), Jack Brown (25), Jonathan Gilroy (14), Conal Tuffnell (27) 1
2 Alnwick Harriers 122 6 Dan Turnbull (5), Adam Fletcher (22), Steve Carragher (10), Ian Simon (34), Dominic Harris (21), Philip Hemsley (30) 2
2 Gosforth Harriers 132 6 Tom Coates (18), Maurice Bourke (31), Andrew Heppell (15), Jonny Stephenson (24), James McCreesh (13), Neil Ramsay (31) 3
2 Elswick Harriers 176 6 Iain Hardy (40), Lee Bennett (7), John Bell (43), Mark Turnbull (19), Kevin Richardson (11), David Armstrong (56) 4
2 Saltwell Harriers 181 6 Graham Stephenson (28), Iain Armstrong (12), Fred Smith (44), Jim Thompson (16), Matt O’Brien (16), Peter Mullarkey (65) 5
2 South Shields Harriers 214 6 Luke Adams (2), Jeff Mcgurty (40), Paul Owen (45), Neil Turner (46), Stephen Mackin (53), Mark Wilson (28) 6
2 Blyth RC 219 6 Graeme Stewart (36), Tony Horsley (38), Gary Jones (8), Graham Wood (51), Calum Storey (22), Paul Whalley (64) 7
2 Sunderland Strollers 253 6 Callum Thom (9), Luke Mccormack (49), Ritchie Gerry (26), Paul Dunlop (66), Michael Dixon (68), Ken Maynard (35) 8
2 Sedgefield Harriers 311 6 James Oldfield (4), David Bentley (42), Mark Raine (48), David Walker (56), Mil Walton (77), Chris Lines (84) 9
2 Blackhill 319 6 Jordan Bell (6), Ian Young (55), Gary Dixon (60), Jonathan Richards (68), Daryl Priestley (79), Michael Mcdonald (51) 10
2 Crook AC 847 6 Paul Brennan (90), Geoff Hewitson (98), Mark Nichol (148), Gerry Hehir (168), Lloyd Ashby (169), Paul Wragg (174) 11
division club total_points total_counters counters position
3 Low Fell RC 77 6 Gavin Thompson (13), David France (3), Ian Marriott (23), Fai Ng (25), Paul Harrison (9), Stephen Magrath (4) 1
3 Houghton AC 80 6 Juma Tatah (14), Stephen Johnson (21), Lee Dover (2), Adam Middleton (16), Tom Whelan (17), Thomas Grey (10) 2
3 Blaydon Harriers 140 6 David Garner (11), Isaac Dunn (5), James Ramshaw (30), James Dias (7), Jamie Boswell (41), Liam Friel (46) 3
3 Derwentside AC 201 6 Graham Marshall (18), Mark Davinson (29), David Reay (34), John S Donneky (8), Steven Dickson (27), Chris Lowes (85) 4
3 Jesmond Joggers 267 6 Josh Freed (19), Angus Miller (33), Stuart Harper (43), Gregory Stamp (55), Tim Mcgahey (58), John Farr (59) 5
3 Ponteland Runners 268 6 John Mcgargill (47), James Leiper (15), Chris Kenyon (56), Tim Allsop (20), Matthew Levison (62), Matty Bell (68) 6
3 Ashington Hirst 271 6 Kurt Heron (1), Paul White (6), Iain Singer (52), Martin Thompson (59), Philip Battista (74), Nic Crofts (79) 7
3 Washington Running Club 302 6 Peter Setterfield (24), Tim Jones (28), Craig Smith (50), Nick Butchart (51), Carl Smith (66), David Bannan (83) 8
3 Claremont RR 391 6 Roberto Marzo (22), Anthony Liddle (39), Danny Edwards (70), Duncan Scott (72), David Devennie (93), Dean O’Brien (95) 9
3 Derwent Valley Trail Runners 445 6 Stephen Heseltine (38), Ian Hutchinson (49), Andrew Nesbit (76), Jordan Babak (91), Tony Curry (93), Dan English (98) 10
3 Derwent Valley Running Club 553 6 Mark Marchant (35), Simon Woolley (79), Peter Storey (100), Nick Belcher (105), John Kirby (113), Steve Wade (121) 11
3 Newcastle Frontrunners 587 6 Russell Dickinson Deane (32), Phillip Hall (67), Mark Sutherland (75), Curtis Allen (123), Ken Hodson (144), Allen Dickinson Deane (146) 12
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment