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
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:09.000 • Tpep Dropoff Datetime: 2017-01-01T11:37:12.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:09.000
Tpep Dropoff Datetime
2017-01-01T11:37:12.000
Passenger Count
1
Trip Distance
18.20
Ratecodeid
4
Store And Fwd Flag
N
Pulocationid
138
Dolocationid
265
Payment Type
2
Fare Amount
61.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
62.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:09.000 • Tpep Dropoff Datetime: 2017-01-01T11:19:46.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:09.000
Tpep Dropoff Datetime
2017-01-01T11:19:46.000
Passenger Count
1
Trip Distance
1.11
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
107
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
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:10.000 • Tpep Dropoff Datetime: 2017-01-01T11:31:59.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:10.000
Tpep Dropoff Datetime
2017-01-01T11:31:59.000
Passenger Count
2
Trip Distance
4.60
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
90
Dolocationid
262
Payment Type
2
Fare Amount
17
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:10.000 • Tpep Dropoff Datetime: 2017-01-01T11:18:34.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:10.000
Tpep Dropoff Datetime
2017-01-01T11:18:34.000
Passenger Count
3
Trip Distance
1.65
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
114
Dolocationid
186
Payment Type
2
Fare Amount
6.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:10.000 • Tpep Dropoff Datetime: 2017-01-01T11:17:48.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:10.000
Tpep Dropoff Datetime
2017-01-01T11:17:48.000
Passenger Count
1
Trip Distance
1.11
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
162
Dolocationid
237
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-01T11:14:11.000 • Tpep Dropoff Datetime: 2017-01-01T11:24:25.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:11.000
Tpep Dropoff Datetime
2017-01-01T11:24:25.000
Passenger Count
3
Trip Distance
2.40
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
141
Dolocationid
186
Payment Type
2
Fare Amount
10.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:11.000 • Tpep Dropoff Datetime: 2017-01-01T11:16:12.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:11.000
Tpep Dropoff Datetime
2017-01-01T11:16:12.000
Passenger Count
1
Trip Distance
0.85
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
162
Dolocationid
237
Payment Type
1
Fare Amount
4.5
Extra
0
Mta Tax
0.5
Tip Amount
1.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.62
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:11.000 • Tpep Dropoff Datetime: 2017-01-01T11:17:57.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:11.000
Tpep Dropoff Datetime
2017-01-01T11:17:57.000
Passenger Count
6
Trip Distance
0.85
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
230
Dolocationid
164
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-01T11:14:11.000 • Tpep Dropoff Datetime: 2017-01-01T11:28:06.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:11.000
Tpep Dropoff Datetime
2017-01-01T11:28:06.000
Passenger Count
5
Trip Distance
4.23
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
239
Dolocationid
249
Payment Type
1
Fare Amount
15
Extra
0
Mta Tax
0.5
Tip Amount
1.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.38
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:11.000 • Tpep Dropoff Datetime: 2017-01-01T11:27:33.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:11.000
Tpep Dropoff Datetime
2017-01-01T11:27:33.000
Passenger Count
1
Trip Distance
2.88
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
50
Payment Type
1
Fare Amount
12.5
Extra
0
Mta Tax
0.5
Tip Amount
1.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:12.000 • Tpep Dropoff Datetime: 2017-01-01T11:21:21.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:12.000
Tpep Dropoff Datetime
2017-01-01T11:21:21.000
Passenger Count
1
Trip Distance
1.10
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
107
Dolocationid
186
Payment Type
1
Fare Amount
7
Extra
0
Mta Tax
0.5
Tip Amount
1.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.35
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:12.000 • Tpep Dropoff Datetime: 2017-01-01T11:17:47.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:12.000
Tpep Dropoff Datetime
2017-01-01T11:17:47.000
Passenger Count
1
Trip Distance
0.60
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
239
Dolocationid
239
Payment Type
2
Fare Amount
4.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:12.000 • Tpep Dropoff Datetime: 2017-01-01T11:29:53.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:12.000
Tpep Dropoff Datetime
2017-01-01T11:29:53.000
Passenger Count
1
Trip Distance
3.60
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
263
Dolocationid
186
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
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:12.000 • Tpep Dropoff Datetime: 2017-01-01T11:18:57.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:12.000
Tpep Dropoff Datetime
2017-01-01T11:18:57.000
Passenger Count
1
Trip Distance
1.06
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
48
Dolocationid
50
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-01T11:14:12.000 • Tpep Dropoff Datetime: 2017-01-01T11:28:14.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:12.000
Tpep Dropoff Datetime
2017-01-01T11:28:14.000
Passenger Count
1
Trip Distance
5.18
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
13
Dolocationid
137
Payment Type
1
Fare Amount
17.5
Extra
0
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:12.000 • Tpep Dropoff Datetime: 2017-01-01T11:16:07.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:12.000
Tpep Dropoff Datetime
2017-01-01T11:16:07.000
Passenger Count
1
Trip Distance
0.68
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
142
Dolocationid
163
Payment Type
2
Fare Amount
4
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:13.000 • Tpep Dropoff Datetime: 2017-01-01T11:23:09.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:13.000
Tpep Dropoff Datetime
2017-01-01T11:23:09.000
Passenger Count
2
Trip Distance
5.20
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
233
Dolocationid
88
Payment Type
1
Fare Amount
16
Extra
0
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:13.000 • Tpep Dropoff Datetime: 2017-01-01T11:40:20.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:13.000
Tpep Dropoff Datetime
2017-01-01T11:40:20.000
Passenger Count
2
Trip Distance
17.10
Ratecodeid
3
Store And Fwd Flag
N
Pulocationid
230
Dolocationid
1
Payment Type
1
Fare Amount
64
Extra
0
Mta Tax
0
Tip Amount
10
Tolls Amount
17.5
Improvement Surcharge
0.3
Total Amount
91.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:13.000 • Tpep Dropoff Datetime: 2017-01-01T11:26:48.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:13.000
Tpep Dropoff Datetime
2017-01-01T11:26:48.000
Passenger Count
1
Trip Distance
7.64
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
223
Dolocationid
242
Payment Type
2
Fare Amount
22.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
28.84
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:14.000 • Tpep Dropoff Datetime: 2017-01-01T11:41:46.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:14.000
Tpep Dropoff Datetime
2017-01-01T11:41:46.000
Passenger Count
1
Trip Distance
19.50
Ratecodeid
2
Store And Fwd Flag
N
Pulocationid
132
Dolocationid
75
Payment Type
2
Fare Amount
52
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
58.34
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:14.000 • Tpep Dropoff Datetime: 2017-01-01T11:22:28.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:14.000
Tpep Dropoff Datetime
2017-01-01T11:22:28.000
Passenger Count
1
Trip Distance
1.80
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
107
Dolocationid
186
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-01T11:14:14.000 • Tpep Dropoff Datetime: 2017-01-01T11:24:58.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:14.000
Tpep Dropoff Datetime
2017-01-01T11:24:58.000
Passenger Count
1
Trip Distance
1.80
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
231
Dolocationid
79
Payment Type
1
Fare Amount
9
Extra
0
Mta Tax
0.5
Tip Amount
2.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.25
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:15.000 • Tpep Dropoff Datetime: 2017-01-01T11:31:33.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:15.000
Tpep Dropoff Datetime
2017-01-01T11:31:33.000
Passenger Count
4
Trip Distance
4.40
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
80
Payment Type
1
Fare Amount
16.5
Extra
0
Mta Tax
0.5
Tip Amount
3.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.75
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:15.000 • Tpep Dropoff Datetime: 2017-01-01T11:21:13.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:15.000
Tpep Dropoff Datetime
2017-01-01T11:21:13.000
Passenger Count
1
Trip Distance
1.50
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
162
Payment Type
1
Fare Amount
7.5
Extra
0
Mta Tax
0.5
Tip Amount
1.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.95
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:15.000 • Tpep Dropoff Datetime: 2017-01-01T11:44:27.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:15.000
Tpep Dropoff Datetime
2017-01-01T11:44:27.000
Passenger Count
5
Trip Distance
9.70
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
42
Payment Type
2
Fare Amount
32
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:15.000 • Tpep Dropoff Datetime: 2017-01-01T11:28:18.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:15.000
Tpep Dropoff Datetime
2017-01-01T11:28:18.000
Passenger Count
4
Trip Distance
2.54
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
230
Dolocationid
239
Payment Type
2
Fare Amount
12.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:15.000 • Tpep Dropoff Datetime: 2017-01-01T11:34:21.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:15.000
Tpep Dropoff Datetime
2017-01-01T11:34:21.000
Passenger Count
1
Trip Distance
5.45
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
48
Dolocationid
88
Payment Type
2
Fare Amount
20
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:16.000 • Tpep Dropoff Datetime: 2017-01-01T11:17:05.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:16.000
Tpep Dropoff Datetime
2017-01-01T11:17:05.000
Passenger Count
1
Trip Distance
0.90
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
186
Dolocationid
249
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
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:17.000 • Tpep Dropoff Datetime: 2017-01-01T11:19:44.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:17.000
Tpep Dropoff Datetime
2017-01-01T11:19:44.000
Passenger Count
1
Trip Distance
1.50
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
137
Dolocationid
148
Payment Type
2
Fare Amount
7
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:17.000 • Tpep Dropoff Datetime: 2017-01-01T11:20:51.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:17.000
Tpep Dropoff Datetime
2017-01-01T11:20:51.000
Passenger Count
1
Trip Distance
1.75
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
164
Dolocationid
43
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-01T11:14:17.000 • Tpep Dropoff Datetime: 2017-01-01T11:19:25.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:17.000
Tpep Dropoff Datetime
2017-01-01T11:19:25.000
Passenger Count
1
Trip Distance
1.24
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
249
Dolocationid
79
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-01T11:14:17.000 • Tpep Dropoff Datetime: 2017-01-01T11:21:49.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:17.000
Tpep Dropoff Datetime
2017-01-01T11:21:49.000
Passenger Count
2
Trip Distance
0.81
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
261
Dolocationid
209
Payment Type
1
Fare Amount
6.5
Extra
0
Mta Tax
0.5
Tip Amount
1.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.76
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:17.000 • Tpep Dropoff Datetime: 2017-01-01T11:20:26.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:17.000
Tpep Dropoff Datetime
2017-01-01T11:20:26.000
Passenger Count
6
Trip Distance
0.89
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
186
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-01T11:14:19.000 • Tpep Dropoff Datetime: 2017-01-01T11:21:20.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:19.000
Tpep Dropoff Datetime
2017-01-01T11:21:20.000
Passenger Count
1
Trip Distance
1.17
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
234
Dolocationid
186
Payment Type
2
Fare Amount
6.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:19.000 • Tpep Dropoff Datetime: 2017-01-01T11:17:51.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:19.000
Tpep Dropoff Datetime
2017-01-01T11:17:51.000
Passenger Count
1
Trip Distance
0.56
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
239
Dolocationid
142
Payment Type
1
Fare Amount
4.5
Extra
0
Mta Tax
0.5
Tip Amount
1.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.36
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:20.000 • Tpep Dropoff Datetime: 2017-01-01T11:17:54.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:20.000
Tpep Dropoff Datetime
2017-01-01T11:17:54.000
Passenger Count
1
Trip Distance
1.12
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
137
Dolocationid
162
Payment Type
1
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:20.000 • Tpep Dropoff Datetime: 2017-01-01T11:18:53.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:20.000
Tpep Dropoff Datetime
2017-01-01T11:18:53.000
Passenger Count
1
Trip Distance
1.18
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
249
Dolocationid
231
Payment Type
1
Fare Amount
6
Extra
0
Mta Tax
0.5
Tip Amount
1.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:20.000 • Tpep Dropoff Datetime: 2017-01-01T11:18:56.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:20.000
Tpep Dropoff Datetime
2017-01-01T11:18:56.000
Passenger Count
2
Trip Distance
1.03
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
79
Dolocationid
211
Payment Type
1
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
1.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.56
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:21.000 • Tpep Dropoff Datetime: 2017-01-01T11:18:58.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:21.000
Tpep Dropoff Datetime
2017-01-01T11:18:58.000
Passenger Count
1
Trip Distance
1.60
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
231
Dolocationid
158
Payment Type
1
Fare Amount
6.5
Extra
0
Mta Tax
0.5
Tip Amount
1.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.75
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:21.000 • Tpep Dropoff Datetime: 2017-01-01T11:21:27.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:21.000
Tpep Dropoff Datetime
2017-01-01T11:21:27.000
Passenger Count
1
Trip Distance
1.80
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
236
Dolocationid
161
Payment Type
1
Fare Amount
8
Extra
0
Mta Tax
0.5
Tip Amount
1.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:22.000 • Tpep Dropoff Datetime: 2017-01-01T11:18:08.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:22.000
Tpep Dropoff Datetime
2017-01-01T11:18:08.000
Passenger Count
2
Trip Distance
1.10
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
48
Dolocationid
68
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-01T11:14:22.000 • Tpep Dropoff Datetime: 2017-01-01T11:23:05.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:22.000
Tpep Dropoff Datetime
2017-01-01T11:23:05.000
Passenger Count
3
Trip Distance
1.20
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
211
Dolocationid
158
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
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:22.000 • Tpep Dropoff Datetime: 2017-01-01T11:21:32.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:22.000
Tpep Dropoff Datetime
2017-01-01T11:21:32.000
Passenger Count
1
Trip Distance
1.90
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
238
Dolocationid
163
Payment Type
1
Fare Amount
8
Extra
0
Mta Tax
0.5
Tip Amount
2.6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.4
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:25.000 • Tpep Dropoff Datetime: 2017-01-01T11:18:13.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:25.000
Tpep Dropoff Datetime
2017-01-01T11:18:13.000
Passenger Count
1
Trip Distance
1.60
Ratecodeid
4
Store And Fwd Flag
N
Pulocationid
233
Dolocationid
79
Payment Type
3
Fare Amount
10.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2017-01-01T11:14:25.000 • Tpep Dropoff Datetime: 2017-01-01T11:21:11.000
Vendorid
1
Tpep Pickup Datetime
2017-01-01T11:14:25.000
Tpep Dropoff Datetime
2017-01-01T11:21:11.000
Passenger Count
2
Trip Distance
1.40
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
249
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-01T11:14:25.000 • Tpep Dropoff Datetime: 2017-01-01T11:15:40.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:25.000
Tpep Dropoff Datetime
2017-01-01T11:15:40.000
Passenger Count
1
Trip Distance
0.34
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
100
Dolocationid
161
Payment Type
2
Fare Amount
3
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
3.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:26.000 • Tpep Dropoff Datetime: 2017-01-01T11:17:12.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:26.000
Tpep Dropoff Datetime
2017-01-01T11:17:12.000
Passenger Count
1
Trip Distance
0.58
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
238
Dolocationid
239
Payment Type
1
Fare Amount
4.5
Extra
0
Mta Tax
0.5
Tip Amount
1.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.36
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:26.000 • Tpep Dropoff Datetime: 2017-01-01T11:25:19.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:26.000
Tpep Dropoff Datetime
2017-01-01T11:25:19.000
Passenger Count
1
Trip Distance
2.57
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
263
Dolocationid
161
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-01T11:14:26.000 • Tpep Dropoff Datetime: 2017-01-01T11:20:45.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:26.000
Tpep Dropoff Datetime
2017-01-01T11:20:45.000
Passenger Count
1
Trip Distance
1.25
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
100
Dolocationid
68
Payment Type
2
Fare Amount
6.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2017-01-01T11:14:26.000 • Tpep Dropoff Datetime: 2017-01-01T11:24:35.000
Vendorid
2
Tpep Pickup Datetime
2017-01-01T11:14:26.000
Tpep Dropoff Datetime
2017-01-01T11:24:35.000
Passenger Count
5
Trip Distance
3.38
Ratecodeid
1
Store And Fwd Flag
N
Pulocationid
107
Dolocationid
236
Payment Type
1
Fare Amount
12
Extra
0
Mta Tax
0.5
Tip Amount
2.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.36