From a 500-row sample across 20 columns.
vendoridratecodeidstore_and_fwd_flag+10vendoridratecodeidstore_and_fwd_flag+10vendoridratecodeidstore_and_fwd_flag+10Mappable — Socrata point column `pickup_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 | 2010-04-24T11:01:05.000 | 2010-04-24T11:04:23.000 | 1 | 0.90000000000000002 | -74.008650000000003 | 40.719752 | 1 | 0 | -74.006304999999998 | 40.733663999999997 | Cas |
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% | 2010-11-07T01:00:00.0002010-11-07T01:01:00.0002010-11-07T01:10:00.000 |
dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2010-11-07T01:39:00.0002010-11-07T01:21:00.0002010-11-07T01:23:00.000 |
passenger_count | integer | The number of passengers in the vehicle. This is a driver-entered value. |
GET /api/datasets/74wj-s5ij GET /api/datasets/74wj-s5ij/quality GET /api/datasets/74wj-s5ij/related GET /api/columns?dataset=74wj-s5ij
vendoridratecodeidstore_and_fwd_flagvendoridratecodeidstore_and_fwd_flag+10vendoridratecodeidstore_and_fwd_flag+10vendoridratecodeidstore_and_fwd_flag+13vendoridratecodeidstore_and_fwd_flag+10| CMT | 2010-06-11T19:52:30.000 | 2010-06-11T19:57:43.000 | 1 | 0.90000000000000002 | -73.989102000000003 | 40.726773999999999 | 1 | 0 | -73.995930000000001 | 40.716571999999999 | Cas |
| VTS | 2010-12-29T22:40:00.000 | 2010-12-29T22:44:00.000 | 1 | 0.88 | -73.992603000000003 | 40.743768000000003 | 1 | — | -73.993342999999996 | 40.73433 | CSH |
| VTS | 2010-09-13T17:41:00.000 | 2010-09-13T18:05:00.000 | 5 | 2.3599999999999999 | -74.000906999999998 | 40.736604999999997 | 1 | — | -74.010047 | 40.720218000000003 | CSH |
| VTS | 2010-12-18T15:32:00.000 | 2010-12-18T15:40:00.000 | 1 | 2.2200000000000002 | -73.914261999999994 | 40.764853000000002 | 1 | — | -73.87921 | 40.767733 | CSH |
| CMT | 2010-08-23T07:49:43.000 | 2010-08-23T07:58:47.000 | 1 | 2.2000000000000002 | -73.979769000000005 | 40.747036999999999 | 1 | N | -73.981164000000007 | 40.767870000000002 | CSH |
| VTS | 2010-02-17T17:55:00.000 | 2010-02-17T18:06:00.000 | 5 | 1.72 | -73.961605000000006 | 40.779865000000001 | 1 | — | -73.979681999999997 | 40.763762 | CSH |
| CMT | 2010-06-24T11:34:52.000 | 2010-06-24T11:57:04.000 | 2 | 3.2000000000000002 | -74.010265000000004 | 40.709744999999998 | 1 | 0 | -73.986363999999995 | 40.746917000000003 | Cas |
| CMT | 2010-08-13T06:11:19.000 | 2010-08-13T06:16:49.000 | 1 | 1.3999999999999999 | -73.984695000000002 | 40.769382 | 1 | N | -73.963954999999999 | 40.757919000000001 | CRD |
| VTS | 2010-12-17T19:29:00.000 | 2010-12-17T19:38:00.000 | 2 | 1.48 | -73.96987 | 40.762661999999999 | 1 | — | -73.972735 | 40.746456999999999 | 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% | 0.9000000000000000210.80000000000000004 |
pickup_longitude | float | Longitude where the meter was engaged. | 0% | 0-73.137393000000003-73.995807999999997 |
pickup_latitude | float | Latitude where the meter was engaged. | 0% | 041.36613799999999940.761200000000002 |
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 | 52% | 0N1of 6 |
dropoff_longitude | float | Longitude where the meter was disengaged. | 0% | 0-73.137393000000003-73.995807999999997 |
dropoff_latitude | float | Latitude where the meter was disengaged. | 0% | 041.36613799999999940.761200000000002 |
payment_type | categorical | — | 0% | CSHCRDCASof 11 |
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. | 0% | 0.50-1of 18 |
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.57000000000000035.5 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 76.59999999999999965.7999999999999998 |
pickup_location | coordinate | — | 0% | {'coordinates': [0, 0], …{'coordinates': [-73.137…{'coordinates': [-73.995… |
dropoff_location | coordinate | — | 0% | VTSCMTDDSof 3 |