cityofnewyork-us/2020-yellow-taxi-trip-data-january-june-kxp8-n2sj

 
External

2020 Yellow Taxi Trip Data (January - June)

  • base
  • fhv
  • high volume
  • lyft
  • trip
  • And 4 more...

2020 Yellow Taxi Trip Data (January - June)

These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow taxi in 2020. The 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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
VendorIDvendoridvendoridnumber
tpep_pickup_datetimetpep_pickup_datetimetpep_pickup_datetimecalendar_date
tpep_dropoff_datetimetpep_dropoff_datetimetpep_dropoff_datetimecalendar_date
passenger_countpassenger_countpassenger_countnumber
trip_distancetrip_distancetrip_distancenumber
RatecodeIDratecodeidratecodeidnumber
store_and_fwd_flagstore_and_fwd_flagstore_and_fwd_flagtext
PULocationIDpulocationidpulocationidnumber
DOLocationIDdolocationiddolocationidnumber
payment_typepayment_typepayment_typenumber
fare_amountfare_amountfare_amountnumber
extraextraextranumber
mta_taxmta_taxmta_taxnumber
tip_amounttip_amounttip_amountnumber
tolls_amounttolls_amounttolls_amountnumber
improvement_surchargeimprovement_surchargeimprovement_surchargenumber
total_amounttotal_amounttotal_amountnumber
congestion_surchargecongestion_surchargecongestion_surchargenumber

Upstream Metadata