跳至內容

駿眼統計為獨立資訊服務,與香港賽馬會並無任何關聯、認可或授權關係。

賽馬數據

HKJC Race Results

賽果收錄377,703筆賽果記錄,資料來自香港賽馬會公布的賽果,涵蓋1977年5月至2026年11月,每小時更新。

Hong Kong horse racing results and historical form guide

hkjc_race_results

Results

377,703

涵蓋期間

1977年5月至2026年11月

欄位數目

91

最新數據

2026-11-14

樣本

顯示 8 行
HKJC Race Results: 樣本
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

兩者均可直接用試算表開啟。

亦提供 壓縮 CSV 檔, JSON 格式

對此數據表有疑問?歡迎查詢。 (在新分頁開啟)

欄位

91
HKJC Race Results: 欄位
欄位名稱 類型 說明
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.

查詢數據

每個數據表均可透過 Renavon 帳戶,以 SQL、API 或 AI 助理查詢。

SELECT * FROM renavon_exports.hkjc_race_results LIMIT 10

在 renavon.com 取得金鑰 (在新分頁開啟)

取得此數據表的方式

免費樣本

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.

免費

下載樣本

一次性存檔

1977年5月7日至今 · 不會更新

US$299

購買存檔 Race Results

Racing Pass Pro

滾動 24 個月期間,現時由2024年11月起另包含 13 個數據表

US$1,490/年

按年收費 · 或每月 US$149 Racing Pass Pro

訂閱 Racing Pass Pro

價格及付款程序均由 Renavon 全權處理,駿眼並不經手有關付款。

Renavon 的付款頁面只提供英文版本。

查看所有價格