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:19:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:38:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:22.000
Lpep Dropoff Datetime
2016-01-01T00:38:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941390991210938
Pickup Latitude
40.814323425292969
Dropoff Longitude
-73.840629577636719
Dropoff Latitude
40.880851745605469
Passenger Count
1
Trip Distance
11.38
Fare Amount
32
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:19:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:28.000
Lpep Dropoff Datetime
2016-01-01T00:39:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.971359252929688
Pickup Latitude
40.672943115234375
Dropoff Longitude
-73.95623779296875
Dropoff Latitude
40.726364135742188
Passenger Count
1
Trip Distance
5.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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:38:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:39.000
Lpep Dropoff Datetime
2016-01-01T00:38:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93927001953125
Pickup Latitude
40.807647705078125
Dropoff Longitude
-73.936737060546875
Dropoff Latitude
40.829998016357422
Passenger Count
1
Trip Distance
2.85
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:38:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:39.000
Lpep Dropoff Datetime
2016-01-01T00:39:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949600219726563
Pickup Latitude
40.679725646972656
Dropoff Longitude
-73.949737548828125
Dropoff Latitude
40.678993225097656
Passenger Count
1
Trip Distance
0.05
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
3.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:17.000
Lpep Dropoff Datetime
2016-01-01T00:39:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954124450683594
Pickup Latitude
40.673206329345703
Dropoff Longitude
-73.952857971191406
Dropoff Latitude
40.688968658447266
Passenger Count
1
Trip Distance
1.41
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:40.000
Lpep Dropoff Datetime
2016-01-01T00:32:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.877235412597656
Pickup Latitude
40.737602233886719
Dropoff Longitude
-73.844680786132813
Dropoff Latitude
40.679851531982422
Passenger Count
5
Trip Distance
4.62
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:06.000
Lpep Dropoff Datetime
2016-01-01T00:39:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940216064453125
Pickup Latitude
40.750255584716797
Dropoff Longitude
-73.920234680175781
Dropoff Latitude
40.766410827636719
Passenger Count
1
Trip Distance
2.16
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:29:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:37:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:30.000
Lpep Dropoff Datetime
2016-01-01T00:37:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.996292114257813
Pickup Latitude
40.682544708251953
Dropoff Longitude
-73.993667602539063
Dropoff Latitude
40.690090179443359
Passenger Count
1
Trip Distance
1.04
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:37:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:13.000
Lpep Dropoff Datetime
2016-01-01T00:39:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.910911560058594
Pickup Latitude
40.775875091552734
Dropoff Longitude
-73.919754028320313
Dropoff Latitude
40.778125762939453
Passenger Count
6
Trip Distance
0.68
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:32:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:46:39.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:32:06.000
Lpep Dropoff Datetime
2016-01-01T00:46:39.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.879814147949219
Pickup Latitude
40.756240844726563
Dropoff Longitude
-73.929618835449219
Dropoff Latitude
40.760784149169922
Passenger Count
1
Trip Distance
2.70
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
3
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:12:35.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:20.000
Lpep Dropoff Datetime
2016-01-01T01:12:35.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.885017395019531
Pickup Latitude
40.853343963623047
Dropoff Longitude
-73.916061401367187
Dropoff Latitude
40.824817657470703
Passenger Count
3
Trip Distance
3.20
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:13.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:25.000
Lpep Dropoff Datetime
2016-01-01T00:58:13.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.846817016601563
Pickup Latitude
40.839992523193359
Dropoff Longitude
-73.885017395019531
Dropoff Latitude
40.853340148925781
Passenger Count
1
Trip Distance
3.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:22:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:05:59.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:22:22.000
Lpep Dropoff Datetime
2016-01-01T01:05:59.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.941383361816406
Pickup Latitude
40.706668853759766
Dropoff Longitude
-73.968269348144531
Dropoff Latitude
40.802207946777344
Passenger Count
1
Trip Distance
11.60
Fare Amount
41
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
42.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:47:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:59:29.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:47:27.000
Lpep Dropoff Datetime
2016-01-01T00:59:29.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.983512878417969
Pickup Latitude
40.676567077636719
Dropoff Longitude
-73.939529418945313
Dropoff Latitude
40.669013977050781
Passenger Count
1
Trip Distance
2.60
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:33:57.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:33:57.000
Lpep Dropoff Datetime
2016-01-01T00:44:17.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.9892578125
Pickup Latitude
40.690826416015625
Dropoff Longitude
-73.981216430664063
Dropoff Latitude
40.675254821777344
Passenger Count
1
Trip Distance
1.60
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:13:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:19:31.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:13:42.000
Lpep Dropoff Datetime
2016-01-01T00:19:31.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.94171142578125
Pickup Latitude
40.679985046386719
Dropoff Longitude
-73.956008911132813
Dropoff Latitude
40.681209564208984
Passenger Count
1
Trip Distance
0.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:14:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:21.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:14:49.000
Lpep Dropoff Datetime
2016-01-01T00:30:21.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.923484802246094
Pickup Latitude
40.743579864501953
Dropoff Longitude
-73.880905151367188
Dropoff Latitude
40.758167266845703
Passenger Count
1
Trip Distance
3.10
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:52:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:41.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:52:59.000
Lpep Dropoff Datetime
2016-01-01T01:04:41.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.940643310546875
Pickup Latitude
40.814262390136719
Dropoff Longitude
-73.943191528320313
Dropoff Latitude
40.789512634277344
Passenger Count
1
Trip Distance
2.40
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:45:48.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:35.000
Lpep Dropoff Datetime
2016-01-01T00:45:48.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.937698364257813
Pickup Latitude
40.818466186523438
Dropoff Longitude
-73.937858581542969
Dropoff Latitude
40.818214416503906
Passenger Count
1
Trip Distance
4.60
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
3.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:06:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:20:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:06:05.000
Lpep Dropoff Datetime
2016-01-01T00:20:17.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.93939208984375
Pickup Latitude
40.848262786865234
Dropoff Longitude
-73.991279602050781
Dropoff Latitude
40.764404296875
Passenger Count
2
Trip Distance
7.10
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.35
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:58:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:56.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:09.000
Lpep Dropoff Datetime
2016-01-01T01:08:56.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.973159790039063
Pickup Latitude
40.673568725585938
Dropoff Longitude
-73.966064453125
Dropoff Latitude
40.689422607421875
Passenger Count
2
Trip Distance
2.20
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:52:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:49.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:52:24.000
Lpep Dropoff Datetime
2016-01-01T01:01:49.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.942344665527344
Pickup Latitude
40.786540985107422
Dropoff Longitude
-73.937728881835938
Dropoff Latitude
40.828609466552734
Passenger Count
1
Trip Distance
3.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:14:49.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:56.000
Lpep Dropoff Datetime
2016-01-01T01:14:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.010948181152344
Pickup Latitude
40.678993225097656
Dropoff Longitude
-73.954994201660156
Dropoff Latitude
40.716419219970703
Passenger Count
1
Trip Distance
5.50
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
20
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
40.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:57.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:49.000
Lpep Dropoff Datetime
2016-01-01T01:08:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954460144042969
Pickup Latitude
40.730129241943359
Dropoff Longitude
-73.991966247558594
Dropoff Latitude
40.699581146240234
Passenger Count
1
Trip Distance
4.70
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:59:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:41.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:44.000
Lpep Dropoff Datetime
2016-01-01T01:09:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927192687988281
Pickup Latitude
40.688217163085938
Dropoff Longitude
-73.911155700683594
Dropoff Latitude
40.674461364746094
Passenger Count
4
Trip Distance
1.60
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:26.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:42.000
Lpep Dropoff Datetime
2016-01-01T01:17:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952644348144531
Pickup Latitude
40.676734924316406
Dropoff Longitude
-73.917678833007812
Dropoff Latitude
40.698936462402344
Passenger Count
1
Trip Distance
3.30
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:59:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:16:06.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:45.000
Lpep Dropoff Datetime
2016-01-01T01:16:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98358154296875
Pickup Latitude
40.683151245117188
Dropoff Longitude
-73.941291809082031
Dropoff Latitude
40.684837341308594
Passenger Count
3
Trip Distance
2.90
Fare Amount
13.5
Extra
0
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:59:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:20:25.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:37.000
Lpep Dropoff Datetime
2016-01-01T01:20:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951751708984375
Pickup Latitude
40.715007781982422
Dropoff Longitude
-73.997489929199219
Dropoff Latitude
40.732719421386719
Passenger Count
1
Trip Distance
3.80
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:59:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:45.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:37.000
Lpep Dropoff Datetime
2016-01-01T01:09:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920783996582031
Pickup Latitude
40.830883026123047
Dropoff Longitude
-73.940017700195313
Dropoff Latitude
40.813182830810547
Passenger Count
2
Trip Distance
2.00
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:59:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:24:12.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:31.000
Lpep Dropoff Datetime
2016-01-01T01:24:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.010345458984375
Pickup Latitude
40.648502349853516
Dropoff Longitude
-73.9417724609375
Dropoff Latitude
40.6270751953125
Passenger Count
1
Trip Distance
6.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:30.000
Lpep Dropoff Datetime
2016-01-01T01:01:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952217102050781
Pickup Latitude
40.786460876464844
Dropoff Longitude
-73.948051452636719
Dropoff Latitude
40.787071228027344
Passenger Count
1
Trip Distance
0.30
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
11.8
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.6
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:05:39.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:28.000
Lpep Dropoff Datetime
2016-01-01T01:05:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844146728515625
Pickup Latitude
40.721080780029297
Dropoff Longitude
-73.853759765625
Dropoff Latitude
40.736003875732422
Passenger Count
1
Trip Distance
1.20
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:25:40.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:28.000
Lpep Dropoff Datetime
2016-01-01T01:25:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926727294921875
Pickup Latitude
40.694011688232422
Dropoff Longitude
-73.918327331542969
Dropoff Latitude
40.638813018798828
Passenger Count
1
Trip Distance
4.60
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:21.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:29.000
Lpep Dropoff Datetime
2016-01-01T01:18:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983146667480469
Pickup Latitude
40.696720123291016
Dropoff Longitude
-73.980552673339844
Dropoff Latitude
40.734344482421875
Passenger Count
1
Trip Distance
5.70
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:53.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:29.000
Lpep Dropoff Datetime
2016-01-01T01:03:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9139404296875
Pickup Latitude
40.756561279296875
Dropoff Longitude
-73.924057006835938
Dropoff Latitude
40.761390686035156
Passenger Count
1
Trip Distance
0.60
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:40.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:26.000
Lpep Dropoff Datetime
2016-01-01T01:00:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.892074584960938
Pickup Latitude
40.869464874267578
Dropoff Longitude
-73.894203186035156
Dropoff Latitude
40.866584777832031
Passenger Count
1
Trip Distance
0.20
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
4
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:55.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:18.000
Lpep Dropoff Datetime
2016-01-01T01:17:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.930648803710937
Pickup Latitude
40.830585479736328
Dropoff Longitude
-73.883651733398437
Dropoff Latitude
40.869308471679688
Passenger Count
1
Trip Distance
5.80
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
4.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:11:41.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:11.000
Lpep Dropoff Datetime
2016-01-01T01:11:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.866622924804688
Pickup Latitude
40.823116302490234
Dropoff Longitude
-73.896583557128906
Dropoff Latitude
40.83245849609375
Passenger Count
2
Trip Distance
2.80
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:59:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:27:01.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:17.000
Lpep Dropoff Datetime
2016-01-01T01:27:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.872268676757813
Pickup Latitude
40.675285339355469
Dropoff Longitude
-73.953262329101563
Dropoff Latitude
40.698947906494141
Passenger Count
3
Trip Distance
6.20
Fare Amount
23
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:05:08.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:12.000
Lpep Dropoff Datetime
2016-01-01T01:05:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964576721191406
Pickup Latitude
40.712165832519531
Dropoff Longitude
-73.954696655273437
Dropoff Latitude
40.716712951660156
Passenger Count
1
Trip Distance
0.90
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:59:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:04.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:26.000
Lpep Dropoff Datetime
2016-01-01T01:08:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925521850585937
Pickup Latitude
40.758869171142578
Dropoff Longitude
-73.921150207519531
Dropoff Latitude
40.775344848632813
Passenger Count
1
Trip Distance
1.60
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:59:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:13:43.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:50.000
Lpep Dropoff Datetime
2016-01-01T01:13:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954505920410156
Pickup Latitude
40.805545806884766
Dropoff Longitude
-73.938827514648438
Dropoff Latitude
40.845005035400391
Passenger Count
1
Trip Distance
4.00
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.8
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.1
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:59:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:39.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:59:29.000
Lpep Dropoff Datetime
2016-01-01T01:07:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.973533630371094
Pickup Latitude
40.678741455078125
Dropoff Longitude
-73.958564758300781
Dropoff Latitude
40.669025421142578
Passenger Count
2
Trip Distance
1.40
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:58:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:54.000
Lpep Dropoff Datetime
2016-01-01T01:07:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948112487792969
Pickup Latitude
40.763671875
Dropoff Longitude
-73.959014892578125
Dropoff Latitude
40.743625640869141
Passenger Count
1
Trip Distance
2.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:58:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:23:02.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:54.000
Lpep Dropoff Datetime
2016-01-01T01:23:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943962097167969
Pickup Latitude
40.825298309326172
Dropoff Longitude
-73.885238647460938
Dropoff Latitude
40.852699279785156
Passenger Count
1
Trip Distance
5.30
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:58:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:11:48.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:52.000
Lpep Dropoff Datetime
2016-01-01T01:11:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988754272460938
Pickup Latitude
40.696418762207031
Dropoff Longitude
-73.980613708496094
Dropoff Latitude
40.676494598388672
Passenger Count
1
Trip Distance
2.00
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:58:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:57.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:51.000
Lpep Dropoff Datetime
2016-01-01T01:04:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919097900390625
Pickup Latitude
40.770366668701172
Dropoff Longitude
-73.904129028320313
Dropoff Latitude
40.764331817626953
Passenger Count
1
Trip Distance
1.10
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:58:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:18:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:50.000
Lpep Dropoff Datetime
2016-01-01T01:18:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9271240234375
Pickup Latitude
40.697925567626953
Dropoff Longitude
-73.91162109375
Dropoff Latitude
40.708282470703125
Passenger Count
1
Trip Distance
2.60
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:58:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:18.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:54.000
Lpep Dropoff Datetime
2016-01-01T01:09:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844413757324219
Pickup Latitude
40.721347808837891
Dropoff Longitude
-73.799186706542969
Dropoff Latitude
40.737075805664062
Passenger Count
1
Trip Distance
3.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:58:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:11:42.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:58:52.000
Lpep Dropoff Datetime
2016-01-01T01:11:42.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.940093994140625
Pickup Latitude
40.789375305175781
Dropoff Longitude
-73.942222595214844
Dropoff Latitude
40.822372436523438
Passenger Count
1
Trip Distance
3.00
Fare Amount
12
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
12
Payment Type
2
Trip Type
2