Crunching the Ashley Madison Leak

2015-08-12

So, this Ashley Madison data leak. There’s sites where you can look up email addresses, but there’s other info too if you know how to process it in a database! Some interesting numbers I crunched last night:

• Over 1000 profiles in the V8G area.
• Over 86% are male.
• Over 66% are listed as currently in relationships (on the flipside, 33% are single!)

Stats!

Editor’s note (2026): this was a quick evening of SQL against the leaked dump — V8G is Terrace, BC. I kept the views and import scripts (terrace.sql, terrace_basics.sql, terrace_cc.sql). A good early example of the kind of data-warehouse spelunking I ended up doing professionally.