2023 Yellow Taxi Trip Data

These records are generated from the trip record submissions made by yellow taxi Technology Service Providers (TSPs). Each row represents a single trip in a yellow 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 4b4i-vvec 19 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
1
Vendorid: 1 • Tpep Pickup Datetime: 2023-01-01T00:42:00.000 • Tpep Dropoff Datetime: 2023-01-01T00:55:56.000
Vendorid
1
Tpep Pickup Datetime
2023-01-01T00:42:00.000
Tpep Dropoff Datetime
2023-01-01T00:55:56.000
Passenger Count
3.0
Trip Distance
2.6
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
170
Dolocationid
211
Payment Type
1
Fare Amount
15.6
Extra
3.5
Mta Tax
0.5
Tip Amount
4.1
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
24.7
Congestion Surcharge
2.5
Airport Fee
0.0
1
Vendorid: 1 • Tpep Pickup Datetime: 2023-01-01T00:58:38.000 • Tpep Dropoff Datetime: 2023-01-01T01:17:06.000
Vendorid
1
Tpep Pickup Datetime
2023-01-01T00:58:38.000
Tpep Dropoff Datetime
2023-01-01T01:17:06.000
Passenger Count
2.0
Trip Distance
4.0
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
211
Dolocationid
229
Payment Type
2
Fare Amount
21.2
Extra
3.5
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
26.2
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:16:28.000 • Tpep Dropoff Datetime: 2023-01-01T00:25:26.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:16:28.000
Tpep Dropoff Datetime
2023-01-01T00:25:26.000
Passenger Count
1.0
Trip Distance
2.75
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
137
Dolocationid
232
Payment Type
1
Fare Amount
14.2
Extra
1.0
Mta Tax
0.5
Tip Amount
2.5
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
21.7
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:29:48.000 • Tpep Dropoff Datetime: 2023-01-01T00:41:53.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:29:48.000
Tpep Dropoff Datetime
2023-01-01T00:41:53.000
Passenger Count
1.0
Trip Distance
2.02
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
232
Dolocationid
148
Payment Type
1
Fare Amount
13.5
Extra
1.0
Mta Tax
0.5
Tip Amount
3.7
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
22.2
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:43:39.000 • Tpep Dropoff Datetime: 2023-01-01T01:06:07.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:43:39.000
Tpep Dropoff Datetime
2023-01-01T01:06:07.000
Passenger Count
1.0
Trip Distance
2.88
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
148
Dolocationid
256
Payment Type
1
Fare Amount
23.3
Extra
1.0
Mta Tax
0.5
Tip Amount
5.66
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
33.96
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:31:31.000 • Tpep Dropoff Datetime: 2023-01-01T01:16:10.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:31:31.000
Tpep Dropoff Datetime
2023-01-01T01:16:10.000
Passenger Count
2.0
Trip Distance
5.33
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
209
Dolocationid
50
Payment Type
2
Fare Amount
39.4
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
44.4
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:17:23.000 • Tpep Dropoff Datetime: 2023-01-01T00:37:02.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:17:23.000
Tpep Dropoff Datetime
2023-01-01T00:37:02.000
Passenger Count
1.0
Trip Distance
1.23
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
68
Dolocationid
164
Payment Type
2
Fare Amount
17.0
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
22.0
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:44:56.000 • Tpep Dropoff Datetime: 2023-01-01T01:09:11.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:44:56.000
Tpep Dropoff Datetime
2023-01-01T01:09:11.000
Passenger Count
1.0
Trip Distance
4.37
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
236
Payment Type
1
Fare Amount
24.7
Extra
1.0
Mta Tax
0.5
Tip Amount
5.94
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
35.64
Congestion Surcharge
2.5
Airport Fee
0.0
1
Vendorid: 1 • Tpep Pickup Datetime: 2023-01-01T00:38:00.000 • Tpep Dropoff Datetime: 2023-01-01T00:44:45.000
Vendorid
1
Tpep Pickup Datetime
2023-01-01T00:38:00.000
Tpep Dropoff Datetime
2023-01-01T00:44:45.000
Passenger Count
2.0
Trip Distance
1.4
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
246
Dolocationid
234
Payment Type
2
Fare Amount
8.6
Extra
3.5
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
13.6
Congestion Surcharge
2.5
Airport Fee
0.0
1
Vendorid: 1 • Tpep Pickup Datetime: 2023-01-01T00:45:03.000 • Tpep Dropoff Datetime: 2023-01-01T01:14:04.000
Vendorid
1
Tpep Pickup Datetime
2023-01-01T00:45:03.000
Tpep Dropoff Datetime
2023-01-01T01:14:04.000
Passenger Count
1.0
Trip Distance
5.6
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
226
Payment Type
1
Fare Amount
28.2
Extra
3.5
Mta Tax
0.5
Tip Amount
5.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
38.2
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:16:12.000 • Tpep Dropoff Datetime: 2023-01-01T00:24:41.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:16:12.000
Tpep Dropoff Datetime
2023-01-01T00:24:41.000
Passenger Count
1.0
Trip Distance
4.0
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
170
Dolocationid
209
Payment Type
1
Fare Amount
17.7
Extra
1.0
Mta Tax
0.5
Tip Amount
4.54
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
27.24
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:34:25.000 • Tpep Dropoff Datetime: 2023-01-01T00:40:20.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:34:25.000
Tpep Dropoff Datetime
2023-01-01T00:40:20.000
Passenger Count
1.0
Trip Distance
1.38
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
87
Dolocationid
232
Payment Type
1
Fare Amount
8.6
Extra
1.0
Mta Tax
0.5
Tip Amount
2.72
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
16.32
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:46:53.000 • Tpep Dropoff Datetime: 2023-01-01T00:56:28.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:46:53.000
Tpep Dropoff Datetime
2023-01-01T00:56:28.000
Passenger Count
1.0
Trip Distance
1.17
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
114
Payment Type
1
Fare Amount
10.7
Extra
1.0
Mta Tax
0.5
Tip Amount
3.14
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
18.84
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:29:04.000 • Tpep Dropoff Datetime: 2023-01-01T00:53:09.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:29:04.000
Tpep Dropoff Datetime
2023-01-01T00:53:09.000
Passenger Count
1.0
Trip Distance
6.54
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
170
Dolocationid
261
Payment Type
2
Fare Amount
32.4
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
37.4
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:55:26.000 • Tpep Dropoff Datetime: 2023-01-01T01:04:55.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:55:26.000
Tpep Dropoff Datetime
2023-01-01T01:04:55.000
Passenger Count
1.0
Trip Distance
1.87
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
231
Dolocationid
113
Payment Type
1
Fare Amount
11.4
Extra
1.0
Mta Tax
0.5
Tip Amount
3.28
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
19.68
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:30:30.000 • Tpep Dropoff Datetime: 2023-01-01T00:54:38.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:30:30.000
Tpep Dropoff Datetime
2023-01-01T00:54:38.000
Passenger Count
1.0
Trip Distance
5.29
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
237
Dolocationid
114
Payment Type
1
Fare Amount
28.9
Extra
1.0
Mta Tax
0.5
Tip Amount
8.09
Tolls Amount
6.55
Improvement Surcharge
1.0
Total Amount
48.54
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:55:30.000 • Tpep Dropoff Datetime: 2023-01-01T01:01:59.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:55:30.000
Tpep Dropoff Datetime
2023-01-01T01:01:59.000
Passenger Count
1.0
Trip Distance
1.45
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
114
Dolocationid
170
Payment Type
1
Fare Amount
9.3
Extra
1.0
Mta Tax
0.5
Tip Amount
2.86
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
17.16
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:21:27.000 • Tpep Dropoff Datetime: 2023-01-01T00:52:38.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:21:27.000
Tpep Dropoff Datetime
2023-01-01T00:52:38.000
Passenger Count
1.0
Trip Distance
18.47
Ratecodeid
2.0
Store And Fwd Flag
N
Pulocationid
264
Dolocationid
144
Payment Type
1
Fare Amount
70.0
Extra
0.0
Mta Tax
0.5
Tip Amount
14.8
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
90.05
Congestion Surcharge
2.5
Airport Fee
1.25
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:57:51.000 • Tpep Dropoff Datetime: 2023-01-01T01:16:58.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:57:51.000
Tpep Dropoff Datetime
2023-01-01T01:16:58.000
Passenger Count
3.0
Trip Distance
3.98
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
114
Dolocationid
237
Payment Type
1
Fare Amount
21.2
Extra
1.0
Mta Tax
0.5
Tip Amount
1.5
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
27.7
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:19:17.000 • Tpep Dropoff Datetime: 2023-01-01T00:34:55.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:19:17.000
Tpep Dropoff Datetime
2023-01-01T00:34:55.000
Passenger Count
1.0
Trip Distance
7.45
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
132
Dolocationid
76
Payment Type
2
Fare Amount
31.0
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
34.75
Congestion Surcharge
0.0
Airport Fee
1.25
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:20:39.000 • Tpep Dropoff Datetime: 2023-01-01T00:51:23.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:20:39.000
Tpep Dropoff Datetime
2023-01-01T00:51:23.000
Passenger Count
1.0
Trip Distance
3.48
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
246
Dolocationid
239
Payment Type
1
Fare Amount
28.2
Extra
1.0
Mta Tax
0.5
Tip Amount
8.3
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
41.5
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:09:19.000 • Tpep Dropoff Datetime: 2023-01-01T00:19:58.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:09:19.000
Tpep Dropoff Datetime
2023-01-01T00:19:58.000
Passenger Count
2.0
Trip Distance
0.99
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
43
Dolocationid
163
Payment Type
1
Fare Amount
10.7
Extra
1.0
Mta Tax
0.5
Tip Amount
3.92
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
19.62
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:21:54.000 • Tpep Dropoff Datetime: 2023-01-01T00:36:54.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:21:54.000
Tpep Dropoff Datetime
2023-01-01T00:36:54.000
Passenger Count
2.0
Trip Distance
0.63
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
163
Dolocationid
161
Payment Type
1
Fare Amount
13.5
Extra
1.0
Mta Tax
0.5
Tip Amount
2.78
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
21.28
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:46:40.000 • Tpep Dropoff Datetime: 2023-01-01T01:07:09.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:46:40.000
Tpep Dropoff Datetime
2023-01-01T01:07:09.000
Passenger Count
2.0
Trip Distance
3.13
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
161
Dolocationid
148
Payment Type
1
Fare Amount
19.8
Extra
1.0
Mta Tax
0.5
Tip Amount
4.96
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
29.76
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:13:14.000 • Tpep Dropoff Datetime: 2023-01-01T00:17:32.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:13:14.000
Tpep Dropoff Datetime
2023-01-01T00:17:32.000
Passenger Count
2.0
Trip Distance
0.81
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
107
Dolocationid
170
Payment Type
1
Fare Amount
6.5
Extra
1.0
Mta Tax
0.5
Tip Amount
2.3
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
13.8
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:54:04.000 • Tpep Dropoff Datetime: 2023-01-01T01:18:05.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:54:04.000
Tpep Dropoff Datetime
2023-01-01T01:18:05.000
Passenger Count
3.0
Trip Distance
5.95
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
162
Dolocationid
88
Payment Type
1
Fare Amount
31.0
Extra
1.0
Mta Tax
0.5
Tip Amount
4.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
40.0
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:27:42.000 • Tpep Dropoff Datetime: 2023-01-01T00:41:06.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:27:42.000
Tpep Dropoff Datetime
2023-01-01T00:41:06.000
Passenger Count
1.0
Trip Distance
6.08
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
132
Dolocationid
124
Payment Type
2
Fare Amount
25.4
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
29.15
Congestion Surcharge
0.0
Airport Fee
1.25
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:09:33.000 • Tpep Dropoff Datetime: 2023-01-01T00:17:44.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:09:33.000
Tpep Dropoff Datetime
2023-01-01T00:17:44.000
Passenger Count
1.0
Trip Distance
1.1
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
125
Payment Type
1
Fare Amount
9.3
Extra
1.0
Mta Tax
0.5
Tip Amount
2.57
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
16.87
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:22:45.000 • Tpep Dropoff Datetime: 2023-01-01T00:34:33.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:22:45.000
Tpep Dropoff Datetime
2023-01-01T00:34:33.000
Passenger Count
1.0
Trip Distance
2.22
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
211
Dolocationid
170
Payment Type
1
Fare Amount
14.2
Extra
1.0
Mta Tax
0.5
Tip Amount
3.84
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
23.04
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:44:22.000 • Tpep Dropoff Datetime: 2023-01-01T00:52:11.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:44:22.000
Tpep Dropoff Datetime
2023-01-01T00:52:11.000
Passenger Count
1.0
Trip Distance
1.51
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
107
Dolocationid
79
Payment Type
2
Fare Amount
10.0
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
15.0
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:54:22.000 • Tpep Dropoff Datetime: 2023-01-01T01:17:21.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:54:22.000
Tpep Dropoff Datetime
2023-01-01T01:17:21.000
Passenger Count
1.0
Trip Distance
7.65
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
4
Dolocationid
146
Payment Type
2
Fare Amount
34.5
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
39.5
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:48:06.000 • Tpep Dropoff Datetime: 2023-01-01T01:06:40.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:48:06.000
Tpep Dropoff Datetime
2023-01-01T01:06:40.000
Passenger Count
2.0
Trip Distance
2.9
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
43
Payment Type
1
Fare Amount
19.1
Extra
1.0
Mta Tax
0.5
Tip Amount
6.02
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
30.12
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:07:40.000 • Tpep Dropoff Datetime: 2023-01-01T00:14:21.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:07:40.000
Tpep Dropoff Datetime
2023-01-01T00:14:21.000
Passenger Count
1.0
Trip Distance
0.83
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
162
Dolocationid
237
Payment Type
1
Fare Amount
7.9
Extra
1.0
Mta Tax
0.5
Tip Amount
2.58
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
15.48
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:15:12.000 • Tpep Dropoff Datetime: 2023-01-01T00:39:34.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:15:12.000
Tpep Dropoff Datetime
2023-01-01T00:39:34.000
Passenger Count
1.0
Trip Distance
11.18
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
239
Dolocationid
18
Payment Type
3
Fare Amount
-45.0
Extra
-1.0
Mta Tax
-0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
-1.0
Total Amount
-50.0
Congestion Surcharge
-2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:15:12.000 • Tpep Dropoff Datetime: 2023-01-01T00:39:34.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:15:12.000
Tpep Dropoff Datetime
2023-01-01T00:39:34.000
Passenger Count
1.0
Trip Distance
11.18
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
239
Dolocationid
18
Payment Type
3
Fare Amount
45.0
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
50.0
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:16:28.000 • Tpep Dropoff Datetime: 2023-01-01T00:24:31.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:16:28.000
Tpep Dropoff Datetime
2023-01-01T00:24:31.000
Passenger Count
2.0
Trip Distance
0.81
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
161
Dolocationid
229
Payment Type
1
Fare Amount
9.3
Extra
1.0
Mta Tax
0.5
Tip Amount
2.86
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
17.16
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:26:36.000 • Tpep Dropoff Datetime: 2023-01-01T00:29:51.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:26:36.000
Tpep Dropoff Datetime
2023-01-01T00:29:51.000
Passenger Count
4.0
Trip Distance
0.65
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
229
Dolocationid
140
Payment Type
1
Fare Amount
5.8
Extra
1.0
Mta Tax
0.5
Tip Amount
2.16
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
12.96
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:34:27.000 • Tpep Dropoff Datetime: 2023-01-01T00:36:37.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:34:27.000
Tpep Dropoff Datetime
2023-01-01T00:36:37.000
Passenger Count
3.0
Trip Distance
0.46
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
141
Dolocationid
237
Payment Type
1
Fare Amount
4.4
Extra
1.0
Mta Tax
0.5
Tip Amount
1.88
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
11.28
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:38:26.000 • Tpep Dropoff Datetime: 2023-01-01T00:46:07.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:38:26.000
Tpep Dropoff Datetime
2023-01-01T00:46:07.000
Passenger Count
3.0
Trip Distance
2.06
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
237
Dolocationid
75
Payment Type
1
Fare Amount
11.4
Extra
1.0
Mta Tax
0.5
Tip Amount
4.92
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
21.32
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:48:19.000 • Tpep Dropoff Datetime: 2023-01-01T01:14:48.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:48:19.000
Tpep Dropoff Datetime
2023-01-01T01:14:48.000
Passenger Count
2.0
Trip Distance
10.73
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
75
Dolocationid
25
Payment Type
2
Fare Amount
-45.0
Extra
-1.0
Mta Tax
-0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
-1.0
Total Amount
-50.0
Congestion Surcharge
-2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:48:19.000 • Tpep Dropoff Datetime: 2023-01-01T01:14:48.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:48:19.000
Tpep Dropoff Datetime
2023-01-01T01:14:48.000
Passenger Count
2.0
Trip Distance
10.73
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
75
Dolocationid
25
Payment Type
2
Fare Amount
45.0
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
50.0
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:55:07.000 • Tpep Dropoff Datetime: 2023-01-01T01:08:28.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:55:07.000
Tpep Dropoff Datetime
2023-01-01T01:08:28.000
Passenger Count
3.0
Trip Distance
5.41
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
132
Dolocationid
216
Payment Type
2
Fare Amount
24.0
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
27.75
Congestion Surcharge
0.0
Airport Fee
1.25
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:27:01.000 • Tpep Dropoff Datetime: 2023-01-01T00:34:07.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:27:01.000
Tpep Dropoff Datetime
2023-01-01T00:34:07.000
Passenger Count
2.0
Trip Distance
1.15
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
231
Dolocationid
249
Payment Type
1
Fare Amount
9.3
Extra
1.0
Mta Tax
0.5
Tip Amount
1.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
15.3
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:36:29.000 • Tpep Dropoff Datetime: 2023-01-01T01:20:05.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:36:29.000
Tpep Dropoff Datetime
2023-01-01T01:20:05.000
Passenger Count
2.0
Trip Distance
5.72
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
249
Dolocationid
151
Payment Type
1
Fare Amount
41.5
Extra
1.0
Mta Tax
0.5
Tip Amount
9.3
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
55.8
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:13:40.000 • Tpep Dropoff Datetime: 2023-01-01T00:24:54.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:13:40.000
Tpep Dropoff Datetime
2023-01-01T00:24:54.000
Passenger Count
1.0
Trip Distance
4.72
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
132
Dolocationid
203
Payment Type
1
Fare Amount
21.2
Extra
1.0
Mta Tax
0.5
Tip Amount
3.74
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
28.69
Congestion Surcharge
0.0
Airport Fee
1.25
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:32:30.000 • Tpep Dropoff Datetime: 2023-01-01T00:52:16.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:32:30.000
Tpep Dropoff Datetime
2023-01-01T00:52:16.000
Passenger Count
1.0
Trip Distance
1.08
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
142
Dolocationid
48
Payment Type
2
Fare Amount
16.3
Extra
1.0
Mta Tax
0.5
Tip Amount
0.0
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
21.3
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:53:24.000 • Tpep Dropoff Datetime: 2023-01-01T01:15:21.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:53:24.000
Tpep Dropoff Datetime
2023-01-01T01:15:21.000
Passenger Count
1.0
Trip Distance
0.79
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
48
Dolocationid
68
Payment Type
1
Fare Amount
18.4
Extra
1.0
Mta Tax
0.5
Tip Amount
4.68
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
28.08
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:15:31.000 • Tpep Dropoff Datetime: 2023-01-01T00:25:45.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:15:31.000
Tpep Dropoff Datetime
2023-01-01T00:25:45.000
Passenger Count
1.0
Trip Distance
1.57
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
264
Dolocationid
162
Payment Type
1
Fare Amount
11.4
Extra
1.0
Mta Tax
0.5
Tip Amount
3.28
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
19.68
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:30:03.000 • Tpep Dropoff Datetime: 2023-01-01T00:39:40.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:30:03.000
Tpep Dropoff Datetime
2023-01-01T00:39:40.000
Passenger Count
1.0
Trip Distance
1.88
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
264
Dolocationid
237
Payment Type
1
Fare Amount
12.1
Extra
1.0
Mta Tax
0.5
Tip Amount
3.42
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
20.52
Congestion Surcharge
2.5
Airport Fee
0.0
2
Vendorid: 2 • Tpep Pickup Datetime: 2023-01-01T00:44:59.000 • Tpep Dropoff Datetime: 2023-01-01T00:46:10.000
Vendorid
2
Tpep Pickup Datetime
2023-01-01T00:44:59.000
Tpep Dropoff Datetime
2023-01-01T00:46:10.000
Passenger Count
1.0
Trip Distance
0.28
Ratecodeid
1.0
Store And Fwd Flag
N
Pulocationid
264
Dolocationid
229
Payment Type
1
Fare Amount
3.7
Extra
1.0
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0.0
Improvement Surcharge
1.0
Total Amount
10.44
Congestion Surcharge
2.5
Airport Fee
0.0