賽馬數據
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
樣本
| horse_id | race_date | race_number | race_index | race_id | horse_name | horse_number | finishing_position | non_starter | result_status | result_status_label | finishing_time_seconds | finishing_time | margin | margin_lengths | draw | odds | venue_code | venue | surface_type | course_config | distance | distance_category | race_name | race_class | track_condition | field_size | jockey | jockey_allowance | trainer | owner | horse_colour | horse_sex | horse_age | horse_origin | import_type | import_date | declared_horse_weight | sire | dam | dam_sire | is_winner | is_top_three | dead_heat | weight | gear | gear_label | total_stakes | season_stakes | no_of_starts | career_wins | career_seconds | career_thirds | career_total_starts | career_win_rate | race_url | video_replay_url | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HK_2025_L317 | 2026-11-14 00:00:00 | 1 | ST_20261114_R01 | EVER WEALTH | — | 0 | true | — | — | — | — | — | — | — | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | — | P F Yiu | Arthur Wong Chun Mo | Bay | Gelding | 3 | AUS | PPG | 2025-12-23 00:00:00 | — | All Too Hard | Its Time For Magic | Per Incanto | 0 | 0 | false | 121 | B-/V1 | Blinkers (removed) / Visor (1st time) | 237500.0 | 0.0 | 0-0-2-5 | 0 | 0 | 2 | 5 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | 1d3b0f5ee42089022e6f52aad83c3074 | |||
| HK_2025_L308 | 2026-11-14 00:00:00 | 1 | ST_20261114_R01 | SHARP PLANET | — | 0 | true | — | — | — | — | — | — | — | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | — | C Fownes | Yiu King Chuen, Chino Yiu Chin Hang & Chris Yiu Chun Hang | Bay | Gelding | 3 | IRE | PPG | 2025-12-20 00:00:00 | — | Starspangledbanner | Onyali | Rip Van Winkle | 0 | 0 | false | 122 | B/TT | Blinkers / Tongue Tie | 218500.0 | 0.0 | 0-1-0-4 | 0 | 1 | 0 | 4 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | b0ad90b1182d7a44c7b25abc1910c2a0 | |||
| HK_2025_L438 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | SECRET HEDGE | 12 | 1 | false | PLACED | Finished | 69.18 | 1:09.18 | --- | — | 14 | 34.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | M Chadwick | — | J Size | Idon Pong Wai Ning | Brown | Gelding | 3 | AUS | PPG | 2026-03-24 00:00:00 | 1128 | Brutal | Commanding Epic | Commands | 1 | 1 | false | 125 | P1 | Pacifiers (1st time) | 655200.0 | 655200.0 | 1-0-0-1 | 1 | 0 | 0 | 1 | 1.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | 6d063ff306864ac0a7151a23c754d897 |
| HK_2026_M046 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | HAPPY PEGASUS | 2 | 2 | false | PLACED | Finished | 69.33 | 1:09.33 | 1 | 1.0 | 13 | 2.4 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | C L Chau | 2 | C S Shum | Jackson Wang Dong Ying & Julia Zhang Yu Ling | Bay | Gelding | 3 | AUS | PPG | 2026-07-06 00:00:00 | 1171 | Hanseatic | Split Lip | Your Song | 0 | 1 | false | 131 | TT | Tongue Tie | 900900.0 | 900900.0 | 1-1-0-2 | 1 | 1 | 0 | 2 | 0.5 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | 6f8b41119f39ab5625ff1d3e99dc6033 |
| HK_2025_L388 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | I WIN I WIN | 8 | 3 | false | PLACED | Finished | 69.34 | 1:09.34 | 1 | 1.0 | 3 | 8.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | L Ferraris | — | D Eustace | Willie Leung Yiu Chung | Bay | Gelding | 3 | AUS | PPG | 2026-01-28 00:00:00 | 1153 | Pinatubo | Queen Himiko | Real Impact | 0 | 1 | false | 125 | XB1 | Crossed Nose Band (1st time) | 134550.0 | 134550.0 | 0-0-1-1 | 0 | 0 | 1 | 1 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | 9ec23e0a7b44f7657d6348059e1e890f |
| HK_2026_M008 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | DA DA DA | 4 | 4 | false | PLACED | Finished | 69.67 | 1:09.67 | 3 | 3.0 | 9 | 18.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | A Atzeni | — | M Newnham | Patrick Law Fu Yuen | Bay | Gelding | 3 | AUS | PPG | 2026-06-01 00:00:00 | 1135 | Yes Yes Yes | Dubrovnik | Medaglia d'Oro | 0 | 0 | false | 125 | — | 70200.0 | 70200.0 | 0-0-0-1 | 0 | 0 | 0 | 1 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | 9acc014f48308b94f4d958c4dd35d2c4 | |
| HK_2025_L509 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | SAINT JOSE PATCH | 11 | 5 | false | PLACED | Finished | 69.76 | 1:09.76 | 3-3/4 | 3.75 | 8 | 5.4 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | E C W Wong | 3 | K L Man | Lam Wai Ying | Bay | Gelding | 3 | AUS | PPG | 2026-05-28 00:00:00 | 1236 | Home Affairs | Mystical Pursuit | Needs Further | 0 | 0 | false | 122 | — | 286650.0 | 286650.0 | 0-1-0-2 | 0 | 1 | 0 | 2 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | 941ebe738da47d1ed06a5077d82efc1d | |
| HK_2025_L245 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | ALMIGHTY WARRIOR | 1 | 6 | false | PLACED | Finished | 69.91 | 1:09.91 | 4-1/2 | 4.5 | 2 | 8.1 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | Z Purton | — | K W Lui | Anthony Chung On Leung | Bay | Gelding | 3 | IRE | PPG | 2025-11-01 00:00:00 | 928 | Saxon Warrior | One Last Look | Fastnet Rock | 0 | 0 | false | 133 | XB | Crossed Nose Band | 922700.0 | 157950.0 | 1-1-1-6 | 1 | 1 | 1 | 6 | 0.1667 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://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/local | 2026-11-14 22:10:54 | 1333a26d56b7d3a493e0466db43d894e |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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
取得此數據表的方式
免費樣本
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 的付款頁面只提供英文版本。