Back to Events

DTL — Down The Line

Down The Line at Bywell Shooting Ground

Bywell Shooting Ground

Sunday, 17 March 2019 · CPSA Results →

Event Rating

Latest Visitor Reviews

No written reviews yet.

Entries

80.7%

Field Average

93.3%

Highest Score

21.0%

Lowest Score

Top 3 Overall

🥈

John Adams

278/300

92.67%

🥇

P Chalmers

280/300

93.33%

🥉

David Woolley

276/300

92.00%

Event Difficulty

80.7% This Event

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

↓ -10.4% harder than usual

Ground avg: 91.1%

Score Distribution

90–100%

6 26.1%

80–89%

9 39.1%

70–79%

6 26.1%

60–69%

1 4.3%

50–59%

0 0.0%

<50%

1 4.3%

Field Achievement

% of competitors reaching each score threshold

90%+

26.1%

6 / 23

80%+

65.2%

15 / 23

70%+

91.3%

21 / 23

60%+

95.7%

22 / 23

50%+

95.7%

22 / 23

Class Breakdown

Class	Count	Average	High	Low	Winner
AA	2	89.7%	92.7%	86.7%	John Adams
A	9	87.6%	93.3%	80.7%	P Chalmers
B	6	82.2%	91.7%	75.3%	Elliott Cutter
C	5	74.8%	79.0%	69.0%	David Robinson
Other	1	21.0%	21.0%	21.0%	Ellie Whitehead

Class Composition

2 8.7%

9 39.1%

6 26.1%

5 21.7%

Other

1 4.3%

Largest class: A — 9 competitors (39.1%)

Class Winners

AA 2 entered

278/300 — 92.67%

John Adams

2: Alan Dixon — 86.67%

A 9 entered

280/300 — 93.33%

P Chalmers

2: David Woolley — 92.00%

B 6 entered

275/300 — 91.67%

Elliott Cutter

2: Brian Whitehead — 83.67%

C 5 entered

237/300 — 79.00%

David Robinson

2: Caroline Whitehead — 77.67%

Other 1 entered

63/300 — 21.00%

Ellie Whitehead

Full Results — 23 entries

A P Chalmers

280/300

93.3%

AA John Adams

278/300

92.7%

A David Woolley

276/300

92.0%

B Elliott Cutter

275/300

91.7%

A George Turnes

274/300

91.3%

A Mervyn Turkington

271/300

90.3%

A Edward Brown

266/300

88.7%

AA Alan Dixon

260/300

86.7%

A Ted Philipson

259/300

86.3%

A David Whitehead

255/300

85.0%

B Brian Whitehead

251/300

83.7%

B David Taberner

248/300

82.7%

A David Magill

243/300

81.0%

A Cliff Pain

242/300

80.7%

B Derek Ridley

241/300

80.3%

B Charles Rautenberg

238/300

79.3%

C David Robinson

237/300

79.0%

C Caroline Whitehead

233/300

77.7%

C Dominic Grant

229/300

76.3%

B Christopher Jones

226/300

75.3%

C Steven Price

216/300

72.0%

C Roger Bowie

207/300

69.0%

Unknown Ellie Whitehead

63/300

21.0%

#	Name	Class	Score	Score %	Class Rank
1	P Chalmers	A	280/300	93.33%	1
2	John Adams	AA	278/300	92.67%	1
3	David Woolley	A	276/300	92.00%	2
4	Elliott Cutter	B	275/300	91.67%	1
5	George Turnes	A	274/300	91.33%	3
6	Mervyn Turkington	A	271/300	90.33%	4
7	Edward Brown	A	266/300	88.67%	5
8	Alan Dixon	AA	260/300	86.67%	2
9	Ted Philipson	A	259/300	86.33%	6
10	David Whitehead	A	255/300	85.00%	7
11	Brian Whitehead	B	251/300	83.67%	2
12	David Taberner	B	248/300	82.67%	3
13	David Magill	A	243/300	81.00%	8
14	Cliff Pain	A	242/300	80.67%	9
15	Derek Ridley	B	241/300	80.33%	4
16	Charles Rautenberg	B	238/300	79.33%	5
17	David Robinson	C	237/300	79.00%	1
18	Caroline Whitehead	C	233/300	77.67%	2
19	Dominic Grant	C	229/300	76.33%	3
20	Christopher Jones	B	226/300	75.33%	6
21	Steven Price	C	216/300	72.00%	4
22	Roger Bowie	C	207/300	69.00%	5
23	Ellie Whitehead	Unknown	63/300	21.00%	1

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

DB 50% · Py 39% · Render 11%

11 queries · avg 1.4ms · max 3.3ms

Render Breakdown

DB Logic (Pre-Render) 0.0150s

Python Logic (Pre-Render) 0.0115s

Full Page Render 0.0033s

QUERY TABLES ▾

⚠ event_review 4× 0.004s

shoot_event 2× 0.003s

shoot_score 2× 0.005s

site_configuration 2× 0.002s

admin_menu_item 1× 0.001s

⚠ = queried 3+ times (cache candidate)

SQL QUERIES (11) — click to expand

#1 [22:04:18.880] 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 [22:04:18.883] 1.5ms

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:04:18.888] 3.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:04:18.890] 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 [22:04:18.892] 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 [22:04:18.894] 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:04:18.895] 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 [22:04:18.897] 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:04:18.899] 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:04:18.900] 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:04:18.902] 1.1ms

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?