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

5 rows where raceid = "1979-10-03-021-1030-Sand"

View and edit SQL

Suggested facets: lengthbehindwinner

Link horseid raceid place draw rating trainer jockey lengthbehindwinner winodds actualweight position1 position2 position3 position4 position5 position6 finishtime declaredweight gear
HK_1975_Z070 1979-10-03-021-1030-Sand 03 3 87 E Collingwood W Hood 7 2.6 139             68.4    
HK_1977_L141 1979-10-03-021-1030-Sand 02 2 83 G Moore G W Moore 3 3.8 135             67.6    
HK_1978_M054 1979-10-03-021-1030-Sand 05 4 76 G Sofronoff A K Cheam 14 2.7 128             69.5    
HK_1978_M125 1979-10-03-021-1030-Sand 01 5 71 R Burns P Miers 3 7.2 123             67.2    
HK_1979_N094 1979-10-03-021-1030-Sand 04 1 81 S T Wong D Brosnan 10 16.0 133             68.9    

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