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:44:09.000 • Lpep Dropoff Datetime: 2016-01-01T02:15:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:09.000
Lpep Dropoff Datetime
2016-01-01T02:15:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962661743164063
Pickup Latitude
40.710090637207031
Dropoff Longitude
-73.871589660644531
Dropoff Latitude
40.719692230224609
Passenger Count
1
Trip Distance
6.55
Fare Amount
25
Extra
0.5
Mta Tax
0.5
Tip Amount
1
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:28:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:22.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:28:04.000
Lpep Dropoff Datetime
2016-01-01T01:44:22.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954170227050781
Pickup Latitude
40.787334442138672
Dropoff Longitude
-73.9481201171875
Dropoff Latitude
40.829425811767578
Passenger Count
1
Trip Distance
3.78
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:34:04.000 • Lpep Dropoff Datetime: 2016-01-01T01:44:26.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:04.000
Lpep Dropoff Datetime
2016-01-01T01:44:26.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986236572265625
Pickup Latitude
40.689006805419922
Dropoff Longitude
-73.953018188476563
Dropoff Latitude
40.713939666748047
Passenger Count
1
Trip Distance
4.63
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:26:49.000 • Lpep Dropoff Datetime: 2016-01-01T01:33:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:26:49.000
Lpep Dropoff Datetime
2016-01-01T01:33:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917701721191406
Pickup Latitude
40.825298309326172
Dropoff Longitude
-73.90521240234375
Dropoff Latitude
40.823158264160156
Passenger Count
1
Trip Distance
0.70
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:56.000 • Lpep Dropoff Datetime: 2016-01-01T02:46:33.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:56.000
Lpep Dropoff Datetime
2016-01-01T02:46:33.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915420532226562
Pickup Latitude
40.699863433837891
Dropoff Longitude
-73.980216979980469
Dropoff Latitude
40.742702484130859
Passenger Count
1
Trip Distance
7.43
Fare Amount
34
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:54:45.000 • Lpep Dropoff Datetime: 2016-01-01T02:46:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:54:45.000
Lpep Dropoff Datetime
2016-01-01T02:46:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948036193847656
Pickup Latitude
40.801311492919922
Dropoff Longitude
-74.074195861816406
Dropoff Latitude
40.728946685791016
Passenger Count
2
Trip Distance
12.62
Fare Amount
42.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
10.5
Improvement Surcharge
0.3
Total Amount
54.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:51:38.000 • Lpep Dropoff Datetime: 2016-01-01T02:47:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:38.000
Lpep Dropoff Datetime
2016-01-01T02:47:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948486328125
Pickup Latitude
40.753944396972656
Dropoff Longitude
-73.803985595703125
Dropoff Latitude
40.589305877685547
Passenger Count
3
Trip Distance
17.00
Fare Amount
56.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
2.08
Improvement Surcharge
0.3
Total Amount
59.88
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:51:38.000 • Lpep Dropoff Datetime: 2016-01-01T02:47:36.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:51:38.000
Lpep Dropoff Datetime
2016-01-01T02:47:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.951568603515625
Pickup Latitude
40.7303466796875
Dropoff Longitude
-73.983055114746094
Dropoff Latitude
40.784152984619141
Passenger Count
1
Trip Distance
13.04
Fare Amount
46
Extra
0.5
Mta Tax
0.5
Tip Amount
12
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
59.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:50:49.000 • Lpep Dropoff Datetime: 2016-01-01T02:13:14.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:49.000
Lpep Dropoff Datetime
2016-01-01T02:13:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.995742797851563
Pickup Latitude
40.690525054931641
Dropoff Longitude
-73.995689392089844
Dropoff Latitude
40.690570831298828
Passenger Count
1
Trip Distance
1.07
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3.82
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
19.12
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:22:48.000 • Lpep Dropoff Datetime: 2016-01-01T01:49:34.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:22:48.000
Lpep Dropoff Datetime
2016-01-01T01:49:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.963272094726562
Pickup Latitude
40.679256439208984
Dropoff Longitude
-73.958023071289062
Dropoff Latitude
40.634231567382813
Passenger Count
1
Trip Distance
5.33
Fare Amount
20.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:35:10.000 • Lpep Dropoff Datetime: 2016-01-01T01:49:59.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:10.000
Lpep Dropoff Datetime
2016-01-01T01:49:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917381286621094
Pickup Latitude
40.840206146240234
Dropoff Longitude
-73.919090270996094
Dropoff Latitude
40.861095428466797
Passenger Count
1
Trip Distance
2.92
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-01T01:58:52.000 • Lpep Dropoff Datetime: 2016-01-01T02:50:29.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:58:52.000
Lpep Dropoff Datetime
2016-01-01T02:50:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.99359130859375
Pickup Latitude
40.668296813964844
Dropoff Longitude
-73.958602905273437
Dropoff Latitude
40.810165405273437
Passenger Count
1
Trip Distance
12.09
Fare Amount
41.5
Extra
0.5
Mta Tax
0.5
Tip Amount
8.56
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
51.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:50:44.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:07.000
Lpep Dropoff Datetime
2016-01-01T01:50:44.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.915870666503906
Pickup Latitude
40.764366149902344
Dropoff Longitude
-73.901748657226563
Dropoff Latitude
40.769767761230469
Passenger Count
1
Trip Distance
1.26
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1
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-01T01:55:53.000 • Lpep Dropoff Datetime: 2016-01-01T02:50:54.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:53.000
Lpep Dropoff Datetime
2016-01-01T02:50:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948631286621094
Pickup Latitude
40.751247406005859
Dropoff Longitude
-73.707931518554688
Dropoff Latitude
40.842838287353516
Passenger Count
1
Trip Distance
22.77
Fare Amount
65.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
66.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:30:43.000 • Lpep Dropoff Datetime: 2016-01-01T02:51:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:30:43.000
Lpep Dropoff Datetime
2016-01-01T02:51:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.813026428222656
Pickup Latitude
40.718837738037109
Dropoff Longitude
-73.92816162109375
Dropoff Latitude
40.743961334228516
Passenger Count
2
Trip Distance
0.00
Fare Amount
2.5
Extra
0.5
Mta Tax
0.5
Tip Amount
67
Tolls Amount
0
Improvement Surcharge
0
Total Amount
70.5
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:36:48.000 • Lpep Dropoff Datetime: 2016-01-01T02:52:39.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:36:48.000
Lpep Dropoff Datetime
2016-01-01T02:52:39.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.905220031738281
Pickup Latitude
40.839733123779297
Dropoff Longitude
-73.952308654785156
Dropoff Latitude
40.824012756347656
Passenger Count
1
Trip Distance
20.07
Fare Amount
50
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
50
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:14.000 • Lpep Dropoff Datetime: 2016-01-01T01:53:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:14.000
Lpep Dropoff Datetime
2016-01-01T01:53:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954727172851563
Pickup Latitude
40.718700408935547
Dropoff Longitude
-73.944305419921875
Dropoff Latitude
40.700286865234375
Passenger Count
1
Trip Distance
1.71
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-01T01:59:07.000 • Lpep Dropoff Datetime: 2016-01-01T02:53:13.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:07.000
Lpep Dropoff Datetime
2016-01-01T02:53:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.969215393066406
Pickup Latitude
40.693187713623047
Dropoff Longitude
-73.947090148925781
Dropoff Latitude
40.837333679199219
Passenger Count
1
Trip Distance
12.33
Fare Amount
44.5
Extra
0.5
Mta Tax
0.5
Tip Amount
11.45
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
57.25
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:18.000 • Lpep Dropoff Datetime: 2016-01-01T01:55:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:18.000
Lpep Dropoff Datetime
2016-01-01T01:55:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953018188476563
Pickup Latitude
40.713958740234375
Dropoff Longitude
-73.999847412109375
Dropoff Latitude
40.68353271484375
Passenger Count
1
Trip Distance
4.90
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
3.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:33:50.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:33:50.000
Lpep Dropoff Datetime
2016-01-01T01:56:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95733642578125
Pickup Latitude
40.726726531982422
Dropoff Longitude
-73.919670104980469
Dropoff Latitude
40.770469665527344
Passenger Count
3
Trip Distance
4.91
Fare Amount
19
Extra
0.5
Mta Tax
0.5
Tip Amount
3
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:56:28.000 • Lpep Dropoff Datetime: 2016-01-01T02:56:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:28.000
Lpep Dropoff Datetime
2016-01-01T02:56:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.883430480957031
Pickup Latitude
40.747756958007813
Dropoff Longitude
-73.99578857421875
Dropoff Latitude
40.764484405517578
Passenger Count
1
Trip Distance
7.20
Fare Amount
38
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
39.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:44:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:56:52.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:44:21.000
Lpep Dropoff Datetime
2016-01-01T01:56:52.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.912582397460938
Pickup Latitude
40.766918182373047
Dropoff Longitude
-73.889686584472656
Dropoff Latitude
40.734512329101563
Passenger Count
1
Trip Distance
3.14
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-01T01:50:03.000 • Lpep Dropoff Datetime: 2016-01-01T02:55:05.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:50:03.000
Lpep Dropoff Datetime
2016-01-01T02:55:05.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.904159545898437
Pickup Latitude
40.750057220458984
Dropoff Longitude
-73.857635498046875
Dropoff Latitude
40.736808776855469
Passenger Count
1
Trip Distance
15.50
Fare Amount
54.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
55.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:53:54.000 • Lpep Dropoff Datetime: 2016-01-01T02:57:49.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:54.000
Lpep Dropoff Datetime
2016-01-01T02:57:49.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958854675292969
Pickup Latitude
40.809886932373047
Dropoff Longitude
-73.993423461914062
Dropoff Latitude
40.678249359130859
Passenger Count
1
Trip Distance
16.71
Fare Amount
56
Extra
0.5
Mta Tax
0.5
Tip Amount
17.19
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
74.49
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:45:42.000 • Lpep Dropoff Datetime: 2016-01-01T01:58:46.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:45:42.000
Lpep Dropoff Datetime
2016-01-01T01:58:46.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953971862792969
Pickup Latitude
40.673702239990234
Dropoff Longitude
-73.946914672851563
Dropoff Latitude
40.678699493408203
Passenger Count
1
Trip Distance
1.54
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:21:56.000 • Lpep Dropoff Datetime: 2016-01-01T01:59:24.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:21:56.000
Lpep Dropoff Datetime
2016-01-01T01:59:24.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.011199951171875
Pickup Latitude
40.675216674804687
Dropoff Longitude
-73.876838684082031
Dropoff Latitude
40.673473358154297
Passenger Count
1
Trip Distance
8.71
Fare Amount
30
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:59:21.000 • Lpep Dropoff Datetime: 2016-01-01T02:58:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:21.000
Lpep Dropoff Datetime
2016-01-01T02:58:43.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.79974365234375
Pickup Latitude
40.978057861328125
Dropoff Longitude
-73.857040405273437
Dropoff Latitude
40.908329010009766
Passenger Count
1
Trip Distance
0.00
Fare Amount
7
Extra
0
Mta Tax
0
Tip Amount
1.4
Tolls Amount
0
Improvement Surcharge
0
Total Amount
8.4
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:02:00.000 • Lpep Dropoff Datetime: 2016-01-01T01:16:57.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:02:00.000
Lpep Dropoff Datetime
2016-01-01T01:16:57.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.986923217773437
Pickup Latitude
40.692405700683594
Dropoff Longitude
-74.011154174804687
Dropoff Latitude
40.67523193359375
Passenger Count
1
Trip Distance
2.83
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-01T01:42:43.000 • Lpep Dropoff Datetime: 2016-01-01T02:59:19.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:43.000
Lpep Dropoff Datetime
2016-01-01T02:59:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.851753234863281
Pickup Latitude
40.850238800048828
Dropoff Longitude
-74.0989990234375
Dropoff Latitude
40.612701416015625
Passenger Count
1
Trip Distance
30.35
Fare Amount
90
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
16.62
Improvement Surcharge
0.3
Total Amount
107.92
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:42:15.000 • Lpep Dropoff Datetime: 2016-01-01T02:55:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:42:15.000
Lpep Dropoff Datetime
2016-01-01T02:55:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938392639160156
Pickup Latitude
40.850799560546875
Dropoff Longitude
-73.949386596679688
Dropoff Latitude
40.676101684570313
Passenger Count
1
Trip Distance
20.78
Fare Amount
69
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
5.54
Improvement Surcharge
0.3
Total Amount
75.84
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:57:12.000 • Lpep Dropoff Datetime: 2016-01-01T02:04:27.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:57:12.000
Lpep Dropoff Datetime
2016-01-01T02:04:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924819946289063
Pickup Latitude
40.861713409423828
Dropoff Longitude
-73.934219360351563
Dropoff Latitude
40.848731994628906
Passenger Count
1
Trip Distance
1.21
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:53:45.000 • Lpep Dropoff Datetime: 2016-01-01T02:03:43.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:53:45.000
Lpep Dropoff Datetime
2016-01-01T02:03:43.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.908218383789063
Pickup Latitude
40.771232604980469
Dropoff Longitude
-73.890609741210937
Dropoff Latitude
40.751243591308594
Passenger Count
1
Trip Distance
2.22
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
5
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-01T01:59:29.000 • Lpep Dropoff Datetime: 2016-01-01T02:11:09.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:29.000
Lpep Dropoff Datetime
2016-01-01T02:11:09.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.948814392089844
Pickup Latitude
40.710910797119141
Dropoff Longitude
-73.9598388671875
Dropoff Latitude
40.692001342773437
Passenger Count
1
Trip Distance
2.06
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-01T01:59:52.000 • Lpep Dropoff Datetime: 2016-01-01T02:14:12.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:59:52.000
Lpep Dropoff Datetime
2016-01-01T02:14:12.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.997634887695312
Pickup Latitude
40.682880401611328
Dropoff Longitude
-73.986717224121094
Dropoff Latitude
40.724269866943359
Passenger Count
1
Trip Distance
3.91
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:52:51.000 • Lpep Dropoff Datetime: 2016-01-01T02:30:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:52:51.000
Lpep Dropoff Datetime
2016-01-01T02:30:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955406188964844
Pickup Latitude
40.819866180419922
Dropoff Longitude
-74.004768371582031
Dropoff Latitude
40.712306976318359
Passenger Count
1
Trip Distance
9.81
Fare Amount
34
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
35.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:55:21.000 • Lpep Dropoff Datetime: 2016-01-01T02:03:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:55:21.000
Lpep Dropoff Datetime
2016-01-01T02:03:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.829689025878906
Pickup Latitude
40.713615417480469
Dropoff Longitude
-73.8135986328125
Dropoff Latitude
40.672256469726562
Passenger Count
1
Trip Distance
3.96
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
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:25:45.000 • Lpep Dropoff Datetime: 2016-01-01T01:53:07.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:25:45.000
Lpep Dropoff Datetime
2016-01-01T01:53:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962440490722656
Pickup Latitude
40.640827178955078
Dropoff Longitude
-73.908164978027344
Dropoff Latitude
40.683403015136719
Passenger Count
1
Trip Distance
5.51
Fare Amount
22
Extra
0.5
Mta Tax
0.5
Tip Amount
3.7
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:35:11.000 • Lpep Dropoff Datetime: 2016-01-01T02:02:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:35:11.000
Lpep Dropoff Datetime
2016-01-01T02:02:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.941886901855469
Pickup Latitude
40.817581176757813
Dropoff Longitude
-73.942764282226562
Dropoff Latitude
40.823116302490234
Passenger Count
1
Trip Distance
1.69
Fare Amount
17
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:00:19.000 • Lpep Dropoff Datetime: 2016-01-01T01:06:55.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:00:19.000
Lpep Dropoff Datetime
2016-01-01T01:06:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.905006408691406
Pickup Latitude
40.839595794677734
Dropoff Longitude
-73.891929626464844
Dropoff Latitude
40.825885772705078
Passenger Count
2
Trip Distance
1.37
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:36:34.000 • Lpep Dropoff Datetime: 2016-01-01T01:52:10.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:36:34.000
Lpep Dropoff Datetime
2016-01-01T01:52:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.897865295410156
Pickup Latitude
40.867488861083984
Dropoff Longitude
-73.851951599121094
Dropoff Latitude
40.84259033203125
Passenger Count
2
Trip Distance
3.46
Fare Amount
14
Extra
0.5
Mta Tax
0.5
Tip Amount
3
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-01T01:56:18.000 • Lpep Dropoff Datetime: 2016-01-01T02:11:32.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:56:18.000
Lpep Dropoff Datetime
2016-01-01T02:11:32.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.85345458984375
Pickup Latitude
40.842582702636719
Dropoff Longitude
-73.914863586425781
Dropoff Latitude
40.830085754394531
Passenger Count
2
Trip Distance
4.89
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-01T01:09:01.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:04.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:09:01.000
Lpep Dropoff Datetime
2016-01-01T01:31:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944435119628906
Pickup Latitude
40.829551696777344
Dropoff Longitude
-73.976318359375
Dropoff Latitude
40.752098083496094
Passenger Count
1
Trip Distance
8.16
Fare Amount
25.5
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
27.3
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2016-01-01T01:00:07.000 • Lpep Dropoff Datetime: 2016-01-01T01:03:11.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:00:07.000
Lpep Dropoff Datetime
2016-01-01T01:03:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.924903869628906
Pickup Latitude
40.761806488037109
Dropoff Longitude
-73.936813354492188
Dropoff Latitude
40.75994873046875
Passenger Count
1
Trip Distance
0.67
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:34:47.000 • Lpep Dropoff Datetime: 2016-01-01T01:34:47.000
Vendorid
2
Lpep Pickup Datetime
2016-01-01T01:34:47.000
Lpep Dropoff Datetime
2016-01-01T01:34:47.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.801254272460938
Pickup Latitude
40.705112457275391
Dropoff Longitude
-73.801216125488281
Dropoff Latitude
40.704990386962891
Passenger Count
1
Trip Distance
53.81
Fare Amount
5
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
5.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:59:55.000 • Lpep Dropoff Datetime: 2016-01-01T02:12:06.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:59:55.000
Lpep Dropoff Datetime
2016-01-01T02:12:06.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.877166748046875
Pickup Latitude
40.73779296875
Dropoff Longitude
-73.901596069335938
Dropoff Latitude
40.755592346191406
Passenger Count
1
Trip Distance
2.10
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.8
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:41:23.000 • Lpep Dropoff Datetime: 2016-01-01T01:53:33.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:41:23.000
Lpep Dropoff Datetime
2016-01-01T01:53:33.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.903472900390625
Pickup Latitude
40.745506286621094
Dropoff Longitude
-73.883003234863281
Dropoff Latitude
40.735973358154297
Passenger Count
1
Trip Distance
2.20
Fare Amount
10.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.15
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:22:54.000 • Lpep Dropoff Datetime: 2016-01-01T01:39:21.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:22:54.000
Lpep Dropoff Datetime
2016-01-01T01:39:21.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.880599975585937
Pickup Latitude
40.748016357421875
Dropoff Longitude
-73.900856018066406
Dropoff Latitude
40.745906829833984
Passenger Count
1
Trip Distance
1.00
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:35:43.000 • Lpep Dropoff Datetime: 2016-01-01T01:45:59.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:35:43.000
Lpep Dropoff Datetime
2016-01-01T01:45:59.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.883293151855469
Pickup Latitude
40.870594024658203
Dropoff Longitude
-73.850822448730469
Dropoff Latitude
40.9036865234375
Passenger Count
4
Trip Distance
4.30
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:13:21.000 • Lpep Dropoff Datetime: 2016-01-01T01:31:28.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:13:21.000
Lpep Dropoff Datetime
2016-01-01T01:31:28.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.916435241699219
Pickup Latitude
40.824871063232422
Dropoff Longitude
-73.887443542480469
Dropoff Latitude
40.870494842529297
Passenger Count
1
Trip Distance
4.10
Fare Amount
16
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
4
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2016-01-01T01:44:46.000 • Lpep Dropoff Datetime: 2016-01-01T02:15:14.000
Vendorid
1
Lpep Pickup Datetime
2016-01-01T01:44:46.000
Lpep Dropoff Datetime
2016-01-01T02:15:14.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.916259765625
Pickup Latitude
40.817085266113281
Dropoff Longitude
-73.89892578125
Dropoff Latitude
40.851318359375
Passenger Count
1
Trip Distance
4.70
Fare Amount
22.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
23.8
Payment Type
2
Trip Type
1
NYC Data AI • Public-data exploration interface