hkjc_dividends
Hong Kong horse racing payouts and betting dividends
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 setupHistorical dividend payouts for Hong Kong horse racing. One row per pool type per race, covering 34 different bet types including WIN, PLACE, QUINELLA, FORECAST, TIERCE, QUARTET, FIRST 4, and multi-race exotics. Contains 25 years of data (2001-present). Includes denormalized race attributes for easy filtering without JOINs.
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 (17 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| race_id | Nullable(String) | Unique race identifier (format: ST_20250928_R01) | — | — |
| race_date | DateTime | Date of the race (YYYY-MM-DD) | — | — |
| venue_code | String | Venue code (ST=Sha Tin, HV=Happy Valley) | — | — |
| venue | Nullable(String) | Full venue name (Sha Tin / Happy Valley) | — | — |
| race_number | Int64 | Race number within the meeting (1-11) | — | — |
| pool_type | String | Betting pool type (WIN, PLACE, QUINELLA, QUINELLA PLACE, FORECAST, TIERCE, TRIO, FIRST 4, QUARTET, DOUBLE, TREBLE, TRIPLE TRIO, SIX UP, etc.) | — | — |
| pool_category | String | Pool category: 'Win/Place', 'Exotic (2 Horse)', 'Exotic (3+ Horse)', 'Multi-Race', 'Other' | — | — |
| is_multi_race_pool | UInt8 | True if this is a multi-race pool (DOUBLE, TREBLE, TRIPLE TRIO, SIX UP) | — | — |
| winning_combination | String | Winning combination (horse numbers, comma-separated, e.g., '3,11,4' for TIERCE) | — | — |
| dividend | Nullable(Float64) | Dividend payout amount per $10 bet (HKD) | — | — |
| return_per_dollar | Nullable(Float64) | Return per $1 bet (dividend / 10) | — | — |
| race_class | Nullable(String) | Race class (Class 1-5, Group One/Two/Three, etc.) | — | — |
| distance | Nullable(Int64) | Race distance in meters | — | — |
| distance_category | String | Distance category (Sprint/Mile/Middle/Long) | — | — |
| track_condition | Nullable(String) | Track going/condition | — | — |
| 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. | — | — |
Last 6 months of pool dividends, full schema. Covers Win, Place, Quinella, Tierce, Trifecta, and the exotic pools.
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
- Jan 2001 – present, in full
- Updates
- None. Frozen at purchase
- Delivery
- Gzipped CSV, opens in Excel; link valid 7 days
- API access
- Not included
- Access window
- Most recent 24 months, rolling
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- 120,000 rows/month included
Included Datasets
- Access window
- Most recent 24 months, rolling
- Updates
- Continuous, within hours of the source
- Delivery
- API, SQL and downloads
- Exports
- 1,000,000 rows/month included
Included Datasets
- Access window
- Most recent 24 months, rolling
- 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