From a 500-row sample across 6 columns.
dolocationidsr_flagpulocationid+3dolocationidsr_flagpulocationid+3dolocationidpulocationidpickup_datetime+2dolocationidpulocationidpickup_datetime+2| dispatching_base_num | pickup_datetime | dropoff_datetime | pulocationid | dolocationid | affiliated_base_number |
|---|---|---|---|---|---|
| B00001 | 2020-01-01T00:30:00.000 | 2020-01-01T01:44:00.000 | 264 | 264 | B00001 |
| B00001 | 2020-01-01T00:30:00.000 | 2020-01-01T00:47:00.000 | 264 | 264 | B00001 |
| B00009 | 2020-01-01T00:48:00.000 | 2020-01-01T01:19:00.000 | 264 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dispatching_base_num | text | — | 0% | B02550B01145B00856 |
pickup_datetime | datetime | — | 0% | 2020-01-28T09:00:00.0002020-01-16T10:00:00.0002020-01-24T08:00:00.000 |
dropoff_datetime | datetime | — | 0% | 2020-01-15T10:00:00.0002020-01-17T09:00:00.0002020-02-25T10:00:00.000 |
pulocationid | integer | — | 24% | 264221206 |
GET /api/datasets/m3yx-mvk4 GET /api/datasets/m3yx-mvk4/quality GET /api/datasets/m3yx-mvk4/related GET /api/columns?dataset=m3yx-mvk4
dolocationidpulocationiddolocationidpulocationidpickup_datetimedropoff_datetime| 264 |
| B00009 |
| B00009 | 2020-01-01T00:34:00.000 | 2020-01-01T00:43:00.000 | 264 | 264 | B00009 |
| B00009 | 2020-01-01T00:23:00.000 | 2020-01-01T00:32:00.000 | 264 | 264 | B00009 |
| B00009 | 2020-01-01T00:52:00.000 | 2020-01-01T01:01:00.000 | 264 | 264 | B00009 |
| B00013 | 2020-01-01T00:20:30.000 | 2020-01-01T00:45:52.000 | 264 | 264 | B00013 |
| B00013 | 2020-01-01T00:08:15.000 | 2020-01-01T00:12:03.000 | 264 | 264 | B00013 |
| B00013 | 2020-01-01T00:40:30.000 | 2020-01-01T01:06:23.000 | 264 | 264 | B00013 |
| B00014 | 2020-01-01T00:53:04.000 | 2020-01-01T01:19:13.000 | 264 | 264 | B00014 |
dolocationid | integer | — | 4% | 26426576 |
sr_flag | text | — | 100% | — |
affiliated_base_number | text | — | 0% | B02875B01899B02872 |