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:28:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:28:04.000
Lpep Dropoff Datetime
2016-01-01T01:56:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925178527832031
Pickup Latitude
40.764976501464844
Dropoff Longitude
-73.978225708007813
Dropoff Latitude
40.791893005371094
Passenger Count
1
Trip Distance
7.85
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
8.58
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
42.92
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:52:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:41.000
Lpep Dropoff Datetime
2016-01-01T01:56:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93927001953125
Pickup Latitude
40.843101501464844
Dropoff Longitude
-73.941162109375
Dropoff Latitude
40.833976745605469
Passenger Count
1
Trip Distance
0.79
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:42:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:38.000
Lpep Dropoff Datetime
2016-01-01T01:56:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957778930664063
Pickup Latitude
40.729846954345703
Dropoff Longitude
-73.942276000976563
Dropoff Latitude
40.754016876220703
Passenger Count
2
Trip Distance
2.40
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:38:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:01.000
Lpep Dropoff Datetime
2016-01-01T01:56:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95147705078125
Pickup Latitude
40.713241577148438
Dropoff Longitude
-73.980903625488281
Dropoff Latitude
40.675849914550781
Passenger Count
5
Trip Distance
4.35
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
3.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:56:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:44.000
Lpep Dropoff Datetime
2016-01-01T01:56:52.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.965827941894531
Pickup Latitude
40.805210113525391
Dropoff Longitude
-73.96588134765625
Dropoff Latitude
40.805282592773438
Passenger Count
2
Trip Distance
0.01
Fare Amount
40
Extra
0
Mta Tax
0
Tip Amount
8
Tolls Amount
0
Improvement Surcharge
0
Total Amount
48
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:06.000
Lpep Dropoff Datetime
2016-01-01T01:56:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913185119628906
Pickup Latitude
40.756290435791016
Dropoff Longitude
-73.913833618164063
Dropoff Latitude
40.756572723388672
Passenger Count
1
Trip Distance
0.04
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:40:03.000 • Lpep Dropoff Datetime: 2016-01-02T01:37:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:03.000
Lpep Dropoff Datetime
2016-01-02T01:37:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949081420898437
Pickup Latitude
40.714126586914062
Dropoff Longitude
-73.96697998046875
Dropoff Latitude
40.693626403808594
Passenger Count
1
Trip Distance
2.66
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:47.000
Lpep Dropoff Datetime
2016-01-01T01:56:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949775695800781
Pickup Latitude
40.71630859375
Dropoff Longitude
-73.949600219726563
Dropoff Latitude
40.679771423339844
Passenger Count
1
Trip Distance
3.13
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:41.000
Lpep Dropoff Datetime
2016-01-01T01:56:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920967102050781
Pickup Latitude
40.756568908691406
Dropoff Longitude
-73.921295166015625
Dropoff Latitude
40.763343811035156
Passenger Count
1
Trip Distance
3.11
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:45:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:58.000
Lpep Dropoff Datetime
2016-01-01T01:56:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.973777770996094
Pickup Latitude
40.67889404296875
Dropoff Longitude
-73.993156433105469
Dropoff Latitude
40.667438507080078
Passenger Count
1
Trip Distance
1.65
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:39:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:14.000
Lpep Dropoff Datetime
2016-01-01T01:56:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954109191894531
Pickup Latitude
40.729736328125
Dropoff Longitude
-73.982757568359375
Dropoff Latitude
40.678031921386719
Passenger Count
1
Trip Distance
5.64
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:32.000
Lpep Dropoff Datetime
2016-01-01T01:57:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957908630371094
Pickup Latitude
40.713214874267578
Dropoff Longitude
-73.994033813476563
Dropoff Latitude
40.681678771972656
Passenger Count
1
Trip Distance
5.40
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:47:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:20.000
Lpep Dropoff Datetime
2016-01-01T01:57:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955146789550781
Pickup Latitude
40.804416656494141
Dropoff Longitude
-73.940109252929687
Dropoff Latitude
40.822021484375
Passenger Count
1
Trip Distance
1.56
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-01T01:49:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:49:52.000
Lpep Dropoff Datetime
2016-01-01T01:56:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977821350097656
Pickup Latitude
40.684738159179688
Dropoff Longitude
-73.976531982421875
Dropoff Latitude
40.694381713867187
Passenger Count
1
Trip Distance
1.08
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.34
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.14
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:57.000
Lpep Dropoff Datetime
2016-01-01T01:56:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954338073730469
Pickup Latitude
40.685653686523438
Dropoff Longitude
-73.944419860839844
Dropoff Latitude
40.714359283447266
Passenger Count
1
Trip Distance
3.13
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:30:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:28.000
Lpep Dropoff Datetime
2016-01-01T01:56:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952789306640625
Pickup Latitude
40.823093414306641
Dropoff Longitude
-73.916908264160156
Dropoff Latitude
40.807407379150391
Passenger Count
1
Trip Distance
3.92
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-01T01:45:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:45.000
Lpep Dropoff Datetime
2016-01-01T01:56:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.928421020507813
Pickup Latitude
40.766677856445313
Dropoff Longitude
-73.894966125488281
Dropoff Latitude
40.750663757324219
Passenger Count
1
Trip Distance
3.21
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:36:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:36:32.000
Lpep Dropoff Datetime
2016-01-01T01:56:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.884429931640625
Pickup Latitude
40.737907409667969
Dropoff Longitude
-73.801368713378906
Dropoff Latitude
40.692081451416016
Passenger Count
2
Trip Distance
6.15
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:47:00.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:00.000
Lpep Dropoff Datetime
2016-01-01T01:56:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949150085449219
Pickup Latitude
40.722541809082031
Dropoff Longitude
-73.959388732910156
Dropoff Latitude
40.690494537353516
Passenger Count
1
Trip Distance
2.55
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-01T01:05:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:05:58.000
Lpep Dropoff Datetime
2016-01-01T01:57:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915176391601563
Pickup Latitude
40.763957977294922
Dropoff Longitude
-73.940956115722656
Dropoff Latitude
40.811649322509766
Passenger Count
1
Trip Distance
10.44
Fare Amount
35.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:17.000
Lpep Dropoff Datetime
2016-01-01T01:57:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.020057678222656
Pickup Latitude
40.649578094482422
Dropoff Longitude
-73.982902526855469
Dropoff Latitude
40.696140289306641
Passenger Count
1
Trip Distance
5.66
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:48:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:30.000
Lpep Dropoff Datetime
2016-01-01T01:56:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.897613525390625
Pickup Latitude
40.748294830322266
Dropoff Longitude
-73.888275146484375
Dropoff Latitude
40.757396697998047
Passenger Count
5
Trip Distance
1.15
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:34:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:30.000
Lpep Dropoff Datetime
2016-01-01T01:56:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903427124023438
Pickup Latitude
40.745723724365234
Dropoff Longitude
-73.902458190917969
Dropoff Latitude
40.695907592773437
Passenger Count
1
Trip Distance
4.59
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:38:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:05.000
Lpep Dropoff Datetime
2016-01-01T01:57:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957275390625
Pickup Latitude
40.814380645751953
Dropoff Longitude
-73.886741638183594
Dropoff Latitude
40.833786010742188
Passenger Count
1
Trip Distance
7.71
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:43:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:46.000
Lpep Dropoff Datetime
2016-01-01T01:56:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.802192687988281
Pickup Latitude
40.702701568603516
Dropoff Longitude
-73.733963012695313
Dropoff Latitude
40.719032287597656
Passenger Count
1
Trip Distance
3.95
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-01T01:44:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:13.000
Lpep Dropoff Datetime
2016-01-01T01:56:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93133544921875
Pickup Latitude
40.852550506591797
Dropoff Longitude
-73.953598022460938
Dropoff Latitude
40.8228759765625
Passenger Count
1
Trip Distance
2.40
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-01T01:37:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:55.000
Lpep Dropoff Datetime
2016-01-01T01:56:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961135864257813
Pickup Latitude
40.709552764892578
Dropoff Longitude
-73.991996765136719
Dropoff Latitude
40.729290008544922
Passenger Count
1
Trip Distance
3.21
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-01T01:41:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:49.000
Lpep Dropoff Datetime
2016-01-01T01:55:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949012756347656
Pickup Latitude
40.685638427734375
Dropoff Longitude
-73.952980041503906
Dropoff Latitude
40.673202514648438
Passenger Count
2
Trip Distance
1.91
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-01T01:47:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:48.000
Lpep Dropoff Datetime
2016-01-01T01:56:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965690612792969
Pickup Latitude
40.687221527099609
Dropoff Longitude
-73.986579895019531
Dropoff Latitude
40.702953338623047
Passenger Count
1
Trip Distance
2.07
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-01T01:47:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:02.000
Lpep Dropoff Datetime
2016-01-01T01:56:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920906066894531
Pickup Latitude
40.861160278320313
Dropoff Longitude
-73.899162292480469
Dropoff Latitude
40.886520385742188
Passenger Count
1
Trip Distance
2.18
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.24
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.04
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:17:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:17:27.000
Lpep Dropoff Datetime
2016-01-01T01:56:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952163696289063
Pickup Latitude
40.789703369140625
Dropoff Longitude
-73.9365234375
Dropoff Latitude
40.701984405517578
Passenger Count
1
Trip Distance
10.33
Fare Amount
35
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:54.000
Lpep Dropoff Datetime
2016-01-01T01:55:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994453430175781
Pickup Latitude
40.660285949707031
Dropoff Longitude
-74.008926391601563
Dropoff Latitude
40.639469146728516
Passenger Count
1
Trip Distance
2.25
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:39:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:37.000
Lpep Dropoff Datetime
2016-01-01T01:56:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944923400878906
Pickup Latitude
40.823871612548828
Dropoff Longitude
-73.975250244140625
Dropoff Latitude
40.777297973632813
Passenger Count
1
Trip Distance
3.77
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:48:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:50.000
Lpep Dropoff Datetime
2016-01-01T01:57:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95477294921875
Pickup Latitude
40.733001708984375
Dropoff Longitude
-73.944580078125
Dropoff Latitude
40.715282440185547
Passenger Count
1
Trip Distance
1.41
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:03.000
Lpep Dropoff Datetime
2016-01-01T01:57:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882064819335938
Pickup Latitude
40.747894287109375
Dropoff Longitude
-73.904136657714844
Dropoff Latitude
40.753616333007812
Passenger Count
1
Trip Distance
1.65
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:54:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:45.000
Lpep Dropoff Datetime
2016-01-01T01:57:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890434265136719
Pickup Latitude
40.746772766113281
Dropoff Longitude
-73.887649536132812
Dropoff Latitude
40.747165679931641
Passenger Count
1
Trip Distance
0.14
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:14.000
Lpep Dropoff Datetime
2016-01-01T01:55:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920143127441406
Pickup Latitude
40.8079833984375
Dropoff Longitude
-73.94940185546875
Dropoff Latitude
40.790241241455078
Passenger Count
1
Trip Distance
2.31
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-01T01:51:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:21.000
Lpep Dropoff Datetime
2016-01-01T01:56:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94976806640625
Pickup Latitude
40.822174072265625
Dropoff Longitude
-73.9580078125
Dropoff Latitude
40.815578460693359
Passenger Count
1
Trip Distance
0.90
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:47:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:47:25.000
Lpep Dropoff Datetime
2016-01-01T01:56:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.829635620117188
Pickup Latitude
40.713626861572266
Dropoff Longitude
-73.832748413085938
Dropoff Latitude
40.692161560058594
Passenger Count
1
Trip Distance
2.04
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:25:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:25:11.000
Lpep Dropoff Datetime
2016-01-01T01:57:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844520568847656
Pickup Latitude
40.721416473388672
Dropoff Longitude
-73.986015319824219
Dropoff Latitude
40.752105712890625
Passenger Count
1
Trip Distance
9.39
Fare Amount
32
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:34:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:21.000
Lpep Dropoff Datetime
2016-01-01T01:55:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943222045898438
Pickup Latitude
40.836406707763672
Dropoff Longitude
-73.890846252441406
Dropoff Latitude
40.868270874023438
Passenger Count
1
Trip Distance
6.49
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:41:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:26.000
Lpep Dropoff Datetime
2016-01-01T01:56:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881080627441406
Pickup Latitude
40.756046295166016
Dropoff Longitude
-73.8326416015625
Dropoff Latitude
40.760181427001953
Passenger Count
3
Trip Distance
2.94
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-01T01:46:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:30.000
Lpep Dropoff Datetime
2016-01-01T01:57:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9942626953125
Pickup Latitude
40.690265655517578
Dropoff Longitude
-73.970672607421875
Dropoff Latitude
40.678058624267578
Passenger Count
1
Trip Distance
1.99
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:50:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:01.000
Lpep Dropoff Datetime
2016-01-01T01:57:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881019592285156
Pickup Latitude
40.747905731201172
Dropoff Longitude
-73.86395263671875
Dropoff Latitude
40.749759674072266
Passenger Count
1
Trip Distance
0.88
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:43:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:53.000
Lpep Dropoff Datetime
2016-01-01T01:56:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994346618652344
Pickup Latitude
40.660423278808594
Dropoff Longitude
-74.027587890625
Dropoff Latitude
40.631431579589844
Passenger Count
2
Trip Distance
4.72
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:35:16.000 • Lpep Dropoff Datetime: 2016-01-02T01:34:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:16.000
Lpep Dropoff Datetime
2016-01-02T01:34:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949691772460938
Pickup Latitude
40.714042663574219
Dropoff Longitude
-73.919830322265625
Dropoff Latitude
40.688304901123047
Passenger Count
1
Trip Distance
2.61
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:46:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:06.000
Lpep Dropoff Datetime
2016-01-01T01:57:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90045166015625
Pickup Latitude
40.816963195800781
Dropoff Longitude
-73.943954467773438
Dropoff Latitude
40.821868896484375
Passenger Count
1
Trip Distance
2.70
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
1.23
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.53
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:39:00.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:00.000
Lpep Dropoff Datetime
2016-01-01T01:56:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.83056640625
Pickup Latitude
40.759529113769531
Dropoff Longitude
-73.922866821289063
Dropoff Latitude
40.754268646240234
Passenger Count
1
Trip Distance
6.18
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:38:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:02.000
Lpep Dropoff Datetime
2016-01-01T01:57:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8563232421875
Pickup Latitude
40.736728668212891
Dropoff Longitude
-73.895309448242188
Dropoff Latitude
40.746494293212891
Passenger Count
1
Trip Distance
2.61
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-01T01:36:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:57:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:36:24.000
Lpep Dropoff Datetime
2016-01-01T01:57:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951736450195312
Pickup Latitude
40.714401245117188
Dropoff Longitude
-73.991226196289062
Dropoff Latitude
40.72760009765625
Passenger Count
5
Trip Distance
3.12
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