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:37:34.000 • Lpep Dropoff Datetime: 2018-01-01T00:50:44.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:37:34.000
Lpep Dropoff Datetime
2018-01-01T00:50:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
145
Dolocationid
7
Passenger Count
1
Trip Distance
2.55
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: 2018-01-01T00:54:53.000 • Lpep Dropoff Datetime: 2018-01-01T01:08:24.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:54:53.000
Lpep Dropoff Datetime
2018-01-01T01:08:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
173
Passenger Count
1
Trip Distance
3.16
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:57:30.000 • Lpep Dropoff Datetime: 2018-01-01T01:13:04.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:57:30.000
Lpep Dropoff Datetime
2018-01-01T01:13:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
129
Dolocationid
36
Passenger Count
2
Trip Distance
5.86
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:35:06.000 • Lpep Dropoff Datetime: 2018-01-01T00:59:27.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:35:06.000
Lpep Dropoff Datetime
2018-01-01T00:59:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
97
Dolocationid
228
Passenger Count
1
Trip Distance
3.60
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:48:43.000 • Lpep Dropoff Datetime: 2018-01-01T00:58:03.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:48:43.000
Lpep Dropoff Datetime
2018-01-01T00:58:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
83
Dolocationid
226
Passenger Count
2
Trip Distance
1.96
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: 2018-01-01T00:41:40.000 • Lpep Dropoff Datetime: 2018-01-01T00:54:32.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:41:40.000
Lpep Dropoff Datetime
2018-01-01T00:54:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
260
Passenger Count
1
Trip Distance
2.08
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T01:00:19.000 • Lpep Dropoff Datetime: 2018-01-01T01:03:10.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T01:00:19.000
Lpep Dropoff Datetime
2018-01-01T01:03:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
7
Passenger Count
1
Trip Distance
0.58
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:53:11.000 • Lpep Dropoff Datetime: 2018-01-01T00:59:25.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:53:11.000
Lpep Dropoff Datetime
2018-01-01T00:59:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
74
Dolocationid
42
Passenger Count
1
Trip Distance
1.00
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:05:12.000 • Lpep Dropoff Datetime: 2018-01-01T00:11:43.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:05:12.000
Lpep Dropoff Datetime
2018-01-01T00:11:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
75
Passenger Count
1
Trip Distance
1.15
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:31:13.000 • Lpep Dropoff Datetime: 2018-01-01T00:51:24.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:31:13.000
Lpep Dropoff Datetime
2018-01-01T00:51:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
169
Passenger Count
1
Trip Distance
5.07
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:26:19.000 • Lpep Dropoff Datetime: 2018-01-01T00:36:02.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:26:19.000
Lpep Dropoff Datetime
2018-01-01T00:36:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
173
Dolocationid
56
Passenger Count
1
Trip Distance
2.45
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T01:01:04.000 • Lpep Dropoff Datetime: 2018-01-01T01:41:26.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T01:01:04.000
Lpep Dropoff Datetime
2018-01-01T01:41:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
228
Dolocationid
127
Passenger Count
1
Trip Distance
18.54
Fare Amount
53
Extra
0.5
Mta Tax
0.5
Tip Amount
8.14
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
64.39
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:27:32.000 • Lpep Dropoff Datetime: 2018-01-01T00:40:21.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:27:32.000
Lpep Dropoff Datetime
2018-01-01T00:40:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
70
Passenger Count
1
Trip Distance
2.51
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: 2018-01-01T00:59:26.000 • Lpep Dropoff Datetime: 2018-01-01T01:15:09.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:59:26.000
Lpep Dropoff Datetime
2018-01-01T01:15:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
260
Dolocationid
25
Passenger Count
1
Trip Distance
8.01
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:46:55.000 • Lpep Dropoff Datetime: 2018-01-01T00:53:04.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:46:55.000
Lpep Dropoff Datetime
2018-01-01T00:53:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
179
Dolocationid
223
Passenger Count
1
Trip Distance
0.92
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:12:49.000 • Lpep Dropoff Datetime: 2018-01-01T00:49:06.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:12:49.000
Lpep Dropoff Datetime
2018-01-01T00:49:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
130
Passenger Count
1
Trip Distance
9.20
Fare Amount
32
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:27:52.000 • Lpep Dropoff Datetime: 2018-01-01T00:31:58.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:27:52.000
Lpep Dropoff Datetime
2018-01-01T00:31:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
223
Passenger Count
1
Trip Distance
1.08
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:36:54.000 • Lpep Dropoff Datetime: 2018-01-01T00:41:32.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:36:54.000
Lpep Dropoff Datetime
2018-01-01T00:41:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
223
Dolocationid
179
Passenger Count
1
Trip Distance
1.30
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.49
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:31:57.000 • Lpep Dropoff Datetime: 2018-01-01T00:47:01.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:31:57.000
Lpep Dropoff Datetime
2018-01-01T00:47:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
74
Passenger Count
2
Trip Distance
2.00
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: 2018-01-01T00:47:37.000 • Lpep Dropoff Datetime: 2018-01-01T00:53:14.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:47:37.000
Lpep Dropoff Datetime
2018-01-01T00:53:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
95
Dolocationid
196
Passenger Count
6
Trip Distance
1.30
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:19:44.000 • Lpep Dropoff Datetime: 2018-01-01T00:32:04.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:19:44.000
Lpep Dropoff Datetime
2018-01-01T00:32:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
242
Dolocationid
248
Passenger Count
1
Trip Distance
2.31
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: 2018-01-01T00:46:18.000 • Lpep Dropoff Datetime: 2018-01-01T00:55:46.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:46:18.000
Lpep Dropoff Datetime
2018-01-01T00:55:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
242
Dolocationid
32
Passenger Count
1
Trip Distance
2.35
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:21:54.000 • Lpep Dropoff Datetime: 2018-01-01T00:41:15.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:21:54.000
Lpep Dropoff Datetime
2018-01-01T00:41:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
31
Passenger Count
1
Trip Distance
7.63
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T01:00:05.000 • Lpep Dropoff Datetime: 2018-01-01T01:14:51.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T01:00:05.000
Lpep Dropoff Datetime
2018-01-01T01:14:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
94
Dolocationid
247
Passenger Count
1
Trip Distance
4.42
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:07:21.000 • Lpep Dropoff Datetime: 2018-01-01T00:11:04.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:07:21.000
Lpep Dropoff Datetime
2018-01-01T00:11:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
181
Passenger Count
1
Trip Distance
0.78
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:28:43.000 • Lpep Dropoff Datetime: 2018-01-01T00:30:28.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:28:43.000
Lpep Dropoff Datetime
2018-01-01T00:30:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
52
Dolocationid
52
Passenger Count
1
Trip Distance
0.33
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:40:21.000 • Lpep Dropoff Datetime: 2018-01-01T00:47:43.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:40:21.000
Lpep Dropoff Datetime
2018-01-01T00:47:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
33
Dolocationid
189
Passenger Count
1
Trip Distance
1.55
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:20:17.000 • Lpep Dropoff Datetime: 2018-01-01T00:48:40.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:20:17.000
Lpep Dropoff Datetime
2018-01-01T00:48:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
66
Dolocationid
48
Passenger Count
2
Trip Distance
5.30
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
4
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:22:40.000 • Lpep Dropoff Datetime: 2018-01-01T00:42:37.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:22:40.000
Lpep Dropoff Datetime
2018-01-01T00:42:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
80
Dolocationid
181
Passenger Count
1
Trip Distance
4.97
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:43:49.000 • Lpep Dropoff Datetime: 2018-01-01T00:49:37.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:43:49.000
Lpep Dropoff Datetime
2018-01-01T00:49:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
40
Passenger Count
1
Trip Distance
1.21
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:52:08.000 • Lpep Dropoff Datetime: 2018-01-01T01:09:30.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:52:08.000
Lpep Dropoff Datetime
2018-01-01T01:09:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
25
Dolocationid
107
Passenger Count
1
Trip Distance
5.82
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:07:28.000 • Lpep Dropoff Datetime: 2018-01-01T00:13:25.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:07:28.000
Lpep Dropoff Datetime
2018-01-01T00:13:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
247
Dolocationid
235
Passenger Count
1
Trip Distance
1.26
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:51:23.000 • Lpep Dropoff Datetime: 2018-01-01T00:56:13.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:51:23.000
Lpep Dropoff Datetime
2018-01-01T00:56:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
127
Dolocationid
243
Passenger Count
1
Trip Distance
0.84
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:17:03.000 • Lpep Dropoff Datetime: 2018-01-01T00:22:57.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:17:03.000
Lpep Dropoff Datetime
2018-01-01T00:22:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
62
Dolocationid
62
Passenger Count
1
Trip Distance
0.46
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: 2018-01-01T00:28:00.000 • Lpep Dropoff Datetime: 2018-01-01T00:34:15.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:28:00.000
Lpep Dropoff Datetime
2018-01-01T00:34:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
189
Dolocationid
49
Passenger Count
1
Trip Distance
0.98
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.49
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:24:04.000 • Lpep Dropoff Datetime: 2018-01-01T00:42:52.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:24:04.000
Lpep Dropoff Datetime
2018-01-01T00:42:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
166
Dolocationid
68
Passenger Count
1
Trip Distance
5.41
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
5.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:34:22.000 • Lpep Dropoff Datetime: 2018-01-01T00:50:29.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:34:22.000
Lpep Dropoff Datetime
2018-01-01T00:50:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
94
Dolocationid
159
Passenger Count
1
Trip Distance
3.50
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: 2018-01-01T00:30:51.000 • Lpep Dropoff Datetime: 2018-01-01T00:43:34.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:30:51.000
Lpep Dropoff Datetime
2018-01-01T00:43:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
116
Dolocationid
24
Passenger Count
1
Trip Distance
2.06
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: 2018-01-01T00:45:33.000 • Lpep Dropoff Datetime: 2018-01-01T00:55:30.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:45:33.000
Lpep Dropoff Datetime
2018-01-01T00:55:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
74
Passenger Count
1
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: 2018-01-01T00:55:48.000 • Lpep Dropoff Datetime: 2018-01-01T01:02:08.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:55:48.000
Lpep Dropoff Datetime
2018-01-01T01:02:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
82
Dolocationid
82
Passenger Count
1
Trip Distance
1.19
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:18:24.000 • Lpep Dropoff Datetime: 2018-01-01T00:29:55.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:18:24.000
Lpep Dropoff Datetime
2018-01-01T00:29:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
129
Passenger Count
1
Trip Distance
2.50
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:50:20.000 • Lpep Dropoff Datetime: 2018-01-01T01:05:57.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:50:20.000
Lpep Dropoff Datetime
2018-01-01T01:05:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
41
Passenger Count
1
Trip Distance
5.01
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.91
Tolls Amount
5.76
Improvement Surcharge
0.3
Total Amount
29.47
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:23:45.000 • Lpep Dropoff Datetime: 2018-01-01T00:23:45.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:23:45.000
Lpep Dropoff Datetime
2018-01-01T00:23:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
7
Dolocationid
264
Passenger Count
1
Trip Distance
0.00
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:52:43.000 • Lpep Dropoff Datetime: 2018-01-01T01:22:40.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:52:43.000
Lpep Dropoff Datetime
2018-01-01T01:22:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
112
Dolocationid
143
Passenger Count
1
Trip Distance
5.60
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
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:43:48.000 • Lpep Dropoff Datetime: 2018-01-01T00:47:34.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:43:48.000
Lpep Dropoff Datetime
2018-01-01T00:47:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
42
Dolocationid
42
Passenger Count
1
Trip Distance
0.70
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2018-01-01T00:55:38.000 • Lpep Dropoff Datetime: 2018-01-01T01:01:29.000
Vendorid
1
Lpep Pickup Datetime
2018-01-01T00:55:38.000
Lpep Dropoff Datetime
2018-01-01T01:01:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
41
Dolocationid
42
Passenger Count
1
Trip Distance
1.40
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:10:46.000 • Lpep Dropoff Datetime: 2018-01-01T00:28:49.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:10:46.000
Lpep Dropoff Datetime
2018-01-01T00:28:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
49
Dolocationid
49
Passenger Count
1
Trip Distance
0.86
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:40:52.000 • Lpep Dropoff Datetime: 2018-01-01T01:24:42.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:40:52.000
Lpep Dropoff Datetime
2018-01-01T01:24:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
255
Dolocationid
79
Passenger Count
1
Trip Distance
8.11
Fare Amount
32
Extra
0.5
Mta Tax
0.5
Tip Amount
6.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
39.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2018-01-01T00:18:46.000 • Lpep Dropoff Datetime: 2018-01-01T00:27:01.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:18:46.000
Lpep Dropoff Datetime
2018-01-01T00:27:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
181
Dolocationid
97
Passenger Count
1
Trip Distance
1.45
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: 2018-01-01T00:40:06.000 • Lpep Dropoff Datetime: 2018-01-01T00:47:30.000
Vendorid
2
Lpep Pickup Datetime
2018-01-01T00:40:06.000
Lpep Dropoff Datetime
2018-01-01T00:47:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pulocationid
65
Dolocationid
97
Passenger Count
1
Trip Distance
1.16
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