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

9 rows where raceid = "1979-10-10-038-1575-Sand"

View and edit SQL

Suggested facets: rating, actualweight

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1973_G023 1979-10-10-038-1575-Sand 04 1 25 K H Au M C Tam 14 1/2 11.0 120             109.6    
HK_1974_Z020 1979-10-10-038-1575-Sand 08 8 26 J H Brown P Leyshan 21 3/4 6.8 126             110.9    
HK_1974_Z029 1979-10-10-038-1575-Sand 07 5 33 H M Cheung W T Leung 19 3/4 25.0 133             110.5    
HK_1974_Z047 1979-10-10-038-1575-Sand 05 7 29 G Smyth P H Chan 16 1/2 94.0 122             110.0    
HK_1974_Z049 1979-10-10-038-1575-Sand 06 2 31 G Sofronoff D Brosnan 18 1/4 18.0 131             110.3    
HK_1975_Z071 1979-10-10-038-1575-Sand 09 3 29 R Burns P Miers 23 1/4 9.0 129             111.2    
HK_1976_K046 1979-10-10-038-1575-Sand 01 4 33 G Moore G W Moore 4 3.5 133             107.8    
HK_1976_K053 1979-10-10-038-1575-Sand 03 6 34 P C Kan R Setches 8 2.2 134             108.5    
HK_1976_K054 1979-10-10-038-1575-Sand 02 9 22 C L Ng C C Nam -- 27.0 115             107.1    

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