Skip to content

HKJC Guru is an independent statistics service and is not affiliated with, endorsed by, or connected to The Hong Kong Jockey Club.

Racing data

HKJC Race Results

HKJC Race Results holds 377,703 results from the Hong Kong Jockey Club's published race results, covering May 1977 to November 2026, and is updated hourly.

Hong Kong horse racing results and historical form guide

hkjc_race_results

Results

377,703

Coverage

May 1977 to November 2026

Columns

91

Latest data

2026-11-14

Sample

8 rows shown
HKJC Race Results: Sample
horse_idrace_daterace_numberrace_indexrace_idhorse_namehorse_numberfinishing_positionnon_starterresult_statusresult_status_labelfinishing_time_secondsfinishing_timemarginmargin_lengthsdrawoddsposition_1position_2position_3position_4position_5position_6section_1_timesection_2_timesection_3_timesection_4_timesection_5_timesection_6_timelbw_1lbw_2lbw_3lbw_4lbw_5lbw_6split_800m_600m_timesplit_600m_400m_timesplit_400m_200m_timesplit_final_200m_timesplit_first_200m_timehas_opening_200m_segmentsection_1_vs_pacesection_2_vs_pacesection_3_vs_pacesection_4_vs_pacesection_5_vs_pacesection_6_vs_pacevenue_codevenuesurface_typecourse_configdistancedistance_categoryrace_namerace_classtrack_conditionfield_sizejockeyjockey_allowancetrainerownerhorse_colourhorse_sexhorse_agehorse_originimport_typeimport_datedeclared_horse_weightsiredamdam_sireis_winneris_top_threedead_heatweightgeargear_labelentry_ratingrating_typetotal_stakesseason_stakesno_of_startscareer_winscareer_secondscareer_thirdscareer_total_startscareer_win_raterace_urlvideo_replay_urlupdated_atid
HK_2025_L4382026-11-14 00:00:001187ST_20261114_R01SECRET HEDGE121falsePLACEDFinished69.181:09.18---—1434.0———871———24.4322.3622.39———5-1/44-1/2111.1111.2510.8611.53—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14M Chadwick—J SizeIdon Pong Wai NingBrownGelding3AUSPPG2026-03-24 00:00:001128BrutalCommanding EpicCommands11false125P1Pacifiers (1st time)52H655200.0655200.01-0-0-110011.0https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:546d063ff306864ac0a7151a23c754d897
HK_2026_M0462026-11-14 00:00:001187ST_20261114_R01HAPPY PEGASUS22falsePLACEDFinished69.331:09.3311.0132.4———552———24.1122.5622.66———3-1/43-3/4111.1511.4110.9811.68—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14C L Chau2C S ShumJackson Wang Dong Ying & Julia Zhang Yu LingBayGelding3AUSPPG2026-07-06 00:00:001171HanseaticSplit LipYour Song01false131TTTongue Tie60H900900.0900900.01-1-0-211020.5https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:546f8b41119f39ab5625ff1d3e99dc6033
HK_2025_L3882026-11-14 00:00:001187ST_20261114_R01I WIN I WIN83falsePLACEDFinished69.341:09.3411.038.0———983———24.5122.3222.51———5-3/44-3/4111.1111.2111.1411.37—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14L Ferraris—D EustaceWillie Leung Yiu ChungBayGelding3AUSPPG2026-01-28 00:00:001153PinatuboQueen HimikoReal Impact01false125XB1Crossed Nose Band (1st time)52H134550.0134550.00-0-1-100110.0https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:549ec23e0a7b44f7657d6348059e1e890f
HK_2026_M0082026-11-14 00:00:001187ST_20261114_R01DA DA DA44falsePLACEDFinished69.671:09.6733.0918.0———664———24.1922.4823.00———3-3/43-3/4311.1511.3311.111.9—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14A Atzeni—M NewnhamPatrick Law Fu YuenBayGelding3AUSPPG2026-06-01 00:00:001135Yes Yes YesDubrovnikMedaglia d'Oro00false125—52H70200.070200.00-0-0-100010.0https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:549acc014f48308b94f4d958c4dd35d2c4
HK_2025_L5092026-11-14 00:00:001187ST_20261114_R01SAINT JOSE PATCH115falsePLACEDFinished69.761:09.763-3/43.7585.4———115———23.5922.4823.69———3/41-1/43-3/411.1111.3711.3412.35—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14E C W Wong3K L ManLam Wai YingBayGelding3AUSPPG2026-05-28 00:00:001236Home AffairsMystical PursuitNeeds Further00false122—52H286650.0286650.00-1-0-201020.0https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:54941ebe738da47d1ed06a5077d82efc1d
HK_2025_L2452026-11-14 00:00:001187ST_20261114_R01ALMIGHTY WARRIOR16falsePLACEDFinished69.911:09.914-1/24.528.1———336———23.8722.4823.56———1-3/41-3/44-1/211.1111.3711.2612.3—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14Z Purton—K W LuiAnthony Chung On LeungBayGelding3IREPPG2025-11-01 00:00:00928Saxon WarriorOne Last LookFastnet Rock00false133XBCrossed Nose Band60H922700.0157950.01-1-1-611160.1667https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:541333a26d56b7d3a493e0466db43d894e
HK_2025_L4572026-11-14 00:00:001187ST_20261114_R01I AM THE WALRUS77falsePLACEDFinished69.991:09.9955.0127.7———227———23.7122.5623.72———3/41-1/4511.1511.4111.3412.38—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14K C Leung—P C NgAthy Ngai Sze YinChestnutGelding3AUSPPG2026-03-24 00:00:001092ZoustarPatricia DawnSebring00false125—52H40950.040950.00-0-0-200020.0https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:54f0187fa7763bc27b108cccd1b2b21098
HK_2025_L2442026-11-14 00:00:001187ST_20261114_R01SPICE BAG38falsePLACEDFinished70.31:10.3077.0527.0———12108———24.7922.4023.11———7-1/27711.0311.3711.0612.05—false——————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14J Orman—D J HallLai Wai Chi & Adrian Michael BellBayGelding3IREPPG2025-11-01 00:00:001123AcclamationWestern SafariHigh Chaparral00false130—57H551000.00.01-0-0-310030.3333https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local2026-11-14 22:10:547f42b74cf65b85a36e3eb57cbe34c241

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

