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-01T01:09:20.000 • Lpep Dropoff Datetime: 2017-01-01T01:26:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:09:20.000
Lpep Dropoff Datetime
2017-01-01T01:26:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
158
Passenger Count
1
Trip Distance
3.63
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:21:04.000 • Lpep Dropoff Datetime: 2017-01-01T01:38:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:21:04.000
Lpep Dropoff Datetime
2017-01-01T01:38:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
116
Passenger Count
1
Trip Distance
2.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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:44:10.000 • Lpep Dropoff Datetime: 2017-01-01T02:23:11.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:44:10.000
Lpep Dropoff Datetime
2017-01-01T02:23:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
152
Dolocationid
94
Passenger Count
1
Trip Distance
6.01
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:07:57.000 • Lpep Dropoff Datetime: 2017-01-01T01:23:24.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:07:57.000
Lpep Dropoff Datetime
2017-01-01T01:23:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
145
Passenger Count
5
Trip Distance
3.51
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-01T01:48:17.000 • Lpep Dropoff Datetime: 2017-01-01T02:14:30.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:48:17.000
Lpep Dropoff Datetime
2017-01-01T02:14:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
79
Passenger Count
5
Trip Distance
6.09
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:07:11.000 • Lpep Dropoff Datetime: 2017-01-01T01:18:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:07:11.000
Lpep Dropoff Datetime
2017-01-01T01:18:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
95
Passenger Count
1
Trip Distance
2.08
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: 2017-01-01T01:02:45.000 • Lpep Dropoff Datetime: 2017-01-01T01:19:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:02:45.000
Lpep Dropoff Datetime
2017-01-01T01:19:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
247
Passenger Count
1
Trip Distance
3.25
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
20.84
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:49:24.000 • Lpep Dropoff Datetime: 2017-01-01T01:54:33.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:49:24.000
Lpep Dropoff Datetime
2017-01-01T01:54:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
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-01T01:58:52.000 • Lpep Dropoff Datetime: 2017-01-01T02:07:33.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:58:52.000
Lpep Dropoff Datetime
2017-01-01T02:07:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
260
Passenger Count
1
Trip Distance
3.08
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:31:32.000 • Lpep Dropoff Datetime: 2017-01-01T02:46:08.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:31:32.000
Lpep Dropoff Datetime
2017-01-01T02:46:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
152
Dolocationid
75
Passenger Count
1
Trip Distance
2.99
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:05:48.000 • Lpep Dropoff Datetime: 2017-01-01T01:31:07.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:05:48.000
Lpep Dropoff Datetime
2017-01-01T01:31:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
136
Dolocationid
4
Passenger Count
1
Trip Distance
12.07
Fare Amount
34
Extra
0.5
Mta Tax
0.5
Tip Amount
7.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
42.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:07:11.000 • Lpep Dropoff Datetime: 2017-01-01T01:36:46.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:07:11.000
Lpep Dropoff Datetime
2017-01-01T01:36:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
36
Passenger Count
2
Trip Distance
4.58
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
3
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:44:39.000 • Lpep Dropoff Datetime: 2017-01-01T01:59:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:44:39.000
Lpep Dropoff Datetime
2017-01-01T01:59:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
36
Dolocationid
255
Passenger Count
2
Trip Distance
2.66
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:05:39.000 • Lpep Dropoff Datetime: 2017-01-01T01:21:33.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:05:39.000
Lpep Dropoff Datetime
2017-01-01T01:21:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
127
Dolocationid
136
Passenger Count
1
Trip Distance
1.75
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:41:26.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:41:26.000
Lpep Dropoff Datetime
2017-01-01T01:52:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
244
Dolocationid
127
Passenger Count
1
Trip Distance
1.63
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: 2017-01-01T01:55:00.000 • Lpep Dropoff Datetime: 2017-01-01T02:03:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:55:00.000
Lpep Dropoff Datetime
2017-01-01T02:03:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
127
Dolocationid
240
Passenger Count
1
Trip Distance
2.05
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-01T01:25:58.000 • Lpep Dropoff Datetime: 2017-01-01T01:43:07.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:25:58.000
Lpep Dropoff Datetime
2017-01-01T01:43:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
56
Dolocationid
260
Passenger Count
1
Trip Distance
3.32
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-01T01:51:34.000 • Lpep Dropoff Datetime: 2017-01-01T01:57:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:51:34.000
Lpep Dropoff Datetime
2017-01-01T01:57:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
83
Dolocationid
82
Passenger Count
1
Trip Distance
0.94
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:17:57.000 • Lpep Dropoff Datetime: 2017-01-01T01:31:11.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:17:57.000
Lpep Dropoff Datetime
2017-01-01T01:31:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
25
Passenger Count
1
Trip Distance
3.83
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: 2017-01-01T01:34:41.000 • Lpep Dropoff Datetime: 2017-01-01T01:38:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:34:41.000
Lpep Dropoff Datetime
2017-01-01T01:38:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
65
Passenger Count
1
Trip Distance
0.69
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-01T01:39:09.000 • Lpep Dropoff Datetime: 2017-01-01T01:49:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:39:09.000
Lpep Dropoff Datetime
2017-01-01T01:49:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
144
Passenger Count
1
Trip Distance
2.41
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:56:19.000 • Lpep Dropoff Datetime: 2017-01-01T02:22:08.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:56:19.000
Lpep Dropoff Datetime
2017-01-01T02:22:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
193
Dolocationid
126
Passenger Count
1
Trip Distance
8.79
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:06:20.000 • Lpep Dropoff Datetime: 2017-01-01T01:11:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:06:20.000
Lpep Dropoff Datetime
2017-01-01T01:11:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
116
Passenger Count
1
Trip Distance
0.90
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-01T01:16:53.000 • Lpep Dropoff Datetime: 2017-01-01T01:30:22.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:16:53.000
Lpep Dropoff Datetime
2017-01-01T01:30:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
152
Dolocationid
168
Passenger Count
1
Trip Distance
2.34
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:15:49.000 • Lpep Dropoff Datetime: 2017-01-01T01:21:22.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:15:49.000
Lpep Dropoff Datetime
2017-01-01T01:21:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
82
Passenger Count
1
Trip Distance
1.08
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:38:58.000 • Lpep Dropoff Datetime: 2017-01-01T01:44:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:38:58.000
Lpep Dropoff Datetime
2017-01-01T01:44:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
83
Passenger Count
1
Trip Distance
1.19
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:54:19.000 • Lpep Dropoff Datetime: 2017-01-01T02:03:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:54:19.000
Lpep Dropoff Datetime
2017-01-01T02:03:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
7
Passenger Count
1
Trip Distance
1.50
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-01T01:18:09.000 • Lpep Dropoff Datetime: 2017-01-01T01:24:28.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:18:09.000
Lpep Dropoff Datetime
2017-01-01T01:24:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
198
Dolocationid
36
Passenger Count
1
Trip Distance
0.89
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.71
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:47:01.000 • Lpep Dropoff Datetime: 2017-01-01T02:02:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:47:01.000
Lpep Dropoff Datetime
2017-01-01T02:02:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
226
Passenger Count
1
Trip Distance
1.25
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:14:34.000 • Lpep Dropoff Datetime: 2017-01-01T01:43:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:14:34.000
Lpep Dropoff Datetime
2017-01-01T01:43:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
36
Dolocationid
61
Passenger Count
1
Trip Distance
4.48
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-01T01:52:17.000 • Lpep Dropoff Datetime: 2017-01-01T02:04:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:52:17.000
Lpep Dropoff Datetime
2017-01-01T02:04:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
168
Passenger Count
1
Trip Distance
2.29
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:14:42.000 • Lpep Dropoff Datetime: 2017-01-01T01:21:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:14:42.000
Lpep Dropoff Datetime
2017-01-01T01:21:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
42
Passenger Count
1
Trip Distance
0.84
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:25:25.000 • Lpep Dropoff Datetime: 2017-01-01T01:45:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:25:25.000
Lpep Dropoff Datetime
2017-01-01T01:45:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
136
Passenger Count
1
Trip Distance
4.72
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-01T01:58:43.000 • Lpep Dropoff Datetime: 2017-01-01T02:27:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:58:43.000
Lpep Dropoff Datetime
2017-01-01T02:27:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
256
Passenger Count
1
Trip Distance
7.39
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:49:59.000 • Lpep Dropoff Datetime: 2017-01-01T02:07:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:49:59.000
Lpep Dropoff Datetime
2017-01-01T02:07:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
75
Passenger Count
1
Trip Distance
3.23
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-01T01:14:37.000 • Lpep Dropoff Datetime: 2017-01-01T01:20:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:14:37.000
Lpep Dropoff Datetime
2017-01-01T01:20:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
92
Dolocationid
73
Passenger Count
1
Trip Distance
1.12
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:17:22.000 • Lpep Dropoff Datetime: 2017-01-01T01:29:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:17:22.000
Lpep Dropoff Datetime
2017-01-01T01:29:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
49
Passenger Count
1
Trip Distance
2.56
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:36:24.000 • Lpep Dropoff Datetime: 2017-01-01T01:40:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:36:24.000
Lpep Dropoff Datetime
2017-01-01T01:40:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
17
Passenger Count
1
Trip Distance
0.93
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.89
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.19
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:49:12.000 • Lpep Dropoff Datetime: 2017-01-01T01:54:47.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:49:12.000
Lpep Dropoff Datetime
2017-01-01T01:54:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
17
Passenger Count
1
Trip Distance
1.43
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:30:24.000 • Lpep Dropoff Datetime: 2017-01-01T02:31:36.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:30:24.000
Lpep Dropoff Datetime
2017-01-01T02:31:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
189
Passenger Count
1
Trip Distance
7.81
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-01T01:00:59.000 • Lpep Dropoff Datetime: 2017-01-01T01:18:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:00:59.000
Lpep Dropoff Datetime
2017-01-01T01:18:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
225
Passenger Count
1
Trip Distance
3.63
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:28:22.000 • Lpep Dropoff Datetime: 2017-01-01T02:15:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:28:22.000
Lpep Dropoff Datetime
2017-01-01T02:15:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
48
Passenger Count
1
Trip Distance
10.02
Fare Amount
37
Extra
0.5
Mta Tax
0.5
Tip Amount
4.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
42.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:07:15.000 • Lpep Dropoff Datetime: 2017-01-01T01:07:48.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:07:15.000
Lpep Dropoff Datetime
2017-01-01T01:07:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
61
Passenger Count
2
Trip Distance
0.04
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-01T01:07:15.000 • Lpep Dropoff Datetime: 2017-01-01T01:07:48.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:07:15.000
Lpep Dropoff Datetime
2017-01-01T01:07:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
61
Passenger Count
2
Trip Distance
0.04
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-01T01:26:05.000 • Lpep Dropoff Datetime: 2017-01-01T01:27:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:26:05.000
Lpep Dropoff Datetime
2017-01-01T01:27:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
49
Passenger Count
3
Trip Distance
0.28
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: 2017-01-01T01:32:23.000 • Lpep Dropoff Datetime: 2017-01-01T01:43:54.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:32:23.000
Lpep Dropoff Datetime
2017-01-01T01:43:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
49
Dolocationid
61
Passenger Count
3
Trip Distance
2.05
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
0.22
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.52
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:45:23.000 • Lpep Dropoff Datetime: 2017-01-01T01:47:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:45:23.000
Lpep Dropoff Datetime
2017-01-01T01:47:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
61
Passenger Count
2
Trip Distance
0.20
Fare Amount
3
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:31:38.000 • Lpep Dropoff Datetime: 2017-01-01T01:51:05.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:31:38.000
Lpep Dropoff Datetime
2017-01-01T01:51:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
148
Passenger Count
1
Trip Distance
3.53
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:06:01.000 • Lpep Dropoff Datetime: 2017-01-01T01:18:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:06:01.000
Lpep Dropoff Datetime
2017-01-01T01:18:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
197
Passenger Count
6
Trip Distance
3.28
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:42:43.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:42.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:42:43.000
Lpep Dropoff Datetime
2017-01-01T01:52:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
130
Passenger Count
6
Trip Distance
2.61
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
NYC Data AI • Public-data exploration interface