賽馬數據
HKJC Racing Changes
賽事變動收錄825筆記錄,資料來自香港賽馬會公布的賽事變動,涵蓋2025年12月至2026年11月,每小時更新。
Hong Kong race card scratches and jockey changes
hkjc_racing_changes
行數
825
涵蓋期間
2025年12月至2026年11月
欄位數目
19
最新數據
2026-11-14
樣本
| race_date | venue_code | race_number | race_id | race_year | race_month | venue | race_class | distance | runner_number | horse_name_en | horse_name_ch | change_type_code | change_type | scratch_reserve_indicator | change_time | is_scratch | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11-14 00:00:00 | ST | 3 | ST_20261114_R03 | 2026 | 11 | Sha Tin | Class 5 | 1650 | 10 | QUICK MONEY | 不勞而獲 | 96 | Code 96 | 2026-11-13 01:30:57 | 0 | 2026-11-14 22:10:54 | 0c185ebf361c3ad6c79def50d7940be0 | |
| 2026-11-14 00:00:00 | ST | 3 | ST_20261114_R03 | 2026 | 11 | Sha Tin | Class 5 | 1650 | 10 | QUICK MONEY | 不勞而獲 | 99 | Jockey Change | 2026-11-13 01:31:18 | 0 | 2026-11-14 22:10:54 | 105aa97b24b38279458163ed368eaa46 | |
| 2026-11-14 00:00:00 | ST | 3 | ST_20261114_R03 | 2026 | 11 | Sha Tin | Class 5 | 1650 | 10 | QUICK MONEY | 不勞而獲 | 98 | Weight Change | 2026-11-13 01:31:36 | 0 | 2026-11-14 22:10:54 | 3fbd266793326d36588011618f53ebb5 | |
| 2026-11-14 00:00:00 | ST | 3 | ST_20261114_R03 | 2026 | 11 | Sha Tin | Class 5 | 1650 | 3 | VIEW OF COSMOS | 觀萬象 | 92 | Code 92 | 2026-11-14 05:57:31 | 0 | 2026-11-14 22:10:54 | a66df3adf20e42e13e8fd8c3b7278a9b | |
| 2026-11-14 00:00:00 | ST | 7 | ST_20261114_R07 | 2026 | 11 | Sha Tin | Class 2 | 1200 | 8 | MEGASTAR HEART | 正本巨星 | 98 | Weight Change | 2026-11-14 07:34:01 | 0 | 2026-11-14 22:10:54 | 1eca008b72da415c93cede117bae2730 | |
| 2026-11-14 00:00:00 | ST | 7 | ST_20261114_R07 | 2026 | 11 | Sha Tin | Class 2 | 1200 | 9 | JOHANNES BRAHMS | 玩笑 | 98 | Weight Change | 2026-11-14 07:34:11 | 0 | 2026-11-14 22:10:54 | 015b9ad66235750d23062442122fcba4 | |
| 2026-11-14 00:00:00 | ST | 7 | ST_20261114_R07 | 2026 | 11 | Sha Tin | Class 2 | 1200 | 3 | LUCKY WITH YOU | 幸運有您 | 92 | Code 92 | 2026-11-14 07:59:44 | 0 | 2026-11-14 22:10:54 | 334d28f3c5e405aec98d33a66ce12b96 | |
| 2026-11-11 00:00:00 | HV | 1 | HV_20261111_R01 | 2026 | 11 | Happy Valley | Class 5 | 1650 | 4 | HEALTHY PONY | 健康小馬 | 99 | Jockey Change | 2026-11-10 02:48:30 | 0 | 2026-11-11 14:30:09 | be62577158bed428ad9d6b6d9b79c7a5 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| race_date | date and time | Date of the race |
| venue_code | text | Venue code (ST=Sha Tin, HV=Happy Valley) |
| race_number | number | Race number (1-11 typically) |
| race_id | text | Generated race identifier for joins (venue_YYYYMMDD_RNN) |
| race_year | number | Year of the race |
| race_month | number | Month of the race (1-12) |
| venue | text | Full venue name |
| race_class | text | Race class (denormalized from races) |
| distance | number | Race distance in meters (denormalized from races) |
| runner_number | text | Horse's saddle cloth number |
| horse_name_en | text | Horse name in English |
| horse_name_ch | text | Horse name in Chinese |
| change_type_code | text | Change type code (S=Scratched, J=Jockey, etc.) |
| change_type | text | Human-readable change type (Scratched, Jockey Change, etc.) |
| scratch_reserve_indicator | text | Indicates if the horse was a reserve runner. 'R' means the horse was a reserve that may fill a vacancy if another horse is scratched. Empty for non-reserve horses. |
| change_time | date and time | Timestamp when change was announced |
| is_scratch | number | Whether this is a scratch (true/false) |
| 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_racing_changes LIMIT 10
取得此數據表的方式
免費樣本
Last 12 months of jockey/horse changes, scratchings, and weight adjustments, full schema. The pre-race state delta the form guide doesn't show.
免費
下載樣本Racing Pass Pro
滾動 24 個月期間,現時由2024年11月起另包含 13 個數據表
US$1,490/年
按年收費 · 或每月 US$149 Racing Pass Pro
訂閱 Racing Pass Pro價格及付款程序均由 Renavon 全權處理,駿眼並不經手有關付款。
Renavon 的付款頁面只提供英文版本。