Racing data
HKJC Trainer Rankings
Hong Kong trainer standings, wins, and performance statistics
hkjc_trainer_rankings
Rows
1,821
Coverage
January 1970 to September 2026
Columns
21
Latest data
2026-09-27
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-09-27 00:00:00 | 2026-27 | combined | SJJ | J Size | 蔡約翰 | 0 | 12797 | 1667 | 1435 | 1212 | 4314 | 0.1303 | 0.3371 | 54 | 4 | 15 | 0.0741 | 23 | 2026-09-28 22:00:08 | fc68da99c671d81c310d952f09a58813 |
| 2026-09-27 00:00:00 | 2026-27 | combined | CAS | A S Cruz | 告東尼 | 0 | 16549 | 1616 | 1538 | 1397 | 4551 | 0.0976 | 0.275 | 100 | 2 | 18 | 0.02 | 23 | 2026-09-28 22:00:08 | d3e39e3a07c2b166ddb62dcf3760f55e |
| 2026-09-27 00:00:00 | 2026-27 | combined | FC | C Fownes | 方嘉柏 | 0 | 13084 | 1240 | 1147 | 1149 | 3536 | 0.0948 | 0.2703 | 92 | 9 | 22 | 0.0978 | 23 | 2026-09-28 22:00:08 | ab8343c4b7f6c93244cb4e047a49a05b |
| 2026-09-27 00:00:00 | 2026-27 | combined | YPF | P F Yiu | 姚本輝 | 0 | 13075 | 1111 | 1065 | 1049 | 3225 | 0.085 | 0.2467 | 73 | 7 | 18 | 0.0959 | 23 | 2026-09-28 22:00:08 | 20daa5324fba76bb4e1c0bcef916d1af |
| 2026-09-27 00:00:00 | 2026-27 | combined | LKW | K W Lui | 呂健威 | 0 | 12529 | 1043 | 1012 | 973 | 3028 | 0.0832 | 0.2417 | 84 | 4 | 26 | 0.0476 | 23 | 2026-09-28 22:00:08 | 788c6605746362d78f3a23ba1a8de60b |
| 2026-09-27 00:00:00 | 2026-27 | combined | SCS | C S Shum | 沈集成 | 0 | 10426 | 942 | 845 | 820 | 2607 | 0.0904 | 0.25 | 91 | 10 | 20 | 0.1099 | 23 | 2026-09-28 22:00:08 | a2c9bf7dfc075c86aada31ec295a1135 |
| 2026-09-27 00:00:00 | 2026-27 | combined | YCH | C H Yip | 葉楚航 | 0 | 12749 | 899 | 902 | 922 | 2723 | 0.0705 | 0.2136 | 70 | 2 | 7 | 0.0286 | 23 | 2026-09-28 22:00:08 | 31a3afca5990339a9348ea2fd14d276c |
| 2026-09-27 00:00:00 | 2026-27 | combined | MKL | K L Man | 文家良 | 0 | 10615 | 746 | 787 | 771 | 2304 | 0.0703 | 0.2171 | 82 | 8 | 19 | 0.0976 | 23 | 2026-09-28 22:00:08 | 40427b3e21be77f7e52b30f372b384fc |
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 10Ways 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 (daily snapshots from 2025-12-03) · does not update
$99
Buy the archive Trainer Rankings (opens in new tab)Racing Pass Starter
A rolling 24-month window, currently from October 2024with 5 other tables
$49/mo
Subscribe to Racing Pass Starter (opens in new tab)