Public data, instantly queryable

A curated registry of DuckDB databases built from government and research data. Connect and query in seconds.

--
Rows
--
Databases
Free and open source
License
uv pip install datapond

Available Databases

Loading databases

Updates

September 17, 2026
Two national databases: police stops and the federal judiciary

open-policing: every standardized stop released by the Stanford Open Policing Project, 35 state patrols and 53 city or county departments in one table (230.0M stops), with the project's standardized columns typed and each location's raw source fields kept, plus a locations table with observed and stated coverage. courtlistener: CourtListener's judge database (16,190 judges, 51,289 positions), its registry of 3,353 courts, and 32,336 federal judicial financial disclosure reports with their gifts, debts, reimbursements and income line items, joinable to the FJC directory. Also this week: an independent audit of every repository and database, answered in four rounds (see the changelog). Full changelog →

September 15, 2026
Six new legal-system databases: federal courts and judges, the Supreme Court, border enforcement, sentencing, Cook County prosecutions

fjc: the Federal Judicial Center's Integrated Database, every federal civil case since 1988, criminal defendant since FY1970 and appeal since 1971 (21.1M rows), with the two file eras unioned and invalid source dates audited rather than silently dropped. cbp: the Deportation Data Project's CBP FOIA releases, Border Patrol apprehensions, encounters, port-of-entry inadmissibles, Title 42 expulsions and CBP One (51.3M rows), 121 differently-shaped spreadsheets harmonised into one schema per record type with every source file documented. ussc: the U.S. Sentencing Commission's individual offender datafiles, every federal defendant sentenced FY2002-FY2025 (1.72M defendants, 14.0M rows), reshaped from a 22,000-variable fixed-width record into a sentences table plus long tables per count, guideline computation, drug type and departure reason. cook-sao: the Cook County (Chicago) State's Attorney's felony case datasets, 2011 until the Office closed the series at the end of 2024 (3.2M rows): felony review, charges and bond at initiation, dispositions with judge and court, sentences, diversion referrals. scdb: the Supreme Court Database, every decision 1791-present at the case and justice level with its 2,949-entry code book loaded as a table. fjc-judges: the FJC's biographical directory of every Article III judge since 1789, with each appointment's nomination-to-commission timeline. Each ships with a data dictionary, researcher caveats, and works from Python and R today. Full changelog →

September 14, 2026
September refresh + R package

Six databases rebuilt from their latest sources: immigration courts through the August 2026 DOJ file (173M rows), ICE enforcement through August 6 from the Deportation Data Project's new release (23.6M rows, with a new arrest city field), ClinicalTrials.gov as of September 14 (59M rows), DOL H-1B/PERM through FY2026 Q3 (with a fix for date columns that had been empty), and FEC campaign finance through the current 2026 cycle (355M rows), plus IPEDS through the 2025-26 provisional release (27.9M rows). The July audit's repairs now run as regression checks inside every build. New: an R package with the same API as the Python client, and datapond 0.1.3 on PyPI. Full changelog →

July 6, 2026
Full refresh + data-quality audit of all databases

Every existing database was rebuilt from its latest source (ICE gains a new encounters table and the 2026 FOIA release; CMS Medicare adds CY2024; FEC covers the 2026 cycle), then independently audited from a researcher's perspective and repaired — including fixes to views, lookups, and column typing that affected published-number accuracy. Two databases were added the next day: CMS Open Payments (172.5M rows) and DOL H-1B/PERM visa disclosures (8.5M rows). Each README now carries a researcher-caveats section, and every HuggingFace dataset page includes the changelog. Full changelog →

Getting Started

Every database can be queried remotely in seconds with no full download (DuckDB fetches only the byte ranges your query needs), or downloaded locally for full speed.

1
Install
2
Query remotely (no full download)
3
Or download for full speed
4
Use plain SQL for anything

Add a Database

datapond is open for new databases from any public data source. If you have a dataset that would be useful as a queryable DuckDB database, we would love to include it.

Read the contributing guide