DataBench for Public-Data Reporters
A Mac or Windows desktop app that lets a journalist or graduate student load a 100-million-row public dataset (census, FCC, SEC filings, crime stats) and explore it visually with pivots, joins, and saved analyses — no SQL required and no data leaves the laptop.
Data journalists, graduate students, and policy researchers working with large public datasets
- One-click loaders for the most common public datasets (Census ACS, FCC broadband, SEC EDGAR, OpenStreetMap) with automatic schema guesses
- Visual pivot table builder so non-coders can drag columns to rows and values without writing SQL
- Citation helper that exports a chart with the exact query and data version used, suitable for footnotes
- Offline mode so a reporter can work on a plane without losing responsiveness on 100M rows
The Dev.to experiment showed ClickHouse on a laptop returns dashboard queries in under 300 ms at 100M rows — exactly the experience journalists need when chasing a tip on a deadline without IT support.
Columbia Journalism School and Knight Science Journalism maintain curated data-journalism tool lists, and dadroit.com compares 20+ tools for opening large CSVs, showing recurring pain around big local datasets in newsrooms and academic workflows.Tools | Data Journalism Resources (Columbia Journalism School) ↗How to Open Large CSV Files: 20+ Tools Compared (2026) ↗
No dominant product combines 'no-SQL + 100M-row local pivot/join + saved analyses' for journalists; Tableau/Power BI are enterprise-priced, OpenRefine/CSVkit need scripting, Modern CSV is an editor, Datawrapper is web-only, leaving a real but narrow gap.11 Best Alternatives to Power BI and Tableau for 2026 ↗Data Journalism Toolkit - Knight Science Journalism @MIT ↗
Newsroom budgets are shrinking and comparable offerings (OpenRefine, CSVkit, Datawrapper, Modern CSV free tier) are free/open source; fieldwork.news' 2026 guide lists mostly free tools, indicating low willingness to pay for a desktop app in this audience.Tools for Data Journalism: From Raw Data to Published Story (2026) ↗Modern CSV - CSV File Editor, Viewer, and Analyzer ↗
Government open-data programs (census, FCC, SEC, crime stats) are entrenched and growing; even the automated-journalism adjacent market is projected at multi-billion CAGR, suggesting sustained demand for public-data exploration tooling.Automated Journalism Market 2026-2035 ↗
DuckDB-vs-ClickHouse-Local benchmarks on Dev.to confirm laptop-class engines handle 100M-row analytical queries fast, so the data engine is proven; remaining work is wrapping pivots/joins/saved-analyses UX on top, which is moderate.DuckDB vs. ClickHouse Local: A Comparative Analysis for Analytical Workloads ↗