From a 500-row sample across 19 columns.
pulocationiddolocationidextra+17pulocationiddolocationidextra+17pulocationiddolocationidextra+17| vendorid | lpep_pickup_datetime | lpep_dropoff_datetime | store_and_fwd_flag | ratecodeid | pulocationid | dolocationid | passenger_count | trip_distance | fare_amount | extra | mta_tax |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2019-02-01T00:10:19.000 | 2019-02-01T00:21:43.000 | N | 1 | 92 | 135 | 1 | 2.79 | 11 | 0.5 | 0.5 |
| 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | — | 7% | 21of 2 |
lpep_pickup_datetime | datetime | — | 0% | 2019-10-07T14:58:00.0002019-11-20T10:31:00.0002019-11-06T15:45:00.000 |
lpep_dropoff_datetime | datetime | — | 0% | 2019-02-02T00:00:00.0002019-03-10T00:00:00.0002019-01-12T00:00:00.000 |
store_and_fwd_flag | categorical | — | 7% | NYof 2 |
GET /api/datasets/q5mz-t52e GET /api/datasets/q5mz-t52e/quality GET /api/datasets/q5mz-t52e/related GET /api/columns?dataset=q5mz-t52e
pulocationiddolocationidextra+17pulocationiddolocationidextra+16pulocationiddolocationidextra+16extratip_amountstore_and_fwd_flag+13extratip_amountstore_and_fwd_flag+13| 2019-02-01T00:02:16.000 |
| 2019-02-01T00:24:37.000 |
| N |
| 1 |
| 66 |
| 36 |
| 1 |
| 4.46 |
| 17.5 |
| 0.5 |
| 0.5 |
| 2 | 2019-02-01T00:37:19.000 | 2019-02-01T00:43:07.000 | N | 1 | 255 | 112 | 1 | 1.26 | 6 | 0.5 | 0.5 |
| 1 | 2019-02-01T00:10:10.000 | 2019-02-01T00:12:21.000 | N | 1 | 75 | 238 | 1 | 0.70 | 4 | 0.5 | 0.5 |
| 1 | 2019-02-01T00:30:19.000 | 2019-02-01T00:46:14.000 | N | 1 | 75 | 48 | 1 | 3.90 | 14.5 | 0.5 | 0.5 |
| 1 | 2019-02-01T00:43:46.000 | 2019-02-01T00:46:08.000 | N | 1 | 7 | 7 | 1 | 0.60 | 4 | 0.5 | 0.5 |
| 2 | 2019-02-01T00:32:56.000 | 2019-02-01T00:45:10.000 | N | 1 | 255 | 37 | 1 | 2.31 | 10.5 | 0.5 | 0.5 |
| 2 | 2019-02-01T00:55:28.000 | 2019-02-01T01:13:53.000 | N | 1 | 80 | 192 | 1 | 8.70 | 26 | 0.5 | 0.5 |
| 2 | 2019-02-01T00:26:19.000 | 2019-02-01T00:37:58.000 | N | 1 | 265 | 248 | 3 | 6.51 | 19.5 | 0.5 | 0.5 |
| 2 | 2019-02-01T00:59:41.000 | 2019-02-01T01:04:06.000 | N | 1 | 82 | 83 | 1 | 1.01 | 5.5 | 0.5 | 0.5 |
Showing 12 of 19 columns. All of them are listed below.
ratecodeid | categorical | — | 7% | 152of 7 |
pulocationid | integer | — | 0% | 747541 |
dolocationid | integer | — | 0% | 744241 |
passenger_count | categorical | — | 7% | 125of 10 |
trip_distance | float | — | 0% | 0.000.901.00 |
fare_amount | float | — | 0% | 66.57 |
extra | float | — | 0% | 00.51 |
mta_tax | float | — | 0% | 0.50-0.5 |
tip_amount | float | — | 0% | 012 |
tolls_amount | float | — | 0% | 06.125.76 |
ehail_fee | categorical | — | 100% | 01.95of 2 |
improvement_surcharge | categorical | — | 0% | 0.30-0.3of 11 |
total_amount | float | — | 0% | 7.86.87.3 |
payment_type | categorical | — | 7% | 123of 5 |
trip_type | categorical | — | 7% | 12of 2 |
congestion_surcharge | coordinate | — | 16% | 02.752.5of 9 |