SQL Console
Query the Auckland transit data lake directly in your browser using DuckDB WASM. All data is publicly accessible via Parquet files.
Tables
Real-time bus GPS locations
Arrival/departure predictions with delays
Service disruption notifications
SQL Editor
No results yet
Run a query to see results here
Loading...
Executing query...
Query Error
Query returned no results
Example Queries
Tips
- • Press Ctrl+Enter to run query
- • Use
LIMITfor large results - • Click table/column names to insert them
- • Queries run entirely in your browser
Large Query Warning
Your query doesn't include a LIMIT clause. This might download and process a large amount of data, which could slow down your browser or use significant bandwidth.
Consider adding LIMIT 1000 to your query.