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

11 rows where raceid = "1979-11-04-082-1800-Grass"

View and edit SQL

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

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1976_K034 1979-11-04-082-1800-Grass 11 11 92 F Carr J Roe 27 1/4 17.0 128             116.7    
HK_1976_K127 1979-11-04-082-1800-Grass 02 9 87 M K Tam M C Tam 3 11.0 120             112.7    
HK_1977_L014 1979-11-04-082-1800-Grass 01 3 86 A Chan K S Ho 3 6.6 122             112.2    
HK_1977_L094 1979-11-04-082-1800-Grass 03 8 89 A Chan J Tandari 4 1/2 12.0 125             112.9    
HK_1978_M154 1979-11-04-082-1800-Grass 04 5 99 T L Lee D Brosnan 6 4.2 135             113.1    
HK_1978_M178 1979-11-04-082-1800-Grass 07 6 95 E Collingwood C Roche 19 1/4 6.8 131             115.3    
HK_1978_M207 1979-11-04-082-1800-Grass 08 1 90 G Sofronoff K W Lui 20 3/4 11.0 123             115.6    
HK_1978_M214 1979-11-04-082-1800-Grass 06 4 100 P Supple W Burnett 8 3/4 25.0 136             113.6    
HK_1978_M227 1979-11-04-082-1800-Grass 05 2 89 P C Kan W Hartack 6 3/4 45.0 125             113.2    
HK_1979_N097 1979-11-04-082-1800-Grass 10 7 95 G Moore G W Moore 23 1/4 3.6 131             116.0    
HK_1979_N109 1979-11-04-082-1800-Grass 09 10 87 R Burns P Miers 21 1/2 35.0 123             115.7    

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