弁財天

ゴフマン「専門家を信じるのではなく、自分自身で考えて判断せよ」

【パナマ文書】に電通があるというのはウソ、本当はケイマン諸島、電通がロシアにテロ資金源を貯めこむ?w 前哨戦であるicij.orgの.csvファイルをPostgreSQLに取り込んでみた。 update18

#!/bin/sh

psql -h localhost -U icij -d template1 <<END_OF_SQL
create database icijdb;
END_OF_SQL
psql -h localhost -U icij -d icijdb <<END_OF_SQL2
create schema icijdb;
alter user icij set search_path to icijdb;
END_OF_SQL2
#!/bin/sh

psql -h localhost -U postgres <<END_OF_SQL
create user icij with password 'hogehoge' createdb;
END_OF_SQL
create table countries_nw (
    country_id      integer not null primary key,
    country_code    varchar(2) not null,
    country_name    varchar(48)
);
create index countries_nw_idx on countries_nw( country_id );

create table edges_1dnw (
    unique_id       integer not null,
    entity_id1      integer not null,
    entity_id2      integer not null,
    description     varchar(48),
    date_from       varchar(48),
    date_to         varchar(48),
    direction       varchar(48),
    chinese_pos     varchar(48),
    link_type       varchar(48),
        primary key (unique_id,entity_id1,entity_id2)
);
create index edges_1dnw_idx on edges_1dnw( unique_id,entity_id1,entity_id2 );
create index edges_1dnw_id1_idx on edges_1dnw( entity_id1 );
create index edges_1dnw_id2_idx on edges_1dnw( entity_id2 );

create table node_countries_nw (
    nodeid1         integer not null,
    country_code    varchar(2) not null,
    country_name    varchar(48) not null,
    country_id      integer,
        primary key (nodeid1,country_code)
);
create index node_countries_nw_idx on node_countries_nw( nodeid1 );

create table nodes_nw (
    unique_id    integer not null primary key,
    subtypes     varchar(48),
    description  varchar(512),
    search_field varchar(512),
    status    varchar(256),
    desc_status  varchar(256),
    type varchar(100),
    desc_company_type varchar(100),
    inc_dat  varchar(100),
    dorm_dat varchar(48),
    juris    varchar(48),
    desc_jurisdiction  varchar(48),
    complete_addresses varchar(256),
    agency_id varchar(256),
    tax_stat  varchar(256),
    tax_stat_description varchar(100)
);
create index nodes_nw_idx on nodes_nw( unique_id );
#!/usr/bin/perl

use utf8;
use strict;
use Encode;
use DBD::Pg;

my $dbh;
my $sth;

$dbh = DBI->connect("dbi:Pg:dbname=icijdb;host=localhost", "icij", "hogehoge");
$dbh->{pg_enable_utf8} = 1;

#my $NUM_COLS = 16;
#my $NUM_COLS = 9;
#my $NUM_COLS = 4;
my $NUM_COLS = 3;

my @max_len;
for (my $loop = 0;$loop < $NUM_COLS; $loop++) {
        $max_len[$loop] = 0;
}
scalar(<>);


while(<>) {
        my @items = split(';', $_);
        #my $sql = "INSERT INTO nodes_nw (unique_id,subtypes,description,search_field,status,desc_status,type,desc_company_type,inc_dat,dorm_dat,juris,desc_jurisdiction,complete_addresses,agency_id,tax_stat,tax_stat_description) values (";
        #my $sql = "INSERT INTO edges_1dnw (unique_id,entity_id1,entity_id2,description,date_from,date_to,direction,chinese_pos,link_type) values (";
        #my $sql = "INSERT INTO node_countries_nw (nodeid1,country_code,country_name,country_id) values (";
        my $sql = "INSERT INTO countries_nw (country_id,country_code,country_name) values (";
        my @val;
        for (my $loop = 0;$loop < $NUM_COLS; $loop++) {
                $val[$loop] = "";
        }
        for (my $loop = 0;$loop < $#items; $loop++) {
                $val[$loop] = $items[$loop];
                $max_len[$loop] = length($items[$loop]) if ($max_len[$loop] < length($items[$loop]));
        }
        for (my $loop = 0;$loop < $NUM_COLS; $loop++) {
                $val[$loop] =~ s/\"//g;
                $val[$loop] =~ s/\\//g;
                $val[$loop] =~ s/\'/\'\'/g;
                if ($loop == 0) {
                        $sql .= $val[$loop] . ",";
                }
                elsif ($loop > 0 && $loop < ($NUM_COLS - 1)) {
                        if ($val[$loop] eq "") {
                                $sql .= 'null,';
                        } else {
                                #$sql .= 'E\'' . $val[$loop] . '\',';
                                $sql .= 'E\'' . decode('UTF-8',$val[$loop]) . '\',';
                        }
                }
                elsif ($loop == ($NUM_COLS - 1)) {
                        if ($val[$loop] eq "") {
                                $sql .= 'null';
                        } else {
                                $sql .= 'E\'' . $val[$loop] . '\'';
                        }
                }
        }
        $sql .= ")";
        #print $sql . "\n";
        $sth = $dbh->prepare($sql);
        $sth->execute() or print "[$sql]\n";
}

for (my $loop = 0;$loop < ($NUM_COLS - 1); $loop++) {
        print "$loop $max_len[$loop]\n";
}

$dbh->disconnect;

edges_1dnw表のchinese_positionにUTF-8で「董事」みたいな漢字を文字化けしないようにINSERTするために
$sql .= 'E\'' . decode('UTF-8',$val[$loop]) . '\',';
とかやっちゃう。

icijdb=> select distinct(chinese_pos) from edges_1dnw;
   chinese_pos    
------------------
 合伙人
 单位信托注册
 股票经纪人
 信托保护人代理人
 副总裁
 注册地址
 税务顾问
 候补董事
 法律顾问
 股东登记
 代理人姓名
 被提名人
 秘书代理人
 信托受托人
 股东
 信託共同授予人
 董事会代表
 助理秘书
 委任人
 通讯地址
 记录和登记
 董事登记
 总会计师
 信托保护人继任人
 相关公司
 财务员
 投资顾问
 受益所有人
 共同受托人的信托
 信托保护人
 受益所有人代理人
 秘书
 授权代表
 信托设立人
 授权人/签署人
 备任董事
 信托设立人代理人
 离岸公司董事
 董事长
 董事
 银行签字
 审计
 受益人
 受益人代理人
 股东代理人
 总裁
 合伙制董事
 投资顾问代理人
 董事代理人
 常驻董事
 托管人
 秘书公司
 保管
(53 行)

icijdb=> 
やっぱICIJ.orgて中国がやってるかんじ。

関連はこんなかんじ。 土人を探すにはnode_countriesNW.csvでJapanのデータのunique_idで他のファイルを辿っていけばいいのでしょーか?w

$ grep 285431 *
edges_1DNW.csv:"507026";"51921";"285431";"registered address";"";"";"1";"注册地址";"OA"
edges_1DNW.csv:"285431";"8522";"227048";"Director";"Thu Jan 26 00:00:00 CST 2006";"";"1";"董事";"EO"
node_countriesNW.csv:"285431";"JA";"Japan";"124"
nodesNW.csv:"285431";"ADDRESS";"Roppongi Hills Mori Tower 6-10-1, Roppongi Minato-Ku Tokyo, Japan";"Roppongi Hills Mori Tower 6-10-1, Roppongi Minato-Ku Tokyo, Japan ";"";"";"";"";"";"";"";"";"";"";"";""
node_countriesNW.csvから285431が日本のアドレスだとわかって… そのアドレスと関連のあるedges_1DNW.csvのキーは507026と51921で…
$ grep 507026 *
edges_1DNW.csv:"507026";"51921";"285431";"registered address";"";"";"1";"注册地址";"OA"
$ grep \"51921\" *
edges_1DNW.csv:"51921";"198830";"288469";"registered address";"";"";"1";"注册地址";"EA"
edges_1DNW.csv:"507026";"51921";"285431";"registered address";"";"";"1";"注册地址";"OA"
edges_1DNW.csv:"206795";"51921";"172318";"Shareholder";"Fri Jun 30 00:00:00 CST 2006";"";"1";"股东";"EO"
node_countriesNW.csv:"51921";"JA";"Japan";"124"
nodesNW.csv:"51921";"OFFICER";"Rakuten Strategic Partners, Inc.";"Rakuten Strategic Partners, Inc. ";"";"";"";"";"";"";"";"";"";"1";"";""
$ 
で、nodesNW.csvから51921は楽天みたいだと突き止められるのかぁ。
#!/usr/bin/perl

use utf8;
use strict;
use Encode;
use DBD::Pg;

my $dbh;
my $sth;

$dbh = DBI->connect("dbi:Pg:dbname=icijdb;host=localhost", "icij", "hogehoge");
$dbh->{pg_enable_utf8} = 1;

my $sql = "select nodeid1,n.subtypes,n.description,nc.country_name \
from node_countries_nw as nc, nodes_nw as n \
where nc.nodeid1 = n.unique_id \
and (country_code = 'JA' or country_code = 'XX')";
#and n.unique_id = 14407"; # NTTドコモ を抽出できるかで検証

#my $sql = "select nodeid1,n.subtypes,n.description,country_code \
#from node_countries_nw as nc, nodes_nw as n \
#where country_code = 'JA' \
#	and n.unique_id = nc.nodeid1";
#and n.unique_id = 285431"; # 楽天 を抽出できるかで検証

my @v;
my $d = $dbh->selectall_arrayref($sql, { Slice => [] }, @v);

