Back to Events

DTL — Down The Line

Down The Line at North Of England C.T.C

North Of England C.T.C

Saturday, 20 January 2024 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

90.5%

Field Average

99.0%

Highest Score

63.3%

Lowest Score

Top 3 Overall

🥈

David Garrett

293/300

97.67%

🥇

Martin Jeminson

99/100

99.00%

🥉

Mark Child

287/300

95.67%

Event Difficulty

90.5% This Event

vs. North Of England C.T.C historical average (Down The Line)

↓ -3.1% harder than usual

Ground avg: 93.6%

Score Distribution

90–100%

16 76.2%

80–89%

3 14.3%

70–79%

1 4.8%

60–69%

1 4.8%

50–59%

0 0.0%

<50%

0 0.0%

Field Achievement

% of competitors reaching each score threshold

90%+

76.2%

16 / 21

80%+

90.5%

19 / 21

70%+

95.2%

20 / 21

60%+

100.0%

21 / 21

50%+

100.0%

21 / 21

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	7	93.9%	99.0%	90.0%	Martin Jeminson
A	7	93.4%	95.7%	91.0%	Mark Child
B	4	90.7%	95.3%	87.7%	John Bailey
C	3	75.9%	84.7%	63.3%	Cedric Leeming

Class Composition

7 33.3%

4 19.0%

3 14.3%

Largest class: AA — 7 competitors (33.3%)

Class Winners

AA 7 entered

99/100 — 99.00%

Martin Jeminson

2: David Garrett — 97.67%

A 7 entered

287/300 — 95.67%

Mark Child

2: Keith Blaney — 95.00%

B 4 entered

286/300 — 95.33%

John Bailey

2: Richard Blacker — 91.33%

C 3 entered

254/300 — 84.67%

Cedric Leeming

2: Sarah Thorpe — 79.67%

Full Results — 21 entries

AA Martin Jeminson

99/100

99.0%

AA David Garrett

293/300

97.7%

A Mark Child

287/300

95.7%

B John Bailey

286/300

95.3%

A Keith Blaney

285/300

95.0%

A Garry Sayles

283/300

94.3%

AA Tom Robinson

282/300

94.0%

A John Randle

280/300

93.3%

AA Mark Shaw

280/300

93.3%

A Mike Hartley

279/300

93.0%

AA Richard Atkins

278/300

92.7%

12=

A John Adams

274/300

91.3%

12=

B Richard Blacker

274/300

91.3%

A David Taberner

273/300

91.0%

AA Stuart Kitchen

271/300

90.3%

AA Christopher Jones

270/300

90.0%

B Stephen Clark

265/300

88.3%

B Paul Worthington

263/300

87.7%

C Cedric Leeming

254/300

84.7%

C Sarah Thorpe

239/300

79.7%

C Paul Lambert

190/300

63.3%

#	Name	Class	Score	Score %	Class Rank
1	Martin Jeminson	AA	99/100	99.00%	1
2	David Garrett	AA	293/300	97.67%	2
3	Mark Child	A	287/300	95.67%	1
4	John Bailey	B	286/300	95.33%	1
5	Keith Blaney	A	285/300	95.00%	2
6	Garry Sayles	A	283/300	94.33%	3
7	Tom Robinson	AA	282/300	94.00%	3
8=	John Randle	A	280/300	93.33%	4
8=	Mark Shaw	AA	280/300	93.33%	4
10	Mike Hartley	A	279/300	93.00%	5
11	Richard Atkins	AA	278/300	92.67%	5
12=	John Adams	A	274/300	91.33%	6
12=	Richard Blacker	B	274/300	91.33%	2
14	David Taberner	A	273/300	91.00%	7
15	Stuart Kitchen	AA	271/300	90.33%	6
16	Christopher Jones	AA	270/300	90.00%	7
17	Stephen Clark	B	265/300	88.33%	3
18	Paul Worthington	B	263/300	87.67%	4
19	Cedric Leeming	C	254/300	84.67%	1
20	Sarah Thorpe	C	239/300	79.67%	2
21	Paul Lambert	C	190/300	63.33%	3

Other DTL Events at North Of England C.T.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.028s ● FAST

DB 48% · Py 36% · Render 17%

11 queries · avg 1.2ms · max 1.9ms

Render Breakdown

DB Logic (Pre-Render) 0.0134s

Python Logic (Pre-Render) 0.0100s

Full Page Render 0.0048s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.003s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [02:12:02.936] 1.9ms

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:12:02.938] 1.3ms

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:12:02.941] 1.9ms

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:12:02.943] 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:12:02.945] 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:12:02.947] 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:12:02.949] 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:12:02.950] 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 [02:12:02.952] 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 [02:12:02.954] 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:12:02.955] 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 North Of England C.T.C

Analyzing Data...

Refresh Complete

Already Up to Date?

Analyzing Data...

Refresh Complete

Already Up to Date?