Which countries are most mentioned in the cables published by Wikileaks?

December 9 data

After improving the method and also release of new data (since the last post, below) , here is the updated list for the top 110 countries. Note that this data, while may have indications regarding the cables, also may reflect priorities upon which certain cables are chosen to be published by wikileaks. The data is as of December 10 2010 (the third column is the percentage)

1	Iran	6844	11.44
2	Russia	4067	6.80
3	France	3836	6.41
4	China	2732	4.57
5	Afghanistan	2538	4.24
6	Spain	2502	4.18
7	Pakistan	2422	4.05
8	Iraq	2059	3.44
9	Brazil	1772	2.96
10	Israel	1663	2.78
11	United Kingdom	1621	2.71
12	Saudi Arabia	1267	2.12
13	Venezuela	1040	1.74
14	Turkey	996	1.66
15	Syria	745	1.24
16	Palestinian territories	682	1.14
17	Georgia	662	1.11
18	Lebanon	653	1.09
19	United Arab Emirates	632	1.06
20	North Korea	603	1.01
21	Ukraine	576	0.96
22	Egypt	561	0.94
23	Germany	537	0.90
24	Bolivia	529	0.88
25	Algeria	474	0.79
26	Cuba	466	0.78
27	Yemen	424	0.71
28	India	400	0.67
29	Morocco	392	0.66
30	Italy	389	0.65
31	Libya	383	0.64
32	Mexico	381	0.64
33	Kuwait	376	0.63
34	Serbia	375	0.63
35	Colombia	374	0.62
36	Argentina	355	0.59
37	Qatar	353	0.59
38	Poland	343	0.57
39	Sweden	225	0.38
40	Tunisia	202	0.34
41	Azerbaijan	201	0.34
42	Japan	189	0.32
43	Sudan	181	0.30
44	Nigeria	177	0.30
45	South Africa	172	0.29
46	Canada	169	0.28
47	Jordan	165	0.28
48	Somalia	158	0.26
49	Haiti	154	0.26
50	Zimbabwe	152	0.25
51	Armenia	142	0.24
52	Mali	139	0.23
53	Uganda	135	0.23
54	Austria	130	0.22
55	Netherlands	127	0.21
56	Niger	126	0.21
57	Croatia	120	0.20
58	Rwanda	114	0.19
59	Bulgaria	112	0.19
60	Oman	105	0.18
61	Belgium	103	0.17
62	Paraguay	98	0.16
63	Macedonia	86	0.14
64	Bosnia and Herzegovina	84	0.14
65	Djibouti	78	0.13
66	Mauritania	78	0.13
67	Honduras	78	0.13
68	Kazakhstan	77	0.13
69	Kyrgyzstan	77	0.13
70	Burkina Faso	76	0.13
71	Tajikistan	67	0.11
72	Ireland	65	0.11
73	Senegal	65	0.11
74	Uzbekistan	64	0.11
75	Angola	64	0.11
76	Bahrain	62	0.10
77	Chile	62	0.10
78	Chad	61	0.10
79	Cyprus	61	0.10
80	Switzerland	61	0.10
81	Turkmenistan	58	0.10
82	Republic of the Congo	58	0.10
83	Portugal	57	0.10
84	Western Sahara	57	0.10
85	Sri Lanka	56	0.09
86	South Korea	56	0.09
87	Panama	55	0.09
88	Belarus	52	0.09
89	Czech Republic	50	0.08
90	Ecuador	49	0.08
91	Greece	48	0.08
92	Australia	48	0.08
93	Hungary	46	0.08
94	Romania	43	0.07
95	Mongolia	35	0.06
96	Singapore	34	0.06
97	Burundi	31	0.05
98	Uruguay	31	0.05
99	Gabon	29	0.05
100	Costa Rica	28	0.05
101	Indonesia	28	0.05
102	Luxembourg	26	0.04
103	Malaysia	26	0.04
104	Cape Verde	25	0.04
105	Gambia	24	0.04
106	Hong Kong	24	0.04
107	Slovenia	17	0.03
108	Denmark	13	0.02
109	Fiji	10	0.02

pie chart as of Dec 9 2010

 

