Baselight
Sign In

Historic Australian Horse Racing Dataset

Predict outcomes of a horse race given the parameters of a race.

@kaggle.hassankamran011_historic_australian_horse_racing_dataset

Loading...
Loading...

About this Dataset

Historic Australian Horse Racing Dataset

The data in this dataset was obtained by scraping websites that provide information on past horse races held in Australia, as well as for placing bets on upcoming races.

Tables

Field

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.field
  • 1.13 MB
  • 13,260 rows
  • 98 columns
Loading... 
CREATE TABLE field (
  "venue" VARCHAR,
  "racenumber" BIGINT,
  "racename" VARCHAR,
  "racedistance" BIGINT,
  "horsenumber" BIGINT,
  "horsename" VARCHAR,
  "form" BIGINT,
  "trainer" VARCHAR,
  "driver" VARCHAR,
  "handicap" BIGINT,
  "horseid" BIGINT,
  "racetitle" VARCHAR,
  "row" BIGINT,
  "firstup" BIGINT,
  "spelllastfive" BIGINT,
  "firststarter" BIGINT,
  "daycalender" TIMESTAMP,
  "age" BIGINT,
  "sex" VARCHAR,
  "sire" VARCHAR,
  "lifetimeruns" BIGINT,
  "recentruns" BIGINT,
  "lifetimewins" BIGINT,
  "lifetimeseconds" BIGINT,
  "lifetimethirds" BIGINT,
  "lifetimeplacings" BIGINT,
  "lifetimewinpercent" DOUBLE,
  "lifetimeplacepercent" DOUBLE,
  "recentplacepercent" DOUBLE,
  "recentwinpercent" DOUBLE,
  "recentplacings" BIGINT,
  "recentthirds" BIGINT,
  "recentseconds" BIGINT,
  "recentwins" BIGINT,
  "class" BIGINT,
  "dayssincelast" BIGINT,
  "gatespeedstrikerate" DOUBLE,
  "broken" DOUBLE,
  "leaderstrikerate" DOUBLE,
  "startingodds" DOUBLE,
  "laststart" BIGINT,
  "start2" BIGINT,
  "start3" BIGINT,
  "start4" BIGINT,
  "gearchanges" VARCHAR,
  "gearremoved" VARCHAR,
  "horsename50" VARCHAR,
  "horsetrain" VARCHAR,
  "tracklaststart" VARCHAR,
  "rowlaststart" DOUBLE,
  "distancelaststart" DOUBLE,
  "trainerlaststart" VARCHAR,
  "driverlaststart" VARCHAR,
  "stewardsfull" VARCHAR,
  "bestwinningmile" VARCHAR,
  "samedistance" DOUBLE,
  "upindistance" DOUBLE,
  "downindistance" DOUBLE,
  "timeslead" DOUBLE,
  "timesgatespeed" DOUBLE,
  "timesbroken" DOUBLE,
  "prizemoneylaststart" DOUBLE,
  "triallaststart" DOUBLE,
  "standlaststart" DOUBLE,
  "racetime" VARCHAR,
  "morningrace" DOUBLE,
  "eveningrace" DOUBLE,
  "prizemoneylastrace" DOUBLE,
  "timelastrace" VARCHAR,
  "tracknamelaststart" VARCHAR,
  "morningracelaststart" DOUBLE,
  "eveningracelaststart" DOUBLE,
  "startingprice1" DOUBLE,
  "prizemoney" DOUBLE,
  "avestake" DOUBLE,
  "totalprize" DOUBLE,
  "sametrack" DOUBLE,
  "prizemoneyup" DOUBLE,
  "prizemoneydown" DOUBLE,
  "prizemoneysame" DOUBLE,
  "numbertrainer" DOUBLE,
  "driverchange" DOUBLE,
  "trainerchange" DOUBLE,
  "trials" DOUBLE,
  "aveplace" DOUBLE,
  "countofdeath" DOUBLE,
  "deathseat" DOUBLE,
  "leading" DOUBLE,
  "countfront1" DOUBLE,
  "countfront2" DOUBLE,
  "countfront3" DOUBLE,
  "countfront4" DOUBLE,
  "countld1" DOUBLE,
  "countld2" DOUBLE,
  "countld3" DOUBLE,
  "countld4" DOUBLE,
  "frontrow" DOUBLE,
  "secondrow" DOUBLE
);

Gear Changes

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.gear_changes
  • 1.13 MB
  • 13,260 rows
  • 98 columns
