From a 500-row sample across 20 columns.
tolls_amountstore_and_fwd_flagtrip_type+18tolls_amountstore_and_fwd_flagtrip_type+16tolls_amountstore_and_fwd_flagtrip_type+17| 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 | 2016-01-01T00:29:24.000 | 2016-01-01T00:39:36.000 | N | 1 | -73.928642272949219 | 40.680610656738281 | -73.924278259277344 | 40.698043823242188 | 1 | 1.46 | 8 |
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% | 2016-08-01T17:03:31.0002016-08-28T16:47:33.0002016-06-18T17:07:57.000 |
lpep_dropoff_datetime | datetime | — | 0% | 2016-05-22T00:00:00.0002016-05-09T00:00:00.0002016-05-16T00:00:00.000 |
store_and_fwd_flag | categorical | — | 0% | NYof 2 |
GET /api/datasets/hvrh-b6nb GET /api/datasets/hvrh-b6nb/quality GET /api/datasets/hvrh-b6nb/related GET /api/columns?dataset=hvrh-b6nb
tolls_amountstore_and_fwd_flagtrip_type+16tolls_amountstore_and_fwd_flagtrip_type+16tolls_amountstore_and_fwd_flagpickup_longitude+16tolls_amountstore_and_fwd_flagtrip_distance+12tolls_amountstore_and_fwd_flagtrip_distance+12| 2 | 2016-01-01T00:19:39.000 | 2016-01-01T00:39:18.000 | N | 1 | -73.952674865722656 | 40.723175048828125 | -73.923919677734375 | 40.761379241943359 | 1 | 3.56 | 15.5 |
| 2 | 2016-01-01T00:19:33.000 | 2016-01-01T00:39:48.000 | N | 1 | -73.971611022949219 | 40.676105499267578 | -74.013160705566406 | 40.646072387695313 | 1 | 3.79 | 16.5 |
| 2 | 2016-01-01T00:22:12.000 | 2016-01-01T00:38:32.000 | N | 1 | -73.989501953125 | 40.669578552246094 | -74.000648498535156 | 40.689033508300781 | 1 | 3.01 | 13.5 |
| 2 | 2016-01-01T00:24:01.000 | 2016-01-01T00:39:22.000 | N | 1 | -73.964729309082031 | 40.682853698730469 | -73.940719604492188 | 40.663013458251953 | 1 | 2.55 | 12 |
| 2 | 2016-01-01T00:32:59.000 | 2016-01-01T00:39:35.000 | N | 1 | -73.891143798828125 | 40.746456146240234 | -73.867744445800781 | 40.742111206054688 | 1 | 1.37 | 7 |
| 2 | 2016-01-01T00:34:42.000 | 2016-01-01T00:39:21.000 | N | 1 | -73.896675109863281 | 40.746196746826172 | -73.886192321777344 | 40.745689392089844 | 1 | 0.57 | 5 |
| 2 | 2016-01-01T00:31:23.000 | 2016-01-01T00:39:36.000 | N | 1 | -73.953353881835937 | 40.803558349609375 | -73.949150085449219 | 40.794120788574219 | 1 | 1.01 | 7 |
| 2 | 2016-01-01T00:24:40.000 | 2016-01-01T00:39:52.000 | N | 1 | -73.994064331054688 | 40.702816009521484 | -73.971572875976562 | 40.679725646972656 | 1 | 2.46 | 12 |
| 2 | 2016-01-01T00:28:59.000 | 2016-01-01T00:39:23.000 | N | 1 | -73.914131164550781 | 40.756641387939453 | -73.917549133300781 | 40.739658355712891 | 1 | 1.61 | 9 |
Showing 12 of 20 columns. All of them are listed below.
ratecodeid | categorical | — | 0% | 152of 7 |
pickup_longitude | float | — | 45% | 0-73.84429931640625-73.844291687011719 |
pickup_latitude | float | — | 45% | 040.72135162353515640.721336364746094 |
dropoff_longitude | float | — | 45% | 0-73.952743530273438-73.952766418457031 |
dropoff_latitude | float | — | 45% | 040.80513381958007840.774318695068359 |
passenger_count | categorical | — | 0% | 125of 10 |
trip_distance | float | — | 0% | 0.000.901.00 |
fare_amount | float | — | 0% | 65.56.5 |
extra | float | — | 0% | 00.51 |
mta_tax | categorical | — | 0% | 0.50-0.5of 8 |
tip_amount | float | — | 0% | 012 |
tolls_amount | float | — | 0% | 05.542.54 |
ehail_fee | numeric | — | 100% | — |
improvement_surcharge | float | — | 0% | 0.30-0.3 |
total_amount | float | — | 0% | 6.87.37.8 |
payment_type | categorical | — | 0% | 213of 5 |
trip_type | categorical | — | 0% | 12of 2 |
pulocationid | integer | — | 55% | 74417 |
dolocationid | integer | — | 55% | 42747 |