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

12 rows where raceid = "1979-11-10-090-1200-Grass"

View and edit SQL

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

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1971_Z014 1979-11-10-090-1200-Grass 11 10 15 P C Kan S M Au-Yeung 14 3/4 28.0 124             76.3    
HK_1972_F001 1979-11-10-090-1200-Grass 08 8 17 P Supple W Burnett 10 20.0 133             75.6    
HK_1972_F018 1979-11-10-090-1200-Grass 06 7 15 R Burns P Miers 9 3/4 11.0 131             75.5    
HK_1973_G002 1979-11-10-090-1200-Grass 12 1 15 F Carr J Roe 16 3/4 74.0 131             76.7    
HK_1974_Z030 1979-11-10-090-1200-Grass 05 2 9 E Collingwood C Roche 7 3/4 8.6 125             75.2    
HK_1974_Z036 1979-11-10-090-1200-Grass 10 9 16 M K Tam L Fox 10 1/4 5.4 132             75.6    
HK_1975_Z067 1979-11-10-090-1200-Grass 09 4 18 K H Au H M Lee 10 6.9 134             75.6    
HK_1975_Z121 1979-11-10-090-1200-Grass 01 11 24 C L Ng A K Cheam 1 1/2 9.7 140             74.1    
HK_1976_K087 1979-11-10-090-1200-Grass 03 5 16 A Chan Y S Wong 6 1/2 12.0 125             75.0    
HK_1976_K101 1979-11-10-090-1200-Grass 04 6 7 T C Cheng R Staples 7 1/4 9.9 123             75.1    
HK_1977_L027 1979-11-10-090-1200-Grass 07 3 18 K H Au M C Tam 9 3/4 11.0 131             75.5    
HK_1977_L041 1979-11-10-090-1200-Grass 02 12 21 S T Wong D Brosnan 1 1/2 4.5 137             74.3    

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