Drupal Code Query

Query

First query loads DuckDB-WASM (~5 s) and ATTACHes the api catalog. contrib_branch_dev, symbol_facts, seq(major, minor), _seq(v), and adoption_state(cr_nid, branch_id) are available alongside every base table.

Looking for one specific symbol? → Symbol Explorer

Use the data elsewhere

Hosted browser SQL: open sql-workbench.com with this catalog pre-attached as api. Same catalog this page uses — views contrib_branch_dev + symbol_facts, macros seq(major, minor) / _seq(v) / adoption_state(cr_nid, branch_id), and one view per public table.

# Bulk-download every parquet for offline work. api.duckdb itself is
# just a view catalog pointing at the remote parquets, so it's not
# self-contained — fetch the parquets, then read them locally.
curl -s https://api.tresbien.tech/data/latest/manifest.json \
  | jq -r '.tables[].name' \
  | xargs -I{} curl -OL https://api.tresbien.tech/data/latest/{}.parquet

-- DuckDB CLI, offline against the downloaded parquets
SELECT change_to, COUNT(*) FROM read_parquet('change_record.parquet')
GROUP BY change_to ORDER BY change_to;

For agents and crawlers: /llms.txt is the machine-friendly directory.

About the dataset →