hkjc_marksix_results

FREE 4,365 rows

Hong Kong Mark Six lottery results and winning numbers history

No-code

Download a file

CSV · Excel · Parquet · JSON. Sample below.

Get sample CSV
For engineers

Query with SQL

DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.

Open connection details
Agent builders

Connect to AI

MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.

See setup

Complete 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.

Free dataset

Create a free account to unlock the complete dataset, SQL, and the API.

Create free account

The evidence

Data coverage
Jan 1993 – present
Volume
4,365 draws
Last updated
15 July, 2026 (6 days ago)
Schema & column quality (33 columns)
Column Type Description Populated Distinct
draw_record_id String Unique record identifier — —
draw_id String Official draw identifier (e.g., '25137A') — —
draw_year Int32 Full year of draw (e.g., 2024) — —
draw_number_in_year Int32 Sequential draw number within the year — —
open_date String Date betting opened for this draw — —
close_date String Date betting closed — —
draw_date String Date of the lottery draw — —
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 (e.g., 'Result', 'Selling') — —
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) — —
estimated_prize Nullable(Float64) Estimated first prize amount (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. — —

Sample data

CSV Excel

Full historical Mark Six lottery results, no row cap. The dataset is small enough to ship in its entirety as the sample.

SELECT * FROM renavon_exports.hkjc_marksix_results LIMIT 50 0.02s
Loading data… | Click a header to sort; drag headers to reorder.

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