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:38:57.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:57.000
Lpep Dropoff Datetime
2016-01-01T00:47:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945175170898437
Pickup Latitude
40.746051788330078
Dropoff Longitude
-73.957962036132813
Dropoff Latitude
40.721717834472656
Passenger Count
1
Trip Distance
2.12
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:41:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:39.000
Lpep Dropoff Datetime
2016-01-01T00:46:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937568664550781
Pickup Latitude
40.804080963134766
Dropoff Longitude
-73.933082580566406
Dropoff Latitude
40.795223236083984
Passenger Count
1
Trip Distance
1.05
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:53.000
Lpep Dropoff Datetime
2016-01-01T00:47:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914451599121094
Pickup Latitude
40.763671875
Dropoff Longitude
-73.938705444335938
Dropoff Latitude
40.805011749267578
Passenger Count
1
Trip Distance
4.09
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
5.21
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
26.05
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:06.000
Lpep Dropoff Datetime
2016-01-01T00:47:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987838745117188
Pickup Latitude
40.679256439208984
Dropoff Longitude
-73.955474853515625
Dropoff Latitude
40.719291687011719
Passenger Count
1
Trip Distance
4.49
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:49.000 • Lpep Dropoff Datetime: 2016-01-02T00:19:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:49.000
Lpep Dropoff Datetime
2016-01-02T00:19:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969764709472656
Pickup Latitude
40.712673187255859
Dropoff Longitude
-73.983078002929688
Dropoff Latitude
40.695018768310547
Passenger Count
1
Trip Distance
5.05
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:06.000
Lpep Dropoff Datetime
2016-01-01T00:47:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950103759765625
Pickup Latitude
40.699634552001953
Dropoff Longitude
-73.924705505371094
Dropoff Latitude
40.693145751953125
Passenger Count
1
Trip Distance
1.53
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:27:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:16.000
Lpep Dropoff Datetime
2016-01-01T00:47:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960968017578125
Pickup Latitude
40.715576171875
Dropoff Longitude
-74.000572204589844
Dropoff Latitude
40.742996215820313
Passenger Count
5
Trip Distance
4.57
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:02.000
Lpep Dropoff Datetime
2016-01-01T00:47:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940757751464844
Pickup Latitude
40.799888610839844
Dropoff Longitude
-73.942909240722656
Dropoff Latitude
40.754276275634766
Passenger Count
1
Trip Distance
6.44
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:21.000
Lpep Dropoff Datetime
2016-01-01T00:46:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958450317382813
Pickup Latitude
40.719146728515625
Dropoff Longitude
-73.949783325195313
Dropoff Latitude
40.801803588867188
Passenger Count
1
Trip Distance
10.32
Fare Amount
32
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:18.000
Lpep Dropoff Datetime
2016-01-01T00:47:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968498229980469
Pickup Latitude
40.675033569335938
Dropoff Longitude
-73.984306335449219
Dropoff Latitude
40.644275665283203
Passenger Count
1
Trip Distance
2.88
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:18.000
Lpep Dropoff Datetime
2016-01-01T00:47:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962539672851562
Pickup Latitude
40.709999084472656
Dropoff Longitude
-73.958358764648438
Dropoff Latitude
40.710479736328125
Passenger Count
2
Trip Distance
0.31
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:54.000
Lpep Dropoff Datetime
2016-01-01T00:47:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.898872375488281
Pickup Latitude
40.858821868896484
Dropoff Longitude
-73.902671813964844
Dropoff Latitude
40.883750915527344
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-01T00:37:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:32.000
Lpep Dropoff Datetime
2016-01-01T00:47:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950355529785156
Pickup Latitude
40.785205841064453
Dropoff Longitude
-73.960533142089844
Dropoff Latitude
40.763957977294922
Passenger Count
2
Trip Distance
1.94
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5
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-01T00:39:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:49.000
Lpep Dropoff Datetime
2016-01-01T00:47:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935783386230469
Pickup Latitude
40.795547485351563
Dropoff Longitude
-73.930122375488281
Dropoff Latitude
40.833145141601563
Passenger Count
1
Trip Distance
3.06
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:37:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:29.000
Lpep Dropoff Datetime
2016-01-01T00:46:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917472839355469
Pickup Latitude
40.765113830566406
Dropoff Longitude
-73.933891296386719
Dropoff Latitude
40.7547607421875
Passenger Count
1
Trip Distance
1.36
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:23:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:15.000
Lpep Dropoff Datetime
2016-01-01T00:43:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.910591125488281
Pickup Latitude
40.661537170410156
Dropoff Longitude
-73.978767395019531
Dropoff Latitude
40.673191070556641
Passenger Count
1
Trip Distance
4.48
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
4.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:51.000
Lpep Dropoff Datetime
2016-01-01T00:47:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941848754882813
Pickup Latitude
40.716831207275391
Dropoff Longitude
-73.886589050292969
Dropoff Latitude
40.712989807128906
Passenger Count
1
Trip Distance
3.40
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:22:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:08.000
Lpep Dropoff Datetime
2016-01-01T00:47:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950180053710938
Pickup Latitude
40.813076019287109
Dropoff Longitude
-73.984718322753906
Dropoff Latitude
40.732349395751953
Passenger Count
1
Trip Distance
8.17
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:30.000
Lpep Dropoff Datetime
2016-01-01T00:48:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914566040039063
Pickup Latitude
40.683494567871094
Dropoff Longitude
-73.949760437011719
Dropoff Latitude
40.670696258544922
Passenger Count
1
Trip Distance
2.98
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:39:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:49.000
Lpep Dropoff Datetime
2016-01-01T00:47:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90625
Pickup Latitude
40.753425598144531
Dropoff Longitude
-73.926849365234375
Dropoff Latitude
40.761543273925781
Passenger Count
1
Trip Distance
0.00
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:23:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:02.000
Lpep Dropoff Datetime
2016-01-01T00:47:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958351135253906
Pickup Latitude
40.721446990966797
Dropoff Longitude
-73.92236328125
Dropoff Latitude
40.691864013671875
Passenger Count
1
Trip Distance
3.43
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:44:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:26.000
Lpep Dropoff Datetime
2016-01-01T00:47:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955848693847656
Pickup Latitude
40.723163604736328
Dropoff Longitude
-73.955780029296875
Dropoff Latitude
40.733646392822266
Passenger Count
1
Trip Distance
0.88
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:40:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:15.000
Lpep Dropoff Datetime
2016-01-01T00:47:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902397155761719
Pickup Latitude
40.775833129882812
Dropoff Longitude
-73.918907165527344
Dropoff Latitude
40.765697479248047
Passenger Count
1
Trip Distance
1.51
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:25:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:39.000
Lpep Dropoff Datetime
2016-01-01T00:47:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95806884765625
Pickup Latitude
40.721656799316406
Dropoff Longitude
-73.831497192382812
Dropoff Latitude
40.707168579101563
Passenger Count
1
Trip Distance
10.74
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-01T00:33:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:27.000
Lpep Dropoff Datetime
2016-01-01T00:47:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945381164550781
Pickup Latitude
40.828327178955078
Dropoff Longitude
-73.991081237792969
Dropoff Latitude
40.769210815429687
Passenger Count
5
Trip Distance
5.27
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:39:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:50.000
Lpep Dropoff Datetime
2016-01-01T00:48:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.016975402832031
Pickup Latitude
40.675796508789063
Dropoff Longitude
-73.9957275390625
Dropoff Latitude
40.698200225830078
Passenger Count
1
Trip Distance
2.57
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:33:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:19.000
Lpep Dropoff Datetime
2016-01-01T00:47:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942428588867188
Pickup Latitude
40.813098907470703
Dropoff Longitude
-73.937690734863281
Dropoff Latitude
40.838687896728516
Passenger Count
1
Trip Distance
2.35
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:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:38.000
Lpep Dropoff Datetime
2016-01-01T00:47:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983146667480469
Pickup Latitude
40.672863006591797
Dropoff Longitude
-73.965171813964844
Dropoff Latitude
40.686813354492188
Passenger Count
1
Trip Distance
2.03
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:38:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:23.000
Lpep Dropoff Datetime
2016-01-01T00:47:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941612243652344
Pickup Latitude
40.822643280029297
Dropoff Longitude
-73.916213989257813
Dropoff Latitude
40.812995910644531
Passenger Count
1
Trip Distance
1.51
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:12:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:42.000
Lpep Dropoff Datetime
2016-01-01T00:47:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9896240234375
Pickup Latitude
40.673248291015625
Dropoff Longitude
-73.979751586914063
Dropoff Latitude
40.773441314697266
Passenger Count
1
Trip Distance
10.49
Fare Amount
35
Extra
0.5
Mta Tax
0.5
Tip Amount
7.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
43.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:09.000
Lpep Dropoff Datetime
2016-01-01T00:47:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944183349609375
Pickup Latitude
40.792198181152344
Dropoff Longitude
-73.937530517578125
Dropoff Latitude
40.793567657470703
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-01T00:41:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:31.000
Lpep Dropoff Datetime
2016-01-01T00:47:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957550048828125
Pickup Latitude
40.722232818603516
Dropoff Longitude
-73.964614868164062
Dropoff Latitude
40.712253570556641
Passenger Count
1
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:42.000
Lpep Dropoff Datetime
2016-01-01T00:47:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961776733398438
Pickup Latitude
40.715896606445313
Dropoff Longitude
-73.989837646484375
Dropoff Latitude
40.733875274658203
Passenger Count
5
Trip Distance
3.55
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:32:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:28.000
Lpep Dropoff Datetime
2016-01-01T00:47:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954551696777344
Pickup Latitude
40.815639495849609
Dropoff Longitude
-73.940773010253906
Dropoff Latitude
40.798343658447266
Passenger Count
1
Trip Distance
2.01
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:27:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:45.000
Lpep Dropoff Datetime
2016-01-01T00:47:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935943603515625
Pickup Latitude
40.7052001953125
Dropoff Longitude
-73.906135559082031
Dropoff Latitude
40.770645141601563
Passenger Count
1
Trip Distance
6.95
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
4.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:55.000
Lpep Dropoff Datetime
2016-01-01T00:47:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891014099121094
Pickup Latitude
40.746906280517578
Dropoff Longitude
-73.859764099121094
Dropoff Latitude
40.757923126220703
Passenger Count
1
Trip Distance
2.28
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:38:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:37.000
Lpep Dropoff Datetime
2016-01-01T00:47:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912117004394531
Pickup Latitude
40.678386688232422
Dropoff Longitude
-73.944915771484375
Dropoff Latitude
40.680191040039063
Passenger Count
1
Trip Distance
1.73
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:42:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:31.000
Lpep Dropoff Datetime
2016-01-01T00:46:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941360473632812
Pickup Latitude
40.816768646240234
Dropoff Longitude
-73.945274353027344
Dropoff Latitude
40.808090209960938
Passenger Count
1
Trip Distance
0.75
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:58.000
Lpep Dropoff Datetime
2016-01-01T00:48:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938209533691406
Pickup Latitude
40.679786682128906
Dropoff Longitude
-73.935279846191406
Dropoff Latitude
40.696937561035156
Passenger Count
1
Trip Distance
1.74
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:37.000
Lpep Dropoff Datetime
2016-01-01T00:48:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994232177734375
Pickup Latitude
40.703105926513672
Dropoff Longitude
-73.959671020507813
Dropoff Latitude
40.65570068359375
Passenger Count
1
Trip Distance
4.05
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-01T00:43:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:19.000
Lpep Dropoff Datetime
2016-01-01T00:47:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921340942382813
Pickup Latitude
40.756191253662109
Dropoff Longitude
-73.92669677734375
Dropoff Latitude
40.741718292236328
Passenger Count
1
Trip Distance
1.06
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
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-01T00:37:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:19.000
Lpep Dropoff Datetime
2016-01-01T00:48:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962867736816406
Pickup Latitude
40.683666229248047
Dropoff Longitude
-73.975349426269531
Dropoff Latitude
40.6744384765625
Passenger Count
1
Trip Distance
1.42
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:40:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:39.000
Lpep Dropoff Datetime
2016-01-01T00:47:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922874450683594
Pickup Latitude
40.755611419677734
Dropoff Longitude
-73.912986755371094
Dropoff Latitude
40.767738342285156
Passenger Count
1
Trip Distance
1.24
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:41:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:53.000
Lpep Dropoff Datetime
2016-01-01T00:48:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940406799316406
Pickup Latitude
40.715984344482422
Dropoff Longitude
-73.93377685546875
Dropoff Latitude
40.705547332763672
Passenger Count
3
Trip Distance
1.35
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:35:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:37.000
Lpep Dropoff Datetime
2016-01-01T00:48:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952613830566406
Pickup Latitude
40.7269287109375
Dropoff Longitude
-73.947616577148438
Dropoff Latitude
40.706939697265625
Passenger Count
1
Trip Distance
2.16
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:42:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:41.000
Lpep Dropoff Datetime
2016-01-01T00:47:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95001220703125
Pickup Latitude
40.722324371337891
Dropoff Longitude
-73.957595825195313
Dropoff Latitude
40.717933654785156
Passenger Count
2
Trip Distance
0.69
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:28.000
Lpep Dropoff Datetime
2016-01-01T00:47:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957984924316406
Pickup Latitude
40.717586517333984
Dropoff Longitude
-73.992729187011719
Dropoff Latitude
40.697418212890625
Passenger Count
1
Trip Distance
3.53
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:44:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:32.000
Lpep Dropoff Datetime
2016-01-01T00:48:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942436218261719
Pickup Latitude
40.812160491943359
Dropoff Longitude
-73.941246032714844
Dropoff Latitude
40.807872772216797
Passenger Count
1
Trip Distance
0.41
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:48.000
Lpep Dropoff Datetime
2016-01-01T00:48:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922584533691406
Pickup Latitude
40.742595672607422
Dropoff Longitude
-73.991645812988281
Dropoff Latitude
40.726707458496094
Passenger Count
1
Trip Distance
9.78
Fare Amount
33
Extra
0.5
Mta Tax
0.5
Tip Amount
6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
40.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:07.000
Lpep Dropoff Datetime
2016-01-01T00:47:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9083251953125
Pickup Latitude
40.771003723144531
Dropoff Longitude
-73.86834716796875
Dropoff Latitude
40.752582550048828
Passenger Count
1
Trip Distance
2.89
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
NYC Data AI • Public-data exploration interface