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

11 rows where raceid = "1980-02-09-255-1650-Grass"

View and edit SQL

Suggested facets: rating, trainer, lengthbehindwinner, actualweight

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1972_F023 1980-02-09-255-1650-Grass 09 2 61 K H Au P Paquet 16 16.0 129             111.9    
HK_1976_K043 1980-02-09-255-1650-Grass 03 5 61 G Sofronoff P Leyshan 3 11.0 129             109.5    
HK_1976_K048 1980-02-09-255-1650-Grass 05 6 55 T L Lee K L Tsui 6 3/4 3.4 118             110.2    
HK_1976_K093 1980-02-09-255-1650-Grass 01 7 52 G Moore G W Moore 2 12.0 120             109.0    
HK_1976_K109 1980-02-09-255-1650-Grass 04 3 69 C L Ng P H Chan 4 1/4 10.0 130             109.7    
HK_1978_M028 1980-02-09-255-1650-Grass 10 11 56 A Chan T O Lau 16 3/4 37.0 124             112.1    
HK_1978_M055 1980-02-09-255-1650-Grass 02 4 55 B Hutchison P Miers 2 5.4 123             109.3    
HK_1978_M089 1980-02-09-255-1650-Grass 08 8 52 A Chan P Robinson 10 1/2 45.0 120             110.9    
HK_1978_M096 1980-02-09-255-1650-Grass 06 9 66 A Ward B Andrews 9 1/4 7.3 134             110.7    
HK_1978_M117 1980-02-09-255-1650-Grass 07 1 61 C L Ng C C Nam 9 3/4 22.0 122             110.8    
HK_1978_M231 1980-02-09-255-1650-Grass 11 10 62 T C Cheng Y P Chan 23 1/4 5.6 125             113.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]);