Back to Events

ESP — English Sporting

English Sporting at Northampton Shooting Ground

Northampton Shooting Ground

Sunday, 15 December 2013 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

76.2%

Field Average

93.0%

Highest Score

46.0%

Lowest Score

Top 3 Overall

🥉 =3

Glen Moore

John Stanton

Malcolm Jenkins

0/0

90.00%

🥇 =1

Adrian Balham

AAA

Mark Goddard

AAA

0/0

93.00%

Event Difficulty

76.2% This Event

vs. Northampton Shooting Ground historical average (English Sporting)

↓ -1.1% harder than usual

Ground avg: 77.3%

Score Distribution

90–100%

5 9.4%

80–89%

16 30.2%

70–79%

21 39.6%

60–69%

6 11.3%

50–59%

4 7.5%

<50%

1 1.9%

Field Achievement

% of competitors reaching each score threshold

90%+

5 / 53

80%+

39.6%

21 / 53

70%+

79.2%

42 / 53

60%+

90.6%

48 / 53

50%+

98.1%

52 / 53

Class Breakdown

Class	Count	Average	High	Low	Winner
AAA	6	86.3%	93.0%	75.0%	Adrian Balham
AA	7	85.3%	90.0%	78.0%	Glen Moore
A	15	80.1%	90.0%	71.0%	John Stanton
B	16	71.5%	81.0%	57.0%	Mike Jennings
C	8	64.0%	77.0%	46.0%	Richard Wells
Other	1	65.0%	65.0%	65.0%	Nathan Cope

Class Composition

AAA

6 11.3%

7 13.2%

15 28.3%

16 30.2%

8 15.1%

Other

1 1.9%

Largest class: B — 16 competitors (30.2%)

Class Winners

AAA 6 entered

0/0 — 93.00%

Adrian Balham(tied) Mark Goddard(tied)

3: Christopher Broomfield — 87.00%

AA 7 entered

0/0 — 90.00%

Glen Moore

2: Frederick Kidd — 89.00%

A 15 entered

0/0 — 90.00%

John Stanton(tied) Malcolm Jenkins(tied)

3: Stewart Chester — 85.00%

B 16 entered

0/0 — 81.00%

Mike Jennings

2: Karl Taylor — 80.00%

C 8 entered

0/0 — 77.00%

Richard Wells

2: Leon Gill — 73.00%

Other 1 entered

0/0 — 65.00%

Nathan Cope

Full Results — 53 entries

AAA Adrian Balham

0/0

93.0%

AAA Mark Goddard

0/0

93.0%

AA Glen Moore

0/0

90.0%

A John Stanton

0/0

90.0%

A Malcolm Jenkins

0/0

90.0%

AA Frederick Kidd

0/0

89.0%

AAA Christopher Broomfield

0/0

87.0%

AA David Morgan

0/0

87.0%

AA Steven Smith

0/0

87.0%

10=

AAA David Kempley

0/0

85.0%

10=

AAA Jo Smith

0/0

85.0%

10=

A Stewart Chester

0/0

85.0%

10=

AA Taylor Hedgecock

0/0

85.0%

14=

A Gordon Webster

0/0

83.0%

14=

A Jason Marlow

0/0

83.0%

16=

A Alan London

0/0

81.0%

16=

A David Ferriman

0/0

81.0%

16=

AA Matthew Sheppard

0/0

81.0%

16=

B Mike Jennings

0/0

81.0%

20=

B Karl Taylor

0/0

80.0%

20=

A Stuart Earl

0/0

80.0%

22=

B Karl Burnage

0/0

79.0%

22=

B Michael Beatwell

0/0

79.0%

22=

A Michael Fryer

0/0

79.0%

25=

AA Ivan Spencer

0/0

78.0%

25=

B Malcolm Clare

0/0

78.0%

25=

A Richard Pettitt

0/0

78.0%

28=

A Jon Freeman

0/0

77.0%

28=

C Richard Wells

0/0

77.0%

28=

B Ricky Mcarthur

0/0

77.0%

A Robert Allen

0/0

76.0%

32=

AAA Julian Freeman

0/0

