Ask NYC Browse All Data Public Safety Transportation Health Buildings

2018 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 w7fs-fd9i 19 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:33:18.000 • Lpep Dropoff Datetime: 2018-01-01T00:44:38.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:33:18.000
Lpep Dropoff Datetime
2018-01-01T00:44:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
61
Passenger Count
1
Trip Distance
1.65
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.91
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:55:46.000 • Lpep Dropoff Datetime: 2018-01-01T01:12:04.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:55:46.000
Lpep Dropoff Datetime
2018-01-01T01:12:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
17
Dolocationid
225
Passenger Count
1
Trip Distance
3.06
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
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:08:06.000 • Lpep Dropoff Datetime: 2018-01-01T00:14:27.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:08:06.000
Lpep Dropoff Datetime
2018-01-01T00:14:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
166
Passenger Count
1
Trip Distance
1.00
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:23:06.000 • Lpep Dropoff Datetime: 2018-01-01T00:50:29.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:23:06.000
Lpep Dropoff Datetime
2018-01-01T00:50:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
68
Passenger Count
1
Trip Distance
6.40
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:24:01.000 • Lpep Dropoff Datetime: 2018-01-01T00:37:25.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:24:01.000
Lpep Dropoff Datetime
2018-01-01T00:37:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
226
Dolocationid
129
Passenger Count
1
Trip Distance
2.80
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: 2018-01-01T00:06:26.000 • Lpep Dropoff Datetime: 2018-01-01T00:21:40.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:06:26.000
Lpep Dropoff Datetime
2018-01-01T00:21:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
71
Dolocationid
225
Passenger Count
1
Trip Distance
3.26
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:54:24.000 • Lpep Dropoff Datetime: 2018-01-01T00:59:45.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:54:24.000
Lpep Dropoff Datetime
2018-01-01T00:59:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
82
Passenger Count
6
Trip Distance
1.23
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: 2018-01-01T00:06:11.000 • Lpep Dropoff Datetime: 2018-01-01T00:10:06.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:06:11.000
Lpep Dropoff Datetime
2018-01-01T00:10:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
179
Passenger Count
1
Trip Distance
1.05
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: 2018-01-01T00:18:08.000 • Lpep Dropoff Datetime: 2018-01-01T00:22:49.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:18:08.000
Lpep Dropoff Datetime
2018-01-01T00:22:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
146
Dolocationid
193
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: 2018-01-01T00:14:20.000 • Lpep Dropoff Datetime: 2018-01-01T00:16:50.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:14:20.000
Lpep Dropoff Datetime
2018-01-01T00:16:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
226
Dolocationid
7
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: 2018-01-01T00:27:18.000 • Lpep Dropoff Datetime: 2018-01-01T00:35:28.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:27:18.000
Lpep Dropoff Datetime
2018-01-01T00:35:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
226
Passenger Count
1
Trip Distance
1.02
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
2.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:13:49.000 • Lpep Dropoff Datetime: 2018-01-01T00:19:04.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:13:49.000
Lpep Dropoff Datetime
2018-01-01T00:19:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
82
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: 2018-01-01T01:01:32.000 • Lpep Dropoff Datetime: 2018-01-01T01:04:02.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T01:01:32.000
Lpep Dropoff Datetime
2018-01-01T01:04:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
83
Dolocationid
83
Passenger Count
1
Trip Distance
0.56
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: 2018-01-01T00:56:34.000 • Lpep Dropoff Datetime: 2018-01-01T01:05:25.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:56:34.000
Lpep Dropoff Datetime
2018-01-01T01:05:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
117
Dolocationid
86
Passenger Count
1
Trip Distance
2.46
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: 2018-01-01T00:35:44.000 • Lpep Dropoff Datetime: 2018-01-01T00:41:27.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:35:44.000
Lpep Dropoff Datetime
2018-01-01T00:41:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
70
Dolocationid
56
Passenger Count
1
Trip Distance
1.10
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: 2018-01-01T01:01:30.000 • Lpep Dropoff Datetime: 2018-01-01T01:03:01.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T01:01:30.000
Lpep Dropoff Datetime
2018-01-01T01:03:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
129
Passenger Count
1
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-12-31T23:59:12.000 • Lpep Dropoff Datetime: 2018-01-01T00:05:23.000
Vendorid
2
Lpep Pickup Datetime
2017-12-31T23:59:12.000
Lpep Dropoff Datetime
2018-01-01T00:05:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
40
Passenger Count
1
Trip Distance
1.65
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: 2018-01-01T00:17:36.000 • Lpep Dropoff Datetime: 2018-01-01T00:23:55.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:17:36.000
Lpep Dropoff Datetime
2018-01-01T00:23:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
49
Passenger Count
1
Trip Distance
1.30
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: 2018-01-01T00:40:06.000 • Lpep Dropoff Datetime: 2018-01-01T00:55:09.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:40:06.000
Lpep Dropoff Datetime
2018-01-01T00:55:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
62
Passenger Count
1
Trip Distance
3.09
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: 2018-01-01T00:14:26.000 • Lpep Dropoff Datetime: 2018-01-01T00:24:46.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:14:26.000
Lpep Dropoff Datetime
2018-01-01T00:24:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
33
Passenger Count
1
Trip Distance
1.63
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:29:25.000 • Lpep Dropoff Datetime: 2018-01-01T00:43:47.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:29:25.000
Lpep Dropoff Datetime
2018-01-01T00:43:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
188
Passenger Count
1
Trip Distance
2.72
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: 2018-01-01T00:07:00.000 • Lpep Dropoff Datetime: 2018-01-01T00:13:00.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:07:00.000
Lpep Dropoff Datetime
2018-01-01T00:13:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
173
Dolocationid
56
Passenger Count
1
Trip Distance
1.12
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:08:48.000 • Lpep Dropoff Datetime: 2018-01-01T00:27:09.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:08:48.000
Lpep Dropoff Datetime
2018-01-01T00:27:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
188
Passenger Count
1
Trip Distance
9.10
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:10:48.000 • Lpep Dropoff Datetime: 2018-01-01T00:12:25.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:10:48.000
Lpep Dropoff Datetime
2018-01-01T00:12:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
42
Passenger Count
1
Trip Distance
0.46
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: 2018-01-01T00:51:36.000 • Lpep Dropoff Datetime: 2018-01-01T00:52:21.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:51:36.000
Lpep Dropoff Datetime
2018-01-01T00:52:21.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
42
Dolocationid
42
Passenger Count
1
Trip Distance
0.00
Fare Amount
8
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
8
Payment Type
1
Trip Type
2
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:13:50.000 • Lpep Dropoff Datetime: 2018-01-01T00:28:39.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:13:50.000
Lpep Dropoff Datetime
2018-01-01T00:28:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
95
Passenger Count
1
Trip Distance
6.40
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:31:23.000 • Lpep Dropoff Datetime: 2018-01-01T00:46:02.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:31:23.000
Lpep Dropoff Datetime
2018-01-01T00:46:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
196
Dolocationid
129
Passenger Count
1
Trip Distance
6.60
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:21:17.000 • Lpep Dropoff Datetime: 2018-01-01T00:34:25.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:21:17.000
Lpep Dropoff Datetime
2018-01-01T00:34:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
79
Passenger Count
1
Trip Distance
4.62
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
3.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:44:46.000 • Lpep Dropoff Datetime: 2018-01-01T01:07:26.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:44:46.000
Lpep Dropoff Datetime
2018-01-01T01:07:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
170
Passenger Count
1
Trip Distance
4.77
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:37:00.000 • Lpep Dropoff Datetime: 2018-01-01T00:41:05.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:37:00.000
Lpep Dropoff Datetime
2018-01-01T00:41:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
134
Passenger Count
1
Trip Distance
0.76
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: 2018-01-01T00:10:14.000 • Lpep Dropoff Datetime: 2018-01-01T00:27:57.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:10:14.000
Lpep Dropoff Datetime
2018-01-01T00:27:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
262
Passenger Count
1
Trip Distance
3.28
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
4.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:35:11.000 • Lpep Dropoff Datetime: 2018-01-01T00:45:24.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:35:11.000
Lpep Dropoff Datetime
2018-01-01T00:45:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
75
Dolocationid
42
Passenger Count
1
Trip Distance
2.77
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:09:39.000 • Lpep Dropoff Datetime: 2018-01-01T00:14:21.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:09:39.000
Lpep Dropoff Datetime
2018-01-01T00:14:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
116
Passenger Count
1
Trip Distance
1.80
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:25:12.000 • Lpep Dropoff Datetime: 2018-01-01T00:39:15.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:25:12.000
Lpep Dropoff Datetime
2018-01-01T00:39:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
48
Passenger Count
1
Trip Distance
5.00
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
3.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.15
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-12-31T23:16:05.000 • Lpep Dropoff Datetime: 2017-12-31T23:29:47.000
Vendorid
2
Lpep Pickup Datetime
2017-12-31T23:16:05.000
Lpep Dropoff Datetime
2017-12-31T23:29:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
14
Passenger Count
1
Trip Distance
5.87
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: 2018-01-01T00:04:05.000 • Lpep Dropoff Datetime: 2018-01-01T00:18:34.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:04:05.000
Lpep Dropoff Datetime
2018-01-01T00:18:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
225
Passenger Count
1
Trip Distance
2.78
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:08:31.000 • Lpep Dropoff Datetime: 2018-01-01T00:10:52.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:08:31.000
Lpep Dropoff Datetime
2018-01-01T00:10:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
Passenger Count
1
Trip Distance
0.41
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:14:04.000 • Lpep Dropoff Datetime: 2018-01-01T00:17:05.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:14:04.000
Lpep Dropoff Datetime
2018-01-01T00:17:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
223
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: 2018-01-01T00:19:55.000 • Lpep Dropoff Datetime: 2018-01-01T00:22:49.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:19:55.000
Lpep Dropoff Datetime
2018-01-01T00:22:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
7
Passenger Count
1
Trip Distance
0.49
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: 2018-01-01T00:38:19.000 • Lpep Dropoff Datetime: 2018-01-01T00:44:04.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:38:19.000
Lpep Dropoff Datetime
2018-01-01T00:44:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
223
Passenger Count
1
Trip Distance
1.20
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: 2018-01-01T00:47:57.000 • Lpep Dropoff Datetime: 2018-01-01T00:57:54.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:47:57.000
Lpep Dropoff Datetime
2018-01-01T00:57:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
7
Passenger Count
1
Trip Distance
1.83
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:12:25.000 • Lpep Dropoff Datetime: 2018-01-01T00:35:44.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:12:25.000
Lpep Dropoff Datetime
2018-01-01T00:35:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
226
Passenger Count
1
Trip Distance
10.68
Fare Amount
31.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:26:48.000 • Lpep Dropoff Datetime: 2018-01-01T00:52:56.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:26:48.000
Lpep Dropoff Datetime
2018-01-01T00:52:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
198
Passenger Count
1
Trip Distance
7.53
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:41:53.000 • Lpep Dropoff Datetime: 2018-01-01T00:47:54.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:41:53.000
Lpep Dropoff Datetime
2018-01-01T00:47:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
75
Dolocationid
74
Passenger Count
3
Trip Distance
1.29
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: 2018-01-01T00:41:53.000 • Lpep Dropoff Datetime: 2018-01-01T00:42:01.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:41:53.000
Lpep Dropoff Datetime
2018-01-01T00:42:01.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
47
Dolocationid
47
Passenger Count
1
Trip Distance
0.13
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: 2018-01-01T00:16:00.000 • Lpep Dropoff Datetime: 2018-01-01T00:42:06.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:16:00.000
Lpep Dropoff Datetime
2018-01-01T00:42:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
262
Passenger Count
1
Trip Distance
12.03
Fare Amount
35.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:38:57.000 • Lpep Dropoff Datetime: 2018-01-01T00:52:02.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:38:57.000
Lpep Dropoff Datetime
2018-01-01T00:52:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
79
Passenger Count
2
Trip Distance
4.60
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: 2018-01-01T00:12:27.000 • Lpep Dropoff Datetime: 2018-01-01T00:24:25.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:12:27.000
Lpep Dropoff Datetime
2018-01-01T00:24:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
55
Dolocationid
210
Passenger Count
3
Trip Distance
3.95
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: 2018-01-01T00:44:21.000 • Lpep Dropoff Datetime: 2018-01-01T00:44:58.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:44:21.000
Lpep Dropoff Datetime
2018-01-01T00:44:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
188
Dolocationid
188
Passenger Count
3
Trip Distance
0.00
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: 2018-01-01T00:12:46.000 • Lpep Dropoff Datetime: 2018-01-01T00:50:49.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:12:46.000
Lpep Dropoff Datetime
2018-01-01T00:50:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
69
Dolocationid
42
Passenger Count
1
Trip Distance
7.61
Fare Amount
30
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.3
Payment Type
1
Trip Type
1
NYC Data AI • Public-data exploration interface