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

Gear Changes
@kaggle.hassankamran011_historic_australian_horse_racing_dataset.gear_changes

  • 1.08 MB
  • 13260 rows
  • 98 columns
venue

Venue

racenumber

RaceNumber

racename

RaceName

racedistance

RaceDistance

horsenumber

HorseNumber

horsename

HorseName

form

Form

trainer

Trainer

driver

Driver

handicap

Handicap

horseid

HorseID

racetitle

RaceTitle

row

Row

firstup

Firstup

spelllastfive

Spelllastfive

firststarter

Firststarter

daycalender

DayCalender

age

Age

sex

Sex

sire

Sire

lifetimeruns

LifetimeRuns

recentruns

RecentRuns

lifetimewins

LifetimeWins

lifetimeseconds

LifetimeSeconds

lifetimethirds

LifetimeThirds

lifetimeplacings

LifetimePlacings

lifetimewinpercent

LifetimeWinPercent

lifetimeplacepercent

LifetimePlacePercent

recentplacepercent

RecentPlacePercent

recentwinpercent

RecentWinPercent

recentplacings

RecentPlacings

recentthirds

RecentThirds

recentseconds

RecentSeconds

recentwins

RecentWins

class

Class

dayssincelast

Dayssincelast

gatespeedstrikerate

Gatespeedstrikerate

broken

Broken

leaderstrikerate

LeaderStrikeRate

startingodds

StartingOdds

laststart

Laststart

start2

Start2

start3

Start3

start4

Start4

gearchanges

GearChanges

gearremoved

GearRemoved

horsename50

Horsename50

horsetrain

Horsetrain

tracklaststart

TrackLastStart

rowlaststart

RowLastStart

distancelaststart

DistanceLastStart

trainerlaststart

TrainerLastStart

driverlaststart

DriverLastStart

stewardsfull

StewardsFull

bestwinningmile

BestWinningMile

samedistance

Samedistance

upindistance

UpInDistance

downindistance

DownInDistance

timeslead

TimesLead

timesgatespeed

TimesGateSpeed

timesbroken

TimesBroken

prizemoneylaststart

PrizemoneyLastStart

triallaststart

Triallaststart

standlaststart

Standlaststart

racetime

Racetime

morningrace

Morningrace

eveningrace

Eveningrace

prizemoneylastrace

Prizemoneylastrace

timelastrace

Timelastrace

tracknamelaststart

Tracknamelaststart

morningracelaststart

Morningracelaststart

eveningracelaststart

Eveningracelaststart

startingprice1

Startingprice1

prizemoney

Prizemoney

avestake

Avestake

totalprize

Totalprize

sametrack

Sametrack

prizemoneyup

Prizemoneyup

prizemoneydown

Prizemoneydown

prizemoneysame

Prizemoneysame

numbertrainer

NumberTrainer

driverchange

Driverchange

trainerchange

Trainerchange

trials

Trials

aveplace

Aveplace

countofdeath

Countofdeath

deathseat

Deathseat

leading

Leading

countfront1

Countfront1

countfront2

Countfront2

countfront3

Countfront3

countfront4

Countfront4

countld1

Countld1

countld2

Countld2

countld3

Countld3

countld4

Countld4

frontrow

Frontrow

secondrow

Secondrow

Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23001VALLEY ESS JAY11484David McElhinneyBryse McElhinney (C,5)777582$9,180 NR up to 70. PBD/NR. Mobile1Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)9GELDINGSKYVALLEY NZ 110715168390.13636363636363630.35454545454545450.42857142857142850.28571428571428573125770.26363636363636360.05454545454545450.2181818181818181414841nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23002KYLIES LIFE86165Joseph PaceJim Douglass 797122$9,180 NR up to 70. PBD/NR. Mobile2Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)6MARELIFE SIGN USA 6314634130.09523809523809520.20634920634920630.21428571428571420.14285714285714283125970.22222222222222220.01587301587301580.1587301587301587515616nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23004VICTREE HILL60210Courtney SlaterMichael Stanley 805682$9,180 NR up to 70. PBD/NR. Mobile3Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)4GELDINGTRIXTON (US) 113360.27272727272727270.5454545454545454591190.09090909090909090.09090909090909090.27272727272727271512nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23005PUMA ROAD25118Rickie AlchinRickie Alchin 813257$9,180 NR up to 70. PBD/NR. Mobile4Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)6GELDINGPEGASUS SPUR CA 68610210220.14705882352941170.32352941176470590.66666666666666660.541360140.05882352941176470.02941176470588230.0441176470588235158115nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23006ROYAL GLENFERRIE23012Paul FitzpatrickSean Grayling 803046$9,180 NR up to 70. PBD/NR. Mobile5Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)5HORSEBETTORS DELIGHT USA 3984610200.10256410256410250.51282051282051280.8750.12574216270.02564102564102560.05128205128205123.25213nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23007SOBOMBA20183J A Rando, M J RandoCameron Hart (C)803783$9,180 NR up to 70. PBD/NR. Mobile6Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)5GELDINGMAJESTIC SON CA 403587200.1250.50.66666666666666660.33333333333333332116270.5250.050.454381nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23008IONA GRINNER94732Troy WilliamsGavin Fitzpatrick 774755$9,180 NR up to 70. PBD/NR. Mobile7Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)9MAREGRINFROMEARTOEAR USA 20712231721610.11111111111111110.29468599033816420.253217070.0724637681159420.01932367149758450.0676328502415458212374nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE23009TORFINO MIST63737Blake FitzpatrickWill Rixon (C,3)795076$9,180 NR up to 70. PBD/NR. Mobile8Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)6MAREMAJESTIC SON CA 845101212340.1190476190476190.40476190476190470.42276130.32142857142857140.25157373nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle3MENANGLE COUNTRY CLUB TROTTERS MOBILE230010ALL CASHED UP12024Blake FitzpatrickBlake Fitzpatrick 802337$9,180 NR up to 70. PBD/NR. Mobile9Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)5HORSEREADY CASH (FRA) 212642120.28571428571428570.57142857142857140.51169240.2380952380952380.2380952380952382.75422nannannannannannannannannannan
Nswhrc at Tabcorp Pk Menangle4APG 2YO C & G BULLION HEAT16091UNCLE MIKI313Chris FrisbyPhoebe Betts (C)815026$9,180 2YO Colts and Geldings. No NR. RBD. Mobile1Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)2GELDINGALWAYS B MIKI USA 331230.3333333333333333110.33333333333333333214070.66666666666666660.66666666666666662.75313nannannannannannannannannannan

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
);

Share link

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