Enron Email Dataset in MySQL

Question

For the purpose of my research, I need the Enron Email Dataset. According to the project's official website, 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 with 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, and 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.

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 09 '14 at 18:31

score 8 · Accepted Answer · answered Oct 09 '14 at 22:06

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.

answered Oct 09 '14 at 22:06

Mike

251
1
6

Nice! Thanks for finding this, with the coding example. Will help me, too. – MrMeritology Oct 09 '14 at 22:45
Could you please include details about what columns these datasets have? Thanks! – Nicolas Raoul Oct 14 '14 at 05:31
Detailed information about one of the collection: http://www.ahschulz.de/enron-email-data/ – Mike Oct 14 '14 at 07:02
1
Two more:
- UC Berkeley Enron Email Analysis
- Enron by Joel Pfeiffer from Purdue
– xiaohan2012 Oct 15 '15 at 10:24
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? – Stefan Falk Feb 06 '18 at 12:19
@displayname , unfortunately, I don't remember. But you can download the files and check it, it's one-minute check. – Mike Feb 06 '18 at 12:38

score 4 · Answer 2 · answered Oct 09 '14 at 20:32

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.

answered Oct 09 '14 at 20:32

MrMeritology

141
2

You could also look at this: http://orchestrate.io/blog/2014/07/17/using-orchestrates-graph-search-with-the-enron-emails/ – MrMeritology Oct 09 '14 at 20:37

Enron Email Dataset in MySQL

2 Answers2

Linked