Missing data on the historic_runners_beta table

0 votes

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)


asked Nov 24, 2020 in Smartform by ronbarr Novice (230 points)

1 Answer

0 votes
Hi Ron - thanks for question and replied off line so we can examine the queries used to produce these results.
answered Nov 30, 2020 by colin Frankel (16,100 points)