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. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.
This dataset has the following 20 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
passenger_count | passenger_count | number | The number of passengers in the vehicle. This is a driver-entered value. | 1 2 5 3 6 view top 100 |
trip_distance | trip_distance | number | The elapsed trip distance in miles reported by the taximeter. | 0.9 1 0.8 1.1 0.7 view top 100 |
pickup_longitude | pickup_longitude | number | Longitude where the meter was engaged. | 0 -73.982223510742188 -73.98223876953125 -73.982139587402344 -73.982200622558594 view top 100 |
pickup_latitude | pickup_latitude | number | Latitude where the meter was engaged. | 0 40.774070739746094 40.77410888671875 40.774078369140625 40.774101257324219 view top 100 |
RateCodeID | ratecodeid | number | 1 2 5 3 4 view top 100 | |
store_and_fwd_flag | store_and_fwd_flag | text | This 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 | N Y view top 100 |
dropoff_longitude | dropoff_longitude | number | Longitude where the meter was disengaged. | 0 -73.982330322265625 -73.982223510742188 -73.982307434082031 -73.982383728027344 view top 100 |
dropoff_latitude | dropoff_latitude | number | Latitude where the meter was disengaged. | 0 40.750148773193359 40.750091552734375 40.750110626220703 40.750068664550781 view top 100 |
fare_amount | fare_amount | number | The time-and-distance fare calculated by the meter. | 6 6.5 7 5.5 7.5 view top 100 |
extra | extra | number | Miscellaneous extras and surcharges. Currently, this only includes the $0.50 and $1 rush hour and overnight charges. | 0 0.5 1 -0.5 -1 view top 100 |
mta_tax | mta_tax | number | $0.50 MTA tax that is automatically triggered based on the metered rate in use. | 0.5 0 -0.5 -1 0.25 view top 100 |
tip_amount | tip_amount | number | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. | 0 1 2 1.5 3 view top 100 |
tolls_amount | tolls_amount | number | Total amount of all tolls paid in trip. | 0 5.54 5.33 11.75 9.75 view top 100 |
total_amount | total_amount | number | The total amount charged to passengers. Does not include cash tips. | 7.8 7.3 8.3 8.8 6.8 view top 100 |
vendor_id | vendor_id | text | A designation for the technology vendor that provided the record. CMT=Creative Mobile Technologies VTS= VeriFone, Inc. DDS=Digital Dispatch Systems | 2 1 view top 100 |
pickup_datetime | pickup_datetime | calendar_date | The date and time when the meter was engaged. | 1 2 5 3 6 view top 100 |
dropoff_datetime | dropoff_datetime | calendar_date | The date and time when the meter was disengaged. | 1 2 5 3 6 view top 100 |
rate_code | rate_code | text | The 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 | 1 2 5 3 4 view top 100 |
payment_type | payment_type | text | A numeric code signifying how the passenger paid for the trip. 1= Credit card 2= Cash 3= No charge 4= Dispute 5= Unknown 6= Voided trip | 1 2 3 4 5 view top 100 |
imp_surcharge | imp_surcharge | number | $0.30 improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | 0.3 -0.3 0 0.1 0.19 view top 100 |