Hi! Could we please enable some services and cookies to improve your experience and our website?
Current database engine: DuckDB Preloaded (NYC Taxi) (duckdb_data)
A read-only DuckDB 1.5 (1.5.5) database preloaded with the table yellow_tripdata: about 2.96 million New York City yellow taxi trips of January 2024 from the NYC Taxi and Limousine Commission, with pickup and drop-off times, locations, distances, fares, tips and payment types.
The table is large enough to see why columnar engines are fast: aggregate trips by hour, day or zone, calculate percentiles of fares and tips, find outliers. To create your own tables, use the empty DuckDB playground.
NEW Now embed mode is available: put an interactive SQL editor on any web page with one script tag.
SQLize is a browser-based DuckDB Preloaded (NYC Taxi) SQL editor and query runner for fast testing, debugging, formatting, and sharing. It is useful for interview tasks, migration checks, analytics validation, and learning SQL in a real execution environment.
Developers, students and data analysts from more than 100 countries, most of all India, the United States, Russia, Brazil, Italy, Poland and Vietnam, use SQLize to run DuckDB Preloaded (NYC Taxi) queries online without installing a database server. A shareable link turns any query into a reproducible example for a colleague, a teacher or a question on Stack Overflow.