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:20:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:34:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:20:30.000
Lpep Dropoff Datetime
2016-01-01T01:34:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9539794921875
Pickup Latitude
40.725807189941406
Dropoff Longitude
-73.961433410644531
Dropoff Latitude
40.694133758544922
Passenger Count
1
Trip Distance
2.80
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:11.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:56.000
Lpep Dropoff Datetime
2016-01-01T01:30:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917778015136719
Pickup Latitude
40.770153045654297
Dropoff Longitude
-73.909278869628906
Dropoff Latitude
40.745105743408203
Passenger Count
1
Trip Distance
3.00
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:19:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:28.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:56.000
Lpep Dropoff Datetime
2016-01-01T01:39:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.967140197753906
Pickup Latitude
40.673717498779297
Dropoff Longitude
-73.960441589355469
Dropoff Latitude
40.635818481445313
Passenger Count
1
Trip Distance
4.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:06:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:11.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:06:16.000
Lpep Dropoff Datetime
2016-01-01T01:20:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987602233886719
Pickup Latitude
40.690883636474609
Dropoff Longitude
-74.006340026855469
Dropoff Latitude
40.682186126708984
Passenger Count
1
Trip Distance
2.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:43:12.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:51.000
Lpep Dropoff Datetime
2016-01-01T01:43:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963088989257813
Pickup Latitude
40.674385070800781
Dropoff Longitude
-73.918006896972656
Dropoff Latitude
40.743335723876953
Passenger Count
1
Trip Distance
7.70
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
5.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:37:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:47.000
Lpep Dropoff Datetime
2016-01-01T01:37:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.880485534667969
Pickup Latitude
40.764026641845703
Dropoff Longitude
-73.933143615722656
Dropoff Latitude
40.760383605957031
Passenger Count
1
Trip Distance
4.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:20:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:23:59.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:20:02.000
Lpep Dropoff Datetime
2016-01-01T01:23:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.995994567871094
Pickup Latitude
40.682418823242187
Dropoff Longitude
-74.003211975097656
Dropoff Latitude
40.684097290039063
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:19:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:46:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:48.000
Lpep Dropoff Datetime
2016-01-01T01:46:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.830238342285156
Pickup Latitude
40.713558197021484
Dropoff Longitude
-73.956779479980469
Dropoff Latitude
40.766796112060547
Passenger Count
2
Trip Distance
11.40
Fare Amount
34.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:33:55.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:42.000
Lpep Dropoff Datetime
2016-01-01T01:33:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957206726074219
Pickup Latitude
40.812179565429688
Dropoff Longitude
-73.948486328125
Dropoff Latitude
40.782238006591797
Passenger Count
1
Trip Distance
3.10
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:26:43.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:44.000
Lpep Dropoff Datetime
2016-01-01T01:26:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.857337951660156
Pickup Latitude
40.73968505859375
Dropoff Longitude
-73.868446350097656
Dropoff Latitude
40.747306823730469
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:19:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:27:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:36.000
Lpep Dropoff Datetime
2016-01-01T01:27:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948539733886719
Pickup Latitude
40.815658569335938
Dropoff Longitude
-73.937423706054687
Dropoff Latitude
40.841648101806641
Passenger Count
1
Trip Distance
2.00
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:59.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:29.000
Lpep Dropoff Datetime
2016-01-01T01:41:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950889587402344
Pickup Latitude
40.805580139160156
Dropoff Longitude
-73.932334899902344
Dropoff Latitude
40.85186767578125
Passenger Count
1
Trip Distance
3.90
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
3
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:20:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:28:05.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:20:44.000
Lpep Dropoff Datetime
2016-01-01T01:28:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956367492675781
Pickup Latitude
40.675117492675781
Dropoff Longitude
-73.959434509277344
Dropoff Latitude
40.694236755371094
Passenger Count
1
Trip Distance
1.70
Fare Amount
7.5
Extra
1
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:19:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:23:48.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:25.000
Lpep Dropoff Datetime
2016-01-01T01:23:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949440002441406
Pickup Latitude
40.802032470703125
Dropoff Longitude
-73.939582824707031
Dropoff Latitude
40.805313110351563
Passenger Count
3
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
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:35:34.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:15.000
Lpep Dropoff Datetime
2016-01-01T01:35:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915847778320313
Pickup Latitude
40.850444793701172
Dropoff Longitude
-73.876976013183594
Dropoff Latitude
40.879489898681641
Passenger Count
1
Trip Distance
5.50
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:20:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:36:45.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:20:05.000
Lpep Dropoff Datetime
2016-01-01T01:36:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954292297363281
Pickup Latitude
40.730487823486328
Dropoff Longitude
-73.913856506347656
Dropoff Latitude
40.755916595458984
Passenger Count
1
Trip Distance
3.20
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:19:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:29:09.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:12.000
Lpep Dropoff Datetime
2016-01-01T01:29:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978683471679688
Pickup Latitude
40.684139251708984
Dropoff Longitude
-73.996292114257813
Dropoff Latitude
40.66229248046875
Passenger Count
2
Trip Distance
1.80
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:20:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:24:24.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:20:24.000
Lpep Dropoff Datetime
2016-01-01T01:24:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983901977539062
Pickup Latitude
40.677688598632813
Dropoff Longitude
-73.977035522460938
Dropoff Latitude
40.676666259765625
Passenger Count
1
Trip Distance
0.70
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:19:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:27:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:22.000
Lpep Dropoff Datetime
2016-01-01T01:27:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991531372070313
Pickup Latitude
40.691379547119141
Dropoff Longitude
-74.006172180175781
Dropoff Latitude
40.678501129150391
Passenger Count
1
Trip Distance
2.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:08.000 • Lpep Dropoff Datetime: 2016-01-01T01:33:37.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:08.000
Lpep Dropoff Datetime
2016-01-01T01:33:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.975051879882813
Pickup Latitude
40.676792144775391
Dropoff Longitude
-73.994468688964844
Dropoff Latitude
40.698047637939453
Passenger Count
2
Trip Distance
2.40
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:34:08.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:22.000
Lpep Dropoff Datetime
2016-01-01T01:34:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912635803222656
Pickup Latitude
40.841789245605469
Dropoff Longitude
-73.954086303710938
Dropoff Latitude
40.823192596435547
Passenger Count
3
Trip Distance
4.50
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:19:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:21:43.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:02.000
Lpep Dropoff Datetime
2016-01-01T01:21:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94464111328125
Pickup Latitude
40.834163665771484
Dropoff Longitude
-73.945831298828125
Dropoff Latitude
40.838657379150391
Passenger Count
1
Trip Distance
0.20
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:52.000
Lpep Dropoff Datetime
2016-01-01T01:30:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.899078369140625
Pickup Latitude
40.825927734375
Dropoff Longitude
-73.867782592773438
Dropoff Latitude
40.840164184570313
Passenger Count
1
Trip Distance
2.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:24:24.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:53.000
Lpep Dropoff Datetime
2016-01-01T01:24:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966941833496094
Pickup Latitude
40.709846496582031
Dropoff Longitude
-73.959991455078125
Dropoff Latitude
40.717750549316406
Passenger Count
1
Trip Distance
0.80
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:37.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:22.000
Lpep Dropoff Datetime
2016-01-01T01:30:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937202453613281
Pickup Latitude
40.828239440917969
Dropoff Longitude
-73.932510375976563
Dropoff Latitude
40.850425720214844
Passenger Count
1
Trip Distance
1.80
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:22:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:42.000
Lpep Dropoff Datetime
2016-01-01T01:22:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957969665527344
Pickup Latitude
40.729915618896484
Dropoff Longitude
-73.957962036132813
Dropoff Latitude
40.721824645996094
Passenger Count
3
Trip Distance
0.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:32:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:59.000
Lpep Dropoff Datetime
2016-01-01T01:32:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952415466308594
Pickup Latitude
40.786529541015625
Dropoff Longitude
-73.971336364746094
Dropoff Latitude
40.749698638916016
Passenger Count
1
Trip Distance
3.60
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:28:59.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:33.000
Lpep Dropoff Datetime
2016-01-01T01:28:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979393005371094
Pickup Latitude
40.660823822021484
Dropoff Longitude
-73.950996398925781
Dropoff Latitude
40.657825469970703
Passenger Count
1
Trip Distance
2.20
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:18:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:46:27.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:34.000
Lpep Dropoff Datetime
2016-01-01T01:46:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952728271484375
Pickup Latitude
40.733982086181641
Dropoff Longitude
-73.925178527832031
Dropoff Latitude
40.691230773925781
Passenger Count
1
Trip Distance
3.90
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:03.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:59.000
Lpep Dropoff Datetime
2016-01-01T01:30:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94342041015625
Pickup Latitude
40.708683013916016
Dropoff Longitude
-73.962684631347656
Dropoff Latitude
40.710117340087891
Passenger Count
3
Trip Distance
1.30
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:49:45.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:29.000
Lpep Dropoff Datetime
2016-01-01T01:49:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.880966186523437
Pickup Latitude
40.741859436035156
Dropoff Longitude
-73.913726806640625
Dropoff Latitude
40.761409759521484
Passenger Count
2
Trip Distance
6.30
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
5.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:32:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:27.000
Lpep Dropoff Datetime
2016-01-01T01:32:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988189697265625
Pickup Latitude
40.659507751464844
Dropoff Longitude
-74.017005920410156
Dropoff Latitude
40.641841888427734
Passenger Count
1
Trip Distance
2.50
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:18:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:54:21.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:27.000
Lpep Dropoff Datetime
2016-01-01T01:54:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921638488769531
Pickup Latitude
40.766616821289063
Dropoff Longitude
-73.977432250976563
Dropoff Latitude
40.643741607666016
Passenger Count
2
Trip Distance
16.60
Fare Amount
48.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
55.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:52:32.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:27.000
Lpep Dropoff Datetime
2016-01-01T01:52:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.973258972167969
Pickup Latitude
40.681377410888672
Dropoff Longitude
-73.98101806640625
Dropoff Latitude
40.765911102294922
Passenger Count
1
Trip Distance
10.70
Fare Amount
35
Extra
0.5
Mta Tax
0.5
Tip Amount
9.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
45.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:19:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:36:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:19:19.000
Lpep Dropoff Datetime
2016-01-01T01:36:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.796852111816406
Pickup Latitude
40.690132141113281
Dropoff Longitude
-73.85198974609375
Dropoff Latitude
40.682670593261719
Passenger Count
1
Trip Distance
3.70
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:18:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:36:41.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:21.000
Lpep Dropoff Datetime
2016-01-01T01:36:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919013977050781
Pickup Latitude
40.67877197265625
Dropoff Longitude
-73.883308410644531
Dropoff Latitude
40.666820526123047
Passenger Count
1
Trip Distance
3.10
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0.01
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.31
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:02.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:20.000
Lpep Dropoff Datetime
2016-01-01T01:40:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902633666992188
Pickup Latitude
40.777057647705078
Dropoff Longitude
-73.903076171875
Dropoff Latitude
40.745689392089844
Passenger Count
1
Trip Distance
4.00
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:18:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:38:55.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:23.000
Lpep Dropoff Datetime
2016-01-01T01:38:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957565307617188
Pickup Latitude
40.722270965576172
Dropoff Longitude
-74.010787963867188
Dropoff Latitude
40.716304779052734
Passenger Count
2
Trip Distance
7.10
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:24.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:19.000
Lpep Dropoff Datetime
2016-01-01T01:31:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983322143554688
Pickup Latitude
40.694099426269531
Dropoff Longitude
-73.957313537597656
Dropoff Latitude
40.722164154052734
Passenger Count
1
Trip Distance
3.30
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:18:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:06.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:32.000
Lpep Dropoff Datetime
2016-01-01T01:41:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952827453613281
Pickup Latitude
40.680595397949219
Dropoff Longitude
-73.903167724609375
Dropoff Latitude
40.706130981445313
Passenger Count
1
Trip Distance
4.20
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
3.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:06.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:12.000
Lpep Dropoff Datetime
2016-01-01T01:39:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949897766113281
Pickup Latitude
40.744163513183594
Dropoff Longitude
-73.905540466308594
Dropoff Latitude
40.770042419433594
Passenger Count
1
Trip Distance
3.10
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
4.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:24:57.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:05.000
Lpep Dropoff Datetime
2016-01-01T01:24:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918739318847656
Pickup Latitude
40.765682220458984
Dropoff Longitude
-73.9168701171875
Dropoff Latitude
40.7548828125
Passenger Count
1
Trip Distance
1.10
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.1
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:28:07.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:10.000
Lpep Dropoff Datetime
2016-01-01T01:28:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991188049316406
Pickup Latitude
40.699733734130859
Dropoff Longitude
-74.0050048828125
Dropoff Latitude
40.676074981689453
Passenger Count
1
Trip Distance
2.10
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:28:29.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:45.000
Lpep Dropoff Datetime
2016-01-01T01:28:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954704284667969
Pickup Latitude
40.732646942138672
Dropoff Longitude
-73.9468994140625
Dropoff Latitude
40.709590911865234
Passenger Count
1
Trip Distance
1.70
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.9
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.7
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:18:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:30:35.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:18:13.000
Lpep Dropoff Datetime
2016-01-01T01:30:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941024780273438
Pickup Latitude
40.721775054931641
Dropoff Longitude
-73.957267761230469
Dropoff Latitude
40.681522369384766
Passenger Count
1
Trip Distance
3.70
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.75
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:17:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:29:42.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:17:53.000
Lpep Dropoff Datetime
2016-01-01T01:29:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945579528808594
Pickup Latitude
40.807613372802734
Dropoff Longitude
-73.942848205566406
Dropoff Latitude
40.787460327148437
Passenger Count
1
Trip Distance
1.90
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:17:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:01.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:17:53.000
Lpep Dropoff Datetime
2016-01-01T01:41:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.859214782714844
Pickup Latitude
40.751510620117187
Dropoff Longitude
-73.923805236816406
Dropoff Latitude
40.761264801025391
Passenger Count
1
Trip Distance
4.00
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:17:54.000 • Lpep Dropoff Datetime: 2016-01-01T02:35:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:17:54.000
Lpep Dropoff Datetime
2016-01-01T02:35:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922714233398438
Pickup Latitude
40.634677886962891
Dropoff Longitude
-73.988189697265625
Dropoff Latitude
40.719993591308594
Passenger Count
1
Trip Distance
19.20
Fare Amount
67
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
70.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:17:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:27:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:17:48.000
Lpep Dropoff Datetime
2016-01-01T01:27:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994422912597656
Pickup Latitude
40.685501098632813
Dropoff Longitude
-73.979606628417969
Dropoff Latitude
40.684814453125
Passenger Count
1
Trip Distance
1.20
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:17:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:34:50.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:17:39.000
Lpep Dropoff Datetime
2016-01-01T01:34:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.847496032714844
Pickup Latitude
40.817047119140625
Dropoff Longitude
-73.8519287109375
Dropoff Latitude
40.840988159179688
Passenger Count
1
Trip Distance
2.30
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