Taxi & Limousine Commission311Search all NYC.gov websites
TLC Trip Record Data
Yellow and green taxi trip records include fields capturing pick-up and drop-off dates/times, pick-up 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 pick-up date, time, and taxi zone location ID (shape file below). These records are generated from the FHV Trip Record submissions made by bases. Note: The TLC publishes base trip record data as submitted by the bases, and we cannot guarantee or confirm their accuracy or completeness. Therefore, this may not represent the total amount of trips dispatched by all TLC-licensed bases. The TLC performs routine reviews of the records and takes enforcement actions when necessary to ensure, to the extent possible, complete and accurate information.
ATTENTION!
On 05/13/2022, we are making the following changes to trip record files:
- All files will be stored in the PARQUET format. Please see the ‘Working With PARQUET Format’ under the Data Dictionaries and MetaData section.
- Trip data will be published monthly (with two months delay) instead of bi-annually.
- HVFHV files will now include 17 more columns (please see High Volume FHV Trips Dictionary for details). Additional columns will be added to the old files as well. The earliest date to include additional columns: February 2019.
- Yellow trip data will now include 1 additional column (‘airport_fee’, please see Yellow Trips Dictionary for details). The additional column will be added to the old files as well. The earliest date to include the additional column: January 2011.
2023
|
January
February
March
|
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 |
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)
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.