My calendar year 2018 database (all track codes in North America and thoroughbred only) shows a little under 40k races with 301,522 starters:
Code:
Data Window Settings:
Connected to: C:\JCapper\exe\JCapper2.mdb
999 Divisor Odds Cap: None
SQL UDM Plays Report: Hide
SQL: SELECT * FROM STARTERHISTORY
WHERE [DATE] >= #01-01-2018#
AND [DATE] <= #12-31-2018#
ORDER BY [DATE], TRACK, RACE
Data Summary Win Place Show
-----------------------------------------------------
Mutuel Totals 448145.60 452766.50 450903.50
Bet -603044.00 -603044.00 -603044.00
-----------------------------------------------------
P/L -154898.40 -150277.50 -152140.50
Wins 39976 79567 116011
Plays 301522 301522 301522
PCT .1326 .2639 .3848
ROI 0.7431 0.7508 0.7477
Avg Mut 11.21 5.69 3.89
Here's what the above query results look like if you break the data out by the medication codes in the Equibase chart data:
Code:
By: Medication
Value P/L Bet Roi Wins Plays Pct Impact AvgMut
----------------------------------------------------------------------------------
0 -606.40 1766.00 0.6566 101 883 .1144 0.8627 11.48 None
1 -127490.40 503254.00 0.7467 34053 251627 .1353 1.0207 11.03 Lasix
2 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00 Bute
3 -9662.20 38712.00 0.7504 2815 19356 .1454 1.0969 10.32 Lasix & Bute
4 -6390.70 29512.00 0.7835 1611 14756 .1092 0.8235 14.35 1st Time Lasix
5 -593.00 1854.00 0.6802 100 927 .1079 0.8137 12.61 Bute & 1st Time Lasix
6 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00
7 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00
8 0.00 0.00 0.0000 0 0 .0000 0.0000 0.00
9 -10155.70 27946.00 0.6366 1296 13973 .0928 0.6996 13.73 Unknown
My comments:
Only 883 runners out of 301,522 were listed in the Equibase chart data as Medication: None.
95.07% of all thoroughbred starters (286,666 out of 301,522) were listed in the Equibase chart data as either Lasix, Lasix & Bute, 1st Time Lasix, or Bute & 1st Time Lasix.
Imo, Lasix is hardly a magic bullet.
However, the win percentages and roi of the runners in each row say that horses treated with lasix do win a higher percentage of their races than horses not treated with lasix.
I'm guessing that's probably why 95% are treated with Lasix whether they are bleeders or not.
-jp
.
