Skip to content

HKJC Guru is an independent statistics service and is not affiliated with, endorsed by, or connected to The Hong Kong Jockey Club.

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

8 rows shown
HKJC Horses Database: Sample
horse_idhorse_namehorse_name_chineseregistration_statuscoloursexageorigin_countryimport_dateimport_typeyears_in_hksiredamdam_sireownertrainercurrent_ratinglast_ratingstart_of_season_ratingseason_rating_changewinssecondsthirdstotal_startswin_rateplace_ratecareer_stagetotal_prize_moneyseason_prize_moneylast_race_datedays_since_last_racestable_locationupdated_atid
HK_2023_J062KA YING RISING嘉應高昇ActiveBayGelding6NZ2023-07-31 00:00:00PPG3ShamexpressMissy MooPer IncantoKa Ying SyndicateD A Hayes14514514232230250.881.0Experienced176819380.018247480.02026-10-17 00:00:0029Hong Kong (19/10/2026)2026-11-13 02:28:34HK_2023_J062
HK_2020_E486ROMANTIC WARRIOR浪漫勇士RetiredBayGelding8IRE2021-06-28 00:00:00ISG5AcclamationFolk MelodyStreet CryPeter Lau Pak FaiC S Shum13913913902450310.77420.9355Experienced288745697.00.02026-05-24 00:00:00175Hong Kong (28/06/2021)2026-11-01 01:22:40HK_2020_E486
HK_2020_E436VOYAGE BUBBLE遨遊氣泡ActiveBayGelding8AUS2021-05-10 00:00:00PPG5Deep FieldRaheightsRahySunshine And Moonlight SyndicateP F Yiu126128128-21285340.35290.7353Experienced132161225.00.02026-10-19 00:00:0027Hong Kong (15/10/2026)2026-11-01 01:22:40HK_2020_E436
HK_2023_J256MY WISH祝願ActiveBayGelding6AUS2023-12-19 00:00:00PPG3Flying ArtieSet The ToneResetAda Che Xiao Hong, Suki Tang Xianfang & Ruby Hui Like SeaM Newnham1241241240743200.350.7Developing43349950.0615250.02026-10-19 00:00:0027Hong Kong (09/06/2026)2026-11-07 02:24:58HK_2023_J256
HK_2021_G180LUCKY SWEYNESSE金鑽貴人ActiveBrownGelding8NZ2021-09-13 00:00:00PPG5SweynesseMadonna MiaRed ClubsCheng Ming Leung, Cheng Yu Tung, Cheng Mei Mei & Cheng Yu WaiK L Man12312312301762340.50.7353Experienced84975100.00.02026-04-26 00:00:00203Hong Kong (30/10/2025)2026-10-23 01:08:35HK_2021_G180
HK_2022_H399GALAXY PATCH錶之銀河ActiveBayGelding7AUS2023-05-08 00:00:00PP3WandjinaVoltaraMore Than ReadyYeung Kin ManB Crawford1221201202871280.28570.5714Experienced37672850.0882000.02026-09-27 00:00:0049Hong Kong (10/11/2026)2026-11-11 02:25:32HK_2022_H399
HK_2023_J358FAST NETWORK舉步生風ActiveBayGelding6NZ2024-01-25 00:00:00PPG2WroteAlbertaMagic AlbertNg Hung YauC H Yip1211211210714210.33330.5714Experienced19832200.00.02026-09-06 00:00:0070Conghua (28/10/2026)2026-11-07 02:24:58HK_2023_J358
HK_2022_H368RAGING BLIZZARD精算暴雪ActiveBayGelding7NZ2023-03-20 00:00:00PPG3Per IncantoPerfect BeatMagnusHayden Pong Hei TingJ Size1181131153774300.23330.6Experienced26246800.03248000.02026-10-25 00:00:0021Hong Kong (28/06/2025)2026-11-07 02:24:58HK_2022_H368

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

Question about this table? Ask us. (opens in new tab)

Columns

34
HKJC Horses Database: 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

Get a key on renavon.com (opens in new tab)

Ways to get this table

Free sample

500 horses stratified across activity status and career stage, full schema. Regenerated quarterly.

Free

Download the sample

One-off archive

All horses, all-time · does not update

US$149

Buy the archive Horses — Career Profiles

Racing 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 Pro

Prices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.

See all pricing