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:46:57.000 • Lpep Dropoff Datetime: 2017-01-01T01:01:40.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:46:57.000
Lpep Dropoff Datetime
2017-01-01T01:01:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
82
Passenger Count
1
Trip Distance
4.98
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:54:37.000 • Lpep Dropoff Datetime: 2017-01-01T01:12:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:54:37.000
Lpep Dropoff Datetime
2017-01-01T01:12:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
193
Passenger Count
1
Trip Distance
4.81
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.51
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:11:13.000 • Lpep Dropoff Datetime: 2017-01-01T00:31:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:11:13.000
Lpep Dropoff Datetime
2017-01-01T00:31:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
216
Dolocationid
63
Passenger Count
1
Trip Distance
4.58
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:22:59.000 • Lpep Dropoff Datetime: 2017-01-01T00:32:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:22:59.000
Lpep Dropoff Datetime
2017-01-01T00:32:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
75
Passenger Count
1
Trip Distance
1.20
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:45:35.000 • Lpep Dropoff Datetime: 2017-01-01T00:59:08.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:45:35.000
Lpep Dropoff Datetime
2017-01-01T00:59:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
62
Dolocationid
91
Passenger Count
1
Trip Distance
3.13
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.51
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:04:03.000 • Lpep Dropoff Datetime: 2017-01-01T00:17:28.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:04:03.000
Lpep Dropoff Datetime
2017-01-01T00:17:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
66
Dolocationid
233
Passenger Count
1
Trip Distance
6.18
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:31:48.000 • Lpep Dropoff Datetime: 2017-01-01T00:50:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:31:48.000
Lpep Dropoff Datetime
2017-01-01T00:50:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
66
Dolocationid
79
Passenger Count
1
Trip Distance
5.17
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:38:38.000 • Lpep Dropoff Datetime: 2017-01-01T00:55:58.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:38:38.000
Lpep Dropoff Datetime
2017-01-01T00:55:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
228
Passenger Count
1
Trip Distance
7.96
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:56:56.000 • Lpep Dropoff Datetime: 2017-01-01T01:14:46.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:56:56.000
Lpep Dropoff Datetime
2017-01-01T01:14:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
228
Dolocationid
26
Passenger Count
1
Trip Distance
3.25
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:15:27.000 • Lpep Dropoff Datetime: 2017-01-01T00:35:50.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:15:27.000
Lpep Dropoff Datetime
2017-01-01T00:35:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
66
Dolocationid
17
Passenger Count
1
Trip Distance
3.21
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:43:28.000 • Lpep Dropoff Datetime: 2017-01-01T00:58:49.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:43:28.000
Lpep Dropoff Datetime
2017-01-01T00:58:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
37
Passenger Count
1
Trip Distance
2.33
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:08:27.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:08:27.000
Lpep Dropoff Datetime
2017-01-01T00:12:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
41
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:17:33.000 • Lpep Dropoff Datetime: 2017-01-01T00:29:07.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:17:33.000
Lpep Dropoff Datetime
2017-01-01T00:29:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
238
Passenger Count
1
Trip Distance
2.03
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:35:19.000 • Lpep Dropoff Datetime: 2017-01-01T00:47:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:35:19.000
Lpep Dropoff Datetime
2017-01-01T00:47:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
244
Passenger Count
1
Trip Distance
2.33
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-01T00:51:52.000 • Lpep Dropoff Datetime: 2017-01-01T01:07:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:51:52.000
Lpep Dropoff Datetime
2017-01-01T01:07:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
167
Passenger Count
1
Trip Distance
1.80
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:57:59.000 • Lpep Dropoff Datetime: 2017-01-01T01:07:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:57:59.000
Lpep Dropoff Datetime
2017-01-01T01:07:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
226
Dolocationid
226
Passenger Count
1
Trip Distance
0.95
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.64
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.44
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:31:34.000 • Lpep Dropoff Datetime: 2017-01-01T00:36:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:31:34.000
Lpep Dropoff Datetime
2017-01-01T00:36:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
168
Passenger Count
1
Trip Distance
1.09
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:20:46.000 • Lpep Dropoff Datetime: 2017-01-01T00:29:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:20:46.000
Lpep Dropoff Datetime
2017-01-01T00:29:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
247
Passenger Count
1
Trip Distance
2.15
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-01T00:39:37.000 • Lpep Dropoff Datetime: 2017-01-01T00:46:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:39:37.000
Lpep Dropoff Datetime
2017-01-01T00:46:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
41
Passenger Count
1
Trip Distance
1.62
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:47:15.000 • Lpep Dropoff Datetime: 2017-01-01T00:57:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:47:15.000
Lpep Dropoff Datetime
2017-01-01T00:57:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
116
Passenger Count
1
Trip Distance
2.30
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-01T00:57:26.000 • Lpep Dropoff Datetime: 2017-01-01T01:05:42.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:57:26.000
Lpep Dropoff Datetime
2017-01-01T01:05:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
80
Passenger Count
1
Trip Distance
1.29
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:20:43.000 • Lpep Dropoff Datetime: 2017-01-01T00:20:53.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:20:43.000
Lpep Dropoff Datetime
2017-01-01T00:20:53.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
129
Dolocationid
129
Passenger Count
1
Trip Distance
0.00
Fare Amount
10
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
10
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:44:40.000 • Lpep Dropoff Datetime: 2017-01-01T00:46:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:44:40.000
Lpep Dropoff Datetime
2017-01-01T00:46:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
Passenger Count
1
Trip Distance
0.25
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-01T00:51:47.000 • Lpep Dropoff Datetime: 2017-01-01T00:58:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:51:47.000
Lpep Dropoff Datetime
2017-01-01T00:58:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
223
Passenger Count
1
Trip Distance
1.75
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:28:07.000 • Lpep Dropoff Datetime: 2017-01-01T00:34:09.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:28:07.000
Lpep Dropoff Datetime
2017-01-01T00:34:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
112
Passenger Count
2
Trip Distance
1.14
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.31
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:37:50.000 • Lpep Dropoff Datetime: 2017-01-01T00:55:24.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:37:50.000
Lpep Dropoff Datetime
2017-01-01T00:55:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
97
Passenger Count
2
Trip Distance
4.33
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:08:48.000 • Lpep Dropoff Datetime: 2017-01-01T00:12:53.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:08:48.000
Lpep Dropoff Datetime
2017-01-01T00:12:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
52
Passenger Count
2
Trip Distance
0.79
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:22:19.000 • Lpep Dropoff Datetime: 2017-01-01T00:37:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:22:19.000
Lpep Dropoff Datetime
2017-01-01T00:37:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
52
Dolocationid
257
Passenger Count
2
Trip Distance
2.92
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:47:25.000 • Lpep Dropoff Datetime: 2017-01-01T00:55:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:47:25.000
Lpep Dropoff Datetime
2017-01-01T00:55:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
189
Passenger Count
2
Trip Distance
1.39
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:59:28.000 • Lpep Dropoff Datetime: 2017-01-01T01:12:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:59:28.000
Lpep Dropoff Datetime
2017-01-01T01:12:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
112
Passenger Count
2
Trip Distance
3.88
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-01T00:21:52.000 • Lpep Dropoff Datetime: 2017-01-01T00:35:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:21:52.000
Lpep Dropoff Datetime
2017-01-01T00:35:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
49
Dolocationid
97
Passenger Count
2
Trip Distance
2.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-01T00:10:18.000 • Lpep Dropoff Datetime: 2017-01-01T00:20:15.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:10:18.000
Lpep Dropoff Datetime
2017-01-01T00:20:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
82
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-01T00:22:27.000 • Lpep Dropoff Datetime: 2017-01-01T00:25:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:22:27.000
Lpep Dropoff Datetime
2017-01-01T00:25:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
160
Passenger Count
1
Trip Distance
1.23
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:58:47.000 • Lpep Dropoff Datetime: 2017-01-01T01:03:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:58:47.000
Lpep Dropoff Datetime
2017-01-01T01:03:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
95
Passenger Count
1
Trip Distance
1.05
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-01T00:30:40.000 • Lpep Dropoff Datetime: 2017-01-01T00:48:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:30:40.000
Lpep Dropoff Datetime
2017-01-01T00:48:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
107
Passenger Count
1
Trip Distance
3.38
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:11:44.000 • Lpep Dropoff Datetime: 2017-01-01T00:24:21.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:11:44.000
Lpep Dropoff Datetime
2017-01-01T00:24:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
225
Passenger Count
1
Trip Distance
2.63
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2
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-01T00:37:51.000 • Lpep Dropoff Datetime: 2017-01-01T00:48:21.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:37:51.000
Lpep Dropoff Datetime
2017-01-01T00:48:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
49
Dolocationid
61
Passenger Count
1
Trip Distance
1.48
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:50:04.000 • Lpep Dropoff Datetime: 2017-01-01T01:25:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:50:04.000
Lpep Dropoff Datetime
2017-01-01T01:25:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
61
Dolocationid
223
Passenger Count
1
Trip Distance
12.40
Fare Amount
38.5
Extra
0.5
Mta Tax
0.5
Tip Amount
7.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
47.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:14:09.000 • Lpep Dropoff Datetime: 2017-01-01T00:17:24.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:14:09.000
Lpep Dropoff Datetime
2017-01-01T00:17:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
146
Passenger Count
1
Trip Distance
0.72
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:50:51.000 • Lpep Dropoff Datetime: 2017-01-01T01:00:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:50:51.000
Lpep Dropoff Datetime
2017-01-01T01:00:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
82
Passenger Count
1
Trip Distance
1.33
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:46:40.000 • Lpep Dropoff Datetime: 2017-01-01T01:05:52.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:46:40.000
Lpep Dropoff Datetime
2017-01-01T01:05:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
141
Passenger Count
1
Trip Distance
7.61
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:57:24.000 • Lpep Dropoff Datetime: 2017-01-01T01:08:52.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:57:24.000
Lpep Dropoff Datetime
2017-01-01T01:08:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
260
Passenger Count
1
Trip Distance
1.82
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:08:53.000 • Lpep Dropoff Datetime: 2017-01-01T00:25:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:08:53.000
Lpep Dropoff Datetime
2017-01-01T00:25:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
173
Passenger Count
1
Trip Distance
2.47
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:21:51.000 • Lpep Dropoff Datetime: 2017-01-01T00:27:52.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:21:51.000
Lpep Dropoff Datetime
2017-01-01T00:27:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
129
Passenger Count
5
Trip Distance
0.71
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-01T00:37:14.000 • Lpep Dropoff Datetime: 2017-01-01T00:55:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:37:14.000
Lpep Dropoff Datetime
2017-01-01T00:55:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
129
Passenger Count
1
Trip Distance
4.68
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-01T00:05:40.000 • Lpep Dropoff Datetime: 2017-01-01T00:16:16.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:05:40.000
Lpep Dropoff Datetime
2017-01-01T00:16:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
35
Dolocationid
225
Passenger Count
1
Trip Distance
1.60
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:16:30.000 • Lpep Dropoff Datetime: 2017-01-01T00:31:57.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:16:30.000
Lpep Dropoff Datetime
2017-01-01T00:31:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
36
Dolocationid
17
Passenger Count
5
Trip Distance
3.12
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.11
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:49:19.000 • Lpep Dropoff Datetime: 2017-01-01T01:06:41.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:49:19.000
Lpep Dropoff Datetime
2017-01-01T01:06:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
37
Passenger Count
2
Trip Distance
3.78
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:24:04.000 • Lpep Dropoff Datetime: 2017-01-01T00:40:36.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:24:04.000
Lpep Dropoff Datetime
2017-01-01T00:40:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
226
Dolocationid
223
Passenger Count
1
Trip Distance
2.62
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:41:45.000 • Lpep Dropoff Datetime: 2017-01-01T00:46:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:41:45.000
Lpep Dropoff Datetime
2017-01-01T00:46:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
179
Passenger Count
1
Trip Distance
0.82
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
NYC Data AI • Public-data exploration interface