Back to Events

DTL — Down The Line

Down The Line at Bywell Shooting Ground

Bywell Shooting Ground

Sunday, 03 July 2022 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

91.3%

Field Average

97.0%

Highest Score

78.3%

Lowest Score

Top 3 Overall

🥇 =1

Allan Henry

David Whitehead

Tom Robinson

291/300

97.00%

Event Difficulty

91.3% This Event

vs. Bywell Shooting Ground historical average (Down The Line)

— About average difficulty

Ground avg: 91.1%

Score Distribution

90–100%

21 70.0%

80–89%

8 26.7%

70–79%

1 3.3%

60–69%

0 0.0%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

70.0%

21 / 30

80%+

96.7%

29 / 30

70%+

100.0%

30 / 30

60%+

100.0%

30 / 30

50%+

100.0%

30 / 30

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	8	95.3%	97.0%	92.3%	Allan Henry
A	9	93.6%	96.3%	89.0%	William Buchanan
B	9	88.5%	93.0%	81.0%	Nicholas Simpson
C	4	84.5%	90.3%	78.3%	Caroline Whitehead

Class Composition

8 26.7%

9 30.0%

4 13.3%

Largest class: A — 9 competitors (30.0%)

Class Winners

AA 8 entered

291/300 — 97.00%

Allan Henry(tied) David Whitehead(tied) Tom Robinson(tied)

4: Ian Mullarkey — 96.67%

A 9 entered

289/300 — 96.33%

William Buchanan

2: Andy Page — 96.00%

B 9 entered

279/300 — 93.00%

Nicholas Simpson

2: Neil Dickinson — 91.67%

C 4 entered

271/300 — 90.33%

Caroline Whitehead

2: Keith Jones — 86.67%

Full Results — 30 entries

AA Allan Henry

291/300

97.0%

AA David Whitehead

291/300

97.0%

AA Tom Robinson

291/300

97.0%

AA Ian Mullarkey

290/300

96.7%

A William Buchanan

289/300

96.3%

A Andy Page

288/300

96.0%

A Roger Brown

287/300

95.7%

A George Turnes

286/300

95.3%

AA Ian Douglas

285/300

95.0%

AA Tony Common

283/300

94.3%

A Grant Turner

282/300

94.0%

12=

A David Bell

280/300

93.3%

12=

A Peter Johnson

280/300

93.3%

14=

AA Charlotte Kitchen

279/300

93.0%

14=

B Nicholas Simpson

279/300

93.0%

AA Nicholas Harris

277/300

92.3%

B Neil Dickinson

275/300

91.7%

B Derek Ridley

272/300

90.7%

19=

B Brian Whitehead

271/300

90.3%

19=

C Caroline Whitehead

271/300

90.3%

B Eric Atkinson

270/300

90.0%

A Christopher Jones

268/300

89.3%

A Tony Gradwell

267/300

89.0%

B Christopher Dickinson

263/300

87.7%

B Ellie Whitehead

261/300

87.0%

C Keith Jones

260/300

86.7%

B Steven Pape

255/300

85.0%

C Derek Blyth

248/300

82.7%

B Jayne Fisher

243/300

81.0%

C Michael Ritson

235/300

78.3%

#	Name	Class	Score	Score %	Class Rank
1=	Allan Henry	AA	291/300	97.00%	1=
1=	David Whitehead	AA	291/300	97.00%	1=
1=	Tom Robinson	AA	291/300	97.00%	1=
4	Ian Mullarkey	AA	290/300	96.67%	4
5	William Buchanan	A	289/300	96.33%	1
6	Andy Page	A	288/300	96.00%	2
7	Roger Brown	A	287/300	95.67%	3
8	George Turnes	A	286/300	95.33%	4
9	Ian Douglas	AA	285/300	95.00%	5
10	Tony Common	AA	283/300	94.33%	6
11	Grant Turner	A	282/300	94.00%	5
12=	David Bell	A	280/300	93.33%	6=
12=	Peter Johnson	A	280/300	93.33%	6=
14=	Charlotte Kitchen	AA	279/300	93.00%	7
14=	Nicholas Simpson	B	279/300	93.00%	1
16	Nicholas Harris	AA	277/300	92.33%	8
17	Neil Dickinson	B	275/300	91.67%	2
18	Derek Ridley	B	272/300	90.67%	3
19=	Brian Whitehead	B	271/300	90.33%	4
19=	Caroline Whitehead	C	271/300	90.33%	1
21	Eric Atkinson	B	270/300	90.00%	5
22	Christopher Jones	A	268/300	89.33%	8
23	Tony Gradwell	A	267/300	89.00%	9
24	Christopher Dickinson	B	263/300	87.67%	6
25	Ellie Whitehead	B	261/300	87.00%	7
26	Keith Jones	C	260/300	86.67%	2
27	Steven Pape	B	255/300	85.00%	8
28	Derek Blyth	C	248/300	82.67%	3
29	Jayne Fisher	B	243/300	81.00%	9
30	Michael Ritson	C	235/300	78.33%	4

Other DTL Events at Bywell Shooting Ground

Analyzing Data...

Connecting to CPSA...

Initial Scores

History Pages

Classifications

Fixture Details

Analyzing Data...

Connecting to CPSA...

Initial Scores

History Pages

Classifications

Fixture Details

⚙ Performance Stats DRAG TO MOVE

0.089s ● FAST

DB 84% · Py 12% · Render 4%

11 queries · avg 6.8ms · max 62.3ms

Render Breakdown

DB Logic (Pre-Render) 0.0744s

Python Logic (Pre-Render) 0.0110s

Full Page Render 0.0032s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.064s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [22:07:08.755] 2.0ms

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 [22:07:08.757] 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 [22:07:08.821] 62.3ms

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 [22:07:08.824] 1.5ms

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 [22:07:08.826] 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 [22:07:08.828] 1.1ms

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 [22:07:08.830] 1.1ms

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 [22:07:08.831] 1.0ms

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 [22:07:08.833] 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 [22:07:08.834] 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 [22:07:08.835] 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

Down The Line at Bywell Shooting Ground

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?