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:14:18.000 • Lpep Dropoff Datetime: 2017-01-01T01:28:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:14:18.000
Lpep Dropoff Datetime
2017-01-01T01:28:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
244
Dolocationid
75
Passenger Count
1
Trip Distance
4.42
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: 2017-01-01T01:32:32.000 • Lpep Dropoff Datetime: 2017-01-01T01:54:15.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:32:32.000
Lpep Dropoff Datetime
2017-01-01T01:54:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
48
Passenger Count
1
Trip Distance
6.32
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:05:45.000 • Lpep Dropoff Datetime: 2017-01-01T01:11:20.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:05:45.000
Lpep Dropoff Datetime
2017-01-01T01:11:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
Passenger Count
2
Trip Distance
0.79
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:15:26.000 • Lpep Dropoff Datetime: 2017-01-01T01:32:16.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:15:26.000
Lpep Dropoff Datetime
2017-01-01T01:32:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
134
Passenger Count
1
Trip Distance
8.82
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:16:08.000 • Lpep Dropoff Datetime: 2017-01-01T01:35:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:16:08.000
Lpep Dropoff Datetime
2017-01-01T01:35:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
226
Passenger Count
5
Trip Distance
2.21
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:43:01.000 • Lpep Dropoff Datetime: 2017-01-01T01:53:22.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:43:01.000
Lpep Dropoff Datetime
2017-01-01T01:53:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
129
Passenger Count
5
Trip Distance
1.80
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:58:15.000 • Lpep Dropoff Datetime: 2017-01-01T02:21:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:58:15.000
Lpep Dropoff Datetime
2017-01-01T02:21:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
252
Passenger Count
5
Trip Distance
4.55
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:03:29.000 • Lpep Dropoff Datetime: 2017-01-01T01:06:19.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:03:29.000
Lpep Dropoff Datetime
2017-01-01T01:06:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
129
Passenger Count
2
Trip Distance
0.66
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:56:47.000 • Lpep Dropoff Datetime: 2017-01-01T02:11:40.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:56:47.000
Lpep Dropoff Datetime
2017-01-01T02:11:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
7
Passenger Count
2
Trip Distance
2.57
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2
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-01T01:11:17.000 • Lpep Dropoff Datetime: 2017-01-01T01:35:35.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:11:17.000
Lpep Dropoff Datetime
2017-01-01T01:35:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
140
Passenger Count
1
Trip Distance
5.70
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:52:02.000 • Lpep Dropoff Datetime: 2017-01-01T02:01:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:52:02.000
Lpep Dropoff Datetime
2017-01-01T02:01:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
146
Dolocationid
260
Passenger Count
1
Trip Distance
1.99
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:38:55.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:54.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:38:55.000
Lpep Dropoff Datetime
2017-01-01T01:52:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
97
Passenger Count
1
Trip Distance
2.33
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:55:07.000 • Lpep Dropoff Datetime: 2017-01-01T02:08:36.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:55:07.000
Lpep Dropoff Datetime
2017-01-01T02:08:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
225
Passenger Count
1
Trip Distance
3.05
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-01T01:03:28.000 • Lpep Dropoff Datetime: 2017-01-01T01:23:52.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:03:28.000
Lpep Dropoff Datetime
2017-01-01T01:23:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
198
Passenger Count
1
Trip Distance
5.97
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-01T01:43:35.000 • Lpep Dropoff Datetime: 2017-01-01T01:48:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:43:35.000
Lpep Dropoff Datetime
2017-01-01T01:48:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
56
Passenger Count
1
Trip Distance
0.94
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:08:45.000 • Lpep Dropoff Datetime: 2017-01-01T01:18:42.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:08:45.000
Lpep Dropoff Datetime
2017-01-01T01:18:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
159
Dolocationid
159
Passenger Count
1
Trip Distance
1.39
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-01T01:20:30.000 • Lpep Dropoff Datetime: 2017-01-01T01:27:50.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:20:30.000
Lpep Dropoff Datetime
2017-01-01T01:27:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
159
Dolocationid
167
Passenger Count
1
Trip Distance
1.41
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-01T01:10:22.000 • Lpep Dropoff Datetime: 2017-01-01T01:28:29.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:10:22.000
Lpep Dropoff Datetime
2017-01-01T01:28:29.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
129
Dolocationid
135
Passenger Count
1
Trip Distance
8.98
Fare Amount
40
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
40
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:12:57.000 • Lpep Dropoff Datetime: 2017-01-01T01:29:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:12:57.000
Lpep Dropoff Datetime
2017-01-01T01:29:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
89
Dolocationid
14
Passenger Count
1
Trip Distance
6.86
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:29:45.000 • Lpep Dropoff Datetime: 2017-01-01T01:35:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:29:45.000
Lpep Dropoff Datetime
2017-01-01T01:35:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
42
Passenger Count
6
Trip Distance
0.83
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:37:48.000 • Lpep Dropoff Datetime: 2017-01-01T01:48:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:37:48.000
Lpep Dropoff Datetime
2017-01-01T01:48:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
244
Passenger Count
6
Trip Distance
1.73
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-01T01:55:07.000 • Lpep Dropoff Datetime: 2017-01-01T02:21:53.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:55:07.000
Lpep Dropoff Datetime
2017-01-01T02:21:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
20
Passenger Count
6
Trip Distance
5.74
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:47:42.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:54.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:47:42.000
Lpep Dropoff Datetime
2017-01-01T01:52:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
112
Passenger Count
1
Trip Distance
0.90
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:56:07.000 • Lpep Dropoff Datetime: 2017-01-01T02:05:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:56:07.000
Lpep Dropoff Datetime
2017-01-01T02:05:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
226
Passenger Count
1
Trip Distance
1.44
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:16:39.000 • Lpep Dropoff Datetime: 2017-01-01T01:31:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:16:39.000
Lpep Dropoff Datetime
2017-01-01T01:31:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
95
Passenger Count
1
Trip Distance
4.30
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:00:02.000 • Lpep Dropoff Datetime: 2017-01-01T01:14:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:00:02.000
Lpep Dropoff Datetime
2017-01-01T01:14:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
256
Passenger Count
1
Trip Distance
1.94
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:16:06.000 • Lpep Dropoff Datetime: 2017-01-01T01:21:42.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:16:06.000
Lpep Dropoff Datetime
2017-01-01T01:21:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
256
Passenger Count
1
Trip Distance
0.55
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:24:05.000 • Lpep Dropoff Datetime: 2017-01-01T01:36:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:24:05.000
Lpep Dropoff Datetime
2017-01-01T01:36:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
256
Dolocationid
225
Passenger Count
1
Trip Distance
1.88
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-01T01:43:16.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:43:16.000
Lpep Dropoff Datetime
2017-01-01T01:52:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
49
Passenger Count
1
Trip Distance
1.79
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.57
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.32
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:00:47.000 • Lpep Dropoff Datetime: 2017-01-01T01:18:08.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:00:47.000
Lpep Dropoff Datetime
2017-01-01T01:18:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
244
Passenger Count
1
Trip Distance
3.00
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:34:39.000 • Lpep Dropoff Datetime: 2017-01-01T01:35:22.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:34:39.000
Lpep Dropoff Datetime
2017-01-01T01:35:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
166
Passenger Count
1
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:31:56.000 • Lpep Dropoff Datetime: 2017-01-01T01:40:21.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:31:56.000
Lpep Dropoff Datetime
2017-01-01T01:40:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
244
Passenger Count
1
Trip Distance
1.51
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-01T01:44:43.000 • Lpep Dropoff Datetime: 2017-01-01T01:59:08.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:44:43.000
Lpep Dropoff Datetime
2017-01-01T01:59:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
244
Dolocationid
24
Passenger Count
1
Trip Distance
2.95
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:03:29.000 • Lpep Dropoff Datetime: 2017-01-01T01:13:54.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:03:29.000
Lpep Dropoff Datetime
2017-01-01T01:13:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
226
Dolocationid
83
Passenger Count
1
Trip Distance
2.04
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-01T01:24:26.000 • Lpep Dropoff Datetime: 2017-01-01T01:30:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:24:26.000
Lpep Dropoff Datetime
2017-01-01T01:30:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
82
Passenger Count
1
Trip Distance
1.03
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:45:59.000 • Lpep Dropoff Datetime: 2017-01-01T01:53:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:45:59.000
Lpep Dropoff Datetime
2017-01-01T01:53:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
129
Passenger Count
1
Trip Distance
1.79
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-01T01:23:52.000 • Lpep Dropoff Datetime: 2017-01-01T01:48:23.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:23:52.000
Lpep Dropoff Datetime
2017-01-01T01:48:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
40
Dolocationid
36
Passenger Count
6
Trip Distance
5.29
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
4.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:49:23.000 • Lpep Dropoff Datetime: 2017-01-01T01:57:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:49:23.000
Lpep Dropoff Datetime
2017-01-01T01:57:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
36
Dolocationid
37
Passenger Count
6
Trip Distance
1.25
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:04:31.000 • Lpep Dropoff Datetime: 2017-01-01T01:23:15.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:04:31.000
Lpep Dropoff Datetime
2017-01-01T01:23:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
83
Dolocationid
160
Passenger Count
2
Trip Distance
3.91
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:34:33.000 • Lpep Dropoff Datetime: 2017-01-01T01:38:15.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:34:33.000
Lpep Dropoff Datetime
2017-01-01T01:38:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
160
Passenger Count
2
Trip Distance
1.30
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:13:58.000 • Lpep Dropoff Datetime: 2017-01-01T01:18:16.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:13:58.000
Lpep Dropoff Datetime
2017-01-01T01:18:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
112
Passenger Count
5
Trip Distance
0.61
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:20:26.000 • Lpep Dropoff Datetime: 2017-01-01T01:42:56.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:20:26.000
Lpep Dropoff Datetime
2017-01-01T01:42:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
165
Passenger Count
5
Trip Distance
10.72
Fare Amount
31
Extra
0.5
Mta Tax
0.5
Tip Amount
8.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
40.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:57:51.000 • Lpep Dropoff Datetime: 2017-01-01T02:25:14.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:57:51.000
Lpep Dropoff Datetime
2017-01-01T02:25:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
7
Passenger Count
5
Trip Distance
11.17
Fare Amount
34
Extra
0.5
Mta Tax
0.5
Tip Amount
9.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
45
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:18:47.000 • Lpep Dropoff Datetime: 2017-01-01T01:24:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:18:47.000
Lpep Dropoff Datetime
2017-01-01T01:24:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
146
Dolocationid
7
Passenger Count
5
Trip Distance
1.09
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:30.000 • Lpep Dropoff Datetime: 2017-01-01T02:00:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:25:30.000
Lpep Dropoff Datetime
2017-01-01T02:00:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
149
Passenger Count
5
Trip Distance
18.13
Fare Amount
50
Extra
0.5
Mta Tax
0.5
Tip Amount
10.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
61.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:33:43.000 • Lpep Dropoff Datetime: 2017-01-01T01:42:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:33:43.000
Lpep Dropoff Datetime
2017-01-01T01:42:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
174
Dolocationid
254
Passenger Count
1
Trip Distance
1.87
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:51:09.000 • Lpep Dropoff Datetime: 2017-01-01T02:05:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:51:09.000
Lpep Dropoff Datetime
2017-01-01T02:05:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
127
Dolocationid
152
Passenger Count
1
Trip Distance
4.22
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
2.44
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.69
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:30:44.000 • Lpep Dropoff Datetime: 2017-01-01T01:36:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:30:44.000
Lpep Dropoff Datetime
2017-01-01T01:36:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
146
Dolocationid
226
Passenger Count
1
Trip Distance
1.22
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:38:16.000 • Lpep Dropoff Datetime: 2017-01-01T01:43:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:38:16.000
Lpep Dropoff Datetime
2017-01-01T01:43:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
226
Dolocationid
260
Passenger Count
1
Trip Distance
0.80
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:44:25.000 • Lpep Dropoff Datetime: 2017-01-01T01:52:16.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:44:25.000
Lpep Dropoff Datetime
2017-01-01T01:52:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
226
Passenger Count
1
Trip Distance
0.87
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
2
Trip Type
1
NYC Data AI • Public-data exploration interface