Ask NYC Browse All Data Public Safety Transportation Health Buildings

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-01T00:30:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:30:19.000
Lpep Dropoff Datetime
2016-01-01T00:47:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951499938964844
Pickup Latitude
40.743282318115234
Dropoff Longitude
-73.917388916015625
Dropoff Latitude
40.706668853759766
Passenger Count
1
Trip Distance
4.00
Fare Amount
15
Extra
0
Mta Tax
0.5
Tip Amount
3.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:40.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:56.000
Lpep Dropoff Datetime
2016-01-01T00:40:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.989334106445313
Pickup Latitude
40.6695556640625
Dropoff Longitude
-73.965072631835938
Dropoff Latitude
40.688308715820313
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-01T00:29:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:34.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:50.000
Lpep Dropoff Datetime
2016-01-01T00:48:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943962097167969
Pickup Latitude
40.83013916015625
Dropoff Longitude
-73.936416625976563
Dropoff Latitude
40.806423187255859
Passenger Count
1
Trip Distance
2.40
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-01T00:29:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:56.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:47.000
Lpep Dropoff Datetime
2016-01-01T00:52:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950515747070312
Pickup Latitude
40.694427490234375
Dropoff Longitude
-73.949394226074219
Dropoff Latitude
40.762443542480469
Passenger Count
1
Trip Distance
7.10
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
6.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:31:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:38:11.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:31:12.000
Lpep Dropoff Datetime
2016-01-01T00:38:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.897422790527344
Pickup Latitude
40.746234893798828
Dropoff Longitude
-73.915130615234375
Dropoff Latitude
40.775962829589844
Passenger Count
1
Trip Distance
2.50
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-01T00:29:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:13.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:42.000
Lpep Dropoff Datetime
2016-01-01T00:34:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957756042480469
Pickup Latitude
40.722023010253906
Dropoff Longitude
-73.961669921875
Dropoff Latitude
40.717487335205078
Passenger Count
2
Trip Distance
0.90
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-01T00:29:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:31:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:36.000
Lpep Dropoff Datetime
2016-01-01T00:31:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983688354492187
Pickup Latitude
40.686435699462891
Dropoff Longitude
-73.979820251464844
Dropoff Latitude
40.684982299804688
Passenger Count
2
Trip Distance
0.20
Fare Amount
3.5
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:38:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:38.000
Lpep Dropoff Datetime
2016-01-01T00:38:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954841613769531
Pickup Latitude
40.671855926513672
Dropoff Longitude
-73.974983215332031
Dropoff Latitude
40.672153472900391
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-01T00:30:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:20.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:30:27.000
Lpep Dropoff Datetime
2016-01-01T00:48:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987625122070313
Pickup Latitude
40.702388763427734
Dropoff Longitude
-73.980636596679688
Dropoff Latitude
40.733894348144531
Passenger Count
1
Trip Distance
5.00
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:37.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:32.000
Lpep Dropoff Datetime
2016-01-01T00:32:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919326782226562
Pickup Latitude
40.671707153320313
Dropoff Longitude
-73.921661376953125
Dropoff Latitude
40.670944213867188
Passenger Count
1
Trip Distance
0.40
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:31:42.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:27.000
Lpep Dropoff Datetime
2016-01-01T00:31:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903533935546875
Pickup Latitude
40.774913787841797
Dropoff Longitude
-73.909965515136719
Dropoff Latitude
40.769718170166016
Passenger Count
1
Trip Distance
0.50
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:23.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:31.000
Lpep Dropoff Datetime
2016-01-01T00:36:23.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.909553527832031
Pickup Latitude
40.816066741943359
Dropoff Longitude
-73.923004150390625
Dropoff Latitude
40.82373046875
Passenger Count
1
Trip Distance
1.20
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-01T00:29:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:32.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:55.000
Lpep Dropoff Datetime
2016-01-01T00:52:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951316833496094
Pickup Latitude
40.712211608886719
Dropoff Longitude
-73.955673217773438
Dropoff Latitude
40.662841796875
Passenger Count
1
Trip Distance
4.40
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-01T00:29:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:27.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:54.000
Lpep Dropoff Datetime
2016-01-01T00:30:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946548461914063
Pickup Latitude
40.797683715820313
Dropoff Longitude
-73.9462890625
Dropoff Latitude
40.797840118408203
Passenger Count
1
Trip Distance
2.10
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
5
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:30:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:43.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:30:20.000
Lpep Dropoff Datetime
2016-01-01T00:48:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962615966796875
Pickup Latitude
40.711582183837891
Dropoff Longitude
-73.996330261230469
Dropoff Latitude
40.737934112548828
Passenger Count
3
Trip Distance
3.90
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:19.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:10.000
Lpep Dropoff Datetime
2016-01-01T00:45:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959152221679688
Pickup Latitude
40.729747772216797
Dropoff Longitude
-73.929435729980469
Dropoff Latitude
40.699848175048828
Passenger Count
4
Trip Distance
3.20
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-01T00:29:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:08.000
Lpep Dropoff Datetime
2016-01-01T00:45:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913780212402344
Pickup Latitude
40.807643890380859
Dropoff Longitude
-73.904853820800781
Dropoff Latitude
40.855278015136719
Passenger Count
1
Trip Distance
5.00
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:30:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:38:26.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:30:08.000
Lpep Dropoff Datetime
2016-01-01T00:38:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.864959716796875
Pickup Latitude
40.761322021484375
Dropoff Longitude
-73.882644653320313
Dropoff Latitude
40.755893707275391
Passenger Count
3
Trip Distance
1.50
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-01T00:29:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:15.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:04.000
Lpep Dropoff Datetime
2016-01-01T00:36:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.869522094726562
Pickup Latitude
40.748924255371094
Dropoff Longitude
-73.864326477050781
Dropoff Latitude
40.730613708496094
Passenger Count
1
Trip Distance
1.40
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-01T00:30:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:30:30.000
Lpep Dropoff Datetime
2016-01-01T00:47:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963836669921875
Pickup Latitude
40.710552215576172
Dropoff Longitude
-73.938125610351563
Dropoff Latitude
40.708484649658203
Passenger Count
3
Trip Distance
1.90
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:50.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:04.000
Lpep Dropoff Datetime
2016-01-01T00:35:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95428466796875
Pickup Latitude
40.787326812744141
Dropoff Longitude
-73.955802917480469
Dropoff Latitude
40.776195526123047
Passenger Count
1
Trip Distance
1.30
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-01T00:28:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:36.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:59.000
Lpep Dropoff Datetime
2016-01-01T00:33:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.850090026855469
Pickup Latitude
40.875865936279297
Dropoff Longitude
-73.854591369628906
Dropoff Latitude
40.886119842529297
Passenger Count
2
Trip Distance
1.00
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-01T00:29:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:55.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:33.000
Lpep Dropoff Datetime
2016-01-01T00:33:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926902770996094
Pickup Latitude
40.762603759765625
Dropoff Longitude
-73.918075561523438
Dropoff Latitude
40.769210815429687
Passenger Count
1
Trip Distance
0.80
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-01T00:28:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:40.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:47.000
Lpep Dropoff Datetime
2016-01-01T00:44:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956520080566406
Pickup Latitude
40.714218139648437
Dropoff Longitude
-73.925666809082031
Dropoff Latitude
40.743740081787109
Passenger Count
1
Trip Distance
3.10
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:39.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:55.000
Lpep Dropoff Datetime
2016-01-01T00:48:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918365478515625
Pickup Latitude
40.765415191650391
Dropoff Longitude
-73.914138793945313
Dropoff Latitude
40.776935577392578
Passenger Count
4
Trip Distance
3.40
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:22.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:52.000
Lpep Dropoff Datetime
2016-01-01T00:34:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968040466308594
Pickup Latitude
40.679695129394531
Dropoff Longitude
-73.968276977539063
Dropoff Latitude
40.690170288085938
Passenger Count
2
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-01T00:28:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:13.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:49.000
Lpep Dropoff Datetime
2016-01-01T01:01:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952194213867188
Pickup Latitude
40.717304229736328
Dropoff Longitude
-73.957427978515625
Dropoff Latitude
40.805423736572266
Passenger Count
2
Trip Distance
11.70
Fare Amount
36
Extra
0.5
Mta Tax
0.5
Tip Amount
8.55
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
51.39
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:09.000
Lpep Dropoff Datetime
2016-01-01T00:40:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951736450195312
Pickup Latitude
40.714897155761719
Dropoff Longitude
-73.999221801757812
Dropoff Latitude
40.675857543945313
Passenger Count
2
Trip Distance
5.40
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:11.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:46.000
Lpep Dropoff Datetime
2016-01-01T00:35:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955009460449219
Pickup Latitude
40.800018310546875
Dropoff Longitude
-73.970237731933594
Dropoff Latitude
40.789211273193359
Passenger Count
1
Trip Distance
1.40
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-01T00:28:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:44.000
Lpep Dropoff Datetime
2016-01-01T00:39:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958160400390625
Pickup Latitude
40.717411041259766
Dropoff Longitude
-73.983955383300781
Dropoff Latitude
40.693607330322266
Passenger Count
1
Trip Distance
3.40
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.25
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:40.000
Lpep Dropoff Datetime
2016-01-01T00:56:10.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.958061218261719
Pickup Latitude
40.815250396728516
Dropoff Longitude
-73.904808044433594
Dropoff Latitude
40.823070526123047
Passenger Count
1
Trip Distance
3.90
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:29:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:49.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:29:31.000
Lpep Dropoff Datetime
2016-01-01T00:40:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925270080566406
Pickup Latitude
40.755302429199219
Dropoff Longitude
-73.901939392089844
Dropoff Latitude
40.776580810546875
Passenger Count
1
Trip Distance
2.10
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-01T00:28:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:37.000
Lpep Dropoff Datetime
2016-01-01T00:36:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942337036132813
Pickup Latitude
40.790550231933594
Dropoff Longitude
-73.947349548339844
Dropoff Latitude
40.790878295898438
Passenger Count
3
Trip Distance
0.30
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-01T00:28:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:59.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:36.000
Lpep Dropoff Datetime
2016-01-01T00:52:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.934295654296875
Pickup Latitude
40.680637359619141
Dropoff Longitude
-74.009101867675781
Dropoff Latitude
40.704357147216797
Passenger Count
1
Trip Distance
6.20
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:37:27.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:32.000
Lpep Dropoff Datetime
2016-01-01T00:37:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957595825195313
Pickup Latitude
40.729682922363281
Dropoff Longitude
-73.951286315917969
Dropoff Latitude
40.712257385253906
Passenger Count
1
Trip Distance
1.60
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:13.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:18.000
Lpep Dropoff Datetime
2016-01-01T00:48:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949440002441406
Pickup Latitude
40.791065216064453
Dropoff Longitude
-73.974479675292969
Dropoff Latitude
40.725910186767578
Passenger Count
1
Trip Distance
5.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:35.000
Lpep Dropoff Datetime
2016-01-01T00:36:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992401123046875
Pickup Latitude
40.694686889648438
Dropoff Longitude
-73.967239379882813
Dropoff Latitude
40.688022613525391
Passenger Count
1
Trip Distance
1.90
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-01T00:28:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:09.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:16.000
Lpep Dropoff Datetime
2016-01-01T00:34:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956153869628906
Pickup Latitude
40.813156127929688
Dropoff Longitude
-73.940017700195313
Dropoff Latitude
40.813194274902344
Passenger Count
1
Trip Distance
1.30
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-01T00:28:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:05:36.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:10.000
Lpep Dropoff Datetime
2016-01-01T01:05:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9476318359375
Pickup Latitude
40.808650970458984
Dropoff Longitude
-73.955780029296875
Dropoff Latitude
40.684902191162109
Passenger Count
1
Trip Distance
12.40
Fare Amount
39
Extra
0.5
Mta Tax
0.5
Tip Amount
3.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
44
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:53:20.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:14.000
Lpep Dropoff Datetime
2016-01-01T00:53:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946670532226562
Pickup Latitude
40.680179595947266
Dropoff Longitude
-73.929962158203125
Dropoff Latitude
40.629100799560547
Passenger Count
1
Trip Distance
4.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:54.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:48.000
Lpep Dropoff Datetime
2016-01-01T00:33:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988853454589844
Pickup Latitude
40.670116424560547
Dropoff Longitude
-73.99822998046875
Dropoff Latitude
40.677532196044922
Passenger Count
1
Trip Distance
0.90
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:27:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:29.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:56.000
Lpep Dropoff Datetime
2016-01-01T00:39:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9365234375
Pickup Latitude
40.697738647460938
Dropoff Longitude
-73.960090637207031
Dropoff Latitude
40.715690612792969
Passenger Count
1
Trip Distance
2.10
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-01T00:27:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:03.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:56.000
Lpep Dropoff Datetime
2016-01-01T00:40:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956184387207031
Pickup Latitude
40.683433532714844
Dropoff Longitude
-73.98663330078125
Dropoff Latitude
40.67193603515625
Passenger Count
1
Trip Distance
2.50
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-01T00:27:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:23.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:58.000
Lpep Dropoff Datetime
2016-01-01T00:43:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.907440185546875
Pickup Latitude
40.770481109619141
Dropoff Longitude
-73.833114624023437
Dropoff Latitude
40.706474304199219
Passenger Count
1
Trip Distance
8.10
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
5.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:27:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:55.000
Lpep Dropoff Datetime
2016-01-01T00:43:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.880867004394531
Pickup Latitude
40.756103515625
Dropoff Longitude
-73.875267028808594
Dropoff Latitude
40.731430053710938
Passenger Count
1
Trip Distance
2.20
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-01T00:27:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:42.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:48.000
Lpep Dropoff Datetime
2016-01-01T00:57:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976982116699219
Pickup Latitude
40.683326721191406
Dropoff Longitude
-73.933937072753906
Dropoff Latitude
40.632453918457031
Passenger Count
1
Trip Distance
5.30
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:27:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:24.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:49.000
Lpep Dropoff Datetime
2016-01-01T00:40:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983848571777344
Pickup Latitude
40.679279327392578
Dropoff Longitude
-73.959182739257813
Dropoff Latitude
40.677318572998047
Passenger Count
1
Trip Distance
1.90
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:27:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:49.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:48.000
Lpep Dropoff Datetime
2016-01-01T00:35:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90277099609375
Pickup Latitude
40.868888854980469
Dropoff Longitude
-73.898429870605469
Dropoff Latitude
40.889724731445313
Passenger Count
2
Trip Distance
1.90
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-01T00:27:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:37:18.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:27:48.000
Lpep Dropoff Datetime
2016-01-01T00:37:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91619873046875
Pickup Latitude
40.769649505615234
Dropoff Longitude
-73.912925720214844
Dropoff Latitude
40.748790740966797
Passenger Count
1
Trip Distance
2.40
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.5
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:28:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:21.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:28:01.000
Lpep Dropoff Datetime
2016-01-01T00:41:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8848876953125
Pickup Latitude
40.747577667236328
Dropoff Longitude
-73.884941101074219
Dropoff Latitude
40.747589111328125
Passenger Count
1
Trip Distance
1.60
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
NYC Data AI • Public-data exploration interface