From a 500-row sample across 19 columns.
mta_taxextrapickup_latitude+17mta_taxextrapickup_latitude+17mta_taxextratrip_distance+13| vendorid | lpep_pickup_datetime | lpep_dropoff_datetime | store_and_fwd_flag | ratecodeid | pickup_longitude | pickup_latitude | dropoff_longitude | dropoff_latitude | passenger_count | trip_distance | fare_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2014-10-13T16:47:42.000 | 2014-10-13T16:48:43.000 | N | 1 | 0 | 0 | 0 | 0 | 1 | 0.2 | 3 |
| 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | — | 0% | 21of 2 |
lpep_pickup_datetime | datetime | — | 0% | 2014-08-09T15:54:25.0002014-06-07T00:00:00.0002014-03-14T00:00:00.000 |
lpep_dropoff_datetime | datetime | — | 0% | 2014-08-10T14:55:38.0002014-08-03T00:00:00.0002014-11-02T00:00:00.000 |
store_and_fwd_flag | categorical | — | 0% | NYof 2 |
GET /api/datasets/2np7-5jsg GET /api/datasets/2np7-5jsg/quality GET /api/datasets/2np7-5jsg/related GET /api/columns?dataset=2np7-5jsg
mta_taxextratrip_distance+13mta_taxextratrip_distance+13mta_taxextratrip_distance+13mta_taxextratrip_distance+13mta_taxextratrip_distance+13| 2014-11-22T01:09:08.000 |
| 2014-11-22T01:18:02.000 |
| N |
| 1 |
| 0 |
| 0 |
| 0 |
| 0 |
| 1 |
| 4 |
| 13 |
| 2 | 2014-08-04T22:46:53.000 | 2014-08-04T23:05:24.000 | N | 1 | 0 | 0 | 0 | 0 | 6 | 4.13 | 16 |
| 1 | 2014-11-25T09:41:35.000 | 2014-11-25T09:54:44.000 | N | 1 | -73.957542419433594 | 40.728981018066406 | -73.953971862792969 | 40.742591857910156 | 1 | 1.4 | 10 |
| 2 | 2014-09-30T09:14:56.000 | 2014-09-30T09:22:07.000 | N | 1 | -73.934089660644531 | 40.853523254394531 | -73.939620971679687 | 40.841522216796875 | 1 | 0.89 | 6.5 |
| 2 | 2014-06-27T19:27:14.000 | 2014-06-27T19:34:06.000 | N | 1 | -73.930633544921875 | 40.853633880615234 | -73.939033508300781 | 40.842319488525391 | 1 | 0.89 | 6.5 |
| 2 | 2014-10-22T23:11:46.000 | 2014-10-22T23:17:37.000 | N | 1 | -73.969047546386719 | 40.693134307861328 | -73.971199035644531 | 40.680858612060547 | 1 | 1.51 | 6.5 |
| 2 | 2014-09-18T15:50:30.000 | 2014-09-18T15:59:47.000 | N | 1 | -73.901405334472656 | 40.862232208251953 | -73.898750305175781 | 40.873912811279297 | 1 | 1.04 | 7.5 |
| 2 | 2014-08-30T20:26:57.000 | 2014-08-30T20:40:24.000 | N | 1 | -73.939323425292969 | 40.805095672607422 | -73.922996520996094 | 40.793376922607422 | 1 | 3.27 | 13 |
| 2 | 2014-10-30T11:41:48.000 | 2014-10-30T11:46:32.000 | N | 1 | -73.952835083007813 | 40.810821533203125 | -73.949638366699219 | 40.80224609375 | 2 | 0.77 | 5 |
Showing 12 of 19 columns. All of them are listed below.
ratecodeid | categorical | — | 0% | 152of 7 |
pickup_longitude | float | — | 0% | 0-73.84429931640625-73.844276428222656 |
pickup_latitude | float | — | 0% | 040.72135162353515640.721336364746094 |
dropoff_longitude | float | — | 0% | 0-73.939163208007812-73.939155578613281 |
dropoff_latitude | float | — | 0% | 040.77430343627929740.774326324462891 |
passenger_count | categorical | — | 0% | 125of 10 |
trip_distance | float | — | 0% | 010.9 |
fare_amount | float | — | 0% | 65.56.5 |
extra | float | — | 0% | 00.51 |
mta_tax | categorical | — | 0% | 0.50-0.5of 11 |
tip_amount | float | — | 0% | 012 |
tolls_amount | float | — | 0% | 05.332.44 |
ehail_fee | numeric | — | 100% | — |
total_amount | float | — | 0% | 76.58 |
payment_type | categorical | — | 0% | 214of 5 |
trip_type | categorical | — | 11% | 12of 2 |