賽馬數據
HKJC Horses Database
馬匹資料收錄18,280匹馬,資料來自香港賽馬會公布的馬匹資料,涵蓋1979年9月至2026年11月,每日更新。
Hong Kong racehorse profiles, pedigree and career statistics
hkjc_horses
Horses
18,280
涵蓋期間
1979年9月至2026年11月
欄位數目
34
最新數據
2026-11-14
樣本
| horse_id | horse_name | horse_name_chinese | registration_status | colour | sex | age | origin_country | import_date | import_type | years_in_hk | sire | dam | dam_sire | owner | trainer | current_rating | last_rating | start_of_season_rating | season_rating_change | wins | seconds | thirds | total_starts | win_rate | place_rate | career_stage | total_prize_money | season_prize_money | last_race_date | days_since_last_race | stable_location | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HK_2023_J062 | KA YING RISING | 嘉應高昇 | Active | Bay | Gelding | 6 | NZ | 2023-07-31 00:00:00 | PPG | 3 | Shamexpress | Missy Moo | Per Incanto | Ka Ying Syndicate | D A Hayes | 145 | 145 | 142 | 3 | 22 | 3 | 0 | 25 | 0.88 | 1.0 | Experienced | 176819380.0 | 18247480.0 | 2026-10-17 00:00:00 | 29 | Hong Kong (19/10/2026) | 2026-11-13 02:28:34 | HK_2023_J062 |
| HK_2020_E486 | ROMANTIC WARRIOR | 浪漫勇士 | Retired | Bay | Gelding | 8 | IRE | 2021-06-28 00:00:00 | ISG | 5 | Acclamation | Folk Melody | Street Cry | Peter Lau Pak Fai | C S Shum | 139 | 139 | 139 | 0 | 24 | 5 | 0 | 31 | 0.7742 | 0.9355 | Experienced | 288745697.0 | 0.0 | 2026-05-24 00:00:00 | 175 | Hong Kong (28/06/2021) | 2026-11-01 01:22:40 | HK_2020_E486 |
| HK_2020_E436 | VOYAGE BUBBLE | 遨遊氣泡 | Active | Bay | Gelding | 8 | AUS | 2021-05-10 00:00:00 | PPG | 5 | Deep Field | Raheights | Rahy | Sunshine And Moonlight Syndicate | P F Yiu | 126 | 128 | 128 | -2 | 12 | 8 | 5 | 34 | 0.3529 | 0.7353 | Experienced | 132161225.0 | 0.0 | 2026-10-19 00:00:00 | 27 | Hong Kong (15/10/2026) | 2026-11-01 01:22:40 | HK_2020_E436 |
| HK_2023_J256 | MY WISH | 祝願 | Active | Bay | Gelding | 6 | AUS | 2023-12-19 00:00:00 | PPG | 3 | Flying Artie | Set The Tone | Reset | Ada Che Xiao Hong, Suki Tang Xianfang & Ruby Hui Like Sea | M Newnham | 124 | 124 | 124 | 0 | 7 | 4 | 3 | 20 | 0.35 | 0.7 | Developing | 43349950.0 | 615250.0 | 2026-10-19 00:00:00 | 27 | Hong Kong (09/06/2026) | 2026-11-07 02:24:58 | HK_2023_J256 |
| HK_2021_G180 | LUCKY SWEYNESSE | 金鑽貴人 | Active | Brown | Gelding | 8 | NZ | 2021-09-13 00:00:00 | PPG | 5 | Sweynesse | Madonna Mia | Red Clubs | Cheng Ming Leung, Cheng Yu Tung, Cheng Mei Mei & Cheng Yu Wai | K L Man | 123 | 123 | 123 | 0 | 17 | 6 | 2 | 34 | 0.5 | 0.7353 | Experienced | 84975100.0 | 0.0 | 2026-04-26 00:00:00 | 203 | Hong Kong (30/10/2025) | 2026-10-23 01:08:35 | HK_2021_G180 |
| HK_2022_H399 | GALAXY PATCH | 錶之銀河 | Active | Bay | Gelding | 7 | AUS | 2023-05-08 00:00:00 | PP | 3 | Wandjina | Voltara | More Than Ready | Yeung Kin Man | B Crawford | 122 | 120 | 120 | 2 | 8 | 7 | 1 | 28 | 0.2857 | 0.5714 | Experienced | 37672850.0 | 882000.0 | 2026-09-27 00:00:00 | 49 | Hong Kong (10/11/2026) | 2026-11-11 02:25:32 | HK_2022_H399 |
| HK_2023_J358 | FAST NETWORK | 舉步生風 | Active | Bay | Gelding | 6 | NZ | 2024-01-25 00:00:00 | PPG | 2 | Wrote | Alberta | Magic Albert | Ng Hung Yau | C H Yip | 121 | 121 | 121 | 0 | 7 | 1 | 4 | 21 | 0.3333 | 0.5714 | Experienced | 19832200.0 | 0.0 | 2026-09-06 00:00:00 | 70 | Conghua (28/10/2026) | 2026-11-07 02:24:58 | HK_2023_J358 |
| HK_2022_H368 | RAGING BLIZZARD | 精算暴雪 | Active | Bay | Gelding | 7 | NZ | 2023-03-20 00:00:00 | PPG | 3 | Per Incanto | Perfect Beat | Magnus | Hayden Pong Hei Ting | J Size | 118 | 113 | 115 | 3 | 7 | 7 | 4 | 30 | 0.2333 | 0.6 | Experienced | 26246800.0 | 3248000.0 | 2026-10-25 00:00:00 | 21 | Hong Kong (28/06/2025) | 2026-11-07 02:24:58 | HK_2022_H368 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| horse_id | text | Unique horse identifier |
| horse_name | text | Horse's name in English |
| horse_name_chinese | text | Horse's name in Chinese, as HKJC publishes it. Blank for about 4% of horses, where we hold no Chinese page or race card for the horse. |
| registration_status | text | Horse's registration status with the HKJC: Active (in training in Hong Kong), Retired, Deregistered, or Former (no longer registered, and HKJC's page gives no reason). |
| colour | text | Coat colour (Bay, Chestnut, Grey, etc.) |
| sex | text | Sex (G=Gelding, C=Colt, F=Filly, M=Mare, H=Horse) |
| age | number | Racing age in years as last published by HKJC. For a horse that has left (registration_status not Active) this is its age when last published, not a live figure; for the age at a given race use horse_age in hkjc_race_results |
| origin_country | text | Country of origin (AUS, NZ, IRE, GB, etc.) |
| import_date | date and time | Date imported to Hong Kong |
| import_type | text | Import classification (PP, PPG, etc.) |
| years_in_hk | number | Years racing in Hong Kong, measured to the pipeline build date |
| sire | text | Sire (father) |
| dam | text | Dam (mother) |
| dam_sire | text | Dam's sire (maternal grandfather) |
| owner | text | Current owner |
| trainer | text | Current trainer |
| current_rating | number | HKJC official rating as last published. For a horse that has left (registration_status not Active) this is its rating when last published and is kept permanently; for the rating a horse ran off in a given race use entry_rating in hkjc_race_results |
| last_rating | number | HKJC rating before the last published change, as last published |
| start_of_season_rating | number | HKJC rating at the start of the season, as last published (for a horse that has left, its last season) |
| season_rating_change | number | Rating change during season |
| wins | number | Career wins in Hong Kong |
| seconds | number | Career second places |
| thirds | number | Career third places |
| total_starts | number | Total career starts |
| win_rate | number | Win percentage (0-1). NULL for unraced horses (no career starts). |
| place_rate | number | Top-3 place percentage (0-1). NULL for unraced horses (no career starts). |
| career_stage | text | Career stage (Unraced/Novice/Developing/Experienced/Veteran) |
| total_prize_money | number | Total career prize money (HKD) |
| season_prize_money | number | Current season prize money (HKD) |
| last_race_date | date and time | Date of most recent race |
| days_since_last_race | number | Days since last race |
| stable_location | text | Current stable location |
| 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_horses LIMIT 10
取得此數據表的方式
免費樣本
500 horses stratified across activity status and career stage, full schema. Regenerated quarterly.
免費
下載樣本Racing Pass Pro
滾動 24 個月期間,現時由2024年11月起另包含 13 個數據表
US$1,490/年
按年收費 · 或每月 US$149 Racing Pass Pro
訂閱 Racing Pass Pro價格及付款程序均由 Renavon 全權處理,駿眼並不經手有關付款。
Renavon 的付款頁面只提供英文版本。