How to read the Ashley Madison data?

To read or process the Ashley Madison data is fairly straight forward. The dataset comes with a suite of files. These are:

  • am_am.dump.gz
  • aminno_member.dump.gz
  • aminno_member_email.dump.gz
  • member_details.dump.gz
  • member_login.dump.gz
  • CreditCardTransactions.7z
  • README

Each of these files come with a PGP signature. You can use gunzip on a Mac (or unix platform) to extract the files. 7z files will require 7-Zip software on a Windows computer.

You will need MySQL software from Oracle to load this data. MySQL Community edition is free.

Top Cities by Users for Ashley Madison

Here’s are the Top 100 cities. It’s interesting that Singapore doesn’t feature on the list at all. The city-state had banned the site in the interest of the family. It looks like the ban worked. Sydney, New York and Toronto looks like a hotbed of infidelity.ashley_madison_top_cities1

  • São Paulo 374542
  • New York 268171
  • Sydney 251813
  • Toronto 222982
  • Santiago 218125
  • Melbourne 213847
  • Houston 186795
  • Los Angeles 181918
  • London 179129
  • Chicago 162444
  • Rio de Janeiro 156572
  • Madrid 135294
  • Bogotá 123559
  • Brisbane 118857
  • Brooklyn 110859
  • Miami 109505
  • Calgary 107021
  • San Antonio 99157
  • Dallas 97736
  • Brasília 97096
  • San Diego 94953
  • Perth 88754
  • Las Vegas 87720
  • Atlanta 86897
  • Philadelphia 86018
  • Edmonton 84971
  • Lima 82279
  • Phoenix 81913
  • Belo Horizonte 77834
  • 香港 77561
  • Austin 77432
  • Columbus 73377
  • Montreal 72304
  • Washington 71779
  • Jacksonville 70134
  • Denver 70043
  • Mississauga 69403
  • Curitiba 68916
  • Barcelona 68513
  • Dublin 65658
  • Ciudad de México 64516
  • Orlando 63549
  • San Francisco 62333
  • Minneapolis 61403
  • 灣仔 60674
  • Portland 60672
  • Charlotte 59686
  • Ottawa 58463
  • Seattle 56935
  • Indianapolis 56741
  • Buenos Aires 56701
  • Adelaide 55490
  • Tampa 55321
  • Cleveland 55031
  • Vancouver 52651
  • Fort Lauderdale 52554
  • Cincinnati 52055
  • Springfield 51644
  • Arlington 51345
  • Salvador 51069
  • San Jose 51043
  • Fort Worth 50976
  • Medellín 50308
  • Beverly Hills 49437
  • Bronx 49067
  • Boston 47951
  • Pittsburgh 47815
  • Kansas City 47793
  • Louisville 47239
  • Winnipeg 47202
  • Porto Alegre 47018
  • Saint Louis 46547
  • Richmond 46546
  • Buffalo 46532
  • North York 46223
  • Roma 46000
  • Johannesburg 45831
  • Sacramento 45777
  • Rochester 45216
  • Columbia 44541
  • Tucson 43293
  • Central 41900
  • Oklahoma City 41809
  • Salt Lake City 41773
  • El Paso 40914
  • Milwaukee 40392
  • Hamilton 40096
  • Cali 38847
  • Colorado Springs 38696
  • New Delhi 38620
  • London 38561
  • Brampton 38446
  • Madison 37813
  • Paris 37641
  • Saint Paul 37412
  • Cape Town 37001
  • Fortaleza 36922
  • Scarborough 35952
  • Albuquerque 35802
  • תל אביב יפו 35602