賽馬數據
HKJC Dividends
Hong Kong horse racing payouts and betting dividends
hkjc_dividends
行數
300,363
涵蓋期間
2001年1月至2026年10月
欄位數目
17
最新數據
2026-10-01
樣本
| race_id | race_date | venue_code | venue | race_number | pool_type | pool_category | is_multi_race_pool | winning_combination | dividend | return_per_dollar | race_class | distance | distance_category | track_condition | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | FIRST 4 | Exotic (3+ Horse) | 0 | 1,2,4,7 | 2609.0 | 260.9 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | f966b4e8b5eaa6ac1106f366d01f43dc |
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | FORECAST | Exotic (2 Horse) | 0 | 7,2 | 1233.0 | 123.3 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | 7899cc8dd8457e10af4859ee166242de |
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | PLACE | Win/Place | 0 | 1 | 18.0 | 1.8 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | 96ef0e018af6ecda8aa69f4de60b398e |
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | PLACE | Win/Place | 0 | 2 | 34.0 | 3.4 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | 87cfe4e957b2853f67bae5943ba61209 |
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | PLACE | Win/Place | 0 | 7 | 34.5 | 3.45 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | 92e0a0f60de0efa89075111b965eba15 |
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | QUARTET | Exotic (3+ Horse) | 0 | 7,2,1,4 | 75749.0 | 7574.9 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | 3c421ed6d75a2b1a475b64537107f991 |
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | QUINELLA | Exotic (2 Horse) | 0 | 2,7 | 554.5 | 55.45 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | 7723ec8f9c24fd6e16762350b8a0fdd6 |
| ST_20261001_R01 | 2026-10-01 00:00:00 | ST | Sha Tin | 1 | QUINELLA PLACE | Exotic (2 Horse) | 0 | 2,7 | 162.0 | 16.2 | Class 5 | 1200 | Sprint | GOOD TO FIRM | 2026-10-01 11:40:37 | 6e06185606af6f37a6853b2ca0c01e23 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| race_id | text | Unique race identifier (format: ST_20250928_R01) |
| race_date | date and time | Date of the race (YYYY-MM-DD) |
| venue_code | text | Venue code (ST=Sha Tin, HV=Happy Valley) |
| venue | text | Full venue name (Sha Tin / Happy Valley) |
| race_number | number | Race number within the meeting (1-11) |
| pool_type | text | Betting pool type (WIN, PLACE, QUINELLA, QUINELLA PLACE, FORECAST, TIERCE, TRIO, FIRST 4, QUARTET, DOUBLE, TREBLE, TRIPLE TRIO, SIX UP, etc.) |
| pool_category | text | Pool category: 'Win/Place', 'Exotic (2 Horse)', 'Exotic (3+ Horse)', 'Multi-Race', 'Other' |
| is_multi_race_pool | number | True if this is a multi-race pool (DOUBLE, TREBLE, TRIPLE TRIO, SIX UP) |
| winning_combination | text | Winning combination (horse numbers, comma-separated, e.g., '3,11,4' for TIERCE) |
| dividend | number | Dividend payout amount per $10 bet (HKD) |
| return_per_dollar | number | Return per $1 bet (dividend / 10) |
| race_class | text | Race class (Class 1-5, Group One/Two/Three, etc.) |
| distance | number | Race distance in meters |
| distance_category | text | Distance category (Sprint/Mile/Middle/Long) |
| track_condition | text | Track going/condition |
| 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_dividends LIMIT 10取得此數據表的方式
免費樣本
Last 6 months of pool dividends, full schema. Covers Win, Place, Quinella, Tierce, Trifecta, and the exotic pools.
免費
下載樣本