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

9 rows where raceid = "1980-01-05-184-1600-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_1971_Z012 1980-01-05-184-1600-Grass 06 5 6 H M Cheung W T Leung 2 3/4 6.0 122             100.3    
HK_1972_F001 1980-01-05-184-1600-Grass 02 1 15 P Supple B Andrews 1/2 4.4 131             100.0    
HK_1972_F018 1980-01-05-184-1600-Grass 09 4 13 R Burns P Miers 3 3/4 14.0 129             100.5    
HK_1972_F055 1980-01-05-184-1600-Grass 03 6   R Burns L Fox 2 14.0 127             100.2    
HK_1974_Z036 1980-01-05-184-1600-Grass 08 2 12 M K Tam T O Lau 3 3/4 14.0 128             100.5    
HK_1976_K087 1980-01-05-184-1600-Grass 07 7 15 A Chan P Paquet 2 3/4 7.0 131             100.3    
HK_1977_L016 1980-01-05-184-1600-Grass 01 9 20 C L Ng K L Tsui 1/2 2.9 129             99.9    
HK_1977_L027 1980-01-05-184-1600-Grass 05 3 15 K H Au Y K Lau 2 1/4 10.0 131             100.2    
HK_1977_L062 1980-01-05-184-1600-Grass 04 8 8 J H Brown W P Hung 2/H 31.0 117             100.2    

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