hkjc_marksix_results
Hong Kong Mark Six lottery results and winning numbers history
Download a file
CSV · Excel · Parquet · JSON. Sample below.
Get sample 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.
Create a free account to access the complete dataset
Dataset Statistics
You're viewing a 20-row preview. Subscribe to unlock the full interactive data explorer, downloads, and SQL access.
| {'name': 'draw_record_id', 'type': 'String'} | {'name': 'draw_id', 'type': 'String'} | {'name': 'draw_year', 'type': 'Int32'} | {'name': 'draw_number_in_year', 'type': 'Int32'} | {'name': 'draw_number', 'type': 'Int32'} | {'name': 'open_date', 'type': 'String'} | {'name': 'close_date', 'type': 'String'} | {'name': 'draw_date', 'type': 'String'} | {'name': 'draw_time', 'type': 'String'} | {'name': 'draw_type', 'type': 'String'} | {'name': 'draw_type_name', 'type': 'String'} | {'name': 'status', 'type': 'String'} | {'name': 'has_results', 'type': 'UInt8'} | {'name': 'is_snowball_draw', 'type': 'UInt8'} | {'name': 'snowball_code', 'type': 'String'} | {'name': 'snowball_name_en', 'type': 'String'} | {'name': 'snowball_name_ch', 'type': 'String'} | {'name': 'ball_1', 'type': 'Nullable(Int32)'} | {'name': 'ball_2', 'type': 'Nullable(Int32)'} | {'name': 'ball_3', 'type': 'Nullable(Int32)'} | {'name': 'ball_4', 'type': 'Nullable(Int32)'} | {'name': 'ball_5', 'type': 'Nullable(Int32)'} | {'name': 'ball_6', 'type': 'Nullable(Int32)'} | {'name': 'extra_ball', 'type': 'Nullable(Int32)'} | {'name': 'total_sales', 'type': 'Nullable(Float64)'} | {'name': 'jackpot_amount', 'type': 'Nullable(Float64)'} | {'name': 'unit_bet', 'type': 'Nullable(Float64)'} | {'name': 'estimated_prize', 'type': 'Nullable(Float64)'} | {'name': 'first_prize_dividend', 'type': 'Nullable(Float64)'} | {'name': 'is_jackpot_won', 'type': 'UInt8'} | {'name': 'draw_month', 'type': 'Nullable(UInt8)'} | {'name': 'draw_day_of_week', 'type': 'Nullable(UInt8)'} | {'name': 'draw_day_name', 'type': 'Nullable(String)'} | {'name': 'updated_at', 'type': 'DateTime'} |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Data Dictionary
Not ready to subscribe? 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 TeamThis is a free dataset!
Create a free account to get full access - no credit card required.