Ask NYC Browse All Data Public Safety Transportation Health Buildings

2015 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 gi8d-wdg5 21 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-27T12:07:55.000 • Lpep Dropoff Datetime: 2015-02-27T12:16:55.000
Vendorid
2
Lpep Pickup Datetime
2015-02-27T12:07:55.000
Lpep Dropoff Datetime
2015-02-27T12:16:55.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.844245910644531
Pickup Latitude
40.721416473388672
Dropoff Longitude
-73.847564697265625
Dropoff Latitude
40.710025787353516
Passenger Count
1
Trip Distance
0.98
Fare Amount
6.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-12T18:48:43.000 • Lpep Dropoff Datetime: 2015-02-12T18:58:29.000
Vendorid
2
Lpep Pickup Datetime
2015-02-12T18:48:43.000
Lpep Dropoff Datetime
2015-02-12T18:58:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944541931152344
Pickup Latitude
40.720706939697266
Dropoff Longitude
-73.946510314941406
Dropoff Latitude
40.748012542724609
Passenger Count
1
Trip Distance
2.16
Fare Amount
9.5
Extra
1
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: 2015-02-04T19:57:27.000 • Lpep Dropoff Datetime: 2015-02-04T20:03:15.000
Vendorid
2
Lpep Pickup Datetime
2015-02-04T19:57:27.000
Lpep Dropoff Datetime
2015-02-04T20:03:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.874114990234375
Pickup Latitude
40.735126495361328
Dropoff Longitude
-73.890190124511719
Dropoff Latitude
40.745479583740234
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: 2015-02-17T22:39:40.000 • Lpep Dropoff Datetime: 2015-02-17T22:49:48.000
Vendorid
2
Lpep Pickup Datetime
2015-02-17T22:39:40.000
Lpep Dropoff Datetime
2015-02-17T22:49:48.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938713073730469
Pickup Latitude
40.804931640625
Dropoff Longitude
-73.928482055664063
Dropoff Latitude
40.856540679931641
Passenger Count
1
Trip Distance
4.58
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: 2015-02-14T15:04:19.000 • Lpep Dropoff Datetime: 2015-02-14T15:25:56.000
Vendorid
2
Lpep Pickup Datetime
2015-02-14T15:04:19.000
Lpep Dropoff Datetime
2015-02-14T15:25:56.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.871238708496094
Pickup Latitude
40.734046936035156
Dropoff Longitude
-73.919647216796875
Dropoff Latitude
40.756172180175781
Passenger Count
1
Trip Distance
3.71
Fare Amount
16.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-22T00:57:38.000 • Lpep Dropoff Datetime: 2015-02-22T01:04:15.000
Vendorid
2
Lpep Pickup Datetime
2015-02-22T00:57:38.000
Lpep Dropoff Datetime
2015-02-22T01:04:15.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.973289489746094
Pickup Latitude
40.678340911865234
Dropoff Longitude
-73.954170227050781
Dropoff Latitude
40.665546417236328
Passenger Count
1
Trip Distance
1.6
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: 2015-02-24T20:17:35.000 • Lpep Dropoff Datetime: 2015-02-24T20:21:00.000
Vendorid
2
Lpep Pickup Datetime
2015-02-24T20:17:35.000
Lpep Dropoff Datetime
2015-02-24T20:21:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960334777832031
Pickup Latitude
40.715686798095703
Dropoff Longitude
-73.966415405273437
Dropoff Latitude
40.713047027587891
Passenger Count
1
Trip Distance
0.67
Fare Amount
4.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.74
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
7.54
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-14T11:50:06.000 • Lpep Dropoff Datetime: 2015-02-14T12:18:07.000
Vendorid
2
Lpep Pickup Datetime
2015-02-14T11:50:06.000
Lpep Dropoff Datetime
2015-02-14T12:18:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.944038391113281
Pickup Latitude
40.821392059326172
Dropoff Longitude
-73.992485046386719
Dropoff Latitude
40.719871520996094
Passenger Count
1
Trip Distance
9.49
Fare Amount
31.5
Extra
0
Mta Tax
0.5
Tip Amount
6.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
38.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-20T23:33:57.000 • Lpep Dropoff Datetime: 2015-02-20T23:44:04.000
Vendorid
2
Lpep Pickup Datetime
2015-02-20T23:33:57.000
Lpep Dropoff Datetime
2015-02-20T23:44:04.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958946228027344
Pickup Latitude
40.708820343017578
Dropoff Longitude
-73.94012451171875
Dropoff Latitude
40.709232330322266
Passenger Count
1
Trip Distance
1.32
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-19T20:17:27.000 • Lpep Dropoff Datetime: 2015-02-19T20:29:36.000
Vendorid
2
Lpep Pickup Datetime
2015-02-19T20:17:27.000
Lpep Dropoff Datetime
2015-02-19T20:29:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.917282104492188
Pickup Latitude
40.761035919189453
Dropoff Longitude
-73.881027221679688
Dropoff Latitude
40.757774353027344
Passenger Count
1
Trip Distance
2.45
Fare Amount
11
Extra
0.5
Mta Tax
0.5
Tip Amount
2.46
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.76
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-19T12:38:13.000 • Lpep Dropoff Datetime: 2015-02-19T13:09:08.000
Vendorid
2
Lpep Pickup Datetime
2015-02-19T12:38:13.000
Lpep Dropoff Datetime
2015-02-19T13:09:08.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.945426940917969
Pickup Latitude
40.812767028808594
Dropoff Longitude
-73.9752197265625
Dropoff Latitude
40.750591278076172
Passenger Count
1
Trip Distance
7.02
Fare Amount
25
Extra
0
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: 2015-02-04T08:37:38.000 • Lpep Dropoff Datetime: 2015-02-04T08:49:23.000
Vendorid
2
Lpep Pickup Datetime
2015-02-04T08:37:38.000
Lpep Dropoff Datetime
2015-02-04T08:49:23.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952339172363281
Pickup Latitude
40.786365509033203
Dropoff Longitude
-73.968841552734375
Dropoff Latitude
40.785602569580078
Passenger Count
1
Trip Distance
1.3
Fare Amount
9
Extra
0
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: 2015-02-14T11:14:20.000 • Lpep Dropoff Datetime: 2015-02-14T11:33:10.000
Vendorid
2
Lpep Pickup Datetime
2015-02-14T11:14:20.000
Lpep Dropoff Datetime
2015-02-14T11:33:10.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920875549316406
Pickup Latitude
40.756679534912109
Dropoff Longitude
-73.98248291015625
Dropoff Latitude
40.756759643554687
Passenger Count
2
Trip Distance
4.2
Fare Amount
16.5
Extra
0
Mta Tax
0.5
Tip Amount
4.32
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.62
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-01T12:23:38.000 • Lpep Dropoff Datetime: 2015-02-01T12:36:21.000
Vendorid
1
Lpep Pickup Datetime
2015-02-01T12:23:38.000
Lpep Dropoff Datetime
2015-02-01T12:36:21.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.954498291015625
Pickup Latitude
40.731422424316406
Dropoff Longitude
-73.974723815917969
Dropoff Latitude
40.742000579833984
Passenger Count
1
Trip Distance
3.2
Fare Amount
13
Extra
0
Mta Tax
0.5
Tip Amount
5.7
Tolls Amount
5.33
Improvement Surcharge
0.3
Total Amount
24.83
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-05T07:04:29.000 • Lpep Dropoff Datetime: 2015-02-05T07:34:47.000
Vendorid
2
Lpep Pickup Datetime
2015-02-05T07:04:29.000
Lpep Dropoff Datetime
2015-02-05T07:34:47.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-74.023414611816406
Pickup Latitude
40.634735107421875
Dropoff Longitude
-73.945793151855469
Dropoff Latitude
40.711540222167969
Passenger Count
1
Trip Distance
8.01
Fare Amount
27.5
Extra
0
Mta Tax
0.5
Tip Amount
6
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
34.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-14T15:31:22.000 • Lpep Dropoff Datetime: 2015-02-14T15:38:30.000
Vendorid
1
Lpep Pickup Datetime
2015-02-14T15:31:22.000
Lpep Dropoff Datetime
2015-02-14T15:38:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.95501708984375
Pickup Latitude
40.799339294433594
Dropoff Longitude
-73.941947937011719
Dropoff Latitude
40.817726135253906
Passenger Count
1
Trip Distance
1.4
Fare Amount
7.5
Extra
0
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: 2015-02-09T22:39:11.000 • Lpep Dropoff Datetime: 2015-02-09T22:53:36.000
Vendorid
2
Lpep Pickup Datetime
2015-02-09T22:39:11.000
Lpep Dropoff Datetime
2015-02-09T22:53:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.942268371582031
Pickup Latitude
40.841632843017578
Dropoff Longitude
-73.966903686523438
Dropoff Latitude
40.793815612792969
Passenger Count
1
Trip Distance
5.25
Fare Amount
17.5
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
20.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-11T13:27:22.000 • Lpep Dropoff Datetime: 2015-01-11T13:52:07.000
Vendorid
2
Lpep Pickup Datetime
2015-01-11T13:27:22.000
Lpep Dropoff Datetime
2015-01-11T13:52:07.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.992439270019531
Pickup Latitude
40.694145202636719
Dropoff Longitude
-73.977210998535156
Dropoff Latitude
40.763053894042969
Passenger Count
1
Trip Distance
7.49
Fare Amount
26
Extra
0
Mta Tax
0.5
Tip Amount
3
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
29.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-24T14:16:18.000 • Lpep Dropoff Datetime: 2015-02-24T14:22:45.000
Vendorid
2
Lpep Pickup Datetime
2015-02-24T14:16:18.000
Lpep Dropoff Datetime
2015-02-24T14:22:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.960006713867188
Pickup Latitude
40.656230926513672
Dropoff Longitude
-73.971733093261719
Dropoff Latitude
40.67620849609375
Passenger Count
1
Trip Distance
1.52
Fare Amount
7.5
Extra
0
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: 2015-02-15T19:11:10.000 • Lpep Dropoff Datetime: 2015-02-15T19:52:17.000
Vendorid
2
Lpep Pickup Datetime
2015-02-15T19:11:10.000
Lpep Dropoff Datetime
2015-02-15T19:52:17.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.962783813476563
Pickup Latitude
40.659767150878906
Dropoff Longitude
-73.776527404785156
Dropoff Latitude
40.645130157470703
Passenger Count
1
Trip Distance
11.94
Fare Amount
39.5
Extra
0
Mta Tax
0.5
Tip Amount
10.08
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
50.38
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-17T21:13:59.000 • Lpep Dropoff Datetime: 2015-02-17T21:17:40.000
Vendorid
2
Lpep Pickup Datetime
2015-02-17T21:13:59.000
Lpep Dropoff Datetime
2015-02-17T21:17:40.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.862579345703125
Pickup Latitude
40.729747772216797
Dropoff Longitude
-73.849609375
Dropoff Latitude
40.729240417480469
Passenger Count
1
Trip Distance
0.8
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-24T09:29:02.000 • Lpep Dropoff Datetime: 2015-02-24T09:34:18.000
Vendorid
1
Lpep Pickup Datetime
2015-02-24T09:29:02.000
Lpep Dropoff Datetime
2015-02-24T09:34:18.000
Store And Fwd Flag
Y
Ratecodeid
1
Pickup Longitude
-73.950874328613281
Pickup Latitude
40.785888671875
Dropoff Longitude
-73.954010009765625
Dropoff Latitude
40.790214538574219
Passenger Count
1
Trip Distance
0.7
Fare Amount
5.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
6.3
Payment Type
4
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-25T08:02:03.000 • Lpep Dropoff Datetime: 2015-02-25T08:10:41.000
Vendorid
1
Lpep Pickup Datetime
2015-02-25T08:02:03.000
Lpep Dropoff Datetime
2015-02-25T08:10:41.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.849594116210937
Pickup Latitude
40.826061248779297
Dropoff Longitude
-73.850967407226563
Dropoff Latitude
40.838722229003906
Passenger Count
1
Trip Distance
1.1
Fare Amount
7
Extra
0
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: 2015-02-18T07:40:07.000 • Lpep Dropoff Datetime: 2015-02-18T07:45:13.000
Vendorid
2
Lpep Pickup Datetime
2015-02-18T07:40:07.000
Lpep Dropoff Datetime
2015-02-18T07:45:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.93768310546875
Pickup Latitude
40.848373413085938
Dropoff Longitude
-73.931968688964844
Dropoff Latitude
40.857872009277344
Passenger Count
1
Trip Distance
0.76
Fare Amount
5
Extra
0
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: 2015-02-08T06:19:54.000 • Lpep Dropoff Datetime: 2015-02-08T06:37:11.000
Vendorid
2
Lpep Pickup Datetime
2015-02-08T06:19:54.000
Lpep Dropoff Datetime
2015-02-08T06:37:11.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.958702087402344
Pickup Latitude
40.733360290527344
Dropoff Longitude
-73.939476013183594
Dropoff Latitude
40.705368041992188
Passenger Count
1
Trip Distance
3.39
Fare Amount
14.5
Extra
0
Mta Tax
0.5
Tip Amount
3.06
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
18.36
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-18T14:21:23.000 • Lpep Dropoff Datetime: 2015-02-18T14:26:30.000
Vendorid
2
Lpep Pickup Datetime
2015-02-18T14:21:23.000
Lpep Dropoff Datetime
2015-02-18T14:26:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.970306396484375
Pickup Latitude
40.689525604248047
Dropoff Longitude
-73.980537414550781
Dropoff Latitude
40.689895629882813
Passenger Count
1
Trip Distance
0.88
Fare Amount
5.5
Extra
0
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: 2015-02-27T02:26:59.000 • Lpep Dropoff Datetime: 2015-02-27T02:33:06.000
Vendorid
2
Lpep Pickup Datetime
2015-02-27T02:26:59.000
Lpep Dropoff Datetime
2015-02-27T02:33:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.955711364746094
Pickup Latitude
40.81402587890625
Dropoff Longitude
-73.954475402832031
Dropoff Latitude
40.800815582275391
Passenger Count
1
Trip Distance
1.06
Fare Amount
6.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.2
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-13T11:02:08.000 • Lpep Dropoff Datetime: 2015-02-13T11:13:01.000
Vendorid
2
Lpep Pickup Datetime
2015-02-13T11:02:08.000
Lpep Dropoff Datetime
2015-02-13T11:13:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.803543090820312
Pickup Latitude
40.717071533203125
Dropoff Longitude
-73.808555603027344
Dropoff Latitude
40.685394287109375
Passenger Count
1
Trip Distance
3.15
Fare Amount
12.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-01-24T21:02:31.000 • Lpep Dropoff Datetime: 2015-01-24T21:08:00.000
Vendorid
1
Lpep Pickup Datetime
2015-01-24T21:02:31.000
Lpep Dropoff Datetime
2015-01-24T21:08:00.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.953216552734375
Pickup Latitude
40.791000366210937
Dropoff Longitude
-73.974411010742188
Dropoff Latitude
40.7835693359375
Passenger Count
1
Trip Distance
1.7
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.5
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-22T18:29:09.000 • Lpep Dropoff Datetime: 2015-02-22T18:51:56.000
Vendorid
2
Lpep Pickup Datetime
2015-02-22T18:29:09.000
Lpep Dropoff Datetime
2015-02-22T18:51:56.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.806953430175781
Pickup Latitude
40.698902130126953
Dropoff Longitude
-73.851852416992188
Dropoff Latitude
40.833305358886719
Passenger Count
6
Trip Distance
11.9
Fare Amount
60
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
60
Payment Type
1
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-04T00:14:23.000 • Lpep Dropoff Datetime: 2015-01-04T00:24:36.000
Vendorid
2
Lpep Pickup Datetime
2015-01-04T00:14:23.000
Lpep Dropoff Datetime
2015-01-04T00:24:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.923171997070313
Pickup Latitude
40.817539215087891
Dropoff Longitude
-73.918472290039063
Dropoff Latitude
40.838100433349609
Passenger Count
1
Trip Distance
1.77
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: 2015-02-26T08:00:24.000 • Lpep Dropoff Datetime: 2015-02-26T08:16:29.000
Vendorid
2
Lpep Pickup Datetime
2015-02-26T08:00:24.000
Lpep Dropoff Datetime
2015-02-26T08:16:29.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.807914733886719
Pickup Latitude
40.700550079345703
Dropoff Longitude
-73.779884338378906
Dropoff Latitude
40.666538238525391
Passenger Count
1
Trip Distance
2.87
Fare Amount
13
Extra
0
Mta Tax
0.5
Tip Amount
2.76
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
16.56
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-11T17:33:24.000 • Lpep Dropoff Datetime: 2015-02-11T17:38:06.000
Vendorid
1
Lpep Pickup Datetime
2015-02-11T17:33:24.000
Lpep Dropoff Datetime
2015-02-11T17:38:06.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9029541015625
Pickup Latitude
40.853569030761719
Dropoff Longitude
-73.902076721191406
Dropoff Latitude
40.857898712158203
Passenger Count
1
Trip Distance
0.6
Fare Amount
5
Extra
1
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: 2015-02-14T23:34:42.000 • Lpep Dropoff Datetime: 2015-02-14T23:42:31.000
Vendorid
2
Lpep Pickup Datetime
2015-02-14T23:34:42.000
Lpep Dropoff Datetime
2015-02-14T23:42:31.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.89117431640625
Pickup Latitude
40.746898651123047
Dropoff Longitude
-73.889968872070313
Dropoff Latitude
40.734535217285156
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: 2015-02-19T19:20:30.000 • Lpep Dropoff Datetime: 2015-02-19T19:31:34.000
Vendorid
2
Lpep Pickup Datetime
2015-02-19T19:20:30.000
Lpep Dropoff Datetime
2015-02-19T19:31:34.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939315795898438
Pickup Latitude
40.805099487304688
Dropoff Longitude
-73.968025207519531
Dropoff Latitude
40.792041778564453
Passenger Count
1
Trip Distance
2.41
Fare Amount
10
Extra
1
Mta Tax
0.5
Tip Amount
2.36
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
14.16
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-16T21:07:51.000 • Lpep Dropoff Datetime: 2015-02-16T21:16:35.000
Vendorid
2
Lpep Pickup Datetime
2015-02-16T21:07:51.000
Lpep Dropoff Datetime
2015-02-16T21:16:35.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.950347900390625
Pickup Latitude
40.801513671875
Dropoff Longitude
-73.937660217285156
Dropoff Latitude
40.81622314453125
Passenger Count
1
Trip Distance
1.62
Fare Amount
8.5
Extra
0.5
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-17T09:45:17.000 • Lpep Dropoff Datetime: 2015-02-17T09:46:27.000
Vendorid
2
Lpep Pickup Datetime
2015-02-17T09:45:17.000
Lpep Dropoff Datetime
2015-02-17T09:46:27.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.964027404785156
Pickup Latitude
40.803005218505859
Dropoff Longitude
-73.959938049316406
Dropoff Latitude
40.807823181152344
Passenger Count
1
Trip Distance
0.4
Fare Amount
3.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
4.3
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-06T20:28:24.000 • Lpep Dropoff Datetime: 2015-02-06T20:48:59.000
Vendorid
1
Lpep Pickup Datetime
2015-02-06T20:28:24.000
Lpep Dropoff Datetime
2015-02-06T20:48:59.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.959060668945313
Pickup Latitude
40.718513488769531
Dropoff Longitude
-73.976966857910156
Dropoff Latitude
40.683200836181641
Passenger Count
1
Trip Distance
4
Fare Amount
16.5
Extra
0.5
Mta Tax
0.5
Tip Amount
3.55
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
21.35
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-13T09:53:41.000 • Lpep Dropoff Datetime: 2015-02-13T10:03:54.000
Vendorid
2
Lpep Pickup Datetime
2015-02-13T09:53:41.000
Lpep Dropoff Datetime
2015-02-13T10:03:54.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.938690185546875
Pickup Latitude
40.685955047607422
Dropoff Longitude
-73.927093505859375
Dropoff Latitude
40.670391082763672
Passenger Count
1
Trip Distance
1.7
Fare Amount
9
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.8
Payment Type
2
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-06T19:14:22.000 • Lpep Dropoff Datetime: 2015-02-06T19:18:45.000
Vendorid
1
Lpep Pickup Datetime
2015-02-06T19:14:22.000
Lpep Dropoff Datetime
2015-02-06T19:18:45.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.9388427734375
Pickup Latitude
40.821502685546875
Dropoff Longitude
-73.930816650390625
Dropoff Latitude
40.821975708007813
Passenger Count
1
Trip Distance
1.2
Fare Amount
6
Extra
1
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
7.5
Payment Type
4
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-09T20:07:10.000 • Lpep Dropoff Datetime: 2015-01-09T20:19:14.000
Vendorid
2
Lpep Pickup Datetime
2015-01-09T20:07:10.000
Lpep Dropoff Datetime
2015-01-09T20:19:14.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.939743041992188
Pickup Latitude
40.798393249511719
Dropoff Longitude
-73.921951293945313
Dropoff Latitude
40.830787658691406
Passenger Count
1
Trip Distance
3.17
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: 2015-02-03T14:33:34.000 • Lpep Dropoff Datetime: 2015-02-03T14:47:36.000
Vendorid
2
Lpep Pickup Datetime
2015-02-03T14:33:34.000
Lpep Dropoff Datetime
2015-02-03T14:47:36.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.922080993652344
Pickup Latitude
40.765937805175781
Dropoff Longitude
-73.908370971679688
Dropoff Latitude
40.778106689453125
Passenger Count
1
Trip Distance
1.37
Fare Amount
10
Extra
0
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: 2015-01-08T00:08:06.000 • Lpep Dropoff Datetime: 2015-01-08T00:18:16.000
Vendorid
2
Lpep Pickup Datetime
2015-01-08T00:08:06.000
Lpep Dropoff Datetime
2015-01-08T00:18:16.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.952064514160156
Pickup Latitude
40.790107727050781
Dropoff Longitude
-73.952133178710937
Dropoff Latitude
40.790130615234375
Passenger Count
1
Trip Distance
2.35
Fare Amount
10
Extra
0.5
Mta Tax
0.5
Tip Amount
2
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
13.3
Payment Type
1
Trip Type
1
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-13T21:40:11.000 • Lpep Dropoff Datetime: 2015-02-13T21:46:01.000
Vendorid
1
Lpep Pickup Datetime
2015-02-13T21:40:11.000
Lpep Dropoff Datetime
2015-02-13T21:46:01.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.971420288085938
Pickup Latitude
40.693225860595703
Dropoff Longitude
-73.978233337402344
Dropoff Latitude
40.686969757080078
Passenger Count
1
Trip Distance
0.9
Fare Amount
5.5
Extra
0.5
Mta Tax
0.5
Tip Amount
1.35
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
8.15
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-18T23:38:26.000 • Lpep Dropoff Datetime: 2015-02-18T23:48:37.000
Vendorid
2
Lpep Pickup Datetime
2015-02-18T23:38:26.000
Lpep Dropoff Datetime
2015-02-18T23:48:37.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.920814514160156
Pickup Latitude
40.826473236083984
Dropoff Longitude
-73.895988464355469
Dropoff Latitude
40.863636016845703
Passenger Count
1
Trip Distance
3
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-11T08:22:23.000 • Lpep Dropoff Datetime: 2015-02-11T08:34:34.000
Vendorid
1
Lpep Pickup Datetime
2015-02-11T08:22:23.000
Lpep Dropoff Datetime
2015-02-11T08:34:34.000
Store And Fwd Flag
N
Ratecodeid
5
Pickup Longitude
-73.862777709960937
Pickup Latitude
40.747051239013672
Dropoff Longitude
-73.886505126953125
Dropoff Latitude
40.756488800048828
Passenger Count
1
Trip Distance
1.8
Fare Amount
0
Extra
0
Mta Tax
0
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0
Total Amount
0
Payment Type
2
Trip Type
2
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-02-02T23:54:57.000 • Lpep Dropoff Datetime: 2015-02-03T00:00:13.000
Vendorid
2
Lpep Pickup Datetime
2015-02-02T23:54:57.000
Lpep Dropoff Datetime
2015-02-03T00:00:13.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.981521606445313
Pickup Latitude
40.674873352050781
Dropoff Longitude
-73.998611450195313
Dropoff Latitude
40.676765441894531
Passenger Count
1
Trip Distance
1.38
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
1
Vendorid: 1 • Lpep Pickup Datetime: 2015-02-26T20:45:34.000 • Lpep Dropoff Datetime: 2015-02-26T20:53:19.000
Vendorid
1
Lpep Pickup Datetime
2015-02-26T20:45:34.000
Lpep Dropoff Datetime
2015-02-26T20:53:19.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.990180969238281
Pickup Latitude
40.702659606933594
Dropoff Longitude
-73.997886657714844
Dropoff Latitude
40.692951202392578
Passenger Count
1
Trip Distance
1.2
Fare Amount
7
Extra
0.5
Mta Tax
0.5
Tip Amount
1.65
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
9.95
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-24T16:37:18.000 • Lpep Dropoff Datetime: 2015-01-24T17:01:30.000
Vendorid
2
Lpep Pickup Datetime
2015-01-24T16:37:18.000
Lpep Dropoff Datetime
2015-01-24T17:01:30.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.935142517089844
Pickup Latitude
40.795967102050781
Dropoff Longitude
-74.003761291503906
Dropoff Latitude
40.722446441650391
Passenger Count
1
Trip Distance
8.13
Fare Amount
26.5
Extra
0
Mta Tax
0.5
Tip Amount
4
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
31.3
Payment Type
1
Trip Type
1
2
Vendorid: 2 • Lpep Pickup Datetime: 2015-01-18T19:31:54.000 • Lpep Dropoff Datetime: 2015-01-18T19:50:20.000
Vendorid
2
Lpep Pickup Datetime
2015-01-18T19:31:54.000
Lpep Dropoff Datetime
2015-01-18T19:50:20.000
Store And Fwd Flag
N
Ratecodeid
1
Pickup Longitude
-73.931259155273437
Pickup Latitude
40.703945159912109
Dropoff Longitude
-73.950592041015625
Dropoff Latitude
40.66070556640625
Passenger Count
1
Trip Distance
4.3
Fare Amount
16.5
Extra
0
Mta Tax
0.5
Tip Amount
0
Tolls Amount
0
Improvement Surcharge
0.3
Total Amount
17.3
Payment Type
2
Trip Type
1
NYC Data AI • Public-data exploration interface