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:26.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:26.000
Lpep Dropoff Datetime
2016-01-01T00:42:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.971153259277344
Pickup Latitude
40.672771453857422
Dropoff Longitude
-73.992141723632813
Dropoff Latitude
40.663288116455078
Passenger Count
1
Trip Distance
1.85
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:36:12.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:12.000
Lpep Dropoff Datetime
2016-01-01T00:42:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960609436035156
Pickup Latitude
40.696170806884766
Dropoff Longitude
-73.950798034667969
Dropoff Latitude
40.689968109130859
Passenger Count
1
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:19:50.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:50.000
Lpep Dropoff Datetime
2016-01-01T00:42:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982002258300781
Pickup Latitude
40.679347991943359
Dropoff Longitude
-73.9539794921875
Dropoff Latitude
40.742462158203125
Passenger Count
1
Trip Distance
8.13
Fare Amount
26
Extra
0.5
Mta Tax
0.5
Tip Amount
6.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:55.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:55.000
Lpep Dropoff Datetime
2016-01-01T00:41:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952751159667969
Pickup Latitude
40.696369171142578
Dropoff Longitude
-73.940826416015625
Dropoff Latitude
40.700950622558594
Passenger Count
1
Trip Distance
1.66
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:27:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:36.000
Lpep Dropoff Datetime
2016-01-01T00:42:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977630615234375
Pickup Latitude
40.689804077148437
Dropoff Longitude
-73.943275451660156
Dropoff Latitude
40.691558837890625
Passenger Count
1
Trip Distance
1.91
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:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:29.000
Lpep Dropoff Datetime
2016-01-01T00:42:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.987518310546875
Pickup Latitude
40.67913818359375
Dropoff Longitude
-73.977615356445313
Dropoff Latitude
40.680511474609375
Passenger Count
2
Trip Distance
0.72
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.04
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.84
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:31:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:46.000
Lpep Dropoff Datetime
2016-01-01T00:41:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.927055358886719
Pickup Latitude
40.863117218017578
Dropoff Longitude
-73.903961181640625
Dropoff Latitude
40.882713317871094
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
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:09.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:09.000
Lpep Dropoff Datetime
2016-01-01T00:42:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.968971252441406
Pickup Latitude
40.672458648681641
Dropoff Longitude
-73.959457397460937
Dropoff Latitude
40.652996063232422
Passenger Count
5
Trip Distance
1.84
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:32:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:44.000
Lpep Dropoff Datetime
2016-01-01T00:42:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943199157714844
Pickup Latitude
40.707481384277344
Dropoff Longitude
-73.985618591308594
Dropoff Latitude
40.721782684326172
Passenger Count
2
Trip Distance
3.01
Fare Amount
11.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.84
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.64
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:29.000
Lpep Dropoff Datetime
2016-01-01T00:42:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95440673828125
Pickup Latitude
40.731307983398437
Dropoff Longitude
-73.926811218261719
Dropoff Latitude
40.769412994384766
Passenger Count
1
Trip Distance
3.25
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:33:28.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:28.000
Lpep Dropoff Datetime
2016-01-01T00:42:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949447631835938
Pickup Latitude
40.802165985107422
Dropoff Longitude
-73.954231262207031
Dropoff Latitude
40.816295623779297
Passenger Count
1
Trip Distance
1.35
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:20:44.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:37.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:20:44.000
Lpep Dropoff Datetime
2016-01-01T00:42:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951080322265625
Pickup Latitude
40.811885833740234
Dropoff Longitude
-73.905075073242188
Dropoff Latitude
40.759490966796875
Passenger Count
1
Trip Distance
5.63
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
8.2
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
35.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:58.000
Lpep Dropoff Datetime
2016-01-01T00:42:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958427429199219
Pickup Latitude
40.721408843994141
Dropoff Longitude
-73.949844360351563
Dropoff Latitude
40.694580078125
Passenger Count
1
Trip Distance
2.63
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:35:48.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:48.000
Lpep Dropoff Datetime
2016-01-01T00:42:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.96551513671875
Pickup Latitude
40.713573455810547
Dropoff Longitude
-73.953788757324219
Dropoff Latitude
40.707592010498047
Passenger Count
1
Trip Distance
0.98
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:34:46.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:01.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:46.000
Lpep Dropoff Datetime
2016-01-01T00:42:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994514465332031
Pickup Latitude
40.661991119384766
Dropoff Longitude
-73.997688293457031
Dropoff Latitude
40.676368713378906
Passenger Count
1
Trip Distance
1.33
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:32:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:37.000
Lpep Dropoff Datetime
2016-01-01T00:42:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944465637207031
Pickup Latitude
40.824573516845703
Dropoff Longitude
-73.950607299804687
Dropoff Latitude
40.802459716796875
Passenger Count
1
Trip Distance
1.82
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:39:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:24.000
Lpep Dropoff Datetime
2016-01-01T00:42:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.918754577636719
Pickup Latitude
40.759265899658203
Dropoff Longitude
-73.913597106933594
Dropoff Latitude
40.759773254394531
Passenger Count
1
Trip Distance
0.48
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:22:36.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:22:36.000
Lpep Dropoff Datetime
2016-01-01T00:42:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949226379394531
Pickup Latitude
40.713733673095703
Dropoff Longitude
-73.953384399414063
Dropoff Latitude
40.771411895751953
Passenger Count
1
Trip Distance
7.13
Fare Amount
23
Extra
0.5
Mta Tax
0.5
Tip Amount
6.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:37:59.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:59.000
Lpep Dropoff Datetime
2016-01-01T00:42:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.8961181640625
Pickup Latitude
40.746482849121094
Dropoff Longitude
-73.902389526367188
Dropoff Latitude
40.741485595703125
Passenger Count
1
Trip Distance
0.71
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:10:52.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:35.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:10:52.000
Lpep Dropoff Datetime
2016-01-01T00:42:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949897766113281
Pickup Latitude
40.812053680419922
Dropoff Longitude
-73.994644165039062
Dropoff Latitude
40.713775634765625
Passenger Count
1
Trip Distance
9.42
Fare Amount
31
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:16.000
Lpep Dropoff Datetime
2016-01-01T00:43:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.919120788574219
Pickup Latitude
40.765830993652344
Dropoff Longitude
-73.93939208984375
Dropoff Latitude
40.751750946044922
Passenger Count
1
Trip Distance
1.76
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
11.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:34:43.000 • Lpep Dropoff Datetime: 2016-01-01T00:38:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:34:43.000
Lpep Dropoff Datetime
2016-01-01T00:38:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948074340820313
Pickup Latitude
40.824691772460938
Dropoff Longitude
-73.958969116210938
Dropoff Latitude
40.814601898193359
Passenger Count
1
Trip Distance
1.11
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:19:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:37.000
Lpep Dropoff Datetime
2016-01-01T00:42:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.980339050292969
Pickup Latitude
40.676601409912109
Dropoff Longitude
-73.982864379882813
Dropoff Latitude
40.737030029296875
Passenger Count
1
Trip Distance
4.91
Fare Amount
19.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:25.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:25.000
Lpep Dropoff Datetime
2016-01-01T00:42:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948684692382812
Pickup Latitude
40.714157104492188
Dropoff Longitude
-73.955078125
Dropoff Latitude
40.722366333007813
Passenger Count
1
Trip Distance
1.17
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:41:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:41:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:41:30.000
Lpep Dropoff Datetime
2016-01-01T00:41:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922309875488281
Pickup Latitude
40.760562896728516
Dropoff Longitude
-73.9248046875
Dropoff Latitude
40.758644104003906
Passenger Count
1
Trip Distance
0.04
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
4
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:16:51.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:16:51.000
Lpep Dropoff Datetime
2016-01-01T00:43:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981468200683594
Pickup Latitude
40.679714202880859
Dropoff Longitude
-73.927963256835938
Dropoff Latitude
40.702022552490234
Passenger Count
1
Trip Distance
5.33
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:15:58.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:15:58.000
Lpep Dropoff Datetime
2016-01-01T00:42:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951759338378906
Pickup Latitude
40.743087768554687
Dropoff Longitude
-73.873672485351563
Dropoff Latitude
40.87841796875
Passenger Count
5
Trip Distance
16.35
Fare Amount
45
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
51.84
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:29:23.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:29:23.000
Lpep Dropoff Datetime
2016-01-01T00:42:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.974838256835938
Pickup Latitude
40.671077728271484
Dropoff Longitude
-73.964866638183594
Dropoff Latitude
40.697418212890625
Passenger Count
1
Trip Distance
2.40
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:18:17.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:18:17.000
Lpep Dropoff Datetime
2016-01-01T00:42:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970108032226563
Pickup Latitude
40.6748046875
Dropoff Longitude
-73.906593322753906
Dropoff Latitude
40.759258270263672
Passenger Count
1
Trip Distance
9.77
Fare Amount
31
Extra
0.5
Mta Tax
0.5
Tip Amount
8.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
40.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:16.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:56.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:16.000
Lpep Dropoff Datetime
2016-01-01T00:42:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.956771850585938
Pickup Latitude
40.668563842773438
Dropoff Longitude
-73.930656433105469
Dropoff Latitude
40.685581207275391
Passenger Count
1
Trip Distance
3.17
Fare Amount
13.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.96
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:24:01.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:24:01.000
Lpep Dropoff Datetime
2016-01-01T00:42:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944816589355469
Pickup Latitude
40.828277587890625
Dropoff Longitude
-73.867393493652344
Dropoff Latitude
40.839714050292969
Passenger Count
5
Trip Distance
5.74
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
5.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.62
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:27:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:15.000
Lpep Dropoff Datetime
2016-01-01T00:42:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.984474182128906
Pickup Latitude
40.687469482421875
Dropoff Longitude
-73.9383544921875
Dropoff Latitude
40.683113098144531
Passenger Count
1
Trip Distance
2.80
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:25:30.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:25:30.000
Lpep Dropoff Datetime
2016-01-01T00:42:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905059814453125
Pickup Latitude
40.872802734375
Dropoff Longitude
-73.897171020507813
Dropoff Latitude
40.862648010253906
Passenger Count
1
Trip Distance
2.42
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:40:36.000 • Lpep Dropoff Datetime: 2016-01-02T00:38:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:40:36.000
Lpep Dropoff Datetime
2016-01-02T00:38:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896339416503906
Pickup Latitude
40.816143035888672
Dropoff Longitude
-73.891670227050781
Dropoff Latitude
40.820690155029297
Passenger Count
1
Trip Distance
0.41
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:26:56.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:56.000
Lpep Dropoff Datetime
2016-01-01T00:42:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924171447753906
Pickup Latitude
40.690364837646484
Dropoff Longitude
-73.869285583496094
Dropoff Latitude
40.683506011962891
Passenger Count
1
Trip Distance
3.94
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:34.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:20.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:31:34.000
Lpep Dropoff Datetime
2016-01-01T00:42:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905715942382813
Pickup Latitude
40.861968994140625
Dropoff Longitude
-73.922019958496094
Dropoff Latitude
40.849159240722656
Passenger Count
1
Trip Distance
1.66
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:18.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:26:18.000
Lpep Dropoff Datetime
2016-01-01T00:42:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.911689758300781
Pickup Latitude
40.775421142578125
Dropoff Longitude
-73.82330322265625
Dropoff Latitude
40.755332946777344
Passenger Count
1
Trip Distance
6.45
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:19:47.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:47.000
Lpep Dropoff Datetime
2016-01-01T00:43:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.989860534667969
Pickup Latitude
40.668857574462891
Dropoff Longitude
-73.987205505371094
Dropoff Latitude
40.725170135498047
Passenger Count
1
Trip Distance
6.85
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
5.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
30.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:35:29.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:53.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:29.000
Lpep Dropoff Datetime
2016-01-01T00:42:53.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966400146484375
Pickup Latitude
40.683414459228516
Dropoff Longitude
-73.955940246582031
Dropoff Latitude
40.674022674560547
Passenger Count
5
Trip Distance
1.12
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:35:11.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:35:11.000
Lpep Dropoff Datetime
2016-01-01T00:42:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912895202636719
Pickup Latitude
40.766399383544922
Dropoff Longitude
-73.924819946289063
Dropoff Latitude
40.762840270996094
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:36:41.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:41.000
Lpep Dropoff Datetime
2016-01-01T00:43:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.993034362792969
Pickup Latitude
40.697467803955078
Dropoff Longitude
-73.994758605957031
Dropoff Latitude
40.684528350830078
Passenger Count
1
Trip Distance
1.08
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:19:20.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:19:20.000
Lpep Dropoff Datetime
2016-01-01T00:42:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.979042053222656
Pickup Latitude
40.693473815917969
Dropoff Longitude
-73.914825439453125
Dropoff Latitude
40.670162200927734
Passenger Count
1
Trip Distance
4.51
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:33:37.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:33:37.000
Lpep Dropoff Datetime
2016-01-01T00:42:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.896385192871094
Pickup Latitude
40.746448516845703
Dropoff Longitude
-73.871864318847656
Dropoff Latitude
40.753437042236328
Passenger Count
1
Trip Distance
1.80
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:27:24.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:24.000
Lpep Dropoff Datetime
2016-01-01T00:42:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.949745178222656
Pickup Latitude
40.680419921875
Dropoff Longitude
-73.986892700195313
Dropoff Latitude
40.720840454101563
Passenger Count
1
Trip Distance
4.56
Fare Amount
15.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:36:31.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:36:31.000
Lpep Dropoff Datetime
2016-01-01T00:42:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.994865417480469
Pickup Latitude
40.667423248291016
Dropoff Longitude
-73.991500854492187
Dropoff Latitude
40.700733184814453
Passenger Count
1
Trip Distance
2.97
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2.26
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T00:32:21.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:17.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:32:21.000
Lpep Dropoff Datetime
2016-01-01T00:42:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939064025878906
Pickup Latitude
40.795345306396484
Dropoff Longitude
-73.931503295898438
Dropoff Latitude
40.830951690673828
Passenger Count
1
Trip Distance
3.41
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:37:53.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:37:53.000
Lpep Dropoff Datetime
2016-01-01T00:43:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.831741333007813
Pickup Latitude
40.715076446533203
Dropoff Longitude
-73.821769714355469
Dropoff Latitude
40.719760894775391
Passenger Count
1
Trip Distance
1.80
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:39:15.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:39:15.000
Lpep Dropoff Datetime
2016-01-01T00:42:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.001869201660156
Pickup Latitude
40.622173309326172
Dropoff Longitude
-74.006233215332031
Dropoff Latitude
40.629810333251953
Passenger Count
2
Trip Distance
0.95
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:38:54.000 • Lpep Dropoff Datetime: 2016-01-01T00:42:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:38:54.000
Lpep Dropoff Datetime
2016-01-01T00:42:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990333557128906
Pickup Latitude
40.693271636962891
Dropoff Longitude
-73.99346923828125
Dropoff Latitude
40.702568054199219
Passenger Count
1
Trip Distance
0.71
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:27:38.000 • Lpep Dropoff Datetime: 2016-01-01T00:43:15.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T00:27:38.000
Lpep Dropoff Datetime
2016-01-01T00:43:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.982398986816406
Pickup Latitude
40.675525665283203
Dropoff Longitude
-73.952827453613281
Dropoff Latitude
40.689708709716797
Passenger Count
1
Trip Distance
2.56
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
NYC Data AI • Public-data exploration interface