From a 500-row sample across 20 columns.
tpep_dropoff_datetimetrip_distancedropoff_latitude+17trip_distancedropoff_latitudetpep_pickup_datetime+16tpep_dropoff_datetimetrip_distancedropoff_latitude+17Mappable — Socrata point column `dropoff_location`.
Open on the map →| vendorid | tpep_pickup_datetime | tpep_dropoff_datetime | passenger_count | trip_distance | pickup_longitude | pickup_latitude | ratecodeid | store_and_fwd_flag | dropoff_longitude | dropoff_latitude | payment_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CMT | 2013-02-06T11:57:26.000 | 2013-02-06T12:05:49.000 | 1 | 1.2 | -74.004198000000002 | 40.725057 | 1 | N | -73.993948000000003 | 40.741188000000001 | 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% | 2013-11-03T01:15:00.0002013-11-03T01:05:00.0002013-11-03T01:29:00.000 |
tpep_dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2013-11-03T01:25:00.0002013-11-03T01:23:00.0002013-11-03T01:33:00.000 |
passenger_count | categorical | The number of passengers in the vehicle. This is a driver-entered value. |
GET /api/datasets/t7ny-aygi GET /api/datasets/t7ny-aygi/quality GET /api/datasets/t7ny-aygi/related GET /api/columns?dataset=t7ny-aygi
trip_distancedropoff_latitudetpep_pickup_datetime+16trip_distancedropoff_latitudetotal_amount+12tpep_dropoff_datetimetrip_distancedropoff_latitude+15trip_distancedropoff_latitudetotal_amount+11tpep_dropoff_datetimetrip_distancetpep_pickup_datetime+11| VTS | 2013-05-21T16:31:00.000 | 2013-05-21T16:41:00.000 | 5 | 1.01 | -73.961917 | 40.810315000000003 | 1 | — | -73.960603000000006 | 40.815759999999997 | CSH |
| VTS | 2013-07-25T23:24:00.000 | 2013-07-25T23:39:00.000 | 2 | 5.8700000000000001 | -73.955207000000001 | 40.80424 | 1 | — | -73.923197000000002 | 40.866947000000003 | CRD |
| VTS | 2013-08-09T15:41:00.000 | 2013-08-09T15:44:00.000 | 1 | 0.57999999999999996 | -73.960992000000005 | 40.769196999999998 | 1 | — | -73.955112999999997 | 40.780135000000001 | CSH |
| VTS | 2013-12-12T23:35:00.000 | 2013-12-12T23:41:00.000 | 2 | 1.46 | -73.954897000000003 | 40.763885000000002 | 1 | — | -73.946543000000005 | 40.781260000000003 | CRD |
| VTS | 2013-06-17T01:48:00.000 | 2013-06-17T01:57:00.000 | 4 | 2.6800000000000002 | -73.990606999999997 | 40.724497 | 1 | — | -73.971767 | 40.756976999999999 | CSH |
| VTS | 2013-11-22T09:44:00.000 | 2013-11-22T10:16:00.000 | 2 | 2.7599999999999998 | -73.995954999999995 | 40.748694999999998 | 1 | — | -73.96405 | 40.773682000000001 | CSH |
| VTS | 2013-08-25T01:01:00.000 | 2013-08-25T01:26:00.000 | 1 | 4.8700000000000001 | -73.987669999999994 | 40.728586999999997 | 1 | — | -73.980739999999997 | 40.667831999999997 | CRD |
| VTS | 2013-04-07T15:51:00.000 | 2013-04-07T15:54:00.000 | 3 | 0.70999999999999996 | -73.940119999999993 | 40.793774999999997 | 1 | — | -73.943297000000001 | 40.786017000000001 | CRD |
| CMT | 2013-10-29T06:25:09.000 | 2013-10-29T06:27:42.000 | 1 | 0.40000000000000002 | -73.956569999999999 | 40.771265 | 1 | N | -73.961738999999994 | 40.767471999999998 | CSH |
Showing 12 of 20 columns. All of them are listed below.
| 0% |
125of 13 |
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.982241999999999-73.982271999999995 |
pickup_latitude | float | Latitude where the meter was engaged. | 0% | 040.77408240.774087000000002 |
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% | 125 |
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 | 50% | NYof 2 |
dropoff_longitude | float | Longitude where the meter was disengaged. | 0% | 0-73.982281999999998-73.982286999999999 |
dropoff_latitude | float | Latitude where the meter was disengaged. | 0% | 040.76599000000000240.774321999999998 |
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% | CRDCSHNOCof 5 |
fare_amount | float | The time-and-distance fare calculated by the meter. | 0% | 6.567 |
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% | 0.50-0.5of 19 |
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.33000000000000014.7999999999999998 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 96.58 |
pickup_location | coordinate | — | 0% | {'coordinates': [0, 0], …{'coordinates': [-73.948…{'coordinates': [-74.023… |
dropoff_location | coordinate | — | — | — |