Navigating Wikileaks can be cumbersome and confusing. With a big picture map of the email database (structure and content) this can be easier. In this map by sender you can visually see what has been released and what has yet to be released including by individual sender.

::::::::

Map to Wikileaks Podesta Emails - Alphabetical Index by Sender (Version 20 Updated 10/27/16)

SUPPLEMENT TO: Navigating WikiLeaks: A Guide to the Podesta Emails

SERIES: Navigating WikiLeaks: A Guide to the Podesta Emails

This is the latest map to the Podesta Emails from Wikileaks (#20 released 10/27/16). You can see the map as of the 14th release on 10/21/16 here: MAP to Wikileaks Podesta Emails [Version 14 - Updated (10/24/16)]

In the prior map I provided a link by set sorted by alphabetical character for the sender's information. Here I will provide a single spreadsheet (excel file) for the entire set of 59,197. As of dump #20 there are 33,314 of the total emails, or 56%, which have been released.

This follows the below image of the general index (see image) where you can see the email number (8 digits) for the .eml file for each of the alphabetical sets. In addition to the spreadsheet, viewable online or downloadable (if you download you can use the links to either open the Wikileaks page for that email or download the original .eml file), I will also provide a PDF.

Using this map you can locate a particular user and see how many emails from that sender have been released and get a sense of how many more are left to come in future data dumps by Wikileaks. You can also locate a particular email and see if there are possible further emails in that chain by looking at the date and any gaps that follow that email. This is just one use of the map possible.

The above information is also available in PDF format here: https://www.documentcloud.org/documents/3192455-Podesta-20-Full-Index.html

The full database is provided in the following formats:

SPREADSHEET (EXCEL): https://1drv.ms/x/s!AjOxRSb63cIggwp9czI2Wfz6c8H7
(Due to the large file size I have had to utilize OneDrive for this file rather than Google Docs)

PDF: https://www.documentcloud.org/documents/3192771-Podesta-Emails-Full-Index-as-of-Podesta-20.html

[NOTE: By necessity this is a very long PDF document - nearly 500 pages - and I have tried to squeeze as much data as is useful per page while keeping the data on a single page format. You can enlarge the text by enlarging the Acrobat reader window.]

I have made this spreadsheet so that you can filter and sort the data. For example you can use the sender information (as received) using the "From" Column (L). In addition I have separated out the email address and the sender name into two columns at the end of the spreadsheet. What you will find is that some email addresses are associated with multiple user names. Sorting according to these columns will provide a means to determine all emails from a particular email address which will not be visible if you only use the alphabetical sort order of the file names. (This data is only in the spreadsheet. I kept it out of the PDF for presentation). I also include a number which corresponds to how many instances of each (the email address, the user name, and the third (last column) is the number of instances of the original "From" column (which combines both email address and user name). This extra data is essential to determining how many emails were sent from particular individuals rather than just one email address and vice versa.

The first column (C) is the actual file name - an eight digit number - of the original .eml file. This is followed by the second column (E) which contains the Email ID - this is a number assigned by Wikileaks and can be used in their search engine and is essential to identify the URL to the Wikileaks page for that email. The "Get" column will allow you to download the original .eml file from the Wikileaks database. The "Link" column will open the Wikileaks page to that email on their website.

The information is presented with a series of colored bands. This is useful for getting a visual image of the whole. Each different colored band represents a different set of emails by data dump (the number of the dump provided in the column of that name ). The DARK ORANGE bands stand out the most - as they represent emails that have yet to be released. This provides a quick visual guide to what is remaining and gaps within a particular sender's set of emails (the emails are listed from the first 00000001.eml to the last in numerical order - which generates a sort based on the first letter recognized from the "From" column - and this is thus listed alphabetically. This can be confusing, however, as while most names are listed with the first letter of the first name some use the first of the last name (i.e. Paul Begala can be found in the "B" set toward the beginning of the list when sorted by file name (number)).

Emails from John Podesta to other senders can be located in the J section beginning with the first known email from him at 00 through the last 00 .

Another factor that can be viewed using the graphic/visual feature of the map is the random distribution of the emails released. This appears to confirm Wikileaks claims that the emails are being released, by and large, in a random selection. Although it appears that some sets of emails or portions thereof may have been intentionally released within the larger random set for that data dump. Further analysis using this map can determine if and when (and thus what sender or emails were included) a more conscious inclusion of a particular set of emails was included in a particular dump or period of time.

Below is a visual representation of the first page of the Map. Open or download the PDF or SPREADSHEET linked above to see the entire Map.

Authors Website: http://www.facebook.com/charlie.grapski

Authors Bio:

One person cannot change it all - but it takes at least one person to change the world. I've tried at least.