75.0%

32=

B Nick Evans

0/0

75.0%

34=

A Carl Hopkins

0/0

74.0%

34=

A Tim Abbott

0/0

74.0%

C Leon Gill

0/0

73.0%

37=

C John Woolacott

0/0

72.0%

37=

B Mr R Bravery

0/0

72.0%

39=

B Nicholas Grant

0/0

71.0%

39=

A Tony Leonard

0/0

71.0%

41=

B Glenn Thompson

0/0

70.0%

41=

C Neil Kirton

0/0

70.0%

B Charles Whatton

0/0

68.0%

B Simon Springthorpe

0/0

67.0%

Unknown Nathan Cope

0/0

65.0%

B Alan Corney

0/0

64.0%

47=

B Jon Hedgecock

0/0

63.0%

47=

B Pip Bayley

0/0

63.0%

49=

C Isabel Russell

0/0

59.0%

49=

C Pete Reynolds

0/0

59.0%

B Gavin Smith

0/0

57.0%

C George Whatton

0/0

56.0%

C Bruce Bulmer

0/0

46.0%

#	Name	Class	Score	Score %	Class Rank
1=	Adrian Balham	AAA	0/0	93.00%	1=
1=	Mark Goddard	AAA	0/0	93.00%	1=
3=	Glen Moore	AA	0/0	90.00%	1
3=	John Stanton	A	0/0	90.00%	1=
3=	Malcolm Jenkins	A	0/0	90.00%	1=
6	Frederick Kidd	AA	0/0	89.00%	2
7=	Christopher Broomfield	AAA	0/0	87.00%	3
7=	David Morgan	AA	0/0	87.00%	3=
7=	Steven Smith	AA	0/0	87.00%	3=
10=	David Kempley	AAA	0/0	85.00%	4=
10=	Jo Smith	AAA	0/0	85.00%	4=
10=	Stewart Chester	A	0/0	85.00%	3
10=	Taylor Hedgecock	AA	0/0	85.00%	5
14=	Gordon Webster	A	0/0	83.00%	4=
14=	Jason Marlow	A	0/0	83.00%	4=
16=	Alan London	A	0/0	81.00%	6=
16=	David Ferriman	A	0/0	81.00%	6=
16=	Matthew Sheppard	AA	0/0	81.00%	6
16=	Mike Jennings	B	0/0	81.00%	1
20=	Karl Taylor	B	0/0	80.00%	2
20=	Stuart Earl	A	0/0	80.00%	8
22=	Karl Burnage	B	0/0	79.00%	3=
22=	Michael Beatwell	B	0/0	79.00%	3=
22=	Michael Fryer	A	0/0	79.00%	9
25=	Ivan Spencer	AA	0/0	78.00%	7
25=	Malcolm Clare	B	0/0	78.00%	5
25=	Richard Pettitt	A	0/0	78.00%	10
28=	Jon Freeman	A	0/0	77.00%	11
28=	Richard Wells	C	0/0	77.00%	1
28=	Ricky Mcarthur	B	0/0	77.00%	6
31	Robert Allen	A	0/0	76.00%	12
32=	Julian Freeman	AAA	0/0	75.00%	6
32=	Nick Evans	B	0/0	75.00%	7
34=	Carl Hopkins	A	0/0	74.00%	13=
34=	Tim Abbott	A	0/0	74.00%	13=
36	Leon Gill	C	0/0	73.00%	2
37=	John Woolacott	C	0/0	72.00%	3
37=	Mr R Bravery	B	0/0	72.00%	8
39=	Nicholas Grant	B	0/0	71.00%	9
39=	Tony Leonard	A	0/0	71.00%	15
41=	Glenn Thompson	B	0/0	70.00%	10
41=	Neil Kirton	C	0/0	70.00%	4
43	Charles Whatton	B	0/0	68.00%	11
44	Simon Springthorpe	B	0/0	67.00%	12
45	Nathan Cope	Unknown	0/0	65.00%	1
46	Alan Corney	B	0/0	64.00%	13
47=	Jon Hedgecock	B	0/0	63.00%	14=
47=	Pip Bayley	B	0/0	63.00%	14=
49=	Isabel Russell	C	0/0	59.00%	5=
49=	Pete Reynolds	C	0/0	59.00%	5=
51	Gavin Smith	B	0/0	57.00%	16
52	George Whatton	C	0/0	56.00%	7
53	Bruce Bulmer	C	0/0	46.00%	8

