Hi there, !
Today Wed 06/19/2013 Tue 06/18/2013 Mon 06/17/2013 Sun 06/16/2013 Sat 06/15/2013 Fri 06/14/2013 Thu 06/13/2013 Archives
487571 articles and 1721178 comments are archived on Rantburg.

Today: 55 articles and 140 comments as of 6:43.
Post a news link    Post your own article   
Area: WoT Operations    WoT Background    Non-WoT    Opinion        Posting Order
Double blasts kill 25 in Pakistan
Today's Headlines
Headline Comments [Views]
Page 6: Politix
2 15:44 Barbara [6478] 
4 13:58 3dc [6463] 
1 11:47 Jan [6457] 
Page 1: WoT Operations
4 18:35 Dale [6474]
8 19:35 JosephMendiola [6481]
0 [6468]
11 22:24 rjschwarz [6478]
2 18:15 trailing wife [6479]
0 [6461]
0 [6473]
0 [6460]
0 [6461]
0 [6459]
9 17:44 mojo [6475]
2 13:05 Barbara [6463]
0 [6490]
0 [6487]
0 [6462]
1 07:50 Threater Flusoper9823 [6464]
4 16:49 AlanC [6458]
2 02:51 g(r)omgoru [6541]
Page 2: WoT Background
0 [6462]
2 09:53 Redneck Jim [6463]
0 [6458]
2 09:27 JohnQC [6459]
0 [6461]
8 22:59 JosephMendiola [6473]
2 22:58 JosephMendiola [6475]
1 19:36 JosephMendiola [6473]
0 [6460]
0 [6462]
0 [6463]
1 07:05 Paul D [6459]
5 16:53 AlanC [6469]
0 [6461]
3 10:57 Thing From Snowy Mountain [6460]
2 10:40 Frank G [6460]
7 22:16 OldSpook [6469]
2 17:40 Dopey Sinatra9196 [6467]
0 [6460]
Page 3: Non-WoT
3 20:27 rjschwarz [6474]
3 18:24 Bright Pebbles [6470]
5 22:13 Frank G [6478]
1 09:29 Cromomp Ghibelline4365 [6460]
7 20:28 rjschwarz [6477]
0 [6461]
4 18:07 trailing wife [6478]
3 09:47 Redneck Jim [6462]
0 [6459]
Page 4: Opinion
0 [6462]
1 14:38 Ptah [6469]
2 13:57 Elmerert Hupens2660 [6474]
3 04:09 Besoeker [6475]
16 22:01 tipper [6470]
7 19:46 JosephMendiola [6471]
Search tool to find out who, what, where, and how related in tax haven island

Fun tool to find who, what, where and how they are related.....in tax heaven island.

Posted by: 3dc || 06/16/2013 11:52 || Comments || Link || E-Mail|| [6463 views] Top|| File under:

#1  An art restorer is able to rebuild a broken sculpture after thoroughly studying its multiple unconnected pieces in order to decode how they related in the past, to return them to their original place and to discover its full shape again.

Just like art restorers, the Investigative Unit at La Nación Costa Rica received in November 2012 a device with millions of data in different formats. The relational databases came scattered over more than 320 tables and without an original dictionary to explain their relations.

These databases were parts of two larger separated databases that had been fed for nearly 30 years by two companies: Singapore-based Portcullis TrustNet (PTN), and Commonwealth Trust Limited (CTL), based in the British Virgin Islands (BVI).

Both firms specialize in setting up offshore financial structures. They have helped tens of thousands of people create offshore companies and trusts, as well as hard-to-trace bank accounts.

The data were obtained by the International Consortium of Investigative Journalists (ICIJ), which chose The Investigative Unit at La Nacion to process it and to develop the interactive application of the most ambitious cross-border investigative project in history.

The task did not start from zero. In the preceding months, UK journalist Duncan Campbell and programmer Matthew Fowler had made progress in understanding and documenting part of those relations.


DON'T MISS: How ICIJ's Project Team Analyzed the Offshore Files


Between January and April, the Investigative Unit’s computer science engineer, Rigoberto Carvajal, thoroughly analyzed the data and, with advice from the UK team and data journalist Mar Cabra, applied reverse engineering processes to reveal the original relations between tables, fields, codes, and, ultimately, hundreds of thousands of records of companies and people.

As he started work, Rigoberto found himself faced with a disorganized and scattered structure, which for years enabled an insufficient and incomplete feeding of data, duplications, void values, unneeded repetitions, missing data and poorly solved relations.

There were thousands of names of people and companies which were duplicated because they had minimal variations in some character, abbreviations, typing errors, or a slightly different order of the elements.

If the data remained that way, the true links and relations of each separate element would have never been disclosed through visualization. It would have been something similar to varnishing, without first sanding them, the dirty pieces of a disassembled sculpture.

Part of the solution consisted in integrating the databases to bring together their similar entries and then organizing them in such a way that the structure would become practical for visualization.

In order to do so, the La Nación team used the Talend Open Studio for Data Integration, an open source tool for ETL (Extraction, Transformation and Load).

Talend hosted all of the processes: extracting the databases tables, organizing their structure to combine similar records, converting them into a node and link structure and, finally, loading up the unified nodes into a sole database which would feed the public application.

Procedures and algorithms to de-duplicate the data were applied. In this task, a library developed by the Massachusetts Institute of Technology (MIT) as a result of a project named Vicino, played an important role. This library was added to the Talend Open Studio tool to apply functions in the data flow.

Also relevant was the use of the SIMIL function, which estimates the percentage of similarity between two chains of text, based on the number of sub-strings they have in common.

