cityofnewyork-us/2017-yellow-taxi-trip-data-biws-g3hs

 
External

2017 Yellow Taxi Trip Data

  • 2018od4a-report

2017 Yellow Taxi Trip Data

This dataset includes trip records from all trips completed in yellow taxis from in NYC during 2017. 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 Passenger Enhancement Program (TPEP). The trip data was not created by the TLC, and TLC makes no representations as to the accuracy of these data.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
store_and_fwd_flagstore_and_fwd_flagstore_and_fwd_flagText
passenger_countpassenger_countpassenger_countNumber
improvement_surchargeimprovement_surchargeimprovement_surchargeNumber
trip_distancetrip_distancetrip_distanceNumber
mta_taxmta_taxmta_taxNumber
payment_typepayment_typepayment_typeNumber
extraextraextraNumber
tpep_dropoff_datetimetpep_dropoff_datetimetpep_dropoff_datetimeCalendar date
tpep_pickup_datetimetpep_pickup_datetimetpep_pickup_datetimeCalendar date
total_amounttotal_amounttotal_amountNumber
fare_amountfare_amountfare_amountNumber
RatecodeIDratecodeidratecodeidNumber
tip_amounttip_amounttip_amountNumber
VendorIDvendoridvendoridNumber
DOLocationIDdolocationiddolocationidNumber
tolls_amounttolls_amounttolls_amountNumber
PULocationIDpulocationidpulocationidNumber

Upstream Metadata