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:33:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:19.000
Lpep Dropoff Datetime
2016-01-01T00:39:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923500061035156
Pickup Latitude
40.866977691650391
Dropoff Longitude
-73.935997009277344
Dropoff Latitude
40.851875305175781
Passenger Count
1
Trip Distance
1.35
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
2.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:22:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:01.000
Lpep Dropoff Datetime
2016-01-01T00:40:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.88848876953125
Pickup Latitude
40.747035980224609
Dropoff Longitude
-73.94073486328125
Dropoff Latitude
40.755733489990234
Passenger Count
1
Trip Distance
3.52
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:21:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:37.000
Lpep Dropoff Datetime
2016-01-01T00:40:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9107666015625
Pickup Latitude
40.7728271484375
Dropoff Longitude
-73.812576293945313
Dropoff Latitude
40.764911651611328
Passenger Count
6
Trip Distance
6.48
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:00:06.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:00:06.000
Lpep Dropoff Datetime
2016-01-01T00:40:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8748779296875
Pickup Latitude
40.829345703125
Dropoff Longitude
-73.9840087890625
Dropoff Latitude
40.743137359619141
Passenger Count
1
Trip Distance
10.58
Fare Amount
37.5
Extra
0.5
Mta Tax
0.5
Tip Amount
11.64
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
50.44
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:24:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:20.000
Lpep Dropoff Datetime
2016-01-01T00:40:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963180541992188
Pickup Latitude
40.684745788574219
Dropoff Longitude
-73.998504638671875
Dropoff Latitude
40.694511413574219
Passenger Count
1
Trip Distance
2.51
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-01T00:23:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:51.000
Lpep Dropoff Datetime
2016-01-01T00:40:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951705932617188
Pickup Latitude
40.714981079101562
Dropoff Longitude
-74.030609130859375
Dropoff Latitude
40.624397277832031
Passenger Count
1
Trip Distance
10.32
Fare Amount
29
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:07.000
Lpep Dropoff Datetime
2016-01-01T00:40:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.980064392089844
Pickup Latitude
40.676925659179688
Dropoff Longitude
-73.956695556640625
Dropoff Latitude
40.673255920410156
Passenger Count
1
Trip Distance
1.79
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:52.000
Lpep Dropoff Datetime
2016-01-01T00:40:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955764770507813
Pickup Latitude
40.717678070068359
Dropoff Longitude
-73.971305847167969
Dropoff Latitude
40.695751190185547
Passenger Count
5
Trip Distance
2.21
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
3.39
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.69
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:19.000
Lpep Dropoff Datetime
2016-01-01T00:40:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.879920959472656
Pickup Latitude
40.756248474121094
Dropoff Longitude
-73.923820495605469
Dropoff Latitude
40.755973815917969
Passenger Count
1
Trip Distance
2.60
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:29:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:49.000
Lpep Dropoff Datetime
2016-01-01T00:40:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.932746887207031
Pickup Latitude
40.703205108642578
Dropoff Longitude
-73.948394775390625
Dropoff Latitude
40.711231231689453
Passenger Count
1
Trip Distance
1.39
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:24:41.000 • Lpep Dropoff Datetime: 2016-01-02T00:00:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:41.000
Lpep Dropoff Datetime
2016-01-02T00:00:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993324279785156
Pickup Latitude
40.682712554931641
Dropoff Longitude
-73.955810546875
Dropoff Latitude
40.690887451171875
Passenger Count
1
Trip Distance
2.42
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:35:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:01.000
Lpep Dropoff Datetime
2016-01-01T00:40:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912094116210937
Pickup Latitude
40.767356872558594
Dropoff Longitude
-73.912559509277344
Dropoff Latitude
40.777435302734375
Passenger Count
1
Trip Distance
1.29
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:30:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:35.000
Lpep Dropoff Datetime
2016-01-01T00:40:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981895446777344
Pickup Latitude
40.676963806152344
Dropoff Longitude
-73.983383178710938
Dropoff Latitude
40.694065093994141
Passenger Count
2
Trip Distance
1.43
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:54.000
Lpep Dropoff Datetime
2016-01-01T00:40:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924308776855469
Pickup Latitude
40.743606567382813
Dropoff Longitude
-73.885055541992188
Dropoff Latitude
40.744121551513672
Passenger Count
1
Trip Distance
2.32
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:33:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:18.000
Lpep Dropoff Datetime
2016-01-01T00:40:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91845703125
Pickup Latitude
40.765491485595703
Dropoff Longitude
-73.92901611328125
Dropoff Latitude
40.775867462158203
Passenger Count
1
Trip Distance
1.41
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:39.000
Lpep Dropoff Datetime
2016-01-01T00:40:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95037841796875
Pickup Latitude
40.707542419433594
Dropoff Longitude
-73.894302368164063
Dropoff Latitude
40.693222045898438
Passenger Count
6
Trip Distance
3.50
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:39.000
Lpep Dropoff Datetime
2016-01-01T00:40:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952781677246094
Pickup Latitude
40.798381805419922
Dropoff Longitude
-73.953720092773438
Dropoff Latitude
40.790668487548828
Passenger Count
1
Trip Distance
0.67
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:23:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:58.000
Lpep Dropoff Datetime
2016-01-01T00:39:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944381713867187
Pickup Latitude
40.823806762695312
Dropoff Longitude
-73.909423828125
Dropoff Latitude
40.844715118408203
Passenger Count
1
Trip Distance
3.20
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:15:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:30.000
Lpep Dropoff Datetime
2016-01-01T00:40:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978439331054687
Pickup Latitude
40.683986663818359
Dropoff Longitude
-73.994911193847656
Dropoff Latitude
40.769111633300781
Passenger Count
1
Trip Distance
6.82
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:36.000
Lpep Dropoff Datetime
2016-01-01T00:40:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948776245117187
Pickup Latitude
40.828948974609375
Dropoff Longitude
-73.944839477539063
Dropoff Latitude
40.808826446533203
Passenger Count
1
Trip Distance
1.89
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:30:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:08.000
Lpep Dropoff Datetime
2016-01-01T00:40:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924102783203125
Pickup Latitude
40.744026184082031
Dropoff Longitude
-73.902862548828125
Dropoff Latitude
40.744663238525391
Passenger Count
1
Trip Distance
2.18
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:37:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:18.000
Lpep Dropoff Datetime
2016-01-01T00:41:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.900749206542969
Pickup Latitude
40.820125579833984
Dropoff Longitude
-73.886405944824219
Dropoff Latitude
40.827510833740234
Passenger Count
1
Trip Distance
0.80
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:33:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:41.000
Lpep Dropoff Datetime
2016-01-01T00:41:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978729248046875
Pickup Latitude
40.670341491699219
Dropoff Longitude
-73.993385314941406
Dropoff Latitude
40.660446166992188
Passenger Count
1
Trip Distance
1.36
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:26:12.000 • Lpep Dropoff Datetime: 2016-01-01T23:50:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:12.000
Lpep Dropoff Datetime
2016-01-01T23:50:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954978942871094
Pickup Latitude
40.694721221923828
Dropoff Longitude
-73.959609985351563
Dropoff Latitude
40.729721069335938
Passenger Count
1
Trip Distance
3.18
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-01T00:34:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:38.000
Lpep Dropoff Datetime
2016-01-01T00:40:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.870796203613281
Pickup Latitude
40.751415252685547
Dropoff Longitude
-73.884262084960938
Dropoff Latitude
40.747642517089844
Passenger Count
3
Trip Distance
0.88
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:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:08.000
Lpep Dropoff Datetime
2016-01-01T00:41:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.893295288085938
Pickup Latitude
40.754806518554687
Dropoff Longitude
-73.923248291015625
Dropoff Latitude
40.761009216308594
Passenger Count
1
Trip Distance
1.77
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:40.000
Lpep Dropoff Datetime
2016-01-01T00:41:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.83062744140625
Pickup Latitude
40.759483337402344
Dropoff Longitude
-73.845428466796875
Dropoff Latitude
40.784271240234375
Passenger Count
1
Trip Distance
2.24
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:22:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:39:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:54.000
Lpep Dropoff Datetime
2016-01-01T00:39:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8048095703125
Pickup Latitude
40.696079254150391
Dropoff Longitude
-73.862533569335938
Dropoff Latitude
40.681484222412109
Passenger Count
1
Trip Distance
3.36
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:23:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:36.000
Lpep Dropoff Datetime
2016-01-01T00:40:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918258666992187
Pickup Latitude
40.741100311279297
Dropoff Longitude
-73.883567810058594
Dropoff Latitude
40.756008148193359
Passenger Count
2
Trip Distance
3.86
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:23:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:33.000
Lpep Dropoff Datetime
2016-01-01T00:40:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982658386230469
Pickup Latitude
40.665275573730469
Dropoff Longitude
-73.9842529296875
Dropoff Latitude
40.607620239257813
Passenger Count
1
Trip Distance
5.06
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:32.000
Lpep Dropoff Datetime
2016-01-01T00:40:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.865791320800781
Pickup Latitude
40.736736297607422
Dropoff Longitude
-73.862030029296875
Dropoff Latitude
40.749732971191406
Passenger Count
5
Trip Distance
1.03
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:21:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:04.000
Lpep Dropoff Datetime
2016-01-01T00:40:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993988037109375
Pickup Latitude
40.681522369384766
Dropoff Longitude
-73.965988159179688
Dropoff Latitude
40.713645935058594
Passenger Count
1
Trip Distance
6.21
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
4.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:23:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:40.000
Lpep Dropoff Datetime
2016-01-01T00:40:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.866455078125
Pickup Latitude
40.831783294677734
Dropoff Longitude
-73.92083740234375
Dropoff Latitude
40.829524993896484
Passenger Count
1
Trip Distance
4.76
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:49.000
Lpep Dropoff Datetime
2016-01-01T00:40:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896492004394531
Pickup Latitude
40.746181488037109
Dropoff Longitude
-73.884780883789062
Dropoff Latitude
40.757671356201172
Passenger Count
1
Trip Distance
1.32
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:17:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:07.000
Lpep Dropoff Datetime
2016-01-01T00:41:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976646423339844
Pickup Latitude
40.682773590087891
Dropoff Longitude
-73.855621337890625
Dropoff Latitude
40.722080230712891
Passenger Count
1
Trip Distance
10.00
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:15:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:51.000
Lpep Dropoff Datetime
2016-01-01T00:40:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.975990295410156
Pickup Latitude
40.687038421630859
Dropoff Longitude
-73.870498657226562
Dropoff Latitude
40.757049560546875
Passenger Count
1
Trip Distance
8.86
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:04.000
Lpep Dropoff Datetime
2016-01-01T00:40:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891998291015625
Pickup Latitude
40.746978759765625
Dropoff Longitude
-73.921066284179688
Dropoff Latitude
40.756359100341797
Passenger Count
1
Trip Distance
1.85
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:15.000
Lpep Dropoff Datetime
2016-01-01T00:41:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976486206054688
Pickup Latitude
40.682826995849609
Dropoff Longitude
-73.873886108398438
Dropoff Latitude
40.727592468261719
Passenger Count
1
Trip Distance
8.68
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:23.000
Lpep Dropoff Datetime
2016-01-01T00:40:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954017639160156
Pickup Latitude
40.707210540771484
Dropoff Longitude
-73.89666748046875
Dropoff Latitude
40.746330261230469
Passenger Count
1
Trip Distance
6.08
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-01T00:27:50.000 • Lpep Dropoff Datetime: 2016-01-02T00:18:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:50.000
Lpep Dropoff Datetime
2016-01-02T00:18:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.985252380371094
Pickup Latitude
40.687137603759766
Dropoff Longitude
-73.949851989746094
Dropoff Latitude
40.681045532226563
Passenger Count
2
Trip Distance
2.23
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:09.000
Lpep Dropoff Datetime
2016-01-01T00:40:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94354248046875
Pickup Latitude
40.814376831054688
Dropoff Longitude
-73.951583862304688
Dropoff Latitude
40.827056884765625
Passenger Count
1
Trip Distance
1.54
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-01T00:09:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:32:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:09:38.000
Lpep Dropoff Datetime
2016-01-01T00:32:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977996826171875
Pickup Latitude
40.672737121582031
Dropoff Longitude
-73.972465515136719
Dropoff Latitude
40.725681304931641
Passenger Count
5
Trip Distance
7.70
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:05:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:52.000
Lpep Dropoff Datetime
2016-01-01T00:41:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958221435546875
Pickup Latitude
40.721794128417969
Dropoff Longitude
-73.942710876464844
Dropoff Latitude
40.66339111328125
Passenger Count
1
Trip Distance
7.23
Fare Amount
28.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:07.000
Lpep Dropoff Datetime
2016-01-01T00:40:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905220031738281
Pickup Latitude
40.745285034179688
Dropoff Longitude
-73.920181274414063
Dropoff Latitude
40.743198394775391
Passenger Count
2
Trip Distance
0.93
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:33:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:13.000
Lpep Dropoff Datetime
2016-01-01T00:41:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.852256774902344
Pickup Latitude
40.687118530273438
Dropoff Longitude
-73.814437866210937
Dropoff Latitude
40.697101593017578
Passenger Count
1
Trip Distance
2.11
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:17:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:16.000
Lpep Dropoff Datetime
2016-01-01T00:40:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970756530761719
Pickup Latitude
40.67352294921875
Dropoff Longitude
-73.926521301269531
Dropoff Latitude
40.694087982177734
Passenger Count
1
Trip Distance
4.51
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-01T00:18:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:37:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:36.000
Lpep Dropoff Datetime
2016-01-01T00:37:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994056701660156
Pickup Latitude
40.7027587890625
Dropoff Longitude
-73.972259521484375
Dropoff Latitude
40.755420684814453
Passenger Count
1
Trip Distance
6.69
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-01T00:35:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:47.000
Lpep Dropoff Datetime
2016-01-01T00:40:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891036987304688
Pickup Latitude
40.746936798095703
Dropoff Longitude
-73.87969970703125
Dropoff Latitude
40.748542785644531
Passenger Count
1
Trip Distance
0.53
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:25:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:50.000
Lpep Dropoff Datetime
2016-01-01T00:41:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890945434570313
Pickup Latitude
40.832073211669922
Dropoff Longitude
-73.918678283691406
Dropoff Latitude
40.823196411132812
Passenger Count
1
Trip Distance
2.90
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:28:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:40:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:10.000
Lpep Dropoff Datetime
2016-01-01T00:40:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953018188476563
Pickup Latitude
40.717697143554688
Dropoff Longitude
-73.986892700195313
Dropoff Latitude
40.732448577880859
Passenger Count
2
Trip Distance
3.47
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