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

8 rows where raceid = "1979-10-27-064-1235-Grass"

View and edit SQL

Suggested facets: lengthbehindwinner

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1975_Z074 1979-10-27-064-1235-Grass 05 8 55 A Chan P F Yiu 14 40.0 123             76.4    
HK_1975_Z108 1979-10-27-064-1235-Grass 03 2 64 T C Cheng T O Lau 7 9.9 132             75.4    
HK_1975_Z122 1979-10-27-064-1235-Grass 07 7 63 M K Tam H M Lee 20 1/4 58.0 131             77.3    
HK_1977_L010 1979-10-27-064-1235-Grass 08 3 61 K H Au G Hall 34 3/4 99.0 129             80.0    
HK_1978_M038 1979-10-27-064-1235-Grass 02 4 65 P C Kan W Hartack 4 2.8 133             75.0    
HK_1978_M050 1979-10-27-064-1235-Grass 06 6 56 E Collingwood W Hood 16 1/4 34.0 124             76.7    
HK_1978_M113 1979-10-27-064-1235-Grass 01 1 66 G Moore G W Moore 4 2.7 134             74.5    
HK_1978_M201 1979-10-27-064-1235-Grass 04 5 70 C Robertson R Setches 8 1/2 3.1 138             75.6    

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