cityofnewyork-us/2019-yellow-taxi-trip-data-2upf-qytp

 
External

2019 Yellow Taxi Trip Data

  • trip data
  • yellow taxi

2019 Yellow 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
VendorIDvendoridvendoridNumber
DOLocationIDdolocationiddolocationidNumber
congestion_surchargecongestion_surchargecongestion_surchargeText
extraextraextraNumber
store_and_fwd_flagstore_and_fwd_flagstore_and_fwd_flagText
tpep_dropoff_datetimetpep_dropoff_datetimetpep_dropoff_datetimeCalendar date
RatecodeIDratecodeidratecodeidNumber
PULocationIDpulocationidpulocationidNumber
payment_typepayment_typepayment_typeNumber
mta_taxmta_taxmta_taxNumber
improvement_surchargeimprovement_surchargeimprovement_surchargeNumber
fare_amountfare_amountfare_amountNumber
total_amounttotal_amounttotal_amountNumber
tolls_amounttolls_amounttolls_amountNumber
tip_amounttip_amounttip_amountNumber
tpep_pickup_datetimetpep_pickup_datetimetpep_pickup_datetimeCalendar date
passenger_countpassenger_countpassenger_countNumber
trip_distancetrip_distancetrip_distanceNumber

Upstream Metadata