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

12 rows where raceid = "1979-10-20-050-1650-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_1976_K022 1979-10-20-050-1650-Grass 12 9 102 F Carr S Morris 16 21.0 133             103.3    
HK_1976_K035 1979-10-20-050-1650-Grass 01 5 95 G Moore G W Moore 1 1/2 1.7 131             100.8    
HK_1977_L087 1979-10-20-050-1650-Grass 05 8 98 H M Cheung R Staples 6 3/4 99.0 134             101.8    
HK_1977_L151 1979-10-20-050-1650-Grass 08 4 85 G Sofronoff D C Cruz 10 3/4 99.0 121             102.4    
HK_1977_L159 1979-10-20-050-1650-Grass 10 12 88 P C Kan R Setches 11 1/2 32.0 124             102.6    
HK_1977_L175 1979-10-20-050-1650-Grass 04 11 95 A Chan K S Ho 3 1/4 15.0 131             101.3    
HK_1977_L180 1979-10-20-050-1650-Grass 07 2 89 G Smyth R Wernham 8 1/2 99.0 125             102.1    
HK_1978_M160 1979-10-20-050-1650-Grass 06 1 87 A Chan J Tandari 7 1/2 17.0 123             101.9    
HK_1978_M176 1979-10-20-050-1650-Grass 09 10 99 P M Chu C C Chan 11 1/2 99.0 135             102.5    
HK_1978_M180 1979-10-20-050-1650-Grass 02 6 87 E Collingwood W Hood 1 1/2 5.5 123             101.0    
HK_1978_M200 1979-10-20-050-1650-Grass 03 3 85 R Burns P Miers 1 1/2/N 5.7 121             101.0    
HK_1978_M207 1979-10-20-050-1650-Grass 11 7 90 G Sofronoff K W Lui 12 3/4 18.0 123             102.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]);