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:33:44.000 • Lpep Dropoff Datetime: 2017-01-01T00:37:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:33:44.000
Lpep Dropoff Datetime
2017-01-01T00:37:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
75
Passenger Count
1
Trip Distance
1.54
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:42:29.000 • Lpep Dropoff Datetime: 2017-01-01T00:54:58.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:42:29.000
Lpep Dropoff Datetime
2017-01-01T00:54:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
75
Dolocationid
42
Passenger Count
1
Trip Distance
2.69
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:59:05.000 • Lpep Dropoff Datetime: 2017-01-01T01:16:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:59:05.000
Lpep Dropoff Datetime
2017-01-01T01:16:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
75
Passenger Count
1
Trip Distance
3.19
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:27:46.000 • Lpep Dropoff Datetime: 2017-01-01T00:46:35.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:27:46.000
Lpep Dropoff Datetime
2017-01-01T00:46:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
145
Dolocationid
82
Passenger Count
1
Trip Distance
6.06
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:50:44.000 • Lpep Dropoff Datetime: 2017-01-01T01:20:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:50:44.000
Lpep Dropoff Datetime
2017-01-01T01:20:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
81
Passenger Count
1
Trip Distance
16.71
Fare Amount
46.5
Extra
0.5
Mta Tax
0.5
Tip Amount
10.67
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
64.01
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:41:25.000 • Lpep Dropoff Datetime: 2017-01-01T00:46:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:41:25.000
Lpep Dropoff Datetime
2017-01-01T00:46:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
179
Passenger Count
1
Trip Distance
1.17
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:32:00.000 • Lpep Dropoff Datetime: 2017-01-01T00:48:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:32:00.000
Lpep Dropoff Datetime
2017-01-01T00:48:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
145
Dolocationid
179
Passenger Count
1
Trip Distance
4.11
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
3.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:56:14.000 • Lpep Dropoff Datetime: 2017-01-01T01:23:52.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:56:14.000
Lpep Dropoff Datetime
2017-01-01T01:23:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
216
Passenger Count
1
Trip Distance
13.72
Fare Amount
38.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
40.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:21:19.000 • Lpep Dropoff Datetime: 2017-01-02T00:08:52.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:21:19.000
Lpep Dropoff Datetime
2017-01-02T00:08:52.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
37
Dolocationid
37
Passenger Count
2
Trip Distance
0.82
Fare Amount
20
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
20
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:28:17.000 • Lpep Dropoff Datetime: 2017-01-01T00:28:27.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:28:17.000
Lpep Dropoff Datetime
2017-01-01T00:28:27.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
37
Dolocationid
37
Passenger Count
2
Trip Distance
0.00
Fare Amount
35
Extra
0
Mta Tax
0
Tip Amount
8.75
Tolls Amount
0
Improvement Surcharge
0
Total Amount
43.75
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:32:25.000 • Lpep Dropoff Datetime: 2017-01-01T01:01:09.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:32:25.000
Lpep Dropoff Datetime
2017-01-01T01:01:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
145
Passenger Count
1
Trip Distance
5.78
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:27:58.000 • Lpep Dropoff Datetime: 2017-01-01T00:44:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:27:58.000
Lpep Dropoff Datetime
2017-01-01T00:44:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
4
Passenger Count
1
Trip Distance
5.51
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:39:52.000 • Lpep Dropoff Datetime: 2017-01-01T00:44:36.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:39:52.000
Lpep Dropoff Datetime
2017-01-01T00:44:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
25
Passenger Count
2
Trip Distance
0.62
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:56:56.000 • Lpep Dropoff Datetime: 2017-01-01T01:34:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:56:56.000
Lpep Dropoff Datetime
2017-01-01T01:34:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
179
Passenger Count
1
Trip Distance
10.36
Fare Amount
36
Extra
0.5
Mta Tax
0.5
Tip Amount
11.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
48.49
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:06:10.000 • Lpep Dropoff Datetime: 2017-01-01T00:07:41.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:06:10.000
Lpep Dropoff Datetime
2017-01-01T00:07:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
41
Passenger Count
1
Trip Distance
0.08
Fare Amount
3
Extra
0.5
Mta Tax
0.5
Tip Amount
6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:10:36.000 • Lpep Dropoff Datetime: 2017-01-01T00:25:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:10:36.000
Lpep Dropoff Datetime
2017-01-01T00:25:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
238
Passenger Count
1
Trip Distance
2.41
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:34:47.000 • Lpep Dropoff Datetime: 2017-01-01T00:43:27.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:34:47.000
Lpep Dropoff Datetime
2017-01-01T00:43:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
142
Passenger Count
1
Trip Distance
2.41
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:07:09.000 • Lpep Dropoff Datetime: 2017-01-01T00:18:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:07:09.000
Lpep Dropoff Datetime
2017-01-01T00:18:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
49
Passenger Count
1
Trip Distance
2.54
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:27:05.000 • Lpep Dropoff Datetime: 2017-01-01T00:44:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:27:05.000
Lpep Dropoff Datetime
2017-01-01T00:44:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
34
Dolocationid
26
Passenger Count
1
Trip Distance
8.43
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:33:58.000 • Lpep Dropoff Datetime: 2017-01-01T00:44:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:33:58.000
Lpep Dropoff Datetime
2017-01-01T00:44:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
70
Passenger Count
1
Trip Distance
3.73
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:47:22.000 • Lpep Dropoff Datetime: 2017-01-01T00:54:35.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:47:22.000
Lpep Dropoff Datetime
2017-01-01T00:54:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
260
Passenger Count
1
Trip Distance
1.53
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:29.000 • Lpep Dropoff Datetime: 2017-01-01T00:59:03.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:47:29.000
Lpep Dropoff Datetime
2017-01-01T00:59:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
197
Dolocationid
130
Passenger Count
1
Trip Distance
3.62
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:19:04.000 • Lpep Dropoff Datetime: 2017-01-01T00:24:22.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:19:04.000
Lpep Dropoff Datetime
2017-01-01T00:24:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
179
Passenger Count
1
Trip Distance
1.01
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:31:22.000 • Lpep Dropoff Datetime: 2017-01-01T00:37:49.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:31:22.000
Lpep Dropoff Datetime
2017-01-01T00:37:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
Passenger Count
1
Trip Distance
1.08
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
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:54:46.000 • Lpep Dropoff Datetime: 2017-01-01T01:07:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:54:46.000
Lpep Dropoff Datetime
2017-01-01T01:07:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
226
Passenger Count
1
Trip Distance
2.18
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:05:22.000 • Lpep Dropoff Datetime: 2017-01-01T00:11:17.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:05:22.000
Lpep Dropoff Datetime
2017-01-01T00:11:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
7
Passenger Count
5
Trip Distance
1.50
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:45:34.000 • Lpep Dropoff Datetime: 2017-01-01T00:58:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:45:34.000
Lpep Dropoff Datetime
2017-01-01T00:58:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
162
Passenger Count
5
Trip Distance
3.96
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-01T00:21:29.000 • Lpep Dropoff Datetime: 2017-01-01T00:31:37.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:21:29.000
Lpep Dropoff Datetime
2017-01-01T00:31:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
181
Passenger Count
5
Trip Distance
2.42
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:38:46.000 • Lpep Dropoff Datetime: 2017-01-01T00:50:30.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:38:46.000
Lpep Dropoff Datetime
2017-01-01T00:50:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
33
Passenger Count
5
Trip Distance
2.40
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:54:03.000 • Lpep Dropoff Datetime: 2017-01-01T01:08:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:54:03.000
Lpep Dropoff Datetime
2017-01-01T01:08:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
255
Passenger Count
5
Trip Distance
4.05
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:26:42.000 • Lpep Dropoff Datetime: 2017-01-01T00:43:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:26:42.000
Lpep Dropoff Datetime
2017-01-01T00:43:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
163
Passenger Count
1
Trip Distance
3.69
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:56:14.000 • Lpep Dropoff Datetime: 2017-01-01T01:02:21.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:56:14.000
Lpep Dropoff Datetime
2017-01-01T01:02:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
74
Passenger Count
1
Trip Distance
0.77
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:56:11.000 • Lpep Dropoff Datetime: 2017-01-01T01:54:29.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:56:11.000
Lpep Dropoff Datetime
2017-01-01T01:54:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
228
Dolocationid
166
Passenger Count
1
Trip Distance
14.08
Fare Amount
51.5
Extra
0.5
Mta Tax
0.5
Tip Amount
10
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
68.34
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:34:33.000 • Lpep Dropoff Datetime: 2017-01-01T00:41:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:34:33.000
Lpep Dropoff Datetime
2017-01-01T00:41:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
97
Passenger Count
1
Trip Distance
1.45
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-01T00:42:14.000 • Lpep Dropoff Datetime: 2017-01-01T00:52:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:42:14.000
Lpep Dropoff Datetime
2017-01-01T00:52:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
225
Passenger Count
1
Trip Distance
2.35
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:51:04.000 • Lpep Dropoff Datetime: 2017-01-01T01:04:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:51:04.000
Lpep Dropoff Datetime
2017-01-01T01:04:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
130
Dolocationid
180
Passenger Count
1
Trip Distance
5.40
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:29:30.000 • Lpep Dropoff Datetime: 2017-01-01T00:44:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:29:30.000
Lpep Dropoff Datetime
2017-01-01T00:44:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
130
Dolocationid
191
Passenger Count
1
Trip Distance
4.04
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:36:16.000 • Lpep Dropoff Datetime: 2017-01-01T00:45:07.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:36:16.000
Lpep Dropoff Datetime
2017-01-01T00:45:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
210
Dolocationid
123
Passenger Count
5
Trip Distance
2.02
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:15:32.000 • Lpep Dropoff Datetime: 2017-01-01T01:07:02.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:15:32.000
Lpep Dropoff Datetime
2017-01-01T01:07:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
190
Dolocationid
7
Passenger Count
1
Trip Distance
16.16
Fare Amount
53
Extra
0.5
Mta Tax
0.5
Tip Amount
13.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
67.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:54:15.000 • Lpep Dropoff Datetime: 2017-01-01T01:10:41.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:54:15.000
Lpep Dropoff Datetime
2017-01-01T01:10:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
168
Dolocationid
74
Passenger Count
4
Trip Distance
5.23
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:44:05.000 • Lpep Dropoff Datetime: 2017-01-01T01:05:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:44:05.000
Lpep Dropoff Datetime
2017-01-01T01:05:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
231
Passenger Count
1
Trip Distance
6.25
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:39:47.000 • Lpep Dropoff Datetime: 2017-01-01T00:45:09.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:39:47.000
Lpep Dropoff Datetime
2017-01-01T00:45:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
223
Passenger Count
1
Trip Distance
0.98
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:52:40.000 • Lpep Dropoff Datetime: 2017-01-01T01:01:07.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:52:40.000
Lpep Dropoff Datetime
2017-01-01T01:01:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
70
Passenger Count
1
Trip Distance
2.27
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:54:10.000 • Lpep Dropoff Datetime: 2017-01-01T01:01:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:54:10.000
Lpep Dropoff Datetime
2017-01-01T01:01:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
188
Dolocationid
49
Passenger Count
1
Trip Distance
1.69
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:34:15.000 • Lpep Dropoff Datetime: 2017-01-01T00:44:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:34:15.000
Lpep Dropoff Datetime
2017-01-01T00:44:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
80
Passenger Count
1
Trip Distance
1.92
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:52:47.000 • Lpep Dropoff Datetime: 2017-01-01T01:02:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:52:47.000
Lpep Dropoff Datetime
2017-01-01T01:02:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
112
Passenger Count
1
Trip Distance
1.86
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:17:41.000 • Lpep Dropoff Datetime: 2017-01-01T00:43:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:17:41.000
Lpep Dropoff Datetime
2017-01-01T00:43:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
89
Passenger Count
2
Trip Distance
4.01
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
3.04
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.29
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T00:54:32.000 • Lpep Dropoff Datetime: 2017-01-01T01:04:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:54:32.000
Lpep Dropoff Datetime
2017-01-01T01:04:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
42
Passenger Count
1
Trip Distance
1.54
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:31:12.000 • Lpep Dropoff Datetime: 2017-01-01T00:38:47.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:31:12.000
Lpep Dropoff Datetime
2017-01-01T00:38:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
80
Passenger Count
1
Trip Distance
1.06
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-01T00:42:01.000 • Lpep Dropoff Datetime: 2017-01-01T00:48:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T00:42:01.000
Lpep Dropoff Datetime
2017-01-01T00:48:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
112
Passenger Count
1
Trip Distance
1.41
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
NYC Data AI • Public-data exploration interface