2016 Green Taxi Trip Data

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

Transportation Taxi and Limousine Commission (TLC) Dataset hvrh-b6nb 23 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:39.000
Lpep Dropoff Datetime
2016-01-01T01:19:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955078125
Pickup Latitude
40.735092163085938
Dropoff Longitude
-73.958045959472656
Dropoff Latitude
40.715248107910156
Passenger Count
1
Trip Distance
1.67
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:10.000
Lpep Dropoff Datetime
2016-01-01T01:20:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.884178161621094
Pickup Latitude
40.749794006347656
Dropoff Longitude
-73.916015625
Dropoff Latitude
40.759925842285156
Passenger Count
1
Trip Distance
1.99
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:07:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:07:09.000
Lpep Dropoff Datetime
2016-01-01T01:20:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966377258300781
Pickup Latitude
40.804458618164063
Dropoff Longitude
-73.939956665039063
Dropoff Latitude
40.85137939453125
Passenger Count
1
Trip Distance
4.22
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:18.000
Lpep Dropoff Datetime
2016-01-01T01:20:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946182250976563
Pickup Latitude
40.818138122558594
Dropoff Longitude
-73.954788208007812
Dropoff Latitude
40.805225372314453
Passenger Count
1
Trip Distance
1.14
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:05:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:05:15.000
Lpep Dropoff Datetime
2016-01-01T01:19:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939613342285156
Pickup Latitude
40.815952301025391
Dropoff Longitude
-73.9642333984375
Dropoff Latitude
40.794895172119141
Passenger Count
1
Trip Distance
2.32
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:22.000
Lpep Dropoff Datetime
2016-01-01T01:20:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908859252929688
Pickup Latitude
40.774795532226563
Dropoff Longitude
-73.899383544921875
Dropoff Latitude
40.747470855712891
Passenger Count
1
Trip Distance
2.61
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:07:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:07:02.000
Lpep Dropoff Datetime
2016-01-01T01:20:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976692199707031
Pickup Latitude
40.68719482421875
Dropoff Longitude
-73.951934814453125
Dropoff Latitude
40.732837677001953
Passenger Count
1
Trip Distance
3.84
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.44
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.24
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:09:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:09:29.000
Lpep Dropoff Datetime
2016-01-01T01:20:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915115356445312
Pickup Latitude
40.760433197021484
Dropoff Longitude
-73.933746337890625
Dropoff Latitude
40.745170593261719
Passenger Count
2
Trip Distance
1.90
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:07:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:07:57.000
Lpep Dropoff Datetime
2016-01-01T01:20:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914230346679688
Pickup Latitude
40.756778717041016
Dropoff Longitude
-73.870292663574219
Dropoff Latitude
40.751773834228516
Passenger Count
1
Trip Distance
3.44
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:17.000
Lpep Dropoff Datetime
2016-01-01T01:20:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937919616699219
Pickup Latitude
40.828414916992188
Dropoff Longitude
-73.952156066894531
Dropoff Latitude
40.819126129150391
Passenger Count
1
Trip Distance
1.24
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:14:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:14:07.000
Lpep Dropoff Datetime
2016-01-01T01:20:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943923950195313
Pickup Latitude
40.693740844726563
Dropoff Longitude
-73.970809936523438
Dropoff Latitude
40.687831878662109
Passenger Count
1
Trip Distance
1.68
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:12:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:12:02.000
Lpep Dropoff Datetime
2016-01-01T01:20:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919807434082031
Pickup Latitude
40.766273498535156
Dropoff Longitude
-73.912994384765625
Dropoff Latitude
40.774021148681641
Passenger Count
1
Trip Distance
0.00
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:08:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:08:28.000
Lpep Dropoff Datetime
2016-01-01T01:20:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950691223144531
Pickup Latitude
40.723678588867188
Dropoff Longitude
-73.968536376953125
Dropoff Latitude
40.709075927734375
Passenger Count
1
Trip Distance
1.84
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:05:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:05:19.000
Lpep Dropoff Datetime
2016-01-01T01:20:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950180053710938
Pickup Latitude
40.722831726074219
Dropoff Longitude
-73.942649841308594
Dropoff Latitude
40.687103271484375
Passenger Count
1
Trip Distance
4.04
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
3.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:04:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:04:24.000
Lpep Dropoff Datetime
2016-01-01T01:19:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95257568359375
Pickup Latitude
40.69537353515625
Dropoff Longitude
-73.953079223632812
Dropoff Latitude
40.655242919921875
Passenger Count
1
Trip Distance
2.85
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:14:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:14:30.000
Lpep Dropoff Datetime
2016-01-01T01:17:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95819091796875
Pickup Latitude
40.721641540527344
Dropoff Longitude
-73.957679748535156
Dropoff Latitude
40.730194091796875
Passenger Count
6
Trip Distance
0.75
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:12.000
Lpep Dropoff Datetime
2016-01-01T01:20:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942459106445313
Pickup Latitude
40.812103271484375
Dropoff Longitude
-73.956550598144531
Dropoff Latitude
40.813148498535156
Passenger Count
1
Trip Distance
1.03
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:55.000
Lpep Dropoff Datetime
2016-01-01T01:17:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.868843078613281
Pickup Latitude
40.749298095703125
Dropoff Longitude
-73.857460021972656
Dropoff Latitude
40.747112274169922
Passenger Count
6
Trip Distance
0.79
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:03:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:03:41.000
Lpep Dropoff Datetime
2016-01-01T01:20:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.885208129882813
Pickup Latitude
40.749378204345703
Dropoff Longitude
-73.9210205078125
Dropoff Latitude
40.739513397216797
Passenger Count
1
Trip Distance
2.32
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:19:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:19:53.000
Lpep Dropoff Datetime
2016-01-01T01:20:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.916549682617187
Pickup Latitude
40.855075836181641
Dropoff Longitude
-73.917900085449219
Dropoff Latitude
40.853252410888672
Passenger Count
1
Trip Distance
0.03
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
3.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:15:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:15:40.000
Lpep Dropoff Datetime
2016-01-01T01:20:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958145141601563
Pickup Latitude
40.719043731689453
Dropoff Longitude
-73.957855224609375
Dropoff Latitude
40.731666564941406
Passenger Count
1
Trip Distance
1.01
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:29.000
Lpep Dropoff Datetime
2016-01-01T01:20:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890884399414062
Pickup Latitude
40.7464599609375
Dropoff Longitude
-73.903366088867188
Dropoff Latitude
40.731121063232422
Passenger Count
1
Trip Distance
1.76
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:02:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:02:42.000
Lpep Dropoff Datetime
2016-01-01T01:20:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956413269042969
Pickup Latitude
40.747688293457031
Dropoff Longitude
-73.952041625976563
Dropoff Latitude
40.778335571289063
Passenger Count
5
Trip Distance
4.36
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:36.000
Lpep Dropoff Datetime
2016-01-01T01:20:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982902526855469
Pickup Latitude
40.693603515625
Dropoff Longitude
-73.951499938964844
Dropoff Latitude
40.725101470947266
Passenger Count
5
Trip Distance
3.80
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
3.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:06:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:06:33.000
Lpep Dropoff Datetime
2016-01-01T01:20:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919258117675781
Pickup Latitude
40.759101867675781
Dropoff Longitude
-73.919876098632812
Dropoff Latitude
40.759284973144531
Passenger Count
1
Trip Distance
1.54
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:06:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:06:35.000
Lpep Dropoff Datetime
2016-01-01T01:20:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954765319824219
Pickup Latitude
40.733188629150391
Dropoff Longitude
-73.910797119140625
Dropoff Latitude
40.712600708007812
Passenger Count
5
Trip Distance
3.39
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.14
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.94
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:08.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:08.000
Lpep Dropoff Datetime
2016-01-01T01:20:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90936279296875
Pickup Latitude
40.775161743164062
Dropoff Longitude
-73.918609619140625
Dropoff Latitude
40.765644073486328
Passenger Count
1
Trip Distance
1.12
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:15.000
Lpep Dropoff Datetime
2016-01-01T01:20:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.877304077148438
Pickup Latitude
40.737594604492188
Dropoff Longitude
-73.881393432617188
Dropoff Latitude
40.747108459472656
Passenger Count
1
Trip Distance
1.59
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:16:29.000 • Lpep Dropoff Datetime: 2016-01-02T01:13:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:16:29.000
Lpep Dropoff Datetime
2016-01-02T01:13:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915802001953125
Pickup Latitude
40.772655487060547
Dropoff Longitude
-73.928016662597656
Dropoff Latitude
40.769763946533203
Passenger Count
5
Trip Distance
0.99
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:48.000
Lpep Dropoff Datetime
2016-01-01T01:20:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94171142578125
Pickup Latitude
40.823028564453125
Dropoff Longitude
-73.935562133789063
Dropoff Latitude
40.832290649414063
Passenger Count
5
Trip Distance
1.07
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:07:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:07:19.000
Lpep Dropoff Datetime
2016-01-01T01:20:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949562072753906
Pickup Latitude
40.680206298828125
Dropoff Longitude
-73.945243835449219
Dropoff Latitude
40.658687591552734
Passenger Count
1
Trip Distance
1.78
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:08:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:08:06.000
Lpep Dropoff Datetime
2016-01-01T01:20:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.814537048339844
Pickup Latitude
40.746566772460938
Dropoff Longitude
-73.867759704589844
Dropoff Latitude
40.761188507080078
Passenger Count
1
Trip Distance
3.58
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:17:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:17:15.000
Lpep Dropoff Datetime
2016-01-01T01:20:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942230224609375
Pickup Latitude
40.806537628173828
Dropoff Longitude
-73.948036193847656
Dropoff Latitude
40.803890228271484
Passenger Count
1
Trip Distance
0.64
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:14:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:14:58.000
Lpep Dropoff Datetime
2016-01-01T01:20:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951911926269531
Pickup Latitude
40.812240600585938
Dropoff Longitude
-73.955879211425781
Dropoff Latitude
40.822216033935547
Passenger Count
1
Trip Distance
0.93
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.49
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:16:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:16:29.000
Lpep Dropoff Datetime
2016-01-01T01:20:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921440124511719
Pickup Latitude
40.766597747802734
Dropoff Longitude
-73.926795959472656
Dropoff Latitude
40.762657165527344
Passenger Count
1
Trip Distance
0.57
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:08:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:08:54.000
Lpep Dropoff Datetime
2016-01-01T01:20:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960838317871094
Pickup Latitude
40.70904541015625
Dropoff Longitude
-73.929756164550781
Dropoff Latitude
40.7005615234375
Passenger Count
1
Trip Distance
1.87
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:03.000
Lpep Dropoff Datetime
2016-01-01T01:20:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958183288574219
Pickup Latitude
40.733390808105469
Dropoff Longitude
-73.9404296875
Dropoff Latitude
40.723487854003906
Passenger Count
1
Trip Distance
1.57
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:03:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:03:50.000
Lpep Dropoff Datetime
2016-01-01T01:20:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963798522949219
Pickup Latitude
40.80792236328125
Dropoff Longitude
-73.936958312988281
Dropoff Latitude
40.856895446777344
Passenger Count
1
Trip Distance
4.06
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.04
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.84
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:14:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:14:12.000
Lpep Dropoff Datetime
2016-01-01T01:19:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9293212890625
Pickup Latitude
40.679325103759766
Dropoff Longitude
-73.928550720214844
Dropoff Latitude
40.670452117919922
Passenger Count
1
Trip Distance
0.70
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:11:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:11:18.000
Lpep Dropoff Datetime
2016-01-01T01:20:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903144836425781
Pickup Latitude
40.745578765869141
Dropoff Longitude
-73.930198669433594
Dropoff Latitude
40.754684448242188
Passenger Count
1
Trip Distance
1.88
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:01:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:01:38.000
Lpep Dropoff Datetime
2016-01-01T01:20:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933868408203125
Pickup Latitude
40.794044494628906
Dropoff Longitude
-73.987289428710938
Dropoff Latitude
40.719768524169922
Passenger Count
1
Trip Distance
7.21
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:12:04.000 • Lpep Dropoff Datetime: 2016-01-02T01:11:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:12:04.000
Lpep Dropoff Datetime
2016-01-02T01:11:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924110412597656
Pickup Latitude
40.827346801757813
Dropoff Longitude
-73.917869567871094
Dropoff Latitude
40.807868957519531
Passenger Count
1
Trip Distance
1.99
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:04:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:04:48.000
Lpep Dropoff Datetime
2016-01-01T01:20:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918861389160156
Pickup Latitude
40.742992401123047
Dropoff Longitude
-73.855857849121094
Dropoff Latitude
40.74920654296875
Passenger Count
1
Trip Distance
3.93
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:14:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:21:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:14:21.000
Lpep Dropoff Datetime
2016-01-01T01:21:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981071472167969
Pickup Latitude
40.685562133789063
Dropoff Longitude
-73.9984130859375
Dropoff Latitude
40.688266754150391
Passenger Count
2
Trip Distance
1.17
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:09:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:21:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:09:19.000
Lpep Dropoff Datetime
2016-01-01T01:21:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92669677734375
Pickup Latitude
40.863315582275391
Dropoff Longitude
-73.939674377441406
Dropoff Latitude
40.841342926025391
Passenger Count
1
Trip Distance
1.80
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:43.000
Lpep Dropoff Datetime
2016-01-01T01:20:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992301940917969
Pickup Latitude
40.689804077148437
Dropoff Longitude
-73.975196838378906
Dropoff Latitude
40.674934387207031
Passenger Count
1
Trip Distance
1.53
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:10:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:21:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:10:15.000
Lpep Dropoff Datetime
2016-01-01T01:21:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951446533203125
Pickup Latitude
40.723167419433594
Dropoff Longitude
-73.929161071777344
Dropoff Latitude
40.708232879638672
Passenger Count
1
Trip Distance
2.27
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:02:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:02:02.000
Lpep Dropoff Datetime
2016-01-01T01:20:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948577880859375
Pickup Latitude
40.809154510498047
Dropoff Longitude
-73.909469604492188
Dropoff Latitude
40.837238311767578
Passenger Count
1
Trip Distance
3.59
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:09:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:09:27.000
Lpep Dropoff Datetime
2016-01-01T01:20:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891304016113281
Pickup Latitude
40.746074676513672
Dropoff Longitude
-73.891365051269531
Dropoff Latitude
40.746463775634766
Passenger Count
1
Trip Distance
0.64
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:14:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:21:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:14:50.000
Lpep Dropoff Datetime
2016-01-01T01:21:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955154418945313
Pickup Latitude
40.735378265380859
Dropoff Longitude
-73.955711364746094
Dropoff Latitude
40.719341278076172
Passenger Count
1
Trip Distance
1.39
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.96
Payment Type
1
Trip Type
1