2017 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 5gj9-2kzx 19 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:16:50.000 • Lpep Dropoff Datetime: 2017-01-01T01:26:21.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:16:50.000
Lpep Dropoff Datetime
2017-01-01T01:26:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
129
Passenger Count
1
Trip Distance
2.29
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:14:48.000 • Lpep Dropoff Datetime: 2017-01-01T01:28:27.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:14:48.000
Lpep Dropoff Datetime
2017-01-01T01:28:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
129
Passenger Count
1
Trip Distance
3.39
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: 2017-01-01T01:29:27.000 • Lpep Dropoff Datetime: 2017-01-01T01:35:47.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:29:27.000
Lpep Dropoff Datetime
2017-01-01T01:35:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
260
Passenger Count
1
Trip Distance
1.15
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: 2017-01-01T01:37:58.000 • Lpep Dropoff Datetime: 2017-01-01T01:58:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:37:58.000
Lpep Dropoff Datetime
2017-01-01T01:58:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
95
Passenger Count
1
Trip Distance
4.66
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: 2017-01-01T01:22:46.000 • Lpep Dropoff Datetime: 2017-01-01T02:01:25.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:22:46.000
Lpep Dropoff Datetime
2017-01-01T02:01:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
132
Passenger Count
1
Trip Distance
26.83
Fare Amount
70.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
71.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:03:01.000 • Lpep Dropoff Datetime: 2017-01-01T01:25:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:03:01.000
Lpep Dropoff Datetime
2017-01-01T01:25:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
241
Passenger Count
1
Trip Distance
7.20
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:28:31.000 • Lpep Dropoff Datetime: 2017-01-01T01:46:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:28:31.000
Lpep Dropoff Datetime
2017-01-01T01:46:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
241
Dolocationid
244
Passenger Count
1
Trip Distance
3.19
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:48:51.000 • Lpep Dropoff Datetime: 2017-01-01T01:56:16.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:48:51.000
Lpep Dropoff Datetime
2017-01-01T01:56:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
244
Dolocationid
244
Passenger Count
1
Trip Distance
0.97
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: 2017-01-01T01:57:38.000 • Lpep Dropoff Datetime: 2017-01-01T02:08:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:57:38.000
Lpep Dropoff Datetime
2017-01-01T02:08:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
244
Dolocationid
243
Passenger Count
1
Trip Distance
2.81
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: 2017-01-01T01:46:25.000 • Lpep Dropoff Datetime: 2017-01-01T02:08:40.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:46:25.000
Lpep Dropoff Datetime
2017-01-01T02:08:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
16
Dolocationid
164
Passenger Count
1
Trip Distance
14.03
Fare Amount
38.5
Extra
0.5
Mta Tax
0.5
Tip Amount
9.07
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
54.41
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:06:32.000 • Lpep Dropoff Datetime: 2017-01-01T01:14:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:06:32.000
Lpep Dropoff Datetime
2017-01-01T01:14:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
49
Dolocationid
97
Passenger Count
1
Trip Distance
1.45
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: 2017-01-01T01:15:35.000 • Lpep Dropoff Datetime: 2017-01-01T01:50:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:15:35.000
Lpep Dropoff Datetime
2017-01-01T01:50:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
223
Passenger Count
1
Trip Distance
9.50
Fare Amount
32.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:28:03.000 • Lpep Dropoff Datetime: 2017-01-01T01:33:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:28:03.000
Lpep Dropoff Datetime
2017-01-01T01:33:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
130
Passenger Count
1
Trip Distance
1.63
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: 2017-01-01T01:46:50.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:16.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:46:50.000
Lpep Dropoff Datetime
2017-01-01T01:52:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
121
Passenger Count
1
Trip Distance
1.66
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: 2017-01-01T01:11:56.000 • Lpep Dropoff Datetime: 2017-01-01T01:21:27.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:11:56.000
Lpep Dropoff Datetime
2017-01-01T01:21:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
40
Dolocationid
106
Passenger Count
3
Trip Distance
1.63
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:36:59.000 • Lpep Dropoff Datetime: 2017-01-01T02:14:17.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:36:59.000
Lpep Dropoff Datetime
2017-01-01T02:14:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
202
Passenger Count
3
Trip Distance
8.32
Fare Amount
30
Extra
0.5
Mta Tax
0.5
Tip Amount
6.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
37.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:00:54.000 • Lpep Dropoff Datetime: 2017-01-01T01:17:25.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:00:54.000
Lpep Dropoff Datetime
2017-01-01T01:17:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
147
Dolocationid
185
Passenger Count
1
Trip Distance
3.60
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:03:14.000 • Lpep Dropoff Datetime: 2017-01-01T01:20:59.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:03:14.000
Lpep Dropoff Datetime
2017-01-01T01:20:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
243
Dolocationid
69
Passenger Count
1
Trip Distance
3.27
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:31:49.000 • Lpep Dropoff Datetime: 2017-01-01T01:38:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:31:49.000
Lpep Dropoff Datetime
2017-01-01T01:38:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
116
Passenger Count
1
Trip Distance
0.81
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: 2017-01-01T01:39:57.000 • Lpep Dropoff Datetime: 2017-01-01T02:14:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:39:57.000
Lpep Dropoff Datetime
2017-01-01T02:14:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
106
Passenger Count
1
Trip Distance
15.97
Fare Amount
45
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
46.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:15:53.000 • Lpep Dropoff Datetime: 2017-01-01T01:19:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:15:53.000
Lpep Dropoff Datetime
2017-01-01T01:19:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
244
Dolocationid
244
Passenger Count
1
Trip Distance
0.56
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: 2017-01-01T01:24:59.000 • Lpep Dropoff Datetime: 2017-01-01T01:32:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:24:59.000
Lpep Dropoff Datetime
2017-01-01T01:32:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
116
Passenger Count
1
Trip Distance
1.17
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: 2017-01-01T01:45:48.000 • Lpep Dropoff Datetime: 2017-01-01T01:56:41.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:45:48.000
Lpep Dropoff Datetime
2017-01-01T01:56:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
152
Dolocationid
74
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:03:52.000 • Lpep Dropoff Datetime: 2017-01-01T01:31:29.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:03:52.000
Lpep Dropoff Datetime
2017-01-01T01:31:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
49
Passenger Count
1
Trip Distance
8.38
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
5.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:20:05.000 • Lpep Dropoff Datetime: 2017-01-01T01:27:11.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:20:05.000
Lpep Dropoff Datetime
2017-01-01T01:27:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
25
Passenger Count
1
Trip Distance
1.55
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: 2017-01-01T01:39:47.000 • Lpep Dropoff Datetime: 2017-01-01T02:07:18.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:39:47.000
Lpep Dropoff Datetime
2017-01-01T02:07:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
106
Dolocationid
158
Passenger Count
1
Trip Distance
5.20
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:21:29.000 • Lpep Dropoff Datetime: 2017-01-01T01:31:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:21:29.000
Lpep Dropoff Datetime
2017-01-01T01:31:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
129
Passenger Count
1
Trip Distance
1.06
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: 2017-01-01T01:33:19.000 • Lpep Dropoff Datetime: 2017-01-01T01:38:40.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:33:19.000
Lpep Dropoff Datetime
2017-01-01T01:38:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
223
Passenger Count
1
Trip Distance
1.89
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: 2017-01-01T01:41:27.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:41:27.000
Lpep Dropoff Datetime
2017-01-01T01:52:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
7
Passenger Count
1
Trip Distance
2.05
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:56:09.000 • Lpep Dropoff Datetime: 2017-01-01T02:11:50.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:56:09.000
Lpep Dropoff Datetime
2017-01-01T02:11:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
226
Passenger Count
1
Trip Distance
3.19
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: 2017-01-01T01:23:15.000 • Lpep Dropoff Datetime: 2017-01-01T01:44:24.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:23:15.000
Lpep Dropoff Datetime
2017-01-01T01:44:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
95
Passenger Count
1
Trip Distance
7.62
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:46:02.000 • Lpep Dropoff Datetime: 2017-01-01T01:54:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:46:02.000
Lpep Dropoff Datetime
2017-01-01T01:54:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
134
Passenger Count
1
Trip Distance
0.88
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: 2017-01-01T01:02:31.000 • Lpep Dropoff Datetime: 2017-01-01T01:22:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:02:31.000
Lpep Dropoff Datetime
2017-01-01T01:22:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
162
Passenger Count
5
Trip Distance
7.48
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
9.1
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
41.39
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:46:54.000 • Lpep Dropoff Datetime: 2017-01-01T01:46:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:46:54.000
Lpep Dropoff Datetime
2017-01-01T01:46:57.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
7
Dolocationid
7
Passenger Count
1
Trip Distance
0.00
Fare Amount
7
Extra
0
Mta Tax
0
Tip Amount
1.4
Tolls Amount
0
Improvement Surcharge
0
Total Amount
8.4
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:49:14.000 • Lpep Dropoff Datetime: 2017-01-01T01:56:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:49:14.000
Lpep Dropoff Datetime
2017-01-01T01:56:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
223
Passenger Count
5
Trip Distance
1.13
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: 2017-01-01T01:32:51.000 • Lpep Dropoff Datetime: 2017-01-01T01:38:28.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:32:51.000
Lpep Dropoff Datetime
2017-01-01T01:38:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
145
Dolocationid
112
Passenger Count
1
Trip Distance
1.69
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: 2017-01-01T01:40:50.000 • Lpep Dropoff Datetime: 2017-01-01T02:09:17.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:40:50.000
Lpep Dropoff Datetime
2017-01-01T02:09:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
113
Passenger Count
1
Trip Distance
5.56
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
4.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:11:03.000 • Lpep Dropoff Datetime: 2017-01-01T01:23:41.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:11:03.000
Lpep Dropoff Datetime
2017-01-01T01:23:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
188
Dolocationid
17
Passenger Count
1
Trip Distance
2.49
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.71
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:28:59.000 • Lpep Dropoff Datetime: 2017-01-01T01:40:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:28:59.000
Lpep Dropoff Datetime
2017-01-01T01:40:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
225
Passenger Count
1
Trip Distance
1.73
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:46:30.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:46:30.000
Lpep Dropoff Datetime
2017-01-01T01:52:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
225
Passenger Count
1
Trip Distance
0.84
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: 2017-01-01T01:56:00.000 • Lpep Dropoff Datetime: 2017-01-01T02:06:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:56:00.000
Lpep Dropoff Datetime
2017-01-01T02:06:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
188
Passenger Count
1
Trip Distance
2.69
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: 2017-01-01T01:11:37.000 • Lpep Dropoff Datetime: 2017-01-01T01:19:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:11:37.000
Lpep Dropoff Datetime
2017-01-01T01:19:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
7
Passenger Count
5
Trip Distance
0.98
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:28:57.000 • Lpep Dropoff Datetime: 2017-01-01T01:41:48.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:28:57.000
Lpep Dropoff Datetime
2017-01-01T01:41:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
193
Passenger Count
5
Trip Distance
2.67
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: 2017-01-01T01:56:48.000 • Lpep Dropoff Datetime: 2017-01-01T02:02:46.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:56:48.000
Lpep Dropoff Datetime
2017-01-01T02:02:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
Passenger Count
5
Trip Distance
0.99
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.49
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:39:14.000 • Lpep Dropoff Datetime: 2017-01-01T01:50:21.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:39:14.000
Lpep Dropoff Datetime
2017-01-01T01:50:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
112
Passenger Count
1
Trip Distance
2.08
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:54:40.000 • Lpep Dropoff Datetime: 2017-01-01T02:02:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:54:40.000
Lpep Dropoff Datetime
2017-01-01T02:02:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
256
Passenger Count
1
Trip Distance
1.46
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:45:36.000 • Lpep Dropoff Datetime: 2017-01-01T01:49:27.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:45:36.000
Lpep Dropoff Datetime
2017-01-01T01:49:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
260
Passenger Count
1
Trip Distance
0.96
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: 2017-01-01T01:04:54.000 • Lpep Dropoff Datetime: 2017-01-01T01:19:22.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:04:54.000
Lpep Dropoff Datetime
2017-01-01T01:19:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
87
Passenger Count
1
Trip Distance
3.22
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: 2017-01-01T01:28:16.000 • Lpep Dropoff Datetime: 2017-01-01T01:37:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:28:16.000
Lpep Dropoff Datetime
2017-01-01T01:37:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
17
Passenger Count
1
Trip Distance
2.11
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:41:05.000 • Lpep Dropoff Datetime: 2017-01-01T01:50:51.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:41:05.000
Lpep Dropoff Datetime
2017-01-01T01:50:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
256
Passenger Count
1
Trip Distance
1.46
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