賽馬數據
HKJC Racing Changes
Hong Kong race card scratches and jockey changes
hkjc_racing_changes
行數
738
涵蓋期間
2025年12月至2026年10月
欄位數目
19
最新數據
2026-10-01
樣本
| 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-10-01 00:00:00 | ST | 1 | ST_20261001_R01 | 2026 | 10 | Sha Tin | Class 5 | 1200 | 14 | EXCEED THE WISH | 星之願 | 98 | Weight Change | 2026-10-01 04:28:50 | 0 | 2026-10-01 11:20:07 | 8a5643ff75878cb8613fff2c1696de69 | |
| 2026-10-01 00:00:00 | ST | 5 | ST_20261001_R05 | 2026 | 10 | Sha Tin | Class 4 | 1000 | 14 | CHAMP'S DOMAIN | 勝萬家 | 96 | Code 96 | 2026-09-28 04:29:37 | 0 | 2026-10-01 11:20:07 | ac5d58478d280dffc6151f526cdae7bb | |
| 2026-10-01 00:00:00 | ST | 5 | ST_20261001_R05 | 2026 | 10 | Sha Tin | Class 4 | 1000 | 14 | CHAMP'S DOMAIN | 勝萬家 | 99 | Jockey Change | 2026-09-28 04:29:47 | 0 | 2026-10-01 11:20:07 | d77482f69ec76ad7bb6fae51301e0699 | |
| 2026-10-01 00:00:00 | ST | 5 | ST_20261001_R05 | 2026 | 10 | Sha Tin | Class 4 | 1000 | 14 | CHAMP'S DOMAIN | 勝萬家 | 98 | Weight Change | 2026-09-28 04:30:24 | 0 | 2026-10-01 11:20:07 | 61987783eee69e4d046445a4082e966b | |
| 2026-10-01 00:00:00 | ST | 7 | ST_20261001_R07 | 2026 | 10 | Sha Tin | Class 4 | 1200 | 14 | LAKESHORE HERO | 翠湖烈風 | 98 | Weight Change | 2026-10-01 07:58:21 | 0 | 2026-10-01 11:20:07 | 19affe9f873d1be8a98350604012f567 | |
| 2026-10-01 00:00:00 | ST | 8 | ST_20261001_R08 | 2026 | 10 | Sha Tin | Class 4 | 1200 | 12 | TYCOON EXPRESS | 騰達勇士 | 98 | Weight Change | 2026-10-01 08:28:37 | 0 | 2026-10-01 11:20:07 | c02ce6becad10f3fa7c49ef9a5298d21 | |
| 2026-10-01 00:00:00 | ST | 11 | ST_20261001_R11 | 2026 | 10 | Sha Tin | Class 3 | 1200 | 13 | THOUSAND SPIRIT | 千杯不醉 | 98 | Weight Change | 2026-10-01 09:58:43 | 0 | 2026-10-01 11:20:07 | fb463193851bc6fc1adad6a1f9013695 | |
| 2026-09-27 00:00:00 | ST | 2 | ST_20260927_R02 | 2026 | 9 | Sha Tin | Class 4 | 1200 | 12 | GLACIATED | 金多囍 | 98 | Weight Change | 2026-09-27 04:57:34 | 0 | 2026-09-27 14:30:06 | e0813d6a641fd09f1d664cda5cdba234 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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.
免費
下載樣本