Other ESP Events at Northampton Shooting Ground

⚙ Performance Stats DRAG TO MOVE

0.032s ● FAST

DB 51% · Py 32% · Render 17%

11 queries · avg 1.5ms · max 4.7ms

Render Breakdown

DB Logic (Pre-Render) 0.0162s

Python Logic (Pre-Render) 0.0103s

Full Page Render 0.0053s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.006s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [01:54:20.138] 1.8ms

shoot_event

SELECT shoot_event.id AS shoot_event_id, shoot_event.cpsa_fixture_id AS shoot_event_cpsa_fixture_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.discipline AS shoot_event_discipline, shoot_event.ground AS shoot_event_ground, shoot_event.url AS shoot_event_…

#2 [01:54:20.141] 1.6ms

shoot_score

SELECT shoot_score.id AS shoot_score_id, shoot_score.targets AS shoot_score_targets, shoot_score.hits AS shoot_score_hits, shoot_score.points AS shoot_score_points, shoot_score.percentage AS shoot_score_percentage, shoot_score.shooter_id AS shoot_score_shooter_id, shoot_score.event_id AS shoot_score…

#3 [01:54:20.148] 4.7ms

shoot_score

SELECT avg(shoot_score.percentage) AS avg_1 
FROM shoot_score JOIN shoot_event ON shoot_score.event_id = shoot_event.id 
WHERE shoot_event.ground = %(ground_1)s AND shoot_event.discipline = %(discipline_1)s AND shoot_event.is_scraped = true AND shoot_event.admin_hidden != true AND shoot_event.id != …

#4 [01:54:20.150] 1.3ms

shoot_event

SELECT shoot_event.id AS shoot_event_id, shoot_event.cpsa_fixture_id AS shoot_event_cpsa_fixture_id, shoot_event.name AS shoot_event_name, shoot_event.date AS shoot_event_date, shoot_event.discipline AS shoot_event_discipline, shoot_event.ground AS shoot_event_ground, shoot_event.url AS shoot_event_…

#5 [01:54:20.152] 1.1ms

event_review

SELECT avg(event_review.rating) AS avg_1, count(event_review.id) AS count_1 
FROM event_review 
WHERE event_review.event_id = %(event_id_1)s

#6 [01:54:20.153] 1.0ms

event_review

SELECT count(*) AS count_1 
FROM (SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.review…

#7 [01:54:20.155] 0.9ms

event_review

SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…

#8 [01:54:20.156] 0.9ms

event_review

SELECT event_review.id AS event_review_id, event_review.event_id AS event_review_event_id, event_review.rating AS event_review_rating, event_review.review_text AS event_review_review_text, event_review.reviewer_name AS event_review_reviewer_name, event_review.reviewer_hash AS event_review_reviewer_h…

#9 [01:54:20.157] 1.0ms

site_configuration

SELECT site_configuration.id AS site_configuration_id, site_configuration.key AS site_configuration_key, site_configuration.value AS site_configuration_value 
FROM site_configuration 
WHERE site_configuration.key LIKE %(key_1)s OR site_configuration.key LIKE %(key_2)s

#10 [01:54:20.159] 1.0ms

site_configuration

SELECT site_configuration.id AS site_configuration_id, site_configuration.key AS site_configuration_key, site_configuration.value AS site_configuration_value 
FROM site_configuration 
WHERE site_configuration.key IN (%(key_1_1)s, %(key_1_2)s, %(key_1_3)s, %(key_1_4)s)

#11 [01:54:20.160] 1.0ms

admin_menu_item

SELECT DISTINCT admin_menu_item.active_tab AS admin_menu_item_active_tab 
FROM admin_menu_item

LIVE REQUESTS (0) — click to expand

English Sporting at Northampton Shooting Ground

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?