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:21:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:16.000
Lpep Dropoff Datetime
2016-01-01T00:29:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935356140136719
Pickup Latitude
40.684314727783203
Dropoff Longitude
-73.934173583984375
Dropoff Latitude
40.667217254638672
Passenger Count
5
Trip Distance
1.54
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:18:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:28:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:21.000
Lpep Dropoff Datetime
2016-01-01T00:28:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941932678222656
Pickup Latitude
40.82257080078125
Dropoff Longitude
-73.951065063476562
Dropoff Latitude
40.802665710449219
Passenger Count
1
Trip Distance
1.70
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:20:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:45.000
Lpep Dropoff Datetime
2016-01-01T00:29:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942161560058594
Pickup Latitude
40.754135131835938
Dropoff Longitude
-73.910675048828125
Dropoff Latitude
40.75286865234375
Passenger Count
1
Trip Distance
1.93
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:19:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:41.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:51.000
Lpep Dropoff Datetime
2016-01-01T00:29:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962570190429688
Pickup Latitude
40.687206268310547
Dropoff Longitude
-73.988792419433594
Dropoff Latitude
40.685184478759766
Passenger Count
1
Trip Distance
2.01
Fare Amount
9
Extra
0.5
Mta Tax
0.5
Tip Amount
6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:26:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:29.000
Lpep Dropoff Datetime
2016-01-01T00:29:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957969665527344
Pickup Latitude
40.81536865234375
Dropoff Longitude
-73.956039428710937
Dropoff Latitude
40.804637908935547
Passenger Count
5
Trip Distance
0.92
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:24:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:43.000
Lpep Dropoff Datetime
2016-01-01T00:29:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.88372802734375
Pickup Latitude
40.743396759033203
Dropoff Longitude
-73.899055480957031
Dropoff Latitude
40.749984741210937
Passenger Count
1
Trip Distance
0.88
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:15:02.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:02.000
Lpep Dropoff Datetime
2016-01-01T00:29:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.007659912109375
Pickup Latitude
40.67486572265625
Dropoff Longitude
-73.971153259277344
Dropoff Latitude
40.684734344482422
Passenger Count
6
Trip Distance
3.38
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:14:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:13.000
Lpep Dropoff Datetime
2016-01-01T00:29:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.853446960449219
Pickup Latitude
40.834140777587891
Dropoff Longitude
-73.939521789550781
Dropoff Latitude
40.841262817382813
Passenger Count
1
Trip Distance
5.10
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:13:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:20.000
Lpep Dropoff Datetime
2016-01-01T00:29:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949226379394531
Pickup Latitude
40.717430114746094
Dropoff Longitude
-73.95086669921875
Dropoff Latitude
40.724094390869141
Passenger Count
1
Trip Distance
2.06
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
2.66
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:00.000
Lpep Dropoff Datetime
2016-01-01T00:29:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954643249511719
Pickup Latitude
40.686882019042969
Dropoff Longitude
-73.912559509277344
Dropoff Latitude
40.67767333984375
Passenger Count
1
Trip Distance
3.00
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:14:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:27.000
Lpep Dropoff Datetime
2016-01-01T00:30:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933486938476563
Pickup Latitude
40.751895904541016
Dropoff Longitude
-73.981094360351563
Dropoff Latitude
40.730678558349609
Passenger Count
4
Trip Distance
4.97
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:07.000
Lpep Dropoff Datetime
2016-01-01T00:30:20.000
Store And Fwd Flag
N
Ratecodeid
2
Pickup Longitude
-73.921920776367188
Pickup Latitude
40.68878173828125
Dropoff Longitude
-73.921920776367188
Dropoff Latitude
40.688766479492188
Passenger Count
3
Trip Distance
0.00
Fare Amount
52
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
52.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:17:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:37.000
Lpep Dropoff Datetime
2016-01-01T00:29:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979278564453125
Pickup Latitude
40.678211212158203
Dropoff Longitude
-74.001197814941406
Dropoff Latitude
40.645084381103516
Passenger Count
1
Trip Distance
2.91
Fare Amount
12
Extra
0.5
Mta Tax
0.5
Tip Amount
3.99
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.29
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:19:27.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:27.000
Lpep Dropoff Datetime
2016-01-01T00:29:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.957374572753906
Pickup Latitude
40.722427368164062
Dropoff Longitude
-73.93804931640625
Dropoff Latitude
40.714572906494141
Passenger Count
1
Trip Distance
1.48
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:26:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:38.000
Lpep Dropoff Datetime
2016-01-01T00:29:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918724060058594
Pickup Latitude
40.765663146972656
Dropoff Longitude
-73.923637390136719
Dropoff Latitude
40.767955780029297
Passenger Count
1
Trip Distance
0.51
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:20:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:20.000
Lpep Dropoff Datetime
2016-01-01T00:29:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963760375976562
Pickup Latitude
40.682895660400391
Dropoff Longitude
-73.957725524902344
Dropoff Latitude
40.658275604248047
Passenger Count
1
Trip Distance
2.16
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:16:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:52.000
Lpep Dropoff Datetime
2016-01-01T00:29:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993095397949219
Pickup Latitude
40.697483062744141
Dropoff Longitude
-73.954864501953125
Dropoff Latitude
40.734275817871094
Passenger Count
1
Trip Distance
5.04
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:20:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:28:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:21.000
Lpep Dropoff Datetime
2016-01-01T00:28:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.870475769042969
Pickup Latitude
40.733852386474609
Dropoff Longitude
-73.814407348632812
Dropoff Latitude
40.730331420898438
Passenger Count
3
Trip Distance
4.41
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:20:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:47.000
Lpep Dropoff Datetime
2016-01-01T00:30:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939979553222656
Pickup Latitude
40.827247619628906
Dropoff Longitude
-73.938804626464844
Dropoff Latitude
40.810752868652344
Passenger Count
1
Trip Distance
1.61
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:16:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:25.000
Lpep Dropoff Datetime
2016-01-01T00:30:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.921951293945313
Pickup Latitude
40.678863525390625
Dropoff Longitude
-73.948768615722656
Dropoff Latitude
40.693347930908203
Passenger Count
1
Trip Distance
2.88
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:20:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:30.000
Lpep Dropoff Datetime
2016-01-01T00:29:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963623046875
Pickup Latitude
40.802886962890625
Dropoff Longitude
-73.944839477539063
Dropoff Latitude
40.794258117675781
Passenger Count
1
Trip Distance
1.36
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:45.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:45.000
Lpep Dropoff Datetime
2016-01-01T00:30:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912307739257813
Pickup Latitude
40.774761199951172
Dropoff Longitude
-73.940139770507813
Dropoff Latitude
40.751155853271484
Passenger Count
1
Trip Distance
2.72
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:22:39.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:39.000
Lpep Dropoff Datetime
2016-01-01T00:29:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.876754760742188
Pickup Latitude
40.744338989257813
Dropoff Longitude
-73.870063781738281
Dropoff Latitude
40.733749389648438
Passenger Count
1
Trip Distance
1.14
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:22:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:49.000
Lpep Dropoff Datetime
2016-01-01T00:29:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.975723266601563
Pickup Latitude
40.68182373046875
Dropoff Longitude
-73.989059448242188
Dropoff Latitude
40.6937255859375
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:21:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:44.000
Lpep Dropoff Datetime
2016-01-01T00:29:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90643310546875
Pickup Latitude
40.745338439941406
Dropoff Longitude
-73.886123657226562
Dropoff Latitude
40.747306823730469
Passenger Count
1
Trip Distance
1.03
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:14:08.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:14:08.000
Lpep Dropoff Datetime
2016-01-01T00:29:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970466613769531
Pickup Latitude
40.672435760498047
Dropoff Longitude
-73.943733215332031
Dropoff Latitude
40.695976257324219
Passenger Count
1
Trip Distance
3.21
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:20:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:47.000
Lpep Dropoff Datetime
2016-01-01T00:29:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92449951171875
Pickup Latitude
40.756122589111328
Dropoff Longitude
-73.931472778320313
Dropoff Latitude
40.766380310058594
Passenger Count
1
Trip Distance
1.84
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:13:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:13:22.000
Lpep Dropoff Datetime
2016-01-01T00:30:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958137512207031
Pickup Latitude
40.721717834472656
Dropoff Longitude
-73.922492980957031
Dropoff Latitude
40.706981658935547
Passenger Count
2
Trip Distance
3.16
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:22:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:20.000
Lpep Dropoff Datetime
2016-01-01T00:29:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.936424255371094
Pickup Latitude
40.820320129394531
Dropoff Longitude
-73.952461242675781
Dropoff Latitude
40.803470611572266
Passenger Count
1
Trip Distance
1.39
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:10:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:31.000
Lpep Dropoff Datetime
2016-01-01T00:30:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.976593017578125
Pickup Latitude
40.6829833984375
Dropoff Longitude
-73.976219177246094
Dropoff Latitude
40.750133514404297
Passenger Count
1
Trip Distance
7.44
Fare Amount
23.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:25.000
Lpep Dropoff Datetime
2016-01-01T00:29:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.829940795898437
Pickup Latitude
40.713703155517578
Dropoff Longitude
-73.807090759277344
Dropoff Latitude
40.6824951171875
Passenger Count
5
Trip Distance
2.70
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:26:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:20.000
Lpep Dropoff Datetime
2016-01-01T00:30:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.999130249023437
Pickup Latitude
40.675811767578125
Dropoff Longitude
-73.996429443359375
Dropoff Latitude
40.682525634765625
Passenger Count
1
Trip Distance
0.74
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.89
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.19
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:25.000
Lpep Dropoff Datetime
2016-01-01T00:29:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.92987060546875
Pickup Latitude
40.697647094726563
Dropoff Longitude
-73.943977355957031
Dropoff Latitude
40.692974090576172
Passenger Count
1
Trip Distance
1.12
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:25:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:16.000
Lpep Dropoff Datetime
2016-01-01T00:30:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956443786621094
Pickup Latitude
40.721031188964844
Dropoff Longitude
-73.953842163085937
Dropoff Latitude
40.729404449462891
Passenger Count
1
Trip Distance
0.96
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
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:23:19.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:23:19.000
Lpep Dropoff Datetime
2016-01-01T00:30:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.891532897949219
Pickup Latitude
40.746669769287109
Dropoff Longitude
-73.870895385742187
Dropoff Latitude
40.741607666015625
Passenger Count
1
Trip Distance
1.36
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:22:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:15.000
Lpep Dropoff Datetime
2016-01-01T00:30:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951690673828125
Pickup Latitude
40.713951110839844
Dropoff Longitude
-73.957305908203125
Dropoff Latitude
40.722442626953125
Passenger Count
3
Trip Distance
1.54
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:28:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:31.000
Lpep Dropoff Datetime
2016-01-01T00:30:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.010299682617188
Pickup Latitude
40.679527282714844
Dropoff Longitude
-74.00518798828125
Dropoff Latitude
40.684909820556641
Passenger Count
1
Trip Distance
0.47
Fare Amount
4
Extra
0.5
Mta Tax
0.5
Tip Amount
1.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:37.000
Lpep Dropoff Datetime
2016-01-01T00:29:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.900360107421875
Pickup Latitude
40.753902435302734
Dropoff Longitude
-73.884674072265625
Dropoff Latitude
40.755615234375
Passenger Count
2
Trip Distance
0.82
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:21:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:21:21.000
Lpep Dropoff Datetime
2016-01-01T00:30:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924636840820313
Pickup Latitude
40.756210327148438
Dropoff Longitude
-73.93096923828125
Dropoff Latitude
40.766986846923828
Passenger Count
5
Trip Distance
1.75
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.47
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.27
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:18:05.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:05.000
Lpep Dropoff Datetime
2016-01-01T00:30:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960968017578125
Pickup Latitude
40.715484619140625
Dropoff Longitude
-73.907913208007813
Dropoff Latitude
40.723190307617187
Passenger Count
2
Trip Distance
3.79
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:05:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:05:13.000
Lpep Dropoff Datetime
2016-01-01T00:30:25.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-74.008064270019531
Pickup Latitude
40.681476593017578
Dropoff Longitude
-73.992790222167969
Dropoff Latitude
40.767475128173828
Passenger Count
1
Trip Distance
7.60
Fare Amount
40
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
40
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:07:22.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:07:22.000
Lpep Dropoff Datetime
2016-01-01T00:29:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987373352050781
Pickup Latitude
40.691280364990234
Dropoff Longitude
-73.940841674804688
Dropoff Latitude
40.683605194091797
Passenger Count
1
Trip Distance
3.84
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:04:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:04:25.000
Lpep Dropoff Datetime
2016-01-01T00:29:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944198608398437
Pickup Latitude
40.713695526123047
Dropoff Longitude
-73.952468872070313
Dropoff Latitude
40.804092407226563
Passenger Count
1
Trip Distance
10.55
Fare Amount
32
Extra
0.5
Mta Tax
0.5
Tip Amount
9.71
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
48.55
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:22:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:44.000
Lpep Dropoff Datetime
2016-01-01T00:29:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943428039550781
Pickup Latitude
40.680122375488281
Dropoff Longitude
-73.960975646972656
Dropoff Latitude
40.681346893310547
Passenger Count
1
Trip Distance
1.00
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:17:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:17:59.000
Lpep Dropoff Datetime
2016-01-01T00:29:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.877532958984375
Pickup Latitude
40.821628570556641
Dropoff Longitude
-73.890670776367188
Dropoff Latitude
40.870212554931641
Passenger Count
1
Trip Distance
5.10
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:09:03.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:09:03.000
Lpep Dropoff Datetime
2016-01-01T00:30:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961280822753906
Pickup Latitude
40.716476440429688
Dropoff Longitude
-73.896240234375
Dropoff Latitude
40.707386016845703
Passenger Count
1
Trip Distance
3.99
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:28:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:21.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:28:49.000
Lpep Dropoff Datetime
2016-01-01T00:29:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.926773071289063
Pickup Latitude
40.691196441650391
Dropoff Longitude
-73.926643371582031
Dropoff Latitude
40.691204071044922
Passenger Count
1
Trip Distance
0.01
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
12
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
15.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:25:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:30:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:33.000
Lpep Dropoff Datetime
2016-01-01T00:30:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944923400878906
Pickup Latitude
40.751228332519531
Dropoff Longitude
-73.961135864257813
Dropoff Latitude
40.761646270751953
Passenger Count
1
Trip Distance
1.86
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:25:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:29:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:37.000
Lpep Dropoff Datetime
2016-01-01T00:29:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952674865722656
Pickup Latitude
40.742618560791016
Dropoff Longitude
-73.937828063964844
Dropoff Latitude
40.745151519775391
Passenger Count
1
Trip Distance
1.12
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
12.34
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:10:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:28:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:36.000
Lpep Dropoff Datetime
2016-01-01T00:28:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950080871582031
Pickup Latitude
40.806758880615234
Dropoff Longitude
-73.877365112304688
Dropoff Latitude
40.823928833007813
Passenger Count
1
Trip Distance
5.91
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
NYC Data AI • Public-data exploration interface