賽馬數據
HKJC Jackpots
Hong Kong horse racing Six Up and Triple Trio jackpots
hkjc_jackpots
行數
83,976
涵蓋期間
2026年1月至2026年10月
欄位數目
16
最新數據
2026-10-01
樣本
| 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-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-28T05:40:05+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-28 05:40:05 | 2026-09-28 05:40:05 | b63ef9fb0feef1631f9745a60049d1dd |
| 2026-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-29T08:00:48+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-29 08:00:48 | 2026-09-29 08:00:48 | c71470fed69bf965a4ccac5214a8e12e |
| 2026-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-30T03:50:07+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-30 03:50:07 | 2026-09-30 03:50:07 | 317f457346a4d37fabce4827ed7afb93 |
| 2026-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-30T04:00:23+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-30 04:00:23 | 2026-09-30 04:00:23 | 426c21139451bfb0ca67ba02f8ca032f |
| 2026-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-30T04:10:19+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-30 04:10:19 | 2026-09-30 04:10:19 | 7e2a405040821ccf87d9ffd8942d43ba |
| 2026-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-30T04:21:01+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-30 04:21:01 | 2026-09-30 04:21:01 | af416c531ef6143947c7916364d6ef72 |
| 2026-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-30T04:31:38+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-30 04:31:38 | 2026-09-30 04:31:38 | 290e9de977e6a211cf87c088366b7c56 |
| 2026-10-01 00:00:00 | ST | 2026 | 10 | ST_2026-10-01_DT_2026-09-30T04:41:44+00:00 | DT | DT | 3000000 | — | 5 | 10,11 | — | Medium Jackpot (1M+) | 2026-09-30 04:41:44 | 2026-09-30 04:41:44 | 4b641567aea8ba2272eb14f7e54a5f54 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hkjc_jackpots LIMIT 10取得此數據表的方式
免費樣本
Last 12 months of jackpot pools, full schema. Tracks roll-overs and payouts for the major exotic pools.
免費
下載樣本