From a 500-row sample across 20 columns.
passenger_countratecodeidpayment_type+16passenger_countratecodeidpayment_type+14dropoff_datetimepassenger_countpayment_type+12Mappable — Socrata point column `dropoff_location`.
Open on the map →| vendorid | tpep_pickup_datetime | dropoff_datetime | passenger_count | trip_distance | pickup_longitude | pickup_latitude | ratecodeid | store_and_fwd_flag | dropoff_longitude | dropoff_latitude | payment_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CMT | 2011-07-13T13:10:26.000 | 2011-07-13T13:20:40.000 | 1 | 1.5 | -74.005718000000002 | 40.741124999999997 | 1 | N | -73.992356000000001 | 40.723958000000003 | CSH |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | A designation for the technology vendor that provided the record. CMT=Creative Mobile Technologies VTS= VeriFone, Inc. DDS=Digital Dispatch Systems | 0% | CMTVTSof 2 |
tpep_pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2011-11-06T01:10:00.0002011-11-06T01:07:00.0002011-11-06T01:21:00.000 |
dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2011-11-06T01:59:00.0002011-11-06T01:24:00.0002011-11-06T01:38:00.000 |
passenger_count | integer | The number of passengers in the vehicle. This is a driver-entered value. |
GET /api/datasets/uwyp-dntv GET /api/datasets/uwyp-dntv/quality GET /api/datasets/uwyp-dntv/related GET /api/columns?dataset=uwyp-dntv
passenger_countratecodeidpayment_type+10passenger_countratecodeidpayment_type+13passenger_countratecodeidpayment_type+10passenger_countratecodeidpayment_type+10passenger_countratecodeidpayment_type+10| CMT | 2011-03-23T23:58:13.000 | 2011-03-24T00:16:27.000 | 3 | 5.2000000000000002 | -73.957565000000002 | 40.769528000000001 | 1 | N | -73.891557000000006 | 40.746650000000002 | CSH |
| VTS | 2011-03-01T10:01:00.000 | 2011-03-01T10:17:00.000 | 1 | 3.0299999999999998 | -73.986502000000002 | 40.776916999999997 | 1 | — | -73.974322000000001 | 40.746938 | CSH |
| CMT | 2011-08-15T11:38:58.000 | 2011-08-15T11:49:46.000 | 1 | 2.2999999999999998 | -73.990489999999994 | 40.730643000000001 | 1 | N | -73.972632000000004 | 40.755913999999997 | CRD |
| CMT | 2011-05-22T16:23:39.000 | 2011-05-22T16:28:59.000 | 3 | 1 | -73.961147999999994 | 40.777565000000003 | 1 | N | -73.948322000000005 | 40.778998999999999 | CSH |
| CMT | 2011-06-01T18:00:14.000 | 2011-06-01T18:17:51.000 | 1 | 2.5 | -73.952966000000004 | 40.786135000000002 | 1 | N | -73.981896000000006 | 40.770432999999997 | CSH |
| CMT | 2011-11-29T22:23:24.000 | 2011-11-29T22:26:54.000 | 1 | 0.29999999999999999 | -73.993932000000001 | 40.732737 | 1 | N | -73.989236000000005 | 40.730946000000003 | CSH |
| VTS | 2011-09-19T19:09:00.000 | 2011-09-19T19:16:00.000 | 6 | 1.4099999999999999 | -73.971952000000002 | 40.793956999999999 | 1 | — | -73.952082000000004 | 40.818874999999998 | CRD |
| CMT | 2011-07-04T22:27:19.000 | 2011-07-04T22:33:39.000 | 0 | 0.90000000000000002 | -73.994200000000006 | 40.735500000000002 | 1 | N | -74.002399999999994 | 40.725299999999997 | CRD |
| CMT | 2011-08-10T14:31:34.000 | 2011-08-10T14:48:07.000 | 1 | 2.5 | -73.985044000000002 | 40.736417000000003 | 1 | N | -73.973309 | 40.764024999999997 | CRD |
Showing 12 of 20 columns. All of them are listed below.
| 0% |
125 |
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.982200000000006-73.982299999999995 |
pickup_latitude | float | Latitude where the meter was engaged. | 0% | 040.77409999999999740.774000000000001 |
ratecodeid | 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% | 124 |
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 | 49% | NYof 2 |
dropoff_longitude | float | Longitude where the meter was disengaged. | 0% | 0-73.982299999999995-73.982399999999998 |
dropoff_latitude | float | Latitude where the meter was disengaged. | 0% | 040.76120000000000240.774299999999997 |
payment_type | categorical | — | 0% | CSHCRDof 2 |
fare_amount | float | The time-and-distance fare calculated by the meter. | 0% | 5.70000000000000025.29999999999999986.0999999999999996 |
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 | categorical | $0.50 MTA tax that is automatically triggered based on the metered rate in use. | 0% | 0.50of 2 |
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% | 04.79999999999999988 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 76.59999999999999966.2000000000000002 |
pickup_location | coordinate | — | 0% | CMTVTSof 2 |
dropoff_location | coordinate | — | 0% | CMTVTSof 2 |