'

Massive White Supremacist Message Board Leak: How to Access and Interpret the Data

By Bellingcat Investigation Team

Today, the entire SQL database from Iron March, a now-defunct neo-Nazi / white supremacist message board, was posted onto the Internet Archive by the user “antifa-data“. You can access this data dump on the Internet Archive, and via a torrent file found here, or through this Magnet link.

Apparently the entire SQL database of the international neo-fascist Iron March forum (where Atomwaffen first properly organised). Contains info on all users, including user emails, IP address, and private messages, as well as all posts and comments. Enjoy. https://t.co/iq8D7IRorU pic.twitter.com/GTzz31HxGs

— Jake Hanrahan (@Jake_Hanrahan) November 6, 2019

This leak contained the entirety of the site’s information, including user names, registered emails, IP addresses of users, all of the forum’s public posts, and even the private messages between members. This message board was linked with the violent neo-Nazi group Atomwaffen Division, and has been widely studied by anti-extremist groups and researchers, such as the Southern Poverty Law Center (SPLC). The SPLC has also scraped all of the public posts from the site — well over 150,000 of them — and has been researching them over the last two years.

How to access the files

There are two ways to read and access the leak. The first is through the SQL database within the torrent, which can be accessed through an SQL database viewer (for example, MySQL Workbench or DB Browser for SQLite). However, this is quite arduous for the average user.

It is much easier to read through the exported spreadsheets that are included within the torrent file. The most important spreadsheets for analysis, and the most important columns within them, are:

core_members (All users)

  • Column A indicates the member ID, which is reflected across other spreadsheets as well.
  • Column B indicates the username within the …read more

    From:: Bellingcat