Question about this table? Ask us. (opens in new tab)

Columns

91
HKJC Race Results: Columns
Column Type Description
race_id text Unique race identifier (format: ST_20250928_R01)
race_date date and time Date of the race (YYYY-MM-DD)
race_number number Race number within the meeting (1-11)
race_index text Original HKJC race identifier within the meeting (1-10). Use this for matching with external HKJC data sources. NULL for modern data (Sept 2025+).
race_name text Name of the race (e.g., 'FAT CHOI HANDICAP')
venue text Race venue (Sha Tin / Happy Valley)
venue_code text Venue code (ST/HV)
surface_type text Track surface type: 'Turf' or 'AWT' (All Weather Track)
course_config text Course configuration (A, B, C, C+3, etc.) - different track layouts at same venue
race_class text Race class (Class 1-5, Group 1/2/3, Griffin, etc.)
distance number Race distance in meters (1000-2400m typical)
distance_category text Distance category (Sprint/Mile/Middle/Long)
track_condition text Track going condition (Good/Good to Firm/Yielding/etc.)
field_size number Number of horses in the race
rating_type text Rating band for the race (H=Handicap, I=International)
horse_number number Horse's saddle/barrier number for the race
draw number Starting gate/barrier position (same as horse_number in HK flat racing)
finishing_position number Final finishing position (1, 2, 3, etc.). 0 for non-starters — see non_starter.
non_starter yes/no TRUE when the horse was entered but did not start the race (scratched, withdrawn, or a standby/reserve that never ran). For these rows finishing_position is not meaningful (0). Filter on non_starter = false for finishing-position calculations; keep them for withdrawal and pre-race analysis.
result_status text Result classification. 'PLACED' = a completed run with a numeric finishing_position (any position, not the racing sense of "placed in the money"). Codes present in the data: PU = pulled up (started, retired mid-race, no placing); WV = withdrawn on veterinary advice; WX = withdrawn (scratched before the race); WXNR = declared a non-runner. WV, WX and WXNR are non-runners (the horse did not start), so they are always flagged non_starter = true. non_starter = false therefore cleanly means the horse ran; for a set restricted to placed runners (excluding a PU or a future DISQ that ran but did not place) filter result_status = 'PLACED'. DISQ (disqualified) is decoded but does not yet appear: HKJC publishes disqualifications weeks after the race, after our re-scrape window closes, so the provisional placing stays frozen. When a DISQ is ingested the runner did start and HKJC renumbers the field, so finishing_position reflects the official result. See result_status_label for decoded wording. NULL for non-starters with no recorded code and entries with no outcome.
result_status_label text Human-readable form of result_status (Finished, Pulled Up, Withdrawn (Vet), Withdrawn, Non-runner; Disqualified once ingested). Unmapped codes pass through verbatim.
finishing_time text Finishing time (MM:SS.ss format)
finishing_time_seconds number Finishing time converted to total seconds
margin text Margin from winner (lengths, head, neck, short head, etc.)
margin_lengths number Margin converted to numeric lengths
odds number Win odds as a decimal number (e.g. 4.5 = 9/2)
weight number Weight carried by the horse, in pounds (e.g. 126)
section_1_time text Time for first section in seconds (e.g., '14.77')
section_2_time text Time for second section in seconds
section_3_time text Time for third section in seconds
section_4_time text Time for fourth section in seconds
section_5_time text Time for fifth section in seconds
section_6_time text Time for sixth section in seconds (longer races only)
position_1 text Running position at first checkpoint
position_2 text Running position at second checkpoint
position_3 text Running position at third checkpoint
position_4 text Running position at fourth checkpoint
position_5 text Running position at fifth checkpoint
position_6 text Running position at sixth checkpoint (longer races only)
lbw_1 text Lengths behind leader at first checkpoint (e.g., '2-1/4')
lbw_2 text Lengths behind leader at second checkpoint
lbw_3 text Lengths behind leader at third checkpoint
lbw_4 text Lengths behind leader at fourth checkpoint
lbw_5 text Lengths behind leader at fifth checkpoint
lbw_6 text Lengths behind leader at sixth checkpoint
split_800m_600m_time number Time in seconds for the 200m run between 800m-to-go and 600m-to-go (second-to-last 400m section, first half). Available from 12 November 2022. Blank for older races or those without sectional data.
split_600m_400m_time number Time in seconds for the 200m run between 600m-to-go and 400m-to-go (second-to-last 400m section, second half).
split_400m_200m_time number Time in seconds for the 200m run between 400m-to-go and 200m-to-go (final 400m section, first half).
split_final_200m_time number Time in seconds for the final 200m (finishing sprint). The single most-analyzed sectional metric in racing; lower is faster. Available from 12 November 2022 (when HKJC began publishing 200m sub-splits); also from April 2024 via the V2 spider.
split_first_200m_time number Time in seconds for the opening 200m from the gates. Four of the eight standard HK race distances (1000m / 1400m / 1800m / 2200m) open with a 200m section; the four multiples of 400m (1200 / 1600 / 2000 / 2400) open with 400m and have no opening 200m timing point. When the distance has no opening 200m, this column is NULL by design, not missing data — use has_opening_200m_segment to filter. Coverage back to 2013 for distances that have the timing point; this timing point has always been part of HKJC's published sectional data, only the column surfacing is new.
has_opening_200m_segment yes/no True when the race distance has an opening 200m timing point (1000m / 1400m / 1800m / 2200m). False for 400m-aligned distances (1200 / 1600 / 2000 / 2400) and Happy Valley 1650m, where split_first_200m_time is NULL by design. Use this to distinguish "no data possible at this distance" from "data missing for this race" when filtering or charting opening-pace metrics.
section_1_vs_pace number Difference between horse's section 1 time and race benchmark. Negative = faster than field average. Available for races with V2 sectional data (Jan 2026+).
section_2_vs_pace number Difference between horse's section 2 time and race benchmark. Negative = faster than field.
section_3_vs_pace number Difference between horse's section 3 time and race benchmark. Negative = faster than field.
section_4_vs_pace number Difference between horse's section 4 time and race benchmark. Negative = faster than field.
section_5_vs_pace number Difference between horse's section 5 time and race benchmark. Negative = faster than field.
section_6_vs_pace number Difference between horse's section 6 time and race benchmark. Negative = faster than field (longer races only).
horse_id text Unique horse identifier (e.g., 'HK_2020_E403')
horse_name text Horse's name in English
horse_colour text Horse's coat colour (Bay, Chestnut, Grey, etc.)
horse_sex text Horse's sex (G=Gelding, C=Colt, F=Filly, M=Mare, H=Horse)
horse_age number Horse's racing age in years on the date of this race (not its current age)
horse_origin text Country of origin (AUS, NZ, IRE, GB, etc.)
import_type text Import classification (PP, PPG, ISG, etc.)
import_date date and time Date imported to Hong Kong
declared_horse_weight number Horse's declared body weight before racing (in lbs, typically 1000-1200). Useful for tracking fitness/condition changes.
sire text Sire (father)
dam text Dam (mother)
dam_sire text Dam's sire (maternal grandfather)
jockey text Jockey name
jockey_allowance number Weight allowance for apprentice jockeys (0/2/5 lbs). NULL for historical races.
trainer text Trainer name
owner text Owner name
entry_rating number Horse's official HKJC rating at the time this race was run (1-144 scale). Resolved from race card and horse profile sources. Single authoritative rating per entry.
total_stakes number Total career prize money (HKD)
season_stakes number Current season prize money (HKD)
no_of_starts text Career record (format: wins-seconds-thirds-total)
career_wins number Career wins in Hong Kong
career_seconds number Career second places
career_thirds number Career third places
career_total_starts number Total career starts
career_win_rate number Career win percentage (0-1)
is_winner number True if horse won the race
is_top_three number True if horse finished in top 3 (excludes scratched entries)
dead_heat yes/no True if horse tied for position. FALSE by default for historical races.
gear text Equipment used (B=Blinkers, TT=Tongue Tie, H=Hood, SR=Shadow Roll, etc.). '--' means no gear. See gear_label for the decoded form.
gear_label text Equipment decoded to words, e.g. 'Visor (removed) / Blinkers (2nd time) / Tongue Tie'. 'No gear' where the raw code is '--'. Codes are HKJC's own (Equipment Register, racing.hkjc.com/en-us/local/page/reg-approved-gear); a trailing 1/2 means first/second time worn and a trailing '-' means removed this start. Unrecognised codes pass through unchanged.
race_url text Source URL for the race page
video_replay_url text Direct URL to watch race video replay for this specific horse
updated_at date and time Timestamp when record was last updated
id text Stable unique identifier for this row — the last column of every export. Use it to deduplicate, to key an incremental load, or to reference one specific row. It is additive: the entity and join keys you already use (race_id, horse_id, and the like) are unchanged.

Query it

Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.

SELECT * FROM renavon_exports.hkjc_race_results LIMIT 10

Get a key on renavon.com (opens in new tab)

Ways to get this table

Free sample

Last 12 months of race results across every meeting, full schema, no row cap. Includes the core columns and the Pro-only columns so buyers can see the full surface area.

Free

Download the sample

One-off archive

7 May 1977 to present · does not update

US$299

Buy the archive Race Results

Racing Pass Pro

A rolling 24-month window, currently from November 2024with 13 other tables

US$1,490/yr

billed yearly · or US$149/mo Racing Pass Pro

Subscribe to Racing Pass Pro

Prices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.

See all pricing