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

13 rows where raceid = "1979-11-10-089-1600-Grass"

View and edit SQL

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

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1976_K020 1979-11-10-089-1600-Grass 12 12 105 J H Brown P Leyshan 15 3/4 20.0 124             99.4    
HK_1976_K029 1979-11-10-089-1600-Grass 08 1 106 R Burns Y P Chan 12 1/2 60.0 120             98.8    
HK_1977_L009 1979-11-10-089-1600-Grass 04 3 106 G Sofronoff F S Cheung SH/1/N 16.0 118             97.1    
HK_1977_L139 1979-11-10-089-1600-Grass 05 7 105 M K Tam C Roche 3 7.4 124             97.4    
HK_1977_L163 1979-11-10-089-1600-Grass 11 2 105 C Robertson W Burnett 14 52.0 124             99.1    
HK_1977_L167 1979-11-10-089-1600-Grass 13 10 109 N Metervelli R Staples 20 1/4 3.9 128             100.1    
HK_1977_L177 1979-11-10-089-1600-Grass 01 8 105 A Chan J Tandari SH 38.0 124             96.8    
HK_1978_M165 1979-11-10-089-1600-Grass 02 5 108 A Chan K L Man SH 4.2 122             96.8    
HK_1978_M172 1979-11-10-089-1600-Grass 07 6 103 N Metervelli K C Lo 11 14.0 122             98.6    
HK_1978_M206 1979-11-10-089-1600-Grass 03 11 102 R Burns P Miers SH/1 4.2 121             97.0    
HK_1978_M220 1979-11-10-089-1600-Grass 06 13 104 G Sofronoff B Andrews 5 10.0 123             97.7    
HK_1978_M224 1979-11-10-089-1600-Grass 10 4 109 P C Kan S M Au-Yeung 14 76.0 121             99.0    
HK_1979_N115 1979-11-10-089-1600-Grass 09 9 106 R Burns A K Cheam 13 3/4 99.0 125             99.0    

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