OpenAid Ledger

Data downloads

The whole ledger, rebuilt every night as plain files, so nobody has to depend on this site to keep a copy. Flat tables are gzipped CSV; project versions and changes are gzipped JSON lines, one record per line. A manifest lists row counts and checksums.

Latest: api.openaidledger.org/dumps/latest/ · dated folders: /dumps/YYYY-MM-DD/

Dump of 2026-09-28, built 2026-09-28 14:13 UTC, covering the record since 26 Sept 2026.

FileWhat it isRowsSize
datasets.csv.gzEvery dataset the IATI Registry has listed since the ledger began, with first/last seen and removal dates.13,949205 KB
observations.csv.gzThe register: one row per dataset per crawl, with HTTP status, file fingerprint and whether it changed.56,8052.6 MB
file_events.csv.gzFile-level events: appeared, vanished, reappeared, content_changed, url_changed, fetch_failed, fetch_recovered.16,677427 KB
file_versions.csv.gzWhich project versions each stored file version contains (file sha256 -> IATI identifier -> project version hash).1,101,66547.5 MB
project_versions.jsonl.gzEvery distinct parsed version of every project: titles, status, dates, organisations, sectors, budgets and transactions.942,497462 MB
project_changes.jsonl.gzProject-level change events with severity (0 cosmetic, 1 notable, 2 material), details, model summary, and the two file versions compared.108,4468.0 MB
manifest.jsonRow counts, sizes, sha256 of each file, schema notes, licence.——

How the files fit together

Start from observations: one row per dataset per crawl with the file's sha256 fingerprint. file_versions maps each fingerprint to the project versions it contained, and project_versions holds each version's parsed fields. project_changes is the diff between consecutive versions with severity, details and the model summary. Any file version can be fetched exactly as stored from /v1/files/<sha256>.

Retention

The last seven nightly dumps and the first dump of every month stay online. Older dumps are kept in cold storage and can be requested.

Licence

Source data is published by each organisation to the IATI Registry under its own open licence (most commonly CC-BY); attribution to the original publisher is required. The ledger's own record (observations, fingerprints, change events, summaries) is released under CC-BY 4.0: use it freely, cite OpenAid Ledger (https://openaidledger.org).