With these algorithms, Carvajal merged several thousand separate records which were the same persons or companies with a total degree of certainty and which had exactly the same addresses.

Following this merge, the links associated to each of those entities were finally related.
Posted by: 3dc || 06/16/2013 12:11 Comments || Top||

#2  The database includes entities incorporated in 10 offshore jurisdictions: British Virgin Islands, Cayman Islands, Cook Islands, Singapore, Hong Kong, Samoa, Seychelles, Mauritius, Labuan and Malaysia. The information comes from two offshore service firms: Singapore-based Portcullis TrustNet and BVI-based Commonwealth Trust Limited (CTL).
Posted by: 3dc || 06/16/2013 12:18 Comments || Top||

#3  How did they get the two companies to release their databases? That may be a story in itself.
Posted by: tipover || 06/16/2013 13:38 Comments || Top||

#4  Tipper - the story is on the site. They didn't. The database just appeared on a live device in their mailroom.
Posted by: 3dc || 06/16/2013 13:58 Comments || Top||

Home Front: WoT
Obama Funder Raising Money for al-Qaeda Families in Yemen?
Jodie Evans, 2008 Obama bundler and co-founder of the leftist anti-American group Code Pink, is in Yemen this week campaigning against the United States’ efforts in fighting the war on terror. This is in keeping with Code Pink’s decade-long history of working with terrorists and state sponsors of terrorism against the United States.

While in Yemen, Evans is raising money for families of Yemenis being held at the terrorist detention center at Guantanamo Bay, Cuba, and possibly the family of slain al Qaeda leader Anwar al-Awlaki.

Code Pink sent their top leadership, including Evans, Susan ‘Medea’ Benjamin and former diplomat Col. Ann Wright (U.S .Army, Ret.) on this trip to the home of al Qaeda in the Arabian Peninsula for meetings with the Yemeni government, the U.S. Ambassador to Yemen Gerald M. Feierstein , Nasser al-Awlaki and other family members of U.S. drone strike targets as well as Guantanamo detainees’ families.

While Code Pink is an American 501(c)3 tax-exempt group, Evans is also appealing for donations from “international donors” through Evans’ Gmail address in support of the trip to Yemen.

Evans posted a photo on June 13 on Instagram and Twitter of the group’s meeting with Nasser al-Awlaki captioned, “Our @CODEPINK #yemen delegation with Anwar al-Awlaki’s father Nasser, “US killed my grandson, Why?”
Posted by: tipper || 06/16/2013 12:23 || Comments || Link || E-Mail|| [6478 views] Top|| File under:

#1  keep em, they're yours
Posted by: Frank G || 06/16/2013 15:30 Comments || Top||

#2  "US killed my grandson, Why?"

Why not?
Posted by: Barbara || 06/16/2013 15:44 Comments || Top||

Science & Technology
PRISM is just the tip of the iceberg
Posted by: Frozen Al || 06/16/2013 00:00 || Comments || Link || E-Mail|| [6457 views] Top|| File under:

#1  Only a matter of time for the Chinese hackers to get this info.
Posted by: Jan || 06/16/2013 11:47 Comments || Top||

Who's in the News
3Govt of Syria
2Govt of Pakistan
1Baloch Liberation Army
1Govt of Iran
1al-Qaeda in Iraq
1al-Qaeda in Arabia

E-Mail Me

The Classics
The O Club
Rantburg Store
The Bloids
The Never-ending Story
Gulf War I
The Way We Were


On Sale now!

A multi-volume chronology and reference guide set detailing three years of the Mexican Drug War between 2010 and 2012.

Rantburg.com and borderlandbeat.com correspondent and author Chris Covert presents his first non-fiction work detailing the drug and gang related violence in Mexico.

Chris gives us Mexican press dispatches of drug and gang war violence over three years, presented in a multi volume set intended to chronicle the death, violence and mayhem which has dominated Mexico for six years.
Click here for more information

Meet the Mods
In no particular order...
Steve White
Scooter McGruder
john frum
Bright Pebbles
trailing wife
Frank G
Alaska Paul

Two weeks of WOT
Sun 2013-06-16
  Double blasts kill 25 in Pakistan
Sat 2013-06-15
  Mali's Tuareg rebels ready to sign peace deal
Fri 2013-06-14
  Mortars Fired at Damascus Airport, Delay 3 Flights
Thu 2013-06-13
  60 Boko Haram members killed in Maiduguri
Wed 2013-06-12
  Thousands Throng Istanbul Protest Square
Tue 2013-06-11
  Bombs and battles hit northern Iraq, more than 70 dead
Mon 2013-06-10
  Syria Islamists Execute Youth in Front of Family
Sun 2013-06-09
  Pak police recovers 15,000 kilos of explosive material
Sat 2013-06-08
  Tunisia Turns Away 8 Gulf Muslim Preachers
Fri 2013-06-07
  Seven killed in suspected U.S. drone strike in Pakistan
Thu 2013-06-06
  Nawaz Sharif elected as Pakistan PM
Wed 2013-06-05
  Locks Cut To Boston Water Supply Aqueduct
Tue 2013-06-04
  Missile Kills 26, including 8 Youths, in Syria Village
Mon 2013-06-03
  Damascus car bombing kills 9 security forces members
Sun 2013-06-02
  Second Muslim Convert Charged with London Soldier Murder

Better than the average link...

Rantburg was assembled from recycled algorithms in the United States of America. No trees were destroyed in the production of this weblog. We did hurt some, though. Sorry.
Help keep the Burg running! Paypal:
WoT Operations (18)    WoT Background (19)    Non-WoT (9)    Opinion (6)    (0)