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:25:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:53.000
Lpep Dropoff Datetime
2016-01-01T01:07:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890899658203125
Pickup Latitude
40.749198913574219
Dropoff Longitude
-73.965492248535156
Dropoff Latitude
40.771671295166016
Passenger Count
3
Trip Distance
7.67
Fare Amount
31
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:05.000
Lpep Dropoff Datetime
2016-01-01T01:08:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955520629882813
Pickup Latitude
40.744415283203125
Dropoff Longitude
-73.924797058105469
Dropoff Latitude
40.765022277832031
Passenger Count
2
Trip Distance
3.05
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:42:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:42.000
Lpep Dropoff Datetime
2016-01-01T01:08:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.89532470703125
Pickup Latitude
40.670017242431641
Dropoff Longitude
-73.937347412109375
Dropoff Latitude
40.804561614990234
Passenger Count
1
Trip Distance
16.47
Fare Amount
45
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
51.84
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:28.000
Lpep Dropoff Datetime
2016-01-01T01:07:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94232177734375
Pickup Latitude
40.700706481933594
Dropoff Longitude
-73.952369689941406
Dropoff Latitude
40.671775817871094
Passenger Count
1
Trip Distance
2.62
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-01T00:52:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:25.000
Lpep Dropoff Datetime
2016-01-01T01:08:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925384521484375
Pickup Latitude
40.69818115234375
Dropoff Longitude
-73.984161376953125
Dropoff Latitude
40.691337585449219
Passenger Count
1
Trip Distance
3.41
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-01T00:47:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:21.000
Lpep Dropoff Datetime
2016-01-01T01:08:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.865737915039063
Pickup Latitude
40.757720947265625
Dropoff Longitude
-73.879425048828125
Dropoff Latitude
40.829265594482422
Passenger Count
3
Trip Distance
8.96
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
34.34
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:36.000
Lpep Dropoff Datetime
2016-01-01T01:07:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926261901855469
Pickup Latitude
40.69818115234375
Dropoff Longitude
-73.963996887207031
Dropoff Latitude
40.693706512451172
Passenger Count
1
Trip Distance
2.00
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:46.000
Lpep Dropoff Datetime
2016-01-01T01:07:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.934913635253906
Pickup Latitude
40.697090148925781
Dropoff Longitude
-73.993247985839844
Dropoff Latitude
40.756301879882813
Passenger Count
1
Trip Distance
7.25
Fare Amount
30.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:52.000
Lpep Dropoff Datetime
2016-01-01T01:07:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954719543457031
Pickup Latitude
40.718673706054687
Dropoff Longitude
-73.964469909667969
Dropoff Latitude
40.686965942382813
Passenger Count
1
Trip Distance
2.49
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:44:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:30.000
Lpep Dropoff Datetime
2016-01-01T01:08:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.889411926269531
Pickup Latitude
40.747184753417969
Dropoff Longitude
-73.773338317871094
Dropoff Latitude
40.711818695068359
Passenger Count
2
Trip Distance
11.25
Fare Amount
33
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:54:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:01.000
Lpep Dropoff Datetime
2016-01-01T01:07:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936676025390625
Pickup Latitude
40.679725646972656
Dropoff Longitude
-73.957122802734375
Dropoff Latitude
40.696762084960938
Passenger Count
5
Trip Distance
2.07
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-01T00:45:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:35.000
Lpep Dropoff Datetime
2016-01-01T01:08:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96600341796875
Pickup Latitude
40.713691711425781
Dropoff Longitude
-73.975059509277344
Dropoff Latitude
40.675041198730469
Passenger Count
5
Trip Distance
6.76
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
4.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:23.000
Lpep Dropoff Datetime
2016-01-01T01:08:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970077514648438
Pickup Latitude
40.67462158203125
Dropoff Longitude
-73.978492736816406
Dropoff Latitude
40.725471496582031
Passenger Count
1
Trip Distance
5.14
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
7.14
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.94
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:02.000
Lpep Dropoff Datetime
2016-01-01T01:08:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95867919921875
Pickup Latitude
40.650611877441406
Dropoff Longitude
-73.975181579589844
Dropoff Latitude
40.647308349609375
Passenger Count
1
Trip Distance
2.13
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:59:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:14.000
Lpep Dropoff Datetime
2016-01-01T01:07:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.929450988769531
Pickup Latitude
40.69378662109375
Dropoff Longitude
-73.922500610351563
Dropoff Latitude
40.681350708007813
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:56:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:35.000
Lpep Dropoff Datetime
2016-01-01T01:08:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.878372192382813
Pickup Latitude
40.842403411865234
Dropoff Longitude
-73.905319213867188
Dropoff Latitude
40.815643310546875
Passenger Count
1
Trip Distance
2.38
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:57:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:12.000
Lpep Dropoff Datetime
2016-01-01T01:08:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966049194335937
Pickup Latitude
40.689685821533203
Dropoff Longitude
-73.988845825195313
Dropoff Latitude
40.722110748291016
Passenger Count
1
Trip Distance
3.40
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:56:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:46.000
Lpep Dropoff Datetime
2016-01-01T01:08:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.861763000488281
Pickup Latitude
40.730182647705078
Dropoff Longitude
-73.815399169921875
Dropoff Latitude
40.763664245605469
Passenger Count
1
Trip Distance
4.63
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-01T00:52:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:24.000
Lpep Dropoff Datetime
2016-01-01T01:08:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915985107421875
Pickup Latitude
40.746406555175781
Dropoff Longitude
-73.95550537109375
Dropoff Latitude
40.720146179199219
Passenger Count
3
Trip Distance
4.12
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:41:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:26.000
Lpep Dropoff Datetime
2016-01-01T01:08:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940055847167969
Pickup Latitude
40.750293731689453
Dropoff Longitude
-73.846122741699219
Dropoff Latitude
40.696739196777344
Passenger Count
1
Trip Distance
8.94
Fare Amount
28.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:54.000
Lpep Dropoff Datetime
2016-01-01T01:08:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942344665527344
Pickup Latitude
40.754055023193359
Dropoff Longitude
-73.911491394042969
Dropoff Latitude
40.768215179443359
Passenger Count
1
Trip Distance
2.36
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:58:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:53.000
Lpep Dropoff Datetime
2016-01-01T01:08:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9241943359375
Pickup Latitude
40.744125366210937
Dropoff Longitude
-73.908851623535156
Dropoff Latitude
40.725910186767578
Passenger Count
1
Trip Distance
2.31
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:59:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:36.000
Lpep Dropoff Datetime
2016-01-01T01:08:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.868583679199219
Pickup Latitude
40.747402191162109
Dropoff Longitude
-73.863922119140625
Dropoff Latitude
40.741825103759766
Passenger Count
3
Trip Distance
1.88
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-01T00:50:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:45.000
Lpep Dropoff Datetime
2016-01-01T01:08:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986808776855469
Pickup Latitude
40.697711944580078
Dropoff Longitude
-73.980255126953125
Dropoff Latitude
40.746395111083984
Passenger Count
1
Trip Distance
4.24
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:42.000
Lpep Dropoff Datetime
2016-01-01T01:08:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939773559570313
Pickup Latitude
40.835926055908203
Dropoff Longitude
-73.873329162597656
Dropoff Latitude
40.896003723144531
Passenger Count
1
Trip Distance
7.11
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:22.000
Lpep Dropoff Datetime
2016-01-01T01:08:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.873405456542969
Pickup Latitude
40.734634399414063
Dropoff Longitude
-73.918693542480469
Dropoff Latitude
40.699047088623047
Passenger Count
1
Trip Distance
6.41
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:56:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:45.000
Lpep Dropoff Datetime
2016-01-01T01:08:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.852401733398438
Pickup Latitude
40.726261138916016
Dropoff Longitude
-73.896835327148438
Dropoff Latitude
40.748874664306641
Passenger Count
2
Trip Distance
7.18
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:24.000
Lpep Dropoff Datetime
2016-01-01T01:07:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962104797363281
Pickup Latitude
40.668724060058594
Dropoff Longitude
-73.993133544921875
Dropoff Latitude
40.68536376953125
Passenger Count
1
Trip Distance
2.38
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:58:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:49.000
Lpep Dropoff Datetime
2016-01-01T01:08:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807907104492188
Pickup Latitude
40.700485229492187
Dropoff Longitude
-73.797149658203125
Dropoff Latitude
40.714599609375
Passenger Count
1
Trip Distance
1.64
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:57:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:23.000
Lpep Dropoff Datetime
2016-01-01T01:08:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.901443481445313
Pickup Latitude
40.862766265869141
Dropoff Longitude
-73.913505554199219
Dropoff Latitude
40.839237213134766
Passenger Count
1
Trip Distance
2.01
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:52:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:17.000
Lpep Dropoff Datetime
2016-01-01T01:07:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924598693847656
Pickup Latitude
40.756118774414063
Dropoff Longitude
-73.944480895996094
Dropoff Latitude
40.714817047119141
Passenger Count
1
Trip Distance
3.79
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:36:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:59.000
Lpep Dropoff Datetime
2016-01-01T01:07:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.864555358886719
Pickup Latitude
40.834709167480469
Dropoff Longitude
-73.990005493164062
Dropoff Latitude
40.731990814208984
Passenger Count
1
Trip Distance
12.57
Fare Amount
38
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
39.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:44.000
Lpep Dropoff Datetime
2016-01-01T01:08:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.884002685546875
Pickup Latitude
40.755771636962891
Dropoff Longitude
-73.871368408203125
Dropoff Latitude
40.744243621826172
Passenger Count
1
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-01T00:51:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:50.000
Lpep Dropoff Datetime
2016-01-01T01:09:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952865600585938
Pickup Latitude
40.678421020507812
Dropoff Longitude
-73.9571533203125
Dropoff Latitude
40.734928131103516
Passenger Count
2
Trip Distance
4.48
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
2.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:44.000
Lpep Dropoff Datetime
2016-01-01T01:08:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.967781066894531
Pickup Latitude
40.710811614990234
Dropoff Longitude
-73.986251831054687
Dropoff Latitude
40.727226257324219
Passenger Count
1
Trip Distance
3.01
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:09.000
Lpep Dropoff Datetime
2016-01-01T01:08:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923042297363281
Pickup Latitude
40.74346923828125
Dropoff Longitude
-73.8828125
Dropoff Latitude
40.747726440429688
Passenger Count
2
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:56:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:54.000
Lpep Dropoff Datetime
2016-01-01T01:09:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960563659667969
Pickup Latitude
40.719673156738281
Dropoff Longitude
-73.987846374511719
Dropoff Latitude
40.718540191650391
Passenger Count
1
Trip Distance
2.42
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
3.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:59.000
Lpep Dropoff Datetime
2016-01-01T01:09:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958717346191406
Pickup Latitude
40.809993743896484
Dropoff Longitude
-73.915931701660156
Dropoff Latitude
40.831985473632813
Passenger Count
1
Trip Distance
3.41
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-01T00:49:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:29.000
Lpep Dropoff Datetime
2016-01-01T01:08:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.867073059082031
Pickup Latitude
40.752590179443359
Dropoff Longitude
-73.920692443847656
Dropoff Latitude
40.76751708984375
Passenger Count
1
Trip Distance
4.56
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:59.000
Lpep Dropoff Datetime
2016-01-01T01:07:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.973297119140625
Pickup Latitude
40.693336486816406
Dropoff Longitude
-73.890975952148437
Dropoff Latitude
40.664268493652344
Passenger Count
1
Trip Distance
5.84
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:33:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:03.000
Lpep Dropoff Datetime
2016-01-01T01:09:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922218322753906
Pickup Latitude
40.679771423339844
Dropoff Longitude
-74.004280090332031
Dropoff Latitude
40.719566345214844
Passenger Count
1
Trip Distance
6.12
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
5.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:16.000
Lpep Dropoff Datetime
2016-01-01T01:08:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909210205078125
Pickup Latitude
40.775138854980469
Dropoff Longitude
-73.917167663574219
Dropoff Latitude
40.758079528808594
Passenger Count
1
Trip Distance
1.86
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:57.000
Lpep Dropoff Datetime
2016-01-01T01:09:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986701965332031
Pickup Latitude
40.702033996582031
Dropoff Longitude
-73.914337158203125
Dropoff Latitude
40.760639190673828
Passenger Count
1
Trip Distance
8.85
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:30.000
Lpep Dropoff Datetime
2016-01-01T01:07:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949752807617188
Pickup Latitude
40.785648345947266
Dropoff Longitude
-73.958930969238281
Dropoff Latitude
40.761795043945313
Passenger Count
1
Trip Distance
2.27
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:56:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:32.000
Lpep Dropoff Datetime
2016-01-01T01:08:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941986083984375
Pickup Latitude
40.78704833984375
Dropoff Longitude
-73.925315856933594
Dropoff Latitude
40.862457275390625
Passenger Count
2
Trip Distance
5.74
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:05.000
Lpep Dropoff Datetime
2016-01-01T01:09:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921585083007813
Pickup Latitude
40.7666015625
Dropoff Longitude
-73.966995239257813
Dropoff Latitude
40.756893157958984
Passenger Count
1
Trip Distance
3.42
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:19.000
Lpep Dropoff Datetime
2016-01-01T01:08:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994300842285156
Pickup Latitude
40.663883209228516
Dropoff Longitude
-74.022903442382812
Dropoff Latitude
40.622264862060547
Passenger Count
1
Trip Distance
3.80
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:47.000
Lpep Dropoff Datetime
2016-01-01T01:09:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.928367614746094
Pickup Latitude
40.697502136230469
Dropoff Longitude
-73.965972900390625
Dropoff Latitude
40.689743041992188
Passenger Count
1
Trip Distance
2.20
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:54.000
Lpep Dropoff Datetime
2016-01-01T01:09:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946456909179688
Pickup Latitude
40.673210144042969
Dropoff Longitude
-73.964393615722656
Dropoff Latitude
40.686412811279297
Passenger Count
1
Trip Distance
2.27
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:48.000
Lpep Dropoff Datetime
2016-01-01T01:08:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918792724609375
Pickup Latitude
40.765712738037109
Dropoff Longitude
-74.013420104980469
Dropoff Latitude
40.627822875976562
Passenger Count
1
Trip Distance
16.15
Fare Amount
44.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
45.8
Payment Type
2
Trip Type
1
NYC Data AI • Public-data exploration interface