賽馬數據
HKJC Sectional Times
分段時間收錄183,221筆記錄,資料來自香港賽馬會公布的分段時間,涵蓋2008年4月至2026年11月,每日更新。
Hong Kong horse racing sectional times and pace analysis
hkjc_sectional_times
行數
183,221
涵蓋期間
2008年4月至2026年11月
欄位數目
45
最新數據
2026-11-14
樣本
| horse_id | race_date | race_id | horse_name | horse_number | race_year | race_month | day_of_week | finishing_position | num_sections | section_1_time | section_2_time | section_3_time | section_4_time | section_5_time | section_6_time | position_1 | position_2 | position_3 | position_4 | position_5 | position_6 | lbw_1 | lbw_2 | lbw_3 | lbw_4 | lbw_5 | lbw_6 | first_section_time | first_section_position | first_section_lbw | final_section_time | final_section_position | final_section_lbw | mid_section_time | mid_section_position | led_early | closed_strongly | consistent_position | wire_to_wire | has_sectional_data | has_multi_section_data | has_comprehensive_sections | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HK_2026_M134 | 2026-11-14 00:00:00 | ST_20261114_R05 | GREEN SUPERSTAR | 9 | 2026 | 11 | 6 | 2 | 3 | — | — | — | 13.66 | 20.84 | 22.98 | — | — | — | 13 | 12 | 2 | — | — | — | 4-1/4 | 3-1/4 | N | — | — | — | 22.98 | 2 | N | 13.66 | 13 | — | — | — | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | e4e9969ed100f28ceab3d2f40adac698 |
| HK_2026_M117 | 2026-11-14 00:00:00 | ST_20261114_R01 | MAJESTICUS | 9 | 2026 | 11 | 6 | 11 | 3 | — | — | — | 23.87 | 22.68 | 24.14 | — | — | — | 4 | 4 | 11 | — | — | — | 1-3/4 | 3 | 9-1/2 | — | — | — | 24.14 | 11 | 9-1/2 | 23.87 | 4 | — | — | — | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | c87761c41cb9cb4d0e9847ceb4a731d7 |
| HK_2026_M112 | 2026-11-14 00:00:00 | ST_20261114_R05 | BAMBOO COPTER | 4 | 2026 | 11 | 6 | 7 | 3 | — | — | — | 13.26 | 21.12 | 23.52 | — | — | — | 8 | 11 | 7 | — | — | — | 1-3/4 | 2-1/2 | 2-3/4 | — | — | — | 23.52 | 7 | 2-3/4 | 13.26 | 8 | — | — | — | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | abc33fa5e7d40618beba63948d0653b9 |
| HK_2026_M088 | 2026-11-14 00:00:00 | ST_20261114_R01 | HARMONY N JOY | 6 | 2026 | 11 | 6 | 10 | 3 | — | — | — | 25.51 | 22.52 | 22.64 | — | — | — | 14 | 14 | 10 | — | — | — | 12 | 12-1/4 | 9-1/4 | — | — | — | 22.64 | 10 | 9-1/4 | 25.51 | 14 | — | — | — | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | aa953da2d6ea7a3aac315e9499037084 |
| HK_2026_M068 | 2026-11-14 00:00:00 | ST_20261114_R05 | YEE CHEONG BRIGHT | 2 | 2026 | 11 | 6 | 3 | 3 | — | — | — | 13.10 | 20.88 | 23.57 | — | — | — | 4 | 1 | 3 | — | — | — | 3/4 | N | 3/4 | — | — | — | 23.57 | 3 | 3/4 | 13.10 | 4 | — | — | — | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | bb847cb161876b89e1c25954932623bc |
| HK_2026_M066 | 2026-11-14 00:00:00 | ST_20261114_R11 | MONOPOLISTIC | 1 | 2026 | 11 | 6 | 9 | 4 | — | — | 25.11 | 22.97 | 23.91 | 23.70 | — | — | 6 | 5 | 5 | 9 | — | — | 2 | 3 | 1-1/2 | 5-1/4 | 25.11 | 6 | 2 | 23.70 | 9 | 5-1/4 | 22.97 | 5 | 0 | 0 | 0 | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | be7f14f006a41763b3f30dbe851564b3 |
| HK_2026_M065 | 2026-11-14 00:00:00 | ST_20261114_R11 | BEAUTY SWIFT | 4 | 2026 | 11 | 6 | 12 | 4 | — | — | 24.91 | 23.05 | 24.03 | 24.41 | — | — | 4 | 4 | 4 | 12 | — | — | 3/4 | 2-1/4 | 1-1/2 | 9-3/4 | 24.91 | 4 | 3/4 | 24.41 | 12 | 9-3/4 | 23.05 | 4 | 0 | 0 | 0 | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | 9cfca8fa1dec84314d3879ba06e49a03 |
| HK_2026_M060 | 2026-11-14 00:00:00 | ST_20261114_R05 | HIGHLAND CROSS | 7 | 2026 | 11 | 6 | 13 | 3 | — | — | — | 13.14 | 21.08 | 24.78 | — | — | — | 5 | 8 | 13 | — | — | — | 1 | 1-1/2 | 9-3/4 | — | — | — | 24.78 | 13 | 9-3/4 | 13.14 | 5 | — | — | — | 0 | true | 1 | 1 | 2026-11-14 22:10:54 | 5c20cf3024d5ac708c1cef925faa7858 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| horse_id | text | Unique horse identifier (canonical HK_YYYY_XXXX format) |
| race_date | date and time | Date of the race (YYYY-MM-DD) |
| race_id | text | Race identifier (format: ST_20250928_R01) |
| horse_name | text | Horse's name in English |
| horse_number | number | Horse's saddle number in the race |
| race_year | number | Year of the race |
| race_month | number | Month of the race (1-12) |
| day_of_week | number | Day of week (1=Monday, 7=Sunday) |
| finishing_position | number | Final finishing position (numeric) |
| num_sections | number | Number of sectional time segments (3-6 depending on distance) |
| section_1_time | text | Time for first 400m section in seconds |
| section_2_time | text | Time for second 400m section in seconds |
| section_3_time | text | Time for third 400m section in seconds |
| section_4_time | text | Time for fourth 400m section in seconds |
| section_5_time | text | Time for fifth 400m section in seconds |
| section_6_time | text | Time for sixth 400m section in seconds (longer races only) |
| position_1 | text | Running position in field 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 |
| 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 |
| first_section_time | text | Time for first populated section (coalesce of section 1/2/3) |
| first_section_position | text | Position at first checkpoint |
| first_section_lbw | text | Lengths behind leader at first checkpoint |
| final_section_time | text | Time for final section |
| final_section_position | text | Position at final checkpoint before finish |
| final_section_lbw | text | Lengths behind leader at final checkpoint |
| mid_section_time | text | Time for middle section (if 3+ sections) |
| mid_section_position | text | Position at middle checkpoint |
| led_early | number | True if horse led at first checkpoint (position_1 = 1) |
| closed_strongly | number | True if horse improved position from first to final section |
| consistent_position | number | True if position changed by 2 or less from start to finish |
| wire_to_wire | number | True if horse led at first checkpoint AND won the race |
| has_sectional_data | yes/no | True if sectional data is available |
| has_multi_section_data | number | True if multiple sections are available |
| has_comprehensive_sections | number | True if 3+ sections are available |
| updated_at | date and time | Timestamp when record was last scraped |
| 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_sectional_times LIMIT 10
取得此數據表的方式
免費樣本
Last 6 months of sectional times — same races as the race_results sample so buyers can join the two and see how the data lines up.
免費
下載樣本Racing Pass Pro
滾動 24 個月期間,現時由2024年11月起另包含 13 個數據表
US$1,490/年
按年收費 · 或每月 US$149 Racing Pass Pro
訂閱 Racing Pass Pro價格及付款程序均由 Renavon 全權處理,駿眼並不經手有關付款。
Renavon 的付款頁面只提供英文版本。