From a 500-row sample across 18 columns.
pickup_longitudedropoff_datetimestore_and_fwd_flag+16pickup_longitudestore_and_fwd_flagtrip_distance+11store_and_fwd_flagtrip_distancemta_tax+7| vendor_id | pickup_datetime | dropoff_datetime | passenger_count | trip_distance | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | payment_type | fare_amount | mta_tax |
|---|---|---|---|---|---|---|---|---|---|---|---|
| VTS | 2014-06-24T08:09:00.000 | 2014-06-24T08:19:00.000 | 1 | 0.72999999999999998 | -74.005899999999997 | 40.717542000000002 | -74.013047 | 40.715026999999999 | CSH | 7 | 0.5 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendor_id | categorical | A designation for the technology vendor that provided the record. CMT=Creative Mobile Technologies VTS= VeriFone, Inc. DDS=Digital Dispatch Systems | 0% | VTSCMTof 2 |
pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2014-11-02T01:10:00.0002014-11-02T01:04:00.0002014-11-02T01:12:00.000 |
dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2014-11-02T01:33:00.0002014-11-02T01:37:00.0002014-11-02T01:36:00.000 |
passenger_count | categorical | The number of passengers in the vehicle. This is a driver-entered value. |
GET /api/datasets/gkne-dk5s GET /api/datasets/gkne-dk5s/quality GET /api/datasets/gkne-dk5s/related GET /api/columns?dataset=gkne-dk5s
pickup_longitudestore_and_fwd_flagtrip_distance+11pickup_longitudestore_and_fwd_flagtrip_distance+11store_and_fwd_flagtrip_distancemta_tax+7store_and_fwd_flagtrip_distancemta_tax+7store_and_fwd_flagtrip_distancemta_tax+7| CMT | 2014-10-13T23:27:58.000 | 2014-10-13T23:30:24.000 | 1 | 0.80000000000000004 | -73.994844000000001 | 40.760216999999997 | -73.988150000000005 | 40.769694000000001 | CSH | 4.5 | 0.5 |
| CMT | 2014-08-30T02:49:30.000 | 2014-08-30T02:55:57.000 | 1 | 1.7 | -74.004238000000001 | 40.741909 | -73.987155999999999 | 40.761324000000002 | CRD | 7.5 | 0.5 |
| VTS | 2014-10-25T12:29:00.000 | 2014-10-25T12:51:00.000 | 1 | 2.0899999999999999 | -73.956523000000004 | 40.766972000000003 | -73.983597000000003 | 40.760531999999998 | CRD | 14.5 | 0.5 |
| VTS | 2014-02-25T20:20:00.000 | 2014-02-25T20:25:00.000 | 1 | 0.67000000000000004 | -73.969963000000007 | 40.759557000000001 | -73.966148000000004 | 40.765027000000003 | CRD | 5.5 | 0.5 |
| CMT | 2014-05-22T14:33:15.000 | 2014-05-22T14:50:48.000 | 1 | 2.5 | -73.994658999999999 | 40.750557999999998 | -73.979945999999998 | 40.775474000000003 | CSH | 12.5 | 0.5 |
| VTS | 2014-07-24T09:31:00.000 | 2014-07-24T09:36:00.000 | 1 | 0.92000000000000004 | -73.954277000000005 | 40.778457000000003 | -73.953293000000002 | 40.78781 | CRD | 5.5 | 0.5 |
| CMT | 2014-05-17T11:02:51.000 | 2014-05-17T11:05:53.000 | 1 | 0.69999999999999996 | -74.000626999999994 | 40.747517000000002 | -74.005668999999997 | 40.737672000000003 | CSH | 4.5 | 0.5 |
| CMT | 2014-09-01T19:57:23.000 | 2014-09-01T20:01:19.000 | 1 | 0.59999999999999998 | -73.954132000000001 | 40.784447 | -73.952636999999996 | 40.778176000000002 | CSH | 5 | 0.5 |
| CMT | 2014-03-20T23:39:00.000 | 2014-03-20T23:47:02.000 | 2 | 2 | -73.941089000000005 | 40.839536000000003 | -73.935417999999999 | 40.853577000000001 | CSH | 8.5 | 0.5 |
Showing 12 of 18 columns. All of them are listed below.
| 0% |
125of 11 |
trip_distance | float | The elapsed trip distance in miles reported by the taximeter. | 0% | 10.900000000000000020.80000000000000004 |
pickup_longitude | float | Longitude where the meter was engaged. | 0% | 0-73.982219999999998-73.982140000000001 |
pickup_latitude | float | Latitude where the meter was engaged. | 0% | 040.75936000000000140.758282000000001 |
store_and_fwd_flag | categorical | This flag indicates whether the trip record was held in vehicle memory before sending to the vendor, aka “store and forward,” because the vehicle did not have a connection to the server. Y= store and forward trip N= not a store and forward trip | 51% | NYof 2 |
dropoff_longitude | float | Longitude where the meter was disengaged. | 0% | 0-73.982309999999998-73.982219999999998 |
dropoff_latitude | float | Latitude where the meter was disengaged. | 0% | 040.74507240.785088999999999 |
payment_type | categorical | A numeric code signifying how the passenger paid for the trip. 1= Credit card 2= Cash 3= No charge 4= Dispute 5= Unknown 6= Voided trip | 0% | CRDCSHUNKof 5 |
fare_amount | float | The time-and-distance fare calculated by the meter. | 0% | 6.567 |
mta_tax | categorical | $0.50 MTA tax that is automatically triggered based on the metered rate in use. | 0% | 0.5030.050000000000001of 3 |
tip_amount | float | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. | 0% | 012 |
tolls_amount | float | Total amount of all tolls paid in trip. | 0% | 05.330000000000000111 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 96.58 |
imp_surcharge | float | $0.30 improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | 0% | 00.51 |
extra | numeric | Miscellaneous extras and surcharges. Currently, this only includes the $0.50 and $1 rush hour and overnight charges. | 100% | — |
rate_code | text | The final rate code in effect at the end of the trip. 1= Standard rate 2=JFK 3=Newark 4=Nassau or Westchester 5=Negotiated fare 6=Group ride | 0% | 125 |