ICIJ FinCEN Files Graph Example

Description: Exploring the FinCEN Files Investigation in Neo4j

Figure 1. Model

Figure 2. Example

Example Query:

MATCH (from:Entity)<-[:ORIGINATOR]-(f:Filing)-[:BENEFITS]->(to:Entity)-[:COUNTRY]->(c:Country {name:$country})
 WITH from, to, round(sum(f.amount)) as sum
 ORDER BY sum DESC LIMIT 10
 RETURN from.name as originator

Setup

This is for Neo4j version: 3.5,4.0

The database is also available on https://demo.neo4jlabs.com:7473

Username "fincen", password: "fincen", database: "fincen"

Rendered guide available via: :play https://guides.neo4j.com/sandbox/fincen/index.html

Unrendered guide: documentation/fincen.neo4j-browser-guide

Load graph data via the following:

Data files: import/*.csv

Import flat files (csv, json, etc) using Cypher’s LOAD CSV, APOC library, or other methods.

Dump file: data/fincen-40.dump

• Drop the file into the Files section of a project in Neo4j Desktop. Then choose the option to Create new DBMS from dump option from the file options.

• Use the neo4j-admin tool to load data from the command line with the command below.

bin/neo4j-admin load --from data/fincen-40.dump [--database "database"]

• Upload the dump file to Neo4j Aura via https://console.neo4j.io/#import-instructions

Data load script: scripts/fincen-import.cypher

bin/cypher-shell -u neo4j -p "password" -f scripts/fincen-import.cypher [-d "database"]

Or import in Neo4j Browser by dragging or pasting the content of scripts/fincen-import.cypher.

Code Examples

• JavaScript

• Java

• C#

• Python

• Go

Feedback

Feel free to submit issues or pull requests for improvement on this repository.