I ran a query to identify all the winners over hurdles over the last 5 years for GB and IRE.
I used historic_races_beta (2015-01-01 to 2020-11-09) for a total of all hurdle races which gave 15,948. When I joined this to the historic_runners_beta to identify the winners (finish_position = 1) I got a total of 15,311 making a difference of 637.
On looking at the difference of 637 a small number comprised of horses which had been disqualified which accounts for some of the differences but, there are 619 races which have an entry on historic_races_beta but don't exist on historic_runners_beta. The meeting dates run from 2020-07-25 to 2020-10-20. Oddly, the 619 races have a corresponding entry on historic_runners.
Can I just check if this is a known issue or any pointers would be appreciated.
(I have a list of the race_ids if needed)