From a 500-row sample across 19 columns.
vendoridpassenger_countcongestion_surcharge+17vendoridpassenger_counttotal_amount+16vendoridpassenger_counttotal_amount+16| 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-12-18T15:52:30.000 | 2019-12-18T15:54:39.000 | N | 1 | 264 | 264 | 5 | 0.00 | 3.5 | 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 | — | 30% | 21of 2 |
lpep_pickup_datetime | datetime | — | 0% | 2020-01-09T15:25:00.0002020-01-03T14:27:00.0002020-01-08T08:14:00.000 |
lpep_dropoff_datetime | datetime | — | 0% | 2020-01-09T11:10:00.0002020-01-09T10:15:00.0002020-01-10T10:10:00.000 |
store_and_fwd_flag | categorical | — | 30% | NYof 2 |
GET /api/datasets/pkmi-4kfn GET /api/datasets/pkmi-4kfn/quality GET /api/datasets/pkmi-4kfn/related GET /api/columns?dataset=pkmi-4kfn
vendoridpassenger_counttotal_amount+14vendoridpassenger_counttotal_amount+16vendoridpassenger_countcongestion_surcharge+13vendoridpassenger_counttotal_amount+12vendoridpassenger_countcongestion_surcharge+13| 2020-01-01T00:45:58.000 |
| 2020-01-01T00:56:39.000 |
| N |
| 5 |
| 66 |
| 65 |
| 2 |
| 1.28 |
| 20 |
| 0 |
| 0 |
| 2 | 2020-01-01T00:41:38.000 | 2020-01-01T00:52:49.000 | N | 1 | 181 | 228 | 1 | 2.47 | 10.5 | 0.5 | 0.5 |
| 1 | 2020-01-01T00:52:46.000 | 2020-01-01T01:14:21.000 | N | 1 | 129 | 263 | 2 | 6.30 | 21 | 3.25 | 0.5 |
| 1 | 2020-01-01T00:19:57.000 | 2020-01-01T00:30:56.000 | N | 1 | 210 | 150 | 1 | 2.30 | 10 | 0.5 | 0.5 |
| 1 | 2020-01-01T00:52:33.000 | 2020-01-01T01:09:54.000 | N | 1 | 35 | 39 | 1 | 3.00 | 13.5 | 0.5 | 0.5 |
| 2 | 2020-01-01T00:10:18.000 | 2020-01-01T00:22:16.000 | N | 1 | 25 | 61 | 1 | 2.77 | 11 | 0.5 | 0.5 |
| 2 | 2020-01-01T01:03:14.000 | 2020-01-01T01:29:45.000 | N | 1 | 225 | 89 | 1 | 4.98 | 20.5 | 0.5 | 0.5 |
| 2 | 2020-01-01T00:04:11.000 | 2020-01-01T00:09:48.000 | N | 1 | 129 | 129 | 1 | 0.71 | 5.5 | 0.5 | 0.5 |
| 2 | 2020-01-01T00:25:52.000 | 2020-01-01T00:32:16.000 | N | 1 | 129 | 83 | 1 | 0.80 | 5.5 | 0.5 | 0.5 |
Showing 12 of 19 columns. All of them are listed below.
ratecodeid | categorical | — | 30% | 152of 7 |
pulocationid | integer | — | 0% | 747541 |
dolocationid | integer | — | 0% | 744275 |
passenger_count | categorical | — | 30% | 125of 10 |
trip_distance | float | — | 0% | 0.000.901.00 |
fare_amount | float | — | 0% | 867 |
extra | float | — | 0% | 00.51 |
mta_tax | categorical | — | 0% | 0.50-0.5of 5 |
tip_amount | float | — | 0% | 02.751 |
tolls_amount | float | — | 0% | 06.122.29 |
ehail_fee | text | — | 100% | — |
improvement_surcharge | categorical | — | 0% | 0.30-0.3of 3 |
total_amount | float | — | 0% | 8.37.37.8 |
payment_type | categorical | — | 30% | 123of 5 |
trip_type | categorical | — | 30% | 12of 2 |
congestion_surcharge | categorical | — | 30% | 02.752.5of 5 |