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:55:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:25.000
Lpep Dropoff Datetime
2016-01-01T01:03:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924476623535156
Pickup Latitude
40.817863464355469
Dropoff Longitude
-73.921722412109375
Dropoff Latitude
40.833023071289063
Passenger Count
1
Trip Distance
1.31
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:56:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:58.000
Lpep Dropoff Datetime
2016-01-01T01:03:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939651489257813
Pickup Latitude
40.790115356445313
Dropoff Longitude
-73.954338073730469
Dropoff Latitude
40.800563812255859
Passenger Count
5
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:48:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:25.000
Lpep Dropoff Datetime
2016-01-01T01:04:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942451477050781
Pickup Latitude
40.714763641357422
Dropoff Longitude
-73.974784851074219
Dropoff Latitude
40.687984466552734
Passenger Count
1
Trip Distance
3.19
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:34:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:11.000
Lpep Dropoff Datetime
2016-01-01T01:04:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957595825195313
Pickup Latitude
40.718025207519531
Dropoff Longitude
-73.948486328125
Dropoff Latitude
40.7823486328125
Passenger Count
1
Trip Distance
8.62
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:29.000
Lpep Dropoff Datetime
2016-01-01T01:02:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9583740234375
Pickup Latitude
40.664192199707031
Dropoff Longitude
-73.920280456542969
Dropoff Latitude
40.658958435058594
Passenger Count
1
Trip Distance
2.68
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:58:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:32.000
Lpep Dropoff Datetime
2016-01-01T01:02:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.878425598144531
Pickup Latitude
40.748252868652344
Dropoff Longitude
-73.882026672363281
Dropoff Latitude
40.756004333496094
Passenger Count
1
Trip Distance
0.63
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:50:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:41.000
Lpep Dropoff Datetime
2016-01-01T01:04:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953529357910156
Pickup Latitude
40.719799041748047
Dropoff Longitude
-73.948829650878906
Dropoff Latitude
40.692428588867188
Passenger Count
2
Trip Distance
2.42
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:47:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:51.000
Lpep Dropoff Datetime
2016-01-01T01:03:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936805725097656
Pickup Latitude
40.697822570800781
Dropoff Longitude
-73.958099365234375
Dropoff Latitude
40.721656799316406
Passenger Count
1
Trip Distance
2.98
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:41:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:35.000
Lpep Dropoff Datetime
2016-01-01T01:03:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.928695678710938
Pickup Latitude
40.677421569824219
Dropoff Longitude
-73.988136291503906
Dropoff Latitude
40.720134735107422
Passenger Count
1
Trip Distance
5.60
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:09.000
Lpep Dropoff Datetime
2016-01-01T01:04:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.011062622070312
Pickup Latitude
40.63409423828125
Dropoff Longitude
-73.967697143554688
Dropoff Latitude
40.648246765136719
Passenger Count
1
Trip Distance
5.71
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:04.000
Lpep Dropoff Datetime
2016-01-01T01:03:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946670532226562
Pickup Latitude
40.831413269042969
Dropoff Longitude
-73.921058654785156
Dropoff Latitude
40.861518859863281
Passenger Count
1
Trip Distance
3.83
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:59:52.000 • Lpep Dropoff Datetime: 2016-01-02T00:53:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:52.000
Lpep Dropoff Datetime
2016-01-02T00:53:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.864433288574219
Pickup Latitude
40.753261566162109
Dropoff Longitude
-73.852867126464844
Dropoff Latitude
40.745410919189453
Passenger Count
1
Trip Distance
0.95
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:55:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:15.000
Lpep Dropoff Datetime
2016-01-01T01:03:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938980102539062
Pickup Latitude
40.791206359863281
Dropoff Longitude
-73.914932250976562
Dropoff Latitude
40.818508148193359
Passenger Count
1
Trip Distance
2.31
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:45:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:19.000
Lpep Dropoff Datetime
2016-01-01T01:04:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937347412109375
Pickup Latitude
40.839168548583984
Dropoff Longitude
-73.897666931152344
Dropoff Latitude
40.817333221435547
Passenger Count
1
Trip Distance
3.44
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:53:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:31.000
Lpep Dropoff Datetime
2016-01-01T01:03:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956001281738281
Pickup Latitude
40.6812744140625
Dropoff Longitude
-73.964439392089844
Dropoff Latitude
40.704292297363281
Passenger Count
1
Trip Distance
2.22
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:58:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:33.000
Lpep Dropoff Datetime
2016-01-01T01:04:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954429626464844
Pickup Latitude
40.690750122070313
Dropoff Longitude
-73.943374633789063
Dropoff Latitude
40.695030212402344
Passenger Count
1
Trip Distance
0.87
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:51:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:16.000
Lpep Dropoff Datetime
2016-01-01T01:04:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921356201171875
Pickup Latitude
40.766693115234375
Dropoff Longitude
-73.894828796386719
Dropoff Latitude
40.735000610351563
Passenger Count
1
Trip Distance
3.49
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:58:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:30.000
Lpep Dropoff Datetime
2016-01-01T01:03:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882553100585938
Pickup Latitude
40.747676849365234
Dropoff Longitude
-73.878669738769531
Dropoff Latitude
40.756206512451172
Passenger Count
1
Trip Distance
0.70
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:33:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:57.000
Lpep Dropoff Datetime
2016-01-01T01:02:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952232360839844
Pickup Latitude
40.810527801513672
Dropoff Longitude
-73.990989685058594
Dropoff Latitude
40.744083404541016
Passenger Count
1
Trip Distance
7.30
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:47:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:39.000
Lpep Dropoff Datetime
2016-01-01T01:04:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.916343688964844
Pickup Latitude
40.764583587646484
Dropoff Longitude
-73.809761047363281
Dropoff Latitude
40.722274780273438
Passenger Count
1
Trip Distance
8.67
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
5.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:33.000
Lpep Dropoff Datetime
2016-01-01T01:04:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939994812011719
Pickup Latitude
40.8055419921875
Dropoff Longitude
-73.936599731445313
Dropoff Latitude
40.814079284667969
Passenger Count
1
Trip Distance
0.71
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:41.000
Lpep Dropoff Datetime
2016-01-01T01:03:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943267822265625
Pickup Latitude
40.817615509033203
Dropoff Longitude
-73.909019470214844
Dropoff Latitude
40.775005340576172
Passenger Count
1
Trip Distance
5.31
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.53
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
27.87
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:40.000
Lpep Dropoff Datetime
2016-01-01T01:02:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.837310791015625
Pickup Latitude
40.718723297119141
Dropoff Longitude
-73.953689575195313
Dropoff Latitude
40.742584228515625
Passenger Count
1
Trip Distance
8.73
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:22.000
Lpep Dropoff Datetime
2016-01-01T01:04:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.885963439941406
Pickup Latitude
40.747589111328125
Dropoff Longitude
-73.912872314453125
Dropoff Latitude
40.769336700439453
Passenger Count
1
Trip Distance
2.41
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:47:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:58.000
Lpep Dropoff Datetime
2016-01-01T01:04:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962051391601562
Pickup Latitude
40.713298797607422
Dropoff Longitude
-73.986541748046875
Dropoff Latitude
40.72894287109375
Passenger Count
1
Trip Distance
3.00
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:20.000
Lpep Dropoff Datetime
2016-01-01T01:02:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942947387695313
Pickup Latitude
40.796886444091797
Dropoff Longitude
-73.974945068359375
Dropoff Latitude
40.720138549804687
Passenger Count
1
Trip Distance
6.12
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:35.000
Lpep Dropoff Datetime
2016-01-01T01:03:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957618713378906
Pickup Latitude
40.729724884033203
Dropoff Longitude
-73.956016540527344
Dropoff Latitude
40.712417602539062
Passenger Count
1
Trip Distance
1.67
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:50:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:59.000
Lpep Dropoff Datetime
2016-01-01T01:04:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963523864746094
Pickup Latitude
40.710418701171875
Dropoff Longitude
-73.927093505859375
Dropoff Latitude
40.708541870117188
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:22:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:41.000
Lpep Dropoff Datetime
2016-01-01T01:04:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9716796875
Pickup Latitude
40.675304412841797
Dropoff Longitude
-73.957504272460938
Dropoff Latitude
40.809246063232422
Passenger Count
1
Trip Distance
13.19
Fare Amount
42
Extra
0.5
Mta Tax
0.5
Tip Amount
10.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
54.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:55.000
Lpep Dropoff Datetime
2016-01-01T01:04:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939956665039063
Pickup Latitude
40.707668304443359
Dropoff Longitude
-73.932151794433594
Dropoff Latitude
40.703300476074219
Passenger Count
2
Trip Distance
0.70
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:03.000
Lpep Dropoff Datetime
2016-01-01T01:04:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981254577636719
Pickup Latitude
40.575851440429687
Dropoff Longitude
-74.021965026855469
Dropoff Latitude
40.631271362304688
Passenger Count
1
Trip Distance
6.04
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:54:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:03.000
Lpep Dropoff Datetime
2016-01-01T01:04:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963607788085938
Pickup Latitude
40.803203582763672
Dropoff Longitude
-73.939315795898438
Dropoff Latitude
40.805103302001953
Passenger Count
1
Trip Distance
1.86
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:56:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:49.000
Lpep Dropoff Datetime
2016-01-01T01:03:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96044921875
Pickup Latitude
40.658340454101563
Dropoff Longitude
-73.942459106445313
Dropoff Latitude
40.660617828369141
Passenger Count
3
Trip Distance
1.21
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:30:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:54.000
Lpep Dropoff Datetime
2016-01-01T01:04:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923789978027344
Pickup Latitude
40.653823852539063
Dropoff Longitude
-73.77191162109375
Dropoff Latitude
40.680767059326172
Passenger Count
4
Trip Distance
15.49
Fare Amount
44.5
Extra
0.5
Mta Tax
0.5
Tip Amount
9.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
54.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:23.000
Lpep Dropoff Datetime
2016-01-01T01:04:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921218872070312
Pickup Latitude
40.763328552246094
Dropoff Longitude
-73.947479248046875
Dropoff Latitude
40.747505187988281
Passenger Count
1
Trip Distance
3.50
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:49:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:16.000
Lpep Dropoff Datetime
2016-01-01T01:04:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964958190917969
Pickup Latitude
40.683116912841797
Dropoff Longitude
-73.950233459472656
Dropoff Latitude
40.7227783203125
Passenger Count
1
Trip Distance
3.63
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:43:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:18.000
Lpep Dropoff Datetime
2016-01-01T01:04:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938758850097656
Pickup Latitude
40.796501159667969
Dropoff Longitude
-73.894515991210937
Dropoff Latitude
40.842456817626953
Passenger Count
3
Trip Distance
5.77
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:53.000
Lpep Dropoff Datetime
2016-01-01T01:04:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940773010253906
Pickup Latitude
40.720611572265625
Dropoff Longitude
-73.951805114746094
Dropoff Latitude
40.73028564453125
Passenger Count
5
Trip Distance
2.95
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:55:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:46.000
Lpep Dropoff Datetime
2016-01-01T01:04:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964614868164062
Pickup Latitude
40.652938842773438
Dropoff Longitude
-73.9541015625
Dropoff Latitude
40.666458129882813
Passenger Count
1
Trip Distance
1.46
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:58:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:37.000
Lpep Dropoff Datetime
2016-01-01T01:04:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911140441894531
Pickup Latitude
40.767669677734375
Dropoff Longitude
-73.904106140136719
Dropoff Latitude
40.753650665283203
Passenger Count
1
Trip Distance
1.62
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:37.000
Lpep Dropoff Datetime
2016-01-01T01:04:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9525146484375
Pickup Latitude
40.803493499755859
Dropoff Longitude
-73.940521240234375
Dropoff Latitude
40.833301544189453
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-01T00:53:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:24.000
Lpep Dropoff Datetime
2016-01-01T01:03:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.889808654785156
Pickup Latitude
40.747154235839844
Dropoff Longitude
-73.920204162597656
Dropoff Latitude
40.740333557128906
Passenger Count
3
Trip Distance
2.00
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:43:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:03.000
Lpep Dropoff Datetime
2016-01-01T01:04:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.907585144042969
Pickup Latitude
40.823875427246094
Dropoff Longitude
-73.952621459960937
Dropoff Latitude
40.804977416992188
Passenger Count
1
Trip Distance
3.59
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:01.000
Lpep Dropoff Datetime
2016-01-01T01:04:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962547302246094
Pickup Latitude
40.710086822509766
Dropoff Longitude
-73.903579711914062
Dropoff Latitude
40.707839965820312
Passenger Count
1
Trip Distance
3.57
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:38:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:33.000
Lpep Dropoff Datetime
2016-01-01T01:03:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94512939453125
Pickup Latitude
40.832439422607422
Dropoff Longitude
-73.890121459960937
Dropoff Latitude
40.826637268066406
Passenger Count
1
Trip Distance
3.61
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-01T00:48:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:52.000
Lpep Dropoff Datetime
2016-01-01T01:03:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956672668457031
Pickup Latitude
40.658924102783203
Dropoff Longitude
-73.919357299804688
Dropoff Latitude
40.675632476806641
Passenger Count
1
Trip Distance
2.85
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:43.000
Lpep Dropoff Datetime
2016-01-01T01:04:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927116394042969
Pickup Latitude
40.775382995605469
Dropoff Longitude
-73.954826354980469
Dropoff Latitude
40.768985748291016
Passenger Count
5
Trip Distance
4.47
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
2.3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.6
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:09.000
Lpep Dropoff Datetime
2016-01-01T01:04:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.998023986816406
Pickup Latitude
40.67803955078125
Dropoff Longitude
-73.946693420410156
Dropoff Latitude
40.682491302490234
Passenger Count
1
Trip Distance
3.83
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-01T00:56:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:30.000
Lpep Dropoff Datetime
2016-01-01T01:04:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979820251464844
Pickup Latitude
40.693538665771484
Dropoff Longitude
-73.952522277832031
Dropoff Latitude
40.694892883300781
Passenger Count
1
Trip Distance
1.44
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:55.000
Lpep Dropoff Datetime
2016-01-01T01:04:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944320678710938
Pickup Latitude
40.809223175048828
Dropoff Longitude
-73.906356811523438
Dropoff Latitude
40.827793121337891
Passenger Count
1
Trip Distance
3.08
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