kliew/phoenix-panamapapers repository overview

⁠Launch Docker Container

docker pull kliew/phoenix-panamapapers
docker run -it -p 8765:8765 --rm kliew/phoenix-panamapapers

⁠Build Docker Image

Or to build the image yourself

docker build -t kliew/phoenix-panamapapers .

⁠Tableau Workbooks

Workbooks can be viewed and edited (while connected to a valid datasource using Simba's Phoenix ODBC driver) using [Tableau Desktop 9.3] (http://www.tableau.com/products/reader⁠). Packaged workbooks (twbx) can be viewed for free using [Tableau Reader 9.3] (http://www.tableau.com/products/reader⁠). The data was extracted from Phoenix and packaged with the workbook.

One set of workbooks describes entities. Another set describes only Entities with Known Beneficiaries.

Some filters do not work due to incompatibilities with Tableau and Phoenix. ie. I tried to make a Average Duration of Entity by Country workbook but had to exclude it from the packaged workbook.

[Definition of terms] (https://offshoreleaks.icij.org/pages/about⁠).

⁠Entities (Offshore Companies) with Known Beneficiaries

SELECT BNAME, BCOUNTRIES, NAME, COUNTRIES, INCORPORATION_DATE, INACTIVATION_DATE, STRUCK_OFF_DATE, DORM_DATE, STATUS, SERVICE_PROVIDER, SOURCEID
FROM
	(
	SELECT COUNTRIES AS BCOUNTRIES, NAME AS BNAME, NODE_2
	FROM OFFICERS
	INNER JOIN
		(
		SELECT NODE_1, REL_TYPE, NODE_2
		FROM ALL_EDGES 
		WHERE REL_TYPE = 'beneficiary of'
		) bEdges
	ON NODE_ID = bEdges.NODE_1
	) beneficiaries
INNER JOIN ENTITIES
ON ENTITIES.NODE_ID = beneficiaries.NODE_2