cityofnewyork-us/2017-green-taxi-trip-data-5gj9-2kzx

 
External

2017 Green Taxi Trip Data

  • 2018od4a-report
  • driver
  • limousine
  • medallion
  • taxi
  • And 4 more...

2017 Green Taxi Trip Data

This dataset includes trip records from all trips completed in green taxis in NYC in 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 Livery Passenger Enhancement Program (LPEP). 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
tip_amounttip_amounttip_amountNumber
ehail_feeehail_feeehail_feeText
fare_amountfare_amountfare_amountNumber
VendorIDvendoridvendoridNumber
lpep_dropoff_datetimelpep_dropoff_datetimelpep_dropoff_datetimeCalendar date
payment_typepayment_typepayment_typeNumber
passenger_countpassenger_countpassenger_countNumber
extraextraextraNumber
trip_distancetrip_distancetrip_distanceNumber
mta_taxmta_taxmta_taxNumber
store_and_fwd_flagstore_and_fwd_flagstore_and_fwd_flagText
lpep_pickup_datetimelpep_pickup_datetimelpep_pickup_datetimeCalendar date
RatecodeIDratecodeidratecodeidNumber
PULocationIDpulocationidpulocationidNumber
trip_typetrip_typetrip_typeNumber
improvement_surchargeimprovement_surchargeimprovement_surchargeNumber
DOLocationIDdolocationiddolocationidNumber
total_amounttotal_amounttotal_amountNumber
tolls_amounttolls_amounttolls_amountNumber

Upstream Metadata