Taxi & Limousine Commission311Search all NYC.gov websites
TLC Trip Record Data
Yellow and green taxi trip records include fields capturing pickup and drop-off dates/times, pickup and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts. The data used in the attached datasets were collected and provided to the NYC Taxi and Limousine Commission (TLC) by technology providers authorized under the Taxicab & Livery Passenger Enhancement Programs (TPEP/LPEP). The trip data was not created by the TLC, and TLC makes no representations as to the accuracy of these data.
For-Hire Vehicle (“FHV”) trip records include fields capturing the dispatching base license number and the pickup date, time, and taxi zone location ID (shape file below).These records are generated from the FHV Trip Record submissions made by bases, so we cannot guarantee or confirm their accuracy or completeness. The TLC performs routine reviews of the records and takes enforcement actions when necessary to ensure, to the extent possible, complete and accurate information. Since 2019 high volume trip records (HVFHV) are reported in a separate (and more detailed) dataset.
For 2025 data onwards, a cbd_congestion_fee column has been added to the Yellow, Green, and High Volume FHV datasets to reflect new congestion pricing charges.
Data Dictionaries and MetaData
- Trip Record User Guide
- Yellow Trips Data Dictionary
- Green Trips Data Dictionary
- FHV Trips Data Dictionary
- High Volume FHV Trips Data Dictionary
- Working With PARQUET Format
Taxi Zone Maps and Lookup Tables
- Taxi Zone Lookup Table (CSV)
- Taxi Zone Shapefile (PARQUET)
- Taxi Zone Map – Bronx (JPG)
- Taxi Zone Map – Brooklyn (JPG)
- Taxi Zone Map – Manhattan (JPG)
- Taxi Zone Map – Queens (JPG)
- Taxi Zone Map – Staten Island (JPG)
Trip Record Data Download Links
Trip data is published monthly on this website, typically with a two-month delay to allow time for full vendor submissions. Due to the size of the datasets, the trip record files have been stored in the PARQUET format. Please see the ‘Working With PARQUET Format’ under the Data Dictionaries and MetaData section for details. Please be advised that there may be minor changes in the near future to standardize the parquet schema across all years and datasets. If you would like to view the data on NYC Open Data, and export the data in various other formats, you may view the collection here .
2025
|
January
February
|
2024
2023
2022
2021
2020
Due to COVID-19 and its impact on the daily operations of small businesses, TLC granted smaller bases an extension on trip record submissions. Trip and trip-related data for these bases will be updated as it becomes available.
2019
2018
2017
2016
2015
2014
| January February March April May June | July August September October November December |
2013
| January February March April May June | July August September October November December |
2012
| January February March April May June | July August September October November December |
2011
| January February March April May June | July August September October November December |
2010
| January February March April May June | July August September October November December |
2009
| January February March April May June | July August September October November December |
Errata
- 09/08/2017 - FHV trip record files from June 2017 updated as of 09/08/2017
- 08/30/2017 - FHV trip record files from July 2016 through June 2017 updated as of 08/16/2017
- 03/13/2017 - FHV trip record files from January 2016 through December 2016 updated as of 02/14/2017
- 09/22/2015 - TPEP and LPEP trip data PARQUETs from January through June 2015 have been updated to include a new field [improvement_surcharge] which lists the itemized portion of the fare covering the Taxicab Improvement Surcharge or Street Hail Livery Improvement Surcharge. This is a $0.30 surcharge on all trips to help fund accessibility in taxis and SHLs, which began on January 1, 2015. All TPEP and LPEP trip data files uploaded moving forward will also include this new field.