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:

  1. All files will be stored in the PARQUET format. Please see the ‘Working With PARQUET Format’ under the Data Dictionaries and MetaData section.
  2. Trip data will be published monthly (with two months delay) instead of bi-annually.
  3. 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.
  4. 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

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

Data Dictionaries and MetaData

Taxi Zone Maps and Lookup Tables

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.