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:50:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:20.000
Lpep Dropoff Datetime
2016-01-01T01:02:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942108154296875
Pickup Latitude
40.70892333984375
Dropoff Longitude
-73.983634948730469
Dropoff Latitude
40.694019317626953
Passenger Count
1
Trip Distance
3.82
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:37.000
Lpep Dropoff Datetime
2016-01-01T01:02:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950401306152344
Pickup Latitude
40.706684112548828
Dropoff Longitude
-73.938507080078125
Dropoff Latitude
40.703857421875
Passenger Count
1
Trip Distance
1.03
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:37:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:22.000
Lpep Dropoff Datetime
2016-01-01T01:02:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.929100036621094
Pickup Latitude
40.698692321777344
Dropoff Longitude
-73.989944458007813
Dropoff Latitude
40.68829345703125
Passenger Count
1
Trip Distance
4.04
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.97
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.77
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:52.000
Lpep Dropoff Datetime
2016-01-01T01:01:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94866943359375
Pickup Latitude
40.823856353759766
Dropoff Longitude
-73.939552307128906
Dropoff Latitude
40.850086212158203
Passenger Count
1
Trip Distance
2.76
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:56.000
Lpep Dropoff Datetime
2016-01-01T01:02:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952125549316406
Pickup Latitude
40.823978424072266
Dropoff Longitude
-73.942604064941406
Dropoff Latitude
40.840095520019531
Passenger Count
1
Trip Distance
1.29
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:48:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:55.000
Lpep Dropoff Datetime
2016-01-01T01:02:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96295166015625
Pickup Latitude
40.711925506591797
Dropoff Longitude
-73.992805480957031
Dropoff Latitude
40.723598480224609
Passenger Count
5
Trip Distance
2.75
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:48:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:51.000
Lpep Dropoff Datetime
2016-01-01T01:01:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94921875
Pickup Latitude
40.711170196533203
Dropoff Longitude
-73.972808837890625
Dropoff Latitude
40.687610626220703
Passenger Count
1
Trip Distance
2.79
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:20.000
Lpep Dropoff Datetime
2016-01-01T01:01:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921096801757813
Pickup Latitude
40.863914489746094
Dropoff Longitude
-73.925041198730469
Dropoff Latitude
40.866279602050781
Passenger Count
1
Trip Distance
0.21
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:49.000
Lpep Dropoff Datetime
2016-01-01T01:01:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957809448242188
Pickup Latitude
40.717742919921875
Dropoff Longitude
-73.990554809570313
Dropoff Latitude
40.640422821044922
Passenger Count
1
Trip Distance
9.02
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-01T00:55:19.000 • Lpep Dropoff Datetime: 2016-01-02T00:43:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:19.000
Lpep Dropoff Datetime
2016-01-02T00:43:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921966552734375
Pickup Latitude
40.766220092773438
Dropoff Longitude
-73.90924072265625
Dropoff Latitude
40.771770477294922
Passenger Count
1
Trip Distance
0.99
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:24.000
Lpep Dropoff Datetime
2016-01-01T01:01:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956016540527344
Pickup Latitude
40.664684295654297
Dropoff Longitude
-73.988693237304688
Dropoff Latitude
40.668682098388672
Passenger Count
1
Trip Distance
3.01
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:46:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:36.000
Lpep Dropoff Datetime
2016-01-01T01:02:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.84332275390625
Pickup Latitude
40.862442016601563
Dropoff Longitude
-73.868614196777344
Dropoff Latitude
40.833747863769531
Passenger Count
1
Trip Distance
3.39
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:26.000
Lpep Dropoff Datetime
2016-01-01T01:01:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.888633728027344
Pickup Latitude
40.747016906738281
Dropoff Longitude
-73.866905212402344
Dropoff Latitude
40.741741180419922
Passenger Count
1
Trip Distance
1.83
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:33.000
Lpep Dropoff Datetime
2016-01-01T01:02:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.86602783203125
Pickup Latitude
40.667587280273437
Dropoff Longitude
-74.014060974121094
Dropoff Latitude
40.650131225585937
Passenger Count
1
Trip Distance
10.45
Fare Amount
37.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
40
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:38.000
Lpep Dropoff Datetime
2016-01-01T01:01:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911056518554688
Pickup Latitude
40.768672943115234
Dropoff Longitude
-73.849456787109375
Dropoff Latitude
40.724582672119141
Passenger Count
1
Trip Distance
6.35
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-01T00:57:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:12.000
Lpep Dropoff Datetime
2016-01-01T01:02:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.880302429199219
Pickup Latitude
40.828605651855469
Dropoff Longitude
-73.895561218261719
Dropoff Latitude
40.821033477783203
Passenger Count
1
Trip Distance
1.02
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:57:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:17.000
Lpep Dropoff Datetime
2016-01-01T01:01:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.869338989257813
Pickup Latitude
40.748859405517578
Dropoff Longitude
-73.863525390625
Dropoff Latitude
40.737297058105469
Passenger Count
1
Trip Distance
1.03
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:52:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:10.000
Lpep Dropoff Datetime
2016-01-01T01:02:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965530395507813
Pickup Latitude
40.683223724365234
Dropoff Longitude
-73.943916320800781
Dropoff Latitude
40.683204650878906
Passenger Count
1
Trip Distance
1.58
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:01.000
Lpep Dropoff Datetime
2016-01-01T01:02:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945304870605469
Pickup Latitude
40.725547790527344
Dropoff Longitude
-73.953865051269531
Dropoff Latitude
40.683177947998047
Passenger Count
1
Trip Distance
3.70
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:54:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:51.000
Lpep Dropoff Datetime
2016-01-01T01:01:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.89093017578125
Pickup Latitude
40.747001647949219
Dropoff Longitude
-73.896018981933594
Dropoff Latitude
40.734912872314453
Passenger Count
1
Trip Distance
1.19
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:51:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:33.000
Lpep Dropoff Datetime
2016-01-01T01:01:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.883949279785156
Pickup Latitude
40.747615814208984
Dropoff Longitude
-73.875556945800781
Dropoff Latitude
40.731121063232422
Passenger Count
5
Trip Distance
1.62
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:57.000
Lpep Dropoff Datetime
2016-01-01T01:02:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.877838134765625
Pickup Latitude
40.75640869140625
Dropoff Longitude
-73.956680297851563
Dropoff Latitude
40.745960235595703
Passenger Count
1
Trip Distance
4.46
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:47:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:47.000
Lpep Dropoff Datetime
2016-01-01T01:02:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976295471191406
Pickup Latitude
40.682483673095703
Dropoff Longitude
-73.95050048828125
Dropoff Latitude
40.714023590087891
Passenger Count
3
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-01T00:53:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:41.000
Lpep Dropoff Datetime
2016-01-01T01:02:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949874877929688
Pickup Latitude
40.785434722900391
Dropoff Longitude
-73.979774475097656
Dropoff Latitude
40.775825500488281
Passenger Count
1
Trip Distance
2.52
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
2.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:26.000
Lpep Dropoff Datetime
2016-01-01T01:02:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938430786132813
Pickup Latitude
40.721614837646484
Dropoff Longitude
-73.9451904296875
Dropoff Latitude
40.695098876953125
Passenger Count
1
Trip Distance
2.78
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:11.000
Lpep Dropoff Datetime
2016-01-01T01:02:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.898033142089844
Pickup Latitude
40.883918762207031
Dropoff Longitude
-73.862846374511719
Dropoff Latitude
40.855880737304688
Passenger Count
1
Trip Distance
4.09
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:41:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:16.000
Lpep Dropoff Datetime
2016-01-01T01:00:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965965270996094
Pickup Latitude
40.710647583007812
Dropoff Longitude
-73.980865478515625
Dropoff Latitude
40.691986083984375
Passenger Count
1
Trip Distance
3.21
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:43:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:03.000
Lpep Dropoff Datetime
2016-01-01T01:02:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91656494140625
Pickup Latitude
40.744613647460938
Dropoff Longitude
-73.992446899414062
Dropoff Latitude
40.685043334960937
Passenger Count
1
Trip Distance
7.88
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:55.000
Lpep Dropoff Datetime
2016-01-01T01:02:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937591552734375
Pickup Latitude
40.804275512695313
Dropoff Longitude
-73.941802978515625
Dropoff Latitude
40.791542053222656
Passenger Count
1
Trip Distance
0.93
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:37:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:03.000
Lpep Dropoff Datetime
2016-01-01T01:02:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926460266113281
Pickup Latitude
40.689048767089844
Dropoff Longitude
-73.947357177734375
Dropoff Latitude
40.674171447753906
Passenger Count
1
Trip Distance
3.58
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-01T00:56:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:33.000
Lpep Dropoff Datetime
2016-01-01T01:02:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950965881347656
Pickup Latitude
40.724021911621094
Dropoff Longitude
-73.939422607421875
Dropoff Latitude
40.724197387695313
Passenger Count
1
Trip Distance
0.94
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:34.000
Lpep Dropoff Datetime
2016-01-01T01:01:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968452453613281
Pickup Latitude
40.710933685302734
Dropoff Longitude
-73.957443237304688
Dropoff Latitude
40.729907989501953
Passenger Count
1
Trip Distance
1.46
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:47:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:49.000
Lpep Dropoff Datetime
2016-01-01T01:02:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991439819335938
Pickup Latitude
40.6893310546875
Dropoff Longitude
-73.950927734375
Dropoff Latitude
40.724075317382813
Passenger Count
2
Trip Distance
4.15
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-01T00:48:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:57.000
Lpep Dropoff Datetime
2016-01-01T01:02:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923469543457031
Pickup Latitude
40.754787445068359
Dropoff Longitude
-73.886138916015625
Dropoff Latitude
40.749134063720703
Passenger Count
1
Trip Distance
2.50
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:33:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:28.000
Lpep Dropoff Datetime
2016-01-01T01:02:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807540893554687
Pickup Latitude
40.701030731201172
Dropoff Longitude
-73.923065185546875
Dropoff Latitude
40.687915802001953
Passenger Count
1
Trip Distance
10.07
Fare Amount
32
Extra
0.5
Mta Tax
0.5
Tip Amount
8.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
41.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:59:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:28.000
Lpep Dropoff Datetime
2016-01-01T00:59:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95086669921875
Pickup Latitude
40.785961151123047
Dropoff Longitude
-73.970863342285156
Dropoff Latitude
40.793441772460938
Passenger Count
1
Trip Distance
2.25
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:53:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:57.000
Lpep Dropoff Datetime
2016-01-01T01:02:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.928192138671875
Pickup Latitude
40.758388519287109
Dropoff Longitude
-73.923896789550781
Dropoff Latitude
40.772518157958984
Passenger Count
1
Trip Distance
1.44
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:52:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:55.000
Lpep Dropoff Datetime
2016-01-01T01:01:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935379028320313
Pickup Latitude
40.68798828125
Dropoff Longitude
-73.966560363769531
Dropoff Latitude
40.691768646240234
Passenger Count
1
Trip Distance
2.26
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:48:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:47.000
Lpep Dropoff Datetime
2016-01-01T01:00:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942344665527344
Pickup Latitude
40.837753295898438
Dropoff Longitude
-73.958343505859375
Dropoff Latitude
40.815364837646484
Passenger Count
1
Trip Distance
1.89
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:11.000
Lpep Dropoff Datetime
2016-01-01T01:02:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94970703125
Pickup Latitude
40.668930053710937
Dropoff Longitude
-73.949851989746094
Dropoff Latitude
40.707485198974609
Passenger Count
1
Trip Distance
2.96
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:20.000
Lpep Dropoff Datetime
2016-01-01T01:01:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93084716796875
Pickup Latitude
40.666080474853516
Dropoff Longitude
-73.965499877929688
Dropoff Latitude
40.691936492919922
Passenger Count
1
Trip Distance
3.77
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:19.000
Lpep Dropoff Datetime
2016-01-01T01:01:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960075378417969
Pickup Latitude
40.715656280517578
Dropoff Longitude
-73.957931518554687
Dropoff Latitude
40.714519500732422
Passenger Count
1
Trip Distance
0.35
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:58.000
Lpep Dropoff Datetime
2016-01-01T01:02:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990676879882813
Pickup Latitude
40.664051055908203
Dropoff Longitude
-73.991081237792969
Dropoff Latitude
40.663532257080078
Passenger Count
1
Trip Distance
2.01
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:44:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:39.000
Lpep Dropoff Datetime
2016-01-01T01:01:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.875396728515625
Pickup Latitude
40.748672485351563
Dropoff Longitude
-73.919647216796875
Dropoff Latitude
40.759323120117188
Passenger Count
1
Trip Distance
2.52
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:22.000
Lpep Dropoff Datetime
2016-01-01T01:01:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.898788452148438
Pickup Latitude
40.746109008789063
Dropoff Longitude
-73.880355834960938
Dropoff Latitude
40.758247375488281
Passenger Count
1
Trip Distance
1.63
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:43.000
Lpep Dropoff Datetime
2016-01-01T01:02:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942237854003906
Pickup Latitude
40.754158020019531
Dropoff Longitude
-73.910903930664063
Dropoff Latitude
40.776290893554688
Passenger Count
1
Trip Distance
2.71
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:57:54.000 • Lpep Dropoff Datetime: 2016-01-02T00:42:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:54.000
Lpep Dropoff Datetime
2016-01-02T00:42:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94866943359375
Pickup Latitude
40.678558349609375
Dropoff Longitude
-73.957084655761719
Dropoff Latitude
40.690773010253906
Passenger Count
6
Trip Distance
1.16
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.4
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:32.000
Lpep Dropoff Datetime
2016-01-01T01:02:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938224792480469
Pickup Latitude
40.809043884277344
Dropoff Longitude
-73.943557739257813
Dropoff Latitude
40.825748443603516
Passenger Count
5
Trip Distance
2.59
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-01T00:40:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:34.000
Lpep Dropoff Datetime
2016-01-01T01:02:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992507934570313
Pickup Latitude
40.683498382568359
Dropoff Longitude
-73.96392822265625
Dropoff Latitude
40.651130676269531
Passenger Count
1
Trip Distance
5.69
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-01T00:51:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:01.000
Lpep Dropoff Datetime
2016-01-01T01:02:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937347412109375
Pickup Latitude
40.804279327392578
Dropoff Longitude
-73.91253662109375
Dropoff Latitude
40.819114685058594
Passenger Count
1
Trip Distance
2.12
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