Ask NYC Browse All Data Public Safety Transportation Health Buildings

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-01T00:01:15.000 • Lpep Dropoff Datetime: 2017-01-01T00:11:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:15.000
Lpep Dropoff Datetime
2017-01-01T00:11:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
166
Passenger Count
1
Trip Distance
1.71
Fare Amount
9
Extra
0
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: 2017-01-01T00:03:34.000 • Lpep Dropoff Datetime: 2017-01-01T00:09:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:03:34.000
Lpep Dropoff Datetime
2017-01-01T00:09:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
75
Dolocationid
74
Passenger Count
1
Trip Distance
1.44
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-01T00:04:02.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:04:02.000
Lpep Dropoff Datetime
2017-01-01T00:12:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
70
Passenger Count
5
Trip Distance
3.45
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: 2017-01-01T00:01:40.000 • Lpep Dropoff Datetime: 2017-01-01T00:14:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:40.000
Lpep Dropoff Datetime
2017-01-01T00:14:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
232
Passenger Count
1
Trip Distance
2.11
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-01T00:00:51.000 • Lpep Dropoff Datetime: 2017-01-01T00:18:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:51.000
Lpep Dropoff Datetime
2017-01-01T00:18:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
239
Passenger Count
1
Trip Distance
2.76
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-01T00:00:28.000 • Lpep Dropoff Datetime: 2017-01-01T00:13:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:28.000
Lpep Dropoff Datetime
2017-01-01T00:13:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
179
Dolocationid
226
Passenger Count
1
Trip Distance
4.14
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:02:39.000 • Lpep Dropoff Datetime: 2017-01-01T00:26:28.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:02:39.000
Lpep Dropoff Datetime
2017-01-01T00:26:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
167
Passenger Count
1
Trip Distance
4.22
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: 2017-01-01T00:15:21.000 • Lpep Dropoff Datetime: 2017-01-01T00:28:06.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:15:21.000
Lpep Dropoff Datetime
2017-01-01T00:28:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
37
Passenger Count
1
Trip Distance
2.83
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-01T00:06:49.000 • Lpep Dropoff Datetime: 2017-01-01T00:11:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:06:49.000
Lpep Dropoff Datetime
2017-01-01T00:11:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
36
Dolocationid
37
Passenger Count
1
Trip Distance
0.78
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: 2017-01-01T00:14:34.000 • Lpep Dropoff Datetime: 2017-01-01T00:28:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:14:34.000
Lpep Dropoff Datetime
2017-01-01T00:28:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
127
Dolocationid
174
Passenger Count
5
Trip Distance
3.49
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: 2017-01-01T00:01:17.000 • Lpep Dropoff Datetime: 2017-01-01T00:09:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:17.000
Lpep Dropoff Datetime
2017-01-01T00:09:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
238
Passenger Count
1
Trip Distance
1.61
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: 2017-01-01T00:31:46.000 • Lpep Dropoff Datetime: 2017-01-01T00:52:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:31:46.000
Lpep Dropoff Datetime
2017-01-01T00:52:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
228
Passenger Count
1
Trip Distance
5.63
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:01:03.000 • Lpep Dropoff Datetime: 2017-01-01T00:22:33.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:03.000
Lpep Dropoff Datetime
2017-01-01T00:22:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
26
Passenger Count
5
Trip Distance
10.24
Fare Amount
30
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:00:39.000 • Lpep Dropoff Datetime: 2017-01-01T00:09:08.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:39.000
Lpep Dropoff Datetime
2017-01-01T00:09:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
70
Dolocationid
173
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:03:20.000 • Lpep Dropoff Datetime: 2017-01-01T00:18:16.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:03:20.000
Lpep Dropoff Datetime
2017-01-01T00:18:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
40
Passenger Count
1
Trip Distance
5.56
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.94
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.74
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:03:28.000 • Lpep Dropoff Datetime: 2017-01-01T00:03:28.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:03:28.000
Lpep Dropoff Datetime
2017-01-01T00:03:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
260
Passenger Count
1
Trip Distance
1.75
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: 2017-01-01T00:00:01.000 • Lpep Dropoff Datetime: 2017-01-01T00:00:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:01.000
Lpep Dropoff Datetime
2017-01-01T00:00:05.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
36
Dolocationid
36
Passenger Count
1
Trip Distance
0.00
Fare Amount
3
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
3
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:01:51.000 • Lpep Dropoff Datetime: 2017-01-01T00:11:48.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:51.000
Lpep Dropoff Datetime
2017-01-01T00:11:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
223
Passenger Count
1
Trip Distance
2.00
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: 2017-01-01T00:26:09.000 • Lpep Dropoff Datetime: 2017-01-01T00:38:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:26:09.000
Lpep Dropoff Datetime
2017-01-01T00:38:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
106
Passenger Count
1
Trip Distance
5.48
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
3.29
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.59
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:49:08.000 • Lpep Dropoff Datetime: 2017-01-01T01:00:54.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:49:08.000
Lpep Dropoff Datetime
2017-01-01T01:00:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
228
Passenger Count
1
Trip Distance
2.00
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-01T00:10:57.000 • Lpep Dropoff Datetime: 2017-01-01T00:34:42.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:10:57.000
Lpep Dropoff Datetime
2017-01-01T00:34:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
107
Passenger Count
2
Trip Distance
6.03
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: 2017-01-01T00:02:56.000 • Lpep Dropoff Datetime: 2017-01-01T00:14:42.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:02:56.000
Lpep Dropoff Datetime
2017-01-01T00:14:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
56
Passenger Count
2
Trip Distance
2.41
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-01T00:01:40.000 • Lpep Dropoff Datetime: 2017-01-01T00:34:15.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:40.000
Lpep Dropoff Datetime
2017-01-01T00:34:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
152
Passenger Count
1
Trip Distance
9.49
Fare Amount
30
Extra
0.5
Mta Tax
0.5
Tip Amount
7.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
39.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:00:36.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:36.000
Lpep Dropoff Datetime
2017-01-01T00:12:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
91
Dolocationid
188
Passenger Count
1
Trip Distance
3.02
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-01T00:00:50.000 • Lpep Dropoff Datetime: 2017-01-01T00:30:28.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:50.000
Lpep Dropoff Datetime
2017-01-01T00:30:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
228
Dolocationid
140
Passenger Count
1
Trip Distance
11.91
Fare Amount
34
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:04:59.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:18.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:04:59.000
Lpep Dropoff Datetime
2017-01-01T00:12:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
126
Dolocationid
159
Passenger Count
1
Trip Distance
1.98
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: 2017-01-01T00:02:54.000 • Lpep Dropoff Datetime: 2017-01-01T00:16:53.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:02:54.000
Lpep Dropoff Datetime
2017-01-01T00:16:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
181
Passenger Count
1
Trip Distance
2.20
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:02:52.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:02:52.000
Lpep Dropoff Datetime
2017-01-01T00:12:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
173
Passenger Count
1
Trip Distance
1.45
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-01T00:01:22.000 • Lpep Dropoff Datetime: 2017-01-01T00:07:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:22.000
Lpep Dropoff Datetime
2017-01-01T00:07:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
43
Passenger Count
1
Trip Distance
1.18
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-01T00:02:17.000 • Lpep Dropoff Datetime: 2017-01-01T00:19:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:02:17.000
Lpep Dropoff Datetime
2017-01-01T00:19:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
63
Passenger Count
1
Trip Distance
4.47
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: 2017-01-01T00:26:50.000 • Lpep Dropoff Datetime: 2017-01-01T00:41:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:26:50.000
Lpep Dropoff Datetime
2017-01-01T00:41:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
145
Dolocationid
7
Passenger Count
2
Trip Distance
3.63
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: 2017-01-01T00:00:19.000 • Lpep Dropoff Datetime: 2017-01-01T00:07:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:19.000
Lpep Dropoff Datetime
2017-01-01T00:07:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
238
Passenger Count
1
Trip Distance
1.30
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
2.49
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.79
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:01:35.000 • Lpep Dropoff Datetime: 2017-01-01T00:06:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:35.000
Lpep Dropoff Datetime
2017-01-01T00:06:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
75
Passenger Count
1
Trip Distance
0.59
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:03:58.000 • Lpep Dropoff Datetime: 2017-01-01T00:08:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:03:58.000
Lpep Dropoff Datetime
2017-01-01T00:08:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
25
Passenger Count
1
Trip Distance
0.80
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:43:45.000 • Lpep Dropoff Datetime: 2017-01-01T00:55:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:43:45.000
Lpep Dropoff Datetime
2017-01-01T00:55:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
130
Dolocationid
205
Passenger Count
3
Trip Distance
3.80
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-01T00:02:31.000 • Lpep Dropoff Datetime: 2017-01-01T00:22:33.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:02:31.000
Lpep Dropoff Datetime
2017-01-01T00:22:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
129
Passenger Count
1
Trip Distance
6.27
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-01T00:01:28.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:37.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:28.000
Lpep Dropoff Datetime
2017-01-01T00:12:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
215
Dolocationid
10
Passenger Count
1
Trip Distance
2.79
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:01:35.000 • Lpep Dropoff Datetime: 2017-01-01T00:16:09.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:35.000
Lpep Dropoff Datetime
2017-01-01T00:16:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
189
Dolocationid
106
Passenger Count
1
Trip Distance
2.46
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: 2017-01-01T00:01:57.000 • Lpep Dropoff Datetime: 2017-01-01T00:02:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:57.000
Lpep Dropoff Datetime
2017-01-01T00:02:01.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
75
Dolocationid
75
Passenger Count
1
Trip Distance
0.00
Fare Amount
5
Extra
0
Mta Tax
0
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0
Total Amount
7
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:00:16.000 • Lpep Dropoff Datetime: 2017-01-01T00:06:17.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:16.000
Lpep Dropoff Datetime
2017-01-01T00:06:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
117
Dolocationid
117
Passenger Count
1
Trip Distance
1.82
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:05:27.000 • Lpep Dropoff Datetime: 2017-01-01T00:13:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:05:27.000
Lpep Dropoff Datetime
2017-01-01T00:13:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
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: 2017-01-01T00:00:22.000 • Lpep Dropoff Datetime: 2017-01-01T00:06:58.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:00:22.000
Lpep Dropoff Datetime
2017-01-01T00:06:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
225
Passenger Count
3
Trip Distance
1.84
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: 2017-01-01T00:02:14.000 • Lpep Dropoff Datetime: 2017-01-01T00:05:17.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:02:14.000
Lpep Dropoff Datetime
2017-01-01T00:05:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
181
Passenger Count
1
Trip Distance
0.73
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-01T00:28:15.000 • Lpep Dropoff Datetime: 2017-01-01T00:42:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:28:15.000
Lpep Dropoff Datetime
2017-01-01T00:42:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
97
Passenger Count
1
Trip Distance
2.65
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
3.99
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.29
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:44:31.000 • Lpep Dropoff Datetime: 2017-01-01T00:52:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:44:31.000
Lpep Dropoff Datetime
2017-01-01T00:52:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
17
Passenger Count
1
Trip Distance
1.65
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:59:37.000 • Lpep Dropoff Datetime: 2017-01-01T01:04:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:59:37.000
Lpep Dropoff Datetime
2017-01-01T01:04:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
225
Passenger Count
1
Trip Distance
1.07
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-01T00:01:19.000 • Lpep Dropoff Datetime: 2017-01-01T00:20:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:19.000
Lpep Dropoff Datetime
2017-01-01T00:20:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
181
Passenger Count
1
Trip Distance
8.27
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-01T00:01:18.000 • Lpep Dropoff Datetime: 2017-01-01T00:11:21.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:18.000
Lpep Dropoff Datetime
2017-01-01T00:11:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
74
Passenger Count
1
Trip Distance
1.55
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: 2017-01-01T00:01:57.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:01:57.000
Lpep Dropoff Datetime
2017-01-01T00:12:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
97
Passenger Count
1
Trip Distance
0.94
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-01T00:30:30.000 • Lpep Dropoff Datetime: 2017-01-01T00:40:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:30:30.000
Lpep Dropoff Datetime
2017-01-01T00:40:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
121
Passenger Count
1
Trip Distance
2.96
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
1
Trip Type
1
NYC Data AI • Public-data exploration interface