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-01T00:43:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:42.000
Lpep Dropoff Datetime
2016-01-01T00:45:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95025634765625
Pickup Latitude
40.826614379882812
Dropoff Longitude
-73.947212219238281
Dropoff Latitude
40.830726623535156
Passenger Count
1
Trip Distance
0.30
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:25.000 • Lpep Dropoff Datetime: 2016-01-01T23:06:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:25.000
Lpep Dropoff Datetime
2016-01-01T23:06:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957855224609375
Pickup Latitude
40.721923828125
Dropoff Longitude
-73.937026977539063
Dropoff Latitude
40.702011108398437
Passenger Count
1
Trip Distance
2.60
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:55.000
Lpep Dropoff Datetime
2016-01-01T00:45:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958015441894531
Pickup Latitude
40.815288543701172
Dropoff Longitude
-73.941619873046875
Dropoff Latitude
40.818344116210938
Passenger Count
1
Trip Distance
1.37
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:27.000
Lpep Dropoff Datetime
2016-01-01T00:46:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9537353515625
Pickup Latitude
40.687393188476563
Dropoff Longitude
-73.929145812988281
Dropoff Latitude
40.698783874511719
Passenger Count
1
Trip Distance
2.58
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
3.69
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.99
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:09.000
Lpep Dropoff Datetime
2016-01-01T00:45:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943817138671875
Pickup Latitude
40.683059692382813
Dropoff Longitude
-73.99371337890625
Dropoff Latitude
40.686813354492188
Passenger Count
1
Trip Distance
3.19
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-01T00:27:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:16.000
Lpep Dropoff Datetime
2016-01-01T00:45:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952560424804688
Pickup Latitude
40.723163604736328
Dropoff Longitude
-73.91265869140625
Dropoff Latitude
40.69549560546875
Passenger Count
1
Trip Distance
3.39
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
3.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:31:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:15.000
Lpep Dropoff Datetime
2016-01-01T00:31:18.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.883758544921875
Pickup Latitude
40.755805969238281
Dropoff Longitude
-73.926605224609375
Dropoff Latitude
40.757205963134766
Passenger Count
1
Trip Distance
2.72
Fare Amount
20
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
20
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:40.000
Lpep Dropoff Datetime
2016-01-01T00:45:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961235046386719
Pickup Latitude
40.714439392089844
Dropoff Longitude
-73.943504333496094
Dropoff Latitude
40.708641052246094
Passenger Count
1
Trip Distance
1.33
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:32.000
Lpep Dropoff Datetime
2016-01-01T00:46:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962608337402344
Pickup Latitude
40.672580718994141
Dropoff Longitude
-73.983810424804688
Dropoff Latitude
40.660091400146484
Passenger Count
6
Trip Distance
1.97
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
2.79
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.09
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:51.000
Lpep Dropoff Datetime
2016-01-01T00:46:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.870063781738281
Pickup Latitude
40.755268096923828
Dropoff Longitude
-73.884506225585937
Dropoff Latitude
40.734733581542969
Passenger Count
4
Trip Distance
2.94
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:11.000
Lpep Dropoff Datetime
2016-01-01T00:46:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960044860839844
Pickup Latitude
40.715629577636719
Dropoff Longitude
-73.922294616699219
Dropoff Latitude
40.707191467285156
Passenger Count
1
Trip Distance
2.56
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-01T00:39:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:41.000
Lpep Dropoff Datetime
2016-01-01T00:46:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.900657653808594
Pickup Latitude
40.862693786621094
Dropoff Longitude
-73.887680053710938
Dropoff Latitude
40.855480194091797
Passenger Count
1
Trip Distance
1.22
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:55.000
Lpep Dropoff Datetime
2016-01-01T00:46:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945281982421875
Pickup Latitude
40.800201416015625
Dropoff Longitude
-73.930717468261719
Dropoff Latitude
40.811923980712891
Passenger Count
1
Trip Distance
2.64
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
1.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:22:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:25.000
Lpep Dropoff Datetime
2016-01-01T00:44:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896148681640625
Pickup Latitude
40.74627685546875
Dropoff Longitude
-73.848617553710938
Dropoff Latitude
40.784320831298828
Passenger Count
1
Trip Distance
8.50
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:26.000
Lpep Dropoff Datetime
2016-01-01T00:45:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915298461914062
Pickup Latitude
40.760536193847656
Dropoff Longitude
-73.897903442382813
Dropoff Latitude
40.744350433349609
Passenger Count
1
Trip Distance
1.74
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
3.09
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.39
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:26:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:23.000
Lpep Dropoff Datetime
2016-01-01T00:45:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957603454589844
Pickup Latitude
40.729808807373047
Dropoff Longitude
-73.914283752441406
Dropoff Latitude
40.703144073486328
Passenger Count
1
Trip Distance
4.14
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:30.000
Lpep Dropoff Datetime
2016-01-01T00:44:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943168640136719
Pickup Latitude
40.793716430664062
Dropoff Longitude
-73.939498901367188
Dropoff Latitude
40.82098388671875
Passenger Count
1
Trip Distance
2.49
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:05.000
Lpep Dropoff Datetime
2016-01-01T00:46:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90948486328125
Pickup Latitude
40.775291442871094
Dropoff Longitude
-73.923530578613281
Dropoff Latitude
40.742637634277344
Passenger Count
1
Trip Distance
2.94
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-01T00:35:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:32.000
Lpep Dropoff Datetime
2016-01-01T00:45:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.860542297363281
Pickup Latitude
40.828086853027344
Dropoff Longitude
-73.925628662109375
Dropoff Latitude
40.824394226074219
Passenger Count
1
Trip Distance
6.31
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:31.000
Lpep Dropoff Datetime
2016-01-01T00:46:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95880126953125
Pickup Latitude
40.692634582519531
Dropoff Longitude
-73.945098876953125
Dropoff Latitude
40.678115844726563
Passenger Count
1
Trip Distance
1.54
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-01T00:35:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:31.000
Lpep Dropoff Datetime
2016-01-01T00:46:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946029663085938
Pickup Latitude
40.824943542480469
Dropoff Longitude
-73.928276062011719
Dropoff Latitude
40.854274749755859
Passenger Count
1
Trip Distance
2.42
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:44.000
Lpep Dropoff Datetime
2016-01-01T00:44:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940101623535156
Pickup Latitude
40.750320434570312
Dropoff Longitude
-73.920387268066406
Dropoff Latitude
40.7679443359375
Passenger Count
1
Trip Distance
1.77
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:08.000
Lpep Dropoff Datetime
2016-01-01T00:46:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909660339355469
Pickup Latitude
40.843841552734375
Dropoff Longitude
-73.932670593261719
Dropoff Latitude
40.856578826904297
Passenger Count
1
Trip Distance
2.16
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
3.09
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.39
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:42:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:56.000
Lpep Dropoff Datetime
2016-01-01T00:46:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903144836425781
Pickup Latitude
40.745906829833984
Dropoff Longitude
-73.901039123535156
Dropoff Latitude
40.746013641357422
Passenger Count
1
Trip Distance
0.17
Fare Amount
3
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:41:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:19.000
Lpep Dropoff Datetime
2016-01-01T00:45:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9405517578125
Pickup Latitude
40.805854797363281
Dropoff Longitude
-73.950538635253906
Dropoff Latitude
40.806003570556641
Passenger Count
1
Trip Distance
0.79
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:35.000
Lpep Dropoff Datetime
2016-01-01T00:44:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926910400390625
Pickup Latitude
40.762886047363281
Dropoff Longitude
-73.866363525390625
Dropoff Latitude
40.736560821533203
Passenger Count
1
Trip Distance
7.16
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:23:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:01.000
Lpep Dropoff Datetime
2016-01-01T00:46:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922340393066406
Pickup Latitude
40.755203247070313
Dropoff Longitude
-73.929168701171875
Dropoff Latitude
40.703762054443359
Passenger Count
1
Trip Distance
5.33
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:28.000
Lpep Dropoff Datetime
2016-01-01T00:46:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963546752929688
Pickup Latitude
40.676418304443359
Dropoff Longitude
-73.962120056152344
Dropoff Latitude
40.678997039794922
Passenger Count
1
Trip Distance
1.19
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:33.000
Lpep Dropoff Datetime
2016-01-01T00:46:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954689025878906
Pickup Latitude
40.732429504394531
Dropoff Longitude
-73.940574645996094
Dropoff Latitude
40.686653137207031
Passenger Count
1
Trip Distance
3.58
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:41:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:00.000
Lpep Dropoff Datetime
2016-01-01T00:46:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.876754760742188
Pickup Latitude
40.748477935791016
Dropoff Longitude
-73.880790710449219
Dropoff Latitude
40.761631011962891
Passenger Count
1
Trip Distance
1.05
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:23.000
Lpep Dropoff Datetime
2016-01-01T00:46:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95068359375
Pickup Latitude
40.743686676025391
Dropoff Longitude
-73.961959838867188
Dropoff Latitude
40.713523864746094
Passenger Count
1
Trip Distance
2.64
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:15:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:05.000
Lpep Dropoff Datetime
2016-01-01T00:44:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987586975097656
Pickup Latitude
40.690303802490234
Dropoff Longitude
-73.886177062988281
Dropoff Latitude
40.650047302246094
Passenger Count
1
Trip Distance
7.13
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:05.000
Lpep Dropoff Datetime
2016-01-01T00:46:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9627685546875
Pickup Latitude
40.672916412353516
Dropoff Longitude
-73.956039428710937
Dropoff Latitude
40.719352722167969
Passenger Count
2
Trip Distance
4.09
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:22.000
Lpep Dropoff Datetime
2016-01-01T00:46:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914779663085938
Pickup Latitude
40.769607543945313
Dropoff Longitude
-73.91253662109375
Dropoff Latitude
40.782428741455078
Passenger Count
1
Trip Distance
1.58
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:27.000
Lpep Dropoff Datetime
2016-01-01T00:45:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922576904296875
Pickup Latitude
40.743503570556641
Dropoff Longitude
-73.883003234863281
Dropoff Latitude
40.755756378173828
Passenger Count
1
Trip Distance
2.57
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:08.000 • Lpep Dropoff Datetime: 2016-01-02T00:27:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:08.000
Lpep Dropoff Datetime
2016-01-02T00:27:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95501708984375
Pickup Latitude
40.722366333007813
Dropoff Longitude
-73.944961547851562
Dropoff Latitude
40.700370788574219
Passenger Count
1
Trip Distance
2.05
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
2.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:28.000
Lpep Dropoff Datetime
2016-01-01T00:45:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954345703125
Pickup Latitude
40.805652618408203
Dropoff Longitude
-73.967987060546875
Dropoff Latitude
40.791988372802734
Passenger Count
5
Trip Distance
1.50
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:04.000
Lpep Dropoff Datetime
2016-01-01T00:45:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936599731445313
Pickup Latitude
40.820564270019531
Dropoff Longitude
-73.926704406738281
Dropoff Latitude
40.818370819091797
Passenger Count
1
Trip Distance
0.54
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:40:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:05.000
Lpep Dropoff Datetime
2016-01-01T00:46:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939498901367188
Pickup Latitude
40.705726623535156
Dropoff Longitude
-73.938438415527344
Dropoff Latitude
40.721584320068359
Passenger Count
1
Trip Distance
1.25
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:42:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:58.000
Lpep Dropoff Datetime
2016-01-01T00:46:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.867446899414063
Pickup Latitude
40.741863250732422
Dropoff Longitude
-73.869941711425781
Dropoff Latitude
40.748519897460938
Passenger Count
1
Trip Distance
0.47
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:01.000
Lpep Dropoff Datetime
2016-01-01T00:45:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945060729980469
Pickup Latitude
40.752353668212891
Dropoff Longitude
-73.920326232910156
Dropoff Latitude
40.745155334472656
Passenger Count
1
Trip Distance
1.47
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:09.000
Lpep Dropoff Datetime
2016-01-01T00:45:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919769287109375
Pickup Latitude
40.737766265869141
Dropoff Longitude
-73.921951293945313
Dropoff Latitude
40.767692565917969
Passenger Count
1
Trip Distance
2.80
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:09.000
Lpep Dropoff Datetime
2016-01-01T00:46:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882545471191406
Pickup Latitude
40.755722045898437
Dropoff Longitude
-73.87384033203125
Dropoff Latitude
40.756736755371094
Passenger Count
5
Trip Distance
0.47
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:42:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:17.000
Lpep Dropoff Datetime
2016-01-01T00:46:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891159057617188
Pickup Latitude
40.747051239013672
Dropoff Longitude
-73.884498596191406
Dropoff Latitude
40.747539520263672
Passenger Count
1
Trip Distance
0.35
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:13.000
Lpep Dropoff Datetime
2016-01-01T00:45:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902320861816406
Pickup Latitude
40.845176696777344
Dropoff Longitude
-73.862899780273438
Dropoff Latitude
40.874668121337891
Passenger Count
1
Trip Distance
3.54
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:53.000
Lpep Dropoff Datetime
2016-01-01T00:46:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946495056152344
Pickup Latitude
40.797618865966797
Dropoff Longitude
-73.94879150390625
Dropoff Latitude
40.813453674316406
Passenger Count
1
Trip Distance
1.98
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:17.000
Lpep Dropoff Datetime
2016-01-01T00:45:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.853973388671875
Pickup Latitude
40.741237640380859
Dropoff Longitude
-73.842620849609375
Dropoff Latitude
40.689632415771484
Passenger Count
1
Trip Distance
1.54
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:46.000
Lpep Dropoff Datetime
2016-01-01T00:46:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917800903320312
Pickup Latitude
40.704620361328125
Dropoff Longitude
-73.945823669433594
Dropoff Latitude
40.727108001708984
Passenger Count
1
Trip Distance
2.82
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:32.000
Lpep Dropoff Datetime
2016-01-01T00:46:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956832885742188
Pickup Latitude
40.663524627685547
Dropoff Longitude
-73.9398193359375
Dropoff Latitude
40.660362243652344
Passenger Count
1
Trip Distance
1.14
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:22.000
Lpep Dropoff Datetime
2016-01-01T00:45:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986953735351563
Pickup Latitude
40.660610198974609
Dropoff Longitude
-73.98455810546875
Dropoff Latitude
40.663200378417969
Passenger Count
3
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
NYC Data AI • Public-data exploration interface