Hi,
It's in the database in a number of places, however the best fields to use for it (since they show how many times a horse has run with wind surgery) are in historic_runners_insights, here:
https://www.betwise.co.uk/smartform/historic_runners_insights
See the descriptions for wind_surgery_dec and prev_wind_ops, as follows:
the daily_runners and historic_runners table now contains a field for wind_surgery_declared. This field only contains an entry for the run immediately following any sort of wind_surgery. However, on any subsequent run where the horse did not have wind surgery immediately prior to that run and post its last run, there will be no evidence that a horse has previously had wind surgery without querying back in time for the horse's history. This field provides a ready solution by showing whether or not a horse has had any wind surgery at any point in its career, and how many different surgeries have been performed. Thus it shows 0,1,2 etc for each horse
