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-01T01:28:17.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:28:17.000
Lpep Dropoff Datetime
2016-01-01T02:17:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957244873046875
Pickup Latitude
40.672653198242187
Dropoff Longitude
-73.972343444824219
Dropoff Latitude
40.796585083007813
Passenger Count
1
Trip Distance
10.73
Fare Amount
40
Extra
0.5
Mta Tax
0.5
Tip Amount
8.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
49.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:21:15.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:21:15.000
Lpep Dropoff Datetime
2016-01-01T02:17:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936805725097656
Pickup Latitude
40.808353424072266
Dropoff Longitude
-73.946060180664063
Dropoff Latitude
40.622795104980469
Passenger Count
1
Trip Distance
16.68
Fare Amount
52.5
Extra
0.5
Mta Tax
0.5
Tip Amount
8.07
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
61.87
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:58:41.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:41.000
Lpep Dropoff Datetime
2016-01-01T02:17:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981559753417969
Pickup Latitude
40.685596466064453
Dropoff Longitude
-73.996444702148438
Dropoff Latitude
40.720989227294922
Passenger Count
1
Trip Distance
3.38
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:37.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:37.000
Lpep Dropoff Datetime
2016-01-01T02:17:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987220764160156
Pickup Latitude
40.692951202392578
Dropoff Longitude
-73.952659606933594
Dropoff Latitude
40.788200378417969
Passenger Count
1
Trip Distance
9.46
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
0.3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.6
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:52:29.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:29.000
Lpep Dropoff Datetime
2016-01-01T02:17:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976547241210937
Pickup Latitude
40.681316375732422
Dropoff Longitude
-73.954055786132813
Dropoff Latitude
40.770366668701172
Passenger Count
1
Trip Distance
9.24
Fare Amount
28.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:36.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:36.000
Lpep Dropoff Datetime
2016-01-01T02:16:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92919921875
Pickup Latitude
40.704555511474609
Dropoff Longitude
-73.951591491699219
Dropoff Latitude
40.730796813964844
Passenger Count
1
Trip Distance
2.77
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-01T01:52:30.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:30.000
Lpep Dropoff Datetime
2016-01-01T02:17:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91912841796875
Pickup Latitude
40.806617736816406
Dropoff Longitude
-73.989151000976563
Dropoff Latitude
40.720325469970703
Passenger Count
1
Trip Distance
9.37
Fare Amount
30
Extra
0.5
Mta Tax
0.5
Tip Amount
0.63
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.93
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:51.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:51.000
Lpep Dropoff Datetime
2016-01-01T02:17:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979972839355469
Pickup Latitude
40.67620849609375
Dropoff Longitude
-73.944252014160156
Dropoff Latitude
40.8023681640625
Passenger Count
1
Trip Distance
12.23
Fare Amount
37
Extra
0.5
Mta Tax
0.5
Tip Amount
7.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
45.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:58:54.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:54.000
Lpep Dropoff Datetime
2016-01-01T02:16:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.878677368164062
Pickup Latitude
40.740093231201172
Dropoff Longitude
-73.880203247070312
Dropoff Latitude
40.745990753173828
Passenger Count
1
Trip Distance
2.66
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-01T01:56:43.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:43.000
Lpep Dropoff Datetime
2016-01-01T02:16:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949630737304687
Pickup Latitude
40.744125366210937
Dropoff Longitude
-73.935066223144531
Dropoff Latitude
40.811500549316406
Passenger Count
1
Trip Distance
7.15
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:52:06.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:06.000
Lpep Dropoff Datetime
2016-01-01T02:17:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9334716796875
Pickup Latitude
40.758285522460937
Dropoff Longitude
-73.944671630859375
Dropoff Latitude
40.707973480224609
Passenger Count
1
Trip Distance
4.39
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:49:23.000 • Lpep Dropoff Datetime: 2016-01-02T01:44:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:49:23.000
Lpep Dropoff Datetime
2016-01-02T01:44:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955635070800781
Pickup Latitude
40.721794128417969
Dropoff Longitude
-73.832954406738281
Dropoff Latitude
40.760696411132813
Passenger Count
6
Trip Distance
9.87
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:37:21.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:21.000
Lpep Dropoff Datetime
2016-01-01T02:17:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844322204589844
Pickup Latitude
40.721328735351562
Dropoff Longitude
-73.996475219726563
Dropoff Latitude
40.737979888916016
Passenger Count
1
Trip Distance
15.88
Fare Amount
47.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
48.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:50:28.000 • Lpep Dropoff Datetime: 2016-01-01T02:13:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:28.000
Lpep Dropoff Datetime
2016-01-01T02:13:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942268371582031
Pickup Latitude
40.700736999511719
Dropoff Longitude
-73.896751403808594
Dropoff Latitude
40.660133361816406
Passenger Count
1
Trip Distance
5.44
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:58:17.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:17.000
Lpep Dropoff Datetime
2016-01-01T02:17:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93310546875
Pickup Latitude
40.697719573974609
Dropoff Longitude
-73.948722839355469
Dropoff Latitude
40.727226257324219
Passenger Count
1
Trip Distance
2.90
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:15.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:15.000
Lpep Dropoff Datetime
2016-01-01T02:17:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905418395996094
Pickup Latitude
40.776561737060547
Dropoff Longitude
-73.984481811523438
Dropoff Latitude
40.739696502685547
Passenger Count
1
Trip Distance
8.40
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
8.46
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
42.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:23.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:23.000
Lpep Dropoff Datetime
2016-01-01T02:17:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948188781738281
Pickup Latitude
40.785690307617188
Dropoff Longitude
-73.868515014648438
Dropoff Latitude
40.839916229248047
Passenger Count
1
Trip Distance
6.97
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:47:46.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:46.000
Lpep Dropoff Datetime
2016-01-01T02:17:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987106323242187
Pickup Latitude
40.686225891113281
Dropoff Longitude
-73.979499816894531
Dropoff Latitude
40.7711181640625
Passenger Count
1
Trip Distance
9.22
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-01T01:54:13.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:13.000
Lpep Dropoff Datetime
2016-01-01T02:17:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965652465820312
Pickup Latitude
40.713069915771484
Dropoff Longitude
-73.916305541992188
Dropoff Latitude
40.763561248779297
Passenger Count
2
Trip Distance
7.84
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:58:54.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:54.000
Lpep Dropoff Datetime
2016-01-01T02:17:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.972808837890625
Pickup Latitude
40.685710906982422
Dropoff Longitude
-73.930412292480469
Dropoff Latitude
40.701087951660156
Passenger Count
1
Trip Distance
3.68
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-01T01:59:29.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:29.000
Lpep Dropoff Datetime
2016-01-01T02:17:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95086669921875
Pickup Latitude
40.709259033203125
Dropoff Longitude
-73.966743469238281
Dropoff Latitude
40.675258636474609
Passenger Count
1
Trip Distance
3.22
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:53:25.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:25.000
Lpep Dropoff Datetime
2016-01-01T02:17:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965606689453125
Pickup Latitude
40.6920166015625
Dropoff Longitude
-73.886276245117188
Dropoff Latitude
40.751594543457031
Passenger Count
1
Trip Distance
8.39
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:53.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:53.000
Lpep Dropoff Datetime
2016-01-01T02:17:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960647583007813
Pickup Latitude
40.598335266113281
Dropoff Longitude
-73.998329162597656
Dropoff Latitude
40.647911071777344
Passenger Count
2
Trip Distance
5.25
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:53:51.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:51.000
Lpep Dropoff Datetime
2016-01-01T02:17:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.97613525390625
Pickup Latitude
40.681919097900391
Dropoff Longitude
-73.948219299316406
Dropoff Latitude
40.770408630371094
Passenger Count
1
Trip Distance
8.95
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
5.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:43:47.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:47.000
Lpep Dropoff Datetime
2016-01-01T02:17:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94647216796875
Pickup Latitude
40.680160522460938
Dropoff Longitude
-73.954902648925781
Dropoff Latitude
40.742176055908203
Passenger Count
1
Trip Distance
6.34
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:57:17.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:57:17.000
Lpep Dropoff Datetime
2016-01-01T02:17:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92462158203125
Pickup Latitude
40.810787200927734
Dropoff Longitude
-73.941520690917969
Dropoff Latitude
40.717681884765625
Passenger Count
1
Trip Distance
9.56
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
34.84
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:01.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:01.000
Lpep Dropoff Datetime
2016-01-01T02:17:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902206420898438
Pickup Latitude
40.776035308837891
Dropoff Longitude
-73.693893432617188
Dropoff Latitude
40.662914276123047
Passenger Count
6
Trip Distance
17.97
Fare Amount
49
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
50.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:58:32.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:32.000
Lpep Dropoff Datetime
2016-01-01T02:17:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992355346679687
Pickup Latitude
40.700279235839844
Dropoff Longitude
-73.9324951171875
Dropoff Latitude
40.692070007324219
Passenger Count
1
Trip Distance
4.14
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-01T01:45:09.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:09.000
Lpep Dropoff Datetime
2016-01-01T02:17:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921150207519531
Pickup Latitude
40.707279205322266
Dropoff Longitude
-74.007270812988281
Dropoff Latitude
40.617023468017578
Passenger Count
2
Trip Distance
13.90
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:03.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:03.000
Lpep Dropoff Datetime
2016-01-01T02:17:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.971725463867188
Pickup Latitude
40.693248748779297
Dropoff Longitude
-73.880889892578125
Dropoff Latitude
40.646923065185547
Passenger Count
5
Trip Distance
6.87
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:58:48.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:48.000
Lpep Dropoff Datetime
2016-01-01T02:16:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.007957458496094
Pickup Latitude
40.644569396972656
Dropoff Longitude
-73.953529357910156
Dropoff Latitude
40.588695526123047
Passenger Count
6
Trip Distance
10.18
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:11.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:11.000
Lpep Dropoff Datetime
2016-01-01T02:17:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959434509277344
Pickup Latitude
40.733306884765625
Dropoff Longitude
-73.987678527832031
Dropoff Latitude
40.675601959228516
Passenger Count
1
Trip Distance
6.72
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:43.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:43.000
Lpep Dropoff Datetime
2016-01-01T02:17:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90838623046875
Pickup Latitude
40.853763580322266
Dropoff Longitude
-73.982208251953125
Dropoff Latitude
40.776405334472656
Passenger Count
1
Trip Distance
8.38
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:45.000 • Lpep Dropoff Datetime: 2016-01-02T01:44:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:45.000
Lpep Dropoff Datetime
2016-01-02T01:44:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960716247558594
Pickup Latitude
40.71881103515625
Dropoff Longitude
-73.983978271484375
Dropoff Latitude
40.727123260498047
Passenger Count
1
Trip Distance
3.28
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:15.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:15.000
Lpep Dropoff Datetime
2016-01-01T02:17:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953742980957031
Pickup Latitude
40.7108154296875
Dropoff Longitude
-73.95458984375
Dropoff Latitude
40.693187713623047
Passenger Count
1
Trip Distance
4.34
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:40:58.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:58.000
Lpep Dropoff Datetime
2016-01-01T02:16:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95672607421875
Pickup Latitude
40.802539825439453
Dropoff Longitude
-73.842414855957031
Dropoff Latitude
40.9207763671875
Passenger Count
1
Trip Distance
12.16
Fare Amount
37.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
38.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:52:57.000 • Lpep Dropoff Datetime: 2016-01-01T02:18:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:57.000
Lpep Dropoff Datetime
2016-01-01T02:18:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959831237792969
Pickup Latitude
40.813625335693359
Dropoff Longitude
-73.960128784179687
Dropoff Latitude
40.766258239746094
Passenger Count
1
Trip Distance
4.53
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
5.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:53:07.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:07.000
Lpep Dropoff Datetime
2016-01-01T02:16:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957939147949219
Pickup Latitude
40.714534759521484
Dropoff Longitude
-73.843162536621094
Dropoff Latitude
40.718647003173828
Passenger Count
1
Trip Distance
7.67
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:40:16.000 • Lpep Dropoff Datetime: 2016-01-01T02:18:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:16.000
Lpep Dropoff Datetime
2016-01-01T02:18:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951576232910156
Pickup Latitude
40.716072082519531
Dropoff Longitude
-73.961776733398438
Dropoff Latitude
40.654323577880859
Passenger Count
5
Trip Distance
9.25
Fare Amount
33.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:05.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:05.000
Lpep Dropoff Datetime
2016-01-01T02:16:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902702331542969
Pickup Latitude
40.775619506835938
Dropoff Longitude
-73.862312316894531
Dropoff Latitude
40.695896148681641
Passenger Count
1
Trip Distance
10.67
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:53.000 • Lpep Dropoff Datetime: 2016-01-01T02:16:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:53.000
Lpep Dropoff Datetime
2016-01-01T02:16:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933906555175781
Pickup Latitude
40.668605804443359
Dropoff Longitude
-73.922103881835938
Dropoff Latitude
40.708583831787109
Passenger Count
1
Trip Distance
3.70
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-01T01:55:15.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:15.000
Lpep Dropoff Datetime
2016-01-01T02:17:07.000
Store And Fwd Flag
N
Ratecodeid
4
Pickup Longitude
-73.892402648925781
Pickup Latitude
40.824489593505859
Dropoff Longitude
-73.779830932617188
Dropoff Latitude
40.917373657226563
Passenger Count
1
Trip Distance
11.77
Fare Amount
39
Extra
0.5
Mta Tax
0
Tip Amount
9.88
Tolls Amount
0
Improvement Surcharge
0
Total Amount
49.38
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:50:10.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:10.000
Lpep Dropoff Datetime
2016-01-01T02:17:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943901062011719
Pickup Latitude
40.714618682861328
Dropoff Longitude
-74.001449584960938
Dropoff Latitude
40.727863311767578
Passenger Count
1
Trip Distance
3.69
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.55
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:48:35.000 • Lpep Dropoff Datetime: 2016-01-01T02:18:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:35.000
Lpep Dropoff Datetime
2016-01-01T02:18:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913589477539062
Pickup Latitude
40.763202667236328
Dropoff Longitude
-73.943313598632813
Dropoff Latitude
40.810596466064453
Passenger Count
2
Trip Distance
7.65
Fare Amount
26
Extra
0.5
Mta Tax
0.5
Tip Amount
5.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:58:45.000 • Lpep Dropoff Datetime: 2016-01-01T02:18:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:45.000
Lpep Dropoff Datetime
2016-01-01T02:18:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919296264648438
Pickup Latitude
40.758590698242188
Dropoff Longitude
-73.960121154785156
Dropoff Latitude
40.714191436767578
Passenger Count
1
Trip Distance
7.15
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-01T01:59:33.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:33.000
Lpep Dropoff Datetime
2016-01-01T02:17:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.904151916503906
Pickup Latitude
40.876388549804688
Dropoff Longitude
-73.955818176269531
Dropoff Latitude
40.803878784179688
Passenger Count
1
Trip Distance
7.51
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:42.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:42.000
Lpep Dropoff Datetime
2016-01-01T02:17:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8443603515625
Pickup Latitude
40.721378326416016
Dropoff Longitude
-73.880706787109375
Dropoff Latitude
40.745330810546875
Passenger Count
1
Trip Distance
3.28
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-01T01:41:03.000 • Lpep Dropoff Datetime: 2016-01-01T02:18:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:03.000
Lpep Dropoff Datetime
2016-01-01T02:18:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914176940917969
Pickup Latitude
40.701213836669922
Dropoff Longitude
-73.971107482910156
Dropoff Latitude
40.672943115234375
Passenger Count
1
Trip Distance
7.17
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
7.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:04.000 • Lpep Dropoff Datetime: 2016-01-01T02:17:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:04.000
Lpep Dropoff Datetime
2016-01-01T02:17:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890785217285156
Pickup Latitude
40.746498107910156
Dropoff Longitude
-73.748809814453125
Dropoff Latitude
40.75579833984375
Passenger Count
6
Trip Distance
11.59
Fare Amount
34.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:09.000 • Lpep Dropoff Datetime: 2016-01-01T02:18:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:09.000
Lpep Dropoff Datetime
2016-01-01T02:18:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917716979980469
Pickup Latitude
40.738792419433594
Dropoff Longitude
-73.851615905761719
Dropoff Latitude
40.742786407470703
Passenger Count
1
Trip Distance
4.53
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