6

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.

migrated from datascience.stackexchange.com Oct 10 '14 at 17:44

This question came from our site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field.

  • 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 B. Oct 9 '14 at 18:31
  • I believe only moderators can move posts. – MrMeritology Oct 9 '14 at 20:33
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.

  • Nice! Thanks for finding this, with the coding example. Will help me, too. – MrMeritology Oct 9 '14 at 22:45
  • Could you please include details about what columns these datasets have? Thanks! – Nicolas Raoul Oct 14 '14 at 5:31
  • Detailed information about one of the collection: ahschulz.de/enron-email-data – Mike B. Oct 14 '14 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? – displayname Feb 6 '18 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.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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