cityofnewyork-us/2019-green-taxi-trip-data-q5mz-t52e

 
External

2019 Green Taxi Trip Data

  • green taxi
  • trip data

2019 Green Taxi Trip Data

The 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 more information please refer to http://www.nyc.gov/html/tlc/html/about/trip_record_data.shtml

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
mta_taxmta_taxmta_taxNumber
total_amounttotal_amounttotal_amountNumber
tip_amounttip_amounttip_amountNumber
extraextraextraNumber
congestion_surchargecongestion_surchargecongestion_surchargeText
DOLocationIDdolocationiddolocationidNumber
payment_typepayment_typepayment_typeNumber
trip_typetrip_typetrip_typeNumber
store_and_fwd_flagstore_and_fwd_flagstore_and_fwd_flagText
lpep_dropoff_datetimelpep_dropoff_datetimelpep_dropoff_datetimeCalendar date
passenger_countpassenger_countpassenger_countNumber
fare_amountfare_amountfare_amountNumber
improvement_surchargeimprovement_surchargeimprovement_surchargeNumber
RatecodeIDratecodeidratecodeidNumber
PULocationIDpulocationidpulocationidNumber
VendorIDvendoridvendoridNumber
trip_distancetrip_distancetrip_distanceNumber
lpep_pickup_datetimelpep_pickup_datetimelpep_pickup_datetimeCalendar date
tolls_amounttolls_amounttolls_amountNumber
ehail_feeehail_feeehail_feeText

Upstream Metadata