Wikileaks / 14.200 cables

Team Members

Lonneke, Bernhard, Esther, Catalina (Cameran) (Michael)



To do: Look up and list some of the core claims

- made by Assange

- about the strategic timing of leaks

- geography of cables

Method as intervention (i.e. journalistic)

- journalistic framing through engines:

- wikileaks impacts search engine optimization:

(don't know whether they belong here or under the claims...)

To do

Includes listing and analysing related projects (i.e. engines, visualizations made with the cables).

Research Question

Meta question: How to make sense of the content of the Big Data Wikileaks cables?

Does the timing of the release date of cables suport the claim that the cables are strategically leaked for highest impact in current events?

Is it true that the cables are released in geographical batches? Or topic batches?

If so, what are the issues addressed in these cables and do they resonate online?

How do the cables render visible different geographies of countries that are referenced together?

Steps in Method

Data categories in the Cables:

Time: 1. Time of the leak 2. Creation date of cable

Geography: 1. Cities of from/to/cc'ed embassies 2. TAGS (countries)

TAGS: 1. Subject tags 2. Country tags 3. Program tags 4. Organization tags 5. Embassadies and Consulates 6. Unknown or self-descriptive tags



Leaks per day (height by nr of results in Yahoo x cables released that day)


Peaks in Twitter activity

Correlate release date of leaks with activity peaks on Twitter during the Arab revolutions.




Worldmap leaks per embassy: Expresses embassies, node size; number of leaks, color; resonance on yahoo

Co-word analyis subject tags

Co-word analysis Program tags

Co-occurence Country tags geospatial: Size= number of leaks; colour = degree

Co-occurence Country tags


  • StateDeptCable1.png
  • StateDeptCable2.png
This project is part of the DmiSummer2011Projects *
I Attachment Action Size Date Who Comment
Cables_Co-words_Subjects.pdfpdf Cables_Co-words_Subjects.pdf manage 46 K 01 Jul 2011 - 13:16 LonnekeVanDerVelden Cables cor-wordanalysis of subjects
Cables_wikileaks_co-word_Program.pdfpdf Cables_wikileaks_co-word_Program.pdf manage 26 K 01 Jul 2011 - 13:24 LonnekeVanDerVelden Co-word analysis program
Cables_wikileaks_co-word_countriesTAGS.pdfpdf Cables_wikileaks_co-word_countriesTAGS.pdf manage 63 K 01 Jul 2011 - 13:43 LonnekeVanDerVelden cables co-word countries tags
Screen_shot_2011-06-30_at_11.12.03_PM.pngpng Screen_shot_2011-06-30_at_11.12.03_PM.png manage 72 K 30 Jun 2011 - 21:13 EstherWeltevrede  
Screen_shot_2011-06-30_at_17.48.22_.pngpng Screen_shot_2011-06-30_at_17.48.22_.png manage 85 K 30 Jun 2011 - 19:48 EstherWeltevrede  
Screen_shot_2011-07-01_at_12.46.45_PM.pngpng Screen_shot_2011-07-01_at_12.46.45_PM.png manage 74 K 01 Jul 2011 - 10:47 EstherWeltevrede  
StateDeptCable1.pngpng StateDeptCable1.png manage 236 K 30 Jun 2011 - 19:50 EstherWeltevrede  
StateDeptCable2.pngpng StateDeptCable2.png manage 214 K 30 Jun 2011 - 19:51 EstherWeltevrede  
average_number_hits_per_cable_of_classification.pngpng average_number_hits_per_cable_of_classification.png manage 26 K 01 Jul 2011 - 12:54 LonnekeVanDerVelden average number of hits per type of cable
world_cooc_tag.pdfpdf world_cooc_tag.pdf manage 65 K 01 Jul 2011 - 13:41 LonnekeVanDerVelden World co-occurence
worldmap_co-word_countries_gs.pdfpdf worldmap_co-word_countries_gs.pdf manage 380 K 01 Jul 2011 - 14:06 LonnekeVanDerVelden Worldmap co-word countries
worldmap_leaks_per_embassy_gs.pdfpdf worldmap_leaks_per_embassy_gs.pdf manage 347 K 01 Jul 2011 - 14:02 LonnekeVanDerVelden world map leaks per embassy
Topic revision: r8 - 01 Jul 2011, LonnekeVanDerVelden
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback