2016 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 uacg-pexx 21 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-06T00:52:05.000 • Tpep Dropoff Datetime: 2016-02-06T01:14:49.000
Vendorid
2
Tpep Pickup Datetime
2016-02-06T00:52:05.000
Tpep Dropoff Datetime
2016-02-06T01:14:49.000
Passenger Count
3
Trip Distance
9.79
Pickup Longitude
-73.984718322753906
Pickup Latitude
40.757400512695313
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.918594360351563
Dropoff Latitude
40.870441436767578
Payment Type
1
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
36.96
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-25T18:13:13.000 • Tpep Dropoff Datetime: 2016-02-25T18:39:47.000
Vendorid
2
Tpep Pickup Datetime
2016-02-25T18:13:13.000
Tpep Dropoff Datetime
2016-02-25T18:39:47.000
Passenger Count
1
Trip Distance
2.89
Pickup Longitude
-73.978012084960938
Pickup Latitude
40.759349822998047
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.98992919921875
Dropoff Latitude
40.729728698730469
Payment Type
1
Fare Amount
17.5
Extra
1
Mta Tax
0.5
Tip Amount
2.98
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.28
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-20T10:50:08.000 • Tpep Dropoff Datetime: 2016-02-20T11:07:54.000
Vendorid
1
Tpep Pickup Datetime
2016-02-20T10:50:08.000
Tpep Dropoff Datetime
2016-02-20T11:07:54.000
Passenger Count
1
Trip Distance
5.9
Pickup Longitude
-73.944496154785156
Pickup Latitude
40.779323577880859
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.993278503417969
Dropoff Latitude
40.722225189208984
Payment Type
1
Fare Amount
19.5
Extra
0
Mta Tax
0.5
Tip Amount
4.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.35
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-10T10:28:59.000 • Tpep Dropoff Datetime: 2016-02-10T10:48:03.000
Vendorid
1
Tpep Pickup Datetime
2016-02-10T10:28:59.000
Tpep Dropoff Datetime
2016-02-10T10:48:03.000
Passenger Count
1
Trip Distance
3
Pickup Longitude
-73.981407165527344
Pickup Latitude
40.764316558837891
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.008476257324219
Dropoff Latitude
40.739421844482422
Payment Type
1
Fare Amount
14.5
Extra
0
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-24T17:29:55.000 • Tpep Dropoff Datetime: 2016-02-24T17:38:08.000
Vendorid
1
Tpep Pickup Datetime
2016-02-24T17:29:55.000
Tpep Dropoff Datetime
2016-02-24T17:38:08.000
Passenger Count
1
Trip Distance
1.4
Pickup Longitude
-73.987388610839844
Pickup Latitude
40.743991851806641
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.001998901367188
Dropoff Latitude
40.728309631347656
Payment Type
1
Fare Amount
7.5
Extra
1
Mta Tax
0.5
Tip Amount
1.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.15
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-28T22:13:29.000 • Tpep Dropoff Datetime: 2016-02-28T22:18:38.000
Vendorid
2
Tpep Pickup Datetime
2016-02-28T22:13:29.000
Tpep Dropoff Datetime
2016-02-28T22:18:38.000
Passenger Count
1
Trip Distance
1.06
Pickup Longitude
-73.967941284179687
Pickup Latitude
40.762432098388672
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.981826782226563
Dropoff Latitude
40.763290405273437
Payment Type
1
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
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-22T07:49:17.000 • Tpep Dropoff Datetime: 2016-02-22T07:56:31.000
Vendorid
1
Tpep Pickup Datetime
2016-02-22T07:49:17.000
Tpep Dropoff Datetime
2016-02-22T07:56:31.000
Passenger Count
1
Trip Distance
1.4
Pickup Longitude
-73.97021484375
Pickup Latitude
40.752155303955078
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.964202880859375
Dropoff Latitude
40.767181396484375
Payment Type
1
Fare Amount
7
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-21T08:43:10.000 • Tpep Dropoff Datetime: 2016-02-21T08:51:59.000
Vendorid
1
Tpep Pickup Datetime
2016-02-21T08:43:10.000
Tpep Dropoff Datetime
2016-02-21T08:51:59.000
Passenger Count
2
Trip Distance
1.5
Pickup Longitude
-73.997726440429687
Pickup Latitude
40.765342712402344
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.995109558105469
Dropoff Latitude
40.750038146972656
Payment Type
1
Fare Amount
8
Extra
0
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-27T18:24:00.000 • Tpep Dropoff Datetime: 2016-02-27T18:31:50.000
Vendorid
1
Tpep Pickup Datetime
2016-02-27T18:24:00.000
Tpep Dropoff Datetime
2016-02-27T18:31:50.000
Passenger Count
1
Trip Distance
2.4
Pickup Longitude
-73.940742492675781
Pickup Latitude
40.808399200439453
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.966537475585937
Dropoff Latitude
40.793373107910156
Payment Type
1
Fare Amount
8.5
Extra
0
Mta Tax
0.5
Tip Amount
2.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.05
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-11T09:09:08.000 • Tpep Dropoff Datetime: 2016-02-11T09:13:51.000
Vendorid
1
Tpep Pickup Datetime
2016-02-11T09:09:08.000
Tpep Dropoff Datetime
2016-02-11T09:13:51.000
Passenger Count
1
Trip Distance
0.7
Pickup Longitude
-74.006210327148438
Pickup Latitude
40.716968536376953
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.000114440917969
Dropoff Latitude
40.726570129394531
Payment Type
1
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
1.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.25
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-21T16:27:32.000 • Tpep Dropoff Datetime: 2016-02-21T16:52:25.000
Vendorid
2
Tpep Pickup Datetime
2016-02-21T16:27:32.000
Tpep Dropoff Datetime
2016-02-21T16:52:25.000
Passenger Count
1
Trip Distance
8.01
Pickup Longitude
-73.990013122558594
Pickup Latitude
40.737831115722656
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.872550964355469
Dropoff Latitude
40.732059478759766
Payment Type
1
Fare Amount
25
Extra
0
Mta Tax
0.5
Tip Amount
7.84
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
39.18
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-01T06:44:34.000 • Tpep Dropoff Datetime: 2016-02-01T06:50:09.000
Vendorid
2
Tpep Pickup Datetime
2016-02-01T06:44:34.000
Tpep Dropoff Datetime
2016-02-01T06:50:09.000
Passenger Count
1
Trip Distance
1.16
Pickup Longitude
-73.964866638183594
Pickup Latitude
40.766910552978516
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.9783935546875
Dropoff Latitude
40.762016296386719
Payment Type
1
Fare Amount
6
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-16T11:33:21.000 • Tpep Dropoff Datetime: 2016-02-16T12:12:23.000
Vendorid
2
Tpep Pickup Datetime
2016-02-16T11:33:21.000
Tpep Dropoff Datetime
2016-02-16T12:12:23.000
Passenger Count
1
Trip Distance
3.25
Pickup Longitude
-74.000770568847656
Pickup Latitude
40.725818634033203
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.973152160644531
Dropoff Latitude
40.761089324951172
Payment Type
1
Fare Amount
23.5
Extra
0
Mta Tax
0.5
Tip Amount
4.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.16
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-19T20:48:39.000 • Tpep Dropoff Datetime: 2016-02-19T20:54:21.000
Vendorid
2
Tpep Pickup Datetime
2016-02-19T20:48:39.000
Tpep Dropoff Datetime
2016-02-19T20:54:21.000
Passenger Count
1
Trip Distance
2.29
Pickup Longitude
-73.993232727050781
Pickup Latitude
40.762668609619141
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.973838806152344
Dropoff Latitude
40.791450500488281
Payment Type
1
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.16
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-28T14:22:13.000 • Tpep Dropoff Datetime: 2016-02-28T14:35:47.000
Vendorid
1
Tpep Pickup Datetime
2016-02-28T14:22:13.000
Tpep Dropoff Datetime
2016-02-28T14:35:47.000
Passenger Count
1
Trip Distance
2.3
Pickup Longitude
-73.975868225097656
Pickup Latitude
40.780555725097656
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.959762573242188
Dropoff Latitude
40.776233673095703
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
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-04T00:00:06.000 • Tpep Dropoff Datetime: 2016-02-04T00:09:05.000
Vendorid
2
Tpep Pickup Datetime
2016-02-04T00:00:06.000
Tpep Dropoff Datetime
2016-02-04T00:09:05.000
Passenger Count
1
Trip Distance
3.17
Pickup Longitude
-73.870643615722656
Pickup Latitude
40.773605346679688
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.908721923828125
Dropoff Latitude
40.759407043457031
Payment Type
1
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-16T16:08:19.000 • Tpep Dropoff Datetime: 2016-02-16T16:13:15.000
Vendorid
2
Tpep Pickup Datetime
2016-02-16T16:08:19.000
Tpep Dropoff Datetime
2016-02-16T16:13:15.000
Passenger Count
1
Trip Distance
1.24
Pickup Longitude
-73.972457885742187
Pickup Latitude
40.786079406738281
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.983306884765625
Dropoff Latitude
40.770271301269531
Payment Type
1
Fare Amount
6
Extra
1
Mta Tax
0.5
Tip Amount
1.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.36
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-29T00:20:33.000 • Tpep Dropoff Datetime: 2016-02-29T00:25:00.000
Vendorid
2
Tpep Pickup Datetime
2016-02-29T00:20:33.000
Tpep Dropoff Datetime
2016-02-29T00:25:00.000
Passenger Count
1
Trip Distance
1.21
Pickup Longitude
-73.976173400878906
Pickup Latitude
40.765640258789063
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.970756530761719
Dropoff Latitude
40.752059936523438
Payment Type
2
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-18T15:21:47.000 • Tpep Dropoff Datetime: 2016-02-18T15:33:02.000
Vendorid
1
Tpep Pickup Datetime
2016-02-18T15:21:47.000
Tpep Dropoff Datetime
2016-02-18T15:33:02.000
Passenger Count
1
Trip Distance
1.5
Pickup Longitude
-73.99053955078125
Pickup Latitude
40.718536376953125
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.006248474121094
Dropoff Latitude
40.733810424804688
Payment Type
1
Fare Amount
9
Extra
0
Mta Tax
0.5
Tip Amount
1.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.75
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-07T10:09:18.000 • Tpep Dropoff Datetime: 2016-02-07T10:24:55.000
Vendorid
2
Tpep Pickup Datetime
2016-02-07T10:09:18.000
Tpep Dropoff Datetime
2016-02-07T10:24:55.000
Passenger Count
1
Trip Distance
4.4
Pickup Longitude
-73.991348266601563
Pickup Latitude
40.750331878662109
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.014335632324219
Dropoff Latitude
40.704269409179688
Payment Type
2
Fare Amount
16
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-01T14:18:18.000 • Tpep Dropoff Datetime: 2016-02-01T14:27:29.000
Vendorid
2
Tpep Pickup Datetime
2016-02-01T14:18:18.000
Tpep Dropoff Datetime
2016-02-01T14:27:29.000
Passenger Count
1
Trip Distance
1.15
Pickup Longitude
-73.960868835449219
Pickup Latitude
40.775119781494141
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.9486083984375
Dropoff Latitude
40.778270721435547
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: 2016-02-21T01:11:58.000 • Tpep Dropoff Datetime: 2016-02-21T01:25:46.000
Vendorid
1
Tpep Pickup Datetime
2016-02-21T01:11:58.000
Tpep Dropoff Datetime
2016-02-21T01:25:46.000
Passenger Count
3
Trip Distance
3.6
Pickup Longitude
-73.986808776855469
Pickup Latitude
40.765888214111328
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.953048706054688
Dropoff Latitude
40.807498931884766
Payment Type
2
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-21T18:16:03.000 • Tpep Dropoff Datetime: 2016-02-21T18:23:07.000
Vendorid
1
Tpep Pickup Datetime
2016-02-21T18:16:03.000
Tpep Dropoff Datetime
2016-02-21T18:23:07.000
Passenger Count
1
Trip Distance
0.9
Pickup Longitude
-73.98272705078125
Pickup Latitude
40.763111114501953
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.977546691894531
Dropoff Latitude
40.753650665283203
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
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-25T21:42:49.000 • Tpep Dropoff Datetime: 2016-02-25T21:55:44.000
Vendorid
1
Tpep Pickup Datetime
2016-02-25T21:42:49.000
Tpep Dropoff Datetime
2016-02-25T21:55:44.000
Passenger Count
2
Trip Distance
1.3
Pickup Longitude
-73.988594055175781
Pickup Latitude
40.758953094482422
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.985153198242188
Dropoff Latitude
40.7489013671875
Payment Type
2
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
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-23T14:47:10.000 • Tpep Dropoff Datetime: 2016-02-23T14:58:33.000
Vendorid
2
Tpep Pickup Datetime
2016-02-23T14:47:10.000
Tpep Dropoff Datetime
2016-02-23T14:58:33.000
Passenger Count
4
Trip Distance
2.29
Pickup Longitude
-73.986351013183594
Pickup Latitude
40.734580993652344
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.008331298828125
Dropoff Latitude
40.721351623535156
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: 2016-02-24T22:58:40.000 • Tpep Dropoff Datetime: 2016-02-24T23:01:05.000
Vendorid
2
Tpep Pickup Datetime
2016-02-24T22:58:40.000
Tpep Dropoff Datetime
2016-02-24T23:01:05.000
Passenger Count
2
Trip Distance
0.3
Pickup Longitude
-73.982391357421875
Pickup Latitude
40.772235870361328
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.982170104980469
Dropoff Latitude
40.76995849609375
Payment Type
2
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-06T19:17:56.000 • Tpep Dropoff Datetime: 2016-02-06T19:49:53.000
Vendorid
1
Tpep Pickup Datetime
2016-02-06T19:17:56.000
Tpep Dropoff Datetime
2016-02-06T19:49:53.000
Passenger Count
1
Trip Distance
6.4
Pickup Longitude
-73.993156433105469
Pickup Latitude
40.727027893066406
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.972160339355469
Dropoff Latitude
40.794158935546875
Payment Type
2
Fare Amount
25.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-27T18:44:23.000 • Tpep Dropoff Datetime: 2016-02-27T18:49:39.000
Vendorid
2
Tpep Pickup Datetime
2016-02-27T18:44:23.000
Tpep Dropoff Datetime
2016-02-27T18:49:39.000
Passenger Count
1
Trip Distance
0.9
Pickup Longitude
-73.964866638183594
Pickup Latitude
40.791557312011719
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.977203369140625
Dropoff Latitude
40.789577484130859
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: 2016-02-04T20:07:39.000 • Tpep Dropoff Datetime: 2016-02-04T20:18:22.000
Vendorid
2
Tpep Pickup Datetime
2016-02-04T20:07:39.000
Tpep Dropoff Datetime
2016-02-04T20:18:22.000
Passenger Count
2
Trip Distance
1.15
Pickup Longitude
-73.98284912109375
Pickup Latitude
40.730663299560547
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.997047424316406
Dropoff Latitude
40.72906494140625
Payment Type
2
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-23T18:22:15.000 • Tpep Dropoff Datetime: 2016-02-23T18:29:37.000
Vendorid
1
Tpep Pickup Datetime
2016-02-23T18:22:15.000
Tpep Dropoff Datetime
2016-02-23T18:29:37.000
Passenger Count
1
Trip Distance
1
Pickup Longitude
0
Pickup Latitude
0
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
0
Dropoff Latitude
0
Payment Type
1
Fare Amount
6.5
Extra
1
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-21T00:55:08.000 • Tpep Dropoff Datetime: 2016-02-21T01:02:26.000
Vendorid
1
Tpep Pickup Datetime
2016-02-21T00:55:08.000
Tpep Dropoff Datetime
2016-02-21T01:02:26.000
Passenger Count
1
Trip Distance
1.5
Pickup Longitude
-74.002349853515625
Pickup Latitude
40.739681243896484
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.98358154296875
Dropoff Latitude
40.74713134765625
Payment Type
1
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.55
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-24T12:43:43.000 • Tpep Dropoff Datetime: 2016-02-24T12:48:11.000
Vendorid
2
Tpep Pickup Datetime
2016-02-24T12:43:43.000
Tpep Dropoff Datetime
2016-02-24T12:48:11.000
Passenger Count
1
Trip Distance
0.79
Pickup Longitude
-73.945755004882813
Pickup Latitude
40.773380279541016
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.953536987304687
Dropoff Latitude
40.779678344726563
Payment Type
1
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
1.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.25
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-20T22:04:49.000 • Tpep Dropoff Datetime: 2016-02-20T22:13:13.000
Vendorid
1
Tpep Pickup Datetime
2016-02-20T22:04:49.000
Tpep Dropoff Datetime
2016-02-20T22:13:13.000
Passenger Count
1
Trip Distance
1.8
Pickup Longitude
-73.982513427734375
Pickup Latitude
40.772365570068359
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.962371826171875
Dropoff Latitude
40.776439666748047
Payment Type
2
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-08T15:06:20.000 • Tpep Dropoff Datetime: 2016-02-08T15:14:33.000
Vendorid
2
Tpep Pickup Datetime
2016-02-08T15:06:20.000
Tpep Dropoff Datetime
2016-02-08T15:14:33.000
Passenger Count
1
Trip Distance
1.75
Pickup Longitude
-73.955421447753906
Pickup Latitude
40.783031463623047
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.939056396484375
Dropoff Latitude
40.804706573486328
Payment Type
1
Fare Amount
8
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-25T21:43:47.000 • Tpep Dropoff Datetime: 2016-02-25T21:52:01.000
Vendorid
2
Tpep Pickup Datetime
2016-02-25T21:43:47.000
Tpep Dropoff Datetime
2016-02-25T21:52:01.000
Passenger Count
1
Trip Distance
1.82
Pickup Longitude
-73.967758178710937
Pickup Latitude
40.765598297119141
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.951278686523438
Dropoff Latitude
40.787700653076172
Payment Type
1
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.76
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-20T01:58:42.000 • Tpep Dropoff Datetime: 2016-02-20T02:21:49.000
Vendorid
1
Tpep Pickup Datetime
2016-02-20T01:58:42.000
Tpep Dropoff Datetime
2016-02-20T02:21:49.000
Passenger Count
1
Trip Distance
8.1
Pickup Longitude
-73.99591064453125
Pickup Latitude
40.748802185058594
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.915580749511719
Dropoff Latitude
40.819187164306641
Payment Type
2
Fare Amount
26.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-22T12:02:22.000 • Tpep Dropoff Datetime: 2016-02-22T12:29:11.000
Vendorid
2
Tpep Pickup Datetime
2016-02-22T12:02:22.000
Tpep Dropoff Datetime
2016-02-22T12:29:11.000
Passenger Count
1
Trip Distance
8.51
Pickup Longitude
-73.873023986816406
Pickup Latitude
40.774169921875
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.967765808105469
Dropoff Latitude
40.793880462646484
Payment Type
1
Fare Amount
28.5
Extra
0
Mta Tax
0.5
Tip Amount
5.06
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
39.9
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-15T14:03:11.000 • Tpep Dropoff Datetime: 2016-02-15T14:15:25.000
Vendorid
1
Tpep Pickup Datetime
2016-02-15T14:03:11.000
Tpep Dropoff Datetime
2016-02-15T14:15:25.000
Passenger Count
1
Trip Distance
2.9
Pickup Longitude
-73.993675231933594
Pickup Latitude
40.762050628662109
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.961967468261719
Dropoff Latitude
40.779232025146484
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: 2016-02-10T12:19:25.000 • Tpep Dropoff Datetime: 2016-02-10T12:28:24.000
Vendorid
2
Tpep Pickup Datetime
2016-02-10T12:19:25.000
Tpep Dropoff Datetime
2016-02-10T12:28:24.000
Passenger Count
1
Trip Distance
1.25
Pickup Longitude
-73.985687255859375
Pickup Latitude
40.757270812988281
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.997337341308594
Dropoff Latitude
40.741668701171875
Payment Type
1
Fare Amount
7.5
Extra
0
Mta Tax
0.5
Tip Amount
1.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.96
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-29T16:02:53.000 • Tpep Dropoff Datetime: 2016-02-29T16:13:20.000
Vendorid
1
Tpep Pickup Datetime
2016-02-29T16:02:53.000
Tpep Dropoff Datetime
2016-02-29T16:13:20.000
Passenger Count
1
Trip Distance
1
Pickup Longitude
-73.97210693359375
Pickup Latitude
40.763343811035156
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.978240966796875
Dropoff Latitude
40.753990173339844
Payment Type
2
Fare Amount
8
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-26T17:31:26.000 • Tpep Dropoff Datetime: 2016-02-26T17:33:05.000
Vendorid
2
Tpep Pickup Datetime
2016-02-26T17:31:26.000
Tpep Dropoff Datetime
2016-02-26T17:33:05.000
Passenger Count
1
Trip Distance
0.28
Pickup Longitude
-73.979965209960937
Pickup Latitude
40.770584106445313
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.978218078613281
Dropoff Latitude
40.77301025390625
Payment Type
2
Fare Amount
3.5
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-17T22:15:59.000 • Tpep Dropoff Datetime: 2016-02-17T22:25:38.000
Vendorid
1
Tpep Pickup Datetime
2016-02-17T22:15:59.000
Tpep Dropoff Datetime
2016-02-17T22:25:38.000
Passenger Count
1
Trip Distance
2.5
Pickup Longitude
-73.981590270996094
Pickup Latitude
40.778762817382813
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.946258544921875
Dropoff Latitude
40.772842407226563
Payment Type
1
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.55
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-11T12:34:33.000 • Tpep Dropoff Datetime: 2016-02-11T13:00:01.000
Vendorid
1
Tpep Pickup Datetime
2016-02-11T12:34:33.000
Tpep Dropoff Datetime
2016-02-11T13:00:01.000
Passenger Count
2
Trip Distance
2.4
Pickup Longitude
-73.989608764648437
Pickup Latitude
40.720638275146484
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.004806518554688
Dropoff Latitude
40.741863250732422
Payment Type
1
Fare Amount
16.5
Extra
0
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-10T15:18:13.000 • Tpep Dropoff Datetime: 2016-02-10T15:30:55.000
Vendorid
1
Tpep Pickup Datetime
2016-02-10T15:18:13.000
Tpep Dropoff Datetime
2016-02-10T15:30:55.000
Passenger Count
1
Trip Distance
1.9
Pickup Longitude
-73.991569519042969
Pickup Latitude
40.741691589355469
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.010086059570313
Dropoff Latitude
40.725601196289063
Payment Type
1
Fare Amount
9.5
Extra
0
Mta Tax
0.5
Tip Amount
2.05
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.35
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-27T15:23:12.000 • Tpep Dropoff Datetime: 2016-02-27T15:23:14.000
Vendorid
2
Tpep Pickup Datetime
2016-02-27T15:23:12.000
Tpep Dropoff Datetime
2016-02-27T15:23:14.000
Passenger Count
2
Trip Distance
0
Pickup Longitude
0
Pickup Latitude
0
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
0
Dropoff Latitude
0
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
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-15T21:19:21.000 • Tpep Dropoff Datetime: 2016-02-15T21:28:18.000
Vendorid
2
Tpep Pickup Datetime
2016-02-15T21:19:21.000
Tpep Dropoff Datetime
2016-02-15T21:28:18.000
Passenger Count
1
Trip Distance
1.57
Pickup Longitude
-74.000358581542969
Pickup Latitude
40.72552490234375
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.998573303222656
Dropoff Latitude
40.713016510009766
Payment Type
1
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.16
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-19T18:49:09.000 • Tpep Dropoff Datetime: 2016-02-19T19:15:53.000
Vendorid
1
Tpep Pickup Datetime
2016-02-19T18:49:09.000
Tpep Dropoff Datetime
2016-02-19T19:15:53.000
Passenger Count
2
Trip Distance
3.6
Pickup Longitude
-73.991424560546875
Pickup Latitude
40.749897003173828
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-74.00640869140625
Dropoff Latitude
40.708282470703125
Payment Type
1
Fare Amount
18
Extra
1
Mta Tax
0.5
Tip Amount
3.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.75
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-28T11:55:12.000 • Tpep Dropoff Datetime: 2016-02-28T12:04:19.000
Vendorid
1
Tpep Pickup Datetime
2016-02-28T11:55:12.000
Tpep Dropoff Datetime
2016-02-28T12:04:19.000
Passenger Count
1
Trip Distance
2
Pickup Longitude
-73.969978332519531
Pickup Latitude
40.768821716308594
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.973258972167969
Dropoff Latitude
40.790126800537109
Payment Type
1
Fare Amount
9
Extra
0
Mta Tax
0.5
Tip Amount
1.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.75
1
Vendorid: 1 • Tpep Pickup Datetime: 2016-02-04T12:52:17.000 • Tpep Dropoff Datetime: 2016-02-04T13:02:49.000
Vendorid
1
Tpep Pickup Datetime
2016-02-04T12:52:17.000
Tpep Dropoff Datetime
2016-02-04T13:02:49.000
Passenger Count
4
Trip Distance
2.9
Pickup Longitude
-73.975547790527344
Pickup Latitude
40.741401672363281
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.994132995605469
Dropoff Latitude
40.722984313964844
Payment Type
2
Fare Amount
11.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
2
Vendorid: 2 • Tpep Pickup Datetime: 2016-02-03T21:13:38.000 • Tpep Dropoff Datetime: 2016-02-03T21:20:39.000
Vendorid
2
Tpep Pickup Datetime
2016-02-03T21:13:38.000
Tpep Dropoff Datetime
2016-02-03T21:20:39.000
Passenger Count
5
Trip Distance
1.31
Pickup Longitude
-73.958290100097656
Pickup Latitude
40.768543243408203
Ratecodeid
1
Store And Fwd Flag
N
Dropoff Longitude
-73.97039794921875
Dropoff Latitude
40.7562255859375
Payment Type
2
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3