賽馬數據
HKJC Trainer Rankings
Hong Kong trainer standings, wins, and performance statistics
hkjc_trainer_rankings
行數
1,821
涵蓋期間
1970年1月至2026年9月
欄位數目
21
最新數據
2026-09-27
樣本
| 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 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hkjc_trainer_rankings LIMIT 10取得此數據表的方式
免費樣本
Full current racing season of trainer rankings, full schema, no row cap. Captures every trainer with runners this season.
免費
下載樣本