From a 500-row sample across 19 columns.
dropoff_latitudetrip_distancepickup_longitude+15dropoff_latitudetrip_distancepickup_longitude+11dropoff_latitudetrip_distancepickup_longitude+13Mappable — Socrata point column `dropoff_location`.
Open on the map →| vendorid | tpep_pickup_datetime | tpep_dropoff_datetime | passenger_count | trip_distance | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | payment_type | fare_amount | extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| VTS | 2009-03-17T19:25:00.000 | 2009-03-17T19:28:00.000 | 1 | 0.88 | -73.966329999999999 | 40.764924999999998 | -73.957584999999995 | 40.774951999999999 | CASH | 4.0999999999999996 | 1 |
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% | VTSCMTDDSof 3 |
tpep_pickup_datetime | datetime | The date and time when the meter was engaged. | 0% | 2009-12-28T18:12:00.0002009-11-01T01:08:00.0002009-11-01T01:02:00.000 |
tpep_dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2009-12-28T18:12:00.0002009-11-01T01:53:00.0002009-11-01T01:49:00.000 |
passenger_count | integer | The number of passengers in the vehicle. This is a driver-entered value. |
GET /api/datasets/f9tw-8p66 GET /api/datasets/f9tw-8p66/quality GET /api/datasets/f9tw-8p66/related GET /api/columns?dataset=f9tw-8p66
trip_distancemta_taxtotal_amount+11trip_distancemta_taxtotal_amount+9trip_distancemta_taxtotal_amount+11trip_distancemta_taxtotal_amount+11trip_distancemta_taxtotal_amount+11| CMT | 2009-03-26T20:20:05.000 | 2009-03-26T20:25:41.000 | 1 | 1.1000000000000001 | -74.009540000000001 | 40.718449 | -74.012034 | 40.708112 | Credit | 5.7999999999999998 | 0 |
| VTS | 2009-02-21T10:36:00.000 | 2009-02-21T10:45:00.000 | 2 | 1.3400000000000001 | -74.016057000000004 | 40.714731999999998 | -74.008778000000007 | 40.715262000000003 | CASH | 6.5 | 0 |
| CMT | 2009-09-20T03:11:51.000 | 2009-09-20T03:24:59.000 | 4 | 3 | -74.001130000000003 | 40.729157999999998 | -73.996060999999997 | 40.759917000000002 | Cash | 10.1 | 0 |
| VTS | 2009-06-16T11:06:00.000 | 2009-06-16T11:16:00.000 | 1 | 1.6599999999999999 | -73.980277999999998 | 40.785699999999999 | -73.956254999999999 | 40.773727999999998 | CASH | 7.7000000000000002 | 0 |
| VTS | 2009-09-27T13:48:00.000 | 2009-09-27T13:54:00.000 | 1 | 0.64000000000000001 | -73.975044999999994 | 40.749845000000001 | -73.972057000000007 | 40.757241999999998 | CASH | 5.2999999999999998 | 0 |
| VTS | 2009-02-09T15:11:00.000 | 2009-02-09T15:28:00.000 | 1 | 1.6799999999999999 | -73.975354999999993 | 40.759017 | -73.990335000000002 | 40.750079999999997 | CASH | 9.6999999999999993 | 0 |
| VTS | 2009-08-10T15:22:00.000 | 2009-08-10T15:25:00.000 | 1 | 0.64000000000000001 | -73.987342999999996 | 40.724850000000004 | -73.990525000000005 | 40.73122 | CASH | 3.7000000000000002 | 0 |
| VTS | 2009-05-09T11:54:00.000 | 2009-05-09T12:00:00.000 | 5 | 0.60999999999999999 | -73.981570000000005 | 40.758608000000002 | -73.972122999999996 | 40.75506 | CASH | 4.9000000000000004 | 0 |
| DDS | 2009-08-13T14:59:43.000 | 2009-08-13T15:18:01.000 | 1 | 10 | -73.985566000000006 | 40.768084000000002 | -73.920185000000004 | 40.882851000000002 | CASH | 24.100000000000001 | 0 |
Showing 12 of 18 columns. All of them are listed below.
| 0% |
125 |
trip_distance | float | The elapsed trip distance in miles reported by the taximeter. | 0% | 10.800000000000000040.90000000000000002 |
pickup_longitude | float | Longitude where the meter was engaged. | 0% | 0-73.137393000000003-73.982249999999993 |
pickup_latitude | float | Latitude where the meter was engaged. | 0% | 041.36613799999999940.733696999999999 |
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 | 100% | — |
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 | 61% | 01of 2 |
dropoff_longitude | float | Longitude where the meter was disengaged. | 0% | 0-73.137393000000003-73.951818000000003 |
dropoff_latitude | float | Latitude where the meter was disengaged. | 0% | 041.36613799999999940.733696999999999 |
payment_type | categorical | — | 0% | CASHCashCreditof 6 |
fare_amount | float | The time-and-distance fare calculated by the meter. | 0% | 5.29999999999999985.70000000000000024.9000000000000004 |
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. | 83% | 0.50of 2 |
tip_amount | float | Tip amount – This field is automatically populated for credit card tips. Cash tips are not included. | 0% | 021 |
tolls_amount | float | Total amount of all tolls paid in trip. | 0% | 04.15000000000000044.5700000000000003 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 5.29999999999999984.90000000000000045.7000000000000002 |
pickup_location | coordinate | — | 0% | {'coordinates': [0, 0], …{'coordinates': [-73.137…{'coordinates': [-73.951… |
dropoff_location | coordinate | — | 0% | {'coordinates': [0, 0], …{'coordinates': [-73.137…{'coordinates': [-73.951… |