Racing data
HKJC Jackpots
HKJC Jackpots holds 97,338 records from the Hong Kong Jockey Club's published jackpot figures, covering January 2026 to November 2026, and is updated hourly.
Hong Kong horse racing Six Up and Triple Trio jackpots
hkjc_jackpots
Rows
97,338
Coverage
January 2026 to November 2026
Columns
16
Latest data
2026-11-14
Sample
| race_date | venue_code | race_year | race_month | jackpot_id | pool_type | pool_category | estimated_dividend | carryover_amount | leg_number | leg_races | merged_pool_id | jackpot_tier | snapshot_timestamp | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-12T06:10:07+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-12 06:10:07 | 2026-11-12 06:10:07 | cf26dea675033dcb5a924a851cc87a29 |
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-12T08:20:27+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-12 08:20:27 | 2026-11-12 08:20:27 | 33ad1fc8741cb124f5ea95a5ec521995 |
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-12T08:50:59+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-12 08:50:59 | 2026-11-12 08:50:59 | 5ed7f7be77933999b7ee8655f6488a2e |
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-13T01:40:12+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-13 01:40:12 | 2026-11-13 01:40:12 | d12d13ec71a5db4d9290d5b01f318bc7 |
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-13T02:11:38+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-13 02:11:38 | 2026-11-13 02:11:38 | bbad8151fe52399ae7f368a0e2ff4e4a |
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-13T03:30:16+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-13 03:30:16 | 2026-11-13 03:30:16 | 17535633139b12ea579d029fb9614381 |
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-13T04:00:39+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-13 04:00:39 | 2026-11-13 04:00:39 | b6bf8a6ed912361d245cd9a69d8f0117 |
| 2026-11-14 00:00:00 | ST | 2026 | 11 | ST_2026-11-14_DT_2026-11-13T04:10:37+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-11-13 04:10:37 | 2026-11-13 04:10:37 | ff4ce9c5772264ed459249d2bcee9fe0 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| race_date | date and time | Date of the race meeting |
| venue_code | text | Venue code (ST=Sha Tin, HV=Happy Valley) |
| race_year | number | Year of the meeting |
| race_month | number | Month of the meeting (1-12) |
| jackpot_id | text | Unique jackpot identifier |
| pool_type | text | Pool type (SixUP, TT=Triple Trio) |
| pool_category | text | Pool category grouping |
| estimated_dividend | number | Estimated dividend/jackpot amount (HKD) |
| carryover_amount | number | Carryover amount brought forward into the pool (HKD); empty when the pool is fresh with no carryover |
| leg_number | number | Current leg number in multi-leg pool |
| leg_races | text | 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 | text | Reference to a combined pool where the Jockey Club merges this pool with another; empty for standalone pools |
| jackpot_tier | text | Jackpot size tier (Mega 10M+, Large 5M+, Medium 1M+, Regular) |
| snapshot_timestamp | date and time | When this snapshot was captured |
| 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. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.hkjc_jackpots LIMIT 10
Ways to get this table
Free sample
Last 12 months of jackpot pools, full schema. Tracks roll-overs and payouts for the major exotic pools.
Free
Download the sampleRacing Pass Pro
A rolling 24-month window, currently from November 2024with 13 other tables
US$1,490/yr
billed yearly · or US$149/mo Racing Pass Pro
Subscribe to Racing Pass ProPrices and checkout are handled entirely by Renavon. HKJC Guru does not process these payments.