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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:51.000
Lpep Dropoff Datetime
2016-01-01T01:09:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969627380371094
Pickup Latitude
40.675708770751953
Dropoff Longitude
-73.881546020507812
Dropoff Latitude
40.666851043701172
Passenger Count
1
Trip Distance
5.32
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:18.000
Lpep Dropoff Datetime
2016-01-01T01:09:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942306518554687
Pickup Latitude
40.786426544189453
Dropoff Longitude
-73.905838012695313
Dropoff Latitude
40.854248046875
Passenger Count
1
Trip Distance
6.32
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:07.000
Lpep Dropoff Datetime
2016-01-01T01:08:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951431274414063
Pickup Latitude
40.725078582763672
Dropoff Longitude
-73.909370422363281
Dropoff Latitude
40.713050842285156
Passenger Count
1
Trip Distance
2.82
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:35.000
Lpep Dropoff Datetime
2016-01-01T01:09:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943618774414062
Pickup Latitude
40.795982360839844
Dropoff Longitude
-73.921844482421875
Dropoff Latitude
40.864952087402344
Passenger Count
2
Trip Distance
5.72
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
2.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:01.000 • Lpep Dropoff Datetime: 2016-01-02T00:43:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:01.000
Lpep Dropoff Datetime
2016-01-02T00:43:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951408386230469
Pickup Latitude
40.730117797851563
Dropoff Longitude
-73.9483642578125
Dropoff Latitude
40.708198547363281
Passenger Count
1
Trip Distance
1.90
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
2.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:42:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:56.000
Lpep Dropoff Datetime
2016-01-01T01:09:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.011756896972656
Pickup Latitude
40.679405212402344
Dropoff Longitude
-73.992332458496094
Dropoff Latitude
40.740741729736328
Passenger Count
1
Trip Distance
7.57
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.47
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
38.81
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:25.000
Lpep Dropoff Datetime
2016-01-01T01:08:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.883331298828125
Pickup Latitude
40.755741119384766
Dropoff Longitude
-73.850715637207031
Dropoff Latitude
40.697940826416016
Passenger Count
1
Trip Distance
6.84
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:03.000
Lpep Dropoff Datetime
2016-01-01T01:09:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933036804199219
Pickup Latitude
40.704231262207031
Dropoff Longitude
-73.983856201171875
Dropoff Latitude
40.694431304931641
Passenger Count
5
Trip Distance
3.10
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:47.000
Lpep Dropoff Datetime
2016-01-01T01:08:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.026321411132812
Pickup Latitude
40.623466491699219
Dropoff Longitude
-73.928359985351562
Dropoff Latitude
40.595695495605469
Passenger Count
5
Trip Distance
8.41
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:48:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:18.000
Lpep Dropoff Datetime
2016-01-01T01:09:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92108154296875
Pickup Latitude
40.867786407470703
Dropoff Longitude
-73.920455932617187
Dropoff Latitude
40.758560180664063
Passenger Count
1
Trip Distance
8.89
Fare Amount
27
Extra
0.5
Mta Tax
0.5
Tip Amount
6.77
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
40.61
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:29.000
Lpep Dropoff Datetime
2016-01-01T01:09:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.975914001464844
Pickup Latitude
40.673755645751953
Dropoff Longitude
-73.993858337402344
Dropoff Latitude
40.702629089355469
Passenger Count
1
Trip Distance
3.37
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:01.000
Lpep Dropoff Datetime
2016-01-01T01:09:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.900650024414063
Pickup Latitude
40.831024169921875
Dropoff Longitude
-73.952812194824219
Dropoff Latitude
40.799995422363281
Passenger Count
2
Trip Distance
4.38
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:33.000
Lpep Dropoff Datetime
2016-01-01T01:09:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.989059448242188
Pickup Latitude
40.694927215576172
Dropoff Longitude
-73.943984985351563
Dropoff Latitude
40.683712005615234
Passenger Count
1
Trip Distance
3.36
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:24.000
Lpep Dropoff Datetime
2016-01-01T01:01:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95184326171875
Pickup Latitude
40.725654602050781
Dropoff Longitude
-73.984169006347656
Dropoff Latitude
40.735263824462891
Passenger Count
2
Trip Distance
4.91
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:26.000
Lpep Dropoff Datetime
2016-01-01T01:09:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941902160644531
Pickup Latitude
40.806922912597656
Dropoff Longitude
-73.945442199707031
Dropoff Latitude
40.834854125976563
Passenger Count
1
Trip Distance
2.59
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:21.000
Lpep Dropoff Datetime
2016-01-01T01:09:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958267211914063
Pickup Latitude
40.721813201904297
Dropoff Longitude
-73.987777709960937
Dropoff Latitude
40.724094390869141
Passenger Count
1
Trip Distance
3.30
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:02.000
Lpep Dropoff Datetime
2016-01-01T01:09:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963890075683594
Pickup Latitude
40.802864074707031
Dropoff Longitude
-73.939689636230469
Dropoff Latitude
40.796878814697266
Passenger Count
1
Trip Distance
1.79
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:51.000
Lpep Dropoff Datetime
2016-01-01T01:08:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.830650329589844
Pickup Latitude
40.700168609619141
Dropoff Longitude
-73.858253479003906
Dropoff Latitude
40.692607879638672
Passenger Count
1
Trip Distance
1.58
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:51.000
Lpep Dropoff Datetime
2016-01-01T01:08:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.829925537109375
Pickup Latitude
40.713714599609375
Dropoff Longitude
-73.857742309570313
Dropoff Latitude
40.705432891845703
Passenger Count
1
Trip Distance
2.53
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:32.000
Lpep Dropoff Datetime
2016-01-01T01:09:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963394165039063
Pickup Latitude
40.649406433105469
Dropoff Longitude
-73.944091796875
Dropoff Latitude
40.611667633056641
Passenger Count
1
Trip Distance
3.49
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
4.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:21.000
Lpep Dropoff Datetime
2016-01-01T01:09:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92584228515625
Pickup Latitude
40.773811340332031
Dropoff Longitude
-73.943161010742187
Dropoff Latitude
40.793533325195313
Passenger Count
1
Trip Distance
6.10
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:25.000
Lpep Dropoff Datetime
2016-01-01T01:08:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939971923828125
Pickup Latitude
40.793964385986328
Dropoff Longitude
-73.977424621582031
Dropoff Latitude
40.763965606689453
Passenger Count
1
Trip Distance
3.58
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:03.000
Lpep Dropoff Datetime
2016-01-01T01:09:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937019348144531
Pickup Latitude
40.694545745849609
Dropoff Longitude
-73.987342834472656
Dropoff Latitude
40.72467041015625
Passenger Count
1
Trip Distance
3.86
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
3.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:43.000
Lpep Dropoff Datetime
2016-01-01T01:08:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977180480957031
Pickup Latitude
40.687381744384766
Dropoff Longitude
-73.988822937011719
Dropoff Latitude
40.697162628173828
Passenger Count
2
Trip Distance
1.11
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:08:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:32.000
Lpep Dropoff Datetime
2016-01-01T01:08:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.881423950195313
Pickup Latitude
40.759750366210938
Dropoff Longitude
-73.898605346679687
Dropoff Latitude
40.709205627441406
Passenger Count
1
Trip Distance
4.46
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:48:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:58.000
Lpep Dropoff Datetime
2016-01-01T01:10:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.873367309570313
Pickup Latitude
40.756172180175781
Dropoff Longitude
-73.922569274902344
Dropoff Latitude
40.705657958984375
Passenger Count
1
Trip Distance
6.56
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
7.14
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.94
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:28.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:28.000
Lpep Dropoff Datetime
2016-01-01T01:09:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98016357421875
Pickup Latitude
40.668491363525391
Dropoff Longitude
-74.010513305664063
Dropoff Latitude
40.714633941650391
Passenger Count
2
Trip Distance
4.29
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:10.000
Lpep Dropoff Datetime
2016-01-01T01:10:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.967765808105469
Pickup Latitude
40.710697174072266
Dropoff Longitude
-73.928985595703125
Dropoff Latitude
40.708251953125
Passenger Count
1
Trip Distance
2.22
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:26.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:26.000
Lpep Dropoff Datetime
2016-01-01T01:10:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941497802734375
Pickup Latitude
40.714748382568359
Dropoff Longitude
-73.946868896484375
Dropoff Latitude
40.772026062011719
Passenger Count
2
Trip Distance
6.25
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:54.000
Lpep Dropoff Datetime
2016-01-01T01:10:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968879699707031
Pickup Latitude
40.674518585205078
Dropoff Longitude
-73.973182678222656
Dropoff Latitude
40.636699676513672
Passenger Count
1
Trip Distance
3.21
Fare Amount
12.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:38.000
Lpep Dropoff Datetime
2016-01-01T01:09:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939445495605469
Pickup Latitude
40.705333709716797
Dropoff Longitude
-73.9603271484375
Dropoff Latitude
40.717403411865234
Passenger Count
1
Trip Distance
1.75
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: 2016-01-01T00:40:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:09.000
Lpep Dropoff Datetime
2016-01-01T01:09:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979728698730469
Pickup Latitude
40.661327362060547
Dropoff Longitude
-73.927818298339844
Dropoff Latitude
40.760311126708984
Passenger Count
1
Trip Distance
14.00
Fare Amount
40.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
41.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:30.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:30.000
Lpep Dropoff Datetime
2016-01-01T01:09:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956459045410156
Pickup Latitude
40.716995239257813
Dropoff Longitude
-73.911079406738281
Dropoff Latitude
40.767623901367187
Passenger Count
1
Trip Distance
6.40
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
4.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:37.000
Lpep Dropoff Datetime
2016-01-01T01:09:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93719482421875
Pickup Latitude
40.694561004638672
Dropoff Longitude
-73.987319946289062
Dropoff Latitude
40.724723815917969
Passenger Count
1
Trip Distance
3.88
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
5.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:43.000
Lpep Dropoff Datetime
2016-01-01T01:10:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983085632324219
Pickup Latitude
40.677608489990234
Dropoff Longitude
-73.960838317871094
Dropoff Latitude
40.679538726806641
Passenger Count
1
Trip Distance
2.23
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:36.000
Lpep Dropoff Datetime
2016-01-01T01:01:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937553405761719
Pickup Latitude
40.703323364257813
Dropoff Longitude
-73.983543395996094
Dropoff Latitude
40.725921630859375
Passenger Count
1
Trip Distance
3.77
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:39.000
Lpep Dropoff Datetime
2016-01-01T01:09:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.860809326171875
Pickup Latitude
40.833538055419922
Dropoff Longitude
-73.914115905761719
Dropoff Latitude
40.808376312255859
Passenger Count
1
Trip Distance
4.37
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:37.000
Lpep Dropoff Datetime
2016-01-01T01:10:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925331115722656
Pickup Latitude
40.839958190917969
Dropoff Longitude
-73.874862670898437
Dropoff Latitude
40.826766967773438
Passenger Count
5
Trip Distance
4.22
Fare Amount
15.5
Extra
0.5
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: 2016-01-01T00:57:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:16.000
Lpep Dropoff Datetime
2016-01-01T01:09:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95135498046875
Pickup Latitude
40.825111389160156
Dropoff Longitude
-73.916229248046875
Dropoff Latitude
40.872016906738281
Passenger Count
1
Trip Distance
4.16
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:12.000
Lpep Dropoff Datetime
2016-01-01T01:09:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987083435058594
Pickup Latitude
40.696128845214844
Dropoff Longitude
-73.959808349609375
Dropoff Latitude
40.718193054199219
Passenger Count
2
Trip Distance
3.31
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:07:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:20.000
Lpep Dropoff Datetime
2016-01-01T01:07:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91644287109375
Pickup Latitude
40.757778167724609
Dropoff Longitude
-73.932792663574219
Dropoff Latitude
40.77264404296875
Passenger Count
1
Trip Distance
1.65
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:35.000
Lpep Dropoff Datetime
2016-01-01T01:10:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977424621582031
Pickup Latitude
40.683883666992188
Dropoff Longitude
-73.960350036621094
Dropoff Latitude
40.68505859375
Passenger Count
5
Trip Distance
1.60
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:12.000
Lpep Dropoff Datetime
2016-01-01T01:09:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946319580078125
Pickup Latitude
40.684455871582031
Dropoff Longitude
-74.001823425292969
Dropoff Latitude
40.720260620117188
Passenger Count
2
Trip Distance
4.75
Fare Amount
18
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:59:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:59:39.000
Lpep Dropoff Datetime
2016-01-01T01:09:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979324340820313
Pickup Latitude
40.677646636962891
Dropoff Longitude
-73.959152221679688
Dropoff Latitude
40.677421569824219
Passenger Count
1
Trip Distance
1.58
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
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:37.000
Lpep Dropoff Datetime
2016-01-01T01:10:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957473754882813
Pickup Latitude
40.729690551757813
Dropoff Longitude
-73.875389099121094
Dropoff Latitude
40.674930572509766
Passenger Count
1
Trip Distance
7.49
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:22.000
Lpep Dropoff Datetime
2016-01-01T01:09:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.99249267578125
Pickup Latitude
40.702125549316406
Dropoff Longitude
-74.013534545898437
Dropoff Latitude
40.708160400390625
Passenger Count
1
Trip Distance
3.94
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:09:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:59.000
Lpep Dropoff Datetime
2016-01-01T01:09:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.973823547363281
Pickup Latitude
40.686168670654297
Dropoff Longitude
-73.955436706542969
Dropoff Latitude
40.707683563232422
Passenger Count
1
Trip Distance
3.24
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:58.000
Lpep Dropoff Datetime
2016-01-01T01:10:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979545593261719
Pickup Latitude
40.669265747070313
Dropoff Longitude
-73.982330322265625
Dropoff Latitude
40.611671447753906
Passenger Count
1
Trip Distance
4.70
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:56:13.000 • Lpep Dropoff Datetime: 2016-01-01T01:10:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:56:13.000
Lpep Dropoff Datetime
2016-01-01T01:10:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.98321533203125
Pickup Latitude
40.695480346679687
Dropoff Longitude
-73.980186462402344
Dropoff Latitude
40.676261901855469
Passenger Count
1
Trip Distance
2.00
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:30.000 • Lpep Dropoff Datetime: 2016-01-02T00:00:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:30.000
Lpep Dropoff Datetime
2016-01-02T00:00:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923751831054688
Pickup Latitude
40.761112213134766
Dropoff Longitude
-73.986808776855469
Dropoff Latitude
40.769329071044922
Passenger Count
3
Trip Distance
4.81
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
2.53
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.83
Payment Type
1
Trip Type
1