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:12:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:51.000
Lpep Dropoff Datetime
2016-01-01T00:24:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956710815429687
Pickup Latitude
40.673728942871094
Dropoff Longitude
-73.997734069824219
Dropoff Latitude
40.674461364746094
Passenger Count
1
Trip Distance
2.85
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:16:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:56.000
Lpep Dropoff Datetime
2016-01-01T00:24:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.892601013183594
Pickup Latitude
40.748367309570313
Dropoff Longitude
-73.913536071777344
Dropoff Latitude
40.745418548583984
Passenger Count
1
Trip Distance
1.35
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:16:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:59.000
Lpep Dropoff Datetime
2016-01-01T00:24:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942970275878906
Pickup Latitude
40.811008453369141
Dropoff Longitude
-73.940811157226563
Dropoff Latitude
40.829395294189453
Passenger Count
1
Trip Distance
1.49
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:19:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:16.000
Lpep Dropoff Datetime
2016-01-01T00:24:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.99755859375
Pickup Latitude
40.691196441650391
Dropoff Longitude
-74.010978698730469
Dropoff Latitude
40.679046630859375
Passenger Count
1
Trip Distance
1.32
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:08:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:38.000
Lpep Dropoff Datetime
2016-01-01T00:23:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959671020507813
Pickup Latitude
40.667312622070313
Dropoff Longitude
-73.910377502441406
Dropoff Latitude
40.659198760986328
Passenger Count
1
Trip Distance
3.47
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:14:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:13.000
Lpep Dropoff Datetime
2016-01-01T00:24:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95782470703125
Pickup Latitude
40.721893310546875
Dropoff Longitude
-73.956550598144531
Dropoff Latitude
40.742542266845703
Passenger Count
5
Trip Distance
2.25
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:18:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:13.000
Lpep Dropoff Datetime
2016-01-01T00:24:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.984298706054688
Pickup Latitude
40.663593292236328
Dropoff Longitude
-73.983039855957031
Dropoff Latitude
40.677288055419922
Passenger Count
1
Trip Distance
1.27
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:21:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:23.000
Lpep Dropoff Datetime
2016-01-01T00:24:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919441223144531
Pickup Latitude
40.765975952148438
Dropoff Longitude
-73.929290771484375
Dropoff Latitude
40.767009735107422
Passenger Count
1
Trip Distance
0.68
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:19:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:02.000
Lpep Dropoff Datetime
2016-01-01T00:24:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912498474121094
Pickup Latitude
40.774913787841797
Dropoff Longitude
-73.910987854003906
Dropoff Latitude
40.761886596679688
Passenger Count
1
Trip Distance
1.14
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:10:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:07.000
Lpep Dropoff Datetime
2016-01-01T00:24:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942558288574219
Pickup Latitude
40.841033935546875
Dropoff Longitude
-73.979713439941406
Dropoff Latitude
40.738899230957031
Passenger Count
1
Trip Distance
10.11
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-01T00:09:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:09:01.000
Lpep Dropoff Datetime
2016-01-01T00:25:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924034118652344
Pickup Latitude
40.761367797851563
Dropoff Longitude
-73.95672607421875
Dropoff Latitude
40.720745086669922
Passenger Count
1
Trip Distance
4.59
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:15:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:35.000
Lpep Dropoff Datetime
2016-01-01T00:25:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994232177734375
Pickup Latitude
40.698776245117187
Dropoff Longitude
-73.967056274414063
Dropoff Latitude
40.694015502929687
Passenger Count
1
Trip Distance
2.02
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:18:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:05.000
Lpep Dropoff Datetime
2016-01-01T00:23:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944374084472656
Pickup Latitude
40.714595794677734
Dropoff Longitude
-73.94281005859375
Dropoff Latitude
40.732521057128906
Passenger Count
1
Trip Distance
1.23
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:16:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:06.000
Lpep Dropoff Datetime
2016-01-01T00:24:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969070434570313
Pickup Latitude
40.67254638671875
Dropoff Longitude
-73.942436218261719
Dropoff Latitude
40.661331176757813
Passenger Count
3
Trip Distance
2.02
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:34.000
Lpep Dropoff Datetime
2016-01-01T00:24:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962936401367188
Pickup Latitude
40.804092407226563
Dropoff Longitude
-73.934600830078125
Dropoff Latitude
40.848720550537109
Passenger Count
1
Trip Distance
4.05
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:22:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:15.000
Lpep Dropoff Datetime
2016-01-01T00:25:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942253112792969
Pickup Latitude
40.846126556396484
Dropoff Longitude
-73.942489624023437
Dropoff Latitude
40.837211608886719
Passenger Count
3
Trip Distance
0.74
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:11:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:07.000
Lpep Dropoff Datetime
2016-01-01T00:25:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.996475219726563
Pickup Latitude
40.690349578857422
Dropoff Longitude
-73.963150024414063
Dropoff Latitude
40.671680450439453
Passenger Count
1
Trip Distance
2.61
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:17:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:19.000
Lpep Dropoff Datetime
2016-01-01T00:24:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90301513671875
Pickup Latitude
40.746353149414063
Dropoff Longitude
-73.886642456054688
Dropoff Latitude
40.757362365722656
Passenger Count
1
Trip Distance
1.53
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:12:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:12:54.000
Lpep Dropoff Datetime
2016-01-01T00:25:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945770263671875
Pickup Latitude
40.812404632568359
Dropoff Longitude
-73.971389770507812
Dropoff Latitude
40.792640686035156
Passenger Count
1
Trip Distance
2.45
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:11:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:21.000
Lpep Dropoff Datetime
2016-01-01T00:25:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963233947753906
Pickup Latitude
40.718925476074219
Dropoff Longitude
-73.963943481445312
Dropoff Latitude
40.71923828125
Passenger Count
2
Trip Distance
1.56
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:03:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:03:45.000
Lpep Dropoff Datetime
2016-01-01T00:25:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961677551269531
Pickup Latitude
40.805381774902344
Dropoff Longitude
-73.925918579101563
Dropoff Latitude
40.824195861816406
Passenger Count
1
Trip Distance
3.51
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
5.49
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.79
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:21:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:48.000
Lpep Dropoff Datetime
2016-01-01T00:25:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978973388671875
Pickup Latitude
40.678440093994141
Dropoff Longitude
-73.974739074707031
Dropoff Latitude
40.677570343017578
Passenger Count
1
Trip Distance
0.42
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:04.000
Lpep Dropoff Datetime
2016-01-01T00:25:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937095642089844
Pickup Latitude
40.819431304931641
Dropoff Longitude
-73.910011291503906
Dropoff Latitude
40.801280975341797
Passenger Count
1
Trip Distance
2.89
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:10:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:11.000
Lpep Dropoff Datetime
2016-01-01T00:23:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.931472778320313
Pickup Latitude
40.852272033691406
Dropoff Longitude
-73.912849426269531
Dropoff Latitude
40.875820159912109
Passenger Count
1
Trip Distance
2.66
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:16:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:48.000
Lpep Dropoff Datetime
2016-01-01T00:25:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.830215454101563
Pickup Latitude
40.759544372558594
Dropoff Longitude
-73.813728332519531
Dropoff Latitude
40.784297943115234
Passenger Count
1
Trip Distance
2.35
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:13:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:23:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:24.000
Lpep Dropoff Datetime
2016-01-01T00:23:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.97283935546875
Pickup Latitude
40.693141937255859
Dropoff Longitude
-73.95635986328125
Dropoff Latitude
40.675300598144531
Passenger Count
1
Trip Distance
2.03
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:15:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:54.000
Lpep Dropoff Datetime
2016-01-01T00:25:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958297729492188
Pickup Latitude
40.658931732177734
Dropoff Longitude
-73.965667724609375
Dropoff Latitude
40.642654418945313
Passenger Count
1
Trip Distance
1.77
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:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:51.000
Lpep Dropoff Datetime
2016-01-01T00:25:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.899169921875
Pickup Latitude
40.745952606201172
Dropoff Longitude
-73.882621765136719
Dropoff Latitude
40.74761962890625
Passenger Count
2
Trip Distance
1.02
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:18:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:08.000
Lpep Dropoff Datetime
2016-01-01T00:25:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951576232910156
Pickup Latitude
40.824672698974609
Dropoff Longitude
-73.938270568847656
Dropoff Latitude
40.83795166015625
Passenger Count
1
Trip Distance
1.31
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:16:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:42.000
Lpep Dropoff Datetime
2016-01-01T00:24:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942390441894531
Pickup Latitude
40.753963470458984
Dropoff Longitude
-73.915863037109375
Dropoff Latitude
40.760166168212891
Passenger Count
1
Trip Distance
1.97
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:21:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:19.000
Lpep Dropoff Datetime
2016-01-01T00:25:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950630187988281
Pickup Latitude
40.785720825195313
Dropoff Longitude
-73.938140869140625
Dropoff Latitude
40.800491333007812
Passenger Count
1
Trip Distance
1.15
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:15:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:46.000
Lpep Dropoff Datetime
2016-01-01T00:25:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.76263427734375
Pickup Latitude
40.698932647705078
Dropoff Longitude
-73.801750183105469
Dropoff Latitude
40.702068328857422
Passenger Count
5
Trip Distance
2.42
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:59.000
Lpep Dropoff Datetime
2016-01-01T00:24:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.967514038085938
Pickup Latitude
40.710906982421875
Dropoff Longitude
-73.949981689453125
Dropoff Latitude
40.722393035888672
Passenger Count
1
Trip Distance
1.64
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:20:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:56.000
Lpep Dropoff Datetime
2016-01-01T00:24:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908195495605469
Pickup Latitude
40.753360748291016
Dropoff Longitude
-73.919235229492187
Dropoff Latitude
40.759113311767578
Passenger Count
1
Trip Distance
0.71
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:53.000
Lpep Dropoff Datetime
2016-01-01T00:25:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.872421264648438
Pickup Latitude
40.754444122314453
Dropoff Longitude
-73.856178283691406
Dropoff Latitude
40.738136291503906
Passenger Count
1
Trip Distance
1.67
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:20:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:18.000
Lpep Dropoff Datetime
2016-01-01T00:25:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957534790039063
Pickup Latitude
40.713760375976562
Dropoff Longitude
-73.945175170898437
Dropoff Latitude
40.712989807128906
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:11:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:11:18.000
Lpep Dropoff Datetime
2016-01-01T00:24:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.830520629882812
Pickup Latitude
40.759544372558594
Dropoff Longitude
-73.885040283203125
Dropoff Latitude
40.749042510986328
Passenger Count
1
Trip Distance
2.96
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:18:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:06.000
Lpep Dropoff Datetime
2016-01-01T00:25:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945938110351563
Pickup Latitude
40.807369232177734
Dropoff Longitude
-73.961158752441406
Dropoff Latitude
40.800167083740234
Passenger Count
1
Trip Distance
1.36
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:08:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:08:26.000
Lpep Dropoff Datetime
2016-01-01T00:24:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9869384765625
Pickup Latitude
40.690032958984375
Dropoff Longitude
-73.942718505859375
Dropoff Latitude
40.663906097412109
Passenger Count
1
Trip Distance
3.69
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:10:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:01.000
Lpep Dropoff Datetime
2016-01-01T00:25:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944931030273438
Pickup Latitude
40.799945831298828
Dropoff Longitude
-73.986968994140625
Dropoff Latitude
40.710323333740234
Passenger Count
1
Trip Distance
8.08
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-01T00:17:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:49.000
Lpep Dropoff Datetime
2016-01-01T00:25:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94879150390625
Pickup Latitude
40.823570251464844
Dropoff Longitude
-73.968070983886719
Dropoff Latitude
40.799789428710938
Passenger Count
1
Trip Distance
2.08
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:13:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:01.000
Lpep Dropoff Datetime
2016-01-01T00:25:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993331909179687
Pickup Latitude
40.682533264160156
Dropoff Longitude
-73.980293273925781
Dropoff Latitude
40.655288696289063
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:38.000 • Lpep Dropoff Datetime: 2016-01-02T00:00:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:38.000
Lpep Dropoff Datetime
2016-01-02T00:00:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920646667480469
Pickup Latitude
40.756557464599609
Dropoff Longitude
-73.890800476074219
Dropoff Latitude
40.742618560791016
Passenger Count
6
Trip Distance
2.18
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:19:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:51.000
Lpep Dropoff Datetime
2016-01-01T00:25:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955238342285156
Pickup Latitude
40.720050811767578
Dropoff Longitude
-73.943214416503906
Dropoff Latitude
40.718151092529297
Passenger Count
1
Trip Distance
0.80
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:13:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:25.000
Lpep Dropoff Datetime
2016-01-01T00:25:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994064331054688
Pickup Latitude
40.702793121337891
Dropoff Longitude
-73.979591369628906
Dropoff Latitude
40.734905242919922
Passenger Count
1
Trip Distance
5.16
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:20:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:46.000
Lpep Dropoff Datetime
2016-01-01T00:25:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95269775390625
Pickup Latitude
40.714183807373047
Dropoff Longitude
-73.940826416015625
Dropoff Latitude
40.725933074951172
Passenger Count
2
Trip Distance
1.17
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.49
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:15:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:24:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:11.000
Lpep Dropoff Datetime
2016-01-01T00:24:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993949890136719
Pickup Latitude
40.699249267578125
Dropoff Longitude
-74.016548156738281
Dropoff Latitude
40.716587066650391
Passenger Count
1
Trip Distance
2.49
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:18:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:05.000
Lpep Dropoff Datetime
2016-01-01T00:25:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954269409179688
Pickup Latitude
40.718471527099609
Dropoff Longitude
-73.95184326171875
Dropoff Latitude
40.707172393798828
Passenger Count
1
Trip Distance
1.23
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:05:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:42.000
Lpep Dropoff Datetime
2016-01-01T00:25:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957901000976563
Pickup Latitude
40.721797943115234
Dropoff Longitude
-74.004226684570313
Dropoff Latitude
40.723472595214844
Passenger Count
1
Trip Distance
3.54
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:17:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:25:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:29.000
Lpep Dropoff Datetime
2016-01-01T00:25:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987342834472656
Pickup Latitude
40.691085815429688
Dropoff Longitude
-74.001426696777344
Dropoff Latitude
40.685611724853516
Passenger Count
1
Trip Distance
1.24
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