the above information is also available in pdf format here: https://www.documentcloud.org/documents/3192131-podesta-stats-20-rev.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) - advertisement - 




pdf: (file uploading - check back) 




[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 1.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)).
map to wikileaks podesta emails: alphabetical index by sender (version 20 updated 10/27/16)
noauthor