September 27, 2014 at 15:03 #26747
Since I added the speed of each horse in a race to the database last year, it has been very useful.
I ran something that would draw a graph of the speed of a horse vs its age. I found that some horses had some curious ages, like -28 and -6. On investigation I found that there were some horses that ‘Died as a 4-y-o’, had their name reused in a later foaled horse. The entry in the horse registry changed the older horse’s name by adding a I to the end of its name, or II if it had been used twice. e.g Marengo(GB) foaled 2011, and Marengo I(GB) in 1994, although my records show Marengo I(GB) as a 20 year old and is still alive.
I changed 5300 races since 1994 and I run my checks daily and get three or four horses each week that need checking. Some just have an incorrect foaling date but most are ‘new’ horses with the same name as an existing, older horse. I can’t find a way of automating it yet as I have to check all the pedigree information to see if it is a new horse or an old one with changes to it’s sex or ownership/trainer.
Mick JohnsonSeptember 27, 2014 at 17:05 #490969TheBluesBrotherParticipant
- Total Posts 1079
The only way to solve the problems with the horses names is to identify them by their ID number.
I have been building a complete database for the French racing scene, and yesterday there was 162 runners and I collected the data in 30 seconds, which shows breeding, trainers, owners and jockeys etc.
Here is an example of 1 of the 3 files that are collected daily:
https://web.cloud.virginmedia.com/?shar … 47b7afc9a4
The Scraper I use was written by a contact who lives in ParisSeptember 27, 2014 at 19:32 #490975
I get my results and declaration data daily from a company that supplies the newspapers and the horse number is not included. I have loads of screen scraping stuff running on my Linux servers but none get that info either.
Mick JohnsonSeptember 27, 2014 at 21:18 #490984VenusianParticipant
- Total Posts 1665
There are no fewer than 30 Marengos on the http://www.pedigreequery.com/ database.September 27, 2014 at 21:31 #490989moehatParticipant
- Total Posts 7862
Does it go back to Napoleon?September 27, 2014 at 21:36 #490992Nathan HughesParticipant
- Total Posts 23815
I wouldn’t name my horse Marengo.Member since March 2008September 28, 2014 at 09:46 #491013
It does go back to Napoleon!
I only use 20 years data to analyse going corrections and course/distance coefficients so the way I’m doing it now is manageable. The ‘new’ horses, by definition, have little form so will probably not be assessed in a future race.
I use recent data on speed, adjusted for going, weight, etc., so pedigree will effect the posible performance of a horse but I measure the actual performance.
- You must be logged in to reply to this topic.