From a 500-row sample across 19 columns.
extratolls_amounttip_amount+16extratolls_amounttip_amount+12extratolls_amounttip_amount+12| passenger_count | trip_distance | pickup_longitude | pickup_latitude | ratecodeid | store_and_fwd_flag | dropoff_longitude | dropoff_latitude | fare_amount | extra | mta_tax | tip_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 | -73.981002807617187 | 40.759609222412109 | 1 | N | -73.991790771484375 | 40.746620178222656 | 11 | 0.5 | 0.5 | 0 |
| 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
passenger_count | categorical | The number of passengers in the vehicle. This is a driver-entered value. | 0% | 125of 10 |
trip_distance | float | The elapsed trip distance in miles reported by the taximeter. | 0% | 0.910.8 |
pickup_longitude | float | Longitude where the meter was engaged. | 0% | 0-73.982223510742188-73.98223876953125 |
pickup_latitude | float | Latitude where the meter was engaged. | 0% | 040.774070739746094 |
GET /api/datasets/2yzn-sicd GET /api/datasets/2yzn-sicd/quality GET /api/datasets/2yzn-sicd/related GET /api/columns?dataset=2yzn-sicd
extratolls_amounttip_amount+8extratolls_amounttip_amount+12extratolls_amounttip_amount+8extratolls_amounttip_amount+8extratolls_amounttip_amount+8| 1.55 |
| -73.991775512695313 |
| 40.750240325927734 |
| 1 |
| N |
| -73.981513977050781 |
| 40.762454986572266 |
| 7.5 |
| 0 |
| 0.5 |
| 0 |
| 1 | 15.1 | -73.983566284179688 | 40.749881744384766 | 2 | N | -73.804557800292969 | 40.649757385253906 | 52 | 0 | 0.5 | 11.65 |
| 1 | 2.9 | -74.000457763671875 | 40.727294921875 | 1 | N | -73.979804992675781 | 40.761722564697266 | 10.5 | 0.5 | 0.5 | 0 |
| 1 | 15.9 | -73.972785949707031 | 40.749996185302734 | 2 | N | -73.786384582519531 | 40.644256591796875 | 52 | 0 | 0.5 | 11.67 |
| 1 | 1.58 | -73.984916687011719 | 40.732505798339844 | 1 | N | -73.988883972167969 | 40.747482299804688 | 9 | 0 | 0.5 | 1.96 |
| 1 | 2.1 | -73.97998046875 | 40.743183135986328 | 1 | N | -73.976051330566406 | 40.766082763671875 | 11.5 | 0 | 0.5 | 0.9 |
| 1 | 1.08 | -73.998016357421875 | 40.740863800048828 | 1 | N | -74.003105163574219 | 40.728660583496094 | 7.5 | 1 | 0.5 | 1.5 |
| 1 | 1 | -73.994094848632812 | 40.741611480712891 | 1 | N | -74.003822326660156 | 40.731166839599609 | 6 | 0 | 0.5 | 0 |
| 2 | 1.2 | -73.975364685058594 | 40.787334442138672 | 1 | N | -73.9654541015625 | 40.802906036376953 | 6 | 0.5 | 0.5 | 0 |
Showing 12 of 19 columns. All of them are listed below.
40.77410888671875ratecodeid | categorical | — | 53% | 125of 7 |
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 | 0% | NYof 2 |
dropoff_longitude | float | Longitude where the meter was disengaged. | 0% | 0-73.982330322265625-73.982223510742188 |
dropoff_latitude | float | Latitude where the meter was disengaged. | 0% | 040.75014877319335940.750091552734375 |
fare_amount | float | The time-and-distance fare calculated by the meter. | 0% | 66.57 |
extra | float | Miscellaneous extras and surcharges. Currently, this only includes the $0.50 and $1 rush hour and overnight charges. | 0% | 00.51 |
mta_tax | float | $0.50 MTA tax that is automatically triggered based on the metered rate in use. | 0% | 0.50-0.5 |
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.545.33 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 7.87.38.3 |
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% | 21of 2 |
pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2015-10-16T13:12:11.0002015-11-19T09:24:32.0002015-11-22T15:15:06.000 |
dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 125of 10 |
rate_code | categorical | 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 | 47% | 125of 7 |
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% | 123of 5 |
imp_surcharge | float | $0.30 improvement surcharge assessed trips at the flag drop. The improvement surcharge began being levied in 2015. | 53% | 0.3-0.30 |