Dr Ron,

I was afraid you'd ask me that. At first I thought I'd seen your requirement met somewhere on the Internet, but after vainly checking sites (some as provided by Ms Boop) I was fed up. So I ran a 1 line SQL statement to generate the "records" from one of the racing results services on sale.

Onto a change of pace:

What you appear to be tring to do will NOT work. Ratings based on Track Records have been around for over 50 years, have consistently failed, and have been rightly mocked.

Partly because:

It would be quite easy to ensure times are accurate but the providers don't bother. So even now the data is plagued with wrongly timed races, wrong or approximate distances or key entry transposition errors which are never fixed. Errors like to go to extremes, so apparently record times are particularly likely to be errors instead.

Some genuine records are due to fluke conditions (e.g. weird winds). And no one can come within seconds of that time ever again.

It is not uncommon for record breaking breaking horses to never recover from that exertion. Therefore fail miserably at short prices before prematurely retiring.


So some Track Records might be unrealistic by a number of seconds. Whereas others might be attainable, because they aren't that big a deal. From records alone you can't figure which is which so it's an exercise in futility.


If it's any consolation average times don't work either.