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-01T00:56:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:06.000
Lpep Dropoff Datetime
2016-01-01T01:17:32.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.906059265136719
Pickup Latitude
40.689132690429688
Dropoff Longitude
-73.963920593261719
Dropoff Latitude
40.683818817138672
Passenger Count
2
Trip Distance
3.60
Fare Amount
25
Extra
0
Mta Tax
0
Tip Amount
6.25
Tolls Amount
0
Improvement Surcharge
0
Total Amount
31.25
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:29.000
Lpep Dropoff Datetime
2016-01-01T01:17:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954658508300781
Pickup Latitude
40.725296020507812
Dropoff Longitude
-73.959053039550781
Dropoff Latitude
40.698627471923828
Passenger Count
2
Trip Distance
4.45
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:18.000
Lpep Dropoff Datetime
2016-01-01T01:17:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948081970214844
Pickup Latitude
40.804080963134766
Dropoff Longitude
-73.889190673828125
Dropoff Latitude
40.814044952392578
Passenger Count
1
Trip Distance
6.20
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:41.000
Lpep Dropoff Datetime
2016-01-01T01:17:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963050842285156
Pickup Latitude
40.684894561767578
Dropoff Longitude
-73.878547668457031
Dropoff Latitude
40.645179748535156
Passenger Count
1
Trip Distance
6.96
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:23.000
Lpep Dropoff Datetime
2016-01-01T01:17:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940818786621094
Pickup Latitude
40.723442077636719
Dropoff Longitude
-73.956184387207031
Dropoff Latitude
40.6573486328125
Passenger Count
1
Trip Distance
5.56
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:23:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:27.000
Lpep Dropoff Datetime
2016-01-01T01:17:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963630676269531
Pickup Latitude
40.802936553955078
Dropoff Longitude
-74.000167846679688
Dropoff Latitude
40.647953033447266
Passenger Count
2
Trip Distance
14.98
Fare Amount
49.5
Extra
0.5
Mta Tax
0.5
Tip Amount
10.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
60.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:15:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:34.000
Lpep Dropoff Datetime
2016-01-01T01:15:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952537536621094
Pickup Latitude
40.724987030029297
Dropoff Longitude
-73.928047180175781
Dropoff Latitude
40.695262908935547
Passenger Count
2
Trip Distance
2.79
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:04.000
Lpep Dropoff Datetime
2016-01-01T01:17:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937904357910156
Pickup Latitude
40.74920654296875
Dropoff Longitude
-73.822723388671875
Dropoff Latitude
40.716178894042969
Passenger Count
1
Trip Distance
9.43
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:00.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:00.000
Lpep Dropoff Datetime
2016-01-01T01:17:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951278686523438
Pickup Latitude
40.712417602539062
Dropoff Longitude
-73.960174560546875
Dropoff Latitude
40.770301818847656
Passenger Count
1
Trip Distance
7.16
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
5.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:20.000
Lpep Dropoff Datetime
2016-01-01T01:17:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94268798828125
Pickup Latitude
40.811637878417969
Dropoff Longitude
-73.907814025878906
Dropoff Latitude
40.833625793457031
Passenger Count
1
Trip Distance
3.24
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-01T00:52:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:45.000
Lpep Dropoff Datetime
2016-01-01T01:18:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921905517578125
Pickup Latitude
40.741672515869141
Dropoff Longitude
-73.958518981933594
Dropoff Latitude
40.658893585205078
Passenger Count
5
Trip Distance
7.22
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.87
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.67
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:56.000
Lpep Dropoff Datetime
2016-01-01T01:17:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927696228027344
Pickup Latitude
40.763103485107422
Dropoff Longitude
-73.992355346679687
Dropoff Latitude
40.737468719482422
Passenger Count
2
Trip Distance
6.14
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
4.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:16:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:36.000
Lpep Dropoff Datetime
2016-01-01T01:16:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923133850097656
Pickup Latitude
40.743862152099609
Dropoff Longitude
-73.997352600097656
Dropoff Latitude
40.741771697998047
Passenger Count
1
Trip Distance
5.14
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
26.84
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:27.000
Lpep Dropoff Datetime
2016-01-01T01:17:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950325012207031
Pickup Latitude
40.639846801757813
Dropoff Longitude
-73.918411254882813
Dropoff Latitude
40.630031585693359
Passenger Count
1
Trip Distance
2.74
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:44.000
Lpep Dropoff Datetime
2016-01-01T01:17:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.88458251953125
Pickup Latitude
40.743766784667969
Dropoff Longitude
-73.883956909179688
Dropoff Latitude
40.743408203125
Passenger Count
1
Trip Distance
7.18
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:40.000
Lpep Dropoff Datetime
2016-01-01T01:17:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925247192382812
Pickup Latitude
40.755359649658203
Dropoff Longitude
-73.832054138183594
Dropoff Latitude
40.771678924560547
Passenger Count
1
Trip Distance
9.34
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:09.000
Lpep Dropoff Datetime
2016-01-01T01:18:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939994812011719
Pickup Latitude
40.682182312011719
Dropoff Longitude
-73.982147216796875
Dropoff Latitude
40.719631195068359
Passenger Count
1
Trip Distance
4.75
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:44.000
Lpep Dropoff Datetime
2016-01-01T01:18:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941612243652344
Pickup Latitude
40.843471527099609
Dropoff Longitude
-73.994461059570312
Dropoff Latitude
40.745555877685547
Passenger Count
1
Trip Distance
8.83
Fare Amount
28.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:04.000
Lpep Dropoff Datetime
2016-01-01T01:18:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915596008300781
Pickup Latitude
40.772312164306641
Dropoff Longitude
-73.973411560058594
Dropoff Latitude
40.674423217773438
Passenger Count
1
Trip Distance
10.77
Fare Amount
32.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
38.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:05.000
Lpep Dropoff Datetime
2016-01-01T01:18:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919624328613281
Pickup Latitude
40.759231567382812
Dropoff Longitude
-73.977203369140625
Dropoff Latitude
40.784641265869141
Passenger Count
1
Trip Distance
5.16
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
5.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:15.000
Lpep Dropoff Datetime
2016-01-01T01:18:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9208984375
Pickup Latitude
40.702808380126953
Dropoff Longitude
-73.979011535644531
Dropoff Latitude
40.692195892333984
Passenger Count
1
Trip Distance
3.92
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.05
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:48.000
Lpep Dropoff Datetime
2016-01-01T01:18:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961402893066406
Pickup Latitude
40.716407775878906
Dropoff Longitude
-73.902557373046875
Dropoff Latitude
40.744785308837891
Passenger Count
3
Trip Distance
4.79
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
5.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:38.000
Lpep Dropoff Datetime
2016-01-01T01:18:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949691772460938
Pickup Latitude
40.802223205566406
Dropoff Longitude
-73.992424011230469
Dropoff Latitude
40.761730194091797
Passenger Count
1
Trip Distance
5.28
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:14.000
Lpep Dropoff Datetime
2016-01-01T01:17:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952018737792969
Pickup Latitude
40.742824554443359
Dropoff Longitude
-73.88128662109375
Dropoff Latitude
40.756038665771484
Passenger Count
1
Trip Distance
3.96
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:45.000
Lpep Dropoff Datetime
2016-01-01T01:17:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925369262695313
Pickup Latitude
40.762161254882813
Dropoff Longitude
-73.934638977050781
Dropoff Latitude
40.703529357910156
Passenger Count
1
Trip Distance
7.63
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
6.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:14.000
Lpep Dropoff Datetime
2016-01-01T01:18:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983062744140625
Pickup Latitude
40.677593231201172
Dropoff Longitude
-73.962272644042969
Dropoff Latitude
40.720718383789063
Passenger Count
1
Trip Distance
6.68
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
1.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:19.000
Lpep Dropoff Datetime
2016-01-01T01:17:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969589233398438
Pickup Latitude
40.675983428955078
Dropoff Longitude
-73.991622924804687
Dropoff Latitude
40.7266845703125
Passenger Count
1
Trip Distance
3.91
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:05.000
Lpep Dropoff Datetime
2016-01-01T01:17:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955276489257813
Pickup Latitude
40.681011199951172
Dropoff Longitude
-73.931053161621094
Dropoff Latitude
40.665237426757813
Passenger Count
1
Trip Distance
2.57
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-01T00:57:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:14.000
Lpep Dropoff Datetime
2016-01-01T01:18:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951873779296875
Pickup Latitude
40.715641021728516
Dropoff Longitude
-73.979103088378906
Dropoff Latitude
40.727901458740234
Passenger Count
1
Trip Distance
2.82
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:53.000
Lpep Dropoff Datetime
2016-01-01T01:17:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9146728515625
Pickup Latitude
40.832195281982422
Dropoff Longitude
-73.933433532714844
Dropoff Latitude
40.845001220703125
Passenger Count
1
Trip Distance
3.21
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-01T00:49:08.000 • Lpep Dropoff Datetime: 2016-01-01T01:16:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:08.000
Lpep Dropoff Datetime
2016-01-01T01:16:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963020324707031
Pickup Latitude
40.719127655029297
Dropoff Longitude
-74.005287170410156
Dropoff Latitude
40.741157531738281
Passenger Count
1
Trip Distance
5.36
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:31.000
Lpep Dropoff Datetime
2016-01-01T01:18:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965049743652344
Pickup Latitude
40.683090209960937
Dropoff Longitude
-73.952934265136719
Dropoff Latitude
40.727268218994141
Passenger Count
1
Trip Distance
4.39
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:16:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:47.000
Lpep Dropoff Datetime
2016-01-01T01:16:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955101013183594
Pickup Latitude
40.689334869384766
Dropoff Longitude
-73.905311584472656
Dropoff Latitude
40.699588775634766
Passenger Count
1
Trip Distance
3.86
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-01T00:50:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:46.000
Lpep Dropoff Datetime
2016-01-01T01:18:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908096313476563
Pickup Latitude
40.774318695068359
Dropoff Longitude
-73.914718627929688
Dropoff Latitude
40.705242156982422
Passenger Count
1
Trip Distance
8.50
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:54:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:07.000
Lpep Dropoff Datetime
2016-01-01T01:18:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957862854003906
Pickup Latitude
40.815269470214844
Dropoff Longitude
-73.869010925292969
Dropoff Latitude
40.821125030517578
Passenger Count
1
Trip Distance
6.26
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:04.000
Lpep Dropoff Datetime
2016-01-01T01:18:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908363342285156
Pickup Latitude
40.699909210205078
Dropoff Longitude
-73.971115112304688
Dropoff Latitude
40.673145294189453
Passenger Count
1
Trip Distance
4.56
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:06.000
Lpep Dropoff Datetime
2016-01-01T01:17:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977554321289063
Pickup Latitude
40.682571411132812
Dropoff Longitude
-74.027900695800781
Dropoff Latitude
40.628318786621094
Passenger Count
6
Trip Distance
5.01
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:37.000
Lpep Dropoff Datetime
2016-01-01T01:18:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.995964050292969
Pickup Latitude
40.673923492431641
Dropoff Longitude
-73.920509338378906
Dropoff Latitude
40.706523895263672
Passenger Count
1
Trip Distance
5.84
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
4.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:31.000
Lpep Dropoff Datetime
2016-01-01T01:18:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.002403259277344
Pickup Latitude
40.577056884765625
Dropoff Longitude
-74.004547119140625
Dropoff Latitude
40.656238555908203
Passenger Count
1
Trip Distance
9.14
Fare Amount
31
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:46.000
Lpep Dropoff Datetime
2016-01-01T01:18:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994659423828125
Pickup Latitude
40.691871643066406
Dropoff Longitude
-73.963699340820313
Dropoff Latitude
40.806289672851563
Passenger Count
1
Trip Distance
12.39
Fare Amount
38
Extra
0.5
Mta Tax
0.5
Tip Amount
7.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
47.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:39.000
Lpep Dropoff Datetime
2016-01-01T01:19:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.869194030761719
Pickup Latitude
40.748821258544922
Dropoff Longitude
-73.990158081054687
Dropoff Latitude
40.683082580566406
Passenger Count
1
Trip Distance
10.89
Fare Amount
33
Extra
0.5
Mta Tax
0.5
Tip Amount
10.29
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
44.59
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:03.000
Lpep Dropoff Datetime
2016-01-01T01:18:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957046508789063
Pickup Latitude
40.747962951660156
Dropoff Longitude
-73.832534790039063
Dropoff Latitude
40.761032104492188
Passenger Count
1
Trip Distance
0.00
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:49.000
Lpep Dropoff Datetime
2016-01-01T01:17:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939132690429688
Pickup Latitude
40.810741424560547
Dropoff Longitude
-74.003677368164063
Dropoff Latitude
40.743240356445313
Passenger Count
1
Trip Distance
7.67
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:48:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:13.000
Lpep Dropoff Datetime
2016-01-01T01:19:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923721313476562
Pickup Latitude
40.770343780517578
Dropoff Longitude
-73.964111328125
Dropoff Latitude
40.673019409179687
Passenger Count
6
Trip Distance
10.87
Fare Amount
34
Extra
0.5
Mta Tax
0.5
Tip Amount
7.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
42.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:52.000
Lpep Dropoff Datetime
2016-01-01T01:19:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.008956909179687
Pickup Latitude
40.649818420410156
Dropoff Longitude
-73.842124938964844
Dropoff Latitude
40.720386505126953
Passenger Count
1
Trip Distance
13.93
Fare Amount
38.5
Extra
0.5
Mta Tax
0.5
Tip Amount
7.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
47.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:15:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:12.000
Lpep Dropoff Datetime
2016-01-01T01:15:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908645629882813
Pickup Latitude
40.776161193847656
Dropoff Longitude
-73.84796142578125
Dropoff Latitude
40.787677764892578
Passenger Count
1
Trip Distance
8.76
Fare Amount
29
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:32.000
Lpep Dropoff Datetime
2016-01-01T01:19:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945465087890625
Pickup Latitude
40.750728607177734
Dropoff Longitude
-74.003692626953125
Dropoff Latitude
40.717269897460937
Passenger Count
1
Trip Distance
8.65
Fare Amount
34.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:32.000
Lpep Dropoff Datetime
2016-01-01T01:19:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956962585449219
Pickup Latitude
40.747890472412109
Dropoff Longitude
-73.975006103515625
Dropoff Latitude
40.656097412109375
Passenger Count
1
Trip Distance
11.88
Fare Amount
32.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:56.000
Lpep Dropoff Datetime
2016-01-01T01:19:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911338806152344
Pickup Latitude
40.744579315185547
Dropoff Longitude
-73.873382568359375
Dropoff Latitude
40.730693817138672
Passenger Count
1
Trip Distance
4.06
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
3.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:19:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:38.000
Lpep Dropoff Datetime
2016-01-01T01:19:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914939880371094
Pickup Latitude
40.769500732421875
Dropoff Longitude
-73.98101806640625
Dropoff Latitude
40.658374786376953
Passenger Count
5
Trip Distance
13.36
Fare Amount
36.5
Extra
0.5
Mta Tax
0.5
Tip Amount
9.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
47.25
Payment Type
1
Trip Type
1