foreach my $r (@$d) {
	my $address = "";
	my $nodeid1_addr = "";
	my $subtype = $r->[1];
	my $desc = $r->[2];
	$desc =~ tr/ / /s;
	$desc =~ s/ $//;
	$address = $r->[1] . "(" . $r->[0] . ")[" . $r->[3] . "][" . $desc . "]";
	#print STDERR $r->[0] . " " . $r->[1] . " " . $r->[2] . " ";
	$nodeid1_addr = $r->[0];
	my $sql2 = "select e.entity_id1,e.entity_id2 from edges_1dnw as e where e.entity_id1 = $nodeid1_addr or e.entity_id2 = $nodeid1_addr";
	my $d2 = $dbh->selectall_arrayref($sql2, { Slice => [] }, @v);
	my $any = "N/A";
	foreach my $r2 (@$d2) {
		my $entity_id1 = $r2->[0];
		my $entity_id2 = $r2->[1];
		my $sql3 = "select n.unique_id,n.subtypes,n.description from nodes_nw as n where n.unique_id = $entity_id1 or n.unique_id = $entity_id2";
		my $d3 = $dbh->selectall_arrayref($sql3, { Slice => [] }, @v);
		foreach my $r3 (@$d3) {
			my $name = $r3->[2];
			$name =~ tr/ / /s;
			$name =~ s/ $//;
			$any = $r3->[1] . "(" . $r3->[0] . ")[" . $name . "]" if ($r3->[1] ne $subtype);
		}
	}
	print "$any $address\n" if ($any ne "N/A" && $any ne "");
}

$dbh->disconnect;
データマイニングの類なんだろーから。3重ループw

わはは。 楽天や電通、Sharecorpとその住所が検索結果に出力されるかをテスト、 ダメならロジックを改善するのさ。(2016年4月17日)

#!/usr/bin/perl

use utf8;
use strict;
use Encode;
use DBD::Pg;

my $dbh;
my $sth;

$dbh = DBI->connect("dbi:Pg:dbname=icijdb;host=localhost", "icij", "hogehoge");
$dbh->{pg_enable_utf8} = 1;

my $sql = "select nodeid1,n.subtypes,n.description,nc.country_name \
from node_countries_nw as nc, nodes_nw as n \
where nc.nodeid1 = n.unique_id";
#and country_code = 'JA'";
#and n.unique_id = 75595"; # 75595 OFFICER[Sharecorp Limited] ADDRESS[Japan][12-7, Yayoi-Cho, Yatsushiro-Shi, Kumamoto Ken Japan 866-0846]
#and (country_code = 'JA' or country_code = 'XX') \
#and n.unique_id = 14407"; # NTTドコモ を抽出できるかで検証

#my $sql = "select nodeid1,n.subtypes,n.description,country_code \
#from node_countries_nw as nc, nodes_nw as n \
#where country_code = 'JA' \
#	and n.unique_id = nc.nodeid1";
#and n.unique_id = 285431"; # 楽天 を抽出できるかで検証

my @v;
my $d = $dbh->selectall_arrayref($sql, { Slice => [] }, @v);

foreach my $r (@$d) {
	my $address = "";
	my $nodeid1_addr = "";
	my $subtype = $r->[1];
	my $desc = $r->[2];
	$desc =~ tr/ / /s;
	$desc =~ s/ $//;
	$address = $r->[1] . "(" . $r->[0] . ")[" . $r->[3] . "][" . $desc . "]";
	#print STDERR "DEBUG " . $r->[0] . " " . $r->[1] . " " . $r->[2] . " ";
	$nodeid1_addr = $r->[0];
	
	&decode_edges_1dnw("unique_id", $nodeid1_addr,$subtype,$address);
	&decode_edges_1dnw("entity_id1", $nodeid1_addr,$subtype,$address);
	&decode_edges_1dnw("entity_id2", $nodeid1_addr,$subtype,$address);
	#print "$any $address\n" if ($any ne "");
}

sub decode_edges_1dnw() {
	my ($colname,$id,$subtype,$address) = @_;
	my $sql2;
    $sql2 = "select e.entity_id1,e.entity_id2 from edges_1dnw as e where e.unique_id = $id" if ($colname eq "unique_id");
    $sql2 = "select e.entity_id1,e.entity_id2 from edges_1dnw as e where e.entity_id1 = $id" if ($colname eq "entity_id1");
    $sql2 = "select e.entity_id2,e.entity_id2 from edges_1dnw as e where e.entity_id2 = $id" if ($colname eq "entity_id2");

	my $d2 = $dbh->selectall_arrayref($sql2, { Slice => [] }, @v);
	foreach my $r2 (@$d2) {
		my $entity_id1 = $r2->[0];
		my $entity_id2 = $r2->[1];
		&decode_nodes_nw($entity_id1,$subtype,$address) if ($colname ne "entity_id1");
		&decode_nodes_nw($entity_id2,$subtype,$address) if ($colname ne "entity_id2");
	}
	#print "DEBUG $any\n";
	#$any;
}

sub decode_nodes_nw() {
	my $any = "";
	my ($unique_id,$subtype,$address) = @_;
	my $sql3 = "select n.unique_id,n.subtypes,n.description from nodes_nw as n where n.unique_id = $unique_id";
	my $d3 = $dbh->selectall_arrayref($sql3, { Slice => [] }, @v);
	foreach my $r3 (@$d3) {
		my $name = $r3->[2];
		$name =~ tr/ / /s;
		$name =~ s/ $//;
		$any = $r3->[1] . "(" . $r3->[0] . ")[" . $name . "]" if ($r3->[1] ne $subtype);
		print "$any $address\n" if ($any ne "");
	}
}

$dbh->disconnect;

会社と思ったものにマーク。

