The Panama Papers, Graphs, and Data Science Unravelling the Shady - - PowerPoint PPT Presentation
The Panama Papers, Graphs, and Data Science Unravelling the Shady World of Offshore Finance One Data Structure at a Time Dr. Jim Webber Chief Scientist, Neo4j About @jimwebber Graphs, databases, distributed systems Socialist, activist,
Unravelling the Shady World of Offshore Finance One Data Structure at a Time
Chief Scientist, Neo4j
Graphs, databases, distributed systems Socialist, activist, agitator, #SJW
“Our aim is to bring journalists from different countries together in teams - eliminating rivalry and promoting
world’s best cross-border investigative team.”
icij.org/about
#BahamasLeak
Unstructured data extraction
leverages Apache Tika, Tesseract OCR and JBIG2-ImageIO.
Database
App
Other
POWER
Raw Files Meta-Data Database Search Discovery
Investigators used Nuix’s optical character recognition to make millions of scanned documents text-
Nuix’s named entity extraction and other analytical tools to identify and cross- reference the names of Mossack Fonseca clients through millions
Lucene syntax queries with proximity matching! 400 users
name: “John” last: “Miller“ role: “Negotiator“ name: "Maria" last: "Osara" name: “Some Media Ltd” value: “$70M”
PERSON PERSON PERSON PERSON
name: ”Jose" last: “Pereia“ position: “Governor“ name: “Alice” last: “Smith“ role: “Advisor“
MENTIONS
name: “John” last: “Miller“ role: “Negotiator“ name: "Maria" last: "Osara" since: Jan 10, 2011 name: “Some Media Ltd” value: “$70M”
PERSON PERSON PERSON PERSON
name: ”Jose" last: “Pereia“ position: “Governor“ name: “Alice” last: “Smith“ role: “Advisor“
(:Person { name:"Dan"} ) -[:KNOWS]-> (:Person {name:"Ann"})
KNOWS
Dan Ann
NODE NODE LABEL PROPERTY http://neo4j.com/developer/cypher LABEL PROPERTY
MATCH (:Person { name:"Dan"} ) -[:KNOWS]-> (who:Person) RETURN who
KNOWS
Dan ???
LABEL NODE NODE LABEL PROPERTY ALIAS ALIAS http://neo4j.com/developer/cypher
Record
Keywords
Topic
@apcj @technige
information
London is wonderful, but expensive. Tax-avoiding investors have been able to distort the property market to suit their
Tax-avoidance multiplies their advantage to the disadvantage of regular Londoners.
Lionel Messi’s net worth is estimated at €200,000,000. Average income in Barcelona is a more modest €33,000 per year at headline 30% income tax. Messi remains entitled to roads, emergency services and all other benefits of citizenry in his host country.
Britain’s former Prime Minister declared that the country was “all in it together” after the 2008 financial collapse. The British people have seen massive declines in education, healthcare, and social services. Cameron benefitted from his dad’s investment funds involvement with Mossack Fonseca.
Icelandic citizens took the brunt of their banking system’s collapse. Their Prime Minister had a conflict of interest in deciding how much government money would be used to compensate shareholders. He was a (transitive) beneficiary.
I’ll leave this one to you, folks. Bad behaviour spans borders, but so does our technology stack and our commitment to building better communities.
Open source data technology democratises the capabilities that were once the domain of the Web giants. What they can do, we can approximate at low cost and with high effectiveness. Bad guys beware - it’s cheap to find you!
@jimwebber