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-01T01:32:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:32:43.000
Lpep Dropoff Datetime
2016-01-01T01:45:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.867355346679688
Pickup Latitude
40.749435424804688
Dropoff Longitude
-73.884284973144531
Dropoff Latitude
40.747642517089844
Passenger Count
1
Trip Distance
0.85
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-01T01:40:16.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:16.000
Lpep Dropoff Datetime
2016-01-01T01:45:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945556640625
Pickup Latitude
40.711341857910156
Dropoff Longitude
-73.952293395996094
Dropoff Latitude
40.7109375
Passenger Count
1
Trip Distance
0.36
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-01T01:38:32.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:32.000
Lpep Dropoff Datetime
2016-01-01T01:45:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.839210510253906
Pickup Latitude
40.700798034667969
Dropoff Longitude
-73.83563232421875
Dropoff Latitude
40.687427520751953
Passenger Count
1
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-01T01:29:57.000 • Lpep Dropoff Datetime: 2016-01-01T01:43:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:57.000
Lpep Dropoff Datetime
2016-01-01T01:43:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.914596557617188
Pickup Latitude
40.8056640625
Dropoff Longitude
-73.948081970214844
Dropoff Latitude
40.803878784179688
Passenger Count
1
Trip Distance
2.27
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-01T01:40:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:23.000
Lpep Dropoff Datetime
2016-01-01T01:45:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955764770507813
Pickup Latitude
40.787883758544922
Dropoff Longitude
-73.949958801269531
Dropoff Latitude
40.780612945556641
Passenger Count
5
Trip Distance
0.78
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-01T01:32:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:18.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:32:56.000
Lpep Dropoff Datetime
2016-01-01T01:45:18.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950576782226563
Pickup Latitude
40.707660675048828
Dropoff Longitude
-73.952850341796875
Dropoff Latitude
40.727058410644531
Passenger Count
1
Trip Distance
1.54
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-01T01:20:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:20:36.000
Lpep Dropoff Datetime
2016-01-01T01:45:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963737487792969
Pickup Latitude
40.710285186767578
Dropoff Longitude
-73.972015380859375
Dropoff Latitude
40.755668640136719
Passenger Count
2
Trip Distance
5.91
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
4.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
28.56
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:13:27.000 • Lpep Dropoff Datetime: 2016-01-01T01:43:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:13:27.000
Lpep Dropoff Datetime
2016-01-01T01:43:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939735412597656
Pickup Latitude
40.707141876220703
Dropoff Longitude
-73.970085144042969
Dropoff Latitude
40.756320953369141
Passenger Count
1
Trip Distance
6.42
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
26.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:31.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:23.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:31.000
Lpep Dropoff Datetime
2016-01-01T01:45:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.946365356445313
Pickup Latitude
40.789165496826172
Dropoff Longitude
-73.943534851074219
Dropoff Latitude
40.793178558349609
Passenger Count
1
Trip Distance
0.29
Fare Amount
3
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:33:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:42:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:35.000
Lpep Dropoff Datetime
2016-01-01T01:42:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965972900390625
Pickup Latitude
40.708988189697266
Dropoff Longitude
-73.943946838378906
Dropoff Latitude
40.711215972900391
Passenger Count
1
Trip Distance
1.49
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-01T01:33:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:25.000
Lpep Dropoff Datetime
2016-01-01T01:45:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95574951171875
Pickup Latitude
40.715591430664063
Dropoff Longitude
-73.948287963867188
Dropoff Latitude
40.69171142578125
Passenger Count
1
Trip Distance
2.09
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-01T01:34:51.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:51.000
Lpep Dropoff Datetime
2016-01-01T01:45:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.907402038574219
Pickup Latitude
40.753559112548828
Dropoff Longitude
-73.887306213378906
Dropoff Latitude
40.738235473632813
Passenger Count
1
Trip Distance
2.04
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-01T01:39:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:58.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:39:56.000
Lpep Dropoff Datetime
2016-01-01T01:44:58.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.991050720214844
Pickup Latitude
40.667415618896484
Dropoff Longitude
-73.978538513183594
Dropoff Latitude
40.683872222900391
Passenger Count
1
Trip Distance
1.37
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.34
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
10.14
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:27:02.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:27:02.000
Lpep Dropoff Datetime
2016-01-01T01:45:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.867477416992188
Pickup Latitude
40.865272521972656
Dropoff Longitude
-73.908828735351563
Dropoff Latitude
40.843753814697266
Passenger Count
1
Trip Distance
5.50
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-01T01:40:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:33.000
Lpep Dropoff Datetime
2016-01-01T01:44:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943252563476562
Pickup Latitude
40.707233428955078
Dropoff Longitude
-73.941398620605469
Dropoff Latitude
40.700103759765625
Passenger Count
1
Trip Distance
0.51
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-01T01:30:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:07.000
Lpep Dropoff Datetime
2016-01-01T01:45:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990707397460938
Pickup Latitude
40.692493438720703
Dropoff Longitude
-73.956718444824219
Dropoff Latitude
40.720718383789063
Passenger Count
1
Trip Distance
3.74
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-01T01:29:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:39.000
Lpep Dropoff Datetime
2016-01-01T01:45:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992576599121094
Pickup Latitude
40.683486938476563
Dropoff Longitude
-74.002365112304687
Dropoff Latitude
40.72796630859375
Passenger Count
3
Trip Distance
3.74
Fare Amount
14.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.16
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.96
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:27:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:27:34.000
Lpep Dropoff Datetime
2016-01-01T01:45:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95428466796875
Pickup Latitude
40.800621032714844
Dropoff Longitude
-73.913772583007812
Dropoff Latitude
40.807777404785156
Passenger Count
1
Trip Distance
3.10
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-01T01:38:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:38:25.000
Lpep Dropoff Datetime
2016-01-01T01:45:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924774169921875
Pickup Latitude
40.744098663330078
Dropoff Longitude
-73.904205322265625
Dropoff Latitude
40.745033264160156
Passenger Count
1
Trip Distance
1.21
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-01T01:41:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:25.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:10.000
Lpep Dropoff Datetime
2016-01-01T01:45:25.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.867523193359375
Pickup Latitude
40.731170654296875
Dropoff Longitude
-73.852210998535156
Dropoff Latitude
40.728321075439453
Passenger Count
1
Trip Distance
1.20
Fare Amount
6
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:12:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:12:11.000
Lpep Dropoff Datetime
2016-01-01T01:45:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966537475585937
Pickup Latitude
40.691848754882813
Dropoff Longitude
-73.922775268554688
Dropoff Latitude
40.701351165771484
Passenger Count
1
Trip Distance
6.01
Fare Amount
24
Extra
0.5
Mta Tax
0.5
Tip Amount
7.59
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
32.89
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:37:58.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:58.000
Lpep Dropoff Datetime
2016-01-01T01:45:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954704284667969
Pickup Latitude
40.732551574707031
Dropoff Longitude
-73.954872131347656
Dropoff Latitude
40.720382690429687
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-01T01:26:33.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:26:33.000
Lpep Dropoff Datetime
2016-01-01T01:45:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95849609375
Pickup Latitude
40.710147857666016
Dropoff Longitude
-73.915496826171875
Dropoff Latitude
40.685661315917969
Passenger Count
1
Trip Distance
3.05
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:21.000
Lpep Dropoff Datetime
2016-01-01T01:45:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807640075683594
Pickup Latitude
40.700313568115234
Dropoff Longitude
-73.797904968261719
Dropoff Latitude
40.695053100585937
Passenger Count
1
Trip Distance
0.87
Fare Amount
5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.58
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.88
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:31:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:31:43.000
Lpep Dropoff Datetime
2016-01-01T01:45:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.895591735839844
Pickup Latitude
40.746372222900391
Dropoff Longitude
-73.911506652832031
Dropoff Latitude
40.712413787841797
Passenger Count
1
Trip Distance
3.04
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-01T01:40:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:45.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:40:38.000
Lpep Dropoff Datetime
2016-01-01T01:45:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.977729797363281
Pickup Latitude
40.684432983398437
Dropoff Longitude
-73.965080261230469
Dropoff Latitude
40.684219360351563
Passenger Count
1
Trip Distance
1.21
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-01T01:28:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:28:14.000
Lpep Dropoff Datetime
2016-01-01T01:45:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.965629577636719
Pickup Latitude
40.710514068603516
Dropoff Longitude
-74.013336181640625
Dropoff Latitude
40.703601837158203
Passenger Count
1
Trip Distance
5.65
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
4.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
24.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:23:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:02.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:23:47.000
Lpep Dropoff Datetime
2016-01-01T01:45:02.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.015510559082031
Pickup Latitude
40.646408081054688
Dropoff Longitude
-73.978073120117187
Dropoff Latitude
40.725376129150391
Passenger Count
1
Trip Distance
7.88
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:20:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:20:49.000
Lpep Dropoff Datetime
2016-01-01T01:45:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920143127441406
Pickup Latitude
40.768375396728516
Dropoff Longitude
-73.841835021972656
Dropoff Latitude
40.691810607910156
Passenger Count
1
Trip Distance
10.92
Fare Amount
32.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:32:25.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:32:25.000
Lpep Dropoff Datetime
2016-01-01T01:45:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.983856201171875
Pickup Latitude
40.672016143798828
Dropoff Longitude
-73.988471984863281
Dropoff Latitude
40.697910308837891
Passenger Count
1
Trip Distance
2.37
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-01T01:33:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:14.000
Lpep Dropoff Datetime
2016-01-01T01:44:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938278198242187
Pickup Latitude
40.843093872070313
Dropoff Longitude
-73.920249938964844
Dropoff Latitude
40.860862731933594
Passenger Count
1
Trip Distance
2.23
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-01T01:24:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:06.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:24:23.000
Lpep Dropoff Datetime
2016-01-01T01:45:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.907447814941406
Pickup Latitude
40.826854705810547
Dropoff Longitude
-73.900932312011719
Dropoff Latitude
40.852893829345703
Passenger Count
1
Trip Distance
2.66
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-01T01:31:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:30.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:31:14.000
Lpep Dropoff Datetime
2016-01-01T01:45:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.943534851074219
Pickup Latitude
40.727588653564453
Dropoff Longitude
-73.934394836425781
Dropoff Latitude
40.698493957519531
Passenger Count
1
Trip Distance
2.24
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-01T01:27:11.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:48.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:27:11.000
Lpep Dropoff Datetime
2016-01-01T01:45:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9893798828125
Pickup Latitude
40.688667297363281
Dropoff Longitude
-73.979324340820313
Dropoff Latitude
40.734806060791016
Passenger Count
1
Trip Distance
6.17
Fare Amount
20
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:29:05.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:05.000
Lpep Dropoff Datetime
2016-01-01T01:45:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.906364440917969
Pickup Latitude
40.823528289794922
Dropoff Longitude
-73.938079833984375
Dropoff Latitude
40.847232818603516
Passenger Count
1
Trip Distance
3.34
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-01T01:23:24.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:23:24.000
Lpep Dropoff Datetime
2016-01-01T01:45:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.966423034667969
Pickup Latitude
40.713031768798828
Dropoff Longitude
-73.98577880859375
Dropoff Latitude
40.661159515380859
Passenger Count
1
Trip Distance
7.37
Fare Amount
24.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
25.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:32:38.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:51.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:32:38.000
Lpep Dropoff Datetime
2016-01-01T01:45:51.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952293395996094
Pickup Latitude
40.714431762695313
Dropoff Longitude
-73.887420654296875
Dropoff Latitude
40.743625640869141
Passenger Count
1
Trip Distance
4.29
Fare Amount
15
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:36:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:08.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:36:03.000
Lpep Dropoff Datetime
2016-01-01T01:45:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964012145996094
Pickup Latitude
40.710559844970703
Dropoff Longitude
-73.955429077148438
Dropoff Latitude
40.677730560302734
Passenger Count
3
Trip Distance
2.63
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-01T01:45:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:10.000
Lpep Dropoff Datetime
2016-01-01T01:45:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.91302490234375
Pickup Latitude
40.756206512451172
Dropoff Longitude
-73.913177490234375
Dropoff Latitude
40.75628662109375
Passenger Count
1
Trip Distance
0.01
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-01T01:19:35.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:31.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:19:35.000
Lpep Dropoff Datetime
2016-01-01T01:45:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945907592773437
Pickup Latitude
40.692001342773437
Dropoff Longitude
-73.934654235839844
Dropoff Latitude
40.680923461914063
Passenger Count
1
Trip Distance
4.21
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-01T01:41:36.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:38.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:41:36.000
Lpep Dropoff Datetime
2016-01-01T01:45:38.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.904548645019531
Pickup Latitude
40.74517822265625
Dropoff Longitude
-73.891464233398437
Dropoff Latitude
40.746570587158203
Passenger Count
1
Trip Distance
0.73
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-01T01:45:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:42.000
Lpep Dropoff Datetime
2016-01-01T01:45:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941307067871094
Pickup Latitude
40.80755615234375
Dropoff Longitude
-73.94183349609375
Dropoff Latitude
40.806133270263672
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-01T01:45:41.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:41.000
Lpep Dropoff Datetime
2016-01-01T01:45:43.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.94378662109375
Pickup Latitude
40.795413970947266
Dropoff Longitude
-73.943794250488281
Dropoff Latitude
40.795402526855469
Passenger Count
2
Trip Distance
0.00
Fare Amount
35
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
35
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:33:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:19.000
Lpep Dropoff Datetime
2016-01-01T01:45:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960044860839844
Pickup Latitude
40.658794403076172
Dropoff Longitude
-73.949752807617188
Dropoff Latitude
40.694568634033203
Passenger Count
1
Trip Distance
3.03
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-01T01:01:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:14:00.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:01:47.000
Lpep Dropoff Datetime
2016-01-01T01:14:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981254577636719
Pickup Latitude
40.684597015380859
Dropoff Longitude
-73.942405700683594
Dropoff Latitude
40.687934875488281
Passenger Count
1
Trip Distance
2.27
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-01T01:22:03.000 • Lpep Dropoff Datetime: 2016-01-01T01:46:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:22:03.000
Lpep Dropoff Datetime
2016-01-01T01:46:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.837326049804688
Pickup Latitude
40.649276733398437
Dropoff Longitude
-73.785476684570313
Dropoff Latitude
40.738063812255859
Passenger Count
1
Trip Distance
12.56
Fare Amount
35
Extra
0.5
Mta Tax
0.5
Tip Amount
10.89
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
47.19
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:27:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:50.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:27:39.000
Lpep Dropoff Datetime
2016-01-01T01:45:50.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941162109375
Pickup Latitude
40.712726593017578
Dropoff Longitude
-73.786827087402344
Dropoff Latitude
40.717041015625
Passenger Count
1
Trip Distance
10.98
Fare Amount
30.5
Extra
0.5
Mta Tax
0.5
Tip Amount
6.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
38.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:37:39.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:37:39.000
Lpep Dropoff Datetime
2016-01-01T01:45:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963218688964844
Pickup Latitude
40.676498413085938
Dropoff Longitude
-73.974494934082031
Dropoff Latitude
40.680046081542969
Passenger Count
5
Trip Distance
0.59
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-01T01:17:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:17:23.000
Lpep Dropoff Datetime
2016-01-01T01:44:39.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.846649169921875
Pickup Latitude
40.690536499023438
Dropoff Longitude
-73.865257263183594
Dropoff Latitude
40.755458831787109
Passenger Count
1
Trip Distance
5.44
Fare Amount
21.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
22.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:29:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:46:03.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:29:43.000
Lpep Dropoff Datetime
2016-01-01T01:46:03.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.90057373046875
Pickup Latitude
40.777301788330078
Dropoff Longitude
-73.801849365234375
Dropoff Latitude
40.706218719482422
Passenger Count
1
Trip Distance
9.50
Fare Amount
27.5
Extra
0.5
Mta Tax
0.5
Tip Amount
5.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.56
Payment Type
1
Trip Type
1
NYC Data AI • Public-data exploration interface