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:39:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:25.000
Lpep Dropoff Datetime
2016-01-01T00:50:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947456359863281
Pickup Latitude
40.682842254638672
Dropoff Longitude
-73.957183837890625
Dropoff Latitude
40.718288421630859
Passenger Count
1
Trip Distance
3.11
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:13:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:38.000
Lpep Dropoff Datetime
2016-01-01T00:48:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955581665039063
Pickup Latitude
40.677284240722656
Dropoff Longitude
-73.759040832519531
Dropoff Latitude
40.706352233886719
Passenger Count
1
Trip Distance
14.00
Fare Amount
41.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
42.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:13.000
Lpep Dropoff Datetime
2016-01-01T00:51:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9925537109375
Pickup Latitude
40.693946838378906
Dropoff Longitude
-73.981117248535156
Dropoff Latitude
40.660026550292969
Passenger Count
1
Trip Distance
3.38
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:41:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:00.000
Lpep Dropoff Datetime
2016-01-01T00:51:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.916465759277344
Pickup Latitude
40.764568328857422
Dropoff Longitude
-73.885856628417969
Dropoff Latitude
40.747722625732422
Passenger Count
1
Trip Distance
2.93
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:46.000
Lpep Dropoff Datetime
2016-01-01T00:50:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90863037109375
Pickup Latitude
40.778068542480469
Dropoff Longitude
-73.905364990234375
Dropoff Latitude
40.773452758789063
Passenger Count
1
Trip Distance
0.35
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:24:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:22.000
Lpep Dropoff Datetime
2016-01-01T00:51:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987419128417969
Pickup Latitude
40.691337585449219
Dropoff Longitude
-73.915412902832031
Dropoff Latitude
40.704559326171875
Passenger Count
1
Trip Distance
4.65
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:48.000
Lpep Dropoff Datetime
2016-01-01T00:50:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951759338378906
Pickup Latitude
40.695125579833984
Dropoff Longitude
-73.957176208496094
Dropoff Latitude
40.689373016357422
Passenger Count
1
Trip Distance
0.69
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:47.000
Lpep Dropoff Datetime
2016-01-01T00:51:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957901000976563
Pickup Latitude
40.721893310546875
Dropoff Longitude
-73.957168579101563
Dropoff Latitude
40.672882080078125
Passenger Count
1
Trip Distance
3.81
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:32:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:44.000
Lpep Dropoff Datetime
2016-01-01T00:51:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.862564086914062
Pickup Latitude
40.730110168457031
Dropoff Longitude
-73.888069152832031
Dropoff Latitude
40.747344970703125
Passenger Count
1
Trip Distance
2.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:44:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:39.000
Lpep Dropoff Datetime
2016-01-01T00:50:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.829475402832031
Pickup Latitude
40.709491729736328
Dropoff Longitude
-73.815559387207031
Dropoff Latitude
40.710727691650391
Passenger Count
1
Trip Distance
1.35
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:33:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:00.000
Lpep Dropoff Datetime
2016-01-01T00:51:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940803527832031
Pickup Latitude
40.708377838134766
Dropoff Longitude
-73.973457336425781
Dropoff Latitude
40.647182464599609
Passenger Count
1
Trip Distance
8.74
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:24:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:04.000
Lpep Dropoff Datetime
2016-01-01T00:52:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940521240234375
Pickup Latitude
40.840263366699219
Dropoff Longitude
-73.997154235839844
Dropoff Latitude
40.736591339111328
Passenger Count
1
Trip Distance
12.07
Fare Amount
35.5
Extra
0.5
Mta Tax
0.5
Tip Amount
7.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
44.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:56.000
Lpep Dropoff Datetime
2016-01-01T00:51:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961875915527344
Pickup Latitude
40.683906555175781
Dropoff Longitude
-73.962417602539062
Dropoff Latitude
40.710029602050781
Passenger Count
1
Trip Distance
2.80
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:37:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:46.000
Lpep Dropoff Datetime
2016-01-01T00:51:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807037353515625
Pickup Latitude
40.699222564697266
Dropoff Longitude
-73.749214172363281
Dropoff Latitude
40.707355499267578
Passenger Count
1
Trip Distance
3.58
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:45:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:22.000
Lpep Dropoff Datetime
2016-01-01T00:52:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.934616088867188
Pickup Latitude
40.712860107421875
Dropoff Longitude
-73.921669006347656
Dropoff Latitude
40.706588745117187
Passenger Count
1
Trip Distance
1.39
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:44:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:47.000
Lpep Dropoff Datetime
2016-01-01T00:51:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903427124023438
Pickup Latitude
40.745464324951172
Dropoff Longitude
-73.906455993652344
Dropoff Latitude
40.739070892333984
Passenger Count
1
Trip Distance
0.91
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:39:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:21.000
Lpep Dropoff Datetime
2016-01-01T00:51:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.842941284179687
Pickup Latitude
40.720958709716797
Dropoff Longitude
-73.7891845703125
Dropoff Latitude
40.711956024169922
Passenger Count
1
Trip Distance
3.48
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:30.000
Lpep Dropoff Datetime
2016-01-01T00:51:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.886459350585938
Pickup Latitude
40.74951171875
Dropoff Longitude
-73.862808227539063
Dropoff Latitude
40.753700256347656
Passenger Count
3
Trip Distance
1.21
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:42:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:51.000
Lpep Dropoff Datetime
2016-01-01T00:52:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941452026367188
Pickup Latitude
40.676826477050781
Dropoff Longitude
-73.971687316894531
Dropoff Latitude
40.687458038330078
Passenger Count
1
Trip Distance
2.01
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
2.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:47.000
Lpep Dropoff Datetime
2016-01-01T00:51:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957649230957031
Pickup Latitude
40.722179412841797
Dropoff Longitude
-74.013526916503906
Dropoff Latitude
40.702419281005859
Passenger Count
1
Trip Distance
5.88
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
5.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:44.000
Lpep Dropoff Datetime
2016-01-01T00:51:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990676879882813
Pickup Latitude
40.699970245361328
Dropoff Longitude
-73.958000183105469
Dropoff Latitude
40.710842132568359
Passenger Count
1
Trip Distance
2.81
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
3.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:05.000
Lpep Dropoff Datetime
2016-01-01T00:51:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951622009277344
Pickup Latitude
40.715095520019531
Dropoff Longitude
-73.948043823242188
Dropoff Latitude
40.676795959472656
Passenger Count
1
Trip Distance
3.36
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
3.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:42.000
Lpep Dropoff Datetime
2016-01-01T00:51:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951141357421875
Pickup Latitude
40.825611114501953
Dropoff Longitude
-73.919990539550781
Dropoff Latitude
40.861583709716797
Passenger Count
1
Trip Distance
3.78
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:46:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:12.000
Lpep Dropoff Datetime
2016-01-01T00:52:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979995727539063
Pickup Latitude
40.681743621826172
Dropoff Longitude
-73.954391479492188
Dropoff Latitude
40.675628662109375
Passenger Count
1
Trip Distance
1.44
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:50.000
Lpep Dropoff Datetime
2016-01-01T00:52:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924995422363281
Pickup Latitude
40.744102478027344
Dropoff Longitude
-73.921356201171875
Dropoff Latitude
40.755989074707031
Passenger Count
1
Trip Distance
0.91
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:50:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:42.000
Lpep Dropoff Datetime
2016-01-01T00:51:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915695190429687
Pickup Latitude
40.830673217773437
Dropoff Longitude
-73.916679382324219
Dropoff Latitude
40.828712463378906
Passenger Count
1
Trip Distance
0.07
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:34:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:34.000
Lpep Dropoff Datetime
2016-01-01T00:52:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.980545043945313
Pickup Latitude
40.664169311523438
Dropoff Longitude
-73.946304321289062
Dropoff Latitude
40.685993194580078
Passenger Count
2
Trip Distance
3.52
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:48:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:05.000
Lpep Dropoff Datetime
2016-01-01T00:51:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940628051757813
Pickup Latitude
40.839813232421875
Dropoff Longitude
-73.935218811035156
Dropoff Latitude
40.847816467285156
Passenger Count
1
Trip Distance
0.72
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:35.000
Lpep Dropoff Datetime
2016-01-01T00:51:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955154418945313
Pickup Latitude
40.804653167724609
Dropoff Longitude
-73.948959350585937
Dropoff Latitude
40.801673889160156
Passenger Count
1
Trip Distance
0.82
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:23:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:53.000
Lpep Dropoff Datetime
2016-01-01T00:50:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920883178710938
Pickup Latitude
40.767803192138672
Dropoff Longitude
-73.820106506347656
Dropoff Latitude
40.797260284423828
Passenger Count
1
Trip Distance
9.32
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-01T00:46:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:02.000
Lpep Dropoff Datetime
2016-01-01T00:52:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903549194335938
Pickup Latitude
40.745502471923828
Dropoff Longitude
-73.886497497558594
Dropoff Latitude
40.747222900390625
Passenger Count
1
Trip Distance
0.90
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:41:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:55.000
Lpep Dropoff Datetime
2016-01-01T00:51:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955490112304688
Pickup Latitude
40.806121826171875
Dropoff Longitude
-73.981086730957031
Dropoff Latitude
40.779209136962891
Passenger Count
1
Trip Distance
2.64
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:25:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:14.000
Lpep Dropoff Datetime
2016-01-01T00:51:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.974441528320312
Pickup Latitude
40.681606292724609
Dropoff Longitude
-73.957527160644531
Dropoff Latitude
40.769401550292969
Passenger Count
1
Trip Distance
9.00
Fare Amount
29
Extra
0.5
Mta Tax
0.5
Tip Amount
6.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:41.000
Lpep Dropoff Datetime
2016-01-01T00:52:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943099975585938
Pickup Latitude
40.705890655517578
Dropoff Longitude
-73.917793273925781
Dropoff Latitude
40.685745239257813
Passenger Count
1
Trip Distance
2.26
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:27.000
Lpep Dropoff Datetime
2016-01-01T00:52:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98297119140625
Pickup Latitude
40.673065185546875
Dropoff Longitude
-73.946807861328125
Dropoff Latitude
40.725086212158203
Passenger Count
3
Trip Distance
5.27
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:14:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:49:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:55.000
Lpep Dropoff Datetime
2016-01-01T00:49:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.97998046875
Pickup Latitude
40.676193237304688
Dropoff Longitude
-73.990867614746094
Dropoff Latitude
40.761020660400391
Passenger Count
5
Trip Distance
7.13
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:41.000
Lpep Dropoff Datetime
2016-01-01T00:52:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970855712890625
Pickup Latitude
40.693088531494141
Dropoff Longitude
-73.904609680175781
Dropoff Latitude
40.700290679931641
Passenger Count
1
Trip Distance
3.69
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:46.000
Lpep Dropoff Datetime
2016-01-01T00:52:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956123352050781
Pickup Latitude
40.802150726318359
Dropoff Longitude
-73.975791931152344
Dropoff Latitude
40.787925720214844
Passenger Count
1
Trip Distance
1.80
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:15.000
Lpep Dropoff Datetime
2016-01-01T00:52:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935035705566406
Pickup Latitude
40.682846069335937
Dropoff Longitude
-73.935989379882812
Dropoff Latitude
40.710830688476563
Passenger Count
1
Trip Distance
2.72
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:42:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:36.000
Lpep Dropoff Datetime
2016-01-01T00:52:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891021728515625
Pickup Latitude
40.845630645751953
Dropoff Longitude
-73.917915344238281
Dropoff Latitude
40.850868225097656
Passenger Count
1
Trip Distance
1.85
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:42:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:39.000
Lpep Dropoff Datetime
2016-01-01T00:52:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936630249023438
Pickup Latitude
40.710628509521484
Dropoff Longitude
-73.92767333984375
Dropoff Latitude
40.695735931396484
Passenger Count
1
Trip Distance
1.52
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:34:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:40.000
Lpep Dropoff Datetime
2016-01-01T00:48:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.874443054199219
Pickup Latitude
40.671440124511719
Dropoff Longitude
-73.911567687988281
Dropoff Latitude
40.640815734863281
Passenger Count
1
Trip Distance
4.38
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:39:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:13.000
Lpep Dropoff Datetime
2016-01-01T00:52:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95001220703125
Pickup Latitude
40.722160339355469
Dropoff Longitude
-73.92266845703125
Dropoff Latitude
40.708114624023437
Passenger Count
1
Trip Distance
2.41
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:25.000
Lpep Dropoff Datetime
2016-01-01T00:52:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93951416015625
Pickup Latitude
40.805213928222656
Dropoff Longitude
-73.938522338867188
Dropoff Latitude
40.804832458496094
Passenger Count
1
Trip Distance
0.06
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:45:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:47.000
Lpep Dropoff Datetime
2016-01-01T00:52:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945846557617188
Pickup Latitude
40.808021545410156
Dropoff Longitude
-73.950576782226563
Dropoff Latitude
40.799110412597656
Passenger Count
1
Trip Distance
1.02
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:43:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:36.000
Lpep Dropoff Datetime
2016-01-01T00:52:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890762329101563
Pickup Latitude
40.702301025390625
Dropoff Longitude
-73.905998229980469
Dropoff Latitude
40.709140777587891
Passenger Count
1
Trip Distance
1.38
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:45:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:13.000
Lpep Dropoff Datetime
2016-01-01T00:52:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.89093017578125
Pickup Latitude
40.746547698974609
Dropoff Longitude
-73.88623046875
Dropoff Latitude
40.765651702880859
Passenger Count
1
Trip Distance
2.29
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:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:56.000
Lpep Dropoff Datetime
2016-01-01T00:52:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911399841308594
Pickup Latitude
40.744510650634766
Dropoff Longitude
-73.887184143066406
Dropoff Latitude
40.747226715087891
Passenger Count
2
Trip Distance
1.26
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:43:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:53.000
Lpep Dropoff Datetime
2016-01-01T00:52:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993644714355469
Pickup Latitude
40.696052551269531
Dropoff Longitude
-73.983901977539062
Dropoff Latitude
40.6865234375
Passenger Count
1
Trip Distance
1.28
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:47:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:56.000
Lpep Dropoff Datetime
2016-01-01T00:51:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915679931640625
Pickup Latitude
40.830657958984375
Dropoff Longitude
-73.916984558105469
Dropoff Latitude
40.821147918701172
Passenger Count
1
Trip Distance
0.71
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1