From a 500-row sample across 20 columns.
tip_amountmta_taxpassenger_count+15tip_amountmta_taxpassenger_count+12tip_amountmta_taxpassenger_count+11Mappable — Socrata point column `pickup_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 | 2012-10-03T11:56:38.000 | 2012-10-03T12:03:09.000 | 1 | 0.90000000000000002 | -73.985946999999996 | 40.768172 | 1 | N | -73.971693999999999 | 40.760691999999999 | 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% | 2012-04-24T20:14:00.0002012-01-24T08:42:00.0002012-02-13T12:38:00.000 |
tpep_dropoff_datetime | datetime | The date and time when the meter was disengaged. | 0% | 2012-04-24T20:14:00.0002012-02-13T12:38:00.0002012-04-27T21:20:00.000 |
passenger_count | categorical | The number of passengers in the vehicle. This is a driver-entered value. |
GET /api/datasets/kerk-3eby GET /api/datasets/kerk-3eby/quality GET /api/datasets/kerk-3eby/related GET /api/columns?dataset=kerk-3eby
tip_amountmta_taxpassenger_count+11tip_amountmta_taxpassenger_count+11tip_amountmta_taxpassenger_count+11tip_amountmta_taxpassenger_count+11tip_amountmta_taxpassenger_count+11| VTS | 2012-04-15T10:26:00.000 | 2012-04-15T10:36:00.000 | 1 | 2.8199999999999998 | -73.981678000000002 | 40.752315000000003 | 1 | — | -74.005757000000003 | 40.725726999999999 | CSH |
| CMT | 2012-06-19T23:08:43.000 | 2012-06-19T23:36:42.000 | 1 | 8.1999999999999993 | -73.946569999999994 | 40.797575000000002 | 1 | N | -73.873166999999995 | 40.877110000000002 | CRD |
| VTS | 2012-12-16T16:20:00.000 | 2012-12-16T16:35:00.000 | 1 | 1.8200000000000001 | -73.987219999999994 | 40.739731999999997 | 1 | — | -74.003420000000006 | 40.718260000000001 | CRD |
| CMT | 2012-06-27T00:43:55.000 | 2012-06-27T00:53:08.000 | 1 | 3.2000000000000002 | -74.004981000000001 | 40.740763999999999 | 1 | N | -73.967823999999993 | 40.757283999999999 | CRD |
| VTS | 2012-02-06T22:10:00.000 | 2012-02-06T22:14:00.000 | 2 | 0.90000000000000002 | -73.972047000000003 | 40.757803000000003 | 1 | — | -73.979827 | 40.746343000000003 | CRD |
| VTS | 2012-03-13T18:29:00.000 | 2012-03-13T18:38:00.000 | 1 | 1.0900000000000001 | -73.976202999999998 | 40.748330000000003 | 1 | — | -73.975030000000004 | 40.760097000000002 | CSH |
| VTS | 2012-05-28T22:14:00.000 | 2012-05-28T22:19:00.000 | 6 | 1.1299999999999999 | -73.993953000000005 | 40.746456999999999 | 1 | — | -73.987089999999995 | 40.755037000000002 | CRD |
| CMT | 2012-01-29T21:20:27.000 | 2012-01-29T21:28:53.000 | 2 | 2.1000000000000001 | 0 | 0 | 1 | N | 0 | 0 | CSH |
| CMT | 2012-04-30T13:20:52.000 | 2012-04-30T13:29:41.000 | 1 | 1.5 | -73.981847999999999 | 40.768732999999997 | 1 | N | -73.968878000000004 | 40.785831000000002 | CRD |
Showing 12 of 20 columns. All of them are listed below.
| 0% |
125of 18 |
trip_distance | float | The elapsed trip distance in miles reported by the taximeter. | 0% | 10.900000000000000021.1000000000000001 |
pickup_longitude | float | Longitude where the meter was engaged. | 0% | 0-73.967136999999994-73.982271999999995 |
pickup_latitude | float | Latitude where the meter was engaged. | 0% | 040.759240.758156999999997 |
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 | 49% | NYof 2 |
dropoff_longitude | float | Longitude where the meter was disengaged. | 0% | 0-73.967136999999994-73.940717000000006 |
dropoff_latitude | float | Latitude where the meter was disengaged. | 0% | 040.759240.758156999999997 |
payment_type | categorical | — | 0% | CSHCRDNOCof 5 |
fare_amount | float | The time-and-distance fare calculated by the meter. | 0% | 6.54.58.5 |
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.79999999999999989.5 |
total_amount | float | The total amount charged to passengers. Does not include cash tips. | 0% | 798 |
pickup_location | coordinate | — | 0% | CMTVTSof 2 |
dropoff_location | coordinate | — | 0% | {'coordinates': [0, 0], …{'coordinates': [-73.967…{'coordinates': [-73.940… |