Racing data
HKJC Race Results (Core)
HKJC Race Results (Core) holds 377,703 results from the Hong Kong Jockey Club's published race results, covering May 1977 to November 2026, and is updated hourly.
Hong Kong horse racing results and form guide (core columns)
hkjc_race_results_core
Results
377,703
Coverage
May 1977 to November 2026
Columns
59
Latest data
2026-11-14
Sample
| horse_id | race_date | race_number | race_index | race_id | horse_name | horse_number | finishing_position | non_starter | result_status | result_status_label | finishing_time_seconds | finishing_time | margin | margin_lengths | draw | odds | venue_code | venue | surface_type | course_config | distance | distance_category | race_name | race_class | track_condition | field_size | jockey | jockey_allowance | trainer | owner | horse_colour | horse_sex | horse_age | horse_origin | import_type | import_date | declared_horse_weight | sire | dam | dam_sire | is_winner | is_top_three | dead_heat | weight | gear | gear_label | total_stakes | season_stakes | no_of_starts | career_wins | career_seconds | career_thirds | career_total_starts | career_win_rate | race_url | video_replay_url | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HK_2025_L317 | 2026-11-14 00:00:00 | 1 | ST_20261114_R01 | EVER WEALTH | — | 0 | true | — | — | — | — | — | — | — | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | — | P F Yiu | Arthur Wong Chun Mo | Bay | Gelding | 3 | AUS | PPG | 2025-12-23 00:00:00 | — | All Too Hard | Its Time For Magic | Per Incanto | 0 | 0 | false | 121 | B-/V1 | Blinkers (removed) / Visor (1st time) | 237500.0 | 0.0 | 0-0-2-5 | 0 | 0 | 2 | 5 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | 1d3b0f5ee42089022e6f52aad83c3074 | |||
| HK_2025_L308 | 2026-11-14 00:00:00 | 1 | ST_20261114_R01 | SHARP PLANET | — | 0 | true | — | — | — | — | — | — | — | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | — | C Fownes | Yiu King Chuen, Chino Yiu Chin Hang & Chris Yiu Chun Hang | Bay | Gelding | 3 | IRE | PPG | 2025-12-20 00:00:00 | — | Starspangledbanner | Onyali | Rip Van Winkle | 0 | 0 | false | 122 | B/TT | Blinkers / Tongue Tie | 218500.0 | 0.0 | 0-1-0-4 | 0 | 1 | 0 | 4 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | b0ad90b1182d7a44c7b25abc1910c2a0 | |||
| HK_2025_L438 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | SECRET HEDGE | 12 | 1 | false | PLACED | Finished | 69.18 | 1:09.18 | --- | — | 14 | 34.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | M Chadwick | — | J Size | Idon Pong Wai Ning | Brown | Gelding | 3 | AUS | PPG | 2026-03-24 00:00:00 | 1128 | Brutal | Commanding Epic | Commands | 1 | 1 | false | 125 | P1 | Pacifiers (1st time) | 655200.0 | 655200.0 | 1-0-0-1 | 1 | 0 | 0 | 1 | 1.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | 6d063ff306864ac0a7151a23c754d897 |
| HK_2026_M046 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | HAPPY PEGASUS | 2 | 2 | false | PLACED | Finished | 69.33 | 1:09.33 | 1 | 1.0 | 13 | 2.4 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | C L Chau | 2 | C S Shum | Jackson Wang Dong Ying & Julia Zhang Yu Ling | Bay | Gelding | 3 | AUS | PPG | 2026-07-06 00:00:00 | 1171 | Hanseatic | Split Lip | Your Song | 0 | 1 | false | 131 | TT | Tongue Tie | 900900.0 | 900900.0 | 1-1-0-2 | 1 | 1 | 0 | 2 | 0.5 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | 6f8b41119f39ab5625ff1d3e99dc6033 |
| HK_2025_L388 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | I WIN I WIN | 8 | 3 | false | PLACED | Finished | 69.34 | 1:09.34 | 1 | 1.0 | 3 | 8.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | L Ferraris | — | D Eustace | Willie Leung Yiu Chung | Bay | Gelding | 3 | AUS | PPG | 2026-01-28 00:00:00 | 1153 | Pinatubo | Queen Himiko | Real Impact | 0 | 1 | false | 125 | XB1 | Crossed Nose Band (1st time) | 134550.0 | 134550.0 | 0-0-1-1 | 0 | 0 | 1 | 1 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | 9ec23e0a7b44f7657d6348059e1e890f |
| HK_2026_M008 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | DA DA DA | 4 | 4 | false | PLACED | Finished | 69.67 | 1:09.67 | 3 | 3.0 | 9 | 18.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | A Atzeni | — | M Newnham | Patrick Law Fu Yuen | Bay | Gelding | 3 | AUS | PPG | 2026-06-01 00:00:00 | 1135 | Yes Yes Yes | Dubrovnik | Medaglia d'Oro | 0 | 0 | false | 125 | — | 70200.0 | 70200.0 | 0-0-0-1 | 0 | 0 | 0 | 1 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | 9acc014f48308b94f4d958c4dd35d2c4 | |
| HK_2025_L509 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | SAINT JOSE PATCH | 11 | 5 | false | PLACED | Finished | 69.76 | 1:09.76 | 3-3/4 | 3.75 | 8 | 5.4 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | E C W Wong | 3 | K L Man | Lam Wai Ying | Bay | Gelding | 3 | AUS | PPG | 2026-05-28 00:00:00 | 1236 | Home Affairs | Mystical Pursuit | Needs Further | 0 | 0 | false | 122 | — | 286650.0 | 286650.0 | 0-1-0-2 | 0 | 1 | 0 | 2 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | 941ebe738da47d1ed06a5077d82efc1d | |
| HK_2025_L245 | 2026-11-14 00:00:00 | 1 | 187 | ST_20261114_R01 | ALMIGHTY WARRIOR | 1 | 6 | false | PLACED | Finished | 69.91 | 1:09.91 | 4-1/2 | 4.5 | 2 | 8.1 | ST | Sha Tin | Turf | A | 1200 | Sprint | PANASONIC WATER DISPENSER HANDICAP | Class 4 (Restricted) | GOOD TO YIELDING | 14 | Z Purton | — | K W Lui | Anthony Chung On Leung | Bay | Gelding | 3 | IRE | PPG | 2025-11-01 00:00:00 | 928 | Saxon Warrior | One Last Look | Fastnet Rock | 0 | 0 | false | 133 | XB | Crossed Nose Band | 922700.0 | 157950.0 | 1-1-1-6 | 1 | 1 | 1 | 6 | 0.1667 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/11/14&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261114&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=PD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026%2F11%2F14&pageid=racing/local | 2026-11-14 22:10:54 | 1333a26d56b7d3a493e0466db43d894e |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| horse_id | text | Unique horse identifier (e.g., 'HK_2020_E403') |
| race_date | date and time | Date of the race (YYYY-MM-DD) |
| race_number | number | Race number within the meeting (1-11) |
| race_index | text | Original HKJC race identifier within the meeting (1-10). Use this for matching with external HKJC data sources. NULL for modern data (Sept 2025+). |
| race_id | text | Unique race identifier (format: ST_20250928_R01) |
| horse_name | text | Horse's name in English |
| horse_number | number | Horse's saddle/barrier number for the race |
| finishing_position | number | Final finishing position (1, 2, 3, etc.). 0 for non-starters — see non_starter. |
| non_starter | yes/no | TRUE when the horse was entered but did not start the race (scratched, withdrawn, or a standby/reserve that never ran). For these rows finishing_position is not meaningful (0). Filter on non_starter = false for finishing-position calculations; keep them for withdrawal and pre-race analysis. |
| result_status | text | Result classification. 'PLACED' = a completed run with a numeric finishing_position (any position, not the racing sense of "placed in the money"). Codes present in the data: PU = pulled up (started, retired mid-race, no placing); WV = withdrawn on veterinary advice; WX = withdrawn (scratched before the race); WXNR = declared a non-runner. WV, WX and WXNR are non-runners (the horse did not start), so they are always flagged non_starter = true. non_starter = false therefore cleanly means the horse ran; for a set restricted to placed runners (excluding a PU or a future DISQ that ran but did not place) filter result_status = 'PLACED'. DISQ (disqualified) is decoded but does not yet appear: HKJC publishes disqualifications weeks after the race, after our re-scrape window closes, so the provisional placing stays frozen. When a DISQ is ingested the runner did start and HKJC renumbers the field, so finishing_position reflects the official result. See result_status_label for decoded wording. NULL for non-starters with no recorded code and entries with no outcome. |
| result_status_label | text | Human-readable form of result_status (Finished, Pulled Up, Withdrawn (Vet), Withdrawn, Non-runner; Disqualified once ingested). Unmapped codes pass through verbatim. |
| finishing_time_seconds | number | Finishing time converted to total seconds |
| finishing_time | text | Finishing time (MM:SS.ss format) |
| margin | text | Margin from winner (lengths, head, neck, short head, etc.) |
| margin_lengths | number | Margin converted to numeric lengths |
| draw | number | Starting gate/barrier position (same as horse_number in HK flat racing) |
| odds | number | Win odds as a decimal number (e.g. 4.5 = 9/2) |
| venue_code | text | Venue code (ST/HV) |
| venue | text | Race venue (Sha Tin / Happy Valley) |
| surface_type | text | Track surface type: 'Turf' or 'AWT' (All Weather Track) |
| course_config | text | Course configuration (A, B, C, C+3, etc.) - different track layouts at same venue |
| distance | number | Race distance in meters (1000-2400m typical) |
| distance_category | text | Distance category (Sprint/Mile/Middle/Long) |
| race_name | text | Name of the race (e.g., 'FAT CHOI HANDICAP') |
| race_class | text | Race class (Class 1-5, Group 1/2/3, Griffin, etc.) |
| track_condition | text | Track going condition (Good/Good to Firm/Yielding/etc.) |
| field_size | number | Number of horses in the race |
| jockey | text | Jockey name |
| jockey_allowance | number | Weight allowance for apprentice jockeys (0/2/5 lbs). NULL for historical races. |
| trainer | text | Trainer name |
| owner | text | Owner name |
| horse_colour | text | Horse's coat colour (Bay, Chestnut, Grey, etc.) |
| horse_sex | text | Horse's sex (G=Gelding, C=Colt, F=Filly, M=Mare, H=Horse) |
| horse_age | number | Horse's racing age in years on the date of this race (not its current age) |
| horse_origin | text | Country of origin (AUS, NZ, IRE, GB, etc.) |
| import_type | text | Import classification (PP, PPG, ISG, etc.) |
| import_date | date and time | Date imported to Hong Kong |
| declared_horse_weight | number | Horse's declared body weight before racing (in lbs, typically 1000-1200). Useful for tracking fitness/condition changes. |
| sire | text | Sire (father) |
| dam | text | Dam (mother) |
| dam_sire | text | Dam's sire (maternal grandfather) |
| is_winner | number | True if horse won the race |
| is_top_three | number | True if horse finished in top 3 (excludes scratched entries) |
| dead_heat | yes/no | True if horse tied for position. FALSE by default for historical races. |
| weight | number | Weight carried by the horse, in pounds (e.g. 126) |
| gear | text | Equipment used (B=Blinkers, TT=Tongue Tie, H=Hood, SR=Shadow Roll, etc.). '--' means no gear. 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. |
| total_stakes | number | Total career prize money (HKD) |
| season_stakes | number | Current season prize money (HKD) |
| no_of_starts | text | Career record (format: wins-seconds-thirds-total) |
| career_wins | number | Career wins in Hong Kong |
| career_seconds | number | Career second places |
| career_thirds | number | Career third places |
| career_total_starts | number | Total career starts |
| career_win_rate | number | Career win percentage (0-1) |
| race_url | text | Source URL for the race page |
| video_replay_url | text | Direct URL to watch race video replay for this specific horse |
| updated_at | date and time | Timestamp when record was last updated |
| 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_race_results_core LIMIT 10
Ways to get this table
Free sample
Last 12 months of race results across every meeting — the core columns (result, race specs, connections, form, career record). The premium sectional / in-running / pace columns are in the Pro dataset.
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.