Racing data
HKJC Sectional Times
HKJC Sectional Times holds 183,221 records from the Hong Kong Jockey Club's published sectional times, covering April 2008 to November 2026, and is updated daily.
Hong Kong horse racing sectional times and pace analysis
hkjc_sectional_times
Rows
183,221
Coverage
April 2008 to November 2026
Columns
45
Latest data
2026-11-14
Sample
| 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 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| 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. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.hkjc_sectional_times LIMIT 10
Ways to get this table
Free sample
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.
Free
Download the sampleRacing Pass Pro
A rolling 24-month window, currently from November 2024with 13 other tables
US$1,490/yr
billed yearly · or US$149/mo Racing Pass Pro
Subscribe to Racing Pass ProPrices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.