Canada Lotto 6/49 Historical Draws

Lotto 6/49 Canada – Complete Archive (1982–2025)

4,363 Draws | 1982-06-12 to 2025-11-12

Instant Digital Download – CSV + SQL

After 40+ years of collecting, cleaning, and verifying every single draw — this is the most complete Lotto 6/49 dataset I know of.
LOTTOMETRICS, Est. 2006

WHAT YOU GET (2 Files + Docs)

• DRAWSSELL.csv
→ Clean CSV – Open instantly in Excel, Google Sheets, Python, R

• DRAWSSELL_H2.sql
→ Full SQL – Import into MySQL, PostgreSQL, SQLite, H2, DBeaver

Bonus:
• README.txt – 30-second import guide
• LICENSE.txt – Personal use only

TABLE STRUCTURE
DRAWID → Draw number (1–4363)
DRAWDAT → Date (YYYY-MM-DD)
NUM1–NUM6 → Main balls (01–49, zero-padded)
NUM7 → Bonus ball (01–49, zero-padded)

Example CSV Row (Extra Padding)
,DRAWID,,,DRAWDATE,,,NUM1,,,NUM2,,,NUM3,,,NUM4,,,NUM5,,,NUM6,,,NUM7,
,1,,,1982-06-12,,,03,,,11,,,12,,,14,,,41,,,43,,,13,

Example H2 Database Import with Schema
CREATE CACHED TABLE "PUBLIC"."DRAWSSELL"(
"DRAWID" INTEGER SELECTIVITY 100,
"DRAWDATE" DATE SELECTIVITY 100,
"NUM1" CHARACTER(2) SELECTIVITY 3,
"NUM2" CHARACTER(2) SELECTIVITY 3,
"NUM3" CHARACTER(2) SELECTIVITY 4,
"NUM4" CHARACTER(2) SELECTIVITY 4,
"NUM5" CHARACTER(2) SELECTIVITY 3,
"NUM6" CHARACTER(2) SELECTIVITY 3,
"NUM7" CHARACTER(2) SELECTIVITY 4

);

-- 4363 +/- SELECT COUNT(*) FROM PUBLIC.DRAWSSELL;
INSERT INTO "PUBLIC"."DRAWSSELL" VALUES (1, DATE '1982-06-12', '03', '11', '12', '14', '41', '43', '13'),

WHY THIS DATA?

• 40+ years of history – from the very first draw
• No missing draws (to the best of my knowledge)
• Clean, padded, analysis-ready
• Zero setup – works immediately

PERFECT FOR

• Lottery analysts
• Data scientists
• Pattern hunters
• Python / R model builders
• Anyone tired of broken scrapers

DISCLAIMER (Please Read)
"To the best of my knowledge, after decades of personal collection and cross-checking, this is the most accurate archive available. However, I cannot guarantee 100% perfection. A draw may be missing or contain a transcription error. This is not an official lottery authority product. Use at your own risk. No refunds. No liability."

LICENSE

Personal Use Only
You may not resell, redistribute, or republish this data.
Full terms in LICENSE.txt.

Instant Download After Purchasedomains.gumroad.com
Powered by Gumroad – secure, fast, trusted.

Questions?
mrlottometrics@lottometrics.com

© 2025 LOTTOMETRICS • Est. 2006
Not affiliated with any lottery authority.