Historical Going description [closed]

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 :)
asked Nov 21, 2017 by PunterBot Handicapper (830 points)
closed Nov 28, 2017 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?
answered Nov 23, 2017 by colin Frankel (19,320 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.
...