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:53:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:47.000
Lpep Dropoff Datetime
2016-01-01T00:57:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949028015136719
Pickup Latitude
40.813003540039063
Dropoff Longitude
-73.942092895507812
Dropoff Latitude
40.812385559082031
Passenger Count
1
Trip Distance
0.42
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:38:10.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:10.000
Lpep Dropoff Datetime
2016-01-01T00:56:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905654907226563
Pickup Latitude
40.773208618164062
Dropoff Longitude
-73.879898071289063
Dropoff Latitude
40.737461090087891
Passenger Count
5
Trip Distance
5.93
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:53:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:46.000
Lpep Dropoff Datetime
2016-01-01T00:56:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9544677734375
Pickup Latitude
40.691032409667969
Dropoff Longitude
-73.952857971191406
Dropoff Latitude
40.699432373046875
Passenger Count
2
Trip Distance
0.82
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:49:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:49.000
Lpep Dropoff Datetime
2016-01-01T00:57:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948883056640625
Pickup Latitude
40.711376190185547
Dropoff Longitude
-73.947052001953125
Dropoff Latitude
40.727764129638672
Passenger Count
1
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:44:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:09.000
Lpep Dropoff Datetime
2016-01-01T00:57:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964553833007813
Pickup Latitude
40.683006286621094
Dropoff Longitude
-73.9925537109375
Dropoff Latitude
40.689811706542969
Passenger Count
1
Trip Distance
1.86
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:48:04.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:04.000
Lpep Dropoff Datetime
2016-01-01T00:57:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.94696044921875
Pickup Latitude
40.678108215332031
Dropoff Longitude
-73.922386169433594
Dropoff Latitude
40.691879272460938
Passenger Count
1
Trip Distance
2.18
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:51:33.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:33.000
Lpep Dropoff Datetime
2016-01-01T00:57:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982231140136719
Pickup Latitude
40.662067413330078
Dropoff Longitude
-73.980392456054688
Dropoff Latitude
40.676494598388672
Passenger Count
1
Trip Distance
1.34
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:53:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:31.000
Lpep Dropoff Datetime
2016-01-01T00:57:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.985099792480469
Pickup Latitude
40.686977386474609
Dropoff Longitude
-73.993072509765625
Dropoff Latitude
40.686851501464844
Passenger Count
1
Trip Distance
0.67
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:53:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:53:17.000
Lpep Dropoff Datetime
2016-01-01T00:56:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956466674804688
Pickup Latitude
40.641281127929688
Dropoff Longitude
-73.959091186523438
Dropoff Latitude
40.651851654052734
Passenger Count
1
Trip Distance
0.73
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:41:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:01.000
Lpep Dropoff Datetime
2016-01-01T00:56:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902275085449219
Pickup Latitude
40.775936126708984
Dropoff Longitude
-73.869186401367188
Dropoff Latitude
40.755683898925781
Passenger Count
1
Trip Distance
3.45
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:38:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:43.000
Lpep Dropoff Datetime
2016-01-01T00:57:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968772888183594
Pickup Latitude
40.674156188964844
Dropoff Longitude
-73.989822387695313
Dropoff Latitude
40.702400207519531
Passenger Count
1
Trip Distance
2.82
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:54:49.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:54:49.000
Lpep Dropoff Datetime
2016-01-01T00:57:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947074890136719
Pickup Latitude
40.825675964355469
Dropoff Longitude
-73.941619873046875
Dropoff Latitude
40.833328247070313
Passenger Count
1
Trip Distance
0.60
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:51:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:51.000
Lpep Dropoff Datetime
2016-01-01T00:58:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.940299987792969
Pickup Latitude
40.762172698974609
Dropoff Longitude
-73.9403076171875
Dropoff Latitude
40.762195587158203
Passenger Count
1
Trip Distance
0.44
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.02
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.82
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:38:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:09.000
Lpep Dropoff Datetime
2016-01-01T00:57:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958106994628906
Pickup Latitude
40.721767425537109
Dropoff Longitude
-73.849411010742187
Dropoff Latitude
40.728958129882812
Passenger Count
1
Trip Distance
7.05
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
4.86
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:41.000
Lpep Dropoff Datetime
2016-01-01T00:57:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9417724609375
Pickup Latitude
40.807098388671875
Dropoff Longitude
-73.947128295898438
Dropoff Latitude
40.794254302978516
Passenger Count
1
Trip Distance
1.08
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:30:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:30:30.000
Lpep Dropoff Datetime
2016-01-01T00:57:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.931533813476562
Pickup Latitude
40.695041656494141
Dropoff Longitude
-73.927253723144531
Dropoff Latitude
40.756946563720703
Passenger Count
1
Trip Distance
5.78
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
2.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:40:57.000 • Lpep Dropoff Datetime: 2016-01-01T00:55:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:57.000
Lpep Dropoff Datetime
2016-01-01T00:55:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.925544738769531
Pickup Latitude
40.761806488037109
Dropoff Longitude
-73.826240539550781
Dropoff Latitude
40.729228973388672
Passenger Count
1
Trip Distance
7.51
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:48:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:13.000
Lpep Dropoff Datetime
2016-01-01T00:57:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.947242736816406
Pickup Latitude
40.831008911132812
Dropoff Longitude
-73.966018676757813
Dropoff Latitude
40.805377960205078
Passenger Count
1
Trip Distance
2.04
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:47:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:46.000
Lpep Dropoff Datetime
2016-01-01T00:57:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912704467773438
Pickup Latitude
40.764984130859375
Dropoff Longitude
-73.896240234375
Dropoff Latitude
40.746208190917969
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:40:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:44.000
Lpep Dropoff Datetime
2016-01-01T00:57:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956230163574219
Pickup Latitude
40.726245880126953
Dropoff Longitude
-73.982444763183594
Dropoff Latitude
40.73150634765625
Passenger Count
1
Trip Distance
4.85
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:51:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:51:55.000
Lpep Dropoff Datetime
2016-01-01T00:57:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.862937927246094
Pickup Latitude
40.757865905761719
Dropoff Longitude
-73.875389099121094
Dropoff Latitude
40.754829406738281
Passenger Count
1
Trip Distance
0.80
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:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:42.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:18.000
Lpep Dropoff Datetime
2016-01-01T00:57:42.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949195861816406
Pickup Latitude
40.794044494628906
Dropoff Longitude
-73.937171936035156
Dropoff Latitude
40.810405731201172
Passenger Count
1
Trip Distance
1.27
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:39:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:20.000
Lpep Dropoff Datetime
2016-01-01T00:57:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993049621582031
Pickup Latitude
40.661628723144531
Dropoff Longitude
-73.962989807128906
Dropoff Latitude
40.688507080078125
Passenger Count
1
Trip Distance
2.97
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:50:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:28.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:00.000
Lpep Dropoff Datetime
2016-01-01T00:57:28.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927543640136719
Pickup Latitude
40.755256652832031
Dropoff Longitude
-73.930694580078125
Dropoff Latitude
40.770130157470703
Passenger Count
1
Trip Distance
1.70
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:39:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:44.000
Lpep Dropoff Datetime
2016-01-01T00:57:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.961578369140625
Pickup Latitude
40.713970184326172
Dropoff Longitude
-74.006118774414063
Dropoff Latitude
40.733070373535156
Passenger Count
1
Trip Distance
3.65
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:18.000
Lpep Dropoff Datetime
2016-01-01T00:57:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.906021118164063
Pickup Latitude
40.830718994140625
Dropoff Longitude
-73.883430480957031
Dropoff Latitude
40.828353881835938
Passenger Count
1
Trip Distance
1.86
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:52:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:34.000
Lpep Dropoff Datetime
2016-01-01T00:57:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919113159179687
Pickup Latitude
40.759113311767578
Dropoff Longitude
-73.928543090820313
Dropoff Latitude
40.766658782958984
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:07.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:07.000
Lpep Dropoff Datetime
2016-01-01T00:57:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959030151367188
Pickup Latitude
40.800811767578125
Dropoff Longitude
-73.972381591796875
Dropoff Latitude
40.793643951416016
Passenger Count
1
Trip Distance
1.32
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:48:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:24.000
Lpep Dropoff Datetime
2016-01-01T00:57:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844200134277344
Pickup Latitude
40.722572326660156
Dropoff Longitude
-73.82073974609375
Dropoff Latitude
40.776699066162109
Passenger Count
1
Trip Distance
4.80
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:47:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:47:58.000
Lpep Dropoff Datetime
2016-01-01T00:58:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944557189941406
Pickup Latitude
40.704471588134766
Dropoff Longitude
-73.922470092773438
Dropoff Latitude
40.707004547119141
Passenger Count
1
Trip Distance
1.68
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:48:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:48:59.000
Lpep Dropoff Datetime
2016-01-01T00:57:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979888916015625
Pickup Latitude
40.629413604736328
Dropoff Longitude
-73.984039306640625
Dropoff Latitude
40.643871307373047
Passenger Count
1
Trip Distance
1.22
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:43:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:25.000
Lpep Dropoff Datetime
2016-01-01T00:57:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994140625
Pickup Latitude
40.702842712402344
Dropoff Longitude
-73.965293884277344
Dropoff Latitude
40.711071014404297
Passenger Count
1
Trip Distance
3.18
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:45:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:56:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:45:50.000
Lpep Dropoff Datetime
2016-01-01T00:56:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939659118652344
Pickup Latitude
40.789451599121094
Dropoff Longitude
-73.952308654785156
Dropoff Latitude
40.808658599853516
Passenger Count
1
Trip Distance
2.23
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:31:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:11.000
Lpep Dropoff Datetime
2016-01-01T00:57:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.998359680175781
Pickup Latitude
40.677188873291016
Dropoff Longitude
-73.970390319824219
Dropoff Latitude
40.685436248779297
Passenger Count
1
Trip Distance
4.38
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
6.39
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.69
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:43:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:12.000
Lpep Dropoff Datetime
2016-01-01T00:57:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.933273315429688
Pickup Latitude
40.855117797851563
Dropoff Longitude
-73.983489990234375
Dropoff Latitude
40.780292510986328
Passenger Count
1
Trip Distance
6.53
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:36.000
Lpep Dropoff Datetime
2016-01-01T00:57:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956703186035156
Pickup Latitude
40.712890625
Dropoff Longitude
-73.987739562988281
Dropoff Latitude
40.746158599853516
Passenger Count
1
Trip Distance
4.40
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:24:13.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:13.000
Lpep Dropoff Datetime
2016-01-01T00:57:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.84429931640625
Pickup Latitude
40.721370697021484
Dropoff Longitude
-73.893531799316406
Dropoff Latitude
40.747608184814453
Passenger Count
1
Trip Distance
8.14
Fare Amount
29.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
33.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:44:35.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:35.000
Lpep Dropoff Datetime
2016-01-01T00:57:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807106018066406
Pickup Latitude
40.699111938476562
Dropoff Longitude
-73.865547180175781
Dropoff Latitude
40.691310882568359
Passenger Count
3
Trip Distance
3.81
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:49:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:23.000
Lpep Dropoff Datetime
2016-01-01T00:57:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896675109863281
Pickup Latitude
40.746257781982422
Dropoff Longitude
-73.8846435546875
Dropoff Latitude
40.755584716796875
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:55:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:55:11.000
Lpep Dropoff Datetime
2016-01-01T00:57:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.882667541503906
Pickup Latitude
40.756488800048828
Dropoff Longitude
-73.881767272949219
Dropoff Latitude
40.756660461425781
Passenger Count
1
Trip Distance
0.14
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:52:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:52:14.000
Lpep Dropoff Datetime
2016-01-01T00:57:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949005126953125
Pickup Latitude
40.808269500732422
Dropoff Longitude
-73.944046020507813
Dropoff Latitude
40.817863464355469
Passenger Count
1
Trip Distance
1.01
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
2.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.49
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:50:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:16.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:50.000
Lpep Dropoff Datetime
2016-01-01T00:57:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.897842407226562
Pickup Latitude
40.884067535400391
Dropoff Longitude
-73.878425598144531
Dropoff Latitude
40.881336212158203
Passenger Count
1
Trip Distance
1.46
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:49:32.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:32.000
Lpep Dropoff Datetime
2016-01-01T00:57:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.829750061035156
Pickup Latitude
40.759559631347656
Dropoff Longitude
-73.8743896484375
Dropoff Latitude
40.743183135986328
Passenger Count
1
Trip Distance
2.64
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:50:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:50:28.000
Lpep Dropoff Datetime
2016-01-01T00:57:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9405517578125
Pickup Latitude
40.833358764648438
Dropoff Longitude
-73.953170776367188
Dropoff Latitude
40.825618743896484
Passenger Count
1
Trip Distance
1.26
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:57:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:57:47.000
Lpep Dropoff Datetime
2016-01-01T00:58:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.909927368164063
Pickup Latitude
40.801322937011719
Dropoff Longitude
-73.909957885742187
Dropoff Latitude
40.801322937011719
Passenger Count
1
Trip Distance
0.00
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
17
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:46:14.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:40.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:46:14.000
Lpep Dropoff Datetime
2016-01-01T00:57:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.902244567871094
Pickup Latitude
40.745681762695313
Dropoff Longitude
-73.869850158691406
Dropoff Latitude
40.748931884765625
Passenger Count
5
Trip Distance
1.72
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:43:00.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:43:00.000
Lpep Dropoff Datetime
2016-01-01T00:58:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962547302246094
Pickup Latitude
40.712509155273437
Dropoff Longitude
-73.989387512207031
Dropoff Latitude
40.732315063476563
Passenger Count
2
Trip Distance
3.30
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.44
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.24
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:49:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:46.000
Lpep Dropoff Datetime
2016-01-01T00:58:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946189880371094
Pickup Latitude
40.680267333984375
Dropoff Longitude
-73.929313659667969
Dropoff Latitude
40.693641662597656
Passenger Count
1
Trip Distance
1.83
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:44:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:58:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:44:24.000
Lpep Dropoff Datetime
2016-01-01T00:58:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.913551330566406
Pickup Latitude
40.83856201171875
Dropoff Longitude
-73.891860961914062
Dropoff Latitude
40.824268341064453
Passenger Count
1
Trip Distance
2.01
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:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:57:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:49:01.000
Lpep Dropoff Datetime
2016-01-01T00:57:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941024780273438
Pickup Latitude
40.798500061035156
Dropoff Longitude
-73.954154968261719
Dropoff Latitude
40.799762725830078
Passenger Count
1
Trip Distance
1.42
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
NYC Data AI • Public-data exploration interface