cityofnewyork-us/2014-green-taxi-trip-data-2np7-5jsg

 
External

2014 Green Taxi Trip Data

  • driver
  • limousine
  • medallion
  • taxi
  • taxi driver
  • And 3 more...

2014 Green Taxi Trip Data

This dataset includes trip records from all trips completed in green taxis in NYC in 2014. 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
Dropoff_latitudedropoff_latitudedropoff_latitudeNumberLatitude where the meter was disengaged.
Ehail_feeehail_feeehail_feeNumber
Tolls_amounttolls_amounttolls_amountNumberTotal amount of all tolls paid in trip.
Passenger_countpassenger_countpassenger_countNumberThe number of passengers in the vehicle. This is a driver-entered value.
Fare_amountfare_amountfare_amountNumberThe time-and-distance fare calculated by the meter. Extra Miscellaneous extras and surcharges. Currently, this only includes the $0.50 and $1 rush hour and overnight charges.
pickup_datetimelpep_pickup_datetimelpep_pickup_datetimeCalendar dateThe date and time when the meter was engaged.
Store_and_fwd_flagstore_and_fwd_flagstore_and_fwd_flagTextThis flag indicates whether the trip record was held in vehicle memory before sending to the vendor, aka “store and forward,” because the vehicle did not have a connection to the server. Y= store and forward trip N= not a store and forward trip
dropoff_datetimelpep_dropoff_datetimelpep_dropoff_datetimeCalendar dateThe date and time when the meter was disengaged.
Dropoff_longitudedropoff_longitudedropoff_longitudeNumberLongitude where the meter was disengaged.
Pickup_longitudepickup_longitudepickup_longitudeNumber
Total_amounttotal_amounttotal_amountNumber
MTA_taxmta_taxmta_taxNumber$0.50 MTA tax that is automatically triggered based on the metered rate in use.
Payment_typepayment_typepayment_typeNumber
Trip_distancetrip_distancetrip_distanceNumberThe elapsed trip distance in miles reported by the taximeter.
rate_coderatecodeidratecodeidNumberThe final rate code in effect at the end of the trip. 1= Standard rate 2=JFK 3=Newark 4=Nassau or Westchester 5=Negotiated fare 6=Group ride
Tip_amounttip_amounttip_amountNumberTip amount – This field is automatically populated for credit card tips. Cash tips are not included.
Pickup_latitudepickup_latitudepickup_latitudeNumberLatitude where the meter was engaged.
ExtraextraextraNumber
Trip_typetrip_typetrip_typeNumber
vendoridvendoridvendoridTextA code indicating the TPEP provider that provided the record. 1= Creative Mobile Technologies, LLC; 2= VeriFone Inc.

Upstream Metadata