PDA

View Full Version : Question for guys with a db


Gallop58
11-01-2011, 04:21 PM
Not sure if anyone can help with this query, but I'm looking for a one calendar year snapshot of the number of 2YO first time starters that never race again vs. the number that race 2 or more times, binned by race distance of that first race.
The larger the population the better. (Doing separately for 3YO first time starters would also be of great interest)
Example:
2F 89 2YOFTStarters 54 FTSTarters that raced back, 60.6%
4F 112 FTS 67 FTS2 59%
1 1/16 etc.
I ask because I'm interested in what the "average" attrition rate is, so I can compare how a particular trainer does compared to the "average".

Thanks in advance to anyone who is able to do this public service :)

sjk
11-02-2011, 06:19 AM
I get this for foals of 2004 that ran in 2006:

First DistOne Start OnlyStarted Again
1 1/16 MILES 8 246
1 1/8 MILES 6
1 MILE 9 360
2 1/2 FURLONGS 6
2 FURLONGS 192
3 1/2 FURLONGS 335
3 FURLONGS 8
4 1/2 FURLONGS 1272
4 FURLONGS 241
5 1/2 FURLONGS 108 4599
5 FURLONGS 33
6 1/2 FURLONGS 12 484
6 FURLONGS 73 2891
7 FURLONGS 16 471