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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:37:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:59.000
Lpep Dropoff Datetime
2016-01-01T01:37:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944725036621094
Pickup Latitude
40.803112030029297
Dropoff Longitude
-73.950271606445313
Dropoff Latitude
40.771457672119141
Passenger Count
4
Trip Distance
2.90
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:41.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:46.000
Lpep Dropoff Datetime
2016-01-01T01:30:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925773620605469
Pickup Latitude
40.702968597412109
Dropoff Longitude
-73.923698425292969
Dropoff Latitude
40.697257995605469
Passenger Count
2
Trip Distance
0.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:43:16.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:49.000
Lpep Dropoff Datetime
2016-01-01T01:43:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956138610839844
Pickup Latitude
40.683536529541016
Dropoff Longitude
-73.91973876953125
Dropoff Latitude
40.743022918701172
Passenger Count
2
Trip Distance
5.90
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:36:14.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:47.000
Lpep Dropoff Datetime
2016-01-01T01:36:14.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.907875061035156
Pickup Latitude
40.873645782470703
Dropoff Longitude
-73.888786315917969
Dropoff Latitude
40.864707946777344
Passenger Count
2
Trip Distance
1.40
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:50.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:56.000
Lpep Dropoff Datetime
2016-01-01T01:40:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844413757324219
Pickup Latitude
40.721389770507813
Dropoff Longitude
-73.799301147460938
Dropoff Latitude
40.736236572265625
Passenger Count
1
Trip Distance
3.30
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
3.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.85
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:47:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:41.000
Lpep Dropoff Datetime
2016-01-01T01:47:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923942565917969
Pickup Latitude
40.690620422363281
Dropoff Longitude
-73.962211608886719
Dropoff Latitude
40.652965545654297
Passenger Count
1
Trip Distance
4.30
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.5
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:55.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:43.000
Lpep Dropoff Datetime
2016-01-01T01:41:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925369262695313
Pickup Latitude
40.702766418457031
Dropoff Longitude
-73.955055236816406
Dropoff Latitude
40.709774017333984
Passenger Count
1
Trip Distance
2.20
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
3.3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.6
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:40.000 • Lpep Dropoff Datetime: 2016-01-01T02:00:42.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:40.000
Lpep Dropoff Datetime
2016-01-01T02:00:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9144287109375
Pickup Latitude
40.845653533935547
Dropoff Longitude
-73.89544677734375
Dropoff Latitude
40.817550659179687
Passenger Count
2
Trip Distance
3.90
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:35:46.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:38.000
Lpep Dropoff Datetime
2016-01-01T01:35:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946189880371094
Pickup Latitude
40.812141418457031
Dropoff Longitude
-73.950271606445313
Dropoff Latitude
40.823074340820313
Passenger Count
3
Trip Distance
1.20
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:48:53.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:34.000
Lpep Dropoff Datetime
2016-01-01T01:48:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987037658691406
Pickup Latitude
40.702545166015625
Dropoff Longitude
-73.9207763671875
Dropoff Latitude
40.692691802978516
Passenger Count
2
Trip Distance
4.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:32:16.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:27.000
Lpep Dropoff Datetime
2016-01-01T01:32:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.009323120117188
Pickup Latitude
40.611335754394531
Dropoff Longitude
-74.030158996582031
Dropoff Latitude
40.618507385253906
Passenger Count
1
Trip Distance
1.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:02.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:25.000
Lpep Dropoff Datetime
2016-01-01T01:39:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979110717773437
Pickup Latitude
40.683017730712891
Dropoff Longitude
-73.947334289550781
Dropoff Latitude
40.673969268798828
Passenger Count
1
Trip Distance
2.10
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
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:53.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:18.000
Lpep Dropoff Datetime
2016-01-01T01:44:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956924438476563
Pickup Latitude
40.689224243164063
Dropoff Longitude
-73.916961669921875
Dropoff Latitude
40.672103881835938
Passenger Count
1
Trip Distance
3.10
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:27:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:27.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:27:58.000
Lpep Dropoff Datetime
2016-01-01T01:44:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881431579589844
Pickup Latitude
40.763923645019531
Dropoff Longitude
-73.925445556640625
Dropoff Latitude
40.747516632080078
Passenger Count
1
Trip Distance
3.20
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:34:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:19.000
Lpep Dropoff Datetime
2016-01-01T01:34:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.880210876464844
Pickup Latitude
40.741275787353516
Dropoff Longitude
-73.871131896972656
Dropoff Latitude
40.729637145996094
Passenger Count
1
Trip Distance
1.20
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:34:53.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:16.000
Lpep Dropoff Datetime
2016-01-01T01:34:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890548706054688
Pickup Latitude
40.747150421142578
Dropoff Longitude
-73.877029418945313
Dropoff Latitude
40.760166168212891
Passenger Count
1
Trip Distance
1.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:27:02.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:09.000
Lpep Dropoff Datetime
2016-01-01T01:27:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.932090759277344
Pickup Latitude
40.6632080078125
Dropoff Longitude
-73.932075500488281
Dropoff Latitude
40.663280487060547
Passenger Count
1
Trip Distance
0.10
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:53.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:30.000
Lpep Dropoff Datetime
2016-01-01T01:55:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9447021484375
Pickup Latitude
40.814163208007812
Dropoff Longitude
-73.998069763183594
Dropoff Latitude
40.736240386962891
Passenger Count
1
Trip Distance
8.10
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:33:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:03.000
Lpep Dropoff Datetime
2016-01-01T01:33:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941780090332031
Pickup Latitude
40.787807464599609
Dropoff Longitude
-73.956588745117187
Dropoff Latitude
40.771186828613281
Passenger Count
1
Trip Distance
1.50
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:46:26.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:33.000
Lpep Dropoff Datetime
2016-01-01T01:46:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9111328125
Pickup Latitude
40.781444549560547
Dropoff Longitude
-73.915092468261719
Dropoff Latitude
40.776008605957031
Passenger Count
3
Trip Distance
4.00
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:00.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:09.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:00.000
Lpep Dropoff Datetime
2016-01-01T01:30:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844429016113281
Pickup Latitude
40.721382141113281
Dropoff Longitude
-73.844779968261719
Dropoff Latitude
40.71173095703125
Passenger Count
1
Trip Distance
0.80
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:22:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:02.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:22:55.000
Lpep Dropoff Datetime
2016-01-01T01:45:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95306396484375
Pickup Latitude
40.745975494384766
Dropoff Longitude
-73.746307373046875
Dropoff Latitude
40.720943450927734
Passenger Count
1
Trip Distance
13.20
Fare Amount
37
Extra
0.5
Mta Tax
0.5
Tip Amount
7.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
45.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:52:40.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:53.000
Lpep Dropoff Datetime
2016-01-01T01:52:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9417724609375
Pickup Latitude
40.838150024414062
Dropoff Longitude
-73.976341247558594
Dropoff Latitude
40.763214111328125
Passenger Count
1
Trip Distance
7.00
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:27:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:38:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:27:10.000
Lpep Dropoff Datetime
2016-01-01T01:38:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98126220703125
Pickup Latitude
40.678287506103516
Dropoff Longitude
-73.956230163574219
Dropoff Latitude
40.674095153808594
Passenger Count
1
Trip Distance
2.00
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:29:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:51.000
Lpep Dropoff Datetime
2016-01-01T01:29:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940483093261719
Pickup Latitude
40.840450286865234
Dropoff Longitude
-73.947212219238281
Dropoff Latitude
40.837371826171875
Passenger Count
1
Trip Distance
0.60
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:36:50.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:45.000
Lpep Dropoff Datetime
2016-01-01T01:36:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905136108398438
Pickup Latitude
40.752544403076172
Dropoff Longitude
-73.877784729003906
Dropoff Latitude
40.7391357421875
Passenger Count
1
Trip Distance
1.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:54:47.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:53.000
Lpep Dropoff Datetime
2016-01-01T01:54:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961578369140625
Pickup Latitude
40.682403564453125
Dropoff Longitude
-73.958503723144531
Dropoff Latitude
40.772586822509766
Passenger Count
2
Trip Distance
9.60
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:26:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:26:02.000
Lpep Dropoff Datetime
2016-01-01T01:31:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944686889648437
Pickup Latitude
40.725601196289063
Dropoff Longitude
-73.954940795898438
Dropoff Latitude
40.73431396484375
Passenger Count
2
Trip Distance
1.10
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.45
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:34:27.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:41.000
Lpep Dropoff Datetime
2016-01-01T01:34:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986495971679688
Pickup Latitude
40.669353485107422
Dropoff Longitude
-73.979560852050781
Dropoff Latitude
40.647724151611328
Passenger Count
1
Trip Distance
2.30
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:32:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:53.000
Lpep Dropoff Datetime
2016-01-01T01:32:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921646118164063
Pickup Latitude
40.766849517822266
Dropoff Longitude
-73.909141540527344
Dropoff Latitude
40.7667236328125
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:41.000
Lpep Dropoff Datetime
2016-01-01T01:30:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807861328125
Pickup Latitude
40.699539184570313
Dropoff Longitude
-73.804977416992188
Dropoff Latitude
40.692157745361328
Passenger Count
2
Trip Distance
0.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:03.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:09.000
Lpep Dropoff Datetime
2016-01-01T01:30:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987174987792969
Pickup Latitude
40.692840576171875
Dropoff Longitude
-73.981010437011719
Dropoff Latitude
40.699817657470703
Passenger Count
1
Trip Distance
0.80
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:42:50.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:34.000
Lpep Dropoff Datetime
2016-01-01T01:42:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.87353515625
Pickup Latitude
40.749588012695313
Dropoff Longitude
-73.893760681152344
Dropoff Latitude
40.742725372314453
Passenger Count
2
Trip Distance
1.70
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:25:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:28.000
Lpep Dropoff Datetime
2016-01-01T01:25:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922653198242187
Pickup Latitude
40.705680847167969
Dropoff Longitude
-73.922653198242187
Dropoff Latitude
40.705680847167969
Passenger Count
1
Trip Distance
0.00
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:35:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:47.000
Lpep Dropoff Datetime
2016-01-01T01:35:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.865867614746094
Pickup Latitude
40.857891082763672
Dropoff Longitude
-73.886177062988281
Dropoff Latitude
40.849479675292969
Passenger Count
2
Trip Distance
1.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:54.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:45.000
Lpep Dropoff Datetime
2016-01-01T01:31:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913055419921875
Pickup Latitude
40.757495880126953
Dropoff Longitude
-73.894027709960937
Dropoff Latitude
40.768566131591797
Passenger Count
1
Trip Distance
1.50
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:39.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:21.000
Lpep Dropoff Datetime
2016-01-01T01:40:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.824302673339844
Pickup Latitude
40.760993957519531
Dropoff Longitude
-73.918777465820313
Dropoff Latitude
40.774200439453125
Passenger Count
1
Trip Distance
6.00
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:52:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:19.000
Lpep Dropoff Datetime
2016-01-01T01:52:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.984832763671875
Pickup Latitude
40.696426391601563
Dropoff Longitude
-73.898605346679687
Dropoff Latitude
40.675548553466797
Passenger Count
1
Trip Distance
5.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:35:37.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:14.000
Lpep Dropoff Datetime
2016-01-01T01:35:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.872161865234375
Pickup Latitude
40.734550476074219
Dropoff Longitude
-73.883995056152344
Dropoff Latitude
40.7581787109375
Passenger Count
4
Trip Distance
2.20
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:33:56.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:09.000
Lpep Dropoff Datetime
2016-01-01T01:33:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.884819030761719
Pickup Latitude
40.854305267333984
Dropoff Longitude
-73.904998779296875
Dropoff Latitude
40.839729309082031
Passenger Count
1
Trip Distance
1.80
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:09.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:06.000
Lpep Dropoff Datetime
2016-01-01T01:40:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957962036132813
Pickup Latitude
40.717010498046875
Dropoff Longitude
-73.95123291015625
Dropoff Latitude
40.688282012939453
Passenger Count
1
Trip Distance
2.40
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:49.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:53.000
Lpep Dropoff Datetime
2016-01-01T01:30:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.880790710449219
Pickup Latitude
40.741691589355469
Dropoff Longitude
-73.883659362792969
Dropoff Latitude
40.747703552246094
Passenger Count
1
Trip Distance
0.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:23.000
Lpep Dropoff Datetime
2016-01-01T01:40:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.877304077148438
Pickup Latitude
40.748371124267578
Dropoff Longitude
-73.859359741210937
Dropoff Latitude
40.726516723632813
Passenger Count
2
Trip Distance
2.20
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:24:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:24:26.000
Lpep Dropoff Datetime
2016-01-01T01:31:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.910621643066406
Pickup Latitude
40.699642181396484
Dropoff Longitude
-73.923057556152344
Dropoff Latitude
40.690078735351563
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
3
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:02.000
Lpep Dropoff Datetime
2016-01-01T01:55:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.972831726074219
Pickup Latitude
40.677822113037109
Dropoff Longitude
-73.954658508300781
Dropoff Latitude
40.765346527099609
Passenger Count
1
Trip Distance
8.20
Fare Amount
29
Extra
0.5
Mta Tax
0.5
Tip Amount
6.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:24:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:26.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:24:36.000
Lpep Dropoff Datetime
2016-01-01T01:31:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882278442382813
Pickup Latitude
40.755939483642578
Dropoff Longitude
-73.885780334472656
Dropoff Latitude
40.747589111328125
Passenger Count
1
Trip Distance
0.80
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:24:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:32:29.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:24:28.000
Lpep Dropoff Datetime
2016-01-01T01:32:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913925170898438
Pickup Latitude
40.838996887207031
Dropoff Longitude
-73.924827575683594
Dropoff Latitude
40.838523864746094
Passenger Count
1
Trip Distance
0.70
Fare Amount
6.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:36.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:36.000
Lpep Dropoff Datetime
2016-01-01T01:39:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913528442382813
Pickup Latitude
40.669193267822266
Dropoff Longitude
-73.875045776367188
Dropoff Latitude
40.674980163574219
Passenger Count
3
Trip Distance
2.50
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:24:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:33.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:24:39.000
Lpep Dropoff Datetime
2016-01-01T01:31:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927642822265625
Pickup Latitude
40.763015747070313
Dropoff Longitude
-73.911041259765625
Dropoff Latitude
40.761936187744141
Passenger Count
1
Trip Distance
1.10
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.75
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:25:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:06.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:25:17.000
Lpep Dropoff Datetime
2016-01-01T01:30:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959861755371094
Pickup Latitude
40.717891693115234
Dropoff Longitude
-73.966438293457031
Dropoff Latitude
40.711296081542969
Passenger Count
2
Trip Distance
0.70
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