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

Horses

@kaggle.hassankamran011_historic_australian_horse_racing_dataset.horses

20.67 MB
640515 rows
59 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	trackrating TrackRating	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	leader Leader	gatespeed GateSpeed	placer Placer	horseid HorseID	age Age	colour Colour	sire Sire	sex Sex	winner Winner
1977303	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	1	JACK MALONE	5092	Fr5	Peter Greig	P J Greig		2.4	GS L 1 SWAB	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	1	1	773852	4	BAY	CAMMIBEST USA	GELDING	1
1977304	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	2	VADER	1520	Fr3	Ryan Veivers	N M Dawson	7.3	18.1	SLE 3	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			1	770866	5	BROWN/BLACK	ALLAMERICAN INGOT USA	GELDING
1977305	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	3	ADRIATIC COAST	760	Fr1	Rob Gorman	R M Gorman	11.2	6	5 D/F UW	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)			1	787614	6	BLACK	WASHINGTON VC USA	GELDING
1977306	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	4	TUXEDO MAX	228	Sr2	Ken Rattray	I L Ross	14.8	7.4	3WM W1 OL	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				792645	5	BROWN/BLACK	ELSU NZ	GELDING
1977307	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	5	TRUE DESIRE	50	Fr7	Mark Dux	M A Dux	16.1	53.1	PRB CWE 4	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				541224	7	BAY	REAL DESIRE USA	GELDING
1977308	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	6	FOREST FURY	50	Sr1	Dayl March	D R March	16.5	16.6	7	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				762951	6	BAY	BETTORS DELIGHT USA	GELDING
1977309	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	7	END OF THE MATTER	50	Fr4	Ashlee Neilson	M P Neilson	18.7	3.7	CWE RTR 8	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				772392	7	BAY	REAL DESIRE USA	GELDING
1977310	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	8	LORD JONES	50	Fr6	Darrel Graham	A F J Sanderson	21.6	21.4	RAS 6	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				773040	6	BAY/BROWN	CHRISTIAN CULLEN NZ	GELDING
1977311	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	9	BLESSED IS THE BOY	50	Sr3	John McMullen	N J McMullen	27	96.6	9	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				761465	6	BAY	BLISSFULL HALL USA	GELDING
1977312	1	SPORTS TODAY ON 4BC CONDITIONED PACE	$8,000 C2 Or Better. RBD. Mobile	1660	10	ERNIE BARRASSO	50	Fr2	Nick Pugliese	N Pugliese	34.5	124.4	2	GOOD	00:01:58.4000000	00:01:54.8000000	00:00:03.4000000	00:00:28.4000000	00:00:30.1000000	00:00:28.4000000	00:00:28.1000000	Albion Park	Sat Jan 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)				766111	8	BROWN	ARTSPLACE (US)	GELDING


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