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

7 rows where raceid = "1980-04-30-392-1650-Sand"

View and edit SQL

Suggested facets: rating, lengthbehindwinner

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1972_F057 1980-04-30-392-1650-Sand 03 2 30 P M Chu P Leyshan 6 3/4 7.2 130             108.9    
HK_1975_Z085 1980-04-30-392-1650-Sand 05 3 25 P C Kan K L Tsui 14 1/4 5.1 120             110.3    
HK_1976_K053 1980-04-30-392-1650-Sand 06 7 25 T C Cheng R Setches 17 1/4 8.5 125             110.8    
HK_1977_L027 1980-04-30-392-1650-Sand 02 6 35 K H Au H M Lee 1 3/4 5.2 135             108.0    
HK_1977_L034 1980-04-30-392-1650-Sand 04 5 30 G Sofronoff K W Lui 11 1/4 25.0 127             109.7    
HK_1978_M095 1980-04-30-392-1650-Sand 01 1 34 R Burns P Miers 1 3/4 2.4 134             107.8    
HK_1978_M123 1980-04-30-392-1650-Sand 07 4 29 G Smyth R Wernham 30 3/4 8.6 129             113.4    

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