hkjc_jackpots

PREMIUM 77,158 rows

Hong Kong horse racing Six Up and Triple Trio jackpots

No-code

Download a file

CSV · Excel · Parquet · JSON. Filtered exports.

See pricing
For engineers

Query with SQL

DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.

Open connection details
Agent builders

Connect to AI

MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.

See setup

Jackpot pool information for multi-race pools like Six Up and Triple Trio. Track rolling jackpots and estimated dividends for snowball pools. These pools accumulate when not won, creating large prize pools. One row per jackpot pool per meeting per snapshot.

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
Jan 2026 – present
Pass access: Most recent 24 months, rolling · Full Archive: Jan 2026 – present
Volume
77,158 rows
Last updated
15 July, 2026 (6 days ago)
Schema & column quality (16 columns)
Column Type Description Populated Distinct
race_date DateTime Date of the race meeting — —
venue_code String Venue code (ST=Sha Tin, HV=Happy Valley) — —
race_year UInt16 Year of the meeting — —
race_month UInt8 Month of the meeting (1-12) — —
jackpot_id String Unique jackpot identifier — —
pool_type String Pool type (SixUP, TT=Triple Trio) — —
pool_category String Pool category grouping — —
estimated_dividend Nullable(Int64) Estimated dividend/jackpot amount (HKD) — —
carryover_amount Nullable(Int64) Carryover amount brought forward into the pool (HKD); empty when the pool is fresh with no carryover — —
leg_number Nullable(Int64) Current leg number in multi-leg pool — —
leg_races Nullable(String) Race numbers making up the pool's legs, comma-separated in running order (e.g. 6,7,8,9,10,11 for a Six Up) — —
merged_pool_id Nullable(String) Reference to a combined pool where the Jockey Club merges this pool with another; empty for standalone pools — —
jackpot_tier String Jackpot size tier (Mega 10M+, Large 5M+, Medium 1M+, Regular) — —
snapshot_timestamp DateTime When this snapshot was captured — —
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. — —

Sample data

CSV Excel

Last 12 months of jackpot pools, full schema. Tracks roll-overs and payouts for the major exotic pools.

SELECT * FROM renavon_exports.hkjc_jackpots 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
Jan 2026 – 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 Pro

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
1,000,000 rows/month included

Included Datasets

HKJC Barrier Trials
HKJC Dividends
HKJC Horses Database
HKJC Jackpots this dataset
HKJC Jockey Rankings
HKJC Pool Investments
HKJC Race Results
HKJC Race Results (Core)
HKJC Race Catalog
HKJC Racing Changes
HKJC Sectional Times
HKJC Track Conditions
HKJC Trainer Rankings
US$149
per month
SAVE 17%
US$1490
per year
(US$124.17/month)

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

Included Datasets

HKJC Barrier Trials
HKJC Dividends
HKJC Horses Database
HKJC Jackpots this dataset
HKJC Jockey Rankings
HKJC Odds Movements (tick-level)
HKJC Closing Odds
HKJC Pool Investments
HKJC Race Results
HKJC Race Results (Core)
HKJC Race Catalog
HKJC Racing Changes
HKJC Sectional Times
HKJC Track Conditions
HKJC Trainer Rankings
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