About
On the 29th of July 2018, Emma Best published on her website the copy of 11k+ wikileaks Twitter DM : https://emma.best/2018/07/29/11000-messages-from-private-wikileaks-chat-released/
Here is a data extraction and wrangling of this corpus, to make it easily searchable, extractable and sharable.
How to use this page
- Every “link.csv” is a downloadable csv.
- You can search and order every table. Results of the search are downloadable as csv or can be copied in the clipboard.
- You can zoom in the time series by selecting the date range. You can also use the selector beside to choose this range. Double click to reset the settings.
- Under each dynamic plot, you can find a static plot by clicking on “Static plost”.
This page may not work as expected on Internet Explorer / Edge. Please switch to another browser if you have trouble reading this page.
Data format
- Every csv is encoded in UTF8
- You can find these csv in JSON format on the GitHub repo
Browse through the content
- Home has the full dataset, to search and download.
- Timeline has a series of time-related content: notably DMs by years, and daily count of DMs.
- Users holds the dataset for each users.
- mentions_urls holds the extracted mentions and urls
- methodo contains the methodology used for the data wrangling
About DMConversationEntry
As documented in the methodo, the DMConversationEntry have no date in the dataset, hence the date is inferred from the directly preceeding date, so these entries might not be correct when it comes to date.
Browse through the content
- Home has the full dataset, to search and download
- Timeline has a series of time-related content: notably DMs by years, and daily count of DMs
- Users holds the dataset for each users
- mentions_urls holds the extracted mentions and urls
- text_mining contains a series of text-frequency based analysis (mainly most frequent words).
Mentions
DMs that contain a mention to a Twitter account.
A dataset with 4 columns
- mention: the mentioned account
- text: extracted text
- date: the date
- user: user who sent the dm
Count of the mentions:
A dataset with 2 columns
- mention: the mention
- n: number of DMs
Urls
Extracted links, (starting with http
).
A dataset with 4 columns
- url: the found url
- text: extracted text
- date: the date
- user: user who sent the dm