Data journalists routinely integrate records across multiple independently published sources to support accountability reporting, yet no existing interactive wrangling tool treats the collection of tables -- rather than the single table -- as its primary unit of work. We present OpenRoundup, an open-source, browser-based system that enables data journalists to consolidate multiple tables into a single analysis-ready output without writing code. The interface comprises five coordinated panels that implement a schema-first, values-on-demand paradigm with live schema previews, ambient data quality alerts, and a recursive treemap visualization of the evolving operation tree. A client-only architecture powered by DuckDB-WASM runs in the browser, providing strong data privacy guarantees suited to sensitive journalism data. The system introduces two conceptual contributions: eager table consolidation, in which a composite table is assembled early in the wrangling phase via interactive, incremental assembly of multiple source tables; and a declarative vocabulary for table consolidation consisting of two operations, Stack and Pack. We evaluate the system through a replication study in which the authors reproduce 17 published journalist programming workflows using only the interface, and a deployment study with four professional data journalists. The replication study demonstrates expressive coverage of real-world consolidation tasks. The deployment study confirms utility for practitioners who understand joins conceptually but lack the programming skills to execute them, and surfaces an unanticipated secondary value for data journalism education.
翻译:数据记者通常需要整合多个独立发布的来源记录以支持问责报道,但现有交互式整理工具均以单表而非多表集合为主要工作单元。我们提出OpenRoundup——一款基于浏览器的开源系统,使数据记者无需编写代码即可将多个表格合并为统一的分析就绪输出。其界面包含五个协同面板,实现了"先定义模式、按需加载值"的范式,具备实时模式预览、环境数据质量提示以及操作树演化的递归树状图可视化功能。基于DuckDB-WASM构建的纯客户端架构在浏览器中运行,为敏感新闻数据提供了强大的隐私保障。该系统提出两项概念贡献:一是主动式表格合并——在整理阶段早期通过交互式增量组装将多个源表合并为复合表;二是由Stack与Pack两种操作构成的声明式表格合并词汇表。我们通过复现研究(作者仅使用界面重现17个已发表的记者编程工作流)及部署研究(四位专业数据记者参与)评估系统功能。复现研究验证了系统对真实世界合并任务的表现力,部署研究则证实其对理解连接概念但缺乏编程技能的从业者具有实用性,并发现了数据新闻教育中的意外辅助价值。