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

Horses2

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.horses2

13.96 MB
144917 rows
139 columns
Only the first 100 columns are shown

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	venue Venue	daycalender DayCalender	handicap Handicap	placer Placer	horseid HorseID	age Age	colour Colour	sire Sire	sex Sex	winner Winner	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	laststart Laststart	start2 Start2	start3 Start3	start4 Start4	marginwinner MarginWinner	samedistance SameDistance	leading Leading	deathseat Deathseat	upindistance Upindistance	downindistance Downindistance	driverchange Driverchange	rowlaststart RowLastStart	distancelaststart DistanceLastStart	trainerlaststart TrainerLastStart
1	ALBANY AUTOS 4YO+ MS PACE (SKY2)	$7,500 4YO and older. Maiden (HWOE = $0). RBD. Mobile	2265	10	JUST A SMILE	7500	3	Nathan Dymock	N C Dymock	103.8	91	RES 4 GG WI	Albany	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)			796616	6	BAY	SMILING SHARD NZ	GELDING		14	26		1	2	3		0.2142857142857142	0.1923076923076923	0.0384615384615384	5	1	3	1	50	4	0.0714285714285714	0.0714285714285714		8	10	4	6			1		1			4	2242	N C Dymock
4	SOS OFFICE 3YO+ MS PACE (SKY1)	$7,500 3YO and older. L6/7 NE HWOE $25,000+. PBD/L. Mobile	2265	5	ALL THE BELLS	7500	3	Barry Howlett	M W Johnson	24.2	16	GS OTE L1W OTE 6	Albany	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)			802153	5	BROWN	CARIBBEAN BLASTER	MARE		27	12	5	4	3	12	0.1851851851851851	0.4444444444444444	0.5	0.1666666666666666	6	2	2	2	75	201	0.5555555555555556		0.3703703703703703	8	2	1	4					1		1	3	2185	B J Howlett
6	ALBANY SCAFFOLD HIRE 4YO+ MS PACE (SKY1)	$7,500 4YO and older. L7/8 (CL9) CONDITIONED. PBD/L. Mobile	2265	8	ADDA COURAGE	7500	1	Damond Briggs	W G Andrews	96.2	61	5 GG WI	Albany	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)			783553	8	BAY	COURAGE UNDER FIRE NZ	GELDING		52	2	8	5	2	15	0.1538461538461538	0.2884615384615384							50	6	0.2884615384615384	0.0384615384615384	0.1923076923076923		2		1										0
1	GARRARDS HORSE & HOUND BAND 5 PACE	$14,060 Band 5. RBD. Mobile	1660	1	FRANCO LANDRY	14060	6	Jack Butler	C J Butler (C,cl)		6.5	3WEM W1 WF OL SWAB	Albion Park	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		1	812938	6	BROWN	BETTORS DELIGHT USA	HORSE	1	37	10	10	7	3	20	0.2702702702702703	0.5405405405405406	0.2	0.1	2		1	1	87	10	0.1081081081081081	0.081081081081081	0.054054054054054	1	1	2	7	1.7			1		1	1	4	2280	M J Butler
2	TAB VENUE MODE VETERANS PACE	$8,640 NR 70 to 99. PBD/L6$. Mobile	2138	7	ITZ BETTOR TO WIN	8640	1	Mark Dux	M A Dux	3.9	9	PRB GS L 1	Albion Park	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)			786217	9	BROWN	BETTORS DELIGHT USA	GELDING		46	4	6	9	1	16	0.1304347826086956	0.3478260869565217							83	7	0.2608695652173913		0.1739130434782608	2	4	7	8			1		1			3	1660	M A Dux
3	BADCOCK GROUP OF COMPANIES BAND 5 PACE	$14,060 Band 5. RBD. Mobile	1660	6	ROLL WITH ROCKY	14060	7	Donny Smith	N M Dawson	6.4	23	GS OL OTM 4	Albion Park	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)			794933	6	BROWN	ROCK N ROLL HEAVEN USA	GELDING		61	15	10	9	13	32	0.1639344262295081	0.5245901639344263	0.2666666666666666		4	1	3		61	7	0.2950819672131147		0.1967213114754098	1	1	4	6		1	1					3	1660	D J D Smith
5	SKY RACING QUALIFYING PACE	$14,660 No NR. RBD. Mobile	2138	3	BOHANNAN	14660	14	Jack Butler	C J Butler	2.7	21	3WM WF OL OTL 4	Albion Park	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		1	812452	7	BAY	SANTANNA BLUE CHIP USA	GELDING		55	24	10	9	9	28	0.1818181818181818	0.509090909090909	0.375	0.125	9	3	3	3	88	7	0.2		0.1454545454545454	2	3	3	6					1			6	1660	M J Butler
7	RADIOTAB PACE	$14,060 No NR. PBD/WOE. Mobile	1660	4	TENNYSON BROMAC	14060	4	Grant Dixon	G W Dixon	10.2	3	URP PRB 3WM WF OL 2	Albion Park	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)			803437	6	BAY	BETTORS DELIGHT USA	HORSE		39	10	13	7	5	25	0.3333333333333333	0.6410256410256411	0.4	0.1	4	3		1	111	10	0.0769230769230769		0.0256410256410256	3	1	2	1						1	1	5	2280	G W Dixon
9	AQWA CONSTRUCTIONS TROTTERS HANDICAP	$8,880 No NR. RBD. Stand	2138	7	IN THE VALLEY	8880	2	Ron Sallis	S R Graham	17.9	61	7	Albion Park	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	1		818410	7	BAY	MUSCLE MASS USA	GELDING		17	28	6	3	1	10	0.3529411764705882	0.5882352941176471	0.1785714285714285	0.0357142857142857	5	3	1	1	65	7	0.1176470588235294		0.2352941176470588	7	9	7	4						1			2647	R J Sallis
2	STIHL SHOP VICTOR HARBOR PACE (SKY 2)	$4,999 No NR. PBD/LTW. Mobile	1800	5	ALTHEGIRLSINMYLIFE	4999	5	Phillip Westbury	K L Green	61	101	6	Globe Derby Park	Sat Jan 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)			777525	9	BROWN/BLACK	IN THE POCKET USA	MARE		76	25	3	5	4	12	0.0394736842105263	0.1578947368421052	0.16		4	2	2		30	6	0.5789473684210527	0.1184210526315789	0.0921052631578947	4	7	8	7		1	1					4	1800	P J Westbury


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