Skip to content
Docs

Uber, Lyft and Via trips

Every trip by the high-volume for-hire services since January 2023, from the TLC, with readable names and zones.

Rows
351,482,183
Size
9.7 GB
Covers
January 2023 onward; the TLC publishes about two months late
Updated
Monthly
Source
NYC TLC trip record data (high-volume for-hire vehicles)
Fileshttps://data.transitlab.nyc/v1/fhv_trips/year=YYYY/month=MM/YYYY-MM.parquetOne file a month, 17 so far. In the database as transitlab.fhv_trips.

Rows and size from catalog.json, 2026-10-06.

What a row is

Section titled “What a row is”

One trip by a company that dispatches more than 10,000 trips a day: in practice Uber, Lyft and Via. The TLC calls these high-volume for-hire services. They are the largest table we carry, about 20 million trips a month.

Each file is the TLC’s file for that month with a few changes, so every month has the same columns:

  • Readable names. Columns are renamed to one style across yellow, green and app trips (pickup_datetime, trip_miles, tip_amount), and codes are spelled out (payment_type is cash, not 2).
  • Zones added. Each trip has the name and borough of its pickup and drop-off taxi zone, so you rarely need the lookup table.
  • Light cleaning. We keep trips that start in the file’s month, end after they start, and last under a day. Nothing else is dropped, so outliers remain.

Query it

Section titled “Query it”
-- Uber and Lyft trips per weekday, by month
SELECT date_trunc('month', pickup_datetime) AS month,
       company,
       count(*) / count(DISTINCT pickup_datetime::DATE) AS trips_per_day
FROM transitlab.fhv_trips
WHERE pickup_datetime >= '2025-01-01'
  AND dayofweek(pickup_datetime) BETWEEN 1 AND 5
  AND company IN ('Uber', 'Lyft')
GROUP BY ALL
ORDER BY ALL;

Columns

Section titled “Columns”
companyvarchar

Uber, Lyft, Via or Juno.

license_numvarchar

TLC license: HV0003 Uber, HV0005 Lyft, HV0004 Via, HV0002 Juno.

dispatching_base_numvarchar

TLC base that dispatched the trip.

originating_base_numvarchar

Base that first received the request.

request_datetimetimestamp

When the rider asked for a car, New York local time.

on_scene_datetimetimestamp

When the driver arrived (Access-A-Ride trips only).

pickup_datetimetimestamp

Pickup, New York local time.

dropoff_datetimetimestamp

Drop-off, New York local time.

pickup_zone_idsmallint

TLC taxi zone of the pickup (1 to 263).

pickup_zonevarchar

Name of the pickup zone, e.g. Midtown Center.

pickup_boroughvarchar

Borough of the pickup zone, or EWR, Unknown, N/A.

dropoff_zone_idsmallint

TLC taxi zone of the drop-off.

dropoff_zonevarchar

Name of the drop-off zone.

dropoff_boroughvarchar

Borough of the drop-off zone.

trip_milesdouble

Distance in miles.

trip_minutesdouble

Minutes from pickup to drop-off.

fare_amountdouble

Base fare before tolls, taxes, fees and tips, in dollars.

tolls_amountdouble

Tolls.

black_car_funddouble

Black Car Fund fee.

sales_taxdouble

Sales tax.

congestion_surchargedouble

New York State congestion surcharge.

airport_feedouble

Airport fee.

cbd_congestion_feedouble

MTA congestion pricing toll, from 2025-01-05. Null before.

tip_amountdouble

Tip.

driver_paydouble

What the driver was paid, before tips.

shared_requestboolean

Rider agreed to share the ride.

shared_matchboolean

Rider shared the car with another booking.

access_a_rideboolean

Trip for an MTA Access-A-Ride rider.

wav_requestboolean

Rider asked for a wheelchair-accessible vehicle.

wav_matchboolean

The vehicle was wheelchair accessible.

Good to know

Section titled “Good to know”
  • Big. A month is several hundred MB. Name the columns you need and filter on time.
  • Fares are richer than taxis’. fare_amount, driver_pay and tip_amount let you compare what riders pay with what drivers get.
  • Smaller for-hire bases (car services, black cars) publish separately and aren’t in this table.
  • Terms: NYC public data. Credit the NYC Taxi and Limousine Commission.