2016 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 hvrh-b6nb 23 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:57.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:05.000
Lpep Dropoff Datetime
2016-01-01T01:03:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949073791503906
Pickup Latitude
40.828479766845703
Dropoff Longitude
-73.922599792480469
Dropoff Latitude
40.765411376953125
Passenger Count
2
Trip Distance
5.90
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
26.34
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:26.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:01.000
Lpep Dropoff Datetime
2016-01-01T00:57:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909942626953125
Pickup Latitude
40.846221923828125
Dropoff Longitude
-73.895027160644531
Dropoff Latitude
40.847702026367188
Passenger Count
1
Trip Distance
1.50
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:42.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:54.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:42.000
Lpep Dropoff Datetime
2016-01-01T00:56:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949958801269531
Pickup Latitude
40.717533111572266
Dropoff Longitude
-73.970314025878906
Dropoff Latitude
40.689506530761719
Passenger Count
1
Trip Distance
2.50
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
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:08.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:50.000
Lpep Dropoff Datetime
2016-01-01T00:52:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.852371215820312
Pickup Latitude
40.726215362548828
Dropoff Longitude
-73.849830627441406
Dropoff Latitude
40.729373931884766
Passenger Count
1
Trip Distance
0.90
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:01.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:48.000
Lpep Dropoff Datetime
2016-01-01T01:01:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943046569824219
Pickup Latitude
40.706478118896484
Dropoff Longitude
-73.964805603027344
Dropoff Latitude
40.684524536132812
Passenger Count
1
Trip Distance
2.60
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:05:20.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:01.000
Lpep Dropoff Datetime
2016-01-01T01:05:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919677734375
Pickup Latitude
40.759166717529297
Dropoff Longitude
-73.818717956542969
Dropoff Latitude
40.762832641601563
Passenger Count
1
Trip Distance
6.60
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:04:37.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:52.000
Lpep Dropoff Datetime
2016-01-01T01:04:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964485168457031
Pickup Latitude
40.683025360107422
Dropoff Longitude
-73.981826782226563
Dropoff Latitude
40.719375610351562
Passenger Count
1
Trip Distance
4.20
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
4.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.85
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:49.000
Lpep Dropoff Datetime
2016-01-01T01:07:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.984512329101563
Pickup Latitude
40.671394348144531
Dropoff Longitude
-74.019523620605469
Dropoff Latitude
40.630653381347656
Passenger Count
1
Trip Distance
4.20
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:15:08.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:05.000
Lpep Dropoff Datetime
2016-01-01T01:15:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946159362792969
Pickup Latitude
40.720394134521484
Dropoff Longitude
-73.953567504882813
Dropoff Latitude
40.757801055908203
Passenger Count
2
Trip Distance
7.90
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:51.000
Lpep Dropoff Datetime
2016-01-01T01:09:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938674926757812
Pickup Latitude
40.685894012451172
Dropoff Longitude
-73.959266662597656
Dropoff Latitude
40.657249450683594
Passenger Count
1
Trip Distance
3.80
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
3.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:05:18.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:48.000
Lpep Dropoff Datetime
2016-01-01T01:05:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.996437072753906
Pickup Latitude
40.690692901611328
Dropoff Longitude
-73.988014221191406
Dropoff Latitude
40.65972900390625
Passenger Count
2
Trip Distance
3.20
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:43.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:46.000
Lpep Dropoff Datetime
2016-01-01T00:50:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976448059082031
Pickup Latitude
40.673126220703125
Dropoff Longitude
-73.988082885742187
Dropoff Latitude
40.663066864013672
Passenger Count
1
Trip Distance
1.10
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:53:48.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:41.000
Lpep Dropoff Datetime
2016-01-01T00:53:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957275390625
Pickup Latitude
40.712032318115234
Dropoff Longitude
-73.95770263671875
Dropoff Latitude
40.722114562988281
Passenger Count
1
Trip Distance
0.90
Fare Amount
7
Extra
0.5
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: 2016-01-01T00:45:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:14:29.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:38.000
Lpep Dropoff Datetime
2016-01-01T01:14:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.978080749511719
Pickup Latitude
40.684650421142578
Dropoff Longitude
-73.972915649414063
Dropoff Latitude
40.755805969238281
Passenger Count
2
Trip Distance
8.30
Fare Amount
28.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.75
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:36.000
Lpep Dropoff Datetime
2016-01-01T00:52:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941375732421875
Pickup Latitude
40.68487548828125
Dropoff Longitude
-73.956718444824219
Dropoff Latitude
40.675144195556641
Passenger Count
1
Trip Distance
1.40
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.56
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:49:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:07.000
Lpep Dropoff Datetime
2016-01-01T00:49:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952781677246094
Pickup Latitude
40.789005279541016
Dropoff Longitude
-73.949134826660156
Dropoff Latitude
40.781379699707031
Passenger Count
1
Trip Distance
0.60
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:59:42.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:33.000
Lpep Dropoff Datetime
2016-01-01T00:59:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.001899719238281
Pickup Latitude
40.649127960205078
Dropoff Longitude
-73.959617614746094
Dropoff Latitude
40.637260437011719
Passenger Count
1
Trip Distance
2.80
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:55.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:56.000
Lpep Dropoff Datetime
2016-01-01T00:58:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954811096191406
Pickup Latitude
40.732311248779297
Dropoff Longitude
-73.988792419433594
Dropoff Latitude
40.722282409667969
Passenger Count
2
Trip Distance
4.10
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
3.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:48:01.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:02.000
Lpep Dropoff Datetime
2016-01-01T00:48:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933158874511719
Pickup Latitude
40.753704071044922
Dropoff Longitude
-73.939163208007812
Dropoff Latitude
40.75054931640625
Passenger Count
1
Trip Distance
0.50
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:19.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:30.000
Lpep Dropoff Datetime
2016-01-01T00:56:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96026611328125
Pickup Latitude
40.690471649169922
Dropoff Longitude
-73.982147216796875
Dropoff Latitude
40.686958312988281
Passenger Count
3
Trip Distance
1.90
Fare Amount
9.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.15
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.95
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:58.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:04.000
Lpep Dropoff Datetime
2016-01-01T01:08:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98223876953125
Pickup Latitude
40.676315307617187
Dropoff Longitude
-73.979400634765625
Dropoff Latitude
40.735454559326172
Passenger Count
1
Trip Distance
6.70
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
4.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.85
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:33.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:23.000
Lpep Dropoff Datetime
2016-01-01T00:56:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942436218261719
Pickup Latitude
40.812095642089844
Dropoff Longitude
-73.966567993164063
Dropoff Latitude
40.801689147949219
Passenger Count
1
Trip Distance
2.00
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
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:46:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:32.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:46:19.000
Lpep Dropoff Datetime
2016-01-01T00:57:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956718444824219
Pickup Latitude
40.686283111572266
Dropoff Longitude
-73.983657836914063
Dropoff Latitude
40.695899963378906
Passenger Count
1
Trip Distance
2.10
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
3.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.65
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:54.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:13.000
Lpep Dropoff Datetime
2016-01-01T00:57:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958282470703125
Pickup Latitude
40.717414855957031
Dropoff Longitude
-73.975692749023438
Dropoff Latitude
40.686832427978516
Passenger Count
1
Trip Distance
3.90
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
4
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:18.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:35.000
Lpep Dropoff Datetime
2016-01-01T01:00:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917350769042969
Pickup Latitude
40.816322326660156
Dropoff Longitude
-73.940116882324219
Dropoff Latitude
40.833610534667969
Passenger Count
1
Trip Distance
2.70
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:38.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:10.000
Lpep Dropoff Datetime
2016-01-01T01:17:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940834045410156
Pickup Latitude
40.583751678466797
Dropoff Longitude
-73.921302795410156
Dropoff Latitude
40.589225769042969
Passenger Count
1
Trip Distance
6.70
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:03.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:05.000
Lpep Dropoff Datetime
2016-01-01T00:50:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922149658203125
Pickup Latitude
40.771053314208984
Dropoff Longitude
-73.921516418457031
Dropoff Latitude
40.762699127197266
Passenger Count
1
Trip Distance
0.90
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:53:17.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:59.000
Lpep Dropoff Datetime
2016-01-01T00:53:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.984184265136719
Pickup Latitude
40.671630859375
Dropoff Longitude
-73.985374450683594
Dropoff Latitude
40.66107177734375
Passenger Count
1
Trip Distance
1.70
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
2.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.05
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:15.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:15.000
Lpep Dropoff Datetime
2016-01-01T00:57:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908065795898437
Pickup Latitude
40.772384643554688
Dropoff Longitude
-73.895668029785156
Dropoff Latitude
40.729068756103516
Passenger Count
1
Trip Distance
3.50
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:19.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:50.000
Lpep Dropoff Datetime
2016-01-01T00:57:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9576416015625
Pickup Latitude
40.717922210693359
Dropoff Longitude
-73.983184814453125
Dropoff Latitude
40.696201324462891
Passenger Count
1
Trip Distance
3.20
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.85
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:49:37.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:18.000
Lpep Dropoff Datetime
2016-01-01T00:49:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.843643188476563
Pickup Latitude
40.721897125244141
Dropoff Longitude
-73.848114013671875
Dropoff Latitude
40.735221862792969
Passenger Count
1
Trip Distance
1.00
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:08.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:49.000
Lpep Dropoff Datetime
2016-01-01T01:00:08.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.860748291015625
Pickup Latitude
40.833484649658203
Dropoff Longitude
-73.94378662109375
Dropoff Latitude
40.788700103759766
Passenger Count
2
Trip Distance
6.70
Fare Amount
25
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
25
Payment Type
2
Trip Type
2
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:53:21.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:41.000
Lpep Dropoff Datetime
2016-01-01T00:53:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922317504882813
Pickup Latitude
40.707107543945313
Dropoff Longitude
-73.947113037109375
Dropoff Latitude
40.719688415527344
Passenger Count
1
Trip Distance
2.20
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:25.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:19.000
Lpep Dropoff Datetime
2016-01-01T00:52:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909332275390625
Pickup Latitude
40.815498352050781
Dropoff Longitude
-73.930549621582031
Dropoff Latitude
40.812076568603516
Passenger Count
1
Trip Distance
1.90
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:53:52.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:50.000
Lpep Dropoff Datetime
2016-01-01T00:53:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922813415527344
Pickup Latitude
40.767528533935547
Dropoff Longitude
-73.915168762207031
Dropoff Latitude
40.757106781005859
Passenger Count
1
Trip Distance
1.40
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
2.75
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.05
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:16:33.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:29.000
Lpep Dropoff Datetime
2016-01-01T01:16:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977310180664063
Pickup Latitude
40.683841705322266
Dropoff Longitude
-73.927810668945313
Dropoff Latitude
40.590503692626953
Passenger Count
1
Trip Distance
8.10
Fare Amount
28.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:49:01.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:43.000
Lpep Dropoff Datetime
2016-01-01T00:49:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.006683349609375
Pickup Latitude
40.648540496826172
Dropoff Longitude
-73.994392395019531
Dropoff Latitude
40.660362243652344
Passenger Count
1
Trip Distance
1.10
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:50:14.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:27.000
Lpep Dropoff Datetime
2016-01-01T00:50:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.930267333984375
Pickup Latitude
40.758663177490234
Dropoff Longitude
-73.919998168945313
Dropoff Latitude
40.766246795654297
Passenger Count
1
Trip Distance
0.90
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:16.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:40.000
Lpep Dropoff Datetime
2016-01-01T01:08:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919685363769531
Pickup Latitude
40.759197235107422
Dropoff Longitude
-73.861679077148438
Dropoff Latitude
40.737815856933594
Passenger Count
1
Trip Distance
4.90
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:45:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:52:04.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:45:39.000
Lpep Dropoff Datetime
2016-01-01T00:52:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956558227539063
Pickup Latitude
40.718891143798828
Dropoff Longitude
-73.958602905273437
Dropoff Latitude
40.712837219238281
Passenger Count
1
Trip Distance
0.80
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:47:02.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:22.000
Lpep Dropoff Datetime
2016-01-01T00:47:02.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.90325927734375
Pickup Latitude
40.745697021484375
Dropoff Longitude
-73.908027648925781
Dropoff Latitude
40.738601684570313
Passenger Count
1
Trip Distance
0.70
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:49:00.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:23.000
Lpep Dropoff Datetime
2016-01-01T00:49:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968284606933594
Pickup Latitude
40.679195404052734
Dropoff Longitude
-73.964576721191406
Dropoff Latitude
40.687751770019531
Passenger Count
1
Trip Distance
0.90
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.16
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:11.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:23.000
Lpep Dropoff Datetime
2016-01-01T00:56:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.904037475585938
Pickup Latitude
40.864360809326172
Dropoff Longitude
-73.917205810546875
Dropoff Latitude
40.835281372070313
Passenger Count
1
Trip Distance
2.70
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:22.000 • Lpep Dropoff Datetime: 2016-01-01T02:00:19.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:22.000
Lpep Dropoff Datetime
2016-01-01T02:00:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959709167480469
Pickup Latitude
40.688217163085938
Dropoff Longitude
-73.990455627441406
Dropoff Latitude
40.699993133544922
Passenger Count
1
Trip Distance
16.30
Fare Amount
60
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
61.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:44.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:22.000
Lpep Dropoff Datetime
2016-01-01T01:10:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947044372558594
Pickup Latitude
40.747196197509766
Dropoff Longitude
-73.929412841796875
Dropoff Latitude
40.697788238525391
Passenger Count
2
Trip Distance
4.60
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
4.25
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.55
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:53:41.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:17.000
Lpep Dropoff Datetime
2016-01-01T00:53:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990753173828125
Pickup Latitude
40.699783325195313
Dropoff Longitude
-73.999610900878906
Dropoff Latitude
40.717884063720703
Passenger Count
2
Trip Distance
2.30
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:10.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:14.000
Lpep Dropoff Datetime
2016-01-01T00:57:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949928283691406
Pickup Latitude
40.680339813232422
Dropoff Longitude
-73.983650207519531
Dropoff Latitude
40.683189392089844
Passenger Count
1
Trip Distance
2.20
Fare Amount
11
Extra
0
Mta Tax
0.5
Tip Amount
2.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:51:22.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:13.000
Lpep Dropoff Datetime
2016-01-01T00:51:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.799964904785156
Pickup Latitude
40.702709197998047
Dropoff Longitude
-73.784492492675781
Dropoff Latitude
40.696243286132812
Passenger Count
4
Trip Distance
1.30
Fare Amount
7
Extra
0.5
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: 2016-01-01T00:44:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:17:12.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:11.000
Lpep Dropoff Datetime
2016-01-01T01:17:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952110290527344
Pickup Latitude
40.710952758789063
Dropoff Longitude
-73.972801208496094
Dropoff Latitude
40.793422698974609
Passenger Count
1
Trip Distance
9.70
Fare Amount
32.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
37.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T00:44:08.000 • Lpep Dropoff Datetime: 2016-01-01T01:11:40.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T00:44:08.000
Lpep Dropoff Datetime
2016-01-01T01:11:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990715026855469
Pickup Latitude
40.699737548828125
Dropoff Longitude
-73.980201721191406
Dropoff Latitude
40.767406463623047
Passenger Count
1
Trip Distance
7.90
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.3
Payment Type
2
Trip Type
1