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:55:28.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:28.000
Lpep Dropoff Datetime
2016-01-01T02:07:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911163330078125
Pickup Latitude
40.837913513183594
Dropoff Longitude
-73.931564331054688
Dropoff Latitude
40.852180480957031
Passenger Count
1
Trip Distance
2.23
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:58:17.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:17.000
Lpep Dropoff Datetime
2016-01-01T02:07:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986679077148438
Pickup Latitude
40.702266693115234
Dropoff Longitude
-73.992156982421875
Dropoff Latitude
40.689968109130859
Passenger Count
1
Trip Distance
1.15
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
2.79
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.09
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:37.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:37.000
Lpep Dropoff Datetime
2016-01-01T02:07:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948440551757813
Pickup Latitude
40.829448699951172
Dropoff Longitude
-73.895896911621094
Dropoff Latitude
40.83367919921875
Passenger Count
1
Trip Distance
3.52
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-01T01:48:46.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:46.000
Lpep Dropoff Datetime
2016-01-01T02:07:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95343017578125
Pickup Latitude
40.668716430664063
Dropoff Longitude
-73.928413391113281
Dropoff Latitude
40.703376770019531
Passenger Count
1
Trip Distance
3.83
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-01T01:55:08.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:08.000
Lpep Dropoff Datetime
2016-01-01T02:07:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927543640136719
Pickup Latitude
40.865318298339844
Dropoff Longitude
-73.902122497558594
Dropoff Latitude
40.875511169433594
Passenger Count
1
Trip Distance
2.19
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:45:46.000 • Lpep Dropoff Datetime: 2016-01-01T02:06:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:46.000
Lpep Dropoff Datetime
2016-01-01T02:06:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92547607421875
Pickup Latitude
40.772113800048828
Dropoff Longitude
-73.972343444824219
Dropoff Latitude
40.793685913085938
Passenger Count
1
Trip Distance
6.68
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:17.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:17.000
Lpep Dropoff Datetime
2016-01-01T02:07:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.856712341308594
Pickup Latitude
40.751197814941406
Dropoff Longitude
-73.866653442382813
Dropoff Latitude
40.767696380615234
Passenger Count
1
Trip Distance
1.77
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:55:48.000 • Lpep Dropoff Datetime: 2016-01-01T02:05:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:48.000
Lpep Dropoff Datetime
2016-01-01T02:05:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947090148925781
Pickup Latitude
40.678207397460938
Dropoff Longitude
-73.924606323242188
Dropoff Latitude
40.689937591552734
Passenger Count
1
Trip Distance
1.95
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-01T01:58:56.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:56.000
Lpep Dropoff Datetime
2016-01-01T02:07:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963005065917969
Pickup Latitude
40.711746215820312
Dropoff Longitude
-73.947746276855469
Dropoff Latitude
40.694828033447266
Passenger Count
1
Trip Distance
2.01
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:59:17.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:17.000
Lpep Dropoff Datetime
2016-01-01T02:07:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938186645507812
Pickup Latitude
40.827903747558594
Dropoff Longitude
-73.95086669921875
Dropoff Latitude
40.825843811035156
Passenger Count
1
Trip Distance
0.91
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:52:23.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:23.000
Lpep Dropoff Datetime
2016-01-01T02:07:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961257934570313
Pickup Latitude
40.693958282470703
Dropoff Longitude
-73.956138610839844
Dropoff Latitude
40.653244018554687
Passenger Count
1
Trip Distance
3.17
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
3.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:47.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:47.000
Lpep Dropoff Datetime
2016-01-01T02:07:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.989700317382812
Pickup Latitude
40.663600921630859
Dropoff Longitude
-73.985870361328125
Dropoff Latitude
40.735904693603516
Passenger Count
1
Trip Distance
8.42
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:53.000 • Lpep Dropoff Datetime: 2016-01-01T02:06:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:53.000
Lpep Dropoff Datetime
2016-01-01T02:06:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.995269775390625
Pickup Latitude
40.679542541503906
Dropoff Longitude
-73.973884582519531
Dropoff Latitude
40.673053741455078
Passenger Count
1
Trip Distance
1.63
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:52:55.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:55.000
Lpep Dropoff Datetime
2016-01-01T02:07:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917617797851562
Pickup Latitude
40.834815979003906
Dropoff Longitude
-73.942474365234375
Dropoff Latitude
40.786251068115234
Passenger Count
1
Trip Distance
4.77
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:13.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:13.000
Lpep Dropoff Datetime
2016-01-01T02:07:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983329772949219
Pickup Latitude
40.695930480957031
Dropoff Longitude
-73.986099243164062
Dropoff Latitude
40.72235107421875
Passenger Count
1
Trip Distance
2.38
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:56:12.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:12.000
Lpep Dropoff Datetime
2016-01-01T02:08:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90765380859375
Pickup Latitude
40.71728515625
Dropoff Longitude
-73.892120361328125
Dropoff Latitude
40.746803283691406
Passenger Count
1
Trip Distance
2.59
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-01T01:58:15.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:15.000
Lpep Dropoff Datetime
2016-01-01T02:07:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.898246765136719
Pickup Latitude
40.746112823486328
Dropoff Longitude
-73.874923706054688
Dropoff Latitude
40.750698089599609
Passenger Count
1
Trip Distance
1.40
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:29:05.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:05.000
Lpep Dropoff Datetime
2016-01-01T02:07:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988655090332031
Pickup Latitude
40.694869995117187
Dropoff Longitude
-73.982269287109375
Dropoff Latitude
40.774085998535156
Passenger Count
1
Trip Distance
7.58
Fare Amount
31
Extra
0.5
Mta Tax
0.5
Tip Amount
6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
38.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:46:16.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:16.000
Lpep Dropoff Datetime
2016-01-01T02:07:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903648376464844
Pickup Latitude
40.822883605957031
Dropoff Longitude
-73.933647155761719
Dropoff Latitude
40.773033142089844
Passenger Count
1
Trip Distance
6.81
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.87
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
35.21
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:43:32.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:43:32.000
Lpep Dropoff Datetime
2016-01-01T02:07:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915214538574219
Pickup Latitude
40.742584228515625
Dropoff Longitude
-73.796768188476562
Dropoff Latitude
40.764812469482422
Passenger Count
1
Trip Distance
10.17
Fare Amount
30.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:52:40.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:40.000
Lpep Dropoff Datetime
2016-01-01T02:07:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914344787597656
Pickup Latitude
40.760646820068359
Dropoff Longitude
-73.878631591796875
Dropoff Latitude
40.756221771240234
Passenger Count
1
Trip Distance
3.26
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-01T01:51:20.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:20.000
Lpep Dropoff Datetime
2016-01-01T02:07:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957565307617188
Pickup Latitude
40.671676635742188
Dropoff Longitude
-73.990432739257813
Dropoff Latitude
40.714466094970703
Passenger Count
1
Trip Distance
4.22
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:35:27.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:27.000
Lpep Dropoff Datetime
2016-01-01T02:07:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921394348144531
Pickup Latitude
40.867912292480469
Dropoff Longitude
-73.977607727050781
Dropoff Latitude
40.746135711669922
Passenger Count
1
Trip Distance
11.05
Fare Amount
36
Extra
0.5
Mta Tax
0.5
Tip Amount
7.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
44.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:03.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:03.000
Lpep Dropoff Datetime
2016-01-01T02:07:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947959899902344
Pickup Latitude
40.7869873046875
Dropoff Longitude
-73.989631652832031
Dropoff Latitude
40.711261749267578
Passenger Count
1
Trip Distance
7.02
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-01T01:37:49.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:49.000
Lpep Dropoff Datetime
2016-01-01T02:07:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903144836425781
Pickup Latitude
40.753768920898438
Dropoff Longitude
-73.948776245117187
Dropoff Latitude
40.832324981689453
Passenger Count
1
Trip Distance
10.90
Fare Amount
33.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:30:12.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:12.000
Lpep Dropoff Datetime
2016-01-01T02:07:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939857482910156
Pickup Latitude
40.6844482421875
Dropoff Longitude
-74.003570556640625
Dropoff Latitude
40.725337982177734
Passenger Count
1
Trip Distance
5.92
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:59.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:59.000
Lpep Dropoff Datetime
2016-01-01T02:07:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.830116271972656
Pickup Latitude
40.713771820068359
Dropoff Longitude
-73.827903747558594
Dropoff Latitude
40.69384765625
Passenger Count
2
Trip Distance
1.73
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:38:57.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:57.000
Lpep Dropoff Datetime
2016-01-01T02:07:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920051574707031
Pickup Latitude
40.690517425537109
Dropoff Longitude
-73.957344055175781
Dropoff Latitude
40.714580535888672
Passenger Count
1
Trip Distance
3.24
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:56:02.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:02.000
Lpep Dropoff Datetime
2016-01-01T02:07:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.996200561523438
Pickup Latitude
40.684032440185547
Dropoff Longitude
-73.975982666015625
Dropoff Latitude
40.669498443603516
Passenger Count
1
Trip Distance
1.75
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:48:22.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:48:22.000
Lpep Dropoff Datetime
2016-01-01T02:07:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.866462707519531
Pickup Latitude
40.742710113525391
Dropoff Longitude
-73.900184631347656
Dropoff Latitude
40.712757110595703
Passenger Count
1
Trip Distance
4.76
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:52:49.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:49.000
Lpep Dropoff Datetime
2016-01-01T02:08:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.997627258300781
Pickup Latitude
40.693599700927734
Dropoff Longitude
-73.961349487304688
Dropoff Latitude
40.678062438964844
Passenger Count
1
Trip Distance
2.88
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.14
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.94
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:24.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:24.000
Lpep Dropoff Datetime
2016-01-01T02:07:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953231811523438
Pickup Latitude
40.791595458984375
Dropoff Longitude
-73.965591430664063
Dropoff Latitude
40.755485534667969
Passenger Count
1
Trip Distance
3.04
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:30.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:30.000
Lpep Dropoff Datetime
2016-01-01T02:07:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.817428588867188
Pickup Latitude
40.717670440673828
Dropoff Longitude
-73.807769775390625
Dropoff Latitude
40.700611114501953
Passenger Count
1
Trip Distance
2.16
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:59:18.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:18.000
Lpep Dropoff Datetime
2016-01-01T02:07:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966194152832031
Pickup Latitude
40.68817138671875
Dropoff Longitude
-73.974929809570313
Dropoff Latitude
40.675182342529297
Passenger Count
1
Trip Distance
1.75
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:28:57.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:28:57.000
Lpep Dropoff Datetime
2016-01-01T02:08:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948654174804688
Pickup Latitude
40.680286407470703
Dropoff Longitude
-73.921699523925781
Dropoff Latitude
40.766414642333984
Passenger Count
1
Trip Distance
9.74
Fare Amount
34.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
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:58:11.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:11.000
Lpep Dropoff Datetime
2016-01-01T02:08:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937263488769531
Pickup Latitude
40.824367523193359
Dropoff Longitude
-73.947944641113281
Dropoff Latitude
40.829639434814453
Passenger Count
1
Trip Distance
1.16
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
2.79
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.09
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:34:58.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:58.000
Lpep Dropoff Datetime
2016-01-01T02:07:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98699951171875
Pickup Latitude
40.702434539794922
Dropoff Longitude
-73.986953735351563
Dropoff Latitude
40.748420715332031
Passenger Count
1
Trip Distance
5.27
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:54:31.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:31.000
Lpep Dropoff Datetime
2016-01-01T02:08:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963172912597656
Pickup Latitude
40.711082458496094
Dropoff Longitude
-73.933029174804688
Dropoff Latitude
40.707588195800781
Passenger Count
3
Trip Distance
1.77
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:51:16.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:16.000
Lpep Dropoff Datetime
2016-01-01T02:07:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909538269042969
Pickup Latitude
40.761367797851563
Dropoff Longitude
-73.802223205566406
Dropoff Latitude
40.720752716064453
Passenger Count
1
Trip Distance
8.74
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-01T01:59:42.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:42.000
Lpep Dropoff Datetime
2016-01-01T02:08:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890823364257813
Pickup Latitude
40.746879577636719
Dropoff Longitude
-73.884841918945313
Dropoff Latitude
40.753162384033203
Passenger Count
1
Trip Distance
0.82
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:44:51.000 • Lpep Dropoff Datetime: 2016-01-01T02:06:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:51.000
Lpep Dropoff Datetime
2016-01-01T02:06:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.887374877929688
Pickup Latitude
40.747337341308594
Dropoff Longitude
-73.859260559082031
Dropoff Latitude
40.745807647705078
Passenger Count
1
Trip Distance
3.67
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:58:25.000 • Lpep Dropoff Datetime: 2016-01-01T02:07:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:25.000
Lpep Dropoff Datetime
2016-01-01T02:07:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.792900085449219
Pickup Latitude
40.710792541503906
Dropoff Longitude
-73.821662902832031
Dropoff Latitude
40.692787170410156
Passenger Count
1
Trip Distance
2.61
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:56:52.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:52.000
Lpep Dropoff Datetime
2016-01-01T02:08:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948829650878906
Pickup Latitude
40.828571319580078
Dropoff Longitude
-73.934783935546875
Dropoff Latitude
40.845321655273438
Passenger Count
1
Trip Distance
1.53
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:21.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:21.000
Lpep Dropoff Datetime
2016-01-01T02:08:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.88323974609375
Pickup Latitude
40.747726440429688
Dropoff Longitude
-73.866828918457031
Dropoff Latitude
40.757434844970703
Passenger Count
1
Trip Distance
1.38
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:50.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:50.000
Lpep Dropoff Datetime
2016-01-01T02:08:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935005187988281
Pickup Latitude
40.696937561035156
Dropoff Longitude
-74.012367248535156
Dropoff Latitude
40.701473236083984
Passenger Count
1
Trip Distance
6.47
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:18.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:18.000
Lpep Dropoff Datetime
2016-01-01T02:08:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.898651123046875
Pickup Latitude
40.889312744140625
Dropoff Longitude
-73.904678344726563
Dropoff Latitude
40.854095458984375
Passenger Count
1
Trip Distance
3.24
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:46:16.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:46:16.000
Lpep Dropoff Datetime
2016-01-01T02:08:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958000183105469
Pickup Latitude
40.675441741943359
Dropoff Longitude
-73.917236328125
Dropoff Latitude
40.701568603515625
Passenger Count
6
Trip Distance
4.15
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
3.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:15.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:15.000
Lpep Dropoff Datetime
2016-01-01T02:08:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940834045410156
Pickup Latitude
40.798362731933594
Dropoff Longitude
-73.93914794921875
Dropoff Latitude
40.821430206298828
Passenger Count
1
Trip Distance
1.91
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:57:28.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:57:28.000
Lpep Dropoff Datetime
2016-01-01T02:08:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982330322265625
Pickup Latitude
40.665969848632812
Dropoff Longitude
-73.956459045410156
Dropoff Latitude
40.674064636230469
Passenger Count
1
Trip Distance
1.87
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:56:24.000 • Lpep Dropoff Datetime: 2016-01-01T02:08:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:24.000
Lpep Dropoff Datetime
2016-01-01T02:08:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992782592773438
Pickup Latitude
40.697608947753906
Dropoff Longitude
-73.958152770996094
Dropoff Latitude
40.710884094238281
Passenger Count
1
Trip Distance
3.54
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