7

For the purpose of my research, I need the Enron Email Dataset. According to the project's official web-site, there is an archive of emails represented in the set of separate TXT-files, but the problem is this archive is not well organized and requires a lot of preparation work in order to be able to proceed the data.

I looked for some ready-to-use well-organized archive of Enron Email Dataset in MySQL, but the only collection I found is the dump of MySQL database, which contains only two columns — message ID and content, no sender/receiver column, no title column. My question is there any well and completely organized Enron Email Dataset in MySQL database format, where I can execute some SQL-queries according to sender/receiver, where it is easy to retrieve a message title etc.

Thanks.

2
  • So, let's move the question to this community. Should I do it manually (create new & delete old) or moderators can just move the question between the sites?
    – Mike
    Oct 9, 2014 at 18:31
  • I believe only moderators can move posts. Oct 9, 2014 at 20:33

2 Answers 2

8

After some additional search, I found the worked link among of lots, which point to 404 pages.
The worked ones are:
https://s3.amazonaws.com/rjurney_public_web/images/enron.mysql.5.5.20.sql.gz
http://www.ahschulz.de/pub/R/data/enron-mysqldump_v5.sql.gz

Detailed information about these datasets:
http://hortonworks.com/blog/the-data-lifecycle-part-one-avroizing-the-enron-emails/
http://www.ahschulz.de/enron-email-data/

P.S. Don't know why, but for me the download process was very slow.

6
  • Nice! Thanks for finding this, with the coding example. Will help me, too. Oct 9, 2014 at 22:45
  • Could you please include details about what columns these datasets have? Thanks! Oct 14, 2014 at 5:31
  • Detailed information about one of the collection: ahschulz.de/enron-email-data
    – Mike
    Oct 14, 2014 at 7:02
  • 1
  • Do you by any chance know if the emails in this data set contain fields like "hasReplied" or "hasForwarded"? For evaluation purpose I require the information if a user has replied or forwarded a particular message - is this in the data set? Feb 6, 2018 at 12:19
4

You might be able to create an SQL DB by using FERC Enron XERA web application: http://fercenron.omega-caci.com/default.html (user guide).

You'd use the search feature of XERA based on fields, and then export the result to a delimited file, then convert to SQL database for additional queries.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.