icij/offshoreleaks-data-packages

Tools to produce and share the downloadable Neo4j packages and guides

Offshore Leaks Database by ICIJ Graph Example

Description: The Offshore Leaks Database and guide from the International Consortium of Investigative Journalists (ICIJ)

Figure 1. Model

Figure 2. Example

Example Query:

MATCH (a:Officer {name:$name})-[r:officer_of|intermediary_of|registered_address*..10]-(b)
RETURN b.name as name LIMIT 20

Setup

This is for Neo4j version: 4.4

Rendered guide available via: :play https://guides.neo4j.com/sandbox/icij-offshoreleaks/index.html

Unrendered guide: documentation/icij-offshoreleaks.neo4j-browser-guide

Load graph data via the following:

Three ways to load the dump file: data/icij-offshoreleaks-44.dump

• 1. Neo4j Desktop:

  • Add 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.

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

bin/neo4j-admin load --from data/icij-offshoreleaks-44.dump [--database "database"]

• 3. Neo4j Aura: Upload the dump file to Neo4j Aura

Code Examples

• JavaScript

• Java

• C#

• Python

• Go

GraphQL API

See /graphql directory for Node.js GraphQL API server example using @neo4j/graphql

Feedback

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

offshoreleaks-data-packages's Issues

Broken hyperlink in Readme.adoc

Hello, In the README.adoc in the description of the Setup section for "3. Neo4j Aura" there is a broken link "https://console.neo4j.io/#import-instructions" returns the Not Found error. Thanks!

Do the _start and _end fields in the raw data refer to the id or node_id fields?

I downloaded the raw data zip files and am trying to understand the data in postgres. I understand that the relationships table links all the others together, but which field on the other tabes maps to the _start and _end fields? It seems like it could be both the id and node_id fields. the id does not always start at 1. Thanks

Is there a CSV version of the Pandora data?

Hey Miguel, sorry to bother about this. I was just wondering if there's a CSV or other tabular/JSON version of the Pandora Papers data that's pre-Neo4J? I saw that there's the olddb zip file, but that seems to merge up the data already, and has it interpreted as a Neo4J node graph. Perhaps there's more of a source form, e.g. companies, directors, shareholders? Thanks for any info!

ux: publish user survey on OLDB

Dumpfile is missing

I'm unable to locate the dump file

Failed to load 'icij-offshoreleaks-44.dump' into 'neo4j' in 'Graph DBMS'

Hello,
when I try to create a new DBMS using this dump, the DB results always offline. I tried with other dumps and I obtain the same result. I don't know how to fix this. I'm using a 5.5.0 DBMS

Pandora papers

Failed to load 'icij-offshoreleaks-42.dump' into 'neo4j' in 'Graph DBMS'

Hello!

I met with problem that indicates as "Failed to load 'icij-offshoreleaks-42.dump' into 'neo4j' in 'Graph DBMS'"
I selected file into neo4j desktop, the file is called as 'icij-offshoreleaks-44.dump'. After I added that file to project and tried to "Create new DBMS from Dump" using that file. So while creating DBMS the problem was occured. So I habe no idea how to fix it.