Documentation Index
Fetch the complete documentation index at: https://docs.delphina.ai/llms.txt
Use this file to discover all available pages before exploring further.
Every regulated for-hire vehicle trip in New York City, published by the NYC Taxi & Limousine Commission (TLC). 2.2 billion+ trip records across yellow taxis, green taxis, Uber, Lyft, and traditional car services from 2018/2019 through early 2026.
At a glance
| |
|---|
| Schema | TLC_DATA.RAW |
| Services | Yellow Taxi, Green Taxi, Rideshare (Uber & Lyft), Car Service (livery/black car) |
| Date range | 2018/2019 through late 2025/early 2026 (varies by service) |
| Refresh | Periodic from TLC open data (published monthly, 1-3 month lag) |
| Timezone | All timestamps in NYC local time (Eastern) |
| Source | NYC TLC Trip Record Data |
| Service | Latest month |
|---|
| Rideshare | January 2026 |
| Car Service | December 2025 |
| Yellow Taxi | November 2025 |
| Green Taxi | December 2025 |
Tables
| Table | Description | Rows |
|---|
TLC_YELLOW_TRIPS | Metered yellow cab trips | ~298M |
TLC_GREEN_TRIPS | Green taxi (Boro Taxi) trips | ~12M |
TLC_FHVHV_TRIPS | Uber and Lyft trips | ~1.5B |
TLC_FHV_TRIPS | Livery and black car trips (no fare data) | ~407M |
TAXI_ZONE_LOOKUP | Zone-to-neighborhood mapping | 265 |
How the four services compare
| Service | How it works | Fare data | Watch out |
|---|
| Yellow Taxi | Metered street-hail, mostly Manhattan | Full: meter fare, tip, tolls, surcharges | Tips only captured on credit card |
| Green Taxi | Street-hail in outer boroughs + upper Manhattan | Full (same as yellow) | Much lower volume; has street-hail vs dispatch flag |
| Rideshare | App-dispatched (Uber ~75%, Lyft ~25%) | Both sides: passenger fare + driver pay | 1.5B rows — always filter on FILE_YEAR_MONTH |
| Car Service | Base-dispatched livery and black car | None — trip counts and locations only | No fare or payment info at all |
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?”
Good to know
| Note | Detail |
|---|
| Cash tips invisible | Taxi tip data only covers credit card payments. Cash tips aren’t recorded. |
| Rideshare is huge | 1.5B+ rows. Always filter on FILE_YEAR_MONTH or queries will be slow. |
| Car service = no fares | TLC_FHV_TRIPS has trip counts and locations only. |
| CBD fee is new | Manhattan congestion pricing started January 2025. CBD_CONGESTION_FEE only exists from that month onward. |
| COVID gap | Trip volumes cratered in 2020. Watch out for year-over-year comparisons spanning 2019-2021. |
