Historic Australian Horse Racing Dataset

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

@kaggle.hassankamran011_historic_australian_horse_racing_dataset

Table List

5 tables(61.24 MB)

Field

Gear Changes

Horses

Horses1

Horses2

Horses1

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.horses1

24.45 MB
434663 rows
98 columns

id Id	racenumber RaceNumber	racename RaceName	racetitle RaceTitle	racedistance RaceDistance	place Place	horsename HorseName	prizemoney Prizemoney	row Row	trainer Trainer	driver Driver	margin Margin	startingodds StartingOdds	stewardscomments StewardsComments	gross_time Gross Time	mile_rate Mile Rate	lead_time Lead Time	first_quarter First Quarter	second_quarter Second Quarter	third_quarter Third Quarter	fourth_quarter Fourth Quarter	venue Venue	daycalender DayCalender	handicap Handicap	placer Placer	horseid HorseID	age Age	colour Colour	sire Sire	sex Sex	winner Winner	lifetimeruns LifetimeRuns	lifetimewins LifetimeWins	lifetimeseconds LifetimeSeconds	lifetimethirds LifetimeThirds	lifetimeplacings LifetimePlacings	lifetimewinpercent LifetimeWinPercent	lifetimeplacepercent LifetimePlacePercent	class Class	dayssincelast Dayssincelast	gatespeedstrikerate Gatespeedstrikerate	broken Broken	leaderstrikerate LeaderStrikeRate	laststart Laststart	start2 Start2	start3 Start3	start4 Start4	marginwinner MarginWinner	leading Leading	deathseat Deathseat	onebehind OneBehind	oneone OneOne	fifthpegs FifthPegs	worsethanfifth Worsethanfifth	standingstartlaststart Standingstartlaststart	insiderunningline Insiderunningline	mobilestart Mobilestart	bsp BSP	weather Weather	trackcondition TrackCondition
4711	1	SKY RACING TROTTERS HANDICAP	$7,630 T2 Or Better. RBD. Stand	2647	1	TAIMATE SUCCESS	4171	Fr1	Graham Dwyer	N M Dawson		1.4	PRB SAL 1 SWAB	00:03:31.7000000	00:02:08.7000000	00:01:28.9000000	00:00:33.5000000	00:00:32.2000000	00:00:29.3000000	00:00:27.8000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	800097	5	BAY	GREAT SUCCESS USA	MARE	1	30	4	9	6	19	0.1333333333333333	0.6333333333333333	70	4	0.1666666666666666		0.0333333333333333	1	2	1	2	2.7	1					1	1	1		1.69	1	GOOD
4712	1	SKY RACING TROTTERS HANDICAP	$7,630 T2 Or Better. RBD. Stand	2647	2	TWICE AS MUCH	1224	Fr1	Wayne Graham	W T Graham	2.7	18.8	OTE OTM OL 2 SWAB	00:03:31.7000000	00:02:08.7000000	00:01:28.9000000	00:00:33.5000000	00:00:32.2000000	00:00:29.3000000	00:00:27.8000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	30	1	791872	6	BAY	SAM BOURBON (FRA)	GELDING		34	11	6	1	18	0.3235294117647059	0.5294117647058824	67	3	0.1470588235294117	0.1470588235294117	0.1470588235294117	2	6	4	9			1				1	1	1		13.69	1	GOOD
4713	1	SKY RACING TROTTERS HANDICAP	$7,630 T2 Or Better. RBD. Stand	2647	3	JUSTABITCOCO	635	Fr2	Doug Lee	D R Lee	4.8	4.5	3	00:03:31.7000000	00:02:08.7000000	00:01:28.9000000	00:00:33.5000000	00:00:32.2000000	00:00:29.3000000	00:00:27.8000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	10	1	770322	7	BAY	BACARDI LINDY USA	MARE		118	13	19	12	44	0.1101694915254237	0.3728813559322034	62	12		0.0847457627118644	0.0169491525423728	3	2	4	9				1			1	1	1		6.91	1	GOOD
4714	1	SKY RACING TROTTERS HANDICAP	$7,630 T2 Or Better. RBD. Stand	2647	4	SCORCHED	438	Fr1	Doug Lee	G P Whitaker	7.2	8.5	5	00:03:31.7000000	00:02:08.7000000	00:01:28.9000000	00:00:33.5000000	00:00:32.2000000	00:00:29.3000000	00:00:27.8000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20		782932	5	BAY	PEGASUS SPUR CA	GELDING		29	10	3	2	15	0.3448275862068966	0.5172413793103449	66	11		0.0689655172413793	0.1379310344827586	4	3	5	6						1	1	1	1		6.8	1	GOOD
4715	1	SKY RACING TROTTERS HANDICAP	$7,630 T2 Or Better. RBD. Stand	2647	5	STONED AGAIN	307	Fr1	Clint Petroff	C A Petroff	11	22.3	BO RODS 4 GF	00:03:31.7000000	00:02:08.7000000	00:01:28.9000000	00:00:33.5000000	00:00:32.2000000	00:00:29.3000000	00:00:27.8000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	10		770769	7	BAY	YANKEE PACO USA	GELDING		59	6	10	7	23	0.1016949152542373	0.3898305084745763	61	10	0.0847457627118644	0.0169491525423728	0.1694915254237288	5	9	2	8							1	1	1		20	1	GOOD
4716	1	SKY RACING TROTTERS HANDICAP	$7,630 T2 Or Better. RBD. Stand	2647		PRINCESS JESSICA	95	Fr2	Doug Lee	T R Moffat		24.7	PRB B PB PB VXAR NAR SD1T	00:03:31.7000000	00:02:08.7000000	00:01:28.9000000	00:00:33.5000000	00:00:32.2000000	00:00:29.3000000	00:00:27.8000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1		758154	10	BAY	SUNDON USA	MARE		115	11	26	22	59	0.0956521739130434	0.5130434782608696	58	4		0.1217391304347826			9	6	5							1	1	1		44.8	1	GOOD
4717	2	GOTTA GO CULLECT @ EGMONT PARK PACE	$4,041 C1 To C2. PBD/C. Mobile	1660	1	SURFACE TO AIR	2030	Fr5	Greg Elkins	M J Elkins (C,cl)		1.6	GS L 1 SWAB	00:01:57.1000000	00:01:53.6000000	00:00:03.4000000	00:00:27.9000000	00:00:29	00:00:28.4000000	00:00:28.4000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		1	221071	10	BAY/BROWN	PACIFIC ROCKET USA	GELDING	1	117	17	16	13	46	0.1452991452991453	0.3931623931623931	61	4	0.188034188034188	0.0256410256410256	0.1111111111111111	1	2	5	7	37	1					1		1	1	1.85	1	GOOD
4718	2	GOTTA GO CULLECT @ EGMONT PARK PACE	$4,041 C1 To C2. PBD/C. Mobile	1660	2	TIME TRAVELLER	612	Fr3	Darrel Graham	D W Graham	37	3.3	4	00:01:57.1000000	00:01:53.6000000	00:00:03.4000000	00:00:27.9000000	00:00:29	00:00:28.4000000	00:00:28.4000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		1	808745	4	BAY	MACH THREE CA	GELDING		8	1	1	2	4	0.125	0.5	62	25	0.5		0.25	2	9	4	3					1		1		1	1	3.09	1	GOOD
4719	2	GOTTA GO CULLECT @ EGMONT PARK PACE	$4,041 C1 To C2. PBD/C. Mobile	1660	3	SLIPASLYGRIN	329	Fr7	Max Towns	J B Elkins (C,cl)	38.8	10.2	RAS CWE 3WM RTR W1 RP QUER NOTED	00:01:57.1000000	00:01:53.6000000	00:00:03.4000000	00:00:27.9000000	00:00:29	00:00:28.4000000	00:00:28.4000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		1	759769	8	BAY	GRINFROMEARTOEAR USA	GELDING		143	18	20	15	53	0.1258741258741259	0.3706293706293706	53	4	0.2587412587412587	0.0069930069930069	0.1748251748251748	3	6	6	4							1		1	1	15.76	1	GOOD
4720	2	GOTTA GO CULLECT @ EGMONT PARK PACE	$4,041 C1 To C2. PBD/C. Mobile	1660	5	MINI CAM	171	Fr4	Dale Belford	K J Belford	44	23.6	RAS 6	00:01:57.1000000	00:01:53.6000000	00:00:03.4000000	00:00:27.9000000	00:00:29	00:00:28.4000000	00:00:28.4000000	Albion Park	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)			777602	6	BAY/BROWN	MILLION DOLLAR CAM USA	GELDING		90	6	7	13	26	0.0666666666666666	0.2888888888888888	41	6	0.1666666666666666	0.0666666666666666	0.1444444444444444	5	5	6	9							1		1	1	107.99	1	GOOD


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