From a 500-row sample across 6 columns.
dispatching_base_numdropoff_datetimepickup_datetime+3dispatching_base_numdropoff_datetimepickup_datetime+2dispatching_base_numdropoff_datetimepickup_datetime+2dolocationidpulocationid| dispatching_base_num | pickup_datetime | dropoff_datetime | pulocationid | dolocationid |
|---|---|---|---|---|
| B02871 | 2018-01-03T16:53:36.000 | 2018-01-03T17:08:12.000 | 228 | 14 |
| B02871 | 2018-01-03T16:04:02.000 | 2018-01-03T17:35:42.000 | 210 | 265 |
| B02871 | 2018-01-03T16:01:53.000 | 2018-01-03T16:29:57.000 | 188 | 39 |
| B02871 | 2018-01-03T16:34:42.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dispatching_base_num | text | — | 0% | B02510B02764B02914 |
pickup_datetime | datetime | — | 0% | B02510B02764B02914 |
dropoff_datetime | datetime | — | 0% | B02510B02764B02914 |
pulocationid | integer | — | 14% | 79132161 |
dolocationid | integer | — |
GET /api/datasets/am94-epxh GET /api/datasets/am94-epxh/quality GET /api/datasets/am94-epxh/related GET /api/columns?dataset=am94-epxh
dolocationidpulocationiddropoff_datetimepickup_datetimedolocationidpulocationid| 2018-01-03T16:46:03.000 |
| 39 |
| 155 |
| B02871 | 2018-01-03T16:49:55.000 | 2018-01-03T16:59:33.000 | 155 | 39 |
| B02472 | 2018-01-03T16:37:49.000 | 2018-01-03T16:44:54.000 | — | 265 |
| B02472 | 2018-01-03T16:59:43.000 | 2018-01-03T17:15:09.000 | — | 265 |
| B02472 | 2018-01-03T16:58:40.000 | 2018-01-03T16:58:42.000 | — | 265 |
| B02472 | 2018-01-03T16:01:51.000 | 2018-01-03T16:20:40.000 | — | 265 |
| B01593 | 2018-01-03T16:51:43.000 | 2018-01-03T17:36:47.000 | — | — |
| 8% |
265132138 |
sr_flag | integer | — | 76% | 1of 1 |