2016 Green Taxi Trip Data

These records are generated from the trip record submissions made by green taxi Technology Service Providers (TSPs). Each row represents a single trip in a green taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.

Transportation Taxi and Limousine Commission (TLC) Dataset hvrh-b6nb 23 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:39:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:49.000
Lpep Dropoff Datetime
2016-01-01T01:57:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913444519042969
Pickup Latitude
40.763027191162109
Dropoff Longitude
-73.9522705078125
Dropoff Latitude
40.715118408203125
Passenger Count
1
Trip Distance
5.75
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-01T01:43:06.000 • Lpep Dropoff Datetime: 2016-01-02T01:41:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:06.000
Lpep Dropoff Datetime
2016-01-02T01:41:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959785461425781
Pickup Latitude
40.717868804931641
Dropoff Longitude
-73.955833435058594
Dropoff Latitude
40.746086120605469
Passenger Count
1
Trip Distance
2.53
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.92
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.72
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:51:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:22.000
Lpep Dropoff Datetime
2016-01-01T01:57:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.017074584960937
Pickup Latitude
40.675392150878906
Dropoff Longitude
-73.997421264648437
Dropoff Latitude
40.674518585205078
Passenger Count
1
Trip Distance
1.63
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:13.000
Lpep Dropoff Datetime
2016-01-01T01:57:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958450317382813
Pickup Latitude
40.743747711181641
Dropoff Longitude
-73.874656677246094
Dropoff Latitude
40.708950042724609
Passenger Count
1
Trip Distance
7.04
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
4.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:47.000
Lpep Dropoff Datetime
2016-01-01T01:57:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968292236328125
Pickup Latitude
40.695159912109375
Dropoff Longitude
-73.957687377929688
Dropoff Latitude
40.672458648681641
Passenger Count
1
Trip Distance
1.92
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.62
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.42
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:01.000
Lpep Dropoff Datetime
2016-01-01T01:57:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905319213867188
Pickup Latitude
40.74798583984375
Dropoff Longitude
-73.875770568847656
Dropoff Latitude
40.723541259765625
Passenger Count
1
Trip Distance
3.78
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:35.000
Lpep Dropoff Datetime
2016-01-01T01:57:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.907867431640625
Pickup Latitude
40.847713470458984
Dropoff Longitude
-73.94140625
Dropoff Latitude
40.833740234375
Passenger Count
1
Trip Distance
2.69
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-01T01:43:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:11.000
Lpep Dropoff Datetime
2016-01-01T01:57:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954536437988281
Pickup Latitude
40.805732727050781
Dropoff Longitude
-73.950851440429688
Dropoff Latitude
40.775825500488281
Passenger Count
1
Trip Distance
2.86
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:50:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:48.000
Lpep Dropoff Datetime
2016-01-01T01:56:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940200805664062
Pickup Latitude
40.789237976074219
Dropoff Longitude
-73.942939758300781
Dropoff Latitude
40.799240112304687
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:17.000
Lpep Dropoff Datetime
2016-01-01T01:57:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.997840881347656
Pickup Latitude
40.691150665283203
Dropoff Longitude
-73.959686279296875
Dropoff Latitude
40.682430267333984
Passenger Count
1
Trip Distance
2.40
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:54.000
Lpep Dropoff Datetime
2016-01-01T01:57:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957473754882813
Pickup Latitude
40.722225189208984
Dropoff Longitude
-73.986709594726563
Dropoff Latitude
40.688980102539063
Passenger Count
1
Trip Distance
4.18
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
10.8
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.6
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:43:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:09.000
Lpep Dropoff Datetime
2016-01-01T01:57:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.875938415527344
Pickup Latitude
40.839958190917969
Dropoff Longitude
-73.904335021972656
Dropoff Latitude
40.876113891601563
Passenger Count
5
Trip Distance
5.32
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:53:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:45.000
Lpep Dropoff Datetime
2016-01-01T01:57:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909461975097656
Pickup Latitude
40.775203704833984
Dropoff Longitude
-73.899116516113281
Dropoff Latitude
40.774654388427734
Passenger Count
1
Trip Distance
0.94
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-01T01:39:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:26.000
Lpep Dropoff Datetime
2016-01-01T01:56:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947921752929687
Pickup Latitude
40.796321868896484
Dropoff Longitude
-73.921234130859375
Dropoff Latitude
40.865253448486328
Passenger Count
1
Trip Distance
5.76
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:50:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:15.000
Lpep Dropoff Datetime
2016-01-01T01:57:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918312072753906
Pickup Latitude
40.770076751708984
Dropoff Longitude
-73.920722961425781
Dropoff Latitude
40.756847381591797
Passenger Count
1
Trip Distance
1.54
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-01T01:55:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:05.000
Lpep Dropoff Datetime
2016-01-01T01:57:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911872863769531
Pickup Latitude
40.775173187255859
Dropoff Longitude
-73.903633117675781
Dropoff Latitude
40.774791717529297
Passenger Count
1
Trip Distance
0.59
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-01T01:54:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:51.000
Lpep Dropoff Datetime
2016-01-01T01:56:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.869850158691406
Pickup Latitude
40.733627319335937
Dropoff Longitude
-73.867698669433594
Dropoff Latitude
40.722900390625
Passenger Count
1
Trip Distance
0.81
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-01T01:57:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:57:17.000
Lpep Dropoff Datetime
2016-01-01T01:57:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913154602050781
Pickup Latitude
40.840133666992188
Dropoff Longitude
-73.913475036621094
Dropoff Latitude
40.839431762695313
Passenger Count
1
Trip Distance
0.05
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-01T01:44:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:16.000
Lpep Dropoff Datetime
2016-01-01T01:57:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969985961914063
Pickup Latitude
40.693206787109375
Dropoff Longitude
-73.951614379882813
Dropoff Latitude
40.662265777587891
Passenger Count
1
Trip Distance
2.94
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:29:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:47.000
Lpep Dropoff Datetime
2016-01-01T01:56:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950294494628906
Pickup Latitude
40.683731079101563
Dropoff Longitude
-73.9989013671875
Dropoff Latitude
40.745517730712891
Passenger Count
1
Trip Distance
6.68
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
4.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:50:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:07.000
Lpep Dropoff Datetime
2016-01-01T01:57:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8841552734375
Pickup Latitude
40.747669219970703
Dropoff Longitude
-73.876792907714844
Dropoff Latitude
40.750026702880859
Passenger Count
1
Trip Distance
1.11
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-01T01:49:47.000 • Lpep Dropoff Datetime: 2016-01-02T01:46:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:49:47.000
Lpep Dropoff Datetime
2016-01-02T01:46:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.975738525390625
Pickup Latitude
40.686847686767578
Dropoff Longitude
-73.990966796875
Dropoff Latitude
40.6907958984375
Passenger Count
1
Trip Distance
0.95
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.17
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.97
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:35:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:32.000
Lpep Dropoff Datetime
2016-01-01T01:57:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952827453613281
Pickup Latitude
40.786788940429688
Dropoff Longitude
-73.9921875
Dropoff Latitude
40.768032073974609
Passenger Count
5
Trip Distance
3.38
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:31.000
Lpep Dropoff Datetime
2016-01-01T01:57:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.89984130859375
Pickup Latitude
40.768535614013672
Dropoff Longitude
-73.928298950195313
Dropoff Latitude
40.759723663330078
Passenger Count
1
Trip Distance
2.35
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-01T01:40:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:05.000
Lpep Dropoff Datetime
2016-01-01T01:57:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938796997070313
Pickup Latitude
40.791332244873047
Dropoff Longitude
-73.981315612792969
Dropoff Latitude
40.714427947998047
Passenger Count
1
Trip Distance
7.29
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
4.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:30:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:51.000
Lpep Dropoff Datetime
2016-01-01T01:57:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949691772460938
Pickup Latitude
40.721950531005859
Dropoff Longitude
-73.998680114746094
Dropoff Latitude
40.692710876464844
Passenger Count
1
Trip Distance
6.91
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:39:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:05.000
Lpep Dropoff Datetime
2016-01-01T01:57:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960350036621094
Pickup Latitude
40.657966613769531
Dropoff Longitude
-73.956932067871094
Dropoff Latitude
40.609401702880859
Passenger Count
1
Trip Distance
3.96
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
3.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:38:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:45.000
Lpep Dropoff Datetime
2016-01-01T01:57:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939773559570313
Pickup Latitude
40.707424163818359
Dropoff Longitude
-73.979896545410156
Dropoff Latitude
40.677803039550781
Passenger Count
5
Trip Distance
5.06
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:50:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:42.000
Lpep Dropoff Datetime
2016-01-01T01:57:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939979553222656
Pickup Latitude
40.815483093261719
Dropoff Longitude
-73.954437255859375
Dropoff Latitude
40.800518035888672
Passenger Count
1
Trip Distance
1.46
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-01T01:50:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:33.000
Lpep Dropoff Datetime
2016-01-01T01:57:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921646118164063
Pickup Latitude
40.767013549804687
Dropoff Longitude
-73.932708740234375
Dropoff Latitude
40.772674560546875
Passenger Count
1
Trip Distance
0.99
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-01T01:52:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:21.000
Lpep Dropoff Datetime
2016-01-01T01:56:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911087036132813
Pickup Latitude
40.775768280029297
Dropoff Longitude
-73.902214050292969
Dropoff Latitude
40.770187377929688
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-01T01:39:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:31.000
Lpep Dropoff Datetime
2016-01-01T01:57:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918548583984375
Pickup Latitude
40.774581909179688
Dropoff Longitude
-73.759971618652344
Dropoff Latitude
40.71588134765625
Passenger Count
1
Trip Distance
11.94
Fare Amount
33
Extra
0.5
Mta Tax
0.5
Tip Amount
6.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
41.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:57:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:57:15.000
Lpep Dropoff Datetime
2016-01-01T01:57:45.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.889839172363281
Pickup Latitude
40.657958984375
Dropoff Longitude
-73.889816284179688
Dropoff Latitude
40.657947540283203
Passenger Count
2
Trip Distance
0.00
Fare Amount
35
Extra
0
Mta Tax
0
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0
Total Amount
36
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:48:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:50.000
Lpep Dropoff Datetime
2016-01-01T01:57:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.929580688476563
Pickup Latitude
40.698371887207031
Dropoff Longitude
-73.948661804199219
Dropoff Latitude
40.710281372070313
Passenger Count
1
Trip Distance
1.63
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
2.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:03.000
Lpep Dropoff Datetime
2016-01-01T01:57:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912696838378906
Pickup Latitude
40.6871337890625
Dropoff Longitude
-73.939727783203125
Dropoff Latitude
40.701316833496094
Passenger Count
1
Trip Distance
2.00
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-01T01:53:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:23.000
Lpep Dropoff Datetime
2016-01-01T01:55:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.830039978027344
Pickup Latitude
40.7137451171875
Dropoff Longitude
-73.821533203125
Dropoff Latitude
40.71392822265625
Passenger Count
1
Trip Distance
0.52
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
3
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:49:20.000 • Lpep Dropoff Datetime: 2016-01-02T00:00:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:49:20.000
Lpep Dropoff Datetime
2016-01-02T00:00:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.831962585449219
Pickup Latitude
40.715049743652344
Dropoff Longitude
-73.803802490234375
Dropoff Latitude
40.723709106445313
Passenger Count
1
Trip Distance
2.41
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-01T01:54:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:35.000
Lpep Dropoff Datetime
2016-01-01T01:57:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952499389648437
Pickup Latitude
40.723243713378906
Dropoff Longitude
-73.954002380371094
Dropoff Latitude
40.730983734130859
Passenger Count
1
Trip Distance
0.62
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-01T01:29:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:44.000
Lpep Dropoff Datetime
2016-01-01T01:56:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.832771301269531
Pickup Latitude
40.715862274169922
Dropoff Longitude
-73.921417236328125
Dropoff Latitude
40.744033813476562
Passenger Count
1
Trip Distance
5.83
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:46.000
Lpep Dropoff Datetime
2016-01-01T01:57:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991950988769531
Pickup Latitude
40.690933227539063
Dropoff Longitude
-73.916847229003906
Dropoff Latitude
40.770942687988281
Passenger Count
1
Trip Distance
10.77
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:51:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:36.000
Lpep Dropoff Datetime
2016-01-01T01:57:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943756103515625
Pickup Latitude
40.825546264648438
Dropoff Longitude
-73.945426940917969
Dropoff Latitude
40.839183807373047
Passenger Count
2
Trip Distance
0.14
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-01T01:06:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:06:30.000
Lpep Dropoff Datetime
2016-01-01T01:56:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960662841796875
Pickup Latitude
40.679485321044922
Dropoff Longitude
-73.878135681152344
Dropoff Latitude
40.722873687744141
Passenger Count
1
Trip Distance
10.24
Fare Amount
38.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
39.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:48:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:04.000
Lpep Dropoff Datetime
2016-01-01T01:57:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923843383789063
Pickup Latitude
40.690563201904297
Dropoff Longitude
-73.916725158691406
Dropoff Latitude
40.674087524414063
Passenger Count
1
Trip Distance
1.84
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-01T01:49:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:58:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:49:29.000
Lpep Dropoff Datetime
2016-01-01T01:58:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953834533691406
Pickup Latitude
40.787639617919922
Dropoff Longitude
-73.948356628417969
Dropoff Latitude
40.774681091308594
Passenger Count
1
Trip Distance
1.44
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-01T01:39:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:46.000
Lpep Dropoff Datetime
2016-01-01T01:57:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949241638183594
Pickup Latitude
40.713485717773438
Dropoff Longitude
-73.964439392089844
Dropoff Latitude
40.67230224609375
Passenger Count
5
Trip Distance
3.84
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
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-01T01:39:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:38.000
Lpep Dropoff Datetime
2016-01-01T01:57:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978317260742188
Pickup Latitude
40.685523986816406
Dropoff Longitude
-73.921615600585937
Dropoff Latitude
40.703056335449219
Passenger Count
1
Trip Distance
4.35
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:06.000 • Lpep Dropoff Datetime: 2016-01-02T01:36:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:06.000
Lpep Dropoff Datetime
2016-01-02T01:36:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.934562683105469
Pickup Latitude
40.697044372558594
Dropoff Longitude
-73.949234008789063
Dropoff Latitude
40.714141845703125
Passenger Count
2
Trip Distance
1.84
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-01T01:37:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:17.000
Lpep Dropoff Datetime
2016-01-01T01:57:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949264526367188
Pickup Latitude
40.714099884033203
Dropoff Longitude
-73.983474731445313
Dropoff Latitude
40.721885681152344
Passenger Count
1
Trip Distance
2.46
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
4.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:53:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:23.000
Lpep Dropoff Datetime
2016-01-01T01:57:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941131591796875
Pickup Latitude
40.788108825683594
Dropoff Longitude
-73.934677124023437
Dropoff Latitude
40.801357269287109
Passenger Count
2
Trip Distance
1.20
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-01T01:45:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:35.000
Lpep Dropoff Datetime
2016-01-01T01:57:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956863403320313
Pickup Latitude
40.813972473144531
Dropoff Longitude
-73.932807922363281
Dropoff Latitude
40.799613952636719
Passenger Count
1
Trip Distance
1.91
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
1
Trip Type
1