Loading... 
CREATE TABLE gear_changes (
  "venue" VARCHAR,
  "racenumber" BIGINT,
  "racename" VARCHAR,
  "racedistance" BIGINT,
  "horsenumber" BIGINT,
  "horsename" VARCHAR,
  "form" BIGINT,
  "trainer" VARCHAR,
  "driver" VARCHAR,
  "handicap" BIGINT,
  "horseid" BIGINT,
  "racetitle" VARCHAR,
  "row" BIGINT,
  "firstup" BIGINT,
  "spelllastfive" BIGINT,
  "firststarter" BIGINT,
  "daycalender" TIMESTAMP,
  "age" BIGINT,
  "sex" VARCHAR,
  "sire" VARCHAR,
  "lifetimeruns" BIGINT,
  "recentruns" BIGINT,
  "lifetimewins" BIGINT,
  "lifetimeseconds" BIGINT,
  "lifetimethirds" BIGINT,
  "lifetimeplacings" BIGINT,
  "lifetimewinpercent" DOUBLE,
  "lifetimeplacepercent" DOUBLE,
  "recentplacepercent" DOUBLE,
  "recentwinpercent" DOUBLE,
  "recentplacings" BIGINT,
  "recentthirds" BIGINT,
  "recentseconds" BIGINT,
  "recentwins" BIGINT,
  "class" BIGINT,
  "dayssincelast" BIGINT,
  "gatespeedstrikerate" DOUBLE,
  "broken" DOUBLE,
  "leaderstrikerate" DOUBLE,
  "startingodds" DOUBLE,
  "laststart" BIGINT,
  "start2" BIGINT,
  "start3" BIGINT,
  "start4" BIGINT,
  "gearchanges" VARCHAR,
  "gearremoved" VARCHAR,
  "horsename50" VARCHAR,
  "horsetrain" VARCHAR,
  "tracklaststart" VARCHAR,
  "rowlaststart" DOUBLE,
  "distancelaststart" DOUBLE,
  "trainerlaststart" VARCHAR,
  "driverlaststart" VARCHAR,
  "stewardsfull" VARCHAR,
  "bestwinningmile" VARCHAR,
  "samedistance" DOUBLE,
  "upindistance" DOUBLE,
  "downindistance" DOUBLE,
  "timeslead" DOUBLE,
  "timesgatespeed" DOUBLE,
  "timesbroken" DOUBLE,
  "prizemoneylaststart" DOUBLE,
  "triallaststart" DOUBLE,
  "standlaststart" DOUBLE,
  "racetime" VARCHAR,
  "morningrace" DOUBLE,
  "eveningrace" DOUBLE,
  "prizemoneylastrace" DOUBLE,
  "timelastrace" VARCHAR,
  "tracknamelaststart" VARCHAR,
  "morningracelaststart" DOUBLE,
  "eveningracelaststart" DOUBLE,
  "startingprice1" DOUBLE,
  "prizemoney" DOUBLE,
  "avestake" DOUBLE,
  "totalprize" DOUBLE,
  "sametrack" DOUBLE,
  "prizemoneyup" DOUBLE,
  "prizemoneydown" DOUBLE,
  "prizemoneysame" DOUBLE,
  "numbertrainer" DOUBLE,
  "driverchange" DOUBLE,
  "trainerchange" DOUBLE,
  "trials" DOUBLE,
  "aveplace" DOUBLE,
  "countofdeath" DOUBLE,
  "deathseat" DOUBLE,
  "leading" DOUBLE,
  "countfront1" DOUBLE,
  "countfront2" DOUBLE,
  "countfront3" DOUBLE,
  "countfront4" DOUBLE,
  "countld1" DOUBLE,
  "countld2" DOUBLE,
  "countld3" DOUBLE,
  "countld4" DOUBLE,
  "frontrow" DOUBLE,
  "secondrow" DOUBLE
);

Horses

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.horses
  • 21.68 MB
  • 640,515 rows
  • 59 columns
