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:16:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:26.000
Lpep Dropoff Datetime
2016-01-01T00:20:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.806999206542969
Pickup Latitude
40.699428558349609
Dropoff Longitude
-73.801628112792969
Dropoff Latitude
40.705486297607422
Passenger Count
1
Trip Distance
0.86
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:46.000
Lpep Dropoff Datetime
2016-01-01T00:19:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962348937988281
Pickup Latitude
40.677711486816406
Dropoff Longitude
-73.962562561035156
Dropoff Latitude
40.673435211181641
Passenger Count
1
Trip Distance
0.35
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:05:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:12.000
Lpep Dropoff Datetime
2016-01-01T00:20:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992996215820313
Pickup Latitude
40.697437286376953
Dropoff Longitude
-73.930862426757812
Dropoff Latitude
40.671607971191406
Passenger Count
1
Trip Distance
4.54
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:17:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:22.000
Lpep Dropoff Datetime
2016-01-01T00:20:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.866348266601563
Pickup Latitude
40.736537933349609
Dropoff Longitude
-73.875953674316406
Dropoff Latitude
40.735908508300781
Passenger Count
1
Trip Distance
0.56
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:06:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:06:53.000
Lpep Dropoff Datetime
2016-01-01T00:20:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945159912109375
Pickup Latitude
40.808063507080078
Dropoff Longitude
-73.994331359863281
Dropoff Latitude
40.765705108642578
Passenger Count
2
Trip Distance
5.41
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:56.000
Lpep Dropoff Datetime
2016-01-01T00:20:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983993530273437
Pickup Latitude
40.677021026611328
Dropoff Longitude
-73.993034362792969
Dropoff Latitude
40.701076507568359
Passenger Count
1
Trip Distance
2.72
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:08:57.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:57.000
Lpep Dropoff Datetime
2016-01-01T00:20:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941360473632812
Pickup Latitude
40.791858673095703
Dropoff Longitude
-73.9249267578125
Dropoff Latitude
40.765163421630859
Passenger Count
5
Trip Distance
4.56
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
4.37
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
26.21
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:19.000
Lpep Dropoff Datetime
2016-01-01T00:20:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881805419921875
Pickup Latitude
40.742393493652344
Dropoff Longitude
-73.894477844238281
Dropoff Latitude
40.744808197021484
Passenger Count
1
Trip Distance
0.64
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-01T00:11:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:35.000
Lpep Dropoff Datetime
2016-01-01T00:20:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957145690917969
Pickup Latitude
40.681419372558594
Dropoff Longitude
-73.935272216796875
Dropoff Latitude
40.684139251708984
Passenger Count
5
Trip Distance
1.51
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
2.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:30.000
Lpep Dropoff Datetime
2016-01-01T00:20:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943466186523438
Pickup Latitude
40.836227416992188
Dropoff Longitude
-73.941154479980469
Dropoff Latitude
40.829006195068359
Passenger Count
1
Trip Distance
0.71
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-01T00:07:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:07:14.000
Lpep Dropoff Datetime
2016-01-01T00:20:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96441650390625
Pickup Latitude
40.681373596191406
Dropoff Longitude
-73.929389953613281
Dropoff Latitude
40.690906524658203
Passenger Count
1
Trip Distance
2.28
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-01T00:20:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:00.000
Lpep Dropoff Datetime
2016-01-01T00:20:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92047119140625
Pickup Latitude
40.699466705322266
Dropoff Longitude
-73.922271728515625
Dropoff Latitude
40.701015472412109
Passenger Count
1
Trip Distance
0.05
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-01T00:15:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:08.000
Lpep Dropoff Datetime
2016-01-01T00:20:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950180053710938
Pickup Latitude
40.826381683349609
Dropoff Longitude
-73.959716796875
Dropoff Latitude
40.813945770263672
Passenger Count
1
Trip Distance
0.93
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-01T00:13:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:18.000
Lpep Dropoff Datetime
2016-01-01T00:20:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926582336425781
Pickup Latitude
40.679187774658203
Dropoff Longitude
-73.942863464355469
Dropoff Latitude
40.687141418457031
Passenger Count
2
Trip Distance
1.31
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-01T00:09:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:09:27.000
Lpep Dropoff Datetime
2016-01-01T00:20:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986770629882813
Pickup Latitude
40.689853668212891
Dropoff Longitude
-73.952865600585938
Dropoff Latitude
40.673881530761719
Passenger Count
1
Trip Distance
2.42
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:19:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:18.000
Lpep Dropoff Datetime
2016-01-01T00:20:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.867774963378906
Pickup Latitude
40.849651336669922
Dropoff Longitude
-73.867477416992188
Dropoff Latitude
40.844985961914063
Passenger Count
1
Trip Distance
0.19
Fare Amount
3
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:07.000
Lpep Dropoff Datetime
2016-01-01T00:19:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951866149902344
Pickup Latitude
40.799007415771484
Dropoff Longitude
-73.937385559082031
Dropoff Latitude
40.812698364257813
Passenger Count
1
Trip Distance
1.54
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-01T00:11:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:28.000
Lpep Dropoff Datetime
2016-01-01T00:20:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962310791015625
Pickup Latitude
40.693866729736328
Dropoff Longitude
-73.963951110839844
Dropoff Latitude
40.673095703125
Passenger Count
2
Trip Distance
2.20
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
3.09
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.39
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:18:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:39.000
Lpep Dropoff Datetime
2016-01-01T00:18:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992340087890625
Pickup Latitude
40.683929443359375
Dropoff Longitude
-73.994415283203125
Dropoff Latitude
40.668048858642578
Passenger Count
1
Trip Distance
1.65
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:14:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:07.000
Lpep Dropoff Datetime
2016-01-01T00:19:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95794677734375
Pickup Latitude
40.644195556640625
Dropoff Longitude
-73.9600830078125
Dropoff Latitude
40.65557861328125
Passenger Count
1
Trip Distance
0.91
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-01T00:12:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:19.000
Lpep Dropoff Datetime
2016-01-01T00:19:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.972915649414063
Pickup Latitude
40.688499450683594
Dropoff Longitude
-73.979194641113281
Dropoff Latitude
40.678245544433594
Passenger Count
1
Trip Distance
1.09
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-01T00:13:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:48.000
Lpep Dropoff Datetime
2016-01-01T00:20:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911575317382812
Pickup Latitude
40.773391723632813
Dropoff Longitude
-73.920745849609375
Dropoff Latitude
40.771579742431641
Passenger Count
1
Trip Distance
0.70
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:08:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:08.000
Lpep Dropoff Datetime
2016-01-01T00:20:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966064453125
Pickup Latitude
40.716281890869141
Dropoff Longitude
-73.971412658691406
Dropoff Latitude
40.686042785644531
Passenger Count
1
Trip Distance
3.24
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:49.000
Lpep Dropoff Datetime
2016-01-01T00:19:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9434814453125
Pickup Latitude
40.714599609375
Dropoff Longitude
-73.9073486328125
Dropoff Latitude
40.683113098144531
Passenger Count
1
Trip Distance
3.34
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:11.000
Lpep Dropoff Datetime
2016-01-01T00:19:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986099243164062
Pickup Latitude
40.677455902099609
Dropoff Longitude
-73.949836730957031
Dropoff Latitude
40.728031158447266
Passenger Count
5
Trip Distance
5.06
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:15:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:05.000
Lpep Dropoff Datetime
2016-01-01T00:20:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982307434082031
Pickup Latitude
40.678672790527344
Dropoff Longitude
-73.996772766113281
Dropoff Latitude
40.661678314208984
Passenger Count
1
Trip Distance
1.36
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-01T00:11:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:39.000
Lpep Dropoff Datetime
2016-01-01T00:20:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956832885742188
Pickup Latitude
40.802394866943359
Dropoff Longitude
-73.949386596679688
Dropoff Latitude
40.822727203369141
Passenger Count
1
Trip Distance
1.62
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-01T00:17:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:38.000
Lpep Dropoff Datetime
2016-01-01T00:20:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978904724121094
Pickup Latitude
40.686737060546875
Dropoff Longitude
-73.960220336914062
Dropoff Latitude
40.688888549804688
Passenger Count
1
Trip Distance
0.84
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-01T00:14:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:23.000
Lpep Dropoff Datetime
2016-01-01T00:19:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.934501647949219
Pickup Latitude
40.698616027832031
Dropoff Longitude
-73.942153930664063
Dropoff Latitude
40.701305389404297
Passenger Count
2
Trip Distance
0.57
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-01T00:05:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:34.000
Lpep Dropoff Datetime
2016-01-01T00:20:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963836669921875
Pickup Latitude
40.710243225097656
Dropoff Longitude
-73.974967956542969
Dropoff Latitude
40.741802215576172
Passenger Count
1
Trip Distance
3.74
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:44.000
Lpep Dropoff Datetime
2016-01-01T00:20:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938934326171875
Pickup Latitude
40.749759674072266
Dropoff Longitude
-73.9080810546875
Dropoff Latitude
40.773410797119141
Passenger Count
2
Trip Distance
3.29
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:13.000
Lpep Dropoff Datetime
2016-01-01T00:20:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944938659667969
Pickup Latitude
40.823848724365234
Dropoff Longitude
-73.946159362792969
Dropoff Latitude
40.813003540039063
Passenger Count
1
Trip Distance
0.95
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-01T00:08:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:12.000
Lpep Dropoff Datetime
2016-01-01T00:21:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954833984375
Pickup Latitude
40.7073974609375
Dropoff Longitude
-73.996780395507813
Dropoff Latitude
40.715293884277344
Passenger Count
1
Trip Distance
2.72
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:45.000
Lpep Dropoff Datetime
2016-01-01T00:19:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940521240234375
Pickup Latitude
40.789051055908203
Dropoff Longitude
-73.951835632324219
Dropoff Latitude
40.798774719238281
Passenger Count
1
Trip Distance
1.11
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-01T00:15:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:07.000
Lpep Dropoff Datetime
2016-01-01T00:20:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942268371582031
Pickup Latitude
40.753921508789063
Dropoff Longitude
-73.926239013671875
Dropoff Latitude
40.757095336914063
Passenger Count
1
Trip Distance
1.12
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-01T00:05:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:15.000
Lpep Dropoff Datetime
2016-01-01T00:19:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994697570800781
Pickup Latitude
40.703010559082031
Dropoff Longitude
-73.981758117675781
Dropoff Latitude
40.740573883056641
Passenger Count
1
Trip Distance
5.45
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:10:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:06.000
Lpep Dropoff Datetime
2016-01-01T00:20:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919685363769531
Pickup Latitude
40.830612182617188
Dropoff Longitude
-73.855422973632812
Dropoff Latitude
40.826190948486328
Passenger Count
1
Trip Distance
3.78
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:01:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:12.000
Lpep Dropoff Datetime
2016-01-01T00:21:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955825805664062
Pickup Latitude
40.668479919433594
Dropoff Longitude
-73.924888610839844
Dropoff Latitude
40.706798553466797
Passenger Count
1
Trip Distance
4.06
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:09:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:09:50.000
Lpep Dropoff Datetime
2016-01-01T00:20:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948410034179687
Pickup Latitude
40.711288452148438
Dropoff Longitude
-74.000953674316406
Dropoff Latitude
40.683811187744141
Passenger Count
1
Trip Distance
5.03
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:06:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:06:41.000
Lpep Dropoff Datetime
2016-01-01T00:20:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95361328125
Pickup Latitude
40.744033813476562
Dropoff Longitude
-73.918609619140625
Dropoff Latitude
40.762016296386719
Passenger Count
1
Trip Distance
2.82
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:12:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:21.000
Lpep Dropoff Datetime
2016-01-01T00:20:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.916450500488281
Pickup Latitude
40.849929809570312
Dropoff Longitude
-73.919151306152344
Dropoff Latitude
40.831363677978516
Passenger Count
1
Trip Distance
1.68
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-01T00:14:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:11.000
Lpep Dropoff Datetime
2016-01-01T00:21:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807991027832031
Pickup Latitude
40.699851989746094
Dropoff Longitude
-73.81683349609375
Dropoff Latitude
40.681648254394531
Passenger Count
1
Trip Distance
2.26
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
3.09
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.39
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:15:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:17.000
Lpep Dropoff Datetime
2016-01-01T00:20:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964950561523438
Pickup Latitude
40.683135986328125
Dropoff Longitude
-73.951484680175781
Dropoff Latitude
40.686119079589844
Passenger Count
1
Trip Distance
1.04
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-01T00:19:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:10.000
Lpep Dropoff Datetime
2016-01-01T00:21:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9759521484375
Pickup Latitude
40.669612884521484
Dropoff Longitude
-73.971786499023438
Dropoff Latitude
40.675159454345703
Passenger Count
1
Trip Distance
0.44
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-01T00:14:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:23.000
Lpep Dropoff Datetime
2016-01-01T00:20:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917060852050781
Pickup Latitude
40.761440277099609
Dropoff Longitude
-73.909889221191406
Dropoff Latitude
40.771865844726563
Passenger Count
1
Trip Distance
0.89
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-01T00:11:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:01.000
Lpep Dropoff Datetime
2016-01-01T00:21:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957176208496094
Pickup Latitude
40.727134704589844
Dropoff Longitude
-73.977546691894531
Dropoff Latitude
40.752101898193359
Passenger Count
1
Trip Distance
3.48
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
18.84
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:10:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:40.000
Lpep Dropoff Datetime
2016-01-01T00:21:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937530517578125
Pickup Latitude
40.804290771484375
Dropoff Longitude
-73.913711547851562
Dropoff Latitude
40.84735107421875
Passenger Count
1
Trip Distance
4.81
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:18:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:04.000
Lpep Dropoff Datetime
2016-01-01T00:18:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953849792480469
Pickup Latitude
40.72149658203125
Dropoff Longitude
-73.989784240722656
Dropoff Latitude
40.678470611572266
Passenger Count
1
Trip Distance
7.40
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:44.000
Lpep Dropoff Datetime
2016-01-01T00:21:12.000
Store And Fwd Flag
N
Ratecodeid
2
Pickup Longitude
-74.011093139648438
Pickup Latitude
40.678871154785156
Dropoff Longitude
-74.010826110839844
Dropoff Latitude
40.679088592529297
Passenger Count
1
Trip Distance
0.02
Fare Amount
52
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
52.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:06:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:06:58.000
Lpep Dropoff Datetime
2016-01-01T00:20:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994056701660156
Pickup Latitude
40.690929412841797
Dropoff Longitude
-73.990303039550781
Dropoff Latitude
40.732341766357422
Passenger Count
1
Trip Distance
3.73
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