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-01T02:14:10.000 • Lpep Dropoff Datetime: 2017-01-01T02:32:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:14:10.000
Lpep Dropoff Datetime
2017-01-01T02:32:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
112
Passenger Count
1
Trip Distance
3.32
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-01T02:34:46.000 • Lpep Dropoff Datetime: 2017-01-01T02:52:50.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:34:46.000
Lpep Dropoff Datetime
2017-01-01T02:52:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
17
Passenger Count
1
Trip Distance
2.97
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-01T02:57:24.000 • Lpep Dropoff Datetime: 2017-01-01T03:00:25.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:57:24.000
Lpep Dropoff Datetime
2017-01-01T03:00:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
17
Passenger Count
1
Trip Distance
0.62
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:48:32.000 • Lpep Dropoff Datetime: 2017-01-01T02:57:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:48:32.000
Lpep Dropoff Datetime
2017-01-01T02:57:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
116
Passenger Count
1
Trip Distance
1.64
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:21:02.000 • Lpep Dropoff Datetime: 2017-01-01T02:26:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:21:02.000
Lpep Dropoff Datetime
2017-01-01T02:26:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
129
Passenger Count
1
Trip Distance
0.78
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-01T02:35:17.000 • Lpep Dropoff Datetime: 2017-01-01T02:49:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:35:17.000
Lpep Dropoff Datetime
2017-01-01T02:49:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
129
Passenger Count
1
Trip Distance
2.15
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-01T02:06:50.000 • Lpep Dropoff Datetime: 2017-01-01T02:15:37.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:06:50.000
Lpep Dropoff Datetime
2017-01-01T02:15:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
226
Dolocationid
129
Passenger Count
1
Trip Distance
1.74
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-01T02:20:51.000 • Lpep Dropoff Datetime: 2017-01-01T02:38:47.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:20:51.000
Lpep Dropoff Datetime
2017-01-01T02:38:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
56
Passenger Count
1
Trip Distance
2.48
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: 2017-01-01T02:55:33.000 • Lpep Dropoff Datetime: 2017-01-01T02:58:51.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:55:33.000
Lpep Dropoff Datetime
2017-01-01T02:58:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
83
Passenger Count
1
Trip Distance
0.32
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: 2017-01-01T02:27:34.000 • Lpep Dropoff Datetime: 2017-01-01T02:34:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:27:34.000
Lpep Dropoff Datetime
2017-01-01T02:34:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
225
Passenger Count
1
Trip Distance
1.17
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-01T02:36:55.000 • Lpep Dropoff Datetime: 2017-01-01T02:44:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:36:55.000
Lpep Dropoff Datetime
2017-01-01T02:44:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
49
Passenger Count
1
Trip Distance
1.39
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-01T02:46:34.000 • Lpep Dropoff Datetime: 2017-01-01T02:51:11.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:46:34.000
Lpep Dropoff Datetime
2017-01-01T02:51:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
49
Dolocationid
49
Passenger Count
1
Trip Distance
0.61
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-01T02:57:26.000 • Lpep Dropoff Datetime: 2017-01-01T03:00:53.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:57:26.000
Lpep Dropoff Datetime
2017-01-01T03:00:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
97
Passenger Count
1
Trip Distance
1.03
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-01T02:01:30.000 • Lpep Dropoff Datetime: 2017-01-01T02:40:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:01:30.000
Lpep Dropoff Datetime
2017-01-01T02:40:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
49
Dolocationid
146
Passenger Count
1
Trip Distance
11.26
Fare Amount
33
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:44:09.000 • Lpep Dropoff Datetime: 2017-01-01T02:52:15.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:44:09.000
Lpep Dropoff Datetime
2017-01-01T02:52:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
146
Dolocationid
7
Passenger Count
1
Trip Distance
1.69
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-01T02:05:30.000 • Lpep Dropoff Datetime: 2017-01-01T02:10:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:05:30.000
Lpep Dropoff Datetime
2017-01-01T02:10:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
168
Dolocationid
168
Passenger Count
1
Trip Distance
0.95
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-01T02:10:15.000 • Lpep Dropoff Datetime: 2017-01-01T02:25:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:10:15.000
Lpep Dropoff Datetime
2017-01-01T02:25:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
75
Passenger Count
1
Trip Distance
2.07
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: 2017-01-01T02:34:28.000 • Lpep Dropoff Datetime: 2017-01-01T02:45:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:34:28.000
Lpep Dropoff Datetime
2017-01-01T02:45:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
42
Passenger Count
1
Trip Distance
2.17
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-01T02:48:34.000 • Lpep Dropoff Datetime: 2017-01-01T03:39:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:48:34.000
Lpep Dropoff Datetime
2017-01-01T03:39:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
4
Passenger Count
1
Trip Distance
8.42
Fare Amount
38
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
39.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:30:51.000 • Lpep Dropoff Datetime: 2017-01-01T02:34:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:30:51.000
Lpep Dropoff Datetime
2017-01-01T02:34:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
256
Passenger Count
1
Trip Distance
0.64
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-01T02:57:02.000 • Lpep Dropoff Datetime: 2017-01-01T02:57:35.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:57:02.000
Lpep Dropoff Datetime
2017-01-01T02:57:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
41
Passenger Count
1
Trip Distance
0.03
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
3.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:57:02.000 • Lpep Dropoff Datetime: 2017-01-01T02:57:35.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:57:02.000
Lpep Dropoff Datetime
2017-01-01T02:57:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
41
Passenger Count
1
Trip Distance
0.03
Fare Amount
-2.5
Extra
-0.5
Mta Tax
-0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
-0.3
Total Amount
-3.8
Payment Type
3
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:06:22.000 • Lpep Dropoff Datetime: 2017-01-02T01:20:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:06:22.000
Lpep Dropoff Datetime
2017-01-02T01:20:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
92
Dolocationid
9
Passenger Count
1
Trip Distance
2.76
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: 2017-01-01T02:00:01.000 • Lpep Dropoff Datetime: 2017-01-01T02:11:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:00:01.000
Lpep Dropoff Datetime
2017-01-01T02:11:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
181
Passenger Count
1
Trip Distance
2.54
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-01T02:13:45.000 • Lpep Dropoff Datetime: 2017-01-01T02:47:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:13:45.000
Lpep Dropoff Datetime
2017-01-01T02:47:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
7
Passenger Count
1
Trip Distance
13.40
Fare Amount
41.5
Extra
0.5
Mta Tax
0.5
Tip Amount
8.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
53.31
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:34:36.000 • Lpep Dropoff Datetime: 2017-01-01T02:53:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:34:36.000
Lpep Dropoff Datetime
2017-01-01T02:53:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
189
Dolocationid
144
Passenger Count
1
Trip Distance
4.21
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:50:28.000 • Lpep Dropoff Datetime: 2017-01-01T02:58:22.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:50:28.000
Lpep Dropoff Datetime
2017-01-01T02:58:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
106
Passenger Count
1
Trip Distance
1.33
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.34
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.14
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:02:29.000 • Lpep Dropoff Datetime: 2017-01-01T02:14:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:02:29.000
Lpep Dropoff Datetime
2017-01-01T02:14:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
225
Passenger Count
2
Trip Distance
1.97
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-01T02:15:00.000 • Lpep Dropoff Datetime: 2017-01-01T02:28:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:15:00.000
Lpep Dropoff Datetime
2017-01-01T02:28:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
61
Passenger Count
2
Trip Distance
2.68
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-01T02:30:43.000 • Lpep Dropoff Datetime: 2017-01-01T02:38:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:30:43.000
Lpep Dropoff Datetime
2017-01-01T02:38:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
61
Passenger Count
2
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:40:53.000 • Lpep Dropoff Datetime: 2017-01-01T03:05:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:40:53.000
Lpep Dropoff Datetime
2017-01-01T03:05:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
4
Passenger Count
2
Trip Distance
5.11
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:06:04.000 • Lpep Dropoff Datetime: 2017-01-01T02:23:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:06:04.000
Lpep Dropoff Datetime
2017-01-01T02:23:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
189
Passenger Count
1
Trip Distance
3.18
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:28:37.000 • Lpep Dropoff Datetime: 2017-01-01T02:43:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:28:37.000
Lpep Dropoff Datetime
2017-01-01T02:43:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
227
Passenger Count
1
Trip Distance
3.80
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:54:53.000 • Lpep Dropoff Datetime: 2017-01-01T03:33:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:54:53.000
Lpep Dropoff Datetime
2017-01-01T03:33:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
228
Dolocationid
198
Passenger Count
1
Trip Distance
7.36
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:11:11.000 • Lpep Dropoff Datetime: 2017-01-01T02:21:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:11:11.000
Lpep Dropoff Datetime
2017-01-01T02:21:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
135
Passenger Count
6
Trip Distance
2.85
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.54
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.34
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:35:09.000 • Lpep Dropoff Datetime: 2017-01-01T02:38:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:35:09.000
Lpep Dropoff Datetime
2017-01-01T02:38:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
95
Passenger Count
6
Trip Distance
0.46
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:14:56.000 • Lpep Dropoff Datetime: 2017-01-01T02:41:19.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:14:56.000
Lpep Dropoff Datetime
2017-01-01T02:41:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
80
Passenger Count
1
Trip Distance
4.07
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:44:35.000 • Lpep Dropoff Datetime: 2017-01-01T02:56:49.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:44:35.000
Lpep Dropoff Datetime
2017-01-01T02:56:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
260
Passenger Count
1
Trip Distance
3.95
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:05:54.000 • Lpep Dropoff Datetime: 2017-01-01T02:16:19.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:05:54.000
Lpep Dropoff Datetime
2017-01-01T02:16:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
145
Dolocationid
7
Passenger Count
1
Trip Distance
2.57
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: 2017-01-01T02:20:31.000 • Lpep Dropoff Datetime: 2017-01-01T02:25:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:20:31.000
Lpep Dropoff Datetime
2017-01-01T02:25:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
Passenger Count
1
Trip Distance
1.13
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-01T02:26:51.000 • Lpep Dropoff Datetime: 2017-01-01T02:53:19.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:26:51.000
Lpep Dropoff Datetime
2017-01-01T02:53:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
198
Passenger Count
1
Trip Distance
5.52
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-01T02:55:41.000 • Lpep Dropoff Datetime: 2017-01-01T02:58:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:55:41.000
Lpep Dropoff Datetime
2017-01-01T02:58:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
198
Dolocationid
198
Passenger Count
1
Trip Distance
0.49
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-01T02:08:07.000 • Lpep Dropoff Datetime: 2017-01-01T02:24:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:08:07.000
Lpep Dropoff Datetime
2017-01-01T02:24:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
244
Passenger Count
1
Trip Distance
2.82
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-01T02:42:00.000 • Lpep Dropoff Datetime: 2017-01-01T02:49:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:42:00.000
Lpep Dropoff Datetime
2017-01-01T02:49:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
152
Dolocationid
244
Passenger Count
1
Trip Distance
1.48
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-01T02:52:32.000 • Lpep Dropoff Datetime: 2017-01-01T02:55:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:52:32.000
Lpep Dropoff Datetime
2017-01-01T02:55:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
223
Passenger Count
1
Trip Distance
0.47
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: 2017-01-01T02:09:34.000 • Lpep Dropoff Datetime: 2017-01-01T02:09:41.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:09:34.000
Lpep Dropoff Datetime
2017-01-01T02:09:41.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
82
Dolocationid
82
Passenger Count
1
Trip Distance
0.00
Fare Amount
30
Extra
0
Mta Tax
0
Tip Amount
7.5
Tolls Amount
0
Improvement Surcharge
0
Total Amount
37.5
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:15:38.000 • Lpep Dropoff Datetime: 2017-01-01T02:22:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:15:38.000
Lpep Dropoff Datetime
2017-01-01T02:22:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
56
Passenger Count
1
Trip Distance
1.00
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-01T02:32:34.000 • Lpep Dropoff Datetime: 2017-01-01T03:15:07.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:32:34.000
Lpep Dropoff Datetime
2017-01-01T03:15:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
56
Dolocationid
156
Passenger Count
1
Trip Distance
25.22
Fare Amount
68
Extra
0.5
Mta Tax
0.5
Tip Amount
8.04
Tolls Amount
11.08
Improvement Surcharge
0.3
Total Amount
90.37
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T02:54:05.000 • Lpep Dropoff Datetime: 2017-01-01T02:58:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:54:05.000
Lpep Dropoff Datetime
2017-01-01T02:58:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
80
Passenger Count
1
Trip Distance
0.74
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-01T02:59:56.000 • Lpep Dropoff Datetime: 2017-01-01T03:07:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T02:59:56.000
Lpep Dropoff Datetime
2017-01-01T03:07:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
256
Passenger Count
1
Trip Distance
1.07
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
NYC Data AI • Public-data exploration interface