Racing data
HKJC Comments on Running
Stewards' running comments for every Hong Kong runner
hkjc_comments_on_running
Rows
250,626
Coverage
September 2000 to September 2026
Columns
21
Latest data
2026-09-23
Sample
| race_date | race_no | race_id | hkjc_internal_race_id | race_name | rating | distance_m | venue | going | placing | placing_raw | horse_no | horse | brand_code | horse_id | jockey | gear | gear_label | comment | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 1 | 1 | 4 | RED BRICK WARRIOR | K580 | HK_2024_K580 | C L Chau | SR1 | Shadow Roll (1st time) | Began smartly from gate 1, sent forward to take the lead, enjoyed the easy lead in the middle stages, kept on well in straight despite shifting out, won by a neck. (See Racing Incidents.) | 2026-09-29 02:07:50.956000 | 6faae352f47e2fa0c6e4e11fdcd55642 |
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 2 | 2 | 11 | ORIENTAL SURPRISE | K028 | HK_2024_K028 | Z Purton | B/TT | Blinkers / Tongue Tie | Average to begin, raced 2 wide in midfield, found rail near 400M, kept to inside after straightening and finished off well to take 2nd. (See Racing Incidents.) | 2026-09-29 02:07:50.956000 | 7f24853c1f73fd3dd4c556df8d57f5ae |
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 3 | 3 | 10 | WINDICATOR FAMILY | H419 | HK_2022_H419 | K Teetan | V- | Visor (removed) | Shifted out at start and made contact, raced towards rear, 8 lengths or so back turning in, made very good progress in straight to take a place. | 2026-09-29 02:07:50.956000 | c1fff06af4a9564b71a73e5edca79388 |
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 4 | 4 | 6 | ALL ARE MINE | H293 | HK_2022_H293 | L Hewitson | H/XB | Hood / Crossed Nose Band | Taken back from a wide draw, raced at rear on the inside, still well back on turn, angled out 350M, made good progress in straight to make frame. | 2026-09-29 02:07:50.956000 | ca0de68cb67adc9a8baf54ed33f46659 |
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 5 | 5 | 3 | SOARING BRONCO | J162 | HK_2023_J162 | L Ferraris | CP-/B1 | Sheepskin Cheek Pieces (removed) / Blinkers (1st time) | Jumped with them, raced better than midfield on the inside, angled out 400M, 4 lengths back turning in, kept on evenly in straight. | 2026-09-29 02:07:50.956000 | cf4133227c32b89b4f9909e535e6ed09 |
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 6 | 6 | 1 | SUPER SICARIO | K306 | HK_2024_K306 | C Y Ho | -- | No gear | Moderately away from the widest draw, raced 3 wide better than midfield early, moved closer after passing 1000M, 2nd in the middle stages, 2-1/2L back turning in, peaked on run 200M, weakened final 100M. | 2026-09-29 02:07:50.956000 | 134bb189d4592d369f49545fdc4b86cd |
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 7 | 7 | 12 | PERFECT PAIRING | J331 | HK_2023_J331 | A Atzeni | B | Blinkers | Bumped shortly after start, raced at rear on the outside, very wide turning in, made some progress in straight. | 2026-09-29 02:07:50.956000 | da23fa40ab142c47f544657ae561cea6 |
| 2026-09-23 | 1 | HV_20260923_R01 | 037 | NAM FUNG HANDICAP | 40-0 | 1650 | Happy Valley | Good | 8 | 8 | 7 | CIRCUIT DUFFY | J501 | HK_2023_J501 | M L Yeung | V-/PC1 | Visor (removed) / Pacifiers with Cowls (1st time) | Out with rest, raced 2 wide slightly behind midfield, 7 lengths or so back turning in, kept on same pace in straight. | 2026-09-29 02:07:50.956000 | 6298f70e3e7f87fad313d42663642d3f |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| race_date | date | Date of the race (YYYY-MM-DD) |
| race_no | number | Race number within the meeting |
| race_id | text | Canonical race identifier (venue_YYYYMMDD_RNN, e.g. ST_20250928_R01) — joins to hkjc_races.race_id, many rows here (one per horse) to one race there |
| hkjc_internal_race_id | text | HKJC's own per-season numeric race id, as shown in parentheses on the page (resets each season — not a cross-dataset join key; use race_id for joins) |
| race_name | text | Race name (e.g. SUNBIRD PLATE) |
| rating | text | Race rating band, blank when not applicable |
| distance_m | number | Race distance in metres |
| venue | text | Racecourse — Sha Tin or Happy Valley |
| going | text | Going (track condition), e.g. Good To Yielding |
| placing | number | Finishing placing as a number (NULL when non-numeric, e.g. WV/DH) |
| placing_raw | text | Finishing placing exactly as the source shows it, including the non-numeric outcome codes a finishing position cannot express: PU (pulled up), UR (unseated rider), FE (fell), DNF (did not finish), TNP (took no part), DISQ (disqualified). Numeric where the horse completed the race; `placing` carries the same value typed as an integer, and is null for every coded outcome. |
| horse_no | text | Horse's saddle number in the race |
| horse | text | Horse's name in English, with the trailing brand parenthetical removed (that value is in brand_code) |
| brand_code | text | Horse's HKJC brand number exactly as the page shows it (e.g. L441; historical horses carry a cycle prefix and render two letters, e.g. BT163 — horse_id embeds only the trailing form, HK_1998_T163) |
| horse_id | text | Canonical horse identifier (HK_YYYY_XXXX format) |
| jockey | text | Jockey who rode the horse |
| gear | text | Equipment carried (HKJC gear codes, e.g. TT = Tongue Tie, B = Blinkers). 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. |
| comment | text | Stewards' comment describing how the horse ran in the race |
| 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. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.hkjc_comments_on_running LIMIT 10Ways to get this table
Free sample
Last 12 months of stewards' comments on running, every runner in every meeting, full schema and no row cap.
Free
Download the sampleOne-off archive
3 September 2000 to present · does not update
$149
Buy the archive Comments on Running (opens in new tab)Racing Pass Pro
A rolling 24-month window, currently from October 2024with 13 other tables
$149/mo
Subscribe to Racing Pass Pro (opens in new tab)