This is a d.i.y. report  on the number of times that a country is mentioned in the diplomatic cables published by Wikilieaks as of December 3 2010. The list is based on the Wikipedia article on sovereign nations. Note that this is just a computer generated report (obviously! ), and it is just based on the number of times that a certain country name (such as Canada) is mentioned in the report. However in order to better reflect the interest in a country one should also look for the name of important cities (i.e. Toronto etc…) to find out more. I guess that would be my next attempt . Moreover this is just based on the published data so far, therefore it is perhaps subject to change as more data becomes available (or not ? who knows ?), and it might partially show Wikileak’s priorities in publishing certain cables at this time. Comments are much appreciated.

Pie Chart of the Frequency of Citations for 33 Countries

And here is the list of countries mentioned least  once  (of total 28525 )

1	Iran	4454
2	Russia	2786
3	France	2759
4	Pakistan	1859
5	Afghanistan	1706
6	Israel	1193
7	Turkey	1028
8	Iraq	834
9	China	783
10	Germany	770
11	Palestinian territories	702
12	Brazil	551
13	Syria	493
14	India	478
15	Venezuela	413
16	United Arab Emirates	411
17	North Korea	410
18	Spain	395
19	Egypt	393
20	Lebanon	386
21	Georgia	365
22	Ukraine	327
23	Italy	297
24	Argentina	277
25	United Kingdom	262
26	Saudi Arabia	256
27	Cuba	207
28	Qatar	204
29	Canada	185
30	Azerbaijan	142
31	Mexico	141
32	Japan	126
33	Morocco	122
34	Sweden	121
35	Jordan	98
36	Yemen	91
37	Kuwait	90
38	Libya	85
39	Austria	76
40	Czech Republic	75
41	Haiti	70
42	Kazakhstan	67
43	Sudan	64
44	Colombia	63
45	Belgium	60
46	Sri Lanka	56
47	Turkmenistan	55
48	Ireland	53
49	Burkina Faso	52
50	Rwanda	49
51	Bahrain	48
52	Oman	47
53	Tunisia	47
54	Uzbekistan	45
55	Chad	44
56	Paraguay	44
57	Poland	42
58	South Korea	42
59	Djibouti	41
60	Greece	39
61	Cyprus	37
62	Kyrgyzstan	37
63	Republic of the Congo	37
64	Algeria	35
65	Croatia	35
66	Somalia	35
67	Romania	34
68	Uganda	32
69	Costa Rica	27
70	Hungary	27
71	Senegal	27
72	Burundi	26
73	Mauritania	26
74	Zimbabwe	25
75	Armenia	24
76	Cape Verde	24
77	Luxembourg	24
78	Mali	24
79	Netherlands	24
80	Niger	24
81	Bolivia	23
82	South Africa	23
83	Switzerland	23
84	Gambia	21
85	Serbia	20
86	Tajikistan	20
87	Bosnia and Herzegovina	19
88	Portugal	19
89	Australia	18
90	Bulgaria	17
91	Mongolia	16
92	Singapore	16
93	Gabon	15
94	Panama	15
95	Belarus	14
96	Uruguay	14
97	Chile	13
98	Indonesia	13
99	Malaysia	13
100	Slovenia	13
101	Ecuador	12
102	Nigeria	12
103	Western Sahara	11
104	Honduras	10
105	Hong Kong	10
106	Angola	9
107	Macedonia	9
108	Denmark	8
109	Fiji	8
110	Central African Republic	7
111	Lithuania	7
112	Madagascar	7
113	Sierra Leone	7
114	Ethiopia	6
115	Guinea	6
116	Liberia	6
117	Albania	5
118	Bangladesh	5
119	Grenada	5
120	Jersey	5
121	Kenya	5
122	New Zealand	5
123	Moldova	4
124	Nicaragua	4
125	Norway	4
126	Barbados	3
127	Benin	3
128	Cambodia	3
129	Cameroon	3
130	Mauritius	3
131	Dominican Republic	2
132	Eritrea	2
133	Estonia	2
134	Finland	2
135	Guatemala	2
136	Latvia	2
137	Mozambique	2
138	Slovakia	2
139	Trinidad and Tobago	2
140	Bermuda	1
141	Equatorial Guinea	1
142	Guam	1
143	Guinea-Bissau	1
144	Laos	1
145	Macau	1
146	Togo	1