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

13 rows where raceid = "1979-11-04-077-1200-Grass"

View and edit SQL

Suggested facets: rating, trainer, actualweight, finishtime

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1971_Z012 1979-11-04-077-1200-Grass 09 8 6 H M Cheung R Staples 11 3/4 17.0 122             77.8    
HK_1973_G029 1979-11-04-077-1200-Grass 07 2 12 P M Chu P Leyshan 6 1/4 27.0 128             77.0    
HK_1973_G032 1979-11-04-077-1200-Grass 01 5 9 K H Au H M Lee HD 29.0 125             75.9    
HK_1974_Z028 1979-11-04-077-1200-Grass 06 11 22 C L Ng R Setches 5 3/4 8.6 138             76.9    
HK_1974_Z040 1979-11-04-077-1200-Grass 08 6 30 A Chan J Tandari 8 1/4 36.0 129             77.3    
HK_1975_Z075 1979-11-04-077-1200-Grass 12 7 3 T C Cheng Y P Chan 16 3/4 45.0 114             78.6    
HK_1976_K095 1979-11-04-077-1200-Grass 11 4 16 F Carr J Roe 15 1/4 96.0 132             78.3    
HK_1976_K110 1979-11-04-077-1200-Grass 10 10 23 M K Tam T P Yung 12 1/2 4.7 132             77.9    
HK_1976_K122 1979-11-04-077-1200-Grass 13 1 19 A Chan K S Ho 19 1/4 6.2 135             79.0    
HK_1976_K138 1979-11-04-077-1200-Grass 04 3 15 G Sofronoff B Andrews HS/1 3/4 18.0 131             76.3    
HK_1977_L006 1979-11-04-077-1200-Grass 03 12 13 K H Au M C Tam H/H 5.9 126             76.0    
HK_1977_L021 1979-11-04-077-1200-Grass 02 9 22 C L Ng A K Cheam H 3.3 138             76.0    
HK_1977_L062 1979-11-04-077-1200-Grass 05 13 13 J H Brown W P Hung 4 1/4 78.0 122             76.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]);