Data source: Hong Kong Jockey Club · About: Hong Kong horserace data updated daily by Data Guru, LLC

14 rows where raceid = "1979-11-17-097-1000-Grass"

View and edit SQL

Suggested facets: rating, trainer, lengthbehindwinner, actualweight, finishtime

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1972_F042 1979-11-17-097-1000-Grass 06 9 49 R Burns A K Cheam 4 1/4 34.0 133             61.5    
HK_1973_G038 1979-11-17-097-1000-Grass 13 1 49 G Smyth G Starkey 7 1/4 42.0 133             62.0    
HK_1973_G039 1979-11-17-097-1000-Grass 08 14 36 G Sofronoff K W Lui 4 1/4 11.0 117             61.6    
HK_1974_Z024 1979-11-17-097-1000-Grass 12 12 35 R Burns P Miers 5 3/4 7.5 119             61.8    
HK_1975_Z066 1979-11-17-097-1000-Grass 02 11 44 M K Tam B Taylor 2 25.0 128             61.1    
HK_1975_Z072 1979-11-17-097-1000-Grass 04 6 49 G Moore G W Moore 2 1/2 9.3 133             61.2    
HK_1975_Z095 1979-11-17-097-1000-Grass 09 5 53 A Chan K S Ho 4 1/4 4.3 137             61.6    
HK_1975_Z096 1979-11-17-097-1000-Grass 03 4 44 C L Ng D C Cruz 2 1/2 8.9 128             61.2    
HK_1975_Z126 1979-11-17-097-1000-Grass 11 8 47 C Robertson R Setches 4 1/2 8.7 131             61.6    
HK_1977_L024 1979-11-17-097-1000-Grass 14 7 42 F Carr S Morris 8 44.0 121             62.2    
HK_1977_L070 1979-11-17-097-1000-Grass 10 2 49 A Ward L Fox 4 1/4 82.0 133             61.6    
HK_1977_L125 1979-11-17-097-1000-Grass 01 3 38 C L Ng C C Nam 2 18.0 115             60.8    
HK_1978_M011 1979-11-17-097-1000-Grass 05 13 48 P C Kan J Bleasdale 2 3/4 6.0 132             61.2    
HK_1978_M171 1979-11-17-097-1000-Grass 07 10 52 K H Au M C Tam 4 1/4 12.0 133             61.5    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [horsesraces] (
   [horseid] TEXT,
   [raceid] TEXT,
   [place] TEXT,
   [draw] INTEGER,
   [rating] INTEGER,
   [trainer] TEXT,
   [jockey] TEXT,
   [lengthbehindwinner] TEXT,
   [winodds] FLOAT,
   [actualweight] INTEGER,
   [position1] INTEGER,
   [position2] INTEGER,
   [position3] INTEGER,
   [position4] INTEGER,
   [position5] INTEGER,
   [position6] INTEGER,
   [finishtime] FLOAT,
   [declaredweight] INTEGER,
   [gear] TEXT,
   PRIMARY KEY ([horseid], [raceid]),
   FOREIGN KEY(horseid) REFERENCES horses(horseid),
   FOREIGN KEY(raceid) REFERENCES races(raceid)
);
CREATE INDEX [idx_horsesraces_raceid]
    ON [horsesraces] ([raceid]);
CREATE INDEX [idx_horsesraces_horseid]
    ON [horsesraces] ([horseid]);