Open data

Download every dataset behind this site

Source data is public domain (US government works). Mirrors of the FOIA.gov bulk CSVs and the Quarterly Report API, normalized into Postgres and re-exported as RFC 4180 CSV. Filter by agency name in your spreadsheet of choice; no auth required.

Annual ingest
May 4, 2026, 7:41 PM
46,230 rows ingested. Bulk CSV ZIPs FY2008–FY2024.
Quarterly ingest
May 5, 2026, 2:02 AM
1,943 rows ingested. Latest quarter: FY2026 Q2 (Jan 1 – Mar 31, 2026).

Annual report — headline

1,821 rows

Per agency-component, per fiscal year: requests pending at start, received, processed, pending at end. The core long-term series.

Source: FOIA.gov bulk Annual Report ZIPs (FY2008–FY2024)
Columns
agency, component, fiscal_year, pending_start, received, processed, pending_end
Download CSV/api/data/annual.csv

Quarterly report

1,942 rows

Per agency, per fiscal-year quarter: received, processed, backlogged. The freshest series. Most recent in the database: FY2026 Q2 (Jan 1 – Mar 31, 2026).

Source: FOIA.gov Quarterly Report JSON:API
Columns
agency, component, fiscal_year, fiscal_quarter, received, processed, backlog
Download CSV/api/data/quarterly.csv

10 oldest pending requests

18,020 rows

Per agency, per fiscal year: the 10 oldest unanswered requests still open at year-end, with their original filing dates and days pending. Litigation-priority data.

Source: FOIA.gov bulk Annual Report ZIPs
Columns
agency, component, fiscal_year, rank, date_received, days_pending
Download CSV/api/data/oldest-pending.csv

Exemption invocations

24,568 rows

Per agency, per fiscal year, per FOIA exemption (b1–b9): how often the agency invoked that exemption when redacting or denying records. Counts are per invocation, not per request.

Source: FOIA.gov bulk Annual Report ZIPs
Columns
agency, component, fiscal_year, exemption, invocations
Download CSV/api/data/exemptions.csv

FOIA personnel

1,821 rows

Per agency, per fiscal year: full-time FOIA employees, equivalent FTE, total full-time staff. The denominator behind processing-time arguments.

Source: FOIA.gov bulk Annual Report ZIPs
Columns
agency, component, fiscal_year, full_time, equivalent_fte, total_fte
Download CSV/api/data/personnel.csv

Slope chart — pre/post Trump

1,942 rows

Pre-computed snapshot for the home-page slope chart: each agency's quarterly backlog at FY2025 Q1 (Oct 1 – Dec 31, 2024, the last full quarter before Trump's Jan. 20, 2025 inauguration) versus the most recent published quarter, with absolute and percentage change.

Source: Derived from quarterly report data
Columns
agency, baseline_period, baseline_backlog, current_period, current_backlog, delta_abs, delta_pct
Download CSVDownload chart (SVG)/api/data/slope.csv

Using the data

  • License. US government works are public domain. Attribution to FOIA.gov and FOIA Tracker is polite but not legally required.
  • Refresh cadence. Bulk CSVs monthly, quarterly API weekly during a published quarter. All ingest scripts are idempotent — re-running them upserts in place.
  • Schema. Postgres source-of-truth lives in scripts/schema.sql in the repo. Each CSV column maps 1:1 to a database column.
  • Caveats. Numbers are self-reported by agencies; definitions vary across years. See the about page for the full caveat list before doing analysis.
  • API access. Each CSV URL is a stable HTTP endpoint — script against it directly. Cache headers allow public, 5-minute caching.