跳至內容

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

賽馬數據

HKJC Race Results (Core)

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

Hong Kong horse racing results and form guide (core columns)

hkjc_race_results_core

Results

377,703

涵蓋期間

1977年5月至2026年11月

欄位數目

59

最新數據

2026-11-14

樣本

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

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

亦提供 壓縮 CSV 檔, JSON 格式

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

欄位

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

查詢數據

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

SELECT * FROM renavon_exports.hkjc_race_results_core LIMIT 10

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

取得此數據表的方式

免費樣本

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.

免費

下載樣本

Racing Pass Pro

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

US$1,490/年

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

訂閱 Racing Pass Pro

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

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

查看所有價格