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:00:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:21.000
Lpep Dropoff Datetime
2016-01-01T00:05:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.887870788574219
Pickup Latitude
40.837055206298828
Dropoff Longitude
-73.882003784179688
Dropoff Latitude
40.853427886962891
Passenger Count
1
Trip Distance
1.20
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:06:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:06:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:06:26.000
Lpep Dropoff Datetime
2016-01-01T00:06:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956993103027344
Pickup Latitude
40.673301696777344
Dropoff Longitude
-73.994255065917969
Dropoff Latitude
40.703098297119141
Passenger Count
1
Trip Distance
3.88
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:01:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:12:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:44.000
Lpep Dropoff Datetime
2016-01-01T00:12:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.974380493164063
Pickup Latitude
40.683349609375
Dropoff Longitude
-73.939399719238281
Dropoff Latitude
40.670196533203125
Passenger Count
6
Trip Distance
2.75
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:04:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:06:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:30.000
Lpep Dropoff Datetime
2016-01-01T00:06:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962753295898438
Pickup Latitude
40.720993041992187
Dropoff Longitude
-73.957588195800781
Dropoff Latitude
40.717990875244141
Passenger Count
1
Trip Distance
0.36
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:00:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:09:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:26.000
Lpep Dropoff Datetime
2016-01-01T00:09:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95440673828125
Pickup Latitude
40.808200836181641
Dropoff Longitude
-73.9388427734375
Dropoff Latitude
40.821739196777344
Passenger Count
1
Trip Distance
1.46
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-01T00:00:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:02:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:01.000
Lpep Dropoff Datetime
2016-01-01T00:02:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92303466796875
Pickup Latitude
40.706745147705078
Dropoff Longitude
-73.927146911621094
Dropoff Latitude
40.708644866943359
Passenger Count
1
Trip Distance
0.34
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:01:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:03:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:34.000
Lpep Dropoff Datetime
2016-01-01T00:03:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963798522949219
Pickup Latitude
40.677730560302734
Dropoff Longitude
-73.964248657226562
Dropoff Latitude
40.672103881835938
Passenger Count
2
Trip Distance
0.51
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:00:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:03:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:23.000
Lpep Dropoff Datetime
2016-01-01T00:03:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952743530273438
Pickup Latitude
40.810611724853516
Dropoff Longitude
-73.956489562988281
Dropoff Latitude
40.802883148193359
Passenger Count
1
Trip Distance
0.43
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:00:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:04:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:41.000
Lpep Dropoff Datetime
2016-01-01T00:04:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946693420410156
Pickup Latitude
40.791690826416016
Dropoff Longitude
-73.958892822265625
Dropoff Latitude
40.780838012695312
Passenger Count
1
Trip Distance
1.15
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-01T00:03:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:04:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:24.000
Lpep Dropoff Datetime
2016-01-01T00:04:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.885360717773437
Pickup Latitude
40.747550964355469
Dropoff Longitude
-73.888710021972656
Dropoff Latitude
40.747806549072266
Passenger Count
1
Trip Distance
0.21
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:01:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:04:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:48.000
Lpep Dropoff Datetime
2016-01-01T00:04:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959152221679688
Pickup Latitude
40.708866119384766
Dropoff Longitude
-73.966468811035156
Dropoff Latitude
40.711246490478516
Passenger Count
1
Trip Distance
0.45
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.59
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.89
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:00:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:04:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:58.000
Lpep Dropoff Datetime
2016-01-01T00:04:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961982727050781
Pickup Latitude
40.713382720947266
Dropoff Longitude
-73.957710266113281
Dropoff Latitude
40.717788696289063
Passenger Count
1
Trip Distance
0.38
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:38.000
Lpep Dropoff Datetime
2016-01-01T00:05:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962142944335937
Pickup Latitude
40.716091156005859
Dropoff Longitude
-73.964584350585938
Dropoff Latitude
40.717498779296875
Passenger Count
1
Trip Distance
0.06
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:01:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:44.000
Lpep Dropoff Datetime
2016-01-01T00:05:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896286010742188
Pickup Latitude
40.746074676513672
Dropoff Longitude
-73.897773742675781
Dropoff Latitude
40.736202239990234
Passenger Count
5
Trip Distance
0.76
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:01:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:50.000
Lpep Dropoff Datetime
2016-01-01T00:05:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919364929199219
Pickup Latitude
40.816551208496094
Dropoff Longitude
-73.913848876953125
Dropoff Latitude
40.818996429443359
Passenger Count
1
Trip Distance
0.42
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:03:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:19.000
Lpep Dropoff Datetime
2016-01-01T00:05:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983306884765625
Pickup Latitude
40.693450927734375
Dropoff Longitude
-73.977493286132812
Dropoff Latitude
40.696033477783203
Passenger Count
2
Trip Distance
0.53
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:02:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:02:58.000
Lpep Dropoff Datetime
2016-01-01T00:05:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940505981445313
Pickup Latitude
40.711601257324219
Dropoff Longitude
-73.938194274902344
Dropoff Latitude
40.708553314208984
Passenger Count
1
Trip Distance
0.42
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:38.000
Lpep Dropoff Datetime
2016-01-01T00:05:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962142944335937
Pickup Latitude
40.716091156005859
Dropoff Longitude
-73.964584350585938
Dropoff Latitude
40.717498779296875
Passenger Count
1
Trip Distance
0.06
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
4
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:03:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:05:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:55.000
Lpep Dropoff Datetime
2016-01-01T00:05:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952522277832031
Pickup Latitude
40.714138031005859
Dropoff Longitude
-73.956344604492188
Dropoff Latitude
40.710891723632812
Passenger Count
1
Trip Distance
0.33
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:06:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:56.000
Lpep Dropoff Datetime
2016-01-01T00:06:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958030700683594
Pickup Latitude
40.646640777587891
Dropoff Longitude
-73.958305358886719
Dropoff Latitude
40.648738861083984
Passenger Count
3
Trip Distance
0.15
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:02:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:06:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:02:02.000
Lpep Dropoff Datetime
2016-01-01T00:06:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963798522949219
Pickup Latitude
40.678489685058594
Dropoff Longitude
-73.981819152832031
Dropoff Latitude
40.683361053466797
Passenger Count
1
Trip Distance
1.02
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:03:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:49.000
Lpep Dropoff Datetime
2016-01-01T00:07:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940658569335938
Pickup Latitude
40.814262390136719
Dropoff Longitude
-73.949348449707031
Dropoff Latitude
40.802600860595703
Passenger Count
1
Trip Distance
0.92
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:04:03.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:03.000
Lpep Dropoff Datetime
2016-01-01T00:07:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987136840820313
Pickup Latitude
40.692401885986328
Dropoff Longitude
-73.982810974121094
Dropoff Latitude
40.699939727783203
Passenger Count
1
Trip Distance
0.71
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:07:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:07:10.000
Lpep Dropoff Datetime
2016-01-01T00:07:21.000
Store And Fwd Flag
N
Ratecodeid
3
Pickup Longitude
-73.92767333984375
Pickup Latitude
40.677230834960938
Dropoff Longitude
-73.922950744628906
Dropoff Latitude
40.676956176757813
Passenger Count
5
Trip Distance
0.04
Fare Amount
20
Extra
0.5
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:01:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:06:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:02.000
Lpep Dropoff Datetime
2016-01-01T00:06:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956001281738281
Pickup Latitude
40.694656372070313
Dropoff Longitude
-73.943740844726563
Dropoff Latitude
40.697013854980469
Passenger Count
1
Trip Distance
1.02
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:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:29.000
Lpep Dropoff Datetime
2016-01-01T00:07:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923583984375
Pickup Latitude
40.70709228515625
Dropoff Longitude
-73.927688598632813
Dropoff Latitude
40.70849609375
Passenger Count
1
Trip Distance
0.34
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:04:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:44.000
Lpep Dropoff Datetime
2016-01-01T00:07:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992156982421875
Pickup Latitude
40.68975830078125
Dropoff Longitude
-73.982681274414063
Dropoff Latitude
40.686016082763672
Passenger Count
1
Trip Distance
0.59
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:02:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:02:52.000
Lpep Dropoff Datetime
2016-01-01T00:07:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944023132324219
Pickup Latitude
40.684715270996094
Dropoff Longitude
-73.938796997070313
Dropoff Latitude
40.675937652587891
Passenger Count
1
Trip Distance
0.85
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:04:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:22.000
Lpep Dropoff Datetime
2016-01-01T00:08:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96551513671875
Pickup Latitude
40.713565826416016
Dropoff Longitude
-73.957687377929688
Dropoff Latitude
40.714271545410156
Passenger Count
1
Trip Distance
0.56
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:36.000
Lpep Dropoff Datetime
2016-01-01T00:07:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.877151489257812
Pickup Latitude
40.737636566162109
Dropoff Longitude
-73.878334045410156
Dropoff Latitude
40.742439270019531
Passenger Count
1
Trip Distance
0.54
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:02:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:02:51.000
Lpep Dropoff Datetime
2016-01-01T00:08:13.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.813819885253906
Pickup Latitude
40.697242736816406
Dropoff Longitude
-73.799446105957031
Dropoff Latitude
40.667411804199219
Passenger Count
1
Trip Distance
2.40
Fare Amount
17
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
17
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:01:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:35.000
Lpep Dropoff Datetime
2016-01-01T00:07:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913742065429688
Pickup Latitude
40.765415191650391
Dropoff Longitude
-73.924049377441406
Dropoff Latitude
40.761325836181641
Passenger Count
1
Trip Distance
1.06
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:00:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:58.000
Lpep Dropoff Datetime
2016-01-01T00:07:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.930610656738281
Pickup Latitude
40.673095703125
Dropoff Longitude
-73.917442321777344
Dropoff Latitude
40.658657073974609
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:03:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:06:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:19.000
Lpep Dropoff Datetime
2016-01-01T00:06:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951377868652344
Pickup Latitude
40.6805419921875
Dropoff Longitude
-73.9544677734375
Dropoff Latitude
40.680866241455078
Passenger Count
1
Trip Distance
0.33
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:07:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:07:10.000
Lpep Dropoff Datetime
2016-01-01T00:07:21.000
Store And Fwd Flag
N
Ratecodeid
3
Pickup Longitude
-73.92767333984375
Pickup Latitude
40.677230834960938
Dropoff Longitude
-73.922950744628906
Dropoff Latitude
40.676956176757813
Passenger Count
5
Trip Distance
0.04
Fare Amount
-20
Extra
-0.5
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
-0.3
Total Amount
-20.8
Payment Type
3
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:03:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:53.000
Lpep Dropoff Datetime
2016-01-01T00:08:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952529907226563
Pickup Latitude
40.808387756347656
Dropoff Longitude
-73.957405090332031
Dropoff Latitude
40.803577423095703
Passenger Count
1
Trip Distance
0.51
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:03:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:33.000
Lpep Dropoff Datetime
2016-01-01T00:08:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93353271484375
Pickup Latitude
40.710372924804688
Dropoff Longitude
-73.941635131835938
Dropoff Latitude
40.714736938476563
Passenger Count
1
Trip Distance
0.86
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-01T00:04:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:06:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:56.000
Lpep Dropoff Datetime
2016-01-01T00:06:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958030700683594
Pickup Latitude
40.646640777587891
Dropoff Longitude
-73.958305358886719
Dropoff Latitude
40.648738861083984
Passenger Count
3
Trip Distance
0.15
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:04:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:42.000
Lpep Dropoff Datetime
2016-01-01T00:08:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962318420410156
Pickup Latitude
40.805023193359375
Dropoff Longitude
-73.970382690429688
Dropoff Latitude
40.793872833251953
Passenger Count
1
Trip Distance
1.12
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:01:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:04.000
Lpep Dropoff Datetime
2016-01-01T00:08:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.843063354492188
Pickup Latitude
40.721286773681641
Dropoff Longitude
-73.811531066894531
Dropoff Latitude
40.727813720703125
Passenger Count
1
Trip Distance
2.46
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-01T00:05:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:36.000
Lpep Dropoff Datetime
2016-01-01T00:08:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890350341796875
Pickup Latitude
40.747058868408203
Dropoff Longitude
-73.881881713867188
Dropoff Latitude
40.751949310302734
Passenger Count
6
Trip Distance
0.76
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:00:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:09:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:53.000
Lpep Dropoff Datetime
2016-01-01T00:09:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942031860351563
Pickup Latitude
40.754405975341797
Dropoff Longitude
-73.9141845703125
Dropoff Latitude
40.765693664550781
Passenger Count
1
Trip Distance
2.11
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-01T00:02:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:02:06.000
Lpep Dropoff Datetime
2016-01-01T00:08:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939353942871094
Pickup Latitude
40.807456970214844
Dropoff Longitude
-73.940231323242188
Dropoff Latitude
40.825172424316406
Passenger Count
6
Trip Distance
1.64
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-01T00:05:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:27.000
Lpep Dropoff Datetime
2016-01-01T00:08:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912651062011719
Pickup Latitude
40.744342803955078
Dropoff Longitude
-73.9034423828125
Dropoff Latitude
40.7454833984375
Passenger Count
1
Trip Distance
0.48
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:06:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:06:04.000
Lpep Dropoff Datetime
2016-01-01T00:08:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913063049316406
Pickup Latitude
40.76629638671875
Dropoff Longitude
-73.917190551757813
Dropoff Latitude
40.761188507080078
Passenger Count
5
Trip Distance
0.42
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:04:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:07:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:10.000
Lpep Dropoff Datetime
2016-01-01T00:07:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952812194824219
Pickup Latitude
40.803333282470703
Dropoff Longitude
-73.950126647949219
Dropoff Latitude
40.795658111572266
Passenger Count
1
Trip Distance
0.59
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:04:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:09:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:39.000
Lpep Dropoff Datetime
2016-01-01T00:09:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.998603820800781
Pickup Latitude
40.681316375732422
Dropoff Longitude
-73.982368469238281
Dropoff Latitude
40.679599761962891
Passenger Count
1
Trip Distance
1.10
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.04
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.84
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:02:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:09:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:02:23.000
Lpep Dropoff Datetime
2016-01-01T00:09:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.897224426269531
Pickup Latitude
40.844715118408203
Dropoff Longitude
-73.915657043457031
Dropoff Latitude
40.836311340332031
Passenger Count
1
Trip Distance
1.55
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:05:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:08:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:09.000
Lpep Dropoff Datetime
2016-01-01T00:08:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920524597167969
Pickup Latitude
40.76800537109375
Dropoff Longitude
-73.913467407226563
Dropoff Latitude
40.774730682373047
Passenger Count
1
Trip Distance
0.63
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:09:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:58.000
Lpep Dropoff Datetime
2016-01-01T00:09:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9522705078125
Pickup Latitude
40.798114776611328
Dropoff Longitude
-73.949638366699219
Dropoff Latitude
40.7933349609375
Passenger Count
1
Trip Distance
1.01
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