* 206728 ENTITY[Toyo Seafoods Corporation] ADDRESS[Japan][Vladimir Touloupov Marusaka Bldg., 4F 2-Chome 1-6 Shinkawa, Chuo-ku Tokyo, Japan]
* 296493 MASTER CLIENT[Towry Law International (Japan) Limited] ADDRESS[Japan][World Wide Center, 4F 1-13, Sanbancho Chiyoda-ku, Tokyo 102-0075 JAPAN]
* 75502 OFFICER[Sun Arrow Co Ltd] ADDRESS[Japan][3-15-14 Kotobuki Taito Ku, 111-0042 Japan]
* 75595 OFFICER[Sharecorp Limited] 
ドリームインキュベータ* 89200 OFFICER[Dream Incubator Inc.] ADDRESS[Japan][Nakameguro GT Tower 14F 2-1-1, Kamimeguro Meguro-ku, Tokyo 153-0051 JAPAN]
* 43789 OFFICER[Daiso Construction Co., Ltd.] ADDRESS[Japan][No. 1-2-15 Marunauchi Fukuyama-Shi Hiroshima 720-0061, Japan]
* 56917 OFFICER[Trustcorp Limited] ADDRESS[Japan][F-2 Will, 1-3-22 Hinode-cho Ageo-city, Saitama 362 Japan]
* 75595 OFFICER[Sharecorp Limited] ADDRESS[Japan][12-7, Yayoi-Cho, Yatsushiro-Shi, Kumamoto Ken Japan 866-0846]
* 73913 OFFICER & MASTER CLIENT[Angela Ng Bow Humair] ADDRESS[Japan][Garden Passage Hiroo #4 3-8-11 Hiroo Shibuya-Ku Tokyo, Japan 150-0012]
* 73979 OFFICER[Jean-Claude Marcel Humair] ADDRESS[Japan][Garden Passage Hiroo #4 3-8-11 Hiroo Shibuya-Ku Tokyo, Japan 150-0012]
* 116648 OFFICER[Jones, Day, Reavis & Pogue, Tokyo] ADDRESS[Japan][Toranomon MT Bldg 10-3,Toranomon 3-Chome Minato - Ku Tokyo 105 JAPAN]
大日本印刷* 78312 OFFICER[Dai Nippon Printing Co., Ltd] ADDRESS[Japan][1-1-1, Ichigaya-Kagacho Shinjuku-ku Tokyo 162-8001 Japan]
* 75595 OFFICER[Sharecorp Limited] ADDRESS[Japan][1-19-18 Shibuya, Shibuya-ku Aoyama Park Tower 3103 Tokyo, Japan 150-0002]
* 79641 OFFICER[Nosui Corporation] ADDRESS[Japan][2-1 Tamagawa 3-Chome Fukushimaku Osaka 553]
山一ファイナンス(旧山一證券w)* 76355 OFFICER[Yamaichi Finance Co.] ADDRESS[Japan][2-20-1 Shiohama, Koto-ku Tokyo, 135 Japan]
三菱商事* 117871 OFFICER[Mitsubishi Corporation] ADDRESS[Japan][6-3 Marunouchi 2-Chome, Chiyoda-Ku TOKYO 100-8086 JAPAN]
バンダイネットワークス* 93507 OFFICER[BANDAI NETWORKDS CO. LTD.] ADDRESS[Japan][21F., 1-6-1, Higashi-Shinbashi Minato-ku Tokyo JAPAN]
* 57787 OFFICER[UMIX CO., LTD] ADDRESS[Japan][2-37-1,Kausgakita, Hirakata, Osaka 573-0137, JAPAN]
* 169225 ENTITY[Alpha Tango Trust] ADDRESS[Japan][2-9-2 Sakuragawa, Itabashi-ku Tokyo 174-0075 JAPAN]
* 51498 OFFICER[Atlas Co., Limited] ADDRESS[Japan][Rm. 505, 603-1-2B. Bushi Iruma-Shi, Saitama City, 358, Japan]
* 99132 OFFICER[G-Mode Co., Ltd] ADDRESS[Japan][9th Fl., Shinjuku Bunka Quint Bldg., 3-22-7 Yoyogi Shibuya-Ku, Tokyo JAPAN 151-0053]
* 41991 OFFICER[Grant Cameron Goodger] ADDRESS[Japan][Azabu Residence #E 2-11-20 Moto Azabo Minato-ku, Tokyo 106-0046 Japan]
* 47429 OFFICER[Paul Cuthbert-Brown] ADDRESS[Japan][c/o Lehman Brothers Ark Mori Bldg., 36th Floor, 12-32 Akasaka 1-Chome, Minato-Ku Tokyo 107-6036, Japan]
* 98116 OFFICER[IM Wing Sum, Victor] ADDRESS[Japan][Eikawa-House, 19 Moriyoshi-Cho Fukakusa, Fushimi-Ku Kyoto Japan]
* 58225 OFFICER[BJARNE CARLSEN] ADDRESS[Japan][Evergreen Park Homes 21 13 Uguisudanicho Shibuya-Ku Tokyo 150-0032, Japan]
* 87371 OFFICER[Philip Gavin Mark WOODALL] ADDRESS[Japan][TAKADANOBABA 1-28-6-804 SHINJUKU TOKYO 169-0075 JAPAN]
サイバーマジック* 214853 ENTITY[Cyber Magic Incorporated] ADDRESS[Japan][Takao Asayama 4-65, Matsugaoka Itami City Hyogo  664-0024 Japan]
* 296533 MASTER CLIENT[Tokiwa Corporation] ADDRESS[Japan][Tokiwa Bldg., 5F 3-8-16 Uchiyama, Chikusa-Ku Nagoya 464-0075 Japan]
* 77851 OFFICER[Velisarios Kattoulas] ADDRESS[Japan][Kakinokizaka 2-10-13 Meguro-ku, Tokyo 152-0022, Japan]
* 21706 OFFICER[Bradley Christopher Ritchey] ADDRESS[Japan][Konan 4-1-6-1005, Minato-ku Tokyo 108-0075, Japan]
丸紅* 120681 OFFICER[Marubeni Itochu Steel Inc.] ADDRESS[Japan][Nihonbashi I-Chome Bldg. $-1 Nihonbashi I-chome 4-1 Nihonbashi 1-Chome Chou-ku Tokyo,Japan]
* 85548 OFFICER[SHEILA VINOD MALKANI] ADDRESS[Japan][5-4-3 Yamamoto-dori, Chuo-ku Kobe, Japan]
* 51443 OFFICER[VINOD KRISHIN MALKANI] ADDRESS[Japan][5-4-3 Yamamoto-dori, Chuo-ku Kobe, Japan]
丸紅* 57471 OFFICER & MASTER CLIENT[Marubeni Corporation] ADDRESS[Japan][4-2, Ohtemachi 1-Chome, Chiyoda-ku, Tokyo 100-8088 JAPAN]
日本製紙* 86923 OFFICER[Nippon Paper Industries Co., Ltd.] ADDRESS[Japan][Shin-Yuraku-Cho Building, 1-12-1 Yuraku-Cho, Chiyoda-Ku Tokyo 100-0006 JAPAN]
* 44069 OFFICER[Trendy Information Co. Ltd.] ADDRESS[Japan][T272-01 4-12-18 Minamigyotoku Ichikawa-Shi, Chiba-Ken Japan]
ジャフコ* 48978 OFFICER[JAFCO G-8 (B) Investment Enterprise Partnership] ADDRESS[Japan][The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis]
ジャフコ* 74100 OFFICER[JAFCO G-8 (A) Investment Enterprise Partnership] ADDRESS[Japan][The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis]
ジャフコ* 79244 OFFICER[JAFCO L-2 Venture Capital Investment Limited Partnership] ADDRESS[Japan][The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis]
ジャフコ* 49747 OFFICER[JAFCO GC-1 Investment Enterprises Partnership] ADDRESS[Japan][The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis]
* 48123 OFFICER[Treasury State Investments Limited] ADDRESS[Japan][Eikawa House, 19 Moriyoshicho Fukakusa Fushimi-Ku Kyoto, Japan]
* 295427 MASTER CLIENT[Salvador Boluda i Vila] ADDRESS[Japan][SP 299 Shibuya Cross Tower 2-5-10 Shibuya Shibuya-ku Tokyo 150-8944 JAPAN]
ゴールドマン・サックスかとおもったらG5w* 93496 OFFICER[G5 Partners LP] ADDRESS[Japan][Tokyo Vanguard #504 4-3-3 Roppongi Minato-Ku Tokyo, 106-0032 Japan]
オリックス* 87652 OFFICER[ORIX Fund No. 10] ADDRESS[Japan][World Trade Center Building 21F., 2-4-1- Hamamatsu-cho Minato-Ku, Tokyo 105-6121 JAPAN]
オリックス* 84924 OFFICER[ORIX FUND NO. 9] ADDRESS[Japan][2-4-1, Hamamatsu-cho Minato-ku Tokyo JAPAN]
東京海上* 75112 OFFICER[Tokio Marine Holdings, Inc] ADDRESS[Japan][2-1 Marunouchi 1-Chome Chiyoda-Ku Tokyo JAPAN]
* 85018 OFFICER[Ant LEAD NO. 1 VENTURE CAPITAL INVESTMENT LIMITED PARTNERSHIP] ADDRESS[Japan][1-2-1 Marunouchi Chiyoda-Ku Tokyo 100-0005 JAPAN]
大和証券* 55321 OFFICER[Daiwa Securities SMBC Principal Investments Co. Ltd.] ADDRESS[Japan][1-9-1, Marunouchi Chiyoda-Ku, Tokyo 100-6754 Japan]
商船三井* 45481 OFFICER[Mitsui O.S.K. Lines, Limited] ADDRESS[Japan][1 - 1 Toranomon, 2 - Chome Minato-Ku, Tokyo, 105-91, Japan]
* 112281 OFFICER[Lifetec Corporation] ADDRESS[Japan][10-19, Minami-Semba 2-Chome Chuo-Ku, Osaka 542-0081, Japan]
* 42242 OFFICER[Dretec Co. Limited] ADDRESS[Japan][1-21-71 Totsuka, Kawaguchi, Saitama 333, Japan]
* 97304 OFFICER[Atlas Company Limited] ADDRESS[Japan][27-7-2107 Kotobuki-Cho, Tokorozawa-Shi, Saitima 359-1122, Japan]
* 46746 OFFICER[Mr Vittorio Volpi] ADDRESS[Japan][2-8-8 Nishihara Shibuya-Ku Tokyo JAPAN]
* 75595 OFFICER[Sharecorp Limited] ADDRESS[Japan][3-11-15 Toranomon, Minato-ku, 4F SVAXTT Building, Tokyo 105-0001, Japan]
ドワンゴ* 72681 OFFICER[DWANGO Co., Ltd.] ADDRESS[Japan][Hamacho Centre Building 2-31-1 Nihonbashi-Hama-cho Chuo-ku, Tokyo 103-0007 JAPAN]
* 75595 OFFICER[Sharecorp Limited] ADDRESS[Japan][J.K. Kichijoji BLD 1-26-1 Kichijoji-Honcho Musashino-City Tokyo, Japan 180-004]
* 56596 OFFICER[Wan, Cheng-Tsai & Lin,Li-Yu] ADDRESS[Japan][J.K. Kichijoji BLD 1-26-1 Kichijoji-Honcho Musashino-City Tokyo, Japan 180-004]
* 88143 OFFICER[Chan Yan Mei, Mary-Ellen] ADDRESS[Japan][4-23-6-1502 Ebisu, Shibuya-ku Tokyo Japan 150-0013]
邱永漢w* 22173 OFFICER[Kyu Eikan] ADDRESS[Japan][1-2-13 Aobadai , Meguro-Ku, Tokyo,153-0042, Japan.]
* 289185 MASTER CLIENT[Boyd & Moore Executive Search] ADDRESS[Japan][Burex Kyobashi Bldg. 812 2-7-14 Kyobashi Chuo-ku Tokyo 104-0031 Japan]
* 74862 OFFICER[SATO TEC. CORPORATION] ADDRESS[Japan][日本靜岡縣富士宮市山宮1115番地-2]
千代田リース(三菱重工)* 44450 OFFICER[Chiyoda Lease Co., Ltd] ADDRESS[Japan][6-38, Manzai-Machi, Nagasaki-Shi, Nagasaki 850, Japan]
日本郵船* 89257 OFFICER[Yusen Air & Sea Service Co. Ltd.] ADDRESS[Japan][8 TH FLOOR, YUSEN AKOZAKI-CHO BUILDING 30-1, NIHONBASHI, HAKOAKI-CHO, CHUO-KU, JAPAN JAPAN 103 0015]
* 49543 OFFICER[Katsu World Co., Ltd] ADDRESS[Japan][Ichinomiya Bldg., 1-35-7 Yoyogi Shibuya-ku Tokyo 151-0053 Japan]
* 78447 OFFICER[Toshka Inc.] ADDRESS[Japan][i-Land Tower 6-5-1 Nishishinjuku Shinjuku-ku Tokyo 163-1305, Japan]
アーツ証券* 296262 MASTER CLIENT[The Arts Securities Co., Ltd] ADDRESS[Japan][Ishikawa Bldg. 4F Shinkawa 2 chome, Chuo-ku Tokyo 104-0033 Japan]
日本航空JAL* 47981 OFFICER[JAL Leasing Co., Ltd] ADDRESS[Japan][JAL Bldg 4-11, Higashi-shinagawa 2-Chome Shinagawa-ku, Tokyo 140 JAPAN]
* 84328 OFFICER[Interpacific Fund M] ADDRESS[Japan][Pola 3 Gotanda Bldg. 6F, 9-5, Nishi-Gotanda 8-Chrome, Shinagawa-ku Tokyo 141-0031, Japan]
双日(日商岩井)* 75975 OFFICER[Nissho Iwai Corporation] ADDRESS[Japan][4-5, Akasaka 2-chome, Minato-ku, Tokyo, Japan]
* 84095 OFFICER[Japan Information Systems Co., Ltd] ADDRESS[Japan][4th Floor, SVAX Hamamatsucho II Bldg. 1-016, Hamamatsucho 2-chome Minato-Ku, Tokyo Japan]
* 112226 OFFICER[corporate directions Inc] ADDRESS[Japan][5fl Hirakawacho Kaizaka Bldg 6-8 Hirakawcho 1-chome chiyoda-ku Tokyo]
楽天* 51921 OFFICER[Rakuten Strategic Partners, Inc.] ADDRESS[Japan][Roppongi Hills Mori Tower 6-10-1, Roppongi Minato-Ku Tokyo, Japan]
石油資源開発* 93135 OFFICER[Japan Petroleum Exploration Co. Ltd.] ADDRESS[Japan][Sapia Tower, 1-7-12 Marunouchi Chiyoda-Ku Tokyo 100-0005 Japan]
* 73670 OFFICER[LIEB FRAU CO., LTD.] ADDRESS[Japan][SHINJUKU 3-1-22, SHINJUKU Tokyo Japan]
* 85901 OFFICER[A-Spine Inc] ADDRESS[Japan][Shintomi Akihabara-bilding 4 3-7-11 Iwamoto City hiyoda-ku Tokyo,]
* 75595 OFFICER[Sharecorp Limited] 
* 93730 OFFICER[Sanley Enterprises Limited] 
やずや* 76603 OFFICER[Yazu Kikaku Co., Ltd] ADDRESS[Japan][1-34-16, Ogusu Minami-Ku Fukuoka 815-8686 Japan]
* 84369 OFFICER[Stockcorp Limited] 
* 75595 OFFICER[Sharecorp Limited] 
* 291959 MASTER CLIENT[International Offshore Consultants] ADDRESS[Japan][1-30-11 Meguro-Ku TOKYO 152-0011]
* 72182 OFFICER[NVCC CHINESE NEW STARS I PARTNERSHIP] ADDRESS[Japan][7-1-16, Akasaka Minato-ku Tokyo Japan]
* 85037 OFFICER[NEOMAX CO., LTD] ADDRESS[Japan][4-7-19, Kitahama Chu-Ku Osaka 541 Japan]
* 56917 OFFICER[Trustcorp Limited] 
* 84369 OFFICER[Stockcorp Limited] 
* 75595 OFFICER[Sharecorp Limited] 
* 112614 OFFICER & MASTER CLIENT[Aall & Company Limited] 
* 112614 OFFICER & MASTER CLIENT[Aall & Company Limited] 
プライスウォーターハウスクーパース* 53253 OFFICER[PricewaterhouseCoopers] 
* 56917 OFFICER[Trustcorp Limited] 
* 47046 OFFICER[B. & McK. Nominees Limited] 
ファーストリテイリング* 97510 OFFICER[Fast Retailing Co., Ltd.] ADDRESS[Japan][717-1 Sayama, Ooaza Yamaguchi City Japan]
* 75595 OFFICER[Sharecorp Limited] 

=== 89200 ドリームインキュベータ ===
OFFICER(89200)[Dream Incubator Inc.] ADDRESS(256022)[Hong Kong][6E Block 1, Tung Chung Crescent Tung Chung Lantau Hong Kong]
OFFICER & MASTER CLIENT(85184)[Mischa Hampe] OFFICER(89200)[Japan][Dream Incubator Inc.]
ENTITY(164159)[Prime Select International Corporation] OFFICER(89200)[Japan][Dream Incubator Inc.]
ADDRESS(238049)[Nakameguro GT Tower 14F 2-1-1, Kamimeguro Meguro-ku, Tokyo 153-0051 JAPAN] OFFICER(89200)[Japan][Dream Incubator Inc.]
ENTITY(172318)[Rock Mobile (Cayman) Corporation] OFFICER(89200)[Japan][Dream Incubator Inc.]
=== 89200 ドリームインキュベータ ===
=== 78312 大日本印刷 ===
OFFICER(78312)[Dai Nippon Printing Co., Ltd] ADDRESS(243142)[Taiwan][13/F., No.98 LinMingChengErLu, 54 DingTaiLI ShanMing District, GaoXiong City, Taiwan 
ENTITY(225080)[Millennium Supreme International Limited] OFFICER(78312)[Japan][Dai Nippon Printing Co., Ltd]
ADDRESS(264051)[Company Kit Limited Unit A, 6/F Shun On Comm Bldg. 112-114 Des Voeux Road C., Hong Kong SAR] OFFICER(78312)[Japan][Dai Nippon Printing Co., Ltd]
ADDRESS(241873)[1-1-1, Ichigaya-Kagacho Shinjuku-ku Tokyo 162-8001 Japan] OFFICER(78312)[Japan][Dai Nippon Printing Co., Ltd]
ENTITY(134651)[VisEra Holding Company] OFFICER(78312)[Japan][Dai Nippon Printing Co., Ltd]
=== 78312 大日本印刷 ===
=== 76355 山一ファイナンス(旧山一證券w) ===
OFFICER(76355)[Yamaichi Finance Co.] ADDRESS(235534)[Malaysia][5 Simpang Tunku Putra 50480 Kuala Lumpur Malaysia]
ENTITY(223133)[Inter-Regional Limited] OFFICER(76355)[Japan][Yamaichi Finance Co.]
ADDRESS(279960)[Parkfield Overseas Corporations Limited Room 2805 Ho King Commercial Centre No. 2 Fa Yuen Street Mongkok Hong Kong] OFFICER(76355)[Japan][Yamaichi Finance Co.]
ADDRESS(247196)[2-20-1 Shiohama, Koto-ku Tokyo, 135 Japan] OFFICER(76355)[Japan][Yamaichi Finance Co.]
ENTITY(127315)[Grand Capital Fund Limited] OFFICER(76355)[Japan][Yamaichi Finance Co.]
=== 76355 山一ファイナンス(旧山一證券w) ===
=== 117871 三菱商事 ===
OFFICER(117871)[Mitsubishi Corporation] ENTITY(200046)[Not identified][JNL Investments, Ltd.]
OFFICER(117871)[Mitsubishi Corporation] ENTITY(200046)[Russia][JNL Investments, Ltd.]
OFFICER(117871)[Mitsubishi Corporation] ENTITY(204228)[Russia][Satridge Solutions, Ltd.]
OFFICER(117871)[Mitsubishi Corporation] ENTITY(204228)[British Virgin Islands][Satridge Solutions, Ltd.]
ENTITY(138651)[Best World Development Limited] OFFICER(117871)[Japan][Mitsubishi Corporation]
ADDRESS(255770)[6-3 Marunouchi 2-Chome, Chiyoda-Ku TOKYO 100-8086 JAPAN] OFFICER(117871)[Japan][Mitsubishi Corporation]
ENTITY(168155)[Asia Group Investments Limited] OFFICER(117871)[Japan][Mitsubishi Corporation]
ENTITY(140441)[Energi Mega Pratama Inc.] OFFICER(117871)[Japan][Mitsubishi Corporation]
ENTITY(158624)[CP Secure International Holding Limited] OFFICER(117871)[Japan][Mitsubishi Corporation]
=== 117871 三菱商事 ===
=== 93507 バンダイネットワークス ===
OFFICER(93507)[BANDAI NETWORKDS CO. LTD.] ENTITY(200174)[United States][Weedford Limited]
ENTITY(124835)[FAITHOPE ENTERPRISES LIMITED] OFFICER(93507)[Japan][BANDAI NETWORKDS CO. LTD.]
ADDRESS(247056)[21F., 1-6-1, Higashi-Shinbashi Minato-ku Tokyo JAPAN] OFFICER(93507)[Japan][BANDAI NETWORKDS CO. LTD.]
ENTITY(172318)[Rock Mobile (Cayman) Corporation] OFFICER(93507)[Japan][BANDAI NETWORKDS CO. LTD.]
OFFICER(93507)[BANDAI NETWORKDS CO. LTD.] ENTITY(200174)[British Virgin Islands][Weedford Limited]
=== 93507 バンダイネットワークス ===
=== 214853 サイバーマジック ===
ADDRESS(286911)[Takao Asayama 4-65, Matsugaoka Itami City Hyogo 664-0024 Japan] ENTITY(214853)[Not identified][Cyber Magic Incorporated]
ADDRESS(286911)[Takao Asayama 4-65, Matsugaoka Itami City Hyogo 664-0024 Japan] ENTITY(214853)[Japan][Cyber Magic Incorporated]
ENTITY(214853)[Cyber Magic Incorporated] MASTER CLIENT(298138)[Japan][Takao Asayama]
=== 214853 サイバーマジック ===
=== 120681 丸紅 ===
OFFICER(120681)[Marubeni Itochu Steel Inc.] ENTITY(226947)[United Kingdom][VMA Publishers Inc.]
OFFICER(120681)[Marubeni Itochu Steel Inc.] ENTITY(226947)[British Virgin Islands][VMA Publishers Inc.]
ENTITY(140538)[IDLI CORPORATION] OFFICER(120681)[Japan][Marubeni Itochu Steel Inc.]
ADDRESS(272274)[Nihonbashi I-Chome Bldg. $-1 Nihonbashi I-chome 4-1 Nihonbashi 1-Chome Chou-ku Tokyo,Japan] OFFICER(120681)[Japan][Marubeni Itochu Steel Inc.]
ENTITY(137121)[CENTRE VIEW HOLDING LIMITED] OFFICER(120681)[Japan][Marubeni Itochu Steel Inc.]
=== 120681 丸紅 ===
=== 57471 丸紅 ===
OFFICER & MASTER CLIENT(57471)[Marubeni Corporation] ADDRESS(238139)[Taiwan][No.106-3, Junghshan Rd., Luju Shiang, Taoyuan Taiwan 338 ROC]
OFFICER & MASTER CLIENT(57471)[Marubeni Corporation] ADDRESS(247978)[United States][2583 White Owl Drive Encinitas (San Diego County) California 92024-6557 USA]
ENTITY(204346)[WonderLord Trading Corp.] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
ADDRESS(236832)[c/o International Offshore Services Group 42 Chelmsford Road Dublin 6 Ireland] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
ENTITY(161655)[Millmerran Investment Company V, Pte. Ltd.] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
ENTITY(161656)[Millmerran Investment Company VI, Pte. Ltd.] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
ENTITY(184630)[Marubeni Corporation] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
ADDRESS(235320)[4-2, Ohtemachi 1-Chome, Chiyoda-ku, Tokyo 100-8088 JAPAN] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
ENTITY(161655)[Millmerran Investment Company V, Pte. Ltd.] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
ENTITY(161656)[Millmerran Investment Company VI, Pte. Ltd.] OFFICER & MASTER CLIENT(57471)[Japan][Marubeni Corporation]
=== 57471 丸紅 ===
=== 86923 日本製紙 ===
OFFICER(86923)[Nippon Paper Industries Co., Ltd.] ADDRESS(236894)[Hong Kong][c/o Room 1201, AT Tower, 180 Electric Road, North Point, Hong Kong]
ENTITY(134157)[Asia Media (BVI) International Corporation Limited] OFFICER(86923)[Japan][Nippon Paper Industries Co., Ltd.]
ADDRESS(237076)[David Chong & Co. Office B1, 7/F. Loyong Court 212-220 Lockhart Road Wanchai Hong Kong CAYMAN ISLANDS] OFFICER(86923)[Japan][Nippon Paper Industries Co., Ltd.]
ADDRESS(285868)[Shin-Yuraku-Cho Building, 1-12-1 Yuraku-Cho, Chiyoda-Ku Tokyo 100-0006 JAPAN] OFFICER(86923)[Japan][Nippon Paper Industries Co., Ltd.]
ENTITY(154261)[YFY Cayman Co., Ltd.] OFFICER(86923)[Japan][Nippon Paper Industries Co., Ltd.]
=== 86923 日本製紙 ===
=== 48978 ジャフコ ===
OFFICER(48978)[JAFCO G-8 (B) Investment Enterprise Partnership] ENTITY(187179)[Not identified][Sosnik, Bell & Co]
ENTITY(195898)[Veneto Investments Limited] OFFICER(48978)[Japan][JAFCO G-8 (B) Investment Enterprise Partnership]
ADDRESS(268974)[Hill Consulting Ltd. Moscow - City Business Centre 10 Testovskaya Str., Severnaya Tower, 11th Floor, Moscow 123317, Russia] OFFICER(48978)[Japan][JAFCO G-8 (B) Investment Enterprise Partnership]
ADDRESS(287149)[The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis] OFFICER(48978)[Japan][JAFCO G-8 (B) Investment Enterprise Partnership]
ENTITY(136422)[A-Spine Holding Group Corp.] OFFICER(48978)[Japan][JAFCO G-8 (B) Investment Enterprise Partnership]
=== 48978 ジャフコ ===
=== 74100 ジャフコ ===
ENTITY(220882)[Crusader Medical Care Limited] OFFICER(74100)[Japan][JAFCO G-8 (A) Investment Enterprise Partnership]
ADDRESS(280420)[Proform Offshore Limited 1st Floor, Beeswing House 31 Sheep Street Wellingborough England, UK NN8 1BZ] OFFICER(74100)[Japan][JAFCO G-8 (A) Investment Enterprise Partnership]
ADDRESS(287149)[The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis] OFFICER(74100)[Japan][JAFCO G-8 (A) Investment Enterprise Partnership]
ENTITY(136422)[A-Spine Holding Group Corp.] OFFICER(74100)[Japan][JAFCO G-8 (A) Investment Enterprise Partnership]
OFFICER(74100)[JAFCO G-8 (A) Investment Enterprise Partnership] ENTITY(193527)[Not identified][Virgin Medical Systems Ltd.]
OFFICER(74100)[JAFCO G-8 (A) Investment Enterprise Partnership] ENTITY(193527)[Switzerland][Virgin Medical Systems Ltd.]
=== 74100 ジャフコ ===
=== 79244 ジャフコ ===
OFFICER(79244)[JAFCO L-2 Venture Capital Investment Limited Partnership] ENTITY(206942)[Not identified][Renova Technology Co., Ltd.]
OFFICER(79244)[JAFCO L-2 Venture Capital Investment Limited Partnership] ENTITY(206942)[Hong Kong][Renova Technology Co., Ltd.]
ENTITY(226002)[Kella Holding Ltd] OFFICER(79244)[Japan][JAFCO L-2 Venture Capital Investment Limited Partnership]
ADDRESS(271917)[Menwin Business Consultants Limited Office 103 124 Strovolos Avenue 2042 Nicosia Cyprus] OFFICER(79244)[Japan][JAFCO L-2 Venture Capital Investment Limited Partnership]
ADDRESS(287149)[The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis] OFFICER(79244)[Japan][JAFCO L-2 Venture Capital Investment Limited Partnership]
ENTITY(136422)[A-Spine Holding Group Corp.] OFFICER(79244)[Japan][JAFCO L-2 Venture Capital Investment Limited Partnership]
=== 79244 ジャフコ ===
=== 49747 ジャフコ ===
ENTITY(196660)[GLORIOUS KING INVESTMENTS LIMITED] OFFICER(49747)[Japan][JAFCO GC-1 Investment Enterprises Partnership]
ADDRESS(279944)[Panocean Secretarial Services Limited Room 1708 Kai Tak Commercial Building 317-321 Des Voeux Road C Hong Kong] OFFICER(49747)[Japan][JAFCO GC-1 Investment Enterprises Partnership]
ADDRESS(287149)[The Second Steel Building 8-2 Marunouchi 1 Chome Chiyoda Ward Tokyo Metropolis] OFFICER(49747)[Japan][JAFCO GC-1 Investment Enterprises Partnership]
ENTITY(136422)[A-Spine Holding Group Corp.] OFFICER(49747)[Japan][JAFCO GC-1 Investment Enterprises Partnership]
OFFICER(49747)[JAFCO GC-1 Investment Enterprises Partnership] ADDRESS(246849)[United Kingdom][21 Vicarage Close, Erith, Kent DA8 1ET]
=== 49747 ジャフコ ===
=== 93496 ゴールドマン・サックスかとおもったらG5w ===
ENTITY(124830)[FORWARD HOLDING GROUP LIMITED] OFFICER(93496)[Japan][G5 Partners LP]
ADDRESS(287230)[Tokyo Vanguard #504 4-3-3 Roppongi Minato-Ku Tokyo, 106-0032 Japan] OFFICER(93496)[Japan][G5 Partners LP]
ENTITY(141834)[IRONBEAK LIMITED] OFFICER(93496)[Japan][G5 Partners LP]
OFFICER(93496)[G5 Partners LP] ENTITY(206338)[Not identified][Edenton Developments Limited]
OFFICER(93496)[G5 Partners LP] ENTITY(206338)[Russia][Edenton Developments Limited]
=== 93496 ゴールドマン・サックスかとおもったらG5w ===
=== 87652 オリックス ===
OFFICER(87652)[ORIX Fund No. 10] ENTITY(186130)[Not identified][PT Ogspiras Basya Pratama]
ENTITY(142346)[BLACK SPADE GROUP LIMITED] OFFICER(87652)[Japan][ORIX Fund No. 10]
ADDRESS(236748)[Trust Net Chambers, P.O.Box 3444, Road Town , Tortola, British Virgin Islands.] OFFICER(87652)[Japan][ORIX Fund No. 10]
ADDRESS(288918)[World Trade Center Building 21F., 2-4-1- Hamamatsu-cho Minato-Ku, Tokyo 105-6121 JAPAN] OFFICER(87652)[Japan][ORIX Fund No. 10]
ENTITY(172532)[Skysoft Inc.] OFFICER(87652)[Japan][ORIX Fund No. 10]
=== 87652 オリックス ===
=== 84924 オリックス ===
OFFICER(84924)[ORIX FUND NO. 9] ADDRESS(247986)[Hong Kong][25B, TOWER 4, DYNASTY COURT, 23 OLD PEAK ROAD HONG KONG]
ENTITY(231384)[JOHANSON FINANCE CORP.] OFFICER(84924)[Japan][ORIX FUND NO. 9]
ADDRESS(236832)[c/o International Offshore Services Group 42 Chelmsford Road Dublin 6 Ireland] OFFICER(84924)[Japan][ORIX FUND NO. 9]
ADDRESS(176116)[2-4-1, Hamamatsu-cho Minato-ku Tokyo JAPAN] OFFICER(84924)[Japan][ORIX FUND NO. 9]
ENTITY(172318)[Rock Mobile (Cayman) Corporation] OFFICER(84924)[Japan][ORIX FUND NO. 9]
=== 84924 オリックス ===
=== 75112 東京海上 ===
OFFICER(75112)[Tokio Marine Holdings, Inc] ADDRESS(269274)[United States][Howard & Bowie Law Offices P.O. Box 460 1 Main Street Damariscotta, ME 04543]
ENTITY(221893)[Visionary Golf Ltd.] OFFICER(75112)[Japan][Tokio Marine Holdings, Inc]
ADDRESS(288469)[Unitrust Corporate Services Ltd. John Humphries House, Room 304 4-10 Stockwell Street, Greenwich London SE10 9JN] OFFICER(75112)[Japan][Tokio Marine Holdings, Inc]
ADDRESS(176481)[2-1 Marunouchi 1-Chome Chiyoda-Ku Tokyo JAPAN] OFFICER(75112)[Japan][Tokio Marine Holdings, Inc]
ENTITY(158624)[CP Secure International Holding Limited] OFFICER(75112)[Japan][Tokio Marine Holdings, Inc]
ENTITY(158624)[CP Secure International Holding Limited] OFFICER(75112)[Japan][Tokio Marine Holdings, Inc]
=== 75112 東京海上 ===
=== 55321 大和証券 ===
OFFICER(55321)[Daiwa Securities SMBC Principal Investments Co. Ltd.] ENTITY(199319)[British Virgin Islands][Kingston Technology Group Inc.]
OFFICER(55321)[Daiwa Securities SMBC Principal Investments Co. Ltd.] ENTITY(199319)[Hong Kong][Kingston Technology Group Inc.]
ENTITY(202196)[Sparenberg Limited] OFFICER(55321)[Japan][Daiwa Securities SMBC Principal Investments Co. Ltd.]
ADDRESS(259978)[Alpha Offshore Limited 2nd Floor 109 Uxbridge Road London, W5 5TL United Kingdom] OFFICER(55321)[Japan][Daiwa Securities SMBC Principal Investments Co. Ltd.]
ADDRESS(180742)[1-9-1, Marunouchi Chiyoda-Ku, Tokyo 100-6754 Japan] OFFICER(55321)[Japan][Daiwa Securities SMBC Principal Investments Co. Ltd.]
ENTITY(171905)[HON CHUAN (CHINA) HOLDINGS CO., LTD.] OFFICER(55321)[Japan][Daiwa Securities SMBC Principal Investments Co. Ltd.]
=== 55321 大和証券 ===
=== 45481 商船三井 ===
ENTITY(192517)[Donnebury Corporation] OFFICER(45481)[Japan][Mitsui O.S.K. Lines, Limited]
ADDRESS(264105)[Corporate Solutions Inc. Corporate Solutions LLC 520 Brickell Key Dr Ste 1403 Miami, Fl 33131 USA] OFFICER(45481)[Japan][Mitsui O.S.K. Lines, Limited]
ADDRESS(240399)[1 - 1 Toranomon, 2 - Chome Minato-Ku, Tokyo, 105-91, Japan] OFFICER(45481)[Japan][Mitsui O.S.K. Lines, Limited]
ENTITY(123442)[SPLENDID CENTURY LIMITED] OFFICER(45481)[Japan][Mitsui O.S.K. Lines, Limited]
OFFICER(45481)[Mitsui O.S.K. Lines, Limited] ENTITY(187785)[Not identified][Thaufeega Fathimath]
=== 45481 商船三井 ===
=== 72681 ドワンゴ ===
ENTITY(219488)[Lorom Overseas Corp.] OFFICER(72681)[Japan][DWANGO Co., Ltd.]
ADDRESS(285729)[Sealight Incorporations Limited Room 1201, Connaught Commercial Building 185 Wanchai Road Wanchai, Hong Kong] OFFICER(72681)[Japan][DWANGO Co., Ltd.]
ADDRESS(268886)[Hamacho Centre Building 2-31-1 Nihonbashi-Hama-cho Chuo-ku, Tokyo 103-0007 JAPAN] OFFICER(72681)[Japan][DWANGO Co., Ltd.]
ENTITY(172532)[Skysoft Inc.] OFFICER(72681)[Japan][DWANGO Co., Ltd.]
OFFICER(72681)[DWANGO Co., Ltd.] ADDRESS(254206)[Singapore][52 Jalan Chengkek Singapore 369275]
=== 72681 ドワンゴ ===
=== 22173 邱永漢w ===
ENTITY(139981)[K Consulting Group Limited] OFFICER(22173)[Japan][Kyu Eikan]
ADDRESS(236724)[Portcullis TrustNet Chambers P.O. Box 3444 Road Town, Tortola British Virgin Islands (w.e.f 9 December 2005)] OFFICER(22173)[Japan][Kyu Eikan]
ADDRESS(233840)[1-2-13 Aobadai , Meguro-Ku, Tokyo,153-0042, Japan.] OFFICER(22173)[Japan][Kyu Eikan]
ENTITY(202371)[Best Chance International Holdings Limited] OFFICER(22173)[Japan][Kyu Eikan]
ENTITY(202371)[Best Chance International Holdings Limited] OFFICER(22173)[Japan][Kyu Eikan]
OFFICER(22173)[Kyu Eikan] ADDRESS(285719)[United States][SCS Offshore 22287 Mulholland Hwy #202 Calabasas, CA 91302]
=== 22173 邱永漢w ===
=== 44450 千代田リース(三菱重工) ===
ENTITY(191488)[Marathon Capital Limited] OFFICER(44450)[Japan][Chiyoda Lease Co., Ltd]
ADDRESS(268544)[Gary Pepper P.O. Box 5697 Santa Barbara, CA 93150 U.S.A.] OFFICER(44450)[Japan][Chiyoda Lease Co., Ltd]
ADDRESS(255808)[6-38, Manzai-Machi, Nagasaki-Shi, Nagasaki 850, Japan] OFFICER(44450)[Japan][Chiyoda Lease Co., Ltd]
ENTITY(170084)[CHIYODA LEASE (CAYMAN) LIMITED] OFFICER(44450)[Japan][Chiyoda Lease Co., Ltd]
OFFICER(44450)[Chiyoda Lease Co., Ltd] ENTITY(211486)[United Kingdom][T.M.B. Logistics Consulting Ltd.]
OFFICER(44450)[Chiyoda Lease Co., Ltd] ENTITY(211486)[British Virgin Islands][T.M.B. Logistics Consulting Ltd.]
=== 44450 千代田リース(三菱重工) ===
=== 89257 日本郵船 ===
ENTITY(164707)[Roseraie Holdings Ltd] OFFICER(89257)[Japan][Yusen Air & Sea Service Co. Ltd.]
ADDRESS(257762)[8 TH FLOOR, YUSEN AKOZAKI-CHO BUILDING 30-1, NIHONBASHI, HAKOAKI-CHO, CHUO-KU, JAPAN JAPAN 103 0015] OFFICER(89257)[Japan][Yusen Air & Sea Service Co. Ltd.]
ENTITY(127689)[YUSEN AIR & SEA SERVICE HOLDINGS (SOUTH ASIA) LIMITED] OFFICER(89257)[Japan][Yusen Air & Sea Service Co. Ltd.]
ENTITY(127689)[YUSEN AIR & SEA SERVICE HOLDINGS (SOUTH ASIA) LIMITED] OFFICER(89257)[Japan][Yusen Air & Sea Service Co. Ltd.]
OFFICER(89257)[Yusen Air & Sea Service Co. Ltd.] ADDRESS(247450)[Hong Kong][23/F., Block F, Evelyn Tower 38 Cloud View Road, North Point Hong Kong]
=== 89257 日本郵船 ===
=== 296262 アーツ証券 ===
OFFICER(23048)[CASCADO AG] MASTER CLIENT(296262)[Japan][The Arts Securities Co., Ltd]
ENTITY(202592)[RadLey Universal Ltd.] MASTER CLIENT(296262)[Japan][The Arts Securities Co., Ltd]
ENTITY(166752)[RA FINANCIAL LTD] MASTER CLIENT(296262)[Japan][The Arts Securities Co., Ltd]
ENTITY(187646)[The Arts Securities Co., Ltd] MASTER CLIENT(296262)[Japan][The Arts Securities Co., Ltd]
ADDRESS(269447)[Ishikawa Bldg. 4F Shinkawa 2 chome, Chuo-ku Tokyo 104-0033 Japan] MASTER CLIENT(296262)[Japan][The Arts Securities Co., Ltd]
=== 296262 アーツ証券 ===
=== 47981 日本航空(JAL) ===
ENTITY(194906)[Brytek Ventures Inc.] OFFICER(47981)[Japan][JAL Leasing Co., Ltd]
ADDRESS(288469)[Unitrust Corporate Services Ltd. John Humphries House, Room 304 4-10 Stockwell Street, Greenwich London SE10 9JN] OFFICER(47981)[Japan][JAL Leasing Co., Ltd]
ENTITY(167528)[JAL Leasing (Cook) Co., Ltd] OFFICER(47981)[Japan][JAL Leasing Co., Ltd]
ADDRESS(269513)[JAL Bldg 4-11, Higashi-shinagawa 2-Chome Shinagawa-ku, Tokyo 140 JAPAN] OFFICER(47981)[Japan][JAL Leasing Co., Ltd]
=== 47981 日本航空(JAL) ===
=== 75975 双日(日商岩井) ===
OFFICER(75975)[Nissho Iwai Corporation] ENTITY(185772)[Not identified][Peter Schneider]
ENTITY(222757)[GERUDO MANGEMENT INC .] OFFICER(75975)[Japan][Nissho Iwai Corporation]
ADDRESS(268654)[Goodwin Management Corporation 13 Bldg. 1, Armianskly per, 3 flr. Moscow 101000 Russia] OFFICER(75975)[Japan][Nissho Iwai Corporation]
ADDRESS(252522)[4-5, Akasaka 2-chome, Minato-ku, Tokyo, Japan] OFFICER(75975)[Japan][Nissho Iwai Corporation]
ENTITY(125734)[POWER HOUSE INVESTMENT HOLDING LIMITED] OFFICER(75975)[Japan][Nissho Iwai Corporation]
=== 75975 双日(日商岩井) ===
=== 51921 楽天 ===
ENTITY(198830)[TILIAN ENTERPRISES LTD.] OFFICER(51921)[Japan][Rakuten Strategic Partners, Inc.]
ADDRESS(288469)[Unitrust Corporate Services Ltd. John Humphries House, Room 304 4-10 Stockwell Street, Greenwich London SE10 9JN] OFFICER(51921)[Japan][Rakuten Strategic Partners, Inc.]
ADDRESS(285431)[Roppongi Hills Mori Tower 6-10-1, Roppongi Minato-Ku Tokyo, Japan] OFFICER(51921)[Japan][Rakuten Strategic Partners, Inc.]
ENTITY(172318)[Rock Mobile (Cayman) Corporation] OFFICER(51921)[Japan][Rakuten Strategic Partners, Inc.]
OFFICER(51921)[Rakuten Strategic Partners, Inc.] ENTITY(206795)[Not identified][Prime Fortune Consultants Limited]
OFFICER(51921)[Rakuten Strategic Partners, Inc.] ENTITY(206795)[Hong Kong][Prime Fortune Consultants Limited]
=== 51921 楽天 ===
=== 93135 石油資源開発 ===
OFFICER(93135)[Japan Petroleum Exploration Co. Ltd.] ADDRESS(258204)[Moldova][89 Valchenko Str., Apt.47,Ribnitsa,5500, Moldova.]
ENTITY(123858)[Hamon Investment Holdings Ltd] OFFICER(93135)[Japan][Japan Petroleum Exploration Co. Ltd.]
ADDRESS(285698)[Sapia Tower, 1-7-12 Marunouchi Chiyoda-Ku Tokyo 100-0005 Japan] OFFICER(93135)[Japan][Japan Petroleum Exploration Co. Ltd.]
ENTITY(140441)[Energi Mega Pratama Inc.] OFFICER(93135)[Japan][Japan Petroleum Exploration Co. Ltd.]
=== 93135 石油資源開発 ===
=== 76603 やずや ===
ENTITY(223380)[Falcondream Limited] OFFICER(76603)[Japan][Yazu Kikaku Co., Ltd]
ADDRESS(286104)[Stone Capital Limited 78 Profsoyuznaya Street Premises of RBC office, 508 room Moscow, Russia pin 117393] OFFICER(76603)[Japan][Yazu Kikaku Co., Ltd]
ADDRESS(107403)[1-34-16, Ogusu Minami-Ku Fukuoka 815-8686 Japan] OFFICER(76603)[Japan][Yazu Kikaku Co., Ltd]
ENTITY(172226)[Sun Red River Cayman Co., Ltd.] OFFICER(76603)[Japan][Yazu Kikaku Co., Ltd]
OFFICER(76603)[Yazu Kikaku Co., Ltd] ADDRESS(246276)[Russia][2, Sechenovskiy Pereulok, Apt 6, Moscow, Russia]
=== 76603 やずや ===
=== 53253 プライスウォーターハウスクーパース(PwC) ===
ENTITY(200144)[Pioneer Base Investments Limited] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ADDRESS(279944)[Panocean Secretarial Services Limited Room 1708 Kai Tak Commercial Building 317-321 Des Voeux Road C Hong Kong] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ADDRESS(257657)[8 Cross Street #17-00 PWC Building Singapore 048424] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ENTITY(161407)[CATERPILLAR FINANCIAL SERVICES ASIA PTE LTD] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ENTITY(161371)[COOPER CAMERON VALVES SINGAPORE PTE. LTD.] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ENTITY(161951)[GORAN INVESTMENT PTE LTD] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ENTITY(161408)[GAITE INVESTMENT PTE LTD] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ENTITY(161980)[WILHELMSEN AALL SHIPS SERVICE PTE. LTD.] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ENTITY(161953)[PYH PTE. LTD.] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
ENTITY(156693)[CHEN FAMILY TRUST] OFFICER(53253)[Singapore][PricewaterhouseCoopers]
=== 53253 プライスウォーターハウスクーパース(PwC) ===
=== 97510 ファーストリテイリング(ユニクロ) ===
ENTITY(126917)[MEGA WEALTH GROUP LIMITED] OFFICER(97510)[Japan][Fast Retailing Co., Ltd.]
ADDRESS(173580)[717-1 Sayama, Ooaza Yamaguchi City Japan] OFFICER(97510)[Japan][Fast Retailing Co., Ltd.]
ENTITY(166457)[CPAT (SINGAPORE) PRIVATE LTD.] OFFICER(97510)[Japan][Fast Retailing Co., Ltd.]
OFFICER(97510)[Fast Retailing Co., Ltd.] ENTITY(207911)[Latvia][Faraday Consult Ltd.]
OFFICER(97510)[Fast Retailing Co., Ltd.] ENTITY(207911)[British Virgin Islands][Faraday Consult Ltd.]
=== 97510 ファーストリテイリング(ユニクロ) ===
この検索をバハマ・リークスでやった 結果

「租税回避は違法ではないが不道徳だ。租税回避する人達を泥棒と同じ扱いにすべき。 そうなれば我々が問題と取り組む理由になる。」ジョージ・オズボーン

Not identified(country_code = 'XX') の企業を抽出しようとしたらバッチが終わらなくなったw
インデックス追加w

create index edges_1dnw_id1_idx on edges_1dnw( entity_id1 );
create index edges_1dnw_id2_idx on edges_1dnw( entity_id2 );
つかXXの企業は文字どーり未確認状態…
やっぱ最後はgrepコマンドだよな。

【パナマ文書】NTTドコモとソニーが共有する[Just In Mobile International Company Limited]て何の会社?に切り出し。

dges_1DNW.csv:"458655";"93390";"146999";"Master Client";"";"";"1";"秘书公司";"EI"
edges_1DNW.csv:"361195";"54662";"146999";"Records & Registers";"";"";"1";"记录和登记";"EO"
edges_1DNW.csv:"28205";"146999";"236724";"registered address";"";"";"1";"注册地址";"EA"
edges_1DNW.csv:"88598";"93390";"146999";"Beneficial Owner";"Tue Oct 25 00:00:00 CST 2005";"";"1";"受益所有人";"EO"
edges_1DNW.csv:"130294";"24883";"146999";"Director";"Fri Oct 28 00:00:00 CST 2005";"";"1";"董事";"EO"
edges_1DNW.csv:"238037";"76609";"146999";"Shareholder";"Fri Oct 28 00:00:00 CST 2005";"";"1";"股东";"EO"
edges_1DNW.csv:"146999";"77576";"156986";"Director";"Fri Nov 30 00:00:00 CST 2007";"";"1";"董事";"EO"
node_countriesNW.csv:"146999";"VI";"British Virgin Islands";"36"
nodesNW.csv:"146999";"ENTITY";"Mitsubishi Group Corporation";"Mitsubishi Group Corporation Portcullis TrustNet Chambers P.O. Box 3444 Road Town, Tortola BRITISH VIRGIN ISLANDS";"Z";"Struck / Defunct / Deregistered";"STD";"Standard International Company";"Fri Oct 28 00:00:00 CST 2005";"";"BVI";"British Virgin Islands";"Portcullis TrustNet Chambers P.O. Box 3444 Road Town, Tortola BRITISH VIRGIN ISLANDS";"1";"IBC";"BVI International Business Company"
OFFICER(117871)[Mitsubishi Corporation] ADDRESS(255770)[Japan][6-3 Marunouchi 2-Chome, Chiyoda-Ku TOKYO 100-8086 JAPAN]
ENTITY(158624)[CP Secure International Holding Limited] OFFICER(117871)[Japan][Mitsubishi Corporation]
OFFICER(76609)[Financecorp Limited] ENTITY(146999)[British Virgin Islands][Mitsubishi Group Corporation]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER & MASTER CLIENT(93390)[Singapore][Johanna Djunaidy]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(28205)[U.S. Virgin Islands][Digital Speed Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(88598)[United States][Callie Killion]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[India][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[Singapore][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[Taiwan][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER & MASTER CLIENT(54662)[Indonesia][Portcullis TrustNet (BVI) Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER & MASTER CLIENT(54662)[Thailand][Portcullis TrustNet (BVI) Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER & MASTER CLIENT(54662)[British Virgin Islands][Portcullis TrustNet (BVI) Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[Australia][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[Myanmar][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[Indonesia][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[British Virgin Islands][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[Malaysia][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(76609)[Thailand][Financecorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER & MASTER CLIENT(54662)[Singapore][Portcullis TrustNet (BVI) Limited]
ENTITY(146999)[Mitsubishi Group Corporation] ADDRESS(238037)[Russia][Mosfilmovskaya str. 70/627, Moscow, Russian Federation.]
OFFICER(77576)[LIU Qiuhua] ENTITY(146999)[British Virgin Islands][Mitsubishi Group Corporation]
ADDRESS(236724)[Portcullis TrustNet Chambers P.O. Box 3444 Road Town, Tortola British Virgin Islands (w.e.f 9 December 2005)] ENTITY(146999)[British Virgin Islands][Mitsubishi Group Corporation]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(24883)[Indonesia][Execorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(24883)[India][Execorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(24883)[Singapore][Execorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(24883)[Taiwan][Execorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(24883)[Malaysia][Execorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(24883)[China][Execorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER(24883)[British Virgin Islands][Execorp Limited]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER & MASTER CLIENT(93390)[Singapore][Johanna Djunaidy]
ENTITY(146999)[Mitsubishi Group Corporation] OFFICER & MASTER CLIENT(93390)[Singapore][Johanna Djunaidy]
三菱グループが英国領バージン諸島(British Virgin Islands)籍の会社をシンガポールに作ってるのを発見w
おーい、川内原発止めていいぞ。 今すぐシャットダウンしろ。

JAPAN 日本 - Secret List of Off-Shore-Companies & Persons
ん?2015年7月5日に既に公開されてるじゃまいかぁ。 icij.orgからダウンロードできるcsv.zipは

$ unzip ../csv.zip 
Archive:  ../csv.zip
  inflating: csv 2014 01 23/countriesNW.csv  
  inflating: csv 2014 01 23/edges_1DNW.csv  
  inflating: csv 2014 01 23/node_countriesNW.csv  
  inflating: csv 2014 01 23/nodesNW.csv  
$ ls -l csv\ 2014\ 01\ 23/
合計 119572
-rw-rw-r-- 1 hoge hoge         6964  1月 23  2014 countriesNW.csv
-rw-rw-r-- 1 hoge hoge 47369099  1月 23  2014 edges_1DNW.csv
-rw-rw-r-- 1 hoge hoge 11536339  1月 23  2014 node_countriesNW.csv
-rw-rw-r-- 1 hoge hoge 63522819  1月 23  2014 nodesNW.csv
$
で、ファイルの日付は2014年1月23日ですな。 で、南ドイツ新聞は1年前にパナマ文書を手に入れたと言ってるのだから ちょっとタイムラインが噛み合わないぁー。 このcsv.zipはモサック・フォンセカのとは違う。 でも ICIJ Offshore Leaks Database(オフショア・リークス・データベース)となってる。 それとも、これからこのデータベースがパナマ文書で追加更新されるてこと?

このプログ的には、丸紅、三菱商事、三菱重工、伊藤忠商事はイスラム国™のプロパガンダ映画「海難1890」のスポンサーだったわけで、
三菱重工、大日本印刷、NTTデータは GALILEOのLISTA.txtにあったわけですよ。
で、NTTアメリカ(NTT America, Inc./ae-3.r23.nycmny01.us.bb.gin.ntt.net)は世界中の ルーティング を改ざんしてる。
まぁなんつか思ってたとーりの展開ですな。

個人的には【山一ファイナンス(旧山一證券w)* 76355 OFFICER[Yamaichi Finance Co.] ADDRESS[Japan][2-20-1 Shiohama, Koto-ku Tokyo, 135 Japan]】があって NTTドコモがみつかり、GALILEOのNTTデータなんて聞いてしまうと、あぁ旧山一證券のビルで開発してるあいつらかよと確信してしまってるとこもあるw

【日本航空JAL* 47981 OFFICER[JAL Leasing Co., Ltd] ADDRESS[Japan][JAL Bldg 4-11, Higashi-shinagawa 2-Chome Shinagawa-ku, Tokyo 140 JAPAN]】
JALと同じように1997年の山一證券の簿外損失もオフショア口座を使った計画倒産だったのかすら?などと勘ぐってしまうわけですなw

$ grep "\"264364\"" *
edges_1DNW.csv:"528635";"83934";"264364";"registered address";"";"";"1";"注册地址";"OA"
edges_1DNW.csv:"264364";"99533";"156722";"Shareholder";"Tue Nov 13 00:00:00 CST 2007";"";"1";"股东";"EO"
node_countriesNW.csv:"264364";"JA";"Japan";"124"
nodesNW.csv:"264364";"ADDRESS";"DENTSU INC 1-8-1 Higashi-shinbashi Minato-Ku, Tokyo 105-7001 JAPAN";"DENTSU INC 1-8-1 Higashi-shinbashi Minato-Ku, Tokyo 105-7001 JAPAN ";"";"";"";"";"";"";"";"";"";"";"";""
$ grep "\"70025\"" *
edges_1DNW.csv:"70025";"216855";"285729";"registered address";"";"";"1";"注册地址";"EA"
edges_1DNW.csv:"514961";"70025";"238842";"registered address";"";"";"1";"注册地址";"OA"
edges_1DNW.csv:"249510";"70025";"149095";"Shareholder";"Tue Oct 10 00:00:00 CST 2006";"";"1";"股东";"EO"
node_countriesNW.csv:"70025";"CJ";"Cayman Islands";"46"
nodesNW.csv:"70025";"OFFICER";"Dentsu Asia Fund I, L.P.";"Dentsu Asia Fund I, L.P. ";"";"";"";"";"";"";"";"";"";"1";"";""
$ 

【パナマ文書】電通のロシアのオフショア口座てオウムの資金源?に切り出し。

CIA behind Panama Papers leaks, says 'most significant financial whistleblower of all time'
「パナマ文書は不正告発ではなく情報機関の作戦だ。」と言ってる人もいますな。

オーザワさんとこの核融合派の南米歌手のおばはんが必死です。

社員に元大和証券SMBC、元伊藤忠商事及びCTC、元ソニー及びソニーマーケティングがいて、つながっていくとこがおもろいですなぁ。

このicijのファイルとパナマ文書は別モノらしい。 でも公開されるとイスラム国™とサイバーテロと不正選挙と何もかも表面化しそーですな。 あぁ、だから2016年5月公開なのか。ターゲットは選挙w

パナマ文書の何が問題なんだと、サラリーマン工作員の奴隷過ぎる必死な解説にw
租税回避ではなくパナマに口座を持っていると言い張っている会社や個人がいるとこがおもしろい。 租税回避ではなく国内の銀行の口座からSWIFT送金せずにオフショアの口座使う取引ていったいどんな取り引きなのか知りたいなぁ。

会社のイメージを租税回避にしたいのか?それとも武器商人にしたいのか?詐欺師にしたいのか?各企業は選択しなければならなくなってる。

「パナマ文書」にJALや電通が載っているという情報はデマ
株式会社参謀本部w 企業概要
「楽天ショップ向けスマホページ自動生成アプリの開発」w
楽天の火消し登場w

楽天* 51921 OFFICER[Rakuten Strategic Partners, Inc.] ADDRESS[Japan][Roppongi Hills Mori Tower 6-10-1, Roppongi Minato-Ku Tokyo, Japan]

各社それぞれ「火消し」を投入してくるとこがw

そういえば北朝鮮がなかったですな。
icijdb=> select distinct(country_name) from node_countries_nw;
           country_name            
-----------------------------------
 Costa Rica
 Cambodia
 Turkey
 Côte d'Ivoire
 Cyprus
 Samoa
 Cayman Islands
 Slovenia
 Vietnam
 Kuwait
 Jamaica
 Antigua and Barbuda
 Saudi Arabia
 Macedonia
 Bosnia and Herzegovina
 Netherlands
 Nigeria
 Lebanon
 Cook Islands
 Australia
 Belize
 Turks and Caicos Islands
 Argentina
 Slovakia
 Russian Federation
 Liechtenstein
 Azerbaijan
 Marshall Islands
 Brazil
 Mongolia
 Hungary
 Uzbekistan
 Mexico
 Taiwan
 Sri Lanka
 Bahamas, The
 Estonia
 Peru
 Bhutan
 Isle of Man
 Anguilla
 Algeria
 Kyrgyzstan
 Malaysia
 Spain
 Serbia
 Belarus
 South Korea
 Jordan
 Niger
 Zimbabwe
 Ireland
 Djibouti
 Malawi
 Iceland
 Nauru
 Dominica
 Jersey
 Puerto Rico
 Trinidad and Tobago
 Austria
 Panama
 Monaco
 South Africa
 Poland
 Laos
 Croatia
 Luxembourg
 Italy
 Sweden
 Niue
 Malta
 Paraguay
 India
 Philippines
 Qatar
 Morocco
 Saint Vincent and the Grenadines
 United Arab Emirates
 Tanzania
 Norway
 Bulgaria
 Fiji
 Namibia
 Libya
 Singapore
 Germany
 Madagascar
 Not identified
 France
 Colombia
 Japan
 Ecuador
 Saint Lucia
 Nepal
 Grenada
 Russia
 Denmark
 Syria
 Bangladesh
 Lithuania
 Barbados
 Curaçao
 Guinea
 Dominican Republic
 Egypt
 Maldives
 Guyana
 Suriname
 Sierra Leone
 Bermuda
 United States
 Georgia
 Benin
 Angola
 Seychelles
 Oman
 Turkmenistan
 Czech Republic
 Gibraltar
 Ghana
 Guernsey
 Gabon
 Israel
 Chile
 New Zealand
 El Salvador
 Botswana
 Macau
 Papua New Guinea
 Finland
 Thailand
 Latvia
 Montenegro
 Venezuela
 Vanuatu
 Bahrain
 The Netherlands
 Uruguay
 Iran
 Lesotho
 Ukraine
 Tonga
 U.S. Virgin Islands
 British Virgin Islands
 Hong Kong
 Portugal
 Norfolk Island
 Liberia
 Romania
 Canada
 Palestine
 China
 Moldova
 Tajikistan
 Kenya
 Mauritius
 Saint Martin
 United Kingdom
 Brunei
 Kazakhstan
 Saint Kitts and Nevis
 Pakistan
 Armenia
 Greece
 Myanmar
 Guam
 Andorra
 Congo, Democratic Republic of the
 Switzerland
 Northern Mariana Islands
 Indonesia
 Belgium
 French Polynesia
(174 行)

icijdb=> 
パナマ文書」の法律事務所、各国のスパイも利用 独紙報道 2016年04月12日 11:04 発信地:ベルリン/ドイツ ×パナマの法律事務所モサック・フォンセカの中国・上海事務所(2016年4月6日撮影、資料写真)。(c)AFP/JOHANNES EISELE

【4月12日 AFP】独日刊紙・南ドイツ新聞(Sueddeutsche Zeitung)は12日、複数の国の情報員が、世界中に衝撃を与えた「パナマ文書」の流出元となった法律事務所モサック・フォンセカ(Mossack Fonseca)を通じ、情報活動の「隠れみの」として利用するペーパーカンパニーを設立していたことが分かったと報じた。事務所の顧客には米中央情報局(CIA)の「仲介役」として密接に協力していた人物も複数含まれていたという。

 モサック・フォンセカから流出した1150万点に及ぶ内部文書を入手し、世界各国の要人や著名人らが資産管理にオフショア企業を利用していた事実を明らかにした同紙によると、事務所の顧客には、1980年代のイラン・コントラ(Iran-Contra)事件の「関係者数人」が含まれていた。

 同事件では、米政府高官らが、イランに対する極秘裏の武器売却と、ニカラグアの反政府武装勢力コントラ(Contra)に対する資金提供を手引きしていたことが明らかになった。

 同紙はさらに、モサック・フォンセカの顧客にはサウジアラビア、コロンビア、ルワンダの少なくとも3か国の「情報機関の現高官や元高官」も含まれていることが、パナマ文書から判明したと報じている。

 そのうちの一人は、サウジアラビアの元総合情報庁長官で、1999年に死去したカマル・アドハム(Kamal Adham)氏で、1970年代の中東における「CIAの主要仲介人の一人」だったと、同紙は伝えている。(c)AFP

うーむ。やはりCIAか。つかCIAと電通以下諸々がつながった瞬間かも。

じゃあ電通や三菱グループの口座は工作資金だったのか?
やっぱこれって次の選挙で自民党の資金が突然枯渇するんじゃね。

【パナマ文書】日立タワー・シンガポール 049318に切り出し。

【パナマ文書】日本興業銀行(The Industrial Bank of Japan, Limited)に切り出し。

UTF-8の文字コードの範囲を超えた文字を挿入してgrep検索が失敗するようになってる。 やるなー。stringsコマンドでUTF-8の文字コードに正規化。

icij.orgの.csvファイルではない、ニュースになったフォセック・モンセカの「パナマ文書」のリストを英のSUNDAYTIMES紙が公開。
これ sunday_times_panama_data.zip
しかし日本の会社や日本人の名前は全く出てこないw ありえねー。まじにCIAの作戦てかんじ。

where country_code = 'JA'
icij_org_2014-01-23_jp.zip

where country_code = 'JA' のリミッターを外した圧縮して27Mバイト、展開すると145Mバイトの巨大テキストファイル。
icij_org_2014-01-23.zip
良い子のスマホやPCではメモリー不足で開くことができないかも。

投稿されたコメント:

コメント
コメントは無効になっています。