0 votes
Can anyone tell me where this is sourced from so I can get it for current races?
closed with the note: I found a source :)
by PunterBot Handicapper (830 points)
closed by PunterBot

1 Answer

0 votes
Hi -

You have advanced_going in the daily_races table and going in the historic_races table.  I'm guessing you might know this already - if not hope this helps; but if so, what else are you after?
by colin Frankel (19.7k points)
Hi yeah I’ve seen the advanced going but I want to use it in my predictive model. There is only a handful of going descriptions but hundreds of variants in the advanced going.
I’m assuming the going on say Sportlife Life will be the same pre/post race and it’s this consistency that I need.
Hi - yes the historical going is rationalised after the fact but the daily going is as reported by clerks of the course; who typically hedge their bets so to speak but also provide any variant of the current in different parts of the course - eg. "soft in places".

In order to compare both if you have say a live model, you will need to take a pattern matching approach to the daily going.  Eg. a statement in your favoured programming language to the effect of "if 'advanced_going' contains 'good' and 'soft' then going = 'good to soft'.
Thanks Colin, I've done exactly that.
...