From a 500-row sample across 7 columns.
pulocationiddropoff_datetimedolocationid+3pulocationiddropoff_datetimedolocationid+3pulocationiddropoff_datetimedolocationid+3pulocationiddolocationid| hvfhs_license_num | dispatching_base_num | pickup_datetime | dropoff_datetime | pulocationid | dolocationid | sr_flag |
|---|---|---|---|---|---|---|
| HV0003 | B02867 | 2019-02-01T00:05:18.000 | 2019-02-01T00:14:57.000 | 245 | 251 | — |
| HV0003 | B02879 | 2019-02-01T00:41:29.000 | 2019-02-01T00:49:39.000 | 216 | 197 | — |
| HV0005 | B02510 |
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 4 |
dispatching_base_num | text | — | 0% | B02510B02764B02872 |
pickup_datetime | datetime | — | 0% | HV0003HV0005HV0004of 4 |
dropoff_datetime | datetime | — | 0% | HV0003HV0005HV0004of 4 |
GET /api/datasets/4p5c-cbgn GET /api/datasets/4p5c-cbgn/quality GET /api/datasets/4p5c-cbgn/related GET /api/columns?dataset=4p5c-cbgn
dropoff_datetimepickup_datetimepulocationiddolocationidpulocationiddolocationid| 2019-02-01T00:51:34.000 |
| 2019-02-01T01:28:29.000 |
| 261 |
| 234 |
| — |
| HV0005 | B02510 | 2019-02-01T00:03:51.000 | 2019-02-01T00:07:16.000 | 87 | 87 | — |
| HV0005 | B02510 | 2019-02-01T00:09:44.000 | 2019-02-01T00:39:56.000 | 87 | 198 | — |
| HV0005 | B02510 | 2019-02-01T00:59:55.000 | 2019-02-01T01:06:28.000 | 198 | 198 | 1 |
| HV0005 | B02510 | 2019-02-01T00:12:06.000 | 2019-02-01T00:42:13.000 | 161 | 148 | — |
| HV0005 | B02510 | 2019-02-01T00:45:35.000 | 2019-02-01T01:14:56.000 | 148 | 21 | — |
| HV0003 | B02867 | 2019-02-01T00:10:48.000 | 2019-02-01T00:20:23.000 | 226 | 260 | — |
| HV0003 | B02867 | 2019-02-01T00:32:32.000 | 2019-02-01T00:40:25.000 | 7 | 223 | — |
pulocationid |
| integer |
| — |
| 0% |
13879132 |
dolocationid | integer | — | 0% | 265132138 |
sr_flag | integer | — | 83% | 1of 1 |