Back to Events

DTL — Down The Line

Down The Line at Spennymoor & District C.P.C

Spennymoor & District C.P.C

Sunday, 25 May 2025 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

83.7%

Field Average

94.0%

Highest Score

64.3%

Lowest Score

Top 3 Overall

🥈

Ian Douglas

276/300

92.00%

🥇

Dan Kitching

94/100

94.00%

🥉

Steven Price

273/300

91.00%

Event Difficulty

83.7% This Event

vs. Spennymoor & District C.P.C historical average (Down The Line)

↓ -2.4% harder than usual

Ground avg: 86.1%

Score Distribution

90–100%

4 25.0%

80–89%

8 50.0%

70–79%

2 12.5%

60–69%

2 12.5%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

25.0%

4 / 16

80%+

75.0%

12 / 16

70%+

87.5%

14 / 16

60%+

100.0%

16 / 16

50%+

100.0%

16 / 16

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	3	89.6%	92.0%	88.0%	Ian Douglas
A	4	87.5%	91.0%	82.3%	Steven Price
B	7	82.1%	94.0%	68.3%	Dan Kitching
C	2	73.0%	81.7%	64.3%	Ross Stonehouse

Class Composition

3 18.8%

4 25.0%

7 43.8%

2 12.5%

Largest class: B — 7 competitors (43.8%)

Class Winners

AA 3 entered

276/300 — 92.00%

Ian Douglas

2: Cory Doble — 88.67%

A 4 entered

273/300 — 91.00%

Steven Price

2: Stuart Kitchen — 90.67%

B 7 entered

94/100 — 94.00%

Dan Kitching

2: Dominic Grant — 89.33%

C 2 entered

245/300 — 81.67%

Ross Stonehouse

2: Stanley Auton — 64.33%

Full Results — 16 entries

B Dan Kitching

94/100

94.0%

AA Ian Douglas

276/300

92.0%

A Steven Price

273/300

91.0%

A Stuart Kitchen

272/300

90.7%

B Dominic Grant

268/300

89.3%

AA Cory Doble

266/300

88.7%

AA Stephen Petch

264/300

88.0%

B Nigel Macbean

261/300

87.0%

A Tony Common

258/300

86.0%

A Colin Prested

247/300

82.3%

C Ross Stonehouse

245/300

81.7%

B Glenn Jones

240/300

80.0%

B Andrew Jones

238/300

79.3%

B Peter Featherstone

231/300

77.0%

B Derek Blyth

205/300

68.3%

C Stanley Auton

193/300

64.3%

#	Name	Class	Score	Score %	Class Rank
1	Dan Kitching	B	94/100	94.00%	1
2	Ian Douglas	AA	276/300	92.00%	1
3	Steven Price	A	273/300	91.00%	1
4	Stuart Kitchen	A	272/300	90.67%	2
5	Dominic Grant	B	268/300	89.33%	2
6	Cory Doble	AA	266/300	88.67%	2
7	Stephen Petch	AA	264/300	88.00%	3
8	Nigel Macbean	B	261/300	87.00%	3
9	Tony Common	A	258/300	86.00%	3
10	Colin Prested	A	247/300	82.33%	4
11	Ross Stonehouse	C	245/300	81.67%	1
12	Glenn Jones	B	240/300	80.00%	4
13	Andrew Jones	B	238/300	79.33%	5
14	Peter Featherstone	B	231/300	77.00%	6
15	Derek Blyth	B	205/300	68.33%	7
16	Stanley Auton	C	193/300	64.33%	2

Other DTL Events at Spennymoor & District C.P.C

⚡ PERFORMANCE DEBUG

🗄️

Total DB Queries

⏱️

0.0ms

Total DB Time

⛓ Scrape / CPSA Log

            Drag header to move • Drag bottom-right to resize
        

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

DB 57% · Py 34% · Render 9%

11 queries · avg 1.4ms · max 3.1ms

Render Breakdown

DB Logic (Pre-Render) 0.0156s

Python Logic (Pre-Render) 0.0091s

Full Page Render 0.0025s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

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:09:18.322] 3.1ms

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:09:18.324] 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 [02:09:18.327] 1.8ms

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:09:18.329] 1.2ms

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:09:18.331] 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:09:18.332] 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 [02:09:18.334] 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 [02:09:18.336] 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…

#9 [02:09:18.338] 1.8ms

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:09:18.339] 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 [02:09:18.341] 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 Spennymoor & District C.P.C

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?