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

7 rows where raceid = "1979-11-17-098-1400-Grass"

View and edit SQL

Suggested facets: rating, lengthbehindwinner, actualweight, finishtime

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1976_K012 1979-11-17-098-1400-Grass 04 3 112 T L Lee R Setches 6 3/4 14.0 121             83.5    
HK_1977_L092 1979-11-17-098-1400-Grass 01 6 124 A Ward B Andrews SH 2.5 133             82.4    
HK_1977_L134 1979-11-17-098-1400-Grass 07 7 111 C Robertson W Burnett 14 9.2 120             84.7    
HK_1978_M156 1979-11-17-098-1400-Grass 03 5 113 P C Kan J Bleasdale 6 5.3 122             83.3    
HK_1978_M168 1979-11-17-098-1400-Grass 02 2 112 S T Wong D Brosnan SH 36.0 121             82.4    
HK_1978_M204 1979-11-17-098-1400-Grass 05 4 111 E Collingwood C Roche 8 1/4 3.7 120             83.7    
HK_1979_N118 1979-11-17-098-1400-Grass 06 1 114 T C Cheng B Taylor 11 6.6 123             84.2    

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