From a 500-row sample across 20 columns.
trip_distancemta_taxlpep_pickup_datetime+17trip_distancemta_taxlpep_pickup_datetime+17trip_distancemta_taxlpep_pickup_datetime+18| 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 | 2015-02-10T08:46:15.000 | 2015-02-10T08:59:50.000 | N | 1 | -73.828262329101563 | 40.693958282470703 | -73.776329040527344 | 40.645347595214844 | 1 | 5.95 | 19 |
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% | 2015-06-01T10:37:33.0002015-01-07T12:38:15.0002015-01-07T11:09:26.000 |
lpep_dropoff_datetime | datetime | — | 0% | 2015-12-06T00:00:00.0002015-12-20T00:00:00.0002015-11-22T00:00:00.000 |
store_and_fwd_flag | categorical | — | 0% | NYof 2 |
GET /api/datasets/gi8d-wdg5 GET /api/datasets/gi8d-wdg5/quality GET /api/datasets/gi8d-wdg5/related GET /api/columns?dataset=gi8d-wdg5
trip_distancemta_taxlpep_pickup_datetime+14trip_distancemta_taxlpep_pickup_datetime+14trip_distancemta_taxlpep_pickup_datetime+14trip_distancemta_taxlpep_pickup_datetime+14trip_distancemta_taxlpep_pickup_datetime+14| 2 | 2015-01-09T15:45:22.000 | 2015-01-09T15:54:32.000 | N | 1 | -73.985671997070313 | 40.669933319091797 | -73.998367309570312 | 40.679828643798828 | 3 | 1.15 | 7.5 |
| 2 | 2015-01-16T22:07:38.000 | 2015-01-16T22:14:25.000 | N | 1 | -73.892570495605469 | 40.746658325195313 | -73.909294128417969 | 40.736202239990234 | 1 | 1.74 | 7.5 |
| 2 | 2015-02-11T20:12:29.000 | 2015-02-11T20:16:39.000 | N | 1 | -73.952033996582031 | 40.714122772216797 | -73.957847595214844 | 40.710945129394531 | 1 | 0.5 | 5 |
| 2 | 2015-02-26T10:42:27.000 | 2015-02-26T10:57:30.000 | N | 1 | -73.89410400390625 | 40.750774383544922 | -73.912811279296875 | 40.755722045898437 | 2 | 1.8 | 11 |
| 1 | 2015-02-02T18:46:40.000 | 2015-02-02T18:58:08.000 | N | 1 | -73.925422668457031 | 40.761699676513672 | -73.915641784667969 | 40.749153137207031 | 1 | 1.3 | 8.5 |
| 2 | 2015-02-17T05:04:16.000 | 2015-02-17T05:34:04.000 | N | 1 | -73.927223205566406 | 40.692600250244141 | -73.918312072753906 | 40.651378631591797 | 1 | 3.47 | 17 |
| 2 | 2015-01-05T12:58:10.000 | 2015-01-05T13:04:51.000 | N | 1 | -73.944419860839844 | 40.807327270507813 | -73.960868835449219 | 40.806556701660156 | 1 | 1.29 | 6.5 |
| 2 | 2015-02-12T23:28:39.000 | 2015-02-12T23:35:14.000 | N | 1 | -73.943794250488281 | 40.746570587158203 | -73.928382873535156 | 40.737293243408203 | 1 | 1.64 | 7.5 |
| 1 | 2015-02-19T19:41:48.000 | 2015-02-19T19:58:32.000 | N | 1 | -73.937156677246094 | 40.804126739501953 | -73.880416870117187 | 40.809806823730469 | 1 | 3.6 | 15 |
Showing 12 of 20 columns. All of them are listed below.
ratecodeid | categorical | — | 0% | 152of 7 |
pickup_longitude | float | — | 0% | 0-73.84429931640625-73.844291687011719 |
pickup_latitude | float | — | 0% | 040.72135162353515640.721336364746094 |
dropoff_longitude | float | — | 0% | 0-73.952728271484375-73.952766418457031 |
dropoff_latitude | float | — | 0% | 040.77430343627929740.774326324462891 |
passenger_count | categorical | — | 0% | 125of 10 |
trip_distance | float | — | 0% | 00.91 |
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.545.33 |
ehail_fee | numeric | — | 100% | — |
improvement_surcharge | categorical | — | 0% | 0.30-0.3of 3 |
total_amount | float | — | 0% | 6.87.37.8 |
payment_type | categorical | — | 0% | 213of 5 |
trip_type | categorical | — | 0% | 12of 2 |