Ask NYC Browse All Data Public Safety Transportation Health Buildings

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:34:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:20.000
Lpep Dropoff Datetime
2016-01-01T00:43:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95880126953125
Pickup Latitude
40.716819763183594
Dropoff Longitude
-73.940376281738281
Dropoff Latitude
40.719524383544922
Passenger Count
1
Trip Distance
1.41
Fare Amount
7.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.64
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.44
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:04.000
Lpep Dropoff Datetime
2016-01-01T00:43:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844673156738281
Pickup Latitude
40.721534729003906
Dropoff Longitude
-73.8507080078125
Dropoff Latitude
40.73492431640625
Passenger Count
1
Trip Distance
2.59
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
12.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:26.000
Lpep Dropoff Datetime
2016-01-01T00:43:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940109252929687
Pickup Latitude
40.820178985595703
Dropoff Longitude
-73.961112976074219
Dropoff Latitude
40.811042785644531
Passenger Count
1
Trip Distance
1.75
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:23:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:27.000
Lpep Dropoff Datetime
2016-01-01T00:43:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993453979492188
Pickup Latitude
40.682338714599609
Dropoff Longitude
-73.982597351074219
Dropoff Latitude
40.722583770751953
Passenger Count
1
Trip Distance
5.70
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:28:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:30.000
Lpep Dropoff Datetime
2016-01-01T00:43:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920433044433594
Pickup Latitude
40.768173217773438
Dropoff Longitude
-73.935638427734375
Dropoff Latitude
40.736835479736328
Passenger Count
1
Trip Distance
3.71
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:29.000
Lpep Dropoff Datetime
2016-01-01T00:43:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918380737304688
Pickup Latitude
40.830181121826172
Dropoff Longitude
-73.944221496582031
Dropoff Latitude
40.836193084716797
Passenger Count
1
Trip Distance
1.87
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:14.000
Lpep Dropoff Datetime
2016-01-01T00:43:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917579650878906
Pickup Latitude
40.758296966552734
Dropoff Longitude
-73.9033203125
Dropoff Latitude
40.745815277099609
Passenger Count
5
Trip Distance
1.37
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:34:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:25.000
Lpep Dropoff Datetime
2016-01-01T00:43:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.878120422363281
Pickup Latitude
40.748283386230469
Dropoff Longitude
-73.900245666503906
Dropoff Latitude
40.74554443359375
Passenger Count
1
Trip Distance
1.44
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:38.000
Lpep Dropoff Datetime
2016-01-01T00:42:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953941345214844
Pickup Latitude
40.80645751953125
Dropoff Longitude
-73.942138671875
Dropoff Latitude
40.809757232666016
Passenger Count
1
Trip Distance
1.27
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:37:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:55.000
Lpep Dropoff Datetime
2016-01-01T00:43:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924293518066406
Pickup Latitude
40.756221771240234
Dropoff Longitude
-73.92767333984375
Dropoff Latitude
40.766395568847656
Passenger Count
1
Trip Distance
1.01
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:54.000
Lpep Dropoff Datetime
2016-01-01T00:43:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.883003234863281
Pickup Latitude
40.742992401123047
Dropoff Longitude
-73.892684936523438
Dropoff Latitude
40.746757507324219
Passenger Count
1
Trip Distance
0.99
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:33:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:27.000
Lpep Dropoff Datetime
2016-01-01T00:43:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.995742797851563
Pickup Latitude
40.690666198730469
Dropoff Longitude
-73.95709228515625
Dropoff Latitude
40.711475372314453
Passenger Count
1
Trip Distance
4.66
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:35.000
Lpep Dropoff Datetime
2016-01-01T00:43:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891571044921875
Pickup Latitude
40.746738433837891
Dropoff Longitude
-73.904464721679688
Dropoff Latitude
40.745151519775391
Passenger Count
1
Trip Distance
0.99
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: 2016-01-01T00:23:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:07.000
Lpep Dropoff Datetime
2016-01-01T00:43:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955307006835938
Pickup Latitude
40.721035003662109
Dropoff Longitude
-73.80169677734375
Dropoff Latitude
40.725475311279297
Passenger Count
1
Trip Distance
10.35
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:54.000
Lpep Dropoff Datetime
2016-01-01T00:43:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9921875
Pickup Latitude
40.662517547607422
Dropoff Longitude
-73.974388122558594
Dropoff Latitude
40.638439178466797
Passenger Count
5
Trip Distance
2.35
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:44.000
Lpep Dropoff Datetime
2016-01-01T00:43:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943748474121094
Pickup Latitude
40.827953338623047
Dropoff Longitude
-73.93695068359375
Dropoff Latitude
40.844844818115234
Passenger Count
1
Trip Distance
1.53
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:20:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:33.000
Lpep Dropoff Datetime
2016-01-01T00:43:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951828002929687
Pickup Latitude
40.725532531738281
Dropoff Longitude
-73.959487915039063
Dropoff Latitude
40.801364898681641
Passenger Count
1
Trip Distance
7.61
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:07:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:07:58.000
Lpep Dropoff Datetime
2016-01-01T00:43:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9847412109375
Pickup Latitude
40.6710205078125
Dropoff Longitude
-73.976806640625
Dropoff Latitude
40.782478332519531
Passenger Count
2
Trip Distance
9.93
Fare Amount
33.5
Extra
0.5
Mta Tax
0.5
Tip Amount
12.1
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
52.44
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:26:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:10.000
Lpep Dropoff Datetime
2016-01-01T00:43:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935714721679688
Pickup Latitude
40.827701568603516
Dropoff Longitude
-73.898918151855469
Dropoff Latitude
40.832149505615234
Passenger Count
2
Trip Distance
2.58
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:29:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:53.000
Lpep Dropoff Datetime
2016-01-01T00:43:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991081237792969
Pickup Latitude
40.701026916503906
Dropoff Longitude
-73.958694458007812
Dropoff Latitude
40.716903686523438
Passenger Count
1
Trip Distance
3.85
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:18:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:22.000
Lpep Dropoff Datetime
2016-01-01T00:43:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951644897460937
Pickup Latitude
40.71484375
Dropoff Longitude
-73.967918395996094
Dropoff Latitude
40.755405426025391
Passenger Count
1
Trip Distance
5.21
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:53.000
Lpep Dropoff Datetime
2016-01-01T00:43:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953460693359375
Pickup Latitude
40.681301116943359
Dropoff Longitude
-73.975372314453125
Dropoff Latitude
40.686687469482422
Passenger Count
1
Trip Distance
1.48
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:30:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:11.000
Lpep Dropoff Datetime
2016-01-01T00:43:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914909362792969
Pickup Latitude
40.842441558837891
Dropoff Longitude
-73.944816589355469
Dropoff Latitude
40.787326812744141
Passenger Count
1
Trip Distance
5.67
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:03.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:03.000
Lpep Dropoff Datetime
2016-01-01T00:44:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.998046875
Pickup Latitude
40.688884735107422
Dropoff Longitude
-73.996734619140625
Dropoff Latitude
40.688594818115234
Passenger Count
1
Trip Distance
0.00
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
3.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:40:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:53.000
Lpep Dropoff Datetime
2016-01-01T00:43:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912994384765625
Pickup Latitude
40.774211883544922
Dropoff Longitude
-73.902320861816406
Dropoff Latitude
40.775928497314453
Passenger Count
1
Trip Distance
0.89
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:32:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:16.000
Lpep Dropoff Datetime
2016-01-01T00:44:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966522216796875
Pickup Latitude
40.804244995117187
Dropoff Longitude
-73.921371459960938
Dropoff Latitude
40.867603302001953
Passenger Count
1
Trip Distance
5.52
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:40:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:41.000
Lpep Dropoff Datetime
2016-01-01T00:43:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952278137207031
Pickup Latitude
40.803352355957031
Dropoff Longitude
-73.951408386230469
Dropoff Latitude
40.809761047363281
Passenger Count
1
Trip Distance
0.40
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:38.000
Lpep Dropoff Datetime
2016-01-01T00:43:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.903457641601563
Pickup Latitude
40.745315551757813
Dropoff Longitude
-73.900260925292969
Dropoff Latitude
40.717617034912109
Passenger Count
1
Trip Distance
2.48
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:29:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:27.000
Lpep Dropoff Datetime
2016-01-01T00:43:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.906585693359375
Pickup Latitude
40.831352233886719
Dropoff Longitude
-73.948318481445312
Dropoff Latitude
40.793117523193359
Passenger Count
6
Trip Distance
3.66
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:12.000
Lpep Dropoff Datetime
2016-01-01T00:43:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944908142089844
Pickup Latitude
40.70794677734375
Dropoff Longitude
-73.906471252441406
Dropoff Latitude
40.771408081054687
Passenger Count
1
Trip Distance
6.74
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
4.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:40.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:40.000
Lpep Dropoff Datetime
2016-01-01T00:43:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938240051269531
Pickup Latitude
40.796489715576172
Dropoff Longitude
-73.958084106445313
Dropoff Latitude
40.769203186035156
Passenger Count
1
Trip Distance
2.18
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:22.000
Lpep Dropoff Datetime
2016-01-01T00:43:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922370910644531
Pickup Latitude
40.743564605712891
Dropoff Longitude
-73.898811340332031
Dropoff Latitude
40.743488311767578
Passenger Count
2
Trip Distance
1.55
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:55.000
Lpep Dropoff Datetime
2016-01-01T00:43:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.890914916992188
Pickup Latitude
40.746551513671875
Dropoff Longitude
-73.887931823730469
Dropoff Latitude
40.759193420410156
Passenger Count
1
Trip Distance
1.37
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:23:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:10.000
Lpep Dropoff Datetime
2016-01-01T00:44:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986785888671875
Pickup Latitude
40.691421508789063
Dropoff Longitude
-73.960548400878906
Dropoff Latitude
40.653282165527344
Passenger Count
1
Trip Distance
3.38
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
3.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:45.000
Lpep Dropoff Datetime
2016-01-01T00:44:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.974891662597656
Pickup Latitude
40.686515808105469
Dropoff Longitude
-73.951934814453125
Dropoff Latitude
40.695018768310547
Passenger Count
1
Trip Distance
1.77
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:33:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:44.000
Lpep Dropoff Datetime
2016-01-01T00:43:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968223571777344
Pickup Latitude
40.693248748779297
Dropoff Longitude
-73.985130310058594
Dropoff Latitude
40.682308197021484
Passenger Count
1
Trip Distance
1.61
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:41:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:30.000
Lpep Dropoff Datetime
2016-01-01T00:44:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.855995178222656
Pickup Latitude
40.751609802246094
Dropoff Longitude
-73.863441467285156
Dropoff Latitude
40.749835968017578
Passenger Count
1
Trip Distance
0.42
Fare Amount
3.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:25.000
Lpep Dropoff Datetime
2016-01-01T00:43:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.932563781738281
Pickup Latitude
40.800006866455078
Dropoff Longitude
-73.946022033691406
Dropoff Latitude
40.827320098876953
Passenger Count
5
Trip Distance
2.73
Fare Amount
13
Extra
0.5
Mta Tax
0.5
Tip Amount
2.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:18:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:18.000
Lpep Dropoff Datetime
2016-01-01T00:42:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95758056640625
Pickup Latitude
40.719581604003906
Dropoff Longitude
-73.976181030273438
Dropoff Latitude
40.669460296630859
Passenger Count
1
Trip Distance
5.26
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:58.000
Lpep Dropoff Datetime
2016-01-01T00:43:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954521179199219
Pickup Latitude
40.663684844970703
Dropoff Longitude
-73.961013793945313
Dropoff Latitude
40.650554656982422
Passenger Count
1
Trip Distance
1.30
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:07.000
Lpep Dropoff Datetime
2016-01-01T00:44:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.937004089355469
Pickup Latitude
40.802131652832031
Dropoff Longitude
-73.955169677734375
Dropoff Latitude
40.804756164550781
Passenger Count
1
Trip Distance
1.24
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:30.000
Lpep Dropoff Datetime
2016-01-01T00:44:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956275939941406
Pickup Latitude
40.675022125244141
Dropoff Longitude
-73.949745178222656
Dropoff Latitude
40.677761077880859
Passenger Count
2
Trip Distance
0.95
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
1.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:46.000
Lpep Dropoff Datetime
2016-01-01T00:43:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923126220703125
Pickup Latitude
40.817577362060547
Dropoff Longitude
-73.942863464355469
Dropoff Latitude
40.821521759033203
Passenger Count
1
Trip Distance
2.02
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:46.000
Lpep Dropoff Datetime
2016-01-01T00:43:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977989196777344
Pickup Latitude
40.673896789550781
Dropoff Longitude
-73.958930969238281
Dropoff Latitude
40.677986145019531
Passenger Count
1
Trip Distance
1.37
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
2.49
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.79
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:34:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:12.000
Lpep Dropoff Datetime
2016-01-01T00:34:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950286865234375
Pickup Latitude
40.828910827636719
Dropoff Longitude
-73.944877624511719
Dropoff Latitude
40.833896636962891
Passenger Count
1
Trip Distance
0.50
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:33:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:33.000
Lpep Dropoff Datetime
2016-01-01T00:44:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927406311035156
Pickup Latitude
40.759571075439453
Dropoff Longitude
-73.958160400390625
Dropoff Latitude
40.760543823242188
Passenger Count
1
Trip Distance
2.84
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:21:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:27.000
Lpep Dropoff Datetime
2016-01-01T00:44:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.001457214355469
Pickup Latitude
40.65704345703125
Dropoff Longitude
-73.990806579589844
Dropoff Latitude
40.597393035888672
Passenger Count
1
Trip Distance
8.57
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:36:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:12.000
Lpep Dropoff Datetime
2016-01-01T00:44:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954177856445313
Pickup Latitude
40.806064605712891
Dropoff Longitude
-73.942092895507812
Dropoff Latitude
40.828914642333984
Passenger Count
1
Trip Distance
1.73
Fare Amount
8
Extra
0.5
Mta Tax
0.5
Tip Amount
1.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:44:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:35.000
Lpep Dropoff Datetime
2016-01-01T00:44:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.867477416992188
Pickup Latitude
40.73468017578125
Dropoff Longitude
-73.895469665527344
Dropoff Latitude
40.712554931640625
Passenger Count
1
Trip Distance
2.82
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:39:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:34.000
Lpep Dropoff Datetime
2016-01-01T00:43:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927734375
Pickup Latitude
40.807060241699219
Dropoff Longitude
-73.937034606933594
Dropoff Latitude
40.798061370849609
Passenger Count
2
Trip Distance
1.02
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
NYC Data AI • Public-data exploration interface