賽馬數據
HKJC Jockey Rankings
Hong Kong jockey standings, wins, and performance statistics
hkjc_jockey_rankings
行數
1,747
涵蓋期間
1970年1月至2026年9月
欄位數目
21
最新數據
2026-09-27
樣本
| snapshot_date | season_year | ranking_type | jockey_code | jockey_name_en | jockey_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_jockeys_in_roster | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-27 00:00:00 | 2026-27 | combined | PZ | Z Purton | 潘頓 | 0 | 11588 | 2033 | 1560 | 1204 | 4797 | 0.1754 | 0.414 | 97 | 21 | 48 | 0.2165 | 22 | 2026-09-28 22:00:08 | 4f3c5a9a884d31e1b9c7e340e8862343 |
| 2026-09-27 00:00:00 | 2026-27 | combined | TEK | K Teetan | 田泰安 | 0 | 8496 | 787 | 819 | 825 | 2431 | 0.0926 | 0.2861 | 102 | 8 | 30 | 0.0784 | 22 | 2026-09-28 22:00:08 | e6d712fc0875729624567f87242ca9b7 |
| 2026-09-27 00:00:00 | 2026-27 | combined | HCY | C Y Ho | 何澤堯 | 0 | 7978 | 654 | 608 | 684 | 1946 | 0.082 | 0.2439 | 80 | 10 | 24 | 0.125 | 22 | 2026-09-28 22:00:08 | 9ac8dcd13f6c466f26a9ff2a5ba8199e |
| 2026-09-27 00:00:00 | 2026-27 | combined | CML | M Chadwick | 蔡明紹 | 0 | 8377 | 577 | 639 | 656 | 1872 | 0.0689 | 0.2235 | 56 | 1 | 10 | 0.0179 | 22 | 2026-09-28 22:00:08 | 3a6f58b3b7078c62b06e85360b482c4a |
| 2026-09-27 00:00:00 | 2026-27 | combined | LDE | K C Leung | 梁家俊 | 0 | 9093 | 535 | 574 | 634 | 1743 | 0.0588 | 0.1917 | 79 | 9 | 14 | 0.1139 | 22 | 2026-09-28 22:00:08 | 0b8da3b1c3cebab1b9d2b79c5c3c401a |
| 2026-09-27 00:00:00 | 2026-27 | combined | YML | M L Yeung | 楊明綸 | 0 | 7360 | 342 | 384 | 471 | 1197 | 0.0465 | 0.1626 | 73 | 1 | 8 | 0.0137 | 22 | 2026-09-28 22:00:08 | f79c1adcf22dd3b7941c88554c3db2a7 |
| 2026-09-27 00:00:00 | 2026-27 | combined | BA | A Badel | 巴度 | 0 | 4192 | 314 | 383 | 357 | 1054 | 0.0749 | 0.2514 | 69 | 5 | 19 | 0.0725 | 22 | 2026-09-28 22:00:08 | 6638783a5b21ae9e57a6bbdbfbae47b4 |
| 2026-09-27 00:00:00 | 2026-27 | combined | BH | H Bowman | 布文 | 0 | 2500 | 297 | 310 | 275 | 882 | 0.1188 | 0.3528 | 44 | 6 | 14 | 0.1364 | 22 | 2026-09-28 22:00:08 | 50c4fd6c50b459c42061888ec3720daf |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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') |
| jockey_code | text | Unique jockey identifier code (e.g., 'PZ' for Z Purton) |
| jockey_name_en | text | Jockey name in English |
| jockey_name_ch | text | Jockey name in Chinese |
| is_visiting | number | Whether jockey is a visiting (guest) rider (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_jockeys_in_roster | number | Total number of jockeys 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_jockey_rankings LIMIT 10取得此數據表的方式
免費樣本
Full current racing season of jockey rankings, full schema, no row cap. Captures every jockey with rides this season.
免費
下載樣本