company
stringThe high-volume for-hire company that dispatched the trips: Uber, Lyft, Juno or Via.
- Uber51%
- Lyft49%
- Valid
- 370,752 · 100%
- Missing
- 0 · 0%
- Distinct
- 2 · 0% of valid
8.9 MB across 1 part, newest sealed 10 October 2026 at 23:50 UTC. The first build wrote 1 part and 370,752 rows.
The high-volume for-hire company that dispatched the trips: Uber, Lyft, Juno or Via.
The TLC high-volume license number of the company, such as HV0003 for Uber and HV0005 for Lyft.
2 distinct values, no chart
The calendar day of pickup, in New York local time.
per month
The hour of pickup, 0 to 23, in New York local time.
The TLC taxi zone ID where the trips began, 1 to 265.
262 distinct values, no chart
The borough of the pickup zone, from the TLC taxi zone lookup.
The name of the pickup zone, from the TLC taxi zone lookup.
The number of trips that began in this zone, hour and company.
Trips where the rider asked to share and was matched with another rider.
The total passenger trip distance, in miles.
The total passenger trip time, in minutes.
The total base passenger fare, in US dollars, before taxes, tolls and fees.
The total tips paid to drivers, in US dollars.
The total driver pay, in US dollars, excluding tips.
The average base passenger fare per trip, in US dollars, before taxes, tolls and fees.
The average trip distance, in miles.
The average trip time, in minutes.
Profile of the served version, all rows, computed 16 Nov 2026, 17:34 UTC
| Warning | Freshness | Latest event 41 d before this version |
|---|---|---|
| Passed | Gaps | No empty days |
| Passed | Anomalies | No spikes or dips |
| Passed | Unique keys | Every company · pickup_date · pickup_hour · pickup_zone_id is unique |