Racing data
HKJC Trainer Rankings
HKJC Trainer Rankings holds 2,143 records from the Hong Kong Jockey Club's published trainer rankings, covering January 1970 to November 2026, and is updated hourly.
Hong Kong trainer standings, wins, and performance statistics
hkjc_trainer_rankings
Rows
2,143
Coverage
January 1970 to November 2026
Columns
21
Latest data
2026-11-14
Sample
| snapshot_date | season_year | ranking_type | trainer_code | trainer_name_en | trainer_name_ch | is_visiting | total_starts | wins | seconds | thirds | places | win_rate | place_rate | current_season_starts | current_season_wins | current_season_places | current_season_win_rate | total_trainers_in_roster | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11-14 00:00:00 | 2026-27 | combined | SJJ | J Size | 蔡約翰 | 0 | 12880 | 1666 | 1434 | 1209 | 4309 | 0.1293 | 0.3345 | 137 | 10 | 28 | 0.073 | 23 | 2026-11-14 22:13:03 | fea960215bbc6376d7eff89c214fc786 |
| 2026-11-14 00:00:00 | 2026-27 | combined | CAS | A S Cruz | 告東尼 | 0 | 16652 | 1614 | 1541 | 1401 | 4556 | 0.0969 | 0.2736 | 203 | 9 | 42 | 0.0443 | 23 | 2026-11-14 22:13:03 | 7178c76d249ef987df59b753e4e94619 |
| 2026-11-14 00:00:00 | 2026-27 | combined | FC | C Fownes | 方嘉柏 | 0 | 13185 | 1251 | 1153 | 1151 | 3555 | 0.0949 | 0.2696 | 193 | 20 | 42 | 0.1036 | 23 | 2026-11-14 22:13:03 | 16d78ca88ff7b2fd7b0fd6e431e460f6 |
| 2026-11-14 00:00:00 | 2026-27 | combined | YPF | P F Yiu | 姚本輝 | 0 | 13173 | 1117 | 1067 | 1051 | 3235 | 0.0848 | 0.2456 | 171 | 19 | 47 | 0.1111 | 23 | 2026-11-14 22:13:03 | f433c75356fa06efe527a1afb6d2ef3d |
| 2026-11-14 00:00:00 | 2026-27 | combined | LKW | K W Lui | 呂健威 | 0 | 12608 | 1046 | 1015 | 975 | 3036 | 0.083 | 0.2408 | 163 | 12 | 49 | 0.0736 | 23 | 2026-11-14 22:13:03 | 6d9d1644ae3f1a7bc430137011db9be3 |
| 2026-11-14 00:00:00 | 2026-27 | combined | SCS | C S Shum | 沈集成 | 0 | 10522 | 941 | 850 | 826 | 2617 | 0.0894 | 0.2487 | 187 | 16 | 41 | 0.0856 | 23 | 2026-11-14 22:13:03 | 49888d0d7e59b0faeec69d07bf8917de |
| 2026-11-14 00:00:00 | 2026-27 | combined | YCH | C H Yip | 葉楚航 | 0 | 12818 | 899 | 905 | 919 | 2723 | 0.0701 | 0.2124 | 139 | 4 | 12 | 0.0288 | 23 | 2026-11-14 22:13:03 | d64a76e2405b16a8282bf12f485ecbe4 |
| 2026-11-14 00:00:00 | 2026-27 | combined | MKL | K L Man | 文家良 | 0 | 10684 | 733 | 786 | 772 | 2291 | 0.0686 | 0.2144 | 151 | 11 | 30 | 0.0728 | 23 | 2026-11-14 22:13:03 | 2410ef71fb990391a4a07e2887d3e275 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| snapshot_date | date and time | Date of the roster snapshot |
| season_year | text | Racing season (e.g., '2025-26') |
| ranking_type | text | Type of ranking (e.g., 'combined') |
| trainer_code | text | Unique trainer identifier code (e.g., 'SJJ' for J Size) |
| trainer_name_en | text | Trainer name in English |
| trainer_name_ch | text | Trainer name in Chinese |
| is_visiting | number | Whether trainer is a visiting (guest) trainer (true/false) |
| total_starts | number | Total career race starts |
| wins | number | Total career wins |
| seconds | number | Total career second places |
| thirds | number | Total career third places |
| places | number | Total top-3 finishes (wins + seconds + thirds) |
| win_rate | number | Career win percentage (0-1 scale) |
| place_rate | number | Career top-3 percentage (0-1 scale) |
| current_season_starts | number | Race starts in current season (Sept–mid-July, summer break Aug) |
| current_season_wins | number | Wins in current season |
| current_season_places | number | Top-3 finishes in current season |
| current_season_win_rate | number | Win percentage in current season (0-1 scale) |
| total_trainers_in_roster | number | Total number of trainers in this snapshot |
| updated_at | date and time | Timestamp when record was last scraped |
| 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_trainer_rankings LIMIT 10
Ways to get this table
Free sample
Full current racing season of trainer rankings, full schema, no row cap. Captures every trainer with runners this season.
Free
Download the sampleOne-off archive
2025-26 season (snapshots from 2025-12-03) · does not update
US$149
Buy the archive Trainer RankingsRacing 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.