Unpacking 200GB of Paramilitary Chat Logs: A Data Dive

Over 200GB of chat logs and recordings from paramilitary groups like the American Patriots Three Percent (APIII) and Oath Keepers, obtained by an undercover operative, have been released. This massive dataset presents a significant challenge for researchers. The author plans a series of blog posts analyzing this data, starting with a script to import the Telegram chat exports (HTML files) into a SQL database for easier searching and analysis. The data includes various file types such as videos, voice messages, and documents, offering a rich, if unwieldy, source of information.