賽馬數據
HKJC Barrier Trials
Hong Kong barrier trial results, times and running comments
hkjc_barrier_trials
行數
10,222
涵蓋期間
2025年5月至2026年9月
欄位數目
32
最新數據
2026-09-29
樣本
| 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-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 1 | TITAN PEGASUS | L213 | HK_2025_L213 | C L Chau | D Eustace | 7 | — | 3 3 1 | 1.11.25 | Racing in a tractable manner; shifted to the inside in the Straight; dashed along under his own steam. | 24.7 | 23.8 | 22.7 | — | 3 | 3 | 1 | — | 2026-10-01 01:07:25.144000 | 3ecfea2c479e0c78b7bc45a95d1100c5 | |||
| 2026-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 2 | KINGDOM | L366 | HK_2025_L366 | C Y Ho | C Fownes | 3 | — | 1/2L | 1 1 2 | 1.11.34 | Led early; stayed on comfortably in the Straight. | 24.7 | 23.8 | 22.7 | — | 1 | 1 | 2 | — | 2026-10-01 01:07:25.144000 | d365ef4d851b689dc611da0bc9911e9c | ||
| 2026-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 3 | WINNING WING | K129 | HK_2024_K129 | M L Yeung | K W Lui | 4 | — | 3/4L | 7 7 3 | 1.11.37 | Shifted out at turn; hard ridden for 3rd. | 24.7 | 23.8 | 22.7 | — | 7 | 7 | 3 | — | 2026-10-01 01:07:25.144000 | 4b1d16ed11d533feae2514de00c505de | ||
| 2026-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 4 | JUBILANT WINNER | J346 | HK_2023_J346 | P N Wong | J Richards | 8 | — | 1-1/2L | 2 2 4 | 1.11.48 | On pace without cover; ran on when asked in the Straight. | 24.7 | 23.8 | 22.7 | — | 2 | 2 | 4 | — | 2026-10-01 01:07:25.144000 | c9a08f285fcde4ee40973dc8c3ac6e5d | ||
| 2026-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 5 | REFUSETOBEENGLISH | K362 | HK_2024_K362 | K C Leung | P C Ng | 2 | B | Blinkers | 3L | 8 8 5 | 1.11.74 | Slightly slow to begin; stayed on well when hard ridden at 300m. | 24.7 | 23.8 | 22.7 | — | 8 | 8 | 5 | — | 2026-10-01 01:07:25.144000 | b8c6b03f6cd6984f6aeed434b2104b3f | |
| 2026-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 6 | SKY DEEP | K041 | HK_2024_K041 | E C W Wong | C Fownes | 1 | V/XB | Visor / Crossed Nose Band | 4L | 5 4 6 | 1.11.90 | Saved ground throughout; limited response when asked in the Straight. | 24.7 | 23.8 | 22.7 | — | 5 | 4 | 6 | — | 2026-10-01 01:07:25.144000 | c37e15c02bc8554caa817a35fc71425f | |
| 2026-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 7 | COOL BOY | L014 | HK_2025_L014 | A Badel | J Richards | 6 | — | 6L | 4 5 7 | 1.12.21 | Ran on ordinary when persuaded in the Straight. | 24.7 | 23.8 | 22.7 | — | 4 | 5 | 7 | — | 2026-10-01 01:07:25.144000 | 5907d094a175e77579ed92e8bb536402 | ||
| 2026-09-29 | SHA TIN | ALL WEATHER TRACK | 1200 | 1 | GOOD | 1.11.25 | 24.7 23.8 22.7 | 8 | ENSUED | H452 | HK_2022_H452 | A Atzeni | J Size | 5 | PC | Pacifiers with Cowls | 6-1/2L | 6 6 8 | 1.12.30 | Hard ridden in the Straight; needs further. | 24.7 | 23.8 | 22.7 | — | 6 | 6 | 8 | — | 2026-10-01 01:07:25.144000 | fb9a0ceaebe2201b48d32e5431052d3a |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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.
免費
下載樣本