Loading... 
CREATE TABLE horses (
  "id" BIGINT,
  "racenumber" BIGINT,
  "racename" VARCHAR,
  "racetitle" VARCHAR,
  "racedistance" BIGINT,
  "place" DOUBLE,
  "horsename" VARCHAR,
  "prizemoney" BIGINT,
  "row" VARCHAR,
  "trainer" VARCHAR,
  "driver" VARCHAR,
  "margin" DOUBLE,
  "startingodds" DOUBLE,
  "stewardscomments" VARCHAR,
  "scratching" VARCHAR,
  "trackrating" VARCHAR,
  "gross_time" VARCHAR,
  "mile_rate" VARCHAR,
  "lead_time" VARCHAR,
  "first_quarter" VARCHAR,
  "second_quarter" VARCHAR,
  "third_quarter" VARCHAR,
  "fourth_quarter" VARCHAR,
  "venue" VARCHAR,
  "daycalender" TIMESTAMP,
  "handicap" BIGINT,
  "leader" DOUBLE,
  "gatespeed" DOUBLE,
  "placer" DOUBLE,
  "horseid" BIGINT,
  "age" BIGINT,
  "colour" VARCHAR,
  "sire" VARCHAR,
  "sex" VARCHAR,
  "winner" DOUBLE,
  "firststarter" DOUBLE,
  "lifetimeruns" DOUBLE,
  "recentruns" DOUBLE,
  "lifetimewins" DOUBLE,
  "lifetimeseconds" DOUBLE,
  "lifetimethirds" DOUBLE,
  "lifetimeplacings" DOUBLE,
  "lifetimewinpercent" DOUBLE,
  "lifetimeplacepercent" DOUBLE,
  "recentplacepercent" DOUBLE,
  "recentwinpercent" DOUBLE,
  "recentplacings" DOUBLE,
  "recentthirds" DOUBLE,
  "recentseconds" DOUBLE,
  "recentwins" DOUBLE,
  "class" DOUBLE,
  "dayssincelast" DOUBLE,
  "gatespeedstrikerate" DOUBLE,
  "broken" DOUBLE,
  "leaderstrikerate" DOUBLE,
  "laststart" DOUBLE,
  "start2" DOUBLE,
  "start3" DOUBLE,
  "start4" DOUBLE
);

Horses1

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.horses1
  • 25.64 MB
  • 434,663 rows
  • 98 columns
Loading... 
CREATE TABLE horses1 (
  "id" BIGINT,
  "racenumber" BIGINT,
  "racename" VARCHAR,
  "racetitle" VARCHAR,
  "racedistance" BIGINT,
  "place" BIGINT,
  "horsename" VARCHAR,
  "prizemoney" BIGINT,
  "row" VARCHAR,
  "trainer" VARCHAR,
  "driver" VARCHAR,
  "margin" DOUBLE,
  "startingodds" DOUBLE,
  "stewardscomments" VARCHAR,
  "scratching" VARCHAR,
  "trackrating" VARCHAR,
  "gross_time" VARCHAR,
  "mile_rate" VARCHAR,
  "lead_time" VARCHAR,
  "first_quarter" VARCHAR,
  "second_quarter" VARCHAR,
  "third_quarter" VARCHAR,
  "fourth_quarter" VARCHAR,
  "venue" VARCHAR,
  "daycalender" TIMESTAMP,
  "handicap" BIGINT,
  "placer" BIGINT,
  "horseid" BIGINT,
  "age" BIGINT,
  "colour" VARCHAR,
  "sire" VARCHAR,
  "sex" VARCHAR,
  "winner" BIGINT,
  "firststarter" BIGINT,
  "lifetimeruns" BIGINT,
  "recentruns" BIGINT,
  "lifetimewins" BIGINT,
  "lifetimeseconds" BIGINT,
  "lifetimethirds" BIGINT,
  "lifetimeplacings" BIGINT,
  "lifetimewinpercent" DOUBLE,
  "lifetimeplacepercent" DOUBLE,
  "recentplacepercent" DOUBLE,
  "recentwinpercent" DOUBLE,
  "recentplacings" BIGINT,
  "recentthirds" BIGINT,
  "recentseconds" BIGINT,
  "recentwins" BIGINT,
  "class" BIGINT,
  "dayssincelast" BIGINT,
  "gatespeedstrikerate" DOUBLE,
  "broken" DOUBLE,
  "leaderstrikerate" DOUBLE,
  "laststart" BIGINT,
  "start2" BIGINT,
  "start3" BIGINT,
  "start4" BIGINT,
  "marginwinner" DOUBLE,
  "samedistance" VARCHAR,
  "fiftypercentile" VARCHAR,
  "bestmilerateint" VARCHAR,
  "leading" DOUBLE,
  "deathseat" DOUBLE,
  "onebehind" DOUBLE,
  "oneone" DOUBLE,
  "fifthpegs" DOUBLE,
  "worsethanfifth" BIGINT,
  "trainerruns" VARCHAR,
  "trainerstrikerate" VARCHAR,
  "driverstrikerate" VARCHAR,
  "driverruns" VARCHAR,
  "numberofhorses" VARCHAR,
  "racesfromsecondrow" VARCHAR,
  "racesfromfrontrow" VARCHAR,
  "gsfromdrawonetwo" VARCHAR,
  "gsfromdrawthreefour" VARCHAR,
  "gsfromdrawrestoffront" VARCHAR,
  "gsandleadwhengsinside" VARCHAR,
  "gsandleadwhengsoutside" VARCHAR,
  "firsttimeatdistance" VARCHAR,
  "upindistance" VARCHAR,
  "downindistance" VARCHAR,
  "mostrunsatdistance" VARCHAR,
  "aveprizemoney" VARCHAR,
  "countgatespeedonfrontrow" VARCHAR,
  "homevenue" VARCHAR,
  "driverchange" VARCHAR,
  "trainerchange" VARCHAR,
  "trackchange" VARCHAR,
  "bestwinningmileratelastwin" VARCHAR,
  "standingstartlaststart" DOUBLE,
  "insiderunningline" DOUBLE,
  "outsiderunningline" DOUBLE,
  "mobilestart" DOUBLE,
  "bsp" DOUBLE,
  "weather" DOUBLE,
  "trackcondition" VARCHAR,
  "horsename50" VARCHAR
);

