Query the graph with SQL

Ask the data anything, in SQL, in your browser. The tables are made from the site's own public JSON (events.json, graph.json and, as they land, /api/v1/graph/<type>.json). Nothing you type leaves your browser. It runs sql.js (SQLite compiled to WebAssembly), pinned to one version and checked by hash.

Try one

Your query

Run (Ctrl+Enter) Loading…

The tables

Every column is text or a number; lists (topics) are text, so use LIKE. {today} in a query becomes today's date (UTC), and {now} the current time. A column named page becomes a link to the site's page.

• Loading…