Back to Events

DTL — Down The Line

Down The Line at Two Counties Gun Club

Two Counties Gun Club

Sunday, 06 July 2025 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

86.8%

Field Average

96.0%

Highest Score

66.0%

Lowest Score

Top 3 Overall

🥈 =2

Andrew Vanstone

Richard Chapple

283/300

94.33%

🥇

Robert Dietz

288/300

96.00%

Event Difficulty

86.8% This Event

vs. Two Counties Gun Club historical average (Down The Line)

↑ +0.6% easier than usual

Ground avg: 86.2%

Score Distribution

90–100%

9 39.1%

80–89%

11 47.8%

70–79%

2 8.7%

60–69%

1 4.3%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

39.1%

9 / 23

80%+

87.0%

20 / 23

70%+

95.7%

22 / 23

60%+

100.0%

23 / 23

50%+

100.0%

23 / 23

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	6	90.9%	96.0%	83.0%	Robert Dietz
A	9	89.7%	94.3%	85.0%	Andrew Vanstone
B	3	86.3%	89.3%	82.7%	Paul Garnsworthy
C	5	76.7%	85.3%	66.0%	Nigel Castle

Class Composition

6 26.1%

9 39.1%

3 13.0%

5 21.7%

Largest class: A — 9 competitors (39.1%)

Class Winners

AA 6 entered

288/300 — 96.00%

Robert Dietz

2: Richard Chapple — 94.33%

A 9 entered

283/300 — 94.33%

Andrew Vanstone

2: Keith Woolcock — 93.00%

B 3 entered

268/300 — 89.33%

Paul Garnsworthy

2: Roger Lewis — 87.00%

C 5 entered

256/300 — 85.33%

Nigel Castle

2: Andrew Brown — 80.33%

Full Results — 23 entries

AA Robert Dietz

288/300

96.0%

A Andrew Vanstone

283/300

94.3%

AA Richard Chapple

283/300

94.3%

A Keith Woolcock

279/300

93.0%

AA Nicholas Shadrick

279/300

93.0%

A Colin Chidley

276/300

92.0%

AA Paul Westaway

273/300

91.0%

A Malcolm Brown

272/300

90.7%

A Andrew Hill

271/300

90.3%

B Paul Garnsworthy

268/300

89.3%

11=

AA Chris Smyth

264/300

88.0%

11=

A Paul Gorrett

264/300

88.0%

11=

A Stuart Taylor

264/300

88.0%

B Roger Lewis

261/300

87.0%

A Steven Marshall

259/300

86.3%

C Nigel Castle

256/300

85.3%

A Michael Webber

255/300

85.0%

AA Gary Burton

249/300

83.0%

B Alan Dungey

248/300

82.7%

C Andrew Brown

241/300

80.3%

C William Mitchell

239/300

79.7%

C Ian Lobb

217/300

72.3%

C Philip Webb

198/300

66.0%

#	Name	Class	Score	Score %	Class Rank
1	Robert Dietz	AA	288/300	96.00%	1
2=	Andrew Vanstone	A	283/300	94.33%	1
2=	Richard Chapple	AA	283/300	94.33%	2
4=	Keith Woolcock	A	279/300	93.00%	2
4=	Nicholas Shadrick	AA	279/300	93.00%	3
6	Colin Chidley	A	276/300	92.00%	3
7	Paul Westaway	AA	273/300	91.00%	4
8	Malcolm Brown	A	272/300	90.67%	4
9	Andrew Hill	A	271/300	90.33%	5
10	Paul Garnsworthy	B	268/300	89.33%	1
11=	Chris Smyth	AA	264/300	88.00%	5
11=	Paul Gorrett	A	264/300	88.00%	6=
11=	Stuart Taylor	A	264/300	88.00%	6=
14	Roger Lewis	B	261/300	87.00%	2
15	Steven Marshall	A	259/300	86.33%	8
16	Nigel Castle	C	256/300	85.33%	1
17	Michael Webber	A	255/300	85.00%	9
18	Gary Burton	AA	249/300	83.00%	6
19	Alan Dungey	B	248/300	82.67%	3
20	Andrew Brown	C	241/300	80.33%	2
21	William Mitchell	C	239/300	79.67%	3
22	Ian Lobb	C	217/300	72.33%	4
23	Philip Webb	C	198/300	66.00%	5

Other DTL Events at Two Counties Gun Club

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.034s ● FAST

DB 46% · Py 41% · Render 13%

11 queries · avg 1.4ms · max 2.3ms

Render Breakdown

DB Logic (Pre-Render) 0.0157s

Python Logic (Pre-Render) 0.0139s

Full Page Render 0.0043s

QUERY TABLES ▾

⚠ event_review 4× 0.005s

shoot_event 2× 0.004s

shoot_score 2× 0.003s

site_configuration 2× 0.003s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [02:10:13.363] 2.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_…

#2 [02:10:13.366] 1.4ms

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 [02:10:13.369] 1.4ms

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 [02:10:13.372] 1.4ms

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 [02:10:13.374] 1.0ms

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 [02:10:13.376] 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 [02:10:13.377] 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…

#8 [02:10:13.380] 2.2ms

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 [02:10:13.383] 1.5ms

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 [02:10:13.385] 1.2ms

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 [02:10:13.387] 1.2ms

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 Two Counties Gun Club

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?