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:31:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:31:01.000
Lpep Dropoff Datetime
2016-01-01T01:39:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915687561035156
Pickup Latitude
40.772228240966797
Dropoff Longitude
-73.926193237304688
Dropoff Latitude
40.769985198974609
Passenger Count
1
Trip Distance
0.84
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:38:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:54.000
Lpep Dropoff Datetime
2016-01-01T01:40:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950485229492187
Pickup Latitude
40.684795379638672
Dropoff Longitude
-73.95880126953125
Dropoff Latitude
40.683132171630859
Passenger Count
1
Trip Distance
0.52
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:34:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:47.000
Lpep Dropoff Datetime
2016-01-01T01:40:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912864685058594
Pickup Latitude
40.774543762207031
Dropoff Longitude
-73.917953491210938
Dropoff Latitude
40.770126342773438
Passenger Count
2
Trip Distance
0.39
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:18:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:18:44.000
Lpep Dropoff Datetime
2016-01-01T01:40:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918861389160156
Pickup Latitude
40.765735626220703
Dropoff Longitude
-73.933883666992188
Dropoff Latitude
40.694190979003906
Passenger Count
1
Trip Distance
7.87
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:21:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:21:44.000
Lpep Dropoff Datetime
2016-01-01T01:40:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9542236328125
Pickup Latitude
40.800674438476562
Dropoff Longitude
-73.938484191894531
Dropoff Latitude
40.846282958984375
Passenger Count
1
Trip Distance
5.03
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:05:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:05:52.000
Lpep Dropoff Datetime
2016-01-01T01:40:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981643676757813
Pickup Latitude
40.679386138916016
Dropoff Longitude
-73.91046142578125
Dropoff Latitude
40.707050323486328
Passenger Count
1
Trip Distance
7.39
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
7.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:23:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:23:12.000
Lpep Dropoff Datetime
2016-01-01T01:40:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95318603515625
Pickup Latitude
40.817520141601563
Dropoff Longitude
-73.951744079589844
Dropoff Latitude
40.782882690429687
Passenger Count
1
Trip Distance
3.17
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-01T01:19:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:19:57.000
Lpep Dropoff Datetime
2016-01-01T01:40:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.995193481445313
Pickup Latitude
40.663036346435547
Dropoff Longitude
-73.93902587890625
Dropoff Latitude
40.67559814453125
Passenger Count
1
Trip Distance
4.01
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:24:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:24:32.000
Lpep Dropoff Datetime
2016-01-01T01:40:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.99530029296875
Pickup Latitude
40.688255310058594
Dropoff Longitude
-73.951271057128906
Dropoff Latitude
40.671676635742188
Passenger Count
1
Trip Distance
3.20
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:26:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:26:29.000
Lpep Dropoff Datetime
2016-01-01T01:40:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957138061523438
Pickup Latitude
40.712089538574219
Dropoff Longitude
-73.958137512207031
Dropoff Latitude
40.670333862304688
Passenger Count
2
Trip Distance
3.42
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:31:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:31:35.000
Lpep Dropoff Datetime
2016-01-01T01:39:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937454223632812
Pickup Latitude
40.839218139648438
Dropoff Longitude
-73.952484130859375
Dropoff Latitude
40.818954467773438
Passenger Count
1
Trip Distance
1.67
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:16:00.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:16:00.000
Lpep Dropoff Datetime
2016-01-01T01:40:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982078552246094
Pickup Latitude
40.662101745605469
Dropoff Longitude
-73.985244750976563
Dropoff Latitude
40.731807708740234
Passenger Count
1
Trip Distance
6.63
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:22:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:22:54.000
Lpep Dropoff Datetime
2016-01-01T01:40:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936080932617188
Pickup Latitude
40.760585784912109
Dropoff Longitude
-73.811737060546875
Dropoff Latitude
40.735942840576172
Passenger Count
1
Trip Distance
9.05
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:21:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:21:19.000
Lpep Dropoff Datetime
2016-01-01T01:40:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940910339355469
Pickup Latitude
40.786685943603516
Dropoff Longitude
-73.954246520996094
Dropoff Latitude
40.823276519775391
Passenger Count
2
Trip Distance
3.89
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:23:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:23:56.000
Lpep Dropoff Datetime
2016-01-01T01:40:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844406127929688
Pickup Latitude
40.721412658691406
Dropoff Longitude
-73.831199645996094
Dropoff Latitude
40.730663299560547
Passenger Count
1
Trip Distance
1.92
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:38:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:13.000
Lpep Dropoff Datetime
2016-01-01T01:40:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940147399902344
Pickup Latitude
40.750251770019531
Dropoff Longitude
-73.94195556640625
Dropoff Latitude
40.747261047363281
Passenger Count
1
Trip Distance
0.37
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:29:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:19.000
Lpep Dropoff Datetime
2016-01-01T01:40:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.929641723632812
Pickup Latitude
40.757057189941406
Dropoff Longitude
-73.918495178222656
Dropoff Latitude
40.7745361328125
Passenger Count
1
Trip Distance
1.72
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:07:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:07:06.000
Lpep Dropoff Datetime
2016-01-01T01:40:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991561889648438
Pickup Latitude
40.663089752197266
Dropoff Longitude
-73.916656494140625
Dropoff Latitude
40.689037322998047
Passenger Count
1
Trip Distance
5.40
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
5.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:25:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:25:22.000
Lpep Dropoff Datetime
2016-01-01T01:41:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946586608886719
Pickup Latitude
40.792438507080078
Dropoff Longitude
-73.950935363769531
Dropoff Latitude
40.825023651123047
Passenger Count
1
Trip Distance
3.96
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:31:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:31:24.000
Lpep Dropoff Datetime
2016-01-01T01:40:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.928375244140625
Pickup Latitude
40.755855560302734
Dropoff Longitude
-73.945465087890625
Dropoff Latitude
40.745956420898438
Passenger Count
1
Trip Distance
1.36
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:30:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:34.000
Lpep Dropoff Datetime
2016-01-01T01:41:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.829917907714844
Pickup Latitude
40.713726043701172
Dropoff Longitude
-73.8468017578125
Dropoff Latitude
40.688106536865234
Passenger Count
1
Trip Distance
3.41
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:27:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:27:20.000
Lpep Dropoff Datetime
2016-01-01T01:39:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942405700683594
Pickup Latitude
40.812156677246094
Dropoff Longitude
-73.968460083007813
Dropoff Latitude
40.800727844238281
Passenger Count
2
Trip Distance
2.15
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:23:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:23:28.000
Lpep Dropoff Datetime
2016-01-01T01:40:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918838500976562
Pickup Latitude
40.758857727050781
Dropoff Longitude
-73.976104736328125
Dropoff Latitude
40.75140380859375
Passenger Count
1
Trip Distance
4.75
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:22:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:22:05.000
Lpep Dropoff Datetime
2016-01-01T01:40:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950782775878906
Pickup Latitude
40.709300994873047
Dropoff Longitude
-73.890083312988281
Dropoff Latitude
40.729263305664063
Passenger Count
1
Trip Distance
0.00
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-01T01:29:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:20.000
Lpep Dropoff Datetime
2016-01-01T01:41:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962547302246094
Pickup Latitude
40.682601928710938
Dropoff Longitude
-74.000839233398437
Dropoff Latitude
40.685592651367188
Passenger Count
1
Trip Distance
2.62
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:34:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:03.000
Lpep Dropoff Datetime
2016-01-01T01:41:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.910781860351563
Pickup Latitude
40.775901794433594
Dropoff Longitude
-73.9119873046875
Dropoff Latitude
40.767578125
Passenger Count
3
Trip Distance
0.81
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:35:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:41.000
Lpep Dropoff Datetime
2016-01-01T01:41:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915359497070313
Pickup Latitude
40.713508605957031
Dropoff Longitude
-73.937156677246094
Dropoff Latitude
40.709423065185547
Passenger Count
1
Trip Distance
1.45
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:26:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:26:19.000
Lpep Dropoff Datetime
2016-01-01T01:41:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943168640136719
Pickup Latitude
40.716846466064453
Dropoff Longitude
-73.990264892578125
Dropoff Latitude
40.686988830566406
Passenger Count
1
Trip Distance
4.38
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:22:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:22:48.000
Lpep Dropoff Datetime
2016-01-01T01:40:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953483581542969
Pickup Latitude
40.667396545410156
Dropoff Longitude
-73.99700927734375
Dropoff Latitude
40.697055816650391
Passenger Count
1
Trip Distance
3.76
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:16.000
Lpep Dropoff Datetime
2016-01-01T01:40:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919929504394531
Pickup Latitude
40.756282806396484
Dropoff Longitude
-73.974929809570313
Dropoff Latitude
40.792942047119141
Passenger Count
2
Trip Distance
5.94
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:29:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:55.000
Lpep Dropoff Datetime
2016-01-01T01:41:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947341918945312
Pickup Latitude
40.711921691894531
Dropoff Longitude
-73.959884643554688
Dropoff Latitude
40.717803955078125
Passenger Count
1
Trip Distance
1.07
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:28:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:28:10.000
Lpep Dropoff Datetime
2016-01-01T01:40:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951507568359375
Pickup Latitude
40.742778778076172
Dropoff Longitude
-73.969200134277344
Dropoff Latitude
40.6947021484375
Passenger Count
1
Trip Distance
4.04
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-01T01:34:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:57.000
Lpep Dropoff Datetime
2016-01-01T01:40:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.886627197265625
Pickup Latitude
40.764572143554687
Dropoff Longitude
-73.894248962402344
Dropoff Latitude
40.75677490234375
Passenger Count
1
Trip Distance
1.09
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:14:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:14:51.000
Lpep Dropoff Datetime
2016-01-01T01:41:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953224182128906
Pickup Latitude
40.691135406494141
Dropoff Longitude
-74.008399963378906
Dropoff Latitude
40.647605895996094
Passenger Count
2
Trip Distance
5.03
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
6.69
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.99
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:36:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:36:38.000
Lpep Dropoff Datetime
2016-01-01T01:41:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939598083496094
Pickup Latitude
40.794685363769531
Dropoff Longitude
-73.950218200683594
Dropoff Latitude
40.788928985595703
Passenger Count
1
Trip Distance
1.05
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:26:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:26:05.000
Lpep Dropoff Datetime
2016-01-01T01:40:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.901893615722656
Pickup Latitude
40.819339752197266
Dropoff Longitude
-73.88336181640625
Dropoff Latitude
40.845390319824219
Passenger Count
1
Trip Distance
2.26
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-01T01:34:42.000 • Lpep Dropoff Datetime: 2016-01-02T01:32:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:42.000
Lpep Dropoff Datetime
2016-01-02T01:32:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.857284545898438
Pickup Latitude
40.739181518554688
Dropoff Longitude
-73.8663330078125
Dropoff Latitude
40.748996734619141
Passenger Count
2
Trip Distance
1.04
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
0.73
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.03
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:35:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:35.000
Lpep Dropoff Datetime
2016-01-01T01:40:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92041015625
Pickup Latitude
40.766410827636719
Dropoff Longitude
-73.927322387695312
Dropoff Latitude
40.773151397705078
Passenger Count
2
Trip Distance
0.78
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-01T01:30:06.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:06.000
Lpep Dropoff Datetime
2016-01-01T01:41:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9957275390625
Pickup Latitude
40.695163726806641
Dropoff Longitude
-74.002655029296875
Dropoff Latitude
40.721206665039063
Passenger Count
1
Trip Distance
2.94
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:30:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:07.000
Lpep Dropoff Datetime
2016-01-01T01:40:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964385986328125
Pickup Latitude
40.712497711181641
Dropoff Longitude
-73.981697082519531
Dropoff Latitude
40.690143585205078
Passenger Count
1
Trip Distance
3.66
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:28:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:28:47.000
Lpep Dropoff Datetime
2016-01-01T01:40:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953659057617188
Pickup Latitude
40.682323455810547
Dropoff Longitude
-73.972251892089844
Dropoff Latitude
40.695358276367188
Passenger Count
5
Trip Distance
1.91
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:20:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:20:50.000
Lpep Dropoff Datetime
2016-01-01T01:40:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945144653320312
Pickup Latitude
40.807647705078125
Dropoff Longitude
-73.924598693847656
Dropoff Latitude
40.866348266601563
Passenger Count
1
Trip Distance
4.85
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:30:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:19.000
Lpep Dropoff Datetime
2016-01-01T01:40:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924667358398438
Pickup Latitude
40.756263732910156
Dropoff Longitude
-73.903350830078125
Dropoff Latitude
40.745540618896484
Passenger Count
1
Trip Distance
1.98
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:27:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:27:49.000
Lpep Dropoff Datetime
2016-01-01T01:40:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962974548339844
Pickup Latitude
40.673881530761719
Dropoff Longitude
-73.925010681152344
Dropoff Latitude
40.676349639892578
Passenger Count
1
Trip Distance
2.83
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-01T01:33:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:40.000
Lpep Dropoff Datetime
2016-01-01T01:40:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937515258789062
Pickup Latitude
40.828880310058594
Dropoff Longitude
-73.939994812011719
Dropoff Latitude
40.828815460205078
Passenger Count
1
Trip Distance
0.95
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:33:08.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:08.000
Lpep Dropoff Datetime
2016-01-01T01:41:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881484985351563
Pickup Latitude
40.747955322265625
Dropoff Longitude
-73.899749755859375
Dropoff Latitude
40.748893737792969
Passenger Count
1
Trip Distance
1.12
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:24:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:24:39.000
Lpep Dropoff Datetime
2016-01-01T01:41:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956901550292969
Pickup Latitude
40.698661804199219
Dropoff Longitude
-73.93316650390625
Dropoff Latitude
40.667942047119141
Passenger Count
1
Trip Distance
3.26
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:35:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:50.000
Lpep Dropoff Datetime
2016-01-01T01:40:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891769409179687
Pickup Latitude
40.748767852783203
Dropoff Longitude
-73.893600463867188
Dropoff Latitude
40.760410308837891
Passenger Count
1
Trip Distance
0.85
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:27:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:41:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:27:20.000
Lpep Dropoff Datetime
2016-01-01T01:41:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961997985839844
Pickup Latitude
40.697971343994141
Dropoff Longitude
-73.958946228027344
Dropoff Latitude
40.729774475097656
Passenger Count
2
Trip Distance
2.86
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:17:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:40:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:17:25.000
Lpep Dropoff Datetime
2016-01-01T01:40:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.929237365722656
Pickup Latitude
40.684093475341797
Dropoff Longitude
-73.958267211914063
Dropoff Latitude
40.721763610839844
Passenger Count
1
Trip Distance
4.00
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