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

12 rows where raceid = "1979-09-29-015-1650-Grass"

View and edit SQL

Suggested facets: place, 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_1974_Z033 1979-09-29-015-1650-Grass 01 3 39 G Moore G W Moore 3/4 5.9 123             105.1    
HK_1975_Z060 1979-09-29-015-1650-Grass -- 10 43 H M Cheung M C Tam P.U. 93.0 122                  
HK_1975_Z096 1979-09-29-015-1650-Grass 03 6 43 C L Ng C K Chow 3 3/4 17.0 122             105.7    
HK_1975_Z097 1979-09-29-015-1650-Grass 09 11 38 P C Kan G Hall 13 3/4 99.0 122             107.5    
HK_1975_Z106 1979-09-29-015-1650-Grass 10 12 45 H M Cheung R Staples 15 25.0 129             107.7    
HK_1975_Z109 1979-09-29-015-1650-Grass 07 4 45 G Sofronoff K W Lui 12 1/2 9.5 126             107.2    
HK_1976_K040 1979-09-29-015-1650-Grass 03 2 48 A Chan T O Lau 3 3/4 3.0 132             105.7    
HK_1976_K113 1979-09-29-015-1650-Grass 05 1 42 R Burns L Fox 7 1/2 10.0 126             106.4    
HK_1976_K132 1979-09-29-015-1650-Grass 06 8 51 T C Cheng W T Leung 9 66.0 135             106.6    
HK_1976_K145 1979-09-29-015-1650-Grass 08 5 43 M K Tam T P Yung 12 1/2 36.0 120             107.3    
HK_1977_L063 1979-09-29-015-1650-Grass 02 7 45 J H Brown S Morris 3/4 3.4 124             105.2    
HK_1977_L100 1979-09-29-015-1650-Grass 11 9 46 C Robertson R Setches 31 15.0 130             110.8    

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