hkjc_racing_changes

PREMIUM 675 rows

Hong Kong race card scratches and jockey changes

Race card changes including scratches, jockey changes, gear changes, and barrier changes. Track late changes before race time for form analysis. Each change is timestamped showing when it was announced. One row per change event.

Premium dataset

Evaluate it in full below: the evidence and a working sample are open to everyone. Buy or subscribe to unlock the complete dataset — your account is created automatically at checkout.

See access options

The evidence

Data coverage
Dec 2025 – present
Pass access: Most recent 24 months, rolling · Full Archive: Dec 2025 – present
Volume
675 rows
Last updated
15 July, 2026 (1 week ago)
Schema & column quality (19 columns)
Column Type Description Populated Distinct
race_date DateTime Date of the race
venue_code String Venue code (ST=Sha Tin, HV=Happy Valley)
race_number Int64 Race number (1-11 typically)
race_id Nullable(String) Generated race identifier for joins (venue_YYYYMMDD_RNN)
race_year UInt16 Year of the race
race_month UInt8 Month of the race (1-12)
venue Nullable(String) Full venue name
race_class Nullable(String) Race class (denormalized from races)
distance Nullable(Int64) Race distance in meters (denormalized from races)
runner_number Nullable(String) Horse's saddle cloth number
horse_name_en Nullable(String) Horse name in English
horse_name_ch Nullable(String) Horse name in Chinese
change_type_code Nullable(String) Change type code (S=Scratched, J=Jockey, etc.)
change_type Nullable(String) Human-readable change type (Scratched, Jockey Change, etc.)
scratch_reserve_indicator String 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 DateTime Timestamp when change was announced
is_scratch Nullable(UInt8) Whether this is a scratch (true/false)
updated_at Nullable(DateTime) Timestamp when record was last scraped
id String 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.

Sample data

Last 12 months of jockey/horse changes, scratchings, and weight adjustments, full schema. The pre-race state delta the form guide doesn't show.

SELECT * FROM renavon_exports.hkjc_racing_changes LIMIT 50 0.02s
Loading data… | Click a header to sort; drag headers to reorder.

Choose your access

A Pass gives you freshness within a rolling window. The Full Archive gives you the full history we hold for the dataset, frozen at purchase. They solve different problems, and they work together.

Satisfaction guarantee: 14-day money-back. Details →

One-off purchase

Full Archive

The full history we hold, frozen at purchase. Yours to keep.

Full details →
What you get
The full history we hold, to your purchase date
History depth
Dec 2025 – present, in full
Updates
None. Frozen at purchase
Delivery
Gzipped CSV, opens in Excel; link valid 7 days
API access
Not included
US$149
one-time purchase

Pass subscription

Racing Pass Enterprise

Continuously updated, with API access.

View full package →
Access window
Most recent 24 months, rolling
Updates
Continuous, within hours of the source
Delivery
API, SQL and downloads
Exports
Uncapped
US$499
per month
SAVE 17%
US$4990
per year
(US$415.83/month)

Get notified when this dataset is updated.

Questions about this data?

Our data experts are ready to help clarify any aspects of this dataset.

Contact Our Team