2016 Green Taxi Trip Data

These records are generated from the trip record submissions made by green taxi Technology Service Providers (TSPs). Each row represents a single trip in a green taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.

Transportation Taxi and Limousine Commission (TLC) Dataset hvrh-b6nb 23 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:59.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:43.000
Lpep Dropoff Datetime
2016-01-01T00:29:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940391540527344
Pickup Latitude
40.789211273193359
Dropoff Longitude
-73.918304443359375
Dropoff Latitude
40.807121276855469
Passenger Count
1
Trip Distance
1.90
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:24:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:53.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:24:39.000
Lpep Dropoff Datetime
2016-01-01T00:44:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950454711914063
Pickup Latitude
40.706947326660156
Dropoff Longitude
-73.917510986328125
Dropoff Latitude
40.776321411132812
Passenger Count
2
Trip Distance
7.50
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
7.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.5
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:31:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:44.000
Lpep Dropoff Datetime
2016-01-01T00:31:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988029479980469
Pickup Latitude
40.690235137939453
Dropoff Longitude
-73.9820556640625
Dropoff Latitude
40.681804656982422
Passenger Count
1
Trip Distance
1.00
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:08.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:44.000
Lpep Dropoff Datetime
2016-01-01T00:50:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969276428222656
Pickup Latitude
40.672702789306641
Dropoff Longitude
-73.879112243652344
Dropoff Latitude
40.674785614013672
Passenger Count
2
Trip Distance
5.10
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:24:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:24:40.000
Lpep Dropoff Datetime
2016-01-01T00:50:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881668090820313
Pickup Latitude
40.742267608642578
Dropoff Longitude
-74.02020263671875
Dropoff Latitude
40.649318695068359
Passenger Count
1
Trip Distance
13.00
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
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:24:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:23.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:24:17.000
Lpep Dropoff Datetime
2016-01-01T00:33:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969955444335937
Pickup Latitude
40.697750091552734
Dropoff Longitude
-73.942909240722656
Dropoff Latitude
40.705486297607422
Passenger Count
1
Trip Distance
1.80
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:24:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:28:25.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:24:27.000
Lpep Dropoff Datetime
2016-01-01T00:28:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957107543945313
Pickup Latitude
40.805110931396484
Dropoff Longitude
-73.970405578613281
Dropoff Latitude
40.793098449707031
Passenger Count
1
Trip Distance
1.30
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:13.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:35.000
Lpep Dropoff Datetime
2016-01-01T00:32:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920211791992188
Pickup Latitude
40.807964324951172
Dropoff Longitude
-73.9449462890625
Dropoff Latitude
40.786590576171875
Passenger Count
1
Trip Distance
2.60
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:25:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:31:02.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:25:08.000
Lpep Dropoff Datetime
2016-01-01T00:31:02.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.905899047851563
Pickup Latitude
40.877548217773437
Dropoff Longitude
-73.914520263671875
Dropoff Latitude
40.854164123535156
Passenger Count
1
Trip Distance
2.00
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:57.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:32.000
Lpep Dropoff Datetime
2016-01-01T00:32:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952880859375
Pickup Latitude
40.808082580566406
Dropoff Longitude
-73.938545227050781
Dropoff Latitude
40.793861389160156
Passenger Count
1
Trip Distance
1.60
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.75
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:22.000
Lpep Dropoff Datetime
2016-01-01T00:33:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938896179199219
Pickup Latitude
40.844753265380859
Dropoff Longitude
-73.928215026855469
Dropoff Latitude
40.854419708251953
Passenger Count
1
Trip Distance
1.40
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:27.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:16.000
Lpep Dropoff Datetime
2016-01-01T00:39:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9581298828125
Pickup Latitude
40.721614837646484
Dropoff Longitude
-73.986473083496094
Dropoff Latitude
40.672542572021484
Passenger Count
1
Trip Distance
7.10
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
20
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
42.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:27:57.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:11.000
Lpep Dropoff Datetime
2016-01-01T00:27:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8916015625
Pickup Latitude
40.746795654296875
Dropoff Longitude
-73.881484985351563
Dropoff Latitude
40.746315002441406
Passenger Count
1
Trip Distance
0.70
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:24:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:18.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:24:08.000
Lpep Dropoff Datetime
2016-01-01T00:39:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.931793212890625
Pickup Latitude
40.697059631347656
Dropoff Longitude
-73.954483032226563
Dropoff Latitude
40.731159210205078
Passenger Count
1
Trip Distance
2.90
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:28:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:59.000
Lpep Dropoff Datetime
2016-01-01T00:28:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.900993347167969
Pickup Latitude
40.856201171875
Dropoff Longitude
-73.913467407226563
Dropoff Latitude
40.849399566650391
Passenger Count
1
Trip Distance
1.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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:31:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:10.000
Lpep Dropoff Datetime
2016-01-01T00:31:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881004333496094
Pickup Latitude
40.747993469238281
Dropoff Longitude
-73.868766784667969
Dropoff Latitude
40.757205963134766
Passenger Count
1
Trip Distance
1.20
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:35.000
Lpep Dropoff Datetime
2016-01-01T00:30:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98016357421875
Pickup Latitude
40.676219940185547
Dropoff Longitude
-73.955413818359375
Dropoff Latitude
40.675819396972656
Passenger Count
1
Trip Distance
1.50
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
2.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:24:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:24:31.000
Lpep Dropoff Datetime
2016-01-01T00:47:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.97772216796875
Pickup Latitude
40.684623718261719
Dropoff Longitude
-73.940902709960938
Dropoff Latitude
40.792457580566406
Passenger Count
2
Trip Distance
10.20
Fare Amount
30
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:41.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:58.000
Lpep Dropoff Datetime
2016-01-01T00:33:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896369934082031
Pickup Latitude
40.746288299560547
Dropoff Longitude
-73.869834899902344
Dropoff Latitude
40.722904205322266
Passenger Count
1
Trip Distance
2.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:15.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:56.000
Lpep Dropoff Datetime
2016-01-01T00:41:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9493408203125
Pickup Latitude
40.713676452636719
Dropoff Longitude
-73.915473937988281
Dropoff Latitude
40.697444915771484
Passenger Count
1
Trip Distance
3.00
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.5
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:55.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:05.000
Lpep Dropoff Datetime
2016-01-01T00:32:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954376220703125
Pickup Latitude
40.731082916259766
Dropoff Longitude
-73.953376770019531
Dropoff Latitude
40.708431243896484
Passenger Count
1
Trip Distance
2.30
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.5
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:26:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:20.000
Lpep Dropoff Datetime
2016-01-01T00:26:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941696166992188
Pickup Latitude
40.806980133056641
Dropoff Longitude
-73.941596984863281
Dropoff Latitude
40.811897277832031
Passenger Count
1
Trip Distance
0.50
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:24.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:52.000
Lpep Dropoff Datetime
2016-01-01T00:42:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.975341796875
Pickup Latitude
40.680881500244141
Dropoff Longitude
-73.93218994140625
Dropoff Latitude
40.683921813964844
Passenger Count
1
Trip Distance
3.00
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:48.000
Lpep Dropoff Datetime
2016-01-01T00:47:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946731567382813
Pickup Latitude
40.800712585449219
Dropoff Longitude
-74.004714965820313
Dropoff Latitude
40.740745544433594
Passenger Count
1
Trip Distance
7.10
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.25
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:37.000
Lpep Dropoff Datetime
2016-01-01T00:47:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962791442871094
Pickup Latitude
40.682643890380859
Dropoff Longitude
-73.952598571777344
Dropoff Latitude
40.771335601806641
Passenger Count
1
Trip Distance
9.40
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:26:11.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:35.000
Lpep Dropoff Datetime
2016-01-01T00:26:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958404541015625
Pickup Latitude
40.800201416015625
Dropoff Longitude
-73.954116821289062
Dropoff Latitude
40.802150726318359
Passenger Count
1
Trip Distance
0.40
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:21.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:50.000
Lpep Dropoff Datetime
2016-01-01T00:39:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946540832519531
Pickup Latitude
40.806144714355469
Dropoff Longitude
-73.953277587890625
Dropoff Latitude
40.770744323730469
Passenger Count
1
Trip Distance
4.20
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:28:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:38.000
Lpep Dropoff Datetime
2016-01-01T00:28:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.833511352539063
Pickup Latitude
40.716373443603516
Dropoff Longitude
-73.8214111328125
Dropoff Latitude
40.722728729248047
Passenger Count
1
Trip Distance
1.90
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:53:16.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:22.000
Lpep Dropoff Datetime
2016-01-01T00:53:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955291748046875
Pickup Latitude
40.804336547851563
Dropoff Longitude
-73.888282775878906
Dropoff Latitude
40.868442535400391
Passenger Count
1
Trip Distance
6.40
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
4
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:38.000
Lpep Dropoff Datetime
2016-01-01T00:39:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942092895507812
Pickup Latitude
40.722679138183594
Dropoff Longitude
-73.969230651855469
Dropoff Latitude
40.765811920166016
Passenger Count
4
Trip Distance
4.90
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:40.000
Lpep Dropoff Datetime
2016-01-01T00:33:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946388244628906
Pickup Latitude
40.697914123535156
Dropoff Longitude
-73.899787902832031
Dropoff Latitude
40.723552703857422
Passenger Count
1
Trip Distance
3.20
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:14.000
Lpep Dropoff Datetime
2016-01-01T00:39:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952415466308594
Pickup Latitude
40.734004974365234
Dropoff Longitude
-73.941940307617188
Dropoff Latitude
40.694705963134766
Passenger Count
1
Trip Distance
3.80
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:23:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:45.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:23:49.000
Lpep Dropoff Datetime
2016-01-01T00:35:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958457946777344
Pickup Latitude
40.674640655517578
Dropoff Longitude
-73.980209350585938
Dropoff Latitude
40.676826477050781
Passenger Count
1
Trip Distance
1.80
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:45.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:00.000
Lpep Dropoff Datetime
2016-01-01T00:35:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951339721679688
Pickup Latitude
40.799304962158203
Dropoff Longitude
-73.940200805664062
Dropoff Latitude
40.822200775146484
Passenger Count
1
Trip Distance
2.40
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:23.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:44.000
Lpep Dropoff Datetime
2016-01-01T00:32:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920814514160156
Pickup Latitude
40.682842254638672
Dropoff Longitude
-73.937934875488281
Dropoff Latitude
40.677085876464844
Passenger Count
1
Trip Distance
2.00
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
3.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:02.000
Lpep Dropoff Datetime
2016-01-01T00:33:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962982177734375
Pickup Latitude
40.804084777832031
Dropoff Longitude
-73.950141906738281
Dropoff Latitude
40.780323028564453
Passenger Count
1
Trip Distance
2.80
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.75
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:31:53.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:00.000
Lpep Dropoff Datetime
2016-01-01T00:31:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933708190917969
Pickup Latitude
40.849498748779297
Dropoff Longitude
-73.920730590820312
Dropoff Latitude
40.867755889892578
Passenger Count
1
Trip Distance
1.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:01.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:58.000
Lpep Dropoff Datetime
2016-01-01T00:33:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977859497070312
Pickup Latitude
40.684734344482422
Dropoff Longitude
-73.975685119628906
Dropoff Latitude
40.686813354492188
Passenger Count
1
Trip Distance
1.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:57.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:57.000
Lpep Dropoff Datetime
2016-01-01T00:34:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949241638183594
Pickup Latitude
40.82794189453125
Dropoff Longitude
-73.91705322265625
Dropoff Latitude
40.867137908935547
Passenger Count
3
Trip Distance
4.00
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:46.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:20.000
Lpep Dropoff Datetime
2016-01-01T00:32:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970298767089844
Pickup Latitude
40.673168182373047
Dropoff Longitude
-73.968780517578125
Dropoff Latitude
40.692737579345703
Passenger Count
1
Trip Distance
1.60
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.25
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:11:50.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:48.000
Lpep Dropoff Datetime
2016-01-01T01:11:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968719482421875
Pickup Latitude
40.673030853271484
Dropoff Longitude
-73.994033813476563
Dropoff Latitude
40.756481170654297
Passenger Count
1
Trip Distance
8.20
Fare Amount
37
Extra
0.5
Mta Tax
0.5
Tip Amount
10
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
48.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:49.000
Lpep Dropoff Datetime
2016-01-01T00:45:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964576721191406
Pickup Latitude
40.705955505371094
Dropoff Longitude
-73.906570434570313
Dropoff Latitude
40.699222564697266
Passenger Count
1
Trip Distance
4.00
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
4
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:34.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:38.000
Lpep Dropoff Datetime
2016-01-01T00:24:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.000328063964844
Pickup Latitude
40.69000244140625
Dropoff Longitude
-74.004898071289063
Dropoff Latitude
40.684848785400391
Passenger Count
1
Trip Distance
0.60
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:54.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:37.000
Lpep Dropoff Datetime
2016-01-01T00:32:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950355529785156
Pickup Latitude
40.804759979248047
Dropoff Longitude
-73.935691833496094
Dropoff Latitude
40.796073913574219
Passenger Count
1
Trip Distance
1.20
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:28:49.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:45.000
Lpep Dropoff Datetime
2016-01-01T00:28:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.879364013671875
Pickup Latitude
40.7369384765625
Dropoff Longitude
-73.862228393554688
Dropoff Latitude
40.737632751464844
Passenger Count
1
Trip Distance
1.10
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:48.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:43.000
Lpep Dropoff Datetime
2016-01-01T00:29:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957420349121094
Pickup Latitude
40.718013763427734
Dropoff Longitude
-73.987800598144531
Dropoff Latitude
40.718570709228516
Passenger Count
1
Trip Distance
2.40
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
4
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:28.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:40.000
Lpep Dropoff Datetime
2016-01-01T00:30:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956382751464844
Pickup Latitude
40.684501647949219
Dropoff Longitude
-73.971946716308594
Dropoff Latitude
40.678291320800781
Passenger Count
2
Trip Distance
1.50
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
1.75
Improvement Surcharge
0.3
Total Amount
10.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:38.000
Lpep Dropoff Datetime
2016-01-01T00:35:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921821594238281
Pickup Latitude
40.677215576171875
Dropoff Longitude
-73.963859558105469
Dropoff Latitude
40.710109710693359
Passenger Count
2
Trip Distance
4.00
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:33:45.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:38.000
Lpep Dropoff Datetime
2016-01-01T00:33:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953445434570312
Pickup Latitude
40.668643951416016
Dropoff Longitude
-73.960655212402344
Dropoff Latitude
40.647602081298828
Passenger Count
3
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:21:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:37:22.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:21:41.000
Lpep Dropoff Datetime
2016-01-01T00:37:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955398559570313
Pickup Latitude
40.714054107666016
Dropoff Longitude
-74.009086608886719
Dropoff Latitude
40.709831237792969
Passenger Count
1
Trip Distance
3.90
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