賽馬數據
HKJC Sectional Times
Hong Kong horse racing sectional times and pace analysis
hkjc_sectional_times
行數
179,172
涵蓋期間
2008年4月至2026年10月
欄位數目
45
最新數據
2026-10-01
樣本
| 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_2025_L519 | 2026-10-01 00:00:00 | ST_20261001_R11 | GLORYSPEED | 7 | 2026 | 10 | 4 | 4 | 3 | — | — | — | 24.47 | 21.78 | 22.45 | — | — | — | 10 | 8 | 4 | — | — | — | 5-3/4 | 4 | 1-1/2 | — | — | — | 22.45 | 4 | 1-1/2 | 24.47 | 10 | — | — | — | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | 14955aeb704e172d5bf982ed2103d7a1 |
| HK_2025_L514 | 2026-10-01 00:00:00 | ST_20261001_R10 | JOYFIELD | 2 | 2026 | 10 | 4 | 14 | 4 | — | — | 14.53 | 22.31 | 22.59 | 22.80 | — | — | 13 | 13 | 13 | 14 | — | — | 6-1/4 | 7-1/4 | 5-1/4 | 6-1/4 | 14.53 | 13 | 6-1/4 | 22.80 | 14 | 6-1/4 | 22.31 | 13 | 0 | 0 | 1 | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | 095eb154b21b563602528c359ed802a1 |
| HK_2025_L513 | 2026-10-01 00:00:00 | ST_20261001_R09 | BRAVEFIELD | 8 | 2026 | 10 | 4 | 11 | 4 | — | — | 14.04 | 21.95 | 23.00 | 22.79 | — | — | 11 | 12 | 12 | 11 | — | — | 4-1/4 | 6-1/2 | 5-3/4 | 7-1/4 | 14.04 | 11 | 4-1/4 | 22.79 | 11 | 7-1/4 | 21.95 | 12 | 0 | 0 | 1 | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | b74efd185ab765497e44501c9a9a5453 |
| HK_2025_L473 | 2026-10-01 00:00:00 | ST_20261001_R10 | LEATHER HERO | 11 | 2026 | 10 | 4 | 13 | 4 | — | — | 14.05 | 21.87 | 22.99 | 23.09 | — | — | 7 | 3 | 4 | 13 | — | — | 3-1/4 | 1-1/2 | 2 | 5 | 14.05 | 7 | 3-1/4 | 23.09 | 13 | 5 | 21.87 | 3 | 0 | 0 | 0 | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | c6d66a6ca6faaadac13fa9600e7a791d |
| HK_2025_L455 | 2026-10-01 00:00:00 | ST_20261001_R05 | CELESTIAL ZOUS | 5 | 2026 | 10 | 4 | 9 | 3 | — | — | — | 13.80 | 20.99 | 22.39 | — | — | — | 12 | 11 | 9 | — | — | — | 4-1/2 | 6 | 7-3/4 | — | — | — | 22.39 | 9 | 7-3/4 | 13.80 | 12 | — | — | — | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | 839148d29679fe198be95411dfd533e3 |
| HK_2025_L443 | 2026-10-01 00:00:00 | ST_20261001_R08 | PRIME ACE | 5 | 2026 | 10 | 4 | 9 | 3 | — | — | — | 24.36 | 22.58 | 22.52 | — | — | — | 5 | 5 | 9 | — | — | — | 1-3/4 | 1-1/4 | 4-1/2 | — | — | — | 22.52 | 9 | 4-1/2 | 24.36 | 5 | — | — | — | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | 96d15f04fc6ebdb632b9f28eb8367d44 |
| HK_2025_L441 | 2026-10-01 00:00:00 | ST_20261001_R05 | JEDI SPURS | 1 | 2026 | 10 | 4 | 2 | 3 | — | — | — | 13.08 | 20.75 | 22.42 | — | — | — | 1 | 1 | 2 | — | — | — | 3/4 | 3/4 | 2 | — | — | — | 22.42 | 2 | 2 | 13.08 | 1 | — | — | — | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | f8ebcf36945531c5a063eace7759d9f3 |
| HK_2025_L410 | 2026-10-01 00:00:00 | ST_20261001_R10 | SONIC LINER | 5 | 2026 | 10 | 4 | 12 | 4 | — | — | 13.85 | 22.31 | 22.91 | 22.79 | — | — | 4 | 6 | 7 | 12 | — | — | 2 | 3 | 3 | 4 | 13.85 | 4 | 2 | 22.79 | 12 | 4 | 22.31 | 6 | 0 | 0 | 0 | 0 | true | 1 | 1 | 2026-10-01 11:20:07 | 24f8262f76e8f46ff64c2bc2e5182cba |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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.
免費
下載樣本