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:04:32.000 • Lpep Dropoff Datetime: 2017-01-01T01:14:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:04:32.000
Lpep Dropoff Datetime
2017-01-01T01:14:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
181
Passenger Count
1
Trip Distance
1.58
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:46.000 • Lpep Dropoff Datetime: 2017-01-01T01:40:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:16:46.000
Lpep Dropoff Datetime
2017-01-01T01:40:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
91
Passenger Count
1
Trip Distance
4.55
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:02:03.000 • Lpep Dropoff Datetime: 2017-01-01T01:37:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:02:03.000
Lpep Dropoff Datetime
2017-01-01T01:37:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
225
Dolocationid
164
Passenger Count
1
Trip Distance
5.97
Fare Amount
26
Extra
0.5
Mta Tax
0.5
Tip Amount
5.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:07:23.000 • Lpep Dropoff Datetime: 2017-01-01T01:19:29.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:07:23.000
Lpep Dropoff Datetime
2017-01-01T01:19:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
256
Passenger Count
1
Trip Distance
2.11
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-01T01:22:45.000 • Lpep Dropoff Datetime: 2017-01-01T01:36:39.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:22:45.000
Lpep Dropoff Datetime
2017-01-01T01:36:39.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
256
Dolocationid
106
Passenger Count
1
Trip Distance
5.34
Fare Amount
35
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
35
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:48:20.000 • Lpep Dropoff Datetime: 2017-01-01T02:16:48.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:48:20.000
Lpep Dropoff Datetime
2017-01-01T02:16:48.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
228
Dolocationid
162
Passenger Count
1
Trip Distance
10.62
Fare Amount
70
Extra
0
Mta Tax
0
Tip Amount
10
Tolls Amount
0
Improvement Surcharge
0
Total Amount
80
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:08:22.000 • Lpep Dropoff Datetime: 2017-01-01T01:16:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:08:22.000
Lpep Dropoff Datetime
2017-01-01T01:16:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
42
Passenger Count
1
Trip Distance
1.11
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-01T01:17:15.000 • Lpep Dropoff Datetime: 2017-01-01T01:39:59.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:17:15.000
Lpep Dropoff Datetime
2017-01-01T01:39:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
48
Passenger Count
1
Trip Distance
6.03
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:59:05.000 • Lpep Dropoff Datetime: 2017-01-01T02:04:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:59:05.000
Lpep Dropoff Datetime
2017-01-01T02:04:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
42
Passenger Count
1
Trip Distance
1.01
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:46:51.000 • Lpep Dropoff Datetime: 2017-01-01T01:56:10.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:46:51.000
Lpep Dropoff Datetime
2017-01-01T01:56:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
41
Passenger Count
1
Trip Distance
1.58
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:59:38.000 • Lpep Dropoff Datetime: 2017-01-01T02:15:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:59:38.000
Lpep Dropoff Datetime
2017-01-01T02:15:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
74
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-01T01:08:14.000 • Lpep Dropoff Datetime: 2017-01-01T01:11:42.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:08:14.000
Lpep Dropoff Datetime
2017-01-01T01:11:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
123
Dolocationid
149
Passenger Count
1
Trip Distance
0.62
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-01T01:13:45.000 • Lpep Dropoff Datetime: 2017-01-01T01:51:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:13:45.000
Lpep Dropoff Datetime
2017-01-01T01:51:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
149
Dolocationid
14
Passenger Count
1
Trip Distance
9.11
Fare Amount
32.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:15:23.000 • Lpep Dropoff Datetime: 2017-01-01T01:21:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:15:23.000
Lpep Dropoff Datetime
2017-01-01T01:21:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
75
Dolocationid
74
Passenger Count
5
Trip Distance
0.97
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:24:32.000 • Lpep Dropoff Datetime: 2017-01-01T01:56:31.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:24:32.000
Lpep Dropoff Datetime
2017-01-01T01:56:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
254
Passenger Count
5
Trip Distance
10.72
Fare Amount
33.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:59:02.000 • Lpep Dropoff Datetime: 2017-01-01T02:18:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:59:02.000
Lpep Dropoff Datetime
2017-01-01T02:18:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
254
Dolocationid
69
Passenger Count
5
Trip Distance
7.35
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:38:50.000 • Lpep Dropoff Datetime: 2017-01-01T01:44:51.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:38:50.000
Lpep Dropoff Datetime
2017-01-01T01:44:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
197
Passenger Count
1
Trip Distance
2.43
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: 2017-01-01T01:01:47.000 • Lpep Dropoff Datetime: 2017-01-01T01:05:45.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:01:47.000
Lpep Dropoff Datetime
2017-01-01T01:05:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
82
Passenger Count
1
Trip Distance
0.81
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:19:17.000 • Lpep Dropoff Datetime: 2017-01-01T01:27:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:19:17.000
Lpep Dropoff Datetime
2017-01-01T01:27:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
7
Passenger Count
1
Trip Distance
1.56
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
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-01T01:09:25.000 • Lpep Dropoff Datetime: 2017-01-01T01:26:35.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:09:25.000
Lpep Dropoff Datetime
2017-01-01T01:26:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
255
Passenger Count
1
Trip Distance
2.43
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:42:18.000 • Lpep Dropoff Datetime: 2017-01-01T02:21:58.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:42:18.000
Lpep Dropoff Datetime
2017-01-01T02:21:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
152
Passenger Count
1
Trip Distance
14.00
Fare Amount
44
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
52.79
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:02:43.000 • Lpep Dropoff Datetime: 2017-01-01T01:29:41.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:02:43.000
Lpep Dropoff Datetime
2017-01-01T01:29:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
95
Passenger Count
2
Trip Distance
4.65
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.24
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.04
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:38:43.000 • Lpep Dropoff Datetime: 2017-01-01T01:44:55.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:38:43.000
Lpep Dropoff Datetime
2017-01-01T01:44:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
56
Passenger Count
2
Trip Distance
0.90
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:56:25.000 • Lpep Dropoff Datetime: 2017-01-01T02:03:49.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:56:25.000
Lpep Dropoff Datetime
2017-01-01T02:03:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
173
Passenger Count
2
Trip Distance
1.13
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:49:03.000 • Lpep Dropoff Datetime: 2017-01-01T02:17:13.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:49:03.000
Lpep Dropoff Datetime
2017-01-01T02:17:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
134
Passenger Count
1
Trip Distance
6.54
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
6.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:16:43.000 • Lpep Dropoff Datetime: 2017-01-01T01:23:58.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:16:43.000
Lpep Dropoff Datetime
2017-01-01T01:23:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
36
Passenger Count
1
Trip Distance
0.80
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.17
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.92
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:30:47.000 • Lpep Dropoff Datetime: 2017-01-01T01:57:24.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:30:47.000
Lpep Dropoff Datetime
2017-01-01T01:57:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
36
Dolocationid
195
Passenger Count
1
Trip Distance
7.95
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:31:51.000 • Lpep Dropoff Datetime: 2017-01-01T01:56:52.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:31:51.000
Lpep Dropoff Datetime
2017-01-01T01:56:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
90
Passenger Count
5
Trip Distance
5.87
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:08:23.000 • Lpep Dropoff Datetime: 2017-01-01T01:18:04.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:08:23.000
Lpep Dropoff Datetime
2017-01-01T01:18:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
65
Passenger Count
2
Trip Distance
1.60
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:34:19.000 • Lpep Dropoff Datetime: 2017-01-01T01:49:09.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:34:19.000
Lpep Dropoff Datetime
2017-01-01T01:49:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
4
Passenger Count
1
Trip Distance
4.74
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-01T01:30:21.000 • Lpep Dropoff Datetime: 2017-01-01T01:41:37.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:30:21.000
Lpep Dropoff Datetime
2017-01-01T01:41:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
69
Passenger Count
1
Trip Distance
2.71
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-01T01:52:44.000 • Lpep Dropoff Datetime: 2017-01-01T02:06:18.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:52:44.000
Lpep Dropoff Datetime
2017-01-01T02:06:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
130
Dolocationid
218
Passenger Count
1
Trip Distance
3.23
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:28:06.000 • Lpep Dropoff Datetime: 2017-01-01T01:30:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:28:06.000
Lpep Dropoff Datetime
2017-01-01T01:30:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
166
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-01T01:38:26.000 • Lpep Dropoff Datetime: 2017-01-01T01:46:08.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:38:26.000
Lpep Dropoff Datetime
2017-01-01T01:46:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
74
Passenger Count
1
Trip Distance
1.23
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-01T01:50:42.000 • Lpep Dropoff Datetime: 2017-01-01T01:54:34.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:50:42.000
Lpep Dropoff Datetime
2017-01-01T01:54:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
75
Dolocationid
74
Passenger Count
1
Trip Distance
0.62
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
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-01T01:32:01.000 • Lpep Dropoff Datetime: 2017-01-01T01:51:12.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:32:01.000
Lpep Dropoff Datetime
2017-01-01T01:51:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
56
Passenger Count
1
Trip Distance
9.91
Fare Amount
28
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
34.84
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:54:56.000 • Lpep Dropoff Datetime: 2017-01-01T02:26:44.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:54:56.000
Lpep Dropoff Datetime
2017-01-01T02:26:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
56
Dolocationid
265
Passenger Count
1
Trip Distance
16.87
Fare Amount
47.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
48.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:27:41.000 • Lpep Dropoff Datetime: 2017-01-01T01:49:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:27:41.000
Lpep Dropoff Datetime
2017-01-01T01:49:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
57
Dolocationid
260
Passenger Count
3
Trip Distance
3.34
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:52:06.000 • Lpep Dropoff Datetime: 2017-01-01T02:05:26.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:52:06.000
Lpep Dropoff Datetime
2017-01-01T02:05:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
82
Passenger Count
2
Trip Distance
2.12
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:29:06.000 • Lpep Dropoff Datetime: 2017-01-01T01:29:32.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:29:06.000
Lpep Dropoff Datetime
2017-01-01T01:29:32.000
Store And Fwd Flag
N
Ratecodeid
5
Pulocationid
55
Dolocationid
55
Passenger Count
2
Trip Distance
0.00
Fare Amount
45
Extra
0
Mta Tax
0
Tip Amount
11.25
Tolls Amount
0
Improvement Surcharge
0
Total Amount
56.25
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:00:06.000 • Lpep Dropoff Datetime: 2017-01-01T02:19:11.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:00:06.000
Lpep Dropoff Datetime
2017-01-01T02:19:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
37
Dolocationid
37
Passenger Count
1
Trip Distance
4.11
Fare Amount
26
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:43:44.000 • Lpep Dropoff Datetime: 2017-01-01T01:50:18.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:43:44.000
Lpep Dropoff Datetime
2017-01-01T01:50:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
173
Passenger Count
2
Trip Distance
0.93
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:55:06.000 • Lpep Dropoff Datetime: 2017-01-01T02:01:43.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:55:06.000
Lpep Dropoff Datetime
2017-01-01T02:01:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
173
Dolocationid
56
Passenger Count
2
Trip Distance
1.85
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:13:12.000 • Lpep Dropoff Datetime: 2017-01-01T01:16:38.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:13:12.000
Lpep Dropoff Datetime
2017-01-01T01:16:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
181
Passenger Count
1
Trip Distance
0.70
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:24:02.000 • Lpep Dropoff Datetime: 2017-01-01T01:39:01.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:24:02.000
Lpep Dropoff Datetime
2017-01-01T01:39:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
14
Passenger Count
1
Trip Distance
4.71
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-01T01:39:07.000 • Lpep Dropoff Datetime: 2017-01-01T02:08:00.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:39:07.000
Lpep Dropoff Datetime
2017-01-01T02:08:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
70
Dolocationid
228
Passenger Count
1
Trip Distance
14.58
Fare Amount
41
Extra
0.5
Mta Tax
0.5
Tip Amount
8.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
50.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:02:17.000 • Lpep Dropoff Datetime: 2017-01-01T01:03:50.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:02:17.000
Lpep Dropoff Datetime
2017-01-01T01:03:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
28
Passenger Count
1
Trip Distance
0.56
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:09:55.000 • Lpep Dropoff Datetime: 2017-01-01T01:15:15.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:09:55.000
Lpep Dropoff Datetime
2017-01-01T01:15:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
197
Passenger Count
1
Trip Distance
1.30
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:21:29.000 • Lpep Dropoff Datetime: 2017-01-01T01:30:30.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:21:29.000
Lpep Dropoff Datetime
2017-01-01T01:30:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
216
Passenger Count
1
Trip Distance
4.34
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.44
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.24
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2017-01-01T01:41:08.000 • Lpep Dropoff Datetime: 2017-01-01T01:44:28.000
Vendorid
2
Lpep Pickup Datetime
2017-01-01T01:41:08.000
Lpep Dropoff Datetime
2017-01-01T01:44:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
134
Dolocationid
28
Passenger Count
1
Trip Distance
0.89
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
NYC Data AI • Public-data exploration interface