At a glance
Latest data by service:
Tables
How the four services compare
Table details
Yellow taxis — TLC_YELLOW_TRIPS
~298M rows, Jan 2019 through Nov 2025. Metered yellow cab trips with full fare breakdowns (meter fare, tips, tolls, surcharges), trip distance, passenger count, and payment type. Tips are only captured on credit card payments.
Green taxis — TLC_GREEN_TRIPS
~12M rows, Jan 2019 through Dec 2025. Boro taxis authorized for street-hail in outer boroughs and upper Manhattan. Same fare structure as yellow taxis, with an additional flag distinguishing street-hail from dispatch trips.
Rideshare — TLC_FHVHV_TRIPS
~1.5B rows, Feb 2019 through Jan 2026. Every Uber and Lyft trip. Includes both what the passenger paid and what the driver received, so you can analyze platform take rates. Also includes pooled ride flags, wheelchair accessibility data, and timestamps for request, arrival, pickup, and dropoff.
Car service — TLC_FHV_TRIPS
~407M rows, Jan 2018 through Dec 2025. Traditional livery and black car trips. No fare data — trip counts and locations only.
Zone lookup — TAXI_ZONE_LOOKUP
265 rows, static. Maps zone IDs to borough, neighborhood, and service zone (Yellow Zone, Boro Zone, Airports, EWR).
Useful analyses
- Platform take rate: How much does Uber/Lyft keep per trip vs what the driver receives?
- Tip patterns: Average tip rate on credit card taxi trips, and how it varies by trip length or time of day.
- Revenue per mile: How do fares compare across services and boroughs?
- Congestion pricing impact: Compare trip volumes and fares before/after the January 2025 CBD fee launch.
- Market share: Trip counts across all four services over time.
Try asking
Market trends
- “How has total NYC trip volume changed since 2019?”
- “What’s Uber’s vs Lyft’s market share over time?”
- “How did rideshare recover after COVID?”
Fares and revenue
- “Average yellow taxi fare by month this year?”
- “How much does Uber keep per trip vs what the driver gets?”
- “Total taxi fare revenue trend year over year?”
Geography
- “Which borough has the most rideshare pickups?”
- “JFK vs LaGuardia airport trips per month?”
- “Average fare for a Manhattan-to-JFK taxi ride?”
Congestion pricing
- “CBD congestion fee revenue since the January 2025 launch?”
- “Congestion surcharge trend for Manhattan trips?”
- “What share of Uber rides are pooled?”
Tipping
- “Average tip rate on credit card yellow taxi trips?”
- “Has contactless/tap-to-pay grown over time?”
- “Do riders tip more on longer trips?”