Horses2

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.horses2
  • 14.64 MB
  • 144,917 rows
  • 139 columns
Loading... 
CREATE TABLE horses2 (
  "racenumber" BIGINT,
  "racename" VARCHAR,
  "racetitle" VARCHAR,
  "racedistance" BIGINT,
  "place" BIGINT,
  "horsename" VARCHAR,
  "prizemoney" BIGINT,
  "row" BIGINT,
  "trainer" VARCHAR,
  "driver" VARCHAR,
  "margin" DOUBLE,
  "startingodds" DOUBLE,
  "stewardscomments" VARCHAR,
  "scratching" VARCHAR,
  "trackrating" VARCHAR,
  "gross_time" VARCHAR,
  "mile_rate" VARCHAR,
  "lead_time" VARCHAR,
  "first_quarter" VARCHAR,
  "second_quarter" VARCHAR,
  "third_quarter" VARCHAR,
  "fourth_quarter" VARCHAR,
  "venue" VARCHAR,
  "daycalender" TIMESTAMP,
  "handicap" BIGINT,
  "placer" BIGINT,
  "horseid" BIGINT,
  "age" BIGINT,
  "colour" VARCHAR,
  "sire" VARCHAR,
  "sex" VARCHAR,
  "winner" BIGINT,
  "firststarter" BIGINT,
  "lifetimeruns" BIGINT,
  "recentruns" BIGINT,
  "lifetimewins" BIGINT,
  "lifetimeseconds" BIGINT,
  "lifetimethirds" BIGINT,
  "lifetimeplacings" BIGINT,
  "lifetimewinpercent" DOUBLE,
  "lifetimeplacepercent" DOUBLE,
  "recentplacepercent" DOUBLE,
  "recentwinpercent" DOUBLE,
  "recentplacings" BIGINT,
  "recentthirds" BIGINT,
  "recentseconds" BIGINT,
  "recentwins" BIGINT,
  "class" BIGINT,
  "dayssincelast" BIGINT,
  "gatespeedstrikerate" DOUBLE,
  "broken" DOUBLE,
  "leaderstrikerate" DOUBLE,
  "laststart" BIGINT,
  "start2" BIGINT,
  "start3" BIGINT,
  "start4" BIGINT,
  "marginwinner" DOUBLE,
  "samedistance" BIGINT,
  "fiftypercentile" VARCHAR,
  "bestmilerateint" VARCHAR,
  "leading" BIGINT,
  "deathseat" BIGINT,
  "onebehind" VARCHAR,
  "oneone" VARCHAR,
  "fifthpegs" VARCHAR,
  "worsethanfifth" VARCHAR,
  "trainerruns" VARCHAR,
  "trainerstrikerate" VARCHAR,
  "driverstrikerate" VARCHAR,
  "driverruns" VARCHAR,
  "numberofhorses" VARCHAR,
  "racesfromsecondrow" VARCHAR,
  "racesfromfrontrow" VARCHAR,
  "gsfromdrawonetwo" VARCHAR,
  "gsfromdrawthreefour" VARCHAR,
  "gsfromdrawrestoffront" VARCHAR,
  "gsandleadwhengsinside" VARCHAR,
  "gsandleadwhengsoutside" VARCHAR,
  "firsttimeatdistance" VARCHAR,
  "upindistance" BIGINT,
  "downindistance" BIGINT,
  "mostrunsatdistance" VARCHAR,
  "aveprizemoney" VARCHAR,
  "countgatespeedonfrontrow" VARCHAR,
  "homevenue" VARCHAR,
  "driverchange" BIGINT,
  "trainerchange" BIGINT,
  "trackchange" VARCHAR,
  "bestwinningmileratelastwin" VARCHAR,
  "standingstartlaststart" VARCHAR,
  "insiderunningline" VARCHAR,
  "outsiderunningline" VARCHAR,
  "mobilestart" VARCHAR,
  "bsp" VARCHAR,
  "weather" VARCHAR,
  "trackcondition" VARCHAR,
  "horsename50" VARCHAR,
  "rowlaststart" DOUBLE,
  "distancelaststart" BIGINT,
  "trainerlaststart" VARCHAR
);

Share link

Anyone who has the link will be able to view this.