2017 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 biws-g3hs 17 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:46.000 • Tpep Dropoff Datetime: 2017-01-01T07:30:05.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:46.000
Tpep Dropoff Datetime
2017-01-01T07:30:05.000
Passenger Count
2
Trip Distance
7.89
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
48
Dolocationid
243
Payment Type
2
Fare Amount
24
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:13:50.000 • Tpep Dropoff Datetime: 2017-01-01T07:34:26.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:13:50.000
Tpep Dropoff Datetime
2017-01-01T07:34:26.000
Passenger Count
1
Trip Distance
13.60
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
197
Dolocationid
78
Payment Type
1
Fare Amount
37
Extra
0
Mta Tax
0.5
Tip Amount
4
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
47.34
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:50.000 • Tpep Dropoff Datetime: 2017-01-01T07:31:04.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:50.000
Tpep Dropoff Datetime
2017-01-01T07:31:04.000
Passenger Count
2
Trip Distance
4.93
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
37
Payment Type
1
Fare Amount
18.5
Extra
0
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:51.000 • Tpep Dropoff Datetime: 2017-01-01T07:15:52.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:51.000
Tpep Dropoff Datetime
2017-01-01T07:15:52.000
Passenger Count
1
Trip Distance
0.55
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
137
Dolocationid
164
Payment Type
1
Fare Amount
4
Extra
0
Mta Tax
0.5
Tip Amount
0.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.76
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:52.000 • Tpep Dropoff Datetime: 2017-01-01T07:33:41.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:52.000
Tpep Dropoff Datetime
2017-01-01T07:33:41.000
Passenger Count
1
Trip Distance
3.25
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
226
Dolocationid
82
Payment Type
2
Fare Amount
14.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:52.000 • Tpep Dropoff Datetime: 2017-01-01T07:21:51.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:52.000
Tpep Dropoff Datetime
2017-01-01T07:21:51.000
Passenger Count
1
Trip Distance
1.78
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
4
Payment Type
2
Fare Amount
8.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:54.000 • Tpep Dropoff Datetime: 2017-01-01T07:19:51.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:54.000
Tpep Dropoff Datetime
2017-01-01T07:19:51.000
Passenger Count
1
Trip Distance
0.97
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
68
Dolocationid
164
Payment Type
2
Fare Amount
6
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:56.000 • Tpep Dropoff Datetime: 2017-01-01T07:20:25.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:56.000
Tpep Dropoff Datetime
2017-01-01T07:20:25.000
Passenger Count
2
Trip Distance
1.62
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
125
Dolocationid
261
Payment Type
1
Fare Amount
7
Extra
0
Mta Tax
0.5
Tip Amount
2.34
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.14
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:56.000 • Tpep Dropoff Datetime: 2017-01-01T07:25:00.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:56.000
Tpep Dropoff Datetime
2017-01-01T07:25:00.000
Passenger Count
1
Trip Distance
2.61
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
152
Dolocationid
243
Payment Type
2
Fare Amount
11
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:58.000 • Tpep Dropoff Datetime: 2017-01-01T07:37:33.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:58.000
Tpep Dropoff Datetime
2017-01-01T07:37:33.000
Passenger Count
1
Trip Distance
10.23
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
141
Dolocationid
138
Payment Type
2
Fare Amount
29.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:13:59.000 • Tpep Dropoff Datetime: 2017-01-01T07:21:53.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:13:59.000
Tpep Dropoff Datetime
2017-01-01T07:21:53.000
Passenger Count
1
Trip Distance
3.35
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
137
Dolocationid
263
Payment Type
1
Fare Amount
10.5
Extra
0
Mta Tax
0.5
Tip Amount
2.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.56
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:00.000 • Tpep Dropoff Datetime: 2017-01-01T07:19:51.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:00.000
Tpep Dropoff Datetime
2017-01-01T07:19:51.000
Passenger Count
1
Trip Distance
1.65
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
186
Dolocationid
143
Payment Type
1
Fare Amount
7
Extra
0
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:00.000 • Tpep Dropoff Datetime: 2017-01-01T07:26:12.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:00.000
Tpep Dropoff Datetime
2017-01-01T07:26:12.000
Passenger Count
1
Trip Distance
2.76
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
113
Dolocationid
50
Payment Type
1
Fare Amount
11.5
Extra
0
Mta Tax
0.5
Tip Amount
2.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.76
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:01.000 • Tpep Dropoff Datetime: 2017-01-01T07:19:57.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:01.000
Tpep Dropoff Datetime
2017-01-01T07:19:57.000
Passenger Count
1
Trip Distance
1.80
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
230
Dolocationid
164
Payment Type
1
Fare Amount
7
Extra
0
Mta Tax
0.5
Tip Amount
1.17
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.97
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:01.000 • Tpep Dropoff Datetime: 2017-01-01T07:24:37.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:01.000
Tpep Dropoff Datetime
2017-01-01T07:24:37.000
Passenger Count
2
Trip Distance
2.00
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
232
Dolocationid
107
Payment Type
1
Fare Amount
10
Extra
0
Mta Tax
0.5
Tip Amount
2.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.5
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:02.000 • Tpep Dropoff Datetime: 2017-01-01T07:19:05.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:02.000
Tpep Dropoff Datetime
2017-01-01T07:19:05.000
Passenger Count
3
Trip Distance
0.93
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
75
Dolocationid
263
Payment Type
1
Fare Amount
6
Extra
0
Mta Tax
0.5
Tip Amount
1.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.16
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:02.000 • Tpep Dropoff Datetime: 2017-01-01T07:21:22.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:02.000
Tpep Dropoff Datetime
2017-01-01T07:21:22.000
Passenger Count
1
Trip Distance
2.74
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
114
Dolocationid
50
Payment Type
2
Fare Amount
10
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:03.000 • Tpep Dropoff Datetime: 2017-01-01T07:22:45.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:03.000
Tpep Dropoff Datetime
2017-01-01T07:22:45.000
Passenger Count
1
Trip Distance
2.08
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
166
Dolocationid
238
Payment Type
1
Fare Amount
9.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:04.000 • Tpep Dropoff Datetime: 2017-01-01T07:17:46.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:04.000
Tpep Dropoff Datetime
2017-01-01T07:17:46.000
Passenger Count
1
Trip Distance
0.90
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
164
Dolocationid
234
Payment Type
1
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:07.000 • Tpep Dropoff Datetime: 2017-01-01T07:44:28.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:07.000
Tpep Dropoff Datetime
2017-01-01T07:44:28.000
Passenger Count
2
Trip Distance
18.90
Ratecodeid
3
Store And Fwd Flag
N
Pulocationid
163
Dolocationid
1
Payment Type
1
Fare Amount
69
Extra
0
Mta Tax
0
Tip Amount
17.75
Tolls Amount
19.58
Improvement Surcharge
0.3
Total Amount
106.63
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:08.000 • Tpep Dropoff Datetime: 2017-01-01T07:21:05.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:08.000
Tpep Dropoff Datetime
2017-01-01T07:21:05.000
Passenger Count
2
Trip Distance
1.90
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
37
Dolocationid
255
Payment Type
1
Fare Amount
8
Extra
0
Mta Tax
0.5
Tip Amount
1.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.55
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:08.000 • Tpep Dropoff Datetime: 2017-01-01T07:16:58.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:08.000
Tpep Dropoff Datetime
2017-01-01T07:16:58.000
Passenger Count
1
Trip Distance
1.10
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
143
Dolocationid
48
Payment Type
2
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:08.000 • Tpep Dropoff Datetime: 2017-01-01T07:30:01.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:08.000
Tpep Dropoff Datetime
2017-01-01T07:30:01.000
Passenger Count
2
Trip Distance
4.38
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
164
Dolocationid
41
Payment Type
1
Fare Amount
16
Extra
0
Mta Tax
0.5
Tip Amount
3.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.16
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:12.000 • Tpep Dropoff Datetime: 2017-01-01T07:19:52.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:12.000
Tpep Dropoff Datetime
2017-01-01T07:19:52.000
Passenger Count
1
Trip Distance
0.81
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
161
Dolocationid
170
Payment Type
2
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:15.000 • Tpep Dropoff Datetime: 2017-01-01T07:23:30.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:15.000
Tpep Dropoff Datetime
2017-01-01T07:23:30.000
Passenger Count
1
Trip Distance
4.40
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
148
Dolocationid
17
Payment Type
2
Fare Amount
14
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:18.000 • Tpep Dropoff Datetime: 2017-01-01T07:23:40.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:18.000
Tpep Dropoff Datetime
2017-01-01T07:23:40.000
Passenger Count
1
Trip Distance
4.80
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
237
Dolocationid
82
Payment Type
2
Fare Amount
15
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:19.000 • Tpep Dropoff Datetime: 2017-01-01T07:25:37.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:19.000
Tpep Dropoff Datetime
2017-01-01T07:25:37.000
Passenger Count
5
Trip Distance
5.74
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
141
Dolocationid
45
Payment Type
2
Fare Amount
18
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:19.000 • Tpep Dropoff Datetime: 2017-01-01T07:20:23.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:19.000
Tpep Dropoff Datetime
2017-01-01T07:20:23.000
Passenger Count
2
Trip Distance
1.58
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
263
Dolocationid
238
Payment Type
1
Fare Amount
7.5
Extra
0
Mta Tax
0.5
Tip Amount
2.49
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.79
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:20.000 • Tpep Dropoff Datetime: 2017-01-01T07:18:34.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:20.000
Tpep Dropoff Datetime
2017-01-01T07:18:34.000
Passenger Count
2
Trip Distance
1.20
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
4
Dolocationid
224
Payment Type
1
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:23.000 • Tpep Dropoff Datetime: 2017-01-01T07:18:40.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:23.000
Tpep Dropoff Datetime
2017-01-01T07:18:40.000
Passenger Count
2
Trip Distance
1.04
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
90
Dolocationid
170
Payment Type
2
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:24.000 • Tpep Dropoff Datetime: 2017-01-01T07:33:47.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:24.000
Tpep Dropoff Datetime
2017-01-01T07:33:47.000
Passenger Count
1
Trip Distance
7.85
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
226
Dolocationid
114
Payment Type
1
Fare Amount
25
Extra
0
Mta Tax
0.5
Tip Amount
5.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.96
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:25.000 • Tpep Dropoff Datetime: 2017-01-01T07:18:13.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:25.000
Tpep Dropoff Datetime
2017-01-01T07:18:13.000
Passenger Count
1
Trip Distance
0.60
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
114
Dolocationid
249
Payment Type
1
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
1.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.95
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:25.000 • Tpep Dropoff Datetime: 2017-01-01T07:19:20.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:25.000
Tpep Dropoff Datetime
2017-01-01T07:19:20.000
Passenger Count
3
Trip Distance
1.12
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
137
Dolocationid
233
Payment Type
1
Fare Amount
6
Extra
0
Mta Tax
0.5
Tip Amount
1.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.16
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:26.000 • Tpep Dropoff Datetime: 2017-01-01T07:14:58.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:26.000
Tpep Dropoff Datetime
2017-01-01T07:14:58.000
Passenger Count
1
Trip Distance
0.00
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
230
Dolocationid
230
Payment Type
2
Fare Amount
2.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
3.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:26.000 • Tpep Dropoff Datetime: 2017-01-01T07:18:40.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:26.000
Tpep Dropoff Datetime
2017-01-01T07:18:40.000
Passenger Count
1
Trip Distance
0.60
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
141
Dolocationid
237
Payment Type
2
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:26.000 • Tpep Dropoff Datetime: 2017-01-01T07:40:47.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:26.000
Tpep Dropoff Datetime
2017-01-01T07:40:47.000
Passenger Count
5
Trip Distance
7.13
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
140
Dolocationid
243
Payment Type
2
Fare Amount
24.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:27.000 • Tpep Dropoff Datetime: 2017-01-01T07:23:41.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:27.000
Tpep Dropoff Datetime
2017-01-01T07:23:41.000
Passenger Count
3
Trip Distance
3.33
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
264
Dolocationid
264
Payment Type
1
Fare Amount
11
Extra
0
Mta Tax
0.5
Tip Amount
3.54
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.34
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:28.000 • Tpep Dropoff Datetime: 2017-01-01T07:21:48.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:28.000
Tpep Dropoff Datetime
2017-01-01T07:21:48.000
Passenger Count
1
Trip Distance
2.70
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
249
Dolocationid
48
Payment Type
2
Fare Amount
10
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:28.000 • Tpep Dropoff Datetime: 2017-01-01T07:28:33.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:28.000
Tpep Dropoff Datetime
2017-01-01T07:28:33.000
Passenger Count
1
Trip Distance
3.80
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
68
Dolocationid
236
Payment Type
1
Fare Amount
14
Extra
0
Mta Tax
0.5
Tip Amount
2.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.75
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:28.000 • Tpep Dropoff Datetime: 2017-01-01T07:23:12.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:28.000
Tpep Dropoff Datetime
2017-01-01T07:23:12.000
Passenger Count
1
Trip Distance
1.71
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
92
Dolocationid
73
Payment Type
2
Fare Amount
8.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:28.000 • Tpep Dropoff Datetime: 2017-01-01T07:24:13.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:28.000
Tpep Dropoff Datetime
2017-01-01T07:24:13.000
Passenger Count
1
Trip Distance
4.59
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
112
Payment Type
1
Fare Amount
14.5
Extra
0
Mta Tax
0.5
Tip Amount
3.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.36
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:31.000 • Tpep Dropoff Datetime: 2017-01-01T07:21:01.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:31.000
Tpep Dropoff Datetime
2017-01-01T07:21:01.000
Passenger Count
1
Trip Distance
1.70
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
107
Dolocationid
186
Payment Type
2
Fare Amount
7.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:32.000 • Tpep Dropoff Datetime: 2017-01-01T07:18:25.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:32.000
Tpep Dropoff Datetime
2017-01-01T07:18:25.000
Passenger Count
1
Trip Distance
1.09
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
170
Dolocationid
100
Payment Type
1
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
1.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.88
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:33.000 • Tpep Dropoff Datetime: 2017-01-01T07:18:49.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:33.000
Tpep Dropoff Datetime
2017-01-01T07:18:49.000
Passenger Count
1
Trip Distance
0.81
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
224
Payment Type
2
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T07:14:33.000 • Tpep Dropoff Datetime: 2017-01-01T07:22:42.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T07:14:33.000
Tpep Dropoff Datetime
2017-01-01T07:22:42.000
Passenger Count
3
Trip Distance
1.71
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
186
Payment Type
2
Fare Amount
8.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:34.000 • Tpep Dropoff Datetime: 2017-01-01T07:39:41.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:34.000
Tpep Dropoff Datetime
2017-01-01T07:39:41.000
Passenger Count
1
Trip Distance
7.30
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
24
Payment Type
2
Fare Amount
24
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:36.000 • Tpep Dropoff Datetime: 2017-01-01T07:36:03.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:36.000
Tpep Dropoff Datetime
2017-01-01T07:36:03.000
Passenger Count
1
Trip Distance
6.80
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
107
Dolocationid
198
Payment Type
2
Fare Amount
22.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:37.000 • Tpep Dropoff Datetime: 2017-01-01T07:24:14.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:37.000
Tpep Dropoff Datetime
2017-01-01T07:24:14.000
Passenger Count
1
Trip Distance
2.00
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
170
Dolocationid
140
Payment Type
2
Fare Amount
9.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:38.000 • Tpep Dropoff Datetime: 2017-01-01T07:26:33.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:38.000
Tpep Dropoff Datetime
2017-01-01T07:26:33.000
Passenger Count
1
Trip Distance
2.50
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
17
Dolocationid
112
Payment Type
1
Fare Amount
11
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T07:14:39.000 • Tpep Dropoff Datetime: 2017-01-01T07:23:57.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T07:14:39.000
Tpep Dropoff Datetime
2017-01-01T07:23:57.000
Passenger Count
1
Trip Distance
3.10
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
231
Dolocationid
48
Payment Type
1
Fare Amount
11
Extra
0
Mta Tax
0.5
Tip Amount
2.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.15