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:30:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:38.000
Lpep Dropoff Datetime
2016-01-01T00:35:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959724426269531
Pickup Latitude
40.687599182128906
Dropoff Longitude
-73.96319580078125
Dropoff Latitude
40.674503326416016
Passenger Count
1
Trip Distance
1.16
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:27.000
Lpep Dropoff Datetime
2016-01-01T00:35:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.028617858886719
Pickup Latitude
40.622920989990234
Dropoff Longitude
-73.961647033691406
Dropoff Latitude
40.719432830810547
Passenger Count
1
Trip Distance
10.83
Fare Amount
31.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
39.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:23:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:43.000
Lpep Dropoff Datetime
2016-01-01T00:35:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922279357910156
Pickup Latitude
40.755199432373047
Dropoff Longitude
-73.9498291015625
Dropoff Latitude
40.711078643798828
Passenger Count
1
Trip Distance
4.15
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:20:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:00.000
Lpep Dropoff Datetime
2016-01-01T00:35:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945098876953125
Pickup Latitude
40.786933898925781
Dropoff Longitude
-73.881843566894531
Dropoff Latitude
40.882972717285156
Passenger Count
1
Trip Distance
9.09
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:17.000
Lpep Dropoff Datetime
2016-01-01T00:35:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961769104003906
Pickup Latitude
40.805496215820312
Dropoff Longitude
-73.952293395996094
Dropoff Latitude
40.804862976074219
Passenger Count
1
Trip Distance
1.01
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:33:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:33.000
Lpep Dropoff Datetime
2016-01-01T00:36:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942497253417969
Pickup Latitude
40.78631591796875
Dropoff Longitude
-73.940986633300781
Dropoff Latitude
40.794158935546875
Passenger Count
1
Trip Distance
0.71
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
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:19:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:34.000
Lpep Dropoff Datetime
2016-01-01T00:35:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943557739257813
Pickup Latitude
40.707290649414063
Dropoff Longitude
-73.926040649414063
Dropoff Latitude
40.775653839111328
Passenger Count
1
Trip Distance
7.34
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:51.000
Lpep Dropoff Datetime
2016-01-01T00:36:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.862113952636719
Pickup Latitude
40.730396270751953
Dropoff Longitude
-73.850112915039063
Dropoff Latitude
40.734283447265625
Passenger Count
2
Trip Distance
0.69
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:54.000 • Lpep Dropoff Datetime: 2016-01-02T00:23:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:54.000
Lpep Dropoff Datetime
2016-01-02T00:23:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963111877441406
Pickup Latitude
40.674671173095703
Dropoff Longitude
-73.956855773925781
Dropoff Latitude
40.687141418457031
Passenger Count
1
Trip Distance
1.31
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:03.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:03.000
Lpep Dropoff Datetime
2016-01-01T00:35:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952705383300781
Pickup Latitude
40.725120544433594
Dropoff Longitude
-73.949455261230469
Dropoff Latitude
40.718429565429687
Passenger Count
1
Trip Distance
0.53
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:24:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:35.000
Lpep Dropoff Datetime
2016-01-01T00:36:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957420349121094
Pickup Latitude
40.672252655029297
Dropoff Longitude
-73.938240051269531
Dropoff Latitude
40.679836273193359
Passenger Count
1
Trip Distance
2.10
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:25.000
Lpep Dropoff Datetime
2016-01-01T00:36:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936180114746094
Pickup Latitude
40.679676055908203
Dropoff Longitude
-73.938308715820313
Dropoff Latitude
40.679866790771484
Passenger Count
1
Trip Distance
0.11
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.8
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.6
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:10:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:19.000
Lpep Dropoff Datetime
2016-01-01T00:34:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952644348144531
Pickup Latitude
40.8082275390625
Dropoff Longitude
-73.985939025878906
Dropoff Latitude
40.726810455322266
Passenger Count
1
Trip Distance
7.50
Fare Amount
26
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:03.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:03.000
Lpep Dropoff Datetime
2016-01-01T00:36:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940658569335938
Pickup Latitude
40.824604034423828
Dropoff Longitude
-73.927085876464844
Dropoff Latitude
40.818557739257813
Passenger Count
1
Trip Distance
1.85
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:28.000
Lpep Dropoff Datetime
2016-01-01T00:35:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.880012512207031
Pickup Latitude
40.741050720214844
Dropoff Longitude
-73.8656005859375
Dropoff Latitude
40.736045837402344
Passenger Count
1
Trip Distance
1.21
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:21:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:00.000
Lpep Dropoff Datetime
2016-01-01T00:35:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.997138977050781
Pickup Latitude
40.66119384765625
Dropoff Longitude
-74.001945495605469
Dropoff Latitude
40.619781494140625
Passenger Count
2
Trip Distance
8.63
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-01T00:24:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:27.000
Lpep Dropoff Datetime
2016-01-01T00:35:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965446472167969
Pickup Latitude
40.716876983642578
Dropoff Longitude
-73.957107543945313
Dropoff Latitude
40.688388824462891
Passenger Count
1
Trip Distance
2.35
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:23:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:50.000
Lpep Dropoff Datetime
2016-01-01T00:35:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954917907714844
Pickup Latitude
40.787651062011719
Dropoff Longitude
-73.982902526855469
Dropoff Latitude
40.77569580078125
Passenger Count
1
Trip Distance
2.52
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:20:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:10.000
Lpep Dropoff Datetime
2016-01-01T00:34:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953140258789063
Pickup Latitude
40.807487487792969
Dropoff Longitude
-73.940696716308594
Dropoff Latitude
40.788833618164063
Passenger Count
1
Trip Distance
2.00
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:49.000
Lpep Dropoff Datetime
2016-01-01T00:36:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948188781738281
Pickup Latitude
40.687232971191406
Dropoff Longitude
-73.936782836914062
Dropoff Latitude
40.697589874267578
Passenger Count
1
Trip Distance
1.33
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:24:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:00.000
Lpep Dropoff Datetime
2016-01-01T00:34:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921432495117187
Pickup Latitude
40.756038665771484
Dropoff Longitude
-73.885032653808594
Dropoff Latitude
40.755588531494141
Passenger Count
1
Trip Distance
2.39
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:22:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:45.000
Lpep Dropoff Datetime
2016-01-01T00:35:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9464111328125
Pickup Latitude
40.811603546142578
Dropoff Longitude
-73.922203063964844
Dropoff Latitude
40.847465515136719
Passenger Count
1
Trip Distance
3.11
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:21:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:58.000
Lpep Dropoff Datetime
2016-01-01T00:36:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.853096008300781
Pickup Latitude
40.73748779296875
Dropoff Longitude
-73.949050903320313
Dropoff Latitude
40.754085540771484
Passenger Count
1
Trip Distance
6.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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:13.000
Lpep Dropoff Datetime
2016-01-01T00:35:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.904373168945313
Pickup Latitude
40.745521545410156
Dropoff Longitude
-73.901077270507813
Dropoff Latitude
40.753116607666016
Passenger Count
1
Trip Distance
1.11
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:30:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:24.000
Lpep Dropoff Datetime
2016-01-01T00:35:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.974067687988281
Pickup Latitude
40.657215118408203
Dropoff Longitude
-73.973373413085937
Dropoff Latitude
40.646842956542969
Passenger Count
1
Trip Distance
1.07
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:23:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:42.000
Lpep Dropoff Datetime
2016-01-01T00:36:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991378784179688
Pickup Latitude
40.689441680908203
Dropoff Longitude
-73.973243713378906
Dropoff Latitude
40.645359039306641
Passenger Count
1
Trip Distance
4.56
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:24:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:32.000
Lpep Dropoff Datetime
2016-01-01T00:36:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918914794921875
Pickup Latitude
40.742996215820313
Dropoff Longitude
-73.983268737792969
Dropoff Latitude
40.699878692626953
Passenger Count
1
Trip Distance
5.76
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:07:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:07:18.000
Lpep Dropoff Datetime
2016-01-01T00:36:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952606201171875
Pickup Latitude
40.718666076660156
Dropoff Longitude
-73.976753234863281
Dropoff Latitude
40.792587280273438
Passenger Count
1
Trip Distance
7.66
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:40.000
Lpep Dropoff Datetime
2016-01-01T00:36:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957839965820312
Pickup Latitude
40.721843719482422
Dropoff Longitude
-74.002876281738281
Dropoff Latitude
40.652488708496094
Passenger Count
1
Trip Distance
8.46
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
30
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
56.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:20:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:49.000
Lpep Dropoff Datetime
2016-01-01T00:36:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.974334716796875
Pickup Latitude
40.686305999755859
Dropoff Longitude
-73.924827575683594
Dropoff Latitude
40.686214447021484
Passenger Count
1
Trip Distance
3.41
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:52.000
Lpep Dropoff Datetime
2016-01-01T00:36:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925216674804687
Pickup Latitude
40.75537109375
Dropoff Longitude
-73.915969848632812
Dropoff Latitude
40.757545471191406
Passenger Count
1
Trip Distance
0.81
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:04.000
Lpep Dropoff Datetime
2016-01-01T00:35:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956298828125
Pickup Latitude
40.681266784667969
Dropoff Longitude
-73.950538635253906
Dropoff Latitude
40.679794311523438
Passenger Count
1
Trip Distance
0.59
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:26:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:49.000
Lpep Dropoff Datetime
2016-01-01T00:35:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.934104919433594
Pickup Latitude
40.751361846923828
Dropoff Longitude
-73.912559509277344
Dropoff Latitude
40.769580841064453
Passenger Count
1
Trip Distance
1.79
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:25:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:08.000
Lpep Dropoff Datetime
2016-01-01T00:35:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908790588378906
Pickup Latitude
40.745105743408203
Dropoff Longitude
-73.878707885742187
Dropoff Latitude
40.756172180175781
Passenger Count
1
Trip Distance
2.23
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:23:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:16.000
Lpep Dropoff Datetime
2016-01-01T00:35:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896644592285156
Pickup Latitude
40.746131896972656
Dropoff Longitude
-73.860374450683594
Dropoff Latitude
40.735923767089844
Passenger Count
1
Trip Distance
2.73
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:20:07.000 • Lpep Dropoff Datetime: 2016-01-02T00:06:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:07.000
Lpep Dropoff Datetime
2016-01-02T00:06:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957809448242188
Pickup Latitude
40.721988677978516
Dropoff Longitude
-73.978378295898437
Dropoff Latitude
40.724826812744141
Passenger Count
1
Trip Distance
3.37
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:31:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:32.000
Lpep Dropoff Datetime
2016-01-01T00:36:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991806030273437
Pickup Latitude
40.699722290039062
Dropoff Longitude
-73.999626159667969
Dropoff Latitude
40.683620452880859
Passenger Count
1
Trip Distance
1.18
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:23.000
Lpep Dropoff Datetime
2016-01-01T00:36:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.906257629394531
Pickup Latitude
40.745376586914063
Dropoff Longitude
-73.887565612792969
Dropoff Latitude
40.747215270996094
Passenger Count
5
Trip Distance
0.98
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:24:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:37.000
Lpep Dropoff Datetime
2016-01-01T00:35:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939552307128906
Pickup Latitude
40.838741302490234
Dropoff Longitude
-73.955070495605469
Dropoff Latitude
40.827033996582031
Passenger Count
1
Trip Distance
1.82
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:13.000
Lpep Dropoff Datetime
2016-01-01T00:36:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9189453125
Pickup Latitude
40.765705108642578
Dropoff Longitude
-73.91912841796875
Dropoff Latitude
40.757488250732422
Passenger Count
1
Trip Distance
0.86
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:20:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:13.000
Lpep Dropoff Datetime
2016-01-01T00:35:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.855987548828125
Pickup Latitude
40.751792907714844
Dropoff Longitude
-73.914382934570313
Dropoff Latitude
40.753849029541016
Passenger Count
1
Trip Distance
3.68
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:29:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:08.000
Lpep Dropoff Datetime
2016-01-01T00:36:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954917907714844
Pickup Latitude
40.688812255859375
Dropoff Longitude
-73.978057861328125
Dropoff Latitude
40.695999145507813
Passenger Count
1
Trip Distance
1.74
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:18:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:25.000
Lpep Dropoff Datetime
2016-01-01T00:35:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942703247070313
Pickup Latitude
40.704402923583984
Dropoff Longitude
-73.911048889160156
Dropoff Latitude
40.675312042236328
Passenger Count
1
Trip Distance
0.00
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:25:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:44.000
Lpep Dropoff Datetime
2016-01-01T00:36:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920982360839844
Pickup Latitude
40.767601013183594
Dropoff Longitude
-73.853919982910156
Dropoff Latitude
40.752288818359375
Passenger Count
1
Trip Distance
4.59
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:46.000
Lpep Dropoff Datetime
2016-01-01T00:35:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926689147949219
Pickup Latitude
40.760452270507813
Dropoff Longitude
-73.940475463867187
Dropoff Latitude
40.763481140136719
Passenger Count
1
Trip Distance
0.87
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:26:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:35:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:00.000
Lpep Dropoff Datetime
2016-01-01T00:35:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.872772216796875
Pickup Latitude
40.734477996826172
Dropoff Longitude
-73.869651794433594
Dropoff Latitude
40.748992919921875
Passenger Count
1
Trip Distance
1.51
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:29:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:45.000
Lpep Dropoff Datetime
2016-01-01T00:36:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.866111755371094
Pickup Latitude
40.877265930175781
Dropoff Longitude
-73.830612182617187
Dropoff Latitude
40.861808776855469
Passenger Count
1
Trip Distance
2.19
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:15:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:24.000
Lpep Dropoff Datetime
2016-01-01T00:36:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844161987304687
Pickup Latitude
40.721038818359375
Dropoff Longitude
-73.854049682617188
Dropoff Latitude
40.691154479980469
Passenger Count
1
Trip Distance
5.10
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
4.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:40.000
Lpep Dropoff Datetime
2016-01-01T00:36:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.885986328125
Pickup Latitude
40.744422912597656
Dropoff Longitude
-73.915107727050781
Dropoff Latitude
40.743480682373047
Passenger Count
2
Trip Distance
1.42
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:32:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:36:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:36.000
Lpep Dropoff Datetime
2016-01-01T00:36:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.876289367675781
Pickup Latitude
40.748561859130859
Dropoff Longitude
-73.886077880859375
Dropoff Latitude
40.747524261474609
Passenger Count
6
Trip Distance
0.51
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