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

Taxi Zone Maps and Lookup Tables

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

2024

January

February

March

April

May

June

July

August

September

October

November

December

2023

January

February

March

April

May

June

July

August

September

October

November

December

2022

January

February

March

April

May

June

July

August

September

October

November

December

2021

January

February

March

April

May

June

July

August

September

October

November

December

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.

January

February

March

April

May

June

July

August

September

October

November

December

2019

January

February

March

April

May

June

July

August

September

October

November

December

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

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.