hkjc_marksix_results
Hong Kong Mark Six lottery results and winning numbers history
Download a file
The complete dataset. No account needed.
Download full CSVQuery with SQL
DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.
Open connection detailsConnect to AI
MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.
See setupComplete history of Hong Kong Mark Six lottery draws with winning numbers, extra ball, jackpot amounts, and prize payouts. Search past results, analyze number frequency patterns, and track snowball jackpots. Updated after every draw (Tuesday, Thursday, Saturday). Each draw includes all six winning numbers plus the extra number, total sales, and first division prize amounts.
The complete dataset is free to download below. No account needed.
The evidence
Schema & column quality (32 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| draw_record_id | String | Unique record identifier | — | — |
| draw_id | String | Official draw identifier (e.g., '202694N') | 100.0% | 4,383 |
| draw_year | Int32 | Full year of draw (e.g., 2024) | — | — |
| draw_number_in_year | Int32 | Sequential draw number within the year | 100.0% | 155 |
| open_date | String | Date betting opened for this draw | — | — |
| close_date | String | Date betting closed | — | — |
| draw_date | String | Date of the lottery draw | 100.0% | 4,383 |
| draw_time | String | Time of the draw (extracted from draw_date, format HH:MM:SS) | — | — |
| draw_type_name | String | Human-readable draw type (Regular Draw, Snowball Draw) - derived from snowball_code | — | — |
| status | String | Draw status — the export carries completed draws only, so this is always 'Result' | — | — |
| has_results | UInt8 | Whether results have been declared (true when status='Result') | — | — |
| is_snowball_draw | UInt8 | Whether this was a snowball draw | — | — |
| snowball_code | String | Snowball identifier if applicable | — | — |
| snowball_name_en | String | Snowball name in English | — | — |
| snowball_name_ch | String | Snowball name in Chinese | — | — |
| ball_1 | Nullable(Int32) | First winning ball number (1-49) | — | — |
| ball_2 | Nullable(Int32) | Second winning ball number (1-49) | — | — |
| ball_3 | Nullable(Int32) | Third winning ball number (1-49) | — | — |
| ball_4 | Nullable(Int32) | Fourth winning ball number (1-49) | — | — |
| ball_5 | Nullable(Int32) | Fifth winning ball number (1-49) | — | — |
| ball_6 | Nullable(Int32) | Sixth winning ball number (1-49) | — | — |
| extra_ball | Nullable(Int32) | The extra (bonus) ball number (1-49) | — | — |
| total_sales | Nullable(Float64) | Total ticket sales for the draw (HKD) | — | — |
| jackpot_amount | Nullable(Float64) | Jackpot pool amount (HKD) | — | — |
| unit_bet | Nullable(Float64) | Cost per unit bet (HKD) | — | — |
| first_prize_dividend | Nullable(Float64) | First prize dividend amount per winning entry (HKD) | — | — |
| is_jackpot_won | UInt8 | Whether first prize was won | — | — |
| draw_month | Nullable(UInt8) | Month of draw (1-12) | — | — |
| draw_day_of_week | Nullable(UInt8) | Day of week (1=Monday, 7=Sunday) | — | — |
| draw_day_name | Nullable(String) | Day name (Monday, Tuesday, etc.) | — | — |
| updated_at | DateTime | Timestamp when record was last updated | — | — |
| 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. | — | — |
Full historical Mark Six lottery results, no row cap. The dataset is small enough to ship in its entirety as the sample.
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