data . willkara
dataset · NYC TLC · Parquet

NYC TLC taxi trip records

1.5 billion yellow / green / FHV trips since 2009, distributed as monthly Parquet files. Stories use build-time DuckDB aggregates. The Playground tab runs DuckDB WASM in your browser — queries execute locally against remote Parquet, no server involved.

About this dataset

Scale

1.5 billion rows, 50+ GB of Parquet. Monthly files going back to 2009.

Architecture

Stories use frozen aggregates built with DuckDB at deploy time. The Playground tab uses DuckDB WASM — queries run in your browser, no server involved.

Coverage

Yellow + green cabs, FHV (for-hire vehicles), and FHVHV (Uber / Lyft / Via). Schema includes fare, tip, distance, pickup/dropoff zones.

Stories from this dataset

story

The black car takeover

How Uber and Lyft hollowed out the yellow cab industry, 2017–2023.

story

NYC at 3 am

Where the city ends up after midnight — yellow cab drop-offs by zone.

story

Tip geography

Which neighborhoods tip the most, and what the data can and cannot say.

story

The congestion pricing effect

Did the $9 toll shift demand away from the Manhattan CBD?

Available Parquet files

Monthly files from the TLC's public distribution. Use these URLs in the Playground tab with read_parquet('url').

yellow 2025-01 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2025-01.parquet
yellow 2025-02 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2025-02.parquet
yellow 2025-03 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2025-03.parquet
yellow 2024-01 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-01.parquet
yellow 2024-02 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-02.parquet
yellow 2024-03 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-03.parquet
yellow 2024-04 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-04.parquet
yellow 2024-05 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-05.parquet
yellow 2024-06 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-06.parquet
yellow 2024-07 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-07.parquet
yellow 2024-08 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-08.parquet
yellow 2024-09 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-09.parquet
yellow 2024-10 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-10.parquet
yellow 2024-11 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-11.parquet
yellow 2024-12 https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2024-12.parquet

→ Open the Playground to query these files directly.