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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:48:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:14.000
Lpep Dropoff Datetime
2016-01-01T01:56:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94549560546875
Pickup Latitude
40.790348052978516
Dropoff Longitude
-73.935630798339844
Dropoff Latitude
40.809295654296875
Passenger Count
1
Trip Distance
1.58
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:52.000
Lpep Dropoff Datetime
2016-01-01T01:56:05.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.945602416992188
Pickup Latitude
40.801219940185547
Dropoff Longitude
-73.945594787597656
Dropoff Latitude
40.801242828369141
Passenger Count
1
Trip Distance
0.00
Fare Amount
20
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
20
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:41.000
Lpep Dropoff Datetime
2016-01-01T01:56:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948814392089844
Pickup Latitude
40.710693359375
Dropoff Longitude
-73.964118957519531
Dropoff Latitude
40.673900604248047
Passenger Count
1
Trip Distance
3.61
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:17.000
Lpep Dropoff Datetime
2016-01-01T01:55:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922065734863281
Pickup Latitude
40.708515167236328
Dropoff Longitude
-73.956062316894531
Dropoff Latitude
40.735786437988281
Passenger Count
1
Trip Distance
3.25
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:23.000
Lpep Dropoff Datetime
2016-01-01T01:55:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937126159667969
Pickup Latitude
40.693000793457031
Dropoff Longitude
-73.918830871582031
Dropoff Latitude
40.670818328857422
Passenger Count
2
Trip Distance
2.78
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-01T01:50:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:35.000
Lpep Dropoff Datetime
2016-01-01T01:56:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978736877441406
Pickup Latitude
40.6624755859375
Dropoff Longitude
-73.961235046386719
Dropoff Latitude
40.671726226806641
Passenger Count
1
Trip Distance
1.66
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
2.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:38:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:52.000
Lpep Dropoff Datetime
2016-01-01T01:55:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950950622558594
Pickup Latitude
40.680496215820313
Dropoff Longitude
-73.911514282226562
Dropoff Latitude
40.701595306396484
Passenger Count
1
Trip Distance
3.23
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:40:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:45.000
Lpep Dropoff Datetime
2016-01-01T01:55:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953720092773438
Pickup Latitude
40.691951751708984
Dropoff Longitude
-73.948127746582031
Dropoff Latitude
40.72662353515625
Passenger Count
1
Trip Distance
3.04
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:36.000
Lpep Dropoff Datetime
2016-01-01T01:56:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990531921386719
Pickup Latitude
40.691421508789063
Dropoff Longitude
-74.006942749023437
Dropoff Latitude
40.676372528076172
Passenger Count
1
Trip Distance
1.74
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-01T01:44:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:54:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:50.000
Lpep Dropoff Datetime
2016-01-01T01:54:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978309631347656
Pickup Latitude
40.684532165527344
Dropoff Longitude
-73.997650146484375
Dropoff Latitude
40.663673400878906
Passenger Count
3
Trip Distance
1.93
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-01T01:37:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:12.000
Lpep Dropoff Datetime
2016-01-01T01:55:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986289978027344
Pickup Latitude
40.692436218261719
Dropoff Longitude
-73.957511901855469
Dropoff Latitude
40.743488311767578
Passenger Count
1
Trip Distance
5.82
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:37:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:38.000
Lpep Dropoff Datetime
2016-01-01T01:55:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956764221191406
Pickup Latitude
40.674060821533203
Dropoff Longitude
-74.003730773925781
Dropoff Latitude
40.642036437988281
Passenger Count
6
Trip Distance
4.17
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-01T01:51:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:37.000
Lpep Dropoff Datetime
2016-01-01T01:55:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919181823730469
Pickup Latitude
40.758998870849609
Dropoff Longitude
-73.920066833496094
Dropoff Latitude
40.765865325927734
Passenger Count
1
Trip Distance
0.58
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-01T01:40:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:04.000
Lpep Dropoff Datetime
2016-01-01T01:55:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952522277832031
Pickup Latitude
40.802986145019531
Dropoff Longitude
-73.941673278808594
Dropoff Latitude
40.838329315185547
Passenger Count
1
Trip Distance
2.94
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:33:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:36:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:38.000
Lpep Dropoff Datetime
2016-01-01T01:36:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.874656677246094
Pickup Latitude
40.879302978515625
Dropoff Longitude
-73.881484985351563
Dropoff Latitude
40.882575988769531
Passenger Count
1
Trip Distance
0.45
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-01T01:45:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:50.000
Lpep Dropoff Datetime
2016-01-01T01:56:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909324645996094
Pickup Latitude
40.81610107421875
Dropoff Longitude
-73.916374206542969
Dropoff Latitude
40.834041595458984
Passenger Count
1
Trip Distance
1.66
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:48:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:20.000
Lpep Dropoff Datetime
2016-01-01T01:56:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970932006835938
Pickup Latitude
40.689563751220703
Dropoff Longitude
-73.97930908203125
Dropoff Latitude
40.661708831787109
Passenger Count
1
Trip Distance
2.15
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-01T01:43:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:47.000
Lpep Dropoff Datetime
2016-01-01T01:55:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919105529785156
Pickup Latitude
40.741359710693359
Dropoff Longitude
-73.954544067382813
Dropoff Latitude
40.764251708984375
Passenger Count
1
Trip Distance
3.66
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:13.000
Lpep Dropoff Datetime
2016-01-01T01:56:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925216674804687
Pickup Latitude
40.761817932128906
Dropoff Longitude
-73.857398986816406
Dropoff Latitude
40.735271453857422
Passenger Count
1
Trip Distance
6.86
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
4.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:16.000
Lpep Dropoff Datetime
2016-01-01T01:55:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903419494628906
Pickup Latitude
40.745746612548828
Dropoff Longitude
-73.899742126464844
Dropoff Latitude
40.723808288574219
Passenger Count
1
Trip Distance
2.34
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-01T01:24:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:24:52.000
Lpep Dropoff Datetime
2016-01-01T01:55:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927383422851563
Pickup Latitude
40.697860717773438
Dropoff Longitude
-74.026077270507813
Dropoff Latitude
40.621360778808594
Passenger Count
1
Trip Distance
11.19
Fare Amount
34
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:48:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:23.000
Lpep Dropoff Datetime
2016-01-01T01:56:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.857109069824219
Pickup Latitude
40.727195739746094
Dropoff Longitude
-73.81488037109375
Dropoff Latitude
40.733695983886719
Passenger Count
1
Trip Distance
3.87
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:23.000
Lpep Dropoff Datetime
2016-01-01T01:55:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.898536682128906
Pickup Latitude
40.840213775634766
Dropoff Longitude
-73.8458251953125
Dropoff Latitude
40.885879516601562
Passenger Count
1
Trip Distance
8.43
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:30:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:30.000
Lpep Dropoff Datetime
2016-01-01T01:55:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.879829406738281
Pickup Latitude
40.741039276123047
Dropoff Longitude
-73.866523742675781
Dropoff Latitude
40.685306549072266
Passenger Count
1
Trip Distance
8.03
Fare Amount
26
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:20.000
Lpep Dropoff Datetime
2016-01-01T01:56:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.99383544921875
Pickup Latitude
40.681610107421875
Dropoff Longitude
-73.971084594726562
Dropoff Latitude
40.677158355712891
Passenger Count
1
Trip Distance
2.08
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-01T01:51:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:02.000
Lpep Dropoff Datetime
2016-01-01T01:56:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914817810058594
Pickup Latitude
40.764102935791016
Dropoff Longitude
-73.917335510253906
Dropoff Latitude
40.773277282714844
Passenger Count
6
Trip Distance
1.03
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:30:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:22.000
Lpep Dropoff Datetime
2016-01-01T01:55:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927818298339844
Pickup Latitude
40.701568603515625
Dropoff Longitude
-73.947349548339844
Dropoff Latitude
40.765220642089844
Passenger Count
1
Trip Distance
6.31
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
6.99
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.29
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:54.000
Lpep Dropoff Datetime
2016-01-01T01:56:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940750122070313
Pickup Latitude
40.751472473144531
Dropoff Longitude
-73.958663940429688
Dropoff Latitude
40.743419647216797
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:43:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:11.000
Lpep Dropoff Datetime
2016-01-01T01:55:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.889381408691406
Pickup Latitude
40.747028350830078
Dropoff Longitude
-73.87152099609375
Dropoff Latitude
40.768226623535156
Passenger Count
1
Trip Distance
2.47
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-01T01:39:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:45.000
Lpep Dropoff Datetime
2016-01-01T01:56:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950042724609375
Pickup Latitude
40.714065551757813
Dropoff Longitude
-73.949676513671875
Dropoff Latitude
40.678291320800781
Passenger Count
1
Trip Distance
3.02
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-01T01:38:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:02.000
Lpep Dropoff Datetime
2016-01-01T01:56:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986862182617188
Pickup Latitude
40.678909301757813
Dropoff Longitude
-73.960548400878906
Dropoff Latitude
40.717704772949219
Passenger Count
5
Trip Distance
4.66
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
3.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:47:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:38.000
Lpep Dropoff Datetime
2016-01-01T01:56:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922500610351563
Pickup Latitude
40.867225646972656
Dropoff Longitude
-73.905303955078125
Dropoff Latitude
40.856494903564453
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-01T01:34:39.000 • Lpep Dropoff Datetime: 2016-01-02T01:33:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:39.000
Lpep Dropoff Datetime
2016-01-02T01:33:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976478576660156
Pickup Latitude
40.68255615234375
Dropoff Longitude
-74.037689208984375
Dropoff Latitude
40.615425109863281
Passenger Count
1
Trip Distance
7.60
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:47:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:31.000
Lpep Dropoff Datetime
2016-01-01T01:56:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93841552734375
Pickup Latitude
40.822765350341797
Dropoff Longitude
-73.926261901855469
Dropoff Latitude
40.808032989501953
Passenger Count
5
Trip Distance
1.73
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-01T01:43:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:37.000
Lpep Dropoff Datetime
2016-01-01T01:56:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.973846435546875
Pickup Latitude
40.614101409912109
Dropoff Longitude
-73.974983215332031
Dropoff Latitude
40.575176239013672
Passenger Count
1
Trip Distance
2.97
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:39:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:37.000
Lpep Dropoff Datetime
2016-01-01T01:56:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978126525878906
Pickup Latitude
40.685207366943359
Dropoff Longitude
-73.924003601074219
Dropoff Latitude
40.686305999755859
Passenger Count
2
Trip Distance
3.31
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:34:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:54:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:52.000
Lpep Dropoff Datetime
2016-01-01T01:54:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990547180175781
Pickup Latitude
40.703742980957031
Dropoff Longitude
-73.983619689941406
Dropoff Latitude
40.672462463378906
Passenger Count
1
Trip Distance
2.94
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-01T01:50:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:39.000
Lpep Dropoff Datetime
2016-01-01T01:56:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91876220703125
Pickup Latitude
40.698600769042969
Dropoff Longitude
-73.899642944335938
Dropoff Latitude
40.697998046875
Passenger Count
1
Trip Distance
1.08
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-01T01:49:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:49:49.000
Lpep Dropoff Datetime
2016-01-01T01:56:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903488159179687
Pickup Latitude
40.745418548583984
Dropoff Longitude
-73.895858764648437
Dropoff Latitude
40.732662200927734
Passenger Count
1
Trip Distance
1.41
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-01T01:33:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:13.000
Lpep Dropoff Datetime
2016-01-01T01:56:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954727172851563
Pickup Latitude
40.732799530029297
Dropoff Longitude
-73.991554260253906
Dropoff Latitude
40.719753265380859
Passenger Count
1
Trip Distance
3.73
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:02.000
Lpep Dropoff Datetime
2016-01-01T01:55:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926025390625
Pickup Latitude
40.8387451171875
Dropoff Longitude
-73.900581359863281
Dropoff Latitude
40.853622436523438
Passenger Count
1
Trip Distance
2.34
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-01T01:32:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:32:14.000
Lpep Dropoff Datetime
2016-01-01T01:55:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994422912597656
Pickup Latitude
40.694660186767578
Dropoff Longitude
-74.006149291992188
Dropoff Latitude
40.742191314697266
Passenger Count
5
Trip Distance
4.76
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-01T01:56:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:40.000
Lpep Dropoff Datetime
2016-01-01T01:56:42.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.906883239746094
Pickup Latitude
40.697296142578125
Dropoff Longitude
-73.906913757324219
Dropoff Latitude
40.697311401367188
Passenger Count
1
Trip Distance
0.00
Fare Amount
10
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
10
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:33:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:50.000
Lpep Dropoff Datetime
2016-01-01T01:56:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943519592285156
Pickup Latitude
40.696197509765625
Dropoff Longitude
-74.025703430175781
Dropoff Latitude
40.626743316650391
Passenger Count
1
Trip Distance
10.73
Fare Amount
31.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:56:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:32.000
Lpep Dropoff Datetime
2016-01-01T01:56:46.000
Store And Fwd Flag
N
Ratecodeid
2
Pickup Longitude
-73.953865051269531
Pickup Latitude
40.806331634521484
Dropoff Longitude
-73.953849792480469
Dropoff Latitude
40.806327819824219
Passenger Count
1
Trip Distance
0.00
Fare Amount
52
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
52.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:38:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:44.000
Lpep Dropoff Datetime
2016-01-01T01:56:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92120361328125
Pickup Latitude
40.766654968261719
Dropoff Longitude
-73.878395080566406
Dropoff Latitude
40.748603820800781
Passenger Count
1
Trip Distance
3.65
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-01T01:39:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:59.000
Lpep Dropoff Datetime
2016-01-01T01:55:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.895118713378906
Pickup Latitude
40.698654174804688
Dropoff Longitude
-73.858627319335938
Dropoff Latitude
40.693836212158203
Passenger Count
1
Trip Distance
3.11
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:06:08.000 • Lpep Dropoff Datetime: 2016-01-01T01:54:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:06:08.000
Lpep Dropoff Datetime
2016-01-01T01:54:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920478820800781
Pickup Latitude
40.703014373779297
Dropoff Longitude
-74.007911682128906
Dropoff Latitude
40.604988098144531
Passenger Count
1
Trip Distance
11.22
Fare Amount
40
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
41.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:47:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:40.000
Lpep Dropoff Datetime
2016-01-01T01:56:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935615539550781
Pickup Latitude
40.682685852050781
Dropoff Longitude
-73.954566955566406
Dropoff Latitude
40.691051483154297
Passenger Count
1
Trip Distance
1.70
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:47:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:46.000
Lpep Dropoff Datetime
2016-01-01T01:56:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.892326354980469
Pickup Latitude
40.727680206298828
Dropoff Longitude
-73.888572692871094
Dropoff Latitude
40.745521545410156
Passenger Count
1
Trip Distance
1.95
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
NYC Data AI • Public-data exploration interface