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 (Core)

HKJC Race Results (Core) 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 form guide (core columns)

hkjc_race_results_core

Results

377,703

Coverage

May 1977 to November 2026

Columns

59

Latest data

2026-11-14

Sample

8 rows shown
HKJC Race Results (Core): Sample
horse_idrace_daterace_numberrace_indexrace_idhorse_namehorse_numberfinishing_positionnon_starterresult_statusresult_status_labelfinishing_time_secondsfinishing_timemarginmargin_lengthsdrawoddsvenue_codevenuesurface_typecourse_configdistancedistance_categoryrace_namerace_classtrack_conditionfield_sizejockeyjockey_allowancetrainerownerhorse_colourhorse_sexhorse_agehorse_originimport_typeimport_datedeclared_horse_weightsiredamdam_sireis_winneris_top_threedead_heatweightgeargear_labeltotal_stakesseason_stakesno_of_startscareer_winscareer_secondscareer_thirdscareer_total_startscareer_win_raterace_urlvideo_replay_urlupdated_atid
HK_2025_L3172026-11-14 00:00:001ST_20261114_R01EVER WEALTH—0true———————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14—P F YiuArthur Wong Chun MoBayGelding3AUSPPG2025-12-23 00:00:00—All Too HardIts Time For MagicPer Incanto00false121B-/V1Blinkers (removed) / Visor (1st time)237500.00.00-0-2-500250.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:541d3b0f5ee42089022e6f52aad83c3074
HK_2025_L3082026-11-14 00:00:001ST_20261114_R01SHARP PLANET—0true———————STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14—C FownesYiu King Chuen, Chino Yiu Chin Hang & Chris Yiu Chun HangBayGelding3IREPPG2025-12-20 00:00:00—StarspangledbannerOnyaliRip Van Winkle00false122B/TTBlinkers / Tongue Tie218500.00.00-1-0-401040.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:54b0ad90b1182d7a44c7b25abc1910c2a0
HK_2025_L4382026-11-14 00:00:001187ST_20261114_R01SECRET HEDGE121falsePLACEDFinished69.181:09.18---—1434.0STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14M Chadwick—J SizeIdon Pong Wai NingBrownGelding3AUSPPG2026-03-24 00:00:001128BrutalCommanding EpicCommands11false125P1Pacifiers (1st time)655200.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.4STSha 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 Tie900900.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.0STSha 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)134550.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.0STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14A Atzeni—M NewnhamPatrick Law Fu YuenBayGelding3AUSPPG2026-06-01 00:00:001135Yes Yes YesDubrovnikMedaglia d'Oro00false125—70200.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.4STSha TinTurfA1200SprintPANASONIC WATER DISPENSER HANDICAPClass 4 (Restricted)GOOD TO YIELDING14E C W Wong3K L ManLam Wai YingBayGelding3AUSPPG2026-05-28 00:00:001236Home AffairsMystical PursuitNeeds Further00false122—286650.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.1STSha 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 Band922700.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

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

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

Columns

59
HKJC Race Results (Core): Columns
Column Type Description
horse_id text Unique horse identifier (e.g., 'HK_2020_E403')
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_id text Unique race identifier (format: ST_20250928_R01)
horse_name text Horse's name in English
horse_number number Horse's saddle/barrier number for the race
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_seconds number Finishing time converted to total seconds
finishing_time text Finishing time (MM:SS.ss format)
margin text Margin from winner (lengths, head, neck, short head, etc.)
margin_lengths number Margin converted to numeric lengths
draw number Starting gate/barrier position (same as horse_number in HK flat racing)
odds number Win odds as a decimal number (e.g. 4.5 = 9/2)
venue_code text Venue code (ST/HV)
venue text Race venue (Sha Tin / Happy Valley)
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
distance number Race distance in meters (1000-2400m typical)
distance_category text Distance category (Sprint/Mile/Middle/Long)
race_name text Name of the race (e.g., 'FAT CHOI HANDICAP')
race_class text Race class (Class 1-5, Group 1/2/3, Griffin, etc.)
track_condition text Track going condition (Good/Good to Firm/Yielding/etc.)
field_size number Number of horses in the race
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
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)
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.
weight number Weight carried by the horse, in pounds (e.g. 126)
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.
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)
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_core 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 — the core columns (result, race specs, connections, form, career record). The premium sectional / in-running / pace columns are in the Pro dataset.

Free

Download the sample

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