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:57:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:51.000
Lpep Dropoff Datetime
2016-01-01T01:00:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950607299804687
Pickup Latitude
40.707672119140625
Dropoff Longitude
-73.941604614257813
Dropoff Latitude
40.708965301513672
Passenger Count
1
Trip Distance
0.70
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:40:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:57.000
Lpep Dropoff Datetime
2016-01-01T01:01:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960685729980469
Pickup Latitude
40.694110870361328
Dropoff Longitude
-73.916679382324219
Dropoff Latitude
40.765918731689453
Passenger Count
1
Trip Distance
7.98
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:53:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:43.000
Lpep Dropoff Datetime
2016-01-01T01:01:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.89105224609375
Pickup Latitude
40.746921539306641
Dropoff Longitude
-73.881309509277344
Dropoff Latitude
40.755935668945313
Passenger Count
1
Trip Distance
1.11
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:38.000
Lpep Dropoff Datetime
2016-01-01T01:01:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.980422973632813
Pickup Latitude
40.681114196777344
Dropoff Longitude
-73.973480224609375
Dropoff Latitude
40.696247100830078
Passenger Count
6
Trip Distance
1.60
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.94
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.74
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:27.000
Lpep Dropoff Datetime
2016-01-01T01:00:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9000244140625
Pickup Latitude
40.777767181396484
Dropoff Longitude
-73.913528442382813
Dropoff Latitude
40.765674591064453
Passenger Count
5
Trip Distance
1.43
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:44:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:16.000
Lpep Dropoff Datetime
2016-01-01T01:01:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936790466308594
Pickup Latitude
40.829910278320312
Dropoff Longitude
-73.898101806640625
Dropoff Latitude
40.857147216796875
Passenger Count
1
Trip Distance
4.27
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:44:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:17.000
Lpep Dropoff Datetime
2016-01-01T01:00:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951591491699219
Pickup Latitude
40.810348510742187
Dropoff Longitude
-73.916954040527344
Dropoff Latitude
40.828296661376953
Passenger Count
1
Trip Distance
2.93
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:50:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:39.000
Lpep Dropoff Datetime
2016-01-01T01:01:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939804077148437
Pickup Latitude
40.789867401123047
Dropoff Longitude
-73.947708129882813
Dropoff Latitude
40.809612274169922
Passenger Count
1
Trip Distance
1.98
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:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:39.000
Lpep Dropoff Datetime
2016-01-01T01:01:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991264343261719
Pickup Latitude
40.681491851806641
Dropoff Longitude
-73.992172241210937
Dropoff Latitude
40.743907928466797
Passenger Count
1
Trip Distance
5.31
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
6.09
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.39
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:58:44.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:44.000
Lpep Dropoff Datetime
2016-01-01T01:01:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844085693359375
Pickup Latitude
40.721160888671875
Dropoff Longitude
-73.848258972167969
Dropoff Latitude
40.730426788330078
Passenger Count
1
Trip Distance
0.69
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:12.000
Lpep Dropoff Datetime
2016-01-01T01:01:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981620788574219
Pickup Latitude
40.663532257080078
Dropoff Longitude
-73.950569152832031
Dropoff Latitude
40.640846252441406
Passenger Count
1
Trip Distance
3.03
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:49:29.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:29.000
Lpep Dropoff Datetime
2016-01-01T01:01:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988418579101563
Pickup Latitude
40.701625823974609
Dropoff Longitude
-73.96038818359375
Dropoff Latitude
40.70672607421875
Passenger Count
1
Trip Distance
3.28
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:45:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:47.000
Lpep Dropoff Datetime
2016-01-01T01:01:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912101745605469
Pickup Latitude
40.775188446044922
Dropoff Longitude
-73.965217590332031
Dropoff Latitude
40.759227752685547
Passenger Count
1
Trip Distance
4.07
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:47:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:02.000
Lpep Dropoff Datetime
2016-01-01T01:01:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.858573913574219
Pickup Latitude
40.837577819824219
Dropoff Longitude
-73.919227600097656
Dropoff Latitude
40.814060211181641
Passenger Count
1
Trip Distance
5.82
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:51:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:18.000
Lpep Dropoff Datetime
2016-01-01T01:01:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942123413085938
Pickup Latitude
40.802234649658203
Dropoff Longitude
-73.96270751953125
Dropoff Latitude
40.799404144287109
Passenger Count
1
Trip Distance
1.64
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: 2016-01-01T00:51:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:32.000
Lpep Dropoff Datetime
2016-01-01T01:01:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915176391601563
Pickup Latitude
40.843776702880859
Dropoff Longitude
-73.918136596679688
Dropoff Latitude
40.826332092285156
Passenger Count
6
Trip Distance
1.52
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:42:46.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:42:46.000
Lpep Dropoff Datetime
2016-01-01T01:01:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961845397949219
Pickup Latitude
40.655067443847656
Dropoff Longitude
-74.024681091308594
Dropoff Latitude
40.624546051025391
Passenger Count
1
Trip Distance
4.31
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:46:22.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:22.000
Lpep Dropoff Datetime
2016-01-01T01:01:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990531921386719
Pickup Latitude
40.699783325195313
Dropoff Longitude
-73.972579956054688
Dropoff Latitude
40.678440093994141
Passenger Count
2
Trip Distance
2.24
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:15.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:15.000
Lpep Dropoff Datetime
2016-01-01T01:00:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924728393554688
Pickup Latitude
40.833740234375
Dropoff Longitude
-73.945243835449219
Dropoff Latitude
40.828346252441406
Passenger Count
1
Trip Distance
1.40
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:55:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:47.000
Lpep Dropoff Datetime
2016-01-01T01:00:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952224731445312
Pickup Latitude
40.691310882568359
Dropoff Longitude
-73.975997924804688
Dropoff Latitude
40.689777374267578
Passenger Count
3
Trip Distance
1.17
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: 2016-01-01T00:31:20.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:20.000
Lpep Dropoff Datetime
2016-01-01T01:01:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983680725097656
Pickup Latitude
40.686466217041016
Dropoff Longitude
-73.996604919433594
Dropoff Latitude
40.758296966552734
Passenger Count
1
Trip Distance
6.42
Fare Amount
25.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:54:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:53.000
Lpep Dropoff Datetime
2016-01-01T01:01:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.853675842285156
Pickup Latitude
40.7547607421875
Dropoff Longitude
-73.848731994628906
Dropoff Latitude
40.738842010498047
Passenger Count
1
Trip Distance
2.12
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:54:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:43.000
Lpep Dropoff Datetime
2016-01-01T01:01:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.934196472167969
Pickup Latitude
40.698436737060547
Dropoff Longitude
-73.914932250976562
Dropoff Latitude
40.705268859863281
Passenger Count
1
Trip Distance
1.67
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:17.000
Lpep Dropoff Datetime
2016-01-01T01:01:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882835388183594
Pickup Latitude
40.755897521972656
Dropoff Longitude
-73.891159057617188
Dropoff Latitude
40.74530029296875
Passenger Count
1
Trip Distance
1.16
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:57:40.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:40.000
Lpep Dropoff Datetime
2016-01-01T01:01:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949302673339844
Pickup Latitude
40.713871002197266
Dropoff Longitude
-73.940620422363281
Dropoff Latitude
40.721691131591797
Passenger Count
1
Trip Distance
0.79
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:01.000
Lpep Dropoff Datetime
2016-01-01T01:01:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957855224609375
Pickup Latitude
40.731414794921875
Dropoff Longitude
-73.972846984863281
Dropoff Latitude
40.688213348388672
Passenger Count
1
Trip Distance
4.29
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:47:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:20.000
Lpep Dropoff Datetime
2016-01-01T00:57:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939468383789063
Pickup Latitude
40.820964813232422
Dropoff Longitude
-73.926353454589844
Dropoff Latitude
40.838615417480469
Passenger Count
1
Trip Distance
1.67
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:35:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:18.000
Lpep Dropoff Datetime
2016-01-01T01:00:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94476318359375
Pickup Latitude
40.834281921386719
Dropoff Longitude
-73.982040405273438
Dropoff Latitude
40.773654937744141
Passenger Count
3
Trip Distance
4.64
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:17.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:17.000
Lpep Dropoff Datetime
2016-01-01T01:01:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917495727539062
Pickup Latitude
40.773143768310547
Dropoff Longitude
-73.915313720703125
Dropoff Latitude
40.760501861572266
Passenger Count
1
Trip Distance
1.37
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:55:09.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:09.000
Lpep Dropoff Datetime
2016-01-01T01:01:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.870956420898437
Pickup Latitude
40.751663208007812
Dropoff Longitude
-73.880912780761719
Dropoff Latitude
40.748088836669922
Passenger Count
1
Trip Distance
0.77
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: 2016-01-01T00:53:37.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:37.000
Lpep Dropoff Datetime
2016-01-01T01:01:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844032287597656
Pickup Latitude
40.721179962158203
Dropoff Longitude
-73.858085632324219
Dropoff Latitude
40.756717681884766
Passenger Count
1
Trip Distance
3.60
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:05.000
Lpep Dropoff Datetime
2016-01-01T01:00:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954345703125
Pickup Latitude
40.815990447998047
Dropoff Longitude
-73.951339721679688
Dropoff Latitude
40.788463592529297
Passenger Count
1
Trip Distance
2.43
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:45:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:35.000
Lpep Dropoff Datetime
2016-01-01T01:01:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.876953125
Pickup Latitude
40.750560760498047
Dropoff Longitude
-73.956336975097656
Dropoff Latitude
40.747653961181641
Passenger Count
5
Trip Distance
5.46
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:54:52.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:52.000
Lpep Dropoff Datetime
2016-01-01T01:01:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948860168457031
Pickup Latitude
40.7110595703125
Dropoff Longitude
-73.940841674804688
Dropoff Latitude
40.721637725830078
Passenger Count
1
Trip Distance
1.12
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:57:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:02:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:42.000
Lpep Dropoff Datetime
2016-01-01T01:02:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.988235473632813
Pickup Latitude
40.666763305664063
Dropoff Longitude
-73.979942321777344
Dropoff Latitude
40.676174163818359
Passenger Count
1
Trip Distance
0.82
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:02.000
Lpep Dropoff Datetime
2016-01-01T01:01:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991142272949219
Pickup Latitude
40.699787139892578
Dropoff Longitude
-73.922637939453125
Dropoff Latitude
40.68414306640625
Passenger Count
1
Trip Distance
5.08
Fare Amount
21
Extra
0.5
Mta Tax
0.5
Tip Amount
4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:11.000
Lpep Dropoff Datetime
2016-01-01T01:01:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951515197753906
Pickup Latitude
40.713764190673828
Dropoff Longitude
-73.9654541015625
Dropoff Latitude
40.713531494140625
Passenger Count
1
Trip Distance
0.92
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:25.000
Lpep Dropoff Datetime
2016-01-01T01:01:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950653076171875
Pickup Latitude
40.685794830322266
Dropoff Longitude
-74.020263671875
Dropoff Latitude
40.649402618408203
Passenger Count
1
Trip Distance
5.88
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:55.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:55.000
Lpep Dropoff Datetime
2016-01-01T01:00:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990737915039062
Pickup Latitude
40.700263977050781
Dropoff Longitude
-73.938507080078125
Dropoff Latitude
40.583988189697266
Passenger Count
3
Trip Distance
15.87
Fare Amount
43
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
44.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:31.000
Lpep Dropoff Datetime
2016-01-01T01:01:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903297424316406
Pickup Latitude
40.745864868164063
Dropoff Longitude
-73.876510620117187
Dropoff Latitude
40.74578857421875
Passenger Count
1
Trip Distance
1.76
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:58:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:58:03.000
Lpep Dropoff Datetime
2016-01-01T01:01:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.995803833007812
Pickup Latitude
40.687221527099609
Dropoff Longitude
-73.991600036621094
Dropoff Latitude
40.685031890869141
Passenger Count
1
Trip Distance
0.48
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:53.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:53.000
Lpep Dropoff Datetime
2016-01-01T01:01:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952484130859375
Pickup Latitude
40.803462982177734
Dropoff Longitude
-73.9439697265625
Dropoff Latitude
40.820102691650391
Passenger Count
1
Trip Distance
1.44
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:32:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:54:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:53.000
Lpep Dropoff Datetime
2016-01-01T00:54:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.884590148925781
Pickup Latitude
40.846126556396484
Dropoff Longitude
-73.90826416015625
Dropoff Latitude
40.812362670898437
Passenger Count
1
Trip Distance
2.98
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:40:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:39.000
Lpep Dropoff Datetime
2016-01-01T01:00:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993217468261719
Pickup Latitude
40.682674407958984
Dropoff Longitude
-74.009353637695312
Dropoff Latitude
40.603096008300781
Passenger Count
2
Trip Distance
8.65
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:55:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:00:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:02.000
Lpep Dropoff Datetime
2016-01-01T01:00:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944419860839844
Pickup Latitude
40.82391357421875
Dropoff Longitude
-73.940139770507813
Dropoff Latitude
40.815193176269531
Passenger Count
5
Trip Distance
0.87
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:52:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:45.000
Lpep Dropoff Datetime
2016-01-01T01:01:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936798095703125
Pickup Latitude
40.702007293701172
Dropoff Longitude
-73.9241943359375
Dropoff Latitude
40.709136962890625
Passenger Count
1
Trip Distance
1.17
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:45:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:51.000
Lpep Dropoff Datetime
2016-01-01T01:01:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953903198242188
Pickup Latitude
40.719451904296875
Dropoff Longitude
-73.983406066894531
Dropoff Latitude
40.679183959960938
Passenger Count
1
Trip Distance
4.57
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
4.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:59.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:59.000
Lpep Dropoff Datetime
2016-01-01T01:01:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955848693847656
Pickup Latitude
40.708518981933594
Dropoff Longitude
-73.98309326171875
Dropoff Latitude
40.715415954589844
Passenger Count
3
Trip Distance
2.61
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:54:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:19.000
Lpep Dropoff Datetime
2016-01-01T01:01:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923774719238281
Pickup Latitude
40.761295318603516
Dropoff Longitude
-73.919654846191406
Dropoff Latitude
40.769790649414063
Passenger Count
1
Trip Distance
0.91
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.95
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.75
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:12.000 • Lpep Dropoff Datetime: 2016-01-01T01:01:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:12.000
Lpep Dropoff Datetime
2016-01-01T01:01:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.989616394042969
Pickup Latitude
40.702362060546875
Dropoff Longitude
-73.979133605957031
Dropoff Latitude
40.737209320068359
Passenger Count
1
Trip Distance
4.97
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