Tote_win null?

Question

I tried to graph tote_win for the last 10,000 data points and tote_win was null for all of them - even the horses that finished 1st. Is tote_win null for the whole database, or is it only null as of recently?

Answer 1

tote_win is only present where there is a valid tote_win return, so it only applies to winners of races where the Tote operates betting pools, and none of the winners in the last month has a NULL value (with the exception of one Arabian race that is in the database in the last month, for which there is no tote betting).

Try the following query on this month's racing

>select tote_win from historic_runners join historic_races using (race_id) where meeting_date > "2016-07-01" and finish_position = 1;

It should return the same number of results (with only the one NULL Arabian race) as the number of races that have occurred in the same period, eg:

>select tote_win from historic_runners join historic_races using (race_id) where meeting_date > "2016-07-01" and finish_position = 1;

 

Comments

Thanks. I downloaded the database on July 7th, and the 10,000 most recent data points for me have null tote_win, but out of the whole database roughly a tenth of the data points have valid tote_win.
Do you have similar results?
Also, is there a way I can refresh my data to be more recent so that I can check the most recent data as you said?