funder-graph

funder-graph › Data

The dataset

The pages on this site are one view of a public dataset. The dataset is the product: every grant a foundation reported paying, as Parquet, with a checksummed manifest, queryable over HTTPS from DuckDB with nothing installed and no account.

Current version
2026.09.0 · built 2026-09-02
Grant rows
2,847,781
Funders
133,583
Resolved recipients
542,269
Manifest
https://data.opengrants.io/funder-graph/2026.09.0/manifest.json
Latest alias
https://data.opengrants.io/funder-graph/latest/manifest.json — a copy of the current version; pin an explicit version for anything you will be asked to reproduce
License
Apache 2.0 for the derived structure, matching and documentation; the source is US federal government work
Schema and pipeline
README, published schema · source

Query it in sixty seconds

Paste this into DuckDB — the desktop shell, or shell.duckdb.org in a browser. It reads the Parquet footer over HTTP range requests and pulls only the row groups it needs; it does not download the dataset. One URL per filing year, listed explicitly, because HTTP has no directory listing; the manifest carries the full list.

INSTALL httpfs; LOAD httpfs;

SELECT recipient_name_raw, recipient_state, amount_usd, tax_year, grant_purpose
FROM read_parquet(
  [ 'https://data.opengrants.io/funder-graph/2026.09.0/grants/filing_year=2023/part-0000.parquet' ],
  hive_partitioning = 1
)
WHERE funder_ein = '942278431'   -- The David and Lucile Packard Foundation
  AND amount_type = 'paid'
ORDER BY amount_usd DESC
LIMIT 25;

Reverse the question with WHERE recipient_ein_resolved = '363673599' AND match_confidence >= 0.90 to see who has funded Feeding America. The confidence filter is there for a reason; see the tiers.

The convenience JSON

Every funder page is also available as /api/funders/<ein>.json: the same payload the page renders from, CORS-open, no key. It is a convenience for people who want the page's numbers without the page. It is explicitly not an SLA-backed API; the Parquet is the stable interface.

Versions and citation

Versions are YYYY.MM.PATCH: the year and month of the IRS posting the release was built from, and a patch for a re-release that fixes a mapping without new source data. Every row carries object_id, tax_period_end and filing_submission_date, so any figure you publish traces to one filing.

Egeria Corporation. funder-graph: The Open 990 Funding Graph, dataset version 2026.09.0. Derived from IRS Form 990 and 990-PF e-file XML and the IRS Exempt Organizations Business Master File. Field mapping via the Nonprofit Open Data Collective IRS E-file Master Concordance File. https://github.com/egeria-corporation/funder-graph

This is informational only, derived from public data on the dates shown. It is not an eligibility determination, and not legal, tax, or accounting advice. Verify against the official source before relying on it.