From a 500-row sample across 18 columns.
improvement_surchargevendoridratecodeid+15improvement_surchargevendoridratecodeid+15improvement_surchargevendoridratecodeid+14| vendorid | tpep_pickup_datetime | tpep_dropoff_datetime | passenger_count | trip_distance | ratecodeid | store_and_fwd_flag | pulocationid | dolocationid | payment_type | fare_amount | extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2020-01-01T00:28:15.000 | 2020-01-01T00:33:03.000 | 1 | 1.20 | 1 | N | 238 | 239 | 1 | 6 | 3 |
| 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vendorid | categorical | — | 3% | 21of 2 |
tpep_pickup_datetime | datetime | — | 0% | 2020-01-09T16:53:00.0002020-01-09T18:13:00.0002020-01-06T08:13:00.000 |
tpep_dropoff_datetime | datetime | — | 0% | 2020-01-12T00:00:00.0002020-01-11T00:00:00.0002020-02-23T00:00:00.000 |
passenger_count | categorical | — | 3% | 123of 10 |
GET /api/datasets/kxp8-n2sj GET /api/datasets/kxp8-n2sj/quality GET /api/datasets/kxp8-n2sj/related GET /api/columns?dataset=kxp8-n2sj
improvement_surchargevendoridratecodeid+14improvement_surchargevendoridratecodeid+15improvement_surchargevendoridratecodeid+15fare_amounttrip_distancemta_tax+7improvement_surchargevendoridratecodeid+12| 2020-01-01T00:35:39.000 |
| 2020-01-01T00:43:04.000 |
| 1 |
| 1.20 |
| 1 |
| N |
| 239 |
| 238 |
| 1 |
| 7 |
| 3 |
| 1 | 2020-01-01T00:47:41.000 | 2020-01-01T00:53:52.000 | 1 | 0.60 | 1 | N | 238 | 238 | 1 | 6 | 3 |
| 1 | 2020-01-01T00:55:23.000 | 2020-01-01T01:00:14.000 | 1 | 0.80 | 1 | N | 238 | 151 | 1 | 5.5 | 0.5 |
| 2 | 2020-01-01T00:01:58.000 | 2020-01-01T00:04:16.000 | 1 | 0.00 | 1 | N | 193 | 193 | 2 | 3.5 | 0.5 |
| 2 | 2020-01-01T00:09:44.000 | 2020-01-01T00:10:37.000 | 1 | 0.03 | 1 | N | 7 | 193 | 2 | 2.5 | 0.5 |
| 2 | 2020-01-01T00:39:25.000 | 2020-01-01T00:39:29.000 | 1 | 0.00 | 1 | N | 193 | 193 | 1 | 2.5 | 0.5 |
| 2 | 2019-12-18T15:27:49.000 | 2019-12-18T15:28:59.000 | 1 | 0.00 | 5 | N | 193 | 193 | 1 | 0.01 | 0 |
| 2 | 2019-12-18T15:30:35.000 | 2019-12-18T15:31:35.000 | 4 | 0.00 | 1 | N | 193 | 193 | 1 | 2.5 | 0.5 |
| 1 | 2020-01-01T00:29:01.000 | 2020-01-01T00:40:28.000 | 2 | 0.70 | 1 | N | 246 | 48 | 1 | 8 | 3 |
Showing 12 of 18 columns. All of them are listed below.
trip_distance | float | — | 0% | 0.900.801.00 |
ratecodeid | categorical | — | 3% | 125of 7 |
store_and_fwd_flag | categorical | — | 3% | NYof 2 |
pulocationid | integer | — | 0% | 237236161 |
dolocationid | integer | — | 0% | 236237161 |
payment_type | categorical | — | 3% | 123of 5 |
fare_amount | float | — | 0% | 66.55.5 |
extra | float | — | 0% | 02.50.5 |
mta_tax | float | — | 0% | 0.50-0.5 |
tip_amount | float | — | 0% | 012 |
tolls_amount | float | — | 0% | 06.122.8 |
improvement_surcharge | categorical | — | 0% | 0.3-0.30of 3 |
total_amount | float | — | 0% | 9.810.39.3 |
congestion_surcharge | categorical | — | 0% | 2.50-2.5of 12 |