From a 500-row sample across 7 columns.
sr_flagpickup_datetimepulocationid+3pickup_datetimepulocationiddropoff_datetime+3sr_flagpickup_datetimepulocationid+3pulocationiddolocationid| hvfhs_license_num | dispatching_base_num | pickup_datetime | dropoff_datetime | pulocationid | dolocationid |
|---|---|---|---|---|---|
| HV0003 | B02864 | 2020-01-01T00:45:34.000 | 2020-01-01T01:02:20.000 | 148 | 90 |
| HV0003 | B02682 | 2020-01-01T00:47:50.000 | 2020-01-01T00:53:23.000 | 114 | 79 |
| HV0003 | B02764 | 2020-01-01T00:04:37.000 | 2020-01-01T00:21:49.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
hvfhs_license_num | categorical | — | 0% | HV0003HV0005HV0004of 3 |
dispatching_base_num | text | — | 0% | B02510B02764B02872 |
pickup_datetime | datetime | — | 0% | 2020-03-16T16:55:46.0002020-03-16T16:55:48.0002020-02-29T18:52:56.000 |
dropoff_datetime | datetime | — | 0% | 2020-02-29T18:52:56.0002020-02-21T23:15:02.000 |
GET /api/datasets/yrt9-58g8 GET /api/datasets/yrt9-58g8/quality GET /api/datasets/yrt9-58g8/related GET /api/columns?dataset=yrt9-58g8
pulocationiddolocationidpulocationiddolocationidpickup_datetimedropoff_datetimepickup_datetimedropoff_datetime| 4 |
| 125 |
| HV0003 | B02764 | 2020-01-01T00:26:36.000 | 2020-01-01T00:33:00.000 | 231 | 113 |
| HV0003 | B02764 | 2020-01-01T00:37:49.000 | 2020-01-01T00:46:59.000 | 114 | 144 |
| HV0003 | B02764 | 2020-01-01T00:49:23.000 | 2020-01-01T01:07:26.000 | 144 | 137 |
| HV0003 | B02870 | 2020-01-01T00:21:11.000 | 2020-01-01T00:36:58.000 | 249 | 148 |
| HV0003 | B02870 | 2020-01-01T00:38:28.000 | 2020-01-01T00:42:38.000 | 148 | 4 |
| HV0003 | B02870 | 2020-01-01T00:46:26.000 | 2020-01-01T01:09:55.000 | 79 | 7 |
| HV0003 | B02836 | 2020-01-01T00:15:35.000 | 2020-01-01T00:23:21.000 | 140 | 236 |
2020-03-16T16:55:47.000pulocationid | integer | — | 0% | 617679 |
dolocationid | integer | — | 0% | 2656176 |
sr_flag | integer | — | 95% | 1of 1 |