Racing data
HKJC Horses Database
HKJC Horses Database holds 18,280 horses from the Hong Kong Jockey Club's published horse profiles, covering September 1979 to November 2026, and is updated daily.
Hong Kong racehorse profiles, pedigree and career statistics
hkjc_horses
Horses
18,280
Coverage
September 1979 to November 2026
Columns
34
Latest data
2026-11-14
Sample
| 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 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| 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. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.hkjc_horses LIMIT 10
Ways to get this table
Free sample
500 horses stratified across activity status and career stage, full schema. Regenerated quarterly.
Free
Download the sampleOne-off archive
All horses, all-time · does not update
US$149
Buy the archive Horses — Career ProfilesRacing 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.