賽馬數據
HKJC Race Results (Core)
Hong Kong horse racing results and form guide (core columns)
hkjc_race_results_core
Results
375,882
涵蓋期間
1977年5月至2026年10月
欄位數目
59
最新數據
2026-10-01
樣本
| 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_2023_J187 | 2026-10-01 00:00:00 | 1 | ST_20261001_R01 | VERBIER | — | 0 | true | — | — | — | — | — | — | ST | Sha Tin | Turf | — | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | --- | — | C Fownes | Alex Shek & Olivia Se | Bay | Gelding | 6 | FR | PPG | 2023-10-14 00:00:00 | — | Toronado | Vadirima | Selkirk | 0 | 0 | false | 133 | — | 2467500.0 | 0.0 | 3-1-5-34 | 3 | 1 | 5 | 34 | 0.0882 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | 26736acae2a176942105a365b5be966e | ||||
| HK_2024_K250 | 2026-10-01 00:00:00 | 1 | ST_20261001_R01 | DASH | — | 0 | true | — | — | — | — | — | — | ST | Sha Tin | Turf | — | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | --- | — | D J Whyte | Benedict Sin | Brown | Gelding | 5 | AUS | PPG | 2024-10-14 00:00:00 | — | Zoustar | Strata Lady | Stratum | 0 | 0 | false | 123 | B | Blinkers | 211725.0 | 0.0 | 0-0-1-13 | 0 | 0 | 1 | 13 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | 577fc5cfba4c8bcedf60ef57021577a3 | |||
| HK_2024_K279 | 2026-10-01 00:00:00 | 1 | 057 | ST_20261001_R01 | CIRRUS SPEED | 7 | 1 | false | PLACED | Finished | — | — | 3 | 12.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | M F Poon | — | D J Hall | Kent Leung Kin Keung | Bay | Gelding | 5 | AUS | PPG | 2024-11-05 00:00:00 | 1109 | Star Turn | Holley Shiftwell | Testa Rossa | 1 | 1 | false | 129 | — | 105300.0 | 0.0 | 1-0-0-11 | 1 | 0 | 0 | 11 | 0.0909 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | 6d5b0995a7015b248efaa2a04cc3eea8 | |||
| HK_2024_K503 | 2026-10-01 00:00:00 | 1 | 057 | ST_20261001_R01 | FALCON HUNTER | 2 | 2 | false | PLACED | Finished | — | — | 2 | 10.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | J Orman | — | J Cummings | Alex Chan Cheuk Lun | Brown | Gelding | 4 | NZ | PPG | 2025-03-27 00:00:00 | 1085 | U S Navy Flag | Evana Rahma | Darci Brahma | 0 | 1 | false | 133 | TT | Tongue Tie | 134550.0 | 0.0 | 0-1-1-9 | 0 | 1 | 1 | 9 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | f122b78a24f0e92ece4b61020390dcb1 | ||
| HK_2023_J223 | 2026-10-01 00:00:00 | 1 | 057 | ST_20261001_R01 | SUNNY Q | 1 | 3 | false | PLACED | Finished | — | — | 4 | 6.6 | ST | Sha Tin | Turf | A | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | A Atzeni | — | W Y So | Matthew Wong Leung Pak | Bay | Gelding | 6 | AUS | PPG | 2023-11-07 00:00:00 | 1165 | Rich Enuff | Harmony Hall | Minardi | 0 | 1 | false | 135 | CP/TT | Sheepskin Cheek Pieces / Tongue Tie | 1499950.0 | 17500.0 | 1-2-3-20 | 1 | 2 | 3 | 20 | 0.05 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | eba22868cd2518a42e4db04d08a527f2 | ||
| HK_2025_L100 | 2026-10-01 00:00:00 | 1 | 057 | ST_20261001_R01 | POWER PATCH | 4 | 4 | false | PLACED | Finished | — | — | 8 | 10.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | C Y Ho | — | K L Man | Lam Wai Ying | Chestnut | Gelding | 4 | AUS | PPG | 2025-08-07 00:00:00 | 1255 | Calyx | Charlee Bear | Choisir | 0 | 0 | false | 133 | B | Blinkers | 40950.0 | 0.0 | 0-0-0-8 | 0 | 0 | 0 | 8 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | 9d850ee4fbc04c0d10789ede574ae8fb | ||
| HK_2024_K038 | 2026-10-01 00:00:00 | 1 | 057 | ST_20261001_R01 | NOBLE FANS | 6 | 5 | false | PLACED | Finished | — | — | 13 | 18.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | Z Purton | — | J Size | Kenneth Tang | Chestnut | Gelding | 5 | AUS | PPG | 2024-07-11 00:00:00 | 1182 | All Too Hard | Tenderly | Stratum | 0 | 0 | false | 130 | B/TT | Blinkers / Tongue Tie | 1082225.0 | 0.0 | 1-1-2-19 | 1 | 1 | 2 | 19 | 0.0526 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | 2e09febac898ac706a6ae69968386f7d | ||
| HK_2024_K216 | 2026-10-01 00:00:00 | 1 | 057 | ST_20261001_R01 | WINNING DIAMOND | 13 | 6 | false | PLACED | Finished | — | — | 12 | 40.0 | ST | Sha Tin | Turf | A | 1200 | Sprint | NANNING HANDICAP | Class 5 | GOOD TO FIRM | 14 | R Kingscote | — | D Eustace | Eddie Chung Kwok Leung | Bay | Gelding | 5 | AUS | PPG | 2024-10-10 00:00:00 | 1026 | Deep Field | Clearly | Invincible Spirit | 0 | 0 | false | 121 | B1 | Blinkers (1st time) | 145950.0 | 0.0 | 0-0-0-15 | 0 | 0 | 0 | 15 | 0.0 | https://racing.hkjc.com/racing/information/english/Racing/LocalResults.aspx?RaceDate=2026/10/01&RaceNo=1 | https://racing.hkjc.com/contentAsset/videoplayer_v4/video-player-iframe_v4.html?type=replay-full&date=20261001&no=01&lang=eng&noPTbar=false&noLeading=false&videoParam=YD&rf=http://racing.hkjc.com/en-us/local/information/resultsall?racedate=2026/10/01&pageid=racing/local | 2026-10-01 11:20:07 | 174adc124fbd8a9824c17ca91aa82fa4 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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; WXNR = declared a non-runner. WV 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), 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 age in years |
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hkjc_race_results_core LIMIT 10取得此數據表的方式
免費樣本
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.
免費
下載樣本