hkjc_jockey_rankings
Hong Kong jockey standings, wins, and performance statistics
Download a file
CSV · Excel · Parquet · JSON. Filtered exports.
See pricingQuery with SQL
DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.
Open connection detailsConnect to AI
MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.
See setupComprehensive jockey rankings with performance statistics. Track which jockeys are riding in Hong Kong and compare their career records - wins, win rates, podium places, and current season form. Includes visiting international riders. One snapshot per race meeting day, captured at the close of the meeting. Snapshot history begins December 2025.
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.
The evidence
Schema & column quality (21 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| snapshot_date | DateTime | Date of the roster snapshot | — | — |
| season_year | String | Racing season (e.g., '2025-26') | — | — |
| ranking_type | String | Type of ranking (e.g., 'combined') | — | — |
| jockey_code | String | Unique jockey identifier code (e.g., 'PZ' for Z Purton) | — | — |
| jockey_name_en | String | Jockey name in English | — | — |
| jockey_name_ch | String | Jockey name in Chinese | — | — |
| is_visiting | UInt8 | Whether jockey is a visiting (guest) rider (true/false) | — | — |
| total_starts | UInt64 | Total career race starts | — | — |
| wins | UInt64 | Total career wins | — | — |
| seconds | UInt64 | Total career second places | — | — |
| thirds | UInt64 | Total career third places | — | — |
| places | UInt64 | Total top-3 finishes (wins + seconds + thirds) | — | — |
| win_rate | Float64 | Career win percentage (0-1 scale) | — | — |
| place_rate | Float64 | Career top-3 percentage (0-1 scale) | — | — |
| current_season_starts | UInt64 | Race starts in current season (Sept–mid-July, summer break Aug) | — | — |
| current_season_wins | UInt64 | Wins in current season | — | — |
| current_season_places | UInt64 | Top-3 finishes in current season | — | — |
| current_season_win_rate | Float64 | Win percentage in current season (0-1 scale) | — | — |
| total_jockeys_in_roster | Nullable(Int32) | Total number of jockeys in this snapshot | — | — |
| updated_at | 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. | — | — |
Full current racing season of jockey rankings, full schema, no row cap. Captures every jockey with rides this season.
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.
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
- 2025-26 season (daily snapshots from 2025-12-03), in full
- Updates
- None. Frozen at purchase
- Delivery
- Gzipped CSV, opens in Excel; link valid 7 days
- API access
- Not included
- Access window
- Current and prior season
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- 120,000 rows/month included
Included Datasets
- Access window
- Current and prior season
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- 1,000,000 rows/month included
Included Datasets
- Access window
- Current and prior season
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- Uncapped
Included Datasets
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