賽馬數據
HKJC Barrier Trials
試閘結果收錄11,397筆記錄,資料來自香港賽馬會公布的試閘結果,涵蓋2025年5月至2026年11月,每日更新。
Hong Kong barrier trial results, times and running comments
hkjc_barrier_trials
行數
11,397
涵蓋期間
2025年5月至2026年11月
欄位數目
32
最新數據
2026-11-13
樣本
| trial_date | venue | track | distance_m | batch_no | going | batch_winning_time | batch_sectional_time | finishing_position | horse | brand_code | horse_id | jockey | trainer | draw | gear | gear_label | lbw | running_position | horse_time | result | comment | batch_split_1_time | batch_split_2_time | batch_split_3_time | batch_split_4_time | split_1_position | split_2_position | split_3_position | split_4_position | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 1 | KA YING RISING | J062 | HK_2023_J062 | Z Purton | D A Hayes | 7 | — | 3 3 1 | 1.08.84 | Ridden conservatively early; shifted racing ground at 300m; won cozily. | 23.6 | 22.0 | 23.2 | — | 3 | 3 | 1 | — | 2026-11-15 00:25:36.404000 | 386f72e6a9795ee6cfed2d023535aa69 | |||
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 2 | HELIOS EXPRESS | H302 | HK_2022_H302 | A Atzeni | J Size | 6 | — | 1-1/4L | 6 6 2 | 1.09.05 | Shifted out at 300m; hard ridden for 2nd. | 23.6 | 22.0 | 23.2 | — | 6 | 6 | 2 | — | 2026-11-15 00:25:36.404000 | cc42916f4771b833c852312e1974a3a1 | ||
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 3 | LOVE TOGETHER | L052 | HK_2025_L052 | K Teetan | C Fownes | 4 | — | 1-3/4L | 5 4 3 | 1.09.11 | Ridden along at 200m; came from behind for 3rd. | 23.6 | 22.0 | 23.2 | — | 5 | 4 | 3 | — | 2026-11-15 00:25:36.404000 | 83096be78ad83ad6e47c5858d241b8e3 | ||
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 4 | PACKING GLORY | L013 | HK_2025_L013 | H Y Yuen | P F Yiu | 2 | B | Blinkers | 2L | 1 1 4 | 1.09.18 | Hit the front momentarily in the Straight; stretching out nicely when asked. | 23.6 | 22.0 | 23.2 | — | 1 | 1 | 4 | — | 2026-11-15 00:25:36.404000 | 68ba528aeb1a7bc1cdf9f3955f604371 | |
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 5 | LEADING ADVANTAGE | M039 | HK_2026_M039 | C Y Ho | P C Ng | 3 | — | 2-1/4L | 4 5 5 | 1.09.21 | Ridden along at turn; impressive. | 23.6 | 22.0 | 23.2 | — | 4 | 5 | 5 | — | 2026-11-15 00:25:36.404000 | 8768eddfcaedbaac8883dfe70e13f18d | ||
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 6 | RAGING BLIZZARD | H368 | HK_2022_H368 | B Avdulla | J Size | 8 | P | Pacifiers | 4-1/2L | 8 8 6 | 1.09.55 | Taken back early; swung wide at turn; raced under his own steam in the Straight. | 23.6 | 22.0 | 23.2 | — | 8 | 8 | 6 | — | 2026-11-15 00:25:36.404000 | bca89082d8025f9b38e8bc6827578852 | |
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 7 | GOLD PATCH | L099 | HK_2025_L099 | M L Yeung | W Y So | 1 | — | 5L | 2 2 7 | 1.09.66 | Led along the rail; weakened in the Straight. | 23.6 | 22.0 | 23.2 | — | 2 | 2 | 7 | — | 2026-11-15 00:25:36.404000 | e6b7843d5e1a3af3eb4d64e25292f1ed | ||
| 2026-11-13 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.08.84 | 23.6 22.0 23.2 | 8 | TOP DRAGON | J481 | HK_2023_J481 | J Orman | W Y So | 5 | CP | Sheepskin Cheek Pieces | 7-1/4L | 7 7 8 | 1.10.00 | Ran on ordinary; not back in condition. | 23.6 | 22.0 | 23.2 | — | 7 | 7 | 8 | — | 2026-11-15 00:25:36.404000 | 51fe93cd2ef173cc2effb5f282227a4d |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| trial_date | date | Date the barrier trial was run (YYYY-MM-DD) |
| venue | text | Trial venue — SHA TIN, CONGHUA or HAPPY VALLEY |
| track | text | Track surface used for the trial — TURF or ALL WEATHER TRACK |
| distance_m | number | Trial distance in metres (e.g. 1000, 1200, 1600) |
| batch_no | number | Batch (trial) number within the venue's session for that date |
| going | text | Going (track condition), e.g. GOOD, WET SLOW |
| batch_winning_time | text | Winning time for the batch as a whole, i.e. the time of the batch's fastest horse (M.SS.hh). The same for every runner in the batch — for this horse's own time, use horse_time. |
| batch_sectional_time | text | Section split times for the batch as a whole, in seconds, space-separated (e.g. '24.1 22.3 24.0'). The same for every runner in the batch. |
| batch_split_1_time | number | First section split time for the batch, in seconds (unpacked from batch_sectional_time). Same for every runner in the batch. |
| batch_split_2_time | number | Second section split time for the batch, in seconds (unpacked from batch_sectional_time). Same for every runner in the batch. |
| batch_split_3_time | number | Third section split time for the batch, in seconds (unpacked from batch_sectional_time). NULL if the batch had fewer than 3 splits. Same for every runner in the batch. |
| batch_split_4_time | number | Fourth section split time for the batch, in seconds (unpacked from batch_sectional_time). NULL if the batch had fewer than 4 splits. Same for every runner in the batch. |
| finishing_position | number | The order HKJC lists this horse in for the trial (1 = first across the line). Barrier trials are not officially placed, so this is the running order as published: horses that dead-heat appear as consecutive positions rather than sharing one. |
| horse | text | Horse's name in English |
| brand_code | text | Horse's HKJC brand number (e.g. H294) |
| horse_id | text | Canonical horse identifier (HK_YYYY_XXXX format) |
| jockey | text | Jockey who rode the horse in the trial |
| trainer | text | Horse's trainer |
| draw | number | Barrier (gate) draw number for the trial |
| gear | text | Equipment carried (HKJC gear codes, e.g. B = Blinkers, TT = Tongue Tie). 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. |
| lbw | text | Lengths behind winner (LBW) — distance behind the first-place finisher. Numeric margins carry an explicit unit suffix, e.g. '2L' (two lengths), '1/2L', '2-1/4L'. Sub-length margins are published as HKJC's abbreviations or words instead of a number: 'Neck', 'Head', 'Nose', 'SH' (short head). HKJC occasionally omits or mis-cases the 'L' at source; the unit is restored here so the numeric form is consistent, and the word margins are passed through as published. |
| running_position | text | Running positions through the trial, space-separated by section |
| split_1_position | number | This horse's running position at the first split (unpacked from running_position). NULL if the horse was withdrawn or did not finish. |
| split_2_position | number | This horse's running position at the second split (unpacked from running_position). NULL if the horse was withdrawn or did not finish. |
| split_3_position | number | This horse's running position at the third split (unpacked from running_position). NULL if the trial had fewer than 3 splits, or the horse was withdrawn/did not finish. |
| split_4_position | number | This horse's running position at the fourth split (unpacked from running_position). NULL if the trial had fewer than 4 splits, or the horse was withdrawn/did not finish. |
| horse_time | text | This horse's individual finishing time (M.SS.hh) |
| result | text | Trial result note (e.g. Passed for a qualifying trial), blank if none |
| comment | text | Stewards'/HKJC comment describing how the horse ran in the trial |
| updated_at | date and time | Timestamp this row was last (re)parsed into the warehouse |
| 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_barrier_trials LIMIT 10
取得此數據表的方式
免費樣本
Last 6 months of barrier trials — the same horses you will meet on the racecard, trialling before they run.
免費
下載樣本Racing Pass Pro
滾動 24 個月期間,現時由2024年11月起另包含 13 個數據表
US$1,490/年
按年收費 · 或每月 US$149 Racing Pass Pro
訂閱 Racing Pass Pro價格及付款程序均由 Renavon 全權處理,駿眼並不經手有關付款。
Renavon 的付款頁面只提供英文版本。