From a 500-row sample across 6 columns.
dolocationidsr_flagpulocationid+3dolocationidsr_flagaffiliated_base_number+4dolocationidpulocationiddropoff_datetime+2dolocationidpulocationiddropoff_datetime| dispatching_base_num | pickup_datetime | dropoff_datetime | affiliated_base_number | dolocationid |
|---|---|---|---|---|
| B00009 | 2021-01-01T00:27:00.000 | 2021-01-01T00:44:00.000 | B00009 | — |
| B00009 | 2021-01-01T00:50:00.000 | 2021-01-01T01:07:00.000 | B00009 | — |
| B00013 | 2021-01-01T00:01:00.000 | 2021-01-01T01:51:00.000 | B00013 | — |
| B00037 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dispatching_base_num | text | — | 0% | B00856B01145B03016 |
pickup_datetime | datetime | — | 0% | 2021-03-10T09:00:00.0002021-01-27T09:00:00.0002021-03-17T09:00:00.000 |
dropoff_datetime | datetime | — | 0% | 2021-06-04T21:04:48.0002021-06-25T21:05:26.0002021-06-22T21:05:21.000 |
pulocationid | integer | — | 82% | 22120692 |
GET /api/datasets/a444-au9b GET /api/datasets/a444-au9b/quality GET /api/datasets/a444-au9b/related GET /api/columns?dataset=a444-au9b
dolocationidpulocationiddolocationidpulocationiddropoff_datetimepickup_datetimedolocationidpulocationid| 2021-01-01T00:13:09.000 |
| 2021-01-01T00:21:26.000 |
| B00037 |
| 72 |
| B00037 | 2021-01-01T00:38:31.000 | 2021-01-01T00:53:44.000 | B00037 | 61 |
| B00037 | 2021-01-01T00:59:02.000 | 2021-01-01T01:08:05.000 | B00037 | 71 |
| B00037 | 2021-01-01T00:18:12.000 | 2021-01-01T00:30:04.000 | B00037 | 91 |
| B00037 | 2021-01-01T00:36:15.000 | 2021-01-01T00:45:08.000 | B00037 | 39 |
| B00037 | 2021-01-01T00:55:04.000 | 2021-01-01T01:13:02.000 | B00037 | 37 |
| B00037 | 2021-01-01T00:48:40.000 | 2021-01-01T01:12:02.000 | B00037 | 39 |
dolocationid | integer | — | 15% | 2657626 |
sr_flag | text | — | 100% | — |
affiliated_base_number | text | — | 2% | B03404B02875B02872 |