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:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:45.000
Lpep Dropoff Datetime
2016-01-01T00:22:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953239440917969
Pickup Latitude
40.802078247070313
Dropoff Longitude
-73.961448669433594
Dropoff Latitude
40.798576354980469
Passenger Count
5
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-01T00:19:03.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:03.000
Lpep Dropoff Datetime
2016-01-01T00:22:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.980010986328125
Pickup Latitude
40.681758880615234
Dropoff Longitude
-73.968719482421875
Dropoff Latitude
40.678627014160156
Passenger Count
1
Trip Distance
0.64
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:18:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:55.000
Lpep Dropoff Datetime
2016-01-01T00:23:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941139221191406
Pickup Latitude
40.83935546875
Dropoff Longitude
-73.94873046875
Dropoff Latitude
40.828777313232422
Passenger Count
1
Trip Distance
0.84
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:10:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:33.000
Lpep Dropoff Datetime
2016-01-01T00:22:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912300109863281
Pickup Latitude
40.767135620117188
Dropoff Longitude
-73.864791870117188
Dropoff Latitude
40.736953735351563
Passenger Count
5
Trip Distance
6.26
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:10.000
Lpep Dropoff Datetime
2016-01-01T00:23:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925254821777344
Pickup Latitude
40.762054443359375
Dropoff Longitude
-73.913047790527344
Dropoff Latitude
40.774162292480469
Passenger Count
1
Trip Distance
1.04
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-01T00:09:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:09:09.000
Lpep Dropoff Datetime
2016-01-01T00:23:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987350463867188
Pickup Latitude
40.692054748535156
Dropoff Longitude
-73.876716613769531
Dropoff Latitude
40.73883056640625
Passenger Count
2
Trip Distance
7.57
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
4.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:10:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:32.000
Lpep Dropoff Datetime
2016-01-01T00:22:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933082580566406
Pickup Latitude
40.709480285644531
Dropoff Longitude
-73.894493103027344
Dropoff Latitude
40.696315765380859
Passenger Count
1
Trip Distance
2.70
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:11.000
Lpep Dropoff Datetime
2016-01-01T00:22:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908004760742188
Pickup Latitude
40.774318695068359
Dropoff Longitude
-73.92730712890625
Dropoff Latitude
40.776416778564453
Passenger Count
3
Trip Distance
1.36
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:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:09:40.000
Lpep Dropoff Datetime
2016-01-01T00:22:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924072265625
Pickup Latitude
40.679050445556641
Dropoff Longitude
-73.961982727050781
Dropoff Latitude
40.662372589111328
Passenger Count
1
Trip Distance
3.46
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:25.000
Lpep Dropoff Datetime
2016-01-01T00:23:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939773559570313
Pickup Latitude
40.707263946533203
Dropoff Longitude
-73.965675354003906
Dropoff Latitude
40.713127136230469
Passenger Count
1
Trip Distance
2.03
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
2.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:01:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:01:33.000
Lpep Dropoff Datetime
2016-01-01T00:22:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.865943908691406
Pickup Latitude
40.737007141113281
Dropoff Longitude
-73.916732788085937
Dropoff Latitude
40.757713317871094
Passenger Count
1
Trip Distance
5.50
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
4.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:49.000
Lpep Dropoff Datetime
2016-01-01T00:22:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93328857421875
Pickup Latitude
40.705188751220703
Dropoff Longitude
-73.950889587402344
Dropoff Latitude
40.711036682128906
Passenger Count
1
Trip Distance
1.37
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.34
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.14
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:37.000
Lpep Dropoff Datetime
2016-01-01T00:23:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961456298828125
Pickup Latitude
40.717391967773438
Dropoff Longitude
-73.957588195800781
Dropoff Latitude
40.730121612548828
Passenger Count
2
Trip Distance
1.43
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:10:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:18.000
Lpep Dropoff Datetime
2016-01-01T00:23:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964286804199219
Pickup Latitude
40.715858459472656
Dropoff Longitude
-73.983222961425781
Dropoff Latitude
40.724330902099609
Passenger Count
1
Trip Distance
2.51
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.84
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.64
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:08:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:29.000
Lpep Dropoff Datetime
2016-01-01T00:22:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953971862792969
Pickup Latitude
40.69488525390625
Dropoff Longitude
-73.962150573730469
Dropoff Latitude
40.647136688232422
Passenger Count
1
Trip Distance
3.68
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-01T00:21:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:24.000
Lpep Dropoff Datetime
2016-01-01T00:23:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.860527038574219
Pickup Latitude
40.684894561767578
Dropoff Longitude
-73.871368408203125
Dropoff Latitude
40.680900573730469
Passenger Count
1
Trip Distance
0.60
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:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:21:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:06:11.000
Lpep Dropoff Datetime
2016-01-01T00:21:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988975524902344
Pickup Latitude
40.695995330810547
Dropoff Longitude
-73.936233520507813
Dropoff Latitude
40.711627960205078
Passenger Count
2
Trip Distance
4.33
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:04:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:44.000
Lpep Dropoff Datetime
2016-01-01T00:22:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945083618164062
Pickup Latitude
40.808181762695313
Dropoff Longitude
-73.958755493164063
Dropoff Latitude
40.762260437011719
Passenger Count
1
Trip Distance
4.78
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.34
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.14
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:19:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:42.000
Lpep Dropoff Datetime
2016-01-01T00:22:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.931076049804688
Pickup Latitude
40.848201751708984
Dropoff Longitude
-73.923469543457031
Dropoff Latitude
40.849018096923828
Passenger Count
1
Trip Distance
1.27
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:06:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:06:36.000
Lpep Dropoff Datetime
2016-01-01T00:23:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955909729003906
Pickup Latitude
40.714099884033203
Dropoff Longitude
-73.924430847167969
Dropoff Latitude
40.743625640869141
Passenger Count
5
Trip Distance
3.72
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:14:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:28.000
Lpep Dropoff Datetime
2016-01-01T00:22:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.830116271972656
Pickup Latitude
40.759593963623047
Dropoff Longitude
-73.813369750976562
Dropoff Latitude
40.771717071533203
Passenger Count
1
Trip Distance
1.67
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:13:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:05.000
Lpep Dropoff Datetime
2016-01-01T00:22:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896766662597656
Pickup Latitude
40.746292114257813
Dropoff Longitude
-73.918113708496094
Dropoff Latitude
40.745647430419922
Passenger Count
1
Trip Distance
1.45
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:19:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:41.000
Lpep Dropoff Datetime
2016-01-01T00:22:15.000
Store And Fwd Flag
N
Ratecodeid
3
Pickup Longitude
-73.957931518554687
Pickup Latitude
40.815135955810547
Dropoff Longitude
-73.955963134765625
Dropoff Latitude
40.813591003417969
Passenger Count
1
Trip Distance
0.16
Fare Amount
-21
Extra
-0.5
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
-0.3
Total Amount
-21.8
Payment Type
3
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:04:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:54.000
Lpep Dropoff Datetime
2016-01-01T00:23:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952774047851562
Pickup Latitude
40.808071136474609
Dropoff Longitude
-73.962554931640625
Dropoff Latitude
40.764419555664063
Passenger Count
1
Trip Distance
3.99
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
3.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:08:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:29.000
Lpep Dropoff Datetime
2016-01-01T00:22:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966140747070312
Pickup Latitude
40.804706573486328
Dropoff Longitude
-73.954063415527344
Dropoff Latitude
40.774791717529297
Passenger Count
1
Trip Distance
2.94
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-01T00:19:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:51.000
Lpep Dropoff Datetime
2016-01-01T00:23:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882728576660156
Pickup Latitude
40.75592041015625
Dropoff Longitude
-73.879806518554688
Dropoff Latitude
40.751056671142578
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:11:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:19.000
Lpep Dropoff Datetime
2016-01-01T00:23:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978996276855469
Pickup Latitude
40.683876037597656
Dropoff Longitude
-73.961074829101562
Dropoff Latitude
40.693866729736328
Passenger Count
1
Trip Distance
1.82
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-01T00:13:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:29.000
Lpep Dropoff Datetime
2016-01-01T00:23:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948173522949219
Pickup Latitude
40.824497222900391
Dropoff Longitude
-73.951797485351563
Dropoff Latitude
40.808681488037109
Passenger Count
1
Trip Distance
1.54
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:12:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:46.000
Lpep Dropoff Datetime
2016-01-01T00:23:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.980079650878906
Pickup Latitude
40.668514251708984
Dropoff Longitude
-74.027297973632812
Dropoff Latitude
40.639148712158203
Passenger Count
1
Trip Distance
4.36
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:12:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:21.000
Lpep Dropoff Datetime
2016-01-01T00:23:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969833374023438
Pickup Latitude
40.672687530517578
Dropoff Longitude
-73.971916198730469
Dropoff Latitude
40.687488555908203
Passenger Count
1
Trip Distance
2.21
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:12:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:49.000
Lpep Dropoff Datetime
2016-01-01T00:22:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.886299133300781
Pickup Latitude
40.744544982910156
Dropoff Longitude
-73.854804992675781
Dropoff Latitude
40.732906341552734
Passenger Count
1
Trip Distance
2.16
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:18:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:16.000
Lpep Dropoff Datetime
2016-01-01T00:23:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952255249023438
Pickup Latitude
40.726421356201172
Dropoff Longitude
-73.958854675292969
Dropoff Latitude
40.722278594970703
Passenger Count
1
Trip Distance
0.70
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:14:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:50.000
Lpep Dropoff Datetime
2016-01-01T00:22:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953857421875
Pickup Latitude
40.811237335205078
Dropoff Longitude
-73.943382263183594
Dropoff Latitude
40.810184478759766
Passenger Count
1
Trip Distance
1.30
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:14:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:28.000
Lpep Dropoff Datetime
2016-01-01T00:22:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.877532958984375
Pickup Latitude
40.748371124267578
Dropoff Longitude
-73.862678527832031
Dropoff Latitude
40.756050109863281
Passenger Count
1
Trip Distance
1.42
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:13:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:31.000
Lpep Dropoff Datetime
2016-01-01T00:23:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948272705078125
Pickup Latitude
40.784713745117188
Dropoff Longitude
-73.972557067871094
Dropoff Latitude
40.752201080322266
Passenger Count
1
Trip Distance
2.73
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.54
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.34
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:19:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:44.000
Lpep Dropoff Datetime
2016-01-01T00:23:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957313537597656
Pickup Latitude
40.722190856933594
Dropoff Longitude
-73.958160400390625
Dropoff Latitude
40.733341217041016
Passenger Count
1
Trip Distance
0.82
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:13:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:26.000
Lpep Dropoff Datetime
2016-01-01T00:23:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.889961242675781
Pickup Latitude
40.749263763427734
Dropoff Longitude
-73.893997192382813
Dropoff Latitude
40.726802825927734
Passenger Count
2
Trip Distance
2.34
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-01T00:19:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:29.000
Lpep Dropoff Datetime
2016-01-01T00:23:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.97119140625
Pickup Latitude
40.671405792236328
Dropoff Longitude
-73.984642028808594
Dropoff Latitude
40.663150787353516
Passenger Count
1
Trip Distance
1.17
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:12:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:54.000
Lpep Dropoff Datetime
2016-01-01T00:23:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903366088867188
Pickup Latitude
40.745845794677734
Dropoff Longitude
-73.862586975097656
Dropoff Latitude
40.729850769042969
Passenger Count
1
Trip Distance
2.62
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:10:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:21.000
Lpep Dropoff Datetime
2016-01-01T00:23:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956161499023438
Pickup Latitude
40.803363800048828
Dropoff Longitude
-73.979469299316406
Dropoff Latitude
40.784721374511719
Passenger Count
1
Trip Distance
3.20
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:12:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:11.000
Lpep Dropoff Datetime
2016-01-01T00:23:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943252563476562
Pickup Latitude
40.816078186035156
Dropoff Longitude
-73.937286376953125
Dropoff Latitude
40.798458099365234
Passenger Count
1
Trip Distance
1.76
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-01T00:08:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:41.000
Lpep Dropoff Datetime
2016-01-01T00:23:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942611694335938
Pickup Latitude
40.816963195800781
Dropoff Longitude
-73.996955871582031
Dropoff Latitude
40.762901306152344
Passenger Count
1
Trip Distance
5.80
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:18:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:31.000
Lpep Dropoff Datetime
2016-01-01T00:22:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961502075195313
Pickup Latitude
40.714107513427734
Dropoff Longitude
-73.959259033203125
Dropoff Latitude
40.716403961181641
Passenger Count
1
Trip Distance
0.56
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: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
4
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:12:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:55.000
Lpep Dropoff Datetime
2016-01-01T00:23:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965408325195313
Pickup Latitude
40.710960388183594
Dropoff Longitude
-73.945526123046875
Dropoff Latitude
40.692859649658203
Passenger Count
1
Trip Distance
2.28
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-01T00:15:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:22:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:26.000
Lpep Dropoff Datetime
2016-01-01T00:22:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951019287109375
Pickup Latitude
40.723686218261719
Dropoff Longitude
-73.959197998046875
Dropoff Latitude
40.716873168945313
Passenger Count
5
Trip Distance
1.14
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:10:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:43.000
Lpep Dropoff Datetime
2016-01-01T00:23:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977890014648437
Pickup Latitude
40.684761047363281
Dropoff Longitude
-74.006660461425781
Dropoff Latitude
40.708099365234375
Passenger Count
1
Trip Distance
3.06
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:10:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:10.000
Lpep Dropoff Datetime
2016-01-01T00:23:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.975982666015625
Pickup Latitude
40.652118682861328
Dropoff Longitude
-74.009361267089844
Dropoff Latitude
40.714054107666016
Passenger Count
1
Trip Distance
5.75
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
3.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:11:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:08.000
Lpep Dropoff Datetime
2016-01-01T00:23:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.989089965820313
Pickup Latitude
40.693729400634766
Dropoff Longitude
-74.019508361816406
Dropoff Latitude
40.647964477539063
Passenger Count
3
Trip Distance
5.97
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:19:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:13.000
Lpep Dropoff Datetime
2016-01-01T00:23:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.906997680664062
Pickup Latitude
40.753208160400391
Dropoff Longitude
-73.885505676269531
Dropoff Latitude
40.755470275878906
Passenger Count
1
Trip Distance
1.17
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