Offshore Leaks Explorer

Express + static web UI for exploring ICIJ Offshore Leaks data alongside local CSV extracts.

Features

• ICIJ API Search: query the public ICIJ reconciliation API.
• Local CSV Explorer: search officers and linked offshore data from local CSVs.
• Tabular/Pivot Views: compare jurisdictions and countries with pivot tables and CSV downloads.

Tech Stack

• Node.js + Express
• Static frontend (HTML/CSS/JS)

Project Structure

public/                # Frontend UI
src/                   # Express app + API routes
data/                  # CSV data (local)
tests/                 # Jest tests

Setup

1. Install dependencies

npm install

2. Start the server

npm run dev

3. Open the UI

• http://localhost:3000/

Environment Variables

Create a .env (or set env vars) to override defaults:

PORT=3000
ICIJ_NAMESPACE=offshore-leaks
LINKED_OFFSHORE_CSV=data/linked_offshore_table_2026.csv
OFFICERS_CSV=data/full-oldb.LATEST/nodes-officers.csv
ENTITIES_CSV=data/full-oldb.LATEST/nodes-entities.csv
COMPANY_COUNTS_CSV=data/company_counts_by_officer_country.csv

Endpoints

• GET /health — status check
• GET /icij/manifest?dataset=offshore-leaks
• GET /icij/search?q=Acme&type=entity&dataset=offshore-leaks
• GET /icij/nodes/:id
• GET /icij/nodes/:id/relationships
• GET /icij/company-links?q=Acme&dataset=offshore-leaks
• GET /linked-offshore?officer_id=123&limit=50&offset=0
• GET /officers-search?name=John
• GET /entities-search?company_id=123
• GET /company-counts — aggregated counts from data/company_counts_by_officer_country.csv

Frontend Pages

• ICIJ API Search — /icij.html
• Local CSV API — /local.html
• Tabular Data — /tabular.html

Scripts

• npm run dev — start server
• npm test — run tests

Notes on Data

This project expects ICIJ Offshore Leaks CSV extracts. Some fields use non‑ISO jurisdiction codes (e.g., BVI, PMA), which are mapped in the frontend.

License & Attribution

The Offshore Leaks Database is licensed under ODbL. Please cite the International Consortium of Investigative Journalists (ICIJ) when using this data.