2015 Green Taxi Trip Data

These records are generated from the trip record submissions made by green taxi Technology Service Providers (TSPs). Each row represents a single trip in a green taxi. The trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off taxi zone locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.

Transportation Taxi and Limousine Commission (TLC) Dataset gi8d-wdg5 21 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-05T20:41:33.000 • Lpep Dropoff Datetime: 2015-01-05T21:06:58.000
Vendorid
2
Lpep Pickup Datetime
2015-01-05T20:41:33.000
Lpep Dropoff Datetime
2015-01-05T21:06:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918258666992187
Pickup Latitude
40.681781768798828
Dropoff Longitude
-73.986854553222656
Dropoff Latitude
40.701137542724609
Passenger Count
1
Trip Distance
5.71
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.2
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-25T16:37:56.000 • Lpep Dropoff Datetime: 2015-02-25T16:57:56.000
Vendorid
2
Lpep Pickup Datetime
2015-02-25T16:37:56.000
Lpep Dropoff Datetime
2015-02-25T16:57:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9892578125
Pickup Latitude
40.688533782958984
Dropoff Longitude
-73.964668273925781
Dropoff Latitude
40.715766906738281
Passenger Count
1
Trip Distance
3.43
Fare Amount
15
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-16T01:54:21.000 • Lpep Dropoff Datetime: 2015-02-16T02:03:26.000
Vendorid
2
Lpep Pickup Datetime
2015-02-16T01:54:21.000
Lpep Dropoff Datetime
2015-02-16T02:03:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955780029296875
Pickup Latitude
40.719825744628906
Dropoff Longitude
-73.931739807128906
Dropoff Latitude
40.705703735351563
Passenger Count
1
Trip Distance
2.01
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
2.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-28T14:46:11.000 • Lpep Dropoff Datetime: 2015-02-28T15:02:09.000
Vendorid
2
Lpep Pickup Datetime
2015-02-28T14:46:11.000
Lpep Dropoff Datetime
2015-02-28T15:02:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936470031738281
Pickup Latitude
40.820346832275391
Dropoff Longitude
-73.94140625
Dropoff Latitude
40.799106597900391
Passenger Count
1
Trip Distance
1.85
Fare Amount
11.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-23T14:26:27.000 • Lpep Dropoff Datetime: 2015-02-23T14:39:02.000
Vendorid
2
Lpep Pickup Datetime
2015-02-23T14:26:27.000
Lpep Dropoff Datetime
2015-02-23T14:39:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991493225097656
Pickup Latitude
40.689449310302734
Dropoff Longitude
-73.963996887207031
Dropoff Latitude
40.686763763427734
Passenger Count
1
Trip Distance
1.68
Fare Amount
9.5
Extra
0
Mta Tax
0.5
Tip Amount
2.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.36
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-01-01T05:42:51.000 • Lpep Dropoff Datetime: 2015-01-01T05:49:43.000
Vendorid
1
Lpep Pickup Datetime
2015-01-01T05:42:51.000
Lpep Dropoff Datetime
2015-01-01T05:49:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957374572753906
Pickup Latitude
40.677127838134766
Dropoff Longitude
-73.931022644042969
Dropoff Latitude
40.677436828613281
Passenger Count
3
Trip Distance
1.7
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-13T11:39:19.000 • Lpep Dropoff Datetime: 2015-01-13T12:02:27.000
Vendorid
2
Lpep Pickup Datetime
2015-01-13T11:39:19.000
Lpep Dropoff Datetime
2015-01-13T12:02:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992530822753906
Pickup Latitude
40.694038391113281
Dropoff Longitude
-73.960098266601563
Dropoff Latitude
40.763786315917969
Passenger Count
1
Trip Distance
7.59
Fare Amount
25.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-28T22:10:46.000 • Lpep Dropoff Datetime: 2015-02-28T22:17:27.000
Vendorid
1
Lpep Pickup Datetime
2015-02-28T22:10:46.000
Lpep Dropoff Datetime
2015-02-28T22:17:27.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.832443237304688
Pickup Latitude
40.806339263916016
Dropoff Longitude
-73.81976318359375
Dropoff Latitude
40.818035125732422
Passenger Count
1
Trip Distance
2.5
Fare Amount
20
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
5.33
Improvement Surcharge
0.3
Total Amount
25.63
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-22T18:05:02.000 • Lpep Dropoff Datetime: 2015-02-22T18:13:17.000
Vendorid
2
Lpep Pickup Datetime
2015-02-22T18:05:02.000
Lpep Dropoff Datetime
2015-02-22T18:13:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9498291015625
Pickup Latitude
40.801765441894531
Dropoff Longitude
-73.967933654785156
Dropoff Latitude
40.799751281738281
Passenger Count
2
Trip Distance
1.47
Fare Amount
7.5
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-24T18:19:42.000 • Lpep Dropoff Datetime: 2015-01-24T18:31:43.000
Vendorid
2
Lpep Pickup Datetime
2015-01-24T18:19:42.000
Lpep Dropoff Datetime
2015-01-24T18:31:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962196350097656
Pickup Latitude
40.709884643554687
Dropoff Longitude
-73.928047180175781
Dropoff Latitude
40.70489501953125
Passenger Count
1
Trip Distance
2.05
Fare Amount
10
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-05T19:29:09.000 • Lpep Dropoff Datetime: 2015-01-05T19:36:10.000
Vendorid
2
Lpep Pickup Datetime
2015-01-05T19:29:09.000
Lpep Dropoff Datetime
2015-01-05T19:36:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942550659179688
Pickup Latitude
40.725208282470703
Dropoff Longitude
-73.947273254394531
Dropoff Latitude
40.711460113525391
Passenger Count
1
Trip Distance
1.27
Fare Amount
6.5
Extra
1
Mta Tax
0.5
Tip Amount
1.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-22T16:16:45.000 • Lpep Dropoff Datetime: 2015-02-22T16:32:53.000
Vendorid
2
Lpep Pickup Datetime
2015-02-22T16:16:45.000
Lpep Dropoff Datetime
2015-02-22T16:32:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993003845214844
Pickup Latitude
40.688575744628906
Dropoff Longitude
-73.948417663574219
Dropoff Latitude
40.718467712402344
Passenger Count
1
Trip Distance
4.06
Fare Amount
16
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-05T07:32:35.000 • Lpep Dropoff Datetime: 2015-02-05T07:44:57.000
Vendorid
2
Lpep Pickup Datetime
2015-02-05T07:32:35.000
Lpep Dropoff Datetime
2015-02-05T07:44:57.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.87237548828125
Pickup Latitude
40.8291015625
Dropoff Longitude
-73.883209228515625
Dropoff Latitude
40.840621948242188
Passenger Count
3
Trip Distance
1.36
Fare Amount
7
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
7
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-15T22:56:40.000 • Lpep Dropoff Datetime: 2015-01-15T23:09:36.000
Vendorid
2
Lpep Pickup Datetime
2015-01-15T22:56:40.000
Lpep Dropoff Datetime
2015-01-15T23:09:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990402221679688
Pickup Latitude
40.693435668945313
Dropoff Longitude
-74.030364990234375
Dropoff Latitude
40.618160247802734
Passenger Count
2
Trip Distance
6.95
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
5.38
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.68
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-04T20:54:17.000 • Lpep Dropoff Datetime: 2015-02-04T20:57:42.000
Vendorid
2
Lpep Pickup Datetime
2015-02-04T20:54:17.000
Lpep Dropoff Datetime
2015-02-04T20:57:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986076354980469
Pickup Latitude
40.669395446777344
Dropoff Longitude
-73.988090515136719
Dropoff Latitude
40.674961090087891
Passenger Count
1
Trip Distance
0.54
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-14T19:09:46.000 • Lpep Dropoff Datetime: 2015-02-14T19:21:37.000
Vendorid
2
Lpep Pickup Datetime
2015-02-14T19:09:46.000
Lpep Dropoff Datetime
2015-02-14T19:21:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.869056701660156
Pickup Latitude
40.748466491699219
Dropoff Longitude
-73.885162353515625
Dropoff Latitude
40.738628387451172
Passenger Count
1
Trip Distance
2
Fare Amount
10
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-05T21:31:47.000 • Lpep Dropoff Datetime: 2015-02-05T22:02:23.000
Vendorid
2
Lpep Pickup Datetime
2015-02-05T21:31:47.000
Lpep Dropoff Datetime
2015-02-05T22:02:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.99517822265625
Pickup Latitude
40.690479278564453
Dropoff Longitude
-73.910835266113281
Dropoff Latitude
40.65289306640625
Passenger Count
1
Trip Distance
6.47
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-13T23:16:20.000 • Lpep Dropoff Datetime: 2015-02-13T23:20:36.000
Vendorid
1
Lpep Pickup Datetime
2015-02-13T23:16:20.000
Lpep Dropoff Datetime
2015-02-13T23:20:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953643798828125
Pickup Latitude
40.710659027099609
Dropoff Longitude
-73.952194213867188
Dropoff Latitude
40.717567443847656
Passenger Count
2
Trip Distance
0.5
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-03T16:27:11.000 • Lpep Dropoff Datetime: 2015-02-03T16:45:17.000
Vendorid
2
Lpep Pickup Datetime
2015-02-03T16:27:11.000
Lpep Dropoff Datetime
2015-02-03T16:45:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96240234375
Pickup Latitude
40.805095672607422
Dropoff Longitude
-73.997932434082031
Dropoff Latitude
40.754032135009766
Passenger Count
1
Trip Distance
5.16
Fare Amount
18.5
Extra
1
Mta Tax
0.5
Tip Amount
4.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-10T18:54:39.000 • Lpep Dropoff Datetime: 2015-02-10T19:01:53.000
Vendorid
2
Lpep Pickup Datetime
2015-02-10T18:54:39.000
Lpep Dropoff Datetime
2015-02-10T19:01:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936775207519531
Pickup Latitude
40.849105834960938
Dropoff Longitude
-73.944404602050781
Dropoff Latitude
40.834880828857422
Passenger Count
1
Trip Distance
1.01
Fare Amount
7
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-01-12T14:02:34.000 • Lpep Dropoff Datetime: 2015-01-12T14:47:28.000
Vendorid
1
Lpep Pickup Datetime
2015-01-12T14:02:34.000
Lpep Dropoff Datetime
2015-01-12T14:47:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9171142578125
Pickup Latitude
40.815971374511719
Dropoff Longitude
-73.915817260742188
Dropoff Latitude
40.815223693847656
Passenger Count
1
Trip Distance
5.5
Fare Amount
30
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-17T09:27:57.000 • Lpep Dropoff Datetime: 2015-02-17T09:43:59.000
Vendorid
2
Lpep Pickup Datetime
2015-02-17T09:27:57.000
Lpep Dropoff Datetime
2015-02-17T09:43:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960891723632812
Pickup Latitude
40.806968688964844
Dropoff Longitude
-73.942710876464844
Dropoff Latitude
40.841171264648438
Passenger Count
1
Trip Distance
2.97
Fare Amount
13.5
Extra
0
Mta Tax
0.5
Tip Amount
3.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.88
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-21T20:39:17.000 • Lpep Dropoff Datetime: 2015-02-21T20:49:53.000
Vendorid
1
Lpep Pickup Datetime
2015-02-21T20:39:17.000
Lpep Dropoff Datetime
2015-02-21T20:49:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923233032226562
Pickup Latitude
40.678970336914063
Dropoff Longitude
-73.938156127929688
Dropoff Latitude
40.682403564453125
Passenger Count
1
Trip Distance
1.1
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-26T10:25:24.000 • Lpep Dropoff Datetime: 2015-02-26T10:40:16.000
Vendorid
2
Lpep Pickup Datetime
2015-02-26T10:25:24.000
Lpep Dropoff Datetime
2015-02-26T10:40:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991119384765625
Pickup Latitude
40.692386627197266
Dropoff Longitude
-73.983283996582031
Dropoff Latitude
40.666904449462891
Passenger Count
1
Trip Distance
2.49
Fare Amount
11.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-27T18:12:52.000 • Lpep Dropoff Datetime: 2015-02-27T18:56:03.000
Vendorid
2
Lpep Pickup Datetime
2015-02-27T18:12:52.000
Lpep Dropoff Datetime
2015-02-27T18:56:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.862884521484375
Pickup Latitude
40.865615844726562
Dropoff Longitude
-73.922561645507812
Dropoff Latitude
40.820560455322266
Passenger Count
1
Trip Distance
6.6
Fare Amount
30
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-08T19:32:26.000 • Lpep Dropoff Datetime: 2015-02-08T19:41:57.000
Vendorid
2
Lpep Pickup Datetime
2015-02-08T19:32:26.000
Lpep Dropoff Datetime
2015-02-08T19:41:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940505981445313
Pickup Latitude
40.793277740478516
Dropoff Longitude
-73.923332214355469
Dropoff Latitude
40.794017791748047
Passenger Count
1
Trip Distance
1.66
Fare Amount
8
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-01-07T11:23:48.000 • Lpep Dropoff Datetime: 2015-01-07T11:45:44.000
Vendorid
1
Lpep Pickup Datetime
2015-01-07T11:23:48.000
Lpep Dropoff Datetime
2015-01-07T11:45:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939254760742187
Pickup Latitude
40.679885864257812
Dropoff Longitude
-73.96661376953125
Dropoff Latitude
40.637893676757813
Passenger Count
1
Trip Distance
4.3
Fare Amount
18
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-06T19:40:05.000 • Lpep Dropoff Datetime: 2015-02-06T19:46:40.000
Vendorid
2
Lpep Pickup Datetime
2015-02-06T19:40:05.000
Lpep Dropoff Datetime
2015-02-06T19:46:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942413330078125
Pickup Latitude
40.828426361083984
Dropoff Longitude
-73.943717956542969
Dropoff Latitude
40.838340759277344
Passenger Count
1
Trip Distance
1.18
Fare Amount
6.5
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-28T12:04:58.000 • Lpep Dropoff Datetime: 2015-02-28T12:09:19.000
Vendorid
1
Lpep Pickup Datetime
2015-02-28T12:04:58.000
Lpep Dropoff Datetime
2015-02-28T12:09:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952835083007813
Pickup Latitude
40.810810089111328
Dropoff Longitude
-73.952484130859375
Dropoff Latitude
40.803459167480469
Passenger Count
1
Trip Distance
0.6
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-01T06:05:12.000 • Lpep Dropoff Datetime: 2015-02-01T06:23:15.000
Vendorid
1
Lpep Pickup Datetime
2015-02-01T06:05:12.000
Lpep Dropoff Datetime
2015-02-01T06:23:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902633666992188
Pickup Latitude
40.741550445556641
Dropoff Longitude
-73.952491760253906
Dropoff Latitude
40.772319793701172
Passenger Count
1
Trip Distance
4.9
Fare Amount
18.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-05T10:55:55.000 • Lpep Dropoff Datetime: 2015-02-05T11:20:55.000
Vendorid
1
Lpep Pickup Datetime
2015-02-05T10:55:55.000
Lpep Dropoff Datetime
2015-02-05T11:20:55.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.956344604492188
Pickup Latitude
40.747673034667969
Dropoff Longitude
-73.980018615722656
Dropoff Latitude
40.755638122558594
Passenger Count
1
Trip Distance
3.2
Fare Amount
17
Extra
0
Mta Tax
0.5
Tip Amount
4.6
Tolls Amount
5.33
Improvement Surcharge
0.3
Total Amount
27.73
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-25T00:02:28.000 • Lpep Dropoff Datetime: 2015-02-25T00:24:25.000
Vendorid
1
Lpep Pickup Datetime
2015-02-25T00:02:28.000
Lpep Dropoff Datetime
2015-02-25T00:24:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.858711242675781
Pickup Latitude
40.692485809326172
Dropoff Longitude
-73.921188354492188
Dropoff Latitude
40.756240844726563
Passenger Count
1
Trip Distance
7.4
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-01T01:10:03.000 • Lpep Dropoff Datetime: 2015-02-01T01:14:07.000
Vendorid
2
Lpep Pickup Datetime
2015-02-01T01:10:03.000
Lpep Dropoff Datetime
2015-02-01T01:14:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956764221191406
Pickup Latitude
40.67413330078125
Dropoff Longitude
-73.947158813476562
Dropoff Latitude
40.675411224365234
Passenger Count
3
Trip Distance
0.91
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-14T17:17:18.000 • Lpep Dropoff Datetime: 2015-02-14T17:52:46.000
Vendorid
2
Lpep Pickup Datetime
2015-02-14T17:17:18.000
Lpep Dropoff Datetime
2015-02-14T17:52:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917884826660156
Pickup Latitude
40.742340087890625
Dropoff Longitude
-73.898880004882813
Dropoff Latitude
40.746479034423828
Passenger Count
1
Trip Distance
2.12
Fare Amount
20.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-01-29T02:14:37.000 • Lpep Dropoff Datetime: 2015-01-29T02:36:33.000
Vendorid
1
Lpep Pickup Datetime
2015-01-29T02:14:37.000
Lpep Dropoff Datetime
2015-01-29T02:36:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986442565917969
Pickup Latitude
40.692493438720703
Dropoff Longitude
-73.987907409667969
Dropoff Latitude
40.770038604736328
Passenger Count
2
Trip Distance
6.1
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
6.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.95
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-31T17:08:15.000 • Lpep Dropoff Datetime: 2015-01-31T17:12:48.000
Vendorid
2
Lpep Pickup Datetime
2015-01-31T17:08:15.000
Lpep Dropoff Datetime
2015-01-31T17:12:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953887939453125
Pickup Latitude
40.787181854248047
Dropoff Longitude
-73.946685791015625
Dropoff Latitude
40.78228759765625
Passenger Count
1
Trip Distance
0.61
Fare Amount
5
Extra
0
Mta Tax
0.5
Tip Amount
1.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-21T00:09:11.000 • Lpep Dropoff Datetime: 2015-02-21T00:26:06.000
Vendorid
2
Lpep Pickup Datetime
2015-02-21T00:09:11.000
Lpep Dropoff Datetime
2015-02-21T00:26:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959205627441406
Pickup Latitude
40.7164306640625
Dropoff Longitude
-73.902626037597656
Dropoff Latitude
40.704307556152344
Passenger Count
1
Trip Distance
3.62
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0.01
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.81
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-06T21:20:32.000 • Lpep Dropoff Datetime: 2015-01-06T21:26:07.000
Vendorid
2
Lpep Pickup Datetime
2015-01-06T21:20:32.000
Lpep Dropoff Datetime
2015-01-06T21:26:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922149658203125
Pickup Latitude
40.755233764648437
Dropoff Longitude
-73.918701171875
Dropoff Latitude
40.743503570556641
Passenger Count
1
Trip Distance
1.09
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-04T11:44:03.000 • Lpep Dropoff Datetime: 2015-02-04T11:54:38.000
Vendorid
2
Lpep Pickup Datetime
2015-02-04T11:44:03.000
Lpep Dropoff Datetime
2015-02-04T11:54:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.888595581054687
Pickup Latitude
40.826335906982422
Dropoff Longitude
-73.867210388183594
Dropoff Latitude
40.837303161621094
Passenger Count
1
Trip Distance
1.72
Fare Amount
9
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-03T10:54:09.000 • Lpep Dropoff Datetime: 2015-02-03T11:00:19.000
Vendorid
2
Lpep Pickup Datetime
2015-02-03T10:54:09.000
Lpep Dropoff Datetime
2015-02-03T11:00:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91900634765625
Pickup Latitude
40.838386535644531
Dropoff Longitude
-73.912513732910156
Dropoff Latitude
40.842479705810547
Passenger Count
1
Trip Distance
0.66
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-07T20:18:26.000 • Lpep Dropoff Datetime: 2015-02-07T20:25:01.000
Vendorid
2
Lpep Pickup Datetime
2015-02-07T20:18:26.000
Lpep Dropoff Datetime
2015-02-07T20:25:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915077209472656
Pickup Latitude
40.752063751220703
Dropoff Longitude
-73.910934448242188
Dropoff Latitude
40.745719909667969
Passenger Count
1
Trip Distance
1.01
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-03T17:36:39.000 • Lpep Dropoff Datetime: 2015-01-03T17:40:05.000
Vendorid
2
Lpep Pickup Datetime
2015-01-03T17:36:39.000
Lpep Dropoff Datetime
2015-01-03T17:40:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957588195800781
Pickup Latitude
40.729690551757813
Dropoff Longitude
-73.95648193359375
Dropoff Latitude
40.720806121826172
Passenger Count
2
Trip Distance
0.73
Fare Amount
4.5
Extra
0
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-22T04:25:33.000 • Lpep Dropoff Datetime: 2015-02-22T04:35:18.000
Vendorid
2
Lpep Pickup Datetime
2015-02-22T04:25:33.000
Lpep Dropoff Datetime
2015-02-22T04:35:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882766723632813
Pickup Latitude
40.747848510742187
Dropoff Longitude
-73.867095947265625
Dropoff Latitude
40.736118316650391
Passenger Count
1
Trip Distance
1.62
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
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-25T22:11:17.000 • Lpep Dropoff Datetime: 2015-02-25T22:21:39.000
Vendorid
1
Lpep Pickup Datetime
2015-02-25T22:11:17.000
Lpep Dropoff Datetime
2015-02-25T22:21:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882308959960937
Pickup Latitude
40.747943878173828
Dropoff Longitude
-73.872749328613281
Dropoff Latitude
40.727241516113281
Passenger Count
1
Trip Distance
1.9
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-19T20:00:05.000 • Lpep Dropoff Datetime: 2015-02-19T20:22:41.000
Vendorid
2
Lpep Pickup Datetime
2015-02-19T20:00:05.000
Lpep Dropoff Datetime
2015-02-19T20:22:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.888595581054687
Pickup Latitude
40.743442535400391
Dropoff Longitude
-73.82818603515625
Dropoff Latitude
40.755294799804688
Passenger Count
1
Trip Distance
4.08
Fare Amount
17
Extra
1
Mta Tax
0.5
Tip Amount
3.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-22T13:29:58.000 • Lpep Dropoff Datetime: 2015-02-22T13:37:47.000
Vendorid
2
Lpep Pickup Datetime
2015-02-22T13:29:58.000
Lpep Dropoff Datetime
2015-02-22T13:37:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952377319335938
Pickup Latitude
40.792636871337891
Dropoff Longitude
-73.981208801269531
Dropoff Latitude
40.781513214111328
Passenger Count
1
Trip Distance
2.34
Fare Amount
9
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-23T03:03:34.000 • Lpep Dropoff Datetime: 2015-02-23T03:18:16.000
Vendorid
2
Lpep Pickup Datetime
2015-02-23T03:03:34.000
Lpep Dropoff Datetime
2015-02-23T03:18:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960113525390625
Pickup Latitude
40.718391418457031
Dropoff Longitude
-73.983711242675781
Dropoff Latitude
40.722991943359375
Passenger Count
1
Trip Distance
3.71
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-28T17:56:50.000 • Lpep Dropoff Datetime: 2015-02-28T18:11:49.000
Vendorid
2
Lpep Pickup Datetime
2015-02-28T17:56:50.000
Lpep Dropoff Datetime
2015-02-28T18:11:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969337463378906
Pickup Latitude
40.686290740966797
Dropoff Longitude
-74.003639221191406
Dropoff Latitude
40.722122192382813
Passenger Count
1
Trip Distance
3.55
Fare Amount
14
Extra
0
Mta Tax
0.5
Tip Amount
2.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.76
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-01-02T20:28:12.000 • Lpep Dropoff Datetime: 2015-01-02T20:32:38.000
Vendorid
1
Lpep Pickup Datetime
2015-01-02T20:28:12.000
Lpep Dropoff Datetime
2015-01-02T20:32:38.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.944847106933594
Pickup Latitude
40.80853271484375
Dropoff Longitude
-73.93505859375
Dropoff Latitude
40.816032409667969
Passenger Count
1
Trip Distance
0.9
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-08T10:13:35.000 • Lpep Dropoff Datetime: 2015-02-08T10:37:29.000
Vendorid
2
Lpep Pickup Datetime
2015-02-08T10:13:35.000
Lpep Dropoff Datetime
2015-02-08T10:37:29.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.898605346679687
Pickup Latitude
40.830280303955078
Dropoff Longitude
-73.966079711914063
Dropoff Latitude
40.795661926269531
Passenger Count
1
Trip Distance
9
Fare Amount
20
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
20
Payment Type
2
Trip Type
2