賽馬數據 免費
HKJC Mark Six Results
Hong Kong Mark Six lottery results and winning numbers history
hkjc_marksix_results
Draws
4,392
涵蓋期間
1993年1月至2026年9月
欄位數目
32
最新數據
2026-09-26
樣本
| draw_record_id | draw_id | draw_year | draw_number_in_year | open_date | close_date | draw_date | draw_time | draw_type_name | status | has_results | is_snowball_draw | snowball_code | snowball_name_en | snowball_name_ch | ball_1 | ball_2 | ball_3 | ball_4 | ball_5 | ball_6 | extra_ball | total_sales | jackpot_amount | unit_bet | first_prize_dividend | is_jackpot_won | draw_month | draw_day_of_week | draw_day_name | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10e6eb77e21bd055a9445ebdf1dbbbf2 | 2026104N | 2026 | 104 | 2026-09-22+08:00 | 2026-09-26T21:15:00+08:00 | 2026-09-26+08:00 | 08:00 | Snowball Draw | Result | 1 | 1 | MAF | Mid-Autumn Festival Snowball | 中秋金多寶 | 4 | 28 | 31 | 44 | 47 | 48 | 19 | 210283391.0 | 50000000.0 | 10.0 | 68000000.0 | 0 | 9 | 6 | Saturday | 2026-09-28 02:01:30 | 10e6eb77e21bd055a9445ebdf1dbbbf2 |
| 93e64c81317d12d78497dd7d30d12ee2 | 2026103N | 2026 | 103 | 2026-09-19+08:00 | 2026-09-22T21:15:00+08:00 | 2026-09-22+08:00 | 08:00 | Regular Draw | Result | 1 | 0 | 2 | 34 | 35 | 43 | 45 | 46 | 41 | 52277424.0 | 6246745.0 | 10.0 | 10000000.0 | 0 | 9 | 2 | Tuesday | 2026-09-28 02:01:30 | 93e64c81317d12d78497dd7d30d12ee2 | |||
| 8170a5f7c4f44eaf0bbab3c70fecbb53 | 2026102N | 2026 | 102 | 2026-09-17+08:00 | 2026-09-19T21:15:00+08:00 | 2026-09-19+08:00 | 08:00 | Regular Draw | Result | 1 | 0 | 5 | 8 | 11 | 14 | 19 | 31 | 21 | 47772644.0 | 8000000.0 | 10.0 | 13000000.0 | 0 | 9 | 6 | Saturday | 2026-09-28 02:01:30 | 8170a5f7c4f44eaf0bbab3c70fecbb53 | |||
| 967501c5e1765bbcff332f5e8540e385 | 2026101N | 2026 | 101 | 2026-09-15+08:00 | 2026-09-17T21:15:00+08:00 | 2026-09-17+08:00 | 08:00 | Regular Draw | Result | 1 | 0 | 4 | 17 | 31 | 41 | 47 | 48 | 8 | 41936678.0 | 0.0 | 10.0 | 8000000.0 | 0 | 9 | 4 | Thursday | 2026-09-28 02:01:30 | 967501c5e1765bbcff332f5e8540e385 | |||
| cf6539d7c8d830294b41c8867dafcf8b | 2026100N | 2026 | 100 | 2026-09-12+08:00 | 2026-09-15T21:15:00+08:00 | 2026-09-15+08:00 | 08:00 | Regular Draw | Result | 1 | 0 | 2 | 5 | 6 | 9 | 29 | 30 | 19 | 53144434.0 | 8000000.0 | 10.0 | 13000000.0 | 0 | 9 | 2 | Tuesday | 2026-09-28 02:01:30 | cf6539d7c8d830294b41c8867dafcf8b | |||
| 5a81e6f211fc05036f3eb1970a196cbc | 202699N | 2026 | 99 | 2026-09-10+08:00 | 2026-09-12T21:15:00+08:00 | 2026-09-12+08:00 | 08:00 | Regular Draw | Result | 1 | 0 | 9 | 18 | 24 | 33 | 40 | 47 | 11 | 42599303.0 | 1523334.0 | 10.0 | 8000000.0 | 0 | 9 | 6 | Saturday | 2026-09-28 02:01:30 | 5a81e6f211fc05036f3eb1970a196cbc | |||
| 5d984f7a610cbf652ec75a45eb5c8e6c | 202698N | 2026 | 98 | 2026-09-08+08:00 | 2026-09-10T21:15:00+08:00 | 2026-09-10+08:00 | 08:00 | Regular Draw | Result | 1 | 0 | 22 | 23 | 31 | 32 | 35 | 45 | 34 | 40144663.0 | 0.0 | 10.0 | 8000000.0 | 0 | 9 | 4 | Thursday | 2026-09-28 02:01:30 | 5d984f7a610cbf652ec75a45eb5c8e6c | |||
| eeb811ca3879754c1538f6bb9ad06cef | 202697N | 2026 | 97 | 2026-09-05+08:00 | 2026-09-08T21:15:00+08:00 | 2026-09-08+08:00 | 08:00 | Regular Draw | Result | 1 | 0 | 9 | 23 | 28 | 29 | 35 | 41 | 38 | 41596716.0 | 0.0 | 10.0 | 8000000.0 | 0 | 9 | 2 | Tuesday | 2026-09-28 02:01:30 | eeb811ca3879754c1538f6bb9ad06cef |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| draw_record_id | text | Unique record identifier |
| draw_id | text | Official draw identifier (e.g., '202694N') |
| draw_year | number | Full year of draw (e.g., 2024) |
| draw_number_in_year | number | Sequential draw number within the year |
| open_date | text | Date betting opened for this draw |
| close_date | text | Date betting closed |
| draw_date | text | Date of the lottery draw |
| draw_time | text | Time of the draw (extracted from draw_date, format HH:MM:SS) |
| draw_type_name | text | Human-readable draw type (Regular Draw, Snowball Draw) - derived from snowball_code |
| status | text | Draw status — the export carries completed draws only, so this is always 'Result' |
| has_results | number | Whether results have been declared (true when status='Result') |
| is_snowball_draw | number | Whether this was a snowball draw |
| snowball_code | text | Snowball identifier if applicable |
| snowball_name_en | text | Snowball name in English |
| snowball_name_ch | text | Snowball name in Chinese |
| ball_1 | number | First winning ball number (1-49) |
| ball_2 | number | Second winning ball number (1-49) |
| ball_3 | number | Third winning ball number (1-49) |
| ball_4 | number | Fourth winning ball number (1-49) |
| ball_5 | number | Fifth winning ball number (1-49) |
| ball_6 | number | Sixth winning ball number (1-49) |
| extra_ball | number | The extra (bonus) ball number (1-49) |
| total_sales | number | Total ticket sales for the draw (HKD) |
| jackpot_amount | number | Jackpot pool amount (HKD) |
| unit_bet | number | Cost per unit bet (HKD) |
| first_prize_dividend | number | First prize dividend amount per winning entry (HKD) |
| is_jackpot_won | number | Whether first prize was won |
| draw_month | number | Month of draw (1-12) |
| draw_day_of_week | number | Day of week (1=Monday, 7=Sunday) |
| draw_day_name | text | Day name (Monday, Tuesday, etc.) |
| updated_at | date and time | Timestamp when record was last updated |
| 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_marksix_results LIMIT 10取得此數據表的方式
免費樣本
Full historical Mark Six lottery results, no row cap. The dataset is small enough to ship in its entirety as the sample.
免費
下載樣本