賽馬數據
HKJC Horses Database
Hong Kong racehorse profiles, pedigree and career statistics
hkjc_horses
行數
18,207
涵蓋期間
1979年9月至2026年10月
欄位數目
33
最新數據
2026-10-01
樣本
| horse_id | horse_name | 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 | 142 | 142 | 3 | 22 | 2 | 0 | 24 | 0.9167 | 1.0 | Experienced | 160923900.0 | 2352000.0 | 2026-09-06 00:00:00 | 25 | Overseas (20/09/2026) | 2026-09-28 01:07:43 | 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 | 134 | 5 | 24 | 5 | 0 | 31 | 0.7742 | 0.9355 | Experienced | 288745697.0 | 74036000.0 | 2026-05-24 00:00:00 | 130 | Hong Kong (28/06/2021) | 2026-10-01 00:07:43 | 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 | 128 | 130 | 128 | 0 | 12 | 8 | 5 | 33 | 0.3636 | 0.7576 | Experienced | 132161225.0 | 0.0 | 2026-04-26 00:00:00 | 158 | Conghua (14/09/2026) | 2026-09-28 01:07:43 | 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 | 121 | 124 | 0 | 7 | 4 | 2 | 19 | 0.3684 | 0.6842 | Developing | 42734700.0 | 0.0 | 2026-04-26 00:00:00 | 158 | Hong Kong (09/06/2026) | 2026-09-28 01:07:43 | 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 | 158 | Hong Kong (30/10/2025) | 2026-09-28 01:07:43 | 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 | 4 | Hong Kong (01/09/2026) | 2026-09-30 02:08:01 | 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 | 25 | Hong Kong (25/09/2026) | 2026-09-28 01:07:43 | HK_2023_J358 |
| HK_2022_H302 | HELIOS EXPRESS | Active | Bay | Gelding | 7 | AUS | 2023-01-16 00:00:00 | PP | 3 | Toronado | Paris Texas | Hinchinbrook | Andy Yung Ming Tai | J Size | 118 | 120 | 120 | -2 | 7 | 9 | 4 | 25 | 0.28 | 0.8 | Experienced | 50580450.0 | 0.0 | 2026-09-27 00:00:00 | 4 | Hong Kong (16/01/2023) | 2026-09-30 22:08:01 | HK_2022_H302 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| horse_id | text | Unique horse identifier |
| horse_name | text | Horse's name in English |
| registration_status | text | Horse's registration status with the HKJC: Active, Retired, or Deregistered. |
| colour | text | Coat colour (Bay, Chestnut, Grey, etc.) |
| sex | text | Sex (G=Gelding, C=Colt, F=Filly, M=Mare, H=Horse) |
| age | number | Current age in years |
| 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 | Current HKJC rating |
| last_rating | number | Previous rating |
| start_of_season_rating | number | Rating at start of current 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.
免費
下載樣本